{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["操作方法","入力表","写真画像","ルール","コメント","アメダス園部","アメダス美山","アメダス須知","アメダス本庄","アメダス三和"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":76,"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":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,0,13,6],[30,0,53,6],[59,0,65,6],[66,0,70,6]]}
["土寄せ判断支援システム（2023年版）の使用法",null,null,null,null,null,"京都府南丹農業改良普及センター"]
[]
["システムの概要　"]
["　このシステムは、黒大豆（新丹波黒）の種まきなどの作業日や、雑草発生状況を入力することにより、その後の作業適期を表示します。推奨する作業体系は、直播、初期除草剤散布、土寄せ２回、茎葉処理除草剤散布、摘心です。\n　表示される「評価・コメント」を参考にしたり、「観察記録」を入力することで生育・収量の分析にも活用でます。\n\n操作方法\n　画面左側の水色の欄に各作業日を入力し、その横に表示される作業適期を参考に、以後の作業計画を立てます。\n　入力された作業日に対して、評価・コメントが表示されるとともに、画面右の観察記録を入力すれば、今後の分析・反省に活用できます。\n　"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n１　「判断日」（最上段の欄）は、判断する時点の日付を毎回入力（実際の日でなくてもよい、シミュレーション可）。「播種日」は必ず入力\n\n２　日付は半角文字で「6/1」などと入力すれば、「6月1日」と表示\n\n３　参照アメダス地点は、園部、美山、須知、本庄、三和から最寄り地点を▼リストで選択\n\n４　判断日までに実施した作業日を、各作業の「実施月日」欄に入力。実施していない作業は入力しなくて良い。上書き入力すれば、何度でも適期を計算。\n\n５　下欄の「追加入力」は、「判断日」が下記の時期になれば入力する（入力欄が水色に変わる）。右側に写真が表示されるので参考に▼リストで選択\n　　・播種後草量：播種後15日以降\n　　・株間草大　：1回目土寄せの５日後以降\n　　　　　または、１回目未実施の場合、表示した２回目土寄せ適期始め以降\n　　・開花前茎長：７月１日以降\n\n６　計算結果は印刷して残しても良いが、複数ほ場の結果をそれぞれ別の名前（ほ場名や作型）でファイル保存すれば、次回続きから入力できる（判断日はその都度日付を更新して入力）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["７　「評価・コメント」欄は、入力内容により今後の注意点や評価を表示\n\n８　「観察記録」を入力すれば、生育・収量の分析や栽培の反省に活用できる（入力しなくても動作に影響なし）。\n　発芽揃い、開花始め、着莢始めは日付を入力。除草剤、土寄せの土壌条件は▼リストで選択。\n\n\n"]
[]
[]
[]
[]
[]
[]
["９　表左上の「メニューに戻る」をクリックすると終了して「黒大豆メニュー」に戻る\nここでファイル保存でき、名前を付けて保存も可能"]

{"sheet":"入力表","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[17,2,18,2],[19,2,20,2],[10,11,11,14],[12,11,13,14],[10,8,11,8],[12,8,13,8],[15,6,21,6],[15,7,21,7],[12,6,13,7],[2,8,2,10],[19,3,20,3],[19,4,20,5],[17,4,18,5],[15,4,16,5],[8,8,9,8],[6,8,7,8],[10,9,11,10],[12,9,13,10],[3,9,3,10],[4,6,4,7],[2,6,2,7],[3,6,3,7],[8,6,9,7],[10,6,11,7],[6,6,7,7],[2,11,2,14],[3,11,3,14],[4,11,4,14],[6,11,7,14],[8,11,9,14],[5,11,5,14],[22,1,23,3],[2,3,2,5],[6,2,7,2],[8,2,9,2],[10,2,11,2],[12,2,13,2],[6,1,7,1],[8,1,9,1],[10,1,11,1],[12,1,13,1],[3,3,3,5],[15,1,16,1],[17,1,18,1],[19,1,20,1],[15,3,16,3],[17,3,18,3],[5,6,5,7],[15,2,16,2],[4,9,4,10],[5,9,5,10],[8,9,9,10],[6,9,7,10]]}
[null,2025,"年","判断日","2025-06-01","6月1日は  ","6/1 と入力（過去年の入力は2024/6/1などと入力）",null,null,null,"京都府南丹農業改良普及センター",null,null,null,null,250512]
[null,"土寄せ判断システム",null,"参照アメダス",{"$f":"VLOOKUP(C36,C37:D41,2)","v":"園部"},"　　　近くのアメダスを▼で園部、美山、須知、本庄、三和 から選んでください"]
[null,"作業","実施月日","おすすめする作業適期",null,null,"　　　　　作業実施状況に対する 評 価　・　コ メ ン ト",null,"観察記録(月日又は土壌条件▼)",null,null,"観察内容（自由記述）"]
[null,"播種","2025-06-01",{"$f":"IF(OR(判断日入力=\"\",アメダス地点=\"\",播種日=\"\"),\"判断日(最上段),参照アメダス,\n播種日を初めに全て入力しください\",\"\")","v":""},null,null,null,null,"発芽揃い"]
[null,"初期除草剤",null,{"$f":"播種日","v":"2025-06-01"},"～",{"$f":"播種日+3","v":"2025-06-04"},{"$f":"コメント!E5","v":""},null,"初期除草剤処理時土壌条件",{"$f":"VLOOKUP(E42,C37:E41,3)","v":0}]
[null,"定稙",null,{"$f":"播種日+8","v":"2025-06-09"},"～",{"$f":"播種日+14","v":"2025-06-15"},{"$f":"コメント!E6","v":""},null,"定稙時の\n土壌条件",{"$f":"VLOOKUP($E43,$C$37:$E$41,3)","v":0}]
[null,"土寄①",null,{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"IF($D$7=\"土寄困難\",\"\",\"～\")","v":"～"},{"$f":"土寄①終修正","v":"2025-07-01"},{"$f":"コメント!E7","v":""},null,"土寄①の\n土壌条件",{"$f":"VLOOKUP($E44,$C$37:$E$41,3)","v":0}]
[null,null,null,{"$f":"IF($D$7=\"土寄困難\",\"\",\"適期内作業可能確率\")","v":"適期内作業可能確率"},null,{"$f":"IF(土寄①始修正=\"土寄困難\",\"\",土寄①確率)","v":0.48181818181818181}]
[null,"土寄②",null,{"$f":"IF(土寄①始修正=\"土寄困難\",\"\",土寄②始修正)","v":"2025-07-06"},{"$f":"IF($D$7=\"土寄困難\",\"\",\"～\")","v":"～"},{"$f":"IF(土寄①始修正=\"土寄困難\",\"\",土寄期限)","v":"2025-07-16"},{"$f":"コメント!E8","v":""},null,"土寄②の\n土壌条件",{"$f":"VLOOKUP($E45,$C$37:$E$41,3)","v":0}]
[null,null,null,{"$f":"IF($D$7=\"土寄困難\",\"\",\"適期内作業可能確率\")","v":"適期内作業可能確率"},null,{"$f":"IF(土寄①始修正=\"土寄困難\",\"\",土寄②確率)","v":0.41818181818181815}]
[null,"茎葉除草剤",null,{"$f":"茎葉始","v":"2025-07-13"},"～",{"$f":"茎葉終","v":"2025-07-23"},{"$f":"コメント!E9","v":""},null,"開花始め"]
[null,null,null,{"$f":"IF($D$7=\"土寄困難\",\"\",IF(茎葉剤時期=\"土寄せ前\",\"土寄せ前 5～7日に処理\",\"土寄せ7日～10日後に処理\"))","v":"土寄せ7日～10日後に処理"}]
[null,"摘心",null,{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",摘心始修正,\"\")","v":""},{"$f":"IF(D13=\"\",\"\",\"～\")","v":""},{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",摘心終,\"\")","v":""},{"$f":"コメント!E10","v":""},null,"着莢始め\n(5mm以上)"]
[null,null,null,{"$f":"IF(摘心判断時期>判断日入力,IF(摘心検討=\"摘心実施を考える\",摘心検討,\"7月1日以降の主茎長で要否を判断\"),摘心実施)","v":"7月1日以降の主茎長で要否を判断"}]
[null,"追加入力","水色セルに ▼リストで選択してください",null,null,null,{"$f":"写真画像!D1","v":"消去"},{"$f":"写真画像!E1","v":"消去"}]
[null,"播種後草量",3,"草多：雑草多\n草少：雑草少","播種2週間後、草目立てば\n土寄せ①は20～25日後",null,{"$f":"参照画像1","v":0},{"$f":"参照画像2","v":0},null,"観察記録の土壌条件は▼リストで選択"]
[]
[null,"株間草大",3,"草大：雑草大\n草小：雑草小","土寄せ①後 株間残草大なら\n茎葉剤土寄せ②前処理",null,null,null,null,"土壌条件：　乾燥　　適湿　　やや過湿　　不良"]
[]
[null,"開花前茎長",3,"主茎：超50cm\n主茎：短50cm","開花までに主茎長50cm\n超えるなら、45cmで摘心"]
[]
[]
[null,"土寄せ作業可能かどうかの\n判断条件"]
[]
[null,"作業できない降雨量mm"]
[null,"当日",2,"mm"]
[null,"翌日",10,"mm"]
[null,"２日後",30,"mm"]
[null,null,"↑"]
[null,null,"降雨量条件は変更できます"]
[]
[]
[]
[null,null,"↓追加入力のメッセージ表示"]
[null,null,{"$f":"IF(AND(判断日入力>=ルール!C40,$C$16=3)=TRUE,1,\"入力済み\")","v":"入力済み"},{"$f":"IF(OR(AND(判断日入力>=播種後20日,$C$16=\"\"),AND(株間草入力=\"株間草入力\",$C$18=3),AND(開花前茎長入力=\"開花前茎長を入力\",$C$20=3)),\"赤字\",\"見えなくする\")","v":"見えなくする"}]
[null,null,1]
[null,null,1,"園部","乾燥","草多"]
[null,null,2,"美山","適湿","草少"]
[null,null,3,"須知","やや過湿"]
[null,null,4,"本庄","過湿","草大"]
[null,null,5,"三和",null,"草小"]
[null,null,null,null,5]
[null,null,null,null,5,"超50cm"]
[null,null,null,null,5,"短50cm"]
[null,null,null,null,5]

{"sheet":"写真画像","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"写真画像データ","写真表示",{"$f":"IF(播種後草入力=\"播種後草入力\",\"草多\",IF(株間草入力=\"株間草入力\",\"草大\",IF(摘心実施=\"開花前茎長を入力\",\"主茎長超50cm\",\"消去\")))","v":"消去"},{"$f":"IF(播種後草入力=\"播種後草入力\",\"草少\",IF(株間草入力=\"株間草入力\",\"草小\",IF(摘心実施=\"開花前茎長を入力\",\"主茎長短50m\",\"消去\")))","v":"消去"}]
[]
[null,"草多","草大","主茎長超50cm",null,{"$f":"IF(AND(播種後草量=\"\",播種後草入力=\"播種後草入力\"),\"草多\",\"\")","v":""}]
["左"]
[null,"草少","草小","主茎長短50m"]
["右"]
[null,"消去"]
[]
[]
[null,{"$f":"IF(AND(播種後草量=\"\",播種後草入力=\"播種後草入力\"),\"草少\",\"\")","v":""},"草小"]

{"sheet":"ルール","index":3,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["黒大豆　土寄せ判断システム知識ベース（判断ルール）"]
[]
[null,null,"数式","内容（名前）","出力値"]
[null,"判断日の設定（未入力時のガード）",{"$f":"IF(判断日入力=\"\",TODAY(),判断日入力)","v":"2025-06-01"},"判断日",{"$f":"C4","v":"2025-06-01"}]
[]
["定稙時期"]
[null,"定稙遅れの植え傷み（15日以上で2日、18日以上で3日）",{"$f":"IF(定稙日<播種日+15,0,IF(定稙日<播種日+18,2,3))","v":0},"植傷み",{"$f":"C7","v":0}]
[]
[]
["土寄せ時期"]
[1100,"１回目　直播後20～30日後に実施（始め）",{"$f":"播種日+植傷み+20","v":"2025-06-21"},"土寄①始の原則",{"$f":"C11","v":"2025-06-21"}]
[1110,"１回目　直播後20～30日後に実施（終わり）",{"$f":"播種日+植傷み+30","v":"2025-07-01"},"土寄①終の原則",{"$f":"C12","v":"2025-07-01"}]
[1115,"土寄①始原則が>7/26なら7/26(播種15日以内なら土寄困難）",{"$f":"IF(C11>土寄最遅,IF(土寄最遅-15<播種日+植傷み,\"土寄困難\",土寄最遅),C11)","v":"2025-06-21"},"土寄①始・前段階",{"$f":"C13","v":"2025-06-21"}]
[1117,"土寄①始原則が>=7/26なら7/31(土寄困難なら\"\"）",{"$f":"IF(C11>土寄最遅,IF(土寄①始=\"土寄困難\",\"\",土寄最遅+5),IF(C12>土寄最遅+5,土寄最遅+5,C12))","v":"2025-07-01"},"土寄①終・前段階",{"$f":"C14","v":"2025-07-01"}]
[null,"移植の場合土寄①始は移植７日後以降",{"$f":"IF(定稙日=\"\",C13,MAX(C13,定稙日+7))","v":"2025-06-21"},"移植の土寄①始",{"$f":"C15","v":"2025-06-21"}]
[null,"移植の場合土寄①終は移植７日後以降",{"$f":"IF(定稙日=\"\",C14,MAX(C14,定稙日+17))","v":"2025-07-01"},"移植の土寄①終","2025-07-01"]
[1200,"２回目　１回目未なら 15日後に実施（始め）",{"$f":"IF(土寄①=\"\",IF(土寄①始修正=\"土寄困難\",\"\",土寄①始+15),\"①入力済\")","v":"2025-07-06"},"①未実施の土寄②始"]
[1210,"２回目　１回目後12日後に実施（始め）",{"$f":"IF(土寄①<>\"\",土寄①+12,\"①未実施\")","v":"①未実施"},"①実施済みの土寄②始"]
[1220,"２回目　１回目未なら 15日後に実施（終わり）",{"$f":"IF(土寄①=\"\",IF(土寄①始=\"土寄困難\",\"\",土寄①終+15),\"①入力済\")","v":"2025-07-16"},"①未実施の土寄②終"]
[1230,"２回目　１回目後20日後に実施（終わり）",{"$f":"IF(土寄①<>\"\",土寄①+20,\"①未実施\")","v":"①未実施"},"①実施済みの土寄②終"]
[1240,"２回目　１回目遅れなら、 適期12日後と①7日後の遅い方（始め）",{"$f":"IF(土寄①>土寄①終,MAX(土寄①始+12,土寄①+7),\"遅れ処理なし\")","v":"遅れ処理なし"},"①遅れの土寄②始"]
[1250,"２回目　１回目遅れなら、 適期20日後と①10日後の遅い方（終わり）",{"$f":"IF(土寄①>土寄①終,MAX(土寄①終+20,土寄①+10),\"遅れ処理なし\")","v":"遅れ処理なし"},"①遅れの土寄②終"]
[1260,"２回目　土寄せ適期始め",{"$f":"MAX(C17,C18,C21)","v":"2025-07-06"},"土寄②始",{"$f":"C23","v":"2025-07-06"}]
[1270,"２回目　土寄せ適期終わり",{"$f":"MAX(C19,C20,C22)","v":"2025-07-16"},"土寄②終",{"$f":"C24","v":"2025-07-16"}]
[1280,"直播後50日後までに終える",{"$f":"播種日+50","v":"2025-07-21"},"播種50日後",{"$f":"C25","v":"2025-07-21"},null,{"$f":"C26","v":"2025-07-26"}]
[1290,"最遅日　７月２６日（開花前）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/26\")","v":"2025-07-26"},"土寄最遅",{"$f":"C26","v":"2025-07-26"},null,{"$f":"播種50日後","v":"2025-07-21"}]
[1300,"土寄②期限　播種後50日以内、7月26日まで（開花前）に終える",{"$f":"MIN(土寄最遅,播種50日後,土寄②終)","v":"2025-07-16"},"土寄期限",{"$f":"C27","v":"2025-07-16"}]
[13]
["降雨とトラクタ作業",null,null,null,null,null,{"$f":"地点名","v":"アメダス園部"}]
[2100,"参照するアメダス地点",{"$f":"アメダス地点","v":"園部"},"［入力表］の選択地点",null,"地点名",{"$f":"\"アメダス\"&C30","v":"アメダス園部"}]
[2110,"当日　作業できない降雨量mm",{"$f":"入力表!C26","v":2},"［入力表］下の降雨量判断条件（当日）"]
[2120,"翌日　作業できない降雨量mm",{"$f":"入力表!C27","v":10},"［入力表］下の降雨量判断条件（翌日）"]
[2130,"２日後　作業できない降雨量mm",{"$f":"入力表!C28","v":30},"［入力表］下の降雨量判断条件（２日後）"]
[2140,"（土寄①　適期内の作業可能な日数計算）","土寄①","適期日数",{"$f":"INDIRECT(地点名&\"!O111\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P111\")","v":5.3},"可能確率",{"$f":"INDIRECT(地点名&\"!D115\")","v":0.48181818181818181}]
[2150,"（土寄②　適期内の作業可能な日数計算）","土寄②","適期日数",{"$f":"INDIRECT(地点名&\"!O112\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P112\")","v":4.5999999999999996},"可能確率",{"$f":"INDIRECT(地点名&\"!E115\")","v":0.41818181818181815}]
[2160,"（除草剤　適期内の作業可能な日数計算）","除草剤","適期日数",{"$f":"INDIRECT(地点名&\"!O113\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P113\")","v":6.6},"可能確率",{"$f":"INDIRECT(地点名&\"!F115\")","v":0.6}]
[2170,"（摘心　適期内の作業可能な日数計算）","摘心","適期日数",{"$f":"アメダス園部!O114","v":{"$error":"#VALUE!"}},"可能日数",{"$f":"アメダス園部!P114","v":{"$error":"#VALUE!"}},"可能確率",{"$f":"アメダス園部!G115","v":{"$error":"#VALUE!"}}]
[8]
["除草剤と土寄せ",null,"播種2週間後","入力"]
[3100,"播種20日後草目立つかどうか判断",{"$f":"播種日+14","v":"2025-06-15"},"播種日2週間後"]
[3110,"播種20日後草目立つかどうかの入力の要否",{"$f":"IF(AND(判断日>=C40,入力表!$C$16=3),\"播種後草入力\",IF(入力表!$C$16<>3,\"入力済み\",\"判断日前\"))","v":"判断日前"},"播種後草入力",{"$f":"C41","v":"判断日前"}]
[3120,"播種20日後草目立てば土寄せ①は20～25日後(早めの実施)",{"$f":"IF(播種後草量=1,IF(播種日+植傷み+25>=土寄最遅+5,土寄最遅+5,土寄①始+5),土寄①終)","v":"2025-07-01"},"土寄①終修正",{"$f":"IF(C42=\"\",土寄①終,C42)","v":"2025-07-01"}]
[3125,"早めの実施の場合、土寄①と②整合",{"$f":"IF(土寄①始=\"土寄困難\",\"土寄困難\",IF(土寄①始>土寄①終修正,土寄①終修正,土寄①始))","v":"2025-06-21"},"土寄①始修正",{"$f":"C43","v":"2025-06-21"}]
[3130,"土寄せ②の入力確認",{"$f":"IF(土寄②=\"\",\"2回目未\",\"\")","v":"2回目未"},"2回目実施済みかどうか"]
[3140,"土寄せ②の5日後（2回目未 7日後）から茎葉剤",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,IF(土寄②=\"\",土寄②始+7,土寄②+5))","v":"2025-07-13"},"茎葉剤始期の原則"]
[3150,"土寄せ②から10日後（2回目未 7日後）までに茎葉剤",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,IF(土寄②=\"\",土寄②終+7,土寄②+10))","v":"2025-07-23"},"茎葉剤終期の原則"]
[3160,"土寄せ②後の茎葉剤は7/26期限（始め）",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,MIN(C45,土寄最遅))","v":"2025-07-13"},"茎葉剤始",{"$f":"C47","v":"2025-07-13"}]
[3170,"土寄せ②後の茎葉剤は7/26期限（終わり）",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,MIN(C46,土寄最遅))","v":"2025-07-23"},"茎葉剤終","2025-07-23"]
[3180,"土寄せ①後(5日)株間残草大きいかどうか判断",{"$f":"IF(土寄①<>\"\",IF(土寄①+5<判断日,\"株間草入力\",\"判断時期前\"),\"土寄①未入力\")","v":"土寄①未入力"},null,"土寄①未入力"]
[3190,"土寄①未入力なら土寄②始以後株間残草大きいかどうか判断",{"$f":"IF(入力表!C18<>3,\"入力済み\",IF(土寄①始修正=\"土寄困難\",\"判断時期前\",IF(土寄①=\"\",IF(土寄②始<=判断日,\"株間草入力\",\"判断時期前\"),C49)))","v":"判断時期前"},"株間草入力",{"$f":"C50","v":"判断時期前"}]
[3200,"土寄せ①後(5日)株間残草大きければ茎葉剤土寄せ②前処理",{"$f":"IF(株間草大=1,\"土寄せ前\",IF(株間草大=2,\"草小さい\",IF(株間草入力=\"判断時期前\",\"判断時期前\",\"株間草未入力\")))","v":"判断時期前"},"土寄前茎葉剤１","判断時期前"]
[3210,"草大きく茎葉剤前処理の場合は土寄せ②5日前から（始め）",{"$f":"IF(C51=\"土寄せ前\",土寄②始-5,\"土寄②後処理\")","v":"土寄②後処理"},"前茎葉剤始１","土寄②後処理"]
[3220,"草大きく茎葉剤前処理の場合は土寄せ②5日前から（終わり）",{"$f":"IF(C51=\"土寄せ前\",土寄②終-5,\"土寄②後処理\")","v":"土寄②後処理"},"前茎葉剤終１","土寄②後処理"]
[3230,"茎葉剤前処理の判断日（土寄②の終期７月２０日）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/20\")","v":"2025-07-20"},"(当該年)７月２０日"]
[3240,"土寄せ②７月２０日より遅れるなら土寄せ②前処理",{"$f":"IF(OR(AND(土寄②=\"\",土寄②終>C54),土寄②>C54),\"土寄せ前\",\"土寄せ後\")","v":"土寄せ後"},"土寄前茎葉剤２",{"$f":"C55","v":"土寄せ後"}]
[3250,"時期遅く土寄せ②前処理の場合前処理判断日の5日前（始め）",{"$f":"IF(C55=\"土寄せ前\",C54-5,\"土寄せ後処理\")","v":"土寄せ後処理"},"前茎葉剤始２","土寄せ後処理"]
[3260,"時期遅く土寄せ②前処理の場合土寄②終の5日前（終わり）",{"$f":"IF(C55=\"土寄せ前\",土寄期限-5,\"土寄せ後処理\")","v":"土寄せ後処理"},"前茎葉剤終２","土寄せ後処理"]
[3270,"茎葉剤処理が土寄せ②の前か後か",{"$f":"IF(OR(土寄前茎葉剤１=\"土寄せ前\",土寄前茎葉剤２=\"土寄せ前\"),\"土寄せ前\",\"土寄せ後\")","v":"土寄せ後"},"茎葉剤時期","土寄せ後"]
[3280,"茎葉剤判断のうち最も早い時期（始め）",{"$f":"IF(茎葉剤時期=\"土寄せ前\",MIN(前茎葉剤始１,前茎葉剤始２),茎葉剤始)","v":"2025-07-13"},"茎葉始","2025-07-13"]
[3290,"茎葉剤判断のうち最も早い時期（終わり）",{"$f":"IF(茎葉剤時期=\"土寄せ前\",MIN(前茎葉剤終１,前茎葉剤終２),茎葉剤終)","v":"2025-07-23"},"茎葉終","2025-07-23"]
[3300,"茎葉剤前処理の場合、土寄②始は茎葉終の５日後に修正",{"$f":"IF(茎葉剤時期=\"土寄せ前\",茎葉始+5,土寄②始)","v":"2025-07-06"},"土寄②始修正","2025-07-06"]
[20]
["摘心"]
[4100,"摘心を前提とする播種日　（５月３１日まで）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/5/31\")","v":"2025-05-31"},"摘心検討早播日",{"$f":"C64","v":"2025-05-31"}]
[4110,"播種が摘心を前提とする時期かどうか",{"$f":"IF(土寄①始修正=\"土寄困難\",\"摘心不要\",IF(AND(播種日<=摘心検討早播日,摘心=\"\"),\"摘心実施を考える\",\"入力で判断\"))","v":"入力で判断"},"摘心検討",{"$f":"C65","v":"入力で判断"}]
[4120,"主茎長で摘心を判断するのは　（７月１日以降）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/1\")","v":"2025-07-01"},"摘心判断時期",{"$f":"C66","v":"2025-07-01"}]
[4130,"摘心は播種後50日までに実施",{"$f":"播種日+50","v":"2025-07-21"},"播種後50日",null,{"$f":"播種日","v":"2025-06-01"}]
[4140,"摘心は開花前に実施　７月２８日まで",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/28\")","v":"2025-07-28"},"(当該年)７月２８日"]
[4150,"摘心実施を判断する時期なら、開花前茎長を入力",{"$f":"IF(土寄①始修正=\"土寄困難\",\"摘心不要\",IF(判断日>=摘心判断時期,\"開花前茎長を入力\",IF(摘心検討=\"摘心実施を考える\",摘心検討,\"7/1以降の主茎長で判断\")))","v":"7/1以降の主茎長で判断"},"開花前茎長入力",{"$f":"C69","v":"7/1以降の主茎長で判断"}]
[4160,"開花前茎長の入力値が50cm超なら摘心実施",{"$f":"IF(土寄①始修正=\"土寄困難\",\"摘心不要\",IF(開花前茎長=1,\"主茎長45cmで摘心\",IF(開花前茎長=2,\"摘心不要\",開花前茎長入力)))","v":"7/1以降の主茎長で判断"},"摘心実施",{"$f":"C70","v":"7/1以降の主茎長で判断"}]
[4170,"摘心は土寄②の後に実施（始め）",{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",IF(土寄②<>\"\",土寄②,土寄②始修正),摘心実施)","v":"7/1以降の主茎長で判断"},"摘心始",{"$f":"IF(摘心実施=\"\",\"\",C71)","v":"7/1以降の主茎長で判断"}]
[4180,"摘心は土寄②の7日後までに実施（終わり）",{"$f":"IF(土寄②=\"\",土寄期限+7,土寄②+7)","v":"2025-07-23"},"摘心終期の原則"]
[4190,"播種後50日、7/28、土寄②7日後いずれか早い日までに終える",{"$f":"MIN(C72,C68,C67)","v":"2025-07-21"},"摘心終",{"$f":"IF(摘心実施=\"\",\"\",C73)","v":"2025-07-21"}]
[4200,"摘心始～摘心終は5日間確保",{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",IF(摘心終-摘心始<5,摘心終-5,摘心始),摘心始)","v":"7/1以降の主茎長で判断"},"摘心始修正",{"$f":"C74","v":"7/1以降の主茎長で判断"}]
[11]

{"sheet":"コメント","index":4,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["黒大豆　土寄せ判断システム　コメントデータ"]
[]
[null,null,"数式","内容（名前）","コメント"]
[null,"判断日の設定（未入力時のガード）",{"$f":"IF(判断日入力=\"\",TODAY(),判断日入力)","v":"2025-06-01"},"判断日"]
[null,null,null,"初期除草剤",{"$f":"E12&E13&E14","v":""}]
[null,null,null,"定稙",{"$f":"E17&E18","v":""}]
[null,null,null,"土寄せ①",{"$f":"E50&E52&E53&E54","v":""}]
[null,null,null,"土寄せ②",{"$f":"E34&E35&E36","v":""}]
[null,null,null,"茎葉除草剤",{"$f":"E61&E65&E70&E71&E72&E73","v":""}]
[null,null,null,"摘心",{"$f":"E77&E81&E83&E86&E87&E88","v":""}]
["初期除草剤"]
[null,"除草剤なしの場合",null,"初期除草剤なし",{"$f":"IF(AND(播種日>0,初期除草剤=\"\",判断日-播種日>6),\"初期除草剤処理なし。雑草発生量を観察し、多ければ播種後25日以内に土寄せ。\",\"\")","v":""},"初期除草剤処理なし。雑草発生量を観察し、多ければ播種後25日以内に土寄せ。"]
[null,null,null,"適期処理",{"$f":"IF(初期除草剤<>\"\",IF(初期除草剤-播種日<4,F13,\"\"),\"\")","v":""},"適期内に実施。"]
[null,"播種後除草剤処理まで間隔が開いた場合",null,"初期除草剤遅れ",{"$f":"IF(初期除草剤-播種日>3,F14,\"\")","v":""},"播種後 除草剤処理まで間隔が開いたので、効果劣る。"]
[]
["定稙時期"]
[null,"定稙遅れの植え傷み（13日以上で2日、17日以上で3日）",{"$f":"IF(定稙日<播種日+13,0,IF(定稙日<播種日+17,2,3))","v":0},"植傷み",{"$f":"IF(植傷み>0,F17,\"\")","v":""},"定稙遅れで植え傷みの恐れ。"]
[null,null,null,null,{"$f":"IF(AND(定稙日<>\"\",植傷み=0),F18,\"\")","v":""},"定稙遅れなし。"]
["土寄せ時期"]
[1100,"１回目　直播後20～30日後に実施（始め）",{"$f":"播種日+20","v":"2025-06-21"},"土寄①始の原則"]
[1110,"１回目　直播後20～30日後に実施（終わり）",{"$f":"播種日+30","v":"2025-07-01"},"土寄①終の原則"]
[1115,"土寄①始原則が>7/26なら7/26(播種15日以内なら土寄困難）",{"$f":"IF(C20>土寄最遅,IF(土寄最遅-15<播種日,\"土寄困難\",土寄最遅),C20)","v":"2025-06-21"},"土寄①始"]
[1117,"土寄①始原則が>=7/26なら7/31(土寄困難なら\"\"）",{"$f":"IF(C20>土寄最遅,IF(土寄①始=\"土寄困難\",\"\",土寄最遅+5),IF(C21>土寄最遅+5,土寄最遅+5,C21))","v":"2025-07-01"},"土寄①終"]
[1200,"２回目　１回目未なら 15日後に実施（始め）",{"$f":"IF(土寄①=\"\",IF(土寄①始修正=\"土寄困難\",\"\",土寄①始+15),\"①入力済\")","v":"2025-07-06"},"①未実施の土寄②始"]
[1210,"２回目　１回目後なら12日後に実施（始め）",{"$f":"IF(土寄①<>\"\",土寄①+12,\"①未実施\")","v":"①未実施"},"①実施済みの土寄②始"]
[1220,"２回目　１回目未なら 15日後に実施（終わり）",{"$f":"IF(土寄①=\"\",IF(土寄①始=\"土寄困難\",\"\",土寄①終+15),\"①入力済\")","v":"2025-07-16"},"①未実施の土寄②終"]
[1230,"２回目　１回目後20日後に実施（終わり）",{"$f":"IF(土寄①<>\"\",土寄①+20,\"①未実施\")","v":"①未実施"},"①実施済みの土寄②終"]
[1240,"２回目　１回目遅れなら、 適期12日後と①7日後の遅い方（始め）",{"$f":"IF(土寄①>土寄①終,MAX(土寄①始+12,土寄①+7),\"遅れ処理なし\")","v":"遅れ処理なし"},"①遅れの土寄②始"]
[1250,"２回目　１回目遅れなら、 適期20日後と①10日後の遅い方（終わり）",{"$f":"IF(土寄①>土寄①終,MAX(土寄①終+20,土寄①+10),\"遅れ処理なし\")","v":"遅れ処理なし"},"①遅れの土寄②終"]
[1260,"２回目　土寄せ適期始め",{"$f":"MAX(C24,C25,C28)","v":"2025-07-06"},"土寄②始",{"$f":"C30","v":"2025-07-06"}]
[1270,"２回目　土寄せ適期終わり",{"$f":"MAX(C26,C27,C29)","v":"2025-07-16"},"土寄②終",{"$f":"C31","v":"2025-07-16"}]
[1280,"直播後50日後までに終える",{"$f":"播種日+50","v":"2025-07-21"},"播種50日後",{"$f":"C32","v":"2025-07-21"},null,{"$f":"C33","v":"2025-07-26"}]
[1290,"最遅日　７月２６日（開花前）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/26\")","v":"2025-07-26"},"土寄最遅",{"$f":"C33","v":"2025-07-26"},null,{"$f":"播種50日後","v":"2025-07-21"}]
[1300,"土寄②期限　播種後50日以内、7月26日まで（開花前）に終える",{"$f":"MIN(土寄最遅,播種50日後,土寄②終)","v":"2025-07-16"},"土寄期限",{"$f":"IF(土寄期限<土寄②,F34,\"\")","v":""},"土寄せ②適期遅れ。"]
[null,null,null,null,{"$f":"IF(AND(土寄②<>\"\",土寄②>=土寄②始修正,土寄②<=土寄期限),F35,\"\")","v":""},"適期内に実施。"]
[13,null,null,null,{"$f":"IF(土寄②>土寄最遅,F36,\"\")","v":""},"開花期に土寄せすると断根し、着莢不良を招く。"]
["降雨とトラクタ作業",null,null,null,null,null,{"$f":"地点名","v":"アメダス園部"}]
[2100,"参照するアメダス地点",{"$f":"アメダス地点","v":"園部"},"［入力表］の選択地点",null,"地点名",{"$f":"\"アメダス\"&C38","v":"アメダス園部"}]
[2110,"当日　作業できない降雨量mm",{"$f":"入力表!C26","v":2},"［入力表］下の降雨量判断条件（当日）"]
[2120,"翌日　作業できない降雨量mm",{"$f":"入力表!C27","v":10},"［入力表］下の降雨量判断条件（翌日）"]
[2130,"２日後　作業できない降雨量mm",{"$f":"入力表!C28","v":30},"［入力表］下の降雨量判断条件（２日後）"]
[2140,"（土寄①　適期内の作業可能な日数計算）","土寄①","適期日数",{"$f":"INDIRECT(地点名&\"!O111\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P111\")","v":5.3},"可能確率",{"$f":"INDIRECT(地点名&\"!D115\")","v":0.48181818181818181}]
[2150,"（土寄②　適期内の作業可能な日数計算）","土寄②","適期日数",{"$f":"INDIRECT(地点名&\"!O112\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P112\")","v":4.5999999999999996},"可能確率",{"$f":"INDIRECT(地点名&\"!E115\")","v":0.41818181818181815}]
[2160,"（除草剤　適期内の作業可能な日数計算）","除草剤","適期日数",{"$f":"INDIRECT(地点名&\"!O113\")","v":11},"可能日数",{"$f":"INDIRECT(地点名&\"!P113\")","v":6.6},"可能確率",{"$f":"INDIRECT(地点名&\"!F115\")","v":0.6}]
[2170,"（摘心　適期内の作業可能な日数計算）","摘心","適期日数",{"$f":"アメダス園部!O114","v":{"$error":"#VALUE!"}},"可能日数",{"$f":"アメダス園部!P114","v":{"$error":"#VALUE!"}},"可能確率",{"$f":"アメダス園部!G115","v":{"$error":"#VALUE!"}}]
[8]
["除草剤と土寄せ",null,"播種後20日","入力"]
[3100,"播種20日後草目立つかどうか判断",{"$f":"播種日+20","v":"2025-06-21"},"播種日20日後"]
[3110,"播種20日後草目立つかどうかの入力の要否",{"$f":"IF(AND(判断日>=C48,入力表!$C$16=\"\"),\"播種後草入力\",IF(入力表!$C$16<>\"\",\"入力済み\",\"判断日前\"))","v":"入力済み"},"播種後草入力",{"$f":"C49","v":"入力済み"}]
[3120,"播種20日後草目立てば土寄せ①は20～25日後(早めの実施)",{"$f":"IF(播種後草量=\"1 草多\",IF(播種日+25>=土寄最遅+5,土寄最遅+5,播種日+25),土寄①終)","v":"2025-07-01"},"土寄①終修正",{"$f":"IF(土寄①>土寄①終修正,F50,\"\")","v":""},"土寄せ①適期遅れ、その後の雑草の残存、生育停滞の恐れあり。"]
[3125,"早めの実施の場合、土寄①と②整合",{"$f":"IF(土寄①始=\"土寄困難\",\"土寄困難\",IF(土寄①始>土寄①終修正,土寄①終修正,土寄①始))","v":"2025-06-21"},"土寄①始修正"]
[null,null,null,null,{"$f":"IF(土寄①始修正=\"土寄困難\",\"\",IF(AND(土寄①>=土寄①始修正,IF(播種後草量<>\"\",土寄①<=土寄①終修正,土寄①<=土寄①始修正+5)),F52,\"\"))","v":""},"適期内に実施。"]
[null,null,null,null,{"$f":"IF(AND(土寄①<>\"\",播種後草量=\"1 草多\",土寄①<=土寄①終修正,株間草大<>\"2 草小\"),F53,\"\")","v":""},"雑草の発生多く、今後株間の雑草が次の土寄せまでに大きくなりすぎてないか要注意。"]
[3130,"土寄せ②の入力確認",{"$f":"IF(土寄②=\"\",\"2回目未\",\"\")","v":"2回目未"},"2回目実施済かどうか",{"$f":"IF(AND(土寄期限=土寄最遅,土寄②=\"\"),F54,\"\")","v":""},"土寄せが1回のみなら、開花期(7月末)までに雑草の処理(茎葉処理剤散布等)を検討。"]
[3140,"土寄せ②の5日後（2回目未 7日後）から茎葉剤",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,IF(土寄②=\"\",土寄②始+7,土寄②+5))","v":"2025-07-13"},"茎葉剤始期の原則"]
[3150,"土寄せ②から10日後（2回目未 7日後）までに茎葉剤",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,IF(土寄②=\"\",土寄②終+7,土寄②+10))","v":"2025-07-23"},"茎葉剤終期の原則"]
[3160,"土寄せ②後の茎葉剤は7/26期限（始め）",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,MIN(C55,土寄最遅))","v":"2025-07-13"},"茎葉剤始",{"$f":"C57","v":"2025-07-13"}]
[3170,"土寄せ②後の茎葉剤は7/26期限（終わり）",{"$f":"IF(土寄①始修正=\"土寄困難\",土寄最遅+5,MIN(C56,土寄最遅))","v":"2025-07-23"},"茎葉剤終","2025-07-23"]
[3180,"土寄せ①後(5日)株間残草大きいかどうか判断",{"$f":"IF(土寄①<>\"\",IF(土寄①+5<判断日,\"株間草入力\",\"判断時期前\"),\"土寄①未入力\")","v":"土寄①未入力"},null,"土寄①未入力"]
[3190,"土寄①未入力なら土寄②始以後株間残草大きいかどうか判断",{"$f":"IF(入力表!#REF!<>\"\",\"入力済み\",IF(土寄①始修正=\"土寄困難\",\"判断時期前\",IF(土寄①=\"\",IF(土寄②始<=判断日,\"株間草入力\",\"判断時期前\"),C59)))","v":{"$error":"#REF!"}},"株間草入力",{"$f":"C60","v":{"$error":"#REF!"}}]
[3200,"土寄せ①後(5日)株間残草大きければ茎葉剤土寄せ②前処理",{"$f":"IF(株間草大=\"1 草大\",\"土寄せ前\",IF(株間草大=\"2 草小\",\"草小さい\",IF(株間草入力=\"判断時期前\",\"判断時期前\",\"株間草未入力\")))","v":"判断時期前"},"土寄前茎葉剤１",{"$f":"IF(C61=\"土寄せ前\",F61,\"\")","v":""},"株間の草が大きくなりすぎると効かないので、早く処理。"]
[3210,"草多く茎葉剤前処理の場合は土寄せ②5日前から（始め）",{"$f":"IF(C61=\"土寄せ前\",土寄②始-5,\"土寄②後処理\")","v":"土寄②後処理"},"前茎葉剤始１","土寄②後処理"]
[3220,"草多く茎葉剤前処理の場合は土寄せ②5日前から（終わり）",{"$f":"IF(C61=\"土寄せ前\",土寄②終-5,\"土寄②後処理\")","v":"土寄②後処理"},"前茎葉剤終１","土寄②後処理"]
[3230,"茎葉剤前処理の判断日（土寄②の終期７月２０日）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/20\")","v":"2025-07-20"},"(当該年)７月２０日"]
[3240,"土寄せ②７月２０日より遅れるなら土寄せ②前処理",{"$f":"IF(OR(AND(土寄②=\"\",土寄②終>C64),土寄②>C64),\"土寄せ前\",\"土寄せ後\")","v":"土寄せ後"},"土寄前茎葉剤２",{"$f":"IF(C65=\"土寄せ前\",F65,\"\")","v":""},"2回目土寄せ後だと開花期になるので、土寄せ前に散布。"]
[3250,"時期遅く土寄せ②前処理の場合前処理判断日の5日前（始め）",{"$f":"IF(C65=\"土寄せ前\",C64-5,\"土寄せ後処理\")","v":"土寄せ後処理"},"前茎葉剤始２",{"$f":"C66","v":"土寄せ後処理"}]
[3260,"時期遅く土寄せ②前処理の場合土寄②終の5日前（終わり）",{"$f":"IF(C65=\"土寄せ前\",土寄期限-5,\"土寄せ後処理\")","v":"土寄せ後処理"},"前茎葉剤終２","土寄せ後処理"]
[3270,"茎葉剤処理が土寄せ②の前か後か",{"$f":"IF(OR(土寄前茎葉剤１=\"土寄せ前\",土寄前茎葉剤２=\"土寄せ前\"),\"土寄せ前\",\"土寄せ後\")","v":"土寄せ後"},"茎葉剤時期","土寄せ後"]
[3280,"茎葉剤判断のうち最も早い時期（始め）",{"$f":"IF(茎葉剤時期=\"土寄せ前\",MIN(前茎葉剤始１,前茎葉剤始２),茎葉剤始)","v":"2025-07-13"},"茎葉始","2025-07-13"]
[3290,"茎葉剤判断のうち最も早い時期（終わり）",{"$f":"IF(茎葉剤時期=\"土寄せ前\",MIN(前茎葉剤終１,前茎葉剤終２),茎葉剤終)","v":"2025-07-23"},"茎葉終",{"$f":"IF(C70<茎葉除草剤,F70,\"\")","v":""},"茎葉除草剤処理適期遅れ。"]
[null,"茎葉除草剤が未入力で茎葉終が7/26の時",null,null,{"$f":"IF(AND(茎葉除草剤=\"\",茎葉終=土寄最遅),F71,\"\")","v":""},"茎葉除草剤は7/26より遅れないよう処理（開花期は薬害の恐れ）。"]
[null,null,null,null,{"$f":"IF(茎葉除草剤>茎葉剤終,F72,\"\")","v":""},"開花期の除草剤処理は薬害の恐れ。"]
[null,null,null,null,{"$f":"IF(AND(茎葉除草剤>=茎葉始,茎葉除草剤<=茎葉終),F73,\"\")","v":""},"適期内に実施。"]
[3300,"茎葉剤前処理の場合、土寄②始は茎葉終の５日後に修正",{"$f":"IF(茎葉剤時期=\"土寄せ前\",茎葉始+5,土寄②始)","v":"2025-07-06"},"土寄②始修正"]
[20]
["摘心"]
[4100,"摘心を前提とする播種日　（５月３１日まで）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/5/31\")","v":"2025-05-31"},"摘心検討早播日",{"$f":"IF(AND(C77>=播種日,開花前茎長=\"2 短50cm\",判断日>=摘心判断時期+9),F77,\"\")","v":""},"5月中の播種にもかかわらず草丈小さく生育不良。"]
[4110,"播種が摘心を前提とする時期かどうか",{"$f":"IF(AND(播種日<=摘心検討早播日,摘心=\"\"),\"摘心実施を考える\",\"入力で判断\")","v":"入力で判断"},"摘心検討",{"$f":"C78","v":"入力で判断"}]
[4120,"主茎長で摘心を判断するのは　（７月１日以降）",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/1\")","v":"2025-07-01"},"摘心判断時期",{"$f":"C79","v":"2025-07-01"}]
[4130,"摘心は播種後50日までに実施",{"$f":"播種日+50","v":"2025-07-21"},"播種後50日"]
[4140,"摘心は開花前に実施　７月２８日まで",{"$f":"DATEVALUE(TEXT(YEAR(判断日),\"####\")&\"/7/28\")","v":"2025-07-28"},"(当該年)７月２８日",{"$f":"IF(摘心>C81,F81,\"\")","v":""},"摘心実施が開花期で、葉の切除で着莢に悪影響。"]
[4150,"摘心実施を判断する時期なら、開花前茎長を入力",{"$f":"IF(判断日>=摘心判断時期,\"開花前茎長を入力\",IF(摘心検討=\"摘心実施を考える\",摘心検討,\"7/1以降の主茎長で判断\"))","v":"7/1以降の主茎長で判断"},"開花前茎長入力",{"$f":"C82","v":"7/1以降の主茎長で判断"}]
[4160,"開花前茎長の入力値が50cm超なら摘心実施",{"$f":"IF(開花前茎長=\"1 超50cm\",\"主茎長45cmで摘心\",IF(開花前茎長=\"2 短50cm\",\"摘心不要\",開花前茎長入力))","v":"7/1以降の主茎長で判断"},"摘心実施",{"$f":"IF(AND(摘心=\"\",開花前茎長=\"1 超50cm\"),F83,\"\")","v":""},"草丈大きいと無摘心では倒伏の恐れ有り、草姿悪い。"]
[4170,"摘心は土寄②の後に実施（始め）",{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",IF(土寄②<>\"\",土寄②,土寄②始修正),摘心実施)","v":"7/1以降の主茎長で判断"},"摘心始",{"$f":"IF(摘心実施=\"\",\"\",C84)","v":"7/1以降の主茎長で判断"}]
[4180,"摘心は土寄②の7日後までに実施（終わり）",{"$f":"IF(土寄②=\"\",土寄期限+7,土寄②+7)","v":"2025-07-23"},"摘心終期の原則"]
[4190,"播種後50日、7/28、土寄②7日後いずれか早い日までに終える",{"$f":"MIN(C85,C81,C80)","v":"2025-07-21"},"摘心終",{"$f":"IF(摘心<>\"\",IF(AND(摘心>=摘心始修正,摘心<=摘心終),F86,\"\"),\"\")","v":""},"適期内に実施。"]
[null,null,null,null,{"$f":"IF(摘心-播種日>50,F87,\"\")","v":""},"草姿を改善するためには、播種後50日以内に実施。"]
[4200,"摘心始～摘心終は5日間確保",{"$f":"IF(摘心実施=\"主茎長45cmで摘心\",IF(摘心終-摘心始<5,摘心終-5,摘心始),摘心始)","v":"7/1以降の主茎長で判断"},"摘心始修正",{"$f":"IF(AND(摘心=\"\",摘心終<=土寄期限),F88,\"\")","v":""},"土寄せ②後実施が原則だが、草姿を改善するために、土寄せ前でも実施（播種後50日以内）。"]
[11]

{"sheet":"アメダス園部","index":5,"n_rows":115,"n_cols":31,"rows_kept":115,"cut":false,"hidden":false,"merged":[[104,1,105,3],[104,5,104,6]]}
[null,"降雨日から見た黒大豆作業の検討",null,null,null,null,null,null,null,{"$f":"\"（\"&C3&\"～\"&L3&\"年平均）\"","v":"（2024～2015年平均）"}]
[null,"アメダス園部データ"]
["月","日",2024,2023,2022,2021,2020,2019,2018,2017,2016,2015,2014,null,null,null,{"$f":"C3","v":2024},2023,2022,2021,2020,2019,2018,2017,2016,2015,2014]
[4,29,16,8.5,50,71.5,0,16,0,3.5,0,0,54.5,null,"2019-04-29",null,{"$f":"IF(C4>=$C$108,1,\"\")","v":1},1,1,1,"",1,"",1,"","",1]
[4,30,11.5,16.5,0,0.5,0,22,0,0,0,0,16,null,"2019-04-30",null,{"$f":"IF(C5>=$C$108,1,IF(C4>=$C$109,1,\"\"))","v":1},1,1,1,"",1,"","","","",1]
[5,1,3.5,0.5,21,4,0,7.5,0,0,0,0,2.5,0,"2019-05-01",null,{"$f":"IF(C6>=$C$108,1,IF(C5>=$C$109,1,IF(C4>=$C$110,1,\"\")))","v":1},{"$f":"IF(D6>=$C$108,1,IF(D5>=$C$109,1,IF(D4>=$C$110,1,\"\")))","v":1},{"$f":"IF(E6>=$C$108,1,IF(E5>=$C$109,1,IF(E4>=$C$110,1,\"\")))","v":1},{"$f":"IF(F6>=$C$108,1,IF(F5>=$C$109,1,IF(F4>=$C$110,1,\"\")))","v":1},{"$f":"IF(G6>=$C$108,1,IF(G5>=$C$109,1,IF(G4>=$C$110,1,\"\")))","v":""},{"$f":"IF(H6>=$C$108,1,IF(H5>=$C$109,1,IF(H4>=$C$110,1,\"\")))","v":1},{"$f":"IF(I6>=$C$108,1,IF(I5>=$C$109,1,IF(I4>=$C$110,1,\"\")))","v":""},{"$f":"IF(J6>=$C$108,1,IF(J5>=$C$109,1,IF(J4>=$C$110,1,\"\")))","v":""},{"$f":"IF(K6>=$C$108,1,IF(K5>=$C$109,1,IF(K4>=$C$110,1,\"\")))","v":""},{"$f":"IF(L6>=$C$108,1,IF(L5>=$C$109,1,IF(L4>=$C$110,1,\"\")))","v":""},{"$f":"IF(M6>=$C$108,1,IF(M5>=$C$109,1,IF(M4>=$C$110,1,\"\")))","v":1}]
[5,2,0,0,0.5,3.5,0,0,7.5,0,0,0,0,1,"2019-05-02",null,"","",1,1,"","",1,"","","",""]
[5,3,0,0,0,0,1,0,1.5,0,6.5,2,0,2,"2019-05-03",null,"","","","","","","","",1,1,""]
[5,4,0,0,0,0,2.5,0,1.5,0,1,3.5,0,3,"2019-05-04",null,"","","","",1,"","","","",1,""]
[5,5,0,0,0,16,0,0,0,0,0,0,0.5,4,"2019-05-05",null,"","","",1,"","","","","","",""]
[5,6,5.5,1.5,0,0,0,7,10.5,0,6,0,0,5,"2019-05-06",null,1,"","",1,"",1,1,"",1,"",""]
[5,7,17,87,0,1.5,0,0,31,0,0,1,0,6,"2019-05-07",null,1,1,"","","","",1,"","","",""]
[5,8,0,19.5,0,0,0,0,10.5,0,0,1,0,7,"2019-05-08",null,1,1,"","","","",1,"","","",""]
[5,9,0,0,0,0,2.5,0,5,5,14.5,0,0,8,"2019-05-09",null,"",1,"","",1,"",1,1,1,"",""]
[5,10,0,0,0,0,4.5,0,0,2,3.5,0,0,9,"2019-05-10",null,"","","","",1,"","",1,1,"",""]
[5,11,0,0,0.5,0,0,0,0,0,24,0,0,10,"2019-05-11",null,"","","","","","","","",1,"",""]
[5,12,7.5,0,9.5,2.5,0,0,0,1.5,0,50.5,7.5,11,"2019-05-12",null,1,"",1,1,"","","","",1,1,1]
[5,13,21.5,9,11,5,0,0,47.5,24.5,0,0,3,12,"2019-05-13",null,1,1,1,1,"","",1,1,"",1,1]
[5,14,0,9.5,10.5,0,0,0,0,0,0,1,0,13,"2019-05-14",null,1,1,1,"","","",1,1,"",1,""]
[5,15,0,0,0,0.5,5,0,0,0,0,0,2,14,"2019-05-15",null,"","",1,"",1,"",1,"","","",1]
[5,16,0,0,0,4.5,33,0,0,0,72.5,34.5,0,15,"2019-05-16",null,"","","",1,1,"","","",1,1,""]
[5,17,0,0,0,14,0,0,0,0,1,0,0,16,"2019-05-17",null,"","","",1,1,"","","",1,1,""]
[5,18,0,0,0,3,23,0,15,0,0,11,0,17,"2019-05-18",null,"","","",1,1,"",1,"",1,1,""]
[5,19,3.5,39,0,1,1,0,2.5,0,0,6.5,0,18,"2019-05-19",null,1,1,"","",1,"",1,"","",1,""]
[5,20,1,0.5,0,36.5,0,9,0,0,0,2,18.5,19,"2019-05-20",null,"",1,"",1,"",1,"","","",1,1]
[5,21,0,0,0,27.5,0,30.5,0,0,0,0,47.5,20,"2019-05-21",null,"",1,"",1,"",1,"","","","",1]
[5,22,0,2,5,1,0,0,0,0,0,0,0,21,"2019-05-22",null,"",1,1,1,"",1,"","","","",1]
[5,23,0,4,0,0,0,1,7.5,0,0,0,0,22,"2019-05-23",null,"",1,"","","",1,1,"","","",1]
[5,24,0,1,0,2.5,0,0,0.5,3.5,0,0,0,23,"2019-05-24",null,"","","",1,"","","",1,"","",""]
[5,25,0,1.5,0,0,0,0,0,18.5,0,0,0,24,"2019-05-25",null,"","","","","","","",1,"","",""]
[5,26,0,0,4,0,18.5,0,0,0,0.5,0,5.5,25,"2019-05-26",null,"","",1,"",1,"","",1,"","",1]
[5,27,16.5,0,5,35,0,0,0,0,2.5,0,0,26,"2019-05-27",null,1,"",1,1,1,"","","",1,"",""]
[5,28,134.5,0,0,0,0,32.5,0,0,0,0,0,27,"2019-05-28",null,1,"","",1,"",1,"","","","",""]
[5,29,0.5,38.5,0,0,0,0,0,0,8,0,0,28,"2019-05-29",null,1,1,"",1,"",1,"","",1,"",""]
[5,30,0,6.5,1.5,0,0,0,13,0,7,0,0,29,"2019-05-30",null,1,1,"","","",1,1,"",1,"",""]
[5,31,2.5,0,2,0,2,0,21.5,1.5,0,0,0,30,"2019-05-31",null,1,1,1,"",1,"",1,"","","",""]
[6,1,0.5,9.5,0,0,0,0,0,21.5,0,0,0,31,"2019-06-01",null,"",1,"","","","",1,1,"","",""]
[6,2,0,85,0,0,0,0,0,0,0,0,0,32,"2019-06-02",null,{"$f":"IF(C38>=$C$108,1,IF(C37>=$C$109,1,IF(C36>=$C$110,1,\"\")))","v":""},{"$f":"IF(D38>=$C$108,1,IF(D37>=$C$109,1,IF(D36>=$C$110,1,\"\")))","v":1},{"$f":"IF(E38>=$C$108,1,IF(E37>=$C$109,1,IF(E36>=$C$110,1,\"\")))","v":""},{"$f":"IF(F38>=$C$108,1,IF(F37>=$C$109,1,IF(F36>=$C$110,1,\"\")))","v":""},{"$f":"IF(G38>=$C$108,1,IF(G37>=$C$109,1,IF(G36>=$C$110,1,\"\")))","v":""},{"$f":"IF(H38>=$C$108,1,IF(H37>=$C$109,1,IF(H36>=$C$110,1,\"\")))","v":""},{"$f":"IF(I38>=$C$108,1,IF(I37>=$C$109,1,IF(I36>=$C$110,1,\"\")))","v":""},{"$f":"IF(J38>=$C$108,1,IF(J37>=$C$109,1,IF(J36>=$C$110,1,\"\")))","v":1},{"$f":"IF(K38>=$C$108,1,IF(K37>=$C$109,1,IF(K36>=$C$110,1,\"\")))","v":""},{"$f":"IF(L38>=$C$108,1,IF(L37>=$C$109,1,IF(L36>=$C$110,1,\"\")))","v":""},{"$f":"IF(M38>=$C$108,1,IF(M37>=$C$109,1,IF(M36>=$C$110,1,\"\")))","v":""}]
[6,3,0,0,0,0.5,0,0,0,0,0,40.5,0,33,"2019-06-03",null,"",1,"","","","","","","",1,""]
[6,4,0,0,0,36.5,0,0,0,0,4.5,0,0.5,34,"2019-06-04",null,"",1,"",1,"","","","",1,1,""]
[6,5,0,0,7.5,0,0,0,3,0,13,23,2,35,"2019-06-05",null,"","",1,1,"","",1,"",1,1,1]
[6,6,0,2,33.5,0,0,0,47,0,0,1,1.5,36,"2019-06-06",null,"",1,1,1,"","",1,"",1,1,""]
[6,7,0,0,2.5,0,0,25,6,22,5,0,5.5,37,"2019-06-07",null,"","",1,"","",1,1,1,1,"",1]
[6,8,1,10.5,0,0,0,0,10,0.5,0,3,2,38,"2019-06-08",null,"",1,1,"","",1,1,1,"",1,1]
[6,9,10,9,0,0,0,0,1,0,1,12.5,0.5,39,"2019-06-09",null,1,1,"","","","",1,"","",1,""]
[6,10,0,0,0,0,7.5,0,9,0,0,0,0.5,40,"2019-06-10",null,1,"","","",1,"",1,"","",1,""]
[6,11,0,9,1.5,0,18,0,11,0,0,3.5,2.5,41,"2019-06-11",null,"",1,"","",1,"",1,"","",1,1]
[6,12,0,2.5,0,0,17,0,2,0,24,1,13,42,"2019-06-12",null,"",1,"","",1,"",1,"",1,"",1]
[6,13,0,0,0,13.5,59.5,0,0,0,28,0,0,43,"2019-06-13",null,"","","",1,1,"","","",1,"",1]
[6,14,0,8,16,6,15,0,0,0,0,0,0,44,"2019-06-14",null,"",1,1,1,1,"","","",1,"",""]
[6,15,0,8,2.5,18.5,0,27.5,5,0,0,0,0,45,"2019-06-15",null,"",1,1,1,1,1,1,"","","",""]
[6,16,13,0,0,12,0,3.5,0,0,18.5,3,0,46,"2019-06-16",null,1,"","",1,"",1,"","",1,1,""]
[6,17,4,0,0,0,0,0,0,0,1,12.5,0,47,"2019-06-17",null,1,"","",1,"","","","",1,1,""]
[6,18,40,0,0,4,23,0,0,0,0,6,0.5,48,"2019-06-18",null,1,"","",1,1,"","","","",1,""]
[6,19,0,0,0,14,55,0,2.5,0,10,12,0,49,"2019-06-19",null,1,"","",1,1,"",1,"",1,1,""]
[6,20,0,0,0,0,0,0,38.5,0.5,3,1,0,50,"2019-06-20",null,1,"","",1,1,"",1,"",1,1,""]
[6,21,13,0,20,0,0,0,0,49.5,29,12,0,51,"2019-06-21",null,1,"",1,"",1,"",1,1,1,1,""]
[6,22,14.5,31.5,9.5,0,0,0,0,0,14.5,0,5,52,"2019-06-22",null,1,1,1,"","","",1,1,1,1,1]
[6,23,17,2.5,0,0,0,0,10,0,18,0.5,0.5,53,"2019-06-23",null,1,1,"","","","",1,1,1,"",""]
[6,24,0,0,0,12,0,0,0,3,12,22.5,0,54,"2019-06-24",null,1,1,"",1,"","",1,1,1,1,""]
[6,25,0,0,5.5,0,3.5,0,0,6,23,0,0,55,"2019-06-25",null,"","",1,1,1,"","",1,1,1,""]
[6,26,0,18,0,0,3.5,0.5,0,0,0,25,7.5,56,"2019-06-26",null,"",1,"","",1,"","","",1,1,1]
[6,27,5,0.5,0,0,0,14,0,0.5,24,0,0,57,"2019-06-27",null,1,1,"","","",1,"","",1,1,""]
[6,28,67,6,0,0,17.5,0.5,12,5.5,9,1,15,58,"2019-06-28",null,1,1,"","",1,1,1,1,1,"",1]
[6,29,2.5,6,0,1.5,0,2,47,1,14,0,21,59,"2019-06-29",null,1,1,"","",1,1,1,"",1,"",1]
[6,30,6.5,10.5,0,2.5,47,26.5,4,44,2.5,14.5,0,60,"2019-06-30",null,1,1,"",1,1,1,1,1,1,1,1]
[7,1,34,8.5,0,13,3.5,4.5,0,5.5,0,18,0,61,"2019-07-01",null,{"$f":"IF(C67>=$C$108,1,IF(C66>=$C$109,1,IF(C65>=$C$110,1,\"\")))","v":1}]
[7,2,6.5,0,0,3,0,1,0,40,0,0,0,62,"2019-07-02",null,1]
[7,3,0,0,86.5,0.5,38,4.5,0,0,7,0,13,63,"2019-07-03",null,1,{"$f":"IF(D69>=$C$108,1,IF(D68>=$C$109,1,IF(D67>=$C$110,1,\"\")))","v":""},{"$f":"IF(E69>=$C$108,1,IF(E68>=$C$109,1,IF(E67>=$C$110,1,\"\")))","v":1},{"$f":"IF(F69>=$C$108,1,IF(F68>=$C$109,1,IF(F67>=$C$110,1,\"\")))","v":""},{"$f":"IF(G69>=$C$108,1,IF(G68>=$C$109,1,IF(G67>=$C$110,1,\"\")))","v":1},{"$f":"IF(H69>=$C$108,1,IF(H68>=$C$109,1,IF(H67>=$C$110,1,\"\")))","v":1},{"$f":"IF(I69>=$C$108,1,IF(I68>=$C$109,1,IF(I67>=$C$110,1,\"\")))","v":""},{"$f":"IF(J69>=$C$108,1,IF(J68>=$C$109,1,IF(J67>=$C$110,1,\"\")))","v":1},{"$f":"IF(K69>=$C$108,1,IF(K68>=$C$109,1,IF(K67>=$C$110,1,\"\")))","v":1},{"$f":"IF(L69>=$C$108,1,IF(L68>=$C$109,1,IF(L67>=$C$110,1,\"\")))","v":""},{"$f":"IF(M69>=$C$108,1,IF(M68>=$C$109,1,IF(M67>=$C$110,1,\"\")))","v":1}]
[7,4,7.5,0,6,1,13,4.5,23.5,30.5,0,13,9.5,64,"2019-07-04",null,1,"",1,"",1,1,1,1,"",1,1]
[7,5,0,10.5,1.5,0,0,0,175,16.5,0,0,8.5,65,"2019-07-05",null,"",1,1,"",1,"",1,1,"",1,1]
[7,6,22.5,0,0,0,31,0,91.5,0,0,0.5,25,66,"2019-07-06",null,1,1,"","",1,"",1,1,"","",1]
[7,7,0,0.5,0,76,10.5,0,70,0.5,0,11.5,1.5,67,"2019-07-07",null,1,"","",1,1,"",1,"","",1,1]
[7,8,0,2.5,1,17.5,61,0,0,0,3,1.5,0,68,"2019-07-08",null,"",1,"",1,1,"",1,"",1,1,""]
[7,9,15.5,13,33,6.5,2.5,0,0,28,18,5,0,69,"2019-07-09",null,1,1,1,1,1,"",1,1,1,1,""]
[7,10,1.5,1,7.5,1,75.5,0,0,0.5,0,0,14.5,70,"2019-07-10",null,1,1,1,"",1,"","",1,1,"",1]
[7,11,13.5,0,0,7.5,10.5,19.5,0,0,0,0,12.5,71,"2019-07-11",null,1,"",1,1,1,1,"","","","",1]
[7,12,20,36,40,2.5,1,2,0,0,5,0,0,72,"2019-07-12",null,1,1,1,1,1,1,"","",1,"",1]
[7,13,0,30,1.5,47,25,11,0,0,16,0,7,73,"2019-07-13",null,1,1,1,1,1,1,"","",1,"",1]
[7,14,11,0,13.5,0,26.5,20.5,0,0,11,0,0.5,74,"2019-07-14",null,1,1,1,1,1,1,"","",1,"",""]
[7,15,25.5,0,3,5.5,0,2,0,0,0,0,0,75,"2019-07-15",null,1,1,1,1,1,1,"","",1,"",""]
[7,16,9.5,0.5,0.5,3,0,1,0,15,0,22.5,0,76,"2019-07-16",null,1,"","",1,"","","",1,"",1,""]
[7,17,3.5,0,2.5,0,1.5,0,0,19,1.5,135,0,77,"2019-07-17",null,1,"",1,"","","","",1,"",1,""]
[7,18,0,0,0,0,4,13,0,28,0,13,5.5,78,"2019-07-18",null,"","","","",1,1,"",1,"",1,1]
[7,19,0,1,43.5,0,0,20.5,0,0,0,2,4,79,"2019-07-19",null,"","",1,"","",1,"",1,"",1,1]
[7,20,0,0,0,0,0,0.5,0,0,0,0,0,80,"2019-07-20",null,"","",1,"","",1,"","","","",""]
[7,21,0,0,4,0,36,0,0,0,0,0,0,81,"2019-07-21",null,"","",1,"",1,"","","","","",""]
[7,22,6.5,0,18,0,1,21.5,0,0,0,16.5,0,82,"2019-07-22",null,1,"",1,"",1,1,"","","",1,""]
[7,23,0,0,3.5,0,0,3.5,0,0,0,18,0,83,"2019-07-23",null,"","",1,"",1,1,"","","",1,""]
[7,24,12.5,0,0,0,29.5,0,0,0,0,0,0,84,"2019-07-24",null,1,"","","",1,"","","","",1,""]
[7,25,0,0,0,0,33.5,2.5,0,2.5,0,0,0,85,"2019-07-25",null,1,"","","",1,1,"",1,"","",""]
[7,26,0,0,0,0,4,0.5,0,1,19,0,0,86,"2019-07-26",null,"","","","",1,"","","",1,"",""]
[7,27,0,0,9,0,2,10.5,0.5,3.5,0,0,13.5,87,"2019-07-27",null,"","",1,"",1,1,"",1,1,"",1]
[7,28,0,0,0,0,0.5,0,0,0,0,40.5,0,88,"2019-07-28",null,"","","","","",1,"","","",1,1]
[7,29,0,0,0,0,2,0,21.5,0,0,10,0,89,"2019-07-29",null,"","","","",1,"",1,"","",1,""]
[7,30,0,0,0,0,5,0,0,8.5,0,0,0,90,"2019-07-30",null,"","","","",1,"",1,1,"",1,""]
[7,31,0,0,0,0,0,0,0,8.5,0,0,0,91,"2019-07-31",null,"","","","","","","",1,"","",""]
[8,1,0,0,0,0.5,0,0,0,0,0,0,0,92,"2019-08-01",null,"","","","","","","","","","",""]
[8,2,0,0,0,0,0,0,0,0,0,0,0,93,"2019-08-02",null,"","","","","","","","","","",""]
[8,3,0,0,5.5,28,0,0,0,0,0,0,3,94,"2019-08-03",null,"","",1,1,"","","","","","",1]
[8,4,0,0,15.5,0,0,0,0,0,0,0,6.5,95,"2019-08-04",null,"","",1,1,"","","","","","",1]
[8,5,0,0,0,0,0,0,0,0,0,0,0,96,"2019-08-05",null,"","",1,"","","","","","","",""]
[8,6,0,0,0,0,0,1.5,0,0,0,0,49,97,"2019-08-06",null,"","","","","","","","","","",1]
[]
[null,"土寄せ作業可能か\nどうかの判断条件",null,null,"判断日",{"$f":"判断日","v":"2025-06-01"},null,null,"判断年",{"$f":"YEAR(判断日)","v":2025},null,null,null,null,null,"可能日の",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,"適期始","適期終",null,null,"5/1から数えて",null,null,null,null,null,"10年平均","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","近5年平均","近3年平均","最多日数","最少日数"]
[null,"作業できない降雨量mm",null,null,"土寄①",{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"土寄①終修正","v":"2025-07-01"},null,"土寄①適期始は",{"$f":"$F$107-DATEVALUE(TEXT(判断年,\"####\")&\"/5/1\")","v":51},"日後",null,null,null,"5月",{"$f":"AVERAGE(Q107:Z107)","v":19.5},{"$f":"31-SUM(Q$6:Q$36)","v":18},{"$f":"31-SUM(R$6:R$36)","v":17},{"$f":"31-SUM(S$6:S$36)","v":21},15,20,22,18,24,19,21,22,{"$f":"AVERAGE(Q107:U107)","v":18.2},{"$f":"AVERAGE(Q107:S107)","v":18.666666666666668},{"$f":"MAX(Q107:Z107)","v":24},{"$f":"MIN(Q107:Z107)","v":15}]
[null,"当日",{"$f":"入力表!C26","v":2},"mm","土寄②",{"$f":"土寄②始修正","v":"2025-07-06"},{"$f":"土寄②終","v":"2025-07-16"},null,"土寄①適期終は",{"$f":"$G$107-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":61},"日後",null,null,null,"6月",14.9,{"$f":"30-SUM(Q$37:Q$66)","v":15},{"$f":"30-SUM(R$37:R$66)","v":11},{"$f":"30-SUM(S$37:S$66)","v":21},16,15,22,11,19,9,10,19,{"$f":"AVERAGE(Q108:U108)","v":15.6},{"$f":"AVERAGE(Q108:S108)","v":15.666666666666666},{"$f":"MAX(Q108:Z108)","v":22},{"$f":"MIN(Q108:Z108)","v":9}]
[null,"翌日",{"$f":"入力表!C27","v":10},"mm","除草剤",{"$f":"茎葉始","v":"2025-07-13"},{"$f":"茎葉終","v":"2025-07-23"},null,"土寄②適期始は",{"$f":"$F$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":66},"日後",null,null,null,"7月",17.2,{"$f":"31-SUM(Q$67:Q$97)","v":13},{"$f":"31-SUM(R$67:R$97)","v":22},{"$f":"31-SUM(S$67:S$97)","v":14},22,8,16,23,17,21,16,18,15.8,16.333333333333332,23,8]
[null,"２日後",{"$f":"入力表!C28","v":30},"mm","摘心",{"$f":"摘心始","v":"7/1以降の主茎長で判断"},{"$f":"摘心終","v":"2025-07-21"},null,"土寄②適期終は",{"$f":"$G$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":76},"日後",null,null,null,"6/25-7/24",15.5,{"$f":"30-SUM(Q$61:Q$90)","v":9},{"$f":"31-SUM(R$61:R$90)","v":17},{"$f":"31-SUM(S$61:S$90)","v":14},20,8,15,22,18,17,15,16,13.6,13.333333333333334,22,8]
[null,null,"↑",null,null,null,null,null,"除草剤適期始行",{"$f":"$F$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":73},"日後",null,null,"土寄せ①適期日数",{"$f":"G107-F107+1","v":11},5.3,{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,Q$105,$J$108-$J$107+1,1))","v":11},{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,R105,$J$108-$J$107+1,1))","v":2},3,8,8,5,7,4,4,1,4,6.4,5.333333333333333,11,1]
[null,null,"入力された条件",null,null,null,null,null,"除草剤適期終行",{"$f":"$G$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":83},"日後",null,null,"土寄せ②適期日数",{"$f":"G108-F108+1","v":11},4.5999999999999996,{"$f":"$O112-SUM(OFFSET(表の5月1日位置,$J$109,Q$105,$J$110-$J$109+1,1))","v":11},1,3,4,2,1,6,7,7,4,7,4.2,5,11,1]
[null,null,null,null,null,null,null,null,"摘心適期始行",{"$f":"$F$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":{"$error":"#VALUE!"}},"日後",null,null,"除草剤適期日数",{"$f":"G109-F109+1","v":11},6.6,{"$f":"$O113-COUNTIF(OFFSET(表の5月1日位置,$J$111,-13+Q$105,$J$112-$J$111+1,1),\">=1\")","v":6},9,3,8,5,3,11,8,8,5,8,6.2,6,11,3]
[null,null,null,"土寄①","土寄②","除草剤","摘心",null,"摘心適期終行",{"$f":"$G$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":81},"日後",null,null,"摘心適期日数",{"$f":"G110-F110+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"$O114-COUNTIF(OFFSET(表の5月1日位置,$J$113,-13+Q$105,$J$114-$J$113+1,1),\">=1\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["適期作業の確率",null,null,{"$f":"P111/O111","v":0.48181818181818181},{"$f":"P112/O112","v":0.41818181818181815},{"$f":"P113/O113","v":0.6},{"$f":"P114/O114","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"7月の1mm以上降雨日数",{"$f":"AVERAGE(R115:AA115)","v":12.4},{"$f":"COUNTIF(C67:C97,\">=1\")","v":14},8,16,12,22,16,5,13,8,13,11,{"$f":"AVERAGE(R115:V115)","v":14.8},{"$f":"AVERAGE(R115:T115)","v":12},{"$f":"MAX(R115:AA115)","v":22},{"$f":"MIN(R115:AA115)","v":5}]

{"sheet":"アメダス美山","index":6,"n_rows":115,"n_cols":31,"rows_kept":115,"cut":false,"hidden":false,"merged":[[104,1,105,3],[104,5,104,6]]}
[null,"降雨日から見た黒大豆作業の検討",null,null,null,null,null,null,null,{"$f":"\"（\"&C3&\"～\"&L3&\"年平均）\"","v":"（2022～2013年平均）"}]
[null,"アメダス美山データ"]
["月","日",2022,2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,null,null,null,{"$f":"C3","v":2022},2021,2020,2019,2018,2017,2016,2015,2014,2013,2012]
[4,29,53,66.5,0,18,0,6.5,0.5,0,37,0,0,null,"2019-04-29",null,{"$f":"IF(C4>=$C$108,1,\"\")","v":1},1,"",1,"",1,"","",1,"",""]
[4,30,0.5,0.5,0,17,0,0,0,0,7.5,5.5,0,null,"2019-04-30",null,{"$f":"IF(C5>=$C$108,1,IF(C4>=$C$109,1,\"\"))","v":1},1,"",1,"","","","",1,1,""]
[5,1,25.5,5,0,10,0,0,0,0,0,3,0,0,"2019-05-01",null,{"$f":"IF(C6>=$C$108,1,IF(C5>=$C$109,1,IF(C4>=$C$110,1,\"\")))","v":1},1,"",1,"","","","",1,1,""]
[5,2,0,10,0,0,5,0,0,0,0,3.5,17,1,"2019-05-02",null,1,1,"",1,1,"","","","",1,1]
[5,3,0,0,0.5,0,2.5,0,4,0,0,0,1,2,"2019-05-03",null,"",1,"","",1,"",1,"","","",1]
[5,4,0,0,1,0,0.5,0,4,6,0,2,3.5,3,"2019-05-04",null,"","","","","","",1,1,"",1,1]
[5,5,0,11,0,0,0,0,0,0,0,0,0,4,"2019-05-05",null,"",1,"","","","","","","","",""]
[5,6,0,0,3.5,21,16.5,2,14,0,0,0,5,5,"2019-05-06",null,"",1,1,1,1,1,1,"","","",1]
[5,7,0,0.5,0,0,43,0,0,1,0,0,5.5,6,"2019-05-07",null,"","","",1,1,"",1,"","","",1]
[5,8,0,0,0,0,11,0,0,1,1,0,0,7,"2019-05-08",null,"","","","",1,"","","","","",""]
[5,9,0,0.5,4.5,0,8.5,4.5,11,0,3.5,0,0,8,"2019-05-09",null,"","",1,"",1,1,1,"",1,"",""]
[5,10,0,0,5,0,0,5,1.5,0,0,6.5,0,9,"2019-05-10",null,"","",1,"","",1,1,"","",1,""]
[5,11,0,0,0,0,0,0,33.5,0,0,12.5,0,10,"2019-05-11",null,"","","","","","",1,"","",1,""]
[5,12,7.5,1.5,0,0,0,0.5,0,49,9,0,1.5,11,"2019-05-12",null,1,"","","","","",1,1,1,1,""]
[5,13,13.5,0,0,0,51,27,0,0,1.5,0,0,12,"2019-05-13",null,1,"","","",1,1,1,1,"","",""]
[5,14,15,0,0,0.5,0.5,0,0,0,0,0,0.5,13,"2019-05-14",null,1,"","","",1,1,"",1,"","",""]
[5,15,0,0,2,0,0,0,0,0,6.5,0,7.5,14,"2019-05-15",null,1,"",1,"",1,"","","",1,"",1]
[5,16,0,7,51,0,0,0,60.5,34,0,0,0,15,"2019-05-16",null,"",1,1,"","","",1,1,"","",""]
[5,17,0,34,0,0,0,0,2.5,0,0,0,0,16,"2019-05-17",null,"",1,1,"","","",1,1,"","",""]
[5,18,0,1.5,17,0,13.5,0,0,8,0,0,0,17,"2019-05-18",null,"",1,1,"",1,"",1,1,"","",""]
[5,19,0,1,1,0,2.5,0,0,6,0,10.5,0,18,"2019-05-19",null,"",1,1,"",1,"","",1,"",1,""]
[5,20,0,40.5,0,4,0,0,0,1.5,8,1.5,0,19,"2019-05-20",null,"",1,"",1,"","","","",1,1,""]
[5,21,0.5,28,0,28,0,0,0,0.5,37.5,0,0,20,"2019-05-21",null,"",1,"",1,"","","","",1,"",""]
[5,22,2,0,0,0,0,0,0,0,0,0,16,21,"2019-05-22",null,1,1,"",1,"","","","",1,"",1]
[5,23,0,0,0,0,5.5,0,0,0,0.5,0,0,22,"2019-05-23",null,"","","","",1,"","","",1,"",1]
[5,24,0,6,0,0,0,2.5,0,0,0,0,0,23,"2019-05-24",null,"",1,{"$f":"IF(E29>=$C$108,1,IF(E28>=$C$109,1,IF(E27>=$C$110,1,\"\")))","v":""},"","",1,"","","","",""]
[5,25,0,0,0,0,0,12,0,0,0,0,2,24,"2019-05-25",null,{"$f":"IF(C30>=$C$108,1,IF(C29>=$C$109,1,IF(C28>=$C$110,1,\"\")))","v":""},"","","","",1,"","","","",1]
[5,26,3.5,0,11,0,0,0,1.5,0,7.5,0,0,25,"2019-05-26",null,1,"",1,"","",1,"","",1,"",""]
[5,27,7,28,0,0,0,0,3,0,0,0,0,26,"2019-05-27",null,1,1,1,"","","",1,"","","",""]
[5,28,0,0,0,40.5,0,0,0,0,0,13.5,2,27,"2019-05-28",null,"",1,"",1,"","","","","",1,1]
[5,29,0,0,0,0,0,0,12.5,0,0,9.5,4.5,28,"2019-05-29",null,"","","",1,"","",1,"","",1,1]
[5,30,1.5,0,0,0,15.5,0,10,0,0,7,0,29,"2019-05-30",null,"","","",1,1,"",1,"","",1,""]
[5,31,4.5,0,2,5.5,15,2,0,0,0,0,0,30,"2019-05-31",null,1,"",1,1,1,1,1,"","","",""]
[6,1,0,0,0,0,0,19,0,0,0,0,0,31,"2019-06-01",null,"","","","",1,1,"","","","",""]
[6,2,0,0,0,0,0,0,0,0,0,0.5,0,32,"2019-06-02",null,"","","","","",1,"","","","",""]
[6,3,0,0,0,0,0,0,0,39,0,0,0,33,"2019-06-03",null,"","","","","","","",1,"","",""]
[6,4,0,32.5,0,0,0,0,4,0,0,0,0,34,"2019-06-04",null,"",1,"","","","",1,1,"","",""]
[6,5,6.5,0,0,0,0.5,0,6.5,25.5,5,0,0,35,"2019-06-05",null,1,1,"","","","",1,1,1,"",""]
[6,6,36.5,0,0,0,29,0,0,1.5,0,21.5,0,36,"2019-06-06",null,1,1,"","",1,"","",1,"",1,""]
[6,7,3,0,0,22,0,20,9,0,5,0,0,37,"2019-06-07",null,1,"","",1,1,1,1,"",1,1,""]
[6,8,0,0,0,2.5,8,0,0,4,1.5,0,30.5,38,"2019-06-08",null,1,"","",1,1,1,"",1,"","",1]
[6,9,0,0,0,0,3,0,0.5,10,1,0,3.5,39,"2019-06-09",null,"","","","",1,"","",1,"","",1]
[6,10,2.5,0,0,4,10.5,0,0,0,8.5,0,0,40,"2019-06-10",null,1,"","",1,1,"","",1,1,"",1]
[6,11,2,0,23.5,0,12,0,0,6.5,2,0,0,41,"2019-06-11",null,1,"",1,"",1,"","",1,1,"",""]
[6,12,0,0,55.5,0,2,0,15,4,31.5,0,0,42,"2019-06-12",null,"","",1,"",1,"",1,1,1,"",""]
[6,13,0,11,64,0,1,0,25.5,0,0.5,0,0,43,"2019-06-13",null,"",1,1,"","","",1,"",1,"",""]
[6,14,9.5,12.5,31,0,0,0,0,0,0,0,0,44,"2019-06-14",null,1,1,1,"","","",1,"",1,"",""]
[6,15,2.5,8,1,19.5,2,0,0,0,0,5.5,1,45,"2019-06-15",null,1,1,1,1,1,"","","","",1,""]
[6,16,0,9,0,6.5,0,0,17.5,0,0,0,31.5,46,"2019-06-16",null,"",1,1,1,"","",1,"","","",1]
[6,17,0,0,0,0,0,0,3,5.5,0,0,21,47,"2019-06-17",null,"","","","","","",1,1,"","",1]
[6,18,0,4,16.5,0,0.5,0,0,3,0,0,0,48,"2019-06-18",null,"",1,1,"","","","",1,"","",1]
[6,19,0,18,51.5,0,3,0,6,10,0,58.5,54,49,"2019-06-19",null,"",1,1,"",1,"",1,1,"",1,1]
[6,20,1,0,1,0,39.5,1,2,0,14,19.5,2,50,"2019-06-20",null,"",1,1,"",1,"",1,1,1,1,1]
[6,21,6,0,0,2.5,0,34.5,17.5,12,0,9,20,51,"2019-06-21",null,1,"",1,1,1,{"$f":"IF(H57>=$C$108,1,IF(H56>=$C$109,1,IF(H55>=$C$110,1,\"\")))","v":1},1,1,1,1,1]
[6,22,1,0,0,0,0,0,15,0,5,0,23.5,52,"2019-06-22",null,"","","","",1,1,1,1,1,"",1]
[6,23,0,0,0,0,5.5,0,13,0.5,0,0,0,53,"2019-06-23",null,"","","","",1,1,1,"","","",1]
[6,24,9.5,2.5,0,0,0,1,8,0,0,2.5,0,54,"2019-06-24",null,1,1,"","","","",1,"","",1,""]
[6,25,0,0,2.5,0,0,11,19.5,0,0,0,0.5,55,"2019-06-25",null,"","",1,"","",1,1,"","","",""]
[6,26,0,0,1,0,0,0,0,31.5,0,49,0,56,"2019-06-26",null,{"$f":"IF(C62>=$C$108,1,IF(C61>=$C$109,1,IF(C60>=$C$110,1,\"\")))","v":""},"","","","",1,1,1,"",1,""]
[6,27,2,0,0,8.5,0,0.5,18.5,1.5,0,0.5,0,57,"2019-06-27",null,1,"","",1,"","",1,1,"",1,""]
[6,28,0,0,86,0,17.5,4.5,9,5.5,15.5,0,0,58,"2019-06-28",null,"","",1,"",1,1,1,1,1,1,""]
[6,29,0,2,0,12,55,5,4.5,0,0.5,0,0,59,"2019-06-29",null,"",1,1,1,1,1,1,"",1,"",""]
[6,30,0,2.5,29,21.5,5.5,35,0,14,0,0,4.5,60,"2019-06-30",null,"",1,1,1,1,1,"",1,"","",1]
[7,1,0,11,1,3.5,0,28,0,21,0,0,57,61,"2019-07-01",null,""]
[7,2,0,5,0,1.5,0,8.5,0,0,0,0,0,62,"2019-07-02",null,""]
[7,3,121.5,1.5,31,6.5,0,0,15,0,15,17,36.5,63,"2019-07-03",null,1,"",1,1,"","",1,"",1,1,1]
[7,4,4.5,0.5,21.5,3.5,19,47,7,17,8.5,26,0,64,"2019-07-04",null,1,"",1,1,1,1,1,1,1,1,1]
[7,5,6,4.5,0,0,154,11,0,0,1,18,7.5,65,"2019-07-05",null,1,1,1,"",1,1,"",1,"",1,1]
[7,6,0,1,54,0,85,0,4,0,29.5,0.5,49.5,66,"2019-07-06",null,"","",1,"",1,1,1,"",1,1,1]
[7,7,0,67,40.5,0,109,0,0,14,5,0,20.5,67,"2019-07-07",null,"",1,1,"",1,"","",1,1,"",1]
[7,8,0,41.5,53,0,1,34.5,2.5,1,0,0,0.5,68,"2019-07-08",null,"",1,1,"",1,1,1,1,"","",1]
[7,9,13,8.5,2.5,0.5,0,11.5,21,54,0,0,0,69,"2019-07-09",null,1,1,1,"",1,1,1,1,"","",""]
[7,10,0.5,1.5,49.5,0,0,5.5,0,0,7.5,0,0,70,"2019-07-10",null,1,1,1,"","",1,1,1,1,"",""]
[7,11,0.5,4,11,12.5,0,0,0,0,1.5,0,0,71,"2019-07-11",null,"",1,1,1,"","","",1,"","",""]
[7,12,36.5,0,1,1,0,0,2.5,0,0,0,34.5,72,"2019-07-12",null,1,"",1,1,"","",1,"","","",1]
[7,13,1.5,15.5,31,12,null,0,58,0,14.5,22.5,2.5,73,"2019-07-13",null,1,1,1,1,"","",1,"",1,1,1]
[7,14,4.5,12,24.5,16,null,0,33,0,2,2,0,74,"2019-07-14",null,1,1,1,1,"","",1,"",1,1,1]
[7,15,11.5,10.5,0.5,2,0,0,1,0,0,7,1,75,"2019-07-15",null,1,1,1,1,"","",1,"","",1,""]
[7,16,0,9.5,0,0,0,3.5,0,14,0,0,0,76,"2019-07-16",null,1,1,"","","",1,1,1,"","",""]
[7,17,4,0,0.5,0,0,15,6,136,0,0,0,77,"2019-07-17",null,1,"","","","",1,1,1,"","",""]
[7,18,0,0,4,22.5,0,2,0,24,12,2.5,0,78,"2019-07-18",null,"","",1,1,"",1,"",1,1,1,""]
[7,19,51.5,0,0.5,14.5,0,0.5,0,2,5,0,0,79,"2019-07-19",null,1,"","",1,"","","",1,1,"",""]
[7,20,0,0,0,2,0,0,0,0,0,0,15,80,"2019-07-20",null,1,"","",1,"","","","","","",1]
[7,21,1,0,67,0,0,0,0,0,0,0,4.5,81,"2019-07-21",null,1,"",1,"","","","","","","",1]
[7,22,10.5,1.5,1,15.5,0,0,0,13.5,0,0,14,82,"2019-07-22",null,1,"",1,1,"","","",1,"","",1]
[7,23,0.5,0,1,4.5,0,0,0,26.5,0,0,0.5,83,"2019-07-23",null,1,"",1,1,"","","",1,{"$f":"IF(K89>=$C$108,1,IF(K88>=$C$109,1,IF(K87>=$C$110,1,\"\")))","v":""},"",1]
[7,24,0,0,22.5,0,0,7.5,0,0,0,7.5,0,84,"2019-07-24",null,{"$f":"IF(C90>=$C$108,1,IF(C89>=$C$109,1,IF(C88>=$C$110,1,\"\")))","v":""},"",1,"","",1,"",1,"",1,""]
[7,25,0,0,28.5,3,0,11,0,0,0,0,0,85,"2019-07-25",null,"","",1,1,"",1,"","","","",""]
[7,26,0,0,3,0,0,4.5,32.5,0,0,0,0,86,"2019-07-26",null,"","",1,"","",1,1,"","","",""]
[7,27,15.5,0,2,3,0,0,0,13.5,5,4,0,87,"2019-07-27",null,1,"",1,1,"","",1,1,1,1,""]
[7,28,0,0,1,0,0,16.5,0,23.5,0.5,2,0,88,"2019-07-28",null,1,"","","","",1,1,1,"",1,""]
[7,29,0,0,14.5,0,31.5,0,0,0,0,15,0,89,"2019-07-29",null,"","",1,"",1,1,"",1,"",1,""]
[7,30,0,0,3.5,0,0,3,0,1.5,0,0.5,0,90,"2019-07-30",null,"","",1,"",1,1,"","","",1,""]
[7,31,0,0,0,1,0,0,0,0,3.5,0,0,91,"2019-07-31",null,"","","","",1,"","","",1,"",""]
[8,1,0,0,0,0,0,0,0,0,0,21.5,0,92,"2019-08-01",null,"","","","","","","","","",1,""]
[8,2,0,0,3.5,2,0,0,0,0,0,0.5,0,93,"2019-08-02",null,"","",1,1,"","","","","",1,""]
[8,3,0,24.5,0,0,0,0,0,0,2.5,0,0,94,"2019-08-03",null,"",1,"","","","","","",1,"",""]
[8,4,7,0,0,0,0,0,0,0,6,15.5,0,95,"2019-08-04",null,1,1,"","","","","","",1,1,""]
[8,5,3,0,0,0,0,0,0,0,0.5,4.5,0.5,96,"2019-08-05",null,1,"","","","","","","","",1,""]
[8,6,0,0,0,0,0,0.5,0,0,49,0.5,0.5,97,"2019-08-06",null,"","","","","","","","",1,"",""]
[]
[null,"土寄せ作業可能か\nどうかの判断条件",null,null,"判断日",{"$f":"判断日","v":"2025-06-01"},null,null,"判断年",{"$f":"YEAR(判断日)","v":2025},null,null,null,null,null,"可能日の",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,"適期始","適期終",null,null,"5/1から数えて",null,null,null,null,null,"10年平均","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","近5年平均","近3年平均","最多日数","最少日数"]
[null,"作業できない降雨量mm",null,null,"土寄①",{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"土寄①終修正","v":"2025-07-01"},null,"土寄①適期始は",{"$f":"$F$107-DATEVALUE(TEXT(判断年,\"####\")&\"/5/1\")","v":51},"日後",null,null,null,"5月",{"$f":"AVERAGE(Q107:Z107)","v":19.600000000000001},{"$f":"31-SUM(Q$6:Q$36)","v":21},{"$f":"31-SUM(R$6:R$36)","v":16},{"$f":"31-SUM(S$6:S$36)","v":20},20,17,22,15,23,22,20,20,{"$f":"AVERAGE(Q107:U107)","v":18.8},{"$f":"AVERAGE(Q107:S107)","v":19},{"$f":"MAX(Q107:Z107)","v":23},{"$f":"MIN(Q107:Z107)","v":15}]
[null,"当日",{"$f":"入力表!C26","v":2},"mm","土寄②",{"$f":"土寄②始修正","v":"2025-07-06"},{"$f":"土寄②終","v":"2025-07-16"},null,"土寄①適期終は",{"$f":"$G$107-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":61},"日後",null,null,null,"6月",16.399999999999999,{"$f":"30-SUM(Q$37:Q$66)","v":19},{"$f":"30-SUM(R$37:R$66)","v":17},{"$f":"30-SUM(S$37:S$66)","v":16},21,13,18,11,11,18,20,18,{"$f":"AVERAGE(Q108:U108)","v":17.2},{"$f":"AVERAGE(Q108:S108)","v":17.333333333333332},{"$f":"MAX(Q108:Z108)","v":21},{"$f":"MIN(Q108:Z108)","v":11}]
[null,"翌日",{"$f":"入力表!C27","v":10},"mm","除草剤",{"$f":"茎葉始","v":"2025-07-13"},{"$f":"茎葉終","v":"2025-07-23"},null,"土寄②適期始は",{"$f":"$F$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":66},"日後",null,null,null,"7月",16.5,{"$f":"31-SUM(Q$67:Q$97)","v":13},{"$f":"31-SUM(R$67:R$97)","v":21},{"$f":"31-SUM(S$67:S$97)","v":8},17,22,16,16,14,20,18,18,16.2,14,22,8]
[null,"２日後",{"$f":"入力表!C28","v":30},"mm","摘心",{"$f":"摘心始","v":"7/1以降の主茎長で判断"},{"$f":"摘心終","v":"2025-07-21"},null,"土寄②適期終は",{"$f":"$G$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":76},"日後",null,null,null,"6/25-7/24",16.100000000000001,{"$f":"30-SUM(Q$61:Q$90)","v":13},{"$f":"31-SUM(R$61:R$90)","v":19},{"$f":"31-SUM(S$61:S$90)","v":9},16,22,16,14,13,20,19,17,15.8,13.666666666666666,22,9]
[null,null,"↑",null,null,null,null,null,"除草剤適期始行",{"$f":"$F$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":73},"日後",null,null,"土寄せ①適期日数",{"$f":"G107-F107+1","v":11},6.2,{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,Q$105,$J$108-$J$107+1,1))","v":11},{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,R105,$J$108-$J$107+1,1))","v":8},8,6,7,5,3,2,5,7,6,8,9,11,2]
[null,null,"入力された条件",null,null,null,null,null,"除草剤適期終行",{"$f":"$G$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":83},"日後",null,null,"土寄せ②適期日数",{"$f":"G108-F108+1","v":11},5,{"$f":"$O112-SUM(OFFSET(表の5月1日位置,$J$109,Q$105,$J$110-$J$109+1,1))","v":11},4,2,1,6,7,6,2,5,6,7,4.8,5.666666666666667,11,1]
[null,null,null,null,null,null,null,null,"摘心適期始行",{"$f":"$F$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":{"$error":"#VALUE!"}},"日後",null,null,"除草剤適期日数",{"$f":"G109-F109+1","v":11},6.3,{"$f":"$O113-COUNTIF(OFFSET(表の5月1日位置,$J$111,-13+Q$105,$J$112-$J$111+1,1),\">=1\")","v":4},6,5,3,11,8,7,5,7,7,6,5.8,5,11,3]
[null,null,null,"土寄①","土寄②","除草剤","摘心",null,"摘心適期終行",{"$f":"$G$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":81},"日後",null,null,"摘心適期日数",{"$f":"G110-F110+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"$O114-COUNTIF(OFFSET(表の5月1日位置,$J$113,-13+Q$105,$J$114-$J$113+1,1),\">=1\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["適期作業の確率",null,null,{"$f":"P111/O111","v":0.5636363636363636},{"$f":"P112/O112","v":0.45454545454545453},{"$f":"P113/O113","v":0.57272727272727275},{"$f":"P114/O114","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"7月の1mm以上降雨日数",{"$f":"AVERAGE(R115:AA115)","v":13.6},{"$f":"COUNTIF(C67:C97,\">=1\")","v":13},15,23,17,6,15,11,14,13,11,11,{"$f":"AVERAGE(R115:V115)","v":15.2},{"$f":"AVERAGE(R115:T115)","v":18.333333333333332},{"$f":"MAX(R115:AA115)","v":23},{"$f":"MIN(R115:AA115)","v":6}]

{"sheet":"アメダス須知","index":7,"n_rows":141,"n_cols":31,"rows_kept":141,"cut":false,"hidden":false,"merged":[[104,1,105,3],[104,5,104,6]]}
[null,"降雨日から見た黒大豆作業の検討",null,null,null,null,null,null,null,{"$f":"\"（\"&C3&\"～\"&L3&\"年平均）\"","v":"（2022～2013年平均）"}]
[null,"アメダス須知データ"]
["月","日",2022,2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,null,null,null,{"$f":"C3","v":2022},2021,2020,2019,2018,2017,2016,2015,2014,2013,2012]
[4,29,53,68.5,0,18,0,2.5,0,0,42,0,0,null,"2019-04-29",null,{"$f":"IF(C4>=$C$108,1,\"\")","v":1},1,"",1,"",1,"","",1,"",""]
[4,30,0,0.5,0,17.5,0,0,0,0,8,4.5,0,null,"2019-04-30",null,{"$f":"IF(C5>=$C$108,1,IF(C4>=$C$109,1,\"\"))","v":1},1,"",1,"","","","",1,1,""]
[5,1,18.5,1.5,0,9.5,0,0,0,0,1,0.5,0,0,"2019-05-01",null,{"$f":"IF(C6>=$C$108,1,IF(C5>=$C$109,1,IF(C4>=$C$110,1,\"\")))","v":1},1,"",1,"","","","",1,"",""]
[5,2,0.5,4,0,0,5,0,0,0,0,0,22.5,1,"2019-05-02",null,1,1,"","",1,"","","","","",1]
[5,3,0,0,2,0,2.5,0,4,0.5,0,0,4,2,"2019-05-03",null,"","",1,"",1,"",1,"","","",1]
[5,4,0,0,0.5,0,0,0,0.5,2.5,0,0,3,3,"2019-05-04",null,"","","","","","","",1,"","",1]
[5,5,0,9.5,0,0,0,0,0,0,0,0,0,4,"2019-05-05",null,"",1,"","","","","","","","",""]
[5,6,0,0,3.5,11.5,14,1,8.5,0,0,0,1,5,"2019-05-06",null,"","",1,1,1,"",1,"","","",""]
[5,7,0,1,0,0,43,0,0,0.5,0,0,0,6,"2019-05-07",null,"","","",1,1,"","","","","",""]
[5,8,0,0,0,0,9.5,0,0,0.5,0,0,0,7,"2019-05-08",null,"","","","",1,"","","","","",""]
[5,9,0,0,4,0,6.5,4,12,0,0,0,0,8,"2019-05-09",null,"","",1,"",1,1,1,"","","",""]
[5,10,0,0,6,0,0,4.5,1.5,0,0,4.5,0,9,"2019-05-10",null,"","",1,"","",1,1,"","",1,""]
[5,11,1.5,0,0,0,0,0,18,0,0,7,0,10,"2019-05-11",null,"","","","","","",1,"","",1,""]
[5,12,9.5,1.5,0,0,0,0.5,0,38,5.5,0,0.5,11,"2019-05-12",null,1,"","","","","",1,1,1,"",""]
[5,13,14,1.5,0,0,52,21,0,0,1.5,0,0,12,"2019-05-13",null,1,"","","",1,1,"",1,"","",""]
[5,14,16,0,0,23.5,0,0,0,0,0,0,0,13,"2019-05-14",null,1,"","",1,1,1,"",1,"","",""]
[5,15,0,0,3.5,0,0,0,0,0,6,0,4.5,14,"2019-05-15",null,1,"",1,1,1,"","","",1,"",1]
[5,16,0,5.5,47.5,0,0,0,67.5,49.5,0,0,0,15,"2019-05-16",null,"",1,1,"","","",1,1,"","",""]
[5,17,0,22,0,0,0,0,3.5,0,0,0,0,16,"2019-05-17",null,"",1,1,"","","",1,1,"","",""]
[5,18,0,1.5,19,0,31,0,0,8,0,0,0,17,"2019-05-18",null,"",1,1,"",1,"",1,1,"","",""]
[5,19,0,0.5,1.5,0,3.5,0,0,4,0,7,0,18,"2019-05-19",null,"","",1,"",1,"","",1,"",1,""]
[5,20,0,36,0,10.5,0,0,0,2.5,12,1.5,0,19,"2019-05-20",null,"",1,"",1,1,"","",1,1,"",""]
[5,21,0.5,25,0,29.5,0,0,0,0,37.5,0,0,20,"2019-05-21",null,"",1,"",1,"","","","",1,"",""]
[5,22,2.5,0,0,0,0,0,0,0,0,0,0,21,"2019-05-22",null,1,1,"",1,"","","","",1,"",""]
[5,23,0,0,0,0,5,0,0,0,0,0,0,22,"2019-05-23",null,"","","","",1,"","","",1,"",""]
[5,24,0,2,0,0,0,2,0,0,0,0,0,23,"2019-05-24",null,"",1,{"$f":"IF(E29>=$C$108,1,IF(E28>=$C$109,1,IF(E27>=$C$110,1,\"\")))","v":""},"","",1,"","","","",""]
[5,25,0,0,0,0,0,18.5,0,0,0,0,1,24,"2019-05-25",null,{"$f":"IF(C30>=$C$108,1,IF(C29>=$C$109,1,IF(C28>=$C$110,1,\"\")))","v":""},"","","","",1,"","","","",""]
[5,26,2.5,0,14.5,0,0,0,0.5,0,4,0,0,25,"2019-05-26",null,1,"",1,"","",1,"","",1,"",""]
[5,27,10,30,0,0,0,0,3.5,0,0,0,0,26,"2019-05-27",null,1,1,1,"","","",1,"","","",""]
[5,28,0,0,0,40,0,0,0,0,0,6,0,27,"2019-05-28",null,1,1,"",1,"","","","","",1,""]
[5,29,0,0,0,0,0,0,12,0,0,5,12.5,28,"2019-05-29",null,"",1,"",1,"","",1,"","",1,1]
[5,30,2,0,0,0,12.5,0,7.5,0,0,4,0,29,"2019-05-30",null,1,"","",1,1,"",1,"","",1,1]
[5,31,3,0,1.5,0.5,8.5,2,0,0,0,0,0,30,"2019-05-31",null,1,"","","",1,1,"","","","",""]
[6,1,0,0,1,0,0,20,0,0,0,0,0,31,"2019-06-01",null,"","","","","",1,"","","","",""]
[6,2,0,0,0,0,0,0,0,0,0,0,0,32,"2019-06-02",null,"","","","","",1,"","","","",""]
[6,3,0,0.5,0,0,0,0,0,36.5,0,0,0,33,"2019-06-03",null,"","","","","","","",1,"","",""]
[6,4,0,31.5,0,0,0,0,4,0,0,0,0,34,"2019-06-04",null,"",1,"","","","",1,1,"","",""]
[6,5,6.5,0,0,0,1,0,9,22.5,2,0,0,35,"2019-06-05",null,1,1,"","","","",1,1,1,"",""]
[6,6,38,0,0,0,36.5,0,0,1,0.5,0,0,36,"2019-06-06",null,1,1,"","",1,"","",1,"","",""]
[6,7,2.5,0,0,25,2,23,8,0,2.5,0,0,37,"2019-06-07",null,1,"","",1,1,1,1,"",1,"",""]
[6,8,0,0,0,1.5,8.5,0,0,3.5,7,0,38.5,38,"2019-06-08",null,1,"","",1,1,1,"",1,1,"",1]
[6,9,0,0,0,0,5.5,0,1.5,7.5,25,0,5.5,39,"2019-06-09",null,"","","","",1,"","",1,1,"",1]
[6,10,0,0,4.5,0.5,7,0,0,0,0.5,0,0,40,"2019-06-10",null,"","",1,"",1,"","","",1,"",1]
[6,11,1.5,0,22.5,0,13.5,0,0,7,3,0,0,41,"2019-06-11",null,"","",1,"",1,"","",1,1,"",""]
[6,12,0,0,28,0,3,0,20.5,0.5,27,0,0.5,42,"2019-06-12",null,"","",1,"",1,"",1,"",1,"",""]
[6,13,0,14,66,0,0,0,26.5,0,0,0,0,43,"2019-06-13",null,"",1,1,"","","",1,"",1,"",""]
[6,14,16.5,11,19,0,0,0,0,0,0,0,0,44,"2019-06-14",null,1,1,1,"","","",1,"","","",""]
[6,15,3,51,0,38,2.5,0,0,0,0,7,1.5,45,"2019-06-15",null,1,1,1,1,1,"","","","",1,""]
[6,16,0.5,14.5,0,4,0,0,16.5,0.5,0,0,32.5,46,"2019-06-16",null,"",1,"",1,"","",1,"","","",1]
[6,17,0,0,0,0,0,0,1.5,8.5,0,0,18.5,47,"2019-06-17",null,"",1,"",1,"","",1,1,"","",1]
[6,18,0,7,19.5,0,0,0,0,6,0,0,0,48,"2019-06-18",null,"",1,1,"","","","",1,"","",1]
[6,19,0,13.5,44,0,2.5,0,6.5,8.5,0,48.5,62,49,"2019-06-19",null,"",1,1,"",1,"",1,1,"",1,1]
[6,20,0,0,0.5,0,33,0.5,0,0,0,24.5,0.5,50,"2019-06-20",null,"",1,1,"",1,"","","","",1,1]
[6,21,11.5,0,0,1,0.5,35,26.5,8,0,11.5,26,51,"2019-06-21",null,1,"",1,"",1,{"$f":"IF(H57>=$C$108,1,IF(H56>=$C$109,1,IF(H55>=$C$110,1,\"\")))","v":1},1,1,"",1,1]
[6,22,2.5,0,0,0,0,0,25.5,0,4.5,0,25,52,"2019-06-22",null,1,"","","",1,1,1,"",1,1,1]
[6,23,0,0,0,0,7,0,13.5,31,0,10.5,0,53,"2019-06-23",null,"","","","",1,1,1,1,"",1,1]
[6,24,0.5,3,0,0,0,2,9,7.5,0,2.5,0.5,54,"2019-06-24",null,"",1,"","","",1,1,1,"",1,""]
[6,25,0,0,3.5,0,0,13,27.5,0,0,0,4,55,"2019-06-25",null,"","",1,"","",1,1,1,"","",1]
[6,26,0,2,5.5,0,0,0,0,22,13,48.5,0,56,"2019-06-26",null,{"$f":"IF(C62>=$C$108,1,IF(C61>=$C$109,1,IF(C60>=$C$110,1,\"\")))","v":""},1,1,"","",1,1,1,1,1,""]
[6,27,0,0.5,4.5,9.5,0,0,16.5,0,0,0,0,57,"2019-06-27",null,"","",1,1,"","",1,1,1,1,""]
[6,28,0,0,50,0.5,18.5,5,9,0.5,22,0,0,58,"2019-06-28",null,"","",1,"",1,1,1,"",1,1,""]
[6,29,0,1.5,0,8.5,58.5,3,6,0,5.5,0,0,59,"2019-06-29",null,"","",1,1,1,1,1,"",1,"",""]
[6,30,0,2.5,17.5,11.5,3.5,33.5,0.5,14,0,0,5.5,60,"2019-06-30",null,"",1,1,1,1,1,"",1,"","",1]
[7,1,0,9,0.5,4.5,0,8.5,0,10.5,0,0,28.5,61,"2019-07-01",null,""]
[7,2,0,3.5,0,2,0,40,0,0,0,0,0,62,"2019-07-02",null,""]
[7,3,161.5,0.5,27.5,5,0,0,16,0,13.5,16,45.5,63,"2019-07-03",null,1,"",1,1,"",1,1,"",1,1,1]
[7,4,5.5,1,7,2,22,38.5,2.5,10.5,18,36.5,0,64,"2019-07-04",null,1,"",1,1,1,1,1,1,1,1,1]
[7,5,3.5,1,0,0,107,13.5,0,0,10,10.5,8.5,65,"2019-07-05",null,1,"","","",1,1,"",1,1,1,1]
[7,6,0,0,34,0,93,0,0,0.5,31,2.5,46,66,"2019-07-06",null,"","",1,"",1,1,"","",1,1,1]
[7,7,0,81.5,21.5,0,144.5,0,0,12.5,3.5,0,13.5,67,"2019-07-07",null,"",1,1,"",1,"","",1,1,"",1]
[7,8,23.5,52.5,36,0,0,0,3.5,3,0.5,0,0,68,"2019-07-08",null,1,1,1,"",1,"",1,1,1,"",1]
[7,9,43.5,10,4,1,0,5.5,15,5.5,0,0,0,69,"2019-07-09",null,1,1,1,"",1,1,1,1,"","",""]
[7,10,0,1.5,22.5,0,0,0,0,0,6,0,0,70,"2019-07-10",null,1,1,1,"","","",1,"",1,"",""]
[7,11,0.5,12,4,16,0,0,0,0,0,0,0,71,"2019-07-11",null,1,1,1,1,"","","","","","",""]
[7,12,67.5,0,1,8.5,0,0,7,0,0,0,16.5,72,"2019-07-12",null,1,1,"",1,"","",1,"","","",1]
[7,13,1,0,25.5,11.5,0,0,19.5,0,10,7,3,73,"2019-07-13",null,1,"",1,1,"","",1,"",1,1,1]
[7,14,8.5,0.5,23,18.5,0,0,5,0,1.5,8,1,74,"2019-07-14",null,1,"",1,1,"","",1,"",1,1,""]
[7,15,24,16.5,0,0.5,0,0,0.5,0,0,1.5,1,75,"2019-07-15",null,1,1,1,1,"","","","","","",""]
[7,16,0,3,0,3,0,22,0,18,0,0,0,76,"2019-07-16",null,1,1,"",1,"",1,"",1,"","",""]
[7,17,10,0,1.5,0,0,2,1.5,101.5,0,0,0,77,"2019-07-17",null,1,"","","","",1,"",1,"","",""]
[7,18,0,0,1.5,15,0,30,0,6.5,3.5,0.5,0,78,"2019-07-18",null,1,"","",1,"",1,"",1,1,"",""]
[7,19,46,0.5,0,18.5,0,0,0,1,3.5,0,0,79,"2019-07-19",null,1,"","",1,"",1,"",1,1,"",""]
[7,20,0,36.5,0,0.5,0,0,0,0,0,0,8,80,"2019-07-20",null,1,1,"",1,"",1,"","","","",1]
[7,21,17.5,0,26,0,0,0,0,0,0,0,0.5,81,"2019-07-21",null,1,1,1,"","","","","","","",""]
[7,22,4,0,2,27.5,0,0,0,6.5,0,6,28.5,82,"2019-07-22",null,1,1,1,1,"","","",1,"",1,1]
[7,23,2.5,0,0,20.5,0,0,0,23.5,0,0,0,83,"2019-07-23",null,1,"","",1,"","","",1,{"$f":"IF(K89>=$C$108,1,IF(K88>=$C$109,1,IF(K87>=$C$110,1,\"\")))","v":""},"",1]
[7,24,0,0,20.5,16.5,0,2,0,0,0,3,0,84,"2019-07-24",null,{"$f":"IF(C90>=$C$108,1,IF(C89>=$C$109,1,IF(C88>=$C$110,1,\"\")))","v":""},"",1,1,"",1,"",1,"",1,""]
[7,25,0,0,25,0,0,7.5,0,0,0,0,0,85,"2019-07-25",null,"","",1,1,"",1,"","","","",""]
[7,26,0,0,3,0.5,0,0.5,17.5,0,0,0,0,86,"2019-07-26",null,"","",1,"","","",1,"","","",""]
[7,27,64.5,0,1,4,0,0,0,8,9,0,0,87,"2019-07-27",null,1,"","",1,"","",1,1,1,"",""]
[7,28,0,0,2.5,0,0,2,0,20,0,2,0,88,"2019-07-28",null,1,"",1,"","",1,"",1,"",1,""]
[7,29,0,0,2.5,0,17,0,0,4.5,0,15.5,0,89,"2019-07-29",null,1,"",1,"",1,"","",1,"",1,""]
[7,30,0,0,32.5,0,0,19.5,0,0,0,20.5,0,90,"2019-07-30",null,"","",1,"",1,1,"","","",1,""]
[7,31,0,0,0,0,0,2.5,0,0,0,3.5,0,91,"2019-07-31",null,"","",1,"","",1,"","","",1,""]
[8,1,0,0,0,0,0,0,0,0,0,28.5,0,92,"2019-08-01",null,"","",1,"","","","","","",1,""]
[8,2,0,0,0,9,0,0,0,0,0,0,0,93,"2019-08-02",null,"","","",1,"","","","","",1,""]
[8,3,1.5,27,0,0,0,0,0,0,3,0,0,94,"2019-08-03",null,"",1,"","","","","","",1,"",""]
[8,4,24.5,0,0,0,0,0,0,0,4.5,0,0,95,"2019-08-04",null,1,1,"","","","","","",1,"",""]
[8,5,0,0,0,0,0,0,0,0,0,19.5,0,96,"2019-08-05",null,1,"","","","","","","","",1,""]
[8,6,0,0,0,4,0,22,19,0,8,0,0,97,"2019-08-06",null,"","","",1,"",1,1,"",1,1,""]
[]
[null,"土寄せ作業可能か\nどうかの判断条件",null,null,"判断日",{"$f":"判断日","v":"2025-06-01"},null,null,"判断年",{"$f":"IF(YEAR(判断日)<>1900,YEAR(判断日),YEAR(TODAY()))","v":2025},null,null,null,null,null,"可能日の",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,"適期始","適期終",null,null,"5/1から数えて",null,null,null,null,null,"10年平均","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","近5年平均","近3年平均","最多日数","最少日数"]
[null,"作業できない降雨量mm",null,null,"土寄①",{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"土寄①終修正","v":"2025-07-01"},null,"土寄①適期始は",{"$f":"$F$107-DATEVALUE(TEXT(判断年,\"####\")&\"/5/1\")","v":51},"日後",null,null,null,"5月",{"$f":"AVERAGE(Q107:Z107)","v":20.5},{"$f":"31-SUM(Q$6:Q$36)","v":19},{"$f":"31-SUM(R$6:R$36)","v":18},{"$f":"31-SUM(S$6:S$36)","v":20},20,16,23,19,22,23,25,25,{"$f":"AVERAGE(Q107:U107)","v":18.600000000000001},{"$f":"AVERAGE(Q107:S107)","v":19},{"$f":"MAX(Q107:Z107)","v":25},{"$f":"MIN(Q107:Z107)","v":16}]
[null,"当日",{"$f":"入力表!C26","v":2},"mm","土寄②",{"$f":"土寄②始修正","v":"2025-07-06"},{"$f":"土寄②終","v":"2025-07-16"},null,"土寄①適期終は",{"$f":"$G$107-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":61},"日後",null,null,null,"6月",16.7,{"$f":"30-SUM(Q$37:Q$66)","v":22},{"$f":"30-SUM(R$37:R$66)","v":16},{"$f":"30-SUM(S$37:S$66)","v":14},22,14,17,12,13,17,20,17,{"$f":"AVERAGE(Q108:U108)","v":17.600000000000001},{"$f":"AVERAGE(Q108:S108)","v":17.333333333333332},{"$f":"MAX(Q108:Z108)","v":22},{"$f":"MIN(Q108:Z108)","v":12}]
[null,"翌日",{"$f":"入力表!C27","v":10},"mm","除草剤",{"$f":"茎葉始","v":"2025-07-13"},{"$f":"茎葉終","v":"2025-07-23"},null,"土寄②適期始は",{"$f":"$F$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":66},"日後",null,null,null,"7月",16.899999999999999,{"$f":"31-SUM(Q$67:Q$97)","v":9},{"$f":"31-SUM(R$67:R$97)","v":20},{"$f":"31-SUM(S$67:S$97)","v":11},15,23,16,21,16,19,19,20,15.6,13.333333333333334,23,9]
[null,"２日後",{"$f":"入力表!C28","v":30},"mm","摘心",{"$f":"摘心始","v":"7/1以降の主茎長で判断"},{"$f":"摘心終","v":"2025-07-21"},null,"土寄②適期終は",{"$f":"$G$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":76},"日後",null,null,null,"6/25-7/24",16,{"$f":"30-SUM(Q$61:Q$90)","v":11},{"$f":"31-SUM(R$61:R$90)","v":18},{"$f":"31-SUM(S$61:S$90)","v":11},14,22,15,18,15,16,20,18,15.2,13.333333333333334,22,11]
[null,null,"↑",null,null,null,null,null,"除草剤適期始行",{"$f":"$F$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":73},"日後",null,null,"土寄せ①適期日数",{"$f":"G107-F107+1","v":11},5.9,{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,Q$105,$J$108-$J$107+1,1))","v":11},{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,R105,$J$108-$J$107+1,1))","v":9},8,4,8,5,2,2,4,6,4,8,9.3333333333333339,11,2]
[null,null,"入力された条件",null,null,null,null,null,"除草剤適期終行",{"$f":"$G$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":83},"日後",null,null,"土寄せ②適期日数",{"$f":"G108-F108+1","v":11},5.5,{"$f":"$O112-SUM(OFFSET(表の5月1日位置,$J$109,Q$105,$J$110-$J$109+1,1))","v":11},2,3,2,5,7,8,5,7,5,8,4.5999999999999996,5.333333333333333,11,2]
[null,null,null,null,null,null,null,null,"摘心適期始行",{"$f":"$F$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":{"$error":"#VALUE!"}},"日後",null,null,"除草剤適期日数",{"$f":"G109-F109+1","v":11},6.6,{"$f":"$O113-COUNTIF(OFFSET(表の5月1日位置,$J$111,-13+Q$105,$J$112-$J$111+1,1),\">=1\")","v":3},8,5,4,11,8,8,5,7,7,6,6.2,5.333333333333333,11,3]
[null,null,null,"土寄①","土寄②","除草剤","摘心",null,"摘心適期終行",{"$f":"$G$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":81},"日後",null,null,"摘心適期日数",{"$f":"G110-F110+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"$O114-COUNTIF(OFFSET(表の5月1日位置,$J$113,-13+Q$105,$J$114-$J$113+1,1),\">=1\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["適期作業の確率",null,null,{"$f":"P111/O111","v":0.53636363636363638},{"$f":"P112/O112","v":0.5},{"$f":"P113/O113","v":0.6},{"$f":"P114/O114","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"7月の1mm以上降雨日数",{"$f":"AVERAGE(R115:AA115)","v":12.6},{"$f":"COUNTIF(C67:C97,\">=1\")","v":15},12,22,16,5,13,9,14,11,13,11,{"$f":"AVERAGE(R115:V115)","v":13.6},{"$f":"AVERAGE(R115:T115)","v":16.666666666666668},{"$f":"MAX(R115:AA115)","v":22},{"$f":"MIN(R115:AA115)","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-28",null,"2020-02-28",43524,43889]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",null,"2020-02-29",43525,43890]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"作表日付","2019-03-02",null,"2020-03-01",43526,43891]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断日",null,null,"2019-05-01",43586,null,"5/1の行",{"$f":"ROW(表の5月1日位置)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年",null,null,"2020-07-03",44015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年5/1算出",null,null,null,43952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期始の行",null,null,"=DATEVALUE(TEXT(P127,\"####\")&\"/5/1\")",{"$f":"DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":45778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期終の行",null,null,"=$M$106-$Q$128",{"$f":"$F$107-$R$131","v":51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"適期始～適期終の不可日",null,null,"=$N$106-$Q$128",{"$f":"$G$107-$R$131","v":61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(OFFSET($O$6,$R$132,4,58-53+1,1))","v":3}]
[]
[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,"=ROW(表の5月1日位置)+($M$106-$Q$128)",{"$f":"ROW(表の5月1日位置)+($F$107-$R$131)","v":57},"セル位置",{"$f":"ADDRESS(R137,17)","v":"$Q$57"},{"$f":"6+($F$107-$R$131)","v":57},{"$f":"T137","v":"$Q$57"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期内の不可日数",null,null,"=ROW(表の5月1日位置)+($M$107-$Q$128)",{"$f":"ROW(表の5月1日位置)+($G$107-$R$131)","v":67},null,{"$f":"ADDRESS(R138,17)","v":"$Q$67"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期終の行",null,null,null,{"$f":"SUM(T137:T138)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上の枠内不要"]

{"sheet":"アメダス本庄","index":8,"n_rows":141,"n_cols":31,"rows_kept":141,"cut":false,"hidden":false,"merged":[[104,1,105,3],[104,5,104,6]]}
[null,"降雨日から見た黒大豆作業の検討",null,null,null,null,null,null,null,{"$f":"\"（\"&C3&\"～\"&L3&\"年平均）\"","v":"（2022～2013年平均）"}]
[null,"アメダス本庄データ"]
["月","日",2022,2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,null,null,null,{"$f":"C3","v":2022},2021,2020,2019,2018,2017,2016,2015,2014,2013,2012]
[4,29,52.5,63.5,0,15.5,0,1.5,0,0,42.5,0,0,null,"2019-04-29",null,{"$f":"IF(C4>=$C$108,1,\"\")","v":1},1,"",1,"","","","",1,"",""]
[4,30,0.5,0.5,0,13.5,0,0,0,0,6,5.5,0,null,"2019-04-30",null,{"$f":"IF(C5>=$C$108,1,IF(C4>=$C$109,1,\"\"))","v":1},1,"",1,"","","","",1,1,""]
[5,1,16.5,4,0,9,0,0,0,0,0,2.5,0,0,"2019-05-01",null,{"$f":"IF(C6>=$C$108,1,IF(C5>=$C$109,1,IF(C4>=$C$110,1,\"\")))","v":1},1,"",1,"","","","",1,1,""]
[5,2,1.5,9,0,0,4.5,0,0,0,0,0.5,25,1,"2019-05-02",null,1,1,"","",1,"","","","","",1]
[5,3,0,0,2.5,0,1,0,3.5,0,0,0,2.5,2,"2019-05-03",null,"","",1,"","","",1,"","","",1]
[5,4,0,0,0.5,0,0.5,0,1,2.5,0,2.5,6.5,3,"2019-05-04",null,"","","","","","","",1,"",1,1]
[5,5,0,6.5,0,0,0,0,0,0,0,0,2,4,"2019-05-05",null,"",1,"","","","","","","","",1]
[5,6,0,0,3.5,8,19,1.5,12,0,0,0,6,5,"2019-05-06",null,"","",1,1,1,"",1,"","","",1]
[5,7,0,0,0,0,48.5,0,0,1,0,0,1,6,"2019-05-07",null,"","","","",1,"",1,"","","",""]
[5,8,0,0,0,0,9,0,0,0,0.5,0,0,7,"2019-05-08",null,"","","","",1,"","","","","",""]
[5,9,0,0.5,4.5,0,7.5,5,10.5,0,3.5,0,0,8,"2019-05-09",null,"","",1,"",1,1,1,"",1,"",""]
[5,10,0,0,3,0,0,3,1,0,0,7.5,0,9,"2019-05-10",null,"","",1,"","",1,1,"","",1,""]
[5,11,1.5,0,0,0,0,0,25,0,0,8,1.5,10,"2019-05-11",null,"","","","","","",1,"","",1,""]
[5,12,5,0.5,0,0,0,1,0,41,5.5,0,1,11,"2019-05-12",null,1,"","","","","",1,1,1,"",""]
[5,13,15,0,0,0,43,15,0,0,1,0,0,12,"2019-05-13",null,1,"","","",1,1,"",1,"","",""]
[5,14,14,0,0,2.5,0,0,0,0,0,0,0,13,"2019-05-14",null,1,"","",1,1,1,"",1,"","",""]
[5,15,0,0,2.5,0,0,0,0,0,7,0,6,14,"2019-05-15",null,1,"",1,"",1,"","","",1,"",1]
[5,16,0,6,43,0,0,0,75.5,22,0,0,0,15,"2019-05-16",null,"",1,1,"","","",1,1,"","",""]
[5,17,0,31,0,0,0,0,1.5,0,0,0,1.5,16,"2019-05-17",null,"",1,1,"","","",1,1,"","",""]
[5,18,0,1,20.5,0,19.5,0,0,6,0,0,0,17,"2019-05-18",null,"",1,1,"",1,"",1,1,"","",""]
[5,19,0,1,1,0,1.5,0,0,6,0,8.5,0,18,"2019-05-19",null,"",1,1,"",1,"","",1,"",1,""]
[5,20,0,20,0,11.5,0,0,0,1.5,8.5,0.5,0,19,"2019-05-20",null,"",1,"",1,"","","","",1,"",""]
[5,21,0,25,0,28,0,0,0,0,37,0,0,20,"2019-05-21",null,"",1,"",1,"","","","",1,"",""]
[5,22,0.5,0,0,0,0,0,0,0,0,0,0.5,21,"2019-05-22",null,"",1,"",1,"","","","",1,"",""]
[5,23,0,0,0,0,7,0,0,0,0,0,0,22,"2019-05-23",null,"","","","",1,"","","",1,"",""]
[5,24,0,5,0,0,0,1.5,0,0,0,0,0,23,"2019-05-24",null,"",1,{"$f":"IF(E29>=$C$108,1,IF(E28>=$C$109,1,IF(E27>=$C$110,1,\"\")))","v":""},"","","","","","","",""]
[5,25,0,0,0.5,0,0,14,0,0,0,0,3,24,"2019-05-25",null,{"$f":"IF(C30>=$C$108,1,IF(C29>=$C$109,1,IF(C28>=$C$110,1,\"\")))","v":""},"","","","",1,"","","","",1]
[5,26,3.5,0,7,0,0,0,0.5,0,4.5,0,0,25,"2019-05-26",null,1,"",1,"","",1,"","",1,"",""]
[5,27,8.5,23,0,0,0,0,2.5,0,0,0,0,26,"2019-05-27",null,1,1,"","","","",1,"","","",""]
[5,28,0,0,0,45,0,0,0.5,0,0,13.5,0,27,"2019-05-28",null,"",1,"",1,"","","","","",1,""]
[5,29,0,0,0,0,0,0,15,0,0,8,8,28,"2019-05-29",null,"","","",1,"","",1,"","",1,1]
[5,30,0,0,0,0,11.5,0,9,0,0,2.5,0.5,29,"2019-05-30",null,"","","",1,1,"",1,"","",1,""]
[5,31,2,0,1,2,17.5,0.5,0,0,0,0,0,30,"2019-05-31",null,1,"","",1,1,"","","","","",""]
[6,1,0,0,0,0,0,14.5,0,0,0,0,0,31,"2019-06-01",null,"","","","",1,1,"","","","",""]
[6,2,0,0,0,0,0,0,0,0,0,0,1.5,32,"2019-06-02",null,"","","","","",1,"","","","",""]
[6,3,0,0,0,0,0,0,0,38.5,0,0,0,33,"2019-06-03",null,"","","","","","","",1,"","",""]
[6,4,0,32,0,0,0,0,4,0,0,0,0,34,"2019-06-04",null,"",1,"","","","",1,1,"","",""]
[6,5,6,0,0,0,0,0,5,24.5,2.5,0,0,35,"2019-06-05",null,1,1,"","","","",1,1,1,"",""]
[6,6,35.5,0,0,0,31,0,0,1.5,0,18,0,36,"2019-06-06",null,1,1,"","",1,"","",1,"",1,""]
[6,7,2,0,0,21.5,0,23,10,0,1,0,0,37,"2019-06-07",null,1,"","",1,1,1,1,"","",1,""]
[6,8,0,0,0,3.5,7,1,0,3.5,0.5,0,32.5,38,"2019-06-08",null,1,"","",1,1,1,1,1,"","",1]
[6,9,0,0,0,0,4,0,2,8,16.5,0,5,39,"2019-06-09",null,"","","","",1,"",1,1,1,"",1]
[6,10,0,0,0,1,2.5,0,0,0,0.5,0,0,40,"2019-06-10",null,"","","","",1,"","","",1,"",1]
[6,11,0.5,0,15.5,0,10.5,0,0,6,0.5,0,0,41,"2019-06-11",null,"","",1,"",1,"","",1,"","",""]
[6,12,0,0,28.5,0,2.5,0,18,10,27.5,0,0.5,42,"2019-06-12",null,"","",1,"",1,"",1,1,1,"",""]
[6,13,0,7.5,52,0,2.5,0,27,0,0.5,0,0,43,"2019-06-13",null,"",1,1,"",1,"",1,1,1,"",""]
[6,14,9.5,8.5,26,0,0,0,0.5,0,0,0,0,44,"2019-06-14",null,1,1,1,"","","",1,"","","",""]
[6,15,1.5,33,0,36.5,1,0,0,0,0,9.5,1.5,45,"2019-06-15",null,"",1,1,1,"","","","","",1,""]
[6,16,0,12,0,5,0,0,16.5,0,0,0,44.5,46,"2019-06-16",null,"",1,"",1,"","",1,"","","",1]
[6,17,0,0,0,0.5,0,0,3,0,0,0,11,47,"2019-06-17",null,"",1,"",1,"","",1,"","","",1]
[6,18,0,4,15.5,0,0,0,0,2,0,0,0,48,"2019-06-18",null,"",1,1,"","","","",1,"","",1]
[6,19,0,20,48,0,2.5,0,4.5,11,0,57.5,68,49,"2019-06-19",null,"",1,1,"",1,"",1,1,"",1,1]
[6,20,0,0,0.5,0,35,0.5,0,0.5,2.5,18,2.5,50,"2019-06-20",null,"",1,1,"",1,"","",1,1,1,1]
[6,21,6,0,0,0,0,28,16,13,0.5,7.5,19,51,"2019-06-21",null,1,"",1,"",1,{"$f":"IF(H57>=$C$108,1,IF(H56>=$C$109,1,IF(H55>=$C$110,1,\"\")))","v":1},1,1,"",1,1]
[6,22,0.5,0,0,0,0,0,14,0,7,0,23.5,52,"2019-06-22",null,"","","","",1,1,1,1,1,"",1]
[6,23,0,0,0,0,4,0,17.5,0,0,0,0,53,"2019-06-23",null,"","","","",1,"",1,"","","",1]
[6,24,3,12,0,0,0,0.5,8,1.5,0,1,0,54,"2019-06-24",null,1,1,"","","","",1,"","","",""]
[6,25,0,0,2,0,0,24,17,0,0,0,1.5,55,"2019-06-25",null,"",1,1,"","",1,1,"","","",""]
[6,26,0,0,2,0,0,0,0,22.5,28.5,54.5,0,56,"2019-06-26",null,{"$f":"IF(C62>=$C$108,1,IF(C61>=$C$109,1,IF(C60>=$C$110,1,\"\")))","v":""},"",1,"","",1,1,1,1,1,""]
[6,27,8,0,0.5,8.5,0,0,13.5,0.5,0,0,0,57,"2019-06-27",null,1,"","",1,"","",1,1,1,1,""]
[6,28,0,0,26.5,0,15.5,3.5,7.5,1.5,16.5,0,0,58,"2019-06-28",null,"","",1,"",1,1,1,"",1,1,""]
[6,29,0,1.5,0,8.5,59,6.5,5.5,0,0,0,0,59,"2019-06-29",null,"","",1,1,1,1,1,"",1,"",""]
[6,30,0,2.5,12.5,11.5,4,40,0,13,0,0,4,60,"2019-06-30",null,"",1,1,1,1,1,"",1,"","",1]
[7,1,0,7.5,0,2,0,13.5,0,10,0,0,34.5,61,"2019-07-01",null,""]
[7,2,0,6.5,0.5,1.5,0,15,0,0,0,0,0,62,"2019-07-02",null,""]
[7,3,132,1.5,36,2.5,0,0,11,0,13,11,32,63,"2019-07-03",null,1,"",1,1,"",1,1,"",1,1,1]
[7,4,4.5,0.5,11.5,0.5,19.5,69.5,17,19,1,47,0,64,"2019-07-04",null,1,"",1,"",1,1,1,1,1,1,1]
[7,5,6,2,0,0,89,12,0,0,7.5,21,16,65,"2019-07-05",null,1,1,1,"",1,1,1,1,1,1,1]
[7,6,0,0.5,38.5,0,90,0,0,0.5,21,2.5,36.5,66,"2019-07-06",null,"","",1,"",1,1,"","",1,1,1]
[7,7,0,79,19,0,146,0,0,12.5,6,0,16,67,"2019-07-07",null,"",1,1,"",1,"","",1,1,"",1]
[7,8,0,34.5,33,0,0,0,3,7,0,0,0,68,"2019-07-08",null,"",1,1,"",1,"",1,1,"","",1]
[7,9,40.5,8.5,1,11.5,0,4,20.5,37,0,0,0,69,"2019-07-09",null,1,1,1,1,1,1,1,1,"","",""]
[7,10,0,1.5,16,0,0,16,0,0,6.5,0,0,70,"2019-07-10",null,1,1,1,1,"",1,1,1,1,"",""]
[7,11,0,12,8,12,0,0,0,0,1,0,0,71,"2019-07-11",null,1,1,1,1,"",1,"",1,"","",""]
[7,12,46.5,0.5,2,1,0,0,4,0,0,0,16.5,72,"2019-07-12",null,1,1,1,1,"","",1,"","","",1]
[7,13,0.5,7,26,7,0,0,53,0,10.5,29.5,4.5,73,"2019-07-13",null,1,1,1,1,"","",1,"",1,1,1]
[7,14,6.5,0.5,21.5,12.5,0,0,58,0,2,2.5,0,74,"2019-07-14",null,1,"",1,1,"","",1,"",1,1,""]
[7,15,18.5,15,0,0,0,0,2.5,0,0,2.5,3,75,"2019-07-15",null,1,1,1,1,"","",1,"","",1,1]
[7,16,0,4.5,0,0,0,11.5,0,16.5,0,0,0,76,"2019-07-16",null,1,1,"","","",1,1,1,"","",""]
[7,17,0,0,1.5,0,0,0,3,117,0,0,0,77,"2019-07-17",null,"","","","","",1,1,1,"","",""]
[7,18,0,0,1.5,21,0,13.5,0,9,8.5,0.5,0,78,"2019-07-18",null,"","","",1,"",1,"",1,1,"",""]
[7,19,48.5,14.5,0,16,0,0,0,2.5,14,0,0,79,"2019-07-19",null,1,1,"",1,"",1,"",1,1,"",""]
[7,20,0,8.5,0,1.5,0,0,0,0,0,0,46,80,"2019-07-20",null,1,1,"",1,"","","","",1,"",1]
[7,21,4.5,0,68,0,0,0,0,0,0,0,0.5,81,"2019-07-21",null,1,"",1,"","","","","","","",1]
[7,22,2,0,1.5,11,0,0,0,4.5,0,2,10,82,"2019-07-22",null,1,"",1,1,"","","",1,"",1,1]
[7,23,1,0,0.5,20,0,0,0,24,0,0,0,83,"2019-07-23",null,"","",1,1,"","","",1,{"$f":"IF(K89>=$C$108,1,IF(K88>=$C$109,1,IF(K87>=$C$110,1,\"\")))","v":""},"",1]
[7,24,0,0,11,0.5,0,5.5,0,0,0,4.5,0,84,"2019-07-24",null,{"$f":"IF(C90>=$C$108,1,IF(C89>=$C$109,1,IF(C88>=$C$110,1,\"\")))","v":""},"",1,1,"",1,"",1,"",1,""]
[7,25,0,0,25,0,0,26.5,0,0,0,0.5,0,85,"2019-07-25",null,"","",1,"","",1,"","","","",""]
[7,26,0,0,2,0,0,4,22.5,0,0,0,0,86,"2019-07-26",null,"","",1,"","",1,1,"","","",""]
[7,27,43,0,3,4.5,0,2.5,0,1.5,1.5,0,0,87,"2019-07-27",null,1,"",1,1,"",1,1,"","","",""]
[7,28,1.5,0,1.5,0,0,1,0,2,0,1.5,0,88,"2019-07-28",null,1,"","","","","","",1,"","",""]
[7,29,0,2.5,7.5,0,16.5,0,0,0.5,0,10.5,0,89,"2019-07-29",null,1,1,1,"",1,"","","","",1,""]
[7,30,0,0,2.5,0,0,12,0,0.5,0,0,0,90,"2019-07-30",null,"","",1,"",1,1,"","","",1,""]
[7,31,0,0,0,0,0,0,0,0,36,0,0,91,"2019-07-31",null,"","","","","",1,"","",1,"",""]
[8,1,0,0,0,0,0,0,0,0,0,37,0,92,"2019-08-01",null,"","","","","","","","",1,1,""]
[8,2,0,0,0,7,0,0,0,0,0,0.5,0,93,"2019-08-02",null,"","","",1,"","","","",1,1,""]
[8,3,0,32,0,3.5,0,0,0,0,1.5,0,0,94,"2019-08-03",null,"",1,"",1,"","","","","",1,""]
[8,4,41,0,0,0,0,0,0,0,7,0,0,95,"2019-08-04",null,1,1,"","","","","","",1,"",""]
[8,5,27.5,0,0,0,0,0,0,0,0.5,8.5,0,96,"2019-08-05",null,1,1,"","","","","","","",1,""]
[8,6,0,0,0,2,0,33,0,2.5,3.5,0,0,97,"2019-08-06",null,1,"","",1,"",1,"",1,1,"",""]
[]
[null,"土寄せ作業可能か\nどうかの判断条件",null,null,"判断日",{"$f":"判断日","v":"2025-06-01"},null,null,"判断年",{"$f":"YEAR(判断日)","v":2025},null,null,null,null,null,"可能日の",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,"適期始","適期終",null,null,"5/1から数えて",null,null,null,null,null,"10年平均","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","近5年平均","近3年平均","最多日数","最少日数"]
[null,"作業できない降雨量mm",null,null,"土寄①",{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"土寄①終修正","v":"2025-07-01"},null,"土寄①適期始は",{"$f":"$F$107-DATEVALUE(TEXT(判断年,\"####\")&\"/5/1\")","v":51},"日後",null,null,null,"5月",{"$f":"AVERAGE(Q107:Z107)","v":21.1},{"$f":"31-SUM(Q$6:Q$36)","v":22},{"$f":"31-SUM(R$6:R$36)","v":18},{"$f":"31-SUM(S$6:S$36)","v":21},21,18,25,18,23,22,23,23,{"$f":"AVERAGE(Q107:U107)","v":20},{"$f":"AVERAGE(Q107:S107)","v":20.333333333333332},{"$f":"MAX(Q107:Z107)","v":25},{"$f":"MIN(Q107:Z107)","v":18}]
[null,"当日",{"$f":"入力表!C26","v":2},"mm","土寄②",{"$f":"土寄②始修正","v":"2025-07-06"},{"$f":"土寄②終","v":"2025-07-16"},null,"土寄①適期終は",{"$f":"$G$107-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":61},"日後",null,null,null,"6月",17.100000000000001,{"$f":"30-SUM(Q$37:Q$66)","v":22},{"$f":"30-SUM(R$37:R$66)","v":16},{"$f":"30-SUM(S$37:S$66)","v":16},22,13,19,10,13,19,21,18,{"$f":"AVERAGE(Q108:U108)","v":17.8},{"$f":"AVERAGE(Q108:S108)","v":18},{"$f":"MAX(Q108:Z108)","v":22},{"$f":"MIN(Q108:Z108)","v":10}]
[null,"翌日",{"$f":"入力表!C27","v":10},"mm","除草剤",{"$f":"茎葉始","v":"2025-07-13"},{"$f":"茎葉終","v":"2025-07-23"},null,"土寄②適期始は",{"$f":"$F$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":66},"日後",null,null,null,"7月",16.5,{"$f":"31-SUM(Q$67:Q$97)","v":13},{"$f":"31-SUM(R$67:R$97)","v":18},{"$f":"31-SUM(S$67:S$97)","v":9},16,23,14,17,16,19,20,18,15.8,13.333333333333334,23,9]
[null,"２日後",{"$f":"入力表!C28","v":30},"mm","摘心",{"$f":"摘心始","v":"7/1以降の主茎長で判断"},{"$f":"摘心終","v":"2025-07-21"},null,"土寄②適期終は",{"$f":"$G$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":76},"日後",null,null,null,"6/25-7/24",15.3,{"$f":"30-SUM(Q$61:Q$90)","v":14},{"$f":"31-SUM(R$61:R$90)","v":17},{"$f":"31-SUM(S$61:S$90)","v":9},14,22,14,14,14,16,19,17,15.2,13.333333333333334,22,9]
[null,null,"↑",null,null,null,null,null,"除草剤適期始行",{"$f":"$F$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":73},"日後",null,null,"土寄せ①適期日数",{"$f":"G107-F107+1","v":11},6.3,{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,Q$105,$J$108-$J$107+1,1))","v":11},{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,R105,$J$108-$J$107+1,1))","v":8},8,5,8,5,4,2,6,6,7,8,9,11,2]
[null,null,"入力された条件",null,null,null,null,null,"除草剤適期終行",{"$f":"$G$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":83},"日後",null,null,"土寄せ②適期日数",{"$f":"G108-F108+1","v":11},4.8,{"$f":"$O112-SUM(OFFSET(表の5月1日位置,$J$109,Q$105,$J$110-$J$109+1,1))","v":11},3,2,1,4,7,6,3,5,6,7,4.2,5.333333333333333,11,1]
[null,null,null,null,null,null,null,null,"摘心適期始行",{"$f":"$F$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":{"$error":"#VALUE!"}},"日後",null,null,"除草剤適期日数",{"$f":"G109-F109+1","v":11},6.6,{"$f":"$O113-COUNTIF(OFFSET(表の5月1日位置,$J$111,-13+Q$105,$J$112-$J$111+1,1),\">=1\")","v":5},6,5,4,11,9,7,5,7,7,7,6.2,5.333333333333333,11,4]
[null,null,null,"土寄①","土寄②","除草剤","摘心",null,"摘心適期終行",{"$f":"$G$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":81},"日後",null,null,"摘心適期日数",{"$f":"G110-F110+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"$O114-COUNTIF(OFFSET(表の5月1日位置,$J$113,-13+Q$105,$J$114-$J$113+1,1),\">=1\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["適期作業の確率",null,null,{"$f":"P111/O111","v":0.57272727272727275},{"$f":"P112/O112","v":0.43636363636363634},{"$f":"P113/O113","v":0.6},{"$f":"P114/O114","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"7月の1mm以上降雨日数",{"$f":"AVERAGE(R115:AA115)","v":12.7},{"$f":"COUNTIF(C67:C97,\">=1\")","v":13},15,22,14,5,14,10,13,13,11,10,{"$f":"AVERAGE(R115:V115)","v":14},{"$f":"AVERAGE(R115:T115)","v":17},{"$f":"MAX(R115:AA115)","v":22},{"$f":"MIN(R115:AA115)","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-28",null,"2020-02-28",43524,43889]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",null,"2020-02-29",43525,43890]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"作表日付","2019-03-02",null,"2020-03-01",43526,43891]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断日",null,null,"2019-05-01",43586,null,"5/1の行",{"$f":"ROW(表の5月1日位置)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年",null,null,"2020-07-03",44015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年5/1算出",null,null,null,43952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期始の行",null,null,"=DATEVALUE(TEXT(P127,\"####\")&\"/5/1\")",{"$f":"DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":45778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期終の行",null,null,"=$M$106-$Q$128",{"$f":"$F$107-$R$131","v":51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"適期始～適期終の不可日",null,null,"=$N$106-$Q$128",{"$f":"$G$107-$R$131","v":61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(OFFSET($O$6,$R$132,4,58-53+1,1))","v":3}]
[]
[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,"=ROW(表の5月1日位置)+($M$106-$Q$128)",{"$f":"ROW(表の5月1日位置)+($F$107-$R$131)","v":57},"セル位置",{"$f":"ADDRESS(R137,17)","v":"$Q$57"},{"$f":"6+($F$107-$R$131)","v":57},{"$f":"T137","v":"$Q$57"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期内の不可日数",null,null,"=ROW(表の5月1日位置)+($M$107-$Q$128)",{"$f":"ROW(表の5月1日位置)+($G$107-$R$131)","v":67},null,{"$f":"ADDRESS(R138,17)","v":"$Q$67"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期終の行",null,null,null,{"$f":"SUM(T137:T138)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上の枠内不要"]

{"sheet":"アメダス三和","index":9,"n_rows":141,"n_cols":31,"rows_kept":141,"cut":false,"hidden":false,"merged":[[104,1,105,3],[104,5,104,6]]}
[null,"降雨日から見た黒大豆作業の検討",null,null,null,null,null,null,null,{"$f":"\"（\"&C3&\"～\"&L3&\"年平均）\"","v":"（2022～2013年平均）"}]
[null,"アメダス三和データ"]
["月","日",2022,2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,null,null,null,{"$f":"C3","v":2022},2021,2020,2019,2018,2017,2016,2015,2014,2013,2012]
[4,29,53.5,61.5,0,13.5,0,1.5,0,0,38,0,0,null,"2019-04-29",null,{"$f":"IF(C4>=$C$108,1,\"\")","v":1},1,"",1,"","","","",1,"",""]
[4,30,0.5,0.5,0,14.5,0,0,0,0,13,4.5,0,null,"2019-04-30",null,{"$f":"IF(C5>=$C$108,1,IF(C4>=$C$109,1,\"\"))","v":1},1,"",1,"","","","",1,1,""]
[5,1,8,1.5,0,10.5,0,0,0,0,0.5,0,0,0,"2019-05-01",null,{"$f":"IF(C6>=$C$108,1,IF(C5>=$C$109,1,IF(C4>=$C$110,1,\"\")))","v":1},1,"",1,"","","","",1,"",""]
[5,2,0.5,5,0,0,4.5,0,0,0,0,1,28,1,"2019-05-02",null,"",1,"",1,1,"","","","","",1]
[5,3,0,0,2.5,0,1,0,5.5,0,0,0,9.5,2,"2019-05-03",null,"","",1,"","","",1,"","","",1]
[5,4,0,0,0.5,0,0,0,0.5,1.5,0,1.5,2,3,"2019-05-04",null,"","","","","","","","","","",1]
[5,5,0,7,0,0,0,0,0,0,0,0,1,4,"2019-05-05",null,"",1,"","","","","","","","",""]
[5,6,0,0.5,1.5,6,12.5,2,6,0,0,0,4,5,"2019-05-06",null,"","","",1,1,1,1,"","","",1]
[5,7,0,0,0,0,47.5,0,0,0,0,0,0,6,"2019-05-07",null,"","","","",1,"","","","","",""]
[5,8,0,0,0,0,13,0,0,0,0,0,0,7,"2019-05-08",null,"","","","",1,"","","","","",""]
[5,9,0,0.5,3,0,7.5,4.5,11.5,0,0,0,0,8,"2019-05-09",null,"","",1,"",1,1,1,"","","",""]
[5,10,0,0,4.5,0,0,2.5,1,0,0,3.5,0,9,"2019-05-10",null,"","",1,"","",1,1,"","",1,""]
[5,11,4,0,0,0,0,0,18.5,0,0,6.5,0,10,"2019-05-11",null,1,"","","","","",1,"","",1,""]
[5,12,4,0.5,0,0,0,0.5,0,41.5,5,0,1,11,"2019-05-12",null,1,"","","","","",1,1,1,"",""]
[5,13,12,0,0,0,44,10,0,0,1,0,0,12,"2019-05-13",null,1,"","","",1,1,"",1,"","",""]
[5,14,9,0,0,4,0,0,0,0,0,0,0,13,"2019-05-14",null,1,"","",1,1,1,"",1,"","",""]
[5,15,0,0.5,3,0,0,0,0,0,3.5,0,3,14,"2019-05-15",null,"","",1,"",1,"","","",1,"",1]
[5,16,0,5,40.5,0,0,0,81.5,26,0,0,0,15,"2019-05-16",null,"",1,1,"","","",1,1,"","",""]
[5,17,0,20,0,0,0,0,0.5,0,0,0,0.5,16,"2019-05-17",null,"",1,1,"","","",1,1,"","",""]
[5,18,0,1,14,0,20.5,0,0,7,0,0,0.5,17,"2019-05-18",null,"",1,1,"",1,"",1,1,"","",""]
[5,19,0,0.5,1,0,1.5,0,0,3,0,4.5,0,18,"2019-05-19",null,"","",1,"",1,"","",1,"",1,""]
[5,20,0,22,0,11,0,0,0,2.5,10,1,0,19,"2019-05-20",null,"",1,"",1,"","","",1,1,"",""]
[5,21,0,12.5,0,24,0,0,0,0,42.5,0,0,20,"2019-05-21",null,"",1,"",1,"","","","",1,"",""]
[5,22,1.5,0,0,0,0,0,0,0,0,0,0,21,"2019-05-22",null,"",1,"",1,"","","","",1,"",""]
[5,23,0,0,0,3.5,7.5,0,0,0,0,0,0,22,"2019-05-23",null,"","","",1,1,"","","",1,"",""]
[5,24,0,4,0,0,0.5,2.5,0,0,0,0,0,23,"2019-05-24",null,"",1,{"$f":"IF(E29>=$C$108,1,IF(E28>=$C$109,1,IF(E27>=$C$110,1,\"\")))","v":""},"","",1,"","","","",""]
[5,25,0,0,0,0,0,18,0,0,0,0,1,24,"2019-05-25",null,{"$f":"IF(C30>=$C$108,1,IF(C29>=$C$109,1,IF(C28>=$C$110,1,\"\")))","v":""},"","","","",1,"","","","",""]
[5,26,1.5,0,10,0,0,0,0.5,0,2.5,0,0,25,"2019-05-26",null,"","",1,"","",1,"","",1,"",""]
[5,27,41,22,0,0,0,0,3.5,0,0,0,0,26,"2019-05-27",null,1,1,1,"","","",1,"","","",""]
[5,28,0,0,0,24,0,0,0,0,0,8,0,27,"2019-05-28",null,1,1,"",1,"","","","","",1,""]
[5,29,0,0,0,0,0,0,17.5,0,0,8.5,17,28,"2019-05-29",null,1,"","",1,"","",1,"","",1,1]
[5,30,0,0,0,0,9,0,7.5,0,0,2,0,29,"2019-05-30",null,"","","","",1,"",1,"","",1,1]
[5,31,0.5,0,1,0.5,4.5,0.5,0,0,0,0,0,30,"2019-05-31",null,"","","","",1,"","","","","",""]
[6,1,0,0,0,0.5,0,13.5,0,0,0,0,0,31,"2019-06-01",null,"","","","","",1,"","","","",""]
[6,2,0,0,0,0,0,0,0,0,0,0,0,32,"2019-06-02",null,"","","","","",1,"","","","",""]
[6,3,0,0,0,0,0,0,0,38.5,0,0,0,33,"2019-06-03",null,"","","","","","","",1,"","",""]
[6,4,0,38,0,0,0,0,4,0,2,0,0,34,"2019-06-04",null,"",1,"","","","",1,1,1,"",""]
[6,5,5.5,0,0,0,1,0,7,20.5,4.5,0,0,35,"2019-06-05",null,1,1,"","","","",1,1,1,"",""]
[6,6,40.5,0,0,0,32.5,0,0,1,0,2,0,36,"2019-06-06",null,1,1,"","",1,"","",1,"",1,""]
[6,7,3,0,0,23,0,22.5,7,0,0,0,0,37,"2019-06-07",null,1,"","",1,1,1,1,"","","",""]
[6,8,0,0,0,3,10,1.5,0,3,0,0,37,38,"2019-06-08",null,1,"","",1,1,1,"",1,"","",1]
[6,9,0,0,0,0,5.5,0,8.5,8.5,20,0,8,39,"2019-06-09",null,"","","","",1,"",1,1,1,"",1]
[6,10,0,0,0,1,1.5,0,0,0,0,0,0,40,"2019-06-10",null,"","","","","","","","",1,"",1]
[6,11,0.5,0,12.5,0,13.5,0,0,3.5,6,0,0,41,"2019-06-11",null,"","",1,"",1,"","",1,1,"",""]
[6,12,0,0,28,0,2.5,0,24,3,32.5,0,1,42,"2019-06-12",null,"","",1,"",1,"",1,1,1,"",""]
[6,13,0,15,50,0,2,0,34.5,0,0,0,0,43,"2019-06-13",null,"",1,1,"",1,"",1,"",1,"",""]
[6,14,10.5,6.5,19,0,0,0,0.5,0,0,0,0,44,"2019-06-14",null,1,1,1,"","","",1,"",1,"",""]
[6,15,1,0.5,0,43,2,0,0,0,0,12.5,1,45,"2019-06-15",null,1,"",1,1,1,"",1,"","",1,""]
[6,16,0,12,0,6,0,0,19,0,0,0.5,36,46,"2019-06-16",null,"",1,"",1,"","",1,"","",1,1]
[6,17,0,0,0,0,0,0,2,0,0,0,8.5,47,"2019-06-17",null,"",1,"",1,"","",1,"","","",1]
[6,18,0,5,18.5,0,0,0,0,5.5,1,0,0,48,"2019-06-18",null,"",1,1,"","","","",1,"","",1]
[6,19,0,15.5,46,0,3,0,4.5,15.5,0,46,83.5,49,"2019-06-19",null,"",1,1,"",1,"",1,1,"",1,1]
[6,20,0,0,0,0,35.5,0.5,0,0,0,16.5,0.5,50,"2019-06-20",null,"",1,1,"",1,"","",1,"",1,1]
[6,21,9,0,0,0,0,33,18,15,6,6.5,21,51,"2019-06-21",null,1,"",1,"",1,{"$f":"IF(H57>=$C$108,1,IF(H56>=$C$109,1,IF(H55>=$C$110,1,\"\")))","v":1},1,1,1,1,1]
[6,22,1,0,0,0,0,0,17,0,5.5,0,25.5,52,"2019-06-22",null,"","","","",1,1,1,1,1,"",1]
[6,23,0,0,0,0,3.5,0,20.5,0,0,0,0,53,"2019-06-23",null,"","","","",1,1,1,"","","",1]
[6,24,9.5,0,0,0,0,1.5,8.5,0.5,0,1,0.5,54,"2019-06-24",null,1,"","","","","",1,"","","",""]
[6,25,0,0,3.5,0,0,20,16.5,0,0,0,3,55,"2019-06-25",null,"","",1,"","",1,1,"","","",1]
[6,26,0,0,2.5,0,0,0,4,22.5,0,61,0,56,"2019-06-26",null,{"$f":"IF(C62>=$C$108,1,IF(C61>=$C$109,1,IF(C60>=$C$110,1,\"\")))","v":""},"",1,"","",1,1,1,"",1,""]
[6,27,0,0.5,1.5,8,0,0,14.5,0,0,0,0,57,"2019-06-27",null,"","","",1,"","",1,1,"",1,""]
[6,28,0,11,18.5,0.5,16,3,9,2.5,12.5,0,0,58,"2019-06-28",null,"",1,1,"",1,1,1,1,1,1,""]
[6,29,0,3,0,6.5,57,6.5,5.5,0.5,5,0,0,59,"2019-06-29",null,"",1,1,1,1,1,1,"",1,"",""]
[6,30,0.5,3.5,9.5,13,1.5,35,0,16.5,0,0,6,60,"2019-06-30",null,"",1,1,1,1,1,"",1,"","",1]
[7,1,0,3.5,0.5,2,0,10.5,0,5,0,0.5,31.5,61,"2019-07-01",null,""]
[7,2,0,11,0,1.5,0,62,0,0,0,0,0,62,"2019-07-02",null,""]
[7,3,139.5,1.5,37.5,2.5,0,0,17,0,9.5,5,47.5,63,"2019-07-03",null,1,1,1,1,"",1,1,"",1,1,1]
[7,4,3,1,7,0,26,67.5,0.5,15,12,51,0,64,"2019-07-04",null,1,"",1,"",1,1,1,1,1,1,1]
[7,5,1.5,0.5,0,0,75,15.5,0,0.5,0,8.5,8.5,65,"2019-07-05",null,1,"",1,"",1,1,"",1,1,1,1]
[7,6,0,0.5,25,0,87,0,0,0,15.5,0,22.5,66,"2019-07-06",null,"","",1,"",1,1,"","",1,1,1]
[7,7,0,74.5,10.5,0,157.5,0,0,15.5,3.5,0.5,17,67,"2019-07-07",null,"",1,1,"",1,"","",1,1,"",1]
[7,8,46,58.5,23.5,0,0,0,3,27.5,0.5,0,0,68,"2019-07-08",null,1,1,1,"",1,"",1,1,"","",1]
[7,9,107,3,0.5,30,0,20.5,24.5,16,1.5,0,0,69,"2019-07-09",null,1,1,1,1,1,1,1,1,"","",""]
[7,10,0,2,17,0,0,5.5,0,0,14,0,0,70,"2019-07-10",null,1,1,1,1,"",1,1,1,1,"",""]
[7,11,0.5,23,6.5,12,0,0,0,0,0,0,0,71,"2019-07-11",null,1,1,1,1,"","","","",1,"",""]
[7,12,43.5,0.5,1,5,0,0,8,0,0,0,12,72,"2019-07-12",null,1,1,"",1,"","",1,"","","",1]
[7,13,1.5,24.5,26,6,0,1,27,0,7.5,40,0.5,73,"2019-07-13",null,1,1,1,1,"","",1,"",1,1,1]
[7,14,6.5,4,15.5,14,0,0,10,0,1.5,11.5,0,74,"2019-07-14",null,1,1,1,1,"","",1,"","",1,""]
[7,15,19,4,1,0,0,0,1,0,0,20.5,0,75,"2019-07-15",null,1,1,1,1,"","",1,"","",1,""]
[7,16,0,2,0,0,0,19,0,21.5,0,0,0,76,"2019-07-16",null,1,1,"","","",1,"",1,"",1,""]
[7,17,3,0,0.5,0,0,0,5,114,0,0,0,77,"2019-07-17",null,1,"","","","",1,1,1,"","",""]
[7,18,0,0,0.5,18,0,3.5,0,1,12,0.5,0,78,"2019-07-18",null,"","","",1,"",1,"",1,1,"",""]
[7,19,40.5,0,0,18.5,0,0,0,0.5,24.5,0,0,79,"2019-07-19",null,1,"","",1,"","","",1,1,"",""]
[7,20,0,0,0,1,0,0,0,0,0,0,5.5,80,"2019-07-20",null,1,"","",1,"","","","",1,"",1]
[7,21,4,0,39,0,0,0,0,0,0,0,0,81,"2019-07-21",null,1,"",1,"","","","","","","",""]
[7,22,0.5,0,3.5,8,1,0,0,10,0,14.5,18,82,"2019-07-22",null,"","",1,1,"","","",1,"",1,1]
[7,23,4,0,0,3,0,0,0,20,0,1.5,0,83,"2019-07-23",null,1,"",1,1,"","","",1,{"$f":"IF(K89>=$C$108,1,IF(K88>=$C$109,1,IF(K87>=$C$110,1,\"\")))","v":""},1,1]
[7,24,0,0,16,44,0,3,0,0,0,2.5,0,84,"2019-07-24",null,{"$f":"IF(C90>=$C$108,1,IF(C89>=$C$109,1,IF(C88>=$C$110,1,\"\")))","v":""},"",1,1,"",1,"",1,"",1,""]
[7,25,0,0,38,0,0,24,0,0,0,3.5,0,85,"2019-07-25",null,"","",1,1,"",1,"","","",1,""]
[7,26,0,0,4,0,0,1,13.5,0,0,0,0,86,"2019-07-26",null,"","",1,1,"",1,1,"","","",""]
[7,27,44,0,2,15.5,0,1,0.5,0,6.5,0,0,87,"2019-07-27",null,1,"",1,1,"","",1,"",1,"",""]
[7,28,0,0,5.5,0,0,0.5,0,15.5,0,4,5.5,88,"2019-07-28",null,1,"",1,1,"","","",1,"",1,1]
[7,29,0,3.5,4.5,0,29.5,0,0,6.5,0,7.5,0,89,"2019-07-29",null,1,1,1,"",1,"","",1,"",1,""]
[7,30,0,0,6.5,0,0,39,0,0,0,54.5,0,90,"2019-07-30",null,"","",1,"",1,1,"","","",1,""]
[7,31,0,0,0,0,0,2,0,0,0,2.5,0,91,"2019-07-31",null,"","","","","",1,"","","",1,""]
[8,1,0,0,0,0,0,0,0,0,0,34.5,0,92,"2019-08-01",null,"","","","","",1,"","","",1,""]
[8,2,0,0,0,0,0,0,0,0,0,0,0,93,"2019-08-02",null,"","","","","","","","","",1,""]
[8,3,11,27,0,0,0,0,0,0,2,0,0,94,"2019-08-03",null,1,1,"","","","","","",1,1,""]
[8,4,3.5,0,0,0,0,0,0,0,4.5,0,0,95,"2019-08-04",null,1,1,"","","","","","",1,"",""]
[8,5,0,0,0,0,0,0,0,0,1,19,0.5,96,"2019-08-05",null,"","","","","","","","","",1,""]
[8,6,0,0,0,0,0,0,0,3.5,1.5,0,1.5,97,"2019-08-06",null,"","","","","","","",1,"",1,""]
[]
[null,"土寄せ作業可能か\nどうかの判断条件",null,null,"判断日",{"$f":"判断日","v":"2025-06-01"},null,null,"判断年",{"$f":"YEAR(判断日)","v":2025},null,null,null,null,null,"可能日の",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,"適期始","適期終",null,null,"5/1から数えて",null,null,null,null,null,"10年平均","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","作業可能日","近5年平均","近3年平均","最多日数","最少日数"]
[null,"作業できない降雨量mm",null,null,"土寄①",{"$f":"土寄①始修正","v":"2025-06-21"},{"$f":"土寄①終修正","v":"2025-07-01"},null,"土寄①適期始は",{"$f":"$F$107-DATEVALUE(TEXT(判断年,\"####\")&\"/5/1\")","v":51},"日後",null,null,null,"5月",{"$f":"AVERAGE(Q107:Z107)","v":21.5},{"$f":"31-SUM(Q$6:Q$36)","v":23},{"$f":"31-SUM(R$6:R$36)","v":19},{"$f":"31-SUM(S$6:S$36)","v":21},21,18,23,19,23,23,25,24,{"$f":"AVERAGE(Q107:U107)","v":20.399999999999999},{"$f":"AVERAGE(Q107:S107)","v":21},{"$f":"MAX(Q107:Z107)","v":25},{"$f":"MIN(Q107:Z107)","v":18}]
[null,"当日",{"$f":"入力表!C26","v":2},"mm","土寄②",{"$f":"土寄②始修正","v":"2025-07-06"},{"$f":"土寄②終","v":"2025-07-16"},null,"土寄①適期終は",{"$f":"$G$107-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":61},"日後",null,null,null,"6月",17.100000000000001,{"$f":"30-SUM(Q$37:Q$66)","v":22},{"$f":"30-SUM(R$37:R$66)","v":17},{"$f":"30-SUM(S$37:S$66)","v":16},22,14,18,10,13,18,21,17,{"$f":"AVERAGE(Q108:U108)","v":18.2},{"$f":"AVERAGE(Q108:S108)","v":18.333333333333332},{"$f":"MAX(Q108:Z108)","v":22},{"$f":"MIN(Q108:Z108)","v":10}]
[null,"翌日",{"$f":"入力表!C27","v":10},"mm","除草剤",{"$f":"茎葉始","v":"2025-07-13"},{"$f":"茎葉終","v":"2025-07-23"},null,"土寄②適期始は",{"$f":"$F$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":66},"日後",null,null,null,"7月",16.100000000000001,{"$f":"31-SUM(Q$67:Q$97)","v":11},{"$f":"31-SUM(R$67:R$97)","v":19},{"$f":"31-SUM(S$67:S$97)","v":9},13,23,17,19,16,19,15,19,15,13,23,9]
[null,"２日後",{"$f":"入力表!C28","v":30},"mm","摘心",{"$f":"摘心始","v":"7/1以降の主茎長で判断"},{"$f":"摘心終","v":"2025-07-21"},null,"土寄②適期終は",{"$f":"$G$108-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":76},"日後",null,null,null,"6/25-7/24",15.7,{"$f":"30-SUM(Q$61:Q$90)","v":13},{"$f":"31-SUM(R$61:R$90)","v":17},{"$f":"31-SUM(S$61:S$90)","v":10},14,22,16,16,14,18,17,18,15.2,13.333333333333334,22,10]
[null,null,"↑",null,null,null,null,null,"除草剤適期始行",{"$f":"$F$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":73},"日後",null,null,"土寄せ①適期日数",{"$f":"G107-F107+1","v":11},6.3,{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,Q$105,$J$108-$J$107+1,1))","v":11},{"$f":"$O111-SUM(OFFSET(表の5月1日位置,$J$107,R105,$J$108-$J$107+1,1))","v":9},8,5,8,5,3,2,5,7,7,8.1999999999999993,9.3333333333333339,11,2]
[null,null,"入力された条件",null,null,null,null,null,"除草剤適期終行",{"$f":"$G$109-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":83},"日後",null,null,"土寄せ②適期日数",{"$f":"G108-F108+1","v":11},5,{"$f":"$O112-SUM(OFFSET(表の5月1日位置,$J$109,Q$105,$J$110-$J$109+1,1))","v":11},2,1,2,4,7,7,4,6,6,6,4,4.666666666666667,11,1]
[null,null,null,null,null,null,null,null,"摘心適期始行",{"$f":"$F$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":{"$error":"#VALUE!"}},"日後",null,null,"除草剤適期日数",{"$f":"G109-F109+1","v":11},6.5,{"$f":"$O113-COUNTIF(OFFSET(表の5月1日位置,$J$111,-13+Q$105,$J$112-$J$111+1,1),\">=1\")","v":4},7,6,4,10,8,7,6,7,6,9,6.2,5.666666666666667,10,4]
[null,null,null,"土寄①","土寄②","除草剤","摘心",null,"摘心適期終行",{"$f":"$G$110-DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":81},"日後",null,null,"摘心適期日数",{"$f":"G110-F110+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"$O114-COUNTIF(OFFSET(表の5月1日位置,$J$113,-13+Q$105,$J$114-$J$113+1,1),\">=1\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["適期作業の確率",null,null,{"$f":"P111/O111","v":0.57272727272727275},{"$f":"P112/O112","v":0.45454545454545453},{"$f":"P113/O113","v":0.59090909090909094},{"$f":"P114/O114","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"7月の1mm以上降雨日数",{"$f":"AVERAGE(R115:AA115)","v":12.5},{"$f":"COUNTIF(C67:C97,\">=1\")","v":14},14,20,15,6,15,9,12,11,14,9,{"$f":"AVERAGE(R115:V115)","v":14},{"$f":"AVERAGE(R115:T115)","v":16.333333333333332},{"$f":"MAX(R115:AA115)","v":20},{"$f":"MIN(R115:AA115)","v":6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-28",null,"2020-02-28",43524,43889]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",null,"2020-02-29",43525,43890]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"作表日付","2019-03-02",null,"2020-03-01",43526,43891]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断日",null,null,"2019-05-01",43586,null,"5/1の行",{"$f":"ROW(表の5月1日位置)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年",null,null,"2020-07-03",44015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"判断年5/1算出",null,null,null,43952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期始の行",null,null,"=DATEVALUE(TEXT(P127,\"####\")&\"/5/1\")",{"$f":"DATEVALUE(TEXT($J$105,\"####\")&\"/5/1\")","v":45778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/1から土寄①適期終の行",null,null,"=$M$106-$Q$128",{"$f":"$F$107-$R$131","v":51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"適期始～適期終の不可日",null,null,"=$N$106-$Q$128",{"$f":"$G$107-$R$131","v":61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(OFFSET($O$6,$R$132,4,58-53+1,1))","v":3}]
[]
[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,"=ROW(表の5月1日位置)+($M$106-$Q$128)",{"$f":"ROW(表の5月1日位置)+($F$107-$R$131)","v":57},"セル位置",{"$f":"ADDRESS(R137,17)","v":"$Q$57"},{"$f":"6+($F$107-$R$131)","v":57},{"$f":"T137","v":"$Q$57"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期内の不可日数",null,null,"=ROW(表の5月1日位置)+($M$107-$Q$128)",{"$f":"ROW(表の5月1日位置)+($G$107-$R$131)","v":67},null,{"$f":"ADDRESS(R138,17)","v":"$Q$67"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土寄①適期終の行",null,null,null,{"$f":"SUM(T137:T138)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上の枠内不要"]