NÄRINGSBERÄKNING

NÄRINGSBERÄKNING I EXCEL

Det här är en enklare form av det näringsberäkningsprogramm i Excel, som jag själv använder. Jag kommer inte att förklara Excel, utan jag förutsätter att du antingen behärskar Excel, känner nå´n som gör det eller skaffar dig kunskaper i det. Rubriker och formler i nedanstående tabell skall skrivas in i Excel, förutom radnummer och kolumnbokstäver, såklart. Fördelen med att ange varans mängd på ett ställe, istället för att slå alla tabellvärden multiplicerat med t.ex. 0,5 är väl uppenbar, det går mycket snabbare att kunna mata in tabellvärden direkt, men det finns en fördel till. Om du vill ändra mängden av en vara slipper du mata in alla tabellvärden en andra gång (denna gång kanske multiplicerade med 0,7). Fördelen med att ha en referensrad, med energigivarna angivna i Energiprocent, är att du snabbt ser att du har lagom med t.ex. protein i en måltid, oavsett måltidens energihalt.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ CR CS CT

1

2 Vara Mängd i hg Energi i kJ/hg kJ i vara Kolhydrater/hg (g) kolhydrater i vara (g) fett/hg (g) fett i vara (g) protein/hg (g) protein i vara (g) fibrer/hg (g) fibrer i vara (g) sockerarter/hg (g) sockerarter i vara (g) summa mättat-fett/hg (g) summa mättat-fett i vara (g) fettsyra 16:1,n-7/hg (g) fettsyra 16:1,n-7 i vara (g) fettsyra 18:1,n-9/hg (g) fettsyra 18:1,n-9 i vara (g) summa fleromättat-fett/hg (g) summa fleromättat-fett i vara (g) fettsyra 18:3,n-3/hg (g) fettsyra 18:3,n-3 i vara (g) EPA (fettsyra 20:5,n-3)/hg (g) EPA (fettsyra 20:5,n-3) i vara (g) DPA (fettsyra 22:5,n-3+n-6)/hg (g) DPA (fettsyra 22:5,n-3+n-6) i vara(g) DHA (fettsyra 22:6,n-3)/hg (g) DHA (fettsyra 22:6,n-3) i vara (g) summa n-3 i vara (g) kolesterol/hg (mg) kolesterol i vara (mg) Vitamin A/hg (µg) Vitamin A i vara (µg) Vitamin D/hg (µg) Vitamin D i vara (µg) Vitamin E/hg (mg) Vitamin E i vara (mg) Tiamin/hg (mg) Tiamin i vara (mg) Riboflavin/hg (mg) Riboflavin i vara (mg) Vitamin C/hg (mg) Vitamin C i vara (mg) Niacin ekvivalenter/hg (mg) Niacin ekvivalenter i vara (mg) Vitamin B6/hg (mg) Vitamin B6 i vara (mg) Vitamin B12/hg (µg) Vitamin B12 i vara (µg) Folat/hg (µg) Folat i vara (µg) Fosfor/hg (mg) Fosfor i vara (mg) Jod/hg (µg) Jod i vara (µg) Järn/hg (mg) Järn i vara (mg) Kalcium/hg (mg) Kalcium i vara (mg) Kalium/hg (mg) Kalium i vara (mg) Magnesium/hg (mg) Magnesium i vara (mg) Selén/hg (µg) Selén i vara (µg) Zink/hg (mg) Zink i vara (mg) Isoleucin/hg (mg) Isoleucin i vara (mg) Leucin/hg (mg) Leucin i vara (mg) Lysin/hg (mg) Lysin i vara (mg) Metionin/hg (mg) Metionin i vara (mg) Cystein/hg (mg) Cystein i vara (mg) Summa Svavel Aminosyror i vara (mg) Fenylalanin/hg (mg) Fenylalanin i vara (mg) Tyrosin/hg (mg) Tyrosin i vara (mg) Summa Aromatiska Aminosyror i vara (mg) Treonin/hg (mg) Treonin i vara (mg) Tryptofan/hg (mg) Tryptofan i vara (mg) Valin/hg (mg) Valin i vara (mg) Histidin/hg (mg) Histidin i vara (mg) Protein kvalité BCAA i vara (mg) EAA i vara (mg) Svavel i vara (mg) mVal i vara

3

=B3*C3
=B3*E3
=B3*G3
=B3*I3
=B3*K3
=B3*M3
=B3*O3
=B3*Q3
=B3*S3
=B3*U3
=B3*W3
=B3*Y3
=B3*AA3
=B3*AC3 =(X3+Z3+AD3)+(0.5*AB3)
=B3*AF3
=B3*AH3
=B3*AJ3
=B3*AL3
=B3*AN3
=B3*AP3
=B3*AR3
=B3*AT3
=B3*AV3
=B3*AX3
=B3*AZ3
=B3*BB3
=B3*BD3
=B3*BF3
=B3*BH3
=B3*BJ3
=B3*BL3
=B3*BN3
=B3*BP3
=B3*BR3
=B3*BT3
=B3*BV3
=B3*BX3
=B3*BZ3 =BY3+CA3
=B3*CC3
=B3*CE3 =CD3+CF3
=B3*CH3
=B3*CJ3
=B3*CL3
=B3*CN3 e.a. =BS3+BU3+CM3 =BS3+BU3+BW3
+CB3+CG3+CI3
+CK3+CM3+CO3 =CB3*0,233 =(BC3*-0,09686)+(BI3*0,0499)
+(BK3*0,02557)+(CS3*-0,06236)

4

=B4*C4
=B4*E4
=B4*G4
=B4*I4
=B4*K4
=B4*M4
=B4*O4
=B4*Q4
=B4*S4
=B4*U4
=B4*W4
=B4*Y4
=B4*AA4
=B4*AC4 =(X4+Z4+AD4)+(0.5*AB4)
=B4*AF4
=B4*AH4
=B4*AJ4
=B4*AL4
=B4*AN4
=B4*AP4
=B4*AR4
=B4*AT4
=B4*AV4
=B4*AX4
=B4*AZ4
=B4*BB4
=B4*BD4
=B4*BF4
=B4*BH4
=B4*BJ4
=B4*BL4
=B4*BN4
=B4*BP4
=B4*BR4
=B4*BT4
=B4*BV4
=B4*BX4
=B4*BZ4 =BY4+CA4
=B4*CC4
=B4*CE4 =CD4+CF4
=B4*CH4
=B4*CJ4
=B4*CL4
=B4*CN4 e.a. =BS4+BU4+CM4 =BS4+BU4+BW4
+CB4+CG4+CI4
+CK4+CM4+CO4 =CB4*0,233 =(BC4*-0,09686)+(BI4*0,0499)
+(BK4*0,02557)+(CS4*-0,06236)

5

