{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["前受金調定","前受金入金","漏水減免","下水減免","上水減免","ブランク伝票"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"都市部"]
[11,"110101-0100","152010-1000","611010-1000",716500,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[0,"都祁"]
[11,"110101-0300","152010-1000","611010-2000",0,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[0,"月ヶ瀬"]
[11,"110101-0500","152010-1000","611010-3000",0,null,"臨時・仮設前受金精算","2020-11-18",1,10]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[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]
[0,"都祁"]
[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]
[0,"月ヶ瀬"]
[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]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"前受金入金","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["読込FLG","証明・給水再開手数料"]
[20,"簿記伝票終わり"]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"口座"]
[21,null,"151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18",99]
[21,null,"334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[0,"郵政納付",null,null,null,null,null,null,99]
[21,null,"151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18",99]
[21,null,"334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[0,"銀行納付",null,null,null,null,null,null,99]
[21,null,"151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18",99]
[21,null,"334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[21,"コンビニ",null,null,null,null,null,null,99]
[21,null,"151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18",99]
[21,null,"334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[21,"窓口",null,null,null,null,null,null,99]
[21,null,"151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18",99]
[21,null,"334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18",99]
[0,"合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"漏水減免","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ID","月分","使用者番号","使用者名義","口径","減免水量","上水減額","下水減額","消費税","相手方番号","備考"]
[1]
[2]
[3]
[4,204,"259-051-000","奥井　徳之",20,7,1540,826,0.1,"0400024594"]
[5,205,"259-051-000","奥井　徳之",20,8,1760,1091,0.1]
[6,206,"259-051-000","奥井　徳之",20,7,955,955,0.1]
[7,207,"259-051-000","奥井　徳之",20,6,819,819,0.1]
[8,207,"259-051-000","奥井　徳之（小計）",null,null,{"$f":"SUM(G5:G8)","v":5074},{"$f":"SUM(H5:H8)","v":3691},0.1,"0400024594"]
[9]
[10,203,"006-010-000","竹本　敏夫",13,3,660,354,0.1,"0400024601"]
[11,204,"006-010-000","竹本　敏夫",13,3,660,354,0.1]
[12,205,"006-010-000","竹本　敏夫",13,4,880,546,0.1]
[13,206,"006-010-000","竹本　敏夫",13,5,1100,682,0.1]
[14,206,"006-010-000","竹本　敏夫（小計）",null,null,{"$f":"SUM(G11:G14)","v":3300},{"$f":"SUM(H11:H14)","v":1936},0.1,"0400024601"]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32,"簿記伝票終わり"]
[999,"全伝票終わり"]
[]
["入力フォーマットの規則について"]
[1,"ここまで行単位で読込みます"]
[2,"予算伝票の読込の始まり"]
[null,"予算伝票のフィールド名の読込"]
[null,"予算伝票のデータの読込"]
[null,"予算伝票の読込の終わり"]
[null,"簿記伝票の読込の始まり"]
[null,"簿記伝票のフィールド名の読込"]
[null,"簿記伝票のデータの読込"]
[null,"簿記伝票の読込の終わり"]
[null,"全伝票の読込の終わり"]
[null,"読込みません。合計、見出しなど関連情報を記載します。"]

{"sheet":"下水減免","index":3,"n_rows":47,"n_cols":39,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ID","ケースN","氏名","ふりがな","還付日","還付回","郵便番号","住所","番地","方書","還付対象期間始","還付対象期間終","水量1月","水量2月","水量3月","水量4月","水量5月","水量6月","水量7月","水量8月","水量9月","水量10月","水量11月","水量12月","水量合計","金額1月","金額2月","金額3月","金額4月","金額5月","金額6月","金額7月","金額8月","金額9月","金額10月","金額11月","金額12月","金額合計","相手方番号"]
[1]
[2]
[3]
[4,63973,"浅沼　静子","ｱｻﾇﾏｼｽﾞｺ","2020-03-27",1,"631-0003",null,null,"中富団地　D-6-501号","2019-01-01","2019-12-31",18,18,15,16,15,15,16,16,16,16,16,17,{"$f":"SUM(M5:X5)","v":194},2088,2088,1740,1856,1740,1740,1856,1856,1856,1856,1888,2006,{"$f":"SUM(Z5:AK5)","v":22570},"0700018853"]
[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]
[31]
[32,null,"簿記伝票終わり"]
[999,null,"全伝票終わり"]
[]
["入力フォーマットの規則について"]
[1,null,"ここまで行単位で読込みます"]
[2,null,"予算伝票の読込の始まり"]
[null,null,"予算伝票のフィールド名の読込"]
[null,null,"予算伝票のデータの読込"]
[null,null,"予算伝票の読込の終わり"]
[null,null,"簿記伝票の読込の始まり"]
[null,null,"簿記伝票のフィールド名の読込"]
[null,null,"簿記伝票のデータの読込"]
[null,null,"簿記伝票の読込の終わり"]
[null,null,"全伝票の読込の終わり"]
[null,null,"読込みません。合計、見出しなど関連情報を記載します。"]

{"sheet":"上水減免","index":4,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ID","使用者番号","水栓所在地","使用者名","8月","9月","10月","11月","12月","1月","2月","3月","4月","5月","6月","7月","合計","備考"]
[1]
[2]
[3]
[4,"799-001-000","奈良市中登美ケ丘","多田　武英",451,451,451,460,460,460,460,460,460,0,0,460,{"$f":"SUM(E5:P5)","v":4573}]
[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]
[31]
[32,"簿記伝票終わり"]
[999,"全伝票終わり"]
[]
["入力フォーマットの規則について"]
[1,"ここまで行単位で読込みます"]
[2,"予算伝票の読込の始まり"]
[null,"予算伝票のフィールド名の読込"]
[null,"予算伝票のデータの読込"]
[null,"予算伝票の読込の終わり"]
[null,"簿記伝票の読込の始まり"]
[null,"簿記伝票のフィールド名の読込"]
[null,"簿記伝票のデータの読込"]
[null,"簿記伝票の読込の終わり"]
[null,"全伝票の読込の終わり"]
[null,"読込みません。合計、見出しなど関連情報を記載します。"]

{"sheet":"ブランク伝票","index":5,"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,"読込みません。全伝票の終わり"]
[]
["＊注意","金額増・金額減がともにゼロの場合、読み込みません"]