{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Cover sheet","Calculation Sheet","Lists","Power Savings Graph","Power Combined Cals"],"not_rendered":{"charts":1,"images":10,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Cover sheet","index":0,"n_rows":45,"n_cols":26,"rows_kept":45,"merged":[[0,5,0,6],[1,4,2,4],[1,5,1,6],[1,12,1,18],[2,5,2,6],[2,12,2,13],[4,7,4,9],[4,11,4,12],[4,13,4,14],[5,7,5,9],[5,11,5,12],[5,13,5,14],[5,20,5,21],[7,9,7,11],[9,11,9,12],[10,11,10,12],[13,9,13,11],[15,5,15,6],[15,11,15,12],[16,11,16,12],[19,9,19,10],[20,11,20,12],[20,14,20,15],[21,1,21,2],[21,11,21,12],[21,14,21,15],[22,11,22,12],[22,14,22,15],[24,11,24,12],[24,14,24,15],[25,11,25,12],[25,14,25,15],[27,10,27,15],[29,20,29,21],[30,10,31,11],[33,3,33,4],[34,3,34,4],[36,3,36,4],[36,9,36,10],[37,3,38,4],[37,5,38,5],[37,6,38,6],[38,11,38,12],[44,2,44,16]]}
[{"$nulls":4},"cap232",{"$nulls":6},"CLICK HERE TO SEE FULL DETAILS"]
[{"$nulls":4},"YEARLY SAVINGS & GAINS",{"$nulls":7},"POWER SAVINGS",{"$nulls":9},"ANSWER"]
[{"$nulls":12},{"$f":"'Calculation Sheet'!C15","v":0},null,{"$f":"F6","v":"$"},null,"PER YEAR"]
[]
[{"$nulls":4},"CURRENCY CONVERTER",null,null,"COUPLING TYPE",{"$nulls":3},"MACHINE IDENTIFICATION NO."]
[{"$nulls":4},"AUD",{"$f":"IF(E6=\"Click Here\",\"\",VLOOKUP(E6,Lists!E7:F22,2))","v":"$"},null,"TCAE",{"$nulls":3},"PLANT DESCRIPTION",{"$nulls":8},"COSTS SAVINGS & PRODUCTION INCREASE",null,"Current Year (CY)","Year 2","Year 3","Year 4"]
[]
[null,"MACHINE",{"$nulls":7},"ENERGY COSTS",{"$nulls":10},{"$f":"'Calculation Sheet'!A6","v":"MACHINE COST"},{"$f":"'Calculation Sheet'!B6","v":"Click Here"},{"$f":"'Calculation Sheet'!C6","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!D6","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!E6","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!F6","v":{"$error":"#N/A"}}]
[{"$nulls":4},"MOTOR POWER",null,"Click Here"]
[{"$nulls":4},"MOTOR SPEED",1485,"RPM",{"$nulls":4},"POWER COST kWH",null,"Click Here",{"$f":"$F$6","v":"$"},{"$nulls":5},{"$f":"'Calculation Sheet'!A8","v":"LABOUR COST"},{"$f":"'Calculation Sheet'!B8","v":"Idle Man Hour Costs"},{"$f":"'Calculation Sheet'!C8","v":0},{"$f":"'Calculation Sheet'!D8","v":0},{"$f":"'Calculation Sheet'!E8","v":0},{"$f":"'Calculation Sheet'!F8","v":0}]
[{"$nulls":11},"MOTOR POWER FACTOR",null,"Click Here","%",{"$nulls":6},{"$f":"'Calculation Sheet'!B9","v":"Labour Repair Costs"},{"$f":"'Calculation Sheet'!C9","v":0},{"$f":"'Calculation Sheet'!D9","v":0},{"$f":"'Calculation Sheet'!E9","v":0},{"$f":"'Calculation Sheet'!F9","v":0}]
[{"$nulls":4},"DUTY Hours Per Day","Click Here","Hrs",{"$nulls":14},{"$f":"'Calculation Sheet'!B10","v":"Labour Cost to Replace Motor Pump"},{"$f":"'Calculation Sheet'!C10","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!D10","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!E10","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!F10","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"DUTY Days per Week",null,"Days"]
[{"$nulls":4},"DUTY Weeks Per Year",null,"Wks",null,null,"PRODUCTION LOSSES",{"$nulls":10},{"$f":"'Calculation Sheet'!A12","v":"MATERIAL COST"},{"$f":"'Calculation Sheet'!B12","v":"Coupling Element Replacement Cost"},{"$f":"'Calculation Sheet'!C12","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!D12","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!E12","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!F12","v":{"$error":"#N/A"}}]
[{"$nulls":21},{"$f":"'Calculation Sheet'!B13","v":"Replace Cost Motor/Pump"},{"$f":"'Calculation Sheet'!C13","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!D13","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!E13","v":{"$error":"#VALUE!"}},{"$f":"'Calculation Sheet'!F13","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"EXISTING COUPLING TYPE","Click Here",{"$nulls":5},"LOST PRODUCTION  VALUE per Hour",null,null,{"$f":"$F$6","v":"$"}]
[{"$nulls":4},"EXISTING COUPLING COST - NEW",null,{"$f":"$F$6","v":"$"},{"$nulls":4},"LOST PRODUCTION LASER ALIGNING per HOUR",null,null,"HRS"]
[{"$nulls":20},{"$f":"'Calculation Sheet'!A15","v":"ENERY COST"},{"$f":"'Calculation Sheet'!B15","v":"Power Savings"},{"$f":"'Calculation Sheet'!C15","v":0},{"$f":"'Calculation Sheet'!D15","v":0},{"$f":"'Calculation Sheet'!E15","v":0},{"$f":"'Calculation Sheet'!F15","v":0}]
[{"$nulls":4},"REPLACEMENT CYCLE EXISTING - COUPLING","Click Here","Years"]
[{"$nulls":9},"LASER ALIGNING",{"$nulls":10},{"$f":"'Calculation Sheet'!A17","v":"PRODUCTION LOSS"},{"$f":"'Calculation Sheet'!B17","v":"Production Loss Due to Break Downs"},{"$f":"'Calculation Sheet'!C17","v":0},{"$f":"'Calculation Sheet'!D17","v":0},{"$f":"'Calculation Sheet'!E17","v":0},{"$f":"'Calculation Sheet'!F17","v":0}]
[{"$nulls":11},"EXTERNAL LASER ALIGNMENT COST pa",null,null,{"$f":"$F$6","v":"$"}]
[null,"LABOUR",{"$nulls":9},"NUMBER MACHINES ALIGNED BY EXTERNAL pa",null,null,"NUMBER"]
[{"$nulls":4},"LABOUR COST Per Hour",null,{"$f":"$F$6","v":"$"},{"$nulls":4},"NUMBER TIMES THIS MACHINE ALIGNED pa",null,null,"NUMBER",{"$nulls":5},{"$f":"'Calculation Sheet'!A19","v":"LASER ALIGNING COSTS"},{"$f":"'Calculation Sheet'!B19","v":"External Laser Align Cost"},{"$f":"'Calculation Sheet'!C19","v":0},{"$f":"'Calculation Sheet'!D19","v":0},{"$f":"'Calculation Sheet'!E19","v":0},{"$f":"'Calculation Sheet'!F19","v":0}]
[{"$nulls":21},{"$f":"'Calculation Sheet'!B20","v":"Internal Laser Align Costs"},{"$f":"'Calculation Sheet'!C20","v":0},{"$f":"'Calculation Sheet'!D20","v":0},{"$f":"'Calculation Sheet'!E20","v":0},{"$f":"'Calculation Sheet'!F20","v":0}]
[{"$nulls":4},"# BREAKDOWNS pa",null,"NUMBER",{"$nulls":4},"INTERNAL LASER ALIGNING/CHECKING",null,null,"MAN HRS",{"$nulls":6},{"$f":"'Calculation Sheet'!B21","v":"Production Loss Due to Laser Alignment"},{"$f":"'Calculation Sheet'!C21","v":0},{"$f":"'Calculation Sheet'!D21","v":0},{"$f":"'Calculation Sheet'!E21","v":0},{"$f":"'Calculation Sheet'!F21","v":0}]
[{"$nulls":4},"TIME TO REPAIR IN MAN HOURS",null,"HRS",{"$nulls":4},"NUMBER TIMES THIS MACHINE ALIGNED pa",null,null,"# PER YR"]
[{"$nulls":20},{"$f":"'Calculation Sheet'!A23","v":"Purchase Price TCAE's"},{"$f":"'Calculation Sheet'!B23","v":"PURCHASE PRICE - TCAE/TCVJ"},{"$f":"'Calculation Sheet'!C23","v":0},{"$f":"'Calculation Sheet'!D23","v":0},{"$f":"'Calculation Sheet'!E23","v":0},{"$f":"'Calculation Sheet'!F23","v":0}]
[{"$nulls":4},"IDLE PRODUCTION MAN HOURS LOST",null,"HRS",{"$nulls":3},"NOTE:  ONLY FILLOUT EXTERNAL OR INTERNAL UNLESS YOU DO BOTH TYPES OF ALIGNING"]
[{"$nulls":4},"TOTAL PRODUCTION LOST IN HOURS",null,"HRS"]
[{"$nulls":4},"HOURS TO REPLACE MOTOR ETC",null,"HRS",{"$nulls":13},"Increased Production Benefits and Reduced Costs Less TCAE/TCVJ Cost",null,{"$f":"'Calculation Sheet'!C27","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!D27","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!E27","v":{"$error":"#N/A"}},{"$f":"'Calculation Sheet'!F27","v":{"$error":"#N/A"}}]
[{"$nulls":10},"THE THOMPSON COUPLINGS CAN HANDLE THIS MISALIGNMENT WITH NO LASER ALIGNING REQUIRED"]
[]
[null,"MATERIALS"]
[{"$nulls":3},"NEW COUPLING ELEMENT COST",null,null,{"$f":"$F$6","v":"$"}]
[{"$nulls":3},"# TIMES REPLACEMENT ELEMENT REQ'D ",null,"Click Here","per Yr"]
[]
[{"$nulls":3},"# TIMES MOTOR/PUMP ETC REPLACE IN YEARS",null,"Click Here","NUMBER",null,null,"TCAE COST"]
[{"$nulls":3},"COST OF MOTOR/PUMP ETC OVERHAUL OR REPLACEMENT",null,null,{"$f":"$F$6","v":"$"}]
[{"$nulls":11},"INSERT TCAE COST",null,null,{"$f":"$F$6","v":"$"}]
[{"$nulls":11},"ESTIMATED PERIOD - THOMPSONS DEFAULT = 4 YEARS",null,"Click Here","YRS"]
[]
[]
[]
[]
[null,"NOTE 1:","NOTE 1: IF LASER ALIGNING OR REPLACEMENT REPAIRS ARE COMPLETED DURING SHUTDOWN TIME ON ANY MACHINE, BY USING THOMPSON COUPLINGS PRODUCTS, THE REPLACEMENT OR LASER ALIGNING WOULD NOT NEED TO BE DONE AT THAT TIME FOR 3 OR MORE YEARS.  THEREFORE, THE PEOPLE HOW WOULD NORMALLY PERFORM THESE TASKS COULD BE ASSITING ELSEWHERE AND THE SHUTDOWN PERIOD COULD BE REDUCED SIGNIFICENTLY AND PRODUCTION RESTARTED EARLIER RESULTING IN HIGHER PRODUCTION GAIN.  NO ALLOWANCE HAS BEEN MADE IN THIS CALCULATION FOR THIS EXTRA GAIN."]

{"sheet":"Calculation Sheet","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"hidden":true,"merged":[[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[3,0,3,1],[3,2,3,5],[20,7,20,8],[26,0,26,1]]}
[null,null,"Current Year (CY)","Year 2","Year 3","Year 4"]
[]
[]
["COSTS SAVINGS & PRODUCTION INCREASE"]
[]
["MACHINE COST",{"$f":"('Cover sheet'!F16)","v":"Click Here"},{"$f":"ROUNDUP(IF('Cover sheet'!$F$19=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$19,Lists!$C$18:$D$22,2,FALSE)*'Cover sheet'!$F$17)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$19=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$19,Lists!$C$18:$D$22,2,FALSE)*'Cover sheet'!$F$17)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$19=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$19,Lists!$C$18:$D$22,2,FALSE)*'Cover sheet'!$F$17)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$19=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$19,Lists!$C$18:$D$22,2,FALSE)*'Cover sheet'!$F$17)),0)","v":{"$error":"#N/A"}}]
[]
["LABOUR COST","Idle Man Hour Costs",{"$f":"'Cover sheet'!$F$28*'Cover sheet'!$F$23","v":0},{"$f":"'Cover sheet'!$F$28*'Cover sheet'!$F$23","v":0},{"$f":"'Cover sheet'!$F$28*'Cover sheet'!$F$23","v":0},{"$f":"'Cover sheet'!$F$28*'Cover sheet'!$F$23","v":0}]
[null,"Labour Repair Costs",{"$f":"'Cover sheet'!$F$26*'Cover sheet'!$F$23*'Cover sheet'!$F$25","v":0},{"$f":"'Cover sheet'!$F$26*'Cover sheet'!$F$23*'Cover sheet'!$F$25","v":0},{"$f":"'Cover sheet'!$F$26*'Cover sheet'!$F$23*'Cover sheet'!$F$25","v":0},{"$f":"'Cover sheet'!$F$26*'Cover sheet'!$F$23*'Cover sheet'!$F$25","v":0}]
[null,"Labour Cost to Replace Motor Pump",{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$F$30,2,FALSE)*('Cover sheet'!$F$23*'Cover sheet'!$F$30))),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$F$30,2,FALSE)*('Cover sheet'!$F$23*'Cover sheet'!$F$30))),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$F$30,2,FALSE)*('Cover sheet'!$F$23*'Cover sheet'!$F$30))),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$F$30,2,FALSE)*('Cover sheet'!$F$23*'Cover sheet'!$F$30))),0)","v":{"$error":"#VALUE!"}}]
[]
["MATERIAL COST","Coupling Element Replacement Cost",{"$f":"IF('Cover sheet'!$F$35=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$35,Lists!$A$30:$B$33,2,FALSE)*'Cover sheet'!$F$34))","v":{"$error":"#N/A"}},{"$f":"IF('Cover sheet'!$F$35=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$35,Lists!$A$30:$B$33,2,FALSE)*'Cover sheet'!$F$34))","v":{"$error":"#N/A"}},{"$f":"IF('Cover sheet'!$F$35=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$35,Lists!$A$30:$B$33,2,FALSE)*'Cover sheet'!$F$34))","v":{"$error":"#N/A"}},{"$f":"IF('Cover sheet'!$F$35=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$35,Lists!$A$30:$B$33,2,FALSE)*'Cover sheet'!$F$34))","v":{"$error":"#N/A"}}]
[null,"Replace Cost Motor/Pump",{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$G$30,2,FALSE)*'Cover sheet'!$F$38)),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$G$30,2,FALSE)*'Cover sheet'!$F$38)),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$G$30,2,FALSE)*'Cover sheet'!$F$38)),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(IF('Cover sheet'!$F$37=\"ClickHere\",0,(VLOOKUP('Cover sheet'!$F$37,Lists!$E$25:$G$30,2,FALSE)*'Cover sheet'!$F$38)),0)","v":{"$error":"#VALUE!"}}]
[]
["ENERY COST","Power Savings",{"$f":"'Power Savings Graph'!$I$2","v":0},{"$f":"'Power Savings Graph'!$I$2","v":0},{"$f":"'Power Savings Graph'!$I$2","v":0},{"$f":"'Power Savings Graph'!$I$2","v":0}]
[]
["PRODUCTION LOSS","Production Loss Due to Break Downs",{"$f":"'Cover sheet'!$N$16*'Cover sheet'!$F$29","v":0},{"$f":"'Cover sheet'!$N$16*'Cover sheet'!$F$29","v":0},{"$f":"'Cover sheet'!$N$16*'Cover sheet'!$F$29","v":0},{"$f":"'Cover sheet'!$N$16*'Cover sheet'!$F$29","v":0}]
[]
["LASER ALIGNING COSTS","External Laser Align Cost",{"$f":"IF('Cover sheet'!$N$21=0,0,IF('Cover sheet'!$N$22=0,0,('Cover sheet'!$N$21/'Cover sheet'!$N$22)*'Cover sheet'!$N$23))","v":0},{"$f":"IF('Cover sheet'!$N$21=0,0,IF('Cover sheet'!$N$22=0,0,('Cover sheet'!$N$21/'Cover sheet'!$N$22)*'Cover sheet'!$N$23))","v":0},{"$f":"IF('Cover sheet'!$N$21=0,0,IF('Cover sheet'!$N$22=0,0,('Cover sheet'!$N$21/'Cover sheet'!$N$22)*'Cover sheet'!$N$23))","v":0},{"$f":"IF('Cover sheet'!$N$21=0,0,IF('Cover sheet'!$N$22=0,0,('Cover sheet'!$N$21/'Cover sheet'!$N$22)*'Cover sheet'!$N$23))","v":0}]
[null,"Internal Laser Align Costs",{"$f":"('Cover sheet'!$N$25*'Cover sheet'!$N$26*'Cover sheet'!$N$26)*'Cover sheet'!$F$23","v":0},{"$f":"('Cover sheet'!$N$25*'Cover sheet'!$N$26*'Cover sheet'!$N$26)*'Cover sheet'!$F$23","v":0},{"$f":"('Cover sheet'!$N$25*'Cover sheet'!$N$26*'Cover sheet'!$N$26)*'Cover sheet'!$F$23","v":0},{"$f":"('Cover sheet'!$N$25*'Cover sheet'!$N$26*'Cover sheet'!$N$26)*'Cover sheet'!$F$23","v":0}]
[null,"Production Loss Due to Laser Alignment",{"$f":"'Cover sheet'!$N$17*'Cover sheet'!$N$16","v":0},{"$f":"'Cover sheet'!$N$17*'Cover sheet'!$N$16","v":0},{"$f":"'Cover sheet'!$N$17*'Cover sheet'!$N$16","v":0},{"$f":"'Cover sheet'!$N$17*'Cover sheet'!$N$16","v":0}]
[]
["Purchase Price TCAE's","PURCHASE PRICE - TCAE/TCVJ",{"$f":"'Cover sheet'!$N$39","v":0},{"$f":"IF('Cover sheet'!$N$40=1,'Cover sheet'!$N$39,IF('Cover sheet'!$N$40=2,0,IF('Cover sheet'!$N$40=3,0,IF('Cover sheet'!$N$40=4,0,'Cover sheet'!$N$39))))","v":0},{"$f":"IF('Cover sheet'!$N$40=1,'Cover sheet'!$N$39,IF('Cover sheet'!$N$40=2,'Cover sheet'!$N$39,0))","v":0},{"$f":"IF('Cover sheet'!$N$40=1,'Cover sheet'!$N$39,IF('Cover sheet'!$N$40=3,'Cover sheet'!$N$39,0))","v":0}]
[]
["REPLACEMENT TIME IN YEARS",null,{"$f":"IF('Cover sheet'!$N$40=\"ClickHere\",0,'Cover sheet'!$N$40)","v":"Click Here"},{"$f":"IF('Cover sheet'!$N$40=\"ClickHere\",0,'Cover sheet'!$N$40)","v":"Click Here"},{"$f":"IF('Cover sheet'!$N$40=\"ClickHere\",0,'Cover sheet'!$N$40)","v":"Click Here"},{"$f":"IF('Cover sheet'!$N$40=\"ClickHere\",0,'Cover sheet'!$N$40)","v":"Click Here"}]
[]
["Increased Production Benefits and Reduced Costs Less TCAE/TCVJ Cost",null,{"$f":"SUM(C6:C20)-C23","v":{"$error":"#N/A"}},{"$f":"SUM(D6:D20)-D23","v":{"$error":"#N/A"}},{"$f":"SUM(E6:E20)-E23","v":{"$error":"#N/A"}},{"$f":"SUM(F6:F20)-F23","v":{"$error":"#N/A"}}]
[]
[null,null,"ROI in Months"]
[null,null,{"$f":"IF(SUM(C6:C21)<0.01,0,(C23/SUM(C6:C21)*12))","v":{"$error":"#N/A"}}]

