| Nbr |
Screen name/task |
Status |
Est. Hrs |
Estimate Cost |
Act. Hrs |
Actual Cost |
Notes |
Phase sort |
| 1 |
Import
Angel History from external system using temporary DB. |
Complete |
2.0 |
$90.00 |
|
|
|
1 |
| 2 |
Delete Angel fails to delete AngelBaseT2 record. |
Complete |
1.0 |
$45.00 |
|
|
|
1 |
| 3 |
Reorder children imported from history |
Complete |
1.0 |
$45.00 |
|
|
|
1 |
| 4 |
New text field for Family page 20 characters + add to report
option + search for option. |
Complete |
2.0 |
$90.00 |
|
|
|
1 |
| 5 |
Change
Printed Application to use Child Letters (A/B/C) instead of numbers |
Complete |
0.5 |
$22.50 |
|
|
|
1 |
| 6 |
Building the ID + Name -
prevent single quote HOH + all child ASP |
Complete |
0.5 |
$22.50 |
|
|
|
1 |
| 7 |
Change printed Application to use Boy/Girl instead of M/F |
Complete |
0.5 |
$22.50 |
|
|
|
1 |
| 8 |
Handle or prevent a slash (/) in Corps name |
Complete |
0.5 |
$22.50 |
|
|
|
1 |
| 9 |
Site Setup - Print ID on App Yes/No - Hosted |
Complete |
1.0 |
$45.00 |
|
|
|
1 |
| 10 |
New Family field for Email Address + add to App Print +
Downloads |
Complete |
2.0 |
$90.00 |
|
|
|
1 |
| 11 |
Manual ID field in Search |
Complete |
0.5 |
$22.50 |
|
|
|
2 |
| 12 |
Manual ID field in Bags |
Complete |
0.5 |
$22.50 |
|
|
|
2 |
| 13 |
Manual ID field in Bike/Box |
Complete |
0.5 |
$22.50 |
|
|
|
2 |
| 14 |
Manual ID field in BarCode and BC Import |
Complete |
1.0 |
$45.00 |
|
|
|
2 |
| 15 |
Rename Corps function -- handles Corps name in other tables. |
Complete |
1.0 |
$45.00 |
0 |
$0.00 |
|
2 |
| 16 |
Site Setup option to allow users to delete a child |
Complete |
2.0 |
$90.00 |
|
|
|
2 |
| 17 |
Disabled Person flag to override age for child Angels,
Statistics, Export, + Angel Reports |
Complete |
5.0 |
$225.00 |
|
|
|
2 |
| 18 |
Enter Manual Client ID twice to verify ID |
Complete |
1.0 |
$45.00 |
|
|
|
2 |
| 19 |
Manual ID Profile1 + Profile1add - Default Corps code, Check for
space in ID + Verify starts with Corps Code in Add Record |
Complete |
1.5 |
$67.50 |
|
|
|
2 |
| 20 |
Change Adopt_a_Family to use a DB field for the text of the
message. Requires a new update field
in Corps setup pages. |
Complete |
1.5 |
$67.50 |
0 |
$0.00 |
|
2 |
| 21 |
Limit find screen results to 200 rows -- Next / Prev option |
Complete |
2.0 |
$90.00 |
|
|
|
3 |
| 22 |
Site Setup. Age calc
field for Child Angel and Elder Angel.
New DB fields. Enter a date to calculate the age of the Angel
(currently uses Christmas day). |
Complete |
4.0 |
$180.00 |
|
|
|
3 |
| 23 |
If Age Calc field is changed for Child/Elder Angel - recalculate
all Angels? |
Complete |
2.0 |
$90.00 |
|
|
|
3 |
| 24 |
Gift required on the textbox (1 / 2 / 3) Flag |
Complete |
1.0 |
$45.00 |
|
|
|
3 |
| 25 |
Option to manually enter a single Application number. Select from list of Missing/Deleted
Applicaiton numbers and takes you to Add Application screen. |
Complete |
2.5 |
$112.50 |
0 |
$0.00 |
|
3 |
| 26 |
Purge history older than date |
Complete |
2.0 |
$90.00 |
|
|
|
4 |
| 27 |
Audit trail of DB functions.
IP address + new report like login log Adminlog |
Complete |
2.0 |
$90.00 |
|
|
|
4 |
| 28 |
Angel Count by City/County depends on Zip Code. How to use city Name? |
Complete |
2.0 |
$90.00 |
|
|
|
4 |
| 29 |
RunSQL Super User Page |
Complete |
1.0 |
$45.00 |
0 |
$0.00 |
|
4 |
| 30 |
Angel_Reports - Trim Forgotten Child name to 25 characters |
Complete |
0.5 |
$22.50 |
|
|
|
5 |
| 31 |
Angel Reports - Option to include First Name on Forgotten (Y/N) |
Complete |
1.0 |
$45.00 |
|
|
|
5 |
| 32 |
Export using XML instead of Excel for Import into Access |
Complete |
4.0 |
$180.00 |
0 |
$0.00 |
|
5 |
| 33 |
Angel_Reports - Reminder letter was sending to All - not just
approved.' |
Complete |
1.0 |
$45.00 |
|
|
|
5 |
| 34 |
Angel_Reports - Use Calculated Date - not Christmas day for Age
(Angel/Elder) |
Complete |
2.0 |
$90.00 |
|
|
|
5 |
| 35 |
Angel_Reports - Updated copy of ATL reports for system |
Complete |
0.5 |
$22.50 |
|
|
|
5 |
| 36 |
Angel_Reports - Remove Angel Return Message from Web + Download
+ Reports |
Complete |
1.0 |
$45.00 |
|
|
|
5 |
| 37 |
Angel_Reports - 3x5 Label like Bryan TX |
Complete |
0.5 |
$22.50 |
|
|
|
5 |
| 38 |
Angel_Reports - Add Angel
Age to setup option for printing Angels.
(How to match against Statistics) - or use Site Setup |
Complete |
2.0 |
$90.00 |
0 |
$0.00 |
|
5 |
| 39 |
Angel_Reports - Forgotten Angels formula can currently duplicate
a certain number of angels. Add a
check-box to prevent (skip previously selected) so that this won't happen
when getting the next Age/Gender child. |
Complete |
1.0 |
$45.00 |
0 |
$0.00 |
|
5 |
| 40 |
BarCode Import -- add Time field to DB fields |
Complete |
0.5 |
$22.50 |
|
|
|
6 |
| 41 |
Statistics + Export Error Report - very large Angel count needs
to be added |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 42 |
Statistics + Export Error Report - Duplicate Client ID (Manual
ID) |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 43 |
Statistics + Export Error Report - Blank Family Name |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 44 |
Statistics + Export Error Report - No Age or No Age Qualify |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 45 |
Statistics + Export Error Report -Corps Code wrong (Manual ID) |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 46 |
Angel count lists 10 twice? |
Complete |
1.0 |
$45.00 |
|
|
|
6 |
| 47 |
IE8 - Print button not printing second page. |
Research |
1.0 |
$45.00 |
|
|
|
6 |
| 48 |
Child shows up on another record ? Why? NCAC reported 2010 |
Research |
5.0 |
$225.00 |
|
|
|
7 |
| 49 |
Problem with leading zeros and zip codes in Java Code Lookup |
Research |
2.0 |
$90.00 |
|
|
|
7 |
| 50 |
Save year-end statistics (angels, apps, people) for year - year
comparison. New DB table, Create and edit screens. |
Future Enh |
4.0 |
$180.00 |
|
|
|
10 |
| 51 |
Import from/to excel Bike List |
Future Enh |
2.0 |
$90.00 |
|
|
|
10 |
| 52 |
Need a way to dynamically design the angel tag. Build the query based on fields selected so
that Corps can modify what is printed. |
Future Enh |
3.0 |
$135.00 |
0 |
$0.00 |
|
10 |
| 53 |
Web-based public view adopt an Angel screen. Public View shows Age and Gender available
counts. Pick one and see a list of
first name and wishes. Pick one and
fill in Name / email / phone to adopt.
Receive Email and see an option to Print_your_Angel. (Permission to
use jpg or scan of tag? Save in
Sponsor Table. |
Future Enh |
6.0 |
$270.00 |
|
|
|
10 |
| 54 |
When you want to keep all application numbers together for a
multi-Corps setup, How to identify the sub-Corps code? Like Kroc-Center has several B&G Clubs
operating from the same setup. Add the
ID code to the Angel Data Download and then use it when printing? Append to Angel ID? NOTE: You could setup
separate Corps and give them starting numbers that are reserved: Kroc Fulton 1 - 1000 / Kroc DeKalb 1001 -
2000... |
Future Enh |
3.5 |
$157.50 |
0 |
$0.00 |
|
10 |
| 55 |
Print Page #2 not working for FireFox v.1.06 (possibly CSS
overflow-x: auto in wrapper DIV) |
Future Enh |
1.0 |
$45.00 |
|
|
http://csscreator.com/node/23333 |
10 |
| 56 |
Need a way to assign Sponsors to Angels. Two new tables (Sponsor and Angel Sponsor) |
Future Enh |
1.0 |
$45.00 |
0 |
$0.00 |
|
11 |
| 57 |
Import/Export/Purge Sponsor. |
Future Enh |
1.5 |
$67.50 |
0 |
$0.00 |
|
11 |
| 58 |
Delete current Angels utility needs to clear Angel Sponsor
table. |
Future Enh |
0.5 |
$22.50 |
0 |
$0.00 |
|
11 |
| 59 |
Assign/Edit Sponsor to Angel screen. Shows all angels in one family. DropDown next to each angel or next to
family name to assign all. NEXT takes
you to the next (unassigned / all) record.
Open the screen runs through a process to append missing Angels. |
Future Enh |
5.0 |
$225.00 |
0 |
$0.00 |
|
11 |
| 60 |
Assign a range of angels families to a sponsor? |
Future Enh |
2.5 |
$112.50 |
0 |
$0.00 |
|
11 |
| 61 |
View Unassigned / All list.
Use HOH Last name in search.
Open Angel by ID option. |
Future Enh |
2.0 |
$90.00 |
0 |
$0.00 |
|
11 |
| 62 |
Purge Angel Sponsor table by Corps. |
Future Enh |
1.0 |
$45.00 |
0 |
$0.00 |
|
11 |
| 63 |
Export Sponsored Angels to Excel. Include Child Name and ID + wishes and
needs. |
Future Enh |
1.5 |
$67.50 |
0 |
$0.00 |
|
11 |
| 64 |
Clearing House options?
Import external spreadsheet from other agencies or one-at-a-time cross
check screen? |
Future Enh |
3.0 |
$135.00 |
0 |
$0.00 |
|
12 |
| 65 |
Add a way to Import 'Live' applications from external system
into AngelWeb? (Seniors DC from Phone
Bank) |
Future Enh |
3.0 |
$135.00 |
0 |
$0.00 |
|
13 |
| 66 |
Report: Angels Only (each name, dob, ID) Note:
Someone asked for this during the conference call -- I don't remember
what this was for. If you asked for this, let me have more details so I
can build this. |
Future Enh |
1.0 |
$45.00 |
|
|
|
13 |
| 67 |
Search by HOH for food only Applications. Note:
Contact me about this -- need more info. |
Future Enh |
1.0 |
$45.00 |
|
|
|
13 |
| |
Included in 2011 Maintenance Agreement (1 - 46) |
|
59.0 |
$2,880.00 |
|
|
|
z |
| |
Additional Enhancements
(Not funded yet) (47 - 67) |
|
54.5 |
$2,272.50 |
|
|
|
z |
| |
Total: |
|
113.5 |
$5,152.50 |
0 |
$0.00 |
|
zzz |
| |
Rate: $45.00 /hr. |
|
|
|
|
|
|
zzz |
| |
Angel Tree Maintenance Agreement for 2011 (includes 2 hr
telephone & setup assistance) |
|
|
$195.00 |
|
|
|
zzz |
|
|
|
|
|
|
|
|
|