{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["使用方法","基本","許可","基本倉庫","工事","工事倉庫","技術者","技術倉庫","役員","役員倉庫","汎用","汎用 (2)","汎用倉庫","作業"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":110,"n_cols":24,"rows_kept":110,"cut":false,"hidden":false,"merged":[[34,8,35,8],[36,4,37,4],[36,3,37,3],[34,3,35,3],[34,4,35,4],[34,7,35,7],[73,5,73,8],[36,7,37,7],[36,8,37,8],[71,5,71,8],[72,5,72,8],[70,5,70,8]]}
[null,"指名願マスター　　　使用説明"]
[]
["目的","提出先市町村毎に異なるフォーマットの工事経歴書・技術者名簿・役員名簿等にコピペする手間を軽減。"]
[]
["概要","各建設業者毎に、工事経歴・技術者名簿・役員名簿等のデーターを既存のファイルから引込み、基礎データーを作成し"]
[null,"そのデーターを使用して、フォーマットの異なる複数の市町村指名願を作成する手間・時間を軽減する。"]
["基礎データーの作成"]
["工事の引込",null,null,null,null,null,null,null,"セル番地の指定方法"]
[1,"当ファイルの工事シートを開く",null,null,null,null,null,null,"①相手の番地を目で確認して　A3　等を記入する。"]
[2,"引込元のファイルを開く（工事経歴が記載されたシート「変更届等」を開く）",null,null,null,null,null,null,"他の方法"]
[3,"引込元の工事経歴が記載された１番目のデーター行数を確認（縦）",null,null,null,null,null,null,"①引込元のファイル・シートを開き当ファイルに戻り、「他ファイル名取得」ボタンをクリック"]
[4,"増分は、１つのデーターが何行に記載されているかの、行数",null,null,null,null,null,null,"②引込元のファイル・シートを開きセル番地をクリックする（アクティブにする）",null,null,null,null,null,null,null,"②-2　宮崎県をクリック"]
[null,"　例１は　１　、例２では　２　となる",null,null,null,null,null,null,"③当ファイルに戻り番地を書き込むセルをクリックする（アクティブにする）",null,null,null,null,null,null,null,"③-2　D24をクリック"]
[null,null,null,null,null,null,null,null,"④そのままダブルクリックする。（相手の番地が記入される）",null,null,null,null,null,null,null,"④-2　D24でダブルクリックすると相手の番地が記入される（この画面では動作しません）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　　　　セルを移動しながら上記を繰り返して指定する"]
[null,"相手シート",null,"Ａ","Ｂ","Ｃ","Ｄ","Ｅ","Ｆ","Ｇ","Ｈ","Ｉ","Ｊ","Ｋ","Ｌ"]
["例　１","元データー",1]
[null,null,2,"発注者","元・下","工事名","場所","技術者名","金額","工期年","月","日","工期年","月","日"]
[null,null,3,"宮崎県","元請","○○","宮崎県日向市","○△",1100000,3,1,12,3,2,28]
[null,null,4,"日向市","元請","××","宮崎県日向市","○△",2200000,3,8,20,3,11,20]
[null,null,5,"鹿児島県","元請","××","鹿児島県鹿児島市","○□",3300000,3,8,20,3,11,20]
[]
[null,"自分シート","増分","発注者","元・下","工事名","工事名２","場所　県","市町村","金額","工期年","月","日","工期年","月","日","技術者名"]
[null,null,1,"A3","B3","C3",null,"D3",null,"F3","G3","H3","I3","J3","K3","L3","E3"]
[]
[null,"引込結果",null,"発注者","元・下","工事名","場所　県","市町村","金額","工期　年","月","日","工期　年","月","日","技術者名"]
[null,null,22,"宮崎県","元請","○○","宮崎県","日向市",1100000,3,1,12,3,2,28,"○△"]
[null,null,23,"日向市","元請","××","宮崎県","日向市",2200000,3,8,20,3,11,20,"○△"]
[null,null,24,"鹿児島県","元請","××","鹿児島県","鹿児島市",3300000,3,8,20,3,11,20,"○□"]
[null,null,25,null,null,null,null,null,"県と県以降に分割される"]
[null,null,null,null,null,null,null,null,null,"市町村によって、県名のみ、市町村名のみと対応が違う為"]
["例　２","相手シート",null,"Ａ","Ｂ","Ｃ","Ｄ","Ｅ","Ｆ","Ｇ","Ｈ","Ｉ"]
[null,"元データー",1]
[null,null,2,"発注者","元・下","工事名","場所","技術者名","金額","工期"]
[null,null,3,"宮崎県","元請","○○××","宮崎県","○△",1100000,"2021-01-12","着工"]
[null,null,4,null,null,"△×○","日向市",null,null,"2021-02-28","完成",null,"　　１つのデーターが２行を利用　（増分　２とする）"]
[null,null,5,"日向市","元請","○○△△","宮崎県日向市","○△",2200000,"2021-06-15"]
[null,null,6,null,null,"××",null,null,null,"2021-08-31"]
[null,"自分シート",null,null,null,null,null,null,null,null,null,null,null,null,"月　日　は記入しない"]
[null,null,"増分","発注者","元・下","工事名","工事名２","場所　県","市町村","金額","工期年","月","日","工期年","月","日","技術者名"]
[null,null,2,"A3","B3","C3","C4","D3","D4","F3","G3",null,null,"G4",null,null,"E3"]
[null,null,null,null,null,null,"1行に結合"]
[null,"引込結果",null,"発注者","元・下","工事名","場所　県","市町村","金額","工期　年","月","日","工期　年","月","日","技術者名"]
[null,null,22,"宮崎県","元請","○○××△×○","宮崎県","日向市",1100000,3,1,12,3,2,28,"○△"]
[null,null,23,"日向市","元請","○○△△××","宮崎県","日向市",2200000,3,6,15,3,8,31,"○△"]
[null,null,24,null,null,null,null,null,null,"年　月　日　に分割して保存"]
[null,null,null,"場所　県が、宮崎県日向市等の場合、プログラムが宮崎県と日向市に自動的に分割する。"]
[]
["　　工事の種類が２業種以上の場合"]
[1,"工事の引込が終了した時点で、下部の「工事」タブにカーソルを合わせ右クリックし、「移動又はコピー」によりコピーを作成（「工事(2)]タブが作成される）"]
[2,"「画面のクリア」ボタンで工事名以下を全クリア"]
[3,"次の業種のシートを表示して、「②他のファイル名の取得」ボタンをクリック後「③他のファイルから引込」ボタンをクリック"]
[4,"同様にして複数の業種の工事データーが作成できる。"]
[]
["　　基本・技術者・役員の基礎データー作成"]
[null,"工事の引込と同様の手順で、基礎データーを作成する。又は手入力で作成する"]
[]
["建設業者毎に基礎データーファイルを作成。（基本・工事・技術者・役員データーを作成）"]
[]
["指名願の本紙への書出"]
["工事の書出",null,"　　増分","発注者","元・下","工事名","場所　県","市町村","金額","工期年","月","日","工期年","月","日","技術者名","ソートキー","印刷","請負金額","着年号","完年号","着工年月","完成年月","場所"]
[null,"自分シート",1,"A3","Ｂ３","Ｃ３","Ｇ３",null,null,null,null,null,null,null,null,null,null,null,"Ｈ３",null,null,"Ｉ３","Ｊ３"]
[null,null,22,"宮崎県","元請","○○××△×○","宮崎県","日向市",1100000,3,1,12,3,2,28,"○△",null,1,{"$f":"INT(I63/1.1/1000)","v":1000},"令和","令和",{"$f":"T63&RIGHT(\"  \"&J63,2)&\"年\"&RIGHT(\"  \"&K63,2)&\"月\"","v":"令和 3年 1月"},{"$f":"U63&RIGHT(\"  \"&M63,2)&\"年\"&RIGHT(\"  \"&N63,2)&\"月\"","v":"令和 3年 2月"},{"$f":"G63&H63","v":"宮崎県日向市"}]
[null,null,23,"日向市","元請","○○△△××","宮崎県","日向市",2200000,3,6,15,3,8,31,"○△",null,1,{"$f":"INT(I64/1.1/1000)","v":2000},"令和","令和",{"$f":"T64&RIGHT(\"  \"&J64,2)&\"年\"&RIGHT(\"  \"&K64,2)&\"月\"","v":"令和 3年 6月"},{"$f":"U64&RIGHT(\"  \"&M64,2)&\"年\"&RIGHT(\"  \"&N64,2)&\"月\"","v":"令和 3年 8月"}]
[null,null,24]
[null,null,25]
[]
[]
[null,"相手シート",null,"Ａ","Ｂ","Ｃ","Ｄ","Ｅ","Ｆ","Ｇ","Ｈ","Ｉ","Ｊ","Ｋ"]
[null,null,1]
[null,null,2,"発注者","元・下","　　　　　　　　　　工　　事　　名",null,null,null,"都道府県名","請負金額","着工","完成"]
[null,null,3,"宮崎県","元請","○○××△×○",null,null,null,"宮崎県",1000,"令和 3年 1月","令和 3年 2月"]
[null,null,4,"日向市","元請","○○△△××",null,null,null,"宮崎県",2000,"令和 3年 6月","令和 3年 8月"]
[null,null,5]
[]
["書出のヒント"]
[1,"市町村によって、書き出す工事名を選択出来ます・・・印刷に「１」を記入した工事のみを印刷する"]
[]
[2,"工事シートをコピーして、工事、工事（２）、工事（３）と増やせるので、土木一式・建築一式・とび・土工・コンクリート等の工事経歴が作成できる。"]
[null,"　　　この場合、書出シートの番地を指定③した後、下方の工事タブを右クリックしてコピーを作成する（書出先のシートも同様に作成する）"]
[null,"　　　注　　書出・呼込ボタンをクリックする前に「相手ファイル名取得」ボタンをクリックして書き出すシートを確定する事"]
[]
[3,"印刷面の工事名がセルからはみ出す場合は、文字のポイントの数値を小さくしたり、途中で折り返して調整する。"]
[null,"　　　折り返す方法、折り返す文字の前にカーソルを合わせクリック後、キーボードのＡＬＴ＋Ｅｎｔｅｒを押す。"]
[]
[4,"日付が　令和　３年１２月　５日等の場合　印刷面のフォントはﾌﾟﾛﾎﾟｰｼｮﾅﾙにしない（MSPゴシックはMSゴシックに変更・MSP明朝はMS明朝に変更）"]
[null,null,null,"MSPゴシック","2021-12-31",{"$f":"TEXT(E87,\"ggg\")&RIGHT(\" \"&TEXT(E87,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(E87),2)&\"月\"&RIGHT(\" \"&DAY(E87),2)&\"日\"","v":"令和 3年12月31日"}]
[null,null,null,"MSPゴシック","2022-01-01",{"$f":"TEXT(E88,\"ggg\")&RIGHT(\" \"&TEXT(E88,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(E88),2)&\"月\"&RIGHT(\" \"&DAY(E88),2)&\"日\"","v":"令和 4年 1月 1日"},null,"Pの場合印刷が不揃いになる"]
[null,null,null,"MPゴシック","2021-12-31",{"$f":"TEXT(E89,\"ggg\")&RIGHT(\" \"&TEXT(E89,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(E89),2)&\"月\"&RIGHT(\" \"&DAY(E89),2)&\"日\"","v":"令和 3年12月31日"}]
[null,null,null,"MPゴシック","2022-01-01",{"$f":"TEXT(E90,\"ggg\")&RIGHT(\" \"&TEXT(E90,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(E90),2)&\"月\"&RIGHT(\" \"&DAY(E90),2)&\"日\"","v":"令和 4年 1月 1日"}]
[]
[5,"市町村によっては、請負金額が税込み（千円）の場合があるので基礎データーは税込み（円）に統一する方がミスが少なくなる。"]
[6,"２業種以上の為「工事(2)]・・・のタブを作成した場合は、指名願本紙も同様に「工事経歴(2)・・・を作成しそれぞれに書き出す。"]
[]
[]
["基本・技術者・役員の書出"]
[null,"工事の書出と同様の手順で、指名願に書き出す。"]
[]
["市町村毎の対応"]
[1,"建設業者毎に基礎データーファイルを作成。基本・工事・技術者・役員データーを作成"]
[2,"市町村毎の、呼出・書込番地のデーターは市町村名にて倉庫に保存する。"]
[null,"　　日向市、日向市業務、日向市物品、門川町、美郷町、諸塚村　　等々の名前で倉庫に保存"]
[3,"各市町村は、書出セルを指定したデーターを保存すれば、保存データーの呼出で再利用が可能"]
[4,"保存倉庫のデーターは、コピペ又は、ファイルの使い回しにて各倉庫の市町村データーを蓄積し、他の業者でも利用する。"]
[null,"　　＊番地指定は、市町村毎に、年１回の作業で完結する。"]
[null,"　　＊市町村毎の印刷は、保存データーの「呼出」で対応する"]
["次年度からは"]
[null,"基本・技術者・役員の変更点を修正する（又は、最新のデーターを呼び込む）"]
[null,"工事は、新年度分を呼び込む。変更届の工事経歴から、当年度、１年前の２年分を呼込む（工事は追加で呼び込まれる）。未成工事分は追加入力する"]
[null,"指名願のフォーマットが変更された場合は、再度番地の指定をやり直す。"]

{"sheet":"基本","index":1,"n_rows":103,"n_cols":25,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["基本",null,null,null,"引込",null,null,"書込保存名",null,"②",null,"指名願マスター　　Ｖ２０２２．０",null,null,null,"2022-01-06",null,null,"ブック名","ペイント三州R3-日向市指名願.xlsx",null,null,null,{"$f":"作業!AP1*1","v":3331},"R3－指名願マスター（工事・技術・役員等）.xlsm"]
[null,null,null,null,"②",null,null,"日向市","←市町村名",null,null,null,null,null,null,null,null,null,null,"①資格審査申請書",null,null,null,null,"ペイント三州R3-日向市指名願.xlsx"]
[null,"保存呼出名","門川町","シート名","番地","縦","横","シート名","番地","縦","横"]
[null,"会社名","有限会社　宮崎電工社","資格審査申請書","AS11",{"$f":"IF(E4=\"\",\"\",MID(E4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E4)&1234567890)),3))","v":"11"},{"$f":"IF(E4=\"\",\"\",COLUMN(INDIRECT(E4&\"1\")))","v":45},"①資格審査申請書","BC10",{"$f":"IF(I4=\"\",\"\",MID(I4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I4)&1234567890)),3))","v":"10"},{"$f":"IF(I4=\"\",\"\",COLUMN(INDIRECT(I4&\"1\")))","v":55},null,null,null,null,null,null,null,"シート名"]
[null,"会社名　略","(有)宮崎電工社",null,null,null,null,null,null,{"$f":"IF(I5=\"\",\"\",MID(I5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I5)&1234567890)),3))","v":""},{"$f":"IF(I5=\"\",\"\",COLUMN(INDIRECT(I5&\"1\")))","v":""}]
[null,"ふりがな","　　　みやざきでんこうしゃ",null,null,{"$f":"IF(E6=\"\",\"\",MID(E6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E6)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I6=\"\",\"\",MID(I6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I6)&1234567890)),3))","v":""},""]
[null,"フリガナ","　　　ミヤザキデンコウシャ","資格審査申請書","AS8",{"$f":"IF(E7=\"\",\"\",MID(E7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E7)&1234567890)),3))","v":"8"},45,"①資格審査申請書","BC9",{"$f":"IF(I7=\"\",\"\",MID(I7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I7)&1234567890)),3))","v":"9"},55]
[null,"〒","883-0026","資格審査申請書","AX16",{"$f":"IF(E8=\"\",\"\",MID(E8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E8)&1234567890)),3))","v":"16"},50,null,null,{"$f":"IF(I8=\"\",\"\",MID(I8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I8)&1234567890)),3))","v":""},{"$f":"IF(I8=\"\",\"\",COLUMN(INDIRECT(I8&\"1\")))","v":""},null,"書込データーR4年処理済み"]
[null,"住所","日向市大字日知屋１２３４５","資格審査申請書","AS19",{"$f":"IF(E9=\"\",\"\",MID(E9,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E9)&1234567890)),3))","v":"19"},45,"①資格審査申請書","BC14",{"$f":"IF(I9=\"\",\"\",MID(I9,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I9)&1234567890)),3))","v":"14"},55,null,"川南町"]
[null,"ふりがな","ひゅうがし　おおあざひちや",null,null,{"$f":"IF(E10=\"\",\"\",MID(E10,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E10)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I10=\"\",\"\",MID(I10,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I10)&1234567890)),3))","v":""},"",null,"高千穂町","申請書のふりがな領域　要再調整"]
[null,"フリガナ",null,null,null,{"$f":"IF(E11=\"\",\"\",MID(E11,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E11)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I11=\"\",\"\",MID(I11,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I11)&1234567890)),3))","v":""},"",null,"日向市R3追加分（年号要調整）"]
[null,"役職","代表取締役","資格審査申請書","AS22",{"$f":"IF(E12=\"\",\"\",MID(E12,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E12)&1234567890)),3))","v":"22"},45,"①資格審査申請書","BC16",{"$f":"IF(I12=\"\",\"\",MID(I12,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I12)&1234567890)),3))","v":"16"},55]
[null,"代表者名","宮崎　太郎","資格審査申請書","AS25",{"$f":"IF(E13=\"\",\"\",MID(E13,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E13)&1234567890)),3))","v":"25"},45,"①資格審査申請書","BT16",{"$f":"IF(I13=\"\",\"\",MID(I13,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I13)&1234567890)),3))","v":"16"},72]
[null,"ふりがな","みやざき　たろう",null,null,{"$f":"IF(E14=\"\",\"\",MID(E14,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E14)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I14=\"\",\"\",MID(I14,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I14)&1234567890)),3))","v":""},""]
[null,"フリガナ","ミヤザキ　タロウ",null,null,{"$f":"IF(E15=\"\",\"\",MID(E15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E15)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I15=\"\",\"\",MID(I15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I15)&1234567890)),3))","v":""},""]
[null,"電話","0982-52-1234","資格審査申請書","BS22",{"$f":"IF(E16=\"\",\"\",MID(E16,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E16)&1234567890)),3))","v":"22"},71,"①資格審査申請書","BJ12",{"$f":"IF(I16=\"\",\"\",MID(I16,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I16)&1234567890)),3))","v":"12"},62]
[null,"FAX","0982-53-2345","資格審査申請書","BS25",{"$f":"IF(E17=\"\",\"\",MID(E17,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E17)&1234567890)),3))","v":"25"},71,"①資格審査申請書","CA12",{"$f":"IF(I17=\"\",\"\",MID(I17,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I17)&1234567890)),3))","v":"12"},79]
[null,"e-maile"," 　　miyaaden@crux.ocn.ne.jp","資格審査申請書","BG16",{"$f":"IF(E18=\"\",\"\",MID(E18,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E18)&1234567890)),3))","v":"16"},{"$f":"IF(E18=\"\",\"\",COLUMN(INDIRECT(E18&\"1\")))","v":59},"①資格審査申請書","BC20",{"$f":"IF(I18=\"\",\"\",MID(I18,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I18)&1234567890)),3))","v":"20"},55,null,null,"操作説明"]
[null,"担当部署名","本店",null,null,{"$f":"IF(E19=\"\",\"\",MID(E19,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E19)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I19=\"\",\"\",MID(I19,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I19)&1234567890)),3))","v":""},"",null,null,"基本情報の入力"]
[null,"担当者名","宮崎　二郎",null,null,{"$f":"IF(E20=\"\",\"\",MID(E20,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E20)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I20=\"\",\"\",MID(I20,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I20)&1234567890)),3))","v":""},"",null,null,"１．会社の基本情報を手入力又は、既存ファイルから引き込む"]
[null,"担当ふりがな","みやざき　じろう",null,null,{"$f":"IF(E21=\"\",\"\",MID(E21,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E21)&1234567890)),3))","v":""},{"$f":"IF(E21=\"\",\"\",COLUMN(INDIRECT(E21&\"1\")))","v":""},null,null,{"$f":"IF(I21=\"\",\"\",MID(I21,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I21)&1234567890)),3))","v":""},"",null,null,"    既存ファイルからの引込方法（セルの番地指定）"]
[null,"担当フリガナ","ミヤザキ　ジロウ",null,null,{"$f":"IF(E22=\"\",\"\",MID(E22,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E22)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I22=\"\",\"\",MID(I22,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I22)&1234567890)),3))","v":""},"",null,null,null,"①引込相手ファイル・シートを開く"]
[null,"担当　電話","0982-52-1234",null,null,{"$f":"IF(E23=\"\",\"\",MID(E23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E23)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I23=\"\",\"\",MID(I23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I23)&1234567890)),3))","v":""},"",null,null,null,"②会社名の記載してあるセルをクリック（アクティブにする）"]
[null,"担当　FAX","0982-53-2345",null,null,{"$f":"IF(E24=\"\",\"\",MID(E24,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E24)&1234567890)),3))","v":""},{"$f":"IF(E24=\"\",\"\",COLUMN(INDIRECT(E24&\"1\")))","v":""},null,null,{"$f":"IF(I24=\"\",\"\",MID(I24,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I24)&1234567890)),3))","v":""},"",null,null,null,"③このファイルに戻る"]
[null,"許可番号",2345,"資格審査申請書","AU58",{"$f":"IF(E25=\"\",\"\",MID(E25,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E25)&1234567890)),3))","v":"58"},47,"①資格審査申請書","H19",{"$f":"IF(I25=\"\",\"\",MID(I25,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I25)&1234567890)),3))","v":"19"},{"$f":"IF(I25=\"\",\"\",COLUMN(INDIRECT(I25&\"1\")))","v":8},null,null,null,"④”E4”をクリック、再度ダブルクリックすると相手の番地・シート名が記入される"]
[null,"許可年月日","2017-10-08","資格審査申請書","W67",{"$f":"IF(E26=\"\",\"\",MID(E26,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E26)&1234567890)),3))","v":"67"},{"$f":"IF(E26=\"\",\"\",COLUMN(INDIRECT(E26&\"1\")))","v":23},null,null,{"$f":"IF(I26=\"\",\"\",MID(I26,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I26)&1234567890)),3))","v":""},"",null,null,null,"⑤相手ファイルに戻る"]
[null,"許可　特定","土、建、解、管","営業所一覧表","N14",{"$f":"IF(E27=\"\",\"\",MID(E27,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E27)&1234567890)),3))","v":"14"},14,"⑥営業所一覧表","M13",{"$f":"IF(I27=\"\",\"\",MID(I27,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I27)&1234567890)),3))","v":"13"},{"$f":"IF(I27=\"\",\"\",COLUMN(INDIRECT(I27&\"1\")))","v":13},null,null,null,"⑥フリガナの記載してあるセルをクリック（アクティブにする）"]
[null,"　　　　一般","電・消","営業所一覧表","X14",{"$f":"IF(E28=\"\",\"\",MID(E28,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E28)&1234567890)),3))","v":"14"},24,"⑥営業所一覧表","W13",{"$f":"IF(I28=\"\",\"\",MID(I28,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I28)&1234567890)),3))","v":"13"},{"$f":"IF(I28=\"\",\"\",COLUMN(INDIRECT(I28&\"1\")))","v":23},null,null,null,"⑦このファイルに戻る"]
[null,"経営審査","電、消、土、解、管",null,null,{"$f":"IF(E29=\"\",\"\",MID(E29,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E29)&1234567890)),3))","v":""},{"$f":"IF(E29=\"\",\"\",COLUMN(INDIRECT(E29&\"1\")))","v":""},null,null,{"$f":"IF(I29=\"\",\"\",MID(I29,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I29)&1234567890)),3))","v":""},"",null,null,null,"⑧”E７”をクリック、再度ダブルクリックすると相手の番地・シート名が記入される"]
[null,"指名申請","電、消、土、解、管",null,null,{"$f":"IF(E30=\"\",\"\",MID(E30,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E30)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I30=\"\",\"\",MID(I30,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I30)&1234567890)),3))","v":""},"",null,null,null,"⑨　⑤～⑧の操作を繰り返し必要な項目を指定する"]
["フリー","〒　３",{"$f":"LEFT(C8,3)","v":"883"},null,null,{"$f":"IF(E31=\"\",\"\",MID(E31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E31)&1234567890)),3))","v":""},"","①資格審査申請書","AX12",{"$f":"IF(I31=\"\",\"\",MID(I31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I31)&1234567890)),3))","v":"12"},50,null,null,"２．「③他のファイルから引込」ボタンをクリックすると相手ファイルから会社名等が引き込まれる。"]
["フリー","〒　４",{"$f":"RIGHT(C8,4)","v":"0026"},null,null,{"$f":"IF(E32=\"\",\"\",MID(E32,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E32)&1234567890)),3))","v":""},"","①資格審査申請書","BC12",{"$f":"IF(I32=\"\",\"\",MID(I32,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I32)&1234567890)),3))","v":"12"},55,null,null,"３．必要に応じてデーターを補完・追加・編集加工する。（１回のみの操作で毎年は変更点を修正で対応する）"]
["フリー","電話市外",{"$f":"LEFT(C16,4)","v":"0982"},null,null,{"$f":"IF(E33=\"\",\"\",MID(E33,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E33)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I33=\"\",\"\",MID(I33,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I33)&1234567890)),3))","v":""},"",null,null,"４．引込データーを保存する。（他の会社のデーター作成に利用）"]
["フリー","電話局番",{"$f":"MID(C16,6,2)","v":"52"},null,null,{"$f":"IF(E34=\"\",\"\",MID(E34,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E34)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I34=\"\",\"\",MID(I34,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I34)&1234567890)),3))","v":""},"",null,null,"５．会社毎にこの操作を繰り返し、会社毎に名前を付けてにファイルを保存する。"]
["フリー","電話番号",{"$f":"RIGHT(C16,4)","v":"1234"},null,null,{"$f":"IF(E35=\"\",\"\",MID(E35,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E35)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I35=\"\",\"\",MID(I35,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I35)&1234567890)),3))","v":""},""]
["フリー","FAX　市外",{"$f":"LEFT(C17,4)","v":"0982"},null,null,{"$f":"IF(E36=\"\",\"\",MID(E36,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E36)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I36=\"\",\"\",MID(I36,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I36)&1234567890)),3))","v":""},"",null,null,"基本情報の書出"]
["フリー","FAX　局番",{"$f":"MID(C17,6,2)","v":"53"},null,null,{"$f":"IF(E37=\"\",\"\",MID(E37,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E37)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I37=\"\",\"\",MID(I37,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I37)&1234567890)),3))","v":""},"",null,null,"１．市町村指定の指名願ファイルに書出す。"]
["フリー","FAX　番号",{"$f":"RIGHT(C17,4)","v":"2345"},null,null,{"$f":"IF(E38=\"\",\"\",MID(E38,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E38)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I38=\"\",\"\",MID(I38,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I38)&1234567890)),3))","v":""},"",null,null,"　　相手ファイルノ書出位置（セル番地指定）"]
["フリー","職氏名",{"$f":"C12&\"　\"&C13","v":"代表取締役　宮崎　太郎"},null,null,{"$f":"IF(E39=\"\",\"\",MID(E39,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E39)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I39=\"\",\"\",MID(I39,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I39)&1234567890)),3))","v":""},"",null,null,null,"①相手ファイル・シートを開く"]
["フリー",{"$f":"B8","v":"〒"},{"$f":"\"〒\"&C8","v":"〒883-0026"},null,null,{"$f":"IF(E40=\"\",\"\",MID(E40,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E40)&1234567890)),3))","v":""},"","⑥営業所一覧表","AG13",{"$f":"IF(I40=\"\",\"\",MID(I40,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I40)&1234567890)),3))","v":"13"},{"$f":"IF(I40=\"\",\"\",COLUMN(INDIRECT(I40&\"1\")))","v":33},null,null,null,"②会社名を記載するセルをクリック（アクティブにする）"]
["フリー",{"$f":"B9","v":"住所"},{"$f":"C9","v":"日向市大字日知屋１２３４５"},null,null,{"$f":"IF(E41=\"\",\"\",MID(E41,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E41)&1234567890)),3))","v":""},"","⑥営業所一覧表","AG15",{"$f":"IF(I41=\"\",\"\",MID(I41,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I41)&1234567890)),3))","v":"15"},{"$f":"IF(I41=\"\",\"\",COLUMN(INDIRECT(I41&\"1\")))","v":33},null,null,null,"③このファイルに戻る"]
["フリー","電話",{"$f":"\"電話　\"&C23","v":"電話　0982-52-1234"},null,null,{"$f":"IF(E42=\"\",\"\",MID(E42,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E42)&1234567890)),3))","v":""},"","⑥営業所一覧表","AG17",{"$f":"IF(I42=\"\",\"\",MID(I42,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I42)&1234567890)),3))","v":"17"},{"$f":"IF(I42=\"\",\"\",COLUMN(INDIRECT(I42&\"1\")))","v":33},null,null,null,"　「①書出ファイル名取得」ボタンをクリック"]
["フリー","FAX",{"$f":"\"FAX　 \"&C24","v":"FAX　 0982-53-2345"},null,null,{"$f":"IF(E43=\"\",\"\",MID(E43,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E43)&1234567890)),3))","v":""},"","⑥営業所一覧表","AG19",{"$f":"IF(I43=\"\",\"\",MID(I43,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I43)&1234567890)),3))","v":"19"},{"$f":"IF(I43=\"\",\"\",COLUMN(INDIRECT(I43&\"1\")))","v":33},null,null,null,"④”Ｉ4”をクリック、再度ダブルクリックすると相手の番地・シート名が記入される"]
["フリー",null,"本　店",null,null,{"$f":"IF(E44=\"\",\"\",MID(E44,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E44)&1234567890)),3))","v":""},"","⑥営業所一覧表","A13",{"$f":"IF(I44=\"\",\"\",MID(I44,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I44)&1234567890)),3))","v":"13"},1,null,null,null,"以下　入力方法⑤以下と同じ要領で指名願ファイルの書込先のセル番地を指定する。"]
["フリー","代表者住所",null,null,null,{"$f":"IF(E45=\"\",\"\",MID(E45,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E45)&1234567890)),3))","v":""},"","①資格審査申請書","BC18",{"$f":"IF(I45=\"\",\"\",MID(I45,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I45)&1234567890)),3))","v":"18"},55,null,null,"２．「③他のファイルへ転記」ボタンをクリックすると、転記される。"]
["フリー","許可　年号",{"$f":"TEXT(C26,\"g\")","v":"H"},null,null,{"$f":"IF(E46=\"\",\"\",MID(E46,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E46)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I46=\"\",\"\",MID(I46,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I46)&1234567890)),3))","v":""},"",null,null,"３．「書込保存名」に市町村名を記入"]
["フリー","許可　年",{"$f":"TEXT(C26,\"e\")","v":"29"},null,null,{"$f":"IF(E47=\"\",\"\",MID(E47,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E47)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I47=\"\",\"\",MID(I47,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I47)&1234567890)),3))","v":""},"",null,null,"４．「書出データーを保存」ボタンをクリックして倉庫に保存する。"]
["フリー","許可　月",{"$f":"MONTH(C26)","v":10},null,null,{"$f":"IF(E48=\"\",\"\",MID(E48,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E48)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I48=\"\",\"\",MID(I48,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I48)&1234567890)),3))","v":""},"",null,null,"５．データーが保存された市町村は、「書込データーの呼出」ボタンでデーターを呼び出し利用する。"]
["フリー","許可　日",{"$f":"DAY(C26)","v":8},null,null,{"$f":"IF(E49=\"\",\"\",MID(E49,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E49)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I49=\"\",\"\",MID(I49,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I49)&1234567890)),3))","v":""},""]
["フリー","有効期限",{"$f":"EDATE(C26,12*5)-1","v":"2022-10-07"},null,null,{"$f":"IF(E50=\"\",\"\",MID(E50,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E50)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I50=\"\",\"\",MID(I50,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I50)&1234567890)),3))","v":""},"",null,null,"工事・技術者・役員についても、同様な操作を繰り返す"]
["フリー","有効　年号",{"$f":"TEXT(C50,\"g\")","v":"R"},null,null,{"$f":"IF(E51=\"\",\"\",MID(E51,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E51)&1234567890)),3))","v":""},"","①資格審査申請書","X25",{"$f":"IF(I51=\"\",\"\",MID(I51,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I51)&1234567890)),3))","v":"25"},24,null,null,"市町村データーは、他の会社でも利用可能なので。上記の操作は市町村毎に１回行えば、後はコピペ・使い回しで対応する。"]
["フリー","有効　年",{"$f":"TEXT(C50,\"e\")","v":"4"},null,null,{"$f":"IF(E52=\"\",\"\",MID(E52,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E52)&1234567890)),3))","v":""},"","①資格審査申請書","Z25",{"$f":"IF(I52=\"\",\"\",MID(I52,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I52)&1234567890)),3))","v":"25"},26,null,null,"＊注"]
["フリー","有効　月",{"$f":"MONTH(C50)","v":10},null,null,{"$f":"IF(E53=\"\",\"\",MID(E53,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E53)&1234567890)),3))","v":""},"","①資格審査申請書","AD25",{"$f":"IF(I53=\"\",\"\",MID(I53,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I53)&1234567890)),3))","v":"25"},30,null,null,"　","←空白が記入してあります、この状態はエラーとなります。「Delete」で「空白」を削除して下さい。"]
["フリー","有効　日",{"$f":"DAY(C50)","v":7},null,null,{"$f":"IF(E54=\"\",\"\",MID(E54,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E54)&1234567890)),3))","v":""},"","①資格審査申請書","AH25",{"$f":"IF(I54=\"\",\"\",MID(I54,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I54)&1234567890)),3))","v":"25"},34,null,null,null,"←正常な表示です"]
["フリー",null,null,null,null,{"$f":"IF(E55=\"\",\"\",MID(E55,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E55)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I55=\"\",\"\",MID(I55,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I55)&1234567890)),3))","v":""},"",null,null,"A3","←正常な表示です"]
["フリー",null,null,null,null,{"$f":"IF(E56=\"\",\"\",MID(E56,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E56)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I56=\"\",\"\",MID(I56,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I56)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E57=\"\",\"\",MID(E57,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E57)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I57=\"\",\"\",MID(I57,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I57)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E58=\"\",\"\",MID(E58,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E58)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I58=\"\",\"\",MID(I58,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I58)&1234567890)),3))","v":""},""]
["フリー","椎葉村長","黒木　保隆",null,null,{"$f":"IF(E59=\"\",\"\",MID(E59,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E59)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I59=\"\",\"\",MID(I59,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I59)&1234567890)),3))","v":""},""]
["フリー","延岡市長",null,null,null,{"$f":"IF(E60=\"\",\"\",MID(E60,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E60)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I60=\"\",\"\",MID(I60,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I60)&1234567890)),3))","v":""},""]
["フリー","高千穂町長","甲斐　宗之",null,null,{"$f":"IF(E61=\"\",\"\",MID(E61,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E61)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I61=\"\",\"\",MID(I61,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I61)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$5","v":"(有)宮崎電工社"},null,null,{"$f":"IF(E62=\"\",\"\",MID(E62,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E62)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I62=\"\",\"\",MID(I62,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I62)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$5","v":"(有)宮崎電工社"},null,null,{"$f":"IF(E63=\"\",\"\",MID(E63,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E63)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I63=\"\",\"\",MID(I63,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I63)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$5","v":"(有)宮崎電工社"},null,null,{"$f":"IF(E64=\"\",\"\",MID(E64,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E64)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I64=\"\",\"\",MID(I64,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I64)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$5","v":"(有)宮崎電工社"},null,null,{"$f":"IF(E65=\"\",\"\",MID(E65,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E65)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I65=\"\",\"\",MID(I65,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I65)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$5","v":"(有)宮崎電工社"},null,null,{"$f":"IF(E66=\"\",\"\",MID(E66,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E66)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I66=\"\",\"\",MID(I66,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I66)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$13","v":"宮崎　太郎"},null,null,{"$f":"IF(E67=\"\",\"\",MID(E67,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E67)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I67=\"\",\"\",MID(I67,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I67)&1234567890)),3))","v":""},""]
["フリー",null,{"$f":"$C$13","v":"宮崎　太郎"},null,null,{"$f":"IF(E68=\"\",\"\",MID(E68,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E68)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I68=\"\",\"\",MID(I68,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I68)&1234567890)),3))","v":""},""]
["フリー",null,"宮崎　太郎",null,null,{"$f":"IF(E69=\"\",\"\",MID(E69,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E69)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I69=\"\",\"\",MID(I69,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I69)&1234567890)),3))","v":""},{"$f":"IF(I69=\"\",\"\",COLUMN(INDIRECT(I69&\"1\")))","v":""}]
["フリー",null,null,null,null,{"$f":"IF(E70=\"\",\"\",MID(E70,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E70)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I70=\"\",\"\",MID(I70,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I70)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E71=\"\",\"\",MID(E71,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E71)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I71=\"\",\"\",MID(I71,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I71)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E72=\"\",\"\",MID(E72,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E72)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I72=\"\",\"\",MID(I72,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I72)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E73=\"\",\"\",MID(E73,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E73)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I73=\"\",\"\",MID(I73,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I73)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E74=\"\",\"\",MID(E74,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E74)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I74=\"\",\"\",MID(I74,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I74)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E75=\"\",\"\",MID(E75,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E75)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I75=\"\",\"\",MID(I75,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I75)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E76=\"\",\"\",MID(E76,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E76)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I76=\"\",\"\",MID(I76,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I76)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E77=\"\",\"\",MID(E77,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E77)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I77=\"\",\"\",MID(I77,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I77)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E78=\"\",\"\",MID(E78,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E78)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I78=\"\",\"\",MID(I78,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I78)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E79=\"\",\"\",MID(E79,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E79)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I79=\"\",\"\",MID(I79,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I79)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E80=\"\",\"\",MID(E80,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E80)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I80=\"\",\"\",MID(I80,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I80)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E81=\"\",\"\",MID(E81,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E81)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I81=\"\",\"\",MID(I81,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I81)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E82=\"\",\"\",MID(E82,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E82)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I82=\"\",\"\",MID(I82,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I82)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E83=\"\",\"\",MID(E83,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E83)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I83=\"\",\"\",MID(I83,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I83)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E84=\"\",\"\",MID(E84,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E84)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I84=\"\",\"\",MID(I84,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I84)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E85=\"\",\"\",MID(E85,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E85)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I85=\"\",\"\",MID(I85,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I85)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E86=\"\",\"\",MID(E86,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E86)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I86=\"\",\"\",MID(I86,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I86)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E87=\"\",\"\",MID(E87,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E87)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I87=\"\",\"\",MID(I87,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I87)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E88=\"\",\"\",MID(E88,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E88)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I88=\"\",\"\",MID(I88,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I88)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E89=\"\",\"\",MID(E89,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E89)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I89=\"\",\"\",MID(I89,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I89)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E90=\"\",\"\",MID(E90,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E90)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I90=\"\",\"\",MID(I90,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I90)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E91=\"\",\"\",MID(E91,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E91)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I91=\"\",\"\",MID(I91,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I91)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E92=\"\",\"\",MID(E92,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E92)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I92=\"\",\"\",MID(I92,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I92)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E93=\"\",\"\",MID(E93,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E93)&1234567890)),3))","v":""},{"$f":"IF(E93=\"\",\"\",COLUMN(INDIRECT(E93&\"1\")))","v":""},null,null,{"$f":"IF(I93=\"\",\"\",MID(I93,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I93)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E94=\"\",\"\",MID(E94,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E94)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I94=\"\",\"\",MID(I94,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I94)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E95=\"\",\"\",MID(E95,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E95)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I95=\"\",\"\",MID(I95,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I95)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E96=\"\",\"\",MID(E96,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E96)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I96=\"\",\"\",MID(I96,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I96)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E97=\"\",\"\",MID(E97,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E97)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I97=\"\",\"\",MID(I97,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I97)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E98=\"\",\"\",MID(E98,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E98)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I98=\"\",\"\",MID(I98,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I98)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E99=\"\",\"\",MID(E99,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E99)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I99=\"\",\"\",MID(I99,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I99)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E100=\"\",\"\",MID(E100,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E100)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I100=\"\",\"\",MID(I100,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I100)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E101=\"\",\"\",MID(E101,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E101)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I101=\"\",\"\",MID(I101,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I101)&1234567890)),3))","v":""},""]
["フリー",null,null,null,null,{"$f":"IF(E102=\"\",\"\",MID(E102,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E102)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I102=\"\",\"\",MID(I102,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I102)&1234567890)),3))","v":""},""]
["フリー","owari ",null,null,null,{"$f":"IF(E103=\"\",\"\",MID(E103,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E103)&1234567890)),3))","v":""},"",null,null,{"$f":"IF(I103=\"\",\"\",MID(I103,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I103)&1234567890)),3))","v":""},""]

{"sheet":"許可","index":2,"n_rows":51,"n_cols":63,"rows_kept":51,"cut":false,"hidden":false,"merged":[[41,55,42,55],[41,57,42,57],[41,59,42,59],[39,61,40,61],[39,62,40,62],[41,45,42,45],[41,47,42,47],[41,49,42,49],[41,51,42,51],[41,53,42,53],[39,51,40,51],[39,53,40,53],[39,55,40,55],[39,57,40,57],[39,59,40,59],[41,35,42,35],[41,37,42,37],[41,39,42,39],[41,41,42,41],[41,43,42,43],[41,25,42,25],[41,27,42,27],[41,29,42,29],[41,31,42,31],[41,33,42,33],[41,15,42,15],[41,17,42,17],[41,19,42,19],[41,21,42,21],[41,23,42,23],[41,5,42,5],[41,7,42,7],[41,9,42,9],[41,11,42,11],[41,13,42,13],[39,2,40,2],[41,2,42,2],[43,2,44,2],[41,3,42,3],[43,53,44,53],[43,55,44,55],[43,57,44,57],[43,59,44,59],[43,43,44,43],[43,45,44,45],[43,47,44,47],[43,49,44,49],[43,51,44,51],[43,33,44,33],[43,35,44,35],[43,37,44,37],[43,39,44,39],[43,41,44,41],[43,23,44,23],[43,25,44,25],[43,27,44,27],[43,29,44,29],[43,31,44,31],[43,13,44,13],[43,15,44,15],[43,17,44,17],[43,19,44,19],[43,21,44,21],[43,3,44,3],[43,5,44,5],[43,7,44,7],[43,9,44,9],[43,11,44,11],[39,41,40,41],[39,43,40,43],[39,45,40,45],[39,47,40,47],[39,49,40,49],[39,31,40,31],[39,33,40,33],[39,35,40,35],[39,37,40,37],[39,39,40,39],[39,5,40,5],[39,7,40,7],[39,9,40,9],[39,11,40,11],[39,13,40,13],[39,15,40,15],[39,17,40,17],[39,19,40,19],[39,21,40,21],[39,23,40,23],[39,25,40,25],[39,27,40,27],[39,29,40,29],[39,3,40,3],[4,45,4,46],[2,56,2,60],[2,51,2,55],[21,3,21,24],[22,3,22,24],[4,40,4,42],[3,43,3,44],[4,43,4,44],[3,37,3,39],[4,37,4,39],[3,3,3,31],[4,3,4,31],[20,3,20,24],[2,40,2,42],[2,43,2,44],[7,56,7,60],[3,56,3,60],[4,56,4,60],[3,51,3,55],[4,51,4,55],[2,47,2,48],[3,47,3,48],[4,47,4,48],[2,49,2,50],[3,49,3,50],[4,49,4,50],[3,40,3,42],[2,45,2,46],[3,45,3,46]]}
[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,"MSP明朝　×"]
[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,"MS明朝　　○",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,"号年(MS）",null,null,null,null,"号年月(MS）",null,null,null,null,"号年月日(MSゴシック又は明朝）"]
[null,null,"特定",{"$f":"基本!C27","v":"土、建、解、管"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-01-07"},null,null,{"$f":"YEAR(AL4)","v":2022},null,null,{"$f":"TEXT(AL4,\"e\")","v":"4"},null,{"$f":"TEXT(AL4,\"g\")","v":"R"},null,{"$f":"TEXT(AL4,\"gg\")","v":"令"},null,{"$f":"TEXT(AL4,\"ge\")","v":"R4"},null,{"$f":"TEXT(AL4,\"ggg\")&RIGHT(\" \"&TEXT(AL4,\"e\"),2)&\"年\"","v":"令和 4年"},null,null,null,null,{"$f":"TEXT(AL4,\"ggg\")&RIGHT(\" \"&TEXT(AL4,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL4),2)&\"月\"","v":"令和 4年 1月"},null,null,null,null,{"$f":"TEXT(AL4,\"ggg\")&RIGHT(\" \"&TEXT(AL4,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL4),2)&\"月\"&RIGHT(\" \"&DAY(AL4),2)&\"日\"","v":"令和 4年 1月 7日"}]
[null,null,"一般",{"$f":"基本!C28","v":"電・消"},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,"2029-12-31",null,null,{"$f":"YEAR(AL5)","v":2029},null,null,{"$f":"TEXT(AL5,\"e\")","v":"11"},null,{"$f":"TEXT(AL5,\"g\")","v":"R"},null,{"$f":"TEXT(AL5,\"gg\")","v":"令"},null,{"$f":"TEXT(AL5,\"ge\")","v":"R11"},null,{"$f":"TEXT(AL5,\"ggg\")&RIGHT(\" \"&TEXT(AL5,\"e\"),2)&\"年\"","v":"令和11年"},null,null,null,null,{"$f":"TEXT(AL5,\"ggg\")&RIGHT(\" \"&TEXT(AL5,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL5),2)&\"月\"","v":"令和11年12月"},null,null,null,null,{"$f":"TEXT(AL5,\"ggg\")&RIGHT(\" \"&TEXT(AL5,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL5),2)&\"月\"&RIGHT(\" \"&DAY(AL5),2)&\"日\"","v":"令和11年12月31日"}]
[null,null,"経営審査",{"$f":"基本!C29","v":"電、消、土、解、管"}]
[null,null,"申請業種",{"$f":"基本!C30","v":"電、消、土、解、管"},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,"MSPの場合印刷が不揃いになる"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AL4,\"ggg\")&RIGHT(\" \"&TEXT(AL4,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL4),2)&\"月\"","v":"令和 4年 1月"},null,null,null,null,{"$f":"TEXT(AL4,\"ggg\")&RIGHT(\" \"&TEXT(AL4,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL4),2)&\"月\"&RIGHT(\" \"&DAY(AL4),2)&\"日\"","v":"令和 4年 1月 7日"}]
[null,null,null,"土","建","大","左","と","石","屋","電","管","夕","鋼","筋","舗","しゅ","板","ガ","塗","防","内","機","絶","通","園","井","具","水","消","清","解",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AL5,\"ggg\")&RIGHT(\" \"&TEXT(AL5,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL5),2)&\"月\"","v":"令和11年12月"},null,null,null,null,{"$f":"TEXT(AL5,\"ggg\")&RIGHT(\" \"&TEXT(AL5,\"e\"),2)&\"年\"&RIGHT(\" \"&MONTH(AL5),2)&\"月\"&RIGHT(\" \"&DAY(AL5),2)&\"日\"","v":"令和11年12月31日"}]
[null,"○","特定",{"$f":"IFERROR(IF(SEARCH(D9,$D$4),$B$10),\"\")","v":"○"},"○","","","","","","","○","","","","","","","","","","","","","","","","","","","","○"]
[null,"○","一般",{"$f":"IFERROR(IF(SEARCH(D9,$D$5),$B$11),\"\")","v":""},"","","","","","","○","","","","","","","","","","","","","","","","","","","○","",""]
[]
[null,"１　　２","許可種類",{"$f":"IF(D10=\"○\",2,IF(D11=\"○\",1,\"\"))","v":2},2,"","","","","",1,2,"","","","","","","","","","","","","","","","","",1,"",2]
[null,9,"経営審査",{"$f":"IFERROR(IF(SEARCH(D9,$D$6),$B$14),\"\")","v":9},{"$f":"IFERROR(IF(SEARCH(E9,$D$6),$B$14),\"\")","v":""},"","","","","",9,9,"","","","","","","","","","","","","","","","","",9,"",9]
[null,"○","指名",{"$f":"IFERROR(IF(SEARCH(D9,$D$7),$B$15),\"\")","v":"○"},"","","","","","","○","○","","","","","","","","","","","","","","","","","","○","","○"]
[null,null,null,{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(#REF!,基本!#REF!),\"○\"),\"\")","v":""}]
[]
[null,"□","特定",{"$f":"IF(D10=\"○\",$B$19,$B$18)","v":"■"},{"$f":"IF(E10=\"○\",$B$19,$B$18)","v":"■"},"□","□","□","□","□","□","■","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","■"]
[null,"■","一般",{"$f":"IF(D11=\"○\",$B$19,$B$18)","v":"□"},{"$f":"IF(E11=\"○\",$B$19,$B$18)","v":"□"},"□","□","□","□","□","■","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","□","■","□","□"]
[]
[null,null,null,"土建大左と石屋電管タ鋼筋舗しゅ板ガ塗防内機絶通園井具水消清解"]
[null,null,"特定",{"$f":"D18&E18&F18&G18&H18&I18&J18&K18&L18&M18&N18&O18&P18&\" \"&Q18&R18&S18&T18&U18&V18&W18&X18&Y18&Z18&AA18&AB18&AC18&AD18&AE18&AF18","v":"■■□□□□□□■□□□□ □□□□□□□□□□□□□□□■"}]
[null,null,"一般",{"$f":"D19&E19&F19&G19&H19&I19&J19&K19&L19&M19&N19&O19&P19&\" \"&Q19&R19&S19&T19&U19&V19&W19&X19&Y19&Z19&AA19&AB19&AC19&AD19&AE19&AF19","v":"□□□□□□□■□□□□□ □□□□□□□□□□□□□■□□"}]
[]
[null,null,null,null,{"$f":"IFERROR(IF(SEARCH(E9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(F9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(G9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(H9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(I9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(J9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(K9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(L9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(M9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(N9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(O9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(P9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(Q9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(R9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(S9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(T9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(U9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(V9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(W9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(X9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(Y9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(Z9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AA9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AB9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AC9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AD9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AE9,基本!#REF!),\"○\"),\"\")","v":""},{"$f":"IFERROR(IF(SEARCH(AF9,基本!#REF!),\"○\"),\"\")","v":""}]
[null,null,"許可業種","土",null,"建",null,"大",null,"左",null,"と",null,"石",null,"屋",null,"電",null,"管",null,"夕",null,"鋼",null,"筋",null,"舗",null,"しゅ",null,"板",null,"ガ",null,"塗",null,"防",null,"内",null,"機",null,"絶",null,"通",null,"園",null,"井",null,"具",null,"水",null,"消",null,"清",null,"解"]
[null,"○","特定",{"$f":"IFERROR(IF(SEARCH(D26,$D$4),$B$27),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$4),$B$27),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$4),$B$27),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$4),$B$27),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$4),$B$27),\"\")","v":"○"}]
[null,"○","一般",{"$f":"IFERROR(IF(SEARCH(D26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$5),$B$28),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$5),$B$28),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$5),$B$28),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$5),$B$28),\"\")","v":""}]
[]
[null,"１　　２","許可種類",{"$f":"IF(D27=\"○\",2,IF(D28=\"○\",1,\"\"))","v":2},null,2,null,"",null,"",null,"",null,"",null,"",null,1,null,2,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,1,null,"",null,2,null,null,"川南町"]
[null,"○　●","許可種類",{"$f":"IF(D27=\"○\",\"●\",IF(D28=\"○\",\"○\",\"\"))","v":"●"},null,{"$f":"IF(F27=\"○\",\"●\",IF(F28=\"○\",\"○\",\"\"))","v":"●"},null,{"$f":"IF(H27=\"○\",\"●\",IF(H28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(J27=\"○\",\"●\",IF(J28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(L27=\"○\",\"●\",IF(L28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(N27=\"○\",\"●\",IF(N28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(P27=\"○\",\"●\",IF(P28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(R27=\"○\",\"●\",IF(R28=\"○\",\"○\",\"\"))","v":"○"},null,{"$f":"IF(T27=\"○\",\"●\",IF(T28=\"○\",\"○\",\"\"))","v":"●"},null,{"$f":"IF(V27=\"○\",\"●\",IF(V28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(X27=\"○\",\"●\",IF(X28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(Z27=\"○\",\"●\",IF(Z28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AB27=\"○\",\"●\",IF(AB28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AD27=\"○\",\"●\",IF(AD28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AF27=\"○\",\"●\",IF(AF28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AH27=\"○\",\"●\",IF(AH28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AJ27=\"○\",\"●\",IF(AJ28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AL27=\"○\",\"●\",IF(AL28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AN27=\"○\",\"●\",IF(AN28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AP27=\"○\",\"●\",IF(AP28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AR27=\"○\",\"●\",IF(AR28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AT27=\"○\",\"●\",IF(AT28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AV27=\"○\",\"●\",IF(AV28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AX27=\"○\",\"●\",IF(AX28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(AZ27=\"○\",\"●\",IF(AZ28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(BB27=\"○\",\"●\",IF(BB28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(BD27=\"○\",\"●\",IF(BD28=\"○\",\"○\",\"\"))","v":"○"},null,{"$f":"IF(BF27=\"○\",\"●\",IF(BF28=\"○\",\"○\",\"\"))","v":""},null,{"$f":"IF(BH27=\"○\",\"●\",IF(BH28=\"○\",\"○\",\"\"))","v":"●"},null,"特定●、一般○（高千穂町）"]
[null,"許可","経営審査",{"$f":"IFERROR(IF(SEARCH(D26,$D$6),D$31),\"\")","v":"●"},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$6),F$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$6),H$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$6),J$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$6),L$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$6),N$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$6),P$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$6),R$31),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$6),T$31),\"\")","v":"●"},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$6),V$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$6),X$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$6),Z$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$6),AB$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$6),AD$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$6),AF$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$6),AH$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$6),AJ$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$6),AL$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$6),AN$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$6),AP$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$6),AR$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$6),AT$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$6),AV$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$6),AX$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$6),AZ$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$6),BB$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$6),BD$31),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$6),BF$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$6),BH$31),\"\")","v":"●"},null,"特定●、一般○（高千穂町）"]
[null,"許可","指名",{"$f":"IFERROR(IF(SEARCH(D26,$D$7),D$31),\"\")","v":"●"},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$7),F$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$7),H$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$7),J$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$7),L$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$7),N$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$7),P$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$7),R$31),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$7),T$31),\"\")","v":"●"},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$7),V$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$7),X$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$7),Z$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$7),AB$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$7),AD$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$7),AF$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$7),AH$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$7),AJ$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$7),AL$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$7),AN$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$7),AP$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$7),AR$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$7),AT$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$7),AV$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$7),AX$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$7),AZ$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$7),BB$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$7),BD$31),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$7),BF$31),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$7),BH$31),\"\")","v":"●"},null,"特定●、一般○（高千穂町）"]
[null,"○","経営審査",{"$f":"IFERROR(IF(SEARCH(D26,$D$6),$B$34),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$6),$B$34),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$6),$B$34),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$6),$B$34),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$6),$B$34),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$6),$B$34),\"\")","v":"○"},null,"●　■　変更可","川南町"]
[null,"○","指名",{"$f":"IFERROR(IF(SEARCH(D26,$D$7),$B$35),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(F26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(H26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(J26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(L26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(N26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(P26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(R26,$D$7),$B$35),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(T26,$D$7),$B$35),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(V26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(X26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(Z26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AB26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AD26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AF26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AH26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AJ26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AL26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AN26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AP26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AR26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AT26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AV26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AX26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(AZ26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BB26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BD26,$D$7),$B$35),\"\")","v":"○"},null,{"$f":"IFERROR(IF(SEARCH(BF26,$D$7),$B$35),\"\")","v":""},null,{"$f":"IFERROR(IF(SEARCH(BH26,$D$7),$B$35),\"\")","v":"○"},null,"●　■　変更可","川南町"]
[]
[null,"□","特定",{"$f":"IF(D27=\"○\",$B$38,$B$37)","v":"■"},null,{"$f":"IF(F27=\"○\",$B$38,$B$37)","v":"■"},null,{"$f":"IF(H27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(J27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(L27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(N27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(P27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(R27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(T27=\"○\",$B$38,$B$37)","v":"■"},null,{"$f":"IF(V27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(X27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(Z27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AB27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AD27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AF27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AH27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AJ27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AL27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AN27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AP27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AR27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AT27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AV27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AX27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AZ27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BB27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BD27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BF27=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BH27=\"○\",$B$38,$B$37)","v":"■"}]
[null,"■","一般",{"$f":"IF(D28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(F28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(H28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(J28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(L28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(N28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(P28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(R28=\"○\",$B$38,$B$37)","v":"■"},null,{"$f":"IF(T28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(V28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(X28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(Z28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AB28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AD28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AF28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AH28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AJ28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AL28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AN28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AP28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AR28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AT28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AV28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AX28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(AZ28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BB28=\"○\",$B$38,$B$37)","v":"□"},null,{"$f":"IF(BD28=\"○\",$B$38,$B$37)","v":"■"},null,{"$f":"IF(BF28=\"○\",$B$38,$B$37)","v":"□"},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":3,"n_rows":103,"n_cols":27,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"引込 ①",null,"引込 ②",null,"引込 ③",null,"書込　①",null,"書込　②",null,"書込　③",null,"書込　④",null,"書込　⑤",null,"書込　⑥",null,"書込　⑦",null,"書込　⑧",null,"書込　⑨",null,"書込　⑩"]
[null,null,"門川町",null,"日向市",null,null,null,"日向市",null,"門川町",null,"美郷町",null,"諸塚村",null,"椎葉村",null,"川南町",null,"高千穂町"]
[{"$f":"基本!B4","v":"会社名"},{"$f":"基本!C4","v":"有限会社　宮崎電工社"},"資格審査申請書","AS11",null,null,null,null,"①資格審査申請書","BC10","資格審査申請書","AS11",null,null,null,null,null,null,"①申請書","AH26","申請書（建設工事）","AS34"]
[{"$f":"基本!B5","v":"会社名　略"},{"$f":"基本!C5","v":"(有)宮崎電工社"}]
[{"$f":"基本!B6","v":"ふりがな"},{"$f":"基本!C6","v":"　　　みやざきでんこうしゃ"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH25","申請書（建設工事）","AS33"]
[{"$f":"基本!B7","v":"フリガナ"},{"$f":"基本!C7","v":"　　　ミヤザキデンコウシャ"},"資格審査申請書","AS8",null,null,null,null,"①資格審査申請書","BC9","資格審査申請書","AS8"]
[{"$f":"基本!B8","v":"〒"},{"$f":"基本!C8","v":"883-0026"},"資格審査申請書","AX16",null,null,null,null,null,null,"資格審査申請書","AX16",null,null,null,null,null,null,"①申請書","AJ22","申請書（建設工事）","AS28"]
[{"$f":"基本!B9","v":"住所"},{"$f":"基本!C9","v":"日向市大字日知屋１２３４５"},"資格審査申請書","AS19",null,null,null,null,"①資格審査申請書","BC14","資格審査申請書","AS19",null,null,null,null,null,null,"①申請書","AH24","申請書（建設工事）","AS31"]
[{"$f":"基本!B10","v":"ふりがな"},{"$f":"基本!C10","v":"ひゅうがし　おおあざひちや"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH23","申請書（建設工事）","AS30"]
[{"$f":"基本!B11","v":"フリガナ"},{"$f":"基本!C11","v":0}]
[{"$f":"基本!B12","v":"役職"},{"$f":"基本!C12","v":"代表取締役"},"資格審査申請書","AS22",null,null,null,null,"①資格審査申請書","BC16","資格審査申請書","AS22"]
[{"$f":"基本!B13","v":"代表者名"},{"$f":"基本!C13","v":"宮崎　太郎"},"資格審査申請書","AS25",null,null,null,null,"①資格審査申請書","BT16","資格審査申請書","AS25"]
[{"$f":"基本!B14","v":"ふりがな"},{"$f":"基本!C14","v":"みやざき　たろう"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH27","申請書（建設工事）","AS36"]
[{"$f":"基本!B15","v":"フリガナ"},{"$f":"基本!C15","v":"ミヤザキ　タロウ"}]
[{"$f":"基本!B16","v":"電話"},{"$f":"基本!C16","v":"0982-52-1234"},"資格審査申請書","BS22",null,null,null,null,"①資格審査申請書","BJ12","資格審査申請書","BS22",null,null,null,null,null,null,null,null,"申請書（建設工事）","AS39"]
[{"$f":"基本!B17","v":"FAX"},{"$f":"基本!C17","v":"0982-53-2345"},"資格審査申請書","BS25",null,null,null,null,"①資格審査申請書","CA12","資格審査申請書","BS25",null,null,null,null,null,null,null,null,"申請書（建設工事）","AS41"]
[{"$f":"基本!B18","v":"e-maile"},{"$f":"基本!C18","v":" 　　miyaaden@crux.ocn.ne.jp"},null,null,null,null,null,null,"①資格審査申請書","BC20"]
[{"$f":"基本!B19","v":"担当部署名"},{"$f":"基本!C19","v":"本店"}]
[{"$f":"基本!B20","v":"担当者名"},{"$f":"基本!C20","v":"宮崎　二郎"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH30","申請書（建設工事）","AS44"]
[{"$f":"基本!B21","v":"担当ふりがな"},{"$f":"基本!C21","v":"みやざき　じろう"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH29","申請書（建設工事）","AS43"]
[{"$f":"基本!B22","v":"担当フリガナ"},{"$f":"基本!C22","v":"ミヤザキ　ジロウ"}]
[{"$f":"基本!B23","v":"担当　電話"},{"$f":"基本!C23","v":"0982-52-1234"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH31"]
[{"$f":"基本!B24","v":"担当　FAX"},{"$f":"基本!C24","v":"0982-53-2345"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH32"]
[{"$f":"基本!B25","v":"許可番号"},{"$f":"基本!C25","v":2345},"資格審査申請書","AU58",null,null,null,null,"①資格審査申請書","H19","資格審査申請書","AU58",null,null,null,null,null,null,"①申請書","AE10","申請書（建設工事）","AT13"]
[{"$f":"基本!B26","v":"許可年月日"},{"$f":"基本!C26","v":43016},"資格審査申請書","W67",null,null,null,null,null,null,"資格審査申請書","W67"]
[{"$f":"基本!B27","v":"許可　特定"},{"$f":"基本!C27","v":"土、建、解、管"},"営業所一覧表","N14",null,null,null,null,"⑥営業所一覧表","M13","営業所一覧表","N14",null,null,null,null,null,null,"⑤営業所","B8","営業所一覧表","C9"]
[{"$f":"基本!B28","v":"　　　　一般"},{"$f":"基本!C28","v":"電・消"},"営業所一覧表","X14",null,null,null,null,"⑥営業所一覧表","W13","営業所一覧表","X14",null,null,null,null,null,null,"⑤営業所","C8","営業所一覧表","D9"]
[{"$f":"基本!B30","v":"指名申請"},{"$f":"基本!C30","v":"電、消、土、解、管"}]
[{"$f":"基本!#REF!","v":{"$error":"#REF!"}},{"$f":"基本!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"基本!B31","v":"〒　３"},{"$f":"基本!C31","v":"883"},null,null,null,null,null,null,"①資格審査申請書","AX12"]
[{"$f":"基本!B32","v":"〒　４"},{"$f":"基本!C32","v":"0026"},null,null,null,null,null,null,"①資格審査申請書","BC12"]
[{"$f":"基本!B33","v":"電話市外"},{"$f":"基本!C33","v":"0982"}]
[{"$f":"基本!B34","v":"電話局番"},{"$f":"基本!C34","v":"52"}]
[{"$f":"基本!B35","v":"電話番号"},{"$f":"基本!C35","v":"1234"}]
[{"$f":"基本!B36","v":"FAX　市外"},{"$f":"基本!C36","v":"0982"}]
[{"$f":"基本!B37","v":"FAX　局番"},{"$f":"基本!C37","v":"53"}]
[{"$f":"基本!B38","v":"FAX　番号"},{"$f":"基本!C38","v":"2345"}]
[{"$f":"基本!B39","v":"職氏名"},{"$f":"基本!C39","v":"代表取締役　宮崎　太郎"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①申請書","AH28","申請書（建設工事）","AS37"]
[{"$f":"基本!B40","v":"〒"},{"$f":"基本!C40","v":"〒883-0026"},null,null,null,null,null,null,"⑥営業所一覧表","AG13",null,null,null,null,null,null,null,null,"⑤営業所","D8","営業所一覧表","E8"]
[{"$f":"基本!B41","v":"住所"},{"$f":"基本!C41","v":"日向市大字日知屋１２３４５"},null,null,null,null,null,null,"⑥営業所一覧表","AG15",null,null,null,null,null,null,null,null,"⑤営業所","D9","営業所一覧表","E9"]
[{"$f":"基本!B42","v":"電話"},{"$f":"基本!C42","v":"電話　0982-52-1234"},null,null,null,null,null,null,"⑥営業所一覧表","AG17",null,null,null,null,null,null,null,null,"⑤営業所","D10","営業所一覧表","E10"]
[{"$f":"基本!B43","v":"FAX"},{"$f":"基本!C43","v":"FAX　 0982-53-2345"},null,null,null,null,null,null,"⑥営業所一覧表","AG19",null,null,null,null,null,null,null,null,"⑤営業所","D11","営業所一覧表","E11"]
[{"$f":"基本!B44","v":0},{"$f":"基本!C44","v":"本　店"},null,null,null,null,null,null,"⑥営業所一覧表","A13",null,null,null,null,null,null,null,null,"⑤営業所","A8"]
[{"$f":"基本!B45","v":"代表者住所"},{"$f":"基本!C45","v":0},null,null,null,null,null,null,"①資格審査申請書","BC18"]
[{"$f":"基本!B46","v":"許可　年号"},{"$f":"基本!C46","v":"H"}]
[{"$f":"基本!B47","v":"許可　年"},{"$f":"基本!C47","v":"29"}]
[{"$f":"基本!B48","v":"許可　月"},{"$f":"基本!C48","v":10}]
[{"$f":"基本!B49","v":"許可　日"},{"$f":"基本!C49","v":8}]
[{"$f":"基本!B50","v":"有効期限"},{"$f":"基本!C50","v":44841}]
[{"$f":"基本!B51","v":"有効　年号"},{"$f":"基本!C51","v":"R"},null,null,null,null,null,null,"①資格審査申請書","X25"]
[{"$f":"基本!B52","v":"有効　年"},{"$f":"基本!C52","v":"4"},null,null,null,null,null,null,"①資格審査申請書","Z25"]
[{"$f":"基本!B53","v":"有効　月"},{"$f":"基本!C53","v":10},null,null,null,null,null,null,"①資格審査申請書","AD25"]
[{"$f":"基本!B54","v":"有効　日"},{"$f":"基本!C54","v":7},null,null,null,null,null,null,"①資格審査申請書","AH25"]
[{"$f":"基本!B55","v":0},{"$f":"基本!C55","v":0}]
[{"$f":"基本!B56","v":0},{"$f":"基本!C56","v":0}]
[{"$f":"基本!B57","v":0},{"$f":"基本!C57","v":0}]
[{"$f":"基本!B58","v":0},{"$f":"基本!C58","v":0}]
[{"$f":"基本!B59","v":"椎葉村長"},{"$f":"基本!C59","v":"黒木　保隆"}]
[{"$f":"基本!B60","v":"延岡市長"},{"$f":"基本!C60","v":0}]
[{"$f":"基本!B61","v":"高千穂町長"},{"$f":"基本!C61","v":"甲斐　宗之"}]
[{"$f":"基本!B62","v":0},{"$f":"基本!C62","v":"(有)宮崎電工社"}]
[{"$f":"基本!B63","v":0},{"$f":"基本!C63","v":"(有)宮崎電工社"}]
[{"$f":"基本!B64","v":0},{"$f":"基本!C64","v":"(有)宮崎電工社"}]
[{"$f":"基本!B65","v":0},{"$f":"基本!C65","v":"(有)宮崎電工社"}]
[{"$f":"基本!B66","v":0},{"$f":"基本!C66","v":"(有)宮崎電工社"}]
[{"$f":"基本!B67","v":0},{"$f":"基本!C67","v":"宮崎　太郎"}]
[{"$f":"基本!B68","v":0},{"$f":"基本!C68","v":"宮崎　太郎"}]
[{"$f":"基本!B69","v":0},{"$f":"基本!C69","v":"宮崎　太郎"}]
[{"$f":"基本!B70","v":0},{"$f":"基本!C70","v":0}]
[{"$f":"基本!B71","v":0},{"$f":"基本!C71","v":0}]
[{"$f":"基本!B72","v":0},{"$f":"基本!C72","v":0}]
[{"$f":"基本!B73","v":0},{"$f":"基本!C73","v":0}]
[{"$f":"基本!B74","v":0},{"$f":"基本!C74","v":0}]
[{"$f":"基本!B75","v":0},{"$f":"基本!C75","v":0}]
[{"$f":"基本!B76","v":0},{"$f":"基本!C76","v":0}]
[{"$f":"基本!B77","v":0},{"$f":"基本!C77","v":0}]
[{"$f":"基本!B78","v":0},{"$f":"基本!C78","v":0}]
[{"$f":"基本!B79","v":0},{"$f":"基本!C79","v":0}]
[{"$f":"基本!B80","v":0},{"$f":"基本!C80","v":0}]
[{"$f":"基本!B81","v":0},{"$f":"基本!C81","v":0}]
[{"$f":"基本!B82","v":0},{"$f":"基本!C82","v":0}]
[{"$f":"基本!B83","v":0},{"$f":"基本!C83","v":0}]
[{"$f":"基本!B84","v":0},{"$f":"基本!C84","v":0}]
[{"$f":"基本!B85","v":0},{"$f":"基本!C85","v":0}]
[{"$f":"基本!B86","v":0},{"$f":"基本!C86","v":0}]
[{"$f":"基本!B87","v":0},{"$f":"基本!C87","v":0}]
[{"$f":"基本!B88","v":0},{"$f":"基本!C88","v":0}]
[{"$f":"基本!B89","v":0},{"$f":"基本!C89","v":0}]
[{"$f":"基本!B90","v":0},{"$f":"基本!C90","v":0}]
[{"$f":"基本!B91","v":0},{"$f":"基本!C91","v":0}]
[{"$f":"基本!B92","v":0},{"$f":"基本!C92","v":0}]
[{"$f":"基本!B93","v":0},{"$f":"基本!C93","v":0}]
[{"$f":"基本!B94","v":0},{"$f":"基本!C94","v":0}]
[{"$f":"基本!B95","v":0},{"$f":"基本!C95","v":0}]
[{"$f":"基本!B96","v":0},{"$f":"基本!C96","v":0}]
[{"$f":"基本!B97","v":0},{"$f":"基本!C97","v":0}]
[{"$f":"基本!B98","v":0},{"$f":"基本!C98","v":0}]
[{"$f":"基本!B99","v":0},{"$f":"基本!C99","v":0}]
[{"$f":"基本!B100","v":0},{"$f":"基本!C100","v":0}]
[{"$f":"基本!B101","v":0},{"$f":"基本!C101","v":0}]
[{"$f":"基本!B102","v":0},{"$f":"基本!C102","v":0}]
[{"$f":"基本!B103","v":"owari "}]

{"sheet":"工事","index":4,"n_rows":127,"n_cols":31,"rows_kept":127,"cut":false,"hidden":false,"merged":[[6,8,6,9],[13,8,13,9]]}
["工事",null,null,null,null,"操作順序",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T3=0,\"\",MID(T3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(T3)&1234567890)),3))","v":"16"},{"$f":"TEXT(V1,\"e\")","v":"4"},{"$f":"TODAY()","v":"2022-01-07"},null,null,"R3－指名願マスター（工事・技術・役員等）.xlsm"]
[null,null,null,null,null,"①工事データーをクリア",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T3=\"\",\"\",COLUMN(INDIRECT(T3&\"1\")))","v":52},null,null,null,null,"ペイント三州R3-日向市指名願.xlsx"]
[null,null,null,null,null,"②相手先のブック・シートを開いて「②　ボタン」　をクリック",null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ16"]
[null,null,null,null,null,"③引込元のデーター開始位置・増分・番地を記入③又は、保存データーからコピー.又は使用方法のダブルクリックを利用する"]
[null,null,null,null,null,"④「④　追加引込」　ボタンをクリック"]
[null,null,null,null,null,"⑤金額の税込・税抜を確認"]
["引込元の位置",null,null,null,"引込元","Ｒ３－変更届(宮崎県)2021.2.xlsm",null,"シート名","工事２"]
["ﾃﾞｰﾀ名称","件数","増分","発注者","元・下","工事名","工事名２","都道府県","市町村","請負金額","着工年","着工月","着工日","完成年","完成月","完成日","技術者",null,null,null,null,null,null,null,null,null,null,null,1,null,2]
["変更届",40,2,"B10","C10","D10","D11","E10","E11","H10","J10","K10","L10","J11","K11","L11","G10",null,null,null,null,null,null,null,null,null,null,null,"処理しない",null,"金額　円→金額　千円"]
[null,null,null,null,null,null,{"$f":"IF(G9=\"\",\"\",2)","v":2},null,null,null,{"$f":"SUM(L10:M10)","v":0},{"$f":"IF(L9=\"\",3,\"\")","v":""},{"$f":"IF(M9=\"\",3,\"\")","v":""},{"$f":"SUM(O10:P10)","v":0},{"$f":"IF(O9=\"\",3,\"\")","v":""},{"$f":"IF(P9=\"\",3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"税込円→税込千円",null,"税込　円→税抜　千円（10%)"]
[null,null,null,null,null,null,"２行の場合1行に結合（１行の場合は、工事名２は記入しない）",null,null,"「RYY.MM.DD」の場合着工年のみに記入（月日は削除）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税込円→税抜千円（10%)"]
[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,"書出先","ペイント三州R3-日向市指名願.xlsx",null,"シート名","⑤工事経歴書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["ﾃﾞｰﾀ名称③","件数","増分","発注者","元・下","工事名","都道府県","市町村","請負金額","着工年","着工月","着工日","完成年","完成月","完成日","技術者",null,null,{"$f":"S21","v":"請負金額"},{"$f":"T21","v":"着年号"},"完年号","着号年月","完号年月","県市町村",0,null,null,"年月"]
["日向市",10,4,"A20","M20","P20","AF20",null,null,"AU20","AX20","BA20","AU22","AX22","BA22",null,null,null,"AK20"]
[null,"①書込先のファイル・シートを開いて、①ファイル名取得ボタンをｸﾘｯｸ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"号年月"]
[null,"②データー内容の加工・修正（数式の修正）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M18=\"\",\"\",IF(M18<20,\"令和\",\"平成\"))","v":""},null,null,null,null,null,null,"号年月日"]
[null,"③書込先のデーター開始位置・増分・番地を記入③又は、保存データーから引き込む",null,null,null,null,null,null,null,"転記先の工事名を確認・調整する事",null,null,null,null,null,"印刷対象件数",{"$f":"COUNTIF(Q22:Q64,$Q$20)","v":17},null,null,null,{"$f":"IF(M19=\"\",\"\",IF(M19<20,\"令和\",\"平成\"))","v":""}]
[null,"④請負金額の確認（税込・抜）",null,null,null,null,null,null,"税込み","折り返し位置・文字のポイント等",null,null,null,null,null,"印刷対象",1,null,null,{"$f":"IF(J20=\"\",\"\",IF(J20<20,\"令和\",\"平成\"))","v":"平成"},{"$f":"IF(M20=\"\",\"\",IF(M20<20,\"令和\",\"平成\"))","v":""},null,null,"←印刷面のフォントを（MSP×）MSとする事"]
["種類",null,null,"発注者","元・下","工事名","都道府県","市町村","請負金額","着工年月日",null,null,"完成年月日",null,null,"技術者","転記","ソートキー","請負金額","着年号","完年号",{"$f":"\"着\" & INDEX(AB15:AB18,AB14)","v":"着号年月"},{"$f":"\"完\" & INDEX(AB15:AB18,AB14)","v":"完号年月"},"県市町村"]
["建築一式",null,{"$f":"ROW()-21","v":1},"日向市","元請","テストデーター１","宮崎県","日向市",1100000,3,8,10,3,12,5,"宮崎太郎",1,{"$f":"IF(M22=\"\",61363,DATE(IF(M22<25,2018,1988)+M22,N22,O22)+IF(O22<1,1,0))","v":"2021-12-05"},{"$f":"IF(I22=0,\"\",IF($AE$8=1,INT(I22/1000),INT(I22/1.1/1000)))","v":1000},{"$f":"IF(J22<25,\"令和\",\"平成\")","v":"令和"},{"$f":"IF(M22<25,\"令和\",\"平成\")","v":"令和"},{"$f":"IF($AB$14<3,\"\",T22)&RIGHT(\"  \"&J22,2)&\" 年 \"&RIGHT(\"  \"&K22,2)&\" 月\"&IF(OR($AB$14=3,$AB$14=1),\"\",RIGHT(\"  \"&L22,2)&\"日\")","v":"令和 3 年  8 月"},{"$f":"IF($AB$14<3,\"\",U22)&RIGHT(\"  \"&M22,2)&\" 年 \"&RIGHT(\"  \"&N22,2)&\" 月\"&IF(OR($AB$14=3,$AB$14=1),\"\",RIGHT(\"  \"&O22,2)&\"日\")","v":"令和 3 年 12 月"},{"$f":"G22&H22","v":"宮崎県日向市"}]
[null,null,{"$f":"ROW()-21","v":2},"日向市",null,"テストデーター２","宮崎県","日向市",1100001,3,8,10,null,null,null,null,1,{"$f":"IF(M23=\"\",61363,DATE(IF(M23<25,2018,1988)+M23,N23,O23)+IF(O23<1,1,0))","v":"2068-01-01"},1000,{"$f":"IF(J23<25,\"令和\",\"平成\")","v":"令和"},{"$f":"IF(M23<25,\"令和\",\"平成\")","v":"令和"},{"$f":"IF($AB$14<3,\"\",T23)&RIGHT(\"  \"&J23,2)&\" 年 \"&RIGHT(\"  \"&K23,2)&\" 月\"&IF(OR($AB$14=3,$AB$14=1),\"\",RIGHT(\"  \"&L23,2)&\"日\")","v":"令和 3 年  8 月"},{"$f":"IF($AB$14<3,\"\",U23)&RIGHT(\"  \"&M23,2)&\" 年 \"&RIGHT(\"  \"&N23,2)&\" 月\"&IF(OR($AB$14=3,$AB$14=1),\"\",RIGHT(\"  \"&O23,2)&\"日\")","v":"令和   年    月"},{"$f":"G23&H23","v":"宮崎県日向市"}]
[null,null,3,"日向市",null,"テストデーター３","宮崎県","日向市",1100002,3,8,10,null,null,null,null,1,"2068-01-01",1000,"令和","令和","令和 3 年  8 月","令和   年    月","宮崎県日向市"]
[null,null,4,"日向市",null,"テストデーター４","宮崎県","日向市",1100003,3,8,10,null,null,null,null,1,"2068-01-01",1000,"令和","令和","令和 3 年  8 月","令和   年    月","宮崎県日向市"]
[null,null,5,"日向市",null,"テストデーター５","宮崎県","日向市",1100004,3,8,10,null,null,null,null,1,"2068-01-01",1000,"令和","令和","令和 3 年  8 月","令和   年    月","宮崎県日向市"]
[null,null,6,"日向市",null,"テストデーター６","宮崎県","日向市",1100005,3,8,10,null,null,null,null,1,"2068-01-01",1000,"令和","令和","令和 3 年  8 月","令和   年    月","宮崎県日向市"]
[null,null,7,"日向市",null,"テストデーター７","宮崎県","日向市",1100006,3,8,10,null,null,null,null,1,"2068-01-01",1000,"令和","令和","令和 3 年  8 月","令和   年    月","宮崎県日向市"]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","",{"$f":"IF(J33<25,\"令和\",\"平成\")","v":"令和"},{"$f":"IF(M33<25,\"令和\",\"平成\")","v":"令和"},"令和   年    月","令和   年    月",""]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[null,null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2068-01-01","","令和","令和","令和   年    月","令和   年    月",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5,null,22,null,null,null,null,null,null,null,null,7]
[null,null,3,null,5,null,null,null,null,null,null,null,null,14]
[null,null,5,null,22,null,null,null,null,null,null,null,null,7]
[null,null,3,null,5,null,null,null,null,null,null,null,null,14]

{"sheet":"工事倉庫","index":5,"n_rows":31,"n_cols":29,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["工事業経歴書　引込位置（引込対象別）データー　"]
[null,null,null,null,null,null,null,"２行の場合1行に結合（１行の場合は、工事名２はクリア）",null,null,null,"「RYY.MM.DD」の場合着工年のみに記入（月日はクリア）"]
[null,null,"件数","増分","発注者","元・下","工事名","工事名２","都道府県","市町村","請負金額","着工年","着工月","着工日","完成年","完成月","完成日","技術者"]
["変更届の場合","変更届書",40,2,"B10","C10","D10","D11","E10","E11","H10","J10","K10","L10","J11","K11","L11","G10"]
[null,"○○建設",40]
[null,"変更届",40,2,"B10","C10","D10","D11","E10","E11","H10","J10","K10","L10","J11","K11","L11","G10"]
[]
[]
[]
[]
[]
[]
[]
[]
[12]
[]
["工事業経歴書　書出位置（市町村別）データー　　税込・税抜を選択、年号年月日を選択可"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/1000,抜/1000",null,null,"着年月日","完年月日"]
[null,"書出データー","最大件数","増分","発注者","元・下","工事名","県","市町村","請負金額","着年","着月","着日","完年","完月","完日","主任","ソートキー","転記","請負金額","着年号","完年号","着年月","完年月"]
[null,"日向市",10,4,"A20","M20","P20","AF20",null,null,"AU20","AX20","BA20","AU22","AX22","BA22",null,null,null,"AK20"]
["R3","門川町",10,4,"A14","M14","P14","AF14",null,null,"AT14","AW14","AZ14","AT16","AW16","AZ16",null,null,"","AK14","AR14","AR16"]
["R3税込金額順","美郷町"]
[null,"諸塚村",15,3,"B11","G11","J11","","U11","","AD12","AF12","","AH12","AJ12","","",null,null,"Y11",""]
[null,"椎葉村",14,1,"A7","C7","D7","","E7","","H7","K7","","N7","P7","","",null,null,"F7","H7","M7"]
[null,"延岡市"]
[null,"日之影町"]
[null,"高千穂町",10,1,"B8","C8","D8","E8",null,null,null,null,null,null,null,null,null,null,null,"F8",null,null,"G8","H8",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,"川南町",15,4,"B17","K17","N17","AB17",null,null,"AP17","AS17",null,"AP19","AS19",null,null,null,null,"AG17","AN17","AN19",null,null,null,null,null,null,"年月日"]

{"sheet":"技術者","index":6,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":false,"merged":[[13,5,13,6],[13,8,13,9],[6,8,6,9],[6,5,6,6]]}
["技術",null,null,null,null,null,null,"操作順序",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R3－指名願マスター（工事・技術・役員等）.xlsm","R3－指名願（工事・技術・役員の転記）.xlsm"]
[null,null,null,null,null,null,null,"①画面をクリア",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ペイント三州R3-日向市指名願.xlsx"]
[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,1]
["ﾃﾞｰﾀ名称③","最大件数","増分","氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任","実務　工事経歴","スタート年月日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年　ＲＹＹ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年　　ＹＹ"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",IF($X$20=1,TEXT(J22,\"g\"),TEXT(J22,\"e\")))","v":"5"}]
[]
["書出先の位置",null,null,null,"書出先","ペイント三州R3-日向市指名願.xlsx",null,"シート名","⑧技術者経歴書",null,null,null,null,null,null,null,null,"経験",null,null,null,null,null,null,null,null,null,null,null,2]
["ﾃﾞｰﾀ名称③","最大件数","増分","氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任","実務　工事経歴","スタート年月日",null,null,"年数","月数","経験年月","氏名（姓）","氏名（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
["日向市",12,3,"C20",null,null,null,null,"M20",null,null,null,null,"AM20",null,null,null,"AX20","BB20",null,null,null,"X20","AA20","AE20"]
[null,"①書込先のファイル・シートを開いて、①ファイル名取得ボタンをｸﾘｯｸ"]
["基準日","②データー内容の加工・修正（数式の修正）"]
["2021-12-02","③書込先のデーター開始位置・増分・番地を記入③又は、保存データーから引き込む"]
[null,"④実務経験の工事を入力",null,null,null,null,null,null,null,null,null,null,null,null,"実務経験",null,1,"←印刷対象",null,null,null,null,null,2,null,null,1,null,null,1]
[null,null,null,"氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任","実務　工事経歴","スタート年月日",null,"印刷","経年","経月","経験年月","（姓）","（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
[null,null,1,"宮崎　太郎","1982-09-01","1943-02-26","九州工業高等学校","電気科","１級電気工事施工管理技士","1993-05-31",null,"○","○",null,"1959-04-01",null,1,{"$f":"IF(O22=\"\",\"\",DATEDIF(O22,$A$19,\"y\"))","v":62},{"$f":"IF(O22=\"\",\"\",MOD(DATEDIF(O22,$A$19,\"M\"),12))","v":8},{"$f":"RIGHT(\"  \"&R22,2)&\"年\"&RIGHT(\"  \"&S22,2)&\"月\"","v":"62年 8月"},{"$f":"IF(D22=\"\",\"\",LEFT(D22, FIND(\"　\", D22)-1))","v":"宮崎"},{"$f":"IF(D22=\"\",\"\",RIGHT(D22, LEN(D22)-FIND(\"　\", D22)))","v":"太郎"},{"$f":"IF(J22=\"\",\"\",TEXT(J22,\"ggg\"))","v":"平成"},{"$f":"IF(J22=\"\",\"\",IF($X$20=1,TEXT(J22,\"ge\"),TEXT(J22,\"e\")))","v":"5"},{"$f":"IF(J22=\"\",\"\",MONTH(J22))","v":5},{"$f":"IF(J22=\"\",\"\",DAY(J22))","v":31},{"$f":"IF(F22=\"\",\"\",IF($AA$20=1,TEXT(F22,\"ge\"),TEXT(F22,\"e\")))","v":"S18"},{"$f":"IF(F22=\"\",\"\",MONTH(F22))","v":2},{"$f":"IF(F22=\"\",\"\",DAY(F22))","v":26},{"$f":"IF(E22=\"\",\"\",IF($AD$20=1,TEXT(E22,\"ge\"),TEXT(E22,\"e\")))","v":"S57"},{"$f":"IF(E22=\"\",\"\",MONTH(E22))","v":9},{"$f":"IF(E22=\"\",\"\",DAY(E22))","v":1}]
["経験年数の算定",null,2,"宮崎　太郎","1982-09-01","1943-02-26","九州工業高等学校","電気科","甲種消防設備士","1966-10-31",null,null,"○",null,"1966-10-31",null,2,55,1,"55年 1月","宮崎","太郎",{"$f":"IF(J23=\"\",\"\",TEXT(J23,\"ggg\"))","v":"昭和"},"41",10,31,{"$f":"IF(F23=\"\",\"\",IF($AA$20=1,TEXT(F23,\"ge\"),TEXT(F23,\"e\")))","v":"S18"},{"$f":"IF(F23=\"\",\"\",MONTH(F23))","v":2},{"$f":"IF(F23=\"\",\"\",DAY(F23))","v":26},{"$f":"IF(E23=\"\",\"\",IF($AD$20=1,TEXT(E23,\"ge\"),TEXT(E23,\"e\")))","v":"S57"},{"$f":"IF(E23=\"\",\"\",MONTH(E23))","v":9},{"$f":"IF(E23=\"\",\"\",DAY(E23))","v":1}]
["　に使用する。",null,4,"宮崎　一郎","1995-04-01","1976-07-14","日向工業高等学校","電気科","２級電気工事施工管理技士","2012-03-09",null,null,"○",null,"1995-04-01",null,1,26,8,{"$f":"RIGHT(\"  \"&R24,2)&\"年\"&RIGHT(\"  \"&S24,2)&\"月\"","v":"26年 8月"},{"$f":"IF(D24=\"\",\"\",LEFT(D24, FIND(\"　\", D24)-1))","v":"宮崎"},{"$f":"IF(D24=\"\",\"\",RIGHT(D24, LEN(D24)-FIND(\"　\", D24)))","v":"一郎"},"平成",{"$f":"IF(J24=\"\",\"\",IF($X$20=1,TEXT(J24,\"ge\"),TEXT(J24,\"e\")))","v":"24"},{"$f":"IF(J24=\"\",\"\",MONTH(J24))","v":3},{"$f":"IF(J24=\"\",\"\",DAY(J24))","v":9},{"$f":"IF(F24=\"\",\"\",IF($AA$20=1,TEXT(F24,\"ge\"),TEXT(F24,\"e\")))","v":"S51"},{"$f":"IF(F24=\"\",\"\",MONTH(F24))","v":7},{"$f":"IF(F24=\"\",\"\",DAY(F24))","v":14},{"$f":"IF(E24=\"\",\"\",IF($AD$20=1,TEXT(E24,\"ge\"),TEXT(E24,\"e\")))","v":"H7"},{"$f":"IF(E24=\"\",\"\",MONTH(E24))","v":4},{"$f":"IF(E24=\"\",\"\",DAY(E24))","v":1}]
[null,null,6,"宮崎　一郎","1995-04-01","1976-04-25","日向工業高等学校","電気科","１級電気工事施工管理技士","2009-03-10",null,"○","○",null,"1995-04-01",null,1,26,8,"26年 8月","宮崎","一郎","平成","21",3,10,"S51",4,25,"H7",4,1]
[null,null,7,"日向　学","1998-04-01","1979-05-08","日向工業高等学校","電気科","第２種電気工事士","1996-10-21",null,null,"○",null,"1998-04-01",null,1,23,8,"23年 8月","日向","学","平成","8",10,21,"S54",5,8,"H10",4,1]
[null,null,8,"日向　四郎","2004-04-01","1965-12-30","日向工業高等学校","電気科","１級電気工事施工管理技士","1997-02-28",null,"○","○",null,"1984-04-01",null,1,37,8,"37年 8月","日向","四郎","平成","9",2,28,"S40",12,30,"H16",4,1]
[null,null,9,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","１級電気工事施工管理技士","2002-03-11",null,null,"○",null,"1997-04-01",null,1,24,8,"24年 8月","日向","五郎","平成","14",3,11,"S47",5,17,"H19",7,1]
[null,null,10,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","甲種消防設備士","2009-11-20",null,null,"○",null,"1997-04-03",null,2,24,7,"24年 7月","日向","五郎","平成","21",11,20,"S47",5,17,"H19",7,1]
[null,null,11,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","技術士　電気・電子部門","2015-03-11",null,"○","○",null,"1997-04-04",null,1,24,7,"24年 7月","日向","五郎","平成","27",3,11,"S47",5,17,"H19",7,1]
[null,null,12,"林　一郎","2007-04-01","1988-12-05","日向工業高等学校","電気科","第２種電気工事士","2007-09-19",null,null,"○",null,"1997-04-05",null,1,24,7,"24年 7月","林","一郎","平成","19",9,19,"S63",12,5,"H19",4,1]
[null,null,13,"林　一郎","2007-04-01","1988-12-05","日向工業高等学校","電気科","甲種消防設備士　甲－４","2018-10-10",null,null,"○",null,"1997-04-06",null,2,24,7,"24年 7月","林","一郎","平成","30",10,10,"S63",12,5,"H19",4,1]
[null,null,14,"延岡　三郎","2015-04-01","1997-01-20","日向工業高等学校","電気科","１級電気工事施工管理技士補","2021-08-27",null,null,"○",null,"1997-04-07",null,1,24,7,"24年 7月","延岡","三郎","令和","3",8,27,"H9",1,20,"H27",4,1]
[null,null,15,"延岡　三郎","2015-04-01","1997-01-20","日向工業高等学校","電気科","甲種消防設備士　甲－４","2018-10-10",null,null,"○",null,"1997-04-09",null,2,24,7,"24年 7月","延岡","三郎","平成","30",10,10,"H9",1,20,"H27",4,1]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"","","  年  月","","","","","","","","","","","",""]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","",""]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","","",{"$f":"IF(J45=\"\",\"\",TEXT(J45,\"ggg\"))","v":""}]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","","",""]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","","",""]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  年  月","","","","","","","","","","","","",""]
[null,null,30,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":7,"n_rows":31,"n_cols":33,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["技術者"]
["技術者　引込位置（引込対象別）データー　"]
[]
[null,"ﾃﾞｰﾀ名称","最大件数","増分","氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任","実務　工事経歴","スタート年月日"]
[1,null,40,2,"B10","C10","D10","D11","E10","E11","H10","J10","K10","L10","J11","K11"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[]
["技術者経歴書　書出位置（市町村別）データー　　"]
[]
[null,null,"最大","増分","氏名","採用","生年月日","学歴","学科","免許","取得年月日","業種","監理","主任","工事経歴","スタート年月日",null,"印刷","経験年","経験月","経験年月","（姓）","（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
[null,"日向市",12,3,"C20",null,null,null,null,"M20",null,null,null,null,"AM20",null,null,null,"AX20","BB20",null,null,null,"X20","AA20","AE20"]
[null,"門川町",20,2,null,"","",null,null,"AC26","","","","","","","","",null,null,"","C26","I26",null,"","","","Q26","U26","Y26","AV26","AZ26","BD26"]
[null,"美郷町"]
[null,"諸塚村",10,2,"B7","","","G7","L7","P7","","","","","AC7","","","",null,null,"","","",null,"V7","Y7"]
[null,"椎葉村",19,1,null,"","","B8","C8","D8","E8","","I8","H8","F8","","","",null,null,"G8","","",null,"",""]
[null,"延岡市"]
[null,"日之影町"]
[null,"高千穂町",10,1,"B9",null,null,"C9","D9","E9","F9",null,null,null,"G9",null,null,null,null,null,"H9"]
[null,"五ヶ瀬町"]
[null,"都農町"]
[null,"川南町",20,1,"B14",null,null,null,null,"J14","F9",null,null,null,"AD14",null,null,null,"AV14","AY14",null,null,null,"S14","U14","X14","AA14"]

{"sheet":"役員","index":8,"n_rows":49,"n_cols":28,"rows_kept":49,"cut":false,"hidden":false,"merged":[[13,5,13,6],[13,8,13,9],[6,8,6,9],[6,5,6,6]]}
["役員",null,null,null,null,null,"操作順序",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,"R3－指名願マスター（工事・技術・役員等）.xlsm"]
[null,null,null,null,null,null,"①画面をクリア",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"元号　R",null,null,"ペイント三州R3-日向市指名願.xlsx"]
[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,"元号　RYY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"元号　令YY"]
["引込元の位置",null,null,null,"引込元",null,null,"シート名",null,null,null,null,null,null,null,null,null,null,null,null,null,"元号　令和YY"]
["ﾃﾞｰﾀ名称③","最大件数","増分","役職","氏名","ふりがな","フリガナ","生年月日","性別","住所"]
[]
[]
[]
[]
[]
["書出先の位置",null,null,null,"書出先","ペイント三州R3-日向市指名願.xlsx",null,"シート名","⑭誓約書兼照会承諾書（役員名簿）"]
["ﾃﾞｰﾀ名称③","最大件数","増分","役職","氏名","ふりがな","フリガナ","生年月日","性別","住所"]
["日向市",10,4,"D29","Y29",null,"L29",null,"BC29",null,null,null,null,null,null,null,null,"AM29","AQ29","AU29","AY29"]
[null,"①書込先のファイル・シートを開いて、①ファイル名取得ボタンをｸﾘｯｸ"]
[null,"②データー内容の加工・修正（数式の修正）"]
[null,"③書込先のデーター開始位置・増分・番地を記入③又は、保存データーから引き込む"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"印刷対象"]
[null,null,null,"役職","氏名","ふりがな","フリガナ","生年月日","性別","住所","号年月日","生号",null,null,null,null,"印刷","生年","生年","月","日","姓","名","姓かな","名かな","姓カナ","名カナ"]
[null,null,1,"代表取締役","宮崎　太郎","みやざき　たろう","ミヤザキ　タロウ","1943-02-26","男","日向市上町二丁目３番地２",{"$f":"IF(H22=\"\",\"\",LEFT(TEXT(H22,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H22,\"ggge\"),3,2),2)&\"年\"&RIGHT(\" \"&MONTH(H22),2)&\"月\"&RIGHT(\" \"&DAY(H22),2)&\"日\")","v":"昭和18年 2月26日"},{"$f":"IF(H22=\"\",\"\",TEXT(H22,\"g\"))","v":"S"},null,null,null,null,1,{"$f":"IF(H22=\"\",\"\",IF($V$1=1,TEXT(H22,\"ｇ\"),IF($V$1=2,TEXT(H22,\"gg\"),IF($V$1=3,TEXT(H22,\"gｇｇ\"),IF($V$1=4,TEXT(H22,\"ge\"),IF($V$1=5,TEXT(H22,\"gｇe\"),LEFT(TEXT(H22,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H22,\"ggge\"),3,2),2)))))))","v":"S18"},{"$f":"IF(H22=\"\",\"\",TEXT(H22,\"e\"))","v":"18"},{"$f":"IF(H22=\"\",\"\",MONTH(H22))","v":2},{"$f":"IF(H22=\"\",\"\",DAY(H22))","v":26},{"$f":"IF(E22=\"\",\"\",LEFT(E22, FIND(\"　\", E22)-1))","v":"宮崎"},{"$f":"IF(E22=\"\",\"\",RIGHT(E22, LEN(E22)-FIND(\"　\", E22)))","v":"太郎"},{"$f":"IF(F22=\"\",\"\",LEFT(F22, FIND(\"　\", F22)-1))","v":"みやざき"},{"$f":"IF(F22=\"\",\"\",RIGHT(F22, LEN(F22)-FIND(\"　\", F22)))","v":"たろう"},{"$f":"IF(G22=\"\",\"\",LEFT(G22, FIND(\"　\", G22)-1))","v":"ミヤザキ"},{"$f":"IF(G22=\"\",\"\",RIGHT(G22, LEN(G22)-FIND(\"　\", G22)))","v":"タロウ"}]
[null,null,2,"取締役","宮崎　花子","みやざき　はなこ","ミヤザキ　ハナコ","1946-11-13","女","日向市上町二丁目３番地２","昭和21年11月13日",{"$f":"IF(H23=\"\",\"\",TEXT(H23,\"g\"))","v":"S"},null,null,null,null,1,"S21","21",{"$f":"IF(H23=\"\",\"\",MONTH(H23))","v":11},{"$f":"IF(H23=\"\",\"\",DAY(H23))","v":13},"宮崎","花子","みやざき","はなこ",{"$f":"IF(G23=\"\",\"\",LEFT(G23, FIND(\"　\", G23)-1))","v":"ミヤザキ"},{"$f":"IF(G23=\"\",\"\",RIGHT(G23, LEN(G23)-FIND(\"　\", G23)))","v":"ハナコ"}]
[null,null,3,"取締役","宮崎　一郎","みやざき　いちろう","ミヤザキ　イチロウ","1965-12-30","男","日向市北町１丁目１０２","昭和40年12月30日","S",null,null,null,null,1,"S40","40",{"$f":"IF(H24=\"\",\"\",MONTH(H24))","v":12},{"$f":"IF(H24=\"\",\"\",DAY(H24))","v":30},{"$f":"IF(E24=\"\",\"\",LEFT(E24, FIND(\"　\", E24)-1))","v":"宮崎"},{"$f":"IF(E24=\"\",\"\",RIGHT(E24, LEN(E24)-FIND(\"　\", E24)))","v":"一郎"},{"$f":"IF(F24=\"\",\"\",LEFT(F24, FIND(\"　\", F24)-1))","v":"みやざき"},{"$f":"IF(F24=\"\",\"\",RIGHT(F24, LEN(F24)-FIND(\"　\", F24)))","v":"いちろう"},"ミヤザキ","イチロウ"]
[null,null,4,"取締役","宮崎　二郎","みやざき　じろう","ミヤザキ　ジロウ","1972-05-17","男","日向市上町二丁目３番地２","昭和47年 5月17日","S",null,null,null,null,1,"S47","47",{"$f":"IF(H25=\"\",\"\",MONTH(H25))","v":5},{"$f":"IF(H25=\"\",\"\",DAY(H25))","v":17},"宮崎","二郎","みやざき","じろう","ミヤザキ","ジロウ"]
[null,null,5,"監査役","宮崎　三郎","みやざき　じろう","ミヤザキ　サブロウ","1989-05-25","男","日向市上町二丁目３番地２","平成 1年 5月25日","H",null,null,null,null,1,{"$f":"IF(H26=\"\",\"\",IF($V$1=1,TEXT(H26,\"ｇ\"),IF($V$1=2,TEXT(H26,\"gg\"),IF($V$1=3,TEXT(H26,\"gｇｇ\"),IF($V$1=4,TEXT(H26,\"ge\"),IF($V$1=5,TEXT(H26,\"gｇe\"),LEFT(TEXT(H26,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H26,\"ggge\"),3,2),2)))))))","v":"H1"},"1",{"$f":"IF(H26=\"\",\"\",MONTH(H26))","v":5},{"$f":"IF(H26=\"\",\"\",DAY(H26))","v":25},"宮崎","三郎","みやざき","じろう","ミヤザキ","サブロウ"]
[null,null,6,"監査役","宮崎　四郎","みやざき　じろう","ミヤザキ　シロウ","1991-05-06","男","日向市上町二丁目３番地３","平成 3年 5月 6日","H",null,null,null,null,1,{"$f":"IF(H27=\"\",\"\",IF($V$1=1,TEXT(H27,\"ｇ\"),IF($V$1=2,TEXT(H27,\"gg\"),IF($V$1=3,TEXT(H27,\"gｇｇ\"),IF($V$1=4,TEXT(H27,\"ge\"),IF($V$1=5,TEXT(H27,\"gｇe\"),LEFT(TEXT(H27,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H27,\"ggge\"),3,2),2)))))))","v":"H3"},"3",5,6,"宮崎","四郎","みやざき","じろう","ミヤザキ","シロウ"]
[null,null,7,null,null,null,null,null,null,null,"","",null,null,null,null,1,{"$f":"IF(H28=\"\",\"\",IF($V$1=1,TEXT(H28,\"ｇ\"),IF($V$1=2,TEXT(H28,\"gg\"),IF($V$1=3,TEXT(H28,\"gｇｇ\"),IF($V$1=4,TEXT(H28,\"ge\"),IF($V$1=5,TEXT(H28,\"gｇe\"),LEFT(TEXT(H28,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H28,\"ggge\"),3,2),2)))))))","v":""},{"$f":"IF(H28=\"\",\"\",TEXT(H28,\"e\"))","v":""},{"$f":"IF(H28=\"\",\"\",MONTH(H28))","v":""},{"$f":"IF(H28=\"\",\"\",DAY(H28))","v":""},{"$f":"IF(E28=\"\",\"\",LEFT(E28, FIND(\"　\", E28)-1))","v":""},{"$f":"IF(E28=\"\",\"\",RIGHT(E28, LEN(E28)-FIND(\"　\", E28)))","v":""},{"$f":"IF(F28=\"\",\"\",LEFT(F28, FIND(\"　\", F28)-1))","v":""},{"$f":"IF(F28=\"\",\"\",RIGHT(F28, LEN(F28)-FIND(\"　\", F28)))","v":""},{"$f":"IF(G28=\"\",\"\",LEFT(G28, FIND(\"　\", G28)-1))","v":""},{"$f":"IF(G28=\"\",\"\",RIGHT(G28, LEN(G28)-FIND(\"　\", G28)))","v":""}]
[null,null,8,null,null,null,null,null,null,null,"","",null,null,null,null,1,"","","","","","","","","","",{"$f":"IF(H29=\"\",\"\",LEFT(TEXT(H29,\"gｇge\"),2)&RIGHT(\" \"&MID(TEXT(H29,\"ggge\"),3,2),2)&\"年\"&RIGHT(\" \"&MONTH(H29),2)&\"月\"&RIGHT(\" \"&DAY(H29),2)&\"日\")","v":""}]
[null,null,9,null,null,null,null,null,null,null,"","",null,null,null,null,null,"","","","","","","","","","",""]
[null,null,10,null,null,null,null,null,null,null,"","",null,null,null,null,null,"","","","","","","","","","",""]
[null,null,11,null,null,null,null,null,null,null,"","",null,null,null,null,null,"","","","","","","","","","",""]
[null,null,12,null,null,null,null,null,null,null,"","",null,null,null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H34=\"\",\"\",TEXT(H34,\"ge\"))","v":""},{"$f":"IF(H34=\"\",\"\",DAY(H34))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J36=\"\",\"\",J36)","v":""},{"$f":"IF(J36=\"\",\"\",MONTH(J36))","v":""},{"$f":"IF(J36=\"\",\"\",TEXT(J36,\"ge\"))","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H45=\"\",\"\",IF($V$1=1,TEXT(H45,\"ｇ\"),IF($V$1=2,TEXT(H45,\"gg\"),IF($V$1=3,TEXT(H45,\"gｇｇ\"),IF($V$1=4,TEXT(H45,\"ge\"),IF($V$1=5,TEXT(H45,\"gｇe\"),LEFT(TEXT(H45,\"gｇge\"),2)&RIGHT(\"　\"&MID(TEXT(H45,\"ggge\"),3,2),2)))))))","v":""}]
[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":9,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["書込データー"]
["役員　引込位置（引込対象別）データー　"]
[]
[null,"ﾃﾞｰﾀ名称","最大件数","増分","役職","氏名","ふりがな","フリガナ","生年月日","性別","住所"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[]
[]
[]
[null,null,"最大件数","増分","役職","氏名","ふりがな","フリガナ","生年月日","性別","住所","号年月日","生号R",null,null,null,null,"印刷","生年","生年","月","日","姓","名","姓かな","名かな","姓カナ","名カナ"]
[null,"日向市",10,4,"D29","Y29",null,"L29",null,"BC29",null,null,null,null,null,null,null,null,"AM29","AQ29","AU29","AY29"]
[null,"日向市業務",18,1,null,"A4",null,"I13","P13","N13"]
[null,"門川町"]
[null,"美郷町"]
[null,"諸塚村"]
[null,"椎葉村"]
[null,"延岡市"]
[null,"日之影町"]
[null,"高千穂町",18,2,"S7","B8",null,"B7","AK7","AW7","BD8"]
[null,"五ヶ瀬町"]
[null,"都農町"]
[null,"川南町",20,1,"B15","E15",null,"C15",null,"L15",null,null,null,null,null,null,null,null,"H15","I15","J15","K15"]
[null,"川南町送付",20,1,null,"B2",null,"A2",null,"G2",null,null,"C2",null,null,null,null,null,null,"D2","E2","F2"]

{"sheet":"汎用","index":10,"n_rows":50,"n_cols":29,"rows_kept":50,"cut":false,"hidden":false,"merged":[[13,5,13,6],[13,8,13,9],[6,5,6,6],[6,8,6,9]]}
["汎用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R3－指名願（工事・技術・役員の転記）.xlsm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20210817115852.xlsx"]
[]
[]
[]
[]
["引込元の位置",null,null,null,"引込元",null,null,"シート名"]
[null,"最大件数","増分",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[]
[]
[]
[]
[]
["書出先の位置",null,null,null,"書出先","20210817115852.xlsx",null,"シート名","⑱技術者雇用状況 "]
[null,"最大件数","増分","氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任",11,12,"スタート年月日","印刷","（姓）","（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
["日向技術雇用",20,2,null,null,null,null,null,"AC27",null,null,null,null,null,null,null,null,"C27","I27",null,null,null,null,"Q27","U27","Y27","AU27","AY27","BC27"]
[]
["基準日"]
["2021-12-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"印刷対象",null,"編集（計算式は保存されません）"]
[null,null,null,"氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任",11,12,"スタート年月日","印刷","（姓）","（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
[null,null,1,"宮崎　太郎","1982-09-01","1943-02-26","九州工業高等学校","電気科","１級電気工事施工管理技士","1993-05-31",null,"○","○",null,null,"1959-04-01",1,{"$f":"IF(D22=\"\",\"\",LEFT(D22, FIND(\"　\", D22)-1))","v":"宮崎"},{"$f":"IF(D22=\"\",\"\",RIGHT(D22, LEN(D22)-FIND(\"　\", D22)))","v":"太郎"},{"$f":"IF(J22=\"\",\"\",TEXT(J22,\"ggg\"))","v":"平成"},{"$f":"IF(J22=\"\",\"\",IF($X$20=1,TEXT(J22,\"ge\"),TEXT(J22,\"e\")))","v":"5"},{"$f":"IF(J22=\"\",\"\",MONTH(J22))","v":5},{"$f":"IF(J22=\"\",\"\",DAY(J22))","v":31},{"$f":"IF(F22=\"\",\"\",IF($AA$20=1,TEXT(F22,\"ge\"),TEXT(F22,\"e\")))","v":"18"},{"$f":"IF(F22=\"\",\"\",MONTH(F22))","v":2},{"$f":"IF(F22=\"\",\"\",DAY(F22))","v":26},{"$f":"IF(E22=\"\",\"\",IF($AD$20=1,TEXT(E22,\"ge\"),TEXT(E22,\"e\")))","v":"57"},{"$f":"IF(E22=\"\",\"\",MONTH(E22))","v":9},{"$f":"IF(E22=\"\",\"\",DAY(E22))","v":1}]
[null,null,2,"宮崎　太郎","1982-09-01","1943-02-26","九州工業高等学校","電気科","甲種消防設備士","1966-10-31",null,null,"○",null,null,"1966-10-31",2,{"$f":"IF(D23=\"\",\"\",LEFT(D23, FIND(\"　\", D23)-1))","v":"宮崎"},{"$f":"IF(D23=\"\",\"\",RIGHT(D23, LEN(D23)-FIND(\"　\", D23)))","v":"太郎"},{"$f":"IF(J23=\"\",\"\",TEXT(J23,\"ggg\"))","v":"昭和"},{"$f":"IF(J23=\"\",\"\",IF($X$20=1,TEXT(J23,\"ge\"),TEXT(J23,\"e\")))","v":"41"},{"$f":"IF(J23=\"\",\"\",MONTH(J23))","v":10},{"$f":"IF(J23=\"\",\"\",DAY(J23))","v":31},{"$f":"IF(F23=\"\",\"\",IF($AA$20=1,TEXT(F23,\"ge\"),TEXT(F23,\"e\")))","v":"18"},{"$f":"IF(F23=\"\",\"\",MONTH(F23))","v":2},{"$f":"IF(F23=\"\",\"\",DAY(F23))","v":26},{"$f":"IF(E23=\"\",\"\",IF($AD$20=1,TEXT(E23,\"ge\"),TEXT(E23,\"e\")))","v":"57"},{"$f":"IF(E23=\"\",\"\",MONTH(E23))","v":9},{"$f":"IF(E23=\"\",\"\",DAY(E23))","v":1}]
[null,null,3,"宮崎　一郎","1995-04-01","1976-07-14","日向工業高等学校","電気科","２級電気工事施工管理技士","2012-03-09",null,null,"○",null,null,"1995-04-01",1,"宮崎","一郎","平成","24",3,9,"51",7,14,"7",4,1]
[null,null,4,"宮崎　一郎","1995-04-01","1976-04-25","日向工業高等学校","電気科","１級電気工事施工管理技士","2009-03-10",null,"○","○",null,null,"1995-04-01",1,"宮崎","一郎","平成","21",3,10,"51",4,25,"7",4,1]
[null,null,5,"日向　学","1998-04-01","1979-05-08","日向工業高等学校","電気科","第２種電気工事士","1996-10-21",null,null,"○",null,null,"1998-04-01",1,"日向","学","平成","8",10,21,"54",5,8,"10",4,1]
[null,null,6,"日向　四郎","2004-04-01","1965-12-30","日向工業高等学校","電気科","１級電気工事施工管理技士","1997-02-28",null,"○","○",null,null,"1984-04-01",1,"日向","四郎","平成","9",2,28,"40",12,30,"16",4,1]
[null,null,7,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","１級電気工事施工管理技士","2002-03-11",null,null,"○",null,null,"1997-04-01",null,"日向","五郎","平成","14",3,11,"47",5,17,"19",7,1]
[null,null,8,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","甲種消防設備士","2009-11-20",null,null,"○",null,null,"1997-04-03",2,"日向","五郎","平成","21",11,20,"47",5,17,"19",7,1]
[null,null,9,"日向　五郎","2007-07-01","1972-05-17","九州工業大学大学院","情報工学科","技術士　電気・電子部門","2015-03-11",null,"○","○",null,null,"1997-04-04",1,"日向","五郎","平成","27",3,11,"47",5,17,"19",7,1]
[null,null,10,"林　一郎","2007-04-01","1988-12-05","日向工業高等学校","電気科","第２種電気工事士","2007-09-19",null,null,"○",null,null,"1997-04-05",1,"林","一郎","平成","19",9,19,"63",12,5,"19",4,1]
[null,null,11,"林　一郎","2007-04-01","1988-12-05","日向工業高等学校","電気科","甲種消防設備士　甲－４","2018-10-10",null,null,"○",null,null,"1997-04-06",2,"林","一郎","平成","30",10,10,"63",12,5,"19",4,1]
[null,null,12,"延岡　三郎","2015-04-01","1997-01-20","日向工業高等学校","電気科","１級電気工事施工管理技士補","2021-08-27",null,null,"○",null,null,"1997-04-07",1,"延岡","三郎","令和","3",8,27,"9",1,20,"27",4,1]
[null,null,null,"延岡　三郎","2015-04-01","1997-01-20","日向工業高等学校","電気科","甲種消防設備士　甲－４","2018-10-10",null,null,"○",null,null,"1997-04-09",2,"延岡","三郎","平成","30",10,10,"9",1,20,"27",4,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(J36=\"\",\"\",TEXT(J36,\"ggg\"))","v":""},{"$f":"IF(J36=\"\",\"\",IF($X$20=1,TEXT(J36,\"ge\"),TEXT(J36,\"e\")))","v":""},{"$f":"IF(J36=\"\",\"\",MONTH(J36))","v":""},{"$f":"IF(J36=\"\",\"\",DAY(J36))","v":""},{"$f":"IF(F36=\"\",\"\",IF($AA$20=1,TEXT(F36,\"ge\"),TEXT(F36,\"e\")))","v":""},{"$f":"IF(F36=\"\",\"\",MONTH(F36))","v":""},{"$f":"IF(F36=\"\",\"\",DAY(F36))","v":""},{"$f":"IF(E36=\"\",\"\",IF($AD$20=1,TEXT(E36,\"ge\"),TEXT(E36,\"e\")))","v":""},{"$f":"IF(E36=\"\",\"\",MONTH(E36))","v":""},{"$f":"IF(E36=\"\",\"\",DAY(E36))","v":""}]
[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,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,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":"汎用 (2)","index":11,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,5,6,6],[6,8,6,9],[13,5,13,6],[13,8,13,9]]}
["汎用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R3－指名願（工事・技術・役員の転記）.xlsm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Book1"]
[]
[]
[]
[]
["引込元の位置",null,null,null,"引込元",null,null,"シート名"]
[null,"最大件数","増分",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[]
[]
[]
[]
[]
["書出先の位置",null,null,null,"書出先",null,null,"シート名"]
[null,"最大件数","増分"]
["日向技術雇用",20,2]
[]
["基準日"]
["2021-12-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"印刷対象",null,"編集（計算式は保存されません）"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,"印刷"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"汎用倉庫","index":12,"n_rows":38,"n_cols":32,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["書込データー"]
[]
["汎用　引込位置（引込対象別）データー　"]
[]
[1]
[1]
[2]
[2]
[3]
[3]
[4]
[4]
[5]
[5]
[6]
[6]
[7]
[7]
[]
[null,"書出データー","最大件数","増分",1,2,5,6,7,8,9,10,11,12,13,14,15,"印刷",17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[1,null,null,null,"氏名","入社年月日","生年月日","最終学歴","専攻学科","免許","取得年月日","コード","監理","主任",11,12,"スタート年月日","印刷","（姓）","（名）","取得号","取得年","取得月","取得日","生年","月","日","採年","月","日"]
[1,"日向技術雇用",20,2,null,null,null,null,null,"AC27",null,null,null,null,null,null,null,null,"C27","I27",null,null,null,null,"Q27","U27","Y27","AU27","AY27","BC27"]
[2]
[2]
[3]
[3]
[4]
[4]
[5]
[5]
[6]
[6]
[7]
[7]
[8]
[8]
[9]
[9]

{"sheet":"作業","index":13,"n_rows":31,"n_cols":46,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["ワークエリア　　工事業経歴",null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,null,null,10,{"$f":"IF(AE3=0,\"\",MID(AE3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AE3)&1234567890)),3))","v":"16"},null,{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},null,null,null,null,null,null,{"$f":"AS2&AT2&AS3&AT3","v":"3331"},{"$f":"TODAY()","v":"2022-01-07"}]
["引込（工事）","最大件数","増分","発注者","元・下","工事名","工事名２","都道府県","市町村","請負金額","着工年","着工月","着工日","完成年","完成月","完成日","主任",null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(AE3=\"\",\"\",COLUMN(INDIRECT(AE3&\"1\")))","v":52},null,null,null,null,null,null,null,null,"tera","tera",{"$f":"RIGHT(0&MONTH(AP3),2)","v":"01"},{"$f":"LEFT(AP2,1)+1","v":1},{"$f":"RIGHT(AP2,1)","v":"1"},{"$f":"RIGHT(AP4,1)","v":"3"},{"$f":"RIGHT(AQ4,1)","v":"3"}]
["縦",{"$f":"B6","v":40},{"$f":"C6","v":2},{"$f":"IF(D6=0,\"\",MID(D6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(D6)&1234567890)),3))","v":"10"},{"$f":"IF(E6=0,\"\",MID(E6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E6)&1234567890)),3))","v":"10"},{"$f":"IF(F6=0,\"\",MID(F6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(F6)&1234567890)),3))","v":"10"},{"$f":"IF(G6=0,\"\",MID(G6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(G6)&1234567890)),3))","v":"11"},{"$f":"IF(H6=0,\"\",MID(H6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(H6)&1234567890)),3))","v":"10"},{"$f":"IF(I6=0,\"\",MID(I6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I6)&1234567890)),3))","v":"11"},{"$f":"IF(J6=0,\"\",MID(J6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(J6)&1234567890)),3))","v":"10"},{"$f":"IF(K6=0,\"\",MID(K6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(K6)&1234567890)),3))","v":"10"},{"$f":"IF(L6=0,\"\",MID(L6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(L6)&1234567890)),3))","v":"10"},{"$f":"IF(M6=0,\"\",MID(M6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(M6)&1234567890)),3))","v":"10"},{"$f":"IF(N6=0,\"\",MID(N6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(N6)&1234567890)),3))","v":"11"},{"$f":"IF(O6=0,\"\",MID(O6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(O6)&1234567890)),3))","v":"11"},{"$f":"IF(P6=0,\"\",MID(P6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(P6)&1234567890)),3))","v":"11"},{"$f":"IF(Q6=0,\"\",MID(Q6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Q6)&1234567890)),3))","v":"10"},{"$f":"IF(R6=0,\"\",MID(R6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(R6)&1234567890)),3))","v":""},{"$f":"IF(S6=0,\"\",MID(S6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(S6)&1234567890)),3))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ADDRESS(AD1,AD2,4)","v":"D10"},"AZ16",null,null,null,null,null,null,null,null,"2022-01-07","2022-01-07",{"$f":"RIGHT(0&DAY(AQ1),2)","v":"07"},{"$f":"LEFT(AP3,1)+1","v":1},{"$f":"RIGHT(AP3,1)","v":"7"},{"$f":"RIGHT(AP5,1)","v":"3"},{"$f":"RIGHT(AQ5,1)","v":"1"}]
["横",null,null,{"$f":"IF(D6=\"\",\"\",COLUMN(INDIRECT(D6&\"1\")))","v":2},{"$f":"IF(E6=\"\",\"\",COLUMN(INDIRECT(E6&\"1\")))","v":3},{"$f":"IF(F6=\"\",\"\",COLUMN(INDIRECT(F6&\"1\")))","v":4},{"$f":"IF(G6=\"\",\"\",COLUMN(INDIRECT(G6&\"1\")))","v":4},{"$f":"IF(H6=\"\",\"\",COLUMN(INDIRECT(H6&\"1\")))","v":5},5,8,10,11,12,10,11,12,{"$f":"IF(Q6=\"\",\"\",COLUMN(INDIRECT(Q6&\"1\")))","v":7},{"$f":"IF(R6=\"\",\"\",COLUMN(INDIRECT(R6&\"1\")))","v":""},"",null,null,null,null,null,null,null,null,null,null,"修正禁止",null,null,null,null,null,null,null,null,null,{"$f":"IF(AN2=AO2,0,AO3-AN3)","v":0},null,{"$f":"AQ2*3","v":3},{"$f":"AR2*3","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ3*3","v":3},{"$f":"AR3*3","v":21}]
[null,40,2,"B10","C10","D10","D11","E10","E11","H10","J10","K10","L10","J11","K11","L11","G10"]
[null,null,null,null,null,null,2,null,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑　このエリアの計算式は修正禁止です"]
[null,null,null,null,null,"２行の場合１行に結合",null,null,null,null,"「RYY.MM.DD」の場合着工年のみに記入（月日は削除）"]
[]
["引込その他"]
["引込","最大件数","増分",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["縦",{"$f":"B15","v":30},{"$f":"C15","v":1},{"$f":"IF(D15=0,\"\",MID(D15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(D15)&1234567890)),3))","v":"4"},{"$f":"IF(E15=0,\"\",MID(E15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E15)&1234567890)),3))","v":"4"},{"$f":"IF(F15=0,\"\",MID(F15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(F15)&1234567890)),3))","v":"4"},{"$f":"IF(G15=0,\"\",MID(G15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(G15)&1234567890)),3))","v":"4"},{"$f":"IF(H15=0,\"\",MID(H15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(H15)&1234567890)),3))","v":"4"},{"$f":"IF(I15=0,\"\",MID(I15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I15)&1234567890)),3))","v":"4"},{"$f":"IF(J15=0,\"\",MID(J15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(J15)&1234567890)),3))","v":"4"},{"$f":"IF(K15=0,\"\",MID(K15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(K15)&1234567890)),3))","v":""},{"$f":"IF(L15=0,\"\",MID(L15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(L15)&1234567890)),3))","v":"4"},{"$f":"IF(M15=0,\"\",MID(M15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(M15)&1234567890)),3))","v":"4"},{"$f":"IF(N15=0,\"\",MID(N15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(N15)&1234567890)),3))","v":""},{"$f":"IF(O15=0,\"\",MID(O15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(O15)&1234567890)),3))","v":"4"},{"$f":"IF(P15=0,\"\",MID(P15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(P15)&1234567890)),3))","v":""},{"$f":"IF(Q15=0,\"\",MID(Q15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Q15)&1234567890)),3))","v":""},{"$f":"IF(R15=0,\"\",MID(R15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(R15)&1234567890)),3))","v":""},{"$f":"IF(S15=0,\"\",MID(S15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(S15)&1234567890)),3))","v":""},{"$f":"IF(T15=0,\"\",MID(T15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(T15)&1234567890)),3))","v":""},{"$f":"IF(U15=0,\"\",MID(U15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(U15)&1234567890)),3))","v":""},{"$f":"IF(V15=0,\"\",MID(V15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(V15)&1234567890)),3))","v":""},{"$f":"IF(W15=0,\"\",MID(W15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(W15)&1234567890)),3))","v":""},{"$f":"IF(X15=0,\"\",MID(X15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(X15)&1234567890)),3))","v":""},{"$f":"IF(Y15=0,\"\",MID(Y15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Y15)&1234567890)),3))","v":""},{"$f":"IF(Z15=0,\"\",MID(Z15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Z15)&1234567890)),3))","v":""},{"$f":"IF(AA15=0,\"\",MID(AA15,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AA15)&1234567890)),3))","v":""}]
["横",null,null,{"$f":"IF(D15=\"\",\"\",COLUMN(INDIRECT(D15&\"1\")))","v":3},{"$f":"IF(E15=\"\",\"\",COLUMN(INDIRECT(E15&\"1\")))","v":4},5,6,7,8,9,"",11,12,"",14,"","","","","","","","","","","",""]
[]
[null,30,1,"C4","D4","E4","F4","G4","H4","I4",null,"K4","L4",null,"N4"]
[]
[]
[]
["書出（工事）","最大件数","増分","発注者","元・下","工事名","都道府県","市町村","請負金額","着工年月日",null,null,"完成年月日",null,null,"技術者","転記","ソートキー","請負金額","着年号","完年号","着工年月","完成年月",21,22,23,24]
["縦",{"$f":"B23","v":10},{"$f":"C23","v":4},{"$f":"IF(D23=0,\"\",MID(D23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(D23)&1234567890)),3))","v":"20"},{"$f":"IF(E23=0,\"\",MID(E23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E23)&1234567890)),3))","v":"20"},{"$f":"IF(F23=0,\"\",MID(F23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(F23)&1234567890)),3))","v":"20"},{"$f":"IF(G23=0,\"\",MID(G23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(G23)&1234567890)),3))","v":"20"},{"$f":"IF(H23=0,\"\",MID(H23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(H23)&1234567890)),3))","v":""},{"$f":"IF(I23=0,\"\",MID(I23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I23)&1234567890)),3))","v":""},{"$f":"IF(J23=0,\"\",MID(J23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(J23)&1234567890)),3))","v":"20"},{"$f":"IF(K23=0,\"\",MID(K23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(K23)&1234567890)),3))","v":"20"},{"$f":"IF(L23=0,\"\",MID(L23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(L23)&1234567890)),3))","v":"20"},{"$f":"IF(M23=0,\"\",MID(M23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(M23)&1234567890)),3))","v":"22"},{"$f":"IF(N23=0,\"\",MID(N23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(N23)&1234567890)),3))","v":"22"},{"$f":"IF(O23=0,\"\",MID(O23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(O23)&1234567890)),3))","v":"22"},{"$f":"IF(P23=0,\"\",MID(P23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(P23)&1234567890)),3))","v":""},{"$f":"IF(Q23=0,\"\",MID(Q23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Q23)&1234567890)),3))","v":""},{"$f":"IF(R23=0,\"\",MID(R23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(R23)&1234567890)),3))","v":""},{"$f":"IF(S23=0,\"\",MID(S23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(S23)&1234567890)),3))","v":"20"},{"$f":"IF(T23=0,\"\",MID(T23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(T23)&1234567890)),3))","v":""},{"$f":"IF(U23=0,\"\",MID(U23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(U23)&1234567890)),3))","v":""},{"$f":"IF(V23=0,\"\",MID(V23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(V23)&1234567890)),3))","v":""},{"$f":"IF(W23=0,\"\",MID(W23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(W23)&1234567890)),3))","v":""},{"$f":"IF(X23=0,\"\",MID(X23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(X23)&1234567890)),3))","v":""},{"$f":"IF(Y23=0,\"\",MID(Y23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Y23)&1234567890)),3))","v":""},{"$f":"IF(Z23=0,\"\",MID(Z23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Z23)&1234567890)),3))","v":""},{"$f":"IF(AA23=0,\"\",MID(AA23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AA23)&1234567890)),3))","v":""}]
["横",null,null,{"$f":"IF(D23=\"\",\"\",COLUMN(INDIRECT(D23&\"1\")))","v":1},{"$f":"IF(E23=\"\",\"\",COLUMN(INDIRECT(E23&\"1\")))","v":13},16,32,"","",{"$f":"IF(J23=\"\",\"\",COLUMN(INDIRECT(J23&\"1\")))","v":47},{"$f":"IF(K23=\"\",\"\",COLUMN(INDIRECT(K23&\"1\")))","v":50},53,47,50,53,"","","",37,"","","","","","","",""]
[]
["日向市",10,4,"A20","M20","P20","AF20",null,null,"AU20","AX20","BA20","AU22","AX22","BA22",null,null,null,"AK20"]
[]
[]
[]
["書出その他","最大件数","増分",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["縦",{"$f":"B31","v":10},{"$f":"C31","v":4},{"$f":"IF(D31=0,\"\",MID(D31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(D31)&1234567890)),3))","v":"29"},{"$f":"IF(E31=0,\"\",MID(E31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(E31)&1234567890)),3))","v":"29"},{"$f":"IF(F31=0,\"\",MID(F31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(F31)&1234567890)),3))","v":""},{"$f":"IF(G31=0,\"\",MID(G31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(G31)&1234567890)),3))","v":"29"},{"$f":"IF(H31=0,\"\",MID(H31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(H31)&1234567890)),3))","v":""},{"$f":"IF(I31=0,\"\",MID(I31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(I31)&1234567890)),3))","v":"29"},{"$f":"IF(J31=0,\"\",MID(J31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(J31)&1234567890)),3))","v":""},{"$f":"IF(K31=0,\"\",MID(K31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(K31)&1234567890)),3))","v":""},{"$f":"IF(L31=0,\"\",MID(L31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(L31)&1234567890)),3))","v":""},{"$f":"IF(M31=0,\"\",MID(M31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(M31)&1234567890)),3))","v":""},{"$f":"IF(N31=0,\"\",MID(N31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(N31)&1234567890)),3))","v":""},{"$f":"IF(O31=0,\"\",MID(O31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(O31)&1234567890)),3))","v":""},{"$f":"IF(P31=0,\"\",MID(P31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(P31)&1234567890)),3))","v":""},{"$f":"IF(Q31=0,\"\",MID(Q31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Q31)&1234567890)),3))","v":""},{"$f":"IF(R31=0,\"\",MID(R31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(R31)&1234567890)),3))","v":"29"},{"$f":"IF(S31=0,\"\",MID(S31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(S31)&1234567890)),3))","v":"29"},{"$f":"IF(T31=0,\"\",MID(T31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(T31)&1234567890)),3))","v":"29"},{"$f":"IF(U31=0,\"\",MID(U31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(U31)&1234567890)),3))","v":"29"},{"$f":"IF(V31=0,\"\",MID(V31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(V31)&1234567890)),3))","v":""},{"$f":"IF(W31=0,\"\",MID(W31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(W31)&1234567890)),3))","v":""},{"$f":"IF(X31=0,\"\",MID(X31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(X31)&1234567890)),3))","v":""},{"$f":"IF(Y31=0,\"\",MID(Y31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Y31)&1234567890)),3))","v":""},{"$f":"IF(Z31=0,\"\",MID(Z31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(Z31)&1234567890)),3))","v":""},{"$f":"IF(AA31=0,\"\",MID(AA31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AA31)&1234567890)),3))","v":""},{"$f":"IF(AB31=0,\"\",MID(AB31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AB31)&1234567890)),3))","v":""},{"$f":"IF(AC31=0,\"\",MID(AC31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AC31)&1234567890)),3))","v":""},{"$f":"IF(AD31=0,\"\",MID(AD31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AD31)&1234567890)),3))","v":""},{"$f":"IF(AE31=0,\"\",MID(AE31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AE31)&1234567890)),3))","v":""},{"$f":"IF(AF31=0,\"\",MID(AF31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AF31)&1234567890)),3))","v":""},{"$f":"IF(AG31=0,\"\",MID(AG31,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(AG31)&1234567890)),3))","v":""}]
["横","選別",0,{"$f":"IF(D31=\"\",\"\",COLUMN(INDIRECT(D31&\"1\")))","v":4},{"$f":"IF(E31=\"\",\"\",COLUMN(INDIRECT(E31&\"1\")))","v":25},"",12,"",55,"","","","","","","","",39,43,47,51,"","","","","","",{"$f":"IF(AB31=\"\",\"\",COLUMN(INDIRECT(AB31&\"1\")))","v":""},"","","","",""]
[]
[null,10,4,"D29","Y29",null,"L29",null,"BC29",null,null,null,null,null,null,null,null,"AM29","AQ29","AU29","AY29"]