A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how can i setup spreadsheet to compare 3 diff computer specs,pric



 
 
Thread Tools Display Modes
  #1  
Old February 19th, 2010, 08:02 PM posted to microsoft.public.excel.setup
bridhe
external usenet poster
 
Posts: 1
Default how can i setup spreadsheet to compare 3 diff computer specs,pric

how can i set up a spreadsheet that will allow me to compare 3 different
types of computers with specifications and costs or cost benefits using
formula or functions in this worksheet
  #2  
Old February 22nd, 2010, 01:43 PM posted to microsoft.public.excel.setup
JLatham
external usenet poster
 
Posts: 1,896
Default how can i setup spreadsheet to compare 3 diff computer specs,pric

I'd just set up columns for the pieces of information you're concerned with
about the computers:
Model | Cost | CPU Type | CPU Speed | RAM | HD Storage | ...
Which features are important to you are the ones I'd record, and I'd just
put simple numeric values of equal type in each column. That is, instead of
recording CPU speed as 2.4 GHz and 3.0 GHz, I'd just enter 2.4 and 3. Easier
to compare simple numeric values later.

As for determining best deal, well that's rather arbitrary on your part. A
lot depends on the intended use of the system: for something simply to surf
the web, chat on-line, use email, and other 'light' applications, then your
best bang for the buck might actually be a small, low-cost system as the cost
of lots of drive storage, high-end video cards, super-sound cards would be
rather wasted. If you're into on-line gaming, then high end video cards,
lots of RAM and CPU power are a plus.

Consider some type of scheme that 'weighs' each numeric value and gives you
an overall score for the computer that's based on the individual values for
each sub-system you've recorded and simply compare those scores, either
against one another or also incorporate the cost of the system to determine
the best bang for the buck (i.e., Cost / weighted-score [lower is better], or
weighted-score / Cost [higher is better]).

"bridhe" wrote:

how can i set up a spreadsheet that will allow me to compare 3 different
types of computers with specifications and costs or cost benefits using
formula or functions in this worksheet

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.