Technology & Social Media Excel Help please

I have the attached excel calculator that works extremely well for me and my clients in our offices
I have been asked if I can put it on the wholesale section of our website. ( they want to access from phones etc on the road)
Sure i said...easy. proved not so easy
The calculator has some pretty complex formulas that websites don't like.

Can you clever IT guys help??
In the usual version, the data sheets ( window and door) are hidden so people can not
change the prices, and the whole thing is password protected to prevent damage.

In this sample version, i have changed the prices to random numbers and have only protected the
calculator sheet so show that you should only be able to access the input fields.

I have looked at http://www.exceleverywhere.com/ but am totaly confused as to which version I would need.

Thanks

 

I'm pretty good with excel and happy to help you out.

Just a little unclear on what you're trying to do - presumably the folks on the road are opening it with Google Sheets on Android or whatever the iphone equivalent is (rather than Excel which is PC based)?

If you know what they're actually opening it with, then you can create (or possible convert) the sheet to suit that application. There are certain things that certain applications can and can't do.

 

I can answer most Excel questions anyone can throw at me (except for graphs, I suck at those), but I think that this isn't really an Excel question.
I'm assuming (like DT) that you're talking about embedding some form of pseudo Excel into your website similar to this?

 

I think that is the problem.. I don't know what they will opening with
Google sheets seems to struggle with the formulas. the iphone excel app works ok.
it would be nice to have it embeded into the website like any number of calculators out
there

 

YES something like that would be awesome
I thought I would be able to "save as HTML" but it seems not

 

Unfortunately, I think functionality like that is well outside the scope of HTML.

The easiest way to do it would be to take the spreadsheet, upload it to Onedrive and then embed it into your website.

 

I open Excel regularly with Numbers on the ipad. Pretty good, but I don't like editing it as the excel version then gets messy. If you just want read access, then save it as a PDF and just make it available. If you want them to have write access, where you put it is less important than the apps they use to access it. Personally, I find apps a lot, lot easier to use than Google Docs (or other online stuff), but the downside is you need an app that correctly handles Excel.

Oh, and by calculator you may have (haven't looked) macros or vb stuff that simply isn't going to work well anywhere but Excel :-(.

 

yup really the best way would be to just let them download the file, then they can have their computer convert the file. A few issues with this though, if people are using goggle docs then a lot of the time the formatting and formulas can get lost on the conversion. Also if people are using say a Mac instead of PC a lot of things can also get lost in conversion or just not work correctly.

Embedding into your website like above might look ok, but I doubt that is going to work with mobile phones, and it will throw up all sorts of issues with different browser types.

In my mind you have 2 options, first is to code it into the site, you will need a website designer and it might cost you a bit of $, also this depends on how complicated you want to make it, the more complicated the more $ it will cost. Think of say the bank mortgage calculators that you can go to online etc

Second, upload the spreadsheet and protect it, let people download it, if you have free membership on your site maybe they need to be signed in to download it. Then you can manage it a bit. Have a version for PC in excel and google docs, also one for the MAC, and then maybe a simple version for the phones.

Just make it a phone App and charge people..

Good luck

 

It works perfectly fine on Android 5.1 and I would assume that it works on all recent Android builds as well as apple.

It's even hosted by Microsoft if you do it that way. In my opinion it's just a much more user friendly and elegant solution.
People can always download the spreadsheet if they want if on their computer.

 

That is where Tableau comes into action.
I was a heavy Excel user but I'm a convert now

 

I have send the file to http://www.spreadsheetconverter.com/ and have asked which version of the software I need.

Will update when I find out. Thanks all for the help.