{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Reporting","Task list","Project Tracker ","Project Budget"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Reporting","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Task list","index":1,"n_rows":505,"n_cols":9,"rows_kept":505,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,1,3,1]]}
[]
[null,"Project Name","<insert project name here>"]
[null,"Current Task Statuses","Not Started","In Progress","Complete","Overdue"]
[null,null,{"$f":"COUNTIF($F$12:$F$505,C3)/COUNTIF($F$12:$F$505,\"*\")","v":0.36363636363636365},{"$f":"COUNTIF($F$12:$F$505,D3)/COUNTIF($F$12:$F$505,\"*\")","v":0.18181818181818182},{"$f":"COUNTIF($F$12:$F$505,E3)/COUNTIF($F$12:$F$505,\"*\")","v":0.36363636363636365},{"$f":"COUNTIF($F$12:$F$505,F3)/COUNTIF($F$12:$F$505,\"*\")","v":9.0909090909090912E-2}]
[]
[null,null,"Budget",{"$f":"C8-D8","v":0}]
[null,null,"Planned","Actual"]
[null,null,{"$f":"SUM($G$11:$G$505)","v":0},{"$f":"SUM($H$11:$H$505)","v":0}]
[]
["Tasks","Assigned To","Start","End","Days","Status","Planned Cost","Actual Cost","Notes"]
["Preferential Procurement ",null,null,null,{"$f":"IF(C11=\"\",\"\",IF(D11=\"\",\"\",D11-C11))","v":""}]
["Compile a compile a comprehensive list of suppliers ",null,"2021-02-01","2021-02-01",{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",\"\",D12-C12))","v":0},"Complete"]
["Develop a new procurement capturing system ",null,"2021-02-02","2021-02-03",{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",\"\",D13-C13))","v":1},"Complete"]
[null,null,"2021-02-03","2021-02-07",{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",\"\",D14-C14))","v":4},"Overdue"]
[null,null,"2016-02-04","2016-02-10",{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",\"\",D15-C15))","v":6},"In Progress"]
[null,null,"2021-02-11","2021-02-14",3,"Not Started"]
[null,null,"2016-02-03","2016-02-14",11,"Complete"]
[null,null,"2016-02-03","2016-02-21",18,"In Progress"]
[null,null,"2016-02-21","2016-02-28",7,"Not started"]
[null,null,"2016-03-01","2016-03-01",0,"Not started"]
[null,null,"2016-02-03","2016-02-28",25,"Complete"]
[null,null,"2016-03-07","2016-03-10",3,"Not started"]
["Skills Development ",null,null,null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
["Management Control ",null,null,null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
["Skills Development ",null,null,null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C78=\"\",\"\",IF(D78=\"\",\"\",D78-C78))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C142=\"\",\"\",IF(D142=\"\",\"\",D142-C142))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C206=\"\",\"\",IF(D206=\"\",\"\",D206-C206))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C270=\"\",\"\",IF(D270=\"\",\"\",D270-C270))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C334=\"\",\"\",IF(D334=\"\",\"\",D334-C334))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C398=\"\",\"\",IF(D398=\"\",\"\",D398-C398))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},{"$f":"IF(C462=\"\",\"\",IF(D462=\"\",\"\",D462-C462))","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]

{"sheet":"Project Tracker ","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,4],[42,19,42,38]]}
["Gantt Chart Template"]
[]
["Project Name:"]
[]
[]
[]
[null,"Task Name","Start  (Date)","End  (Date)","Duration (Days)"]
[]
[null,"Sample Task 1","2019-06-01","2019-06-07",{"$f":"D9-C9","v":6}]
[null,"Sample Task 2","2019-06-02","2019-06-08",{"$f":"D10-C10","v":6}]
[null,"Sample Task 3","2019-06-03","2019-06-06",3]
[null,"Sample Task 4","2019-06-06","2019-06-08",2]
[null,"Sample Task 5","2019-06-06","2019-06-14",8]
[null,"Sample Task 6","2019-06-08","2019-06-13",5]
[null,"Sample Task 7","2019-06-09","2019-06-17",8]
[null,"Sample Task 8","2019-06-10","2019-06-11",1]
[null,"Sample Task 9","2019-06-13","2019-06-14",1]
[null,"Sample Task 10","2019-06-14","2019-06-20",6]
[null,"Sample Task 11","2019-06-15","2019-06-16",1]
[null,"Sample Task 12","2019-06-16","2019-06-21",5]
[null,"Sample Task 13","2019-06-17","2019-06-20",3]
[null,"Sample Task 14","2019-06-20","2019-06-21",1]
[null,"Sample Task 15","2019-06-21","2019-06-26",5]

{"sheet":"Project Budget","index":3,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,10,7,10],[18,1,18,2],[33,1,33,14]]}
["Project Budget Template"]
[]
["Project Name:","Alpha Omega"]
["Department:","Marketing"]
["Supervisor Name:","Oliver Jones"]
[]
[{"$nulls":4},"Labor",null,"Materials",null,null,null,"Fixed",null,null,null,"BALANCE"]
[null,null,null,"Planned Hours","Actual Hours","$/HR","UNITS","$/UNITS","Travel","Equipment",null,"Misc.","BUDGETED","ACTUAL","UNDER/OVER"]
["WBS","Project Tasks","Assigned To:",{"$nulls":9},{"$f":"SUM(M10:M18)","v":700},{"$f":"SUM(N10:N18)","v":1590},{"$f":"M9-N9","v":-890}]
[1,"Task","Dave Johnson",8,8,30,100,5,null,null,50,null,300,{"$f":"(E10*F10)+(G10*H10)+I10+J10+K10+L10","v":790},{"$f":"M10-N10","v":-490}]
[2,"Task","Sarah Goldman",8,8,15,null,null,30,null,100,null,300,250,50]
[3,"Task","Melissa Shaw",null,null,null,50,11,{"$nulls":4},100,550,-450]
[3.1,"       SubTask ",{"$nulls":10},{"$f":"E13*F13+G13*H13+K13","v":0},0,0]
[3.2,"       SubTask ",{"$nulls":10},0,0,0]
[3.3,"       SubTask ",{"$nulls":10},0,0,0]
[3.4,"       SubTask ",{"$nulls":10},0,0,0]
[4,"Task",{"$nulls":10},0,0,0]
[5,"Task",{"$nulls":10},0,0,0]
[null,"SUBTOTAL",null,null,null,{"$f":"(E10*F10)+(E11*F11)+(E12*F12)+(E13*F13)+(E14*F14)+(E15*F15)+(E16*F16)+(E17*F17)+(E18*F18)","v":360},null,{"$f":"(G10*H10)+(G11*H11)+(G12*H12)+(G13*H13)+(G14*H14)+(G15*H15)+(G16*H16)+(G17*H17)+(G18*H18)","v":1050},{"$f":"SUM(I10:I18)","v":30},null,{"$f":"SUM(K10:K18)","v":150},{"$f":"SUM(L10:L18)","v":0},{"$f":"SUM(M10:M18)","v":700},{"$f":"SUM(F19:L19)","v":1590},{"$f":"M19-N19","v":-890}]