Talk:2180: Spreadsheets - Revision history

FaviFake: spam

2025-06-12T13:05:55Z

spam

ExplainEuge.ca at 06:12, 12 June 2025

2025-06-12T06:12:15Z

An user who has no account yet at 23:48, 13 October 2023

2023-10-13T23:48:29Z

172.70.86.12 at 13:23, 12 November 2022

2022-11-12T13:23:50Z

NiceGuy1 at 06:43, 12 November 2022

2022-11-12T06:43:20Z

Ipez: Deleted spam

2019-11-05T12:11:42Z

Deleted spam

108.162.210.214 at 20:55, 17 October 2019

2019-10-17T20:55:55Z

172.68.222.22 at 11:48, 4 August 2019

2019-08-04T11:48:22Z

Ipez: First proposal for the calendar_from_a_cell formula (link to Google Sheets)

2019-08-03T15:03:29Z

First proposal for the calendar_from_a_cell formula (link to Google Sheets)

172.68.90.76: my job is sometimes like this.

2019-07-29T19:45:09Z

my job is sometimes like this.

← Older revision		Revision as of 13:05, 12 June 2025
Line 38:		Line 38:

	if that also works in excel, i'll definitely use that [[User:An user who has no account yet\|An user who has no account yet]] ([[User talk:An user who has no account yet\|talk]]) 23:48, 13 October 2023 (UTC)		if that also works in excel, i'll definitely use that [[User:An user who has no account yet\|An user who has no account yet]] ([[User talk:An user who has no account yet\|talk]]) 23:48, 13 October 2023 (UTC)
−
−	Euge.ca 2nd comic is titled Temptation, a word appearing also in this comic, and that one also has an angel and a devil, this time with colors. [[User:ExplainEuge.ca\|ExplainEuge.ca]] ([[User talk:ExplainEuge.ca\|talk]]) 06:12, 12 June 2025 (UTC)

← Older revision		Revision as of 06:12, 12 June 2025
Line 38:		Line 38:

	if that also works in excel, i'll definitely use that [[User:An user who has no account yet\|An user who has no account yet]] ([[User talk:An user who has no account yet\|talk]]) 23:48, 13 October 2023 (UTC)		if that also works in excel, i'll definitely use that [[User:An user who has no account yet\|An user who has no account yet]] ([[User talk:An user who has no account yet\|talk]]) 23:48, 13 October 2023 (UTC)
		+
		+	Euge.ca 2nd comic is titled Temptation, a word appearing also in this comic, and that one also has an angel and a devil, this time with colors. [[User:ExplainEuge.ca\|ExplainEuge.ca]] ([[User talk:ExplainEuge.ca\|talk]]) 06:12, 12 June 2025 (UTC)

← Older revision		Revision as of 23:48, 13 October 2023
Line 36:		Line 36:

	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)		For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)
		+
		+	if that also works in excel, i'll definitely use that [[User:An user who has no account yet\|An user who has no account yet]] ([[User talk:An user who has no account yet\|talk]]) 23:48, 13 October 2023 (UTC)

@@ Line 27: / Line 27: @@
 ::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)
 :::Yes, I use Excel to make the contents of the batch file, a list of REN commands instead of typing them individually, then copy and paste to a Notepad file, save it as "Go.bat", then type Go in a DOS command window. :) I use Excel to construct all the individual filenames, then compile the old names with the new names into "ren [old name] [new name]". If there's more than like 5 files, programming the Excel is faster and less work than naming each file individually. [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 06:43, 12 November 2022 (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 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)
 ::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)

← Older revision		Revision as of 12:11, 5 November 2019
Line 34:		Line 34:

	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)		For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)
−
−	If you want to quit using Spreadsheets and you are not an SQL guru, then I recommend Airtable: https://airtable.com/invite/r/H8m6cjAd [[Special:Contributions/108.162.210.214\|108.162.210.214]] 20:55, 17 October 2019 (UTC)

← Older revision		Revision as of 20:55, 17 October 2019
Line 34:		Line 34:

	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)		For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)
		+
		+	If you want to quit using Spreadsheets and you are not an SQL guru, then I recommend Airtable: https://airtable.com/invite/r/H8m6cjAd [[Special:Contributions/108.162.210.214\|108.162.210.214]] 20:55, 17 October 2019 (UTC)

← Older revision		Revision as of 11:48, 4 August 2019
Line 33:		Line 33:
	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

−	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. ~~Also it only~~ freezes the browser for ~~half a minute~~. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)	+	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. It freezes the browser for some 15 seconds just as Randall promised. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)

← Older revision		Revision as of 15:03, 3 August 2019
Line 32:		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
		+
		+	For days after this comic was uploaded I was afraid to visit explain-xkcd as I was certain that the formula mentioned in the title text would be recreated already. Call me nerd-sniped, but I could not resist giving it a try. So here it is: https://docs.google.com/spreadsheets/d/1Q5GOo6x49HkyDsDGmr61za4S5GWCuXQkd-tX9zN4Zwo/edit?usp=sharing The calendar generates entirely from cell D4. Only input is start date in A1 and end date in A2. I don't know if Randall seriously developed the formula he described, but mine differs somewhat from his description. It does make heavy use of SEQUENCE, but uses only one ARRAYFORMULA (why would you double-nest it anyway?) and does not use REGEXMATCH as I could not find any use for it. Of course, there's also a hodgepodge of functions SWITCH, IF, some operators and a bunch of functions related to date calculations. Also it only freezes the browser for half a minute. Output is a calendar displaying all the months from start to end date, containing name of the month, year, weekdays and every individual day. Feel free to copy the formula from D4 into your own Google Sheets spreadsheet and add any dates you like in cells A1 and A2 (they must be in those two cells in your sheet, too) using the function =DATE(yyyy,mm,dd). For me it works easily even for dates decades apart. If you see a random N/A error in one or two cells (though I haven't spotted any), let me know, it's easily correctable. If you see a REF error, you probably inserted dates decades apart, in which case you just need to hold on and Google will add more rows automatically. Be patient with it. [[User:Ipez\|Ipez]] ([[User talk:Ipez\|talk]]) 15:03, 3 August 2019 (UTC)

← Older revision		Revision as of 19:45, 29 July 2019
Line 30:		Line 30:

	QUERY() is overrated. FILTER() is more advanced and usable in other formulas.		QUERY() is overrated. FILTER() is more advanced and usable in other formulas.
		+
		+	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