Forum Discussion
I need to count how many times 2 different letters appear in a column & totals in diff. cells
I'm actually not expecting you to understand all that I've done here. But yes, to your question, the list will just keep going. That's the thing about a database. And NO, you won't need to add a new sheet for a new month. That's another thing about a database. The reporting can be tailored to whatever timeframe you wish.
So I've been playing around a bit myself as you'll see on the attached. I've gone away from the Pivot Table to the newest technology that Microsoft has introduced just in the last year...ARRAY formulas. Just been learning them over the last week or two.
I added a column here to make it easier to select a week--this column determines a week number (e.g. the 14th week of the year)--and does it automatically based on the date you enter. Then to create a report, you just enter the start date of the week (I'm assuming Sundays for that)....and it automatically adjusts for that week.
And as you add rows to the database....it captures them and reports them for the corresponding week.
Now: I can help you create a drop down list of names for each center and then, for each center, a specific list of names of the people who are deployed in that center. You could update it from there, so it always was current.
Why don't you email me a list of the actual names of your Agencies....I'll create dummy lists for you to complete of the actual names of the real people....
As for the quarantine cases, it probably makes sense to track those on a separate sheet. It could be part of the same workbook, just so all of your records are in the same place.
And you'll be off and running for the next week and the rest of the year.
mathetesI can attach the names of the agencies or just a list of them or I can send you a copy of the workbook I am using which each tab has the agency name and the agency people that have been sent so far for deployment it is only last names used if there are the same last name there is just first initial. the tab with command is the staff in the operations center.
I don't know if that is ok?
I have been playing around with the book you have sent me and I know it can be done but not sure how, but can there be like more freedom as to the fact that it will auto complete items such as year and etc.?
Please let me know
Thank you,
I think this will be awesome!!!
To send a private message, you click on the person's name at the top of one of a posting. Doing that takes you to the person's "Profile" page, and up at the top right corner you'll see a "Message" block.
You guys are having great fun - so I won't interfere!
But I note that you said you sent a private message. Can you tell me how to do that please? many thanks,
- That would be cool also! I just sent you a private message also.
It occurred to me that it might be a lot more functional for an attendance tracker if the names of the people were in alphabetical order by last names, and fortunately that kind of thing is very easy. So this version works that way.
I'm sure you'll also want to revise the report format, or add additional capabilities--e.g., showing two, three or even four weeks in succession. That can be done. Let's do a few revisions along those lines before you start filling in the actual names. You can plan to start using this for your May tallies, at the very latest. If we work fast, maybe by this coming week.
- Fire Response Protection detail for Correctional Facilities
- these are the Agency names:
Downstate
Eastern
Fishkill
Green Haven
Otisville
Shawangunk
Sullivan
Ulster
Wallkill
Woodbourne
Auburn
Cayuga
Elmira
5 Points
Mohawk
Coxsackie
Oneida
Southport
Command
