{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sales Tracker","Pending Sales Tracker","Performance","Salespeople","Appointment Tracker","HHC & Lead Break down","Partner Contact Info","Students Turned Away"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":2,"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":68,"n_cols":28,"rows_kept":68,"cut":false,"hidden":false,"merged":[[60,11,61,11],[1,26,1,27]]}
["SALES REP","FIRST NAME","LAST NAME","PHONE","CHECK-IN EMAIL","SECONDARY EMAIL","PRODUCT NAME","PURCHASE PRICE","CC","ACH/CHECK","POST-DATED ACH/CHECK","PAYMENT DETAILS","ZIP AMOUNT","TOTAL COLLECTED AT EVENT","REMAINING BALANCE","INSTALLMENT LOANS","0% LINE OF CREDIT","REIMBURSEMENT EXPECTED ","IHF COLLECTED","IHF FINANCED","TUITION NOTES AND  BALANCE DETAILS","HIGH HEAD COUNT","DPH","DPHC","Momentum Class 1","Momentum Class 2","SPEAKER 1","SPEAKER 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":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":0},{"$f":"K62","v":0},null,{"$f":"M62","v":0},{"$f":"SUM(I2+M2+J2)","v":0},{"$f":"O62","v":0},0,0,{"$f":"R62","v":0},0,0,null,{"$f":"H64","v":0},{"$f":"IFERROR((H2/V2),\"\")","v":""},{"$f":"IFERROR((N2/V2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+M3+J3","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", L3)), ISNUMBER(SEARCH(\"ZIP\", L3))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", L3)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", L3)), H3-I3, \"\"), H3-N3)),\"\")","v":0},null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L3)),(I3+M3+J3),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L3)),H3-I3-J3-M3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4+M4+J4","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", L4)), ISNUMBER(SEARCH(\"ZIP\", L4))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", L4)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", L4)), H4-I4, \"\"), H4-N4)),\"\")","v":0},null,null,null,"",{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L4)),H4-I4-J4-M4,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"",{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L5)),#REF!-I5-J5-M5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"",{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L6)),H5-I6-J6-M6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"",{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L7)),H7-I7-J7-M7,\"\")","v":""}]
[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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,{"$error":"#VALUE!"},"",null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L35)),(I35+M35+J35),\"\")","v":""},""]
[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," ",null,0,0,null,null,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,null,null,0,0,null,null,null,"",{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L39)),H39-I39-J39-M39,\"\")","v":""}]
[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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,null,null,0,0,null,null,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,"TOTAL SOLD","CC","ACH/CHECK","POST-DATED ACH/CHECK",null,"ZIP","TOTAL COLLECTED","TOTAL REMANING","INSTALLMENT LOANS","0% LINE OF CREDIT","REFUNDS","IHF COLLECTED ","IHF FINANCED"]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H60)","v":0},{"$f":"SUM(I3:I60)","v":0},{"$f":"SUM(J3:J60)","v":0},{"$f":"SUM(K3:K60)","v":0},null,{"$f":"SUM(M3:M60)","v":0},{"$error":"#VALUE!"},0,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((H62/H64),\"\")","v":""},{"$f":"IFERROR((N62/H64),\"\")","v":""},{"$f":"IFERROR((N2/H2), \"\")","v":""}]
[]
[null,null,null,"Please Record any swaps in the \"Pending Sales Tracker\" tab and not in the sales tracker tab ( Please type \"SWAP\" in \"Payment details Column for the swapped $ to reflect in the SWAPS column)."]
[null,null,null,"Please DO NOT TYPE OVER COLUMNS A, N, O, P, S AND T (FORMULAS)/ G, AND H (DATA VALIDATION LIST)"]
[null,null,null,"Please ensure that the exact number of APPOINTMENTS for each sales representative/team leader is added to the performance tab. This is of utmost importance for accurate tracking and evaluation"]

