Main

related bits

0

processing priority

4

site type

3 (personal blog or private political site, e.g. Blogspot, Substack, also small blogs on own domains)

review version

11

html import

20 (imported)

Events

first seen date

2024-03-26 02:18:35

expired found date

-

created at

2024-06-19 00:11:28

updated at

2026-01-19 05:13:42

Domain name statistics

length

20

crc

14761

tld

2211

nm parts

0

nm random digits

0

nm rare letters

0

Connections

is subdomain of id

13642151 (wordpress.com)

previous id

0

replaced with id

0

related id

-

dns primary id

0

dns alternative id

0

lifecycle status

0 (unclassified, or currently active)

Subdomains and pages

deleted subdomains

0

page imported products

0

page imported random

0

page imported parking

0

Error counters

count skipped due to recent timeouts on the same server IP

0

count content received but rejected due to 11-799

0

count dns errors

0

count cert errors

0

count timeouts

0

count http 429

0

count http 404

0

count http 403

0

count http 5xx

0

next operation date

-

Server

server bits

server ip

-

Mainpage statistics

mp import status

20

mp rejected date

-

mp saved date

-

mp size orig

179864

mp size raw text

37858

mp inner links count

66

mp inner links status

20 (imported)

Open Graph

title

Patrick O'Beirne @ sysmod

description

Spreadsheet quality and testing

site name

Patrick O'Beirne @ sysmod

author

updated

2025-12-29 01:56:44

raw text

Patrick O'Beirne @ sysmod | Spreadsheet quality and testing Patrick O'Beirne @ sysmod Spreadsheet quality and testing Skip to content Home About ← Older posts Excel dynamic array cumulative sum Posted on Aug 23, 2023 by Patrick O'Beirne, Excel/VBA developer To calculate a 2-D array where each row is the cusum of each row in the source table, it’s possible to use the MMULT function. The matrix multiplication is done with an upper-right triangular array of 1s. That’s fine for a small number of columns, like 12. Using a lower-left matrix, you can calculate cusums down the columns. But when you get to 1000 rows, the matrix is a million-cell array, and for 3000 rows or more, Excel is going to go out of memory. I asked on LinkedIn for suggestions for an efficient method of doing this for a dynamic array cusum down columns. We have a winner. I have a dynamic array of 4000 rows and 4 columns in A3. A3# is =MAKEARRAY($K$1,4,LAMBDA(I,j,I*10+j)) K1 contains 4000 –...

Text analysis

redirect type

0 (-)

block type

0 (no issues)

detected language

1 (English)

category id

AI [en] (229)

index version

2025123101

spam phrases

0

Text statistics

text nonlatin

0

text cyrillic

0

text characters

27949

text words

6085

text unique words

1404

text lines

701

text sentences

247

text paragraphs

90

text words per sentence

24

text matched phrases

11

text matched dictionaries

7

RSS

rss status

32 (unknown)

rss found date

2024-03-26 02:18:35

rss size orig

80741

rss items

10

rss spam phrases

0

rss detected language

1 (English)

inbefore feed id

-

inbefore status

0 (new)

Sitemap

sitemap status

40 (completed successful import of reports.txt file to table in_pages)

sitemap review version

2

sitemap urls count

90

sitemap urls adult

0

sitemap filtered products

0

sitemap filtered videos

0

sitemap found date

2024-03-03 14:01:14

sitemap process date

2025-08-14 03:53:44

sitemap first import date

-

sitemap last import date

2026-01-19 05:13:42