{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Revision History","SOW as provided to Contractors","Pricing Summary","General Conditions","Generator ","UPS-Inverter","DC Plant","DC Cabling","Grounding","Surge Suppression System","Electrical","HVAC System","Environmental Monitoring","Fire Protection","Architectural","Cable Management","Security Access"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Revision History","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["REVISION HISTORY"]
["Version","Date","Author","Change History"]
[1,"2014-01-24","A. Koch","Finalized and released to the field."]
[2,"2014-02-05","T. McGrath-Agg","Added field rates per notification from Ken Bellefeuille."]
[3,"2014-02-11","T. McGrath-Agg","Updated title to alleviate confusion."]

{"sheet":"SOW as provided to Contractors","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":" \"The cost outlined on this file are related to the ATS Estimate with the Internal Reference Number\" &'Pricing Summary'!B7:E7","v":"The cost outlined on this file are related to the ATS Estimate with the Internal Reference Number YYYYMMDDiii##"}]
[]
[null,null,"Cut and Paste the Customer SOW below. Provide \"exceptions, and project clarifications\" as required."]

{"sheet":"Pricing Summary","index":2,"n_rows":41,"n_cols":37,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,0,9,7],[12,1,12,8],[11,1,11,8],[18,1,18,8],[15,1,15,8],[17,1,17,8],[6,25,6,27],[6,29,6,31],[6,34,6,36],[7,15,7,17],[6,1,6,4],[7,25,7,27],[7,29,7,31],[7,34,7,36],[0,0,0,13],[0,15,0,17],[21,1,21,8],[34,20,34,21],[30,20,30,21],[31,20,31,21],[32,20,32,21],[33,20,33,21],[22,1,22,8],[23,1,23,8],[19,1,19,8],[10,1,10,8],[16,1,16,8],[13,1,13,8],[14,1,14,8],[20,1,20,8],[0,29,0,31],[34,1,34,2],[25,1,25,7],[32,0,32,10],[2,7,2,12],[3,7,3,12],[4,7,4,12],[5,7,5,12],[26,1,26,6],[27,1,27,6],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[8,9,8,11],[28,20,28,23]]}
["ATS Estimate to Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DISCIPLINE COST DETAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,"BUDGET DETAIL"]
["Estimate Pricing Summary"]
["Location:","Project Name",null,null,null,null,"Customer:"]
["Project Name:","Project Name - City, State.",null,null,null,null,"ATS Estimator:"]
["Date:","MM/DD/YY",null,null,null,null,"Phone:"]
["Vendor:","Alpha",null,null,null,null,"Email:"]
["Internal Reference #"," YYYYMMDDiii##",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUDGET DETAIL",null,null,null,"BUDGET DETAIL",null,null,null,null,"MARGIN"]
[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,"Cost",null,null,null,"Revenue",null,null,null,null,"%"]
["Click on each Tab to access & enter information for $ Cost Quotes.  Quote all applicable Tabs.  Blue area is for input data.",null,null,null,null,null,null,null,null,"Summary Per Tab",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,"ATS","ATS","HE Partlist",null,"ATS","ATS","HE Partlist","ATS",null,"ATS","ATS","HE Partlist"]
[null,null,null,null,null,null,null,null,null,"Material","Labor ","Equipment",null,null,null,"Material","Labor ","Equipment",null,null,null,null,null,"Quantity","UOM","Material ","Labor","Product",null,"Material ","Labor","Product","Total Revenue",null,"Material ","Labor","Product"]
["General Conditions",{"$f":"'General Conditions'!C5","v":"Design, Engineering and Mobilization"},null,null,null,null,null,null,null,{"$f":"'General Conditions'!K24","v":0},{"$f":"'General Conditions'!L24","v":0},{"$f":"'General Conditions'!M24","v":0},null,null," ",{"$f":"SUMPRODUCT(--( 'General Conditions'!$R$8:$R$60=\"M\"), 'General Conditions'!$W$8:$W$60, 'General Conditions'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('General Conditions'!$R$8:$R$60=\"L\"), 'General Conditions'!$W$8:$W$60, 'General Conditions'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('General Conditions'!$R$8:$R$60=\"E\"), 'General Conditions'!$W$8:$W$60, 'General Conditions'!$X$8:$X$60)","v":0},null,null,null,"General Conditions",null,1,"EA",{"$f":"SUMIFS('General Conditions'!$Y:$Y, 'General Conditions'!$R:$R, \"<>L\", 'General Conditions'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('General Conditions'!$Y:$Y, 'General Conditions'!$R:$R, \"=L\", 'General Conditions'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('General Conditions'!AB:AB, \"=TRUE\", 'General Conditions'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('General Conditions'!$AA:$AA, 'General Conditions'!$R:$R, \"<>L\", 'General Conditions'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('General Conditions'!$AA:$AA, 'General Conditions'!$R:$R, \"=L\", 'General Conditions'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('General Conditions'!AB:AB, \"=TRUE\", 'General Conditions'!$AA:$AA)","v":0},{"$f":"AD11+AE11","v":0},null,{"$f":"IF(AND(Z11<>0, AD11<>0), 1-(Z11/AD11), \"-\")","v":"-"},{"$f":"IF(AND(AA11<>0, AE11<>0), 1-(AA11/AE11), \"-\")","v":"-"},"N/A"]
["Generator",{"$f":"'Generator '!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Generator '!K50","v":0},{"$f":"'Generator '!L50","v":0},{"$f":"'Generator '!M50","v":0},null,null," ",{"$f":"SUMPRODUCT(--('Generator '!$R$8:$R$60 =\"M\"),'Generator '!$W$8:$W$60,'Generator '!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Generator '!$R$8:$R$60=\"L\"),'Generator '!$W$8:$W$60,'Generator '!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Generator '!$R$8:$R$60=\"E\"),'Generator '!$W$8:$W$60,'Generator '!$X$8:$X$60)","v":0},null,null,null,"Generator",null,1,"EA",{"$f":"SUMIFS('Generator '!$Y:$Y, 'Generator '!$R:$R, \"<>L\", 'Generator '!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Generator '!$Y:$Y, 'Generator '!$R:$R, \"=L\", 'Generator '!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Generator '!AB:AB, \"=TRUE\", 'Generator '!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Generator '!$AA:$AA, 'Generator '!$R:$R, \"<>L\", 'Generator '!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Generator '!$AA:$AA, 'Generator '!$R:$R, \"=L\", 'Generator '!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Generator '!AB:AB, \"=TRUE\", 'Generator '!$AA:$AA)","v":0},{"$f":"AD12+AE12","v":0},null,{"$f":"IF(AND(Z12<>0, AD12<>0), 1-(Z12/AD12), \"-\")","v":"-"},{"$f":"IF(AND(AA12<>0, AE12<>0), 1-(AA12/AE12), \"-\")","v":"-"},"N/A"]
["UPS",{"$f":"'UPS-Inverter'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'UPS-Inverter'!K32","v":0},{"$f":"'UPS-Inverter'!L32","v":0},{"$f":"'UPS-Inverter'!M32","v":0},null,null,null,{"$f":"SUMPRODUCT(--('UPS-Inverter'!$R$8:$R$60=\"M\"), 'UPS-Inverter'!$W$8:$W$60, 'UPS-Inverter'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('UPS-Inverter'!$R$8:$R$60=\"L\"), 'UPS-Inverter'!$W$8:$W$60, 'UPS-Inverter'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('UPS-Inverter'!$R$8:$R$60=\"E\"), 'UPS-Inverter'!$W$8:$W$60, 'UPS-Inverter'!$X$8:$X$60)","v":0},null,null,null,"UPS",null,1,"EA",{"$f":"SUMIFS('UPS-Inverter'!$Y:$Y, 'UPS-Inverter'!$R:$R, \"<>L\", 'UPS-Inverter'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('UPS-Inverter'!$Y:$Y, 'UPS-Inverter'!$R:$R, \"=L\", 'UPS-Inverter'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('UPS-Inverter'!$AB:$AB, \"=TRUE\", 'UPS-Inverter'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('UPS-Inverter'!$AA:$AA, 'UPS-Inverter'!$R:$R, \"<>L\", 'UPS-Inverter'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('UPS-Inverter'!$AA:$AA, 'UPS-Inverter'!$R:$R, \"=L\", 'UPS-Inverter'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('UPS-Inverter'!$AB:$AB, \"=TRUE\", 'UPS-Inverter'!$Y:$Y)","v":0},0,null,"-","-",{"$f":"IF(AND(AB13<>0, AF13<>0), 1-(AB13/AF13), \"-\")","v":"-"}]
["DC Plant",{"$f":"'DC Plant'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'DC Plant'!K59","v":0},{"$f":"'DC Plant'!L59","v":0},{"$f":"'DC Plant'!M59","v":0},null,null,null,{"$f":"SUMPRODUCT(--('DC Plant'!$R$8:$R$60=\"M\"), 'DC Plant'!$W$8:$W$60, 'DC Plant'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('DC Plant'!$R$8:$R$60=\"L\"), 'DC Plant'!$W$8:$W$60, 'DC Plant'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('DC Plant'!$R$8:$R$60=\"E\"), 'DC Plant'!$W$8:$W$60, 'DC Plant'!$X$8:$X$60)","v":0},null,null,null,"DC Plant",null,1,"EA",{"$f":"SUMIFS('DC Plant'!$Y:$Y, 'DC Plant'!$R:$R, \"<>L\", 'DC Plant'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('DC Plant'!$Y:$Y, 'DC Plant'!$R:$R, \"=L\", 'DC Plant'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('DC Plant'!$AB:$AB, \"=TRUE\", 'DC Plant'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('DC Plant'!$AA:$AA, 'DC Plant'!$R:$R, \"<>L\", 'DC Plant'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('DC Plant'!$AA:$AA, 'DC Plant'!$R:$R, \"=L\", 'DC Plant'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('DC Plant'!$AB:$AB, \"=TRUE\", 'DC Plant'!$AA:$AA)","v":0},0,null,"-","-",{"$f":"IF(AND(AB14<>0, AF14<>0), 1-(AB14/AF14), \"-\")","v":"-"}]
["DC Cabling",{"$f":"'DC Cabling'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'DC Cabling'!K36","v":0},{"$f":"'DC Cabling'!L36","v":0},{"$f":"'DC Cabling'!M36","v":0},null,null,null,{"$f":"SUMPRODUCT(--('DC Cabling'!$R$8:$R$60=\"M\"), 'DC Cabling'!$W$8:$W$60, 'DC Cabling'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('DC Cabling'!$R$8:$R$60=\"L\"), 'DC Cabling'!$W$8:$W$60, 'DC Cabling'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('DC Cabling'!$R$8:$R$60=\"E\"), 'DC Cabling'!$W$8:$W$60, 'DC Cabling'!$X$8:$X$60)","v":0},null,null,null,"DC Cabling",null,1,"EA",{"$f":"SUMIFS('DC Cabling'!$Y:$Y, 'DC Cabling'!$R:$R, \"<>L\", 'DC Cabling'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('DC Cabling'!$Y:$Y, 'DC Cabling'!$R:$R, \"=L\", 'DC Cabling'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('DC Cabling'!$AB:$AB, \"=TRUE\", 'DC Cabling'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('DC Cabling'!$AA:$AA, 'DC Cabling'!$R:$R, \"<>L\", 'DC Cabling'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('DC Cabling'!$AA:$AA, 'DC Cabling'!$R:$R, \"=L\", 'DC Cabling'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('DC Cabling'!$AB:$AB, \"=TRUE\", 'DC Cabling'!$AA:$AA)","v":0},0,null,"-","-","-"]
["Grounding",{"$f":"Grounding!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"Grounding!K40","v":0},{"$f":"Grounding!L40","v":0},{"$f":"Grounding!M40","v":0},null,null,null,{"$f":"SUMPRODUCT(--(Grounding!$R$8:$R$60=\"M\"), Grounding!$W$8:$W$60, Grounding!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Grounding!$R$8:$R$60=\"L\"), Grounding!$W$8:$W$60, Grounding!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Grounding!$R$8:$R$60=\"E\"), Grounding!$W$8:$W$60, Grounding!$X$8:$X$60)","v":0},null,null,null,"Grounding",null,1,"EA",{"$f":"SUMIFS(Grounding!$Y:$Y, Grounding!$R:$R, \"<>L\", Grounding!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Grounding!$Y:$Y, Grounding!$R:$R, \"=L\", Grounding!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Grounding!$AB:$AB, \"=TRUE\", Grounding!$Y:$Y)","v":0},null,{"$f":"SUMIFS(Grounding!$AA:$AA, Grounding!$R:$R, \"<>L\", Grounding!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Grounding!$AA:$AA, Grounding!$R:$R, \"=L\", Grounding!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Grounding!$AB:$AB, \"=TRUE\", Grounding!$AA:$AA)","v":0},0,null,"-","-","-"]
["Surge Suppression System",{"$f":"'Surge Suppression System'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Surge Suppression System'!K15","v":0},{"$f":"'Surge Suppression System'!L15","v":0},{"$f":"'Surge Suppression System'!M15","v":0},null,null,null,{"$f":"SUMPRODUCT(--('Surge Suppression System'!$R$8:$R$60=\"M\"), 'Surge Suppression System'!$W$8:$W$60, 'Surge Suppression System'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Surge Suppression System'!$R$8:$R$60=\"L\"), 'Surge Suppression System'!$W$8:$W$60, 'Surge Suppression System'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Surge Suppression System'!$R$8:$R$60=\"E\"), 'Surge Suppression System'!$W$8:$W$60, 'Surge Suppression System'!$X$8:$X$60)","v":0},null,null,null,"Surge Suppression System",null,1,"EA",{"$f":"SUMIFS('Surge Suppression System'!$Y:$Y, 'Surge Suppression System'!$R:$R, \"<>L\", 'Surge Suppression System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Surge Suppression System'!$Y:$Y, 'Surge Suppression System'!$R:$R, \"=L\", 'Surge Suppression System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Surge Suppression System'!$AB:$AB, \"=TRUE\", 'Surge Suppression System'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Surge Suppression System'!$AA:$AA, 'Surge Suppression System'!$R:$R, \"<>L\", 'Surge Suppression System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Surge Suppression System'!$AA:$AA, 'Surge Suppression System'!$R:$R, \"=L\", 'Surge Suppression System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Surge Suppression System'!$AB:$AB, \"=TRUE\", 'Surge Suppression System'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Electrical",{"$f":"Electrical!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"Electrical!K39","v":0},{"$f":"Electrical!L39","v":0},{"$f":"Electrical!M39","v":0},null,null,null,{"$f":"SUMPRODUCT(--(Electrical!$R$8:$R$60=\"M\"), Electrical!$W$8:$W$60, Electrical!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Electrical!$R$8:$R$60=\"L\"), Electrical!$W$8:$W$60, Electrical!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Electrical!$R$8:$R$60=\"E\"), Electrical!$W$8:$W$60, Electrical!$X$8:$X$60)","v":0},null,null,null,"Electrical",null,1,"EA",{"$f":"SUMIFS(Electrical!$Y:$Y, Electrical!$R:$R, \"<>L\", Electrical!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Electrical!$Y:$Y, Electrical!$R:$R, \"=L\", Electrical!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Electrical!$AB:$AB, \"=TRUE\", Electrical!$Y:$Y)","v":0},null,{"$f":"SUMIFS(Electrical!$AA:$AA, Electrical!$R:$R, \"<>L\", Electrical!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Electrical!$AA:$AA, Electrical!$R:$R, \"=L\", Electrical!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Electrical!$AB:$AB, \"=TRUE\", Electrical!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["HVAC System",{"$f":"'HVAC System'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'HVAC System'!K47","v":0},{"$f":"'HVAC System'!L47","v":0},{"$f":"'HVAC System'!M47","v":0},null,null,null,{"$f":"SUMPRODUCT(--('HVAC System'!$R$8:$R$60=\"M\"), 'HVAC System'!$W$8:$W$60, 'HVAC System'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('HVAC System'!$R$8:$R$60=\"L\"), 'HVAC System'!$W$8:$W$60, 'HVAC System'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('HVAC System'!$R$8:$R$60=\"E\"), 'HVAC System'!$W$8:$W$60, 'HVAC System'!$X$8:$X$60)","v":0},null,null,null,"HVAC System",null,1,"EA",{"$f":"SUMIFS('HVAC System'!$Y:$Y, 'HVAC System'!$R:$R, \"<>L\", 'HVAC System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('HVAC System'!$Y:$Y, 'HVAC System'!$R:$R, \"=L\", 'HVAC System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('HVAC System'!$AB:$AB, \"=TRUE\", 'HVAC System'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('HVAC System'!$AA:$AA, 'HVAC System'!$R:$R, \"<>L\", 'HVAC System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('HVAC System'!$AA:$AA, 'HVAC System'!$R:$R, \"=L\", 'HVAC System'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('HVAC System'!$AB:$AB, \"=TRUE\", 'HVAC System'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Environmental Monitoring",{"$f":"'Environmental Monitoring'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Environmental Monitoring'!K28","v":0},{"$f":"'Environmental Monitoring'!L28","v":0},{"$f":"'Environmental Monitoring'!M28","v":0},null,null,null,{"$f":"SUMPRODUCT(--('Environmental Monitoring'!$R$8:$R$60=\"M\"), 'Environmental Monitoring'!$W$8:$W$60, 'Environmental Monitoring'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Environmental Monitoring'!$R$8:$R$60=\"L\"), 'Environmental Monitoring'!$W$8:$W$60, 'Environmental Monitoring'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Environmental Monitoring'!$R$8:$R$60=\"E\"), 'Environmental Monitoring'!$W$8:$W$60, 'Environmental Monitoring'!$X$8:$X$60)","v":0},null,null,null,"Environmental Monitoring",null,1,"EA",{"$f":"SUMIFS('Environmental Monitoring'!$Y:$Y, 'Environmental Monitoring'!$R:$R, \"<>L\", 'Environmental Monitoring'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Environmental Monitoring'!$Y:$Y, 'Environmental Monitoring'!$R:$R, \"=L\", 'Environmental Monitoring'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Environmental Monitoring'!$AB:$AB, \"=TRUE\", 'Environmental Monitoring'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Environmental Monitoring'!$AA:$AA, 'Environmental Monitoring'!$R:$R, \"<>L\", 'Environmental Monitoring'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Environmental Monitoring'!$AA:$AA, 'Environmental Monitoring'!$R:$R, \"=L\", 'Environmental Monitoring'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Environmental Monitoring'!$AB:$AB, \"=TRUE\", 'Environmental Monitoring'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Fire Protection",{"$f":"'Fire Protection'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Fire Protection'!K27","v":0},{"$f":"'Fire Protection'!L27","v":0},{"$f":"'Fire Protection'!M27","v":0},null,null,null,{"$f":"SUMPRODUCT(--('Fire Protection'!$R$8:$R$60=\"M\"), 'Fire Protection'!$W$8:$W$60, 'Fire Protection'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Fire Protection'!$R$8:$R$60=\"L\"), 'Fire Protection'!$W$8:$W$60, 'Fire Protection'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Fire Protection'!$R$8:$R$60=\"E\"), 'Fire Protection'!$W$8:$W$60, 'Fire Protection'!$X$8:$X$60)","v":0},null,null,null,"Fire Protection",null,1,"EA",{"$f":"SUMIFS('Fire Protection'!$Y:$Y, 'Fire Protection'!$R:$R, \"<>L\", 'Fire Protection'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Fire Protection'!$Y:$Y, 'Fire Protection'!$R:$R, \"=M\", 'Fire Protection'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Fire Protection'!$AB:$AB, \"=TRUE\", 'Fire Protection'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Fire Protection'!$AA:$AA, 'Fire Protection'!$R:$R, \"<>L\", 'Fire Protection'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Fire Protection'!$AA:$AA, 'Fire Protection'!$R:$R, \"=L\", 'Fire Protection'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Fire Protection'!$AB:$AB, \"=TRUE\", 'Fire Protection'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Architectural",{"$f":"Architectural!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"Architectural!K26","v":0},{"$f":"Architectural!L26","v":0},{"$f":"Architectural!M26","v":0},null,null,null,{"$f":"SUMPRODUCT(--(Architectural!$R$8:$R$60=\"M\"), Architectural!$W$8:$W$60, Architectural!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Architectural!$R$8:$R$60=\"L\"), Architectural!$W$8:$W$60, Architectural!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--(Architectural!$R$8:$R$60=\"E\"), Architectural!$W$8:$W$60, Architectural!$X$8:$X$60)","v":0},null,null,null,"Architectural",null,1,"EA",{"$f":"SUMIFS(Architectural!$Y:$Y, Architectural!$R:$R, \"<>L\", Architectural!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Architectural!$Y:$Y, Architectural!$R:$R, \"=M\", Architectural!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Architectural!$AB:$AB, \"=TRUE\", Architectural!$Y:$Y)","v":0},null,{"$f":"SUMIFS(Architectural!$AA:$AA, Architectural!$R:$R, \"<>L\", Architectural!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS(Architectural!$AA:$AA, Architectural!$R:$R, \"=L\", Architectural!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF(Architectural!$AB:$AB, \"=TRUE\", Architectural!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Cable Management",{"$f":"'Cable Management'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Cable Management'!K31","v":0},{"$f":"'Cable Management'!L31","v":0},{"$f":"'Cable Management'!M31","v":0},null,null,null,{"$f":"SUMPRODUCT(--('Cable Management'!$R$8:$R$60=\"M\"), 'Cable Management'!$W$8:$W$60, 'Cable Management'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Cable Management'!$R$8:$R$60=\"L\"), 'Cable Management'!$W$8:$W$60, 'Cable Management'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Cable Management'!$R$8:$R$60=\"E\"), 'Cable Management'!$W$8:$W$60, 'Cable Management'!$X$8:$X$60)","v":0},null,null,null,"Cable Management",null,1,"EA",{"$f":"SUMIFS('Cable Management'!$Y:$Y, 'Cable Management'!$R:$R, \"<>L\", 'Cable Management'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Cable Management'!$Y:$Y, 'Cable Management'!$R:$R, \"=L\", 'Cable Management'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Cable Management'!$AB:$AB, \"=TRUE\", 'Cable Management'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Cable Management'!$AA:$AA, 'Cable Management'!$R:$R, \"<>L\", 'Cable Management'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Cable Management'!$AA:$AA, 'Cable Management'!$R:$R, \"=L\", 'Cable Management'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Cable Management'!$AB:$AB, \"=TRUE\", 'Cable Management'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
["Security/Access",{"$f":"'Security Access'!C5","v":"NA - No Scope of Work Included in Quote."},null,null,null,null,null,null,null,{"$f":"'Security Access'!K25","v":0},{"$f":"'Security Access'!L25","v":0},{"$f":"'Security Access'!M25","v":0},null,null,null,{"$f":"SUMPRODUCT(--('Security Access'!$R$8:$R$60=\"M\"), 'Security Access'!$W$8:$W$60, 'Security Access'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Security Access'!$R$8:$R$60=\"L\"), 'Security Access'!$W$8:$W$60, 'Security Access'!$X$8:$X$60)","v":0},{"$f":"SUMPRODUCT(--('Security Access'!$R$8:$R$60=\"E\"), 'Security Access'!$W$8:$W$60, 'Security Access'!$X$8:$X$60)","v":0},null,null,null,"Security/Access",null,1,"EA",{"$f":"SUMIFS('Security Access'!$Y:$Y, 'Security Access'!$R:$R, \"<>L\", 'Security Access'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Security Access'!$Y:$Y, 'Security Access'!$R:$R, \"=L\", 'Security Access'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Security Access'!$AB:$AB, \"=TRUE\", 'Security Access'!$Y:$Y)","v":0},null,{"$f":"SUMIFS('Security Access'!$AA:$AA, 'Security Access'!$R:$R, \"<>L\", 'Security Access'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIFS('Security Access'!$AA:$AA, 'Security Access'!$R:$R, \"=L\", 'Security Access'!$AB:$AB, \"=FALSE\")","v":0},{"$f":"SUMIF('Security Access'!$AB:$AB, \"=TRUE\", 'Security Access'!$AA:$AA)","v":0},0,null,"-","-","N/A"]
[null,null,null,null,null,null,null,null,null,{"$f":" SUM(J11:J24)","v":0},{"$f":" SUM(K11:K24)","v":0},{"$f":" SUM(L11:L24)","v":0},null,null,null,{"$f":" SUM(P11:P24)","v":0},0,0,null,null,null,null,null,null,null,"TOTAL COST",null,{"$f":"SUM(Z11:AB24)","v":0},null,"TOTAL REV",null,{"$f":"SUM(AD11:AF24)","v":0},null,null,"Blended Margin",null,{"$f":"IF(AND(AB25<>0, AF25<>0), 1-(AB25/AF25), \"-\")","v":"-"}]
["EQUIPMENT = ","Capitol Assets (gens, batts, DC plants,CBs, ATSs, HVAC controller)",null,null,null,null,null,null,"Bid Total",{"$f":"SUM(J25:M25)","v":0},null,null,null,null,"Cost Sub-Total ",{"$f":"SUM(P25:S25)","v":0}]
["MATERIALS = ","Conduit, cable, ladder rack, concrete, dirt,etc",null,null,null,null,null,0,"Tax",{"$f":"J25*H27","v":0}," ",null,null,null,"Tax",{"$f":"P25*M27","v":0}]
["LABOR = ","All labor and trades on site and remote",null,null,null,null,null,null,"Quote Total",{"$f":"SUM(J26:J27)","v":0},null,null,null,null,"Cost Total",{"$f":"SUM(P26:P27)","v":0}]
[]
[]
[]
[null,"Quotation Validity: 60 Days from",{"$f":"B5","v":"MM/DD/YY"},null,null,null,null,null,null,"Estimated Project Completion After Receipt of Order:","tbd"]
["Any added equipment, materials, or work not quoted herein, shall require a change order.  Freight and taxes are quoted & invoiced separately. Allowances are billed not to exceed Alpha rates, with anyoverages invoiced as added work."]
["Applicable sales tax and freight are not included in quote."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate Value Approval Matrix",null,null,"Approved by:"]
[]
["Prepared by (Vendor):","Please Address Purchase Order To:"]
["Name","Altair Advanced Industries, Inc"]
["Alpha","3765 Alpha Way, WA 98226"]
["Phone Number","E-Mail Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Margin Approval Matirix"]
["E-Mail Address","Bellingham, Washington"]

{"sheet":"General Conditions","index":3,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,2,7,9],[8,2,8,9],[10,2,10,9],[5,15,6,16],[23,8,23,9],[4,2,6,9],[24,8,24,9],[9,2,9,9],[13,2,13,9],[11,2,11,9],[20,2,20,9],[19,2,19,9],[17,2,17,9],[18,2,18,9],[12,2,12,9],[15,2,15,9],[16,2,16,9],[14,2,14,9],[0,3,0,8],[0,20,0,21],[4,10,4,12],[5,25,6,25],[5,26,6,26],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,17,6,18],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales - General Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"General Condition"]
[null,"Return to Main Summary"]
[]
[null,"General Conditions:","Design, Engineering and Mobilization",null,null,null,null,null,null,null,"CAT"]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Design Fees:","Architectural, Structural, MEP drawings - Allowance",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[2,"Permitting:","(Special, Zoning, Planning, Historical or USE permitting) Allowance",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[3,"Environmental Permitting","(Arcadis, EPA) Allowance - excluding SPCC plan at added costs.",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[4,"Permit Cost:","(building or Mep permit) Allowance",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"W11*X11/(1-Z11)","v":0},false,"E",3]
[5,"Project Management - RCM:",null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[6,"Supervision - PM:","(direct on site superintendent)",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[7,"Construction Debris Removal:","Allowance",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[8,"Power Company Back Charges","describe - primary voltage thru xx KVA XFMR to MD terminations - allowance",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,7]
[9,"Final Cleaning","Allowance",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,8]
[10,"Contingency","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,9]
[11,"Mobilization","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,10]
[12,"DEMO","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,11]
[13,"Power Strip Replacement","INSERT NUMBER OF PLUG-STRIPS REPLACED (    ) HERE…..",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,12]
[14,"Specify","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K23)","v":0},{"$f":"SUM(L8:L23)","v":0},{"$f":"SUM(M8:M23)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K24:M24)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Generator ","index":4,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,2,46,9],[44,2,44,9],[45,2,45,9],[41,2,41,9],[40,2,40,9],[43,2,43,9],[42,2,42,9],[39,2,39,9],[33,2,33,9],[36,2,36,9],[37,2,37,9],[32,2,32,9],[35,2,35,9],[34,2,34,9],[38,2,38,9],[13,2,13,9],[20,2,20,9],[26,2,26,9],[22,2,22,9],[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,2,11,9],[24,2,24,9],[25,2,25,9],[23,2,23,9],[17,2,17,9],[21,2,21,9],[27,2,27,9],[49,8,49,9],[50,8,50,9],[4,2,6,9],[31,2,31,9],[28,2,28,9],[29,2,29,9],[30,2,30,9],[15,2,15,9],[19,2,19,9],[16,2,16,9],[18,2,18,9],[12,2,12,9],[14,2,14,9],[47,2,47,9],[7,2,7,9],[0,3,0,8],[0,20,0,21],[4,10,4,12],[5,25,6,25],[5,26,6,26],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales - Generator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Generator"]
[null,"Return to Main Summary"]
[]
[null,"Generator:","NA - No Scope of Work Included in Quote.",null,null,null,null,null,null,null,"CAT"]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work:",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Generator"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Quantity & KW Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Output Circuit Breaker",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,"     Fuel Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[null,"     Tank Size","(48 or 72 hour, specify gallons)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     Load bank","(testing after installation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,7]
[null,"     Distance from MTS or GTG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,8]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,9]
[2,"Fuel","(fill tank after MDEQ inspection)",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Rigging and Setting",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0.2,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2,0,false]
[4,"ATS Switch (UTG and/or GTG)","(isolation bypass type only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0.2,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2,0,false]
[null,"     Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Manual Transfer Switch"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Mounting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Distance from ATS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"Lug Cabinet"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Mounting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Distance from MTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[7,"Feeder conduit and conductors"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[8,"Auxiliary conduit & conductors"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[9,"Misc. "," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=9\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=9\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=9\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K49)","v":0},{"$f":"SUM(L8:L49)","v":0},{"$f":"SUM(M8:M49)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K50:M50)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"UPS-Inverter","index":5,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[17,2,17,9],[18,2,18,9],[29,2,29,9],[19,2,19,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[28,2,28,9],[23,2,23,9],[31,8,31,9],[32,8,32,9],[4,2,6,9],[27,2,27,9],[16,2,16,9],[26,2,26,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[15,2,15,9],[10,2,10,9],[12,2,12,9],[24,2,24,9],[13,2,13,9],[14,2,14,9],[11,2,11,9],[5,25,6,25],[5,26,6,26],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,24,6,24],[0,3,0,8],[0,20,0,21],[4,10,4,12],[5,22,6,22],[5,23,6,23]]}
[null,null,null,"ATS Quote to Sales - UPS Inverter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"UPS System / Inverter System"]
[null,"Return to Main Summary"]
[]
[null,"UPS System / Inverter System:","NA - No Scope of Work Included in Quote.",null,null,null,null,null,null,null,"CAT"]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[1,"UPS ",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false,"M",1]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"L",2]
[null,"     Input Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Output Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,"     Maintenance By-pass",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Modular Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Modular Design (N+1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Run Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Inverter",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Input Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Output Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Maintenance By-pass",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Modular Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Modular Design (N+1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Run Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Feeder Conduit & Conductors",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K31)","v":0},{"$f":"SUM(L8:L31)","v":0},{"$f":"SUM(M8:M31)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K32:N32)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"DC Plant","index":6,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[31,2,31,9],[30,2,30,9],[35,2,35,9],[32,2,32,9],[33,2,33,9],[34,2,34,9],[36,2,36,9],[41,2,41,9],[39,2,39,9],[37,2,37,9],[38,2,38,9],[59,8,59,9],[4,2,6,9],[23,2,23,9],[24,2,24,9],[7,2,7,9],[9,2,9,9],[10,2,10,9],[8,2,8,9],[19,2,19,9],[20,2,20,9],[54,2,54,9],[53,2,53,9],[58,8,58,9],[42,6,42,9],[48,2,48,9],[43,3,43,9],[56,2,56,9],[50,2,50,9],[52,2,52,9],[51,2,51,9],[40,2,40,9],[49,2,49,9],[26,2,26,9],[27,2,27,9],[29,2,29,9],[5,17,6,18],[5,15,6,16],[28,2,28,9],[21,2,21,9],[22,2,22,9],[25,2,25,9],[5,26,6,26],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,24,6,24],[0,3,0,8],[0,20,0,21],[4,10,4,12],[5,21,6,21],[5,20,6,20],[5,19,6,19]]}
[null,null,null,"ATS Quote to Sales - DC Plant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"DC Plant"]
[null,"Return to Main Summary"]
[]
[null,"DC Plant:","NA - No Scope of Work Included in Quote.",null,null,null,null,null,null,null,"CAT"]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"DC Plant -48V",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=1\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false,"M",1]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"L",2]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,"     Main Control Bay","Size",null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[null,"     Auxiliary Bay","Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     Rectification","Size",null,"Quantity",null,"Total",{"$f":" D14*F14","v":0},"DC amps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,7]
[null,"     Distribution Circuit Breakers","Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,8]
[null,null,"Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ","Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Battery System ",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=2\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Catalog #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Amp Hour Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity of -48V Strings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Floor Battery support",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=3\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"slab scan / core drill / floor plates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"concrete cut / remove / replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"under-raised-floor structural steel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Battery Disconnect",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=4\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Battery Bay/Stand/Rack",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=5\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"BDCBB",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=6\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,"Split Bus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Circuit Breaker Positions",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Circuit Breaker Quantity","30A",null,"40A",null,"50A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ","60A",null,"70A",null,"80A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"100A",null,"125A",null,"150A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"200A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Distance From Plant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[7,"Fuse Alarm Panel",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=7\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     CAT #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[8,"Misc. ",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P, \"=8\",R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K58)","v":0},{"$f":"SUM(L8:L58)","v":0},{"$f":"SUM(M8:M58)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K59:N59)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"DC Cabling","index":7,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[36,8,36,9],[4,2,6,9],[7,2,7,7],[32,2,32,7],[23,2,23,7],[28,4,28,7],[29,4,29,7],[33,2,33,7],[24,4,24,7],[26,4,26,7],[27,4,27,7],[30,4,30,7],[31,4,31,7],[25,4,25,7],[0,3,0,8],[0,20,0,21],[5,26,6,26],[35,8,35,9],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales - DC Cabling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"DC Cabling"]
[null,"Return to Main Summary"]
[]
[null,"DC Cabling:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Cabling"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"DC Plant/BTB","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"    Existing Battery/BTB","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"    New Battery/BTB","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Battery #4","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #5","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #6","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #7","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #8","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #9","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Battery #10","Size",null,"# Polarity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     BDCBB #1","Size",null,"# Polarity",null,"# CKTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     BDCBB #2","Size",null,"# Polarity",null,"# CKTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     BDCBB #3","Size",null,"# Polarity",null,"# CKTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     BDCBB #4","Size",null,"# Polarity",null,"# CKTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Inverter #1","Size",null,"# Polarity",null,"# CKTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"     Small Circuits"," ","Quantity",null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#6",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#4",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#2",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#1/0",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#2/0",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#3/0",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"#4/0",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Misc.","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K35)","v":0},{"$f":"SUM(L8:L35)","v":0},{"$f":"SUM(M8:M35)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K36:N36)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Grounding","index":8,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[5,26,6,26],[39,8,39,9],[40,8,40,9],[4,2,6,9],[7,3,7,9],[37,2,37,9],[29,3,29,9],[28,3,28,9],[26,3,26,9],[35,2,35,9],[0,3,0,8],[0,20,0,21],[5,25,6,25],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,15,6,16],[5,17,6,18],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales - Grounding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Grounding"]
[null,"Return to Main Summary"]
[]
[null,"Grounding:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Interior Grounding","Quantity"," ",null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     MGB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     AGB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     750 MCM GREEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     4/0 Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,"     2/0 Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[null,"     1/0 Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     #2 Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     #6 Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Water Pipe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Building Steel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Sprinkler Pipe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Exterior Ring or Electrode",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Equipment Cabinets",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     FEC Cabinets",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Interface Plate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Exterior Grounding",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Well Driven Electrode",null,"describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Ground Field","Rods",null,"#2 Tinned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"     Soil Resistivity Test",null,"describe",null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"     3 PT Fall of Potential Test",null,"describe",null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Bond to Tower",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Bond to SAT Dish","Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Bond to HVAC","Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Bond to Generator","Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Lightning Protection","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A36,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A36,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A36,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A38,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A38,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A38,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K39)","v":0},{"$f":"SUM(L8:L39)","v":0},{"$f":"SUM(M8:M39)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K40:N40)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Surge Suppression System","index":9,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[5,26,6,26],[15,8,15,9],[12,2,12,9],[8,2,8,9],[10,2,10,9],[4,2,6,9],[14,8,14,9],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,24,6,24],[0,3,0,8],[0,20,0,21],[5,22,6,22],[5,23,6,23],[5,25,6,25]]}
[null,null,null,"ATS Quote to Sales - Surge Suppression System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Surge Suppression System"]
[null,"Return to Main Summary"]
[]
[null,"Surge Suppression:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"TVSS",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Rating","Voltage",null,"Ampacity",null,"Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Technology","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Misc. ","describe - TVSS disconnect & circuit breaker, conduit & wiring.",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K14)","v":0},{"$f":"SUM(L8:L14)","v":0},{"$f":"SUM(M8:M14)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K15:N15)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Electrical","index":10,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[38,8,38,9],[39,8,39,9],[8,2,8,9],[20,2,20,9],[4,2,6,9],[36,2,36,9],[7,2,7,9],[19,2,19,9],[21,2,21,9],[23,2,23,9],[28,2,28,9],[29,2,29,9],[35,2,35,9],[22,2,22,9],[24,2,24,9],[5,26,6,26],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,24,6,24],[0,3,0,8],[0,20,0,21],[5,22,6,22],[5,23,6,23],[5,25,6,25]]}
[null,null,null,"ATS Quote to Sales - Electrical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Electrical"]
[null,"Return to Main Summary"]
[]
[null,"Electrical:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Switchgear",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Main Disconnect (MD)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Main Distribution panel (MDP)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Rectifier panel (RP-1)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,"     Inverter/UPS panel (INV-1)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[null,"     Inverter/UPS bypass","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     other panel (specify)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     other panel (specify)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     other panel (specify)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     other panel (specify)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     other panel (specify)","Ampacity",null,"Voltage ",null,"AIC",null,"Phase ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Feeder Conduits & Conductors","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Branch Conduits & Conductors","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Light Fixtures",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Fluorescent w/Shattershield Lamps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Exit Signs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Emergency Lights",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Devices",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A30,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Single Pole Switches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Three-way Switches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Convenience Receptacle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Twist-lock Receptacle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Wiremold","Size",null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A37,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A37,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A37,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K38)","v":0},{"$f":"SUM(L8:L38)","v":0},{"$f":"SUM(M8:M38)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K39:M39)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"HVAC System","index":11,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[29,2,29,9],[43,2,43,9],[41,2,41,9],[30,2,30,9],[28,2,28,9],[25,2,25,9],[7,2,7,9],[8,2,8,9],[10,2,10,9],[4,2,6,9],[17,2,17,9],[20,2,20,9],[23,2,23,9],[24,2,24,9],[22,2,22,9],[14,2,14,9],[9,2,9,9],[13,2,13,9],[21,2,21,9],[15,2,15,9],[16,2,16,9],[46,8,46,9],[47,8,47,9],[44,2,44,9],[31,2,31,9],[40,2,40,9],[36,2,36,9],[38,2,38,9],[39,2,39,9],[35,2,35,9],[34,2,34,9],[33,2,33,9],[5,26,6,26],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,24,6,24],[0,3,0,8],[0,20,0,21],[5,22,6,22],[5,23,6,23],[5,25,6,25]]}
[null,null,null,"ATS Quote to Sales - HVAC System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"HVAC System"]
[null,"Return to Main Summary"]
[]
[null,"HVAC:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Wall Mounted"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,null,"Voltage",null,null,"Ampacity",null,null,"Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[2,"Split System"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,7]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"Voltage",null,null,"Ampacity",null,null,"Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Packaged"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A21,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"Voltage",null,null,"Ampacity",null,null,"Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Controls"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Thermostats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Distribution",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A34,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Supply Duct ","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Hot/Cold Rows","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Return ","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"Exhaust Fan",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A39,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A39,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A39,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Control","specify CFM and Manufacture, part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Automatic damper",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,"Voltage",null,null,"Ampacity",null,null,"Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[7,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A45,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A45,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A45,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K46)","v":0},{"$f":"SUM(L8:L46)","v":0},{"$f":"SUM(M8:M46)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K47:M47)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Environmental Monitoring","index":12,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[28,8,28,9],[4,2,6,9],[11,4,11,5],[25,2,25,9],[7,2,7,9],[8,2,8,9],[23,2,23,9],[11,6,11,9],[27,8,27,9],[0,3,0,8],[0,20,0,21],[5,26,6,26],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales -Environmental Monitoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Envionmental Monitoring"]
[null,"Return to Main Summary"]
[]
[null,"Environmental Monitoring:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Monitoring System"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     House Generator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Portable Generator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     HVAC","Quantity",null,"Controller",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Temperature","Quantity",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Hydrogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     ATS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     MTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     DC Plant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     UPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Inverter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Power Router",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     TVSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Fire Suppression",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Conduit & Cables","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A24,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A24,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A24,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A26,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K27)","v":0},{"$f":"SUM(L8:L27)","v":0},{"$f":"SUM(M8:M27)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K28:M28)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Fire Protection","index":13,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[13,2,13,9],[7,2,7,9],[8,2,8,9],[9,4,9,9],[5,15,6,16],[12,2,12,9],[26,8,26,9],[27,8,27,9],[24,2,24,9],[23,2,23,9],[21,2,21,9],[22,2,22,9],[14,4,14,9],[20,2,20,9],[18,2,18,9],[15,2,15,9],[17,2,17,9],[19,2,19,9],[16,2,16,9],[0,3,0,8],[0,20,0,21],[5,26,6,26],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,24,6,24],[5,17,6,18],[5,19,6,19],[4,2,6,9]]}
[null,null,null,"ATS Quote to Sales -Fire Protection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Fire Protection"]
[null,"Return to Main Summary"]
[]
[null,"Fire Protection:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Clean Agent"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Rooms",null,"Describe","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Zones",null,"Under Floors",null,"Above Ceiling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Cubic Feet",null,"Concentration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Sprinkler",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A14,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Rooms ",null,"Describe","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Pre-action","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Detection & Evacuation",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Fire Alarm Control Panel (FACP)","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Smoke Detectors","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Heat Detectors","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Audible/Visual Devices","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Abort Button","describe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A25,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K26)","v":0},{"$f":"SUM(L8:L26)","v":0},{"$f":"SUM(M8:M26)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K27:M27)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Architectural","index":14,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[26,8,26,9],[19,2,19,9],[20,2,20,9],[4,2,6,9],[23,2,23,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9],[21,2,21,9],[22,2,22,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,9],[25,8,25,9],[5,22,6,22],[0,3,0,8],[0,20,0,21],[5,23,6,23],[5,25,6,25],[5,26,6,26],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales -Architectural",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Architectural"]
[null,"Return to Main Summary"]
[]
[null,"Architectural:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Excavation, Trench & Backfill","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[2,"Concrete Work","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[3,"Masonry","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[4,"Structural Steel","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[5,"Light Gauge Metal Framing","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[6,"Drywall","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[7,"Painting","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[8,"VCT Flooring","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,7]
[9,"Raised Computer Flooring","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,8]
[10,"Acoustical Ceiling","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,9]
[11,"Precast Concrete Building","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,10]
[12,"Windows & Doors","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,11]
[13,"Roofing","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,12]
[14,"Fiber Vault","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,13]
[15,"Paving","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,14]
[16,"Fencing","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,15]
[17,"Misc. ","describe",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,17]
[null," "," "," "," "," ",null," ","Subtotal",null,{"$f":"SUM(K8:K24)","v":0},{"$f":"SUM(L8:L24)","v":0},{"$f":"SUM(M8:M24)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null," "," "," ","Grand Total",null,null,null,{"$f":"SUM(K26:M26)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," "," "," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Cable Management","index":15,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[31,8,31,9],[4,2,6,9],[7,2,7,9],[12,2,12,9],[16,2,16,9],[21,2,21,9],[28,2,28,9],[26,2,26,9],[17,2,17,9],[18,2,18,9],[22,2,22,9],[30,8,30,9],[0,3,0,8],[0,20,0,21],[5,26,6,26],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales -Cable Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Cable Management"]
[null,"Return to Main Summary"]
[]
[null,"Infrastructure:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Cable Rack"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Floor Stands",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,4]
[2,"Fiber Guide"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A13,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,5]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,null,6]
[null,"     Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Express Exits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Equipment Bays"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A18,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[4,"Fiber Management"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Fiber Entry Cabinets","Quantity",null,"Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Fiber Bay","Quantity",null,"Manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[5,"Hardware Removal","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A27,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A27,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A27,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[6,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A29,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K30)","v":0},{"$f":"SUM(L8:L30)","v":0},{"$f":"SUM(M8:M30)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K31:M31)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]

{"sheet":"Security Access","index":16,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[25,8,25,9],[4,2,6,9],[22,2,22,9],[16,2,16,9],[7,2,7,9],[15,2,15,9],[8,2,8,9],[24,8,24,9],[0,3,0,8],[0,20,0,21],[5,26,6,26],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,25,6,25],[5,15,6,16],[5,17,6,18],[5,19,6,19],[5,24,6,24]]}
[null,null,null,"ATS Quote to Sales -Security System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item Detail"]
[null,"Security System"]
[null,"Return to Main Summary"]
[]
[null,"Security/Access:","NA - No Scope of Work Included in Quote."]
[null," ",null,null,null,null,null,null,null,null,"M","L","E",null,null,"REF#",null,"CAT",null,"HE Part ","Part Number","Description","QTY","Unit Cost","Extended Cost","Margin","Total Sell Price"]
["REF #","Statement of Work",null,null,null,null,null,null,null,null,"Material","Labor","Equipment"]
[1,"Security System"," ",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A8,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W8*X8","v":0},0,{"$f":"W8*X8/(1-Z8)","v":0},false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9*X9","v":0},0,{"$f":"W9*X9/(1-Z9)","v":0},false,"M",1]
[null,"     Door Contacts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"L",2]
[null,"     Motion Detectors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false,"E",3]
[null,"     Key Pad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Strobe Light",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Siren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[2,"Badge Access",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A16,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A16,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A16,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Manufacturer","Manufacture and part number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Card Reader",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     RTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Mag Lock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,"     Electric Strike",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[3,"Misc. ","describe",null,null,null,null,null,null,null,{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=M\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=L\")","v":0},{"$f":"SUMIFS(AA:AA,P:P,A23,R:R, \"=E\")","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K8:K24)","v":0},{"$f":"SUM(L8:L24)","v":0},{"$f":"SUM(M8:M24)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,null,{"$f":"SUM(K25:M25)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,false]