Check your e-mail.
Have you used the HPC powered Excel server? I saw a demo where a home built HPC server with 6 nodes crunched a 50 bond portfolio monte carlo pricing simulation in about 45 seconds. The server was homebuilt for about $5k and pretty much the size of a bulky under the desk case.
Have you seen this or used this? Would you ever need to turn your excel desktop into a HPC front end?
Wow! Awesome. And I can look at the formatting and see what you guys are talking about. This is so great! Thank you!!!
Please help me with the following simple interface question…
I hate moving my hands from the keyboard to reach for the mouse and am wondering if I could set up a way to ALT-TAB between worksheets like I do applications.
Thanks.
JohnT - I know this! (Because Cap showed me on the previous page of this thread) To flip between worksheets, just hit Ctrl-Tab, instead of Alt-Tab.
StG
:dances the Snoopy dance:
Thanks!
I have a long spreadsheet going that I enter new rows of data onto daily. Often the data in one cell is identical to the cell above it. I then have to highlight that cell and cut & paste it to the lower cell.
Is there a short-cut to copy what’s above one cell to the cell directly underneath it?
I encounter this at work. I have a list, a numerical list that I want to sort into odd number and even numbers. Is there a way to do this? The list would be something like
67
68
71
73
77
78
82
The entire list is about 300 numbers, all in a single column. Is there any easy to sort them? out
I don’t really see what the problem is here. Do you want to copy a whole row into another row? If so, click the grey row header at the very left of the spread sheet to select it. If you are looking for a key-board shortcut to copy in general, it is Ctrl-c.
If what you want is to have a keyboard shortcut that will copy the cell in the row above to the cell in the row directly below, you could easily do this by recording a macro and assigning a keyboard shortcut.
Clarification, please.
Check your e-mail…
Hey, cool, just noticed this thread right after posting an Excel question in GQ. Any help with this problem would be greatly appreciated.
Thank God you started this thread!
I’ve been going nuts trying to figure out how to drop an excel spreadsheet into a Powerpoint Slide. If I just try cutting and pasting, it invariably cuts bits off. Any ideas?
Copy the table, paste special - Microsoft Office Excel Worksheet Object.
Thanks excel guy!
What is the best cell format to store time durations such as 37:41:30 meaning 30 days, 41 hours and 30 minutes?
When I manually type in 37:41:30, excel seems to think I mean 1/1/1900 1:41:00 PM.
I have an application that outputs events and gives time durations for each event. I’d like to add up the duration column to get the total amount of time for all events. But when faced with this column of event durations:
0:35
0:36
0:21
6:20
17:10
14:50
12:00
8:55
6:41
6:10
6:05
5:25
5:10
4:35
1:41
0:45
6:36
24:31:00
9:05
Excel adds them all up and gives me 17:31. I can tell just by eyeballing the numbers that the total has got to be somewhere around 28 days.
I don’t think you’ll be able to do this with standard or custom cell formats. I suspect your best bet will be to enter the data into three columns: days, hours, minutes. In another column you can create a formula that will put the elements into common units such as days (d + (h/24) + (m/1449)), hours ((d24) + h + (m/60)), or minutes ((d1440) + (h*60) + m) and then you can do math on them. You could also create another column just for looks if you wish: concatenate(d, “:”, h, “:”, m)
Obviously that 1449 is a typo. It should be 1440.
Also, here’s a better “just for looks” formula:
CONCATENATE(IF(VALUE(days)=0,VALUE(hours),CONCATENATE(days,":",RIGHT(hours+100,2))),":",RIGHT(minutes+100,2))
Had another idea for you…
Format the column where you enter your data as Text. Then be sure to always enter your data in fully padded dd:hh:mm format. Examples: 00:00:01 or 00:01:16 or 01:20:09
Then you can use the following formula to convert that text string into a number of seconds: (where A1 is the cell containing the text string.)
=VALUE(MID(A1,1,2))2460+VALUE(MID(A1,4,2))*60+VALUE(MID(A1,7,2))
You can then do whatever math you wish on the number of seconds. A formula like this will convert seconds back into the text format you desire: (where B1 is the cell containing the number of seconds.)
=CONCATENATE(RIGHT(TRUNC(B1/1440)+100,2),":",RIGHT(MOD(TRUNC(B1/60),24)+100,2),":",RIGHT(MOD(B1,60)+100,2))
That’s more doable but the program I use spits out long colums of tab delimited values and doesn’t stick in enough leading zeroes as place holders. If the only data to report is minutes, the output will be just o:45. If there are hours and minutes to report, it’ll show 2:45. If there days, hours & minutes it’ll show 9:02:45.
On existing sheets, if I try to format a cell that has “0:25” (which excel thinks means 12:25 a.m.) into text, excel turns the value into 0.01736.
At this point I’m thinking it might be easier for me just to get another job 
Is there a way to create a custom format that sticks around from workbook to workbook? Or even better, one that I could make an icon for? I have a LOT of numbers in almost every workbook that I use that need to be in a number format with the commas to separate thousands but with no decimals (i.e. 2,345). However, instead of being able to click one or two buttons to get this format, I always have to get to formatting, choose Number, set decimals to 0, and then check the “thousands separator” check box. Every. Single. Time. I’d love to be able to create a shortcut (or a key stroke or whatever) to be able to get to that format quickly and easily. Is that possible or is it a pipe dream? Thanks!