Pie spreadsheet models

select text Here is how to verify the calculations using a spreadsheet.

Word	Word	Word	Word	Word	
Text	Letter	Letter	Letter	Word	Letters $ and Values #	
	Product	Count	Sum	Count	
A	=PRODUCT(G4:I4)	=COUNT(G4:I4)	=SUM(G4:I4)	1	A	1	
BAD	=PRODUCT(G5:M5)	=COUNT(G5:M5)	=SUM(G5:M5)	1	B	2	A	1	D	4	
CAB	=PRODUCT(G6:M6)	=COUNT(G6:M6)	=SUM(G6:M6)	1	C	3	A	1	B	2	
	
Phrase	Product	Number	Product	Number	
	Letters	Letters	Words	Words	
	=PRODUCT(B4:B6)	=SUM(C4:C6)	=PRODUCT(D4:D6)	=SUM(E4:E6)	
	
	Product		Number		Over	
	Letters		Letters		Product	
Over	=B10	*	=C10	=	=PRODUCT(B14:D14)	
Under	=D10	*	=E10	=	=PRODUCT(B15:D15)	
	Product		Number		Under	
	Words		Words		Product	
	
				Result=	=FIXED(F14/F15,10)

Select and copy the above text into the clipboard.
Paste the copied text into a new spreadsheet into cell A1.
Adjust the formatting and cell widths as desired.

select text Here is how to verify the calculations using a spreadsheet.

Word	Word	Word	Word	Word	
Text	Letter	Letter	Letter	Word	Letters $ and Values #	
	Product	Count	Sum	Count	
Ἐν	=PRODUCT(G4:K4)	=COUNT(G4:K4)	=SUM(G4:K4)	1	Ἐ	5	ν	50	
ἀρχῇι	=PRODUCT(G5:Q5)	=COUNT(G5:Q5)	=SUM(G5:Q5)	1	ἀ	1	ρ	100	χ	600	ῇ	8	ι	10	
ἦν	=PRODUCT(G6:K6)	=COUNT(G6:K6)	=SUM(G6:K6)	1	ἦ	8	ν	50	
ὁ	=PRODUCT(G7:I7)	=COUNT(G7:I7)	=SUM(G7:I7)	1	ὁ	70	
λόγος	=PRODUCT(G8:Q8)	=COUNT(G8:Q8)	=SUM(G8:Q8)	1	λ	30	ό	70	γ	3	ο	70	ς	200	
καὶ	=PRODUCT(G9:M9)	=COUNT(G9:M9)	=SUM(G9:M9)	1	κ	20	α	1	ὶ	10	
ὁ	=PRODUCT(G10:I10)	=COUNT(G10:I10)	=SUM(G10:I10)	1	ὁ	70	
λόγος	=PRODUCT(G11:Q11)	=COUNT(G11:Q11)	=SUM(G11:Q11)	1	λ	30	ό	70	γ	3	ο	70	ς	200	
ἦν	=PRODUCT(G12:K12)	=COUNT(G12:K12)	=SUM(G12:K12)	1	ἦ	8	ν	50	
πρὸς	=PRODUCT(G13:O13)	=COUNT(G13:O13)	=SUM(G13:O13)	1	π	80	ρ	100	ὸ	70	ς	200	
τὸν	=PRODUCT(G14:M14)	=COUNT(G14:M14)	=SUM(G14:M14)	1	τ	300	ὸ	70	ν	50	
θεόν	=PRODUCT(G15:O15)	=COUNT(G15:O15)	=SUM(G15:O15)	1	θ	9	ε	5	ό	70	ν	50	
καὶ	=PRODUCT(G16:M16)	=COUNT(G16:M16)	=SUM(G16:M16)	1	κ	20	α	1	ὶ	10	
θεὸς	=PRODUCT(G17:O17)	=COUNT(G17:O17)	=SUM(G17:O17)	1	θ	9	ε	5	ὸ	70	ς	200	
ἦν	=PRODUCT(G18:K18)	=COUNT(G18:K18)	=SUM(G18:K18)	1	ἦ	8	ν	50	
ὁ	=PRODUCT(G19:I19)	=COUNT(G19:I19)	=SUM(G19:I19)	1	ὁ	70	
λόγος	=PRODUCT(G20:Q20)	=COUNT(G20:Q20)	=SUM(G20:Q20)	1	λ	30	ό	70	γ	3	ο	70	ς	200	
	
Phrase	Product	Number	Product	Number	
	Letters	Letters	Words	Words	
	=PRODUCT(B4:B20)	=SUM(C4:C20)	=PRODUCT(D4:D20)	=SUM(E4:E20)	
	
	Product		Number		Over	
	Letters		Letters		Product	
Over	=B24	*	=C24	=	=PRODUCT(B28:D28)	
Under	=D24	*	=E24	=	=PRODUCT(B29:D29)	
	Product		Number		Under	
	Words		Words		Product	
	
				Result=	=FIXED(F28/F29,10)

Select and copy the above text into the clipboard.
Paste the copied text into a new spreadsheet into cell A1.
Adjust the formatting and cell widths as desired.

select text Here is how to verify the calculations using a spreadsheet.

Word	Word	Word	Word	Word	
Text	Letter	Letter	Letter	Word	Letters $ and Values #	
	Product	Count	Sum	Count	
בראשית	=PRODUCT(G4:S4)	=COUNT(G4:S4)	=SUM(G4:S4)	1	ב	2	ר	200	א	1	ש	300	י	10	ת	400	
ברא	=PRODUCT(G5:M5)	=COUNT(G5:M5)	=SUM(G5:M5)	1	ב	2	ר	200	א	1	
אלהים	=PRODUCT(G6:Q6)	=COUNT(G6:Q6)	=SUM(G6:Q6)	1	א	1	ל	30	ה	5	י	10	ם	40	
את	=PRODUCT(G7:K7)	=COUNT(G7:K7)	=SUM(G7:K7)	1	א	1	ת	400	
השמים	=PRODUCT(G8:Q8)	=COUNT(G8:Q8)	=SUM(G8:Q8)	1	ה	5	ש	300	מ	40	י	10	ם	40	
ואת	=PRODUCT(G9:M9)	=COUNT(G9:M9)	=SUM(G9:M9)	1	ו	6	א	1	ת	400	
הארץ	=PRODUCT(G10:O10)	=COUNT(G10:O10)	=SUM(G10:O10)	1	ה	5	א	1	ר	200	ץ	90	
	
Phrase	Product	Number	Product	Number	
	Letters	Letters	Words	Words	
	=PRODUCT(B4:B10)	=SUM(C4:C10)	=PRODUCT(D4:D10)	=SUM(E4:E10)	
	
	Product		Number		Over	
	Letters		Letters		Product	
Over	=B14	*	=C14	=	=PRODUCT(B18:D18)	
Under	=D14	*	=E14	=	=PRODUCT(B19:D19)	
	Product		Number		Under	
	Words		Words		Product	
	
				Result=	=FIXED(F18/F19,10)

Select and copy the above text into the clipboard.
Paste the copied text into a new spreadsheet into cell A1.
Adjust the formatting and cell widths as desired.