{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Project Type Data","Country Data","Data Validation","How to use it","Area Model","Point Model","ROI Chart Area (Project)","ROI Chart Point (Project)"],"not_rendered":{"charts":2,"images":4,"macros":0,"external_links":0,"defined_names":4,"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":"Project Type Data","index":0,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,null,"SitePrint Productivity (m²)",null,null,"SitePrint Productivity (ft²)",null,null,"Manual Productivity (m²)",null,null,"Manual Productivity (ft²)",null,null,"SitePrint Productivity (points)",null,null,"Manual Productivity (points)"]
["Project Type","Average $/sqft","High Density","Medium Density","Low Density","High Density","Medium Density","Low Density","High Density","Medium Density","Low Density","High Density","Medium Density","Low Density","High Density","Medium Density","Low Density","High Density","Medium Density","Low Density"]
["Hospitals and Other Health Treatment",531.57175498792367,{"$f":"+ROUNDUP(D3*0.75,-1)","v":230},300,{"$f":"+ROUNDUP(D3*1.25,-1)","v":380},{"$f":"+ROUNDUP(C3*10,-1)","v":2300},{"$f":"+ROUNDUP(D3*10,-1)","v":3000},{"$f":"+ROUNDUP(E3*10,-1)","v":3800},{"$f":"ROUNDUP(C3/8/5,0)*5","v":30},{"$f":"ROUNDUP(D3/8/5,0)*5","v":40},{"$f":"ROUNDUP(E3/8/5,0)*5","v":50},{"$f":"ROUNDUP(I3*10/5,0)*5","v":300},{"$f":"ROUNDUP(J3*10/5,0)*5","v":400},{"$f":"ROUNDUP(K3*10/5,0)*5","v":500},100,200,300,20,40,80]
["Hotels",278.56305669635714,{"$f":"+ROUNDUP(D4*0.75,-1)","v":230},300,{"$f":"+ROUNDUP(D4*1.25,-1)","v":380},{"$f":"+ROUNDUP(C4*10,-1)","v":2300},{"$f":"+ROUNDUP(D4*10,-1)","v":3000},{"$f":"+ROUNDUP(E4*10,-1)","v":3800},30,{"$f":"ROUNDUP(D4/8/5,0)*5","v":40},50,{"$f":"ROUNDUP(I4*10/5,0)*5","v":300},400,500,100,200,300,20,40,80]
["Manufacturing Plants",645.02739922259434,300,400,500,3000,4000,{"$f":"+ROUNDUP(E5*10,-1)","v":5000},40,50,65,400,500,650,100,200,300,20,40,80]
["Office and Bank Buildings",433.43917862971858,270,350,440,2700,3500,4400,35,45,55,350,450,550,100,200,300,20,40,80]
["Parking Garages",111.20508528532839,380,500,630,3800,5000,6300,50,65,80,500,650,800,100,200,300,20,40,80]
["Schools, Libraries, and Labs",553.51906065065771,230,300,380,2300,3000,3800,30,40,50,300,400,500,100,200,300,20,40,80]
["Warehouses",83.909112084904379,300,400,500,3000,4000,5000,40,50,65,400,500,650,100,200,300,20,40,80]
["Dormitories",392.37829089176438,230,300,380,2300,3000,3800,30,40,50,300,400,500,100,200,300,20,40,80]
["Residential Apartments",164.70261490890655,230,300,380,2300,3000,3800,30,40,50,300,400,500,100,200,300,20,40,80]
["Other",249.16274646687214,230,300,380,2300,3000,3800,30,40,50,300,400,500,100,200,300,20,40,80]

{"sheet":"Country Data","index":1,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Country","Currency","Metric","Price per Area","Price per Point","SitePrint Hardware Price","Average Hourly Rate","Conversion 1 USD to local currency","Robot Capping","Project Capping","Metric",{"$nulls":10},"Country","Currency","Metric","Price per Area","Average Hourly Rate","Maximum Productivity (Assuming two professionals)"]
["Australia","AUD","m²",2.5,2.5,87950,65,1.45,25000,25000,"m",null,null,null,{"$f":"+(G2*2)/Z2","v":2},null,null,null,"Australia",52,null,"Australia","AUD","m²",2.5,65,{"$f":"2*Z2/Y2","v":52}]
["Austria","EUR","m²",1.3,1.3,49500,55,0.9,13000,15000,"m",null,null,null,2,null,null,null,"Austria",84.615384615384613,null,"Austria","EUR","m²",1.3,55,{"$f":"2*Z3/Y3","v":84.615384615384613}]
["Belgium","EUR","m²",1.3,1.3,49500,35,0.9,13000,15000,"m",null,null,null,2,null,null,null,"Belgium",53.846153846153847,null,"Belgium","EUR","m²",1.3,35,53.846153846153847]
["Canada","CAD","m²",2.5,2.5,71500,110,1.35,16000,25000,"m",null,null,null,2,null,null,null,"Canada",88,null,"Canada","CAD","m²",2.5,110,88]
["Denmark","DKK","m²",13,13,350000,385,6.75,130000,130000,"m",null,null,null,2,null,null,null,"Denmark",59.230769230769234,null,"Denmark","DKK","m²",13,385,59.230769230769234]
["France","EUR","m²",1.3,1.3,49500,45,0.9,13000,15000,"m",null,null,null,2,null,null,null,"France",69.230769230769226,null,"France","EUR","m²",1.3,45,69.230769230769226]
["Germany","EUR","m²",1.3,1.3,49500,55,0.9,13000,15000,"m",null,null,null,2,null,null,null,"Germany",84.615384615384613,null,"Germany","EUR","m²",1.3,55,84.615384615384613]
["Ireland","EUR","m²",1.3,1.3,49500,45,0.9,13000,13000,"m",null,null,null,2,null,null,null,"Ireland",69.230769230769226,null,"Ireland","EUR","m²",1.3,45,69.230769230769226]
["Luxembourg","EUR","m²",1.3,1.3,49500,55,0.9,13000,15000,"m",null,null,null,2,null,null,null,"Luxembourg",84.615384615384613,null,"Luxembourg","EUR","m²",1.3,55,84.615384615384613]
["Netherland","EUR","m²",1.3,1.3,49500,45,0.9,13000,15000,"m",null,null,null,2,null,null,null,"Netherland",69.230769230769226,null,"Netherland","EUR","m²",1.3,45,69.230769230769226]
["New Zealand","NZD","m²",2.7,2.7,92950,75,1.59,27000,27000,"m",null,null,null,2,null,null,null,"New Zealand",55.55555555555555,null,"New Zealand","NZD","m²",2.7,75,55.55555555555555]
["Norway","NOK","m²",17,17,570000,485,10.55,170000,170000,"m",null,null,null,2,null,null,null,"Norway",57.058823529411768,null,"Norway","NOK","m²",17,485,57.058823529411768]
["Poland","EUR","m²",1.2,1.2,49500,45,0.9,12000,15000,"m",null,null,null,2,null,null,null,"Poland",75,null,"Poland","EUR","m²",1.2,45,75]
["Portugal","EUR","m²",1.2,1.2,49500,45,0.9,12000,15000,"m",null,null,null,2,null,null,null,"Portugal",75,null,"Portugal","EUR","m²",1.2,45,75]
["Switzerland","CHF","m²",1.5,1.5,49500,75,0.85,15000,15000,"m",null,null,null,2,null,null,null,"Schwitzerland",100,null,"Schwitzerland","CHF","m²",1.5,75,100]
["Spain","EUR","m²",1.2,1.2,49500,45,0.9,12000,15000,"m",null,null,null,2,null,null,null,"Spain",75,null,"Spain","EUR","m²",1.2,45,75]
["Sweden","SEK","m²",17,17,570000,430,10.26,170000,170000,"m",null,null,null,2,null,null,null,"Sweden",50.588235294117645,null,"Sweden","SEK","m²",17,430,50.588235294117645]
["United Kingdom","GBP","m²",1.1000000000000001,1.1000000000000001,44000,45,0.75,11000,11000,"m",null,null,null,2,null,null,null,"United Kingdom",81.818181818181813,null,"United Kingdom","GBP","m²",1.1000000000000001,45,81.818181818181813]
["United States","USD","ft²",0.2,2,54950,75,1,12000,20000,"ft",null,null,null,2,null,null,null,"United States",70.093457943925245,null,"United States","USD","ft²",0.2,75,750]

{"sheet":"Data Validation","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Point Only",null,null,null,{"$f":"+IF('Area Model'!E5=\"United States\",\"ft/h\",\"m/h\")","v":"ft/h"},null,"m/h"]
["Linework",null,null,null,{"$f":"+IF('Area Model'!E5=\"United States\",\"ft²/h\",\"m²/h\")","v":"ft²/h"},null,"m²/h"]
[{"$nulls":6},"ft/h"]
["General Contractor (Self-Perform)",{"$nulls":5},"ft²/h"]
["General Contractor (Non Self-Perform)"]
["Specialty Trade - Interior Contractor"]
["Specialty Trade - MEP/FP Contractor"]
["Specialty Trade - Concrete Contractor"]
["Geospatial Service Provider"]
["Industrial/Material Handling"]
["Other"]
[]
["High Density"]
["Medium Density"]
["Low Density"]
["Other"]
[]
["MRSP"]
["Other"]
[]
["None (0%)",0]
["Low (0.1 %)",1E-3]
["Medium (0.5%)",5.0000000000000001E-3]
["High (1%)",0.01]
[]
["MSRP"]
["Custom price"]

{"sheet":"How to use it","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Guide to Using the HP SitePrint ROI Tool"]

{"sheet":"Area Model","index":4,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"HP SitePrint ROI Tool - Area Model"]
[null,null,"Project Details",{"$nulls":4},"Pricing and Initial Investment"]
[]
[null,null,"Country","Select country","United States",null,null,"HP SitePrint Robot Pricing",null,{"$f":"IF(J15=\"Custom Price\",M5,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!F:F))","v":54950},{"$f":"_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,{"$f":"+K5","v":"USD"}]
[]
[null,null,"Expected Layout Duration","(Input duration) →",1,"months",null,"HP SitePrint Usage Fee",null,{"$f":"IF(J15=\"Custom Price\",M7,_xlfn.XLOOKUP('Area Model'!E5,'Country Data'!A:A,'Country Data'!D:D))","v":0.2},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C))","v":"USD/ft²"},null,null,{"$f":"+K7","v":"USD/ft²"}]
[]
[null,null,"Project Size","(Input size) →",30000,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C)","v":"ft²"},null,"Robot Capping",null,{"$f":"IF(J15=\"Custom Price\",M9,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!I:I))","v":12000},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"Month\")","v":"USD/Month"},null,null,{"$f":"+K9","v":"USD/Month"}]
[]
[null,null,"Nº of SitePrint Robots","(Input nº of robots) →",1,"robots",null,"Project capping",null,{"$f":"IF(J15=\"Custom Price\",M11,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!J:J))","v":20000},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"Month\")","v":"USD/Month"},null,null,{"$f":"+K11","v":"USD/Month"}]
[]
[null,null,"Total Station Cost","(Input cost) →",26050,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Initial investment",null,{"$f":"+J5*E11+E13*E11","v":81000},{"$f":"IF(N36=\"N/A\",\"\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B))","v":"USD"}]
[]
[null,null,"Printed distance","(Input distance) →",2700,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!K:K)","v":"ft"},null,null,null,"MSRP"]
[null,null,"Project Layout expenses"]
[]
[{"$nulls":4},"Traditional",{"$nulls":4},"SitePrint"]
[]
[null,null,"Crew Size","(Input crew size) →",2,"people",null,null,"(Input crew size) →",1,"people"]
[]
[null,null,"Hourly cost of layout professionals","(Input cost) →",75,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,"(Input cost) →",75,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Productivitity","(Input Productivity) →",330,"ft²/h",null,null,"(Input Productivity) →",3600,{"$f":"+F24","v":"ft²/h"},null,"Productivity Increase",{"$f":"IFERROR(CONCATENATE(ROUND((J24/E24),1),\"x\"),\"\")","v":"10.9x"},{"$f":"+IF(N24=\"\",\"\",IF((J24/E24)<=1,\"\",\"Faster\"))","v":"Faster"}]
[]
[null,null,"Layout Duration",null,{"$f":"+E27/8","v":11.363636363636363},"days",null,null,null,{"$f":"+J27/8","v":1.0416666666666667},"days",null,"Layout time reduction",{"$f":"+E26-J26","v":10.321969696969697},"days"]
[{"$nulls":4},{"$f":"IF(OR(F24=\"m²/h\", F24=\"ft²/h\"), IFERROR(E9/E24,0), IF(OR(F24=\"m/h\", F24=\"ft/h\"), IFERROR(E15/E24,0), \"\"))","v":90.909090909090907},"hours",null,null,null,{"$f":"IF(OR(K24=\"m²/h\", K24=\"ft²/h\"), IFERROR(E9/J24,0), IF(OR(F24=\"m/h\", F24=\"ft/h\"), IFERROR(E15/J24,0), \"\"))","v":8.3333333333333339},"hours",null,null,{"$f":"+E27-J27","v":82.575757575757578},"hours"]
[{"$nulls":4},{"$f":"+E27*E20","v":181.81818181818181},"manhours",null,null,null,{"$f":"+J27*J20","v":8.3333333333333339},"manhours",null,null,173.48484848484847,"manhours"]
[]
[null,null,"Labor Costs",null,{"$f":"+E27*E20*E22","v":13636.363636363636},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,null,{"$f":"+J27*J20*J22","v":625},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Labor Cost Reduction",{"$f":"+E30-J30","v":13011.363636363636},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"SitePrint Usage Fee",{"$nulls":6},{"$f":"+E9*J7","v":6000},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Robot Capping Discount",{"$nulls":6},{"$f":"IFERROR(IF(J32/E11/E7<J9,0,((J9-(J32/E11/E7))*E7*E11)),0)","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Project Capping Discount",{"$nulls":6},{"$f":"IFERROR(IF((J32+J33)/E7<J11,0,J11*(E7)-(J32+J33)),0)","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"SitePrint Usage Fee After Cappings",{"$nulls":6},{"$f":"+J32+J33+J34","v":6000},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Layout Operational Expenses (Excluding D&A)",null,{"$f":"+E30+E35","v":13636.363636363636},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,null,{"$f":"+J35+J30","v":6625},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Layout cost reduction",{"$f":"+E37-J37","v":7011.363636363636},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Layout cost per area",null,{"$f":"IFERROR(E37/E9,0)","v":0.45454545454545453},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C))","v":"USD/ft²"},null,null,null,{"$f":"IFERROR(J37/E9,0)","v":0.22083333333333333},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C))","v":"USD/ft²"},null,{"$f":"+CONCATENATE(\"Layout cost reduction/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C))","v":"Layout cost reduction/ft²"},{"$f":"+E39-J39","v":0.2337121212121212},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Layout cost per distance",null,{"$f":"IF(E15=\"\",\"\",IFERROR(E37/E15,0))","v":5.0505050505050502},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!K:K))","v":"USD/ft"},null,null,null,{"$f":"IF(E15=\"\",\"\",IFERROR(J37/E15,0))","v":2.4537037037037037},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!K:K))","v":"USD/ft"},null,{"$f":"+CONCATENATE(\"Layout cost reduction/\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!K:K))","v":"Layout cost reduction/ft"},{"$f":"IFERROR(E41-J41,0)","v":2.5968013468013464},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Return on investment"]
[]
[null,null,"Iceberg Value"]
[null,null,"Expected savings from Layout Labor Cost Reduction","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Expected savings from Schedule Reduction","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Expected savings from Rework","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Total Additional Savings",null,{"$f":"+E46+E47+E48","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Payback Period",null,{"$f":"IFERROR(IF((J5*E11+E13*E11)/(N39+E49/E9)<=0,\"N/A\",(J5*E11+E13*E11)/(N39+E49/E9)),\"\")","v":346580.226904376},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!C:C)","v":"ft²"}]
[null,null,"Area threshold required to break even on the investment",null,{"$f":"IFERROR(IF(E51=\"N/A\",\"N/A\",E51/E9),\"\")","v":11.552674230145866},"projects"]
[{"$nulls":4},{"$f":"IFERROR(IF(E51=\"N/A\",\"N/A\",E52*E7),\"\")","v":11.552674230145866},"months"]
[]
[null,null,"Notes"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null,"  "]

{"sheet":"Point Model","index":5,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"HP SitePrint ROI Tool - Point Model"]
[null,null,"Project Details",{"$nulls":4},"Pricing and Initial Investment"]
[]
[null,null,"Country","Select country","United States",null,null,"HP SitePrint Robot Pricing",null,{"$f":"IF(J15=\"Custom Price\",M5,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!F:F))","v":54950},{"$f":"_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,{"$f":"+K5","v":"USD"}]
[]
[null,null,"Expected Layout Duration","(Input duration) →",null,"months",null,"HP SitePrint Usage Fee",null,{"$f":"IF(J15=\"Custom Price\",M7,_xlfn.XLOOKUP('Point Model'!E5,'Country Data'!A:A,'Country Data'!E:E))","v":2},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"point\")","v":"USD/point"},null,null,{"$f":"+K7","v":"USD/point"}]
[]
[null,null,"Project Size","(Input size) →",null,"points",null,"Robot Capping",null,{"$f":"IF(J15=\"Custom Price\",M9,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!I:I))","v":12000},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"Month\")","v":"USD/Month"},null,null,{"$f":"+K9","v":"USD/Month"}]
[]
[null,null,"Nº of SitePrint Robots","(Input nº of robots) →",null,"robots",null,"Project capping",null,{"$f":"IF(J15=\"Custom Price\",M11,_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!J:J))","v":20000},{"$f":"+CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"Month\")","v":"USD/Month"},null,null,{"$f":"+K11","v":"USD/Month"}]
[]
[null,null,"Total Station Cost","(Input cost) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Initial investment",null,{"$f":"+J5*E11+E13*E11","v":0},{"$f":"IF(N36=\"N/A\",\"\",_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B))","v":"USD"}]
[]
[{"$nulls":9},"MSRP"]
[null,null,"Project Layout expenses"]
[]
[{"$nulls":4},"Traditional",{"$nulls":4},"SitePrint"]
[]
[null,null,"Crew Size","(Input crew size) →",null,"people",null,null,"(Input crew size) →",null,"people"]
[]
[null,null,"Hourly cost of layout professionals","(Input cost) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,"(Input cost) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Productivitity","(Input Productivity) →",null,"points/hour",null,null,"(Input Productivity) →",null,"points/hour",null,"Productivity Increase",{"$f":"IFERROR(CONCATENATE(ROUND((J24/E24),1),\"x\"),\"\")","v":""},{"$f":"+IF(N24=\"\",\"\",IF((J24/E24)<=1,\"\",\"Faster\"))","v":""}]
[]
[null,null,"Layout Duration",null,{"$f":"+E27/8","v":0},"days",null,null,null,{"$f":"+J27/8","v":0},"days",null,"Layout time reduction",{"$f":"+E26-J26","v":0},"days"]
[{"$nulls":4},{"$f":"IFERROR(E9/E24,0)","v":0},"hours",null,null,null,{"$f":"IFERROR(E9/J24,0)","v":0},"hours",null,null,{"$f":"+E27-J27","v":0},"hours"]
[{"$nulls":4},{"$f":"+E27*E20","v":0},"manhours",null,null,null,{"$f":"+J27*J20","v":0},"manhours",null,null,0,"manhours"]
[]
[null,null,"Labor Costs",null,{"$f":"+E27*E20*E22","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,null,{"$f":"+J27*J20*J22","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Labor Cost Reduction",{"$f":"+E30-J30","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"SitePrint Usage Fee",{"$nulls":6},{"$f":"+E9*J7","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Robot Capping Discount",{"$nulls":6},{"$f":"IFERROR(IF(J32/E11/E7<J9,0,((J9-(J32/E11/E7))*E7*E11)),0)","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Project Capping Discount",{"$nulls":6},{"$f":"IFERROR(IF((J32+J33)/E7<J11,0,J11*(E7)-(J32+J33)),0)","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"SitePrint Usage Fee After Cappings",{"$nulls":6},{"$f":"+J32+J33+J34","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Layout Operational Expenses (Excluding D&A)",null,{"$f":"+E30+E35","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,null,null,{"$f":"+J35+J30","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"},null,"Layout cost reduction",{"$f":"+E37-J37","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Layout cost per area",null,{"$f":"IFERROR(E37/E9,0)","v":0},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"point\")","v":"USD/point"},null,null,null,{"$f":"IFERROR(J37/E9,0)","v":0},{"$f":"CONCATENATE(_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B),\"/\",\"point\")","v":"USD/point"},null,{"$f":"+CONCATENATE(\"Layout cost reduction/\",\"point\")","v":"Layout cost reduction/point"},{"$f":"+E39-J39","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[]
[null,null,"Return on investment"]
[]
[null,null,"Iceberg Value"]
[null,null,"Expected savings from Layout Labor Cost Reduction","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Expected savings from Schedule Reduction","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Expected savings from Rework","(Input savings) →",null,{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[null,null,"Total Additional Savings","(Input savings) →",{"$f":"+E45+E46+E47","v":0},{"$f":"+_xlfn.XLOOKUP(E5,'Country Data'!A:A,'Country Data'!B:B)","v":"USD"}]
[]
[null,null,"Payback Period",null,{"$f":"IFERROR(IF((J5*E11+E13*E11)/(N39+E48/E9)<=0,\"N/A\",(J5*E11+E13*E11)/(N39+E48/E9)),\"\")","v":""},"points"]
[null,null,"Area threshold required to break even on the investment",null,{"$f":"IFERROR(IF(E50=\"N/A\",\"N/A\",E50/E9),\"\")","v":""},"projects"]
[{"$nulls":4},{"$f":"IFERROR(IF(E50=\"N/A\",\"N/A\",E51*E7),\"\")","v":""},"months"]
[]
[null,null,"Notes"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null," -"]
[null,null,"  "]

{"sheet":"ROI Chart Area (Project)","index":6,"n_rows":5,"n_cols":61,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,37,0,48],[0,49,0,60],[0,1,0,12],[0,13,0,24],[0,25,0,36]]}
[null,"Year 1",{"$nulls":11},"Year 2",{"$nulls":11},"Year 3",{"$nulls":11},"Year 4",{"$nulls":11},"Year 5"]
[null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 13","Month 14","Month 15","Month 16","Month 17","Month 18","Month 19","Month 20","Month 21","Month 22","Month 23","Month 24","Month 25","Month 26","Month 27","Month 28","Month 29","Month 30","Month 31","Month 32","Month 33","Month 34","Month 35","Month 36","Month 37","Month 38","Month 39","Month 40","Month 41","Month 42","Month 43","Month 44","Month 45","Month 46","Month 47","Month 48","Month 49","Month 50","Month 51","Month 52","Month 53","Month 54","Month 55","Month 56","Month 57","Month 58","Month 59","Month 60"]
["Initial Investment",{"$f":"+'Area Model'!J13","v":81000},{"$f":"+B3","v":81000},{"$f":"+C3","v":81000},81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000]
["Monthly Savings",{"$f":"+'Area Model'!N37/'Area Model'!E7+'Area Model'!E49/'Area Model'!E7","v":7011.363636363636},{"$f":"+B4","v":7011.363636363636},{"$f":"+C4","v":7011.363636363636},7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636,7011.363636363636]
["Accumulated Savings",{"$f":"+B4","v":7011.363636363636},{"$f":"+C4+B5","v":14022.727272727272},{"$f":"+D4+C5","v":21034.090909090908},28045.454545454544,35056.818181818177,42068.181818181809,49079.545454545441,56090.909090909074,63102.272727272706,70113.636363636339,77124.999999999971,84136.363636363603,91147.727272727236,98159.090909090868,105170.4545454545,112181.81818181813,119193.18181818177,126204.5454545454,133215.90909090903,140227.27272727268,147238.63636363632,154249.99999999997,161261.36363636362,168272.72727272726,175284.09090909091,182295.45454545456,189306.81818181821,196318.18181818185,203329.5454545455,210340.90909090915,217352.27272727279,224363.63636363644,231375.00000000009,238386.36363636373,245397.72727272738,252409.09090909103,259420.45454545468,266431.81818181829,273443.18181818194,280454.54545454559,287465.90909090923,294477.27272727288,301488.63636363653,308500.00000000017,315511.36363636382,322522.72727272747,329534.09090909112,336545.45454545476,343556.81818181841,350568.18181818206,357579.5454545457,364590.90909090935,371602.272727273,378613.63636363664,385625.00000000029,392636.36363636394,399647.72727272758,406659.09090909123,413670.45454545488,420681.81818181853]

{"sheet":"ROI Chart Point (Project)","index":7,"n_rows":5,"n_cols":61,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,0,12],[0,13,0,24],[0,25,0,36],[0,37,0,48],[0,49,0,60]]}
[null,"Year 1",{"$nulls":11},"Year 2",{"$nulls":11},"Year 3",{"$nulls":11},"Year 4",{"$nulls":11},"Year 5"]
[null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 13","Month 14","Month 15","Month 16","Month 17","Month 18","Month 19","Month 20","Month 21","Month 22","Month 23","Month 24","Month 25","Month 26","Month 27","Month 28","Month 29","Month 30","Month 31","Month 32","Month 33","Month 34","Month 35","Month 36","Month 37","Month 38","Month 39","Month 40","Month 41","Month 42","Month 43","Month 44","Month 45","Month 46","Month 47","Month 48","Month 49","Month 50","Month 51","Month 52","Month 53","Month 54","Month 55","Month 56","Month 57","Month 58","Month 59","Month 60"]
["Initial Investment",{"$f":"+'Point Model'!J13","v":0},{"$f":"+B3","v":0},{"$f":"+C3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Monthly Savings",{"$f":"+'Point Model'!N37/'Point Model'!E7+'Point Model'!E48/'Point Model'!E7","v":{"$error":"#DIV/0!"}},{"$f":"+B4","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Accumulated Savings",{"$f":"+B4","v":{"$error":"#DIV/0!"}},{"$f":"+C4+B5","v":{"$error":"#DIV/0!"}},{"$f":"+D4+C5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]