{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["はじめに","説明","伝票作成","出納簿","期間別試算表","科目細分類表","現金照合表","手書き領収書フォーム","予算比較"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":52,"comments":1,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"説明","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,2,10,5],[11,2,12,5],[9,8,11,11],[3,2,4,5],[5,2,6,5],[18,12,19,17],[24,12,25,17],[22,12,23,17],[4,8,4,11],[16,8,17,11],[21,8,22,11],[56,12,57,17],[23,2,23,3],[52,12,53,17],[29,12,30,17],[32,12,35,17],[39,12,41,17],[36,12,37,17],[42,12,44,17],[27,12,28,17],[44,2,44,5],[45,12,46,17],[24,8,25,11],[26,8,26,11],[29,8,30,11]]}
[null,"会計帳簿システムの使用手順",null,null,null,null,null,null,null,null,null,null,"４．補足Q&A"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4-<1>バックアップ処理のイメージは？"]
[null,"１．年度初めの準備",null,null,null,null,null,"２.PCの動きが重くて伝票を削除したいとき。",null,null,null,null,"→バックアップには、A B C Dの4種類があります。"]
[null,null,"前年度から引き継ぐものは、このシステムとしては「会計帳簿.xlsm」だけです。",null,null,null,null,"基本的には年度初めの対応とほぼ同じです。"]
[null,null,null,null,null,null,null,"2-<1>","最初に、バックアップファイルCを作成します。"]
[null,"1-<1>","最初に、バックアップファイルCを作成します（同じフォルダ内）。"]
[]
[null,null,null,null,null,null,null,"2-<2>","伝票を削除します。"]
[null,null,null,null,null,null,null,null,"1-<2>だけ行います。"]
[null,"1-<2>","前年度の伝票を削除します（処理が軽ければ削除しなくてもOK）。",null,null,null,null,null,"ここへ削除したい範囲（基本的には期間計算の単位で、例えば2021/4/1~2021/6/30など）を入力して、伝票削除を実行してください。"]
[]
[null,null,"前年度の年度開始日を削除開始日へ、年度終了日を削除終了日へ入れるのが基本です。"]
[]
[null,null,null,null,null,null,null,"３．伝票入力と月次の処理"]
[null,null,"削除開始日","削除終了日",null,null,null,"3-<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,"各月のEXCELマクロファイル(xlsm)を用意するのではなく、バックアップが各月の結果となります。"]
[null,null,"間違えて伝票を削除した場合"]
[null,null,"→補足4-<5>を行ってください。",null,null,null,null,"3-<2>","毎月末（期間末）に、試算表を作成します。"]
[null,null,null,null,null,null,null,null,"1)期間計算をクリック（期間別試算表の各期間の上段にボタン）",null,null,null,"4-<2>月次の処理が終わらないと、翌月の伝票を入れられないのか？"]
[null,"1-<3>-1","団体名を入れてください（一度入れればOK)。",null,null,null,null,null,null,null,null,null,"→伝票を入れるのは、いつでもOKです。但し、伝票Noは順番を守ってください。"]
[null,null,"A自治会",null,null,null,null,null,"2)細分類をハンド記入"]
[null,"1-<3>-2","年度初めの設定をします。",null,null,null,null,null,"3)出納簿の印刷（　当該の期間を入力、科目は空欄にする。PDFで確認後印刷。）",null,null,null,"月次処理は全データから、当該期間のデータを拾い上げるため、他の期間のデータがあっても影響ありません。"]
[null,null,null,2021,"年度"]
[null,"1-<3>-3","期間別試算表の期間設定を行います。",null,null,null,null,null,"4）実績のある科目について、元帳を印刷"]
[null,null,null,"開始日","終了日",null,null,null,"5)現金と預金の残高照合",null,null,null,"4-<3>PCが高性能で、何も重くならないのに、過去の伝票を削除する必要があるのか？"]
[null,null,"前年度末",null,"2021-03-31"]
[null,null,"期間計算1","2021-04-01","2021-04-30",null,null,"3-<3>","バックアップBを作成します。（期間別試算表の各期間の上段にボタン）",null,null,null,"→サクサク動くのなら、年度を超えても伝票削除は不要です。但し年度初めは、1-<3>は必ず行ってください。"]
[null,null,"期間計算2","2021-05-01","2021-05-31"]
[null,null,"期間計算3","2021-06-01","2021-06-30"]
[null,null,"期間計算4","2021-07-01","2021-07-31",null,null,null,null,null,null,null,"4-<4>バックアップファイルなどファイルを開いたとき、「コンテンツの有効化」、を問われた場合は、そこをクリックして有効化してから、一度、保存してください。再度、開くときは、この問いは出てこないはずです。"]
[null,null,"期間計算5","2021-08-01","2021-08-31"]
[null,null,"期間計算6","2021-09-01","2021-09-30",null,null,null,"以上です。"]
[null,null,"期間計算7","2021-10-01","2021-10-31"]
[null,null,"期間計算8","2021-11-01","2021-11-30",null,null,null,null,null,null,null,"4-<5>間違えて伝票削除を実行した場合(削除をし過ぎた場合）、復元の仕方は？"]
[null,null,"期間計算9","2021-12-01","2021-12-31"]
[null,null,"期間計算10","2022-01-01","2022-01-31",null,null,null,null,null,null,null,"→慎重に行う必要があります。"]
[null,null,"期間計算11","2022-02-01","2022-02-28",null,null,null,null,null,null,null,"1) 同じフォルダの中に、バックアップCファイル「XXXXXXC_会計帳簿.xlsm」が作られているはずです。これを開いて、間違えて削除した伝票が残っていることを確認してください。"]
[null,null,"期間計算12","2022-03-01","2022-03-31"]
[]
[null,null,"通期期間",{"$f":"MIN(D30:D41)","v":"2021-04-01"},{"$f":"MAX(E30:E41)","v":"2022-03-31"},null,null,null,null,null,null,null,"2) 今、「会計帳簿.xlsm」と「XXXXXXC_会計帳簿.xlsm」の２つのファイルが開かれているはずです。「会計帳簿.xlsm」を閉じてください。"]
[]
[null,"1-<3>-4","前年度末の現金及び普通預金の残高を登録します。"]
[null,null,"前年度末現金",0,"円",null,null,null,null,null,null,null,"3)「XXXXXXC_会計帳簿.xlsm」ファイルの「説明」シートのこの位置から、以下のバックアップDを実行ください。"]
[null,null,"前年度末普通預金",1925396,"円"]
[]
[null,"1-<3>-5","バックアップファイルAを作成します。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"4)「XXXXXXC_会計帳簿.xlsm」を閉じてください。"]
[null,"年度初めの準備は以上です。",null,null,null,null,null,null,null,null,null,null,"5)「会計帳簿.xlsm」を削除してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null,"6)「XXXXXXC_会計帳簿.xlsm」の名前を「会計帳簿.xlsm」へ変更してください。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"7)1-<1>または2-<1>を再度行って下さい。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"4-<6>使い始めた後で、科目名や細分類名を変更することが出来ますか？"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"→できます。科目細分類表」シートに手順があります。"]

{"sheet":"伝票作成","index":2,"n_rows":32,"n_cols":32,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,3,20,5],[21,3,21,5],[29,3,29,9],[25,3,25,9],[32,1,39,10],[2,3,2,4],[21,8,21,10],[22,8,22,10],[22,3,22,5],[28,3,28,9],[4,1,4,3],[6,1,6,3],[18,8,18,10],[19,8,19,10],[20,8,20,10],[8,1,8,5],[8,6,8,10],[26,3,26,9],[27,3,27,9],[18,3,18,5],[19,3,19,5]]}
[null,{"$f":"IF(F16 <> K16,\"記入にエラーがあります。訂正してからPDF作成してください。\",\"\")","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,1]
[null,"伝票入力は出納簿で行います。ここでは伝票Noだけを入力します。"]
[null,null,null,{"$f":"説明!C24","v":"A自治会"},null,null,"会計伝票"]
[null,{"$f":"説明!D26","v":2021},null,"年度",null,null,null,null,null,"会長印","会計印"]
[null,"伝票No",null,null,1]
[null,null,null,null,{"$f":"IF(AND(E7>=start_date,E7<=end_date),\"\",\"この伝票Noは古い年度で使われたままです！\")","v":""}]
[null,"計上日",null,null,{"$f":"INDEX(debit_allitems,MATCH(slip_no,debit_slip_no,0),1)","v":"2021-04-01"}]
[]
[null,"借　方",null,null,null,null,"貸　方"]
[null,"行番","No番号","科目G","科　目","金額(円)","行番","No番号","科目G","科　目","金額(円)"]
[null,1,{"$f":"slip_no&B11","v":"11"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),1),\"\")","v":"-"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),2),\"\")","v":"施設費"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),4),\"\")","v":21902},1,{"$f":"slip_no&G11","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),1),\"\")","v":"-"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),2),\"\")","v":"普通預金"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),4),\"\")","v":34365}]
[null,2,{"$f":"slip_no&B12","v":"12"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),1),\"\")","v":"-"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),2),\"\")","v":"施設費"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),4),\"\")","v":12463},2,{"$f":"slip_no&G12","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),1),\"\")","v":"-"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),2),\"\")","v":"普通預金"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),4),\"\")","v":0}]
[null,3,{"$f":"slip_no&B13","v":"13"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),4),\"\")","v":""},3,{"$f":"slip_no&G13","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),4),\"\")","v":""}]
[null,4,{"$f":"slip_no&B14","v":"14"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),4),\"\")","v":""},4,{"$f":"slip_no&G14","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),4),\"\")","v":""}]
[null,5,{"$f":"slip_no&B15","v":"15"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),4),\"\")","v":""},5,{"$f":"slip_no&G15","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),4),\"\")","v":""}]
[null,null,null,null,"計",{"$f":"SUM(F11:F15)","v":34365},null,null,null,"計",{"$f":"SUM(K11:K15)","v":34365}]
[]
[null,null,null,"借方細分類",null,null,null,null,"貸方細分類"]
[null,1,{"$f":"C11","v":"11"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C19,debit_chain,0),3),\"\")","v":"公民館管理費"},null,null,1,{"$f":"H11","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H19,debit_chain,0),3),\"\")","v":"振替支払"}]
[null,2,{"$f":"C12","v":"12"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C20,debit_chain,0),3),\"\")","v":"防犯灯維持費"},null,null,2,{"$f":"H12","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H20,debit_chain,0),3),\"\")","v":"振込支払"}]
[null,3,{"$f":"C13","v":"13"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C21,debit_chain,0),3),\"\")","v":""},null,null,3,{"$f":"H13","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H21,debit_chain,0),3),\"\")","v":""}]
[null,4,{"$f":"C14","v":"14"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C22,debit_chain,0),3),\"\")","v":""},null,null,4,{"$f":"H14","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H22,debit_chain,0),3),\"\")","v":""}]
[null,5,{"$f":"C15","v":"15"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C23,debit_chain,0),3),\"\")","v":""},null,null,5,{"$f":"H15","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H23,debit_chain,0),3),\"\")","v":""}]
[]
[null,"摘要"]
[null,1,{"$f":"slip_no&B26","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C26,debit_chain,0),5),\"\")","v":"3月分電気料/振替支払　A公民館/2口　従量電灯B/3基"},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C26,debit_chain,0),6),\"\")","v":"（連）"}]
[null,2,{"$f":"slip_no&B27","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C27,debit_chain,0),5),\"\")","v":"3月分電気料/振替支払　街路灯/103基"},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C27,debit_chain,0),6),\"\")","v":0}]
[null,3,{"$f":"slip_no&B28","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C28,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C28,debit_chain,0),6),\"\")","v":""}]
[null,4,{"$f":"slip_no&B29","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C29,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C29,debit_chain,0),6),\"\")","v":""}]
[null,5,{"$f":"slip_no&B30","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C30,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C30,debit_chain,0),6),\"\")","v":""}]
[]
[null,"説明/備考"]

