Morning Gurus
Well it is morning in the UK & on Grand National Day - I fancy Majestic Concorde.
Anyway please would you kindly help me.
I am trying to devise a Cost Spreadsheet based on a Shift Pattern. As you will see from the attached spreadsheet I have achieved the end result but poorly I may add.
Firstly and to avoid any problems - am I correct in assuming that you can name a variable and assign that variable a value? I am assuming you can and would dearly like to use that as Tariffs may vary from here on in.Incidentally the Tariff is the same throughout.
Now to try to explain: The spreadsheet is setup Rows 3 - 368 in daily format and the Shift Pattern is indicated M - Mornings A - Afternoons N - Nights. The hours per shift vary as follows: M = 7.2 hours A = 8.2 hours N = 7.8 hours D = 7.4 hours. Tariff is assumed to 10.5 (But will change).
Columns AH - BH crudely capture the cost/per man/per shift but if you look at the Formula in the cell it uses the VARIABLE declared in Sheet 2 and it is all manually input. I don't like this as it is laborious to populate and errors can occur. Hence Variable. The COLUMN's F - AF lay out the shift pattern and I would like the calculation to emanate from there if possible, so that if I changed the shift pattern by merely editing the A for Afternoons to N for Nights, the calculation would happen automatically.
Also I have staged the calculation COLUMN's AH-BH Capture the DAILY COST then COLUMN's BJ-BP Calculate the COST PER SHIFT then COLUMN's BR-BX Calculate the WEEKLY COST PER SHIFT and then finally COLUMN's BZ-CF calculate the PERIOD COSTS PER SHIFT.
Could it be simpler to end up with the PERIOD COSTS PER SHIFT ?
I tried but could not figure it, so I thought that I would ask you guru's for help please.
Regards
Tezza73
TEST-PATT.xls
Saqib