{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Order Form"," Monthly LS Central on BC SaaS","LS Central on BC SaaS edit","BTC2 Computation","Change Log ","FactorOld","Factor","Price List","Lists","Change Log"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":4,"defined_names":49,"comments":6,"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":"Order Form","index":0,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":true,"merged":[[55,0,55,9],[52,0,52,9],[17,3,17,9],[46,3,46,4],[46,5,46,8],[54,0,54,9],[53,0,53,9]]}
["How to order:"]
[null,"Submission Details: e-mail all orders to licenses@lsretail.com or submit a request via JIRA "]
[]
[]
[null,"In order to ensure the fastest order processing, the following completed Order Form is now required for all eligible orders to LS Retail:"]
[null,"1.  Orders received on out-of-date pricelists will not be processed and will be returned to the sender for correction."]
[null,"2.  Underlined fields in RED are mandatory."]
[null,"3.  Alterations to the format of this coversheet may result in delays or non-acceptance."]
[null,"4.  To submit the order, please fill out this form and email to licenses@lsretail.com or submit a request via JIRA."]
[null,"5.  This order may not be processed if your account has overdue balances or you have exceeded your credit limit. "]
[null,"      To check your account statement and credit limit please send email to accounting@lsretail.com"]
[null,"6.  You can view your partner discounts on LS Retail Business Center."]
[]
["Order details:"]
[null,"Order date"]
[null,"Purchase order (PO) number"]
[null,"Special Deal / Promo"]
[null,"MA/GVA/PVLA","No",{"$f":"IF(C18=\"No\",\"\",\"Please contact your partner for discounts\")","v":""}]
[]
["Partner details:"]
[null,"Partner name"]
[null,"Partner MPN no."]
[]
["Customer details:"]
[null,"Order Type:","New License","Select appropriate order type, New license, Additonal Modules "]
[null,"Customer name"]
[null,"Customer INN/TIN number"]
[null,"Doing business as"]
[null,"Customer no. (if Applicable)"]
[null,"Link to Existing SaaS Active Directory","No"]
[null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"Microsoft Tenant ID:\",\"Request for a Preferred Domain name (Option 1)\")","v":"Request for a Preferred Domain name (Option 1)"},null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"\",\"onmicrosoft.com\")","v":"onmicrosoft.com"}]
[null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"Domain Name:\",\"Request for a Preferred Domain name (Option 2)\")","v":"Request for a Preferred Domain name (Option 2)"},null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"\",\"onmicrosoft.com\")","v":"onmicrosoft.com"}]
[null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"Domain Name:\",\"Request for a Preferred Domain name 3\")","v":"Request for a Preferred Domain name 3"},null,{"$f":"IF(Link_To_Existing_SaaS_Active_Directory=\"Yes\",\"\",\"onmicrosoft.com\")","v":"onmicrosoft.com"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Address 1\",\"\")","v":"Address 1"}]
[null,{"$f":"IF(New_License=\"New License\",\"Address 2\",IF(New_License=\"Transition\",\"Address 2\",\"\"))","v":"Address 2"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"City\",\"\")","v":"City"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Postal/Zip\",\"\")","v":"Postal/Zip"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"State/Province\",\"\")","v":"State/Province"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Country\",\"\")","v":"Country"},"United States"]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Email\",\"\")","v":"Email"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Phone\",\"\")","v":"Phone"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Contact name\",\"\")","v":"Contact name"}]
[null,{"$f":"IF(New_License=\"New License\",\"Customer Website\",IF(New_License=\"Transition\",\"Customer Website\",\"\"))","v":"Customer Website"}]
[null,{"$f":"IF(New_License=\"New License\",\"Enhancement Plan Required for \",\"\")","v":"Enhancement Plan Required for "}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Product line\",\"\")","v":"Product line"},"LS Central on Business Central SaaS"]
[null,{"$f":"IF(New_License=\"New License\",\"NACE code\",\"\")","v":"NACE code"}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Type of business\",\"\")","v":"Type of business"},"Please select the correct Type of Business"]
[null,{"$f":"IF(New_License=\"New License\",\"LS Retail Version no.\",\"\")","v":"LS Retail Version no."}]
[null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"Date of Customer Acceptance of LS Retail SaaS customer terms (including Microsoft Customer Agreement)\",\"\")","v":"Date of Customer Acceptance of LS Retail SaaS customer terms (including Microsoft Customer Agreement)"},{"$f":"TODAY()","v":"2024-04-15"}]
[null,null,{"$f":"IF((OR(New_License=\"New License\",Transition=\"Transition\")),\"*LS Retail Customer Terms (link opens in a new tab)\",\"\")","v":"*LS Retail Customer Terms (link opens in a new tab)"}]
[]
["Disclaimer:"]
["This pricelist is intended for general information purposes only, and is provided AS IS. Any risk arising from the use of the information shall rest with the recipient and nothing herein shall be construed as constituting any kind of warranty or representation, express, implied or statutory.  Users are responsible for information that is input using the pricing calculator embedded in this pricelist.  LS Retail does not warrant or make any representations regarding the use, validity or accuracy of this pricelist and the result of the calculations. "]
["Here you can find information on the availability of LS Central on BC SaaS local versions"]
["LS Central on Business Central SaaS is available for customers located in United States, Canada, United Kingdom, Denmark, Germany and Iceland"]
["All new LS Retail licenses are automatically listed as a reference customer upon processing of the initial order. Contact licenses@lsretail.com to opt out of this program. "]
[]
[null," "]

{"sheet":" Monthly LS Central on BC SaaS","index":1,"n_rows":83,"n_cols":12,"rows_kept":83,"cut":false,"hidden":true,"merged":[[52,8,52,10],[53,8,53,10],[54,8,54,10],[60,9,60,10],[43,8,43,10],[44,8,44,10],[49,8,49,10],[50,8,50,10],[51,8,51,10],[57,8,57,10],[58,8,58,10],[55,8,55,10],[56,8,56,10],[48,8,48,10],[33,9,33,10],[37,8,37,10],[38,8,38,10],[39,8,39,10],[42,8,42,10],[40,8,40,10],[82,1,82,9],[76,1,76,10],[77,1,77,10],[78,1,78,10],[80,1,80,9],[74,3,74,6],[2,6,7,8],[13,8,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[28,8,28,10],[29,8,29,10],[19,9,19,10],[26,8,26,10],[27,8,27,10],[32,8,32,10],[74,8,74,10],[59,9,59,10],[31,8,31,10],[30,8,30,10],[0,9,0,10],[22,8,22,10],[0,1,0,3],[23,8,23,10],[25,8,25,10],[20,9,20,10],[24,8,24,9],[21,8,21,10]]}
[null," LS Central on Business Central SaaS Price Quote Sheet",null,null,null,null,null,{"$f":"\"Effective from \"&TEXT(Lists!L18,\"dd.mm.yyyy\")","v":"Effective from Effective from 1 September 2023"},null,"LS Retail Confidential"]
[]
[]
[null,{"$f":"\"Customer Location:  \"","v":"Customer Location:  "},"United States"]
[null,{"$f":"\"Country Code:  \"","v":"Country Code:  "},"W1"]
[null,{"$f":"\"Customer Region:  \"","v":"Customer Region:  "},{"$f":"FactorOld!C1","v":"NAOM"}]
[]
[]
[null,null,null,null,null,null,"Subscription Term","Monthly"]
[null,{"$f":"\"Currency:  \"","v":"Currency:  "},"USD",null,null,null,"Mode of Billing","Monthly"]
[]
[null,null,null,null,null,null,null,"Total Value","License Currency"]
[null,null,"                          Check here to opt in for a 3 year price guarantee which comes with a 3-year commmitment period",null,null,null,null,{"$f":"H75","v":0},{"$f":"FactorOld!P1","v":"USD"}]
[null,"Qty","Monthly Modules","Granule ID","SKU",null,{"$f":"Factor!P1&\" Monthly\"","v":"USD Monthly"},"Total ","Prerequisites/Notes: \nMinimum order 1 Essential or Premium User and 1 LS Central Base - Per Full User, 1 Store and 1 LS Retail Device SAL"]
[null,null,"Promotion",null,null,null,null,null,"Minimum order 1 Essential or Premium User and 1 LS Central Base - Per Full User and 1 LS Retail Device SAL","The modules listed here are only the Get Me Started promotion modules - if you need to add more modules please add them in the price list below"]
[null,null,"Get me Started",null,null,null,null,null,null,"To enable the Get Me Started promotion please enter \"1\"  - no other number should be inserted in this part below"]
[null,{"$f":"+IF($B$16=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B4),'Price List'!B4,\"\")","v":"    Dynamics 365 Business Central Essential"},null,{"$f":"+'Price List'!C4","v":"BC-D365-SAAS-E"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B4),FALSE)","v":84},{"$f":"G17*B17*(1-0.15)","v":0},null,"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$16=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B5),'Price List'!B5,\"\")","v":"    Dynamics 365 Business Central Premium"},null,{"$f":"+'Price List'!C5","v":"BC-D365-SAAS-P"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B5),FALSE)","v":120},{"$f":"G18*B18*(1-0.15)","v":0},null,"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$16=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B30),'Price List'!B30,\"\")","v":"     LS Central Base - Per Full User"},null,{"$f":"'Price List'!C30","v":"BC-D365-SAAS-BASE"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B30),FALSE)","v":36},{"$f":"G19*B19*(1-0.15)","v":0},null,"If customer needs additional LS Central Base - Per full user please add them below",""]
[null,0,{"$f":"\"    \"&IF(ISTEXT('Price List'!B42),'Price List'!B42,\"\")","v":"    Device SAL for Retail & Hospitality"},null,{"$f":"'Price List'!C42","v":"BC-D365-SAAS-POS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B42),FALSE)","v":102},{"$f":"G20*B20*(1-0.15)","v":0},null,"If customer needs additional Retail Device SAL for Retail & Hospitality please add them below"]
[]
[null,{"$f":"SUM(B16,B23:B24)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B3),'Price List'!B3,\"\")","v":"    ERP Users"},"","",null,"","",""]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B4),'Price List'!B4,\"\")","v":"   Dynamics 365 Business Central Essential"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"+'Price List'!C4","v":"BC-D365-SAAS-E"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B4),FALSE)","v":84},{"$f":"+B23*G23","v":0},"You cannot mix and match Essential and Premium Users, Includes 2 GB database capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B5),'Price List'!B5,\"\")","v":"   Dynamics 365 Business Central Premium"},{"$f":"IF('Price List'!C42,'Price List'!C42,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C5","v":"BC-D365-SAAS-P"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B5),FALSE)","v":120},{"$f":"+B24*G24","v":0},"You cannot mix and match Essential and Premium Users, Includes 3 GB database capacity "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B6),'Price List'!B6,\"\")","v":"   Dynamics 365 Business Central Team Member"},{"$f":"IF('Price List'!C5,'Price List'!C5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C6","v":"BC-D365-SAAS-TM"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B6),FALSE)","v":9.6},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B7),'Price List'!B7,\"\")","v":"   Dynamics 365 Business Central External Accountant"},{"$f":"IF('Price List'!C43,'Price List'!C43,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C7","v":"BC-D365-SAAS-EA"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B7),FALSE)","v":0},0,"One included per tenant"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B8),'Price List'!B8,\"\")","v":"   Dynamics 365 Business Central Sales Professional attach"},null,{"$f":"+'Price List'!C8","v":"BC-D365-SAAS-SPA"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B8),FALSE)","v":24},0,"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to."]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B9),'Price List'!B9,\"\")","v":"   Dynamics 365 Business Central Customer Service Professional attach"},null,{"$f":"+'Price List'!C9","v":"BC-D365-SAAS-CSPA"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B9),FALSE)","v":24},0,"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to."]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B18),'Price List'!B18,\"\")","v":"    Other Modules"}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B19),'Price List'!B19,\"\")","v":"   Dynamics 365 Business Central Database Capacity"},null,{"$f":"+'Price List'!C19","v":"BC-D365-SAAS-CDC"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B19),FALSE)","v":12},{"$f":"+B30*G30","v":0},"Additional Database Capacity is sold per GB"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B20),'Price List'!B20,\"\")","v":"   Dynamics 365 Business Central Database Capacity Additional 100 GB"},{"$f":"IF('Price List'!C4,'Price List'!C4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C20","v":"BC-D365-SAAS-CDCA"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B20),FALSE)","v":600},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B21),'Price List'!B21,\"\")","v":"   Dynamics 365 Business Central Database Capacity Overage"},{"$f":"IF('Price List'!C5,'Price List'!C5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C21","v":"BC-D365-SAAS-CDCO"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B21),FALSE)","v":6},{"$f":"+B32*G32","v":0},"Pre-requirement is Business Central Database Capacity Additional 100 GB"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B22),'Price List'!B22,\"\")","v":"   Dynamics 365 Business Central Additional Environment Addon*"},{"$f":"IF('Price List'!C44,'Price List'!C44,\"\")","v":{"$error":"#VALUE!"}},{"$f":"+'Price List'!C22","v":"BC-D365-SAAS-CAE"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B22),FALSE)","v":360},{"$f":"+B33*G33","v":0},"Please indicate the country where the Additional Environment will be setup; \n*Additional Environments can only be setup in countries where LS Central SaaS clusters are running"]
[null,{"$f":"SUM(B35+B16)","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B29),'Price List'!B29,\"\")","v":"   Base"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B16=1,\"Promo Discount:\",\"\")","v":""},{"$f":"IF(B16=1,0.05,\"\")","v":""}]
[null,{"$f":"B22","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B30),'Price List'!B30,\"\")","v":"    LS Central Base - Per Full User"},{"$f":"IF('Price List'!C56,'Price List'!C56,\"\")","v":""},{"$f":"'Price List'!C30","v":"BC-D365-SAAS-BASE"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B30),FALSE)","v":36},{"$f":"IF(B16=1,(+B35*G35)*(1-H34),G35*B35)","v":0},"LS Central Base - Per Full User (Essential or Premium) is a prerequisite for Retail Devices"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B31),'Price List'!B31,\"\")","v":"    Yearly"},{"$f":"IF('Price List'!C7,'Price List'!C7,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C31","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B31),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B33),'Price List'!B33,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C33","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B33),FALSE)","v":0},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B34),'Price List'!B34,\"\")","v":"   Stores"},null,null,null,null,null," It is not permitted to have both Online Store and Offline Store, either all Online or all Offline"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B35),'Price List'!B35,\"\")","v":"   Online Store"},null,{"$f":"'Price List'!C35","v":"BC-D365-SAAS-STOREON"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B35),FALSE)","v":0},{"$f":"G39*+B39","v":0},"Does not include a Device or a DD license. Qty should be equal to total Number of stores in the customer license. "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B36),'Price List'!B36,\"\")","v":"   Offline Store"},null,{"$f":"'Price List'!C36","v":"BC-D365-SAAS-STOREOFF"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B36),FALSE)","v":6},{"$f":"G40*+B40","v":0},"Includes a DD license but does not include a Device. Qty should be equal to total Number of stores in the customer license. "]
[null,{"$f":"SUM(B42:B46)","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B41),'Price List'!B41,\"\")","v":"   Devices"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B16=1,\"Promo Discount:\",\"\")","v":""},{"$f":"IF(B16=1,0.05,\"\")","v":""}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B42),'Price List'!B42,\"\")","v":"   Device SAL for Retail & Hospitality"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C42","v":"BC-D365-SAAS-POS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B42),FALSE)","v":102},{"$f":"IF(B16=1,(+B42*G42)*(1-H41),G42*B42)","v":0},"Stationary POS, LS Central POS (web version), back office device, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B43),'Price List'!B43,\"\")","v":"   Device SAL for Mobile POS App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C43","v":"BC-D365-SAAS-MPOS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B43),FALSE)","v":102},0,"For retail, for Android devices, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B44),'Price List'!B44,\"\")","v":"   Device SAL for Mobile Inventory App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C44","v":"BC-D365-SAAS-MI"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B44),FALSE)","v":102},0,"For retail, for Android devices, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B45),'Price List'!B45,\"\")","v":"   Device SAL for Kitchen Display Server"},null,{"$f":"'Price List'!C45","v":"BC-D365-SAAS-KDS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B45),FALSE)","v":102},0,"Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B46),'Price List'!B46,\"\")","v":"   Device SAL for Back Office "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C46","v":"BC-D365-SAAS-BACK"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B46),FALSE)","v":102},0,"For Back Office only and no customer facing transactions, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B57),'Price List'!B57,\"\")","v":"    Office 365 Business Premium"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C57","v":"BC-D365-SAAS-O365BP"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B57),FALSE)","v":15},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B58),'Price List'!B58,\"\")","v":"    Power BI Pro"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C58","v":"BC-D365-SaaS-PBP"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B58),FALSE)","v":12},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B62),'Price List'!B62,\"\")","v":"   LS Central Modules"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C62","v":""},null,null,null,"LS Central Base - Per Full User is prerequisite for all below modules",null,null," "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B63),'Price List'!B63,\"\")","v":"   Scan Pay Go - per Usage"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C63","v":"BC-D365-SAAS-SPG"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B63),FALSE)","v":0.01},{"$f":"+B50*G50","v":0},"Invoiced per Scan Pay Go Transaction Usage, Invoiced Monthly for the past month"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B65),'Price List'!B65,\"\")","v":"   Hotels - per Property"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C65","v":"BC-D365-SAAS-HOTEL-P"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B65),FALSE)","v":163.19999999999999},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B66),'Price List'!B66,\"\")","v":"   Hotels - per Room"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C66","v":"BC-D365-SAAS-HOTEL-R"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B66),FALSE)","v":7},{"$f":"+B52*G52","v":0},"LS Central for hotels - per Property is prerequisite"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B67),'Price List'!B67,\"\")","v":"   Hotels - per Power App User"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C67","v":"BC-D365-SAAS-HOTEL-PAU"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B67),FALSE)","v":15},{"$f":"+B53*G53","v":0},"LS Central for hotels - per Property is prerequisite"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B68),'Price List'!B68,\"\")","v":"   Bookings - per Location"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C68","v":"BC-D365-SAAS-APL"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B68),FALSE)","v":15},0,"LS Activity - per Location is prerequisitefor LS Activity - per Device"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B69),'Price List'!B69,\"\")","v":"   Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C69","v":"BC-D365-SAAS-APOS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B69),FALSE)","v":12},{"$f":"+B55*G55","v":0},"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality, for Mobile POS App and Back Office in the customer license "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B70),'Price List'!B70,\"\")","v":"   Staff Management - per Employee"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C70","v":"BC-D365-SAAS-SPE"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B70),FALSE)","v":2},0,"Per all Employees in the LSC Staff Employee Table.  "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B71),'Price List'!B71,\"\")","v":"   LS Pay - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C71","v":"BC-D365-SAAS-PAY"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B71),FALSE)","v":12},0,"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality and Retail Device CALs for Mobile POS App in the customer license"]
[null,null,"LS eCommerce Base - Please select a Framework",{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C58,'Price List'!B76:C79,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B76),FALSE)","v":163.19999999999999},{"$f":"(+B58*G58)","v":0},"LS eCommerce Base is a prerequisite for LS eCommerce per Device"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B80),'Price List'!B80,\"\")","v":"   eCommerce per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C80","v":"BC-D365-SAAS-EPOS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$I$132,ROW('Price List'!B80),FALSE)","v":3.6},{"$f":"(+B59*G59)","v":0},"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality and Retail Device CALs for Mobile POS App in the customer license"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!#REF!),'Price List'!#REF!,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"(+B60*G60)*0.5","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B81),'Price List'!B81,\"\")","v":"    LS Central Additional Language Layer"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C81","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B81),FALSE)","v":24},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B69),'Price List'!B69,\"\")","v":"    Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C69","v":"BC-D365-SAAS-APOS"},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B69),FALSE)","v":12},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B107),'Price List'!B107,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C107","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B107),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B108),'Price List'!B108,\"\")","v":"     "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C108","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B108),FALSE)","v":500},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B109),'Price List'!B109,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C109","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B109),FALSE)","v":40},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B110),'Price List'!B110,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C110","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B110),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B111),'Price List'!B111,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C111","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B111),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B112),'Price List'!B112,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C112","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B112),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B113),'Price List'!B113,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C113","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B113),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B114),'Price List'!B114,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C114","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B114),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B115),'Price List'!B115,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C115","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B115),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B116),'Price List'!B116,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C116","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B116),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B117),'Price List'!B117,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C117","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B117),FALSE)","v":0},0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B118),'Price List'!B118,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C118","v":0},null,{"$f":"HLOOKUP($C$10,'Price List'!$B$1:$G$132,ROW('Price List'!B118),FALSE)","v":0},0]
[null,null,"","Total Solution Cost (TSC)",null,null,null,{"$f":"SUM(H23:H28,H30:H33,H35,H39:H40,H42:H46,H51:H59)","v":0},""]
[null,null,"","","",null,"","",null,""]
[null,"Please find information about ongoing promos on our Partner Portal"]
[null,"Click here for more details about products in the Price List"]
[null,"Information on country availability can be found on LS Retail Portal"]
[]
[null,"This document is intended for general information purposes only, and we have taken due care in its preparation. All embedded functionality used to facilitate price calculations is provided AS IS. Any risk arising from the use of the information shall rest with the recipient and nothing herein shall be construed as constituting any kind of warranty or representation, express, implied or statutory.  Users are responsible for information that is input using the pricing calculator embedded in the offline pricelist.  Under certain circumstances the figures resulting from the applied pricing calculations embedded in the price list, which are shown for your convenience in this pricelist, may differ from those reflected in the Order Summary Page in Order Central. In these scenarios, the figures shown in the Order Summary Page will control."]
[]
[null,"For information on the availability of EFT connections for the mobile and the stationary LS Central Points of Sale, contact licenses@lsretail.com"]

