{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ブランク伝票","マクロ実行後（上水調定）","入力シートサンプル（上水調定）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[11]
[11]
[0]
[11]
[0]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日","消費税CD","消費税率","消費税額"]
[21]
[21]
[0]
[21]
[0]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]
[]
["読込FLG","読込FLGの値に応じて行単位で読込みます"]
[10,"読込みません。予算伝票の読込の始まり"]
[0,"読込みません。合計、見出しなど関連情報を記載します。"]
[11,"予算伝票データ"]
[19,"読込みません。予算伝票の終わり"]
[20,"読込みません。簿記伝票の読込の始まり"]
[21,"簿記伝票データ"]
[29,"読込みません。簿記伝票の終わり"]
[999,"読込みません。全伝票の終わり"]
[]
["＊注意","金額増・金額減がともにゼロの場合、読み込みません"]

{"sheet":"マクロ実行後（上水調定）","index":1,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"都市部"]
[11,"110101-0100","152010-1000","611010-1000",604333058,null,{"$f":"\"定例調定：\"&$B$3&\"：隔月分\"","v":"定例調定：都市部：隔月分"},"2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",61075465,null,{"$f":"\"定例調定：\"&$B$3&\"：毎月分\"","v":"定例調定：都市部：毎月分"},"2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",788150,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",15861,null,{"$f":"\"調定増：現年度：\"&$B$3","v":"調定増：現年度：都市部"},"2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$B$3","v":"調定増：過年度：都市部"},"2020-11-18",1,10]
[11,"110101-0100","611010-1000","152010-1000",null,31360,{"$f":"\"調定減：現年度：\"&$B$3","v":"調定減：現年度：都市部"},"2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$B$3","v":"調定減：過年度：都市部"},"2020-11-18",1,10]
[0,"都祁"]
[11,"110101-0300","152010-1000","611010-2000",11228857,null,{"$f":"\"定例調定：\"&$B$11&\"：隔月分\"","v":"定例調定：都祁：隔月分"},"2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",null,null,{"$f":"\"定例調定：\"&$B$11&\"：毎月分\"","v":"定例調定：都祁：毎月分"},"2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",null,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",null,null,{"$f":"\"調定増：現年度：\"&$B$11","v":"調定増：現年度：都祁"},"2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$B$11","v":"調定増：過年度：都祁"},"2020-11-18",1,10]
[11,"110101-0300","611010-2000","152010-1000",null,null,{"$f":"\"調定減：現年度：\"&$B$11","v":"調定減：現年度：都祁"},"2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$B$11","v":"調定減：過年度：都祁"},"2020-11-18",1,10]
[0,"月ヶ瀬"]
[11,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"定例調定：\"&$B$19&\"：隔月分\"","v":"定例調定：月ヶ瀬：隔月分"},"2020-11-18",1,10]
[11,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"定例調定：\"&$B$19&\"：毎月分\"","v":"定例調定：月ヶ瀬：毎月分"},"2020-11-18",1,10]
[11,"110101-0500","152010-1000","611010-3000",null,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[11,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"調定増：現年度：\"&$B$19","v":"調定増：現年度：月ヶ瀬"},"2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$B$19","v":"調定増：過年度：月ヶ瀬"},"2020-11-18",1,10]
[11,"110101-0500","611010-3000","152010-1000",null,null,{"$f":"\"調定減：現年度：\"&$B$19","v":"調定減：現年度：月ヶ瀬"},"2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$B$19","v":"調定減：過年度：月ヶ瀬"},"2020-11-18",1,10]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,{"$f":"B4","v":"110101-0100"},"152010-1000","611010-1000",549393689.090909,549393689.090909,{"$f":"G4","v":"定例調定：都市部：隔月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",54939368.909090996,54939368.909090996,null,"2020-11-18",99]
[21,{"$f":"B5","v":"110101-0100"},{"$f":"C5","v":"152010-1000"},{"$f":"D5","v":"611010-1000"},55523149.999999993,55523149.999999993,{"$f":"G5","v":"定例調定：都市部：毎月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",5552315.0000000075,5552315.0000000075,null,"2020-11-18",99]
[21,"110101-0100","152010-1000","611010-1000",716500,716500,"臨時・仮設前受金精算","2020-11-18",99]
[21,null,"152010-1000","336010-1000",71650,71650,null,"2020-11-18",99]
[21,{"$f":"B7","v":"110101-0100"},"152010-1000","611010-1000",14419.090909090908,14419.090909090908,{"$f":"G7","v":"調定増：現年度：都市部"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",1441.9090909090919,1441.9090909090919,null,"2020-11-18",99]
[21,{"$f":"B8","v":"110503-0100"},"152010-1000","613020-1000",0,0,{"$f":"G8","v":"調定増：過年度：都市部"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B9","v":"110101-0100"},"611010-1000","152010-1000",28509.090909090908,28509.090909090908,{"$f":"G9","v":"調定減：現年度：都市部"},"2020-11-18",99]
[21,null,"336010-1000","152010-1000",2850.9090909090919,2850.9090909090919,null,"2020-11-18",99]
[21,{"$f":"B10","v":"210507-0100"},"713040-1000","152010-1000",0,0,{"$f":"G10","v":"調定減：過年度：都市部"},"2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,{"$f":"B12","v":"110101-0300"},"152010-1000","611010-2000",10208051.818181816,10208051.818181816,{"$f":"G12","v":"定例調定：都祁：隔月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",1020805.1818181835,1020805.1818181835,null,"2020-11-18",99]
[21,{"$f":"B13","v":"110101-0300"},{"$f":"C13","v":"152010-1000"},{"$f":"D13","v":"611010-2000"},0,0,{"$f":"G13","v":"定例調定：都祁：毎月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,"110101-0300","152010-1000","611010-2000",0,0,"臨時・仮設前受金精算","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B15","v":"110101-0300"},"152010-1000","611010-2000",0,0,{"$f":"G15","v":"調定増：現年度：都祁"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B16","v":"110503-0100"},"152010-1000","613020-1000",0,0,{"$f":"G16","v":"調定増：過年度：都祁"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B17","v":"110101-0300"},"611010-2000","152010-1000",0,0,{"$f":"G17","v":"調定減：現年度：都祁"},"2020-11-18",99]
[21,null,"336010-1000","152010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B18","v":"210507-0100"},"713040-1000","152010-1000",0,0,{"$f":"G18","v":"調定減：過年度：都祁"},"2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,{"$f":"B20","v":"110101-0500"},"152010-1000","611010-3000",0,0,{"$f":"G20","v":"定例調定：月ヶ瀬：隔月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B21","v":"110101-0500"},"152010-1000",{"$f":"D21","v":"611010-3000"},0,0,{"$f":"G21","v":"定例調定：月ヶ瀬：毎月分"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,"110101-0100","152010-1000","611010-1000",0,0,"臨時・仮設前受金精算","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B23","v":"110101-0500"},"152010-1000","611010-3000",0,0,{"$f":"G23","v":"調定増：現年度：月ヶ瀬"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B24","v":"110503-0100"},"152010-1000","613020-1000",0,0,{"$f":"G24","v":"調定増：過年度：月ヶ瀬"},"2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B25","v":"110101-0500"},"611010-3000","152010-1000",0,0,{"$f":"G25","v":"調定減：現年度：月ヶ瀬"},"2020-11-18",99]
[21,null,"336010-1000","152010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B26","v":"210507-0100"},"713040-1000","152010-1000",0,0,{"$f":"G26","v":"調定減：過年度：月ヶ瀬"},"2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"入力シートサンプル（上水調定）","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["項目","発行日"]
["発行日","2020-01-01"]
[null,"予算科目CD","借方科目CD","貸方科目CD","消費税CD","消費税率"]
["都市部","110101-0100","152010-1000","611010-1000",1,10]
["都祁","110101-0300","152010-1000","611010-2000",1,10]
["月ヶ瀬","110101-0500","152010-1000","611010-3000",1,10]
[null,"簿記科目CD"]
["仮受消費税","336010-1000"]
["仮払消費税","158030-1000"]
["過年度修正益","613020-1000"]
["過年度修正損","713040-1000"]
["予算科目CD","借方科目CD","貸方科目CD","税込み金額","税抜き金額","消費税額","摘要"]
["都市部"]
["給水収益","給水未収金","給水収益",604333058,{"$f":"D14/1.1","v":549393689.090909},{"$f":"D14-E14","v":54939368.909090996},{"$f":"\"定例調定：\"&$A$13&\"：隔月分\"","v":"定例調定：都市部：隔月分"}]
["給水収益","給水未収金","給水収益",61075465,{"$f":"D15/1.1","v":55523149.999999993},{"$f":"D15-E15","v":5552315.0000000075},{"$f":"\"定例調定：\"&$A$13&\"：毎月分\"","v":"定例調定：都市部：毎月分"}]
["給水収益","給水未収金","給水収益",788150,716500,71650,"臨時・仮設前受金精算"]
["給水収益","給水未収金","給水収益",15861,14419.090909090908,1441.9090909090919,{"$f":"\"調定増：現年度：\"&$A$13","v":"調定増：現年度：都市部"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$13","v":"調定増：過年度：都市部"}]
["給水収益","給水収益","給水未収金",31360,28509.090909090908,2850.9090909090919,{"$f":"\"調定減：現年度：\"&$A$13","v":"調定減：現年度：都市部"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$13","v":"調定減：過年度：都市部"}]
["都祁"]
["給水収益","給水未収金","給水収益",11228857,{"$f":"D22/1.1","v":10208051.818181816},{"$f":"D22-E22","v":1020805.1818181835},{"$f":"\"定例調定：\"&$A$21&\"：隔月分\"","v":"定例調定：都祁：隔月分"}]
["給水収益","給水未収金","給水収益",null,{"$f":"D23/1.1","v":0},{"$f":"D23-E23","v":0},{"$f":"\"定例調定：\"&$A$21&\"：毎月分\"","v":"定例調定：都祁：毎月分"}]
["給水収益","給水未収金","給水収益",null,0,0,"臨時・仮設前受金精算"]
["給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$A$21","v":"調定増：現年度：都祁"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$21","v":"調定増：過年度：都祁"}]
["給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$A$21","v":"調定減：現年度：都祁"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$21","v":"調定減：過年度：都祁"}]
["月ヶ瀬"]
["給水収益","給水未収金","給水収益",null,{"$f":"D30/1.1","v":0},{"$f":"D30-E30","v":0},{"$f":"\"定例調定：\"&$A$29&\"：隔月分\"","v":"定例調定：月ヶ瀬：隔月分"}]
["給水収益","給水未収金","給水収益",null,{"$f":"D31/1.1","v":0},{"$f":"D31-E31","v":0},{"$f":"\"定例調定：\"&$A$29&\"：毎月分\"","v":"定例調定：月ヶ瀬：毎月分"}]
["給水収益","給水未収金","給水収益",null,0,0,"臨時・仮設前受金精算"]
["給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$A$29","v":"調定増：現年度：月ヶ瀬"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$29","v":"調定増：過年度：月ヶ瀬"}]
["給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$A$29","v":"調定減：現年度：月ヶ瀬"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$29","v":"調定減：過年度：月ヶ瀬"}]
["金額合計"]