=B5*C5
=B5*E5
=B5*G5
=B5*I5
=B5*K5
=B5*M5
=B5*O5
=B5*Q5
=B5*S5
=B5*U5
=B5*W5
=B5*Y5
=B5*AA5
=B5*AC5 =(X5+Z5+AD5)+(0.5*AB5)
=B5*AF5
=B5*AH5
=B5*AJ5
=B5*AL5
=B5*AN5
=B5*AP5
=B5*AR5
=B5*AT5
=B5*AV5
=B5*AX5 BR =B5*AZ5
=B5*BB5
=B5*BD5
=B5*BF5
=B5*BH5
=B5*BJ5
=B5*BL5
=B5*BN5
=B5 *BP5
=B5*BR5
=B5*BT5
=B5*BV5
=B5*BX5
=B5*BZ5 =BY5+CA5
=B5*CC5
=B5*CE5 =CD5+CF5
=B5*CH5
=B5*CJ5
=B5*CL5
=B5*CN5 e.a. =BS5+BU5+CM5 =BS5+BU5+BW5
+CB5,CG5,CI5
+CK5+CM5+CO5 =CB5*0,233 =(BC5*-0,09686)+(BI5*0,0499)
+(BK5*0,02557)+(CS5*-0,06236)

6

=B6*C6
=B6*E6
=B6*G6
=B6*I6
=B6*K6
=B6*M6
=B6*O6
=B6*Q6
=B6*S6
=B6*U6
=B6*W6
=B6*Y6
=B6*AA6
=B6*AC6 =(X6+Z6+AD6)+(0.5*AB6)
=B6*AF6
=B6*AH6
=B6*AJ6
=B6*AL6
=B6*AN6
=B6*AP6
=B6*AR6
=B6*AT6
=B6*AV6
=B6*AX6 BR =B6*AZ6
=B6*BB6
=B6*BD6
=B6*BF6
=B6*BH6
=B6*BJ6
=B6*BL6
=B6*BN6
=B6 *BP6
=B6*BR6
=B6*BT6
=B6*BV6
=B6*BX6
=B6*BZ6 =BY6+CA6
=B6*CC6
=B6*CE6 =CD6+CF6
=B6*CH6
=B6*CJ6
=B6*CL6
=B6*CN6 e.a. =BS6+BU6+CM6 =BS6+BU6+BW6
+CB6,CG6,CI6
+CK6+CM6+CO6 =CB6*0,233 =(BC6*-0,09686)+(BI6*0,0499)
+(BK6*0,02557)+(CS6*-0,06236)

7

=B7*C7
=B7*E7
=B7*G7
=B7*I7
=B7*K7
=B7*M7
=B7*O7
=B7*Q7
=B7*S7
=B7*U7
=B7*W7
=B7*Y7
=B7*AA7
=B7*AC7 =(X7+Z7+AD7)+(0.5*AB7)
=B7*AF7
=B7*AH7
=B7*AJ7
=B7*AL7
=B7*AN7
=B7*AP7
=B7*AR7
=B7*AT7
=B7*AV7
=B7*AX7
=B7*AZ7
=B7*BB7
=B7*BD7
=B7*BF7
=B7*BH7
=B7*BJ7
=B7*BL7
=B7*BN7
=B7*BP7
=B7*BR7
=B7*BT7
=B7*BV7
=B7*BX7
=B7*BZ7 =BY7+CA7
=B7*CC7
=B7*CE7 =CD7+CF7
=B7*CH7
=B7*CJ7
=B7*CL7
=B7*CN7 e.a. =BS7+BU7+CM7 =BS7+BU7+BW7
+CB7,CG7,CI7
+CK7+CM7+CO7 =CB7*0,233 =(BC7*-0,09686)+(BI7*0,0499)
+(BK7*0,02557)+(CS7*-0,06236)

8

=B8*C8
=B8*E8
=B8*G8
=B8*I8
=B8*K8
=B8*M8
=B8*O8
=B8*Q8
=B8*S8
=B8*U8
=B8*W8
=B8*Y8/TD>
=B8*AA8
=B8*AC8 =(X8+Z8+AD8)+(0.5*AB8)
=B8*AF8
=B8*AH8
=B8*AJ8
=B8*AL8
=B8*AN8
=B8*AP8
=B8*AR8
=B8*AT8
=B8*AV8
=B8*AX8
=B8*AZ8
=B8*BB8
=B8*BD8
=B8*BF8
=B8*BH8
=B8*BJ8
=B8*BL8
=B8*BN8
=B8*BP8
=B8*BR8
=B8*BT8
=B8*BV8
=B8*BX8
=B8*BZ8 =BY8+CA8
=B8*CC8
=B8*CE8 =CD8+CF8
=B8*CH8
=B8*CJ8
=B8*CL8
=B8*CN8 e.a. =BS8+BU8+CM8 =BS8+BU8+BW8
+CB8,CG8,CI8
+CK8+CM8+CO8 =CB8*0,233 =(BC8*-0,09686)+(BI8*0,0499)
+(BK8*0,02557)+(CS8*-0,06236)

9

=B9*C9
=B9*E9
=B9*G9
=B9*I9
=B9*K9
=B9*M9
=B9*O9
=B9*Q9
=B9*S9
=B9*U9
=B9*W9
=B9*Y9
=B9*AA9
=B9*AC9 =(X9+Z9+AD9)+(0.5*AB9)
=B9*AF9
=B9*AH9
=B9*AJ9
=B9*AL9
=B9*AN9
=B9*AP9
=B9*AR9
=B9*AT9
=B9*AV9
=B9*AX9
=B9*AZ9
=B9*BB9
=B9*BD9
=B9*BF9
=B9*BH9
=B9*BJ9
=B9*BL9
=B9*BN9
=B9*BP9
=B9*BR9
=B9*BT9
=B9*BV9
=B9*BX9
=B9*BZ9 =BY9+CA9
=B9*CC9
=B9*CE9 =CD9+CF9
=B9*CH9
=B9*CJ9
=B9*CL9
=B9*CN9 e.a. =BS9+BU9+CM9 =BS9+BU9+BW9
+CB9,CG9,CI9
+CK9+CM9+CO9 =CB9*0,233 =(BC9*-0,09686)+(BI9*0,0499)
+(BK9*0,02557)+(CS9*-0,06236)

10

