Re: Heh

1

That is pretty damn funny.


Posted by: Nope@nope.com | Link to this comment | 09-15-22 5:22 AM
horizontal rule
2

People sometimes use Excel for real data and there's always problems because it does bullshit like that, but not always so noticeable.


Posted by: Moby Hick | Link to this comment | 09-15-22 5:24 AM
horizontal rule
3

You need to make things clear in SAS.

format dinner mmddyy10.;


Posted by: Moby Hick | Link to this comment | 09-15-22 5:39 AM
horizontal rule
4

Little Bobby Tables


Posted by: Nope@nope.com | Link to this comment | 09-15-22 6:08 AM
horizontal rule
5

Little Bobby Tables


Posted by: Nope@nope.com | Link to this comment | 09-15-22 6:08 AM
horizontal rule
6

That's funny.


Posted by: heebie-geebie | Link to this comment | 09-15-22 6:10 AM
horizontal rule
7

"Sometimes it's easier to rewrite genetics than update Excel" - A modern classic, although relabel might be more accurate than rewrite.


Posted by: Minivet | Link to this comment | 09-15-22 6:41 AM
horizontal rule
8

I bet if Neb were around, he'd support this guy. https://twitter.com/mrchevette/status/1562790610079084545?s=46&t=Ws_ZHzRbTV_nT5a9_Gg8JA


Posted by: ogged | Link to this comment | 09-15-22 6:48 AM
horizontal rule
9

I guess I learned something. Thanks.


Posted by: Moby Hick | Link to this comment | 09-15-22 7:08 AM
horizontal rule
10

8 is the dumbest thing I've ever seen. A diagram is supposed to be an ancillary thing that guides one's understanding, not some rigid constraint-bound mess.


Posted by: heebie-geebie | Link to this comment | 09-15-22 7:20 AM
horizontal rule
11

I've failed then.


Posted by: Moby Hick | Link to this comment | 09-15-22 7:35 AM
horizontal rule
12

||
This was an interesting essay, some overlap with DeLong's scope.
http://glineq.blogspot.com/2016/05/economic-reflections-on-fall-of.html

Was there consensus about interest level for a group reading of that one? A target date and pace maybe? It's a big book, potentially could start in October if particiapnts exist and agree?
|>


Posted by: lw | Link to this comment | 09-15-22 7:48 AM
horizontal rule
13

I saw that joke years ago but I had no idea I should share it here. Now I need to post every funny thing I've found on the assumption that it will be new to someone.
There are people who just routinely repost commons jokes on Twitter every six months and enough people think it's new that they get tens of thousands of likes.
I've gotten screwed by the thing in 7. The worst Excel behavior is when it converts a number to a date to a number again and the latter number is the date in the format of "days since Jan 1 1970". Completely impossible to identify that it's corrupted your data!


Posted by: SP | Link to this comment | 09-15-22 8:19 AM
horizontal rule
14

I saw that joke years ago but I had no idea I should share it here. Now I need to post every funny thing I've found on the assumption that it will be new to someone.

No. You leave those jokes for heebie. She somehow needs to come up with something to post here every weekday. If you don't have any suggestions to send her, you can at least not take her material.


Posted by: peep | Link to this comment | 09-15-22 8:37 AM
horizontal rule
15

13. Yes, didn't you know that this year is 52 AB (After Bill)?


Posted by: chris y | Link to this comment | 09-15-22 8:52 AM
horizontal rule
16

I just converted the number 1 to a date in Excel and it was January 1, 1900. I think it's Unix that counts from 1970? Or did Excel change at some point?


Posted by: Minivet | Link to this comment | 09-15-22 8:59 AM
horizontal rule
17

That's another thing SAS does better. It counts from 1/1/1960.


Posted by: Moby Hick | Link to this comment | 09-15-22 8:59 AM
horizontal rule
18

I recorded which it was in Excel a while ago but now I can't figure out what it means.


Posted by: SP | Link to this comment | 09-15-22 9:00 AM
horizontal rule
19

Excel is magic. It solves problems for me all the time. The folks that Bill Gates stole that from are tremendous benefactors of humanity.


Posted by: politicalfootball | Link to this comment | 09-15-22 9:18 AM
horizontal rule
20

Quatro Pro?


Posted by: Moby Hick | Link to this comment | 09-15-22 9:19 AM
horizontal rule
21

@17

Philip Larkin counts from 1963.


Posted by: Nope@nope.com | Link to this comment | 09-15-22 9:22 AM
horizontal rule
22

@17

Philip Larkin counts from 1963.


Posted by: Nope@nope.com | Link to this comment | 09-15-22 9:22 AM
horizontal rule
23

@17

Philip Larkin counts from 1963.


Posted by: Nope@nope.com | Link to this comment | 09-15-22 9:22 AM
horizontal rule
24

Lotus or Visicalc, I'm thinking. But I am no spreadsheet historian.


Posted by: politicalfootball | Link to this comment | 09-15-22 9:23 AM
horizontal rule
25

Peep is doing the lord's work in 14.


Posted by: heebie-geebie | Link to this comment | 09-15-22 9:32 AM
horizontal rule
26

10: This is why God made the white-arm/black-arm Predator handshake meme format.


Posted by: snarkout | Link to this comment | 09-15-22 9:58 AM
horizontal rule
27

22: I don't want Excel always breaking the bank, though.


