Excel Spreadsheet Design

Kapalı İlan edilme: 2 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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.

Visual Basic Veri İşleme Veri Girişi Excel Microsoft Office

Proje NO: #30182551

Proje hakkında

21 teklif Uzak proje Aktif 2 yıl önce

Bu iş için 21 freelancer ortalamada $128 teklif veriyor

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 Daha Fazla

$100 USD in 2 gün içinde
(40 Değerlendirme)
4.8
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(26 Değerlendirme)
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 gün içinde
(1 Yorum)
3.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 Daha Fazla

$200 USD in 7 gün içinde
(1 Yorum)
2.5
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 8 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$120 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Myprogame

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

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
eddylaufamily

Hi, I've worked on Excel for >20 years with Fortune 50 companies. No longer in corporate world, doing full time freelance now. I reside in Singapore. Besides building the model, I will ensure you understand how the mo Daha Fazla

$200 USD in 3 gün içinde
(0 Değerlendirme)
0.0