{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":270,"n_cols":7,"rows_kept":270,"cut":false,"hidden":false,"merged":[]}
["기초방 71","다음 표의 누적판매량과 월누적 판매량을 구하시오"]
[]
[null,"날짜","판매","누적판매량","월누적판매"]
[null,"2023-01-01",5,{"$f":"_xlfn.LET(_xlpm.수량, C4:C270, _xlpm.누적, _xlfn.SCAN(0, _xlpm.수량, _xlfn.LAMBDA(_xlpm.S,_xlpm.A, _xlpm.S + _xlpm.A)), _xlpm.월누적, _xlfn.SCAN(0, _xlpm.수량, _xlfn.LAMBDA(_xlpm.S,_xlpm.A, IFERROR(IF(MONTH(OFFSET(_xlpm.A, 0, -1)) <> MONTH(OFFSET(_xlpm.A, -1, -1)), _xlpm.S * 0 + _xlpm.A, _xlpm.S + _xlpm.A), _xlpm.A))), _xlfn.HSTACK(_xlpm.누적, _xlpm.월누적))","v":5},5,5,5]
[null,"2023-01-02",5,10,10,10,10]
[null,"2023-01-03",2,12,12,12,12]
[null,"2023-01-04",8,20,20,20,20]
[null,"2023-01-05",3,23,23,23,23]
[null,"2023-01-06",4,27,27,27,27]
[null,"2023-01-07",3,30,30,30,30]
[null,"2023-01-08",1,31,31,31,31]
[null,"2023-01-09",1,32,32,32,32]
[null,"2023-01-10",8,40,40,40,40]
[null,"2023-01-11",2,42,42,42,42]
[null,"2023-01-12",9,51,51,51,51]
[null,"2023-01-13",6,57,57,57,57]
[null,"2023-01-14",8,65,65,65,65]
[null,"2023-01-15",8,73,73,73,73]
[null,"2023-01-16",3,76,76,76,76]
[null,"2023-01-17",2,78,78,78,78]
[null,"2023-01-18",7,85,85,85,85]
[null,"2023-01-19",8,93,93,93,93]
[null,"2023-01-20",8,101,101,101,101]
[null,"2023-01-21",6,107,107,107,107]
[null,"2023-01-22",10,117,117,117,117]
[null,"2023-01-23",1,118,118,118,118]
[null,"2023-01-24",10,128,128,128,128]
[null,"2023-01-25",1,129,129,129,129]
[null,"2023-01-26",2,131,131,131,131]
[null,"2023-01-27",3,134,134,134,134]
[null,"2023-01-28",10,144,144,144,144]
[null,"2023-01-29",3,147,147,147,147]
[null,"2023-01-30",5,152,152,152,152]
[null,"2023-01-31",6,158,158,158,158]
[null,"2023-02-01",4,162,4,162,4]
[null,"2023-02-02",4,166,8,166,8]
[null,"2023-02-03",4,170,12,170,12]
[null,"2023-02-04",5,175,17,175,17]
[null,"2023-02-05",10,185,27,185,27]
[null,"2023-02-06",4,189,31,189,31]
[null,"2023-02-07",2,191,33,191,33]
[null,"2023-02-08",10,201,43,201,43]
[null,"2023-02-09",2,203,45,203,45]
[null,"2023-02-10",2,205,47,205,47]
[null,"2023-02-11",10,215,57,215,57]
[null,"2023-02-12",6,221,63,221,63]
[null,"2023-02-13",1,222,64,222,64]
[null,"2023-02-14",8,230,72,230,72]
[null,"2023-02-15",5,235,77,235,77]
[null,"2023-02-16",2,237,79,237,79]
[null,"2023-02-17",9,246,88,246,88]
[null,"2023-02-18",9,255,97,255,97]
[null,"2023-02-19",3,258,100,258,100]
[null,"2023-02-20",8,266,108,266,108]
[null,"2023-02-21",3,269,111,269,111]
[null,"2023-02-22",3,272,114,272,114]
[null,"2023-02-23",4,276,118,276,118]
[null,"2023-02-24",10,286,128,286,128]
[null,"2023-02-25",10,296,138,296,138]
[null,"2023-02-26",9,305,147,305,147]
[null,"2023-02-27",2,307,149,307,149]
[null,"2023-02-28",7,314,156,314,156]
[null,"2023-03-01",10,324,10,324,10]
[null,"2023-03-02",4,328,14,328,14]
[null,"2023-03-03",3,331,17,331,17]
[null,"2023-03-04",9,340,26,340,26]
[null,"2023-03-05",1,341,27,341,27]
[null,"2023-03-06",3,344,30,344,30]
[null,"2023-03-07",3,347,33,347,33]
[null,"2023-03-08",9,356,42,356,42]
[null,"2023-03-09",8,364,50,364,50]
[null,"2023-03-10",7,371,57,371,57]
[null,"2023-03-11",2,373,59,373,59]
[null,"2023-03-12",5,378,64,378,64]
[null,"2023-03-13",5,383,69,383,69]
[null,"2023-03-14",4,387,73,387,73]
[null,"2023-03-15",2,389,75,389,75]
[null,"2023-03-16",4,393,79,393,79]
[null,"2023-03-17",8,401,87,401,87]
[null,"2023-03-18",2,403,89,403,89]
[null,"2023-03-19",8,411,97,411,97]
[null,"2023-03-20",3,414,100,414,100]
[null,"2023-03-21",4,418,104,418,104]
[null,"2023-03-22",7,425,111,425,111]
[null,"2023-03-23",2,427,113,427,113]
[null,"2023-03-24",1,428,114,428,114]
[null,"2023-03-25",9,437,123,437,123]
[null,"2023-03-26",5,442,128,442,128]
[null,"2023-03-27",2,444,130,444,130]
[null,"2023-03-28",8,452,138,452,138]
[null,"2023-03-29",7,459,145,459,145]
[null,"2023-03-30",5,464,150,464,150]
[null,"2023-03-31",10,474,160,474,160]
[null,"2023-04-01",8,482,8,482,8]
[null,"2023-04-02",8,490,16,490,16]
[null,"2023-04-03",4,494,20,494,20]
[null,"2023-04-04",7,501,27,501,27]
[null,"2023-04-05",7,508,34,508,34]
[null,"2023-04-06",4,512,38,512,38]
[null,"2023-04-07",10,522,48,522,48]
[null,"2023-04-08",10,532,58,532,58]
[null,"2023-04-09",4,536,62,536,62]
[null,"2023-04-10",10,546,72,546,72]
[null,"2023-04-11",6,552,78,552,78]
[null,"2023-04-12",3,555,81,555,81]
[null,"2023-04-13",1,556,82,556,82]
[null,"2023-04-14",9,565,91,565,91]
[null,"2023-04-15",7,572,98,572,98]
[null,"2023-04-16",1,573,99,573,99]
[null,"2023-04-17",3,576,102,576,102]
[null,"2023-04-18",6,582,108,582,108]
[null,"2023-04-19",10,592,118,592,118]
[null,"2023-04-20",9,601,127,601,127]
[null,"2023-04-21",10,611,137,611,137]
[null,"2023-04-22",10,621,147,621,147]
[null,"2023-04-23",6,627,153,627,153]
[null,"2023-04-24",1,628,154,628,154]
[null,"2023-04-25",3,631,157,631,157]
[null,"2023-04-26",4,635,161,635,161]
[null,"2023-04-27",7,642,168,642,168]
[null,"2023-04-28",9,651,177,651,177]
[null,"2023-04-29",3,654,180,654,180]
[null,"2023-04-30",2,656,182,656,182]
[null,"2023-05-01",9,665,9,665,9]
[null,"2023-05-02",8,673,17,673,17]
[null,"2023-05-03",3,676,20,676,20]
[null,"2023-05-04",10,686,30,686,30]
[null,"2023-05-05",5,691,35,691,35]
[null,"2023-05-06",1,692,36,692,36]
[null,"2023-05-07",9,701,45,701,45]
[null,"2023-05-08",3,704,48,704,48]
[null,"2023-05-09",4,708,52,708,52]
[null,"2023-05-10",5,713,57,713,57]
[null,"2023-05-11",8,721,65,721,65]
[null,"2023-05-12",7,728,72,728,72]
[null,"2023-05-13",7,735,79,735,79]
[null,"2023-05-14",6,741,85,741,85]
[null,"2023-05-15",8,749,93,749,93]
[null,"2023-05-16",6,755,99,755,99]
[null,"2023-05-17",10,765,109,765,109]
[null,"2023-05-18",3,768,112,768,112]
[null,"2023-05-19",2,770,114,770,114]
[null,"2023-05-20",8,778,122,778,122]
[null,"2023-05-21",7,785,129,785,129]
[null,"2023-05-22",10,795,139,795,139]
[null,"2023-05-23",3,798,142,798,142]
[null,"2023-05-24",4,802,146,802,146]
[null,"2023-05-25",3,805,149,805,149]
[null,"2023-05-26",9,814,158,814,158]
[null,"2023-05-27",3,817,161,817,161]
[null,"2023-05-28",2,819,163,819,163]
[null,"2023-05-29",2,821,165,821,165]
[null,"2023-05-30",2,823,167,823,167]
[null,"2023-05-31",8,831,175,831,175]
[null,"2023-06-01",6,837,6,837,6]
[null,"2023-06-02",7,844,13,844,13]
[null,"2023-06-03",6,850,19,850,19]
[null,"2023-06-04",9,859,28,859,28]
[null,"2023-06-05",10,869,38,869,38]
[null,"2023-06-06",8,877,46,877,46]
[null,"2023-06-07",8,885,54,885,54]
[null,"2023-06-08",10,895,64,895,64]
[null,"2023-06-09",2,897,66,897,66]
[null,"2023-06-10",7,904,73,904,73]
[null,"2023-06-11",3,907,76,907,76]
[null,"2023-06-12",8,915,84,915,84]
[null,"2023-06-13",9,924,93,924,93]
[null,"2023-06-14",10,934,103,934,103]
[null,"2023-06-15",10,944,113,944,113]
[null,"2023-06-16",10,954,123,954,123]
[null,"2023-06-17",8,962,131,962,131]
[null,"2023-06-18",10,972,141,972,141]
[null,"2023-06-19",6,978,147,978,147]
[null,"2023-06-20",2,980,149,980,149]
[null,"2023-06-21",9,989,158,989,158]
[null,"2023-06-22",9,998,167,998,167]
[null,"2023-06-23",2,1000,169,1000,169]
[null,"2023-06-24",7,1007,176,1007,176]
[null,"2023-06-25",6,1013,182,1013,182]
[null,"2023-06-26",6,1019,188,1019,188]
[null,"2023-06-27",8,1027,196,1027,196]
[null,"2023-06-28",2,1029,198,1029,198]
[null,"2023-06-29",4,1033,202,1033,202]
[null,"2023-06-30",4,1037,206,1037,206]
[null,"2023-07-01",6,1043,6,1043,6]
[null,"2023-07-02",1,1044,7,1044,7]
[null,"2023-07-03",9,1053,16,1053,16]
[null,"2023-07-04",7,1060,23,1060,23]
[null,"2023-07-05",1,1061,24,1061,24]
[null,"2023-07-06",8,1069,32,1069,32]
[null,"2023-07-07",5,1074,37,1074,37]
[null,"2023-07-08",2,1076,39,1076,39]
[null,"2023-07-09",10,1086,49,1086,49]
[null,"2023-07-10",6,1092,55,1092,55]
[null,"2023-07-11",5,1097,60,1097,60]
[null,"2023-07-12",5,1102,65,1102,65]
[null,"2023-07-13",7,1109,72,1109,72]
[null,"2023-07-14",6,1115,78,1115,78]
[null,"2023-07-15",2,1117,80,1117,80]
[null,"2023-07-16",5,1122,85,1122,85]
[null,"2023-07-17",6,1128,91,1128,91]
[null,"2023-07-18",10,1138,101,1138,101]
[null,"2023-07-19",1,1139,102,1139,102]
[null,"2023-07-20",8,1147,110,1147,110]
[null,"2023-07-21",7,1154,117,1154,117]
[null,"2023-07-22",6,1160,123,1160,123]
[null,"2023-07-23",5,1165,128,1165,128]
[null,"2023-07-24",3,1168,131,1168,131]
[null,"2023-07-25",6,1174,137,1174,137]
[null,"2023-07-26",9,1183,146,1183,146]
[null,"2023-07-27",8,1191,154,1191,154]
[null,"2023-07-28",7,1198,161,1198,161]
[null,"2023-07-29",1,1199,162,1199,162]
[null,"2023-07-30",5,1204,167,1204,167]
[null,"2023-07-31",6,1210,173,1210,173]
[null,"2023-08-01",9,1219,9,1219,9]
[null,"2023-08-02",6,1225,15,1225,15]
[null,"2023-08-03",1,1226,16,1226,16]
[null,"2023-08-04",5,1231,21,1231,21]
[null,"2023-08-05",5,1236,26,1236,26]
[null,"2023-08-06",10,1246,36,1246,36]
[null,"2023-08-07",3,1249,39,1249,39]
[null,"2023-08-08",1,1250,40,1250,40]
[null,"2023-08-09",2,1252,42,1252,42]
[null,"2023-08-10",5,1257,47,1257,47]
[null,"2023-08-11",6,1263,53,1263,53]
[null,"2023-08-12",5,1268,58,1268,58]
[null,"2023-08-13",4,1272,62,1272,62]
[null,"2023-08-14",6,1278,68,1278,68]
[null,"2023-08-15",9,1287,77,1287,77]
[null,"2023-08-16",4,1291,81,1291,81]
[null,"2023-08-17",2,1293,83,1293,83]
[null,"2023-08-18",10,1303,93,1303,93]
[null,"2023-08-19",8,1311,101,1311,101]
[null,"2023-08-20",2,1313,103,1313,103]
[null,"2023-08-21",9,1322,112,1322,112]
[null,"2023-08-22",3,1325,115,1325,115]
[null,"2023-08-23",6,1331,121,1331,121]
[null,"2023-08-24",8,1339,129,1339,129]
[null,"2023-08-25",6,1345,135,1345,135]
[null,"2023-08-26",4,1349,139,1349,139]
[null,"2023-08-27",9,1358,148,1358,148]
[null,"2023-08-28",8,1366,156,1366,156]
[null,"2023-08-29",10,1376,166,1376,166]
[null,"2023-08-30",2,1378,168,1378,168]
[null,"2023-08-31",6,1384,174,1384,174]
[null,"2023-09-01",7,1391,7,1391,7]
[null,"2023-09-02",5,1396,12,1396,12]
[null,"2023-09-03",1,1397,13,1397,13]
[null,"2023-09-04",6,1403,19,1403,19]
[null,"2023-09-05",6,1409,25,1409,25]
[null,"2023-09-06",9,1418,34,1418,34]
[null,"2023-09-07",10,1428,44,1428,44]
[null,"2023-09-08",2,1430,46,1430,46]
[null,"2023-09-09",6,1436,52,1436,52]
[null,"2023-09-10",9,1445,61,1445,61]
[null,"2023-09-11",8,1453,69,1453,69]
[null,"2023-09-12",6,1459,75,1459,75]
[null,"2023-09-13",9,1468,84,1468,84]
[null,"2023-09-14",3,1471,87,1471,87]
[null,"2023-09-15",4,1475,91,1475,91]
[null,"2023-09-16",5,1480,96,1480,96]
[null,"2023-09-17",8,1488,104,1488,104]
[null,"2023-09-18",8,1496,112,1496,112]
[null,"2023-09-19",7,1503,119,1503,119]
[null,"2023-09-20",4,1507,123,1507,123]
[null,"2023-09-21",2,1509,125,1509,125]
[null,"2023-09-22",1,1510,126,1510,126]
[null,"2023-09-23",4,1514,130,1514,130]
[null,"2023-09-24",8,1522,138,1522,138]