Apr 05 2021 10:26 AM
Apr 05 2021 10:26 AM
Hopefully this makes sense to you, as I'm trying to explain this from a novice view. I'm currently trying to build a very basic timesheet submission system for my work as everything is very manual and I want to try and automate it a bit.
On the workbook I have, I have two worksheets: one that pulls in data from the form submissions and one that does all of the attendance calculations. I wanted to keep them separate just for simplicity. I have broken down the attendance sheet into the following:
- Hours submitted to date
- Expected hours
- Attendance %
What I basically want to do is every time a student submits their hours, I want to auto-calculate the total hours to date, the total expected hours, and also the total attendance so far by taking the data from the submission worksheet and putting it into the calculation worksheet. Obviously, I put the formula in manually, but I have to do this over 200 times, so I'm trying to find a way around this.
If anyone has any ideas on how to do this, please do let me know.
Apr 05 2021 10:48 AM
Maybe I am not the most suitable to give you a solution to this problem, but with your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Apr 05 2021 11:07 AM
Apr 05 2021 12:51 PM
Could you please clarify your sample
- how week starts on Apr 26 and ends on Apr 14 and why there are 12 days in the week?
- Hours expected for today - if we are in the middle of the week, e.g on Wed, shall we take all hours expected for the week or take them till Wed? If the latest, what is the logic is used to calculate?
- if student reported few weeks and we are in the middle of the week, shall we take hours reported for the current week or we calculate only finished weeks?