ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > ASP Free Lounge
Reload this Page

Lookup, Index, and Trend

Discuss Lookup, Index, and Trend in the ASP Free Lounge forum on ASP Free.
Lookup, Index, and Trend ASP development forum discussing anything that doesn't fit into the other forums. This is the place to relax, talk, and maybe even have some friendly debate.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old April 15th, 2004, 05:51 PM
MTT_14 MTT_14 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Apr 2004
Posts: 6 MTT_14 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 21 sec
Reputation Power: 0
Lookup, Index, and Trend
Hi,

I don't use forums, etc... very often.

Thanks,
Ken

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++
I'm trying to utilize this Excel formula to search "named" cells:

=IF(B1=LOOKUP(B1,x,x), LOOKUP(INDEX(x,MATCH(LOOKUP(B1,x,x),x,0)x,y),TREND (y,x,B1))


The object:
to return intermediate values uses (linear) extrapolation.


The Problem:
it doesn't work.


Any suggestions greatly appreciated.


************************************************** *********


Formula is from "MS Excel 2000 Formulas" by J. Walkenbach (p. 230)

Please see attached Excel File.


Thanks!
-Ken
Attached Files
File Type: txt Extrapolation Problem.txt (90 Bytes, 373 views)
Reply With Quote
  #2  
Old April 15th, 2004, 07:00 PM
Skip's Avatar
Skip Skip is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Nov 2003
Location: UK
Posts: 816 Skip User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 21 m 47 sec
Reputation Power: 5
Code:
<%
Dim oConn As New ADODB.Connection
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=C:\Book1.xls;" & _
           "Extended Properties=""Excel 8.0;"""

' change Sheet1$ to your worksheet name
oRS.Open "Select * from [Sheet1$]", oConn, adOpenStatic
if oRS.eof then
response.write("No info here tom")
else

'do somthing with your formula don know what though Memnoch :D

end if
oConn.Close
%>
__________________
If it was working its not now
Reply With Quote
  #3  
Old April 15th, 2004, 07:38 PM
MTT_14 MTT_14 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Apr 2004
Posts: 6 MTT_14 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 21 sec
Reputation Power: 0
Interpolation Problem
Thanks, though I've got to admit its "all greek to me" ;-)
My Excel programmiming has been very slight (a little more adept at MetaStock, etc...),
is this VB code?
or can it be entered in the formula bar?

Thanks,
MTT_14

Quote:
Originally Posted by Skip
Code:
<%
Dim oConn As New ADODB.Connection
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Book1.xls;" & _
"Extended Properties=""Excel 8.0;"""
 
' change Sheet1$ to your worksheet name
oRS.Open "Select * from [Sheet1$]", oConn, adOpenStatic
if oRS.eof then
response.write("No info here tom")
else
 
'do somthing with your formula don know what though Memnoch :D
 
end if
oConn.Close
%>
Reply With Quote
  #4  
Old April 16th, 2004, 06:10 AM
Skip's Avatar
Skip Skip is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Nov 2003
Location: UK
Posts: 816 Skip User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 21 m 47 sec
Reputation Power: 5
No m8 Sorry,

I think i miss-understood this is asp i thought you wanted to access an excel file from a web page. There was talk of an MS office forum I dont know if this has come into effect I will find out for you.
Reply With Quote
  #5  
Old April 16th, 2004, 11:54 AM
MTT_14 MTT_14 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Apr 2004
Posts: 6 MTT_14 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 21 sec
Reputation Power: 0
Interpolation Problem
Basically I'm just trying to find the internediate values between to plots on a chart (one of which is accelerating (unevenly?) faster than the other.
Its too bad we can't attach xls files. Virus worries I guess ;-0

Thanks,
mtt_14


Quote:
Originally Posted by Skip
No m8 Sorry,

I think i miss-understood this is asp i thought you wanted to access an excel file from a web page. There was talk of an MS office forum I dont know if this has come into effect I will find out for you.
Reply With Quote
  #6  
Old April 16th, 2004, 03:45 PM
sbaxter sbaxter is offline
Moderator: Access, SQL
ASP Free God (5000 - 5499 posts)
  
Join Date: Oct 2003
Posts: 5,126 sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
Skip asked us to help

If you zip your file, you can attach it

S-
Reply With Quote
  #7  
Old April 17th, 2004, 12:41 PM
MTT_14 MTT_14 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Apr 2004
Posts: 6 MTT_14 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 21 sec
Reputation Power: 0
Interpolation Problem
Doh!
Thanks ;-)


Quote:
Originally Posted by sbaxter
Skip asked us to help

If you zip your file, you can attach it

S-
Attached Files
File Type: zip Extrapolation Problem.zip (2.1 KB, 414 views)
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > ASP Free Lounge > Lookup, Index, and Trend

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway. 
Stay green...Green IT