Как одна буква в ассемблере стоит 3× производительности

Я хочу показать вам, как одна буква в ассемблере может стоить 3× производительности. Не в теории — на живых замерах. По дороге мы заглянем внутрь процессора: Register Alias Table, partial register merge, scheduler, latency vs throughput, и даже обнаружим, что делитель выдаёт остаток раньше частного. Но начнём с основ. Приготовьтесь: кроличья нора окажется глубже, чем кажется.

https://habr.com/ru/articles/1024862/?utm_source=habrahabr&utm_medium=rss&utm_campaign=1024862

#x86 #assembly #NASM #div #partial_register_merge #latency #throughput #микроархитектура #Skylake #оптимизация

Как одна буква в ассемблере стоит 3× производительности

Я хочу показать вам, как одна буква в ассемблере может стоить 3× производительности. Не в теории — на живых замерах. По дороге мы заглянем внутрь процессора: Register Alias Table, partial register merge, scheduler, latency vs throughput, и даже обнаружим, что делитель выдаёт остаток раньше частного. Но начнём с основ. Приготовьтесь: кроличья нора окажется глубже, чем кажется.

https://habr.com/ru/articles/1024862/

#x86 #assembly #NASM #div #partial_register_merge #latency #throughput #микроархитектура #Skylake #оптимизация

Google Sheets actually has a ton of Excel compatible functions; wish the User Experience was better though

I have been using Microsoft Excel since it beat the Quattro Pro limitation of rows and columns with the version 12.0, on Windows more commonly named Excel 2007 (which also introduced a fully new user experience including the vertical screen estate eating Ribbon – the main reason I like 16:10 monitors over 16:9 ones) and on Mac as Excel 2008.

It means I have like 20 years of Excel experience not just on what it can technically can do (see my Excel posts) but especially on the user experience bit.

Google Sheets is lacking on the latter, which makes it way more time consuming on the latter, but on the former, it has a lot of functions.

Another big difference is separate formatting for time duration, otherwise adding time stamps will give very strange results.

For this little example that I shared with a wind orchestra for planning purposes earlier this year: docs.google.com/spreadsheets/d/1zlKTP9nlhF04bQIQJBBDxnVMz9pzl9sxm9o-5sBL9FQ/view.

The functions and formatting used there:

• [Wayback/Archive] SUMIF – Google Docs Editors Help
  • [Wayback/Archive] How To Use the SUMIF Google Sheets Function (3 Easy Examples)
• [Wayback/Archive] SUMIFS function – Google Docs Editors Help
  • [Wayback/Archive] An Easy SUMIFS Google Sheets Guide [With Examples]
• [Wayback/Archive] How To Add Time in Google Sheets [4+ Easy Ways] | SSP
  
• Select the timestamp cells
• Go to “Format” > “Number“
• Choose “Duration“

Since [Wayback/Archive] The Best Way to Add or Subtract Time In Google Sheets (without Functions) – YouTube (which is now a private video) failed for me in the sense that it had overflow and formatting issues, I went with the SUM and SUMIF functions which worked fine. Not sure what I did wrong, but hey (:

Queries:

• [Wayback/Archive] google sheets sumif at DuckDuckGo
• [Wayback/Archive] google sheets sumifs at DuckDuckGo
• [Wayback/Archive] google sheets add time values at DuckDuckGo

Related blog posts:

• Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
• How to aggregate (count/sum/average) cells and ignore the #div/0! ‘s – via: list of functions by Excel version

--jeroen

Was mache ich am heutigen #DIDay?

#diday #div #did