π³ 05/03 - 10:41 - so there is still an issue with Paulo Laurenco's empty return causing an issue with all following entries. it the value in sum of total is 0, it still needs to be picked up as an en
π³ 04/03 - 23:14 - i think the blank information from paulo is still creating an issue, payroll information for everyone alphabetically after Paulo is incorrect. Paulo Lorenco Testing Unpaid Leave 14/
π³ 04/03 - 22:56 - i've found the issue.. paulo laurenco is in the submitted schedule but has no values as he was on annual leave, if somebody is on the list but is missing a total sum, this needs to
π³ 04/03 - 22:37 - this is great!! but payroll total is 93190.42 and you are showing 92843.29 whats wrong? on the detailed timesheets records can you show all the headers from the upload?
π³ 04/03 - 22:26 - This is all wrong, start the full page code again. i will copy the uploaded data again, this is a xlsx file with column headers in row 1, employee names are in column a from row 2 o
π³ 04/03 - 22:13 - incorrect, each row is an employee entry and needs to be treated seperately. there are no total sums or subtotals, this needs to be captured by you. data is now uploaded as a spread
π³ 04/03 - 22:05 - still not working.. this is the data i'm uploading, why isnt this being picked up by the import function. Employee Name Department Job Start Date Sum of Shift hours Sum of Normal Ra
π³ 04/03 - 21:55 - i've redone the spreadsheet to only relevant info, use this for the page and data visualiation. Employee Name Department Job Start Date Sum of Shift hours Sum of Normal Rate Sum of
π³ 04/03 - 21:45 - incorrect, you've now found 1314 records, it should be 476. employee names arent shown on the detailed records register, no other relevant information has been found.
π³ 04/03 - 21:39 - column draw downs need to be static. employee name, normal rate, total, total overtime, job, will always be the same import spreadsheet columns.
π³ 04/03 - 16:11 - update the overtime hours graph to also show total overtime cost. the hours being read by other graphs should be shift hours. with the cost by job code include the top 10 jobs and f
π³ 04/03 - 15:52 - youre now not showing the employee's names correctly again in the timesheet records. 'Employee Name' is employee name, 'Normal Rate' is their standard rate of pay etc
π³ 04/03 - 12:39 - Maintain image size of charts, currently the chart size changes meaning the image scrolls up the screen as the information buffers