the puzzle">Working 2009 file (formerly working 2008) had BOE activated on 5/6/08, Then the Form 11 was ran on 5/19/08 which has 945 rural comm assessed. On 5/30/08 then maintained certified copying all the parcels to the a new database. 

Working 2008_Certified (new database) On 8/19/08 the Form 11 shows 948 rural comm assessed and the Form 11A shows 947 rural comm assessed. A difference of one which is mind boggling initself since the reports were ran 5 minutes apart. (will need to talk to programmer who designed the report on that one) Regardless if it is 947 or 948, the issue is 2 or 3 parcels with a value difference of 40,256.

The query used to run the reports exluded PDFs 114,198,200,202,204, excluded maparea 75, excluded Taxdistrict 13 set to 0. So first thoughts were one of those previously excluded are now being included. Seemed logical until I ran some comparsion. 

Compaing the 2007 certified *test* to the Working 2008_Certified. 
I found 8 parcels with tax district set to 0 on 2007 that were not the same on 2008. 7 of those were delted in 08 and the other one was Commercial but 610,000 original value. 
I found 7 parcels with map areas set to 75 on 2007 that were not the same on 2008. All 7 of those were deleted for 2008.
I found 3 parcels in the excluded PDF in 2007 that were not in the excluded PDF for 2008. One of those was deleted. The other 2 were commercial one urban, one rural but their values were like 59,000 and 210,000 for beginning balances.

So that shot the first set of theories.
So all I really know is 1. it is rural commercial. 2. It is 2-3 parcels summing up to 40,256 original starting balance. 3. They got added to the counts sometime between 5/19 and 8/19.

After this I went on a wild goose chase looking for 3 parcels that added up to 40,256 in various queries based on edit dates and values. And I still found nothing. 

So my next step that I will try tomorrow is the backwards approach and I will need the help of my favorite programmer in the world and his select SQL stmts :-)

From the Form 11 on May 19th to the Form 11a on Aug 19, there was 136 parcel difference. All of those parcels should have a Zero original balance because they are new for 2008.  I need to run a SQL stmt that will find all parcels with an original value of Zero. If that total does not match 136, I will have a new area to explore.  I will need to find the ones that are new but don't have a zero original balance and just maybe this will lead me to a combined value of 40,256.

I'll owe the programer lunch for all his help.