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

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado Pagado a la entrega

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

Entrada de datos Procesamiento de datos Formularios electrónicos Excel Format and Layout

Nº del proyecto: #11210142

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 7 años

12 freelancers están ofertando un promedio de $21 por este trabajo

schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience . I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in pas Más

$25 USD en 1 día
(414 comentarios)
8.3
shafaqat11

Hello Sir, How are you? 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 Más

$30 USD en 2 días
(107 comentarios)
6.2
muradeltaher

my name is murad Mechanical engineer 10 year experience new on freelancer trying it see what will it do for me Autocad 2d 3d MEP HVAC Experience i'll send you my CV

$25 USD en 1 día
(94 comentarios)
5.3
abcmarketersbd

Hello, My 4 years experience in data entry, customer service and internet research has prepared me to be a perfect match for this position. I believe that my skills, experience and reputation for excellence can gre Más

$15 USD en 1 día
(1 comentario)
0.4
mostafaemamit

Hi, I am interested in your job as I have a enough good experience in marketing sector working as business analyst using Excel to handle data size 800.000 Row to prepare a professional Reports for top management. K Más

$25 USD en 1 día
(1 comentario)
0.0
Xaibyousaf

A proposal has not yet been provided

$24 USD en 3 días
(0 comentarios)
0.0
JamelahDenoyo

Dear Madam / Sir; Good day! I am Jamelah M. Denoyo, 28 years old, Filipino citizen from Philippines. I have significant experience in clerical works such as copying, editing, making letter, proposals, research, Más

$10 USD en 1 día
(0 comentarios)
0.0
pjm326

Hello, I am a 25 year old Canadian business student. I am very proficient with excel and am looking to build a reputation for myself on this site. I could get started on your project right away and will provide many Más

$35 USD en 1 día
(0 comentarios)
0.0