Universally unique identifier Puns

Long name, short implementation, great idea.

ULID is a splendid idea for databases and I started using it as soon as I heard about it, at some point a client wanted to use his Window box to browse DB data and yes... do some edits U__U, so I needed to parse the thing.

I'm not gonna go over the same points the author makes about why GUIDs are a "bad" thing but yeah, they are. As for generation I've experienced first hand issues with COM not being available in some systems, so... this is an option.

Hope you find it useful Lib\ULID.ahk.

I am curious about this.

I know there was a doc that explained when/how a new unique identifier is created. I've been looking for an hour and my google fu has failed me.

Does anyone have a link to the doc that explains it? I believe if mac address changes for example new ID is created.

As the title states, I’m looking for a card scanner app that has support for both gold bordered cards and exporting with a unique identifier preferably oracle_id from Scryfall). I have yet to find one that does both. Am I missing any? Perhaps the community knows of a dev for one of the apps that might be willing to add such support. Looking for an iOS or even a desktop version (I have no android device with which to scan).

I would pay cold hard American dollars for such an app… and by cold hard American dollars I mean electronic ones and zeros transferred from my imaginary collection of money to your imaginary collection of money.

Hello!

I am trying to insert unique identifiers on labels in mail merge on Word. The unique identifiers are written like this: "UI_0001". I keep trying to do it in word, but the unique identifier appears as "1,2,3..". Is there a way to make this happen, because I have over 1000 labels to do and I'd rather not have to input them manually?

Thanks.

Motherboards have a MAC address that programs on your PC can read and track, but do CPUs have anything similar to that which can be tracked? I'm asking mainly out of curiosity.

Hi all.

Say I have two spreadsheets.

Sheet 1 has data with unique IDs associated.

Sheet 2 has different data with the same unique IDs (only on select rows).

I need to import certain columns to sheet 1 from sheet 2 & have them match the rows on sheet 1 according to the unique IDs. But only export the data from the rows that indeed have the unique IDs.

What would be the function here so that I can not alter any data on sheet 1, but add the relevant columns from sheet 2 in the proper rows?

What is the likely value of n?

• We know that there are more possible games of go than there are atoms in the universe. This is actually a difficult mathematical problem - even coming up with a "number of possible games" is a difficult proof since you've got Ko's, Superkos, and triple-ko loops in a mind-boggingly large number. It's widely accepted though that the number of atoms in the universe is roughly 10^80.

• The number of legal positions in Go is higher than 10^80, with it being roughly 2x10^170. You can imagine there are near infinite ways to reach many of those board positions, because many will pass through many others. It's an absurd problem to try to constrain, but at the end you can be nearly certain that your board position is unique from every other end state that has ever occurred, assuming your game played out n rounds.

Ok, now that that's out of the way... let's talk about things that aren't mind boggingly unique.

Fuseki. Your average game can probably be constrained to a heat map of likely positions. The four corners will likely be filled in some order, and then enclosed in some order, and so on. 10 moves into the game, it's very likely you're playing someone else's game. Even 20 moves in, you're likely performing a joseki that someone has followed up with at some point.

At what move number n can you be relatively certain that you're in unique territory?

The question is simple, why does the Dfinity foundation need our IPs, unique identifiers among other things about how the software is being used for SDK users? Without any mention of anonymization procedures either. Knowing the identity of the user and what he's building does nothing to "help improve" the SDK.

An SDK that calls home and sends personal information to Dfinity's servers is no different than Chrome phoning home to Google to send information about the user which could be shared, hacked or even sold to nefarious parties. This information is taken from Dfinity SDK own terms of service

https://sdk.dfinity.org/docs/index.html

links to:

https://download.dfinity.systems/sdk/sdk-license-agreement.txt

which contains the following:

>7. PRIVACY AND INFORMATION. In order to continually innovate and improve the DFINITY Canister SDK, DFINITY may collect certain usage statistics from the software including but not limited to a unique identifier, associated IP address, version number of the software, and information on which tools and/or services in the DFINITY Canister SDK are being used and how they are being used. This collection is turned on by default, but you have the option to opt out. If you opt out, the information will not be collected. The data collected is examined in the aggregate to improve the DFINITY Canister SDK and is maintained in accordance with DFINITY’s Privacy Policy. Notwithstanding the foregoing, DFINITY does not collect your private keys or any data from which private keys are derived.

Given Dfinity's lack of transparency this is unsurprising. I wonder what other surprises the base protocol will bring, probably more privacy concerns. Not accidental, designed. But now it's showing that privacy is maybe not a priority for Dfinity.

