1eb02266-3e9c-40c1-9915-792a8da9b404 130 4 5 false false 0 decimal

&[DATE] &[TIME] - &[FILENAME]

Comparison of 2 methods to find Cumulative Sum of a Large Matrix

]]>

Super Fast

]]>

Very slow for large matices

]]>

Based on method of PompeTell

]]>

Program 1: To find cumulative totals q Cum_Tot1 q q mat2sys sys2mat : k 1 q rows range k 1 ≡ A k el q k el : A k el A k 1 - el q k el + : if for A eval 31 line :

Program 2: To find cumulative totals q Cum_Tot2 q q mat2sys sys2mat : j 1 q rows range CMT j el q n el n 1 j sum : for CMT eval 31 line :

Program 3: To find cumulative totals q Cum_Tot3 q q mat2sys sys2mat : j 1 q length range S j el q 1 j range el sum : for S eval 31 line :

2. Import rainfall data from EXCEL file

]]>

MyDirectory DocumentDirectory : C:\Users\Alvaro\Downloads\

MyFile MyDirectory Rainfal\005F\Data.xlsx concat :

Only a part is selected (Full range B7:B20826,

which may take an exceptionally very long time).

]]>

Read daily rainfall data file. Define correct cell range (in this case B7:B20826

]]>

DATA MyFile Sheet1 B7 B5826 importData.XLSX :

DATA rows 5820

DATA cols 1

DATA length 5820

4 appVersion 0.99.7109.29964

Program 1: To find cumulative totals q Cum_Tot1 q q mat2sys sys2mat : k 1 q rows range k 1 ≡ A k el q k el : A k el A k 1 - el q k el + : if for A eval 31 line :

t.0 1 time :

https://en.smath.com/forum/yaf_postsm48041_Making-Vector-Elements-Cumulative.aspx

Ans1 DATA Cum_Tot1 :

1 time t.0 - 2.8 s *

Ans1 rows 5820

Ans1 sum 133313912.1376

Program 5: To find cumulative totals q Cum_Tot4 Q q eval : A Clear A 1 el Q 1 el : k 2 Q rows range : A k el A k 1 - el Q k el + : eval 51 line :

t.0 1 time :

Ans4 DATA Cum_Tot4 :

1 time t.0 - 2.3 s *

Ans4 rows 5820

Ans4 sum 133313912.1376