{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Expenses","Calculation"],"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":"Expenses","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Name","Expenses","Amount","Date",null,"From","Amount","To"]
["Ted","Food",76.849999999999994,"2015-01-01",null,"Tom",84.18,"Fred"]
["Martin","Dinner",49.11,"2015-01-03",null,"Hank",20.92,"Fred"]
["Fred","Tickets",28.8,"2015-01-06",null,"Hank",26.87,"Ted"]
["Martin","Breakfast",11.45,"2015-01-09",null,"Hank",25.08,"Martin"]
["Martin","Bus",15,"2015-01-11"]
["Fred","Coffe",7,"2015-01-14"]
["Martin","Train",32.5,"2015-01-16"]
["Ted","Eiffel tower",45,"2015-01-22"]
["Martin","Bus",12,"2015-01-26"]
["Fred","Ice cream",15.775,"2015-01-27"]
["Fred","Restaurant",127.3,"2015-01-31"]
["Fred","Travel expenses",21.2,"2015-02-02"]
["Tom","Presents",10.8,{"$f":"D13+4","v":"2015-02-06"}]
["Hank","Sodas",22.1,{"$f":"D14+2","v":"2015-02-08"}]

{"sheet":"Calculation","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Name","Total",null,"Tom",0,null,{"$f":"SUM(B2:B34)","v":474.88500000000005},{"$f":"MAX(IF(A2:A38<>\"\",MATCH(ROW(A2:A38),ROW(A2:A38)),\"\"))","v":5}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A1,Table1[Name]),0)),\"\")","v":"Ted"},{"$f":"IF(A2<>\"\",SUMIF(Table1[Name],A2,Table1[Amount]),\"\")","v":121.85},null,"Hank",4.2632564145606011E-14]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A2,Table1[Name]),0)),\"\")","v":"Martin"},{"$f":"IF(A3<>\"\",SUMIF(Table1[Name],A3,Table1[Amount]),\"\")","v":120.06},null,"Martin",0]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A3,Table1[Name]),0)),\"\")","v":"Fred"},{"$f":"IF(A4<>\"\",SUMIF(Table1[Name],A4,Table1[Amount]),\"\")","v":200.07499999999999},null,"Ted",0]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A4,Table1[Name]),0)),\"\")","v":"Tom"},{"$f":"IF(A5<>\"\",SUMIF(Table1[Name],A5,Table1[Amount]),\"\")","v":10.8},null,"Fred",0]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A5,Table1[Name]),0)),\"\")","v":"Hank"},{"$f":"IF(A6<>\"\",SUMIF(Table1[Name],A6,Table1[Amount]),\"\")","v":22.1}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A6,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A7<>\"\",SUMIF(Table1[Name],A7,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A7,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A8<>\"\",SUMIF(Table1[Name],A8,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A8,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A9<>\"\",SUMIF(Table1[Name],A9,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A9,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A10<>\"\",SUMIF(Table1[Name],A10,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A10,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A11<>\"\",SUMIF(Table1[Name],A11,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A11,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A12<>\"\",SUMIF(Table1[Name],A12,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A12,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A13<>\"\",SUMIF(Table1[Name],A13,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A13,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A14<>\"\",SUMIF(Table1[Name],A14,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A14,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A15<>\"\",SUMIF(Table1[Name],A15,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A15,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A16<>\"\",SUMIF(Table1[Name],A16,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A16,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A17<>\"\",SUMIF(Table1[Name],A17,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A17,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A18<>\"\",SUMIF(Table1[Name],A18,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A18,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A19<>\"\",SUMIF(Table1[Name],A19,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A19,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A20<>\"\",SUMIF(Table1[Name],A20,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A20,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A21<>\"\",SUMIF(Table1[Name],A21,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A21,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A22<>\"\",SUMIF(Table1[Name],A22,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A22,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A23<>\"\",SUMIF(Table1[Name],A23,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A23,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A24<>\"\",SUMIF(Table1[Name],A24,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A24,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A25<>\"\",SUMIF(Table1[Name],A25,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A25,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A26<>\"\",SUMIF(Table1[Name],A26,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A26,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A27<>\"\",SUMIF(Table1[Name],A27,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A27,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A28<>\"\",SUMIF(Table1[Name],A28,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A28,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A29<>\"\",SUMIF(Table1[Name],A29,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A29,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A30<>\"\",SUMIF(Table1[Name],A30,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A30,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A31<>\"\",SUMIF(Table1[Name],A31,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A31,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A32<>\"\",SUMIF(Table1[Name],A32,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A32,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A33<>\"\",SUMIF(Table1[Name],A33,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A33,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A34<>\"\",SUMIF(Table1[Name],A34,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A34,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A35<>\"\",SUMIF(Table1[Name],A35,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A35,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A36<>\"\",SUMIF(Table1[Name],A36,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A36,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A37<>\"\",SUMIF(Table1[Name],A37,Table1[Amount]),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Table1[Name],MATCH(0,COUNTIF($A$1:A37,Table1[Name]),0)),\"\")","v":""},{"$f":"IF(A38<>\"\",SUMIF(Table1[Name],A38,Table1[Amount]),\"\")","v":""}]