Hi Andrew - thank you for responding
I have attached the file. This was originally sorted by one of your colleagues but seems to have some issues.
You will see that some of the choices are giving N/A or VALUE! responses. But also, if you look at the top section, under CCG - Cellulitis - the choice is Airedale, Wharefedale etc - and if you look at the value given for cost is it £964.20, but on the actual sheet the value should be £248,764. This means the cost per episode value is also very wrong. Hope this makes sense and you can sort this for me
That one seems to work OK - and I think I can make this apply to all other cells - have you had chance to look at the other issues with the error messages?
If you look at the sheet provided labelled Analysis Tool the problem is when you select Hosiery Spend per 1000 patients or Total Hosiery Spend you get error messages in cells P8, Q8 and R8 and down from there
There is also a similar issue when you select CCG population - see cell G19, 20 et al for this issue
The file has become corrupt in that the middle table has the wrong values - only noticed it when I tried to show it to a colleague ???
Not yet - the file is not compiled correctly. If you look at the middle table it should run from the worksheet entitles CCG List Lower Limb Ulcer - but it runs from the worksheet CCG List Cellulitis and therefore gives the same results as the top table. The INDEX sum needs changing to the correct worksheet
I tried that but on things like CCGpopulation etc I then get an N?A response - is it possible you could change the sheet to point to the correct worksheet?
Yes - the one marked CCG List Lower Limb Ulcer for the middle table and the bottom table should be a combination of both - need this quite urgently please
Yes please - and the average in the lower table needs to work out the average of those 2 values
But this is the work that should have been done the first time? I am desperate so if needed I will pay again but if this had been done the first time around it wouldn't need doing now
I have opened another question - please let me know when you get it
Should be there now?
How do I get the table?
The only thing I am getting are these responses from you?
Yes that looks OK - the bottom section now needs to be a combination of the 2 other sections, and the weighted average needs to work out the average of the 2 as well please
I responded to say the middle box seems ok now the bottom book needs to be a combination of the two top boxes and the bottom weighted national average should be a combination as well
Actually can you look at the weighted national average in the top section - when I choose cost the figure just can't be right - the figures are up in the hundreds of thousands and the average in below 1000 ?