{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["시험기본정보","배정감독수정보","감독배정","감독표"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"시험기본정보","index":0,"n_rows":19,"n_cols":15,"rows_kept":19}
[null,0]
[]
[null,"new남궁고사 ver1"]
[]
[]
[]
[null,"1. 고사 날짜 및 교시",{"$nulls":4},"2. 고사실 정보",null,null,"3. 감독교사 정보",null,null,"4. 업무강도 (업무강도 높은 순 정렬)"]
[]
[null,"순번","날짜","시작교시","종료교시",null,"순번","고사실명",null,"순번","이름",null,"순번","보직","업무강도"]
[null,1,"2023-04-24",1,4,null,1,101,null,1,"남궁연",null,1,"정감독",100]
[null,2,"2023-04-25",1,4,null,2,102,null,2,"남궁호윤",null,2,"부감독",50]
[null,3,"2023-04-26",1,4,null,3,103,null,3,"남궁유",null,3,"자습감독",30]
[null,4,"2023-04-27",1,4,null,4,104,null,4,"노봉나",null,4,"복도감독",20]
[{"$nulls":6},5,201,null,5,"영민한"]
[{"$nulls":6},6,202,null,6,"산울림"]
[{"$nulls":6},7,203,null,7,"초록아빠"]
[{"$nulls":6},8,204,null,8,"혜성특급"]
[{"$nulls":6},9,"101-104복도",null,9,"최종병기학"]
[{"$nulls":6},10,"별관2층복도",null,10,"찐호박"]

{"sheet":"배정감독수정보","index":1,"n_rows":73,"n_cols":15,"rows_kept":73}
[null,0]
{"$rows_empty":7}
[null,1,"교시","보직",101,102,103,104,201,202,203,204,"101-104복도","별관2층복도","합계"]
[1,"2023-04-24",1,"정감독",1,1,1,1,{"$nulls":6},{"$f":"SUM($E10:$N10)","v":4}]
[1,"2023-04-24",1,"부감독",1,1,1,1,{"$nulls":6},{"$f":"SUM($E11:$N11)","v":4}]
[1,"2023-04-24",1,"자습감독",{"$nulls":10},{"$f":"SUM($E12:$N12)","v":0}]
[1,"2023-04-24",1,"복도감독",{"$nulls":8},1,1,{"$f":"SUM($E13:$N13)","v":2}]
[1,"2023-04-24",2,"정감독",{"$nulls":10},{"$f":"SUM($E14:$N14)","v":0}]
[1,"2023-04-24",2,"부감독",{"$nulls":10},{"$f":"SUM($E15:$N15)","v":0}]
[1,"2023-04-24",2,"자습감독",{"$nulls":4},1,1,1,1,null,null,{"$f":"SUM($E16:$N16)","v":4}]
[1,"2023-04-24",2,"복도감독",{"$nulls":10},{"$f":"SUM($E17:$N17)","v":0}]
[1,"2023-04-24",3,"정감독",{"$nulls":10},{"$f":"SUM($E18:$N18)","v":0}]
[1,"2023-04-24",3,"부감독",{"$nulls":10},{"$f":"SUM($E19:$N19)","v":0}]
[1,"2023-04-24",3,"자습감독",{"$nulls":10},{"$f":"SUM($E20:$N20)","v":0}]
[1,"2023-04-24",3,"복도감독",{"$nulls":10},{"$f":"SUM($E21:$N21)","v":0}]
[1,"2023-04-24",4,"정감독",{"$nulls":10},{"$f":"SUM($E22:$N22)","v":0}]
[1,"2023-04-24",4,"부감독",{"$nulls":10},{"$f":"SUM($E23:$N23)","v":0}]
[1,"2023-04-24",4,"자습감독",{"$nulls":10},{"$f":"SUM($E24:$N24)","v":0}]
[1,"2023-04-24",4,"복도감독",{"$nulls":10},{"$f":"SUM($E25:$N25)","v":0}]
[2,"2023-04-25",1,"정감독",{"$nulls":10},{"$f":"SUM($E26:$N26)","v":0}]
[2,"2023-04-25",1,"부감독",{"$nulls":10},{"$f":"SUM($E27:$N27)","v":0}]
[2,"2023-04-25",1,"자습감독",{"$nulls":10},{"$f":"SUM($E28:$N28)","v":0}]
[2,"2023-04-25",1,"복도감독",{"$nulls":10},{"$f":"SUM($E29:$N29)","v":0}]
[2,"2023-04-25",2,"정감독",{"$nulls":10},{"$f":"SUM($E30:$N30)","v":0}]
[2,"2023-04-25",2,"부감독",{"$nulls":10},{"$f":"SUM($E31:$N31)","v":0}]
[2,"2023-04-25",2,"자습감독",{"$nulls":10},{"$f":"SUM($E32:$N32)","v":0}]
[2,"2023-04-25",2,"복도감독",{"$nulls":10},{"$f":"SUM($E33:$N33)","v":0}]
[2,"2023-04-25",3,"정감독",{"$nulls":10},{"$f":"SUM($E34:$N34)","v":0}]
[2,"2023-04-25",3,"부감독",{"$nulls":10},{"$f":"SUM($E35:$N35)","v":0}]
[2,"2023-04-25",3,"자습감독",{"$nulls":10},{"$f":"SUM($E36:$N36)","v":0}]
[2,"2023-04-25",3,"복도감독",{"$nulls":10},{"$f":"SUM($E37:$N37)","v":0}]
[2,"2023-04-25",4,"정감독",{"$nulls":10},{"$f":"SUM($E38:$N38)","v":0}]
[2,"2023-04-25",4,"부감독",{"$nulls":10},{"$f":"SUM($E39:$N39)","v":0}]
[2,"2023-04-25",4,"자습감독",{"$nulls":10},{"$f":"SUM($E40:$N40)","v":0}]
[2,"2023-04-25",4,"복도감독",{"$nulls":10},{"$f":"SUM($E41:$N41)","v":0}]
[3,"2023-04-26",1,"정감독",{"$nulls":10},{"$f":"SUM($E42:$N42)","v":0}]
[3,"2023-04-26",1,"부감독",{"$nulls":10},{"$f":"SUM($E43:$N43)","v":0}]
[3,"2023-04-26",1,"자습감독",{"$nulls":10},{"$f":"SUM($E44:$N44)","v":0}]
[3,"2023-04-26",1,"복도감독",{"$nulls":10},{"$f":"SUM($E45:$N45)","v":0}]
[3,"2023-04-26",2,"정감독",{"$nulls":10},{"$f":"SUM($E46:$N46)","v":0}]
[3,"2023-04-26",2,"부감독",{"$nulls":10},{"$f":"SUM($E47:$N47)","v":0}]
[3,"2023-04-26",2,"자습감독",{"$nulls":10},{"$f":"SUM($E48:$N48)","v":0}]
[3,"2023-04-26",2,"복도감독",{"$nulls":10},{"$f":"SUM($E49:$N49)","v":0}]
[3,"2023-04-26",3,"정감독",{"$nulls":10},{"$f":"SUM($E50:$N50)","v":0}]
[3,"2023-04-26",3,"부감독",{"$nulls":10},{"$f":"SUM($E51:$N51)","v":0}]
[3,"2023-04-26",3,"자습감독",{"$nulls":10},{"$f":"SUM($E52:$N52)","v":0}]
[3,"2023-04-26",3,"복도감독",{"$nulls":10},{"$f":"SUM($E53:$N53)","v":0}]
[3,"2023-04-26",4,"정감독",{"$nulls":10},{"$f":"SUM($E54:$N54)","v":0}]
[3,"2023-04-26",4,"부감독",{"$nulls":10},{"$f":"SUM($E55:$N55)","v":0}]
[3,"2023-04-26",4,"자습감독",{"$nulls":10},{"$f":"SUM($E56:$N56)","v":0}]
[3,"2023-04-26",4,"복도감독",{"$nulls":10},{"$f":"SUM($E57:$N57)","v":0}]
[4,"2023-04-27",1,"정감독",{"$nulls":10},{"$f":"SUM($E58:$N58)","v":0}]
[4,"2023-04-27",1,"부감독",{"$nulls":10},{"$f":"SUM($E59:$N59)","v":0}]
[4,"2023-04-27",1,"자습감독",{"$nulls":10},{"$f":"SUM($E60:$N60)","v":0}]
[4,"2023-04-27",1,"복도감독",{"$nulls":10},{"$f":"SUM($E61:$N61)","v":0}]
[4,"2023-04-27",2,"정감독",{"$nulls":10},{"$f":"SUM($E62:$N62)","v":0}]
[4,"2023-04-27",2,"부감독",{"$nulls":10},{"$f":"SUM($E63:$N63)","v":0}]
[4,"2023-04-27",2,"자습감독",{"$nulls":10},{"$f":"SUM($E64:$N64)","v":0}]
[4,"2023-04-27",2,"복도감독",{"$nulls":10},{"$f":"SUM($E65:$N65)","v":0}]
[4,"2023-04-27",3,"정감독",{"$nulls":10},{"$f":"SUM($E66:$N66)","v":0}]
[4,"2023-04-27",3,"부감독",{"$nulls":10},{"$f":"SUM($E67:$N67)","v":0}]
[4,"2023-04-27",3,"자습감독",{"$nulls":10},{"$f":"SUM($E68:$N68)","v":0}]
[4,"2023-04-27",3,"복도감독",{"$nulls":10},{"$f":"SUM($E69:$N69)","v":0}]
[4,"2023-04-27",4,"정감독",{"$nulls":10},{"$f":"SUM($E70:$N70)","v":0}]
[4,"2023-04-27",4,"부감독",{"$nulls":10},{"$f":"SUM($E71:$N71)","v":0}]
[4,"2023-04-27",4,"자습감독",{"$nulls":10},{"$f":"SUM($E72:$N72)","v":0}]
[4,"2023-04-27",4,"복도감독",{"$nulls":10},{"$f":"SUM($E73:$N73)","v":0}]

{"sheet":"감독배정","index":2,"n_rows":21,"n_cols":29,"rows_kept":21}
[null,0]
[]
[]
[{"$nulls":5},1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4]
[{"$nulls":5},"2023-04-24","2023-04-24","2023-04-24","2023-04-24","2023-04-25","2023-04-25","2023-04-25","2023-04-25","2023-04-26","2023-04-26","2023-04-26","2023-04-26","2023-04-27","2023-04-27","2023-04-27","2023-04-27",{"$nulls":4},"보직별 감독수"]
[null,"순번","이름","배정할\n시간","못들어가는\n고사실",1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"최대가능시간","P값","총감독\n시간","업무강도","정감독","부감독","자습감독","복도감독"]
[null,1,"남궁연",null,null,"101-104복도[4]","201[3]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"16-COUNTIF($F7:$U7,\"x\")","v":16},{"$f":"IFERROR(($D7-SUM($F7:$U7))/(16-COUNTA($F7:$U7)),-100)","v":-100},2,50,0,0,1,1]
[null,2,"남궁호윤",null,null,"별관2층복도[4]","203[3]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,-100,2,50,0,0,1,1]
[null,3,"남궁유",null,null,"102[1]","x",0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,-100,1,100,1,0,0,0]
[null,4,"노봉나",null,null,"103[1]","x",0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,-100,1,100,1,0,0,0]
[null,5,"영민한",null,null,"101[2]","202[3]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,-100,2,80,0,1,1,0]
[null,6,"산울림",null,null,"103[2]","204[3]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,-100,2,80,0,1,1,0]
[null,7,"초록아빠",null,null,"102[2]","x",0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,-100,1,50,0,1,0,0]
[null,8,"혜성특급",null,null,"104[2]","x",0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,-100,1,50,0,1,0,0]
[null,9,"최종병기학",null,null,"104[1]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,-100,1,100,1,0,0,0]
[null,10,"찐호박",null,null,"101[1]",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,-100,1,100,1,0,0,0]
[]
[null,null,"배정할시간합",{"$f":"SUM($D$7:$D$16)","v":0},"가능한교사수",{"$f":"10-COUNTIF(F$7:F$16,\"x\")","v":10},{"$f":"10-COUNTIF(G$7:G$16,\"x\")","v":6},{"$f":"10-COUNTIF(H$7:H$16,\"x\")","v":10},{"$f":"10-COUNTIF(I$7:I$16,\"x\")","v":10},{"$f":"10-COUNTIF(J$7:J$16,\"x\")","v":10},{"$f":"10-COUNTIF(K$7:K$16,\"x\")","v":10},{"$f":"10-COUNTIF(L$7:L$16,\"x\")","v":10},{"$f":"10-COUNTIF(M$7:M$16,\"x\")","v":10},{"$f":"10-COUNTIF(N$7:N$16,\"x\")","v":10},{"$f":"10-COUNTIF(O$7:O$16,\"x\")","v":10},{"$f":"10-COUNTIF(P$7:P$16,\"x\")","v":10},{"$f":"10-COUNTIF(Q$7:Q$16,\"x\")","v":10},{"$f":"10-COUNTIF(R$7:R$16,\"x\")","v":10},{"$f":"10-COUNTIF(S$7:S$16,\"x\")","v":10},{"$f":"10-COUNTIF(T$7:T$16,\"x\")","v":10},{"$f":"10-COUNTIF(U$7:U$16,\"x\")","v":10}]
[null,null,"총필요시간합",{"$f":"SUM($F19:$U19)","v":14},"일별필요시간",10,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"P값",{"$f":"IFERROR((F$19-SUM(F$7:F$16))/(10-COUNTA(F$7:F$16)),-100)","v":-100},{"$f":"IFERROR((G$19-SUM(G$7:G$16))/(10-COUNTA(G$7:G$16)),-100)","v":-100},{"$f":"IFERROR((H$19-SUM(H$7:H$16))/(10-COUNTA(H$7:H$16)),-100)","v":-100},{"$f":"IFERROR((I$19-SUM(I$7:I$16))/(10-COUNTA(I$7:I$16)),-100)","v":-100},{"$f":"IFERROR((J$19-SUM(J$7:J$16))/(10-COUNTA(J$7:J$16)),-100)","v":-100},{"$f":"IFERROR((K$19-SUM(K$7:K$16))/(10-COUNTA(K$7:K$16)),-100)","v":-100},{"$f":"IFERROR((L$19-SUM(L$7:L$16))/(10-COUNTA(L$7:L$16)),-100)","v":-100},{"$f":"IFERROR((M$19-SUM(M$7:M$16))/(10-COUNTA(M$7:M$16)),-100)","v":-100},{"$f":"IFERROR((N$19-SUM(N$7:N$16))/(10-COUNTA(N$7:N$16)),-100)","v":-100},{"$f":"IFERROR((O$19-SUM(O$7:O$16))/(10-COUNTA(O$7:O$16)),-100)","v":-100},{"$f":"IFERROR((P$19-SUM(P$7:P$16))/(10-COUNTA(P$7:P$16)),-100)","v":-100},{"$f":"IFERROR((Q$19-SUM(Q$7:Q$16))/(10-COUNTA(Q$7:Q$16)),-100)","v":-100},{"$f":"IFERROR((R$19-SUM(R$7:R$16))/(10-COUNTA(R$7:R$16)),-100)","v":-100},{"$f":"IFERROR((S$19-SUM(S$7:S$16))/(10-COUNTA(S$7:S$16)),-100)","v":-100},{"$f":"IFERROR((T$19-SUM(T$7:T$16))/(10-COUNTA(T$7:T$16)),-100)","v":-100},{"$f":"IFERROR((U$19-SUM(U$7:U$16))/(10-COUNTA(U$7:U$16)),-100)","v":-100}]
[{"$nulls":4},"배정된감독수",{"$f":"SUM(F$7:F$16)","v":0},{"$f":"SUM(G$7:G$16)","v":0},{"$f":"SUM(H$7:H$16)","v":0},{"$f":"SUM(I$7:I$16)","v":0},{"$f":"SUM(J$7:J$16)","v":0},{"$f":"SUM(K$7:K$16)","v":0},{"$f":"SUM(L$7:L$16)","v":0},{"$f":"SUM(M$7:M$16)","v":0},{"$f":"SUM(N$7:N$16)","v":0},{"$f":"SUM(O$7:O$16)","v":0},{"$f":"SUM(P$7:P$16)","v":0},{"$f":"SUM(Q$7:Q$16)","v":0},{"$f":"SUM(R$7:R$16)","v":0},{"$f":"SUM(S$7:S$16)","v":0},{"$f":"SUM(T$7:T$16)","v":0},{"$f":"SUM(U$7:U$16)","v":0}]

{"sheet":"감독표","index":3,"n_rows":73,"n_cols":15,"rows_kept":73,"merged":[[5,2,5,3]]}
[]
[]
[]
[]
[]
[null,"성함","초록아빠"]
[]
[]
[null,"날짜","교시","보직",101,102,103,104,201,202,203,204,"101-104복도","별관2층복도","합계"]
[1,"2023-04-24",1,"정감독","찐호박","남궁유","노봉나","최종병기학"]
[1,"2023-04-24",1,"부감독","영민한","초록아빠","산울림","혜성특급"]
[1,"2023-04-24",1,"자습감독"]
[1,"2023-04-24",1,"복도감독",{"$nulls":8},"남궁연","남궁호윤"]
[1,"2023-04-24",2,"정감독"]
[1,"2023-04-24",2,"부감독"]
[1,"2023-04-24",2,"자습감독",{"$nulls":4},"남궁연","영민한","남궁호윤","산울림"]
[1,"2023-04-24",2,"복도감독"]
[1,"2023-04-24",3,"정감독"]
[1,"2023-04-24",3,"부감독"]
[1,"2023-04-24",3,"자습감독"]
[1,"2023-04-24",3,"복도감독"]
[1,"2023-04-24",4,"정감독"]
[1,"2023-04-24",4,"부감독"]
[1,"2023-04-24",4,"자습감독"]
[1,"2023-04-24",4,"복도감독"]
[2,"2023-04-25",1,"정감독"]
[2,"2023-04-25",1,"부감독"]
[2,"2023-04-25",1,"자습감독"]
[2,"2023-04-25",1,"복도감독"]
[2,"2023-04-25",2,"정감독"]
[2,"2023-04-25",2,"부감독"]
[2,"2023-04-25",2,"자습감독"]
[2,"2023-04-25",2,"복도감독"]
[2,"2023-04-25",3,"정감독"]
[2,"2023-04-25",3,"부감독"]
[2,"2023-04-25",3,"자습감독"]
[2,"2023-04-25",3,"복도감독"]
[2,"2023-04-25",4,"정감독"]
[2,"2023-04-25",4,"부감독"]
[2,"2023-04-25",4,"자습감독"]
[2,"2023-04-25",4,"복도감독"]
[3,"2023-04-26",1,"정감독"]
[3,"2023-04-26",1,"부감독"]
[3,"2023-04-26",1,"자습감독"]
[3,"2023-04-26",1,"복도감독"]
[3,"2023-04-26",2,"정감독"]
[3,"2023-04-26",2,"부감독"]
[3,"2023-04-26",2,"자습감독"]
[3,"2023-04-26",2,"복도감독"]
[3,"2023-04-26",3,"정감독"]
[3,"2023-04-26",3,"부감독"]
[3,"2023-04-26",3,"자습감독"]
[3,"2023-04-26",3,"복도감독"]
[3,"2023-04-26",4,"정감독"]
[3,"2023-04-26",4,"부감독"]
[3,"2023-04-26",4,"자습감독"]
[3,"2023-04-26",4,"복도감독"]
[4,"2023-04-27",1,"정감독"]
[4,"2023-04-27",1,"부감독"]
[4,"2023-04-27",1,"자습감독"]
[4,"2023-04-27",1,"복도감독"]
[4,"2023-04-27",2,"정감독"]
[4,"2023-04-27",2,"부감독"]
[4,"2023-04-27",2,"자습감독"]
[4,"2023-04-27",2,"복도감독"]
[4,"2023-04-27",3,"정감독"]
[4,"2023-04-27",3,"부감독"]
[4,"2023-04-27",3,"자습감독"]
[4,"2023-04-27",3,"복도감독"]
[4,"2023-04-27",4,"정감독"]
[4,"2023-04-27",4,"부감독"]
[4,"2023-04-27",4,"자습감독"]
[4,"2023-04-27",4,"복도감독"]