Replies saying "but you can opt out" will be missing the point of unnecessary data collection even before day 1. At this point privacy cannot be guaranteed for Dfinity's developers or users.

I am trying to import some student options from one type of timetabling software to another.

The first piece of software exports the options in two columns, the first being id and the second with the option. If a student has multiple options then they appear multiple times.

https://preview.redd.it/mmxc262omhn61.png?width=341&format=png&auto=webp&s=741e82674ea408eb14256961e06c27cf93392c7b

Where the new software wants a new column for each subject and the id to only occur once.

https://preview.redd.it/w9r7jzhbnhn61.png?width=749&format=png&auto=webp&s=41960f97ce35a0a81f30fe5764f04bfb1109f85e

I don't even know where to start on this one or even how to phrase the question to google it.

I don't really want to do it manually considering that there is 1200 students with upto 10 options per student.

Any ideas?

Hi,

I need to generate a unique identifier for payment processing, within which I would like to encode the payment date, value, and accountancy code, so I can cross check in accountancy audits later on.

The payment information includes the following elements:

date, payment value, accountancy code of recipient.
31/03/2021, 150.25, P000168
31/03/2021, 3562.43, P000MGH
31/03/2021, 235.00, PM0051

My current thoughts are:

Convert the date to decimal, obtain a single check digit for the payment value (multiply by 100 to remove decimal, and obtain Modulo 7), convert accountancy alfanumeric code to a check digit, create a check digit for accountancy code, concatenate all together, and convert to Hex value

Something along the lines of :

=DEC2HEX(CONCATENATE(TEXT(A1,0), MOD((B1*100),7), [PROBLEM]))

[PROBLEM] is the function I am stuck on. I am at a loss to convert the alfanumeric accountancy code to number.(not uniform length) If I strip out alphabetical, there will be too many identical results.

Secondly, with current set up, the resulting number is not unique. I am thinking of adding another number maybe random via =RANDBETWEEN(1,999), or maybe the sequence in the payment list.

The underlying idea is to automate payments, but also run checks to make sure no errors have occurred in the automation.

Ideas and pointers are welcome.

Thanks!

I’ve been given a large spreadsheet (which I’ve posted about before!). It is a matrix that has over 10,000 rows and 600 columns. I want to make it easy for end users by providing a summary page because each column might only have a couple of “Yes” so it’s time consuming scrolling through 10,000 rows! I would like a summary page where the column headings from the matrix are listed vertically and all the non blanks are listed in the row next to it.

As an example: the columns are the name of the system and the rows are the employees with a “yes” entered if they do have access to the system. So on the summary I want a list of system names in column A and then I want all the systems they have access to in the cells next to them. So the list would be SYSTEM | EMPLOYEE 2 | EMPLOYEE 16 etc

Hopefully this makes sense and thank you in advance for any help!!

Hi! Using Airtable for Project Management and I'm building a "Grid View" within my "Project Table" that will create unique identification for projects submitted via form.

Each project will have at least one stakeholder attached, but some projects may have more than one stakeholder attached.

Those stakeholders exist in a linked table called "Stakeholders"

What I'd like to accomplish with a formula within my Project Identifier Grid View is to show ONLY the first stakeholder that is linked to a particular project.

Is there something similar to "LEFT(string, howMany)" that allows me to only display the first record from a linked field?

Thanks very much in advance for your help.

Basically what the title says. I have several servers with pairs of PM1725 AICs in them. I set them up in Storage Spaces as a mirror. All works well and I don't generally have any issues. Most of my servers are running Server 2019 and they all have the Samsung driver loaded for the PM1725 which is retrieved via Windows Update by checking for updates in device manager.

Now I have one Windows Server 2016 box with two of these cards. All is the same, but when I load the Samsung driver, Storage Spaces suddenly only sees a single physical card. Both are visible and healthy and work fine independently in Disk Management and are detected by the Samsung DC Tool. This is the same Samsung driver that I see gets loaded on the Server 2019 systems. If I run:

Get-PhysicalDisk | select FriendlyName,UniqueID

I can see that both cards have the SAME "unique" ID listed as "EUI.0". I'm certain this is the source of the reason Storage Spaces only sees one device, because they have the same unique ID.

If I roll the driver back to the default "Standard NVMe Express Controller" driver from Microsoft, this behavior changes and the unique ID is a long truly unique string on each. Storage Spaces then sees two cards.

I don't see this behavior on my Server 2019 boxes with the Samsung driver. My only thought is it's some sort of bug in Server 2016 and I should just plan to upgrade the box to hopefully correct this.

I'm wondering if anyone else has seen this behavior before and know the reasoning?

Thanks!