Converting letters to numbers
Thu, 8 Jun 2006 12:14:20 +0200
I am a teacher looking for an easy way to convert letters to numbers. My
students get their grades A - F. To calculate their average grade, I need to
convert the letters to numbers, calculate the average and then back to
letters. Typically the list would look something like this:
Subject 1 Subjec ...
|
Great time in France
Wed, 7 Jun 2006 15:13:28 +0100
Hello
I had a fantastic time in France, hope to visit again soon.
I found a holiday cottage from these guys www.looktogo.co.uk http://www.looktogo.co.uk
Regards,
Dancer: ). ...
|
File Links - Drive Mapping
Mon, 29 May 2006 23:21:02 -0700
Hi,
whenever my client opens a spreadsheet (Office XP) with linked files, it
creates a network drive mapping (z:) even though the links point to the h:
What is causing this or where else can I look to stop it mapping the z: drive.
Thanks,
Graham ...
|
Debit McCredit Personal Finance Software
Sun, 28 May 2006 22:41:58 -0400
If you are looking for a good alternative to Quicken or Money, then give
Debit McCredit a test drive.
Available from CNET's Download.com at:
http://www.download.com/3120-20_4-0.html?tag=srch&nid=1&qt=debit+mccredit&tg=dl-2001
Also available directly from the publisher at:
http://www.debitmccredit.com/
...
|
Excel files suddenly need a password to open
22 May 2006 05:05:53 -0700
I've got a client who emails Excel files which are created from
templates and contain cells which are protected and also a macro with
password protection. The password for both cells and macro are the
same. The original templates were created with Excel 2000. Now when the
files are dragged and dropped from Out ...
|
Staff Rota Template?
Fri, 19 May 2006 15:54:13 GMT
Hi
I am trying to design a staff duty rota template for a shop open 7 days per
week. We have between 4 6 staff (depending on seasonal fluctuations) and
each member of staff has two days off per week.
I have searched the Microsoft database of templates and found nothing that
will allow me to input staff name ...
|
Weighted Survey Results
17 May 2006 07:19:25 -0700
Can I please have some help in determining the best way to complete an
analysis? I have two colummns 1) number of surveys completed and 2)
overall score. I have listed a sample below:
# of Surveys Rec'd Score Presenter
159 3.75 Ed
48 ...
|
|
|
Cointact me
Thu, 11 May 2006 23:08:47 GMT
I have a budget template for a restaurant that produces a budget, 5 year
forecast, breakeven analysis and chart, and a vash flow statement and busjet
variance sheet, if you contact me on
pbraun1@bigpond.net.au I can send you it, depending on your country you may
have to alter it
Peter
...
|
if statement
Thu, 11 May 2006 09:39:17 GMT
Can anyone tell me how to put more than 9 if statements into a single
formula ? I can get 9 om a row but not 9
for instance if i want to detect the numbers of days in a mont on a large
spreadsheet I may enter
=if(a1="Jan",31,if(a1="Feb",28,if(a1="Mar",31,0))) and so on, I can get it
to work upto September ...
|
Excel error using .NET web application-help ASAP
Wed, 10 May 2006 16:42:01 -0700
Hi,
I am accesing a excel file from .NET web application. This excel file is a
used as a template with macro written inside.Following program code calls the
excel file .
ConnExcel = server.CreateObject("ADODB.Connection")
ConnExcel.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DBQ="
& strEx ...
|
