{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sales Tracker","Pending Sales Tracker","NameList","Performance","Partner Contact Info","Students Turned Away"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":"Sales Tracker","index":0,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[45,10,46,10]]}
["SALES REP","FIRST NAME","LAST NAME","PHONE","CHECK-IN EMAIL","SECONDARY EMAIL","PRODUCT NAME","PURCHASE PRICE","CC","ACH/CHECK","PAYMENT DETAILS","ZIP AMOUNT","TOTAL COLLECTED AT EVENT","REMAINING BALANCE","SWAP","INSTALLMENT LOANS","CREDIT STACKING","IHF COLLECTED","IHF FINANCED","TUITION NOTES AND  BALANCE DETAILS","HIGH HEAD COUNT","DPH","DPHC","Momentum Class 1","Momentum Class 2"]
["*** PLEASE DO NOT EDIT THIS ROW. IF NEW COLUMNS ARE NEEDED, ADD THEM AFTER THE LAST COLUMN. THX. ***",null,null,null,null,null,null,{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0},null,{"$f":"L47","v":0},{"$f":"SUM(I2+L2)","v":0},{"$f":"N47","v":0},0,0,0,0,0,null,null,{"$f":"IFERROR((H2/U2),\"\")","v":""},{"$f":"IFERROR((M2/U2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+L3","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", K3)), ISNUMBER(SEARCH(\"ZIP\", K3))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", K3)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", K3)), H3-I3, \"\"), H3-M3)),\"\")","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"SWAP\",K3)),N3,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K3)),(I3+L3),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K3)),H3-I3-J3-L3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4+L4","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", K4)), ISNUMBER(SEARCH(\"ZIP\", K4))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", K4)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", K4)), H4-I4, \"\"), H4-M4)),\"\")","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"SWAP\",K4)),N4,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K4)),(I4+L4),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K4)),H4-I4-J4-L4,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,"TOTAL SOLD","CC","ACH/CHECK",null,"ZIP","TOTAL COLLECTED","TOTAL REMANING","TOTAL SWAPS","INSTALLMENT LOANS","CREDIT STALKING","IHF COLLECTED ","IHF FINANCED"]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H45)","v":0},{"$f":"SUM(I3:I45)","v":0},{"$f":"SUM(J3:J45)","v":0},null,{"$f":"SUM(L3:L45)","v":0},0,0,{"$f":"SUM(O3:O45)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,"HIGH HEAD COUNT","DPH","DPHC","COLLECTION RATIO"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((H47/H49),\"\")","v":""},{"$f":"IFERROR((M47/H49),\"\")","v":""},{"$f":"IFERROR((M2/H2), \"\")","v":""}]
[]
[]
[null,null,null,"Please DO NOT TYPE OVER COLUMNS L,M,P, AND Q (FORMULAS)"]
[]
[null,null,null,"Please refer to this list below for Sales Reps (copy and paste as value) in the Sales Rep column (Column A). Please make sure to just include one first and last name per row. Thank you."]

{"sheet":"Pending Sales Tracker","index":1,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[45,10,46,10]]}
["SALES REP","FIRST NAME","LAST NAME","PHONE","CHECK-IN EMAIL","SECONDARY EMAIL","PRODUCT NAME","PURCHASE PRICE","CC","ACH/CHECK","PAYMENT DETAILS","ZIP AMOUNT","TOTAL COLLECTED AT EVENT","REMAINING BALANCE","SWAP","INSTALLMENT LOANS","CREDIT STACKING","IHF COLLECTED","IHF FINANCED","TUITION NOTES AND  BALANCE DETAILS","HIGH HEAD COUNT","DPH","DPHC","Momentum Class ","Momentum Class"]
["*** PLEASE DO NOT EDIT THIS ROW. IF NEW COLUMNS ARE NEEDED, ADD THEM AFTER THE LAST COLUMN. THX. ***",null,null,null,null,null,null,{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0},null,{"$f":"L47","v":0},{"$f":"SUM(I2+L2)","v":0},{"$f":"N47","v":0},0,0,0,0,0,null,null,{"$f":"IFERROR((H2/U2),\"\")","v":""},{"$f":"IFERROR((M2/U2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+L3","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", K3)), ISNUMBER(SEARCH(\"ZIP\", K3))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", K3)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", K3)), H3-I3, \"\"), H3-M3)),\"\")","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"SWAP\",K3)),N3,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K3)),(I3+L3),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K3)),H3-I3-J3-L3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4+L4","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", K4)), ISNUMBER(SEARCH(\"ZIP\", K4))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", K4)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", K4)), H4-I4, \"\"), H4-M4)),\"\")","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"SWAP\",K4)),N4,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K4)),(I4+L4),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",K4)),H4-I4-J4-L4,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"",""]
[null,null,null,null,null,null,null,"TOTAL SOLD","CC","ACH/CHECK",null,"ZIP","TOTAL COLLECTED","TOTAL REMANING","TOTAL SWAPS","INSTALLMENT LOANS","CREDIT STALKING","IHF COLLECTED ","IHF FINANCED"]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H45)","v":0},{"$f":"SUM(I3:I45)","v":0},{"$f":"SUM(J3:J45)","v":0},null,{"$f":"SUM(L3:L45)","v":0},0,0,{"$f":"SUM(O3:O45)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,"HIGH HEAD COUNT","DPH","DPHC","COLLECTION RATIO"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((H47/H49),\"\")","v":""},{"$f":"IFERROR((M47/H49),\"\")","v":""},{"$f":"IFERROR((M2/H2), \"\")","v":""}]
[]
[]
[null,null,null,"Please DO NOT TYPE OVER COLUMNS L,M,P, AND Q (FORMULAS)"]
[]
[null,null,null,"Please refer to this list below for Sales Reps (copy and paste as value) in the Sales Rep column (Column A). Please make sure to just include one first and last name per row. Thank you."]

