- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 43# lcctno
data!J2 ¥i¥Hª½±µ±a¨ç¼Æ¤ñ¸û²³æ¤@¨Ç
=FORECAST(I2,OFFSET(µ²ªG!D1,MATCH(I2,µ²ªG!A:A,1),,-2),OFFSET(µ²ªG!A1,MATCH(I2,µ²ªG!A:A,1),,-2))
FORECAST(x,known_y's,known_x's)
X ¬O±zn¹w´ú¤@Ó¼ÆȪº¸ê®ÆÂI¡C
Known_y's ¬O¦]Åܼư}¦C©Î¸ê®Æ½d³ò¡C
Known_x's ¬O¦ÛÅܼư}¦C©Î¸ê®Æ½d³ò¡C
ì data!J2 ¤½¦¡
=IF(ISERROR(LOOKUP(I2,OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,),ROW(OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,)))),"--",IF(LOOKUP(I2,OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,),ROW(OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,)))>=µ²ªG!$E$2+2,1,VLOOKUP(I2,IF({1,0},OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,),OFFSET(µ²ªG!$D$3,,,µ²ªG!$E$2,)),2)+(I2-LOOKUP(I2,OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,)))*LINEST(OFFSET(INDIRECT("µ²ªG!D"&LOOKUP(I2,OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,),ROW(OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,))),1),,,2,),OFFSET(INDIRECT("µ²ªG!A"&LOOKUP(I2,OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,),ROW(OFFSET(µ²ªG!$A$3,,,µ²ªG!$E$2,))),1),,,2,)))) |
|