TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker and becoming a Supporting Member. For more info: Support TMC

psa: how to post nice tables from excel

Discussion in 'TSLA Investor Discussions' started by luvb2b, Aug 30, 2018.

  1. luvb2b

    luvb2b Member

    Joined:
    Mar 18, 2013
    Messages:
    962
    Location:
    thebeach
    quick psa for those who like to share info on various spreadsheets. these are the tricks i use to post my models each quarter.

    use a formula in excel like this... the example below goes in cell b5. put the row title in cell a5 and the numbers to present in c5,d5,e5,f5.
    ="{TR}{TD}{B}"&A5&"{/B}{/TD}{TD2}{B}"&TEXT(C5,"#,##0")&"{/B}{/TD2}{TD2}{B}"&TEXT(D5,"#,##0")&"{/B}{/TD2}{TD2}{B}"&TEXT(E5,"#,##0")&"{/B}{/TD2}{TD2}{B}"&TEXT(F5,"#,##0")&"{/B}{/TD2}{/TR}"

    replace all the curly braces with square braces (i can't post square braces otherwise when i post this system will process as tags. see the text file for the actual formula for cell b5.

    you can use mmm-yy format for dates. or percentages you can imagine 0.00% format. or whatever other format you need can replace the "#,##0"

    just use one such formula in column b for everything in your spreadsheet. copy and paste out of column b to a post. add {TABLE} and {/TABLE} (again square brackets not curly braces) at the top and bottom to mark the table for the system.

    when you're done should look like this (you might see the code in the quote when you reply).


    luv q4-18eluv q3-18eJun-18Mar-18
     

    Attached Files:

    • Love x 3
    • Helpful x 2
    • Like x 1
  2. ggr

    ggr Roadster R80 537, SigS P85 29, M3P 80k

    Joined:
    Mar 24, 2011
    Messages:
    5,080
    Location:
    San Diego, CA
    You are worth every cent we pay you! Wanna be a moderator?
     
    • Like x 1
    • Love x 1
  3. luvb2b

    luvb2b Member

    Joined:
    Mar 18, 2013
    Messages:
    962
    Location:
    thebeach
    thank you for the offer. i must respectfully decline as tesla is consuming too much of my time and treasure already.
     
    • Funny x 3
    • Informative x 1

Share This Page

  • About Us

    Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.
  • Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


    SUPPORT TMC