{"sheet":"NameList","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["ZIP"]
["CHECK"]
["ACH"]
["CC"]
["SWAP"]
["IHF"]
["CASH"]

{"sheet":"Performance","index":3,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Coach","APPOINTMENTS","ENROLLMENTS","CLOSE RATIO","PURCHASE PRICE","$ PER APPT (DPA)","TOTAL COLLECTED AT EVENT ","$ PER APPT COLLECTED (DPAC)"]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A2)","v":0},{"$f":"IFERROR(C2/B2,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A2,'Sales Tracker'!$H:$H)","v":0},{"$f":"IFERROR(E2/B2,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A2,'Sales Tracker'!$M:$M)","v":0},{"$f":"IFERROR(G2/B2,\" \")","v":" "}]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A3)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A3,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A3,'Sales Tracker'!$M:$M)","v":0},{"$f":"IFERROR(G3/B3,\" \")","v":" "}]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A4)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A4,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A4,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A5)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A5,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A5,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A6)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A6,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A6,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A7)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A7,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A7,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A8)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A8,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A8,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A9)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A9,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A9,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A10)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A10,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A10,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A11)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A11,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A11,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A12)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A12,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A12,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A13)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A13,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A13,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A14)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A14,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A14,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A15)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A15,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A15,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A16)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A16,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A16,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A17)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A17,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A17,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A18)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A18,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A18,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A19)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A19,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A19,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A20)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A20,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A20,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A21)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A21,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A21,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A22)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A22,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A22,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A23)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A23,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A23,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A24)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A24,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A24,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A25)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A25,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A25,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A26)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A26,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A26,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A27)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A27,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A27,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A28)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A28,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A28,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A29)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A29,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A29,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A30)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A30,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A30,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A31)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A31,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A31,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A32)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A32,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A32,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A33)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A33,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A33,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A34)","v":0},{"$f":"IFERROR(C34/B34,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A34,'Sales Tracker'!$H:$H)","v":0},{"$f":"IFERROR(E34/B34,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A34,'Sales Tracker'!$M:$M)","v":0},{"$f":"IFERROR(G34/B34,\" \")","v":" "}]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A35)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A35,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A35,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A36)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A36,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A36,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A37)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A37,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A37,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A38)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A38,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A38,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A39)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A39,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A39,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A40)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A40,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A40,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A41)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A41,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A41,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A42)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A42,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A42,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A43)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A43,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A43,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A44)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A44,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A44,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A45)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A45,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A45,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A46)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A46,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A46,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A47)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A47,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A47,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A48)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A48,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A48,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A49)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A49,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A49,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A50)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A50,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A50,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A51)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A51,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A51,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A52)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A52,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A52,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A53)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A53,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A53,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A54)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A54,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A54,'Sales Tracker'!$M:$M)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A55)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A55,'Sales Tracker'!$H:$H)","v":0}," ",{"$f":"SUMIF('Sales Tracker'!$A:$A,A55,'Sales Tracker'!$M:$M)","v":0}," "]

{"sheet":"Partner Contact Info","index":4,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Partner First Name","Partner Last Name","Partner Email","Phone Number","Linked to Buyer","Misc. Details"]

{"sheet":"Students Turned Away","index":5,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","Phone","Notes"]