{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SITESYNC_COMMISSIONING","START"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"SITESYNC_COMMISSIONING","index":0,"n_rows":112,"n_cols":25,"rows_kept":112,"cut":false,"hidden":false,"merged":[[61,9,61,10],[39,1,39,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[60,15,60,16],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[57,9,57,10],[55,9,55,10],[56,9,56,10],[40,13,40,14],[40,11,40,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[50,13,50,14],[58,9,58,10],[59,9,59,10],[60,9,60,10],[41,9,41,10],[42,9,42,10],[46,9,46,10],[39,9,40,10],[60,13,60,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[61,13,61,14],[41,15,41,16],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[51,13,51,14],[52,13,52,14],[53,13,53,14],[54,13,54,14],[55,13,55,14],[56,13,56,14],[57,13,57,14],[58,13,58,14],[59,13,59,14],[41,13,41,14],[42,13,42,14],[61,15,61,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[28,15,28,20],[29,15,29,20],[30,15,30,20],[51,15,51,16],[52,15,52,16],[40,15,40,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[39,11,39,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[10,0,10,20],[9,0,9,20],[20,15,20,20],[21,15,21,20],[23,15,23,20],[24,15,24,20],[25,15,25,20],[26,15,26,20],[27,15,27,20],[12,0,12,20],[25,0,25,3],[13,0,13,20],[14,6,14,13],[23,4,23,12],[24,4,24,12],[26,0,26,5],[26,7,27,13],[27,0,27,5],[14,15,14,20],[15,15,15,20],[16,15,16,20],[73,2,73,3],[74,2,74,3],[39,0,40,0],[71,2,71,3],[72,2,72,3],[67,2,68,3],[67,1,68,1],[67,4,68,4],[66,5,66,8],[59,1,59,8],[56,1,56,8],[57,1,57,8],[58,1,58,8],[60,1,60,8],[61,1,61,8],[55,1,55,8],[73,6,73,7],[75,2,75,3],[76,2,76,3],[75,6,75,7],[75,10,75,11],[25,4,25,12],[28,4,28,12],[29,4,29,12],[30,4,30,12],[31,4,31,12],[32,4,32,12],[33,4,33,12],[34,4,34,12],[66,1,66,4],[69,2,69,3],[70,2,70,3],[66,9,66,12],[69,6,69,7],[69,10,69,11],[72,6,72,7],[72,10,72,11],[64,11,65,20],[30,13,31,13],[31,15,31,20],[32,15,32,20],[73,14,73,15],[73,18,73,19],[74,6,74,7],[74,10,74,11],[74,14,74,15],[74,18,74,19],[69,14,69,15],[69,18,69,19],[70,6,70,7],[70,10,70,11],[70,14,70,15],[70,18,70,19],[71,6,71,7],[71,10,71,11],[71,14,71,15],[71,18,71,19],[72,14,72,15],[72,18,72,19],[73,10,73,11],[66,13,66,16],[66,17,66,20],[67,5,68,5],[15,3,15,12],[16,3,16,12],[17,3,17,12],[22,15,22,20],[67,6,68,7],[67,8,68,8],[67,9,68,9],[67,10,68,11],[67,12,68,12],[67,13,68,13],[67,14,68,15],[67,16,68,16],[67,17,68,17],[67,18,68,19],[67,20,68,20],[42,11,42,12],[41,11,41,12],[37,0,37,7],[33,15,33,20],[34,15,34,20],[37,11,38,20],[75,14,75,15],[75,18,75,19],[76,6,76,7],[76,10,76,11],[76,14,76,15],[76,18,76,19],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[28,0,34,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[34,2,34,3],[23,0,23,3],[24,0,24,3],[22,7,22,13],[18,3,18,12],[19,3,19,12],[17,15,17,20],[18,15,18,20],[19,15,19,20]]}
["24 hour",null,"Click this cell and select an option from the drop down box.",null,null,null,null,"Same as M-F",null,"By Group",null,"Click this cell and select an option from the drop down box.","By Group"]
["AM",null,"USB flash drive",null,null,null,null,"Schedule #1",null,"By Zone",null,"Original Order ","By Zone (provide additional information)"]
["PM",null,"Ship pre-loaded tablet PC",null,null,null,null,"Schedule #2",null,"By Network",null,"Repeat Order"]
["From Sunrise",null,null,null,null,null,null,"Schedule #3",null,"No",null,"Click this cell and select an option from the drop down box."]
["From Sunset",null,"Simple Settings",null,null,null,null,"Schedule #4",null,null,null,"Factory commission per this worksheet."]
["No Entry",null,"Advanced Settings",null,null,null,null,"Schedule #5",null,null,null,"I will generate and return a BC file for factory commissioning."]
[null,null,null,null,null,null,null,null,null,null,null,"To be programmed in the field.  Ship the fixtures \"neutral\" (100% power)"]
[]
["#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
["CUSTOMER PRE-COMMISSIONING SPECIFICATION WORKSHEET REV. D"]
["ACKNOWLEDGEMENT: By submitting this form to Hubbell Lighting, I authorize Hubbell to program the lighting fixtures and deliver software and materials as specified herein.  I understand that a late or revised submission may be denied or may result in additional service charges."]
[]
[{"$f":"IF(O16,\"Worksheet is complete.  Please save as an EXCEL FILE and return to Beacon Products.\",\"ATTENTION: Worksheet is NOT COMPLETE!  Please complete the sections indicated in red.\")","v":"ATTENTION: Worksheet is NOT COMPLETE!  Please complete the sections indicated in red."}]
[{"$f":"IF(W14=1,\"ATTENTION: Your control strategy includes motion zone control.  Attach supplementary info. or contact Tech Support to fully define.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W42:W62)>0,1,0)","v":0}]
["JOB INFORMATION ",null,null,null,null,null,{"$f":"IF(AND(N16=\"OK\",N17=\"OK\",N18=\"OK\",N19=\"OK\",N20=\"OK\"),\"SECTION COMPLETE\",\"This section is NOT COMPLETE.  Please fill in all fields.\")","v":"This section is NOT COMPLETE.  Please fill in all fields."},null,null,null,null,null,null,null,null,"SPECIAL REQUESTS  (Subject to review )"]
["Job Name:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=\"\",\"X\",\"OK\")","v":"X"},{"$f":"AND(G15=\"SECTION COMPLETE\",H23=\"SECTION COMPLETE\",OR(NOT(O25),AND(L38=\"SECTION COMPLETE\",L65=\"SECTION COMPLETE\")))","v":false}]
["Customer PO #:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17=\"\",\"X\",\"OK\")","v":"X"},{"$f":"IF(O18=1,TRUE,O16)","v":false}]
["Sales Order #:",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["Job site city & state:",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["Job site ZIP code:",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
["SOFTWARE & BRIDGE NODE DELIVERY ",null,null,null,null,null,null,{"$f":"IF(AND(N24=\"OK\",N25=\"OK\",N26=\"OK\",N29=\"OK\",N30=\"OK\",N31=\"OK\",N33=\"OK\",N34=\"OK\",N35=\"OK\"),\"SECTION COMPLETE\",\"Section is NOT COMPLETE. Please fill in all fields.\")","v":"Section is NOT COMPLETE. Please fill in all fields."}]
["Type of Order:",null,null,null,"Click this cell and select an option from the drop down box.",null,null,null,null,null,null,null,null,{"$f":"IF(E24=\"Click this cell and select an option from the drop down box.\",\"X\",\"OK\")","v":"X"}]
["Commissioning:",null,null,null,"Click this cell and select an option from the drop down box.",null,null,null,null,null,null,null,null,{"$f":"IF(E25=\"Click this cell and select an option from the drop down box.\",\"X\",\"OK\")","v":"X"},{"$f":"OR(E25=\"Click this cell and select an option from the drop down box.\",E25=\"Factory commission per this worksheet.\")","v":true}]
["Software Delivery (REQUIRED):",null,null,null,"Click this cell and select an option from the drop down box.",null,null,null,null,null,null,null,null,{"$f":"IF(E26=\"Click this cell and select an option from the drop down box.\",\"X\",\"OK\")","v":"X"}]
["# Extra SWBRG - bridge node (OPTIONAL):",null,null,null,null,null,0,"Note: Each original order requires at minimum one SWUSB or SWTAB.  All SWUSB, SWTAB, or SWBRG should be included on your purchase order.",null,null,null,null,null,null,{"$f":"OR(E27=\"Click this cell and select an option from the drop down box.\",E27=\"Factory commission per this worksheet.\")","v":false}]
["# Extra SWUSB - software license and\n                             bridge node (OPTIONAL):",null,null,null,null,null,0]
["Deliver to:",null,"Name:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E29=\"\",\"X\",\"OK\")","v":"X"}]
[null,null,"Organization:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E30=\"\",\"X\",\"OK\")","v":"X"}]
[null,null,"Address:",null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Address:"]
[null,null,"City/State/ZIP",null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Phone:",null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"e-mail:",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
["FIXTURE TYPE INFORMATION & SETTINGS",null,null,null,null,null,null,null,null,{"$f":"AND(O27=TRUE,I38=FALSE)","v":false},null,{"$f":"IF(O25=FALSE,\"Based on your commissioning choice, you may SKIP this section.\",IF(V41<0,\"Section is NOT complete.  Please complete indicated fields.\",IF(V41=0,\"You MUST complete at least one line of this section.\",\"SECTION COMPLETE\")))","v":"You MUST complete at least one line of this section."}]
["For each set of fixtures with common catalog number and settings, fill out one row.  "]
["Qty","Catalog #",null,null,null,null,null,null,null,"Type #",null,"Select the schedule you want to run on…",null,null,null,null,null,"Group","Motion ","Delay","Completion"]
[null,"See Hubbell Lighting literature for valid fixture options.",null,null,null,null,null,null,null,null,null,"MON - FRI",null,"SATURDAY",null,"SUNDAY",null,"#","Master","(mins.)","Status",{"$f":"SUM(V42:V62)","v":0},"Weekday N/A count","Motion sensor?"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,{"$f":"IF(OR(A42<>\"\",B42<>\"\",J42<>\"\"),IF(OR(A42=\"\",B42=\"\",J42=\"\"),\"Incomplete\",\"OK\"),\"No entry\")","v":"No entry"},{"$f":"IF(U42=\"No entry\",0,IF(U42=\"OK\",1,-100))","v":0},{"$f":"IF(S42=\"By Zone\",1,0)","v":0},{"$f":"OR(ISNUMBER(FIND(\"MDD\",B42)),ISNUMBER(FIND(\"mdd\",B42)),ISNUMBER(FIND(\"BCM\",B42)),ISNUMBER(FIND(\"bcm\",B42)),ISNUMBER(FIND(\"SWPM\",B42)),ISNUMBER(FIND(\"swpm\",B42)),ISNUMBER(FIND(\"SWFM\",B42)),ISNUMBER(FIND(\"swfm\",B42)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",{"$f":"IF(U43=\"No entry\",0,IF(U43=\"OK\",1,-100))","v":0},{"$f":"IF(S43=\"By Zone\",1,0)","v":0},{"$f":"OR(ISNUMBER(FIND(\"MDD\",B43)),ISNUMBER(FIND(\"mdd\",B43)),ISNUMBER(FIND(\"BCM\",B43)),ISNUMBER(FIND(\"bcm\",B43)),ISNUMBER(FIND(\"SWPM\",B43)),ISNUMBER(FIND(\"swpm\",B43)),ISNUMBER(FIND(\"SWFM\",B43)),ISNUMBER(FIND(\"swfm\",B43)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Schedule #1",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule #1",null,"Same as M-F",null,"Same as M-F",null,"#1","No",10,"No entry",0,0,false]
[{"$f":"SUM(A42:A62)","v":0},"Total fixtures"]
[]
["SCHEDULE SETTINGS",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O25=FALSE,\"Based on your commissioning choice, you may SKIP this section.\",IF(U93,\"You MUST complete schedule(s)\"&U94,IF(U90<0,\"Section is NOT complete.  Please fix the schedule indicated.\",IF(U90=0,\"You MUST complete at least one schedule.\",\"SECTION COMPLETE\"))))","v":"You MUST complete schedule(s)  #1"}]
["Complete up to five schedules for inclusion under fixture types above."]
[null,{"$f":"\"SCHEDULE #1 - \"&IF(B90=0,\"NO ENTRY\",IF(B90=1,\"OK\",\"INCOMPLETE\"))","v":"SCHEDULE #1 - NO ENTRY"},null,null,null,{"$f":"\"SCHEDULE #2 - \"&IF(F90=0,\"NO ENTRY\",IF(F90=1,\"OK\",\"INCOMPLETE\"))","v":"SCHEDULE #2 - NO ENTRY"},null,null,null,{"$f":"\"SCHEDULE #3 - \"&IF(J90=0,\"NO ENTRY\",IF(J90=1,\"OK\",\"INCOMPLETE\"))","v":"SCHEDULE #3 - NO ENTRY"},null,null,null,{"$f":"\"SCHEDULE #4 - \"&IF(N90=0,\"NO ENTRY\",IF(N90=1,\"OK\",\"INCOMPLETE\"))","v":"SCHEDULE #4 - NO ENTRY"},null,null,null,{"$f":"\"SCHEDULE #5 - \"&IF(R90=0,\"NO ENTRY\",IF(R90=1,\"OK\",\"INCOMPLETE\"))","v":"SCHEDULE #5 - NO ENTRY"}]
["Event #","Time","Time Format",null,"% Bright","Time","Time Format",null,"% Bright","Time","Time Format",null,"% Bright","Time","Time Format",null,"% Bright","Time","Time Format",null,"% Bright",null,null,null,"`"]
[]
["#1",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#2",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#3",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#4",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#5",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#6",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#7",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
["#8",null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry",null,null,null,"No Entry"]
[]
[null,"No Entry Test","Complete Test","Incomplete test",null,"No Entry Test","Complete Test",null,null,"No Entry Test","Complete Test",null,null,"No Entry Test","Complete Test",null,null,"No Entry Test","Complete Test"]
[null,{"$f":"AND(C70=\"No Entry\",B70=\"\",E70=\"\")","v":true},{"$f":"OR(AND(C70=\"Power on at Panel\",B70=\"\",E70<>\"\",E70>=0,E70<=100),AND(C70=\"24 hour\",B70<>\"\",B70>=0,E70<>\"\",E70>=0,E70<=100),AND(OR(C70=\"AM\",C70=\"PM\"),B70<>\"\",B70>=100,B70<1259,E70<>\"\",E70>=0,E70<=100),AND(OR(C70=\"From Sunrise\",C70=\"From Sunset\"),B70>-559,B70<559,E70<>\"\",E70>=0,E70<=100))","v":false},{"$f":"AND(B80=FALSE,C80=FALSE)","v":false},null,{"$f":"AND(G70=\"No Entry\",F70=\"\",I70=\"\")","v":true},{"$f":"OR(AND(G70=\"Power on at Panel\",F70=\"\",I70<>\"\",I70>=0,I70<=100),AND(G70=\"24 hour\",F70<>\"\",F70>=0,I70<>\"\",I70>=0,I70<=100),AND(OR(G70=\"AM\",G70=\"PM\"),F70<>\"\",F70>=100,F70<1259,I70<>\"\",I70>=0,I70<=100),AND(OR(G70=\"From Sunrise\",G70=\"From Sunset\"),F70>-559,F70<559,I70<>\"\",I70>=0,I70<=100))","v":false},{"$f":"AND(F80=FALSE,G80=FALSE)","v":false},null,{"$f":"AND(K70=\"No Entry\",J70=\"\",M70=\"\")","v":true},{"$f":"OR(AND(K70=\"Power on at Panel\",J70=\"\",M70<>\"\",M70>=0,M70<=100),AND(K70=\"24 hour\",J70<>\"\",J70>=0,M70<>\"\",M70>=0,M70<=100),AND(OR(K70=\"AM\",K70=\"PM\"),J70<>\"\",J70>=100,J70<1259,M70<>\"\",M70>=0,M70<=100),AND(OR(K70=\"From Sunrise\",K70=\"From Sunset\"),J70>-559,J70<559,M70<>\"\",M70>=0,M70<=100))","v":false},{"$f":"AND(J80=FALSE,K80=FALSE)","v":false},null,{"$f":"AND(O70=\"No Entry\",N70=\"\",Q70=\"\")","v":true},{"$f":"OR(AND(O70=\"Power on at Panel\",N70=\"\",Q70<>\"\",Q70>=0,Q70<=100),AND(O70=\"24 hour\",N70<>\"\",N70>=0,Q70<>\"\",Q70>=0,Q70<=100),AND(OR(O70=\"AM\",O70=\"PM\"),N70<>\"\",N70>=100,N70<1259,Q70<>\"\",Q70>=0,Q70<=100),AND(OR(O70=\"From Sunrise\",O70=\"From Sunset\"),N70>-559,N70<559,Q70<>\"\",Q70>=0,Q70<=100))","v":false},{"$f":"AND(N80=FALSE,O80=FALSE)","v":false},null,{"$f":"AND(S70=\"No Entry\",R70=\"\",U70=\"\")","v":true},{"$f":"OR(AND(S70=\"Power on at Panel\",R70=\"\",U70<>\"\",U70>=0,U70<=100),AND(S70=\"24 hour\",R70<>\"\",R70>=0,U70<>\"\",U70>=0,U70<=100),AND(OR(S70=\"AM\",S70=\"PM\"),R70<>\"\",R70>=100,R70<1259,U70<>\"\",U70>=0,U70<=100),AND(OR(S70=\"From Sunrise\",S70=\"From Sunset\"),R70>-559,R70<559,U70<>\"\",U70>=0,U70<=100))","v":false},{"$f":"AND(R80=FALSE,S80=FALSE)","v":false}]
[null,{"$f":"AND(C71=\"No Entry\",B71=\"\",E71=\"\")","v":true},{"$f":"OR(AND(C71=\"Power on at Panel\",B71=\"\",E71<>\"\",E71>=0,E71<=100),AND(C71=\"24 hour\",B71<>\"\",B71>=0,E71<>\"\",E71>=0,E71<=100),AND(OR(C71=\"AM\",C71=\"PM\"),B71<>\"\",B71>=100,B71<1259,E71<>\"\",E71>=0,E71<=100),AND(OR(C71=\"From Sunrise\",C71=\"From Sunset\"),B71>-559,B71<559,E71<>\"\",E71>=0,E71<=100))","v":false},{"$f":"AND(B81=FALSE,C81=FALSE)","v":false},null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false,null,true,false,false]
[]
["Schedule",{"$f":"AND(B80:B87)","v":true},{"$f":"OR(C80:C87)","v":false},{"$f":"OR(D80:D87)","v":false},null,{"$f":"AND(F80:F87)","v":true},{"$f":"OR(G80:G87)","v":false},false,null,{"$f":"AND(J80:J87)","v":true},{"$f":"OR(K80:K87)","v":false},false,null,{"$f":"AND(N80:N87)","v":true},{"$f":"OR(O80:O87)","v":false},false,null,{"$f":"AND(R80:R87)","v":true},{"$f":"OR(S80:S87)","v":false},false]
["Conclusion",{"$f":"IF(D89,-100,IF(C89,1,0))*$O$25","v":0},null,null,null,{"$f":"IF(H89,-100,IF(G89,1,0))*$O$25","v":0},null,null,null,{"$f":"IF(L89,-100,IF(K89,1,0))*$O$25","v":0},null,null,null,{"$f":"IF(P89,-100,IF(O89,1,0))*$O$25","v":0},null,null,null,{"$f":"IF(T89,-100,IF(S89,1,0))*$O$25","v":0},null,null,{"$f":"SUM(B90:R90)","v":0}]
[]
["#Occurrences",{"$f":"COUNTIF($L$42:$Q$62,\"Schedule #1\")","v":22},null,null,null,{"$f":"COUNTIF($L$42:$Q$62,\"Schedule #2\")","v":0},null,null,null,{"$f":"COUNTIF($L$42:$Q$62,\"Schedule #3\")","v":0},null,null,null,{"$f":"COUNTIF($L$42:$Q$62,\"Schedule #4\")","v":0},null,null,null,{"$f":"COUNTIF($L$42:$Q$62,\"Schedule #5\")","v":0}]
["Flag to complte",{"$f":"AND(B92>0,B90<>1)","v":true},null,null,null,{"$f":"AND(F92>0,F90<>1)","v":false},null,null,null,{"$f":"AND(J92>0,J90<>1)","v":false},null,null,null,{"$f":"AND(N92>0,N90<>1)","v":false},null,null,null,{"$f":"AND(R92>0,R90<>1)","v":false},null,null,{"$f":"OR(B93,F93,J93,N93,R93)","v":true}]
[null,{"$f":"IF(B93,\"  #1\",\"\")","v":"  #1"},null,null,null,{"$f":"IF(F93,\"  #2\",\"\")","v":""},null,null,null,{"$f":"IF(J93,\"  #3\",\"\")","v":""},null,null,null,{"$f":"IF(N93,\"  #4\",\"\")","v":""},null,null,null,{"$f":"IF(R93,\"  #5\",\"\")","v":""},null,null,{"$f":"B94&F94&J94&N94&R94","v":"  #1"}]
[null,"TIME/Sorting index","Sorted Time","Time - minutes coverted to 100 scale","Sorted Bright %","TIME/Sorting index","Sorted Time","Time - minutes coverted to 100 scale","Sorted Bright %","TIME/Sorting index","Sorted Time","Time - minutes coverted to 100 scale","Sorted Bright %","TIME/Sorting index","Sorted Time","Time - minutes coverted to 100 scale","Sorted Bright %","TIME/Sorting index","Sorted Time","Time - minutes coverted to 100 scale","Sorted Bright %"]
[null,null,0,{"$f":"INT(C96/100)*100+(C96-INT(C96/100)*100)*1.66666","v":0},{"$f":"IF(B$90<1,200,IF(MIN(B97:B104)>=2400,100,E112))","v":200},null,0,{"$f":"INT(G96/100)*100+(G96-INT(G96/100)*100)*1.66666","v":0},{"$f":"IF(F$90<1,200,IF(MIN(F97:F104)>=2400,100,I112))","v":200},null,0,{"$f":"INT(K96/100)*100+(K96-INT(K96/100)*100)*1.66666","v":0},{"$f":"IF(J$90<1,200,IF(MIN(J97:J104)>=2400,100,M112))","v":200},null,0,{"$f":"INT(O96/100)*100+(O96-INT(O96/100)*100)*1.66666","v":0},{"$f":"IF(N$90<1,200,IF(MIN(N97:N104)>=2400,100,Q112))","v":200},null,0,{"$f":"INT(S96/100)*100+(S96-INT(S96/100)*100)*1.66666","v":0},{"$f":"IF(R$90<1,200,IF(MIN(R97:R104)>=2400,100,U112))","v":200}]
[null,{"$f":"IF(OR(C70=\"24 hour\",C70=\"AM\"),B70-1200*AND(C70=\"AM\",B70>=1200),IF(C70=\"PM\",B70+1200*(B70<1200),IF(C70=\"Power on at Panel\",1300,IF(C70=\"No Entry\",2400,IF(C70=\"From Sunrise\",B70+600-40*(B70<0),IF(C70=\"From Sunset\",B70+ 1800-40*(B70<0),0))))))+ROW()/1000","v":2400.0970000000002},{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B97)-1)/2+1),B$105:B$112,0)))","v":2400},{"$f":"INT(C97/100)*100+(C97-INT(C97/100)*100)*1.66666","v":2400},{"$f":"E96","v":200},{"$f":"IF(OR(G70=\"24 hour\",G70=\"AM\"),F70-1200*AND(G70=\"AM\",F70>=1200),IF(G70=\"PM\",F70+1200*(F70<1200),IF(G70=\"Power on at Panel\",1300,IF(G70=\"No Entry\",2400,IF(G70=\"From Sunrise\",F70+600-40*(F70<0),IF(G70=\"From Sunset\",F70+ 1800-40*(F70<0),0))))))+ROW()/1000","v":2400.0970000000002},{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F97)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"I96","v":200},{"$f":"IF(OR(K70=\"24 hour\",K70=\"AM\"),J70-1200*AND(K70=\"AM\",J70>=1200),IF(K70=\"PM\",J70+1200*(J70<1200),IF(K70=\"Power on at Panel\",1300,IF(K70=\"No Entry\",2400,IF(K70=\"From Sunrise\",J70+600-40*(J70<0),IF(K70=\"From Sunset\",J70+ 1800-40*(J70<0),0))))))+ROW()/1000","v":2400.0970000000002},{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J97)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"M96","v":200},{"$f":"IF(OR(O70=\"24 hour\",O70=\"AM\"),N70-1200*AND(O70=\"AM\",N70>=1200),IF(O70=\"PM\",N70+1200*(N70<1200),IF(O70=\"Power on at Panel\",1300,IF(O70=\"No Entry\",2400,IF(O70=\"From Sunrise\",N70+600-40*(N70<0),IF(O70=\"From Sunset\",N70+ 1800-40*(N70<0),0))))))+ROW()/1000","v":2400.0970000000002},{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N97)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"Q96","v":200},{"$f":"IF(OR(S70=\"24 hour\",S70=\"AM\"),R70-1200*AND(S70=\"AM\",R70>=1200),IF(S70=\"PM\",R70+1200*(R70<1200),IF(S70=\"Power on at Panel\",1300,IF(S70=\"No Entry\",2400,IF(S70=\"From Sunrise\",R70+600-40*(R70<0),IF(S70=\"From Sunset\",R70+ 1800-40*(R70<0),0))))))+ROW()/1000","v":2400.0970000000002},{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R97)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"U96","v":200}]
[null,{"$f":"IF(OR(C71=\"24 hour\",C71=\"AM\"),B71-1200*AND(C71=\"AM\",B71>=1200),IF(C71=\"PM\",B71+1200*(B71<1200),IF(C71=\"Power on at Panel\",1300,IF(C71=\"No Entry\",2400,IF(C71=\"From Sunrise\",B71+600-40*(B71<0),IF(C71=\"From Sunset\",B71+ 1800-40*(B71<0),0))))))+ROW()/1000","v":2400.098},{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B98)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C98=2400,E97,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B106)-2)/2)+1,B$105:B$112,0))))","v":200},2400.098,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F98)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G98=2400,I97,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F106)-2)/2)+1,F$105:F$112,0))))","v":200},2400.098,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J98)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K98=2400,M97,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J106)-2)/2)+1,J$105:J$112,0))))","v":200},2400.098,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N98)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O98=2400,Q97,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N106)-2)/2)+1,N$105:N$112,0))))","v":200},2400.098,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R98)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S98=2400,U97,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R106)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.0990000000002,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B99)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C99=2400,E98,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B107)-2)/2)+1,B$105:B$112,0))))","v":200},2400.0990000000002,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F99)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G99=2400,I98,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F107)-2)/2)+1,F$105:F$112,0))))","v":200},2400.0990000000002,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J99)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K99=2400,M98,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J107)-2)/2)+1,J$105:J$112,0))))","v":200},2400.0990000000002,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N99)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O99=2400,Q98,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N107)-2)/2)+1,N$105:N$112,0))))","v":200},2400.0990000000002,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R99)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S99=2400,U98,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R107)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.1,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B100)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C100=2400,E99,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B108)-2)/2)+1,B$105:B$112,0))))","v":200},2400.1,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F100)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G100=2400,I99,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F108)-2)/2)+1,F$105:F$112,0))))","v":200},2400.1,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J100)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K100=2400,M99,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J108)-2)/2)+1,J$105:J$112,0))))","v":200},2400.1,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N100)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O100=2400,Q99,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N108)-2)/2)+1,N$105:N$112,0))))","v":200},2400.1,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R100)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S100=2400,U99,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R108)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.1010000000001,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B101)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C101=2400,E100,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B109)-2)/2)+1,B$105:B$112,0))))","v":200},2400.1010000000001,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F101)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G101=2400,I100,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F109)-2)/2)+1,F$105:F$112,0))))","v":200},2400.1010000000001,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J101)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K101=2400,M100,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J109)-2)/2)+1,J$105:J$112,0))))","v":200},2400.1010000000001,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N101)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O101=2400,Q100,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N109)-2)/2)+1,N$105:N$112,0))))","v":200},2400.1010000000001,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R101)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S101=2400,U100,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R109)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.1019999999999,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B102)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C102=2400,E101,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B110)-2)/2)+1,B$105:B$112,0))))","v":200},2400.1019999999999,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F102)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G102=2400,I101,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F110)-2)/2)+1,F$105:F$112,0))))","v":200},2400.1019999999999,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J102)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K102=2400,M101,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J110)-2)/2)+1,J$105:J$112,0))))","v":200},2400.1019999999999,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N102)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O102=2400,Q101,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N110)-2)/2)+1,N$105:N$112,0))))","v":200},2400.1019999999999,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R102)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S102=2400,U101,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R110)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.1030000000001,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B103)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C103=2400,E102,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B111)-2)/2)+1,B$105:B$112,0))))","v":200},2400.1030000000001,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F103)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G103=2400,I102,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F111)-2)/2)+1,F$105:F$112,0))))","v":200},2400.1030000000001,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J103)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K103=2400,M102,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J111)-2)/2)+1,J$105:J$112,0))))","v":200},2400.1030000000001,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N103)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O103=2400,Q102,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N111)-2)/2)+1,N$105:N$112,0))))","v":200},2400.1030000000001,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R103)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S103=2400,U102,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R111)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,2400.1039999999998,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B104)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C104=2400,E103,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B112)-2)/2)+1,B$105:B$112,0))))","v":200},2400.1039999999998,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F104)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G104=2400,I103,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F112)-2)/2)+1,F$105:F$112,0))))","v":200},2400.1039999999998,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J104)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K104=2400,M103,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J112)-2)/2)+1,J$105:J$112,0))))","v":200},2400.1039999999998,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N104)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O104=2400,Q103,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N112)-2)/2)+1,N$105:N$112,0))))","v":200},2400.1039999999998,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R104)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S104=2400,U103,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R112)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,{"$f":"COUNTIF(B$97:B$104,\"<=\"&B97)","v":1},{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B105)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C105=2400,E104,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B113)-2)/2)+1,B$105:B$112,0))))","v":200},{"$f":"COUNTIF(F$97:F$104,\"<=\"&F97)","v":1},{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F105)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G105=2400,I104,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F113)-2)/2)+1,F$105:F$112,0))))","v":200},{"$f":"COUNTIF(J$97:J$104,\"<=\"&J97)","v":1},{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J105)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K105=2400,M104,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J113)-2)/2)+1,J$105:J$112,0))))","v":200},{"$f":"COUNTIF(N$97:N$104,\"<=\"&N97)","v":1},{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N105)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O105=2400,Q104,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N113)-2)/2)+1,N$105:N$112,0))))","v":200},{"$f":"COUNTIF(R$97:R$104,\"<=\"&R97)","v":1},{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R105)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S105=2400,U104,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R113)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,{"$f":"COUNTIF(B$97:B$104,\"<=\"&B98)","v":2},{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B106)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C106=2400,E105,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B114)-2)/2)+1,B$105:B$112,0))))","v":200},2,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F106)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G106=2400,I105,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F114)-2)/2)+1,F$105:F$112,0))))","v":200},2,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J106)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K106=2400,M105,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J114)-2)/2)+1,J$105:J$112,0))))","v":200},2,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N106)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O106=2400,Q105,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N114)-2)/2)+1,N$105:N$112,0))))","v":200},2,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R106)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S106=2400,U105,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R114)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,3,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B107)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C107=2400,E106,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B115)-2)/2)+1,B$105:B$112,0))))","v":200},3,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F107)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G107=2400,I106,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F115)-2)/2)+1,F$105:F$112,0))))","v":200},3,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J107)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K107=2400,M106,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J115)-2)/2)+1,J$105:J$112,0))))","v":200},3,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N107)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O107=2400,Q106,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N115)-2)/2)+1,N$105:N$112,0))))","v":200},3,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R107)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S107=2400,U106,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R115)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,4,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B108)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C108=2400,E107,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B116)-2)/2)+1,B$105:B$112,0))))","v":200},4,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F108)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G108=2400,I107,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F116)-2)/2)+1,F$105:F$112,0))))","v":200},4,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J108)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K108=2400,M107,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J116)-2)/2)+1,J$105:J$112,0))))","v":200},4,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N108)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O108=2400,Q107,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N116)-2)/2)+1,N$105:N$112,0))))","v":200},4,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R108)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S108=2400,U107,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R116)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,5,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B109)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C109=2400,E108,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B117)-2)/2)+1,B$105:B$112,0))))","v":200},5,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F109)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G109=2400,I108,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F117)-2)/2)+1,F$105:F$112,0))))","v":200},5,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J109)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K109=2400,M108,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J117)-2)/2)+1,J$105:J$112,0))))","v":200},5,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N109)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O109=2400,Q108,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N117)-2)/2)+1,N$105:N$112,0))))","v":200},5,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R109)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S109=2400,U108,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R117)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,6,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B110)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C110=2400,E109,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B118)-2)/2)+1,B$105:B$112,0))))","v":200},6,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F110)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G110=2400,I109,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F118)-2)/2)+1,F$105:F$112,0))))","v":200},6,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J110)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K110=2400,M109,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J118)-2)/2)+1,J$105:J$112,0))))","v":200},6,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N110)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O110=2400,Q109,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N118)-2)/2)+1,N$105:N$112,0))))","v":200},6,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R110)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S110=2400,U109,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R118)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,7,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B111)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C111=2400,E110,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B119)-2)/2)+1,B$105:B$112,0))))","v":200},7,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F111)-1)/2+1),F$105:F$112,0)))","v":2400},2400,{"$f":"IF(F$90<1,200,IF(G111=2400,I110,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F119)-2)/2)+1,F$105:F$112,0))))","v":200},7,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J111)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K111=2400,M110,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J119)-2)/2)+1,J$105:J$112,0))))","v":200},7,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N111)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O111=2400,Q110,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N119)-2)/2)+1,N$105:N$112,0))))","v":200},7,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R111)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S111=2400,U110,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R119)-2)/2)+1,R$105:R$112,0))))","v":200}]
[null,8,{"$f":"INT(INDEX(B$97:B$104,MATCH(INT((ROWS(B$97:B112)-1)/2+1),B$105:B$112,0)))","v":2400},2400,{"$f":"IF(B$90<1,200,IF(C112=2400,E111,INDEX(E$70:E$77,MATCH(INT((ROWS(B$105:B120)-2)/2)+1,B$105:B$112,0))))","v":200},8,{"$f":"INT(INDEX(F$97:F$104,MATCH(INT((ROWS(F$97:F112)-1)/2+1),F$105:F$112,0)))","v":2400},{"$f":"INT(G112/100)*100+(G112-INT(G112/100)*100)*1.66666","v":2400},{"$f":"IF(F$90<1,200,IF(G112=2400,I111,INDEX(I$70:I$77,MATCH(INT((ROWS(F$105:F120)-2)/2)+1,F$105:F$112,0))))","v":200},8,{"$f":"INT(INDEX(J$97:J$104,MATCH(INT((ROWS(J$97:J112)-1)/2+1),J$105:J$112,0)))","v":2400},2400,{"$f":"IF(J$90<1,200,IF(K112=2400,M111,INDEX(M$70:M$77,MATCH(INT((ROWS(J$105:J120)-2)/2)+1,J$105:J$112,0))))","v":200},8,{"$f":"INT(INDEX(N$97:N$104,MATCH(INT((ROWS(N$97:N112)-1)/2+1),N$105:N$112,0)))","v":2400},2400,{"$f":"IF(N$90<1,200,IF(O112=2400,Q111,INDEX(Q$70:Q$77,MATCH(INT((ROWS(N$105:N120)-2)/2)+1,N$105:N$112,0))))","v":200},8,{"$f":"INT(INDEX(R$97:R$104,MATCH(INT((ROWS(R$97:R112)-1)/2+1),R$105:R$112,0)))","v":2400},2400,{"$f":"IF(R$90<1,200,IF(S112=2400,U111,INDEX(U$70:U$77,MATCH(INT((ROWS(R$105:R120)-2)/2)+1,R$105:R$112,0))))","v":200}]

{"sheet":"START","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[[7,0,17,11],[18,0,28,11]]}
[]
[]
[]
["BEACONNECT COMMISSIONING WORKSHEET"]
[]
[]
["ATTENTION:"]
["If you are seeing this page, you need to ENABLE MACROS in order to view and use the commissioning worksheet.  Excel may provide a notification to enable macros when the worksheet is first opened, or there may be a button on the ribbon above this spreadsheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Otherwise, click the round \"Office button\" in the top left corner, click Excel Options, Trust Center, Trust Center Settings, Macro Settings.  Select \"Disable All Macros with Notification\" and click OK twice.  Reload the spreadsheet and enable macros when prompted. (Instructions for Office 2007)"]