{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DATA","SUMMARY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"DATA","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3],[0,0,0,5],[2,5,4,6],[4,2,4,3]]}
["PROJECT TRACKER"]
[null,null,null,null,null,"Details"]
[null,"Project"]
[null,"Start"]
[null,"End"]
[]
[]
["DAY","WEEK \nENDING","START \nTIME","END \nTIME","HOURS \nSPENT","PROJECT","DETAILS"]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},"13:00:00","14:00:00",{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":1.0000000000000018},"Company A","Starting on project."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.706736111111,44936.713460648149,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.16138888889690861},"Company B","Answered customer question."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.713831018518,44936.722997685189,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.22000000008847564},"Company C","Call with customer going over project details."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.723321759258,44936.727592592593,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.1025000000372529},"Company D","Customer had a quick question about an invoice."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.728101851855,44936.739895833336,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.28305555554106832},"Company E","Began testing file."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.740057870367,44936.750625000001,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.25361111119855195},"Company F","Conference call with customer and their staff."]
["2023-01-10",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44936.799143518518,44936.815034722225,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.38138888898538426},"Company G","Fixed an issue relating to a calculation problem they identified."]
["2023-01-11",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44937.658599537041,44937.663599537038,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.11999999993713573},"Company H","Troubleshooted a problem with the file."]
["2023-01-11",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44937.845451388886,44937.861689814818,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.38972222234588116},"Company A","Began working on consolidating worksheets."]
["2023-01-12",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44938.801203703704,44938.828240740739,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.64888888882705942},"Company B","Worked on mapping items."]
["2023-01-12",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44938.84946759259,44938.869421296295,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.47888888890156522},"Company C","Worked on changes per customer's latest email."]
["2023-01-12",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-01-13"},44938.875335648147,44938.906875000001,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":0.75694444449618459},"Company D","Reconciler Testing"]
["2023-02-07",{"$f":"tblProjects[[#This Row],[DAY]]+(7-WEEKDAY(tblProjects[[#This Row],[DAY]],16))","v":"2023-02-10"},44964.448599537034,44964.448912037034,{"$f":"(tblProjects[[#This Row],[END \nTIME]]-tblProjects[[#This Row],[START \nTIME]])*24","v":7.5000000069849193E-3},"Company A","Began testing the template."]

{"sheet":"SUMMARY","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["WEEK \nENDING","PROJECT","Sum of HOURS ",null,null,null,"Project List"]
["2023-01-13","Company A",1.3897222223458829,null,null,null,"Company A"]
[null,"Company B",0.81027777772396803,null,null,null,"Company B"]
[null,"Company C",0.69888888899004087,null,null,null,"Company C"]
[null,"Company D",0.85944444453343749,null,null,null,"Company D"]
[null,"Company E",0.28305555554106832,null,null,null,"Company E"]
[null,"Company F",0.25361111119855195,null,null,null,"Company F"]
[null,"Company G",0.38138888898538426,null,null,null,"Company G"]
[null,"Company H",0.11999999993713573,null,null,null,"Company H"]
["1/13/2023 Total",null,4.7963888892554696]
["2023-02-10","Company A",7.5000000069849193E-3]
["2/10/2023 Total",null,7.5000000069849193E-3]
["Grand Total",null,4.8038888892624545]