Participant Identification Code - Revision history

E.vandenberge: /* OpenOffice / LibreOffice */

2026-08-10T12:07:49Z

OpenOffice / LibreOffice

← Older revision		Revision as of 12:07, 10 August 2026
Line 25:		Line 25:

	==== OpenOffice / LibreOffice ====		==== OpenOffice / LibreOffice ====
	If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to OpenOffice/ LibreOffice you can use [https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods this document] to calculate PIC. You may have to enable macros for it to work.		If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to OpenOffice/ LibreOffice you can use {{Download link\|https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods\|this document}} to calculate PIC. You may have to enable macros for it to work.

	==== Google Sheets ====		==== Google Sheets ====

Wilbert.vanham: check procedure

2020-04-29T11:05:15Z

check procedure

← Older revision		Revision as of 11:05, 29 April 2020
Line 17:		Line 17:

	''R.E.Searcher@socsci.ru.nl''		''R.E.Searcher@socsci.ru.nl''

			If a participant later comes to you with a PPN and a PIC, you go and lookup your ES. Based on your ES and the PPN given to you by the participant, you recalculate the PIC. If this is identical to the PIC supplied by the participant, then the participant is indeed the person identified by the given PPN in your data file.
	=== Example ===		=== Example ===
	[[File:pic.png\|frame\|Calculating Participant Identification Code in LibreOffice]]		[[File:pic.png\|frame\|Calculating Participant Identification Code in LibreOffice]]

Wilbert.vanham: better picture

2020-04-24T12:01:12Z

better picture

← Older revision		Revision as of 12:01, 24 April 2020
Line 18:		Line 18:
	''R.E.Searcher@socsci.ru.nl''		''R.E.Searcher@socsci.ru.nl''
	=== Example ===		=== Example ===
	[[File:~~PIC libre office~~.png\|frame\|Calculating Participant Identification Code in LibreOffice]]		[[File:pic.png\|frame\|Calculating Participant Identification Code in LibreOffice]]
	==== Online ====		==== Online ====
	Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.		Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.

Wilbert.vanham at 10:03, 24 April 2020

2020-04-24T10:03:03Z

← Older revision		Revision as of 10:03, 24 April 2020
Line 18:		Line 18:
	''R.E.Searcher@socsci.ru.nl''		''R.E.Searcher@socsci.ru.nl''
	=== Example ===		=== Example ===
			[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in LibreOffice]]
	==== Online ====		==== Online ====
	Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.		Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.
Line 23:		Line 24:
	==== OpenOffice / LibreOffice ====		==== OpenOffice / LibreOffice ====
	If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to OpenOffice/ LibreOffice you can use [https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods this document] to calculate PIC. You may have to enable macros for it to work.		If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to OpenOffice/ LibreOffice you can use [https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods this document] to calculate PIC. You may have to enable macros for it to work.
	~~[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in LibreOffice]]~~

	==== Google Sheets ====		==== Google Sheets ====

Wilbert.vanham at 09:58, 24 April 2020

2020-04-24T09:58:49Z

← Older revision		Revision as of 09:58, 24 April 2020
Line 31:		Line 31:
	In Python 3 you can easily calculate pic. Note that ''secret'' and the ''ppn'' must be strings.		In Python 3 you can easily calculate pic. Note that ''secret'' and the ''ppn'' must be strings.

	#!/usr/bin/env/python3		#!/usr/bin/env python3
	import hashlib		import hashlib
	secret = "mySecret123!"		secret = "mySecret123!"

Wilbert.vanham at 09:56, 24 April 2020

2020-04-24T09:56:52Z

← Older revision		Revision as of 09:56, 24 April 2020
Line 26:		Line 26:

	==== Google Sheets ====		==== Google Sheets ====
	You can also calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet].		You can also calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet]. Use ''File'' -> ''Make a copy'' if you want to alter the document.

	==== Python 3 ====		==== Python 3 ====

Wilbert.vanham: add import

2020-04-24T09:53:48Z

add import

← Older revision		Revision as of 09:53, 24 April 2020
Line 32:		Line 32:

	#!/usr/bin/env/python3		#!/usr/bin/env/python3
			import hashlib
	secret = "mySecret123!"		secret = "mySecret123!"
	ppn = "0"		ppn = "0"

Wilbert.vanham: /* Python 3 */ typesetting

2020-04-24T09:53:07Z

Python 3: typesetting

← Older revision		Revision as of 09:53, 24 April 2020
Line 29:		Line 29:

	==== Python 3 ====		==== Python 3 ====
	In Python 3 you can easily calculate pic. Note that ~~the~~ secret and the ppn must be strings.		In Python 3 you can easily calculate pic. Note that ''secret'' and the ''ppn'' must be strings.

	#!/usr/bin/env/python3		#!/usr/bin/env/python3
	secret = "mySecret123!"		secret = "mySecret123!"
	ppn = "0"		ppn = "0"
	pic = hashlib.sha256(secret.encode('utf-8')+ppn.encode('utf-8')).hexdigest()[0:4].upper()		pic = hashlib.sha256(secret.encode('utf-8')+ppn.encode('utf-8')).hexdigest()[0:4].upper()
	print(pic)		print(pic)

	== Rationale ==		== Rationale ==

Wilbert.vanham: /* Example */ add python

2020-04-24T09:51:40Z

Example: add python

← Older revision		Revision as of 09:51, 24 April 2020
Line 18:		Line 18:
	''R.E.Searcher@socsci.ru.nl''		''R.E.Searcher@socsci.ru.nl''
	=== Example ===		=== Example ===
			==== Online ====
	Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.		Try this [https://www.socsci.ru.nl/wilberth/computer/pic.html calculator] to make these checksums yourself.

	If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to ~~Open Office~~/ ~~Libre Office~~ you can use [https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods this document] to calculate PIC. You may have to enable macros for it to work.		==== OpenOffice / LibreOffice ====
	[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in ~~Libre Office~~]]		If you install the [https://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg cryptographic hash] extension to OpenOffice/ LibreOffice you can use [https://www.socsci.ru.nl/wilberth/nocms/computer/pic.ods this document] to calculate PIC. You may have to enable macros for it to work.
			[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in LibreOffice]]

			==== Google Sheets ====
	You can also calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet].		You can also calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet].

			==== Python 3 ====
			In Python 3 you can easily calculate pic. Note that the secret and the ppn must be strings.

			#!/usr/bin/env/python3
			secret = "mySecret123!"
			ppn = "0"
			pic = hashlib.sha256(secret.encode('utf-8')+ppn.encode('utf-8')).hexdigest()[0:4].upper()
			print(pic)

	== Rationale ==		== Rationale ==

Wilbert.vanham at 09:23, 24 April 2020

2020-04-24T09:23:22Z

← Older revision		Revision as of 09:23, 24 April 2020
Line 23:		Line 23:
	[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in Libre Office]]		[[File:PIC libre office.png\|frame\|Calculating Participant Identification Code in Libre Office]]

	You can ~~alse~~ calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet].		You can also calculate the PICs with this [https://docs.google.com/spreadsheets/d/18jmxpui2rr3dShySQiyn06kX36cCHHGRgan2MGGXjlo/edit?usp=sharing Google Sheet].

	== Rationale ==		== Rationale ==