I
Inexcelhell
_*Number*_ _*Status*_ _*Date*_
N01-02 Draft 4-May-05
N01-02 Draft 4-May-05
N01-92 In Process 15-Oct-05
N01-88 Draft 15-May-05
N01-29 In Process 9-Jul-05
N01-32 In Process 9-Jul-05
N02-22 Draft 24-Aug-05
N02-27 Draft 24-Aug-05
N20-12 Assigned 3-Dec-05
N24-19 Draft 24-Aug-05
N33-13 Doc Written 4-May-07
N44-04 Cancelled 15-Oct-05
My header are Number, Status, and Date (columns A,B and C). The
dcuments represent my rows (A2-A13).
Since I don't know how to write HTML and indent in the is post, let m
just say:
So for example, my first spreadsheet entry is: Number=N01-02
Status=Draft; Date=4-May-05
In my real file, I have over 300 documents. The documents are i
groups. Let’s say "N01" is a group of like documents about Dogs. Th
next two numbers “-02” give the document its uniqueness (aside from it
Title, which I have not represented in the example for simplicity sake)
Let’s say the “-02” part is dealing with green dogs. And if I were t
pick on another document. Let’s say N01-92; that would be about re
dogs. And N33-13, another group would be about fat birds and so on. Go
me so far?
What I need to do is take every document group and find out fo
example:
How many N01 documents did I finish in the first quarter of the year?
How many N44 documents do I have in draft this quarter, which in th
fourth quarter?
Every single status, I have to in some way account for in eac
document.
At some point, the status of the documents changes as the documents ar
progressing to different stages. But I want to this informatio
documented. Most likely all of my summing and counting and such will b
on a summary page separate from the tab I’ll be counting.
--Please hellllpppp!!
N01-02 Draft 4-May-05
N01-02 Draft 4-May-05
N01-92 In Process 15-Oct-05
N01-88 Draft 15-May-05
N01-29 In Process 9-Jul-05
N01-32 In Process 9-Jul-05
N02-22 Draft 24-Aug-05
N02-27 Draft 24-Aug-05
N20-12 Assigned 3-Dec-05
N24-19 Draft 24-Aug-05
N33-13 Doc Written 4-May-07
N44-04 Cancelled 15-Oct-05
My header are Number, Status, and Date (columns A,B and C). The
dcuments represent my rows (A2-A13).
Since I don't know how to write HTML and indent in the is post, let m
just say:
So for example, my first spreadsheet entry is: Number=N01-02
Status=Draft; Date=4-May-05
In my real file, I have over 300 documents. The documents are i
groups. Let’s say "N01" is a group of like documents about Dogs. Th
next two numbers “-02” give the document its uniqueness (aside from it
Title, which I have not represented in the example for simplicity sake)
Let’s say the “-02” part is dealing with green dogs. And if I were t
pick on another document. Let’s say N01-92; that would be about re
dogs. And N33-13, another group would be about fat birds and so on. Go
me so far?
What I need to do is take every document group and find out fo
example:
How many N01 documents did I finish in the first quarter of the year?
How many N44 documents do I have in draft this quarter, which in th
fourth quarter?
Every single status, I have to in some way account for in eac
document.
At some point, the status of the documents changes as the documents ar
progressing to different stages. But I want to this informatio
documented. Most likely all of my summing and counting and such will b
on a summary page separate from the tab I’ll be counting.
--Please hellllpppp!!