Meta tags:
Headings (most frequently used words):
the, now, we, re, getting, to, meat, 2011, new, arthurian, economics, saturday, october, debt, accumulation, google, translate, blog, archive, links, labels, july, 2014, sunday, 30, 29, unsna, us, gross, output, 1987, and, if, you, don, know, about, csv, easier, second, time, exercise,
Text of the page (most frequently used words):
the (474), and (164), you (97), that (93), for (62), with (50), data (46), numbers (40), cell (39), all (37), one (36), this (35), but (34), ctrl (33), not (31), have (31), column (30), from (29), are (29), press (28), debt (28), want (27), what (27), cells (27), then (26), now (26), can (25), down (25), row (22), file (22), just (22), there (22), #output (22), formula (21), three (20), 1913 (19), year (19), click (19), gross (19), cpi (18), into (18), like (18), right (18), line (17), open (17), more (17), left (17), next (16), columns (16), january (16), after (16), back (15), values (15), about (15), excel (15), will (15), see (15), bls (15), thing (15), them (15), work (14), which (14), type (14), was (14), before (14), value (14), make (13), when (13), don (13), get (13), selected (13), mouse (13), way (12), two (12), here (12), because (12), using (12), 1914 (12), than (12), first (12), graph (12), def (12), got (11), page (11), they (11), spreadsheet (11), copy (11), where (11), out (11), time (11), december (11), october (11), calc (10), done (10), text (10), use (10), again (10), know (10), years (10), over (10), shift (10), may (10), enter (10), look (10), spending (10), undata (10), july (10), link (9), put (9), save (9), rows (9), typed (9), might (9), jan (9), character (9), read (9), february (9), march (9), april (9), june (9), august (9), september (9), november (9), arthurian (8), each (8), useful (8), those (8), how (8), clicked (8), something (8), start (8), office (8), your (8), easier (8), blank (8), same (8), sign (8), through (8), economic (8), blue (8), filter (8), gdp (8), new (8), posts (7), spreadsheeting (7), source (7), months (7), post (7), lot (7), wanted (7), some (7), could (7), top (7), image (7), end (7), point (7), also (7), 2011 (7), intermediate (7), consumption (7), red (7), green (7), policy (7), inflation (7), fred (6), format (6), has (6), should (6), change (6), select (6), month (6), economics (6), other (6), sheet (6), easy (6), need (6), four (6), below (6), every (6), a16 (6), yearvalue (6), added (6), used (6), characters (6), gives (6), key (6), hold (6), button (6), parenthesis (6), important (6), dollar (6), 1915 (6), destination (6), half (6), unsna (6), csv (6), credit (6), money (6), cost (6), labels (5), openoffice (5), does (5), menu (5), had (5), another (5), screen (5), didn (5), good (5), better (5), would (5), ampersand (5), sure (5), number (5), few (5), date (5), release (5), maybe (5), keys (5), equal (5), f21 (5), immediately (5), copied (5), five (5), much (5), import (5), tried (5), process (5), domestic (5), their (5), box (5), getting (5), meat (5), little (5), pick (5), problem (5), only (5), growth (5), louis (4), federal (4), comments (4), going (4), monthly (4), did (4), desktop (4), find (4), case (4), window (4), really (4), enough (4), space (4), entered (4), part (4), always (4), keep (4), cursor (4), actually (4), long (4), worked (4), computer (4), once (4), less (4), above (4), whole (4), arrow (4), say (4), b15 (4), transpose (4), original (4), curly (4), braces (4), transposing (4), q21 (4), f22 (4), still (4), different (4), makes (4), paste (4), goes (4), delete (4), most (4), google (4), labor (4), trends (4), 1939 (4), last (4), second (4), accounts (4), economy (4), options (4), wikipedia (4), filters (4), zoho (4), 2010 (4), 1987 (4), share (4), produce (4), gold (4), fed (3), graphs (3), appear (3), org (3), posted (3), why (3), its (3), went (3), saved (3), firefox (3), wants (3), files (3), cpiai (3), opened (3), third (3), lose (3), doesn (3), sounds (3), while (3), whatever (3), changes (3), turned (3), come (3), course (3), automatically (3), rest (3), except (3), typing (3), between (3), help (3), doing (3), calculation (3), followed (3), without (3), tell (3), yet (3), hand (3), past (3), away (3), story (3), pointing (3), says (3), dozen (3), transposed (3), special (3), single (3), bar (3), q22 (3), okay (3), move (3), said (3), sense (3), anyway (3), selection (3), noticed (3), writing (3), stand (3), version (3), plus (3), off (3), billy (3), nice (3), price (3), rather (3), dates (3), temporary (3), permanent (3), these (3), national (3), rev (3), table (3), countries (3), list (3), show (3), download (3), set (3), looks (3), 1986 (3), 1970 (3), think (3), average (3), almost (3), tax (3), historical (3), showing (3), timeline (3), productivity (3), household (3), financial (3), crisis (3), blog (3), reserve (2), bank (2), 2016 (2), older (2), trouble (2), order (2), minimum (2), repetitive (2), free (2), own (2), fine (2), everything (2), txt (2), filename (2), try (2), final (2), product (2), remember (2), default (2), close (2), worksheet (2), made (2), yeah (2), inserted (2), making (2), side (2), handy (2), fun (2), repetition (2), dragged (2), letter (2), thought (2), letters (2), name (2), couldn (2), semicolons (2), figured (2), tells (2), take (2), hit (2), spacebar (2), pretty (2), stick (2), names (2), matter (2), fact (2), 5th (2), digit (2), add (2), rule (2), maximum (2), though (2), suppose (2), works (2), worry (2), else (2), isn (2), gave (2), drag (2), until (2), spreadsheets (2), tools (2), pressed (2), holding (2), closing (2), note (2), applies (2), notice (2), happen (2), signs (2), means (2), changing (2), cut (2), ods (2), write (2), well (2), example (2), item (2), quick (2), mess (2), loop (2), checked (2), pages (2), docs (2), versions (2), feb (2), mid (2), let (2), saturday (2), threw (2), sample (2), found (2), provides (2), funny (2), index (2), calculations (2), filled (2), explicitly (2), formatted (2), steps (2), yesterday (2), sequence (2), since (2), unusual (2), united (2), nations (2), system (2), nipa (2), looking (2), links (2), paragraph (2), give (2), trying (2), search (2), stuff (2), later (2), hits (2), million (2), records (2), isic (2), must (2), info (2), instead (2), hover (2), slow (2), lets (2), total (2), big (2), picture (2), saw (2), being (2), approximately (2), scrolled (2), far (2), apply (2), changed (2), shows (2), comma (2), zip (2), tab (2), formatting (2), careful (2), quote (2), items (2), bad (2), 2009 (2), never (2), people (2), 170 (2), 000 (2), count (2), convert (2), sheet2 (2), pasted (2), mark (2), ready (2), series (2), context (2), variable (2), gds (2), measure (2), producing (2), call (2), sources (2), brown (2), 2014 (2), label (2), 2018 (2), taxes (2), sumner (2), recession (2), non (2), loops (2), laffer (2), curve (2), krugman (2), jerry (2), banking (2), expectations (2), investment (2), civilization (2), push (2), wealth (2), 2013 (2), 1966 (2), interesting (2), dave (2), ross (2), translate (2), html (2), blogger (2), economist (2), john (2), charts (2), rates (2), funds (2), pdf (2), apparently (2), interest (2), venn (2), rights, reserved, courtesy, http, research, stlouisfed, fred2, lead, horse, water, him, drink, stay, thirsty, friends, subscribe, atom, home, jazz, recently, great, strong, besides, graphing, experience, came, amount, risk, error, quirks, everybody, laughs, littered, wherever, laugh, pop, windows, sub, similar, installed, worst, include, fiddle, exactly, leave, improvements, sound, passion, fiddling, computers, rome, burns, power, renamed, narrowed, fit, monitor, portrait, typically, couple, habit, often, begins, figuring, minimize, expecting, fill, beyond, abbreviations, reason, lengths, stopped, obviously, hundred, worth, sitting, looked, situation, knew, commas, recall, helpful, been, ten, manually, spaces, care, sticks, chunks, together, fourth, taking, clever, 4th, guessed, comes, seem, grab, starts, somewhere, dle, asked, counting, possibly, hitting, boy, lcd, result, gets, a17, bingo, heh, too, simplify, pretend, step, stacked, probably, telling, figure, word, buttons, slowly, zero, contain, were, shown, puts, code, information, specifically, pot, luck, extra, stuck, starting, g22, containing, plugged, capture, form, disappear, however, perfectly, cellname, nobody, explanation, modifying, check, place, started, images, temp, c17, become, missed, consideration, finish, 1920, 1925, create, 1916, skip, barely, moves, selects, quicker, wrong, recent, seems, any, errors, workbook, contains, textfile, imported, cfya, ago, calculated, forgot, named, prelim, ignore, stored, created, hope, dec, apr, mar, bureau, statistics, provided, bit, topic, things, please, exercise, jazzbumpa, consumer, day, opportunity, practice, skills, moved, properly, aligned, easily, inserting, translated, recognized, grabbed, needed, perhaps, dragging, group, early, track, fifth, rhythm, symmetrical, missing, appears, rearranging, took, hour, occurred, rising, mitchell, sunday, sna, pleasing, ear, wipe, kleenex, googled, brought, eliminate, previous, direct, struggle, perseverance, progress, searched, hell, supposed, 91124, main, body, armenia, consists, several, scrollboxes, scrollbar, neat, scrolls, bored, naturally, miss, zoom, closer, additional, boxes, industry, specific, deal, basically, ones, magic, motions, verify, country, told, follow, wouldn, further, refreshed, run, selecting, captures, across, including, both, xml, loaded, separated, option, identified, sheesh, awkward, extract, along, picked, unchecked, otherwise, stays, gone, solve, bolded, widths, wrap, kind, wasn, front, deleted, thinks, uploaded, exporter, identifies, continue, nothing, biggest, chunk, jumble, separate, combine, drift, obvious, stupid, difficult, hey, seen, anywhere, discouraged, undo, stupidities, built, who, surely, beating, around, bush, avoid, rude, given, dollars, mean, billion, 500, digits, billions, compatible, sheet1, range, turns, justifies, behave, called, sheet3, badly, clean, present, backwards, newest, chronologically, sorted, 1997, trend, increase, decrease, suggests, variation, implies, trending, upward, deceptive, speak, farther, certain, article, leaves, net, his, usually, lines, clarity, relative, sizes, straightforward, consumed, under, differs, reasons, business, written, deductions, via, shares, stability, represents, fixed, assets, industries, current, prices, 2008, copyright, arthur, shipman, withering, shoots, waste, fraud, abuse, verdoorn, urgency, unsustainable, umic, ulc, tot, tongue, cheek, tint, knob, supply, decline, transaction, difference, taylor, symmetry, deception, stimulus, star, trek, standard, deviation, stagflation, report, slack, simulated, evidence, simulacron, serfdom, scott, reviews, reduction, reading, questions, printing, controls, predicting, pfi, parameters, oil, linear, moving, motives, multiplier, mmt, milton, friedman, military, medium, account, math, problems, matched, fekete, malaise, limits, ego, captain, introduction, iceberg, sleep, humor, pay, craft, hodrick, prescott, hoarding, revisionism, phase, rate, gresham, law, shortage, gang8, mpc, full, disclosure, era, fpi, forget, words, financialization, feedback, fcm, fallacy, composition, failure, embrace, factors, evolution, excuse, erosion, eroc, forces, echoes, dpd, disarray, demand, pull, deflation, outside, limit, issue, reissue, inside, general, equilibrium, activity, bulge, recovery, debasement, cycle, chronicles, efficiency, coping, coinage, civ, calculating, bullard, earthquake, best, downs, behavioral, finte, greater, artish, adjusting, accidental, discoveries, accelerated, repayment, argument, 400k, smoothing, revision, 2000, 1970s, real, contact, website, tufte, analysis, normalized, scaled, mental, workout, numerical, ignorance, kardi, teknomo, jim, organize, supreme, court, jester, prac, vin, faq, very, bloogger, within, color, codes, sentral, test, www, schools, host, tips, spoiler, theory2life, irrational, unsettling, broad, oak, redonomics, thinking, margin, old, freshman, dolor, rants, dredd, mayday, books, jbpeebles, truth, addicts, anon, frozen, arctic, tundra, blended, purple, candid, troublesome, action, nextblog, skeptical, optimist, worthwhile, canadian, father, tim, duy, cybereconomics, crises, businomics, ecometry, william, hummell, flavianopolis, aquinum, razor, crystal, bull, williams, sgs, econompic, secret, wieczorek, perot, historicalstatistics, irs, corp, 2006, usgovernmentspending, economagic, stock, 1947, flow, jobs, bea, measuringworth, statistical, abstracts, gavin, kennedy, mason, paul, scribd, 361, 571, 476, 2012, 412, 374, 283, 2015, 318, 274, 2017, gain, sumer, desire, such, concerns, meets, fixing, confuse, wages, salaries, arising, government, employment, inequality, symptom, percent, sides, advice, eye, ahead, safe, households, hedge, population, 1929, anna, zabai, bis, helps, keynes, excessive, finance, dolts, theory, sector, wanna, forgotten, crash, raising, footnote, shiller, drives, decade, swings, seeing, aberrations, high, archive, model, accumulating, hurts, mine, brings, preview, template, introductory, googledocs, alone, php, accumulation, art, vigor, overview, life, death, policies, overlap, recommendations, surprising, short, longer, views, newer, econcrit, challenging, premisses,
Text of the page (random words):
tting that spreadsheets do so the next time you open the thing most of your changes are gone save it in spreadsheet format and you solve that problem i bolded the column labels in row 1 set column widths and made the text in column c wrap automatically that s the kind of formatting you lose if you keep the file as csv then because i wasn t careful with the import i had to go into column f and delete a single quote from in front of the number on every row also i deleted some columns that unsna thinks important and i don t then i uploaded it to zoho so you can see what the thing looks like here s the zoho the filename was set by the undata exporter the first row identifies the columns look at rows 2 3 and 4 column c there you have output intermediate consumption and gross value added all for 2011 as column d shows the next three rows have the same three items of data for 2010 the rows continue like that back to 1987 then from 1986 back to 1970 the only data item is gross value added before 1970 nothing still we ve got three items of data for the years 1987 to 2011 not a bad start the biggest problem i have now is that all the numbers are in column f that means i can t copy a chunk of numbers and get just gross output or just intermediate consumption or something i get a jumble in order for the data to be useful i have to separate it into different columns by type so i get three columns of data rather than one and also combine the three rows for each year into one row then i get one row for 2011 with three columns of data and one row for 2010 with three columns of data and one row for 2009 with three columns of data i could go on but i think you get my drift it s obvious isn t it so why doesn t undata know this i think they do know it they re not stupid maybe they just want to make it difficult hey i ve never seen this data used anywhere why not i think people are discouraged from using the data because it is so much work to undo the stupidities built into it by people who surely should know better i m beating around the bush here trying to avoid being explicitly rude oh well if you scrolled the spreadsheet enough to see column f you saw that the numbers are given in dollars i mean if the value is 27 170 5 billion undata gives it as 27 170 500 000 000 that s not easy to read you have to count digits so i want to convert their numbers to billions the numbers will be easier to read that way and compatible with fred s numbers that and i want to convert the three row one column format to one row three columns so the data is useful now we re getting to the meat i copied the original data sheet1 to a new sheet to make the changes figured out a calculation to move the data for me into the format that i want it s in the first few columns of sheet2 in this zoho file it only applies to the data back to 1987 where there are the three different values for each year for 1986 back to 1970 i just copied and pasted the range of cells turns out that like my column f values my year values had the single quote mark that left justifies them and makes them behave like text instead of numbers next time i ll have to be more careful with the import from csv i copied sheet2 to make a new sheet and called it sheet3 on the new sheet i copied the first few columns and pasted them as values over top of the calculations after that i could delete the source data that was formatted badly clean up the sheet and credit undata for the data and of course they also present the data backwards newest first rather than chronologically i sorted that here s what i have so far data now ready to use now we re getting to the meat now i was ready to look at the numbers graph 1 i noticed wikipedia said in the us economy total intermediate consumption represents about 45 of gross output that s about right for the blue line since 1997 or so more like 42 before that and it looks like a trend of increase for the blue line and decrease for the red also when you say average it suggests up and down variation but it also implies stability in the value if intermediate consumption is trending upward as a share of gross output it is deceptive to speak of its average value would be nice if the values went farther back in time so one could be more certain about trends now we re getting to the meat another thing the wikipedia article said was that gross output is what we produce in a year but we use up intermediate consumption in the process which leaves us with net output which his just about the same as gdp that s four different data series right there to those four i want to add my context variable gds gross domestic spending that gives us five series to look at on one graph you with me usually if i have more than two lines on a graph i start to lose clarity this time it s five but we re only looking at their relative sizes that s straightforward the source for this graph is the same file as the shares of gross output graph above it s on the next tab to the right so you can look at the numbers if you want here s the picture graph 2 the blue line is u s gross output the measure of what we produce in a year the red line is intermediate consumption the measure of output consumed in the process of producing output it is almost half gross output the red is almost half the blue the green line is output left over after using up output red to produce output blue the green line is just a little over half the blue the red line is just a little under half the green is just a little over the gold line is gdp it is approximately equal to the green the gold line we call it gross domestic product but really it is the part of output left over after using output to produce output almost the same as the green line it differs for reasons you can read at wikipedia the brown line is gross domestic spending it is gdp plus the business spending that is written off as tax deductions in the process of producing output data sources for graph 2 blue red green unsna via undata gold fred brown arthurian posted by the arthurian at 4 00 am 0 comments labels gross domestic spending spreadsheeting sunday october 30 2011 easier the second time i got this from billy mitchell graph 1 i threw some trends on billy s graph and jazzbumpa threw them back at me i want to do more with trends using this same graph as a sample so now i need the numbers i found this graph at the bls link billy provides graph 2 bls provides the data in an excel file pretty nice it goes back to 1939 monthly numbers funny thing though each year is on its own row with one column for each month just like the consumer price index file i got the other day so it was another opportunity to practice my transposing skills to get all those 12 cell rows turned and moved and properly aligned with all the data in one column so i can more easily use it for graphs and calculations i did it this time in excel rather than open office calc i did the same thing as before inserting columns at the left and doing my work there 1 in excel i typed jan 1939 and when i hit enter it got translated into jan 39 so excel recognized it as a date after i entered the next two months of 1939 i grabbed all three cells and dragged em down and excel filled in the whole column for me with all the dates i needed perhaps in open office if i explicitly formatted the cell as a date it would have filled in all the dates for me when i tried dragging the group of three cells see steps 8 and 9 of yesterday s early post i notice it is much easier to keep track of what i m doing with this source data because this time the file does not have the blank line every fifth year i also noticed the rhythm of the process first select a dozen cells and press ctrl c then click a temporary destination and press ctrl v and then ctrl x click a permanent destination and press ctrl v and then ctrl c click a temporary destination and press ctrl v and then ctrl x click a permanent destination and press ctrl v and then ctrl c click a temporary destination and press ctrl v and then ctrl x click a permanent destination and press ctrl v and then ctrl c and like that to the end except at the end you don t need the last ctrl c because there are no more years to copy but it s symmetrical the ctrl c that s missing from the end of the sequence appears at the start anyway the whole rearranging the data thing took less than half an hour and that s for all the years since 1939 it goes quick spending that much time with the numbers it occurred to me how unusual it is that the numbers don t keep rising economic numbers always go up but not these numbers posted by the arthurian at 4 00 am 2 comments labels spreadsheeting saturday october 29 2011 exercise a bit off topic but you might find this handy if i happen to know things about excel that you don t then again if you know an easier way to do something i have done here please do let me know jazz recently provided a great link for cpi numbers going all the way back to 1913 monthly numbers from a strong source the bureau of labor statistics trouble is each year s numbers are all on one row all 12 months and two year values besides then the next year s numbers are on the next line this is not a useful format for graphing in my experience i want the numbers all in one column this post is about what i came up with to put all those cpi numbers into one column in order with the minimum amount of repetitive work and the minimum risk of error i did all this in openoffice calc which is free which is why i have it it has its own quirks but it does work a lot like excel what i ve done here will work in excel if you ve got it 1 i went to the bls link and saved the page in firefox on the firefox menu click save page as firefox wants to save the page as a text file which is fine 2 i saved it to the desktop i save everything to the desktop everybody laughs when they see how littered my desktop is you can save it wherever you want but when you can t find it i ll laugh at you i right clicked on the file and from the pop up menu i use windows clicked open with and from the sub menu openoffice org calc something similar should work if you have excel installed worst case open excel click file open change the file type to include txt files and select the bls file filename cpiai txt something like that 3 i had to fiddle with the text import window that opened up but i got exactly what i wanted on the third try the cpi data from bls with a year on each row and a column for each month not what i wanted for a final product but what i wanted to start with 4 remember to save the file as an open office spreadsheet or an excel spreadsheet don t leave it as the default type a text file because you will lose all your improvements when you save and close the thing this doesn t sound like economics at all does it sounds like my other passion fiddling with computers while rome burns in open office or excel whatever now you have a copy of the bls cpi data all you have to do now is make it useful this is where the power of a spreadsheet can really save you some work 5 i renamed the worksheet source and and made a copy of the sheet to make my changes in yeah it is easy enough to go get the thing again but is is easier just to make another copy of the source sheet if i need it 6 i narrowed down the columns so i could fit more on my screen my monitor is turned portrait so typically i can see a lot of rows and not a lot of columns 7 i inserted four columns to the left of column a making some blank space at the left side of the worksheet i left a couple blank cells at top just out of habit often they come in handy in cell a3 i entered date and in cell b3 cpi u 8 now the fun begins you know the repetitive part and figuring out how to minimize the repetition in cell a4 one row down from the cell where i typed date i entered jan 1913 which is of course where the bls numbers start below it i typed feb 1913 and below that mar 1913 then i selected those three cells and dragged em down the screen expecting it to automatically fill in apr 1913 and the rest of the months of 1913 and beyond 9 it didn t work so i typed in the rest of the months for 1913 always using 3 letter abbreviations for no reason except i thought it might be good to keep the lengths all the same turned out it was 10 when i got to january 1914 i stopped obviously there had to be a better way than typing every month and year for a hundred years worth of months 11 with the cursor sitting in cell a16 i looked the situation over i knew i wanted the letters jan from cell a4 and a space and the yearvalue from cell a4 with 1 added to it and actually i wanted that in every cell from here on down not jan but the month name from 12 rows up and the yearvalue from 12 rows up with 1 added to it 12 i can do that actually i couldn t because open office calc wants semicolons between the numbers where excel wants commas as i recall but the help was helpful and i figured it out long before i would have been done typing the next ten years of numbers manually and it worked you can see the formula i used in the image below 13 14 in cell a16 i typed an equal sign which tells the computer it will be doing a calculation followed by left a4 4 which tells the computer to take the first 4 characters from the left end of the text in cell a4 next i hit the spacebar once and then shift 7 for the ampersand and the spacebar once again pretty sure i need spaces there it might work without them but i don t have to care about that what the ampersand does is sticks chunks of text together what it will do for me is stick the three letters jan and the fourth character a space into cell a16 followed by whatever i put after the ampersand which i didn t tell you about yet see how i am taking the left 4 characters here and because i was clever enough to use all three letter month names the 4th character will always be a space and as a matter of fact the 5th character will always be the first number of the four digit year value and as you might have guessed the year value is what comes next in the formula by the way this may seem like a lot of work but it is a lot less work than typing in all those month names and year numbers by hand so after the ampersand we want the yearvalue but in cell a16 i want the next year after the yearvalue in cell a4 i want 1914 not 1913 so as you can see in the formula in the image above after the ampersand i put a 1 and a plus sign that will add 1 to something so now all i have to do is grab the yearvalue from cell a4 and i ll be done to get the yearvalue from cell a4 i typed mid a4 5 99 remember semicolons between the numbers if you re using open office calc what that does is it starts somewhere in the mid dle of cell a4 with the 5th character actually because that s what i asked for and gives me the next 99 characters or less i use 99 as a rule because it is easier than counting the maximum number of characters i might possibly need though in this case...
|
