excel template needed

Topic

New Reply

Hi All,

Before I go and possibly re-invent the wheel here, I have to look into replacing a couple of network printers and I was wondering if any of you had every done that and if you had developed an excel spreadsheet to do a cost comparison.

Reply | Quote

Replies

Hi All,

Before I go and possibly re-invent the wheel here, I have to look into replacing a couple of network printers and I was wondering if any of you had every done that and if you had developed an excel spreadsheet to do a cost comparison.

Hi,

So you want a cost comparison. Put cost of the old one in to colum A and new one to B. The for C colum =IF(A2>B2,A2-B2,B2-A2)
First it checks witch value is larger and the counts the difference based on the larger value.
Attached example file.

Not sure if this is what you want?

-Matti

Reply | Quote

Hi,

So you want a cost comparison. Put cost of the old one in to colum A and new one to B. The for C colum =IF(A2>B2,A2-B2,B2-A2)
First it checks witch value is larger and the counts the difference based on the larger value.
Attached example file.

Not sure if this is what you want?

-Matti

Hi Matti,

Thanks for the suggestion. Actually I am creating an excel file that allows me to compare a number of network printer related items. For example, cost (as you mentioned and always important), PPM (printed pages per minute both B&W and Color), cost associated with the PPM, monthly and annual print allowances, costs for over-printing, etc.

We are in the process of looking into replacing some network printers and I am getting quotes from all over and I need a way to concisely gather the information together to assist in determining which is the best-bang-for-the-buck solution. This also helps me try to boil it down to an apples-to-apples comparison as each vendor has their own, unique way of presenting the same information.

Thanks again for the suggestion and Welcome to Windows Secrets! As I am sure you have already noticed, this is a great place to seek knowledge and assistance (not to mention some really great online friends)!

Reply | Quote

Why not try this and save yourself a huge headache.
Send out an RFQ, in a format that you choose, listing the items you want on it such as PPM etc, and stipulate that their RFQ must be on the sheet that you have attached.
Worked for me albeit not for printers.

Have the providers fill that in and send back to you. If they want your business badly enough they will fill it out, if they don’t Oh well!

Reply | Quote

Why not try this and save yourself a huge headache.
Send out an RFQ, in a format that you choose, listing the items you want on it such as PPM etc, and stipulate that their RFQ must be on the sheet that you have attached.
Worked for me albeit not for printers.

Have the providers fill that in and send back to you. If they want your business badly enough they will fill it out, if they don’t Oh well!

Well where were you 8 to 10 weeks ago?! I wish I had thought of that back when this whole process started. Great idea t8nt! Oh well, I will keep that in mind when we go to re-negotiate.

Reply | Quote

Well where were you 8 to 10 weeks ago?! I wish I had thought of that back when this whole process started. Great idea t8nt! Oh well, I will keep that in mind when we go to re-negotiate.

You are quite welcome Mickey.. The way I figure it I have better things to do than to sift through all of their specs and decipher them. That is what they get paid to do so let them do it.

Reply | Quote

You are quite welcome Mickey.. The way I figure it I have better things to do than to sift through all of their specs and decipher them. That is what they get paid to do so let them do it.

You are so right.

If this had been my task from the beginning I might have actually thought of this. Instead it is a project that someone else (higher up) that is/was the lead who then assigned it to me when it became apparent that they had messed around so long that it was not going to complete on time. Now it is their success and my failure. Yeah!

Reply | Quote