Spreadsheet: 453489d1459343179-cannot-get-isna-to-work-in-formula-test-2016
Sheet: TEST

CUSTOMER NAME: |  |  |  |  |  |  | TOTAL CONTRACT SERVICES |  |  |  | TOTAL CONTRACT VALUE |  |  |  |  | PAYMENT TYPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTRACT | YES | SERVICE | LAWN | GARDEN | ENHANCE | LABOUR COST | 28 | JAN. | √ | MULCH | COST | INSTALLED | DELIVERED | 1
ADDRESS: |  |  |  |  |  |  | TOTAL EXTRA SERVICES |  |  |  | TOTAL [NAME] |  |  |  |  |  |  | FULL PAYMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXTRA |  | LAWN | SPRING LAWN | SPRING GARDEN | LAWN FERTILIZER (Spring) | LABOUR CHARGE | 45 | FEB. |  | UTILITY | 10 | 53 | 15 | 2
CITY / TOWN |  |  |  |  |  |  | TOTAL COMBINED SERVICES |  |  |  | TOTAL COMBINE VALUE |  |  |  |  |  |  | 2 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GARDEN | SUMMER LAWN | GARDEN CARE | LAWN FERTILIZER (Summer) | MAT. UPCHARGE | 1.5 | MAR. |  | CANADA RED | 29.75 | 76 | 45 | 3
 |  | NOTES |  |  |  |  |  |  |  |  | DISCOUNT |  | 0 |  |  |  |  | 3 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCE | FALL LAWN | FALL GARDEN | LAWN FERTILIZER (Fall) |  |  | APR. |  | PIN O-NOIR | 31.25 | 78 | 47 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPOST TOPDRESS |  |  | MAY |  | BLACK BEAUTY | 29 | 93 | 44 | 5
 |  |  | AGREEMENT |  | TIME | TIME | PRODUCT | PRODUCT |  | PRICE | SCHEDULED |  |  |  |  |  |  | 5 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corn Gluten (Spring) |  |  | JUN. |  | COMPOST | 17.5 | 50 | 27 | 6
SERVICE |  |  | TYPE | PRICE | SOLD | USED | QUANITIY | TYPE | VISITS | PER VISIT | VISITS | NOTES |  |  |  |  |  | 6 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corn Gluten (Summer) |  |  | JUL. |  |  |  |  |  | 7
SPRING LAWN |  |  | EXTRA | 425 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 1 |  |  | AUG.
SUMMER LAWN |  |  | CONTRACT |  |  |  |  |  |  | 75 | 24 |  |  |  |  |  |  | 8 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 2 |  |  | SEPT.
FALL LAWN |  |  | EXTRA | 575 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 3 |  |  | OCT.
SPRING GARDEN |  |  | EXTRA | 350 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 4 |  |  | NOV.
GARDEN CARE |  |  | CONTRACT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DETHATCHING |  |  | DEC.
FALL GARDEN |  |  | EXTRA | 700 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORE AERATION
LAWN FERTILIZER (Spring) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE MONTHLY FOR WORK COMPLETED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEASONAL PLANTING
LAWN FERTILIZER (Summer) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY REVENUE STATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Spring) GUTTERS
LAWN FERTILIZER (Fall) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EXTRA | TOTAL CONTRACT | SCHEDULED | COMBINED | ADDITOINAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Fall) GUTTERS
COMPOST TOPDRESS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH |  | CHARGE | CHARGE | PAYMENTS | TOTAL CHARGED | BILLING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEMATODES
CORN GLUTEN (SPRING) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (DRIVEWAY SPRAY)
CORN GLUTEN (SUMMER) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POISON IVY SPRAY
FIESTA 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MULCH INSTALLED
FIESTA 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MULCH DELIVERED
FIESTA 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (1)
FIESTA 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (2)
DETHATCHING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (3)
CORE AERATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (4)
SEASONAL PLANTING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER
(SPRING) GUTTERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER
(FALL) GUTTERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER
NEMATODES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER
(DRIVEWAY SPRAY)
POISON IVY SPRAY |  |  |  |  |  |  |  |  |  |  | PROD. USED |  |  |  |  | TOTAL SUMMARY
MULCH INSTALLED
ENHANCEMENT (1) |  |  | EXTRA | 2300 |  |  |  |  |  |  | Tree planting
ENHANCEMENT (2)
ENHANCEMENT (3)
ENHANCEMENT (4)
 |  |  |  | AGREEMENT |  |  |  |  |  |  |  | TOTAL |  |  |  | EXTRA LAB. | EXTRA MAT. | TOTAL EXTRA | CONTRACT LAB. | CONTRACT MAT. | TOTAL CONTRACT |  | NOTES
MONTH | DATE |  |  | TYPE | SERVICE | SPECIFIC SERVICE |  |  | START | FINISH | EMPLOYEES | TIME | LITRES | KG'S | YARDS | CHARGE | CHARGE | CHARGE | CHARGE | CHARGE | CHARGE | INVOICED
APR. | 2016-04-13 00:00:00 |  |  | EXTRA | LAWN | SPRING LAWN |  |  | 07:45:00 | 11:00:00 | 2
APR. | 2016-04-23 00:00:00 |  |  | CONTRACT | LAWN | SUMMER LAWN |  |  | 08:00:00 | 08:45:00 | 2
APR. | 2016-04-30 00:00:00 |  |  | EXTRA | GARDEN | SPRING GARDEN |  |  | 07:30:00 | 08:45:00 | 2
MAY | 2016-05-03 00:00:00 |  |  | CONTRACT | LAWN | SUMMER LAWN |  |  | 09:00:00 | 09:40:00 | 2