Forum Discussion
how to automate a payroll sheet?
I am trying to automate a sheet that I can enter in the model of the part and the amount and let it do the math on the hours worked. For example, if I assemble 100 pieces of the model "011" that is considered 8 hours of work, 50 is 4 hours, etc. however 100 of the model "010" is only 4 hours and 50 would be 2 hours, etc. so I need it to read column A for the date (Tuesday-Monday every week)read column b for the type and column c for the amount do the math on how many hours that is considered depending on the model and output every Tuesday column G...this is very complex so I'm not sure it's possible. it would just save me some time with the calculator
https://docs.google.com/spreadsheets/d/1Zp4vc5dWJLQVbSy7qbibA4PHA2rdcXF8GoU2GGT741U/edit?usp=sharing link to it if needed.
You need to grant edit access to that Google sheet if you expect help.
What you're asking is very easy in a spreadsheet. I'd create a table in which the formula would seek how much time to allocate to each unit of whatever model it is, and then use VLOOKUP to retrieve that.
What's not clear is what Tuesday has to do with it as compared to other days of the week.
2 Replies
You need to grant edit access to that Google sheet if you expect help.
What you're asking is very easy in a spreadsheet. I'd create a table in which the formula would seek how much time to allocate to each unit of whatever model it is, and then use VLOOKUP to retrieve that.
What's not clear is what Tuesday has to do with it as compared to other days of the week.
- my apologies, the permission is updated, as to why Tuesday, the work week ends Tuesday; however many parts of various models is done is recorded and then sent to the accounting firm to be paid to that employee. for example, if someone does 400 "011" parts from Wednesday 3/30/2022 to Saturday 4/2/2022 the amount would be 32 hours and that number will be sent to the accounting firm that following Tuesday 4/5/2022 and the employee would be direct deposited on Friday 4/8/2022. hopefully I have made that make more sense, and thanks in advance for the help.
