{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["AzureModeler","ProspectWorksheet","Settings","AzurePricing","TCO","Topology","Template","AzureResources","SavedModels"],"not_rendered":{"charts":8,"images":12,"macros":1,"external_links":0,"defined_names":138,"comments":4,"pivot_tables":1},"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":"AzureModeler","index":0,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Azure Modeler for Business Workloads\n\n\nMonthly Estimate with Azure/Office 365 and Dynamics ERP & CRM Online Solutions",{"$f":" \"Avg. Monthly Per User  \" & CHAR(10)  & CHAR(10) & TEXT(((SUM(F17:F22))/TotalUserCount*AzureRunHoursDiscount) +SUM(L18:L22),CurrencySymbol&\"#,###\")","v":"Avg. Monthly Per User  \n\n$45"},null,"Customer Name:",null,"Sample ERP 3 Users",null,null,"Modeler Instructions:  \nHover over green 'Get Started ' to get started"]
[null,{"$f":"\"Monthly Azure :  \" & TEXT( (SUM(F17:F22)*AzureRunHoursDiscount)/TotalUserCount,CurrencySymbol&\"#,###\") & \"  Non-Azure :   \" & TEXT(SUM(L18:L22),CurrencySymbol&\"#,##0\")","v":"Monthly Azure :  $45  Non-Azure :   $0"},{"$f":"IF(OR(Office365=\"Yes\",CRMOLOption=\"Yes\"),MAX(O365Users,CRMOLUsers),SUM(C6:C8))","v":3},{"$f":"SUM(C6:C8)","v":3},null,null,null,null,null,"Azure Pricing online"]
[]
[null,"Dynamics ERP Server and Users","Azure Price Options","USD","Standard Tier","Get\nStarted","Server Options & Discounts",null,"GP",{"$f":"\"Dynamics \" & BaseProduct & \" Server\n Matrix Options\"","v":"Dynamics GP Server\n Matrix Options"},"User # Lower Limit","Users # Upper Limit","Separate SQL Server"]
[null,"Dynamics ERP Users",3,null,null,24,"Daily Scheduled Runtime Hrs for Azure Servers",{"$f":"DailyRunHours/24","v":1},{"$f":"Settings!E24","v":"  Small"},{"$f":"Settings!F24","v":"VM-A2"},{"$f":"Settings!G24","v":1},{"$f":"Settings!H24","v":3},{"$f":"Settings!I24","v":"No"},"  Small","Yes"]
[null,"Dynamics ERP Web Client Users & Load factor",0,0.5,null,"PERP",{"$f":"IF(F7=\"PERP\",\"Dynamics ERP License Type - \" & \"Perpetual/Purchase\",\"Dynamics ERP License Type \" & \"Monthly\")","v":"Dynamics ERP License Type - Perpetual/Purchase"},null,{"$f":"Settings!E25","v":" Medium"},{"$f":"Settings!F25","v":"VM-A3"},{"$f":"Settings!G25","v":4},{"$f":"Settings!H25","v":7},{"$f":"Settings!I25","v":"Yes"}," Medium","No"]
[null,"Dynamics ERP Limited Users/CALs & Load Factor",0,0.25,null,"PERP",{"$f":"IF(F8=\"VM-SQL\",\"SQL Virtual Machine - w/SQL License inclued\",\"SQL Server  License -  \" & \"Purchased w/License Mobility\")","v":"SQL Server  License -  Purchased w/License Mobility"},null,{"$f":"Settings!E26","v":"Large"},{"$f":"Settings!F26","v":"VM-A3"},{"$f":"Settings!G26","v":8},{"$f":"Settings!H26","v":20},{"$f":"Settings!I26","v":"Yes"},"Large",6]
[null,{"$f":"\"Total Adjusted Users - (Adjustment factor)   \"\n & TEXT(WebClientPerformanceFactor,\"0%\")","v":"Total Adjusted Users - (Adjustment factor)   50%"},{"$f":"ROUNDUP(DesktopCALs+(WebClientCALs*WebClientPerformanceFactor)+ (LimitedUserCALs*LimitedUserPerformanceFactor),0)","v":3},null,null,"No","Separate Domain Controller",null,{"$f":"Settings!E27","v":"XLarge"},{"$f":"Settings!F27","v":"VM-A5"},{"$f":"Settings!G27","v":21},{"$f":"Settings!H27","v":40},{"$f":"Settings!I27","v":"Yes"},"Xlarge",12,{"$f":"IF(ExcelVersionNo<15,checkisformula(C9),_xlfn.ISFORMULA(C9))","v":true}]
[null,"Microsoft Office 365 Users",{"$f":"ERPUserCount","v":3},null,null,"No",{"$f":"I10","v":"Microsoft Office 365 Business Premium"},null,"Microsoft Office 365 Business Premium",null,15,null,null,null,null,{"$f":"IF(ExcelVersionNo<15,checkisformula(C10),_xlfn.ISFORMULA(C10))","v":true}]
[null,"Microsoft CRM Online Users",{"$f":"ERPUserCount","v":3},null,null,"No","Dynamics CRM Online",null,"Microsoft CRM OnLine",null,65]
[null,"Dynamics ERP Server/Azure VM",{"$f":"IFERROR(VLOOKUP(AdjustedCALs,K6:N9,4,TRUE),\"\")","v":"  Small"},{"$f":"IFERROR(VLOOKUP(BaseServerSize,I6:J9,2,TRUE),\"\")","v":"VM-A2"},null,"No","Remote Desktop SPLA Agreement",null,"Remote Desktop Azure SPLA Agreement",null,4]
[null,"Azure VM SQL Server Type","SW",{"$f":"IF(SQLServerType=\"SS\",\"SQL Standard\",IF(SQLServerType=\"SW\",\"SQL Web\",\"SQL Enterprise\"))","v":"SQL Web"},null,"No","Separate SQL Reporting Service Server",null,"Microsoft Dynamics ERP Subscription User/Mth",null,100]
[null,"Financing Software and Services (Rate %/Period Mths)",0.1,24,null,"No",{"$f":"IF(TypeOfERPLicence=\"PERP\",\"Finance Software and Services Option\",\"Finance Services Option\")","v":"Finance Software and Services Option"},null,"Finance Amount / Mth Payment",null,5000,{"$f":"IF(FinanceOption=\"Yes\",PMT(FinanceRate/12,FinancePeriod,FinanceAmount)*-1,0)","v":0}]
[null,"Azure 99.95% SLA Requirement","No",null,null,"No",{"$f":"IF(TypeOfERPLicence=\"SPLA\",\"Partner Implementation Services\",\"Partner Implementation Estimate & License\")","v":"Partner Implementation Estimate & License"},null,{"$f":"IF(TypeOfERPLicence=\"SPLA\",\"Partner Implementation Estimate Only\",\"Partner Implementation Estimate & License\")","v":"Partner Implementation Estimate & License"},null,5000]
[null,{"$f":"\"Azure Resources Schedule - \" & AzureTier & \" VMs\"","v":"Azure Resources Schedule - Standard Tier VMs"},"Type","Qty","Cost /\nHr.","Est. per Month","Azure Resource Description",null,"Dynamics ERP License & Other Monthly Services Estimate:"]
[null,{"$f":"IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"No\",\nIF(LEFT(C17,1)=\"S\",\"Windows & SQL Server VM\",\"Windows VM - Assume SQL License Mobility\"),\n\"Windows VM\"),\"\")","v":"Windows VM - Assume SQL License Mobility"},{"$f":"IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nVM,\nIF(TypeOfSQLLicense<>\"VM-SQL\",VM,SQLServerType &\"-\"  & MID(D12,4,2))),\"\")","v":"VM-A2"},{"$f":"IF(AzureSLA=\"Yes\",2,1)","v":1},{"$f":"IFERROR(INDEX(AzurePricing!A3:N86,(MATCH(ServerClass1Type,AzurePricing!A3:A86,0)),\nIF(AzureTier=\"Basic Tier\",MATCH(Currency,AzurePricing!A1:N1,0),MATCH(Currency,AzurePricing!A1:N1,0)+1)),\"\")","v":0.17999999999999997},{"$f":"IFERROR(D17*(E17*744),\"\")","v":133.91999999999999},{"$f":"IFERROR(IF(E17<>0.0001,IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"No\",\nINDEX(AzurePricing!$A$99:$C$170,MATCH(ServerClass1Type,AzurePricing!$A$99:$A$170,0),2,1),\nINDEX(AzurePricing!$A$99:$C$170,MATCH(ServerClass1Type,AzurePricing!$A$99:$A$170,0),2,1)),\"Not available on Basic Tier\"),\"\")","v":"A2 Medium (2 cores, 3.5GB RAM)"},{"$f":"TEXT(ServerClass1Mth,CurrencySymbol&\"#,###\")","v":"$134"},"Optional Services User/Mth",null,"Users","Per Mth",null,{"$f":"IF(ExcelVersionNo<15,checkisformula(C17),_xlfn.ISFORMULA(C17))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(D17),_xlfn.ISFORMULA(D17))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(E17),_xlfn.ISFORMULA(E17))","v":true}]
[null,{"$f":"IF(DomainController=\"Yes\",G9,\"Windows VM 2\")","v":"Windows VM 2"},"VM-A1",{"$f":"IF(DomainController=\"No\",0,IF(AzureSLA=\"Yes\",2,1))","v":0},{"$f":"INDEX(AzurePricing!A3:N87,(MATCH(ServerClass2Type,AzurePricing!A3:A87,0)),\nIF(AzureTier=\"Basic Tier\",MATCH(Currency,AzurePricing!A1:N1,0),MATCH(Currency,AzurePricing!A1:N1,0)+1))","v":8.9999999999999983E-2},{"$f":"D18*(E18*744)","v":0},{"$f":"IF(E18<>0.0001,INDEX(AzurePricing!$A$99:$C$170,MATCH(C18,AzurePricing!$A$99:$A$170,0),2,1),\"Not Available on Basic Tier\")","v":"A1 Small (1 core, 1.75GB RAM)"},{"$f":"TEXT(ServerClass2Mth,CurrencySymbol&\"#,###\")","v":"$"},"RDS SPLA","Remote Desktop Services",{"$f":"DesktopCALs","v":3},{"$f":"IF(F12=\"Yes\",RDPSPLA,0)","v":0},{"$f":"IF(RDServices=\"Yes\",K18*L18,0)","v":0},{"$f":"IF(ExcelVersionNo<15,checkisformula(C18),_xlfn.ISFORMULA(C18))","v":false},{"$f":"IF(ExcelVersionNo<15,checkisformula(D18),_xlfn.ISFORMULA(D18))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(E18),_xlfn.ISFORMULA(E18))","v":true}]
[null,{"$f":"IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nIF(TypeOfSQLLicense=\"VM-SQL\",\"Dedicated SQL VM Machine\",\"Windows VM for SQL w/License Mobility\"),\nIF(TypeOfSQLLicense<>\"PERP\",\"Windows SQL VM Machine\",\"Windows VM Machine\")),\"\")","v":"Windows VM Machine"},{"$f":"IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nIF(TypeOfSQLLicense=\"VM-SQL\",SQLServerType & \"-\"& MID(VM,4,2),\"VM-\"&MID(VM,4,2)),\nIF(TypeOfSQLLicense<>\"VM-SQL\",\"VM-\"&MID(VM,4,2),\"VM-\"&MID(VM,4,2))),\"\")","v":"VM-A2"},{"$f":"IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",(IF(AzureSLA=\"Yes\",2,1)),0),\"\")","v":0},{"$f":"IFERROR(INDEX(AzurePricing!A3:N86,(MATCH(ServerClass3Type,AzurePricing!A3:A86,0)),\nIF(AzureTier=\"Basic Tier\",MATCH(Currency,AzurePricing!A1:N1,0),MATCH(Currency,AzurePricing!A1:N1,0)+1)),\"\")","v":0.17999999999999997},{"$f":"IFERROR(D19*(E19*744),\"\")","v":0},{"$f":"IFERROR(IF(E19<>0.0001,IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nINDEX(AzurePricing!$A$99:$C$170,MATCH(C19,AzurePricing!$A$99:$A$170,0),2,1),\nINDEX(AzurePricing!$A$99:$C$170,MATCH(C19,AzurePricing!$A$99:$A$170,0),2,1)),\"Not available on Basic Tier\"),\"\")","v":"A2 Medium (2 cores, 3.5GB RAM)"},{"$f":"TEXT(ServerClass3Mth,CurrencySymbol&\"#,###\")","v":"$"},"ERP SPLA","Dynamics ERP SPLA License",{"$f":"DesktopCALs+WebClientCALs","v":3},{"$f":"IF(TypeOfERPLicence=\"SPLA\",K13,0)","v":0},{"$f":"IF(TypeOfERPLicence=\"SPLA\",K19*L19,0)","v":0},{"$f":"IF(ExcelVersionNo<15,checkisformula(C19),_xlfn.ISFORMULA(C19))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(D19),_xlfn.ISFORMULA(D19))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(E19),_xlfn.ISFORMULA(E19))","v":true}]
[null,"SQL Server Reporting Service (Optional)","SW-A1",{"$f":"IF(SRSServer=\"Yes\",1,0)","v":0},{"$f":"INDEX(AzurePricing!A3:N86,(MATCH(ServerClass4Type,AzurePricing!A3:A86,0)),\nIF(AzureTier=\"Basic Tier\",MATCH(Currency,AzurePricing!A1:N1,0),MATCH(Currency,AzurePricing!A1:N1,0)+1))","v":0.12199999999999998},{"$f":"D20*(E20*744)","v":0},{"$f":"INDEX(AzurePricing!$A$99:$C$170,MATCH(C20,AzurePricing!$A$99:$A$170,0),2,1)","v":"A1 Small (1 core, 1.75GB RAM)"},{"$f":"TEXT(ServerClass4Mth,CurrencySymbol&\"#,###\")","v":"$"},"Other","Partner added monthly services",{"$f":"DesktopCALs+WebClientCALs","v":3},0,{"$f":"IF(PartnerFeesOption=\"Yes\",K20*L20,0)","v":0},{"$f":"IF(ExcelVersionNo<15,checkisformula(C20),_xlfn.ISFORMULA(C20))","v":false},{"$f":"IF(ExcelVersionNo<15,checkisformula(D20),_xlfn.ISFORMULA(D20))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(E20),_xlfn.ISFORMULA(E20))","v":true}]
[null,"Additional Disk Storage","A-5GB",null,null,{"$f":"IF(ISERROR(FIND(\"5GB\",C21)),INDEX(AzurePricing!$A$93:$D$96,MATCH(C21,AzurePricing!$A$93:$A$96),4,1),0)","v":0},{"$f":"IF(ISERROR(FIND(\"5GB\",C21)),INDEX(AzurePricing!$A$93:$D$96,MATCH(C21,AzurePricing!$A$93:$A$96,0),2,1),\"First 5 GB Storage Free\")","v":"First 5 GB Storage Free"},null,"O365","Microsoft Office 365",{"$f":"IF(Office365=\"Yes\",IF(O365Users>0,O365Users,DesktopCALs+WebClientCALs),0)","v":0},{"$f":"IF(Office365=\"Yes\",O365PlanCost,0)","v":0},{"$f":"IF(Office365=\"Yes\",K21*L21,0)","v":0},{"$f":"IF(ExcelVersionNo<15,checkisformula(C21),_xlfn.ISFORMULA(C21))","v":false},{"$f":"IF(ExcelVersionNo<15,checkisformula(D21),_xlfn.ISFORMULA(D21))","v":false},{"$f":"IF(ExcelVersionNo<15,checkisformula(E21),_xlfn.ISFORMULA(E21))","v":false}]
[null,"Dedicated Remote Desktop Server",{"$f":"IF(AND(DesktopCALs>RDSUserCount,RDServices=\"Yes\"),ServerClass1Type,\"\")","v":""},{"$f":"IF(AND(DesktopCALs>5,RDServices=\"Yes\"),1,\"\")","v":""},{"$f":"IFERROR(INDEX(AzurePricing!A3:N86,(MATCH(ServerClass5Type,AzurePricing!A3:A86,0)),\nIF(AzureTier=\"Basic Tier\",MATCH(Currency,AzurePricing!A1:N1,0),MATCH(Currency,AzurePricing!A1:N1,0)+1)),\"\")","v":""},{"$f":"IFERROR(D22*(E22*744),\"\")","v":""},{"$f":"IF(ISNA(INDEX(AzurePricing!$A$99:$C$170,MATCH(C22,AzurePricing!$A$99:$A$170,0),2,1)),\"\",INDEX(AzurePricing!$A$99:$C$170,MATCH(C22,AzurePricing!$A$99:$A$170,0),2,1))","v":""},{"$f":"TEXT(ServerClass5Mth,CurrencySymbol&\"#,###\")","v":""},"CRMOL","Microsoft CRM Online",{"$f":"IF(CRMOLOption=\"Yes\",IF(CRMOLUsers>0,CRMOLUsers,DesktopCALs+WebClientCALs),0)","v":0},{"$f":"IF(CRMOLOption=\"Yes\",CRMOLPlanCost,0)","v":0},{"$f":"IF(CRMOLOption=\"Yes\",K22*L22,0)","v":0},{"$f":"IF(ExcelVersionNo<15,checkisformula(C22),_xlfn.ISFORMULA(C22))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(D22),_xlfn.ISFORMULA(D22))","v":true},{"$f":"IF(ExcelVersionNo<15,checkisformula(E22),_xlfn.ISFORMULA(E22))","v":true}]
[null,null,null,null,null,null,null,null,"Upfront",{"$f":"IF(TypeOfERPLicence=\"SPLA\",\"Partner License & Implementation\",\"Partner License & Implementation\")","v":"Partner License & Implementation"},null,{"$f":"IF(PartnerFeesOption=\"Yes\",PartnerFees,0)","v":0},{"$f":"IF(PartnerFeesOption=\"Yes\",K15,0)","v":0}]
[null,{"$f":"\"4 Year Cost Model on Azure - Year 1:   \"&TEXT(AzureCostYear1,CurrencySymbol&\"##,##0\")&\"   Year 2:   \"&TEXT(AzureCostYear2,CurrencySymbol&\"##,##0\")&\"   Year 3:   \"&TEXT(AzureCostYear3,CurrencySymbol&\"##,##0\")&\"   Year 4:   \"&TEXT(AzureCostYear4,CurrencySymbol&\"##,##0\")&\" -  Total 4 Year Investment: \"&TEXT(ROUNDUP(SUM(AzureCostYear1,AzureCostYear2,AzureCostYear3,AzureCostYear4),0)+FinanceTotal,CurrencySymbol&\"##,##0\")","v":"4 Year Cost Model on Azure - Year 1:   $1,607   Year 2:   $1,607   Year 3:   $1,607   Year 4:   $1,607 -  Total 4 Year Investment: $6,429"},null,null,null,null,null,null,{"$f":"\"Azure Only Model Estimate Per Year:  \" &CHAR(10)  & TEXT(SUM($F$17:$F$22)*AzureRunHoursDiscount*12,CurrencySymbol&\"#,##0\") & \"    Monthly:  \" &CHAR(10)  & TEXT(SUM($F$17:$F$22)*AzureRunHoursDiscount,CurrencySymbol&\"#,##0\")","v":"Azure Only Model Estimate Per Year:  \n$1,607    Monthly:  \n$134"},null,null,null,{"$f":"SUM(F17:F22)*H6 +SUM(M18:M22)","v":133.91999999999999}]
[null,"* Note: Microsoft Azure prices do change periodically.  ",null,null,null,null,null,null,null,null,null,"Last Model\nDelta (4 YR)",{"$f":"MthUserTotal*48-N25+M23","v":0},6428.16]
[null,{"$f":"\"It is important for you to confirm that you have the most current Azure prices.  The 'as of' prices in this calculator are \" & TEXT(AzureUpdateDate,\"mm/dd/yyyy  HH:MM AM/PM\")","v":"It is important for you to confirm that you have the most current Azure prices.  The 'as of' prices in this calculator are 02/12/2015  02:47 PM"}]
[null,"Disclaimer: This tool is provided for informational purposes only and subject to further changes and modifications.  Microsoft makes no warranties, express or implied, as to the tool and any results generated from the tool.",null,null,null,null,null,null,null,null,null,null,{"$f":"\" v3.3.7:\" & ExcelVersion()","v":" v3.3.7:15.0"}]
[]
[]
[]
[]
[]
[]
[]
[null,"Finance Yearly Recap",{"$f":"IF(AND(FinanceOption=\"Yes\",FinancePeriod>11),FinanceMthPayment*12,0)","v":0},{"$f":"IF(AND(FinanceOption=\"Yes\",FinancePeriod>23),FinanceMthPayment*12,0)","v":0},{"$f":"IF(AND(FinanceOption=\"Yes\",FinancePeriod>35),FinanceMthPayment*12,0)","v":0},{"$f":"IF(AND(FinanceOption=\"Yes\",FinancePeriod>47),FinanceMthPayment*12,0)","v":0},{"$f":"SUM(C35:F35)","v":0}]

{"sheet":"ProspectWorksheet","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"PartnerName&\" Microsoft Cloud Planning Model for \"   &\":    \"&DesktopCALs+WebClientCALs&\" Dynamics \" & BaseProduct  & \" users\" & \" for \" & CustomerName","v":"Contoso Solutions Inc. Microsoft Cloud Planning Model for :    3 Dynamics GP users for Sample ERP 3 Users"}]
[null,"Microsoft Azure Resources Schedule","Type","Qty","Cost /\nHr.","Cost per Month","Azure Resource Description"]
[null,{"$f":"AzureModeler!B17","v":"Windows VM - Assume SQL License Mobility"},{"$f":"AzureModeler!C17","v":"VM-A2"},{"$f":"AzureModeler!D17","v":1},{"$f":"AzureModeler!E17","v":0.17999999999999997},{"$f":"AzureModeler!F17","v":133.91999999999999},{"$f":"AzureModeler!G17","v":"A2 Medium (2 cores, 3.5GB RAM)"}]
[null,{"$f":"AzureModeler!B18","v":"Windows VM 2"},{"$f":"AzureModeler!C18","v":"VM-A1"},{"$f":"AzureModeler!D18","v":0},{"$f":"AzureModeler!E18","v":8.9999999999999983E-2},{"$f":"AzureModeler!F18","v":0},{"$f":"AzureModeler!G18","v":"A1 Small (1 core, 1.75GB RAM)"}]
[null,{"$f":"AzureModeler!B19","v":"Windows VM Machine"},{"$f":"AzureModeler!C19","v":"VM-A2"},{"$f":"AzureModeler!D19","v":0},{"$f":"AzureModeler!E19","v":0.17999999999999997},{"$f":"AzureModeler!F19","v":0},{"$f":"AzureModeler!G19","v":"A2 Medium (2 cores, 3.5GB RAM)"}]
[null,{"$f":"AzureModeler!B20","v":"SQL Server Reporting Service (Optional)"},{"$f":"AzureModeler!C20","v":"SW-A1"},{"$f":"AzureModeler!D20","v":0},{"$f":"AzureModeler!E20","v":0.12199999999999998},{"$f":"AzureModeler!F20","v":0},{"$f":"AzureModeler!G20","v":"A1 Small (1 core, 1.75GB RAM)"}]
[null,{"$f":"AzureModeler!B22","v":"Dedicated Remote Desktop Server"},{"$f":"AzureModeler!C22","v":""},{"$f":"AzureModeler!D22","v":""},{"$f":"AzureModeler!E22","v":""},{"$f":"AzureModeler!F22","v":""},{"$f":"AzureModeler!G22","v":""}]
[null,{"$f":"AzureModeler!B21","v":"Additional Disk Storage"},{"$f":"AzureModeler!C21","v":"A-5GB"},{"$f":"AzureModeler!D21","v":0},{"$f":"AzureModeler!E21","v":0},{"$f":"AzureModeler!F21","v":0},{"$f":"AzureModeler!G21","v":"First 5 GB Storage Free"}]
[null,null,null,{"$f":"SUM(D4:D9)","v":1},null,{"$f":"SUM(F4:F9)*AzureRunHoursDiscount","v":133.91999999999999},{"$f":"\"Totals adjusted for \" & DailyRunHours & \" hours to run per day\"","v":"Totals adjusted for 24 hours to run per day"}]
[]
[null,{"$f":"\"Dynamics \" & BaseProduct  & \" License & Other Monthly Service Options:\"","v":"Dynamics GP License & Other Monthly Service Options:"},{"$f":"TEXT(SUM(AzureModeler!M18:M23),CurrencySymbol & \"###0\")","v":"$0"},null,null,null,{"$f":"AzureModeler!B3","v":"Monthly Azure :  $45  Non-Azure :   $0"}]
[null,"Optional addin services per user per month",null,null,"Users","Cost/Mth","Description"]
[null,{"$f":"AzureModeler!I18","v":"RDS SPLA"},null,null,{"$f":"AzureModeler!K18","v":3},{"$f":"AzureModeler!L18","v":0},{"$f":"AzureModeler!J18","v":"Remote Desktop Services"}]
[null,{"$f":"AzureModeler!I19","v":"ERP SPLA"},null,null,{"$f":"AzureModeler!K19","v":3},{"$f":"AzureModeler!L19","v":0},{"$f":"AzureModeler!J19","v":"Dynamics ERP SPLA License"}]
[null,{"$f":"AzureModeler!I20","v":"Other"},null,null,{"$f":"AzureModeler!K20","v":3},{"$f":"AzureModeler!L20","v":0},{"$f":"AzureModeler!J20","v":"Partner added monthly services"}]
[null,{"$f":"AzureModeler!I21","v":"O365"},null,null,{"$f":"AzureModeler!K21","v":0},{"$f":"AzureModeler!L21","v":0},{"$f":"AzureModeler!J21","v":"Microsoft Office 365"}]
[null,{"$f":"AzureModeler!I22","v":"CRMOL"},null,null,{"$f":"AzureModeler!K22","v":0},{"$f":"AzureModeler!L22","v":0},{"$f":"AzureModeler!J22","v":"Microsoft CRM Online"}]
[null,{"$f":"AzureModeler!I23","v":"Upfront"},null,null,{"$f":"AzureModeler!K23","v":0},{"$f":"AzureModeler!L23","v":0},{"$f":"AzureModeler!J23","v":"Partner License & Implementation"}]
[null,{"$f":"AzureModeler!B24","v":"4 Year Cost Model on Azure - Year 1:   $1,607   Year 2:   $1,607   Year 3:   $1,607   Year 4:   $1,607 -  Total 4 Year Investment: $6,429"}]

{"sheet":"Settings","index":2,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Settings for Azure Modeler","Settings","Selected ERP >>>>",{"$f":"BaseProduct","v":"GP"},"Size","Dynamics ERP Server\n Sizing Matrix Options","User # Lower Limit","Users # Upper Limit","Separate SQL Server",null,null,null,null,null,null,"Formula Refresh"]
["Partner Name","Contoso Solutions Inc.","Yes","GP-S","  Small","VM-A2",1,3,"No",null,null,null,null,"AUD","$","=IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nVM,\nIF(TypeOfSQLLicense<>\"VM-SQL\",VM,SQLServerType &\"-\"  & MID(D12,4,2))),\"\")","=IF(AzureSLA=\"Yes\",2,1)"]
["Create Mail","Yes","No","GP-M"," Medium","VM-A3",4,7,"Yes",null,null,null,null,"CAD","$",null,"=IF(DomainController=\"No\",0,IF(AzureSLA=\"Yes\",2,1))"]
["Prospect Worksheet Range to Copy for Mail","B2:G21",null,"GP-L","Large","VM-A3",8,20,"Yes",null,null,null,null,"Euro","€","=IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",\nIF(TypeOfSQLLicense=\"VM-SQL\",SQLServerType & \"-\"& MID(VM,4,2),\"VM-\"&MID(VM,4,2)),\nIF(TypeOfSQLLicense<>\"VM-SQL\",\"VM-\"&MID(VM,4,2),\"VM-\"&MID(VM,4,2))),\"\")","=IFERROR(IF(VLOOKUP(AdjustedCALs,MachineIndex,3,TRUE)=\"Yes\",(IF(AzureSLA=\"Yes\",2,1)),0),\"\")"]
["Print TCO Recap on mail","Yes",null,"GP-XL","XLarge","VM-A5",21,40,"Yes",null,null,null,null,"Pound","£",null,"=IF(SRSServer=\"Yes\",1,0)"]
["TCO Print Range ","A1:G42",null,"SL-S","  Small","VM-A2",1,9,"No",null,null,null,null,"USD","$","=IF(AND(DesktopCALs>RDSUserCount,RDServices=\"Yes\"),ServerClass1Type,\"\")","=IF(AND(DesktopCALs>5,RDServices=\"Yes\"),1,\"\")"]
["Print Topology on mail","Yes",null,"SL-M"," Medium","VM-A2",6,10,"Yes",null,null,null,null,"ZAR","R ",null,"=ERPUserCount"]
["Include Topology Range","A1:K52",null,"SL-L","Large","VM-A3",11,20,"Yes",null,null,null,null,null,null,null,"=ERPUserCount"]
["Print TCO Graphs on mail","Yes",null,"SL-XL","XLarge","VM-A4",21,40,"Yes"]
["TCO Graph Range","A25:G47",null,"NAV-S","  Small","VM-A3",1,5,"No"]
["Longterm & Workload Cost Range","A42:G55",null,"NAV-M"," Medium","VM-A3",6,10,"Yes"]
["Create PowerPoint Proposal","No",null,"NAV-L","Large","VM-A3",11,20,"Yes"]
["PowerPoint Proposal Intro Slide Number",2,null,"NAV-XL","XLarge","VM-A4",21,40,"Yes"]
["Add Content Links to Mail","Yes",null,"AX-S","  Small","VM-A3",1,5,"Yes"]
["Template","Azure-Modeler-template.oft",null,"AX-M"," Medium","VM-A3",6,10,"Yes"]
["Prompt for Template Export","Yes",null,"AX-L","Large","VM-A4",11,20,"Yes"]
["Prompt to Print Previous Model Details","Yes",null,"AX-XL","XLarge","VM-A5",21,40,"Yes"]
["Remote Desktop Server Count",9,null,"CRM-S","  Small","VM-A2",1,5,"Yes"]
["SaaS Monthly Per User",300,null,"CRM-M"," Medium","VM-A3",6,10,"Yes"]
["SaaS Compete Setup Cost",1000,null,"CRM-L","Large","VM-A4",11,20,"Yes"]
["SaaS Compete Implementation",5000,null,"CRM-XL","XLarge","VM-A5",21,40,"Yes"]
["Standard Dynamics ERP Implementation",5000]
["Start up with Guide Me","No",null,null,{"$f":"\"Azure Server Mapping for Dynamics \" & BaseProduct","v":"Azure Server Mapping for Dynamics GP"}]
["Currency Symbol",{"$f":"VLOOKUP(Currency,N2:O10,2,TRUE)","v":"$"},null,null,{"$f":"INDEX($E$2:$I$21,MATCH((D1&\"-S\"),$D$2:$D$21,0),1)","v":"  Small"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-S\"),$D$2:$D$21,0),2)","v":"VM-A2"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-S\"),$D$2:$D$21,0),3)","v":1},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-S\"),$D$2:$D$21,0),4)","v":3},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-S\"),$D$2:$D$21,0),5)","v":"No"}]
[null,null,null,null,{"$f":"INDEX($E$2:$I$21,MATCH((D1&\"-M\"),$D$2:$D$21,0),1)","v":" Medium"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-M\"),$D$2:$D$21,0),2)","v":"VM-A3"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-M\"),$D$2:$D$21,0),3)","v":4},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-M\"),$D$2:$D$21,0),4)","v":7},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-M\"),$D$2:$D$21,0),5)","v":"Yes"}]
["AzurePriceUpdateSheet","https://dl-web.dropbox.com/s/85g4yax628kmzvf/rateschduleimport.xlsx?dl=1",null,null,{"$f":"INDEX($E$2:$I$21,MATCH((D1&\"-L\"),$D$2:$D$21,0),1)","v":"Large"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-L\"),$D$2:$D$21,0),2)","v":"VM-A3"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-L\"),$D$2:$D$21,0),3)","v":8},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-L\"),$D$2:$D$21,0),4)","v":20},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-L\"),$D$2:$D$21,0),5)","v":"Yes"}]
["Last Azure Update Date","2015-02-12T14:47:21",null,null,{"$f":"INDEX($E$2:$I$21,MATCH((D1&\"-XL\"),$D$2:$D$21,0),1)","v":"XLarge"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-XL\"),$D$2:$D$21,0),2)","v":"VM-A5"},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-XL\"),$D$2:$D$21,0),3)","v":21},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-XL\"),$D$2:$D$21,0),4)","v":40},{"$f":"INDEX($E$2:$I$21,MATCH(($D$1&\"-XL\"),$D$2:$D$21,0),5)","v":"Yes"}]
["Azure Resources Update Sheet","https://dl.dropbox.com/s/7tu0r66oce77nd9/AzureResources.xlsx?dl=1"]
["Last Azure Resources Update Date","2015-02-14T12:44:05"]
[]
[]
["Base Prosposal Name"]
["Local OneDrive Synch File Location",null,""]
[]
[]
[]
[]
["Cloud Survey Questions:"]
["Understand existing on premise and cloud topology by workloads. Beginning with ERP/CRM."]
["Determine knowledge/experience of cloud today at both IT and Business level"]
["What are the key business drives in the next two years"]
["Determine what is driving interest in the cloud today"]
["What is the level of interest in cloud from the IT organization today. Are there any Cloud iniatives today"]
["what length of time are the seeking for having the solution hosted?"]
["What ERP system are the using today and for how long?"]
["Do they use a CRM system today?"]
["Are there any upcoming key events or projects in the next 12-24 months?"]
["Do they have any hardware upgrades/replacement in the next 12-24 months?"]
["What other technology platforms are in use on premise today?"]
["Do they want to co-manage their cloud solutions/"]
["What version of Office/Productivity apps do their users use today?"]
["Would they consider putting desktop productivity (MS Office license) into a monthly price for all users?"]
["What are their ERP operational hours?"]
["Do they need failover/redundancy?  Do they need to meet a SLA?"]
["Who is be involved in the decision to move to the cloud?"]
[]
[]
["Cloud Positioning"]
["Position Microsoft Cloud options and strengths during the discussion:"]
[" End to End cloud solutions of Microsoft  - highlight limited scope of point solution  SaaS solutions"]
["Deep long term experience with the cloud and with ERP"]
["Hybrid cloud strengths and staged migration"]
["Existing knowledge of Microsoft platform scales in the Microsoft cloud"]
["Don’t lead with individual products lead with the Cloud platform and leverage the breadth thru the workloads we can move the cloud."]
["Long term TCO investment of balancing licensing options with Dynamics ERP and CRM ( Buy vs Lease) the business applications license"]
["Leverage case studies of customer success with Office 365, CRM OnLine and Dynamics Cloud stories"]
["Model TCO (with Azure Modeler for Business Workloads ) options with the customer and point to flexibility and breadth of solutions"]
["Don’t sell. Be consultative and adaptable to right size the Microsoft Cloud options."]
["safd asf asfasfasfdasf"]

