| Subject: | Re: [LCtalk] probably simple excel question |
| From: | Natty Simson |
| Date: | Tue, 07 Dec 2004 20:01:53 +0100 |
Hi there--
I have an answer for you -- possibly not the best, but it works. With your
Excel sheet open, you want to insert a column to the right of each channel
column. Then, in the first cell of each of the new blank columns, type
"=x1*2.55" (without the quote marks), where x is the letter of the column
to the left. Next, select each of your new columns in turn (by clicking on
the letter at the top), and go to the Edit menu -> "Fill" -> "Fill Down".
You should now have each column multiplied by 2.55 in a column to its
right. Next, go to File-> "Save as" and choose the format "CSV" from the
list. It'll tell you that some features may be discarded (they'll be saved
in your original file anyway), and click OK. Close the file and then open
the file you just made (make sure it's the CSV one). Next, delete the
superfluous columns and rows. Now, select _all_ the cells you've just made
(click top left one, hold shift, click bottom right one), and go to Format
-> "Cells". Click the catefory "Number", and change the decimal places box
to read "0" (no quotes). This will round all to the nearest whole number.
You're done! Note: the conversion to CSV is so that all the formulas cease
to be formulas and just turn into numbers. I'm sure someone here knows a
faster way, and I'm sure the process can be automated with macros or
somesuch, but that's how I'd do it. Hope this helps, and feel free to ask
me for clarification.
Natty
|
