On Wed May 3 2006 02:05, + John Toliver wrote:
> I am using Open Office 2.0 on windows xp
>
> I am trying to create a spreadsheet which totals my work hours for a two
> week period, and then shows me what my gross pay and total hours will be
> for this period. I want each table to be duplicated four times on the
> sheet. Then I want to create 12 sheets, one for each month with 4 tables
> and a final that will give me year totals I can use when I am doing my
> taxes.
>
> So basically, I am just making extensive use of the "sum" function in calc.
> The first problem I run into is that on the template I am editing, when I
> change the weekly total column to "sum(mtwtf)" it won't display on the
> sheet itself. The sheet returns zero but when I go to the function wizard
> to check my input, it calculates it properly so I know wht I entered is
> correct(I put in some dummy totals to make sure the functions worked). I
> went hunting for a "refresh button" and didn't find one so I'm confused
> here How can I make the spreadsheet display the totals properly? I also
> find that I am unable to get the data to reflect properly when I try to say
> in an adjacent cell: ("sum(<week1totalhours>;<week2totalhours>")=total
> hours for pay period and then in another cell say:
> (<payrate>*<cell_with_total_hours_for_two_weeks>)=gross pay for pay period.
>
>
>
> I believe that if I fix the first then the others will then start updating
> properly. The help says I am doing it correctly but I can't make it
> reflect.
> If this helps, I have the total hours for each day calculated also and this
> displays properly. and I base my other formulas off of this basic input.
> Anyhelp would be appreciated and if this doesn't make sense, I will rewrite
> this differently to be more clear.
As you are not subscribed you may not have seen that:
On Wed May 3 2006 11:27, Dan Lewis wrote:
>
> Would you please post this speadsheet on the web and send its address to
> this mailing list? Include some data in it also. Then several people can
> look at what you have and suggest changes.
Please reply to [email protected] only.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
