{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Instructions","Example","Analyser","Data"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Example","index":2,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,10,22,10],[21,11,21,13],[21,16,21,17],[22,11,22,13],[22,16,22,17],[2,2,2,18],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,4,17],[3,18,4,18]]}
[]
[]
[null,null,"Telephone Bill Analyser"]
[null,null,"Number","Detail or Line Type","Service\nFee","Local",null,"National",null,"Overseas",null,"13/1300",null,"Mobile",null,"Special",null,"Other\nFees","Total"]
[null,null,null,null,null,"Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost"]
[null,null,"02 91250555","Business Line Rotary",36.36,170,{"$f":"F6*0.2","v":34},42,{"$f":"H6*0.7272","v":30.542399999999997},7,9.23,42,{"$f":"L6*0.3182","v":13.3644},38,100.12,1,{"$f":"0.3454*P6","v":0.34539999999999998},3.22,{"$f":"IF(E6+G6+I6+K6+M6+O6+Q6+R6>0,E6+G6+I6+K6+M6+O6+Q6+R6,\" \")","v":227.18220000000002}]
[null,null,"02 91250516","Business Line Rotary",36.36,106,{"$f":"F7*0.2","v":21.200000000000003},31,22.543199999999999,1,1.34,26,{"$f":"L7*0.3182","v":8.2731999999999992},25,50.22,3,{"$f":"0.3454*P7","v":1.0362},3.22,{"$f":"IF(E7+G7+I7+K7+M7+O7+Q7+R7>0,E7+G7+I7+K7+M7+O7+Q7+R7,\" \")","v":144.1926}]
[null,null,"02 91250520","Business Line Rotary",36.36,87,17.400000000000002,23,16.7256,null,null,11,3.5002,11,12.01,1,0.34539999999999998,3.22,89.561200000000014]
[null,null,"02 91250563","Business Line Rotary",36.36,62,12.4,11,7.9991999999999992,null,null,4,1.2727999999999999,6,2.08,null,null,3.22,63.331999999999994]
[null,null,"02 91250564","Business Line Rotary",36.36,24,4.8000000000000007,7,5.0903999999999998,null,null,null,null,2,2.5299999999999998,null,null,3.22,52.000399999999999]
[null,null,"02 91250500","Fax Line",36.36,89,17.8,17,{"$f":"H11*0.7272","v":12.362399999999999},null,null,null,null,null,null,null,null,null,66.52239999999999]
[null,null,null,"ADSL2 300Gb",81.819999999999993,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E12+G12+I12+K12+M12+O12+Q12+R12>0,E12+G12+I12+K12+M12+O12+Q12+R12,\" \")","v":81.819999999999993}]
[null,null,null,"Paper Bill Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(E13+G13+I13+K13+M13+O13+Q13+R13>0,E13+G13+I13+K13+M13+O13+Q13+R13,\" \")","v":2}]
[null,null,null,"Credit Card Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,8.01,{"$f":"IF(E14+G14+I14+K14+M14+O14+Q14+R14>0,E14+G14+I14+K14+M14+O14+Q14+R14,\" \")","v":8.01}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"You can enter"]
[null,null,null,"Sub Totals:",{"$f":"IF(SUM(E6:E17)>0,SUM(E6:E17),\" \")","v":299.98},538,107.60000000000001,131,95.263199999999998,8,10.57,83,26.410599999999999,82,166.96,5,1.7269999999999999,26.11,734.62079999999992,null,null,null,"your data here"]
[]
[null,null,null,null,"Average call costs:",null,{"$f":"IF(ISERROR(G18/F18),\"\",G18/F18)","v":0.2},null,{"$f":"IF(ISERROR(I18/H18),\"\",I18/H18)","v":0.72719999999999996},null,{"$f":"IF(ISERROR(K18/J18),\"\",K18/J18)","v":1.32125},null,{"$f":"IF(ISERROR(M18/L18),\"\",M18/L18)","v":0.31819999999999998},null,{"$f":"IF(ISERROR(O18/N18),\"\",O18/N18)","v":2.0360975609756098},null,{"$f":"IF(ISERROR(Q18/P18),\"\",Q18/P18)","v":0.34539999999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mobile\nCalls:","Total Minutes:",null,null,317,null,"GST:",null,{"$f":"IF(ISERROR(S18*0.1),\"\",S18*0.1)","v":73.46208}]
[null,null,null,null,null,null,null,null,null,null,null,"Cost per Minute:",null,null,{"$f":"IF(ISERROR(O18/O22),\"\",O18/O22)","v":0.52668769716088326},null,"Bill Total:",null,{"$f":"IF(ISERROR(S18+S22),\"\",S18+S22)","v":808.08287999999993}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copyright Talking Business co. Ph:1300 666 765"]

{"sheet":"Analyser","index":3,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,10,22,10],[21,11,21,13],[21,16,21,17],[22,11,22,13],[22,16,22,17],[2,2,2,18],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,4,17],[3,18,4,18]]}
[]
[]
[null,null,"Telephone Bill Analyser"]
[null,null,"Number","Detail or Line Type","Service\nFee","Local",null,"National",null,"Overseas",null,"13/1300",null,"Mobile",null,"Special",null,"Other\nFees","Total"]
[null,null,null,null,null,"Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost","Calls","Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E6+G6+I6+K6+M6+O6+Q6+R6>0,E6+G6+I6+K6+M6+O6+Q6+R6,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E7+G7+I7+K7+M7+O7+Q7+R7>0,E7+G7+I7+K7+M7+O7+Q7+R7,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Sub Totals:",{"$f":"IF(SUM(E6:E17)>0,SUM(E6:E17),\" \")","v":" "}," ",{"$f":"IF(SUM(G6:G17)>0,SUM(G6:G17),\" \")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[]
[null,null,null,null,"Average call costs:",null,{"$f":"IF(ISERROR(G18/F18),\"\",G18/F18)","v":""},null,{"$f":"IF(ISERROR(I18/H18),\"\",I18/H18)","v":""},null,{"$f":"IF(ISERROR(K18/J18),\"\",K18/J18)","v":""},null,{"$f":"IF(ISERROR(M18/L18),\"\",M18/L18)","v":""},null,{"$f":"IF(ISERROR(O18/N18),\"\",O18/N18)","v":""},null,{"$f":"IF(ISERROR(Q18/P18),\"\",Q18/P18)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mobile\nCalls:","Total Minutes:",null,null,null,null,"GST:",null,{"$f":"IF(ISERROR(S18*0.1),\"\",S18*0.1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Cost per Minute:",null,null,{"$f":"IF(ISERROR(O18/O22),\"\",O18/O22)","v":""},null,"Bill Total:",null,{"$f":"IF(ISERROR(S18+S22),\"\",S18+S22)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copyright Talking Business co. Ph:1300 666 765"]

{"sheet":"Data","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Business Line"]
["Business Line Rotary"]
["Fax Line"]
["Private Line"]
["ADSL2"]
["OnRamp-2"]
["Paper Bill Fee"]
["Credit Card Fee"]