+ Reply to Thread
Results 1 to 3 of 3

Reflect TBF vacancies over 2018-2019/2019-2020 budget year

  1. #1
    Registered User
    Join Date
    03-09-2018
    Location
    us
    MS-Off Ver
    14
    Posts
    11

    Reflect TBF vacancies over 2018-2019/2019-2020 budget year

    I have an excel sheet that reflects positions that are vacant, the yellow cells are reflecting positions approved but vacant for 2018-2019, the green cells reflect positions that are vacant and projected for the budget year 2019-2020 they are placed in the month that they are expected to be filled, however it just really comes across confusing and I hope someone here could take a fresh look at this and help me present this in a more comprehensive manner. The total number of vacant positions for both budget years totals 35, however, the columns distract the eye and I could see how people would be confused just looking at the columns and trying to determine what I am trying to state. Positions that are in green cannot be filled until the new budget year begins, the yellow positions can effectively be filled now because the 2018-2019 budget has already been approved.

    Please find attached excel spreadsheet, I have been working too many hours this week on budget and I am seeing things now.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Reflect TBF vacancies over 2018-2019/2019-2020 budget year

    There is no spreadsheet attached to the post.
    Let us know if you need help.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Reflect TBF vacancies over 2018-2019/2019-2020 budget year

    Can't really guess what the data looks like but I can't help thinking the immediate vacancies should be green and the next year's vacancies would be yellow/amber ... green for go, and amber for get ready to go soon.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Call in the Cavalry - 2019
    By MrShorty in forum The Water Cooler
    Replies: 163
    Last Post: 12-30-2019, 02:39 PM
  2. [SOLVED] Jump to specific column if cell contains value 2019
    By besis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2019, 05:06 PM
  3. Converting text " 12/31/2019 to date format
    By Gerbilsocks in forum Excel General
    Replies: 1
    Last Post: 01-15-2019, 02:21 PM
  4. Determine last and current month (2018 - 2019)
    By Bandito1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2019, 06:09 AM
  5. Excel 2019 Download
    By Analyst157 in forum Excel General
    Replies: 2
    Last Post: 12-25-2018, 08:57 PM
  6. [SOLVED] Excel 2019 functions are not showing
    By ImranBhatti in forum Excel General
    Replies: 10
    Last Post: 11-02-2018, 09:45 AM
  7. how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.
    By sahana108 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2018, 09:07 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1