{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["マニュアル","取込","実態調査対応表","設定"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":2,"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":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"マニュアル"]
[null,"Ⅰ","取込シート"]
[null,null,1,"データ取り込み"]
[null,null,null,"「ファイル指定」ボタンを押して旧フォーマットのファイルを指定します。"]
[null,null,null,"経費、処理、災害それぞれの「ファイル指定」ボタンを実行します。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,2,"データ抜き出し"]
[null,null,null,"「データ抜き出し」ボタンを押して旧フォーマットのファイルを実態調査対応表シートに転記します。"]
[null,null,null,"経費、処理、災害それぞれの「データ抜き出し」ボタンを実行します。"]
[null,null,null,"「データ抜き出し」ボタンを押す前に参照する旧フォーマットを閉じていることを確認してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,3,"データ転記"]
[null,null,null,"「ファイル指定」ボタンを押して新支援ツールのファイルを指定します。"]
[null,null,null,"「データ抜き出し」ボタンを押して実態調査対応表シートのデータを新支援ツールに転記します。"]
[]
[]
[]
[]
[null,null,4,"データクリア"]
[null,null,null,"「データクリア」ボタンを押して実態調査対応表シートの値データ（I列）を削除します。"]
[]
[]
[]
[]
[null,"Ⅱ","実態調査対応表シート"]
[null,null,null,"2データ抜き出しを行うことで値に入力されます。"]
[null,null,null,"入力される値は実態調査の表、列、行のデータになります。"]

{"sheet":"取込","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"■データ取込"]
[null,null,"フォルダ","ファイル"]
[null,"施設"]
[null,"経費","C:\\○○\\取込ファイル\\","2018経費XXXX.xlsm"]
[null,"処理","C:\\○○\\取込ファイル\\","2018処理XXXX.xlsm"]
[null,"災害","C:\\○○\\取込ファイル\\","2018災害処理XXXX.xlsm"]
[null,"■データ転記"]
[null,"新支援ツール","\\\\jposa2601\\Client_OSA\\119165-56\\R2年度\\30_会計基準検討\\ツール（香月さん）\\■テスト用マクロ格納\\テスト\\","★⑥資料3_【暫定版】（簡易版）新支援ツール 20210226（十勝）.xlsx"]
[null,"■データクリア"]
[null,"　　実態調査対応表の値クリア"]

{"sheet":"実態調査対応表","index":2,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[31,1,31,4],[41,2,41,4],[42,1,42,4],[43,1,43,4],[35,1,41,1],[54,1,54,4],[50,1,53,2],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[44,1,44,4],[38,2,38,4],[40,2,40,4],[39,2,39,4],[1,5,1,7],[25,2,25,4],[27,1,27,4],[29,1,29,4],[30,1,30,4],[26,2,26,4],[13,1,26,1],[28,1,28,4],[20,2,20,4],[13,2,16,2],[13,3,13,4],[14,3,16,3],[1,8,1,10],[2,1,2,4],[3,1,3,4],[12,2,12,4],[7,1,12,1],[5,5,5,7],[5,8,5,10],[6,1,6,4],[7,2,10,2],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,2,11,4],[46,5,46,7],[46,8,46,10],[47,1,47,4],[48,1,49,2],[48,3,48,4],[49,3,49,4],[33,8,33,10],[34,1,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[33,5,33,7],[17,2,19,2],[17,3,17,4],[18,3,18,4],[19,3,19,4],[21,2,24,2],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4]]}
[]
[null,"【基礎情報】",null,null,null,"実態調査",null,null,"【簡易版】新支援ツール"]
[null,"項目",null,null,null,"表","列","行","シート","セル","値"]
[null,"構成市区町村数",null,null,null,"62","01",null,"1.基礎情報（事務組合用）","F6"]
[]
[null,"【歳出】",null,null,null,"実態調査",null,null,"新支援ツール"]
[null,null,null,null,null,"表","列","行","シート","セル","値"]
[null,"建設・改良費","工事費","収集運搬施設",null,72,"01","01","入力チェック","H16"]
[null,null,null,"中間処理施設",null,72,"01","02","入力チェック","H17"]
[null,null,null,"最終処分場",null,72,"01","03","入力チェック","H18"]
[null,null,null,"その他",null,72,"01","04","入力チェック","H19"]
[null,null,"調査費",null,null,72,"01","05","入力チェック","H20"]
[null,null,"小計",null,null,72,"01","06","入力チェック","H22"]
[null,"処理及び維持管理費","人件費","一般職",null,72,"01","07","入力チェック","H23"]
[null,null,null,"技能職","収集運搬",72,"01","08","入力チェック","H24"]
[null,null,null,null,"中間処理",72,"01","09","入力チェック","H25"]
[null,null,null,null,"最終処分",72,"01","10","入力チェック","H26"]
[null,null,"処理費","収集運搬費",null,72,"01","11","入力チェック","H27"]
[null,null,null,"中間処理費",null,72,"01","12","入力チェック","H28"]
[null,null,null,"最終処分費",null,72,"01","13","入力チェック","H29"]
[null,null,"車両等購入費",null,null,72,"01","14","入力チェック","H30"]
[null,null,"委託費","収集運搬費",null,72,"01","15","入力チェック","H31"]
[null,null,null,"中間処理費",null,72,"01","16","入力チェック","H32"]
[null,null,null,"最終処分費",null,72,"01","17","入力チェック","H33"]
[null,null,null,"その他",null,72,"01","18","入力チェック","H34"]
[null,null,"調査研究費",null,null,72,"01","19","入力チェック","H36"]
[null,null,"小計",null,null,34,"01","20","入力チェック","H37"]
[null,"その他",null,null,null,72,"01","21","入力チェック","H38"]
[null,"合計",null,null,null,34,"01","22","入力チェック","H39"]
[null,"災害廃棄物処理に係る歳出（処理及維持管理費）",null,null,null,"72A","01",20]
[null,"災害廃棄物処理に係る歳出（その他）",null,null,null,"72A","01",21]
[null,"小計",null,null,null,null,null,null,"5.その他費用・収益","D54",{"$f":"K30+K31","v":0}]
[]
[null,"【歳入】",null,null,null,"実態調査",null,null,"新支援ツール"]
[null,null,null,null,null,"表","列","行","シート","セル","値"]
[null,"特定財源","国庫支出金",null,null,71,"01","01","入力チェック","H54"]
[null,null,"都道府県支出金",null,null,71,"01","02","入力チェック","H55"]
[null,null,"地方債",null,null,71,"01","03","入力チェック","H56"]
[null,null,"使用料及び手数料",null,null,71,"01","04","入力チェック","H57"]
[null,null,"市町村分担金",null,null,71,"01","05","入力チェック","H58"]
[null,null,"その他",null,null,71,"01","06","入力チェック","H59"]
[null,null,"小計",null,null,71,"01","07","入力チェック","H60"]
[null,"一般財源",null,null,null,71,"01","08","入力チェック","H61"]
[null,"合計",null,null,null,71,"01","09","入力チェック","H62"]
[null,"災害廃棄物処理に係る歳入",null,null,null,"71A","01","07","5.その他費用・収益","D93"]
[]
[null,"【従事職員】",null,null,null,"実態調査",null,null,"新支援ツール"]
[null,null,null,null,null,"表","列","行","シート","セル","値"]
[null,"一般職",null,"事務系",null,64,"01","01","入力チェック","H73"]
[null,null,null,"技術系",null,64,"01","02","入力チェック","H74"]
[null,"技能職",null,"収集運搬",null,64,"01","03","入力チェック","H75"]
[null,null,null,"中間処理",null,64,"01","04","入力チェック","H76"]
[null,null,null,"最終処分",null,64,"01","05","入力チェック","H77"]
[null,null,null,"その他",null,64,"01","06","入力チェック","H78"]
[null,"合計",null,null,null,64,"01","07","入力チェック","H79"]

{"sheet":"設定","index":3,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":true,"merged":[[41,1,41,4],[42,1,42,4],[53,1,53,4],[20,2,20,4],[26,2,26,4],[13,1,26,1],[28,1,28,4],[40,2,40,4],[36,2,36,4],[37,2,37,4],[39,2,39,4],[38,2,38,4],[25,2,25,4],[27,1,27,4],[29,1,29,4],[30,1,30,4],[3,1,3,4],[6,1,6,4],[49,1,52,2],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[43,1,43,4],[46,1,46,4],[47,1,48,2],[47,3,47,4],[48,3,48,4],[34,1,39,1],[34,2,34,4],[35,2,35,4],[12,2,12,4],[33,1,33,4],[0,5,1,5],[0,6,0,8],[2,1,2,4],[13,2,16,2],[13,3,13,4],[14,3,16,3],[17,2,19,2],[17,3,17,4],[18,3,18,4],[19,3,19,4],[21,2,24,2],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[7,1,11,1],[7,2,10,2],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,2,11,4]]}
["【実態調査対応表と同じに行に項目を入れてください】",null,null,null,null,"実態調査対応表","データ取り込み"]
["No","【基礎情報】",null,null,null,null,"ファイル","シート","セル"]
[null,"項目"]
[{"$f":"MAX($A$2:$A3)+1","v":1},"構成市区町村数",null,null,null,{"$f":"\"K\"&ROW()","v":"K4"},"処理","62、63表","C5"]
[]
[null,"【歳出】",null,null,null,null,null,null,null,null,null,"開始行","終了行"]
[null,"項目",null,null,null,null,null,null,null,null,"基本情報",4,4]
[{"$f":"MAX($A$3:$A4)+1","v":2},"建設・改良費","工事費","収集運搬施設",null,{"$f":"\"K\"&ROW()","v":"K8"},"経費","72表","G6",null,"歳出",8,31]
[{"$f":"MAX($A$2:$A8)+1","v":3},null,null,"中間処理施設",null,"K9","経費","72表","G7",null,"歳入",36,45]
[{"$f":"MAX($A$2:$A9)+1","v":4},null,null,"最終処分場",null,"K10","経費","72表","G8",null,"従事職員",49,55]
[{"$f":"MAX($A$2:$A10)+1","v":5},null,null,"その他",null,"K11","経費","72表","G9",null,"その他"]
[{"$f":"MAX($A$2:$A11)+1","v":6},null,"調査費",null,null,"K12","経費","72表","G10"]
[{"$f":"MAX($A$2:$A12)+1","v":7},null,"小計",null,null,"K13","経費","72表","G11"]
[{"$f":"MAX($A$2:$A13)+1","v":8},"処理及び維持管理費","人件費","一般職",null,{"$f":"\"K\"&ROW()","v":"K14"},"経費","72表","G12"]
[{"$f":"MAX($A$2:$A14)+1","v":9},null,null,"技能職","収集運搬",{"$f":"\"K\"&ROW()","v":"K15"},"経費","72表","G13"]
[{"$f":"MAX($A$2:$A15)+1","v":10},null,null,null,"中間処理","K16","経費","72表","G14"]
[{"$f":"MAX($A$2:$A16)+1","v":11},null,null,null,"最終処分","K17","経費","72表","G15"]
[{"$f":"MAX($A$2:$A17)+1","v":12},null,"処理費","収集運搬費",null,"K18","経費","72表","G16"]
[{"$f":"MAX($A$2:$A18)+1","v":13},null,null,"中間処理費",null,"K19","経費","72表","G17"]
[{"$f":"MAX($A$2:$A19)+1","v":14},null,null,"最終処分費",null,"K20","経費","72表","G18"]
[{"$f":"MAX($A$2:$A20)+1","v":15},null,"車両等購入費",null,null,"K21","経費","72表","G19"]
[{"$f":"MAX($A$2:$A21)+1","v":16},null,"委託費","収集運搬費",null,"K22","経費","72表","G20"]
[{"$f":"MAX($A$2:$A22)+1","v":17},null,null,"中間処理費",null,"K23","経費","72表","G21"]
[{"$f":"MAX($A$2:$A23)+1","v":18},null,null,"最終処分費",null,"K24","経費","72表","G22"]
[{"$f":"MAX($A$2:$A24)+1","v":19},null,null,"その他",null,"K25","経費","72表","G23"]
[{"$f":"MAX($A$2:$A25)+1","v":20},null,"調査研究費",null,null,"K26","経費","72表","G24"]
[{"$f":"MAX($A$2:$A26)+1","v":21},null,"小計",null,null,"K27","経費","72表","G25"]
[{"$f":"MAX($A$2:$A27)+1","v":22},"その他",null,null,null,"K28","経費","72表","G26"]
[{"$f":"MAX($A$2:$A28)+1","v":23},"合計",null,null,null,"K29","経費","72表","G27"]
[{"$f":"MAX($A$2:$A29)+1","v":24},"災害廃棄物処理に係る歳出（処理及維持管理費）",null,null,null,"K30","災害","72A表","G25"]
[{"$f":"MAX($A$2:$A30)+1","v":25},"災害廃棄物処理に係る歳出（その他）",null,null,null,"K31","災害","72A表","G26"]
[]
[null,"【歳入】"]
[]
[{"$f":"MAX($A$2:$A34)+1","v":26},"特定財源","国庫支出金",null,null,{"$f":"\"K\"&ROW()+1","v":"K36"},"経費","71表","E7"]
[{"$f":"MAX($A$2:$A35)+1","v":27},null,"都道府県支出金",null,null,{"$f":"\"K\"&ROW()+1","v":"K37"},"経費","71表","E8"]
[{"$f":"MAX($A$2:$A36)+1","v":28},null,"地方債",null,null,"K38","経費","71表","E9"]
[{"$f":"MAX($A$2:$A37)+1","v":29},null,"使用料及び手数料",null,null,"K39","経費","71表","E10"]
[{"$f":"MAX($A$2:$A38)+1","v":30},null,"市町村分担金",null,null,"K40","経費","71表","E11"]
[{"$f":"MAX($A$2:$A39)+1","v":31},null,"その他",null,null,"K41","経費","71表","E12"]
[{"$f":"MAX($A$2:$A40)+1","v":32},null,"小計",null,null,"K42","経費","71表","E13"]
[{"$f":"MAX($A$2:$A41)+1","v":33},"一般財源",null,null,null,"K43","経費","71表","E14"]
[{"$f":"MAX($A$2:$A42)+1","v":34},"合計",null,null,null,"K44","経費","71表","E15"]
[{"$f":"MAX($A$2:$A43)+1","v":35},"災害廃棄物処理に係る歳入",null,null,null,"K45","災害","71A表","E13"]
[]
[null,"【従事職員】"]
[]
[{"$f":"MAX($A$2:$A47)+1","v":36},"一般職",null,"事務系",null,{"$f":"\"K\"&ROW()+1","v":"K49"},"処理","64、65表","E6"]
[{"$f":"MAX($A$2:$A48)+1","v":37},null,null,"技術系",null,{"$f":"\"K\"&ROW()+1","v":"K50"},"処理","64、65表","E7"]
[{"$f":"MAX($A$2:$A49)+1","v":38},"技能職",null,"収集運搬",null,"K51","処理","64、65表","E8"]
[{"$f":"MAX($A$2:$A50)+1","v":39},null,null,"中間処理",null,"K52","処理","64、65表","E9"]
[{"$f":"MAX($A$2:$A51)+1","v":40},null,null,"最終処分",null,"K53","処理","64、65表","E10"]
[{"$f":"MAX($A$2:$A52)+1","v":41},null,null,"その他",null,"K54","処理","64、65表","E11"]
[{"$f":"MAX($A$2:$A53)+1","v":42},"合計",null,null,null,"K55","処理","64、65表","E12"]