{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Install","Viability","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"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":"Install","index":0,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":false,"merged":[[69,0,69,7],[80,6,80,10],[47,6,47,10],[37,3,37,4],[53,6,53,10],[50,1,50,10],[56,0,56,7],[100,0,100,5],[82,3,82,5],[93,1,93,10],[94,1,94,10],[95,1,95,10],[91,0,91,7],[87,7,87,10],[89,8,89,10],[24,5,24,6],[24,7,24,10],[27,1,27,6],[25,5,25,6],[25,7,25,8],[24,1,24,4],[29,0,29,7],[31,0,31,1],[35,0,35,1],[43,0,43,8],[1,2,1,8],[3,2,3,8],[33,7,33,10],[37,0,37,1],[19,7,19,10],[20,7,20,10],[13,4,13,6],[23,1,23,4],[23,5,23,6],[23,7,23,10],[26,5,26,6],[26,7,26,8],[22,5,22,6],[22,7,22,10],[19,1,19,4],[19,5,19,6],[20,4,20,6],[20,0,20,1],[22,1,22,4],[4,0,4,7],[9,1,9,4],[9,5,9,6],[9,7,9,10],[10,1,10,4],[10,5,10,6],[7,7,7,10],[7,4,7,6],[10,7,10,10],[5,0,5,5],[6,1,6,4],[6,5,6,6],[7,0,7,1],[17,0,17,7],[14,1,14,6],[6,7,6,10],[13,7,13,8],[11,1,11,4],[11,5,11,6],[11,7,11,10],[12,5,12,6],[12,7,12,8]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2013-10-02T16:16:31.900"},null,{"$f":"MONTH(save_date)","v":10}]
[null,null,"Compupool Products",null,null,null,null,null,null,null,null,null,{"$f":"DAY(save_date)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(save_date)","v":2013}]
[null,null,"Commercial Installation Details Questionnaire",null,null,null,null,null,null,null,null,null,{"$f":"M7&\" \"&M8","v":"02Oct13 16 16"}]
["Dealer / Contractor Information     ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"HOUR(save_date)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MINUTE(save_date)","v":16}]
["Company:","Pool Supply Unlimited",null,null,null,"Name:",null,null,null,null,null,null,{"$f":"TEXT(save_date,\"ddmmmyy\")","v":"02Oct13"}]
[null,null,null,null,"Enquiry reference:",null,null,null,null,null,null,null,{"$f":"TEXT(save_date,\"hh mm\")","v":"16 16"}]
[]
["E-mail Address:","sales@poolsupplyunlimited.com",null,null,null,"Address Line 1:",null,"1426 E Spruce St"]
["Telephone Number:","(888) 836-6025",null,null,null,"Address Line 2:"]
["Fax Number:","(888) 648-5677",null,null,null,"City:",null,"Ontario"]
[null,null,null,null,null,"State/Province:",null,"CA"]
[null,null,null,null,"Zip / Postal Code:",null,null,91761]
[null,"Country/Region:",null,null,null,null,null,"USA"]
[]
[]
["Customer Information     "]
[]
["Company:",null,null,null,null,"Name:"]
[null,null,null,null,"Project reference:"]
[]
["E-mail Address:",null,null,null,null,"Address Line 1:"]
["Telephone Number:",null,null,null,null,"Address Line 2:"]
["Fax Number:",null,null,null,null,"City:"]
[null,null,null,null,null,"State/Province:"]
[null,null,null,null,null,"Postal Code:"]
[null,"Country/Region:",null,null,null,null,null,"USA"]
[]
["Pool Information     "]
[]
["Is this a Pool or Spa?",null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,"explain:"]
[]
["Is this indoor or outdoor?",null,null,null,null,null,null,null,null,null,null,null,1]
[]
["What is the volume of the project?",null,null,null,null,null,null,null,null,null,null,null,1]
[]
["What is the approximate surface area of the pool ",null,null,null,null,null,null,"sq. feet",null," sq. meters"]
[]
["Is the pool heated or non-heated? ",null,null,null,null,null,null,null,null,null,null,null,1]
[]
["Is the project a flat-water pool, wave pool, slide pool, lazy river, or therapy/hospital pool?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,"explain:"]
[]
["What is the number of water features in the pool and their description (e.g. water slide, river, fountain, etc..) "]
[]
[]
["What is the finish of the pool walls, floor, coping and pavement around the pool (e.g. paint, concrete, epoxy, fiberglass, tiles, etc…)"]
[]
[]
[]
["Operation Information     "]
[]
["What is the minimum number of hours, per day, the main filter pump operates"]
[]
["What is the maximum number of bathers in the pool/spa at any one specific time?"]
[]
["What is the maximum number of bathers in the pool/spa over the entire day?"]
[]
["What is the maximum water temperature maintained? (F or C)",null,null,null,null,null,null,null,null,null,77,"◦F"]
[null,null,null,null,null,null,null,null,null,null,25,"◦C"]
[]
["How many days per year is the project operational?"]
[]
["Sanitization Information     "]
["What are the current levels  for the following Parameters?"]
[]
[null,"Total Alkalinity (ppm project)",null,null,null,null,"Total Alkalinity (ppm source)"]
[]
[null,"Calcium Hardness (ppm project)  ",null,null,null,null," Calcium Hardness (ppm source)"]
[]
[null,"pH (project)",null,null,null,null," pH (source)"]
[]
[null,"Total Dissolved Solids (TDS) (ppm project)",null,null,null,null,"(TDS) (ppm source) "]
[]
["How is the project currently being sanitized? (For existing pools only)"]
[]
["What quantity of sanitizer is being used?",null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
["Will a pH dosing system or any other automated chemical controller be used? ",null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,"explain:"]
[]
["What is the concentration of chlorine residual required to be maintained in the pool water?"]
[]
["Other relevant information"]
["Is there any other relevant data which Compu Pool should know."]
[]
[]
[]
[]
["I confirm that the above information is complete and accurate, and I understand that it will be used for sizing a Compu Pool System  for this project."]
["Consult with your local Government Health Department for any specific local regulations concerning Electrolytic Sanitizing methods."]
[]
["_________________________________________ Project Manager"]

{"sheet":"Viability","index":1,"n_rows":75,"n_cols":23,"rows_kept":75,"cut":false,"hidden":false,"merged":[[56,1,56,3],[25,1,26,1],[27,2,27,3],[18,1,18,4],[20,7,20,10],[21,6,21,8],[43,7,43,8],[45,2,45,3],[45,7,45,8],[30,2,30,3],[30,4,30,5],[33,1,33,3],[52,1,52,3],[53,1,53,3],[29,1,29,3],[29,7,29,8],[1,2,1,8],[6,1,6,5],[3,2,3,10],[7,2,7,4],[8,1,8,2],[19,1,19,2],[13,7,13,8],[14,7,14,8],[15,7,15,8],[10,7,10,10],[11,7,11,10],[17,1,17,10],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[12,7,12,10],[10,2,10,4],[11,2,11,4],[12,2,12,4],[15,2,15,4],[60,1,60,11],[7,7,7,11],[8,7,8,11],[7,5,7,6],[8,5,8,6],[10,5,10,6],[11,5,11,6],[43,11,43,12],[35,1,35,3],[37,2,37,3],[41,6,41,8],[58,1,58,3],[54,1,54,3],[31,2,31,3],[33,5,33,8],[55,6,55,7],[51,1,51,3],[0,10,0,11],[5,1,5,3],[49,1,49,3],[39,7,39,8],[31,6,31,8],[49,5,49,8],[49,10,49,11],[47,5,47,8],[41,1,41,3],[37,7,37,8],[19,7,19,8],[23,2,23,3],[25,2,25,3],[27,7,27,8],[19,4,19,5]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2013-10-02"}]
[null,null,"Compupool Products"]
[]
[null,null,"Commercial Chlorinator Viability Tool"]
[]
[null,"Customer Information     "]
[]
[null,"Company:",{"$f":"customer_name","v":0},null,null,"Name:",null,{"$f":"Install!H7","v":0}]
[null,null,null,null,null,"Enquiry reference:"]
[]
[null,"E-mail Address:",null,null,null,"Address Line 1:"]
[null,"Telephone Number:",null,null,null,"Address Line 2:"]
[null,"Fax Number:",null,null,null,"City:"]
[null,null,null,null,null,"State/Province:"]
[null,null,null,null,null,"Zip / Postal Code:"]
[null,null,null,null,null,"Country/Region:",null,"USA"]
[]
[null,"Customer Costs"]
[null,"Chlorine ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Compound_name",2,"asd",1,"litres / kgs",1,"daily ",1]
[null,"Type of chlorine currently used:   ",null,null,null,null,null,"       Concentration:",null,null,{"$f":"CHOOSE(P25,Q20,Q21,Q22,Q23,Q24)","v":10},"%",null,null,null,"Chlorine gas",100,"ase",2,"lbs",{"$f":"1/2.206","v":0.45330915684496825},"weekly",7]
[null,null,null,null,null,null,null,"(adjust concentration if required)",null,null,null,null,null,null,null,"Trichlor Tablets",90,"asw",3,"US Gallons",{"$f":"4.546*0.8","v":3.6368000000000005},"monthly",{"$f":"365.25/12","v":30.4375}]
[null,null,null,"Volume used:",null,100,"Override concentration:",null,null,null,0,"%",null,null,null,"Calcium Hypochlorite",65,"asc",4,"Imperial Gallons",4.5460000000000003,"annually",365.25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K22>0.01,K22,concentration)","v":10},null,null,null,null,"Sodium Hypochlorite (liquid chlorine)",10,"ax"]
[null,null,"Volume Unit:",null,null,null,null,null,null,null,{"$f":"CHOOSE(chosen_unit,U19,U20,U21,U22)","v":0.45330915684496825},null,null,null,null,"Dichlor",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,2,null,1]
[null,null,"Frequency:",null,null,null,null,null,null,null,{"$f":"CHOOSE(V25,W19,W20,W21,W22)","v":1}]
[]
[null,null,"Chlorine lbs per day:",null,null,{"$f":"Chlorine_kgs_per_day*2.206","v":10},null,"Chlorine Kgs Day:",null,null,{"$f":"vol_unit*volume*chosen_concentration/(100*frequency)","v":4.5330915684496826},null,null,null,null,100,90,65,null,10,60]
[]
[null,"Operational days per year: ",null,null,null,365,null,"Annual Volume used:",null,null,{"$f":"volume/frequency*operational_days_pa","v":36500},{"$f":"VLOOKUP(chosen_unit,S19:T22,2)","v":"lbs"}]
[null,null,"  "]
[null,null,"Chlorine Cost: ",null,null,2.2999999999999998,"  Annual Chlorine Cost :",null,null,null,{"$f":"annual_chlorine_volume*chlorine_unit_cost","v":83950},"p.a"]
[]
[null,"Compupool Chlorinator Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"litres or kgs;lbs;US Gallons;Imperial Gallons"]
[]
[null,"Compupool Model No:",null,null,null,null,null,null,null,null,null,null,null,null,null,"1;0.454;3.78541178 ;4.54609188 "]
[]
[null,null,"CPP Daily Output:",null,null,{"$f":"CPP_daily_output*2.206","v":5.005414},"lbs/day","CPP Daily Output:",null,null,{"$f":"VLOOKUP(Model_ref_no,Comm_model_data,3)","v":2.2690000000000001},"  kgs/day",null,null,null,null,1]
[]
[null,null,null,null,null,null,null,"CPP Kilowatt rating:          ",null,null,{"$f":"VLOOKUP(Model_ref_no,Comm_model_data,4)","v":0.5},"   kW"]
[]
[null,"CPP  Model cost:",null,null,null,0,"Cost per kilowatt-hour:",null,null,null,0.09]
[]
[null,null,null,null,null,null,null,"Approx. salt cost:*",null,null,{"$f":"VLOOKUP(Model_ref_no,Comm_model_data,6)","v":378}," over 5 years"]
[]
[null,null,"Hours of operation per day:",null,null,{"$f":"Chlorine_kgs_per_day/CPP_daily_output*24","v":47.948081817008543},"hrs/day","Annual CPP cost:",null,null,{"$f":"Hrs_production_per_day*operational_days_pa*Cost_per_kwh*CPP_kW_rating","v":787.54724384436531},"p.a"]
[]
[null,null,null,null,null,"Payback (years):",null,null,null,null,{"$f":"CPP_model_cost/(K32-Annual_CPP_Cost-(Salt_cost_5yr/5))","v":0},"yrs"]
[]
[null,"Five Year Cost Analysis"]
[]
[null,"Chlorine at today's prices",null,null,null,null,null,null,null,null,{"$f":"5*K32","v":419750}]
[null,"Cost of Compupool Chlorinator",null,null,null,null,null,{"$f":"CPP_model_cost","v":0}]
[null,"Allowance for the cost of salt *",null,null,null,null,null,{"$f":"Salt_cost_5yr","v":378}]
[null,"Cost of Electricity",null,null,null,null,null,{"$f":"Annual_CPP_Cost*5","v":3937.7362192218266}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H53:H55)","v":4315.7362192218261}]
[null,"Saving over Five years",null,null,null,null,null,null,null,null,{"$f":"K52-K56","v":415434.26378077816}]
[]
[null,"Saving as a percentage of chlorine cost",null,null,null,null,null,null,null,null,{"$f":"K57/K52","v":0.9897183175241886}]
[]
[null,"*Salt cost is an allowance only, based on the initial treatment, and 10% loss per year thereafter."]
[]
[]
[]
[]
[null,"         "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"          "]

{"sheet":"Sheet3","index":2,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Sort Order","ID","CPP_Model","Output_kgs_24hrs","Power_in_KW","Capital_Cost","Salt_cost_pa"]
[2,1,"E-S100",2.2690000000000001,0.5,20000,378]
[4,2,"E-S150",3.63,0.85,30000,567]
[6,3,"E-S200",4.54,1.1499999999999999,40000,756]
[8,4,"E-S300",6.806,1.7,50000,1134]
[10,5,"E-S400",9.0739999999999998,2,60000,1575]
[12,6,"CPP250NR",6,1,16200,945]
[15,7,"CPP400NR",10,2,21560,1575]
[20,8,"CPP500NR",12,2.5,27000,1890]
[24,9,"CPP600NR",14.5,3.5,31160,2285]
[26,10,"CPP800NR",19,4.5,35960,2990]
[28,11,"CPP1000NR",24,5,43160,3780]
[30,12,"CPP1200NR",29,7,51160,4565]
[35,13,"CPP1500NR",36,8.5,59160,5670]
[40,14,"CPP2000NR",48,11.5,74000,7560]
[45,15,"CPP2500NR",60,14,89600,9450]
[50,16,"CPP3000NR",72,17,116000,11340]