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):
ts 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 that number would i suppose be four but 99 works and i don t have to worry about what else might work so that s it that s the whole formula now i enter the formula into cell a16 by hitting the enter key boy this is really lcd isn t it and make sure it gave me the result that i want jan 1914 15 now it gets easy with the cursor in cell a16 type ctrl c to copy the formula then press the down arrow and type ctrl v to past a copy of the formula into cell a17 feb 1914 try a few more to make sure it works then select a whole lot of cells in column a and press ctrl v to past the formula into all of em at once 16 bingo the date values are done 17 heh that was the easy part 18 i worked out a way to copy the cpi numbers too but i didn t get it right away with the 1914 numbers but to simplify this story we will pretend that i did 19 go up to the top of the spreadsheet again click on cell b4 which is just below the text cpi u that you typed in step 7 just to the left of the selected cell it should say jan 1913 with the mouse pointing at cell b4 click and hold down the left mouse button and drag the mouse down until you are pointing at cell b15 just to the left of that cell it says dec 1913 and release the mouse button so what you have done is you have selected the 12 cells where you want to put the cpi values we got from the bls which should be over to the right and maybe a few rows down from the selected cells 20 the selected cells are stacked one above the other in a column the numbers we want are all next to each other in a row what we have to do is transpose them 21 this probably sounds like a lot of work to transpose one row at a time yeah don t worry about it spreadsheets are useful tools 22 with those dozen cells selected type an equal sign again telling the computer that it will have to figure something out followed by the word transpose and shift 9 for the open parenthesis character now with no mouse buttons pressed find the bls numbers for 1913 point the mouse to the cpi value for january 1913 then press and hold down the left mouse button slowly drag the mouse over to the right holding the mouse button down until the mouse is pointing at the cpi value for december 1913 release the mouse button press shift 0 that is shift zero to type the close parenthesis character now do not press enter 23 with the cpi numbers for 1913 all selected and the closing parenthesis typed in press and hold down the ctrl key and the shift key at the same time and while holding them down press enter once then release all the keys 24 if you look back at your column b cells b4 through b15 now contain the cpi values transposed from the original where they were all in a row 25 important note in the formula shown in this image you can see curly braces the and characters before the equal sign and after the closing parenthesis you do not have to type them in in fact you should not type them in the computer puts them in there automatically when you hold down ctrl and shift and press enter the curly braces are not characters they are code they are special information that tell you that your formula was entered the special way and that it applies in this case not to a single cell but to a dozen cells in the formula bar you can read that i am transposing cells on row 21 specifically i am using cells f21 through q21 but that s just pot luck if i inserted an extra blank row at the top i d be using cells f22 through q22 and if i stuck another column at the left i d be starting with cell g22 not f22 the important thing is that i selected the cells containing the bls numbers for the 12 months of 1913 and plugged them in to the 12 cells for 1913 in column b 26 where was i 27 what we have just done is to capture the bls numbers for 1913 and put them into a useful form before we do the numbers for 1914 there is one more thing to be done 28 with cells b4 through b15 still selected click in the formula bar notice that the curly braces disappear that s okay now with the arrow keys or maybe the mouse move the cursor so that when you type what you type will appear immediately after the open parenthesis character and immediately before the f of f...
|