{"sheet":"Lists","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"hidden":true,"merged":[[2,0,2,6],[3,0,3,1],[5,2,5,3],[5,4,5,5],[15,2,15,3],[23,4,23,5]]}
[]
[]
["LISTS USED"]
[]
[]
["AMORTISATION","Machine Rating Factor","COUPLING TYPES",null,"Currencies",null,"Cost per KW"]
["Click Here","Click Here","Click Here",null,"Click Here","Symbol","Click Here"]
[1,{"v":0.6,"d":"60%"},"DISC",{"v":0.05,"d":"5%"},"AUD","$",0.08]
[2,{"v":0.7,"d":"70%"},"GRID",{"v":0.1,"d":"10%"},"BRITISH POUND","£",{"v":0.1,"d":"0.10"}]
[3,{"v":0.75,"d":"75%"},"GEAR",{"v":0.1,"d":"10%"},"CANADIAN $","$",0.12]
[4,{"v":0.8,"d":"80%"},"JAWFLEX or HRC",{"v":1,"d":"100%"},"DUTCH EURO","€",0.14]
[null,{"v":0.85,"d":"85%"},"ELASTOMERIC TYRE",{"v":1,"d":"100%"},"EURO","€",0.16]
["Daily Duty Hours",{"v":0.95,"d":"95%"},"FALK STEEL FLEX",{"v":1,"d":"100%"},"FRENCH EURO","€",0.18]
["Click Here",{"v":1,"d":"100%"},"RIGID",{"v":0,"d":"0%"},"GERMANY EURO","€",{"v":0.2,"d":"0.20"}]
[4,{"v":1.05,"d":"105%"},"OTHER",{"v":1,"d":"100%"},"GREEK DRACHMA","€",0.22]
[8,null,"Repair cycle",null,"INDONESIA","Rp",0.24]
[12,null,"Click Here","Per Year","ITALIAN EURO","€",0.26]
[16,null,"Twice per Year",2,"MEXICAN PESO","Mex$",0.28]
[18,null,"Once per Year",1,"NEW ZEALAND","$",{"v":0.3,"d":"0.30"}]
[20,null,"One per 18 Months",{"v":0.666,"d":"67%"},"SPANISH EURO","€",0.35]
[22,null,"Once per 2 Years",{"v":0.5,"d":"50%"},"SWEDISH KRONA","kr"]
[24,null,"Once per 3 years",{"v":0.333,"d":"33%"},"USA","$"]
["kW or BHP","TCVJ or TCAE Type"]
["Click Here","Click Here",null,null,"Motor/Pump Replacement"]
["kW","TCVJ",null,null,"Click Here","Per Year"]
["BHP","TCAE",null,null,"Twice per Year",2]
[{"$nulls":4},"Once per Year",1]
["Element Replacement","Element Replacement",null,null,"One per 18 Months",{"v":0.666,"d":"67%"}]
["Click Here","Per Year",null,null,"Once per 2 Years",{"v":0.5,"d":"50%"}]
["Twice per Year",2,null,null,"Once per 3 years",{"v":0.333,"d":"33%"}]
["Once per Year",1]
["One per 18 Months",{"v":0.666,"d":"67%"}]
["Once per 2 Years",{"v":0.5,"d":"50%"}]

{"sheet":"Power Savings Graph","index":3,"n_rows":2,"n_cols":9,"rows_kept":2}
[null,"Operating Hours per Day",{"$f":"'Cover sheet'!F12","v":"Click Here"},null,"# Operating Days Per Year",{"$f":"'Power Combined Cals'!I4","v":0},null,"Cost Per KW",{"$f":"'Cover sheet'!N10","v":"Click Here"}]
[null,{"$f":"IF('Cover sheet'!G9=\"kW\",\"kW\",\"BHP\")","v":"BHP"},{"$f":"'Cover sheet'!F9","v":0},null,{"$f":"'Cover sheet'!H6","v":"TCAE"},{"$f":"IF(E2=\"TCVJ\",'Power Combined Cals'!I1,IF(E2=\"TCAE\",'Power Combined Cals'!I2,\"\"))","v":{"v":0.023,"d":"2.30%"}},null,"Savings Per Year",{"$f":"IF(C1=4,'Power Combined Cals'!D20,IF(C1=8,'Power Combined Cals'!E20,IF(C1=12,'Power Combined Cals'!F20,IF(C1=16,'Power Combined Cals'!G20,IF(C1=18,'Power Combined Cals'!H20,IF(C1=20,'Power Combined Cals'!I20,IF(C1=22,'Power Combined Cals'!J20,IF(C1=24,'Power Combined Cals'!K20,))))))))","v":0}]

{"sheet":"Power Combined Cals","index":4,"n_rows":22,"n_cols":11,"rows_kept":22,"hidden":true}
[{"$nulls":4},"KW Per Hour",null,null,"TCVJ",{"v":0.03,"d":"3%"}]
[{"$nulls":4},0.746,null,null,"TCAE",{"v":0.023,"d":"2.30%"}]
[{"$nulls":7},"ANSWER",{"$f":"(IF('Cover sheet'!$F$16=\"ClickHere\",0,VLOOKUP('Cover sheet'!$F$16,Lists!C7:D15,2,FALSE)*'Power Savings Graph'!$F$2))","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":4},"Cost Per KW",{"$f":"IF('Cover sheet'!$N$10=\"ClickHere\",0,'Cover sheet'!$N$10)","v":"Click Here"},null,"TOTAL # DAYS",{"$f":"('Cover sheet'!F13*'Cover sheet'!F14)","v":0}]
[{"$nulls":7},"RATING FACTOR",{"$f":"IF('Cover sheet'!$N$11=\"ClickHere\",0,'Cover sheet'!$N$11)","v":"Click Here"}]
[null,null,"Power accounting for Motor Power Factor"]
[null,{"$f":"'Cover sheet'!G9","v":"Click Here"},{"$f":"ROUNDUP((IF(B7=\"kW\",'Cover sheet'!F9,IF(B7=\"BHP\",'Cover sheet'!F9/E2,0))/I5),1)","v":{"$error":"#VALUE!"}},{"$f":"$C$7*D$8","v":{"$error":"#VALUE!"}},{"$f":"$C$7*E$8","v":{"$error":"#VALUE!"}},{"$f":"$C$7*F$8","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Hours Per Day",4,8,12,16,18,20,22,24]
[{"$nulls":3},"4 Hours Per Day","8 Hours Per Day","12 Hours Per Day","16 Hours Per Day","18 Hours Per Day","20 Hours Per Day","22 Hours Per Day","24 Hours Per Day"]
[]
[]
[null,null,"Power Savings"]
[null,{"$f":"'Cover sheet'!G9","v":"Click Here"},{"$f":"C7","v":{"$error":"#VALUE!"}},{"$f":"(((D7*$F$4)*$I$3)*$I$4)","v":{"$error":"#VALUE!"}},{"$f":"(((E7*$F$4)*$I$3)*$I$4)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Hours Per Day",4,8,12,16,18,20,22,24]
[{"$nulls":3},"4 Hours Per Day","8 Hours Per Day","12 Hours Per Day","16 Hours Per Day","18 Hours Per Day","20 Hours Per Day","22 Hours Per Day","24 Hours Per Day"]
[]
[]
[]
[null,{"$f":"'Cover sheet'!G9","v":"Click Here"},{"$f":"C13","v":{"$error":"#VALUE!"}},{"$f":"D7","v":{"$error":"#VALUE!"}},{"$f":"E7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Yearly Savings",{"$f":"D13","v":{"$error":"#VALUE!"}},{"$f":"E13","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H13","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":3},4,8,12,16,18,20,22,24]
[{"$nulls":3},"4 Hours Per Day","8 Hours Per Day","12 Hours Per Day","16 Hours Per Day","18 Hours Per Day","20 Hours Per Day","22 Hours Per Day","24 Hours Per Day"]