{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["収入","Sheet1 (2)","Sheet1 (3)","支出1","支出2","賃金明細表看護師用","賃金明細表介護員用","賃金明細表事務職他","賃金明細表新人職員用","購入計画・修繕計画"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":65,"comments":8,"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":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,16,2,18],[3,0,10,0],[12,0,19,0]]}
[27,"年度老健予算計画"]
[]
[null,"3）老健事業収支計画",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["施設運営事業収益","科目　区分","前年実績月額","４月予算","４月実績","５月予算","５月実績","６月予算","６月実績","７月予算","７月実績","８月予算","８月実績","９月予算","９月実績","上半期予算","上半期実績計","上半期予実対比","上半期実績構成比"]
[null,"入所用",null,null,{"$f":"D5","v":0},null,{"$f":"F5","v":0},null,{"$f":"H5","v":0},null,{"$f":"J5","v":0},null,{"$f":"L5","v":0},null,{"$f":"N5","v":0},{"$f":"SUM(D5,F5,H5,J5,L5,N5)","v":0},{"$f":"SUM(E5,G5,I5,K5,M5,O5)","v":0},{"$f":"Q5-P5","v":0},{"$f":"IF($Q$5=0,\"\",$Q$5/$Q$11)","v":""}]
[null,"通所用",null,null,{"$f":"D6","v":0},null,0,null,{"$f":"H6","v":0},null,{"$f":"J6","v":0},null,{"$f":"L6","v":0},null,{"$f":"N6","v":0},{"$f":"SUM(D6,F6,H6,J6,L6,N6)","v":0},{"$f":"SUM(E6,G6,I6,K6,M6,O6)","v":0},{"$f":"Q6-P6","v":0},{"$f":"IF(Q6=0,\"\",Q6/$Q$11)","v":""}]
[null,"居宅支援用",null,null,0,null,0,null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},0,0,0,{"$f":"IF(Q7=0,\"\",Q7/$Q$11)","v":""}]
[null,"訪問看護ST用",null,null,{"$f":"D8","v":0},null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q8=0,\"\",Q8/$Q$11)","v":""}]
[null,"その他収入（手入力）",null,null,{"$f":"D9","v":0},null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q9=0,\"\",Q9/$Q$11)","v":""}]
[null,"その他収入（手入力）",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,""]
[null,"施設運営事業収益計",{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P5:P10)","v":0},{"$f":"SUM(Q5:Q10)","v":0},{"$f":"SUM(R5:R10)","v":0},{"$f":"IF(Q11=0,\"\",Q11/$Q$11)","v":""}]
[]
["施設運営事業収益","科目　区分","上半期実績計","１０月予算","１０月実績","１１月予算","１１月実績","１２月予算","１２月実績","１月予算","１月実績","２月予算","２月実績","３月予算","３月実績","年度予算計","年度実績計","年間予実対比","年間実績構成比"]
[null,{"$f":"B5","v":"入所用"},{"$f":"Q5","v":0},null,{"$f":"D14","v":0},null,{"$f":"F14","v":0},null,{"$f":"H14","v":0},null,{"$f":"J14","v":0},null,{"$f":"L14","v":0},null,{"$f":"N14","v":0},{"$f":"SUM(P5,D14,F14,H14,J14,L14,N14)","v":0},{"$f":"SUM(C14,E14,G14,I14,K14,M14,O14)","v":0},{"$f":"Q14-P14","v":0},{"$f":"IF(Q14=0,\"\",Q14/$Q$20)","v":""}]
[null,"通所用",{"$f":"Q6","v":0},null,{"$f":"D15","v":0},null,0,null,{"$f":"H15","v":0},null,{"$f":"J15","v":0},null,{"$f":"L15","v":0},null,{"$f":"N15","v":0},{"$f":"SUM(P6,D15,F15,H15,J15,L15,N15)","v":0},{"$f":"SUM(C15,E15,G15,I15,K15,M15,O15)","v":0},{"$f":"Q15-P15","v":0},{"$f":"IF(Q15=0,\"\",Q15/$Q$20)","v":""}]
[null,"居宅支援用",0,null,0,null,0,null,{"$f":"H16","v":0},null,{"$f":"J16","v":0},null,{"$f":"L16","v":0},null,{"$f":"N16","v":0},{"$f":"SUM(P7,D16,F16,H16,J16,L16,N16)","v":0},0,0,""]
[null,"訪問看護ST用",0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,""]
[null,"その他収入（手入力）",0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,""]
[null,"その他収入（手入力）",0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,""]
[null,"施設運営事業収益計",{"$f":"SUM(C14:C19)","v":0},{"$f":"SUM(D14:D19)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P14:P19)","v":0},{"$f":"SUM(Q14:Q19)","v":0},{"$f":"SUM(R14:R19)","v":0},{"$f":"IF(Q20=0,\"\",Q20/$Q$20)","v":""}]

{"sheet":"Sheet1 (2)","index":1,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":true,"merged":[[16,0,16,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
["26年度通所リハビリ事業計画"]
[]
["1）条件設定"]
["科目　区分","４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月","年度　計"]
["暦"]
["稼働日数"]
["平均入所者数（計画）"]
["職員数"]
[]
["2）収入シミュレーション設定（点数改訂は反映されていない）"]
["基本利用料　　平均収入単価",null,"長短入所"]
["加算収入率　　対基本利用料",null,null,"％"]
["１日当たり食費",null,null,"円"]
["平均居室料　　多床",null,null,"円"]
["平均居室料　　個別",null,null,"円"]
["その他収入率",null,null,"％"]
["１日１人当たり単価",null,null,"円"]
[]
["3）26年度老健事業収支計画"]
["科目　区分","４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月","年度　計","構成"]
["（収入の部）"]
["基本報酬（介護報酬）"]
["加算収入"]
["食費"]
["居室"]
["その他の収入"]
[]
["収入総合計"]
[]
["（支出の部）"]
["給与　看護師"]
["給与　介護員"]
["給与　その他"]
["給与　新規"]
["賞与　看護師"]
["賞与　介護員"]
["賞与　その他"]
["賞与　新規"]
["薬品費"]
["給食費"]
["施設療養消耗器具備品費"]
["減価償却費"]
["法定福利費"]
["福利厚生費"]
["地代家賃"]
["水道光熱費"]
["委託費"]
["通信費"]
["法人税等"]
["その他"]
["支出総合計"]
["収入総合計－支出総合計（Ｃ"]

{"sheet":"Sheet1 (3)","index":2,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[[14,0,14,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["26年度居宅支援事業計画"]
[]
["1）条件設定"]
["科目　区分","４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月","年度　計"]
["暦"]
["稼働日数"]
["要介護件数"]
["要支援件数"]
["職員数"]
[]
["2）収入シミュレーション設定（点数改訂は反映されていない）"]
["基本利用料　　平均収入単価",null,"長短入所"]
["加算収入率　　対基本利用料",null,null,"％"]
["その他収入率",null,null,"％"]
["居宅支援単価",null,null,"円"]
[]
["3）26年度老健事業収支計画"]
["科目　区分","４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月","年度　計","構成"]
["（収入の部）"]
["基本報酬（介護報酬）"]
["加算収入"]
["要支援単価"]
["その他の収入"]
[]
["収入総合計"]
[]
["（支出の部）"]
["給与　看護師"]
["給与　介護員"]
["給与　その他"]
["給与　新規"]
["賞与　看護師"]
["賞与　介護員"]
["賞与　その他"]
["賞与　新規"]
["薬品費"]
["給食費"]
["施設療養消耗器具備品費"]
["減価償却費"]
["法定福利費"]
["福利厚生費"]
["地代家賃"]
["水道光熱費"]
["委託費"]
["通信費"]
["法人税等"]
["その他"]
["支出総合計"]
["収入総合計－支出総合計（Ｃ"]

{"sheet":"支出1","index":3,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,60,1],[59,0,59,1],[3,0,51,0],[2,0,2,1],[54,0,55,0],[57,0,58,0],[52,0,52,1],[56,0,56,1]]}
[{"$f":"IF(収入!A1=\"\",\"\",収入!A1)","v":27},"年度老健予算計画"]
[null,"支出の部",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["科目　区分",null,"前期実績月額","４月予算","４月実績","５月予算","５月実績","６月予算","６月実績","７月予算","７月実績","８月予算","８月実績","９月予算","９月実績","上半期予算計","上半期実績計","上半期予実対比","上半期構成（収入比）"]
["施設運営事業費用","給与　看護師",null,{"$f":"賃金明細表看護師用!F4","v":0},{"$f":"D4","v":0},{"$f":"賃金明細表看護師用!G4","v":0},{"$f":"F4","v":0},{"$f":"賃金明細表看護師用!H4","v":0},{"$f":"H4","v":0},{"$f":"賃金明細表看護師用!I4","v":0},{"$f":"J4","v":0},{"$f":"賃金明細表看護師用!J4","v":0},{"$f":"L4","v":0},{"$f":"賃金明細表看護師用!K4","v":0},{"$f":"N4","v":0},{"$f":"SUM(D4,F4,H4,J4,L4,N4)","v":0},{"$f":"SUM(E4,G4,I4,K4,M4,O4)","v":0},{"$f":"Q4-P4","v":0},{"$f":"IF(Q4=0,\"\",Q4/収入!$Q$11)","v":""}]
[null,"給与　介護員",null,{"$f":"賃金明細表介護員用!F4","v":0},{"$f":"D5","v":0},{"$f":"賃金明細表介護員用!G4","v":0},0,{"$f":"賃金明細表介護員用!H4","v":0},0,{"$f":"賃金明細表介護員用!I4","v":0},0,{"$f":"賃金明細表介護員用!J4","v":0},0,{"$f":"賃金明細表介護員用!K4","v":0},0,{"$f":"SUM(D5,F5,H5,J5,L5,N5)","v":0},0,{"$f":"Q5-P5","v":0},{"$f":"IF(Q5=0,\"\",Q5/収入!$Q$11)","v":""}]
[null,"給与　その他",null,{"$f":"賃金明細表事務職他!F4","v":0},0,{"$f":"賃金明細表事務職他!G4","v":0},0,{"$f":"賃金明細表事務職他!H4","v":0},0,{"$f":"賃金明細表事務職他!I4","v":0},0,{"$f":"賃金明細表事務職他!J4","v":0},0,{"$f":"賃金明細表事務職他!K4","v":0},0,0,0,0,{"$f":"IF(Q6=0,\"\",Q6/収入!$Q$11)","v":""}]
[null,"給与　新規",null,{"$f":"賃金明細表新人職員用!F4","v":0},0,{"$f":"賃金明細表新人職員用!G4","v":0},0,{"$f":"賃金明細表新人職員用!H4","v":0},0,{"$f":"賃金明細表新人職員用!I4","v":0},0,{"$f":"賃金明細表新人職員用!J4","v":0},0,{"$f":"賃金明細表新人職員用!K4","v":0},0,0,0,0,{"$f":"IF(Q7=0,\"\",Q7/収入!$Q$11)","v":""}]
[null,"退職金・退職共済掛金",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q8=0,\"\",Q8/収入!$Q$11)","v":""}]
[null,"法定福利費",null,{"$f":"ROUND((D4+D5+D6+D7+D11+D12+D13+D14)*0.16,0)","v":0},0,{"$f":"ROUND((F4+F5+F6+F7+F11+F12+F13+F14)*0.16,0)","v":0},0,{"$f":"ROUND((H4+H5+H6+H7+H11+H12+H13+H14)*0.16,0)","v":0},0,{"$f":"ROUND((J4+J5+J6+J7+J11+J12+J13+J14)*0.16,0)","v":0},0,{"$f":"ROUND((L4+L5+L6+L7+L11+L12+L13+L14)*0.16,0)","v":0},0,{"$f":"ROUND((N4+N5+N6+N7+N11+N12+N13+N14)*0.16,0)","v":0},0,0,0,0,{"$f":"IF(Q9=0,\"\",Q9/収入!$Q$11)","v":""}]
[null,"給与　計",{"$f":"SUM(C4:C9)","v":0},{"$f":"SUM(D4:D9)","v":0},{"$f":"SUM(E4:E9)","v":0},0,{"$f":"SUM(G4:G9)","v":0},0,{"$f":"SUM(I4:I9)","v":0},0,{"$f":"SUM(K4:K9)","v":0},0,{"$f":"SUM(M4:M9)","v":0},0,{"$f":"SUM(O4:O9)","v":0},{"$f":"SUM(P4:P9)","v":0},{"$f":"SUM(Q4:Q9)","v":0},0,{"$f":"IF(Q10=0,\"\",Q10/収入!$Q$11)","v":""}]
[null,"賞与　看護師",null,null,0,null,0,null,0,{"$f":"賃金明細表看護師用!I5","v":0},0,null,0,null,0,{"$f":"SUM(D11,F11,H11,J11,L11,N11)","v":0},0,0,{"$f":"IF(Q11=0,\"\",Q11/収入!$Q$11)","v":""}]
[null,"賞与　介護員",null,null,0,null,0,null,0,{"$f":"賃金明細表介護員用!I5","v":0},0,null,0,null,0,0,0,0,{"$f":"IF(Q12=0,\"\",Q12/収入!$Q$11)","v":""}]
[null,"賞与　その他",null,null,0,null,0,null,0,{"$f":"賃金明細表事務職他!I5","v":0},0,null,0,null,0,0,0,0,{"$f":"IF(Q13=0,\"\",Q13/収入!$Q$11)","v":""}]
[null,"賞与　新規",null,null,0,null,0,null,0,{"$f":"賃金明細表新人職員用!I5","v":0},0,null,0,null,0,0,0,0,{"$f":"IF(Q14=0,\"\",Q14/収入!$Q$11)","v":""}]
[null,"賞与　計",{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0},{"$f":"SUM(E11:E14)","v":0},{"$f":"SUM(F11:F14)","v":0},{"$f":"SUM(G11:G14)","v":0},{"$f":"SUM(H11:H14)","v":0},{"$f":"SUM(I11:I14)","v":0},0,{"$f":"SUM(K11:K14)","v":0},{"$f":"SUM(L11:L14)","v":0},{"$f":"SUM(M11:M14)","v":0},{"$f":"SUM(N11:N14)","v":0},{"$f":"SUM(O11:O14)","v":0},0,{"$f":"SUM(Q11:Q14)","v":0},0,{"$f":"IF(Q15=0,\"\",Q15/収入!$Q$11)","v":""}]
[null,"医薬品費",null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(D16,F16,H16,J16,L16,N16)","v":0},0,0,{"$f":"IF(Q16=0,\"\",Q16/収入!$Q$11)","v":""}]
[null,"診療材料費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q17=0,\"\",Q17/収入!$Q$11)","v":""}]
[null,"施設消耗器具備品費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q18=0,\"\",Q18/収入!$Q$11)","v":""}]
[null,"給食用材料費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q19=0,\"\",Q19/収入!$Q$11)","v":""}]
[null,"材料費　計",{"$f":"SUM(C16:C19)","v":0},{"$f":"SUM(D16:D19)","v":0},{"$f":"SUM(E16:E19)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P16:P19)","v":0},{"$f":"SUM(Q16:Q19)","v":0},0,{"$f":"IF(Q20=0,\"\",Q20/収入!$Q$11)","v":""}]
[null,"委託費",null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(D21,F21,H21,J21,L21,N21)","v":0},{"$f":"SUM(E21,G21,I21,K21,M21,O21)","v":0},0,{"$f":"IF(Q21=0,\"\",Q21/収入!$Q$11)","v":""}]
[null,"委託費　計",{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P21","v":0},0,0,{"$f":"IF(Q22=0,\"\",Q22/収入!$Q$11)","v":""}]
[null,"減価償却費1",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"N23","v":0},{"$f":"SUM(D23,F23,H23,J23,L23,N23)","v":0},0,0,{"$f":"IF(Q23=0,\"\",Q23/収入!$Q$11)","v":""}]
[null,"減価償却費2",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q24=0,\"\",Q24/収入!$Q$11)","v":""}]
[null,"賃借料",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q25=0,\"\",Q25/収入!$Q$11)","v":""}]
[null,"地代家賃",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q26=0,\"\",Q26/収入!$Q$11)","v":""}]
[null,"修繕費1",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q27=0,\"\",Q27/収入!$Q$11)","v":""}]
[null,"修繕費2",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q28=0,\"\",Q28/収入!$Q$11)","v":""}]
[null,"車両費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q29=0,\"\",Q29/収入!$Q$11)","v":""}]
[null,"設備関係費　計",{"$f":"SUM(C23:C29)","v":0},{"$f":"SUM(D23:D29)","v":0},{"$f":"SUM(E23:E29)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P23:P29)","v":0},{"$f":"SUM(Q23:Q29)","v":0},0,{"$f":"IF(Q30=0,\"\",Q30/収入!$Q$11)","v":""}]
[null,"図書費",null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(D31,F31,H31,J31,L31,N31)","v":0},0,0,{"$f":"IF(Q31=0,\"\",Q31/収入!$Q$11)","v":""}]
[null,"研修費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q32=0,\"\",Q32/収入!$Q$11)","v":""}]
[null,"図書研修費　計",{"$f":"SUM(C31:C32)","v":0},{"$f":"SUM(D31:D32)","v":0},{"$f":"SUM(E31:E32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P31:P32)","v":0},0,0,{"$f":"IF(Q33=0,\"\",Q33/収入!$Q$11)","v":""}]
[null,"福利厚生費",null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(D34,F34,H34,J34,L34,N34)","v":0},0,0,{"$f":"IF(Q34=0,\"\",Q34/収入!$Q$11)","v":""}]
[null,"旅費交通費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q35=0,\"\",Q35/収入!$Q$11)","v":""}]
[null,"職員被服費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q36=0,\"\",Q36/収入!$Q$11)","v":""}]
[null,"通信費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q37=0,\"\",Q37/収入!$Q$11)","v":""}]
[null,"広告宣伝費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q38=0,\"\",Q38/収入!$Q$11)","v":""}]
[null,"消耗品費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q39=0,\"\",Q39/収入!$Q$11)","v":""}]
[null,"消耗器具備品費1",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q40=0,\"\",Q40/収入!$Q$11)","v":""}]
[null,"消耗器具備品費2",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q41=0,\"\",Q41/収入!$Q$11)","v":""}]
[null,"会議費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q42=0,\"\",Q42/収入!$Q$11)","v":""}]
[null,"水道光熱費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q43=0,\"\",Q43/収入!$Q$11)","v":""}]
[null,"保険料",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q44=0,\"\",Q44/収入!$Q$11)","v":""}]
[null,"交際費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q45=0,\"\",Q45/収入!$Q$11)","v":""}]
[null,"諸会費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q46=0,\"\",Q46/収入!$Q$11)","v":""}]
[null,"租税公課",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q47=0,\"\",Q47/収入!$Q$11)","v":""}]
[null,"雑費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q48=0,\"\",Q48/収入!$Q$11)","v":""}]
[null,"管理諸費",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q49=0,\"\",Q49/収入!$Q$11)","v":""}]
[null,"税理士等報酬",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q50=0,\"\",Q50/収入!$Q$11)","v":""}]
[null,"その他　費用",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q51=0,\"\",Q51/収入!$Q$11)","v":""}]
[null,"経費　計",{"$f":"SUM(C34:C51)","v":0},{"$f":"SUM(D34:D51)","v":0},{"$f":"SUM(E34:E51)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P34:P51)","v":0},{"$f":"SUM(Q34:Q51)","v":0},0,{"$f":"IF(Q52=0,\"\",Q52/収入!$Q$11)","v":""}]
["施設運営事業費用計",null,{"$f":"C10+C15+C20+C22+C30+C33+C52","v":0},{"$f":"D10+D15+D20+D22+D30+D33+D52","v":0},{"$f":"E10+E15+E20+E22+E30+E33+E52","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P10+P15+P20+P22+P30+P33+P52","v":0},{"$f":"Q10+Q15+Q20+Q22+Q30+Q33+Q52","v":0},0,{"$f":"IF(Q53=0,\"\",Q53/収入!$Q$11)","v":""}]
["施設運営事業利益",null,{"$f":"収入!C11-支出1!C53","v":0},{"$f":"収入!D11-支出1!D53","v":0},{"$f":"収入!E11-支出1!E53","v":0},{"$f":"収入!F11-支出1!F53","v":0},{"$f":"収入!G11-支出1!G53","v":0},{"$f":"収入!H11-支出1!H53","v":0},{"$f":"収入!I11-支出1!I53","v":0},{"$f":"収入!J11-支出1!J53","v":0},{"$f":"収入!K11-支出1!K53","v":0},{"$f":"収入!L11-支出1!L53","v":0},{"$f":"収入!M11-支出1!M53","v":0},{"$f":"収入!N11-支出1!N53","v":0},{"$f":"収入!O11-支出1!O53","v":0},{"$f":"収入!P11-支出1!P53","v":0},{"$f":"収入!Q11-支出1!Q53","v":0},0,{"$f":"IF(Q54=0,\"\",Q54/収入!$Q$11)","v":""}]
["施設運営事業外収益","受取利息及び配当金",null,null,0,null,{"$f":"F55","v":0},null,{"$f":"H55","v":0},null,{"$f":"J55","v":0},null,{"$f":"L55","v":0},null,{"$f":"N55","v":0},{"$f":"SUM(D55,F55,H55,J55,L55,N55)","v":0},0,0,{"$f":"IF(Q55=0,\"\",Q55/収入!$Q$11)","v":""}]
[null,"雑収入",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q56=0,\"\",Q56/収入!$Q$11)","v":""}]
["施設運営事業外収益計",null,{"$f":"SUM(C55:C56)","v":0},{"$f":"SUM(D55:D56)","v":0},{"$f":"SUM(E55:E56)","v":0},{"$f":"SUM(F55:F56)","v":0},{"$f":"SUM(G55:G56)","v":0},0,{"$f":"SUM(I55:I56)","v":0},0,{"$f":"SUM(K55:K56)","v":0},{"$f":"SUM(L55:L56)","v":0},{"$f":"SUM(M55:M56)","v":0},{"$f":"SUM(N55:N56)","v":0},{"$f":"SUM(O55:O56)","v":0},{"$f":"SUM(P55:P56)","v":0},{"$f":"SUM(Q55:Q56)","v":0},0,{"$f":"IF(Q57=0,\"\",Q57/収入!$Q$11)","v":""}]
["施設運営事業外費用","支払利息",null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(D58,F58,H58,J58,L58,N58)","v":0},0,0,{"$f":"IF(Q58=0,\"\",Q58/収入!$Q$11)","v":""}]
[null,"雑損失",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(Q59=0,\"\",Q59/収入!$Q$11)","v":""}]
["施設運営事業外費用計",null,{"$f":"SUM(C58:C59)","v":0},{"$f":"SUM(D58:D59)","v":0},{"$f":"SUM(E58:E59)","v":0},{"$f":"SUM(F58:F59)","v":0},{"$f":"SUM(G58:G59)","v":0},0,{"$f":"SUM(I58:I59)","v":0},0,{"$f":"SUM(K58:K59)","v":0},{"$f":"SUM(L58:L59)","v":0},{"$f":"SUM(M58:M59)","v":0},{"$f":"SUM(N58:N59)","v":0},{"$f":"SUM(O58:O59)","v":0},{"$f":"SUM(P58:P59)","v":0},{"$f":"SUM(Q58:Q59)","v":0},0,{"$f":"IF(Q60=0,\"\",Q60/収入!$Q$11)","v":""}]
["経常利益",null,{"$f":"C54+C57-C60","v":0},{"$f":"D54+D57-D60","v":0},{"$f":"E54+E57-E60","v":0},0,{"$f":"G54+G57-G60","v":0},0,{"$f":"I54+I57-I60","v":0},0,{"$f":"K54+K57-K60","v":0},0,{"$f":"M54+M57-M60","v":0},0,{"$f":"O54+O57-O60","v":0},0,0,0,{"$f":"IF(Q61=0,\"\",Q61/収入!$Q$11)","v":""}]

