You can't use a text formatted cell in an equation for numbers without getting into some serious formulas. But you can format a number to make it look like text.
If you have `50` in a cell, and put a custom format of `### "percent of"` it will display as `50 percent of`, but will functionally be `50`
> Sometimes I think people who know too much in Excel are more dangerous than people who know too little...
too true
> Since there are 2^56 possible keys, the odds of hitting one of these is 1 in 2^52. That's "both you and your computer were--independently--struck by lightening this year" territory.
> If you get one either a) your random number generator is bad, like *Debian* bad, and you're *totally screwed* already: checking for weak DES keys is putting new vinyl on the Titanic's deck's chairs, OR
b) wow, you're unlucky! Sorry about the lightening; you should buy a lottery ticket! ...but don't worry, the attacker was just going to brute force your DES keys anyway!
> This is regarding the new design on the train timetable/info displays.
There are serious readability issues with the new design. I'm finding myself having to walk right up to one of the displays to read, when previously I could do so from one or two carriages down the platform.
Specifically:
* The colour on the departure time of the coming/current train is too light. It needs more contrast with the background. Why not the same dark grey as the rest?
* The text of the departure time of the next train (down the very bottom) is far too small. My eyesight isn't perfect, but I suspect even…
I may have gotten slightly annoyed at the new station display design...
I am not really that bad at playing video games, THEY are just that bad at porting them to the PC :-) Ok avoid ports, and kickstarter games, anything else I should know about?
Especially if it's something unlikely. Almost as if it could only happen in a movie. For instance, you're about to be robbed and a random cop on patrol arrives at that exact time. What are the chances of that?
Is there an expression/idiom that communicates that general idea?
@Boris_yo wow i did not know there was a story behind this, thought it was just some dumbass (looking) picture that was legally releaced to be used for memes.
I'm using ldap and I'd like to use the secondary groups of these ldap users for manage folder permissions
for example
If I write getent group XXX where XXX is a ldapgroup it has output, otherwise, if I write id YYY where YYY is a member of XXX I get only the primary group
How can I set it up for obtain more than the primary group?
@ITProGuy Did you ask this question as a question on SuperUser? That way if you got an answer and someone else was looking for it they could also see it.
This feels a bit more like something that would be a serverfault question
Unrelatedly, I have a windows 7 vm upgrading to windows 10. Checking for updates is at 11% but.... the system is cut off from the network so I have no idea where its checking for em 0_0
@Nzall if he swears by them he might know enough to check everything that gets selected, and could probably manully do it hisself. If he is recomending them to everyone without telling them they need to know a bit , well.
Problems today would be to recommend "tuning", or "cleaning" , or any catch phrases used in selling SEO trash "optomising" junk, and the users will start believing what they say at those sites :-)
Scan Completed 850 Cookies found , is that all :-)
Tracking = Infected? Ahh to say Whatever . . .
Speaking of cookies, I am wondering why the Smoreo has never made it to the shelf.
@DavidPostill my opinion would be anyone should receive credit for the work they did even if they are in prison, unless they are in prison for stealing the credit from others.
So, you have the university professor/cryptologist, the heroine, a hulking misunderstood villan's lacky, and the great mystery of who exactly is a good boy.
@Burgi actually, what typically happens is it gets downvoted to hell, then deleted. Occationally before I even get to see it. THAT I blame my popularitymy lovely cultists the secret cabal for.
I do agree though with his assessment, but it has only effected me one time , back when the ISP (cable) would give a new IP to me whenever, i found myself blocked from sites I had not yet been banned from.
He's annoyed he's qbanned. Feels like he's taking out his frustration on meta. TBH, with a few exceptions, folk who are qbanned take up a lot of mod time to deal with, sometimes with little reward for us.
@Psycogeek "Question bans are relative to the account, NOT the IP address (except for serious infractions)." from meta.stackexchange.com/a/161701/267099
see that loooooooong line of slow traffic from south to north? I just rode that. It took me an HOUR to get to work today where it usually takes about 25 minutes. All because of one fucker who had to be a "spirited" driver and crash into another person.
@allquixotic dont move to california, takes 2 hours minimum to do 25 miles around here in commute traffic (6 hours each day). if a wreck happens they just scrape it and the dead bodies off to the side , and keep it going :-)
They just keep adding more lanes, and it becomes one Bigger parking lot. A Ford Model-T Could get to work as fast as the guy with the 454 8cyl.
Someday i expect people will get smart(er) and realise that 10,000 mopeds would get there faster.
@Bob I think that is too often the scapegoat for traffic. In actuality, what causes traffic is people moving around in lanes. Every time a car going slower moves into a lane that's going faster, they are contributing to the traffic problem, because the car that's now behind them has to slow down while they accelerate into the lane.
A crash causes a lane to basically stop, then people pull around the crash to try to keep going, which slows down the next lane. Then people move from that next lane to the other lane that's still going fast. And so on.
annoyingly, the traffic jam was so long that it wore down my Prius C's battery, which means my engine kept cutting on even at very low speeds to force charge the battery -_-
I turned off my A/C to try to get more battery range and stop the engine from constantly turning on
@allquixotic Then again, I've gotten into situations where I decided to stick in one lane only to find that it (and the jam) are in a branch of the road that I'm not going down.
yeah it was basically from the southernmost point of the Baltimore beltway (the highway loop around Baltimore) to nearly the top of the northwestern corridor
I get off the Baltimore beltway two exits before the exit where the crash was, and the location of the crash was at least 5 km from the point where I exited.
yet I still suffered mightily from it
never even got to see the crash
though, unless there was another Prius C in the traffic, or a Tesla, I probably had the most efficient "jog" (was moving at approximately a fast jogging / average person's running speed, not even sprinting) than anyone else on the road
the Prius C gets the best "city" driving (low speeds, stop and go) MPG of any non-electric vehicle commercially sold in the US today, except for the first generation Honda Insight, which you can only buy used (new Insights are much less fuel efficient, go figure)
it gets better city MPG than even the regular Prius, by a small margin (but the regular Prius does better at highway speeds)
@Bob in the absence of traffic impediments, and assuming I could drive at a speed that is unlikely to get me ticketed but still breaks the legal speed limit, 20 minutes. 37 km.
the entire trip only has two traffic lights, and at one of them it's legal to make a right turn on red (after stopping), so I rarely get impeded at the first light. the second light isn't horrifically long even in the worst case.
unrelatedly, this image was rendered on an e-Ink display:
File size was the first thing I checked and the local file was big enough to maybe be the original (e.g. it hadn't started back at a few MB), but I don't have another copy of the original file to check
Especially if it's something unlikely. Almost as if it could only happen in a movie. For instance, you're about to be robbed and a random cop on patrol arrives at that exact time. What are the chances of that?
Is there an expression/idiom that communicates that general idea?
I have heard that you should keep the registry clean on Windows. Is this actually important or is it just myth?
