{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":37,"n_cols":22,"rows_kept":37,"merged":[[0,0,1,0],[0,1,0,8],[1,10,1,18],[2,10,8,18],[9,10,11,18],[12,10,12,18],[13,10,13,18],[15,10,29,18],[32,2,33,2],[32,3,32,6],[33,3,33,5],[34,3,34,5],[35,3,35,5],[36,3,36,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5],[48,3,48,5],[49,3,49,5],[50,3,50,5],[51,3,51,5],[52,3,52,5],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[74,3,74,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[79,3,79,5],[80,3,80,5],[81,3,81,5],[82,3,82,5],[83,3,83,5]]}
["#","Aggregated Consumption Request Form (for 1 or More Buildings)"]
[null,"Common Area Account #","Service Address","Borough","E & G","Additional Addresses","BBL","BIN","Last Year's Invoice#",null,"Instructions"]
[1,12345678901234,"123 Example St",2,null,3,"1-12345-1234",1234567,"00000",{"$f":"IF(B3=12345678901234,\"EXAMPLE\",IF(AND(B3>0,),\"\",\"\"))","v":"EXAMPLE"},"1) Please fill in column B with the 14 digit Con Edison common area account number for the building being requested. Please omit the dashes and the 15th digit as they are not necessary for processing.\n\n2) In column C please fill in the service address as it appears on the bill.\n\n3) Select the appropriate borough from the drop down window in column D."]
[2,null,null,1,null,1,{"$nulls":14},"Values for Combo Box","Values for Combo Box 2"]
[3,null,null,1,null,1]
[4,null,null,1,null,1,{"$nulls":14},"Manhattan","No"]
[5,null,null,1,null,1,{"$nulls":14},"Bronx","Yes"]
[6,{"$nulls":4},1,{"$nulls":14},"Brooklyn"]
[7,{"$nulls":4},1,{"$nulls":14},"Queens"]
[8,{"$nulls":4},1,{"$nulls":4},"4) If the location you are requesting receives both electric and gas service from Con Edison check the box in column E. If any buildings receive steam service CLICK HERE.",{"$nulls":9},"Staten Island"]
[9,{"$nulls":4},1,{"$nulls":14},"Westchester"]
[10,{"$nulls":4},1]
[11,{"$nulls":4},1,{"$nulls":4},"5) If the building has additional service address that receive Con Edison service select \"Yes\" and click here."]
[12,{"$nulls":4},1,{"$nulls":4},"and CLICK HERE. Otherwise skip to step 6."]
[13,{"$nulls":4},1]
[14,{"$nulls":4},1,{"$nulls":4},"6) Input the BBL and BIN for each location in columns G & H respectively.\n\n7) If a request was made for the same location(s) during any of the previous benchmarking periods please provide the associated invoice number from the most recent year, in column I, to expedite processing.\n\n8) Please send all applicable Letters of Authorization as PDF attachements via email along with this form. \n\n*Row 3 of the first section is this form has been pre-populated with an example, please overwrite the information in that row with the first location you would like to request aggregated consumption data for.\n\n**Rows 35-37 of the second section of this form are also pre-populated with examples to aid in form completion. Please overwrite these sections with your own information when populating this form."]
[15,{"$nulls":4},1]
[16,{"$nulls":4},1]
[17,{"$nulls":4},1]
[18,{"$nulls":4},1]
[19,{"$nulls":4},1]
[20,{"$nulls":4},1]
[21,null,null,1,null,1]
[22,{"$nulls":4},1]
[23,{"$nulls":4},1]
[24,null,null,1,null,1]
[25,null,null,1,null,1]
[]
[]
[null,"        Letter of Authorization  (LOA) attached (request will not be processed without LOA dated within past 12 months)"]
[]
[]
[null,null,"#","Additional Service Addresses"]
[{"$nulls":3},"Building Address",null,null,"BIN"]
[null,null,1,"125 Example St",null,null,1234567,{"$f":"IF(D35=\"125 Example St\",\"EXAMPLE\",IF(AND(D35>0,),\"\",\"\"))","v":"EXAMPLE"}]
[null,null,1,"127 Example St",null,null,1234568,{"$f":"IF(D36=\"127 Example St\",\"EXAMPLE\",IF(AND(D36>0,),\"\",\"\"))","v":"EXAMPLE"}]
[null,null,1,"129 Example St",null,null,1234569,{"$f":"IF(D37=\"129 Example St\",\"EXAMPLE\",IF(AND(D37>0,),\"\",\"\"))","v":"EXAMPLE"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}