- Views 171
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:
So, this dynamic form can take orders, insert data into an Excel worksheet and print customized reports and all of that with the ability to perform automatic calculations such as:
1. Calculating the discount amount according to the quantity of products.
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.
In addition, the form can generate some customized reports in separate worksheets such as:
1. A cascaded report to generate a report according to the cascaded combo boxes.
2. By country report to generate a report with all related data to a selected country.
3. By city report to generate a report with all related data to a selected country and selected city in that country.
4. Entire report to generate a comprehensive report for the entire database.
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 countries names, cities names, stores names, products names, prices, route for delivery and delivery fees.
D- Change reports names or delete some of the existed reports.
E- 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.
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+$10
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 contains:
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.
F- The needed reports to be included and the needed reports to be deleted.
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, 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.
Note: All my work is produced on Windows environment.