Advertisement

Member Login


Or call us
US +1 (617) 500-8224
EU +44 (113) 815 2220
Or Skype us

Who's Online

We have 111 guests and 6 members online


Enter Amount:


Total Downloads

155451
Home

ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Reading graphical and tabular data with Excel (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Reading graphical and tabular data with Excel
#1613
JohnDoyle (Admin)
Please support us with an XLC Pro Subscription.
Moderator
Posts: 894
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Reading graphical and tabular data with Excel 1 Year, 2 Months ago Karma: 475  
This thread is about Reading graphical and tabular data with Excel video.
This is added to complement the Excel tips section in the site help.
This video can also be viewed on YouTube:
 
Logged Logged  
 
Last Edit: 2009/08/11 07:35 By JohnDoyle.
 
  The administrator has disabled public write access.
#1626
MajorMagee (User)
Egg (Fresh Boarder)
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Re:Reading graphical and tabular data with Excel 1 Year, 2 Months ago Karma: 2  
I was thinking about this, and decided that it was indeed a useful thing to be able to do. The attached spreadsheet is a rough example of an enhanced implementation of what you're showing in the tutorial.

It's set up to take advantage of image editing programs (like paint) that show a readout of pixel coordinates as you move the pen over the image. One fills in the table with pixel coordinates (D3:E5) & (D8:E27), and the min, max scale values (B3:C5). It then automatically remaps the coordinates to match the graph rather than the image, and scales them to their intended values. Fairly handy for accurately pulling chart values from an image.

For interpolation you can enter a trial x value (B8), and it will calculate the matching y value, using several types of curve fitting. Fairly handy for getting additional values without going back to the image.
File Attachment:
File Name: Data_Mapping.xls
File Size: 88064
 
Logged Logged  
 
Last Edit: 2009/05/09 04:09 By MajorMagee.
  The administrator has disabled public write access.
#1628
JohnDoyle (Admin)
Please support us with an XLC Pro Subscription.
Moderator
Posts: 894
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Reading graphical and tabular data with Excel 1 Year, 2 Months ago Karma: 475  
MajorMagee you are to be commended once again for your hard work. In particular a special commendation for the formula in cell C17 - the 7th order polynomial curve fit - certainly not be be attempted after a few beers.

Your use of 'paint' programs for data input is also very innovative.

After all these commendations it is only a matter of time before you become ColonelMagee! Thanks for your very useful addition.
 
Logged Logged  
 
  The administrator has disabled public write access.
#1630
MajorMagee (User)
Egg (Fresh Boarder)
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Re:Reading graphical and tabular data with Excel 1 Year, 2 Months ago Karma: 2  
Thanks.

You've inspired a little more refinement. This version includes some simple instructions, and can accomodate a graph where the axis origin is not at 0,0.
File Attachment:
File Name: Graphic_Data_Mapping.xls
File Size: 99328
 
Logged Logged  
  The administrator has disabled public write access.
Go to top