File talk:Brent Spot monthly.svg
It would be nice to have an update soon. Recent price drops have turned the price increase into a sharp peak, changing the nature of the graph; this should be reflected. Just my 2 cents :-)
Updating this graph[編集]
I'd love to update this graph - I see it hasn't been touched for nearly 2 years. I also see that the price of Brent Crude is back up to $91.45/b, which is significant. It's the US Consumer price index that has me stuck. TomTheHand says that web page is 'not a direct link; you'll have to query it yourself'. Query what? I can't make head nor tail of that page. There are two other points that worry me:
- I see that for the first (nominal) graph, Tom has kindly scaled the SVG so that adding new data is easy. But how did he do the inflation adjusted one? Every figure is scaled by some inflation figure for that month, so that the last month comes out unscaled. To add extra months in that way, every previous figure has to be adjusted! Tom must have had some terrific spreadsheet set up, but unfortunately that is not available to us now. I'm temped to leave the whole graph adjusted to March 2009 US dollars and just scale the new figures. But that assumes I know how to find anything on that web page we have to 'query'. There I am totally unable to help.
- I see that this graph is used on 15 different language wikipedias. What evidence do we have that any of these countries are interested in US urban consumer inflation? None I think. How about if we just remove the US-inflation-adjusted graph and maintain the other, easy, one? Maybe a compromise would be to leave that graph in place but only extend the unadjusted one from 2009 - 2011? The problem there is that that might be misleading, as the viewer might be tempted to believe that the two graphs remain superimposed, and that there hasn't been any US inflation for two years.
No one has ever responded to a single thing I ever wrote on Commons, so I assume nothing will happen. If anyone wants to get my attention, maybe leave a message on my en.wikipedia talk page (same user name, watch capitalisation). --Nigelj (talk) 17:25, 4 February 2011 (UTC)
- Well, I managed to update it. Properly with no compromises. Lots of spreadsheet work. And I also rationalised some of the styling (but it seems that Wikimedia's built-in SVG-PNG software is not as good at reading some of that as my 'Eye of GNOME 2.30.0'. I'll try and tweak it to match the built-in software's limitations as I do other updates. --Nigelj (talk) 20:57, 4 February 2011 (UTC)
Calculation spreadsheet[編集]
I have been asked for a copy of the spreadsheet that I used to update this graph. It is a .ods spreadsheet document, with formulas for calculation and then to format the figures into SVG path attribute text. I don't know how to upload that here. Here is tabulation of the first few rows. I have added the 1,2,3... and A,B,C... for the rows and columns that the spreadsheet software provides.
| A | B | C | D | E | F | G | |
| 1 | Month | US RPI | RBRTE | Price adjusted | Integer | Formatted SVG
(raw price) "Brent_Nominal" |
Formatted SVG
(adjusted) "Brent_Real" |
|---|---|---|---|---|---|---|---|
| 2 | May 1987 | 113.1 | 18.58 | 38.140 | 0 | M 0 18.58 | M 0 38.140 |
| 3 | Jun 1987 | 113.5 | 18.86 | 38.578 | 1 | L 1 18.86 | L 1 38.578 |
| 4 | Jul 1987 | 113.8 | 19.86 | 40.517 | 2 | 2 19.86 | 2 40.517 |
| 5 | Aug 1987 | 114.4 | 18.98 | 38.518 | 3 | 3 18.98 | 3 38.518 |
| 6 | Sep 1987 | 115 | 18.31 | 36.965 | 4 | 4 18.31 | 4 36.965 |
- The formula in the first cell of column D is
=C2 * (B$311/B2)(there were 311 rows in the last version I made) - The formulae in the first three cells of column F are
="M " & E2 & " " & TEXT(C2, "0.00")="L " & E3 & " " & TEXT(C3, "0.00")=E4 & " " & TEXT(C4, "0.00")
- The formula in the first cell of column G is
="M " & E2 & " " & TEXT(D2, "0.000"), and the pattern follows that in F.
I hope this is helpful. Please feel free to ask for more details. --Nigelj (トーク) 18:04, 2 November 2014 (UTC)
