payeeName: This must be the string name of the payee and must match exactly (case sensative) the names in tblPayee.
procedureName: This must be the string name of the procedure and must match exactly (case sensative) the names in tblProcedure.
avgCharge
avgPayment
caseRate
To upload tblPayee:
The worksheet must be named tblPayee.
The columns must be named:
name: This must be the string name of the payee and must match exactly (case sensative) the names in tblData.
inflatorMultiplier
pct1
pct2
pct3
pct4
pct5
pct6
pct7
pct8
pct9
pct10
implantPct
To upload tblProcedure:
The worksheet must be named tblProcedures.
The columns must be named:
name: This must be the string name of the payee and must match exactly (case sensative) the names in tblData.
NOTE: The code is split out of the name. The split occurs on " - " (includes the space before and after. This is used to pull in the professional charges for tblData.