{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["減価償却","長前戻入","料金日報","入力様式の説明"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":164,"n_cols":17,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","簿記項","簿記目","簿記節","簿記略称","４月－７月分","その他の月","減価償却費総額","固定資産額"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要"]
[3,0,"都市部"]
[4,1,"210117-0100","711080-1000","111015-1000",1495779]
[5,1,"210117-0100","711080-1000","111015-2000",4105058]
[6,1,"210117-0100","711080-1000","111025-1000",2625691]
[7,1,"210117-0100","711080-1000","111025-2000",798475]
[8,1,"210117-0100","711080-1000","111025-3000",448188]
[9,1,"210117-0100","711080-1000","111025-4000",6900276]
[10,1,"210117-0100","711080-1000","111025-5000",10585578]
[11,1,"210117-0100","711080-1000","111025-6000",99979061]
[12,1,"210117-0100","711080-1000","111025-7000",2125569]
[13,1,"210117-0100","711080-1000","111035-1000",7742761]
[14,1,"210117-0100","711080-1000","111035-2000",2444997]
[15,1,"210117-0100","711080-1000","111035-3000",381263]
[16,1,"210117-0100","711080-1000","111035-4000",165939]
[17,1,"210117-0100","711080-1000","111035-5000",1014758]
[18,1,"210117-0100","711080-1000","111035-6000",3662719]
[19,1,"210117-0100","711080-1000","111035-7000",16166635]
[20,1,"210117-0100","711080-1000","111045-1000",827630]
[21,1,"210117-0100","711080-1000","111055-1000",1033232]
[22,1,"210117-0500","711080-3000","111065-1000",0]
[23,1,"210117-0300","711080-2000","112010-1000",32707926]
[24,1,"210117-0300","711080-2000","112010-1000",4956940]
[25,1,"210117-0300","711080-2000","112010-2000",17723739]
[26,1,"210117-0300","711080-2000","112015-1000",5049826]
[27,1,"210117-0300","711080-2000","112020-1000",0]
[28,1,"210117-0300","711080-2000","112030-1000",0]
[29,0,"都祁",null,null,0]
[30,1,"210117-0700","711080-1000","111015-1000",0]
[31,1,"210117-0700","711080-1000","111015-2000",934701]
[32,1,"210117-0700","711080-1000","111025-1000",107172]
[33,1,"210117-0700","711080-1000","111025-2000",1705847]
[34,1,"210117-0700","711080-1000","111025-3000",21156]
[35,1,"210117-0700","711080-1000","111025-4000",1787640]
[36,1,"210117-0700","711080-1000","111025-5000",253301]
[37,1,"210117-0700","711080-1000","111025-6000",8251834]
[38,1,"210117-0700","711080-1000","111025-7000",1128005]
[39,1,"210117-0700","711080-1000","111035-1000",1741626]
[40,1,"210117-0700","711080-1000","111035-2000",843840]
[41,1,"210117-0700","711080-1000","111035-3000",0]
[42,1,"210117-0700","711080-1000","111035-4000",755]
[43,1,"210117-0700","711080-1000","111035-5000",0]
[44,1,"210117-0700","711080-1000","111035-6000",110002]
[45,1,"210117-0700","711080-1000","111035-7000",1895523]
[46,1,"210117-0700","711080-1000","111045-1000",0]
[47,1,"210117-0700","711080-1000","111055-1000",0]
[48,1,"210117-1100","711080-3000","111065-1000",0]
[49,1,"210117-0900","711080-2000","112010-1000",0]
[50,1,"210117-0900","711080-2000","112010-1000",1105156]
[51,1,"210117-0900","711080-2000","112010-2000",167878]
[52,1,"210117-0900","711080-2000","112015-1000",1432500]
[53,1,"210117-0900","711080-2000","112020-1000",0]
[54,1,"210117-0900","711080-2000","112030-1000",0]
[55,0,"月ヶ瀬",null,null,0]
[56,0,"210117-1300","711080-1000","111015-1000",0]
[57,1,"210117-1300","711080-1000","111015-2000",207911]
[58,1,"210117-1300","711080-1000","111025-1000",71138]
[59,1,"210117-1300","711080-1000","111025-2000",545782]
[60,1,"210117-1300","711080-1000","111025-3000",69559]
[61,1,"210117-1300","711080-1000","111025-4000",501933]
[62,1,"210117-1300","711080-1000","111025-5000",130989]
[63,1,"210117-1300","711080-1000","111025-6000",1100221]
[64,1,"210117-1300","711080-1000","111025-7000",662686]
[65,1,"210117-1300","711080-1000","111035-1000",83720]
[66,1,"210117-1300","711080-1000","111035-2000",59224]
[67,1,"210117-1300","711080-1000","111035-3000",8745]
[68,1,"210117-1300","711080-1000","111035-4000",242]
[69,0,"210117-1300","711080-1000","111035-5000",0]
[70,1,"210117-1300","711080-1000","111035-6000",209211]
[71,1,"210117-1300","711080-1000","111035-7000",690346]
[72,0,"210117-1300","711080-1000","111045-1000",0]
[73,1,"210117-1300","711080-1000","111055-1000",6150]
[74,0,"210117-1700","711080-3000","111065-1000",0]
[75,0,"210117-1500","711080-2000","112010-1000",0]
[76,0,"210117-1500","711080-2000","112010-1000",0]
[77,0,"210117-1500","711080-2000","112010-2000",0]
[78,2,"210117-1500","711080-2000","112015-1000",1219431]
[79,0,"210117-1500","711080-2000","112020-1000",0]
[80,0,"210117-1500","711080-2000","112030-1000",0]
[81,19,"予算伝票終わり",null,null,null,null,null,null,null,null,null,"簿記略称","４月－７月分","その他の月","減価償却費総額","固定資産額"]
[82,20,"簿記伝票始まり"]
[83,21,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要"]
[84,0,"都市部"]
[85,2,null,"711080-1000","111015-1000",1495779,1495779,"減価償却",null,"有形固定資産","建物","事務所用建物",null,{"$f":"$P86-$O86*8","v":5983122},{"$f":"ROUNDDOWN(P86/12,0)","v":1495779},17949354,1248192762]
[86,2,null,"711080-1000","111015-2000",4105058,4105058,"減価償却",null,"有形固定資産","建物","施設用建物",null,{"$f":"$P87-$O87*8","v":16420237},{"$f":"ROUNDDOWN(P87/12,0)","v":4105058},49260701,2961821435]
[87,2,null,"711080-1000","111025-1000",2625691,2625691,"減価償却",null,"有形固定資産","構築物","導水設備",null,10502773,2625691,31508301,2094542085]
[88,2,null,"711080-1000","111025-2000",798475,798475,"減価償却",null,"有形固定資産","構築物","取水設備",null,3193907,798475,9581707,723828260]
[89,2,null,"711080-1000","111025-3000",448188,448188,"減価償却",null,"有形固定資産","構築物","えん堤",null,1792760,448188,5378264,632836368]
[90,2,null,"711080-1000","111025-4000",6900276,6900276,"減価償却",null,"有形固定資産","構築物","浄水設備",null,27601108,6900276,82803316,4963620099]
[91,2,null,"711080-1000","111025-5000",10585578,10585578,"減価償却",null,"有形固定資産","構築物","配水設備",null,42342319,10585578,127026943,7628031666]
[92,2,null,"711080-1000","111025-6000",99979061,99979061,"減価償却",null,"有形固定資産","構築物","配水管設備",null,399916250,99979061,1199748738,63943887887]
[93,0,null,"711080-1000","111025-7000",2125569,2125569,"減価償却",null,"有形固定資産","構築物","諸設備",null,8502276,2125569,25506828,1853111706]
[94,0,null,"711080-1000","111035-1000",7742761,7742761,"減価償却",null,"有形固定資産","機械及び装置","電気設備",null,30971052,7742761,92913140,3970669184]
[95,0,null,"711080-1000","111035-2000",2444997,2444997,"減価償却",null,"有形固定資産","機械及び装置","ポンプ設備",null,9779999,2444997,29339975,1256090257]
[96,0,null,"711080-1000","111035-3000",381263,381263,"減価償却",null,"有形固定資産","機械及び装置","塩素滅菌設備",null,1525060,381263,4575164,462873826]
[97,0,null,"711080-1000","111035-4000",165939,165939,"減価償却",null,"有形固定資産","機械及び装置","量水器",null,663758,165939,1991270,774048554]
[98,2,null,"711080-1000","111035-5000",1014758,1014758,"減価償却",null,"有形固定資産","機械及び装置","通信設備",null,4059036,1014758,12177100,206747440]
[99,0,null,"711080-1000","111035-6000",3662719,3662719,"減価償却",null,"有形固定資産","機械及び装置","計装設備",null,14650877,3662719,43952629,5046118385]
[100,0,null,"711080-1000","111035-7000",16166635,16166635,"減価償却",null,"有形固定資産","機械及び装置","その他機械装置",null,64666549,16166635,193999629,5430666251]
[101,0,null,"711080-1000","111045-1000",827630,827630,"減価償却",null,"有形固定資産","車両運搬具","車両運搬具",null,3310528,827630,9931568,105020051]
[102,2,null,"711080-1000","111055-1000",1033232,1033232,"減価償却",null,"有形固定資産","器具備品","器具備品",null,4132937,1033232,12398793,190664317]
[103,0,null,"711080-3000","111065-1000",0,0,"減価償却",null,"有形固定資産","リース資産","リース資産",null,0,0,0,0]
[104,2,null,"711080-2000","112010-1000",32707926,32707926,"減価償却",null,"無形固定資産","ダム使用権","布目ダム使用権2",null,130831715,32707926,392495123,9864022220]
[105,2,null,"711080-2000","112010-1000",4956940,4956940,"減価償却",null,null,null,"布目ダム使用権",null,19827770,4956940,59483290,1941033718]
[106,2,null,"711080-2000","112010-2000",17723739,17723739,"減価償却",null,"無形固定資産","ダム使用権","布目ダム（２次）使用権",null,70894963,17723739,212684875,6727558415]
[107,2,null,"711080-2000","112015-1000",5049826,5049826,"減価償却",null,"無形固定資産","水利権","上津ダム水利権",null,20199310,5049826,60597918,1187981161]
[108,0,null,"711080-2000","112020-1000",0,0,"減価償却",null,"無形固定資産","リース資産","リース資産",null,0,0,0,0]
[109,0,null,"711080-2000","112030-1000",0,0,"減価償却",null,"無形固定資産","その他無形固定資産","その他無形固定資産",null,0,0,0,0]
[110,0,"都祁",null,null,0,0,"減価償却",null,null,null,null,null,0,0]
[111,0,null,"711080-1000","111015-1000",0,0,"減価償却",null,"有形固定資産","建物","事務所用建物",null,0,0,0,0]
[112,2,null,"711080-1000","111015-2000",934701,934701,"減価償却",null,"有形固定資産","建物","施設用建物",null,3738806,934701,11216414,295913004]
[113,2,null,"711080-1000","111025-1000",107172,107172,"減価償却",null,"有形固定資産","構築物","導水設備",null,428690,107172,1286066,72749662]
[114,2,null,"711080-1000","111025-2000",1705847,1705847,"減価償却",null,"有形固定資産","構築物","取水設備",null,6823390,1705847,20470166,624992083]
[115,2,null,"711080-1000","111025-3000",21156,21156,"減価償却",null,"有形固定資産","構築物","えん堤",null,84628,21156,253876,18003322]
[116,2,null,"711080-1000","111025-4000",1787640,1787640,"減価償却",null,"有形固定資産","構築物","浄水設備",null,7150567,1787640,21451687,723510379]
[117,2,null,"711080-1000","111025-5000",253301,253301,"減価償却",null,"有形固定資産","構築物","配水設備",null,1013213,253301,3039621,124038381]
[118,2,null,"711080-1000","111025-6000",8251834,8251834,"減価償却",null,"有形固定資産","構築物","配水管設備",null,33007338,8251834,99022010,2164614235]
[119,2,null,"711080-1000","111025-7000",1128005,1128005,"減価償却",null,"有形固定資産","構築物","諸設備",null,4512025,1128005,13536065,398994601]
[120,2,null,"711080-1000","111035-1000",1741626,1741626,"減価償却",null,"有形固定資産","機械及び装置","電気設備",null,6966511,1741626,20899519,420901514]
[121,2,null,"711080-1000","111035-2000",843840,843840,"減価償却",null,"有形固定資産","機械及び装置","ポンプ設備",null,3375364,843840,10126084,187322650]
[122,0,null,"711080-1000","111035-3000",0,0,"減価償却",null,"有形固定資産","機械及び装置","塩素滅菌設備",null,0,0,0,12308473]
[123,2,null,"711080-1000","111035-4000",755,755,"減価償却",null,"有形固定資産","機械及び装置","量水器",null,3022,755,9062,2790023]
[124,0,null,"711080-1000","111035-5000",0,0,"減価償却",null,"有形固定資産","機械及び装置","通信設備",null,0,0,0,0]
[125,2,null,"711080-1000","111035-6000",110002,110002,"減価償却",null,"有形固定資産","機械及び装置","計装設備",null,440015,110002,1320031,51982724]
[126,2,null,"711080-1000","111035-7000",1895523,1895523,"減価償却",null,"有形固定資産","機械及び装置","その他機械装置",null,7582098,1895523,22746282,578025675]
[127,0,null,"711080-1000","111045-1000",0,0,"減価償却",null,"有形固定資産","車両運搬具","車両運搬具",null,0,0,0,0]
[128,0,null,"711080-1000","111055-1000",0,0,"減価償却",null,"有形固定資産","器具備品","器具備品",null,0,0,0,0]
[129,0,null,"711080-3000","111065-1000",0,0,"減価償却",null,"有形固定資産","リース資産","リース資産",null,0,0]
[130,0,null,"711080-2000","112010-1000",0,0,"減価償却",null,"無形固定資産","ダム使用権","布目ダム使用権2",null,0,0]
[131,2,null,"711080-2000","112010-1000",1105156,1105156,"減価償却",null,null,null,"布目ダム使用権",null,4420626,1105156,13261874,349229365]
[132,2,null,"711080-2000","112010-2000",167878,167878,"減価償却",null,"無形固定資産","ダム使用権","布目ダム（２次）使用権",null,671516,167878,2014540,69837406]
[133,2,null,"711080-2000","112015-1000",1432500,1432500,"減価償却",null,"無形固定資産","水利権","上津ダム水利権",null,5730000,1432500,17190000,17190000]
[134,0,null,"711080-2000","112020-1000",0,0,"減価償却",null,"無形固定資産","リース資産","リース資産",null,0,0]
[135,0,null,"711080-2000","112030-1000",0,0,"減価償却",null,"無形固定資産","その他無形固定資産","その他無形固定資産",null,0,0]
[136,0,"月ヶ瀬",null,null,0,0,"減価償却",null,null,null,null,null,0,0]
[137,0,null,"711080-1000","111015-1000",0,0,"減価償却",null,"有形固定資産","建物","事務所用建物",null,0,0,0,0]
[138,2,null,"711080-1000","111015-2000",207911,207911,"減価償却",null,"有形固定資産","建物","施設用建物",null,831646,207911,2494934,54857978]
[139,2,null,"711080-1000","111025-1000",71138,71138,"減価償却",null,"有形固定資産","構築物","導水設備",null,284561,71138,853665,17739372]
[140,2,null,"711080-1000","111025-2000",545782,545782,"減価償却",null,"有形固定資産","構築物","取水設備",null,2183131,545782,6549387,163170802]
[141,2,null,"711080-1000","111025-3000",69559,69559,"減価償却",null,"有形固定資産","構築物","えん堤",null,278242,69559,834714,24505672]
[142,2,null,"711080-1000","111025-4000",501933,501933,"減価償却",null,"有形固定資産","構築物","浄水設備",null,2007742,501933,6023206,163452016]
[143,2,null,"711080-1000","111025-5000",130989,130989,"減価償却",null,"有形固定資産","構築物","配水設備",null,523965,130989,1571877,66750851]
[144,2,null,"711080-1000","111025-6000",1100221,1100221,"減価償却",null,"有形固定資産","構築物","配水管設備",null,4400891,1100221,13202659,407090014]
[145,2,null,"711080-1000","111025-7000",662686,662686,"減価償却",null,"有形固定資産","構築物","諸設備",null,2650748,662686,7952236,219539661]
[146,2,null,"711080-1000","111035-1000",83720,83720,"減価償却",null,"有形固定資産","機械及び装置","電気設備",null,334880,83720,1004640,86915199]
[147,2,null,"711080-1000","111035-2000",59224,59224,"減価償却",null,"有形固定資産","機械及び装置","ポンプ設備",null,236901,59224,710693,79959007]
[148,2,null,"711080-1000","111035-3000",8745,8745,"減価償却",null,"有形固定資産","機械及び装置","塩素滅菌設備",null,34981,8745,104941,13825107]
[149,2,null,"711080-1000","111035-4000",242,242,"減価償却",null,"有形固定資産","機械及び装置","量水器",null,972,242,2908,939815]
[150,0,null,"711080-1000","111035-5000",0,0,"減価償却",null,"有形固定資産","機械及び装置","通信設備",null,{"$f":"$P151-$O151*8","v":0},{"$f":"ROUNDDOWN(P151/12,0)","v":0},0,0]
[151,2,null,"711080-1000","111035-6000",209211,209211,"減価償却",null,"有形固定資産","機械及び装置","計装設備",null,836852,209211,2510540,160839281]
[152,2,null,"711080-1000","111035-7000",690346,690346,"減価償却",null,"有形固定資産","機械及び装置","その他機械装置",null,2761394,690346,8284162,348990963]
[153,0,null,"711080-1000","111045-1000",0,0,"減価償却",null,"有形固定資産","車両運搬具","車両運搬具",null,0,0,0,0]
[154,2,null,"711080-1000","111055-1000",6150,6150,"減価償却",null,"有形固定資産","器具備品","器具備品",null,24600,6150,73800,410000]
[155,0,null,"711080-3000","111065-1000",0,0,"減価償却",null,"有形固定資産","リース資産","リース資産",null,0,0]
[156,0,null,"711080-2000","112010-1000",0,0,"減価償却",null,"無形固定資産","ダム使用権","布目ダム使用権2",null,0,0]
[157,0,null,null,null,0,0,"減価償却",null,null,null,"布目ダム使用権",null,0,0]
[158,0,null,"711080-2000","112010-2000",0,0,"減価償却",null,"無形固定資産","ダム使用権","布目ダム（２次）使用権",null,0,0]
[159,2,null,"711080-2000","112015-1000",1219431,1219431,"減価償却",null,"無形固定資産","水利権","上津ダム水利権",null,4877726,1219431,14633174,14633175]
[160,0,null,"711080-2000","112020-1000",0,0,"減価償却",null,"無形固定資産","リース資産","リース資産",null,0,0]
[161,0,null,"711080-2000","112030-1000",0,0,"減価償却",null,"無形固定資産","その他無形固定資産","その他無形固定資産",null,0,0]
[162,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]

{"sheet":"長前戻入","index":1,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","簿記項","簿記目","簿記節","簿記略称","４月－７月分","その他の月","減価償却費総額"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要"]
[3,0,"都市部有形"]
[4,1,"110309-0100","612050-1000","361065-1000",20609485,null,"長前戻入",null,"分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金",{"$f":"$P5-$O5*8","v":82437945},{"$f":"ROUNDDOWN($P5/12,0)","v":20609485},247313825]
[5,1,"110309-0100","612050-1000","361055-1000",5871021,null,"長前戻入",null,"開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金",23484092,5871021,70452260]
[6,1,"110309-0100","612050-1000","361075-1000",11221023,null,"長前戻入",null,"受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金",44884094,11221023,134652278]
[7,1,"110309-0100","612050-1000","361035-1000",1854069,null,"長前戻入",null,"補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金",7416278,1854069,22248830]
[8,1,"110309-0100","612050-1000","361025-1000",10410952,null,"長前戻入",null,"負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金",41643816,10410952,124931432]
[9,1,"110309-0100","612050-1000","361015-1000",16478387,null,"長前戻入",null,"受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産",65913548,16478387,197740644]
[10,1,"110309-0100","612050-1000","361045-1000",5674403,null,"長前戻入",null,"一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金",22697619,5674403,68092843]
[11,0,"都市部無形",null,null,null,null,"長前戻入"]
[12,0,"110309-0300","612050-2000","361065-1000",0,null,"長前戻入",null,"分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金",{"$f":"$P13-$O13*8","v":0},{"$f":"ROUNDDOWN($P13/12,0)","v":0},0]
[13,0,"110309-0300","612050-2000","361055-1000",0,null,"長前戻入",null,"開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金",0,0,0]
[14,0,"110309-0300","612050-2000","361075-1000",0,null,"長前戻入",null,"受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金",0,0,0]
[15,0,"110309-0300","612050-2000","361035-1000",0,null,"長前戻入",null,"補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金",0,0,0]
[16,1,"110309-0300","612050-2000","361025-1000",19016430,null,"長前戻入",null,"負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金",76065724,19016430,228197164]
[17,0,"110309-0300","612050-2000","361015-1000",0,null,"長前戻入",null,"受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産",0,0,0]
[18,0,"110309-0300","612050-2000","361045-1000",0,null,"長前戻入",null,"一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金",0,0,0]
[19,0,"都祁有形",null,null,null,null,"長前戻入"]
[20,1,"110309-0500","612050-3000","361065-1000",181821,null,"長前戻入",null,"分担金","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額",null,{"$f":"$P21-$O21*8","v":727293},{"$f":"ROUNDDOWN($P21/12,0)","v":181821},2181861]
[21,1,"110309-0500","612050-3000","361055-1000",0,null,"長前戻入",null,"開発負担金","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額",null,0,0,0]
[22,1,"110309-0500","612050-3000","361075-1000",9948,null,"長前戻入",null,"受託負担金","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額",null,39796,9948,119380]
[23,1,"110309-0500","612050-3000","361035-1000",6148461,null,"長前戻入",null,"補助金","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額",null,24593855,6148461,73781543]
[24,1,"110309-0500","612050-3000","361025-1000",2349422,null,"長前戻入",null,"負担金","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額",null,9397696,2349422,28193072]
[25,1,"110309-0500","612050-3000","361015-1000",18791,null,"長前戻入",null,"受贈財産","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額",null,75166,18791,225494]
[26,1,"110309-0500","612050-3000","361045-1000",4191901,null,"長前戻入",null,"一般会計補助金","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額",null,16767604,4191901,50302812]
[27,0,"都祁無形",null,null,null,null,"長前戻入"]
[28,0,"110309-0700","612050-4000","361065-1000",0,null,"長前戻入",null,"分担金",null,null,null,{"$f":"$P29-$O29*8","v":0},{"$f":"ROUNDDOWN($P29/12,0)","v":0},0]
[29,0,"110309-0700","612050-4000","361055-1000",0,null,"長前戻入",null,"開発負担金",null,null,null,0,0,0]
[30,0,"110309-0700","612050-4000","361075-1000",0,null,"長前戻入",null,"受託負担金",null,null,null,0,0,0]
[31,0,"110309-0700","612050-4000","361035-1000",0,null,"長前戻入",null,"補助金",null,null,null,0,0,0]
[32,0,"110309-0700","612050-4000","361025-1000",0,null,"長前戻入",null,"負担金",null,null,null,0,0,0]
[33,0,"110309-0700","612050-4000","361015-1000",0,null,"長前戻入",null,"受贈財産",null,null,null,0,0,0]
[34,0,"110309-0700","612050-4000","361045-1000",0,null,"長前戻入",null,"一般会計補助金",null,null,null,0,0,0]
[35,0,"月ヶ瀬有形",null,null,null,null,"長前戻入"]
[36,1,"110309-0900","612050-5000","361065-1000",26490,null,"長前戻入",null,"分担金","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額",null,{"$f":"$P37-$O37*8","v":105961},{"$f":"ROUNDDOWN($P37/12,0)","v":26490},317881]
[37,0,"110309-0900","612050-5000","361055-1000",0,null,"長前戻入",null,"開発負担金","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額",null,0,0,0]
[38,1,"110309-0900","612050-5000","361075-1000",3466,null,"長前戻入",null,"受託負担金","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額",null,13875,3466,41603]
[39,1,"110309-0900","612050-5000","361035-1000",1827030,null,"長前戻入",null,"補助金","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額",null,7308128,1827030,21924368]
[40,1,"110309-0900","612050-5000","361025-1000",1226694,null,"長前戻入",null,"負担金","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額",null,4906776,1226694,14720328]
[41,0,"110309-0900","612050-5000","361015-1000",0,null,"長前戻入",null,"受贈財産","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額",null,0,0,0]
[42,1,"110309-0900","612050-5000","361045-1000",256698,null,"長前戻入",null,"一般会計補助金","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額",null,1026796,256698,3080380]
[43,0,"月ヶ瀬無形",null,null,null,null,"長前戻入"]
[44,0,"110309-1100","612050-6000","361065-1000",0,null,"長前戻入",null,"分担金",null,null,null,{"$f":"$P45-$O45*8","v":0},{"$f":"ROUNDDOWN($P45/12,0)","v":0},0]
[45,0,"110309-1100","612050-6000","361055-1000",0,null,"長前戻入",null,"開発負担金",null,null,null,0,0,0]
[46,0,"110309-1100","612050-6000","361075-1000",0,null,"長前戻入",null,"受託負担金",null,null,null,0,0,0]
[47,1,"110309-1100","612050-6000","361035-1000",805441,null,"長前戻入",null,"補助金",null,null,null,3221768,805441,9665296]
[48,1,"110309-1100","612050-6000","361025-1000",297082,null,"長前戻入",null,"負担金",null,null,null,1188338,297082,3564994]
[49,0,"110309-1100","612050-6000","361015-1000",0,null,"長前戻入",null,"受贈財産",null,null,null,0,0,0]
[50,0,"110309-1100","612050-6000","361045-1000",0,null,"長前戻入",null,"一般会計補助金",null,null,null,0,0,0]
[51,19,"予算伝票終わり",null,null,null,null,null,null,null,null,null,"簿記略称","４月－７月分","その他の月","減価償却費総額"]
[52,20,"簿記伝票始まり"]
[53,21,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要"]
[54,0,"都市部有形"]
[55,2,null,"612050-1000","361065-1000",20609485,20609485,"長前戻入",null,"分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金",{"$f":"$P56-$O56*8","v":82437945},{"$f":"ROUNDDOWN($P56/12,0)","v":20609485},247313825]
[56,2,null,"612050-1000","361055-1000",5871021,5871021,"長前戻入",null,"開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金",23484092,5871021,70452260]
[57,2,null,"612050-1000","361075-1000",11221023,11221023,"長前戻入",null,"受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金",44884094,11221023,134652278]
[58,2,null,"612050-1000","361035-1000",1854069,1854069,"長前戻入",null,"補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金",7416278,1854069,22248830]
[59,2,null,"612050-1000","361025-1000",10410952,10410952,"長前戻入",null,"負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金",41643816,10410952,124931432]
[60,2,null,"612050-1000","361015-1000",16478387,16478387,"長前戻入",null,"受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産",65913548,16478387,197740644]
[61,2,null,"612050-1000","361045-1000",5674403,5674403,"長前戻入",null,"一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金",22697619,5674403,68092843]
[62,0,"都市部無形",null,null,null,null,"長前戻入"]
[63,0,null,"612050-2000","361065-1000",0,0,"長前戻入",null,"分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額","分担金",{"$f":"$P64-$O64*8","v":0},{"$f":"ROUNDDOWN($P64/12,0)","v":0},0]
[64,0,null,"612050-2000","361055-1000",0,0,"長前戻入",null,"開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額","開発負担金",0,0,0]
[65,0,null,"612050-2000","361075-1000",0,0,"長前戻入",null,"受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額","受託負担金",0,0,0]
[66,0,null,"612050-2000","361035-1000",0,0,"長前戻入",null,"補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額","補助金",0,0,0]
[67,2,null,"612050-2000","361025-1000",19016430,19016430,"長前戻入",null,"負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額","負担金",76065724,19016430,228197164]
[68,0,null,"612050-2000","361015-1000",0,0,"長前戻入",null,"受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額","受贈財産",0,0,0]
[69,0,null,"612050-2000","361045-1000",0,0,"長前戻入",null,"一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額","一般会計補助金",0,0,0]
[70,0,"都祁有形",null,null,null,null,"長前戻入"]
[71,2,null,"612050-3000","361065-1000",181821,181821,"長前戻入",null,"分担金","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額",null,{"$f":"$P72-$O72*8","v":727293},{"$f":"ROUNDDOWN($P72/12,0)","v":181821},2181861]
[72,2,null,"612050-3000","361055-1000",0,0,"長前戻入",null,"開発負担金","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額",null,0,0,0]
[73,2,null,"612050-3000","361075-1000",9948,9948,"長前戻入",null,"受託負担金","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額",null,39796,9948,119380]
[74,2,null,"612050-3000","361035-1000",6148461,6148461,"長前戻入",null,"補助金","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額",null,24593855,6148461,73781543]
[75,2,null,"612050-3000","361025-1000",2349422,2349422,"長前戻入",null,"負担金","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額",null,9397696,2349422,28193072]
[76,2,null,"612050-3000","361015-1000",18791,18791,"長前戻入",null,"受贈財産","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額",null,75166,18791,225494]
[77,2,null,"612050-3000","361045-1000",4191901,4191901,"長前戻入",null,"一般会計補助金","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額",null,16767604,4191901,50302812]
[78,0,"都祁無形",null,null,null,null,"長前戻入"]
[79,0,null,"612050-4000","361065-1000",0,0,"長前戻入",null,"分担金",null,null,null,{"$f":"$P80-$O80*8","v":0},{"$f":"ROUNDDOWN($P80/12,0)","v":0},0]
[80,0,null,"612050-4000","361055-1000",0,0,"長前戻入",null,"開発負担金",null,null,null,0,0,0]
[81,0,null,"612050-4000","361075-1000",0,0,"長前戻入",null,"受託負担金",null,null,null,0,0,0]
[82,0,null,"612050-4000","361035-1000",0,0,"長前戻入",null,"補助金",null,null,null,0,0,0]
[83,0,null,"612050-4000","361025-1000",0,0,"長前戻入",null,"負担金",null,null,null,0,0,0]
[84,0,null,"612050-4000","361015-1000",0,0,"長前戻入",null,"受贈財産",null,null,null,0,0,0]
[85,0,null,"612050-4000","361045-1000",0,0,"長前戻入",null,"一般会計補助金",null,null,null,0,0,0]
[86,0,"月ヶ瀬有形",null,null,null,null,"長前戻入"]
[87,2,null,"612050-5000","361065-1000",26490,26490,"長前戻入",null,"分担金","分担金長期前受金収益化累計額","分担金長期前受金収益化累計額",null,{"$f":"$P88-$O88*8","v":105961},{"$f":"ROUNDDOWN($P88/12,0)","v":26490},317881]
[88,0,null,"612050-5000","361055-1000",0,0,"長前戻入",null,"開発負担金","開発負担金長期前受金収益化累計額","開発負担金長期前受金収益化累計額",null,0,0,0]
[89,2,null,"612050-5000","361075-1000",3466,3466,"長前戻入",null,"受託負担金","受託負担金長期前受金収益化累計額","受託負担金長期前受金収益化累計額",null,13875,3466,41603]
[90,2,null,"612050-5000","361035-1000",1827030,1827030,"長前戻入",null,"補助金","補助金長期前受金収益化累計額","補助金長期前受金収益化累計額",null,7308128,1827030,21924368]
[91,2,null,"612050-5000","361025-1000",1226694,1226694,"長前戻入",null,"負担金","負担金長期前受金収益化累計額","負担金長期前受金収益化累計額",null,4906776,1226694,14720328]
[92,0,null,"612050-5000","361015-1000",0,0,"長前戻入",null,"受贈財産","受贈財産評価額長期前受金収益化累計額","受贈財産評価額長期前受金収益化累計額",null,0,0,0]
[93,2,null,"612050-5000","361045-1000",256698,256698,"長前戻入",null,"一般会計補助金","一般会計補助金長期前受金収益化累計額","一般会計補助金長期前受金収益化累計額",null,1026796,256698,3080380]
[94,0,"月ヶ瀬無形",null,null,null,null,"長前戻入"]
[95,0,null,"612050-6000","361065-1000",0,0,"長前戻入",null,"分担金",null,null,null,{"$f":"$P96-$O96*8","v":0},{"$f":"ROUNDDOWN($P96/12,0)","v":0},0]
[96,0,null,"612050-6000","361055-1000",0,0,"長前戻入",null,"開発負担金",null,null,null,0,0,0]
[97,0,null,"612050-6000","361075-1000",0,0,"長前戻入",null,"受託負担金",null,null,null,0,0,0]
[98,2,null,"612050-6000","361035-1000",805441,805441,"長前戻入",null,"補助金",null,null,null,3221768,805441,9665296]
[99,2,null,"612050-6000","361025-1000",297082,297082,"長前戻入",null,"負担金",null,null,null,1188338,297082,3564994]
[100,0,null,"612050-6000","361015-1000",0,0,"長前戻入",null,"受贈財産",null,null,null,0,0,0]
[101,0,null,"612050-6000","361045-1000",0,0,"長前戻入",null,"一般会計補助金",null,null,null,0,0,0]
[102,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]

{"sheet":"料金日報","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要"]
[3,0,"口座"]
[4,0,"都市部"]
[5,1,"110101-0100",null,null,94380298,null,"都市部水道料金","2020-11-18"]
[6,0,"110101-0100",null,null,67182693,null,"都市部公共下水","2020-11-18"]
[7,0,"110101-0100",null,null,543801,null,"都市部農業集落排水","2020-11-18"]
[8,0,"都祁"]
[9,1,"110101-0300",null,null,134014,null,"都祁水道料金","2020-11-18"]
[10,0,"110101-0300",null,null,41321,null,"都祁公共下水","2020-11-18"]
[11,0,"110101-0300",null,null,77252,null,"都祁農業集落排水","2020-11-18"]
[12,0,"月ヶ瀬"]
[13,1,"110101-0500",null,null,1322218,null,"月ヶ瀬水道料金","2020-11-18"]
[14,0,"110101-0500",null,null,null,null,"月ヶ瀬公共下水","2020-11-18"]
[15,0,"110101-0500",null,null,null,null,"月ヶ瀬農業集落排水","2020-11-18"]
[16,19,"予算伝票終わり",null,null,null,null,""]
[17,20,"簿記伝票始まり",null,null,null,null,""]
[18,21,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要"]
[19,null,"口座"]
[20,0,"都市部"]
[21,2,"110101-0100","152010-1000","611010-1000",null,null,"水道料金"]
[22,2,null,"152010-1000","335530-1000",null,null,"公共下水"]
[23,2,null,"151010-1000",null,null,null,"農業集落排水"]
[24,0,"都祁"]
[25,2,"110101-0300","152010-1000","611010-1000",null,null,"水道料金"]
[26,2,null,"151010-1000","335530-3000",null,null,"公共下水"]
[27,2,null,"151010-1000",null,null,null,"農業集落排水"]
[28,0,"月ヶ瀬"]
[29,2,"110101-0500","152010-1000","611010-1000",null,null,"水道料金"]
[30,0,null,"151010-1000","335530-5000",null,null,"公共下水"]
[31,2,null,"151010-1000",null,null,null,"農業集落排水"]
[32,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]

{"sheet":"入力様式の説明","index":3,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16,19,"予算伝票終わり",null,null,null,null,""]
[17,20,"簿記伝票始まり",null,null,null,null,""]
[18,21,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要"]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]
[]
["入力フォーマットの規則について"]
[1,"ID=999","ここまで行単位で読込みます"]
[2,"読込FLG=10","予算伝票の読込の始まり"]
[null,"読込FLG=11","予算伝票のフィールド名の読込"]
[null,"読込FLG=1","予算伝票のデータの読込"]
[null,"読込FLG=19","予算伝票の読込の終わり"]
[null,"読込FLG=20","簿記伝票の読込の始まり"]
[null,"読込FLG=21","簿記伝票のフィールド名の読込"]
[null,"読込FLG=2","簿記伝票のデータの読込"]
[null,"読込FLG=29","簿記伝票の読込の終わり"]
[null,"読込FLG=999","全伝票の読込の終わり"]
[null,"読込FLG=0","読込みません。合計、見出しなど関連情報を記載します。"]