Pages

Search

Microsoft Works - Works guest list template

Microsoft Works - Works guest list template

Works guest list template

Posted: 04 Oct 2008 10:30 AM PDT

Hattieruth,
You are quite welcomed!

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"Hattieruth" <microsoft.com> wrote in message
news:com...
Thanks for all your help. I really appreciate it.

Works Calendar - Colour Change

Posted: 03 Oct 2008 12:54 PM PDT

My calendar is purple, (works 9) and I would like to have other options also.
If anyone out there has any solutions please reply.

"st" wrote:
 

boarder art

Posted: 03 Oct 2008 12:51 AM PDT

craig wrote: 

A quick Google image search (
http://images.google.co.uk/images?q=boarder%20art* ) returns lots of
artwork featuring boarders of, er, variable quality.

Convert Works Database into Excel

Posted: 30 Sep 2008 05:29 PM PDT

It should. As I recall, Works Suite 200 is Works version 5. If the
install gives you an option, just install the Works and not the Suite
add-ons. You probably already have a newer version of MS Word.

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"frankiegospel" <microsoft.com> wrote in
message news:com... 

Consultation about a formula for works...

Posted: 29 Sep 2008 03:55 PM PDT

From Works help:

Click the data entry values such as text or numbers in cells you want to
repeat.
With the mouse pointer, point to the lower-right corner of the cell (the
intersection of a row and column that can contain text or numbers that
contains the entry).
When the pointer looks like a plus, drag down the rows to select more cells.
When you release the mouse button, Works repeats the text in the selected
cells.

Tip

You can also repeat text by clicking a data entry, and then dragging down
the rows where you want the data entry to appear. On the Edit menu, click
Fill Down.
--
Ronald Sommer


"MR FORMULAS" <microsoft.com> wrote in message
news:com... 

using Works Database

Posted: 27 Sep 2008 07:31 PM PDT

Hi Raymond,

Works database report limits the use of functions as you encountered.

The formula has to be entered into List view - a field that will hold the 'markings'
i.e. asterisk etc. This then becomes the value displayed in the report as indicator.

You may wish to use a new record line to print the asterisk etc. above the actual
score achieved per hole.

HTH,
--
Kevin James



"Raymond" <microsoft.com> wrote in message
news:com...
|
|
| "Raymond" wrote:
|
| Hi Kevin,
|
| I tried your formula and Works said that the function "IF" is an invalid
| function in a Works report. The Works functions (AVG, COUNT, MAX, MIN, STD,
| SUM, and VAR) will not work either. I was hoping a formula something like,
| where "HFHDC" record value is equal to "hfhc" record value to write the
| record
| value of "Hole10", ect. Maybe this is not possible in the Works Database.
| Any
| other ideals would be appreciated.
|
| Thanks for all your help,
|
| Raymond
| >
| > "Kevin James" wrote:
| >
| > > Hi Raymond,
| > >
| > > That page explains it all.
| > >
| > > You wish to find a hfhc value that matches the player's HFHDC value and then
| > > identify the hole numbers for which the player receives an allowance. This is to
| > > be signified in the report with the display of a plus, an asterisk, an asterisk
and
| > > a plus or two asterisks ( 0.5, 1, 1.5, 2 ).
| > >
| > > One way of treating this is to say e.g. that Hole 10 is 'used' when HFHDC is
| > > greater than 6.5. Hole 10 has 5 different values that it can hold, all based on
the
| > > HFHDC value.
| > >
| > > So perhaps, a formula that has the following 'pattern' can be used e.g for Hole
10
| > >
| > > =IF('HFHDC< 6.5,"",IF('HFHDC=6.5,"+",IF('HFHDC<15.5,"*",IF('HF HDC=15.5,"*+","**"))))
| > >
| > > HTH,
| > > --
| > > Kevin James
| > >
| > >
| > >
| > >
| > > "Raymond" <microsoft.com> wrote in message
| > > news:com...
| > > |
| > > |
| > > | "Kevin James" wrote:
| > > |
| > > | > Hi Raymond,
| > > | >
| > > | > It's good news to hear that you are progressing well with your database.
| > > | >
| > > | > To retrieve the value for field 'Hole11 when the 'HFHDC and 'hfhc" fields
| > > | > are equal in value you may set up new fields, in list view, with the
formula:
| > > | >
| > > | > =IF('HFHDC ='hfhc,'Hole11,'"othervalue?")
| > > | >
| > > | > where "othervalue" is whatever other value you wish to use when HFHDC
| > > | > and hfhc are not equal.
| > > | >
| > > | > I don't understand ( golf and ) how this will operate to provide the
solution
| > > | > to your statement below nor why hole 11 is used.
| > > | >
| > > | > "I will then need to write it for each hole, 10 thru 18, which will dot
the
| > > | > score card on the holes of which each player would receive a stroke,
| > > | > based on his handicap."
| > > | >
| > > | > If you intend to compare the two handicaps and the hole 'par' and mark the
| > > | > hole (report) with an asterisk if they are equal then perhaps you are
looking
| > > | > for something close to:
| > > | >
| > > | > =IF('HFHDC ='hfhc,'*","") which returns an asterisk if equal or else
'nothing'
| > > | >
| > > | > HTH,
| > > | > --
| > > | > Kevin James
| > > | >
| > > | >
| > > | Thanks Kevin,
| > > | If you have time please go to http://www.jhga.org and click on the "Misc"
| > > | link in the navigation bar. I have a copy of the database and report which
| > > | might help me in explaining what I'm trying to accomplish.
| > > | Raymond
| > > | >
| > > | > "Raymond" <microsoft.com> wrote in message
| > > | > news:com...
| > > | > | Hi Kevin,
| > > | > | In reference to my post on 9/15 for designing a golf score card with the
| > > | > | Works Database. I have the design completed as I want in a report. I still
| > > | > | need to write a formula that will use the record value of my "HFHDC" field
| > > | > | and match the record value of the "hfhc" field and then get the record value
| > > | > | of my "Hole11" field. If a formula can be used to do this, I would appreciate
| > > | > | if you will write an example for me. I will then need to write it for each
| > > | > | hole, 10 thru 18, which will dot the score card on the holes of which each
| > > | > | player would receive a stroke, based on his handicap. I have my database list
| > > | > | with the HFHDC field to provide the players' handicap, the hfhc field to
| > > | > | provide the course handicap rating for each hole, and each Hole fields (10
| > > | > | thru 18) to provide asterisks that dots the score card for the stroke holes.
| > > | > |
| > > | > | Thanks,
| > > | > | Raymond
| > > | >
| > > | >
| > > | >
| > > | >
| > >
| > >
| > >
| > >

Importing legacy Works Calendar with Outlook 2007?

Posted: 26 Sep 2008 09:20 AM PDT

You are welcome and thanks for posting back.

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"Xandrakkan" <microsoft.com> wrote in message
news:com... 

Where is Works Calendar file saved to?

Posted: 25 Sep 2008 10:08 PM PDT

mswkscal.wcd is where Works calendar data is stored.

Works calendar reads the gibberish you see in the mswkscal.wcd file.

If you are in doubt whether the calendar is displaying what is in the
mswkscal.wcd file, tempory move mswkscal.wcd out of it's existing folder,
open calendar, it should display an error message. If it doesn't, then the
file you moved is not the one Works calendar is reading.

Hope this helps,
Ken

"Bacchus41" <microsoft.com> wrote in message
news:com...

|I have looked at the files named in the support article but they are
exactly
| the same size with data entered into the calendar as they were empty. Is
| there somewhere else to look or is there a way to read the gibberish in
the
| files to see if something is really stored there? I lost everything once
| already when SP3 ruined the files in my computer and I had to start over
with
| a clean install. I would really like to be able to back these files up.
|
| "Kevin James" wrote:
|
| > Hi Dave,
| >
| > These are the Calendar files installed by Works Calendar.
| >
| > http://support.microsoft.com/?kbid=909529
| >
| > HTH,
| > --
| > Kevin James
| >
| >
| >
| >
| >
| >
| >
| >
| > "Dave" <microsoft.com> wrote in message
| > news:com...
| > |I have searched high and low on my computers to find where Calendar's
data is
| > | stored, but can't find it. I've selected hidden and system files in
the
| > | searchl. I have looked for files with today's date. I have searched
| > | manually. But I can't find it.
| > |
| > | I ask this because when I reformatted my drive last year, I got my
data
| > | saved -- except for Calendar data because it was stored in an odd
place. i
| > | would like to save the file to another place so that that doesn't
happen
| > | again. But, I just can't find it.
| > |
| > | Thanks for any insight,
| > | Dave
| >
| >
| >

Finding the correct formula for this explanation

Posted: 21 Sep 2008 02:34 PM PDT

MR FORMULAS,
For a single item X quantity use the following:

A1= Item Name
B2= Quantity
C2= Per Unit Price
D2= Fee Charge
E2= The following formula, then drag the fomula down the length of the
column.

=IF($B2="","",IF(($B2*$C2*$D2)<1.01,1,IF(($B2*$C2* $D2)>60.01,60,($B2*$C2*$D2))))

Or you can just add the Fee Charge Percentage in the formula, like this, in
your fee column.

=IF($B2="","",IF(($B2*$C2*0.01)<1.01,1,IF(($B2*$C2 *0.01)>60.01,60,($B2*$C2*0.01))))

If it is multiple items to the same receipient, then you will need to get
the total of the order, before applying the following.

If you designate E10 as the cell that your total in E11 place the following
formula:
=IF(($E10*0.01)>60.01,60,IF(($E10*0.01)<1.01,1,($E 10*0.01)))

Or if you place the percentage for the fee in a cell, use the cell address
to multiply with the total.




--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"MR FORMULAS" <MR microsoft.com> wrote in message
news:com...
I've been trying to create a spread sheet, that calculates all my fees,
profits, starting from distributors to the cost of shipping to Mexico, which
I have already, and has beed designed in works the website similar to Ebay,
infact its the same company, I'm new at works, and I got stuck at this
formula that I can't get it to work right because I believe Im not very
savvy
about works and formulas.

What I am trying to do is this...

This company charges you (1%) of price of item being sold, but minimum
charge it's ($1 dlls) max $60 dlls, meaning that If I sell 7 CARS @ $1000
each one, then 1000 X 1% X number of cars (7) = $70, but the max they can
charge you is $60. So $70 will be decrased to $60.00, same as well if the
charge it's less than $1 dollar how can I make it to display $1 dollar?. How
can I express this on WORKS?"

Excell

Posted: 21 Sep 2008 06:19 AM PDT

I CAN NOT ACCESS MICROSOFT 2007 wrote: 

Please rephrase your question in the form of a question, rather than a
post which is empty save for the quoting of someone else's post.

....

What is "Microsoft 2007"? Is it related to Microsoft Windows Vista,
which stumbled into the world in 2007?

Works 9 Calendar import

Posted: 19 Sep 2008 03:01 PM PDT

Jeffrey Needle wrote: 

Well, I've tried .ics and .vcs, and neither one will work. I looked on
the web, and others seem to have had similar problems. But no fix seems
to be forthcoming. I'm searching the Microsoft site to see if something
comes up.

If anyone has other ideas, I'm all ears. Thanks.