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

# The Excel Questions Thread - Page 25

Quote:
Originally Posted by rajesh06
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.
School me in Solver pl0x.
PSA:

CHAR(10) will insert a line break in ur function! Use it loud and proud!
*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?
Quote:
Originally Posted by Cool The Kid
*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.
Quote:
Originally Posted by Bhowie
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.
For hags:
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?
Quote:
Originally Posted by MasterOfReality
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.
I take it you tried playong with text to colums?

Quote:
Originally Posted by MasterOfReality
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?
Quote:
Originally Posted by rajesh06
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
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.
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
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.
I can't get this sample to work in Excel 2000. Macro crashes.
Quote:
Originally Posted by Reevolving
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