{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Panel Identification","Branch Circuits","Alarms","Description","Hidden","Validation","Mirror","VHistory","Scrap","Breaker Panel State","Breaker Panel Template","Branch Circuits Temp","Configure Meter"],"not_rendered":{"images":13,"macros":1,"defined_names":119},"read":"whole","date_system":"1900"}

{"sheet":"Panel Identification","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,0,0,4]]}
["Panel Identification: "]
[]
[null,"Panel Name",""]
[null,"Meter ID",null,"Power meter's Meter ID rotary switch setting. (Choices: 1...8)"]
[null,"Panel Type","3-phase","Click arrow, select from list.  (Choices: single-phase, split-phase, 3-phase)"]
[null,"Nominal Voltage",null,"Nominal panel line-line voltage.  (Establishes alarm thresholds)\n  Example: nominal voltage (400V),  threshold (90%):  alarm occurs at 360V"]
[null,"Rated Amps",null,"Panel mains breaker rated amps.  (Establishes alarm thresholds.)\n  Example:  rated amps (400A), threshold (80%): alarm occurs at 320A"]
[null,"Circuit Positions",42,"Branch circuit breaker positions.  (1-96)"]
[null,"Circuit Layout",2,"Click arrow, select from list.  (Circuit breaker columns.  Choices: 1 or 2)"]
[null,"Circuit Numbers","Odd/Even","Click arrow, select from list.  (Choices: odd/even or sequential)\n    odd/even:   left column 1,3,5… right column 2,4,6....\n    sequential:  left column 1,2,3..., right column 49,50,51..."]
[null,"Phase CT Amps",null,"Amp rating of CTs measuring panel mains breaker."]
[null,"Neutral CT Amps",null,"Amp rating of CT meausring neutral current ( Enter 0 if no neutral CT)"]
[null,"Earth CT Amps",null,"Amp rating of CT measuring ground current ( Enter 0 if no earth CT)"]
[null,"MODBUS Address",null,"Power meter's MODBUS address.  (Enter 0 if MODBUS not used)"]

{"sheet":"Branch Circuits","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"merged":[[0,0,0,14],[2,1,2,3],[2,4,2,5],[2,6,2,7],[2,9,2,11],[2,12,2,13],[2,14,2,15]]}
["Branch Circuits: "]
[]
[null,"Circuit",null,null,"Circuit Breaker",null,"CT",null,null,"Circuit",null,null,"Circuit Breaker",null,"CT"]
[null,"Position","Phase","Name","Poles","Amps","Number","Amps",null,"Position","Phase","Name","Poles","Amps","Number","Amps"]
[null,1,"A",{"$nulls":6},2,"A"]
[null,3,"B",{"$nulls":6},4,"B"]
[null,5,"C",{"$nulls":6},6,"C"]
[null,7,"A",{"$nulls":6},8,"A"]
[null,9,"B",{"$nulls":6},10,"B"]
[null,11,"C",{"$nulls":6},12,"C"]
[null,13,"A",{"$nulls":6},14,"A"]
[null,15,"B",{"$nulls":6},16,"B"]
[null,17,"C",{"$nulls":6},18,"C"]
[null,19,"A",{"$nulls":6},20,"A"]
[null,21,"B",{"$nulls":6},22,"B"]
[null,23,"C",{"$nulls":6},24,"C"]
[null,25,"A",{"$nulls":6},26,"A"]
[null,27,"B",{"$nulls":6},28,"B"]
[null,29,"C",{"$nulls":6},30,"C"]
[null,31,"A",{"$nulls":6},32,"A"]
[null,33,"B",{"$nulls":6},34,"B"]
[null,35,"C",{"$nulls":6},36,"C"]
[null,37,"A",{"$nulls":6},38,"A"]
[null,39,"B",{"$nulls":6},40,"B"]
[null,41,"C",{"$nulls":6},42,"C"]

{"sheet":"Alarms","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[0,0,0,7],[2,1,3,1],[2,2,2,5]]}
["Alarms: "]
[{"$nulls":7}," "]
[null,null,"Panel",{"$nulls":3},"Branch "]
[null,null,"Mains Voltage","Mains Current","Neutral Current","Earth Current","Circuit Currents"]
[null,"Upper Critical Threshold",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0%"}]
[null,"Upper Warning Threshold",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0%"}]
[null,"Lower Warning Threshold",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0%"}]
[null,"Lower Critical Threshold",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0%"}]
[null,"Assert Time (seconds)",0,0,0,0,0]
[null,"Hysteresis (volts or amps)",0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"}]

{"sheet":"Description","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"hidden":true}
{"$rows_empty":8}
[{"$nulls":4},"Raritan PMC Deployment Utility"]

{"sheet":"Hidden","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"hidden":true}
["3-Phase Panel","Single-Phase Panel","Split-Phase Panel",null,"Panel Types",null,"Mains Voltage Alarm Threshold","Min","Max",null,"Mains Current Alarm Threshold","Min","Max",null,"Branch Circuit Current Alarm","Min","Max"]
[{"$nulls":6},"Upper Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Upper Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Upper Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[1,1,"1 (LN)",null,"single-phase",null,"Upper Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Upper Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Upper Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
["2 (LL)",null,"2 (LL)",null,"split-phase",null,"Lower Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Lower Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Lower Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
["2 (LLN)",null,"2 (LLN)",null,"3-phase",null,"Lower Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Lower Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"},null,"Lower Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[3,{"$nulls":5},"Assert Time",0,100,null,"Assert Time",0,100,null,"Assert Time",0,100]
[{"$nulls":6},"Hysteresis",{"v":0,"d":"0.0"},{"v":500,"d":"500.0"},null,"Hysteresis",{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"},null,"Hysteresis",{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"}]
["# Columns","Panel Layout","Phase Assignments (3-Phase)","Phase Assignments (Split-Phase)","Phase Assignments (Single-Phase)"]
[{"$nulls":10},"Mains Neutral Current Alarm","Min","Max"]
[1,"Odd/Even","A","A","A",{"$nulls":5},"Upper Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[2,"Sequential","B","B",{"$nulls":6},"Upper Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[null,null,"C",{"$nulls":7},"Lower Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Lower Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Assert Time",0,100]
[{"$nulls":10},"Hysteresis",0,{"v":2000,"d":"2000.00"}]
[]
[{"$nulls":10},"Mains PE Current Alarm","Min","Max"]
[{"$nulls":10},"Upper Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Upper Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Lower Warning %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Lower Critical %",{"v":0,"d":"0%"},{"v":2,"d":"200%"}]
[{"$nulls":10},"Assert Time",0,100]
[{"$nulls":10},"Hysteresis",{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"}]

{"sheet":"Validation","index":5,"n_rows":5,"n_cols":5,"rows_kept":5,"hidden":true}
[null,"Number of breaker poles"]
[null,"(blank) - no circuit here\n1 (LN) - 1 phase line/neutral circuit\n2 (LL) - 1 phase line/line circuit. e.g 208V\n2 (LLN) - 2 phase line/line + 1-phase line/neutral\n3 (LLL/LLLN) - 3 phase with/without neutral","Circuit breaker current rating (in amperes)","CTs are numbered 1 to 96.  Make sure the same number is not used twice.","CT current rating in amperes"]
[{"$nulls":3},1]
[{"$nulls":3},96]
[{"$nulls":3},"Enter value 1 to 96 or leave blank if no CT at this circuit position."]

{"sheet":"Mirror","index":6,"n_rows":25,"n_cols":11,"rows_kept":25,"hidden":true}
[]
[]
[]
[]
[null,1,"A",{"$nulls":6},2,"A"]
[null,3,"B",{"$nulls":6},4,"B"]
[null,5,"C",{"$nulls":6},6,"C"]
[null,7,"A",{"$nulls":6},8,"A"]
[null,9,"B",{"$nulls":6},10,"B"]
[null,11,"C",{"$nulls":6},12,"C"]
[null,13,"A",{"$nulls":6},14,"A"]
[null,15,"B",{"$nulls":6},16,"B"]
[null,17,"C",{"$nulls":6},18,"C"]
[null,19,"A",{"$nulls":6},20,"A"]
[null,21,"B",{"$nulls":6},22,"B"]
[null,23,"C",{"$nulls":6},24,"C"]
[null,25,"A",{"$nulls":6},26,"A"]
[null,27,"B",{"$nulls":6},28,"B"]
[null,29,"C",{"$nulls":6},30,"C"]
[null,31,"A",{"$nulls":6},32,"A"]
[null,33,"B",{"$nulls":6},34,"B"]
[null,35,"C",{"$nulls":6},36,"C"]
[null,37,"A",{"$nulls":6},38,"A"]
[null,39,"B",{"$nulls":6},40,"B"]
[null,41,"C",{"$nulls":6},42,"C"]

{"sheet":"VHistory","index":7,"n_rows":18,"n_cols":3,"rows_kept":18,"hidden":true}
["Version History"]
["Revision","Date","Description"]
[0.1,"2015-03-19","Original"]
[0.2,"2015-04-03","Change font to red instead of drawing a red border around duplicate CTs"]
[null,null,"Clear out cells prior to deleting the circuit"]
[null,null,"Don't darken borders when circuit is created"]
[null,null,"Fix bug related to not consistently detecting a duplicate CT #"]
[0.3,"2015-04-20","When enter value in poles, cursor moves back to name, should go to rating."]
[null,null,"When add value in BCM CT number, cursor moves to number field in next row, should go to CT rating."]
[null,null,"Change formatting of 2(LL) pole circuit"]
[null,null,"Unprotect the worksheet while the worksheet change is occuring"]
[null,null,"Lock the BCM CT Number, Rating cells in the 2nd position of a 2 (LL) pole circuit"]
[0.4,"???","Michael S. updates"]
[0.5,"2015-07-25","Added code to export Excel file to JSON format"]
[null,"2015-08-12","Added Export button"]
[null,null,"Fixed JSON syntax errors"]
[null,"2015-08-26","Finalized JSON syntax for 2 column, 42 position panel"]
[null,"2015-08-27","Added 'Phase CT Rating' field to 'PMM Panel Mains Meter ' table"]

{"sheet":"Scrap","index":8,"n_rows":42,"n_cols":7,"rows_kept":42,"hidden":true}
[1,"A","25",1,60,1,60]
[3,"B","C3",1,15,3,60]
[5,"C","30",1,15,5,60]
[7,"A","C7",1,15,7,60]
[9,"B"]
[11,"C"]
[13,"A"]
[15,"B"]
[17,"C"]
[19,"A"]
[21,"B"]
[23,"C"]
[25,"A"]
[27,"B"]
[29,"C"]
[31,"A"]
[33,"B"]
[35,"C"]
[37,"A"]
[39,"B"]
[41,"C"]
[2,"A"]
[4,"B"]
[6,"C"]
[8,"A"]
[10,"B"]
[12,"C"]
[14,"A"]
[16,"B"]
[18,"C"]
[20,"A"]
[22,"B"]
[24,"C"]
[26,"A"]
[28,"B"]
[30,"C"]
[32,"A"]
[34,"B"]
[36,"C"]
[38,"A"]
[40,"B"]
[42,"C"]

{"sheet":"Breaker Panel State","index":9,"n_rows":96,"n_cols":12,"rows_kept":96,"hidden":true}
[1,0,0,null,0,null,null,0,false,3,0,0]
[2,0,0,null,0,null,null,0,false,4,0,0]
[3,0,0,null,0,null,null,0,false,5,0,0]
[4,0,0,null,0,null,null,0,false,6,0,0]
[5,0,0,null,0,null,null,0,false,7,0,0]
[6,0,0,null,0,null,null,0,false,8,0,0]
[7,0,0,null,0,null,null,0,false,9,0,0]
[8,0,0,null,0,null,null,0,false,10,0,0]
[9,0,0,null,0,null,null,0,false,11,0,0]
[10,0,0,null,0,null,null,0,false,12,0,0]
[11,0,0,null,0,null,null,0,false,13,0,0]
[12,0,0,null,0,null,null,0,false,14,0,0]
[13,0,0,null,0,null,null,0,false,15,0,0]
[14,0,0,null,0,null,null,0,false,16,0,0]
[15,0,0,null,0,null,null,0,false,17,0,0]
[16,0,0,null,0,null,null,0,false,18,0,0]
[17,0,0,null,0,null,null,0,false,19,0,0]
[18,0,0,null,0,null,null,0,false,20,0,0]
[19,0,0,null,0,null,null,0,false,21,0,0]
[20,0,0,null,0,null,null,0,false,22,0,0]
[21,0,0,null,0,null,null,0,false,23,0,0]
[22,0,0,null,0,null,null,0,false,24,0,0]
[23,0,0,null,0,null,null,0,false,25,0,0]
[24,0,0,null,0,null,null,0,false,26,0,0]
[25,0,0,null,0,null,null,0,false,27,0,0]
[26,0,0,null,0,null,null,0,false,28,0,0]
[27,0,0,null,0,null,null,0,false,29,0,0]
[28,0,0,null,0,null,null,0,false,30,0,0]
[29,0,0,null,0,null,null,0,false,31,0,0]
[30,0,0,null,0,null,null,0,false,32,0,0]
[31,0,0,null,0,null,null,0,false,33,0,0]
[32,0,0,null,0,null,null,0,false,34,0,0]
[33,0,0,null,0,null,null,0,false,35,0,0]
[34,0,0,null,0,null,null,0,false,36,0,0]
[35,0,0,null,0,null,null,0,false,37,0,0]
[36,0,0,null,0,null,null,0,false,38,0,0]
[37,0,0,null,0,null,null,0,false,39,0,0]
[38,0,0,null,0,null,null,0,false,40,0,0]
[39,0,0,null,0,null,null,0,false,41,0,0]
[40,0,0,null,0,null,null,0,false,42,0,0]
[41,0,0,null,0,null,null,0,false,2,0,0]
[42,0,0,null,0,null,null,0,false,44,0,0]
[0,0,0,null,0,null,null,0,false,45,0,0]
[0,0,0,null,0,null,null,0,false,46,0,0]
[0,0,0,null,0,null,null,0,false,47,0,0]
[0,0,0,null,0,null,null,0,false,48,0,0]
[0,0,0,null,0,null,null,0,false,49,0,0]
[0,0,0,null,0,null,null,0,false,50,0,0]
[0,0,0,null,0,null,null,0,false,51,0,0]
[0,0,0,null,0,null,null,0,false,52,0,0]
[0,0,0,null,0,null,null,0,false,53,0,0]
[0,0,0,null,0,null,null,0,false,54,0,0]
[0,0,0,null,0,null,null,0,false,55,0,0]
[0,0,0,null,0,null,null,0,false,56,0,0]
[0,0,0,null,0,null,null,0,false,57,0,0]
[0,0,0,null,0,null,null,0,false,58,0,0]
[0,0,0,null,0,null,null,0,false,59,0,0]
[0,0,0,null,0,null,null,0,false,60,0,0]
[0,0,0,null,0,null,null,0,false,61,0,0]
[0,0,0,null,0,null,null,0,false,62,0,0]
[0,0,0,null,0,null,null,0,false,63,0,0]
[0,0,0,null,0,null,null,0,false,64,0,0]
[0,0,0,null,0,null,null,0,false,65,0,0]
[0,0,0,null,0,null,null,0,false,66,0,0]
[0,0,0,null,0,null,null,0,false,67,0,0]
[0,0,0,null,0,null,null,0,false,68,0,0]
[0,0,0,null,0,null,null,0,false,69,0,0]
[0,0,0,null,0,null,null,0,false,70,0,0]
[0,0,0,null,0,null,null,0,false,71,0,0]
[0,0,0,null,0,null,null,0,false,72,0,0]
[0,0,0,null,0,null,null,0,false,73,0,0]
[0,0,0,null,0,null,null,0,false,74,0,0]
[0,0,0,null,0,null,null,0,false,75,0,0]
[0,0,0,null,0,null,null,0,false,76,0,0]
[0,0,0,null,0,null,null,0,false,77,0,0]
[0,0,0,null,0,null,null,0,false,78,0,0]
[0,0,0,null,0,null,null,0,false,79,0,0]
[0,0,0,null,0,null,null,0,false,80,0,0]
[0,0,0,null,0,null,null,0,false,81,0,0]
[0,0,0,null,0,null,null,0,false,82,0,0]
[0,0,0,null,0,null,null,0,false,83,0,0]
[0,0,0,null,0,null,null,0,false,84,0,0]
[0,0,0,null,0,null,null,0,false,85,0,0]
[0,0,0,null,0,null,null,0,false,86,0,0]
[0,0,0,null,0,null,null,0,false,87,0,0]
[0,0,0,null,0,null,null,0,false,88,0,0]
[0,0,0,null,0,null,null,0,false,89,0,0]
[0,0,0,null,0,null,null,0,false,90,0,0]
[0,0,0,null,0,null,null,0,false,91,0,0]
[0,0,0,null,0,null,null,0,false,92,0,0]
[0,0,0,null,0,null,null,0,false,93,0,0]
[0,0,0,null,0,null,null,0,false,94,0,0]
[93,0,51,"2 (LL)",0,"B",null,95,true,95,2,93]
[94,0,51,"2 (LL)",0,"B",null,96,false,96,2,94]
[0,0,51,"2 (LL)",0,"C",null,95,false,2,0,93]
[0,0,51,"2 (LL)",0,"C",null,96,true,98,0,94]

{"sheet":"Breaker Panel Template","index":10,"n_rows":3,"n_cols":8,"rows_kept":3,"hidden":true,"merged":[[0,1,0,3],[0,4,0,5],[0,6,0,7]]}
["Breaker Panel Template: ","Circuit",null,null,"Circuit Breaker",null,"CT"]
[null,"Position","Phase","Name","Poles","Amps","Number","Amps"]
[null,1]

{"sheet":"Branch Circuits Temp","index":11,"n_rows":26,"n_cols":13,"rows_kept":26,"hidden":true,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,7,0,8],[0,9,0,10],[0,11,0,12]]}
["Circuit",null,"Circuit Breaker",null,"BCM CT",null,null,"Circuit",null,"Circuit Breaker",null,"BCM CT"]
["Position","Name","Poles","Rating","Number","Rating",null,"Position","Name","Poles","Rating","Number","Rating"]
[1,{"$nulls":6},25]
[2,{"$nulls":6},26]
[3,{"$nulls":6},27]
[4,{"$nulls":6},28]
[5,{"$nulls":6},29]
[6,{"$nulls":6},30]
[7,{"$nulls":6},31]
[8,{"$nulls":6},32]
[9,{"$nulls":6},33]
[10,{"$nulls":6},34]
[11,{"$nulls":6},35]
[12,{"$nulls":6},36]
[13,{"$nulls":6},37]
[14,{"$nulls":6},38]
[15,{"$nulls":6},39]
[16,{"$nulls":6},40]
[17,{"$nulls":6},41]
[18,{"$nulls":6},42]
[19,{"$nulls":6},43]
[20,{"$nulls":6},44]
[21,{"$nulls":6},45]
[22,{"$nulls":6},46]
[23,{"$nulls":6},47]
[24,{"$nulls":6},48]

{"sheet":"Configure Meter","index":12,"n_rows":4,"n_cols":3,"rows_kept":4,"merged":[[0,0,0,3]]}
["Configure Meter: "]
[]
[null,"username","password"]
[null,"admin","raritan"]