- Views 165
What you get with this Offer
So, this dynamic form can take orders and insert data into an Excel worksheet with the ability to perform some automatic calculations such as:
1.Calculating the discount amount according to the quantity of products.
(the initial values are: if quantity more than 1 and less than 100 the discount rate is 2%
if quantity more than 99 and less than 200 the discount rate is 4%
if quantity more than 199 and less than 1000000 the discount rate is 6%)
2. Calculation the cost before and after discount rate.
3. Calculating the days to deliver the product.
4. Calculating the tax amount.
5. Calculating the delivery fees.
6. Calculating the cost after taxes.
7. Reaching the final cost of the order by adding all calculated costs.
8. User can insert, edit and delete the row data such as the countries, cities, stores and products.
The customer must know that he or she will get the following:
1- The source of the excel workbook so that customer can perform modifications in the future according to the business needs ( No passwords are hidden).
2-As long as customer will get the worksheet as it appears on the video without modifications, the delivery will be in one working day.
3- If the customer needs modifications on the workbook , the allowed modifications without any change to the price will be limited to :
A- Change Labels names
B- Delete unneeded fields from the workbook.
C- Change the background color or the form fields or buttons colors.
and the delivery of the excel workbook will be in 2 working days.
For the OPTIONAL ADD-ON SERVICES TO THE BUYER the extra days are calculated as working days so weekends are excluded.
The most important part is that the customer should know I'm looking for this business as:
"Simply, we deliver work on time with high quality and satisfaction is guaranteed"
Note: All my work is produced on Windows environment.
Get more with Offer Add-ons
I can add 5 more fields and one of them is to perform calculations+ change colors.
Additional 3 working days+$15
I can add 15 more fields and 3 of them is to perform calculations+change colors.
Additional 5 working days+$35
What the Freelancer needs to start the work
If the customer will get the Excel Workbook as it is without any changes , nothing is needed to deliver the workbook as the time frame will be 1 working day.
But If any more modifications are needed and to define exactly the time frame to deliver the workbook ,the customer should provide some information which are not limited to :
1- A full description of the needed modifications which such as:
A- number of fields.
B- Fields label name.
C- The needed discount rate percentage and according to what quantity.
D- Color of the background , fields and buttons.
E-countries names, cities names, stores names, products names prices , route for delivery and delivery fees.
Hence, The delivery date will be according to the needed modifications.
The most important point is that all of the above modifications are for free and are included in the price with no extra charge.
But if the customer needs a form from scratch with specific calculations , a custom job will be ideal for that.
Please,Know that I will be happy if you contact me before purchase to answer any inquiry in your mind.
Finally, any inquiry form customers and potential customers are welcomed with pleasure.