{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"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":"Sheet1","index":0,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["기초방69","각 표를 결합하여 총합을 구하시는 테이블을 만드시오"]
[]
[]
[null,"일자","직원","매출",null,"일자","직원","매출",null,{"$f":"_xlfn.LET(_xlpm.TH, _xlfn.HSTACK(\"일자\", \"직원\", \"매출\"), _xlpm.T, _xlfn.VSTACK(표1[], 표2[], 표3[]), _xlfn.VSTACK(_xlpm.TH, _xlpm.T, _xlfn.HSTACK(\"\", \"TOTAL\", SUM(INDEX(_xlpm.T, , 3)))))","v":"일자"},"직원","매출"]
[null,"2023-01-03","A",100,null,"2023-01-03","A",100,null,"2023-01-03","A",100]
[null,"2023-01-03","A",200,null,"2023-01-03","A",200,null,"2023-01-03","A",200]
[null,null,null,null,null,"2023-01-04","B",3000,null,"2023-01-04","B",3000]
[null,null,null,null,null,"2023-01-05","B",400,null,"2023-01-05","B",400]
[null,"일자","직원","매출",null,"2023-01-08","B",1500,null,"2023-01-08","B",1500]
[null,"2023-01-04","B",3000,null,"2023-01-07","C",500,null,"2023-01-07","C",500]
[null,"2023-01-05","B",400,null,"2023-01-08","C",400,null,"2023-01-08","C",400]
[null,"2023-01-08","B",1500,null,null,"TOTAL",6100,null,"","TOTAL",6100]
[]
[]
[null,"일자","직원","매출"]
[null,"2023-01-07","C",500]
[null,"2023-01-08","C",400]