{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Signed URL","GET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Signed URL","index":0,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Filename","020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf"]
[]
["Current date and time",{"$f":"UtcDate(B2)","v":"20220525T155346Z"}]
["Current date",{"$f":"LEFT(B4,8)","v":"20220525"}]
[null,"AWS4"]
[null,"HMAC-SHA256"]
[null,{"$f":"_xlfn.CONCAT(B6, \"-\", B7)","v":"AWS4-HMAC-SHA256"}]
["Region","us-west-2"]
[null,"s3"]
[null,"aws4_request"]
["Access Key","AKIA5TRHZWO3QGECXEHC"]
["Secret Key","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"]
["Bucket name","brians3test"]
[]
["host",{"$f":"_xlfn.CONCAT(B14,\".\",B10,\".\",B9,\".amazonaws.com\")","v":"brians3test.s3.us-west-2.amazonaws.com"}]
[]
[]
[null,"GET"]
[null,{"$f":"_xlfn.CONCAT(\"/\",B2)","v":"/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf"}]
[null,{"$f":"_xlfn.CONCAT(\"X-Amz-Algorithm=\",B8,\"&X-Amz-Credential=\",B12,\"%2F\",B5,\"%2F\",B9,\"%2F\",B10,\"%2F\",B11,\"&X-Amz-Date=\",B4,\"&X-Amz-Expires=86400&X-Amz-SignedHeaders=host\")","v":"X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA5TRHZWO3QGECXEHC%2F20220525%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20220525T155346Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host"}]
[null,{"$f":"_xlfn.CONCAT(\"host:\",B16)","v":"host:brians3test.s3.us-west-2.amazonaws.com"}]
[null,"host"]
[null,"UNSIGNED-PAYLOAD"]
[]
[null,{"$f":"_xlfn.CONCAT(B19,CHAR(10),B20,CHAR(10),B21,CHAR(10),B22,CHAR(10),CHAR(10),B23,CHAR(10),B24)","v":"GET\n/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf\nX-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA5TRHZWO3QGECXEHC%2F20220525%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20220525T155346Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host\nhost:brians3test.s3.us-west-2.amazonaws.com\n\nhost\nUNSIGNED-PAYLOAD"}]
[]
["SHA256",{"$f":"Base64_SHA256(B26)","v":"559c313aaa3c958ab8487d6bac20da1055557184d580553a17c81c4b7e9a3748"}]
[]
[]
[null,"AWS4-HMAC-SHA256"]
[null,{"$f":"B4","v":"20220525T155346Z"}]
[null,{"$f":"_xlfn.CONCAT(B5,\"/\",B9,\"/s3/aws4_request\")","v":"20220525/us-west-2/s3/aws4_request"}]
[null,{"$f":"B28","v":"559c313aaa3c958ab8487d6bac20da1055557184d580553a17c81c4b7e9a3748"}]
[]
[null,{"$f":"_xlfn.CONCAT(B31,CHAR(10), B32, CHAR(10), B33, CHAR(10),B34)","v":"AWS4-HMAC-SHA256\n20220525T155346Z\n20220525/us-west-2/s3/aws4_request\n559c313aaa3c958ab8487d6bac20da1055557184d580553a17c81c4b7e9a3748"}]
[]
[null,{"$f":"_xlfn.CONCAT(B6,B13)","v":"AWS4jvIMMNOMEI7MoskR2rblLUZlInHE4FAYSZiyeiKK"}]
[]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B5)","v":"HMACSHA256 of 20220525"},{"$f":"Base64_HMACSHA256_RAW(B5,B38)","v":"d4d8e5ab99a2391656c864edc3a48f91ead5ea1ae0939df35f3112da928284f3"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B9)","v":"HMACSHA256 of us-west-2"},{"$f":"Base64_HMACSHA256(B9,B40)","v":"379ffb11b154229a1e416bff98320bf5653a1c1f25f77e6a1165089bc10717eb"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B10)","v":"HMACSHA256 of s3"},{"$f":"Base64_HMACSHA256(B10,B41)","v":"f511fe690636edce10300363a342c35725b4a63eb3f4bcd7b7f8c8840ac05676"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B11)","v":"HMACSHA256 of aws4_request"},{"$f":"Base64_HMACSHA256(B11,B42)","v":"cafa8b042716f9cb63dc875cb7de87ef0ec2464d726d99e44d5c8a078485adb8"}]
[]
["HMACSHA256",{"$f":"Base64_HMACSHA256(B36,B43)","v":"8f02706b944ca071daf0812905dd03af55fd88a49b0cf93d9f53e4626f7a9f29"}]
[]
[null,{"$f":"_xlfn.CONCAT(\"https://\",B16,\"/\",B2,\"?\",B21, \"&X-Amz-Signature=\",B45)","v":"https://brians3test.s3.us-west-2.amazonaws.com/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA5TRHZWO3QGECXEHC%2F20220525%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20220525T155346Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&X-Amz-Signature=8f02706b944ca071daf0812905dd03af55fd88a49b0cf93d9f53e4626f7a9f29"}]

