{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1-Input Data","2-New Assoc. Analysis","3-Assoc. Pay Chart","4-Sr Dr Pay Chart","5-Breakeven Chart","Calcs","Module1"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":285,"comments":3,"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":"1-Input Data","index":0,"n_rows":120,"n_cols":4,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"#1 - Dental Associate Analysis - Data Input"]
[]
[null,null,"Formal Practice Name","Rocky View Dental Care"]
[]
[null,null,"Senior Doctor(s) Name","John Righthinker, D.D.S."]
[]
[]
[null,null,"Potential Associate Name","Irving Wannabe, D.M.D."]
[]
[null,null,"Annual Total Practice Production ",1293504]
[]
[null,null,"Annual  Productions - All Doctors",801275]
[]
[null,null,"Collections Rate",0.96]
[]
[null,null,"Estimated Universal Variable Percent",0.09]
[]
[null,null,{"$f":"\"% of Univ. Variables Paid by \"&Doctor1","v":"% of Univ. Variables Paid by John Righthinker, D.D.S."},1]
[]
[null,null,"Annual Lab Fees - All Doctors",81890]
[]
[null,null,"Calculated Lab Fee Percent",{"$f":"LabFee","v":0.10219961935665034}]
[]
[null,null,{"$f":"\"% of Assoc. Lab Paid by \"&Doctor1","v":"% of Assoc. Lab Paid by John Righthinker, D.D.S."},0]
[]
[]
[null,null,"New Associate Data"]
[null,null,"New Associate Estimated Daily Production",2000]
[]
[null,null,"Estimated Normal Daily Hours Worked ",8]
[null,null,"Standard Treatment Hours per Day for This Practice",0]
[]
[null,null,{"$f":"AssocName&\"'s Estimated Days Worked Per Week\"","v":"Irving Wannabe, D.M.D.'s Estimated Days Worked Per Week"},4]
[]
[]
[null,null,"Associate Paid on  (1=Collections, 2=Production)",1]
[]
[null,null,"Associate Commission Percentage:",0.45]
[]
[null,null,"Associate Payroll Taxes and Benefits",0.1]
[]
[]
[null,null,"Practice Gross Production Value of a New Patient:",1200]
[]
[]
[]
[null,null,"Associate Minimum Annual Income Required",83400]
[]
[null,null,"Daily Associate Income Required",{"$f":"Calcs!Z351","v":400.34562211981569}]
[]
[null,null,"Addl. Front Desk Help"]
[]
[null,null,"  Number of Hours / Day                                                  ",8]
[]
[null,null,"  Amount Paid / Hour                                                       ",21]
[]
[null,null,"  Days / Week to Work                                                     ",4]
[null,null,"  Estimated Gross Monthly Pay",{"$f":"FrontDeskSal","v":2916.48}]
[null,null,{"$f":"\"  % to \"&Doctor1","v":"  % to John Righthinker, D.D.S."},1]
[]
[null,null,"Associate's Clinical Asst.:"]
[]
[null,null,"  Number of Hours / Day",8]
[]
[null,null,"  Amount Paid / Hour",18]
[]
[null,null,"  Days / Week to Work",4]
[]
[null,null,"  Number of Assistants Needed.",1]
[null,null,"  Estimated Gross Monthly Pay",{"$f":"AssisSal","v":2499.84}]
[null,null,{"$f":"\"  % to \"&Doctor1","v":"  % to John Righthinker, D.D.S."},0]
[]
[]
[null,null,"Annual Expenses:"]
[null,null,null,"Annually Only"]
[null,null,"Expense 1: Malpractice Insurance ",2500]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},0]
[]
[null,null,"Expense 2: Additional Operatory(ies)",6000]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},1]
[]
[null,null,"Expense 3: Marketing ",20000]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},1]
[]
[null,null,"Expense 4: CE Expense",5000]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},0.5]
[]
[null,null,"Expense 5: Equipment",0]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},0]
[]
[null,null,"Moving Expense",10000]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},0.4]
[]
[null,null,"Expense 7: Optional Expense B",0]
[]
[null,null,{"$f":"'2-New Assoc. Analysis'!$E$85","v":"% to John Righthinker, D.D.S."},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"2-New Assoc. Analysis","index":1,"n_rows":132,"n_cols":17,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"Formal_Practice_Name","v":"Rocky View Dental Care"}]
[]
[null,"#2 - New Associate Analysis - The Wealthy Dentist University ® ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-03-23T21:47:12.910"}]
[]
[]
[]
[null,"Assumptions:"]
[null,{"$f":"Potential_Associate_Name&\"'s Estimated Current Daily Production\"","v":"Irving Wannabe, D.M.D.'s Estimated Current Daily Production"},null,null,null,null,null,null,null,{"$f":"AssEstCurrProd","v":2000}]
[null,{"$f":"\"Estimated Normal Daily Hours Worked by \"&AssocName","v":"Estimated Normal Daily Hours Worked by Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,{"$f":"AssocHoursDay","v":8}]
[]
[null,"Standard Treatment Hours per Day for the Associate",null,null,null,null,null,null,null,{"$f":"StdTreatHours","v":0}]
[null,{"$f":"AssocName&\"'s Estimated Days Worked per Week\"","v":"Irving Wannabe, D.M.D.'s Estimated Days Worked per Week"},null,null,null,null,null,null,null,{"$f":"AssocDaysWorkedPerWk","v":4}]
[null,{"$f":"AssocName&\"'s Production per Standard Day\"","v":"Irving Wannabe, D.M.D.'s Production per Standard Day"},null,null,null,null,null,null,null,{"$f":"ProdperStandardDay","v":0}]
[null,"Practice Collections %:",null,null,null,null,null,null,null,{"$f":"CollectionsPercent","v":0.96}]
[null,"Estimated Universal Variable Percent",null,null,null,null,null,null,null,{"$f":"CalUnivVarPerCent","v":0.09}]
[null,"Annual Lab Fees - All Doctors",null,null,null,null,null,null,null,{"$f":"DrsLabFeePct","v":0.10219961935665034}]
[null,"Associate Commission %:",null,null,null,null,null,null,null,{"$f":"AssCommPct","v":0.45}]
[null,"Associate Commission Paid on:  (1=Collections, 2=Production)",null,null,null,null,null,null,null,{"$f":"AssocPaidOn","v":1}]
[]
[null,"Historical Production",null,null,null,null,null,null,null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[null,{"$f":"\"Production Required to Sustain \"&AssocName","v":"Production Required to Sustain Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,{"$f":"RequiredProd","v":34720}]
[null,"Value of a New Patient:",null,null,null,null,null,null,null,{"$f":"ValueNewPt","v":1200}]
[null,"Number of New Patients per Month Required to Sustain Associate ",null,null,null,null,null,null,null,{"$f":"NewPtsNeeded","v":28.933333333333334}]
[]
[null,{"$f":"\"Net Profit per Standard Day of Production by \"&AssocName","v":"Net Profit per Standard Day of Production by Irving Wannabe, D.M.D."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Profit to",null,"Take-Home For"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Doctor1","v":"John Righthinker, D.D.S."},null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[null,null,"Estimated Current Daily Production",null,null,null,null,null,null,{"$f":"AssEstCurrProd","v":2000}]
[null,null,null,null,null,null,null,null,"x",{"$f":"CollectionsPercent","v":0.96}]
[]
[null,null,"Current Collections per Standard Day",null,null,null,null,null,null,{"$f":"CurCollecPerStdDay","v":1920},null,null,null,{"$f":"GrossPay","v":1920}]
[]
[null,null,"Associate Commission Percentage:",null,null,null,null,{"$f":"AssocCoomRate","v":0.45}]
[null,null,null,"Paid on:",null,null,null,{"$f":"CollecProd","v":1},"1 = Collections               2 = Production"]
[null,null,null,{"$f":"\"Gross Commission for \"&AssocName","v":"Gross Commission for Irving Wannabe, D.M.D."},null,null,null,null,null,{"$f":"AssocGrossPay","v":864},null,null,null,{"$f":"-AssocGrossPay","v":-864},null,{"$f":"AssocGrossPay","v":864}]
[null,null,null,"Estimated Payroll Taxes & Benefits ",null,null,null,{"$f":"PayrollTaxAssoc","v":0.1},null,{"$f":"AssocPayrollTaxes","v":44.839738187041661},null,null,null,{"$f":"-AssocPayrollTaxes","v":-44.839738187041661}]
[]
[null,null,"Variable Expenses"]
[]
[null,null,null,"Universal Variable Expenses"]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"SrDocUnivExp","v":1},{"$f":"UnivDrPortion","v":0.09},{"$f":"-DrUniVar","v":180},null,null,null,{"$f":"DrUniVar","v":-180}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"AssocUnivExp","v":0},{"$f":"UnivAssocPortion","v":0},{"$f":"-AssUniVar","v":0},null,null,null,null,null,{"$f":"AssUniVar","v":0}]
[null,null,null,null,null,null,"         "]
[null,null,null,{"$f":"AssocName&\"'s Lab Fees\"","v":"Irving Wannabe, D.M.D.'s Lab Fees"}]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"SrDocLabExp","v":0},{"$f":"AsocLabFees","v":0},{"$f":"-DrLabFeesAssoc","v":0},null,null,null,{"$f":"DrLabFeesAssoc","v":0}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"AssocLabExp","v":1},{"$f":"AssocLabCosts","v":0.10219961935665034},{"$f":"-AssLabFee","v":204.39923871330069},null,null,null,null,null,{"$f":"AssLabFee","v":-204.39923871330069}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Formal_Practice_Name","v":"Rocky View Dental Care"}]
[null,{"$f":"\"Practice: \"&Doctor1","v":"Practice: John Righthinker, D.D.S."}]
[null,"New Associate Analysis - The Wealthy Dentist University ® ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-03-23T21:47:12.910"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Profit to",null,"Take-Home for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Doctor1","v":"John Righthinker, D.D.S."},null,{"$f":"Potential_Associate_Name","v":"Irving Wannabe, D.M.D."}]
[null,null,"Add'l. Team Cost:",null,null,null,null,null,null,"Monthly",null,"Daily"]
[]
[null,null,null,"Addl. Front Desk Help"]
[null,null,null,{"$f":"FrontDeskDetails","v":"Salary = 8 Hrs. * $21 /hr. * 4 days/wk.  "},null,null,null,null,null,{"$f":"FrontDeskSal","v":2916.48},null,{"$f":"FrontDeskSalDaily","v":168}]
[null,null,null,"  Estimated Payroll Taxes & Benefits",null,null,null,0.1,null,{"$f":"FrontDeskPayrollMo","v":249.98400000000004},null,{"$f":"FrontDeskPayrollDaily","v":16.8}]
[null,null,null,"  Total",null,null,null,null,null,{"$f":"FrontDeslTotMo","v":3166.4639999999999},null,{"$f":"AssocFrontDeskCost","v":184.8}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"PercentToSrDr","v":1},null,{"$f":"FrntDeskDrMo","v":3166.4639999999999},null,{"$f":"FrntDeskDrDaily","v":184.8},null,{"$f":"DrFrntDsk","v":-184.8}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"FrntDskPctToAssoc","v":0},null,{"$f":"FrntDeskAssocMo","v":0},null,{"$f":"FrntDeskAssocDaily","v":0},null,null,null,{"$f":"AssFrntDsk","v":0}]
[]
[null,null,null,"Associate's Clinical Asst.:"]
[null,null,null,{"$f":"\"Salary = \" &'1-Input Data'!D65&\" Hrs. * $\" &'1-Input Data'!D67&\" /hr. * \" &'1-Input Data'!D69&\" days/wk. * \" &'1-Input Data'!D71& \" assistant(s)\"","v":"Salary = 8 Hrs. * $18 /hr. * 4 days/wk. * 1 assistant(s)"},null,null,null,null,null,{"$f":"AssisSal","v":2499.84},null,{"$f":"J74/AssocStandardDaysperMo","v":144}]
[null,null,null," Estimated Payroll taxes & benefits",null,null,null,0.1,null,{"$f":"AssisPayrollMo","v":249.98400000000004},null,{"$f":"AssisPayrollDaily","v":14.4}]
[null,null,null,"  Total",null,null,null,null,null,{"$f":"AssisTotMo","v":2749.8240000000001},null,{"$f":"AssocAsstCost","v":158.4}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"AssisPctToDr","v":0},null,{"$f":"AssisDrMo","v":0},null,{"$f":"AssisDrDaily","v":0},null,{"$f":"DrClinAsst","v":0}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"AssisPctToAssoc","v":1},null,{"$f":"AssisAssocMo","v":2749.8240000000001},null,{"$f":"AssisAssocDaily","v":158.4},null,null,null,{"$f":"AssClinAsst","v":-158.4}]
[]
[null,null,"Annual Expenses"]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$78","v":"Expense 1: Malpractice Insurance "},null,null,null,null,null,{"$f":"MalPracMo","v":208.33333333333334},null,{"$f":"MalPracDaily","v":12.000768049155146}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"MalPracPctToDr","v":0},null,{"$f":"MalPracDrMo","v":0},null,{"$f":"MalPracDrDaily","v":0},null,{"$f":"DrExp1","v":0}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"MalPracPctToAssoc","v":1},null,{"$f":"MalPracAssocMo","v":208.33333333333334},null,{"$f":"AssocMedInsCost","v":12.000768049155146},null,null,null,{"$f":"AssExp1","v":-12.000768049155146}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$82","v":"Expense 2: Additional Operatory(ies)"},null,null,null,null,null,{"$f":"AddlOpMo","v":500},null,{"$f":"AddlOpDaily","v":28.801843317972352}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"AddlOpPctToDr","v":1},null,{"$f":"AddlOpDrMo","v":500},null,{"$f":"AddlOpDrDaily","v":28.801843317972352},null,{"$f":"DrExp2","v":-28.801843317972352}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"AddlOpPctToAssoc","v":0},null,{"$f":"AddlOpAssocMo","v":0},null,{"$f":"AddlOpAssocDaily","v":0},null,null,null,{"$f":"AssExp2","v":0}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$86","v":"Expense 3: Marketing "},null,null,null,null,null,{"$f":"MktgCostsMo","v":1666.6666666666667},null,{"$f":"MktgCostsDaily","v":96.006144393241172}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"MktgCostsPctToDr","v":1},null,{"$f":"MktgCostsDrMo","v":1666.6666666666667},null,{"$f":"MktgCostsDrDaily","v":96.006144393241172},null,{"$f":"DrExp3","v":-96.006144393241172}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"MktgCostsPctToAssoc","v":0},null,{"$f":"MktgCostsAssocMo","v":0},null,{"$f":"MktgCostsAssocDaily","v":0},null,null,null,{"$f":"AssExp3","v":0}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$90","v":"Expense 4: CE Expense"},null,null,null,null,null,{"$f":"CEMo","v":416.66666666666669},null,{"$f":"CEDaily","v":24.001536098310293}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"CEPctToDr","v":0.5},null,{"$f":"CEDrMo","v":208.33333333333334},null,{"$f":"CEDrDaily","v":12.000768049155146},null,{"$f":"DrExp4","v":-12.000768049155146}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"CEPctToAssoc","v":0.5},null,{"$f":"CEAssocMo","v":208.33333333333334},null,{"$f":"CEAssocDaily","v":12.000768049155146},null,null,null,{"$f":"AssExp4","v":-12.000768049155146}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$94","v":"Expense 5: Equipment"},null,null,null,null,null,{"$f":"EquipMo","v":0},null,{"$f":"EquipDaily","v":0}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"EquipPctToDr","v":0},null,{"$f":"EquipDrMo","v":0},null,{"$f":"EquipDrDaily","v":0},null,{"$f":"DrExp5","v":0}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"EquipPctToAssoc","v":1},null,{"$f":"EquipAssocMo","v":0},null,{"$f":"EquipAssocDaily","v":0},null,null,null,{"$f":"AssExp5","v":0}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$98","v":"Moving Expense"},null,null,null,null,null,{"$f":"Opt1Mo","v":833.33333333333337},null,{"$f":"Opt1Daily","v":48.003072196620586}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"Opt1PctToDr","v":0.4},null,{"$f":"Opt1DrMo","v":333.33333333333337},null,{"$f":"Opt1DrDaily","v":19.201228878648237},null,{"$f":"DrExp6","v":-19.201228878648237}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"Opt1PctToAssoc","v":0.6},null,{"$f":"Opt1AssocMo","v":500},null,{"$f":"Opt1AssocDaily","v":28.801843317972349},null,null,null,{"$f":"AssExp6","v":-28.801843317972349}]
[]
[null,null,null,{"$f":"'1-Input Data'!$C$102","v":"Expense 7: Optional Expense B"},null,null,null,null,null,{"$f":"Opt2Mo","v":0},null,{"$f":"EquipDaily","v":0}]
[]
[null,null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"Opt2PctToDr","v":0},null,{"$f":"Opt2DrMo","v":0},null,{"$f":"Opt2DrDaily","v":0},null,{"$f":"DrExp7","v":0}]
[null,null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"Opt2PctToAssoc","v":1},null,{"$f":"Opt2AssocMo","v":0},null,{"$f":"Opt2AssocDaily","v":0},null,null,null,{"$f":"AssExp7","v":0}]
[]
[]
[null,null,null,"Net Profit per Standard Day - before Overhead Allocation",null,null,null,null,null,null,null,null,null,{"$f":"DrNetIncome","v":490.35027717394132},null,{"$f":"AssPftDay","v":448.39738187041667}]
[]
[null,null,null,"Number of Standard Days per Month",null,null,null,null,null,null,null,null,"x",{"$f":"AssocStandardDaysperMo","v":17.36},"x",{"$f":"AssocStandardDaysperMo","v":17.36}]
[]
[null,null,null,"Net Profit per Month - before Overhead Allocation",null,null,null,null,null,null,null,null,null,{"$f":"DrPftMo","v":8512.4808117396205},null,{"$f":"DrPftDaily","v":7784.178549270433}]
[]
[null,null,null,"Contribution after direct expenses per Day",null,null,null,null,null,null,null,null,null,{"$f":"ContribDrDaily","v":490.35027717394132},null,{"$f":"ContribAssocDaily","v":448.39738187041667}]
[null,null,null,"Contribution after direct expenses per Month",null,null,null,null,null,null,null,null,null,{"$f":"ContribDrMo","v":8512.4808117396205},null,{"$f":"ContribAssocMo","v":7784.178549270433}]
[null,null,null,"Contribution after direct expenses per Year",null,null,null,null,null,null,null,null,null,{"$f":"ContribDrYear","v":102149.76974087545},null,{"$f":"ContribAssocYear","v":93410.142591245196}]
[null,null,null,"Overhead Contribution"]
[]
[]
[null,null,null,{"$f":"Potential_Associate_Name&\"'s minimum required gross annual income\"","v":"Irving Wannabe, D.M.D.'s minimum required gross annual income"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1-Input Data'!D49","v":83400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!L193","v":"Surplus"},{"$f":"P127-P131","v":10010.142591245196},{"$f":"Calcs!M193","v":10010.142591245196}]

{"sheet":"3-Assoc. Pay Chart","index":2,"n_rows":159,"n_cols":27,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"# 3 - Associate's Daily Net Take-Home Before Tax"]
[null,null,null,"Assumptions:"]
[null,null,null,"Assoc. Paid on:",null,{"$f":"IF(AssocPaidOn=1,\"Collections\",\"Production\")","v":"Collections"}]
[null,null,null,"No. of Days Worked:",null,{"$f":"AssocStandardDaysperMo","v":17.36},null,null,null,"Collections %",null,{"$f":"CollperCent","v":0.96},null,null,"Lab Fees  ",{"$f":"DrsLabFeePct","v":0.10219961935665034},null,"Team Cost",null,{"$f":"AssClinAsst_FrntDsk","v":-158.4},null,"Other Expenses",null,{"$f":"AssocAnnExp","v":-52.803379416282638}]
[]
[null,null,{"$f":"AssocRange","v":"Lab Fees"},102.19961935665035,112.41958129231537,122.63954322798041,132.85950516364545,143.07946709931048,153.2994290349755,163.51939097064053,173.73935290630558,183.95931484197061,194.17927677763564,204.39923871330069,214.61920064896572,224.83916258463074,235.05912452029577,245.27908645596082,255.49904839162585,265.7190103272909,275.93897226295593,286.15893419862095,296.37889613428598,306.59885806995101,null,"New Assoc.","Assoc."]
[null,null,"Universal Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Est. Prod.","Comm. %"]
[null,null,"Production Rate","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"New_Associate_Est._Prod.","v":2000},{"$f":"Associate_commission_percentage","v":0.45}]
[null,null,"Per Day",1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000]
[null,"Percent",0.25,-73.402998772932989,-59.622960708598022,-45.842922644263069,-32.062884579928095,-18.282846515593128,-4.5028084512581543,9.2772296130768197,23.057267677411765,36.837305741746754,50.617343806081699,64.397381870416666,78.17741993475164,91.957457999086614,105.73749606342159,119.51753412775651,133.29757219209154,147.07761025642645,160.85764832076143,174.6376863850964,188.41772444943138,202.19776251376635]
[null,{"$f":"IF(AssocPaidOn=1,\"of Coll.\",\"of Prod.\")","v":"of Coll."},0.26,-63.802998772932973,-49.062960708598013,-34.322922644263087,-19.582884579928084,-4.8428465155931306,9.8971915487418798,24.63722961307684,39.377267677411773,54.117305741746755,68.857343806081701,83.597381870416712,98.337419934751608,113.07745799908662,127.81749606342163,142.55753412775647,157.29757219209154,172.03761025642649,186.7776483207615,201.5176863850964,216.25772444943135,230.99776251376639]
[null,"Paid to",0.27,-54.202998772932943,-38.50296070859801,-22.802922644263056,-7.102884579928066,8.5971534844068671,24.297191548741864,39.997229613076861,55.697267677411851,71.397305741746834,87.09734380608171,102.79738187041676,118.49741993475169,134.19745799908662,149.89749606342167,165.59753412775655,181.29757219209154,196.99761025642653,212.69764832076143,228.39768638509636,244.09772444943135,259.79776251376637]
[null,"Assoc.",0.28000000000000003,-44.602998772932978,-27.942960708598012,-11.282922644263017,5.3771154200719522,22.037153484406922,38.697191548741905,55.357229613076875,72.01726767741178,88.677305741746807,105.33734380608172,121.99738187041669,138.65741993475166,155.31745799908663,171.9774960634216,188.63753412775662,205.29757219209168,221.95761025642656,238.61764832076145,255.27768638509647,271.93772444943141,288.59776251376644]
[null,null,0.29000000000000004,-35.002998772932955,-17.382960708598013,0.23707735573696453,17.85711542007197,35.477153484406934,53.097191548741883,70.717229613076881,88.33726767741183,105.95730574174678,123.57734380608173,141.19738187041673,158.81741993475174,176.43745799908663,194.05749606342164,211.67753412775662,229.29757219209162,246.91761025642657,264.53764832076143,282.1576863850965,299.77772444943145,317.39776251376639]
[null,null,0.30000000000000004,-25.402998772932936,-6.8229607085979538,11.757077355736946,30.337115420071939,48.917153484406931,67.49719154874191,86.077229613076895,104.65726767741188,123.23730574174687,141.81734380608174,160.39738187041678,178.97741993475171,197.55745799908675,216.13749606342168,234.71753412775652,253.29757219209162,271.87761025642652,290.45764832076151,309.03768638509649,327.61772444943148,346.19776251376646]
[null,null,0.31000000000000005,-15.802998772932972,3.7370392914020485,23.277077355736992,42.817115420071964,62.357153484406986,81.897191548741944,101.43722961307691,120.97726767741182,140.51730574174684,160.05734380608175,179.59738187041671,199.13741993475179,218.6774579990867,238.21749606342169,257.75753412775663,277.29757219209165,296.83761025642656,316.37764832076158,335.9176863850966,355.45772444943162,374.99776251376653]
[null,null,0.32000000000000006,-6.2029987729329505,14.297039291402051,34.797077355737031,55.297115420071982,75.797153484406977,96.297191548741921,116.79722961307692,137.29726767741187,157.79730574174692,178.29734380608176,198.79738187041676,219.29741993475176,239.79745799908667,260.29749606342176,280.79753412775671,301.29757219209165,321.79761025642659,342.29764832076165,362.7976863850966,383.29772444943154,403.79776251376649]
[null,null,0.33000000000000007,3.3970012270670722,24.85703929140206,46.31707735573702,67.777115420071993,89.237153484406974,110.69719154874196,132.15722961307694,153.61726767741192,175.0773057417469,196.53734380608176,217.99738187041675,239.45741993475181,260.91745799908671,282.37749606342169,303.83753412775667,325.29757219209176,346.75761025642663,368.2176483207615,389.67768638509659,411.13772444943169,432.59776251376655]
[null,null,0.34000000000000008,12.997001227067095,35.41703929140207,57.837077355737001,80.257115420072012,102.67715348440697,125.09719154874199,147.51722961307695,169.93726767741185,192.35730574174687,214.77734380608192,237.19738187041676,259.61741993475181,282.03745799908671,304.45749606342173,326.87753412775663,349.29757219209176,371.71761025642667,394.13764832076157,416.55768638509659,438.97772444943161,461.39776251376662]
[null,null,0.35000000000000009,22.597001227067118,45.977039291402043,69.357077355737033,92.73711542007203,116.11715348440697,139.49719154874197,162.87722961307696,186.2572676774119,209.63730574174699,233.01734380608187,256.39738187041684,279.77741993475178,303.15745799908672,326.53749606342177,349.91753412775671,373.29757219209176,396.6776102564267,420.05764832076164,443.43768638509658,466.81772444943152,490.19776251376669]
[null,null,0.3600000000000001,32.197001227067091,56.537039291402102,80.877077355737072,105.21711542007205,129.55715348440702,153.89719154874194,178.23722961307698,202.57726767741195,226.91730574174693,251.25734380608188,275.59738187041677,299.93741993475186,324.27745799908683,348.61749606342181,372.95753412775679,397.29757219209176,421.63761025642674,445.97764832076172,470.31768638509669,494.65772444943178,518.99776251376659]
[null,null,0.37000000000000011,41.797001227067121,67.097039291402155,92.397077355737053,117.69711542007201,142.99715348440702,168.29719154874203,193.59722961307699,218.89726767741189,244.19730574174687,269.49734380608191,294.79738187041681,320.09741993475183,345.39745799908695,370.69749606342185,395.99753412775675,421.29757219209176,446.59761025642666,471.89764832076185,497.1976863850968,522.49772444943187,547.79776251376677]
[null,null,0.38000000000000012,51.397001227067172,77.6570392914021,103.91707735573704,130.17711542007203,156.43715348440702,182.69719154874201,208.95722961307703,235.21726767741191,261.47730574174699,287.73734380608192,313.99738187041697,340.25741993475191,366.51745799908684,392.77749606342189,419.03753412775671,445.29757219209176,471.55761025642676,497.81764832076175,524.07768638509674,550.33772444943179,576.59776251376672]
[null,null,0.39000000000000012,60.997001227067081,88.217039291402159,115.43707735573707,142.65711542007205,169.87715348440707,197.09719154874199,224.31722961307702,251.53726767741196,278.75730574174696,305.97734380608193,333.19738187041679,360.41741993475188,387.63745799908696,414.85749606342182,442.07753412775679,469.29757219209188,496.51761025642685,523.73764832076176,550.95768638509685,578.17772444943193,605.39776251376668]
[null,null,0.40000000000000013,70.597001227067096,98.777039291402104,126.95707735573711,155.13711542007206,183.31715348440702,211.49719154874205,239.677229613077,267.85726767741193,296.03730574174705,324.21734380608194,352.39738187041684,380.57741993475196,408.75745799908685,436.93749606342186,465.11753412775687,493.29757219209199,521.47761025642683,549.65764832076184,577.83768638509673,606.01772444943185,634.19776251376686]
[null,null,0.41000000000000014,80.197001227067119,109.33703929140216,138.47707735573709,167.61711542007208,196.75715348440707,225.897191548742,255.03722961307702,284.17726767741198,313.31730574174702,342.45734380608195,371.59738187041688,400.73741993475193,429.87745799908697,459.0174960634219,488.15753412775695,517.29757219209193,546.43761025642686,575.57764832076168,604.71768638509684,633.857724449432,662.99776251376682]
[null,null,0.42000000000000015,89.797001227067142,119.89703929140211,149.99707735573708,180.0971154200721,210.19715348440715,240.29719154874195,270.39722961307706,300.49726767741203,330.59730574174699,360.69734380608196,390.79738187041693,420.89741993475189,450.99745799908686,481.097496063422,511.19753412775691,541.29757219209193,571.3976102564269,601.49764832076175,631.59768638509695,661.69772444943192,691.79776251376677]
[null,null,0.43000000000000016,99.397001227067165,130.45703929140217,161.51707735573711,192.57711542007212,223.63715348440707,254.69719154874204,285.75722961307707,316.81726767741196,347.87730574174708,378.93734380608197,409.99738187041697,441.05741993475198,472.11745799908704,503.1774960634221,534.23753412775693,565.29757219209205,596.35761025642694,627.41764832076183,658.47768638509683,689.53772444943183,720.59776251376695]
[null,null,0.44000000000000017,108.99700122706719,141.01703929140211,173.03707735573715,205.05711542007211,237.07715348440709,269.09719154874205,301.11722961307709,333.13726767741201,365.15730574174705,397.17734380608198,429.19738187041702,461.21741993475194,493.23745799908698,525.25749606342197,557.27753412775701,589.29757219209205,621.31761025642697,653.3376483207619,685.35768638509694,717.37772444943198,749.39776251376691]
[null,null,0.45000000000000018,118.59700122706721,151.57703929140217,184.55707735573714,217.5371154200721,250.51715348440703,283.49719154874202,316.4772296130771,349.45726767741206,382.43730574174714,415.41734380608199,448.39738187041706,481.37741993475208,514.35745799908705,547.33749606342201,580.31753412775697,613.29757219209205,646.27761025642701,679.25764832076197,712.23768638509682,745.2177244494319,778.19776251376686]
[null,null,0.46000000000000019,128.19700122706723,162.13703929140223,196.07707735573712,230.01711542007209,263.95715348440712,297.89719154874211,331.83722961307711,365.777267677412,399.71730574174711,433.657343806082,467.59738187041711,501.53741993475211,535.47745799908716,569.41749606342205,603.35753412775694,637.29757219209205,671.23761025642705,705.17764832076182,739.11768638509693,773.05772444943204,806.99776251376704]
[null,null,0.4700000000000002,137.79700122706714,172.69703929140218,207.59707735573724,242.49711542007211,277.39715348440717,312.29719154874209,347.19722961307713,382.09726767741205,416.99730574174708,451.89734380608201,486.79738187041704,521.69741993475213,556.59745799908706,591.49749606342209,626.39753412775713,661.29757219209205,696.19761025642708,731.09764832076189,765.99768638509704,800.89772444943196,835.79776251376688]
[null,null,0.4800000000000002,147.39700122706716,183.25703929140224,219.11707735573719,254.97711542007212,290.83715348440711,326.69719154874218,362.55722961307714,398.4172676774121,434.27730574174717,470.13734380608201,505.99738187041709,541.8574199347521,577.71745799908717,613.57749606342202,649.43753412775709,685.29757219209205,721.15761025642712,757.01764832076196,792.87768638509692,828.73772444943211,864.59776251376707]
[null,null,0.49000000000000021,156.99700122706719,193.8170392914023,230.63707735573715,267.45711542007206,304.27715348440717,341.09719154874227,377.91722961307715,414.73726767741204,451.55730574174714,488.37734380608225,525.19738187041708,562.01741993475207,598.83745799908729,635.65749606342217,672.47753412775705,709.29757219209205,746.11761025642693,782.93764832076204,819.75768638509703,856.57772444943203,893.39776251376725]
[null,null,0.50000000000000022,166.59700122706721,204.37703929140227,242.15707735573713,279.93711542007208,317.71715348440722,355.49719154874214,393.27722961307717,431.05726767741209,468.83730574174712,506.61734380608226,544.39738187041712,582.17741993475215,619.95745799908718,657.7374960634221,695.51753412775702,733.29757219209205,771.07761025642696,808.85764832076211,846.63768638509714,884.41772444943217,922.19776251376697]
[null,null,0.51000000000000023,176.19700122706723,214.93703929140233,253.67707735573711,292.41711542007209,331.15715348440716,369.89719154874223,408.63722961307718,447.37726767741214,486.11730574174732,524.85734380608221,563.59738187041717,602.33741993475223,641.0774579990873,679.81749606342225,718.55753412775698,757.29757219209205,796.037610256427,834.77764832076195,873.51768638509702,912.25772444943209,950.99776251376716]
[null,null,0.52000000000000024,185.79700122706726,225.49703929140225,265.19707735573724,304.89711542007211,344.59715348440722,384.29719154874209,423.9972296130772,463.69726767741219,503.39730574174729,543.09734380608222,582.79738187041721,622.49741993475209,662.19745799908719,701.89749606342218,741.59753412775717,781.29757219209228,820.99761025642692,860.69764832076203,900.39768638509713,940.09772444943223,979.79776251376677]
[null,null,0.53000000000000025,195.39700122706728,236.05703929140228,276.71707735573722,317.37711542007213,358.03715348440727,398.69719154874218,439.35722961307721,480.01726767741218,520.6773057417472,561.33734380608223,601.99738187041726,642.65741993475217,683.31745799908731,723.97749606342211,764.63753412775714,805.29757219209228,845.95761025642696,886.6176483207621,927.27768638509724,967.93772444943215,1008.597762513767]
[null,null,0.54000000000000026,204.99700122706722,246.61703929140222,288.2370773557372,329.85711542007215,371.47715348440721,413.09719154874227,454.71722961307722,496.33726767741229,537.95730574174729,579.57734380608224,621.19738187041708,662.81741993475225,704.4374579990872,746.05749606342226,787.6775341277571,829.29757219209228,870.917610256427,912.53764832076217,954.15768638509712,995.77772444943218,1037.3977625137672]
[null,null,0.55000000000000027,214.59700122706724,257.17703929140231,299.75707735573729,342.33711542007217,384.91715348440727,427.49719154874214,470.07722961307724,512.65726767741228,555.23730574174726,597.81734380608225,640.39738187041712,682.97741993475233,725.55745799908732,768.13749606342219,810.71753412775729,853.29757219209228,895.87761025642703,938.45764832076202,981.03768638509712,1023.6177244494321,1066.197762513767]
[null,null,0.56000000000000028,224.19700122706723,267.73703929140225,311.27707735573728,354.81711542007218,398.35715348440721,441.89719154874223,485.43722961307736,528.97726767741221,572.51730574174735,616.05734380608226,659.59738187041717,703.13741993475219,746.67745799908721,790.21749606342235,833.75753412775725,877.29757219209228,920.83761025642707,964.37764832076209,1007.917686385097,1051.4577244494324,1094.9977625137672]
[null,null,0.57000000000000028,233.79700122706723,278.29703929140231,322.79707735573726,367.2971154200722,411.79715348440726,456.29719154874232,500.79722961307738,545.29726767741226,589.79730574174732,634.29734380608227,678.79738187041721,723.29741993475227,767.79745799908733,812.29749606342227,856.79753412775722,901.29757219209228,945.79761025642711,990.29764832076205,1034.7976863850972,1079.2977244494323,1123.7977625137673]
[null,null,0.58000000000000029,243.39700122706725,288.85703929140237,334.31707735573724,379.77711542007222,425.23715348440732,470.69719154874218,516.15722961307733,561.61726767741231,607.0773057417473,652.53734380608228,697.99738187041726,743.45741993475235,788.91745799908745,834.37749606342231,879.83753412775718,925.29757219209228,970.75761025642714,1016.2176483207621,1061.6776863850973,1107.1377244494322,1152.5977625137671]
[null,null,0.5900000000000003,252.99700122706727,299.41703929140232,345.83707735573722,392.25711542007224,438.67715348440726,485.09719154874239,531.51722961307735,577.93726767741225,624.35730574174738,670.77734380608229,717.1973818704173,763.61741993475221,810.03745799908734,856.45749606342224,902.87753412775714,949.29757219209228,995.71761025642706,1042.1376483207623,1088.5576863850972,1134.9777244494323,1181.3977625137672]
[null,null,0.60000000000000031,262.59700122706732,309.97703929140238,357.35707735573732,404.73711542007226,452.11715348440731,499.49719154874248,546.87722961307736,594.2572676774123,641.63730574174747,689.01734380608229,736.39738187041735,783.77741993475229,831.15745799908746,878.53749606342217,925.91753412775734,973.29757219209216,1020.6776102564271,1068.0576483207622,1115.4376863850973,1162.8177244494323,1210.1977625137674]
[null,null,0.61000000000000032,272.19700122706735,320.53703929140232,368.8770773557373,417.21711542007228,465.55715348440725,513.89719154874228,562.23722961307737,610.57726767741235,658.91730574174744,707.2573438060823,755.59738187041739,803.93741993475237,852.27745799908735,900.61749606342255,948.9575341277573,997.29757219209216,1045.6376102564273,1093.9776483207622,1142.3176863850972,1190.6577244494324,1238.9977625137672]
[null,null,0.62000000000000033,281.79700122706726,331.09703929140238,380.39707735573728,429.69711542007229,478.99715348440736,528.29719154874238,577.59722961307739,626.89726767741229,676.19730574174741,725.49734380608231,774.79738187041721,824.09741993475245,873.39745799908746,922.69749606342248,971.99753412775715,1021.2975721920922,1070.5976102564273,1119.8976483207623,1169.1976863850973,1218.4977244494323,1267.7977625137673]
[null,null,0.63000000000000034,291.39700122706728,341.65703929140233,391.91707735573738,442.17711542007231,492.43715348440747,542.69719154874247,592.9572296130774,643.21726767741234,693.47730574174739,743.73734380608232,793.99738187041726,844.25741993475231,894.51745799908736,944.7774960634224,995.03753412775734,1045.2975721920925,1095.5576102564273,1145.8176483207624,1196.0776863850974,1246.3377244494325,1296.5977625137675]
[null,null,0.64000000000000035,300.9970012270673,352.21703929140239,403.43707735573736,454.65711542007233,505.87715348440742,557.09719154874233,608.31722961307742,659.53726767741227,710.75730574174736,761.97734380608233,813.1973818704173,864.41741993475239,915.63745799908747,966.85749606342233,1018.0775341277573,1069.2975721920925,1120.5176102564274,1171.7376483207622,1222.9576863850973,1274.1777244494324,1325.3977625137672]
[null,null,0.65000000000000036,310.59700122706732,362.77703929140233,414.95707735573734,467.13711542007235,519.31715348440741,571.49719154874242,623.67722961307743,675.85726767741244,728.03730574174756,780.21734380608234,832.39738187041735,884.57741993475247,936.75745799908736,988.93749606342215,1041.1175341277574,1093.2975721920925,1145.4776102564274,1197.6576483207623,1249.8376863850974,1302.0177244494325,1354.1977625137674]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,2,{"$f":"Doctor1&\"'s Net Profit After Overhead Cost\"","v":"John Righthinker, D.D.S.'s Net Profit After Overhead Cost"}]
[]
[null,null,null,null,{"$f":"(E$118*CollperCent)","v":1056}]
[null,null,null,null,{"$f":"-IF(AssocPaidOn=1,E$118*CollperCent*$C$129,E$118*$C$129)","v":-369.60000000000008}]
[null,null,null,null,{"$f":"-PayrollTaxAssoc*((IF(AssocPaidOn=1,E$118*CollperCent*$C$129,E$118*$C$129)*(1-AssocVarCosts-AssocLabCosts)-AssocAddlCosts-AssocRDACosts))","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"-E$118*SrDrVarCosts","v":0}]
[null,null,null,null,{"$f":"-AddlCostAssoc","v":-321.60875576036869}]
[null,null,null,null,{"$f":"-DailyOverheadCosts","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"SUM(E107:E112)","v":{"$error":"#NAME?"}},"Result at V429"]
[null,null,null,null,{"$f":"NoDaysWorked","v":17.36}]
[null,null,null,"Assoc. Paid on:",null,null,{"$f":"IF(AssocPaidOn=1,\"Collections\",\"Production\")","v":"Collections"}]
[null,null,null,"Days Worked",null,{"$f":"NoDaysWorked","v":17.36},null,"Collections %",null,{"$f":"CollperCent","v":0.96},null,"Variable Costs",null,{"$f":"SrDrVarCosts","v":0},null,"Addl Costs of Assoc",null,null,{"$f":"-(DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5)","v":321.60875576036869},null,"Overhead",null,null,{"$f":"-'2-New Assoc. Analysis'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Production Rate"]
[null,null,"Per Day",{"$f":"D11","v":1000},1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000]
[null,null,{"$f":"C12","v":0.25},{"$f":"(IF(AssocPaidOn=1,D$118*$J$116*(1-$C119),D$118*(1-$C119))+SrDrSubTotal+PayRlTaxes)","v":154.35027717394146},226.35027717394146,298.35027717394144,370.35027717394144,442.35027717394144,514.35027717394144,586.35027717394144,658.35027717394144,730.35027717394144,802.35027717394144,{"$f":"(IF(AssocPaidOn=1,N$118*$J$116*(1-$C119),N$118*(1-$C119))+SrDrSubTotal+PayRlTaxes)","v":874.35027717394144},946.35027717394144,1018.3502771739414,1090.3502771739415,1162.3502771739415,1234.3502771739415,1306.3502771739415,1378.3502771739415,1450.3502771739415,1522.3502771739415,1594.3502771739415]
[null,null,0.26,144.75027717394144,215.7902771739414,286.83027717394145,357.87027717394142,428.91027717394138,499.95027717394134,570.99027717394131,642.0302771739415,713.07027717394146,784.11027717394143,855.15027717394139,926.19027717394135,997.23027717394132,1068.2702771739416,1139.3102771739416,1210.3502771739415,1281.3902771739415,1352.4302771739415,1423.4702771739414,1494.5102771739414,1565.5502771739414]
[null,null,0.27,135.15027717394142,205.23027717394146,275.31027717394147,345.3902771739414,415.47027717394144,485.55027717394148,555.63027717394141,625.71027717394134,695.79027717394149,765.87027717394142,835.95027717394134,906.0302771739415,976.11027717394143,1046.1902771739415,1116.2702771739416,1186.3502771739415,1256.4302771739415,1326.5102771739414,1396.5902771739416,1466.6702771739415,1536.7502771739416]
[null,null,0.28000000000000003,125.5502771739414,194.6702771739414,263.79027717394138,332.91027717394138,402.03027717394139,471.15027717394139,540.27027717394151,609.3902771739414,678.51027717394129,747.63027717394141,816.7502771739413,885.87027717394142,954.99027717394131,1024.1102771739415,1093.2302771739414,1162.3502771739415,1231.4702771739414,1300.5902771739416,1369.7102771739414,1438.8302771739416,1507.9502771739415]
[null,null,0.29000000000000004,115.95027717394137,184.11027717394145,252.27027717394142,320.43027717394136,388.59027717394144,456.75027717394141,524.91027717394138,593.07027717394146,661.23027717394132,729.3902771739414,797.55027717394125,865.71027717394134,933.87027717394142,1002.0302771739413,1070.1902771739415,1138.3502771739415,1206.5102771739414,1274.6702771739415,1342.8302771739416,1410.9902771739414,1479.1502771739415]
[null,null,0.30000000000000004,106.35027717394146,173.5502771739414,240.75027717394144,307.95027717394134,375.15027717394139,442.35027717394132,509.55027717394125,576.7502771739413,643.95027717394134,711.15027717394139,778.35027717394144,845.55027717394125,912.7502771739413,979.95027717394134,1047.1502771739415,1114.3502771739415,1181.5502771739414,1248.7502771739414,1315.9502771739415,1383.1502771739415,1450.3502771739413]
[null,null,0.31000000000000005,96.750277173941441,162.99027717394145,229.23027717394135,295.47027717394133,361.71027717394134,427.95027717394134,494.19027717394135,560.43027717394136,626.67027717394137,692.91027717394138,759.15027717394139,825.3902771739414,891.63027717394141,957.87027717394142,1024.1102771739413,1090.3502771739413,1156.5902771739413,1222.8302771739413,1289.0702771739413,1355.3102771739414,1421.5502771739414]
[null,null,0.32000000000000006,87.150277173941419,152.43027717394139,217.71027717394136,282.99027717394131,348.27027717394139,413.55027717394137,478.83027717394145,544.11027717394143,609.3902771739414,674.67027717394137,739.95027717394134,805.23027717394132,870.51027717394129,935.79027717394126,1001.0702771739412,1066.3502771739413,1131.6302771739413,1196.9102771739415,1262.1902771739415,1327.4702771739414,1392.7502771739414]
[null,null,0.33000000000000007,77.550277173941396,141.87027717394145,206.19027717394138,270.51027717394129,334.83027717394134,399.15027717394139,463.47027717394133,527.79027717394126,592.1102771739412,656.43027717394136,720.7502771739413,785.07027717394124,849.3902771739414,913.71027717394134,978.03027717394127,1042.3502771739413,1106.6702771739413,1170.9902771739414,1235.3102771739414,1299.6302771739413,1363.9502771739415]
[null,null,0.34000000000000008,67.950277173941373,131.31027717394139,194.6702771739414,258.03027717394139,321.39027717394129,384.7502771739413,448.11027717394131,511.47027717394133,574.83027717394123,638.19027717394135,701.55027717394125,764.91027717394138,828.27027717394128,891.63027717394118,954.99027717394131,1018.3502771739412,1081.7102771739414,1145.0702771739413,1208.4302771739412,1271.7902771739414,1335.1502771739413]
[null,null,0.35000000000000009,{"$f":"(IF(AssocPaidOn=1,D$118*$J$116*(1-$C129),D$118*(1-$C129))+SrDrSubTotal+PayRlTaxes)","v":58.35027717394135},120.75027717394133,183.15027717394142,245.5502771739414,307.95027717394134,370.35027717394132,432.7502771739413,495.15027717394139,557.55027717394125,619.95027717394134,{"$f":"(IF(AssocPaidOn=1,N$118*$J$116*(1-$C129),N$118*(1-$C129))+SrDrSubTotal+PayRlTaxes)","v":682.35027717394121},744.7502771739413,807.15027717394116,869.55027717394125,931.95027717394134,994.35027717394121,1056.7502771739414,1119.1502771739413,1181.5502771739414,1243.9502771739412,1306.3502771739413]
[null,null,0.3600000000000001,48.750277173941328,110.19027717394138,171.63027717394132,233.07027717394138,294.51027717394129,355.95027717394134,417.39027717394129,478.83027717394123,540.27027717394128,601.71027717394134,663.15027717394116,724.59027717394122,786.03027717394127,847.47027717394133,908.91027717394115,970.35027717394121,1031.7902771739414,1093.2302771739412,1154.6702771739413,1216.1102771739413,1277.5502771739414]
[null,null,0.37000000000000011,39.150277173941419,99.630277173941323,160.11027717394134,220.59027717394136,281.07027717394124,341.55027717394125,402.03027717394127,462.51027717394129,522.99027717394131,583.47027717394133,643.95027717394134,704.43027717394114,764.91027717394115,825.39027717394117,885.87027717394119,946.35027717394121,1006.8302771739412,1067.3102771739414,1127.7902771739411,1188.2702771739412,1248.7502771739412]
[null,null,0.38000000000000012,29.550277173941396,89.070277173941378,148.59027717394136,208.11027717394134,267.63027717394129,327.15027717394128,386.67027717394126,446.19027717394124,505.71027717394134,565.23027717394132,624.7502771739413,684.27027717394128,743.79027717394126,803.31027717394124,862.83027717394123,922.35027717394121,981.87027717394119,1041.3902771739413,1100.9102771739413,1160.4302771739412,1219.9502771739412]
[null,null,0.39000000000000012,19.950277173941373,78.510277173941319,137.07027717394126,195.63027717394132,254.19027717394127,312.7502771739413,371.31027717394124,429.87027717394119,488.43027717394114,546.99027717394131,605.55027717394125,664.1102771739412,722.67027717394114,781.23027717394109,839.79027717394104,898.35027717394121,956.91027717394115,1015.4702771739411,1074.0302771739412,1132.5902771739411,1191.1502771739413]
[null,null,0.40000000000000013,10.35027717394135,67.950277173941373,125.55027717394128,183.1502771739413,240.75027717394133,298.35027717394121,355.95027717394123,413.55027717394125,471.15027717394116,528.7502771739413,586.35027717394121,643.95027717394112,701.55027717394125,759.15027717394116,816.75027717394107,874.35027717394121,931.95027717394112,989.55027717394103,1047.1502771739413,1104.7502771739412,1162.3502771739411]
[null,null,0.41000000000000014,0.75027717394132765,57.390277173941314,114.0302771739413,170.67027717394129,227.31027717394127,283.95027717394123,340.59027717394122,397.2302771739412,453.87027717394119,510.51027717394129,567.15027717394116,623.79027717394104,680.43027717394114,737.07027717394124,793.71027717394111,850.35027717394098,906.99027717394108,963.63027717394118,1020.2702771739411,1076.910277173941,1133.5502771739411]
[null,null,0.42000000000000015,-8.8497228260586951,46.830277173941255,102.51027717394132,158.19027717394127,213.87027717394122,269.55027717394125,325.2302771739412,380.91027717394115,436.59027717394122,492.27027717394105,547.95027717394112,603.63027717394118,659.31027717394102,714.99027717394108,770.67027717394114,826.35027717394098,882.03027717394104,937.71027717394111,993.39027717394094,1049.0702771739411,1104.7502771739412]
[null,null,0.43000000000000016,-18.449722826058718,36.270277173941309,90.990277173941337,145.71027717394125,200.43027717394128,255.15027717394119,309.87027717394119,364.59027717394122,419.31027717394113,474.03027717394104,528.75027717394107,583.4702771739411,638.19027717394113,692.91027717394115,747.63027717394118,802.35027717394098,857.07027717394101,911.79027717394104,966.51027717394106,1021.2302771739411,1075.950277173941]
[null,null,0.44000000000000017,-28.049722826058741,25.71027717394125,79.470277173941241,133.23027717394123,186.99027717394122,240.75027717394121,294.51027717394118,348.27027717394117,402.03027717394116,455.79027717394115,509.55027717394103,563.31027717394102,617.07027717394101,670.830277173941,724.59027717394099,778.35027717394098,832.11027717394097,885.87027717394096,939.63027717394095,993.39027717394094,1047.150277173941]
[null,null,0.45000000000000018,{"$f":"(IF(AssocPaidOn=1,D$118*$J$116*(1-$C139),D$118*(1-$C139))+SrDrSubTotal+PayRlTaxes)","v":-37.649722826058763},15.150277173941305,67.950277173941259,120.75027717394121,173.55027717394128,226.35027717394124,279.15027717394116,331.95027717394112,384.75027717394107,437.55027717394114,{"$f":"(IF(AssocPaidOn=1,N$118*$J$116*(1-$C139),N$118*(1-$C139))+SrDrSubTotal+PayRlTaxes)","v":490.35027717394098},543.15027717394116,595.95027717394112,648.75027717394107,701.55027717394103,754.35027717394098,807.15027717394094,859.95027717394089,912.75027717394107,965.55027717394103,1018.350277173941]
[null,null,0.46000000000000019,-47.249722826058672,4.5902771739412458,56.430277173941278,108.2702771739412,160.11027717394123,211.95027717394115,263.79027717394115,315.63027717394118,367.4702771739411,419.31027717394113,471.15027717394116,522.99027717394108,574.830277173941,626.67027717394092,678.51027717394106,730.35027717394098,782.1902771739409,834.03027717394104,885.87027717394096,937.71027717394088,989.5502771739408]
[null,null,0.4700000000000002,-56.849722826058695,-5.9697228260586996,44.910277173941182,95.790277173941178,146.67027717394117,197.55027717394117,248.43027717394116,299.31027717394113,350.19027717394113,401.07027717394112,451.95027717394112,502.830277173941,553.71027717394111,604.59027717394099,655.47027717394087,706.35027717394098,757.23027717394086,808.11027717394097,858.99027717394085,909.87027717394096,960.75027717394084]
[null,null,0.4800000000000002,-66.449722826058718,-16.529722826058759,33.3902771739412,83.310277173941159,133.23027717394123,183.15027717394119,233.07027717394115,282.99027717394108,332.91027717394104,382.83027717394111,432.75027717394107,482.67027717394092,532.59027717394099,582.51027717394106,632.43027717394091,682.35027717394098,732.27027717394083,782.1902771739409,832.11027717394097,882.03027717394082,931.95027717394089]
[null,null,0.49000000000000021,-76.049722826058741,-27.089722826058818,21.870277173941219,70.830277173941255,119.79027717394118,168.7502771739411,217.71027717394114,266.67027717394114,315.63027717394107,364.59027717394099,413.55027717394103,462.51027717394106,511.47027717394087,560.43027717394091,609.39027717394094,658.35027717394098,707.31027717394102,756.27027717394083,805.23027717394086,854.1902771739409,903.15027717394071]
[null,null,0.50000000000000022,-85.649722826058763,-37.649722826058763,10.350277173941237,58.350277173941237,106.35027717394112,154.35027717394112,202.35027717394112,250.35027717394112,298.35027717394109,346.35027717394098,394.35027717394098,442.35027717394098,490.35027717394098,538.35027717394098,586.35027717394098,634.35027717394098,682.35027717394098,730.35027717394075,778.35027717394075,826.35027717394075,874.35027717394075]
[null,null,0.51000000000000023,-95.249722826058786,-48.209722826058822,-1.1697228260587451,45.870277173941219,92.910277173941182,139.95027717394115,186.99027717394111,234.03027717394107,281.07027717394101,328.11027717394097,375.15027717394094,422.19027717394101,469.23027717394086,516.27027717394083,563.31027717394102,610.35027717394098,657.39027717394094,704.43027717394091,751.47027717394087,798.51027717394084,845.5502771739408]
[null,null,0.52000000000000024,-104.84972282605875,-58.769722826058768,-12.689722826058841,33.3902771739412,79.470277173941128,125.55027717394117,171.6302771739411,217.71027717394102,263.79027717394104,309.87027717394096,355.950277173941,402.03027717394093,448.11027717394097,494.1902771739409,540.27027717394083,586.35027717394075,632.43027717394091,678.51027717394084,724.59027717394076,770.67027717394069,816.75027717394084]
[null,null,0.53000000000000025,-114.44972282605877,-69.329722826058827,-24.209722826058822,20.910277173941182,66.030277173941073,111.15027717394108,156.27027717394108,201.39027717394109,246.51027717394109,291.63027717394095,336.75027717394096,381.87027717394096,426.99027717394085,472.11027717394097,517.23027717394086,562.35027717394075,607.47027717394087,652.59027717394076,697.71027717394065,742.83027717394077,787.95027717394066]
[null,null,0.54000000000000026,-124.0497228260588,-79.889722826058829,-35.729722826058804,8.4302771739411639,52.590277173941132,96.7502771739411,140.91027717394107,185.07027717394104,229.230277173941,273.39027717394094,317.55027717394091,361.71027717394088,405.87027717394085,450.03027717394082,494.1902771739409,538.35027717394075,582.51027717394084,626.67027717394069,670.83027717394077,714.99027717394063,759.15027717394071]
[null,null,0.55000000000000027,{"$f":"(IF(AssocPaidOn=1,D$118*$J$116*(1-$C149),D$118*(1-$C149))+SrDrSubTotal+PayRlTaxes)","v":-133.64972282605876},-90.449722826058832,-47.2497228260589,-4.0497228260588543,39.150277173941078,82.350277173941123,125.55027717394105,168.75027717394099,211.95027717394103,255.15027717394096,{"$f":"(IF(AssocPaidOn=1,N$118*$J$116*(1-$C149),N$118*(1-$C149))+SrDrSubTotal+PayRlTaxes)","v":298.35027717394098},341.55027717394091,384.75027717394084,427.95027717394089,471.15027717394071,514.35027717394075,557.5502771739408,600.75027717394084,643.95027717394066,687.15027717394071,730.35027717394075]
[null,null,0.56000000000000028,-143.24972282605879,-101.00972282605883,-58.769722826058882,-16.529722826058872,25.710277173941137,67.950277173941032,110.19027717394104,152.43027717394105,194.67027717394095,236.91027717394095,279.15027717394094,321.39027717394083,363.63027717394084,405.87027717394085,448.11027717394074,490.35027717394075,532.59027717394076,574.83027717394077,617.07027717394078,659.31027717394056,701.55027717394057]
[null,null,0.57000000000000028,-152.84972282605881,-111.56972282605884,-70.289722826058863,-29.009722826058891,12.270277173941082,53.550277173941055,94.830277173941028,136.110277173941,177.39027717394097,218.67027717394095,259.95027717394089,301.23027717394086,342.51027717394084,383.79027717394081,425.07027717394078,466.35027717394075,507.63027717394073,548.9102771739407,590.19027717394067,631.47027717394064,672.75027717394062]
[null,null,0.58000000000000029,-162.44972282605883,-122.12972282605884,-81.809722826058845,-41.489722826058909,-1.1697228260589725,39.150277173941078,79.470277173941014,119.79027717394095,160.110277173941,200.43027717394094,240.75027717394087,281.07027717394089,321.39027717394083,361.71027717394077,402.03027717394082,442.35027717394075,482.67027717394069,522.99027717394063,563.31027717394056,603.63027717394073,643.95027717394066]
[null,null,0.5900000000000003,-172.04972282605885,-132.68972282605884,-93.329722826058884,-53.969722826058927,-14.609722826058913,24.750277173940987,64.110277173941,103.47027717394101,142.83027717394091,182.19027717394093,221.55027717394083,260.91027717394081,300.27027717394083,339.63027717394073,378.99027717394074,418.35027717394075,457.71027717394065,497.07027717394055,536.43027717394068,575.79027717394058,615.15027717394048]
[null,null,0.60000000000000031,-181.64972282605882,-143.24972282605884,-104.84972282605892,-66.449722826058945,-28.049722826058968,10.350277173941009,48.750277173940987,87.150277173940964,125.55027717394094,163.95027717394092,202.3502771739409,240.75027717394087,279.15027717394082,317.5502771739408,355.95027717394066,394.35027717394064,432.75027717394062,471.15027717394071,509.55027717394057,547.95027717394066,586.35027717394053]
[null,null,0.61000000000000032,-191.24972282605884,-153.80972282605885,-116.3697228260589,-78.929722826058963,-41.489722826058909,-4.0497228260589679,33.390277173940973,70.830277173940914,108.27027717394085,145.71027717394091,183.15027717394085,220.59027717394079,258.03027717394082,295.47027717394076,332.9102771739407,370.35027717394064,407.79027717394058,445.23027717394064,482.67027717394069,520.11027717394052,557.55027717394057]
[null,null,0.62000000000000033,-200.84972282605887,-164.3697228260589,-127.88972282605889,-91.409722826058925,-54.929722826058963,-18.449722826059059,18.030277173940959,54.510277173940977,90.990277173940882,127.4702771739409,163.9502771739408,200.43027717394082,236.91027717394073,273.39027717394072,309.87027717394074,346.35027717394064,382.83027717394066,419.31027717394056,455.79027717394058,492.2702771739406,528.75027717394039]
[null,null,0.63000000000000034,-210.44972282605883,-174.92972282605891,-139.40972282605892,-103.88972282605894,-68.369722826059018,-32.849722826059036,2.6702771739409457,38.190277173940927,73.710277173940909,109.23027717394089,144.75027717394087,180.27027717394074,215.79027717394072,251.3102771739407,286.83027717394066,322.35027717394064,357.87027717394062,393.3902771739406,428.91027717394047,464.43027717394045,499.95027717394044]
[null,null,0.64000000000000035,-220.04972282605885,-185.48972282605891,-150.92972282605896,-116.36972282605896,-81.809722826059016,-47.249722826059013,-12.689722826059068,21.870277173940877,56.430277173940823,90.990277173940882,125.55027717394083,160.11027717394077,194.67027717394072,229.23027717394066,263.79027717394058,298.35027717394064,332.91027717394059,367.47027717394053,402.03027717394048,436.59027717394042,471.15027717394048]
[null,null,0.65000000000000036,-229.64972282605888,-196.04972282605891,-162.44972282605895,-128.84972282605898,-95.249722826059013,-61.649722826059048,-28.049722826059082,5.5502771739408274,39.15027717394085,72.750277173940873,106.35027717394078,139.95027717394069,173.55027717394071,207.15027717394074,240.75027717394065,274.35027717394053,307.95027717394055,341.55027717394057,375.15027717394048,408.75027717394039,442.35027717394041]

{"sheet":"4-Sr Dr Pay Chart","index":3,"n_rows":52,"n_cols":28,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,{"$f":"\"# 4 - \"&Doctor1&\"'s Daily Net Profit Before Overhead Cost\"","v":"# 4 - John Righthinker, D.D.S.'s Daily Net Profit Before Overhead Cost"}]
[null,null,null,"Assumptions:",null,null,null," ",null," "]
[]
[null,null,null,"Days Worked",null,{"$f":"NoDaysWorked","v":17.36},null,"Collections %",null,{"$f":"CollperCent","v":0.96},null,"Variable Costs",null,{"$f":"VarCostsPerctUniversal","v":0.09},null,"Team Cost",null,{"$f":"DrClinAsst_FrntDsk","v":-184.8},null,"Other Expenses",null,{"$f":"DrAnnExp","v":-156.00998463901692}]
[]
[null,null,{"$f":"SrDrRange","v":"Lab Fees"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"New Assoc.","Assoc."]
[null,null,"Universal Costs",90,99,108,117,126,135,144,153,162,171,180,189,198,207,216,225,234,243,252,261,270,null,null,"Est. Prod.","Comm. %"]
[null,null,"Production Rate","","","","","","","","","","","","","","","","","","","","","",null,null,{"$f":"New_Associate_Est._Prod.","v":2000},{"$f":"Associate_commission_percentage","v":0.45}]
[null,null,"Per Day",1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000]
[null,"Percent",0.25,306.75027717394136,367.35027717394132,427.9502771739414,488.55027717394137,549.1502771739415,609.75027717394141,670.35027717394155,730.95027717394146,791.55027717394137,852.1502771739415,912.75027717394164,973.35027717394178,1033.9502771739417,1094.5502771739416,1155.1502771739417,1215.7502771739416,1276.3502771739418,1336.9502771739417,1397.5502771739416,1458.1502771739417,1518.7502771739416]
[null,{"$f":"IF('2-New Assoc. Analysis'!$H$37=1,\"of Coll.\",\"of Prod.\")","v":"of Coll."},0.26,296.19027717394141,355.73427717394151,415.27827717394138,474.82227717394125,534.3662771739414,593.91027717394127,653.45427717394136,712.99827717394146,772.54227717394156,832.08627717394143,891.63027717394152,951.17427717394185,1010.7182771739417,1070.2622771739418,1129.8062771739417,1189.3502771739418,1248.8942771739416,1308.4382771739415,1367.9822771739416,1427.5262771739415,1487.0702771739413]
[null,"Paid to",0.27,285.63027717394135,344.11827717394141,402.60627717394135,461.09427717394141,519.58227717394152,578.07027717394158,636.55827717394141,695.04627717394146,753.53427717394152,812.02227717394135,870.5102771739414,928.99827717394146,987.48627717394174,1045.9742771739416,1104.4622771739419,1162.9502771739417,1221.4382771739415,1279.9262771739416,1338.4142771739416,1396.9022771739417,1455.390277173942]
[null,"Assoc.",0.28000000000000003,275.07027717394141,332.50227717394131,389.93427717394133,447.36627717394134,504.79827717394147,562.23027717394143,619.66227717394145,677.09427717394146,734.52627717394125,791.9582771739415,849.39027717394151,906.82227717394176,964.25427717394155,1021.6862771739418,1079.1182771739416,1136.5502771739416,1193.9822771739416,1251.4142771739414,1308.8462771739416,1366.2782771739417,1423.7102771739417]
[null,null,0.29000000000000004,264.51027717394135,320.88627717394144,377.26227717394136,433.63827717394128,490.01427717394131,546.39027717394129,602.76627717394149,659.14227717394124,715.51827717394144,771.89427717394142,828.27027717394117,884.64627717394137,941.02227717394157,997.39827717394155,1053.7742771739415,1110.1502771739417,1166.5262771739415,1222.9022771739417,1279.2782771739417,1335.6542771739416,1392.0302771739416]
[null,null,0.30000000000000004,253.9502771739414,309.27027717394134,364.59027717394133,419.91027717394121,475.23027717394137,530.55027717394137,585.8702771739413,641.19027717394124,696.5102771739414,751.83027717394134,807.1502771739415,862.47027717394121,917.7902771739416,973.11027717394154,1028.4302771739417,1083.7502771739416,1139.0702771739416,1194.3902771739415,1249.7102771739417,1305.0302771739414,1360.3502771739415]
[null,null,0.31000000000000005,243.39027717394134,297.65427717394124,351.91827717394125,406.18227717394115,460.44627717394127,514.71027717394122,568.97427717394135,623.23827717394147,677.50227717394137,731.76627717394149,786.03027717394139,840.29427717394151,894.55827717394118,948.82227717394176,1003.0862771739414,1057.3502771739418,1111.6142771739414,1165.8782771739418,1220.1422771739415,1274.4062771739416,1328.6702771739415]
[null,null,0.32000000000000006,232.83027717394143,286.03827717394137,339.24627717394134,392.45427717394131,445.66227717394116,498.87027717394136,552.07827717394139,605.28627717394124,658.49427717394133,711.70227717394141,764.91027717394127,818.11827717394135,871.32627717394121,924.53427717394152,977.74227717394137,1030.9502771739417,1084.1582771739413,1137.3662771739416,1190.5742771739413,1243.7822771739416,1296.9902771739414]
[null,null,0.33000000000000007,222.27027717394137,274.42227717394138,326.57427717394131,378.7262771739413,430.87827717394129,483.03027717394139,535.1822771739412,587.33427717394125,639.48627717394129,691.63827717394133,743.79027717394138,795.94227717394119,848.09427717394146,900.24627717394151,952.39827717394155,1004.5502771739414,1056.7022771739414,1108.8542771739415,1161.0062771739415,1213.1582771739413,1265.3102771739416]
[null,null,0.34000000000000008,211.71027717394131,262.80627717394128,313.90227717394129,364.99827717394123,416.09427717394141,467.19027717394118,518.28627717394124,569.38227717394125,620.47827717394148,671.57427717394103,722.67027717394126,773.76627717394149,824.86227717394127,875.95827717394127,927.0542771739415,978.1502771739415,1029.2462771739413,1080.3422771739415,1131.4382771739415,1182.5342771739415,1233.6302771739413]
[null,null,0.35000000000000009,201.15027717394125,251.1902771739413,301.23027717394137,351.27027717394122,401.3102771739413,451.35027717394127,501.39027717394134,551.43027717394125,601.47027717394121,651.5102771739414,701.55027717394114,751.59027717394133,801.63027717394107,851.67027717394126,901.71027717394168,951.75027717394141,1001.7902771739414,1051.8302771739413,1101.8702771739415,1151.9102771739415,1201.9502771739415]
[null,null,0.3600000000000001,190.5902771739413,239.57427717394131,288.55827717394124,337.54227717394116,386.5262771739412,435.51027717394135,484.49427717394133,533.47827717394125,582.4622771739414,631.4462771739411,680.43027717394125,729.41427717394117,778.39827717394132,827.38227717394125,876.36627717394117,925.35027717394155,974.33427717394125,1023.3182771739414,1072.3022771739413,1121.2862771739415,1170.2702771739414]
[null,null,0.37000000000000011,180.03027717394136,227.95827717394124,275.88627717394132,323.81427717394132,371.74227717394115,419.6702771739412,467.59827717394109,515.52627717394125,563.45427717394136,611.38227717394125,659.31027717394136,707.23827717394147,755.16627717394113,803.09427717394124,851.02227717394112,898.95027717394146,946.87827717394134,994.80627717394123,1042.7342771739413,1090.6622771739412,1138.5902771739413]
[null,null,0.38000000000000012,169.47027717394118,216.34227717394126,263.2142771739413,310.08627717394126,356.95827717394127,403.83027717394128,450.70227717394113,497.57427717394131,544.4462771739411,591.31827717394117,638.19027717394101,685.06227717394108,731.93427717394093,778.806277173941,825.6782771739413,872.55027717394114,919.42227717394144,966.29427717394151,1013.1662771739414,1060.0382771739414,1106.9102771739413]
[null,null,0.39000000000000012,158.91027717394135,204.72627717394127,250.54227717394116,296.3582771739413,342.17427717394122,387.99027717394114,433.80627717394117,479.62227717394097,525.43827717394129,571.25427717394132,617.07027717394135,662.88627717394115,708.70227717394118,754.51827717394099,800.33427717394102,846.15027717394105,891.96627717394108,937.78227717394134,983.59827717394114,1029.4142771739412,1075.2302771739414]
[null,null,0.40000000000000013,148.35027717394129,193.11027717394128,237.87027717394125,282.63027717394124,327.39027717394123,372.15027717394105,416.91027717394121,461.6702771739412,506.43027717394108,551.19027717394101,595.95027717394123,640.71027717394099,685.47027717394121,730.2302771739412,774.99027717394097,819.75027717394096,864.51027717394118,909.27027717394117,954.03027717394139,998.79027717394138,1043.5502771739411]
[null,null,0.41000000000000014,137.79027717394123,181.4942771739413,225.19827717394125,268.90227717394117,312.60627717394124,356.31027717394113,400.01427717394103,443.7182771739412,487.42227717394121,531.12627717394139,574.83027717394111,618.53427717394106,662.23827717394124,705.94227717394119,749.64627717394114,793.35027717394087,837.05427717394105,880.75827717394122,924.46227717394117,968.16627717394113,1011.8702771739413]
[null,null,0.42000000000000015,127.23027717394129,169.8782771739412,212.52627717394122,255.17427717394122,297.82227717394113,340.47027717394116,383.11827717394112,425.76627717394098,468.41427717394112,511.06227717394114,553.71027717394099,596.35827717394113,639.00627717394104,681.65427717394095,724.30227717394109,766.950277173941,809.59827717394091,852.24627717394105,894.89427717394096,937.5422771739411,980.19027717394124]
[null,null,0.43000000000000016,116.67027717394123,158.26227717394121,199.85427717394131,241.44627717394116,283.03827717394114,324.63027717394112,366.22227717394117,407.81427717394121,449.40627717394108,490.99827717394123,532.5902771739411,574.1822771739412,615.77427717394107,657.36627717394094,698.95827717394104,740.55027717394091,782.14227717394101,823.73427717394111,865.32627717394098,906.91827717394131,948.51027717394118]
[null,null,0.44000000000000017,106.11027717394128,146.64627717394134,187.18227717394117,227.71827717394123,268.25427717394115,308.79027717394109,349.32627717394115,389.86227717394098,430.39827717394104,470.9342771739411,511.47027717394127,552.00627717394104,592.54227717394133,633.07827717394093,673.61427717394099,714.15027717394105,754.68627717394088,795.22227717394094,835.758277173941,876.29427717394083,916.83027717394111]
[null,null,0.45000000000000018,95.550277173941211,135.03027717394124,174.51027717394115,213.99027717394117,253.47027717394116,292.95027717394117,332.43027717394108,371.91027717394104,411.390277173941,450.87027717394102,490.35027717394087,529.83027717394111,569.31027717394113,608.79027717394115,648.27027717394094,687.75027717394096,727.23027717394098,766.71027717394077,806.19027717394101,845.67027717394103,885.15027717394105]
[null,null,0.46000000000000019,84.990277173941266,123.41427717394114,161.83827717394124,200.2622771739411,238.68627717394116,277.11027717394103,315.53427717394112,353.9582771739411,392.38227717394096,430.80627717394094,469.23027717394092,507.65427717394101,546.07827717394093,584.50227717394114,622.92627717394112,661.35027717394087,699.77427717394085,738.19827717394105,776.62227717394103,815.04627717394078,853.47027717394076]
[null,null,0.4700000000000002,74.430277173941263,111.79827717394127,149.1662771739411,186.53427717394115,223.90227717394109,261.27027717394111,298.63827717394105,336.0062771739411,373.37427717394098,410.74227717394109,448.11027717394103,485.47827717394102,522.84627717394096,560.2142771739409,597.58227717394084,634.950277173941,672.31827717394071,709.68627717394088,747.05427717394082,784.42227717394098,821.79027717394092]
[null,null,0.4800000000000002,63.870277173941204,100.18227717394117,136.49427717394119,172.80627717394108,209.11827717394121,245.43027717394108,281.74227717394109,318.05427717394099,354.366277173941,390.67827717394101,426.99027717394091,463.30227717394104,499.61427717394105,535.92627717394112,572.23827717394079,608.55027717394091,644.86227717394081,681.17427717394094,717.48627717394083,753.79827717394073,790.11027717394086]
[null,null,0.49000000000000021,53.310277173941202,88.56627717394106,123.82227717394116,159.07827717394125,194.3342771739411,229.59027717394108,264.84627717394102,300.1022771739411,335.35827717394096,370.61427717394099,405.87027717394079,441.12627717394088,476.38227717394074,511.63827717394093,546.89427717394096,582.15027717394105,617.40627717394091,652.66227717394077,687.91827717394085,723.17427717394094,758.43027717394057]
[null,null,0.50000000000000022,42.750277173941136,76.950277173941188,111.15027717394113,145.35027717394118,179.55027717394111,213.75027717394104,247.95027717394106,282.15027717394099,316.35027717394104,350.55027717394086,384.75027717394096,418.95027717394095,453.15027717394076,487.35027717394087,521.55027717394091,555.75027717394096,589.950277173941,624.15027717394059,658.35027717394064,692.55027717394069,726.75027717394073]
[null,null,0.51000000000000023,32.190277173941134,65.334277173941089,98.478277173941223,131.62227717394111,164.76627717394112,197.91027717394113,231.05427717394102,264.19827717394099,297.34227717394089,330.48627717394089,363.63027717394084,396.77427717394079,429.91827717394079,463.06227717394057,496.20627717394115,529.35027717394087,562.49427717394087,595.63827717394088,628.78227717394088,661.92627717394089,695.07027717394067]
[null,null,0.52000000000000024,21.630277173941188,53.718277173941161,85.806277173941069,117.89427717394116,149.98227717394101,182.07027717394109,214.15827717394106,246.24627717394088,278.33427717394096,310.42227717394093,342.51027717394089,374.59827717394091,406.68627717394082,438.77427717394079,470.86227717394075,502.95027717394083,535.03827717394097,567.12627717394071,599.21427717394067,631.30227717394064,663.39027717394083]
[null,null,0.53000000000000025,11.070277173941129,42.102277173941111,73.134277173941157,104.1662771739411,135.19827717394102,166.23027717394095,197.26227717394099,228.29427717394103,259.32627717394092,290.35827717394085,321.39027717394089,352.42227717394093,383.45427717394068,414.48627717394078,445.5182771739407,476.55027717394063,507.58227717394089,538.61427717394076,569.64627717394069,600.67827717394084,631.71027717394054]
[null,null,0.54000000000000026,0.51027717394118355,30.486277173941126,60.462277173941132,90.438277173941131,120.41427717394103,150.39027717394103,180.36627717394103,210.34227717394091,240.31827717394088,270.29427717394088,300.270277173941,330.24627717394077,360.22227717394094,390.19827717394077,420.17427717394065,450.15027717394054,480.12627717394065,510.10227717394065,540.07827717394071,570.05427717394059,600.0302771739407]
[null,null,0.55000000000000027,-10.049722826058817,18.870277173941084,47.790277173940993,76.710277173941066,105.63027717394104,134.550277173941,163.47027717394096,192.39027717394092,221.31027717394099,250.23027717394081,279.15027717394088,308.07027717394072,336.9902771739408,365.91027717394081,394.8302771739406,423.75027717394067,452.67027717394075,481.59027717394088,510.51027717394078,539.43027717394057,568.35027717394064]
[null,null,0.56000000000000028,-20.609722826058878,7.2542771739411549,35.118277173941017,62.982277173941,90.846277173941033,118.71027717394097,146.574277173941,174.43827717394092,202.30227717394084,230.16627717394087,258.03027717394087,285.89427717394091,313.75827717394083,341.62227717394063,369.48627717394061,397.35027717394058,425.21427717394062,453.07827717394065,480.94227717394074,508.8062771739406,536.67027717394058]
[null,null,0.57000000000000028,-31.16972282605888,-4.3617228260589425,22.446277173941048,49.254277173941048,76.062277173941041,102.87027717394093,129.67827717394093,156.48627717394092,183.29427717394091,210.10227717394091,236.91027717394076,263.71827717394075,290.52627717394074,317.33427717394073,344.14227717394073,370.95027717394055,397.75827717394048,424.56627717394048,451.37427717394047,478.18227717394046,504.99027717394057]
[null,null,0.58000000000000029,-41.729722826058939,-15.977722826058985,9.7742771739410799,35.526277173940976,61.278277173940936,87.030277173941002,112.78227717394097,138.53427717394081,164.28627717394087,190.03827717394083,215.79027717394078,241.5422771739407,267.29427717394054,293.04627717394072,318.79827717394068,344.55027717394063,370.30227717394064,396.05427717394053,421.80627717394049,447.55827717394067,473.31027717394062]
[null,null,0.5900000000000003,-52.289722826058942,-27.593722826058915,-2.8977228260588888,21.798277173940967,46.494277173940944,71.190277173940856,95.886277173940883,120.58227717394092,145.27827717394084,169.97427717394086,194.67027717394078,219.36627717394092,244.06227717394069,268.7582771739406,293.45427717394074,318.15027717394065,342.84627717394056,367.54227717394042,392.2382771739405,416.93427717394042,441.63027717394033]
[null,null,0.60000000000000031,-62.849722826058944,-39.209722826059014,-15.569722826059026,8.0702771739409584,31.710277173940945,55.350277173940938,78.990277173940925,102.63027717394093,126.27027717394068,149.91027717394078,173.55027717394066,197.19027717394076,220.83027717394063,244.4702771739407,268.11027717394057,291.75027717394067,315.39027717394055,339.03027717394065,362.67027717394035,386.31027717394039,409.95027717394026]
[null,null,0.61000000000000032,-73.40972282605901,-50.825722826058943,-28.241722826058997,-5.6577228260590484,16.92627717394101,39.510277173940899,62.094277173940853,84.678277173940799,107.26227717394076,129.84627717394082,152.43027717394065,175.01427717394071,197.59827717394077,220.18227717394049,242.76627717394064,265.35027717394058,287.93427717394042,310.51827717394048,333.10227717394054,355.68627717394037,378.27027717394049]
[null,null,0.62000000000000033,-83.969722826058884,-62.441722826058985,-40.913722826058965,-19.385722826059059,2.1422771739409612,23.670277173940811,45.198277173940895,66.726277173940915,88.254277173940821,109.78227717394086,131.31027717394088,152.83827717394055,174.36627717394057,195.89427717394059,217.42227717394073,238.95027717394061,260.4782771739404,282.00627717394042,303.53427717394044,325.06227717394046,346.59027717394025]
[null,null,0.63000000000000034,-94.529722826058887,-74.057722826058921,-53.585722826059104,-33.113722826059124,-12.641722826059143,7.8302771739408357,28.302277173940816,48.774277173940803,69.246277173940783,89.718277173940763,110.19027717394076,130.66227717394074,151.13427717394072,171.6062771739407,192.07827717394045,212.55027717394043,233.02227717394041,253.49427717394036,273.96627717394034,294.43827717394032,314.9102771739403]
[null,null,0.64000000000000035,-105.08972282605895,-85.673722826059006,-66.25772282605908,-46.841722826059133,-27.425722826059079,-8.0097228260591375,11.406277173940801,30.822277173940911,50.238277173940858,69.654277173940798,89.070277173940738,108.48627717394069,127.90227717394063,147.31827717394057,166.73427717394051,186.15027717394045,205.56627717394039,224.98227717394056,244.39827717394047,263.81427717394041,283.23027717394035]
[null,null,0.65000000000000036,-115.64972282605895,-97.289722826058934,-78.929722826059049,-60.569722826059142,-42.209722826059128,-23.849722826059114,-5.4897228260592126,12.870277173940686,31.230277173940586,49.59027717394072,67.95027717394062,86.31027717394052,104.67027717394078,123.03027717394068,141.39027717394058,159.75027717394047,178.11027717394037,196.4702771739405,214.8302771739404,233.1902771739403,251.5502771739404]

{"sheet":"5-Breakeven Chart","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"#5 - Breakeven Take Home"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!Y356","v":"45% Commission on Collections"}]

{"sheet":"Calcs","index":5,"n_rows":357,"n_cols":46,"rows_kept":357,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"Formal_Practice_Name","v":"Rocky View Dental Care"}]
[{"$f":"\"Practice: \"&Doctor1","v":"Practice: John Righthinker, D.D.S."}]
["New Associate Analysis - MasterPlan Alliance Recomendations",null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-03-23T21:47:12.910"},null,{"$f":"'1-Input Data'!$D$7","v":"John Righthinker, D.D.S."},null,null,{"$f":"O4","v":"John Righthinker, D.D.S."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1-Input Data'!$D$10","v":"Irving Wannabe, D.M.D."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SrDrName","v":"John Righthinker, D.D.S."},{"$f":"Calcs!O6","v":"John Righthinker, D.D.S."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[]
[{"$f":"Potential_Associate_Name&\"'s Estimated Current Daily Production\"","v":"Irving Wannabe, D.M.D.'s Estimated Current Daily Production"},null,null,null,null,null,null,null,null,{"$f":"'1-Input Data'!$D$30","v":2000}]
[{"$f":"\"Estimated Normal Daily Hours Worked by \"&AssocName","v":"Estimated Normal Daily Hours Worked by Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,null,{"$f":"ENDHWNA1","v":8},null,null,null,null,null,null,"AssStdDaysMo",{"$f":"AssStdDaysMo","v":17.36},null,null,"AssStdDaysMo",{"$f":"AssStdDaysMo","v":17.36}]
[{"$f":"\"Number of operatories used by \"&AssocName","v":"Number of operatories used by Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,"x",1]
[{"$f":"\"Operatory hours per Normal Day for \"&AssocName","v":"Operatory hours per Normal Day for Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,null,{"$f":"J10*J11","v":8}]
[]
["\"Standard\" treatment hours per day for this practice",null,null,null,null,null,null,null,null,{"$f":"Std__treatment_hours_per_day_for_this_practice","v":0}]
[{"$f":"\"Number of operatories used by \"&AssocName","v":"Number of operatories used by Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,"x",1]
[{"$f":"\"Operatory hours per Standard Day for \"&AssocName","v":"Operatory hours per Standard Day for Irving Wannabe, D.M.D."},null,null,null,null,null,null,null,null,{"$f":"J14*J15","v":0}]
[{"$f":"AssocName&\"'s Days worked Per Week\"","v":"Irving Wannabe, D.M.D.'s Days worked Per Week"},null,null,null,null,null,null,null,null,{"$f":"Dr._Assoc2_s_Days_worked_Per_Week","v":4}]
[{"$f":"AssocName&\"'s Production per Standard Day\"","v":"Irving Wannabe, D.M.D.'s Production per Standard Day"},null,null,null,null,null,null,null,null,{"$f":"J9/J10*J14","v":0}]
["Collections percent:",null,null,null,null,null,null,null,null,{"$f":"CollperCent","v":0.96}]
["Associate commission percentage:",null,null,null,null,null,null,null,null,{"$f":"'1-Input Data'!$D$40","v":0.45}]
["Associate paid on  (1=Collections, 2=Production)",null,null,null,null,null,null,null,null,{"$f":"Associate_paid_on","v":1}]
[]
["Historical Production",null,null,null,null,null,null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assoc. Addl Expense",null,null,null,{"$f":"AssocAddlCosts","v":0}]
["Month",null,null,"Days","Hours","General","Speclty","Hygiene","Total","Average","Average","    Collections *",null,"New"]
[null,null,null,"Worked","Worked","Dental","Prod","Prod","Prod","Prod","Prod","@",null,"Patients"]
[null,null,null,null,null,"Prod",null,"by Dr",null,"per Day","per Hr",{"$f":"CollperCent","v":0.96},"Ratio",null,null,null,"Net Contri. On an Assoc New Pt.",null,null,null,{"$f":"NetContribAssocNewPt","v":0}]
["May",87,"(Avg)",{"$f":"I48","v":12.5},{"$f":"D28*StdTreatHours","v":0},{"$f":"I51","v":12844.416666666666},0,0,{"$f":"SUM(F28:H28)","v":12844.416666666666},{"$f":"I28/D28","v":1027.5533333333333},{"$f":"I28/E28","v":{"$error":"#DIV/0!"}},"N/A",null,null,null,null,"Number of new pat. - B/E",null,null,null,{"$f":"NewPtBE","v":0}]
["Jun",null,null,15,0,15856,0,0,15856,1057.0666666666666,{"$error":"#DIV/0!"},{"$f":"I28*CollperCent","v":12330.64},{"$f":"L29/I28","v":0.96},30]
["Jul",null,null,12,0,11258,0,0,11258,938.16666666666663,{"$error":"#DIV/0!"},15221.76,0.96,16]
["Aug",null,null,12,0,13602,0,0,13602,1133.5,{"$error":"#DIV/0!"},10807.68,0.96000000000000008,21]
["Sep",null,null,14,0,10852,0,0,10852,775.14285714285711,{"$error":"#DIV/0!"},13057.92,0.96,19]
["Oct",null,null,14,0,18960,0,0,18960,1354.2857142857142,{"$error":"#DIV/0!"},10417.92,0.96,19]
["Nov",null,null,11,0,9024,0,0,9024,820.36363636363637,{"$error":"#DIV/0!"},18201.599999999999,0.96,9]
["Dec",null,null,11,0,13551,0,0,13551,1231.909090909091,{"$error":"#DIV/0!"},8663.0399999999991,0.95999999999999985,14]
["Jan",88,null,14,0,12210,0,0,12210,872.14285714285711,{"$error":"#DIV/0!"},13008.96,0.96,16]
["Feb",null,null,9,0,9388,0,0,9388,1043.1111111111111,{"$error":"#DIV/0!"},11721.6,0.96000000000000008,19]
["Mar",null,null,16,0,14972,0,0,14972,935.75,{"$error":"#DIV/0!"},9012.48,0.96,24]
["Apr",null,null,10,0,12086,0,0,12086,1208.5999999999999,{"$error":"#DIV/0!"},14373.119999999999,0.96,17]
["May",null,null,12,0,12374,0,0,12374,1031.1666666666667,{"$error":"#DIV/0!"},11602.56,0.96,23]
[null,null,null,"________","________","________","________","________","________","________","________","________","________","________",null,null,{"$f":"SrDrVarCosts","v":0}]
["12-mo. total",null,null,{"$f":"SUM(D29:D41)","v":150},0,154133,0,0,154133,"N/A","N/A",{"$f":"SUM(L29:L41)","v":148419.28},{"$f":"L42/SUM(I28:I39)","v":0.96000000000000008},{"$f":"SUM(N29:N41)","v":227}]
[null,null,null,"________","________","________","________","________","________","________","________","________","________","________"]
[null,null,null,"________","________","________","________","________","________","________","________","________","________","________"]
[null,"* Individual collection figures not provided.  Collections calculated with 30-day lag time."]
[]
["Historical Averages:",null,null,null,null,null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[null,null,null,"# Days Worked per Month:",null,null,null,null,{"$f":"D42/COUNT(D29:D40)","v":12.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X48","v":0},0,0,0,0,0]
[null,null,null,"# Hours Worked per Month:",null,null,null,null,{"$f":"E42/COUNT(E29:E40)","v":0}]
[null,null,null,"# Hours Worked per Day:",null,null,null,null,{"$f":"I49/I48","v":0}]
[null,null,null,"Prod. per Month:",null,null,null,null,{"$f":"I42/COUNT(F29:F40)","v":12844.416666666666},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X51","v":0},0,0,0,0,0]
[null,null,null,"Prod. per Day:",null,null,null,null,{"$f":"I42/D42","v":1027.5533333333333}]
[null,null,null,"Prod. per Hour:",null,null,null,null,{"$f":"I42/E42","v":{"$error":"#DIV/0!"}}]
[null,null,null,"New Patients per Month:",null,null,null,null,{"$f":"N42/COUNT(N29:N40)","v":18.916666666666668},null,null,null,null,null,null,null,null,null,{"$f":"I54","v":18.916666666666668},{"$f":"S54","v":18.916666666666668},18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668,18.916666666666668]
[]
[{"$f":"AssocName","v":"Irving Wannabe, D.M.D."},null,null,"is paid a percent of (1=coll, 2=prod)",null,null,null,null,1]
["Value of a new patient:",null,null,null,null,{"$f":"Value_of_a_new_patient","v":1200}]
[{"$f":"\"Production required to sustain \"&AssocName","v":"Production required to sustain Irving Wannabe, D.M.D."},null,null,null,null,null,null,{"$f":"J9*J201","v":34720}]
["# of new patients per mo. reqd. to sustain associate ",null,null,null,null,null,null,{"$f":"H58/F57","v":28.933333333333334}]
[]
[]
[{"$f":"\"Net profit per standard day of production by \"&AssocName","v":"Net profit per standard day of production by Irving Wannabe, D.M.D."}]
[]
[null,null,null,null,null,null,null,null,null,null,"Profit to",null,"Profit to"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Doctor1","v":"John Righthinker, D.D.S."},null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[]
[null,"Current Production per Standard Day",null,null,null,null,null,{"$f":"J9","v":2000}]
[null,null,null,null,null,null,"x",{"$f":"CollperCent","v":0.96}]
[]
[null,"Current Collections per Standard Day",null,null,null,null,null,{"$f":"$H$67*$H$68","v":1920},null,null,{"$f":"$H$70","v":1920}]
[]
[]
[null,"Associate's fee",null,null,null,{"$f":"AssCommPct","v":0.45}," "]
[null,null,"Paid on:",null,null,null,{"$f":"AssocPaidOn","v":1},"(1=Collections; 2 = Production)"]
[null,null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."},null,null,null,{"$f":"IF(G74=1,H70*F73,H67*F73)","v":864},null,null,null,{"$f":"-$M$75","v":-864},null,{"$f":"G75","v":864}]
[null,null,"Payroll taxes ",null,null,{"$f":"'1-Input Data'!D42","v":0.1},{"$f":"(G75+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc","v":44.839738187041661},null,null,null,{"$f":"-G76","v":-44.839738187041661}]
[]
[null,"Variable expenses"]
[]
[null,null,"Universal variable exp.",null,null,null,null,{"$f":"CalUnivVarPerCent","v":0.09}]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"PercentUnivPdByDr1","v":1},null,{"$f":"H80*G81","v":0.09},null,{"$f":"-I81*$H$67","v":-180}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G81","v":0},null,{"$f":"H80*G82","v":0},null,null,null,{"$f":"-I82*$H$67","v":0}]
[null,null,null,null,null,"         ",null,null,null,null,null,null,null,null," ",null," "]
[null,null,{"$f":"AssocName&\"'s Lab fees\"","v":"Irving Wannabe, D.M.D.'s Lab fees"},null,null,null,null,{"$f":"LabFees/AnnProd___All_Doctors","v":0.10219961935665034},null,null,null,null,null,null," ",null," "]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"PercentLabPdByDr1","v":0},null,{"$f":"H84*G85","v":0},null,{"$f":"-I85*$H$67","v":0}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G85","v":1},null,{"$f":"H84*G86","v":0.10219961935665034},null,null,null,{"$f":"-I86*$H$67","v":-204.39923871330069}]
[]
[]
[]
[]
[]
[]
[{"$f":"Formal_Practice_Name","v":"Rocky View Dental Care"}]
[{"$f":"\"Practice: \"&Doctor1","v":"Practice: John Righthinker, D.D.S."}]
["New Associate Analysis - MasterPlan Alliance Recomendations",null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-03-23T21:47:12.910"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Profit to",null,"Profit to"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Doctor1","v":"John Righthinker, D.D.S."},null,{"$f":"AssocName","v":"Irving Wannabe, D.M.D."}]
[]
[null,"Add'l. costs due to Associate:",null,null,null,null,null,"Monthly","Daily"]
[]
[null,null,"Addl. Front Desk Help"]
[null,null,{"$f":"\"Salary = \" &'1-Input Data'!D55&\" Hrs. * $\" &'1-Input Data'!D57&\" /hr. * \" &'1-Input Data'!D59&\" days/wk.  \"","v":"Salary = 8 Hrs. * $21 /hr. * 4 days/wk.  "},null,null,null,null,{"$f":"'1-Input Data'!D55*'1-Input Data'!D57*'1-Input Data'!D59*4.34","v":2916.48},{"$f":"H103/AssocStandardDaysperMo","v":168}]
[null,null,"  Payroll taxes & benefits",null,null,null,0.1,{"$f":"H111*G104","v":249.98400000000004},{"$f":"I103*G104","v":16.8}]
[null,null,"  Total",null,null,null,null,{"$f":"SUM(H103:H104)","v":3166.4639999999999},{"$f":"SUM(I103:I104)","v":184.8}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"PercentToSrDr","v":1},{"$f":"H105*G107","v":3166.4639999999999},{"$f":"I105*G107","v":184.8},null,{"$f":"-I107","v":-184.8}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G107","v":0},{"$f":"H105*G108","v":0},{"$f":"I105*G108","v":0},null,null,null,{"$f":"-I108","v":0}]
[]
[null,null,"Associate's Clinical Asst.:",null,null,null,null,"Monthly","Daily",null,null,null,null,null,null,null,{"$f":"DrPftMo","v":8512.4808117396205}]
[null,null,{"$f":"\"Salary = \" &'1-Input Data'!D65&\" Hrs. * $\" &'1-Input Data'!D67&\" /hr. * \" &'1-Input Data'!D69&\" days/wk. * \" &'1-Input Data'!D71& \" assistant(s)\"","v":"Salary = 8 Hrs. * $18 /hr. * 4 days/wk. * 1 assistant(s)"},null,null,null,null,{"$f":"'1-Input Data'!D65*'1-Input Data'!D67*AssociateClinicalAsst.*Number_of_Asst_needed.*4.34","v":2499.84},{"$f":"H111/AssocStandardDaysperMo","v":144},null,null,"Team Cost",null,"Team Cost",null,null,12]
[null,null,"  Payroll taxes & benefits",null,null,null,0.1,{"$f":"H111*G112","v":249.98400000000004},{"$f":"I111*G112","v":14.4},null,null,{"$f":"DrFrntDsk+DrClinAsst","v":-184.8},null,{"$f":"AssFrntDsk+AssClinAsst","v":-158.4}]
[null,null,"  Total",null,null,null,null,{"$f":"SUM(H111:H112)","v":2749.8240000000001},{"$f":"SUM(I111:I112)","v":158.4}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!$D$73","v":0},{"$f":"H113*G115","v":0},{"$f":"I113*G115","v":0},null,{"$f":"-I115","v":0}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G115","v":1},{"$f":"H113*G116","v":2749.8240000000001},{"$f":"I113*G116","v":158.4},null,null,null,{"$f":"-I116","v":-158.4}]
[]
[null,null,"Expense 1:",null,{"$f":"'1-Input Data'!$C$78","v":"Expense 1: Malpractice Insurance "},null,null,{"$f":"MalPracInsAnn/12","v":208.33333333333334},{"$f":"H118/AssocStandardDaysperMo","v":12.000768049155146}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!D80","v":0},{"$f":"H118*G120","v":0},{"$f":"I118*G120","v":0},null,{"$f":"-I120","v":0}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G120","v":1},{"$f":"H118*G121","v":208.33333333333334},{"$f":"I118*G121","v":12.000768049155146},null,null,null,{"$f":"-I121","v":-12.000768049155146}]
[]
[null,null,"Expense 2:",null,{"$f":"'1-Input Data'!$C$82","v":"Expense 2: Additional Operatory(ies)"},null,null,{"$f":"AddlOp/12","v":500},{"$f":"H123/AssocStandardDaysperMo","v":28.801843317972352}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!D84","v":1},{"$f":"H123*G125","v":500},{"$f":"I123*G125","v":28.801843317972352},null,{"$f":"-I125","v":-28.801843317972352}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G125","v":0},{"$f":"H123*G126","v":0},{"$f":"I123*G126","v":0},null,null,null,{"$f":"-I126","v":0}]
[]
[null,null,"Expense 3:",null,{"$f":"'1-Input Data'!$C$86","v":"Expense 3: Marketing "},null,null,{"$f":"'1-Input Data'!D86/12","v":1666.6666666666667},{"$f":"H128/AssocStandardDaysperMo","v":96.006144393241172}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!D88","v":1},{"$f":"H128*G130","v":1666.6666666666667},{"$f":"I128*G130","v":96.006144393241172},null,{"$f":"-I130","v":-96.006144393241172}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G130","v":0},{"$f":"H128*G131","v":0},{"$f":"I128*G131","v":0},null,null,null,{"$f":"-I131","v":0}]
[]
[null,null,"Expense 4:",null,{"$f":"'1-Input Data'!$C$90","v":"Expense 4: CE Expense"},null,null,{"$f":"C.E._Annually/12","v":416.66666666666669},{"$f":"H133/AssocStandardDaysperMo","v":24.001536098310293}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"PercentToSrDoctor_CE","v":0.5},{"$f":"H133*G135","v":208.33333333333334},{"$f":"I133*G135","v":12.000768049155146},null,{"$f":"-I135","v":-12.000768049155146}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G135","v":0.5},{"$f":"H133*G136","v":208.33333333333334},{"$f":"I133*G136","v":12.000768049155146},null,null,null,{"$f":"-I136","v":-12.000768049155146}]
[]
[null,null,"Expense 5:",null,{"$f":"'1-Input Data'!$C$94","v":"Expense 5: Equipment"},null,null,{"$f":"'1-Input Data'!$D$94/12","v":0},{"$f":"H138/AssocStandardDaysperMo","v":0}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!$D$96","v":0},{"$f":"H138*G140","v":0},{"$f":"I138*G140","v":0},null,{"$f":"-I140","v":0}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G140","v":1},{"$f":"H138*G141","v":0},{"$f":"I138*G141","v":0},null,null,null,{"$f":"-I141","v":0}]
[]
[null,null,"Expense 6:",null,{"$f":"'1-Input Data'!C98","v":"Moving Expense"},null,null,{"$f":"'1-Input Data'!$D$98/12","v":833.33333333333337},{"$f":"H143/AssocStandardDaysperMo","v":48.003072196620586}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!$D$100","v":0.4},{"$f":"H143*G145","v":333.33333333333337},{"$f":"I143*G145","v":19.201228878648237},null,{"$f":"-I145","v":-19.201228878648237}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G145","v":0.6},{"$f":"H143*G146","v":500},{"$f":"I143*G146","v":28.801843317972349},null,null,null,{"$f":"-I146","v":-28.801843317972349}]
[]
[null,null,"Expense 7:",null,{"$f":"'1-Input Data'!C102","v":"Expense 7: Optional Expense B"},null,null,{"$f":"'1-Input Data'!$D$102/12","v":0},{"$f":"H148/AssocStandardDaysperMo","v":0}]
[]
[null,null,null,{"$f":"\"% to \"&Doctor1","v":"% to John Righthinker, D.D.S."},null,null,{"$f":"'1-Input Data'!$D$104","v":0},{"$f":"H148*G150","v":0},{"$f":"I148*G150","v":0},null,{"$f":"-I150","v":0},{"$f":"SUM(K120:K150)","v":-156.00998463901692}]
[null,null,null,{"$f":"\"% to \"&AssocName","v":"% to Irving Wannabe, D.M.D."},null,null,{"$f":"1-G150","v":1},{"$f":"H148*G151","v":0},{"$f":"I148*G151","v":0},null,null,null,{"$f":"-I151","v":0},{"$f":"SUM(M121:M151)","v":-52.803379416282638}]
[]
[null,"HIDE ROWS",null,null,null,null,null,null,null,"SubTotal",{"$f":"DrExp7+DrExp6+DrExp5+DrExp4+DrExp3+DrExp2+DrExp1+DrClinAsst+DrFrntDsk+DrLabFeesAssoc+DrUniVar","v":-520.80998463901688},null,{"$f":"AssExp7+AssExp6+AssExp5+AssExp4+AssExp3+AssExp2+AssExp1+AssClinAsst+AssFrntDsk+AssLabFee+AssUniVar","v":-415.60261812958333}]
[null,"HIDE ROWS",null,null,null,null,null,null,null,"AssocCompTax",{"$f":"K75+PayRlTaxes","v":-908.83973818704169}]
[null,"HIDE ROWS",null,null,null,null,null,null,null,"ProdAftColl",{"$f":"K70","v":1920},"GrossComp",{"$f":"M75","v":864},null,null,null,{"$f":"IF(TrgtAssocProfit=0,0,(TrgtAssocProfit-HygNetProfit)/TrgtAssocProfit)","v":{"$error":"#REF!"}}]
[]
[null,null,"Net Profit per Standard Day - before Overhead Allocation",null,null,null,null,null,null,null,{"$f":"SUM(K153:K155)","v":490.35027717394132},null,{"$f":"SUM(M153:M155)","v":448.39738187041667}]
[]
[null,null,"Number of Standard Days per Month",null,null,null,null,null,null,"x",{"$f":"AssocStandardDaysperMo","v":17.36},"x",{"$f":"AssocStandardDaysperMo","v":17.36}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DrPftMo","v":8512.4808117396205}]
[null,null,"Net Profit per Month - before Overhead Allocation",null,null,null,null,null,null,null,{"$f":"K157*K159","v":8512.4808117396205},null,{"$f":"M157*M159","v":7784.178549270433},null,null,null,12]
[]
[]
[]
[null,"Overhead Allocated to Cost of Associate:",null,null,null,null,null,"Monthly","Daily"]
[null,null,null,null,null,null,null,null,{"$f":"AssocStandardDaysperMo","v":17.36}]
[null,null,"Other",null,null,null,null,0,{"$f":"H167/AssocStandardDaysperMo","v":0}]
[null,null,"XX"]
[null,null,"  Total",null,null,null,null,{"$f":"SUM(H167:H168)","v":0},{"$f":"SUM(I167:I168)","v":0}]
[]
[null,null,"% allocated to Associate:",null,null,null,{"$f":"Assoc1AllocTotal","v":0.21910112359550563},{"$f":"H169*G171","v":0},{"$f":"I169*G171","v":0}]
[]
[null,null,null,{"$f":"\"Paid by \"&Doctor1","v":"Paid by John Righthinker, D.D.S."},null,null,1,{"$f":"H171*G173","v":0},{"$f":"I171*G173","v":0},null,{"$f":"-I173","v":0}]
[null,null,null,{"$f":"\"Paid by \"&AssocName","v":"Paid by Irving Wannabe, D.M.D."},null,null,{"$f":"1-G173","v":0},{"$f":"H171*G174","v":0},{"$f":"I171*G174","v":0},null,null,null,{"$f":"-I174","v":0}]
[]
[null,null,"Net Profit per Standard Day - after Overhead Allocation",null,null,null,null,null,null,null,{"$f":"K157+K173","v":490.35027717394132},null,{"$f":"M157+M174","v":448.39738187041667}]
[]
[null,null,"Number of Standard Days per Month",null,null,null,null,null,null,"x",{"$f":"AssocStandardDaysperMo","v":17.36},"x",{"$f":"AssocStandardDaysperMo","v":17.36}]
[]
[null,null,"Net Profit per Month - after Overhead Allocation",null,null,null,null,null,null,null,{"$f":"K176*K178","v":8512.4808117396205},null,{"$f":"M176*M178","v":7784.178549270433}]
[null,null,null,null,null,null,null,null,null,null,"________",null,"________"]
[]
[]
[null,null,"Contribution after direct expenses per Day",null,null,null,null,null,null,null,{"$f":"$K$157","v":490.35027717394132},null,{"$f":"$M$157","v":448.39738187041667}]
[null,null,"Contribution after direct expenses per Month",null,null,null,null,null,null,null,{"$f":"$K$161","v":8512.4808117396205},null,{"$f":"$M$161","v":7784.178549270433}]
[null,null,"Contribution after direct expenses per Year",null,null,null,null,null,null,null,{"$f":"K185*12","v":102149.76974087545},null,{"$f":"M185*12","v":93410.142591245196}]
[null,null,"Overhead Contribution"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"Potential_Associate_Name&\"'s minimum required gross annual income\"","v":"Irving Wannabe, D.M.D.'s minimum required gross annual income"},null,null,null,{"$f":"'1-Input Data'!D49","v":83400}]
["Projected Treatment Days per Month",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M193>0,\"Surplus\",\"Shortfall\")","v":"Surplus"},{"$f":"ContribAssocYear-'1-Input Data'!D49","v":10010.142591245196}]
[]
[]
[null,null,null,"Op Hours",null,"Wks per",null,"Treatment",null,"Total",null,"Treat. Space Usage Ratios"]
[null,null,null,"per Week",null,"Month",null,"Hours per",null,"Standard",null,"All","Doctors","Assoc"]
[null,null,null,null,null,null,null,"Standard Day",null,"Days/Month",null,"Prod","Only","Only"]
[{"$f":"Doctor1","v":"John Righthinker, D.D.S."},null,null,39,null,4.34,null,{"$f":"+$J$14","v":0},null,0,null,{"$f":"D199/D205","v":0.21910112359550563},{"$f":"D199/D206","v":0.5},"N/A"]
["Dr. Second",null,null,0,null,4.34,null,{"$f":"+$J$14*2","v":0},null,{"$f":"D200*F200/H200","v":{"$error":"#DIV/0!"}},null,{"$f":"D200/D205","v":0},{"$f":"D200/D205","v":0},"N/A"]
["New Associate",null,null,39,null,4.34,null,{"$f":"+$J$14","v":0},null,{"$f":"AssocDaysWorkedPerWk*4.34","v":17.36},null,{"$f":"D201/D205","v":0.21910112359550563},{"$f":"D201/D206","v":0.5},{"$f":"D201/D207","v":1}]
["Dr. Assoc2",null,null,0,null,4.34,null,{"$f":"+$J$14","v":0},null,{"$f":"D202*F202/H202","v":{"$error":"#DIV/0!"}},null,{"$f":"D202/D205","v":0},{"$f":"D202/D206","v":0},{"$f":"D202/D207","v":0}]
["Hygiene",null,null,{"$f":"12.5*8","v":100},null,4.34,null,{"$f":"+$J$14","v":0},null,0,null,{"$f":"D203/D205","v":0.5617977528089888},"N/A","N/A"]
[null,null,null,"________",null,null,null,null,null,"________",null,"________","________","________"]
["Total",null,null,{"$f":"SUM(D199:D204)","v":178},null,null,null,null,null,{"$f":"SUM(J199:J204)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(L199:L204)","v":1},{"$f":"SUM(M199:M204)","v":1},{"$f":"SUM(N199:N204)","v":1}]
["Doctors Only",null,null,{"$f":"SUM(D199:D202)","v":78}]
["Assoc Only",null,null,{"$f":"SUM(D201:D202)","v":39}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!$I$118*CollperCent","v":1440},null,null,{"$f":"Q160*Q161","v":102149.76974087545},"Dr. Profit Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$74=1,'3-Assoc. Pay Chart'!$I$118*CollperCent*'3-Assoc. Pay Chart'!$C$139,'3-Assoc. Pay Chart'!$I$118*'3-Assoc. Pay Chart'!$C$139)","v":648.00000000000023}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SrDrVarCosts","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AddlCostAssoc","v":321.60875576036869}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DailyOverheadCosts","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,"Gross Practice Production",null,null,null,{"$f":"TotPracProd","v":1293504},null,".",null,null,null,null,null,null,null,null,null,null,null,"Associate's Net Take-Home Before Tax"]
[null,null,null,null,null,"Number of months",null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lab Fees",{"$f":"Z222*AssocLabExp*AssLabFees","v":102.19961935665035},112.41958129231537,122.63954322798041,132.85950516364545,143.07946709931048,153.2994290349755,163.51939097064053,173.73935290630558,183.95931484197061,194.17927677763564,204.39923871330069,214.61920064896572,224.83916258463074,235.05912452029577,245.27908645596082,255.49904839162585,265.7190103272909,275.93897226295593,286.15893419862095,296.37889613428598,306.59885806995101]
[null,null,null,null,null,"Variable Expenses ",null,null,null,"Annually",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Universal Costs",{"$f":"Z222*AssocUnivExp*VarCostsPerctUniversal","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Universal Variable Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Production Rate","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"Patient Billing Expenses",null,null,0,{"$f":"J222/NumberOfMonths","v":0},{"$f":"J222/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Per Day",1000,{"$f":"Z222+100","v":1100},1200,1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000]
[null,null,null,null,null,null,"Collection Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Cent",0.25,{"$f":"(IF(AssocPaidOn=1,Z$222*CollperCent*$Y223,Z$222*$Y223)-Z$219-Z$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":-73.402998772932989},-59.622960708598022,-45.842922644263069,-32.062884579928095,-18.282846515593128,-4.5028084512581543,9.2772296130768197,23.057267677411765,36.837305741746754,50.617343806081699,{"$f":"(IF(AssocPaidOn=1,AJ$222*CollperCent*$Y223,AJ$222*$Y223)-AJ$219-AJ$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":64.397381870416666},78.17741993475164,91.957457999086614,105.73749606342159,119.51753412775651,133.29757219209154,147.07761025642645,160.85764832076143,174.6376863850964,188.41772444943138,202.19776251376635]
[null,null,null,null,null,null,null,"Receivables Factoring",null,0,{"$f":"J224/NumberOfMonths","v":0},{"$f":"J224/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AssocPaidOn=1,\"of Coll.\",\"of Prod.\")","v":"of Coll."},{"$f":"Y223+0.01","v":0.26},-63.802998772932973,-49.062960708598013,-34.322922644263087,-19.582884579928084,-4.8428465155931306,9.8971915487418798,24.63722961307684,39.377267677411773,54.117305741746755,68.857343806081701,83.597381870416712,98.337419934751608,113.07745799908662,127.81749606342163,142.55753412775647,157.29757219209154,172.03761025642649,186.7776483207615,201.5176863850964,216.25772444943135,230.99776251376639]
[null,null,null,null,null,null,null,"Receivables Mgt Fees - Dent-A-Med",null,0,{"$f":"J225/NumberOfMonths","v":0},{"$f":"J225/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pd to",{"$f":"Y224+0.01","v":0.27},-54.202998772932943,-38.50296070859801,-22.802922644263056,-7.102884579928066,8.5971534844068671,24.297191548741864,39.997229613076861,55.697267677411851,71.397305741746834,87.09734380608171,102.79738187041676,118.49741993475169,134.19745799908662,149.89749606342167,165.59753412775655,181.29757219209154,196.99761025642653,212.69764832076143,228.39768638509636,244.09772444943135,259.79776251376637]
[null,null,null,null,null,null,null,"Small Claims Court & Legal/Coll. Fees",null,0,{"$f":"J226/NumberOfMonths","v":0},{"$f":"J226/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,"Assoc",0.28000000000000003,-44.602998772932978,-27.942960708598012,-11.282922644263017,5.3771154200719522,22.037153484406922,38.697191548741905,55.357229613076875,72.01726767741178,88.677305741746807,105.33734380608172,121.99738187041669,138.65741993475166,155.31745799908663,171.9774960634216,188.63753412775662,205.29757219209168,221.95761025642656,238.61764832076145,255.27768638509647,271.93772444943141,288.59776251376644]
[null,null,null,null,null,null,null,"  Total",null,{"$f":"SUM(J224:J226)","v":0},{"$f":"SUM(K224:K226)","v":0},{"$f":"SUM(L224:L226)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.29000000000000004,-35.002998772932955,-17.382960708598013,0.23707735573696453,17.85711542007197,35.477153484406934,53.097191548741883,70.717229613076881,88.33726767741183,105.95730574174678,123.57734380608173,141.19738187041673,158.81741993475174,176.43745799908663,194.05749606342164,211.67753412775662,229.29757219209162,246.91761025642657,264.53764832076143,282.1576863850965,299.77772444943145,317.39776251376639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30000000000000004,-25.402998772932936,-6.8229607085979538,11.757077355736946,30.337115420071939,48.917153484406931,67.49719154874191,86.077229613076895,104.65726767741188,123.23730574174687,141.81734380608174,160.39738187041678,178.97741993475171,197.55745799908675,216.13749606342168,234.71753412775652,253.29757219209162,271.87761025642652,290.45764832076151,309.03768638509649,327.61772444943148,346.19776251376646]
[null,null,null,null,null,null,"Dental Supplies",null,null,9.9999999999999995E-7,{"$f":"J229/NumberOfMonths","v":8.3333333333333325E-8},{"$f":"J229/TotPracProd","v":7.7309385977932804E-13},null,null,null,null,null,null,null,null,null,null,null,null,0.31000000000000005,-15.802998772932972,3.7370392914020485,23.277077355736992,42.817115420071964,62.357153484406986,81.897191548741944,101.43722961307691,120.97726767741182,140.51730574174684,160.05734380608175,179.59738187041671,199.13741993475179,218.6774579990867,238.21749606342169,257.75753412775663,277.29757219209165,296.83761025642656,316.37764832076158,335.9176863850966,355.45772444943162,374.99776251376653]
[null,null,null,null,null,null,"Merchant Discount Fees / Visa & MC",null,null,0,{"$f":"J230/NumberOfMonths","v":0},{"$f":"J230/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.32000000000000006,-6.2029987729329505,14.297039291402051,34.797077355737031,55.297115420071982,75.797153484406977,96.297191548741921,116.79722961307692,137.29726767741187,157.79730574174692,178.29734380608176,198.79738187041676,219.29741993475176,239.79745799908667,260.29749606342176,280.79753412775671,301.29757219209165,321.79761025642659,342.29764832076165,362.7976863850966,383.29772444943154,403.79776251376649]
[null,null,null,null,null,null,"Miscellaneous",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33000000000000007,3.3970012270670722,24.85703929140206,46.31707735573702,67.777115420071993,89.237153484406974,110.69719154874196,132.15722961307694,153.61726767741192,175.0773057417469,196.53734380608176,217.99738187041675,239.45741993475181,260.91745799908671,282.37749606342169,303.83753412775667,325.29757219209176,346.75761025642663,368.2176483207615,389.67768638509659,411.13772444943169,432.59776251376655]
[null,null,null,null,null,null,null,"Freight & Shipping",null,0,{"$f":"J232/NumberOfMonths","v":0},{"$f":"J232/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.34000000000000008,12.997001227067095,35.41703929140207,57.837077355737001,80.257115420072012,102.67715348440697,125.09719154874199,147.51722961307695,169.93726767741185,192.35730574174687,214.77734380608192,237.19738187041676,259.61741993475181,282.03745799908671,304.45749606342173,326.87753412775663,349.29757219209176,371.71761025642667,394.13764832076157,416.55768638509659,438.97772444943161,461.39776251376662]
[null,null,null,null,null,null,null,"Insurance Refunds",null,0,{"$f":"J233/NumberOfMonths","v":0},{"$f":"J233/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.35000000000000009,{"$f":"(IF(AssocPaidOn=1,Z$222*CollperCent*$Y233,Z$222*$Y233)-Z$219-Z$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":22.597001227067118},45.977039291402043,69.357077355737033,92.73711542007203,116.11715348440697,139.49719154874197,162.87722961307696,186.2572676774119,209.63730574174699,233.01734380608187,{"$f":"(IF(AssocPaidOn=1,AJ$222*CollperCent*$Y233,AJ$222*$Y233)-AJ$219-AJ$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":256.39738187041684},279.77741993475178,303.15745799908672,326.53749606342177,349.91753412775671,373.29757219209176,396.6776102564267,420.05764832076164,443.43768638509658,466.81772444943152,490.19776251376669]
[null,null,null,null,null,null,null,"New",null,0,{"$f":"J234/NumberOfMonths","v":0},{"$f":"J234/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.3600000000000001,32.197001227067091,56.537039291402102,80.877077355737072,105.21711542007205,129.55715348440702,153.89719154874194,178.23722961307698,202.57726767741195,226.91730574174693,251.25734380608188,275.59738187041677,299.93741993475186,324.27745799908683,348.61749606342181,372.95753412775679,397.29757219209176,421.63761025642674,445.97764832076172,470.31768638509669,494.65772444943178,518.99776251376659]
[null,null,null,null,null,null,null,"  Total",null,{"$f":"SUM(J231:J234)","v":0},{"$f":"SUM(K232:K234)","v":0},{"$f":"SUM(L232:L234)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.37000000000000011,41.797001227067121,67.097039291402155,92.397077355737053,117.69711542007201,142.99715348440702,168.29719154874203,193.59722961307699,218.89726767741189,244.19730574174687,269.49734380608191,294.79738187041681,320.09741993475183,345.39745799908695,370.69749606342185,395.99753412775675,421.29757219209176,446.59761025642666,471.89764832076185,497.1976863850968,522.49772444943187,547.79776251376677]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38000000000000012,51.397001227067172,77.6570392914021,103.91707735573704,130.17711542007203,156.43715348440702,182.69719154874201,208.95722961307703,235.21726767741191,261.47730574174699,287.73734380608192,313.99738187041697,340.25741993475191,366.51745799908684,392.77749606342189,419.03753412775671,445.29757219209176,471.55761025642676,497.81764832076175,524.07768638509674,550.33772444943179,576.59776251376672]
[null,null,null,null,null,null,"Office Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39000000000000012,60.997001227067081,88.217039291402159,115.43707735573707,142.65711542007205,169.87715348440707,197.09719154874199,224.31722961307702,251.53726767741196,278.75730574174696,305.97734380608193,333.19738187041679,360.41741993475188,387.63745799908696,414.85749606342182,442.07753412775679,469.29757219209188,496.51761025642685,523.73764832076176,550.95768638509685,578.17772444943193,605.39776251376668]
[null,null,null,null,null,null,null,"Miscellaneous",null,0,{"$f":"J238/NumberOfMonths","v":0},{"$f":"J238/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.40000000000000013,70.597001227067096,98.777039291402104,126.95707735573711,155.13711542007206,183.31715348440702,211.49719154874205,239.677229613077,267.85726767741193,296.03730574174705,324.21734380608194,352.39738187041684,380.57741993475196,408.75745799908685,436.93749606342186,465.11753412775687,493.29757219209199,521.47761025642683,549.65764832076184,577.83768638509673,606.01772444943185,634.19776251376686]
[null,null,null,null,null,null,null,"Other ",null,0,{"$f":"J239/NumberOfMonths","v":0},{"$f":"J239/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.41000000000000014,80.197001227067119,109.33703929140216,138.47707735573709,167.61711542007208,196.75715348440707,225.897191548742,255.03722961307702,284.17726767741198,313.31730574174702,342.45734380608195,371.59738187041688,400.73741993475193,429.87745799908697,459.0174960634219,488.15753412775695,517.29757219209193,546.43761025642686,575.57764832076168,604.71768638509684,633.857724449432,662.99776251376682]
[null,null,null,null,null,null,null,"  Total",null,{"$f":"SUM(J238:J239)","v":0},{"$f":"SUM(K238:K239)","v":0},{"$f":"SUM(L238:L239)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.42000000000000015,89.797001227067142,119.89703929140211,149.99707735573708,180.0971154200721,210.19715348440715,240.29719154874195,270.39722961307706,300.49726767741203,330.59730574174699,360.69734380608196,390.79738187041693,420.89741993475189,450.99745799908686,481.097496063422,511.19753412775691,541.29757219209193,571.3976102564269,601.49764832076175,631.59768638509695,661.69772444943192,691.79776251376677]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43000000000000016,99.397001227067165,130.45703929140217,161.51707735573711,192.57711542007212,223.63715348440707,254.69719154874204,285.75722961307707,316.81726767741196,347.87730574174708,378.93734380608197,409.99738187041697,441.05741993475198,472.11745799908704,503.1774960634221,534.23753412775693,565.29757219209205,596.35761025642694,627.41764832076183,658.47768638509683,689.53772444943183,720.59776251376695]
[null,null,null,null,null,null,"Parking--Patient",null,null,0,{"$f":"J242/NumberOfMonths","v":0},{"$f":"J242/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.44000000000000017,108.99700122706719,141.01703929140211,173.03707735573715,205.05711542007211,237.07715348440709,269.09719154874205,301.11722961307709,333.13726767741201,365.15730574174705,397.17734380608198,429.19738187041702,461.21741993475194,493.23745799908698,525.25749606342197,557.27753412775701,589.29757219209205,621.31761025642697,653.3376483207619,685.35768638509694,717.37772444943198,749.39776251376691]
[null,null,null,null,null,null,"Petty Cash",null,null,0,{"$f":"J243/NumberOfMonths","v":0},{"$f":"J243/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.45000000000000018,{"$f":"(IF(AssocPaidOn=1,Z$222*CollperCent*$Y243,Z$222*$Y243)-Z$219-Z$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":118.59700122706721},151.57703929140217,184.55707735573714,217.5371154200721,250.51715348440703,283.49719154874202,316.4772296130771,349.45726767741206,382.43730574174714,415.41734380608199,{"$f":"(IF(AssocPaidOn=1,AJ$222*CollperCent*$Y243,AJ$222*$Y243)-AJ$219-AJ$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":448.39738187041706},481.37741993475208,514.35745799908705,547.33749606342201,580.31753412775697,613.29757219209205,646.27761025642701,679.25764832076197,712.23768638509682,745.2177244494319,778.19776251376686]
[null,null,null,null,null,null,"Postage",null,null,0,{"$f":"J244/NumberOfMonths","v":0},{"$f":"J244/TotPracProd","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.46000000000000019,128.19700122706723,162.13703929140223,196.07707735573712,230.01711542007209,263.95715348440712,297.89719154874211,331.83722961307711,365.777267677412,399.71730574174711,433.657343806082,467.59738187041711,501.53741993475211,535.47745799908716,569.41749606342205,603.35753412775694,637.29757219209205,671.23761025642705,705.17764832076182,739.11768638509693,773.05772444943204,806.99776251376704]
[null,null,null,null,null,null,"Telephone",null,null,16890,{"$f":"J245/NumberOfMonths","v":1407.5},{"$f":"J245/TotPracProd","v":1.3057555291672851E-2},null,null,null,null,null,null,null,null,null,null,null,null,0.4700000000000002,137.79700122706714,172.69703929140218,207.59707735573724,242.49711542007211,277.39715348440717,312.29719154874209,347.19722961307713,382.09726767741205,416.99730574174708,451.89734380608201,486.79738187041704,521.69741993475213,556.59745799908706,591.49749606342209,626.39753412775713,661.29757219209205,696.19761025642708,731.09764832076189,765.99768638509704,800.89772444943196,835.79776251376688]
[null,null,null,null,null,null,"Subtotal:  Universal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4800000000000002,147.39700122706716,183.25703929140224,219.11707735573719,254.97711542007212,290.83715348440711,326.69719154874218,362.55722961307714,398.4172676774121,434.27730574174717,470.13734380608201,505.99738187041709,541.8574199347521,577.71745799908717,613.57749606342202,649.43753412775709,685.29757219209205,721.15761025642712,757.01764832076196,792.87768638509692,828.73772444943211,864.59776251376707]
[null,null,null,null,null,null,null,"Variable Expenses",null,{"$f":"J222+J227+J229+J230+J235+J240+J242+J243+J244+J245","v":16890.000001},{"$f":"K222+K227+K229+K230+K235+K240+K242+K243+K244+K245","v":1407.5000000833334},{"$f":"L222+L227+L229+L230+L235+L240+L242+L243+L244+L245","v":1.3057555292445944E-2},null,null,null,null,null,null,null,null,null,null,null,null,0.49000000000000021,156.99700122706719,193.8170392914023,230.63707735573715,267.45711542007206,304.27715348440717,341.09719154874227,377.91722961307715,414.73726767741204,451.55730574174714,488.37734380608225,525.19738187041708,562.01741993475207,598.83745799908729,635.65749606342217,672.47753412775705,709.29757219209205,746.11761025642693,782.93764832076204,819.75768638509703,856.57772444943203,893.39776251376725]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50000000000000022,166.59700122706721,204.37703929140227,242.15707735573713,279.93711542007208,317.71715348440722,355.49719154874214,393.27722961307717,431.05726767741209,468.83730574174712,506.61734380608226,544.39738187041712,582.17741993475215,619.95745799908718,657.7374960634221,695.51753412775702,733.29757219209205,771.07761025642696,808.85764832076211,846.63768638509714,884.41772444943217,922.19776251376697]
[null,null,null,null,null,"Variable Expenses, Dental Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51000000000000023,176.19700122706723,214.93703929140233,253.67707735573711,292.41711542007209,331.15715348440716,369.89719154874223,408.63722961307718,447.37726767741214,486.11730574174732,524.85734380608221,563.59738187041717,602.33741993475223,641.0774579990873,679.81749606342225,718.55753412775698,757.29757219209205,796.037610256427,834.77764832076195,873.51768638509702,912.25772444943209,950.99776251376716]
[null,null,null,null,null,null,"Lab Fees",null,null,{"$f":"LabFees","v":81890},{"$f":"J250/NumberOfMonths","v":6824.166666666667},{"$f":"IF(AnnProd___All_Doctors=0,0,J250/AnnProd___All_Doctors)","v":0.10219961935665034},null,null,null,null,null,null,null,null,null,null,null,null,0.52000000000000024,185.79700122706726,225.49703929140225,265.19707735573724,304.89711542007211,344.59715348440722,384.29719154874209,423.9972296130772,463.69726767741219,503.39730574174729,543.09734380608222,582.79738187041721,622.49741993475209,662.19745799908719,701.89749606342218,741.59753412775717,781.29757219209228,820.99761025642692,860.69764832076203,900.39768638509713,940.09772444943223,979.79776251376677]
[null,null,null,null,null,null,null,null,null,"________","________","________",null,null,null,null,null,null,null,null,null,null,null,null,0.53000000000000025,195.39700122706728,236.05703929140228,276.71707735573722,317.37711542007213,358.03715348440727,398.69719154874218,439.35722961307721,480.01726767741218,520.6773057417472,561.33734380608223,601.99738187041726,642.65741993475217,683.31745799908731,723.97749606342211,764.63753412775714,805.29757219209228,845.95761025642696,886.6176483207621,927.27768638509724,967.93772444943215,1008.597762513767]
[null,null,null,null,null,null,"Total Variable Expenses",null,null,{"$f":"J247+J250","v":98780.000001000008},{"$f":"K247+K250","v":8231.6666667499994},{"$f":"L247+L250","v":0.11525717464909628},null,null,null,null,null,null,null,null,null,null,null,null,0.54000000000000026,204.99700122706722,246.61703929140222,288.2370773557372,329.85711542007215,371.47715348440721,413.09719154874227,454.71722961307722,496.33726767741229,537.95730574174729,579.57734380608224,621.19738187041708,662.81741993475225,704.4374579990872,746.05749606342226,787.6775341277571,829.29757219209228,870.917610256427,912.53764832076217,954.15768638509712,995.77772444943218,1037.3977625137672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000027,{"$f":"(IF(AssocPaidOn=1,Z$222*CollperCent*$Y253,Z$222*$Y253)-Z$219-Z$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":214.59700122706724},257.17703929140231,299.75707735573729,342.33711542007217,384.91715348440727,427.49719154874214,470.07722961307724,512.65726767741228,555.23730574174726,597.81734380608225,{"$f":"(IF(AssocPaidOn=1,AJ$222*CollperCent*$Y253,AJ$222*$Y253)-AJ$219-AJ$220+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)","v":640.39738187041712},682.97741993475233,725.55745799908732,768.13749606342219,810.71753412775729,853.29757219209228,895.87761025642703,938.45764832076202,981.03768638509712,1023.6177244494321,1066.197762513767]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000028,224.19700122706723,267.73703929140225,311.27707735573728,354.81711542007218,398.35715348440721,441.89719154874223,485.43722961307736,528.97726767741221,572.51730574174735,616.05734380608226,659.59738187041717,703.13741993475219,746.67745799908721,790.21749606342235,833.75753412775725,877.29757219209228,920.83761025642707,964.37764832076209,1007.917686385097,1051.4577244494324,1094.9977625137672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57000000000000028,233.79700122706723,278.29703929140231,322.79707735573726,367.2971154200722,411.79715348440726,456.29719154874232,500.79722961307738,545.29726767741226,589.79730574174732,634.29734380608227,678.79738187041721,723.29741993475227,767.79745799908733,812.29749606342227,856.79753412775722,901.29757219209228,945.79761025642711,990.29764832076205,1034.7976863850972,1079.2977244494323,1123.7977625137673]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.58000000000000029,243.39700122706725,288.85703929140237,334.31707735573724,379.77711542007222,425.23715348440732,470.69719154874218,516.15722961307733,561.61726767741231,607.0773057417473,652.53734380608228,697.99738187041726,743.45741993475235,788.91745799908745,834.37749606342231,879.83753412775718,925.29757219209228,970.75761025642714,1016.2176483207621,1061.6776863850973,1107.1377244494322,1152.5977625137671]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5900000000000003,252.99700122706727,299.41703929140232,345.83707735573722,392.25711542007224,438.67715348440726,485.09719154874239,531.51722961307735,577.93726767741225,624.35730574174738,670.77734380608229,717.1973818704173,763.61741993475221,810.03745799908734,856.45749606342224,902.87753412775714,949.29757219209228,995.71761025642706,1042.1376483207623,1088.5576863850972,1134.9777244494323,1181.3977625137672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.60000000000000031,262.59700122706732,309.97703929140238,357.35707735573732,404.73711542007226,452.11715348440731,499.49719154874248,546.87722961307736,594.2572676774123,641.63730574174747,689.01734380608229,736.39738187041735,783.77741993475229,831.15745799908746,878.53749606342217,925.91753412775734,973.29757219209216,1020.6776102564271,1068.0576483207622,1115.4376863850973,1162.8177244494323,1210.1977625137674]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61000000000000032,272.19700122706735,320.53703929140232,368.8770773557373,417.21711542007228,465.55715348440725,513.89719154874228,562.23722961307737,610.57726767741235,658.91730574174744,707.2573438060823,755.59738187041739,803.93741993475237,852.27745799908735,900.61749606342255,948.9575341277573,997.29757219209216,1045.6376102564273,1093.9776483207622,1142.3176863850972,1190.6577244494324,1238.9977625137672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62000000000000033,281.79700122706726,331.09703929140238,380.39707735573728,429.69711542007229,478.99715348440736,528.29719154874238,577.59722961307739,626.89726767741229,676.19730574174741,725.49734380608231,774.79738187041721,824.09741993475245,873.39745799908746,922.69749606342248,971.99753412775715,1021.2975721920922,1070.5976102564273,1119.8976483207623,1169.1976863850973,1218.4977244494323,1267.7977625137673]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63000000000000034,291.39700122706728,341.65703929140233,391.91707735573738,442.17711542007231,492.43715348440747,542.69719154874247,592.9572296130774,643.21726767741234,693.47730574174739,743.73734380608232,793.99738187041726,844.25741993475231,894.51745799908736,944.7774960634224,995.03753412775734,1045.2975721920925,1095.5576102564273,1145.8176483207624,1196.0776863850974,1246.3377244494325,1296.5977625137675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64000000000000035,300.9970012270673,352.21703929140239,403.43707735573736,454.65711542007233,505.87715348440742,557.09719154874233,608.31722961307742,659.53726767741227,710.75730574174736,761.97734380608233,813.1973818704173,864.41741993475239,915.63745799908747,966.85749606342233,1018.0775341277573,1069.2975721920925,1120.5176102564274,1171.7376483207622,1222.9576863850973,1274.1777244494324,1325.3977625137672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65000000000000036,310.59700122706732,362.77703929140233,414.95707735573734,467.13711542007235,519.31715348440741,571.49719154874242,623.67722961307743,675.85726767741244,728.03730574174756,780.21734380608234,832.39738187041735,884.57741993475247,936.75745799908736,988.93749606342215,1041.1175341277574,1093.2975721920925,1145.4776102564274,1197.6576483207623,1249.8376863850974,1302.0177244494325,1354.1977625137674]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sr. Doctor's Net Profit Before Overhead Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lab Fees",{"$f":"Z$272*SrDocLabExp*DrsLabFeePct","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Universal Costs",{"$f":"Z$272*SrDocUnivExp*VarCostsPerctUniversal","v":90},99,108,117,126,135,144,153,162,171,180,189,198,207,216,225,234,243,252,261,270]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Production Rate","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Day",{"$f":"1000","v":1000},{"$f":"Z272+100","v":1100},{"$f":"AA272+100","v":1200},1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Cent",0.25,{"$f":"(Z$272*CollperCent)-IF(AssocPaidOn=1,Z$272*CollperCent*$Y273,Z$272*$Y273)-((IF(AssocPaidOn=1,Z$272*CollperCent*$Y273,Z$272*$Y273)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-Z$269-Z$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":306.75027717394136},367.35027717394132,427.9502771739414,488.55027717394137,549.1502771739415,609.75027717394141,670.35027717394155,730.95027717394146,791.55027717394137,852.1502771739415,{"$f":"(AJ$272*CollperCent)-IF(AssocPaidOn=1,AJ$272*CollperCent*$Y273,AJ$272*$Y273)-((IF(AssocPaidOn=1,AJ$272*CollperCent*$Y273,AJ$272*$Y273)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-AJ$269-AJ$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":912.75027717394164},973.35027717394178,1033.9502771739417,1094.5502771739416,1155.1502771739417,1215.7502771739416,1276.3502771739418,1336.9502771739417,1397.5502771739416,1458.1502771739417,1518.7502771739416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('2-New Assoc. Analysis'!$H$37=1,\"of Coll.\",\"of Prod.\")","v":"of Coll."},{"$f":"Y273+0.01","v":0.26},296.19027717394141,355.73427717394151,415.27827717394138,474.82227717394125,534.3662771739414,593.91027717394127,653.45427717394136,712.99827717394146,772.54227717394156,832.08627717394143,891.63027717394152,951.17427717394185,1010.7182771739417,1070.2622771739418,1129.8062771739417,1189.3502771739418,1248.8942771739416,1308.4382771739415,1367.9822771739416,1427.5262771739415,1487.0702771739413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paid to",{"$f":"Y274+0.01","v":0.27},285.63027717394135,344.11827717394141,402.60627717394135,461.09427717394141,519.58227717394152,578.07027717394158,636.55827717394141,695.04627717394146,753.53427717394152,812.02227717394135,870.5102771739414,928.99827717394146,987.48627717394174,1045.9742771739416,1104.4622771739419,1162.9502771739417,1221.4382771739415,1279.9262771739416,1338.4142771739416,1396.9022771739417,1455.390277173942]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assoc.",0.28000000000000003,275.07027717394141,332.50227717394131,389.93427717394133,447.36627717394134,504.79827717394147,562.23027717394143,619.66227717394145,677.09427717394146,734.52627717394125,791.9582771739415,849.39027717394151,906.82227717394176,964.25427717394155,1021.6862771739418,1079.1182771739416,1136.5502771739416,1193.9822771739416,1251.4142771739414,1308.8462771739416,1366.2782771739417,1423.7102771739417]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29000000000000004,264.51027717394135,320.88627717394144,377.26227717394136,433.63827717394128,490.01427717394131,546.39027717394129,602.76627717394149,659.14227717394124,715.51827717394144,771.89427717394142,828.27027717394117,884.64627717394137,941.02227717394157,997.39827717394155,1053.7742771739415,1110.1502771739417,1166.5262771739415,1222.9022771739417,1279.2782771739417,1335.6542771739416,1392.0302771739416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30000000000000004,253.9502771739414,309.27027717394134,364.59027717394133,419.91027717394121,475.23027717394137,530.55027717394137,585.8702771739413,641.19027717394124,696.5102771739414,751.83027717394134,807.1502771739415,862.47027717394121,917.7902771739416,973.11027717394154,1028.4302771739417,1083.7502771739416,1139.0702771739416,1194.3902771739415,1249.7102771739417,1305.0302771739414,1360.3502771739415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31000000000000005,243.39027717394134,297.65427717394124,351.91827717394125,406.18227717394115,460.44627717394127,514.71027717394122,568.97427717394135,623.23827717394147,677.50227717394137,731.76627717394149,786.03027717394139,840.29427717394151,894.55827717394118,948.82227717394176,1003.0862771739414,1057.3502771739418,1111.6142771739414,1165.8782771739418,1220.1422771739415,1274.4062771739416,1328.6702771739415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32000000000000006,232.83027717394143,286.03827717394137,339.24627717394134,392.45427717394131,445.66227717394116,498.87027717394136,552.07827717394139,605.28627717394124,658.49427717394133,711.70227717394141,764.91027717394127,818.11827717394135,871.32627717394121,924.53427717394152,977.74227717394137,1030.9502771739417,1084.1582771739413,1137.3662771739416,1190.5742771739413,1243.7822771739416,1296.9902771739414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33000000000000007,222.27027717394137,274.42227717394138,326.57427717394131,378.7262771739413,430.87827717394129,483.03027717394139,535.1822771739412,587.33427717394125,639.48627717394129,691.63827717394133,743.79027717394138,795.94227717394119,848.09427717394146,900.24627717394151,952.39827717394155,1004.5502771739414,1056.7022771739414,1108.8542771739415,1161.0062771739415,1213.1582771739413,1265.3102771739416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34000000000000008,211.71027717394131,262.80627717394128,313.90227717394129,364.99827717394123,416.09427717394141,467.19027717394118,518.28627717394124,569.38227717394125,620.47827717394148,671.57427717394103,722.67027717394126,773.76627717394149,824.86227717394127,875.95827717394127,927.0542771739415,978.1502771739415,1029.2462771739413,1080.3422771739415,1131.4382771739415,1182.5342771739415,1233.6302771739413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35000000000000009,{"$f":"(Z$272*CollperCent)-IF(AssocPaidOn=1,Z$272*CollperCent*$Y283,Z$272*$Y283)-((IF(AssocPaidOn=1,Z$272*CollperCent*$Y283,Z$272*$Y283)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-Z$269-Z$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":201.15027717394125},251.1902771739413,301.23027717394137,351.27027717394122,401.3102771739413,451.35027717394127,501.39027717394134,551.43027717394125,601.47027717394121,651.5102771739414,{"$f":"(AJ$272*CollperCent)-IF(AssocPaidOn=1,AJ$272*CollperCent*$Y283,AJ$272*$Y283)-((IF(AssocPaidOn=1,AJ$272*CollperCent*$Y283,AJ$272*$Y283)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-AJ$269-AJ$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":701.55027717394114},751.59027717394133,801.63027717394107,851.67027717394126,901.71027717394168,951.75027717394141,1001.7902771739414,1051.8302771739413,1101.8702771739415,1151.9102771739415,1201.9502771739415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3600000000000001,190.5902771739413,239.57427717394131,288.55827717394124,337.54227717394116,386.5262771739412,435.51027717394135,484.49427717394133,533.47827717394125,582.4622771739414,631.4462771739411,680.43027717394125,729.41427717394117,778.39827717394132,827.38227717394125,876.36627717394117,925.35027717394155,974.33427717394125,1023.3182771739414,1072.3022771739413,1121.2862771739415,1170.2702771739414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37000000000000011,180.03027717394136,227.95827717394124,275.88627717394132,323.81427717394132,371.74227717394115,419.6702771739412,467.59827717394109,515.52627717394125,563.45427717394136,611.38227717394125,659.31027717394136,707.23827717394147,755.16627717394113,803.09427717394124,851.02227717394112,898.95027717394146,946.87827717394134,994.80627717394123,1042.7342771739413,1090.6622771739412,1138.5902771739413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38000000000000012,169.47027717394118,216.34227717394126,263.2142771739413,310.08627717394126,356.95827717394127,403.83027717394128,450.70227717394113,497.57427717394131,544.4462771739411,591.31827717394117,638.19027717394101,685.06227717394108,731.93427717394093,778.806277173941,825.6782771739413,872.55027717394114,919.42227717394144,966.29427717394151,1013.1662771739414,1060.0382771739414,1106.9102771739413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39000000000000012,158.91027717394135,204.72627717394127,250.54227717394116,296.3582771739413,342.17427717394122,387.99027717394114,433.80627717394117,479.62227717394097,525.43827717394129,571.25427717394132,617.07027717394135,662.88627717394115,708.70227717394118,754.51827717394099,800.33427717394102,846.15027717394105,891.96627717394108,937.78227717394134,983.59827717394114,1029.4142771739412,1075.2302771739414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.40000000000000013,148.35027717394129,193.11027717394128,237.87027717394125,282.63027717394124,327.39027717394123,372.15027717394105,416.91027717394121,461.6702771739412,506.43027717394108,551.19027717394101,595.95027717394123,640.71027717394099,685.47027717394121,730.2302771739412,774.99027717394097,819.75027717394096,864.51027717394118,909.27027717394117,954.03027717394139,998.79027717394138,1043.5502771739411]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41000000000000014,137.79027717394123,181.4942771739413,225.19827717394125,268.90227717394117,312.60627717394124,356.31027717394113,400.01427717394103,443.7182771739412,487.42227717394121,531.12627717394139,574.83027717394111,618.53427717394106,662.23827717394124,705.94227717394119,749.64627717394114,793.35027717394087,837.05427717394105,880.75827717394122,924.46227717394117,968.16627717394113,1011.8702771739413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42000000000000015,127.23027717394129,169.8782771739412,212.52627717394122,255.17427717394122,297.82227717394113,340.47027717394116,383.11827717394112,425.76627717394098,468.41427717394112,511.06227717394114,553.71027717394099,596.35827717394113,639.00627717394104,681.65427717394095,724.30227717394109,766.950277173941,809.59827717394091,852.24627717394105,894.89427717394096,937.5422771739411,980.19027717394124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43000000000000016,116.67027717394123,158.26227717394121,199.85427717394131,241.44627717394116,283.03827717394114,324.63027717394112,366.22227717394117,407.81427717394121,449.40627717394108,490.99827717394123,532.5902771739411,574.1822771739412,615.77427717394107,657.36627717394094,698.95827717394104,740.55027717394091,782.14227717394101,823.73427717394111,865.32627717394098,906.91827717394131,948.51027717394118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44000000000000017,106.11027717394128,146.64627717394134,187.18227717394117,227.71827717394123,268.25427717394115,308.79027717394109,349.32627717394115,389.86227717394098,430.39827717394104,470.9342771739411,511.47027717394127,552.00627717394104,592.54227717394133,633.07827717394093,673.61427717394099,714.15027717394105,754.68627717394088,795.22227717394094,835.758277173941,876.29427717394083,916.83027717394111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45000000000000018,{"$f":"(Z$272*CollperCent)-IF(AssocPaidOn=1,Z$272*CollperCent*$Y293,Z$272*$Y293)-((IF(AssocPaidOn=1,Z$272*CollperCent*$Y293,Z$272*$Y293)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-Z$269-Z$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":95.550277173941211},135.03027717394124,174.51027717394115,213.99027717394117,253.47027717394116,292.95027717394117,332.43027717394108,371.91027717394104,411.390277173941,450.87027717394102,{"$f":"(AJ$272*CollperCent)-IF(AssocPaidOn=1,AJ$272*CollperCent*$Y293,AJ$272*$Y293)-((IF(AssocPaidOn=1,AJ$272*CollperCent*$Y293,AJ$272*$Y293)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-AJ$269-AJ$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":490.35027717394087},529.83027717394111,569.31027717394113,608.79027717394115,648.27027717394094,687.75027717394096,727.23027717394098,766.71027717394077,806.19027717394101,845.67027717394103,885.15027717394105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46000000000000019,84.990277173941266,123.41427717394114,161.83827717394124,200.2622771739411,238.68627717394116,277.11027717394103,315.53427717394112,353.9582771739411,392.38227717394096,430.80627717394094,469.23027717394092,507.65427717394101,546.07827717394093,584.50227717394114,622.92627717394112,661.35027717394087,699.77427717394085,738.19827717394105,776.62227717394103,815.04627717394078,853.47027717394076]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4700000000000002,74.430277173941263,111.79827717394127,149.1662771739411,186.53427717394115,223.90227717394109,261.27027717394111,298.63827717394105,336.0062771739411,373.37427717394098,410.74227717394109,448.11027717394103,485.47827717394102,522.84627717394096,560.2142771739409,597.58227717394084,634.950277173941,672.31827717394071,709.68627717394088,747.05427717394082,784.42227717394098,821.79027717394092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4800000000000002,63.870277173941204,100.18227717394117,136.49427717394119,172.80627717394108,209.11827717394121,245.43027717394108,281.74227717394109,318.05427717394099,354.366277173941,390.67827717394101,426.99027717394091,463.30227717394104,499.61427717394105,535.92627717394112,572.23827717394079,608.55027717394091,644.86227717394081,681.17427717394094,717.48627717394083,753.79827717394073,790.11027717394086]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49000000000000021,53.310277173941202,88.56627717394106,123.82227717394116,159.07827717394125,194.3342771739411,229.59027717394108,264.84627717394102,300.1022771739411,335.35827717394096,370.61427717394099,405.87027717394079,441.12627717394088,476.38227717394074,511.63827717394093,546.89427717394096,582.15027717394105,617.40627717394091,652.66227717394077,687.91827717394085,723.17427717394094,758.43027717394057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50000000000000022,42.750277173941136,76.950277173941188,111.15027717394113,145.35027717394118,179.55027717394111,213.75027717394104,247.95027717394106,282.15027717394099,316.35027717394104,350.55027717394086,384.75027717394096,418.95027717394095,453.15027717394076,487.35027717394087,521.55027717394091,555.75027717394096,589.950277173941,624.15027717394059,658.35027717394064,692.55027717394069,726.75027717394073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51000000000000023,32.190277173941134,65.334277173941089,98.478277173941223,131.62227717394111,164.76627717394112,197.91027717394113,231.05427717394102,264.19827717394099,297.34227717394089,330.48627717394089,363.63027717394084,396.77427717394079,429.91827717394079,463.06227717394057,496.20627717394115,529.35027717394087,562.49427717394087,595.63827717394088,628.78227717394088,661.92627717394089,695.07027717394067]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52000000000000024,21.630277173941188,53.718277173941161,85.806277173941069,117.89427717394116,149.98227717394101,182.07027717394109,214.15827717394106,246.24627717394088,278.33427717394096,310.42227717394093,342.51027717394089,374.59827717394091,406.68627717394082,438.77427717394079,470.86227717394075,502.95027717394083,535.03827717394097,567.12627717394071,599.21427717394067,631.30227717394064,663.39027717394083]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53000000000000025,11.070277173941129,42.102277173941111,73.134277173941157,104.1662771739411,135.19827717394102,166.23027717394095,197.26227717394099,228.29427717394103,259.32627717394092,290.35827717394085,321.39027717394089,352.42227717394093,383.45427717394068,414.48627717394078,445.5182771739407,476.55027717394063,507.58227717394089,538.61427717394076,569.64627717394069,600.67827717394084,631.71027717394054]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54000000000000026,0.51027717394118355,30.486277173941126,60.462277173941132,90.438277173941131,120.41427717394103,150.39027717394103,180.36627717394103,210.34227717394091,240.31827717394088,270.29427717394088,300.270277173941,330.24627717394077,360.22227717394094,390.19827717394077,420.17427717394065,450.15027717394054,480.12627717394065,510.10227717394065,540.07827717394071,570.05427717394059,600.0302771739407]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000027,{"$f":"(Z$272*CollperCent)-IF(AssocPaidOn=1,Z$272*CollperCent*$Y303,Z$272*$Y303)-((IF(AssocPaidOn=1,Z$272*CollperCent*$Y303,Z$272*$Y303)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-Z$269-Z$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":-10.049722826058817},18.870277173941084,47.790277173940993,76.710277173941066,105.63027717394104,134.550277173941,163.47027717394096,192.39027717394092,221.31027717394099,250.23027717394081,{"$f":"(AJ$272*CollperCent)-IF(AssocPaidOn=1,AJ$272*CollperCent*$Y303,AJ$272*$Y303)-((IF(AssocPaidOn=1,AJ$272*CollperCent*$Y303,AJ$272*$Y303)+AssLabFee+AssFrntDsk+AssClinAsst+AssExp1+AssExp2+AssExp3+AssExp4+AssExp5+AssExp6+AssExp7)*PayrollTaxAssoc)-AJ$269-AJ$270+DrFrntDsk+DrClinAsst+DrExp1+DrExp2+DrExp3+DrExp4+DrExp5+DrExp6+DrExp7","v":279.15027717394088},308.07027717394072,336.9902771739408,365.91027717394081,394.8302771739406,423.75027717394067,452.67027717394075,481.59027717394088,510.51027717394078,539.43027717394057,568.35027717394064]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000028,-20.609722826058878,7.2542771739411549,35.118277173941017,62.982277173941,90.846277173941033,118.71027717394097,146.574277173941,174.43827717394092,202.30227717394084,230.16627717394087,258.03027717394087,285.89427717394091,313.75827717394083,341.62227717394063,369.48627717394061,397.35027717394058,425.21427717394062,453.07827717394065,480.94227717394074,508.8062771739406,536.67027717394058]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57000000000000028,-31.16972282605888,-4.3617228260589425,22.446277173941048,49.254277173941048,76.062277173941041,102.87027717394093,129.67827717394093,156.48627717394092,183.29427717394091,210.10227717394091,236.91027717394076,263.71827717394075,290.52627717394074,317.33427717394073,344.14227717394073,370.95027717394055,397.75827717394048,424.56627717394048,451.37427717394047,478.18227717394046,504.99027717394057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.58000000000000029,-41.729722826058939,-15.977722826058985,9.7742771739410799,35.526277173940976,61.278277173940936,87.030277173941002,112.78227717394097,138.53427717394081,164.28627717394087,190.03827717394083,215.79027717394078,241.5422771739407,267.29427717394054,293.04627717394072,318.79827717394068,344.55027717394063,370.30227717394064,396.05427717394053,421.80627717394049,447.55827717394067,473.31027717394062]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5900000000000003,-52.289722826058942,-27.593722826058915,-2.8977228260588888,21.798277173940967,46.494277173940944,71.190277173940856,95.886277173940883,120.58227717394092,145.27827717394084,169.97427717394086,194.67027717394078,219.36627717394092,244.06227717394069,268.7582771739406,293.45427717394074,318.15027717394065,342.84627717394056,367.54227717394042,392.2382771739405,416.93427717394042,441.63027717394033]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.60000000000000031,-62.849722826058944,-39.209722826059014,-15.569722826059026,8.0702771739409584,31.710277173940945,55.350277173940938,78.990277173940925,102.63027717394093,126.27027717394068,149.91027717394078,173.55027717394066,197.19027717394076,220.83027717394063,244.4702771739407,268.11027717394057,291.75027717394067,315.39027717394055,339.03027717394065,362.67027717394035,386.31027717394039,409.95027717394026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61000000000000032,-73.40972282605901,-50.825722826058943,-28.241722826058997,-5.6577228260590484,16.92627717394101,39.510277173940899,62.094277173940853,84.678277173940799,107.26227717394076,129.84627717394082,152.43027717394065,175.01427717394071,197.59827717394077,220.18227717394049,242.76627717394064,265.35027717394058,287.93427717394042,310.51827717394048,333.10227717394054,355.68627717394037,378.27027717394049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y309+0.01","v":0.62000000000000033},-83.969722826058884,-62.441722826058985,-40.913722826058965,-19.385722826059059,2.1422771739409612,23.670277173940811,45.198277173940895,66.726277173940915,88.254277173940821,109.78227717394086,131.31027717394088,152.83827717394055,174.36627717394057,195.89427717394059,217.42227717394073,238.95027717394061,260.4782771739404,282.00627717394042,303.53427717394044,325.06227717394046,346.59027717394025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63000000000000034,-94.529722826058887,-74.057722826058921,-53.585722826059104,-33.113722826059124,-12.641722826059143,7.8302771739408357,28.302277173940816,48.774277173940803,69.246277173940783,89.718277173940763,110.19027717394076,130.66227717394074,151.13427717394072,171.6062771739407,192.07827717394045,212.55027717394043,233.02227717394041,253.49427717394036,273.96627717394034,294.43827717394032,314.9102771739403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64000000000000035,-105.08972282605895,-85.673722826059006,-66.25772282605908,-46.841722826059133,-27.425722826059079,-8.0097228260591375,11.406277173940801,30.822277173940911,50.238277173940858,69.654277173940798,89.070277173940738,108.48627717394069,127.90227717394063,147.31827717394057,166.73427717394051,186.15027717394045,205.56627717394039,224.98227717394056,244.39827717394047,263.81427717394041,283.23027717394035]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y312+0.01","v":0.65000000000000036},-115.64972282605895,-97.289722826058934,-78.929722826059049,-60.569722826059142,-42.209722826059128,-23.849722826059114,-5.4897228260592126,12.870277173940686,31.230277173940586,49.59027717394072,67.95027717394062,86.31027717394052,104.67027717394078,123.03027717394068,141.39027717394058,159.75027717394047,178.11027717394037,196.4702771739405,214.8302771739404,233.1902771739403,251.5502771739404]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Associate's Net Take-Home Before Tax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!D11","v":1000},{"$f":"'3-Assoc. Pay Chart'!E11","v":1100},{"$f":"'3-Assoc. Pay Chart'!F11","v":1200},{"$f":"'3-Assoc. Pay Chart'!G11","v":1300},{"$f":"'3-Assoc. Pay Chart'!H11","v":1400},{"$f":"'3-Assoc. Pay Chart'!I11","v":1500},{"$f":"'3-Assoc. Pay Chart'!J11","v":1600},{"$f":"'3-Assoc. Pay Chart'!K11","v":1700},{"$f":"'3-Assoc. Pay Chart'!L11","v":1800},{"$f":"'3-Assoc. Pay Chart'!M11","v":1900},{"$f":"'3-Assoc. Pay Chart'!N11","v":2000},{"$f":"'3-Assoc. Pay Chart'!O11","v":2100},{"$f":"'3-Assoc. Pay Chart'!P11","v":2200},{"$f":"'3-Assoc. Pay Chart'!Q11","v":2300},{"$f":"'3-Assoc. Pay Chart'!R11","v":2400},{"$f":"'3-Assoc. Pay Chart'!S11","v":2500},{"$f":"'3-Assoc. Pay Chart'!T11","v":2600},{"$f":"'3-Assoc. Pay Chart'!U11","v":2700},{"$f":"'3-Assoc. Pay Chart'!V11","v":2800},{"$f":"'3-Assoc. Pay Chart'!W11","v":2900},{"$f":"'3-Assoc. Pay Chart'!X11","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C27-0.00001","v":0.39999000000000012},{"$f":"'3-Assoc. Pay Chart'!D27","v":70.597001227067096},{"$f":"'3-Assoc. Pay Chart'!E27","v":98.777039291402104},{"$f":"'3-Assoc. Pay Chart'!F27","v":126.95707735573711},{"$f":"'3-Assoc. Pay Chart'!G27","v":155.13711542007206},{"$f":"'3-Assoc. Pay Chart'!H27","v":183.31715348440702},{"$f":"'3-Assoc. Pay Chart'!I27","v":211.49719154874205},{"$f":"'3-Assoc. Pay Chart'!J27","v":239.677229613077},{"$f":"'3-Assoc. Pay Chart'!K27","v":267.85726767741193},{"$f":"'3-Assoc. Pay Chart'!L27","v":296.03730574174705},{"$f":"'3-Assoc. Pay Chart'!M27","v":324.21734380608194},{"$f":"'3-Assoc. Pay Chart'!N27","v":352.39738187041684},{"$f":"'3-Assoc. Pay Chart'!O27","v":380.57741993475196},{"$f":"'3-Assoc. Pay Chart'!P27","v":408.75745799908685},{"$f":"'3-Assoc. Pay Chart'!Q27","v":436.93749606342186},{"$f":"'3-Assoc. Pay Chart'!R27","v":465.11753412775687},{"$f":"'3-Assoc. Pay Chart'!S27","v":493.29757219209199},{"$f":"'3-Assoc. Pay Chart'!T27","v":521.47761025642683},{"$f":"'3-Assoc. Pay Chart'!U27","v":549.65764832076184},{"$f":"'3-Assoc. Pay Chart'!V27","v":577.83768638509673},{"$f":"'3-Assoc. Pay Chart'!W27","v":606.01772444943185},{"$f":"'3-Assoc. Pay Chart'!X27","v":634.19776251376686}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C28-0.00001","v":0.40999000000000013},{"$f":"'3-Assoc. Pay Chart'!D28","v":80.197001227067119},{"$f":"'3-Assoc. Pay Chart'!E28","v":109.33703929140216},{"$f":"'3-Assoc. Pay Chart'!F28","v":138.47707735573709},{"$f":"'3-Assoc. Pay Chart'!G28","v":167.61711542007208},{"$f":"'3-Assoc. Pay Chart'!H28","v":196.75715348440707},{"$f":"'3-Assoc. Pay Chart'!I28","v":225.897191548742},{"$f":"'3-Assoc. Pay Chart'!J28","v":255.03722961307702},{"$f":"'3-Assoc. Pay Chart'!K28","v":284.17726767741198},{"$f":"'3-Assoc. Pay Chart'!L28","v":313.31730574174702},{"$f":"'3-Assoc. Pay Chart'!M28","v":342.45734380608195},{"$f":"'3-Assoc. Pay Chart'!N28","v":371.59738187041688},{"$f":"'3-Assoc. Pay Chart'!O28","v":400.73741993475193},{"$f":"'3-Assoc. Pay Chart'!P28","v":429.87745799908697},{"$f":"'3-Assoc. Pay Chart'!Q28","v":459.0174960634219},{"$f":"'3-Assoc. Pay Chart'!R28","v":488.15753412775695},{"$f":"'3-Assoc. Pay Chart'!S28","v":517.29757219209193},{"$f":"'3-Assoc. Pay Chart'!T28","v":546.43761025642686},{"$f":"'3-Assoc. Pay Chart'!U28","v":575.57764832076168},{"$f":"'3-Assoc. Pay Chart'!V28","v":604.71768638509684},{"$f":"'3-Assoc. Pay Chart'!W28","v":633.857724449432},{"$f":"'3-Assoc. Pay Chart'!X28","v":662.99776251376682}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C29-0.00001","v":0.41999000000000014},{"$f":"'3-Assoc. Pay Chart'!D29","v":89.797001227067142},{"$f":"'3-Assoc. Pay Chart'!E29","v":119.89703929140211},{"$f":"'3-Assoc. Pay Chart'!F29","v":149.99707735573708},{"$f":"'3-Assoc. Pay Chart'!G29","v":180.0971154200721},{"$f":"'3-Assoc. Pay Chart'!H29","v":210.19715348440715},{"$f":"'3-Assoc. Pay Chart'!I29","v":240.29719154874195},{"$f":"'3-Assoc. Pay Chart'!J29","v":270.39722961307706},{"$f":"'3-Assoc. Pay Chart'!K29","v":300.49726767741203},{"$f":"'3-Assoc. Pay Chart'!L29","v":330.59730574174699},{"$f":"'3-Assoc. Pay Chart'!M29","v":360.69734380608196},{"$f":"'3-Assoc. Pay Chart'!N29","v":390.79738187041693},{"$f":"'3-Assoc. Pay Chart'!O29","v":420.89741993475189},{"$f":"'3-Assoc. Pay Chart'!P29","v":450.99745799908686},{"$f":"'3-Assoc. Pay Chart'!Q29","v":481.097496063422},{"$f":"'3-Assoc. Pay Chart'!R29","v":511.19753412775691},{"$f":"'3-Assoc. Pay Chart'!S29","v":541.29757219209193},{"$f":"'3-Assoc. Pay Chart'!T29","v":571.3976102564269},{"$f":"'3-Assoc. Pay Chart'!U29","v":601.49764832076175},{"$f":"'3-Assoc. Pay Chart'!V29","v":631.59768638509695},{"$f":"'3-Assoc. Pay Chart'!W29","v":661.69772444943192},{"$f":"'3-Assoc. Pay Chart'!X29","v":691.79776251376677}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C30-0.00001","v":0.42999000000000015},{"$f":"'3-Assoc. Pay Chart'!D30","v":99.397001227067165},{"$f":"'3-Assoc. Pay Chart'!E30","v":130.45703929140217},{"$f":"'3-Assoc. Pay Chart'!F30","v":161.51707735573711},{"$f":"'3-Assoc. Pay Chart'!G30","v":192.57711542007212},{"$f":"'3-Assoc. Pay Chart'!H30","v":223.63715348440707},{"$f":"'3-Assoc. Pay Chart'!I30","v":254.69719154874204},{"$f":"'3-Assoc. Pay Chart'!J30","v":285.75722961307707},{"$f":"'3-Assoc. Pay Chart'!K30","v":316.81726767741196},{"$f":"'3-Assoc. Pay Chart'!L30","v":347.87730574174708},{"$f":"'3-Assoc. Pay Chart'!M30","v":378.93734380608197},{"$f":"'3-Assoc. Pay Chart'!N30","v":409.99738187041697},{"$f":"'3-Assoc. Pay Chart'!O30","v":441.05741993475198},{"$f":"'3-Assoc. Pay Chart'!P30","v":472.11745799908704},{"$f":"'3-Assoc. Pay Chart'!Q30","v":503.1774960634221},{"$f":"'3-Assoc. Pay Chart'!R30","v":534.23753412775693},{"$f":"'3-Assoc. Pay Chart'!S30","v":565.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T30","v":596.35761025642694},{"$f":"'3-Assoc. Pay Chart'!U30","v":627.41764832076183},{"$f":"'3-Assoc. Pay Chart'!V30","v":658.47768638509683},{"$f":"'3-Assoc. Pay Chart'!W30","v":689.53772444943183},{"$f":"'3-Assoc. Pay Chart'!X30","v":720.59776251376695}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C31-0.00001","v":0.43999000000000016},{"$f":"'3-Assoc. Pay Chart'!D31","v":108.99700122706719},{"$f":"'3-Assoc. Pay Chart'!E31","v":141.01703929140211},{"$f":"'3-Assoc. Pay Chart'!F31","v":173.03707735573715},{"$f":"'3-Assoc. Pay Chart'!G31","v":205.05711542007211},{"$f":"'3-Assoc. Pay Chart'!H31","v":237.07715348440709},{"$f":"'3-Assoc. Pay Chart'!I31","v":269.09719154874205},{"$f":"'3-Assoc. Pay Chart'!J31","v":301.11722961307709},{"$f":"'3-Assoc. Pay Chart'!K31","v":333.13726767741201},{"$f":"'3-Assoc. Pay Chart'!L31","v":365.15730574174705},{"$f":"'3-Assoc. Pay Chart'!M31","v":397.17734380608198},{"$f":"'3-Assoc. Pay Chart'!N31","v":429.19738187041702},{"$f":"'3-Assoc. Pay Chart'!O31","v":461.21741993475194},{"$f":"'3-Assoc. Pay Chart'!P31","v":493.23745799908698},{"$f":"'3-Assoc. Pay Chart'!Q31","v":525.25749606342197},{"$f":"'3-Assoc. Pay Chart'!R31","v":557.27753412775701},{"$f":"'3-Assoc. Pay Chart'!S31","v":589.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T31","v":621.31761025642697},{"$f":"'3-Assoc. Pay Chart'!U31","v":653.3376483207619},{"$f":"'3-Assoc. Pay Chart'!V31","v":685.35768638509694},{"$f":"'3-Assoc. Pay Chart'!W31","v":717.37772444943198},{"$f":"'3-Assoc. Pay Chart'!X31","v":749.39776251376691}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C32-0.00001","v":0.44999000000000017},{"$f":"'3-Assoc. Pay Chart'!D32","v":118.59700122706721},{"$f":"'3-Assoc. Pay Chart'!E32","v":151.57703929140217},{"$f":"'3-Assoc. Pay Chart'!F32","v":184.55707735573714},{"$f":"'3-Assoc. Pay Chart'!G32","v":217.5371154200721},{"$f":"'3-Assoc. Pay Chart'!H32","v":250.51715348440703},{"$f":"'3-Assoc. Pay Chart'!I32","v":283.49719154874202},{"$f":"'3-Assoc. Pay Chart'!J32","v":316.4772296130771},{"$f":"'3-Assoc. Pay Chart'!K32","v":349.45726767741206},{"$f":"'3-Assoc. Pay Chart'!L32","v":382.43730574174714},{"$f":"'3-Assoc. Pay Chart'!M32","v":415.41734380608199},{"$f":"'3-Assoc. Pay Chart'!N32","v":448.39738187041706},{"$f":"'3-Assoc. Pay Chart'!O32","v":481.37741993475208},{"$f":"'3-Assoc. Pay Chart'!P32","v":514.35745799908705},{"$f":"'3-Assoc. Pay Chart'!Q32","v":547.33749606342201},{"$f":"'3-Assoc. Pay Chart'!R32","v":580.31753412775697},{"$f":"'3-Assoc. Pay Chart'!S32","v":613.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T32","v":646.27761025642701},{"$f":"'3-Assoc. Pay Chart'!U32","v":679.25764832076197},{"$f":"'3-Assoc. Pay Chart'!V32","v":712.23768638509682},{"$f":"'3-Assoc. Pay Chart'!W32","v":745.2177244494319},{"$f":"'3-Assoc. Pay Chart'!X32","v":778.19776251376686}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C33-0.00001","v":0.45999000000000018},{"$f":"'3-Assoc. Pay Chart'!D33","v":128.19700122706723},{"$f":"'3-Assoc. Pay Chart'!E33","v":162.13703929140223},{"$f":"'3-Assoc. Pay Chart'!F33","v":196.07707735573712},{"$f":"'3-Assoc. Pay Chart'!G33","v":230.01711542007209},{"$f":"'3-Assoc. Pay Chart'!H33","v":263.95715348440712},{"$f":"'3-Assoc. Pay Chart'!I33","v":297.89719154874211},{"$f":"'3-Assoc. Pay Chart'!J33","v":331.83722961307711},{"$f":"'3-Assoc. Pay Chart'!K33","v":365.777267677412},{"$f":"'3-Assoc. Pay Chart'!L33","v":399.71730574174711},{"$f":"'3-Assoc. Pay Chart'!M33","v":433.657343806082},{"$f":"'3-Assoc. Pay Chart'!N33","v":467.59738187041711},{"$f":"'3-Assoc. Pay Chart'!O33","v":501.53741993475211},{"$f":"'3-Assoc. Pay Chart'!P33","v":535.47745799908716},{"$f":"'3-Assoc. Pay Chart'!Q33","v":569.41749606342205},{"$f":"'3-Assoc. Pay Chart'!R33","v":603.35753412775694},{"$f":"'3-Assoc. Pay Chart'!S33","v":637.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T33","v":671.23761025642705},{"$f":"'3-Assoc. Pay Chart'!U33","v":705.17764832076182},{"$f":"'3-Assoc. Pay Chart'!V33","v":739.11768638509693},{"$f":"'3-Assoc. Pay Chart'!W33","v":773.05772444943204},{"$f":"'3-Assoc. Pay Chart'!X33","v":806.99776251376704}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C34-0.00001","v":0.46999000000000019},{"$f":"'3-Assoc. Pay Chart'!D34","v":137.79700122706714},{"$f":"'3-Assoc. Pay Chart'!E34","v":172.69703929140218},{"$f":"'3-Assoc. Pay Chart'!F34","v":207.59707735573724},{"$f":"'3-Assoc. Pay Chart'!G34","v":242.49711542007211},{"$f":"'3-Assoc. Pay Chart'!H34","v":277.39715348440717},{"$f":"'3-Assoc. Pay Chart'!I34","v":312.29719154874209},{"$f":"'3-Assoc. Pay Chart'!J34","v":347.19722961307713},{"$f":"'3-Assoc. Pay Chart'!K34","v":382.09726767741205},{"$f":"'3-Assoc. Pay Chart'!L34","v":416.99730574174708},{"$f":"'3-Assoc. Pay Chart'!M34","v":451.89734380608201},{"$f":"'3-Assoc. Pay Chart'!N34","v":486.79738187041704},{"$f":"'3-Assoc. Pay Chart'!O34","v":521.69741993475213},{"$f":"'3-Assoc. Pay Chart'!P34","v":556.59745799908706},{"$f":"'3-Assoc. Pay Chart'!Q34","v":591.49749606342209},{"$f":"'3-Assoc. Pay Chart'!R34","v":626.39753412775713},{"$f":"'3-Assoc. Pay Chart'!S34","v":661.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T34","v":696.19761025642708},{"$f":"'3-Assoc. Pay Chart'!U34","v":731.09764832076189},{"$f":"'3-Assoc. Pay Chart'!V34","v":765.99768638509704},{"$f":"'3-Assoc. Pay Chart'!W34","v":800.89772444943196},{"$f":"'3-Assoc. Pay Chart'!X34","v":835.79776251376688}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C35-0.00001","v":0.47999000000000019},{"$f":"'3-Assoc. Pay Chart'!D35","v":147.39700122706716},{"$f":"'3-Assoc. Pay Chart'!E35","v":183.25703929140224},{"$f":"'3-Assoc. Pay Chart'!F35","v":219.11707735573719},{"$f":"'3-Assoc. Pay Chart'!G35","v":254.97711542007212},{"$f":"'3-Assoc. Pay Chart'!H35","v":290.83715348440711},{"$f":"'3-Assoc. Pay Chart'!I35","v":326.69719154874218},{"$f":"'3-Assoc. Pay Chart'!J35","v":362.55722961307714},{"$f":"'3-Assoc. Pay Chart'!K35","v":398.4172676774121},{"$f":"'3-Assoc. Pay Chart'!L35","v":434.27730574174717},{"$f":"'3-Assoc. Pay Chart'!M35","v":470.13734380608201},{"$f":"'3-Assoc. Pay Chart'!N35","v":505.99738187041709},{"$f":"'3-Assoc. Pay Chart'!O35","v":541.8574199347521},{"$f":"'3-Assoc. Pay Chart'!P35","v":577.71745799908717},{"$f":"'3-Assoc. Pay Chart'!Q35","v":613.57749606342202},{"$f":"'3-Assoc. Pay Chart'!R35","v":649.43753412775709},{"$f":"'3-Assoc. Pay Chart'!S35","v":685.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T35","v":721.15761025642712},{"$f":"'3-Assoc. Pay Chart'!U35","v":757.01764832076196},{"$f":"'3-Assoc. Pay Chart'!V35","v":792.87768638509692},{"$f":"'3-Assoc. Pay Chart'!W35","v":828.73772444943211},{"$f":"'3-Assoc. Pay Chart'!X35","v":864.59776251376707}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C36-0.00001","v":0.4899900000000002},{"$f":"'3-Assoc. Pay Chart'!D36","v":156.99700122706719},{"$f":"'3-Assoc. Pay Chart'!E36","v":193.8170392914023},{"$f":"'3-Assoc. Pay Chart'!F36","v":230.63707735573715},{"$f":"'3-Assoc. Pay Chart'!G36","v":267.45711542007206},{"$f":"'3-Assoc. Pay Chart'!H36","v":304.27715348440717},{"$f":"'3-Assoc. Pay Chart'!I36","v":341.09719154874227},{"$f":"'3-Assoc. Pay Chart'!J36","v":377.91722961307715},{"$f":"'3-Assoc. Pay Chart'!K36","v":414.73726767741204},{"$f":"'3-Assoc. Pay Chart'!L36","v":451.55730574174714},{"$f":"'3-Assoc. Pay Chart'!M36","v":488.37734380608225},{"$f":"'3-Assoc. Pay Chart'!N36","v":525.19738187041708},{"$f":"'3-Assoc. Pay Chart'!O36","v":562.01741993475207},{"$f":"'3-Assoc. Pay Chart'!P36","v":598.83745799908729},{"$f":"'3-Assoc. Pay Chart'!Q36","v":635.65749606342217},{"$f":"'3-Assoc. Pay Chart'!R36","v":672.47753412775705},{"$f":"'3-Assoc. Pay Chart'!S36","v":709.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T36","v":746.11761025642693},{"$f":"'3-Assoc. Pay Chart'!U36","v":782.93764832076204},{"$f":"'3-Assoc. Pay Chart'!V36","v":819.75768638509703},{"$f":"'3-Assoc. Pay Chart'!W36","v":856.57772444943203},{"$f":"'3-Assoc. Pay Chart'!X36","v":893.39776251376725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Assoc. Pay Chart'!C37-0.00001","v":0.49999000000000021},{"$f":"'3-Assoc. Pay Chart'!D37","v":166.59700122706721},{"$f":"'3-Assoc. Pay Chart'!E37","v":204.37703929140227},{"$f":"'3-Assoc. Pay Chart'!F37","v":242.15707735573713},{"$f":"'3-Assoc. Pay Chart'!G37","v":279.93711542007208},{"$f":"'3-Assoc. Pay Chart'!H37","v":317.71715348440722},{"$f":"'3-Assoc. Pay Chart'!I37","v":355.49719154874214},{"$f":"'3-Assoc. Pay Chart'!J37","v":393.27722961307717},{"$f":"'3-Assoc. Pay Chart'!K37","v":431.05726767741209},{"$f":"'3-Assoc. Pay Chart'!L37","v":468.83730574174712},{"$f":"'3-Assoc. Pay Chart'!M37","v":506.61734380608226},{"$f":"'3-Assoc. Pay Chart'!N37","v":544.39738187041712},{"$f":"'3-Assoc. Pay Chart'!O37","v":582.17741993475215},{"$f":"'3-Assoc. Pay Chart'!P37","v":619.95745799908718},{"$f":"'3-Assoc. Pay Chart'!Q37","v":657.7374960634221},{"$f":"'3-Assoc. Pay Chart'!R37","v":695.51753412775702},{"$f":"'3-Assoc. Pay Chart'!S37","v":733.29757219209205},{"$f":"'3-Assoc. Pay Chart'!T37","v":771.07761025642696},{"$f":"'3-Assoc. Pay Chart'!U37","v":808.85764832076211},{"$f":"'3-Assoc. Pay Chart'!V37","v":846.63768638509714},{"$f":"'3-Assoc. Pay Chart'!W37","v":884.41772444943217},{"$f":"'3-Assoc. Pay Chart'!X37","v":922.19776251376697}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Senior Doctor's Net Take-Home Before Tax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!D11","v":1000},{"$f":"'4-Sr Dr Pay Chart'!E11","v":1100},{"$f":"'4-Sr Dr Pay Chart'!F11","v":1200},{"$f":"'4-Sr Dr Pay Chart'!G11","v":1300},{"$f":"'4-Sr Dr Pay Chart'!H11","v":1400},{"$f":"'4-Sr Dr Pay Chart'!I11","v":1500},{"$f":"'4-Sr Dr Pay Chart'!J11","v":1600},{"$f":"'4-Sr Dr Pay Chart'!K11","v":1700},{"$f":"'4-Sr Dr Pay Chart'!L11","v":1800},{"$f":"'4-Sr Dr Pay Chart'!M11","v":1900},{"$f":"'4-Sr Dr Pay Chart'!N11","v":2000},{"$f":"'4-Sr Dr Pay Chart'!O11","v":2100},{"$f":"'4-Sr Dr Pay Chart'!P11","v":2200},{"$f":"'4-Sr Dr Pay Chart'!Q11","v":2300},{"$f":"'4-Sr Dr Pay Chart'!R11","v":2400},{"$f":"'4-Sr Dr Pay Chart'!S11","v":2500},{"$f":"'4-Sr Dr Pay Chart'!T11","v":2600},{"$f":"'4-Sr Dr Pay Chart'!U11","v":2700},{"$f":"'4-Sr Dr Pay Chart'!V11","v":2800},{"$f":"'4-Sr Dr Pay Chart'!W11","v":2900},{"$f":"'4-Sr Dr Pay Chart'!X11","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C27-0.00001","v":0.39999000000000012},{"$f":"'4-Sr Dr Pay Chart'!D27","v":148.35027717394129},{"$f":"'4-Sr Dr Pay Chart'!E27","v":193.11027717394128},{"$f":"'4-Sr Dr Pay Chart'!F27","v":237.87027717394125},{"$f":"'4-Sr Dr Pay Chart'!G27","v":282.63027717394124},{"$f":"'4-Sr Dr Pay Chart'!H27","v":327.39027717394123},{"$f":"'4-Sr Dr Pay Chart'!I27","v":372.15027717394105},{"$f":"'4-Sr Dr Pay Chart'!J27","v":416.91027717394121},{"$f":"'4-Sr Dr Pay Chart'!K27","v":461.6702771739412},{"$f":"'4-Sr Dr Pay Chart'!L27","v":506.43027717394108},{"$f":"'4-Sr Dr Pay Chart'!M27","v":551.19027717394101},{"$f":"'4-Sr Dr Pay Chart'!N27","v":595.95027717394123},{"$f":"'4-Sr Dr Pay Chart'!O27","v":640.71027717394099},{"$f":"'4-Sr Dr Pay Chart'!P27","v":685.47027717394121},{"$f":"'4-Sr Dr Pay Chart'!Q27","v":730.2302771739412},{"$f":"'4-Sr Dr Pay Chart'!R27","v":774.99027717394097},{"$f":"'4-Sr Dr Pay Chart'!S27","v":819.75027717394096},{"$f":"'4-Sr Dr Pay Chart'!T27","v":864.51027717394118},{"$f":"'4-Sr Dr Pay Chart'!U27","v":909.27027717394117},{"$f":"'4-Sr Dr Pay Chart'!V27","v":954.03027717394139},{"$f":"'4-Sr Dr Pay Chart'!W27","v":998.79027717394138},{"$f":"'4-Sr Dr Pay Chart'!X27","v":1043.5502771739411}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C28-0.00001","v":0.40999000000000013},{"$f":"'4-Sr Dr Pay Chart'!D28","v":137.79027717394123},{"$f":"'4-Sr Dr Pay Chart'!E28","v":181.4942771739413},{"$f":"'4-Sr Dr Pay Chart'!F28","v":225.19827717394125},{"$f":"'4-Sr Dr Pay Chart'!G28","v":268.90227717394117},{"$f":"'4-Sr Dr Pay Chart'!H28","v":312.60627717394124},{"$f":"'4-Sr Dr Pay Chart'!I28","v":356.31027717394113},{"$f":"'4-Sr Dr Pay Chart'!J28","v":400.01427717394103},{"$f":"'4-Sr Dr Pay Chart'!K28","v":443.7182771739412},{"$f":"'4-Sr Dr Pay Chart'!L28","v":487.42227717394121},{"$f":"'4-Sr Dr Pay Chart'!M28","v":531.12627717394139},{"$f":"'4-Sr Dr Pay Chart'!N28","v":574.83027717394111},{"$f":"'4-Sr Dr Pay Chart'!O28","v":618.53427717394106},{"$f":"'4-Sr Dr Pay Chart'!P28","v":662.23827717394124},{"$f":"'4-Sr Dr Pay Chart'!Q28","v":705.94227717394119},{"$f":"'4-Sr Dr Pay Chart'!R28","v":749.64627717394114},{"$f":"'4-Sr Dr Pay Chart'!S28","v":793.35027717394087},{"$f":"'4-Sr Dr Pay Chart'!T28","v":837.05427717394105},{"$f":"'4-Sr Dr Pay Chart'!U28","v":880.75827717394122},{"$f":"'4-Sr Dr Pay Chart'!V28","v":924.46227717394117},{"$f":"'4-Sr Dr Pay Chart'!W28","v":968.16627717394113},{"$f":"'4-Sr Dr Pay Chart'!X28","v":1011.8702771739413}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C29-0.00001","v":0.41999000000000014},{"$f":"'4-Sr Dr Pay Chart'!D29","v":127.23027717394129},{"$f":"'4-Sr Dr Pay Chart'!E29","v":169.8782771739412},{"$f":"'4-Sr Dr Pay Chart'!F29","v":212.52627717394122},{"$f":"'4-Sr Dr Pay Chart'!G29","v":255.17427717394122},{"$f":"'4-Sr Dr Pay Chart'!H29","v":297.82227717394113},{"$f":"'4-Sr Dr Pay Chart'!I29","v":340.47027717394116},{"$f":"'4-Sr Dr Pay Chart'!J29","v":383.11827717394112},{"$f":"'4-Sr Dr Pay Chart'!K29","v":425.76627717394098},{"$f":"'4-Sr Dr Pay Chart'!L29","v":468.41427717394112},{"$f":"'4-Sr Dr Pay Chart'!M29","v":511.06227717394114},{"$f":"'4-Sr Dr Pay Chart'!N29","v":553.71027717394099},{"$f":"'4-Sr Dr Pay Chart'!O29","v":596.35827717394113},{"$f":"'4-Sr Dr Pay Chart'!P29","v":639.00627717394104},{"$f":"'4-Sr Dr Pay Chart'!Q29","v":681.65427717394095},{"$f":"'4-Sr Dr Pay Chart'!R29","v":724.30227717394109},{"$f":"'4-Sr Dr Pay Chart'!S29","v":766.950277173941},{"$f":"'4-Sr Dr Pay Chart'!T29","v":809.59827717394091},{"$f":"'4-Sr Dr Pay Chart'!U29","v":852.24627717394105},{"$f":"'4-Sr Dr Pay Chart'!V29","v":894.89427717394096},{"$f":"'4-Sr Dr Pay Chart'!W29","v":937.5422771739411},{"$f":"'4-Sr Dr Pay Chart'!X29","v":980.19027717394124}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C30-0.00001","v":0.42999000000000015},{"$f":"'4-Sr Dr Pay Chart'!D30","v":116.67027717394123},{"$f":"'4-Sr Dr Pay Chart'!E30","v":158.26227717394121},{"$f":"'4-Sr Dr Pay Chart'!F30","v":199.85427717394131},{"$f":"'4-Sr Dr Pay Chart'!G30","v":241.44627717394116},{"$f":"'4-Sr Dr Pay Chart'!H30","v":283.03827717394114},{"$f":"'4-Sr Dr Pay Chart'!I30","v":324.63027717394112},{"$f":"'4-Sr Dr Pay Chart'!J30","v":366.22227717394117},{"$f":"'4-Sr Dr Pay Chart'!K30","v":407.81427717394121},{"$f":"'4-Sr Dr Pay Chart'!L30","v":449.40627717394108},{"$f":"'4-Sr Dr Pay Chart'!M30","v":490.99827717394123},{"$f":"'4-Sr Dr Pay Chart'!N30","v":532.5902771739411},{"$f":"'4-Sr Dr Pay Chart'!O30","v":574.1822771739412},{"$f":"'4-Sr Dr Pay Chart'!P30","v":615.77427717394107},{"$f":"'4-Sr Dr Pay Chart'!Q30","v":657.36627717394094},{"$f":"'4-Sr Dr Pay Chart'!R30","v":698.95827717394104},{"$f":"'4-Sr Dr Pay Chart'!S30","v":740.55027717394091},{"$f":"'4-Sr Dr Pay Chart'!T30","v":782.14227717394101},{"$f":"'4-Sr Dr Pay Chart'!U30","v":823.73427717394111},{"$f":"'4-Sr Dr Pay Chart'!V30","v":865.32627717394098},{"$f":"'4-Sr Dr Pay Chart'!W30","v":906.91827717394131},{"$f":"'4-Sr Dr Pay Chart'!X30","v":948.51027717394118}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C31-0.00001","v":0.43999000000000016},{"$f":"'4-Sr Dr Pay Chart'!D31","v":106.11027717394128},{"$f":"'4-Sr Dr Pay Chart'!E31","v":146.64627717394134},{"$f":"'4-Sr Dr Pay Chart'!F31","v":187.18227717394117},{"$f":"'4-Sr Dr Pay Chart'!G31","v":227.71827717394123},{"$f":"'4-Sr Dr Pay Chart'!H31","v":268.25427717394115},{"$f":"'4-Sr Dr Pay Chart'!I31","v":308.79027717394109},{"$f":"'4-Sr Dr Pay Chart'!J31","v":349.32627717394115},{"$f":"'4-Sr Dr Pay Chart'!K31","v":389.86227717394098},{"$f":"'4-Sr Dr Pay Chart'!L31","v":430.39827717394104},{"$f":"'4-Sr Dr Pay Chart'!M31","v":470.9342771739411},{"$f":"'4-Sr Dr Pay Chart'!N31","v":511.47027717394127},{"$f":"'4-Sr Dr Pay Chart'!O31","v":552.00627717394104},{"$f":"'4-Sr Dr Pay Chart'!P31","v":592.54227717394133},{"$f":"'4-Sr Dr Pay Chart'!Q31","v":633.07827717394093},{"$f":"'4-Sr Dr Pay Chart'!R31","v":673.61427717394099},{"$f":"'4-Sr Dr Pay Chart'!S31","v":714.15027717394105},{"$f":"'4-Sr Dr Pay Chart'!T31","v":754.68627717394088},{"$f":"'4-Sr Dr Pay Chart'!U31","v":795.22227717394094},{"$f":"'4-Sr Dr Pay Chart'!V31","v":835.758277173941},{"$f":"'4-Sr Dr Pay Chart'!W31","v":876.29427717394083},{"$f":"'4-Sr Dr Pay Chart'!X31","v":916.83027717394111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C32-0.00001","v":0.44999000000000017},{"$f":"'4-Sr Dr Pay Chart'!D32","v":95.550277173941211},{"$f":"'4-Sr Dr Pay Chart'!E32","v":135.03027717394124},{"$f":"'4-Sr Dr Pay Chart'!F32","v":174.51027717394115},{"$f":"'4-Sr Dr Pay Chart'!G32","v":213.99027717394117},{"$f":"'4-Sr Dr Pay Chart'!H32","v":253.47027717394116},{"$f":"'4-Sr Dr Pay Chart'!I32","v":292.95027717394117},{"$f":"'4-Sr Dr Pay Chart'!J32","v":332.43027717394108},{"$f":"'4-Sr Dr Pay Chart'!K32","v":371.91027717394104},{"$f":"'4-Sr Dr Pay Chart'!L32","v":411.390277173941},{"$f":"'4-Sr Dr Pay Chart'!M32","v":450.87027717394102},{"$f":"'4-Sr Dr Pay Chart'!N32","v":490.35027717394087},{"$f":"'4-Sr Dr Pay Chart'!O32","v":529.83027717394111},{"$f":"'4-Sr Dr Pay Chart'!P32","v":569.31027717394113},{"$f":"'4-Sr Dr Pay Chart'!Q32","v":608.79027717394115},{"$f":"'4-Sr Dr Pay Chart'!R32","v":648.27027717394094},{"$f":"'4-Sr Dr Pay Chart'!S32","v":687.75027717394096},{"$f":"'4-Sr Dr Pay Chart'!T32","v":727.23027717394098},{"$f":"'4-Sr Dr Pay Chart'!U32","v":766.71027717394077},{"$f":"'4-Sr Dr Pay Chart'!V32","v":806.19027717394101},{"$f":"'4-Sr Dr Pay Chart'!W32","v":845.67027717394103},{"$f":"'4-Sr Dr Pay Chart'!X32","v":885.15027717394105}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C33-0.00001","v":0.45999000000000018},{"$f":"'4-Sr Dr Pay Chart'!D33","v":84.990277173941266},{"$f":"'4-Sr Dr Pay Chart'!E33","v":123.41427717394114},{"$f":"'4-Sr Dr Pay Chart'!F33","v":161.83827717394124},{"$f":"'4-Sr Dr Pay Chart'!G33","v":200.2622771739411},{"$f":"'4-Sr Dr Pay Chart'!H33","v":238.68627717394116},{"$f":"'4-Sr Dr Pay Chart'!I33","v":277.11027717394103},{"$f":"'4-Sr Dr Pay Chart'!J33","v":315.53427717394112},{"$f":"'4-Sr Dr Pay Chart'!K33","v":353.9582771739411},{"$f":"'4-Sr Dr Pay Chart'!L33","v":392.38227717394096},{"$f":"'4-Sr Dr Pay Chart'!M33","v":430.80627717394094},{"$f":"'4-Sr Dr Pay Chart'!N33","v":469.23027717394092},{"$f":"'4-Sr Dr Pay Chart'!O33","v":507.65427717394101},{"$f":"'4-Sr Dr Pay Chart'!P33","v":546.07827717394093},{"$f":"'4-Sr Dr Pay Chart'!Q33","v":584.50227717394114},{"$f":"'4-Sr Dr Pay Chart'!R33","v":622.92627717394112},{"$f":"'4-Sr Dr Pay Chart'!S33","v":661.35027717394087},{"$f":"'4-Sr Dr Pay Chart'!T33","v":699.77427717394085},{"$f":"'4-Sr Dr Pay Chart'!U33","v":738.19827717394105},{"$f":"'4-Sr Dr Pay Chart'!V33","v":776.62227717394103},{"$f":"'4-Sr Dr Pay Chart'!W33","v":815.04627717394078},{"$f":"'4-Sr Dr Pay Chart'!X33","v":853.47027717394076}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C34-0.00001","v":0.46999000000000019},{"$f":"'4-Sr Dr Pay Chart'!D34","v":74.430277173941263},{"$f":"'4-Sr Dr Pay Chart'!E34","v":111.79827717394127},{"$f":"'4-Sr Dr Pay Chart'!F34","v":149.1662771739411},{"$f":"'4-Sr Dr Pay Chart'!G34","v":186.53427717394115},{"$f":"'4-Sr Dr Pay Chart'!H34","v":223.90227717394109},{"$f":"'4-Sr Dr Pay Chart'!I34","v":261.27027717394111},{"$f":"'4-Sr Dr Pay Chart'!J34","v":298.63827717394105},{"$f":"'4-Sr Dr Pay Chart'!K34","v":336.0062771739411},{"$f":"'4-Sr Dr Pay Chart'!L34","v":373.37427717394098},{"$f":"'4-Sr Dr Pay Chart'!M34","v":410.74227717394109},{"$f":"'4-Sr Dr Pay Chart'!N34","v":448.11027717394103},{"$f":"'4-Sr Dr Pay Chart'!O34","v":485.47827717394102},{"$f":"'4-Sr Dr Pay Chart'!P34","v":522.84627717394096},{"$f":"'4-Sr Dr Pay Chart'!Q34","v":560.2142771739409},{"$f":"'4-Sr Dr Pay Chart'!R34","v":597.58227717394084},{"$f":"'4-Sr Dr Pay Chart'!S34","v":634.950277173941},{"$f":"'4-Sr Dr Pay Chart'!T34","v":672.31827717394071},{"$f":"'4-Sr Dr Pay Chart'!U34","v":709.68627717394088},{"$f":"'4-Sr Dr Pay Chart'!V34","v":747.05427717394082},{"$f":"'4-Sr Dr Pay Chart'!W34","v":784.42227717394098},{"$f":"'4-Sr Dr Pay Chart'!X34","v":821.79027717394092}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C35-0.00001","v":0.47999000000000019},{"$f":"'4-Sr Dr Pay Chart'!D35","v":63.870277173941204},{"$f":"'4-Sr Dr Pay Chart'!E35","v":100.18227717394117},{"$f":"'4-Sr Dr Pay Chart'!F35","v":136.49427717394119},{"$f":"'4-Sr Dr Pay Chart'!G35","v":172.80627717394108},{"$f":"'4-Sr Dr Pay Chart'!H35","v":209.11827717394121},{"$f":"'4-Sr Dr Pay Chart'!I35","v":245.43027717394108},{"$f":"'4-Sr Dr Pay Chart'!J35","v":281.74227717394109},{"$f":"'4-Sr Dr Pay Chart'!K35","v":318.05427717394099},{"$f":"'4-Sr Dr Pay Chart'!L35","v":354.366277173941},{"$f":"'4-Sr Dr Pay Chart'!M35","v":390.67827717394101},{"$f":"'4-Sr Dr Pay Chart'!N35","v":426.99027717394091},{"$f":"'4-Sr Dr Pay Chart'!O35","v":463.30227717394104},{"$f":"'4-Sr Dr Pay Chart'!P35","v":499.61427717394105},{"$f":"'4-Sr Dr Pay Chart'!Q35","v":535.92627717394112},{"$f":"'4-Sr Dr Pay Chart'!R35","v":572.23827717394079},{"$f":"'4-Sr Dr Pay Chart'!S35","v":608.55027717394091},{"$f":"'4-Sr Dr Pay Chart'!T35","v":644.86227717394081},{"$f":"'4-Sr Dr Pay Chart'!U35","v":681.17427717394094},{"$f":"'4-Sr Dr Pay Chart'!V35","v":717.48627717394083},{"$f":"'4-Sr Dr Pay Chart'!W35","v":753.79827717394073},{"$f":"'4-Sr Dr Pay Chart'!X35","v":790.11027717394086}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C36-0.00001","v":0.4899900000000002},{"$f":"'4-Sr Dr Pay Chart'!D36","v":53.310277173941202},{"$f":"'4-Sr Dr Pay Chart'!E36","v":88.56627717394106},{"$f":"'4-Sr Dr Pay Chart'!F36","v":123.82227717394116},{"$f":"'4-Sr Dr Pay Chart'!G36","v":159.07827717394125},{"$f":"'4-Sr Dr Pay Chart'!H36","v":194.3342771739411},{"$f":"'4-Sr Dr Pay Chart'!I36","v":229.59027717394108},{"$f":"'4-Sr Dr Pay Chart'!J36","v":264.84627717394102},{"$f":"'4-Sr Dr Pay Chart'!K36","v":300.1022771739411},{"$f":"'4-Sr Dr Pay Chart'!L36","v":335.35827717394096},{"$f":"'4-Sr Dr Pay Chart'!M36","v":370.61427717394099},{"$f":"'4-Sr Dr Pay Chart'!N36","v":405.87027717394079},{"$f":"'4-Sr Dr Pay Chart'!O36","v":441.12627717394088},{"$f":"'4-Sr Dr Pay Chart'!P36","v":476.38227717394074},{"$f":"'4-Sr Dr Pay Chart'!Q36","v":511.63827717394093},{"$f":"'4-Sr Dr Pay Chart'!R36","v":546.89427717394096},{"$f":"'4-Sr Dr Pay Chart'!S36","v":582.15027717394105},{"$f":"'4-Sr Dr Pay Chart'!T36","v":617.40627717394091},{"$f":"'4-Sr Dr Pay Chart'!U36","v":652.66227717394077},{"$f":"'4-Sr Dr Pay Chart'!V36","v":687.91827717394085},{"$f":"'4-Sr Dr Pay Chart'!W36","v":723.17427717394094},{"$f":"'4-Sr Dr Pay Chart'!X36","v":758.43027717394057}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-Sr Dr Pay Chart'!C37-0.00001","v":0.49999000000000021},{"$f":"'4-Sr Dr Pay Chart'!D37","v":42.750277173941136},{"$f":"'4-Sr Dr Pay Chart'!E37","v":76.950277173941188},{"$f":"'4-Sr Dr Pay Chart'!F37","v":111.15027717394113},{"$f":"'4-Sr Dr Pay Chart'!G37","v":145.35027717394118},{"$f":"'4-Sr Dr Pay Chart'!H37","v":179.55027717394111},{"$f":"'4-Sr Dr Pay Chart'!I37","v":213.75027717394104},{"$f":"'4-Sr Dr Pay Chart'!J37","v":247.95027717394106},{"$f":"'4-Sr Dr Pay Chart'!K37","v":282.15027717394099},{"$f":"'4-Sr Dr Pay Chart'!L37","v":316.35027717394104},{"$f":"'4-Sr Dr Pay Chart'!M37","v":350.55027717394086},{"$f":"'4-Sr Dr Pay Chart'!N37","v":384.75027717394096},{"$f":"'4-Sr Dr Pay Chart'!O37","v":418.95027717394095},{"$f":"'4-Sr Dr Pay Chart'!P37","v":453.15027717394076},{"$f":"'4-Sr Dr Pay Chart'!Q37","v":487.35027717394087},{"$f":"'4-Sr Dr Pay Chart'!R37","v":521.55027717394091},{"$f":"'4-Sr Dr Pay Chart'!S37","v":555.75027717394096},{"$f":"'4-Sr Dr Pay Chart'!T37","v":589.950277173941},{"$f":"'4-Sr Dr Pay Chart'!U37","v":624.15027717394059},{"$f":"'4-Sr Dr Pay Chart'!V37","v":658.35027717394064},{"$f":"'4-Sr Dr Pay Chart'!W37","v":692.55027717394069},{"$f":"'4-Sr Dr Pay Chart'!X37","v":726.75027717394073}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Associate Minimum Income Requried",{"$f":"IF(AssocStandardDaysperMo=0,0,'1-Input Data'!D49/AssocStandardDaysperMo/12)","v":400.34562211981569},{"$f":"Z351","v":400.34562211981569},400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569,400.34562211981569]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Potential_Associate_Name&\"'s \"&\"TakeHome\"","v":"Irving Wannabe, D.M.D.'s TakeHome"},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!Z319+1)","v":118.59700122706721},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AA319+1)","v":151.57703929140217},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AB319+1)","v":184.55707735573714},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AC319+1)","v":217.5371154200721},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AD319+1)","v":250.51715348440703},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AE319+1)","v":283.49719154874202},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AF319+1)","v":316.4772296130771},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AG319+1)","v":349.45726767741206},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AH319+1)","v":382.43730574174714},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AI319+1)","v":415.41734380608199},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AJ319+1)","v":448.39738187041706},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AK319+1)","v":481.37741993475208},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AL319+1)","v":514.35745799908705},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AM319+1)","v":547.33749606342201},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AN319+1)","v":580.31753412775697},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AO319+1)","v":613.29757219209205},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AP319+1)","v":646.27761025642701},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AQ319+1)","v":679.25764832076197},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AR319+1)","v":712.23768638509682},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AS319+1)","v":745.2177244494319},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$321:$AT$331,Calcs!AT319+1)","v":778.19776251376686}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Associate_commission_percentage*100&\"% \"&IF(AssocPaidOn=1,\"Commission on Collections\",\"Commission on Production\")","v":"45% Commission on Collections"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sr._Dr.___Partner_1_Name&\"'s \"&\"TakeHome\"","v":"John Righthinker, D.D.S.'s TakeHome"},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!Z319+1)","v":95.550277173941211},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AA319+1)","v":135.03027717394124},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AB319+1)","v":174.51027717394115},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AC319+1)","v":213.99027717394117},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AD319+1)","v":253.47027717394116},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AE319+1)","v":292.95027717394117},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AF319+1)","v":332.43027717394108},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AG319+1)","v":371.91027717394104},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AH319+1)","v":411.390277173941},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AI319+1)","v":450.87027717394102},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AJ319+1)","v":490.35027717394087},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AK319+1)","v":529.83027717394111},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AL319+1)","v":569.31027717394113},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AM319+1)","v":608.79027717394115},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AN319+1)","v":648.27027717394094},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AO319+1)","v":687.75027717394096},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AP319+1)","v":727.23027717394098},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AQ319+1)","v":766.71027717394077},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AR319+1)","v":806.19027717394101},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AS319+1)","v":845.67027717394103},{"$f":"VLOOKUP(Associate_commission_percentage,Calcs!$Y$338:$AT$348,Calcs!AT319+1)","v":885.15027717394105}]

{"sheet":"Module1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}