silverhand

joined 1 year ago
[–] [email protected] 11 points 1 week ago* (last edited 1 week ago) (1 children)

Anybody who used ANY library to process xslx knows MS keeps changing it :-)

I highly doubt that, also, people in corporate finance do not use libraries to process excel files.

About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?

=OFFSET(first_cell, 7, COLUMNS(range_name), ROWS(range_name)-9-7) where range_name is the label given to the whole table and first_cell is its first cell.

[–] [email protected] 27 points 1 week ago* (last edited 1 week ago) (4 children)

Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers )

You can literally label ranges to use them as variables in Excel formulae, not to mention Excel Tables has more operations and features than you'll ever need.

limits in columns and records

Unless you are working with an unfiltered, un-aggregated ledger dump straight out of your database (in which case you shouldn't be let anywhere near an office computer), it's rather hard to cross 1M+ rows and 16.4k columns in corporate finance.

ever changing formats across versions

The .xlsx format was introduced in 2007 (18 years ago) and hasn't changed since. Not to mention you can still use all kinds of plaintext formats whenever you want.

[–] [email protected] 131 points 1 week ago (18 children)

Only those with no experience in corporate finance will find this surprising.

Excel is a powerful tool. The only ones who ridicule it are idiots who don't understand anything.

[–] [email protected] 1 points 1 week ago (1 children)

No, you can't.

Why not use the same method that worked last time? Do you not have a wired connection anymore?

Anyway, if a kernel update fixed it last time, it's highly likely the latest ISO will have that updated kernel already. Just try seeing if Wifi works from the live USB.

[–] [email protected] 1 points 1 week ago

Cromite doesn't seem to allow opening supported links in other apps for some reason

[–] [email protected] 26 points 1 week ago (4 children)

Literally every other browser with uBlock Origin? I am still able to use it even on Chrome.

[–] [email protected] 34 points 1 week ago (1 children)

The fact that he invented Javascript alone makes him a villain. Everything he did after that is just complementary.

[–] [email protected] 6 points 2 weeks ago

Chegg still exists!?

[–] [email protected] 20 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

cynical (/ˈsɪnɪkl/) adjective

  • concerned only with one's own interests and typically disregarding accepted standards in order to achieve them.

Technically all corporations and enterprises in a free market have to adhere to that description, by design. Corporations are fundamentally social structures built for one and one purpose only - creating value for shareholders.

[–] [email protected] 5 points 2 weeks ago

It is a pointless view that solves nothing. Flip it around, say "all (on both sides) are not guilty" and you might have a starting point.

[–] [email protected] 74 points 2 weeks ago (6 children)

Should I just declare to never talk about politics with them again since it’s pointless?

Yes. I thought that was obvious, when have you ever seen children being able to convert their parents?

[–] [email protected] 6 points 3 weeks ago

Social skills are not something you can "learn" by questioning things like this. You have to live more of your life among people.

It's like swimming - you can't learn to swim no matter how much you study about it, read books or ask questions. You have to get into the water. And the first couple of times you're in the water you'll drown, tire out, may even feel frustrated or bad. But you'll only be able to swim by going back in, over and over until you start floating. So it is with socializing with people.

view more: next ›