Excel Spreadsheet Design

$30-250 USD

Closed

Posted

about 3 years ago

$30-250 USD

Paid on delivery

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.

Project ID: 30182551

About the project

21 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

21 freelancers are bidding on average $128 USD for this job

@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 skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high. Please Ping me the chat box for further discussion.

$100 USD in 2 days

5.0

(40 reviews)

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 interested, we can discuss this further on chat.

$80 USD in 1 day

4.6

(26 reviews)

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 days

5.0

(1 review)

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 top and a list of the items being leased in this period down the side. It would then filter through each item in the first spreadsheet and put a bar along the specific date range it is being leased over. If the macro goes to add a bar and discovers there is already a bar for that item on that date it will colour it red for the duration of the overlap.

$200 USD in 7 days

5.0

(1 review)

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 days

0.0

(0 reviews)

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 work Thank you

$33 USD in 1 day

0.0

(0 reviews)

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 Statement. Data Collection. Data Quality Check and Remediation. Exploratory Data Analysis. Data Modelling. Data Communication. Better Data Management Solution.

$140 USD in 8 days

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 possess all the skills that you have outlined, and can effectively work towards tight deadlines.

$140 USD in 7 days

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 sheet that satisfies the client. Some clarification might be reuqired about the second worksheet to fully understand your requirement.

$120 USD in 7 days

0.0

(0 reviews)

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 short this database got all the stock, sales, open orders data and printed kanban cards for each pallet of product to be produced according to the defined Kanban levels. Then these kanban cards are moved to an exposure board to make the planning visual. According to the requirements the planner sent a daily batch of kanban cards to the production boards. After the production is completed the kanban cards were scanned and this allowed stock entry as well as raw material consumption/back flush. I think this is a good example and quite similar to what you may need. Regards, Lee

$56 USD in 1 day

0.0

(0 reviews)

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 days

0.0

(0 reviews)

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 model works, how to maintain it yourself or by your staff and learn some Excel knowledge too. Price and timeline are indicative. Couldn't see any attachment so will need more understanding of what is required. Hope to hear from you.

$200 USD in 3 days