{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet1 (2)"],"not_rendered":{"charts":1,"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":"Sheet1","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[13,1,13,2],[0,0,1,9],[2,1,3,8]]}
["Save time and money by moving from cheque to BACS payments"]
[]
[null,"If you have been thinking about moving from cheque to BACS payments then use this easy calculator to give you an estimate of the savings you could make. We have included an average hourly rate if you want to include time savings - if you don’t want to include these please leave question 5 blank. "]
[]
[]
[null,".","(Please type in values/ use drop down box provided)"]
[null,"1 - What is the estimated number of cheques you produce each month?",null,null,null,{"$f":"IF(G7=\"Cheque payments\",\"\",IF(AND(C7<20,C7>0.5),\"If you are producing less than 20 cheques per month it is unlikely you will make a significant saving\",\"\"))","v":""}]
[null,"2 - Do you use pre printed cheques or a bank provided cheque book?"]
[null,"3 - Do you use a Franking machine?"]
[null,"4 - Do you generally use 1st or 2nd class postage?"]
[null,"5 - How many hours spent writing/ printing/ posting cheques each month? (if applicable)"]
[]
[]
[null,"For the purpose of this calculation, we are using 11 months for the annual calculation (which excludes August)",null,null,"Yes"]
[null,null,null,null,"No"]
[null,"The rates below are used in this calclation.",null,null,"1st class"]
[null,null,null,null,"2nd class"]
[null,"Cheques",null,null,"Pre Printed"]
[null,"1st class stamp ",0.67,null,"Bank Provided"]
[null,"2nd class stamp",0.57999999999999996]
[null,"1st class frank",0.6]
[null,"2nd class frank",0.44]
[null,"Pre printed cheques",{"$f":"180/1000","v":0.18}]
[null,"Envelopes",{"$f":"9.2/1000","v":9.1999999999999998E-3}]
[null,"Printing costs per sheet",0.03]
[null,"Average KR7 Hourly rate",12.07]
[null,"BACS"]
[null,"Monthly payment",5]
[null,"Transaction charge",0.28000000000000003]
[null,"Printing costs per sheet",0.03]
[]
[]
[]
[null,{"$f":"\"Date calculated - \"&TEXT(TODAY(),\"DD/MM/YYY\")","v":"Date calculated - 16/04/2018"}]

{"sheet":"Sheet1 (2)","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,1,0,2],[41,6,41,7],[42,6,43,8],[40,6,40,7],[39,6,39,8]]}
[null,"Moving from cheque to BACS payments"]
[null,"- you could save time and money"]
[]
[]
[]
[null,".","(Please type in values/ use drop down box provided)",null,null,null,null,"Monthly","Annually","Including staff time cost writing/printing/posting cheques"]
[null,"How many cheques per month",{"$f":"Sheet1!C7","v":0},null,null,null,"Cheque payments",{"$f":"SUM(H29:H32)","v":0},{"$f":"H7*11","v":0},{"$f":"I7+C11*11.8","v":0}]
[null,"Do you use pre printed cheques or a bank provided cheque book?",{"$f":"Sheet1!C8","v":0},null,null,null,"BACS payments",{"$f":"SUM(J29:J32)","v":5.03},{"$f":"H8*11","v":55.330000000000005},{"$f":"I8","v":55.330000000000005}]
[null,"Do you use a Franking machine?",{"$f":"Sheet1!C9","v":0}]
[null,"Which stamps do you use to post your cheques?",{"$f":"Sheet1!C10","v":0},null,null,null,{"$f":"IF(I8<I7,\"You could save an estimated £\"&ROUND(SUM(I7-I8),2)&\" over a year! (excluding staff time costs)\",\"You are estimated to pay an extra £\"&ROUND(SUM(I8-I7),2)&\" a year\")","v":"You are estimated to pay an extra £55.33 a year"}]
[null,"Hours spent preparing/ writing/ posting",{"$f":"Sheet1!C11","v":0}]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"1st class"]
[null,null,null,null,"2nd class"]
[null,"Cheques",null,null,"Pre Printed"]
[null,"1st class stamp ",0.67,null,"Bank Provided"]
[null,"2nd class stamp",0.57999999999999996]
[null,"1st class frank",0.6]
[null,"2nd class frank",0.44]
[null,"Pre printed cheques",0.18]
[null,"Envelopes",9.1999999999999998E-3]
[null,"Printing costs per sheet",0.03]
[null,"AVG KR7 Hourly rate",12.07,null,null,null,"Breakdown of monthly costs for your comparison (based on answers to questions 1-5)"]
[null,"BACS"]
[null,"Monthly payment",5,null,null,null,"Cheques",null,"BACS"]
[null,"Transaction charge",0.28000000000000003,null,null,null,"Stamps",{"$f":"IF(C9=\"Yes\",IF(C10=\"1st class\",C21*C7,C22*C7),IF(C10=\"1st class\",C19*C7,C20*C7))","v":0},"BACS monthly payment",5]
[null,"Printing costs per sheet",0.03,null,null,null,"Pre printed cheques",{"$f":"IF(C8=\"pre printed\",C7*C23,0)","v":0},"Transaction charges",{"$f":"C29*C7","v":0}]
[null,null,null,null,null,null,"Envelopes",{"$f":"C24*C7","v":0},"Printing (monthly BACS run)",0.03]
[null,null,null,null,null,null,"Printing (remittance)",{"$f":"IF(C8=\"bank provided\",C25*C7,0)","v":0}]
[null,null,null,null,null,null,"KR7 salary",{"$f":"C11*C26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Monthly hours spent preparing cheques",null,"(Enter no. hours here and press enter)"]
[null,null,null,null,null,null,"Estimated monthly cost",null,{"$f":"IFERROR(I41*12,\"\")","v":""}]
[null,null,null,null,null,null,"This  is an estimate of the cost of the time spent preparing cheques based on an average KR7 grade salary."]