What is the best way to 'hide' calculation cells or numbers in Excel while keeping same end result?
Essentially, my job is to calculate costs for a tour group. My sales team who I work with is extremely stingy with budget, and they often like to open my excel and mess with my margins.
The margins I'm talking about are profit margins - for most other markets we dedicate a small percentage (3% or less) of the budget as 'operational costs', which is used in case there's a fuckup when the tour is ongoing. If not, it gets calculated as profits anyways and everyone goes home happy.
The problem is that lately my team keeps getting into my excel sheets and incorporates my safety margin into their profit, leaving me with no money to work with in case there's a fuckup. And yes, the policy of my seniors and my team leader is to just 'hide it', because no other market messes with our calculations.
Anyways, my point is:
Given a sheet like this:
| Items | Cost |
|---|---|
| Bus | 15 |
| Hotel | 30 |
| Margin | 5 |
| Total | 50 |
What's the most untraceable way to hide the 'margin' column?
Currently what I've been doing is to hide the margin in the bus section, but it gets really complicated to track.
| Items | Cost |
|---|---|
| Bus | 20 |
| Hotel | 30 |
| Total | 50 |
It also gets troublesome if the sales ever starts to realize that the bus fee is different every time.
Any tips?
[link] [comments]
Want to read more?
Check out the full article on the original site