Advice how to simulate spreadsheet in website.

[melaniekelley]

Can anyone make a recommendation how I would create the ability to do price calculations on a website, preferably in PHP script.

I have built out an excel matrix for my pricing that is based on variable lookups and then multiply that number by the quantity. My pricing is dependent on quantity price breaks (ex. 1-47, 48-71,72-143) and the number of inks used in the final product.

How would I simulate that concept on a website. Allow the user to input 2 variables and populate a price dependent on the how I described my spreadsheet.

I am clueless where to begin this process or how to look for help. How does one built something like this on a website?

Please send ideals.

 

[JP2112]

This has nothing to do with Excel or VBA per se. You will need to translate your matrix into PHP. What you'll probably need is a self-submitting form that calculates input values and displays the result. Try searching for "php form tutorial" on your favorite search engine to get started. Here are some promising links.

http://www.html-form-guide.com/php-form/php-form-action-self.html
http://www.tizag.com/phpT/forms.php