Closed

Excel Chart Tool

This project received 14 bids from talented freelancers with an average bid price of $150 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
14
Project Description

Hello Experts
I’m looking for an excel expert to develop a tool with a very nice interface, format, coloring {overall design} to satisfy the followings:
1-A tab to enter the following data {IN-Input Sheet} and to save them into a table in another tab called {IN-Log}
[url removed, login to view] date: normal date field
[url removed, login to view] : text field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view]: number field
[url removed, login to view]: number field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb}
[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb} / or a number of DAYs
[url removed, login to view] Loc : text field
[url removed, login to view] Loc : text field
[url removed, login to view] : text field
[url removed, login to view] : text field
[url removed, login to view]: this field will have a link to a file/image/email in outlook need to be attached to this record
2-A tab to enter the following data {OUT-Input Sheet} and to save them into a table in another tab called {OUT-Log}
[url removed, login to view] date: normal date field
[url removed, login to view] : text field
[url removed, login to view]: text field
[url removed, login to view]: number field
[url removed, login to view]: number field
[url removed, login to view]: text field
[url removed, login to view]: text field
[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb}
[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb} / or a number of DAYs
[url removed, login to view] Loc : text field
[url removed, login to view] Loc : text field
[url removed, login to view] : text field
[url removed, login to view]: this field will have a link to a file/image/email in outlook need to be attached to this record
3-Sheet { IN-Log }, should list all the records inputted via {IN-Input Sheet} with a check box at the first column of each record {to be used for selection later}
4-Sheet { OUT-Log }, should list all the records inputted via {OUT-Input Sheet} with a check box at the first column of each record {to be used for selection later}
5-Gantt Chart Generation tab {GNT CHRT}: this sheet should have the option to select WHICH sheet I want to draw my Gantt chart from {IN-Log/OUT-Log} and after selecting the sheet, a list of all the fields names for the selected sheet should be displayed to select which ones we want to show to the left side of the Gantt Chart {like what we have in MS Project, we have some fields displayed to the left of each bar having some details about the drawn bar} . Now after selecting which sheet to draw the chart from and what are the fields to show, we need to select the RECORDS from that sheet to draw our chart based on them and their DATE VALUES.
6-When we finish setting all these information and want to generate the chart we should have options for drawing the chart as follow:
[url removed, login to view] the chart for the entire year “Current Year” - DAYS , so we should have a calendar from January to December where every single DAY is shown on the chart to be filled
[url removed, login to view] the chart for the entire year “Current Year” – MONTHS, so we should have a calendar from January to December where every single month is represented with ONE CELL to be filled
[url removed, login to view] the chart for 3 years ahead – MONTHS, so we should have a calendar from January to December for the current year PLUS the same for the next coming 3 years where every single month is represented with ONE CELL to be filled
[url removed, login to view] the chart for 5 years ahead – MONTHS, so we should have a calendar from January to December for the current year PLUS the same for the next coming 5 years where every single month is represented with ONE CELL to be filled

**** Please view attached requirements document for better view and understaning

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online