Build Custom Excel Form

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Freelancer must have Skype and have communication throughout this short project.

Mileage Form:

The Excel Mileage Form should be duplicated (exact same formulas for mileage calculation, same colors, font, etc.). We are only reproducing this form because it is locked and we need another tab named "CAP".

CAP Requirements:

- The CAP report should be similar to the Word document, but in Excel. Instead of checkboxes for service rendered, the new form should offer a drop down. Program (service rendered) dropdown choices are: 56A (Transportation), 56E (School Transport), 71A (In Home Case Management-Licensed), 71Q (In Home Case Management-Masters), 71B (In Home Case Management), 95A (Intensive Therapeutic Services), 00W (Hoteling)

- Multiple Programs/Services should be able to be selected

- Time (Start and End) should be a field located beside the Program Name (excel should auto calculate time)

- Sometimes there will be a need to enter 2 start and end times for 1 program

- A field for mileage should also exist (no calculation required, we should just be able to enter mileage)

- Type of contact options should remain a checkbox. Options are: Face to Face, Telephone Contact, Missed Appointment

- Form fields should be created for all entries

- The Summary section should allow as much content as the writer desires. The summary section should allow the writer to fill up the first page and automatically create a field on the second page.

- Page size is [url removed, login to view] (US standard)

- Change "Signature" to "ACS Worker" and allow a form field for worker to type their name and title below.

- Updated address is:

PO Box 70123

Albany, GA 31708

(888) 576-8372

(866) 794-8372

Excel Format and Layout

Project ID: #11181120

About the project

12 proposals Remote project Active 7 years ago

Awarded to:

TreyMack91

In order to complete the project I will employ list validation to create the menu style required which i have mastered doing various excel courses. I will ensure the formatting is kept and also add all necessary fields More

$25 USD in 1 day
(0 Reviews)
0.0

12 freelancers are bidding on average $25 for this job

cgullapalli

Hi, I am good at Excel and vba. Plz provide me the details further to work on. Looking forward to discuss in the chat.

$34 USD in 0 days
(210 Reviews)
6.6
shafaqat11

Hello Sir, I have read the project and understand your requirement. I am a highly trained on Data Entry ,Research, Web search, Web scraping, Product Add, Any Type Of eCommerce Cart, Expert with great knowledge of Ex More

$20 USD in 1 day
(14 Reviews)
4.2
conforti

I can unlock the existing file

$15 USD in 2 days
(8 Reviews)
3.4
rikari000813

I've been working with excel for more than 5 years now. I've used it to create algorithms, scrapers, dashboards, and most common one is for forms.

$30 USD in 1 day
(9 Reviews)
3.4
sadaqatali408

HI Thanks for the opportunity, I have read entire project details given in your project and I am fully capable to deliver you the work as per your requirement like Data Entry Services (Copy of data from sites & Manual More

$30 USD in 1 day
(5 Reviews)
2.0
anikkanti

Hi, I’m Anik. I’m a professional Freelancer. I’m working in these fields for a long term. I'm very expert in Microsoft Office (MS word, Excel & Power Point) PDF & Photoshop. I'm also professional in web research & d More

$35 USD in 3 days
(8 Reviews)
1.7
naveed6645

Dear Sir/Madam, I would like to work on your project, I can do it as per your request please contact us and let us know about work. i will provide you work as per your request. Please contact us, If you have problem w More

$30 USD in 0 days
(0 Reviews)
0.0
nistha6

Hello sir I read your requirements of Excel spreadsheet. I shall ensure accuracy and timely completion of the work. Thank you

$19 USD in 1 day
(0 Reviews)
0.0
Erastus87

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
mbwesselman

Although I am new to Freelacer, I am looking for ways to build my own portfolio while also helping others out in completing their own projects. I have over 15 years of Management experience in both Operations and Sale More

$20 USD in 1 day
(0 Reviews)
0.0
rgrohit81

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0