For anyone not sure if Easy Data Transform is a powerful tool, here’s an example.
I protest absurd property tax appraisal. I also tilt at windmills, spit into the wind, peek under that old Lone Ranger’s mask, and if Superman got annoying, I’d tug on his cape.
But not without Easy Data Transform.
Getting appraisal data from our local tax district is like pulling teeth. Other tax districts politely post appraisal database dumps whether anyone asks or not.
This time it appeared I needed to let those folks know that inscrutable dump files are quite transparent with the right tools. I needed to show proof I could make sense out of data.
A nearby county posts their appraisal data. It was about 51,000 lines of text, each line about 9,500 characters in length. An accompanying spreadsheet listed the field lengths, one row in the spreadsheet per field in the database.
I added spreadsheet columns for start and ending positions, computed from the field lengths. There were about 500 fields of which I really only wanted about 30.
A checkbox column in the spreadsheet let me select the fields I wanted. A couple more columns computed start and end positions, either for an individual data field that I wanted to see, or an aggregate block of multiple consecutive fields I wanted to ignore.
Launch plus probably five minutes at this point.
Fixed lengths were copied into EDT’s fixed length specifiers from the 30 fields I wanted and about 20 “ignore me” spans.
Launch plus ten minutes (got a phone call).
Drop the fields not needed with EDT’s remove columns transform, rotate the spreadsheet to make one column per field, and the stack transform added column headers to the fixed length data.
Launch plus 30 minutes and now I know “real” property appraisals in Wise County went up an average of 54.33%, at minimum dropped 93.73%, and at maximum went up a whopping 20,747.50% (probably due to new construction on a previously vacant lot).
So, why did that take 30 minutes? I did a couple of what-if scenarios along the way.
There are times when I figure I get the full value out of EDT’s license cost on a single run. Please don’t quote me on that, I like how affordable EDT is.
But it’s really worth the money. It is amazing for pulling truth out of data. Or log files, that’s a cool trick, too.