Talk:Warming stripes#spreadsheet

File:Information.svg

An editor has asked for a discussion to address the redirect Stripe diagram. Please participate in the redirect discussion if you wish to do so. _signed, Rosguill ^talk 18:13, 8 August 2019 (UTC)

File:20181204 Warming stripes (global, WMO, 1850-2018) - Climate Lab Book (Ed Hawkins).svg

I've just learned that this image was chosen as a Featured picture. See:

• Wikipedia:Featured picture candidates/Warming stripes
• https://web.archive.org/web/20210118015423/https://en.wikipedia.org/wiki/Wikipedia:Featured_pictures#Sciences
• https://web.archive.org/web/20210119171614/https://en.wikipedia.org/wiki/Wikipedia:Featured_pictures_thumbs/69
• https://web.archive.org/web/20210124042712/https://en.wikipedia.org/wiki/Wikipedia:Featured_pictures/Sciences/Others

:—RCraig09 (talk) 17:23, 19 January 2021 (UTC)

{{clear}}

{{anchor|xlsx|spreadsheet|Spreadsheet}}

{{collapse top |title=Click at right to show/hide preliminary comments }}

I've written a Microsoft Excel .xlsx spreadsheet file that semi-automates generation of SVG files of warming stripes graphics, so you don't have to buy really expensive software. You simply paste a vertical list of temperatures or other data. The spreadsheet automatically generates a column of cells containing xml code, each cell representing one "stripe" per cell. Simply copy that column and paste it into a text editor (TextEdit for Mac, presumably Notepad for Windows), and save the text file as {{code|filename.svg}}". Notes:

• SVG filesize for a 171-point dataset is only about 9 Kbytes (file is "from scratch"; not generated by Inkscape etc.)
• I've pre-programmed the colors to be the ones that warming stripes originator Ed Hawkins has used: 8 blue and 8 red colors. You can change them manually, in a conversion/translation table on the right side of the spreadsheet.
• For flexibility over time, I include a cell that allows you to designate how many degrees are covered by each color (normally 0.10°C to 0.15°C per color). Enter larger numbers for datasets that span larger temperature ranges, so that colors remain in range of the sixteen colors. Data that exceed the most extreme color are truncated by the conversion/translation table to the most extreme color.
• Per Ed Hawkins' early works, the boundary temperature between blue and red is 0.0 in the data column, corresponding to the average temperature over the reference period. If you want a different blue-red boundary temperature, offset your dataset up or down accordingly.
• I initially (3 Feb 2021, Version 1) set the aspect ratio to be very close to 16:9, specifically 855x480 pixels, with each of the 171 stripes being 5 pixels wide (855/171=5). In Version 2 (below), you specify width and height (in pixels) and number of data points (=number of stripes).
• Included instructions for Version 1 are:

1. Paste/Enter temperature anomaly data into "dT" column
2. If needed, change " ° per colour" choice above (to keep stripes within colour ranges)
3. Copy blue-shaded cells, paste into text file, and save as ".svg" file

• You can click this [https://www.dropbox.com/scl/fi/vk30q5is9xvwerfiq6rb5/20210203-Warming-Stripes-XLSX-to-SVG-CONVERSION.xlsx?dl=0&rlkey=v63lm8qdtx2vz333goxntwulu v1 Dropbox link] to download Version 1 of the .xlsx spreadsheet (though it's smarter to use Version 2.x, below).

• Much of this collapsed text is preliminary and obsolete. See User:RCraig09/Excel to XML for SVG for my most current documentation. —RCraig09 (talk) 17:13, 4 November 2023 (UTC)

{{collapse bottom}}

Update:

{{User:RCraig09/Excel to XML for SVG}}

Examples (warming stripes):

{{User:RCraig09/Warming stripes in shapes}}

{{clear}}

:That is cool! I had no idea that this was possible. Is it possible to automate updating [https://en.wikipedia.org/wiki/Instrumental_temperature_record#/media/File:20200324_Global_average_temperature_-_NASA-GISS_HadCrut_NOAA_Japan_BerkeleyE.svg your collection of instrumental data sets] with this? (There is a new version out for HadCRUT, finally agreeing with all the other data sets by not ignoring the poles). FemkeMilene (talk) 08:41, 20 February 2021 (UTC)

::(on design: black title and text is calmer). FemkeMilene (talk) 08:42, 20 February 2021 (UTC)

::: {{reply|Femkemilene}}

:::# Oh, it's possible! But spreadsheets are clumsy tools for some tasks. I had to catenate text strings and calculated-numbers to create the XML elements.

:::# Re 5-trace graphs: people who understand a little XML can separately make five unique .SVG files, and then copy the main 'path' text from four svg files into the fifth svg file (using the fifth file's plot area and grid lines etc).

:::# To quickly generate 5-trace graphics within the spreadsheet, it would require almost about 22 columns to generate each trace. It would add a bit of complication for the user, also. Version 1.0 was meant for people who basically understand spreadsheets but don't know SVG or Inkscape etc. I plan to update the 5-trace GST graphic manually , in Inkscape, when all 2020 data is in.

:::# I used blue for experimentation... and forgot to change to all black characters! D'oh! I will change in future versions. —RCraig09 (talk) 22:52, 20 February 2021 (UTC)

::: {{reply|Femkemilene}} I am now adding to the spreadsheet, to expand to more than one trace. (At first I was intimidated by the project. :-) ) —RCraig09 (talk) 04:48, 21 February 2021 (UTC)

:::: Brilliant! I wish we could fully automate loads of those graphs and this is a step on the right direction :). FemkeMilene (talk) 08:07, 21 February 2021 (UTC)

