Other What currently makes your life awesome?

Discussion in 'General' started by Brooxy, 28 Oct 2009.

Page 1193 of 1404
  1. The_Crapman

    The_Crapman World's worst stuntman. Lover of bit-tech

    Joined:
    5 Dec 2011
    Posts:
    8,317
    Likes Received:
    4,651
    Going in all guns blazing, going to brush up on my excel shizz before going in and maybe try and learn some vba. Kick ass and chew coffee beans so when that discussion comes I'm in a good position to be asking for the upper boundaries of the advertised salary range.
     
    The_Crapman, 18 Jan 2022
    #23841
    IanW, Byron C and Pete J like this.
  2. Byron C

    Byron C I was told there would be cheesecake…?

    Joined:
    12 Apr 2002
    Posts:
    11,254
    Likes Received:
    5,957
    We're introducing a new financial benefit in April: interest-free loans. Having given this some thought, and having scoured the interwebs a little (OK a lot), I've realised that this puts buying a property within reach. We were going to start making preparations to move anyway (boxing up stuff we don't use all the time, throwing out old stuff we don't want/need any more, etc), but up until around mid-day I assumed I'd be renting again. This changes things somewhat...

    Best of luck with the new job! VBa is pretty easy to get to grips with! An easy way to get started is to record some macros and then take a look at the VBa code it produces.
     
    Byron C, 18 Jan 2022
    #23842
  3. The_Crapman

    The_Crapman World's worst stuntman. Lover of bit-tech

    Joined:
    5 Dec 2011
    Posts:
    8,317
    Likes Received:
    4,651
    I've used it a few times like that, recorded a few key strokes and/or functions, then copy-pasted it changing a keystroke or 2 to repeat it. Had to do it for the credit card payment file as it got imported into access, which would throw a fit if there were any non numerical characters in the payment reference field. So previously, people had been manually doing a find and replace for each non numerical character, or filtering for them. One. By. One. It would take forever, or at least what seemed like it. Especially when you'd have somehow missed one, the upload would fail, and then have to go through them all again. Few minutes of jiggery pokery and a macro made it a 5 second job.
     
    The_Crapman, 18 Jan 2022
    #23843
  4. adidan

    adidan Guesswork is still work

    Joined:
    25 Mar 2009
    Posts:
    20,621
    Likes Received:
    6,470
    Awesome news mate, really pleased for you :thumb:

    Recruiters can help but only so much, you got you the job.

    [​IMG]
     
    Last edited: 18 Jan 2022
    adidan, 18 Jan 2022
    #23844
    The_Crapman likes this.
  5. oscy

    oscy Modder

    Joined:
    22 Sep 2011
    Posts:
    1,368
    Likes Received:
    244
    Now that the store I was in has closed, my former colleague is trying to get me into their chill store, so hopefully that happens nice and easy.

    Then my next step is to get the twerky one in.
     
    oscy, 19 Jan 2022
    #23845
  6. Dr. Coin

    Dr. Coin Multimodder

    Joined:
    13 Sep 2013
    Posts:
    1,102
    Likes Received:
    296
    XLOOKUP function is your new friend, I totally abuse excel (that is I should be using a proper database, especial when I start nesting xlookups in xlookups) with this function. Replaced vlookup, hlookup, index and match.
     
    Dr. Coin, 19 Jan 2022
    #23846
    Byron C, The_Crapman and goldstar0011 like this.
  7. goldstar0011

    goldstar0011 Multimodder

    Joined:
    2 Sep 2007
    Posts:
    3,756
    Likes Received:
    567
    If I talk about xlookup once more in my office someone is gonna hit me, after I make them a spreadsheet they need with xlookup
     
    goldstar0011, 19 Jan 2022
    #23847
    MLyons and The_Crapman like this.
  8. The_Crapman

    The_Crapman World's worst stuntman. Lover of bit-tech

    Joined:
    5 Dec 2011
    Posts:
    8,317
    Likes Received:
    4,651
    That's only on 365 though isn't it?
     
    The_Crapman, 19 Jan 2022
    #23848
  9. Spraduke

    Spraduke Lurker

    Joined:
    23 Sep 2009
    Posts:
    1,200
    Likes Received:
    489
    Spraduke, 19 Jan 2022
    #23849
  10. The_Crapman

    The_Crapman World's worst stuntman. Lover of bit-tech

    Joined:
    5 Dec 2011
    Posts:
    8,317
    Likes Received:
    4,651
    Sweet. Look forward to that upgrade in 2031 :hehe:
     
    The_Crapman, 19 Jan 2022
    #23850
    MLyons likes this.
  11. David

    David μoʍ ɼouმ qᴉq λon ƨbԍuq ϝʁλᴉuმ ϝo ʁԍɑq ϝμᴉƨ

    Joined:
    7 Apr 2009
    Posts:
    18,375
    Likes Received:
    7,039
    Interview on Saturday morning.
     
    David, 19 Jan 2022
    #23851
    perplekks45, Pete J, Byron C and 6 others like this.
  12. The_Crapman

    The_Crapman World's worst stuntman. Lover of bit-tech

    Joined:
    5 Dec 2011
    Posts:
    8,317
    Likes Received:
    4,651
    Newjobitis is contagious :eeek:
     
    The_Crapman, 19 Jan 2022
    #23852
  13. IanW

    IanW Grumpy Old Git

    Joined:
    2 Aug 2003
    Posts:
    9,858
    Likes Received:
    3,493
    I think I'm immune. :sigh:
     
    IanW, 19 Jan 2022
    #23853
  14. MLyons

    MLyons 70% Dev, 30% Doge. DevDoge. Software Dev @ Corsair Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    3 Mar 2017
    Posts:
    4,268
    Likes Received:
    2,896
    pls no
     
    MLyons, 19 Jan 2022
    #23854
  15. ElThomsono

    ElThomsono Multimodder

    Joined:
    18 Mar 2005
    Posts:
    4,483
    Likes Received:
    2,108
    Hopefully Boris gets one soon.
     
    ElThomsono, 19 Jan 2022
    #23855
    Isitari, The_Crapman and MLyons like this.
  16. David

    David μoʍ ɼouმ qᴉq λon ƨbԍuq ϝʁλᴉuმ ϝo ʁԍɑq ϝμᴉƨ

    Joined:
    7 Apr 2009
    Posts:
    18,375
    Likes Received:
    7,039
    Yeah, as a love doll in a gorilla enclosure, hopefully.
     
    David, 19 Jan 2022
    #23856
    Isitari, perplekks45, Pete J and 5 others like this.
  17. Byron C

    Byron C I was told there would be cheesecake…?

    Joined:
    12 Apr 2002
    Posts:
    11,254
    Likes Received:
    5,957
    Honestly even that is better than he deserves.
     
    Byron C, 19 Jan 2022
    #23857
  18. Mr_Mistoffelees

    Mr_Mistoffelees The Bit-Tech Cat. New Improved Version.

    Joined:
    26 Aug 2014
    Posts:
    5,933
    Likes Received:
    3,118
    No!

    Exile him now!
     
    Mr_Mistoffelees, 19 Jan 2022
    #23858
  19. ElThomsono

    ElThomsono Multimodder

    Joined:
    18 Mar 2005
    Posts:
    4,483
    Likes Received:
    2,108
    This made me laugh more than it had any right to :hehe:
     
    ElThomsono, 19 Jan 2022
    #23859
    Mr_Mistoffelees likes this.
  20. IanW

    IanW Grumpy Old Git

    Joined:
    2 Aug 2003
    Posts:
    9,858
    Likes Received:
    3,493
    Overheard:- "At least someone in Downing Street knows how to pack a suitcase!"
     
    IanW, 19 Jan 2022
    #23860
Page 1193 of 1404
Tags:

Share This Page