Pocket Geiger: Testing Gas Mantle containing Thorium

comments Comments Off on Pocket Geiger: Testing Gas Mantle containing Thorium
By , 22/10/2016 20:30

I tested the PocketGeiger Type 5 ( in combination with an Arduino Nano (Atmega 328). For test radiator I use an gas mantle, a cloth soaked in thorium nitrate salt. This light radioactive material is emmiting about 5 µSv/h (beta and gamma rays). In comparison, Uranium ammunition has emission of 2 mSv/h on direct skin contact ([1]).

Gas mantle PocketGeiger Type 5

 

The PocketGeiger has no Geiger–Müller tube, instead it has a PIN diode. The schematics can be downloaded here [2].

PocketGeiger Gas Mantle Thorium

[1] Factsheet about depleted Uranium Ammunition (german)

[2] Schematics for PocketGeiger Type 5

 

Excel: VBA Macro export Sheet to PDF on WorkbookAfterSave

comments Comments Off on Excel: VBA Macro export Sheet to PDF on WorkbookAfterSave
By , 21/10/2016 20:34

In Excel many things can be automated using VBA (Visual Basic for Application) macros. Here is an example on how to export a PDF for the first sheet in an Excel workbook. Therefore, the script selects the printable area which has to be defined by the user, once.

Add this code to “ThisWorkbook” by opening the VBA-Editor [ALT]+[F11]:


Option Explicit

Private WithEvents App As Excel.Application

Private Sub Workbook_Open()
    
    Set App = Excel.Application
End Sub

Private Sub App_WorkbookAfterSave(ByVal Wb As Workbook, _
                                  ByVal Success As Boolean)
       
    If Wb Is ThisWorkbook And Success Then
        ExportPdfForFirstSheet Wb.Name
    End If
End Sub

Private Sub ExportPdfForFirstSheet(ByVal OriginalFileName As String)
    On Error Resume Next
    
    Dim currentPrintArea
    Dim currentWorksheet
    Dim documentName As String
    Dim fso As Object
    
    ' Create helper object handling file names.
    Set fso = CreateObject("scripting.filesystemobject")
            
    ' Extract document name from file name.
    documentName = fso.GetBaseName(OriginalFileName)
                  
    ' Select first sheet.
    ThisWorkbook.Sheets(1).Select
              
    ' Selecting print area for export.
    Set currentWorksheet = ThisWorkbook.ActiveSheet
    Set currentPrintArea = currentWorksheet.Range( _
                               currentWorksheet.PageSetup.printArea)
    currentPrintArea.Select
          
    ' Exporting selected area.
    Selection.ExportAsFixedFormat _
        Type:=xlTypePDF, _
        fileName:=ThisWorkbook.path & "\" & documentName & ".pdf", _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=True
        
    If Err.Number <> 0 Then
        MsgBox "Unable to create PDF:" & vbCrLf & Err.Description
    End If
End Sub



Sharing private Videos

comments Comments Off on Sharing private Videos
By , 14/10/2016 23:32

Private videos can be easily shared with http://videosprout.com. Just upload the video and share the direct link which contains a unique id. It is not shown on the platform and is hidden from all others.

videosprout

Handbrake: Rotate Videos

comments Comments Off on Handbrake: Rotate Videos
By , 14/10/2016 23:24

Rotating videos in Handbrake (tested version 0.10.5.0) is done by supplying a special string in the field “Extra Options:” of the video tab.

HandBrake Rotate Videos with Extra Options

HandBrake Rotate Videos with Extra Options

 

FunctionExtra Option String
Rotate 90° clockwise, --rotate=4
Rotate 90° counterclockwise, --rotate=7
Rotate 180° / flip vertically, --rotate=3

 

And some more, see Rotate videos using handbrake.

PHP: Synchronisierung CardDAV-Server mit Fritz.Box

comments Comments Off on PHP: Synchronisierung CardDAV-Server mit Fritz.Box
By , 09/10/2016 18:47

Synchronizing contacts between multiple devices is a pain. But the following PHP script reduces the pain to sync the phonebook of the Fritz.Box! with a CardDAV-Server.

https://github.com/carlos22/carddav2fb

Python: Storyboard from Video File with VLC Remote Control

comments Comments Off on Python: Storyboard from Video File with VLC Remote Control
By , 07/10/2016 16:58

You want to create a screenshot series automatically from a video see Python: Storyboard from Video File with VLC Remote Control.

Water skiing in Jagel

comments Comments Off on Water skiing in Jagel
By , 18/09/2016 10:43

Long-Term recording with Wireshark (multiple files)

comments Comments Off on Long-Term recording with Wireshark (multiple files)
By , 16/09/2016 17:48

The terminal program TShark.exe in the program folder allows user to customize (for easy reuse) and start Wireshark recordings.


tshark -i 1 -a duration:86400 -b duration:3600 -w C:\tmp\test.pcap

Options:
-a duration:<interval>: defines the recording stop condition. In this example the maximum interval to record is 1 day (86400 sec.).
-b duration:<interval>: defines the size of the ring buffer. After exceeding the limit a file switch happens, in this example every hour (3600 sec.)
-i <interface>: interface number
-w <filepath>: target file

The resulting filenames look the following:
test_00001_20160914102510.pcap
test_00002_20160914112510.pcap
test_00003_20160914122510.pcap

test_00024_20160915102510.pcap

Study the help. There are some interesting possibilities.

Help: https://www.wireshark.org/docs/man-pages/tshark.html

MSSQL: Re-mapping SQL users and Windows users

comments Comments Off on MSSQL: Re-mapping SQL users and Windows users
By , 22/04/2016 22:00

The following article shows how to re-map SQL users and Windows users with instance logins in MSSQL. This might be necessary if you move your database to a different machine.

Re-mapping SQL users and Windows users in MSSQL

Besuch im Hamburg Minaturwunderland

comments Comments Off on Besuch im Hamburg Minaturwunderland
By , 31/01/2016 22:09

Hier sind die Fotos vom Hamburg Miniaturwunderland.

Bilder vom Hamburg Miniaturwunderland

OLYMPUS DIGITAL CAMERA

Panorama Theme by Themocracy