2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/d2e4753c3f511cfc6b2932ce60d0bc2e09296f9f 0 0 68147 254571 view1 2 8 0 0 0 0 2 0 0 0 0 0 80 60 true false 2 19 0 0 0 0 2 0 0 0 0 0 80 60 true false 18 19 0 0 0 0 2 0 0 0 0 0 80 60 true false Sheet2 1241 0 80 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn en US fr FR ru RU true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € . . WAHR WAHR FALSCH $ - $ € - € € - € руб. - руб. / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 GROWTH Function Result TRUE Sheet Result Description 1 TRUE Simple GROWTH formulas with local references and values Function Expected Correct FunctionString Comment Month Units Formula (Corresponding Units) 3 10.5 Value Bin1 Bin2 32618.2037735397 32618.2037735397 TRUE {=GROWTH(J2:J7,I2:I7)} 11 33100 32618 4 7.2 38 4 80 47729.4226147478 47729.4226147478 TRUE {=GROWTH(J2:J7,I2:I7)} 12 47300 47729 120 200 32 10 69841.3008562174 69841.3008562174 TRUE {=GROWTH(J2:J7,I2:I7)} 13 69000 69841 2 5.4 89 45 102197.073378832 102197.073378832 TRUE {=GROWTH(J2:J7,I2:I7)} 14 102000 102197 7.5 8.1 6 80 4 149542.486740046 149542.486740046 TRUE {=GROWTH(J2:J7,I2:I7)} 15 150000 149542 29 218821.876214596 218821.876214596 TRUE {=GROWTH(J2:J7,I2:I7)} 16 220000 218822 35 320196.718363473 320196.718363473 TRUE {=GROWTH(J2:J7,I2:I7,I9:I10)} Month Formula (Predicted Units) 99 468536.054184048 468536.054184048 TRUE {=GROWTH(J2:J7,I2:I7,I9:I10)} 17 320197 50 32618.2037735398 32618.2037735398 TRUE {=GROWTH(J2:J7)} 18 468536 41 47729.4226147478 47729.4226147478 TRUE {=GROWTH(J2:J7)} 88 69841.3008562174 69841.3008562174 TRUE {=GROWTH(J2:J7)} 8 102197.073378832 102197.073378832 TRUE {=GROWTH(J2:J7)} 40 149542.486740046 149542.486740046 TRUE {=GROWTH(J2:J7)} 3 218821.876214596 218821.876214596 TRUE {=GROWTH(J2:J7)} 95 32618.2037735397 32618.2037735397 TRUE {=GROWTH(J2:J7,I2:I7)} 2 47729.4226147478 47729.4226147478 TRUE {=GROWTH(J2:J7,I2:I7)} 96 69841.3008562174 69841.3008562174 TRUE {=GROWTH(J2:J7,I2:I7)} 25 102197.073378832 102197.073378832 TRUE {=GROWTH(J2:J7,I2:I7)} 67 149542.486740046 149542.486740046 TRUE {=GROWTH(J2:J7,I2:I7)} 13 218821.876214596 218821.876214596 TRUE {=GROWTH(J2:J7,I2:I7)} 17 1414600.72828845 1414600.72828845 TRUE {=GROWTH(J2:J7,I2:I7,I9:I10,0)} 95 3254137.27894144 3254137.27894144 TRUE {=GROWTH(J2:J7,I2:I7,I9:I10,0)} 76 7.34438054854886 7.34438054854886 TRUE =GROWTH(N1:N5,M1:M5) 79 4.02730745306701 4.02730745306701 TRUE =GROWTH({4,5,6}) 92 4.02730745306701 4.02730745306701 TRUE =GROWTH({4,5,6}, {10,20,30}) 97 4.45694834338361 4.45694834338361 TRUE =GROWTH({4,5,6}, {10,20,30}, {15,30,45}) 54 2.91343785655985 2.91343785655985 TRUE =GROWTH({4,5,6}, {10,20,30}, {15,30,45}, 0) 92 62 70 56 12 2 70 93 36 57 66 94 66 30 51 72 65 62 68 77 48 38 70 36 13 0 99 33 69 44 11 93 50 57 58 79 22 55 38 73 19 76 50 68 36 37 80 56 72 64 86 60 94 45 0 90 92 37 20 89 89 59 12 95 18 79 90 60 89 93 83 41 7 96 25 65 91 43 55 42 6 77 45 20 41 72 92 83 52 82 93 76 71 15 23 32 68 9 59 36 10 70 83 33 6 7 1 76 70 41 90 60 60 75 28 5 71 81 18 3 61 4 85 15 21 27 38 27 51 53 26 3 17 24 37 65 81 82 58 4 86 43 51 75 16 49 9 30 94 61 64 10 82 91 4 9 86 61 66 12 49 49 73 64 57 84 77 77 58 15 21 83 52 87 85 1 52 23 98 88 12 20 89 57 67 81 32 96 57 0 79 53 23 34 69 60 40 37 22 56 64 90 81 49 97 71 85 97 45 82 35 66 37 72 90 93 50 77 89 42 18 28 51 18 13 41 22 53 97 13 85 59 57 92 43 72 65 55 62 75 93 7 4 79 70 73 80 62 53 37 18 78 77 74 19 22 78 42 47 36 7 77 98 61 14 75 72 0 75 96 35 48 14 76 63 11 19 20 18 46 38 34 67 28 22 41 70 20 89 84 73 94 92 29 47 91 50 46 14 36 14 26 50 48 9 70 74 33 17 55 63 0 88 7 70 70 25 10 60 3 0 91 31 22 67 76 18 34 87 4 34 54 81 36 26 66 29 26 89 99 35 55 56 28 13 91 78 33 92 14 89 53 10 93 80 36 37 6 25 66 9 84 77 9 26 37 14 62 76 67 22 15 0 99 54 10 68 84 40 41 63 54 21 54 69 60 42 91 47 79 6 65 67 65 55 32 86 62 32 97 37 87 18 85 98 96 67 39 46 17 75 87 0 52 90 81 62 65 36 91 46 26 56 33 95 95 31 48 60 20 94 20 21 4 81 17 63 12 4 27 77 3 64 43 57 98 37 78 19 56 88 14 63 1 46 53 53 93 23 17 28 76 90 72 42 19 52 48 8 55 30 40 91 32 71 70 56 5 0 23 25 81 89 2 74 4 66 77 96 88 70 66 30 62 75 79 59 72 20 8 47 99 84 27 74 68 3 98 38 80 50 72 8 9 15 79 84 38 42 25 70 96 67 1 53 46 24 79 61 8 30 63 52 17 -7 -3 -2 -6 -7 2 4 -3 -2 -4 -3 0 -3 -1 3 -3 -3 -4 -3 0 0 1 -2 0 5 0 -4 -2 -5 1 -2 0 -4 -3 -4 5 0 -1 4 5 -1 0 -2 -2 -4 0 -5 0 -1 0 -2 -2 -4 0 -4 -8 -2 1 6 1 -6 0 -2 2 -5 -5 -2 1 -6 0 -2 2 -5 -5 -1 -1 1 -1 -1 -1 4 3 2 1 -3 -1 1 4 3 2 3 1 -3 4 O5 yes 1 no 2 yes 3