Talk:1667: Algorithms - Revision history

MeZimm at 16:08, 25 February 2025

2025-02-25T16:08:40Z

162.158.175.129 at 15:05, 23 August 2024

2024-08-23T15:05:16Z

172.70.90.228 at 03:03, 20 September 2023

2023-09-20T03:03:08Z

LostButMakingGoodTime: Another real world example of the complexities of using excel for scheduling.

2018-07-01T17:52:38Z

Another real world example of the complexities of using excel for scheduling.

172.68.58.137 at 23:35, 11 August 2017

2017-08-11T23:35:49Z

Davidy22 at 09:01, 14 April 2016

2016-04-14T09:01:19Z

Elektrizikekswerk at 07:18, 14 April 2016

2016-04-14T07:18:30Z

141.101.70.103 at 01:32, 14 April 2016

2016-04-14T01:32:32Z

Tahg at 23:07, 13 April 2016

2016-04-13T23:07:00Z

Davidy22 at 20:45, 13 April 2016

2016-04-13T20:45:33Z

← Older revision		Revision as of 16:08, 25 February 2025
Line 42:		Line 42:

	Why is 'schism' probably referring to the East-West Schism? There have been dozens of schisms for all sorts of reasons, from Arianism and Miaphysitism to recent splits in the Mormon Church and various other young denominations. The comic could (theoretically) be referring to any one of these schisms, or (more likely, in my view) it could be referring to the concept of a schism in general. Personally I think it's most likely a parody of modern church splits over outwardly petty-looking, seemingly trivial, or apparently overly worldly reasons. [[Special:Contributions/172.70.90.228\|172.70.90.228]] 03:03, 20 September 2023 (UTC)		Why is 'schism' probably referring to the East-West Schism? There have been dozens of schisms for all sorts of reasons, from Arianism and Miaphysitism to recent splits in the Mormon Church and various other young denominations. The comic could (theoretically) be referring to any one of these schisms, or (more likely, in my view) it could be referring to the concept of a schism in general. Personally I think it's most likely a parody of modern church splits over outwardly petty-looking, seemingly trivial, or apparently overly worldly reasons. [[Special:Contributions/172.70.90.228\|172.70.90.228]] 03:03, 20 September 2023 (UTC)
−	:Agreed. Reference deleted. - MeZimm [[~~Special~~:~~Contributions/162.158.175.129~~\|~~162.158.175.129~~]] 15:05, 23 August 2024 (UTC)	+	:Agreed. Reference deleted. [[User:MeZimm\|MeZimm]] ([[User talk:MeZimm\|talk]]) 15:05, 23 August 2024 (UTC)

← Older revision		Revision as of 15:05, 23 August 2024
Line 42:		Line 42:

	Why is 'schism' probably referring to the East-West Schism? There have been dozens of schisms for all sorts of reasons, from Arianism and Miaphysitism to recent splits in the Mormon Church and various other young denominations. The comic could (theoretically) be referring to any one of these schisms, or (more likely, in my view) it could be referring to the concept of a schism in general. Personally I think it's most likely a parody of modern church splits over outwardly petty-looking, seemingly trivial, or apparently overly worldly reasons. [[Special:Contributions/172.70.90.228\|172.70.90.228]] 03:03, 20 September 2023 (UTC)		Why is 'schism' probably referring to the East-West Schism? There have been dozens of schisms for all sorts of reasons, from Arianism and Miaphysitism to recent splits in the Mormon Church and various other young denominations. The comic could (theoretically) be referring to any one of these schisms, or (more likely, in my view) it could be referring to the concept of a schism in general. Personally I think it's most likely a parody of modern church splits over outwardly petty-looking, seemingly trivial, or apparently overly worldly reasons. [[Special:Contributions/172.70.90.228\|172.70.90.228]] 03:03, 20 September 2023 (UTC)
		+	:Agreed. Reference deleted. - MeZimm [[Special:Contributions/162.158.175.129\|162.158.175.129]] 15:05, 23 August 2024 (UTC)

