The OFFICIAL programming thread

Gators1

@Hog said in The OFFICIAL programming thread:

What kind of ghetto bullshit is this?

Microsoft Excel SUBTOTAL function

Syntax

SUBTOTAL(function_num,ref1,[ref2],…)

The SUBTOTAL function syntax has the following arguments:
Function_num Required. The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

To use this function, you’ve got to look up a chart of codes called “Function numbers” (e.g. 101 for “AVERAGE”, 102 for “COUNT” etc) and enter it into the formula.

Hey Microsoft, the 1980’s are calling and they want their User Experience back.

Lots of the functions in excel are from the 1980 as that they left as is for compatibility. If they changed it every update then it would break millions of spreadsheets and users who aren’t that technical would be lost.

@Gators1 said in The OFFICIAL programming thread:

@Hog said in The OFFICIAL programming thread:

What kind of ghetto bullshit is this?

Microsoft Excel SUBTOTAL function

Syntax

SUBTOTAL(function_num,ref1,[ref2],…)

The SUBTOTAL function syntax has the following arguments:
Function_num Required. The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

To use this function, you’ve got to look up a chart of codes called “Function numbers” (e.g. 101 for “AVERAGE”, 102 for “COUNT” etc) and enter it into the formula.

Hey Microsoft, the 1980’s are calling and they want their User Experience back.

Lots of the functions in excel are from the 1980 as that they left as is for compatibility. If they changed it every update then it would break millions of spreadsheets and users who aren’t that technical would be lost.

Yeah I dunno about that reasoning. They fucked everyone in the ass in the 90’s with massive changes. You used to be able to do anything and everything Excel could do in a couple of keystrokes via menu shortcuts. A billion macros had to be rewritten when they gave us the god awful ribbon (although they did phase the menu shortcuts out slowly.)

But in any case, it really is an odd animal that does remind me a lot of reaching for manuals to work out how to do a simple task before we had even had GUIs. I don’t how something like it would work in Excel but in a program you’d create constants, like AVERAGE = 101, and you’d just start typing the name and let it suggest it rather than have to remember some obscure number.

Gustaf

@Hog alt text

Gators1

@Hog said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

@Hog said in The OFFICIAL programming thread:

What kind of ghetto bullshit is this?

Microsoft Excel SUBTOTAL function

Syntax

SUBTOTAL(function_num,ref1,[ref2],…)

The SUBTOTAL function syntax has the following arguments:
Function_num Required. The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

To use this function, you’ve got to look up a chart of codes called “Function numbers” (e.g. 101 for “AVERAGE”, 102 for “COUNT” etc) and enter it into the formula.

Hey Microsoft, the 1980’s are calling and they want their User Experience back.

Lots of the functions in excel are from the 1980 as that they left as is for compatibility. If they changed it every update then it would break millions of spreadsheets and users who aren’t that technical would be lost.

Yeah I dunno about that reasoning. They fucked everyone in the ass in the 90’s with massive changes. You used to be able to do anything and everything Excel could do in a couple of keystrokes via menu shortcuts. A billion macros had to be rewritten when they gave us the god awful ribbon (although they did phase the menu shortcuts out slowly.)

But in any case, it really is an odd animal that does remind me a lot of reaching for manuals to work out how to do a simple task before we had even had GUIs. I don’t how something like it would work in Excel but in a program you’d create constants, like AVERAGE = 101, and you’d just start typing the name and let it suggest it rather than have to remember some obscure number.

The functions exist in the user sheets though. If the numbers go away then the sheets break or they have to write some conversion tool in order to do upgrades and that might not always work. Think about if you got a new release of Python and they changed a bunch of shit in the built in functions. All your code wouldn’t work and you would have to go through each script to update it. Now think about some dumb as ccountant that doesn’t really understand functions and inherited the workbooks that don’t work anymore. Compatibility across releases has always been significant for Excel.

Tazz

Gators1

I hate Python libraries!

That is all

Tazz

Gustaf

@Tazz said in The OFFICIAL programming thread:

What a dumb nerd!

Also he’s not an engineer.

Tazz

Gators1

Has it deleted your C drive yet? No? Still better than human coders.

Dec 4, 2022

Stack Overflow bans ChatGPT as 'substantially harmful'

High error rates mean thousands of AI answers need checking by humans

Like there aren’t maybe dozens or more stack overflow users who will just script around it and use ChatGPT in the backend to farm karma or whatever it is that StackOverflow awards. How will they police it? Add a report link with the option saying, “I can’t be sure but I don’t think this user is human”?

Gators1

@Hog said in The OFFICIAL programming thread:

Like there aren’t maybe dozens or more stack overflow users who will just script around it and use ChatGPT in the backend to farm karma or whatever it is that StackOverflow awards. How will they police it? Add a report link with the option saying, “I can’t be sure but I don’t think this user is human”?

I have never been sure the people on SO are human.

Gators1

Chat GPT is garbage. I have had it create a few simple conversion functions for me, but occasionally it just gets really stupid. In this case it can’t even convert freedom to commie measures and did it backwards. At least it apologizes I guess, which seems to be a lost art these days.

Screenshot 2022-12-21 164723.png