{"sheet":"LS Central on BC SaaS edit","index":2,"n_rows":116,"n_cols":21,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,1,0,3],[0,9,0,15],[1,11,1,12],[2,7,3,9],[30,9,30,15],[23,9,23,15],[12,9,12,15],[13,9,13,15],[14,9,14,15],[15,9,15,15],[16,9,16,15],[17,9,17,15],[18,9,18,15],[19,9,19,15],[20,9,20,15],[21,9,21,15],[51,9,51,15],[22,9,22,15],[49,9,49,15],[50,9,50,15],[43,9,43,15],[44,9,44,15],[47,9,47,15],[48,9,48,15],[24,9,24,15],[32,9,32,15],[33,9,33,15],[39,9,39,15],[40,9,40,15],[37,9,37,15],[38,9,38,15],[25,9,25,15],[26,9,26,15],[27,9,27,15],[41,9,41,15],[42,9,42,15],[28,9,28,15],[29,9,29,15],[31,9,31,15],[96,11,96,12],[75,1,75,15],[76,1,76,15],[78,1,78,9],[80,1,80,9],[74,1,74,15],[57,9,57,15],[58,9,58,15],[56,9,56,15],[52,9,52,15],[54,9,54,15],[55,9,55,15],[72,3,72,6],[53,9,53,18],[72,9,72,15]]}
[null," LS Central on Business Central SaaS Price Quote Sheet",null,null,null,{"$f":"\"Effective from \"&TEXT(Lists!L18,\"dd.mm.yyyy\")","v":"Effective from Effective from 1 September 2023"},null,null,null,"LS Retail Confidential"]
[null,null,null,null,null,null,null,null,null,"Please see this link for the latest information and country availability details"]
[null,"Subscription Term:","Monthly"]
[null,"Mode of Billing:","Monthly"]
[null,{"$f":"\"Currency:\"","v":"Currency:"},"USD",null,null,null,null,"Partner discount Subscription/SaaS:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Value","License Currency"]
[null,null,"                                        Check here to opt in for a 3 year price guarantee which comes with a 3-year commmitment period",null,null,null,null,null,{"$f":"I73","v":0},{"$f":"Factor!P2","v":"USD"}]
[null,"Qty","Yearly Modules","Granule ID","SKU",{"$f":"J12","v":"USD"},{"$f":"Factor!P2&\" Yearly\"","v":"USD Yearly"},null,"Total ","Prerequisites/Notes: \nMinimum order 1 Essential or Premium User and 1 LS Central Base - Per Full User, 1 Store and 1 LS Retail Device SAL"]
[null,null,"Promotion",null,null,null,null,null,null,"The modules listed here are only the Get Me Started promotion modules - if you need to add more modules please add them in the price list below"]
[null,null,"Get me Started",null,null,null,null,null,null,"To enable the Get Me Started promotion please enter \"1\"  - no other number should be inserted in this part below"]
[null,{"$f":"+IF($B$15=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B4),'Price List'!B4,\"\")","v":"    Dynamics 365 Business Central Essential"},null,{"$f":"+'Price List'!C4","v":"BC-D365-SAAS-E"},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B4),FALSE)","v":84},null,{"$f":"G16*B16*(1-0.15)","v":0},"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$15=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B5),'Price List'!B5,\"\")","v":"    Dynamics 365 Business Central Premium"},null,{"$f":"+'Price List'!C5","v":"BC-D365-SAAS-P"},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B5),FALSE)","v":120},null,{"$f":"G17*B17*(1-0.15)","v":0},"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$15=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B30),'Price List'!B30,\"\")","v":"     LS Central Base - Per Full User"},null,{"$f":"'Price List'!C30","v":"BC-D365-SAAS-BASE"},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B30),FALSE)","v":36},null,{"$f":"G18*B18*(1-0.15)","v":0},"If customer needs additional LS Central Base - Per full user please add them below",null,null,null,null,null,""]
[null,0,{"$f":"\"    \"&IF(ISTEXT('Price List'!B42),'Price List'!B42,\"\")","v":"    Device SAL for Retail & Hospitality"},null,{"$f":"'Price List'!C42","v":"BC-D365-SAAS-POS"},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B42),FALSE)","v":102},null,{"$f":"G19*B19*(1-0.15)","v":0},"If customer needs additional Retail Device SAL for Retail & Hospitality please add them below"]
[]
[null,{"$f":"SUM(B15,B22:B23)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B3),'Price List'!B3,\"\")","v":"    ERP Users"},"","",null,"",null,"",""]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B11),'Price List'!B11,\"\")","v":"   Dynamics 365 Business Central Essential"},{"$f":"'Price List'!C11","v":"BC-D365-SAAS-E"},{"$f":"'Price List'!C11","v":"BC-D365-SAAS-E"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G22/10,G22*1.2),IF(C$4=\"Monthly\",G22/12,G22))","v":84},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B11),FALSE)","v":840},null,{"$f":"+B22*F22","v":0},"You cannot mix and match Essential and Premium Users, Includes 2 GB database capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B12),'Price List'!B12,\"\")","v":"   Dynamics 365 Business Central Premium"},{"$f":"IF('Price List'!C42,'Price List'!C42,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C12","v":"BC-D365-SAAS-P"},120,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B12),FALSE)","v":1200},null,{"$f":"+B23*G23","v":0},"You cannot mix and match Essential and Premium Users, Includes 3 GB database capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B13),'Price List'!B13,\"\")","v":"   Dynamics 365 Business Central Team Member"},{"$f":"IF('Price List'!C5,'Price List'!C5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C13","v":"BC-D365-SAAS-TM"},9.6,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B13),FALSE)","v":96},null,0,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B14),'Price List'!B14,\"\")","v":"   Dynamics 365 Business Central External Accountant"},{"$f":"IF('Price List'!C43,'Price List'!C43,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C14","v":"BC-D365-SAAS-EA"},0,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B14),FALSE)","v":0},null,0,"One included per tenant"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B15),'Price List'!B15,\"\")","v":"   Dynamics 365 Business Central Sales Professional attach"},null,{"$f":"'Price List'!C15","v":"BC-D365-SAAS-SPA"},24,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B15),FALSE)","v":240},null,{"$f":"+B26*G26","v":0},"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to."]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B16),'Price List'!B16,\"\")","v":"   Dynamics 365 Business Central Customer Service Professional attach"},null,{"$f":"'Price List'!C16","v":"BC-D365-SAAS-CSPA"},24,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B16),FALSE)","v":240},null,{"$f":"+B27*G27","v":0},"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to."]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B18),'Price List'!B18,\"\")","v":"    Other Modules"},"","",null,"",null,"",""]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B24),'Price List'!B24,\"\")","v":"   Dynamics 365 Business Central Database Capacity"},null,{"$f":"'Price List'!C24","v":"BC-D365-SAAS-CDC"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G29/10,G29*1.2),IF(C$4=\"Monthly\",G29/12,G29))","v":12},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B24),FALSE)","v":120},null,{"$f":"+B29*F29","v":0},"Additional Database Capacity is sold per GB"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B25),'Price List'!B25,\"\")","v":"   Dynamics 365 Business Central Database Capacity Additional 100 GB"},null,{"$f":"'Price List'!C25","v":"BC-D365-SAAS-CDCA"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G30/10,G30*1.2),IF(C$4=\"Monthly\",G30/12,G30))","v":600},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B25),FALSE)","v":6000},null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B26),'Price List'!B26,\"\")","v":"   Dynamics 365 Business Central Database Capacity Overage"},null,{"$f":"'Price List'!C26","v":"BC-D365-SAAS-CDCO"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G31/10,G31*1.2),IF(C$4=\"Monthly\",G31/12,G31))","v":6},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B26),FALSE)","v":60},null,0,"Pre-requirement is Business Central Database Capacity Additional 100 GB"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B27),'Price List'!B27,\"\")","v":"   Dynamics 365 Business Central Additional Environment Addon*"},null,{"$f":"'Price List'!C27","v":"BC-D365-SAAS-CAE"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G32/10,G32*1.2),IF(C$4=\"Monthly\",G32/12,G32))","v":360},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B27),FALSE)","v":3600},null,0,"Please indicate the country where the Additional Environment will be setup; \n*Additional Environments can only be setup in countries where LS Central SaaS clusters are running"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B29),'Price List'!B29,\"\")","v":"   Base"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B15=1,\"Promo Discount:\",\"\")","v":""}]
[null,{"$f":"B21","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B32),'Price List'!B32,\"\")","v":"    LS Central Base - Per Full User"},{"$f":"IF('Price List'!C56,'Price List'!C56,\"\")","v":""},{"$f":"'Price List'!C32","v":"BC-D365-SAAS-BASE"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G34/10,G34*1.2),IF(C$4=\"Monthly\",G34/12,G34))","v":36},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B32),FALSE)","v":360},null,{"$f":"+B34*F34","v":0},"LS Central Base - Per Full User (Essential or Premium) is a prerequisite for Retail Devices"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B31),'Price List'!B31,\"\")","v":"    Yearly"},{"$f":"IF('Price List'!C7,'Price List'!C7,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C31","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B33),'Price List'!B33,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C33","v":0}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B34),'Price List'!B34,\"\")","v":"   Stores"},null,null,null,null,null,null,"It is not permitted to have both Online Store and Offline Store, either all Online or all Offline"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B38),'Price List'!B38,\"\")","v":"   Online Store"},null,{"$f":"'Price List'!C38","v":"BC-D365-SAAS-STOREON"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G38/10,G38*1.2),IF(C$4=\"Monthly\",G38/12,G38))","v":0},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B38),FALSE)","v":0},null,{"$f":"+B38*F38","v":0},"Does not include a Device or a DD license. Qty should be equal to total Number of stores in the customer license"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B39),'Price List'!B39,\"\")","v":"   Offline Store"},null,{"$f":"'Price List'!C39","v":"BC-D365-SAAS-STOREOFF"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G39/10,G39*1.2),IF(C$4=\"Monthly\",G39/12,G39))","v":6},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B39),FALSE)","v":60},null,0,"Includes a DD license but does not include a Device. Qty should be equal to total Number of stores in the customer license"]
[null,{"$f":"SUM(B41:B45)","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B41),'Price List'!B41,\"\")","v":"   Devices"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B15=1,\"Promo Discount:\",\"\")","v":""}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B42),'Price List'!B49,\"\")","v":"   Device SAL for Retail & Hospitality"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C49","v":"BC-D365-SAAS-POS"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G41/10,G41*1.2),IF(C$4=\"Monthly\",G41/12,G41))","v":102},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B49),FALSE)","v":1020},null,{"$f":"+B41*F41","v":0},"Stationary POS, LS Central POS (web version), back office device, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B43),'Price List'!B50,\"\")","v":"   Device SAL for Mobile POS App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C50","v":"BC-D365-SAAS-MPOS"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G42/10,G42*1.2),IF(C$4=\"Monthly\",G42/12,G42))","v":102},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B50),FALSE)","v":1020},null,0,"For retail, for Android devices, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B44),'Price List'!B51,\"\")","v":"   Device SAL for Mobile Inventory App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C51","v":"BC-D365-SAAS-MI"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G43/10,G43*1.2),IF(C$4=\"Monthly\",G43/12,G43))","v":102},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B51),FALSE)","v":1020},null,0,"For retail, for Android devices, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B45),'Price List'!B52,\"\")","v":"   Device SAL for Kitchen Display Server"},null,{"$f":"'Price List'!C52","v":"BC-D365-SAAS-KDS"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G44/10,G44*1.2),IF(C$4=\"Monthly\",G44/12,G44))","v":102},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B52),FALSE)","v":1020},null,0,"Includes 1GB Database Capacity"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B46),'Price List'!B53,\"\")","v":"   Device SAL for Back Office "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C53","v":"BC-D365-SAAS-BACK"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G45/10,G45*1.2),IF(C$4=\"Monthly\",G45/12,G45))","v":102},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B53),FALSE)","v":1020},null,0,"For Back Office only and no customer facing transactions, Includes 1GB Database Capacity"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B57),'Price List'!B57,\"\")","v":"    Office 365 Business Premium"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C57","v":"BC-D365-SAAS-O365BP"}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B58),'Price List'!B58,\"\")","v":"    Power BI Pro"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C58","v":"BC-D365-SaaS-PBP"}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B62),'Price List'!B62,\"\")","v":"   LS Central Modules"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C62","v":""},null,null,null,null," LS Central Base - Per Full User is prerequisite for all below modules",null,null,null,null,null,null," "]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B89),'Price List'!B89,\"\")","v":"    Hotels - per Property"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C89","v":"BC-D365-SAAS-HOTEL-P"},{"$f":"IF(C$3=\"Monthly\",IF(C$4=\"Monthly\",G49/10,G49*1.2),IF(C$4=\"Monthly\",G49/12,G49))","v":163.19999999999999},{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B89),FALSE)","v":1632},null,{"$f":"+B49*F49","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B90),'Price List'!B90,\"\")","v":"    Hotels - per Room"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C90","v":"BC-D365-SAAS-HOTEL-R"},8.4,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B90),FALSE)","v":84},null,0,"LS Central for hotels - per Property is prerequisite"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B91),'Price List'!B91,\"\")","v":"    Hotels - per Power App User"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C91","v":"BC-D365-SAAS-HOTEL-PAU"},18,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B91),FALSE)","v":180},null,0,"LS Central for hotels - per Property is prerequisite"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B92),'Price List'!B92,\"\")","v":"    Bookings - per Location"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C92","v":"BC-D365-SAAS-BPL"},18,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B92),FALSE)","v":180},null,0,"LS Activity - per Location is prerequisitefor LS Activity - per Device"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B93),'Price List'!B93,\"\")","v":"    Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C93","v":"BC-D365-SAAS-BPOS"},14.4,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B93),FALSE)","v":144},null,0,"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality, for Mobile POS App and Back Office in the customer license "]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B94),'Price List'!B94,\"\")","v":"    Staff Management - per Employee"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C94","v":"BC-D365-SAAS-SPE"},2.4,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B94),FALSE)","v":24},null,0,"Per all Employees in the LSC Staff Employee Table"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B95),'Price List'!B95,\"\")","v":"    LS Pay - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C95","v":"BC-D365-SAAS-PAY"},12,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B95),FALSE)","v":120},null,0,"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality and Retail Device CALs for Mobile POS App in the customer license"]
[null,null,"LS eCommerce Base - Please select a Framework",{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C56,'Price List'!B100:C103,2,FALSE)","v":{"$error":"#N/A"}},163.19999999999999,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B100),FALSE)","v":1632},null,0,"LS eCommerce Base is a prerequisite for LS eCommerce per Device"]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B104),'Price List'!B104,\"\")","v":"   eCommerce per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C104","v":"BC-D365-SAAS-EPOS"},3.6,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$I$132,ROW('Price List'!B104),FALSE)","v":36},{"$f":"IF(B57<10,0,VLOOKUP(B57,$L$100:$M$106,2,1))","v":0},0,"Qty must be equal to total number of Retail Device CALs for Retail & Hospitality and Retail Device CALs for Mobile POS App in the customer license"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!#REF!),'Price List'!#REF!,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"(+B58*G58)*0.5","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B81),'Price List'!B81,\"\")","v":"    LS Central Additional Language Layer"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C81","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B69),'Price List'!B69,\"\")","v":"    Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C69","v":"BC-D365-SAAS-APOS"},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B69),FALSE)","v":12},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B107),'Price List'!B107,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C107","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B107),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B108),'Price List'!B108,\"\")","v":"     "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C108","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B108),FALSE)","v":500},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B109),'Price List'!B109,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C109","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B109),FALSE)","v":40},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B110),'Price List'!B110,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C110","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B110),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B111),'Price List'!B111,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C111","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B111),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B112),'Price List'!B112,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C112","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B112),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B113),'Price List'!B113,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C113","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B113),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B114),'Price List'!B114,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C114","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B114),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B115),'Price List'!B115,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C115","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B115),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B116),'Price List'!B116,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C116","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B116),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B117),'Price List'!B117,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C117","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B117),FALSE)","v":0},null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B118),'Price List'!B118,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C118","v":0},null,{"$f":"HLOOKUP($C$5,'Price List'!$B$1:$G$132,ROW('Price List'!B118),FALSE)","v":0},null,0]
[null,null,"","Total Solution Cost (TSC)",null,null,null,null,{"$f":"SUM(I22:I45,I49:I57)","v":0},""]
[null,null,"","","",null,"",null,"",""]
[null,"Please find information about ongoing promos on our Partner Portal"]
[null,"Click here for more details about products in the Price List"]
[null,"Information on country availability can be found on LS Retail Portal"]
[]
[null,"This document is intended for general information purposes only, and we have taken due care in its preparation. All embedded functionality used to facilitate price calculations is provided AS IS. Any risk arising from the use of the information shall rest with the recipient and nothing herein shall be construed as constituting any kind of warranty or representation, express, implied or statutory.  Users are responsible for information that is input using the pricing calculator embedded in the offline pricelist.  Under certain circumstances the figures resulting from the applied pricing calculations embedded in the price list, which are shown for your convenience in this pricelist, may differ from those reflected in the Order Summary Page in Order Central. In these scenarios, the figures shown in the Order Summary Page will control."]
[]
[null,"For information on the availability of EFT connections for the mobile and the stationary LS Central Points of Sale, contact licenses@lsretail.com"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Qty Discount Scheme"]
[null,null,null,null,null,null,null,null,null,null,null,"Qty","Extra Discount "]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,9,0]
[null,null,null,null,null,null,null,null,null,null,null,10,0.05]
[null,null,null,null,null,null,null,null,null,null,null,25,0.1]
[null,null,null,null,null,null,null,null,null,null,null,50,0.15]
[null,null,null,null,null,null,null,null,null,null,null,100,0.2]
[null,null,null,null,null,null,null,null,null,null,null,250,0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"BTC2 Computation","index":3,"n_rows":104,"n_cols":29,"rows_kept":104,"cut":false,"hidden":false,"merged":[[2,26,2,27],[4,5,4,8],[69,10,69,16],[96,1,96,16],[97,1,97,16],[55,10,55,16],[56,10,56,16],[57,10,57,16],[58,10,58,16],[59,10,59,16],[52,10,52,16],[53,10,53,16],[41,10,41,16],[42,10,42,16],[43,10,43,16],[44,10,44,16],[63,10,63,16],[66,10,66,16],[76,10,76,16],[70,10,70,16],[71,10,71,16],[72,10,72,16],[73,10,73,16],[74,10,74,16],[75,10,75,16],[67,10,67,16],[48,10,48,16],[28,10,28,16],[27,10,27,16],[102,1,102,10],[77,10,77,16],[78,10,78,16],[79,10,79,16],[80,10,80,16],[94,10,94,16],[95,1,95,10],[100,1,100,10],[98,1,98,16],[65,10,65,16],[64,10,64,16],[60,10,60,16],[68,10,68,16],[54,10,54,16],[40,10,40,16],[29,10,29,16],[30,10,30,16],[31,10,31,16],[32,10,32,16],[33,10,33,16],[34,10,34,16],[35,10,35,16],[36,10,36,16],[37,10,37,16],[38,10,38,16],[39,10,39,16],[46,10,46,16],[45,10,45,16],[47,10,47,16]]}
["LS Retail Confidential"]
[]
["Bridge to the Cloud 2",null,{"$f":"IF(F5=\"Before September 1, 2022\",(IF(AND(C16>0,C22>0),IF(AND(T16>=0,T21>=0),\"ELIGIBLE FOR BTC2\",\"NOT ELIGIBLE FOR BTC2\"),\"INCOMPLETE DETAILS\")),\"NOT ELIGIBLE\")","v":"INCOMPLETE DETAILS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Users?",{"$f":"IF(AND(Z6=\"YES\",U6=\"ELIGIBLE\"),ROUNDDOWN(IF(B38>0,(U4/S38),(U4/S37)),0),\"NOT ELIGIBLE\")","v":"NOT ELIGIBLE"},null,{"$f":"IF(OR(AA3<0,AA3=\"NOT ELIGIBLE\"),\"*\",\"*estimated number of free users\")","v":"*"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 Months EP",{"$f":"I22/12*2","v":0}]
["On-premise Perpetual License First Registration Date:",null,null,null,null,"Before September 1, 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Month NCE cost",{"$f":"(T28)","v":0},null,null,null,null,"Does the license have or has previously licensed concurrent users?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U5>U4,\"ELIGIBLE\",\"NOT ELIGIBLE\")","v":"NOT ELIGIBLE"},null,null,null,null,"Yes"]
[null,"Subscription Term:","Triennial"]
[null,"Mode of Billing:","Monthly"]
[null,{"$f":"\"Currency:\"","v":"Currency:"},{"$f":"VLOOKUP(C12,V15:W24,2,FALSE)","v":"USD"},null,null,null,null,"Partner discount Subscription/SaaS:"]
[]
["Customer License Value from Business Hub",null,null,null,null,null,null,null,"Currency Equivalent to:"]
[null,"PLP Currency:","USD",null,null,null,null,null,{"$f":"C9","v":"USD"}]
[null,"PLP LSR:",null,null,null,null,null,null,{"$f":"IF($C$12=$I$12,C13,(C13*(VLOOKUP($C$12,$V$21:$X$24,3,FALSE))))","v":0}]
[null,"SQL amount:",null,null,null,null,null,null,{"$f":"IF($C$12=$I$12,C14,(C14*(VLOOKUP($C$12,$V$21:$X$24,3,FALSE))))","v":0}]
[null,"Total PLP:",{"$f":"+C14+C13","v":0},null,null,null,null,null,{"$f":"+I14+I13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AUD","AUD"]
[null,"Enhancement @ 18%",{"$f":"IF(C14=0,(C13*0.18),((C13*0.18)+(C14*0.2)))","v":0},null,null,null,null,null,{"$f":"IF(I14=0,(I13*0.18),((I13*0.18)+(I14*0.2)))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"(J27*12)-I16","v":0},null,"CAD","CAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR","EUR"]
["License Value from MS PSBC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GBP","GBP"]
[null,"PLP MS:",null,null,null,null,null,null,{"$f":"IF($C$12=$I$12,C19,(C19*(VLOOKUP($C$12,$V$21:$X$24,3,FALSE))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"NZD","NZD"]
[null,"SQL amount:",null,null,null,null,null,null,{"$f":"IF($C$12=$I$12,C20,(C20*(VLOOKUP($C$12,$V$21:$X$24,3,FALSE))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"USD","USD"]
[null,"Total PLP:",{"$f":"+C20+C19","v":0},null,null,null,null,null,{"$f":"+I20+I19","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"(T28*12)-I22","v":0},null,"DKK","EUR",0.13420000000000001]
[null,"Enhancement @ 18%",{"$f":"IF(C20=0,(C19*0.18),((C19*0.18)+(C20*0.2)))","v":0},null,null,null,null,null,{"$f":"IF(I20=0,(I19*0.18),((I19*0.18)+(I20*0.2)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"NOK","EUR",8.7569999999999995E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEK","EUR",8.9520000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INR","USD",{"$f":"0.01112/X25","v":1.2062045775029829E-2}]
[null,null,null,null,null,null,null,null,null,{"$f":"$C$9","v":"USD"},null,null,null,null,null,null,null,null,null,null,null,null,null,0.92190000000000005]
[null,null,null,null,null,null,null,null,"Monthly Partner Price with 15% margin",{"$f":"J27*0.85","v":0}]
[null,null,null,null,null,null,null,null,"Monthly Customer Cost with BTC2",{"$f":"J95","v":0},{"$f":"Factor!P2","v":"USD"}]
[null,"Qty","Modules","Granule ID","SKU","Current Pricelist Prices",{"$f":"Factor!P2&\" Yearly\"","v":"USD Yearly"},null,"BTC2 Prices","Total ","Prerequisites/Notes: \nMinimum order 1 Essential or Premium User and 1 LS Central Base - Per Full User, 1 Store and 1 LS Retail Device SAL",null,null,null,null,null,null,null,"MS Price",{"$f":"SUM(T37:T61)","v":0}]
[null,null,"Promotion",null,null,null,null,null,null,null,"The modules listed here are only the Get Me Started promotion modules - if you need to add more modules please add them in the price list below"]
[null,null,"Get me Started",null,null,null,null,null,null,null,"To enable the Get Me Started promotion please enter \"1\"  - no other number should be inserted in this part below"]
[null,{"$f":"+IF($B$30=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B4),'Price List'!B4,\"\")","v":"    Dynamics 365 Business Central Essential"},null,{"$f":"+'Price List'!C4","v":"BC-D365-SAAS-E"},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B4),FALSE)","v":84},null,null,{"$f":"G31*B31*(1-0.15)","v":0},"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$30=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B5),'Price List'!B5,\"\")","v":"    Dynamics 365 Business Central Premium"},null,{"$f":"+'Price List'!C5","v":"BC-D365-SAAS-P"},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B5),FALSE)","v":120},null,null,{"$f":"G32*B32*(1-0.15)","v":0},"You cannot mix and match Essential and Premium Users select either one and if customer needs more please add them below"]
[null,{"$f":"+IF($B$30=1,1,0)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B30),'Price List'!B30,\"\")","v":"     LS Central Base - Per Full User"},null,{"$f":"'Price List'!C30","v":"BC-D365-SAAS-BASE"},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B30),FALSE)","v":36},null,null,{"$f":"G33*B33*(1-0.15)","v":0},"If customer needs additional LS Central Base - Per full user please add them below",null,null,null,null,null,""]
[null,0,{"$f":"\"    \"&IF(ISTEXT('Price List'!B42),'Price List'!B42,\"\")","v":"    Device SAL for Retail & Hospitality"},null,{"$f":"'Price List'!C42","v":"BC-D365-SAAS-POS"},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B42),FALSE)","v":102},null,null,{"$f":"G34*B34*(1-0.15)","v":0},"If customer needs additional Retail Device SAL for Retail & Hospitality please add them below"]
[]
[null,{"$f":"SUM(B30,B37:B38)","v":0},{"$f":"\"    \"&IF(ISTEXT('Price List'!B3),'Price List'!B3,\"\")","v":"    ERP Users"},"","",null,"",null,null,"",""]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B11),'Price List'!B11,\"\")","v":"   Dynamics 365 Business Central Essential"},{"$f":"'Price List'!C11","v":"BC-D365-SAAS-E"},{"$f":"'Price List'!C11","v":"BC-D365-SAAS-E"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G37/10,G37*1.2),IF(C$8=\"Monthly\",G37/12,G37))","v":70},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B11),FALSE)","v":840},null,{"$f":"F37*0.6","v":42},{"$f":"+B37*I37","v":0},"You cannot mix and match Essential and Premium Users, Includes 2 GB database capacity",null,null,null,null,null,null,null,{"$f":"I37","v":42},{"$f":"S37*B37","v":0}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B12),'Price List'!B12,\"\")","v":"   Dynamics 365 Business Central Premium"},{"$f":"IF('Price List'!C42,'Price List'!C42,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C12","v":"BC-D365-SAAS-P"},100,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B12),FALSE)","v":1200},null,{"$f":"F38*0.6","v":60},{"$f":"+B38*I38","v":0},"You cannot mix and match Essential and Premium Users, Includes 3 GB database capacity",null,null,null,null,null,null,null,{"$f":"I38","v":60},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B13),'Price List'!B13,\"\")","v":"   Dynamics 365 Business Central Team Member"},{"$f":"IF('Price List'!C5,'Price List'!C5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C13","v":"BC-D365-SAAS-TM"},8,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B13),FALSE)","v":96},null,{"$f":"F39*0.6","v":4.8},{"$f":"+B39*I39","v":0},null,null,null,null,null,null,null,null,{"$f":"I39","v":4.8},0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B14),'Price List'!B14,\"\")","v":"   Dynamics 365 Business Central External Accountant"},{"$f":"IF('Price List'!C43,'Price List'!C43,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C14","v":"BC-D365-SAAS-EA"},0,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B14),FALSE)","v":0},null,null,{"$f":"+B40*F40","v":0},"One included per tenant",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B15),'Price List'!B15,\"\")","v":"   Dynamics 365 Business Central Sales Professional attach"},null,{"$f":"'Price List'!C15","v":"BC-D365-SAAS-SPA"},20,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B15),FALSE)","v":240},null,null,{"$f":"+B41*F41","v":0},"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to.",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B16),'Price List'!B16,\"\")","v":"   Dynamics 365 Business Central Customer Service Professional attach"},null,{"$f":"'Price List'!C16","v":"BC-D365-SAAS-CSPA"},20,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B16),FALSE)","v":240},null,null,{"$f":"+B42*F42","v":0},"This module can be attached to a Essential or Premium user, You have to own an Essential or Premium user to attach this module to.",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B18),'Price List'!B18,\"\")","v":"    Other Modules"},"","",null,"",null,null,"","",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B24),'Price List'!B24,\"\")","v":"   Dynamics 365 Business Central Database Capacity"},null,{"$f":"'Price List'!C24","v":"BC-D365-SAAS-CDC"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G44/10,G44*1.2),IF(C$8=\"Monthly\",G44/12,G44))","v":10},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B24),FALSE)","v":120},null,null,{"$f":"+B44*F44","v":0},"Additional Database Capacity is sold per GB",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B25),'Price List'!B25,\"\")","v":"   Dynamics 365 Business Central Database Capacity Additional 100 GB"},null,{"$f":"'Price List'!C25","v":"BC-D365-SAAS-CDCA"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G45/10,G45*1.2),IF(C$8=\"Monthly\",G45/12,G45))","v":500},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B25),FALSE)","v":6000},null,null,{"$f":"+B45*F45","v":0},null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B26),'Price List'!B26,\"\")","v":"   Dynamics 365 Business Central Database Capacity Overage"},null,{"$f":"'Price List'!C26","v":"BC-D365-SAAS-CDCO"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G46/10,G46*1.2),IF(C$8=\"Monthly\",G46/12,G46))","v":5},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B26),FALSE)","v":60},null,null,{"$f":"+B46*F46","v":0},"Pre-requirement is Business Central Database Capacity Additional 100 GB",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B27),'Price List'!B27,\"\")","v":"   Dynamics 365 Business Central Additional Environment Addon*"},null,{"$f":"'Price List'!C27","v":"BC-D365-SAAS-CAE"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G47/10,G47*1.2),IF(C$8=\"Monthly\",G47/12,G47))","v":300},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B27),FALSE)","v":3600},null,null,{"$f":"+B47*F47","v":0},"Please indicate the country where the Additional Environment will be setup; \n*Additional Environments can only be setup in countries where LS Central SaaS clusters are running",null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B29),'Price List'!B29,\"\")","v":"   Base"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B30=1,\"Promo Discount:\",\"\")","v":""}]
[null,{"$f":"+B37+B38","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B32),'Price List'!B32,\"\")","v":"    LS Central Base - Per Full User"},{"$f":"IF('Price List'!C56,'Price List'!C56,\"\")","v":""},{"$f":"'Price List'!C32","v":"BC-D365-SAAS-BASE"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G49/10,G49*1.2),IF(C$8=\"Monthly\",G49/12,G49))","v":30},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B32),FALSE)","v":360},null,{"$f":"F49*0.6","v":18},{"$f":"+B49*I49","v":0},"LS Central Base - Per Full User (Essential or Premium) is a prerequisite for Retail Devices",null,null,null,null,null,null,null,0,{"$f":"S49*B49","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B31),'Price List'!B31,\"\")","v":"    Yearly"},{"$f":"IF('Price List'!C7,'Price List'!C7,\"\")","v":{"$error":"#VALUE!"}},{"$f":"'Price List'!C31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S50*B50","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B33),'Price List'!B33,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S51*B51","v":0}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B34),'Price List'!B34,\"\")","v":"   Stores"}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B38),'Price List'!B38,\"\")","v":"   Online Store"},null,{"$f":"'Price List'!C38","v":"BC-D365-SAAS-STOREON"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G53/10,G53*1.2),IF(C$8=\"Monthly\",G53/12,G53))","v":0},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B38),FALSE)","v":0},null,{"$f":"F53*0.6","v":0},{"$f":"+B53*I53","v":0},"Does not include a Device or a DD license. Total quantity of the purchased store modules should be equal to the actual number of customer's stores",null,null,null,null,null,null,null,0,{"$f":"S53*B53","v":0}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B39),'Price List'!B39,\"\")","v":"   Offline Store"},null,{"$f":"'Price List'!C39","v":"BC-D365-SAAS-STOREOFF"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G54/10,G54*1.2),IF(C$8=\"Monthly\",G54/12,G54))","v":5},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B39),FALSE)","v":60},null,3,{"$f":"+B54*I54","v":0},"Includes a DD license but does not include a Device. Total quantity of the purchased store modules should be equal to the actual number of customer's stores",null,null,null,null,null,null,null,0,{"$f":"S54*B54","v":0}]
[null,{"$f":"SUM(B56:B60)","v":0},{"$f":"\"   \"&IF(ISTEXT('Price List'!B41),'Price List'!B41,\"\")","v":"   Devices"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(B30=1,\"Promo Discount:\",\"\")","v":""}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B42),'Price List'!B49,\"\")","v":"   Device SAL for Retail & Hospitality"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C49","v":"BC-D365-SAAS-POS"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G56/10,G56*1.2),IF(C$8=\"Monthly\",G56/12,G56))","v":85},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B49),FALSE)","v":1020},null,{"$f":"F56*0.6","v":51},{"$f":"+B56*I56","v":0},"Stationary POS, LS Central POS (web version), back office device, Includes 1GB Database Capacity",null,null,null,null,null,null,null,{"$f":"VLOOKUP($J$25,$V$56:$Y$61,4,FALSE)","v":24},{"$f":"S56*B56","v":0},null,"USD",null,40,{"$f":"X56*0.6","v":24}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B43),'Price List'!B50,\"\")","v":"   Device SAL for Mobile POS App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C50","v":"BC-D365-SAAS-MPOS"},85,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B50),FALSE)","v":1020},null,51,0,"For retail, for Android devices, Includes 1GB Database Capacity",null,null,null,null,null,null,null,24,0,null,"CAD",1.3568,{"$f":"+X$56*W57","v":54.271999999999998},{"$f":"X57*0.6","v":32.563199999999995}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B44),'Price List'!B51,\"\")","v":"   Device SAL for Mobile Inventory App"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C51","v":"BC-D365-SAAS-MI"},85,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B51),FALSE)","v":1020},null,51,0,"For retail, for Android devices, Includes 1GB Database Capacity",null,null,null,null,null,null,null,24,0,null,"EUR",{"$f":"0.85*1.11","v":0.94350000000000001},{"$f":"+X$56*W58","v":37.74},22.644000000000002]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B45),'Price List'!B52,\"\")","v":"   Device SAL for Kitchen Display Server"},null,{"$f":"'Price List'!C52","v":"BC-D365-SAAS-KDS"},85,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B52),FALSE)","v":1020},null,51,0,"Includes 1GB Database Capacity",null,null,null,null,null,null,null,24,0,null,"GBP",{"$f":"0.76*1.09","v":0.82840000000000003},{"$f":"+X$56*W59","v":33.136000000000003},19.881600000000002]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B46),'Price List'!B53,\"\")","v":"   Device SAL for Back Office "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C53","v":"BC-D365-SAAS-BACK"},85,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B53),FALSE)","v":1020},null,51,0,"For Back Office only and no customer facing transactions, Includes 1GB Database Capacity",null,null,null,null,null,null,null,24,0,null,"AUD",1.4965700000000002,{"$f":"+X$56*W60","v":59.862800000000007},35.917680000000004]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B47),'Price List'!B54,\"\")","v":"   Self Checkout Connector Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C54","v":"BC-D365-SAAS-SCC"},85,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B54),FALSE)","v":1020},null,51,0,null,null,null,null,null,null,null,null,24,0,null,"NZD",1.6264000000000001,{"$f":"+X$56*W61","v":65.055999999999997},39.0336]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B57),'Price List'!B57,\"\")","v":"    Office 365 Business Premium"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C57","v":"BC-D365-SAAS-O365BP"}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B58),'Price List'!B58,\"\")","v":"    Power BI Pro"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C58","v":"BC-D365-SaaS-PBP"}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B62),'Price List'!B62,\"\")","v":"   LS Central Modules"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C62","v":""},null,null,null,null,null," LS Central Base - Per Full User is prerequisite for all below modules",null,null,null,null,null,null," "]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B83),'Price List'!B83,\"\")","v":"    Scan Pay Go - per Usage"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C83","v":"BC-D365-SAAS-SPG"},0.01,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B83),FALSE)","v":0.01},null,{"$f":"F65*0.6","v":6.0000000000000001E-3},{"$f":"+B65*I65","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B84),'Price List'!B84,\"\")","v":"    Analytics"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C84","v":"BC-D365-SAAS-ANALYTI"},{"$f":"IF(C$7=\"Monthly\",IF(C$8=\"Monthly\",G66/10,G66*1.2),IF(C$8=\"Monthly\",G66/12,G66))","v":0},{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B84),FALSE)","v":0},null,0,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B85),'Price List'!B85,\"\")","v":"    Pharmacies Base - W1"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C85","v":"BC-D365-SAAS-PHBW1"},500,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B85),FALSE)","v":6000},null,300,0,"Pharmacies Base - W1 localization lonely. Pharmacies Base is the prerequisite for Pharmacies per Device"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B86),'Price List'!B86,\"\")","v":"    Pharmacies per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C86","v":"BC-D365-SAAS-PHDW1"},40,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B86),FALSE)","v":480},null,24,0,"Qty must be equal to total number of Device CALs for Retail & Hospitality and Device CALs for Mobile in the customer license"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B87),'Price List'!B87,\"\")","v":"    Forecourt base"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C87","v":"BC-D365-SAAS-FCB"},136,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B87),FALSE)","v":1632},null,81.599999999999994,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B88),'Price List'!B88,\"\")","v":"    Forecourt per device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C88","v":"BC-D365-SAAS-FCD"},17.7,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B88),FALSE)","v":212.4},null,10.62,0,"Forecourt Base is prerequisite. Only for those Retail Devices utilizing the Forecourt Controller interface"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B89),'Price List'!B89,\"\")","v":"    Hotels - per Property"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C89","v":"BC-D365-SAAS-HOTEL-P"},136,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B89),FALSE)","v":1632},null,81.599999999999994,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B90),'Price List'!B90,\"\")","v":"    Hotels - per Room"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C90","v":"BC-D365-SAAS-HOTEL-R"},7,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B90),FALSE)","v":84},null,4.2,0,"Hotels - per Property is prerequisite"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B91),'Price List'!B91,\"\")","v":"    Hotels - per Power App User"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C91","v":"BC-D365-SAAS-HOTEL-PAU"},15,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B91),FALSE)","v":180},null,9,0,"Hotels - per Property is prerequisite"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B92),'Price List'!B92,\"\")","v":"    Bookings - per Location"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C92","v":"BC-D365-SAAS-BPL"},15,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B92),FALSE)","v":180},null,9,0,"Bookings - per Location is prerequisitefor Bookings - per Device"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B93),'Price List'!B93,\"\")","v":"    Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C93","v":"BC-D365-SAAS-BPOS"},12,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B93),FALSE)","v":144},null,7.1999999999999993,0,"Qty must be equal to total number of Device CALs for Retail & Hospitality, for Mobile POS App and Back Office in the customer license "]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B94),'Price List'!B94,\"\")","v":"    Staff Management - per Employee"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C94","v":"BC-D365-SAAS-SPE"},2,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B94),FALSE)","v":24},null,1.2,0,"Per all Employees in the LSC Staff Employee Table"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B95),'Price List'!B95,\"\")","v":"    LS Pay - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C95","v":"BC-D365-SAAS-PAY"},10,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B95),FALSE)","v":120},null,6,0,"Qty must be equal to total number of Device CALs for Retail & Hospitality and Device CALs for Mobile POS App in the customer license"]
[null,null,"eCommerce Base - Please select a Framework",{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C78,'Price List'!B100:C103,2,FALSE)","v":"BC-D365-SAAS-E3RD"},136,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B100),FALSE)","v":1632},null,81.599999999999994,0,{"$f":"IF(C78=\"eCommerce Base - Shopify*\",\"eCommerce Base is a prerequisite for eCommerce per Device. *Shopify is only available for version 24 and newer\",\"eCommerce Base is a prerequisite for eCommerce per Device\")","v":"eCommerce Base is a prerequisite for eCommerce per Device"}]
[null,null,{"$f":"\"   \"&IF(ISTEXT('Price List'!B104),'Price List'!B104,\"\")","v":"   eCommerce per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C104","v":"BC-D365-SAAS-EPOS"},3,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$I$132,ROW('Price List'!B104),FALSE)","v":36},{"$f":"IF(B79<10,0,VLOOKUP(B79,$M$121:$N$127,2,1))","v":0},1.7999999999999998,0,"Qty must be equal to total number of Device CALs for Retail & Hospitality and Device CALs for Mobile POS App in the customer license"]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!#REF!),'Price List'!#REF!,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"(+B80*G80)*0.5","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B81),'Price List'!B81,\"\")","v":"    LS Central Additional Language Layer"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C81","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B69),'Price List'!B69,\"\")","v":"    Bookings - per Device"},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C69","v":"BC-D365-SAAS-APOS"},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B69),FALSE)","v":12},null,null,{"$f":"+B82*G82","v":0}]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B107),'Price List'!B107,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C107","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B107),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B108),'Price List'!B108,\"\")","v":"     "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C108","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B108),FALSE)","v":500},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B109),'Price List'!B109,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C109","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B109),FALSE)","v":40},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B110),'Price List'!B110,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C110","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B110),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B111),'Price List'!B111,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C111","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B111),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B112),'Price List'!B112,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C112","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B112),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B113),'Price List'!B113,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C113","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B113),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B114),'Price List'!B114,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C114","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B114),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B115),'Price List'!B115,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C115","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B115),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B116),'Price List'!B116,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C116","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B116),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B117),'Price List'!B117,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C117","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B117),FALSE)","v":0},null,null,0]
[null,null,{"$f":"\"    \"&IF(ISTEXT('Price List'!B118),'Price List'!B118,\"\")","v":"    "},{"$f":"IF('Price List'!#REF!,'Price List'!#REF!,\"\")","v":{"$error":"#REF!"}},{"$f":"'Price List'!C118","v":0},null,{"$f":"HLOOKUP($C$9,'Price List'!$B$1:$G$132,ROW('Price List'!B118),FALSE)","v":0},null,null,0]
[null,null,"",null,null,null,null,null,"Total Solution Cost (TSC)",{"$f":"SUM(J37:J63,J65:J79)","v":0},""]
[null,"This sheet is intended for general information purposes only, and is provided AS IS. Any risk arising from the use of the information shall rest with the recipient and nothing herein shall be construed as constituting any kind of warranty or representation, express, implied or statutory.  Users are responsible for information that is input using the pricing calculator embedded in this pricelist.  LS Retail does not warrant or make any representations regarding the use, validity or accuracy of this pricelist and the result of the calculations. "]
[null,"Please find information about ongoing promos on our Partner Portal"]
[null,"Click here for more details about products in the Price List"]
[null,"Information on country availability can be found on LS Retail Portal"]
[]
[null,"This document is intended for general information purposes only, and we have taken due care in its preparation. All embedded functionality used to facilitate price calculations is provided AS IS. Any risk arising from the use of the information shall rest with the recipient and nothing herein shall be construed as constituting any kind of warranty or representation, express, implied or statutory.  Users are responsible for information that is input using the pricing calculator embedded in the offline pricelist.  Under certain circumstances the figures resulting from the applied pricing calculations embedded in the price list, which are shown for your convenience in this pricelist, may differ from those reflected in the Order Summary Page in Order Central. In these scenarios, the figures shown in the Order Summary Page will control."]
[]
[null,"For information on the availability of EFT connections for the mobile and the stationary LS Central Points of Sale, contact licenses@lsretail.com"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Change Log ","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Price List Change History:"]
[]
[null,"Date","Affected Countries","Type of Change","Summary of Change"]
[null,"2024-03-01","Worldwide","Modules","Added LS Central for pharmacies - W1 localization only, without the country integration"]
[null,"2023-11-15","Worldwide","Prerequisites","The restriction to order only one category of store has been lifted. Customers now have the flexibility to mix purchases from both online and offline stores, provided that the total quantity aligns with the actual number of customer stores."]
[null,"2023-10-01","Worldwide","Modules","Added Self Checkout Connectore Device and Forecourt"]
[null,"2023-09-01","AUD, NZD and CAD","Price Increase","SaaS license price adjustments for local currencies (lsretail.com)"]
[null,"2023-04-01","EU and GB","Price Increase","Following the Local Pricing update announcement from Microsoft"]
[null,"2023-04-01","Worldwide","Changes","New module Analytics added and Activity name changed to Bookings"]
[null,"2023-01-01","Worldwide","Changes","Monthly and Yearly terms combined into 1 sheet"]

{"sheet":"FactorOld","index":5,"n_rows":241,"n_cols":32,"rows_kept":241,"cut":false,"hidden":true,"merged":[]}
[{"$f":"' Monthly LS Central on BC SaaS'!C4","v":"United States"},{"$f":"VLOOKUP($A1,$A4:$J241,2)","v":"United States"},{"$f":"VLOOKUP($A1,$A4:$J241,3)","v":"NAOM"},{"$f":"VLOOKUP($A1,$A4:$J241,4)","v":1},{"$f":"VLOOKUP($A1,$A4:$J241,5)","v":"USD"},{"$f":"IF(K1,E1,VLOOKUP($A1,$A4:$J241,6))","v":"USD"},{"$f":"VLOOKUP($A1,$A4:$J241,7)","v":1200},{"$f":"VLOOKUP($A1,$A4:$J241,8)","v":1200},{"$f":"IF(K1,D1,VLOOKUP($A1,$A4:$J241,9))","v":1},{"$f":"VLOOKUP($A1,$A4:$J241,10)","v":0},{"$f":"IF(N1=\"EUR\",TRUE,FALSE)","v":false},true,{"$f":"IF(COUNTIF(Lists!H3:H6,VLOOKUP($A1,$A4:$J242,6))=1,VLOOKUP($A1,$A4:$J242,6),\"\")","v":""},"",null,{"$f":"' Monthly LS Central on BC SaaS'!C10","v":"USD"},{"$f":"VLOOKUP(P1,P3:Q6,2,FALSE)","v":1},{"$f":"+' Monthly LS Central on BC SaaS'!C10","v":"USD"},{"$f":"VLOOKUP(R1,R3:S6,2,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Lists!H3:H6,VLOOKUP($A1,$A4:$J242,6))=1,E1,\"\")","v":""}]
["Country","LS Retail Region","Microsoft region","Factor vegna mism gjaldmiðla","Currencey vegna mis gjaldmiðla","Currency","USD verð","Landa verð","Factor Store",null,null,null,null,null,null,"USD",1,"USD",1]
["Afghanistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,{"$f":"H4/G4","v":1},null,null,null,null,null,null,"CAD",{"$f":"+Q12/Q11","v":1.2795918367346939},"CAD",{"$f":"+Q4","v":1.2795918367346939}]
["Albania","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"EUR",{"$f":"+Q13/Q11","v":0.84326530612244899},"EUR",{"$f":"+Q5","v":0.84326530612244899}]
["Algeria","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",{"$f":"+Q14/Q11","v":0.75408163265306127},"GBP",{"$f":"+Q6","v":0.75408163265306127}]
["American Samoa","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Andorra","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Angola","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly",null,null,null,null,null,"yearly"]
["Anguilla","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,"list price",null,null,"Essential","Premium","Team member","Device",null,null,"USD","CAD","EUR","GBP",null,null,"USD","CAD","EUR","GBP"]
["Antarctica","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"USD",49,70,5.6,28,null,"ess",49,62.7,{"$f":"41.32*1.11","v":45.865200000000002},37,null,"ess",{"$f":"W11*12","v":588},{"$f":"X11*12","v":752.40000000000009},550.38239999999996,444]
["Antigua and Barbuda","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"CAD",62.7,89.6,7.2,35.799999999999997,null,"p",70,89.6,{"$f":"59.03*1.11","v":65.523300000000006},52.78,null,"p",{"$f":"W12*12","v":840},{"$f":"X12*12","v":1075.1999999999998},{"$f":"Y12*12","v":786.27960000000007},{"$f":"Z12*12","v":633.36}]
["Argentina","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"EUR",41.32,59.03,4.7300000000000004,23.6,null,"tm",5.6,7.2,{"$f":"4.73*1.11","v":5.2503000000000011},4.22,null,"tm",67.199999999999989,86.4,63.003600000000013,50.64]
["Armenia","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",36.950000000000003,52.78,4.22,21.1,null,"device",28,35.799999999999997,{"$f":"23.6*1.11","v":26.196000000000005},null,null,"device",336,429.59999999999997,314.35200000000009]
["Aruba","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Australia","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1,null,null,null,null,"factor",null,"CAD",{"$f":"+Q12/$Q$11","v":1.2795918367346939},{"$f":"+R12/$R$11","v":1.28},{"$f":"+S12/$S$11","v":1.2857142857142858},{"$f":"+T12/T11","v":1.2785714285714285},null,"ess",1,1.2159183673469387,0.84326530612244899,0.75408163265306127,null,"ess",{"$f":"W22*12","v":840},1021.1999999999999,785.88000000000011,633.59999999999991]
["Austria","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75,null,null,null,null,null,null,"EUR",{"$f":"+Q13/$Q$11","v":0.84326530612244899},{"$f":"+R13/$R$11","v":0.84328571428571431},{"$f":"+S13/$S$11","v":0.84464285714285725},null,null,"p",1,1.2158571428571427,0.84328571428571431,0.754,null,"p",1200,1459.1999999999998,1122.8760000000002,904.80000000000007]
["Azerbaijan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",0.75408163265306127,0.754,0.75357142857142856,null,null,"tm",1,1.2160714285714285,0.84464285714285725,0.75357142857142856,null,"tm",96,116.39999999999999,90.575999999999993,72]
["Bahamas, The","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,null,null,null,null,null,null,"device",1,1.216,null,null,null,"device",{"$f":"W25*12","v":180},{"$f":"X25*12","v":218.88}]
["Bahrain","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,1.2159183673469387,1.2158571428571427,1.2160714285714285,1.216,null,"average factor",{"$f":"+AVERAGE(W16:W19)","v":1},{"$f":"+AVERAGE(X16:X19)","v":1.2159617346938776},0.84373129251700674,0.75388435374149665]
["Bangladesh","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,0.84326530612244899,0.84328571428571431,0.84464285714285725]
["Barbados","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,null,0.75408163265306127,0.754,0.75357142857142856,null,null,"ess",70,85.1,{"$f":"59*1.11","v":65.490000000000009},52.8]
["Belarus","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,null,null,null,null,null,"p",100,121.6,{"$f":"84.3*1.11","v":93.573000000000008},75.400000000000006]
["Belgium","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75,null,null,null,null,null,null,null,null,null,null,null,null,"tm",8,9.6999999999999993,{"$f":"6.8*1.11","v":7.548},6]
["Belize","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,null,null,null,null,null,null,"device",15,18.239999999999998]
["Benin","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Bermuda","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,"erp price",null,null,"Essential","Premium","Team member","Device"]
["Bhutan","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"USD",70,100,8,40]
["Bolivia","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"CAD",89.6,128,10.199999999999999,51.2]
["Bosnia and Herzegovina","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"EUR",59,84.3,6.7,33.700000000000003]
["Botswana","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",52.8,75.400000000000006,6,30.2]
["Bouvet Island","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","NOK",1200,8562,7.1349999999999998]
["Brazil","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["British Indian Ocean Territory","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Brunei","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Bulgaria","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Burkina Faso","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Burundi","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Cambodia","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Cameroon","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Canada","Canada","NAOM",1,"CAD","CAD",1200,1200,1.2040816326530612]
["Cape Verde","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Cayman Islands","Latam PR/BM/CI/VI","LATAM II",1,"USD","USD",1200,966,0.80500000000000005]
["Central African Republic","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Chad","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Chile","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["China","China","China",{"$f":"7800/1200","v":6.5},"RMB","RMB",1200,7800,6.5]
["Christmas Island","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Cocos (Keeling) Islands","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Colombia","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Comoros","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Congo","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Congo (DRC)","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Cook Islands","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Costa Rica","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Côte d'Ivoire","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Croatia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Cyprus","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Czech Republic","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Denmark","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Djibouti","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Dominica","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Dominican Republic","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Ecuador"," ","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Egypt","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["El Salvador","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Equatorial Guinea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Eritrea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,{"$f":"H68/G68","v":1}]
["Estonia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Ethiopia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Falkland Islands (Islas Malvinas)","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Faroe Islands","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Fiji Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Finland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["France","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["French Guiana","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["French Polynesia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["French Southern and Antarctic Lands","YTDB","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Gabon","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gambia, The","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gaza Strip","N/A","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Georgia","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Germany","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Ghana","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gibraltar","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Greece","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Greenland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Grenada","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Guadeloupe","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Guam","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guatemala","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Guinea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guinea-Bissau","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guyana","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Haiti","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Heard Island and McDonald Islands","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Honduras","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Hong Kong SAR","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Hungary","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Iceland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["India","India","India",{"$f":"53988/1200","v":44.99},"INR","INR",1200,53988,44.99]
["Indonesia","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Iran","N/A","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Iraq","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Ireland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Israel","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Italy","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Jamaica","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Jan Mayen","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Japan","Japan","Japan",{"$f":"99600/1200","v":83},"JPY","JPY",1200,99600,83]
["Jordan","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Kazakhstan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Kenya","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Kiribati","Australia","APAC I",1,"AUD","AUD",1200,1200,1]
["Korea, South","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Kuwait","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Kyrgyzstan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Laos","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Latvia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Lebanon","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Lesotho","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Liberia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Libya","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Liechtenstein","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","CHF",1200,978,0.81499999999999995]
["Lithuania","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Luxembourg","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Macao SAR","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Macedonia, FYROM","Eastern Europe","EMEA II",1,"USD","USD",1200,1200,1]
["Madagascar","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malawi","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malaysia","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Maldives","South East Asia","APAC II",1,"USD","USD",1200,1200,{"$f":"H132/G132","v":1}]
["Mali","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malta","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Marshall Islands","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Martinique","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mauritania","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mauritius","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mayotte","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mexico","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Micronesia","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Moldova","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Monaco","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mongolia","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Montenegro","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Montserrat","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Morocco","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mozambique","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Myanmar","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Namibia","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Nauru","Australia","APAC I",1,"AUD","AUD",1200,1200,1]
["Nepal","South East Asia","APAC II",1,"USD","USD",1200,1200,1]
["Netherlands Antilles","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Netherlands, The","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["New Caledonia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["New Zealand","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Nicaragua","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Niger","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Nigeria","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Niue","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Norfolk Island","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Northern Mariana Islands","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Norway","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","NOK",1200,8562,7.1349999999999998]
["Oman","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Pakistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Palau","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Panama","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Papua New Guinea","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Paraguay","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Peru","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Philippines","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Pitcairn Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Poland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Portugal","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Puerto Rico","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Qatar","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Reunion","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Romania","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Russia","Russia","EMEA I",{"$f":"56385/1200","v":46.987499999999997},"RUB","RUB",1200,56385,46.987499999999997]
["Rwanda","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Saint Helena","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","GBP",1200,805,0.67083333333333328]
["Saint Kitts and Nevis","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Saint Lucia","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Saint Pierre and Miquelon","Canada","NAOM",{"$f":"1200/1200","v":1},"CAD","CAD",1200,1200,1.2040816326530612]
["Saint Vincent and the Grenadines","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Samoa","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["San Marino","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Sao Tomé and Príncipe","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Saudi Arabia","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Senegal","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Serbia","Eastern Europe","EMEA II",1,"USD","USD",1200,1200,1]
["Seychelles","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Sierra Leone","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Singapore","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Slovakia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Slovenia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,{"$f":"H196/G196","v":0.75}]
["Solomon Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Somalia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["South Africa","South Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["South Georgia and the South Sandwich Islands","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Spain","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Sri Lanka","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Suriname","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Svalbard","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Swaziland","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Sweden","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","SEK",1200,8233,6.8608333333333329]
["Switzerland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","CHF",1200,978,0.81499999999999995]
["Taiwan","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Tajikistan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Tanzania","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Thailand","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Timor-Leste","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Togo","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Tokelau","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Tonga","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Trinidad and Tobago","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Tunisia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turkey","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turkmenistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turks and Caicos Islands","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Tuvalu","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["U.S. Minor Outlying Islands","United States","NAOM",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Uganda","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Ukraine","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["United Arab Emirates","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["United Kingdom","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","GBP",1200,805,0.67083333333333328]
["United States","United States","NAOM",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Uruguay","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Uzbekistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Vanuatu","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Vatican City","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Venezuela","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Vietnam","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Virgin Islands, British","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Virgin Islands, U.S.","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Wallis and Futuna","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["West Bank","N/A","EMEA II",1,"USD","USD",1200,1200,1]
["Western Sahara","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Yemen","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Zambia","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Zimbabwe","Africa","EMEA II",1,"USD","USD",1200,1200,1]

{"sheet":"Factor","index":6,"n_rows":241,"n_cols":30,"rows_kept":241,"cut":false,"hidden":true,"merged":[]}
[{"$f":"' Monthly LS Central on BC SaaS'!C4","v":"United States"},{"$f":"VLOOKUP($A1,$A4:$J241,2)","v":"United States"},{"$f":"VLOOKUP($A1,$A4:$J241,3)","v":"NAOM"},{"$f":"VLOOKUP($A1,$A4:$J241,4)","v":1},{"$f":"VLOOKUP($A1,$A4:$J241,5)","v":"USD"},{"$f":"IF(K1,E1,VLOOKUP($A1,$A4:$J241,6))","v":"USD"},{"$f":"VLOOKUP($A1,$A4:$J241,7)","v":1200},{"$f":"VLOOKUP($A1,$A4:$J241,8)","v":1200},{"$f":"IF(K1,D1,VLOOKUP($A1,$A4:$J241,9))","v":1},{"$f":"VLOOKUP($A1,$A4:$J241,10)","v":0},{"$f":"IF(N1=\"EUR\",TRUE,FALSE)","v":false},true,{"$f":"IF(COUNTIF(Lists!H3:H6,VLOOKUP($A1,$A4:$J242,6))=1,VLOOKUP($A1,$A4:$J242,6),\"\")","v":""},"",null,{"$f":"' Monthly LS Central on BC SaaS'!C10","v":"USD"},{"$f":"VLOOKUP(P1,P3:Q6,2,FALSE)","v":1},{"$f":"+' Monthly LS Central on BC SaaS'!C10","v":"USD"},{"$f":"VLOOKUP(R1,R3:S6,2,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Lists!H3:H6,VLOOKUP($A1,$A4:$J242,6))=1,E1,\"\")","v":""},null,null,{"$f":"'BTC2 Computation'!C9","v":"USD"},{"$f":"VLOOKUP(P1,P3:Q6,2,FALSE)","v":1},{"$f":"'LS Central on BC SaaS edit'!C5","v":"USD"},{"$f":"VLOOKUP(R1,R3:S6,2,FALSE)","v":1}]
["Country","LS Retail Region","Microsoft region","Factor vegna mism gjaldmiðla","Currencey vegna mis gjaldmiðla","Currency","USD verð","Landa verð","Factor Store",null,null,null,null,null,null,"USD",1,"USD",1]
["Afghanistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,{"$f":"H4/G4","v":1},null,null,null,null,null,null,"CAD",{"$f":"+Q12/Q11","v":1.2795918367346939},"CAD",{"$f":"+Q4","v":1.2795918367346939}]
["Albania","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"EUR",{"$f":"+Q13/Q11","v":0.84326530612244899},"EUR",{"$f":"+Q5","v":0.84326530612244899}]
["Algeria","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",{"$f":"+Q14/Q11","v":0.75408163265306127},"GBP",{"$f":"+Q6","v":0.75408163265306127}]
["American Samoa","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Andorra","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Angola","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Anguilla","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,"list price",null,null,"Essential","Premium","Team member","Device Cost","Device Selling",null,null,"usd","cad","eur","gbp"]
["Antarctica","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"USD",49,70,5.6,28,85,null,"Monthly",{"$f":"U11","v":85},{"$f":"U12","v":108.8},{"$f":"U13","v":72.25},{"$f":"U14","v":63.75}]
["Antigua and Barbuda","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"CAD",62.7,89.6,7.2,35.799999999999997,{"$f":"AD16","v":108.8},null,"Yearly",{"$f":"X11*12","v":1020},{"$f":"Y11*12","v":1305.5999999999999},867,765]
["Argentina","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"EUR",41.32,59.03,4.7300000000000004,23.6,{"$f":"AD17","v":72.25}]
["Armenia","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",36.950000000000003,52.78,4.22,21.1,63.75]
["Aruba","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prices until July 1st. ","Prices after July 1st. "]
["Australia","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1,null,null,null,null,"factor",null,"CAD",{"$f":"+Q12/$Q$11","v":1.2795918367346939},{"$f":"+R12/$R$11","v":1.28},{"$f":"+S12/$S$11","v":1.2857142857142858},{"$f":"R16","v":1.28},null,null,null,null,null,null,null,"CAD",{"$f":"79*T16","v":101.12},{"$f":"85*T16","v":108.8}]
["Austria","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75,null,null,null,null,null,null,"EUR",{"$f":"+Q13/$Q$11","v":0.84326530612244899},{"$f":"+R13/$R$11","v":0.84328571428571431},{"$f":"+S13/$S$11","v":0.84464285714285725},0.85,null,null,null,null,null,null,null,"EUR",{"$f":"79*T17","v":67.149999999999991},{"$f":"85*T17","v":72.25}]
["Azerbaijan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",{"$f":"+Q14/$Q$11","v":0.75408163265306127},0.754,0.75357142857142856,0.75,null,null,{"$f":"119*0.75","v":89.25},null,null,null,null,"GBP",{"$f":"79*T18","v":59.25},{"$f":"85*T18","v":63.75}]
["Bahamas, The","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Bahrain","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,1.2159183673469387,1.2158571428571427,1.2160714285714285,1.216]
["Bangladesh","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,null,0.84326530612244899,0.84328571428571431,0.84464285714285725]
["Barbados","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,null,0.75408163265306127,0.754,0.75357142857142856]
["Belarus","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Belgium","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Belize","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Benin","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Bermuda","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,"erp price",null,null,"Essential","Premium","Team member","Device"]
["Bhutan","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"USD",70,100,8,40]
["Bolivia","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005,null,null,null,null,null,null,"CAD",89.6,128,10.199999999999999,51.2]
["Bosnia and Herzegovina","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"EUR",59,84.3,6.7,33.700000000000003]
["Botswana","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1,null,null,null,null,null,null,"GBP",52.8,75.400000000000006,6,30.2]
["Bouvet Island","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","NOK",1200,8562,7.1349999999999998]
["Brazil","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["British Indian Ocean Territory","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Brunei","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Bulgaria","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Burkina Faso","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Burundi","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Cambodia","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Cameroon","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Canada","Canada","NAOM",1,"CAD","CAD",1200,1200,1.2040816326530612]
["Cape Verde","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Cayman Islands","Latam PR/BM/CI/VI","LATAM II",1,"USD","USD",1200,966,0.80500000000000005]
["Central African Republic","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Chad","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Chile","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["China","China","China",{"$f":"7800/1200","v":6.5},"RMB","RMB",1200,7800,6.5]
["Christmas Island","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Cocos (Keeling) Islands","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Colombia","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Comoros","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Congo","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Congo (DRC)","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Cook Islands","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Costa Rica","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Côte d'Ivoire","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Croatia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Cyprus","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Czech Republic","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Denmark","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Djibouti","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Dominica","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Dominican Republic","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Ecuador"," ","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Egypt","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["El Salvador","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Equatorial Guinea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Eritrea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,{"$f":"H68/G68","v":1}]
["Estonia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Ethiopia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Falkland Islands (Islas Malvinas)","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Faroe Islands","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Fiji Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Finland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["France","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["French Guiana","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["French Polynesia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["French Southern and Antarctic Lands","YTDB","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Gabon","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gambia, The","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gaza Strip","N/A","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Georgia","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Germany","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Ghana","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Gibraltar","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Greece","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Greenland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","DKK",1200,6700,5.583333333333333]
["Grenada","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Guadeloupe","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Guam","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guatemala","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Guinea","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guinea-Bissau","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Guyana","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Haiti","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Heard Island and McDonald Islands","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Honduras","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Hong Kong SAR","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Hungary","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Iceland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["India","India","India",{"$f":"53988/1200","v":44.99},"INR","INR",1200,53988,44.99]
["Indonesia","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Iran","N/A","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Iraq","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Ireland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Israel","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Italy","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Jamaica","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Jan Mayen","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Japan","Japan","Japan",{"$f":"99600/1200","v":83},"JPY","JPY",1200,99600,83]
["Jordan","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Kazakhstan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Kenya","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Kiribati","Australia","APAC I",1,"AUD","AUD",1200,1200,1]
["Korea, South","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Kuwait","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Kyrgyzstan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Laos","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Latvia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Lebanon","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Lesotho","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Liberia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Libya","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Liechtenstein","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","CHF",1200,978,0.81499999999999995]
["Lithuania","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Luxembourg","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Macao SAR","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Macedonia, FYROM","Eastern Europe","EMEA II",1,"USD","USD",1200,1200,1]
["Madagascar","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malawi","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malaysia","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Maldives","South East Asia","APAC II",1,"USD","USD",1200,1200,{"$f":"H132/G132","v":1}]
["Mali","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Malta","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Marshall Islands","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Martinique","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mauritania","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mauritius","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mayotte","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mexico","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Micronesia","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Moldova","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Monaco","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Mongolia","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Montenegro","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Montserrat","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Morocco","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Mozambique","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Myanmar","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Namibia","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Nauru","Australia","APAC I",1,"AUD","AUD",1200,1200,1]
["Nepal","South East Asia","APAC II",1,"USD","USD",1200,1200,1]
["Netherlands Antilles","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Netherlands, The","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["New Caledonia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["New Zealand","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Nicaragua","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Niger","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Nigeria","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Niue","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Norfolk Island","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["Northern Mariana Islands","APOC United States","APAC I",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Norway","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","NOK",1200,8562,7.1349999999999998]
["Oman","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Pakistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Palau","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Panama","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Papua New Guinea","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Paraguay","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Peru","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Philippines","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Pitcairn Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Poland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Portugal","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Puerto Rico","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Qatar","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Reunion","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Romania","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Russia","Russia","EMEA I",{"$f":"56385/1200","v":46.987499999999997},"RUB","RUB",1200,56385,46.987499999999997]
["Rwanda","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Saint Helena","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","GBP",1200,805,0.67083333333333328]
["Saint Kitts and Nevis","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Saint Lucia","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Saint Pierre and Miquelon","Canada","NAOM",{"$f":"1200/1200","v":1},"CAD","CAD",1200,1200,1.2040816326530612]
["Saint Vincent and the Grenadines","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Samoa","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["San Marino","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Sao Tomé and Príncipe","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Saudi Arabia","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Senegal","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Serbia","Eastern Europe","EMEA II",1,"USD","USD",1200,1200,1]
["Seychelles","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Sierra Leone","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Singapore","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Slovakia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Slovenia","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,{"$f":"H196/G196","v":0.75}]
["Solomon Islands","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Somalia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["South Africa","South Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["South Georgia and the South Sandwich Islands","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Spain","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Sri Lanka","South East Asia","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Suriname","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Svalbard","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Swaziland","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Sweden","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","SEK",1200,8233,6.8608333333333329]
["Switzerland","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","CHF",1200,978,0.81499999999999995]
["Taiwan","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Tajikistan","Central Asia","EMEA II",1,"USD","USD",1200,1200,1]
["Tanzania","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Thailand","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Timor-Leste","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["Togo","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Tokelau","New Zealand","APAC II",{"$f":"1560/1200","v":1.3},"NZD","NZD",1200,1560,1.3]
["Tonga","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Trinidad and Tobago","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Tunisia","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turkey","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turkmenistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Turks and Caicos Islands","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Tuvalu","Australia","APAC I",{"$f":"1200/1200","v":1},"AUD","AUD",1200,1200,1]
["U.S. Minor Outlying Islands","United States","NAOM",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Uganda","Africa","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Ukraine","Eastern Europe","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["United Arab Emirates","Middle East","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["United Kingdom","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","GBP",1200,805,0.67083333333333328]
["United States","United States","NAOM",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Uruguay","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Uzbekistan","Central Asia","EMEA II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Vanuatu","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Vatican City","Eurozone","EMEA I",{"$f":"900/1200","v":0.75},"EUR","EUR",1200,900,0.75]
["Venezuela","Rest of Latam","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Vietnam","South East Asia ","APAC II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Virgin Islands, British","Latam Caribbean","LATAM I",{"$f":"966/1200","v":0.80500000000000005},"USD","USD",1200,966,0.80500000000000005]
["Virgin Islands, U.S.","Latam PR/BM/CI/VI","LATAM II",{"$f":"1200/1200","v":1},"USD","USD",1200,1200,1]
["Wallis and Futuna","South East Asia ","APAC II",1,"USD","USD",1200,1200,1]
["West Bank","N/A","EMEA II",1,"USD","USD",1200,1200,1]
["Western Sahara","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Yemen","Middle East","EMEA II",1,"USD","USD",1200,1200,1]
["Zambia","Africa","EMEA II",1,"USD","USD",1200,1200,1]
["Zimbabwe","Africa","EMEA II",1,"USD","USD",1200,1200,1]

{"sheet":"Price List","index":7,"n_rows":141,"n_cols":31,"rows_kept":141,"cut":false,"hidden":true,"merged":[[0,27,0,30],[0,12,0,21]]}
[null,null,"SKU","USD","CAD","EUR","GBP","AUD","NZD",null,null,null,"MS pricelist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should receive these prices in the future once Embed is ready"]
[null,null,null,null,{"$f":"1.28*1.06","v":1.3568},0.85,0.76,{"$f":"1.373*1.09","v":1.4965700000000002},{"$f":"1.52*1.07","v":1.6264000000000001},null,null,null,null,null,"USD","USD","CAD","CAD","EUR","EUR","GBP","GBP","AUD","AUD","NZD","NZD",null,"USD","CAD","EUR","GBP"]
[null,"ERP Users",null,null,null,null,null,null,null,null,null,null,"Offer Display Name","Offer ID","List Price","ERP Price","List Price","ERP Price","List Price","ERP Price","List Price","ERP Price","List Price","ERP Price","List Price","ERP Price",null,"LS Retail price","LS Retail price","LS Retail price","LS Retail price"]
[null,"Dynamics 365 Business Central Essential","BC-D365-SAAS-E",84,{"$f":"+D4*$E$2","v":113.9712},{"$f":"+D4*$F$2*1.11","v":79.253999999999991},{"$f":"+D4*$G$2*1.09","v":69.585600000000014},{"$f":"+D4*$H$2","v":125.71188000000001},{"$f":"D4*$I$2","v":136.61760000000001},null,null,null,"Dynamics 365 Business Central Essential","70ec2332-e230-4c53-837d-75dfb54cefe8",{"$f":"+FactorOld!Q11","v":49},{"$f":"+FactorOld!W22","v":70},62.72,89.6,{"$f":"+FactorOld!Y11","v":45.865200000000002},{"$f":"+FactorOld!Y22","v":65.490000000000009},{"$f":"+FactorOld!Z11","v":37},{"$f":"+FactorOld!Z22","v":52.8},67.3,96.1,74.099999999999994,105.8,null,{"$f":"P4*(1-0.5)","v":35},{"$f":"Q4*(1-0.5)","v":31.36},{"$f":"R4*(1-0.5)","v":44.8},{"$f":"S4*(1-0.5)","v":22.932600000000001}]
[null,"Dynamics 365 Business Central Premium","BC-D365-SAAS-P",120,{"$f":"+D5*$E$2","v":162.816},113.22000000000001,99.408000000000015,{"$f":"+D5*$H$2","v":179.58840000000004},{"$f":"D5*$I$2","v":195.16800000000001},null,null,null,"Dynamics 365 Business Central Premium","C9F0BDF2-3679-4F9A-8E69-0DC52C5E9E52",{"$f":"+FactorOld!W12","v":70},{"$f":"+FactorOld!W23","v":100},89.6,128,{"$f":"+FactorOld!Y12","v":65.523300000000006},{"$f":"+FactorOld!Y23","v":93.573000000000008},{"$f":"+FactorOld!Z12","v":52.78},{"$f":"+FactorOld!Z23","v":75.400000000000006},96.1,137.30000000000001,105.8,151.19999999999999,null,{"$f":"P5*(1-0.5)","v":50},44.8,64,32.761650000000003]
[null,"Dynamics 365 Business Central Team Member","BC-D365-SAAS-TM",9.6,13.02528,9.0576000000000008,7.9526399999999997,14.367072000000002,15.613440000000001,null,null,null,"Dynamics 365 Business Central Team Member","70DE61E8-402B-4665-B80E-97FC39323B81",{"$f":"+FactorOld!W13","v":5.6},{"$f":"+FactorOld!W24","v":8},7.17,10.199999999999999,{"$f":"+FactorOld!Y13","v":5.2503000000000011},{"$f":"+FactorOld!Y24","v":7.548},{"$f":"+FactorOld!Z13","v":4.22},{"$f":"+FactorOld!Z24","v":6},7.7,11,8.5,12.1,null,4,{"$f":"Q6*(1-0.5)","v":3.585},5.0999999999999996,2.6251500000000005]
[null,"Dynamics 365 Business Central External Accountant","BC-D365-SAAS-EA",0,0,0,0,0,0,null,null,null,"Dynamics 365 Business Central External Accountant","88F9EB8A-0636-45E8-A601-553E0A48AA9E",0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"Q7*(1-0.5)","v":0},0,0]
[null,"Dynamics 365 Business Central Sales Professional attach","BC-D365-SAAS-SPA",24,32.563200000000002,22.644000000000002,19.881600000000002,35.917680000000004,39.0336,null,null,null,"Dynamics 365 Sales Professional Attach to Qualifying Dynamics 365 Base Offer","62ba2336-d7be-4339-9a52-727e7cc7c0fe",15,20]
[null,"Dynamics 365 Business Central Customer Service Professional attach","BC-D365-SAAS-CSPA",24,32.563200000000002,22.644000000000002,19.881600000000002,35.917680000000004,39.0336,null,null,null,"Dynamics 365 Customer Service Professional Attach to Qualifying Dynamics 365 Base Offer","41791076-9613-40e3-b1c4-7ba8c2c95e60",15,20]
[null,"Yearly",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7*(1-0.5)","v":0},{"$f":"Q7*(1-0.5)","v":0},{"$f":"R7*(1-0.5)","v":0},{"$f":"S7*(1-0.5)","v":0}]
[null,"Dynamics 365 Business Central Essential","BC-D365-SAAS-E",840,1140,{"$f":"+D11*$F$2*1.11","v":792.54000000000008},{"$f":"+D11*$G$2*1.09","v":695.85599999999999},1257.1188000000002,1366.1760000000002,null,null,null,"Dynamics 365 Business Central Essential","70ec2332-e230-4c53-837d-75dfb54cefe8",{"$f":"O4*12","v":588},{"$f":"FactorOld!AC16","v":840},{"$f":"Q4*12","v":752.64},1075.1999999999998,{"$f":"FactorOld!AE11","v":550.38239999999996},{"$f":"FactorOld!AE16","v":785.88000000000011},{"$f":"FactorOld!AF11","v":444},{"$f":"FactorOld!AF16","v":633.59999999999991},null,null,null,null,null,{"$f":"P11*(1-0.5)","v":420},{"$f":"Q11*(1-0.5)","v":376.32},{"$f":"R11*(1-0.5)","v":537.59999999999991},{"$f":"S11*(1-0.5)","v":275.19119999999998}]
[null,"Dynamics 365 Business Central Premium","BC-D365-SAAS-P",1200,1628.4,1132.2,994.08,{"$f":"+D12*$H$2","v":1795.8840000000002},1951.68,null,null,null,"Dynamics 365 Business Central Premium","C9F0BDF2-3679-4F9A-8E69-0DC52C5E9E52",{"$f":"O5*12","v":840},{"$f":"FactorOld!AC17","v":1200},1075.1999999999998,1536,{"$f":"FactorOld!AE12","v":786.27960000000007},{"$f":"FactorOld!AE17","v":1122.8760000000002},{"$f":"FactorOld!AF12","v":633.36},{"$f":"FactorOld!AF17","v":904.80000000000007},null,null,null,null,null,{"$f":"P12*(1-0.5)","v":600},{"$f":"Q12*(1-0.5)","v":537.59999999999991},768,393.13980000000004]
[null,"Dynamics 365 Business Central Team Member","BC-D365-SAAS-TM",96,130.80000000000001,90.576000000000008,79.52640000000001,143.67072000000002,156.1344,null,null,null,"Dynamics 365 Business Central Team Member","70DE61E8-402B-4665-B80E-97FC39323B81",67.199999999999989,{"$f":"FactorOld!AC18","v":96},86.039999999999992,122.39999999999999,{"$f":"FactorOld!AE13","v":63.003600000000013},{"$f":"FactorOld!AE18","v":90.575999999999993},{"$f":"FactorOld!AF13","v":50.64},{"$f":"FactorOld!AF18","v":72},null,null,null,null,null,48,{"$f":"Q13*(1-0.5)","v":43.019999999999996},61.199999999999996,31.501800000000006]
[null,"Dynamics 365 Business Central External Accountant","BC-D365-SAAS-EA",0,0,0,0,0,0,null,null,null,"Dynamics 365 Business Central External Accountant","88F9EB8A-0636-45E8-A601-553E0A48AA9E",0,0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"Q14*(1-0.5)","v":0},0,0]
[null,"Dynamics 365 Business Central Sales Professional attach","BC-D365-SAAS-SPA",240,325.63200000000001,226.44000000000003,198.81600000000003,359.17680000000007,390.33600000000001,null,null,null,"Dynamics 365 Sales Professional Attach to Qualifying Dynamics 365 Base Offer","62ba2336-d7be-4339-9a52-727e7cc7c0fe",{"$f":"O8*12","v":180},240]
[null,"Dynamics 365 Business Central Customer Service Professional attach","BC-D365-SAAS-CSPA",240,325.63200000000001,226.44000000000003,198.81600000000003,359.17680000000007,390.33600000000001,null,null,null,"Dynamics 365 Customer Service Professional Attach to Qualifying Dynamics 365 Base Offer","41791076-9613-40e3-b1c4-7ba8c2c95e60",180,240]
[null,null,null,null,null,null,null,null,0]
[null,"Other Modules"]
[null,"Dynamics 365 Business Central Database Capacity","BC-D365-SAAS-CDC",12,{"$f":"+D19*$E$2","v":16.281600000000001},{"$f":"+D19*$F$2*1.11","v":11.322000000000001},{"$f":"+D19*$G$2*1.09","v":9.9408000000000012},{"$f":"+D19*$H$2","v":17.958840000000002},19.5168,null,null,null,"Common Data Service Database Capacity","D31FCBC0-AAF7-48B7-AF12-900C05A60594",7,10,38.4,51.2,{"$f":"25.3*1.11","v":28.083000000000002},{"$f":"33.7*1.11","v":37.407000000000004},22.6,30.2,38.4,54.9,42.3,60.5]
[null,"Dynamics 365 Business Central Database Capacity Additional 100 GB","BC-D365-SAAS-CDCA",600,{"$f":"+D20*$E$2","v":814.08},{"$f":"+D20*$F$2*1.11","v":566.1},{"$f":"+D20*$G$2*1.09","v":497.04},{"$f":"+D20*$H$2","v":897.94200000000012},{"$f":"D20*$I$2","v":975.84},null,null,null,"Common Data Service Database Capacity Additional 100 GB",null,{"$f":"P20*0.7","v":350},500]
[null,"Dynamics 365 Business Central Database Capacity Overage","BC-D365-SAAS-CDCO",6,{"$f":"+D21*$E$2","v":8.1408000000000005},{"$f":"+D21*$F$2*1.11","v":5.6610000000000005},{"$f":"+D21*$G$2*1.09","v":4.9704000000000006},{"$f":"+D21*$H$2","v":8.9794200000000011},{"$f":"D21*$I$2","v":9.7584},null,null,null,null,null,3.5,5]
[null,"Dynamics 365 Business Central Additional Environment Addon*","BC-D365-SAAS-CAE",360,{"$f":"$D$22*E2","v":488.44799999999998},{"$f":"+D22*$F$2*1.11","v":339.66},{"$f":"+D22*$G$2*1.09","v":298.22400000000005},{"$f":"$D$22*H2","v":538.76520000000005},585.50400000000002,null,null,null,"Dynamics 365 Business Central Additional Environment Addon","642447e8-06fe-4176-b0e4-8745aa293722",210,300,{"$f":"R22*0.7","v":448},640,{"$f":"T22*0.7","v":330.22500000000002},{"$f":"425*1.11","v":471.75000000000006},{"$f":"V22*0.7","v":266},380,480.6,686.5,529.20000000000005,756]
[null,"Yearly"]
[null,"Dynamics 365 Business Central Database Capacity","BC-D365-SAAS-CDC",120,163.19999999999999,{"$f":"+D24*$F$2*1.11","v":113.22000000000001},{"$f":"+D24*$G$2*1.09","v":99.408000000000015},{"$f":"+D24*$H$2","v":179.58840000000004},195.16800000000001,null,null,null,"Common Data Service Database Capacity","D31FCBC0-AAF7-48B7-AF12-900C05A60594",{"$f":"O19*12","v":84},120]
[null,"Dynamics 365 Business Central Database Capacity Additional 100 GB","BC-D365-SAAS-CDCA",6000,8140.8,{"$f":"+D25*$F$2*1.11","v":5661.0000000000009},{"$f":"+D25*$G$2*1.09","v":4970.4000000000005},{"$f":"+D25*$H$2","v":8979.4200000000019},{"$f":"D25*$I$2","v":9758.4},null,null,null,null,null,{"$f":"O20*12","v":4200},6000]
[null,"Dynamics 365 Business Central Database Capacity Overage","BC-D365-SAAS-CDCO",60,81.599999999999994,{"$f":"+D26*$F$2*1.11","v":56.610000000000007},{"$f":"+D26*$G$2*1.09","v":49.704000000000008},{"$f":"+D26*$H$2","v":89.794200000000018},{"$f":"D26*$I$2","v":97.584000000000003},null,null,null,null,null,{"$f":"O21*12","v":42},{"$f":"P21*12","v":60}]
[null,"Dynamics 365 Business Central Additional Environment Addon*","BC-D365-SAAS-CAE",3600,4884,{"$f":"+D27*$F$2*1.11","v":3396.6000000000004},{"$f":"+D27*$G$2*1.09","v":2982.2400000000002},{"$f":"$D$27*H2","v":5387.652000000001},5855.04,null,null,null,"Dynamics 365 Business Central Additional Environment Addon","642447e8-06fe-4176-b0e4-8745aa293722",{"$f":"O22*12","v":2520},3600]
[]
[null,"Base"]
[null," LS Central Base - Per Full User","BC-D365-SAAS-BASE",36,{"$f":"+D30*$E$2","v":48.844799999999999},{"$f":"+D30*$F$2*1.11","v":33.966000000000001},{"$f":"+D30*$G$2*1.09","v":29.822400000000002},{"$f":"+D30*$H$2","v":53.876520000000006},{"$f":"D30*$I$2","v":58.550400000000003}]
[null,"Yearly",null,null,null,null,null,null,0]
[null," LS Central Base - Per Full User","BC-D365-SAAS-BASE",360,488.5,{"$f":"+D32*$F$2*1.11","v":339.66},{"$f":"+D32*$G$2*1.09","v":298.22400000000005},{"$f":"+D32*$H$2","v":538.76520000000005},{"$f":"D32*$I$2","v":585.50400000000002}]
[null,null,null,null,null,null,null,null,0]
[null,"Stores"]
[null,"Online Store","BC-D365-SAAS-STOREON",0,{"$f":"+D35*$E$2","v":0},{"$f":"+D35*$F$2*1.11","v":0},{"$f":"+D35*$G$2*1.09","v":0},{"$f":"+D35*$H$2","v":0},0]
[null,"Offline Store","BC-D365-SAAS-STOREOFF",6,8.1408000000000005,{"$f":"+D36*$F$2*1.11","v":5.6610000000000005},{"$f":"+D36*$G$2*1.09","v":4.9704000000000006},8.9794200000000011,9.7584]
[null,"Yearly",null,null,null,null,null,null,0]
[null,"Online Store","BC-D365-SAAS-STOREON",0,{"$f":"+D38*$E$2","v":0},{"$f":"+D38*$F$2*1.11","v":0},{"$f":"+D38*$G$2*1.09","v":0},{"$f":"+D38*$H$2","v":0},0]
[null,"Offline Store","BC-D365-SAAS-STOREOFF",60,81.400000000000006,{"$f":"+D39*$F$2*1.11","v":56.610000000000007},{"$f":"+D39*$G$2*1.09","v":49.704000000000008},89.794200000000018,97.584000000000003]
[null,null,null,null,null,null,null,null,0]
[null,"Devices"]
[null,"Device SAL for Retail & Hospitality","BC-D365-SAAS-POS",102,{"$f":"+D42*$E$2","v":138.39359999999999},{"$f":"+D42*$F$2*1.11","v":96.237000000000009},{"$f":"+D42*$G$2*1.09","v":84.496800000000007},{"$f":"+D42*$H$2","v":152.65014000000002},165.89279999999999,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",28,40,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P42*(1-0.5)","v":20},{"$f":"Q42*(1-0.5)","v":0},0,0]
[null,"Device SAL for Mobile POS App","BC-D365-SAAS-MPOS",102,138.39359999999999,96.237000000000009,84.496800000000007,152.65014000000002,165.89279999999999,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",28,40,35.799999999999997,51.2,{"$f":"23.61*1.11","v":26.207100000000001},{"$f":"33.7*1.11","v":37.407000000000004},21.1,30.2,38.4,54.9,42.3,60.5,null,{"$f":"P43*(1-0.5)","v":20},{"$f":"Q43*(1-0.5)","v":17.899999999999999},25.6,13.10355]
[null,"Device SAL for Mobile Inventory App","BC-D365-SAAS-MI",102,138.39359999999999,96.237000000000009,84.496800000000007,152.65014000000002,165.89279999999999,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",28,40,4.13,5.8,{"$f":"2.87*1.11","v":3.1857000000000002},{"$f":"4.1*1.11","v":4.5510000000000002},2.57,3.6,null,null,null,null,null,{"$f":"P44*(1-0.5)","v":20},2.0649999999999999,2.9,1.5928500000000001]
[null,"Device SAL for Kitchen Display Server","BC-D365-SAAS-KDS",102,138.39359999999999,96.237000000000009,84.496800000000007,152.65014000000002,165.89279999999999,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",28,40]
[null,"Device SAL for Back Office ","BC-D365-SAAS-BACK",102,138.39359999999999,96.237000000000009,84.496800000000007,152.65014000000002,165.89279999999999,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",28,40]
[null,"Self Checkout Connector Device","BC-D365-SAAS-SCC",102,{"$f":"+D47*$E$2","v":138.39359999999999},96.237000000000009,84.496800000000007,{"$f":"+D47*$H$2","v":152.65014000000002},{"$f":"D47*$I$2","v":165.89279999999999}]
[null,"Yearly",null,null,null,null,null,null,0]
[null,"Device SAL for Retail & Hospitality","BC-D365-SAAS-POS",1020,1384,{"$f":"+D49*$F$2*1.11","v":962.37000000000012},{"$f":"+D49*$G$2*1.09","v":844.96800000000007},{"$f":"+D49*$H$2","v":1526.5014000000001},1658.9280000000001,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",{"$f":"O42*12","v":336},480,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P49*(1-0.5)","v":240},{"$f":"Q49*(1-0.5)","v":0},{"$f":"R49*(1-0.5)","v":0},{"$f":"S49*(1-0.5)","v":0}]
[null,"Device SAL for Mobile POS App","BC-D365-SAAS-MPOS",1020,1384,962.37000000000012,844.96800000000007,1526.5014000000001,1658.9280000000001,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",336,480,{"$f":"Q43*12","v":429.59999999999997},614.40000000000009,314.48520000000002,448.88400000000001,253.20000000000002,362.4,null,null,null,null,null,{"$f":"P50*(1-0.5)","v":240},{"$f":"Q50*(1-0.5)","v":214.79999999999998},307.20000000000005,157.24260000000001]
[null,"Device SAL for Mobile Inventory App","BC-D365-SAAS-MI",1020,1384,962.37000000000012,844.96800000000007,1526.5014000000001,1658.9280000000001,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",336,480,49.56,69.599999999999994,38.228400000000001,54.612000000000002,30.839999999999996,43.2,null,null,null,null,null,{"$f":"P51*(1-0.5)","v":240},{"$f":"Q51*(1-0.5)","v":24.78},34.799999999999997,19.1142]
[null,"Device SAL for Kitchen Display Server","BC-D365-SAAS-KDS",1020,1384,962.37000000000012,844.96800000000007,1526.5014000000001,1658.9280000000001,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",336,480]
[null,"Device SAL for Back Office ","BC-D365-SAAS-BACK",1020,1384,962.37000000000012,844.96800000000007,1526.5014000000001,1658.9280000000001,null,null,null,"Dynamics 365 Business Central Device","92e2abd3-f3c5-488d-9d66-4957ed81ffe2",336,480]
[null,"Self Checkout Connector Device","BC-D365-SAAS-SCC",1020,1384,962.37000000000012,844.96800000000007,{"$f":"+D54*$H$2","v":1526.5014000000001},{"$f":"D54*$I$2","v":1658.9280000000001}]
[null,null,null,null,null,null,null,null,0]
[null,"Below items are not in pricelist - only used for existing customers allready with these products"]
[null,"Office 365 Business Premium","BC-D365-SAAS-O365BP",15,{"$f":"+D57*$E$2","v":20.352},{"$f":"+D57*$F$2*1.11","v":14.152500000000002},{"$f":"+D57*$G$2*1.09","v":12.426000000000002},{"$f":"+D57*$H$2","v":22.448550000000004},24.396000000000001,null,null,null,"Office 365 Business Premium","031C9E47-4802-4248-838E-778FB1D2CC05",10,12.5,12.16,15.2,{"$f":"8.43*1.11","v":9.3573000000000004},{"$f":"10.55*1.11","v":11.710500000000001},7.54,9.4,null,null,null,null,null,{"$f":"O57","v":10},{"$f":"Q57","v":12.16},{"$f":"S57","v":9.3573000000000004},{"$f":"U57","v":7.54}]
[null,"Power BI Pro","BC-D365-SaaS-PBP",12,16.281600000000001,{"$f":"+D58*$F$2*1.11","v":11.322000000000001},{"$f":"+D58*$G$2*1.09","v":9.9408000000000012},17.958840000000002,19.5168,null,null,null,"Power BI Pro","800F4F3B-CFE1-42C1-9CEA-675512810488",8,10,9.7100000000000009,12.1,{"$f":"6.73*1.11","v":7.4703000000000008},{"$f":"8.4*1.11","v":9.3240000000000016},6.02,7.5,null,null,null,null,null,{"$f":"O58","v":8},{"$f":"Q58","v":9.7100000000000009},{"$f":"S58","v":7.4703000000000008},{"$f":"U58","v":6.02}]
[null,"Yearly",null,null,null,null,null,null,0]
[null,"Office 365 Business Premium","BC-D365-SAAS-O365BP",150,{"$f":"+D60*$E$2","v":203.52},{"$f":"+D60*$F$2*1.11","v":141.52500000000001},{"$f":"+D60*$G$2*1.09","v":124.26},{"$f":"+D60*$H$2","v":224.48550000000003},243.96,null,null,null,"Office 365 Business Premium","031C9E47-4802-4248-838E-778FB1D2CC05",{"$f":"O57*12","v":120},{"$f":"P57*12","v":150},145.92000000000002,182.39999999999998,112.2876,140.52600000000001,90.48,112.80000000000001,null,null,null,null,null,{"$f":"O60","v":120},{"$f":"Q60","v":145.92000000000002},{"$f":"S60","v":112.2876},{"$f":"U60","v":90.48}]
[null,"Power BI Pro","BC-D365-SaaS-PBP",120,162.816,{"$f":"+D61*$F$2*1.11","v":113.22000000000001},{"$f":"+D61*$G$2*1.09","v":99.408000000000015},179.58840000000004,195.16800000000001,null,null,null,"Power BI Pro","800F4F3B-CFE1-42C1-9CEA-675512810488",{"$f":"O58*12","v":96},{"$f":"P58*12","v":120},116.52000000000001,145.19999999999999,89.643600000000006,111.88800000000002,72.239999999999995,90,null,null,null,null,null,{"$f":"O61","v":96},{"$f":"Q61","v":116.52000000000001},{"$f":"S61","v":89.643600000000006},{"$f":"U61","v":72.239999999999995}]
[null,"LS Central Modules","","Not in Microsoft pricelists - only available for selected partners"]
[null,"Scan Pay Go - per Usage","BC-D365-SAAS-SPG",0.01,{"$f":"+D63*$E$2","v":1.3568E-2},{"$f":"+D63*$F$2*1.11","v":9.4350000000000007E-3},{"$f":"+D63*$G$2*1.09","v":8.2840000000000014E-3},{"$f":"+D63*$H$2","v":1.4965700000000002E-2},{"$f":"D63*$I$2","v":1.6264000000000001E-2}]
[null,"Analytics","BC-D365-SAAS-ANALYTI",0,null,null,null,null,{"$f":"D64*$I$2","v":0}]
[null,"Hotels - per Property","BC-D365-SAAS-HOTEL-P",163.19999999999999,221.42975999999999,153.97920000000002,135.19488000000001,{"$f":"+D65*$H$2","v":244.24022400000001},{"$f":"+D65*$I$2","v":265.42847999999998}]
[null,"Hotels - per Room","BC-D365-SAAS-HOTEL-R",{"$f":"7","v":7},9.4976000000000003,6.6045000000000007,5.7988000000000008,10.475990000000001,{"$f":"+D66*$I$2","v":11.3848}]
[null,"Hotels - per Power App User","BC-D365-SAAS-HOTEL-PAU",{"$f":"15","v":15},20.352,14.152500000000002,12.426000000000002,22.448550000000004,24.396000000000001]
[null,"Bookings - per Location","BC-D365-SAAS-APL",{"$f":"15","v":15},20.352,14.152500000000002,12.426000000000002,22.448550000000004,24.396000000000001]
[null,"Bookings - per Device","BC-D365-SAAS-APOS",{"$f":"12","v":12},16.281600000000001,11.322000000000001,{"$f":"+D69*$G$2*1.09+0.01","v":9.950800000000001},{"$f":"+D69*$H$2","v":17.958840000000002},{"$f":"D69*$I$2","v":19.5168},null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"Staff Management - per Employee","BC-D365-SAAS-SPE",{"$f":"2","v":2},{"$f":"+D70*$E$2","v":2.7136},1.887,1.6568000000000001,{"$f":"+D70*$H$2","v":2.9931400000000004},3.2528000000000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Pay - per Device","BC-D365-SAAS-PAY",12,{"$f":"+D71*$E$2","v":16.281600000000001},11.322000000000001,9.9408000000000012,{"$f":"+D71*$H$2","v":17.958840000000002},19.5168,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Loss Prevention - per Device",null,9.6,13.02528,{"$f":"+D72*$F$2","v":8.16},{"$f":"+D72*$G$2","v":7.2959999999999994},14.367072000000002,15.613440000000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Loyalty  - per License",null,142.79999999999998,193.75103999999999,121.37999999999998,108.52799999999999,213.710196,232.24991999999997,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Additional Loyalty Concurrent Users (500)",null,142.79999999999998,193.75103999999999,121.37999999999998,108.52799999999999,213.710196,232.24991999999997,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central eCommerce Integration Framework - nopCommerce ",null,610.79999999999995,828.73343999999997,519.17999999999995,464.20799999999997,914.10495600000002,993.40512000000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - Please select a Framework","BC-D365-SAAS-E3RD",{"$f":"163.2","v":163.19999999999999},221.42975999999999,{"$f":"+D76*$F$2*1.11","v":153.97920000000002},{"$f":"+D76*$G$2*1.09","v":135.19488000000001},244.24022400000001,265.42847999999998,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - Magento/Adobe Commerce","BC-D365-SAAS-EMAG",{"$f":"163.2","v":163.19999999999999},221.42975999999999,{"$f":"+D77*$F$2*1.11","v":153.97920000000002},{"$f":"+D77*$G$2*1.09","v":135.19488000000001},244.24022400000001,265.42847999999998,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - Shopify","BC-D365C-SAAS-ESHOP",{"$f":"163.2","v":163.19999999999999},221.42975999999999,{"$f":"+D78*$F$2*1.11","v":153.97920000000002},{"$f":"+D78*$G$2*1.09","v":135.19488000000001},244.24022400000001,265.42847999999998,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - 3rd Party","BC-D365-SAAS-E3RD",{"$f":"163.2","v":163.19999999999999},{"$f":"+D79*$E$2","v":221.42975999999999},{"$f":"+D79*$F$2*1.11","v":153.97920000000002},{"$f":"+D79*$G$2*1.09","v":135.19488000000001},{"$f":"+D79*$H$2","v":244.24022400000001},{"$f":"D79*$I$2","v":265.42847999999998}]
[null,"eCommerce per Device","BC-D365-SAAS-EPOS",3.6,4.8844799999999999,{"$f":"+D80*$F$2*1.11","v":3.3966000000000003},{"$f":"+D80*$G$2*1.09","v":2.9822400000000004},5.387652000000001,5.8550400000000007]
[null,"LS Central Additional Language Layer",null,24,32.563200000000002,20.399999999999999,18.240000000000002,35.917680000000004,{"$f":"D81*$I$2","v":39.0336},null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"Yearly"]
[null,"Scan Pay Go - per Usage","BC-D365-SAAS-SPG",0.01]
[null,"Analytics","BC-D365-SAAS-ANALYTI",0,null,null,null,null,{"$f":"D84*$I$2","v":0}]
[null,"Pharmacies Base - W1","BC-D365-SAAS-PHBW1",6000,{"$f":"+D85*$E$2","v":8140.8},{"$f":"+D85*$F$2*1.11","v":5661.0000000000009},{"$f":"+D85*$G$2*1.09","v":4970.4000000000005},{"$f":"+D85*$H$2","v":8979.4200000000019},{"$f":"D85*$I$2","v":9758.4}]
[null,"Pharmacies per Device","BC-D365-SAAS-PHDW1",480,651.26400000000001,452.88000000000005,397.63200000000006,718.35360000000014,780.67200000000003]
[null,"Forecourt base","BC-D365-SAAS-FCB",1632,{"$f":"+D87*$E$2","v":2214.2975999999999},{"$f":"+D87*$F$2*1.11","v":1539.7920000000001},{"$f":"+D87*$G$2*1.09","v":1351.9488000000001},{"$f":"+D87*$H$2","v":2442.4022400000003},{"$f":"D87*$I$2","v":2654.2847999999999}]
[null,"Forecourt per device","BC-D365-SAAS-FCD",212.4,288.18432000000001,200.39940000000001,175.95216000000002,317.87146800000005,345.44736]
[null,"Hotels - per Property","BC-D365-SAAS-HOTEL-P",{"$f":"136*12","v":1632},{"$f":"+$D$89*E2","v":2214.2975999999999},{"$f":"+$D89*F$2*1.11","v":1539.7920000000001},{"$f":"+$D$89*G2*1.09","v":1351.9488000000001},{"$f":"+$D$89*H2","v":2442.4022400000003},{"$f":"+$D$89*I2","v":2654.2847999999999}]
[null,"Hotels - per Room","BC-D365-SAAS-HOTEL-R",{"$f":"7*12","v":84},{"$f":"+D90*$E$2","v":113.9712},79.253999999999991,{"$f":"+D90*$G$2*1.09","v":69.585600000000014},{"$f":"+D90*$H$2","v":125.71188000000001},{"$f":"+D90*$I$2","v":136.61760000000001}]
[null,"Hotels - per Power App User","BC-D365-SAAS-HOTEL-PAU",{"$f":"15*12","v":180},{"$f":"+D91*$E$2","v":244.22399999999999},169.83,149.11200000000002,{"$f":"+D91*$H$2","v":269.38260000000002},{"$f":"+D91*$I$2","v":292.75200000000001}]
[null,"Bookings - per Location","BC-D365-SAAS-BPL",{"$f":"15*12","v":180},244.22399999999999,169.83,149.11200000000002,269.38260000000002,292.75200000000001]
[null,"Bookings - per Device","BC-D365-SAAS-BPOS",{"$f":"12*12","v":144},195.3792,135.864,{"$f":"+D93*$G$2*1.09+0.1","v":119.3896},215.50608000000003,234.20160000000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"Staff Management - per Employee","BC-D365-SAAS-SPE",{"$f":"2*12","v":24},{"$f":"+D94*$E$2","v":32.563200000000002},22.644000000000002,19.881600000000002,{"$f":"+D94*$H$2","v":35.917680000000004},39.0336,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Pay - per Device","BC-D365-SAAS-PAY",{"$f":"10*12","v":120},{"$f":"+D95*$E$2","v":162.816},113.22000000000001,99.408000000000015,{"$f":"+D95*$H$2","v":179.58840000000004},195.16800000000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Loss Prevention - per Device",null,{"$f":"(D72*12)*0.8","v":92.16},125.042688,{"$f":"+D96*$F$2","v":78.335999999999999},{"$f":"+D96*$G$2","v":70.041600000000003},137.92389120000001,149.88902400000001,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Loyalty  - per License",null,{"$f":"(D73*12)*0.8","v":1370.88},1860.0099840000003,1165.248,1041.8688000000002,2051.6178816000006,2229.5992320000005,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central Additional Loyalty Concurrent Users (500)",null,{"$f":"(D74*12)*0.8","v":1370.88},1860.0099840000003,1165.248,1041.8688000000002,2051.6178816000006,2229.5992320000005,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"LS Central eCommerce Integration Framework - nopCommerce ",null,{"$f":"(D75*12)*0.8","v":5863.68},7955.8410240000003,4984.1279999999997,4456.3968000000004,8775.4075776000009,9536.6891520000008,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - Please select a Framework","BC-D365-SAAS-E3RD",{"$f":"136*12","v":1632},2214.2975999999999,{"$f":"+D100*$F$2*1.11","v":1539.7920000000001},{"$f":"+D100*$G$2*1.09","v":1351.9488000000001},2442.4022400000003,2654.2847999999999,null,null,null,"LS eCommerce Base - DynamicWeb Removed from the pricelist in February 2022"]
[null,"eCommerce Base - Magento/Adobe Commerce","BC-D365-SAAS-EMAG",{"$f":"136*12","v":1632},2214.2975999999999,{"$f":"+D101*$F$2*1.11","v":1539.7920000000001},{"$f":"+D101*$G$2*1.09","v":1351.9488000000001},2442.4022400000003,2654.2847999999999,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - Shopify*","BC-D365C-SAAS-ESHOP",{"$f":"136*12","v":1632},{"$f":"+D102*$E$2","v":2214.2975999999999},{"$f":"+D102*$F$2*1.11","v":1539.7920000000001},{"$f":"+D102*$G$2*1.09","v":1351.9488000000001},{"$f":"+D102*$H$2","v":2442.4022400000003},{"$f":"D102*$I$2","v":2654.2847999999999},null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[null,"eCommerce Base - 3rd Party","BC-D365-SAAS-E3RD",{"$f":"136*12","v":1632},2214.2975999999999,{"$f":"+D103*$F$2*1.11","v":1539.7920000000001},{"$f":"+D103*$G$2*1.09","v":1351.9488000000001},2442.4022400000003,2654.2847999999999]
[null,"eCommerce per Device","BC-D365-SAAS-EPOS",{"$f":"3*12","v":36},48.844799999999999,{"$f":"+D104*$F$2*1.11","v":33.966000000000001},{"$f":"+D104*$G$2*1.09","v":29.822400000000002},53.876520000000006,58.550400000000003]
[null,"LS Central Additional Language Layer - Yearly",null,{"$f":"D81*12","v":288},390.75839999999999,244.79999999999998,218.88,431.01216000000005,468.40320000000003,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
[]
[" "]
[null," ",null,{"$f":"D85/12","v":500},{"$f":"E85/12","v":678.4},471.75000000000006,414.20000000000005,748.2850000000002,813.19999999999993]
[null,null,null,{"$f":"D86/12","v":40},{"$f":"E86/12","v":54.271999999999998},37.74,33.136000000000003,59.862800000000014,65.055999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Comment from Sigrun dated 16.11.2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dynamics 365 Business Central Device","5b04b78c-fd36-4cf3-a7a5-3457991c8b79","Corporate","1 Month(s)","NON-SPECIFIC","CLOUD RESELLER CORPORATE",35.799999999999997,51.2]
[null,null,"SKU","USD",null,null,null,null,null,null,null,null,null,"Dynamics 365 Business Central Device from DPL or Bus Ed (Qualified Offer)","a8f4144e-d1d9-48d7-8966-dc6a32d28a30","Corporate","1 Month(s)","NON-SPECIFIC","CLOUD RESELLER CORPORATE",21.5,30.7]
[]
[]
[]
[]
[null,"Removed from pricelist"]
["LSPO-5466","LS eCommerce Base - Avensia Storefront","BC-D365-SAAS-EAVE",{"$f":"163.2","v":163.19999999999999},{"$f":"+D140*$E$2","v":221.42975999999999},{"$f":"+D140*$F$2","v":138.72},{"$f":"+D140*$G$2","v":124.032},{"$f":"+D140*$H$2","v":244.24022400000001},{"$f":"D140*$I$2","v":265.42847999999998},null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]
["LSPO-5466","LS eCommerce Base - Avensia Storefront - Yearly","BC-D365-SAAS-EAVE",{"$f":"136*12","v":1632},2214.2975999999999,1387.2,1240.32,2442.4022400000003,2654.2847999999999,null,null,null,"Finding the prices by using this formula, but typing in so it appears correctly =+$E26*Factor!$T$18"]

{"sheet":"Lists","index":8,"n_rows":90,"n_cols":14,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[]
[null,"OrderType",null,null,null,null,null,"Currency List",null,null,"Link To Existing SaaS Active Directory"]
[null,"New License",null,null,null,null,null,"AUD",null,null,"Yes"]
[null,"Additional modules",null,null,null,null,null,"CAD",null,null,"No"]
[null,null,null,null,null,null,null,"DKK"]
[null,null,null,null,null,null,null,"EUR",null,null,null,null,null,"If yes, <existing AAD Name>"]
[null,null,null,null,null,null,null,"GBP",null,null,null,null,null,"If no, <preferred AAD Name>"]
[null,null,null,null,null,null,null,"INR"]
[null,null,null,null,null,null,null,"NOK"]
[null,null,null,null,null,null,null,"NZD"]
[null,null,null,null,null,null,null,"SEK"]
[null,null,null,null,null,null,null,"USD"]
[]
[null,null,null,null,null,null,null,"Price Guarantee Monthly"]
[null,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Effective"]
[null,"MA/GVA/PVLA",null,null,null,null,null,"Price Guarantee Yearly",null,null,null,"Effective from 1 September 2023"]
[null,"No",null,null,null,null,null,false]
[null,"Global Volume Agreement"]
[null,"Multisite Agreement"]
[null,"Perpertual Volume Licensing Agreement"]
[null,"Volume Agreement",null,null,null,null,null,"Subscription Term/Billing"]
[null,null,null,null,null,null,null,"Triennial"]
[null,"Enhancement plan Required for ",null,null,null,null,null,"Annual"]
[null," 1 Year",null,null,null,null,null,"Monthly"]
[null," 3 Year annual"]
[null," 3 Year upfront"]
[]
[null,null,null,null,null,null,null,"Special Deal /Promo"]
[null,null,null,null,null,null,null,"BTC2 Promo - SH0084"]
[null,"Product Line"]
[null,"LS Central on Business Central SaaS"]
[]
[null,null,null,null,null,null,null,"First Registration Date"]
[]
[null,null,null,null,null,null,null,"Before September 1, 2022"]
[null,null,null,null,null,null,null,"On or after September 1, 2022"]
[]
[null,"Version"]
[null,"LS Central on Busines Central (13)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TypeBusiness"]
[null,"1 Supermarkets/Groceries/Convenience"]
[null,"2 Department stores"]
[null,"3 Consumer electronics/Home appliances/Technology"]
[null,"4 Fashion/Apparel/Accessories"]
[null,"5 Furniture/Housing"]
[null,"6 Hardware/DIY/Garden Centers"]
[null,"7 Hospitality - Restaurants, Fast Food, Catering"]
[null,"8 Others"]
[null,"9 Duty free/Airport/Travel Retail"]
[null,"10 Hospitality - Hotels and Resorts"]
[null,"11 Pharmacies/Drugstores"]
[null,"12 Sport- clothing/equipment  "]
[null,"13 Bookstores/Stationary/Newsstands"]
[null,"14 Forecourt and Gas stations"]
[null,"15 Entertainment: Museums, Casinos, Stadiums"]
[null,"16 Jewelry Stores"]
[null,"17 Pet Stores"]
[null,"18 Shoe Stores"]
[null,"19 Cars/Automotive"]
[null,"20 Importer/Seller/Supplier/Wholesaler"]
[null,"21 Wineries/Liquor Stores"]
[null,"22 Photo Shops"]
[null,"23 Specialty Retail/Boutiques"]
[null,"24 Optical Stores"]
[null,"25 Trade companies/Service Provider/Consultancy"]
[null,"26 NGO/Government/Schools"]
[null,"27 Health/Beauty/Cosmetics"]
[null,"Please select the correct Type of Business"]
[]
[]
[]
[]
[null,"NaceCode"]

{"sheet":"Change Log","index":9,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Pricelist Change History:"]
[]
[null,"Date","Affected Countries","Type of Change","Summary of Change"]