Monthly Archives: March 2010

Sporadic Application Suggestions (1)

Autohotkey Version 1.0.48.05

You are sick doing same boring tasks on the machine? Copying, verifying, deleting etc., and other time wasting things? Here comes your deliverance: „AutoHotkey“. I was stumpling over the tiny little PORTABLE program when I was looking for a solution automatising key inputs. The program comes with a very simple srcipt language to control the automatisiesd tasks.

1. Photographing GoogleEarth using the SCREEN PRINT key, importing and saving the image and finally stiching all the continiously taken images together.

2. Second application for AutoHotkey I use is when working with EXCEL. I have often moving, deleting, and copying cell contents to other (fixed or relative) places in the sheets. If you have a sheet over 10`000 Rows and 100 columns AutHotkey is doing the job during you lunch break :).

According to example 2 a ready to use script can looks like as follows:

;Copy Cells xmin ymin xmax ymax
 ;define the HOT KEY
 !+c:: ;Alt+Shift+c
 ;Type in the no. of loops BEFORE running the script
 loops:=74
 ;
 loop %loops%
 {
 Send {LCtrl Down}c{LCtrl Up}
 Sleep 50
 Send {Down}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Up}{Right 3}{LCtrl Down}c{LCtrl Up}
 Sleep 50
 Send {Left 2}{Down}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Up}{Right}{LCtrl Down}c{LCtrl Up}
 Sleep 50
 Send {Left 2}{Down 2}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Down}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Up 3}{Right}{LCtrl Down}c{LCtrl Up}
 Sleep 50
 Send {Down 2}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Up 2}{Right 2}{LCtrl Down}c{LCtrl Up}
 Sleep 50
 Send {Left 2}{Down 3}{LCtrl Down}v{LCtrl Up}
 Sleep 50
 Send {Left}{Down}
 }
 Return
Here is the data set: (xmin/xmax,ymin/ymax are GK4 coordinates)
IMAGE XMIN YMIN XMAX YMAX
_4408_5700_200801.tif 4408000 5700000 4410000 5702000
_4410_5700_200801.tif 4410000 5700000 4412000 5702000
_4412_5704_200801.tif 4412000 5704000 4414000 5706000
_4414_5706_200801.tif 4414000 5706000 4416000 5708000
_4416_5702_200801.tif 4416000 5702000 4418000 5704000
_4418_5704_200801.tif 4418000 5704000 4420000 5706000
_4420_5706_200801.tif 4420000 5706000 4422000 5708000
_4422_5700_200801.tif 4422000 5700000 4424000 5702000
_4424_5704_200801.tif 4424000 5704000 4426000 5706000
_4426_5706_200801.tif 4426000 5706000 4428000 5708000
_4428_5702_200801.tif 4428000 5702000 4430000 5704000
_4406_5696_200803.tif 4406000 5696000 4408000 5698000
_4406_5698_200803.tif 4406000 5698000 4408000 5700000
_4406_5700_200801.tif 4406000 5700000 4408000 5702000
_4406_5702_200801.tif 4406000 5702000 4408000 5704000
_4406_5704_200801.tif 4406000 5704000 4408000 5706000
_4406_5706_200801.tif 4406000 5706000 4408000 5708000
_4408_5696_200803.tif 4408000 5696000 4410000 5698000
_4408_5698_200803.tif 4408000 5698000 4410000 5700000
_4408_5702_200801.tif 4408000 5702000 4410000 5704000
_4408_5704_200801.tif 4408000 5704000 4410000 5706000
_4408_5706_200801.tif 4408000 5706000 4410000 5708000
_4410_5696_200803.tif 4410000 5696000 4412000 5698000
_4410_5698_200803.tif 4410000 5698000 4412000 5700000
_4410_5702_200801.tif 4410000 5702000 4412000 5704000
_4410_5704_200801.tif 4410000 5704000 4412000 5706000
_4410_5706_200801.tif 4410000 5706000 4412000 5708000
_4412_5696_200803.tif 4412000 5696000 4414000 5698000
_4412_5698_200803.tif 4412000 5698000 4414000 5700000
_4412_5700_200801.tif 4412000 5700000 4414000 5702000
_4412_5702_200801.tif 4412000 5702000 4414000 5704000
_4412_5706_200801.tif 4412000 5706000 4414000 5708000
_4414_5696_200803.tif 4414000 5696000 4416000 5698000
_4414_5698_200803.tif 4414000 5698000 4416000 5700000
_4414_5700_200801.tif 4414000 5700000 4416000 5702000
_4414_5702_200801.tif 4414000 5702000 4416000 5704000
_4414_5704_200801.tif 4414000 5704000 4416000 5706000
_4416_5696_200803.tif 4416000 5696000 4418000 5698000
_4416_5698_200803.tif 4416000 5698000 4418000 5700000
_4416_5700_200801.tif 4416000 5700000 4418000 5702000
_4416_5704_200801.tif 4416000 5704000 4418000 5706000
_4416_5706_200801.tif 4416000 5706000 4418000 5708000
_4418_5696_200803.tif 4418000 5696000 4420000 5698000
_4418_5698_200803.tif 4418000 5698000 4420000 5700000
_4418_5700_200801.tif 4418000 5700000 4420000 5702000
_4418_5702_200801.tif 4418000 5702000 4420000 5704000
_4418_5706_200801.tif 4418000 5706000 4420000 5708000
_4420_5696_200804.tif 4420000 5696000 4422000 5698000
_4420_5698_200804.tif 4420000 5698000 4422000 5700000
_4420_5700_200801.tif 4420000 5700000 4422000 5702000
_4420_5702_200801.tif 4420000 5702000 4422000 5704000
_4420_5704_200801.tif 4420000 5704000 4422000 5706000
_4422_5696_200804.tif 4422000 5696000 4424000 5698000
_4422_5698_200804.tif 4422000 5698000 4424000 5700000
_4422_5702_200801.tif 4422000 5702000 4424000 5704000
_4422_5704_200801.tif 4422000 5704000 4424000 5706000
_4422_5706_200801.tif 4422000 5706000 4424000 5708000
_4424_5696_200804.tif 4424000 5696000 4426000 5698000
_4424_5698_200804.tif 4424000 5698000 4426000 5700000
_4424_5700_200801.tif 4424000 5700000 4426000 5702000
_4424_5702_200801.tif 4424000 5702000 4426000 5704000
_4424_5706_200801.tif 4424000 5706000 4426000 5708000
_4426_5696_200804.tif 4426000 5696000 4428000 5698000
_4426_5698_200804.tif 4426000 5698000 4428000 5700000
_4426_5700_200801.tif 4426000 5700000 4428000 5702000
_4426_5702_200801.tif 4426000 5702000 4428000 5704000
_4426_5704_200801.tif 4426000 5704000 4428000 5706000
_4428_5696_200804.tif 4428000 5696000 4430000 5698000
_4428_5698_200804.tif 4428000 5698000 4430000 5700000
_4428_5700_200801.tif 4428000 5700000 4430000 5702000
_4428_5704_200801.tif 4428000 5704000 4430000 5706000
_4428_5706_200801.tif 4428000 5706000 4430000 5708000
_4430_5696_200804.tif 4430000 5696000 4432000 5698000
_4430_5698_200804.tif 4430000 5698000 4432000 5700000

The result will be a rearranged list of the coordinates. Please keep in mind that this short tutorial will not replace the very detailed HELP file coming with the installation package.

Try it out, comments are wellcome. I like it.
Btw: Half of the Harz Mountains is nearly stiched together, georeferenced, and imported into GIS for MTB route planning 🙂

Ciao Michael
Advertisements

1 Comment

Filed under Uncategorized

Visiting Albert Einstein Exhibition on PI Day

Entrance Of The Historical Museum Bern

Having a nica afternoon in Bern

visiting the Albert Einstein exhibition on PI Day

and have realised Einsteins 141th birthday

unfortunately time was running out beeing in the museum 😦

2 Comments

Filed under Uncategorized

A few free days

Watch the Swiss watches!

winter wonderland

jammy ....

Icy Tinguely sculpture

Finished school in Aarau, worked in Bern & Zurich

1 Comment

Filed under Uncategorized

A rainy winter tour in the Elbsandstein (Großer Zschand)

Scenic view from the Goldsteig

Just to show that it was really a rainy day ...

It's time to turn that into green!

Snowy Goldsteig

Guess what happens next! ...

... Exactly - beauty of nature has to be destroyed!

2 Comments

Filed under Uncategorized

Alexa pt. I

Lexi1

Supper's Ready

Think of me with kindness @Dude 😉

Rollin' down the hill

3 Comments

Filed under Uncategorized

HaiBike – winter

That’s my ‘City Bike’ – winter-equipped … illuminated by the sunset on top of the Reiche Zeche.

HaiBike "High End", high modulus carbon fibre, winter-equipped, ca. 9 kg

Leave a comment

Filed under Uncategorized

Winter BBQ

Winter BBQ at my backyard

Leave a comment

Filed under Uncategorized