Spreadsheet: 866660d1713551279-continue-to-my-last-thread-discussion-sample-2
Sheet: new working

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My working
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project 1 |  |  |  |  |  |  |  |  |  | Project 2
 | Position ID | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total Q1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | project 1 | project 2 | project 3 | Total |  | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 |  |  |  | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7
 | 1 | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13000 | 21000 | 25000 | 33000 | 41000 | 47000 |  |  |  |  | 13000 | 21000 | 25000 | 33000 | 41000 | 47000
 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | 5000 | 6000 | 6000 | 4000 | 6000 | 6000 | 3000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - I can't limit to [NAME] figure of project total
 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - and when project 1 allocation done project 2 pick the remaining cost of same period and move on |  |  |  |  |  |  |  |  |  | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000
 | 5 | 3000 | 4000 | 4074.44 | 4000 | 3000 | 3000 | 3000
 | 6 | 4000 | 4000 | 4000 | 4000 | 3000 | 3000 | 3000
 | 7 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result should be requried
 | 8 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project 1 |  |  |  |  |  |  |  |  |  | Project 2 |  |  |  |  |  |  |  |  |  | Project 3
 | 9 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total | [NAME] for Project 1 |  | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total | [NAME] for Project 2 |  | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total | [NAME] for Project 3
 | 10 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5800 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 2200 | 4000 | 7900 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 100 | 8000 | 1300
 | 11 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 12 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 13 | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000
 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 15 | 5000 | 6000 | 6000 | 4000 | 6000 | 6000 | 3000
 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 17 | 3000 | 4000 | 4074.44 | 4000 | 3000 | 3000 | 3000
 | 18 | 4000 | 4000 | 4000 | 4000 | 3000 | 3000 | 3000
 | 19 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 20 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 21 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 22 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 23 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 24 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 25 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 26 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | 27 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000