images thread v1.9: incredibly cool rocks with mysterious origins

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > images thread v1.9: incredibly cool rocks with mysterious origins

«‹›860 »

Large Testicles: Jun 1, 2020; ✊🏴🥷
Proud ANTIFA Terrorist

Improbable Lobster posted:

gently caress yeah, motocompos rule, i know i'm way too tall to fit on one tho

# ? Sep 17, 2023 17:02

Adbot: ADBOT LOVES YOU

# ? Oct 3, 2023 18:45

Large Testicles: Jun 1, 2020; ✊🏴🥷
Proud ANTIFA Terrorist

speaking of motocompos, someone just posted this in AI
https://www.businessinsider.com/hondas-new-electric-scooter-motocompacto-motocompo-2023-9

# ? Sep 17, 2023 17:05

Chris Knight: Jun 5, 2002; And I'm only saying this because I care.

There are a lot of decaffeinated brands on the market today that are just as tasty as the real thing.; Fun Shoe

Armitag3 posted:

0010 - october
0011 - november
0012 - december
0013 - megacember
0014 - ultrabuary
0015 - m-m-m-m-onsterpril pril _{pril _pril _pril}
...
9999 - the hottest july

# ? Sep 17, 2023 17:37

Armitag3: Mar 15, 2020; Forget it Jake, it's cybertown.

Chris Knight posted:

backbone of the whole financial system everyone

# ? Sep 17, 2023 17:45

Large Testicles: Jun 1, 2020; ✊🏴🥷
Proud ANTIFA Terrorist

Chris Knight posted:

i'm going to start calling them that in conversations with my also dorky sister

# ? Sep 17, 2023 17:57

Powerful Two-Hander: Mar 10, 2004; Mods please change my name to "Tooter Skeleton" TIA.

