Spreadsheet: 288091d1389094898-how-do-i-make-a-daily-list-of-orders-into-one-weekly-list-with-no-rows-empty-cash-sheets-tmp-jan-2014
Sheet: SATURDAY 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
 |  |  | [NAME] |  | Date: |  |  |  | MONDAY CLINIC ALL DAY
 | Average Order Value |  | AutoGraph III
 |  |  | Auto FF |  | 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
 |  |  | AutoPlus | 1
 |  |  | Ultimate Sig Plus | 2
 |  |  | Ultimate HD Life | 3
 |  |  | Other | 4
 | Average Disp Value |  | CL | 5
 |  |  | TOTAL | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  | Old Patient |  | 11
 |  | New Patient |  | 12
 |  |  |  | 13
 |  |  | FRAME TOTAL | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 | ORDERS |  |  | 21
 |  |  |  | 22
 | Patient | [NAME] | Index
 |  |  |  |  | TOTALS |  |  |  |  |  |  |  | TOTAL VOUCHER VALUES |  |  |  |  |  | [NAME] | Index | Coating
 | Patient | [NAME] | Index |  |  |  |  | TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  | Total Across
 | [NAME] | AutoPlus | 1.67 |  |  |  | [NAME]
 | [NAME] | SV | 1.5 |  | Appointments |  | [NAME] | Number | Index |  | Number | Coatings | Number | Old patients | New patients | Frame Type | Number |  |  |  |  |  | [NAME]
 | [NAME] | [NAME] | 1.5 |  |  |  | SV |  | 1.74 |  |  | Glacier Plus |  |  |  | L Metal |  |  |  |  |  |  | Ultimate
 | [NAME] | CL |  |  |  |  | [NAME] |  | 1.67 |  |  | Glacier |  |  |  | L Plastic |  |  |  |  |  |  | Other
 | [NAME] | SV | 1.5 |  | Average Order Value |  | AutoGraph III |  | 1.6 |  |  | Ulti MAR |  |  |  | M Metal
 | [NAME] | SV | 1.5 |  |  |  | Auto FF |  | PolyC |  |  | Ulti MAR PLUS |  |  |  | M Plastic
 | [NAME] | Ultimate HD Life | PolyC |  |  |  | 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