{"sheet":"支出2","index":4,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,1],[60,0,60,1],[2,0,2,1],[3,0,51,0],[52,0,52,1],[54,0,55,0],[56,0,56,1],[57,0,58,0]]}
[{"$f":"IF(収入!A1=\"\",\"\",収入!A1)","v":27},"年度老健予算計画"]
[null,"支出の部",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["科目　区分",null,"上半期予算","上半期実績","10月予算","10月実績","11月予算","11月実績","12月予算","12月実績","１月予算","１月実績","２月予算","２月実績","３月予算","３月実績","年間予算計","年間実績計","年間予実対比","年間構成（収入比）"]
["施設運営事業費用","給与　看護師",{"$f":"支出1!P4","v":0},{"$f":"支出1!Q4","v":0},{"$f":"賃金明細表看護師用!L4","v":0},{"$f":"E4","v":0},{"$f":"賃金明細表看護師用!M4","v":0},{"$f":"G4","v":0},{"$f":"賃金明細表看護師用!N4","v":0},{"$f":"I4","v":0},{"$f":"賃金明細表看護師用!O4","v":0},{"$f":"K4","v":0},{"$f":"賃金明細表看護師用!P4","v":0},{"$f":"M4","v":0},{"$f":"賃金明細表看護師用!Q4","v":0},{"$f":"O4","v":0},{"$f":"SUM(C4,E4,G4,I4,K4,M4,O4)","v":0},{"$f":"SUM(D4,F4,H4,J4,L4,N4,P4)","v":0},{"$f":"R4-Q4","v":0},{"$f":"IF(R4=0,\"\",R4/収入!$Q$20)","v":""}]
[null,"給与　介護員",{"$f":"支出1!P5","v":0},{"$f":"支出1!Q5","v":0},{"$f":"賃金明細表介護員用!L4","v":0},{"$f":"E5","v":0},{"$f":"賃金明細表介護員用!M4","v":0},0,{"$f":"賃金明細表介護員用!N4","v":0},0,{"$f":"賃金明細表介護員用!O4","v":0},0,{"$f":"賃金明細表介護員用!P4","v":0},0,{"$f":"賃金明細表介護員用!Q4","v":0},0,{"$f":"SUM(C5,E5,G5,I5,K5,M5,O5)","v":0},{"$f":"SUM(D5,F5,H5,J5,L5,N5,P5)","v":0},{"$f":"R5-Q5","v":0},{"$f":"IF(R5=0,\"\",R5/収入!$Q$20)","v":""}]
[null,"給与　その他",{"$f":"支出1!P6","v":0},{"$f":"支出1!Q6","v":0},{"$f":"賃金明細表事務職他!L4","v":0},0,{"$f":"賃金明細表事務職他!M4","v":0},0,{"$f":"賃金明細表事務職他!N4","v":0},0,{"$f":"賃金明細表事務職他!O4","v":0},0,{"$f":"賃金明細表事務職他!P4","v":0},0,{"$f":"賃金明細表事務職他!Q4","v":0},0,0,0,0,{"$f":"IF(R6=0,\"\",R6/収入!$Q$20)","v":""}]
[null,"給与　新規",{"$f":"支出1!P7","v":0},{"$f":"支出1!Q7","v":0},{"$f":"賃金明細表新人職員用!L4","v":0},0,{"$f":"賃金明細表新人職員用!M4","v":0},0,{"$f":"賃金明細表新人職員用!N4","v":0},0,{"$f":"賃金明細表新人職員用!O4","v":0},0,{"$f":"賃金明細表新人職員用!P4","v":0},0,{"$f":"賃金明細表新人職員用!Q4","v":0},0,0,0,0,{"$f":"IF(R7=0,\"\",R7/収入!$Q$20)","v":""}]
[null,"退職金・退職共済掛金",{"$f":"支出1!P8","v":0},{"$f":"支出1!Q8","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R8=0,\"\",R8/収入!$Q$20)","v":""}]
[null,"法定福利費",{"$f":"支出1!P9","v":0},{"$f":"支出1!Q9","v":0},{"$f":"ROUND((E4+E5+E6+E7+E11+E12+E13+E14)*0.16,0)","v":0},0,{"$f":"ROUND((G4+G5+G6+G7+G11+G12+G13+G14)*0.16,0)","v":0},0,{"$f":"ROUND((I4+I5+I6+I7+I11+I12+I13+I14)*0.16,0)","v":0},0,{"$f":"ROUND((K4+K5+K6+K7+K11+K12+K13+K14)*0.16,0)","v":0},0,{"$f":"ROUND((M4+M5+M6+M7+M11+M12+M13+M14)*0.16,0)","v":0},0,{"$f":"ROUND((O4+O5+O6+O7+O11+O12+O13+O14)*0.16,0)","v":0},0,0,0,0,{"$f":"IF(R9=0,\"\",R9/収入!$Q$20)","v":""}]
[null,"給与　計",{"$f":"支出1!P10","v":0},{"$f":"支出1!Q10","v":0},{"$f":"SUM(E4:E9)","v":0},{"$f":"SUM(F4:F9)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(N4:N9)","v":0},0,{"$f":"SUM(P4:P9)","v":0},{"$f":"SUM(Q4:Q9)","v":0},{"$f":"SUM(R4:R9)","v":0},0,{"$f":"IF(R10=0,\"\",R10/収入!$Q$20)","v":""}]
[null,"賞与　看護師",{"$f":"支出1!P11","v":0},{"$f":"支出1!Q11","v":0},null,0,null,0,{"$f":"賃金明細表看護師用!N5","v":0},0,null,0,null,0,null,0,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11)","v":0},{"$f":"SUM(D11,F11,H11,J11,L11,N11,P11)","v":0},0,{"$f":"IF(R11=0,\"\",R11/収入!$Q$20)","v":""}]
[null,"賞与　介護員",{"$f":"支出1!P12","v":0},{"$f":"支出1!Q12","v":0},null,0,null,0,{"$f":"賃金明細表介護員用!N5","v":0},0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R12=0,\"\",R12/収入!$Q$20)","v":""}]
[null,"賞与　その他",{"$f":"支出1!P13","v":0},{"$f":"支出1!Q13","v":0},null,0,null,0,{"$f":"賃金明細表事務職他!N5","v":0},0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R13=0,\"\",R13/収入!$Q$20)","v":""}]
[null,"賞与　新規",{"$f":"支出1!P14","v":0},{"$f":"支出1!Q14","v":0},null,0,null,0,{"$f":"賃金明細表新人職員用!N5","v":0},0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R14=0,\"\",R14/収入!$Q$20)","v":""}]
[null,"賞与　計",{"$f":"支出1!P15","v":0},{"$f":"支出1!Q15","v":0},{"$f":"SUM(E11:E14)","v":0},{"$f":"SUM(F11:F14)","v":0},{"$f":"SUM(G11:G14)","v":0},{"$f":"SUM(H11:H14)","v":0},{"$f":"SUM(I11:I14)","v":0},{"$f":"SUM(J11:J14)","v":0},0,0,{"$f":"SUM(M11:M14)","v":0},{"$f":"SUM(N11:N14)","v":0},{"$f":"SUM(O11:O14)","v":0},{"$f":"SUM(P11:P14)","v":0},0,0,0,{"$f":"IF(R15=0,\"\",R15/収入!$Q$20)","v":""}]
[null,"医薬品費",{"$f":"支出1!P16","v":0},{"$f":"支出1!Q16","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C16,E16,G16,I16,K16,M16,O16)","v":0},{"$f":"SUM(D16,F16,H16,J16,L16,N16,P16)","v":0},0,{"$f":"IF(R16=0,\"\",R16/収入!$Q$20)","v":""}]
[null,"診療材料費",{"$f":"支出1!P17","v":0},{"$f":"支出1!Q17","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R17=0,\"\",R17/収入!$Q$20)","v":""}]
[null,"施設消耗器具備品費",{"$f":"支出1!P18","v":0},{"$f":"支出1!Q18","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R18=0,\"\",R18/収入!$Q$20)","v":""}]
[null,"給食用材料費",{"$f":"支出1!P19","v":0},{"$f":"支出1!Q19","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R19=0,\"\",R19/収入!$Q$20)","v":""}]
[null,"材料費　計",{"$f":"支出1!P20","v":0},{"$f":"支出1!Q20","v":0},{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q16:Q19)","v":0},{"$f":"SUM(R16:R19)","v":0},0,{"$f":"IF(R20=0,\"\",R20/収入!$Q$20)","v":""}]
[null,"委託費",{"$f":"支出1!P21","v":0},{"$f":"支出1!Q21","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C21,E21,G21,I21,K21,M21,O21)","v":0},{"$f":"SUM(D21,F21,H21,J21,L21,N21,P21)","v":0},0,{"$f":"IF(R21=0,\"\",R21/収入!$Q$20)","v":""}]
[null,"委託費　計",{"$f":"支出1!P22","v":0},{"$f":"支出1!Q22","v":0},{"$f":"E21","v":0},{"$f":"F21","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q21","v":0},0,0,{"$f":"IF(R22=0,\"\",R22/収入!$Q$20)","v":""}]
[null,"減価償却費1",{"$f":"支出1!P23","v":0},{"$f":"支出1!Q23","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C23,E23,G23,I23,K23,M23,O23)","v":0},{"$f":"SUM(D23,F23,H23,J23,L23,N23,P23)","v":0},0,{"$f":"IF(R23=0,\"\",R23/収入!$Q$20)","v":""}]
[null,"減価償却費2",{"$f":"支出1!P24","v":0},{"$f":"支出1!Q24","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R24=0,\"\",R24/収入!$Q$20)","v":""}]
[null,"賃借料",{"$f":"支出1!P25","v":0},{"$f":"支出1!Q25","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R25=0,\"\",R25/収入!$Q$20)","v":""}]
[null,"地代家賃",{"$f":"支出1!P26","v":0},{"$f":"支出1!Q26","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R26=0,\"\",R26/収入!$Q$20)","v":""}]
[null,"修繕費1",{"$f":"支出1!P27","v":0},{"$f":"支出1!Q27","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R27=0,\"\",R27/収入!$Q$20)","v":""}]
[null,"修繕費2",{"$f":"支出1!P28","v":0},{"$f":"支出1!Q28","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R28=0,\"\",R28/収入!$Q$20)","v":""}]
[null,"車両費",{"$f":"支出1!P29","v":0},{"$f":"支出1!Q29","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R29=0,\"\",R29/収入!$Q$20)","v":""}]
[null,"設備関係費　計",{"$f":"支出1!P30","v":0},{"$f":"支出1!Q30","v":0},{"$f":"SUM(E23:E29)","v":0},{"$f":"SUM(F23:F29)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q23:Q29)","v":0},{"$f":"SUM(R23:R29)","v":0},0,{"$f":"IF(R30=0,\"\",R30/収入!$Q$20)","v":""}]
[null,"図書費",{"$f":"支出1!P31","v":0},{"$f":"支出1!Q31","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C31,E31,G31,I31,K31,M31,O31)","v":0},{"$f":"SUM(D31,F31,H31,J31,L31,N31,P31)","v":0},0,{"$f":"IF(R31=0,\"\",R31/収入!$Q$20)","v":""}]
[null,"研修費",{"$f":"支出1!P32","v":0},{"$f":"支出1!Q32","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R32=0,\"\",R32/収入!$Q$20)","v":""}]
[null,"図書研修費　計",{"$f":"支出1!P33","v":0},{"$f":"支出1!Q33","v":0},{"$f":"SUM(E31:E32)","v":0},{"$f":"SUM(F31:F32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q31:Q32)","v":0},0,0,{"$f":"IF(R33=0,\"\",R33/収入!$Q$20)","v":""}]
[null,"福利厚生費",{"$f":"支出1!P34","v":0},{"$f":"支出1!Q34","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C34,E34,G34,I34,K34,M34,O34)","v":0},{"$f":"SUM(D34,F34,H34,J34,L34,N34,P34)","v":0},0,{"$f":"IF(R34=0,\"\",R34/収入!$Q$20)","v":""}]
[null,"旅費交通費",{"$f":"支出1!P35","v":0},{"$f":"支出1!Q35","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R35=0,\"\",R35/収入!$Q$20)","v":""}]
[null,"職員被服費",{"$f":"支出1!P36","v":0},{"$f":"支出1!Q36","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R36=0,\"\",R36/収入!$Q$20)","v":""}]
[null,"通信費",{"$f":"支出1!P37","v":0},{"$f":"支出1!Q37","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R37=0,\"\",R37/収入!$Q$20)","v":""}]
[null,"広告宣伝費",{"$f":"支出1!P38","v":0},{"$f":"支出1!Q38","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R38=0,\"\",R38/収入!$Q$20)","v":""}]
[null,"消耗品費",{"$f":"支出1!P39","v":0},{"$f":"支出1!Q39","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R39=0,\"\",R39/収入!$Q$20)","v":""}]
[null,"消耗器具備品費1",{"$f":"支出1!P40","v":0},{"$f":"支出1!Q40","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R40=0,\"\",R40/収入!$Q$20)","v":""}]
[null,"消耗器具備品費2",{"$f":"支出1!P41","v":0},{"$f":"支出1!Q41","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R41=0,\"\",R41/収入!$Q$20)","v":""}]
[null,"会議費",{"$f":"支出1!P42","v":0},{"$f":"支出1!Q42","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R42=0,\"\",R42/収入!$Q$20)","v":""}]
[null,"水道光熱費",{"$f":"支出1!P43","v":0},{"$f":"支出1!Q43","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R43=0,\"\",R43/収入!$Q$20)","v":""}]
[null,"保険料",{"$f":"支出1!P44","v":0},{"$f":"支出1!Q44","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R44=0,\"\",R44/収入!$Q$20)","v":""}]
[null,"交際費",{"$f":"支出1!P45","v":0},{"$f":"支出1!Q45","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R45=0,\"\",R45/収入!$Q$20)","v":""}]
[null,"諸会費",{"$f":"支出1!P46","v":0},{"$f":"支出1!Q46","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R46=0,\"\",R46/収入!$Q$20)","v":""}]
[null,"租税公課",{"$f":"支出1!P47","v":0},{"$f":"支出1!Q47","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R47=0,\"\",R47/収入!$Q$20)","v":""}]
[null,"雑費",{"$f":"支出1!P48","v":0},{"$f":"支出1!Q48","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R48=0,\"\",R48/収入!$Q$20)","v":""}]
[null,"管理諸費",{"$f":"支出1!P49","v":0},{"$f":"支出1!Q49","v":0},null,0,null,0,null,0,null,{"$f":"K49","v":0},null,0,null,{"$f":"O49","v":0},0,0,0,{"$f":"IF(R49=0,\"\",R49/収入!$Q$20)","v":""}]
[null,"税理士等報酬",{"$f":"支出1!P50","v":0},{"$f":"支出1!Q50","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R50=0,\"\",R50/収入!$Q$20)","v":""}]
[null,"その他　費用",{"$f":"支出1!P51","v":0},{"$f":"支出1!Q51","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R51=0,\"\",R51/収入!$Q$20)","v":""}]
[null,"経費　計",{"$f":"支出1!P52","v":0},{"$f":"支出1!Q52","v":0},{"$f":"SUM(E34:E51)","v":0},{"$f":"SUM(F34:F51)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q34:Q51)","v":0},{"$f":"SUM(R34:R51)","v":0},0,{"$f":"IF(R52=0,\"\",R52/収入!$Q$20)","v":""}]
["施設運営事業費用計",null,{"$f":"支出1!P53","v":0},{"$f":"支出1!Q53","v":0},{"$f":"E10+E15+E20+E22+E30+E33+E52","v":0},{"$f":"F10+F15+F20+F22+F30+F33+F52","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q10+Q15+Q20+Q22+Q30+Q33+Q52","v":0},{"$f":"R10+R15+R20+R22+R30+R33+R52","v":0},0,{"$f":"IF(R53=0,\"\",R53/収入!$Q$20)","v":""}]
["施設運営事業利益",null,{"$f":"支出1!P54","v":0},{"$f":"支出1!Q54","v":0},{"$f":"収入!D20-支出2!E53","v":0},{"$f":"収入!E20-支出2!F53","v":0},{"$f":"収入!F20-支出2!G53","v":0},{"$f":"収入!G20-支出2!H53","v":0},{"$f":"収入!H20-支出2!I53","v":0},{"$f":"収入!I20-支出2!J53","v":0},{"$f":"収入!J20-支出2!K53","v":0},{"$f":"収入!K20-支出2!L53","v":0},{"$f":"収入!L20-支出2!M53","v":0},{"$f":"収入!M20-支出2!N53","v":0},{"$f":"収入!N20-支出2!O53","v":0},{"$f":"収入!O20-支出2!P53","v":0},{"$f":"収入!P20-支出2!Q53","v":0},{"$f":"収入!Q20-支出2!R53","v":0},0,{"$f":"IF(R54=0,\"\",R54/収入!$Q$20)","v":""}]
["施設運営事業外収益","受取利息及び配当金",{"$f":"支出1!P55","v":0},{"$f":"支出1!Q55","v":0},null,0,null,{"$f":"G55","v":0},null,{"$f":"I55","v":0},null,{"$f":"K55","v":0},null,{"$f":"M55","v":0},null,{"$f":"O55","v":0},{"$f":"SUM(C55,E55,G55,I55,K55,M55,O55)","v":0},{"$f":"SUM(D55,F55,H55,J55,L55,N55,P55)","v":0},0,{"$f":"IF(R55=0,\"\",R55/収入!$Q$20)","v":""}]
[null,"雑収入",{"$f":"支出1!P56","v":0},{"$f":"支出1!Q56","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R56=0,\"\",R56/収入!$Q$20)","v":""}]
["施設運営事業外収益計",null,{"$f":"支出1!P57","v":0},{"$f":"支出1!Q57","v":0},{"$f":"SUM(E55:E56)","v":0},{"$f":"SUM(F55:F56)","v":0},{"$f":"SUM(G55:G56)","v":0},{"$f":"SUM(H55:H56)","v":0},0,{"$f":"SUM(J55:J56)","v":0},0,{"$f":"SUM(L55:L56)","v":0},{"$f":"SUM(M55:M56)","v":0},{"$f":"SUM(N55:N56)","v":0},{"$f":"SUM(O55:O56)","v":0},{"$f":"SUM(P55:P56)","v":0},{"$f":"SUM(Q55:Q56)","v":0},{"$f":"SUM(R55:R56)","v":0},0,{"$f":"IF(R57=0,\"\",R57/収入!$Q$20)","v":""}]
["施設運営事業外費用","支払利息",{"$f":"支出1!P58","v":0},{"$f":"支出1!Q58","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(C58,E58,G58,I58,K58,M58,O58)","v":0},{"$f":"SUM(D58,F58,H58,J58,L58,N58,P58)","v":0},0,{"$f":"IF(R58=0,\"\",R58/収入!$Q$20)","v":""}]
[null,"雑損失",{"$f":"支出1!P59","v":0},{"$f":"支出1!Q59","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,{"$f":"IF(R59=0,\"\",R59/収入!$Q$20)","v":""}]
["施設運営事業外費用計",null,{"$f":"支出1!P60","v":0},{"$f":"支出1!Q60","v":0},{"$f":"SUM(E58:E59)","v":0},{"$f":"SUM(F58:F59)","v":0},{"$f":"SUM(G58:G59)","v":0},{"$f":"SUM(H58:H59)","v":0},0,{"$f":"SUM(J58:J59)","v":0},0,{"$f":"SUM(L58:L59)","v":0},{"$f":"SUM(M58:M59)","v":0},{"$f":"SUM(N58:N59)","v":0},{"$f":"SUM(O58:O59)","v":0},{"$f":"SUM(P58:P59)","v":0},{"$f":"SUM(Q58:Q59)","v":0},{"$f":"SUM(R58:R59)","v":0},0,{"$f":"IF(R60=0,\"\",R60/収入!$Q$20)","v":""}]
["経常利益",null,{"$f":"支出1!P61","v":0},{"$f":"支出1!Q61","v":0},{"$f":"E54+E57-E60","v":0},{"$f":"F54+F57-F60","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q54+Q57-Q60","v":0},0,0,{"$f":"IF(R61=0,\"\",R61/収入!$Q$20)","v":""}]

{"sheet":"賃金明細表看護師用","index":5,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[112,2,112,4],[113,2,113,4],[114,2,114,4],[115,2,115,4],[0,0,0,17],[2,2,2,4],[3,2,3,4],[4,2,4,4],[111,2,111,4],[5,15,5,16]]}
["基準内賃金明細表　看護師用"]
[]
[null,null,{"$f":"\"平成\"&収入!A1&\"年度\"","v":"平成27年度"},null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"月別合計",null,null,{"$f":"O9-F112","v":0},{"$f":"F4-G112","v":0},0,{"$f":"H4-I112","v":0},0,0,0,0,0,0,0,0]
[null,null,"賞与合計",null,null,null,null,null,{"$f":"P9-(F115+G115+H115+I115)","v":0},null,null,null,null,{"$f":"Q9-(F116+G116+H116+I116+J116+K116+L116+M116+N116)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"夏期冬期賞与を入力して下さい。\n↓↓↓↓↓↓↓↓",null,"（単位：円）"]
[null,"氏名","等号",null,null,"本　給","等級資格","固定職種","固定役職","職務","調整","通勤","家族","その他","月計","夏　期","冬　期","退職"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"手当",null,"賞与（７月）","賞与（12月）","予定月"]
[null,"合計",null,null,null,{"$f":"SUMIF($A$10:$A$109,\">=1\",F10:F109)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$10:$A$109,\">=1\",P10:P109)","v":0},{"$f":"SUMIF($A$10:$A$109,\">=1\",Q10:Q109)","v":0}]
[1,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:N10)","v":0}]
[2,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:N35)","v":0}]
[27,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F36:N36)","v":0}]
[28,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F73:N73)","v":0}]
[65,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[67,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"給与",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"1月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"2月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"3月\",$O$10:$O$109)","v":0}]
[null,null,"退職者",null,null,{"$f":"COUNTA(F10:F109)","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"5月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"6月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"7月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"8月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"9月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"10月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"11月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"12月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"1月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"2月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"3月\",$O$10:$O$109,\"<>\")","v":0}]
[null,null,"在職者",null,null,null,{"$f":"F113-G113","v":0},{"$f":"G114-H113","v":0},{"$f":"H114-I113","v":0},0,0,0,0,0,0,0,0]
[null,null,"夏期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$P$10:$P$109)","v":0}]
[null,null,"冬期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$Q$10:$Q$109)","v":0}]

