{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Criteria","Orders","Lists"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Criteria","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ecommerce Risk Matrix - Sample Spreadsheet"]
[null,"Created by: Kontrolit.net"]
[null,"Before using for your shop we suggest you plug in real data from existing orders (at least 10) and then adjust figures in yellow boxes to suit."]
[]
[null,"Title","Score",null,"Average Order Value",50]
["ID","Delivery address different from card holders address",5,null,"Mile multiplication",20]
[1,"Card holder’s security code doesn’t match",5,null,"Warning Threshold",15]
[2,"Card holder’s address partial match",3,null,"Do Not Ship Threshold",40]
[3,"Card holder’s address no match",5]
[4,"Mobile number",1]
[5,"Phone number not correct",5]
[6,"Email address a free one",1]
[7,"Email address is random",3]
[8,"Customer profile all lower case or upper case",2]
[9,"Time of day after 11pm and before 7am",3]
[10,"Distance between card holder’s address and delivery address",1]
[11,"Above average order value",1]
[12,"Customer has bought more than 2 months ago",-10]
[13,"Express delivery selected",5]
[14,"Country of the IP address does not match card holder",20]
[15,"A small order just before a larger order as a new customer",15]
[" "]

{"sheet":"Orders","index":1,"n_rows":19,"n_cols":21,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Order 1",null,"Order 2",null,"Order 3",null,"Order 4",null,"Order 5",null,"Order 6",null,"Order 7",null,"Order 8",null,"Order 9",null,"Order 10"]
["Criteria","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score","Data","Score"]
[{"$f":"Criteria!B7","v":"Delivery address different from card holders address"},"Yes",{"$f":"IF(B3=\"Yes\",Criteria!$C$8,0)","v":5},"Yes",{"$f":"IF(D3=\"Yes\",Criteria!$C$8,0)","v":5},"Yes",{"$f":"IF(F3=\"Yes\",Criteria!$C$8,0)","v":5},"Yes",{"$f":"IF(H3=\"Yes\",Criteria!$C$8,0)","v":5},null,{"$f":"IF(J3=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(L3=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(N3=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(P3=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(R3=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(T3=\"Yes\",Criteria!$C$8,0)","v":0}]
[{"$f":"Criteria!B8","v":"Card holder’s security code doesn’t match"},"Yes",{"$f":"IF(B4=\"Yes\",Criteria!$C$8,0)","v":5},"No",{"$f":"IF(D4=\"Yes\",Criteria!$C$8,0)","v":0},"Yes",{"$f":"IF(F4=\"Yes\",Criteria!$C$8,0)","v":5},"No",{"$f":"IF(H4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(J4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(L4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(N4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(P4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(R4=\"Yes\",Criteria!$C$8,0)","v":0},null,{"$f":"IF(T4=\"Yes\",Criteria!$C$8,0)","v":0}]
[{"$f":"Criteria!B9","v":"Card holder’s address partial match"},"Yes",{"$f":"IF(B5=\"Yes\",Criteria!$C$9,0)","v":3},"Yes",{"$f":"IF(D5=\"Yes\",Criteria!$C$9,0)","v":3},"Yes",{"$f":"IF(F5=\"Yes\",Criteria!$C$9,0)","v":3},"No",{"$f":"IF(H5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(J5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(L5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(N5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(P5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(R5=\"Yes\",Criteria!$C$9,0)","v":0},null,{"$f":"IF(T5=\"Yes\",Criteria!$C$9,0)","v":0}]
[{"$f":"Criteria!B10","v":"Card holder’s address no match"},"Yes",{"$f":"IF(B6=\"Yes\",Criteria!$C$10,0)","v":5},"No",{"$f":"IF(D6=\"Yes\",Criteria!$C$10,0)","v":0},"No",{"$f":"IF(F6=\"Yes\",Criteria!$C$10,0)","v":0},"No",{"$f":"IF(H6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(J6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(L6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(N6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(P6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(R6=\"Yes\",Criteria!$C$10,0)","v":0},null,{"$f":"IF(T6=\"Yes\",Criteria!$C$10,0)","v":0}]
[{"$f":"Criteria!B11","v":"Mobile number"},"Yes",{"$f":"IF(B7=\"Yes\",Criteria!$C$11,0)","v":1},"Yes",{"$f":"IF(D7=\"Yes\",Criteria!$C$11,0)","v":1},"Yes",{"$f":"IF(F7=\"Yes\",Criteria!$C$11,0)","v":1},"Yes",{"$f":"IF(H7=\"Yes\",Criteria!$C$11,0)","v":1},null,{"$f":"IF(J7=\"Yes\",Criteria!$C$11,0)","v":0},null,{"$f":"IF(L7=\"Yes\",Criteria!$C$11,0)","v":0},null,{"$f":"IF(N7=\"Yes\",Criteria!$C$11,0)","v":0},null,{"$f":"IF(P7=\"Yes\",Criteria!$C$11,0)","v":0},null,{"$f":"IF(R7=\"Yes\",Criteria!$C$11,0)","v":0},null,{"$f":"IF(T7=\"Yes\",Criteria!$C$11,0)","v":0}]
[{"$f":"Criteria!B12","v":"Phone number not correct"},"Yes",{"$f":"IF(B8=\"Yes\",Criteria!$C$12,0)","v":5},"No",{"$f":"IF(D8=\"Yes\",Criteria!$C$12,0)","v":0},"No",{"$f":"IF(F8=\"Yes\",Criteria!$C$12,0)","v":0},"No",{"$f":"IF(H8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(J8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(L8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(N8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(P8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(R8=\"Yes\",Criteria!$C$12,0)","v":0},null,{"$f":"IF(T8=\"Yes\",Criteria!$C$12,0)","v":0}]
[{"$f":"Criteria!B13","v":"Email address a free one"},"Yes",{"$f":"IF(B9=\"Yes\",Criteria!$C$13,0)","v":1},"Yes",{"$f":"IF(D9=\"Yes\",Criteria!$C$13,0)","v":1},"Yes",{"$f":"IF(F9=\"Yes\",Criteria!$C$13,0)","v":1},"Yes",{"$f":"IF(H9=\"Yes\",Criteria!$C$13,0)","v":1},null,{"$f":"IF(J9=\"Yes\",Criteria!$C$13,0)","v":0},null,{"$f":"IF(L9=\"Yes\",Criteria!$C$13,0)","v":0},null,{"$f":"IF(N9=\"Yes\",Criteria!$C$13,0)","v":0},null,{"$f":"IF(P9=\"Yes\",Criteria!$C$13,0)","v":0},null,{"$f":"IF(R9=\"Yes\",Criteria!$C$13,0)","v":0},null,{"$f":"IF(T9=\"Yes\",Criteria!$C$13,0)","v":0}]
[{"$f":"Criteria!B14","v":"Email address is random"},"Yes",{"$f":"IF(B10=\"Yes\",Criteria!$C$14,0)","v":3},"No",{"$f":"IF(D10=\"Yes\",Criteria!$C$14,0)","v":0},"No",{"$f":"IF(F10=\"Yes\",Criteria!$C$14,0)","v":0},"Yes",{"$f":"IF(H10=\"Yes\",Criteria!$C$14,0)","v":3},null,{"$f":"IF(J10=\"Yes\",Criteria!$C$14,0)","v":0},null,{"$f":"IF(L10=\"Yes\",Criteria!$C$14,0)","v":0},null,{"$f":"IF(N10=\"Yes\",Criteria!$C$14,0)","v":0},null,{"$f":"IF(P10=\"Yes\",Criteria!$C$14,0)","v":0},null,{"$f":"IF(R10=\"Yes\",Criteria!$C$14,0)","v":0},null,{"$f":"IF(T10=\"Yes\",Criteria!$C$14,0)","v":0}]
[{"$f":"Criteria!B15","v":"Customer profile all lower case or upper case"},"Yes",{"$f":"IF(B11=\"Yes\",Criteria!$C$15,0)","v":2},"No",{"$f":"IF(D11=\"Yes\",Criteria!$C$15,0)","v":0},"No",{"$f":"IF(F11=\"Yes\",Criteria!$C$15,0)","v":0},"Yes",{"$f":"IF(H11=\"Yes\",Criteria!$C$15,0)","v":2},null,{"$f":"IF(J11=\"Yes\",Criteria!$C$15,0)","v":0},null,{"$f":"IF(L11=\"Yes\",Criteria!$C$15,0)","v":0},null,{"$f":"IF(N11=\"Yes\",Criteria!$C$15,0)","v":0},null,{"$f":"IF(P11=\"Yes\",Criteria!$C$15,0)","v":0},null,{"$f":"IF(R11=\"Yes\",Criteria!$C$15,0)","v":0},null,{"$f":"IF(T11=\"Yes\",Criteria!$C$15,0)","v":0}]
[{"$f":"Criteria!B16","v":"Time of day after 11pm and before 7am"},"Yes",{"$f":"IF(B12=\"Yes\",Criteria!$C$16,0)","v":3},"No",{"$f":"IF(D12=\"Yes\",Criteria!$C$16,0)","v":0},"No",{"$f":"IF(F12=\"Yes\",Criteria!$C$16,0)","v":0},"No",{"$f":"IF(H12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(J12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(L12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(N12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(P12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(R12=\"Yes\",Criteria!$C$16,0)","v":0},null,{"$f":"IF(T12=\"Yes\",Criteria!$C$16,0)","v":0}]
[{"$f":"Criteria!B17","v":"Distance between card holder’s address and delivery address"},150,{"$f":"INT((B13/Criteria!$F$7)*Criteria!$C$17)","v":7},20,{"$f":"INT((D13/Criteria!$F$7)*Criteria!$C$17)","v":1},20,{"$f":"INT((F13/Criteria!$F$7)*Criteria!$C$17)","v":1},200,{"$f":"INT((H13/Criteria!$F$7)*Criteria!$C$17)","v":10},null,{"$f":"INT((J13/Criteria!$F$7)*Criteria!$C$17)","v":0},null,{"$f":"INT((L13/Criteria!$F$7)*Criteria!$C$17)","v":0},null,{"$f":"INT((N13/Criteria!$F$7)*Criteria!$C$17)","v":0},null,{"$f":"INT((P13/Criteria!$F$7)*Criteria!$C$17)","v":0},null,{"$f":"INT((R13/Criteria!$F$7)*Criteria!$C$17)","v":0},null,{"$f":"INT((T13/Criteria!$F$7)*Criteria!$C$17)","v":0}]
[{"$f":"Criteria!B18","v":"Above average order value"},400,{"$f":"INT((B14/Criteria!$F$6)*Criteria!$C$18)","v":8},300,{"$f":"INT((D14/Criteria!$F$6)*Criteria!$C$18)","v":6},58,{"$f":"INT((F14/Criteria!$F$6)*Criteria!$C$18)","v":1},50,{"$f":"INT((H14/Criteria!$F$6)*Criteria!$C$18)","v":1},null,{"$f":"INT((J14/Criteria!$F$6)*Criteria!$C$18)","v":0},null,{"$f":"INT((L14/Criteria!$F$6)*Criteria!$C$18)","v":0},null,{"$f":"INT((N14/Criteria!$F$6)*Criteria!$C$18)","v":0},null,{"$f":"INT((P14/Criteria!$F$6)*Criteria!$C$18)","v":0},null,{"$f":"INT((R14/Criteria!$F$6)*Criteria!$C$18)","v":0},null,{"$f":"INT((T14/Criteria!$F$6)*Criteria!$C$18)","v":0}]
[{"$f":"Criteria!B19","v":"Customer has bought more than 2 months ago"},"Yes",{"$f":"IF(B15=\"Yes\",Criteria!$C$19,0)","v":-10},"Yes",{"$f":"IF(D15=\"Yes\",Criteria!$C$19,0)","v":-10},"No",{"$f":"IF(F15=\"Yes\",Criteria!$C$19,0)","v":0},"No",{"$f":"IF(H15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(J15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(L15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(N15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(P15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(R15=\"Yes\",Criteria!$C$19,0)","v":0},null,{"$f":"IF(T15=\"Yes\",Criteria!$C$19,0)","v":0}]
[{"$f":"Criteria!B20","v":"Express delivery selected"},"Yes",{"$f":"IF(B16=\"Yes\",Criteria!$C$20,0)","v":5},"No",{"$f":"IF(D16=\"Yes\",Criteria!$C$20,0)","v":0},"No",{"$f":"IF(F16=\"Yes\",Criteria!$C$20,0)","v":0},"Yes",{"$f":"IF(H16=\"Yes\",Criteria!$C$20,0)","v":5},null,{"$f":"IF(J16=\"Yes\",Criteria!$C$20,0)","v":0},null,{"$f":"IF(L16=\"Yes\",Criteria!$C$20,0)","v":0},null,{"$f":"IF(N16=\"Yes\",Criteria!$C$20,0)","v":0},null,{"$f":"IF(P16=\"Yes\",Criteria!$C$20,0)","v":0},null,{"$f":"IF(R16=\"Yes\",Criteria!$C$20,0)","v":0},null,{"$f":"IF(T16=\"Yes\",Criteria!$C$20,0)","v":0}]
[{"$f":"Criteria!B21","v":"Country of the IP address does not match card holder"},"Yes",{"$f":"IF(B17=\"Yes\",Criteria!$C$21,0)","v":20},"No",{"$f":"IF(D17=\"Yes\",Criteria!$C$21,0)","v":0},"No",{"$f":"IF(F17=\"Yes\",Criteria!$C$21,0)","v":0},"No",{"$f":"IF(H17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(J17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(L17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(N17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(P17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(R17=\"Yes\",Criteria!$C$21,0)","v":0},null,{"$f":"IF(T17=\"Yes\",Criteria!$C$21,0)","v":0}]
[{"$f":"Criteria!B22","v":"A small order just before a larger order as a new customer"},"Yes",{"$f":"IF(B18=\"Yes\",Criteria!$C$22,0)","v":15},"No",{"$f":"IF(D18=\"Yes\",Criteria!$C$22,0)","v":0},"No",{"$f":"IF(F18=\"Yes\",Criteria!$C$22,0)","v":0},"No",{"$f":"IF(H18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(J18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(L18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(N18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(P18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(R18=\"Yes\",Criteria!$C$22,0)","v":0},null,{"$f":"IF(T18=\"Yes\",Criteria!$C$22,0)","v":0}]
[null,"Sub Total",{"$f":"SUM(C3:C18)","v":78},"Sub Total",{"$f":"SUM(E3:E18)","v":7},"Sub Total",{"$f":"SUM(G3:G18)","v":17},"Sub Total",{"$f":"SUM(I3:I18)","v":28},"Sub Total",{"$f":"SUM(K3:K18)","v":0},"Sub Total",{"$f":"SUM(M3:M18)","v":0},"Sub Total",{"$f":"SUM(O3:O18)","v":0},"Sub Total",{"$f":"SUM(Q3:Q18)","v":0},"Sub Total",{"$f":"SUM(S3:S18)","v":0},"Sub Total",{"$f":"SUM(U3:U18)","v":0}]

{"sheet":"Lists","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Yes"]
["No"]