{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Inputs","Validation","Version Tracking","AEG Import"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Instructions","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[31,6,31,7],[30,6,30,7],[23,6,23,7],[22,6,22,7],[21,6,21,7],[29,6,29,7],[27,6,27,7],[26,6,26,7],[25,6,25,7],[24,6,24,7],[27,3,28,3],[9,2,9,6],[7,2,7,6],[8,2,8,3],[8,4,8,6],[20,6,20,7],[11,2,11,6]]}
[]
[]
[null,"Air-Cooled Ice Machine Rebates"]
[null,"Equipment Information Workbook Instructions"]
[null,{"$f":"_xlfn.CONCAT(\"Version \",'Version Tracking'!C4)","v":"Version 1.2"}]
[]
[]
[null,null,"This worksheet is required for all applications for ice machine incentives. The completed worksheet must be completed and and uploaded to the Application Portal located at:"]
[null,null,"Online Application Portal",null,"Resources Page"]
[null,null,"Ice machine technical requirements can be found on the Resources page of the Application Portal. "]
[null,null,"Instructions"]
[null,null,"1.   Enter the required project information in the shaded areas only. A description of this information is provided below in the Inputs section.                                    "]
[null,null,null,"- All other information will be populated automatically."]
[null,null,"2.   Save file with a project name and date using the naming convention: project name_YY_MM_DD.xls"]
[null,null,"3.","Upload the this worksheet to the supporting documents section of your online application. "]
[]
[null,null,"Inputs Tab"]
[null,null,"Provide at least the required information in the Customer and Project Information section."]
[null,null,"Use a separate row for each ice machine."]
[null,null,"Proposed Equipment Information",null,"Unit","Input Range","Description"]
[null,null,"1.","Building Type","n/a","Select from Building Types","Enter the building type that most closely matches where the installation of the ice machine is taking place."]
[null,null,"2.","Manufacturer","n/a","Any","Enter the manufacturer of the new ice machine."]
[null,null,3,"Model ","n/a","Any","Enter the model number of the new ice machine."]
[null,null,4,"Serial Number","n/a","Any","Enter the serial number of the new ice machine."]
[null,null,5,"Harvest Rate\n(lbs ice/day)","n/a","Any","Rated ice production in lbs/day from the ENERGY STAR certification."]
[null,null,6,"Ice Type","n/a","Select from dropdown","Select Batch or Continous operation."]
[null,null,7,"Ice Machine Type","n/a","Select from dropdown","Select Ice Machine Head, Remote Condensing Unit or Self Contained Unit."]
[null,null,8,"ENERGY STAR Unique ID \n(7 digits found on the ENERGY STAR website)","n/a","Any","Enter the Unique ID number from the ENERGY STAR website."]
[null,null,null,null,null,null,"https://www.energystar.gov/productfinder/product/certified-commercial-ice-machines/results"]
[null,null,9,"Manufacturer","n/a","Any","Enter the manufacturer of the water-cooled ice machine being replaced."]
[null,null,10,"Model ","n/a","Any","Enter the model number of the water-cooled ice machine being replaced."]
[null,null,11,"Serial Number","n/a","Any","Enter the serial number of the water-cooled ice machine being replaced."]

{"sheet":"Inputs","index":1,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,10,34,12],[0,26,0,27],[4,1,4,24],[21,3,22,3],[21,24,22,24],[10,12,10,14],[25,1,25,2],[24,1,24,2],[23,1,23,2],[21,1,22,2],[33,1,33,2],[32,1,32,2],[31,1,31,2],[30,1,30,2],[29,1,29,2],[34,13,34,14],[14,2,14,24],[6,4,6,5],[7,6,7,7],[7,10,7,11],[7,4,7,5],[8,15,8,23],[10,6,10,7],[25,10,25,11],[24,10,24,11],[23,10,23,11],[22,10,22,11],[21,4,21,11],[28,1,28,2],[27,1,27,2],[26,1,26,2],[28,10,28,11],[27,10,27,11],[26,10,26,11],[33,10,33,11],[32,10,32,11],[31,10,31,11],[30,10,30,11],[29,10,29,11],[21,18,22,18],[8,4,8,5],[8,10,8,11],[9,4,9,5],[9,10,9,11],[21,12,21,14],[13,1,13,24],[12,1,12,24],[9,12,9,14],[8,12,8,14],[20,14,20,24],[19,2,19,24],[18,2,18,24],[17,2,17,24],[16,2,16,24],[15,2,15,24],[4,26,9,27],[1,1,1,3],[2,4,2,24],[3,1,3,24],[1,4,1,24],[6,6,6,7],[6,10,6,11],[7,12,7,14],[6,12,6,14],[8,6,8,7],[9,6,9,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide in Public Version"]
[null,null,null,null,"JEA Ice Machine Rebate Application \nEquipment Information"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"Version \",'Version Tracking'!C4)","v":"Version 1.2"}]
[]
[null,"Customer and Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check for Ice Machine and Green Restaurant incentives in current Program Year. Cooling Tower Project Cap may need to be modified in order to not exceed the $30,000 annual water incentive cap."]
[]
[null,null,null,null,"Customer Name ",null,null,null,null,null,"Project Name "]
[null,null,null,null,"Customer Contact ",null,null,null,null,null,"Contractor Name"]
[null,null,null,null,"Customer Address",null,null,null,null,null,"Contractor Contact",null,null,null,null,"Hide these columns in public version"]
[null,null,null,null,"Customer Phone",null,null,null,null,null,"Contactor Email"]
[null,null,null,null,"Customer Email",null,null,null,null,null,"Total Project Cost"]
[]
[null,"Enter Information in Blue Cells Only!"]
[null,"ICE MACHINE TECHNICAL REQUIREMENTS"]
[null,1,"Must replace an existing water-cooled ice machine with an ENERGY STAR certified air-cooled ice machine. "]
[null,2,"Business Rebates program will pay a rebate of $300 for every 100 pounds of ice production from an ENERGY STAR commercial ice machine. Rebates are capped at 50% of the total project cost and $7,000 per project."]
[null,3,"You do not need to engage a Trade Ally to purchase/install an ice machine. "]
[null,4,"An inspection may be required prior to installing a new ice machine."]
[null,5,"For emergency replacements, customer may purchase and install a new air cooled ice machine and submit an application with copies of invoices and photos of existing water-cooled ice machine within 60 days. Rebate will not be approved without proof through photos of existing water-cooled ice machine. "]
[null,6,"All equipment must be new. Used or refurbished air-cooled ice machines are not elicible for rebates."]
[]
[null,"Line Item",null,"Building Type","New ENERGY STAR Certified Commercial Ice Machine Information",null,null,null,null,null,null,null,"Existing Water-cooled Ice Machine Information",null,null,"Total kWh Saved","Summer Coincident Peak kW Saved","Incentive","Incentive per Ton or unit","Translate for Counting",null,null,null,null,"Requested Rebate"]
[null,null,null,null,"Manufacturer","Model ","Serial Number","Harvest Rate\n(lbs ice/day)","Ice Type","Ice Machine Type","ENERGY STAR Unique ID",null,"Manufacturer","Model ","Serial Number"]
[null,"Ex.",null,"Restaurant","XYZ Ice","XYZIM350",123456,350,"Continous","Self Contained Unit",168795,null,"ACME Ice","AIMWC350",389426,{"$error":"#N/A"},{"$error":"#N/A"},300,60,{"$error":"#N/A"},null,null,null,null,1050]
[null,"N1",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#N/A"},null,null,null,null,null,null,null,{"$f":"ROUND(H25/100*Incentive,0)","v":0}]
[null,"N2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N9",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#N/A"},"-",null,null,null,null,null,null,0]
[null,"N10",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#N/A"},"-",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y35=SUM(Y25:Y34),\"No Cost Cap Applied\",IF(Y35=Validation!I17,\"S10,000 Project Cap Applied\",\"50% of Project Cost Cap Applied\"))","v":"No Cost Cap Applied"},null,null,"Total Requested Rebate",null,"","","-",null,null,null,null,null,null,{"$f":"MIN(Validation!I15,Validation!I16,Validation!I18)","v":0}]

{"sheet":"Validation","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,10,0,11],[9,9,10,9],[11,9,15,9],[16,9,19,9],[6,9,8,9],[6,12,6,15],[6,16,6,19],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[19,7,19,8],[2,1,3,1],[2,2,2,3],[2,4,2,5],[4,2,5,5]]}
[null,null,null,null,null,null,null,null,null,null,"SLT Attributes Dictionary"]
[null,null,null,null,null,null,null,"Device Type","ICE Type",null,"Attribute","Data Description"]
[null,"Building Type",null,null,null,null,null,"Ice Making Head","Batch",null,"CAPACITY","LBS/Day ice capacity"]
[null,null,null,null,null,null,null,"Remote Condensing Unit","Continous",null,"building_type_sel","Building Type"]
[null,"Data center ","GPD water savings is estimated at 1 GPD per 1 pound/day of rated ice production",null,null,null,null,"Self Contained Unit",null,null,"Elec_Util_cust_Incentive","Incentive"]
[null,"College ",null,null,null,null,null,null,null,null,"Incentive_Per_Unit","Incentive"]
[null,"Primary school ",null,null,null,null,null,null,null,null,"GALLONS_WATER","GPD water use reduction"]
[null,"Secondary school ",null,null,null,null,null,"Incentive / 100# ice rating",null,null,"MANUFACTURER","New Unit"]
[null,"Hospital ",null,null,null,null,null,300,null,null,"Model","New Unit"]
[null,"Midrise apartment ",null,null,null,null,null,null,null,null,"SERIAL_NUMBER","New Unit"]
[null,"Hotel ",null,null,null,null,null,null,null,null,"TYPE","Ice Machine Type"]
[null,"Grocery",null,null,null,null,null,"Incentive Cap calc",null,null,"STYLE","Operation description"]
[null,"Convenience",null,null,null,null,null,"Project Cost Cap %",0.5,null,"CERTIFIED_REF_NUMBER","ENERGY STAR Unique ID"]
[null,"Restaurant",null,null,null,null,null,"Project Cost",{"$f":"ProjectCost","v":0},null,"MAKE","Existing Unit"]
[null,"Nursing home ",null,null,null,null,null,"Initial Incentive",{"$f":"SUM(Inputs!Y25:Y34)","v":0},null,"MODEL_NUMBER","Existing Unit"]
[null,"Stand-alone retail ",null,null,null,null,null,"Cost Cap Incentive",{"$f":"IF(I15>I13*I14,I13*I14,I15)","v":0},null,"SERIAL_NUM_SUBCOMPONENT_1","Existing Unit"]
[null,"24-hour retail ",null,null,null,null,null,"Max incentive cap",7000,null,"quantity","Defailt at 1"]
[null,"Large office ",null,null,null,null,null,"Max Cap Incentice",{"$f":"IF(I16>I17,I17,I16)","v":0}]
[null,"Public assembly "]
[null,"Religious worship ",null,null,null,null,null,"Check for Cooling Tower and Green Restaurant incentives in current Program Year. Ice Machine Max Incentive Cap may need to be modified in order to not exceed the $30,000 annual water incentive cap."]
[null,"Other "]

{"sheet":"Version Tracking","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B50001<>\"\"),B1:B50001)","v":1.2}]
[null,"Version","Notes","Date","Updated By"]
[null,1,"Initial Creation","2022-02-25","CGO"]
[null,1.1000000000000001,"Modified Project Incentive cap, Caution wording for annual water cap, AEG M#","2022-03-15","CGO"]
[null,1.2,"Edits based on JEA feedback (formatting, word smithing)","2022-04-14","RM"]

{"sheet":"AEG Import","index":4,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Measure #","Import?","CAPACITY","building_type_sel","Elec_Util_cust_Incentive","Incentive_Per_Unit","GALLONS_WATER","MANUFACTURER","Model","SERIAL_NUMBER","TYPE","STYLE","CERTIFIED_REF_NUMBER","MAKE","MODEL_NUMBER","SERIAL_NUM_SUBCOMPONENT_1","quantity"]
["IM",{"$f":"IF(Inputs!K25=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H25","v":0},{"$f":"Inputs!D25","v":0},{"$f":"Inputs!Y25","v":0},{"$f":"E2","v":0},{"$f":"Inputs!H25","v":0},{"$f":"Inputs!E25","v":0},{"$f":"Inputs!F25","v":0},{"$f":"Inputs!G25","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K25","v":0},{"$f":"Inputs!G25","v":0},{"$f":"Inputs!H25","v":0},{"$f":"Inputs!E25","v":0},1]
["IM",{"$f":"IF(Inputs!K26=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H26","v":0},{"$f":"Inputs!D26","v":0},{"$f":"Inputs!Y26","v":0},{"$f":"E3","v":0},{"$f":"Inputs!H26","v":0},{"$f":"Inputs!E26","v":0},{"$f":"Inputs!F26","v":0},{"$f":"Inputs!G26","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K26","v":0},{"$f":"Inputs!G26","v":0},{"$f":"Inputs!H26","v":0},{"$f":"Inputs!E26","v":0},1]
["IM",{"$f":"IF(Inputs!K27=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H27","v":0},{"$f":"Inputs!D27","v":0},{"$f":"Inputs!Y27","v":0},0,{"$f":"Inputs!H27","v":0},{"$f":"Inputs!E27","v":0},{"$f":"Inputs!F27","v":0},{"$f":"Inputs!G27","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K27","v":0},{"$f":"Inputs!G27","v":0},{"$f":"Inputs!H27","v":0},{"$f":"Inputs!E27","v":0},1]
["IM",{"$f":"IF(Inputs!K28=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H28","v":0},{"$f":"Inputs!D28","v":0},{"$f":"Inputs!Y28","v":0},0,{"$f":"Inputs!H28","v":0},{"$f":"Inputs!E28","v":0},{"$f":"Inputs!F28","v":0},{"$f":"Inputs!G28","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K28","v":0},{"$f":"Inputs!G28","v":0},{"$f":"Inputs!H28","v":0},{"$f":"Inputs!E28","v":0},1]
["IM",{"$f":"IF(Inputs!K29=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H29","v":0},{"$f":"Inputs!D29","v":0},{"$f":"Inputs!Y29","v":0},0,{"$f":"Inputs!H29","v":0},{"$f":"Inputs!E29","v":0},{"$f":"Inputs!F29","v":0},{"$f":"Inputs!G29","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K29","v":0},{"$f":"Inputs!G29","v":0},{"$f":"Inputs!H29","v":0},{"$f":"Inputs!E29","v":0},1]
["IM",{"$f":"IF(Inputs!K30=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H30","v":0},{"$f":"Inputs!D30","v":0},{"$f":"Inputs!Y30","v":0},0,{"$f":"Inputs!H30","v":0},{"$f":"Inputs!E30","v":0},{"$f":"Inputs!F30","v":0},{"$f":"Inputs!G30","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K30","v":0},{"$f":"Inputs!G30","v":0},{"$f":"Inputs!H30","v":0},{"$f":"Inputs!E30","v":0},1]
["IM",{"$f":"IF(Inputs!K31=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H31","v":0},{"$f":"Inputs!D31","v":0},{"$f":"Inputs!Y31","v":0},0,{"$f":"Inputs!H31","v":0},{"$f":"Inputs!E31","v":0},{"$f":"Inputs!F31","v":0},{"$f":"Inputs!G31","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K31","v":0},{"$f":"Inputs!G31","v":0},{"$f":"Inputs!H31","v":0},{"$f":"Inputs!E31","v":0},1]
["IM",{"$f":"IF(Inputs!K32=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H32","v":0},{"$f":"Inputs!D32","v":0},{"$f":"Inputs!Y32","v":0},0,{"$f":"Inputs!H32","v":0},{"$f":"Inputs!E32","v":0},{"$f":"Inputs!F32","v":0},{"$f":"Inputs!G32","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K32","v":0},{"$f":"Inputs!G32","v":0},{"$f":"Inputs!H32","v":0},{"$f":"Inputs!E32","v":0},1]
["IM",{"$f":"IF(Inputs!K33=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H33","v":0},{"$f":"Inputs!D33","v":0},{"$f":"Inputs!Y33","v":0},0,{"$f":"Inputs!H33","v":0},{"$f":"Inputs!E33","v":0},{"$f":"Inputs!F33","v":0},{"$f":"Inputs!G33","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K33","v":0},{"$f":"Inputs!G33","v":0},{"$f":"Inputs!H33","v":0},{"$f":"Inputs!E33","v":0},1]
["IM",{"$f":"IF(Inputs!K34=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"Inputs!H34","v":0},{"$f":"Inputs!D34","v":0},{"$f":"Inputs!Y34","v":0},0,{"$f":"Inputs!H34","v":0},{"$f":"Inputs!E34","v":0},{"$f":"Inputs!F34","v":0},{"$f":"Inputs!G34","v":0},{"$f":"Inputs!$J$25","v":0},{"$f":"Inputs!$I$25","v":0},{"$f":"Inputs!K34","v":0},{"$f":"Inputs!G34","v":0},{"$f":"Inputs!H34","v":0},{"$f":"Inputs!E34","v":0},1]