[01:47:15] [discord] Next Miraheze venture: Miraheze Mastodon install, available for all MH users \:P [01:47:29] [discord] Available soon on social.miraheze.org [01:49:26] [discord] unfortunately located on db141 [01:50:26] [discord] Actually its hosted on my laptop 😏 [01:52:19] [discord] delayed indefinitely [01:52:45] [discord] oh yeah, doesn't Miraheze have a Mastodon account? [01:52:50] [discord] aye [02:14:52] Yeah I created us an account just in case we ended up needing to switch to something that isn’t twitter [02:15:27] Don’t think there is a tweetdeck equivalent for mastodon though [05:19:42] i'm so tired ugh it's been a long week [05:19:42] just had the flu [05:19:51] got the flu shot and everything, still 104 fever [05:19:54] *sigh* [07:26:35] [discord] extremely random thing that I imagine somebody here might know about. In Google Sheets, is there *any way* for a formula to calculate a single time, then replace the cell value with the static value from the formula? [07:28:23] [discord] i.e. formula calculates once, then the cell value never changes again [11:43:17] [discord] my honest reaction [11:43:29] [discord] hi [12:33:35] [discord] Was that in response to my wiki? [12:34:15] [discord] no, it was at user above, his messages got deleted [12:34:29] [discord] Ah. [12:40:47] [discord] Is a world building community looking for a new member? 😋 [12:41:49] [discord] there are a few I believe [12:41:57] [discord] unsure which are putting themselves forward at this time though [12:46:04] [discord] I'm just getting bored unable to continue own project. I have no other hobbies so I'm been working offline ever since the server went down. Been working on the project for about 4 or 5 a day since late September. Sucks to have your special interest removed like that. I'm not not doing so hot lately, with the whole depression thing. [12:46:08] [discord] I'm just getting bored unable to continue own project. I have no other hobbies so I'm been working offline ever since the server went down. Been working on the project for about 4 or 5 a day since late September. [12:46:09] [discord] Sucks to have your special interest removed like that. I'm not not doing so hot lately, with the whole depression thing. (edited) [12:46:13] [discord] I'm just getting bored unable to continue own project. I have no other hobbies so I'm been working offline ever since the server went down. Been working on the project for about 4 or 5 a day since late September. [12:46:13] [discord] [12:46:15] [discord] Sucks to have your special interest removed like that. I'm not not doing so hot lately, with the whole depression thing. (edited) [12:46:34] [discord] Getting desperate 😅 [12:46:46] [discord] Getting desperate 🥲 (edited) [12:49:24] [discord] Sorry for that [12:50:43] [discord] no need to be sorry, in this case a useful gazetteer of wikis would come in handy but that function is at best incomplete and not too reliable [12:57:18] [discord] I'll manage, I'm just worried because I have nothing backed up. besides the pictures. I joined the project because I forget things quite fact so I wanted to write all down and chat with people while working on it. [12:57:19] [discord] My potato brain is in mix of panic mode and ignoring the situation. So my brain is in constant conflict. I'm clearly not stable the last few weeks. 🥔 🧠 [12:57:34] [discord] I'll manage, I'm just worried because I have nothing backed up. besides the pictures. I joined the project because I forget things quite fast so I wanted to write all down and chat with people while working on it. [12:57:34] [discord] My potato brain is in mix of panic mode and ignoring the situation. So my brain is in constant conflict. I'm clearly not stable the last few weeks. 🥔 🧠 (edited) [13:33:02] [discord] I'm glad I didn't delete my old wiki. 😅 [23:52:18] [discord] I don't use Google sheets but Microsoft Excel. I learnt they use almost the same formats [23:52:41] [discord] So it all depends on what formula and what you're calculating [23:53:41] [discord] I don't know of anything offhand that's essentially a calculate-once self-destructive formula... but you can always fill a column, highlight and copy, then right click and do 'paste values [23:53:45] [discord] I don't know of anything offhand that's essentially a calculate-once self-destructive formula... but you can always fill a column, highlight and copy, then right click and do 'paste values' (edited) [23:54:02] [discord] That essentially duplicates a column w/ static values instead of the formula [23:54:25] [discord] I don't know of anything offhand that's essentially a calculate-once self-destructive formula... but you can always fill a column w/ formula, highlight and copy, then right click in a new column and do 'paste values' (edited) [23:54:43] [discord] I don't know of anything offhand that's essentially a calculate-once self-destructive formula... but you can always fill a column w/ formula, highlight and copy, then right click in a new column and do 'paste values' (exact language varies based on spreadsheet tool) (edited) [23:55:03] [discord] That manually duplicates a column w/ static values instead of the formula (edited)