190 reputation
11
bio website movingsql.com
location New Jersey
age 56
visits member for 5 years, 2 months
seen Oct 14 at 18:13
coder & programmer of many defunct languages...

Sep
15
comment Before Operating systems, What concept was used to make them work?
As for the matter of which answers tend to get the most vote... well there you have my sincere sympathies. I've had the same thing happen to my many times, I'm afraid that's just how StackExchange is. And my most popular answer by far is nothing more than two nested REPLACE functions, far from my best answer.
Sep
15
comment Before Operating systems, What concept was used to make them work?
@krowe Actually it has everything to do with it. C and its sucessor languages have their dominant position today because for almost 20 years most schools turned out CS grads whose preferred (and often only) OS language was C. And this was because, despite there being dozens of serious competitors to C, it was the only one of them that was free, had free source code, and complied a free OS, also with free source code. A deal very few universities could resist. What the big SW companies did then was simply a reflection of what their employees wanted, which is what they were most used to: C.
Sep
12
comment Before Operating systems, What concept was used to make them work?
Most of the things listed above about UNIX and C's precedence are incorrect, most especially, why UNIX and C were so important in the history of OSs. This was due, almost entirely, to the 1974 Consent Decree against AT&T, which meant that it (and a lot of other AT&T technology) was free, including the source code. Because of this, it's real "first's" were as the first free fully functioning modern OS and low level compiler, including all of the source code. A solitary position it would occupy for 10-20 years before it's competitors would honestly admit the advantage that gave it.
Sep
11
comment Before Operating systems, What concept was used to make them work?
"until Ken and Dennis first compiled the UNIX kernel ... that a true OS in the modern sense was born.." OMG. Less true words have rarely been written on this site. There is no sense in which this statement is remotely accurate.
May
5
awarded  Caucus
Apr
24
awarded  Popular Question
Sep
13
revised 2007 Worksheet Opens with Errors in 2010
deleted 1 characters in body
Sep
13
revised 2007 Worksheet Opens with Errors in 2010
added 503 characters in body
Sep
13
asked 2007 Worksheet Opens with Errors in 2010
Apr
25
comment How to count number of distinct values in a range?
This is the part that I'm having trouble with: "coming up with a scaled value for each distinct value based on how many iterations there are in the column." If I understand this, then SUMPRODUCT is effectively executing a loop like for each [i] in A2:A100 DO:{ sum += (([i]<>"")/COUNTIF(A2:A100,[i])) }, right? I am having a little trouble understanding how it knows to enumerate both the conditional and the 2nd COUNTIF parameter, but not the 1st COUNTIF parameter? Is this DWIM-magic documented/explained anywhere by MS? It would be nice to know how to write these intentionally.
Apr
25
awarded  Commentator
Apr
25
comment How to count number of distinct values in a range?
How/why does this work???
Apr
19
comment How do I apply formulas to subtotal rows?
Generally this is done the other way around: you apply subsequent formulas to just the data rows and skip the subtotals. Most of the time that should work out to the same result.
Mar
29
awarded  Critic
Mar
20
accepted How can I turn a Calculated Column back into a data column in an Excel Table?
Mar
20
comment How can I turn a Calculated Column back into a data column in an Excel Table?
Yes, that worked! Thanks! Any insights on the second part?
Mar
20
asked How can I turn a Calculated Column back into a data column in an Excel Table?
Oct
11
revised Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
added 429 characters in body
Oct
11
awarded  Editor
Oct
11
revised Microsoft Office 2003 document (Excel and Word), intermitently, takes 30 seconds to load
added 25 characters in body