=B10*C10
=B10*E10
=B10*G10
=B10*I10
=B10*K10
=B10*M10
=B10*O10
=B10*Q10
=B10*S10
=B10*U10
=B10*W10
=B10*Y10
=B10*AA10
=B10*AC10 =(X10+Z10+AD10)+(0.5*AB10)
=B10*AF10
=B10*AH10
=B10*AJ10
=B10*AL10
=B10*AN10
=B10*AP10
=B10*AR10
=B10*AT10
=B10*AV10
=B10*AX10
=B10*AZ10
=B10*BB10
=B10*BD10
=B10*BF10
=B10*BH10
=B10*BJ10
=B10*BL10
=B10*BN10
=B10*BP10
=B10*BR10
=B10*BT10
=B10*BV10
=B10*BX10
=B10*BZ10 =BY10+CA10
=B10*CC10
=B10*CE10 =CD10+CF10
=B10*CH10
=B10*CJ10
=B10*CL10
=B10*CN10 e.a. =BS10+BU10+CM10 =BS10+BU10+BW10
+CB10,CG10,CI10
+CK10+CM10+CO10 =CB10*0,233 =(BC10*-0,09686)+(BI10*0,0499)
+(BK10*0,02557)+(CS10*-0,06236)

11

=B11*C11
=B11*E11
=B11*G11
=B11*I11
=B11*K11
=B11*M11
=B11*O11
=B11*Q11
=B11*S11
=B11*U11
=B11*W11
=B11*Y11
=B11*AA11
=B11*AC11 =(X11+Z11+AD11)+(0.5*AB11)
=B11*AF11
=B11*AH11
=B11*AJ11
=B11*AL11
=B11*AN11
=B11*AP11
=B11*AR11
=B11*AT11
=B11*AV11
=B11*AX11
=B11*AZ11
=B11*BB11
=B11*BD11
=B11*BF11
=B11*BH11
=B11*BJ11
=B11*BL11
=B11*BN11
=B11*BP11
=B11*BR11
=B11*BT11
=B11*BV11
=B11*BX11
=B11*BZ11 =BY11+CA11
=B11*CC11
=B11*CE11 =CD11+CF11
=B11*CH11
=B11*CJ11
=B11*CL11
=B11*CN11 e.a. =BS11+BU11+CM11 =BS11+BU11+BW11
+CB11,CG11,CI11
+CK11+CM11+CO11 =CB11*0,233 =(BC11*-0,09686)+(BI11*0,0499)
+(BK11*0,02557)+(CS11*-0,06236)

12

=B12*C12
=B12*E12
=B12*G12
=B12*I12
=B12*K12
=B12*M12
=B12*O12
=B12*Q12
=B12*S12
=B12*U12
=B12*W12
=B12*Y12
=B12*AA12
=B12*AC12 =(X12+Z12+AD12)+(0.5*AB12)
=B12*AF12
=B12*AH12
=B12*AJ12
=B12*AL12
=B12*AN12
=B12*AP12
=B12*AR12
=B12*AT12
=B12*AV12
=B12*AX12
=B12*AZ12
=B12*BB12
=B12*BD12
=B12*BF12
=B12*BH12
=B12*BJ12
=B12*BL12
=B12*BN12
=B12*BP12
=B12*BR12
=B12*BT12
=B12*BV12
=B12*BX12
=B12*BZ12 =BY12+CA12
=B12*CC12
=B12*CE12 =CD12+CF12
=B12*CH12
=B12*CJ12
=B12*CL12
=B12*CN12 e.a. =BS12+BU12+CM12 =BS12+BU12+BW12
+CB12,CG12,CI12
+CK12+CM12+CO12 =CB12*0,233 =(BC12*-0,09686)+(BI12*0,0499)
+(BK12*0,02557)+(CS12*-0,06236)

13

=B13*C13
=B13*E13
=B13*G13
=B13*I13
=B13*K13
=B13*M13
=B13*O13
=B13*Q13
=B13*S13
=B13*U13
=B13*W13
=B13*Y13
=B13*AA13
=B13*AC13 =(X13+Z13+AD13)+(0.5*AB13)
=B13*AF13
=B13*AH13
=B13*AJ13
=B13*AL13
=B13*AN13
=B13*AP13
=B13*AR13
=B13*AT13
=B13*AV13
=B13*AX13
=B13*AZ13
=B13*BB13
=B13*BD13
=B13*BF13
=B13*BH13
=B13*BJ13
=B13*BL13
=B13*BN13
=B13*BP13
=B13*BR13
=B13*BT13
=B13*BV13
=B13*BX13
=B13*BZ13 =BY13+CA13
=B13*CC13
=B13*CE13 =CD13+CF13
=B13*CH13
=B13*CJ13
=B13*CL13
=B13*CN13 e.a. =BS13+BU13+CM13 =BS13+BU13+BW13
+CB13,CG13,CI13
+CK13+CM13+CO13 =CB13*0,233 =(BC13*-0,09686)+(BI13*0,0499)
+(BK13*0,02557)+(CS13*-0,06236)

14

=B14*C14
=B14*E14
=B14*G14
=B14*I14
=B14*K14
=B14*M14
=B14*O14
=B14*Q14
=B14*S14
=B14*U14
=B14*W14
=B14*Y14
=B14*AA14
=B14*AC14 =(X14+Z14+AD14)+(0.5*AB14)
=B14*AF14
=B14*AH14
=B14*AJ14
=B14*AL14
=B14*AN14
=B14*AP14
=B14*AR14
=B14*AT14
=B14*AV14
=B14*AX14
=B14*AZ14
=B14*BB14
=B14*BD14
=B14*BF14
=B14*BH14
=B14*BJ14
=B14*BL14
=B14*BN14
=B14*BP14
=B14*BR14
=B14*BT14
=B14*BV14
=B14*BX14
=B14*BZ14 =BY14+CA14
=B14*CC14
=B14*CE14 =CD14+CF14
=B14*CH14
=B14*CJ14
=B14*CL14
=B14*CN14 e.a. =BS14+BU14+CM14 =BS14+BU14+BW14
+CB14,CG14,CI14
+CK14+CM14+CO14 =CB14*0,233 =(BC14*-0,09686)+(BI14*0,0499)
+(BK14*0,02557)+(CS14*-0,06236)

15

=B15*C15
=B15*E15
=B15*G15
=B15*I15
=B15*K15
=B15*M15
=B15*O15
=B15*Q15
=B15*S15
=B15*U15
=B15*W15
=B15*Y15
=B15*AA15
=B15*AC15 =(X15+Z15+AD15)+(0.5*AB15)
=B15*AF15
=B15*AH15
=B15*AJ15
=B15*AL15
=B15*AN15
=B15*AP15
=B15*AR15
=B15*AT15
=B15*AV15
=B15*AX15
=B15*AZ15
=B15*BB15
=B15*BD15
=B15*BF15
=B15*BH15
=B15*BJ15
=B15*BL15
=B15*BN15
=B15*BP15
=B15*BR15
=B15*BT15
=B15*BV15
=B15*BX15
=B15*BZ15 =BY15+CA15
=B15*CC15
=B15*CE15 =CD15+CF15
=B15*CH15
=B15*CJ15
=B15*CL15
=B15*CN15 e.a. =BS15+BU15+CM15 =BS15+BU15+BW15
+CB15,CG15,CI15
+CK15+CM15+CO15 =CB15*0,233 =(BC15*-0,09686)+(BI15*0,0499)
+(BK15*0,02557)+(CS15*-0,06236)

