{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Dashboard","Members","Seats","Books","Settings","Book_Register","Books_inventory","Receipt","Calc","Members_db"],"not_rendered":{"images":30,"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":9,"n_cols":22,"rows_kept":9,"merged":[[4,8,7,9],[4,14,7,15],[4,20,7,21]]}
[]
[{"$nulls":6},"Dashboard"]
[]
[]
[{"$nulls":8},{"$f":"Calc!M3","v":8},{"$nulls":5},{"$f":"Calc!M4","v":7},{"$nulls":5},{"$f":"Calc!M5","v":1}]
[]
[]
[]
[{"$nulls":9},"Total Members",{"$nulls":5},"Active Members",{"$nulls":5},"Expired Members"]

{"sheet":"Members","index":1,"n_rows":23,"n_cols":19,"rows_kept":23}
["C-Panel"]
["Sel Rw:",15,{"$nulls":4},"Members"]
["Sel Seat:","D2"]
["Seat Db Rw:",{"$f":"IFERROR(MATCH(Members!B3,tblMembers[Seat'#],0)+3,\"\")","v":""}]
["Scrl Ctrl:",1,{"$nulls":5},"Members List"]
["Edit Mode:",false]
["Full Name:",{"$f":"IFERROR(VLOOKUP(B3,tblMembers[],2,FALSE),\"\")","v":""}]
["Fname:",{"$f":"IFERROR(TRIM(LEFT(B7,FIND(\" \",B7,1))),\"\")","v":""},{"$nulls":5},"Seat #","Name","Date of Birth","Gender","Address","Phone","Subscription","Amount","Issue Date","Expiry Date","Status","Action"]
["Lname:",{"$f":"TRIM(RIGHT(B7,LEN(B7)-LEN(B8)))","v":""},{"$nulls":3},{"$f":"B5","v":1},null,{"$f":"IFERROR(INDEX(tblMembers[],F9,1),\"\")","v":"A1"},{"$f":"IFERROR(INDEX(tblMembers[],F9,2),\"\")","v":"John Smith"},{"$f":"IFERROR(INDEX(tblMembers[],F9,3),\"\")","v":"2024-12-01"},{"$f":"IFERROR(INDEX(tblMembers[],F9,4),\"\")","v":"Male"},{"$f":"IFERROR(INDEX(tblMembers[],F9,7),\"\")","v":"49, new mal road, shimla - 234345"},{"$f":"IFERROR(INDEX(tblMembers[],F9,8),\"\")","v":9876543210},{"$f":"IFERROR(INDEX(tblMembers[],F9,9),\"\")","v":"1 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F9,10),\"\")","v":{"v":1000,"d":"₹ 1,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F9,11),\"\")","v":"2024-04-07"},{"$f":"IFERROR(INDEX(tblMembers[],F9,12),\"\")","v":"2024-05-05"},{"$f":"IFERROR(INDEX(tblMembers[],F9,13),\"\")","v":"Expired"}]
[{"$nulls":5},{"$f":"F9+1","v":2},null,{"$f":"IFERROR(INDEX(tblMembers[],F10,1),\"\")","v":"B9"},{"$f":"IFERROR(INDEX(tblMembers[],F10,2),\"\")","v":"Dhirendra Modi"},{"$f":"IFERROR(INDEX(tblMembers[],F10,3),\"\")","v":"2020-07-01"},{"$f":"IFERROR(INDEX(tblMembers[],F10,4),\"\")","v":"Male"},{"$f":"IFERROR(INDEX(tblMembers[],F10,7),\"\")","v":"12, Nale par mohalla, Sindhwa - 12345"},{"$f":"IFERROR(INDEX(tblMembers[],F10,8),\"\")","v":1234567890},{"$f":"IFERROR(INDEX(tblMembers[],F10,9),\"\")","v":"1 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F10,10),\"\")","v":{"v":1000,"d":"₹ 1,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F10,11),\"\")","v":"2024-05-06"},{"$f":"IFERROR(INDEX(tblMembers[],F10,12),\"\")","v":"2024-06-05"},{"$f":"IFERROR(INDEX(tblMembers[],F10,13),\"\")","v":"Active"}]
[{"$nulls":5},{"$f":"F10+1","v":3},null,{"$f":"IFERROR(INDEX(tblMembers[],F11,1),\"\")","v":"E8"},{"$f":"IFERROR(INDEX(tblMembers[],F11,2),\"\")","v":"Sila Sharma"},{"$f":"IFERROR(INDEX(tblMembers[],F11,3),\"\")","v":"2010-01-01"},{"$f":"IFERROR(INDEX(tblMembers[],F11,4),\"\")","v":"Female"},{"$f":"IFERROR(INDEX(tblMembers[],F11,7),\"\")","v":"45, Ramgarh, Up - 12345"},{"$f":"IFERROR(INDEX(tblMembers[],F11,8),\"\")","v":9876543210},{"$f":"IFERROR(INDEX(tblMembers[],F11,9),\"\")","v":"6 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F11,10),\"\")","v":{"v":1000,"d":"₹ 1,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F11,11),\"\")","v":"2024-05-05"},{"$f":"IFERROR(INDEX(tblMembers[],F11,12),\"\")","v":"2024-06-04"},{"$f":"IFERROR(INDEX(tblMembers[],F11,13),\"\")","v":"Active"}]
[{"$nulls":5},4,null,{"$f":"IFERROR(INDEX(tblMembers[],F12,1),\"\")","v":"C6"},{"$f":"IFERROR(INDEX(tblMembers[],F12,2),\"\")","v":"Pooja Khajuri"},{"$f":"IFERROR(INDEX(tblMembers[],F12,3),\"\")","v":"2023-06-08"},{"$f":"IFERROR(INDEX(tblMembers[],F12,4),\"\")","v":"Female"},{"$f":"IFERROR(INDEX(tblMembers[],F12,7),\"\")","v":"17, Ganesh Complex , Indoore, Mp-345465"},{"$f":"IFERROR(INDEX(tblMembers[],F12,8),\"\")","v":9876543210},{"$f":"IFERROR(INDEX(tblMembers[],F12,9),\"\")","v":"12 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F12,10),\"\")","v":{"v":1000,"d":"₹ 1,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F12,11),\"\")","v":"2024-05-06"},{"$f":"IFERROR(INDEX(tblMembers[],F12,12),\"\")","v":"2024-06-05"},{"$f":"IFERROR(INDEX(tblMembers[],F12,13),\"\")","v":"Active"}]
[{"$nulls":5},5,null,{"$f":"IFERROR(INDEX(tblMembers[],F13,1),\"\")","v":"F2"},{"$f":"IFERROR(INDEX(tblMembers[],F13,2),\"\")","v":"Ekesh Kharte"},{"$f":"IFERROR(INDEX(tblMembers[],F13,3),\"\")","v":"2012-04-05"},{"$f":"IFERROR(INDEX(tblMembers[],F13,4),\"\")","v":"Male"},{"$f":"IFERROR(INDEX(tblMembers[],F13,7),\"\")","v":"Zakarta, Indoneshiya"},{"$f":"IFERROR(INDEX(tblMembers[],F13,8),\"\")","v":1234567890},{"$f":"IFERROR(INDEX(tblMembers[],F13,9),\"\")","v":"6 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F13,10),\"\")","v":{"v":5000,"d":"₹ 5,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F13,11),\"\")","v":"2024-05-06"},{"$f":"IFERROR(INDEX(tblMembers[],F13,12),\"\")","v":"2024-11-02"},{"$f":"IFERROR(INDEX(tblMembers[],F13,13),\"\")","v":"Active"}]
[{"$nulls":5},6,null,{"$f":"IFERROR(INDEX(tblMembers[],F14,1),\"\")","v":"C7"},{"$f":"IFERROR(INDEX(tblMembers[],F14,2),\"\")","v":"Dipka Malhotra"},{"$f":"IFERROR(INDEX(tblMembers[],F14,3),\"\")","v":"1994-12-01"},{"$f":"IFERROR(INDEX(tblMembers[],F14,4),\"\")","v":"Male"},{"$f":"IFERROR(INDEX(tblMembers[],F14,7),\"\")","v":"Musakhedi, Indore - 451002"},{"$f":"IFERROR(INDEX(tblMembers[],F14,8),\"\")","v":1234567890},{"$f":"IFERROR(INDEX(tblMembers[],F14,9),\"\")","v":"6 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F14,10),\"\")","v":{"v":5000,"d":"₹ 5,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F14,11),\"\")","v":"2024-05-12"},{"$f":"IFERROR(INDEX(tblMembers[],F14,12),\"\")","v":"2024-11-08"},{"$f":"IFERROR(INDEX(tblMembers[],F14,13),\"\")","v":"Active"}]
[{"$nulls":5},7,null,{"$f":"IFERROR(INDEX(tblMembers[],F15,1),\"\")","v":"E10"},{"$f":"IFERROR(INDEX(tblMembers[],F15,2),\"\")","v":"Dinesh Ganjewala"},{"$f":"IFERROR(INDEX(tblMembers[],F15,3),\"\")","v":"2003-01-01"},{"$f":"IFERROR(INDEX(tblMembers[],F15,4),\"\")","v":"Male"},{"$f":"IFERROR(INDEX(tblMembers[],F15,7),\"\")","v":"Chamarkundiya, Khurmabad"},{"$f":"IFERROR(INDEX(tblMembers[],F15,8),\"\")","v":1234567890},{"$f":"IFERROR(INDEX(tblMembers[],F15,9),\"\")","v":"12 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F15,10),\"\")","v":{"v":10000,"d":"₹ 10,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F15,11),\"\")","v":"2024-05-12"},{"$f":"IFERROR(INDEX(tblMembers[],F15,12),\"\")","v":"2025-05-07"},{"$f":"IFERROR(INDEX(tblMembers[],F15,13),\"\")","v":"Active"}]
[{"$nulls":5},8,null,{"$f":"IFERROR(INDEX(tblMembers[],F16,1),\"\")","v":"C10"},{"$f":"IFERROR(INDEX(tblMembers[],F16,2),\"\")","v":"Radha Sharma"},{"$f":"IFERROR(INDEX(tblMembers[],F16,3),\"\")","v":"2006-01-12"},{"$f":"IFERROR(INDEX(tblMembers[],F16,4),\"\")","v":"Female"},{"$f":"IFERROR(INDEX(tblMembers[],F16,7),\"\")","v":"32, Mal Road, Shimla"},{"$f":"IFERROR(INDEX(tblMembers[],F16,8),\"\")","v":1234567890},{"$f":"IFERROR(INDEX(tblMembers[],F16,9),\"\")","v":"12 Month"},{"$f":"IFERROR(INDEX(tblMembers[],F16,10),\"\")","v":{"v":10000,"d":"₹ 10,000"}},{"$f":"IFERROR(INDEX(tblMembers[],F16,11),\"\")","v":"2024-05-15"},{"$f":"IFERROR(INDEX(tblMembers[],F16,12),\"\")","v":"2025-05-10"},{"$f":"IFERROR(INDEX(tblMembers[],F16,13),\"\")","v":"Active"}]
[{"$nulls":5},9,null,{"$f":"IFERROR(INDEX(tblMembers[],F17,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F17,13),\"\")","v":""}]
[{"$nulls":5},10,null,{"$f":"IFERROR(INDEX(tblMembers[],F18,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F18,13),\"\")","v":""}]
[{"$nulls":5},11,null,{"$f":"IFERROR(INDEX(tblMembers[],F19,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F19,13),\"\")","v":""}]
[{"$nulls":5},12,null,{"$f":"IFERROR(INDEX(tblMembers[],F20,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F20,13),\"\")","v":""}]
[{"$nulls":5},13,null,{"$f":"IFERROR(INDEX(tblMembers[],F21,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F21,13),\"\")","v":""}]
[{"$nulls":5},14,null,{"$f":"IFERROR(INDEX(tblMembers[],F22,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F22,13),\"\")","v":""}]
[{"$nulls":5},{"$f":"F22+1","v":15},null,{"$f":"IFERROR(INDEX(tblMembers[],F23,1),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,2),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,3),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,4),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,7),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,8),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,9),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,10),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,11),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,12),\"\")","v":""},{"$f":"IFERROR(INDEX(tblMembers[],F23,13),\"\")","v":""}]

{"sheet":"Seats","index":2,"n_rows":20,"n_cols":26,"rows_kept":20}
[]
[{"$nulls":6},"Seats Management"]
[]
[]
[]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H6,tblMembers[Seat'#],0)<>0,VLOOKUP(H6,tblMembers[],4,FALSE),\"\"),\"\")","v":"Male"},"A1",{"$f":"IFERROR(IF(MATCH(J6,tblMembers[Seat'#],0)<>0,VLOOKUP(J6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B1",{"$f":"IFERROR(IF(MATCH(L6,tblMembers[Seat'#],0)<>0,VLOOKUP(L6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C1",{"$f":"IFERROR(IF(MATCH(N6,tblMembers[Seat'#],0)<>0,VLOOKUP(N6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D1",{"$f":"IFERROR(IF(MATCH(P6,tblMembers[Seat'#],0)<>0,VLOOKUP(P6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E1",{"$f":"IFERROR(IF(MATCH(R6,tblMembers[Seat'#],0)<>0,VLOOKUP(R6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F1",{"$f":"IFERROR(IF(MATCH(T6,tblMembers[Seat'#],0)<>0,VLOOKUP(T6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G1",{"$f":"IFERROR(IF(MATCH(V6,tblMembers[Seat'#],0)<>0,VLOOKUP(V6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H1",{"$f":"IFERROR(IF(MATCH(X6,tblMembers[Seat'#],0)<>0,VLOOKUP(X6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I1",{"$f":"IFERROR(IF(MATCH(Z6,tblMembers[Seat'#],0)<>0,VLOOKUP(Z6,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J1"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H7,tblMembers[Seat'#],0)<>0,VLOOKUP(H7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A2",{"$f":"IFERROR(IF(MATCH(J7,tblMembers[Seat'#],0)<>0,VLOOKUP(J7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B2",{"$f":"IFERROR(IF(MATCH(L7,tblMembers[Seat'#],0)<>0,VLOOKUP(L7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C2",{"$f":"IFERROR(IF(MATCH(N7,tblMembers[Seat'#],0)<>0,VLOOKUP(N7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D2",{"$f":"IFERROR(IF(MATCH(P7,tblMembers[Seat'#],0)<>0,VLOOKUP(P7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E2",{"$f":"IFERROR(IF(MATCH(R7,tblMembers[Seat'#],0)<>0,VLOOKUP(R7,tblMembers[],4,FALSE),\"\"),\"\")","v":"Male"},"F2",{"$f":"IFERROR(IF(MATCH(T7,tblMembers[Seat'#],0)<>0,VLOOKUP(T7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G2",{"$f":"IFERROR(IF(MATCH(V7,tblMembers[Seat'#],0)<>0,VLOOKUP(V7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H2",{"$f":"IFERROR(IF(MATCH(X7,tblMembers[Seat'#],0)<>0,VLOOKUP(X7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I2",{"$f":"IFERROR(IF(MATCH(Z7,tblMembers[Seat'#],0)<>0,VLOOKUP(Z7,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J2"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H8,tblMembers[Seat'#],0)<>0,VLOOKUP(H8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A3",{"$f":"IFERROR(IF(MATCH(J8,tblMembers[Seat'#],0)<>0,VLOOKUP(J8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B3",{"$f":"IFERROR(IF(MATCH(L8,tblMembers[Seat'#],0)<>0,VLOOKUP(L8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C3",{"$f":"IFERROR(IF(MATCH(N8,tblMembers[Seat'#],0)<>0,VLOOKUP(N8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D3",{"$f":"IFERROR(IF(MATCH(P8,tblMembers[Seat'#],0)<>0,VLOOKUP(P8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E3",{"$f":"IFERROR(IF(MATCH(R8,tblMembers[Seat'#],0)<>0,VLOOKUP(R8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F3",{"$f":"IFERROR(IF(MATCH(T8,tblMembers[Seat'#],0)<>0,VLOOKUP(T8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G3",{"$f":"IFERROR(IF(MATCH(V8,tblMembers[Seat'#],0)<>0,VLOOKUP(V8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H3",{"$f":"IFERROR(IF(MATCH(X8,tblMembers[Seat'#],0)<>0,VLOOKUP(X8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I3",{"$f":"IFERROR(IF(MATCH(Z8,tblMembers[Seat'#],0)<>0,VLOOKUP(Z8,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J3"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H9,tblMembers[Seat'#],0)<>0,VLOOKUP(H9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A4",{"$f":"IFERROR(IF(MATCH(J9,tblMembers[Seat'#],0)<>0,VLOOKUP(J9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B4",{"$f":"IFERROR(IF(MATCH(L9,tblMembers[Seat'#],0)<>0,VLOOKUP(L9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C4",{"$f":"IFERROR(IF(MATCH(N9,tblMembers[Seat'#],0)<>0,VLOOKUP(N9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D4",{"$f":"IFERROR(IF(MATCH(P9,tblMembers[Seat'#],0)<>0,VLOOKUP(P9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E4",{"$f":"IFERROR(IF(MATCH(R9,tblMembers[Seat'#],0)<>0,VLOOKUP(R9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F4",{"$f":"IFERROR(IF(MATCH(T9,tblMembers[Seat'#],0)<>0,VLOOKUP(T9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G4",{"$f":"IFERROR(IF(MATCH(V9,tblMembers[Seat'#],0)<>0,VLOOKUP(V9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H4",{"$f":"IFERROR(IF(MATCH(X9,tblMembers[Seat'#],0)<>0,VLOOKUP(X9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I4",{"$f":"IFERROR(IF(MATCH(Z9,tblMembers[Seat'#],0)<>0,VLOOKUP(Z9,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J4"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H10,tblMembers[Seat'#],0)<>0,VLOOKUP(H10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A5",{"$f":"IFERROR(IF(MATCH(J10,tblMembers[Seat'#],0)<>0,VLOOKUP(J10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B5",{"$f":"IFERROR(IF(MATCH(L10,tblMembers[Seat'#],0)<>0,VLOOKUP(L10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C5",{"$f":"IFERROR(IF(MATCH(N10,tblMembers[Seat'#],0)<>0,VLOOKUP(N10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D5",{"$f":"IFERROR(IF(MATCH(P10,tblMembers[Seat'#],0)<>0,VLOOKUP(P10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E5",{"$f":"IFERROR(IF(MATCH(R10,tblMembers[Seat'#],0)<>0,VLOOKUP(R10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F5",{"$f":"IFERROR(IF(MATCH(T10,tblMembers[Seat'#],0)<>0,VLOOKUP(T10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G5",{"$f":"IFERROR(IF(MATCH(V10,tblMembers[Seat'#],0)<>0,VLOOKUP(V10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H5",{"$f":"IFERROR(IF(MATCH(X10,tblMembers[Seat'#],0)<>0,VLOOKUP(X10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I5",{"$f":"IFERROR(IF(MATCH(Z10,tblMembers[Seat'#],0)<>0,VLOOKUP(Z10,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J5"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H11,tblMembers[Seat'#],0)<>0,VLOOKUP(H11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A6",{"$f":"IFERROR(IF(MATCH(J11,tblMembers[Seat'#],0)<>0,VLOOKUP(J11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B6",{"$f":"IFERROR(IF(MATCH(L11,tblMembers[Seat'#],0)<>0,VLOOKUP(L11,tblMembers[],4,FALSE),\"\"),\"\")","v":"Female"},"C6",{"$f":"IFERROR(IF(MATCH(N11,tblMembers[Seat'#],0)<>0,VLOOKUP(N11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D6",{"$f":"IFERROR(IF(MATCH(P11,tblMembers[Seat'#],0)<>0,VLOOKUP(P11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E6",{"$f":"IFERROR(IF(MATCH(R11,tblMembers[Seat'#],0)<>0,VLOOKUP(R11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F6",{"$f":"IFERROR(IF(MATCH(T11,tblMembers[Seat'#],0)<>0,VLOOKUP(T11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G6",{"$f":"IFERROR(IF(MATCH(V11,tblMembers[Seat'#],0)<>0,VLOOKUP(V11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H6",{"$f":"IFERROR(IF(MATCH(X11,tblMembers[Seat'#],0)<>0,VLOOKUP(X11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I6",{"$f":"IFERROR(IF(MATCH(Z11,tblMembers[Seat'#],0)<>0,VLOOKUP(Z11,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J6"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H12,tblMembers[Seat'#],0)<>0,VLOOKUP(H12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A7",{"$f":"IFERROR(IF(MATCH(J12,tblMembers[Seat'#],0)<>0,VLOOKUP(J12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B7",{"$f":"IFERROR(IF(MATCH(L12,tblMembers[Seat'#],0)<>0,VLOOKUP(L12,tblMembers[],4,FALSE),\"\"),\"\")","v":"Male"},"C7",{"$f":"IFERROR(IF(MATCH(N12,tblMembers[Seat'#],0)<>0,VLOOKUP(N12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D7",{"$f":"IFERROR(IF(MATCH(P12,tblMembers[Seat'#],0)<>0,VLOOKUP(P12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E7",{"$f":"IFERROR(IF(MATCH(R12,tblMembers[Seat'#],0)<>0,VLOOKUP(R12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F7",{"$f":"IFERROR(IF(MATCH(T12,tblMembers[Seat'#],0)<>0,VLOOKUP(T12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G7",{"$f":"IFERROR(IF(MATCH(V12,tblMembers[Seat'#],0)<>0,VLOOKUP(V12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H7",{"$f":"IFERROR(IF(MATCH(X12,tblMembers[Seat'#],0)<>0,VLOOKUP(X12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I7",{"$f":"IFERROR(IF(MATCH(Z12,tblMembers[Seat'#],0)<>0,VLOOKUP(Z12,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J7"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H13,tblMembers[Seat'#],0)<>0,VLOOKUP(H13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A8",{"$f":"IFERROR(IF(MATCH(J13,tblMembers[Seat'#],0)<>0,VLOOKUP(J13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B8",{"$f":"IFERROR(IF(MATCH(L13,tblMembers[Seat'#],0)<>0,VLOOKUP(L13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C8",{"$f":"IFERROR(IF(MATCH(N13,tblMembers[Seat'#],0)<>0,VLOOKUP(N13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D8",{"$f":"IFERROR(IF(MATCH(P13,tblMembers[Seat'#],0)<>0,VLOOKUP(P13,tblMembers[],4,FALSE),\"\"),\"\")","v":"Female"},"E8",{"$f":"IFERROR(IF(MATCH(R13,tblMembers[Seat'#],0)<>0,VLOOKUP(R13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F8",{"$f":"IFERROR(IF(MATCH(T13,tblMembers[Seat'#],0)<>0,VLOOKUP(T13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G8",{"$f":"IFERROR(IF(MATCH(V13,tblMembers[Seat'#],0)<>0,VLOOKUP(V13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H8",{"$f":"IFERROR(IF(MATCH(X13,tblMembers[Seat'#],0)<>0,VLOOKUP(X13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I8",{"$f":"IFERROR(IF(MATCH(Z13,tblMembers[Seat'#],0)<>0,VLOOKUP(Z13,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J8"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H14,tblMembers[Seat'#],0)<>0,VLOOKUP(H14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A9",{"$f":"IFERROR(IF(MATCH(J14,tblMembers[Seat'#],0)<>0,VLOOKUP(J14,tblMembers[],4,FALSE),\"\"),\"\")","v":"Male"},"B9",{"$f":"IFERROR(IF(MATCH(L14,tblMembers[Seat'#],0)<>0,VLOOKUP(L14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C9",{"$f":"IFERROR(IF(MATCH(N14,tblMembers[Seat'#],0)<>0,VLOOKUP(N14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D9",{"$f":"IFERROR(IF(MATCH(P14,tblMembers[Seat'#],0)<>0,VLOOKUP(P14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E9",{"$f":"IFERROR(IF(MATCH(R14,tblMembers[Seat'#],0)<>0,VLOOKUP(R14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F9",{"$f":"IFERROR(IF(MATCH(T14,tblMembers[Seat'#],0)<>0,VLOOKUP(T14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G9",{"$f":"IFERROR(IF(MATCH(V14,tblMembers[Seat'#],0)<>0,VLOOKUP(V14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H9",{"$f":"IFERROR(IF(MATCH(X14,tblMembers[Seat'#],0)<>0,VLOOKUP(X14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I9",{"$f":"IFERROR(IF(MATCH(Z14,tblMembers[Seat'#],0)<>0,VLOOKUP(Z14,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J9"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H15,tblMembers[Seat'#],0)<>0,VLOOKUP(H15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A10",{"$f":"IFERROR(IF(MATCH(J15,tblMembers[Seat'#],0)<>0,VLOOKUP(J15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B10",{"$f":"IFERROR(IF(MATCH(L15,tblMembers[Seat'#],0)<>0,VLOOKUP(L15,tblMembers[],4,FALSE),\"\"),\"\")","v":"Female"},"C10",{"$f":"IFERROR(IF(MATCH(N15,tblMembers[Seat'#],0)<>0,VLOOKUP(N15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D10",{"$f":"IFERROR(IF(MATCH(P15,tblMembers[Seat'#],0)<>0,VLOOKUP(P15,tblMembers[],4,FALSE),\"\"),\"\")","v":"Male"},"E10",{"$f":"IFERROR(IF(MATCH(R15,tblMembers[Seat'#],0)<>0,VLOOKUP(R15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F10",{"$f":"IFERROR(IF(MATCH(T15,tblMembers[Seat'#],0)<>0,VLOOKUP(T15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G10",{"$f":"IFERROR(IF(MATCH(V15,tblMembers[Seat'#],0)<>0,VLOOKUP(V15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H10",{"$f":"IFERROR(IF(MATCH(X15,tblMembers[Seat'#],0)<>0,VLOOKUP(X15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I10",{"$f":"IFERROR(IF(MATCH(Z15,tblMembers[Seat'#],0)<>0,VLOOKUP(Z15,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J10"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H16,tblMembers[Seat'#],0)<>0,VLOOKUP(H16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A11",{"$f":"IFERROR(IF(MATCH(J16,tblMembers[Seat'#],0)<>0,VLOOKUP(J16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B11",{"$f":"IFERROR(IF(MATCH(L16,tblMembers[Seat'#],0)<>0,VLOOKUP(L16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C11",{"$f":"IFERROR(IF(MATCH(N16,tblMembers[Seat'#],0)<>0,VLOOKUP(N16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D11",{"$f":"IFERROR(IF(MATCH(P16,tblMembers[Seat'#],0)<>0,VLOOKUP(P16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E11",{"$f":"IFERROR(IF(MATCH(R16,tblMembers[Seat'#],0)<>0,VLOOKUP(R16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F11",{"$f":"IFERROR(IF(MATCH(T16,tblMembers[Seat'#],0)<>0,VLOOKUP(T16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G11",{"$f":"IFERROR(IF(MATCH(V16,tblMembers[Seat'#],0)<>0,VLOOKUP(V16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H11",{"$f":"IFERROR(IF(MATCH(X16,tblMembers[Seat'#],0)<>0,VLOOKUP(X16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I11",{"$f":"IFERROR(IF(MATCH(Z16,tblMembers[Seat'#],0)<>0,VLOOKUP(Z16,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J11"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H17,tblMembers[Seat'#],0)<>0,VLOOKUP(H17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A12",{"$f":"IFERROR(IF(MATCH(J17,tblMembers[Seat'#],0)<>0,VLOOKUP(J17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B12",{"$f":"IFERROR(IF(MATCH(L17,tblMembers[Seat'#],0)<>0,VLOOKUP(L17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C12",{"$f":"IFERROR(IF(MATCH(N17,tblMembers[Seat'#],0)<>0,VLOOKUP(N17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D12",{"$f":"IFERROR(IF(MATCH(P17,tblMembers[Seat'#],0)<>0,VLOOKUP(P17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E12",{"$f":"IFERROR(IF(MATCH(R17,tblMembers[Seat'#],0)<>0,VLOOKUP(R17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F12",{"$f":"IFERROR(IF(MATCH(T17,tblMembers[Seat'#],0)<>0,VLOOKUP(T17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G12",{"$f":"IFERROR(IF(MATCH(V17,tblMembers[Seat'#],0)<>0,VLOOKUP(V17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H12",{"$f":"IFERROR(IF(MATCH(X17,tblMembers[Seat'#],0)<>0,VLOOKUP(X17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I12",{"$f":"IFERROR(IF(MATCH(Z17,tblMembers[Seat'#],0)<>0,VLOOKUP(Z17,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J12"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H18,tblMembers[Seat'#],0)<>0,VLOOKUP(H18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A13",{"$f":"IFERROR(IF(MATCH(J18,tblMembers[Seat'#],0)<>0,VLOOKUP(J18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B13",{"$f":"IFERROR(IF(MATCH(L18,tblMembers[Seat'#],0)<>0,VLOOKUP(L18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C13",{"$f":"IFERROR(IF(MATCH(N18,tblMembers[Seat'#],0)<>0,VLOOKUP(N18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D13",{"$f":"IFERROR(IF(MATCH(P18,tblMembers[Seat'#],0)<>0,VLOOKUP(P18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E13",{"$f":"IFERROR(IF(MATCH(R18,tblMembers[Seat'#],0)<>0,VLOOKUP(R18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F13",{"$f":"IFERROR(IF(MATCH(T18,tblMembers[Seat'#],0)<>0,VLOOKUP(T18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G13",{"$f":"IFERROR(IF(MATCH(V18,tblMembers[Seat'#],0)<>0,VLOOKUP(V18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H13",{"$f":"IFERROR(IF(MATCH(X18,tblMembers[Seat'#],0)<>0,VLOOKUP(X18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I13",{"$f":"IFERROR(IF(MATCH(Z18,tblMembers[Seat'#],0)<>0,VLOOKUP(Z18,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J13"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H19,tblMembers[Seat'#],0)<>0,VLOOKUP(H19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A14",{"$f":"IFERROR(IF(MATCH(J19,tblMembers[Seat'#],0)<>0,VLOOKUP(J19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B14",{"$f":"IFERROR(IF(MATCH(L19,tblMembers[Seat'#],0)<>0,VLOOKUP(L19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C14",{"$f":"IFERROR(IF(MATCH(N19,tblMembers[Seat'#],0)<>0,VLOOKUP(N19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D14",{"$f":"IFERROR(IF(MATCH(P19,tblMembers[Seat'#],0)<>0,VLOOKUP(P19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E14",{"$f":"IFERROR(IF(MATCH(R19,tblMembers[Seat'#],0)<>0,VLOOKUP(R19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F14",{"$f":"IFERROR(IF(MATCH(T19,tblMembers[Seat'#],0)<>0,VLOOKUP(T19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G14",{"$f":"IFERROR(IF(MATCH(V19,tblMembers[Seat'#],0)<>0,VLOOKUP(V19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H14",{"$f":"IFERROR(IF(MATCH(X19,tblMembers[Seat'#],0)<>0,VLOOKUP(X19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I14",{"$f":"IFERROR(IF(MATCH(Z19,tblMembers[Seat'#],0)<>0,VLOOKUP(Z19,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J14"]
[{"$nulls":6},{"$f":"IFERROR(IF(MATCH(H20,tblMembers[Seat'#],0)<>0,VLOOKUP(H20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"A15",{"$f":"IFERROR(IF(MATCH(J20,tblMembers[Seat'#],0)<>0,VLOOKUP(J20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"B15",{"$f":"IFERROR(IF(MATCH(L20,tblMembers[Seat'#],0)<>0,VLOOKUP(L20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"C15",{"$f":"IFERROR(IF(MATCH(N20,tblMembers[Seat'#],0)<>0,VLOOKUP(N20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"D15",{"$f":"IFERROR(IF(MATCH(P20,tblMembers[Seat'#],0)<>0,VLOOKUP(P20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"E15",{"$f":"IFERROR(IF(MATCH(R20,tblMembers[Seat'#],0)<>0,VLOOKUP(R20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"F15",{"$f":"IFERROR(IF(MATCH(T20,tblMembers[Seat'#],0)<>0,VLOOKUP(T20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"G15",{"$f":"IFERROR(IF(MATCH(V20,tblMembers[Seat'#],0)<>0,VLOOKUP(V20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"H15",{"$f":"IFERROR(IF(MATCH(X20,tblMembers[Seat'#],0)<>0,VLOOKUP(X20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"I15",{"$f":"IFERROR(IF(MATCH(Z20,tblMembers[Seat'#],0)<>0,VLOOKUP(Z20,tblMembers[],4,FALSE),\"\"),\"\")","v":""},"J15"]

{"sheet":"Books","index":3,"n_rows":22,"n_cols":16,"rows_kept":22}
["C-Panel"]
["Sel Rw:",11,{"$nulls":4},"Books"]
["Sel Db Rw:",7]
["Scrl Ctrl:",1]
[]
[]
[{"$nulls":7},"Title","Author","Category","Issue Date","Member's Name","Seat #","Duration","Return Date","Status"]
[{"$nulls":5},{"$f":"B4","v":1},null,{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(A1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(A1))),\"\")","v":"Ace quant"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(B1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(B1))),\"\")","v":"Adda"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(C1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(C1))),\"\")","v":"Quant"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(D1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(D1))),\"\")","v":"2024-05-06"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(E1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(E1))),\"\")","v":"John Smith"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(F1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(F1))),\"\")","v":"A1"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(G1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(G1))),\"\")","v":4},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(H1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(H1))),\"\")","v":"2024-05-10"},{"$f":"IFERROR(IF(INDEX(tblBookReg,F8,COLUMN(I1))=0,\"\",INDEX(tblBookReg,F8,COLUMN(I1))),\"\")","v":"Returned"}]
[{"$nulls":5},{"$f":"F8+1","v":2},null,"English Speaking","M.S. Khurana","English","2024-05-07","Dhirendra Modi","B9",3,"2024-05-10","Issued"]
[{"$nulls":5},{"$f":"F9+1","v":3},null,"Reasoning Ability","Dr. Haldiram","Reasoning","2024-05-07","Pooja Khajuri","C6",2,"2024-05-09","Issued"]
[{"$nulls":5},4,null,"The Secret","Falana","Self Help","2024-05-15","Dinesh Ganjewala","E10",5,"2024-05-20","Returned"]
[{"$nulls":5},5,null,"","","","","","","","",""]
[{"$nulls":5},6,null,"","","","","","","","",""]
[{"$nulls":5},7,null,"","","","","","","","",""]
[{"$nulls":5},8,null,"","","","","","","","",""]
[{"$nulls":5},9,null,"","","","","","","","",""]
[{"$nulls":5},10,null,"","","","","","","","",""]
[{"$nulls":5},11,null,"","","","","","","","",""]
[{"$nulls":5},12,null,"","","","","","","","",""]
[{"$nulls":5},{"$f":"F19+1","v":13},null,"","","","","","","","",""]
[{"$nulls":5},14,null,"","","","","","","","",""]
[{"$nulls":5},{"$f":"F21+1","v":15},null,"","","","","","","","",""]

{"sheet":"Settings","index":4,"n_rows":27,"n_cols":13,"rows_kept":27,"merged":[[7,14,10,14]]}
[]
[{"$nulls":6},"Settings"]
[]
[]
[]
[{"$nulls":7},"Subscription Plan",{"$nulls":3},"General Settings"]
[]
[{"$nulls":7},"Plan Type","Duration (in Day)","Amount",null,"Library Name:","Private Library System"]
[{"$nulls":7},"1 Month",30,{"v":1000,"d":"₹ 1,000"},null,"Address:","123, ifill Tower, New City - 451666"]
[{"$nulls":7},"3 Month",90,{"v":2700,"d":"₹ 2,700"},null,"Phone:",1234567890]
[{"$nulls":7},"6 Month",180,{"v":5000,"d":"₹ 5,000"},null,"Email:","pls@email.com"]
[{"$nulls":7},"12 Month",360,{"v":10000,"d":"₹ 10,000"}]
[]
[]
[{"$nulls":7},"Books Category",{"$nulls":3},"Admin Panel Settings"]
[{"$nulls":7},"Self Help"]
[{"$nulls":7},"English",{"$nulls":3},"PIN:",1234]
[{"$nulls":7},"Quant",{"$nulls":3},"Enter PIN:",1234]
[{"$nulls":7},"Physics",{"$nulls":3},"Check:",{"$f":"IF(M17=M18,TRUE,FALSE)","v":true}]
[{"$nulls":7},"Chemistry"]
[{"$nulls":7},"Reasoning"]
[{"$nulls":7},"Story"]
[{"$nulls":7},"Novel"]
[{"$nulls":7},"Non-fiction"]
[{"$nulls":7},"Fiction"]
[{"$nulls":7},"Romantic Novel"]
[{"$nulls":7},"Comic"]

{"sheet":"Book_Register","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"hidden":true}
["Books Register"]
[]
["Title","Author","Category","Issue Date","Member's Name","Seat #","Duration","Return Date","Status"]
["Ace quant","Adda","Quant","2024-05-06","John Smith","A1",4,"2024-05-10","Returned"]
["English Speaking","M.S. Khurana","English","2024-05-07","Dhirendra Modi","B9",3,"2024-05-10","Issued"]
["Reasoning Ability","Dr. Haldiram","Reasoning","2024-05-07","Pooja Khajuri","C6",2,"2024-05-09","Issued"]
["The Secret","Falana","Self Help","2024-05-15","Dinesh Ganjewala","E10",5,"2024-05-20","Returned"]

{"sheet":"Books_inventory","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"hidden":true}
["Books Inventory"]
[]
["Title","Author","Category"]
["English Speaking","M.S. Khurana","English"]
["Ace quant","Adda","Quant"]
["Reasoning Ability","Dr. Haldiram","Reasoning"]
["The Secret","Falana","Self Help"]

{"sheet":"Receipt","index":7,"n_rows":22,"n_cols":6,"rows_kept":22,"hidden":true,"merged":[[1,5,1,6],[2,5,2,6],[13,5,13,6],[14,5,16,6]]}
[]
[null,null,{"$f":"compName","v":"Private Library System"},null,null,{"$f":"compPh","v":1234567890}]
[null,null,{"$f":"compAdd","v":"123, ifill Tower, New City - 451666"},null,null,{"$f":"compMail","v":"pls@email.com"}]
[]
[]
[null,"Member Name:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],2,FALSE),\"\")","v":"Radha Sharma"}]
[null,"Gender:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],4,FALSE),\"\")","v":"Female"}]
[null,"Father's Name:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],5,FALSE),\"\")","v":"Radheshyam Sharma"}]
[null,"Mother's Name:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],6,FALSE),\"\")","v":"Rukmi Sharma"}]
[null,"Address:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],7,FALSE),\"\")","v":"32, Mal Road, Shimla"}]
[null,"Phone:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],8,FALSE),\"\")","v":1234567890}]
[]
[]
[null,"Plan:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],9,FALSE)& \" \" & \"Subscription\",\"\")","v":"12 Month Subscription"},null,null,"Seat#"]
[null,"Issued:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],11,FALSE),\"\")","v":"2024-05-15"},null,null,"C10"]
[null,"Valid thru:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],12,FALSE),\"\")","v":"2025-05-10"}]
[null,"Amount:",{"$f":"IFERROR(VLOOKUP($F$15,tblMembers[],10,FALSE),\"\")","v":{"v":10000,"d":"₹ 10,000.00"}}]
[]
[]
[]
[]
[{"$nulls":5},"Authorized Signature"]