{"sheet":"GET","index":1,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["Filename","020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf"]
[]
["Current date and time",{"$f":"UtcDate(B2)","v":"20220525T154205Z"}]
["Current date",{"$f":"LEFT(B4,8)","v":"20220525"}]
[null,"AWS4"]
[null,"HMAC-SHA256"]
[null,{"$f":"_xlfn.CONCAT(B6, \"-\", B7)","v":"AWS4-HMAC-SHA256"}]
["Region","us-west-2"]
[null,"s3"]
[null,"aws4_request"]
["Access Key","AKIA5TRHZWO3QGECXEHC"]
["Secret Key","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"]
["Bucket name","brians3test"]
[]
["host",{"$f":"_xlfn.CONCAT(B14,\".\",B10,\".\",B9,\".amazonaws.com\")","v":"brians3test.s3.us-west-2.amazonaws.com"}]
[]
[]
[null,"GET"]
[null,{"$f":"_xlfn.CONCAT(\"/\",B2)","v":"/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf"}]
[]
[null,{"$f":"_xlfn.CONCAT(\"host:\",B16)","v":"host:brians3test.s3.us-west-2.amazonaws.com"}]
[null,"x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]
[null,{"$f":"_xlfn.CONCAT(\"x-amz-date:\",B4)","v":"x-amz-date:20220525T154205Z"}]
[]
[null,"host;x-amz-content-sha256;x-amz-date"]
[null,"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]
[]
[null,{"$f":"_xlfn.CONCAT(B19,CHAR(10),B20,CHAR(10),B21,CHAR(10),B22,CHAR(10),B23,CHAR(10),B24,CHAR(10),B25,CHAR(10),B26,CHAR(10),B27)","v":"GET\n/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf\n\nhost:brians3test.s3.us-west-2.amazonaws.com\nx-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855\nx-amz-date:20220525T154205Z\n\nhost;x-amz-content-sha256;x-amz-date\ne3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"}]
[]
["SHA256",{"$f":"Base64_SHA256(B29)","v":"2a4cc49a8b5a9ac7cfbd96e4788f93ea890d431cbecf356759d3876acc4b0d0c"}]
[]
[]
[null,"AWS4-HMAC-SHA256"]
[null,{"$f":"B4","v":"20220525T154205Z"}]
[null,{"$f":"_xlfn.CONCAT(B5,\"/\",B9,\"/s3/aws4_request\")","v":"20220525/us-west-2/s3/aws4_request"}]
[null,{"$f":"B31","v":"2a4cc49a8b5a9ac7cfbd96e4788f93ea890d431cbecf356759d3876acc4b0d0c"}]
[]
[null,{"$f":"_xlfn.CONCAT(B34,CHAR(10), B35, CHAR(10), B36, CHAR(10),B37)","v":"AWS4-HMAC-SHA256\n20220525T154205Z\n20220525/us-west-2/s3/aws4_request\n2a4cc49a8b5a9ac7cfbd96e4788f93ea890d431cbecf356759d3876acc4b0d0c"}]
[]
[null,{"$f":"_xlfn.CONCAT(B6,B13)","v":"AWS4jvIMMNOMEI7MoskR2rblLUZlInHE4FAYSZiyeiKK"}]
[]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B5)","v":"HMACSHA256 of 20220525"},{"$f":"Base64_HMACSHA256_RAW(B5,B41)","v":"d4d8e5ab99a2391656c864edc3a48f91ead5ea1ae0939df35f3112da928284f3"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B9)","v":"HMACSHA256 of us-west-2"},{"$f":"Base64_HMACSHA256(B9,B43)","v":"379ffb11b154229a1e416bff98320bf5653a1c1f25f77e6a1165089bc10717eb"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B10)","v":"HMACSHA256 of s3"},{"$f":"Base64_HMACSHA256(B10,B44)","v":"f511fe690636edce10300363a342c35725b4a63eb3f4bcd7b7f8c8840ac05676"}]
[{"$f":"_xlfn.CONCAT(\"HMACSHA256 of \", B11)","v":"HMACSHA256 of aws4_request"},{"$f":"Base64_HMACSHA256(B11,B45)","v":"cafa8b042716f9cb63dc875cb7de87ef0ec2464d726d99e44d5c8a078485adb8"}]
[]
["HMACSHA256",{"$f":"Base64_HMACSHA256(B39,B46)","v":"b634a6ae27a18f81afdadc61f518644f5ee9907b5753638e008eecd4e2980ea0"}]
[]
[null,{"$f":"_xlfn.CONCAT(\"https://\",B16,\"/\",B2)","v":"https://brians3test.s3.us-west-2.amazonaws.com/020706ac4b5c16e8342686f8c7202755_2022-03-26.mxf"}]
["Authorization",{"$f":"_xlfn.CONCAT(B34,\" Credential=\",B12,\"/\",B5,\"/\",B9,\"/\",B10,\"/\",B11,\", SignedHeaders=\",B26,\", Signature=\",B48)","v":"AWS4-HMAC-SHA256 Credential=AKIA5TRHZWO3QGECXEHC/20220525/us-west-2/s3/aws4_request, SignedHeaders=host;x-amz-content-sha256;x-amz-date, Signature=b634a6ae27a18f81afdadc61f518644f5ee9907b5753638e008eecd4e2980ea0"}]