Closed

Finishing 85% complete project about automated Excel Calendar

This project was awarded to shivaparvathi108 for €12 EUR.

Get free quotes for a project like this
Employer working
Project Budget
€8 - €30 EUR
Total Bids
12
Project Description

Keep in mind this project is 85% done, it was actually finished until i found it i needed to add 2 things more.

Basicaly i have an entire year for every employee of mine, if someone takes vacation it gets a certain code (A2 in the example) but it there are other codes to (A1, A5, etc etc).

If i put A2 in the month sheet(january in this case) that means that person takes off a whole day, which should automatically show up in their personal sheet under the tab A2 with the date that person took the A2(which is in the example).

Now if a person takes 4hours vacation( as seen on 6th and 7th of january) thats not an entire day so it adds the dates in a comment in the personal field.

This has all been done before by someone else and works.

The things i need done now(you can see [url removed, login to view]), is:

1. To add minutes to it. So not just hours but also minutes. An example would be "1u30 A2" or "4u45 A1".

2. If someone takes 5u A2 on day 1, 5u A2 on day 2 and 6u A2 on day 3, they now all get put in seperate cells on the personal sheet because it tries to add up to 8 and waits for 3u, 3u and 2u, but i can actually add 3u from day 2 to day 1 and add the 6u from day 3 to day 2. So its needs recalculating so it will always add up to 8hours.

3. You need to check in the Month sheets in the comments aswell(seen in [url removed, login to view]).

If a person takes 5u A2 and the field is to small i will add the other codes in a comment section on that date and i want them added to the comment section as we do now.

If you have any question please contact me.

It seems hard but it's quite easy to understand when you know what i mean.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online