Closed Thread
Results 1 to 2 of 2

Corporate Mobilization Forecast - Questions on improving, formulas & functions Excel

  1. #1
    Forum Contributor
    Join Date
    05-14-2015
    Location
    Ulaanbaatar, Mongolia
    MS-Off Ver
    Office 2021 Professional Plus
    Posts
    120

    Corporate Mobilization Forecast - Questions on improving, formulas & functions Excel

    Hi all,


    Little bit of background: I work in corporate company's HR department, and to be more specific in 'Mobilization Team' which I look after on-boarding process of nationals & expatriate employees. I have this mobilization spreadsheet to keep track of new starters and already mobilized personnel to company. I use this spreadsheet to report our progress.


    Main point: The spreadsheet is completely 100% manual where I have to edit every single details to make it look right and it's not a nice thing to do. I want to improve this to keep better track of everything, up-to-date record etc.


    What I want to improve:


    1. Editing/modifying - when I change date, or input a data, it reflects the change to that whole row for that person to.
    2. Adding formula/function - I can only see IF function. How do I add IFS for multiple conditions and values?
    3. Multiple choice drop down list - If the personnel has completed first stage and currently stuck at second stage I want the STATUS to show : Medical Stage (First stage being : Contract Signing Stage; Third stage : SAP ID activation; Fourth stage : Mobilized). This is tied to 1 & 2 like when the person has signed the contract : IF(F7>=DATE(2016,9,13),'Mobilised'),F7 4. If the later stages are not confirmed, without given date and the cell is empty, the STATUS cell counts whatever cell has date or data in it. Example: If the Medical completed date has date and SAP number provided date is empty ; the status shows: Medical Stage
    5. I want the STATUS cell to show 4 different colors in gradient bar. If it's stage 1: yellow ; stage 2: orange; stage 3; blue or something ; stage 4; green


    Please help me as much as you can. English is not my native and first language - apologies if it doesn't make sense at all. But can you please edit and modify my attached (somehow I cant attach file) spreadsheet as close as possible to things I mentioned above?

    Your assistance is greatly appreciated.
    Mobilsation Spreadsheet Template.xlsx

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Corporate Mobilization Forecast - Questions on improving, formulas & functions Excel

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 24
    Last Post: 05-24-2017, 09:49 AM
  2. Replies: 1
    Last Post: 05-09-2017, 09:16 AM
  3. Corporate Finance Excel
    By medinas925 in forum Excel General
    Replies: 4
    Last Post: 06-17-2015, 07:43 PM
  4. Improving Speed of Index and Match Functions
    By hazza147 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2010, 01:05 PM
  5. Excel - how can I practice formulas on financial questions?
    By flamingformulas in forum Excel General
    Replies: 4
    Last Post: 02-20-2006, 11:20 AM
  6. Excel volatil functions questions
    By nicgendron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 08:12 AM
  7. [SOLVED] what book do you recomende for formulas & advance excel questions
    By KimSingh in forum Excel General
    Replies: 1
    Last Post: 04-03-2005, 06:06 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