Create excel spreadsheet
Budget: €250 – €750 EUR
Please makeit done on your end and show me screenshot and a short statement how it will work :
I need an excel spread sheet that can automatically tell me what vans checks have been completed and if they have been completed in a time frame of greater than 10 mins.
Needs to be able to automatically be updated once I drop in the new weeks excel file into the folder.
After the contest is awarded, the file needs to be able to automatically email sites asking why weekly vans checks were not completed or why weekly van checks not completed in a timeframe of greater than 10 mins. Emails address and email template will be given after contest is awarded.
The main file "Weekly van checks"
The data files "Weekly van checks VIC" and "Weekly van checks TAS"
If the van name is in the list of one of those data files then the weekly check has been completed. Check box column in main file "Weekly van check" file should have a green ticket.
If the van name is NOT in the data file list then the weekly van check has not been completed. Check box column in main file "weekkly van check" file should have a red cross.
If the van check was completed in a time frame of greater than 10 mins "time 10min" box column in the main file should have green tick.
If the van check was completed in a time frame of less than 10 mins "time 10min" box column in the main file should have a red cross.
I need an excel spread sheet that can automatically tell me what vans checks have been completed and if they have been completed in a time frame of greater than 10 mins.
Needs to be able to automatically be updated once I drop in the new weeks excel file into the folder.
After the contest is awarded, the file needs to be able to automatically email sites asking why weekly vans checks were not completed or why weekly van checks not completed in a timeframe of greater than 10 mins. Emails address and email template will be given after contest is awarded.
The main file "Weekly van checks"
The data files "Weekly van checks VIC" and "Weekly van checks TAS"
If the van name is in the list of one of those data files then the weekly check has been completed. Check box column in main file "Weekly van check" file should have a green ticket.
If the van name is NOT in the data file list then the weekly van check has not been completed. Check box column in main file "weekkly van check" file should have a red cross.
If the van check was completed in a time frame of greater than 10 mins "time 10min" box column in the main file should have green tick.
If the van check was completed in a time frame of less than 10 mins "time 10min" box column in the main file should have a red cross.