Join Australia's most dynamic and respected property investment community

Excel Help please

Discussion in 'Living Room' started by moyjos, 27th Oct, 2015.

  1. moyjos

    moyjos Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    280
    Location:
    Sunshine Coast
    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
     

    Attached Files:

  2. D.T.

    D.T. Adelaide Property Manager Business Member

    Joined:
    13th Jun, 2015
    Posts:
    5,571
    Location:
    Adelaide, SA
    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.
     
  3. spludgey

    spludgey Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    679
    Location:
    Sydney
    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?
     
  4. moyjos

    moyjos Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    280
    Location:
    Sunshine Coast
    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
     
  5. moyjos

    moyjos Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    280
    Location:
    Sunshine Coast
    :) YES something like that would be awesome
    I thought I would be able to "save as HTML" but it seems not
     
  6. spludgey

    spludgey Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    679
    Location:
    Sydney
    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.
     
  7. mcarthur

    mcarthur Well-Known Member

    Joined:
    19th Jun, 2015
    Posts:
    521
    Location:
    ACT
    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 :-(.
     
  8. Matty77

    Matty77 Active Member

    Joined:
    21st Sep, 2015
    Posts:
    44
    Location:
    Adelaide
    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
     
  9. spludgey

    spludgey Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    679
    Location:
    Sydney
    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.
     
  10. devank

    devank Look, lets just get on with this, ok? Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    714
    Location:
    Inner West - Sydney
    That is where Tableau comes into action.
    I was a heavy Excel user but I'm a convert now :)
     
  11. geoffw

    geoffw Moderator Staff Member

    Joined:
    15th Jun, 2015
    Posts:
    2,125
    Location:
    Canberra
    It looks as if some vlookups or similar have been used and it may be difficult to translate.

    The easiest would be to post a job on Upwork and get somebody to do it. I'd guess that $50 would be the absolute maximum you'd have to pay.
     
    moyjos likes this.
  12. moyjos

    moyjos Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    280
    Location:
    Sunshine Coast