[SOLVED] Is my excel too complicated?

[Mark Conway]

Hi there,

I have an excel sheet I would like to use via Woo Price Calc… But I am really struggling to make it work. I have watched the explainer video numerous times and I am starting to get the impression it may not work for what I need…

Your help would be very much appreciated.

So basically, we lease cars…. the customer will choose the MPA (mileage per annum) and the payment profile (3+23, 6+23 etc). The payment profile is basically the customer deposit. So 3+ means the deposit is 3 x the price shown and 6+ is 6 x the monthly, and so on. Then the 23 simply refers to the remaining 23 months of a 24 month contract.

If i need to re-do the excel i can… However I would need direction of how it will need to be laid out.

I really hope you can help with this!

I have attached the excel.

[david]

Hi Mark,

No I think that our plugin can manage your Excel. We changed your worksheet with very simple Excel formulas (See attachment).

If you see all the input fields and the output field (price), you can realize that our plugin is ok for your needs.

Anyway if you’ll buy it and you’ll have any problems we will give you help or you can have refund money back.

Bye,
David
AT19

[Author]

Posts