Track vacation time for team members Track vacation time for team members
Page 1 of 5 123 ... LastLast
Posts 1 to 10 of 47
  1. #1

    Still gathering requirements...

    vik845 has no reputation


    Join Date
    Jan 2016
    Posts
    25

    Default Track vacation time for team members

    Need help - I have been asked to create a spreadsheet for tracing team members vacation time. Please advise how can I create this spreadsheet? Thanks

    1. Each team member of xyz team listed into columns/ rows however you see fit
    2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
    3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
    4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person

  2. #2

    Old Greg is my bitch's bitch

    northernladyuk is a fount of knowledge

    northernladyuk's Avatar
    Join Date
    Nov 2011
    Location
    Working the streets of your imagination
    Posts
    9,459

    Default

    Quote Originally Posted by vik845 View Post
    Need help - I have been asked to create a spreadsheet for tracing team members vacation time. Please advise how can I create this spreadsheet? Thanks

    1. Each team member of xyz team listed into columns/ rows however you see fit
    2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
    3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
    4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person
    SASguru will do the heavy lifting with the Excel back-end, and Suity can spin you up a BPM tool and UI.
    Where there's muck there's brass.

  3. #3

    Still gathering requirements...

    Chutney Spoon is too good to be a permie

    Chutney Spoon's Avatar
    Join Date
    Jul 2009
    Location
    Chutney, mouth, chutney, elsewhere, chutney
    Posts
    84

    Default

    Do you like films about gladiators?
    Do you double dip?
    Have you tried bleeding the radiators?

    We need to know.

  4. #4

    Godlike

    Paddy is a fount of knowledge

    Paddy's Avatar
    Join Date
    Jul 2006
    Posts
    9,756

    Default

    Book a meeting room and have a brain storming session.
    Brexiteers remind me of religious fanatics, only faith, no facts.

  5. #5

    Lord of the Vectras

    VectraMan - scorchio!

    VectraMan's Avatar
    Join Date
    Dec 2005
    Location
    European Union (Yorkshire)
    Posts
    11,442

    Default



    I can recommend this book. I think the "Spread Sheet" might turn out to be big.
    Will work inside IR35. Or for food.

  6. #6

    Old Greg is my bitch's bitch

    northernladyuk is a fount of knowledge

    northernladyuk's Avatar
    Join Date
    Nov 2011
    Location
    Working the streets of your imagination
    Posts
    9,459

    Default

    Quote Originally Posted by Paddy View Post
    Book a meeting room and have a brain storming session.
    Surveymonkey or Doodle Poll to agree date for session?
    Where there's muck there's brass.

  7. #7

    Faqqed Off

    TheFaQQer is a fount of knowledge

    TheFaQQer's Avatar
    Join Date
    Oct 2006
    Posts
    36,488

    Default

    Quote Originally Posted by vik845 View Post
    Need help - I have been asked to create a spreadsheet for tracing team members vacation time. Please advise how can I create this spreadsheet? Thanks

    1. Each team member of xyz team listed into columns/ rows however you see fit
    2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
    3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
    4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person
    1. Put each team member's name in a column or row (as you see fit). It might be worth including a column / row title as well
    2. In a row / column below / next to the members name, enter the number of work days requested off (you could include validation to make sure it's a number)
    3. In a row / column below / next to that, include the exact dates that the person will be OOO. For multiple days, you could enter a date range
    4. In a row / column below / next to that, use the "sum" formula to add up the values entered in step 2.

    Good luck with your ECDL, but bear in mind that from next year it doesn't count as a qualification for school league tables so many schools will be removing it as an option.
    Best Forum Advisor 2014
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership

  8. #8

    My post count is Majestic

    northernladuk is always on top

    northernladuk's Avatar
    Join Date
    Mar 2009
    Posts
    40,447

    Default

    Was this part of your schedule of work or is the client asking you to carry out ad hoc bits of extra work?
    'CUK forum personality of 2011 - Winner - Yes really!!!!

  9. #9

    Godlike

    jamesbrown is a fount of knowledge

    jamesbrown's Avatar
    Join Date
    Dec 2011
    Posts
    7,225

    Default

    Scooty is a whizz at Excel-based summation. Sas would be overkill. Why splash out on Blue Nun when you can get away with Diamond White?

  10. #10

    Double Godlike!

    MrMarkyMark is a fount of knowledge


    Join Date
    Dec 2012
    Posts
    10,973

    Default

    Quote Originally Posted by vik845 View Post
    Need help - I have been asked to create a spreadsheet for tracing team members vacation time. Please advise how can I create this spreadsheet? Thanks

    1. Each team member of xyz team listed into columns/ rows however you see fit
    2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
    3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
    4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person
    Have you raised a CUK ticket, if not please do the needful at the soonest.

    Please provide required solution platform, service pack applied and operating system you wish to deliver on.

    Have you tried switching it on and off again?

    HTH.

    BIDI.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •