Spreadsheet: 288097d1389096082-how-do-i-make-a-daily-list-of-orders-into-one-weekly-list-with-no-rows-empty-cash-sheets-tmp-jan-2014
Sheet: MON AM

 | Date: |  |  |  | MONDAY CLINIC ALL DAY
 | Patient | Old/New | S/T Fee | C/L Fee | D/S Fee | Result | Frames | Lenses | Voucher | Prism | Tint | TOTAL VOUCHER | Frame Type | Patient | [NAME] | Index | Coatings | Order | From | Date | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 | TOTALS |  |  |  |  |  |  |  | TOTAL VOUCHER VALUES |  |  |  |  |  | [NAME] | Index | Coating
 |  |  |  | TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  | Total Across
 |  |  | [NAME]
 | Appointments |  | [NAME] | Number | Index |  | Number | Coatings | Number | Old patients | New patients | Frame Type | Number |  |  |  |  |  | [NAME]
 |  |  | SV |  | 1.74 |  |  | Glacier Plus |  |  |  | L Metal |  |  |  |  |  |  | Ultimate
 |  |  | [NAME] |  | 1.67 |  |  | Glacier |  |  |  | L Plastic |  |  |  |  |  |  | Other
 | Average Order Value |  | AutoGraph III |  | 1.6 |  |  | Ulti MAR |  |  |  | M Metal
 |  |  | Auto FF |  | PolyC |  |  | Ulti MAR PLUS |  |  |  | M Plastic
 |  |  | AutoPlus |  | Trivex |  |  | HMC |  |  |  | Rimless
 |  |  | Ultimate Sig Plus |  | 1.5 |  |  | HMC Budget |  |  |  | Childrens
 |  |  | Ultimate HD Life |  | TOTAL |  |  | HC |  |  |  | Reglaze
 |  |  | Other |  |  |  |  | Trans GP |  |  |  | TOTAL
 | Average Disp Value |  | CL |  |  |  |  | Trans G
 |  |  | TOTAL |  |  |  |  | Trans Only/React |  |  |  | TOTAL FRAMES SOLD
 |  |  |  |  |  |  |  | Uncoated
 |  |  |  |  |  |  |  | TOTAL
 |  | Old Patient |  |  |  |  |  |  | 37.5 | 12.2 | 8.2 |  |  |  | SV |  | 1.74 |  |  |  | Glacier Plus
 |  | New Patient |  |  |  | STO |  |  | 57 | 24.4 | 9.2 |  |  |  | [NAME] |  | 1.67 |  |  |  | Glacier
 |  |  |  |  |  | Dispensing |  | L Metal | 83.4 | 14.7 |  |  |  |  | AutoGraph III |  | 1.6 |  |  |  | Ulti MAR
 |  |  | FRAME TOTAL |  |  | CL |  | L Plastic | 188.4 | 29.4 |  |  |  |  | Auto FF |  | PolyC |  |  |  | Ulti MAR PLUS
 |  |  |  |  |  |  |  | M Metal | 64.8 |  |  |  |  |  | AutoPlus |  | Trivex |  |  |  | HMC
 |  |  |  |  |  |  |  | M Plastic | 82.4 |  |  |  |  |  | Ultimate Sig Plus |  | 1.5 |  |  |  | HMC Budget
 |  |  |  |  |  |  |  | Rimless | 106.9 |  |  |  |  |  | Ultimate HD Life |  |  |  |  |  | HC
 |  |  |  |  |  |  |  | Childrens | 207.2 |  |  |  |  |  | Other |  |  |  |  |  | Trans GP
 |  |  |  |  |  |  |  | Reglaze |  |  |  |  |  |  | CL |  |  |  |  |  | Trans G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trans Only/React
 | ORDERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uncoated
 | Patient | [NAME] | Index | Coatings | Order | From | Date
 |  |  |  |  | Yes
 | Patient | [NAME] | Index | Coatings | Order | From | Date
 | [NAME] | AutoPlus | 1.67 | Trans GP | Yes | [NAME] | 2014-01-02 00:00:00
 | [NAME] | SV | 1.5 | HC | Yes | [NAME] | 2014-01-02 00:00:00
 | [NAME] | [NAME] | 1.5 | Uncoated | Yes | Ultimate | 2014-01-02 00:00:00
 | [NAME] | CL |  |  | Yes |  | 2014-01-02 00:00:00
 | [NAME] | SV | 1.5 | HC | Yes | [NAME] | 2014-01-02 00:00:00
 | [NAME] | SV | 1.5 | HC | Yes | [NAME] | 2014-01-02 00:00:00
 | [NAME] | Ultimate HD Life | PolyC | Ulti MAR | Yes | Ultimate | 2014-01-02 00:00:00