{"sheet":"出納簿","index":3,"n_rows":144,"n_cols":55,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,42,0,46],[2,18,6,18],[2,19,6,19],[2,20,6,20],[2,24,6,24],[2,25,6,25],[1,30,6,30],[2,26,6,26],[2,27,6,27],[2,28,6,28],[2,23,6,23],[0,16,0,29],[4,42,4,46],[1,40,1,41],[3,38,6,38],[3,39,6,39],[1,1,1,2],[4,47,4,52],[4,0,6,0],[4,3,4,7],[4,8,4,13],[2,29,6,29],[2,16,6,16],[2,17,6,17],[2,21,6,21],[2,22,6,22],[1,3,1,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"解説↗",null,null,"コントロールデータ",null,null,null,null,null,null,null,null,null,null,null,null,null,"合計金額表示方法判定フラグ",2,null,"借方対象期間合計金額","借方対象科目合計金額","貸方対象期間合計金額","貸方対象科目合計金額","伝票削除フラグ"]
[null,{"$f":"説明!C24","v":"A自治会"},null,"出納簿兼仕訳帳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"選択2 選択3-1",null,null,null,"選択3-2 選択5",null,null,"選択4",null,"選択1",null,"合計判定フラグに対応する合計額の結果","伝票データ入力",1,0,0,0,0,null,"削除開始日","削除終了日",{"$f":"説明!C24","v":"A自治会"},null,"出納簿　兼　総勘定元帳",null,null,null,{"$f":"B3","v":2021},"年度",null,null,null,null,null,{"$f":"TODAY()","v":"2022-11-10"}]
[null,{"$f":"説明!D26","v":2021},"年度",null,"期間","2021-04-01",null,"2021-10-31",null,null,null,null,null,null,null,null,"借方チェーン番号","貸方チェーン番号","印刷行の指定\nA+B+C+D","対象期間全科目 A","借方と貸方が同じ B","科目が借方科目に一致、但し科目が空欄の場合はN  C","科目が貸方科目に一致,但し科目が空欄の場合はN  D","対象科目が借方または貸方に一致","対象期間対象科目借方金額合計","対象期間対象科目貸方金額合計","a 処理日が範囲内はA、範囲外はB、未入力はC","b 伝票Noが最大の行に1マークが入る。","aがAかつbが1の場合はY、そうでない場合でaがCならY、違う場合N","借方科目または貸方科目が空欄",null,"対象期間全科目",2,{"$f":"SUMIF(print_judge_date,\"=Y\",debit_sum_2)","v":12747204},0,{"$f":"SUMIF(print_judge_date,\"=Y\",credit_sum_2)","v":12747204},0,null,{"$f":"IF(説明!C16=\"\",\"\",説明!C16)","v":""},{"$f":"IF(説明!D16=\"\",\"\",説明!D16)","v":""},null,null,null,"対象期間",{"$f":"IF(from_date_2<>\"\",from_date_2,\"\")","v":"2021-04-01"},"〜",{"$f":"IF(to_date_2<>\"\",to_date_2,\"\")","v":"2021-10-31"}]
[null,null,null,null,"科目G",{"$f":"IFERROR(VLOOKUP(H4,g_kamoku,2,FALSE),\"\")","v":""},"科目",null,null,null,null,null,"借方-貸方=",{"$f":"G7-M7","v":0},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"対象期間対象科目",3,0,{"$f":"SUMIFS(debit_sum_2,print_judge_date,\"Y\",debit_select,\"Y\")","v":0},0,{"$f":"SUMIFS(credit_sum_2,print_judge_date,\"Y\",credit_select,\"Y\")","v":0},null,null,null,null,null,null,"科目G",{"$f":"list_kamoku_2","v":""},"科目",{"$f":"H4","v":0},null,null,null,null,"借方-貸方=",{"$f":"N4","v":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,null,null,null,null,"全期間全科目",4,{"$f":"SUMIF(process_date,\"=Y\",debit_sum_2)","v":0},0,{"$f":"SUMIF(process_date,\"=Y\",credit_sum_2)","v":0},0,null,null,null,null,null,"借　方",null,null,null,null,"貸　方"]
[null,null,null,null,null,"期間合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,2,FALSE),\"\")","v":12747204},"円",null,null,null,"期間合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,4,FALSE),\"\")","v":12747204},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全期間対象科目",5,{"$f":"SUMIF(process_date,\"=Y\",debit_sum_2)","v":0},{"$f":"SUMIF(debit_select,\"=Y\",debit_sum_2)","v":0},{"$f":"SUMIF(process_date,\"=Y\",credit_sum_2)","v":0},{"$f":"SUMIF(credit_select,\"=Y\",credit_sum_2)","v":0},null,null,null,null,null,null,null,"期間合計金額",{"$f":"G6","v":12747204},"円",null,null,null,"期間合計金額",{"$f":"M6","v":12747204},"円"]
[null,null,null,null,null,"科目合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,3,FALSE),\"\")","v":0},"円",null,null,null,"科目合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,5,FALSE),\"\")","v":0},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,"科目合計金額",{"$f":"G7","v":0},"円",null,null,null,"科目合計金額",{"$f":"M7","v":0},"円",null,"（複）複式 (連）連記式"]
[null,"計上日","伝No","行No","科目G","科目名（選択）","細分類（選択）","金額(円)","伝No","行No","科目G","科目名（選択）","細分類（選択）","金額(円)","摘要","補足","&","&",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"計上日","伝票No.","行番","科目G","科目名","細分類","金額","伝票No.","行番","科目G","科目名","細分類","金額","摘要","補足"]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K9),_xlfn.ISFORMULA(E9),_xlfn.ISFORMULA(Q9:AD9),_xlfn.ISFORMULA(AL9),_xlfn.ISFORMULA(AO9:BC9)),\"可\",\"不可\")","v":"可"},"2021-04-01",1,1,{"$f":"IFERROR(VLOOKUP(F9,g_kamoku,2,FALSE),\"\")","v":"-"},"施設費","公民館管理費",21902,{"$f":"C9","v":1},{"$f":"D9","v":1},{"$f":"IFERROR(VLOOKUP(L9,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","振替支払",34365,"3月分電気料/振替支払　A公民館/2口　従量電灯B/3基","（連）",{"$f":"C9&D9","v":"11"},{"$f":"I9&J9","v":"11"},{"$f":"T9&U9&V9&W9","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B9,to_date_2>=B9),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F9=L9,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F9=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L9=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V9=\"Y\",W9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X9=\"Y\",V9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X9=\"Y\",W9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B9>=start_date,B9<=end_date),\"A\",IF(B9=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C9,0),\"\")","v":""},{"$f":"IF(AND(AA9=\"A\",AB9<>\"\"),\"Y\",IF(AA9=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F9=\"\",L9=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,{"$f":"IF(OR(delete_start_date=\"\",delete_end_date=\"\"),\"\",IF(AND(B9>=delete_start_date,B9<=delete_end_date),\"1\",\"\"))","v":""},null,null,{"$f":"B9","v":"2021-04-01"},1,1,{"$f":"IF(E9=0,\"\",E9)","v":"-"},{"$f":"IF(F9=0,\"\",F9)","v":"施設費"},{"$f":"IF(G9=0,\"\",G9)","v":"公民館管理費"},{"$f":"IF(H9=0,\"\",H9)","v":21902},1,1,{"$f":"IF(K9=0,\"\",K9)","v":"-"},"普通預金","振替支払",34365,"3月分電気料/振替支払　A公民館/2口　従量電灯B/3基","（連）"]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K10),_xlfn.ISFORMULA(E10),_xlfn.ISFORMULA(Q10:AD10),_xlfn.ISFORMULA(AL10),_xlfn.ISFORMULA(AO10:BC10)),\"可\",\"不可\")","v":"可"},"2021-04-01",1,2,"-","施設費","防犯灯維持費",12463,{"$f":"C10","v":1},{"$f":"D10","v":2},{"$f":"IFERROR(VLOOKUP(L10,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","振込支払",0,"3月分電気料/振替支払　街路灯/103基",null,"12","12",{"$f":"T10&U10&V10&W10","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B10,to_date_2>=B10),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F10=L10,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(OR(V10=\"Y\",W10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X10=\"Y\",V10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X10=\"Y\",W10=\"Y\"),\"Y\",\"N\")","v":"N"},"A",{"$f":"IFERROR(MATCH(MAX(slip),C10,0),\"\")","v":""},{"$f":"IF(AND(AA10=\"A\",AB10<>\"\"),\"Y\",IF(AA10=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F10=\"\",L10=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B10","v":"2021-04-01"},{"$f":"C10","v":1},{"$f":"D10","v":2},{"$f":"IF(E10=0,\"\",E10)","v":"-"},{"$f":"IF(F10=0,\"\",F10)","v":"施設費"},{"$f":"IF(G10=0,\"\",G10)","v":"防犯灯維持費"},{"$f":"IF(H10=0,\"\",H10)","v":12463},{"$f":"I10","v":1},{"$f":"J10","v":2},{"$f":"IF(K10=0,\"\",K10)","v":"-"},{"$f":"IF(L10=0,\"\",L10)","v":"普通預金"},{"$f":"IF(M10=0,\"\",M10)","v":"振込支払"},{"$f":"IF(N10=0,\"\",N10)","v":""},{"$f":"IF(O10=0,\"\",O10)","v":"3月分電気料/振替支払　街路灯/103基"},{"$f":"IF(P10=0,\"\",P10)","v":""}]
["可","2021-04-05",2,1,{"$f":"IFERROR(VLOOKUP(F11,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","振込入金",6210,2,1,{"$f":"IFERROR(VLOOKUP(L11,g_kamoku,2,FALSE),\"\")","v":"-"},"会費","月払いアパート会費",6210,"XXXX月払いアパート会費　振込入金",null,"21","21","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-05",2,1,"-","普通預金","振込入金",6210,2,1,"-","会費","月払いアパート会費",6210,"XXXX月払いアパート会費　振込入金",""]
["可","2021-04-06",3,1,"-","雑費","保険料",93720,3,1,"-","普通預金","振込支払",93720,"自治会活動保険支払い（XX自治会連合会宛て）",null,"31","31","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-06",3,1,"-","雑費","保険料",93720,3,1,"-","普通預金","振込支払",93720,"自治会活動保険支払い（XX自治会連合会宛て）",""]
["可","2021-04-06",4,1,"-","雑費","振込手数料",880,4,1,"-","普通預金","銀行手数料",880,"振込手数料　自治会活動保険振込 　XX銀行宛て",null,"41","41","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-06",4,1,"-","雑費","振込手数料",880,4,1,"-","普通預金","銀行手数料",880,"振込手数料　自治会活動保険振込 　XX銀行宛て",""]
["可","2021-04-11",5,1,"-","現金","-",320000,5,1,"-","会費","一般世帯会費",320000,"4-1XXXX班長より現金受領 一般世帯一括40世帯",null,"51","51","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-11",5,1,"-","現金","-",320000,5,1,"-","会費","一般世帯会費",320000,"4-1XXXX班長より現金受領 一般世帯一括40世帯",""]
["可","2021-04-12",6,1,"-","現金","-",8000,6,1,"-","普通預金","現金払出",8000,"香典2件分",null,"61","61","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",6,1,"-","現金","-",8000,6,1,"-","普通預金","現金払出",8000,"香典2件分",""]
["可","2021-04-12",7,1,"-","普通預金","現金預入",320000,7,1,"-","現金","-",320000,"4-1班XXXX班長　自治会費　預入",null,"71","71","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",7,1,"-","普通預金","現金預入",320000,7,1,"-","現金","-",320000,"4-1班XXXX班長　自治会費　預入",""]
["可","2021-04-12",8,1,"-","負担金","緑の募金",25000,8,1,"-","普通預金","振込支払",25000,"緑の募金運動（XX市緑化推進本部あて）50円x500世帯　対予算：同",null,"81","81","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",8,1,"-","負担金","緑の募金",25000,8,1,"-","普通預金","振込支払",25000,"緑の募金運動（XX市緑化推進本部あて）50円x500世帯　対予算：同",""]
["可","2021-04-12",9,1,"-","雑費","振込手数料",660,9,1,"-","普通預金","銀行手数料",660,"振込手数料　緑の募金振込",null,"91","91","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",9,1,"-","雑費","振込手数料",660,9,1,"-","普通預金","銀行手数料",660,"振込手数料　緑の募金振込",""]
["可","2021-04-12",10,1,"-","雑費","慶弔費",4000,10,1,"-","現金","-",8000,"1班XXXX様(79)ご香典　4月5日逝去　仏式　喪主XXXX（長男）　自治会3,000円　民生委員1,000円","（連）","101","101","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",10,1,"-","雑費","慶弔費",4000,10,1,"-","現金","-",8000,"1班XXXX様(79)ご香典　4月5日逝去　仏式　喪主XXXX（長男）　自治会3,000円　民生委員1,000円","（連）"]
["可","2021-04-12",10,2,"-","雑費","慶弔費",4000,10,2,"-","現金","-",null,"1班XXXX様(80)ご香典　4月3日逝去　仏式　喪主XXXX（子）　自治会3,000円　民生委員1,000円",null,"102","102","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",10,2,"-","雑費","慶弔費",4000,10,2,"-","現金","-","","1班XXXX様(80)ご香典　4月3日逝去　仏式　喪主XXXX（子）　自治会3,000円　民生委員1,000円",""]
["可","2021-04-12",11,1,"-","現金","-",7668,11,1,"-","普通預金","現金払出",7668,"文具8点 立替分",null,"111","111","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",11,1,"-","現金","-",7668,11,1,"-","普通預金","現金払出",7668,"文具8点 立替分",""]
["可","2021-04-12",12,1,"-","事務費","-",2167,12,1,"-","現金","-",7668,"ホワイトコピー用紙代（XXXX立替）エプソンインク（XXXX立替）","（連）","121","121","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",12,1,"-","事務費","-",2167,12,1,"-","現金","-",7668,"ホワイトコピー用紙代（XXXX立替）エプソンインク（XXXX立替）","（連）"]
["可","2021-04-12",12,2,"-","事務費","-",340,12,2,"-","現金","-",0,"公民館管理委員当番表印刷　アパート自治会費納入依頼印刷　",null,"122","122","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",12,2,"-","事務費","-",340,12,2,"-","現金","-","","公民館管理委員当番表印刷　アパート自治会費納入依頼印刷　",""]
["可","2021-04-12",12,3,"-","事務費","-",4033,12,3,"-","現金","-",null,"切手7枚　ポストイット　7cmファイル2冊",null,"123","123","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",12,3,"-","事務費","-",4033,12,3,"-","現金","-","","切手7枚　ポストイット　7cmファイル2冊",""]
["可","2021-04-12",12,4,"-","事務費","-",1128,12,4,"-","現金","-",null,"PC用マウス",null,"124","124","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",12,4,"-","事務費","-",1128,12,4,"-","現金","-","","PC用マウス",""]
["可","2021-04-12",13,1,"-","現金","-",113880,13,1,"-","普通預金","現金払出",113880,"PC、プリンタ購入分　立替分",null,"131","131","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",13,1,"-","現金","-",113880,13,1,"-","普通預金","現金払出",113880,"PC、プリンタ購入分　立替分",""]
["可","2021-04-12",14,1,"-","事務費","-",84980,14,1,"-","現金","-",113880,"パソコンNEC LAVIE Smart N15 XXXX（Amazonで購入）","（連）","141","141","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",14,1,"-","事務費","-",84980,14,1,"-","現金","-",113880,"パソコンNEC LAVIE Smart N15 XXXX（Amazonで購入）","（連）"]
["可","2021-04-12",14,2,"-","事務費","-",28900,14,2,"-","現金","-",null,"エプソンプリンタ　エコタンク　A4モノクロXXXX",null,"142","142","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",14,2,"-","事務費","-",28900,14,2,"-","現金","-","","エプソンプリンタ　エコタンク　A4モノクロXXXX",""]
["可","2021-04-12",15,1,"-","現金","-",376000,15,1,"-","会費","一般世帯会費",330000,"5-1班　XXXX班長より　現金受領  一括35人*8,000円 前期分10人*5,000円","（連）","151","151","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",15,1,"-","現金","-",376000,15,1,"-","会費","一般世帯会費",330000,"5-1班　XXXX班長より　現金受領  一括35人*8,000円 前期分10人*5,000円","（連）"]
["可","2021-04-12",15,2,"-","現金","-",0,15,2,"-","会費","自治会協力金",46000,"5-1班　XXXX班長より　協力金（XXXX8,000円　XXXX30,000円　XXXX8,000円)",null,"152","152","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-12",15,2,"-","現金","-","",15,2,"-","会費","自治会協力金",46000,"5-1班　XXXX班長より　協力金（XXXX8,000円　XXXX30,000円　XXXX8,000円)",""]
["可","2021-04-13",16,1,"-","普通預金","現金預入",376000,16,1,"-","現金","-",376000,"5-1班自治会費　現金預入",null,"161","161","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",16,1,"-","普通預金","現金預入",376000,16,1,"-","現金","-",376000,"5-1班自治会費　現金預入",""]
["可","2021-04-13",17,1,"-","現金","-",30000,17,1,"-","普通預金","現金払出",30000,"小口現金の確保",null,"171","171","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",17,1,"-","現金","-",30000,17,1,"-","普通預金","現金払出",30000,"小口現金の確保",""]
["可","2021-04-13",18,1,"-","施設費","防犯灯維持費",121,18,1,"-","現金","コンビニ振込",121,"公衆街路灯A/1基 A自治会12ケ384　2/19~3/18分",null,"181","181","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",18,1,"-","施設費","防犯灯維持費",121,18,1,"-","現金","コンビニ振込",121,"公衆街路灯A/1基 A自治会12ケ384　2/19~3/18分",""]
["可","2021-04-13",19,1,"-","現金","-",56000,19,1,"-","会費","アパート世帯会費",56000,"XXXXさん コーポXXXX月払いアパート年間分７世帯",null,"191","191","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",19,1,"-","現金","-",56000,19,1,"-","会費","アパート世帯会費",56000,"XXXXさん コーポXXXX月払いアパート年間分７世帯",""]
["可","2021-04-13",20,1,"-","普通預金","現金預入",56000,20,1,"-","現金","-",56000,"XXXXさん 預入",null,"201","201","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",20,1,"-","普通預金","現金預入",56000,20,1,"-","現金","-",56000,"XXXXさん 預入",""]
["可","2021-04-13",21,1,"-","事務費","-",376,21,1,"-","現金","-",376,"領収書綴り#778 1冊",null,"211","211","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",21,1,"-","事務費","-",376,21,1,"-","現金","-",376,"領収書綴り#778 1冊",""]
["可","2021-04-13",22,1,"-","事務費","-",547,22,1,"-","その他","未払金",547,"DCMラベルシート44面 XXXXさん立替",null,"221","221","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-13",22,1,"-","事務費","-",547,22,1,"-","その他","未払金",547,"DCMラベルシート44面 XXXXさん立替",""]
["可","2021-04-15",23,1,"-","施設費","公民館管理費",1452,23,1,"-","普通預金","振替支払",1452,"XX市上下水道料",null,"231","231","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-15",23,1,"-","施設費","公民館管理費",1452,23,1,"-","普通預金","振替支払",1452,"XX市上下水道料",""]
["可","2021-04-15",24,1,"-","普通預金","振込入金",8000,24,1,"-","会費","アパート世帯会費",8000,"自治会費XXXXさん（XXXX）月払いアパート年間分1世帯",null,"241","241","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-15",24,1,"-","普通預金","振込入金",8000,24,1,"-","会費","アパート世帯会費",8000,"自治会費XXXXさん（XXXX）月払いアパート年間分1世帯",""]
["可","2021-04-15",25,1,"-","事務費","-",84,25,1,"-","現金","-",84,"XXXXさん自治会費領収書送付切手1枚@84",null,"251","251","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-15",25,1,"-","事務費","-",84,25,1,"-","現金","-",84,"XXXXさん自治会費領収書送付切手1枚@84",""]
["可","2021-04-15",26,1,"-","現金","-",5000,26,1,"-","会費","アパート世帯会費",5000,"XXXXさん（XXXX）から直接受け取り　アパート世帯前期分1世帯",null,"261","261","YNNN","Y","N",{"$f":"IF(AND(kamoku_name<>\"\",F41=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L41=kamoku_name),\"Y\",\"N\")","v":"N"},"N","N","N",{"$f":"IF(AND(B41>=start_date,B41<=end_date),\"A\",IF(B41=\"\",\"C\",\"B\"))","v":"A"},"","N","N",null,null,null,null,null,null,null,{"$f":"IF(OR(delete_start_date=\"\",delete_end_date=\"\"),\"\",IF(AND(B41>=delete_start_date,B41<=delete_end_date),\"1\",\"\"))","v":""},null,null,"2021-04-15",26,1,"-","現金","-",5000,26,1,"-","会費","アパート世帯会費",5000,"XXXXさん（XXXX）から直接受け取り　アパート世帯前期分1世帯",""]
["可","2021-04-17",27,1,"-","現金","-",176000,27,1,"-","会費","一般世帯会費",176000,"5-2班　XXXX班長より自治会費受領　一般世帯 一括22世帯",null,"271","271","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-17",27,1,"-","現金","-",176000,27,1,"-","会費","一般世帯会費",176000,"5-2班　XXXX班長より自治会費受領　一般世帯 一括22世帯",""]
["可","2021-04-19",28,1,{"$f":"IFERROR(VLOOKUP(F43,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","現金預入",181000,28,1,"-","現金","-",181000,"5-2班　XXXXさん　自治会費　預入　",null,"281","281","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-19",28,1,"-","普通預金","現金預入",181000,28,1,"-","現金","-",181000,"5-2班　XXXXさん　自治会費　預入　",""]
["可","2021-04-19",29,1,"-","現金","-",8000,29,1,"-","会費","自治会協力金",8000,"XX病院　協力金 受け取り　協力金受領書渡し済み",null,"291","291","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-19",29,1,"-","現金","-",8000,29,1,"-","会費","自治会協力金",8000,"XX病院　協力金 受け取り　協力金受領書渡し済み",""]
["可","2021-04-19",30,1,"-","普通預金","振込入金",8000,30,1,"-","会費","アパート世帯会費",8000,"XXX　XXXXガーデン　振込入金",null,"301","301","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-19",30,1,"-","普通預金","振込入金",8000,30,1,"-","会費","アパート世帯会費",8000,"XXX　XXXXガーデン　振込入金",""]
["可","2021-04-19",31,1,{"$f":"IFERROR(VLOOKUP(F46,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","現金預入",8000,31,1,"-","現金","-",8000,"XX病院　協力金 預入",null,"311","311","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-19",31,1,"-","普通預金","現金預入",8000,31,1,"-","現金","-",8000,"XX病院　協力金 預入",""]
["可","2021-04-19",32,1,"-","事務費","-",180,32,1,"-","現金","-",180,"河川清掃提案資料作成　河川の写真PDF印刷",null,"321","321","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-19",32,1,"-","事務費","-",180,32,1,"-","現金","-",180,"河川清掃提案資料作成　河川の写真PDF印刷",""]
["可","2021-04-21",33,1,"-","現金","-",168000,33,1,"-","会費","一般世帯会費",168000,"7-2班　XXXX班長　一般世帯 一括21世帯","（複）","331","331","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",33,1,"-","現金","-",168000,33,1,"-","会費","一般世帯会費",168000,"7-2班　XXXX班長　一般世帯 一括21世帯","（複）"]
["可","2021-04-21",33,2,"-","普通預金","現金預入",168000,33,2,"-","現金","-",168000,"7-2班 自治会費 一般世帯　預入",null,"332","332","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",33,2,"-","普通預金","現金預入",168000,33,2,"-","現金","-",168000,"7-2班 自治会費 一般世帯　預入",""]
["可","2021-04-21",34,1,"-","現金","-",254400,34,1,"-","会費","一般世帯会費",253000,"7-3班　XXXX班長　一般世帯一括31 世帯　一般世帯前期1世帯","（連）","341","341","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",34,1,"-","現金","-",254400,34,1,"-","会費","一般世帯会費",253000,"7-3班　XXXX班長　一般世帯一括31 世帯　一般世帯前期1世帯","（連）"]
["可","2021-04-21",34,2,"-","現金","-",0,34,2,"-","会費","転入出世帯会費",1400,"7-3班　XXXX班長　佐藤恵理子　一般世帯５月転出予定",null,"342","342","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",34,2,"-","現金","-","",34,2,"-","会費","転入出世帯会費",1400,"7-3班　XXXX班長　佐藤恵理子　一般世帯５月転出予定",""]
["可","2021-04-21",34,3,"-","普通預金","現金預入",254400,34,3,"-","現金","-",254400,"7-3班 自治会費 現金預入",null,"343","343","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",34,3,"-","普通預金","現金預入",254400,34,3,"-","現金","-",254400,"7-3班 自治会費 現金預入",""]
["可","2021-04-21",35,1,"-","普通預金","振込入金",40000,35,1,"-","会費","アパート世帯会費",40000,"XXXXハイム 4/20入金　8000X5  5000X8",null,"351","351","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-21",35,1,"-","普通預金","振込入金",40000,35,1,"-","会費","アパート世帯会費",40000,"XXXXハイム 4/20入金　8000X5  5000X8",""]
["可","2021-04-24",36,1,"-","事務費","-",130,36,1,"-","現金","-",130,"防災自主点検チェック表コピー13枚　セブンイレブン",null,{"$f":"C54&D54","v":"361"},{"$f":"I54&J54","v":"361"},"YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,{"$f":"B54","v":"2021-04-24"},{"$f":"C54","v":36},{"$f":"D54","v":1},"-","事務費","-",130,{"$f":"I54","v":36},{"$f":"J54","v":1},"-","現金","-",130,"防災自主点検チェック表コピー13枚　セブンイレブン",""]
["可","2021-04-24",37,1,"-","事務費","-",602,37,1,"-","現金","-",602,"DCM封筒角形2号100枚　4/16",null,"371","371","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-24",37,1,"-","事務費","-",602,37,1,"-","現金","-",602,"DCM封筒角形2号100枚　4/16",""]
["可","2021-04-24",38,1,"-","現金","-",3576000,38,1,"-","会費","一般世帯会費",3168000,"4/24班長会時集金　一般世帯　396世帯　一括396世帯　　","（連）","381","381","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-24",38,1,"-","現金","-",3576000,38,1,"-","会費","一般世帯会費",3168000,"4/24班長会時集金　一般世帯　396世帯　一括396世帯　　","（連）"]
["可","2021-04-24",38,2,"-","現金","-",0,38,2,"-","会費","アパート世帯会費",134000,"4/24班長会時集金　アパート世帯（代理集金）25世帯　うち一括19世帯104,000円　前期6世帯 30,000円　　",null,"382","382","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-24",38,2,"-","現金","-","",38,2,"-","会費","アパート世帯会費",134000,"4/24班長会時集金　アパート世帯（代理集金）25世帯　うち一括19世帯104,000円　前期6世帯 30,000円　　",""]
["可","2021-04-24",38,3,"-","現金","-",0,38,3,"-","会費","アパート世帯会費",50000,"4/24班長会時集金　アパート世帯(住民直接）　10世帯　前期10世帯",null,"383","383","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-24",38,3,"-","現金","-","",38,3,"-","会費","アパート世帯会費",50000,"4/24班長会時集金　アパート世帯(住民直接）　10世帯　前期10世帯",""]
["可","2021-04-24",38,4,"-","現金","-",0,38,4,"-","会費","自治会協力金",224000,"4/24班長会時集金　協力金　27会社　",null,"384","384","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-24",38,4,"-","現金","-","",38,4,"-","会費","自治会協力金",224000,"4/24班長会時集金　協力金　27会社　",""]
["可","2021-04-25",39,1,"-","普通預金","現金預入",3576000,39,1,"-","現金","-",3576000,"4/24班長会時集金　預金預入",null,"391","391","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-25",39,1,"-","普通預金","現金預入",3576000,39,1,"-","現金","-",3576000,"4/24班長会時集金　預金預入",""]
["可","2021-04-25",40,1,"-","施設費","公民館管理費",437,40,1,"-","現金","-",437,"公民館　障害者トイレ用ブラシ",null,"401","401","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-25",40,1,"-","施設費","公民館管理費",437,40,1,"-","現金","-",437,"公民館　障害者トイレ用ブラシ",""]
["可","2021-04-25",41,1,"-","普通預金","振込入金",128000,41,1,"-","会費","アパート世帯会費",128000,"XX不動産　 4/22",null,"411","411","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-25",41,1,"-","普通預金","振込入金",128000,41,1,"-","会費","アパート世帯会費",128000,"XX不動産　 4/22",""]
["可","2021-04-26",42,1,"-","施設費","防犯灯維持費",123,42,1,"-","現金","コンビニ振込",123,"公衆街路灯A/1基　A自治会12ケ384 3/19~4/20分",null,"421","421","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-26",42,1,"-","施設費","防犯灯維持費",123,42,1,"-","現金","コンビニ振込",123,"公衆街路灯A/1基　A自治会12ケ384 3/19~4/20分",""]
["可","2021-04-27",43,1,"-","施設費","公民館管理費",1895,43,1,"-","普通預金","振替支払",1895,"3月ガス代　XX産業",null,"431","431","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-27",43,1,"-","施設費","公民館管理費",1895,43,1,"-","普通預金","振替支払",1895,"3月ガス代　XX産業",""]
["可","2021-04-28",44,1,"-","負担金","XX地区自治会連合会",63000,44,1,"-","普通預金","振込支払",63000,"令和3年度会費納入　100円X630世帯　対予算：同",null,"441","441","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-28",44,1,"-","負担金","XX地区自治会連合会",63000,44,1,"-","普通預金","振込支払",63000,"令和3年度会費納入　100円X630世帯　対予算：同",""]
["可","2021-04-28",45,1,"-","雑費","振込手数料",880,45,1,"-","普通預金","銀行手数料",880,"伝票No.44 会費納入　XXバンク→XX銀行",null,"451","451","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-28",45,1,"-","雑費","振込手数料",880,45,1,"-","普通預金","銀行手数料",880,"伝票No.44 会費納入　XXバンク→XX銀行",""]
["可","2021-04-29",46,1,"-","その他","未払金",547,46,1,"-","現金","-",547,"XXさん立替の清算　伝票No22",null,"461","461","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-04-29",46,1,"-","その他","未払金",547,46,1,"-","現金","-",547,"XXさん立替の清算　伝票No22",""]
["可","2021-05-04",47,1,"-","事務費","-",20,47,1,"-","現金","-",20,"6-1班　8-1班の会費集金管理表のコピー代",null,"471","471","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-04",47,1,"-","事務費","-",20,47,1,"-","現金","-",20,"6-1班　8-1班の会費集金管理表のコピー代",""]
["可","2021-05-04",48,1,"-","雑費","慶弔費",4000,48,1,"-","現金","-",4000,"4-3班XXXX様(88)ご香典　5月3日逝去　仏式　 喪主XXXX（子）自治会3,000円　民生委員1,000円",null,"481","481","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-04",48,1,"-","雑費","慶弔費",4000,48,1,"-","現金","-",4000,"4-3班XXXX様(88)ご香典　5月3日逝去　仏式　 喪主XXXX（子）自治会3,000円　民生委員1,000円",""]
["可","2021-05-04",49,1,"-","事務費","-",220,49,1,"-","現金","-",220,"御香典袋　10枚x2=20枚",null,"491","491","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-04",49,1,"-","事務費","-",220,49,1,"-","現金","-",220,"御香典袋　10枚x2=20枚",""]
["可","2021-05-06",50,1,"-","普通預金","振込入金",17260,50,1,{"$f":"IFERROR(VLOOKUP(L71,g_kamoku,2,FALSE),\"\")","v":"-"},"会費","月払いアパート会費",17260,"5/6 XXXX 月払いアパート会費　",null,"501","501","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-06",50,1,"-","普通預金","振込入金",17260,50,1,"-","会費","月払いアパート会費",17260,"5/6 XXXX 月払いアパート会費　",""]
["可","2021-05-06",51,1,"-","負担金","第４防災会",252000,51,1,"-","普通預金","振込支払",252000,"第X防災会　自治会防災金　400円x630世帯252,000円(予算同）",null,"511","511","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-06",51,1,"-","負担金","第４防災会",252000,51,1,"-","普通預金","振込支払",252000,"第X防災会　自治会防災金　400円x630世帯252,000円(予算同）",""]
["可","2021-05-06",52,1,"-","雑費","振込手数料",880,52,1,"-","普通預金","銀行手数料",880,"伝票no51 XX銀行　振込手数料",null,"521","521","YNNN","Y","N",{"$f":"IF(AND(kamoku_name<>\"\",F73=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L73=kamoku_name),\"Y\",\"N\")","v":"N"},"N","N","N",{"$f":"IF(AND(B73>=start_date,B73<=end_date),\"A\",IF(B73=\"\",\"C\",\"B\"))","v":"A"},"","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-06",52,1,"-","雑費","振込手数料",880,52,1,"-","普通預金","銀行手数料",880,"伝票no51 XX銀行　振込手数料",""]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K74),_xlfn.ISFORMULA(E74),_xlfn.ISFORMULA(Q74:AD74),_xlfn.ISFORMULA(AL74),_xlfn.ISFORMULA(AO74:BC74)),\"可\",\"不可\")","v":"可"},"2021-05-09",53,1,"-","施設費","公民館管理費",486,{"$f":"C74","v":53},{"$f":"D74","v":1},"-","現金","-",486,"公民館　トイレの洗剤　３点　デイツー",null,"531","531",{"$f":"T74&U74&V74&W74","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B74,to_date_2>=B74),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F74=L74,\"Y\",\"N\")","v":"N"},"N","N",{"$f":"IF(OR(V74=\"Y\",W74=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X74=\"Y\",V74=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X74=\"Y\",W74=\"Y\"),\"Y\",\"N\")","v":"N"},"A",{"$f":"IFERROR(MATCH(MAX(slip),C74,0),\"\")","v":""},{"$f":"IF(AND(AA74=\"A\",AB74<>\"\"),\"Y\",IF(AA74=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F74=\"\",L74=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,{"$f":"IF(OR(delete_start_date=\"\",delete_end_date=\"\"),\"\",IF(AND(B74>=delete_start_date,B74<=delete_end_date),\"1\",\"\"))","v":""},null,null,"2021-05-09",53,1,{"$f":"IF(E74=0,\"\",E74)","v":"-"},{"$f":"IF(F74=0,\"\",F74)","v":"施設費"},{"$f":"IF(G74=0,\"\",G74)","v":"公民館管理費"},{"$f":"IF(H74=0,\"\",H74)","v":486},53,1,{"$f":"IF(K74=0,\"\",K74)","v":"-"},{"$f":"IF(L74=0,\"\",L74)","v":"現金"},{"$f":"IF(M74=0,\"\",M74)","v":"-"},{"$f":"IF(N74=0,\"\",N74)","v":486},"公民館　トイレの洗剤　３点　デイツー",{"$f":"IF(P74=0,\"\",P74)","v":""}]
["可","2021-05-09",54,1,"-","雑費","慶弔費",4000,54,1,{"$f":"IFERROR(VLOOKUP(L75,g_kamoku,2,FALSE),\"\")","v":"-"},"現金","-",4000,"7-3班 XXXX(91)様ご香典　5月9日逝去　仏式　喪主XXXX（子）　自治会3,000円　民生委員1,000円",null,"541","541","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-09",54,1,"-","雑費","慶弔費",4000,54,1,"-","現金","-",4000,"7-3班 XXXX(91)様ご香典　5月9日逝去　仏式　喪主XXXX（子）　自治会3,000円　民生委員1,000円",""]
["可","2021-05-10",55,1,"-","負担金","国際交流協会",2000,55,1,{"$f":"IFERROR(VLOOKUP(L76,g_kamoku,2,FALSE),\"\")","v":"-"},"現金","郵便局振込",2000,"2021年度　XX国際交流協会会費納入　個人会員　",null,"551","551","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-10",55,1,"-","負担金","国際交流協会",2000,55,1,"-","現金","郵便局振込",2000,"2021年度　XX国際交流協会会費納入　個人会員　",""]
["可","2021-05-10",56,1,"-","事務費","-",2310,56,1,{"$f":"IFERROR(VLOOKUP(L77,g_kamoku,2,FALSE),\"\")","v":"-"},"現金","-",4069,"班長用書類保存用ファイル　21冊　Seria","（連）","561","561","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-10",56,1,"-","事務費","-",2310,56,1,"-","現金","-",4069,"班長用書類保存用ファイル　21冊　Seria","（連）"]
["可","2021-05-10",56,2,"-","事務費","-",1759,56,2,{"$f":"IFERROR(VLOOKUP(L78,g_kamoku,2,FALSE),\"\")","v":"-"},"現金","-",0,"書類コピー代　XXXX協働センター",null,"562","562","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-10",56,2,"-","事務費","-",1759,56,2,"-","現金","-","","書類コピー代　XXXX協働センター",""]
["可","2021-05-15",57,1,{"$f":"IFERROR(VLOOKUP(F79,g_kamoku,2,FALSE),\"\")","v":"-"},"施設費","公民館管理費",24370,57,1,{"$f":"IFERROR(VLOOKUP(L79,g_kamoku,2,FALSE),\"\")","v":"-"},"普通預金","振替支払",37039,"5/6 4月分中電電気料　A公民館/2口　従量電灯B/3基","（連）","571","571","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,{"$f":"IF(OR(delete_start_date=\"\",delete_end_date=\"\"),\"\",IF(AND(B79>=delete_start_date,B79<=delete_end_date),\"1\",\"\"))","v":""},null,null,"2021-05-15",57,1,"-","施設費","公民館管理費",24370,57,1,"-","普通預金","振替支払",37039,"5/6 4月分中電電気料　A公民館/2口　従量電灯B/3基","（連）"]
["可","2021-05-15",57,2,"-","施設費","防犯灯維持費",12669,57,2,"-","普通預金","振替支払",0,"5/6　４月分中電電気料　街路灯/103基",null,"572","572","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-15",57,2,"-","施設費","防犯灯維持費",12669,57,2,"-","普通預金","振替支払","","5/6　４月分中電電気料　街路灯/103基",""]
["可","2021-05-15",58,1,"-","現金","-",7000,58,1,"-","会費","一般世帯会費",7000,"1班　XXXX　自治会費　５月入居　６月－３月まで１０か月分（700x10) 7,000円",null,"581","581","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-15",58,1,"-","現金","-",7000,58,1,"-","会費","一般世帯会費",7000,"1班　XXXX　自治会費　５月入居　６月－３月まで１０か月分（700x10) 7,000円",""]
["可","2021-05-15",59,1,"-","現金","-",4250,59,1,"-","会費","アパート世帯会費",4250,"5-1班　XXXX201号室様　前期分",null,"591","591","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-15",59,1,"-","現金","-",4250,59,1,"-","会費","アパート世帯会費",4250,"5-1班　XXXX201号室様　前期分",""]
["可","2021-05-15",60,1,"-","事務費","-",4000,60,1,"-","現金","-",4000,"エプソンインク　ヤマダデンキ",null,"601","601","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-15",60,1,"-","事務費","-",4000,60,1,"-","現金","-",4000,"エプソンインク　ヤマダデンキ",""]
["可","2021-05-15",61,1,"-","施設費","防犯灯設置費・ＬＥＤ化工事費",11000,61,1,"-","現金","-",11000,"5/10 防犯灯移設工事　12コ723電柱移動工事　（XXXデンキ）",null,"611","611","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-15",61,1,"-","施設費","防犯灯設置費・ＬＥＤ化工事費",11000,61,1,"-","現金","-",11000,"5/10 防犯灯移設工事　12コ723電柱移動工事　（XXXデンキ）",""]
["可","2021-05-17",62,1,"-","負担金","明るい社会づくり",4000,62,1,"-","現金","-",4000,"明るい社会づくり運動　会費2,000円(2口)　横断バッグ寄付金2,000円（2口) (事務局長XXXX）",null,"621","621","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-17",62,1,"-","負担金","明るい社会づくり",4000,62,1,"-","現金","-",4000,"明るい社会づくり運動　会費2,000円(2口)　横断バッグ寄付金2,000円（2口) (事務局長XXXX）",""]
["可","2021-05-17",63,1,"-","負担金","XX地区社会福祉協議会",170100,63,1,"-","普通預金","振込支払",170100,"令和３年度　XXXX地区社会福祉協議会会費納入　270円 X 630世帯　= 170,100円（予算と同）",null,{"$f":"C86&D86","v":"631"},{"$f":"I86&J86","v":"631"},"YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,{"$f":"B86","v":"2021-05-17"},{"$f":"C86","v":63},{"$f":"D86","v":1},"-","負担金","XX地区社会福祉協議会",170100,{"$f":"I86","v":63},{"$f":"J86","v":1},"-","普通預金","振込支払",170100,"令和３年度　XXXX地区社会福祉協議会会費納入　270円 X 630世帯　= 170,100円（予算と同）",""]
["可","2021-05-17",64,1,"-","雑費","振込手数料",330,64,1,"-","普通預金","銀行手数料",330,"伝票No.63 XXXX地区社会福祉協議会会費納入　手数料",null,"641","641","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-17",64,1,"-","雑費","振込手数料",330,64,1,"-","普通預金","銀行手数料",330,"伝票No.63 XXXX地区社会福祉協議会会費納入　手数料",""]
["可","2021-05-17",65,1,"-","普通預金","振込入金",8000,65,1,"-","会費","自治会協力金",8000,"5/10振込　（株）XXXX",null,"651","651","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-17",65,1,"-","普通預金","振込入金",8000,65,1,"-","会費","自治会協力金",8000,"5/10振込　（株）XXXX",""]
["可","2021-05-18",66,1,"-","現金","-",30000,66,1,"-","普通預金","現金払出",30000,"小口現金の確保",null,"661","661","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-18",66,1,"-","現金","-",30000,66,1,"-","普通預金","現金払出",30000,"小口現金の確保",""]
["可","2021-05-18",67,1,"-","事務費","-",360,67,1,"-","現金","-",360,"DCM コピー用紙　A4  ケーヨーデイツー",null,"671","671","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-18",67,1,"-","事務費","-",360,67,1,"-","現金","-",360,"DCM コピー用紙　A4  ケーヨーデイツー",""]
["可","2021-05-23",68,1,"-","雑費","慶弔費",4000,68,1,"-","現金","-",4000,"3-1班 XXXX(96)様ご香典　5月23日逝去　仏式　喪主XXXX（妻）　自治会3,000円　民生委員1,000円",null,"681","681","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-23",68,1,"-","雑費","慶弔費",4000,68,1,"-","現金","-",4000,"3-1班 XXXX(96)様ご香典　5月23日逝去　仏式　喪主XXXX（妻）　自治会3,000円　民生委員1,000円",""]
["可","2021-05-23",69,1,"-","施設費","公民館管理費",765,69,1,"-","現金","-",765,"トイレットペーパー　フレリーピンク　ダブル18口 2個　@348 税10% 杏林堂",null,"691","691","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-23",69,1,"-","施設費","公民館管理費",765,69,1,"-","現金","-",765,"トイレットペーパー　フレリーピンク　ダブル18口 2個　@348 税10% 杏林堂",""]
["可","2021-05-24",70,1,"-","現金","-",765000,70,1,"-","普通預金","現金払出",765000,"5部会助成金用　預金払い出し　AA会180,000 BB会180,000 CC部155,000 DD会150,000 EE会100,000",null,"701","701","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-24",70,1,"-","現金","-",765000,70,1,"-","普通預金","現金払出",765000,"5部会助成金用　預金払い出し　AA会180,000 BB会180,000 CC部155,000 DD会150,000 EE会100,000",""]
["可","2021-05-24",71,1,"-","普通預金","振込入金",48000,71,1,"-","会費","アパート世帯会費",48000,"（株）XXXX",null,"711","711","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-24",71,1,"-","普通預金","振込入金",48000,71,1,"-","会費","アパート世帯会費",48000,"（株）XXXX",""]
["可","2021-05-24",72,1,"-","助成金","AA会助成金",180000,72,1,"-","現金","-",180000,"AA会会計　XXXXさん受領","（連）","721","721",{"$f":"T95&U95&V95&W95","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B95,to_date_2>=B95),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F95=L95,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F95=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L95=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V95=\"Y\",W95=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X95=\"Y\",V95=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X95=\"Y\",W95=\"Y\"),\"Y\",\"N\")","v":"N"},"A",{"$f":"IFERROR(MATCH(MAX(slip),C95,0),\"\")","v":""},"N",{"$f":"IF(OR(F95=\"\",L95=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,"2021-05-24",72,1,"-","助成金","AA会助成金",180000,72,1,"-","現金","-",180000,"AA会会計　XXXXさん受領","（連）"]
["可","2021-05-24",72,2,"-","助成金","BB部助成金",155000,72,2,"-","現金","-",155000,"BB部会計　XXXXさん受領",null,"722","722","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-24",72,2,"-","助成金","BB部助成金",155000,72,2,"-","現金","-",155000,"BB部会計　XXXXさん受領",""]
["可","2021-05-24",72,3,"-","助成金","CC会助成金",150000,72,3,"-","現金","-",150000,"CC会会長　XXXXさん受領",null,"723","723","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-24",72,3,"-","助成金","CC会助成金",150000,72,3,"-","現金","-",150000,"CC会会長　XXXXさん受領",""]
["可","2021-05-25",73,1,"-","助成金","DD会助成金",180000,73,1,"-","現金","-",180000,"DD会会計　XXXXさん受領","（連）","731","731","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-25",73,1,"-","助成金","DD会助成金",180000,73,1,"-","現金","-",180000,"DD会会計　XXXXさん受領","（連）"]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K99),_xlfn.ISFORMULA(E99),_xlfn.ISFORMULA(I99:J99),_xlfn.ISFORMULA(Q99:AD99),_xlfn.ISFORMULA(AL99),_xlfn.ISFORMULA(AO99:BC99)),\"可\",\"不可\")","v":"可"},"2021-05-25",73,2,"-","助成金","EE会助成金",100000,73,2,"-","現金","-",100000,"EE会会計　XXXXさん受領",null,"732","732","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-25",73,2,"-","助成金","EE会助成金",100000,73,2,"-","現金","-",100000,"EE会会計　XXXXさん受領",""]
["可","2021-05-26",74,"1","-","事務費","-",150,74,"1","-","現金","-",150,"中電電気料書類コピー15部(セブンイレブン)",null,"741","741","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-26",74,"1","-","事務費","-",150,74,"1","-","現金","-",150,"中電電気料書類コピー15部(セブンイレブン)",""]
["可","2021-05-27",75,"1","-","事業費","自主防災費",14520,75,"1","-","現金","-",14520,"自治会役員防災服　２着　（XXXX衣料）",null,"751","751","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-27",75,"1","-","事業費","自主防災費",14520,75,"1","-","現金","-",14520,"自治会役員防災服　２着　（XXXX衣料）",""]
["可","2021-05-27",76,"1","-","雑費","慶弔費",4000,76,"1","-","現金","-",4000,"4-1班 XXXX(86)様ご香典　5月26日逝去　仏式　喪主XXXX（長男）　自治会3,000円　民生委員1,000円",null,"761","761","YNNN","Y","N","N","N","N","N","N","A","","N","N",null,null,null,null,null,null,null,"",null,null,"2021-05-27",76,"1","-","雑費","慶弔費",4000,76,"1","-","現金","-",4000,"4-1班 XXXX(86)様ご香典　5月26日逝去　仏式　喪主XXXX（長男）　自治会3,000円　民生委員1,000円",""]
["可","2021-05-27",77,1,"-","施設費","公民館管理費",1650,77,1,"-","普通預金","振替支払",1650,"4月分ガス代　XXXX産業",null,{"$f":"C103&D103","v":"771"},{"$f":"I103&J103","v":"771"},{"$f":"T103&U103&V103&W103","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B103,to_date_2>=B103),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F103=L103,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F103=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L103=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V103=\"Y\",W103=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X103=\"Y\",V103=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X103=\"Y\",W103=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B103>=start_date,B103<=end_date),\"A\",IF(B103=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C103,0),\"\")","v":1},{"$f":"IF(AND(AA103=\"A\",AB103<>\"\"),\"Y\",IF(AA103=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F103=\"\",L103=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B103","v":"2021-05-27"},{"$f":"C103","v":77},{"$f":"D103","v":1},"-","施設費","公民館管理費",1650,{"$f":"I103","v":77},{"$f":"J103","v":1},"-","普通預金","振替支払",1650,"4月分ガス代　XXXX産業",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C104&D104","v":""},{"$f":"I104&J104","v":"00"},{"$f":"T104&U104&V104&W104","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B104,to_date_2>=B104),\"Y\",\"N\")","v":"N"},{"$f":"IF(F104=L104,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F104=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L104=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V104=\"Y\",W104=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X104=\"Y\",V104=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X104=\"Y\",W104=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B104>=start_date,B104<=end_date),\"A\",IF(B104=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C104,0),\"\")","v":""},{"$f":"IF(AND(AA104=\"A\",AB104<>\"\"),\"Y\",IF(AA104=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F104=\"\",L104=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B104","v":"00:00:00"},{"$f":"C104","v":0},{"$f":"D104","v":0},"","","","",{"$f":"I104","v":0},{"$f":"J104","v":0},"","","","",{"$f":"IF(O104=0,\"\",O104)","v":""},""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C105&D105","v":""},{"$f":"I105&J105","v":"00"},{"$f":"T105&U105&V105&W105","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B105,to_date_2>=B105),\"Y\",\"N\")","v":"N"},{"$f":"IF(F105=L105,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F105=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L105=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V105=\"Y\",W105=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X105=\"Y\",V105=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X105=\"Y\",W105=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B105>=start_date,B105<=end_date),\"A\",IF(B105=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C105,0),\"\")","v":""},{"$f":"IF(AND(AA105=\"A\",AB105<>\"\"),\"Y\",IF(AA105=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F105=\"\",L105=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B105","v":"00:00:00"},{"$f":"C105","v":0},{"$f":"D105","v":0},"","","","",{"$f":"I105","v":0},{"$f":"J105","v":0},"","","","","",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C106&D106","v":""},{"$f":"I106&J106","v":"00"},{"$f":"T106&U106&V106&W106","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B106,to_date_2>=B106),\"Y\",\"N\")","v":"N"},{"$f":"IF(F106=L106,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F106=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L106=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V106=\"Y\",W106=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X106=\"Y\",V106=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X106=\"Y\",W106=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B106>=start_date,B106<=end_date),\"A\",IF(B106=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C106,0),\"\")","v":""},{"$f":"IF(AND(AA106=\"A\",AB106<>\"\"),\"Y\",IF(AA106=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F106=\"\",L106=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B106","v":"00:00:00"},{"$f":"C106","v":0},{"$f":"D106","v":0},"","","","",{"$f":"I106","v":0},{"$f":"J106","v":0},"","","","","",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C107&D107","v":""},{"$f":"I107&J107","v":"00"},{"$f":"T107&U107&V107&W107","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B107,to_date_2>=B107),\"Y\",\"N\")","v":"N"},{"$f":"IF(F107=L107,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F107=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L107=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V107=\"Y\",W107=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X107=\"Y\",V107=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X107=\"Y\",W107=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B107>=start_date,B107<=end_date),\"A\",IF(B107=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C107,0),\"\")","v":""},{"$f":"IF(AND(AA107=\"A\",AB107<>\"\"),\"Y\",IF(AA107=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F107=\"\",L107=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B107","v":"00:00:00"},{"$f":"C107","v":0},{"$f":"D107","v":0},"","","","",{"$f":"I107","v":0},{"$f":"J107","v":0},"","","","","",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C108&D108","v":""},{"$f":"I108&J108","v":"00"},{"$f":"T108&U108&V108&W108","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B108,to_date_2>=B108),\"Y\",\"N\")","v":"N"},{"$f":"IF(F108=L108,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F108=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L108=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V108=\"Y\",W108=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X108=\"Y\",V108=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X108=\"Y\",W108=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B108>=start_date,B108<=end_date),\"A\",IF(B108=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C108,0),\"\")","v":""},{"$f":"IF(AND(AA108=\"A\",AB108<>\"\"),\"Y\",IF(AA108=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F108=\"\",L108=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B108","v":"00:00:00"},{"$f":"C108","v":0},{"$f":"D108","v":0},"","","","",{"$f":"I108","v":0},{"$f":"J108","v":0},"","","","","",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C109&D109","v":""},{"$f":"I109&J109","v":"00"},{"$f":"T109&U109&V109&W109","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B109,to_date_2>=B109),\"Y\",\"N\")","v":"N"},{"$f":"IF(F109=L109,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F109=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L109=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V109=\"Y\",W109=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X109=\"Y\",V109=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X109=\"Y\",W109=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B109>=start_date,B109<=end_date),\"A\",IF(B109=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C109,0),\"\")","v":""},{"$f":"IF(AND(AA109=\"A\",AB109<>\"\"),\"Y\",IF(AA109=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F109=\"\",L109=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B109","v":"00:00:00"},{"$f":"C109","v":0},{"$f":"D109","v":0},"","","","",{"$f":"I109","v":0},{"$f":"J109","v":0},"","","","","",""]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C110&D110","v":""},{"$f":"I110&J110","v":"00"},{"$f":"T110&U110&V110&W110","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B110,to_date_2>=B110),\"Y\",\"N\")","v":"N"},{"$f":"IF(F110=L110,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F110=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L110=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V110=\"Y\",W110=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X110=\"Y\",V110=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X110=\"Y\",W110=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B110>=start_date,B110<=end_date),\"A\",IF(B110=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C110,0),\"\")","v":""},{"$f":"IF(AND(AA110=\"A\",AB110<>\"\"),\"Y\",IF(AA110=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F110=\"\",L110=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B110","v":"00:00:00"},{"$f":"C110","v":0},{"$f":"D110","v":0},"","","","",{"$f":"I110","v":0},{"$f":"J110","v":0},"","","","","",""]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K111),_xlfn.ISFORMULA(E111),_xlfn.ISFORMULA(Q111:AD111),_xlfn.ISFORMULA(AL111),_xlfn.ISFORMULA(AO111:BC111)),\"可\",\"不可\")","v":"可"},null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,"","00","NYNN","N","Y","N","N","N","N","N","C","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N",{"$f":"IF(ISBLANK(B112),\"N\",\"Y\")","v":"N"},"",{"$f":"IF(OR(AA112=\"N\",AB112<>\"\"),\"Y\",\"N\")","v":"Y"},"Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,{"$f":"IFERROR(VLOOKUP(F113,g_kamoku,2,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(L113,g_kamoku,2,FALSE),\"\")","v":""},null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","",{"$f":"T115&U115&V115&W115","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B115,to_date_2>=B115),\"Y\",\"N\")","v":"N"},{"$f":"IF(E115=K115,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(list_kamoku_2<>\"\",E115=list_kamoku_2),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(list_kamoku_2<>\"\",K115=list_kamoku_2),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V115=\"Y\",W115=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X115=\"Y\",V115=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X115=\"Y\",W115=\"Y\"),\"Y\",\"N\")","v":"N"},"N",{"$f":"IFERROR(MATCH(MAX(slip),C115,0),\"\")","v":""},"Y",{"$f":"IF(OR(F115=\"\",L115=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,0,"","","","","",""]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"","","","",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B123","v":"00:00:00"},{"$f":"IF(V123=\"Y\",C123,\"\")","v":""},{"$f":"IF(V123=\"Y\",D123,\"\")","v":""},{"$f":"IF(V123=\"Y\",E123,\"\")","v":""},{"$f":"IF(V123=\"Y\",F123,\"\")","v":""},{"$f":"IF(V123=\"Y\",G123,\"\")","v":""},{"$f":"IF(V123=\"Y\",H123,\"\")","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,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(O144=0,\"\",O144)","v":""}]

{"sheet":"期間別試算表","index":4,"n_rows":108,"n_cols":63,"rows_kept":108,"cut":false,"hidden":false,"merged":[[26,3,26,4],[3,35,3,36],[105,2,105,4],[106,2,106,4],[107,2,107,4],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[4,29,4,30],[3,17,3,18],[3,19,3,20],[3,21,3,22],[49,2,49,4],[50,2,103,2],[50,3,50,4],[51,3,51,4],[52,3,55,3],[95,3,98,3],[99,3,99,4],[100,3,100,4],[101,3,103,3],[28,2,48,2],[28,3,28,4],[29,3,34,3],[35,3,35,4],[36,3,44,3],[45,3,45,4],[46,3,48,3],[56,3,56,4],[57,3,59,3],[60,3,60,4],[61,3,68,3],[69,3,69,4],[70,3,74,3],[75,3,75,4],[76,3,93,3],[94,3,94,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[9,2,9,4],[10,2,12,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[6,2,7,2],[6,3,6,4],[7,3,7,4],[4,2,5,4],[8,2,8,4],[21,3,21,4],[13,2,13,4],[14,2,22,2],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[22,3,22,4],[3,33,3,34],[4,31,4,32],[4,33,4,34],[27,5,27,6],[3,15,3,16],[3,7,3,8],[2,7,2,8],[2,9,2,10],[3,9,3,10],[4,7,4,8],[4,9,4,10],[2,11,2,12],[2,13,2,14],[3,11,3,12],[3,13,3,14],[4,11,4,12],[4,13,4,14],[27,9,27,10],[27,7,27,8],[3,5,3,6],[4,5,4,6],[0,0,0,4],[3,2,3,3],[1,2,1,4],[2,2,2,4],[3,51,3,52],[3,53,3,54],[4,51,4,52],[4,53,4,54],[3,45,3,46],[4,43,4,44],[4,45,4,46],[3,47,3,48],[3,49,3,50],[4,47,4,48],[4,49,4,50],[3,39,3,40],[3,41,3,42],[4,39,4,40],[4,41,4,42],[3,43,3,44],[3,37,3,38],[4,35,4,36],[4,37,4,38],[3,31,3,32]]}
["計算期間は「説明」シートへ登録ください。\n"]
[null,null,{"$f":"説明!C24","v":"A自治会"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BE4","v":2021},"予実績比較表"]
[null,null,"試算表",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"説明!D26","v":2021},null,"年度",{"$f":"IF(説明!E29=\"\",\"\",説明!E29)","v":"2021-03-31"},null,{"$f":"IF(説明!D30=\"\",\"\",説明!D30)","v":"2021-04-01"},null,{"$f":"IF(説明!E30=\"\",\"\",説明!E30)","v":"2021-04-30"},null,{"$f":"IF(説明!D31=\"\",\"\",説明!D31)","v":"2021-05-01"},null,{"$f":"IF(説明!E31=\"\",\"\",説明!E31)","v":"2021-05-31"},null,{"$f":"IF(説明!D32=\"\",\"\",説明!D32)","v":"2021-06-01"},null,{"$f":"IF(説明!E32=\"\",\"\",説明!E32)","v":"2021-06-30"},null,{"$f":"IF(説明!D33=\"\",\"\",説明!D33)","v":"2021-07-01"},null,{"$f":"IF(説明!E33=\"\",\"\",説明!E33)","v":"2021-07-31"},null,{"$f":"IF(説明!D34=\"\",\"\",説明!D34)","v":"2021-08-01"},null,{"$f":"IF(説明!E34=\"\",\"\",説明!E34)","v":"2021-08-31"},null,{"$f":"IF(説明!D35=\"\",\"\",説明!D35)","v":"2021-09-01"},null,{"$f":"IF(説明!E35=\"\",\"\",説明!E35)","v":"2021-09-30"},null,{"$f":"IF(説明!D36=\"\",\"\",説明!D36)","v":"2021-10-01"},null,{"$f":"IF(説明!E36=\"\",\"\",説明!E36)","v":"2021-10-31"},null,{"$f":"IF(説明!D37=\"\",\"\",説明!D37)","v":"2021-11-01"},null,{"$f":"IF(説明!E37=\"\",\"\",説明!E37)","v":"2021-11-30"},null,{"$f":"IF(説明!D38=\"\",\"\",説明!D38)","v":"2021-12-01"},null,{"$f":"IF(説明!E38=\"\",\"\",説明!E38)","v":"2021-12-31"},null,{"$f":"IF(説明!D39=\"\",\"\",説明!D39)","v":"2022-01-01"},null,{"$f":"IF(説明!E39=\"\",\"\",説明!E39)","v":"2022-01-31"},null,{"$f":"IF(説明!D40=\"\",\"\",説明!D40)","v":"2022-02-01"},null,{"$f":"IF(説明!E40=\"\",\"\",説明!E40)","v":"2022-02-28"},null,{"$f":"IF(説明!D41=\"\",\"\",説明!D41)","v":"2022-03-01"},null,{"$f":"IF(説明!E41=\"\",\"\",説明!E41)","v":"2022-03-31"},null,null,{"$f":"説明!D26","v":2021},"年度予算",null,null,"年間予算","累計実績","差異"]
[null,null,"単位：円",null,null,"繰越残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",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":"BE7","v":0},{"$f":"F7","v":0},{"$f":"BJ5-BI5","v":0}]
[null,null,null,null,null,"借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方",null,"借方","貸方",null,"繰越普通預金",{"$f":"BE8","v":1925396},{"$f":"F8","v":1925396},0]
[{"$f":"科目細分類表!E4","v":"-"},null,"資産",{"$f":"科目細分類表!E5","v":"現金"},null,{"$f":"説明!D46","v":0},null,5098948,5071548,{"$f":"F7+H7-I7","v":27400},null,806250,822590,{"$f":"J7+L7-M7","v":11060},null,303100,285749,{"$f":"N7+P7-Q7","v":28411},null,60000,63694,{"$f":"R7+T7-U7","v":24717},null,0,0,{"$f":"V7+X7-Y7","v":24717},null,0,0,{"$f":"Z7+AB7-AC7","v":24717},null,0,0,{"$f":"AD7+AF7-AG7","v":24717},null,0,0,{"$f":"AH7+AJ7-AK7","v":24717},null,0,0,{"$f":"AL7+AN7-AO7","v":24717},null,0,0,{"$f":"AP7+AR7-AS7","v":24717},null,0,0,{"$f":"AT7+AV7-AW7","v":24717},null,0,0,{"$f":"AX7+AZ7-BA7","v":24717},null,null,{"$f":"説明!D46","v":0},null,null,"現金（繰越含む）",{"$f":"BI5","v":0},{"$f":"BB7","v":24717},24717]
[{"$f":"科目細分類表!F4","v":"-"},null,null,{"$f":"科目細分類表!F5","v":"普通預金"},null,{"$f":"説明!D47","v":1925396},null,5129610,381400,{"$f":"F8+H8-I8","v":6673606},null,73260,1256999,{"$f":"J8+L8-M8","v":5489867},null,260316,358170,{"$f":"N8+P8-Q8","v":5392013},null,21081,96425,{"$f":"R8+T8-U8","v":5316669},null,0,0,{"$f":"V8+X8-Y8","v":5316669},null,0,0,{"$f":"Z8+AB8-AC8","v":5316669},null,0,0,{"$f":"AD8+AF8-AG8","v":5316669},null,0,0,{"$f":"AH8+AJ8-AK8","v":5316669},null,0,0,{"$f":"AL8+AN8-AO8","v":5316669},null,0,0,{"$f":"AP8+AR8-AS8","v":5316669},null,0,0,{"$f":"AT8+AV8-AW8","v":5316669},null,0,0,{"$f":"AX8+AZ8-BA8","v":5316669},null,null,{"$f":"説明!D47","v":1925396},null,null,"普通預金（繰越含む）",{"$f":"BI6","v":1925396},{"$f":"BB8","v":5316669},3391273]
[null,null,"資金の過不足",null,null,null,{"$f":"F8+F7","v":1925396},null,{"$f":"H25","v":4775610},null,{"$f":"G9+I9-H9","v":6701006},null,{"$f":"L25","v":-1200079},null,{"$f":"K9+M9-L9","v":5500927},null,{"$f":"P25","v":-80503},null,{"$f":"O9+Q9-P9","v":5420424},null,{"$f":"T25","v":-79038},null,{"$f":"S9+U9-T9","v":5341386},null,{"$f":"X25","v":0},null,{"$f":"W9+Y9-X9","v":5341386},null,{"$f":"AB25","v":0},null,{"$f":"AA9+AC9-AB9","v":5341386},null,{"$f":"AF25","v":0},null,{"$f":"AE9+AG9-AF9","v":5341386},null,{"$f":"AJ25","v":0},null,{"$f":"AI9+AK9-AJ9","v":5341386},null,{"$f":"AN25","v":0},null,{"$f":"AM9+AO9-AN9","v":5341386},null,{"$f":"AR25","v":0},null,{"$f":"AQ9+AS9-AR9","v":5341386},null,{"$f":"AV25","v":0},null,{"$f":"AU9+AW9-AV9","v":5341386},null,{"$f":"AZ25","v":0},null,{"$f":"AY9+BA9-AZ9","v":5341386},null,{"$f":"SUM(BE7:BE8)","v":1925396},{"$f":"SUM(BF7:BF8)","v":0},null,"繰越資金",{"$f":"BE9","v":1925396},{"$f":"BC9","v":5341386},3415990]
[null,null,"資産等の合計",null,null,{"$f":"SUM(F7:F9)","v":1925396},1925396,10228558,10228558,{"$f":"SUM(J7:J9)","v":6701006},{"$f":"SUM(K7:K9)","v":6701006},879510,879510,{"$f":"SUM(N7:N9)","v":5500927},{"$f":"SUM(O7:O9)","v":5500927},{"$f":"SUM(P7:P9)","v":563416},{"$f":"SUM(Q7:Q9)","v":563416},5420424,5420424,{"$f":"SUM(T7:T9)","v":81081},81081,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,0,0,5341386,5341386,null,{"$f":"BE9-BF9","v":1925396},{"$f":"SUM(BF7:BF9)","v":0},null,"収支へ繰入",{"$f":"BE10","v":1925396},{"$f":"BB10-BC10","v":0},-1925396]
[{"$f":"科目細分類表!G4","v":"-"},null,"収入",{"$f":"科目細分類表!G5","v":"会費"},null,null,null,0,5129610,{"$f":"F11+H11","v":0},{"$f":"G11+I11","v":5129610},0,84510,{"$f":"J11+L11","v":0},{"$f":"K11+M11","v":5214120},0,25376,{"$f":"N11+P11","v":0},{"$f":"O11+Q11","v":5239496},0,12786,{"$f":"R11+T11","v":0},{"$f":"S11+U11","v":5252282},0,0,{"$f":"V11+X11","v":0},{"$f":"W11+Y11","v":5252282},0,0,{"$f":"Z11+AB11","v":0},{"$f":"AA11+AC11","v":5252282},0,0,{"$f":"AD11+AF11","v":0},{"$f":"AE11+AG11","v":5252282},0,0,{"$f":"AH11+AJ11","v":0},{"$f":"AI11+AK11","v":5252282},0,0,{"$f":"AL11+AN11","v":0},5252282,0,0,{"$f":"AP11+AR11","v":0},5252282,0,0,{"$f":"AT11+AV11","v":0},5252282,0,0,{"$f":"AX11+AZ11","v":0},5252282,null,null,5512000,null,{"$f":"D11","v":"会費"},{"$f":"BF11","v":5512000},{"$f":"BC11","v":5252282},-259718]
[{"$f":"科目細分類表!H4","v":"-"},null,null,{"$f":"科目細分類表!H5","v":"補助金"},null,null,null,0,0,{"$f":"F12+H12","v":0},{"$f":"G12+I12","v":0},0,0,{"$f":"J12+L12","v":0},{"$f":"K12+M12","v":0},0,304320,{"$f":"N12+P12","v":0},{"$f":"O12+Q12","v":304320},0,0,{"$f":"R12+T12","v":0},{"$f":"S12+U12","v":304320},0,0,{"$f":"V12+X12","v":0},{"$f":"W12+Y12","v":304320},0,0,{"$f":"Z12+AB12","v":0},{"$f":"AA12+AC12","v":304320},0,0,{"$f":"AD12+AF12","v":0},{"$f":"AE12+AG12","v":304320},0,0,{"$f":"AH12+AJ12","v":0},{"$f":"AI12+AK12","v":304320},0,0,0,304320,0,0,0,304320,0,0,0,304320,0,0,0,304320,null,null,1715100,null,{"$f":"D12","v":"補助金"},{"$f":"BF12","v":1715100},{"$f":"BC12","v":304320},-1410780]
[{"$f":"科目細分類表!I4","v":"-"},null,null,{"$f":"科目細分類表!I5","v":"雑収入"},null,null,null,0,0,0,0,0,0,0,0,0,9800,0,9800,0,8295,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,0,0,0,18095,null,null,1029000,null,{"$f":"D13","v":"雑収入"},{"$f":"BF13","v":1029000},{"$f":"BC13","v":18095},-1010905]
[null,null,"収入の部合計",null,null,{"$f":"SUM(F13,F12,F11)","v":0},{"$f":"SUM(G13,G12,G11)","v":0},{"$f":"SUM(H13,H12,H11)","v":0},{"$f":"SUM(I13,I12,I11)","v":5129610},0,5129610,{"$f":"SUM(L13,L12,L11)","v":0},{"$f":"SUM(M13,M12,M11)","v":84510},0,5214120,{"$f":"SUM(P13,P12,P11)","v":0},{"$f":"SUM(Q13,Q12,Q11)","v":339496},0,5553616,{"$f":"SUM(T13,T12,T11)","v":0},{"$f":"SUM(U13,U12,U11)","v":21081},0,5574697,{"$f":"SUM(X13,X12,X11)","v":0},{"$f":"SUM(Y13,Y12,Y11)","v":0},0,5574697,{"$f":"SUM(AB13,AB12,AB11)","v":0},{"$f":"SUM(AC13,AC12,AC11)","v":0},0,5574697,{"$f":"SUM(AF13,AF12,AF11)","v":0},{"$f":"SUM(AG13,AG12,AG11)","v":0},0,5574697,{"$f":"SUM(AJ13,AJ12,AJ11)","v":0},{"$f":"SUM(AK13,AK12,AK11)","v":0},0,5574697,{"$f":"SUM(AN13,AN12,AN11)","v":0},{"$f":"SUM(AO13,AO12,AO11)","v":0},{"$f":"AL14+AN14","v":0},{"$f":"AM14+AO14","v":5574697},{"$f":"SUM(AR13,AR12,AR11)","v":0},{"$f":"SUM(AS13,AS12,AS11)","v":0},{"$f":"AP14+AR14","v":0},{"$f":"AQ14+AS14","v":5574697},{"$f":"SUM(AV13,AV12,AV11)","v":0},{"$f":"SUM(AW13,AW12,AW11)","v":0},{"$f":"AT14+AV14","v":0},{"$f":"AU14+AW14","v":5574697},{"$f":"SUM(AZ13,AZ12,AZ11)","v":0},{"$f":"SUM(BA13,BA12,BA11)","v":0},{"$f":"AX14+AZ14","v":0},{"$f":"AY14+BA14","v":5574697},null,{"$f":"SUM(BE11:BE13)","v":0},{"$f":"SUM(BF11:BF13)","v":8256100},null,"収入",{"$f":"BF14","v":8256100},{"$f":"BC14","v":5574697},{"$f":"SUM(BK11:BK13)","v":-2681403}]
[{"$f":"科目細分類表!J4","v":"-"},null,"支出",{"$f":"科目細分類表!J5","v":"事務費"},null,null,null,123467,0,123467,0,8819,0,132286,0,127,0,132413,0,941,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,0,0,133354,0,null,180000,null,null,{"$f":"D15","v":"事務費"},{"$f":"BE15","v":180000},{"$f":"BB15","v":133354},{"$f":"BI15-BJ15","v":46646}]
[{"$f":"科目細分類表!K4","v":"-"},null,null,{"$f":"科目細分類表!K5","v":"会議費"},null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,97000,null,null,{"$f":"D16","v":"会議費"},97000,0,97000]
[{"$f":"科目細分類表!L4","v":"-"},null,null,{"$f":"科目細分類表!L5","v":"役員費"},null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,940000,null,null,"役員費",940000,0,940000]
[{"$f":"科目細分類表!M4","v":"-"},null,null,{"$f":"科目細分類表!M5","v":"事業費"},null,null,null,0,0,0,0,14520,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,0,0,14520,0,null,3751000,null,null,"事業費",3751000,14520,3736480]
[{"$f":"科目細分類表!N4","v":"-"},null,null,{"$f":"科目細分類表!N5","v":"助成金"},null,null,null,0,0,0,0,765000,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,0,0,765000,0,null,785000,null,null,"助成金",785000,765000,20000]
[{"$f":"科目細分類表!O4","v":"-"},null,null,{"$f":"科目細分類表!O5","v":"負担金"},null,null,null,88000,0,88000,0,428100,0,516100,0,362780,0,878880,0,25200,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,0,0,904080,0,null,1330400,null,null,"負担金",1330400,904080,426320]
[{"$f":"科目細分類表!P4","v":"-"},null,null,{"$f":"科目細分類表!P5","v":"施設費"},null,null,null,38393,0,38393,0,50940,0,89333,0,44762,0,134095,0,38066,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,0,0,172161,0,null,1222000,null,null,"施設費",1222000,172161,1049839]
[{"$f":"科目細分類表!Q4","v":"-"},null,null,{"$f":"科目細分類表!Q5","v":"積立金"},null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,400000,null,null,"積立金",400000,0,400000]
[{"$f":"科目細分類表!R4","v":"-"},null,null,{"$f":"科目細分類表!R5","v":"雑費"},null,null,null,104140,0,104140,0,17210,0,121350,0,12330,0,133680,0,35912,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,0,0,169592,0,null,290000,null,null,"雑費",290000,169592,120408]
[null,null,"支出の部合計",null,null,{"$f":"SUM(F22:F23,F21,F20,F19,F18,F17,F15:F16)","v":0},{"$f":"SUM(G22:G23,G21,G20,G19,G18,G17,G15:G16)","v":0},{"$f":"SUM(H22:H23,H21,H20,H19,H18,H17,H15:H16)","v":354000},{"$f":"SUM(I22:I23,I21,I20,I19,I18,I17,I15:I16)","v":0},354000,0,{"$f":"SUM(L22:L23,L21,L20,L19,L18,L17,L15:L16)","v":1284589},{"$f":"SUM(M22:M23,M21,M20,M19,M18,M17,M15:M16)","v":0},1638589,0,{"$f":"SUM(P22:P23,P21,P20,P19,P18,P17,P15:P16)","v":419999},{"$f":"SUM(Q22:Q23,Q21,Q20,Q19,Q18,Q17,Q15:Q16)","v":0},2058588,0,{"$f":"SUM(T22:T23,T21,T20,T19,T18,T17,T15:T16)","v":100119},{"$f":"SUM(U22:U23,U21,U20,U19,U18,U17,U15:U16)","v":0},2158707,0,{"$f":"SUM(X22:X23,X21,X20,X19,X18,X17,X15:X16)","v":0},{"$f":"SUM(Y22:Y23,Y21,Y20,Y19,Y18,Y17,Y15:Y16)","v":0},2158707,0,{"$f":"SUM(AB22:AB23,AB21,AB20,AB19,AB18,AB17,AB15:AB16)","v":0},{"$f":"SUM(AC22:AC23,AC21,AC20,AC19,AC18,AC17,AC15:AC16)","v":0},2158707,0,{"$f":"SUM(AF22:AF23,AF21,AF20,AF19,AF18,AF17,AF15:AF16)","v":0},{"$f":"SUM(AG22:AG23,AG21,AG20,AG19,AG18,AG17,AG15:AG16)","v":0},2158707,0,{"$f":"SUM(AJ22:AJ23,AJ21,AJ20,AJ19,AJ18,AJ17,AJ15:AJ16)","v":0},{"$f":"SUM(AK22:AK23,AK21,AK20,AK19,AK18,AK17,AK15:AK16)","v":0},2158707,0,{"$f":"SUM(AN22:AN23,AN21,AN20,AN19,AN18,AN17,AN15:AN16)","v":0},{"$f":"SUM(AO22:AO23,AO21,AO20,AO19,AO18,AO17,AO15:AO16)","v":0},2158707,0,{"$f":"SUM(AR22:AR23,AR21,AR20,AR19,AR18,AR17,AR15:AR16)","v":0},{"$f":"SUM(AS22:AS23,AS21,AS20,AS19,AS18,AS17,AS15:AS16)","v":0},2158707,{"$f":"AQ24+AS24","v":0},{"$f":"SUM(AV22:AV23,AV21,AV20,AV19,AV18,AV17,AV15:AV16)","v":0},{"$f":"SUM(AW22:AW23,AW21,AW20,AW19,AW18,AW17,AW15:AW16)","v":0},2158707,{"$f":"AU24+AW24","v":0},{"$f":"SUM(AZ22:AZ23,AZ21,AZ20,AZ19,AZ18,AZ17,AZ15:AZ16)","v":0},{"$f":"SUM(BA22:BA23,BA21,BA20,BA19,BA18,BA17,BA15:BA16)","v":0},2158707,{"$f":"AY24+BA24","v":0},null,{"$f":"SUM(BE15:BE23)","v":8995400},null,null,"支出",8995400,2158707,{"$f":"SUM(BK15:BK23)","v":6836693}]
[null,null,"予備費",null,null,0,null,{"$f":"(I14-H14)-(H24-I24)","v":4775610},null,4775610,0,{"$f":"(M14-L14)-(L24-M24)","v":-1200079},null,3575531,0,{"$f":"(Q14-P14)-(P24-Q24)","v":-80503},null,3495028,0,{"$f":"(U14-T14)-(T24-U24)","v":-79038},null,3415990,0,{"$f":"(Y14-X14)-(X24-Y24)","v":0},null,3415990,0,{"$f":"(AC14-AB14)-(AB24-AC24)","v":0},null,3415990,0,{"$f":"(AG14-AF14)-(AF24-AG24)","v":0},null,3415990,0,{"$f":"(AK14-AJ14)-(AJ24-AK24)","v":0},null,3415990,0,{"$f":"(AO14-AN14)-(AN24-AO24)","v":0},null,3415990,0,{"$f":"(AS14-AR14)-(AR24-AS24)","v":0},null,3415990,{"$f":"AQ25+AS25","v":0},{"$f":"(AW14-AV14)-(AV24-AW24)","v":0},null,3415990,{"$f":"AU25+AW25","v":0},{"$f":"(BA14-AZ14)-(AZ24-BA24)","v":0},null,3415990,{"$f":"AY25+BA25","v":0},null,1186096,null,null,{"$f":"C25","v":"予備費"},1186096,3415990,{"$f":"BJ25-BI25","v":2229894}]
[null,null,"収支合計",null,null,{"$f":"SUM(F24,F25,F14)","v":0},{"$f":"SUM(G24,G25,G14)","v":0},{"$f":"SUM(H24,H25,H14)","v":5129610},{"$f":"SUM(I24,I25,I14)","v":5129610},5129610,5129610,{"$f":"SUM(L24,L25,L14)","v":84510},{"$f":"SUM(M24,M25,M14)","v":84510},5214120,5214120,{"$f":"SUM(P24,P25,P14)","v":339496},{"$f":"SUM(Q24,Q25,Q14)","v":339496},5553616,5553616,{"$f":"SUM(T24,T25,T14)","v":21081},{"$f":"SUM(U24,U25,U14)","v":21081},5574697,5574697,{"$f":"SUM(X24,X25,X14)","v":0},{"$f":"SUM(Y24,Y25,Y14)","v":0},5574697,5574697,{"$f":"SUM(AB24,AB25,AB14)","v":0},{"$f":"SUM(AC24,AC25,AC14)","v":0},5574697,5574697,{"$f":"SUM(AF24,AF25,AF14)","v":0},{"$f":"SUM(AG24,AG25,AG14)","v":0},5574697,5574697,{"$f":"SUM(AJ24,AJ25,AJ14)","v":0},{"$f":"SUM(AK24,AK25,AK14)","v":0},5574697,5574697,{"$f":"SUM(AN24,AN25,AN14)","v":0},{"$f":"SUM(AO24,AO25,AO14)","v":0},5574697,5574697,{"$f":"SUM(AR24,AR25,AR14)","v":0},{"$f":"SUM(AS24,AS25,AS14)","v":0},5574697,{"$f":"AQ26+AS26","v":5574697},{"$f":"SUM(AV24,AV25,AV14)","v":0},{"$f":"SUM(AW24,AW25,AW14)","v":0},5574697,{"$f":"AU26+AW26","v":5574697},{"$f":"SUM(AZ24,AZ25,AZ14)","v":0},{"$f":"SUM(BA24,BA25,BA14)","v":0},5574697,{"$f":"AY26+BA26","v":5574697},null,{"$f":"BE14+BE24+BE25","v":10181496},{"$f":"BE10+BF14","v":10181496},null,"収支",{"$f":"BE26-BF26","v":0},{"$f":"BB26-BC26","v":0}]
[{"$f":"科目細分類表!S4","v":"-"},null,null,"その他",null,null,null,547,547,{"$f":"F27+H27-I27","v":0},null,0,0,{"$f":"J27+L27-M27","v":0},null,0,0,{"$f":"N27+P27-Q27","v":0},null,0,0,{"$f":"R27+T27-U27","v":0},null,0,0,{"$f":"V27+X27-Y27","v":0},null,0,0,{"$f":"Z27+AB27-AC27","v":0},null,0,0,{"$f":"AD27+AF27-AG27","v":0},null,0,0,{"$f":"AH27+AJ27-AK27","v":0},null,0,0,{"$f":"AL27+AN27-AO27","v":0},null,0,0,{"$f":"AP27+AR27-AS27","v":0},null,0,0,{"$f":"AT27+AV27-AW27","v":0},null,0,0,{"$f":"AX27+AZ27-BA27","v":0}]
[null,null,"細分類"]
[null,null,"収入",{"$f":"D11","v":"会費"},null,{"$f":"SUM(F30,F35)","v":0},{"$f":"SUM(G30,G35)","v":0},{"$f":"H11","v":0},{"$f":"I11","v":5129610},{"$f":"F29+H29","v":0},{"$f":"G29+I29","v":5129610},{"$f":"L11","v":0},{"$f":"M11","v":84510},{"$f":"J29+L29","v":0},{"$f":"K29+M29","v":5214120},{"$f":"P11","v":0},{"$f":"Q11","v":25376},{"$f":"N29+P29","v":0},{"$f":"O29+Q29","v":5239496},{"$f":"T11","v":0},{"$f":"U11","v":12786},{"$f":"R29+T29","v":0},{"$f":"S29+U29","v":5252282},{"$f":"X11","v":0},{"$f":"Y11","v":0},{"$f":"V29+X29","v":0},{"$f":"W29+Y29","v":5252282},{"$f":"AB11","v":0},{"$f":"AC11","v":0},{"$f":"Z29+AB29","v":0},{"$f":"AA29+AC29","v":5252282},{"$f":"AF11","v":0},{"$f":"AG11","v":0},{"$f":"AD29+AF29","v":0},{"$f":"AE29+AG29","v":5252282},{"$f":"AJ11","v":0},{"$f":"AK11","v":0},{"$f":"AH29+AJ29","v":0},{"$f":"AI29+AK29","v":5252282},{"$f":"AN11","v":0},{"$f":"AO11","v":0},{"$f":"AL29+AN29","v":0},{"$f":"AM29+AO29","v":5252282},{"$f":"AR11","v":0},{"$f":"AS11","v":0},{"$f":"AP29+AR29","v":0},{"$f":"AQ29+AS29","v":5252282},{"$f":"AV11","v":0},{"$f":"AW11","v":0},{"$f":"AT29+AV29","v":0},{"$f":"AU29+AW29","v":5252282},{"$f":"AZ11","v":0},{"$f":"BA11","v":0},{"$f":"AX29+AZ29","v":0},{"$f":"AY29+BA29","v":5252282},null,null,{"$f":"BF11","v":5512000}]
[null,null,null,null,"自治会費",{"$f":"SUM(F31:F34)","v":0},{"$f":"SUM(G31:G34)","v":0},{"$f":"SUM(H31:H34)","v":0},{"$f":"SUM(I31:I34)","v":4851610},{"$f":"SUM(J31:J34)","v":0},{"$f":"G30+I30","v":4851610},{"$f":"SUM(L31:L34)","v":0},{"$f":"SUM(M31:M34)","v":76510},{"$f":"SUM(N31:N34)","v":0},4928120,0,19076,0,4947196,0,0,0,4947196,{"$f":"SUM(X31:X34)","v":0},0,0,4947196,0,0,0,4947196,0,0,0,4947196,0,0,0,4947196,0,0,0,4947196,0,0,0,4947196,0,0,0,4947196,0,0,0,4947196,null,null,5218000]
[null,null,null,null,"一般世帯",null,0,null,4415000,{"$f":"F31+H31","v":0},4415000,null,7000,{"$f":"J31+L31","v":0},{"$f":"K31+M31","v":4422000},null,null,{"$f":"N31+P31","v":0},{"$f":"O31+Q31","v":4422000},null,null,{"$f":"R31+T31","v":0},{"$f":"S31+U31","v":4422000},null,null,{"$f":"V31+X31","v":0},{"$f":"W31+Y31","v":4422000},null,null,{"$f":"Z31+AB31","v":0},{"$f":"AA31+AC31","v":4422000},null,null,{"$f":"AD31+AF31","v":0},{"$f":"AE31+AG31","v":4422000},null,null,{"$f":"AH31+AJ31","v":0},{"$f":"AI31+AK31","v":4422000},null,null,{"$f":"AL31+AN31","v":0},{"$f":"AM31+AO31","v":4422000},null,null,{"$f":"AP31+AR31","v":0},{"$f":"AQ31+AS31","v":4422000},null,null,{"$f":"AT31+AV31","v":0},{"$f":"AU31+AW31","v":4422000},null,null,{"$f":"AX31+AZ31","v":0},{"$f":"AY31+BA31","v":4422000},null,null,4992000]
[null,null,null,null,"アパート世帯",null,0,null,429000,0,429000,null,52250,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,0,481250,null,null,44000]
[null,null,null,null,"転入出世帯",null,0,null,1400,0,1400,null,null,0,1400,null,7000,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,0,8400,null,null,35000]
[null,null,null,null,"月払いアパート",null,0,null,6210,0,6210,null,17260,0,23470,null,12076,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,0,35546,null,null,147000]
[null,null,null,null,"自治会協力金",null,0,null,278000,0,278000,null,8000,0,286000,null,6300,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,0,292300,null,null,294000]
[null,null,null,{"$f":"D12","v":"補助金"},null,{"$f":"SUM(F37:F45)","v":0},{"$f":"SUM(G37:G45)","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0},0,0,{"$f":"L12","v":0},{"$f":"M12","v":0},0,0,{"$f":"P12","v":0},{"$f":"Q12","v":304320},0,304320,{"$f":"T12","v":0},{"$f":"U12","v":0},0,304320,{"$f":"X12","v":0},{"$f":"Y12","v":0},0,304320,{"$f":"AB12","v":0},{"$f":"AC12","v":0},0,304320,{"$f":"AF12","v":0},{"$f":"AG12","v":0},0,304320,{"$f":"AJ12","v":0},{"$f":"AK12","v":0},0,304320,{"$f":"AN12","v":0},{"$f":"AO12","v":0},0,304320,{"$f":"AR12","v":0},{"$f":"AS12","v":0},0,304320,{"$f":"AV12","v":0},{"$f":"AW12","v":0},0,304320,{"$f":"AZ12","v":0},{"$f":"BA12","v":0},0,304320,null,null,{"$f":"BF12","v":1715100}]
[null,null,null,null,"行政連絡業務費",null,0,null,null,0,0,null,null,0,0,null,304320,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,0,304320,null,null,614400]
[null,null,null,null,"敬老会開催費",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,500000]
[null,null,null,null,"地域福祉費",{"$f":"SUM(F40:F40)","v":0},0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,190000]
[null,null,null,null,"自主防災費",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,85000]
[null,null,null,null,"防犯灯設置費",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,60000]
[null,null,null,null,"防犯灯維持費",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,155000]
[null,null,null,null,"赤十字社公費金",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,17500]
[null,null,null,null,"環境美化協力金",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,51200]
[null,null,null,null,"河川愛護補助金",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,42000]
[null,null,null,{"$f":"D13","v":"雑収入"},null,{"$f":"SUM(F47:F49)","v":0},{"$f":"SUM(G47:G49)","v":0},{"$f":"H13","v":0},{"$f":"I13","v":0},0,0,{"$f":"L13","v":0},{"$f":"M13","v":0},0,0,{"$f":"P13","v":0},{"$f":"Q13","v":9800},0,9800,{"$f":"T13","v":0},{"$f":"U13","v":8295},0,18095,{"$f":"X13","v":0},{"$f":"Y13","v":0},0,18095,{"$f":"AB13","v":0},{"$f":"AC13","v":0},0,18095,{"$f":"AF13","v":0},{"$f":"AG13","v":0},0,18095,{"$f":"AJ13","v":0},{"$f":"AK13","v":0},0,18095,{"$f":"AN13","v":0},{"$f":"AO13","v":0},0,18095,{"$f":"AR13","v":0},{"$f":"AS13","v":0},0,18095,{"$f":"AV13","v":0},{"$f":"AW13","v":0},0,18095,{"$f":"AZ13","v":0},{"$f":"BA13","v":0},0,18095,null,null,{"$f":"BF13","v":1029000}]
[null,null,null,null,"公民館使用料",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,18000]
[null,null,null,null,"納涼祭祭券売上",null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,1000000]
[null,null,null,null,"その他",null,0,null,null,0,0,null,null,0,0,null,9800,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,0,9800,null,null,11000]
[null,null,"収入の部合計",null,null,{"$f":"SUM(F46,F36,F29)","v":0},{"$f":"SUM(G46,G36,G29)","v":0},{"$f":"SUM(H46,H36,H29)","v":0},{"$f":"SUM(I46,I36,I29)","v":5129610},0,5129610,{"$f":"SUM(L46,L36,L29)","v":0},{"$f":"SUM(M46,M36,M29)","v":84510},0,5214120,{"$f":"SUM(P46,P36,P29)","v":0},{"$f":"SUM(Q46,Q36,Q29)","v":339496},0,5553616,{"$f":"SUM(T46,T36,T29)","v":0},{"$f":"SUM(U46,U36,U29)","v":21081},0,5574697,{"$f":"SUM(X46,X36,X29)","v":0},{"$f":"SUM(Y46,Y36,Y29)","v":0},0,5574697,{"$f":"SUM(AB46,AB36,AB29)","v":0},{"$f":"SUM(AC46,AC36,AC29)","v":0},0,5574697,{"$f":"SUM(AF46,AF36,AF29)","v":0},{"$f":"SUM(AG46,AG36,AG29)","v":0},0,5574697,{"$f":"SUM(AJ46,AJ36,AJ29)","v":0},{"$f":"SUM(AK46,AK36,AK29)","v":0},0,5574697,{"$f":"SUM(AN46,AN36,AN29)","v":0},{"$f":"SUM(AO46,AO36,AO29)","v":0},0,5574697,{"$f":"SUM(AR46,AR36,AR29)","v":0},{"$f":"SUM(AS46,AS36,AS29)","v":0},0,5574697,{"$f":"SUM(AV46,AV36,AV29)","v":0},{"$f":"SUM(AW46,AW36,AW29)","v":0},0,5574697,{"$f":"SUM(AZ46,AZ36,AZ29)","v":0},{"$f":"SUM(BA46,BA36,BA29)","v":0},0,5574697,null,null,{"$f":"BF29+BF36+BF46","v":8256100}]
[null,null,"支出",{"$f":"D15","v":"事務費"},null,0,null,{"$f":"H15","v":123467},{"$f":"I15","v":0},123467,0,{"$f":"L15","v":8819},{"$f":"M15","v":0},132286,0,{"$f":"P15","v":127},{"$f":"Q15","v":0},132413,0,{"$f":"T15","v":941},{"$f":"U15","v":0},133354,0,{"$f":"X15","v":0},{"$f":"Y15","v":0},133354,0,{"$f":"AB15","v":0},{"$f":"AC15","v":0},133354,0,{"$f":"AF15","v":0},{"$f":"AG15","v":0},133354,0,{"$f":"AJ15","v":0},{"$f":"AK15","v":0},133354,0,{"$f":"AN15","v":0},{"$f":"AO15","v":0},133354,0,{"$f":"AR15","v":0},{"$f":"AS15","v":0},133354,0,{"$f":"AV15","v":0},{"$f":"AW15","v":0},133354,0,{"$f":"AZ15","v":0},{"$f":"BA15","v":0},133354,0,null,{"$f":"BE15","v":180000}]
[null,null,null,{"$f":"D16","v":"会議費"},null,{"$f":"SUM(F53:F56)","v":0},{"$f":"SUM(G53:G56)","v":0},{"$f":"H16","v":0},{"$f":"I16","v":0},0,0,{"$f":"L16","v":0},{"$f":"M16","v":0},0,0,{"$f":"P16","v":0},{"$f":"Q16","v":0},0,0,{"$f":"T16","v":0},{"$f":"U16","v":0},0,0,{"$f":"X16","v":0},{"$f":"Y16","v":0},0,0,{"$f":"AB16","v":0},{"$f":"AC16","v":0},0,0,{"$f":"AF16","v":0},{"$f":"AG16","v":0},0,0,{"$f":"AJ16","v":0},{"$f":"AK16","v":0},0,0,{"$f":"AN16","v":0},{"$f":"AO16","v":0},0,0,{"$f":"AR16","v":0},{"$f":"AS16","v":0},0,0,{"$f":"AV16","v":0},{"$f":"AW16","v":0},0,0,{"$f":"AZ16","v":0},{"$f":"BA16","v":0},0,0,null,{"$f":"BE16","v":97000}]
[null,null,null,null,"新旧三役引継",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,25000]
[null,null,null,null,"新旧役員引継",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,40000]
[null,null,null,null,"会計監査会",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,10000]
[null,null,null,null,"班長会・全体部会・代議員会・諮問委員会",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,22000]
[null,null,null,{"$f":"D17","v":"役員費"},null,{"$f":"SUM(F58:F60)","v":0},{"$f":"SUM(G58:G60)","v":0},{"$f":"H17","v":0},{"$f":"I17","v":0},0,0,{"$f":"L17","v":0},{"$f":"M17","v":0},0,0,{"$f":"P17","v":0},{"$f":"Q17","v":0},0,0,{"$f":"T17","v":0},{"$f":"U17","v":0},0,0,{"$f":"X17","v":0},{"$f":"Y17","v":0},0,0,{"$f":"AB17","v":0},{"$f":"AC17","v":0},0,0,{"$f":"AF17","v":0},{"$f":"AG17","v":0},0,0,{"$f":"AJ17","v":0},{"$f":"AK17","v":0},0,0,{"$f":"AN17","v":0},{"$f":"AO17","v":0},0,0,{"$f":"AR17","v":0},{"$f":"AS17","v":0},0,0,{"$f":"AV17","v":0},{"$f":"AW17","v":0},0,0,{"$f":"AZ17","v":0},{"$f":"BA17","v":0},0,0,null,{"$f":"BE17","v":940000}]
[null,null,null,null,"役員研修費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,300000]
[null,null,null,null,"三役交際費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,60000]
[null,null,null,null,"業務活動費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,580000]
[null,null,null,{"$f":"D18","v":"事業費"},null,{"$f":"SUM(F62:F69)","v":0},{"$f":"SUM(G62:G69)","v":0},{"$f":"H18","v":0},{"$f":"I18","v":0},0,0,{"$f":"L18","v":14520},{"$f":"M18","v":0},14520,0,{"$f":"P18","v":0},{"$f":"Q18","v":0},14520,0,{"$f":"T18","v":0},{"$f":"U18","v":0},14520,0,{"$f":"X18","v":0},{"$f":"Y18","v":0},14520,0,{"$f":"AB18","v":0},{"$f":"AC18","v":0},14520,0,{"$f":"AF18","v":0},{"$f":"AG18","v":0},14520,0,{"$f":"AJ18","v":0},{"$f":"AK18","v":0},14520,0,{"$f":"AN18","v":0},{"$f":"AO18","v":0},14520,0,{"$f":"AR18","v":0},{"$f":"AS18","v":0},14520,0,{"$f":"AV18","v":0},{"$f":"AW18","v":0},14520,0,{"$f":"AZ18","v":0},{"$f":"BA18","v":0},14520,0,null,{"$f":"BE18","v":3751000}]
[null,null,null,null,"敬老会費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,500000]
[null,null,null,null,"地域福祉費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,261000]
[null,null,null,null,"自主防災費",0,null,null,null,0,0,14520,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,null,14520,0,null,140000]
[null,null,null,null,"祭事費（納涼祭）",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,2575000]
[null,null,null,null,"戦没者慰霊祭費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,100000]
[null,null,null,null,"交通教室費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,30000]
[null,null,null,null,"土地借用料",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,36000]
[null,null,null,null,"環境整備費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,210000]
[null,null,null,{"$f":"D19","v":"助成金"},null,{"$f":"SUM(F71:F75)","v":0},{"$f":"SUM(G71:G75)","v":0},{"$f":"H19","v":0},{"$f":"I19","v":0},0,0,{"$f":"L19","v":765000},{"$f":"M19","v":0},765000,0,{"$f":"P19","v":0},{"$f":"Q19","v":0},765000,0,{"$f":"T19","v":0},{"$f":"U19","v":0},765000,0,{"$f":"X19","v":0},{"$f":"Y19","v":0},765000,0,{"$f":"AB19","v":0},{"$f":"AC19","v":0},765000,0,{"$f":"AF19","v":0},{"$f":"AG19","v":0},765000,0,{"$f":"AJ19","v":0},{"$f":"AK19","v":0},765000,0,{"$f":"AN19","v":0},{"$f":"AO19","v":0},765000,0,{"$f":"AR19","v":0},{"$f":"AS19","v":0},765000,0,{"$f":"AV19","v":0},{"$f":"AW19","v":0},765000,0,{"$f":"AZ19","v":0},{"$f":"BA19","v":0},765000,0,null,{"$f":"BE19","v":785000}]
[null,null,null,null,"AA会助成金",0,null,null,null,0,0,180000,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,180000]
[null,null,null,null,"BB部助成金",0,null,null,null,0,0,155000,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,null,155000,0,null,{"$f":"155000+20000","v":175000}]
[null,null,null,null,"CC会助成金",0,null,null,null,0,0,180000,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,null,180000,0,null,180000]
[null,null,null,null,"DD会助成金",0,null,null,null,0,0,150000,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,null,150000,0,null,150000]
[null,null,null,null,"EE会助成金",0,null,null,null,0,0,100000,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,null,100000,0,null,100000]
[null,null,null,{"$f":"D20","v":"負担金"},null,{"$f":"SUM(F77:F94)","v":0},{"$f":"SUM(G77:G94)","v":0},{"$f":"H20","v":88000},{"$f":"I20","v":0},88000,0,{"$f":"L20","v":428100},{"$f":"M20","v":0},516100,0,{"$f":"P20","v":362780},{"$f":"Q20","v":0},878880,0,{"$f":"T20","v":25200},{"$f":"U20","v":0},904080,0,{"$f":"X20","v":0},{"$f":"Y20","v":0},904080,0,{"$f":"AB20","v":0},{"$f":"AC20","v":0},904080,0,{"$f":"AF20","v":0},{"$f":"AG20","v":0},904080,0,{"$f":"AJ20","v":0},{"$f":"AK20","v":0},904080,0,{"$f":"AN20","v":0},{"$f":"AO20","v":0},904080,0,{"$f":"AR20","v":0},{"$f":"AS20","v":0},904080,0,{"$f":"AV20","v":0},{"$f":"AW20","v":0},904080,0,{"$f":"AZ20","v":0},{"$f":"BA20","v":0},904080,0,null,{"$f":"BE20","v":1330400}]
[null,null,null,null,"XX区自治会連合会",0,null,null,null,0,0,null,null,0,0,47550,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,null,47550,0,null,96000]
[null,null,null,null,"XX市自治会連合会",0,null,null,null,0,0,null,null,0,0,28530,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,null,28530,0,null,57600]
[null,null,null,null,"XX地区自治会連合会",0,null,63000,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,null,63000,0,null,63000]
[null,null,null,null,"広報等仕分料",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,12000]
[null,null,null,null,"自主防災費",0,null,null,null,0,0,null,null,0,0,36700,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,null,36700,0,null,36500]
[null,null,null,null,"防災員研修費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,60000]
[null,null,null,null,"自治会長研修費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,46000]
[null,null,null,null,"手をつなぐ育成会",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,25200]
[null,null,null,null,"社会福祉協議会会費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,"北浜東部地区社会福祉協議会",0,null,null,null,null,0,170100,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,null,170100,0,null,170100]
[null,null,null,null,"日本赤十字社",0,null,null,null,0,0,null,null,0,0,250000,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,null,250000,0,null,250000]
[null,null,null,null,"赤い羽根共同募金",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,125000]
[null,null,null,null,"緑の募金",0,null,25000,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,null,25000,0,null,25000]
[null,null,null,null,"歳末助け合い募金",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,100000]
[null,null,null,null,"国際交流協会",0,null,null,null,0,0,2000,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,null,2000,0,null,2000]
[null,null,null,null,"XX祭り負担金",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,6000]
[null,null,null,null,"第X防災会",0,null,null,null,0,0,252000,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,null,252000,0,null,252000]
[null,null,null,null,"明るい社会づくり",0,null,null,null,{"$f":"F94+H94","v":0},{"$f":"G94+I94","v":0},4000,null,{"$f":"J94+L94","v":4000},{"$f":"K94+M94","v":0},null,null,{"$f":"N94+P94","v":4000},{"$f":"O94+Q94","v":0},null,null,{"$f":"R94+T94","v":4000},{"$f":"S94+U94","v":0},null,null,4000,0,null,null,4000,0,null,null,4000,0,null,null,4000,0,null,null,4000,0,null,null,4000,0,null,null,4000,0,null,null,4000,0,null,4000]
[null,null,null,{"$f":"D21","v":"施設費"},null,{"$f":"SUM(F96:F99)","v":0},{"$f":"SUM(G96:G99)","v":0},{"$f":"H21","v":38393},{"$f":"I21","v":0},38393,0,{"$f":"L21","v":50940},{"$f":"M21","v":0},89333,0,{"$f":"P21","v":44762},{"$f":"Q21","v":0},134095,0,{"$f":"T21","v":38066},{"$f":"U21","v":0},172161,0,{"$f":"X21","v":0},{"$f":"Y21","v":0},{"$f":"V95+X95","v":172161},{"$f":"W95+Y95","v":0},{"$f":"AB21","v":0},{"$f":"AC21","v":0},{"$f":"Z95+AB95","v":172161},{"$f":"AA95+AC95","v":0},{"$f":"AF21","v":0},{"$f":"AG21","v":0},{"$f":"AD95+AF95","v":172161},{"$f":"AE95+AG95","v":0},{"$f":"AJ21","v":0},{"$f":"AK21","v":0},{"$f":"AH95+AJ95","v":172161},{"$f":"AI95+AK95","v":0},{"$f":"AN21","v":0},{"$f":"AO21","v":0},{"$f":"AL95+AN95","v":172161},{"$f":"AM95+AO95","v":0},{"$f":"AR21","v":0},{"$f":"AS21","v":0},{"$f":"AP95+AR95","v":172161},{"$f":"AQ95+AS95","v":0},{"$f":"AV21","v":0},{"$f":"AW21","v":0},{"$f":"AT95+AV95","v":172161},{"$f":"AU95+AW95","v":0},{"$f":"AZ21","v":0},{"$f":"BA21","v":0},{"$f":"AX95+AZ95","v":172161},{"$f":"AY95+BA95","v":0},null,{"$f":"BE21","v":1222000}]
[null,null,null,null,"防犯灯設置費及びＬＥＤ化工事費",0,null,null,null,0,0,11000,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,null,11000,0,null,62000]
[null,null,null,null,"防犯灯維持費",0,null,12707,null,12707,0,12669,null,25376,0,13440,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,null,38816,0,null,150000]
[null,null,null,null,"公民館管理費",0,null,25686,null,25686,0,27271,null,52957,0,31322,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,null,84279,0,null,950000]
[null,null,null,null,"運動公園管理費",0,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,60000]
[null,null,null,{"$f":"D22","v":"積立金"},null,0,null,{"$f":"H22","v":0},{"$f":"I22","v":0},0,0,{"$f":"L22","v":0},{"$f":"M22","v":0},0,0,{"$f":"P22","v":0},{"$f":"Q22","v":0},0,0,{"$f":"T22","v":0},{"$f":"U22","v":0},0,0,{"$f":"X22","v":0},{"$f":"Y22","v":0},0,0,{"$f":"AB22","v":0},{"$f":"AC22","v":0},0,0,{"$f":"AF22","v":0},{"$f":"AG22","v":0},0,0,{"$f":"AJ22","v":0},{"$f":"AK22","v":0},0,0,{"$f":"AN22","v":0},{"$f":"AO22","v":0},0,0,{"$f":"AR22","v":0},{"$f":"AS22","v":0},0,0,{"$f":"AV22","v":0},{"$f":"AW22","v":0},0,0,{"$f":"AZ22","v":0},{"$f":"BA22","v":0},0,0,null,{"$f":"BE22","v":400000}]
[null,null,null,{"$f":"D23","v":"雑費"},null,{"$f":"SUM(F102:F104)","v":0},{"$f":"SUM(G102:G104)","v":0},{"$f":"H23","v":104140},{"$f":"I23","v":0},104140,0,{"$f":"L23","v":17210},{"$f":"M23","v":0},121350,0,{"$f":"P23","v":12330},{"$f":"Q23","v":0},133680,0,{"$f":"T23","v":35912},{"$f":"U23","v":0},169592,0,{"$f":"X23","v":0},{"$f":"Y23","v":0},169592,0,{"$f":"AB23","v":0},{"$f":"AC23","v":0},169592,0,{"$f":"AF23","v":0},{"$f":"AG23","v":0},169592,0,{"$f":"AJ23","v":0},{"$f":"AK23","v":0},169592,0,{"$f":"AN23","v":0},{"$f":"AO23","v":0},169592,0,{"$f":"AR23","v":0},{"$f":"AS23","v":0},169592,0,{"$f":"AV23","v":0},{"$f":"AW23","v":0},169592,0,{"$f":"AZ23","v":0},{"$f":"BA23","v":0},169592,0,null,{"$f":"BE23","v":290000}]
[null,null,null,null,"保険料",0,null,93720,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,null,93720,0,null,165000]
[null,null,null,null,"慶弔費",0,null,8000,null,8000,0,16000,null,24000,0,12000,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,null,36000,0,null,120000]
[null,null,null,null,"振込手数料",0,null,2420,null,2420,0,1210,null,3630,0,330,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,null,3960,0,null,5000]
[null,null,null,null,"その他",null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,"支出の部合計",null,null,{"$f":"SUM(F100:F101,F95,F76,F70,F61,F57,F51:F52)","v":0},{"$f":"SUM(G100:G101,G95,G76,G70,G61,G57,G51:G52)","v":0},{"$f":"SUM(H100:H101,H95,H76,H70,H61,H57,H51:H52)","v":354000},{"$f":"SUM(I100:I101,I95,I76,I70,I61,I57,I51:I52)","v":0},354000,0,{"$f":"SUM(L100:L101,L95,L76,L70,L61,L57,L51:L52)","v":1284589},{"$f":"SUM(M100:M101,M95,M76,M70,M61,M57,M51:M52)","v":0},1638589,0,{"$f":"SUM(P100:P101,P95,P76,P70,P61,P57,P51:P52)","v":419999},{"$f":"SUM(Q100:Q101,Q95,Q76,Q70,Q61,Q57,Q51:Q52)","v":0},2058588,0,{"$f":"SUM(T100:T101,T95,T76,T70,T61,T57,T51:T52)","v":100119},{"$f":"SUM(U100:U101,U95,U76,U70,U61,U57,U51:U52)","v":0},2158707,0,{"$f":"SUM(X100:X101,X95,X76,X70,X61,X57,X51:X52)","v":0},{"$f":"SUM(Y100:Y101,Y95,Y76,Y70,Y61,Y57,Y51:Y52)","v":0},2158707,0,{"$f":"SUM(AB100:AB101,AB95,AB76,AB70,AB61,AB57,AB51:AB52)","v":0},{"$f":"SUM(AC100:AC101,AC95,AC76,AC70,AC61,AC57,AC51:AC52)","v":0},2158707,0,{"$f":"SUM(AF100:AF101,AF95,AF76,AF70,AF61,AF57,AF51:AF52)","v":0},{"$f":"SUM(AG100:AG101,AG95,AG76,AG70,AG61,AG57,AG51:AG52)","v":0},2158707,0,{"$f":"SUM(AJ100:AJ101,AJ95,AJ76,AJ70,AJ61,AJ57,AJ51:AJ52)","v":0},{"$f":"SUM(AK100:AK101,AK95,AK76,AK70,AK61,AK57,AK51:AK52)","v":0},2158707,0,{"$f":"SUM(AN100:AN101,AN95,AN76,AN70,AN61,AN57,AN51:AN52)","v":0},{"$f":"SUM(AO100:AO101,AO95,AO76,AO70,AO61,AO57,AO51:AO52)","v":0},2158707,0,{"$f":"SUM(AR100:AR101,AR95,AR76,AR70,AR61,AR57,AR51:AR52)","v":0},{"$f":"SUM(AS100:AS101,AS95,AS76,AS70,AS61,AS57,AS51:AS52)","v":0},2158707,0,{"$f":"SUM(AV100:AV101,AV95,AV76,AV70,AV61,AV57,AV51:AV52)","v":0},{"$f":"SUM(AW100:AW101,AW95,AW76,AW70,AW61,AW57,AW51:AW52)","v":0},2158707,0,{"$f":"SUM(AZ100:AZ101,AZ95,AZ76,AZ70,AZ61,AZ57,AZ51:AZ52)","v":0},{"$f":"SUM(BA100:BA101,BA95,BA76,BA70,BA61,BA57,BA51:BA52)","v":0},2158707,0,null,{"$f":"BE24","v":8995400},{"$f":"BF24","v":0}]
[null,null,"予備費",null,null,0,null,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,null,{"$f":"BE25","v":1186096}]
[null,null,"収支合計",null,null,{"$f":"SUM(F106,F107,F50)","v":0},{"$f":"SUM(G106,G107,G50)","v":0},{"$f":"SUM(H106,H107,H50)","v":354000},{"$f":"SUM(I106,I107,I50)","v":5129610},354000,5129610,{"$f":"SUM(L106,L107,L50)","v":1284589},{"$f":"SUM(M106,M107,M50)","v":84510},1638589,5214120,{"$f":"SUM(P106,P107,P50)","v":419999},{"$f":"SUM(Q106,Q107,Q50)","v":339496},2058588,5553616,{"$f":"SUM(T106,T107,T50)","v":100119},{"$f":"SUM(U106,U107,U50)","v":21081},2158707,5574697,{"$f":"SUM(X106,X107,X50)","v":0},{"$f":"SUM(Y106,Y107,Y50)","v":0},2158707,5574697,{"$f":"SUM(AB106,AB107,AB50)","v":0},{"$f":"SUM(AC106,AC107,AC50)","v":0},2158707,5574697,{"$f":"SUM(AF106,AF107,AF50)","v":0},{"$f":"SUM(AG106,AG107,AG50)","v":0},2158707,5574697,{"$f":"SUM(AJ106,AJ107,AJ50)","v":0},{"$f":"SUM(AK106,AK107,AK50)","v":0},2158707,5574697,{"$f":"SUM(AN106,AN107,AN50)","v":0},{"$f":"SUM(AO106,AO107,AO50)","v":0},2158707,5574697,{"$f":"SUM(AR106,AR107,AR50)","v":0},{"$f":"SUM(AS106,AS107,AS50)","v":0},2158707,5574697,{"$f":"SUM(AV106,AV107,AV50)","v":0},{"$f":"SUM(AW106,AW107,AW50)","v":0},2158707,5574697,{"$f":"SUM(AZ106,AZ107,AZ50)","v":0},{"$f":"SUM(BA106,BA107,BA50)","v":0},2158707,5574697,null,{"$f":"BE26","v":10181496},{"$f":"BE10+BF50+BF106+BF107","v":10181496}]

{"sheet":"科目細分類表","index":5,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,2],[0,0,0,2],[0,6,0,18]]}
["この３列は触らないでください。",null,null,"科目細分類表",null,null,"下の操作を行うと、科目名及び科目グループ名（セル内で完全一致した）を置き換えます(処理としては、置き換え前に、時刻付きのバックアップEを作成します）。"]
[null,null,null,null,null,null,"文字列","現金","を","現金","へ置き換えます。→"]
[]
[null,"逆引き",null,"科目グループ→","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"E4","v":"-"},{"$f":"科目細分類[[#Headers],[現金]]","v":"現金"},{"$f":"E4","v":"-"},"科目名→\n細分類↓","現金","普通預金","会費","補助金","雑収入","事務費","会議費","役員費","事業費","助成金","負担金","施設費","積立金","雑費","その他"]
[{"$f":"F4","v":"-"},{"$f":"科目細分類[[#Headers],[普通預金]]","v":"普通預金"},{"$f":"F4","v":"-"},"a","諸口","振込支払","一般世帯会費","行政連絡業務費","公民館使用料","-","新旧三役引継","役員研修費","敬老会費","AA会助成金","XX区自治会連合会","防犯灯設置費・ＬＥＤ化工事費","-","保険料","未払金"]
[{"$f":"G4","v":"-"},{"$f":"科目細分類[[#Headers],[会費]]","v":"会費"},{"$f":"G4","v":"-"},"b","コンビニ振込","振替支払","アパート世帯会費","敬老会開催費","納涼祭祭券売上","-","新旧役員引継","三役交際費","地域福祉費","BB部助成金","XX市自治会連合会","防犯灯維持費","-","慶弔費","借入金"]
[{"$f":"H4","v":"-"},{"$f":"科目細分類[[#Headers],[補助金]]","v":"補助金"},{"$f":"H4","v":"-"},"c","郵便局振込","現金払出","転入出世帯会費","地域福祉費","エアコン使用料","-","会計監査会","業務活動費","自主防災費","CC会助成金","XX地区自治会連合会","公民館管理費","-","振込手数料","仮払金"]
[{"$f":"I4","v":"-"},{"$f":"科目細分類[[#Headers],[雑収入]]","v":"雑収入"},{"$f":"I4","v":"-"},"d","-","振込入金","月払いアパート会費","自主防災費","その他","-","班長会・全体部会・代議会・諮問会","-","祭事費（納涼祭）","DD会助成金","広報等仕分料","運動公園管理費","-","その他雑費","現金残高差異"]
[{"$f":"J4","v":"-"},{"$f":"科目細分類[[#Headers],[事務費]]","v":"事務費"},{"$f":"J4","v":"-"},"e","-","現金預入","自治会協力金","防犯灯設置費","-","-","-","-","戦没者慰霊祭費","EE会助成金","自主防災費","-","-","-","仮受金"]
[{"$f":"K4","v":"-"},{"$f":"科目細分類[[#Headers],[会議費]]","v":"会議費"},{"$f":"K4","v":"-"},"f","-","銀行手数料","-","防犯灯維持費","-","-","-","-","交通教室費","-","防災員研修費","-","-","-","-"]
[{"$f":"L4","v":"-"},{"$f":"科目細分類[[#Headers],[役員費]]","v":"役員費"},{"$f":"L4","v":"-"},"g","-","諸口","-","赤十字社公費金","-","-","-","-","土地借用料","-","自治会長研修費","-","-","-","-"]
[{"$f":"M4","v":"-"},{"$f":"科目細分類[[#Headers],[事業費]]","v":"事業費"},{"$f":"M4","v":"-"},"h","-","-","-","環境美化協力金","-","-","-","-","環境整備費","-","手をつなぐ育成会","-","-","-","-"]
[{"$f":"N4","v":"-"},{"$f":"科目細分類[[#Headers],[助成金]]","v":"助成金"},{"$f":"N4","v":"-"},"i","-","-","-","河川愛護補助金","-","-","-","-","-","-","社会福祉協議会会費","-","-","-","-"]
[{"$f":"O4","v":"-"},{"$f":"科目細分類[[#Headers],[負担金]]","v":"負担金"},{"$f":"O4","v":"-"},"j","-","-","-","-","-","-","-","-","-","-","XX地区社会福祉協議会","-","-","-","-"]
[{"$f":"P4","v":"-"},{"$f":"科目細分類[[#Headers],[施設費]]","v":"施設費"},{"$f":"P4","v":"-"},"k","-","-","-","-","-","-","-","-","-","-","日本赤十字社","-","-","-","-"]
[{"$f":"Q4","v":"-"},{"$f":"科目細分類[[#Headers],[積立金]]","v":"積立金"},{"$f":"Q4","v":"-"},"l","-","-","-","-","-","-","-","-","-","-","赤い羽根共同募金","-","-","-","-"]
[{"$f":"R4","v":"-"},{"$f":"科目細分類[[#Headers],[雑費]]","v":"雑費"},{"$f":"R4","v":"-"},"m","-","-","-","-","-","-","-","-","-","-","緑の募金","-","-","-","-"]
[{"$f":"S4","v":"-"},{"$f":"科目細分類[[#Headers],[その他]]","v":"その他"},{"$f":"S4","v":"-"},"n","-","-","-","-","-","-","-","-","-","-","歳末助け合い募金","-","-","-","-"]
[null,null,null,"o","-","-","-","-","-","-","-","-","-","-","国際交流協会","-","-","-","-"]
[null,null,null,"p","-","-","-","-","-","-","-","-","-","-","XX祭り負担金","-","-","-","-"]
[null,null,null,"q","-","-","-","-","-","-","-","-","-","-","第X防災会","-","-","-","-"]
[null,null,null,"r","-","-","-","-","-","-","-","-","-","-","明るい社会づくり","-","-","-","-"]

{"sheet":"現金照合表","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,1,6,2],[6,4,6,5],[18,1,18,3],[2,1,2,9],[4,2,4,4],[3,7,3,8]]}
[]
[null,{"$f":"説明!C24","v":"A自治会"}]
[null,"現　金　照　合　表"]
[null,null,null,null,null,null,"会計","XXXX",null,"㊞"]
[null,"日付","2021-05-31"]
[]
[null,"金種",null,"枚数","金額",null,null,"帳簿残高",62564,"円"]
[null,10000,"円",3,{"$f":"B8*D8","v":30000},"円",null,"実際有高",{"$f":"E19","v":62564},"円"]
[null,5000,"円",0,{"$f":"B9*D9","v":0},"円",null,"現金過不足",{"$f":"I8-I7","v":0},"円"]
[null,2000,"円",null,0,"円"]
[null,1000,"円",31,31000,"円"]
[null,500,"円",2,1000,"円"]
[null,100,"円",4,400,"円"]
[null,50,"円",null,0,"円"]
[null,10,"円",13,130,"円"]
[null,5,"円",5,25,"円"]
[null,1,"円",9,9,"円"]
[null,"商品券",null,null,null,"円"]
[null,"現金残高",null,null,{"$f":"SUM(E8:E18)","v":62564},"円"]

{"sheet":"手書き領収書フォーム","index":7,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,4,22,5],[2,1,2,2],[11,1,11,2],[13,4,13,5],[4,4,4,5],[20,1,20,2],[2,4,2,5],[11,4,11,5],[20,4,20,5]]}
[]
[]
[null,"領収証",null,null,{"$f":"説明!C24","v":"A自治会"},null,"様"]
[]
[null,null,null,null,150000,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]
[]
[]
[null,"領収証",null,null,{"$f":"E3","v":"A自治会"},null,"様"]
[]
[null,null,null,null,100000,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]
[]
[]
[null,"領収証",null,null,{"$f":"E3","v":"A自治会"},null,"様"]
[]
[null,null,null,null,null,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]

{"sheet":"予算比較","index":8,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"期間別試算表!C2","v":"A自治会"},null,null,{"$f":"TODAY()","v":"2022-11-10"}]
[null,{"$f":"期間別試算表!BH2","v":2021},"年度",{"$f":"期間別試算表!BI2","v":"予実績比較表"}]
[null,null,null,null,"単位：円"]
[null,null,{"$f":"期間別試算表!BI4","v":"年間予算"},{"$f":"期間別試算表!BJ4","v":"累計実績"},{"$f":"期間別試算表!BK4","v":"差異"}]
[null,{"$f":"期間別試算表!BH5","v":"繰越現金"},{"$f":"期間別試算表!BI5","v":0},{"$f":"期間別試算表!BJ5","v":0},{"$f":"期間別試算表!BK5","v":0}]
[null,{"$f":"期間別試算表!BH6","v":"繰越普通預金"},{"$f":"期間別試算表!BI6","v":1925396},{"$f":"期間別試算表!BJ6","v":1925396},{"$f":"期間別試算表!BK6","v":0}]
[null,{"$f":"期間別試算表!BH7","v":"現金（繰越含む）"},{"$f":"期間別試算表!BI7","v":0},{"$f":"期間別試算表!BJ7","v":24717},{"$f":"期間別試算表!BK7","v":24717}]
[null,{"$f":"期間別試算表!BH8","v":"普通預金（繰越含む）"},{"$f":"期間別試算表!BI8","v":1925396},{"$f":"期間別試算表!BJ8","v":5316669},{"$f":"期間別試算表!BK8","v":3391273}]
[null,{"$f":"期間別試算表!BH9","v":"繰越資金"},{"$f":"期間別試算表!BI9","v":1925396},{"$f":"期間別試算表!BJ9","v":5341386},{"$f":"期間別試算表!BK9","v":3415990}]
[null,{"$f":"期間別試算表!BH10","v":"収支へ繰入"},{"$f":"期間別試算表!BI10","v":1925396},{"$f":"期間別試算表!BJ10","v":0},{"$f":"期間別試算表!BK10","v":-1925396}]
[null,{"$f":"期間別試算表!BH11","v":"会費"},{"$f":"期間別試算表!BI11","v":5512000},{"$f":"期間別試算表!BJ11","v":5252282},{"$f":"期間別試算表!BK11","v":-259718}]
[null,{"$f":"期間別試算表!BH12","v":"補助金"},{"$f":"期間別試算表!BI12","v":1715100},{"$f":"期間別試算表!BJ12","v":304320},{"$f":"期間別試算表!BK12","v":-1410780}]
[null,{"$f":"期間別試算表!BH13","v":"雑収入"},{"$f":"期間別試算表!BI13","v":1029000},{"$f":"期間別試算表!BJ13","v":18095},{"$f":"期間別試算表!BK13","v":-1010905}]
[null,{"$f":"期間別試算表!BH14","v":"収入"},{"$f":"期間別試算表!BI14","v":8256100},{"$f":"期間別試算表!BJ14","v":5574697},{"$f":"期間別試算表!BK14","v":-2681403}]
[null,{"$f":"期間別試算表!BH15","v":"事務費"},{"$f":"期間別試算表!BI15","v":180000},{"$f":"期間別試算表!BJ15","v":133354},{"$f":"期間別試算表!BK15","v":46646}]
[null,{"$f":"期間別試算表!BH16","v":"会議費"},{"$f":"期間別試算表!BI16","v":97000},{"$f":"期間別試算表!BJ16","v":0},{"$f":"期間別試算表!BK16","v":97000}]
[null,{"$f":"期間別試算表!BH17","v":"役員費"},{"$f":"期間別試算表!BI17","v":940000},{"$f":"期間別試算表!BJ17","v":0},{"$f":"期間別試算表!BK17","v":940000}]
[null,{"$f":"期間別試算表!BH18","v":"事業費"},{"$f":"期間別試算表!BI18","v":3751000},{"$f":"期間別試算表!BJ18","v":14520},{"$f":"期間別試算表!BK18","v":3736480}]
[null,{"$f":"期間別試算表!BH19","v":"助成金"},{"$f":"期間別試算表!BI19","v":785000},{"$f":"期間別試算表!BJ19","v":765000},{"$f":"期間別試算表!BK19","v":20000}]
[null,{"$f":"期間別試算表!BH20","v":"負担金"},{"$f":"期間別試算表!BI20","v":1330400},{"$f":"期間別試算表!BJ20","v":904080},{"$f":"期間別試算表!BK20","v":426320}]
[null,{"$f":"期間別試算表!BH21","v":"施設費"},{"$f":"期間別試算表!BI21","v":1222000},{"$f":"期間別試算表!BJ21","v":172161},{"$f":"期間別試算表!BK21","v":1049839}]
[null,{"$f":"期間別試算表!BH22","v":"積立金"},{"$f":"期間別試算表!BI22","v":400000},{"$f":"期間別試算表!BJ22","v":0},{"$f":"期間別試算表!BK22","v":400000}]
[null,{"$f":"期間別試算表!BH23","v":"雑費"},{"$f":"期間別試算表!BI23","v":290000},{"$f":"期間別試算表!BJ23","v":169592},{"$f":"期間別試算表!BK23","v":120408}]
[null,{"$f":"期間別試算表!BH24","v":"支出"},{"$f":"期間別試算表!BI24","v":8995400},{"$f":"期間別試算表!BJ24","v":2158707},{"$f":"期間別試算表!BK24","v":6836693}]
[null,{"$f":"期間別試算表!BH25","v":"予備費"},{"$f":"期間別試算表!BI25","v":1186096},{"$f":"期間別試算表!BJ25","v":3415990},{"$f":"期間別試算表!BK25","v":2229894}]
[null,{"$f":"期間別試算表!BH26","v":"収支"},{"$f":"期間別試算表!BI26","v":0},{"$f":"期間別試算表!BJ26","v":0},{"$f":"期間別試算表!BK26","v":0}]