Editing Talk:2180: Spreadsheets
Please sign your posts with ~~~~ |
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 5: | Line 5: | ||
My unofficial job title is the Head of the Department for Extreme Spreadsheeting. There are multiple reasons for this, including that we need to share info easily across different offices, I'm very familiar with spreadsheet formulas, and I have no f***ing clue how to get a SQL database functioning properly. [[User:Misterblu28|Misterblu28]] ([[User talk:Misterblu28|talk]]) 21:48, 24 July 2019 (UTC)misterblue28 | My unofficial job title is the Head of the Department for Extreme Spreadsheeting. There are multiple reasons for this, including that we need to share info easily across different offices, I'm very familiar with spreadsheet formulas, and I have no f***ing clue how to get a SQL database functioning properly. [[User:Misterblu28|Misterblu28]] ([[User talk:Misterblu28|talk]]) 21:48, 24 July 2019 (UTC)misterblue28 | ||
: It involves chickens, black candles, a full moon, and one of those fancy space-age pens that can write on any surface. | : It involves chickens, black candles, a full moon, and one of those fancy space-age pens that can write on any surface. | ||
− | |||
The "devil" is clearly a reference to the FreeBSD daemon mascot. [[Special:Contributions/172.68.38.64|172.68.38.64]] 04:42, 25 July 2019 (UTC) | The "devil" is clearly a reference to the FreeBSD daemon mascot. [[Special:Contributions/172.68.38.64|172.68.38.64]] 04:42, 25 July 2019 (UTC) | ||
Line 24: | Line 23: | ||
My goto functions tend to be LOOKUP() (or HLOOOKUP() and VLOOKUP() for various subtelties like matching unsorted arrays), LEFT(), RIGHT(), MIDDLE(), COUNTA(), COUNTIF() (especially for range A$1:A''current_or_preceding_row_number_for_this_cell'' to establish "this is the ''n''th example of some quality in this column", usually for firstness), FIND(), ISERR(), ISNUMBER(), SUBSTITUTE(), and of course loads and loads of IF()s, ...usually heavily nested. And at least these days Open/LibreOffice accept comma seperation of function params, 'cos forgwtting I'm not in Excel and not using semicolons in such a scratch-built monstrosity leading to an error that ''wasn't'' bad logic or nesting was a bummer, until I realised... [[Special:Contributions/141.101.98.148|141.101.98.148]] 20:56, 25 July 2019 (UTC) | My goto functions tend to be LOOKUP() (or HLOOOKUP() and VLOOKUP() for various subtelties like matching unsorted arrays), LEFT(), RIGHT(), MIDDLE(), COUNTA(), COUNTIF() (especially for range A$1:A''current_or_preceding_row_number_for_this_cell'' to establish "this is the ''n''th example of some quality in this column", usually for firstness), FIND(), ISERR(), ISNUMBER(), SUBSTITUTE(), and of course loads and loads of IF()s, ...usually heavily nested. And at least these days Open/LibreOffice accept comma seperation of function params, 'cos forgwtting I'm not in Excel and not using semicolons in such a scratch-built monstrosity leading to an error that ''wasn't'' bad logic or nesting was a bummer, until I realised... [[Special:Contributions/141.101.98.148|141.101.98.148]] 20:56, 25 July 2019 (UTC) | ||
− | I was hoping the explanation would say what those named functions do, LOL! Never used Google Sheets. But I've used the hell out of Excel. Can't imagine how a single cell could display a calendar, but I've often done a quick on-the-fly calendar where each cell is a day... Usually to check what weekdays certain days are. Like "What weekday was I born?". Often I designate one cell as a starting date, the first row uses the WEEKDAY function to check "Is that this weekday, an earlier weekday or a later weekday?". A later weekday, leave it blank. An earlier weekday, take yesterday and add one. This weekday, show it. Then Week 2, Sunday is Saturday + 1, Monday is Sunday + 1, etc. Copy / Paste to finish the week, Copy / Paste the week to finish the calendar. I change the cell formatting to show only the Day of the date, but each cell stores an entire date. And the 8th column shows the month every time the month changes (usually a VLOOKUP on a reference table I make with Fill Series). I can then just change the master cell to change what date range the calendar shows. I might use Excel the most for mass renaming files | + | I was hoping the explanation would say what those named functions do, LOL! Never used Google Sheets. But I've used the hell out of Excel. Can't imagine how a single cell could display a calendar, but I've often done a quick on-the-fly calendar where each cell is a day... Usually to check what weekdays certain days are. Like "What weekday was I born?". Often I designate one cell as a starting date, the first row uses the WEEKDAY function to check "Is that this weekday, an earlier weekday or a later weekday?". A later weekday, leave it blank. An earlier weekday, take yesterday and add one. This weekday, show it. Then Week 2, Sunday is Saturday + 1, Monday is Sunday + 1, etc. Copy / Paste to finish the week, Copy / Paste the week to finish the calendar. I change the cell formatting to show only the Day of the date, but each cell stores an entire date. And the 8th column shows the month every time the month changes (usually a VLOOKUP on a reference table I make with Fill Series). I can then just change the master cell to change what date range the calendar shows. I might use Excel the most for mass renaming files. :) [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 04:24, 26 July 2019 (UTC) |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |