...
Contract | PO Number | Pay Item | Bill Item | Contractor Name | Service | Week End Date | WorkDay | Pay Qty | Unit | Pay Rate | Pay Net Value | Bill Qty | Bill RateBill Net Value | ||
123015011 | 78932 | 50 | 60 | Bloggs, Joe | |||||||||||
3000456 | 09/01/2022 | 03/01/20112022 | 8 | HR | 88.25706 | 8 | 105.90 | 847.20 | 3000456 | ||||||
023000456 | 09/01/2022 | 04/01/20112022 | 8 | HR | 88.25706 | 8 | 105.90 | 847.20 | 3000456 | ||||||
033000456 | 09/01/2022 | 05/01/20112022 | 8 | HR | 88.25 | 706 | 8 | 105.90 | 847.20 | ||||||
TOTAL: | 242118 | 24 | 2541.60 | ||||||||||||
123005111 | 84527 | 30 | 25 | Smith, John | |||||||||||
3000458 | 09/01/2022 | 03/01/20112022 | 10 | HR | 90.25 | 902.5 | 10 | 112.82 | 1128.20 | 3000458 | |||||
023000458 | 09/01/2022 | 04/01/20112022 | 10 | HR | 90.25902.5 | 10 | 112.821128.20 | ||||||||
TOTAL: | 20 | 1805 | 20 | 225.64 | 2256.40 |
In the example above, the import data is not formatted correctly because the data includes grouping rows with summed totals. The next example shows the same data but this time formatted correctly to remove the grouping and grouped totals:
Contract | PO Number | Pay Item | Bill Item | Contractor Name | Service | Week End Date | WorkDay | Qty | Unit | Rate | Net Value | Bill Qty | Bill Rate | Bill Net Value |
123015011 | 78932 | 50 | 60 | Bloggs, Joe | 3000456 | 09/01/2022 | 03/01/20112022 | 8 | HR | 88.25 | 706 | 8 | 105.90847.20 | |
123015011 | 78932 | 50 | 60 | Bloggs, Joe | 300045602 | 09/01/2022 | 04/01/20112022 | 8 | HR | 88.25706 | 8 | 105.90847.20 | ||
123015011 | 78932 | 50 | 60 | Bloggs, Joe | 3000456 | 0309/01/2022 | 05/01/20112022 | 8 | HR | 88.25706 | 8 | 105.90847.20 | ||
123015111 | 84527 | 30 | 25 | Smith, John | 3000458 | 09/01/2022 | 03/01/20112022 | 10 | HR | 90.25902.5 | 10 | 112.821128.20 | ||
123015111 | 84527 | 30 | 25 | Smith, John | 300045802 | 09/01/2022 | 04/01/20112022 | 10 | HR | 90.25902.5 | 10 | 112.821128.20 |