← Older revision		Revision as of 03:03, 20 September 2023
Line 40:		Line 40:

	My organization has used Excel as a scheduling tool for at least 10 years. Management was using paper and an enterprising employee with a penchant for Excel decided to kick them into the computer age. Each hour of each day of a 24/7 operation is tracked, including which of 13 task positions is being worked by which employee. But it must contain room for other than regularly scheduled employees as well as future additions. And each Workbook covers 2 weeks at a stretch. All information must come together to generate several reports. So... 13 positions x a theoretical 100 employees = 1300 cells. Times 14 days = 18,200 cells. And each cell has a background formula to calculate from each hour of each 24 hr. day...formulas with 95 nested COUNTIFs. So there are 1,729,000 COUNTIF calculations running in the background and spitting out results on a bar chart and two totals reports. And this does not include the formulas running behind each daily sheet to provide staffing numbers for each hour around the clock. It has been an absolute beast to manage. I just recently finished overhauling the whole thing, improving appearance and organization, locking areas of each sheet to minimize formula corruption, and implementing conditional formatting to further reduce the need for the user input (half a dozen supervisory personnel, some of whom can recognize a computer when they see one) that has caused so much grief. But in the end there was no getting around the enormous formulas running in the background. Excel is NOT the right tool for this job. But we have been unable to determine a replacement. [[User:LostButMakingGoodTime\|LostButMakingGoodTime]] ([[User talk:LostButMakingGoodTime\|talk]]) 17:52, 1 July 2018 (UTC)		My organization has used Excel as a scheduling tool for at least 10 years. Management was using paper and an enterprising employee with a penchant for Excel decided to kick them into the computer age. Each hour of each day of a 24/7 operation is tracked, including which of 13 task positions is being worked by which employee. But it must contain room for other than regularly scheduled employees as well as future additions. And each Workbook covers 2 weeks at a stretch. All information must come together to generate several reports. So... 13 positions x a theoretical 100 employees = 1300 cells. Times 14 days = 18,200 cells. And each cell has a background formula to calculate from each hour of each 24 hr. day...formulas with 95 nested COUNTIFs. So there are 1,729,000 COUNTIF calculations running in the background and spitting out results on a bar chart and two totals reports. And this does not include the formulas running behind each daily sheet to provide staffing numbers for each hour around the clock. It has been an absolute beast to manage. I just recently finished overhauling the whole thing, improving appearance and organization, locking areas of each sheet to minimize formula corruption, and implementing conditional formatting to further reduce the need for the user input (half a dozen supervisory personnel, some of whom can recognize a computer when they see one) that has caused so much grief. But in the end there was no getting around the enormous formulas running in the background. Excel is NOT the right tool for this job. But we have been unable to determine a replacement. [[User:LostButMakingGoodTime\|LostButMakingGoodTime]] ([[User talk:LostButMakingGoodTime\|talk]]) 17:52, 1 July 2018 (UTC)
		+
		+	Why is 'schism' probably referring to the East-West Schism? There have been dozens of schisms for all sorts of reasons, from Arianism and Miaphysitism to recent splits in the Mormon Church and various other young denominations. The comic could (theoretically) be referring to any one of these schisms, or (more likely, in my view) it could be referring to the concept of a schism in general. Personally I think it's most likely a parody of modern church splits over outwardly petty-looking, seemingly trivial, or apparently overly worldly reasons. [[Special:Contributions/172.70.90.228\|172.70.90.228]] 03:03, 20 September 2023 (UTC)