{"sheet":"AzurePricing","index":3,"n_rows":170,"n_cols":27,"rows_kept":170,"cut":false,"hidden":false,"merged":[]}
["Machine",{"$f":"\"Azure Resource List as of \" & TEXT(AzureResourceUpdateDate,\"mm/dd/yyyy HH:MM AM/PM\")","v":"Azure Resource List as of 02/12/2015 02:47 PM"},"USD",null,"CAD",null,"Pound",null,"Euro",null,"AUD",null,"ZAR"]
["Options",null,"Basic Tier","Standard Tier","Basic Tier","Standard Tier","Basic Tier","Standard Tier","Basic Tier","Standard Tier","Basic Tier","Standard Tier","Basic Tier","Standard Tier"]
["VM-A0","A0 Extra Small (1 core, 0.75GB RAM)",1.7999999999999999E-2,0.02,1.8980999999999998E-2,2.1090000000000001E-2,1.0996199999999999E-2,1.2218E-2,1.3404599999999999E-2,1.4894000000000001E-2,1.8163800000000001E-2,2.0182000000000002E-2,0.20519999999999999,0.22800000000000001,null,null,null,null,null,null,null,null,null,null,null,null,"USD"]
["VM-A1","A1 Small (1 core, 1.75GB RAM)",7.5499999999999998E-2,8.9999999999999983E-2,7.9614749999999998E-2,9.4904999999999975E-2,4.6122949999999996E-2,5.4980999999999988E-2,5.622485E-2,6.7022999999999985E-2,7.6187050000000006E-2,9.0818999999999997E-2,0.92340000000000011,1.0259999999999998,null,null,null,null,null,null,null,null,null,null,null,null,"CAD"]
["VM-A2","A2 Medium (2 cores, 3.5GB RAM)",0.151,0.17999999999999997,0.1592295,0.18980999999999995,9.2245899999999992E-2,0.10996199999999998,0.1124497,0.13404599999999997,0.15237410000000001,0.18163799999999999,1.8468000000000002,2.0519999999999996,null,null,null,null,null,null,null,null,null,null,null,null,"Pound"]
["VM-A3","A3 Large (4 cores, 7GB RAM)",0.30199999999999999,0.35999999999999993,0.31845899999999999,0.3796199999999999,0.18449179999999998,0.21992399999999995,0.2248994,0.26809199999999994,0.30474820000000002,0.36327599999999999,3.6936000000000004,4.1039999999999992,null,null,null,null,null,null,null,null,null,null,null,null,"Euro"]
["VM-A4","A4 Extra Large (8 cores, 14GB RAM)",0.60399999999999998,0.71999999999999986,0.63691799999999998,0.7592399999999998,0.36898359999999997,0.43984799999999991,0.4497988,0.53618399999999988,0.60949640000000005,0.72655199999999998,7.3872000000000009,8.2079999999999984,null,null,null,null,null,null,null,null,null,null,null,null,"AUD"]
["VM-A5","A5 (2 cores, 14GB RAM)",1E-4,0.32,1.0545E-4,0.33744000000000002,1E-4,0.195488,1E-4,0.23830400000000002,1E-4,0.32291200000000003,1E-4,3.8760000000000003,null,null,null,null,null,null,null,null,null,null,null,null,"ZAR"]
["VM-A6","A6 (4 cores, 28GB RAM)",1E-4,0.64,1.0545E-4,0.67488000000000004,1E-4,0.39097599999999999,1E-4,0.47660800000000003,1E-4,0.64582400000000006,1E-4,7.7520000000000007]
["VM-A7","A7 (8 cores, 56GB RAM)",1E-4,1.28,1.0545E-4,1.3497600000000001,1E-4,0.78195199999999998,1E-4,0.95321600000000006,1E-4,1.2916480000000001,1E-4,15.504000000000001]
["VM-A8","A8 (8 cores, 56GB RAM)",1E-4,2.4500000000000002,1.0545E-4,2.5835250000000003,1E-4,1.4967050000000002,1E-4,1.8245150000000001,1E-4,2.4722950000000004,1E-4,27.930000000000003]
["VM-A9","A9 (16 cores, 112GB RAM)",1E-4,4.9000000000000004,1.0545E-4,5.1670500000000006,1E-4,2.9934100000000003,1E-4,3.6490300000000002,1E-4,4.9445900000000007,1E-4,55.860000000000007]
["VM-D1","D1 (1 core, 3.5GB RAM)",0.13666666666666669,0.16700000000000001,0.14411500000000002,0.17610150000000002,8.3489666666666684E-2,0.10202030000000001,0.10177566666666668,0.12436490000000001,0.13791033333333336,0.16851970000000002,1.71,2.0861999999999998]
["VM-D2","D2 (2 cores, 7GB RAM)",0.27333333333333337,0.33400000000000002,0.28823000000000004,0.35220300000000004,0.16697933333333337,0.20404060000000002,0.20355133333333336,0.24872980000000003,0.27582066666666671,0.33703940000000004,3.42,4.1723999999999997]
["VM-D3","D3 (4 cores, 14GB RAM)",0.54666666666666675,0.66800000000000004,0.57646000000000008,0.70440600000000009,0.33395866666666674,0.40808120000000003,0.40710266666666672,0.49745960000000006,0.55164133333333343,0.67407880000000009,6.84,8.3447999999999993]
["VM-D4","D4 (8 cores, 28GB RAM)",1.0933333333333335,1.3360000000000001,1.1529200000000002,1.4088120000000002,0.66791733333333347,0.81616240000000007,0.81420533333333345,0.99491920000000011,1.1032826666666669,1.3481576000000002,13.68,16.689599999999999]
["VM-D11","D11 (2 cores, 14GB RAM)",0.32,0.39066666666666672,0.33744000000000002,0.41195800000000005,0.195488,0.2386582666666667,0.23830400000000002,0.29092946666666669,0.32291200000000003,0.39422173333333344,27.36,4.7994000000000003]
["VM-D12","D12 (4 cores, 28GB RAM)",0.64,0.78133333333333344,0.67488000000000004,0.82391600000000009,0.39097599999999999,0.4773165333333334,0.47660800000000003,0.58185893333333338,0.64582400000000006,0.78844346666666687,7.8659999999999997,9.5988000000000007]
["VM-D13","D13 (8 cores, 56GB RAM)",1.1519999999999999,1.406666666666667,1.2147839999999999,1.4833300000000003,0.70375679999999996,0.85933266666666686,0.85789439999999995,1.047544666666667,1.1624832,1.4194673333333339,14.158800000000001,17.282399999999999]
["VM-D14","D14 (16 cores, 112GB RAM)",2.0733333333333333,2.5313333333333339,2.1863299999999999,2.6692910000000007,1.2665993333333332,1.5463915333333336,1.5440113333333334,1.8850839333333338,2.0922006666666668,2.5543684666666673,25.490400000000005,31.099200000000003]
["SE-A0","A0 Extra Small (1 core, 0.75GB RAM)",1.518,1.52,1.6007309999999999,1.60284,0.92734620000000001,0.92856800000000006,1.1304546,1.1319440000000001,1.5318138000000001,1.5338320000000001,17.305200000000003,17.328000000000003]
["SE-A1","A1 Small (1 core, 1.75GB RAM)",1.5754999999999999,1.59,1.6613647499999999,1.676655,0.96247294999999988,0.97133100000000006,1.1732748499999999,1.1840730000000002,1.5898370500000001,1.6044690000000001,18.023400000000002,18.126000000000001]
["SE-A2","A2 Medium (2 cores, 3.5GB RAM)",1.651,1.68,1.7409794999999999,1.77156,1.0085959,1.0263119999999999,1.2294997000000001,1.251096,1.6660241000000002,1.6952880000000001,18.946800000000003,19.152000000000001]
["SE-A3","A3 Large (4 cores, 7GB RAM)",1.802,1.8599999999999999,1.900209,1.9613699999999998,1.1008418,1.136274,1.3419494000000001,1.3851419999999999,1.8183982000000003,1.8769260000000001,20.793600000000001,21.204000000000001]
["SE-A4","A4 Extra Large (8 cores, 14GB RAM)",3.6040000000000001,3.7199999999999998,3.8004180000000001,3.9227399999999997,2.2016836,2.272548,2.6838988000000001,2.7702839999999997,3.6367964000000006,3.7538520000000002,41.587200000000003,42.408000000000001]
["SE-A5","A5 (2 cores, 14GB RAM)",1E-4,1.82,1E-4,1.91919,1E-4,1.1118380000000001,1E-4,1.3553540000000002,1E-4,1.8365620000000002,1E-4,20.976000000000003]
["SE-A6","A6 (4 cores, 28GB RAM)",1E-4,2.14,1E-4,2.2566299999999999,1E-4,1.307326,1E-4,1.5936580000000002,1E-4,2.1594740000000003,1E-4,24.852000000000004]
["SE-A7","A7 (8 cores, 56GB RAM)",1E-4,4.28,1E-4,4.5132599999999998,1E-4,2.614652,1E-4,3.1873160000000005,1E-4,4.3189480000000007,1E-4,49.704000000000008]
["SE-A8","A8 (8 cores, 56GB RAM)",1E-4,5.45,1E-4,5.7470249999999998,1E-4,3.3294049999999999,1E-4,4.0586150000000005,1E-4,5.4995950000000011,1E-4,62.13000000000001]
["SE-A9","A9 (16 cores, 112GB RAM)",1E-4,10.9,1E-4,11.49405,1E-4,6.6588099999999999,1E-4,8.1172300000000011,1E-4,10.999190000000002,1E-4,124.26000000000002]
["SE-D1","D1 (1 core, 3.5GB RAM)",1.6366666666666667,1.667,1.725865,1.7578515000000001,0.99983966666666668,1.0183703,1.2188256666666668,1.2414149000000001,1.6515603333333335,1.6821697000000002,18.810000000000002,19.186199999999999]
["SE-D2","D2 (2 cores, 7GB RAM)",1.7733333333333334,1.8340000000000001,1.8699800000000002,1.933953,1.0833293333333334,1.1203906000000001,1.3206013333333335,1.3657798000000001,1.7894706666666669,1.8506894000000003,20.520000000000003,21.272400000000001]
["SE-D3","D3 (4 cores, 14GB RAM)",2.0466666666666669,2.1680000000000001,2.1582100000000004,2.2861560000000001,1.2503086666666667,1.3244312,1.5241526666666669,1.6145096000000001,2.0652913333333336,2.1877288000000004,23.94,25.444800000000001]
["SE-D4","D4 (8 cores, 28GB RAM)",4.0933333333333337,4.3360000000000003,4.3164200000000008,4.5723120000000002,2.5006173333333335,2.6488624000000001,3.0483053333333339,3.2290192000000002,4.1305826666666672,4.3754576000000007,47.88,50.889600000000002]
["SE-D11","D11 (2 cores, 14GB RAM)",1.82,1.8906666666666667,1.91919,1.993708,1.1118380000000001,1.1550082666666668,1.3553540000000002,1.4079794666666667,1.8365620000000002,1.9078717333333335,44.46,21.8994]
["SE-D12","D12 (4 cores, 28GB RAM)",2.14,2.2813333333333334,2.2566299999999999,2.4056660000000001,1.307326,1.3936665333333333,1.5936580000000002,1.6989089333333334,2.1594740000000003,2.3020934666666668,24.966000000000001,26.698800000000002]
["SE-D13","D13 (8 cores, 56GB RAM)",4.1520000000000001,4.4066666666666672,4.3782839999999998,4.6468300000000005,2.5364568000000003,2.692032666666667,3.0919944000000004,3.2816446666666672,4.1897832000000008,4.4467673333333346,48.358800000000002,51.482399999999998]
["SE-D14","D14 (16 cores, 112GB RAM)",1E-4,8.5313333333333343,1E-4,8.9962910000000011,1E-4,5.2117915333333338,1E-4,6.3532839333333344,1E-4,8.6089684666666688,0,99.499200000000002]
["SS-A0","A0 Extra Small (1 core, 0.75GB RAM)",0.41800000000000004,0.42000000000000004,0.44078100000000003,0.44289000000000006,0.25535620000000003,0.25657800000000003,0.31128460000000002,0.31277400000000005,0.42180380000000006,0.42382200000000009,4.7652000000000001,4.7880000000000003]
["SS-A1","A1 Small (1 core, 1.75GB RAM)",0.47550000000000003,0.49,0.50141475000000002,0.51670499999999997,0.29048295000000002,0.29934099999999997,0.35410485000000003,0.36490300000000003,0.47982705000000009,0.49445900000000004,5.4834000000000005,5.5860000000000003]
["SS-A2","A2 Medium (2 cores, 3.5GB RAM)",0.55100000000000005,0.57999999999999996,0.58102950000000009,0.61160999999999999,0.33660590000000001,0.35432199999999997,0.41032970000000007,0.43192599999999998,0.55601410000000007,0.58527800000000008,6.4068000000000005,6.6120000000000001]
["SS-A3","A3 Large (4 cores, 7GB RAM)",0.70199999999999996,0.76,0.740259,0.80142000000000002,0.42885179999999995,0.46428400000000003,0.52277940000000001,0.56597200000000003,0.70838820000000002,0.76691600000000004,8.2536000000000005,8.6639999999999997]
["SS-A4","A4 Extra Large (8 cores, 14GB RAM)",1.4039999999999999,1.52,1.480518,1.60284,0.8577035999999999,0.92856800000000006,1.0455588,1.1319440000000001,1.4167764,1.5338320000000001,16.507200000000001,17.327999999999999]
["SS-A5","A5 (2 cores, 14GB RAM)",1E-4,0.72,1E-4,0.75923999999999991,1E-4,0.43984799999999996,1E-4,0.53618399999999999,1E-4,0.72655200000000009,1E-4,8.4359999999999999]
["SS-A6","A6 (4 cores, 28GB RAM)",1E-4,1.6800000000000002,1E-4,1.7715600000000002,1E-4,1.0263120000000001,1E-4,1.2510960000000002,1E-4,1.6952880000000004,1E-4,20.064]
["SS-A7","A7 (8 cores, 56GB RAM)",1E-4,2.08,1E-4,2.1933600000000002,1E-4,1.270672,1E-4,1.5489760000000001,1E-4,2.0989280000000003,1E-4,24.624000000000002]
["SS-A8","A8 (8 cores, 56GB RAM)",1E-4,3.25,1E-4,3.4271250000000002,1E-4,1.985425,1E-4,2.4202750000000002,1E-4,3.2795750000000004,1E-4,37.050000000000004]
["SS-A9","A9 (16 cores, 112GB RAM)",1E-4,6.5,1E-4,6.8542500000000004,1E-4,3.97085,1E-4,4.8405500000000004,1E-4,6.5591500000000007,1E-4,74.100000000000009]
["SS-D1","D1 (1 core, 3.5GB RAM)",0.53666666666666674,0.56700000000000006,0.56591500000000006,0.59790150000000009,0.32784966666666671,0.34638030000000003,0.39965566666666674,0.42224490000000003,0.54155033333333347,0.57215970000000016,6.2700000000000005,6.6462000000000003]
["SS-D2","D2 (2 cores, 7GB RAM)",0.67333333333333334,0.73399999999999999,0.71003000000000005,0.774003,0.41133933333333333,0.44840059999999998,0.50143133333333334,0.54660980000000003,0.67946066666666671,0.7406794000000001,7.98,8.7324000000000002]
["SS-D3","D3 (4 cores, 14GB RAM)",0.94666666666666677,1.0680000000000001,0.99826000000000015,1.126206,0.57831866666666676,0.65244120000000005,0.70498266666666676,0.79533960000000004,0.95528133333333354,1.0777188000000002,11.4,12.9048]
["SS-D4","D4 (8 cores, 28GB RAM)",1.8933333333333335,2.1360000000000001,1.9965200000000003,2.2524120000000001,1.1566373333333335,1.3048824000000001,1.4099653333333335,1.5906792000000001,1.9105626666666671,2.1554376000000004,22.8,25.8096]
["SS-D11","D11 (2 cores, 14GB RAM)",0.72,0.79066666666666674,0.75923999999999991,0.83375800000000011,0.43984799999999996,0.4830182666666667,0.53618399999999999,0.58880946666666678,0.72655200000000009,0.79786173333333354,31.92,9.3594000000000008]
["SS-D12","D12 (4 cores, 28GB RAM)",1.04,1.1813333333333333,1.0966800000000001,1.245716,0.63533600000000001,0.72167653333333337,0.77448800000000007,0.87973893333333342,1.0494640000000002,1.1920834666666669,12.426,14.158800000000001]
["SS-D13","D13 (8 cores, 56GB RAM)",1.552,2.206666666666667,1.636584,2.3269300000000004,0.94811679999999998,1.3480526666666668,1.1557744000000001,1.6433046666666671,1.5661232000000003,2.2267473333333339,23.278800000000004,26.4024]
["SS-D14","D14 (16 cores, 112GB RAM)",1E-4,4.131333333333334,1E-4,4.356491000000001,1E-4,2.5238315333333339,1E-4,3.0766039333333337,1E-4,4.1689284666666682,1E-4,49.339200000000005]
["SW-A0","A0 Extra Small (1 core, 0.75GB RAM)",0.05,5.2000000000000005E-2,5.2725000000000001E-2,5.4834000000000008E-2,3.0545000000000003E-2,3.1766800000000005E-2,3.7235000000000004E-2,3.8724400000000006E-2,5.0455000000000007E-2,5.2473200000000012E-2,0.57000000000000006,0.59279999999999999]
["SW-A1","A1 Small (1 core, 1.75GB RAM)",0.1075,0.12199999999999998,0.11335874999999999,0.12864899999999999,6.5671750000000001E-2,7.4529799999999993E-2,8.0055250000000008E-2,9.0853399999999987E-2,0.10847825000000001,0.1231102,5.4834000000000005,1.3907999999999998]
["SW-A2","A2 Medium (2 cores, 3.5GB RAM)",0.183,0.21199999999999997,0.19297349999999999,0.22355399999999997,0.1117947,0.12951079999999998,0.13628010000000002,0.15787639999999997,0.1846653,0.21392919999999999,6.4068000000000005,2.4167999999999994]
["SW-A3","A3 Large (4 cores, 7GB RAM)",0.33399999999999996,0.3919999999999999,0.35220299999999993,0.4133639999999999,0.20404059999999999,0.23947279999999993,0.24872979999999997,0.29192239999999992,0.33703939999999999,0.39556719999999995,8.2536000000000005,4.468799999999999]
["SW-A4","A4 Extra Large (8 cores, 14GB RAM)",0.66799999999999993,0.78399999999999981,0.70440599999999987,0.8267279999999998,0.40808119999999998,0.47894559999999986,0.49745959999999995,0.58384479999999983,0.67407879999999998,0.7911343999999999,16.507200000000001,8.937599999999998]
["SW-A5","A5 (2 cores, 14GB RAM)",1E-4,0.35199999999999998,1E-4,0.37118399999999996,1E-4,0.2150368,1E-4,0.26213439999999999,1E-4,0.3552032,1E-4,4.2408000000000001]
["SW-A6","A6 (4 cores, 28GB RAM)",1E-4,0.67200000000000004,1E-4,0.70862400000000003,1E-4,0.41052480000000002,1E-4,0.50043840000000006,1E-4,0.67811520000000014,1E-4,8.1168000000000013]
["SW-A7","A7 (8 cores, 56GB RAM)",1E-4,1.3440000000000001,1E-4,1.4172480000000001,1E-4,0.82104960000000005,1E-4,1.0008768000000001,1E-4,1.3562304000000003,1E-4,16.233600000000003]
["SW-A8","A8 (8 cores, 56GB RAM)",1E-4,2.5140000000000002,1E-4,2.6510130000000003,1E-4,1.5358026000000002,1E-4,1.8721758000000002,1E-4,2.5368774000000007,1E-4,28.659600000000005]
["SW-A9","A9 (16 cores, 112GB RAM)",1E-4,5.0280000000000005,1E-4,5.3020260000000006,1E-4,3.0716052000000005,1E-4,3.7443516000000003,1E-4,5.0737548000000015,1E-4,57.319200000000009]
["SW-D1","D1 (1 core, 3.5GB RAM)",0.16866666666666669,0.19900000000000001,0.17785900000000002,0.20984550000000002,0.10303846666666668,0.1215691,0.12560606666666668,0.1481953,0.17020153333333338,0.20081090000000004,1.742,2.4509999999999996]
["SW-D2","D2 (2 cores, 7GB RAM)",0.30533333333333335,0.36599999999999999,0.32197400000000004,0.38594699999999998,0.18652813333333335,0.22358939999999999,0.22738173333333336,0.27256020000000003,0.30811186666666673,0.36933060000000001,3.452,4.5371999999999995]
["SW-D3","D3 (4 cores, 14GB RAM)",0.57866666666666677,0.70000000000000007,0.61020400000000008,0.73815000000000008,0.35350746666666671,0.42763000000000007,0.43093306666666675,0.52129000000000003,0.5839325333333335,0.70637000000000016,6.8719999999999999,8.7096]
["SW-D4","D4 (8 cores, 28GB RAM)",1.1573333333333335,1.4000000000000001,1.2204080000000002,1.4763000000000002,0.70701493333333343,0.85526000000000013,0.86186613333333351,1.0425800000000001,1.167865066666667,1.4127400000000003,13.744,17.4192]
["SW-D11","D11 (2 cores, 14GB RAM)",0.35199999999999998,0.42266666666666675,0.37118399999999996,0.4457020000000001,0.2150368,0.25820706666666671,0.26213439999999999,0.31475986666666672,0.3552032,0.42651293333333345,27.391999999999999,5.1642000000000001]
["SW-D12","D12 (4 cores, 28GB RAM)",0.67200000000000004,0.81333333333333346,0.70862400000000003,0.85766000000000009,0.41052480000000002,0.49686533333333344,0.50043840000000006,0.60568933333333341,0.67811520000000014,0.82073466666666683,7.8979999999999997,9.9636000000000013]
["SW-D13","D13 (8 cores, 56GB RAM)",1.216,1.470666666666667,1.2822719999999999,1.5508180000000003,0.74285440000000003,0.89843026666666692,0.9055552,1.0952054666666671,1.2270656000000002,1.4840497333333338,14.222800000000001,18.012]
["SW-D14","D14 (16 cores, 112GB RAM)",1E-4,2.659333333333334,1E-4,2.8042670000000007,1E-4,1.6245867333333337,1E-4,1.9804055333333339,1E-4,2.6835332666666676,1E-4,32.558400000000006]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bandwidth"]
["BW10","Bandwidth 10GB",1.9E-2,1.9E-2,1.9E-2,1.9E-2]
["BW20","Bandwidth 20GB",1.9E-2,1.9E-2,1.9E-2,1.9E-2,"  5  GB"]
[]
[null,"Disk Storage"]
["B-50GB","Page Blobs & Disks 50 GB",50,2.5,null,null," 50 GB"]
["C-100GB","Page Blobs & Disks 100 GB",100,5,null,null,"100 GB"]
["D-500GB","Page Blobs & Disks 500 GB",500,25,null,null,"500 GB"]
["E-1TB","Page Blobs & Disks 1 TB",1000,50,null,null,"1000 GB"]
[]
[null,"Alternate Lookup All VMs"]
["VM-A0","A0 Extra Small (1 core, 0.75GB RAM)"]
["VM-A1","A1 Small (1 core, 1.75GB RAM)"]
["VM-A2","A2 Medium (2 cores, 3.5GB RAM)"]
["VM-A3","A3 Large (4 cores, 7GB RAM)"]
["VM-A4","A4 Extra Large (8 cores, 14GB RAM)"]
["VM-A5","A5 (2 cores, 14GB RAM)"]
["VM-A6","A6 (4 cores, 28GB RAM)"]
["VM-A7","A7 (8 cores, 56GB RAM)"]
["VM-A8","A8 (8 cores, 56GB RAM)"]
["VM-A9","A9 (16 cores, 112GB RAM)"]
["VM-D1","D1 (1 core, 3.5GB RAM)"]
["VM-D11","D11 (2 cores, 14GB RAM)"]
["VM-D12","D12 (4 cores, 28GB RAM)"]
["VM-D13","D13 (8 cores, 56GB RAM)"]
["VM-D14","D14 (16 cores, 112GB RAM)"]
["VM-D2","D2 (2 cores, 7GB RAM)"]
["VM-D3","D3 (4 cores, 14GB RAM)"]
["VM-D4","D4 (8 cores, 28GB RAM)"]
["SE-A0","A0 Extra Small (1 core, 0.75GB RAM)"]
["SE-A1","A1 Small (1 core, 1.75GB RAM)"]
["SE-A2","A2 Medium (2 cores, 3.5GB RAM)"]
["SE-A3","A3 Large (4 cores, 7GB RAM)"]
["SE-A4","A4 Extra Large (8 cores, 14GB RAM)"]
["SE-A5","A5 (2 cores, 14GB RAM)"]
["SE-A6","A6 (4 cores, 28GB RAM)"]
["SE-A7","A7 (8 cores, 56GB RAM)"]
["SE-A8","A8 (8 cores, 56GB RAM)"]
["SE-A9","A9 (16 cores, 112GB RAM)"]
["SE-D1","D1 (1 core, 3.5GB RAM)"]
["SE-D11","D11 (2 cores, 14GB RAM)"]
["SE-D12","D12 (4 cores, 28GB RAM)"]
["SE-D13","D13 (8 cores, 56GB RAM)"]
["SE-D14","D14 (16 cores, 112GB RAM)"]
["SE-D2","D2 (2 cores, 7GB RAM)"]
["SE-D3","D3 (4 cores, 14GB RAM)"]
["SE-D4","D4 (8 cores, 28GB RAM)"]
["SS-A0","A0 Extra Small (1 core, 0.75GB RAM)"]
["SS-A1","A1 Small (1 core, 1.75GB RAM)"]
["SS-A2","A2 Medium (2 cores, 3.5GB RAM)"]
["SS-A3","A3 Large (4 cores, 7GB RAM)"]
["SS-A4","A4 Extra Large (8 cores, 14GB RAM)"]
["SS-A5","A5 (2 cores, 14GB RAM)"]
["SS-A6","A6 (4 cores, 28GB RAM)"]
["SS-A7","A7 (8 cores, 56GB RAM)"]
["SS-A8","A8 (8 cores, 56GB RAM)"]
["SS-A9","A9 (16 cores, 112GB RAM)"]
["SS-D1","D1 (1 core, 3.5GB RAM)"]
["SS-D11","D11 (2 cores, 14GB RAM)"]
["SS-D12","D12 (4 cores, 28GB RAM)"]
["SS-D13","D13 (8 cores, 56GB RAM)"]
["SS-D14","D14 (16 cores, 112GB RAM)"]
["SS-D2","D2 (2 cores, 7GB RAM)"]
["SS-D3","D3 (4 cores, 14GB RAM)"]
["SS-D4","D4 (8 cores, 28GB RAM)"]
["SW-A0","A0 Extra Small (1 core, 0.75GB RAM)"]
["SW-A1","A1 Small (1 core, 1.75GB RAM)"]
["SW-A2","A2 Medium (2 cores, 3.5GB RAM)"]
["SW-A3","A3 Large (4 cores, 7GB RAM)"]
["SW-A4","A4 Extra Large (8 cores, 14GB RAM)"]
["SW-A5","A5 (2 cores, 14GB RAM)"]
["SW-A6","A6 (4 cores, 28GB RAM)"]
["SW-A7","A7 (8 cores, 56GB RAM)"]
["SW-A8","A8 (8 cores, 56GB RAM)"]
["SW-A9","A9 (16 cores, 112GB RAM)"]
["SW-D1","D1 (1 core, 3.5GB RAM)"]
["SW-D11","D11 (2 cores, 14GB RAM)"]
["SW-D12","D12 (4 cores, 28GB RAM)"]
["SW-D13","D13 (8 cores, 56GB RAM)"]
["SW-D14","D14 (16 cores, 112GB RAM)"]
["SW-D2","D2 (2 cores, 7GB RAM)"]
["SW-D3","D3 (4 cores, 14GB RAM)"]
["SW-D4","D4 (8 cores, 28GB RAM)"]

