Build Excel Data enrty and management forms - TWO seperate forms required
$10-30 USD
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
Nº del proyecto: #11210142
Sobre el proyecto
12 freelancers están ofertando un promedio de $21 por este trabajo
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
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
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
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
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
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