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
     
    NineteenNine, tjsblue, sem and 5 others like this.
  7. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington Football TeamAtlanta 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
     
  11. Emma

    Emma
    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 My son got the Denver Nuggets jeans
    Donor
    Ohio State BuckeyesDenver NuggetsCleveland CavaliersCleveland Indians

  13. Taques

    Taques sometimes maybe good sometimes maybe shit
    Staff Donor TMB OG
    The Real Movement

    what’s the square root of this apartment
     
    Tobias, devine, gus_chiggins and 17 others like this.
  14. Nelson

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

    holy Christ
     
  15. a.tramp

    a.tramp Insubordinate and churlish
    Donor
    Kansas State WildcatsTexas Rangers

  16. Taques

    Taques sometimes maybe good sometimes maybe shit
    Staff Donor TMB OG
    The Real Movement

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

    ned's head Well-Known Member
    Donor

    Friedskillet got this shit

    [​IMG]
     
  18. Cheshire Bridge

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

    [​IMG]
     
  19. nofatchildren - cissp

    nofatchildren - cissp Free Da Guys
    Donor TMB OG
    Tiger 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. Louis Holth

    Louis Holth but we also just might be those motherfuckers
    Donor
    South Carolina GamecocksAtlanta BravesCarolina PanthersTottenham Hotspur

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

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

  22. 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
     
  23. Beachy Toast

    Beachy Toast He wants you too, Malachi.
    Donor
    Chicago White SoxChicago BearsChicago BlackhawksKansas State WildcatsMontreal Impact

    Joe_Pesci likes this.
  24. Redav

    Redav One big ocean
    Donor

    Have you tried shutting down your computer and restarting it?
     
  25. 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.
  26. 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.
     
  27. The Banks

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

  28. Drew Swinney Esq

    Drew Swinney Esq Successful Attorney in Atlanta
    Donor
    Clemson TigersAtlanta BravesCarolina PanthersGrateful DeadUnited States Men's National Soccer Team

    Microsoft Word users. How do you change the font?
     
    Tobias, Lip, BUstang and 4 others like this.
  29. miles

    miles All I know is my gut says, maybe
    Donor

  30. killrbee7

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

    Clemson education really pays off.
     
  31. Louis Holth

    Louis Holth but we also just might be those motherfuckers
    Donor
    South Carolina GamecocksAtlanta BravesCarolina PanthersTottenham Hotspur

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

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

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

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington Football TeamAtlanta 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
     
  34. Louis Holth

    Louis Holth but we also just might be those motherfuckers
    Donor
    South Carolina GamecocksAtlanta BravesCarolina PanthersTottenham Hotspur

    Getting ready for the season
     
  35. Arrec Bardwin

    Arrec Bardwin La Araña Discoteca
    Donor
    Auburn TigersAtlanta BravesAtlanta FalconsChelseaAtlanta United

    Hey kid, I’m a computa.

    Stop all the downloadin.
     
    Corch likes this.
  36. ned's head

    ned's head Well-Known Member
    Donor

    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.
  37. racer

    racer Yuma, where I work in software.
    Donor
    Iowa HawkeyesKansas City ChiefsLas Vegas Golden KnightsWatfordOlympicsFormula 1

    Didn’t read thread. Trying to figure out how to turn a list where each ID number has a few lines with a different email address, and I want to concatenate them into one cell and line for each.
    Like:

    10001|[email protected]
    10001|[email protected]
    10001|[email protected]

    To:

    10001|email@mail, person@company, guy@place

    Not having great success via google so far.
     
  38. DollarBillHokie

    DollarBillHokie Usher is the worst
    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.
     
    jorge likes this.
  39. Where Eagles Dare

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

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

    racer Yuma, where I work in software.
    Donor
    Iowa HawkeyesKansas City ChiefsLas Vegas Golden KnightsWatfordOlympicsFormula 1

  41. IV

    IV Freedom is the right of all sentient beings
    Donor TMB OG
    Alabama Crimson TideUAB BlazersDemocratAvengersBirmingham LegionUnited States Men's National Soccer Team

    only a Sith deals in absolutes
     
  42. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee TitansNashville PredatorsNashville SC

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

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

    Yes
     
    Jax Teller likes this.
  44. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee TitansNashville PredatorsNashville SC

    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?
     
  45. Where Eagles Dare

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

    Seems like an equipment question vs an excel question
     
  46. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee TitansNashville PredatorsNashville SC

    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.
     
  47. Where Eagles Dare

    Where Eagles Dare The Specialist Show On Earth
    Donor
    Auburn TigersAtlanta BravesWashington Football TeamAtlanta 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.
  48. Jax Teller

    Jax Teller Well-Known Member
    Donor
    Alabama Crimson TideAtlanta BravesTennessee TitansNashville PredatorsNashville SC

    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.
     
  49. TDCD

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

    this sounds like a microsoft word problem