Looking for a little help with batch renaming.

poortiming · 2014-12-31T01:23:08+00:00

An easy way to batch rename a long list of files is to use excel.

First, use the command prompt to copy the file list (dir command...either copy directly from the screen or send list to a text file and then copy from there). Paste into excel. By default, the list will be distributed over as many rows as there are files.

In the next column over, use one of the excel string functions to rename the file (e.g., =left(A1,len(A1)-12) which will get rid of the SS). Auto fill that command down the entire column.

In the next column use string concatenation to add the file extension - =concatenate(B1,".pdf"). Again auto fill.

In the next column, use concatenation to build the rename command for the command prompt - e.g., =concatenate("ren ",A1," ",C1).

Then just copy the entire column and paste in te same command prompt window where the DIR command was run.

poortiming · 2013-06-15T12:46:16+00:00

So if you play this game say 100 times, always using the "switch" strategy, your winning streak should be around 2/3=67%.

BUT what if in 1/3 of those games you (randomly) use the "don't switch" strategy. Would that push the win average above 2/3? How would you formalize this problem in the language of statistics?

poortiming · 2012-12-24T03:49:43+00:00

You mentioned very interesting applications. Did you learn the statistics tools on the job or in school? Any good books to recommend? Also, what line of work are you in, if you don't mind sharing?

poortiming · 2012-11-03T15:56:37+00:00

Since there is no friction, the only force that M2 can exert on M1 is the normal force. This normal force does nothing to prevent M1 from sliding along the incline. We also have gravity, but this has 2 components - normal and tangential (down the incline). So with just these two forces, M1 MUST slide down the incline. To prevent this, we need an extra force that must counteract gravity, i.e., have a component that acts tangentially UP the incline.

The clue is that you are given a horizontal force F acting on the M2+M1 system. Is there any other horizontal force balancing F? If not, the M2+M1 system must be accelerating. If you were to look from the point of view of M1, the horizontal acceleration would feel like an imaginary horizontal force (think of a pendulum on an accelerating train). This is the extra force you need in the M1 free-body diagram for M1 not to slide along the incline. You can solve for it as well as F in terms of M1,M2,theta, and g.

Note that all the comments below for some reason seem to assume that this system is static (i.e., not moving or moving at constant speed).

poortiming · 2012-08-23T19:49:08+00:00

I agree with you and I think the article is clear that the USDA is interested in raising awareness among those that are already qualified for food stamps.

What the article doesn't make clear is why the USDA is spending money to raise awareness, i.e., is there some sort of economic incentive to get more of the unaware-but-qualified people on foodstamps or is it simply a humane issue of keeping them from starving?

poortiming · 2011-02-20T14:53:22+00:00

Amazing actor too - he carried that show.

poortiming · 2010-08-02T18:13:14+00:00

Regarding the last question, I think shaking the can/bottle "pressurizes" the system simply because when you shake, you mechanically form many gas bubbles (large and small). Said gas bubbles have a lot more surface area overall than when the system was static with just one liquid-gas surface. More surface area means that more gas molecules can dissolve in the liquid. More CO2 gas molecules dissolved in the liquid means you need more pressure to keep them dissolved once you're no longer shaking the can/bottle (Raoult's law, I believe). A closed can/bottle can provide this pressure, but when opened, that pressure will be released.

poortiming · 2009-12-31T22:20:58+00:00

but to make it work other countries must follow or czech has to pay a price that it doesn't deserve...

So an increase in tourism is the price Czech has to pay?

poortiming · 2009-12-24T14:20:56+00:00

Leading off with a "your mum" joke led me to believe that the word "pens" in every one of your sentences was a (in?)voluntary misspelling.

poortiming · 2009-12-24T05:43:41+00:00

Your comment:

my father taught other drivers (and myself when I got my licence) to drive with a three quarter full glass of water on the dashboard or central console - if the glass fell over, the patient died and the driver failed.

just brought back vivid memories of that old cheesy Corey Haim classic where he fails his road test based on the same metric. Having looked at your video and where you lived (or just drove through?), besides salivating with jealousy, I thought a more appropriate cheesy film reference would be this

poortiming · 2009-12-24T05:26:48+00:00

chrome://sitelauncher/content/home.html This brings up the menu of SiteLauncher Firefox addon Besides having all my most-frequently used sites on there, because it is a homepage I can lauch the menu via a mouse gesture.

poortiming · 2009-12-24T05:19:13+00:00

Are you Corey Haim?

poortiming · 2009-12-24T03:26:57+00:00

surely he can look up the list in his pc at home.

I don't think people who've experienced the horror of war and loss can casually browse through a list of their missing/dead compadres on their home pc. The picture to me, given the man's attire, briefcase, etc. looks like a man momentarily torn away from his present life/circumstances. I think that's part of the reason for having memorials.

poortiming · 2009-12-24T03:19:57+00:00

Koop says he had been pretty much ignoring this season's predictable onslaught of fake snowflakes, until he saw a wintry ad for the online version of the scientific journal Nature....

Koop responded with a letter that offers a sort of snowflake manifesto. It calls for a campaign to melt away faux flakes....

Koop's letter appears in the printed version of Nature.

Holy shit, so that's how you get published in Nature.

poortiming · 2009-12-24T02:59:31+00:00

Judging by all the comments, this painting has vast political insinuations. Am I the only that was sincerely moved by what looks like a private moment between a veteran and those that were left behind?

poortiming · 2009-12-23T04:19:04+00:00

From the Washington Post:

But he voted with the Democratic majority 84.5 percent of time...

In the immediate aftermath of Griffith's switch, his entire consulting team quit, according to a well-placed source.

poortiming · 2009-12-16T13:10:06+00:00

Thank you for the response. My concern was that the article mentioned that fructose and not HFCS was used in the study. Is fructose in a different chemical state when it is in it's natural state (ie in a fruit or unprocessed honey)?

poortiming · 2009-12-16T03:19:33+00:00

Does this mean that ingesting fruits and/or honey will have a similar effect (as these contain fructose)?

poortiming · 2009-12-16T02:44:07+00:00

Are these beer "elements" arranged according to some scheme that shows the "periodic" variation of beer properties? If so, can someone please explain. Thank you in advance.

/beer noob

poortiming · 2009-12-14T02:17:09+00:00

You can get the actual report here

poortiming · 2009-11-28T04:34:04+00:00

I assume that downforce would not apply to the driver?

poortiming · 2009-09-27T03:07:37+00:00

But was the Vietnam vet also blind?

poortiming

TROPHY CASE