Meta tags:

Headings (most frequently used words):

october, 2011, the, economics, monday, sunday, second, no, and, in, new, arthurian, google, saturday, friday, thursday, wednesday, tuesday, feet, easier, results, of, for, debt, accumulation, translate, blog, archive, links, labels, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, is, not, same, as, per, time, exercise, now, here, trend, that, to, see, manufacturing, employment, trends, following, up, with, alvin, warren, sir, one, from, page, five, third, search, financial, crisis, was, rooted, corporate, income, tax, interest, deduction, skills, shortage, reading, graph, past, 40, years, big, free, bird, brief, kind, word, shiller, have, clever, title, this, post, words, either, shower, gold, like, cracker, jack, glance, just, glimpse, capital, gains, coherence, loses, fed, on, shadow, banking, money, measures, context, velocity,

Text of the page (most frequently used words):
the (764), and (268), that (177), for (107), you (87), money (78), with (65), debt (65), from (60), this (59), not (57), graph (55), but (53), have (52), are (49), all (46), numbers (41), one (39), tax (39), cell (39), see (38), was (36), there (33), ctrl (33), what (31), will (31), then (31), #interest (31), can (30), base (30), like (30), out (29), arthurian (28), down (28), press (28), comments (27), october (27), cells (26), which (25), more (25), payments (25), posted (24), just (24), now (24), fed (23), line (23), they (23), here (23), inflation (23), 1913 (23), don (22), year (22), 2011 (22), years (22), when (21), how (21), because (21), after (21), column (21), formula (21), value (20), than (20), before (20), deduction (20), cpi (20), post (19), corporate (19), want (18), them (18), right (18), work (18), about (18), waldman (18), again (17), gains (17), rate (17), velocity (17), bls (17), bank (16), between (16), their (16), time (16), page (16), click (16), january (16), make (15), same (15), got (15), values (15), number (15), next (15), excel (15), those (15), left (15), row (15), open (15), other (14), know (14), should (14), get (14), first (14), into (14), policy (14), economy (14), some (14), central (14), financial (14), your (14), way (14), file (14), selected (14), federal (13), put (13), dollar (13), income (13), something (13), well (13), red (13), business (13), thing (13), independence (13), spending (13), type (13), data (13), 1914 (13), mouse (13), blue (12), mzm (12), also (12), may (12), less (12), has (12), capital (12), long (12), three (12), would (12), done (12), excess (12), use (12), four (12), its (12), economic (12), change (12), def (12), reserve (11), total (11), had (11), look (11), each (11), were (11), source (11), second (11), through (11), another (11), back (11), where (11), only (11), point (11), might (11), problem (11), december (11), measures (10), since (10), easier (10), much (10), level (10), looking (10), says (10), end (10), over (10), two (10), march (10), november (10), june (10), didn (10), august (10), google (10), september (10), crisis (10), congress (10), good (10), july (10), copy (10), shift (10), enter (10), feet (10), louis (9), shows (9), green (9), think (9), spreadsheet (9), used (9), taxed (9), term (9), thought (9), growth (9), months (9), his (9), note (9), gdp (9), ratio (9), trends (9), cost (9), office (9), off (9), typed (9), jan (9), character (9), february (9), april (9), any (8), quantity (8), range (8), too (8), did (8), article (8), been (8), reserves (8), paper (8), read (8), new (8), monetary (8), accountability (8), created (8), bias (8), many (8), recession (8), economics (8), billy (8), lot (8), dividend (8), using (8), sign (8), does (7), top (7), 100 (7), though (7), part (7), words (7), anyway (7), banking (7), really (7), while (7), increase (7), actually (7), found (7), link (7), great (7), depression (7), employment (7), better (7), key (7), times (7), start (7), five (7), very (7), skills (7), 1939 (7), said (7), alvin (7), warren (7), eliminate (7), calc (7), save (7), month (7), blank (7), image (7), fred (6), supply (6), difference (6), calculation (6), find (6), figure (6), pretty (6), short (6), still (6), could (6), pay (6), dividends (6), 2010 (6), sure (6), rather (6), price (6), why (6), few (6), pdf (6), structure (6), changes (6), average (6), cannot (6), past (6), per (6), immediately (6), 1980 (6), every (6), credit (6), equity (6), pointing (6), costs (6), results (6), write (6), doesn (6), case (6), topic (6), useful (6), text (6), need (6), a16 (6), yearvalue (6), characters (6), hold (6), button (6), parenthesis (6), 1915 (6), destination (6), org (5), posts (5), show (5), lines (5), these (5), whatever (5), sample (5), keep (5), ten (5), dollars (5), fit (5), shadow (5), say (5), individuals (5), corporations (5), law (5), dates (5), john (5), yesterday (5), during (5), must (5), above (5), starts (5), little (5), who (5), writes (5), most (5), makes (5), brief (5), below (5), even (5), without (5), however (5), always (5), yet (5), easy (5), components (5), exercise (5), pothole (5), maybe (5), able (5), shortage (5), manufacturing (5), firm (5), firms (5), going (5), reading (5), taxes (5), playing (5), field (5), temporary (5), financing (5), stockholders (5), quoted (5), space (5), bondholders (5), wanted (5), rows (5), once (5), ampersand (5), date (5), release (5), keys (5), f21 (5), parsing (5), graphs (4), recent (4), bottom (4), relation (4), highest (4), whether (4), zero (4), course (4), give (4), equal (4), come (4), add (4), interesting (4), sentence (4), following (4), excerpt (4), rest (4), lower (4), being (4), history (4), holding (4), percent (4), reduced (4), whose (4), 2008 (4), added (4), prices (4), treasury (4), worked (4), unemployment (4), rates (4), policies (4), company (4), government (4), title (4), ago (4), shiller (4), form (4), original (4), provides (4), designed (4), independent (4), system (4), political (4), economists (4), help (4), important (4), seems (4), free (4), big (4), fact (4), made (4), move (4), trend (4), increases (4), works (4), noticed (4), darwin (4), things (4), glacial (4), around (4), productivity (4), large (4), 1918 (4), profits (4), third (4), surowiecki (4), scale (4), code (4), went (4), sounds (4), rule (4), side (4), extra (4), revenue (4), our (4), monthly (4), menu (4), select (4), columns (4), entered (4), cursor (4), computer (4), whole (4), b15 (4), transpose (4), curly (4), braces (4), transposing (4), q21 (4), f22 (4), paste (4), goes (4), doubled (4), guy (4), http (3), research (3), stlouisfed (3), fred2 (3), lead (3), agree (3), plus (3), 2006 (3), gave (3), trying (3), minimum (3), maximum (3), across (3), process (3), context (3), sunday (3), originated (3), paul (3), monday (3), forms (3), higher (3), today (3), period (3), result (3), signed (3), president (3), until (3), quantitative (3), williams (3), such (3), additional (3), 600 (3), looks (3), double (3), tried (3), krugman (3), wednesday (3), happen (3), 1937 (3), occurred (3), seem (3), getting (3), shower (3), gold (3), politics (3), irrational (3), clever (3), couple (3), word (3), excerpts (3), paragraphs (3), paragraph (3), blame (3), pages (3), ensure (3), based (3), force (3), legal (3), clearly (3), power (3), means (3), subject (3), people (3), avoid (3), james (3), private (3), making (3), spent (3), let (3), spike (3), decrease (3), clear (3), 1974 (3), 1966 (3), except (3), both (3), measure (3), hard (3), edge (3), notice (3), isn (3), example (3), report (3), thousands (3), mid (3), produced (3), companies (3), order (3), demand (3), paying (3), davis (3), jstor (3), sir (3), risk (3), hint (3), gives (3), call (3), bad (3), skews (3), eliminating (3), changing (3), looked (3), writing (3), accumulating (3), sheet (3), enough (3), labels (3), spreadsheeting (3), jazz (3), own (3), firefox (3), wants (3), desktop (3), cpiai (3), yeah (3), turned (3), typing (3), doing (3), followed (3), hand (3), arrow (3), dozen (3), transposed (3), special (3), q22 (3), okay (3), selection (3), version (3), 1983 (3), fold (3), nice (3), permanent (3), pellet (3), 1200 (3), timeline (3), blog (3), 2016 (2), appear (2), newer (2), points (2), situation (2), various (2), tcmdo (2), sort (2), running (2), along (2), ends (2), stopped (2), counting (2), recognized (2), control (2), within (2), fiddle (2), mind (2), expect (2), coming (2), stretch (2), compress (2), different (2), subtract (2), plot (2), math (2), max (2), factor (2), divided (2), finally (2), nothing (2), reason (2), happened (2), phrase (2), statement (2), ordinary (2), wikipedia (2), view (2), taxpayers (2), assets (2), held (2), net (2), bracket (2), progressive (2), eligible (2), act (2), 2012 (2), coherence (2), loses (2), tuesday (2), mine (2), easing (2), late (2), purchase (2), longer (2), ben (2), waited (2), 2009 (2), glimpse (2), removed (2), glance (2), thursday (2), china (2), cycle (2), somehow (2), futurecast (2), attack (2), broad (2), pointed (2), recall (2), ever (2), seeing (2), afflicted (2), ravaged (2), six (2), deal (2), despite (2), budget (2), never (2), moves (2), journal (2), cracker (2), jack (2), friday (2), model (2), market (2), anything (2), length (2), ignore (2), guess (2), exuberance (2), ought (2), having (2), robert (2), stuff (2), kind (2), saturday (2), christopher (2), waller (2), liked (2), conclusion (2), sources (2), broken (2), ones (2), span (2), hover (2), pop (2), famous (2), review (2), fundamental (2), tension (2), accountable (2), electorate (2), improve (2), credibility (2), transparency (2), led (2), institutional (2), design (2), sound (2), opposed (2), banks (2), place (2), minimize (2), governments (2), cbi (2), properly (2), calculate (2), 1993 (2), developed (2), countries (2), levels (2), bankers (2), officials (2), worst (2), response (2), policymakers (2), calamity (2), bullard (2), sector (2), moving (2), erosion (2), issue (2), democracy (2), gain (2), century (2), bird (2), hour (2), mzmsl (2), 1982 (2), matched (2), recessions (2), 1970 (2), smaller (2), lose (2), 1960s (2), appears (2), tend (2), opposite (2), directions (2), arithmetic (2), denominator (2), thus (2), greater (2), finish (2), everything (2), applies (2), together (2), driving (2), helped (2), quarterly (2), nominal (2), series (2), stock (2), stop (2), habit (2), morning (2), odd (2), missed (2), day (2), wasn (2), story (2), related (2), wrote (2), easily (2), overlook (2), friedman (2), scientist (2), aware (2), theory (2), later (2), earlier (2), thinks (2), piece (2), gap (2), presents (2), overall (2), starting (2), 000 (2), workers (2), current (2), create (2), output (2), available (2), literally (2), unfilled (2), sitting (2), books (2), share (2), spend (2), jobs (2), pete (2), grow (2), else (2), yale (2), skewing (2), study (2), links (2), deductible (2), full (2), whatsoever (2), permitted (2), unlimited (2), equalize (2), effects (2), world (2), war (2), financed (2), investments (2), taxation (2), rooted (2), externalizes (2), risks (2), activity (2), take (2), search (2), fifth (2), quote (2), leave (2), accumulation (2), specifically (2), showing (2), clock (2), profit (2), favor (2), device (2), gets (2), wrong (2), similar (2), checked (2), problems (2), trouble (2), medium (2), besides (2), thankfully (2), last (2), proposal (2), forces (2), comes (2), care (2), perhaps (2), understand (2), cool (2), socialize (2), investor (2), receives (2), fundamentally (2), investment (2), investors (2), trust (2), enforce (2), bankruptcy (2), taking (2), analysis (2), fair (2), repetitive (2), openoffice (2), saved (2), clicked (2), txt (2), files (2), window (2), try (2), final (2), remember (2), close (2), worksheet (2), screen (2), inserted (2), handy (2), fun (2), dragged (2), automatically (2), letter (2), worth (2), letters (2), couldn (2), semicolons (2), tells (2), hit (2), spacebar (2), stick (2), tell (2), names (2), matter (2), 5th (2), digit (2), worry (2), drag (2), tools (2), pressed (2), closing (2), bar (2), sense (2), signs (2), cut (2), ods (2), quick (2), mess (2), delete (2), stand (2), docs (2), versions (2), feb (2), labor (2), eight (2), old (2), threw (2), filled (2), sequence (2), unusual (2), gun (2), shoots (2), pellets (2), 2018 (2), sumner (2), star (2), trek (2), household (2), loops (2), laffer (2), curve (2), jerry (2), historical (2), expectations (2), echoes (2), civilization (2), push (2), 2013 (2), dave (2), ross (2), translate (2), html (2), blogger (2), economist (2), charts (2), venn (2), rights, reserved, courtesy, horse, water, him, drink, stay, thirsty, friends, subscribe, atom, home, older, remark, certainly, irretrievable, 1959, measured, squashed, substantially, room, proportional, rectify, brown, lost, development, notes, methodology, idea, turn, blind, dimension, 500, 495, baseline, location, minus, confusing, description, min, determines, stretched, compressed, multiply, ended, expected, square, kosh, innovation, essentially, vanished, ashwin, mcculley, formerly, pimco, called, bryan, noeth, rajdeep, sengupta, traditional, liabilities, love, told, includes, contrasts, nicely, 1934, 1941, exclude, percentages, varied, excluded, respectively, united, states, sorts, sold, 2003, lowest, brackets, previously, scheduled, expire, extended, prevention, reconciliation, bush, toward, obama, extending, modifies, 10th, bought, trillion, instruments, announced, billion, securities, boost, tripled, easings, gradual, uptrend, almost, normal, portion, expand, sits, idle, relative, arose, providing, keynesian, sweeping, painful, prize, discussion, seen, criticize, caused, relapse, mention, forced, futurecasts, bread, butter, ohm, screws, finances, throwing, lifeline, breaks, purchases, bailout, imply, adds, employees, target, customers, win, selling, products, services, unnecessary, fight, arm, bailouts, updates, news, nanute, usually, moment, saw, commons, either, hours, turns, book, web, origin, unambiguously, titled, rearranged, provide, continuity, shortened, presented, intro, abstract, footnotes, references, shorter, attention, identifying, runs, 293, 301, balanced, lacking, presentation, sided, itself, already, studying, lucas, suggest, perspective, permission, remains, losing, credible, reasoning, understandable, tendency, reexamine, tool, misuse, reasons, purposefully, print, excessive, amounts, termed, discretionary, policymaking, decided, answer, question, necessary, country, specific, constructed, variety, indicators, discussed, published, alesina, summers, high, experienced, 1955, derived, negative, relationship, manipulated, elected, fashion, requires, behave, transparent, manner, oversight, weakens, perception, respects, 1930s, begun, examine, prior, goals, responsibilities, changed, prevent, argue, further, consolidated, washington, levers, closer, hub, tricky, willingness, ways, boggling, particular, counterintuitive, mistakes, principle, everpresent, public, uninformed, observer, miles, mirrors, major, relatively, constant, tall, significant, peaks, count, peak, sag, rose, fell, pace, mathematical, holds, true, corresponding, near, fairly, invention, flat, varies, proportion, parallel, magic, simple, uptrends, downtrends, obvious, plays, larger, role, creating, differences, nonetheless, vary, differently, contribute, equally, variations, elapsed, drive, distance, traveled, speed, assume, unless, faster, slowdown, spendings, tee, miss, staying, patched, gone, minor, event, reminded, lionel, ruby, causing, jigger, likely, fellow, searching, fossils, north, england, revisited, area, astonished, discover, marked, ridges, rocks, visit, appreciate, markings, became, absolutely, ruse, condense, quotes, unrelated, thousand, apparently, taken, represent, volume, orders, frustrated, satisfy, survey, reveals, unmet, consumers, cash, systematically, goods, labour, shortages, national, hovers, borrowed, borrow, sloppy, hell, ironic, bothered, fix, busy, finger, googling, brought, expense, currently, limited, offsets, against, granted, according, 2005, congressional, capitalgainsandgames, list, returned, steve, deductibility, businesses, magnifies, social, concentrates, among, bear, under, rules, rid, interfluidity, previous, kenneth, galbraith, recognize, felt, author, small, agreed, taxable, reduce, restore, dangerously, nudges, direction, mortgage, million, euphoria, encourages, yorker, articles, considered, noon, complained, rejected, option, reviewed, hints, none, happy, generate, utility, approved, wiggle, comparing, pretending, advantages, focus, talk, relieving, burden, break, clean, allows, deductions, leaves, ears, wading, impression, oooh, altogether, resist, including, arrive, follows, bring, twists, natural, helps, produce, burdened, successful, industry, finance, everyone, suddenly, realizes, bringing, nor, deficit, beneficial, harmful, willing, trade, focusing, drifts, considerations, complicates, matters, raising, veil, confusion, reader, heart, damn, feelings, meltdown, shouldn, disproportionately, incidence, least, accompanied, elsewhere, enhanced, entirely, ending, perverse, incentive, subsidy, wizards, hugely, stable, environment, drops, balance, bondholder, pays, paid, uncle, sam, state, meddling, tilt, scales, towards, creditors, equityholders, crucial, modern, strangers, overcome, issues, nervous, given, equivalent, doomsday, claim, timely, malice, misfortune, fails, promised, claims, via, convention, encourage, socially, partially, downside, existence, enforceable, essential, element, constellation, institutions, fund, intensive, projects, coercion, footnote, messed, troubles, indebtedness, fully, eyeballed, separate, ces3000000001, activities, ces5500000001, recently, strong, format, graphing, experience, came, amount, error, quirks, fine, everybody, laughs, littered, wherever, laugh, windows, sub, installed, include, filename, opened, exactly, product, default, improvements, passion, fiddling, computers, rome, burns, renamed, narrowed, monitor, portrait, typically, often, begins, figuring, repetition, expecting, fill, beyond, abbreviations, lengths, obviously, hundred, knew, name, commas, helpful, figured, manually, spaces, sticks, chunks, fourth, 4th, guessed, grab, somewhere, dle, asked, possibly, suppose, hitting, boy, lcd, a17, bingo, heh, away, simplify, pretend, step, stacked, probably, spreadsheets, telling, buttons, slowly, contain, shown, puts, information, single, pot, luck, stuck, g22, containing, plugged, capture, disappear, perfectly, cellname, nobody, explanation, modifying, copied, check, started, images, temp, c17, become, item, consideration, 1920, 1925, 1916, skip, barely, selects, quicker, loop, errors, workbook, contains, textfile, imported, cfya, calculated, forgot, named, prelim, stored, hope, dec, apr, mar, import, bureau, statistics, provided, bit, please, ducks, inspiring, reward, naturally, chunk, sometime, 225, roughly, tenfold, twice, ballpark, gonna, soon, meanwhile, 1929, 1945, briefly, bullshit, days, jazzbumpa, funny, consumer, index, opportunity, practice, moved, aligned, calculations, inserting, translated, grabbed, needed, explicitly, formatted, dragging, group, steps, early, track, rhythm, symmetrical, missing, rearranging, took, half, rising, mitchell, talking, football, fields, far, gravity, pulls, ground, shooting, air, quarter, travel, 300, copyright, arthur, shipman, zoho, withering, waste, fraud, abuse, verdoorn, urgency, unsustainable, umic, ulc, tot, tongue, cheek, tint, knob, decline, transaction, taylor, symmetry, deception, stimulus, standard, deviation, stagflation, slack, simulated, evidence, simulacron, serfdom, scott, reviews, reduction, questions, printing, controls, predicting, pfi, parameters, oil, non, linear, motives, multiplier, mmt, milton, military, account, set, fekete, malaise, variable, limits, ego, captain, introduction, iceberg, sleep, humor, craft, hodrick, prescott, hoarding, revisionism, phase, gross, domestic, gresham, gds, gang8, mpc, disclosure, era, fpi, forget, financialization, feedback, fcm, fallacy, composition, failure, embrace, factors, evolution, excuse, eroc, dpd, disarray, pull, deflation, outside, limit, reissue, inside, general, equilibrium, bulge, recovery, debasement, chronicles, efficiency, coping, coinage, civ, calculating, wealth, earthquake, best, downs, behavioral, finte, artish, adjusting, accidental, discoveries, accelerated, repayment, argument, 400k, smoothing, revision, 1986, 2000, 1970s, real, contact, website, tufte, normalized, scaled, mental, workout, numerical, ignorance, kardi, teknomo, jim, organize, supreme, court, jester, prac, vin, faq, bloogger, color, codes, sentral, test, www, schools, host, tips, spoiler, theory2life, unsettling, oak, redonomics, thinking, margin, freshman, dolor, rants, dredd, mayday, 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, sgs, econompic, secret, mark, wieczorek, perot, historicalstatistics, irs, corp, usgovernmentspending, economagic, 1947, flow, funds, bea, accounts, measuringworth, statistical, abstracts, gavin, kennedy, mason, scribd, 361, twentieth, wage, suppression, black, helicopters, yes, dear, ambsl, nope, downhill, nuts, glances, inco, 571, 476, 412, 374, 2014, 283, 2015, 318, 274, 2017, archive, hurts, brings, preview, template, introductory, googledocs, alone, php, art, vigor, overview, download, life, death, overlap, recommendations, surprising, views, econcrit, challenging, premisses,

