https://thechange.wiki/index.php?action=history&feed=atom&title=the_change_wiki%3ACalculator%2FFeature_requests%2FSpreadsheets 2026-09-23T03:18:28Z Revision history for this page on the wiki MediaWiki 1.41.0 https://thechange.wiki/index.php?title=the_change_wiki:Calculator/Feature_requests/Spreadsheets&diff=1622&oldid=prev 2023-10-17T18:50:03Z

<p>Elie moved page <a href="/index.php?title=Wiki_for_a_better_world:Calculator/feature_requests/spreadsheets&amp;action=edit&amp;redlink=1" class="new" title="Wiki for a better world:Calculator/feature requests/spreadsheets (page does not exist)">Wiki for a better world:Calculator/feature requests/spreadsheets</a> to <a href="/index.php?title=Wiki_for_a_better_world:Calculator/Feature_requests/Spreadsheets&amp;action=edit&amp;redlink=1" class="new" title="Wiki for a better world:Calculator/Feature requests/Spreadsheets (page does not exist)">Wiki for a better world:Calculator/Feature requests/Spreadsheets</a> without leaving a redirect: we capitalizing subpages now</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 14:50, 17 October 2023</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Elie https://thechange.wiki/index.php?title=the_change_wiki:Calculator/Feature_requests/Spreadsheets&diff=1281&oldid=prev 2023-05-20T22:43:45Z

<p><span dir="auto"><span class="autocomment">Use-cases</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:43, 20 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l23">Line 23:</td> <td colspan="2" class="diff-lineno">Line 23:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Solar panel minerals]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Solar panel minerals]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Minerals/table]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Minerals/table]]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [[Energy demand]]</ins></div></td></tr> </table>

Elie https://thechange.wiki/index.php?title=the_change_wiki:Calculator/Feature_requests/Spreadsheets&diff=1221&oldid=prev 2023-05-17T21:58:34Z

<p>Created page with &quot;So, combine the calculations with tables, huh? Congratulations, u just re-invented the &#039;&#039;&#039;spreadsheet&#039;&#039;&#039; lol Ok but seriously, we can&#039;t use any existing spreadsheet software because none of the calculations work with &#039;&#039;units&#039;&#039;. Also I really don&#039;t have time to build a full-featured spreadsheet web app from scratch. ==Design idea== Quick design, off the top of my head; this probably has some flaws that still need to be worked out, but: * Just like a normal wikitable, b...&quot;</p> <p><b>New page</b></p><div>So, combine the calculations with tables, huh? Congratulations, u just re-invented the '''spreadsheet''' lol<br /> <br /> Ok but seriously, we can't use any existing spreadsheet software because none of the calculations work with ''units''.<br /> <br /> Also I really don't have time to build a full-featured spreadsheet web app from scratch.<br /> <br /> ==Design idea==<br /> Quick design, off the top of my head; this probably has some flaws that still need to be worked out, but:<br /> * Just like a normal wikitable, but each cell has an option to act as a datapoint<br /> * Just like a datapoint, the cell can be given an identifier, value, description and note.<br /> * Same identifier can be used in multiple cells, to reference the same data<br /> * Cell shows its value by default (monospace font, maybe green background idk)<br /> * Hovering or clicking the cell will reveal its id, description, note.<br /> ** Need to decide on a UI behavior. Has to work on mobile too (in other words, usable with no mouse hover)<br /> * For datapoints that are calculated from other datapoints:<br /> ** The 'value' should be the equation.<br /> *** But also, the 'value' showed by default in the cell should be the result.<br /> ** There needs to be a fifth parameter of the cell: &quot;units wanted&quot;.<br /> ** Design decision: should there be a distinction between these calculated datapoints vs &quot;primary&quot; datapoints? On one hand, their behavior is different, right? On the other hand, &quot;primary&quot; datapoints already can still reference other &quot;primary&quot; datapoints. So what's the simplest way to go about this?<br /> <br /> ==Use-cases==<br /> Here are some pages that could benefit from these kinds of spreadsheets:<br /> * [[Solar panel minerals]]<br /> * [[Minerals/table]]</div>

Elie