{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["환불기준(겨울학기)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":71,"n_cols":18,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,0,4,0]]}
["구분",null,null,null,"청연 계절(3인실) 24박","청연 계절(1인실) 24박","청연 계절(장애인실) 24박","청연 장기A(3인실) 57박","청연 장기B(3인실) 64박","매지 장기C(3인실) 57박","매지 장기D(3인실) 64박",null,null,"계절입사","장기입사A","장기입사B","장기입사C","장기입사D"]
["23-겨울학기 ",null,null,"1박 단가",9890,{"$f":"E2*3","v":29670},12060,9890,9890,5190,5190,null,"입사일","2023-12-25","2023-12-22","2023-12-22","2023-12-22","2023-12-22"]
[null,null,null,"입사비",{"$f":"E2*N4","v":237360},{"$f":"F2*N4","v":712080},{"$f":"G2*N4","v":289440},{"$f":"H2*O4","v":563730},{"$f":"I2*P4","v":632960},{"$f":"J2*Q4","v":295830},{"$f":"K2*R4","v":332160},null,"퇴사일","2024-01-18","2024-02-17","2024-02-24","2024-02-17","2024-02-24"]
[null,null,null,"위약금",{"$f":"E3*0.2","v":47472},142416,57888,112746,{"$f":"I3*0.2","v":126592},59166,66432,null,"사용일(박)",{"$f":"N3-N2","v":24},{"$f":"O3-O2","v":57},{"$f":"P3-P2","v":64},{"$f":"Q3-Q2","v":57},{"$f":"R3-R2","v":64}]
[null,"계절","장기","위약금 (절상)",{"$f":"ROUNDDOWN(E4,-1)","v":47470},142410,57880,112740,126590,59160,66430]
["장기A/B/C/D입사일",null,1,"2023-12-22",null,null,null,{"$f":"H3-H5","v":450990},{"$f":"I3-I5","v":506370},{"$f":"J3-J5","v":236670},{"$f":"K3-K5","v":265730}]
[null,null,2,"2023-12-23",null,null,null,{"$f":"H6-$H$2","v":441100},{"$f":"I6-$I$2","v":496480},{"$f":"J6-$J$2","v":231480},{"$f":"K6-$K$2","v":260540}]
[null,null,3,"2023-12-24",null,null,null,{"$f":"H7-$H$2","v":431210},{"$f":"I7-$I$2","v":486590},{"$f":"J7-$J$2","v":226290},{"$f":"K7-$K$2","v":255350}]
["계절입사일",null,4,"2023-12-25",{"$f":"E3-E5","v":189890},{"$f":"F3-F5","v":569670},{"$f":"G3-G5","v":231560},421320,476700,221100,250160]
[null,1,5,"2023-12-26",{"$f":"E9-$E$2","v":180000},{"$f":"F9-$F$2","v":540000},{"$f":"G9-$G$2","v":219500},411430,466810,215910,244970]
[null,2,6,"2023-12-27",{"$f":"E10-$E$2","v":170110},{"$f":"F10-$F$2","v":510330},{"$f":"G10-$G$2","v":207440},401540,456920,210720,239780]
[null,3,7,"2023-12-28",{"$f":"E11-$E$2","v":160220},480660,195380,391650,447030,205530,234590]
[null,4,8,"2023-12-29",150330,450990,183320,381760,437140,200340,229400]
[null,5,9,"2023-12-30",140440,421320,171260,371870,427250,195150,224210]
[null,6,10,"2023-12-31",130550,391650,159200,361980,417360,189960,219020]
[null,7,11,"2024-01-01",120660,361980,147140,352090,407470,184770,213830]
[null,8,12,"2024-01-02",110770,332310,135080,342200,397580,179580,208640]
[null,9,13,"2024-01-03",100880,302640,123020,332310,387690,174390,203450]
[null,10,14,"2024-01-04",90990,272970,110960,322420,377800,169200,198260]
[null,11,15,"2024-01-05",81100,243300,98900,312530,367910,164010,193070]
[null,12,16,"2024-01-06",71210,213630,86840,302640,358020,158820,187880]
[null,13,17,"2024-01-07",61320,183960,74780,292750,348130,153630,182690]
[null,14,18,"2024-01-08",51430,154290,62720,282860,338240,148440,177500]
[null,15,19,"2024-01-09",41540,124620,50660,272970,328350,143250,172310]
[null,16,20,"2024-01-10",31650,94950,38600,263080,318460,138060,167120]
[null,17,21,"2024-01-11",21760,65280,26540,253190,308570,132870,161930]
[null,18,22,"2024-01-12",{"$f":"E26-$E$2","v":11870},{"$f":"F26-$F$2","v":35610},14480,243300,298680,127680,156740]
["계절 입사비 환불기한(24박*80%)",19,23,"2024-01-13",1980,{"$f":"F27-$F$2","v":5940},{"$f":"G27-$G$2","v":2420},233410,288790,122490,151550]
[null,20,24,"2024-01-14",-7910,-23730,-9640,223520,278900,117300,146360]
[null,21,25,"2024-01-15",-17800,-53400,-21700,213630,269010,112110,141170]
[null,22,26,"2024-01-16",-27690,-83070,-33760,203740,259120,106920,135980]
[null,23,27,"2024-01-17",-37580,-112740,-45820,193850,249230,101730,130790]
["계절퇴사일",null,28,"2024-01-18",-47470,-142410,-57880,183960,239340,96540,125600]
[null,null,29,"2024-01-19",-57360,-172080,-69940,174070,229450,91350,120410]
[null,null,30,"2024-01-20",-67250,-201750,-82000,164180,219560,86160,115220]
[null,null,31,"2024-01-21",-77140,-231420,-94060,154290,209670,80970,110030]
[null,null,32,"2024-01-22",-87030,-261090,-106120,144400,199780,75780,104840]
[null,null,33,"2024-01-23",-96920,-290760,-118180,134510,189890,70590,99650]
[null,null,34,"2024-01-24",-106810,-320430,-130240,124620,180000,65400,94460]
[null,null,35,"2024-01-25",-116700,-350100,-142300,114730,170110,60210,89270]
[null,null,36,"2024-01-26",-126590,-379770,-154360,104840,160220,55020,84080]
[null,null,37,"2024-01-27",-136480,-409440,-166420,94950,150330,49830,78890]
[null,null,38,"2024-01-28",-146370,-439110,-178480,85060,140440,44640,73700]
[null,null,39,"2024-01-29",-156260,-468780,-190540,75170,130550,39450,68510]
[null,null,40,"2024-01-30",-166150,-498450,-202600,65280,120660,34260,63320]
[null,null,41,"2024-01-31",-176040,-528120,-214660,55390,110770,29070,58130]
[null,null,42,"2024-02-01",-185930,-557790,-226720,45500,100880,23880,52940]
[null,null,43,"2024-02-02",-195820,-587460,-238780,35610,90990,18690,47750]
[null,null,44,"2024-02-03",-205710,-617130,-250840,25720,81100,13500,42560]
[null,null,45,"2024-02-04",-215600,-646800,-262900,15830,71210,8310,37370]
["장기A/C 입사비 환불기한(57박*80%)",null,46,"2024-02-05",-225490,-676470,-274960,5940,61320,3120,32180]
[null,null,47,"2024-02-06",-235380,-706140,-287020,-3950,51430,-2070,26990]
[null,null,48,"2024-02-07",-245270,-735810,-299080,-13840,41540,-7260,21800]
[null,null,49,"2024-02-08",-255160,-765480,-311140,-23730,31650,-12450,16610]
[null,null,50,"2024-02-09",-265050,-795150,-323200,-33620,21760,-17640,11420]
[null,null,51,"2024-02-10",-274940,-824820,-335260,-43510,11870,-22830,6230]
["장기B/D 입사비 환불기한(64박*80%)",null,52,"2024-02-11",-284830,-854490,-347320,-53400,1980,-28020,1040]
[null,null,53,"2024-02-12",-294720,-884160,-359380,-63290,-7910,-33210,-4150]
[null,null,54,"2024-02-13",-304610,-913830,-371440,-73180,-17800,-38400,-9340]
[null,null,55,"2024-02-14",-314500,-943500,-383500,-83070,-27690,-43590,-14530]
[null,null,56,"2024-02-15",-324390,-973170,-395560,-92960,-37580,-48780,-19720]
[null,null,57,"2024-02-16",-334280,-1002840,-407620,-102850,-47470,-53970,-24910]
["장기 A/C 퇴사일",null,58,"2024-02-17",-344170,-1032510,-419680,-112740,-57360,-59160,-30100]
[null,null,59,"2024-02-18",-354060,-1062180,-431740,-122630,-67250,-64350,-35290]
["장기 B/D 이동일",null,null,"2024-02-19",-363950,-1091850,-443800,-132520,-77140,-69540,-40480]
[null,null,null,"2024-02-20",-373840,-1121520,-455860,-142410,-87030,-74730,-45670]
[null,null,null,"2024-02-21",-383730,-1151190,-467920,-152300,-96920,-79920,-50860]
[null,null,null,"2024-02-22",-393620,-1180860,-479980,-162190,-106810,-85110,-56050]
[null,null,null,"2024-02-23",-403510,-1210530,-492040,-172080,-116700,-90300,-61240]
[null,null,null,"2024-02-24",-413400,-1240200,-504100,-181970,-126590,-95490,-66430]
["24-1학기 입사일",null,null,"2024-02-25",-423290,-1269870,-516160,-191860,-136480,-100680,-71620]