{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["환불기준(2024-여름학기)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"환불기준(2024-여름학기)","index":0,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,0,4,0]]}
["구분",null,null,null,"청연 계절(3인실) 23박","청연 계절(장애인실) 23박","청연 장기(3인실) 62박",null,null,"계절입사","장기입사"]
["24-여름학기 ",null,null,"1박 단가",9890,12060,9890,null,"입사일","2024-06-25","2024-06-22"]
[null,null,null,"입사비",{"$f":"E2*J4","v":227470},{"$f":"F2*J4","v":277380},{"$f":"G2*K4","v":613180},null,"퇴사일","2024-07-18","2024-08-23"]
[null,null,null,"위약금",{"$f":"E3*0.2","v":45494},55476,122636,null,"사용일(박)",{"$f":"J3-J2","v":23},{"$f":"K3-K2","v":62}]
[null,"계절","장기","위약금 (절상)",{"$f":"ROUNDDOWN(E4,-1)","v":45490},55470,122630]
["장기입사일",null,1,"2024-06-22",null,null,{"$f":"G3-G5","v":490550}]
[null,null,2,"2024-06-23",null,null,{"$f":"G6-$G$2","v":480660}]
[null,null,3,"2024-06-24",null,null,{"$f":"G7-$G$2","v":470770}]
["계절입사일",null,4,"2024-06-25",{"$f":"E3-E5","v":181980},{"$f":"F3-F5","v":221910},460880]
[null,1,5,"2024-06-26",{"$f":"E9-$E$2","v":172090},{"$f":"F9-$F$2","v":209850},450990]
[null,2,6,"2024-06-27",{"$f":"E10-$E$2","v":162200},{"$f":"F10-$F$2","v":197790},441100]
[null,3,7,"2024-06-28",152310,185730,431210]
[null,4,8,"2024-06-29",142420,173670,421320]
[null,5,9,"2024-06-30",132530,161610,411430]
[null,6,10,"2024-07-01",122640,149550,401540]
[null,7,11,"2024-07-02",112750,137490,391650]
[null,8,12,"2024-07-03",102860,125430,381760]
[null,9,13,"2024-07-04",92970,113370,371870]
[null,10,14,"2024-07-05",83080,101310,361980]
[null,11,15,"2024-07-06",73190,89250,352090]
[null,12,16,"2024-07-07",63300,77190,342200]
[null,13,17,"2024-07-08",53410,65130,332310]
[null,14,18,"2024-07-09",43520,53070,322420]
[null,15,19,"2024-07-10",33630,41010,312530]
[null,16,20,"2024-07-11",23740,28950,302640]
[null,17,21,"2024-07-12",13850,16890,292750]
["계절입사비 환불기한(23박*80%)",18,22,"2024-07-13",3960,4830,282860]
[null,19,23,"2024-07-14",-5930,-7230,272970]
[null,20,24,"2024-07-15",-15820,-19290,263080]
[null,21,25,"2024-07-16",-25710,-31350,253190]
[null,22,26,"2024-07-17",-35600,-43410,243300]
["계절퇴사일",23,27,"2024-07-18",-45490,-55470,233410]
[null,null,28,"2024-07-19",-55380,-67530,223520]
[null,null,29,"2024-07-20",-65270,-79590,213630]
[null,null,30,"2024-07-21",-75160,-91650,203740]
[null,null,31,"2024-07-22",-85050,-103710,193850]
[null,null,32,"2024-07-23",-94940,-115770,183960]
[null,null,33,"2024-07-24",-104830,-127830,174070]
[null,null,34,"2024-07-25",-114720,-139890,164180]
[null,null,35,"2024-07-26",-124610,-151950,154290]
[null,null,36,"2024-07-27",-134500,-164010,144400]
[null,null,37,"2024-07-28",-144390,-176070,134510]
[null,null,38,"2024-07-29",-154280,-188130,124620]
[null,null,39,"2024-07-30",-164170,-200190,114730]
[null,null,40,"2024-07-31",-174060,-212250,104840]
[null,null,41,"2024-08-01",-183950,-224310,94950]
[null,null,42,"2024-08-02",-193840,-236370,85060]
[null,null,43,"2024-08-03",-203730,-248430,75170]
[null,null,44,"2024-08-04",-213620,-260490,65280]
[null,null,45,"2024-08-05",-223510,-272550,55390]
[null,null,46,"2024-08-06",-233400,-284610,45500]
[null,null,47,"2024-08-07",-243290,-296670,35610]
[null,null,48,"2024-08-08",-253180,-308730,25720]
[null,null,49,"2024-08-09",-263070,-320790,15830]
["장기입사비 환불기한(62박*80%)",null,50,"2024-08-10",-272960,-332850,5940]
[null,null,51,"2024-08-11",-282850,-344910,-3950]
[null,null,52,"2024-08-12",-292740,-356970,-13840]
[null,null,53,"2024-08-13",-302630,-369030,-23730]
[null,null,54,"2024-08-14",-312520,-381090,-33620]
[null,null,55,"2024-08-15",-322410,-393150,-43510]
[null,null,56,"2024-08-16",-332300,-405210,-53400]
[null,null,57,"2024-08-17",-342190,-417270,-63290]
[null,null,58,"2024-08-18",-352080,-429330,-73180]
[null,null,59,"2024-08-19",-361970,-441390,-83070]
[null,null,null,"2024-08-20",-371860,-453450,-92960]
[null,null,null,"2024-08-21",-381750,-465510,-102850]
[null,null,null,"2024-08-22",-391640,-477570,-112740]
["장기퇴사일",null,null,"2024-08-23",-401530,-489630,-122630]
[null,null,null,"2024-08-24",-411420,-501690,-132520]
["24-2학기 입사일",null,null,"2024-08-25",-421310,-513750,-142410]