{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["需要申請書","リスト","算出補助表"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

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

{"sheet":"リスト","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"hidden":true}
[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,{"$nulls":3},"委託炊飯、自校調理用","第３学期分"]
[null,"８月分",null,4,null,4,{"$nulls":4},"８月分"]
[{"$nulls":3},5,null,5]
[{"$nulls":5},6]
[{"$nulls":5},7]
[{"$nulls":5},8]
[{"$nulls":5},9]
[{"$nulls":5},10]

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