Design and Code an Excel sheet

$10-30 USD

Completed

Posted

about 8 years ago

$10-30 USD

Paid on delivery

Hello all I have a simple idea for a spreadsheet that I am currently working on. It is very hard to explain a spreadsheet over text but I will try. 1) A master spreadsheet where people input day by day what they do, what time they arrive and where they have been. This only increases in size and will be filled in for a whole year. 2) A time sheet that takes the information from the master sheet and only displays the information from the week after the date above. 3) A mileage sheet that puts together mileage information from the master document, only in the month that is input above. However if either the previous location or next location are "home" then it will not appear. I have attached a sketch of the document to see if people can understand this. Let me know if there are any questions? DSR

Excel

Visual Basic

Visual Basic for Apps

Project ID: 9963622

About the project

9 proposals

Remote project

Active 8 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

Awarded to:

@johncarteratfl

I looked into your excel file and three spread sheets that you have. I hope I can do this task for you very elegantly. Give me a chance to serve you.

$25 USD in 1 day

0.0

(0 reviews)

0.0

9 freelancers are bidding on average $28 USD for this job

@bytessolution

Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you for your time.

$30 USD in 1 day

4.1

(2 reviews)

2.8

@tkannanid

Hi.. I am ready to work on the project and please have a detailed information of your requirement.. Thanks!!

$15 USD in 1 day

4.8

(3 reviews)

2.2

@Spruceberg

I am a financial analyst in a big corporation and I like to "play" in Excel. I'm not doing it just for the money... I really like it:) Plus if I understand you correctly than I can do it with 2 pivot tables. We can always talk more about it before you decide what to do:)

$15 USD in 3 days

5.0

(1 review)

0.6

@renandocarmoreis

Hello, let suggest to build a simple web application for this instead of spreadsheet. Users will login and make appointments. The app will generate the 2 reports "time sheet" and "mileage sheet"

$66 USD in 3 days