quote:

Dates in Excel spreadsheets

In reality, there are no such things. What you have are floating point numbers and pious hope. There are several problems with Excel dates:

(1) Dates are not stored as a separate data type; they are stored as floating point numbers and you have to rely on (a) the "number format" applied to them in Excel and/or (b) knowing which cells are supposed to have dates in them. This module helps with (a) by inspecting the format that has been applied to each number cell; if it appears to be a date format, the cell is classified as a date rather than a number. Feedback on this feature, especially from non-English-speaking locales, would be appreciated.

(2) Excel for Windows stores dates by default as the number of days (or fraction thereof) since 1899-12-31T00:00:00. Excel for Macintosh uses a default start date of 1904-01-01T00:00:00. The date system can be changed in Excel on a per-workbook basis (for example: Tools -> Options -> Calculation, tick the "1904 date system" box). This is of course a bad idea if there are already dates in the workbook. There is no good reason to change it even if there are no dates in the workbook. Which date system is in use is recorded in the workbook. A workbook transported from Windows to Macintosh (or vice versa) will work correctly with the host Excel. When using this module's xldate_as_tuple function to convert numbers from a workbook, you must use the datemode attribute of the Book object. If you guess, or make a judgement depending on where you believe the workbook was created, you run the risk of being 1462 days out of kilter.

Reference: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q180162

(3) The Excel implementation of the Windows-default 1900-based date system works on the incorrect premise that 1900 was a leap year. It interprets the number 60 as meaning 1900-02-29, which is not a valid date. Consequently any number less than 61 is ambiguous. Example: is 59 the result of 1900-02-28 entered directly, or is it 1900-03-01 minus 2 days? The OpenOffice.org Calc program "corrects" the Microsoft problem; entering 1900-02-27 causes the number 59 to be stored. Save as an XLS file, then open the file with Excel -- you'll see 1900-02-28 displayed.

Reference: http://support.microsoft.com/default.aspx?scid=kb;en-us;214326

(4) The Macintosh-default 1904-based date system counts 1904-01-02 as day 1 and 1904-01-01 as day zero. Thus any number such that (0.0 <= number < 1.0) is ambiguous. Is 0.625 a time of day (15:00:00), independent of the calendar, or should it be interpreted as an instant on a particular day (1904-01-01T15:00:00)? The xldate_* functions in this module take the view that such a number is a calendar-independent time of day (like Python's datetime.time type) for both date systems. This is consistent with more recent Microsoft documentation (for example, the help file for Excel 2002 which says that the first day in the 1904 date system is 1904-01-02).

(5) Usage of the Excel DATE() function may leave strange dates in a spreadsheet. Quoting the help file, in respect of the 1900 date system: "If year is between 0 (zero) and 1899 (inclusive), Excel adds that value to 1900 to calculate the year. For example, DATE(108,1,2) returns January 2, 2008 (1900+108)." This gimmick, semi-defensible only for arguments up to 99 and only in the pre-Y2K-awareness era, means that DATE(1899, 12, 31) is interpreted as 3799-12-31.

Bob Morales posted:

The real reason is because the owner LOVES printing emails. So if you have this email chain going, he'll print it and it's 85% signatures and he flips the gently caress out.

skooma512 posted:

How the gently caress do the Don's of the world continue to have jobs?

tactlessbastard posted:

edit: I'd like to take this as flippantly IRL as I am here but she reports directly to Son of Owner and I've seen him doing bible studies in his office soooooo

Thanks Ants posted:

Blade down knives are fine, if the cutlery thing is so brittle that it's getting broken by knives going in point down then the plastics have degraded and it needs replacing. Though what you actually want is a Siemens dishwasher with a cutlery tray rather than a basket.

Super Soaker Party! posted:

<checks date>



What are you doing? Stop it.

Toupee Groupie posted:

I know it is not the lines. I spent about 10 hours over 3 days on the phone with enterprise support (what I am classified at due to the contract) and was told in a roundabout way that the POP in my area has 2.5 Gig down and 1Gb up and service has been oversold. Since our line was put in 100 + houses and a few businesses have gone in with no upgrade of their equipment. Over Christmas break, we had a few slowness issues since everyone was home, but when we complained, either break was up, or adjusted QOS at the ISP POP. Most houses in my area have 2 parents working from home on VPN, 2.5 kids streaming Netflix, games or using Zoom for school.

What I am surmising is this is happening: Everyone is home and internet is slow or not working at all. Network engineers look at the POP and see that there is a dedicated line that, if changing it over to a standard home broadband connection., 100s of home customers houses would get more bandwidth and complaints will stop coming in. Our neighbors are having the same downtime and slowness issues with their home broadband internet. We call and complain, and management would rather stop 100 calls from coming in to the company to an already overworked and smaller customer service center. The average home internet connection with the lone broadband ISP is 80 dollars a month, and that doesn't include TV or phone service that they have. We were paying 250 dollars a month before to get 50Mb down and 5Mb up (their highest internet speed offered) along with TV and phone. That internet alone was 120 a month.

Moo the cow posted:

Bob Morales posted:

Access....so that's Microsoft right?

devmd01 posted:

Lmao yep, I’ve been subscribed to a feature request for Okta for two years with no traction. It’s always amusing to see the new comment notification emails.

quote:

"I asked the ESRI Reps about grouping feature layers at the 2017 UC and was told this would be done by the next UC 2018"

"ESRI did address this at the UC and said that they will include this ability in late 2018/early 2019 when they change to the 4x JSAPI. "

"I talked with Katie Cullen at the UC and she said group layers are coming 2019."

"The new map viewer will be out in September 2019, however it will not have the ability to group layers in the initial release, layer grouping will not be available until December 2019, or March 2020 at the latest. "

The Fool posted:

I have the most fun with a sister org that doesn't use their e-mail address as their upn.

My users constantly invite the e-mail address to things in sharepoint and teams and it causes all kinds of confusion.

Rooted Vegetable posted:

I have to card reader my way into the washroom. Before anyone asks, it only works for one of the washrooms. I presume it helps avoid unintentional errors.

sixth and maimed posted:

I was thinking about shooting them a mail asking how many we need to order to get a volume discount and then relaying that number to him.

Thanks Ants posted:

Are new contracts significantly worse than the ones existing staff are on?

Breetai posted:

In what context? It's useful for chronological ordering when sorting by filename at least.

nielsm posted:

Sane people use YYYYMMDD. What are you gonna do if a time traveler from 1981 arrives and is confused about which century the dates fall in?

Potato Salad posted:

Does anyone know how Deloitte upward-failed itself into its perceived status as a useful institution?

ConfusedUs posted:

Someone drive their car into my apartment building last night.

They took out my air conditioning unit and also, uh, the building may not be structurally sound anymore.

So that’s what’s pissing me off.

klosterdev posted:

Me over Teams: Hi $user, is there a good time for you for us to address your ticket together?
User: Yes
*crickets*

Potato Salad posted:

I am tempted to punt to a commercial program but they all are built into full bore spyware and require someone to compare mouse activity with screen activity