{"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":112,"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: My 96-Circuit 1-Column 3-Phase Panel"]
[]
[null,"Panel Name",""]
[null,"Meter ID","","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","","Nominal panel line-line voltage.  (Establishes alarm thresholds)\n  Example: nominal voltage (400V),  threshold (90%):  alarm occurs at 360V"]
[null,"Rated Amps","","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","","Amp rating of CTs measuring panel mains breaker."]
[null,"Neutral CT Amps","","Amp rating of CT meausring neutral current ( Enter 0 if no neutral CT)"]
[null,"Earth CT Amps","","Amp rating of CT measuring ground current ( Enter 0 if no earth CT)"]
[null,"MODBUS Address","","Power meter's MODBUS address.  (Enter 0 if MODBUS not used)"]

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

{"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: My 96-Circuit 1-Column 3-Phase Panel"]
[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"]
[null,null,null,null,null,null,null,null,null,null,"Mains Neutral Current Alarm","Min","Max"]
[1,"Odd/Even",null,null,null,null,null,null,null,null,"Upper Critical %",0,2]
[2,"Sequential",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]
[]
[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":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,1,null,null,null,null,null,null,2]
[null,3,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,8]
[null,9,null,null,null,null,null,null,10]
[null,11,null,null,null,null,null,null,12]
[null,13,null,null,null,null,null,null,14]
[null,15,null,null,null,null,null,null,16]
[null,17,null,null,null,null,null,null,18]
[null,19,null,null,null,null,null,null,20]
[null,21,null,null,null,null,null,null,22]
[null,23,null,null,null,null,null,null,24]
[null,25,null,null,null,null,null,null,26]
[null,27,null,null,null,null,null,null,28]
[null,29,null,null,null,null,null,null,30]
[null,31,null,null,null,null,null,null,32]
[null,33,null,null,null,null,null,null,34]
[null,35,null,null,null,null,null,null,36]
[null,37,null,null,null,null,null,null,38]
[null,39,null,null,null,null,null,null,40]
[null,41,null,null,null,null,null,null,42]

{"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":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
[1,"C1",3,15,1,60]
[3,null,null,null,3]
[5,null,null,null,5]
[7,"C2",3,16,7,61]
[9,null,null,null,9]
[11,null,null,null,11]
[13,"C3",3,17,13,62]
[15,null,null,null,15]
[17,null,null,null,17]
[19,"C4",3,18,19,63]
[21,null,null,null,21]
[23,null,null,null,23]
[25,"C5",3,19,25,64]
[27,null,null,null,27]
[29,null,null,null,29]
[31,"C6",3,20,31,65]
[33,null,null,null,33]
[35,null,null,null,35]
[37,"C7",3,21,37,66]
[39,null,null,null,39]
[41,null,null,null,41]
[43,"C8",3,22,43,67]
[45,null,null,null,45]
[47,null,null,null,47]
[49,"C9",3,23,49,68]
[51,null,null,null,51]
[53,null,null,null,53]
[55,"C10",3,24,55,69]
[57,null,null,null,57]
[59,null,null,null,59]
[61,"C11",3,25,61,70]
[63,null,null,null,63]
[65,null,null,null,65]
[67,"C12",3,26,67,71]
[69,null,null,null,69]
[71,null,null,null,71]
[73,"C13",3,27,73,72]
[75,null,null,null,75]
[77,null,null,null,77]
[79,"C14",3,28,79,73]
[81,null,null,null,81]
[83,null,null,null,83]
[85,"C15",3,29,85,74]
[87,null,null,null,87]
[89,null,null,null,89]
[91,"C16",3,30,91,75]
[93,null,null,null,93]
[95,null,null,null,95]
[2,"C17",3,31,2,76]
[4,null,null,null,4]
[6,null,null,null,6]
[8,"C18",3,32,8,77]
[10,null,null,null,10]
[12,null,null,null,12]
[14,"C19",3,33,14,78]
[16,null,null,null,16]
[18,null,null,null,18]
[20,"C20",3,34,20,79]
[22,null,null,null,22]
[24,null,null,null,24]
[26,"C21",3,35,26,80]
[28,null,null,null,28]
[30,null,null,null,30]
[32,"C22",3,36,32,81]
[34,null,null,null,34]
[36,null,null,null,36]
[38,"C23",3,37,38,82]
[40,null,null,null,40]
[42,null,null,null,42]
[44,"C24",3,38,44,83]
[46,null,null,null,46]
[48,null,null,null,48]
[50,"C25",3,39,50,84]
[52,null,null,null,52]
[54,null,null,null,54]
[56,"C26",3,40,56,85]
[58,null,null,null,58]
[60,null,null,null,60]
[62,"C27",3,41,62,86]
[64,null,null,null,64]
[66,null,null,null,66]
[68,"C28",3,42,68,87]
[70,null,null,null,70]
[72,null,null,null,72]
[74,"C29",3,43,74,88]
[76,null,null,null,76]
[78,null,null,null,78]
[80,"C30",3,44,80,89]
[82,null,null,null,82]
[84,null,null,null,84]
[86,"C31",3,45,86,90]
[88,null,null,null,88]
[90,null,null,null,90]
[92,"C32",3,46,92,91]
[94,null,null,null,94]
[96,null,null,null,96]

{"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,0,false,3,0,0,0]
[2,0,0,null,0,null,0,false,4,0,0]
[3,0,0,null,0,null,0,false,5,0,0]
[4,0,0,null,0,null,0,false,6,0,0]
[5,0,0,null,0,null,0,false,7,0,0]
[6,0,0,null,0,null,0,false,8,0,0]
[7,0,0,null,0,null,0,false,9,0,0]
[8,0,0,null,0,null,0,false,10,0,0]
[9,0,0,null,0,null,0,false,11,0,0]
[10,0,0,null,0,null,0,false,12,0,0]
[11,0,0,null,0,null,0,false,13,0,0]
[12,0,0,null,0,null,0,false,14,0,0]
[13,0,0,null,0,null,0,false,15,0,0]
[14,0,0,null,0,null,0,false,16,0,0]
[15,0,0,null,0,null,0,false,17,0,0]
[16,0,0,null,0,null,0,false,18,0,0]
[17,0,0,null,0,null,0,false,19,0,0]
[18,0,0,null,0,null,0,false,20,0,0]
[19,0,0,null,0,null,0,false,21,0,0]
[20,0,0,null,0,null,0,false,22,0,0]
[21,0,0,null,0,null,0,false,23,0,0]
[22,0,0,null,0,null,0,false,24,0,0]
[23,0,0,null,0,null,0,false,25,0,0]
[24,0,0,null,0,null,0,false,26,0,0]
[25,0,0,null,0,null,0,false,27,0,0]
[26,0,0,null,0,null,0,false,28,0,0]
[27,0,0,null,0,null,0,false,29,0,0]
[28,0,0,null,0,null,0,false,30,0,0]
[29,0,0,null,0,null,0,false,31,0,0]
[30,0,0,null,0,null,0,false,32,0,0]
[31,0,0,null,0,null,0,false,33,0,0]
[32,0,0,null,0,null,0,false,34,0,0]
[33,0,0,null,0,null,0,false,35,0,0]
[34,0,0,null,0,null,0,false,36,0,0]
[35,0,0,null,0,null,0,false,37,0,0]
[36,0,0,null,0,null,0,false,38,0,0]
[37,0,0,null,0,null,0,false,39,0,0]
[38,0,0,null,0,null,0,false,40,0,0]
[39,0,0,null,0,null,0,false,41,0,0]
[40,0,0,null,0,null,0,false,42,0,0]
[41,0,0,null,0,null,0,false,2,0,0]
[42,0,0,null,0,null,0,false,44,0,0]
[43,67,26,3,22,"C8",47,false,45,3,43]
[44,83,74,3,38,"C24",48,false,46,3,44]
[0,0,26,3,0,null,47,false,47,0,43]
[0,0,74,3,0,null,48,false,48,0,44]
[0,0,26,3,0,null,47,false,49,0,43]
[0,0,74,3,0,null,48,false,50,0,44]
[49,68,29,3,23,"C9",53,false,51,3,49]
[50,84,77,3,39,"C25",54,false,52,3,50]
[0,0,29,3,0,null,53,false,53,0,49]
[0,0,77,3,0,null,54,false,54,0,50]
[0,0,29,3,0,null,53,false,55,0,49]
[0,0,77,3,0,null,54,false,56,0,50]
[55,69,32,3,24,"C10",59,false,57,3,55]
[56,85,80,3,40,"C26",60,false,58,3,56]
[0,0,32,3,0,null,59,false,59,0,55]
[0,0,80,3,0,null,60,false,60,0,56]
[0,0,32,3,0,null,59,false,61,0,55]
[0,0,80,3,0,null,60,false,62,0,56]
[61,70,35,3,25,"C11",65,false,63,3,61]
[62,86,83,3,41,"C27",66,false,64,3,62]
[0,0,35,3,0,null,65,false,65,0,61]
[0,0,83,3,0,null,66,false,66,0,62]
[0,0,35,3,0,null,65,false,67,0,61]
[0,0,83,3,0,null,66,false,68,0,62]
[67,71,38,3,26,"C12",71,false,69,3,67]
[68,87,86,3,42,"C28",72,false,70,3,68]
[0,0,38,3,0,null,71,false,71,0,67]
[0,0,86,3,0,null,72,false,72,0,68]
[0,0,38,3,0,null,71,false,73,0,67]
[0,0,86,3,0,null,72,false,74,0,68]
[73,72,41,3,27,"C13",77,false,75,3,73]
[74,88,89,3,43,"C29",78,false,76,3,74]
[0,0,41,3,0,null,77,false,77,0,73]
[0,0,89,3,0,null,78,false,78,0,74]
[0,0,41,3,0,null,77,false,79,0,73]
[0,0,89,3,0,null,78,false,80,0,74]
[79,73,44,3,28,"C14",83,false,81,3,79]
[80,89,92,3,44,"C30",84,false,82,3,80]
[0,0,44,3,0,null,83,false,83,0,79]
[0,0,92,3,0,null,84,false,84,0,80]
[0,0,44,3,0,null,83,false,85,0,79]
[0,0,92,3,0,null,84,false,86,0,80]
[85,74,47,3,29,"C15",89,false,87,3,85]
[86,90,95,3,45,"C31",90,false,88,3,86]
[0,0,47,3,0,null,89,false,89,0,85]
[0,0,95,3,0,null,90,false,90,0,86]
[0,0,47,3,0,null,89,false,91,0,85]
[0,0,95,3,0,null,90,false,92,0,86]
[91,75,50,3,30,"C16",95,false,93,3,91]
[92,91,98,3,46,"C32",96,false,94,3,92]
[0,0,50,3,0,null,95,false,95,0,91]
[0,0,98,3,0,null,96,false,96,0,92]
[0,0,50,3,0,null,95,false,2,0,91]
[0,0,98,3,0,null,96,false,98,0,92]

{"sheet":"Breaker Panel Template","index":10,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6]]}
[null,"Circuit",null,"Circuit Breaker",null,"CT"]
[null,"Position","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: My 96-Circuit 1-Column 3-Phase Panel"]
[]
[null,"username","password"]
[null,"",""]