{"text_format":"1","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":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":119,"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":"Panel Identification","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"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,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,14,2,15],[2,1,2,3],[2,4,2,5],[2,6,2,7],[2,9,2,11],[2,12,2,13]]}
["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",null,null,null,null,null,null,2,"A"]
[null,3,"B",null,null,null,null,null,null,4,"B"]
[null,5,"C",null,null,null,null,null,null,6,"C"]
[null,7,"A",null,null,null,null,null,null,8,"A"]
[null,9,"B",null,null,null,null,null,null,10,"B"]
[null,11,"C",null,null,null,null,null,null,12,"C"]
[null,13,"A",null,null,null,null,null,null,14,"A"]
[null,15,"B",null,null,null,null,null,null,16,"B"]
[null,17,"C",null,null,null,null,null,null,18,"C"]
[null,19,"A",null,null,null,null,null,null,20,"A"]
[null,21,"B",null,null,null,null,null,null,22,"B"]
[null,23,"C",null,null,null,null,null,null,24,"C"]
[null,25,"A",null,null,null,null,null,null,26,"A"]
[null,27,"B",null,null,null,null,null,null,28,"B"]
[null,29,"C",null,null,null,null,null,null,30,"C"]
[null,31,"A",null,null,null,null,null,null,32,"A"]
[null,33,"B",null,null,null,null,null,null,34,"B"]
[null,35,"C",null,null,null,null,null,null,36,"C"]
[null,37,"A",null,null,null,null,null,null,38,"A"]
[null,39,"B",null,null,null,null,null,null,40,"B"]
[null,41,"C",null,null,null,null,null,null,42,"C"]

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

{"sheet":"Description","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Raritan PMC Deployment Utility"]

{"sheet":"Hidden","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["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"]
[null,null,null,null,null,null,"Upper Critical %",0,2,null,"Upper Critical %",0,2,null,"Upper Critical %",0,2]
[1,1,"1 (LN)",null,"single-phase",null,"Upper Warning %",0,2,null,"Upper Warning %",0,2,null,"Upper Warning %",0,2]
["2 (LL)",null,"2 (LL)",null,"split-phase",null,"Lower Warning %",0,2,null,"Lower Warning %",0,2,null,"Lower Warning %",0,2]
["2 (LLN)",null,"2 (LLN)",null,"3-phase",null,"Lower Critical %",0,2,null,"Lower Critical %",0,2,null,"Lower Critical %",0,2]
[3,null,null,null,null,null,"Assert Time",0,100,null,"Assert Time",0,100,null,"Assert Time",0,100]
[null,null,null,null,null,null,"Hysteresis",0,500,null,"Hysteresis",0,2000,null,"Hysteresis",0,2000]
["# Columns","Panel Layout","Phase Assignments (3-Phase)","Phase Assignments (Split-Phase)","Phase Assignments (Single-Phase)"]
[null,null,null,null,null,null,null,null,null,null,"Mains Neutral Current Alarm","Min","Max"]
[1,"Odd/Even","A","A","A",null,null,null,null,null,"Upper Critical %",0,2]
[2,"Sequential","B","B",null,null,null,null,null,null,"Upper Warning %",0,2]
[null,null,"C",null,null,null,null,null,null,null,"Lower Warning %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Lower Critical %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Assert Time",0,100]
[null,null,null,null,null,null,null,null,null,null,"Hysteresis",0,2000]
[]
[null,null,null,null,null,null,null,null,null,null,"Mains PE Current Alarm","Min","Max"]
[null,null,null,null,null,null,null,null,null,null,"Upper Critical %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Upper Warning %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Lower Warning %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Lower Critical %",0,2]
[null,null,null,null,null,null,null,null,null,null,"Assert Time",0,100]
[null,null,null,null,null,null,null,null,null,null,"Hysteresis",0,2000]

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

{"sheet":"VHistory","index":7,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["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,"cut":false,"hidden":true,"merged":[]}
[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,"cut":false,"hidden":true,"merged":[]}
[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,"cut":false,"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,"cut":false,"hidden":true,"merged":[[0,11,0,12],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,7,0,8],[0,9,0,10]]}
["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,null,null,null,null,null,null,25]
[2,null,null,null,null,null,null,26]
[3,null,null,null,null,null,null,27]
[4,null,null,null,null,null,null,28]
[5,null,null,null,null,null,null,29]
[6,null,null,null,null,null,null,30]
[7,null,null,null,null,null,null,31]
[8,null,null,null,null,null,null,32]
[9,null,null,null,null,null,null,33]
[10,null,null,null,null,null,null,34]
[11,null,null,null,null,null,null,35]
[12,null,null,null,null,null,null,36]
[13,null,null,null,null,null,null,37]
[14,null,null,null,null,null,null,38]
[15,null,null,null,null,null,null,39]
[16,null,null,null,null,null,null,40]
[17,null,null,null,null,null,null,41]
[18,null,null,null,null,null,null,42]
[19,null,null,null,null,null,null,43]
[20,null,null,null,null,null,null,44]
[21,null,null,null,null,null,null,45]
[22,null,null,null,null,null,null,46]
[23,null,null,null,null,null,null,47]
[24,null,null,null,null,null,null,48]

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