eee

@eee

active 2 months, 2 weeks ago
  • eee posted a new activity comment 2 months, 2 weeks ago

    I suspect this is the most likely, that the garage accidentally didn’t put much in. It’s happened to me in the past.

  • eee posted a new activity comment 2 months, 2 weeks ago

    for client maintainability, I’m trying to do it all with formulas. Although I of course can’t guarantee it to be bug free, I do clearly document what I’ve done so that anyone with reasonable Excel skills could follow what I’ve done.

    I’m sure there are more elegant ways of doing all that I’m providing but not sure that would fit all of the…[Read more]

  • eee posted a new activity comment 2 months, 2 weeks ago

    That’s what I think I’m going to have to do, would have been nice to avoid it though. Becomes rather long because it’s got indirect in it.

  • eee posted a new activity comment 2 months, 2 weeks ago

    I’ve got a number of cells with text that I want to concatenate with a delimiter but excluding blank cells. Textjoin does the job with no need for extra logic.

    Eg; an address over several cells converted to a single string with commas.

    Concatenate function is still available.

  • eee posted a new activity comment 2 months, 2 weeks ago

    Don’t know whether you’re being funny or serious.

    If funny, then nice one

    If serious, then get real, you’re just playing with semantics. It’s a kosher version of office with a full version of the bits of Office I need. Why would I pay extra for bits I don’t need, just so that it can have a slightly different name?

    • Take a look at the licence agreement. It will say “The software is not licensed for use in any commercial, non-profit, or revenue generating business activities.”, or similar.

  • eee posted a new activity comment 2 months, 2 weeks ago

    Thing is it wasn’t advertised, their documentation/help etc just says it’s there, nothing about giving it to you and then taking away.

    I’ve never really like MS, but this is a now low (for me at least).

  • eee posted an update 2 months, 2 weeks ago

    Micros**t has really pissed me off.

    I’ve got Home & Student Office 16; i.e. the basic version (Word, Excel, PowerPoint and One-note), but I’m doing some professional work producing an Excel “tool” for someone. It’s reasonably complicated and I found the TEXTJOIN function which really helps with what I’m doing.

    I come down this morning to…[Read more]

    • Get the entire Office suite; full, professional versions, via their home use programme, for £10…

      https://www.microsofthup.com/hupuk/home.aspx?country_id=GB

    • It’s annoying but it’s reasonably unoriginal “feature advertising”. A bit like how (and I know I am talking about something from 10+ years ago here) you get only five opportunities to play a non-Region-2-encoded DVD on a lot of laptop players/apps (which is five more that you would get on a non-multi-region dedicated DVD player hooked up to your telly!)

      • Thing is it wasn’t advertised, their documentation/help etc just says it’s there, nothing about giving it to you and then taking away.

        I’ve never really like MS, but this is a now low (for me at least).

    • > I’ve got Home & Student Office 16, but I’m doing some professional work

      > It stinks, it feels like I’ve stolen something.

      See what some simple editing has done there?

      • Don’t know whether you’re being funny or serious.

        If funny, then nice one

        If serious, then get real, you’re just playing with semantics. It’s a kosher version of office with a full version of the bits of Office I need. Why would I pay extra for bits I don’t need, just so that it can have a slightly different name?

        • Take a look at the licence agreement. It will say “The software is not licensed for use in any commercial, non-profit, or revenue generating business activities.”, or similar.

    • Have you tried just using “&” it’s a bit of a long shot but it might still be there as in (A2)&(B6) is concatenate, but in shorthand.

      • I’ve got a number of cells with text that I want to concatenate with a delimiter but excluding blank cells. Textjoin does the job with no need for extra logic.

        Eg; an address over several cells converted to a single string with commas.

        Concatenate function is still available.

    • Whatever you’re doing, I’m almost completely sure you don’t want to be doing it in excel.

      Export to .csv and it’ll be a ten minute job in Python.

      I’ve seen many programs written in spreadsheets where there are hard to spot bugs and/or nobody has a clue how they work any more.

      • for client maintainability, I’m trying to do it all with formulas. Although I of course can’t guarantee it to be bug free, I do clearly document what I’ve done so that anyone with reasonable Excel skills could follow what I’ve done.

        I’m sure there are more elegant ways of doing all that I’m providing but not sure that would fit all of the…[Read more]

    • How many cells are you looking to join?

      a bit of a faff I know but could you do it with an IF and some “,” and &s

      • That’s what I think I’m going to have to do, would have been nice to avoid it though. Becomes rather long because it’s got indirect in it.

    • “WTF is going on with Microsoft giving me features (either with the original purchase or a subsequent update) and then removing them with a subsequent auto-update”

      I sympathize, but you bought a license to use a product, and part of the deal is that Microsoft gets to update that product from time to time. If you’d actually bought the Office…[Read more]

  • eee posted a new activity comment 2 months, 2 weeks ago

    Doing nothing is not an option, you have to do something. At that something should be what you are passionate about. You can’t be happy in a card board box and expect the world to just give you stuff because you exist, some people will give to you and you might find a few that are extremely generous…but at the end of the day doing nothing…[Read more]

  • eee posted a new activity comment 2 months, 4 weeks ago

    When I was a kid there was a local farmer with a good portion of his face missing-he’s tried to kill himself after the death of his wife, using a shotgun. so it doesnt necessarily blow their head off. Kurt Cobain also used a shotgun-so it can also be successful! can’t answer the rest of your questions though.

  • eee posted a new activity comment 4 months, 1 week ago

    I have a Source in black and it’s brilliant. It looks smart on the surface and is very straight forward. I don’t use it daily but it’s nice for a change and I like being able to offer people another choice of drink as we don’t have much (water or tea really!)

    I mainly wanted to reduce my plastic waste too which it has done hugely!!

  • eee posted a new activity comment 4 months, 1 week ago

    The biggest problem getting an older model is if apps get updated to the point they become incompatible/unsupported with your version of Android or too large for your phones memory. The latter point is especially problematic and a lot of apps can’t be transferred to an sd card. I personally wouldn’t buy any phone without at least 32gb internal…[Read more]

  • eee posted a new activity comment 4 months, 1 week ago

    Rule? This is English, don’t expect logic!

    • If the distribution were more random, I wouldn’t be considering the possibility of a rule! And yet, aside from the eels, in the examples I gave, just some species off the top of my head and I know there are outliers but in terms of what you generally picture when you think of these fish(es), there is a pattern!

  • eee posted a new activity comment 4 months, 1 week ago

    Yes I agree with the others your being very silly. I know someone who can afford the very best of everything but delights in furnishing her home with ‘homemade’ shabby chic – nothing matches but she delights in showing people what she has rescued from skips and charity shops and then tarted up. Go for it put your own stamp on things.

  • eee posted a new activity comment 4 months, 1 week ago

    Ah yes, the benefit system. I have 2 opinions, 1 is that those who know how to work the system and make it work for them, are those that see benefit as an acceptable way of life. Opinion 2 is that they make it so complicated, those of us who hope we never have to use it, but occasionally fall on difficult times (which is what I thought the system…[Read more]

    • It’s awful! I think I’m reasonably intelligent, but just finding the right thing to apply for was confusing. Not helped by office workers who were as clueless as me! Couldn’t verify my ID, so had to book an appointment to go in and show them my driving license. Then I get another appointment to chat about my options! Because combining the two,…[Read more]