Completed

Excel Spreadsheet Design

I need to create a spreadsheet containing 2 worksheets.

The first worksheet must contain a number of specific items that are leased out with start and end dates. Each item will have numerous start and finish dates for leasing across a number of years and will contain certain data such as State to be leased in etc. This is the data entry sheet.

The second worksheet must contain a graphical bar representing each item for lease, based on the previous mentioned spreadsheet dates. Dates will be shown across the top of the spreadsheet. Each item must be graphically displayed on 1 line only. Based on the data entered on the other spreadsheet, the cell must be displayed in a particular colour for each item, based on the state it is being leased to. Lastly, and this is the MOST IMPORTANT PART of the spreadsheet - when items have been double booked, the bar MUST change to a different colour (maybe red) for the period where 2 bookings occur on that item. Please see rough hand drawn attachment. Please let me know if this is viable.

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

See more: excel spreadsheet design outsource, excel spreadsheet design layout, excel spreadsheet design outsourcing, quotes excel spreadsheet design, excel spreadsheet automated data search create tables, professional excel spreadsheet design australia, excel spreadsheet design johannesburg, excel spreadsheet design, freelance excel spreadsheet design, graphic design i need some graphic design, i have a still image with a design i need you to draw it in vector form with correct alignment so we can print it on t-shirt, i have my design i need to install on website, excel spreadsheet design for hire australia, i am a fresher in graphic design i need a job, I need some graphic design.I need a mickey mouse e invitation for my son\ s 1st birthday., I need some graphic design.I need some graphic design. Need a book cover for a self published EBook to upload to Amazon Kindle , I need some graphic design. I need a cover photo made 851 x 350 for Facebook at 100kb in size or smaller. , I need some graphic design I need a cover photo made 851 x 350 for Facebook at 100kb in size or smaller. , graphic design i need

About the Employer:
( 1 review ) Newport, Australia

Project ID: #30181961

Awarded to:

(213 Reviews)
7.0

28 freelancers are bidding on average $117 for this job

(1048 Reviews)
8.2
(369 Reviews)
8.1
(482 Reviews)
7.4
(268 Reviews)
7.0
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data More

$250 AUD in 5 days
(114 Reviews)
6.4
(28 Reviews)
4.8
PERPETUAL0

Hello there let me show you some top samples thanks ilyas

$70 AUD in 1 day
(58 Reviews)
4.7
globalgo

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project. Your satisfaction with th More

$50 AUD in 7 days
(14 Reviews)
3.5
Peefect

Hi Sir , I am an excel Expert and will develop it. Please message me the files with proper details. As per your attached pdf , My understanding is thay you are looking for the tracking details of projects basis on sta More

$59 AUD in 4 days
(10 Reviews)
3.6
shintung9105

=========== Excel Expert is here ============= Hi! I am happy to put my bid on this project. I read the description and I am appreciate in your project. I am an expert with Excel formula and VBA as I have built many pr More

$50 AUD in 1 day
(4 Reviews)
2.4
pawangaire123

Greetings! I’m very much interested to your requirements and Job openings. I am a Professional in Microsoft office, Data Entry, PDF, and excel with over 5 years of experience, therefore, I can easily do this job. You c More

$30 AUD in 2 days
(2 Reviews)
1.6
bmoatar1

Hi, I have full experience with excel, VBA ========================================================== I'm sure I can complete your project on time with high quality. you can contact me and discuss project more detail v More

$140 AUD in 3 days
(1 Review)
0.4
kbs80555

I have good knowledge in Microsoft word and Microsoft excel so i can guarantee you that your project will be completed with in your time line and as per your budget.

$35 AUD in 2 days
(0 Reviews)
0.0
as3792976

I am skillful and hard working [login to view URL] I have certificate of data entry operator .And I can do this work with 100%accuracy

$140 AUD in 5 days
(0 Reviews)
0.0
vishalpandey8602

HEYY!! I am professional Data Entry Specialist. I work for my client's satisfaction.I can complete your project before the deadline with great accuracy and dedication. Please give me the chance to become the part of yo More

$40 AUD in 3 days
(0 Reviews)
0.0
TeamShiraishia

Good day! I am interested for this proposed project. I have an experience of doing Data Entry for years and doing sideline from other people outside freelancer. I am also accurate and well experience in Microsoft Exce More

$50 AUD in 5 days
(0 Reviews)
0.0
harmeetrai

They are responsible for planning, designing, developing, and evaluating computer systems. MIS executives have various duties depending on the type and size of the organization they work for.

$140 AUD in 7 days
(0 Reviews)
0.0
dc7188240

yes, i have this project will be delivered in 5 days complete. i have great work in excel. i have professional work.

$250 AUD in 5 days
(0 Reviews)
0.0
Aryan1380067

I AM A STUDENT WHO IS INTRESTED IN DOING DATA ENTRY JOBS. I KNOW TO OPERATE MS WORD AND MS EXCEL. SINCE MY SUMMER VACATION IS GOING ON I CAN DO IT IN MINIMUM TIME.

$40 AUD in 2 days
(0 Reviews)
0.0
rakeshvirupaksha

I am well experienced worker in computer work even there is excel, word anything, so i am suitable for your work. i will do my work honestly and sincerely.

$140 AUD in 7 days
(0 Reviews)
0.0