← Older revision		Revision as of 17:52, 1 July 2018
Line 38:		Line 38:

	Might it additionally be not just the intrinsic complexity but the perceived complexity? Bigger spreadsheets like this easily become arcane and incomprehensible, esp with a general lack of comments or explanations of what cells and formulas mean or how they were reached, especially with multiple contributors. [[Special:Contributions/172.68.58.137\|172.68.58.137]] 23:35, 11 August 2017 (UTC)RJ K.		Might it additionally be not just the intrinsic complexity but the perceived complexity? Bigger spreadsheets like this easily become arcane and incomprehensible, esp with a general lack of comments or explanations of what cells and formulas mean or how they were reached, especially with multiple contributors. [[Special:Contributions/172.68.58.137\|172.68.58.137]] 23:35, 11 August 2017 (UTC)RJ K.
		+
		+	My organization has used Excel as a scheduling tool for at least 10 years. Management was using paper and an enterprising employee with a penchant for Excel decided to kick them into the computer age. Each hour of each day of a 24/7 operation is tracked, including which of 13 task positions is being worked by which employee. But it must contain room for other than regularly scheduled employees as well as future additions. And each Workbook covers 2 weeks at a stretch. All information must come together to generate several reports. So... 13 positions x a theoretical 100 employees = 1300 cells. Times 14 days = 18,200 cells. And each cell has a background formula to calculate from each hour of each 24 hr. day...formulas with 95 nested COUNTIFs. So there are 1,729,000 COUNTIF calculations running in the background and spitting out results on a bar chart and two totals reports. And this does not include the formulas running behind each daily sheet to provide staffing numbers for each hour around the clock. It has been an absolute beast to manage. I just recently finished overhauling the whole thing, improving appearance and organization, locking areas of each sheet to minimize formula corruption, and implementing conditional formatting to further reduce the need for the user input (half a dozen supervisory personnel, some of whom can recognize a computer when they see one) that has caused so much grief. But in the end there was no getting around the enormous formulas running in the background. Excel is NOT the right tool for this job. But we have been unable to determine a replacement. [[User:LostButMakingGoodTime\|LostButMakingGoodTime]] ([[User talk:LostButMakingGoodTime\|talk]]) 17:52, 1 July 2018 (UTC)

← Older revision		Revision as of 23:35, 11 August 2017
Line 36:		Line 36:
	[[Special:Contributions/108.162.249.158\|108.162.249.158]] 20:30, 13 April 2016 (UTC)		[[Special:Contributions/108.162.249.158\|108.162.249.158]] 20:30, 13 April 2016 (UTC)
	:xlsx was introduced with Office 2007: https://en.wikipedia.org/wiki/Microsoft_Excel#Current_file_extensions [[User:Elektrizikekswerk\|Elektrizikekswerk]] ([[User talk:Elektrizikekswerk\|talk]]) 07:18, 14 April 2016 (UTC)		:xlsx was introduced with Office 2007: https://en.wikipedia.org/wiki/Microsoft_Excel#Current_file_extensions [[User:Elektrizikekswerk\|Elektrizikekswerk]] ([[User talk:Elektrizikekswerk\|talk]]) 07:18, 14 April 2016 (UTC)
		+
		+	Might it additionally be not just the intrinsic complexity but the perceived complexity? Bigger spreadsheets like this easily become arcane and incomprehensible, esp with a general lack of comments or explanations of what cells and formulas mean or how they were reached, especially with multiple contributors. [[Special:Contributions/172.68.58.137\|172.68.58.137]] 23:35, 11 August 2017 (UTC)RJ K.

@@ Line 4: / Line 4: @@
 :: Oh my [[User:Nk22|The Twenty-second. The Not So Only. The Nathan/Nk22]] ([[User talk:Nk22|talk]]) 10:36, 13 April 2016 (UTC)
 :::also http://www.geocities.jp/nchikada/pac/ (it's geocities!) --[[Special:Contributions/141.101.98.84|141.101.98.84]] 11:56, 13 April 2016 (UTC)
