{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["License Agreement","Index","Site Information","Water Balance","Virtual Energy","Treasure Map","Andon","Building Envelope Leaks","Compressed Air","Energy Star Appliances","Fans","Groove Belt","HVAC","LED Lighting","Delamping","Power Strips - Occupancy Sensor","Machine Sleep","Panel Cooler","VFDs","Ice Machines","Water Leaks","Visualizations","Treasure Hunt Form","Conversion Factors","Education Material","E-factors"],"not_rendered":{"charts":9,"images":26,"macros":1,"external_links":0,"defined_names":43,"comments":32,"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":"License Agreement","index":0,"n_rows":107,"n_cols":3,"rows_kept":107,"cut":false,"hidden":false,"merged":[[23,1,23,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[1,0,1,2],[5,0,5,2],[3,1,3,2],[7,1,7,2],[21,0,21,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[84,0,84,2],[94,0,94,2],[99,0,99,2],[0,0,0,2],[48,1,48,2],[62,1,62,2],[64,1,64,2],[69,0,69,2],[71,0,71,2],[78,0,78,2],[18,1,18,2],[19,1,19,2],[38,1,38,2],[44,0,44,2],[46,0,46,2],[12,1,12,2]]}
["General Motors Creative Common License Agreement"]
["Attribution-ShareAlike 4.0 International"]
[]
[null,"By exercising the Licensed Rights (defined below), You accept and agree to be bound by the terms and conditions of this Creative Commons Attribution-ShareAlike 4.0 International Public License (\"Public License\"). To the extent this Public License may be interpreted as a contract, You are granted the Licensed Rights in consideration of Your acceptance of these terms and conditions, and the Licensor grants You such rights in consideration of benefits the Licensor receives from making the Licensed Material available under these terms and conditions."]
[]
["Section 1 – Definitions."]
[]
["a.","Adapted Material means material subject to Copyright and Similar Rights that is derived from or based upon the Licensed Material and in which the Licensed Material is translated, altered, arranged, transformed, or otherwise modified in a manner requiring permission under the Copyright and Similar Rights held by the Licensor. For purposes of this Public License, where the Licensed Material is a musical work, performance, or sound recording, Adapted Material is always produced where the Licensed Material is synched in timed relation with a moving image."]
["b.","Adapter's License means the license You apply to Your Copyright and Similar Rights in Your contributions to Adapted Material in accordance with the terms and conditions of this Public License."]
["c.","BY-SA Compatible License means a license listed at creativecommons.org/compatiblelicenses , approved by Creative Commons as essentially the equivalent of this Public License."]
["d.","Copyright and Similar Rights means copyright and/or similar rights closely related to copyright including, without limitation, performance, broadcast, sound recording, and Sui Generis Database Rights, without regard to how the rights are labeled or categorized. For purposes of this Public License, the rights specified in Section 2(b)(1)-(2) are not Copyright and Similar Rights."]
["e.","Effective Technological Measures means those measures that, in the absence of proper authority, may not be circumvented under laws fulfilling obligations under Article 11 of the WIPO Copyright Treaty adopted on December 20, 1996, and/or similar international agreements."]
["f.","Exceptions and Limitations means fair use, fair dealing, and/or any other exception or limitation to Copyright and Similar Rights that applies to Your use of the Licensed Material."]
["g.","License Elements means the license attributes listed in the name of a Creative Commons Public License. The License Elements of this Public License are Attribution and ShareAlike."]
["h","Licensed Material means the artistic or literary work, database, or other material to which the Licensor applied this Public License."]
["i.","Licensed Rights means the rights granted to You subject to the terms and conditions of this Public License, which are limited to all Copyright and Similar Rights that apply to Your use of the Licensed Material and that the Licensor has authority to license."]
["j.","Licensor means the individual(s) or entity(ies) granting rights under this Public License."]
["k.","Share means to provide material to the public by any means or process that requires permission under the Licensed Rights, such as reproduction, public display, public performance, distribution, dissemination, communication, or importation, and to make material available to the public including in ways that members of the public may access the material from a place and at a time individually chosen by them."]
["l.","Sui Generis Database Rights means rights other than copyright resulting from Directive 96/9/EC of the European Parliament and of the Council of 11 March 1996 on the legal protection of databases, as amended and/or succeeded, as well as other essentially equivalent rights anywhere in the world."]
["m.","You means the individual or entity exercising the Licensed Rights under this Public License. Your has a corresponding meaning."]
[]
["Section 2 – Scope."]
[]
["a.","License grant ."]
[]
[null,1,"Subject to the terms and conditions of this Public License, the Licensor hereby grants You a worldwide, royalty-free, non-sublicensable, non-exclusive, irrevocable license to exercise the Licensed"]
[null,null,"Rights in the Licensed Material to:"]
[null,null,"A. reproduce and Share the Licensed Material, in whole or in part; and"]
[null,null,"B. produce, reproduce, and Share Adapted Material."]
[null,2,"Exceptions and Limitations . For the avoidance of doubt, where Exceptions and Limitations apply to Your use, this Public License does not apply, and You do not need to comply with its terms and conditions."]
[null,3,"Term . The term of this Public License is specified in Section 6(a) ."]
[null,4,"Media and formats; technical modifications allowed . The Licensor authorizes You to exercise the Licensed Rights in all media and formats whether now known or hereafter created, and to make technical modifications necessary to do so. The Licensor waives and/or agrees not to assert any right or authority to forbid You from making technical modifications necessary to exercise the Licensed Rights, including technical modifications necessary to circumvent Effective Technological Measures. For purposes of this Public License, simply making modifications authorized by this Section 2(a)(4) never produces Adapted Material."]
[null,5,"Downstream recipients ."]
[null,null,"A. Offer from the Licensor – Licensed Material . Every recipient of the Licensed Material automatically receives an offer from the Licensor to exercise the Licensed Rights under the terms and conditions of this Public License."]
[null,null,"B. Additional offer from the Licensor – Adapted Material . Every recipient of Adapted Material from You automatically receives an offer from the Licensor to exercise the Licensed Rights in the Adapted Material under the conditions of the Adapter’s License You apply."]
[null,null,"C. No downstream restrictions . You may not offer or impose any additional or different terms or conditions on, or apply any Effective Technological Measures to, the Licensed Material if doing so restricts exercise of the Licensed Rights by any recipient of the Licensed Material."]
[null,6,"No endorsement . Nothing in this Public License constitutes or may be construed as permission to assert or imply that You are, or that Your use of the Licensed Material is, connected with, or sponsored, endorsed, or granted official status by, the Licensor or others designated to receive attribution as provided in Section 3(a)(1)(A)(i) ."]
[]
["b.","Other rights ."]
[]
[null,1,"Moral rights, such as the right of integrity, are not licensed under this Public License, nor are publicity, privacy, and/or other similar personality rights; however, to the extent possible, the Licensor waives and/or agrees not to assert any such rights held by the Licensor to the limited extent necessary to allow You to exercise the Licensed Rights, but not otherwise."]
[null,2,"Patent and trademark rights are not licensed under this Public License."]
[null,3,"To the extent possible, the Licensor waives any right to collect royalties from You for the exercise of the Licensed Rights, whether directly or through a collecting society under any voluntary or waivable statutory or compulsory licensing scheme. In all other cases the Licensor expressly reserves any right to collect such royalties."]
[]
["Section 3 – License Conditions."]
[]
["Your exercise of the Licensed Rights is expressly made subject to the following conditions."]
[]
["a.","Attribution."]
[]
[null,1,"If You Share the Licensed Material (including in modified form), You must:"]
[null,null,"A. retain the following if it is supplied by the Licensor with the Licensed Material:"]
[null,null,"i. identification of the creator(s) of the Licensed Material and any others designated to receive attribution, in any reasonable manner requested by the Licensor (including by pseudonym if designated);"]
[null,null,"ii. a copyright notice;"]
[null,null,"iii. a notice that refers to this Public License;"]
[null,null,"iv. a notice that refers to the disclaimer of warranties;"]
[null,null,"v. a URI or hyperlink to the Licensed Material to the extent reasonably practicable;"]
[null,null,"B. indicate if You modified the Licensed Material and retain an indication of any previous modifications; and"]
[null,null,"C. indicate the Licensed Material is licensed under this Public License, and include the text of, or the URI or hyperlink to, this Public License."]
[null,2,"You may satisfy the conditions in Section 3(a)(1) in any reasonable manner based on the medium, means, and context in which You Share the Licensed Material. For example, it may be reasonable to satisfy the conditions by providing a URI or hyperlink to a resource that includes the required information."]
[null,3,"If requested by the Licensor, You must remove any of the information required by Section 3(a)(1)(A) to the extent reasonably practicable."]
[]
["b.","ShareAlike ."]
[]
[null,"In addition to the conditions in Section 3(a) , if You Share Adapted Material You produce, the following conditions also apply."]
[null,1,"The Adapter’s License You apply must be a Creative Commons license with the same License Elements, this version or later, or a BY-SA Compatible License."]
[null,2,"You must include the text of, or the URI or hyperlink to, the Adapter's License You apply. You may satisfy this condition in any reasonable manner based on the medium, means, and context in which You Share Adapted Material."]
[null,3,"You may not offer or impose any additional or different terms or conditions on, or apply any Effective Technological Measures to, Adapted Material that restrict exercise of the rights granted under the Adapter's License You apply."]
[]
["Section 4 – Sui Generis Database Rights."]
[]
["Where the Licensed Rights include Sui Generis Database Rights that apply to Your use of the Licensed Material:"]
[]
[null,"a.","for the avoidance of doubt, Section 2(a)(1) grants You the right to extract, reuse, reproduce, and Share all or a substantial portion of the contents of the database;"]
[null,"b.","if You include all or a substantial portion of the database contents in a database in which You have Sui Generis Database Rights, then the database in which You have Sui Generis Database Rights (but not its individual contents) is Adapted Material, including for purposes of Section 3(b) ; and"]
[null,"c.","You must comply with the conditions in Section 3(a) if You Share all or a substantial portion of the contents of the database."]
[null,null,"For the avoidance of doubt, this Section 4 supplements and does not replace Your obligations under this Public License where the Licensed Rights include other Copyright and Similar Rights."]
[]
["Section 5 – Disclaimer of Warranties and Limitation of Liability."]
[]
[null,"a.","Unless otherwise separately undertaken by the Licensor, to the extent possible, the Licensor offers the Licensed Material as-is and as-available, and makes no representations or warranties of any kind concerning the Licensed Material, whether express, implied, statutory, or other. This includes, without limitation, warranties of title, merchantability, fitness for a particular purpose, non-infringement, absence of latent or other defects, accuracy, or the presence or absence of errors, whether or not known or discoverable. Where disclaimers of warranties are not allowed in full or in part, this disclaimer may not apply to You."]
[null,"b.","To the extent possible, in no event will the Licensor be liable to You on any legal theory (including, without limitation, negligence) or otherwise for any direct, special, indirect, incidental, consequential, punitive, exemplary, or other losses, costs, expenses, or damages arising out of this Public License or use of the Licensed Material, even if the Licensor has been advised of the possibility of such losses, costs, expenses, or damages. Where a limitation of liability is not allowed in full or in part, this limitation may not apply to You."]
[null,"c.","The disclaimer of warranties and limitation of liability provided above shall be interpreted in a manner that, to the extent possible, most closely approximates an absolute disclaimer and waiver of all liability."]
[]
["Section 6 – Term and Termination."]
[]
[null,"a.","This Public License applies for the term of the Copyright and Similar Rights licensed here. However, if You fail to comply with this Public License, then Your rights under this Public License terminate automatically."]
[null,"b.","Where Your right to use the Licensed Material has terminated under Section 6(a), it reinstates:"]
[null,null,"1. automatically as of the date the violation is cured, provided it is cured within 30 days of Your discovery of the violation; or"]
[null,null,"2. upon express reinstatement by the Licensor."]
[null,null,"For the avoidance of doubt, this Section 6(b) does not affect any right the Licensor may have to seek remedies for Your violations of this Public License."]
[null,"c.","For the avoidance of doubt, the Licensor may also offer the Licensed Material under separate terms or conditions or stop distributing the Licensed Material at any time; however, doing so will not terminate this Public License."]
[null,"d.","Sections 1 , 5 , 6 , 7 , and 8 survive termination of this Public License."]
[]
["Section 7 – Other Terms and Conditions."]
[]
[null,"a.","The Licensor shall not be bound by any additional or different terms or conditions communicated by You unless expressly agreed."]
[null,"b.","Any arrangements, understandings, or agreements regarding the Licensed Material not stated herein are separate from and independent of the terms and conditions of this Public License."]
[]
["Section 8 – Interpretation."]
[]
[null,"a.","For the avoidance of doubt, this Public License does not, and shall not be interpreted to, reduce, limit, restrict, or impose conditions on any use of the Licensed Material that could lawfully be made without permission under this Public License."]
[null,"b.","To the extent possible, if any provision of this Public License is deemed unenforceable, it shall be automatically reformed to the minimum extent necessary to make it enforceable. If the provision cannot be reformed, it shall be severed from this Public License without affecting the enforceability of the remaining terms and conditions."]
[null,"c.","No term or condition of this Public License will be waived and no failure to comply consented to unless expressly agreed to by the Licensor."]
[null,"d.","Nothing in this Public License constitutes or may be interpreted as a limitation upon, or waiver of, any privileges and immunities that apply to the Licensor or You, including from the legal processes of any jurisdiction or authority."]
[]
[null,null,"© 2022 General Motors"]

{"sheet":"Index","index":1,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,11,49,14],[1,1,1,6],[2,8,3,8],[5,8,7,8],[2,9,8,13],[11,9,16,13],[18,5,21,6],[22,5,44,6]]}
[]
[null,"Worksheet Index ",null,null,null,null,null,null,"Instructions "]
[null,null,null,null,null,null,null,null,1,"Identify which of the modules are applicable to the specific GM Treasure Maps analysis by selecting \"Applicable\" or \"Not Applicable. This will populate the appropriate tabs for your evaluation. Please note, tabs identified as \"Standard\" will be kept populated at all times. "]
[null,"Site Data ","Applicable/Not Applicable ","Module #",null,"Facility Information "]
[null,"Copyright Licensing Agreement","Standard ","Worksheet",null,"Start Date of Treasure Maps","<Insert Date>"]
[null,"Site Information","Standard ","Worksheet",null,"Organization Name","<Insert Org Name>"]
[null,"Water Balance ","Standard ","Worksheet",null,"Site Name ","<Insert Site Name>"]
[null,"Virtual Energy","Standard ","Worksheet",null,"Site Sector ","<Insert Site Sector>"]
[null,null,null,null,null,"Facility type (dropdown)","Industrial"]
[null,"VTH Summary Tabs",null,null,null,"Street Address","<Insert Street Address>"]
[null,"Treasure Maps Summary","Standard ","Worksheet",null,"City","<Insert City>"]
[null,null,null,null,null,"State/Province (dropdown)","MI",null,2,"Each calculation tab will have standard cells highlighted in light red that will need to be populated with facility specific data. Once completed, calculations will be automatically generated to use as estimates for the action plan summary detail. "]
[null,"Energy",null,null,null,"Zip Code","<Insert Zip Code>"]
[null,"Building Envelope Leaks","Applicable","Worksheet",null,"Contact Name ","<Insert Contact Name>"]
[null,"Compressed Air Pressure Reduction","Applicable","Worksheet",null,"Contact Email","<Insert Contact Email>"]
[null,"Compressed Air Leaks","Applicable","Worksheet",null,"Number of employees","<Insert # employees>"]
[null,"Energy Star - Vending Machines","Applicable","Worksheet",null,"Site Google Map Image","<Insert Below>"]
[null,"Energy Star - Water Cooler","Applicable","Worksheet"]
[null,"Energy Star - Refrigerator","Applicable ","Worksheet",null,"Disclaimer"]
[null,"Energy Star - Coffee Machine","Applicable","Worksheet"]
[null,"Fans","Applicable","Worksheet"]
[null,"Groove Belts","Applicable","Worksheet"]
[null,"HVAC Temperature Setbacks","Applicable","Worksheet",null,"GM is providing this tool to help its suppliers identify potential energy and cost savings. These potential saving are estimates only, and can fluctuate based on energy prices and other factors. By sharing this tool, GM does not assume any liability for any particular energy or cost saving estimates. By using this tool, supplier assumes all liability for the information put into the tool, and for any energy or cost savings estimated by the tool. "]
[null,"LED Lighting","Applicable","Worksheet"]
[null,"Delamping","Applicable","Worksheet"]
[null,"Occupancy Sensor Power Strips - Office Cubicles","Applicable","Worksheet"]
[null,"Occupancy Sensor Power Strips - Workstation","Applicable","Worksheet"]
[null,"Machine Sleep","Applicable","Worksheet"]
[null,"Panel Cooler","Applicable","Worksheet"]
[null,"VFDs","Applicable","Worksheet"]
[]
[null,"Water "]
[null,"Ice Machines","Applicable","Worksheet"]
[null,"Water Leaks","Applicable","Worksheet"]
[]
[null,"Conclusion"]
[null,"Visuals - Leadership Presentation Template","Standard","Worksheet"]
[null,"EPA Treasure Hunt Submission","Standard","Worksheet"]
[]
[null,"Resources"]
[null,"Metrics Conversion Table","Standard ","Worksheet"]
[null,"Education Material","Standard ","Worksheet",null,null,null,null,"Applicable",null,"Industrial"]
[null,"Emission Factors","Standard ","Worksheet",null,null,null,null,"Non Applicable",null,"Commercial"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Site Information","index":2,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,3],[17,3,17,9],[30,19,30,20],[18,9,21,9],[18,8,21,8],[18,7,21,7],[18,6,21,6],[19,3,21,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scope 2 Factor ","Scope 1 Factor "]
[null,"Site Utility Data ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(Index!$G$12,'E-factors'!B8:B73,'E-factors'!J8:J73,'E-factors'!J60)","v":0.45826907375487613},{"$f":"_xlfn.XLOOKUP(Index!$G$12,'E-factors'!B8:B73,'E-factors'!K8:K73,'E-factors'!K60)","v":0.1961076158753793}]
[null,"MonthNumber","Production Units (total units/month)","Production Hours (total hours/month)","Electricity (Mwh)","Electricity (USD) ","Electricity (USD/MWh) ","Natural Gas (Mcf)","Natural Gas (MWh)","Natural Gas  (USD)","Natural Gas (USD/MWh)","Water (M3)","Water (USD)","Water (USD/M3)","CDD (F)","HDD (F)","Intensity - Electricity (MWh)/Unit","Intensity - Natural Gas (MWh)/Unit","Intensity - Water (M3)/Unit","MT CO2e - Electricity","MT CO2e - Natural Gas"]
[null,"2023-01-01",null,null,null,null,{"$f":"IFERROR(E5/F5,0)","v":0},null,{"$f":"IFERROR((H5*0.29),0)","v":0},null,{"$f":"IFERROR(J5/I5,0)","v":0},null,null,{"$f":"IFERROR(M5/L5,0)","v":0},0,0,{"$f":"IFERROR(E5/C5,0)","v":0},{"$f":"IFERROR(I5/C5,0)","v":0},{"$f":"IFERROR(L5/C5,0)","v":0},{"$f":"IFERROR(E5*$T$3,0)","v":0},{"$f":"IFERROR(I5*$U$3,0)","v":0}]
[null,"2023-02-01",null,null,null,null,{"$f":"IFERROR(E6/F6,0)","v":0},null,{"$f":"IFERROR((H6*0.29),0)","v":0},null,{"$f":"IFERROR(J6/I6,0)","v":0},null,null,{"$f":"IFERROR(M6/L6,0)","v":0},0,0,{"$f":"IFERROR(E6/C6,0)","v":0},0,{"$f":"IFERROR(L6/C6,0)","v":0},{"$f":"IFERROR(E6*$T$3,0)","v":0},{"$f":"IFERROR(I6*$U$3,0)","v":0}]
[null,"2023-03-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-04-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-05-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-06-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-07-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-08-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-09-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-10-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-11-01",null,null,null,null,0,null,0,null,0,null,null,0,0,0,0,0,0,0,0]
[null,"2023-12-01",null,null,null,null,0,null,0,null,{"$f":"IFERROR(J16/I16,0)","v":0},null,null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Summary & Cost"]
[null,null,null,null,"12 Month Total ","Unit ","Cost ","Unit ","Intensity ","Unit "]
[null,null,null,"Production",{"$f":"SUM(C5:C16)","v":0},"Count/yr"]
[null,null,null,null,{"$f":"SUM(D5:D16)","v":0},"Hours/yr"]
[null,null,null,null,{"$f":"IFERROR(AVERAGE(D5:D16),0)","v":0},"Hours/month (avg)"]
[null,null,null,"Electricity ",{"$f":"SUM(E5:E16)","v":0},"MWh/yr",{"$f":"IFERROR(SUM(F5:F16)/E23,0)","v":0},"$/Mwh",{"$f":"IFERROR(E23/$E$14,0)","v":0},"Mwh/unit "]
[null,null,null,"Natural Gas ",{"$f":"SUM(I5:I16)","v":0},"MWh/yr",{"$f":"IFERROR(SUM(J5:J16)/E24,0)","v":0},"$/Mwh",{"$f":"IFERROR(E24/$E$14,0)","v":0},"Mwh/unit"]
[null,null,null,"Water",{"$f":"SUM(L5:L16)","v":0},"M3/yr",{"$f":"IFERROR(SUM(M5:M16)/E25,0)","v":0},"$/M3",{"$f":"IFERROR(E25/$E$14,)","v":0},"M3/unit"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Water Balance","index":3,"n_rows":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,16,19,18],[1,2,1,3],[2,3,2,4],[2,5,2,12],[2,13,2,14],[2,15,2,18]]}
[]
[null,null,"Site Water Data"]
[null,null,null,"Supply/Input Water (M3)",null,"Process Water (M3)",null,null,null,null,null,null,null,"Water Reuse (M3)",null,"Balance (M3)"]
[null,"Month","Production Units","City ","Surface & Ground","Sanitation ","Swamp Cooler","Boiler ","Cooling Tower ","WWTP","Humidification ","Fire Protection ","Insert Other","Stormwater ","WWTP","Process Usage ","Water Supply ","Reuse ","Variance"]
[null,{"$f":"'Site Information'!B5","v":"2023-01-01"},{"$f":"'Site Information'!C5","v":0},{"$f":"'Site Information'!M5","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F5:M5),\"\")","v":0},{"$f":"SUM(D5:E5)","v":0},{"$f":"SUM(N5:O5)","v":0},{"$f":"IFERROR((Q5-P5)/Q5,\"\")","v":""}]
[null,{"$f":"'Site Information'!B6","v":"2023-02-01"},{"$f":"'Site Information'!C6","v":0},{"$f":"'Site Information'!M6","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F6:M6),\"\")","v":0},{"$f":"SUM(D6:E6)","v":0},{"$f":"SUM(N6:O6)","v":0},{"$f":"IFERROR((Q6-P6)/Q6,\"\")","v":""}]
[null,{"$f":"'Site Information'!B7","v":"2023-03-01"},{"$f":"'Site Information'!C7","v":0},{"$f":"'Site Information'!M7","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B8","v":"2023-04-01"},{"$f":"'Site Information'!C8","v":0},{"$f":"'Site Information'!M8","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B9","v":"2023-05-01"},{"$f":"'Site Information'!C9","v":0},{"$f":"'Site Information'!M9","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B10","v":"2023-06-01"},{"$f":"'Site Information'!C10","v":0},{"$f":"'Site Information'!M10","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B11","v":"2023-07-01"},{"$f":"'Site Information'!C11","v":0},{"$f":"'Site Information'!M11","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B12","v":"2023-08-01"},{"$f":"'Site Information'!C12","v":0},{"$f":"'Site Information'!M12","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B13","v":"2023-09-01"},{"$f":"'Site Information'!C13","v":0},{"$f":"'Site Information'!M13","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B14","v":"2023-10-01"},{"$f":"'Site Information'!C14","v":0},{"$f":"'Site Information'!M14","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B15","v":"2023-11-01"},{"$f":"'Site Information'!C15","v":0},{"$f":"'Site Information'!M15","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,{"$f":"'Site Information'!B16","v":"2023-12-01"},{"$f":"'Site Information'!C16","v":0},{"$f":"'Site Information'!M16","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"SUM(P5:P16)","v":0},{"$f":"SUM(Q5:Q16)","v":0},{"$f":"SUM(R5:R16)","v":0},{"$f":"IFERROR((Q17-P17)/Q17,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Virtual Energy","index":4,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,6],[20,1,20,6],[36,1,36,6],[52,19,52,24]]}
[]
[null,"Data Analysis "]
[null,"Fuel "]
[null,"Month","CDD or HDD","HDD Value","CDD Value","Production ","Total Fuel (Mwh)"]
[null,"2020-09-19","CDD",{"$f":"IF(C5=\"HDD\",'Site Information'!$P$5,0)","v":0},{"$f":"IF(C5=\"CDD\",'Site Information'!$O$5,0)","v":0},{"$f":"'Site Information'!C5","v":0},{"$f":"'Site Information'!I5","v":0}]
[null,"2020-10-19","HDD",{"$f":"IF(C6=\"HDD\",'Site Information'!$P$6,0)","v":0},{"$f":"IF(C6=\"CDD\",'Site Information'!$O$6,0)","v":0},{"$f":"'Site Information'!C6","v":0},{"$f":"'Site Information'!I6","v":0}]
[null,"2020-11-19","HDD",{"$f":"IF(C7=\"HDD\",'Site Information'!P7,0)","v":0},{"$f":"IF(C7=\"CDD\",'Site Information'!$O$7,0)","v":0},{"$f":"'Site Information'!C7","v":0},{"$f":"'Site Information'!I7","v":0}]
[null,"2020-12-19","HDD",{"$f":"IF(C8=\"HDD\",'Site Information'!$P$8,0)","v":0},{"$f":"IF(C8=\"CDD\",'Site Information'!$O$8,0)","v":0},{"$f":"'Site Information'!C8","v":0},{"$f":"'Site Information'!I8","v":0}]
[null,"2020-01-20","HDD",{"$f":"IF(C9=\"HDD\",'Site Information'!$P$9,0)","v":0},{"$f":"IF(C9=\"CDD\",'Site Information'!$O$9,0)","v":0},{"$f":"'Site Information'!C9","v":0},{"$f":"'Site Information'!I9","v":0}]
[null,"2020-02-20","HDD",{"$f":"IF(C10=\"HDD\",'Site Information'!$P$10,0)","v":0},{"$f":"IF(C10=\"CDD\",'Site Information'!$O$10,0)","v":0},{"$f":"'Site Information'!C10","v":0},{"$f":"'Site Information'!I10","v":0}]
[null,"2020-03-20","HDD",{"$f":"IF(C11=\"HDD\",'Site Information'!$P$11,0)","v":0},{"$f":"IF(C11=\"CDD\",'Site Information'!$O$11,0)","v":0},{"$f":"'Site Information'!C11","v":0},{"$f":"'Site Information'!I11","v":0}]
[null,"2020-04-20","CDD",{"$f":"IF(C12=\"HDD\",'Site Information'!$P$12,0)","v":0},{"$f":"IF(C12=\"CDD\",'Site Information'!$O$12,0)","v":0},{"$f":"'Site Information'!C12","v":0},{"$f":"'Site Information'!I12","v":0}]
[null,"2020-05-20","CDD",{"$f":"IF(C13=\"HDD\",'Site Information'!$P$13,0)","v":0},{"$f":"IF(C13=\"CDD\",'Site Information'!$O$13,0)","v":0},{"$f":"'Site Information'!C13","v":0},{"$f":"'Site Information'!I13","v":0}]
[null,"2020-06-20","CDD",{"$f":"IF(C14=\"HDD\",'Site Information'!$P$14,0)","v":0},{"$f":"IF(C14=\"CDD\",'Site Information'!$O$14,0)","v":0},{"$f":"'Site Information'!C14","v":0},{"$f":"'Site Information'!I14","v":0}]
[null,"2020-07-20","CDD",{"$f":"IF(C15=\"HDD\",'Site Information'!$P$15,0)","v":0},{"$f":"IF(C15=\"CDD\",'Site Information'!$O$15,0)","v":0},{"$f":"'Site Information'!C15","v":0},{"$f":"'Site Information'!I15","v":0}]
[null,"2020-08-20","CDD",{"$f":"IF(C16=\"HDD\",'Site Information'!$P$16,0)","v":0},{"$f":"IF(C16=\"CDD\",'Site Information'!$O$16,0)","v":0},{"$f":"'Site Information'!C16","v":0},{"$f":"'Site Information'!I16","v":0}]
[]
["HDD"]
["CDD"]
[]
[null,"Electricity "]
[null,"Month","CDD or HDD","HDD Value","CDD Value","Production ","Total Electrcity (Mwh)"]
[null,"2020-09-19","CDD",{"$f":"IF(C23=\"HDD\",'Site Information'!$P$5,0)","v":0},{"$f":"IF(C23=\"CDD\",'Site Information'!$O$5,0)","v":0},{"$f":"'Site Information'!C5","v":0},{"$f":"'Site Information'!G5","v":0}]
[null,"2020-10-19","HDD",{"$f":"IF(C24=\"HDD\",'Site Information'!$P$6,0)","v":0},{"$f":"IF(C24=\"CDD\",'Site Information'!$O$6,0)","v":0},{"$f":"'Site Information'!C6","v":0},{"$f":"'Site Information'!G6","v":0}]
[null,"2020-11-19","HDD",{"$f":"IF(C25=\"HDD\",'Site Information'!Q27,0)","v":0},{"$f":"IF(C25=\"CDD\",'Site Information'!$O$7,0)","v":0},{"$f":"'Site Information'!C7","v":0},{"$f":"'Site Information'!G7","v":0}]
[null,"2020-12-19","HDD",{"$f":"IF(C26=\"HDD\",'Site Information'!$P$8,0)","v":0},{"$f":"IF(C26=\"CDD\",'Site Information'!$O$8,0)","v":0},{"$f":"'Site Information'!C8","v":0},{"$f":"'Site Information'!G8","v":0}]
[null,"2020-01-20","HDD",{"$f":"IF(C27=\"HDD\",'Site Information'!$P$9,0)","v":0},{"$f":"IF(C27=\"CDD\",'Site Information'!$O$9,0)","v":0},{"$f":"'Site Information'!C9","v":0},{"$f":"'Site Information'!G9","v":0}]
[null,"2020-02-20","HDD",{"$f":"IF(C28=\"HDD\",'Site Information'!$P$10,0)","v":0},{"$f":"IF(C28=\"CDD\",'Site Information'!$O$10,0)","v":0},{"$f":"'Site Information'!C10","v":0},{"$f":"'Site Information'!G10","v":0}]
[null,"2020-03-20","HDD",{"$f":"IF(C29=\"HDD\",'Site Information'!$P$11,0)","v":0},{"$f":"IF(C29=\"CDD\",'Site Information'!$O$11,0)","v":0},{"$f":"'Site Information'!C11","v":0},{"$f":"'Site Information'!G11","v":0}]
[null,"2020-04-20","CDD",{"$f":"IF(C30=\"HDD\",'Site Information'!$P$12,0)","v":0},{"$f":"IF(C30=\"CDD\",'Site Information'!$O$12,0)","v":0},{"$f":"'Site Information'!C12","v":0},{"$f":"'Site Information'!G12","v":0}]
[null,"2020-05-20","CDD",{"$f":"IF(C31=\"HDD\",'Site Information'!$P$13,0)","v":0},{"$f":"IF(C31=\"CDD\",'Site Information'!$O$13,0)","v":0},{"$f":"'Site Information'!C13","v":0},{"$f":"'Site Information'!G13","v":0}]
[null,"2020-06-20","CDD",{"$f":"IF(C32=\"HDD\",'Site Information'!$P$14,0)","v":0},{"$f":"IF(C32=\"CDD\",'Site Information'!$O$14,0)","v":0},{"$f":"'Site Information'!C14","v":0},{"$f":"'Site Information'!G14","v":0}]
[null,"2020-07-20","CDD",{"$f":"IF(C33=\"HDD\",'Site Information'!$P$15,0)","v":0},{"$f":"IF(C33=\"CDD\",'Site Information'!$O$15,0)","v":0},{"$f":"'Site Information'!C15","v":0},{"$f":"'Site Information'!G15","v":0}]
[null,"2020-08-20","CDD",{"$f":"IF(C34=\"HDD\",'Site Information'!$P$16,0)","v":0},{"$f":"IF(C34=\"CDD\",'Site Information'!$O$16,0)","v":0},{"$f":"'Site Information'!C16","v":0},{"$f":"'Site Information'!G16","v":0}]
[]
[]
[null,"Water"]
[null,"Month","CDD or HDD","HDD Value","CDD Value","Production ","Total Water (M3)"]
[null,"2020-09-19","CDD",{"$f":"IF(C39=\"HDD\",'Site Information'!$P$5,0)","v":0},{"$f":"IF(C39=\"CDD\",'Site Information'!$O$5,0)","v":0},{"$f":"'Site Information'!C5","v":0},{"$f":"'Site Information'!M5","v":0}]
[null,"2020-10-19","HDD",{"$f":"IF(C40=\"HDD\",'Site Information'!$P$6,0)","v":0},{"$f":"IF(C40=\"CDD\",'Site Information'!$O$6,0)","v":0},{"$f":"'Site Information'!C6","v":0},{"$f":"'Site Information'!M6","v":0}]
[null,"2020-11-19","HDD",{"$f":"IF(C41=\"HDD\",'Site Information'!R31,0)","v":0},{"$f":"IF(C41=\"CDD\",'Site Information'!$O$7,0)","v":0},{"$f":"'Site Information'!C7","v":0},{"$f":"'Site Information'!M7","v":0}]
[null,"2020-12-19","HDD",{"$f":"IF(C42=\"HDD\",'Site Information'!$P$8,0)","v":0},{"$f":"IF(C42=\"CDD\",'Site Information'!$O$8,0)","v":0},{"$f":"'Site Information'!C8","v":0},{"$f":"'Site Information'!M8","v":0}]
[null,"2020-01-20","HDD",{"$f":"IF(C43=\"HDD\",'Site Information'!$P$9,0)","v":0},{"$f":"IF(C43=\"CDD\",'Site Information'!$O$9,0)","v":0},{"$f":"'Site Information'!C9","v":0},{"$f":"'Site Information'!M9","v":0}]
[null,"2020-02-20","HDD",{"$f":"IF(C44=\"HDD\",'Site Information'!$P$10,0)","v":0},{"$f":"IF(C44=\"CDD\",'Site Information'!$O$10,0)","v":0},{"$f":"'Site Information'!C10","v":0},{"$f":"'Site Information'!M10","v":0}]
[null,"2020-03-20","HDD",{"$f":"IF(C45=\"HDD\",'Site Information'!$P$11,0)","v":0},{"$f":"IF(C45=\"CDD\",'Site Information'!$O$11,0)","v":0},{"$f":"'Site Information'!C11","v":0},{"$f":"'Site Information'!M11","v":0}]
[null,"2020-04-20","CDD",{"$f":"IF(C46=\"HDD\",'Site Information'!$P$12,0)","v":0},{"$f":"IF(C46=\"CDD\",'Site Information'!$O$12,0)","v":0},{"$f":"'Site Information'!C12","v":0},{"$f":"'Site Information'!M12","v":0}]
[null,"2020-05-20","CDD",{"$f":"IF(C47=\"HDD\",'Site Information'!$P$13,0)","v":0},{"$f":"IF(C47=\"CDD\",'Site Information'!$O$13,0)","v":0},{"$f":"'Site Information'!C13","v":0},{"$f":"'Site Information'!M13","v":0}]
[null,"2020-06-20","CDD",{"$f":"IF(C48=\"HDD\",'Site Information'!$P$14,0)","v":0},{"$f":"IF(C48=\"CDD\",'Site Information'!$O$14,0)","v":0},{"$f":"'Site Information'!C14","v":0},{"$f":"'Site Information'!M14","v":0}]
[null,"2020-07-20","CDD",{"$f":"IF(C49=\"HDD\",'Site Information'!$P$15,0)","v":0},{"$f":"IF(C49=\"CDD\",'Site Information'!$O$15,0)","v":0},{"$f":"'Site Information'!C15","v":0},{"$f":"'Site Information'!M15","v":0}]
[null,"2020-08-20","CDD",{"$f":"IF(C50=\"HDD\",'Site Information'!$P$16,0)","v":0},{"$f":"IF(C50=\"CDD\",'Site Information'!$O$16,0)","v":0},{"$f":"'Site Information'!C16","v":0},{"$f":"'Site Information'!M16","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Treasure Map","index":5,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,2,2],[22,4,22,5],[23,4,23,5],[24,4,24,5],[11,4,11,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[18,4,18,5],[4,5,5,5],[3,1,3,7],[4,4,5,4],[4,6,5,6],[4,7,5,7],[33,14,33,15],[10,4,10,5],[21,4,21,5],[20,4,20,5],[16,4,16,5],[12,4,12,5],[17,4,17,5],[26,4,26,5],[30,4,30,5],[31,4,31,5],[27,4,27,5],[25,4,25,5],[29,4,29,5],[28,4,28,5],[19,4,19,5]]}
[]
[null,null,null,"Site Name:","Site Sector:"]
[null,null,null,{"$f":"Index!G7","v":"<Insert Site Name>"},{"$f":"Index!G8","v":"<Insert Site Sector>"}]
[null,"Summary & Cost",null,null,null,null,null,null,"Grand Total Cost (USD)","Grand Total Savings (USD)  Per Year","Total Payback Period (Years) ","Grand Total Electricity Savings (Mwh) Per Year","Grand Total Water Savings (M3) Per Year","Grand Total Methane/Propane (Mwh) Per Year","Grand Total Scope 2 Emissions Saved (Mt CO2e) Per Year","Grand Total Scope 1 Emissions Saved (Mt CO2e) Per Year"]
[null,null,"12 Month Total ","Unit ","Cost ","Unit ","Intensity ","Unit ",{"$f":"SUBTOTAL(9,I12:I30)","v":0},{"$f":"SUBTOTAL(9,J12:J30)","v":0},{"$f":"IFERROR(I5/J5,\"\")","v":""},{"$f":"SUBTOTAL(9,L12:L30)","v":0},{"$f":"SUBTOTAL(9,M12:M30)","v":0},{"$f":"SUBTOTAL(9,N12:N30)","v":0},{"$f":"SUBTOTAL(9,O12:O30)","v":0},{"$f":"SUBTOTAL(9,P12:P30)","v":0}]
[null,{"$f":"'Site Information'!D20","v":"Production"},{"$f":"'Site Information'!E20","v":0},{"$f":"'Site Information'!F20","v":"Count/yr"}]
[null,{"$f":"'Site Information'!D23","v":"Electricity "},{"$f":"'Site Information'!E23","v":0},{"$f":"'Site Information'!F23","v":"MWh/yr"},{"$f":"'Site Information'!G23","v":0},{"$f":"'Site Information'!H23","v":"$/Mwh"},{"$f":"'Site Information'!I23","v":0},{"$f":"'Site Information'!J23","v":"Mwh/unit "}]
[null,{"$f":"'Site Information'!D24","v":"Natural Gas "},{"$f":"'Site Information'!E24","v":0},{"$f":"'Site Information'!F24","v":"MWh/yr"},{"$f":"'Site Information'!G24","v":0},{"$f":"'Site Information'!H24","v":"$/Mwh"},{"$f":"'Site Information'!I24","v":0},{"$f":"'Site Information'!J24","v":"Mwh/unit"},null,"`"]
[null,{"$f":"'Site Information'!D25","v":"Water"},{"$f":"'Site Information'!E25","v":0},{"$f":"'Site Information'!F25","v":"M3/yr"},{"$f":"'Site Information'!G25","v":0},{"$f":"'Site Information'!H25","v":"$/M3"},{"$f":"'Site Information'!I25","v":0},{"$f":"'Site Information'!J25","v":"M3/unit"}]
[]
[null,"Ref. No. ","Title","Current State","Future State",null,"Equipment","Energy Source","Total Cost (USD)","Total Savings (USD)","Payback (Years)","Electricity Savings (MWh)","Water (M3)","Propane/Methane (MWh)","Scope 2 Emissions Saved (Mt CO2e)","Scope 1 Emissions Saved (Mt CO2e)"]
[null,1.1,"Building Envelope Leaks","Door leaks or Dock doors left open during idle truck loading","Fixed leaks and close doors when Trailer is not being processed",null,"Doors","Electricity & Gas",{"$f":"IFERROR(,0)","v":0},{"$f":"IFERROR('Building Envelope Leaks'!$U$41,0)","v":0},{"$f":"IFERROR(I12/J12,\"-\")","v":"-"},{"$f":"('Building Envelope Leaks'!$V$39)","v":0},null,{"$f":"('Building Envelope Leaks'!$Q$39)","v":0},{"$f":"L12*'Site Information'!$T$3","v":0},{"$f":"N12*'Site Information'!$U$3","v":0}]
[null,{"$f":"B12+1","v":2.10},"Compressed Air Pressure Reduction","Current PSI ","Reduction in Psi (full system or by decoupling heavy loaded items)",null,"Compressed Air","Electricity",null,{"$f":"IFERROR('Compressed Air'!$L$20,0)","v":0},"-",{"$f":"('Compressed Air'!$K$20)","v":0},null,null,{"$f":"L13*'Site Information'!$T$3","v":0},{"$f":"N13*'Site Information'!$U$3","v":0}]
[null,{"$f":"B13+0.1","v":2.2},"Compressed Air Leaks","Air leaks are > 20% in a system","Reduce air leaks to world class 20%",null,"Compressed Air","Electricity",{"$f":"IFERROR(,0)","v":0},{"$f":"('Compressed Air'!$L$33)","v":0},{"$f":"IFERROR(I14/J14,\"-\")","v":"-"},{"$f":"('Compressed Air'!$K$33)","v":0},null,null,{"$f":"L14*'Site Information'!$T$3","v":0},{"$f":"N14*'Site Information'!$U$3","v":0}]
[null,3.10,"Energy Star - Vending Machines","Vending Machine (older models) non-Energy Star","Request and change out dated vending machines to \"Energy Star\"",null,"Vending","Electricity ",0,{"$f":"IFERROR('Energy Star Appliances'!$E$16,0)","v":0},{"$f":"IFERROR(I15/J15,\"-\")","v":"-"},{"$f":"('Energy Star Appliances'!$E$15)","v":0},null,null,{"$f":"L15*'Site Information'!$T$3","v":0},{"$f":"N15*'Site Information'!$U$3","v":0}]
[null,3.20,"Energy Star - Water Cooler","Water Cooler (older models) non-Energy Star","Request and change out dated water cooler to \"Energy Star\"",null,"Water Cooler","Electricity ",0,{"$f":"IFERROR(SUM('Energy Star Appliances'!$E$28,'Energy Star Appliances'!$K$28),0)","v":0},"-",{"$f":"SUM('Energy Star Appliances'!$E$27,'Energy Star Appliances'!$K$27)","v":0},null,null,{"$f":"L16*'Site Information'!$T$3","v":0},{"$f":"N16*'Site Information'!$U$3","v":0}]
[null,3.30,"Energy Star - Refrigerator","Refrigerator (older models) non-Energy Star","Request and change out dated refrigerator to \"Energy Star\"",null,"Refrigerator","Electricity ",0,{"$f":"SUM('Energy Star Appliances'!$E$40,'Energy Star Appliances'!$K$40)","v":0},"-",{"$f":"SUM('Energy Star Appliances'!$E$39,'Energy Star Appliances'!$K$39)","v":0},null,null,{"$f":"L17*'Site Information'!$T$3","v":0},{"$f":"N17*'Site Information'!$U$3","v":0}]
[null,3.40,"Energy Star - Coffee Maker","Coffee Maker (older models) non-Energy Star","Request and change out dated coffee maker to \"Energy Star\"",null,"Coffee Maker","Electricity ",{"$f":"IFERROR(,0)","v":0},{"$f":"'Energy Star Appliances'!$K$51","v":0},"-",{"$f":"('Energy Star Appliances'!$K$50)","v":0},null,null,{"$f":"L18*'Site Information'!$T$3","v":0},{"$f":"N18*'Site Information'!$U$3","v":0}]
[null,4.1,"Fans","No Timer switch ","Timing switch installed",null,"Fans","Electricity",{"$f":"IFERROR(Fans!$H$18,0)","v":0},{"$f":"IFERROR(Fans!$J$17,0)","v":0},"-",{"$f":"(Fans!$I$17)","v":0},null,null,{"$f":"L19*'Site Information'!$T$3","v":0},{"$f":"N19*'Site Information'!$U$3","v":0}]
[null,5.1,"Groove Belts","Straight belts ","Grooved belts",null,"Motors","Electricity ",{"$f":"IFERROR(,0)","v":0},{"$f":"IFERROR('Groove Belt'!$I$25,0)","v":0},"-",{"$f":"'Groove Belt'!$H$25","v":0},null,null,{"$f":"L20*'Site Information'!$T$3","v":0},{"$f":"N20*'Site Information'!$U$3","v":0}]
[null,6.10,"HVAC Set back thermostats (CDD)","Current Thermostat temperature","Reduce thermostat temperate by Delta x°",null,"Heating/Cooling","Electricity & Gas",null,{"$f":"IFERROR(HVAC!$K$18,\"\")","v":0},"-",null,null,{"$f":"(HVAC!$J$18)","v":0},{"$f":"L21*'Site Information'!$T$3","v":0},{"$f":"N21*'Site Information'!$U$3","v":0}]
[null,7.10,"LED Lighting","Fluorescent lights ","LED lights",null,"Lighting","Electricity",0,{"$f":"IFERROR('LED Lighting'!$J$35,0)","v":0},{"$f":"IFERROR(I22/J22,\"-\")","v":"-"},{"$f":"('LED Lighting'!$I$35)","v":0},null,null,{"$f":"L22*'Site Information'!$T$3","v":0},{"$f":"N22*'Site Information'!$U$3","v":0}]
[null,8.10,"Delamping","Current light candle","Reduction in candle light lumin on any fixtures that can support",null,"Lighting","Electricity ",0,{"$f":"IFERROR(Delamping!$J$25,0)","v":0},{"$f":"IFERROR(I23/J23,\"-\")","v":"-"},{"$f":"(Delamping!$I$25)","v":0},null,null,{"$f":"L23*'Site Information'!$T$3","v":0},{"$f":"N23*'Site Information'!$U$3","v":0}]
[null,9.10,"Occupancy Sensors in Office Stations (Power Strips)","Office cubicles have devices on throughout the day","Devices in office spaces turn off when team member is not present",null,"Multi-equip","Electricity",{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$C$16,0)","v":0},{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$K$27,0)","v":0},"-",{"$f":"'Power Strips - Occupancy Sensor'!$J$27","v":0},null,null,{"$f":"L24*'Site Information'!$T$3","v":0},{"$f":"N24*'Site Information'!$U$3","v":0}]
[null,9.2,"Occupancy Sensors in Workstation Cubicles (Power Strips)","Work stations are always on during production hours","Items in work areas turn off when operator is not present",null,"Multi-equip","Electricity",{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$C$35,0)","v":0},{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$K$45,0)","v":0},"-",{"$f":"'Power Strips - Occupancy Sensor'!$J$45","v":0},null,null,{"$f":"L25*'Site Information'!$T$3","v":0},{"$f":"N25*'Site Information'!$U$3","v":0}]
[null,10.10,"Machine Sleep","Machine continuously runs in-between cycles","Items are slept or reduced during inactivity in between cycles ",null,"Machinery ","Electricity",{"$f":"IFERROR(,0)","v":0},{"$f":"IFERROR('Machine Sleep'!$K$17,0)","v":0},"-",{"$f":"('Machine Sleep'!$J$17)","v":0},null,null,{"$f":"L26*'Site Information'!$T$3","v":0},{"$f":"N26*'Site Information'!$U$3","v":0}]
[null,11.10,"Panel Coolers ","Current temperature under 35° C or 95° F","Temp set at 35°C/95°F",null,"Panel Coolers","Electricity",null,{"$f":"IFERROR('Panel Cooler'!$J$23,0)","v":0},{"$f":"IFERROR(I27/J27,\"-\")","v":"-"},{"$f":"('Panel Cooler'!$I$23)","v":0},null,null,{"$f":"L27*'Site Information'!$T$3","v":0},{"$f":"N27*'Site Information'!$U$3","v":0}]
[null,12.10,"VFDs (Variable Frequency Drive)","Motors run at 100% when ever in use","Variable Frequency Drive added to reduce speed during times it is not needed",null,"Motors","Electricity",{"$f":"IFERROR(,0)","v":0},{"$f":"IFERROR(VFDs!N17,0)","v":0},{"$f":"IFERROR(I28/J28,\"-\")","v":"-"},{"$f":"(VFDs!M17)","v":0},null,null,{"$f":"L28*'Site Information'!$T$3","v":0},{"$f":"N28*'Site Information'!$U$3","v":0}]
[null,13.10,"Air cooled Ice machines","Water cooled Ice Machine","Air Cooled Ice Machine",null,"Ice Machine","Water",0,{"$f":"IFERROR('Ice Machines'!H17,0)","v":0},"-",null,{"$f":"('Ice Machines'!H16)","v":0},null,{"$f":"L29*'Site Information'!$T$3","v":0},{"$f":"N29*'Site Information'!$U$3","v":0}]
[null,14.10,"Water dripping calculations - (i.e. facets, spickets, piping)","water leaking (dripping water)","Eliminate leaks ",null,"Water systems","Water",0,{"$f":"'Water Leaks'!J50","v":0},"-",null,{"$f":"('Water Leaks'!I50)","v":0},null,{"$f":"L30*'Site Information'!$T$3","v":0},{"$f":"N30*'Site Information'!$U$3","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(I31/J31,\"\")","v":""}]
[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,null,null,null,null,"",null,null,null,"© 2022 General Motors"]

