{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Complaint Dashbord","My First Macro"],"not_rendered":{"charts":0,"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":"Complaint Dashbord","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[]
["Key Performance Indicators"]
[null,2018]
[null,"1st Qtr",null,"2nd Qtr",null,"3rd Qtr",null,"4th Qtr",null,"Year"]
["Total House Calls",1226,null,1352,null,1466,null,1537,null,"AVG"]
[]
[]
["Complaints","#","%","#","%","#","%","#","%","%"]
["Arranged appointment not kept",12,{"$f":"B9/B$5","v":9.7879282218597055E-3},12,{"$f":"D9/D$5","v":8.8757396449704144E-3},12,{"$f":"F9/F$5","v":8.1855388813096858E-3},12,{"$f":"H9/H$5","v":7.8074170461938843E-3},{"$f":"(C9+E9+G9+I9)/4","v":8.6641559485834234E-3}]
["Dissatisfaction with Price of service",26,{"$f":"B10/B$5","v":2.1207177814029365E-2},19,{"$f":"D10/D$5","v":1.4053254437869823E-2},20,1.3642564802182811E-2,24,{"$f":"H10/H$5","v":1.5614834092387769E-2},{"$f":"(C10+E10+G10+I10)/4","v":1.6129457786617441E-2}]
["Service not delivered to expected standard",15,1.2234910277324634E-2,15,{"$f":"D11/D$5","v":1.1094674556213017E-2},16,1.0914051841746248E-2,21,{"$f":"H11/H$5","v":1.3662979830839297E-2},1.1976654126530799E-2]
["Repair delayed or not completed",33,2.6916802610114192E-2,17,{"$f":"D12/D$5","v":1.257396449704142E-2},12,8.1855388813096858E-3,18,{"$f":"H12/H$5","v":1.1711125569290826E-2},1.4846857889439031E-2]
["General delay ",13,1.0603588907014683E-2,8,{"$f":"D13/D$5","v":5.9171597633136093E-3},13,8.8676671214188273E-3,16,{"$f":"H13/H$5","v":1.040988939492518E-2},8.9495762966680745E-3]
["Rudeness or attitude",15,1.2234910277324634E-2,19,{"$f":"D14/D$5","v":1.4053254437869823E-2},11,7.5034106412005461E-3,12,{"$f":"H14/H$5","v":7.8074170461938843E-3},1.0399748100647222E-2]
["      Total",{"$f":"SUM(B9:B14)","v":114},9.2985318107667206E-2,{"$f":"SUM(D9:D14)","v":90},{"$f":"D15/D$5","v":6.6568047337278113E-2},{"$f":"SUM(F9:F14)","v":84},5.7298772169167803E-2,{"$f":"SUM(H9:H14)","v":103},{"$f":"H15/H$5","v":6.7013662979830843E-2},7.0966450148485988E-2]

{"sheet":"My First Macro","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"Build your First Ecel VBA Macro"]
[]
[null,null,null,1,"Add the Developer tab to your Excel Ribbon"]
[null,null,null,2,"Set up your Desktop for editing and parts of VBE"]
[null,null,null,3,"The magic of the immediate window"]
[null,null,null,4,"Build a Basic Excel Macro"]
[null,null,null,5,"Record a Macro"]