{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["森山","井上","杉島","合計","7月第1週"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"森山","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,5,3],[3,0,3,1],[2,0,2,1],[3,2,3,4],[2,2,2,4]]}
["アルバイト勤務表"]
[]
["フリガナ",null,{"$f":"PHONETIC(C4)","v":"モリヤマヨシアキ"}]
["氏名",null,"森山義明"]
[]
["日","出勤・退勤",null,null,"勤務（時）","日給",null,"時給",900]
[1,"08:00:00",null,"10:00:00",2.0000000000000009,1800.0000000000009,null,"勤務日数",4]
[2,"09:00:00",null,"11:00:00",1.9999999999999996,1799.9999999999995]
[3,"09:00:00",null,"11:00:00",1.9999999999999996,1799.9999999999995]
[4,"09:00:00",null,"11:00:00",1.9999999999999996,1799.9999999999995]
[5,"08:00:00",null,"10:00:00",2.0000000000000009,1800.0000000000009]
[6,null,null,null,0,0]
[7,null,"～",null,0,0]
[null,null,null,null,"支給計",7200]

{"sheet":"井上","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[5,1,5,3]]}
["アルバイト勤務表"]
[]
["フリガナ",null,{"$f":"PHONETIC(C4)","v":"イノウエタカシ"}]
["氏名",null,"井上隆"]
[]
["日","出勤・退勤",null,null,"勤務（時）","日給",null,"時給",1000]
[1,null,null,null,0,0,null,"勤務日数",4]
[2,"19:00:00","～","22:00:00",3,3000]
[3,null,"～",null,0,0]
[4,"19:00:00","～","23:00:00",4.0000000000000018,4000.0000000000018]
[5,"19:00:00","～","23:00:00",4.0000000000000018,4000.0000000000018]
[6,null,"～",null,0,0]
[7,"19:00:00",null,"22:00:00",3,3000]
[null,null,null,null,"支給計",14000]

{"sheet":"杉島","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[5,1,5,3]]}
["アルバイト勤務表"]
[]
["フリガナ",null,{"$f":"PHONETIC(C4)","v":"スギシマナオコ"}]
["氏名",null,"杉島直子"]
[]
["日","出勤・退勤",null,null,"勤務（時）","日給",null,"時給",850]
[1,"09:00:00","～","12:00:00",3,2550,null,"勤務日数",3]
[2,"09:00:00","～","12:00:00",3,2550]
[3,"09:00:00","～","12:00:00",3,2550]
[4,null,"～",null,0,0]
[5,null,"～",null,0,0]
[6,"09:00:00","～","12:00:00",3,2550]
[7,null,"～",null,0,0]
[null,null,null,null,"支給計",7650]

{"sheet":"合計","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["アルバイト勤務（7月第1週）"]
[]
["日","勤務人数","支給額計"]
[1,2,4350]
[2,3,7350]
[3,2,4350]
[4,2,5800]
[5,2,5800]
[6,1,2550]
[7,1,3000]
[]
["合　計",13,33200]

{"sheet":"7月第1週","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["アルバイト勤務（7月第1週）",null,null,"VBAではなくExcel関数を使用して合計を出す方法"]
[]
["日","勤務人数","支給額計"]
[1,{"$f":"COUNT(森山:杉島!B7)","v":2},{"$f":"SUM(森山:杉島!F7)","v":4350.0000000000009}]
[2,{"$f":"COUNT(森山:杉島!B8)","v":3},{"$f":"SUM(森山:杉島!F8)","v":7350}]
[3,{"$f":"COUNT(森山:杉島!B9)","v":2},{"$f":"SUM(森山:杉島!F9)","v":4350}]
[4,{"$f":"COUNT(森山:杉島!B10)","v":2},{"$f":"SUM(森山:杉島!F10)","v":5800.0000000000018}]
[5,{"$f":"COUNT(森山:杉島!B11)","v":2},{"$f":"SUM(森山:杉島!F11)","v":5800.0000000000027}]
[6,{"$f":"COUNT(森山:杉島!B12)","v":1},{"$f":"SUM(森山:杉島!F12)","v":2550}]
[7,{"$f":"COUNT(森山:杉島!B13)","v":1},{"$f":"SUM(森山:杉島!F13)","v":3000}]
[]
["合　計",{"$f":"SUM(B4:B10)","v":13},{"$f":"SUM(C4:C10)","v":33200}]