Spreadsheet: 755375d1636817945-reference-every-8th-cell-from-another-sheet-easily-analyze-data-from-proper-data-set-using-pivot-table-engineeringstudent-
Sheet: Awarded Production 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Name |  | MONTH OF APRIL 2021 |  |  |  |  |  |  |  | MONTH OF MAY 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORECAST LABOR |  | ACTUAL LABOUR |  | FORECAST MATERIAL |  | ACTUAL MATERIAL |  | FORECAST LABOR |  | ACTUAL LABOUR |  | FORECAST MATERIAL |  | ACTUAL MATERIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production | Cost | Production | Cost | Production | Cost | Production | Cost | Production | Cost | Production | Cost | Production | Cost | Production | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 1 |  | 4 | 400 | 7 | 700 | 10 | 1000 | 13 | 1300 | 3 | 300 | 6 | 600 | 9 | 900 | 12 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 2 |  | 3 | 300 | 6 | 600 | 9 | 900 | 12 | 1200 | 2 | 200 | 5 | 500 | 8 | 800 | 11 | 1100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 3 |  | 2 | 200 | 5 | 500 | 8 | 800 | 11 | 1100 | 4 | 400 | 7 | 700 | 10 | 1000 | 13 | 1300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project | Proj 1
 |  |  |  |  |  |  |  |  |  |  | Month | Project | Forcast/Actual | Labor/Material | Production/Cost | Values |  | Production/Cost | Cost
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Forcast | Labor | Production | 4
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Forcast | Labor | Cost | 400 |  | Sum of Values2 |  | Labor/Material | Forcast/Actual
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Actual | Labor | Production | 7 |  |  |  | Labor |  | Material |  | Grand Total
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Actual | Labor | Cost | 700 |  | Years | Month | Forcast | Actual | Forcast | Actual
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Forcast | Material | Production | 10 |  | 2021 | Apr | 400 | 700 | 1000 | 1300 | 3400
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Forcast | Material | Cost | 1000 |  |  | May | 300 | 600 | 900 | 1200 | 3000
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Actual | Material | Production | 13 |  | Grand Total |  | 700 | 1300 | 1900 | 2500 | 6400
 |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | Proj 1 | Actual | Material | Cost | 1300
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Forcast | Labor | Production | 3
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Forcast | Labor | Cost | 300
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Actual | Labor | Production | 6
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Actual | Labor | Cost | 600
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Forcast | Material | Production | 9
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Forcast | Material | Cost | 900
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Actual | Material | Production | 12
 |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | Proj 1 | Actual | Material | Cost | 1200