Excel dudes

Discussion in 'The Mainboard' started by skiedfrillet, Jul 31, 2018.

  1. skiedfrillet

    skiedfrillet It's not a lie if you believe it.
    Donor
    Clemson Tigers

    what's the formula if I want to do G4 - J4, G5 - J5, etc so forth and so on? i don't want to write =G4-J4, G5-J5, etc 200 times
     
  2. angus

    angus Well-Known Member
    Donor

    Write it once. Click on the little plus button in the corner and drag to copy to the rest.
     
  3. Frank Costello

    Frank Costello I want my environment to be a product of me.
    Sacramento Kings

    F4 to make it absolute
     
  4. angus

    angus Well-Known Member
    Donor

    That's also like 6th grade level excel. HTH
     
  5. skiedfrillet

    skiedfrillet It's not a lie if you believe it.
    Donor
    Clemson Tigers

    your mom's 6th grade level excel
     
  6. angus

    angus Well-Known Member
    Donor

    YOU'RE WELCOME
     
    tjsblue, sem, Arkadin and 4 others like this.
  7. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    Is this your first time using excel?
     
  8. skiedfrillet

    skiedfrillet It's not a lie if you believe it.
    Donor
    Clemson Tigers

     
  9. HatterasJack

    HatterasJack Is your refrigerator running? It's Mike Hunt.
    Donor

    Any more brain busters?
     
  10. Joshuam2107

    Joshuam2107 SUH DUDE
    Donor

    Spell Rizzuto
     
    laxjoe, Owsley, a.tramp and 12 others like this.
  11. Emma

    Emma Wisconsin Sports
    Donor
    Wisconsin BadgersMilwaukee Brewers altMilwaukee BucksGreen Bay Packers

    Have you tried putting it in a microwave?
     
    Owsley and a.tramp like this.
  12. Corch

    Corch Hmm surprised you didn't know that
    Donor
    Ohio State BuckeyesDenver NuggetsCleveland BrownsColorado State RamsCleveland CavaliersCleveland Indians

  13. Taques

    Taques yung malarkey
    Staff Donor TMB OG
    PCd'I

    what’s the square root of this apartment
     
  14. Nelson

    Nelson Can somebody please get Ja Rule on the phone
    Donor
    Nebraska CornhuskersDenver NuggetsDenver BroncosColorado AvalanceBorussia DortmundManchester UnitedColorado State Rams

    holy Christ
     
    Owsley, kinghill, dawgonit and 5 others like this.
  15. a.tramp

    a.tramp Insubordinate and churlish
    Donor
    Kansas State WildcatsTexas Rangers

    OP excels at dudes
     
    Owsley, kennypowers, Goose and 21 others like this.
  16. Taques

    Taques yung malarkey
    Staff Donor TMB OG
    PCd'I

    not in my experience
     
    Goose, miles, Kirk Fogg and 3 others like this.
  17. ned's head

    ned's head Well-Known Member

    Friedskillet got this shit

    [​IMG]
     
  18. Cheshire Bridge

    Cheshire Bridge 2017 & 2019 National Champions - Clemson Tigers
    Donor
    Clemson TigersAtlanta BravesTiger WoodsCollege Football Playoff

    [​IMG]
     
    Clemson327, dawgonit, Goose and 6 others like this.
  19. nofatchildren

    nofatchildren Bull Moose Till I Die
    Donor TMB OG
    Washington NationalsToronto RaptorsKansas City ChiefsSt. Louis BluesTiger Woods

    The first thing I do when my VDI at work gets updates pushed is uninstall Excel. I don't want to be tempted to use that piece of shit in a moment of weakness.
     
  20. broXcore

    broXcore cat
    Donor
    Kansas State WildcatsKansas City ChiefsSporting Kansas CityTottenham HotspurDSA

  21. Louis Holth

    Louis Holth David LaChapelle levels of not giving a fuck
    Donor
    South Carolina GamecocksAtlanta BravesCharlotte HornetsCarolina PanthersTottenham Hotspur

    It’s hard to learn excel when you’re busy being the preeminent fast food critic
     
    Nelson and a.tramp like this.
  22. Nelson

    Nelson Can somebody please get Ja Rule on the phone
    Donor
    Nebraska CornhuskersDenver NuggetsDenver BroncosColorado AvalanceBorussia DortmundManchester UnitedColorado State Rams

  23. skiedfrillet

    skiedfrillet It's not a lie if you believe it.
    Donor
    Clemson Tigers

    i had a turkey, american cheese bc i'm not a terrorist, honey mustard, and lettuce sandwich

    my side was some delicious jalapeno cape cod chips
     
    a.tramp, Corch and Goose like this.
  24. Toast

    Toast I watch you sleep.
    Donor
    Chicago White SoxChicago BearsChicago BlackhawksKansas State WildcatsMontreal Impact

    Joe_Pesci likes this.
  25. Redav

    Redav My favorite meat is hotdog
    Donor

    Have you tried shutting down your computer and restarting it?
     
  26. Icculus is a Bammer

    Icculus is a Bammer marco esquandolas took my job
    Donor
    New Orleans PelicansNew Orleans SaintsDC United

    Not before deleting all temporary files
     
    Redav likes this.
  27. The Banks

    The Banks TMB's Alaskan
    Donor TMB OG
    Oregon DucksGreen Bay PackersDetroit Red WingsBayern Munich

    I remember when I learned that if I wanted to type 1, 2, 3...100 I didn’t need to do all of them, just the first few then select them and drag.
     
  28. The Banks

    The Banks TMB's Alaskan
    Donor TMB OG
    Oregon DucksGreen Bay PackersDetroit Red WingsBayern Munich

  29. White Tajh Boyd

    White Tajh Boyd You've gotta be on the team to get a ring.
    Donor
    Clemson TigersAtlanta BravesCarolina PanthersCollege Football PlayoffUnited States Men's National Soccer Team

    Microsoft Word users. How do you change the font?
     
    TC, blind dog and Where Eagles Dare like this.
  30. miles

    miles All I know is my gut says, maybe
    Donor

    help computer
     
    dawgonit likes this.
  31. killrbee7

    killrbee7 EMAGin' and Swaggin'
    Donor TMB OG
    South Carolina GamecocksAtlanta BravesCarolina PanthersLiverpool

    Clemson education really pays off.
     
  32. Louis Holth

    Louis Holth David LaChapelle levels of not giving a fuck
    Donor
    South Carolina GamecocksAtlanta BravesCharlotte HornetsCarolina PanthersTottenham Hotspur

    You would know
     
    TC and killrbee7 like this.
  33. killrbee7

    killrbee7 EMAGin' and Swaggin'
    Donor TMB OG
    South Carolina GamecocksAtlanta BravesCarolina PanthersLiverpool

    That SEC speed ridiculous
     
    Louis Holth likes this.
  34. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    You don't even need to drag rookie. All you have to do is double click the bottom right-hand corner of the cell and it will auto-fill for you
     
  35. Louis Holth

    Louis Holth David LaChapelle levels of not giving a fuck
    Donor
    South Carolina GamecocksAtlanta BravesCharlotte HornetsCarolina PanthersTottenham Hotspur

    Getting ready for the season
     
  36. Arrec Bardwin

    Arrec Bardwin He ain’t me, he can’t be me
    Donor
    Auburn TigersAtlanta BravesAtlanta FalconsChelseaAtlanta United

    Hey kid, I’m a computa.

    Stop all the downloadin.
     
  37. ned's head

    ned's head Well-Known Member

    I fear that this thread is going to discourage skiedfrillet from seeking help and his next work project is going to end up like


    [​IMG]
     
    #37 ned's head, Aug 1, 2018
    Last edited: Dec 26, 2019
    LetItSoak likes this.
  38. racer

    racer Fuck Tucker, Tucker sucks.
    Donor
    Iowa HawkeyesKansas City ChiefsLas Vegas Golden KnightsWatfordSneakersOlympicsTravel

  39. DollarBillHokie

    DollarBillHokie Greatest Asset: being, like, really smart
    Donor
    Virginia Tech HokiesTiger Woods

    Simple way is writing a formula in column b (cells indicated in your formula above)
    B1 ‘= a1 ‘
    B2 ‘= b1 & “, ” & a2’
    Copy cell b2 down the entire column

    If you just need this one off, that’s easy. Just copy and paste the last row as values. If you need the list frequently and it changes, I have a more complicated formula that determines the max length and uses that to determine the longest row.
     
  40. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    Any chance you can use python or put it in a sql table? Would be super easy in both.
     
  41. racer

    racer Fuck Tucker, Tucker sucks.
    Donor
    Iowa HawkeyesKansas City ChiefsLas Vegas Golden KnightsWatfordSneakersOlympicsTravel

  42. IV

    IV I'm often wrong, but occasionally correct
    Donor TMB OG
    Alabama Crimson TideCollege Football PlayoffAvengers

    only a Sith deals in absolutes
     
    broXcore, InZahnWeTrust and Wu like this.
  43. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee Titans

    Is this the only Excel thread we have? Trying to figure out how to compute some power settings on a piece of equipment.
     
  44. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    Yes
     
    Jax Teller likes this.
  45. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee Titans

    Well hell. So i'm trying to figure out the % of max power a piece of equipment is putting out for each of it's 20 power settings. Normally I figure this would be easy as each setting would be an additional 5% of max all the way to 20 = 100%. But setting 1 does not equal 0, it actually equals 15%. So if setting 1 is 15%, setting 20 is 100%. How do i figure out the % for the other 18? Would I do 85 (the total power spread in %) divided by 18 settings?
     
  46. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    Seems like an equipment question vs an excel question
     
    bigred77, Jax Teller and laxjoe like this.
  47. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee Titans

    You're probably right. More of an engineering or statistics question probably. Was just using excel to do the breakdown and was curious if there maybe a formula that would help or something.
    Maybe I should just post a new thread. I'm not sure we have a thread that already exists that would help.
     
  48. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington RedskinsAtlanta United

    :idk:

    if it was 1:1 linear relationship between setting and power then yes, your though would work to spread it over the settings 1-20 between 15-100%.

    I highly doubt anyone is going to know exactly b/c ever piece of equipment power is probably different.
     
    Brocephus and Jax Teller like this.
  49. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee Titans

    Yea and the manufacturer is being really slow at answering any emails. This is just a wave maker in an aquarium so it's not any kind of priority.

    I talked it out with a friend of mine and we got 85 (remaining power after starting at 15) divided by 19 settings = about 4.47% each setting. That puts setting 20 at 99.93% which I'm good with.
     
  50. TDCD

    TDCD Handling the Fisher account
    Donor
    Florida State SeminolesConnecticut HuskiesBoston Red SoxNew England Patriots

    this sounds like a microsoft word problem