{"sheet":"TCO","index":4,"n_rows":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,"Year One - Cost Analysis Azure Cloud vs On Premise vs SaaS",null,null,null,null,"Yearly Azure Cash Flow Recap"]
["Costs Assumptions","Qty","Purchase Cost w/\nServices","Costs per Year\nSpread","On Premise \nMth","Azure /\nO365\nMth","SaaS Compete\nMth",null,"OnPrem","Azure/O365","SaaS Compete"]
["Total Users",{"$f":"IF(O365Users=0,DesktopCALs+WebClientCALs+LimitedUserCALs,O365Users)","v":3},null,null,null,null,null,"Year 1",{"$f":"IF(FinanceAmountYear1=0,SUM(I39:I42)*12,SUM(I39:I42)*12+FinanceAmountYear1)","v":5312.5},{"$f":"IF(FinanceAmountYear1=0,SUM(J39:J42)*12*AzureRunHoursDiscount,SUM(J39:J42)*12*AzureRunHoursDiscount+FinanceAmountYear1)","v":1607.04},{"$f":"SUM(K39:K42)*12+AmortizedSWCompetePerMonth*12","v":12300}]
["ERP Users",{"$f":"ERPUserCount","v":3},null,null,null,null,null,"Year 2",{"$f":"IF(FinanceAmountYear2=0,SUM(L39:L42)*12,SUM(L39:L42)*12+FinanceAmountYear2)-IF(AmortizeYears<2,(AmortizedSWOnPremPerMonth+AmortizedHWOnPremPerMonth)*12,0)","v":5312.5},{"$f":"IF(FinanceAmountYear2=0,SUM(M39:M42)*12*AzureRunHoursDiscount,SUM(M39:M42)*12*AzureRunHoursDiscount+FinanceAmountYear2)-IF(AmortizeYears<2,AmortizedSWOnAzurePerMonth*12*AzureRunHoursDiscount,0)","v":1607.04},{"$f":"SUM(N39:N42)*12+AmortizedSWCompetePerMonth*12-IF(AmortizeYears<2,AmortizedSWCompetePerMonth*12,0)","v":12300}]
["Amortize Period Years",4,null,null,null,null,null,"Year 3",{"$f":"IF(FinanceAmountYear3=0,SUM(O39:O42)*12,SUM(O39:O42)*12+FinanceAmountYear3)-IF(AmortizeYears<3,(AmortizedSWOnPremPerMonth+AmortizedHWOnPremPerMonth)*12,0)","v":5312.5},{"$f":"IF(FinanceAmountYear3=0,SUM(P39:P42)*12*AzureRunHoursDiscount,SUM(P39:P42)*12*AzureRunHoursDiscount+FinanceAmountYear3)-IF(AmortizeYears<3,AmortizedSWOnAzurePerMonth*12*AzureRunHoursDiscount,0)","v":1607.04},{"$f":"SUM(Q39:Q42)*12+AmortizedSWCompetePerMonth*12-IF(AmortizeYears<3,AmortizedSWCompetePerMonth*12,0)","v":12300}]
["Include Admin & Overhead costs","No",null,null,null,null,null,"Year 4",{"$f":"IF(FinanceAmountYear3=0,SUM(R39:R42)*12,SUM(R39:R42)*12+FinanceAmountYear4)-IF(AmortizeYears<4,(AmortizedSWOnPremPerMonth+AmortizedHWOnPremPerMonth)*12,0)","v":5312.5},{"$f":"IF(FinanceAmountYear4=0,SUM(S39:S42)*12*AzureRunHoursDiscount,SUM(S39:S42)*12*AzureRunHoursDiscount+FinanceAmountYear4)-IF(AmortizeYears<4,AmortizedSWOnAzurePerMonth*12*AzureRunHoursDiscount,0)","v":1607.04},{"$f":"SUM(T39:T42)*12+AmortizedSWCompetePerMonth*12-IF(AmortizeYears<4,AmortizedSWCompetePerMonth*12,0)","v":12300}]
["Include 5 year hardware refresh in totals","Yes",null,null,null,null,null,"Year 5",{"$f":"SUM(U39:U42)*12-(AmortizedSWOnPremPerMonth+AmortizedHWOnPremPerMonth)*12","v":2500},{"$f":"SUM(V39:V42)*12*AzureRunHoursDiscount-(AmortizedSWOnAzurePerMonth)*12*AzureRunHoursDiscount","v":1607.04},{"$f":"SUM(W39:W42)*12","v":10800}]
[{"$f":"\"Software & Services CostsY/M/M/M - \"","v":"Software & Services CostsY/M/M/M - "},{"$f":"IF(TypeOfERPLicence=\"PERP\",\"Perpetual ERP\",\"Saas ERP\")","v":"Perpetual ERP"},null,null,{"$f":"SUM(E9:E16)","v":151.04166666666669},{"$f":"SUM(F9:F16)","v":133.91999999999999},{"$f":"SUM(G9:G16)","v":900},"Total Years 10 & 15",{"$f":"SUM(I3:I6)+I7*6-IF(HardwareRefresh=\"No\",AmortizedHWOnPremPerMonth*12*AmortizeYears,0)","v":36250},{"$f":"SUM(J3:J6)+J7*6","v":16070.4},{"$f":"SUM(K3:K6)+K7*6","v":114000}]
[{"$f":"IF(LEFT(ServerClass1Type,1)=\"S\",\"Microsoft OS (Server & CAL) w/SQL\",\"Microsoft OS (Server & CAL) \")","v":"Microsoft OS (Server & CAL) "},{"$f":"TotalServerCount+IF(Office365=\"Yes\",1,0)","v":1},3000,{"$f":"B9*C9/AmortizeYears","v":750},{"$f":"D9/12","v":62.5},{"$f":"(ServerClass1Mth+ServerClass2Mth+ServerClass4Mth+StorageMth+\n(IF(ServerClass5Mth<>\"\",ServerClass5Mth,0)))+(IF(TypeOfSQLLicense<>\"VM-SQL\",ServerClass3Mth,0))","v":133.91999999999999},"NA",null,{"$f":"I8+I7*5-IF(HardwareRefresh=\"No\",AmortizedHWOnPremPerMonth*12*AmortizeYears,0)","v":48750},{"$f":"J8+J7*5","v":24105.599999999999},{"$f":"K8+K7*5","v":168000}]
["Microsoft SQL Server (Azure per/Mth)",null,null,null,"NA",{"$f":"IF(TypeOfSQLLicense=\"VM-SQL\",ServerClass3Mth,0)","v":0},"NA"]
["Microsoft SQL Server (Amortized)",1,3500,{"$f":"B11*C11/AmortizeYears","v":875},{"$f":"D11/12","v":72.916666666666671},"NA","NA"]
["Dynamics ERP (PERP) Amortized",null,{"$f":"IF(TypeOfERPLicence=\"Perp\",IF(PartnerFeesOption=\"Yes\",PartnerFees,0),0)","v":0},{"$f":"C12/AmortizeYears","v":0},{"$f":"D12/12","v":0},{"$f":"D12/12","v":0},"NA"]
["Microsoft Office (OnPrem & Office 365)",{"$f":"B3","v":3},250,{"$f":"B13*C13/AmortizeYears","v":187.5},{"$f":"D13/12","v":15.625},{"$f":"IF(Office365=\"Yes\",O365Users*O365PlanCost,0)","v":0},"NA"]
["Dynamics ERP License & Service (SaaS)",null,{"$f":"IF(TypeOfERPLicence=\"SPLA\",\nTCOERPUserCount*MthSPLA*12+ IF(FinanceOption=\"Yes\",FinanceAmountYear1,0)+IF(PartnerFeesOption=\"Yes\",PartnerFees/AmortizeYears,0),\n0)","v":0},{"$f":"C14","v":0},{"$f":"D14/12","v":0},{"$f":"D14/12","v":0},"NA"]
["Microsoft Cloud (CRM/RDS) Options",null,null,null,null,{"$f":"IF(CRMOLOption=\"Yes\",CRMOLPlanCost*CRMOLUsers,0) + IF(RDServices=\"Yes\",RDPSPLA*DesktopCALs,0)","v":0},"NA"]
["Competive SaaS + Services - (SaaS)",null,{"$f":"SaaSImplementation+SaaSSetup","v":6000},{"$f":"C16/AmortizeYears","v":1500},"NA","NA",{"$f":"(TCOERPUserCount*SaaSCompete)","v":900}]
["Amortized Items Total",null,null,null,{"$f":"E9+E11+E12+E13","v":151.04166666666669},{"$f":"F12","v":0},{"$f":"((SaaSImplementation+SaaSSetup)/12/AmortizeYears)","v":125}]
["Server Hardware & Enviromental",null,null,null,{"$f":"SUM(E19:E21)","v":183.33333333333331},{"$f":"SUM(F19:F21)","v":0},{"$f":"SUM(G19:G22)","v":0},"Year","Deployment","Software & Services",{"$f":"$A$18","v":"Server Hardware & Enviromental"},{"$f":"$A$23","v":"Monthly Maintence Costs"},{"$f":"$A$29","v":"Admin & Overhead"},null,"Row Labels","Software Services Costs","Server HW Costs","Mth Costs"," Admin & Overhead"]
["On Premise Servers Amortized",{"$f":"TotalServerCount+IF(Office365=\"Yes\",1,0)","v":1},4000,{"$f":"B19*C19/AmortizeYears","v":1000},{"$f":"D19/12","v":83.333333333333329},null,null,"Year 1","OnPrem",{"$f":"E8+D7","v":151.04166666666669},{"$f":"$E$18","v":183.33333333333331},{"$f":"$E$23","v":108.33333333333333},{"$f":"$E$29","v":0},null,"Year 1",29319.727999999999,9000,9000,0]
["Other Physical  Costs (power, misc)",null,null,100,{"$f":"D20","v":100},null,null,"Year 1","OnLine",{"$f":"F8+D7","v":133.91999999999999},{"$f":"$F$18","v":0},{"$f":"$F$23","v":0},{"$f":"$F$29","v":0},null,"OnLine",13319.727999999999,0,3000,0]
[null,null,null,null,null,null,null,"Year 2","OnPrem",{"$f":"$E$8","v":151.04166666666669},{"$f":"$E$18","v":183.33333333333331},{"$f":"$E$23","v":108.33333333333333},{"$f":"$E$29","v":0},null,"OnPrem",16000,9000,6000,0]
["Amortized Items Total",null,null,{"$f":"D19","v":1000},{"$f":"E19","v":83.333333333333329},null,null,"Year 2","OnLine",null,{"$f":"$F$18","v":0},{"$f":"$F$23","v":0},{"$f":"$F$29","v":0},null,"Year 2",11000,9000,9000,0]
["Monthly Maintence Costs",null,null,null,{"$f":"SUM(E24:E28)","v":108.33333333333333},{"$f":"SUM(F24:F28)","v":0},{"$f":"SUM(G24:G28)","v":0},"Year 3","OnPrem",{"$f":"$E$8","v":151.04166666666669},{"$f":"$E$18","v":183.33333333333331},{"$f":"$E$23","v":108.33333333333333},{"$f":"$E$29","v":0},null,"OnLine",null,0,3000,0]
["Microsoft Software Assurance",null,null,null,{"$f":"(C9+C11)*0.2/12","v":108.33333333333333},null,null,"Year 3","OnLine",null,{"$f":"$F$18","v":0},{"$f":"$F$23","v":0},{"$f":"$F$29","v":0},null,"OnPrem",11000,9000,6000,0]
[null,null,null,null,null,null,null,"Year 4","OnPrem",{"$f":"$E$8","v":151.04166666666669},{"$f":"$E$18","v":183.33333333333331},{"$f":"$E$23","v":108.33333333333333},{"$f":"$E$29","v":0},null,"Year 3",11000,9000,9000,0]
["Dynamics ERP BREP Support",null,{"$f":"IF(TypeOfERPLicence=\"PERP\",C12*0.5*0.2,0)","v":0},{"$f":"C26","v":0},{"$f":"$D$26/12","v":0},{"$f":"$D$26/12","v":0},null,"Year 4","OnLine",null,{"$f":"$F$18","v":0},{"$f":"$F$23","v":0},{"$f":"$F$29","v":0},null,"OnLine",null,0,3000,0]
[null,null,null,null,null,null,null,"Year 5","OnPrem",{"$f":"$E$8","v":151.04166666666669},{"$f":"$E$18","v":183.33333333333331},{"$f":"$E$23","v":108.33333333333333},{"$f":"$E$29","v":0},null,"OnPrem",11000,9000,6000,0]
[null,null,null,null,null,null,null,"Year 5","OnLine",null,{"$f":"$F$18","v":0},{"$f":"$F$23","v":0},{"$f":"$F$29","v":0},null,"Year 4",11000,9000,9000,0]
["Admin & Overhead",null,null,null,{"$f":"SUM(E30:E34)","v":0},{"$f":"SUM(F30:F34)","v":0},{"$f":"SUM(G30:G34)","v":0},null,null,null,null,null,null,null,"OnLine",null,0,3000,0]
["Wages On-premise support",3,60000,{"$f":"B30*C30","v":180000},{"$f":"IF(IncludeAdmin=\"Yes\",D30/12,0)","v":0},null,null,null,null,null,null,null,null,null,"OnPrem",11000,9000,6000,0]
["Wages Dynamics ERP Online Support",2,60000,{"$f":"B31*C31","v":120000},null,{"$f":"IF(IncludeAdmin=\"Yes\",D31/12,0)","v":0},{"$f":"IF(IncludeAdmin=\"Yes\",E31,0)","v":0},null,null,null,null,null,null,null,"Year 5",11000,9000,9000,0]
["Wages On-line SaaS Support",1.5,60000,{"$f":"B32*C32","v":90000},null,null,{"$f":"IF(IncludeAdmin=\"Yes\",D32/12,0)","v":0},null,null,null,null,null,null,null,"OnLine",null,0,3000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OnPrem",11000,9000,6000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",73319.728000000003,45000,45000,0]
["Total Per Month",null,null,null,{"$f":"SUM(E9:E17,E19:E21,E24:E26,E30:E33)","v":593.75},{"$f":"SUM(F9:F17,F19:F21,F24:F26,F30:F33)","v":133.91999999999999},1025]
[]
["Longterm TCO Impact On Permise vs Azure vs SaaS compete (Cash Flow Forecast)",null,null,null,null,null,null,null,"Year 1-5 Monthly",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"5 Year Recap"]
[null,null,"3 Yr","5 Yr","10 Yr","15 Yr",null,null,"OnPrem","Azure","SaaS Compete","OnPrem","Azure","SaaS Compete","OnPrem","Azure","SaaS Compete","OnPrem","Azure","SaaS Compete","OnPrem","Azure","SaaS Compete","OnPrem","Azure","SaaS Compete"]
[{"$f":"\"Dynamics ERP OnPrem:\" & TypeOfERPLicence","v":"Dynamics ERP OnPrem:PERP"},null,{"$f":"SUM($I$3:$I$5)","v":15937.5},{"$f":"SUM($I$3:$I$5)+$I$6+$I$7","v":23750},{"$f":"I8","v":36250},{"$f":"I9","v":48750},null,{"$f":"$A$8","v":"Software & Services CostsY/M/M/M - "},{"$f":"E8","v":151.04166666666669},{"$f":"F8","v":133.91999999999999},{"$f":"G8","v":900},{"$f":"$E$8","v":151.04166666666669},{"$f":"$F$8","v":133.91999999999999},{"$f":"$G$8","v":900},{"$f":"$E$8","v":151.04166666666669},{"$f":"$F$8","v":133.91999999999999},{"$f":"$G$8","v":900},{"$f":"$E$8","v":151.04166666666669},{"$f":"$F$8","v":133.91999999999999},{"$f":"$G$8","v":900},{"$f":"$E$8","v":151.04166666666669},{"$f":"$F$8","v":133.91999999999999},{"$f":"$G$8","v":900},{"$f":"I39+L39+O39+R39+U39","v":755.20833333333348},{"$f":"J39+M39+P39+S39+V39","v":669.59999999999991},{"$f":"K39+N39+Q39+T39+W39","v":4500}]
[{"$f":"\"Dynamics ERP Azure :\" & TypeOfERPLicence","v":"Dynamics ERP Azure :PERP"},null,{"$f":"SUM($J$3:$J$5)","v":4821.12},{"$f":"SUM($J$3:$J$5)+$J$6+$J$7","v":8035.2},{"$f":"J8","v":16070.4},{"$f":"J9","v":24105.599999999999},null,{"$f":"$A$18","v":"Server Hardware & Enviromental"},{"$f":"$E$18","v":183.33333333333331},{"$f":"$F$18","v":0},null,{"$f":"$E$18","v":183.33333333333331},{"$f":"$F$18","v":0},null,{"$f":"$E$18","v":183.33333333333331},{"$f":"$F$18","v":0},null,{"$f":"$E$18","v":183.33333333333331},{"$f":"$F$18","v":0},null,{"$f":"$E$18","v":183.33333333333331},{"$f":"$F$18","v":0},null,{"$f":"I40+L40+O40+R40+U40","v":916.66666666666652},0]
["Competitive SaaS",null,{"$f":"SUM($K$3:$K$5)","v":36900},{"$f":"SUM($K$3:$K$5)+$K$6+$K$7","v":60000},{"$f":"K8","v":114000},{"$f":"K9","v":168000},null,{"$f":"$A$23","v":"Monthly Maintence Costs"},{"$f":"$E$23","v":108.33333333333333},{"$f":"$F$23","v":0},{"$f":"$G$23","v":0},{"$f":"$E$23","v":108.33333333333333},{"$f":"$F$23","v":0},{"$f":"$G$23","v":0},{"$f":"$E$23","v":108.33333333333333},{"$f":"$F$23","v":0},{"$f":"$G$23","v":0},{"$f":"$E$23","v":108.33333333333333},{"$f":"$F$23","v":0},{"$f":"$G$23","v":0},{"$f":"$E$23","v":108.33333333333333},{"$f":"$F$23","v":0},{"$f":"$G$23","v":0},541.66666666666663,0,{"$f":"K41+N41+Q41+T41+W41","v":0}]
[null,null,null,null,null,null,null,{"$f":"$A$29","v":"Admin & Overhead"},{"$f":"$E$29","v":0},{"$f":"$F$29","v":0},{"$f":"$G$29","v":0},{"$f":"$E$29","v":0},{"$f":"$F$29","v":0},{"$f":"$G$29","v":0},{"$f":"$E$29","v":0},{"$f":"$F$29","v":0},{"$f":"$G$29","v":0},{"$f":"$E$29","v":0},{"$f":"$F$29","v":0},{"$f":"$G$29","v":0},{"$f":"$E$29","v":0},{"$f":"$F$29","v":0},{"$f":"$G$29","v":0},0,0,{"$f":"K42+N42+Q42+T42+W42","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ERP","Email Platform","Productivity","Collaboration","Reporting","Directory","CRM","Remote Access"]
[null,null,null,null,null,null,null,"Dynamics",1,{"$f":"IF(Office365=\"Yes\",1,0)","v":0},{"$f":"IF(Office365=\"Yes\",1,0)","v":0},{"$f":"IF(Office365=\"Yes\",1,0)","v":0},{"$f":"IF(SRSServer=\"Yes\",1,0)","v":0},{"$f":"IF(DomainController=\"Yes\",1,0)","v":0},{"$f":"IF(CRMOLOption=\"Yes\",1,0)","v":0},{"$f":"IF(RDServices=\"Yes\",1,0)","v":0}]
[null,null,null,null,null,null,null,"Compete",1,0,0,0,0,0,0,0]

{"sheet":"Topology","index":5,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(LEFT(ServerClass1Type,1)=\"S\",\"Application Server w/ SQL Server\",\"Application Server no SQL Server\")","v":"Application Server no SQL Server"}]
[{"$f":"\"Microsoft Dynamics \" & BaseProduct & \" Azure Network Topology Proposal for:  \" &CustomerName","v":"Microsoft Dynamics GP Azure Network Topology Proposal for:  Sample ERP 3 Users"}]
[{"$f":"\"Designed by \" & PartnerName","v":"Designed by Contoso Solutions Inc."}]

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

{"sheet":"AzureResources","index":7,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Title",{"$f":"\"Azure Web Resources                         \" & \"Count of links selected to mail:                   \" & LinksToMail & \"          \"","v":"Azure Web Resources                         Count of links selected to mail:                   7          "},"Pick Solution Area","Include Link in Mail",{"$f":"COUNTIFS(D:D,\"Yes\")","v":7}]
["Performance Guidance for SQL Server in Azure Virtual Machines","http://msdn.microsoft.com/en-us/library/azure/dn248436.aspx","Azure","No"]
["Volume Licensing for Microsoft Products and Online Services","http://www.microsoft.com/licensing/products/products.aspx","Azure","No"]
["What is Azure","http://azure.microsoft.com/en-us/overview/what-is-azure/","Azure","No"]
["Azure Price Calculator","http://azure.microsoft.com/en-us/pricing/calculator/","Azure","No"]
["Gartner Azure Magic Quadrant","http://blogs.technet.com/b/in_the_cloud/archive/2014/10/07/the-quadruple-msft-is-a-leader-in-four-gartner-mq-s.aspx","Azure","Yes"]
["Azure P2V Machine Converter","http://blogs.technet.com/b/server-cloud/archive/2014/10/13/available-now-the-microsoft-virtual-machine-converter-3-0.aspx","Azure","No"]
["D-Series Performance Expectations","http://azure.microsoft.com/blog/2014/10/06/d-series-performance-expectations/","Azure","Yes"]
["High-Performance Storage for Azure Virtual Machine Workloads","http://azure.microsoft.com/blog/2014/12/11/introducing-premium-storage-high-performance-storage-for-azure-virtual-machine-workloads/","Azure","Yes"]
["Download Running Critical Application Workloads on Microsoft Azure Virtual Machines","https://www.microsoft.com/en-us/download/details.aspx?id=45328","Azure","No"]
["Set up endpoints on a virtual machine in Azure","http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-set-up-endpoints/","Azure","No"]
["Microsoft partner learning paths","https://mspartnerlp.mspartner.microsoft.com/LearningPath","Azure","Yes"]
["Migrating VMs to Azure","http://blogs.technet.com/b/msuspartner/archive/2014/11/13/microsoft-azure-partner-community-migrating-vms-to-azure.aspx","Azure","No"]
["Disaster Recovery and High Availability – Building Resilient Cloud Applications","http://blogs.technet.com/b/msuspartner/archive/2014/10/14/microsoft-azure-partner-community-focus-on-disaster-recovery-and-high-availability-building-resilient-cloud-applications.aspx","Azure","No"]
["Azure Partner Cloud Profitability Guide","https://partner.microsoft.com/download/global/40197805","Azure","No"]
["Performance Best Practices for SQL Server in Azure Virtual Machines","http://msdn.microsoft.com/en-us/library/azure/dn133149.aspx","Azure","No"]
["Azure Powershell Script Center","https://gallery.technet.microsoft.com/scriptcenter/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=WindowsAzure","Azure","No"]
["Start Windows Azure Virtual Machines on a Schedule ","https://gallery.technet.microsoft.com/scriptcenter/Start-Windows-Azure-b6c179b6","Azure","Yes"]
["Stop Windows Azure Virtual Machines on a Schedule ","https://gallery.technet.microsoft.com/scriptcenter/Start-Windows-Azure-b6c179b6","Azure","Yes"]
["Azure region speed optimization test","http://azurespeedtest.azurewebsites.net/","Azure","No"]
["Catalogic Case Study -Dynamics GP on Azure","http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=710000004498","GP","No"]
["Microsoft Dynamics GP Hosting Guide","https://mbs.microsoft.com/partnersource/northamerica/deployment/documentation/white-papers/MSDGPhostingguide","GP","No"]
["Experience Dynamics GP","http://www.dynamicsgptestdrive.com/en-US/Guides/Experience%20Microsoft%20Dynamics%20GP","GP","No"]
["Gain insight on financial performance","http://www.dynamicsgptestdrive.com/en-US/Guides/Gain%20insight%20on%20financial%20performance","GP","No"]
["Make it easier to enter sales orders","http://www.dynamicsgptestdrive.com/en-US/Guides/Make%20it%20easier%20to%20enter%20orders","GP","No"]
["Make smarter purchasing decsions","http://www.dynamicsgptestdrive.com/en-US/Guides/Make%20smarter%20purchasing%20decisions","GP","No"]
["Microsoft Dynamics NAV 2013 and Microsoft Dynamics GP 2013 Licensing Guide","https://mbs.microsoft.com/partnersource/northamerica/pricing-ordering/pricing-ordering-news/MSDNAVGP2013LicensingGuide","SMBERP","No"]
["Dynamic SMB ERP SPLA PartnerSource ","https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/marketing-collateral/messaging-frameworks/MSDYERP_SPLA","SMBERP","No"]
["Microsoft Dynamics NAV 2015 and Microsoft Dynamics GP 2015 Pricing and Licensing","https://mbs.microsoft.com/partnersource/northamerica/pricing-ordering/licensing-policies/perpetual-licensing","SMBERP","No"]
["SMB Resource Center - R2R Resources","https://mbs.microsoft.com/partnersource/northamerica/partner-essentials/smb-resource-center","SMBERP","No"]
["Captain Stack Sales Tools","http://blogs.msdn.com/b/captain_stack/","SMBERP","No"]
["DIY Dynamics","https://mbs.microsoft.com/partnersource/northamerica/pricing-ordering/pricing-ordering-news/DIY_Dynamics","SMBERP","No"]
["Syncing Domain Controllers between on-Premises and Windows Azure","http://blogs.technet.com/b/uspartner_ts2team/archive/2014/01/17/windows-azure-syncing-domain-controllers-between-on-premise-and-windows-azure.aspx","Azure","Yes"]

