todorov84 · HackerTrans

vor 11 Monatendiscuss

Interestingly, the main problem with Minesweeper is that is a game of chance (so the approach discussed in the article is very appropriate).

For a minesweeper variant purely based on logic, I highly recommend the game Tametsi. It has 160 handcrafted levels, and some have very interesting geometrical arrangements. I have logged over 100 hours in this game.

todorov84

vor 2 Jahrendiscuss

Oh, come on.

Just format the range as text before pasting or importing the data (right-click -> format cells -> category = text). Text-formatted ranges don't convert input data.

The article also doesn't help saying that there is a toggle for implicit conversions. You want text, you preformat as text.

Just learn to use the damn thing before you bash it. Especially if it's your daily driver.

todorov84

vor 3 Jahrendiscuss

Does anyone have any updates on Mike Burgess (from winhelp2002.mvps.org)? He used to keep my go-to hosts file, but his health seems to have declined in the last few years. I would like to know if he is still around and if there is currently any method to donate or support him. Any news would be greatly appreciated.

todorov84

vor 4 Jahrendiscuss

I don't trust this developer.

For the last two years or so they tried to retire "Simple Gallery" (which already had no ads or extra permissions required) and move people to its paid version by releasing updates with nag screens and fewer and fewer functions (edit: removals).

Every single time someone complained in a review, they would reply a canned answer: "Hey, there are many improvements in the Pro app version, it is definitely worth upgrading".

I have no issue paying for apps I like, but sorry, I won't reward scummy behaviour.

todorov84

vor 4 Jahrendiscuss

I think you should go with Office 2010 even though you dislike the ribbon.

Office 2003 is a delight to use, but any version prior to 2007 will lack support by default to docx, xlsx and pptx formats, which are the current file formats and the ones someone would share with you in the "real world".

Using an older version, even if you install the compatibility pack as someone suggested in another comment, you will experience many issues -- especially in Excel, which was heavily modified (e.g. rows increased from 2^16 to 2^20, new color model replacing the old palette of 16 user-defined colors, new functions such as SUMIFS and COUNTIFS, new implementations for sorting, filtering, conditional formatting etc).

Excel 2010 is almost like 2007, but with many tweaks, corrected statistical functions (they were notoriously unreliable in previous versions) and with improvements to charts which are still almost 100% compatible with the latest version. You should have no problems at all creating and editing documents between Excel 2010 and the most recent version in either direction.

Being an older version of Office, it's also very responsive even on low-end machines -- just be sure to install the 64 bits version.

As for the ribbon, remember that you can double click any tab (for instance, "Data") to automatically hide the menu. You can also customize each and every button on it (right button, "Customize the ribbon").

todorov84

vor 5 Jahrendiscuss

I've blocked these popups and the suggestions overlay at the end of videos by using these rules:

  www.youtube.com##.ytd-thumbnail-overlay-loading-preview-renderer
  www.youtube.com##.ytd-video-preview
  www.youtube.com##.ytp-ce-covering-overlay
  www.youtube.com##.ytp-ce-element
  www.youtube.com##.ytp-cards
  www.youtube.com##.ytp-cards-teaser
  www.youtube.com##.ytp-cards-button-icon

todorov84

vor 6 Jahrendiscuss

For maximum readability, you could also go for

  (min + ((num + max - Math.abs(num - max)) / 2) + Math.abs(min - ((num + max - Math.abs(num - max)) / 2))) / 2

Since

  min(a, b) = (a + b - |a - b|) / 2

and

  max(a, b) = (a + b + |a - b|) / 2

comments