2016-08-02T18:23:37.029031124P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/389b08190092f9a9103b3ac098994ec83b2d0bfa 0 0 69019 108983 view1 1 7 0 0 0 0 2 0 0 0 0 0 75 60 true false 2 87 0 0 0 0 2 0 0 0 195 0 75 60 true false Sheet1 1241 0 75 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 zxx en US fr FR ru RU true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= 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 LINEST Function Result TRUE Sheet Result Description 1 TRUE Simple LINEST formulas with local references and values Function Expected Correct FunctionString Comment x1 x2 y LINEST value Known y Known x Month Sales Floor space (x1) Offices (x2) Entrances (x3) Age (x4) Assessed value (y) 4.85714285714286 4.85714285714286 TRUE =K17 4 7 100 4,17 -3,48 82,33 1 0 1 3100 2310 2 20 142000 0.914732033918978 0.914732033918978 TRUE =K18 5 9 105 5,46 10,96 9,35 9 4 2 4500 2333 2 12 144000 0.849375459221161 0.849375459221161 TRUE =K19 6 11 104 0,87 5,06 #NA 5 2 3 4400 2356 3 1.5 33 151000 28.1951219512195 28.1951219512195 TRUE =K20 7 12 108 13,21 4 #NA 7 3 4 5400 2379 3 2 43 150000 660.571428571428 660.571428571428 TRUE =K21 8 15 111 675,45 102,26 #NA Result (slope) Result (y-intercept) 5 7500 2402 2 3 53 139000 77.5714285714286 77.5714285714286 TRUE =L17 9 17 120 2 1 6 8100 2425 4 2 23 169000 6.65934972617524 6.65934972617524 TRUE =L18 10 19 133 Formula (array formula in cells A7:B7) Formula Result 2448 2 1.5 99 126000 4.84030695602783 4.84030695602783 TRUE =L19 2 1 $11,000 2471 2 34 142900 5 5 TRUE =L20 Calculates the estimate of the sales in the ninth month, based on sales in months 2 through 6. 2494 3 23 163000 117.142857142857 117.142857142857 TRUE =L21 2517 4 55 169000 0.5 0.5 TRUE =LINEST({2,3,5,7,10},{4,6,10,14,20},1,0) 2540 2 3 22 149000 0.5 0.5 TRUE =K25 -234.2371645 0 0 TRUE =L25 13.26801148 2 2 TRUE =R9 0.996747993 1 1 TRUE =S9 459.7536742 10800 10800 TRUE =SUM(LINEST(V2:V6, U2:U6)*{9,1}) 4.85714285714286 77.5714285714286 1732393319 -234.237164471202 -234.237164471202 TRUE =K29 0.914732033918978 6.65934972617524 Formula (array formula entered in A14:A18) 13.2680114755004 13.2680114755004 TRUE =K30 0.849375459221161 4.84030695602783 Err:502 0.99674799338451 0.99674799338451 TRUE =K31 28.1951219512195 5 459.753674225393 459.753674225393 TRUE =K32 660.571428571428 117.142857142857 1732393319.22925 1732393319.22925 TRUE =K33 2553.21066039154 2553.21066039154 TRUE =L29 x1 x2 x3 y=-0.3*U24+7*T24-19*S24 x1 x2 x3 y=1.2*X24-2.3*Y24+3.4*Z24 530.669151930378 530.669151930378 TRUE =L30 0 0 0 0 0 5.1 2.1 -4.59 970.578462928506 970.578462928506 TRUE =L31 0.5 0 -2 4 -8 68.4 1 7 8 12.3 6 6 TRUE =L32 -1 1 -1 26.3 2 4 2 0 5652135.31620397 5652135.31620397 TRUE =L33 1 1 1 -12.3 -1 6 5.4 12529.7681670868 12529.7681670868 TRUE =M29 3 9 27 -2.1 6 3 0 0.3 400.066838193953 400.066838193953 TRUE =M30 -234.237164471202 2553.21066039154 12529.7681670868 27.6413873660203 52317.8305072913 5 25 125 42.5 #N/A error TRUE =M31 13.2680114755004 530.669151930378 400.066838193953 5.42937404154531 12237.3616028623 #N/A error TRUE =M32 0.99674799338451 970.578462928506 #N/A #N/A #N/A -0.3 7 -19 0 3.4 -2.3 1.2 0 #N/A error TRUE =M33 459.753674225393 6 #N/A #N/A #N/A 7.78386753299983E-16 3.12582706182415E-15 7.47872232821402E-15 #N/A 7.40094535217939E-15 1.82660844546218E-14 4.02893660475375E-15 7.2069683128199E-14 27.6413873660203 27.6413873660203 TRUE =N29 1732393319.22925 5652135.31620397 #N/A #N/A #N/A 1 2.09805716107385E-14 #N/A #N/A 1 1.21537732619395E-14 #N/A #N/A 5.42937404154531 5.42937404154531 TRUE =N30 5.5523702096735E+030 3 #N/A #N/A 3.73790456956461E+029 1 #N/A #N/A #N/A error TRUE =N31 7332.20000000001 1.32055315533997E-27 #N/A #N/A 165.64248 1.47714204502634E-28 #N/A #N/A #N/A error TRUE =N32 #N/A error TRUE =N33 52317.8305072913 52317.8305072913 TRUE =O29 12237.3616028623 12237.3616028623 TRUE =O30 #N/A error TRUE =O31 #N/A error TRUE =O32 #N/A error TRUE =O33 -0.3 -0.3 TRUE =S31 7.78386753299983E-16 7.78386753299983E-16 TRUE =S32 1 1 TRUE =S33 5.5523702096735E+030 5.5523702096735E+030 TRUE =S34 7332.20000000001 7332.20000000001 TRUE =S35 7 7 TRUE =T31 3.12582706182415E-15 3.12582706182415E-15 TRUE =T32 2.09805716107385E-14 2.09805716107385E-14 TRUE =T33 3 3 TRUE =T34 1.32055315533997E-27 1.32055315533997E-27 TRUE =T35 -19 -19 TRUE =U31 7.47872232821402E-15 7.47872232821402E-15 TRUE =U32 #N/A error TRUE =U33 #N/A error TRUE =U34 #N/A error TRUE =U35 0 0 TRUE =V31 #N/A error TRUE =V32 #N/A error TRUE =V33 #N/A error TRUE =V34 #N/A error TRUE =V35 3.4 3.4 TRUE =X31 7.40094535217939E-15 7.40094535217939E-15 TRUE =X32 1 1 TRUE =X33 3.73790456956461E+029 3.73790456956461E+029 TRUE =X34 165.64248 165.64248 TRUE =X35 -2.3 -2.3 TRUE =Y31 1.82660844546218E-14 1.82660844546218E-14 TRUE =Y32 1.21537732619395E-14 1.21537732619395E-14 TRUE =Y33 1 1 TRUE =Y34 1.47714204502634E-28 1.47714204502634E-28 TRUE =Y35 1.2 1.2 TRUE =Z31 4.02893660475375E-15 4.02893660475375E-15 TRUE =Z32 #N/A error TRUE =Z33 #N/A error TRUE =Z34 #N/A error TRUE =Z35 0 -1.73194791841524E-14 TRUE =AA31 0 7.2069683128199E-14 TRUE =AA32 #N/A error TRUE =AA33 #N/A error TRUE =AA34 7 100 #N/A error TRUE =AA35 9 105 66.5714285714286 66.5714285714286 TRUE =INDEX(LINEST(K83:K87,J83:J87),1,2) 11 104 0.460217718382158 0.460217718382158 TRUE =INDEX(LINEST(K83:K87,J83:J87^{1,2}),1,1) 12 108 2.44177215189873 2.44177215189873 TRUE =J89 15 111 0.460217718382158 0.460217718382158 TRUE =J90 17 120 80.1772151898734 80.1772151898734 TRUE =K89 19 133 -10.4180900964687 -10.4180900964687 TRUE =K90 164.458093636605 164.458093636605 TRUE =L90 2.44177215189873 80.1772151898734 0.994341547754605 0.994341547754605 TRUE =O93 0.460217718382158 -10.4180900964687 164.458093636605 0.007846000908183 0.007846000908183 TRUE =O94 0.999998850552028 0.999998850552028 TRUE =O95 2029957.60481605 2029957.60481605 TRUE =O96 1 6 0.666692 6.666692 0.994341547754605 2.12817454484602 2.30123312876209 0 3153007.95235537 3153007.95235537 TRUE =O97 2 4 8 22 −1.37614 20.62386 0.007846000908183 0.110686824028813 0.37209276413207 #N/A 2.12817454484602 2.12817454484602 TRUE =P93 3 9 27 54 −1.13891 52.86109 0.999998850552028 0.719545765557922 #N/A #N/A 0.110686824028813 0.110686824028813 TRUE =P94 4 16 64 108 −1.18741 106.8126 2029957.60481605 7 #N/A #N/A 0.719545765557922 0.719545765557922 TRUE =P95 5 25 125 190 −1.19113 188.8089 3153007.95235537 3.62422276112635 #N/A #N/A 7 7 TRUE =P96 6 36 216 306 −1.23125 304.7688 3.62422276112635 3.62422276112635 TRUE =P97 7 49 343 462 −0.30762 461.6924 2.30123312876209 2.30123312876209 TRUE =Q93 8 64 512 664 0.70592 664.7059 0.37209276413207 0.37209276413207 TRUE =Q94 9 81 729 918 −0.80582 917.1942 #N/A TRUE =Q95 aoo#112324 10 100 1000 1230 0.271383 1230.271 #N/A TRUE =Q96 #N/A TRUE =Q97 0 0 TRUE =R93 #N/A TRUE =R94 #N/A TRUE =R95 #N/A TRUE =R96 #N/A TRUE =R97 0.0011 0.0011 TRUE =M133 Aoo#109264 4.04849321602897E-17 4.04849321602897E-17 TRUE =M134 0.0306 0.000040 793.571428571433 -0.000778571428572 1 1 TRUE =M135 0.0393 0.000050 5.33567125627786 0.000388442730788 7.3824164159995E+026 7.3824164159995E+026 TRUE =M136 0.0469 0.000060 0.999774015875587 0.000282337184434 4.83999999999991E-07 4.83999999999991E-07 TRUE =M137 0.0549 0.000070 22120.4480286991 5 0.11 0.11 TRUE =N133 0.0626 0.000080 0.001763315714286 3.98571428570977E-07 1.13934698304003E-16 1.13934698304003E-16 TRUE =N134 0.0704 0.000090 2.56049193087833E-17 2.56049193087833E-17 TRUE =N135 0.0787 0.000100 3 3 TRUE =N136 1.96683567842791E-33 1.96683567842791E-33 TRUE =N137 0.993513073759398 0.993513073759398 TRUE =M141 Aoo#112447 0.012835202310614 0.012835202310614 TRUE =M142 0.0 0.93 0.9300 0 0.0 DV 0.2 0.997004784931993 0.997004784931993 TRUE =M143 0.2 0.90 0.9018 1 0.2 V0 100 5991.58515208592 5991.58515208592 TRUE =M144 0.4 0.84 0.8434 2 0.4 Vinc 1 656.400371441014 656.400371441014 TRUE =M145 0.6 0.72 0.7243 3 0.6 Ctitolante 0.005 0.998365537944251 0.998365537944251 TRUE =M146 0.8 0.68 0.6854 4 0.8 0.006044561390305 0.006044561390305 TRUE =M147 1.0 0.58 0.5858 5 1.0 0.999304012155418 0.999304012155418 TRUE =M148 1.2 0.50 0.5060 6 1.2 27280.3273487637 27280.3273487637 TRUE =M149 1.4 0.43 0.4360 7 1.4 2860.62585490803 2860.62585490803 TRUE =M150 1.6 0.33 0.3353 8 1.6 0.066317010526317 0.066317010526317 TRUE =N141 1.8 0.26 0.2647 9 1.8 0.15375479515727 0.15375479515727 TRUE =N142 2.0 0.19 0.1938 10 2.0 0.330988985021654 0.330988985021654 TRUE =N143 2.2 0.13 0.1329 11 2.2 RegLin 2^tra 18 18 TRUE =N144 2.4 0.11 0.1126 12 2.4 0.0011 0.11 1.97196674770196 1.97196674770196 TRUE =N145 2.6 0.11 0.1129 13 2.6 4.04849321602897E-17 1.13934698304003E-16 0 0 TRUE =N146 2.8 0.11 0.1131 14 2.8 1 2.56049193087833E-17 #N/A error TRUE =N147 3.0 0.11 0.1133 15 3.0 7.3824164159995E+026 3 0.323821545440303 0.323821545440303 TRUE =N148 3.2 0.11 0.1135 16 3.2 4.83999999999991E-07 1.96683567842791E-33 19 19 TRUE =N149 1.99234747253558 1.99234747253558 TRUE =N150 22 22 TRUE =I165 57 57 TRUE =I166 1 0.747893 0.993513073759398 0.066317010526317 7 7 TRUE =I167 2 1.818264 0.012835202310614 0.15375479515727 0 0 TRUE =I168 3 3.651207 0.997004784931993 0.330988985021654 1 1 TRUE =I169 4 3.859577 5991.58515208592 18 #N/A TRUE =I170 5 5.536406 656.400371441014 1.97196674770196 612.5 612.5 TRUE =I171 6 6.099020 0.998365537944251 0 3 3 TRUE =J165 7 7.351438 0.006044561390305 #N/A 8 8 TRUE =J166 8 7.581386 0.999304012155418 0.323821545440303 1 1 TRUE =J167 9 8.748781 27280.3273487637 19 0 0 TRUE =J168 10 10.196513 2860.62585490803 1.99234747253558 0 0 TRUE =J169 11 10.696322 0 0 TRUE =J170 12 12.178042 -6.99452631578947 -6.99452631578947 TRUE =M169 13 12.398021 0.002475683082978 0.002475683082978 TRUE =M170 14 13.956954 0.999999949709745 0.999999949709745 TRUE =M171 15 15.132228 9942283.62965002 9942283.62965002 TRUE =M172 16 15.838082 11577901.4177444 11577901.4177444 TRUE =M173 17 17.327514 4.11879699248141 4.11879699248141 TRUE =N169 18 18.071353 0.320748742445571 0.320748742445571 TRUE =N170 19 18.672921 0.763056773181177 0.763056773181177 TRUE =N171 20 20.102165 1 1 TRUE =N172 0.582255639097671 0.582255639097671 TRUE =N173 -108.083609022579 -108.083609022579 TRUE =O169 34.8435504725221 34.8435504725221 TRUE =O170 -10188 100 1500 #N/A error TRUE =O171 22 3 -6757 101 1010 #N/A error TRUE =O172 57 8 -6542 102 980 #N/A error TRUE =O173 7 1 -5761 105 870 -0.699789473684211 -0.699789473684211 TRUE =M182 0 0 0.000506389721518 0.000506389721518 TRUE =M183 1 0 -6.99452631578947 4.11879699248141 -108.083609022579 0.999999798786035 0.999999798786035 TRUE =M184 #N/A 0 0.002475683082978 0.320748742445571 34.8435504725221 2484916.49382745 2484916.49382745 TRUE =M185 612.5 0 0.999999949709745 0.763056773181177 #N/A 0.121069615639098 0.121069615639098 TRUE =M186 9942283.62965002 1 #N/A 0.299248120300747 0.299248120300747 TRUE =N182 11577901.4177444 0.582255639097671 #N/A 0.006560769731841 0.006560769731841 TRUE =N183 0.000156079794514 0.000156079794514 TRUE =N184 1 1 TRUE =N185 2.43609022556365E-08 2.43609022556365E-08 TRUE =N186 0.3501 1.00 1.500 1.10053744360903 1.10053744360903 TRUE =O182 0.6959 1.01 1.010 0.00712708986938 0.00712708986938 TRUE =O183 0.7201 1.02 0.980 #N/A error TRUE =O184 0.8059 1.05 0.870 #N/A error TRUE =O185 #N/A error TRUE =O186 -0.699789473684211 0.299248120300747 1.10053744360903 -0.699999999995333 -0.699999999995333 TRUE =M193 0.000506389721518 0.006560769731841 0.00712708986938 9.25081260404044E-13 9.25081260404044E-13 TRUE =M194 0.999999798786035 0.000156079794514 #N/A 1 1 TRUE =M195 2484916.49382745 1 #N/A 3.46285083263994E+030 3.46285083263994E+030 TRUE =M196 0.121069615639098 2.43609022556365E-08 #N/A 0.001693384196 0.001693384196 TRUE =M197 0.299999999990667 0.299999999990667 TRUE =N193 -0.000007 1.00 2.00001 1.84989825908131E-12 1.84989825908131E-12 TRUE =N194 -0.010993 1.01 2.01999 1.5636727264106E-17 1.5636727264106E-17 TRUE =N195 -0.022007 1.02 2.04001 1 1 TRUE =N196 -0.054993 1.05 2.09999 2.44507239532035E-34 2.44507239532035E-34 TRUE =N197 1.1 1.1 TRUE =O193 -0.699999999995333 0.299999999990667 1.1 5.04426861242829E-16 5.04426861242829E-16 TRUE =O194 9.25081260404044E-13 1.84989825908131E-12 5.04426861242829E-16 #N/A error TRUE =O195 1 1.5636727264106E-17 #N/A #N/A error TRUE =O196 3.46285083263994E+030 1 #N/A #N/A error TRUE =O197 0.001693384196 2.44507239532035E-34 #N/A -0.684999999999999 -0.684999999999999 TRUE =M205 0.009354143466935 0.009354143466935 TRUE =M206 0.999999363887917 0.999999363887917 TRUE =M207 -0.0014500 1.00 2.00200 786024.500000118 786024.500000118 TRUE =M208 -0.0096500 1.01 2.01800 0.001572049 0.001572049 TRUE =M209 -0.0233500 1.02 2.04200 0.272999999999999 0.272999999999999 TRUE =N205 -0.0535500 1.05 2.09800 0.01819340539866 0.01819340539866 TRUE =N206 3.16227766016836E-05 3.16227766016836E-05 TRUE =N207 -0.684999999999999 0.272999999999999 1.09694 1 1 TRUE =N208 0.009354143466935 0.01819340539866 0.001020122541659 9.99999999999988E-10 9.99999999999988E-10 TRUE =N209 0.999999363887917 3.16227766016836E-05 #N/A 1.09694 1.09694 TRUE =O205 786024.500000118 1 #N/A 0.001020122541659 0.001020122541659 TRUE =O206 0.001572049 9.99999999999988E-10 #N/A #N/A error TRUE =O207 #N/A error TRUE =O208 #N/A error TRUE =O209 -0.0014500 -0.0096500 -0.0233500 -0.0535500 -0.684999999999999 -0.684999999999999 TRUE =M216 1.00 1.01 1.02 1.05 0.009354143466935 0.009354143466935 TRUE =M217 2.00200 2.01800 2.04200 2.09800 0.999999363887917 0.999999363887917 TRUE =M218 786024.500000118 786024.500000118 TRUE =M219 -0.684999999999999 0.272999999999999 1.09694 0.001572049 0.001572049 TRUE =M220 0.009354143466935 0.01819340539866 0.001020122541659 0.272999999999999 0.272999999999999 TRUE =N216 0.999999363887917 3.16227766016836E-05 #N/A 0.01819340539866 0.01819340539866 TRUE =N217 786024.500000118 1 #N/A 3.16227766016836E-05 3.16227766016836E-05 TRUE =N218 0.001572049 9.99999999999988E-10 #N/A 1 1 TRUE =N219 9.99999999999988E-10 9.99999999999988E-10 TRUE =N220 1.09694 1.09694 TRUE =O216 0.001020122541659 0.001020122541659 TRUE =O217 #N/A error TRUE =O218 #N/A error TRUE =O219 #N/A error TRUE =O220 TRUE #N/A 4 O5 yes 1 no 2 yes 3