{"sheet":"SavedModels","index":8,"n_rows":3,"n_cols":43,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Model Name","Time of Model","Desktop CALs","WebClient CALs","LimitedUser CALs","O365 Users","CRMOL Users","DailyRun Hours","TypeOfERP Licence","TypeOfSQL License","Domain Controller","Office365","CRMOL Option","RDS Services","SRS Server","Finance Option","Partner Fees Option","O365Plan Cost","CRMOLPlan Cost","RDP SPLA","Mth SPLA","Finance Amount","Partner Fees","Partner Monthly Fees","Currency","Azure Tier","Server Class1 Type","Server Class1 Qty","Server Class2 Type","Server Class2 Qty","Server Class3 Type","Server Class3 Qty","Server Class4 Type","Server Class4 Qty","Disk Storage","Server Class5 Type","Serve rClass5 Qty","SQLServer Type","Finance Rate","Finance Period","Azure SLA","Base Product","4 Year Invstment"]
["Sample ERP Prospect -  3 user model","2015-01-06T09:42:09",3,0,0,3,3,24,"PERP","PERP","No","No","No","No","No","No","Yes",15,65,4,130,5000,5000,0,"USD","Standard Tier","VM-A2",1,"VM-A1",0,"VM-A2",0,"SW-A1",0,"A-5GB",null,null,"SW",0.1,12,"No","GP",11428.16]
["Sample ERP Prospect -  5 user with SQL","2015-01-06T09:53:59",5,0,0,5,5,24,"PERP","VM-SQL","No","No","No","No","No","No","Yes",15,65,4,130,5000,5000,0,"USD","Standard Tier","VM-A2",1,"VM-A1",0,"SW-A2",1,"SW-A1",0,"A-5GB",null,null,"SW",0.1,12,"No","GP",18999.099999999999]