Fermé

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.

Compétences : Visual Basic, Traitement de Données, Saisie de Données, Excel, Microsoft Office

En voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Singapore, Singapore

Nº du projet : #30182551

22 freelances font une offre moyenne de 128 $ pour ce travail

(448 Commentaires)
8.3
(164 Commentaires)
6.8
(122 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(27 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
4.9
mohamedeljayyar

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(1 Évaluation)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
2.4
Myprogame

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0