BP Comment Quick Links
March 12, 2010 BP UnfilteredPECOTA Updateby Dave Pease 2010 PECOTA Projection Analysis As promised, here are the results of our preliminary analysis of the 2010 PECOTA projections. We took the methodology for multiple builds of the projections (which will be easier to identify when we start using versioning, which we will do when we've got everything else cleaned up) and ran all the inputs for the 2009 version of PECOTA through it. Then we compared those projections to the actual results of the 2009 season. In all cases, lower numbers are better. RMS Error results
Bias-adjusted RMS Error results
BP used the 2010 PECOTA projections as the basis of our LABR draft strategy this weekend.
PECOTA Ten-Year Forecasts and Hitter Cards We have diagnosed the main problem with our ten-year forecasts as reported on the PECOTA beta hitter cards. Nate Silver generated one set of comps in the original PECOTA process and used those comps to generate the long-term projections. We were trying to re-generate new comps in year n+1 based on the player's career thus far with his projections for year n included, and repeating. In addition to introducing considerable extra complication, this process generally created much less favorable long-term projections, as many readers noted. We've adjusted the long-term projection process to work the way Nate originally designed it. Once we've got everything stabilized and released, we'll be revisiting this topic. Another problem we had was that a player projected to be out of baseball entirely had a value of zero, while if he was good enough to be projected to get some playing time but bad enough to be below average, he'd have a negative value. For example, in a player's tenth percentile, he might be out of baseball entirely, returning 0 WARP, but in his fiftieth he performed well enough to stay in baseball, and rated -1.0 WARP in the playing time he was projected to get. Because we didn't distinguish between a 0 WARP in baseball and a 0 WARP being out of baseball, this enabled some very weird results for players with this condition. We've changed the process to differentiate between the two, and the values should now be much more reasonable. The K bar in the player profile graph has been reversed, and now works as it did previously. We still have a problem with some players having their higher percentile projections zeroed out, while the lower are filled--we've identified this internally as "the Koyie Hill problem". This is a similar issue to the reversed projections problem above, and it'll be fixed this weekend. PFM Settings Update
We've made some small changes to the position adjustment setting of the PFM:
Levels 2 and 3 are disabled. We are looking into bringing those levels back into play--lets us know how much you used and miss them.
Depth Charts, Weighted Means Spreadsheet, and PFM We've pushed two updates to the Depth Charts, Weighted Means Spreadsheet, and PFM this week. The first one was sent out late March 9. With this update, we attempted to address some of the issues people had noted with Depth Chart team statistics that Clay mentions in this post. While this might have made the team projections more satisfactory, it quickly became apparent that it did so at the expense of the individual player projections, which are what the vast majority of subscribers are using PECOTA for this time of year. If you downloaded a spreadsheet or ran PFM between the evening of March 9 and now, please do it again and use the individual player stats you get from the current data. As an aside, the modifications that were made to the March 9 data were more-or-less applied on a league-wide basis, so draft order and dollar value from the PFM probably won't change very much. The raw statistics that were predicted will be fairly different, though. This morning, we pushed out another update which puts things largely back to their previous state. The RMSE analysis above is run on this version of PECOTA. Depth charts will be updated at least every other weekday through the start of the season. Weighted Means versus Fiftieth Percentile Traditionally, PECOTA has used weighted means projections for it's default projections--the Depth Charts, PFM, Weighted Means Spreadsheet (obviously), and player cards have all used or highlighted the weighted means stat line. This year, we've been using the fiftieth percentile for these applications instead. Until recently, we haven't had the weighted means at all for PECOTA in 2010. We now have the weighted means in the cards--see the bottom row of the 2010 projections table--and the weighted means are being used for the ten-year projections in the cards. Everywhere else, though, we're sticking with the fiftieth percentile projections for now, so you'll see the projections in the fiftieth percentile line of the cards match the Depth Charts, PFM, and Weighted Means Spreadsheet (which I realize means the spreadsheet is now misnamed). We're working on the pitcher cards now. They'll be available next week.
Dave Pease is an author of Baseball Prospectus. Follow @davepease
130 comments have been left for this article. BP Comment Quick Links Cardinals645 (26292) When do you anticipate switching the Depth Charts, PFM, and Spreadsheet to Weighted Means? Al Skorupa (39403) Follow up: Will this be done? Should this be done? Why? We don't know. The weighted means (at least for 2009) have more bias than the fiftieth. We're going to have to look at it more closely. Mar 12, 2010 22:45 PM The data I have in hand right now says we won't. The 50 percentile data in the PFM already has a positive bias - projecting more singles, HR, BB, and runs than the 2009 major leagues did, on the order of 4%. I don't consider that to be a large problem - a forecast system that is optimized for individual elements isn't necessarily going to be an unbiased estimator of the system as a whole. Going to a weighted means forecast will double or, in some categories, triple those biases, into the 10-15% range, which is big enough for me to consider it a problem. And for those larger biases, you get no improvement in the individual errors - at least for 2008 and 2009. Mar 13, 2010 14:05 PM K Wilson (10398) Even if the weighted means seem more biased, I'd like to have access to a true weighted means spreadsheet. At the very least, I think you should change the name of the "Weighted Means Spreadsheet" to "Medians Spreadsheet" or something, so that it is not so misleading. Mike (54181) "Thanks for writing and for your support of Baseball Prospectus. mrharrier (35334) I wrote a long reply. It somehow got lost. Wozzyck (11638) Thanks for the update, though it still seems that there are issues with the PECOTA hitter cards that haven't been addressed. One is that several players have screwy things going on around the 90th percentile. Take Adam Jones for example. jpjazzman (32699) Even worse - We're looking at this. Thanks. Mar 12, 2010 18:22 PM BurrRutledge (18981) Dave, the PFM allows us to set "aggressive," "moderate," and "conservative" rankings. In the past I've selected "aggressive" because I want to draft players with the best chance to outperform. swarmee (40459) You're not using that setting correctly. That's supposed to be how aggressive the other owners are in the league. As in, if you're in a single-season league and Pujols goes for $55, you're in an aggressive league, $48 and you're in a moderate league, and $43 and you're in a conservative league, basically. BurrRutledge (18981) Seriously? What's the setting do in a straight draft? swarmee (40459) It just reapportions the dollar amounts to fit better in with your league. It really shouldn't change the order of players. BurrRutledge (18981) So funny. As long as I've been using the PFM I've thought it was some way to tweak the PFM to evaluate the players by a slightly higher percentile of their forecast. Sigh. hessshaun (41493) I never knew that either. The work instructions for that tool are horrible. I realize that those items can be helpful, but the tool burnt me as much as it saved me, two years in a row. I think it's more me sorting through PECOTA's biases than anything else. swarmee (40459) Disposition: allows the user to select from between a more conservative and a more aggressive approach when deriving dollar value calculations; the more aggressive approach places a higher value on the top players (e.g., "Stars & Scrubs") jrmayne (1468) There's an ongoing discussion in the Depth Charts, for those interested in the thoughts of some who have followed the updates. Some of us are skeptical. dianagram (9530) Dear BP, R.A.Wagman (32721) Question - why not include projections for all first rounders from last year? Why are guys like Dustin Ackley and Kyle Gibson excluded, while other rookies with zero pro experience like Stephen Strasburg and Jose Iglesias are projected? Wharton93 (23153) Should we be sending the books back to Amazon? Are THOSE Pecota numbers any good? I can't even tell anymore what's what. The season ended 5.5 months ago---that's a long time to have worked this all out. Hopefully somebody will spend the Summer fixing this. Many drafts are already over this year. we have included the projections printed in Baseball Prospectus 2010 as the second lines in the error reports above. Mar 12, 2010 18:17 PM Bob (24776) thanks for the update and for explaining the problems and the processes by which you are seeking to solve those problems. vtadave (11550) Don't hold your breath. Guesing no refund is forthcoming. BP has really lost no only my piddling respect this year, bt rsspect accross the fantasy landscape. There is no doubt thtat BP has some truly sharp minds behind the numbers/content, but the ball has been clearly dropped this year. Steven (5022) Sadly, I must agree that a refund seems unlikely. Dave has said that non-keeper leagues should not be an issue, but there's little more than "oops" for those of us in long-term sim leagues. ferret (20608) My two cents is this has been (and still is) a major disaster that will affect the BP brand very negatively. I would make a couple of suggestions for your consideration. They have been suggested previously but not acknowledged.... Jivas (649) "4. Make a big public apology." ccmonter (6231) I'd like the apology, but first of all I want the numbers. Let the team do their work. Let's get the numbers first and then we can worry about everyone's feelings. Shadetree42 (33584) Exactly. It is one thing to screw up massively. Quite another to flatly ignore your customers once it occurs [yes, remaining silent for 12 days after the problem was acknowledged counts as ignoring customers]. This has been a case study in how NOT to handle a significant problem encountered by a consumer-facing business. The increasingly apparent arrogance of BP is bordering on astounding at this point. I abjectly, completely apologize for the problems we have had with this process this year. Honestly, it kills me that we've had these issues. We so appreciate your support, and we want to bring you the best. Mar 12, 2010 20:42 PM Jivas (649) Thanks Dave. It really does help to have BP acknowledge the extent of the problem that is plainly evident to all of us. jrmayne (1468) I wouldn't mind a true-beta; one with some bugs here and there. But it simply has to be closer than every single release so far. brokeslowly (27699) Other readers have rated this comment below the viewing threshold. Click here to view anyway. I think that all the naysayers should lighten up. Progress is being made, and I'm betting that the projections available right now are up there with any in the business. BP is obviously trying hard to fix the problems. If you don't think that the non-PECOTA content of BP is worth your $40 for a year, either you're not a true baseball fan or you probably can't afford to dole out the money in the first place. jrmayne (1468) I'd note the comparisons appear designed to show the newer PECOTA is better. Shadetree42 (33584) All these points are valid, especially #1 and #2. It appears they used 2009 results both to create the new formula and to "test" its accuracy. That just doesn't work in any kind of forecasting business. Juris (1283) Not sure this is a valid criticism. I think the main thing BP has been trying to do with PECOTA this year is just to change the underlying technology from Excel to some other form of data base, while turning all of Nate's complicated macros into lines of code written in a totally different format. So it would be logical for them to see whether they come up with the 2009 PECOTAS that Nate developed, but this time using their new code. If they accurately "replicated" the 2009 PECOTAS using the new code, then they could feel reasonably confident that their translation from Excel to their new DB and code was a good one. Shadetree42 (33584) If they were simply interested in replicating the old PECOTA formula [which is what they *should* have done for this season], they would have simply compared the generated 2009 projections for each system on a player by player basis and noted the discrepancies. They clearly changed the way the algorithm works, and their post was an attempt to show that the new system is slightly better than the old one -- i.e., that the changes they implemented had some merit. It's a valid concept certainly. But the problem is, as a previous poster noted, that the sample size is tiny (one year) and they are using in-sample data to test the new algo. So the RMS error table for 2009 does not really establish anything meaningful. tbwhite (361) "With so many moving parts, it's really hard to know what went wrong." These are PECOTAs run with the current version of the system, but only the information available at the start of the '09 season. Mar 12, 2010 22:30 PM Shadetree42 (33584) Thanks for the info. I understand that it was not run with any explicit knowledge of the future, but was the new PECOTA system originally developed (optimized) using any data from the 2009 season? That has not been made clear yet. If I throw out the '09 data, I still get nearly identical RMSEs for old and new PECOTAs, looking at only '07 and '08. (The difference is .001.) Mar 12, 2010 22:47 PM jrmayne (1468) Colin: On number one, I agree, which is why I've added 2008 data to the mix and am in the process of adding 2007. Mar 13, 2010 13:53 PM If you really think that we're trying to pull the wool over your eyes by producing test results that we've massaged, or made 2009-specific changes only for the purpose of passing tests on 2009 data, please send me an email and I will refund your money. Mar 13, 2010 20:44 PM Shadetree42 (33584) It's not a question of "resorting to something like that." It's a much less sinister question of how best to test a new prediction algorithm. I (and others) have suggested that optimizing parameters on a data set (all past seasons), and then testing the algorithm's accuracy on a subset of that data, is not a valid approach. tbwhite (361) If for some reason you feel you MUST use 2009 data in training, at least randomly split your data in half or 60/40. Train on one piece and measure accuracy on the remaining group. But an accuracy test based on data you trained on is pretty close to worthless. The parent comment had as its lead 'the comparisons appear designed to show the newer PECOTA is better'. They weren't--they were what we had to publish. More coming. Mar 15, 2010 09:46 AM Juris (1283) I don't buy this. I think the main effort this year with PECOTA has been to translate the system to a new platform. PECOTA is very complex, probably more so than any other "systematic" forecaster that's out there. Shadetree42 (33584) It's unclear from this post whether 10-year projections for hitters have been fully "fixed" yet, but it doesn't look like it. Basically, most players are projected to remain stable or improve from mid/late-20s through age 35 or so. This is not a normal aging curve, and differs significantly from past long-term PECOTA forecasts. E.g., Dustin Pedroia's TAv taken from his latest 10-year forecast: Juris (1283) To illustrate why a relatively flat aging curve might not be wrong in many cases, but also why it is complicated to make multiyear projections, take a look at this article by Nate Silver: http://baseballprospectus.com/article.php?articleid=7189. Shadetree42 (33584) Valid point. I would still maintain that the age 30-to-35 curves look suspiciously flat this year compared to previous PECOTA iterations. The fact that there are 10-year projections instead of 7-year projections is probably also a factor. I have not done any systematic checks, just looked at a 15-20 players. stlpdx (47802) Other readers have rated this comment below the viewing threshold. Click here to view anyway. This 'update' is a whole lot of nothing. I am so tired of this shit. Brian Cartwright (4519) First, I had a hard time finding the 2010 projections. The 'Find a Player' box still takes you to 2009. Mike Juntunen (30924) It seems to me people are missing the implication here that Nate is not doing the PECOTA adjustments and tweaks as he has always done, probably because he's no longer really an active part of BP. Every year Nate has, in the mid-winter, posted his various PECOTA adjustments and new projects for the year. However, it's a lot easier for the designer to work on a project than it is for people, however brilliant, to pick up that project, learn it and improve it without breaking some things. BMoreGreen (50521) ~However, it's a lot easier for the designer to work on a project than it is for people, however brilliant, to pick up that project, learn it and improve it without breaking some things.~ deep64blue (33349) The old system didn't work - they had major problems last year, that wasn't an option. Mike Juntunen (30924) At least through 2008, PECOTA was a series of excel spreadsheets on Nate's computer. If Nate isn't in the picture, there's no way to make that transition pretty. dianagram (9530) "All we are saying ... is give Pease a chance." krissbeth (40802) To the torch-wielding mob: Does rotoworld's projections work better than PECOTA right now? I enjoy reading BP, but I want the best projections possible for my draft in two weeks. Which would you choose? BMoreGreen (50521) Geez, even as frustrated as I am with BP right now, it makes me feel a little dirty to consider posting more reliable sources ... but being raised Catholic, I guess can just head to confession for absolution at a later date - if warranted. zstine1 (32591) do any other sites have anything like PFM that is so customizable? BMoreGreen (50521) Nick J (23779) Last Player Picked yadenr (36923) Baseballnotebook.com is also a strong projection site. I've used them paired with PECOTA now with great success. Every system has its flaws and hangups. Get to know at least a couple of them and make your own call based on their biases. I don't mean to advert for a competitor, but it seems like you should have at least one more system that you are using in combination with BP. BN costs money but I've found it to be really valuable. BurrRutledge (18981) My fantasy 2010 analysis will still be 100% PECOTA-based, with a sprinkling of Marc Normandin insights to inform some of the more difficult drafting scenarios I'm likely to encounter. bflaff1 (54933) Krissbeth, surveyzas (119) as someone who's not involved in fantasy baseball, or uses the PECOTA projections for anything more than personal reference...i have to echo others' sentiments about how disappointing this roll-out has been. i'm mystified by the fact that this transition didn't fully undergo thorough QA testing before replacing the existing methodology to produce the data that is the foundation to the core product. danlbfaks (2044) I'm not a programmer and have generated "software" in Excel for Z-scores, regressions, projections, et cetera that could not have possibly amounted to 1/1000th the complexity of what Nate created and tweaked over the years. When I've handed my "software" to a programmer to translate it, they've often laughed at the silly complexity involved in using Excel to kludge the calculations. I imagine successfully converting Nate's work lies somewhere between flapping your arms to fly and blowing someone's head off with a thought. swarmee (40459) But whether or not the fantasy players want to use it, if the underlying projections are out-of-whack, it's still not completing its original purpose. If the data made sense (like 10% < 25% < 50% < 75% < 90% projections were all proper), then trying to adjust the weighting scales to better approximate the 2009 season makes sense. When the answers are still being ironed out 5 months after the season ended, it's obvious that the work isn't being checked in house and solved in house. Clonod (35609) I buy BP for the articles, but if I bought a fantasy subscription this year, I'd be seriously irked. Drafts are already taking place, and this stuff is still buggy? leites (17240) Let me just say I would buy a BP subscription just to read Kevin Goldstein's prospect analysis -- for me, PECOTA is just a bonus. Joe D. (3692) Age 22 seasons leites (17240) Another comp example: Matt Wieters' top comps are John Christensen, Jarrod Saltalamacchia, Sid Bream, and Steve Decker. Looking at these, and Everth Cabrera's, I'm no longer sure the comp listings have any value whatsoever. (Of course, if Cabrera turns out to be a Hall of Fame player . . .) gluckschmerz (20110) I was kinda disappoint that PECOTA wasn't up to snuff when I had my draft last weekend. AND I think BP should have been more upfront about things A LOT earlier. It just seemed like I expected BP people to more forthright about all this PECOTA stuff. Why keep pretending? coonscrape (50234) Other readers have rated this comment below the viewing threshold. Click here to view anyway. We have an opening in our 5x5 roto auction fantasy league to anyone who will pay $40.oo for Jose Reyes DBA (14224) Allow me to join the angry mob here. I'll reiterate what's been said above - the BP brand has been severely, if not permanently, impaired. bflaff1 (54933) "The reality is, the product you are offering for a price is inferior to those being offered elsewhere for free." To follow up on this--I'm not much of a natural marketer, but the reason we haven't been more forthcoming about serious issues in the 2010 projections is that we're not aware of any serious issues in the 2010 projections. Seriously. Mar 13, 2010 21:37 PM redspid (20166) This is key. Pecota has some drawbacks, but if you know them from previous years, you can adjust. The 2010 projections should be fine. dianagram (9530) I have $5 that says Adam Jones outperforms Nate McLouth in every category this season, contrary to PECOTA's projection. NewStadiumInsider (34058) Other readers have rated this comment below the viewing threshold. Click here to view anyway. At this point I'd like a refund so I can take my $20 back and pay for Bloomberg Sports' draft kit. Is it too late for that? Nathan J. Miller (10465) I wouldn't. I've been pretty unimpressed with the Bloomberg. dianagram (9530) I haven't found any way to print ANYTHING I've seen on the Bloomberg site ... NewStadiumInsider (34058) As follow-up to this, I tried out Bloomberg Sports and was very unhappy with the product. They focused way too much on a fancy design, and it wasn't as customizable as I would have hoped for it to be. zstine1 (32591) i think toyota has taken less flak than BP has this spring. whoami1219 (45036) Well, lets remember the countless number of deaths caused by an inaccurate Pecota. Shame on you BP! SHAME! mrharrier (35334) I've asked this question previously in ways that haven't generated positive responses -- so now I'll ask it in a positive way. Could anyone please provide some insight into the characteristics of Nate McLouth that would lead him to be ranked by BP as one of the top players for the coming year, though other prognosticators differ on this point? Is there something about his BABIP data, his expected walk rates, an age-fueled increase in AVG, or anything else that is making PECOTA particularly optimistic about his expected production? Michael Bodell (89) I think this idea in general is a good one for an article. Take a bunch of other projection systems (CHONE, Marcel, Zips, Bill James, fans, etc.) and look for players where PECOTA is way above or way below the average of the other group (maybe where OPS is >5% different?) and try to explain what is making PECOTA feel this about a player and why the BP author thinks PECOTA is right (or wrong!). I think that would make for a great and interesting read. Bob (24776) Nate Silver used to do this with prospects. He'd compare the Baseball America prospects with those hyped by PECOTA, exploring particularly the players that one and not the other system thought predicted would be good. It was very interesting and he wasn't afraid to concede that PECOTA has its limitations. bflaff1 (54933) mrharrier, braden23 (26308) Aren't good fantasy owners supposed to look at projections, add in their own conclusions and make their calls accordingly? Before all this noise, I had my PFM set to my league rules, and I draft according to the projections and my assessment on which ones I am on board with and which ones I am not. R.A.Wagman (32721) Amen. One of the most commendable points about BP, is that it is for the thinking fan. If we accept projections blindly, we're not really thinking, are we? NotMrTibbs (55448) Other readers have rated this comment below the viewing threshold. Click here to view anyway. I'll respond to this comment for $40. Clonod (35609) If people didn't buy fantasy subscriptions to this site, I'd be with you. BP makes money on PECOTA having a reputation as more reliable and thorough than other projection systems. That's just a fact. Richie (27368) I will make one suggestion. Either: tbwhite (361) So, how exactly are the "2010 Projections" done that are in the box at the top of the box on the player cards page ? I see that it's the Median rate stats, but they are applied to more PA's ? Where does the PA number come from ? If a player has a depth chart playing time estimate, we use that. If not, we use the PECOTA projected playing time. We thought this would be the best solution, but it is confusing and we haven't figured out how to make it less so. Mar 14, 2010 12:33 PM tbwhite (361) How about using the PECOTA percentile projection that matched your depth chart playing time. PECOTA says the better a guys plays the more he plays. So, if you are projecting that a guy who has never started regularly before will get 600 PA's, it seems logical that you are also assuming the he will play well. Few players could play at their 10th percentile level while simultaneously establishing themselves as regulars. Nailfan (3486) Dave, Clay Davenport will be updating the playing time projections every other day through the start of the season. Keep in mind he's doing it based on his guesstimates of how much playing time each player will get throughout the course of the season--that means he might be allocating considerable playing time to a player who isn't slated to start, if he thinks the guy who is starting the season at that position isn't up to the job and won't last long. Mar 14, 2010 14:46 PM vtadave (11550) Regarding the issues with PECOTA this year, I clearly overreacted in this threat and for that, I offer my humble apologies. gluckschmerz (20110) I do need to say this, I will not be renewing for a number of reasons: No reliable PECOTA (the silence surrounding the PECOTA issue puzzles and disappoints), no Sheehan, poor customer service, and articles and analyisis which seem to me to be strewn with grammatical, stylistic and most probably mathematical/statistical errors. Steven (5022) I tend to agree. BP is behaving like an organization that is past its prime. I see marketing outreach (with them cited on MLB network and the like), but no customer service/support to back it up. Ira (1386) On Friday, I openned up the latest update to the Depth Charts and was immediately very upset. The more I look at it, the more upset I get, too. I'm not much of a fantasy player, so its not just the consistency aspect to it. No, what bothers me is that the Texas Rangers managed to magically lose 50 runs of offense during spring training. They lost this by losing a big chunk of their power, and this came from decreased power output from their main power hitters. D1Johnson (40738) Regarding Jose Reyes, I just noticed that the 2010 projections appearing at the top of the beta card do not match the weighted mean under the 2010 Forecast further down the sheet, nor is it close. makewayhomer (31413) Re: PFM and 50th percentile projections - I still don't see a perfect fit. Bodhizefa (36436) No mention of the massive changes in projection to players like Alex Rodriguez, Mark Teixeira, Chris Davis and others this go-round? jrmayne (1468) I made some comments in the depth charts. It's a little difficult to suss out why there are differences in the projections from various PECOTA sources (two spreadsheets differ, which differ from listed projection, which differ from 50th percentile.) Integer rounding explains a lot of it, but I don't think all of it. Weighted means appear to still be miscalced. Big differences (like Andy Marte's slugging) between projection and 50th percentile are undesirable. Mike (54181) There is a pretty interesting discussion regarding this year's PECOTA's over at Tom Tango's site, Inside The Book. The discussion can be found in the comments section of the March 3rd, "Weiters II" blog post. (I won't provide the link, but it should be easy enough to find). Mike (54181) Oh, and I don't know if this is by design, but this post no longer shows up in the Unfiltered Archives. For some reason the most recent posts that appear are from March 3rd and earlier. Jquinton82 (54222) Not to be THAT GUY, bc I know you guys are working hard trying to fix this... but when can we expect the cards for pitchers? (relatively soon, 2 months from now, not for quite a while?)... I ask bc this is my first time as a subscriber and genuinely have no clue what to expect in terms of time frame on all this.... honestly just curious. Not a subscriber? Sign up today!
|
Thanks for the update!
Is there a way for you to footnote new additions/eliminations to the PFM/Depth Charts/Weighted Means (in terms of players added/removed)?
It would make it easier to match up prior iterations which have been transferred into spreadsheets.