ESTIMATOR SHEET
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
VISIT TYPEPRIMARY INSURANCE IDPRIMARY INSURANCEPAYOUTVISIT TYPE 3PRIMARY INSURANCEPAY OUT
3
VISIT TYPE 1111A1
***This value needs to be calculated using the visit type, the primary insurance, and the fee schedule. The visit types are sorted into percentages meaning that the payout total for the visit type is as illustrated to the right.
CODE%A1
4
VISIT TYPE 3333C31256725.0%131.97$32.99
5
VISIT TYPE 4222B21267817.0%98.34$16.72
6
VISIT TYPE 2333C31278958.0%116.87$67.78
7
VISIT TYPE 5222B2#N/A#N/A
8
VISIT TYPE 5111A1#N/A#N/A
9
VISIT TYPE 3222B2117.4949
<---THIS VALUE SHOULD APPEAR IN THE PAYOUT CELLS IN COLUMN E.
10
VISIT TYPE 4333C3
11
VISIT TYPE 5333C3
12
VISIT TYPE 4222B2
13
VISIT TYPE 1111A1
14
VISIT TYPE 1333C3
15
VISIT TYPE 3222B2
16
VISIT TYPE 4333C3
17
VISIT TYPE 2111A1
18
VISIT TYPE 5111A1
19
VISIT TYPE 5222B2
20
VISIT TYPE 3333C3
21
VISIT TYPE 4111A1
22
VISIT TYPE 5222B2
23
VISIT TYPE 4333C3
24
VISIT TYPE 1111A1
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu