{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Installing Libre Barcode 39","Code 39 with VBA ","IMAGE+API","Check Digit MOD 43"],"not_rendered":{"images":10},"read":"whole","date_system":"1900"}

{"sheet":"Installing Libre Barcode 39","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
["Product Name","SKU","Quantity","Unit Price ($)","Barcodes"]
["Laptop","LAP1001",15,{"v":750,"d":"$750.00"},{"$f":"\"*\"&B2&\"*\"","v":"*LAP1001*"}]
["Smartphone","MOB2002",40,{"v":550,"d":"$550.00"},{"$f":"\"*\"&B3&\"*\"","v":"*MOB2002*"}]
["Wireless Mouse","ACC3003",120,{"v":25,"d":"$25.00"},"*ACC3003*"]
["Keyboard","ACC4004",85,{"v":35,"d":"$35.00"},"*ACC4004*"]
["Printer","PRN5005",30,{"v":210,"d":"$210.00"},"*PRN5005*"]
["Monitor","MON6006",22,{"v":180,"d":"$180.00"},"*MON6006*"]
["Router","NET7007",60,{"v":65,"d":"$65.00"},"*NET7007*"]
["External Hard Drive","STR8008",18,{"v":120,"d":"$120.00"},"*STR8008*"]
["Smartwatch","WCH9009",25,{"v":200,"d":"$200.00"},"*WCH9009*"]
["Bluetooth Speaker","SPK1010",50,{"v":75,"d":"$75.00"},"*SPK1010*"]

{"sheet":"Code 39 with VBA ","index":1,"n_rows":11,"n_cols":5,"rows_kept":11}
["Product Name","SKU","Quantity","Unit Price ($)","Barcodes"]
["Laptop","LAP1001",15,{"v":750,"d":"$750.00"},{"$f":"EncodeCode39(B2)","v":"*LAP1001*"}]
["Smartphone","MOB2002",40,{"v":550,"d":"$550.00"},{"$f":"EncodeCode39(B3)","v":"*MOB2002*"}]
["Wireless Mouse","ACC3003",120,{"v":25,"d":"$25.00"},{"$f":"EncodeCode39(B4)","v":"*ACC3003*"}]
["Keyboard","ACC4004",85,{"v":35,"d":"$35.00"},{"$f":"EncodeCode39(B5)","v":"*ACC4004*"}]
["Printer","PRN5005",30,{"v":210,"d":"$210.00"},{"$f":"EncodeCode39(B6)","v":"*PRN5005*"}]
["Monitor","MON6006",22,{"v":180,"d":"$180.00"},{"$f":"EncodeCode39(B7)","v":"*MON6006*"}]
["Router","NET7007",60,{"v":65,"d":"$65.00"},{"$f":"EncodeCode39(B8)","v":"*NET7007*"}]
["External Hard Drive","STR8008",18,{"v":120,"d":"$120.00"},{"$f":"EncodeCode39(B9)","v":"*STR8008*"}]
["Smartwatch","WCH9009",25,{"v":200,"d":"$200.00"},{"$f":"EncodeCode39(B10)","v":"*WCH9009*"}]
["Bluetooth Speaker","SPK1010",50,{"v":75,"d":"$75.00"},{"$f":"EncodeCode39(B11)","v":"*SPK1010*"}]

{"sheet":"IMAGE+API","index":2,"n_rows":11,"n_cols":5,"rows_kept":11}
["Product Name","SKU","Quantity","Unit Price ($)","Barcodes"]
["Laptop","LAP1001",15,{"v":750,"d":"$750.00"},{"$f":"_xlfn.IMAGE(\"https://barcodeapi.org/api/39/\" & B2)","v":{"$error":"#VALUE!"}}]
["Smartphone","MOB2002",40,{"v":550,"d":"$550.00"},{"$f":"_xlfn.IMAGE(\"https://barcodeapi.org/api/39/\" & B3)","v":{"$error":"#VALUE!"}}]
["Wireless Mouse","ACC3003",120,{"v":25,"d":"$25.00"},{"$error":"#VALUE!"}]
["Keyboard","ACC4004",85,{"v":35,"d":"$35.00"},{"$error":"#VALUE!"}]
["Printer","PRN5005",30,{"v":210,"d":"$210.00"},{"$error":"#VALUE!"}]
["Monitor","MON6006",22,{"v":180,"d":"$180.00"},{"$error":"#VALUE!"}]
["Router","NET7007",60,{"v":65,"d":"$65.00"},{"$error":"#VALUE!"}]
["External Hard Drive","STR8008",18,{"v":120,"d":"$120.00"},{"$error":"#VALUE!"}]
["Smartwatch","WCH9009",25,{"v":200,"d":"$200.00"},{"$error":"#VALUE!"}]
["Bluetooth Speaker","SPK1010",50,{"v":75,"d":"$75.00"},{"$error":"#VALUE!"}]

{"sheet":"Check Digit MOD 43","index":3,"n_rows":11,"n_cols":5,"rows_kept":11}
["Product Name","SKU","Quantity","Unit Price ($)","Barcodes"]
["Laptop","LAP1001",15,{"v":750,"d":"$750.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B2)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*LAP1001F*"}]
["Smartphone","MOB2002",40,{"v":550,"d":"$550.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B3)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*MOB2002I*"}]
["Wireless Mouse","ACC3003",120,{"v":25,"d":"$25.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B4)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*ACC3003/*"}]
["Keyboard","ACC4004",85,{"v":35,"d":"$35.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B5)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*ACC4004%*"}]
["Printer","PRN5005",30,{"v":210,"d":"$210.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B6)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*PRN5005%*"}]
["Monitor","MON6006",22,{"v":180,"d":"$180.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B7)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*MON6006 *"}]
["Router","NET7007",60,{"v":65,"d":"$65.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B8)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*NET7007.*"}]
["External Hard Drive","STR8008",18,{"v":120,"d":"$120.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B9)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*STR8008E*"}]
["Smartwatch","WCH9009",25,{"v":200,"d":"$200.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B10)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*WCH9009-*"}]
["Bluetooth Speaker","SPK1010",50,{"v":75,"d":"$75.00"},{"$f":"_xlfn.LET(\n  _xlpm.s, UPPER(TRIM(B11)),\n  _xlpm.chars, \"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%\",\n  _xlpm.n, LEN(_xlpm.s),\n  _xlpm.charsArr, MID(_xlpm.s, _xlfn.SEQUENCE(_xlpm.n), 1),\n  _xlpm.vals, IFERROR(FIND(_xlpm.charsArr, _xlpm.chars) - 1, NA()),\n  IF(ISNA(SUM(_xlpm.vals)),\n     \"Invalid character in input\",\n     _xlfn.LET(_xlpm.rem, MOD(SUM(_xlpm.vals), 43),\n         _xlpm.check, MID(_xlpm.chars, _xlpm.rem + 1, 1),\n         \"*\" & _xlpm.s & _xlpm.check & \"*\"\n     )\n  )\n)","v":"*SPK1010W*"}]