Posted by: snarkout | Link to this comment | 09-15-22 9:59 AM
horizontal rule
28

There's more.

https://twitter.com/undersequoias/status/1286374917110292480


Posted by: apostropher | Link to this comment | 09-15-22 10:36 AM
horizontal rule
29

There are people who just routinely repost commons jokes on Twitter every six months and enough people think it's new that they get tens of thousands of likes.

https://xkcd.com/1053/


Posted by: ajay | Link to this comment | 09-16-22 1:18 AM
horizontal rule
30

I swear to Christ that I have probably spent more time on trying to extract dates from spreadsheets than almost any other thing. Librarians and archivists are literally fucking insane when it comes to dates.

"fl. c. approx. third quarter of 15th c."*

When what they want it to plot some collection on a timeline or enable users to search or filter them by date. I have not-jokingly suggested that when I quote for projects I should just add a 20% surcharge any time someone mentions that their data is in a spreadsheet.

* I have one client who sometimes records the season, too, i.e. that it was summer, when they don't know what decade it was. And they want that sort of thing represented. So, it's somewhere between June and September, any year between 1928 and 1946.


Posted by: nattarGcM ttaM | Link to this comment | 09-16-22 1:19 AM
horizontal rule
31

You just need more fields.


Posted by: Moby Hick | Link to this comment | 09-16-22 4:03 AM
horizontal rule
32

Or for the seasonal client reclassify them as pastures.


Posted by: Doug | Link to this comment | 09-16-22 6:11 AM
horizontal rule
33

Wanted: data class with room for precision level.


Posted by: Minivet | Link to this comment | 09-16-22 7:31 AM
horizontal rule
34

12: Bret Deveraux just published a blog article last month on "Why No Roman Industrial Revolution?" that answers the question that globalinequality article was asking. Bret is a historian whose professional work is on the military history of Rome, and whose blog goes into intersection of military history and popular culture, diving into topics like why the Dothraki don't accurately reflect key aspects of the nomadic cultures that GRRM said inspired them.

Short answer: the Industrial Revolution in Britain, and the development of steam engine technology in particular, depended on certain factors that were largely geographically unique to Britain at the time to make that development economically feasible (and after that, diffusion of technology prevented any alternate examples of Industrial Revolutions occurring from scratch elsewhere):


Fundamentally this is a story about coal, steam engines, textile manufacture and above all the harnessing of a new source of energy in the economy. That's not the whole story, by any means, but it is one of the most important through-lines and will serve to demonstrate the point.


The specificity matters here because each innovation in the chain required not merely the discovery of the principle, but also the design and an economically viable use-case to all line up in order to have impact. The steam engine is an excellent example of this problem.

...

But the technology could not jump straight to railroads and steam ships because the first steam engines were nowhere near that powerful or efficient: creating steam engines that could drive trains and ships (and thus could move themselves) requires decades of development where existing technology and economic needs created very valuable niches for the technology at each stage. It is particularly remarkable here how much of these conditions are unique to Britain: it has to be coal, coal has to have massive economic demand (to create the demand for pumping water out of coal mines) and then there needs to be massive demand for spinning (so you need a huge textile export industry fueled both by domestic wool production and the cotton spoils of empire) and a device to manage the conversion of rotational energy into spun thread. I've left this bit out for space, but you also need a major incentive for the design of pressure-cylinders (which, in the event, was the demand for better siege cannon) because of how that dovetails with developing better cylinders for steam engines.


Posted by: Dave W. | Link to this comment | 09-16-22 3:29 PM
horizontal rule
35

29- I've already read that one.


Posted by: SP | Link to this comment | 09-16-22 4:24 PM
horizontal rule
36

34: In these parts, he's known as the "Fuck Sparta" guy.


Posted by: Moby Hick | Link to this comment | 09-16-22 4:40 PM
horizontal rule
37

In my case, it's because I have trouble with French names.


Posted by: Moby Hick | Link to this comment | 09-16-22 4:44 PM
horizontal rule
38

34: Deveraux is excellent both on his blog and on Twitter. That post is great, and not just because it's consistent with what I was arguing on a previous thread (though it is).


Posted by: teofilo | Link to this comment | 09-16-22 4:46 PM
horizontal rule
39

12: I'll play.


Posted by: Mossy Character | Link to this comment | 09-16-22 10:31 PM
horizontal rule
40

Mossy!


Posted by: teofilo | Link to this comment | 09-16-22 10:56 PM
horizontal rule
41

Mossy!


Posted by: Barry Freed | Link to this comment | 09-17-22 7:02 AM
horizontal rule
42

MOSSY!

re: Berkeley economist book club - I'm in too.


Posted by: peep | Link to this comment | 09-17-22 10:28 AM
horizontal rule
43

I will actually buy the book next week and put up a book pub post. If you're interested? Buy now and start reading.


Posted by: LizardBreath | Link to this comment | 09-17-22 3:53 PM
horizontal rule
44

Probably just buying the book is enough for me.


Posted by: Moby Hick | Link to this comment | 09-17-22 3:59 PM
horizontal rule
45

teo! Barry! PEEP!


Posted by: Mossy Character | Link to this comment | 09-17-22 8:26 PM
horizontal rule
46

39: Hope you have been able to stay safe.


Posted by: Moby Hick | Link to this comment | 09-18-22 3:55 PM
horizontal rule