• Short guides to forum navigation, searching, posting, translation, alerts and notifications viewable by clicking here.
  • Türk dostlarımıza hoş geldiniz Giriş burada.
  • Scammers are running ads on Facebook and Instagram claiming a giveaway. DO NOT OPEN THESE LINKS AND LOG IN. See this thread: here
  • The Kinesis Community Forum will be down starting on Friday, Eastern Standard Time, and is expected to be back online on Monday. Big changes in the backend are coming!

[Forensics] KAG "Exchange physical for digital" (EPD)

About 1 eighth of KAG coin in circulation appears to originate from EPD.
The rest presumably is from Minting / Mint Cycling.

In the long list of replies in this thread, I shall attempt to guess (by automated methods) whether these EPDs came in as bars or coins. And whether as ozt or as kg.

This is going to be quite a slog (another word for real work)
 
Click to expand...
How to fetch EPD data directly from Kinesis blockchain?

Code: 
curl -L -X GET 'https://kag-mainnet.kinesisgroup.io/transactions?limit=100&order=asc' \
-H 'Accept: application/json' > t
5000+ lines in a jiffy

asc
for ASCending

100
just for demonstration purposes

That looks like this SNIPped (first 30 lines only):
Code: 
linux> head -30 t
{
  "_links": {
    "self": {
      "href": "https://kag-mainnet.kinesisgroup.io/transactions?cursor=\u0026limit=100\u0026order=asc"
    },
    "next": {
      "href": "https://kag-mainnet.kinesisgroup.io/transactions?cursor=4357557854408704\u0026limit=100\u0026order=asc"
    },
    "prev": {
      "href": "https://kag-mainnet.kinesisgroup.io/transactions?cursor=2173253455872\u0026limit=100\u0026order=desc"
    }
  },
  "_embedded": {
    "records": [
      {
        "_links": {
          "self": {
            "href": "https://kag-mainnet.kinesisgroup.io/transactions/edde94468f924ab0b159d0e48e73ec3beecdf3cf0ae31693ccbbe688eacdc324"
          },
          "account": {
            "href": "https://kag-mainnet.kinesisgroup.io/accounts/GAUCIFE37F4KQ5F6QPNSZ75QKRQTNRCF32FZNUXMCXUFSKRMWGF76LTI"
          },
          "ledger": {
            "href": "https://kag-mainnet.kinesisgroup.io/ledgers/506"
          },
          "operations": {
            "href": "https://kag-mainnet.kinesisgroup.io/transactions/edde94468f924ab0b159d0e48e73ec3beecdf3cf0ae31693ccbbe688eacdc324/operations{?cursor,limit,order}",
            "templated": true
          },
          "effects": {
 
The data we want appears to be in a memo field:
Code: 
linux> grep \"memo\" t
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "",
        "memo": "Mint #5291",
        "memo": "Mint #5319",
        "memo": "return test to emission",
        "memo": "Mint #5372",
        "memo": "Mint #5382",
        "memo": "Mint #5392",
        "memo": "test epd",
        "memo": "test epd",
        "memo": "pit return 1/2",
        "memo": "pit return 2/2",
        "memo": "Account Merge",
        "memo": "Account Merge",
        "memo": "EPD KAG 001",
        "memo": "Account Merge",
        "memo": "Mint #5406",
        "memo": "Mint #5439",
        "memo": "Mint #5458",
        "memo": "Account Merge",
        "memo": "EPD KAG 002",
        "memo": "Mint #5482",
        "memo": "Mint #5491",
        "memo": "Mint #5509",
        "memo": "Mint #5531",
        "memo": "Mint #5558",
        "memo": "Mint #5589",
        "memo": "Mint #5601",

SNiP
 
Bash that around to get what we want:
Code: 
linux> grep \"memo\" t | cut -d":" -f2 | sed 's/\"\|,//g' | sort 

linux> grep \"memo\" t | cut -d":" -f2 | sed 's/\"\|,//g' | sort | grep 'EPD\|EDP' | sort -k3

linux>  grep \"memo\" t | cut -d":" -f2 | sed 's/\"\|,//g' | sort | grep 'EPD\|EDP' | sort -k3
 EPD KAG 001
 EPD KAG 002
 EDP KAG 003
 EPD KAG 004
 EPD KAG 005
 EPD KAG 006
 EPD KAG 007
 EPD KAG 008
 EPD KAG 009
 
Code: 
linux> grep "EPD KAG 006" $KAG_extract

linux> echo $KAG_extract 
../Blockchain-Exploration/KAG/stellar-export-20230223-1606.csv
Not available from Derek's Watcher node CSV extract.

That's OK we can fetch it from here:
Code: 
linux> cd ../CI-dat/
linux> wget https://github.com/cryptoinformer0/kinesis-data/raw/main/kag-raw.csv
--2023-04-03 22:17:51--  https://github.com/cryptoinformer0/kinesis-data/raw/main/kag-raw.csv
Resolving github.com (github.com)... 140.82.121.3
Connecting to github.com (github.com)|140.82.121.3|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://raw.githubusercontent.com/cryptoinformer0/kinesis-data/main/kag-raw.csv [following]
--2023-04-03 22:17:52--  https://raw.githubusercontent.com/cryptoinformer0/kinesis-data/main/kag-raw.csv
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.111.133, 185.199.108.133, 185.199.109.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.111.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6905238 (6.6M) [text/plain]
Saving to: ‘kag-raw.csv.1’

kag-raw.csv.1                         100%[=========================================================================>]   6.58M  4.95MB/s    in 1.3s    

2023-04-03 22:17:54 (4.95 MB/s) - ‘kag-raw.csv.1’ saved [6905238/6905238]

eww. How could you do such a thing?

It's got the data.
I do not really know how to do a dump on the full history. Yet.
Code: 
linux> echo $KAG_CI_extract 
../CI-dat/kag-raw.csv

linux> grep "EPD KAG 006" $KAG_CI_extract
2019-05-01T07:06:58Z,5747e36766126aa75aee0eb6bbe924e97f0924eca3507cb25b893edcadc1242a,payment,EPD KAG 006,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GAOO4W4NHRSUVFPCVUA2BZTAMCJ6O7MBMXMDMUL6XEQ7Q6DBT6UTFD7V,100,0.45001,kag,TRUE

It looks as if that file was extracted by Python screen scrape in JAN-2023.
It's data. I likes data. I needs data.
Code: 
linux> ls -ng ../CI-dat/
total 6744
-rw-rw-r-- 1 1000 6905238 Apr  3 20:40 kag-raw.csv
linux> wc -l ../CI-dat/*
28387 ../CI-dat/kag-raw.csv
28K lines
28K transactions
Probably the full history of KAG
 
Check format of that extract file using same order as for Derek's extract file:

0, 1, 5, 8, 9

The blockchain displays text instead of numeric codes:
Code: 
for i in create_account payment set_options account_merge inflation
do
  echo $i
  cat $KAG_CI_extract | awk -F, -v type="$i" '($3==type) {print $0}' | head -1 | sed 's/,/\n/g' | nl -ba
done
head -1
Just the first record of each type
Code: 
create_account
     1    2022-12-30T12:04:53Z
     2    0c73f1f7654231dc740a51dc6cc3a5f960bd9cbfb829d3948ec02fce52295df2
     3    create_account
     4    
     5    GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
     6    GDZDXT5JDONAZ7TQ7QA42HSO62GMYLKU74AVFVS4NN4SFYMPVVFCJGCU
     7    1
     8    0.00451
     9    kag
    10    TRUE
payment
     1    2022-12-30T08:26:12Z
     2    4d192f8c6ac5474353231d4049f62dad796dc8f6bd53ed9e67becb90e4e8bcc1
     3    payment
     4    
     5    GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
     6    GCH64RFQNF4I55QBAK6KQJDL4IANE7KMU4SNLO4MOPUPYFKW2WTYJEY7
     7    3000
     8    13.50001
     9    kag
    10    TRUE
set_options
     1    2022-11-22T09:27:08Z
     2    3abf26b47a3b70e24f8dead4bd201953026a3a84bc0a179f82495cd83924efa0
     3    set_options
     4    
     5    GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
     6    
     7    
     8    0.00001
     9    kag
    10    TRUE
account_merge
     1    2022-12-30T12:04:58Z
     2    c6f77eb82a7382555193e34ccf9e0e47a4786f0984cc97fd315e7db70efff34a
     3    account_merge
     4    
     5    GDZDXT5JDONAZ7TQ7QA42HSO62GMYLKU74AVFVS4NN4SFYMPVVFCJGCU
     6    GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
     7    0.99999
     8    0.00001
     9    kag
    10    TRUE
inflation
     1    2022-12-01T00:00:20Z
     2    336660aebea0cea12eecc73c0dcf1f625a68cd58b8a3f5024ecc809c454c7bee
     3    inflation
     4    
     5    GDCQANEHPUIIT6CQGJO2NTKGCRFD5NETJNC33CJG3PWCSRVYNHISHLHK
     6    
     7    5034.626896
     8    0.00001
     9    kag
    10    TRUE
10 fields per record
all 5 record types
tidy
I likes it very much
 
After a little inspection, "EPD" appears in Field4
Sometimes as "EDP" too. Instead of "EPD".
Ah the joys of not validating human input...
Code: 
cat $KAG_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1
that was not my first attempt

sort -k1
lexicographic sort on first field
date
Good enough. It works

here's the full output of that one command (130+ lines)
Code: 
2019-04-01T12:42:17Z                 payment    test epd                   32.15
2019-04-01T12:45:47Z                 payment    test epd                   32.15
2019-04-04T07:25:53Z          create_account    EPD KAG 001             10600.00
2019-04-10T00:54:17Z          create_account    EPD KAG 002               200.00
2019-04-29T07:29:38Z          create_account    EDP KAG 003               225.06
2019-04-29T07:43:42Z                 payment    EPD KAG 004                64.30
2019-04-29T07:48:17Z                 payment    EPD KAG 005                32.15
2019-05-01T07:06:58Z                 payment    EPD KAG 006               100.00
2019-05-01T07:14:07Z                 payment    EPD KAG 007               100.00
2019-05-02T04:16:52Z          create_account    EPD KAG 008              1286.04
2019-05-07T05:32:13Z                 payment    EPD KAG 009               739.47
2019-05-13T07:32:54Z          create_account    EPD KAG 010                32.15
2019-05-14T04:52:23Z          create_account    EPD KAG 011               225.06
2019-05-14T04:56:43Z                 payment    EPD KAG 012                32.15
2019-05-14T05:00:48Z                 payment    EPD KAG 013              2000.00
2019-05-14T05:05:48Z                 payment    EPD KAG 014              1400.00
2019-05-20T05:56:34Z          create_account    EPD KAG 015              4790.50
2019-06-12T04:43:13Z                 payment    EPD KAG 016              2000.00
2019-06-17T05:38:39Z          create_account    EPD KAG 017               321.51
2019-06-19T03:57:49Z                 payment    EPD KAG 018               500.00
2019-06-24T03:28:50Z          create_account    EPD KAG 019               400.00
2019-06-28T06:39:50Z                 payment    EPD KAG 020              1000.00
2019-08-21T09:57:05Z                 payment    EPD KAG 021              5900.00
2019-09-03T08:00:45Z                 payment    EPD KAG 022             52984.85
2019-09-03T08:21:05Z                 payment    EPD KAG 023             69124.65
2019-09-09T04:58:51Z          create_account    EPD KAG 024              3600.00
2019-09-09T05:02:45Z                 payment    EPD KAG 025               100.00
2019-09-18T05:43:26Z                 payment    EPD KAG 026               257.21
2019-09-30T08:17:02Z          create_account    EPD KAG 027               200.00
2019-09-30T08:21:52Z          create_account    EPD KAG 028               400.00
2020-06-12T09:05:44Z                 payment    EPD KAG 029               200.00
2020-08-19T06:47:41Z                 payment    EPD KAG 030               600.00
2020-09-23T05:17:58Z          create_account    EPD KAG 031              1446.80
2020-09-23T06:59:38Z          create_account    EPD KAG 032               110.30
2020-10-15T06:45:43Z          create_account    EPD KAG 033               964.53
2020-11-13T06:19:19Z          create_account    EPD KAG 034               964.53
2020-12-21T06:10:44Z          create_account    EPD KAG 035               160.75
2021-01-19T04:45:14Z          create_account    EPD KAG 036               500.00
2021-01-27T05:17:14Z          create_account    KAG EPD 037              7716.24
2021-01-27T05:24:14Z          create_account    EPD KAG 038              3986.72
2021-01-27T05:34:19Z          create_account    EPD KAG 039               200.00
2021-01-27T05:37:39Z          create_account    EPD KAG 040                32.15
2021-01-28T04:36:35Z          create_account    EPD KAG 041              2000.00
2021-03-03T00:26:38Z                 payment    EPD KAG 043               482.26
2021-03-03T00:29:18Z                 payment    EPD KAG 042               482.26
2021-03-16T07:03:47Z          create_account    EPD KAG 044              3118.65
2021-03-17T06:10:47Z          create_account    EPD KAG 045              1704.00
2021-03-25T06:29:05Z          create_account    EPD KAG 046              2500.00
2021-04-01T06:02:37Z          create_account    EPD KAG 047              1700.00
2021-04-11T22:48:48Z          create_account    EPD KAG 048               160.75
2021-04-22T04:33:43Z          create_account    EPD KAG 049               200.00
2021-04-23T07:05:08Z          create_account    EPD KAG 050              1000.00
2021-05-05T06:42:04Z          create_account    EPD KAG 051              1100.00
2021-05-10T06:41:19Z          create_account    EPD KAG 052               482.26
2021-05-10T06:43:44Z          create_account    EPD KAG 053              6000.00
2021-05-14T07:18:19Z          create_account    EPD KAG 054               200.00
2021-05-21T06:46:54Z          create_account    EPD KAG 055              3934.40
2021-05-21T06:48:52Z          create_account    EPD KAG 056               385.81
2021-05-21T07:23:03Z          create_account    EPD KAG 057              3858.12
2021-06-09T23:25:32Z          create_account    EPD KAG 058             18740.10
2021-06-09T23:31:02Z          create_account    EPD KAG 059               999.90
2021-06-17T07:29:17Z          create_account    EPD KAG 060              1300.00
2021-06-22T05:38:57Z          create_account    EPD KAG 061               985.80
2021-07-16T06:07:45Z          create_account    EPD KAG 062              1350.34
2021-07-16T06:10:57Z          create_account    EPD KAG 063              1013.70
2021-07-23T03:02:20Z          create_account    EPD KAG 064               739.47
2021-07-23T03:09:25Z          create_account    EPD KAG 065               100.00
2021-07-23T03:15:09Z          create_account    EPD KAG 066               500.00
2021-08-19T06:30:05Z          create_account    EPD KAG 067               300.00
2021-08-31T05:54:50Z          create_account    KAG EPD 068              8086.62
2021-09-09T05:41:35Z          create_account    EPD KAG 069               300.00
2021-09-09T05:46:54Z          create_account    EPD KAG 070               225.06
2021-10-08T07:13:50Z          create_account    EPD KAG 071              1000.00
2021-10-08T07:20:19Z          create_account    EPD KAG 072               259.53
2021-10-15T06:06:48Z          create_account    EPD KAG 073               417.96
2021-10-19T23:27:38Z          create_account    EPD KAG 074               200.00
2021-10-19T23:31:08Z          create_account    EPD KAG 075              1000.00
2021-10-21T05:51:08Z          create_account    EPD KAG 076               417.96
2021-11-10T06:02:48Z          create_account    EPD KAG 077               100.00
2021-11-24T23:54:58Z          create_account    EPD KAG 078              3235.57
2021-11-30T09:33:34Z          create_account    EPD KAG 079               400.00
2021-11-30T09:35:33Z          create_account    EPD KAG 080               128.60
2021-11-30T09:39:23Z          create_account    EPD KAG 081               100.00
2021-11-30T09:41:58Z          create_account    EPD KAG 082              4013.60
2021-11-30T09:46:09Z          create_account    EPD KAG 083             11191.30
2021-11-30T09:49:33Z          create_account    EPD KAG 084               100.00
2021-11-30T09:51:13Z          create_account    EPD KAG 085               192.91
2021-11-30T09:53:44Z          create_account    EPD KAG 086               100.00
2021-12-01T01:46:53Z          create_account    EPD KAG 087              2000.00
2021-12-10T02:33:59Z          create_account    EPD KAG 088               321.51
2021-12-14T03:26:09Z          create_account    EPD KAG 089               803.77
2021-12-14T03:29:39Z          create_account    EPD KAG 090               643.02
2021-12-20T07:42:09Z          create_account    EPD KAG 091              9548.85
2021-12-29T23:31:49Z          create_account    EPD KAG 092               643.02
2022-01-20T05:20:11Z          create_account    EPD KAG 093               959.06
2022-01-28T02:42:20Z          create_account    EPD KAG 094              2800.00
2022-01-28T02:46:31Z          create_account    EPD KAG 095              1700.00
2022-01-28T02:53:56Z          create_account    EPD KAG 096               900.23
2022-01-28T02:56:06Z          create_account    EPD KAG 097              1400.00
2022-03-11T03:46:06Z          create_account    EPD KAG 098               643.02
2022-03-16T06:21:16Z          create_account    EPD KAG 099              3280.00
2022-03-16T06:27:41Z          create_account    EPD KAG 100              2314.87
2022-03-18T06:02:00Z          create_account    EPD KAG 101               200.00
2022-03-25T02:16:16Z                 payment    EPD KAG 102              3761.67
2022-03-30T03:49:17Z          create_account    EPD KAG 103               160.75
2022-05-06T02:22:41Z          create_account    EPD KAG 104             12117.13
2022-05-06T02:28:07Z          create_account    EPD KAG 105              2000.00
2022-05-17T07:55:02Z          create_account    EPD KAG 106              2732.84
2022-05-17T07:58:18Z          create_account    EPD KAG 107               500.00
2022-05-19T03:18:36Z          create_account    EPD KAG 108               977.32
2022-06-06T02:19:26Z          create_account    EPD KAG 109             12078.74
2022-06-17T01:14:37Z          create_account    EPD KAG 110             10318.96
2022-08-08T03:48:09Z          create_account    EPD KAG 111              6023.54
2022-08-15T05:05:48Z          create_account    EPD KAG 112              1286.04
2022-08-23T04:27:53Z          create_account    EPD KAG 113              1273.17
2022-08-23T04:31:35Z          create_account    EPD KAG 114              1527.80
2022-09-01T06:40:09Z          create_account    EPD KAG 115              3468.40
2022-09-01T06:42:59Z          create_account    EPD KAG 116               160.75
2022-09-13T05:55:08Z          create_account    EPD KAG 117              2387.19
2022-09-13T05:57:43Z          create_account    EPD KAG 118              2387.19
2022-09-13T06:19:15Z          create_account    EPD 1% fee                 24.11
2022-09-13T06:24:14Z          create_account    EPD 1% fee                 24.11
2022-09-23T03:55:25Z          create_account    EPD KAG 119               900.00
2022-10-21T05:50:13Z          create_account    EPD KAG 120              1591.46
2022-10-21T05:53:12Z          create_account    EPD KAG 121              1591.46
2022-10-21T05:55:46Z          create_account    EPD 1% fee                 16.07
2022-10-21T05:57:56Z          create_account    EPD 1% fee                 16.07
2022-11-17T02:49:37Z          create_account    EPD KAG 122              2300.00
2022-11-24T04:53:08Z          create_account    EPD KAG 123              1047.80
2022-12-01T03:50:03Z          create_account    EPD KAG 124              1607.55
2022-12-01T03:53:17Z          create_account    EPD KAG 125              1864.76
2022-12-05T04:31:58Z          create_account    EPD KAG 126              3501.21
2022-12-05T04:35:08Z          create_account    EPD KAG 127              3501.21
2022-12-05T04:38:05Z          create_account    Segregated EPD 1% fee       35.37
2022-12-05T04:40:19Z          create_account    Segregated EPD 1% fee       35.37
2022-12-13T04:20:10Z          create_account    EPD KAG 128               500.00
2022-12-19T03:50:46Z          create_account    EPD KAG 129              4211.78
2022-12-19T03:54:39Z          create_account    EPD KAG 130              1060.98
2022-12-19T03:57:57Z          create_account    EPD KAG 131               100.00
2022-12-28T02:54:51Z          create_account    EPD KAG 132               610.87
2022-12-28T02:56:55Z          create_account    EPD KAG 133              1607.55
2022-12-28T04:28:02Z          create_account    EPD KAG 134               954.88
2022-12-28T04:29:57Z          create_account    EPD KAG 135               477.44
2022-12-28T04:32:06Z          create_account    Segregated EPD 1% fee        9.65
2022-12-28T04:33:53Z          create_account    Segregated EPD 1% fee        4.82
 
Segregate the segregated.
I don't know why. It just sounds good.
Code: 
EPD KAG 117  
EPD KAG 118  
EPD KAG 120  
EPD KAG 121  
EPD KAG 126  
EPD KAG 127  
EPD KAG 134  
EPD KAG 135
Actual work not shown (manual, 2 minutes' work)

All likely EPDs to segregated storage.
As opposed to pooled.
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 

linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | wc -l
137
137 records
 
Taking date of first transaction
and date of last transaction
Code: 
echo $((($(date '+%s' -d "2022-12-28T04:33:53Z") - $(date '+%s' -d "2019-04-01T12:42:17Z")) / (24 * 60 * 60)))
linux> echo $((($(date '+%s' -d "2022-12-28T04:33:53Z") - $(date '+%s' -d "2019-04-01T12:42:17Z")) / (24 * 60 * 60)))
1366
linux> bc <<< "scale=2; 1366 / 365"
3.74
a period of nearly 4 years
Code: 
linux> bc <<< "scale=2; 1366 / 137 "
9.97
1 pooled EPD event about every 10 days
 
Totals ?
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {sum_7 += $7} END {printf "%.2f\n", sum_7}' 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {sum_7 += $7} END {printf "%.2f\n", sum_7}' 
381116.17
GNU units:
Code: 
units -t "381116.17 ozt" t
linux> units -t "381116.17 ozt" t
11.854038
Nearly 12 tonnes.

Current KAG value from Explorer screen. Top right.
Yes the data extract is from January 2023.
This is just to get a rough idea of relative magnitudes.
Code: 
3,083,690.3814 KAG
3083690.3814
units -t "3083690.3814 ozt" t
linux> units -t "3083690.3814 ozt" t
95.913492
Nearly 96 tonnes equivalent if 1:1 physical to digital coin (1 ozt Ag : 1 KAG).

Code: 
bc <<< "scale=6; 11.850425 / 95.813961"
linux> bc <<< "scale=6; 11.850425 / 95.813961"
.123681

bc <<< "scale=6; (11.850425 / 95.813961)^(-1)"
linux> bc <<< "scale=6; (11.850425 / 95.813961)^(-1)"
8.085316
About 1 in 8 tonnes is EPD
deduce:
7 in 8 is from Minting/ Mint Cycling
presumably
 
About 200 Kozt of the above came in over 8 transactions over 5 different accounts.
See below:
Focus on EPDs over 10000 ozt ? 10 Kozt...
Code: 
linux> units -t "10 thousand ozt (1/ozt) XAG" USD
218100
218 K USD for 10 average 1 Kozt bars at current spot
200+ Grand USD for 10 Kozt
Worth a look

($7 > 10000)
does the job
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 

linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 | cut -f2

1fbe1265a1e8836bf29062f3e8de268f3a126b70e5c6fab3bfe4d147426d3cd1
2df2ad4d6c10fddcff3d806c124d3767883e6bb177d407e75cf59cca0cf1f46d
728f54c145673d745d7355b96ff41c15706f2aa69feb9efccbd11483915f7e45
d6f54381a77747bea673f547d838f7d7d309eecc857683b2b76db26c605e43b3
352e2a5517d9ac01ee6d5cb7906cdbccbf9414303a2dbeb9e2e3901165c1ae10
153eef692539b14c4687fdad03dbf19184ecbb1650c053523387d7bdd7111dfa
fde6eb23d06c30ff4d5ce5670fc43cd028a37c24a750144c88e6c7fa27cdd152
20bcb414bccb8285930a4414b0f663e1183cb91ebfa084cd9fc3846406588708
Let's write those to a file
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 | cut -f2 > list
and open them up in a browser:
Code: 
while IFS= read x
do
  xdg-open https://explorer.kinesis.money/transaction/KAG/$x
  sleep $[($RANDOM % 9) + 10]s
done < list
Even better, hit the flat file directly:
Code: 
while IFS= read x
do
  grep $x $KAG_CI_extract
  sleep 5
done < list

2019-04-04T07:25:53Z,1fbe1265a1e8836bf29062f3e8de268f3a126b70e5c6fab3bfe4d147426d3cd1,create_account,EPD KAG 001,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDAC6TUP3J5GRMP4HJNTTA7AWH7IQYBFSOJMPOWJPGSEQQBLHS2NQ65G,10600,47.70001,kag,TRUE
2019-09-03T08:00:45Z,2df2ad4d6c10fddcff3d806c124d3767883e6bb177d407e75cf59cca0cf1f46d,payment,EPD KAG 022,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDPWZC6EDJ4QN4VQBVRPJFE6DCG5HXH2M7APH5YRH24HKS6O5F72RUH4,52984.848,238.4318261,kag,TRUE
2019-09-03T08:21:05Z,728f54c145673d745d7355b96ff41c15706f2aa69feb9efccbd11483915f7e45,payment,EPD KAG 023,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDPWZC6EDJ4QN4VQBVRPJFE6DCG5HXH2M7APH5YRH24HKS6O5F72RUH4,69124.65,311.060935,kag,TRUE
2021-06-09T23:25:32Z,d6f54381a77747bea673f547d838f7d7d309eecc857683b2b76db26c605e43b3,create_account,EPD KAG 058,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDFXRGMVLOFKZPWCRLI6NDQANGHS6B2AWZRPMOS7ZI57ARZTTN2OISKG,18740.1,84.33046,kag,TRUE
2021-11-30T09:46:09Z,352e2a5517d9ac01ee6d5cb7906cdbccbf9414303a2dbeb9e2e3901165c1ae10,create_account,EPD KAG 083,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GA2FXKZBH4VIJ5IYIT6HRZ36HOM467WTX7LYJKA5AOV6WJVVJ627UI6M,11191.3,50.36086,kag,TRUE
2022-05-06T02:22:41Z,153eef692539b14c4687fdad03dbf19184ecbb1650c053523387d7bdd7111dfa,create_account,EPD KAG 104,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDHBFLPTILILYDGQEY7PYM4KBAWXFGLP2FTAS4AW7TCWRKZ3XAJAZQHB,12117.132,54.527104,kag,TRUE
2022-06-06T02:19:26Z,fde6eb23d06c30ff4d5ce5670fc43cd028a37c24a750144c88e6c7fa27cdd152,create_account,EPD KAG 109,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDHBFLPTILILYDGQEY7PYM4KBAWXFGLP2FTAS4AW7TCWRKZ3XAJAZQHB,12078.743,54.3543535,kag,TRUE
2022-06-17T01:14:37Z,20bcb414bccb8285930a4414b0f663e1183cb91ebfa084cd9fc3846406588708,create_account,EPD KAG 110,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDHBFLPTILILYDGQEY7PYM4KBAWXFGLP2FTAS4AW7TCWRKZ3XAJAZQHB,10318.956,46.435312,kag,TRUE
Code: 
linux> . ./KAG-set-main-account-symbols.sh 

linux> set | grep KAG_[E,G,H,I,R] 
KAG_EmissionAccount=GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU
KAG_GAPSAccount=GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
KAG_HotWalletAccount=GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
KAG_InflationAccount=GBBVUAMR3CYNQKMNHVWCMUQVE3XQIL3WM5GSP5D6SCECKIZNNBT6FT7I
KAG_RootAccount=GAUCIFE37F4KQ5F6QPNSZ75QKRQTNRCF32FZNUXMCXUFSKRMWGF76LTI
(From To) in Fields 5 and 6
From is Emission E e
To is whom?
Write those to temp file t2
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%-20s\t%-20s\t%8.2f\n", $4, $6, $7}' | sort -k2 | cut -f2 | sort -u > t2
Find common with System Accounts after writing those yet again to file t1
Code: 
set | grep ^KAG | sort -t= -k2 | cut -d= -f2 | grep ^G | sort > t1
Code: 
linux> comm t1 t2
    GA2FXKZBH4VIJ5IYIT6HRZ36HOM467WTX7LYJKA5AOV6WJVVJ627UI6M
GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
GAUCIFE37F4KQ5F6QPNSZ75QKRQTNRCF32FZNUXMCXUFSKRMWGF76LTI
GBBVUAMR3CYNQKMNHVWCMUQVE3XQIL3WM5GSP5D6SCECKIZNNBT6FT7I
GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU
    GDAC6TUP3J5GRMP4HJNTTA7AWH7IQYBFSOJMPOWJPGSEQQBLHS2NQ65G
    GDFXRGMVLOFKZPWCRLI6NDQANGHS6B2AWZRPMOS7ZI57ARZTTN2OISKG
    GDHBFLPTILILYDGQEY7PYM4KBAWXFGLP2FTAS4AW7TCWRKZ3XAJAZQHB
    GDPWZC6EDJ4QN4VQBVRPJFE6DCG5HXH2M7APH5YRH24HKS6O5F72RUH4
Oh joy. No intersection of the 2 sets (the 2 files)

I am of course hoping I have isolated the 5 system accounts correctly.

I am not at all certain of that fact.
 
Code: 
linux> wc -l t2
5 t2
Check those 5 accounts in the browser?
Code: 
while IFS= read x
do
  xdg-open https://explorer.kinesis.money/account/$x
  sleep $[($RANDOM % 9) + 10]s
done < t2
or directly here:
Code: 
https://explorer.kinesis.money/account/GA2FXKZBH4VIJ5IYIT6HRZ36HOM467WTX7LYJKA5AOV6WJVVJ627UI6M
https://explorer.kinesis.money/account/GDAC6TUP3J5GRMP4HJNTTA7AWH7IQYBFSOJMPOWJPGSEQQBLHS2NQ65G
https://explorer.kinesis.money/account/GDFXRGMVLOFKZPWCRLI6NDQANGHS6B2AWZRPMOS7ZI57ARZTTN2OISKG
https://explorer.kinesis.money/account/GDHBFLPTILILYDGQEY7PYM4KBAWXFGLP2FTAS4AW7TCWRKZ3XAJAZQHB
https://explorer.kinesis.money/account/GDPWZC6EDJ4QN4VQBVRPJFE6DCG5HXH2M7APH5YRH24HKS6O5F72RUH4
 
Focus on the numbers and dates
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 
2019-04-04T07:25:53Z          create_account    EPD KAG 001             10600.00
2019-09-03T08:00:45Z                 payment    EPD KAG 022             52984.85
2019-09-03T08:21:05Z                 payment    EPD KAG 023             69124.65
2021-06-09T23:25:32Z          create_account    EPD KAG 058             18740.10
2021-11-30T09:46:09Z          create_account    EPD KAG 083             11191.30
2022-05-06T02:22:41Z          create_account    EPD KAG 104             12117.13
2022-06-06T02:19:26Z          create_account    EPD KAG 109             12078.74
2022-06-17T01:14:37Z          create_account    EPD KAG 110             10318.96

linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4
10600.00
52984.85
69124.65
18740.10
11191.30
12117.13
12078.74
10318.96

linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | paste -s -d+ | bc -l
197155.73
nearly 200 Kozt
 
Let's try guessing what those EPDs looked like physically:

Using Good Delivery Bar specs:
Code: 
AG_GDB_lower_bound=900
AG_GDB_upper_bound=1050

linux> set | grep ^AG_
AG_GDB_lower_bound=900
AG_GDB_upper_bound=1050
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 > list

linux> for i in `cat list`; do  printf "%10.2f\t" $i; units -o "%10.2f" -t "$i / $AG_GDB_upper_bound"; done
  10600.00         10.10
  52984.85         50.46
  69124.65         65.83
  18740.10         17.85
  11191.30         10.66
  12117.13         11.54
  12078.74         11.50
  10318.96          9.83
linux> for i in `cat list`; do  printf "%10.2f\t" $i; units -o "%10.2f" -t "$i / $AG_GDB_lower_bound"; done
  10600.00         11.78
  52984.85         58.87
  69124.65         76.81
  18740.10         20.82
  11191.30         12.43
  12117.13         13.46
  12078.74         13.42
  10318.96         11.47
linux> for i in `cat list`; do  printf "%10.2f\t" $i; units -o "%10.2f" -t "$i / (( $AG_GDB_upper_bound + $AG_GDB_lower_bound ) / 2)"; done
  10600.00         10.87
  52984.85         54.34
  69124.65         70.90
  18740.10         19.22
  11191.30         11.48
  12117.13         12.43
  12078.74         12.39
  10318.96         10.58
That last command takes the average of the GDB upper and lower bound. Not 1000. Heh. 975.

So my best guess is those particular EPDs were multiples of 1000 Kozt commercial bars going into the Kinesis system

10
54
70
19
11
12
12
10

at a time.
 
The 8 EPDs over 10 Kozt above were probably special cases of some sort.

Let's now exclude them for clarity.
To focus on the rest.
 
($7 <= 10000)
does the trick
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | wc -l
129
129 of 'em. Yup.
Now here's an idea:
Select the round numbers to identify EPDs made up of 1000 Kozt and 100 ozt.
Or 500 ozt Monster Boxes of 1 ozt coins.
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep "\.00"
grep "\.00"
grep ".00"
would give a different result.
dot would be interpreted as a regexp
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep "\.00" | wc -l
52
52 of those records
And without the line count (wc -l)
Code: 
  200.00
  100.00
  100.00
 2000.00
 1400.00
 2000.00
  500.00
  400.00
 1000.00
 5900.00
 3600.00
  100.00
  200.00
  400.00
  200.00
  600.00
  500.00
  200.00
 2000.00
 1704.00
 2500.00
 1700.00
  200.00
 1000.00
 1100.00
 6000.00
  200.00
 1300.00
  100.00
  500.00
  300.00
  300.00
 1000.00
  200.00
 1000.00
  100.00
  400.00
  100.00
  100.00
  100.00
 2000.00
 2800.00
 1700.00
 1400.00
 3280.00
  200.00
 2000.00
  500.00
  900.00
 2300.00
  500.00
  100.00
Oh a 1704 slipped in.
1704
possibly
(1 Kozt bar) + (7 * 100 ozt) + (4 * 1 ozt coins)
or
Code: 
linux> units -t " 1704.00 ozt" kg
53.000324
53 kg
Either/ or.
We don't need to know.
At least we tried to make sense of the numbers.

3280?
Code: 
linux> units -t "3280 ozt" "1000 ozt; 100 ozt; 10 ozt"
3;2;8
Neat trick. I found that while looking at dms (deg;arcmin;arcsec) in the manual here:

Screenshot from 2023-04-04 00-06-27.png
Quick aside:
Here's how units sees an ozt
Code: 
linux> units -t ozt
troyounce = 1|12 troypound = 0.031103477 kg
 
Now pick out the non-round numbers.

In English: "Did any of these (129 - 52) EPDs come in as kg instead of ozt?"
Quite likely.

grep -v
excludes
Code: 
linux> cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep -v "\.00" | wc -l
77
Write those records to a flat file
Code: 
cat $KAG_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 10000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep -v "\.00" > Not-Round
Examine more closely:
convert all Not-Round to kg
Code: 
linux> for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done 
32.15     1.00
32.15     1.00
225.06    7.00
64.30     2.00
32.15     1.00
1286.04   40.00
739.47    23.00
32.15     1.00
225.06    7.00
32.15     1.00
4790.50   149.00
321.51    10.00
257.21    8.00
1446.80   45.00
110.30    3.43
964.53    30.00
964.53    30.00
160.75    5.00
7716.24   240.00
3986.72   124.00
32.15     1.00
482.26    15.00
482.26    15.00
3118.65   97.00
160.75    5.00
482.26    15.00
3934.40   122.37
385.81    12.00
3858.12   120.00
999.90    31.10
985.80    30.66
1350.34   42.00
1013.70   31.53
739.47    23.00
8086.62   251.52
225.06    7.00
259.53    8.07
417.96    13.00
417.96    13.00
3235.57   100.64
128.60    4.00
4013.60   124.84
192.91    6.00
321.51    10.00
803.77    25.00
643.02    20.00
9548.85   297.00
643.02    20.00
959.06    29.83
900.23    28.00
643.02    20.00
2314.87   72.00
3761.67   117.00
160.75    5.00
2732.84   85.00
977.32    30.40
6023.54   187.35
1286.04   40.00
1273.17   39.60
1527.80   47.52
3468.40   107.88
160.75    5.00
2387.19   74.25
2387.19   74.25
1591.46   49.50
1591.46   49.50
1047.80   32.59
1607.55   50.00
1864.76   58.00
3501.21   108.90
3501.21   108.90
4211.78   131.00
1060.98   33.00
610.87    19.00
1607.55   50.00
954.88    29.70
477.44    14.85
Round numbers in column 2 of this output are strong candidates for kg EPD deliveries
Write out the round numbers like so:
Code: 
linux> for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done | grep "\.00"
32.15     1.00
32.15     1.00
225.06    7.00
64.30     2.00
32.15     1.00
1286.04   40.00
739.47    23.00
32.15     1.00
225.06    7.00
32.15     1.00
4790.50   149.00
321.51    10.00
257.21    8.00
1446.80   45.00
964.53    30.00
964.53    30.00
160.75    5.00
7716.24   240.00
3986.72   124.00
32.15     1.00
482.26    15.00
482.26    15.00
3118.65   97.00
160.75    5.00
482.26    15.00
385.81    12.00
3858.12   120.00
1350.34   42.00
739.47    23.00
225.06    7.00
417.96    13.00
417.96    13.00
128.60    4.00
192.91    6.00
321.51    10.00
803.77    25.00
643.02    20.00
9548.85   297.00
643.02    20.00
900.23    28.00
643.02    20.00
2314.87   72.00
3761.67   117.00
160.75    5.00
2732.84   85.00
1286.04   40.00
160.75    5.00
1607.55   50.00
1864.76   58.00
4211.78   131.00
1060.98   33.00
610.87    19.00
1607.55   50.00

linux> for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done | grep "\.00" | wc -l
53
53 EPDs probably came in as kilos (kg)
 
How about the rest?
Code: 
linux> for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done | grep -v "\.00" | wc -l
24

24 records


linux>  for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done | grep -v "\.00" 
110.30    3.43
3934.40   122.37
999.90    31.10
985.80    30.66
1013.70   31.53
8086.62   251.52
259.53    8.07
3235.57   100.64
4013.60   124.84
959.06    29.83
977.32    30.40
6023.54   187.35
1273.17   39.60
1527.80   47.52
3468.40   107.88
2387.19   74.25
2387.19   74.25
1591.46   49.50
1591.46   49.50
1047.80   32.59
3501.21   108.90
3501.21   108.90
954.88    29.70
477.44    14.85
Write those out to another flat file
Not-Round-kg
Code: 
for i in `cat Not-Round`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i ozt" "kg"; done | grep -v "\.00" > Not-Round-kg
Separate out that second column, the kg column
Code: 
linux> cat Not-Round-kg | cut -c11- > Column2-kg
linux> nl Column2-kg 
     1    3.43
     2    122.37
     3    31.10
     4    30.66
     5    31.53
     6    251.52
     7    8.07
     8    100.64
     9    124.84
    10    29.83
    11    30.40
    12    187.35
    13    39.60
    14    47.52
    15    107.88
    16    74.25
    17    74.25
    18    49.50
    19    49.50
    20    32.59
    21    108.90
    22    108.90
    23    29.70
    24    14.85
nl
number the line
number the record
 
A hunch, partly prompted by Richard Melbourne speaking in the VaultSide chat, Episode 1 from a couple of days ago.

fineness

Grab the standard EPD fineness numbers according to Kinesis from here

Code it up:

Multiply by the reciprocal of the fineness to guess the gross weight
Code: 
for i in `cat Column2-kg`
do
  printf "%-10.2f\n" $i
  for j in 800 900 916 925 947 950 958 999
  do
    units -o "%-.6f" -t "$i * ( 1000 / $j )"
  done
done > All-Together
Code: 
linux> echo ' 800 900 916 925 947 950 958 999' | sed 's/ /\n/g' | sed '1d' | wc -l
8
8 + 1 = 9 records
1 per line

Join them together 9 at a time into 1 line:
H/T: baeldung or was it jim mcnamara
Code: 
cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}'
Sniff out round numbers again using exactly the same trick for the 3rd time now (?)
Code: 
linux> cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}' | nl -ba | grep "\.00000"
    11    30.40         38.000000    33.777778    33.187773    32.864865    32.101373    32.000000    31.732777    30.430430
    13    39.60         49.500000    44.000000    43.231441    42.810811    41.816262    41.684211    41.336117    39.639640
    18    49.50         61.875000    55.000000    54.039301    53.513514    52.270327    52.105263    51.670146    49.549550
    19    49.50         61.875000    55.000000    54.039301    53.513514    52.270327    52.105263    51.670146    49.549550
    21    108.90        136.125000    121.000000    118.886463    117.729730    114.994720    114.631579    113.674322    109.009009
    22    108.90        136.125000    121.000000    118.886463    117.729730    114.994720    114.631579    113.674322    109.009009
    23    29.70         37.125000    33.000000    32.423581    32.108108    31.362196    31.263158    31.002088    29.729730
Clearer in colour:
Screenshot from 2023-04-04 00-34-01.png
in red, we may have matches for
800
900
or
950
Fineness each time

Let's move back a step.
Back to the original ozt numbers
Next post:
 
You must log in or register to reply here.

Translate

Back
Top