{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Project Plan","Project Gantt Chart"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Project Gantt Chart","index":1,"reason":"not_a_worksheet"}],"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":"Project Plan","index":0,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,3],[1,18,1,19],[0,11,0,12],[0,13,0,14],[22,0,22,3]]}
[1,null,null,null,null,null,null,null,null,null,null,"Reduction 1",null,"Reduction 2"]
["Task","Normal Time","Actual Time","Reduction","Cost","Task","Start Time","Planned Time","Finish Time","Critical Path","Task","Days","Cost","Days","Cost","Late Start","Late Finish",null,"Gantt Chart Data"]
[]
["Specs",10,10,null,{"$f":"IF(D4=0,0,IF(D4=L4,M4,IF(D4=N4,O4,9999)))","v":0},"Specs",0,{"$f":"C4-D4","v":10},{"$f":"G4+H4","v":10},{"$f":"IF(I4=Q4,\"Critical\",\"\")","v":"Critical"},"Specs",2,50,3,600,{"$f":"Q4-H4","v":0},{"$f":"MIN(P5,P18)","v":10},null,{"$f":"IF(I4=Q4,H4,0)","v":10},{"$f":"IF(I4=Q4,0,H4)","v":0}]
["Excavate",5,5,null,0,"Excavate",{"$f":"I4","v":10},5,15,"","Excavate",1,1000,null,null,17,{"$f":"P6","v":22},null,{"$f":"IF(I5=Q5,H5,0)","v":0},{"$f":"IF(I5=Q5,0,H5)","v":5}]
["Pour",6,6,null,0,"Pour",{"$f":"I5","v":15},6,21,"","Pour",1,900,null,null,22,{"$f":"MIN(P14,P10)","v":28},null,0,6]
["Electric",5,5,null,0,"Electric",{"$f":"I14","v":43},5,48,"","Electric",2,1000,null,null,44,{"$f":"P8","v":49},null,0,5]
["Wallboard",4,4,null,0,"Wallboard",{"$f":"MAX(I9,I14,I7)","v":49},4,53,"Critical","Wallboard",1,100,null,null,49,{"$f":"P11","v":53},null,4,0]
["Plumbing",6,6,null,0,"Plumbing",{"$f":"I14","v":43},6,49,"Critical","Plumbing",2,500,null,null,43,{"$f":"P8","v":49},null,6,0]
["Lifts",4,4,null,0,"Lifts",{"$f":"I6","v":21},4,25,"","Lifts",1,200,2,500,60,{"$f":"H23","v":64},null,0,4]
["Int.Paint",5,5,null,0,"Int.Paint",{"$f":"I8","v":53},5,58,"Critical","Int.Paint",1,350,2,750,53,{"$f":"P15","v":58},null,5,0]
["Millwork",8,8,null,0,"Millwork",{"$f":"I14","v":43},8,51,"","Millwork",2,1000,3,1750,45,{"$f":"P13","v":53},null,0,8]
["Trim",5,5,null,0,"Trim",{"$f":"I12","v":51},5,56,"","Trim",2,450,3,750,53,{"$f":"P15","v":58},null,0,5]
["Frame",15,15,null,0,"Frame",{"$f":"MAX(I6,I20)","v":28},15,43,"Critical","Frame",2,5000,4,7500,28,{"$f":"MIN(P16,P9,P7,P12,P8)","v":43},null,15,0]
["Decorate",6,6,null,0,"Decorate",{"$f":"MAX(I11,I13)","v":58},6,64,"Critical","Decorate",2,500,4,4000,58,{"$f":"H23","v":64},null,6,0]
["Siding",7,7,null,0,"Siding",{"$f":"I14","v":43},7,50,"","Siding",1,500,3,3000,46,{"$f":"P21","v":53},null,0,7]
["Ext.Paint",7,7,null,0,"Ext.Paint",{"$f":"I21","v":54},7,61,"","Ext.Paint",1,250,2,750,57,{"$f":"H23","v":64},null,0,7]
["Blueprint",5,5,null,0,"Blueprint",{"$f":"I4","v":10},5,15,"Critical","Blueprint",2,350,3,600,10,{"$f":"P19","v":15},null,5,0]
["BOM",3,3,null,0,"BOM",{"$f":"I18","v":15},3,18,"Critical","BOM",1,250,2,850,15,{"$f":"P20","v":18},null,3,0]
["Lumber",10,10,null,0,"Lumber",{"$f":"I19","v":18},10,28,"Critical","Lumber",2,500,4,1450,18,{"$f":"P14","v":28},null,10,0]
["Windows",4,4,null,0,"Windows",{"$f":"I16","v":50},4,54,"","Windows",1,500,null,null,53,{"$f":"P17","v":57},null,0,4]
[null,null,null,null,null,"Target",0,54,null,null,null,null,null,null,null,null,null,null,54]
["Lateness cost",null,null,null,{"$f":"1500*MAX(0,H23-54)","v":15000},null,"Actual Finish",{"$f":"MAX(I4:I21)","v":64}]
["Total Project Cost",null,null,null,{"$f":"SUM(E4:E23)","v":15000}]