{"sheet":"賃金明細表介護員用","index":6,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[115,2,115,4],[111,2,111,4],[112,2,112,4],[113,2,113,4],[0,0,0,17],[2,2,2,4],[3,2,3,4],[4,2,4,4],[114,2,114,4],[5,15,5,16]]}
["基準内賃金明細表　介護員用"]
[]
[null,null,{"$f":"\"平成\"&収入!A1&\"年度\"","v":"平成27年度"},null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"月別合計",null,null,{"$f":"O9-F112","v":0},{"$f":"F4-G112","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"賞与合計",null,null,null,null,null,{"$f":"P9-(F115+G115+H115+I115)","v":0},null,null,null,null,{"$f":"Q9-(F116+G116+H116+I116+J116+K116+L116+M116+N116)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"夏期冬期賞与を入力して下さい。\n↓↓↓↓↓↓↓↓",null,"（単位：円）"]
[null,"氏名","等号",null,null,"本　給","等級資格","固定職種","固定役職","職務","調整","通勤","家族","その他","月計","夏　期","冬　期","退職"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"手当",null,"賞与（７月）","賞与（12月）","予定月"]
[null,"合計",null,null,null,{"$f":"SUMIF($A$10:$A$109,\">=1\",F10:F109)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$10:$A$109,\">=1\",P10:P109)","v":0},{"$f":"SUMIF($A$10:$A$109,\">=1\",Q10:Q109)","v":0}]
[1,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:N10)","v":0}]
[2,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:N35)","v":0}]
[27,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F36:N36)","v":0}]
[28,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[65,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[67,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F96:N96)","v":0}]
[88,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"給与",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"1月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"2月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"3月\",$O$10:$O$109)","v":0}]
[null,null,"退職者",null,null,{"$f":"COUNTA(F10:F109)","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"5月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"6月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"7月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"8月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"9月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"10月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"11月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"12月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"1月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"2月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"3月\",$O$10:$O$109,\"<>\")","v":0}]
[null,null,"在職者",null,null,null,{"$f":"F113-G113","v":0},{"$f":"G114-H113","v":0},{"$f":"H114-I113","v":0},0,0,0,0,0,0,0,0]
[null,null,"夏期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$P$10:$P$109)","v":0}]
[null,null,"冬期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$Q$10:$Q$109)","v":0}]

