-
Comparison site needed using an excel spreadsheet for the results
Thanks for your reply and interest in this topic it's really useful. That may look simple to you but as a none programmer it's a bit eye watering. If you think JS will be a more useful way of doing things i think i'll explore that route. I'm thinking to pass the spreadsheet to someone such as yourself who knows how to convert it and go from there. I was exploring the excel route as I know how that works and thought a simple integration may be best but if the way you describe is more stable maybe thats the best route. I was just trying to keep the cost's down and expect this may run into 10,000's. I might try and outsource this task on a forum like GURU. Is that wise or do I really need to spend alot to get the right result? Thanks again for your help
-
Comparison site needed using an excel spreadsheet for the results
Thanks for all your debate and input on this guys. It's just what i was after. The reason i was looking to use a spreadsheet is that i've built it already and it's quote complex over multiple sheet with many formula's. I don't know how easy it would be to covert to the above mentioned into code. For example i;ve got about 50 IF functions like this =+IF(P15<99999,0,IF(AND(P15>99999,P15<249999),P15-O24-O23-O25,999999-O24-O23-O25)) I was just hoping that there would be some easier way to integrate it into a site with the spreadsheet sitting behind it doing all the work. It would also be my preferred method as i could then change the spreadsheet myself to reflect price changes which happen all the time. If it was in code i'd need someone to change the formula's on a regular basis. I'll have a look into the suggested office 365 option and also speak to a web designer to see how long it would take to convert what I already have into code. I really appreciate your expert input on this though so thanks again. I'll post an update and hopefully site with the preferred solution if and when it's done
-
Comparison site needed using an excel spreadsheet for the results
My spreadsheet has alot of calculations in it. Can these be imported to either of these languages or will i need to build them from scratch. Thanks for you help
-
Comparison site needed using an excel spreadsheet for the results
Hi i'm relaively new to web design but am stuggling to find a suitable plugin or solution for what i want. I have built an excel spreadsheet which i wish to be used to make a comparison calculation in a website. I basically want the user to input data at the front end, which then goes into the spreadsheet and then displays the results at the back end on another web page. I don't just want to integrate a spreadsheet onto the web page as they don't look very attractive. The front and back end needs to look attractive. It is a comparison site so needs to look and feel like the one and not just a website with an excel spreadsheet on it. The results page needs to bring forward the results and then display them along with other data about that company (which doesn't have to be in the spreadsheet but held elsewhere on the wordpress site ) so for example. A client puts in an amount say £100 at the front end. The spreadsheet does the calculation and then displays the companies which give the best return for that amount. e.g. Company A 1.2% Company B 2.5% Company C4.5%. (the speadsheet will do the calculation. On the results page however i then want data about that company so for example Company A has 5 employees, was established in 1980 and is based in London. It needs to work like the usual comparison sites such as comparing life and car insurance. I can't find how to use a spread sheet to do calculations behind a site and display and order the results. Is there anyone that could point me in the right direction or offer to build this for me. Thanks in advance