{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["계산작업","기타작업-3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"계산작업","index":0,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,14,20,14],[19,10,19,11]]}
[]
[null,"[표1]"]
[null,"가입나이","코드","구분-성별","가입금액","가입기간","미납기간","가입상태",null,null,"[표2]"]
[null,24,"BM",{"$f":"CONCATENATE(VLOOKUP(C4,$K$5:$M$8,2,FALSE),\"-\",VLOOKUP(C4,$K$5:$M$8,3,FALSE))","v":"기본형-남자"},{"$f":"INDEX($L$13:$S$16,MATCH(C4,$K$13:$K$16,0),MATCH(B4,$L$11:$S$11,1))","v":13200},5,3,{"$f":"fn가입상태(F4,G4)","v":"휴면보험"},null,null,"코드","구분","성별"]
[null,41,"BW",{"$f":"CONCATENATE(VLOOKUP(C5,$K$5:$M$8,2,FALSE),\"-\",VLOOKUP(C5,$K$5:$M$8,3,FALSE))","v":"기본형-여자"},{"$f":"INDEX($L$13:$S$16,MATCH(C5,$K$13:$K$16,0),MATCH(B5,$L$11:$S$11,1))","v":22500},3,0,{"$f":"fn가입상태(F5,G5)","v":"정상"},null,null,"BM","기본형","남자"]
[null,50,"SM","추가보장-남자",45000,15,0,"정상",null,null,"SM","추가보장","남자"]
[null,29,"SW","추가보장-여자",14200,15,0,"정상",null,null,"BW","기본형","여자"]
[null,42,"SW","추가보장-여자",28400,5,1,"1개월 미납",null,null,"SW","추가보장","여자"]
[null,7,"SW","추가보장-여자",13000,10,0,"정상"]
[null,45,"SM","추가보장-남자",24000,14,1,"1개월 미납",null,null,"[표3] 코드별 가입나이별 가입금액"]
[null,16,"SW","추가보장-여자",12900,5,1,"1개월 미납",null,null,null,0,10,20,30,40,50,60,70]
[null,16,"BM","기본형-남자",12800,6,1,"1개월 미납",null,null,null,10,20,30,40,50,60,70]
[null,51,"BM","기본형-남자",33000,8,0,"정상",null,null,"BM",12800,12800,13200,14800,19800,33000,58300,89500]
[null,46,"BM","기본형-남자",19800,8,2,"2개월 미납",null,null,"SM",13100,13100,13700,16100,24000,45000,85500,134800]
[null,22,"BM","기본형-남자",13200,21,0,"정상",null,null,"BW",12700,12600,13500,16700,22500,26500,32200,43100]
[null,6,"BM","기본형-남자",12800,7,0,"정상",null,null,"SW",13000,12900,14200,19100,28400,34900,43900,60700]
[null,22,"BW","기본형-여자",13500,21,2,"2개월 미납"]
[null,21,"SM","추가보장-남자",13700,20,0,"정상"]
[null,13,"SW","추가보장-여자",12900,8,0,"정상",null,null,"[표4] 나이대별 가입자수",null,null,null,"[표5] 코드별 나이별 평균 가입기간"]
[null,29,"BM","기본형-남자",13200,24,0,"정상",null,null,"나이",null,"가입자수",null,"코드",0,20,30,40,60]
[null,61,"BW","기본형-여자",32200,23,1,"1개월 미납",null,null,1,10,{"$f":"TEXT(FREQUENCY($B$4:$B$39,$L$21:$L$27),\"[>0]00명;미가입\")","v":"03명"},null,null,20,30,40,60,80]
[null,12,"BW","기본형-여자",12600,20,2,"2개월 미납",null,null,11,20,"06명",null,"BM",{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O22)*($B$4:$B$39>=P$20)*($B$4:$B$39<P$21),$F$4:$F$39)),\"\")","v":7.333333333333333},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O22)*($B$4:$B$39>=Q$20)*($B$4:$B$39<Q$21),$F$4:$F$39)),\"\")","v":16.75},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O22)*($B$4:$B$39>=R$20)*($B$4:$B$39<R$21),$F$4:$F$39)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O22)*($B$4:$B$39>=S$20)*($B$4:$B$39<S$21),$F$4:$F$39)),\"\")","v":8},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O22)*($B$4:$B$39>=T$20)*($B$4:$B$39<T$21),$F$4:$F$39)),\"\")","v":""}]
[null,64,"SW","추가보장-여자",43900,7,0,"정상",null,null,21,30,"12명",null,"BW",{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O23)*($B$4:$B$39>=P$20)*($B$4:$B$39<P$21),$F$4:$F$39)),\"\")","v":20.5},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O23)*($B$4:$B$39>=Q$20)*($B$4:$B$39<Q$21),$F$4:$F$39)),\"\")","v":21},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O23)*($B$4:$B$39>=R$20)*($B$4:$B$39<R$21),$F$4:$F$39)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O23)*($B$4:$B$39>=S$20)*($B$4:$B$39<S$21),$F$4:$F$39)),\"\")","v":5},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O23)*($B$4:$B$39>=T$20)*($B$4:$B$39<T$21),$F$4:$F$39)),\"\")","v":23}]
[null,29,"BM","기본형-남자",13200,17,2,"2개월 미납",null,null,31,40,"미가입",null,"SM",{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O24)*($B$4:$B$39>=P$20)*($B$4:$B$39<P$21),$F$4:$F$39)),\"\")","v":9},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O24)*($B$4:$B$39>=Q$20)*($B$4:$B$39<Q$21),$F$4:$F$39)),\"\")","v":8.6666666666666661},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O24)*($B$4:$B$39>=R$20)*($B$4:$B$39<R$21),$F$4:$F$39)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O24)*($B$4:$B$39>=S$20)*($B$4:$B$39<S$21),$F$4:$F$39)),\"\")","v":13},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O24)*($B$4:$B$39>=T$20)*($B$4:$B$39<T$21),$F$4:$F$39)),\"\")","v":""}]
[null,17,"BW","기본형-여자",12600,21,2,"2개월 미납",null,null,41,50,"07명",null,"SW",{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O25)*($B$4:$B$39>=P$20)*($B$4:$B$39<P$21),$F$4:$F$39)),\"\")","v":7.666666666666667},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O25)*($B$4:$B$39>=Q$20)*($B$4:$B$39<Q$21),$F$4:$F$39)),\"\")","v":16.5},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O25)*($B$4:$B$39>=R$20)*($B$4:$B$39<R$21),$F$4:$F$39)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O25)*($B$4:$B$39>=S$20)*($B$4:$B$39<S$21),$F$4:$F$39)),\"\")","v":12.333333333333334},{"$f":"IFERROR(AVERAGE(IF(($C$4:$C$39=$O25)*($B$4:$B$39>=T$20)*($B$4:$B$39<T$21),$F$4:$F$39)),\"\")","v":13.5}]
[null,29,"SM","추가보장-남자",13700,2,2,"해지예상",null,null,51,60,"05명"]
[null,26,"SM","추가보장-남자",13700,4,1,"1개월 미납",null,null,61,70,"03명"]
[null,59,"SM","추가보장-남자",45000,2,1,"1개월 미납"]
[null,43,"BW","기본형-여자",22500,5,2,"2개월 미납"]
[null,53,"SM","추가보장-남자",45000,21,2,"2개월 미납"]
[null,29,"SW","추가보장-여자",14200,18,1,"1개월 미납"]
[null,18,"BM","기본형-남자",12800,9,1,"1개월 미납"]
[null,41,"BW","기본형-여자",22500,7,0,"정상"]
[null,8,"SM","추가보장-남자",13100,9,2,"2개월 미납"]
[null,64,"SW","추가보장-여자",43900,20,1,"1개월 미납"]
[null,21,"SW","추가보장-여자",14200,12,2,"2개월 미납"]
[null,25,"SW","추가보장-여자",14200,21,0,"정상"]
[null,53,"SW","추가보장-여자",34900,23,0,"정상"]
[null,59,"SW","추가보장-여자",34900,9,1,"1개월 미납"]

{"sheet":"기타작업-3","index":1,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"[표1]",null,null,null,null,null,null,null,null,null,null,"[표2]"]
[null,"구분","아동명","보호자동반","기본요금","입장시간","퇴장시간","요금",null,null,null,null,"구분","기본요금"]
[null,"유치","한새미","유",3000,"13:00:00","15:00:00",6000,null,null,null,null,"유아",0]
[null,"초등","이시환","무",4000,"15:40:00","17:30:00",8000,null,null,null,null,"유치",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,"초등",4000]