homeGeek CultureWebstoreeCards!Forums!Joy of Tech!AY2K!webcam

The Geek Culture Forums! (new server edition)


Post New Topic  New Poll  Post A Reply
my profile | directory login | | search | faq | forum home
  next oldest topic   next newest topic
» The Geek Culture Forums! (new server edition)   » Other Geeky Stuff   » Ask a Geek!   » Advanced excel help please!

 - UBBFriend: Email this page to someone!    
Author Topic: Advanced excel help please!
littlefish
BlabberMouth, a Blabber Odyssey
Member # 966

Member Rated:
4
Icon 1 posted March 05, 2005 06:10      Profile for littlefish   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
I hate excel. All of the column headings have changed from letters to numbers, making it rather hard to enter formulas. (=A1+1) for example is no longer possible, as the column head is 1, so you try (=11+1) and you get 12. I must've accidentally clicked somewhere and now excel has changed its settings to taunt me. Help is as usual, pathetic.

Can anyone tell me what I have changed so I can get back to doing my sums?

Edit: I've sorted it out a bit enough for me to do the sums, (I have to use RxCy where x is the row number and y is the column number to refer to cells) Got a bit confusing as if written R[x]C[y], then the values are relative. So if you write =R[2]C[4] in R1C1, you get the value from R3C5. Anyway, I don't like this method, and other people use this machine as well, so it needs to go back to a less ambigous method of cell reference.

Posts: 2421 | From: That London | Registered: Nov 2001  |  IP: Logged
Allan
SuperFan!
Member # 1717

Member Rated:
5
Icon 1 posted March 05, 2005 06:20      Profile for Allan     Send New Private Message       Edit/Delete Post   Reply With Quote 
In the menu bar

Tools | Options

and click the 'General' tab

uncheck R1C1 reference style

[Smile] enjoy your sums!!

Posts: 1280 | From: Edinburgh, Scotland / Frankfurt, Germany | Registered: Oct 2002  |  IP: Logged
littlefish
BlabberMouth, a Blabber Odyssey
Member # 966

Member Rated:
4
Icon 1 posted March 05, 2005 06:23      Profile for littlefish   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
Thanks Allan! Your reply came whilst I was editing my first post!
Posts: 2421 | From: That London | Registered: Nov 2001  |  IP: Logged
Xanthine

Solid Nitrozanium SuperFan!
Member # 736

Member Rated:
5
Icon 1 posted March 05, 2005 12:11      Profile for Xanthine     Send New Private Message       Edit/Delete Post   Reply With Quote 
Why oh why oh why are you analyzing your data in excel?

--------------------
And it's one, two, three / On the wrong side of the lee / What were you meant for? / What were you meant for?
- The Decemberists

Posts: 7670 | From: the lab | Registered: Mar 2001  |  IP: Logged
littlefish
BlabberMouth, a Blabber Odyssey
Member # 966

