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 26: | Line 26: | ||
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 though. :) [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 04:24, 26 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 though. :) [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 04:24, 26 July 2019 (UTC) | ||
::excel to rename files? How very Rube Goldberg. Windows still includes shell batch commands (.bat files) for that kind of functionality.[[Special:Contributions/162.158.246.82|162.158.246.82]] 14:44, 27 July 2019 (UTC) | ::excel to rename files? How very Rube Goldberg. Windows still includes shell batch commands (.bat files) for that kind of functionality.[[Special:Contributions/162.158.246.82|162.158.246.82]] 14:44, 27 July 2019 (UTC) | ||
− | |||
− | |||
Something about the display is bugged out. [[Special:Contributions/162.158.107.67|162.158.107.67]] 05:43, 26 July 2019 (UTC) | Something about the display is bugged out. [[Special:Contributions/162.158.107.67|162.158.107.67]] 05:43, 26 July 2019 (UTC) | ||
Line 34: | Line 32: | ||
I find this comic to be an accurate reflection of part of my job. I am the IT guy for our company. Which means that I'm also in charge of taking the basic reports that came with our point of sale program and editing the data into reports that are custom designed to answer the question that the manager asks. And the question is often different every day. So dropping the 10 page report into a spreadsheet to massage the data into 5 lines of 'boss answer' makes sense. But sometimes the question is a repeat. And after the 10th time the manager asked the question, I added a procedure into the database. So now every time I get a 'boss question', I have to decide if I'm going to make a procedure for it or a spreadsheet. The comic gets amusingly ridiculous for me on the 3rd panel, because running a query in the spreadsheet has pushed the complexity of my work up to the point where it's just as easy to make the procedure in the database. [[Special:Contributions/172.68.90.76|172.68.90.76]] 19:45, 29 July 2019 (UTC)SiliconWolf | I find this comic to be an accurate reflection of part of my job. I am the IT guy for our company. Which means that I'm also in charge of taking the basic reports that came with our point of sale program and editing the data into reports that are custom designed to answer the question that the manager asks. And the question is often different every day. So dropping the 10 page report into a spreadsheet to massage the data into 5 lines of 'boss answer' makes sense. But sometimes the question is a repeat. And after the 10th time the manager asked the question, I added a procedure into the database. So now every time I get a 'boss question', I have to decide if I'm going to make a procedure for it or a spreadsheet. The comic gets amusingly ridiculous for me on the 3rd panel, because running a query in the spreadsheet has pushed the complexity of my work up to the point where it's just as easy to make the procedure in the database. [[Special:Contributions/172.68.90.76|172.68.90.76]] 19:45, 29 July 2019 (UTC)SiliconWolf | ||
− | |||
− | |||
− | |||
− |