16

=B16*C16
=B16*E16
=B16*G16
=B16*I16
=B16*K16
=B16*M16
=B16*O16
=B16*Q16
=B16*S16
=B16*U16
=B16*W16
=B16*Y16
=B16*AA16
=B16*AC16 =(X16+Z16+AD16)+(0.5*AB16)
=B16*AF16
=B16*AH16
=B16*AJ16
=B16*AL16
=B16*AN16
=B16*AP16
=B16*AR16
=B16*AT16
=B16*AV16
=B16*AX16
=B16*AZ16
=B16*BB16
=B16*BD16
=B16*BF16
=B16*BH16
=B16*BJ16
=B16*BL16
=B16*BN16
=B16*BP16
=B16*BR16
=B16*BT16
=B16*BV16
=B16*BX16
=B16*BZ16 =BY16+CA16
=B16*CC16
=B16*CE16 =CD16+CF16
=B16*CH16
=B16*CJ16
=B16*CL16
=B16*CN16 e.a. =BS16+BU16+CM16 =BS16+BU16+BW16
+CB16,CG16,CI16
+CK16+CM16+CO16 =CB16*0,233 =(BC16*-0,09686)+(BI16*0,0499)
+(BK16*0,02557)+(CS16*-0,06236)

17

=B17*C17
=B17*E17
=B17*G17
=B17*I17
=B17*K17
=B17*M17
=B17*O17
=B17*Q17
=B17*S17
=B17*U17
=B17*W17
=B17*Y17
=B17*AA17
=B17*AC17 =(X17+Z17+AD17)+(0.5*AB17)
=B17*AF17
=B17*AH17
=B17*AJ17
=B17*AL17
=B17*AN17
=B17*AP17
=B17*AR17
=B17*AT17
=B17*AV17
=B17*AX17
=B17*AZ17
=B17*BB17
=B17*BD17
=B17*BF17
=B17*BH17
=B17*BJ17
=B17*BL17
=B17*BN17
=B17*BP17
=B17*BR17
=B17*BT17
=B17*BV17
=B17*BX17
=B17*BZ17 =BY17+CA17
=B17*CC17
=B17*CE17 =CD17+CF17
=B17*CH17
=B17*CJ17
=B17*CL17
=B17*CN17 e.a. =BS17+BU17+CM17 =BS17+BU17+BW17
+CB17,CG17,CI17
+CK17+CM17+CO17 =CB17*0,233 =(BC17*-0,09686)+(BI17*0,0499)
+(BK17*0,02557)+(CS17*-0,06236)

18 Totalt i måltiden

=SUMMA(D3:D17)
=SUMMA(F3:F17)
=SUMMA(H3:H17)
=SUMMA(J3:J17)
=SUMMA(L3:L17)
=SUMMA(N3:N17)
=SUMMA(P3:P17)
=SUMMA(R3:R17)
=SUMMA(T3:T17)
=SUMMA(V3:V17)
=SUMMA(X3:X17)
=SUMMA(Z3:Z17)
=SUMMA(AB3:AB17)
=SUMMA(AD3:AD17) =SUMMA(AE3:AE17)
=SUMMA(AG3:AG17)
=SUMMA(AI3:AI17)
=SUMMA(AK3:AK17)
=SUMMA(AM3:AM17)
=SUMMA(AO3:AO17)
=SUMMA(AQ3:AQ17)
=SUMMA(AS3:AS17)
=SUMMA(AU3:AU17)
=SUMMA(AW3:AW17)
=SUMMA(AY3:AY17)
=SUMMA(BA3:BA17)
=SUMMA(BC3:BC17)
=SUMMA(BE3:BE17)
=SUMMA(BG3:BG17)
=SUMMA(BI3:BI17)
=SUMMA(BK3:BK17)
=SUMMA(BM3:BM17)
=SUMMA(BO3:BO17)
=SUMMA(BQ3:BQ17)
=SUMMA(BS3:BS17)
=SUMMA(BU3:BU17)
=SUMMA(BW3:BW17)
=SUMMA(BY3:BY17)
=SUMMA(CA3:CA17) =SUMMA(CB3:CB17)
=SUMMA(CD3:CD17)
=SUMMA(CF3:CF17) =SUMMA(CG3:CG17)
=SUMMA(CI3:CI17)
=SUMMA(CK3:CK17)
=SUMMA(CM3:CM17)
=SUMMA(CO3:CO17) =SUMMA(CQ3:CQ17) =SUMMA(CR3:CR17) =SUMMA(CS3:CS17) =SUMMA(CT3:CT17)

19 REFERENS SORT

Kcal
E%
E%
E%
g/MJ
E%
E%
E%
E%
E%
E%
E%
E%
E% E%
mg/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/MJ
%Rek/g
%Rek/g
%Rek/g

%Rek/g

%Rek/g
%Rek/g
%Rek/g
%Rek/g
%Rek/g C.S. %Rek/g %Rek/g %Rek/MJ mVal/MJ

20 REFERENSTAL

=B18*0,239
=(F18*1700)/D18
=(H18*3800)/D18
=(J18*1700)/D18
=(L18*1000)/D18
=(N18*1700)/D18
=(P18*3800)/D18
=(R18*3800)/D18
=(T18*3800)/D18
=(V18*3800)/D18
=(X18*3800)/D18
=(Z18*3800)/D18
=(AB18*3800)/D18
=(AD18*3800)/D18 =(AE18*3800)/D18
=(AG18*1000)/D18
=AI18*100000)/(D18*80)
=(AK18*100000)/(D18*1,4)
=(AM18*100000)/(D18*0,9)
=(AO18*100000)/(D18*0,12)
=(AQ18*100000)/(D18*0,14)
=(AS18*100000)/(D18*8)
=(AU18*100000)/(D18*1,6)
=(AW18*100000)/(D18*0,13)
=(AY18*100000)/(D18*0,2)
=(BA*100000)/(D18*45)
=(BC18*100000)/(D18*80)
=(BE18*100000)/(D18*17)
=(BG18*100000)/(D18*1,6)
=(BI18*100000)/(D18*100)
=(BK18*100000)/(D18*350)
=(BM18*100000)/(D18*32)
=(BO18*100000)/(D18*5,7)
=(BQ18*100000)/(D18*1,2)
=(BS18*100)/(J18*31)
=(BU18*100)/(J18*61)
=(BW18*100)/(J18*48)

=(CB18*100)/(J18*24)

