Amending/creating macros on spreadsheet
Budget: £20 – £250 GBP
1. Timesheet tab. Each row should be linked to the corresponding row on the weekly timesheet but when you press calculate, it takes the names from the correct weeks of the weekly timesheet. Eg if I select weeks 41 to 44, it should take the names from week 44 and place them accordingly on the table on the timesheet tab. This is the main table on this tab I am referring to. It should also provide the correct number of hours for the weeks selected eg weeks 41 to 44 in column D, total hours.
2. There should be an NI column added after holiday paid. The NI calc is ((hourly rate x hrs) + (holiday pay) - (758)) x 15.05%. Total paid should now include NI also After Total paid There should then be another column which is called 'max B hrs' then 'C hrs' then 'C hourly' then 'C total'. C hrs is total hours - max B hours. C total is c hrs x c hourly when pressing calculate, the total hours should be brought in split. So if 150 hours is imported from the weekly timesheet into total hours and max B hrs is 0, then 150 would go into the total hours cell. If however max b hrs was 60, then 60 would go into the total hours cell and therefore 90 would go into c hours. There should then be a total column which includes total paid (salary+holiday+ni)+(C total)
3. NI should not be able to give a minus figure
4. The timesheet tab only should be password protected. There should then be a new tab and on that tab it also has the same calculate button with weeks to select. This button would work in the same way as the button on the ‘timesheet’ tab but would only provide the following information to viewer:
Select which weeks
Calculate button
Total paid which would be p26 from the timesheet tab
2. There should be an NI column added after holiday paid. The NI calc is ((hourly rate x hrs) + (holiday pay) - (758)) x 15.05%. Total paid should now include NI also After Total paid There should then be another column which is called 'max B hrs' then 'C hrs' then 'C hourly' then 'C total'. C hrs is total hours - max B hours. C total is c hrs x c hourly when pressing calculate, the total hours should be brought in split. So if 150 hours is imported from the weekly timesheet into total hours and max B hrs is 0, then 150 would go into the total hours cell. If however max b hrs was 60, then 60 would go into the total hours cell and therefore 90 would go into c hours. There should then be a total column which includes total paid (salary+holiday+ni)+(C total)
3. NI should not be able to give a minus figure
4. The timesheet tab only should be password protected. There should then be a new tab and on that tab it also has the same calculate button with weeks to select. This button would work in the same way as the button on the ‘timesheet’ tab but would only provide the following information to viewer:
Select which weeks
Calculate button
Total paid which would be p26 from the timesheet tab