Encerrado

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.

Habilidades: Visual Basic, Processamento de dados, Processamento de Dados, Excel, Microsoft Office

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Singapore, Singapore

ID do Projeto: #30182551

22 freelancers estão ofertando em média $128 nesse trabalho

(448 Comentários)
8.3
(164 Comentários)
6.8
(122 Comentários)
6.0
AnuradhaVM

Hi, Greetings! ✅checked your project details. I can organize and design spreadsheet data. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have strong analysis, and Excel/google sheet Mais

$100 USD in 2 dias
(27 Comentários)
4.5
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start right away and complete it within a few hours. If Mais

$80 USD em 1 dia
(25 Comentários)
4.9
mohamedeljayyar

I'm expert with google sheets and excel works, i understood your requirments and i'm ready to start right away...........................................................

$250 USD in 4 dias
(1 Comentário)
3.0
Shoaibbms

respected customer i can fulfil your requirement because i have lotof experiance regarding data entry and typing work, give me opportunity to i will definetly complete my work with in dead line, thanks with regards

$30 USD in 6 dias
(0 Comentários)
0.0
Rambeer

Sir, I have just seen your job profile, according to your job profile, you have need 2 colourfull spreadsheets. And I can make them the Asura of your choice fastly My motive is work is worship I hope you give me this Mais

$33 USD em 1 dia
(0 Comentários)
0.0
rahulkumarandhr1

Sir, I'm eagerly waiting for your project and I had done some projects in India as a data analyst. If done this project it will be helpful to my career. I'll give my better efforts to this project . Define Problem Stat Mais

$140 USD in 8 dias
(0 Comentários)
0.0
Charankongari

I will submit my work on time.I am desperate to get some experience.I am able to do the work that you have given.I will submit the work on time.I am good at my communication skills

$140 USD in 7 dias
(0 Comentários)
0.0
Meleyh

I have just finished with a project, and do not have any more in the pipeline at the moment. If I am hired for this project, I will be able to give it my full attention and will deliver on time. Apart from this, I poss Mais

$140 USD in 7 dias
(0 Comentários)
0.0
ravishankar375

I am retired from the indian Army as a clerk,and have well knowledge about Ms Office. I prefer to remain in the disciplined routine and emphasise more time punctuality in any work

$140 USD in 7 dias
(0 Comentários)
0.0
UpalGhosh06

I will like to help you in completing the excell sheet in 5days. So if you kindly believe on me and give me your work then I can get a chance to help you. Thank you, Upal Ghosh.

$101 USD in 5 dias
(0 Comentários)
0.0
pipsqueakk

Hi I've read the project and understand it. I'll try my best to deliver this project to you in time and without any error. please contact me

$100 USD in 7 dias
(0 Comentários)
0.0
binndassmanish

hi I have read and understand your task I will complete your project in given time , I have well knowledge of excel ,VB application, so don't worry just give me a chance

$167 USD in 4 dias
(0 Comentários)
0.0
ahmadelasmr

As a senior civil engineer worked on designing structural elements, designing spreadsheets using MS excel is a daily job. The spreadsheet described above is a repeated job to me and I guarantee to deliver a quality she Mais

$120 USD in 7 dias
(0 Comentários)
0.0
pharit98

Thank you for for the selection.I have more than 7 years of experience in this [login to view URL] it is easy for me to do.I will wait for your answer.

$110 USD in 2 dias
(0 Comentários)
0.0
llgurbuz

Hi, Very interested in your job. I will work super fast and deliver in record time. As a relevant experience to your project I have completed Kanban production and stock management database using Excel and VBA. In sh Mais

$56 USD em 1 dia
(0 Comentários)
0.0
GKEvans

Hello, I have 15 years of experience in Excel. I could create you a macro that will perform this function for you. It would list the earliest start date (after or on the current date) to the latest end date along the Mais

$200 USD in 7 dias
(0 Comentários)
2.4
Myprogame

Hi I can complete this project I have experience on government in ten years and completed projects with government

$140 USD in 7 dias
(0 Comentários)
0.0