ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½u©Ê¤º´¡­Èªº¤½¦¡

[µo°Ý] ½u©Ê¤º´¡­Èªº¤½¦¡

½Ð°Ý¦U¦ì«e½ú¡A¦³¨S¦³¨ç¼Æ¤½¦¡¥i¥H§Ö³t­pºâ¤º´¡­È¡C¦pªþ¥ó¡C
§Úª¾¹DA1=50, F1=125¡A¦ý¬O§Ú¥²¶·­n§âB1¨ìE1¥Î½u©Ê¤º´¡§â­È¸É¤W¥h¡A
§Ú¥Ø«e¬O¥ÎB1=($F$1-$A$1)/5+A1¨Ì§Ç¶ñº¡B1¨ìE1¡A
¦ý¬O§Ú·Qª¾¹Dexcel¬O§_¦³¤½¦¡¥i¥H§Ö³t­pºâB1¨ìE1ªº½u©Ê¤º´¡­È©O¡H
¥Ñ¨ä¬O·í­n¥Î½u©Ê¤º´¡­È¶ñº¡ªºÀx¦s®æ¼Æ¶q¤S¤£¤@©w®É¡A
¨C¦¸³£­n­«¼g¹³¬O³o¼Ëªº¤½¦¡=($F$1-$A$1)/5+A1¡A
·Pı«D±`³Â·Ð¡A©Ò¥H·Q½Ð±Ð«e½ú­Ì¬O§_¦³³o¼Ëªº¨ç¼Æ¦s¦b¡H

Linear Interpolate.zip (4.63 KB)

¦^´_ 1# maxchou


    B1=$A$1+COLUMN(A1)*(LOOKUP(9.9E+307,INDIRECT("RC[1]:RC255",0))-$A$1)/(LOOKUP(9.9E+307,INDIRECT("RC[1]:RC255",0),COLUMN(INDIRECT("RC[1]:RC255",0)))-1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# maxchou


   

TOP

¦^´_ 1# maxchou

¥t¤@ºØ¤èªk:
C7 = FORECAST(B7,OFFSET(KnownY,MATCH(B7,KnownX,1)-1,0,2),OFFSET(KnownX,MATCH(B7,KnownX,1)-1,0,2))
   

§â½d¨ÒÀÉ©ñ³o
´¡­È.rar (5.87 KB)

TOP

¦^´_ 2# Hsieh


ÁÂÁÂHsieh«e½ú¡A¤£¹L«D±`©êºp¡A§Ú¤@¶}©l¨S¦³Á¿²M·¡¡A
§Úªº¸ê®Æ¦b¦P¤@row¤¤¡A¬O¨C¹j´X­Ó¦³¤wª¾ªº¼Æ¦r¡A¦Ó§Ú¥²¶·§âªÅ®æ¶ñº¡¡A(¦pªþ¥óG1-J1, L1-O1)
¦ÓHsieh«e½úªº¤½¦¡¬O¥H¦P¤@rowªº³Ì¤j­È¨Ó­pºâ¡A¤£ª¾¹D¹³¬Oªþ¥ó³o¼Ëªº¸ê®Æ¡A
¬O§_¦³¥i¯à¥H¤@­Ó¤ñ¸û§Öªº¤½¦¡¨Ó­pºâB1-E1, G1-J1, L1-O1µ¥Àx¦s®æ¡C
¦A¦¸ÁÂÁÂHsieh«e½ú¡I
Linear Interpolate.zip (4.64 KB)

TOP

¦^´_ 4# infoverdad


ÁÂÁÂinfoverdad«e½ú¡A¯u¬O¤£¦n·N«ä¡A¤@¶}©l¨S»¡²M·¡¡A§Ú¸ê®Æªº®æ¦¡¦p¦P§ó·sªºªþ¥óLinear Interpolate.zip
§Úªº»¡©ú¤£²M·¡¡AÅýinfoverdad«e½ú®ö¶O®É¶¡¡A«D±`©êºp¡I
¦A¦¸ÁÂÁÂinfoverdad«e½ú¡I

TOP

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-9-19 21:30 ½s¿è

¦^´_ 6# maxchou

¨ä­ì²z¬O¤@­Pªº(§Q¥Î¤wª¾ÂI¥Hforecast¤½¦¡ºâ¥X¨ä¶¡¥¼ª¾ªº´¡­È)!¦pªþ¥ó
interval2.rar (6.57 KB)

TOP

¦^´_ 7# infoverdad

ÁÂÁÂinfoverdad«e½ú³o»ò¥J²Óªº¸É¥R»¡©ú¡A
§Ú§Æ±æªº¤è¦¡´N¬O¦p¦¹¡A¥u¬O¨S·Q¨ì»Ý­n¥Î¨ì¨º»ò¦h¨º»ò½ÆÂøªº©w¸q¸ò¨ç¼Æ¡C
§Ú±o¦n¦n¬ã¨s¬ã¨s......

TOP

¦^´_ 8# maxchou


    «Øij¥i¦Ü¦¹ºô§}¬Ý¬Ý: http://www.blueleafsoftware.com/Products/Dagra/LinearInterpolationExcel.php

TOP

¦^´_ 7# infoverdad
«e½ú:©êºp,§Ú¥u¬O¤p¾Ç¥Íµ¥¯Å,µLªk¤U¸ü±zªºÀÉ®×.¥u¬O,­Y«ö·Ó±z©Ò¶Kªº¤½¦¡,§Ú¤]ºâ¤£¥X¨Ó .  XD
¥i¥H´£¨Ñ¥t¥~ªº³sµ²ÂI¶Ü??  ·P®¦!:loveliness:

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD