{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["報告書設定","ホーム","データ","preset","種雄牛","期末","他品種","【県液】","【県卵】","【国液】","【国卵】","データサンプル","種雄牛サンプル"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["No","項目","オブジェクト名","値"]
[1,"報告対象年次","year",2021]
[2,"宮城県知事名","president","---"]
[3,"免許の有無","licence",false]
[4,"許可の有無","permission",false]
[5,"氏名","myName"]
[6,"住所","myAddress"]
[7,"獣医師・授精師免許番号","licenceNum"]
[8,"授精所管理番号","permissionNum"]
[9,"授精所の名称","permissionName"]
[10,"授精所所在地","permissionAddress"]
[11,"業務１（精液生産）","gyoumu1",false]
[12,"業務２（体内受精卵生産）","gyoumu2",false]
[13,"業務３（体外受精卵生産・屠体）","gyoumu3",false]
[14,"業務４（体外受精卵生産・生体）","gyoumu4",false]
[15,"業務５（保存）","gyoumu5",false]
[16,"授精所の業務の別","---",{"$f":"IF(COUNTIF(D12:D16,TRUE)=0,\"\",LEFT(CONCATENATE(IF(D12=TRUE,\"１、\",\"\"),IF(D13=TRUE,\"２、\",\"\"),IF(D14=TRUE,\"３、\",\"\"),IF(D15=TRUE,\"４、\",\"\"),IF(D16=TRUE,\"５、\",\"\")),COUNTIF(D12:D16,TRUE)*2-1))","v":""}]

{"sheet":"ホーム","index":1,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,27],[3,1,3,13],[3,15,3,27],[13,1,13,13]]}
[null,"宮城県・国の精液・受精卵に係る報告書作成支援マクロ（2021年次版）"]
[null,"ホーム画面"]
[]
[null,"　期中データ の登録・修正",null,null,null,null,null,null,null,null,null,null,null,null,null,"　報告様式 の設定"]
[]
[null,null,"期中の精液・受精卵の譲受・譲渡等のデータを登録します。",null,null,null,null,null,null,null,null,null,null,null,null,null,"法・条例で定める報告様式に表示する氏名等の情報を設定します"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"データ入力後に「データ反映」ボタンを押してください"]
[]
[]
[]
[]
[]
[]
[null,"　種雄牛 の設定"]
[]
[null,null,"取り扱っている種雄牛の情報を登録します。",null,null,null,null,null,null,null,null,null,null,null,null,null,"マクロ（プログラム）が有効化されていません！！"]
[null,null,"精液の期首在庫本数を登録します。",null,null,null,null,null,null,null,null,null,null,null,null,null,"画面を下にスクロールすると有効化の手順があります"]
[]
[]
[]
[]
[]
[]
[null,null,"下記の手順でマクロを有効化してください。"]
[null,null,"　・画面上部（黄色の帯）に「保護ビュー」のメッセージが表示されている場合は、「編集を有効にする」 をクリックしてください"]
[null,null,"　・画面上部（黄色の帯）に「セキュリティの警告」のメッセージが表示されている場合は、「コンテンツの有効化」 をクリックしてください"]

