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
  #11  
Old 12-01-2008, 06:17 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,249
Default

Quote:
Originally Posted by GadgetGeek View Post


I have some jobs that copy a zipped file locally and unzips it for processing that runs much quicker than just processing the unzipped data off the network drive.
I'm assuming you want to keep the zip file, otherwise you could save time still by unzipping directly from the network to your local drive, no?
Reply With Quote
  #12  
Old 12-02-2008, 09:28 AM
GadgetGeek's Avatar
GadgetGeek GadgetGeek is offline
Note Contributor
SOA AAA
 
Join Date: Sep 2001
Location: I'm here, where are you?
Studying for a way to escape
College: Illinois College ('87)
Favorite beer: Stag
Posts: 11,154
Default

Quote:
Originally Posted by dumples View Post
I'm assuming you want to keep the zip file, otherwise you could save time still by unzipping directly from the network to your local drive, no?
I'll have to check my logic, that may be what I'm actually doing. It might be the zip creation that I do locally and then copy the zip back to the network. Our network guys are grateful for me storing zip instead of txt on the lan as these are pretty sizable files.
__________________
Some people are like slinkies. Mostly useless, but provide amusement when pushed down the stairs.
Reply With Quote
  #13  
Old 12-02-2008, 01:03 PM
Guilty Bystander Guilty Bystander is offline
Member
SOA AAA
 
Join Date: Jun 2005
College: Meeeshigan
Favorite beer: Bell's Two Hearted IPA & kunhenn's DRIPA
Posts: 1,775
Default

Thanks for the feedback.

I do have all the files, excel and text, on my hard drive. I, too, have learned over time to avoid the network traffic jams.

I am not writing to any workbooks, per se. I get policy information from a input text file, do some calculations in excel and in the VBA itself based on the policy information, and then write selected information to a second text file (note, there is only one input file and one output file).

s-5, I do use some worksheetfunctions, but most of the calculations are on the worksheet. I'm considering moving all but a few items into the VBA code. There are some parameters that I'd keep on the worksheet, like file directory, file name, etc.
Reply With Quote
  #14  
Old 12-11-2008, 07:17 PM
Gates Is Antichrist's Avatar
Gates Is Antichrist Gates Is Antichrist is offline
Member
SOA AAA
 
Join Date: Feb 2002
Location: Hell
Favorite beer: Pacifico
Posts: 161
Default

Quote:
Originally Posted by Guilty Bystander View Post
I have an excel macro. I open a text file with policy information, I calculate some values on a worksheet, then capture output to a second text file with a write statement. I''m doing this on a seriatim basis and everything works fine, but I'd like to speed things up.
I agree with the prior posts, and just throw in this cutie, which is mondo compact and it ain't slow. This is for fixed length records. (I've only used Line Input otherwise)
Code:
  Dim myStr(99999) As String * 82
  Open "foobar.txt" For Binary As #1  
  Get #1, , myStr
  Close #1
If speed matters - sorry, Microsoft, but someone has to care about it - IMO the most serious Excel calculation resource is
http://www.decisionmodels.com/optspeedd.htm and
http://www.decisionmodels.com/calcsecretsj.htm and the rest of that site.

If you post your code, you might get more specific advice.
__________________
______
ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor.
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 11:45 AM.


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.45372 seconds with 11 queries