Design Excel Scpreadsheet with Automatic Visual Schedule Based on Tasks Start and Due Date

Project Details

If you send me a private email message that is COPY and PASTE and not a PERSONALIZED message I will not award you the project even if you’re the lowest bidder.

Timeline: Revised Spreadsheet by Tuesday 10/8/13, but working with me ongoing through March of next year.

Scope:|

I need an assistant to work with me for several months part time on revising and maintaining an Excel spreadsheet/database.

YOU MUST be an Excel Specialist for this work, it is not good enough to just know the basics of excel.

While this is a part time role I am going to need you to making revisions to the document upon request and to be available to me via email and Skype. Speaking good English would be helpful as well.

I will send you a current excel spreadsheet that will need to be modified as follows:

The current spreadsheet has five tabs, You will focus on tabs #1 -#4

Tabs #1 will provide you with each task and the group/person and color of the group. You will chart out on Tab #2 each task and timeline in the associated color and associate the task from Tab #1 to the schedule on tab #2.

The goal is to provide a visual layout when tasks are in progress and when they are expected to be completed.

The same will need to be done for Tab #3 tasks and plotted on tab #4 as well in the same manner.

You will need to first revise the spreadsheet as follows: For schedule please change time line in to remaining months of year. October – March 2014 and if possible I would like the ability to be able to view by week view as well or single month view.

Tabs #1 and #3 that contain tasks will also need to revised prior to start as follows:

1. Make columns from left to right as follows: Task, Accountability, Date Start Date Required, [in one column three parts] Green= On Target Yellow= Approaching Due Date and Red=Overdue [see note below]

2. Imagine at the top of this column you have the three status listed and text color coded. Then the columns below for each action item I can just shade the box based on color to indicate status of task completion.

3. The last column would be “Task Status”

Some final thoughts: If you are really good with excel and have some other ideas to make this work better, I am certainly open to your creativity.

What would be perfect solution would be I populate tasks and start dates and due dates and that automatically generates the schedule and adjusts the boxes so I dont have to do it manually. Also that it automatically flags approaching tasks and overdo or expired tasks.

I will share the file with bidders who are in the final selection process and really show interest in this work.

I will need a working excel spreadsheet as soon as Tuesday 10/8/13 and again you will stay on with me over the course of several months reviving the schedule as tasks are added, deleted and revised week to week, month to month.

Mecanografía Entrada de datos Procesamiento de datos Excel Asistente virtual

Nº del proyecto: #4995546

Sobre el proyecto