Member Rated:
4
Icon 1 posted March 05, 2005 15:41      Profile for littlefish   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
quote:
Why oh why oh why are you analyzing your data in excel?
Well I get the data from the mass spec in .wfs format, which I can then open in excel and save as a .csv. I trim it, strip out the useless headers and change the time format to something I can use. The IR data which I want to correlate comes out from the winIR pro software as a .kin file, which I can then convert to an .spc, and then convert it to a csv in the win IR pro software. (I don't know why it won't let me save it as a .csv to start with, but it makes me do that mess. Once saved as a .csv I then run the IR spectra .csv file through a custom app to swap axes and stuff to give me a .dat (tab delimited text) file. I can the collate the IR and mass spec together as they are the same format and I plot them with origin.

Or in short: to make all the files play nicely together and do a bit of maths.

Posts: 2421 | From: That London | Registered: Nov 2001  |  IP: Logged
Xanthine

Solid Nitrozanium SuperFan!
Member # 736

Member Rated:
5
Icon 1 posted March 05, 2005 16:02      Profile for Xanthine     Send New Private Message       Edit/Delete Post   Reply With Quote 
Gotta love the world of science files. [Roll Eyes]

For images of gels, we'll save one copy as a .gel so we can quantitate our data, and then make another copy as a .tif so we can make a .jpg for any potential papers and presentations. It's actually fairly easy to go from .gel to .tif is you use the right program, but you can't go from .tif to .gel. So if you don't at least save the .gel you're fscked and have to redo the whole bloody experiment.

I only made that mistake once, and had so much fun explaining myself to my PI I've never made it again.

Just try opening a .pdb sometime. Now those are fun...

--------------------
And it's one, two, three / On the wrong side of the lee / What were you meant for? / What were you meant for?
- The Decemberists

Posts: 7670 | From: the lab | Registered: Mar 2001  |  IP: Logged
dragonman97

SuperFan!
Member # 780

Member Rated:
4
Icon 1 posted March 05, 2005 21:13      Profile for dragonman97   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
A Palm DB file? [Wink]

Nah...I did a quick Google search, and I know what they are now - they look like they're in a pretty simple format, though. [Smile] I wouldn't have a fscking clue what to do with them, but I'd certainly be able to write a Perl program to open it, and dump the relevant details out, in a pretty short bit of time. Actually gleaning useful information from it is a whole different story. [Wink] [Big Grin]

Sorry...data munging is one of my hobbies, in case you didn't already know. Ooh...which reminds me...

TGTGAAGCTATTGCTAAATGTGATGCTCCTGCTGTTGCTG
TTGCTAATTGTGATGCTCCTGCTAAAGCTAATGCTTTTGC
TGAAGCTACTGCTGCT


GCTAAAGCTCATGCTGTTTGTGAATGTGAAGCTATTGCTT
TTGCTTGGGCTATTGCTGTTGCTACTGCTTTTGCTACTTG
TTTTGCTCAAGCTTGTGCTTTTTGTTGTGCTGGTGCTGTT
TGTTGTGCTGCTTGTGGTGCTTTTTGTTGTTGTAAAGCTG
ATTGTTTTTGTGAAGCTTTTGCTCATGCTTTTGCTTTTGC
TAATGCTCATGCTAAATGTTGTGCTCCTTGTGAAGCTGTT
GCTGAAGCTGCTTGTAAA

[Razz] [Razz] [Razz]

Believe it or not, I actually find Excel to be a pretty decent tool to review data in. I've even written a function in one of my programs to dump out data in such a format that I can dump it in an Excel spreadsheet, and have it show up nicely with conditional formatting, and work with AutoFilter. Excel is really getting on my nerves with some of its shoddy programming. ("Do you want to save this file? [Yes/No/Go Away] -> _YES_; "Saving foo.txt will lose its formatting? Would you like me to confuse you with more file choosers? [Sod Off/Yes, Sir, May I Have Another?] _Sod_Off_ *QUIT* The file 'foo.txt' has not been saved, are you sure you want to quit? [Of course, I just saved it, fool/No, you know best, master/I give up] *Of course...* {Bang head against wall}) I'm starting to consider trying out Gnumeric on Windows, and see how it works for what I do - I rather love it under Linux, and if it will get the job done, and not aggravate me further, that'll make me just a bit happier. The more FL/OSS, the better! [Smile]

--------------------
There are three things you can be sure of in life: Death, taxes, and reading about fake illnesses online...

Posts: 9339 | From: Westchester County, New York | Registered: May 2001  |  IP: Logged
littlefish
BlabberMouth, a Blabber Odyssey
Member # 966

Member Rated:
4
Icon 1 posted March 06, 2005 02:48      Profile for littlefish   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
I feel your pain Dman. I did check, and it is possible to get into a loop if you want to save your file, but not as a .xls, because the words in their dialog boxes suck. Apart from that, it has a good import feature, and the ability to do simple maths easily. It does try too hard to be helpful though. When I had been using the new version for a while I had to spend a while finding all the preferences to turn them all off. I felt a bit like Dave from 2001, shutting off all the higher functions of HAL that had been working to destroy him....
Posts: 2421 | From: That London | Registered: Nov 2001  |  IP: Logged


All times are Eastern Time  
Post New Topic  New Poll  Post A Reply Close Topic    Move Topic    Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:

Contact Us | Geek Culture Home Page

© 2018 Geek Culture

Powered by Infopop Corporation
UBB.classicTM 6.4.0



homeGeek CultureWebstoreeCards!Forums!Joy of Tech!AY2K!webcam