Re: Can this be done better? - 'selective protection'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Dan,

Thanks for responding.

Let me try to clarify & respond to your questions.

This spread*** is an 'output costing' model which maps the costs
from accounting ledgers to predefined outputs through a series of
matrix & cost drivers. Thus costs are cascaded down from lets say
'head office' to regional offices, costs can be cross charged by
regional offices and finally the resultant costs are apportioned via
drivers to outputs. This has been completed and works as required.

I am now looking at deployment & internal housekeeping. Initially
there will only be 5 or 6 people accessing the model, each one will be
responsible for a particular area, lets say head office & regions 1 to
5. Because the final figure to be apportioned by the output driver
consists of direct costs from the accounting system + contributions
from head office + regions 1 to 5 it is desirable that the user logged
in can only change the drivers associated with their area. This
ensures that they cannot change other area's drivers to reduce /
change the amount apportioned to them. You can then see it is also
desirable that they can follow the model's computations to see how the
amount apportioned to their area has been arrived at, thus they need
to see sheets not associated directly with their area. If they are not
happy with that amount internal negotiations will take place to
validate / change the cost driver basis.

Now to answer your questions specifically (assume sheets are protected
with relevant cells unprotected to allow data entry),

Data entry is required on approx 70% of the total no of sheets but
surely this is irrelevant.

As per original posting irrelevant sheets made UNavailable by changing
*** property to xlNoSelection. Thus they can see the *** but not
access it.

Audit Trail was a descriptive used in original posting. Initial users
are familiar with Excel and will follow the formula's and will have
been schooled in the model's operation.

Choice user has if they are interested and irrelevant.

Probably 5 or 6. My initial thoughts are 1 for each area. This might
change as the model develops and its use gets more widespread. It will
very much depend on company policy & internal housekeeping.

No

No

From external sources but not database / software related.

I hope this helps.

Regards

Michael



.

Quantcast