{"sheet":"Calc","index":8,"n_rows":33,"n_cols":16,"rows_kept":33,"hidden":true}
["Userform Controls",{"$nulls":10},"Dashboard Setup"]
[]
["Gender",null,"Duration",null,"Books Title:","The Secret",{"$nulls":5},"Total Members:",{"$f":"IFERROR(COUNTA(tblMembers[Seat'#]),\"\")","v":8},null,"Total Earning:",{"$f":"SUM(Members_db!J:J)","v":{"v":34000,"d":"₹ 34,000"}}]
["Male",null,1,null,"Author",{"$f":"IFERROR(VLOOKUP($F$3,Books_inventory!$A$4:$C$5000,2,FALSE),\"\")","v":"Falana"},{"$nulls":5},"Active Members:",{"$f":"COUNTIF(tblMembers[Status],\"Active\")","v":7}]
["Female",null,2,null,"Category",{"$f":"IFERROR(VLOOKUP($F$3,Books_inventory!$A$4:$C$5000,3,FALSE),\"\")","v":"Self Help"},{"$nulls":5},"Exipired Members:",{"$f":"COUNTIF(tblMembers[Status],\"Expired\")","v":1}]
[null,null,3]
[null,null,4,null,"Seat#","E10",{"$nulls":5},"Total Books:",{"$f":"COUNTA(Books_inventory!A4:A9999)","v":4}]
[null,null,5,null,"Member:",{"$f":"IFERROR(VLOOKUP(F7,tblMembers[],2,FALSE),\"\")","v":"Dinesh Ganjewala"},{"$nulls":5},"Issued:",{"$f":"COUNTIF(Book_Register!I4:'Book_Register'!I9999,\"Issued\")","v":2}]
[null,null,6,{"$nulls":8},"Delay:",{"$f":"COUNTIF(Book_Register!I4:'Book_Register'!I9999,\"Returned\")","v":2}]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]

