{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["연습1","연습1(정답)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":2,"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":"연습1","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["퇴직금 정산 내역"]
[]
["성명","부서명","직책","근속기간","기본급","상여금","수당","퇴직금"]
["김민서","회계부","부장",25,2800,{"$f":"E4*400%","v":11200},{"$f":"IF(D4>=30, E4*10%, IF(D4>=20, E4*5%, E4*2%))","v":140},{"$f":"D4*E4+F4+G4","v":81340}]
["박해수","회계부","과장",12,2000,8000,40,{"$f":"D5*E5+F5+G5","v":32040}]
["최경민","인사부","부장",21,2800,11200,140,70140]
["이가영","영업부","차장",25,2500,10000,125,72625]
["강호정","영업부","대리",9,1800,7200,36,23436]
["황경엽","회계부","과장",18,2000,8000,40,44040]
["윤소정","회계부","차장",22,2500,10000,125,65125]
["조경원","인사부","대리",14,1800,7200,36,32436]
["황진주","회계부","대리",7,1800,7200,36,19836]
["유병문","영업부","대리",7,1800,7200,36,19836]

{"sheet":"연습1(정답)","index":1,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["퇴직금 정산 내역"]
[null,null,null,null,null,null,null,null,null,"②번 정답"]
["성명","부서명","직책","근속기간","기본급","상여금","수당","퇴직금",null,"부서명","직책"]
["김민서","회계부","부장",25,2800,{"$f":"E4*400%","v":11200},{"$f":"IF(D4>=30, E4*10%, IF(D4>=20, E4*5%, E4*2%))","v":140},{"$f":"D4*E4+F4+G4","v":81340},null,"회계부"]
["박해수","회계부","과장",12,2000,8000,40,{"$f":"D5*E5+F5+G5","v":32040},null,null,"과장"]
["최경민","인사부","부장",21,2800,11200,140,70140]
["이가영","영업부","차장",25,2500,10000,125,72625]
["강호정","영업부","대리",9,1800,7200,36,23436,null,"성명","부서명","직책","근속기간","기본급","상여금","수당","퇴직금"]
["황경엽","회계부","과장",18,2000,8000,40,44040,null,"김민서","회계부","부장",25,2800,11200,140,81340]
["윤소정","회계부","차장",22,2500,10000,125,65125,null,"박해수","회계부","과장",12,2000,8000,40,32040]
["조경원","인사부","대리",14,1800,7200,36,32436,null,"황경엽","회계부","과장",18,2000,8000,40,44040]
["황진주","회계부","대리",7,1800,7200,36,19836,null,"윤소정","회계부","차장",22,2500,10000,125,65125]
["유병문","영업부","대리",7,1800,7200,36,19836,null,"황진주","회계부","대리",7,1800,7200,36,19836]
["①번 정답",null,null,null,null,null,null,null,null,"③번 정답"]
["근속기간","퇴직금",null,null,null,null,null,null,null,"기본급","상여금"]
[">=10","<=50000",null,null,null,null,null,null,null,">=2000",">=100"]
[]
[]
[]
["성명","부서명","직책","근속기간","기본급","상여금","수당","퇴직금",null,"성명","부서명","직책","상여금","퇴직금"]
["박해수","회계부","과장",12,2000,8000,40,32040,null,"김민서","회계부","부장",11200,81340]
["황경엽","회계부","과장",18,2000,8000,40,44040,null,"박해수","회계부","과장",8000,32040]
["조경원","인사부","대리",14,1800,7200,36,32436,null,"최경민","인사부","부장",11200,70140]
[null,null,null,null,null,null,null,null,null,"이가영","영업부","차장",10000,72625]
[null,null,null,null,null,null,null,null,null,"황경엽","회계부","과장",8000,44040]
[null,null,null,null,null,null,null,null,null,"윤소정","회계부","차장",10000,65125]