Im looking to automate a Sales Quotation spreadsheet. Essentially it will be a list of Requirements, Price table, Product specs table, and rule/criteria and a quote page listing the matching products and related price and quantities.
We are an all Apple Mac environment so we are restricted to Excel for Mac 2016 functionality unfortunately. (ie All functions, SQL, VBA Marcos etc should work but no Power Pivot and no multi table PowerPivot available.)
For Example:
Requirements (Drop down Lists)
1 Savings OR
2 Backup OR
3 Both
4 Budget Amount
5 Roof Type
Price table
1 Inverter A
2 Inverter B
3 Battery A
4 Battery B
5 Panel A
6 Panel B
Product specs table
1 Inverter A (5kw, Max 10 panels, Min 5 panels etc)
2 Inverter B (10kw, Max 20 panels, Min 5 panels etc)
…….
Rules/criteria
1 IF Savings THEN Inverter A, No Batt, Panel A
2 IF Backup THEN Inverter B, Batt B, Panel A or B)
etc etc
Quote page
Option A
Inverter A R 5000
Panel A R 5000
TOTAL R10000
Option B
Inverter B R 5000
Batt B R 2000
TOTAL R 8000
Hello Sir,
I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction.
I can help you with Excel for Mac work
I have more than 5 years of the experience in Excel, Mac OS, Software Architecture, SQL
Please ping me for more discussion.
Thanks.
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
Hello!
This is white horse Technologies and I was glad to see that you're looking for help for project excel Mac work. I've delivered more than 40 projects in the last 1 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
Hello there ,
I have gone through your project details and requirements regarding need of Excel for Mac expert.
We have experienced developers regarding the skill set you require for the successful completion of your project.
Please initiate a chat with us, so we can just help you out in your project asap.
Thanks "
Softpointzone.
Hello
I would be able to help you. I have over 10 years experience with excel and vba and I work on a Mac so I’m sure I will be the best fit for you.
If you could send over your data set and possibly any past examples of what you’ve been doing to date manually that would be greatly appreciated.
I hope to hear back from you soon.
Kind regards
Steve
Hi there,
I'm Jorge Padula co-founder of Toptive - Top Tier Developers .
We are a team based in Argentina with strong experience in software and mobile development.
SENIOR in Excel, Mac OS, Software Architecture, SQL.
We are able to do your project starting ASAP.
Do not hesitate to contact me if you are interested.
You will not regret,
Thank you very much,
Kindest regards,
Jorge