{"sheet":"Andon","index":6,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":true,"merged":[[3,1,3,17],[1,1,1,17],[10,1,10,17],[9,1,9,17],[7,1,7,17],[6,2,6,17],[5,2,5,17],[13,3,14,3],[13,4,14,4],[13,5,14,5],[25,15,25,17],[4,2,4,17],[13,6,14,6],[13,7,14,7],[11,1,11,7],[11,9,11,17],[18,4,18,5],[13,1,14,1],[13,2,14,2]]}
[]
[null,"Andon"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 1.1 - Andon Replacement"]
[null,"Items needed to replace 1 andon board\nDesktop\n2 Monitors\nProduction = 8760\nTvs can have sleep modes, when not on they Use .5 watts\nMonitors and desk top can be shut off during non production hours for additional savings"]
[null,"Exisiting Eqipment",null,null,null,null,null,null,null,"New Equipment"]
[null,"Equipment","Number of Boards","Voltage","Amperage","Production Hrs/Yr","MWh/Yr","Electricity Cost/Yr (USD)",null,"Equipment","Replacement Equipment","Voltage","Amperage","Production Hrs/Yr","Equipment Cost","Total Equipment Cost (USD)","MWh/Yr","Electricity Cost/Yr (USD)"]
[null,"ADAPTIVE Andon Board",null,120,null,null,{"$f":"(((((D14*E14)*C14)/1000)/1000)*F14)","v":0},{"$f":"IFERROR(G14*'Treasure Map'!$E$7,0)","v":0},null,"Dell Desktop",{"$f":"(C14*1)","v":0},120,null,null,750,{"$f":"(O14*K14)","v":0},{"$f":"(((((L14*M14)*K14)/1000)/1000)*N14)","v":0},{"$f":"IFERROR(Q14*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"65\" LED Vizio Smart Cast TV",{"$f":"(C14*2)","v":0},120,null,null,700,{"$f":"(O15*K15)","v":0},{"$f":"(((((L15*M15)*K15)/1000)/1000)*N15)","v":0},{"$f":"IFERROR(Q15*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,120,null,null,{"$f":"(((((D16*E16)*C16)/1000)/1000)*F16)","v":0},{"$f":"IFERROR(G16*'Treasure Map'!$E$7,0)","v":0},null,null,null,120,null,null,null,{"$f":"(500*K16)","v":0},0,{"$f":"IFERROR(Q16*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,120,null,null,{"$f":"(((((D17*E17)*C17)/1000)/1000)*F17)","v":0},{"$f":"IFERROR(G17*'Treasure Map'!$E$7,0)","v":0},null,null,null,120,null,null,null,0,0,{"$f":"IFERROR(Q17*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,120,null,null,0,{"$f":"IFERROR(G18*'Treasure Map'!$E$7,0)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(P14:P17)","v":0},{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":0}]
[null,null,null,null,"Total ",null,{"$f":"SUM(G14:G18)","v":0},{"$f":"SUM(H14:H18)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Equipment","MWh/Yr","Electricity Cost/Yr (USD)","Equipment Cost (USD)"]
[null,null,null,null,null,null,null,null,null,null,null,"Existing Equipment",{"$f":"G19","v":0},{"$f":"H19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"New Equipment",{"$f":"Q18","v":0},{"$f":"R18","v":0},{"$f":"(P18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Yearly Savings",{"$f":"M22-M23","v":0},{"$f":"N22-N23","v":0},{"$f":"O23","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Building Envelope Leaks","index":7,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[8,3,8,21],[12,2,15,21],[9,2,9,21],[1,2,1,21],[3,2,3,21],[4,3,4,21],[5,3,5,21],[6,3,6,21],[7,3,7,21],[42,20,42,21],[17,18,17,19],[18,18,18,19],[40,17,40,18],[23,1,25,1],[21,14,21,15],[21,17,22,17],[21,19,21,20],[21,2,22,2],[21,3,21,5],[21,9,21,10],[21,12,22,12],[21,8,22,8]]}
[]
[null,null,"Building Envelope Leaks"]
[]
[null,null,"User Input Instructions"]
[null,null,"Pink","Please input data ONLY in the pink cells."]
[null,null,"Cold Climate Days","This Section will be used to calculate heating cost impacts"]
[null,null,"Hot Climate Days","This Section will be used to calculate Cooling cost impacts"]
[null,null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,null,"Green","Final outputs for Treasure Map Tab"]
[null,null,"Please give best estimate if the exact data is not known"]
[]
[null,null,"Section 1.1 - Door Leaks"]
[null,null,"Infiltration rates can vary widely, so it’s best to stay conservative.  Keeping doors closed is obviously best practice for conditioned spaces.  Things that can help save at entry points include reducing setpoints, interlocking heaters with rollup door opening.  Etc.  Ensuring that windows are closed appropriately during the winter.  Typically you want to maintain a slightly positive pressure (0.025 inches WC) in a building to reduce infiltration through windows and doors.  Shutting down door/dock heaters during non-production is also best practice – or at least reducing setpoints.\n\nSpray-foam insulation (consult your fire insurance) is also a great option for increasing R-value of exterior surfaces."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity Cost",null,{"$f":"IFERROR('Treasure Map'!E7,\"\")","v":0},"$/MWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas Cost",null,{"$f":"IFERROR('Treasure Map'!E8,\"\")","v":0},"$/MWh"]
[]
[]
[null,null,"Description","Opening",null,null,"Area","Air Leaving","Hours Open per day","Outside Temperature",null,"Inside Temperature","Heating Degree Days","Delta Winter","Heat Loss",null,"Heat Cost ","Cooling Degree Days","Delta Summer","Cooling Loss",null,"Cooling Cost"]
[null,null,null,"Number of Doors/Leaks","Width Ft","Height Ft","Ft2","Ft3/s",null," Winter Deg F","Summer Deg F","Deg F",null,"Deg F","BTU/Hr","MWh per Year","Natural Gas Cost/Yr",null,"Deg F","BTU/Hr","MWh per Year","Electricity Cost/Yr"]
[null,"Example","One Sg Ft",1,1,1,{"$f":"(E24*F24)","v":1},{"$f":"(250/60)*G24","v":4.166666666666667},1,34,90,75,60,{"$f":"L24-J24","v":41},{"$f":"H24*60*N24*1.08","v":11070.000000000002},{"$f":"((((O24*0.00029307103866)*I24)*M24)/1000)","v":0.19465778387797203},{"$f":"IFERROR(P24*$U$19,0)","v":0},90,{"$f":"K24-L24","v":15},{"$f":"H24*60*S24*1.08","v":4050.000000000001},{"$f":"((((T24*0.00029307103866)*I24)*R24)/1000)","v":0.10682439359157002},{"$f":"IFERROR(U24*U$18,0)","v":0}]
[null,null,"Ped. Door",2,3,7,{"$f":"E25*F25","v":21},{"$f":"(250/60)*G25","v":87.50},24,34,90,75,60,{"$f":"L25-J25","v":41},{"$f":"H25*60*N25*1.08","v":232470.00000000003},98.10752307449789,{"$f":"IFERROR(P25*$U$19,0)","v":0},90,15,85050,53.83949437015127,0]
[null,null,"Overhead Dr",1,7,12,{"$f":"E26*F26","v":84},{"$f":"(250/60)*G26","v":350},8,34,90,75,60,{"$f":"L26-J26","v":41},{"$f":"H26*60*N26*1.08","v":929880.0000000001},130.8100307659972,0,90,15,340200,71.78599249353505,0]
[null,null,"Entry/Exit Doors",null,null,null,{"$f":"E27*F27*D27","v":0},0,null,null,null,null,null,{"$f":"L27-J27","v":0},{"$f":"H27*60*N27*1.08","v":0},0,0,null,0,0,0,0]
[null,null,"Dock doors",null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,"Door near electrical shop",null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,"Door Near Frame 8",null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Annual MWh (Gas)",{"$f":"SUM(P27:P38)","v":0},null,null,null,"Total Annual MWh (Electricity)",{"$f":"SUM(U27:U38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Savings Per Year",{"$f":"SUM(Q27:Q38)","v":0},null,null,null,"Total Savings Per Year",{"$f":"SUM(V27:V38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Savings (Natural Gas + Electricity)",null,{"$f":"(Q40+V40)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"* Example from the Flir camera showing heat transfer from a trailer sitting in a dock door with door open vs closed"]

{"sheet":"Compressed Air","index":8,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,1,7,11],[1,1,1,11],[3,1,3,11],[4,2,4,11],[5,2,5,11],[6,2,6,11],[34,9,34,11],[22,1,22,11],[23,1,23,11],[9,1,9,11],[10,1,10,11]]}
[]
[null,"Compressed Air"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 2.1 - Pressure Reduction"]
[null,"The industry rule of thumb is 1% energy savings for every 2 PSI reduction in pressure.  Producing compressed air at lower pressure reduces the amount of work your compressors need to do per CFM of air supplied.  A system pressure reduction also reduces leak rates.  The key to determining if a pressure reduction is possible is to know what pressure your equipment requires, and make sure your longest run is satisfied for flow and pressure.  If your longest run will potentially become starved of flow/pressure after a system pressure reduction, a receiver buffer tank can potentially be used to help satisfy the longest run."]
[null,"Equipment","Hp","Production Hrs/Yr","PSI Reduction","Cfm","Percent Factor","% system reduction","Cfm Reduced","HP Reduced","MWh Saved","Yearly Savings"]
[null,null,null,null,null,{"$f":"C13*4","v":0},0.01,{"$f":"(E13*0.01)/2","v":0},{"$f":"F13*H13","v":0},{"$f":"I13/4","v":0},{"$f":"((J13*0.746)*D13)/1000","v":0},{"$f":"IFERROR(K13*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,{"$f":"C14*4","v":0},0.01,0,{"$f":"F14*H14","v":0},{"$f":"I14/4","v":0},0,{"$f":"IFERROR(K14*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.01,0,0,0,0,{"$f":"IFERROR(K15*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.01,0,0,0,0,{"$f":"IFERROR(K16*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.01,0,0,0,0,{"$f":"IFERROR(K17*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.01,0,0,0,0,{"$f":"IFERROR(K18*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.01,0,0,0,0,{"$f":"IFERROR(K19*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Yearly Savings",{"$f":"SUM(K13:K19)","v":0},{"$f":"SUM(L13:M19)","v":0}]
[]
[]
[null,"Section 3.2 - Leak Reduction"]
[null,"A facility compressed air leak rate below 20% would be considered ‘world class’.  A total system leak rate of 30% is common.  One way to determine leak rate, would be to look at compressed air flow (CFM) during a complete production shutdown.  The CFM during shutdown, divided by your typical full production CFM rate will be your % leak rate.  There is a wide array of ultrasonic leak detectors that can be used to detect and pinpoint leaks.  Though, larger leaks, or accessible ones can often be located through hearing alone.  Leak rate depends on system pressure, and orifice size."]
[null,"Equipment Name","Hp","Production Hrs/Yr","Current leak Rate %","Cfm","World class leak rate","Leak Reduction potential","Cfm Reduced","Hp Reduced","MWh Saved","Yearly savings"]
[null,null,null,null,null,{"$f":"(C26*4)","v":0},0.20,{"$f":"(E26-G26)","v":-0.20},{"$f":"(F26*H26)","v":0},{"$f":"(C26*H26)","v":0},{"$f":"((J26*0.746)*D26)/1000","v":0},{"$f":"IFERROR(K26*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,{"$f":"(C27*4)","v":0},0.20,-0.20,{"$f":"(F27*H27)","v":0},0,{"$f":"((J27*0.746)*D27)/1000","v":0},{"$f":"IFERROR(K27*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.20,-0.20,0,0,{"$f":"((J28*0.746)*D28)/1000","v":0},{"$f":"IFERROR(K28*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.20,-0.20,0,0,0,{"$f":"IFERROR(K29*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.20,-0.20,0,0,0,{"$f":"IFERROR(K30*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.20,-0.20,0,0,0,{"$f":"IFERROR(K31*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,0,0.20,-0.20,0,0,0,{"$f":"IFERROR(K32*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Yearly Savings",{"$f":"SUM(K26:K32)","v":0},{"$f":"SUM(L26:L32)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Energy Star Appliances","index":9,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,9,52,10],[35,1,35,4],[35,7,35,10],[44,1,44,10],[45,1,46,10],[21,1,22,10],[23,1,23,4],[23,7,23,10],[32,1,32,10],[33,1,34,10],[20,1,20,10],[1,1,1,10],[3,1,3,10],[9,1,9,10],[10,1,10,10],[7,1,7,10],[5,2,5,10],[4,2,4,10],[11,1,11,4],[6,2,6,10]]}
[]
[null,"Energy Star Appliances"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 3.1 - Vending Machine Conversion to Energy Star"]
[null,"Complete the below vending machine energy usage data. To calculate the potential savings, fill in the KWh/day energy usage of your current vending machine and the total quantity vending machines of that type. Calculate for multiple models if needed.\n\nRefrigerated vending machines operate 24 hours per day, seven days a week. In addition to consuming 2,500 to 4,400 kilowatt-hours (KWh) of energy per year, they add to cooling loads in the spaces they occupy. At average electricity costs of aboutUS$0.10/KWh, annual operating costs can range from $250 to $440."]
[null,"Reference"]
[null,"Quantity of refrigerated machines","Old Vending Machine\nkWh/day","EPA Energy Star Vending Machine\nkWh/day","Savings kWh Daily"]
[null,null,null,5,{"$f":"(C14-D14)*B14","v":0}]
[null,null,null,"Savings (MWh)",{"$f":"(E14*365)/1000","v":0}]
[null,null,null,"Savings (USD)",{"$f":"IFERROR(E15*'Treasure Map'!E7,0)","v":0}]
[]
[]
[]
[]
[null,"Section 3.2 - Water Cooler Conversion to Energy Star"]
[null,"Complete the below water cooler energy usage data. To calculate the potential savings, fill in the Kwh/day energy usage of your current water cooler and the total quantity water coolers of that type. Calculate for multiple models if needed.\n\nThe calculator on the left is for conversion from an old hot/cold water cooler to a new Energy Star hot/cold. The calculator on the right is for conversion from an old hot/cold water cooler to a new Energy Star cook/cold cooler. If you do not require hot water, the cook (room temperature) and cold cooler is significantly more efficient. Use one calculator of the other, not both when totaling savings."]
[]
[null,"Replace with Hot/Cold Water Cooler",null,null,null,null,null,"Replace with Cook/Cold Water Cooler"]
[null,"Quantity of Water Coolers","Old Water Cooler\nkWh/day","EPA Energy Star Hot/Cold Water Cooler kWh/day","Savings Daily",null,null,"Quantity of Water Coolers","Old Water Cooler\nkWh/day","EPA Energy Star Cook/Cold Water Cooler\nkWh/day","Savings Daily"]
[null,null,null,0.70,{"$f":"(C26-D26)*B26","v":0},null,null,null,null,0.13,{"$f":"(I26-J26)*H26","v":0}]
[null,null,null,"Savings (MWh)",{"$f":"(E26*365)/1000","v":0},null,null,null,null,"Savings (MWh)",{"$f":"(K26*365)/1000","v":0}]
[null,null,null,"Savings (USD)",{"$f":"IFERROR(E27*'Treasure Map'!E7,0)","v":0},null,null,null,null,"Savings (USD)",{"$f":"IFERROR(K27*'Treasure Map'!E7,0)","v":0}]
[]
[]
[]
[]
[null,"Section 3.3 - Refrigerator Conversion to Energy Star"]
[null,"Complete the below refrigerator energy usage data. To calculate the potential savings, fill in the KWh/day energy usage of your current refrigerator and the total quantity refrigerators of that type. Calculate for multiple models if needed.\n\nRefrigerated vending machines operate 24 hours per day, seven days a week. In addition to consuming 2,500 to 4,400 kilowatt-hours (KWh) of energy per year, they add to cooling loads in the spaces they occupy. At average electricity costs of aboutUS$0.10/kWh, annual operating costs can range from $250 to $440."]
[]
[null,"Standard Size Refrigerator",null,null,null,null,null,"Compact Size Refrigerator"]
[null,"Quantity of Refrigerators","Old Refrigerator\nkWh/day","EPA Energy Star Refrigerator\nkWh/day","Savings Daily",null,null,"Quantity of Refrigerators","Old Refrigerator\nkWh/day","EPA Energy Star Refrigerator\nkWh/day","Savings Daily"]
[null,null,null,1.36986301369863,{"$f":"(C38-D38)*B38","v":0},null,null,null,null,0.7205479452054795,{"$f":"(I38-J38)*H38","v":0}]
[null,null,null,"Savings (MWh)",{"$f":"(E38*365)/1000","v":0},null,null,null,null,"Savings (MWh)",{"$f":"(K38*365)/1000","v":0}]
[null,null,null,"Savings (USD)",{"$f":"IFERROR(E39*'Treasure Map'!E7,0)","v":0},null,null,null,null,"Savings (USD)",{"$f":"IFERROR(K39*'Treasure Map'!E7,0)","v":0}]
[]
[]
[]
[]
[null,"Section 3.4 - Coffee Maker Conversion to Energy Star"]
[null,"Complete the below coffee maker energy usage data. To calculate the potential savings, fill in the Watts/Gal energy usage of your current coffee maker and the total quantity coffee makers of that type. Calculate for multiple models if needed.\n\nRefrigerated vending machines operate 24 hours per day, seven days a week. In addition to consuming 2,500 to 4,400 kilowatt-hours (kWh) of energy per year, they add to cooling loads in the spaces they occupy. At average electricity costs of aboutUS$0.10/kWh, annual operating costs can range from $250 to $440."]
[]
[null,"Quantity of \nCoffee Makers","Old Coffee Maker Brewing Wattage","Hours Used Per Day","Old Coffee Maker Idle Wattage","Idle Used Per Day","Old Coffee Maker\nkWh/day","EPA Energy Star Coffee Maker Brewing\nkWh/day","EPA Energy Star Coffee Maker Idle\nkWh/day","EPA Energy Star Coffee Maker Total\nkWh/day","Savings Daily"]
[null,null,null,null,null,{"$f":"24-D49","v":24},{"$f":"((C49/1000)*D49)+((E49/1000)*F49)","v":0},{"$f":"(520/1000)*D49","v":0},{"$f":"(0.5/1000)*F49","v":0.012},{"$f":"H49+I49","v":0.012},{"$f":"(G49-J49)*B49","v":0}]
[null,null,null,null,null,null,null,null,null,"Savings (MWh)",{"$f":"(K49*365)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,"Savings (USD)",{"$f":"IFERROR(K50*'Treasure Map'!E7,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Fans","index":10,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,1,7,9],[9,1,9,9],[10,1,10,9],[19,8,19,9],[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,2,6,9]]}
[]
[null,"Fans"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 4.1 - Pedestal Fans Timing Sensor"]
[null,"This measure is most prudent for locations where personnel are not disciplined about manually turning off their fans at the end of production shifts.  If users are good about turning them off, this measure may not be worth pursuing. "]
[null,"Number of Fans ","Kw","Hrs/Day off","Days/Year ","Fan running hours","Cost per Fan Timer Installed (USD)","Total Cost (USD)","Yearly Savings MWh","Yearly Savings (USD)"]
[null,null,null,null,null,{"$f":"(D13*E13)","v":0},63.20,{"$f":"G13*B13","v":0},{"$f":"(B13*F13)*(C13/1000)","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*I13,\"\")","v":0}]
[null,null,null,null,null,{"$f":"(D14*E14)","v":0},63.20,{"$f":"G14*B14","v":0},{"$f":"(B14*F14)*(C14/1000)","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*I14,\"\")","v":0}]
[null,null,null,null,null,0,63.20,{"$f":"G15*B15","v":0},0,{"$f":"IFERROR('Treasure Map'!$E$7*I15,\"\")","v":0}]
[null,null,null,null,null,0,63.20,{"$f":"G16*B16","v":0},0,{"$f":"IFERROR('Treasure Map'!$E$7*I16,\"\")","v":0}]
[null,null,null,null,null,null,"Total Yearly Savings",null,{"$f":"SUM(I13:I16)","v":0},{"$f":"SUM(J13:J16)","v":0}]
[null,null,null,null,null,null,"Total Cost",{"$f":"SUM(H13:H16)","v":0}]
[]
[null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Groove Belt","index":11,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,1,17,8],[26,7,26,8],[24,5,24,6],[1,1,1,8],[3,1,3,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,1,7,8],[9,1,9,8]]}
[]
[null,"Groove Belt"]
[null," "," "," "," "," "," "," "," "]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[null," "," "," "," "," "," "," "," "]
[null,"Section 5.1 "]
[null,"Perhaps it would be best pursued with regular PM work.\nDon’t buy the cheapest belt on the market, cheaper belts tend to slip more causing increase ware and energy cost."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HorsePower HP","Quantity ","kW","Production Hrs/Year","MWh","2% Percent Factor","Yearly Savings (MWh)","Yearly Savings (USD)"]
[null,null,null,{"$f":"B21*0.746","v":0},null,{"$f":"(C21*D21*E21)/1000","v":0},0.02,{"$f":"(F21*G21)","v":0},{"$f":"H21*IFERROR('Treasure Map'!$E$7,0)","v":0}]
[null,null,null,{"$f":"B22*0.746","v":0},null,{"$f":"(C22*D22*E22)/1000","v":0},0.02,{"$f":"(F22*G22)","v":0},{"$f":"H22*IFERROR('Treasure Map'!$E$7,0)","v":0}]
[null,null,null,0,null,0,0.02,0,{"$f":"H23*IFERROR('Treasure Map'!$E$7,0)","v":0}]
[null,null,null,0,null,0,0.02,0,{"$f":"H24*IFERROR('Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,"Total Yearly Savings",null,{"$f":"SUM(H21:H24)","v":0},{"$f":"IFERROR(SUM(I21:I24),0)","v":0}]
[]
[null,null,null,null,null,null,null,"© 2022 General Motors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"`"]

{"sheet":"HVAC","index":12,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,1,3,10],[4,2,4,10],[5,2,5,10],[6,2,6,10],[7,1,7,10],[19,9,19,10],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[17,7,17,8]]}
[]
[null,"HVAC Temperature Setbacks"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab "]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section - 6.1 Production - Temperature/Hour Reduction "]
[null,"You can save as much as 10% a year on heating and cooling by simply turning your thermostat back 7°-10° F of r8 hours a day from normal setting. The percentage of savings from setback is greater for buildings in milder climates than those in severe climates "]
[null,"Reference Data "]
[null,"HVAC often represents a large opportunity depending on the existing conditions.  Things like managing setpoints, scheduling, and setback modes are simple things that can be used to reduce energy consumption.  More sophisticated measures would be things like VFD control on fans, and ensuring you aren’t over-ventilating your site (refer to ASHRAE 62.1 for Ventilation and Acceptable Indoor Air Quality).  Making sure process exhaust fans are powered off during non-production is also an easy way to lower HVAC expenses - any exhausted air must be made-up with AHUs.  Performing an air-balance analysis of the facility can help identify if/when an over or under-ventilating situation is occurring. It would be wise to hire a third party professional consultant to perform an analysis like this."]
[]
[null,"Cfm","Temp In °F","Temp Out (Avg of HDD °F)","Heating Degree days (HDD)","Run Hours per day","Delta T (°F)","Btu/ Hr","MWh/Hr","MWh per year","Yealy Savings (USD)"]
[null,null,null,null,null,null,{"$f":"C16-D16","v":0},{"$f":"B16*1.08*(C16-D16)","v":0},{"$f":"(H16*0.00029307107)/1000","v":0},{"$f":"I16*E16*F16","v":0},{"$f":"IFERROR('Treasure Map'!$E$8*J16,0)","v":0}]
[null,null,null,null,null,null,{"$f":"C17-D17","v":0},{"$f":"B17*1.08*(C17-D17)","v":0},{"$f":"(H17*0.00029307107)/1000","v":0},{"$f":"I17*E17*F17","v":0},{"$f":"IFERROR('Treasure Map'!$E$8*J17,0)","v":0}]
[null,null,null,null,null,null,null,"Total Yearly Savings",null,{"$f":"(J16-J17)","v":0},{"$f":"IFERROR(K16-K17,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"LED Lighting","index":13,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[11,1,11,9],[10,1,10,9],[21,1,21,9],[36,7,36,9],[30,7,30,9],[7,1,7,9],[9,1,9,9],[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,2,6,9]]}
[]
[null,"Lighting LED"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 7.1 - Light LED Upgrade"]
[null,"High Intensity Discharge lighting (such as High Pressure Sodium and Metal Halide) often used in low-bay, high-bay, and exterior applications, use ~500% more power than an LED equivalent.  Compared to Fluorescent lighting, equivalent LEDs will often use one third, to a quarter of the power.  Depending on the application, the addition of occupancy sensor or daylight harvesting controls can reduce fixture run-time hours by 30% - providing additional savings."]
[null,"Existing Lighting"]
[null,"Equipment ","Location ","Fixture Quantity ","Lamps per Fixture","Watts per Lamp","Watts per Fixture (ignores BF)","Production Hrs/Yr","Yearly MWh","Yearly cost (USD)"]
[null,null,null,null,null,null,{"$f":"F14*E14","v":0},null,{"$f":"((G14*D14*H14)/1000)/1000","v":0},{"$f":"IFERROR(I14*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,{"$f":"F15*E15","v":0},null,{"$f":"((G15*D15*H15)/1000)/1000","v":0},{"$f":"IFERROR(I15*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I16*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I17*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I18*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I14:I18)","v":0},{"$f":"SUM(J14:J18)","v":0}]
[]
[]
[null,"Replacement LED Lighting"]
[null,"Equipment ","Location","Fixture Quantity","Lamps per Fixture","Watts per  Fixture","Watts per Lamp","Production Hrs/Yr","Yearly MWh","Yearly cost (USD)"]
[null,null,null,null,null,null,{"$f":"F24*E24","v":0},null,{"$f":"((G24*D24*H24)/1000)/1000","v":0},{"$f":"IFERROR(I24*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,{"$f":"F25*E25","v":0},null,{"$f":"((G25*D25*H25)/1000)/1000","v":0},{"$f":"IFERROR(I25*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I26*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I27*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"IFERROR(I28*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I24:I28)","v":0},{"$f":"SUM(J24:J28)","v":0}]
[]
[null,null,null,null,null,null,null,"Totals"]
[null,null,null,null,null,null,null,"Equipment","Yearly MWh","Yearly cost (USD)"]
[null,null,null,null,null,null,null,"Current",{"$f":"(I19)","v":0},{"$f":"(J19)","v":0}]
[null,null,null,null,null,null,null,"LED Future",{"$f":"(I29)","v":0},{"$f":"(J29)","v":0}]
[null,null,null,null,null,null,null,"Total Yearly Savings",{"$f":"(I33-I34)","v":0},{"$f":"(J33-J34)","v":0}]
[]
[null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Delamping","index":14,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,2,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[26,7,26,9],[24,6,24,7],[10,1,15,9]]}
[]
[null,"Delamping"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section - 8.1 - Lowering light intensities "]
[null,"Delamping refers to the process of removing or reducing the number of lamps or light fixtures in a given space. It involves intentionally reducing the lighting levels by removing unnecessary or excessive lighting fixtures. Delamping is often done to save energy, reduce electricity costs, and improve lighting efficiency. It is typically carried out after a thorough assessment of the lighting needs and requirements of the space to ensure that the remaining lighting is still adequate for the intended use. It is not recommended to decrease fixture density in an area with a low ceiling above production equipment with lots of lighting obstructions (steel, duct, piping, etc.).\n\nThis is a simple method to save energy when existing light levels are deemed too high. A more thorough lighting study should be performed to ensure adequate light intensity for the space type, which could yield additional energy savings from overall lux reductions."]
[]
[]
[]
[]
[]
[null,"Name of Area","Number of fixtures","Lamps/fixture","Wattage/lamp","Proposed lamps/fixture","Operating Hrs/Year","Lighting kW","MWh/Year","Total Cost (USD)"]
[null,"Example: Loading dock",200,4,28,2,6000,{"$f":"C18*((D18*E18)-(F18*E18))/1000","v":11.20},{"$f":"(H18*G18)/1000","v":67.20},{"$f":"IFERROR('Treasure Map'!$E$7*I18,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"C19*((D19*E19)-(F19*E19))/1000","v":0},{"$f":"(H19*G19)/1000","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*I19,0)","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*I20,0)","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*I21,0)","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*I22,0)","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*I23,0)","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*I24,0)","v":0}]
[null,null,null,null,null,null,"Total Yearly Savings",null,{"$f":"SUM(I19:I24)","v":0},{"$f":"IFERROR(SUM(J19:J24),0)","v":0}]
[]
[null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Power Strips - Occupancy Sensor","index":15,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,1,9,10],[10,1,10,10],[46,8,46,10],[31,1,31,2],[12,1,12,2],[29,1,29,10],[28,1,28,10],[7,1,7,10],[1,1,1,10],[3,1,3,10],[4,2,4,10],[5,2,5,10],[6,2,6,10]]}
[]
[null,"Occupancy Sensors"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 9.1 - Office Space Occupancy Sensors / Power Strip Usage"]
[null,"- Insert the different pieces of equipment that use energy in your office spaces and work stations that are plugged in\n- Insert the estimated amount of hours that each device/equipment is on during a given day\n- Insert the hours which the devices will be used for after purchasing the Power Strip with Occupancy Sensors (i.e. 6 hrs)\n- Insert the number of cubicles/work stations that contain the device listed in the Column B\n- Assuming 23 days in an average month"]
[]
[null,"Cost of Power Strips"]
[null,"Total Power Strips"]
[null,"Cost of Power Strip",0]
[null,"Total Cost",{"$f":"C14*C15","v":0}]
[]
[null,"Equipment ","Watts of Equipment","Number of Pieces of Equipment","Days Running per Yr","Hours Running Current","Hours Running Future ","MWh Per Year\nCurrent Usage","MWh Per Year\nFuture Usage","Annual Savings MWh","Total Yearly Savings \n(USD)"]
[null,"PC ",null,null,null,null,null,{"$f":"((C19*F19*D19*E19)/1000)/1000","v":0},{"$f":"((C19*G19*D19*E19)/1000)/1000","v":0},{"$f":"H19-I19","v":0},{"$f":"IFERROR(J19*'Treasure Map'!$E$7,0)","v":0}]
[null,"Monitor ",null,null,null,null,null,{"$f":"((C20*F20*D20*E20)/1000)/1000","v":0},{"$f":"((C20*G20*D20*E20)/1000)/1000","v":0},{"$f":"H20-I20","v":0},{"$f":"IFERROR(J20*'Treasure Map'!$E$7,0)","v":0}]
[null,"Desk Lamp ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J21*'Treasure Map'!$E$7,0)","v":0}]
[null,"Fan ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J22*'Treasure Map'!$E$7,0)","v":0}]
[null,"Heater ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J23*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J24*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J25*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"((C26*G26*D26*E26)/1000)/1000","v":0},0,{"$f":"IFERROR(J26*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(J19:J26)","v":0},{"$f":"SUM(K19:K26)","v":0}]
[]
[null,"Section 9.2 - Work Station Occupancy Sensors / Power Strip Usage"]
[null,"- Insert the different pieces of equipment that use energy in your office spaces and work stations that are plugged in\n- Insert the estimated amount of hours that each device/equipment is on during a given day\n- Insert the hours which the devices will be used for after purchasing the Power Strip with Occupancy Sensors (i.e. 6 hrs)\n- Insert the number of cubicles/work stations that contain the device listed in the Column B\n- Assuming 23 days in an average month"]
[]
[null,"Cost of Power Strips"]
[null,"Total Power Strips"]
[null,"Cost of Power Strip",0]
[null,"Total Cost",{"$f":"C33*C34","v":0}]
[null,"Equipment ","Watts of Equipment","Number of Pieces of Equipment","Days Running per Yr","Hours Running Current","Hours Running Future ","MWh Per Year\nCurrent Usage","MWh Per Year\nFuture Usage","Annual Savings (MWh)","Total Yearly Savings \n(USD)"]
[null,"PC ",null,null,null,null,null,{"$f":"((C37*F37*D37*E37)/1000)/1000","v":0},{"$f":"((C37*G37*D37*E37)/1000)/1000","v":0},{"$f":"H37-I37","v":0},{"$f":"IFERROR(J37*'Treasure Map'!$E$7,0)","v":0}]
[null,"Monitor ",null,null,null,null,null,{"$f":"((C38*F38*D38*E38)/1000)/1000","v":0},{"$f":"((C38*G38*D38*E38)/1000)/1000","v":0},{"$f":"H38-I38","v":0},{"$f":"IFERROR(J38*'Treasure Map'!$E$7,0)","v":0}]
[null,"Desk Lamp ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J39*'Treasure Map'!$E$7,0)","v":0}]
[null,"Fan ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J40*'Treasure Map'!$E$7,0)","v":0}]
[null,"Heater ",null,null,null,null,null,0,0,0,{"$f":"IFERROR(J41*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J42*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J43*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J44*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(J37:J44)","v":0},{"$f":"SUM(K37:K44)","v":0}]
[]
[null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Machine Sleep","index":16,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,1,10,10],[9,1,9,10],[18,9,18,10],[1,1,1,10],[3,1,3,10],[2,1,2,10],[4,2,4,10],[5,2,5,10],[6,2,6,10],[7,1,7,10],[8,1,8,10]]}
[]
[null,"Machine/Equipment Sleep"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 10.1 - Machine Sleep"]
[null,"Look at opportunities to use Equipment logic to add sleep when machine is not needed"]
[null,"Equipment","Quantity of Equipment","Equipment Load kW","Production Hours/Yr","Product cycle time (Min)","Equipment Cycle time (Min)","Time savings (Min)","Energy savings per machine (MWh per year)","Total Machine set Yearly Savings (MWh) ","Yearly Savings (USD)"]
[null,null,null,null,null,null,null,{"$f":"(F13-G13)","v":0},{"$f":"((H13/60)*D13*E13)/1000","v":0},{"$f":"(C13*I13)","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*J13,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"(F14-G14)","v":0},{"$f":"((H14/60)*D14*E14)/1000","v":0},{"$f":"(C14*I14)","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*J14,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*J15,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IFERROR('Treasure Map'!$E$7*J16,0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Yearly Savings",{"$f":"SUM(J13:J16)","v":0},{"$f":"SUM(K13:K16)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Panel Cooler","index":17,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,6,22,7],[8,1,8,4],[24,7,24,9],[6,2,6,9],[7,1,7,9],[15,1,15,9],[16,1,16,9],[1,1,1,9],[3,1,3,9],[2,1,2,9],[4,2,4,9],[5,2,5,9]]}
[]
[null,"Panel Coolers"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[null,"Reference Data "]
[null,"SpectraCool™ G52 Key Features:"]
[null,"Nominal cooling capacity 8000 & 12000 BTUs/Hr"]
[null,"Single Unit 72 Deg F"]
[null,"1 Deg F = 1% reduction"]
[]
[]
[null,"Section 11.1 - Panel Cooler Temperature Settings"]
[null,"Sometimes panel coolers are maintained at a lower setpoint than is required by the equipment.  Be sure to check the equipment cooling requirements before raising setpoints.  The last thing we want is production interruptions caused by overheating faults, or  thermal damage to panel components.  Ideal Panel temperature is 35°C or 95°F\n\n"]
[null,"# Panel Coolers ","BTU's/Hr","Hrs/ Year","Original SP (°F)","Revised SP (°F)","MWh","Difference (For 1% improvement)","Yearly Savings (MWh)"," Yearly Savings (USD)"]
[null,null,8000,null,null,95,{"$f":"(C19*D19*0.000293)/1000","v":0},{"$f":"(F19-E19)*0.01","v":0.95},{"$f":"(G19*H19)*B19","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*I19,\"\")","v":0}]
[null,null,12000,null,null,95,{"$f":"(C20*D20*0.000293)/1000","v":0},{"$f":"(F20-E20)*0.01","v":0.95},{"$f":"(G20*H20)*B20","v":0},{"$f":"IFERROR('Treasure Map'!$E$7*I20,\"\")","v":0}]
[null,null,null,null,null,95,0,0.95,0,{"$f":"IFERROR('Treasure Map'!$E$7*I21,\"\")","v":0}]
[null,null,null,null,null,95,0,0.95,0,{"$f":"IFERROR('Treasure Map'!$E$7*I22,\"\")","v":0}]
[null,null,null,null,null,null,"Total yearly savings",null,{"$f":"SUM(I19:I20)","v":0},{"$f":"SUM(J19:J20)","v":0}]
[]
[null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"VFDs","index":18,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,11,18,13],[1,1,1,13],[3,1,3,13],[4,2,4,13],[5,2,5,13],[9,1,9,13],[7,1,7,13],[11,6,11,8],[11,9,11,11],[11,12,11,13],[16,10,16,11],[10,1,10,13],[11,1,11,5]]}
[]
[null,"VFDs "]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 12.1 - VFD replacement/addition "]
[null,"Pumps, Fans, Compressors, and ConveyorsWhen pump and fan motors are oversized for the load (more flow or pressure than is required), there may be an opportunity to add a variable frequency drive (VFD).   By utilizing a VFD, the speed of the motor, and by extension, the fan/pump can be reduced to better match system demand.  According to the Affinity Laws, power is proportional to the cube of the change in motor speed.  So for example, reducing motor speed by 50% (30 Hz vs 60 Hz), will reduce motor power by 87.5%.  Though less dramatic speed reductions are more common (45 or 50 hz), VFDs can reduce electric usage and extend equipment life.  Most Totally Enclosed, Fan-Cooled motors should not operate below 15 Hz, as they will not be able to adequately cool themselves.  Always refer to the motor OEM to determine safe operating speeds for a given motor.  It is also important to make sure the motor can handle the addition of a VFD inverter. The addition of grounding rings on a motor can help reduce the possibility bearing damage that can be caused by voltage spikes from VFD use.  Various control schemes can also be utilized, such that the VFD will automatically adjust to changes in system demand.  It is always best to consult with a professional before installing a VFD. Inappropriate use of a VFD can result in some or all of the end uses being starved for flow/pressure, motor damage, and fire."]
[null,null,null,null,null,null,"Current conditions",null,null,"Proposed",null,null,"Electric savings "]
[null,"Equipment","Hp","Production Hrs/Yr","Load Factor %","Motor Efficiency %","Motor Hz","Demand kW","Consumption kWh/Yr","Motor Hz","Demand kW","Consumption kWh/Yr","Yearly MWh Savings","Yearly Savings (USD)"]
[null,null,null,null,0.75,null,null,{"$f":"IFERROR((C14*0.746*E14)/F14,\"\")","v":""},{"$f":"IFERROR(H14*D14,\"\")","v":""},{"$f":"(G14*0.85)","v":0},{"$f":"IFERROR(H14*(J14/G14)^3,\"\")","v":""},{"$f":"IFERROR(K14*D14,\"\")","v":""},{"$f":"IFERROR((I14-L14)/1000,\"\")","v":""},{"$f":"IFERROR(M14*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,0.75,null,null,{"$f":"IFERROR((C15*0.746*E15)/F15,\"\")","v":""},{"$f":"IFERROR(H15*D15,\"\")","v":""},{"$f":"(G15*0.85)","v":0},{"$f":"IFERROR(H15*(J15/G15)^3,\"\")","v":""},{"$f":"IFERROR(K15*D15,\"\")","v":""},{"$f":"IFERROR((I15-L15)/1000,\"\")","v":""},{"$f":"IFERROR(M15*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,0.75,null,null,"","",0,"","",{"$f":"IFERROR((I16-L16)/1000,\"\")","v":""},{"$f":"IFERROR(M16*'Treasure Map'!$E$7,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total savings",null,{"$f":"SUM(M14:M16)","v":0},{"$f":"SUM(N14:N16)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]
[]
[]
[]
[]
[null,null,50]
[null,null,60]

{"sheet":"Ice Machines","index":19,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,8,16,12],[18,11,18,12],[1,1,1,12],[9,1,9,12],[7,1,7,12],[10,1,10,12],[6,2,6,12],[5,2,5,12],[4,2,4,12],[3,1,3,12],[11,8,11,12],[12,8,12,12],[13,8,13,12],[14,8,14,12],[15,8,15,12]]}
[]
[null,"Ice Machines: Air vs Water Cooled"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 13.1 - Ice Machine Conversion to Air Cooled"]
[null,"Verify if your ice machine is air cooled or water cooled using the instructions below. If you have water cooled machines, Complete the below ice machine water usage data. To calculate the potential savings, fill in the gallons of ice produced per day of your current ice machine and the total quantity of water cooled ice machines. \n\nIce machines operate 24 hours per day, seven days a week. Water cooled ice machines use between 100-200 gallons of water per 100 lbs of ice produced compared to air cooled which use 20 gallons of water per 100 lbs of ice. Also, Manitowoc estimates that water cooled ice machines dischare 5 GPM during ice production cycles."]
[null,null,null,null,null,null,null,null,"How to Verify if Your Ice Machine is Water or Air Cooled"]
[]
[null,"Quantity of Refrigerated Machines","# of Employees Using Ice Machines","Old Water Cooled Ice Machine \nGallons of cooling per 100 lbs of ice produced","Ice Produced per Day \n(lbs per day)","Air Cooled Ice Machine\nWater Usage (Gal)","Savings Daily (Gal)","Savings Yearly (Gal)","Step 1: Locate the ice maker serial number. Should be on sticker/plate on the back of the machine."]
[null,null,null,null,{"$f":"(C15*0.25)","v":0},{"$f":"E15/8.34","v":0},{"$f":"(D15-F15)*B15","v":0},{"$f":"(G15)*(52*5)","v":0},"Step 2: Identify the last letter of the serial number. It should be an A or W. (See picture above for guidance)"]
[null,null,null,null,null,"Savings (M3)",{"$f":"G15/264.172","v":0},{"$f":"H15/264.172","v":0},"Step 3: If the letter is a W, it is water cooled. Procede with the calculator on the right."]
[null,null,null,null,null,"Savings (USD)",{"$f":"IFERROR('Site Information'!G25*G16,0)","v":0},{"$f":"IFERROR('Site Information'!G25*H16,0)","v":0},"             If the letter is an A, it is air cooled and no futher calculations are needed."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Water Leaks","index":20,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,8,51,9],[49,1,49,3],[1,1,1,9],[4,2,4,9],[5,2,5,9],[7,1,7,9],[9,1,9,9],[10,1,10,9],[6,2,6,9],[3,1,3,9],[8,1,8,9]]}
[]
[null,"Water Leaks"]
[]
[null,"User Input Instructions"]
[null,"Pink","Please input data ONLY in the pink cells."]
[null,"Gray","Please DO NOT enter any data in the gray cells. They contain formulas"]
[null,"Green","Final outputs for Treasure Map Tab"]
[null,"Please give best estimate if the exact data is not known"]
[]
[null,"Section 14.1 - Water Leaks by Flow"]
[null,"Calculate the diameter of the orifice (inches) and the pressure in the pipe. Use those values in the chart below to calculate the rate & cost of the leak."]
[]
[null,"# of Orifices of this Pressure/Size","Pressure in Pipe (PSI)","Diameter of Orifice, in.","Flow GPM","Flow M3/hr","Flow M3/Day","Cost Per Day ($)","Annual Usage (M3)","Annual Cost ($)"]
[null,null,30,0.015625,{"$f":"0.0255*B14","v":0},{"$f":"E14*60/264","v":0},{"$f":"F14*24","v":0},{"$f":"'Treasure Map'!$E$9*G14","v":0},{"$f":"G14*365","v":0},{"$f":"H14*365","v":0}]
[null,null,30,0.03125,0,0,0,{"$f":"'Treasure Map'!$E$9*G15","v":0},0,0]
[null,null,30,0.0625,0,0,0,{"$f":"'Treasure Map'!$E$9*G16","v":0},0,0]
[null,null,30,0.125,0,0,0,{"$f":"'Treasure Map'!$E$9*G17","v":0},0,0]
[null,null,30,0.1875,0,0,0,{"$f":"'Treasure Map'!$E$9*G18","v":0},0,0]
[null,null,30,0.25,0,0,0,{"$f":"'Treasure Map'!$E$9*G19","v":0},0,0]
[null,null,30,0.375,0,0,0,{"$f":"'Treasure Map'!$E$9*G20","v":0},0,0]
[null,null,30,0.50,0,0,0,{"$f":"'Treasure Map'!$E$9*G21","v":0},0,0]
[null,null,30,0.625,0,0,0,{"$f":"'Treasure Map'!$E$9*G22","v":0},0,0]
[null,null,30,0.75,0,0,0,{"$f":"'Treasure Map'!$E$9*G23","v":0},0,0]
[null,null,30,0.875,0,0,0,{"$f":"'Treasure Map'!$E$9*G24","v":0},0,0]
[null,null,30,1,0,0,0,{"$f":"'Treasure Map'!$E$9*G25","v":0},0,0]
[null,null,50,0.015625,0,0,0,{"$f":"'Treasure Map'!$E$9*G26","v":0},0,0]
[null,null,50,0.03125,0,0,0,{"$f":"'Treasure Map'!$E$9*G27","v":0},0,0]
[null,null,50,0.0625,0,0,0,{"$f":"'Treasure Map'!$E$9*G28","v":0},0,0]
[null,null,50,0.125,0,0,0,{"$f":"'Treasure Map'!$E$9*G29","v":0},0,0]
[null,null,50,0.1875,0,0,0,{"$f":"'Treasure Map'!$E$9*G30","v":0},0,0]
[null,null,50,0.25,0,0,0,{"$f":"'Treasure Map'!$E$9*G31","v":0},0,0]
[null,null,50,0.375,0,0,0,{"$f":"'Treasure Map'!$E$9*G32","v":0},0,0]
[null,null,50,0.50,0,0,0,{"$f":"'Treasure Map'!$E$9*G33","v":0},0,0]
[null,null,50,0.625,0,0,0,{"$f":"'Treasure Map'!$E$9*G34","v":0},0,0]
[null,null,50,0.75,0,0,0,{"$f":"'Treasure Map'!$E$9*G35","v":0},0,0]
[null,null,50,0.875,0,0,0,{"$f":"'Treasure Map'!$E$9*G36","v":0},0,0]
[null,null,50,1,0,0,0,{"$f":"'Treasure Map'!$E$9*G37","v":0},0,0]
[null,null,100,0.015625,0,0,0,{"$f":"'Treasure Map'!$E$9*G38","v":0},0,0]
[null,null,100,0.03125,0,0,0,{"$f":"'Treasure Map'!$E$9*G39","v":0},0,0]
[null,null,100,0.0625,0,0,0,{"$f":"'Treasure Map'!$E$9*G40","v":0},0,0]
[null,null,100,0.125,0,0,0,{"$f":"'Treasure Map'!$E$9*G41","v":0},0,0]
[null,null,100,0.1875,0,0,0,{"$f":"'Treasure Map'!$E$9*G42","v":0},0,0]
[null,null,100,0.25,0,0,0,{"$f":"'Treasure Map'!$E$9*G43","v":0},0,0]
[null,null,100,0.375,0,0,0,{"$f":"'Treasure Map'!$E$9*G44","v":0},0,0]
[null,null,100,0.50,0,0,0,{"$f":"'Treasure Map'!$E$9*G45","v":0},0,0]
[null,null,100,0.625,0,0,0,{"$f":"'Treasure Map'!$E$9*G46","v":0},0,0]
[null,null,100,0.75,0,0,0,{"$f":"'Treasure Map'!$E$9*G47","v":0},0,0]
[null,null,100,0.875,0,0,0,{"$f":"'Treasure Map'!$E$9*G48","v":0},0,0]
[null,null,100,1,0,0,0,{"$f":"'Treasure Map'!$E$9*G49","v":0},0,0]
[null,"Total:",null,null,{"$f":"SUM(E14:E49)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Visualizations","index":21,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":false,"merged":[[45,10,45,11],[44,10,44,11],[49,10,49,11],[48,10,48,11],[47,10,47,11],[46,10,46,11],[54,10,54,11],[53,10,53,11],[52,10,52,11],[51,10,51,11],[50,10,50,11],[59,10,59,11],[58,10,58,11],[57,10,57,11],[56,10,56,11],[55,10,55,11],[64,10,64,11],[63,10,63,11],[62,10,62,11],[61,10,61,11],[60,10,60,11],[8,13,8,15],[2,2,2,4],[16,2,17,2],[25,2,26,4],[16,4,17,4],[2,6,2,7],[4,4,9,4],[2,9,2,10],[4,2,9,2],[45,4,45,5],[43,1,43,9],[45,2,45,3],[46,4,46,5],[45,7,45,8],[29,19,29,21],[18,4,23,4],[18,2,23,2],[27,2,30,4],[12,4,14,4],[12,2,14,2]]}
[]
[]
[null,null,"Savings Dashboard",null,null,null,"Grand Total Electricity Savings (Mwh) Per Year",null,null,"Grand Total Water Savings (M3) Per Year",null,null,"Grand Total Methane/Propane (Mwh) Per Year",null,null,null,"Total Scope 1 Emissions Saved (Mt CO2e) Per Year","Total Scope 2 Emissions Saved (Mt CO2e) Per Year"]
[null,null,"Total Cost",null,"Total Savings",null,"Electricity Savings (MWh)",{"$f":"$C$13","v":0},null,"Water Savings (M3)",{"$f":"$C$19","v":0},null,"Natural Gas Savings (MWh)",{"$f":"$E$13","v":0},null,"Savings (Mt CO2e)",{"$f":"$E$19","v":0},{"$f":"$C$28","v":0}]
[null,null,{"$f":"$K$45","v":0},null,{"$f":"$M$45","v":0},null,"Electricity Usage (MWh)",{"$f":"'Site Information'!$E$23","v":0},null,"Water Usage (M3)",{"$f":"'Site Information'!$E$25","v":0},null,"Natural Gas Usage (MWh)",{"$f":"'Site Information'!$E$24","v":0},null,"Emissions (Mt CO2e)",{"$f":"SUM('Site Information'!U5:U16)/1000000","v":0},{"$f":"SUM('Site Information'!T5:T16)/1000000","v":0}]
[null,null,null,null,null,null,"Usage - Savings",{"$f":"H5-H4","v":0},null,"Usage - Savings",{"$f":"K5-K4","v":0},null,"Usage - Savings",{"$f":"N5-N4","v":0},null,"Usage - Savings",{"$f":"Q5-Q4","v":0},{"$f":"R5-R4","v":0}]
[]
[]
[]
[]
[]
[null,null,"Electricity Savings                 MWh",null,"Natural Gas Savings"]
[null,null,{"$f":"$O$45","v":0},null,{"$f":"$Q$45","v":0}]
[]
[]
[]
[null,null,"Water Savings (M3)",null,"Scope 1 Emissions    (Mt CO2e)"]
[]
[null,null,{"$f":"$P$45","v":0},null,{"$f":"$S$45","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Scope 2 Emissions (Mt CO2e)"]
[]
[null,null,{"$f":"$R$45","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Summary & Cost",null,null,null,null,null,null,null,null,"Grand Total Cost (USD)",null,"Grand Total Savings (USD)  Per Year","Total Payback Period (Years) ","Grand Total Electricity Savings (MWh) Per Year","Grand Total Water Savings (M3) Per Year","Grand Total Methane/Propane Savings (Mwh) Per Year","Grand Total Scope 2 Emissions Saved (Mt CO2e) Per Year","Grand Total Scope 1 Emissions Saved (Mt CO2e) Per Year"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K47:K65)","v":0},null,{"$f":"SUBTOTAL(9,M47:M65)","v":0},{"$f":"IFERROR(K45/M45,\"\")","v":""},{"$f":"SUBTOTAL(9,O47:O65)","v":0},{"$f":"SUBTOTAL(9,P47:P65)","v":0},{"$f":"SUBTOTAL(9,Q47:Q65)","v":0},{"$f":"SUBTOTAL(9,R47:R65)","v":0},{"$f":"SUBTOTAL(9,S47:S65)","v":0}]
[null,"Ref. No. ","Title",null,"Current State",null,"Future State","Equipment",null,"Energy Source","Total Cost (USD)",null,"Total Savings (USD)","Payback (Years)",null,"Water (M3)","Propane/Methane (MWh)","Scope 2 Emissions Saved (Mt CO2e)","Scope 1 Emissions Saved (Mt CO2e)"]
[null,1.1,"Building Envelope Leaks",null,"Door leaks or Dock doors left open during idle truck loading",null,"Fixed leaks and close doors when Trailer is not being processed","Doors",null,"Electricity & Gas",{"$f":"IFERROR(,0)","v":0},null,{"$f":"IFERROR('Building Envelope Leaks'!$T$41,0)","v":0},{"$f":"IFERROR(K47/M47,\"-\")","v":"-"},{"$f":"('Building Envelope Leaks'!$V$39)","v":0},null,{"$f":"('Building Envelope Leaks'!$Q$39)","v":0},{"$f":"O47*'Site Information'!$T$3","v":0},{"$f":"Q47*'Site Information'!$U$3","v":0}]
[null,{"$f":"B47+1","v":2.10},"Compressed Air Pressure Reduction",null,"Current PSI ",null,"Reduction in Psi (full system or by decoupling heavy loaded items)","Compressed Air",null,"Electricity",null,null,{"$f":"IFERROR('Compressed Air'!$L$20,0)","v":0},"-",{"$f":"('Compressed Air'!$K$20)","v":0},null,null,{"$f":"O48*'Site Information'!$T$3","v":0},{"$f":"Q48*'Site Information'!$U$3","v":0}]
[null,{"$f":"B48+0.1","v":2.2},"Compressed Air Leaks",null,"Air leaks are > 20% in a system",null,"Reduce air leaks to world class 20%","Compressed Air",null,"Electricity",{"$f":"IFERROR(,0)","v":0},null,{"$f":"('Compressed Air'!$L$33)","v":0},"-",{"$f":"('Compressed Air'!$K$33)","v":0},null,null,{"$f":"O49*'Site Information'!$T$3","v":0},{"$f":"Q49*'Site Information'!$U$3","v":0}]
[null,3.10,"Energy Star - Vending Machines",null,"Vending Machine (older models) non-Energy Star",null,"Request and change out dated vending machines to \"Energy Star\"","Vending",null,"Electricity ",0,null,{"$f":"IFERROR('Energy Star Appliances'!$E$16,0)","v":0},"-",{"$f":"('Energy Star Appliances'!$E$15)","v":0},null,null,{"$f":"O50*'Site Information'!$T$3","v":0},{"$f":"Q50*'Site Information'!$U$3","v":0}]
[null,3.20,"Energy Star - Water Cooler",null,"Water Cooler (older models) non-Energy Star",null,"Request and change out dated water cooler to \"Energy Star\"","Water Cooler",null,"Electricity ",0,null,{"$f":"IFERROR(SUM('Energy Star Appliances'!$E$28,'Energy Star Appliances'!$K$28),0)","v":0},"-",{"$f":"SUM('Energy Star Appliances'!$E$27,'Energy Star Appliances'!$K$27)","v":0},null,null,{"$f":"O51*'Site Information'!$T$3","v":0},{"$f":"Q51*'Site Information'!$U$3","v":0}]
[null,3.30,"Energy Star - Refrigerator",null,"Refrigerator (older models) non-Energy Star",null,"Request and change out dated refrigerator to \"Energy Star\"","Refrigerator",null,"Electricity ",0,null,{"$f":"SUM('Energy Star Appliances'!$E$40,'Energy Star Appliances'!$K$40)","v":0},"-",{"$f":"SUM('Energy Star Appliances'!$E$39,'Energy Star Appliances'!$K$39)","v":0},null,null,{"$f":"O52*'Site Information'!$T$3","v":0},{"$f":"Q52*'Site Information'!$U$3","v":0}]
[null,3.40,"Energy Star - Coffee Maker",null,"Coffee Maker (older models) non-Energy Star",null,"Request and change out dated coffee maker to \"Energy Star\"","Coffee Maker",null,"Electricity ",{"$f":"IFERROR(,0)","v":0},null,{"$f":"'Energy Star Appliances'!$K$51","v":0},"-",{"$f":"('Energy Star Appliances'!$K$50)","v":0},null,null,{"$f":"O53*'Site Information'!$T$3","v":0},{"$f":"Q53*'Site Information'!$U$3","v":0}]
[null,4.1,"Fans",null,"No Timer switch ",null,"Timing switch installed","Fans",null,"Electricity",{"$f":"IFERROR(Fans!$H$18,0)","v":0},null,{"$f":"IFERROR(Fans!$J$17,0)","v":0},"-",{"$f":"(Fans!$I$17)","v":0},null,null,{"$f":"O54*'Site Information'!$T$3","v":0},{"$f":"Q54*'Site Information'!$U$3","v":0}]
[null,5.1,"Groove Belts",null,"Straight belts ",null,"Grooved belts","Motors",null,"Electricity ",{"$f":"IFERROR(,0)","v":0},null,{"$f":"IFERROR('Groove Belt'!$I$25,0)","v":0},"-",{"$f":"'Groove Belt'!$H$25","v":0},null,null,{"$f":"O55*'Site Information'!$T$3","v":0},{"$f":"Q55*'Site Information'!$U$3","v":0}]
[null,6.10,"HVAC Set back thermostats (CDD)",null,"Current Thermostat temperature",null,"Reduce thermostat temperate by Delta x°","Heating/Cooling",null,"Electricity & Gas",null,null,{"$f":"IFERROR(HVAC!$K$18,\"\")","v":0},"-",null,null,{"$f":"(HVAC!$J$18)","v":0},{"$f":"O56*'Site Information'!$T$3","v":0},{"$f":"Q56*'Site Information'!$U$3","v":0}]
[null,7.10,"LED Lighting",null,"Fluorescent lights ",null,"LED lights","Lighting",null,"Electricity",0,null,{"$f":"IFERROR('LED Lighting'!$J$35,0)","v":0},"-",{"$f":"('LED Lighting'!$I$35)","v":0},null,null,{"$f":"O57*'Site Information'!$T$3","v":0},{"$f":"Q57*'Site Information'!$U$3","v":0}]
[null,8.10,"Delamping",null,"Current light candle",null,"Reduction in candle light lumin on any fixtures that can support","Lighting",null,"Electricity ",0,null,{"$f":"IFERROR(Delamping!$J$25,0)","v":0},"-",{"$f":"(Delamping!$I$25)","v":0},null,null,{"$f":"O58*'Site Information'!$T$3","v":0},{"$f":"Q58*'Site Information'!$U$3","v":0}]
[null,9.10,"Occupancy Sensors in Office Stations (Power Strips)",null,"Office cubicles have devices on throughout the day",null,"Devices in office spaces turn off when team member is not present","Multi-equip",null,"Electricity",{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$C$16,0)","v":0},null,{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$K$27,0)","v":0},"-",{"$f":"'Power Strips - Occupancy Sensor'!$J$27","v":0},null,null,{"$f":"O59*'Site Information'!$T$3","v":0},{"$f":"Q59*'Site Information'!$U$3","v":0}]
[null,9.2,"Occupancy Sensors in Workstation Cubicles (Power Strips)",null,"Work stations are always on during production hours",null,"Items in work areas turn off when operator is not present","Multi-equip",null,"Electricity",{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$C$35,0)","v":0},null,{"$f":"IFERROR('Power Strips - Occupancy Sensor'!$K$45,0)","v":0},"-",{"$f":"'Power Strips - Occupancy Sensor'!$J$45","v":0},null,null,{"$f":"O60*'Site Information'!$T$3","v":0},{"$f":"Q60*'Site Information'!$U$3","v":0}]
[null,10.10,"Machine Sleep",null,"Machine continuously runs in-between cycles",null,"Items are slept or reduced during inactivity in between cycles ","Machinery ",null,"Electricity",{"$f":"IFERROR(,0)","v":0},null,{"$f":"IFERROR('Machine Sleep'!$K$17,0)","v":0},"-",{"$f":"('Machine Sleep'!$J$17)","v":0},null,null,{"$f":"O61*'Site Information'!$T$3","v":0},{"$f":"Q61*'Site Information'!$U$3","v":0}]
[null,11.10,"Panel Coolers ",null,"Current temperature under 35° C or 95° F",null,"Temp set at 35°C/95°F","Panel Coolers",null,"Electricity",null,null,{"$f":"IFERROR('Panel Cooler'!$J$23,0)","v":0},"-",{"$f":"('Panel Cooler'!$I$23)","v":0},null,null,{"$f":"O62*'Site Information'!$T$3","v":0},{"$f":"Q62*'Site Information'!$U$3","v":0}]
[null,12.10,"VFDs Pumps and Fans",null,"Motors run at 100% when ever in use",null,"Variable Frequency Drive added to reduce speed during times it is not needed","Motors",null,"Electricity",{"$f":"IFERROR(,0)","v":0},null,{"$f":"IFERROR(VFDs!$N$17,0)","v":0},"-",{"$f":"(VFDs!$M$62)","v":0},null,null,{"$f":"O63*'Site Information'!$T$3","v":0},{"$f":"Q63*'Site Information'!$U$3","v":0}]
[null,13.10,"Air cooled Ice machines",null,"Water cooled Ice Machine",null,"Air Cooled Ice Machine","Ice Machine",null,"Water",0,null,{"$f":"IFERROR('Ice Machines'!$H$17,0)","v":0},"-",null,{"$f":"'Ice Machines'!$H$16","v":0},null,{"$f":"O64*'Site Information'!$T$3","v":0},{"$f":"Q64*'Site Information'!$U$3","v":0}]
[null,14.10,"Water dripping calculations - (i.e. facets, spickets, piping)",null,"water leaking (dripping water)",null,"Eliminate leaks ","Water systems",null,"Water",0,null,{"$f":"IFERROR('Water Leaks'!$J$50,0)","v":0},"-",null,{"$f":"'Water Leaks'!$I$50","v":0},null,{"$f":"O65*'Site Information'!$T$3","v":0},{"$f":"Q65*'Site Information'!$U$3","v":0}]

{"sheet":"Treasure Hunt Form","index":22,"n_rows":83,"n_cols":26,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy Star Treasure Hunts"]
[null,"Find the Treasure in Your Facility Campaign"]
[]
[null,"GM wants to empower you to examine your energy use more closely!"]
[null,"Energy Star is a voluntary program of the U.S. Environmental Protection Agency (EPA) that helps businesses and individuals save money and protect our climate through superior energy efficiency. "]
[null,"Energy Treasure Hunts are one best practice that many Energy Star partner organizations have adopted to identify no- and low-cost savings opportunities and build stronger energy teams."]
[null,"The Energy Treasure Map Tool allows organizations to uncover hidden savings through self-guided exercises. Users will also earn Energy Treasure Hunt participation credit."]
[null,"Sharing detailed information about your energy savings efforts via the tool will boost your CDP score and offset costs incurred through sustainability assessment platforms (i.e. EcoVadis, M2030)."]
[]
[null,"What to do?"]
[null,"Complete the form below to share a summary of your savings and earn recognition for your participation. "]
[null,"Note: If your organization is submitting multiple Energy Treasure Hunts, a separate line item is required for each site."]
[null,"Select the \"Send Email to Energy Star\" button above to open an email in a separate window."]
[null,"Copy and paste the table below into the email and submit the completed form to treasurehunt@energystar.gov. "]
[null,"Note: Total attachments may not exceed 100MB in a single email."]
[null,"For any questions about this form, email treasurehunt@energystar.gov."]
[null,"gpscsustainability@gm.com"]
[]
[null,"Sponsors and participants that submit their summary findings will:"]
[null,"Be featured on the Energy Star Treasure Hunt website in the \"What others have done\" section."]
[null,"Receive a printable certificate noting contribution."]
[null,"Showcase the importance of energy efficiency and inspire others to make a difference!"]
[]
[null,"Useful Links and Email Addresses:"]
[null,"http://www.energystar.gov/treasurehunt"]
[null,"treasurehunt@energystar.gov"]
[null,"gpscsustainability@gm.com"]
[]
[null,"*Indicates a required field. "]
[null,null,"1. Organization name*","2. Contact name*","3. Contact title","4. Contact email*","5a. Site name*","5b. Street address*","5c. City*","5d. State*","5e. ZIP Code*","6. Is the facility a commercial building or industrial facility?*\n\nIf it is a commercial building, please answer questions 7a-c. If it is an industrial building, please skip to question 8.","7a. Commercial building type","7b. Building square footage (sq. ft.)","7c. Is the site benchmarked in Portfolio Manager?","8. Industrial facility type","9. Start date of treasure hunt*","10. Total potential annual energy savings identified during the hunt (Source kBtu)*","11a. Approximately how many opportunities were identified during the hunt?","11b. Top 3 energy-saving measures identified (e.g., lighting left on in five conference rooms, six steam leaks detected, incorrect set points)","12. What percentage (%) of the facility’s total energy use would the treasure hunt findings save? (calculated on source energy basis)*","13. How many people participated?","14. How did you hear about treasure hunts? (e.g., trade association, utility, region, etc.)","15. Would you be willing to participate in a case study about your treasure hunt, if requested?","16. Company logo (insert filename of logo attached to submission email)","17. Photos of hunt (insert filenames of photos attached to submission email)"]
[null,1,{"$f":"Index!G6","v":"<Insert Org Name>"},{"$f":"Index!G14","v":"<Insert Contact Name>"},null,{"$f":"Index!G15","v":"<Insert Contact Email>"},{"$f":"Index!G7","v":"<Insert Site Name>"},{"$f":"Index!G10","v":"<Insert Street Address>"},{"$f":"Index!G11","v":"<Insert City>"},{"$f":"Index!G12","v":"MI"},{"$f":"Index!G13","v":"<Insert Zip Code>"},{"$f":"Index!G9","v":"Industrial"}," "," "," "," ",{"$f":"Index!G5","v":"<Insert Date>"},{"$f":"(SUM(Visualizations!H4+Visualizations!N4))*3412.8","v":0}," "," ",{"$f":"IFERROR(((Visualizations!H4+Visualizations!N4)/(Visualizations!H5+Visualizations!N5)),0)","v":0}," "," "," "," "," "]
[null,2," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,3," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,4," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,5," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,6," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,7," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,8," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,9," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,10," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,11," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,12," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,13," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,14," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,15," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,16," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,17," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,18," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,19," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,20," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,21," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,22," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,23," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,24," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,25," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,26," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,27," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,28," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,29," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,30," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,31," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,32," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,33," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,34," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,35," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,36," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,37," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,38," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,39," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,40," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,41," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,42," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,43," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,44," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,45," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,46," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,47," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,48," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,49," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,50," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[]
[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,"© 2022 General Motors"]

{"sheet":"Conversion Factors","index":23,"n_rows":85,"n_cols":16,"rows_kept":85,"cut":false,"hidden":false,"merged":[[31,1,31,3],[31,5,31,7],[31,9,31,11],[31,13,31,15],[13,1,13,3],[13,5,13,7],[13,9,13,11],[13,13,13,15],[19,1,19,3],[84,13,84,15],[48,1,48,3],[48,5,48,7],[48,9,48,11],[48,13,48,15],[65,5,65,7],[65,9,65,11],[65,13,65,15]]}
[]
["#","Calculation ","Conversion ",null,"#","Abbreviation ","Description "]
[1,"Multiply by 8.314","pounds in a gallon ",null,1,"gpm ","gallons per minute"]
[{"$f":"A3+1","v":2},"Divide by 12","inches to feet",null,{"$f":"E3+1","v":2},"WWTP","wastewater treatment plant"]
[{"$f":"A4+1","v":3},"Multiply by 7.381","cubic feet into gallons ",null,{"$f":"E4+1","v":3},"gph","gallons per hour"]
[4,"Multiply by 0.00378541","gallons to cubic meters",null,4,"mgd","million gallons per day"]
[null,null,null,null,5,"Btu/h","british thermal unit per hour"]
[null,null,null,null,null,"M3 / gal","cubic meters per gallon"]
[]
["UNIT CONVERSION FACTORS"]
[null,null,"(Unless otherwise indicated, conversion factors are from Ref. 1, inside jacket cover.)"]
[null,"From","To","Multiply\nBy",null,"From","To","Multiply\nBy",null,"From","To","Multiply\nBy",null,"From","To","Multiply\nBy"]
[]
[null,"Temperature",null,null,null,"Distance",null,null,null,"Force",null,null,null,"Pressure"]
[null,{"$f":"CHAR(176)&\"K\"","v":"°K"},{"$f":"CHAR(176)&\"R\"","v":"°R"},{"$f":"9/5","v":1.80},null,"feet","inches",12,null,"Definition: 1 Newton (N) = 1 kg-m/s2",null,null,null,"Def.: 1 N/m2 = 1 pascal (Pa)"]
[null,null,null,"Add",null,"yards","feet",3,null,"lbf","N",4.4482,null,"atm","lbf/in2",14.696]
[null,{"$f":"CHAR(176)&\"F\"","v":"°F"},{"$f":"CHAR(176)&\"R\"","v":"°R"},459.67,null,"meters","feet",3.2808,null,null,null,null,null,"atm","N/m2",101325]
[null,{"$f":"CHAR(176)&\"C\"","v":"°C"},{"$f":"CHAR(176)&\"K\"","v":"°K"},273.15,null,"meters","inches",39.37,null,null,null,null,null,"atm","bars",1.01325]
[null,null,null,null,null,"inches","cm",2.54,null,null,null,null,null,"psi","inches H2O",27.707258364]
[null,"Time",null,null,null,"statute\nmiles","feet",5280,null,null,null,null,null,"atm","mm Hg",760]
[null,"years","months",12,null,"statute\nmiles","yards",1760,null,null,null,null,null,"inches Hg","psia",0.49115407]
[null,"years","weeks",52,null,"statute\nmiles","kilometers",1.61,null,null,null,null,null,"lbf/ft2","lbf/in2",144]
[null,"years","days",365,null,"nautical\nmiles","yards",2025,null,null,null,null,null,"bar","N/m2",100000]
[null,"years","hours",{"$f":"D23*D25","v":8760},null,null,null,null,null,null,null,null,null,"lbf/in2","Pa",6894.80]
[null,"days","hours",24]
[null,"days","minutes",{"$f":"D25*D27","v":1440}]
[null,"hours","minutes",60]
[null,"minutes","seconds",60]
[]
[]
[]
[null,"Mass",null,null,null,"Area",null,null,null,"Energy & Work",null,null,null,"Flow"]
[null,"short tons","lbm",2000,null,"yd2","in2",1296,null,"Btu","ft-lbf",778.17]
[null,"long tons","lbm",null,null,"ft2","in2",144,null,"kWhr","Btu",3412.142]
[null,"metric\ntons","kg",1000,null,"ft2","cm2",929.0304,null,"kJ","kcal",4.1868]
[null,"kg","lbm",2.2046,null,"acre","ft2",43560,null,"Refr. Ton-hrs","kWhr",{"$f":"12000/L34","v":3.5168524639361434}]
[null,"lbm","grams",453.54,null,"m2","ft2",{"$f":"H17^2","v":10.763648640000001},null,"ft-lbf","Joule",1.35582]
[null,"lbm","grains",7000,null,"mile2","acre",639.9974,null,"kJ","kcal",4.1868]
[null,null,null,null,null,null,null,null,null,"kWhr","Joule",3600000]
[null,null,null,null,null,null,null,null,null,"Btu","Joule",1055.1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Density",null,null,null,"Volume",null,null,null,"Power (Energy Transfer Rate)",null,null,null,"Viscosity"]
[null,null,null,null,null,"in3","cm3",16.387,null,"hp","kW",0.7457,null,"Poise","lbf-s/ft2",0.00209]
[null,null,null,null,null,"ft3","in3",1728,null,"hp","ft-lbf/sec",550,null,"Poise","lbm/ft-s",0.0672]
[null,null,null,null,null,"ft3","liter",28.31685,null,"hp","Btu/hr",2545,null,"lbf-s/ft2","lbm/ft-s",32.174]
[null,null,null,null,null,"m3","ft3",35.31467,null,"kW","Btu/hr",3412.142,null,"lbm/ft-s","Poise",14.87]
[null,null,null,null,null,"gallons","ml",3785.40,null,"Boiler hp","Btu/hr",33475.35]
[null,null,null,null,null,"gallons","in3",231,null,"Refr. tons","Btu/hr",12000]
[null,null,null,null,null,"gallons","ft3",0.13368,null,"Clg. Twr. Ton","Btu/hr",15000]
[null,null,null,null,null,"MMgal","Mcf",{"$f":"1000000*H56/1000","v":133.68}]
[null,null,null,null,null,"m3","gallons",264]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Velocity",null,null,null,"Chemistry",null,null,null,"Miscellaneous"]
[null,null,null,null,null,"ft/sec","mile/hr",0.6818182,null,"Mcal/kgmole","Btu/lbmole",1800,null,"Angular Measures"]
[null,null,null,null,null,"ft/min","meter/sec",0.00508,null,null,null,null,null,"radians","degrees",{"$f":"180/PI()","v":57.29577951308232}]
[null,null,null,null,null,"mile/hr","km/hr",1.6093]
[null,null,null,null,null,"knot","mile/hr",1.150779,null,null,null,null,null,"Pump & Fan Power Calculation"]
[null,null,null,null,null,"C (light)","mile/sec",186282.40,null,null,null,null,null,"cfm-inch w.c.","hp",{"$f":"$U$39/($U$36*$I$45*$Q$68)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"gpm-ft TDH","hp",{"$f":"$M$73/($I$45*$Q$68)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2022 General Motors"]

{"sheet":"Education Material","index":24,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,"#","Topic ","Link to more information "]
[null,1,"Heating & Cooling Degree Day (deg F) ","https://www.weather.gov/key/climate_heat_cool#:~:text=If%20the%20temperature%20mean%20is,result%20is%20Heating%20Degree%20Days.&text=Because%20the%20result%20is%20below,F%20%3D%2036%20Heating%20Degree%20Days."]
[null,2,"Boiler Water Diagram ","https://www.cfm.va.gov/til/sDetail/Div23HVACSteam/SD232111-04.pdf"]
[null,3,"Cooling Tower ","https://www.coolingtowerproducts.com/blog/how-cooling-towers-work-diagram-pictures-2015.htm"]
[null,4,"Textile WWTP ","https://core.ac.uk/download/pdf/35338582.pdf"]
[null,5,"Psychrometric Chart ","http://www.flycarpet.net/en/PsyOnline"]
[null,6,"Steam Table ","https://www.tlv.com/global/US/steam-theory/how-to-read-a-steam-table.html"]
[null,7,"Cooling Tower Evaporation ","https://www.chemengonline.com/cooling-towers-estimate-evaporation-loss-and-makeup-water-requirements/#:~:text=As%20air%20rises%20inside%20the,is%20lost%20due%20to%20evaporation."]
[null,8,"REA Cooling Tower Water Tool","http://www.reahvac.com/tools/cooling-tower-make-water-flow-calculation/"]
[null,9,"Swamp Cooler ","https://home.howstuffworks.com/home-improvement/heating-and-cooling/swamp-cooler.htm"]
[null,10,"DoE:Cooling Towers: Understanding Key Components of Cooling Towers and How to Improve Water Efficiency","https://www.energy.gov/sites/prod/files/2013/10/f3/waterfs_coolingtowers.pdf"]
[null,11,"Wastewater Technology Fact Sheet Oxidation Ditches","https://www3.epa.gov/npdes/pubs/oxidation_ditch.pdf"]
[null,12,"Wastewater Technology Fact Sheet Fine Bubble Aeration","https://www3.epa.gov/npdes/pubs/fine.pdf"]
[null,13,"Recommended Lighting levels ","https://www.noao.edu/education/QLTkit/ACTIVITY_Documents/Safety/LightLevels_outdoor+indoor.pdf"]
[null,14,"Wastewater Clarifier Performance","https://www.thewastewaterblog.com/single-post/2016/10/22/Wastewater-Clarifier-Performance#:~:text=The%20weir%20overflow%20rate%20is,GFD%20represents%20gallons%20per%20day"]
[null,15,"Thermostats","https://www.energy.gov/energysaver/thermostats"]
[null,null,"DOE Tips Sheets","Tip Sheets by System | Department of Energy"]
[]
[null,null,null,"© 2022 General Motors"]

{"sheet":"E-factors","index":25,"n_rows":73,"n_cols":39,"rows_kept":73,"cut":false,"hidden":false,"merged":[[7,27,7,31],[7,32,7,34],[3,1,3,8],[4,1,6,1],[4,2,4,8],[5,2,5,8],[5,31,5,32],[6,31,6,32]]}
["Emissions Factors"]
[null,"Canada Source",null,"Emission Factors and Reference Values - Canada.ca",null,null,null,null,null,"All Canada S2 converted from g CO2e/kWh",null,null,null,"All Canada S1 converted from g CO2/m3"]
[null,"Source","https://www.epa.gov/egrid/power-profiler#/",null,null,null,null,null,"Created:","2023-01-30",null,null,null,"All US S1 converted from million MT CO2 emissions from natural gas & MMcf natural gas consumption by state"]
[null,"3. State Output Emission Rates (eGRID2021)"]
[null,"State","Total output emission rates"]
[null,null,"(lb/MWh)",null,null,null,null,null,null,"Scope 2 Factor","Scope 1 Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 2.  2021 State energy-related carbon dioxide emissions by fuel"]
[null,null,"CO2","CH4","N2O","CO2e","Annual NOX","Ozone Season NOX","SO2","CO2e (MT/MWh)","CO2e (MT/MWh)"]
[null,"AK",920,0.075,0.01,925,6.10,6.20,0.453,{"$f":"F8*(1/2204.6)","v":0.41957724757325593},0.7885403395754025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"million metric tons of carbon dioxide",null,null,null,null,"shares"]
[null,"AL",750.80,0.055,0.008,754.50,0.20,0.20,0.134,0.34223895491245576,0.19329459536378174,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State","Coal","Petroleum","Natural Gas ","Total",null,"Coal","Petroleum","Natural Gas",null,"MMcf","Conversion","Factor"]
[null,"AR",1086.9,0.091,0.013,1093.1,0.60,0.60,1.157,0.49582690737548757,0.18572053890789572,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AK",1.80,17.50,19.60,38.90,null,0.046,0.449,0.505,null,84804,{"$f":"AK10*1000*0.2931","v":2.4856052400000002E7},{"$f":"(AD10*1000000)/AL10","v":0.7885403395754025}]
[null,"AZ",724.80,0.042,0.006,727.60,0.40,0.40,0.141,0.3300371949560011,0.1928645963634651,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AL",29.60,40.2,38.60,108.40,null,0.273,0.371,0.356,null,681321,1.9969518510000002E8,0.19329459536378174]
[null,"CA",479,0.025,0.003,480.50,0.40,0.40,0.015,0.2179533702258913,0.1892587930617882,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR",20.70,22.50,18.80,62,null,0.334,0.363,0.304,null,345368,1.0122736080000001E8,0.18572053890789572]
[null,"CO",1216.9,0.113,0.016,1224.6,0.60,0.60,0.367,0.5554749160845505,0.23670776193703227,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ",15.40,42.10,25.60,83,null,0.185,0.507,0.308,null,452868,1.3273561080000001E8,0.1928645963634651]
[null,"CT",515.10,0.048,0.006,518.10,0.20,0.20,0.034,0.23500861834346368,0.19082143727462772,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA",2.70,208.10,113.30,324,null,0.008,0.642,0.35,null,2042481,5.986511811E8,0.1892587930617882]
[null,"DC",651.7,0.018,0.002,652.60,2.90,2.80,0.033,0.2960174181257371,0.19272104188078776,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO",24.20,33.50,27.70,85.40,null,0.283,0.393,0.324,null,399256,1.1702193360000001E8,0.23670776193703227]
[null,"DE",867.50,0.04,0.005,870.10,0.40,0.40,0.317,0.39467477093350267,0.19868468921661006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CT",0.30,20.10,16.20,36.60,null,0.008,0.55,0.442,null,289649,8.48961219E7,0.19082143727462772]
[null,"FL",834.10,0.052,0.007,837.50,0.30,0.30,0.168,0.37988750793794795,0.1862974001548987,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC",0,1,1.50,2.50,null,0,0.405,0.595,null,26555,7783270.500000001,0.19272104188078776]
[null,"GA",758.10,0.064,0.009,762.40,0.30,0.30,0.248,0.3458223714052436,0.1854785506799794,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE",0.40,8,4.6,13,null,0.034,0.614,0.352,null,78991,2.31522621E7,0.19868468921661006]
[null,"HI",1491,0.164,0.025,1502.60,4.80,4.80,5.519,0.681574888868729,0.12268266252293704,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL",19.20,123.30,83.90,226.30,null,0.085,0.545,0.371,null,1536524,4.5035518440000004E8,0.1862974001548987]
[null,"IA",768.90,0.081,0.012,774.40,0.50,0.70,0.802,0.35126553569808583,0.19247038221650653,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA",19.50,64,40.60,124.10,null,0.157,0.516,0.327,null,746821,2.1889323510000002E8,0.1854785506799794]
[null,"ID",271.30,0.009,0.001,272,0.20,0.20,0.059,0.12337839063775742,0.19159256527371152,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HI",1.20,16,0.10,17.30,null,0.069,0.923,0.008,null,2781,815111.1000000001,0.12268266252293704]
[null,"IL",653,0.063,0.009,657.30,0.30,0.30,0.722,0.2981493241404336,0.18813895216672682,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA",25.30,26.30,21.60,73.1,null,0.346,0.359,0.295,null,382890,1.1222505900000001E8,0.19247038221650653]
[null,"IN",1632.60,0.152,0.022,1642.90,1,0.90,0.843,0.7452145513925429,0.1894074315375518,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID",0.30,13.20,7.10,20.50,null,0.014,0.642,0.344,null,126434,3.7057805400000006E7,0.19159256527371152]
[null,"KS",838.20,0.095,0.014,844.60,0.60,0.60,0.155,0.3831080468112129,0.19795526319075157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IL",49.90,77,57.40,184.20,null,0.271,0.418,0.311,null,1040920,305093652,0.18813895216672682]
[null,"KY",1727.10,0.186,0.027,1739.80,0.90,0.90,1.378,0.7891681030572439,0.2073708894782145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN",71.70,49.40,45.30,166.40,null,0.431,0.297,0.272,null,815991,2.3916696210000002E8,0.1894074315375518]
[null,"LA",826,0.04,0.006,828.70,0.60,0.70,0.738,0.375895854123197,0.2228370257731208,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS",21,23.70,15.10,59.80,null,0.351,0.396,0.253,null,260252,7.62798612E7,0.19795526319075157]
[null,"MA",851.40,0.129,0.017,859.60,0.70,0.60,0.213,0.38991200217726574,0.18866045995542366,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY",52.50,39.7,19.10,111.30,null,0.472,0.357,0.171,null,314246,9.210550260000001E7,0.2073708894782145]
[null,"MD",698.20,0.058,0.008,702,0.20,0.20,0.241,0.318425111131271,0.2093709824652744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA",9.2,83.70,95.70,188.60,null,0.049,0.444,0.507,null,1465240,4.2946184400000006E8,0.2228370257731208]
[null,"ME",301,0.124,0.018,309.4,0.40,0.40,0.288,0.14034291935044904,0.19259774451092573,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA",0,34.8,21.30,56.10,null,0,0.621,0.379,null,385197,1.1290124070000002E8,0.18866045995542366]
[null,"MI",1003.80,0.096,0.014,1010.30,0.80,0.80,0.951,0.45826907375487613,0.1961076158753793,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD",6.60,30,16,52.60,null,0.126,0.57,0.304,null,260728,7.641937680000001E7,0.2093709824652744]
[null,"MN",826,0.082,0.012,831.60,0.60,0.60,0.256,0.37721128549396715,0.19469878358680498,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME",0.20,11.30,3,14.40,null,0.011,0.783,0.207,null,53144,1.5576506400000002E7,0.19259774451092573]
[null,"MO",1636.10,0.189,0.027,1649,1.30,1.20,2.631,0.7479814932414044,0.18555383352762145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI",41.60,56.30,49.90,147.8,null,0.282,0.381,0.337,null,868141,2.5445212710000002E8,0.1961076158753793]
[null,"MS",834,0.036,0.005,836.40,0.40,0.50,0.143,0.37938855121110404,0.19583477080594322,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN",17.20,38.60,27.40,83.20,null,0.206,0.465,0.329,null,480144,1.407302064E8,0.19469878358680498]
[null,"MT",1045,0.117,0.017,1053,0.90,0.80,1.072,0.4776376666969065,0.201183554805579,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO",59.10,42.50,15.40,117,null,0.505,0.363,0.132,null,283162,8.29947822E7,0.18555383352762145]
[null,"NC",669.50,0.05,0.007,672.70,0.40,0.40,0.224,0.3051347183162479,0.1857705918271839,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS",6.20,26.70,30.20,63.10,null,0.098,0.423,0.479,null,526140,154211634,0.19583477080594322]
[null,"ND",1340.70,0.151,0.022,1351,1.30,1.40,1.639,0.6128095799691554,0.4361375640058863,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT",11.80,12.20,4.50,28.50,null,0.412,0.428,0.159,null,76314,2.2367633400000002E7,0.201183554805579]
[null,"NE",1124.80,0.13,0.019,1133.70,1,1.1,2.174,0.5142429465662706,0.1916407167230399,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC",21.30,60.80,33.40,115.60,null,0.184,0.526,0.289,null,613414,1.797916434E8,0.1857705918271839]
[null,"NH",304,0.063,0.008,308,0.20,0.10,0.044,0.13970788351628413,0.1883186805216251,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND",34.7,11.80,10.10,56.50,null,0.613,0.208,0.179,null,79010,2.3157831000000004E7,0.4361375640058863]
[null,"NJ",480.90,0.035,0.004,483.10,0.20,0.20,0.046,0.2191327224893405,0.18854717744117583,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE",20.70,16.60,9.90,47.20,null,0.439,0.352,0.21,null,176251,5.16591681E7,0.1916407167230399]
[null,"NM",1134.30,0.097,0.014,1140.80,0.70,0.70,0.167,{"$f":"F40*(1/2204.6)","v":0.5174634854395355},0.3117688822223152,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH",0.30,9.8,3.20,13.30,null,0.023,0.739,0.238,null,57975,1.69924725E7,0.1883186805216251]
[null,"NV",715.10,0.028,0.004,716.90,0.50,0.60,0.128,0.3251837067948834,0.1892280276303714,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ",1.20,51.20,36.7,89.10,null,0.014,0.574,0.412,null,664095,1.9464624450000003E8,0.18854717744117583]
[null,"NY",455.30,0.027,0.003,457,0.20,0.20,0.038,0.2072938401524086,0.1911463257626575,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM",12.80,18.30,14.80,45.90,null,0.278,0.399,0.322,null,161962,{"$f":"AK42*1000*0.2931","v":4.74710622E7},{"$f":"(AD42*1000000)/AL42","v":0.3117688822223152}]
[null,"OH",1208.20,0.099,0.014,1214.9,0.60,0.50,1.216,0.5510750249478364,0.2025590140674815,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV",3.40,19.90,16.10,39.40,null,0.087,0.504,0.409,null,290285,8.508253350000001E7,0.1892280276303714]
[null,"OK",753.50,0.047,0.006,756.60,0.50,0.60,0.412,0.3431915086637032,0.22706133501000586,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY",0.50,83.70,71.80,156,null,0.003,0.537,0.46,null,1281571,3.756284601E8,0.1911463257626575]
[null,"OR",325.80,0.015,0.002,326.70,0.50,0.50,0.015,0.14819014787262996,0.19367372992338772,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH",54.80,71.4,67.80,194,null,0.283,0.368,0.349,null,1141990,3.3471726900000006E8,0.2025590140674815]
[null,"PA",726.40,0.049,0.007,729.60,0.30,0.30,0.407,0.33094438900480816,0.22564541044637984,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK",12.60,36.50,38.7,87.80,null,0.144,0.415,0.441,null,581503,1.704385293E8,0.22706133501000586]
[null,"PR",1558,0.081,0.013,1563.90,3.20,3,3.284,0.7093803864646648,0.190500998371509,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR",0.10,22.40,16,38.50,null,0.003,0.581,0.416,null,281860,8.261316600000001E7,0.19367372992338772]
[null,"RI",832.70,0.016,0.002,833.60,0.40,0.40,0.012,0.3781184795427742,{"$f":"K60","v":0.20410278042610486},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA",45.90,70,97.60,213.50,null,0.215,0.328,0.457,null,1475732,4.3253704920000005E8,0.22564541044637984]
[null,"SC",567,0.05,0.007,570.40,0.20,0.20,0.179,0.25873174271976773,0.18533831041439786,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI",0,5.1,5.60,10.60,null,0,0.477,0.523,null,100294,2.9396171400000002E7,0.190500998371509]
[null,"SD",302.9,0.025,0.004,304.6,0.10,0.10,0.074,0.13816565363331218,0.2035173074028513,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC",15.60,35.50,18.30,69.30,null,0.225,0.512,0.264,null,336876,9.873835560000001E7,0.18533831041439786]
[null,"TN",698.30,0.065,0.009,702.60,0.30,0.30,0.366,0.3186972693459131,0.19162435779101855,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD",2.10,8.10,5,15.20,null,0.136,0.534,0.33,null,83821,2.45679351E7,0.2035173074028513]
[null,"TX",856.40,0.057,0.008,860.20,0.50,0.50,0.654,0.39018416039190784,0.21048828350529575,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN",21.60,49.50,21.50,92.70,null,0.233,0.534,0.232,null,382800,1.1219868000000001E8,0.19162435779101855]
[null,"UT",1560.50,0.157,0.023,1571.20,1.60,1.60,0.65,0.7126916447428105,0.21214027153176906,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX",92.80,325.4,245.30,663.50,null,0.14,0.49,0.37,null,3976068,1.1653855308000002E9,0.21048828350529575]
[null,"VA",599.2,0.049,0.006,601.50,0.20,0.20,0.088,0.27283861017871724,0.19389356118014395,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US",1008.60,2247.8,1654.90,4911.20,null,0.205,0.458,0.337,null,27663493,8.108169798300001E9,0.20410278042610486]
[null,"VT",36,0.137,0.018,44.80,0.20,0.20,0.017,0.02032114669327769,0.17997463386089038,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT",26.50,21.20,14.40,62.10,null,0.426,0.342,0.232,null,231592,6.78796152E7,0.21214027153176906]
[null,"WA",201.80,0.017,0.002,203,0.10,0.10,0.039,0.09208019595391455,0.20162374826823629,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA",6.50,54.70,36.8,98,null,0.066,0.559,0.375,null,647543,1.897948533E8,0.19389356118014395]
[null,"WI",1267.1,0.117,0.017,1274.9,0.50,0.60,0.221,0.5782908464120476,0.1874646170132552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT",0,4.80,0.70,5.60,null,0,0.87,0.13,null,13270,3889437.0000000005,0.17997463386089038]
[null,"WV",1944.10,0.223,0.032,1959.40,1,0.90,1.44,0.888778009616257,0.47209507019050484,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA",3.50,50.20,20.10,73.80,null,0.048,0.68,0.272,null,340125,9.969063750000001E7,0.20162374826823629]
[null,"WY",1833.90,0.198,0.029,1847.40,1.20,1.30,1.16,0.8379751428830627,0.346295646679041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI",27.50,35.7,29.30,92.50,null,0.297,0.386,0.316,null,533252,1.5629616120000002E8,0.1874646170132552]
[null,"U.S.",852.30,0.071,0.01,857,0.50,0.50,0.531,0.38873264991381656,0.20410278042610486,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV",60.60,13.40,14.40,88.40,null,0.686,0.152,0.163,null,104068,3.0502330800000004E7,0.47209507019050484]
[null,"British Columbia",null,null,null,15,null,null,null,{"$f":"F61*0.000001*1000","v":0.015},{"$f":"M61*0.000001/(0.0353*0.2931)","v":0.19001723299727538},null,1966,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY",36.10,10.2,8.3,54.60,null,0.661,0.187,0.152,null,81774,2.3967959400000002E7,0.346295646679041]
[null,"Alberta",null,null,null,540,null,null,null,0.54,0.1896306262159991,null,1962]
[null,"Saskatchewan",null,null,null,730,null,null,null,0.73,0.18557125501259852,null,1920]
[null,"Manitoba",null,null,null,2,null,null,null,0.002,0.18508799653600322,null,1915]
[null,"Ontario",null,null,null,30,null,null,null,0.03,0.1856679067079176,null,1921]
[null,"Quebec",null,null,null,1.70,null,null,null,0.0017,0.1861511651845129,null,1926]
[null,"New Brunswick",null,null,null,300,null,null,null,0.30,0.18547460331727947,null,1919]
[null,"Nova Scotia",null,null,null,690,null,null,null,0.69,0.18547460331727947,null,1919]
[null,"Prince Edward Island",null,null,null,300,null,null,null,0.30,0.18547460331727947,null,1919]
[null,"Newfoundland and Labrador",null,null,null,17,null,null,null,0.017,0.18547460331727947,null,1919]
[null,"Yukon",null,null,null,80,null,null,null,0.07999999999999999,0.19001723299727538,null,1966]
[null,"Northwest Territories",null,null,null,170,null,null,null,0.16999999999999998,0.19001723299727538,null,1966]
[null,"Nunavut",null,null,null,840,null,null,null,0.84,0.19001723299727538,null,1966]