I gang

Timeline in Excel

Hi,

I have a list of projects that needs to be added to a timeline in Excel.

Functionality

Automatic update of a timeline in Excel sheet with program name and start/end dates of items in list.

Description:

I need to be able to see a timeline of events in Excel. The timeline is updated from a list of tasks on another sheet in the same Excelfile. The timeline is updated every time you select the sheet with the timeline.

For each task there is a “project name”, “start date”, “end date”,and ” type” that need to be added to the timeline automatically once it’s added to the list of tasks. “Item starting date” and “Item days” is displayed as a bar on the timeline. The other are displayed as numbers and letters. On the timeline.

The time range also needs to be updated automatically every time you select the sheet with the timeline in the file. The time line range should show:

The project name

The start date of a project

The end dat of a project

Programming language

I assume this will be an Excel macro.

General

Duplication: It should be possible to duplicate the file and use the functionality on different sets of information.

Add rows: It should be possible to add rows of new information and keep the time line fuctionality. Once any of the fields “project name”, “project cost”, “item starting date”, “item name” and “item days” contain information the item row should be added to the timeline.

Data formats in dependent cells

(if needed for programming of macro):

Project name: (English)

Item date: date format (03-16-2011)

Item name: general format (language English)

Item days: number of days

Item end date: date format (3-16-2011)

Add columns It should be possible to add columns and keep the automated timeline function

Change headings: it should be possible to change headings in columns and still have the functionality defined in this document.

Compatibility: Windows Excel 2002 SP3 up to Excel 2007

Screen size: adapt for Window Excel in 1280*1024 pixel window

Task hierarchy: No main or subtasks. Tasks that overlap in time should be placed in parallel with the earliest starting point closest to the timeline and building up.

Task range: up to 200 tasks on the timeline. Scrolling right if necessary

Text format on timeline bar:

#Project Name#,: # start date#, #end date#

Færdigheder: Excel, Visual Basic

Se mere: timeline excel sheet, timeline excel, items timeline excel, timeline excel macro, excel timeline, visual programming language, visual basic cost, starting visual basic, programming language timeline, programming language list, formats excel, excel data programming, excel add programming, basic programming language, time line excel, excel automated timeline, new excel, excel programming language, pixel type, parallel programming, macro excel, line sheet, format excel, excel projects, excel function

Om arbejdsgiveren:
( 0 bedømmelser ) Rogers, United States

Projekt-ID: #1005905

Tildelt til:

rboscariol

Please check my private message for further details.

$250 USD på 1 dag
(0 bedømmelser)
0.0

50 freelancere byder i gennemsnit $367 for dette job

svet63

Excel developer since 1997. Can do. Regards, Svet.

$450 USD in 7 dage
(69 bedømmelser)
6.5
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$300 USD in 7 dage
(64 bedømmelser)
6.5
fedalal2

Hi, I have more 10 years with MS Excel and MS Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$350 USD in 4 dage
(32 bedømmelser)
5.5
mrbrave

Ready to start now....See PMB Please.

$300 USD in 5 dage
(73 bedømmelser)
5.4
vbexcel

Excel/VBA expert - ten years experience.

$250 USD in 5 dage
(26 bedømmelser)
5.3
northwolves

See PMB please.

$250 USD in 3 dage
(46 bedømmelser)
5.0
djucuti

Hi, please check PM

$250 USD in 10 dage
(19 bedømmelser)
4.7
kulhanekd

I would like to bid. Donna

$300 USD in 5 dage
(11 bedømmelser)
4.5
telemarketing555

Hi. Please check your PM. Thank you.

$250 USD in 5 dage
(26 bedømmelser)
4.4
RoyEdwards

Please see PM for details. Thanks.

$400 USD in 5 dage
(13 bedømmelser)
4.3
jeffrmanley

I have over 7 years experience developing custom code for Microsoft Excel. I am available to start on your project immediately. Please see PM

$275 USD in 4 dage
(1 bedømmelse)
3.4
priyaam

Hi, I am interested in this project

$250 USD in 5 dage
(7 bedømmelser)
3.3
Inswinger

Hi, Please check the PM.

$250 USD in 3 dage
(4 bedømmelser)
3.3
ssawatzky

Hi, I work daily with Excel and VBA. I would enjoy working on this with you.

$300 USD in 14 dage
(2 bedømmelser)
3.1
Pravynandas

Hi, I would like to work on this project. Pls check my PM.

$350 USD in 20 dage
(1 bedømmelse)
2.8
SilviaT

Please check PM.

$250 USD på 1 dag
(5 bedømmelser)
2.4
statnxt

Kindly refer to your Inbox for details and a proposal. Thanks!

$300 USD in 15 dage
(3 bedømmelser)
2.2
vbeh

Ready to start.

$250 USD in 5 dage
(3 bedømmelser)
2.1
kanadyanako

Kindly see my proposal.

$250 USD in 7 dage
(1 bedømmelse)
1.8
alastairnash

Johnmora please check your PMB, I have sent you something.

$250 USD in 2 dage
(1 bedømmelse)
1.6