-::::Or the thing I use at work. Work in finance - reconciling 1 code takes half a GIGABYTE of spreadsheets every 4 weeks that had been added to and tweaked so many times in the last 5 years by 6 different people, 5 of which are no longer at the company (and the last one hasn't used it in over a year) that it took me 4 months just to understand how the damned things worked and went together, and my work asks me to teach internal excel classes and run drop ins to help people out. First thing I did when I understood it was tear it down and rebuild from the ground up. Didn't cut the number of sheets (actually ended up with more), but it now takes 3 days not 15 and has dropped from half a gig to about 270MB thanks to a major cleanup in the one file I kept.
+::::Or the thing I use at work. Work in finance - reconciling 1 code takes half a GIGABYTE of spreadsheets every 4 weeks that had been added to and tweaked so many times in the last 5 years by 6 different people, 5 of which are no longer at the company (and the last one hasn't used it in over a year) that it took me 4 months just to understand how the damned things worked and went together, and my work asks me to teach internal excel classes and run drop ins to help people out. First thing I did when I understood it was tear it down and rebuild from the ground up. Didn't cut the number of sheets (actually ended up with more), but it now takes 3 days not 15 and has dropped from half a gig to about 270MB thanks to a major cleanup in the one file I kept. {{unsigned ip|141.101.70.103}}
 Leftpad is a reference to the recent incident where a developer unpublished all his libraries from the NodeJS Package Manager, causing much disruption: http://www.theregister.co.uk/2016/03/23/npm_left_pad_chaos/ [[Special:Contributions/162.158.85.231|162.158.85.231]] 05:58, 13 April 2016 (UTC)

← Older revision		Revision as of 07:18, 14 April 2016
Line 35:		Line 35:
	Were .xlsx spreadsheets even around in 2007? Wasn't that final x added to the extension with office 2010?		Were .xlsx spreadsheets even around in 2007? Wasn't that final x added to the extension with office 2010?
	[[Special:Contributions/108.162.249.158\|108.162.249.158]] 20:30, 13 April 2016 (UTC)		[[Special:Contributions/108.162.249.158\|108.162.249.158]] 20:30, 13 April 2016 (UTC)
		+	:xlsx was introduced with Office 2007: https://en.wikipedia.org/wiki/Microsoft_Excel#Current_file_extensions [[User:Elektrizikekswerk\|Elektrizikekswerk]] ([[User talk:Elektrizikekswerk\|talk]]) 07:18, 14 April 2016 (UTC)

@@ Line 30: / Line 30: @@
 :Huh, that's strange. Someone had better find a query that actually works and edit the article accordingly.
 :Also, the page told me, "In order to show you the most relevant results, we have omitted some entries very similar to the 0 already displayed. If you like, you can repeat the search with the omitted results included." I clicked the link to repeat it and still, nothing showed up. Just goes to show that even Google's algorithms can have small flaws and quirks. <span style="background:#0064de;font-size:12px;padding:4px 12px;border-radius:8px;">[[User talk:AgentMuffin|<span style="color:#f0faff;">~AgentMuffin</span>]]</span>
 Were .xlsx spreadsheets even around in 2007?  Wasn't that final x added to the extension with office 2010?
 [[Special:Contributions/108.162.249.158|108.162.249.158]] 20:30, 13 April 2016 (UTC)

@@ Line 1: / Line 1: @@
 <!-- Please sign your posts with a ~~~~ -->
 How can an excel spreadsheet be complicated? [[Special:Contributions/108.162.244.85|108.162.244.85]] 04:52, 13 April 2016 (UTC
 :See this example http://arstechnica.com/gaming/2013/04/how-an-accountant-created-an-entire-rpg-inside-an-excel-spreadsheet/ {{unsigned ip|108.162.216.82}}
@@ Line 33: / Line 30: @@
 :Huh, that's strange. Someone had better find a query that actually works and edit the article accordingly.
 :Also, the page told me, "In order to show you the most relevant results, we have omitted some entries very similar to the 0 already displayed. If you like, you can repeat the search with the omitted results included." I clicked the link to repeat it and still, nothing showed up. Just goes to show that even Google's algorithms can have small flaws and quirks. <span style="background:#0064de;font-size:12px;padding:4px 12px;border-radius:8px;">[[User talk:AgentMuffin|<span style="color:#f0faff;">~AgentMuffin</span>]]</span>