{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","시나리오 요약","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["고객 포인트 적립 현황"]
[]
["고객영","고객아이디","등급","가입년도","적립포인트"]
["장세준","sj1524 ","골드","2016년",168000]
["전시윤","star2008","실버","2020년",71000]
["김상희","shkim55","일반","2024년",16000]
["이채성","lee1133","일반","2022년",49000]
["배하준","boys7477","골드","2017년",125000]
["장서영","young99","일반","2023년",38000]

{"sheet":"기본작업-2","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["튼튼병원 진료 현황"]
[]
["처방번호","진요일자","이름","성별","나이","처방약일수","진료비"]
[453257,"2024-03-04","이미경","여성",35,3,5634.5164000000004]
[618301,"2024-03-04","강현준","남성",66,2,3254.4580999999998]
[936422,"2024-03-05","김유진","여성",28,5,6257.9633000000003]
[554286,"2024-03-05","전선하","여성",44,3,6542.8546999999999]
[607005,"2024-03-05","권지향","여성",72,3,3063.2651000000001]
[793241,"2024-03-06","최용성","남성",9,5,1807.9087999999999]
[165028,"2024-03-06","조선수","남성",16,2,2648.5214000000001]
[296177,"2024-03-07","유한열","남성",56,3,5771.6908000000003]
[819900,"2024-03-07","김미정","여성",49,5,6328.3427000000001]

{"sheet":"기본작업-3","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["박스오피스 현황"]
[]
["영화명","카테고리","개봉일","상영시간(분)","등급","평점"]
["미카15","액션","2024-02-05",134,"15세 이상",4]
["특별한가족","미스터리","2024-02-05",128,"15세 이상",5]
["행복의국가","액션","2024-02-05",100,"12세 이상",5]
["백수빌라","코미디","2024-02-12",110,"전체",3]
["시민유진","코미디","2024-02-12",98,"12세 이상",5]
["명탐정코알라","코미디","2024-02-12",90,"전체",2]
["슈퍼외계인","액션","2024-02-12",115,"12세 이상",4]
["그가죽었다","미스터리","2012-02-19",122,"15세 이상",3]
["빅토리가든","액션","2012-02-19",106,"15세 이상",3]
["침입자","미스터리","2012-02-26",120,"15세 이상",4,null,"카테고리"]
["블랙버드","액션","2012-02-26",118,"12세 이상",2,null,5]
["핸섬보이즈","코미디","2012-02-26",107,"전체",5]

{"sheet":"계산작업","index":3,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,1,9,3],[35,0,35,4]]}
["[표1]","계열 학과별 취업률",null,null,null,null,"[표2]","등록금 실납입금액"]
["계열","학과","경쟁률","재학생","취업률",null,"학번","이름","학점","등록금","실납입금액"]
["공학계열","컴퓨터학과",2.75,275,4.75,null,24020352,"박지영",2.87,3580000,{"$f":"IF(A17:C25,AVERAGE,a)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["자연계열","생명과학과",1.83,239,3.81,null,24020967,"조재성",4.12,3600000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["자연계열","식품조리과",2.14,302,2.94,null,23080108,"김민서",3.76,4150000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["공학계열","로봇공학과",3.23,261,5.62,null,24020135,"이중희",4.3,3860000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["공학계열","IT융합학과",1.98,225,3.27,null,23080579,"신영숙",2.5299999999999998,4270000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["자연계열","대기과학과",2.4300000000000002,195,4.53,null,24020251,"최경민",3.45,3750000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["공학계열","신소재학과",3.06,238,2.76,null,24020608,"김경아",3.89,3670000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["계열","공학계열에서 취업률이 가장 높은 학과명",null,null,null,null,23080774,"한정수",4.26,4590000,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["공학계열",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,"<학점순위별 장학금지급률>"]
[null,null,null,null,null,null,"순위",1,2,4,6]
[null,null,null,null,null,null,"장학금지급률",1,0.8,0.6,0]
[]
["[표3]","국가별 수출/수입 현황",null,null,null,null,"[표4]","성적현황"]
["국가명","수출액","수입액","수출현황",null,null,"이름","1과목","2과목","3과목","4과목","비고"]
["프랑스",43252500,36765300,null,null,null,"이하늘",3.47,3.18,4.05,3.82]
["일본",63824100,54551000,null,null,null,"박정훈",2.99,3.15,2.68,2.71]
["캐나다",34280000,41045900,null,null,null,"엄지영",3.92,4.5199999999999996,4.17,4.2699999999999996]
["중국",75360200,65657000,null,null,null,"김동준",3.84,3.51,3.36,3.62]
["미국",84822400,97853300,null,null,null,"유서하",4.68,4.76,4.83,4.8899999999999997]
["스페인",52461000,44592000,null,null,null,"황성철",1.95,1.52,1.28,1.63]
["러시아",69021000,83487400,null,null,null,"윤미진",4.25,4.22,4.05,4.16]
["브라질",49240000,58104900,null,null,null,"김청옥",2.2599999999999998,2.54,2.38,2.4300000000000002]
[]
["[표5]","도서 분류"]
["분류코드","도서명","입고일","출판사","저자","가격"]
[3333,"봄밤","2024-03-05","나무서재","이수현",16900]
[1111,"회장의생각","2024-03-07","경제북스","박서진",24500]
[2222,"모든편의점","2024-03-10","한영사","문영철",18300]
[3333,"작별하는것","2024-03-13","북산책","장시원",15200]
[1111,"토탈브레인","2024-03-18","베타미디어","선우진",19000]
[1111,"리더의질문","2024-03-24","경영하우스","유인명",21600]
[2222,"인기팡팡","2024-03-27","미래아이","현진원",17500]
["가장 빈도가 높은 분류코드 도서의 개수"]

{"sheet":"분석작업-1","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["상공주차장 주차현황"]
[]
["구분","차량번호","주차장","입차시간","퇴차시간","할인금액","이용금액","정산금액"]
["예약","61호7459","지상-2","07:19:00","12:20:00",3000,17535,14535]
["입퇴원","43가6770","지상-2","09:19:00","10:47:00",4000,4480,480]
["진료","69가8432","지상-1","09:39:00","13:27:00",3000,13580,10580]
["예약","51나7326","지하","10:15:00","12:52:00",2000,8295,6295]
["예약","22가3590","지하","10:25:00","11:30:00",2000,3675,1675]
["입퇴원","38나9193","지상-1","10:40:00","20:50:00",4000,35350,31350]
["진료","37나2896","지하","11:45:00","20:21:00",3000,30660,27660]
["예약","86가4414","지상-2","11:46:00","12:27:00",2000,2835,835]
["진료","15사5249","지상-1","12:31:00","21:55:00",3000,32340,29340]
["예약","32다5229","지상-2","13:40:00","15:07:00",1000,5845,4845]
["진료","67다4634","지하","13:57:00","14:31:00",2000,2590,590]
["진료","96가1887","지하","14:10:00","19:51:00",2000,18935,16935]
["입퇴원","83허1845","지상-1","15:34:00","18:53:00",3000,11165,8165]
[]
[]
[]
[null,"열 레이블"]
[null,"지상-1",null,"지상-2",null,"지하"]
["행 레이블","합계 : 이용금액","합계 : 할인금액","합계 : 이용금액","합계 : 할인금액","합계 : 이용금액","합계 : 할인금액"]
["예약",null,null,26215,6000,11970,4000]
["입퇴원",46515,7000,4480,4000]
["진료",45920,6000,null,null,52185,7000]

{"sheet":"시나리오 요약","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","환율인상","환율인하"]
[null,null,null,null,"만든 사람 user 날짜 2026-06-22","만든 사람 user 날짜 2026-06-22"]
[null,"변경 셀:"]
[null,null,"$F$3",1200,1250,1150]
[null,"결과 셀:"]
[null,null,"$F$12",69324000,72212500,66435500]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"분석작업-2","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["냉동식품 수입현황"]
[]
[null,null,null,null,"환율",1200]
["구분","제품코드","원가(USD)","원가(원)","수입량","수입총액(원)"]
["수산물","OC-1524",48,{"$f":"$F$3*C5","v":57600},200,{"$f":"D5*E5","v":11520000}]
["축산물","FN-2877",32,{"$f":"$F$3*C6","v":38400},320,{"$f":"D6*E6","v":12288000}]
["축산물","FN-6241",44,52800,150,7920000]
["수산물","OC-3690",38,45600,240,10944000]
["수산물","OC-8732",51,61200,120,7344000]
["축산물","FN-5508",49,58800,150,8820000]
["축산물","FN-9273",38,45600,230,10488000]
[null,null,null,null,"수입총액합계",{"$f":"SUM(F5:F11)","v":69324000}]

{"sheet":"매크로작업","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["상공아파트 전기사용 현황"]
[]
["호수","사용량","공동요금","전기요금","요금총액"]
["101호",241,26540,42940]
["102호",354,26540,72310]
["201호",199,26540,31350]
["202호",406,26540,92940]
["301호",387,26540,80890]
["302호",448,26540,108280]
["401호",275,26540,51780]
["402호",302,26540,58790]

{"sheet":"차트작업","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["전자제품 목표/생산 현황"]
[]
["제품명","목표량","생산량","생산단가","달성률"]
["세탁기",850,882,560000,{"$f":"C4/B4","v":1.0376470588235294}]
["냉장고",1200,1154,1250000,{"$f":"C5/B5","v":0.96166666666666667}]
["스마트TV",1500,1518,1080000,1.012]
["인덕션",650,613,320000,0.94307692307692303]
["합계",{"$f":"SUM(B4:B7)","v":4200},{"$f":"SUM(C4:C7)","v":4167},3210000,0.9921428571428571]