Not sure if Excel can do what i need
I am obviously a new user to excel. I have a psychological assessmen
that needs to be computerised for ease of use in obtaining results.
Here is what i would like to happen. I have 28 questions with fiv
Likert scale options(0-4) for answers. Each question addresses 1 of
different personality traits. So questions 1, 6, 8, 22 look at anger.
Where as questions 2, 9, 28 look at happiness. What i would like is fo
excel to group the answers and give me the total number for each trait.
Then based on that number, give out a prewritten (which i would provide
result of the assessment.
...Need Min Value from Row and Heading Value that Corresponds to it.
I have a table that looks somewhat like this w/o the *'d headings:
h1 h2 h3 h4 h5 h6 h7 *Min Price *Heading
$5.00 $6.00 $3.00 $4.00 $9.00 $1.00 $9.00 $1.00 h6
$3.00 $6.00 $8.00 $65.00 $9.00 $2.00 $4.00 $2.00 h6
$4.00 $9.00 $5.00 $7.00 $1.00 $2.00 $8.00 $1.00 h5
$9.00 $7.00 $6.00 $3.00 $9.00 $8.00 $2.00 $2.00 h7
$7.00 $8.00 $9.00 $7.00 $9.00 $8.00 $8.00 $7.00 h1
I have several SKU's with various price contract/programs. I want to find
the best price in one cell and the heading that would correspond to that cell
I was trying to do this with an expression ...How can I create a Visio timeline from a Microsoft Project file?
Can a Microsoft Project file be used to generate a timeline in Visio? If so,
which versions of each program would I need?
And by timeline, I don't mean Gaant chart. I mean the timelines that I can
manually create in Visio using the Timeline Shapes stencil.
"Suzie" <SB29@mdahospital.com> wrote in message
> Can a Microsoft Project file be used to generate a timeline in Visio? If
> which versions of each program would I need?
This from v2003pro timeline help, your mileage may vary
Import Project da...Need to test a mobo
I had a power surge about 3 weeks ago - lost a drive, now making
ticking noises. I had another two drive that seem to work
sporadically now. So, I thought it might have been my power supply.
Bought a tester and found out that all seems well. Next, I bought a
new hard drive and found that it was also acting up - making noises
like whirring up and down (like the other drives I thought were
dead). So I am starting to wonder if it is my mobo - but how can I
test this out?
I am using a dual boot - Win XP and Win 7 - both drives work and don't
work. Up and down. Right now my Win7 ...Why is a .WAV file NOT automatically playing when I start the PPT
I inserted a .wav file in my powerpoint show and when I go to "view show,"
the animations work but the sound file does not play - either automatically
OR on mouse click. The other animations and their "effect options" sounds
play fine, but NOT the sound icon. I have checked with our school technician
and it is not a hardware problem b/c windows media player works fine.
Can you help me? I am a middle school special educator and I teach autistic
students. I need to run the Powerpoint I created for my disabled student to
Can you help me?
Th...GP 10.00 User Secury for Project Accounting
How can I grant user access to view Project Accounting Batch ID lookup
during PA Billing Transaction?
...Stuck in review and need to be in design.
I am using Visio 2007. I need to complete the diagram that I have been
working on and I hit the review key by mistake. How do I get back to the
On Wed, 4 Nov 2009 16:14:01 -0800, cameron <firstname.lastname@example.org> wrote:
>I am using Visio 2007. I need to complete the diagram that I have been
>working on and I hit the review key by mistake. How do I get back to the
menu Tools -> Track Markup
and then close the Review window.
Regards, Paul Herber, Sandrila Ltd.
DFD/SSADM for Visio http://www.visio-dfd.sa...CRM 1.2 Security Service Not starting
I have CRM 1.2 and SQL on the same box.
When the server is restarted, the CRM Security Service fails to start.
I must manually start the service.
Error "The Microsoft CRM Security Service Failed to
Start" During the Microsoft CRM Server Installation When
Microsoft CRM and SQL Server 2000 are Installed on the
>I have CRM 1.2 and SQL on the same box.
>When the server is restarted, the CRM Security Service
fails to start.
>I must manually start the service.
...Plug in needed
Looking for an Outlook plug in which, on reply to a e-mail, will:-
a) allow selective quoting only, and
b) not top quote.
Anything around at all?
Much to my horror (sorry guys) the Boss wants us to use Outofluck at work!
On the carpool lane lane to Nirvana.
John Phillips <email@example.com> wrote:
> Looking for an Outlook plug in which, on reply to a e-mail, will:-
> a) allow selective quoting only, and
> b) not top quote.
> Anything around at all?
The best Outlook adjunct I've found for quote handling on replies is
Outlook-Quotef...What is the Need for XSD in Application Blocks designing
Can anyone help in clearing my doubt
There is a need for me to implement Application Blocks in my project,
(Basically 3 tire), the project comprises of UIL, BLL,Business Entities,
DAL.. When i saw the example programs from User Interface Application Block
example, which is implementing the Business Layer part, Interface for BLL
and Business Entity part where by i am not able to understand the real usage
of XSD's and the autogenerated C#? Can anyone explain me what is the process
flow behind this fuda in a simple terms.
Thanks in Advance
...Selecting which Inbox to show at start-up
I am trying to sync my mail with my palm, and it will only sync the general
inbox, but my mail goes to the inbox of my mail account at my school. How
can I either get that mail moved to the general inbox at start-up, or just
switch that to be the main inbox?
If i could get outlook to check this other account at start-up it might be
fine, but i have to click on it to get it to check the school mail, even
though that is the only mail account i have set up
What type of account and version of Outlook are we talking about here?
Robert Sparnaaij [MVP-Outlook]
Tips...Which setting do I need to adjust
I've noticed that when using my default browser IE 8 and I click on a link
that is suppose to start a download, it doesn't. When I click on the same
link in firefox the download starts like it should.
Can anyone tell me what setting in IE 8 is preventing the download from
starting? on the page it says "Downloading: 50fpct-Just4freeplanet.com.rar |
34.7 MB" but in IE 8 it isn't downloading. It also isn't asking me if I want
to allow IE 8 to download the file like it sometimes does.
> I've noticed that when using my d...need to get my mail
how can i get my hot mail from here
You can't, this is a newsgroup, it has nothing to do with email.
"carlos" <firstname.lastname@example.org> wrote in message
> how can i get my hot mail from here
Windows Mail doesn't support HTTP mail, which for a long time was the=20
only allowed access method for free Hotmail accounts.
Earlier this year Microsoft enabled POP access for free Hotmail/Live/MSN
accounts. Follow the settings given here:
http://mailcall.spaces.live.com/Blog/cns!CC9301187A51FE33!4...Import delimited text to project
I'm trying to import a small text file (2 columns, 14 rows, tab-
separated) into an pre-created table in an Access 2003 project
(connected to SQL Server 2000 back-end).
This works fine interactively, but I cannot get it to go
programmatically. I've tried using TransferText in a macro, and
RunCode in a macro calling a VBA function.
If I omit column names from the 1st line of the input .txt file,
Access complains that the target table doesn't have a column called
'F1' (which is true if unhelpful). If I try to make life easy for it
by renaming my table columns to 'F1'...Do I need these?
I was looking through my Add/Remove Programs list and saw the
following. I have a Dell Latitude D600 with XP SP3. I use VB 6.0
The MSXML KBs stacked up? The .NET updates? Do I really need
-- Windows Live OneCare Scanner
-- MSXML 4.0 SP2 KBs 936181, 954430, 973688 w/ MSXML 6 SP2 KB 973686
-- VIsual C++ 2005 & 2008 Redistributables
-- MS .NET Framework 1.1, 2.0 SP2, 3.0 SP2, 3.5 SP1
-- Memory Key Boot Utility
Ed from AZ wrote:
> I was looking through my Add/Remove Programs list and saw the
> following. I have a Dell Latitude D600 with XP SP...Web Outlook & Exchange Setup need ideas
I currently have
Server: Windows 2000 Server, Exchange 5.
Clients: Windows 2000 Pro, Outlook 200
I am planning to install Outlook Web Access. I want to upgrade Exchange Server 5.5 to 2003. People say Ex 2003 does has installation probles with Win 2000 Server. Is this true
Does Outlook Web Access have to be installed on the same box that is running the Exchange Server? If it has to be, will it work if I install Exchange Server on a different box and have its information store point to the information store of my original Exchange Server. And then install Outlook Web Access on the new box
I a...save a publisher file as a JPG file, need to be more than default 150dpi
I am saving a publisher file as a jpg file but it only saves it with a dpi
of 150, i need this to be at least 300 dpi
please can someone advise how i can change and where i change the setting to
is it possible?
thanks in advance for your help
> I am saving a publisher file as a jpg file but it only saves it with a dpi
> of 150, i need this to be at least 300 dpi
> please can someone advise how i can change and where i change the setting to
> do this.
Try hitting "Change" where it says "150dpi" in the Save As dialog.
While you...Message Archiving Software Needed
Hi all -
I am looking for a recommendation on Exchange 2000/2003 message archiving
software. I would like it to archive the email as well as to have a
searchable database with reporting features.
I use Enterprise Vault (symantec, veritas) and it is ok... Supports
journalling and archiving of mailboxes. not much reporting capabilities but
has an altavista search engine to access old emails.
I have only used this product but would rate it 7/10... Heaps of room for
improvement and now symantec has it hopefully future versions will be better.
"Donni...need to re-join exchange 5.5 to mixed organization for public folders backup
I just removed the last exchange 5.5 from the mixed organization I
have. But now i'm missing some public folders!!!!
Can I re-join the exchange 5.5 server after deleting it from the
organization?? please help! Then I have to replicate the public
I have an exchange 2003 SP2 cluster and an another Ex 2003 where the
SRS service was running.
If I can not do this?? How can I restore the public folders to the new
Exchange 2003 server??
How about bringing up the 55 server and using Exmerge.
<email@example.com> wrote in message
news:firstname.lastname@example.org...need to transpose 3 or 4 columns to one column
The matrix below represents what I need to do in Excel. I need to
transpose the data from row 1 of C1, C2, C3 and C4 to rows 1-4 of C5
then repeat for each additional row of C1-C4. I think I might need a
macro but I have no idea how to write it. Any help would be
appreciated. My data set is too large to utilize cut and paste
special. Thank you for your responses.
C1 C2 C3 C4 C5
5 4 3 5 5
4 3 4 5 4
5 4 3 2 3
If your example table is entered in cells A1:D4, enter this into cell E2, and copy down until it
returns #REF ...how to start a new thread?
Sounds crazy, but I can't post a question in a normal way. I see the button
on the upper left side that has the name "New". When I click it there appear
Suggestion for Microsoft
Only when I wildly and repeatedly hit that list somewhere with my mouse
clicks a question screen will suddenly open. What is the standard procedure
to open the question screen? (I believe in a certain way one mouse click
should do the job, but as you will have guessed by now, I am but a dumb end
user, so please help)
The Net...plz solve this i need solution
guys, i have a student record and for that i calculate total,avg and
result but the problem is rank ....what i need is i would like to give
the rank to only pass student in sequence. but for the fail its show
fail....any formula ...plz see the attechment for this.........
...PB with OCX control integrated in Dialog in a DLL MFC project
I develop a DLL MFC using VStudio 7.0.
As soon as i integrate an OCX control in a dialog ressource, the CDialog
object linked to this ressource doesn't load. I try modal and modless
methods, Nothing happens.
Is there an option i've forgotten?
Is the control properly registered? Does it require a license? Has
AfxEnableControlContainer been called?
In article <7E9200A5-922F-403C-A33C-2118B318E0D9@microsoft.com>,
> Hi all,
> I develop a DLL MFC using VStudio 7.0.
> As soon as i integrate an OCX co...I need to know if there is a template for my needs...
I'm trying to compile a scheduling program via Access/2000 (Yeah, I know
that's an old program....LOL. thanks for my employer's budgeting...LOL). I
trying to setup a scheduling process for teachers and students and be able to
print forms....Is there a template that you could suggest that I try and use?
I need a formula that finds the closest sum of the list of bills to the
specified amount, i.e
Amount $ 70.00
In this case formula should highlight or indicate in some way cells
with amounts $30.00 and $30.00 and show the total of these cells.
Roman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24442
View this thread: http://www.excelforum.com/showthread.php?threadid=380407
Try this, Roman: