Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #71  
Old 05-20-2010, 11:20 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,140
Default

Quote:
Originally Posted by Ouling View Post
If I have one row to for the input data that have calculation

and I have 30000 rows of data that feeds into them as inputs

and I want excel cycle through them to spit out 30000 calcuation into another worksheet

Without me having to edit, copy paste, and drag and drop

Anyone know how that works without having to write long macros?

Thanks alot
I don't understand the question. Can you clarify what you mean in the bold?

Your top row is doing some type of calculation on the columns below? And you want to copy it down into another sheet? Or an separate workbook?
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #72  
Old 05-21-2010, 07:44 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,454
Default

I think he has a formula in the first line and wants to apply it, one by one, to all the rows of data below. More specifics on what calcs he wants to do would probably help.

And it probably should not have been put into this thread. Oh well.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #73  
Old 05-21-2010, 08:29 AM
IMP's Avatar
IMP IMP is offline
= I Must Pass
 
Join Date: Mar 2004
Location: in my pants, and yours
Studying for drinking
Favorite beer: blue moon....cuz i'm a female
Posts: 31,777
Blog Entries: 11
Default

you either copy/paste the one line of of formulas or you have a macro
__________________
Quote:
Originally Posted by Patience View Post
that's why they invented doggy style
Reply With Quote
  #74  
Old 05-21-2010, 10:46 AM
ADeliciousDish's Avatar
ADeliciousDish ADeliciousDish is offline
Member
 
Join Date: Apr 2010
Location: NPR
Studying for Schweddy Balls recipe
Posts: 296
Default

He just wants to copy formulas down really far? Why would you need a macro for that. Just type A30000 into the range box and then ctrl+shift+uparrow, ctrl+d
__________________
Good times.
Reply With Quote
  #75  
Old 06-17-2010, 02:06 PM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 9,132
Default

To minimize/expose the ribbon in Excel 2007:

Double click the open tab or use CTRL+F1.
__________________


Learn how FSA exams are different from the prelims

We have your exam covered:

LP | LFV-U | LFV-C | LRM | ERM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Sp

Check out our Technical Skills Course and our new R Course!

Connect on Twitter, Facebook, & LinkedIn
Reply With Quote
  #76  
Old 06-17-2010, 02:11 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,454
Default

Pardon me for being dense, but where is this "open tab" you speak of? Is it the office button? I thought double-clicking that would close Excel.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #77  
Old 06-17-2010, 02:16 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,454
Default

If you mean the tab at the bottom of my spread sheet, that's what I double click to change the label on the tab. Now I need to learn how to rename a tab!!
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #78  
Old 06-17-2010, 02:26 PM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 9,132
Default

Quote:
Originally Posted by JMO View Post
If you mean the tab at the bottom of my spread sheet, that's what I double click to change the label on the tab. Now I need to learn how to rename a tab!!
Fear not. Sorry I wasn't clearer. I was referring to the ribbon tab (e.g. Home, Data, Insert, etc.).

Yes, now "tab" can refer to 2 things inside a workbook. Never realized that until now.
__________________


Learn how FSA exams are different from the prelims

We have your exam covered:

LP | LFV-U | LFV-C | LRM | ERM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Sp

Check out our Technical Skills Course and our new R Course!

Connect on Twitter, Facebook, & LinkedIn
Reply With Quote
  #79  
Old 06-17-2010, 02:38 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,454
Default

Actually, it was a good thing. I tried Excel help and found another way to minimize the ribbon. Up next to the quick access tool bar*, there is a little icon for customizing said tool bar, and one of the options there is to toggle the ribbon off/on.

* This was something I was frantically looking for, because it is apparently the only place that undo/redo resides. For those who are wondering, it's next to the Office button ("the globe" as it is sometimes known.)
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #80  
Old 06-17-2010, 02:42 PM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 9,132
Default

Quote:
Originally Posted by JMO View Post
Actually, it was a good thing. I tried Excel help and found another way to minimize the ribbon. Up next to the quick access tool bar*, there is a little icon for customizing said tool bar, and one of the options there is to toggle the ribbon off/on.

* This was something I was frantically looking for, because it is apparently the only place that undo/redo resides. For those who are wondering, it's next to the Office button ("the globe" as it is sometimes known.)
I keep the ribbon minimized probably 95% of the time. Being able to minimize the ribbon and gain more screen real estate is a nice "feature" of all the Office 2007 apps.

I use keyboard shortcuts for most things in Excel, so I don't have much need to look at the ribbon. I also keep a few frequently used buttons on the custom quick access toolbar.
__________________


Learn how FSA exams are different from the prelims

We have your exam covered:

LP | LFV-U | LFV-C | LRM | ERM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Sp

Check out our Technical Skills Course and our new R Course!

Connect on Twitter, Facebook, & LinkedIn
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 07:20 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.30290 seconds with 10 queries