Forum Discussion
Project schedule
Is it possible for you to post not an image but the actual spreadsheet you created as the basis for that image?
It would help us help you if you did it that way. Otherwise, beyond just telling you, 'Yes, it's possible" if you want some actual help in creating the formula...please, a spreadsheet.
And for the sake of clarification: are you saying you'd be putting in 44 instead of the 48 that appears there now? And would it be fair or safe to assume that you could also be asking "if any of the other numbers change as well, what would need to be done in order for the bottom left cell to read 1750?" Or is it only the Sales employee who might vary from the standard 48?
In other words, is it that the 1750 needs to be held as a constant goal to be achieved, with the other hours somewhat malleable? And are there limits to how many can be malleable, or how much malleability is allowed?
Can you tell us more about the bigger picture here? I used to be Director of HR and Payroll systems for a major corporation. I don't recall ever being asked to create a sheet like this. Ever. It almost seems like a case of the tail wagging the dog. Why aren't we just totaling actual hours?
If you have the backup data, the daily travel schedules or whatever, would you be willing to post that? I think that what you really want is not only possible, but more desirable, as you seem to be saying yourself.
Let me ask: is this single page something you do for each individual to somehow represent a year's worth of work hours? If not that, what is it? What do these numbers represent? What's the reality behind them?
I ask not to pry, but because of my background in HR and payroll systems. But also, maybe even more so, because of my desire to design spreadsheets that make sense. And you seem to be saying that the way you've been doing things doesn't totally make sense. Please forgive me if I'm misrepresenting you on that; I'm just trying to make sense of this.
It's essentially used to determine yearly costs for each department.
I am not able to post the travel schedule but this really the meat of the information that I need to generate, everything else is secondary and has to be entered manually.
I'm going to try one more time to make sense of all this.
- It sounds like what you're doing is more for budget planning purposes. Is that correct?
- If that is the case, then the way you're doing it--which from your sample just involves manually entering numbers that definitely are rough estimates--seems fine. You could consider using more accurate fractional hours (e.g., 48.6; or use 48 for five months, 49 for seven) that would get you much closer to the 1750 total.
- Do you even need monthly figures (given that in your sample spreadsheet they vary not a whit, what's the value of showing them?!!)?
- If, on the other hand, you want to report reality--i.e., have true/actual data, which you seem to wish were the case--then it could be linked to the actual employee hours, and start to actually reflect that reality. But as it is, you are just juggling numbers to come up with a pre-determined total, and if that's what you've been asked to do, the way you're already doing it is as good as any other. Why quibble the small stuff?
Again, I'm probing this because from all you've said, what you have presented us with (at least from my perspective as a former HR/Payroll database manager) first needs to be addressed from the perspective of policy and practice; only later as an Excel question. Are we reflecting reality or primarily coming up with budgeting estimates? Either is legitimate, but which is it? Keep them separate.
- It sounds like what you're doing is more for budget planning purposes. Is that correct?