thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to compare budget against actual against several cost codes. Part of the analysis requires me to look at hired equipment and I am required to compare spends vs budgets in weekly periods. I am trying (based on the anticipated or known on and off hire dates) to "spread" the liability up to a certain period end:
<tbody>
</tbody>
Can anyone assist in guiding me on how to spread the costs listed in Column N between Columns R and Z? Some consumable items (shown in row 3) are also included and purchased as a one-off which also require factoring in.
Is this possible without a VBA? Hopefully someone can assist me.
Thanks
I'm trying to compare budget against actual against several cost codes. Part of the analysis requires me to look at hired equipment and I am required to compare spends vs budgets in weekly periods. I am trying (based on the anticipated or known on and off hire dates) to "spread" the liability up to a certain period end:
1 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI |
2 | PERIOD END | 28/02/2018 | WEEK COMMENCING | 01/01 | 08/01 | 15/01 | 22/01 | 29/01 | 05/02 | 12/02 | 19/02 | 26/02 | |||||||||||||||||||||||
3 | ON HIRE DATE | ANTICIPATED HIRE PERIOD (WEEKS) | ANTICIPATED OFF-HIRE PERIOD | STATUS (ON/OFF) | OFF HIRE DATE | REQ | BASIS OF HIRE | DELIVERY QUANTITY | UNIT | RATE | COST CODE | TOTAL | PERIOD | LIABILITY | INVOICED | ACCRUED | WEEK ENDING | 07/01 | 14/01 | 21/01 | 28/01 | 04/02 | 11/02 | 18/02 | 25/02 | 04/03 | |||||||||
01/02/18 | 6 | 15/03/18 | Van | 5 Days | 1 | 155.00 | 4 | 620.00 | ? | ? | ? | ? | |||||||||||||||||||||||
04/01/18 | 6 | OFF | 09/02/18 | Dumper Truck | 5 Days | 1 | 575.00 | 5.40 | 3,285.00 | ? | ? | ? | ? | ? | ? | ||||||||||||||||||||
07/03/18 | Blades | Purchased | 50 | 1.00 | 1 | 50.00 | 50.00 |
<tbody>
</tbody>
Can anyone assist in guiding me on how to spread the costs listed in Column N between Columns R and Z? Some consumable items (shown in row 3) are also included and purchased as a one-off which also require factoring in.
Is this possible without a VBA? Hopefully someone can assist me.
Thanks