Build Excel Data enrty and management forms - TWO seperate forms required

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

1) Daily DATA form that creates several different required 'printable' and easy to collect information

- SHEET 1

The USER sheet to enter the data, possibly by using a "User Form" for fast and accurate data verification as it's entered.

~ Collection Fields

a) Customer / Contract

Possible a drop down box on "User Form" with most common entries (updated after first entry of that data)

b) Location / Warehouse

Possible a drop down box or text entry on "User Form" with most common entries (updated after first entry of that data)

c) Day & Date (Date, Day, Month & Year)

Possibly a calendar 'Date Picker' on "User Form"

e) Numbers 1 - 20, numerical reference of daily deliveries

f) Booking Allocation, requested time slot eg. 8am-10am or AM (7:30am - 12:30pm) Possible a drop down box or text entry on "User Form" with most common entries

g) Invoice / Account #, the original document reference

"User Form" MUST receive (x) characters and applies correct format eg. 6003200200 appears on table as 6003 200 200. if character is missing 'Alert' and request correction

h) Customer Name

i) Full delivery address

j) Contact number

k) Delivery type

Possible a drop down box or text entry on "User Form" with most common entries

l) Number of Items / Cartons

Possible a drop down box with fixed options 1 - 25

m) 2 Persons Delivery?

Possible a drop down box with fixed options Yes or NO

n) C.O.D Is there cash to collect on delivery

Possible a drop down box with fixed options Yes or NO

o) Install / Assembly item

Possible a drop down box or text entry on "User Form" with most common entries

p) Comments / Notes

q) Email

r) Additional Phone #'s

s) Lead information, Description of where lead was created eg. Contract, Type of work,

SHEET 2

Daily Run Sheet

Created from data collected in SHEET 1

Layout will be supplied after project awarded

** TO BE PRINTABLE**

SHEET 3

Time Record Sheet

Created from data collected in SHEET 1

Layout will be supplied after project awarded

** TO BE PRINTABLE**

SHEET 4

Data Record Sheet

Collects fields from SHEET 1 for quick reference

Delivery type DATA eg. Bronze, Silver, Gold, NO ATTENDANCE, REFUSED totals

DATA

h) i) j) q) r) s) easy to cut to data base in correct formats

2) Quote Costing Calculator

Excel Sheet

SHEET 1

Drop down boxes, ALL Perth WA suburbs to choose from SHEET 2

Check Boxes x3 must choose one

<25kgs

<120kgs

>121kgs

Tick Boxes

Stairs

Excessive Decline / Incline

Bulky / Odd Shape or size

Requires "Physical Lifting" not manoeuvred on hand trolley (eg. Couches, Mattresses)

Uneven ground or Sand

Clear access and Cartons will fit through ANY openings?.

DISPLAY COSTING TOTAL

SHEET 2

Area to Area DATA

Sheet will have a table of

Headers eg. a, b, c, d, e and so on

Columns will have the allocated data for the specific area

ALL ROWS & COLUMNS will be DATA for Drop down boxes on SHEET 1

SHEET 3

Costing DATA

Headers eg. Booking fee, Pick up fee, deliver fee and so on

ALSO require (But NOT PRICED or IMPORTANT)

3) Public Pricing Brochure (Printable)

4) Quotation Template

Electronic Forms Excel Format and Layout

Project ID: #11223222

About the project

5 proposals Remote project Active 7 years ago

5 freelancers are bidding on average $23 for this job

alpha2alpha

Hi sir, i have read your description and i am interested in your project. i have 2-year experience Data Entry Spare me some time that we can speak about project. Waiting for your positive response

$19 AUD in 1 day
(4 Reviews)
2.9
veranija

Hi I would like to do your task. I guarantee the accuracy and on time delivery of the work to be done. Please let me know the task in detail. then we can discuss what you really expect to do. Time and the payment of More

$15 AUD in 1 day
(2 Reviews)
1.3
Aquibur

Hi, Your project description is much detailed. I am an experienced marketing professional who is well versed in MS Excel and many other analytics tools. With knowledge and speed of working on several excel projects, I More

$25 AUD in 1 day
(0 Reviews)
0.0
rabindra85

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0