{"sheet":"Pending Sales Tracker","index":1,"n_rows":56,"n_cols":29,"rows_kept":56,"cut":false,"hidden":false,"merged":[[48,11,49,11],[1,27,1,28]]}
["SALES REP","FIRST NAME","LAST NAME","PHONE","CHECK-IN EMAIL","SECONDARY EMAIL","PRODUCT NAME","PURCHASE PRICE","CC","ACH/CHECK","POST-DATED ACH/CHECK","PAYMENT DETAILS","ZIP AMOUNT","TOTAL COLLECTED AT EVENT","REMAINING BALANCE","SWAP","INSTALLMENT LOANS","0% LINE OF CREDIT","REIMBURSEMENT EXPECTED ","IHF COLLECTED","IHF FINANCED","TUITION NOTES AND  BALANCE DETAILS","HIGH HEAD COUNT","DPH","DPHC","Momentum Class 1","Momentum Class 2","SPEAKER 1","SPEAKER 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":"H50","v":0},{"$f":"I50","v":0},{"$f":"J50","v":0},{"$f":"K50","v":0},null,{"$f":"M50","v":0},{"$f":"SUM(I2+M2+J2)","v":0},{"$f":"O50","v":0},0,0,0,0,0,0,null,{"$f":"H52","v":0},{"$f":"IFERROR((H2/W2),\"\")","v":""},{"$f":"IFERROR((N2/W2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+M3+J3","v":0},{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", L3)), ISNUMBER(SEARCH(\"ZIP\", L3))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", L3)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", L3)), H3-I3, \"\"), H3-N3)),\"\")","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"SWAP\",L3)),O3,\"\")","v":""},null,null,{"$f":"R3","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L3)),(I3+M3+J3),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L3)),H3-I3-J3-M3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(IF(AND(ISNUMBER(SEARCH(\"IHF\", L4)), ISNUMBER(SEARCH(\"ZIP\", L4))), \"\", IF(ISNUMBER(SEARCH(\"IHF\", L4)), IF(ISNUMBER(SEARCH(\"Owed ZIP\", L4)), H4-I4, \"\"), H4-N4)),\"\")","v":0},"",null,null,{"$f":"R4","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L4)),(I4+M4+J4),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L12)),(I12+M12+J12),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"IHF\",L12)),H12-I12-J12-M12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,0,"",""]
[null,null,null,null,null,null,null,"TOTAL SOLD","CC","ACH/CHECK","POST-DATED ACH/CHECK",null,"ZIP","TOTAL COLLECTED","TOTAL REMANING","TOTAL SWAPS","INSTALLMENT LOANS","0% LINE OF CREDIT","REFUNDS","IHF COLLECTED ","IHF FINANCED"]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H48)","v":0},{"$f":"SUM(I3:I48)","v":0},{"$f":"SUM(J3:J48)","v":0},{"$f":"SUM(K3:K48)","v":0},null,{"$f":"SUM(M3:M48)","v":0},0,0,0,0,0,{"$f":"SUM(S3:S48)","v":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((H50/H52),\"\")","v":""},{"$f":"IFERROR((N50/H52),\"\")","v":""},{"$f":"IFERROR((N2/H2), \"\")","v":""}]
[]
[null,null,null,"Please Record any swaps in the \"Pending Sales Tracker\" tab and not in the sales tracker tab ( Please type \"SWAP\" in \"Payment details Column for the swapped $ to reflect in the SWAPS column)."]
[null,null,null,"Please DO NOT TYPE OVER COLUMNS A, N, O, P, S AND T (FORMULAS)/ G, AND H (DATA VALIDATION LIST)"]
[null,null,null,"Please ensure that the exact number of APPOINTMENTS for each sales representative/team leader is added to the performance tab. This is of utmost importance for accurate tracking and evaluation"]

{"sheet":"Performance","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["SALES REP","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'!$N:$N)","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'!$N:$N)","v":0}," "]
[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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","v":0}," "]
[null,null,{"$f":"COUNTIF('Sales Tracker'!A:A,A13)","v":0},{"$f":"IFERROR(C13/B13,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A13,'Sales Tracker'!$H:$H)","v":0},{"$f":"IFERROR(E13/B13,\" \")","v":" "},{"$f":"SUMIF('Sales Tracker'!$A:$A,A13,'Sales Tracker'!$N:$N)","v":0},{"$f":"IFERROR(G13/B13,\" \")","v":" "}]
[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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","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'!$N:$N)","v":0}," "]

{"sheet":"Salespeople","index":3,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Josiah Marcell "]
["Cristie  McLoud"]
["Josh Bishop"]
["Diana Blood"]
["Lisa Cortez"]
["Felix  Garcia"]
["Nancy   Smith"]
["Gretchen Marcey"]
["Emily  Muiruri"]
["Steve  Andrus"]
["Josh  Berry"]
["Paul Jaqua"]
["Jordy Davidson"]
["Jared Russell"]
["David Verbruggen"]
["Jennifer  Jones"]
["Silvia  Cooke"]
["Tyler Marcell "]
["Guillermo Bogan"]
["Chris Quairate"]
["Brandon  Diaz"]
["Tyler Marcell "]
["Asaph Ward"]
["Jordan Davidson"]
["Paul Jaqua"]
["Josh Berry"]
["Maria  Collins"]
["Paul Jaqua"]
["Felix Garcia"]
["Jordy Davidson"]
["Brandon  Diaz"]
["Angela Wilson"]
["Ryan Horn"]
["Austin Blanchfill"]
["John Dessauer"]
["Jay Evans"]
["Valerie Cummins"]
["Damien  Vanderburg"]
["Bailey Benham"]
["Nicholas Copenbarger"]
["Angela Gruenberg"]
["Speros Vouriotis"]
["Niko Lopez"]
["Gretchen Marcey"]
["Erin  Vanderburg"]
["Boyce  McLoud"]
["Blair Nightingale"]

{"sheet":"Appointment Tracker","index":4,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Coach","First Name","Last Name","Class","Couple "]

{"sheet":"HHC & Lead Break down","index":5,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["HHC Day 1"]
[]
["HHC Day 2"]
[]
["HHC Day 3"]
[]
[]
["A="]
["B=."]
["C="]
["D="]
[]
["Total Apps="]
["Total sales="]
["DNS. "]
["BU. "]

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

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