{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["説明シート（提出不要）","算出表251217"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"説明シート（提出不要）","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"merged":[[0,1,1,32],[58,32,58,41]]}
[null,"栽培実証において補助対象となる国内資源由来肥料の上限量算出表の作成について"]
[]
[]
[null,"（１）栽培実証において補助対象となる国内資源由来肥料の上限量について"]
{"$rows_empty":23}
[null,"（２）栽培実証において補助対象となる国内資源由来肥料量の算出に当たっての留意事項"]
{"$rows_empty":9}
[null,"【補助上限量算出表の作成単位の考え方】"]
[null,"ほ場①（10a）",{"$nulls":15},"ほ場③（10a）"]
[null,"　【実証者：A氏、実証品目:キャベツ】",{"$nulls":15},"　【実証者：A氏、実証品目:キャベツ】"]
[null,"　【輸入原料に依存した肥料】",{"$nulls":15},"　【輸入原料に依存した肥料】"]
[null,"　　（元肥）①化成A：〇袋、②化成B：△袋",{"$nulls":15},"　　（元肥）①化成C：□袋、②化成D：×袋"]
[null,"　【国内資源由来肥料】",{"$nulls":15},"　【国内資源由来肥料】"]
[null,"　　（元肥）国内資源由来肥料A",{"$nulls":15},"　　（元肥）国内資源由来肥料A"]
[null,"ほ場②（10a）",{"$nulls":15},"ほ場④（10a）"]
[null,"　【実証者：B氏、実証品目：キャベツ】",{"$nulls":15},"　【実証者：B氏、実証品目：ハクサイ】"]
[null,"　【輸入原料に依存した肥料】",{"$nulls":15},"　【輸入原料に依存した肥料】"]
[null,"　　（元肥）①化成A：〇袋、②化成B：□袋",{"$nulls":15},"　　（元肥）①化成A：〇袋、②化成D：×袋"]
[null,"　　（追肥）③化成A：◎袋"]
[null,"　【国内資源由来肥料】",{"$nulls":15},"　【国内資源由来肥料】"]
[null,"　　（追肥）国内資源由来肥料A",{"$nulls":15},"　　（元肥）国内資源由来肥料A"]

{"sheet":"算出表251217","index":1,"n_rows":56,"n_cols":63,"rows_kept":56,"merged":[[0,1,1,32],[4,2,4,15],[4,16,4,31],[5,2,5,7],[5,8,5,15],[5,16,5,31],[6,2,6,7],[6,8,6,15],[6,16,6,31],[7,2,7,7],[7,8,7,15],[7,16,7,31],[8,2,8,7],[8,8,8,15],[8,16,8,31],[12,2,15,7],[12,8,15,13],[12,14,14,19],[12,20,12,25],[12,26,15,27],[12,28,12,31],[13,20,13,25],[13,28,15,29],[13,30,15,31],[14,20,14,25],[15,14,15,15],[15,16,15,17],[15,18,15,19],[15,20,15,21],[15,22,15,23],[15,24,15,25],[16,2,16,7],[16,8,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,23],[16,24,16,25],[16,26,16,27],[16,28,16,29],[16,30,16,31],[17,2,17,7],[17,8,17,13],[17,14,17,15],[17,16,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,26,17,27],[17,28,17,29],[17,30,17,31],[18,2,18,7],[18,8,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[18,26,18,27],[18,28,18,29],[18,30,18,31],[19,2,19,7],[19,8,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[19,28,19,29],[19,30,19,31],[20,2,20,7],[20,8,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[20,22,20,23],[20,24,20,25],[20,26,20,27],[20,28,20,29],[20,30,20,31],[23,2,25,7],[23,8,24,13],[23,14,24,19],[26,2,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[27,2,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[28,2,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,26,28,27],[28,28,28,29],[28,30,28,31],[29,2,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,23,29,28],[29,29,30,31],[30,2,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[30,16,30,17],[30,18,30,19],[31,2,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[31,16,31,17],[31,18,31,19],[31,23,31,25],[31,26,31,28],[31,29,31,31],[35,2,38,7],[35,8,37,13],[35,14,35,19],[35,20,35,25],[35,26,37,31],[36,14,36,25],[37,14,37,19],[37,20,37,25],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[38,20,38,21],[38,22,38,23],[38,24,38,25],[38,26,38,27],[38,28,38,29],[38,30,38,31],[39,2,39,7],[39,8,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,15],[39,16,39,17],[39,18,39,19],[39,20,39,21],[39,22,39,23],[39,24,39,25],[39,26,39,27],[39,28,39,29],[39,30,39,31],[40,2,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[40,16,40,17],[40,18,40,19],[40,20,40,21],[40,22,40,23],[40,24,40,25],[40,26,40,27],[40,28,40,29],[40,30,40,31],[41,2,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,23],[41,24,41,25],[41,26,41,27],[41,28,41,29],[41,30,41,31],[42,2,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[42,16,42,17],[42,18,42,19],[42,20,42,21],[42,22,42,23],[42,24,42,25],[42,26,42,27],[42,28,42,29],[42,30,42,31],[43,2,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[43,18,43,19],[43,20,43,21],[43,22,43,23],[43,24,43,25],[43,26,43,27],[43,28,43,29],[43,30,43,31],[47,2,48,7],[47,8,48,10],[47,11,48,13],[47,14,47,21],[47,22,48,23],[48,14,48,15],[48,16,48,17],[48,18,48,19],[48,20,48,21],[48,35,49,39],[48,40,48,48],[48,51,49,55],[48,56,48,64],[49,2,49,7],[49,8,49,10],[49,11,49,13],[49,20,49,21],[49,22,49,23],[50,2,50,7],[50,8,50,10],[50,11,50,13],[50,20,50,21],[50,22,50,23],[50,35,50,39],[50,51,50,55],[51,2,51,7],[51,8,51,10],[51,11,51,13],[51,20,51,21],[51,22,51,23],[51,35,51,39],[51,51,51,55],[52,2,52,7],[52,8,52,10],[52,11,52,13],[52,20,52,21],[52,22,52,23],[52,26,54,27],[52,28,53,31],[52,35,52,39],[52,51,52,55],[53,2,53,7],[53,8,53,10],[53,11,53,13],[53,20,53,21],[53,22,53,23],[53,35,53,39],[53,51,53,55],[54,2,54,7],[54,8,54,10],[54,11,54,13],[54,20,54,21],[54,22,54,23],[54,28,54,31],[54,35,54,39],[54,51,54,55],[55,35,55,39],[55,51,55,55]]}
[null,"栽培実証において補助対象となる国内資源由来肥料の上限量算出表（記入シート）",{"$nulls":32},"（概念図）補助対象となる国内資源由来肥料の上限量の算定"]
[]
[{"$nulls":6},"注）青色セルに必要事項を記入してください。なお、本シートは、資材購入者、実証品目ごとに作成する必要があります。"]
[null,"１．基本情報"]
[null,null,"項     目",{"$nulls":13},"説    明"]
[null,null,"資材購入者名",{"$nulls":13},"事業実施計画書別紙4の（１）欄で整理した資材購入者名を記入。"]
[null,null,"実証ほ場整理番号",{"$nulls":13},"事業実施計画書別紙4の（６）欄で整理した整理番号を記入。"]
[null,null,"対象ほ場面積（ha）",{"$nulls":13},"事業実施計画書別紙４の（７）欄で整理した実証面積を基に記入。"]
[null,null,"実証品目・散布用途",{"$nulls":13},"事業実施計画書別紙４の（８）及び（21）欄で整理した実証品目及び散布用途を記入。"]
[]
[null,"２．補助対象となる肥料成分の上限量の算定"]
[null,"（１）基準年度に施用した肥料の、肥料成分量、単品重量及び施用量（基準年度・事業年度）を入力します。"]
[null,null,"肥料の名称",{"$nulls":5},"肥料の区分",{"$nulls":5},"全肥料成分量　①\n（％）",{"$nulls":11},"単品重量(kg/袋)\n③",null,"施用量（袋）"]
[{"$nulls":20},"国内資源由来　②",{"$nulls":7},"基準年度\n④",null,"事業年度\n⑤"]
[{"$nulls":20},"肥料成分量（％）"]
[{"$nulls":14},"N",null,"P",null,"K",null,"N",null,"P",null,"K"]
[]
[]
[]
[]
[]
[]
[null,"（２）代替される肥料成分の施用量を求め、補助対象となる肥料成分の上限量を算出します。"]
[null,null,"肥料の名称",{"$nulls":5},"（基準年度）肥料成分の施用量\n（kg）　⑥＝③×④×①",{"$nulls":5},"（事業年度）肥料成分の施用量（kg）　⑦＝③×⑤×①"]
[]
[{"$nulls":8},"N",null,"P",null,"K",null,"N",null,"P",null,"K"]
[null,null,{"$f":"C17","v":0},{"$nulls":5},{"$f":"AA17*AC17*O17%","v":0},null,{"$f":"AA17*AC17*Q17%","v":0},null,{"$f":"AA17*AC17*S17%","v":0},null,{"$f":"AA17*AE17*O17%","v":0},null,{"$f":"AA17*AE17*Q17%","v":0},null,{"$f":"AA17*AE17*S17%","v":0},null,{"$f":"IF(I17=\"国内資源由来肥料\",SUM(U17:Z17)/SUM(O17:T17),0)","v":0}]
[null,null,{"$f":"C18","v":0},{"$nulls":5},{"$f":"AA18*AC18*O18%","v":0},null,{"$f":"AA18*AC18*Q18%","v":0},null,{"$f":"AA18*AC18*S18%","v":0},null,{"$f":"AA18*AE18*O18%","v":0},null,{"$f":"AA18*AE18*Q18%","v":0},null,{"$f":"AA18*AE18*S18%","v":0},null,{"$f":"IF(I18=\"国内資源由来肥料\",SUM(U18:Z18)/SUM(O18:T18),0)","v":0}]
[null,null,{"$f":"C19","v":0},{"$nulls":5},{"$f":"$AA19*$AC19*O19%","v":0},null,{"$f":"$AA19*$AC19*Q19%","v":0},null,{"$f":"$AA19*$AC19*S19%","v":0},null,{"$f":"AA19*AE19*O19%","v":0},null,{"$f":"AA19*AE19*Q19%","v":0},null,{"$f":"AA19*AE19*S19%","v":0},null,{"$f":"IF(I19=\"国内資源由来肥料\",SUM(U19:Z19)/SUM(O19:T19),0)","v":0},{"$nulls":17},"　"]
[null,null,{"$f":"C20","v":0},{"$nulls":5},{"$f":"$AA20*$AC20*O20%","v":0},null,{"$f":"$AA20*$AC20*Q20%","v":0},null,{"$f":"$AA20*$AC20*S20%","v":0},null,{"$f":"AA20*AE20*O20%","v":0},null,{"$f":"AA20*AE20*Q20%","v":0},null,{"$f":"AA20*AE20*S20%","v":0},null,{"$f":"IF(I20=\"国内資源由来肥料\",SUM(U20:Z20)/SUM(O20:T20),0)","v":0},null,null,"肥料成分の総合計(kg)",{"$nulls":5},"上限量(kg)\n⑧＝⑥－⑦ "]
[null,null,0,{"$nulls":5},{"$f":"$AA21*$AC21*O21%","v":0},null,{"$f":"$AA21*$AC21*Q21%","v":0},null,{"$f":"$AA21*$AC21*S21%","v":0},null,{"$f":"AA21*AE21*O21%","v":0},null,{"$f":"AA21*AE21*Q21%","v":0},null,{"$f":"AA21*AE21*S21%","v":0},null,{"$f":"IF(I21=\"国内資源由来肥料\",SUM(U21:Z21)/SUM(O21:T21),0)","v":0},null,null,"基準年度　⑥",null,null,"事業年度　⑦"]
[null,null,"各肥料成分の合計",{"$nulls":5},{"$f":"SUM(I27:J31)","v":0},null,{"$f":"SUM(K27:L31)","v":0},null,{"$f":"SUM(M27:N31)","v":0},null,{"$f":"SUM(O27:P31)","v":0},null,{"$f":"SUM(Q27:R31)","v":0},null,{"$f":"SUM(S27:T31)","v":0},{"$nulls":4},{"$f":"SUM(I32:N32)","v":0},null,null,{"$f":"SUM(O32:T32)","v":0},null,null,{"$f":"X32-AA32","v":0}]
[]
[null,"３．栽培実証で施用する国内資源由来肥料の肥料成分量の算定"]
[null,"　　　 肥料成分量及び肥効率を入力し、肥効率を考慮した肥料成分量を算定します。"]
[null,null,"国内資源由来肥料の\n名称",{"$nulls":5},"全肥料成分量\n（％）　⑨",{"$nulls":17},"肥料成分量（％）\n⑫ ＝⑩×⑪＋(⑨－⑩)"]
[{"$nulls":14},"国内資源由来の肥料成分"]
[{"$nulls":14},"成分量（％）⑩",{"$nulls":5},"肥効率（％）⑪",{"$nulls":13},"（解説）国内資源に由来する肥料成分の肥効率について"]
[{"$nulls":8},"N",null,"P",null,"K",null,"N",null,"P",null,"K",null,"N",null,"P",null,"K",null,"N",null,"P",null,"K"]
[{"$nulls":26},{"$f":"O40*U40%+(I40-O40)","v":0},null,{"$f":"Q40*W40%+(K40-Q40)","v":0},null,{"$f":"S40*Y40%+(M40-S40)","v":0}]
[{"$nulls":26},{"$f":"O41*U41%+(I41-O41)","v":0},null,{"$f":"Q41*W41%+(K41-Q41)","v":0},null,{"$f":"S41*Y41%+(M41-S41)","v":0}]
[{"$nulls":26},0,null,0,null,0]
[{"$nulls":26},0,null,0,null,0]
[{"$nulls":26},0,null,{"$f":"Q44*W44%+(K44-Q44)","v":0},null,0]
[]
[null,"４．栽培実証で施用する国内資源由来肥料の購入量が上限内にあることの確認"]
[null,"　　　単品重量と購入量を入力し、購入量が補助対象の上限内にあることを確認します。"]
[null,null,"国内資源由来肥料の\n名称",{"$nulls":5},"単品重量\n（kg/袋）⑬",null,null,"購入量\n（袋）⑭",null,null,"肥料成分量(kg)　⑮＝⑬×⑭×⑫",{"$nulls":7},"国内資源\n原料割合",{"$nulls":12},"肥効率のめやす"]
[{"$nulls":14},"N",null,"P",null,"K",null,"合　　計",{"$nulls":14},"肥料の種類",{"$nulls":4},"肥効率（％）",{"$nulls":10},"肥料の種類",{"$nulls":4},"肥効率（％）"]
[null,null,{"$f":"C40","v":0},{"$nulls":11},{"$f":"$I50*$L50*$AA40%","v":0},null,{"$f":"$I50*$L50*$AC40%","v":0},null,{"$f":"$I50*$L50*$AE40%","v":0},null,{"$f":"SUM(O50:T50)","v":0},null,{"$f":"IF(OR(C40=\"\",SUM(I40:N40)=0,SUM(O40:T40)=0),\"\",IF(SUM(O40:T40)/SUM(I40:N40)>MAX($U$27:$U$31),\"〇\",\"×\"))","v":""},{"$f":"IF(B40=\"\",\"－\",IF(SUM(N40:S40)/SUM(H40:M40)>MIN($U$27:$U$31),\"〇\",\"×\"))","v":"－"},{"$nulls":16},"N",null,null,"P",null,null,"K",{"$nulls":9},"N",null,null,"P",null,null,"K"]
[null,null,{"$f":"C41","v":0},{"$nulls":11},{"$f":"$I51*$L51*$AA41%","v":0},null,{"$f":"$I51*$L51*$AC41%","v":0},null,{"$f":"$I51*$L51*$AE41%","v":0},null,{"$f":"SUM(O51:T51)","v":0},null,{"$f":"IF(OR(C41=\"\",SUM(I41:N41)=0,SUM(O41:T41)=0),\"\",IF(SUM(O41:T41)/SUM(I41:N41)>MAX($U$27:$U$31),\"〇\",\"×\"))","v":""},{"$f":"IF(B41=\"\",\"－\",IF(SUM(N41:S41)/SUM(H41:M41)>MIN($U$27:$U$31),\"〇\",\"×\"))","v":"－"},{"$nulls":11},"稲わら堆肥",{"$nulls":4},"10～20",null,null,"50～100",null,null,"65～90",{"$nulls":4},"魚かす",{"$nulls":4},80,null,null,80,null,null,80]
[null,null,{"$f":"C42","v":0},{"$nulls":11},{"$f":"$I52*$L52*$AA42%","v":0},null,{"$f":"$I52*$L52*$AC42%","v":0},null,{"$f":"$I52*$L52*$AE42%","v":0},null,{"$f":"SUM(O52:T52)","v":0},null,{"$f":"IF(OR(C42=\"\",SUM(I42:N42)=0,SUM(O42:T42)=0),\"\",IF(SUM(O42:T42)/SUM(I42:N42)>MAX($U$27:$U$31),\"〇\",\"×\"))","v":""},{"$f":"IF(B42=\"\",\"－\",IF(SUM(N42:S42)/SUM(H42:M42)>MIN($U$27:$U$31),\"〇\",\"×\"))","v":"－"},{"$nulls":11},"牛ふん堆肥",{"$nulls":4},"10～20",null,null,"60～100",null,null,"65～90",{"$nulls":4},"なたね油かす",{"$nulls":4},80,null,null,80,null,null,80]
[null,null,{"$f":"C43","v":0},{"$nulls":11},{"$f":"$I53*$L53*$AA43%","v":0},null,{"$f":"$I53*$L53*$AC43%","v":0},null,{"$f":"$I53*$L53*$AE43%","v":0},null,{"$f":"SUM(O53:T53)","v":0},null,{"$f":"IF(OR(C43=\"\",SUM(I43:N43)=0,SUM(O43:T43)=0),\"\",IF(SUM(O43:T43)/SUM(I43:N43)>MAX($U$27:$U$31),\"〇\",\"×\"))","v":""},{"$f":"IF(B43=\"\",\"－\",IF(SUM(N43:S43)/SUM(H43:M43)>MIN($U$27:$U$31),\"〇\",\"×\"))","v":"－"},null,null,"判定",null,{"$f":"IF(OR(AD32=0,U55=0),\"\",IF($AD$32>$U$55,\"適　合\",\"不適合\"))","v":""},{"$nulls":6},"豚ぷん堆肥",{"$nulls":4},"20～40",null,null,"60～100",null,null,"65～90",{"$nulls":4},"大豆油かす",{"$nulls":4},80,null,null,80,null,null,80]
[null,null,{"$f":"C44","v":0},{"$nulls":11},{"$f":"$I54*$L54*$AA44%","v":0},null,{"$f":"$I54*$L54*$AC44%","v":0},null,{"$f":"$I54*$L54*$AE44%","v":0},null,{"$f":"SUM(O54:T54)","v":0},null,{"$f":"IF(OR(C44=\"\",SUM(I44:N44)=0,SUM(O44:T44)=0),\"\",IF(SUM(O44:T44)/SUM(I44:N44)>MAX($U$27:$U$31),\"〇\",\"×\"))","v":""},{"$f":"IF(B44=\"\",\"－\",IF(SUM(N44:S44)/SUM(H44:M44)>MIN($U$27:$U$31),\"〇\",\"×\"))","v":"－"},{"$nulls":11},"鶏ふん堆肥",{"$nulls":4},"30～60",null,null,"60～100",null,null,90,{"$nulls":4},"米ぬか",{"$nulls":4},70,null,null,80,null,null,80]
[null,null,"合計",{"$nulls":8},{"$f":"SUM(L50:N54)","v":0},null,null,{"$f":"SUM(O50:O54)","v":0},null,{"$f":"SUM(Q50:Q54)","v":0},null,{"$f":"SUM(S50:S54)","v":0},null,{"$f":"SUM(O55:T55)","v":0},{"$nulls":7},{"$f":"IF(OR(AD32=0,U55=0),\"\",IF($AD$32>$U$55,\"上限内です\",\"上限を超えています\"))","v":""},{"$nulls":6},"バーク堆肥",{"$nulls":4},"10～20",null,null,"50～100",null,null,"65～70",{"$nulls":4},"有機配合肥料",{"$nulls":4},80,null,null,80,null,null,80]
[{"$nulls":35},"もみがら堆肥",{"$nulls":4},10,null,null,50,null,null,80]