How can I change my Pyramid Math

[Jack-P-Winner]

Presently I add the date and the following does a calculation which is called Pyramid Math on the 9/10 scale. When you add numbers together you never carry over so 7+7= 4 not 14, 9+6=5 not 15. You only use the ones position.
When you put in the date you would add it as follows
D15+E15= E14
E14+F15=F14
F14+G15=G14
G14+H15=H14
H14+I15=I14
J15+K15=J14 (The end digits adds the two ends instead of diagonal)

next level up

J15+I15=I13
I13+H14=H13
H13+G14=G13
G13+F13=G12

next level up

F13+G13=G12
H13+I13=H12

next level up
G12+H12=H11

Under the date
J15+K15=J16
J16+I15=I16
I16+H15=H16
H16+G15=G16
G16+F15=F16
D15+E15=E16

next level down

E16+F16=F17
F17+G16=G17
G17+H16=H17
I16+J16=I17

next kevel down

H17+I17=H18
F17+G17=G18
G18+H18=G19

The top Pyramid 11:19 adds and 24:32 subtracts

What I want to be able to do is instead of putting the date in B13 I want to able to put in 7 digits up to the number 9 in any combination like 154245879 or 132457849 for example and have the pyramid run the math. Thanks ya'll for helping me!!!

 

[Luke M]

Hi Jack,

First, I tried to simplify the formulas via MOD function to understand what was going on. Was doing pretty well until I got to the subtraction side. Sometimes the logic seems to be "take previous row number, subtract number beside" and sometimes it was reverse "take number beside, subtract from previous row". Which was is correct?

Also, instead of saying the formulas you already have, if you tell us what the overall goal is in words, that will help us think outside the given box and come up with more solutions possibly. In the attached, at least the for the addition one, you'll see that I've made it so you can give any type of input now, not just dates. Currently set for numbers. CHange B15 to say:
MMDDYYYY
if you want dates.

 

[Jack-P-Winner]

Let me ponder how to explain this. I stated working on the spreadsheet and may have it figured out. Pyramid math is hard to explain without watching a video on it which can be long and boring lol