Text of the page (random words):
ause 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 f21 note however that you might not have f21 you might be transposing numbers from a different cell that is perfectly okay 29 type shift 4 to put a dollar sign after the open parenthesis character now use the arrow keys to move the cursor to the right so that the next character you type will come immediately after the and immediately before the q21 or whatever cellname you have type shift 4 again to put another dollar sign immediately after the nobody said to press enter yet do not press enter not yet 30 the dollar sign before the f21 makes it so the f will not change the dollar sign before the q21 makes it so the q will not change that s what we want because the bls numbers we are using start in column f for january and end in column q for december if the explanation doesn t make sense stick with me anyway it ll make sense when you see it happen 31 now that you have typed in the two dollar signs we are done modifying the formula do not press enter as before you have to press and hold down the ctrl key and the shift key with those keys pressed press and release the enter key then release all the keys your curly braces should come back 32 now we need to do 1914 so with cells b4 through b15 still selected press ctrl c to copy the formula then click on cell c5 one row down and one column to the right of the transposed january 1913 number with cell c5 selected press ctrl v to paste the formula we copied 33 you can check your work if you want but if you do make sure not to change which cells are selected 34 in this image you can see that we are using cpi values from cells f22 through q22 there are dollar signs there so what you see is f22 and q22 actually those start and end cells are one row down from f21 and q21 where the 1913 numbers are that s good that means we got the 1914 cpi numbers 35 now without changing the selection of cells press ctrl x to cut them out of column c click on the cell in column b that is next to jan 1914 in column a and with that one cell selected press ctrl v to paste the cpi values for 1914 in place where we want them 36 oh i just noticed for the first image i used the cpiai ods file i started with but for the rest of the images i used the temp cpiai ods file that i m using to help me write this post oh well 37 again do not change the selection of cells press ctrl c to copy the formula that gives you the 1914 values point to the cell that is one row down and one row to the right of the january 1914 cpi value in my example point to cell c17 click on that cell and press ctrl v to paste in the formula for the 1915 values now without changing the selection press ctrl x to cut out the formula click on the cell that will hold the january 1915 value and press ctrl v to paste the formula into all the months of 1915 38 at this point it has become easy to transpose the next line read item 37 again if you missed it but there is one more consideration before you finish transposing your data 39 in the original bls data there is a blank line after 1915 there is a blank line every five years after 1915 and 1920 and 1925 and so on so when you copy the 1915 formula to create the 1916 formula you don t point to the cell that is one down and one to the right you point to the cell that is two down and one to the right by going down two you skip the blank line 40 and that s it ctrl c ctrl v ctrl x ctrl v the left hand barely moves the right hand selects cells with the mouse it goes quick much quicker than writing this post for example 41 by the way if you mess up just delete the cells that are wrong select the most recent year s numbers that are right and get back into the loop it seems there is an easier way for you to get the cpi numbers all in one column you can use the file i used i checked it over as much as i could stand and i don t see any errors in it the workbook contains three pages source the original bls textfile imported to the spreadsheet monthly all the data transposed into one column cfya change from year ago values calculated from the cpi u values if i forgot to delete it there is also a page named monthly prelim which you can ignore i stored the files at google docs three versions 1 the google docs version 2 the open office calc spreadsheet 3 an excel version created by open office hope this was a useful post posted by the arthurian at 4 00 am 0 comments labels spreadsheeting friday october 28 2011 now here s a trend that s easier to see us financial activities employment thousands since 1939 source ces5500000001 at bls posted by the arthurian at 12 00 pm 0 comments manufacturing employment trends us manufacturing employment thousands since 1939 source ces3000000001 at bls this time i eyeballed in four separate trends related post the skills shortage and reading a graph posted by the arthurian at 8 00 am 0 comments following up with alvin c warren on wednesday i quoted alvin warren from the yale law review the unlimited deduction for corporate interest payments originated in 1918 as a temporary measure designed to equalize the effects of the world war i excess profits tax i thought that was interesting so i went back to the jstor page and found this footnote congress thought it was only fair that interest on corporate indebtedness be fully deductible it s not the federal reserve that messed up our economy it s congress and the level of their economic analysis is it s only fair don t blame the fed for our economic troubles blame congress posted by the arthurian at 4 00 am 1 comments thursday october 27 2011 no sir three in a row yesterday all pointing out the debt bias created by the tax code specifically created by the corporate interest deduction a total of four articles considered all of them showing debt bias as a problem but here s something in the noon post i quote james surowiecki companies can write off all the interest on their debt but not things like dividend payments i complained that surowiecki seems to hint that maybe corporations should be able to write off both their dividend payments and their interest payments and i rejected that option for this post i went back and reviewed his article looking for more such hints but found none so that made me happy it s a good article here s the link again in the four o clock post i quoted alvin c warren who points out that no deduction whatsoever is permitted for dividend payments sounds to me like another hint look dividend payments are profit profit is the only part of business income that is taxed that s bad because it skews the playing fiel...