Build an Excel Spreadsheet to automate the quotation process
$10-30 CAD
Terminado
Publicado hace alrededor de 8 años
$10-30 CAD
Pagado a la entrega
Designing spread sheet to act as a quotation tool
It will have 5 tabs. and should look and feel like an automated tool
These are the tabs
1. Menu --- with buttons to select user (VAR [Value Added Reseller], affiliate Reseller, Admin)
2. VAR (inputs: currency, Exchange rate of the day, select a package, #of users per package, branded option yes or no, aditional discount --》outputs: price per unit, total price, commission take home in % and $)
3. Affiliate re-seller (input: currency, package, #of users, branded option, additional discount --》output of price per unit and commission take home in % and $)
[login to view URL] quotation - creates a custom quotation based on selection on previous sheets... resellers have to send us the quote sheet for each order (button to pdf)
5. Admin panel - password protected and hidden (allows to change equation by package, Allow to add currency bias, allows us to change the admin fees play with the percentage give aways per package. For each user type)
Hi,
I have more than 14 years of VBA/Excel exp and I am expert in this kind of work.
I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work.
Waiting for your positive response.
Thanks.
$70 CAD en 10 días
4,9 (124 comentarios)
6,3
6,3
17 freelancers están ofertando un promedio de $59 CAD por este trabajo
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance
- Build a reservation system
- Build a complex shift allowance calendar and calculator
Hi
I am an experienced Excel and Access developer having expertise in smart spreadsheet and database solution design. I can create your specified quotation solution in Excel or if you are looking for more serious solution than I can even create an Access solution which will look far more professional than Excel spreadsheet. And the best thing is, I am offering your same rate for platform of your choice.
If you have any question than please don't hesitate to ask.
Hope to hear from you soon.
Thanks
As an expert of excel macros and VBA coding and MS access, this can be done easily and with 100% quality. I have 6 years experience as a VBA Developer.
we at LumiNysis are experts in excel and Vba automation and work towards providing high quality solutions to our business partners. We have already developed quotation tools for our clients in past and can handle this with utmost ease.
I have over 4 years experience as a data analyst. I have been doing data entry job for over 5 years using MS Excel as a major tool.
I also have excellent customer service for 5 years.
Outline
Get all detailed data from client
Design quotation template
Automate formula
Test run automation
Input data and review
Sent to client
I will like to be at your service. Expecting your earliest revert.
Thanks.
Isaac (+23408060465320)
I have 2 ½ year experience in Dun & Bradstreet (D&B) Sri Lanka as an Operations Executive. Data gathering from web, registries and by contacting customer and filling the collected information in to a template given by the D&B was the main duty in my job role.
Currently I’m working at John Keels the largest group in SL as a Credit Control Executive. I am preparing various kind of reports which requested by the top management, conducting credit review meetings and handling customer inquiries which related to credit issues
With the experience, trust that I have the capacity and the confidence to complete your project on time with 100% accuracy and your with your satisfaction.