{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["기초방 68","  표1과 표2를 결합하여 [J6]에 출력하시오"]
[null,"  출력시 지역명 / 색상 / 개수 / 연도순으로 출력하시오"]
[null,"  정렬은 지역명 + 개수 + 연도로 하시오"]
[null,"  연도가 없는것은 2021이전으로 표기하시오"]
[]
["색상","지역명","개수",null,"색상","지역명","개수","연도",null,"지역명","색상","개수","연도",null,{"$f":"_xlfn.LET(_xlpm.▶header, \"각 영역의 헤더\", _xlpm.TH, _xlfn.HSTACK(\"색상\", \"지역명\", \"개수\", \"연도\"), _xlpm.▶sort_expand, \"표1에 연도추가\", _xlpm.T, _xlfn._xlws.SORT(_xlfn.VSTACK(_xlfn.EXPAND(표1[], , 4, \"2021이전\"), 표2[]), {2,3,4}), _xlpm.RESULT, _xlfn.VSTACK(_xlpm.TH, _xlpm.T), _xlpm.▶output, \"지역명_색상_개수_연도순으로 출력\", _xlfn.CHOOSECOLS(_xlpm.RESULT, 2, 1, 3, 4))","v":"지역명"},"색상","개수","연도"]
["검정","부산",123,null,"회색","부산",117,"2023",null,"강원","노랑",106,2022,null,"강원","노랑",106,"2022"]
["회색","부산",148,null,"회색","부산",124,"2022",null,"강원","검정",108,2023,null,"강원","검정",108,"2023"]
["검정","강원",139,null,"파랑","강원",157,"2023",null,"강원","회색",115,2021,null,"강원","회색",115,"2021"]
["초록","인천",124,null,"노랑","부산",166,"2021",null,"강원","초록",116,"2021이전",null,"강원","초록",116,"2021이전"]
["초록","강원",157,null,"파랑","서울",154,"2021",null,"강원","노랑",119,2023,null,"강원","노랑",119,"2023"]
["초록","부산",190,null,"검정","강원",108,"2023",null,"강원","검정",139,"2021이전",null,"강원","검정",139,"2021이전"]
["파랑","서울",111,null,"파랑","강원",197,"2022",null,"강원","초록",157,"2021이전",null,"강원","초록",157,"2021이전"]
["검정","강원",166,null,"검정","서울",141,"2022",null,"강원","파랑",157,2023,null,"강원","파랑",157,"2023"]
["회색","부산",148,null,"초록","인천",185,"2021",null,"강원","노랑",160,"2021이전",null,"강원","노랑",160,"2021이전"]
["초록","부산",110,null,"회색","서울",151,"2022",null,"강원","검정",166,"2021이전",null,"강원","검정",166,"2021이전"]
["파랑","서울",194,null,"회색","강원",181,"2021",null,"강원","파랑",178,2022,null,"강원","파랑",178,"2022"]
["초록","서울",176,null,"검정","인천",102,"2021",null,"강원","회색",181,2021,null,"강원","회색",181,"2021"]
["회색","서울",177,null,"노랑","강원",119,"2023",null,"강원","검정",187,2023,null,"강원","검정",187,"2023"]
["초록","강원",116,null,"검정","서울",147,"2021",null,"강원","검정",189,"2021이전",null,"강원","검정",189,"2021이전"]
["검정","강원",189,null,"검정","인천",177,"2023",null,"강원","파랑",197,2022,null,"강원","파랑",197,"2022"]
["검정","부산",133,null,"회색","인천",134,"2023",null,"부산","초록",110,"2021이전",null,"부산","초록",110,"2021이전"]
["검정","인천",191,null,"노랑","인천",192,"2022",null,"부산","회색",117,2023,null,"부산","회색",117,"2023"]
["노랑","부산",151,null,"노랑","부산",148,"2022",null,"부산","검정",123,"2021이전",null,"부산","검정",123,"2021이전"]
["검정","부산",187,null,"파랑","강원",178,"2022",null,"부산","회색",124,2022,null,"부산","회색",124,"2022"]
["검정","부산",127,null,"노랑","서울",114,"2023",null,"부산","검정",126,"2021이전",null,"부산","검정",126,"2021이전"]
["검정","부산",126,null,"회색","강원",115,"2021",null,"부산","검정",127,"2021이전",null,"부산","검정",127,"2021이전"]
["노랑","서울",166,null,"검정","강원",187,"2023",null,"부산","검정",133,"2021이전",null,"부산","검정",133,"2021이전"]
["노랑","부산",144,null,"노랑","강원",106,"2022",null,"부산","노랑",144,"2021이전",null,"부산","노랑",144,"2021이전"]
["검정","서울",101,null,"초록","부산",175,"2021",null,"부산","회색",148,"2021이전",null,"부산","회색",148,"2021이전"]
["노랑","부산",181,null,"노랑","서울",105,"2023",null,"부산","회색",148,"2021이전",null,"부산","회색",148,"2021이전"]
["노랑","강원",160,null,"노랑","서울",111,"2022",null,"부산","노랑",148,2022,null,"부산","노랑",148,"2022"]
["회색","부산",164,null,"노랑","부산",198,"2022",null,"부산","노랑",151,"2021이전",null,"부산","노랑",151,"2021이전"]
[null,null,null,null,null,null,null,null,null,"부산","회색",164,"2021이전",null,"부산","회색",164,"2021이전"]
[null,null,null,null,null,null,null,null,null,"부산","노랑",166,2021,null,"부산","노랑",166,"2021"]
[null,null,null,null,null,null,null,null,null,"부산","초록",175,2021,null,"부산","초록",175,"2021"]
[null,null,null,null,null,null,null,null,null,"부산","노랑",181,"2021이전",null,"부산","노랑",181,"2021이전"]
[null,null,null,null,null,null,null,null,null,"부산","검정",187,"2021이전",null,"부산","검정",187,"2021이전"]
[null,null,null,null,null,null,null,null,null,"부산","초록",190,"2021이전",null,"부산","초록",190,"2021이전"]
[null,null,null,null,null,null,null,null,null,"부산","노랑",198,2022,null,"부산","노랑",198,"2022"]
[null,null,null,null,null,null,null,null,null,"서울","검정",101,"2021이전",null,"서울","검정",101,"2021이전"]
[null,null,null,null,null,null,null,null,null,"서울","노랑",105,2023,null,"서울","노랑",105,"2023"]
[null,null,null,null,null,null,null,null,null,"서울","파랑",111,"2021이전",null,"서울","파랑",111,"2021이전"]
[null,null,null,null,null,null,null,null,null,"서울","노랑",111,2022,null,"서울","노랑",111,"2022"]
[null,null,null,null,null,null,null,null,null,"서울","노랑",114,2023,null,"서울","노랑",114,"2023"]
[null,null,null,null,null,null,null,null,null,"서울","검정",141,2022,null,"서울","검정",141,"2022"]
[null,null,null,null,null,null,null,null,null,"서울","검정",147,2021,null,"서울","검정",147,"2021"]
[null,null,null,null,null,null,null,null,null,"서울","회색",151,2022,null,"서울","회색",151,"2022"]
[null,null,null,null,null,null,null,null,null,"서울","파랑",154,2021,null,"서울","파랑",154,"2021"]
[null,null,null,null,null,null,null,null,null,"서울","노랑",166,"2021이전",null,"서울","노랑",166,"2021이전"]
[null,null,null,null,null,null,null,null,null,"서울","초록",176,"2021이전",null,"서울","초록",176,"2021이전"]
[null,null,null,null,null,null,null,null,null,"서울","회색",177,"2021이전",null,"서울","회색",177,"2021이전"]
[null,null,null,null,null,null,null,null,null,"서울","파랑",194,"2021이전",null,"서울","파랑",194,"2021이전"]
[null,null,null,null,null,null,null,null,null,"인천","검정",102,2021,null,"인천","검정",102,"2021"]
[null,null,null,null,null,null,null,null,null,"인천","초록",124,"2021이전",null,"인천","초록",124,"2021이전"]
[null,null,null,null,null,null,null,null,null,"인천","회색",134,2023,null,"인천","회색",134,"2023"]
[null,null,null,null,null,null,null,null,null,"인천","검정",177,2023,null,"인천","검정",177,"2023"]
[null,null,null,null,null,null,null,null,null,"인천","초록",185,2021,null,"인천","초록",185,"2021"]
[null,null,null,null,null,null,null,null,null,"인천","검정",191,"2021이전",null,"인천","검정",191,"2021이전"]
[null,null,null,null,null,null,null,null,null,"인천","노랑",192,2022,null,"인천","노랑",192,"2022"]