Results 1 to 7 of 7

Thread: Microsoft Excel

  1. #1

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Microsoft Excel

    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]


  2.  
  3. #2

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Microsoft Excel

    Quote Originally Posted by burrocrat View Post
    ok, before i get into the specifics i want to tell you about my problem. i am having an msexcel spreadsheet issue and i need some help. i know there is a spreadsheet tips thread somewhere but i can't find it and i am getting ticked off. i have tried the pretend it's a car starter technique but it is not working. first i talked sweet to it 'you are a pretty spreadsheet' and tapped up and down it with the digital equivalent of a crescent wrench 'please turn over for me honey', but no go... then i hit it harder 'you like that huh? roll over baby, now!', but that didn't work either. so i am about out of patience and either am going to break the wrench or the freakin starter next attempt because it ain't working now so what is there to lose?

    but i figured i would ask for help from some experts first, lucky spreadsheet.
    Quote Originally Posted by burrocrat View Post
    i have data that looks like this...

    Attachment 36645
    Quote Originally Posted by burrocrat View Post
    i desire a chart that looks something like this...

    Attachment 36646

    basically along the x axis i want the weekly date starting at beginning of the year 160101 and eventually running through 161231 the end of the year.

    also i want the y axis to be 0% in the middle and ranging up or down depending on tsp.gov fund gains.

    and for the lines in the chart i want 7 of them: burrocrat, burros-ark, and the 5 main tsp funds g f c s i, each of them in a different color.

    and then after that i want a legend that tells you which color is me or the system or the funds what represent.

    and also if it is not too much trouble i would like a title for the map that says "burros-ark 2016", but i am seriously considering changing that to "kiss my a** bill gates and all your minions can s*** my spreadsheet d***!".

    i have put the crescent wrench away now and am feeling a bit calmer so i will just trust the expertise on this board and be patient and wait...

    thanks.
    I'm far from an expert, but would something like this be helpful for starters?
    burro.png
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  4.  
  5. #3

    Default Re: Microsoft Excel

    that is basically what i want but i can't make the spreadsheet do it.

    maybe if somebody has too much time on their hands they could use the data i posted and make it look like that then tell me how? because i have followed all the example i can find and it is not working.
    100g

  6.  
  7. #4

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Microsoft Excel

    Quote Originally Posted by burrocrat View Post
    that is basically what i want but i can't make the spreadsheet do it.

    maybe if somebody has too much time on their hands they could use the data i posted and make it look like that then tell me how? because i have followed all the example i can find and it is not working.
    ?

    burro.png
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  8.  
  9. #5

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Microsoft Excel

    xlwings - Replace Excel VBA with Python!

    Free and Open-Source

    Make Excel fly with Python!

    Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis. Supports Windows & Mac!

    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  10.  
  11. #6

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Microsoft Excel

    There’s a world championship for Excel spreadsheets
    https://nypost.com/2017/08/07/theres...-spreadsheets/

    "DUMFRIES, Va. — John Dumoulin has never really set foot in an office. He works part-time at Chick-fil-A.
    But the 17-year-old from northern Virginia is the undisputed king of that bane of office workers everywhere — the spreadsheet. Dumoulin won an international competition on Microsoft Excel proficiency, earning $10,000 in prize money along the way.

    ..."
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  12.  
  13. #7

    Default Re: Microsoft Excel

    Quote Originally Posted by userque View Post
    There’s a world championship for Excel spreadsheets
    https://nypost.com/2017/08/07/theres...-spreadsheets/

    "DUMFRIES, Va. — John Dumoulin has never really set foot in an office. He works part-time at Chick-fil-A.
    But the 17-year-old from northern Virginia is the undisputed king of that bane of office workers everywhere — the spreadsheet. Dumoulin won an international competition on Microsoft Excel proficiency, earning $10,000 in prize money along the way.

    ..."
    Drats, I'm too old to compete
    Check out the TSP Poker Club stats: https://goo.gl/cUv6Yj
    Come join the fun: http://www.tsptalk.com/mb/the-lounge...oker-club.html

  14.  

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Microsoft Excel
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Microsoft Excel
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Microsoft Excel
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Microsoft Excel
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes