The Cisco Price List If you didn’t know that Cisco publishes their Recommended Retail Price List on a monthly basis, then raise your hand? Yep, thought so. Thats about 95% of the audience, the usual. It’s one of the lesser known “reseller secrets” that anyone can get the latest Retail Price List on request. You can ask your Cisco Partner/Reseller, who would usually have it (and if they don’t, you should think about using another partner). Sometimes your Cisco Partner will refuse to give it you, stating that that it is confidential information, which it most certainly is not. Typically, I would then speak to my Cisco Account Manager who will then send it over.
((NO, I will not make it available for download, it doesn’t belong to me)) If you partner hasn’t heard about it (and you really don’t want to change reseller) then tell them to request it from the their wholesaler who will be able to get it for them. What does the Price List look like? Its a spreadsheet that lists the part number, description and the retail price in US Dollars for every product that Cisco offers, including Smartnet (in all its myriad forms).
Making the most of this treasure One of the most difficult parts of being a designer, is deciding which product or scenario is most useful to the requirements. For example, I need to install a WAN connection and I know that a Cisco 2811 would be enough, but how much would a Cisco 3825 cost and could I justify that knowing that I might need the IOS Zone Based Firewall in the future.
Normally, I have to ask my reseller to give me a price on both models and the options in the IOS feature set. Typically, this takes a few days while they prepare an official quote and work through the numbers before presenting you the information. More often that not, you need to get things changed and updated, again a wait for several days. And so the cycle goes until you get what you need. And then the reseller wants to constantly bug you ((they call it ‘following up’)) to find out when you are going to purchase it.
CoDe SAS German. SAS Global Forum 2018. SAS Community Nordic. SAS Professionals UK&I. « Message Listing. ERROR: DBMS type EXCEL not valid for import. How to solve this? I even changed XLSX to XLS. I recommend saving data as *.csv: Comma Separated Values, which is a text file.
This means wasted time on the phone and email, you need to be nice enough to the person so that they will produce quotes in future but really you want them to bugger of and leave you alone. So I have a better way to do this. Cisco Dynamic Configuration Tool The first step is to use the to prepare the list of part numbers required for the given solution. The Cisco Dynamic Configuration tool is a fundamental part of establishing each and every component that goes into the purchased product.
For example, purchasing a Cisco 3845 router requires not only the hardware, but also the flash, memory, modules and other accessories to exactly come together. The only accurate way to do this is the use the tool provided by Cisco.
For a selected configuration, it will check and validate your configuration to make that all the modules can be installed (say, not installing too many NM’s, or the wrong type of ESW’s), and the the flash and memory has the capacity to run the IOS image that you have selected. This detail in vital on building the correct part numbers. Note: help is available within the tool and you should go there for a complete introduction. You do not need a Cisco CCO login to access the tool. It is really important to use this tool because will collect together all the line items that Cisco wants you to buy. Because there are various business units within Cisco that may produce the overall product the line items can vary from zero cost to substantial sums.
Selecting which IOS image to use is often a real problem and the Configuration Tool does all the checking of the versions, memory and flash. This tool is the same one that resellers use when quoting. • Since I am buying in English Pounds I add a currency conversion.
It’s an estimate but usually enough to give a rough idea • Add a field for state / government taxes • And a field for your estimated discount from retail price • Enter a Cisco part number into the field Now we need some Excel formulas to lookup from the price list. When I look at the spreadsheet that comes from Cisco, the pricing2/pricing3 tabs are only the Cisco maintenance prices therefore we don’t need to look them up. I delete these sheets.
All of the prices for the actual equipment are in the first sheet. Description =IF(B12',VLOOKUP(B12,pricing1!C:F,2,FALSE),'-') The logic goes something like this: If there is something in Cell B12, then lookup the value in B12 the the area pricing1!C:F and return the second column value. This is the Description. This is very useful to make sure the product is actually what you want. US Retail List Price =IF(B12',REPLACE(VLOOKUP(B12,pricing1!C:G,4,FALSE),1,1,'),'-') The logic is: If there is a part number in Cell B12, then lookup the value in B12 the the area pricing1!C:F and return the fourth column value, convert it to currency (REPLACE function) instead of text. If nothing in Cell B21 then just put a dash. This is the US Retail List price for the item.