{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["환불기준"],"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":"환불기준","index":0,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,0,4,0]]}
["구분",null,null,null,"청연 계절(3인실) 24박","청연 계절(장애인실) 24박","청연 장기(3인실) 65박","청연 장기(장애인실) 65박",null,null,"계절입사","장기입사"]
["2026-여름학기 ",null,null,"1박 단가",9890,12060,9890,12060,null,"입사일","2026-06-28","2026-06-23"]
[null,null,null,"입사비",{"$f":"E2*K4","v":237360},{"$f":"F2*K4","v":289440},{"$f":"G2*L4","v":642850},{"$f":"L4*H2","v":783900},null,"퇴사일","2026-07-22","2026-08-27"]
[null,null,null,"위약금",{"$f":"E3*0.2","v":47472},{"$f":"F3*0.2","v":57888},{"$f":"G3*0.2","v":128570},{"$f":"H3*0.2","v":156780},null,"사용일(박)",{"$f":"K3-K2","v":24},{"$f":"L3-L2","v":65}]
[null,"계절","장기","위약금 (절사)",{"$f":"ROUNDDOWN(E4,-1)","v":47470},57880,{"$f":"ROUNDDOWN(G4,-1)","v":128570},{"$f":"ROUNDDOWN(H4,-1)","v":156780}]
["장기입사일",null,1,"2026-06-23",null,null,{"$f":"G3-G5","v":514280},{"$f":"H3-H5","v":627120}]
[null,null,2,"2026-06-24",null,null,{"$f":"G6-$G$2","v":504390},{"$f":"H6-$H$2","v":615060}]
[null,null,3,"2026-06-25",null,null,494500,603000]
[null,null,4,"2026-06-26",null,null,484610,590940]
[null,1,5,"2026-06-27",null,null,474720,578880]
["계절입사일",2,6,"2026-06-28",{"$f":"E3-E5","v":189890},{"$f":"F3-F5","v":231560},464830,566820]
[null,3,7,"2026-06-29",{"$f":"E11-$E$2","v":180000},{"$f":"F11-$F$2","v":219500},454940,554760]
[null,4,8,"2026-06-30",{"$f":"E12-$E$2","v":170110},{"$f":"F12-$F$2","v":207440},445050,542700]
[null,5,9,"2026-07-01",160220,195380,435160,530640]
[null,6,10,"2026-07-02",150330,183320,425270,518580]
[null,7,11,"2026-07-03",140440,171260,415380,506520]
[null,8,12,"2026-07-04",130550,159200,405490,494460]
[null,9,13,"2026-07-05",120660,147140,395600,482400]
[null,10,14,"2026-07-06",110770,135080,385710,470340]
[null,11,15,"2026-07-07",100880,123020,375820,458280]
[null,12,16,"2026-07-08",90990,110960,365930,446220]
[null,13,17,"2026-07-09",81100,98900,356040,434160]
[null,14,18,"2026-07-10",71210,86840,346150,422100]
[null,15,19,"2026-07-11",61320,74780,336260,410040]
[null,16,20,"2026-07-12",51430,62720,326370,397980]
[null,17,21,"2026-07-13",41540,50660,316480,385920]
[null,18,22,"2026-07-14",31650,38600,306590,373860]
[null,19,23,"2026-07-15",21760,26540,296700,361800]
[null,20,24,"2026-07-16",11870,14480,286810,349740]
["계절입사비 환불기한(24박*80%)",21,25,"2026-07-17",1980,2420,276920,337680]
[null,22,26,"2026-07-18",{"$f":"E30-$E$2","v":-7910},-9640,267030,325620]
[null,23,27,"2026-07-19",-17800,-21700,257140,313560]
[null,null,28,"2026-07-20",-27690,-33760,247250,301500]
[null,null,29,"2026-07-21",-37580,-45820,237360,289440]
["계절퇴사일",null,30,"2026-07-22",-47470,-57880,227470,277380]
[null,null,31,"2026-07-23",-57360,-69940,217580,265320]
[null,null,32,"2026-07-24",-67250,-82000,207690,253260]
[null,null,33,"2026-07-25",-77140,-94060,197800,241200]
[null,null,34,"2026-07-26",-87030,-106120,187910,{"$f":"H38-$H$2","v":229140}]
[null,null,35,"2026-07-27",-96920,-118180,178020,217080]
[null,null,36,"2026-07-28",-106810,-130240,168130,205020]
[null,null,37,"2026-07-29",-116700,-142300,158240,192960]
[null,null,38,"2026-07-30",-126590,-154360,148350,180900]
[null,null,39,"2026-07-31",-136480,-166420,138460,168840]
[null,null,40,"2026-08-01",-146370,-178480,128570,156780]
[null,null,41,"2026-08-02",-156260,-190540,118680,144720]
[null,null,42,"2026-08-03",-166150,-202600,108790,132660]
[null,null,43,"2026-08-04",-176040,-214660,98900,120600]
[null,null,44,"2026-08-05",-185930,-226720,89010,108540]
[null,null,45,"2026-08-06",-195820,-238780,79120,96480]
[null,null,46,"2026-08-07",-205710,-250840,69230,84420]
[null,null,47,"2026-08-08",-215600,-262900,59340,72360]
[null,null,48,"2026-08-09",-225490,-274960,49450,60300]
[null,null,49,"2026-08-10",-235380,-287020,39560,48240]
[null,null,50,"2026-08-11",-245270,-299080,29670,36180]
[null,null,51,"2026-08-12",-255160,-311140,19780,24120]
["장기입사비 환불기한(65박*80%)",null,52,"2026-08-13",-265050,-323200,9890,12060]
[null,null,53,"2026-08-14",-274940,-335260,{"$f":"G57-$G$2","v":0},0]
[null,null,54,"2026-08-15",-284830,-347320,-9890,-12060]
[null,null,55,"2026-08-16",-294720,-359380,-19780,-24120]
[null,null,56,"2026-08-17",-304610,-371440,-29670,-36180]
[null,null,57,"2026-08-18",-314500,-383500,-39560,-48240]
[null,null,58,"2026-08-19",-324390,-395560,-49450,-60300]
[null,null,59,"2026-08-20",-334280,-407620,-59340,-72360]
[null,null,null,"2026-08-21",-344170,-419680,-69230,-84420]
[null,null,null,"2026-08-22",-354060,-431740,-79120,-96480]
[null,null,null,"2026-08-23",-363950,-443800,-89010,-108540]
[null,null,null,"2026-08-24",-373840,-455860,-98900,-120600]
[null,null,null,"2026-08-25",-383730,-467920,{"$f":"G68-$G$2","v":-108790},-132660]
[null,null,null,"2026-08-26",-393620,-479980,-118680,-144720]
["장기퇴사일",null,null,"2026-08-27",-403510,-492040,-128570,-156780]