Jump to content
jamaicarocks

Website issue

Recommended Posts

Wuz up,

   

          I havent got a clue on where to even start so I'm seeking any advise ............my comapany has the need to perfom calculations and provide it's customers with the cost of their PV Solar system(equipment used to provide electricity by solar energy) based on the customers KiloWat usage,we have a excel spereadsheet that work out everything,but I'd like to know how would the info entered(KW usage) by the customers enter the excel spreadsheet to be calculated ,then the results return back to the Website to be viewed by customers ..................Is there a software that can accomplish this or is some form of programming involved ....................Thank You !!!!!

Share this post


Link to post
Share on other sites

Thank you,but how will the info be entered automatically in the Excel formula after the info is entered in the html form and then back to the website for viewing by the customers,and also ,how many people can have use of the excel spreadsheet to calculate their cost?

that is were a macro will come into place.

Share this post


Link to post
Share on other sites

I would program it using php or some other server side script..  otherwise you are running into a security issue.  Macros are known security issues.  I would highly recommend not using them on excel..  Instead use a web form that the user fills out then from there do the calculations and return the results.

Share this post


Link to post
Share on other sites

thanks,but what kind of forms should I use ,I only know of coffecup form builder,but it doesnt do calculations,is it a software type program,or would I have to write it using some code?

thank you

you will have to make some code that will add it to a database.

Share this post


Link to post
Share on other sites

I thought that you had to buy a licence to run asp on a server..

Eitherway jamaicarocks you are going to have to code the formulas again.  I dont know of a way other than converting the excel document into access database.  Which by the way isnt really a database made for a production environment at all.. I would highly recommend looking into an IIS/Apache, MySQL/Oracle XE, and a programming language (jsp, asp, php) to solve this problem..

Share this post


Link to post
Share on other sites

I know of IIS and I'm a MCDBA but not big on query languages....would I need to build the database over and enter the formulas again in a sql database?,or just import the formulas from excel to sql ,but then how would it go from the webpage (where the customer enters dat) to the database to be calculated the the result returned to the webpage............can IIS do this,I would prefer this method

Thank you!

Share this post


Link to post
Share on other sites

I thought that you had to buy a licence to run asp on a server..

you dont have to have one for just asp, you need a licence for asp.net

Do you just need the calculation done?  Or does the data have to be stored on the server?

I think it needs to be stored on the server.

Share this post


Link to post
Share on other sites

Sounds like a simple formula... I think you're way overcomplicating things with trying to use Excel sheets and macros over the internet... A simple script could do it.

Share this post


Link to post
Share on other sites

So I would be just using the php script in place of the Excel formulas,right ?,why would I also need the mysql database,for the web input by the customers?,how would this deal with simultaneous access where say ,10 customers want quotations at the same time?...........Is there any tutorial that can aid or guide me in this process because I know nothing about php scripts..

Thank you

Share this post


Link to post
Share on other sites

Yes

No, you don't need mysql if you aren't going to store the data

same way this site handles hundreds of users...

sure, but all you're doing is a calculation... not much to code.  I could do it fairly quickly I would suspect... depending on how complex your formula(s) are...

Share this post


Link to post
Share on other sites

×
×
  • Create New...