Create excel spreadsheet

  • Status: Closed
  • Præmier: $200
  • Modtagne indlæg: 9
  • Vinder: audreysur

Konkurrence Instruktioner

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.

Main file must have a red theme and must be formatted correctly and professionally.

The file must include dates for up until the beginning of 2024

File must be easy to use. Must be able to easily change van names and add new van names without breaking the file.

Top and side menus should be frozen, so they are still visible when scrolling down and sideways

**The green ticks and red crosses in the two data files "VIC" and 'TAS" are irrelevant. They do not mean anything for the purpose of this contest.

***Any entries that are uploaded with random pictures of excel files not related to this contest will automatically be rejected. Only upload an entry once you have made a suitable entry to submit.

Additional thought after posting the contest. In the time frame box maybe put the actual time in minutes the van check was taken to complete. Then conditional formatting to turn the cell green if greater than 10mins and red if less than 10mins.

Anbefalede færdigheder

Arbejdsgiverfeedback

“Beyond amazing! Next level insane. Her work is of the highest quality and if you don’t use her for excel projects you are crazy! There is simply no one matter!”

Profilbillede totallynumbered, Australia.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • Farrukh Saeed
    Farrukh Saeed
    • 2 måneder siden

    I am working on it. plz wait till deadline

    • 2 måneder siden
  • mondalsagar1245
    mondalsagar1245
    • 2 måneder siden

    Hello plase to my project

    • 2 måneder siden
  • Dnogues
    Dnogues
    • 2 måneder siden

    Ready to make my first project on Freelance! looking forward to get my first review!

    • 2 måneder siden
  • mna9226
    mna9226
    • 2 måneder siden

    Please consider my Entry#37. Feel free to contact me for more automation.

    • 2 måneder siden
  • ropakbarmon2
    ropakbarmon2
    • 2 måneder siden

    *READY to start NOW !!** I am really happy to see your job post on Freelncer. I would like to inform you .that I have a great work experience I will Perform your task perfectly.

    • 2 måneder siden
  • nournadam
    nournadam
    • 2 måneder siden

    hello, I noticed that there are some hidden rows is it required for something or can be eliminated, thank you

    • 2 måneder siden
  • ReyHanjo
    ReyHanjo
    • 2 måneder siden

    Hi. Is it okay if I put the date of delivery in Column B? It will help a lot when it comes to linking files especially if you want to trace the delivery per day. You can unhide it after putting the deliver date in there. It is for the sake of the output that you want to have.

    • 2 måneder siden
    1. totallynumbered
      Konkurrenceafholder
      • 2 måneder siden

      I think this is irrelevant. All I need to know has the van been inspected that week. I don’t care what date.
      Has the van been inspected and has it gone for longer than 10mins

      • 2 måneder siden
  • hathuhoang2
    hathuhoang2
    • 2 måneder siden

    Hi, Andrew. can I start the work for you?

    • 2 måneder siden
  • daniyal3214
    daniyal3214
    • 2 måneder siden

    Hi, I am going to start working on this.

    • 2 måneder siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!