{"sheet":"賃金明細表事務職他","index":7,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[115,2,115,4],[111,2,111,4],[112,2,112,4],[113,2,113,4],[0,0,0,17],[2,2,2,4],[3,2,3,4],[4,2,4,4],[114,2,114,4],[5,15,5,16]]}
["基準内賃金明細表　事務職他"]
[]
[null,null,{"$f":"\"平成\"&収入!A1&\"年度\"","v":"平成27年度"},null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"月別合計",null,null,{"$f":"O9-F112","v":0},{"$f":"F4-G112","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"賞与合計",null,null,null,null,null,{"$f":"P9-(F115+G115+H115+I115)","v":0},null,null,null,null,{"$f":"Q9-(F116+G116+H116+I116+J116+K116+L116+M116+N116)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"夏期冬期賞与を入力して下さい。\n↓↓↓↓↓↓↓↓",null,"（単位：円）"]
[null,"氏名","等号",null,null,"本　給","等級資格","固定職種","固定役職","職務","調整","通勤","家族","その他","月計","夏　期","冬　期","退職"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"手当",null,"賞与（７月）","賞与（12月）","予定月"]
[null,"合計",null,null,null,{"$f":"SUMIF($A$10:$A$109,\">=1\",F10:F109)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$10:$A$109,\">=1\",P10:P109)","v":0},{"$f":"SUMIF($A$10:$A$109,\">=1\",Q10:Q109)","v":0}]
[1,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:N10)","v":0}]
[2,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:N35)","v":0}]
[27,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F36:N36)","v":0}]
[28,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[65,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[67,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F91:N91)","v":0}]
[83,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"給与",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"1月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"2月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"3月\",$O$10:$O$109)","v":0}]
[null,null,"退職者",null,null,{"$f":"COUNTA(F10:F109)","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"5月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"6月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"7月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"8月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"9月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"10月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"11月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"12月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"1月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"2月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"3月\",$O$10:$O$109,\"<>\")","v":0}]
[null,null,"在職者",null,null,null,{"$f":"F113-G113","v":0},{"$f":"G114-H113","v":0},{"$f":"H114-I113","v":0},0,0,0,0,0,0,0,0]
[null,null,"夏期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$P$10:$P$109)","v":0}]
[null,null,"冬期賞与除外者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$Q$10:$Q$109)","v":0}]

