{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Project Data","Project Planning","Project Tracking","Project Comparison"],"not_rendered":{"charts":2,"defined_names":5,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Project Data","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[6,3,6,5],[7,3,7,5]]}
[]
[]
[null,null,"Project Data"]
[]
[null,null,"General"]
[]
[null,null,"Company Name","<Company Name>",{"$nulls":4},"Legend"]
[null,null,"Project Name","<Project Name>",{"$nulls":4},"Input Field"]
[null,null,"Creation Date","mm/dd/yyyy",{"$nulls":4},"Result Field"]
[null,null,"Last modified","mm/dd/yyyy"]
[]
[]
[null,null,"Skill Type"]
[]
[null,null,"Skill Type I","Skill Type I","Skill Type II","Skill Type II","Skill Type III","Skill Type III"]
[null,null,"Skill Type IV","Skill Type IV","Skill Type V","Skill Type V","Skill Type VI","Skill Type VI"]
[]
[{"$nulls":3},{"$f":"IF($D$15=\"\",\"\",$D$15)","v":"Skill Type I"},{"$f":"IF($F$15=\"\",\"\",$F$15)","v":"Skill Type II"},{"$f":"IF($H$15=\"\",\"\",$H$15)","v":"Skill Type III"},{"$f":"IF($D$16=\"\",\"\",$D$16)","v":"Skill Type IV"},{"$f":"IF($F$16=\"\",\"\",$F$16)","v":"Skill Type V"},{"$f":"IF($H$16=\"\",\"\",$H$16)","v":"Skill Type VI"}]
[null,null,"Rate per Hour",{"v":50,"d":"$50.00"},{"v":75,"d":"$75.00"},{"v":100,"d":"$100.00"},{"v":80,"d":"$80.00"},{"v":120,"d":"$120.00"},{"v":150,"d":"$150.00"}]
[]
[]
[null,null,"Project Type"]
[]
[null,null,"Project Type I","Project Type I","Project Type II","Project Type II","Project Type III","Project Type III"]
[null,null,"Project Type IV","Project Type IV","Project Type V","Project Type V","Project Type VI","Project Type VI"]
[]
[{"$nulls":3},{"$f":"IF($D$24=\"\",\"\",$D$24)","v":"Project Type I"},{"$f":"IF($F$24=\"\",\"\",$F$24)","v":"Project Type II"},{"$f":"IF($H$24=\"\",\"\",$H$24)","v":"Project Type III"},{"$f":"IF($D$25=\"\",\"\",$D$25)","v":"Project Type IV"},{"$f":"IF($F$25=\"\",\"\",$F$25)","v":"Project Type V"},{"$f":"IF($H$25=\"\",\"\",$H$25)","v":"Project Type VI"}]
[null,null,{"$f":"IF($D$15=\"\",\"\",$D$15)","v":"Skill Type I"},{"v":0.15,"d":"15.00%"},{"v":0.15,"d":"15.00%"},{"v":0.05,"d":"5.00%"},{"v":0.2,"d":"20.00%"},{"v":0.25,"d":"25.00%"},{"v":0.05,"d":"5.00%"}]
[null,null,{"$f":"IF($F$15=\"\",\"\",$F$15)","v":"Skill Type II"},{"v":0.05,"d":"5.00%"},{"v":0.2,"d":"20.00%"},{"v":0.1,"d":"10.00%"},{"v":0.15,"d":"15.00%"},{"v":0.1,"d":"10.00%"},{"v":0.1,"d":"10.00%"}]
[null,null,{"$f":"IF($H$15=\"\",\"\",$H$15)","v":"Skill Type III"},{"v":0.25,"d":"25.00%"},{"v":0.05,"d":"5.00%"},{"v":0.2,"d":"20.00%"},{"v":0.15,"d":"15.00%"},{"v":0.15,"d":"15.00%"},{"v":0.25,"d":"25.00%"}]
[null,null,{"$f":"IF($D$16=\"\",\"\",$D$16)","v":"Skill Type IV"},{"v":0.15,"d":"15.00%"},{"v":0.05,"d":"5.00%"},{"v":0.15,"d":"15.00%"},{"v":0.05,"d":"5.00%"},{"v":0.2,"d":"20.00%"},{"v":0.15,"d":"15.00%"}]
[null,null,{"$f":"IF($F$16=\"\",\"\",$F$16)","v":"Skill Type V"},{"v":0.2,"d":"20.00%"},{"v":0.3,"d":"30.00%"},{"v":0.25,"d":"25.00%"},{"v":0.15,"d":"15.00%"},{"v":0.15,"d":"15.00%"},{"v":0.2,"d":"20.00%"}]
[null,null,{"$f":"IF($H$16=\"\",\"\",$H$16)","v":"Skill Type VI"},{"v":0.2,"d":"20.00%"},{"v":0.25,"d":"25.00%"},{"v":0.25,"d":"25.00%"},{"v":0.3,"d":"30.00%"},{"v":0.15,"d":"15.00%"},{"v":0.25,"d":"25.00%"}]
[]
[null,null,"Total",{"$f":"SUM(D28:D33)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(E28:E33)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(F28:F33)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(G28:G33)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(H28:H33)","v":{"v":1,"d":"100.00%"}},{"$f":"SUM(I28:I33)","v":{"v":1,"d":"100.00%"}}]

{"sheet":"Project Planning","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[4,2,4,4]]}
[]
[]
[null,null,"Project Planning"]
[]
[null,null,{"$f":"IF('Project Data'!D8=\"\",\"\",'Project Data'!D8)","v":"<Project Name>"}]
[]
[{"$nulls":3},"Project Type","Estimated Start Date","Estimated Due Date","Estimated Work (Hours)","Duration (Days)","Finished (yes/no)","Overdue (yes/no)"]
[{"$nulls":3},"Project Type I",{"$f":"TODAY()","v":"2023-09-03"},{"$f":"TODAY()+28","v":"2023-10-01"},320,{"$f":"NETWORKDAYS(E8,F8)","v":20},{"$f":"IF(OR('Project Tracking'!F8<=TODAY(),'Project Tracking'!F8=\"\"),\"no\",\"yes\")","v":"yes"},{"$f":"IF(F8<'Project Tracking'!F8,\"yes\",\"no\")","v":"yes"}]
[]
[{"$nulls":3},{"$f":"'Project Data'!D18","v":"Skill Type I"},{"$f":"'Project Data'!E18","v":"Skill Type II"},{"$f":"'Project Data'!F18","v":"Skill Type III"},{"$f":"'Project Data'!G18","v":"Skill Type IV"},{"$f":"'Project Data'!H18","v":"Skill Type V"},{"$f":"'Project Data'!I18","v":"Skill Type VI"},"Total"]
[null,null,"Costs",{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,2,0)*'Project Data'!D19*$G$8","v":{"v":2400,"d":"$2,400.00"}},{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,3,0)*'Project Data'!E19*$G$8","v":{"v":1200,"d":"$1,200.00"}},{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,4,0)*'Project Data'!F19*$G$8","v":{"v":8000,"d":"$8,000.00"}},{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,5,0)*'Project Data'!G19*$G$8","v":{"v":3840,"d":"$3,840.00"}},{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,6,0)*'Project Data'!H19*$G$8","v":{"v":7680,"d":"$7,680.00"}},{"$f":"HLOOKUP($D$8,'Project Data'!$C$27:$I$33,7,0)*'Project Data'!I19*$G$8","v":{"v":9600,"d":"$9,600.00"}},{"$f":"SUM(D11:I11)","v":{"v":32720,"d":"$32,720.00"}}]
[null,null,"Hours",{"$f":"D11/'Project Data'!D19","v":48},{"$f":"E11/'Project Data'!E19","v":16},{"$f":"F11/'Project Data'!F19","v":80},{"$f":"G11/'Project Data'!G19","v":48},{"$f":"H11/'Project Data'!H19","v":64},{"$f":"I11/'Project Data'!I19","v":64},{"$f":"SUM(D12:I12)","v":320}]

{"sheet":"Project Tracking","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[4,2,4,4]]}
[]
[]
[null,null,"Project Tracking"]
[]
[null,null,{"$f":"IF('Project Data'!D8=\"\",\"\",'Project Data'!D8)","v":"<Project Name>"}]
[]
[{"$nulls":3},"Project Type","Actual Start Date","Actual Due Date","Actual Work (Hours)","Duration (Days)"]
[{"$nulls":3},{"$f":"'Project Planning'!D8","v":"Project Type I"},{"$f":"TODAY()+1","v":"2023-09-04"},{"$f":"TODAY()+30","v":"2023-10-03"},{"$f":"SUM(D12:I12)","v":319},{"$f":"IF(F8=\"\",\"\",NETWORKDAYS(E8,F8))","v":22}]
[]
[{"$nulls":3},{"$f":"'Project Data'!D18","v":"Skill Type I"},{"$f":"'Project Data'!E18","v":"Skill Type II"},{"$f":"'Project Data'!F18","v":"Skill Type III"},{"$f":"'Project Data'!G18","v":"Skill Type IV"},{"$f":"'Project Data'!H18","v":"Skill Type V"},{"$f":"'Project Data'!I18","v":"Skill Type VI"},"Total"]
[null,null,"Costs",{"$f":"'Project Data'!D19*D12","v":{"v":1500,"d":"$1,500.00"}},{"$f":"'Project Data'!E19*E12","v":{"v":1125,"d":"$1,125.00"}},{"$f":"'Project Data'!F19*F12","v":{"v":5000,"d":"$5,000.00"}},{"$f":"'Project Data'!G19*G12","v":{"v":7040,"d":"$7,040.00"}},{"$f":"'Project Data'!H19*H12","v":{"v":11280,"d":"$11,280.00"}},{"$f":"'Project Data'!I19*I12","v":{"v":6300,"d":"$6,300.00"}},{"$f":"SUM(D11:I11)","v":{"v":32245,"d":"$32,245.00"}}]
[null,null,"Hours",30,15,50,88,94,42,{"$f":"SUM(D12:I12)","v":319}]

{"sheet":"Project Comparison","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"merged":[[4,2,4,4],[15,2,15,4]]}
[]
[]
[null,null,"Project Target/Actual Comparison"]
[]
[null,null,{"$f":"IF('Project Data'!D8=\"\",\"\",'Project Data'!D8)","v":"<Project Name>"}]
[]
[{"$nulls":3},{"$f":"'Project Data'!D18","v":"Skill Type I"},{"$f":"'Project Data'!E18","v":"Skill Type II"},{"$f":"'Project Data'!F18","v":"Skill Type III"},{"$f":"'Project Data'!G18","v":"Skill Type IV"},{"$f":"'Project Data'!H18","v":"Skill Type V"},{"$f":"'Project Data'!I18","v":"Skill Type VI"},"Total"]
[null,null,"Costs (planned)",{"$f":"'Project Planning'!D11","v":{"v":2400,"d":"$2,400.00"}},{"$f":"'Project Planning'!F11","v":{"v":8000,"d":"$8,000.00"}},{"$f":"'Project Planning'!F11","v":{"v":8000,"d":"$8,000.00"}},{"$f":"'Project Planning'!G11","v":{"v":3840,"d":"$3,840.00"}},{"$f":"'Project Planning'!H11","v":{"v":7680,"d":"$7,680.00"}},{"$f":"'Project Planning'!I11","v":{"v":9600,"d":"$9,600.00"}},{"$f":"SUM(D8:I8)","v":{"v":39520,"d":"$39,520.00"}}]
[null,null,"Costs (actual)",{"$f":"'Project Tracking'!D11","v":{"v":1500,"d":"$1,500.00"}},{"$f":"'Project Tracking'!E11","v":{"v":1125,"d":"$1,125.00"}},{"$f":"'Project Tracking'!F11","v":{"v":5000,"d":"$5,000.00"}},{"$f":"'Project Tracking'!G11","v":{"v":7040,"d":"$7,040.00"}},{"$f":"'Project Tracking'!H11","v":{"v":11280,"d":"$11,280.00"}},{"$f":"'Project Tracking'!I11","v":{"v":6300,"d":"$6,300.00"}},{"$f":"SUM(D9:I9)","v":{"v":32245,"d":"$32,245.00"}}]
[]
[{"$nulls":3},{"$f":"'Project Data'!D18","v":"Skill Type I"},{"$f":"'Project Data'!E18","v":"Skill Type II"},{"$f":"'Project Data'!F18","v":"Skill Type III"},{"$f":"'Project Data'!G18","v":"Skill Type IV"},{"$f":"'Project Data'!H18","v":"Skill Type V"},{"$f":"'Project Data'!I18","v":"Skill Type VI"},"Total"]
[null,null,"Hours (planned)",{"$f":"'Project Planning'!D12","v":48},{"$f":"'Project Planning'!F12","v":80},{"$f":"'Project Planning'!F12","v":80},{"$f":"'Project Planning'!G12","v":48},{"$f":"'Project Planning'!H12","v":64},{"$f":"'Project Planning'!I12","v":64},{"$f":"SUM(D12:I12)","v":384}]
[null,null,"Hours (actual)",{"$f":"'Project Tracking'!D12","v":30},{"$f":"'Project Tracking'!E12","v":15},{"$f":"'Project Tracking'!F12","v":50},{"$f":"'Project Tracking'!G12","v":88},{"$f":"'Project Tracking'!H12","v":94},{"$f":"'Project Tracking'!I12","v":42},{"$f":"SUM(D13:I13)","v":319}]
[]
[]
[null,null,"Charts"]