Spreadsheet: 220746d1363257684-index-and-match-testgarysinvoicingsheet13v2
Sheet: Summary-March

INVOICING - MARCH (weeks 9 to 13) |  | 2013-03-01 00:00:00 | 41364
 |  | 41334 |  | 9 |  |  | If only i could figure out conditional formatting so that the whole columns would go red!!
 |  |  |  |  |  |  | WEEK 09
CUSTOMER LIST | Class Hours this Month | Travel/Other this Month | Total Billing Hours | Total (Euros)at shown Hourly Rate |  | CUSTOMER | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Monthly Total | Monthly Total | OVERALL
School1 |  |  | Hourly Rate-> | 25 |  | CLASS/STUDENT/TRAVEL | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | Travel |  | Class time | Travel | TOTALS
IT-E-EN-G-531 | 8 | 0 | 8 | 200 |  | ISTA 14 |  |  |  |  |  |  |  |  | 0 | 0 | 0
IT-E-EN-G-441c | 0 | 0 | 0 | 0 |  | RWE 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0
IT-E-EN-E-556 | 0 | 0 | 0 | 0 |  | ISTA 14 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  | [NAME] |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  | Englisch Conversation |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 8 | 0 | 8 | 200 |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
School2 |  |  | Hourly Rate-> | 55 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
ISTA 14 | 14 | 0 | 14 | 770 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 14 | 0 | 14 | 770 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
School3 |  |  | Hourly Rate-> | 20 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
RWE 1 | 8 | 0 | 8 | 160 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
RWE 2 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Englisch Conversation | 8 | 0 | 8 | 160 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Student 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Student 2 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 4 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 16 | 0 | 16 | 320 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
School4 |  |  | Hourly Rate-> | 20 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
[NAME] | 8 | 0 | 8 | 160 |  |  | WEEK 10 |  |  |  |  |  |  |  | 0 | 0 | 0
[NAME] und Verwaltungsklasse | 0 | 0 | 0 | 0 |  | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Monthly Total | Monthly Total | OVERALL
Einzelunterricht Mitarbeiter [NAME] | 0 | 0 | 0 | 0 |  | Class Date | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | Travel |  | Class time | Travel | TOTALS
Class X | 0 | 0 | 0 | 0 |  | ISTA 14 |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class Y | 0 | 0 | 0 | 0 |  | RWE 1 |  |  |  |  | 2 |  |  |  | 2 | 0 | 2
 | 8 | 0 | 8 | 160 |  | ISTA 14 |  | 2 |  |  |  |  |  |  | 2 | 0 | 2
School5 |  |  | Hourly Rate-> | 35 |  | [NAME] | 2 |  |  |  |  |  |  |  | 2 | 0 | 2
[NAME] | 0 | 0 | 0 | 0 |  | Englisch Conversation | 2 |  |  |  |  |  |  |  | 2 | 0 | 2
 | 0 | 0 | 0 | 0 |  | IT-E-EN-G-531 |  | 4 |  |  |  |  |  |  | 4 | 0 | 4
 | 0 | 0 | 0 | 0 |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Frau Fischer |  |  | Hourly Rate-> | 30 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Frau Fischer / Class 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
New Customer 1 / Class 2 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
New Customer 1 / Class 3 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
School7 |  |  | Hourly Rate-> | 120 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 2 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 3 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 4 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Class 5 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 0 | 0 | 0 | 0 |  |  | WEEK 11 |  |  |  |  |  |  |  | 12 | 0 | 12
NEW CUSTOMER 3 |  |  | Hourly Rate-> | 0 |  | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Monthly Total | Monthly Total | OVERALL
Class 1 | 0 | 0 | 0 | 0 |  | Class Date | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | Travel |  | Class time | Travel | TOTALS
Class 2 | 0 | 0 | 0 | 0 |  | ISTA 14 |  | 2 |  |  |  |  |  |  | 2 | 0 | 2
Class 3 | 0 | 0 | 0 | 0 |  | RWE 1 |  | 2 |  |  |  |  |  |  | 2 | 0 | 2
 | 0 | 0 | 0 | 0 |  | ISTA 14 | 2 |  |  |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | [NAME] |  |  |  | 2 |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | Englisch Conversation |  |  |  |  | 2 |  |  |  | 2 | 0 | 2
MONTHLY TOTALS: | 46 | 0 | 46 | 1450 |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
CROSS CHECK:- | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | WEEK 12 |  |  |  |  |  |  |  | 10 | 0 | 10
 |  |  |  |  |  | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Monthly Total | Monthly Total | OVERALL
 |  |  |  |  |  | Class Date | 2013-03-17 00:00:00 | 2013-03-18 00:00:00 | 2013-03-19 00:00:00 | 2013-03-20 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | Travel |  | Class time | Travel | TOTALS
 |  |  |  |  |  | ISTA 14 | 2 |  |  |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | RWE 1 |  | 2 |  |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | ISTA 14 |  |  | 2 |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | [NAME] |  |  |  | 2 |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | Englisch Conversation |  |  |  |  | 2 |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  | 2 |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | WEEK 13 |  |  |  |  |  |  |  | 14 | 0 | 14
 |  |  |  |  |  | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Monthly Total | Monthly Total | OVERALL
 |  |  |  |  |  | Class Date | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00 | Travel |  | Class time | Travel | TOTALS
 |  |  |  |  |  | ISTA 14 | 2 |  |  |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | RWE 1 |  | 2 |  |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | ISTA 14 |  |  | 2 |  |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | [NAME] |  |  |  | 2 |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | Englisch Conversation |  |  |  |  | 2 |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  | 2 |  |  |  |  | 2 | 0 | 2
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | Total: |  |  |  |  |  |  |  |  | 12 | 0 | 12
 |  |  |  |  |  | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  | Class Time | 2013-03-31 00:00:00 | 2013-04-01 00:00:00 | 2013-04-02 00:00:00 | 2013-04-03 00:00:00 | 2013-04-04 00:00:00 | 2013-04-05 00:00:00 | Travel |  | Class time | Travel | TOTALS
 |  |  |  |  |  | ISTA 14 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | RWE 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | ISTA 14 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | Englisch Conversation |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | IT-E-EN-G-531 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | Total: |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY TOTAL CLASS | MONTHLY TOTAL TRAVEL | OVERALL MONTHLY TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 0 | 48