{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["料金計算","設定"],"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":"料金計算","index":0,"n_rows":19,"n_cols":60,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,49,11,50],[9,41,9,42],[12,29,12,31],[13,29,13,31],[12,32,12,33],[13,32,13,33],[14,32,14,33],[11,53,11,54],[11,55,11,56],[7,49,7,50],[7,51,7,52],[7,53,7,54],[7,55,7,56],[8,49,8,50],[8,51,8,52],[8,53,8,54],[8,55,8,56],[9,49,9,50],[9,51,9,52],[9,53,9,54],[9,55,9,56],[10,49,10,50],[10,51,10,52],[10,53,10,54],[10,55,10,56],[6,55,6,56],[6,53,6,54],[6,51,6,52],[4,43,4,44],[8,41,8,42],[8,43,8,44],[4,53,4,54],[4,55,4,56],[5,49,5,50],[5,51,5,52],[5,53,5,54],[4,45,4,46],[4,47,4,48],[4,49,4,50],[4,51,4,52],[5,55,5,56],[6,49,6,50],[4,41,4,42],[4,35,4,36],[4,37,4,38],[5,33,5,34],[6,39,6,40],[4,27,4,28],[5,27,5,28],[6,27,6,28],[7,27,7,28],[4,31,4,32],[6,35,6,36],[6,37,6,38],[4,39,4,40],[5,35,5,36],[5,37,5,38],[4,29,4,30],[4,33,4,34],[7,18,7,19],[6,29,6,30],[7,29,7,30],[5,31,5,32],[6,31,6,32],[7,31,7,32],[13,13,13,14],[3,3,3,4],[3,5,3,6],[11,12,11,13],[11,9,11,11],[11,14,11,15],[12,14,12,15],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[11,6,11,7],[12,6,12,7],[6,15,6,17],[9,27,9,28],[11,27,11,28],[12,27,12,28],[8,27,8,28],[2,1,2,2],[2,3,2,6],[2,30,2,31],[2,11,2,12],[3,11,3,12],[4,21,4,23],[5,21,5,23],[2,27,2,29],[3,27,3,29],[2,15,2,16],[2,19,2,20],[2,21,2,23],[3,21,3,23],[3,30,3,31],[5,29,5,30],[5,11,5,12],[2,17,2,18],[3,17,3,18],[4,17,4,18],[5,17,5,18],[3,7,3,10],[4,7,4,10],[5,1,17,2],[15,6,15,7],[1,9,1,10],[5,6,5,7],[0,2,0,7],[2,7,2,10],[4,1,4,5],[13,6,13,7],[14,6,14,7],[6,6,6,7],[11,3,17,5],[16,10,16,13],[14,9,14,14],[12,9,12,11],[1,11,1,13],[0,8,0,9],[4,11,4,12],[13,9,13,12],[16,14,16,15],[5,3,10,5],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[0,0,0,1],[12,12,12,13],[16,6,16,7],[17,6,17,7],[7,47,7,48],[5,45,5,46],[5,47,5,48],[6,47,6,48],[9,39,9,40],[6,33,6,34],[7,33,7,34],[7,35,7,36],[7,37,7,38],[8,39,8,40],[7,39,7,40],[7,41,7,42],[5,39,5,40],[7,43,7,44],[9,43,9,44],[8,33,8,34],[5,41,5,42],[5,43,5,44],[6,41,6,42],[6,43,6,44],[6,45,6,46],[7,45,7,46],[8,29,8,30],[9,31,9,32],[11,57,11,58],[8,35,8,36],[8,37,8,38],[8,45,8,46],[8,47,8,48],[9,35,9,36],[9,37,9,38],[9,45,9,46],[9,47,9,48],[10,35,10,36],[10,37,10,38],[10,45,10,46],[10,47,10,48],[11,35,11,36],[11,37,11,38],[11,45,11,46],[11,47,11,48],[11,39,11,40],[11,41,11,42],[11,51,11,52],[11,43,11,44],[10,41,10,42],[10,39,10,40],[10,43,10,44],[1,1,1,6],[15,9,15,14],[11,31,11,32],[10,29,10,30],[11,29,11,30],[11,33,11,34],[10,11,10,12],[5,9,10,10],[6,20,6,21],[8,20,8,21],[9,20,9,21],[6,18,6,19],[8,18,8,19],[9,18,9,19],[10,31,10,32],[10,33,10,34],[8,15,8,17],[9,15,9,17],[10,27,10,28],[9,33,9,34],[9,29,9,30],[8,31,8,32]]}
["0.4.2",null,"まねき料金計算シート",null,null,null,null,null,"by nobu",null,null,"※値はすべて税込"]
[null,"宇多津浜街道店",null,null,null,null,null,null,null,"人数",null,2,null,null,null,"計算結果",null,null,null,null,null,null,null,null,null,null,null,"自動計算エリア"]
[null,"室料",null,0,null,null,null,"ワンドリンク",null,null,null,420,null,false,null,"ランク",null,{"$f":"_xlfn.IFS(ISNUMBER(FIND(\"6\",Y3)),\"0%\",ISNUMBER(FIND(7,Y3)),\"5%\",ISNUMBER(FIND(\"8\",Y3)),\"10%\",ISNUMBER(FIND(\"9\",Y3)),\"15%\",ISNUMBER(FIND(\"10\",Y3)),\"20%\",ISNUMBER(FIND(\"11\",Y3)),\"30%\")","v":"20%"},null,"クーポン",null,{"$f":"_xlfn.IFS(\n  ISNUMBER(FIND(\"AD\",Y3)),\"なし\",\n  ISNUMBER(FIND(\"AF\",Y3)),\"ゲーム100円\",\n  ISNUMBER(FIND(\"AH\",Y3)),\"ゲーム500円\",\n  ISNUMBER(FIND(\"AJ\",Y3)),\"ゲーム1000円\",\n  ISNUMBER(FIND(\"AL\",Y3)),\"ゲーム2000円\",\n  ISNUMBER(FIND(\"AN\",Y3)),\"ゲーム3000円\",\n  ISNUMBER(FIND(\"AP\",Y3)),\"ゲーム4000円\",\n  ISNUMBER(FIND(\"AR\",Y3)),\"ゲーム5000円\",\n  ISNUMBER(FIND(\"AT\",Y3)),\"500円\",\n  ISNUMBER(FIND(\"AV\",Y3)),\"1000円\",\n  ISNUMBER(FIND(\"AX\",Y3)),\"2000円\",\n  ISNUMBER(FIND(\"AZ\",Y3)),\"3000円\",\n  ISNUMBER(FIND(\"BB\",Y3)),\"4000円\",\n  ISNUMBER(FIND(\"BD\",Y3)),\"5000円\"\n)","v":"なし"},null,null,{"$f":"_xlfn.TEXTSPLIT(BH12,,\",\")","v":"AD10"},null,null,"1人当たり",null,null,{"$f":"D3*IF(C4,1,D4*2+F4/30)+IF(AND(NOT(G5),N3),L3)+IF(AND(NOT(G5),N4),L4)+IF(N5,L5)+IF(P14,N14)","v":495},null,{"$f":"IF(C4,1,D4*2+F4/30)","v":1}]
[null,"FT",true,1,null,0,null,"ドリンクバー",null,null,null,495,null,true,null,null,null,{"$f":"_xlfn.IFS(ISNUMBER(FIND(\"6\",Y4)),\"0%\",ISNUMBER(FIND(7,Y4)),\"5%\",ISNUMBER(FIND(\"8\",Y4)),\"10%\",ISNUMBER(FIND(\"9\",Y4)),\"15%\",ISNUMBER(FIND(\"10\",Y4)),\"20%\",ISNUMBER(FIND(\"11\",Y4)),\"30%\",TRUE,\"\")","v":""},null,null,null,{"$f":"_xlfn.IFS(\n  ISNUMBER(FIND(\"AD\",Y4)),\"なし\",\n  ISNUMBER(FIND(\"AF\",Y4)),\"ゲーム100円\",\n  ISNUMBER(FIND(\"AH\",Y4)),\"ゲーム500円\",\n  ISNUMBER(FIND(\"AJ\",Y4)),\"ゲーム1000円\",\n  ISNUMBER(FIND(\"AL\",Y4)),\"ゲーム2000円\",\n  ISNUMBER(FIND(\"AN\",Y4)),\"ゲーム3000円\",\n  ISNUMBER(FIND(\"AP\",Y4)),\"ゲーム4000円\",\n  ISNUMBER(FIND(\"AR\",Y4)),\"ゲーム5000円\",\n  ISNUMBER(FIND(\"AT\",Y4)),\"500円\",\n  ISNUMBER(FIND(\"AV\",Y4)),\"1000円\",\n  ISNUMBER(FIND(\"AX\",Y4)),\"2000円\",\n  ISNUMBER(FIND(\"AZ\",Y4)),\"3000円\",\n  ISNUMBER(FIND(\"BB\",Y4)),\"4000円\",\n  ISNUMBER(FIND(\"BD\",Y4)),\"5000円\",\n  TRUE,\"\"\n)","v":""},null,null,null,null,null,"会計全体",null,null,{"$f":"AE3*L2+O17","v":990}]
[null,"室料にDB付帯",null,null,null,null,false," +ソフトクリーム",null,null,null,110,null,false,null,null,null,{"$f":"_xlfn.IFS(ISNUMBER(FIND(\"6\",Y5)),\"0%\",ISNUMBER(FIND(7,Y5)),\"5%\",ISNUMBER(FIND(\"8\",Y5)),\"10%\",ISNUMBER(FIND(\"9\",Y5)),\"15%\",ISNUMBER(FIND(\"10\",Y5)),\"20%\",ISNUMBER(FIND(\"11\",Y5)),\"30%\",TRUE,\"\")","v":""},null,null,null,{"$f":"_xlfn.IFS(\n  ISNUMBER(FIND(\"AD\",Y5)),\"なし\",\n  ISNUMBER(FIND(\"AF\",Y5)),\"ゲーム100円\",\n  ISNUMBER(FIND(\"AH\",Y5)),\"ゲーム500円\",\n  ISNUMBER(FIND(\"AJ\",Y5)),\"ゲーム1000円\",\n  ISNUMBER(FIND(\"AL\",Y5)),\"ゲーム2000円\",\n  ISNUMBER(FIND(\"AN\",Y5)),\"ゲーム3000円\",\n  ISNUMBER(FIND(\"AP\",Y5)),\"ゲーム4000円\",\n  ISNUMBER(FIND(\"AR\",Y5)),\"ゲーム5000円\",\n  ISNUMBER(FIND(\"AT\",Y5)),\"500円\",\n  ISNUMBER(FIND(\"AV\",Y5)),\"1000円\",\n  ISNUMBER(FIND(\"AX\",Y5)),\"2000円\",\n  ISNUMBER(FIND(\"AZ\",Y5)),\"3000円\",\n  ISNUMBER(FIND(\"BB\",Y5)),\"4000円\",\n  ISNUMBER(FIND(\"BD\",Y5)),\"5000円\",\n  TRUE,\"\"\n)","v":""},null,null,null,null,null,"クーポン",null,"なし",null,100,null,500,null,1000,null,2000,null,3000,null,4000,null,5000,null,500,null,1000,null,2000,null,3000,null,4000,null,5000]
[null,"クーポン",null,"通常",null,null,"500円",null,false,"ランク",null,0,null,false,null,null,null,{"$f":"_xlfn.IFS(ISNUMBER(FIND(\"6\",Y6)),\"0%\",ISNUMBER(FIND(7,Y6)),\"5%\",ISNUMBER(FIND(\"8\",Y6)),\"10%\",ISNUMBER(FIND(\"9\",Y6)),\"15%\",ISNUMBER(FIND(\"10\",Y6)),\"20%\",ISNUMBER(FIND(\"11\",Y6)),\"30%\",TRUE,\"\")","v":""},null,null,null,{"$f":"_xlfn.IFS(\n  ISNUMBER(FIND(\"AD\",Y6)),\"なし\",\n  ISNUMBER(FIND(\"AF\",Y6)),\"ゲーム100円\",\n  ISNUMBER(FIND(\"AH\",Y6)),\"ゲーム500円\",\n  ISNUMBER(FIND(\"AJ\",Y6)),\"ゲーム1000円\",\n  ISNUMBER(FIND(\"AL\",Y6)),\"ゲーム2000円\",\n  ISNUMBER(FIND(\"AN\",Y6)),\"ゲーム3000円\",\n  ISNUMBER(FIND(\"AP\",Y6)),\"ゲーム4000円\",\n  ISNUMBER(FIND(\"AR\",Y6)),\"ゲーム5000円\",\n  ISNUMBER(FIND(\"AT\",Y6)),\"500円\",\n  ISNUMBER(FIND(\"AV\",Y6)),\"1000円\",\n  ISNUMBER(FIND(\"AX\",Y6)),\"2000円\",\n  ISNUMBER(FIND(\"AZ\",Y6)),\"3000円\",\n  ISNUMBER(FIND(\"BB\",Y6)),\"4000円\",\n  ISNUMBER(FIND(\"BD\",Y6)),\"5000円\",\n  TRUE,\"\"\n)","v":""},null,null,null,null,null,0,null,{"$f":"IF(N6,AE4*1)","v":false},null,{"$f":"IF(AND(I12,AD6>=AF5*2,AD6),AD6-AF5)","v":false},null,{"$f":"IF(AND(I13,AD6>=AH5*2,AD6),AD6-AH5)","v":false},null,{"$f":"IF(AND(I14,AD6>=AJ5*2,AD6),AD6-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD6>=AL5*2,AD6),AD6-AL5)","v":false},null,{"$f":"IF(AND(I16,AD6>=AN5*2,AD6),AD6-AN5)","v":false},null,{"$f":"IF(AND(I17,AD6>=AP5*2,AD6),AD6-AP5)","v":false},null,{"$f":"IF(AND(I18,AD6>=AR5*2,AD6),AD6-AR5)","v":false},null,{"$f":"IF(AND(I6,AD6),AD6-AT5)","v":false},null,{"$f":"IF(AND(I7,AD6),AD6-AV5)","v":false},null,{"$f":"IF(AND(I8,AD6),AD6-AX5)","v":false},null,{"$f":"IF(AND(I9,AD6),AD6-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD6),AD6-BB5)","v":false},null,{"$f":"IF(AND(I11,AD6),AD6-BD5)","v":false}]
[null,null,null,null,null,null,"1000円",null,false,null,null,0.05,null,false,null,"株主優待券を",null,null,{"$f":"IF(\n   設定!K4,\n   IF(\n      AND(J13,AI13+AG14>0,AI13+AG14<=O13),\n      AI13+AG14,\n      \"使わない\"\n   ),\n   IF(\n      AND(J13,BF12>1000,INT(BF12/1000)<=O13),\n      INT(BF12/1000),\n      \"使わない\"\n   )\n)","v":1},null,{"$f":"IF(AND(J13,BF12>1000,INT(BF12/1000)<=O13),\"枚使う\",\"\")","v":""},null,null,null,null,null,null,0.05,null,{"$f":"IF(N7,AE4*0.95)","v":false},null,{"$f":"IF(AND(I12,AD7>=AF5*2,AD7),AD7-AF5)","v":false},null,{"$f":"IF(AND(I13,AD7>=AH5*2,AD7),AD7-AH5)","v":false},null,{"$f":"IF(AND(I14,AD7>=AJ5*2,AD7),AD7-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD7>=AL5*2,AD7),AD7-AL5)","v":false},null,{"$f":"IF(AND(I16,AD7>=AN5*2,AD7),AD7-AN5)","v":false},null,{"$f":"IF(AND(I17,AD7>=AP5*2,AD7),AD7-AP5)","v":false},null,{"$f":"IF(AND(I18,AD7>=AR5*2,AD7),AD7-AR5)","v":false},null,{"$f":"IF(AND(I6,AD7),AD7-AT5)","v":false},null,{"$f":"IF(AND(I7,AD7),AD7-AV5)","v":false},null,{"$f":"IF(AND(I8,AD7),AD7-AX5)","v":false},null,{"$f":"IF(AND(I9,AD7),AD7-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD7),AD7-BB5)","v":false},null,{"$f":"IF(AND(I11,AD7),AD7-BD5)","v":false}]
[null,null,null,null,null,null,"2000円",null,false,null,null,0.1,null,false,null,null,null,"(",{"$f":"IF(\n   設定!K4,\n   IF(\n      AND(J13,AI13+AG14>0,AI13+AG14<=O13),\n      AI13*(1000-O12)+AG14*(AG13-O12),\n   ),\n   IF(\n      AB13,\n      (1000-O12)*INT(BF12/1000),\n      0\n   )\n)","v":67},null,"円引き)",null,null,null,null,null,null,0.1,null,{"$f":"IF(N8,AE4*0.9)","v":false},null,{"$f":"IF(AND(I12,AD8>=AF5*2,AD8),AD8-AF5)","v":false},null,{"$f":"IF(AND(I13,AD8>=AH5*2,AD8),AD8-AH5)","v":false},null,{"$f":"IF(AND(I14,AD8>=AJ5*2,AD8),AD8-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD8>=AL5*2,AD8),AD8-AL5)","v":false},null,{"$f":"IF(AND(I16,AD8>=AN5*2,AD8),AD8-AN5)","v":false},null,{"$f":"IF(AND(I17,AD8>=AP5*2,AD8),AD8-AP5)","v":false},null,{"$f":"IF(AND(I18,AD8>=AR5*2,AD8),AD8-AR5)","v":false},null,{"$f":"IF(AND(I6,AD8),AD8-AT5)","v":false},null,{"$f":"IF(AND(I7,AD8),AD8-AV5)","v":false},null,{"$f":"IF(AND(I8,AD8),AD8-AX5)","v":false},null,{"$f":"IF(AND(I9,AD8),AD8-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD8),AD8-BB5)","v":false},null,{"$f":"IF(AND(I11,AD8),AD8-BD5)","v":false}]
[null,null,null,null,null,null,"3000円",null,false,null,null,0.15,null,false,null,"会計全体",null,null,{"$f":"IF(AB13,AB13,BF12)","v":725},null,{"$f":"BF12","v":792},null,"←会計時に出す金額",null,null,null,null,0.15,null,{"$f":"IF(N9,AE4*0.85)","v":false},null,{"$f":"IF(AND(I12,AD9>=AF5*2,AD9),AD9-AF5)","v":false},null,{"$f":"IF(AND(I13,AD9>=AH5*2,AD9),AD9-AH5)","v":false},null,{"$f":"IF(AND(I14,AD9>=AJ5*2,AD9),AD9-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD9>=AL5*2,AD9),AD9-AL5)","v":false},null,{"$f":"IF(AND(I16,AD9>=AN5*2,AD9),AD9-AN5)","v":false},null,{"$f":"IF(AND(I17,AD9>=AP5*2,AD9),AD9-AP5)","v":false},null,{"$f":"IF(AND(I18,AD9>=AR5*2,AD9),AD9-AR5)","v":false},null,{"$f":"IF(AND(I6,AD9),AD9-AT5)","v":false},null,{"$f":"IF(AND(I7,AD9),AD9-AV5)","v":false},null,{"$f":"IF(AND(I8,AD9),AD9-AX5)","v":false},null,{"$f":"IF(AND(I9,AD9),AD9-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD9),AD9-BB5)","v":false},null,{"$f":"IF(AND(I11,AD9),AD9-BD5)","v":false}]
[null,null,null,null,null,null,"4000円",null,false,null,null,0.2,null,true,null,"1人当たり",null,null,{"$f":"CEILING(S9/L2,1)","v":363},null,{"$f":"U9/L2","v":396},null,null,null,null,null,null,0.2,null,{"$f":"IF(N10,AE4*0.8)","v":792},null,{"$f":"IF(AND(I12,AD10>=AF5*2,AD10),AD10-AF5)","v":false},null,{"$f":"IF(AND(I13,AD10>=AH5*2,AD10),AD10-AH5)","v":false},null,{"$f":"IF(AND(I14,AD10>=AJ5*2,AD10),AD10-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD10>=AL5*2,AD10),AD10-AL5)","v":false},null,{"$f":"IF(AND(I16,AD10>=AN5*2,AD10),AD10-AN5)","v":false},null,{"$f":"IF(AND(I17,AD10>=AP5*2,AD10),AD10-AP5)","v":false},null,{"$f":"IF(AND(I18,AD10>=AR5*2,AD10),AD10-AR5)","v":false},null,{"$f":"IF(AND(I6,AD10),AD10-AT5)","v":false},null,{"$f":"IF(AND(I7,AD10),AD10-AV5)","v":false},null,{"$f":"IF(AND(I8,AD10),AD10-AX5)","v":false},null,{"$f":"IF(AND(I9,AD10),AD10-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD10),AD10-BB5)","v":false},null,{"$f":"IF(AND(I11,AD10),AD10-BD5)","v":false}]
[null,null,null,null,null,null,"5000円",null,false,null,null,0.3,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,{"$f":"IF(N11,AE4*0.7)","v":false},null,{"$f":"IF(AND(I12,AD11>=AF5*2,AD11),AD11-AF5)","v":false},null,{"$f":"IF(AND(I13,AD11>=AH5*2,AD11),AD11-AH5)","v":false},null,{"$f":"IF(AND(I14,AD11>=AJ5*2,AD11),AD11-AJ5)","v":false},null,{"$f":"IF(AND(I15,AD11>=AL5*2,AD11),AD11-AL5)","v":false},null,{"$f":"IF(AND(I16,AD11>=AN5*2,AD11),AD11-AN5)","v":false},null,{"$f":"IF(AND(I17,AD11>=AP5*2,AD11),AD11-AP5)","v":false},null,{"$f":"IF(AND(I18,AD11>=AR5*2,AD11),AD11-AR5)","v":false},null,{"$f":"IF(AND(I6,AD11),AD11-AT5)","v":false},null,{"$f":"IF(AND(I7,AD11),AD11-AV5)","v":false},null,{"$f":"IF(AND(I8,AD11),AD11-AX5)","v":false},null,{"$f":"IF(AND(I9,AD11),AD11-AZ5)","v":false},null,{"$f":"IF(AND(I10,AD11),AD11-BB5)","v":false},null,{"$f":"IF(AND(I11,AD11),AD11-BD5)","v":false}]
[null,null,null,"ゲーム",null,null,"100円",null,false,"株主優待券",null,null,"仕入れ値",null,725,null,null,null,null,null,null,null,null,null,null,null,null,"MIN",null,{"$f":"IF(MIN(AD6:AD11)<>0,MIN(AD6:AD11))","v":792},null,{"$f":"IF(MIN(AF6:AF11)<>0,MIN(AF6:AF11))","v":false},null,{"$f":"IF(MIN(AH6:AH11)<>0,MIN(AH6:AH11))","v":false},null,{"$f":"IF(MIN(AJ6:AJ11)<>0,MIN(AJ6:AJ11))","v":false},null,{"$f":"IF(MIN(AL6:AL11)<>0,MIN(AL6:AL11))","v":false},null,false,null,{"$f":"IF(MIN(AP6:AP11)<>0,MIN(AP6:AP11))","v":false},null,false,null,{"$f":"IF(MIN(AT6:AT11)<>0,MIN(AT6:AT11))","v":false},null,{"$f":"IF(MIN(AV6:AV11)<>0,MIN(AV6:AV11))","v":false},null,false,null,false,null,{"$f":"IF(MIN(BB6:BB11)<>0,MIN(BB6:BB11))","v":false},null,false,null,{"$f":"IF(MIN(AD12:BE12)<>0,MIN(AD12:BE12))","v":792},null,{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF(AD6:BE11=BF12, ADDRESS(ROW(AD6:BE11), COLUMN(AD6:BE11), 4), \"\"))","v":"AD10"}]
[null,null,null,null,null,null,"500円",null,false,true,null,null,"枚数",null,10,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(\n  設定!K4,\n  IF(\n    AND(J13,AI13+AG14>0,AI13+AG14<=O13),\n    (AI13+AG14)*O12+AG15,\n  ),\n  IF(\n    AND(J13,BF12>1000,INT(BF12/1000)<=O13),\n    BF12 - ((1000 - O12) * INT(BF12/1000)),\n    BF12\n  )\n)","v":725},null,"BF%1000",null,null,{"$f":"ROUNDUP(MOD(BF12,1000),0)","v":792},null,{"$f":"INT(BF12/1000)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTSPLIT(BH12,\",\")","v":"AD10"}]
[null,null,null,null,null,null,"1000円",null,false,"ポテト食べ放題",null,null,null,{"$f":"IF(P15,\"500\",\"810\")","v":"500"},null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,"AG13/O12",null,null,{"$f":"INT(AG13/O12)","v":1}]
[null,null,null,null,null,null,"2000円",null,false,"期間限定価格",null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG14=1,0,AG13)","v":0}]
[null,null,null,null,null,null,"3000円",null,false,"(2025/12/1~2025/1/12)"]
[null,null,null,null,null,null,"4000円",null,false,null,"カスタム金額",null,null,null,0,null,"←計算時に値を確認！"]
[null,null,null,null,null,null,"5000円",null,false,null,"※ワンドリンク時にまねちゅ～でフードを注文した場合、"]
[null,null,null,null,null,null,null,null,null,null,"　上のワンドリンクのチェックを外し、カスタム金額に飲食代合計を入れると便利です。"]

{"sheet":"設定","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,7],[2,1,2,9],[7,3,7,8],[3,1,3,9],[4,1,4,9],[5,2,5,9]]}
[{"$f":"料金計算!A1","v":"0.4.2"},null,null,"アプリケーション設定"]
[]
[null,"起動時のアップデート確認",null,null,null,null,null,null,null,null,true]
[null,"優待を1000円未満仕入れ値以上で使用",null,null,null,null,null,null,null,null,true]
[null,"F4に数値を入力した時何時間何分に変換",null,null,null,null,null,null,null,null,true]
[null,null,"自動的に30分ずつに切り上げ",null,null,null,null,null,null,null,true]
[]
["Webサイト：",null,null,"https://app.n624.jp/mnk/"]
["メール：",null,"admin@n624.jp"]