Good day all ,
does anyone know how to write codes for excel formulas not necessarily phpexcel, something like using php to create forms that calculate Balance sheets, Income sheets and more and also rate you(AAA, AA-,BB-, etc...).

    5 days later

    Well that task is quite simple the first thing you need to do is create a mysql database something like company name. Then create the tables that you will need to input your figures into. The last part will be setting up your mathematical operations. With MySQL and PHP you can setup a standard HTML Table with Input fields and headers and allow for the addition of columns as needed. The last thing you would have to do is to have PHP check each cell for any mathematical equations. If an equation is found then you can have PHP process it just as excel would in concept. PHP can notate each cell in the table with a name such as "A1", "A2", "B2", etc. When the form is submitted then your code can be processed and an editable display can be presented. The downside is that the position of your mathematical equation would only return a result. To counter act this you can have the mathematical equation stored and when you click on the field a popup through <div> tags and layers could overlay the equation or you could have a title bar similar to excel to allow for the viewing of equations.

    As far as having the ability to start an equation as =sum(A1:B16); you would have to add a little custom code to handle these new options.

    You also have to get down and dirty with some JavaScript if you wanted to be able to highlight Cells as you are able to in excel to create quick =sum(A5:C52); equations.

    I'm not sure exactly what your trying to do but if you need shared spreadsheet work. I would suggest using google docs for this. It is doable with JavaScript, PHP and MySQL as you can see in Google Docs. However I'm not sure what backend they use to store the data.

    I hope this helps but to actually undertake writing all of the code is a full job so I think this will probably be the best answer your going to get beyond hiring someone.

      Write a Reply...