Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

  2. #2
    New Lounger
    Join Date
    May 2010
    Location
    Ireland
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by MickeyMouse View Post
    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
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Matti Mulari View Post
    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)!
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

  4. #4
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    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!
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  5. #5
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by t8ntlikly View Post
    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.
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

  6. #6
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    Quote Originally Posted by MickeyMouse View Post
    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.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  7. #7
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by t8ntlikly View Post
    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!
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •