Simple sales quote calculator based on excel price charts
$30-250 CAD
Оплачується при отриманні
I need a sales quote calculator for Windows XP and Windows 7 that will allow me to enter a number of materials, each at different sizes, and calculate the total cost based on price charts stored in excel spreadsheets.
I am trying to streamline the quoting process.
Right now when my sales staff need to quote an order they have a book of spreadsheets in which they look up each item at each size and add up all the prices.
I'd like a simple program that will let them add any quantity of specific materials, each at a specific size (length x width), that will reference the excel entry for that material, at that size, and create a final total, with any applicable discounts.
It's important that it be able to reference an excel spreadsheet because our materials cost change over time and we'd like to be able to update it manually.
Specifics:
- 30 unique materials with corresponding excel files
- Up to 16 Rows X 32 Columns of prices (512 entries) for each material to be referenced
- Some materials have one price for the first unit ordered, and a discounted price for each additional.
- For each entry I need input boxes for:
- Quantity
- Material Type
- Length
- Width
- Discount Percentage
- A "+" button to add a new field
-A global discount percentage for simply discounting the entire order.
- Each new entry line should auto-fill from the previous, since most parameters are often similar (eg. quantity, size, discount).
- The Material Type field should be a drop down menu as well as auto-fill the alphabetically closest option, to speed up input.
- For ease and speed you should be able to use only the keyboard for all entries:
- ie. press Tab to go from field to field, press + to add a new entry line, press the up and down arrows to scroll through field options.
I do not need invoicing, saving or printing functionality, as we have that with our accounting software.
I am open to options that may be more simple than referencing excel files for pricing, as long as they allow for dynamic updating.
If this software works well I would be open to paying for added features in the future.
ID Проекту: #4308300
Про проект
21 фрілансерів(-и) готові виконати цю роботу у середньому за $123
I have 15 years exp in excel and access. I can create the form you need for your quoting process. Donna
Hello, I can accomplish the automated quote system you seek using Excel VBA. You will be able to create quotes as well as you will be able to change variables through an admin tab. I can even create a custom outpu Більше
Hi, MS Access/Excel expert having 8+ years of IT experience. I can do the project for you. Please see your PM for more details.
Dear sir, i can help you with this project. I have over 16 years of experience in C/C++ development.
Dear digitalpassword, we have carefully considered your project and we are glad to confirm that we can do it. We really appreciate considering us for your project. More details in PMB. Best Regards.
I have previous created pull downs and a GUI via Excel macro code. I have also extracted excel data and created new spreadsheets. All for a financial firm in NY, NY. I entered a low bid since I need the work and nee Більше