{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Setup","Expenses","Settlements","BESetup"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":2,"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":"Setup","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[15,2,15,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"#","Participant Name"]
[null,1,"Dave"]
[null,2,"Bill"]
[null,3,"Jim"]
[null,4,"Emma"]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Expenses","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Description","Paid By","Amount","Split Between","Include?","#of People","Amount per Person"]
["2026-01-04","Dinner","Dave",120,"Dave, Jim","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":2},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":60}]
["2026-02-04","Taxi","Bill",45,"Jim, Emma","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":2},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":22.5}]
["2026-03-04","Groceries","Jim",500,"Bill, Dave, Emma","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":3},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":166.66666666666666}]
["2026-04-04","Coffee","Dave",18,"Dave, Bill, Jim, Emma","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":4},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":4.5}]
["2026-05-04","Hotel","Dave",300,"Dave, Bill, Jim","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":3},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":100}]
["2026-06-06","Movie","Bill",125,"Dave, Bill, Jim, Emma","Yes",{"$f":"LEN(Table2[[#This Row],[Split Between]])-LEN(SUBSTITUTE(Table2[[#This Row],[Split Between]],\",\",\"\"))+1","v":4},{"$f":"Table2[[#This Row],[Amount]]/Table2[[#This Row],['#of People]]","v":31.25}]

{"sheet":"Settlements","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"From",null,"To",null,"Amount"]
[null,"Emma",null,"Jim",null,224.92]
[null,"Hidden",null,"Upgrade to View"]
[null,"Hidden",null,"Upgrade to View"]

{"sheet":"BESetup","index":3,"n_rows":130,"n_cols":26,"rows_kept":130,"cut":false,"hidden":true,"merged":[]}
["List for Expenses",null,"File Type - Paid for no breaks",null,"Currency",null,"Calculation","Amount Paid","Amount Participated","Delta",null,"Value","Label","Label",null,null,null,"Settlements Text",null,null,null,null,null,"Names",null,"Bill"]
["All",null,"Free",null,"USD",null,{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(Setup!C16:C25,Setup!C16:C25<>\"\"))","v":"Bill"},{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G2)","v":170},{"$f":"IF(G2>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G2&\"*\"),0)","v":302.41666666666663},{"$f":"H2-I2","v":-132.41666666666663},null,{"$f":"SUM(H:H)","v":1108},"Total Expenses",{"$f":"M2&\" - \"&TEXT(L2,\"$#,##\")","v":"Total Expenses - $1,108"},null,null,null,"Showing 1 of 3 settlement transactions"]
[{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(Setup!C16:C25,Setup!C16:C25<>\"\"))","v":"Bill"},null,null,null,"GBP",null,"Dave",{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G3)","v":438},{"$f":"IF(G3>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G3&\"*\"),0)","v":362.41666666666663},{"$f":"H3-I3","v":75.583333333333371},null,{"$f":"COUNTA(G:G)-1","v":4},"Participants",{"$f":"M3&\" - \"&L3","v":"Participants - 4"},null,null,null,"2 additional transactions hidden"]
["Dave",null,null,null,"EU",null,"Emma",{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G4)","v":0},{"$f":"IF(G4>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G4&\"*\"),0)","v":224.91666666666666},-224.91666666666666,null,{"$f":"COUNTA(Table2[Amount])","v":6},"Expenses Logged",{"$f":"M4&\" - \"&L4","v":"Expenses Logged - 6"},null,null,null,"Transactions required : 3"]
["Emma",null,null,null,null,null,"Jim",{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G5)","v":500},{"$f":"IF(G5>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G5&\"*\"),0)","v":218.25},281.75,null,{"$f":"ROUND(L2/L4,2)","v":184.67},"Average Expense",{"$f":"M5&\" - \"&TEXT(L5,\"$#,##\")","v":"Average Expense - $185"}]
["Jim",null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G6)","v":0},{"$f":"IF(G6>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G6&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G7)","v":0},{"$f":"IF(G7>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G7&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G8)","v":0},{"$f":"IF(G8>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G8&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G9)","v":0},{"$f":"IF(G9>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G9&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G10)","v":0},{"$f":"IF(G10>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G10&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G11)","v":0},{"$f":"IF(G11>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G11&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G12)","v":0},{"$f":"IF(G12>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G12&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G13)","v":0},{"$f":"IF(G13>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G13&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G14)","v":0},{"$f":"IF(G14>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G14&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G15)","v":0},{"$f":"IF(G15>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G15&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G16)","v":0},{"$f":"IF(G16>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G16&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G17)","v":0},{"$f":"IF(G17>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G17&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G18)","v":0},{"$f":"IF(G18>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G18&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G19)","v":0},{"$f":"IF(G19>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G19&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G20)","v":0},{"$f":"IF(G20>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G20&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G21)","v":0},{"$f":"IF(G21>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G21&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G22)","v":0},{"$f":"IF(G22>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G22&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G23)","v":0},{"$f":"IF(G23>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G23&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G24)","v":0},{"$f":"IF(G24>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G24&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G25)","v":0},{"$f":"IF(G25>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G25&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G26)","v":0},{"$f":"IF(G26>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G26&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G27)","v":0},{"$f":"IF(G27>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G27&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G28)","v":0},{"$f":"IF(G28>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G28&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G29)","v":0},{"$f":"IF(G29>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G29&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G30)","v":0},{"$f":"IF(G30>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G30&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G31)","v":0},{"$f":"IF(G31>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G31&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G32)","v":0},{"$f":"IF(G32>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G32&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G33)","v":0},{"$f":"IF(G33>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G33&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G34)","v":0},{"$f":"IF(G34>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G34&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G35)","v":0},{"$f":"IF(G35>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G35&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G36)","v":0},{"$f":"IF(G36>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G36&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G37)","v":0},{"$f":"IF(G37>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G37&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G38)","v":0},{"$f":"IF(G38>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G38&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G39)","v":0},{"$f":"IF(G39>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G39&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G40)","v":0},{"$f":"IF(G40>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G40&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G41)","v":0},{"$f":"IF(G41>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G41&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G42)","v":0},{"$f":"IF(G42>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G42&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G43)","v":0},{"$f":"IF(G43>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G43&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G44)","v":0},{"$f":"IF(G44>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G44&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G45)","v":0},{"$f":"IF(G45>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G45&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G46)","v":0},{"$f":"IF(G46>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G46&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G47)","v":0},{"$f":"IF(G47>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G47&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G48)","v":0},{"$f":"IF(G48>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G48&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G49)","v":0},{"$f":"IF(G49>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G49&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G50)","v":0},{"$f":"IF(G50>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G50&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G51)","v":0},{"$f":"IF(G51>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G51&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G52)","v":0},{"$f":"IF(G52>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G52&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G53)","v":0},{"$f":"IF(G53>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G53&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G54)","v":0},{"$f":"IF(G54>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G54&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G55)","v":0},{"$f":"IF(G55>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G55&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G56)","v":0},{"$f":"IF(G56>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G56&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G57)","v":0},{"$f":"IF(G57>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G57&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G58)","v":0},{"$f":"IF(G58>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G58&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G59)","v":0},{"$f":"IF(G59>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G59&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G60)","v":0},{"$f":"IF(G60>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G60&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G61)","v":0},{"$f":"IF(G61>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G61&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G62)","v":0},{"$f":"IF(G62>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G62&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G63)","v":0},{"$f":"IF(G63>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G63&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G64)","v":0},{"$f":"IF(G64>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G64&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G65)","v":0},{"$f":"IF(G65>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G65&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G66)","v":0},{"$f":"IF(G66>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G66&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G67)","v":0},{"$f":"IF(G67>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G67&\"*\"),0)","v":0},{"$f":"H67-I67","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G68)","v":0},{"$f":"IF(G68>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G68&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G69)","v":0},{"$f":"IF(G69>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G69&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G70)","v":0},{"$f":"IF(G70>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G70&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G71)","v":0},{"$f":"IF(G71>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G71&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G72)","v":0},{"$f":"IF(G72>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G72&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G73)","v":0},{"$f":"IF(G73>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G73&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G74)","v":0},{"$f":"IF(G74>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G74&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G75)","v":0},{"$f":"IF(G75>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G75&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G76)","v":0},{"$f":"IF(G76>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G76&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G77)","v":0},{"$f":"IF(G77>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G77&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G78)","v":0},{"$f":"IF(G78>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G78&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G79)","v":0},{"$f":"IF(G79>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G79&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G80)","v":0},{"$f":"IF(G80>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G80&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G81)","v":0},{"$f":"IF(G81>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G81&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G82)","v":0},{"$f":"IF(G82>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G82&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G83)","v":0},{"$f":"IF(G83>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G83&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G84)","v":0},{"$f":"IF(G84>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G84&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G85)","v":0},{"$f":"IF(G85>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G85&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G86)","v":0},{"$f":"IF(G86>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G86&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G87)","v":0},{"$f":"IF(G87>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G87&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G88)","v":0},{"$f":"IF(G88>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G88&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G89)","v":0},{"$f":"IF(G89>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G89&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G90)","v":0},{"$f":"IF(G90>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G90&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G91)","v":0},{"$f":"IF(G91>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G91&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G92)","v":0},{"$f":"IF(G92>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G92&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G93)","v":0},{"$f":"IF(G93>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G93&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G94)","v":0},{"$f":"IF(G94>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G94&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G95)","v":0},{"$f":"IF(G95>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G95&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G96)","v":0},{"$f":"IF(G96>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G96&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G97)","v":0},{"$f":"IF(G97>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G97&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G98)","v":0},{"$f":"IF(G98>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G98&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G99)","v":0},{"$f":"IF(G99>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G99&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G100)","v":0},{"$f":"IF(G100>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G100&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G101)","v":0},{"$f":"IF(G101>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G101&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G102)","v":0},{"$f":"IF(G102>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G102&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G103)","v":0},{"$f":"IF(G103>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G103&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G104)","v":0},{"$f":"IF(G104>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G104&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G105)","v":0},{"$f":"IF(G105>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G105&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G106)","v":0},{"$f":"IF(G106>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G106&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G107)","v":0},{"$f":"IF(G107>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G107&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G108)","v":0},{"$f":"IF(G108>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G108&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G109)","v":0},{"$f":"IF(G109>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G109&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G110)","v":0},{"$f":"IF(G110>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G110&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G111)","v":0},{"$f":"IF(G111>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G111&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G112)","v":0},{"$f":"IF(G112>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G112&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G113)","v":0},{"$f":"IF(G113>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G113&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G114)","v":0},{"$f":"IF(G114>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G114&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G115)","v":0},{"$f":"IF(G115>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G115&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G116)","v":0},{"$f":"IF(G116>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G116&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G117)","v":0},{"$f":"IF(G117>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G117&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G118)","v":0},{"$f":"IF(G118>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G118&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G119)","v":0},{"$f":"IF(G119>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G119&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G120)","v":0},{"$f":"IF(G120>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G120&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G121)","v":0},{"$f":"IF(G121>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G121&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G122)","v":0},{"$f":"IF(G122>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G122&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G123)","v":0},{"$f":"IF(G123>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G123&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G124)","v":0},{"$f":"IF(G124>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G124&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G125)","v":0},{"$f":"IF(G125>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G125&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G126)","v":0},{"$f":"IF(G126>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G126&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G127)","v":0},{"$f":"IF(G127>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G127&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G128)","v":0},{"$f":"IF(G128>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G128&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G129)","v":0},{"$f":"IF(G129>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G129&\"*\"),0)","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(Table2[Amount],Table2[Include?],\"Yes\",Table2[Paid By],$G130)","v":0},{"$f":"IF(G130>0,SUMIFS(Table2[Amount per Person],Table2[Include?],\"Yes\",Table2[Split Between],\"*\"&$G130&\"*\"),0)","v":0},0]