{"sheet":"賃金明細表新人職員用","index":8,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[115,2,115,4],[111,2,111,4],[112,2,112,4],[113,2,113,4],[0,0,0,17],[2,2,2,4],[3,2,3,4],[4,2,4,4],[114,2,114,4],[5,15,5,16]]}
["基準内賃金明細表　新人職員用"]
[]
[null,null,{"$f":"\"平成\"&収入!A1&\"年度\"","v":"平成27年度"},null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"月別合計",null,null,{"$f":"F112","v":0},{"$f":"F4+G112","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"賞与合計",null,null,null,null,null,{"$f":"F115+G115+H115+I115","v":0},null,null,null,null,{"$f":"F116+G116+H116+I116+J116+K116+L116+M116+N116","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"夏期冬期賞与を入力して下さい。\n↓↓↓↓↓↓↓↓",null,"（単位：円）"]
[null,"氏名","等号",null,null,"本　給","等級資格","固定職種","固定役職","職務","調整","通勤","家族","その他","月計","夏　期","冬　期","入社"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"手当",null,"賞与（７月）","賞与（12月）","予定月"]
[null,"合計",null,null,null,{"$f":"SUMIF($A$10:$A$109,\">=1\",F10:F109)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$10:$A$109,\">=1\",P10:P109)","v":0},{"$f":"SUMIF($A$10:$A$109,\">=1\",Q10:Q109)","v":0}]
[1,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:N10)","v":0}]
[2,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:N35)","v":0}]
[27,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F36:N36)","v":0}]
[28,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[65,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[67,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,"－",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F100:N100)","v":0}]
[92,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,"－",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"４月","５月","６月","７月","８月","９月","１０月","１１月","１２月","１月","２月","３月"]
[null,null,"給与",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"1月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"2月\",$O$10:$O$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"3月\",$O$10:$O$109)","v":0}]
[null,null,"新入社員",null,null,{"$f":"COUNTIFS($R$10:$R$109,\"4月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"5月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"6月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"7月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"8月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"9月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"10月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"11月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"12月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"1月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"2月\",$O$10:$O$109,\"<>\")","v":0},{"$f":"COUNTIFS($R$10:$R$109,\"3月\",$O$10:$O$109,\"<>\")","v":0}]
[null,null,"在職者",null,null,null,{"$f":"F113+G113","v":0},{"$f":"G114+H113","v":0},{"$f":"H114+I113","v":0},0,0,0,0,0,0,0,0]
[null,null,"夏期賞与対象者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$P$10:$P$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$P$10:$P$109)","v":0}]
[null,null,"冬期賞与対象者",null,null,{"$f":"SUMIF($R$10:$R$109,\"4月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"5月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"6月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"7月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"8月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"9月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"10月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"11月\",$Q$10:$Q$109)","v":0},{"$f":"SUMIF($R$10:$R$109,\"12月\",$Q$10:$Q$109)","v":0}]

{"sheet":"購入計画・修繕計画","index":9,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,10,2,12],[3,0,4,2],[3,3,3,5],[3,7,4,9],[3,10,3,12],[4,3,4,5],[4,10,4,12],[41,0,41,1],[41,3,41,4],[2,0,2,2],[2,3,2,5],[2,7,2,9]]}
["器具・備品・機械購入計画",null,null,null,null,null,null,"修繕計画"]
[]
["30万円未満",null,null,"30万円超",null,null,null,"原状回復工事",null,null,"改良工事"]
["消耗器具備品費2欄へ手入力してください",null,null,"減価償却費2欄へ手入力してください",null,null,null,"修繕費2欄へ手入力してください",null,null,"減価償却費2欄へ手入力してください"]
[null,null,null,"税理士へ償却費確認",null,null,null,null,null,null,"税理士へ償却費確認"]
["予定月","品名","金額","予定月","品名","金額",null,"予定月","金額","備考","予定月","金額","備考"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["合　　計",null,{"$f":"SUM(C7:C41)","v":0},"合　　計",null,{"$f":"SUM(F7:F41)","v":0},null,"合　計",{"$f":"SUM(I7:I41)","v":0},null,"合　計",{"$f":"SUM(L7:L41)","v":0}]