{"sheet":"データ","index":2,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["データ"]
[]
[]
[]
["No","日付","液卵区分","特定区分","品種","種雄牛","処理内容","本数"]

{"sheet":"preset","index":3,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["種雄牛","よみがな","重複"]
["愛之国","あいのくに",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["秋忠平","あきただひら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["彩茂","あやしげ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝茂久","かつしげひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝忠久","かつただひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝忠平","かつただひら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝早桜５","かつはやざくら５",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝秀好","かつひでよし",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝洋","かつひろ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝福桜","かつふくざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝美桜１","かつみざくら１",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勘太","かんた",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["紀多福","きたふく",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["金太郎３","きんたろう３",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["幸紀雄","さきお",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["皐月彰","さつきしょう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂勝","しげかつ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂勝朗","しげかつろう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂晴花","しげはれはな",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂久桜","しげひさざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂洋","しげひろ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂洋美","しげひろみ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["茂福久","しげふくひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["勝吾","しょうご",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["鈴音","すずね",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["聖香藤","せいかふじ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["関平照","せきひらてる",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["第１花藤","だい１はなふじ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["隆之国","たかのくに",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["貴隼桜","たかはやざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["隆富志","たかふじ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["隆安国","たかやすくに",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["知恵久","ちえひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["徳悠翔","とくゆうしょう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["直太郎","なおたろう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["夏百合","なつゆり",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["奈津百合５５","なつゆり５５",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["花国１６５乃９","はなくに１６５の９",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["花国安福","はなくにやすふく",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["花茂桜","はなしげざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["華春久","はなはるひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["花久勝","はなひさかつ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["葉山桜","はやまざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["久関平","ひさせきひら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["平勝美（宮城）","ひらかつみ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["洋糸波","ひろいとなみ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["洋勝忠","ひろかつただ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["福忠平","ふくただひら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["福之姫","ふくのひめ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["福華１","ふくはな１",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["福久増","ふくひさます",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["福増","ふくます",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["蓬莱桜","ほうらいざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美国桜","みくにざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美津金幸","みつかねゆき",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美津北平","みつきたひら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美津忠","みつただ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美津照重","みつてるしげ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["光平照","みつひらてる",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["美津百合","みつゆり",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["実有貴","みゆき",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["元白鵬","もとはくほう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["安亀忠","やすかめただ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["安福忠","やすふくただ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["安福久","やすふくひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["安百合幸","やすゆりさち",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["幸忠栄","ゆきたださかえ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合勝安","ゆりかつやす",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合茂","ゆりしげ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合白清２","ゆりしらきよ２",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合久","ゆりひさ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合未来","ゆりみらい",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["百合芳","ゆりよし",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["夜桜","よざくら",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["芳之国","よしのくに",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["好久勝","よしひさかつ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["好平茂","よしひらしげ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["諒太郎","りょうたろう",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["礼美茂","れみしげ",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["若華福","わかはなふく",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]
["若百合","わかゆり",{"$f":"COUNTIF(presetTable[種雄牛],presetTable[[#This Row],[種雄牛]])","v":1}]

{"sheet":"種雄牛","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["種雄牛"]
[]
[]
[]
["No","特定区分","品種","種雄牛","よみがな","期首在庫（精液）","期首在庫（受精卵）","よく使う"]

{"sheet":"期末","index":5,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["期末在庫"]
[]
[]
["No","特定区分","品種","種雄牛","よみがな","期末在庫（精液）","期末在庫（受精卵）"]

{"sheet":"他品種","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["種雄牛"]
[]
[]
[]
[]
["No","特定区分","品種","期首在庫（精液）","期首在庫（受精卵）"]
[1,"その他","ホルスタイン種"]
[2,"その他","ジャージー種"]
[3,"その他","ブラウンスイス種"]

{"sheet":"【県液】","index":7,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,9,4,11],[5,9,5,11],[2,2,2,14],[1,2,1,14],[0,2,0,14],[10,2,10,3],[10,9,10,10],[3,2,3,14],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,2,7,8],[4,12,4,14],[5,12,5,14],[8,2,8,14],[9,2,9,14],[6,10,6,14],[7,10,7,14]]}
[null,null,"様式第4号（第8条関係）"]
[null,null,"家畜人工授精実施状況報告書"]
[null,null,"2022年　　月　　日　"]
[null,null,"　宮城県知事　村井　嘉浩　殿"]
[null,null,null,null,null,null,null,null,null,"家畜人工授精師(獣医師)番号：",null,null,{"$f":"IF(報告書設定!D8<>\"\",報告書設定!D8,\"（非該当）\")","v":"（非該当）"}]
[null,null,null,null,null,null,null,null,null,"家畜人工授精所の管理番号：",null,null,{"$f":"IF(報告書設定!D9<>\"\",TEXT(報告書設定!D9,\"000000\"),\"（非該当）\")","v":"（非該当）"}]
[null,null,null,null,null,null,null,null,null,"住　 所：",{"$f":"報告書設定!D7","v":0}]
[null,null,null,null,null,null,null,null,null,"氏　 名：",{"$f":"報告書設定!D6","v":0}]
[]
[null,null,"　家畜改良増殖法施行条例第4条第1項の規定により，2021年1月1日から同年12月31日までの家畜人工授精実施状況を次の通り報告します。"]
[null,null,"種　畜",null,null,null,null,null,null,"利用数量"]
[null,null,"品　種","名　前","前年12月31日\n時点の保存数量","生産\n数量","譲受\n数量","譲渡\n数量","家畜人工授精\nした頭数","自己の飼養する\n雌の家畜に利用\nした数量","受精卵の作\n成等に利用\nした数量","廃棄等\nの数量","2021年12月31日\n時点の保存数量","種付け\n(自然交配)\nした頭数","備考"]
[null,null,null,null,"a","b","c","d","e","f","g","h","a+b+c-d-e-f-g-h"]
[null,"特定区分","品種","種雄牛","期首在庫","生産","譲受","譲渡（ストロー）","譲渡（注入）","利用（注入）","利用（その他）","廃棄・亡失","期末在庫","その他（自然交配）","亡失物発見"]
[]
[]
[null,null,"備　考"]
[null,null,"　１　この報告書は，家畜人工授精を実施又は家畜人工授精用精液を保管する者が作成すること。"]
[null,null,"　２　特定家畜人工授精用精液等は，品種ごとに小計欄を設け，小計を合算した合計数量を記載すること。"]
[null,null,"　３　特定家畜人工授精用精液等以外は，種畜の名前は記載不要とし，品種ごとの合計数量を記載すること。"]
[null,null,"　４　家畜人工授精した頭数は，延べ頭数とする。"]
[null,null,"　５　譲受数量には，保存の委託を受けた家畜人工授精用精液の搬入を含む。"]
[null,null,"　６　譲渡数量及び家畜人工授精した頭数には，保存の委託を受けた家畜人工授精用精液の搬出を含む。"]

{"sheet":"【県卵】","index":8,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,7,12,7],[11,8,11,10],[11,11,12,11],[11,12,12,12],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[8,2,8,15],[9,2,9,15],[10,2,10,3],[10,11,10,12],[5,10,5,12],[10,8,10,10],[5,2,5,9],[6,2,6,9],[7,2,7,9],[5,13,5,15],[6,11,6,15],[7,11,7,15],[0,2,0,15],[1,2,1,15],[2,2,2,15],[3,2,3,15],[4,10,4,12],[4,2,4,9],[4,13,4,15]]}
[null,null,"様式第5号（第8条関係）"]
[null,null,"家畜受精卵移植実施状況報告書"]
[null,null,"2022年　　月　　日　"]
[null,null,"　宮城県知事　村井　嘉浩　殿"]
[null,null,null,null,null,null,null,null,null,null,"家畜人工授精師(獣医師)番号：",null,null,{"$f":"IF(報告書設定!D8<>\"\",報告書設定!D8,\"（非該当）\")","v":"（非該当）"}]
[null,null,null,null,null,null,null,null,null,null,"家畜人工授精所の管理番号：",null,null,{"$f":"IF(報告書設定!D9<>\"\",TEXT(報告書設定!D9,\"000000\"),\"（非該当）\")","v":"（非該当）"}]
[null,null,null,null,null,null,null,null,null,null,"住　所：",{"$f":"報告書設定!D7","v":0}]
[null,null,null,null,null,null,null,null,null,null,"氏　名：",{"$f":"報告書設定!D6","v":0}]
[]
[null,null,"　家畜改良増殖法施行条例第4条第1項の規定により，2021年1月1日から同年12月31日までの家畜受精卵移植実施状況を次の通り報告します。"]
[null,null,"種　畜",null,null,null,null,null,"家畜受精卵移植した頭数",null,null,"利用数量"]
[null,null,"品　種","交配した\n種畜の名前","前年12月31日\n時点の保存数量","生産\n数量","譲受\n数量","譲渡\n数量","受卵牛の品種",null,null,"自己の飼養する\n雌の家畜に利用\nした数量","その他の用途\nに利用した\n数量","廃棄等\nの数量","2021年12月31日\n時点の保存数量","備考"]
[null,null,null,null,null,null,null,null,"黒毛\n和種","ホ ル ス\nタイン種","その他"]
[null,null,null,null,"a","b","c","d","e","f","g","h","i","j","a+b+c-d-e-f-g-h-i-j"]
[null,"特定区分","品種","種雄牛","期首在庫","生産","譲受","譲渡（ストロー）","譲渡（黒毛に移植）","譲渡（ホルに移植）","譲渡（その他に移植）","利用（移植）","利用（その他）","廃棄・亡失","期末在庫","亡失物発見"]
[]
[]
[null,null,"備　考"]
[null,null,"　１　この報告書は，家畜受精卵移植を実施又は家畜受精卵を保管する者が作成すること。"]
[null,null,"　２　特定家畜人工授精用精液等は，品種ごとに小計欄を設け，小計を合算した合計数量を記載すること。"]
[null,null,"　３　特定家畜人工授精用精液等以外は，種畜の名前は記載不要とし，品種ごとの合計数量を記載すること。"]
[null,null,"　４　家畜受精卵移植した頭数は，延べ頭数とする。"]
[null,null,"　５　譲受数量には，保存の委託を受けた家畜人工授精用精液の搬入を含む。"]
[null,null,"　６　譲渡数量及び家畜受精卵移植した頭数には，保存の委託を受けた家畜受精卵の搬出を含む。"]

{"sheet":"【国液】","index":9,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,17,11,17],[5,2,5,15],[0,2,0,15],[1,2,1,15],[3,2,3,15],[4,2,4,15],[6,2,6,15],[7,2,7,15],[8,2,8,15],[9,2,9,15],[10,2,10,15],[11,2,11,15],[2,2,2,15],[24,2,24,16],[25,2,25,16],[26,2,26,16],[27,2,27,16],[28,2,28,16],[29,2,29,16],[30,2,30,16],[31,2,31,16],[32,2,32,16],[33,2,33,16],[34,2,34,16],[35,2,35,16],[36,2,36,16],[37,2,37,16],[38,2,38,16]]}
[null,null,"家畜人工授精所における特定家畜人工授精用精液等の業務に関する報告書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様式第二十八号"]
[null,null,"2022年　　月　　日提出"]
[null,null,"　宮城県知事　村井　嘉浩　殿"]
[]
[null,null,"家畜改良増殖法施行規則第49条に基づき、2021年1月1日から12月31日までの家畜人工授精所の運営の状況を次のとおり報告します。"]
[]
[null,null,{"$f":"\"　１　家畜人工授精所の管理番号：\"&TEXT(報告書設定!D9,\"000000\")","v":"　１　家畜人工授精所の管理番号：000000"}]
[null,null,{"$f":"\"　２　家畜人工授精所の名称及び所在地：\"&報告書設定!D10&\"　\"&報告書設定!D11","v":"　２　家畜人工授精所の名称及び所在地：　"}]
[null,null,{"$f":"\"　３　家畜人工授精所の業務の別：\"&報告書設定!D17","v":"　３　家畜人工授精所の業務の別："}]
[null,null,"　４　報告対象物：１（家畜人工授精用精液）"]
[null,null,{"$f":"\"　５　前年12月31日時点の保存数量：\"&TEXT(SUM(sireTable[期首在庫（精液）]),\"#,###\")","v":"　５　前年12月31日時点の保存数量："}]
[null,null,"　６　家畜人工授精所の運営の状況"]
[null,null,"（単位：本）",2021]
[null,null,null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","合計"]
[null,null,null,"1","2","3","4","5","6","7","8","9","10","11","12","13"]
["\n","\n","生産数量"]
["\n","\n","譲受数量"]
["\n","\n","譲渡数量"]
["\n","\n","利用数量"]
["\n","\n","廃棄又は\n亡失した数量"]
["\n","\n","月末時点の\n保存数量"]
["\n","\n","備考"]
[]
[]
[null,null,"備考"]
[null,null,"　１　年は暦年で記載すること。"]
[null,null,"　２　３の業務は次の区分により番号を記入すること。"]
[null,null,"　　１　家畜人工授精用精液の採取及び処理の業務"]
[null,null,"　　２　家畜体内受精卵の採取および処理の業務"]
[null,null,"　　３　家畜体外受精卵の生産に関する業務（家畜の雌のとたいから採取した卵巣から未受精卵を採取し、及び処理し、体外受精を行い、並びにこれにより生じた受精卵を処理する場合に限る。）"]
[null,null,"　　４　家畜体外受精卵の生産に関する業務（家畜の雌から採取した卵巣から未受精卵を採取し、及び処理し、体外受精を行い、並びにこれにより生じた受精卵を処理する場合に限る。）"]
[null,null,"　　５　家畜人工授精用精液若しくは家畜受精卵又はこれらの保存"]
[null,null,"　３　４の報告対象物は次の区分により番号を記入すること。"]
[null,null,"　　１　家畜人工授精用精液"]
[null,null,"　　２　家畜受精卵"]
[null,null,"　４　生産数量及び利用数量には、容器に収められ、封を施した家畜人工授精用精液又は家畜受精卵の本数を記入すること。"]
[null,null,"　５　譲受数量には、保存の委託を受けた特定家畜人工授精用精液等の搬入を含む。"]
[null,null,"　６　譲渡数量には、保存の委託を受けた特定家畜人工授精用精液等の搬出を含む。"]
[null,null,"　７　備考の欄には、亡失した特定家畜人工授精用精液等を発見したときなど各項目に該当しないものについてその事由と数量を記載すること（例：亡失した精液の発見　＋２）。"]

{"sheet":"【国卵】","index":10,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,2,38,15],[27,2,27,15],[28,2,28,15],[29,2,29,15],[30,2,30,15],[31,2,31,15],[32,2,32,15],[33,2,33,15],[34,2,34,15],[35,2,35,15],[36,2,36,15],[37,2,37,15],[2,2,2,15],[26,2,26,15],[0,2,0,15],[0,17,11,17],[1,2,1,15],[3,2,3,15],[4,2,4,15],[5,2,5,15],[6,2,6,15],[7,2,7,15],[8,2,8,15],[9,2,9,15],[10,2,10,15],[11,2,11,15],[24,2,24,15],[25,2,25,15]]}
[null,null,"家畜人工授精所における特定家畜人工授精用精液等の業務に関する報告書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様式第二十八号"]
[null,null,"2022年　　月　　日提出"]
[null,null,"　宮城県知事　村井　嘉浩　殿"]
[]
[null,null,"家畜改良増殖法施行規則第49条に基づき、2021年1月1日から12月31日までの家畜人工授精所の運営の状況を次のとおり報告します。"]
[]
[null,null,{"$f":"\"　１　家畜人工授精所の管理番号：\"&TEXT(報告書設定!D9,\"000000\")","v":"　１　家畜人工授精所の管理番号：000000"}]
[null,null,{"$f":"\"　２　家畜人工授精所の名称及び所在地：\"&報告書設定!D10&\"　\"&報告書設定!D11","v":"　２　家畜人工授精所の名称及び所在地：　"}]
[null,null,{"$f":"\"　３　家畜人工授精所の業務の別：\"&報告書設定!D17","v":"　３　家畜人工授精所の業務の別："}]
[null,null,"　４　報告対象物：２（家畜受精卵）"]
[null,null,{"$f":"\"　５　前年12月31日時点の保存数量：\"&TEXT(SUM(sireTable[期首在庫（受精卵）]),\"#,###\")","v":"　５　前年12月31日時点の保存数量："}]
[null,null,"　６　家畜人工授精所の運営の状況"]
[null,null,"（単位：本）",2021]
[null,null,null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","合計"]
[null,null,null,"1","2","3","4","5","6","7","8","9","10","11","12","13"]
["\n","\n","生産数量"]
["\n","\n","譲受数量"]
["\n","\n","譲渡数量"]
["\n","\n","利用数量"]
["\n","\n","廃棄又は\n亡失した数量"]
["\n","\n","月末時点の\n保存数量"]
["\n","\n","備考"]
[]
[]
[null,null,"備考"]
[null,null,"　１　年は暦年で記載すること。"]
[null,null,"　２　３の業務は次の区分により番号を記入すること。"]
[null,null,"　　１　家畜人工授精用精液の採取及び処理の業務"]
[null,null,"　　２　家畜体内受精卵の採取および処理の業務"]
[null,null,"　　３　家畜体外受精卵の生産に関する業務（家畜の雌のとたいから採取した卵巣から未受精卵を採取し、及び処理し、体外受精を行い、並びにこれにより生じた受精卵を処理する場合に限る。）"]
[null,null,"　　４　家畜体外受精卵の生産に関する業務（家畜の雌から採取した卵巣から未受精卵を採取し、及び処理し、体外受精を行い、並びにこれにより生じた受精卵を処理する場合に限る。）"]
[null,null,"　　５　家畜人工授精用精液若しくは家畜受精卵又はこれらの保存"]
[null,null,"　３　４の報告対象物は次の区分により番号を記入すること。"]
[null,null,"　　１　家畜人工授精用精液"]
[null,null,"　　２　家畜受精卵"]
[null,null,"　４　生産数量及び利用数量には、容器に収められ、封を施した家畜人工授精用精液又は家畜受精卵の本数を記入すること。"]
[null,null,"　５　譲受数量には、保存の委託を受けた特定家畜人工授精用精液等の搬入を含む。"]
[null,null,"　６　譲渡数量には、保存の委託を受けた特定家畜人工授精用精液等の搬出を含む。"]
[null,null,"　７　備考の欄には、亡失した特定家畜人工授精用精液等を発見したときなど各項目に該当しないものについてその事由と数量を記載すること（例：亡失した精液の発見　＋２）。"]

{"sheet":"データサンプル","index":11,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["データ（サンプル）"]
[]
[]
[]
["No","日付","液卵区分","特定区分","品種","種雄牛","処理内容","本数"]
[1,"2021-01-15","精液","特定","黒毛和種","○○茂","譲受",5]
[2,"2021-01-15","精液","特定","黒毛和種","○○久","譲受",5]
[3,"2021-03-01","精液","特定","黒毛和種","○○平","譲渡（ストロー）",2]
[4,"2021-03-05","精液","特定","黒毛和種","○○茂","譲渡（注入）",1]
[5,"2021-02-01","精液","特定","黒毛和種","○○久","譲渡（注入）",1]
[6,"2021-02-15","精液","特定","黒毛和種","○○平","利用（注入）",1]

{"sheet":"種雄牛サンプル","index":12,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["種雄牛（サンプル）"]
[]
[]
[]
["No","特定区分","品種","種雄牛","よみがな","期首在庫（精液）","期首在庫（受精卵）","よく使う"]
[1,"特定","黒毛和種","○○茂","まるまるしげ",20,null,"ON"]
[2,"特定","黒毛和種","○○久","まるまるひさ",30,null,"ON"]
[3,"特定","黒毛和種","○○平","まるまるひら",15]