{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":9,"rows_kept":21}
["Parameter-value List"]
["AMOUNT=","CURRENCY=","LANGUAGE=","ORDERID=","PSPID=","SHA-IN","SHASIGN=","Email address","CC"]
[100,"GBP","en_US",4516628,"McEwen8","IntegrationAttempt1*","A3984E7C5E60A5C6CC38391DE1AA62AC41D2EDD8","ryanmcewen8@gmail.com"]
["&"]
[]
[]
["SHASIGN calculation"]
[{"$f":"CONCATENATE(A2,A3,F3,B2,B3,F3,C2,C3,F3,D2,D3,F3,E2,E3,F3)","v":"AMOUNT=100IntegrationAttempt1*CURRENCY=GBPIntegrationAttempt1*LANGUAGE=en_USIntegrationAttempt1*ORDERID=4516628IntegrationAttempt1*PSPID=McEwen8IntegrationAttempt1*"}]
[]
[]
["Copy the above calcuation into the following link"]
["https://mdepayments.epdq.co.uk/Ncol/Test/testsha.asp"]
[]
[]
["Link creation"]
["https://mdepayments.epdq.co.uk/ncol/test/orderstandard.asp?"]
[{"$f":"CONCATENATE(A2,A3,A4,B2,B3,A4,C2,C3,A4,D2,D3,A4,E2,E3,A4,G2,G3)","v":"AMOUNT=100&CURRENCY=GBP&LANGUAGE=en_US&ORDERID=4516628&PSPID=McEwen8&SHASIGN=A3984E7C5E60A5C6CC38391DE1AA62AC41D2EDD8"}]
[]
[]
["The link itself"]
[{"$f":"CONCATENATE(A16,A17)","v":"https://mdepayments.epdq.co.uk/ncol/test/orderstandard.asp?AMOUNT=100&CURRENCY=GBP&LANGUAGE=en_US&ORDERID=4516628&PSPID=McEwen8&SHASIGN=A3984E7C5E60A5C6CC38391DE1AA62AC41D2EDD8"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}