::::: {{reply|Femkemilene}} Version 2.x is uploaded to Dropbox (link is above). Upgrading to five traces was more straightforward than I feared (though time-consuming!). Five actual temperature data series are included in the v2.x example. I haven't decided how to position five text legends for five traces, since different users will want them in different positions for different datasets. But this is a start.

::::: Spreadsheets are relatively simple for non-techy people to use, but they aren't as flexible as Inkscape etc. Maybe User:Efbrazil can share how he semi-automated making his SVG files. —RCraig09 (talk) 23:07, 21 February 2021 (UTC)

:::::: {{reply|Femkemilene}} I've updated the five-trace .svg graph (at right) with 2020 data and used the spreadsheet to generate the XML code. The only pre-processing needed in this case is to adjust some of the data sets to account for different base/reference periods. Spreadsheet Version 2.2 allows you to choose which 'quadrant' in which to put legends, to accommodate differently shaped graphs. —RCraig09 (talk) 07:54, 25 February 2021 (UTC)

{{od}}

File:20241229 Using concatenate function in spreadsheet to create SVG code - demo.svg

Update (2024): The downloadable spreadsheets are on Google Drive (drive.google.com); download link is updated above. I've just added the chart at right, which shows an example of using the spreadsheet's concatenate function ("&") to assemble text and values into XML code for the SVG files. It's not necessary for users of the spreadsheet to understand the internal details; the spreadsheet itself does the dirty work. —RCraig09 (talk) 20:46, 30 December 2024 (UTC)

{{clear}}

Hello! This is to let editors know that :File:20181204 Warming_stripes_(global,_WMO,_1850-2018)_-_Climate_Lab_Book_(Ed_Hawkins).png, a featured picture used in this article, has been selected as the English Wikipedia's picture of the day (POTD) for November 3, 2023. A preview of the POTD is displayed below and can be edited at Template:POTD/2023-11-03. For the greater benefit of readers, any potential improvements or maintenance that could benefit the quality of this article should be done before its scheduled appearance on the Main Page. If you have any concerns, please place a message at Wikipedia talk:Picture of the day. Thank you!  — Amakuru (talk) 16:14, 27 October 2023 (UTC)

: Here is a link to an archive of Wikipedia's front page early on 3 November 2023: https://web.archive.org/web/20231103104846/https://en.wikipedia.org/wiki/Main_Page . —RCraig09 (talk) 06:01, 4 November 2023 (UTC)

Hello ! I would like to promote Warming Stripes as featured picture in Commons ! Could you come and vote for it ? Effco (talk) 15:33, 4 November 2023 (UTC)

: {{done}} I don't know anything about the decision and implementation process, however. —RCraig09 (talk) 16:02, 4 November 2023 (UTC)

:: Update: The image has [https://commons.wikimedia.org/w/index.php?title=Commons:Featured_picture_candidates/File:20181204_Warming_stripes_(global,_WMO,_1850-2018)_-_Climate_Lab_Book_(Ed_Hawkins).svg&curid=140083783&diff=821383197&oldid=821367905 passed] the nomination process at Wikimedia Commons and will be included in Commons' [https://commons.wikimedia.org/wiki/Commons:Featured_pictures/Non-photographic_media/Computer-generated Featured Picture Gallery]. I don't know if or when it will be featured on the Commons front page. —RCraig09 (talk) 18:33, 13 November 2023 (UTC)

;Primary source:

: https://elliehighwood.com/2017/06/12/climatechangecrochet-the-global-warming-blanket/

; Secondary source:

: https://www.bbc.com/future/article/20231206-the-coloured-stripes-that-explain-climate-change

Uwappa (talk) 09:39, 11 December 2023 (UTC)

:: Thanks User:Uwappa, I also noticed the BBC article in the morning news. I've incorporated its summary teachings into this article, to introduce the numerous existing examples in the /* Applications and influence */ section. You may be aware, primary sources have limited acceptability on Wikipedia, and Ellie Highwood's contribution is already described in the /* Background, publication and content */ section; this is why I haven't added her blog post to the references. —RCraig09 (talk) 23:14, 11 December 2023 (UTC)