{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["需要申請書","リスト","算出補助表"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,6,0,26],[2,4,2,5],[10,0,10,26],[11,0,11,26],[7,9,8,13],[4,9,4,13],[5,9,5,13],[7,0,8,8],[5,7,5,8],[5,0,5,6],[4,0,4,8],[6,0,6,8],[6,9,6,13],[2,6,2,7],[2,9,2,12],[14,0,15,0],[14,1,15,2],[14,3,14,4],[14,5,14,7],[14,8,14,17],[14,18,14,21],[13,0,13,26],[6,19,6,21],[6,22,6,23],[7,19,8,21],[7,22,8,23],[8,17,8,18],[6,24,6,26],[7,24,8,26],[6,14,6,18],[14,22,15,26],[15,3,15,4],[15,5,15,7],[15,18,15,21],[16,1,16,2],[16,5,16,6],[16,18,16,20],[16,22,18,26],[17,1,17,2],[17,3,21,4],[17,18,17,20],[18,1,18,2],[18,5,18,6],[18,18,18,20],[23,18,23,21],[23,22,23,24],[23,25,23,26],[25,0,25,26],[26,0,26,26],[19,22,19,26],[20,1,20,2],[20,5,20,6],[20,18,20,20],[20,22,20,26],[21,1,21,2],[21,5,21,6],[21,18,21,20],[21,25,21,26],[19,0,21,0],[19,1,19,2],[19,5,19,6],[19,18,19,20],[32,20,34,22],[32,23,34,26],[34,1,34,4],[27,0,27,26],[29,0,29,26],[30,1,30,4],[30,5,30,7],[30,16,30,17],[30,18,30,26],[37,20,37,22],[37,23,37,26],[38,0,40,0],[38,1,38,4],[38,5,38,7],[38,18,38,26],[39,18,39,26],[40,1,40,4],[34,5,34,7],[35,0,37,0],[35,1,35,4],[35,5,35,7],[35,18,35,19],[35,20,35,26],[36,1,36,4],[36,5,36,7],[36,18,37,19],[36,20,36,26],[31,0,34,0],[31,1,31,4],[31,5,31,7],[31,18,34,19],[31,20,31,26],[32,1,32,4],[42,20,42,26],[43,2,43,4],[43,5,43,7],[43,20,48,22],[43,23,48,26],[44,2,44,4],[44,5,44,7],[40,5,40,7],[40,18,40,26],[41,1,41,4],[41,5,41,7],[41,18,41,26],[42,1,44,1],[42,2,42,4],[42,5,42,7],[42,18,48,19],[52,11,52,12],[52,13,52,14],[46,1,48,1],[46,2,46,4],[46,5,46,7],[47,2,47,4],[47,5,47,7],[48,2,48,4],[48,5,48,7],[52,9,52,10],[42,0,48,0],[37,1,37,4],[37,5,37,7],[32,5,32,7],[23,0,23,7],[17,5,17,6],[58,1,58,2],[59,1,59,2],[53,1,53,2],[53,4,53,6],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[51,4,51,7],[52,4,52,6],[52,7,52,8]]}
[null,null,null,null,null,null,"青色で囲んだ箇所は直接入力、赤色で囲んだ箇所はリストから選択となります。"]
[]
[null,null,null,"令和",null,null,"年度",null,null,null,null,null,null,null,"学校給食用物資需要申請書"]
[]
["所管教育委員会",null,null,null,null,null,null,null,null,"事務担当者名"]
[null,null,null,null,null,null,null,"㊞"]
["学校及び調理場名",null,null,null,null,null,null,null,null,"事務担当者名",null,null,null,null,"給食実施型",null,null,null,null,"児童生徒数",null,null,"教職員数",null,"計"]
[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":"SUM(T8:X9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"週",null,"回"]
[]
["（注1）給食実施型で完全給食は（パン、ミルク、おかず）補食給食は（ミルク・おかず または パン・ミルク）であり、該当するもの、週の実施回数をリストから選択する。"]
["（注2）教職員数とは教員及び職員の数とし、職員とは学校給食に従事する者をいう。"]
[]
["　　　学校給食用小麦粉及び米穀類需要量"]
["品名","摘要",null,"㋑",null,"㋺　　　　（注3)",null,null,"給食実施回数",null,null,null,null,null,null,null,null,null,"（注4）",null,null,null,"備　考"]
[null,null,null,"給食実施\n人員",null,"1人1回当り\n基準量",null,null,{"$f":"IF($J$3=\"\",\"\",IF($J$3=\"第１学期分\",4,IF($J$3=\"第２学期分\",9,IF($J$3=\"第３学期分\",1,8))))","v":""},"月",{"$f":"IF($J$3=\"\",\"\",IF($J$3=\"第１学期分\",5,IF($J$3=\"第２学期分\",10,IF($J$3=\"第３学期分\",2,0))))","v":""},"月",{"$f":"IF($J$3=\"\",\"\",IF($J$3=\"第１学期分\",6,IF($J$3=\"第２学期分\",11,IF($J$3=\"第３学期分\",3,0))))","v":""},"月",{"$f":"IF($J$3=\"\",\"\",IF($J$3=\"第１学期分\",7,IF($J$3=\"第２学期分\",12,0)))","v":""},"月","㋩","計","需用量\n㋑×㋺×㋩"]
["小麦粉","パン",null,null,"人",null,null,"g",null,"回",null,"回",null,"回",null,"回",{"$f":"IF(AND(I17=\"\",K17=\"\",M17=\"\",O17=\"\"),0,I17+K17+M17+O17)","v":0},"回",{"$f":"IF(Q17=\"\",\"\",ROUNDUP($D$17*F17*Q17/1000,0))","v":0},null,null,"kg"]
["県産麦","県産麦\nパン",null,null,null,null,null,"g",null,"回",null,"回",null,"回",null,"回",0,"回",{"$f":"IF(Q18=\"\",\"\",ROUNDUP($D$17*F18*Q18/1000,0))","v":0},null,null,"kg"]
["米粉","米粉パン",null,null,null,null,null,"g",null,"回",null,"回",null,"回",null,"回",0,"回",{"$f":"IF(Q19=\"\",\"\",ROUNDUP($D$17*F19*Q19*0.7/1000,0))","v":0},null,null,"kg"]
["米穀用","精米",null,null,null,null,null,"g",null,"回",null,"回",null,"回",null,"回",0,"回",{"$f":"IF(Q20=\"\",\"\",ROUNDUP($D$17*F20*Q20/1000,0))","v":0},null,null,"kg"]
[null,"アルファ化米",null,null,null,null,null,"g",null,"回",null,"回",null,"回",null,"回",0,"回",{"$f":"IF(Q21=\"\",\"\",ROUNDUP($D$17*F21*Q21/1000,0))","v":0},null,null,"kg","米飯給食実施回数"]
[null,"アルファ化\n赤飯",null,null,null,null,null,"g",null,"回",null,"回",null,"回",null,"回",0,"回",{"$f":"IF(Q22=\"\",\"\",ROUNDUP($D$17*F22*Q22/1000,0))","v":0},null,null,"kg",null,null,null,"回実施"]
[]
["計",null,null,null,null,null,null,null,{"$f":"IF(AND(I17=\"\",I18=\"\",I19=\"\",I20=\"\",I21=\"\",I22=\"\"),0,I17+I18+I19+I20+I21+I22)","v":0},"回",{"$f":"IF(AND(K17=\"\",K18=\"\",K19=\"\",K20=\"\",K21=\"\",K22=\"\"),0,K17+K18+K19+K20+K21+K22)","v":0},"回",{"$f":"IF(AND(M17=\"\",M18=\"\",M19=\"\",M20=\"\",M21=\"\",M22=\"\"),0,M17+M18+M19+M20+M21+M22)","v":0},"回",{"$f":"IF(AND(O17=\"\",O18=\"\",O19=\"\",O20=\"\",O21=\"\",O22=\"\"),0,O17+O18+O19+O20+O21+O22)","v":0},"回",{"$f":"IF(AND(I24=\"\",K24=\"\",M24=\"\",O24=\"\"),0,I24+K24+M24+O24)","v":0},"回",null,null,null,null,"学期中の変更予定"]
[]
["（注3）「㋺1人1回当り基準量」は使用回数の最も多いものとし、学年差をつけている場合はその平均値とする。"]
["（注4）「需要量」は㋑×㋺×㋩とし、kg以下は切り上げる。「米粉パン」については㋑×㋺×㋩×0.7で算出する。"]
["（注5）学期中に米飯実施回数の変更（予定）のある場合はリストから選択する。"]
[]
["　　　月別学校給食用物資需要申込書"]
["品目","品名",null,null,null,"単位",null,null,{"$f":"I16","v":""},"月",{"$f":"K16","v":""},"月",{"$f":"M16","v":""},"月",{"$f":"O16","v":""},"月","計",null,"備考"]
["精米","自校炊飯用一般精米",null,null,null,"１０ｋｇ",null,null,null,"袋",null,"袋",null,"袋",null,"袋",{"$f":"IF(AND(I32=\"\",K32=\"\",M32=\"\",O32=\"\"),\"\",I32+K32+M32+O32)","v":""},"袋","福岡県産",null,"委託炊飯用は炊飯工場\nに直接納品します"]
[null,"自校炊飯用無洗米",null,null,null,"１０ｋｇ",null,null,null,"袋",null,"袋",null,"袋",null,"袋",{"$f":"IF(AND(I33=\"\",K33=\"\",M33=\"\",O33=\"\"),\"\",I33+K33+M33+O33)","v":""},"袋",null,null,"炊飯方式"]
[]
[null,"委託炊飯用精米",null,null,null,"１０ｋｇ",null,null,null,"袋",null,"袋",null,"袋",null,"袋",{"$f":"IF(AND(I35=\"\",K35=\"\",M35=\"\",O35=\"\"),\"\",I35+K35+M35+O35)","v":""},"袋"]
["アルファ化米","アルファ化米",null,null,null,"１０ｋｇ",null,null,null,"袋",null,"袋",null,"袋",null,"袋","","袋","福岡県産"]
[null,"自校炊飯用赤飯",null,null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ","国内産",null,"委託炊飯用は炊飯工場\nに直接納品します"]
[null,"委託炊飯用赤飯",null,null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ",null,null,"炊飯方式"]
["乾めん類","乾めん",null,null,null,"５ｋｇ",null,null,null,"箱",null,"箱",null,"箱",null,"箱",{"$f":"IF(AND(I39=\"\",K39=\"\",M39=\"\",O39=\"\"),\"\",I39+K39+M39+O39)","v":""},"箱"]
[]
[null,"中華めん",null,null,null,"５ｋｇ",null,null,null,"箱",null,"箱",null,"箱",null,"箱","","箱"]
["脱脂\n粉乳","脱脂粉乳",null,null,null,"１ｋｇ",null,null,null,"箱",null,"箱",null,"箱",null,"箱","","箱"]
["精麦類","自校炊飯","押麦（サンバーレ）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ","福岡県産",null,"委託炊飯用は炊飯工場\nに直接納品します"]
[null,null,"白麦（太陽麦）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ",null,null,"炊飯方式"]
[null,null,"丸麦（サンライス）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ"]
[]
[null,"委託炊飯","押麦（サンバーレ）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ"]
[null,null,"白麦（太陽麦）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ"]
[null,null,"丸麦（サンライス）",null,null,"１ｋｇ",null,null,null,"ｋｇ",null,"ｋｇ",null,"ｋｇ",null,"ｋｇ","","ｋｇ"]

{"sheet":"リスト","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,"1.　学期選択","2-1.給食実施型","2-2.給食実施型\n（回数）","4-1.米飯給食実施回数\n（週・月）","4-2.米飯給食実施回数\n（回数）","5.　学期中の変更予定","6-1.炊飯方式\n（精米）","6-2.炊飯方式\n（α化米）","6-3.炊飯方式\n（精麦）","７.　算出補助表\n　　学期選択"]
[null,"第１学期分","完全",1,"週",1,"有り","自校","自校","自校","第１学期分"]
[null,"第２学期分","補食",2,"月",2,"無し","委託","委託","委託","第２学期分"]
[null,"第３学期分",null,3,null,3,null,null,null,"委託炊飯、自校調理用","第３学期分"]
[null,"８月分",null,4,null,4,null,null,null,null,"８月分"]
[null,null,null,5,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]

{"sheet":"算出補助表","index":2,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[13,12,13,14],[14,12,14,14],[15,12,15,14],[19,1,19,6],[7,8,7,10],[8,8,8,10],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[7,12,7,14],[8,12,8,14],[9,12,9,14],[10,12,10,14],[11,12,11,14],[12,12,12,14],[0,0,1,3],[4,0,4,6],[5,3,5,6],[6,8,6,14],[1,4,1,6],[0,4,0,6],[19,10,19,14],[20,0,23,0],[20,8,24,8],[44,0,47,0],[44,8,47,8],[37,2,37,6],[37,10,37,14],[38,0,41,0],[38,8,42,8],[26,0,29,0],[26,8,29,8],[31,2,31,6],[31,10,31,14],[32,0,35,0],[32,8,35,8],[50,0,53,0],[50,8,54,8],[43,2,43,6],[43,10,43,14],[25,2,25,6],[25,10,25,14]]}
["算出補助表",null,null,null,"学期選択（リストから選択）"]
[]
["　需要申込量算出に必要な場合はご使用ください。"]
[]
["基準値等入力欄"]
[null,null,null,"実施回数"]
[null,"実施人員","基準量",{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""}]
["精米",null,{"$f":"需要申請書!F20","v":0},{"$f":"需要申請書!I20","v":0},{"$f":"需要申請書!K20","v":0},{"$f":"需要申請書!M20","v":0},{"$f":"需要申請書!O20","v":0}]
["アルファ化米",null,{"$f":"需要申請書!F21","v":0},{"$f":"需要申請書!I21","v":0},{"$f":"需要申請書!K21","v":0},{"$f":"需要申請書!M21","v":0},{"$f":"需要申請書!O21","v":0},null,"　　　実施人員のみ入力"]
["赤飯",null,{"$f":"需要申請書!F22","v":0},{"$f":"需要申請書!I22","v":0},{"$f":"需要申請書!K22","v":0},{"$f":"需要申請書!M22","v":0},{"$f":"需要申請書!O22","v":0}]
["乾めん"]
["中華めん"]
["脱脂粉乳",null,null,null,null,null,null,null,"　　　全ての項目に入力"]
["押麦"]
["白麦"]
["丸麦"]
[]
["※　下記表は塗りつぶし箇所のみご記入ください"]
[]
[null,"必要量　＝　（　実施人員　×　基準量　×　実施回数　÷　発注単位　）"]
["精米",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C22:F22)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$8*$C$8*D8/10000,0)","v":0},{"$f":"ROUNDUP($B$8*$C$8*E8/10000,0)","v":0},{"$f":"ROUNDUP($B$8*$C$8*F8/10000,0)","v":0},{"$f":"ROUNDUP($B$8*$C$8*G8/10000,0)","v":0},{"$f":"SUM(C23:F23)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C24:F24)","v":0}]
["（ 10ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C23+C24-C22","v":0},{"$f":"D23+D24-D22","v":0},{"$f":"E23+E24-E22","v":0},0,{"$f":"SUM(C25:F25)","v":0}]
[]
["アルファ化米",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計",null,"赤飯",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C28:F28)","v":0},null,null,"前月残",null,null,null,null,{"$f":"SUM(K28:N28)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$9*$C$9*D9/10000,0)","v":0},{"$f":"ROUNDUP($B$9*$C$9*E9/10000,0)","v":0},{"$f":"ROUNDUP($B$9*$C$9*F9/10000,0)","v":0},{"$f":"ROUNDUP($B$9*$C$9*G9/10000,0)","v":0},{"$f":"SUM(C29:F29)","v":0},null,null,"必要量",{"$f":"ROUNDUP($B$10*$C$10*D10/1000,0)","v":0},{"$f":"ROUNDUP($B$10*$C$10*E10/1000,0)","v":0},{"$f":"ROUNDUP($B$10*$C$10*F10/1000,0)","v":0},{"$f":"ROUNDUP($B$10*$C$10*G10/1000,0)","v":0},{"$f":"SUM(K29:N29)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C30:F30)","v":0},null,null,"調整",null,null,null,null,{"$f":"SUM(K30:N30)","v":0}]
["（ 10ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C29+C30-C28","v":0},{"$f":"D29+D30-D28","v":0},0,0,{"$f":"SUM(C31:F31)","v":0},null,"（ 1ｋｇ ）","申込量\n（必要量+調整）",{"$f":"K29+K30-K28","v":0},{"$f":"L29+L30-L28","v":0},0,0,{"$f":"SUM(K31:N31)","v":0}]
[]
["乾めん",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計",null,"中華めん",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C34:F34)","v":0},null,null,"前月残",null,null,null,null,{"$f":"SUM(K34:N34)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$11*$C$11*D11/5000,0)","v":0},{"$f":"ROUNDUP($B$11*$C$11*E11/5000,0)","v":0},{"$f":"ROUNDUP($B$11*$C$11*F11/5000,0)","v":0},{"$f":"ROUNDUP($B$11*$C$11*G11/5000,0)","v":0},{"$f":"SUM(C35:F35)","v":0},null,null,"必要量",{"$f":"ROUNDUP($B$12*$C$12*D12/5000,0)","v":0},{"$f":"ROUNDUP($B$12*$C$12*E12/5000,0)","v":0},0,0,{"$f":"SUM(K35:N35)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C36:F36)","v":0},null,null,"調整",null,null,null,null,{"$f":"SUM(K36:N36)","v":0}]
["（ 5ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C35+C36-C34","v":0},{"$f":"D35+D36-D34","v":0},0,0,{"$f":"SUM(C37:F37)","v":0},null,"（ 5ｋｇ ）","申込量\n（必要量+調整）",{"$f":"K35+K36-K34","v":0},{"$f":"L35+L36-L34","v":0},0,0,{"$f":"SUM(K37:N37)","v":0}]
[]
["脱脂粉乳",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C40:F40)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$13*$C$13*D13/1000,0)","v":0},{"$f":"ROUNDUP($B$13*$C$13*E13/1000,0)","v":0},{"$f":"ROUNDUP($B$13*$C$13*F13/1000,0)","v":0},{"$f":"ROUNDUP($B$13*$C$13*G13/1000,0)","v":0},{"$f":"SUM(C41:F41)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C42:F42)","v":0}]
["（ 1ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C41+C42-C40","v":0},{"$f":"D41+D42-D40","v":0},0,0,{"$f":"SUM(C43:F43)","v":0}]
[]
["押 麦",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計",null,"白 麦",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C46:F46)","v":0},null,null,"前月残",null,null,null,null,{"$f":"SUM(K46:N46)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$14*$C$14*D14/1000,0)","v":0},{"$f":"ROUNDUP($B$14*$C$14*E14/1000,0)","v":0},{"$f":"ROUNDUP($B$14*$C$14*F14/1000,0)","v":0},{"$f":"ROUNDUP($B$14*$C$14*G14/1000,0)","v":0},{"$f":"SUM(C47:F47)","v":0},null,null,"必要量",{"$f":"ROUNDUP($B$15*$C$15*D15/1000,0)","v":0},{"$f":"ROUNDUP($B$15*$C$15*E15/1000,0)","v":0},{"$f":"ROUNDUP($B$15*$C$15*F15/1000,0)","v":0},{"$f":"ROUNDUP($B$15*$C$15*G15/1000,0)","v":0},{"$f":"SUM(K47:N47)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C48:F48)","v":0},null,null,"調整",null,null,null,null,{"$f":"SUM(K48:N48)","v":0}]
["（ 1ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C47+C48-C46","v":0},{"$f":"D47+D48-D46","v":0},0,0,{"$f":"SUM(C49:F49)","v":0},null,"（ 1ｋｇ ）","申込量\n（必要量+調整）",{"$f":"K47+K48-K46","v":0},{"$f":"L47+L48-L46","v":0},0,0,{"$f":"SUM(K49:N49)","v":0}]
[]
["丸 麦",null,{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"４月\",IF($E$2=\"第２学期分\",\"９月\",IF($E$2=\"第３学期分\",\"１月\",\"８月\"))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"５月\",IF($E$2=\"第２学期分\",\"１０月\",IF($E$2=\"第３学期分\",\"２月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"６月\",IF($E$2=\"第２学期分\",\"１１月\",IF($E$2=\"第３学期分\",\"３月\",0))))","v":""},{"$f":"IF($E$2=\"\",\"\",IF($E$2=\"第１学期分\",\"７月\",IF($E$2=\"第２学期分\",\"１２月\",0)))","v":""},"計"]
[null,"前月残",null,null,null,null,{"$f":"SUM(C52:F52)","v":0}]
[null,"必要量",{"$f":"ROUNDUP($B$16*$C$16*D16/1000,0)","v":0},{"$f":"ROUNDUP($B$16*$C$16*E16/1000,0)","v":0},{"$f":"ROUNDUP($B$16*$C$16*F16/1000,0)","v":0},{"$f":"ROUNDUP($B$16*$C$16*G16/1000,0)","v":0},{"$f":"SUM(C53:F53)","v":0}]
[null,"調整",null,null,null,null,{"$f":"SUM(C54:F54)","v":0}]
["（ 1ｋｇ ）","申込量\n（必要量+調整）",{"$f":"C53+C54-C52","v":0},{"$f":"D53+D54-D52","v":0},0,0,{"$f":"SUM(C55:F55)","v":0}]