or Connect
Styleforum › Forums › General › General Chat › The Excel Questions Thread
New Posts  All Forums:Forum Nav:

The Excel Questions Thread - Page 25

post #361 of 532
Quote:
Originally Posted by rajesh06 View Post
Solver really wasn't designed to solve problems like this but it may work.
I have no elegant suggestion for your question - I am sure that there a more than a handful of brute-force approaches that will work.

I don't see why solver wouldn't work. If you can write it well enough.
post #362 of 532
Thread Starter 
School me in Solver pl0x.
post #363 of 532
Thread Starter 
PSA:

CHAR(10) will insert a line break in ur function! Use it loud and proud!
post #364 of 532
*EDIT* New question I have some data that has about 170,000 entries and I need to see it just laid out simply in graphic form. Excel won't graph more than 32,000 points at a time. Is there any easier way to plot this other than breaking it out every 32,000 pts?
post #365 of 532
Thread Starter 
Quote:
Originally Posted by Cool The Kid View Post
*EDIT* New question

I have some data that has about 170,000 entries and I need to see it just laid out simply in graphic form. Excel won't graph more than 32,000 points at a time. Is there any easier way to plot this other than breaking it out every 32,000 pts?

What kind of chart do you need? You could use a histogram (frequencies into bins), but if you need points across time, you'll have to take some averages.

For example, if I have emission data every second for a month, I might just plot block 1 minute averages to show variation with time. Or, with a histogram, I could use a (relatively) small number of bins to cover my emission range and count the number of points that fall into each bin. That would show me distribution but tell me nothing about variation with time.
post #366 of 532
Quote:
Originally Posted by Bhowie View Post
I don't see why solver wouldn't work. If you can write it well enough.

Solver is designed to converge to a result; this problem really calls for a trial-and-error solution. So it may work but it may not.
post #367 of 532
Thread Starter 
For hags:
post #368 of 532
I have a bit of an issue.

I am going through geological logs that were logged in imperial units. I need to convert this to SI units.

There are thousands of lines with distance measurements that are in feet and inches.

For example each measurement, its actually typed into one cell as "208' 3"", instead of seperate cells for feet and inches.

Short of copy/paste into a txt document and then re-importing and using seperated values to get rid of the " and ' notation and then finally converting, is there a quick and easy way to do this?
post #369 of 532
Quote:
Originally Posted by MasterOfReality View Post
I have a bit of an issue.

I am going through geological logs that were logged in imperial units. I need to convert this to SI units.

There are thousands of lines with distance measurements that are in feet and inches.

For example each measurement, its actually typed into one cell as "208' 3"", instead of seperate cells for feet and inches.

Short of copy/paste into a txt document and then re-importing and using seperated values to get rid of the " and ' notation and then finally converting, is there a quick and easy way to do this?

you can use =find to find the location of the " ' " and " " " and then use =left and =right to extract the feet and inches - its pretty straightforward from there.
post #370 of 532
I take it you tried playong with text to colums?

Quote:
Originally Posted by MasterOfReality View Post
I have a bit of an issue.

I am going through geologica logs that were logged in imperial units. I need to convert this to SI units.

There are thousands of lines with distance measurements that are in feet and inches.

For example each measurement, its actually typed into one cell as "208' 3"", instead of seperate cells for feet and inches.

Short of copy/paste into a txt document and then re-importing and using seperated values and then finally converting, is there a quick and easy way to do this?
post #371 of 532
Quote:
Originally Posted by rajesh06 View Post
you can use =find to find the location of the " ' " and " " " and then use =left and =right to extract the feet and inches - its pretty straightforward from there.

Thanks! I'll give that a go and see what happens.

Quote:
Originally Posted by jgold47 View Post
I take it you tried playong with text to colums?

Yes, unfortunately the problem is the person that transcribed all these entries was not consistent.
post #372 of 532
I want to make a 3D scatterplot (XYZ axis) Say I have 3 variables for each person. (Tits, Ass, Face) A "10,10,10" would be in the upper front right corner. A "0,0,0" would be in the lower back left corner. Can this be done in Excel? If not, what's the best way to plot
post #373 of 532
http://www.doka.ch/Excel3Dscatterplot.htm
http://www.andypope.info/charts/3drotate.htm

May or may not work right in 2007

Otherwise, R would be a good bet.
post #374 of 532
I can't get this sample to work in Excel 2000. Macro crashes.
post #375 of 532
Thread Starter 
Quote:
Originally Posted by Reevolving View Post
I can't get this sample to work in Excel 2000. Macro crashes.

Why are you using Excel 2000 and not at least 2003?
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: General Chat
Styleforum › Forums › General › General Chat › The Excel Questions Thread