{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":90,"n_cols":8,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Make Entries in Yellow Boxes"]
["Buy Outright or Rent?","BUY"]
["Primary Software Licence List","Licence","Req'd Y/N","Payable",null,null,"Customisation","Cost"]
["Back Office (Products and Pricing)",7500,"YES",{"$f":"IF(C4=\"YES\",$B$4,\"0\")","v":7500}," ",null," "," "]
["Party & Personal Orders",7500,"YES",{"$f":"IF(C5=\"YES\",$B$5,\"0\")","v":7500}," ",null,"Integration Estimate",0]
["Virtual Parties (must have B2C Store and Replicating Module)",2500,"YES",{"$f":"IF(C6=\"YES\",$B$6,\"0\")","v":2500},null,null,"Historic Data Transfer  "," "]
["Genealogy / Downline Sales Reports",2500,"YES",{"$f":"IF(C7=\"YES\",$B$7,\"0\")","v":2500},null,null,"Estimate",0]
["Real Time Commission Report",2500,"YES",{"$f":"IF(C8=\"YES\",$B$8,\"0\")","v":2500},null,null,"Bespoke Estimate",0]
["Top Product Sales Report",2000,"YES",{"$f":"IF(C9=\"YES\",$B$9,\"0\")","v":2000},null,null," "," "]
["Customer & Hostess Sales Reports",2000,"YES",{"$f":"IF(C10=\"YES\",$B$10,\"0\")","v":2000},null,null," "," "]
["Recruits & Leavers / Inactive Consultants",2500,"YES",{"$f":"IF(C11=\"YES\",$B$11,\"0\")","v":2500},null,null,"  ","  "]
["Consultant Dashboard",2500,"YES",{"$f":"IF(C12=\"YES\",$B$12,\"0\")","v":2500},null,null," "," "]
["New Consultant Registration",2500,"YES",{"$f":"IF(C13=\"YES\",$B$13,\"0\")","v":2500}," "]
["Customer B2C Store - Shopping Cart",5000,"YES",{"$f":"IF(C14=\"YES\",$B$14,\"0\")","v":5000}," "]
["Daily Metrics/Order Summary Reports/Held Stock Reports",2000,"YES",{"$f":"IF(C15=\"YES\",$B$15,\"0\")","v":2000}," ",null," "]
["Promotions / Demotions / New Consultant Sales Reports",1000,"YES",{"$f":"IF(C16=\"YES\",$B$16,\"0\")","v":1000}]
["Special Offer Management",2000,"YES",{"$f":"IF(C17=\"YES\",$B$17,\"0\")","v":2000}," ",null," "," "]
["Credit Note / Returns / Refunds",1500,"YES",{"$f":"IF(C18=\"YES\",$B$18,\"0\")","v":1500}," ",null," "," "]
["Consultant Promotions",2000,"YES",{"$f":"IF(C19=\"YES\",$B$19,\"0\")","v":2000}," "]
["Customer Promotions",2000,"YES",{"$f":"IF(C20=\"YES\",$B$20,\"0\")","v":2000}," ",null," "," "]
["Hostess Promotions",2000,"YES",{"$f":"IF(C21=\"YES\",$B$21,\"0\")","v":2000}," "]
["Variable Kits",2500,"YES",{"$f":"IF(C22=\"YES\",$B$22,\"0\")","v":2500}," ",null," "," "]
["Content Management Services",5000,"YES",{"$f":"IF(C23=\"YES\",$B$23,\"0\")","v":5000}," "]
["Content Management Public Site",5000,"YES",{"$f":"IF(C24=\"YES\",$B$24,\"0\")","v":5000}]
["SagePay Integration",1500,"NO",{"$f":"IF(C25=\"YES\",$B$25,\"0\")","v":"0"}]
["WorldPay Integration",5000,"NO",{"$f":"IF(C26=\"YES\",$B$26,\"0\")","v":"0"}]
["Adelante Integration",1500,"NO",{"$f":"IF(C27=\"YES\",$B$27,\"0\")","v":"0"}]
["Replicating Module",3750,"YES",{"$f":"IF(C28=\"YES\",$B$28,\"0\")","v":3750},"  ",null," "," "]
["Primary Software Licence UK",{"$f":"D29","v":67750},null,{"$f":"SUM(D4:D28)","v":67750},null,null,"Total Customisation",{"$f":"SUM(H4:H28)","v":0}]
["Countries, Currencies and Languages Licences"," "]
["Number of Additional Countries",0,{"$f":"D31","v":0},{"$f":"D29*B31*(B51*2/3/100)","v":0}]
["Number of Additional Currencies",0,{"$f":"D32","v":0},{"$f":"D29*B32*(B50*2/3/100)","v":0}]
["Number of Languages ",0,0,{"$f":"B33*B52","v":0}]
["Primary Software Licence Total",{"$f":"D34","v":67750}," ",{"$f":"D29+D31+D32+D33","v":67750}]
["Total Customisation",{"$f":"H29","v":0},null,null,"Nr Srv"]
["Cloud Server Required",170,"YES",{"$f":"IF(C36=\"YES\",$B$36,\"0\")","v":170},{"$f":"IF(C36=\"YES\",1,\"0\")","v":1}]
["Dedicated  Server(s) Required (exc Failover)",650,"NO",{"$f":"IF(C37=\"YES\",$B$37*E37,\"0\")","v":"0"},1]
["Failover Set up Required",650,"NO"]
["Is One of the Servers Dedicated to Reporting",0,"NO"]
[" ",null," ",{"$f":"IF(C36=\"YES\",$B$46*E36,\"0\")","v":0}]
[null,null," ",{"$f":"IF(C37=\"YES\",$B$47*E37,\"0\")","v":"0"}]
["Rates",null,null,{"$f":"IF(C38=\"YES\",$B$38,\"0\")","v":"0"}]
["Daily Rate",700," ",{"$f":"IF(C37=\"YES\",$D$41,$D$40)","v":0}]
["SSL Certificate",0]
["Travel Charge per mile",0.35]
["Cloud Server Set Up Fee",0]
["Dedicated Server Set Up Fee",550]
["Failover Set Up ",6875]
["Report Server Set Up",1375]
["Currency Licence %",15]
["Country Licence %",15]
["Language Licence",1350]
["Managed Service Only: software licence % pm",5]
["Managed Service Only: £ per 1000 consultants pm",0]
["Managed Service Only: country/currency % pm",1.5]
["Forecasted Growth",null,null," "]
[null,"Year 1"," "," ","Year 2","Year 3"]
["Number of Consultants in 1000's",1," "," ",2,3]
["Number of Replicated Website Sales",0," ","rep each mth",0,0]
[]
["Financial","Year 1",{"$f":"E61","v":"Year 2 +"},null,"Year 2 +"]
["Deposit (Payable With Order)",{"$f":"(B34+H29)/2","v":33875},null," "]
["followed by  "]
["Licence Balance (Payable on Project Completion Date)",{"$f":"B62","v":33875},null,null,0]
["Rental (Payable Monthly from Installation)",{"$f":"(D29*(B53/100))+(H29*(B53/100))+(B58*B54)+((B31*D29)*B55/100)+((B32*D29)*B55/100)+(D33*(B55/100))","v":3387.5},{"$f":"B65","v":3387.5}," ",{"$f":"B65+((E58-B58)*B54)","v":3387.5}]
[null,null,null," "]
["AND OPTIONALLY",null,null," "]
["Annual Maintenance ",{"$f":"((D29)*0.175)+(D29*B32*0.175*0.5)+(D29*B31*0.175*0.5)+(D33*0.175)+(H29*0.175)","v":11856.25},{"$f":"B68","v":11856.25},null,{"$f":"B68","v":11856.25}]
[null,null,null," "]
["Replication Charge (Payable Monthly from Installation)",{"$f":"IF(C28=\"YES\",$B$59*$D$62,\"0\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(C28=\"YES\",$E$59*$D$62,\"0\")","v":{"$error":"#VALUE!"}}]
["Hosting Fee (Payable Monthly from Installation)",{"$f":"IF(C37=\"YES\",$B$37*E37,$D$36)","v":170},{"$f":"B71","v":170},null,{"$f":"B71","v":170}]
["Hosting Fee Failover Servers",{"$f":"IF(C38=\"YES\",$B$71,\"0\")","v":"0"},null,null,{"$f":"B72","v":"0"}]
["Failover Tuning (Payable Monthly from Installation)",{"$f":"D42","v":"0"}," "," ",{"$f":"B73","v":"0"}]
["TOTAL INC ALL COSTS",null,null," "]
["Cost for Year  ",{"$f":"B62+B64+B68+(B71*12)","v":81646.25},{"$f":"C62+C64+C68+(C71*12)","v":13896.25}," ",{"$f":"E62+E64+E68+(B71*12)+B44","v":13896.25}]
["Rental Cost for Year",{"$f":"B62+(B65*12)+(B71*12)","v":76565},{"$f":"E76","v":42690}," ",{"$f":"E62+(E65*12)+(B71*12)","v":42690}," "," "]
[null,null,null," "]
[]
[null,null,null," "]
[" ",null,null," "]
[" ",null,null," "]
[null,null,null," "]
[]
[null,null,null," "]
[null,null,null," "]
[]
[null,null,null,"YES"]
[null,null,null,"NO"]
[null,null,null,"BUY"]
[null,null,null,"RENT"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}