WordPress.org

Ready to get started?Download WordPress

Forums

insert a numerical formula into a post (10 posts)

  1. Ruth at Virtual Balance
    Member
    Posted 3 years ago #

    I want to insert into a post an interactive facility to do a mathematical calculation. In fact, it's to calculate hourly salary from annual figure. It's a quite simple formula and I have it in an Excel worksheet - it's two cells of that worksheet that I want to insert into my post.
    Is this possible? If so, how?
    Thanks

  2. esmi
    Forum Moderator
    Posted 3 years ago #

    You'd need to look for a suitable plugin.

  3. Ruth at Virtual Balance
    Member
    Posted 3 years ago #

    Thanks, I'll see what there is!

  4. Ruth at Virtual Balance
    Member
    Posted 3 years ago #

    No, the one I chose didn't work.

  5. datawiz
    Member
    Posted 3 years ago #

    Try using Excel Web App. In this post, I have an example of an Excel spreadsheet, with live formulas, embedded in a post:
    http://datawiz.wordpress.com/2011/01/14/creating-a-web-calculator-using-excel/

  6. Ruth at Virtual Balance
    Member
    Posted 3 years ago #

    Thanks, datawiz, that seems like just the thing I was looking for!

  7. Ruth at Virtual Balance
    Member
    Posted 3 years ago #

    Well, I tried it and it worked! It needed a bit of fiddling about, but well worth it. Thank you so much and here's a link to see what is looks like: http://mypaperwork.co.uk/business-basics/time/

  8. datawiz
    Member
    Posted 3 years ago #

    Great to see that it worked!
    I have created a short post with another version of your calculator - I've added more graphics and conditional formatting. I hope you like it:
    http://datawiz.wordpress.com/2011/01/17/real-world-embedded-pay-calculator-and-comparison/

  9. forextradingstrategiesplan com
    Member
    Posted 2 years ago #

    Thank you for sharing the useful information, it worked for me.

    However, datawiz, do you think the scolling bar on your web site is annoying? I found a solution to remove the iframe scrolling bar.

    You simply need to select the area rather than publishng the entire workbook. See my example on Forex Trading Strategies.

    If you are still not able to work it out, send me an email, I can send the screenshot of my setting to you.

  10. roydavy
    Member
    Posted 2 years ago #

    This doesn't work for me for some reason. all i can see is the Excel Web App bar at the bottom of the page, no table...

    i would like to publish this spreadsheet to my site. The blue highlighted cells are the input fields. As soon as a number is inserted the rest of the fields are automatically calculated.

    I found a program that installs into Excel and it works like a charm! However this app costs $100. for converting 1 excel doc i don't think its worth it.. http://www.spreadsheetconverter.com/

    Is there an easy solution and cheap, such as what this "sreadsheetconverter" has to offer, out there?

Topic Closed

This topic has been closed to new replies.

About this Topic