Tax Sale update - got this this morning

[Bruce]

got this update this a.m.....FYI

Bruce
YORGA

64 1500 14th Street SW
Calgary, Alberta Canada T3C 1C9
403)554-9994 br...@yorga.ca



---------------------------- Original Message ----------------------------
Subject: Tax Sale Updates
From: "Perdue Brandon Fielder Collins & Mott, LLP"
Date: Fri, October 18, 2013 6:38 am
To: br...@yorga.ca
--------------------------------------------------------------------------

TAX SALE UPDATES For November 5, 2013 The November 5th sale information has been added to our website for the following counties:     ANDERSON AUSTIN BAYLOR BRAZORIA CARSON DALLAS ELLIS FORT BEND GALVESTON HALL HARRIS PCT 2 HARRIS PCT 3 HARRIS PCT 4 HARRIS PCT 4 (RESALE) HARRIS PCT 5 HARRIS PCT 5 (RESALE) HARRIS PCT 8 HIDALGO HILL JOHNSON MITCHELL MONTGOMERY PCT 1 MONTGOMERY PCT 2 POTTER SMITH TARRANT TRINITY WICHITA WILBARGER     Quick Links PBFCM Tax Sale FAQ PBFCM Tax Resales PBFCM Locations PBFCM Services Amarillo  *  Arlington  *  Austin  *  Conroe  *  Houston Lubbock  *  McAllen  *  Midland  *  San Antonio  *  Tyler  *  Wichita Falls Visit us at www.pbfcm.com

Forward email This email was sent to br...@yorga.ca by taxs...@pbfcm.com |   Update Profile/Email Address | Instant removal with SafeUnsubscribe™ | Privacy Policy. Perdue Brandon Fielder Collins & Mott LLP | 1616 S. Kentucky | Amarillo | TX | 79105

 

[Andrew Ardianto]

Thanks Bruce.

I have also update the Excel Macro (tax2.xlsm)

Now all these selection is available:

Sale Type:

County:

Precinct Number:

Account Number:

Adjudged Value From:

Adjudged Value To:

Minimum Bid From:

Minimum Bid To:

Show image: (yes/no)*

*the image is not sort-able on excel so you may want to choose "no" to be able to sort the result.

Enjoy!

Do let me know if there is any question/trouble. I have 3 days window to ask the programmer for any changes. After that, I have to pay more.

Andrew Ardianto

cell: 403-200-4593

 

--
You received this message because you are subscribed to the Google Groups "TedThomasCalgary" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tedthomascalga...@googlegroups.com.
To post to this group, send an email to tedthoma...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Bruce]

Andrew,

took a quick look at this on the excel sheet, adjusted columns to read address and legal discription etc but what column are you looking at trying to sort? as the zip codes can't be sorted (they have address attached they would have to be in a column by themselves), the rest of the columns don't help me in making my descisions quicker.....maybe  I am missing something, we can talk on weekend over phone if needed.

I may need to spend maybe.

thanks though.

Bruce

YORGA

64 1500 14th Street SW
Calgary, Alberta Canada T3C 1C9
403)554-9994 br...@yorga.ca


---------------------------- Original Message ----------------------------

Subject: Re: Tax Sale update - got this this morning
From: "Andrew Ardianto"
Date: Fri, October 18, 2013 8:51 am
To: "tedthoma...@googlegroups.com"
--------------------------------------------------------------------------

[Andrew Ardianto]

Hi thanks for quick look, Bruce.

Well, the excel format was just parsing the information taken from www.publicans.com.

If the address in publicans.com is one lump, then excel will put it onto one lump (one cell).

You can use formula: =RIGHT(J2,5)

where J2 is the cell contain of full address, and the "5" is the number of character from the right. This will extract exactly 5 character from the right, which is the zipcode.

Here I attach the sample.

Look for column O on the "result" worksheet.

Other useful sorting in excel is if you add one column, and put formula, say: percentage of minimum bid off value, then you could sort based on this, and discard any property that is beyond 30% for example.

Andrew Ardianto

cell: 403-200-4593