Spreadsheet: 800974d1666017535-calculation-of-different-sets-of-cells-depending-on-the-content-of-a-separate-cell-test-document
Sheet: Test Spreadsheet

 | Test Spreadsheet |  |  |  | Fill In | 2
 | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q4
 |  | FY - Plots |  | Q1 - Business Plan | Q1 - Actual | Q1 - Variance |  |  | FY - Plots |  | Q2 - Business Plan | Q2 - Actual | [NAME] |  |  | FY - Plots |  | Q3 - Business Plan | Q3 - Actual | [NAME] |  |  | FY - Plots |  | Q4 - Business Plan | Q4 - Actual | [NAME]
 | Site 1 | 4 |  | 2 | 0 |  |  | Site 1 | 4 |  | 2 | 0 |  |  | Site 1 | 4 |  | 0 | 0 |  |  | Site 1 | 4 |  | 0 | 0
 | Site 2 | 36 |  | 1 | 0 |  |  | Site 2 | 36 |  | 12 | 0 |  |  | Site 2 | 36 |  | 13 | 0 |  |  | Site 2 | 36 |  | 10 | 0
 | Site 3 | 40 |  | 3 | 0 |  |  | Site 3 | 40 |  | 16 | 0 |  |  | Site 3 | 40 |  | 10 | 0 |  |  | Site 3 | 40 |  | 11 | 0
 | Site 4 | 36 |  | 5 | 0 |  |  | Site 4 | 36 |  | 9 | 0 |  |  | Site 4 | 36 |  | 12 | 0 |  |  | Site 4 | 36 |  | 10 | 0
 | Site 5 | 18 |  | 0 | 0 |  |  | Site 5 | 18 |  | 0 | 0 |  |  | Site 5 | 18 |  | 6 | 0 |  |  | Site 5 | 18 |  | 12 | 0
 | Site 6 | 8 |  | 0 | 0 |  |  | Site 6 | 8 |  | 0 | 0 |  |  | Site 6 | 8 |  | 0 | 0 |  |  | Site 6 | 8 |  | 8 | 0
 | Site 7 | 8 |  | 0 | 0 |  |  | Site 7 | 8 |  | 0 | 0 |  |  | Site 7 | 8 |  | 0 | 0 |  |  | Site 7 | 8 |  | 8 | 0
 | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
 |  | FY - Net Revenue |  | Q1 - Business Plan | Q1 - Actual | Q1 - Variance |  |  | FY - Net Revenue |  | Q2 - Business Plan | Q2 - Actual | [NAME] |  |  | FY - Net Revenue |  | Q3 - Business Plan | Q3 - Actual | [NAME] |  |  | FY - Net Revenue |  | Q4 - Business Plan | Q4 - Actual | [NAME]
 | Site 1 | 2248849 |  | 1084900 | 0 |  |  | Site 1 | 2248849 |  | 1163949 | 0 |  |  | Site 1 | 2248849 |  | 0 | 0 |  |  | Site 1 | 2248849 |  | 0 | 0
 | Site 2 | 14066627 |  | 281995 | 0 |  |  | Site 2 | 14066627 |  | 4813491 | 0 |  |  | Site 2 | 14066627 |  | 5204438 | 0 |  |  | Site 2 | 14066627 |  | 3766703 | 0
 | Site 3 | 9225716 |  | 722985 | 0 |  |  | Site 3 | 9225716 |  | 3278976 | 0 |  |  | Site 3 | 9225716 |  | 2051307 | 0 |  |  | Site 3 | 9225716 |  | 3182448 | 0
 | Site 4 | 8566320 |  | 1390997 | 0 |  |  | Site 4 | 8566320 |  | 2151741 | 0 |  |  | Site 4 | 8566320 |  | 2458592 | 0 |  |  | Site 4 | 8566320 |  | 2564990 | 0
 | Site 5 | 4082553 |  | 0 | 0 |  |  | Site 5 | 4082553 |  | 0 | 0 |  |  | Site 5 | 4082553 |  | 1558000 | 0 |  |  | Site 5 | 4082553 |  | 2524553 | 0
 | Site 6 | 2377812 |  | 0 | 0 |  |  | Site 6 | 2377812 |  | 0 | 0 |  |  | Site 6 | 2377812 |  | 0 | 0 |  |  | Site 6 | 2377812 |  | 2377812 | 0
 | Site 7 | 2085242 |  | 0 | 0 |  |  | Site 7 | 2085242 |  | 0 | 0 |  |  | Site 7 | 2085242 |  | 0 | 0 |  |  | Site 7 | 2085242 |  | 2085242 | 0
 | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
 |  | FY - Gross Margin |  | Q1 - Business Plan | Q1 - Actual | Q1 - Variance |  |  | FY - Gross Margin |  | Q2 - Business Plan | Q2 - Actual | [NAME] |  |  | FY - Gross Margin |  | Q3 - Business Plan | Q3 - Actual | [NAME] |  |  | FY - Gross Margin |  | Q4 - Business Plan | Q4 - Actual | [NAME]
 | Site 1 | 497429 |  | 239963 | 0 |  |  | Site 1 | 497429 |  | 257466 | 0 |  |  | Site 1 | 497429 |  | 0 | 0 |  |  | Site 1 | 497429 |  | 0 | 0
 | Site 2 | 3336604 |  | 66889 | 0 |  |  | Site 2 | 3336604 |  | 1141760 | 0 |  |  | Site 2 | 3336604 |  | 1234493 | 0 |  |  | Site 2 | 3336604 |  | 893462 | 0
 | Site 3 | 2102541 |  | 164768 | 0 |  |  | Site 3 | 2102541 |  | 747279 | 0 |  |  | Site 3 | 2102541 |  | 465214 | 0 |  |  | Site 3 | 2102541 |  | 725280 | 0
 | Site 4 | 1846899 |  | 299899 | 0 |  |  | Site 4 | 1846899 |  | 299899 | 0 |  |  | Site 4 | 1846899 |  | 530073 | 0 |  |  | Site 4 | 1846899 |  | 553012 | 0
 | Site 5 | 813254 |  | 0 | 0 |  |  | Site 5 | 813254 |  | 0 | 0 |  |  | Site 5 | 813254 |  | 310357 | 0 |  |  | Site 5 | 813254 |  | 502897 | 0
 | Site 6 | 447504 |  | 0 | 0 |  |  | Site 6 | 447504 |  | 0 | 0 |  |  | Site 6 | 447504 |  | 0 | 0 |  |  | Site 6 | 447504 |  | 447504 | 0
 | Site 7 | 418717 |  | 0 | 0 |  |  | Site 7 | 418717 |  | 0 | 0 |  |  | Site 7 | 418717 |  | 0 | 0 |  |  | Site 7 | 418717 |  | 418717 | 0
 | Abortives | -100000 | - | -25000 | 0 |  |  | Abortives | -100000 | - | -25000 | 0 |  |  | Abortives | -100000 | - | -25000 | 0 |  |  | Abortives | -100000 | - | -25000 | 0
 | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
 |  | FY - Overheads |  | Q1 - Business Plan | Q1 - Actual | Q1 - Variance |  |  | FY - Overheads |  | Q2 - Business Plan | Q2 - Actual | [NAME] |  |  | FY - Overheads |  | Q3 - Business Plan | Q3 - Actual | [NAME] |  |  | FY - Overheads |  | Q4 - Business Plan | Q4 - Actual | [NAME]
 | Total | 2403423 |  | 600855 | 0 |  |  | Total | 2403423 |  | 600856 | 0 |  |  | Total | 2403423 |  | 600856 | 0 |  |  | Total | 2403423 |  | 600856 | 0
 | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
 |  | FY - Operating Profit |  | Q1 - Business Plan | Q1 - Actual | Q1 - Variance |  |  | FY - Operating Profit |  | Q2 - Business Plan | Q2 - Actual | [NAME] |  |  | FY - Operating Profit |  | Q3 - Business Plan | Q3 - Actual | [NAME] |  |  | FY - Operating Profit |  | Q4 - Business Plan | Q4 - Actual | [NAME]
 | Total |  |  | 145664 |  |  |  | Total |  |  | 1984564 |  |  |  | Total |  |  | 1914281 |  |  |  | Total |  |  | 2915016
 | YTD
 |  | FY - Plots |  | YTD - Business Plan | YTD - Actual | YTD - Variance
 | Site 1 | 4 |  |  | 0
 | Site 2 | 36
 | Site 3 | 40
 | Site 4 | 36
 | Site 5 | 18
 | Site 6 | 8
 | Site 7 | 8
 | Total
 | YTD
 |  | FY - Net Revenue |  | YTD - Business Plan | YTD - Actual | YTD - Variance
 | Site 1 | 2248849
 | Site 2 | 14066627
 | Site 3 | 9225716
 | Site 4 | 8566320
 | Site 5 | 4082553
 | Site 6 | 2377812
 | Site 7 | 2085242
 | Total
 | YTD
 |  | FY - Gross Margin |  | YTD - Business Plan | YTD - Actual | YTD - Variance
 | Site 1 | 497429
 | Site 2 | 3336604
 | Site 3 | 2102541
 | Site 4 | 1846899
 | Site 5 | 813254
 | Site 6 | 447504
 | Site 7 | 418717
 | Abortives | -100000 | -
 | Total
 | YTD
 |  | FY - Overheads |  | YTD - Business Plan | YTD - Actual | YTD - Variance
 | Total | 2403423
 | YTD
 |  | FY - Operating Profit |  | YTD - Business Plan | YTD - Actual | YTD - Variance
 | Total