software

Hi,

I want to make a .xls with my working hours to calculate my wage. I designed
myself a lay out but I can't make it. What I want is 13 identical tabs for my
periodes. Within one tab I want the dates of those periodes quot;groupedquot; in
weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
7 rows of the first coloms have the 7 dates of the first week. Then again 2
blank rows and the next week begins. Till I have 4 weeks which make up one
periode. Above one tabel which makes up a week I want a one cell telling me
the week number (hence the reserved free rows).
This is the general lay-out. But I want it to be automated. In colom A row 1
I want to type the year (2006 is this case) and I want to write down the date
of the first of the first day of the first week of the year. With this info I
want the file to calculate all dates; weeknumbers etc.

I know I want a lot. And I admit I do not have the full grasp of the scope
of this problem but I think it's possible but I don't know how to build it.
Is there anybody who can assist me with general guide lines and maybe an
other angle of looking at this problem?

Would this mean that you are going to use one row just for a date, and maybe
a start time, end time, total time and amount? In stead of using rows, why
don't you use column instead. Iow, have one period's dates in a single row?
And then obviously have 13 rows? Just wondering, as I do not have enough
detail to really make a suggestion.

quot;carnelainquot; wrote:

gt; Hi,
gt;
gt; I want to make a .xls with my working hours to calculate my wage. I designed
gt; myself a lay out but I can't make it. What I want is 13 identical tabs for my
gt; periodes. Within one tab I want the dates of those periodes quot;groupedquot; in
gt; weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
gt; 7 rows of the first coloms have the 7 dates of the first week. Then again 2
gt; blank rows and the next week begins. Till I have 4 weeks which make up one
gt; periode. Above one tabel which makes up a week I want a one cell telling me
gt; the week number (hence the reserved free rows).
gt; This is the general lay-out. But I want it to be automated. In colom A row 1
gt; I want to type the year (2006 is this case) and I want to write down the date
gt; of the first of the first day of the first week of the year. With this info I
gt; want the file to calculate all dates; weeknumbers etc.
gt;
gt; I know I want a lot. And I admit I do not have the full grasp of the scope
gt; of this problem but I think it's possible but I don't know how to build it.
gt; Is there anybody who can assist me with general guide lines and maybe an
gt; other angle of looking at this problem?

Yes, I want to use one row for one date. In the row is also coming the start
and end time of my shift. I have formulas to calculate my breaks and my extra
hours. And I need a sum of the weeks total. I am getting paid every 4 weeks
which is the period so I want a sum of my wage of every period and I want to
have every period on a different tab.
I hope this is enough info. Just ask for more if you need.quot;kassiequot; wrote:

gt; Would this mean that you are going to use one row just for a date, and maybe
gt; a start time, end time, total time and amount? In stead of using rows, why
gt; don't you use column instead. Iow, have one period's dates in a single row?
gt; And then obviously have 13 rows? Just wondering, as I do not have enough
gt; detail to really make a suggestion.
gt;
gt; quot;carnelainquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I want to make a .xls with my working hours to calculate my wage. I designed
gt; gt; myself a lay out but I can't make it. What I want is 13 identical tabs for my
gt; gt; periodes. Within one tab I want the dates of those periodes quot;groupedquot; in
gt; gt; weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
gt; gt; 7 rows of the first coloms have the 7 dates of the first week. Then again 2
gt; gt; blank rows and the next week begins. Till I have 4 weeks which make up one
gt; gt; periode. Above one tabel which makes up a week I want a one cell telling me
gt; gt; the week number (hence the reserved free rows).
gt; gt; This is the general lay-out. But I want it to be automated. In colom A row 1
gt; gt; I want to type the year (2006 is this case) and I want to write down the date
gt; gt; of the first of the first day of the first week of the year. With this info I
gt; gt; want the file to calculate all dates; weeknumbers etc.
gt; gt;
gt; gt; I know I want a lot. And I admit I do not have the full grasp of the scope
gt; gt; of this problem but I think it's possible but I don't know how to build it.
gt; gt; Is there anybody who can assist me with general guide lines and maybe an
gt; gt; other angle of looking at this problem?

I'll see what I can work out. Still don't think it is the best way, but
that's what you want!

quot;carnelainquot; wrote:

gt; Yes, I want to use one row for one date. In the row is also coming the start
gt; and end time of my shift. I have formulas to calculate my breaks and my extra
gt; hours. And I need a sum of the weeks total. I am getting paid every 4 weeks
gt; which is the period so I want a sum of my wage of every period and I want to
gt; have every period on a different tab.
gt; I hope this is enough info. Just ask for more if you need.
gt;
gt;
gt; quot;kassiequot; wrote:
gt;
gt; gt; Would this mean that you are going to use one row just for a date, and maybe
gt; gt; a start time, end time, total time and amount? In stead of using rows, why
gt; gt; don't you use column instead. Iow, have one period's dates in a single row?
gt; gt; And then obviously have 13 rows? Just wondering, as I do not have enough
gt; gt; detail to really make a suggestion.
gt; gt;
gt; gt; quot;carnelainquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I want to make a .xls with my working hours to calculate my wage. I designed
gt; gt; gt; myself a lay out but I can't make it. What I want is 13 identical tabs for my
gt; gt; gt; periodes. Within one tab I want the dates of those periodes quot;groupedquot; in
gt; gt; gt; weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
gt; gt; gt; 7 rows of the first coloms have the 7 dates of the first week. Then again 2
gt; gt; gt; blank rows and the next week begins. Till I have 4 weeks which make up one
gt; gt; gt; periode. Above one tabel which makes up a week I want a one cell telling me
gt; gt; gt; the week number (hence the reserved free rows).
gt; gt; gt; This is the general lay-out. But I want it to be automated. In colom A row 1
gt; gt; gt; I want to type the year (2006 is this case) and I want to write down the date
gt; gt; gt; of the first of the first day of the first week of the year. With this info I
gt; gt; gt; want the file to calculate all dates; weeknumbers etc.
gt; gt; gt;
gt; gt; gt; I know I want a lot. And I admit I do not have the full grasp of the scope
gt; gt; gt; of this problem but I think it's possible but I don't know how to build it.
gt; gt; gt; Is there anybody who can assist me with general guide lines and maybe an
gt; gt; gt; other angle of looking at this problem?