m16ghost

6 ms·

1.
by m16ghost 2y ago
> (all in d/m/y format, mind you) The examples you gave are in m/d/y format though, and DATEVALUE() parses your examples correctly into Jan 15th, 2024 and January 3rd, 2024. DATEVALUE() parses ambiguous short date for
2.
by m16ghost 2y ago
Here are some links that might help visualize what is going on: https://www.naftaliharris.com/blog/steinviz/ https://www.youtube.com/watch?v=cUqoHQDinCM (this video actually references the origina
3.
by m16ghost 2y ago
There seems to be a lot of discussion about stock buybacks vs. dividends. Note that Apple also announced an increase of their dividend from $0.24/share to $0.25/share[0], so they are both repurchasing stock and paying out more in
4.
by m16ghost 3y ago
Thanks. What I am getting from this is that pi is believed to have this property, but proving this is still an unresolved problem.
5.
by m16ghost 3y ago
> Therefore, inside pi is contained every discovery and every work of art! Is this actually true? It is not clear to me that pi necessarily contains every possible sub-sequence.
6.
by m16ghost 4y ago
I think we can agree that something will need to change as medical trend cannot outpace inflation forever. I don't think the issue is with executive compensation, because even if insurance companies magically could perform all their se
7.
by m16ghost 4y ago
>Having no idea what the real trend is, couldn't any other factors counteract the perverse effect, making both parent's and your observations true at the same time ? Absolutely. There could be other factors that are counteracti
8.
by m16ghost 4y ago
>The Affordable Care Act introduced the newer perverse incentive of insurance companies tolerating higher prices. Because if you can only pay your execs bonuses based on 20% of your total spend, insurance companies can pay execs more if
9.
by m16ghost 5y ago
You are correct, those are some of the advantages of claims-made vs. occurrence policies. Claims-made policies started because the industry went through a crisis in the 60's and 70's. >Buying a policy to file a claim for an eve
10.
by m16ghost 5y ago
> I recently just renewed my errors and omissions policy and was a little shocked to find out if you let the policy expire then the policy does not protect you even in past while the policy was active. This is to protect the insurer agai
11.
by m16ghost 5y ago
Which version of Python/JS do they implement? I think part of the problem is that any scripting language rolled directly into Excel will be expected to keep backwards compatibility. Microsoft doesn't have full control over Python&
12.
by m16ghost 5y ago
It is not much better than the canonical example given in the article. It still has the following usability issues: -You still need to enumerate and label each new column and their types. This particular problem is fixed by crosstabN(). -Yo
13.
by m16ghost 5y ago
>Pandas is a very popular tool for data analysis. It comes built-in with many useful features, it's battle tested and widely accepted. However, pandas is not always the best tool for the job. SQL is very useful, but there are some d
14.
by m16ghost 6y ago
>E.g. looking at early 3d games, they just feel dated. One cannot help but compare them to today's 3d graphics and of course the oldies fall short by a very far margin. Comparing pixel art games to a modern AAA 3D game title is just
15.
by m16ghost 6y ago
Healthcare in the United States is complicated with lots of different players. The article seems to hint at a key issue they faced: >But insiders claim that it will allow the founding companies to implement ideas from the project on thei
16.
by m16ghost 6y ago
>Obamacare has a rule that insurers can have a maximum profit margin of 20%. So you have two ways to increase profits in the long run: >1) Increase number of subscribers. Possible to do, but the market is pretty saturated. >2) Rais
17.
by m16ghost 6y ago
This will be a good thing initially for consumers as it will allow people to comparison shop for the less complicated, non-life threatening medical treatments. It puts into place the other piece of consumer-driven healthcare[0], which is me
18.
by m16ghost 6y ago
All versions of Excel from 2013 and onward come with a tool that lists out cell by cell differences between two spreadsheets, called Spreadsheet Compare [0]. It lists side-by-side differences in hardcoded values, formula changes, calculated
19.
by m16ghost 6y ago
The Evolution of Trust[0] is a fun walkthrough of those game theory strategies. It adds the twist of miscommunication towards the end. [0] https://ncase.me/trust/
20.
by m16ghost 6y ago
>They were numbering paragraphs, not line items, and lines that wrapped were supposed to be left-justified. I don't think this is a strawman. Word allows you to adjust the indentation on numbered lists so that the text in a paragrap
21.
by m16ghost 6y ago
This doesn't appear to be true. There are other ways for health insurance companies to increase profits. The US Health insurance industry spends on average, 86% of premiums on healthcare costs[0], which means they can increase their pr
22.
by m16ghost 6y ago
Alphabet owns a company called Verily, which is entering the health reinsurance space: https://www.theverge.com/2020/8/25/21401124/alphabet-verily-... Verily already has its own smartwatch though.