Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
101010.pl is one of the many independent Mastodon servers you can use to participate in the fediverse.
101010.pl czyli najstarszy polski serwer Mastodon. Posiadamy wpisy do 2048 znaków.

Administered by:

Server stats:

509
active users

101010.pl: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.0-alpha.5

#cusum

0 posts0 participants0 posts today
ExcelAnalytics<p><a href="https://sysmod.wordpress.com/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sysmod.wordpress.com/</span><span class="invisible"></span></a><br><a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Excel</span></a> <a href="https://mastodon.world/tags/dynamic" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dynamic</span></a> <a href="https://mastodon.world/tags/array" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>array</span></a> <a href="https://mastodon.world/tags/cumulative" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cumulative</span></a> sum<br>To calculate a 2-D array where each row is the <a href="https://mastodon.world/tags/cusum" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cusum</span></a> of each row in the source table, it’s possible to use the <a href="https://mastodon.world/tags/MMULT" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MMULT</span></a> function. The <a href="https://mastodon.world/tags/matrix" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>matrix</span></a> multiplication is done with an upper-right triangular array of 1s. But when you get to 1000 rows, the matrix is a million-cell array, and for 3000 rows or more, <a href="https://mastodon.world/tags/MSExcel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MSExcel</span></a> is going to go out of memory.<br>Here is an efficient method of doing this for a dynamic array cusum down columns.</p>
ExcelAnalytics<p><a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Excel</span></a> <a href="https://mastodon.world/tags/dynamic" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dynamic</span></a> <a href="https://mastodon.world/tags/array" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>array</span></a> <a href="https://mastodon.world/tags/cumulative" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cumulative</span></a> sum <a href="https://mastodon.world/tags/formulas" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>formulas</span></a> shootout </p><p><a href="https://sysmod.wordpress.com/2023/08/23/excel-dynamic-array-cumulative-sum/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">sysmod.wordpress.com/2023/08/2</span><span class="invisible">3/excel-dynamic-array-cumulative-sum/</span></a> </p><p>Different methods are evaluated to calculate cumulative sums in a 2D array efficiently. The fastest solution is obtained from a LinkedIn suggestion by Diarmuid Early, and a close second is from Peter Bartholomew.<br><a href="https://mastodon.world/tags/cusum" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cusum</span></a></p>
ExploreLive feeds
About