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):
this goes all the way back to sumer in the third the point of maximum gain 2017 274 december 31 november 26 october 21 september 23 august 27 july 21 june 17 may 21 april 13 march 25 february 25 january 24 2016 318 december 26 november 20 october 30 september 27 august 29 july 17 june 30 may 24 april 30 march 30 february 30 january 25 2015 283 december 7 november 11 october 21 september 23 august 26 july 27 june 26 may 30 april 25 march 28 february 27 january 32 2014 374 december 25 november 25 october 26 september 30 august 34 july 35 june 32 may 34 april 33 march 35 february 28 january 37 2013 412 december 33 november 31 october 35 september 32 august 33 july 36 june 31 may 36 april 39 march 40 february 31 january 35 2012 476 december 38 november 35 october 51 september 41 august 35 july 39 june 37 may 31 april 38 march 36 february 44 january 51 2011 571 december 44 november 38 october 41 september 53 august 54 july 52 june 50 may 45 april 54 march 46 february 37 january 57 2010 361 december 51 november 43 october 47 september 43 august 35 july 39 june 31 may 9 april 8 march 12 february 23 january 20 2009 79 december 17 november 10 october 14 september 20 august 3 july 7 june 4 april 1 march 1 february 1 january 1 links the 12 pages pdf html scribd money as credit paul krugman john mason gavin kennedy crisis timeline 1 crisis timeline 2 statistical abstracts measuringworth bea economic accounts bls inflation jobs flow of funds debt st louis fed fred money stock 1947 58 economagic usgovernmentspending top tax rates recession dates corp taxes 2006 irs tax data pk sources historicalstatistics org historical charts perot charts mark wieczorek the secret economist econompic john williams sgs crystal bull aquinum s razor flavianopolis william f hummell ecometry the l curve businomics blog on banking crises cybereconomics tim duy like a father to me worthwhile canadian the skeptical optimist nextblog better of thought action the troublesome economist the candid blogger blended purple frozen arctic tundra truth addicts anon jbpeebles mayday books dredd blog dolor s rants the 40 year old freshman thinking on the margin redonomics broad oak unsettling economics irrational expectations theory2life prac spoiler tips vin s read more faq s image host a very nice menu www w3 schools bloogger help image test and t2 blogger sentral html color codes google translate link within a page supreme court jester dave ross 1 dave ross 2 organize your stuff interesting jim kardi teknomo numerical ignorance mental workout g scaled data g normalized data tufte data analysis arthurian website about me contact labels real is a calculation 1 2 3 4 5 6 7 1966 1970s growth 1986 2000 2013 revision 400k smoothing a call for better argument a little r n r accelerated repayment of debt accidental discoveries adjusting debt for inflation artish b is greater than a b h finte behavioral ec best put downs bullard s earthquake c d of wealth calculating labor share civ civilization coinage coping cost and productivity cost push cost push inflation credit efficiency crisis chronicles cycle of civilization debasement debt debt 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 j...
|
