{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template","Example"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,4,2,7],[5,11,26,18]]}
[]
[null,null,null,null,"Turnback Chart - Planning Department"]
[]
[]
[null,null,null,null,"Turn-back","Count ","cumulative count","cumulative %"]
[null,null,null,null,"a",45444444,{"$f":"SUM(F6)","v":45444444},{"$f":"SUM(G6/$G$12)","v":0.39142127739211585},null,null,null,"(add your turn-backs into column E and then add data to the count field (column F) (The number of times each turn-back happened, or the total cost of their impact)\n\nThe chart will display the data.\n\nNow change the chart title.\n\nUse the Sort Button to automatically sort in order."]
[null,null,null,null,"s",44545555,{"$f":"SUM(F7+G6)","v":89989999},{"$f":"SUM(G7/$G$12)","v":0.77510026002508092}]
[null,null,null,null,6,9898888,{"$f":"SUM(F8+G7)","v":99888887},{"$f":"SUM(G8/$G$12)","v":0.86036118621710311}]
[null,null,null,null,"f",6666666,{"$f":"SUM(F9+G8)","v":106555553},{"$f":"SUM(G9/$G$12)","v":0.91778239532391026}]
[null,null,null,null,"e",4545567,{"$f":"SUM(F10+G9)","v":111101120},{"$f":"SUM(G10/$G$12)","v":0.95693419222149023}]
[null,null,null,null,"d",4444444,{"$f":"SUM(F11+G10)","v":115545564},{"$f":"SUM(G11/$G$12)","v":0.995214998292695}]
[null,null,null,null,5,555544,{"$f":"SUM(F12+G11)","v":116101108},{"$f":"SUM(G12/$G$12)","v":1}]

{"sheet":"Example","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,4,2,7]]}
[]
[null,null,null,null,"Turnback Chart - Planning Department"]
[]
[]
[null,null,null,null,"Turn-back","Count (Lost time $)","cumulative count","cumulative %"]
[null,null,null,null,"Customer changed mind (outside 3 day fixed window)",5400,{"$f":"SUM(F6)","v":5400},{"$f":"SUM(G6/$G$12)","v":0.37113402061855671}]
[null,null,null,null,"Equipment Breakdown",3000,{"$f":"SUM(F7+G6)","v":8400},{"$f":"SUM(G7/$G$12)","v":0.57731958762886593}]
[null,null,null,null,"Poor yield from previous run",2000,{"$f":"SUM(F8+G7)","v":10400},{"$f":"SUM(G8/$G$12)","v":0.71477663230240551}]
[null,null,null,null,"Not enough visibility in demand",1750,{"$f":"SUM(F9+G8)","v":12150},{"$f":"SUM(G9/$G$12)","v":0.83505154639175261}]
[null,null,null,null,"Short on material supply",1500,{"$f":"SUM(F10+G9)","v":13650},{"$f":"SUM(G10/$G$12)","v":0.93814432989690721}]
[null,null,null,null,"Ran out of holding stock",500,{"$f":"SUM(F11+G10)","v":14150},{"$f":"SUM(G11/$G$12)","v":0.97250859106529208}]
[null,null,null,null,"Other",400,{"$f":"SUM(F12+G11)","v":14550},{"$f":"SUM(G12/$G$12)","v":1}]