I spent like 30 minutes last week trying to get excel to recognise that the dates in a column were mm/DD/yyyy (not: this is an inferior date format but it's what the data was in) so I could just pull the month and year for a chart and none of the actual functions worked.

set the column as a date type? Nope. Set a custom type? Nope. It wouldn't even treat it as a date at all without going to each cell and pressing enter.

the solution I found on the 10th "for the love of god why won't excel respect my choice of date format?" Was "select the column and do 'import data', then uncheck any delimiters and specify the date format manually and it will import the column into its and reset all the formatting to the one you want"

I mean what the gently caress

# ? Sep 17, 2023 18:00

poemdexter: Feb 18, 2005; Hooray Indie Games!; College Slice

Powerful Two-Hander posted:

I spent like 30 minutes last week trying to get excel to recognise that the dates in a column were mm/DD/yyyy (not: this is an inferior date format but it's what the data was in) so I could just pull the month and year for a chart and none of the actual functions worked.

set the column as a date type? Nope. Set a custom type? Nope. It wouldn't even treat it as a date at all without going to each cell and pressing enter.

the solution I found on the 10th "for the love of god why won't excel respect my choice of date format?" Was "select the column and do 'import data', then uncheck any delimiters and specify the date format manually and it will import the column into its and reset all the formatting to the one you want"

I mean what the gently caress

skill issue

# ? Sep 17, 2023 18:03

laserghost: Feb 12, 2014; ^{trust me, I'm a cat.}

Powerful Two-Hander posted:

I spent like 30 minutes last week trying to get excel to recognise that the dates in a column were mm/DD/yyyy (not: this is an inferior date format but it's what the data was in) so I could just pull the month and year for a chart and none of the actual functions worked.

set the column as a date type? Nope. Set a custom type? Nope. It wouldn't even treat it as a date at all without going to each cell and pressing enter.

the solution I found on the 10th "for the love of god why won't excel respect my choice of date format?" Was "select the column and do 'import data', then uncheck any delimiters and specify the date format manually and it will import the column into its and reset all the formatting to the one you want"

I mean what the gently caress

Lol but also I need to write this down for later use

# ? Sep 17, 2023 18:13

Wild EEPROM: Jul 29, 2011; oh, my, god. Becky, look at her bitrate.

my favorite is when it decides a number is a date

my other favorite is when it deletes leading zeros

my other other favorite is when it decides this long number should become scientific notation

# ? Sep 17, 2023 18:33

Sagebrush: Feb 26, 2012

Yeah all of our student numbers are nine digits starting with 9 so every time I import a roster or something I get a whole column of 9.16E8, 9.55E8, 9.73E8. Awesome

# ? Sep 17, 2023 18:36

Roosevelt: Jul 18, 2009; I'm looking for the man who shot my paw.

excel n00bs itt

# ? Sep 17, 2023 18:40

the gayest hobbit: Jun 2, 2023; the pained frenzy of his bulbous salutation extenuating his excitement as it smacked its way into every muscle of Eliza’s body except for the otherwise central zone.

I'm stuck using CSV for a lot of things but I refuse to use excel because it sucks butt

# ? Sep 17, 2023 18:45

Antigravitas: Dec 8, 2019; Die Rettung fuer die Landwirte:

It's easy, just pipe the csv through awk and sed to reverse the format into something sensible. :v:

# ? Sep 17, 2023 18:45

the gayest hobbit: Jun 2, 2023; the pained frenzy of his bulbous salutation extenuating his excitement as it smacked its way into every muscle of Eliza’s body except for the otherwise central zone.

Antigravitas posted:

It's easy, just pipe the csv through awk and sed to reverse the format into something sensible.

that has to be the output format for waaaaaay too much of my work :cry:

# ? Sep 17, 2023 18:48

akadajet: Sep 14, 2003

ADINSX posted:

Jokes on her Betty is making out with two cyberarchies

if it's vrchat it's probably kermit the frog or a fursuit with a strap on

# ? Sep 17, 2023 18:52

ADINSX: Sep 9, 2003; Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

akadajet posted:

if it's vrchat it's probably kermit the frog or a fursuit with a strap on

Betty finally realizes she can do a lot better than Archie

# ? Sep 17, 2023 18:56

KoRMaK: Jul 31, 2012

laserghost posted:

Lol but also I need to write this down for later use

# ? Sep 17, 2023 19:20

Beeftweeter: Jun 28, 2005; a medium-format picture of beeftweeter staring silently at the camera, a quizzical expression on his face

Antigravitas posted:

It's easy, just pipe the csv through awk and sed to reverse the format into something sensible.

that's right.

# ? Sep 17, 2023 19:22

Roosevelt: Jul 18, 2009; I'm looking for the man who shot my paw.

# ? Sep 17, 2023 19:23

Beeftweeter: Jun 28, 2005; a medium-format picture of beeftweeter staring silently at the camera, a quizzical expression on his face

cool bird pic

i was thinking about going to the japanese gardens here to do some photos but meh its too hot still

# ? Sep 17, 2023 19:26

Ornamental Dingbat: Feb 26, 2007

My boss once asked me to replicate a bunch of locked spreadsheets so he would have editable copies so I just cracked them with like 10 lines of VBA. He still thinks I'm some kind of hacker because I know how to cut and paste from stackoverflow.

# ? Sep 17, 2023 19:29

the gayest hobbit: Jun 2, 2023; the pained frenzy of his bulbous salutation extenuating his excitement as it smacked its way into every muscle of Eliza’s body except for the otherwise central zone.

malört helg

# ? Sep 17, 2023 19:45

Agile Vector: May 21, 2007; scrum bored

the gayest hobbit posted:

mal�rt helg

# ? Sep 17, 2023 19:46

rotor: Jun 11, 2001; classic case of pineapple derangement syndrome

Roosevelt posted:

excel n00bs itt

theyre definitely not � hehehe � theyre definitely not excelling at it!!!!

# ? Sep 17, 2023 19:48

rotor: Jun 11, 2001; classic case of pineapple derangement syndrome

# ? Sep 17, 2023 19:48

Roosevelt: Jul 18, 2009; I'm looking for the man who shot my paw.

lol

# ? Sep 17, 2023 19:50

Midjack: Dec 24, 2007

Roosevelt posted:

# ? Sep 17, 2023 19:52

NoneMoreNegative: Jul 20, 2000; GOTH FASCISTIC
PAIN MASTER

shit wizard dad

the gayest hobbit posted:

malört helg

Shirt option:

# ? Sep 17, 2023 20:06

NoneMoreNegative: Jul 20, 2000; GOTH FASCISTIC
PAIN MASTER

shit wizard dad

Also:

# ? Sep 17, 2023 20:06

Sapozhnik: Jan 2, 2005; Nap Ghost

Chris Knight posted:

but that's not how you spell febRuary, of course the computer isn't going to know wtf pattern you want if you can't even spell the month correctly

# ? Sep 17, 2023 20:08

Haptical Sales Slut: Mar 15, 2010; Age 18 to 49

laserghost posted:

Lol but also I need to write this down for later use

# ? Sep 17, 2023 20:09

mystes: May 31, 2006

the gayest hobbit posted:

malört helg

snart slaycation

# ? Sep 17, 2023 20:24

Shnakepup: Oct 16, 2004; Paraphrasing moments of genius

Powerful Two-Hander posted:

set the column as a date type? Nope. Set a custom type? Nope. It wouldn't even treat it as a date at all without going to each cell and pressing enter.

If the dates are separated by slashes, then select the whole column and do find-and-replace. Replace the slash with the same slash. Even though nothing is technically changing, Excel will still go through and "touch" every cell. This is the equivalent of going to every cell and pressing enter, and Excel should recognize them as dates afterwards.

# ? Sep 17, 2023 20:46

BaldDwarfOnPCP: Jun 26, 2019; by Pragmatica

Radio Paranoia posted:

# ? Sep 17, 2023 20:59

laserghost: Feb 12, 2014; ^{trust me, I'm a cat.}

Some years ago my boss was major pissed at me that I didn't want/know how to remake bunch of paid, editable tax forms for businesses. He accused me of sabotaging him lol

Finally I just edited out the watermarks from screenshots of said forms and printed him the paper copies, and he deemed it good enough to finally gently caress off

# ? Sep 17, 2023 21:23

Jabberlock: Nov 29, 2014

Armitag3 posted:

0010 - october
0011 - november
0012 - december
0013 - smarch

# ? Sep 17, 2023 21:37

MrMoo: Sep 14, 2000

https://twitter.com/Joyfullift/status/1701880379358220554

# ? Sep 17, 2023 23:16

Chris Knight: Jun 5, 2002; And I'm only saying this because I care.

There are a lot of decaffeinated brands on the market today that are just as tasty as the real thing.; Fun Shoe

Sapozhnik posted:

but that's not how you spell febRuary, of course the computer isn't going to know wtf pattern you want if you can't even spell the month correctly

the computer did that

# ? Sep 17, 2023 23:51

Chris Knight: Jun 5, 2002; And I'm only saying this because I care.

There are a lot of decaffeinated brands on the market today that are just as tasty as the real thing.; Fun Shoe

# ? Sep 17, 2023 23:52

Adbot: ADBOT LOVES YOU

# ? Oct 3, 2023 18:45

Beeftweeter: Jun 28, 2005; a medium-format picture of beeftweeter staring silently at the camera, a quizzical expression on his face

what is this, a store for religious ants?

# ? Sep 17, 2023 23:54

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > images thread v1.9: incredibly cool rocks with mysterious origins

«‹›860 »