=(CG18*100)/(J18*41)
=(CI18*100)/(J18*25)
=(CK18*100)/(J18*6,6)
=(CM18*100)/(J18*40)
=(CO18*100)/(J18*16) =MIN(BS20,BV20,BW20,
CB20,CG20,CI20,
CK20,CM20,CO20) =(CQ18*100)/(J18*132) =(BS18*100)/(J18*293) =(CS18*10000)/(J18*CP20*24*0,233) =(CT18*1000)/D18

När du skrivit in ovanstående rubriker och formler, skrivskyddar du dem, men inte övriga celler. Tänk på att ange varans mängd i hg, d.v.s. 1g = 0,01 hg, 10g = 0,1 hg, 100g = 1hg. E% anger procentuell andel av energin, som kommer från respektive energigivare, även fiber anses numera bidra med energi, men anges i g/MJ. Följande värden kan vara bra att sikta på: Protein 20E%, Fett 20E%, Kolhydrater 55E%, Fiber 7g/MJ.
Idén är fri att använda för eget bruk, men idén får ej säljas. Idén först publicerad på denna hemsida 15 09 05

Tillbaka till startsidan

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT
1
2	Vara	Mängd i hg	Energi i kJ/hg	kJ i vara	Kolhydrater/hg (g)	kolhydrater i vara (g)	fett/hg (g)	fett i vara (g)	protein/hg (g)	protein i vara (g)	fibrer/hg (g)	fibrer i vara (g)	sockerarter/hg (g)	sockerarter i vara (g)	summa mättat-fett/hg (g)	summa mättat-fett i vara (g)	fettsyra 16:1,n-7/hg (g)	fettsyra 16:1,n-7 i vara (g)	fettsyra 18:1,n-9/hg (g)	fettsyra 18:1,n-9 i vara (g)	summa fleromättat-fett/hg (g)	summa fleromättat-fett i vara (g)	fettsyra 18:3,n-3/hg (g)	fettsyra 18:3,n-3 i vara (g)	EPA (fettsyra 20:5,n-3)/hg (g)	EPA (fettsyra 20:5,n-3) i vara (g)	DPA (fettsyra 22:5,n-3+n-6)/hg (g)	DPA (fettsyra 22:5,n-3+n-6) i vara(g)	DHA (fettsyra 22:6,n-3)/hg (g)	DHA (fettsyra 22:6,n-3) i vara (g)	summa n-3 i vara (g)	kolesterol/hg (mg)	kolesterol i vara (mg)	Vitamin A/hg (µg)	Vitamin A i vara (µg)	Vitamin D/hg (µg)	Vitamin D i vara (µg)	Vitamin E/hg (mg)	Vitamin E i vara (mg)	Tiamin/hg (mg)	Tiamin i vara (mg)	Riboflavin/hg (mg)	Riboflavin i vara (mg)	Vitamin C/hg (mg)	Vitamin C i vara (mg)	Niacin ekvivalenter/hg (mg)	Niacin ekvivalenter i vara (mg)	Vitamin B6/hg (mg)	Vitamin B6 i vara (mg)	Vitamin B12/hg (µg)	Vitamin B12 i vara (µg)	Folat/hg (µg)	Folat i vara (µg)	Fosfor/hg (mg)	Fosfor i vara (mg)	Jod/hg (µg)	Jod i vara (µg)	Järn/hg (mg)	Järn i vara (mg)	Kalcium/hg (mg)	Kalcium i vara (mg)	Kalium/hg (mg)	Kalium i vara (mg)	Magnesium/hg (mg)	Magnesium i vara (mg)	Selén/hg (µg)	Selén i vara (µg)	Zink/hg (mg)	Zink i vara (mg)	Isoleucin/hg (mg)	Isoleucin i vara (mg)	Leucin/hg (mg)	Leucin i vara (mg)	Lysin/hg (mg)	Lysin i vara (mg)	Metionin/hg (mg)	Metionin i vara (mg)	Cystein/hg (mg)	Cystein i vara (mg)	Summa Svavel Aminosyror i vara (mg)	Fenylalanin/hg (mg)	Fenylalanin i vara (mg)	Tyrosin/hg (mg)	Tyrosin i vara (mg)	Summa Aromatiska Aminosyror i vara (mg)	Treonin/hg (mg)	Treonin i vara (mg)	Tryptofan/hg (mg)	Tryptofan i vara (mg)	Valin/hg (mg)	Valin i vara (mg)	Histidin/hg (mg)	Histidin i vara (mg)	Protein kvalité	BCAA i vara (mg)	EAA i vara (mg)	Svavel i vara (mg)	mVal i vara
3				=B3*C3		=B3*E3		=B3*G3		=B3*I3		=B3*K3		=B3*M3		=B3*O3		=B3*Q3		=B3*S3		=B3*U3		=B3*W3		=B3*Y3		=B3*AA3		=B3*AC3	=(X3+Z3+AD3)+(0.5*AB3)		=B3*AF3		=B3*AH3		=B3*AJ3		=B3*AL3		=B3*AN3		=B3*AP3		=B3*AR3		=B3*AT3		=B3*AV3		=B3*AX3		=B3*AZ3		=B3*BB3		=B3*BD3		=B3*BF3		=B3*BH3		=B3*BJ3		=B3*BL3		=B3*BN3		=B3*BP3		=B3*BR3		=B3*BT3		=B3*BV3		=B3*BX3		=B3*BZ3	=BY3+CA3		=B3*CC3		=B3*CE3	=CD3+CF3		=B3*CH3		=B3*CJ3		=B3*CL3		=B3*CN3	e.a.	=BS3+BU3+CM3	=BS3+BU3+BW3 +CB3+CG3+CI3 +CK3+CM3+CO3	=CB3*0,233	=(BC3-0,09686)+(BI30,0499) +(BK30,02557)+(CS3-0,06236)
4				=B4*C4		=B4*E4		=B4*G4		=B4*I4		=B4*K4		=B4*M4		=B4*O4		=B4*Q4		=B4*S4		=B4*U4		=B4*W4		=B4*Y4		=B4*AA4		=B4*AC4	=(X4+Z4+AD4)+(0.5*AB4)		=B4*AF4		=B4*AH4		=B4*AJ4		=B4*AL4		=B4*AN4		=B4*AP4		=B4*AR4		=B4*AT4		=B4*AV4		=B4*AX4		=B4*AZ4		=B4*BB4		=B4*BD4		=B4*BF4		=B4*BH4		=B4*BJ4		=B4*BL4		=B4*BN4		=B4*BP4		=B4*BR4		=B4*BT4		=B4*BV4		=B4*BX4		=B4*BZ4	=BY4+CA4		=B4*CC4		=B4*CE4	=CD4+CF4		=B4*CH4		=B4*CJ4		=B4*CL4		=B4*CN4	e.a.	=BS4+BU4+CM4	=BS4+BU4+BW4 +CB4+CG4+CI4 +CK4+CM4+CO4	=CB4*0,233	=(BC4-0,09686)+(BI40,0499) +(BK40,02557)+(CS4-0,06236)
5				=B5*C5		=B5*E5		=B5*G5		=B5*I5		=B5*K5		=B5*M5		=B5*O5		=B5*Q5		=B5*S5		=B5*U5		=B5*W5		=B5*Y5		=B5*AA5		=B5*AC5	=(X5+Z5+AD5)+(0.5*AB5)		=B5*AF5		=B5*AH5		=B5*AJ5		=B5*AL5		=B5*AN5		=B5*AP5		=B5*AR5		=B5*AT5		=B5*AV5		=B5*AX5	BR	=B5*AZ5		=B5*BB5		=B5*BD5		=B5*BF5		=B5*BH5		=B5*BJ5		=B5*BL5		=B5*BN5		=B5 *BP5		=B5*BR5		=B5*BT5		=B5*BV5		=B5*BX5		=B5*BZ5	=BY5+CA5		=B5*CC5		=B5*CE5	=CD5+CF5		=B5*CH5		=B5*CJ5		=B5*CL5		=B5*CN5	e.a.	=BS5+BU5+CM5	=BS5+BU5+BW5 +CB5,CG5,CI5 +CK5+CM5+CO5	=CB5*0,233	=(BC5-0,09686)+(BI50,0499) +(BK50,02557)+(CS5-0,06236)
6				=B6*C6		=B6*E6		=B6*G6		=B6*I6		=B6*K6		=B6*M6		=B6*O6		=B6*Q6		=B6*S6		=B6*U6		=B6*W6		=B6*Y6		=B6*AA6		=B6*AC6	=(X6+Z6+AD6)+(0.5*AB6)		=B6*AF6		=B6*AH6		=B6*AJ6		=B6*AL6		=B6*AN6		=B6*AP6		=B6*AR6		=B6*AT6		=B6*AV6		=B6*AX6	BR	=B6*AZ6		=B6*BB6		=B6*BD6		=B6*BF6		=B6*BH6		=B6*BJ6		=B6*BL6		=B6*BN6		=B6 *BP6		=B6*BR6		=B6*BT6		=B6*BV6		=B6*BX6		=B6*BZ6	=BY6+CA6		=B6*CC6		=B6*CE6	=CD6+CF6		=B6*CH6		=B6*CJ6		=B6*CL6		=B6*CN6	e.a.	=BS6+BU6+CM6	=BS6+BU6+BW6 +CB6,CG6,CI6 +CK6+CM6+CO6	=CB6*0,233	=(BC6-0,09686)+(BI60,0499) +(BK60,02557)+(CS6-0,06236)
7				=B7*C7		=B7*E7		=B7*G7		=B7*I7		=B7*K7		=B7*M7		=B7*O7		=B7*Q7		=B7*S7		=B7*U7		=B7*W7		=B7*Y7		=B7*AA7		=B7*AC7	=(X7+Z7+AD7)+(0.5*AB7)		=B7*AF7		=B7*AH7		=B7*AJ7		=B7*AL7		=B7*AN7		=B7*AP7		=B7*AR7		=B7*AT7		=B7*AV7		=B7*AX7		=B7*AZ7		=B7*BB7		=B7*BD7		=B7*BF7		=B7*BH7		=B7*BJ7		=B7*BL7		=B7*BN7		=B7*BP7		=B7*BR7		=B7*BT7		=B7*BV7		=B7*BX7		=B7*BZ7	=BY7+CA7		=B7*CC7		=B7*CE7	=CD7+CF7		=B7*CH7		=B7*CJ7		=B7*CL7		=B7*CN7	e.a.	=BS7+BU7+CM7	=BS7+BU7+BW7 +CB7,CG7,CI7 +CK7+CM7+CO7	=CB7*0,233	=(BC7-0,09686)+(BI70,0499) +(BK70,02557)+(CS7-0,06236)
8				=B8*C8		=B8*E8		=B8*G8		=B8*I8		=B8*K8		=B8*M8		=B8*O8		=B8*Q8		=B8*S8		=B8*U8		=B8*W8		=B8*Y8/TD>		=B8*AA8		=B8*AC8	=(X8+Z8+AD8)+(0.5*AB8)		=B8*AF8		=B8*AH8		=B8*AJ8		=B8*AL8		=B8*AN8		=B8*AP8		=B8*AR8		=B8*AT8		=B8*AV8		=B8*AX8		=B8*AZ8		=B8*BB8		=B8*BD8		=B8*BF8		=B8*BH8		=B8*BJ8		=B8*BL8		=B8*BN8		=B8*BP8		=B8*BR8		=B8*BT8		=B8*BV8		=B8*BX8		=B8*BZ8	=BY8+CA8		=B8*CC8		=B8*CE8	=CD8+CF8		=B8*CH8		=B8*CJ8		=B8*CL8		=B8*CN8	e.a.	=BS8+BU8+CM8	=BS8+BU8+BW8 +CB8,CG8,CI8 +CK8+CM8+CO8	=CB8*0,233	=(BC8-0,09686)+(BI80,0499) +(BK80,02557)+(CS8-0,06236)
9				=B9*C9		=B9*E9		=B9*G9		=B9*I9		=B9*K9		=B9*M9		=B9*O9		=B9*Q9		=B9*S9		=B9*U9		=B9*W9		=B9*Y9		=B9*AA9		=B9*AC9	=(X9+Z9+AD9)+(0.5*AB9)		=B9*AF9		=B9*AH9		=B9*AJ9		=B9*AL9		=B9*AN9		=B9*AP9		=B9*AR9		=B9*AT9		=B9*AV9		=B9*AX9		=B9*AZ9		=B9*BB9		=B9*BD9		=B9*BF9		=B9*BH9		=B9*BJ9		=B9*BL9		=B9*BN9		=B9*BP9		=B9*BR9		=B9*BT9		=B9*BV9		=B9*BX9		=B9*BZ9	=BY9+CA9		=B9*CC9		=B9*CE9	=CD9+CF9		=B9*CH9		=B9*CJ9		=B9*CL9		=B9*CN9	e.a.	=BS9+BU9+CM9	=BS9+BU9+BW9 +CB9,CG9,CI9 +CK9+CM9+CO9	=CB9*0,233	=(BC9-0,09686)+(BI90,0499) +(BK90,02557)+(CS9-0,06236)
10				=B10*C10		=B10*E10		=B10*G10		=B10*I10		=B10*K10		=B10*M10		=B10*O10		=B10*Q10		=B10*S10		=B10*U10		=B10*W10		=B10*Y10		=B10*AA10		=B10*AC10	=(X10+Z10+AD10)+(0.5*AB10)		=B10*AF10		=B10*AH10		=B10*AJ10		=B10*AL10		=B10*AN10		=B10*AP10		=B10*AR10		=B10*AT10		=B10*AV10		=B10*AX10		=B10*AZ10		=B10*BB10		=B10*BD10		=B10*BF10		=B10*BH10		=B10*BJ10		=B10*BL10		=B10*BN10		=B10*BP10		=B10*BR10		=B10*BT10		=B10*BV10		=B10*BX10		=B10*BZ10	=BY10+CA10		=B10*CC10		=B10*CE10	=CD10+CF10		=B10*CH10		=B10*CJ10		=B10*CL10		=B10*CN10	e.a.	=BS10+BU10+CM10	=BS10+BU10+BW10 +CB10,CG10,CI10 +CK10+CM10+CO10	=CB10*0,233	=(BC10-0,09686)+(BI100,0499) +(BK100,02557)+(CS10-0,06236)
11				=B11*C11		=B11*E11		=B11*G11		=B11*I11		=B11*K11		=B11*M11		=B11*O11		=B11*Q11		=B11*S11		=B11*U11		=B11*W11		=B11*Y11		=B11*AA11		=B11*AC11	=(X11+Z11+AD11)+(0.5*AB11)		=B11*AF11		=B11*AH11		=B11*AJ11		=B11*AL11		=B11*AN11		=B11*AP11		=B11*AR11		=B11*AT11		=B11*AV11		=B11*AX11		=B11*AZ11		=B11*BB11		=B11*BD11		=B11*BF11		=B11*BH11		=B11*BJ11		=B11*BL11		=B11*BN11		=B11*BP11		=B11*BR11		=B11*BT11		=B11*BV11		=B11*BX11		=B11*BZ11	=BY11+CA11		=B11*CC11		=B11*CE11	=CD11+CF11		=B11*CH11		=B11*CJ11		=B11*CL11		=B11*CN11	e.a.	=BS11+BU11+CM11	=BS11+BU11+BW11 +CB11,CG11,CI11 +CK11+CM11+CO11	=CB11*0,233	=(BC11-0,09686)+(BI110,0499) +(BK110,02557)+(CS11-0,06236)
12				=B12*C12		=B12*E12		=B12*G12		=B12*I12		=B12*K12		=B12*M12		=B12*O12		=B12*Q12		=B12*S12		=B12*U12		=B12*W12		=B12*Y12		=B12*AA12		=B12*AC12	=(X12+Z12+AD12)+(0.5*AB12)		=B12*AF12		=B12*AH12		=B12*AJ12		=B12*AL12		=B12*AN12		=B12*AP12		=B12*AR12		=B12*AT12		=B12*AV12		=B12*AX12		=B12*AZ12		=B12*BB12		=B12*BD12		=B12*BF12		=B12*BH12		=B12*BJ12		=B12*BL12		=B12*BN12		=B12*BP12		=B12*BR12		=B12*BT12		=B12*BV12		=B12*BX12		=B12*BZ12	=BY12+CA12		=B12*CC12		=B12*CE12	=CD12+CF12		=B12*CH12		=B12*CJ12		=B12*CL12		=B12*CN12	e.a.	=BS12+BU12+CM12	=BS12+BU12+BW12 +CB12,CG12,CI12 +CK12+CM12+CO12	=CB12*0,233	=(BC12-0,09686)+(BI120,0499) +(BK120,02557)+(CS12-0,06236)
13				=B13*C13		=B13*E13		=B13*G13		=B13*I13		=B13*K13		=B13*M13		=B13*O13		=B13*Q13		=B13*S13		=B13*U13		=B13*W13		=B13*Y13		=B13*AA13		=B13*AC13	=(X13+Z13+AD13)+(0.5*AB13)		=B13*AF13		=B13*AH13		=B13*AJ13		=B13*AL13		=B13*AN13		=B13*AP13		=B13*AR13		=B13*AT13		=B13*AV13		=B13*AX13		=B13*AZ13		=B13*BB13		=B13*BD13		=B13*BF13		=B13*BH13		=B13*BJ13		=B13*BL13		=B13*BN13		=B13*BP13		=B13*BR13		=B13*BT13		=B13*BV13		=B13*BX13		=B13*BZ13	=BY13+CA13		=B13*CC13		=B13*CE13	=CD13+CF13		=B13*CH13		=B13*CJ13		=B13*CL13		=B13*CN13	e.a.	=BS13+BU13+CM13	=BS13+BU13+BW13 +CB13,CG13,CI13 +CK13+CM13+CO13	=CB13*0,233	=(BC13-0,09686)+(BI130,0499) +(BK130,02557)+(CS13-0,06236)
14				=B14*C14		=B14*E14		=B14*G14		=B14*I14		=B14*K14		=B14*M14		=B14*O14		=B14*Q14		=B14*S14		=B14*U14		=B14*W14		=B14*Y14		=B14*AA14		=B14*AC14	=(X14+Z14+AD14)+(0.5*AB14)		=B14*AF14		=B14*AH14		=B14*AJ14		=B14*AL14		=B14*AN14		=B14*AP14		=B14*AR14		=B14*AT14		=B14*AV14		=B14*AX14		=B14*AZ14		=B14*BB14		=B14*BD14		=B14*BF14		=B14*BH14		=B14*BJ14		=B14*BL14		=B14*BN14		=B14*BP14		=B14*BR14		=B14*BT14		=B14*BV14		=B14*BX14		=B14*BZ14	=BY14+CA14		=B14*CC14		=B14*CE14	=CD14+CF14		=B14*CH14		=B14*CJ14		=B14*CL14		=B14*CN14	e.a.	=BS14+BU14+CM14	=BS14+BU14+BW14 +CB14,CG14,CI14 +CK14+CM14+CO14	=CB14*0,233	=(BC14-0,09686)+(BI140,0499) +(BK140,02557)+(CS14-0,06236)
15				=B15*C15		=B15*E15		=B15*G15		=B15*I15		=B15*K15		=B15*M15		=B15*O15		=B15*Q15		=B15*S15		=B15*U15		=B15*W15		=B15*Y15		=B15*AA15		=B15*AC15	=(X15+Z15+AD15)+(0.5*AB15)		=B15*AF15		=B15*AH15		=B15*AJ15		=B15*AL15		=B15*AN15		=B15*AP15		=B15*AR15		=B15*AT15		=B15*AV15		=B15*AX15		=B15*AZ15		=B15*BB15		=B15*BD15		=B15*BF15		=B15*BH15		=B15*BJ15		=B15*BL15		=B15*BN15		=B15*BP15		=B15*BR15		=B15*BT15		=B15*BV15		=B15*BX15		=B15*BZ15	=BY15+CA15		=B15*CC15		=B15*CE15	=CD15+CF15		=B15*CH15		=B15*CJ15		=B15*CL15		=B15*CN15	e.a.	=BS15+BU15+CM15	=BS15+BU15+BW15 +CB15,CG15,CI15 +CK15+CM15+CO15	=CB15*0,233	=(BC15-0,09686)+(BI150,0499) +(BK150,02557)+(CS15-0,06236)
16				=B16*C16		=B16*E16		=B16*G16		=B16*I16		=B16*K16		=B16*M16		=B16*O16		=B16*Q16		=B16*S16		=B16*U16		=B16*W16		=B16*Y16		=B16*AA16		=B16*AC16	=(X16+Z16+AD16)+(0.5*AB16)		=B16*AF16		=B16*AH16		=B16*AJ16		=B16*AL16		=B16*AN16		=B16*AP16		=B16*AR16		=B16*AT16		=B16*AV16		=B16*AX16		=B16*AZ16		=B16*BB16		=B16*BD16		=B16*BF16		=B16*BH16		=B16*BJ16		=B16*BL16		=B16*BN16		=B16*BP16		=B16*BR16		=B16*BT16		=B16*BV16		=B16*BX16		=B16*BZ16	=BY16+CA16		=B16*CC16		=B16*CE16	=CD16+CF16		=B16*CH16		=B16*CJ16		=B16*CL16		=B16*CN16	e.a.	=BS16+BU16+CM16	=BS16+BU16+BW16 +CB16,CG16,CI16 +CK16+CM16+CO16	=CB16*0,233	=(BC16-0,09686)+(BI160,0499) +(BK160,02557)+(CS16-0,06236)
17				=B17*C17		=B17*E17		=B17*G17		=B17*I17		=B17*K17		=B17*M17		=B17*O17		=B17*Q17		=B17*S17		=B17*U17		=B17*W17		=B17*Y17		=B17*AA17		=B17*AC17	=(X17+Z17+AD17)+(0.5*AB17)		=B17*AF17		=B17*AH17		=B17*AJ17		=B17*AL17		=B17*AN17		=B17*AP17		=B17*AR17		=B17*AT17		=B17*AV17		=B17*AX17		=B17*AZ17		=B17*BB17		=B17*BD17		=B17*BF17		=B17*BH17		=B17*BJ17		=B17*BL17		=B17*BN17		=B17*BP17		=B17*BR17		=B17*BT17		=B17*BV17		=B17*BX17		=B17*BZ17	=BY17+CA17		=B17*CC17		=B17*CE17	=CD17+CF17		=B17*CH17		=B17*CJ17		=B17*CL17		=B17*CN17	e.a.	=BS17+BU17+CM17	=BS17+BU17+BW17 +CB17,CG17,CI17 +CK17+CM17+CO17	=CB17*0,233	=(BC17-0,09686)+(BI170,0499) +(BK170,02557)+(CS17-0,06236)
18	Totalt i måltiden			=SUMMA(D3:D17)		=SUMMA(F3:F17)		=SUMMA(H3:H17)		=SUMMA(J3:J17)		=SUMMA(L3:L17)		=SUMMA(N3:N17)		=SUMMA(P3:P17)		=SUMMA(R3:R17)		=SUMMA(T3:T17)		=SUMMA(V3:V17)		=SUMMA(X3:X17)		=SUMMA(Z3:Z17)		=SUMMA(AB3:AB17)		=SUMMA(AD3:AD17)	=SUMMA(AE3:AE17)		=SUMMA(AG3:AG17)		=SUMMA(AI3:AI17)		=SUMMA(AK3:AK17)		=SUMMA(AM3:AM17)		=SUMMA(AO3:AO17)		=SUMMA(AQ3:AQ17)		=SUMMA(AS3:AS17)		=SUMMA(AU3:AU17)		=SUMMA(AW3:AW17)		=SUMMA(AY3:AY17)		=SUMMA(BA3:BA17)		=SUMMA(BC3:BC17)		=SUMMA(BE3:BE17)		=SUMMA(BG3:BG17)		=SUMMA(BI3:BI17)		=SUMMA(BK3:BK17)		=SUMMA(BM3:BM17)		=SUMMA(BO3:BO17)		=SUMMA(BQ3:BQ17)		=SUMMA(BS3:BS17)		=SUMMA(BU3:BU17)		=SUMMA(BW3:BW17)		=SUMMA(BY3:BY17)		=SUMMA(CA3:CA17)	=SUMMA(CB3:CB17)		=SUMMA(CD3:CD17)		=SUMMA(CF3:CF17)	=SUMMA(CG3:CG17)		=SUMMA(CI3:CI17)		=SUMMA(CK3:CK17)		=SUMMA(CM3:CM17)		=SUMMA(CO3:CO17)		=SUMMA(CQ3:CQ17)	=SUMMA(CR3:CR17)	=SUMMA(CS3:CS17)	=SUMMA(CT3:CT17)
19	REFERENS SORT			Kcal		E%		E%		E%		g/MJ		E%		E%		E%		E%		E%		E%		E%		E%		E%	E%		mg/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/MJ		%Rek/g		%Rek/g		%Rek/g					%Rek/g					%Rek/g		%Rek/g		%Rek/g		%Rek/g		%Rek/g	C.S.	%Rek/g	%Rek/g	%Rek/MJ	mVal/MJ
20	REFERENSTAL			=B18*0,239		=(F18*1700)/D18		=(H18*3800)/D18		=(J18*1700)/D18		=(L18*1000)/D18		=(N18*1700)/D18		=(P18*3800)/D18		=(R18*3800)/D18		=(T18*3800)/D18		=(V18*3800)/D18		=(X18*3800)/D18		=(Z18*3800)/D18		=(AB18*3800)/D18		=(AD18*3800)/D18	=(AE18*3800)/D18		=(AG18*1000)/D18		=AI18100000)/(D1880)		=(AK18100000)/(D181,4)		=(AM18100000)/(D180,9)		=(AO18100000)/(D180,12)		=(AQ18100000)/(D180,14)		=(AS18100000)/(D188)		=(AU18100000)/(D181,6)		=(AW18100000)/(D180,13)		=(AY18100000)/(D180,2)		=(BA100000)/(D1845)		=(BC18100000)/(D1880)		=(BE18100000)/(D1817)		=(BG18100000)/(D181,6)		=(BI18100000)/(D18100)		=(BK18100000)/(D18350)		=(BM18100000)/(D1832)		=(BO18100000)/(D185,7)		=(BQ18100000)/(D181,2)		=(BS18100)/(J1831)		=(BU18100)/(J1861)		=(BW18100)/(J1848)					=(CB18100)/(J1824)					=(CG18100)/(J1841)		=(CI18100)/(J1825)		=(CK18100)/(J186,6)		=(CM18100)/(J1840)		=(CO18100)/(J1816)	=MIN(BS20,BV20,BW20, CB20,CG20,CI20, CK20,CM20,CO20)	=(CQ18100)/(J18132)	=(BS18100)/(J18293)	=(CS1810000)/(J18CP20240,233)	=(CT18*1000)/D18