{"sheet":"Members_db","index":9,"n_rows":11,"n_cols":39,"rows_kept":11,"hidden":true}
["Members Database",{"$nulls":25},"Seat#","Name","Dob","Gender","Father's Name","Mother's Name","Address","Phone","Subscription","Amount","Issue Date","Expiry Date","Status"]
[]
["Seat#","Name","Dob","Gender","Father's Name","Mother's Name","Address","Phone","Subscription","Amount","Issue Date","Expiry Date","Status",{"$nulls":13},"Seat#","Name","Dob","Gender","Father's Name","Mother's Name","Address","Phone","Subscription","Amount","Issue Date","Expiry Date","Status"]
["A1","John Smith","2024-12-01","Male","Johnathan Smith","Jerry Smith","49, new mal road, shimla - 234345",9876543210,"1 Month",{"v":1000,"d":"₹ 1,000"},"2024-04-07","2024-05-05","Expired"]
["B9","Dhirendra Modi","2020-07-01","Male","Shitendra Modi","Putali bai Modi","12, Nale par mohalla, Sindhwa - 12345",1234567890,"1 Month",{"v":1000,"d":"₹ 1,000"},"2024-05-06","2024-06-05","Active"]
["E8","Sila Sharma","2010-01-01","Female","Shelendra Sharma","Saraswati Sharma","45, Ramgarh, Up - 12345",9876543210,"6 Month",{"v":1000,"d":"₹ 1,000"},"2024-05-05","2024-06-04","Active"]
["C6","Pooja Khajuri","2023-06-08","Female","Mehul Khajuri","Neeta Khajuri","17, Ganesh Complex , Indoore, Mp-345465",9876543210,"12 Month",{"v":1000,"d":"₹ 1,000"},"2024-05-06","2024-06-05","Active"]
["F2","Ekesh Kharte","2012-04-05","Male","Gyarsilal kharte","Megna bai kharte","Zakarta, Indoneshiya",1234567890,"6 Month",{"v":5000,"d":"₹ 5,000"},"2024-05-06","2024-11-02","Active"]
["C7","Dipka Malhotra","1994-12-01","Male","Hukmaram Malhotra","Geeta Bai","Musakhedi, Indore - 451002",1234567890,"6 Month",{"v":5000,"d":"₹ 5,000"},"2024-05-12","2024-11-08","Active"]
["E10","Dinesh Ganjewala","2003-01-01","Male","Jagdish","Gunja","Chamarkundiya, Khurmabad",1234567890,"12 Month",{"v":10000,"d":"₹ 10,000"},"2024-05-12","2025-05-07","Active"]
["C10","Radha Sharma","2006-01-12","Female","Radheshyam Sharma","Rukmi Sharma","32, Mal Road, Shimla",1234567890,"12 Month",{"v":10000,"d":"₹ 10,000"},"2024-05-15","2025-05-10","Active"]