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):
ebt and context debt and inflation debt and recovery debt bulge debt good and bad debt is not credit debt productivity debt to gdp debt to gdp in comments def credit def debt def economic activity def financial cost def gdp def general equilibrium def inflation def inside money def investment def issue and reissue def laffer limit def outside money deflation demand pull inflation disarray dpd echoes economic forces economics v the economy eroc erosion of debt evolution of the excuse expectations factors failure s embrace fallacy of composition fcm fed policy federal spending feedback loops final spending financial cost financialization five words five digit years forget about debt fpi fred free banking era full disclosure fun with the mpc gang8 gds gold shortage gresham s law gross domestic spending growth rate calc growth phase growth historical revisionism hoarding hodrick prescott household debt hover craft how to pay for it humor because you might not know if i didn t say i couldn t sleep iceberg inflation introduction is it ego captain jerry says krugman laffer curve limits long and variable loops malaise matched set fekete math problems medium of account military spending milton friedman mmt money multiplier more debt than money is policy motives moving average new tools of policy non linear not only household debt oil parameters for debt pfi policy predicting recession price controls printing vs spending problem x productivity questions r reading and writing red and green reduction reviews scott sumner sequence 2 serfdom simulacron simulated evidence slack special report spreadsheeting stagflation standard deviation star trek stimulus sumner symmetry in deception taxes taylor rule the difference between debt and credit the economy is transaction the k r shift the long decline the supply side the tint knob they don t know timeline tongue in cheek tot ulc umic unsustainable urgency verdoorn waste fraud abuse withering shoots zoho the new arthurian economics copyright 2010 2018 arthur shipman showing posts with label spreadsheeting show all posts showing posts with label spreadsheeting show all posts saturday july 5 2014 unsna us gross output 1987 2011 unsna is un sna the united nations system of national accounts like nipa except nipa is pleasing to the ear and unsna sounds like something you d wipe off with a kleenex i googled unsna data historical and found system of national accounts 2008 united nations so i went there looking for data i clicked data on their blue menu bar that brought me to their national accounts data page text and links at the end of the second paragraph is a link to undata that s the one you want i suppose i could eliminate the previous paragraph and just give you the undata link direct but i m trying to give you a sense of the struggle perseverance in the search for data plus i write this stuff down so i can find my way back later anyway the undata page has a search box so now we re making some progress i searched for gross output i got two hits two is good what the hell am i supposed to do with 13 million hits i take table 2 6 output gross value added and fixed assets by industries at current prices isic rev 4 because it has 91124 records the other one isic rev 3 must be older and has half a million records maybe i ll look at that later now we re getting to the meat the rev 4 link gives me this the main body of the default page is a table of info about armenia it consists of several columns of info i don t want but there are select filters scrollboxes on the left the first one is countries so i can look at u s data instead their scrollbar is neat you just hover over the little down arrow and the list of countries scrolls slow enough you can read it but not so slow that you re bored in the second filter box you can pick years for data i want all the years naturally now the important part that you must not miss just below the second filter list there is a link that says more you ll want to click that it lets you zoom in closer to the data you want click the more and you get two additional filter boxes at the top of the third box is total economy that s the one i want the other options are industry specific i want big picture the last filter box lets you pick the data you want to see that s a big deal basically i wanted the first three that appear in the filter window the ones i saw at wikipedia yesterday gross output intermediate consumption and gross value added the last of these being approximately equal to gdp oh and most important be sure to click the apply filters link it s below the last filter box that s the magic that makes undata do what you want oh funny thing while writing this post i was going through the motions to verify the steps but i didn t pick the country and the years before i clicked more then after i told you about all four filters i tried to pick the u s and follow through the process but the thing wouldn t let me pick the u s the list of countries scrolled down as far as the s s and no further i clicked less to go back to the two filter screen and tried again no good but i refreshed the page and then it worked okay in case you run into trouble using the thing when i was done selecting my filter options i clicked apply filters and the screen changed to show the data i wanted to see and if you don t know about csv as the first of the undata screen captures shows across the top above the table of data are options including download and select columns both look useful i used download which gives some format options first time i tried xml but when i loaded it into openoffice calc i got a blank spreadsheet so then i tried the value separated option identified as comma sheesh what an awkward way to say csv and it worked fine gave me a zip file had to extract the data file from the zip before i could use it i just put it on my desktop along with everything else then i right clicked the data file and picked open with openoffice calc a text import window opened i checked comma and unchecked tab or something like that to make the sample import look right then clicked ok openoffice calc opened the file right away excel would be as easy maybe easier now we re getting to the meat i saved the spreadsheet right away in spreadsheet format otherwise it stays as a csv file and csv files can t save the formatting 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 ...
|
