1 / 59

Little Known/Used Features & New Stuff (did you know…)

Discover the often forgotten or overlooked tools and features of WinGAP that can make your work easier. Get important facts and tips for everyday use.

chadd
Download Presentation

Little Known/Used Features & New Stuff (did you know…)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2018 WinGAP Conference Gregg Reese– rgreese@wingap.net Little Known/Used Features & New Stuff (did you know…)

  2. Often forgotten or overlooked WinGAP Tools & Features • Some may make your WinGAP work easier • Little know important facts of our everyday lives Topics

  3. September 1 marked the 6-year anniversary of my retirement from DOR • Time flies so fast after youth is past that we cannot accomplish one half the many things we have in mind or indeed one half our duties. The only safe and sensible plan is to make others things give way to the essentials, and the first of these is fly fishing…..Theodore Gordon DID YOU KNOW THAT…

  4. In May, 2018, the final DBF county converted to SQL • Well past our Jan 1 deadline • Who was it? • I will not tell DID YOU KNOW THAT…

  5. How many of you know where you SQL Server versioning stands? • The most current version of Microsoft SQL Server is SQL Server 2017 • Is it imperative that you rush home and upgrade to this version? • No, not at all • WinGAP runs fine on versions from SQL Server 2008 up to and including SQL Server 2017 DID YOU KNOW THAT…

  6. Mfg Housing can now be searched using Title Number • Option was added to the Prebill MH Search Order list DID YOU KNOW THAT…

  7. What had you rather wake up to though, someone crunching an apple or the aroma of a fresh brewed cup of coffee? DID YOU KNOW THAT…

  8. Counts for parcels, personal property and MH’s are just a click or two away • Help >> About this application • Real Parcels (includes Exempt parcels) • Personal Accounts • Prebill MH’s • NonPrebill MH’s • Taxable Real • Exempt Real DID YOU KNOW THAT…

  9. Help >> About this application DID YOU KNOW THAT…

  10. “I do not want the picture of my place to show on your website!!” • Maybe they don’t want their ex to know they have accumulated a bunch of “toys”???? Ever heard a property owner state…

  11. “I do not want the picture of my place to show on your website!!” • Mask Photo Export is the answer • Checkbox below Documents button on Real Gen Info screen Ever heard a property owner state…

  12. When checked, Mask Photo Export will set a flag in realprop that the website vendor should acknowledge and not display photo • Realprop.maskphoto = 1 is the flag Ever heard a property owner state…

  13. You can create your own set of custom flags • For Real Property Only, at this time • Setup Custom Flag selections from • Tools >> Schedules/Tables >> Custom Flags • Enter info for the following items: • Code • Reason (description) • Property Type • Real Count • # of parcels with flag • Purge From All Properties • Removes flag DID YOU KNOW THAT…

  14. You can assign Custom Flags to parcels • Custom Flags button on Real Gen Info • Operates exactly like Asmt Reasons • Add as many Custom Flags as needed • Custom Flags are NOT cleared at YEC DID YOU KNOW THAT…

  15. You can assign Custom Flags to parcels DID YOU KNOW THAT…

  16. You can assign Custom Flags to parcels • Stored in CustomFlags table • Report can be created to generate list of parcels with specific Custom Flag • SSMS can be used to generate quick list to be copied to Excel • Select parcel_no,reason from customflags c inner join realprop r on c.realkey=r.realkey where reason = ‘bad dog’ order by parcel_no DID YOU KNOW THAT…

  17. Ratio Stats can be run from a parcel • Stats button present on Real Gen Info screen • Sits just below Custom Flags DID YOU KNOW THAT…

  18. Ratio Stats can be run from a parcel • Clicking Stats button opens Basic Selection Criteria Screen DID YOU KNOW THAT… Handy for generating a quick set of sales to justify value

  19. Most cats are not fans of a belly rub • Rolling on their backs is a defensive posture • Many dogs, however, really like it • Most of the time, rolling on their backs means scratch that tummy • Oh, it feels so good….. DID YOU KNOW THAT…

  20. A Growth Override can be applied • Growth button sits just above CustomFlags on Real Gen Info • Allows adjustment to Growth DID YOU KNOW THAT…

  21. A Growth Override can be applied • Real & Inflationary growth can be adjusted when extenuating circumstances are present • Override box must be checked to make it permanent for year • Realprop.growth = 1 indicates growth override DID YOU KNOW THAT…

  22. A COPL checkbox is on the MH screen • Provides a means of quickly identifying MH as having a Certificate of Permanent Location DID YOU KNOW THAT…

  23. A COPL checkbox is on the MH screen • Flag set in mobile.copl • List can be generated with the following SQL query statement • Select mobilekey,mobtype from mobile where copl = 1 DID YOU KNOW THAT…

  24. Valuation Schedules can now be accessed from the MH screen • User must have rights to schedules • Provides easy access and almost instant feedback on schedule changes DID YOU KNOW THAT…

  25. Valuation Schedules can be accessed from property screens • Clicking Schedule button opens schedules associated with MH • Changes can be made to schedule items • After exiting schedule, Apply must be clicked on property screen before value change is seen DID YOU KNOW THAT…

  26. Six years ago having a herd of goats was just a thought… a dream • Now we have 14 goats • It could easily be 1,000 • It is like having a herd of big rabbits DID YOU KNOW THAT…

  27. Pumpkin (The bottle fed goat)….

  28. Tri-Goats ….

  29. Sketched basement area info can be transferred to Res Imp screen • Prevents double data entry • Cuts down on errors • Provides options for valuing finished and unfinished basement areas DID YOU KNOW THAT…

  30. Sketched basement area info can be transferred to Res Imp screen • Sum Bsmt to Screen must be designated in Preferences • At bottom of Other Options list DID YOU KNOW THAT…

  31. Sketched basement area info can be transferred to Res Imp screen • Sketch label in the Res Imp Label schedule must be designated as a basement DID YOU KNOW THAT… Checking Basement Area box sets up schedule item

  32. Sketched basement area info can be transferred to Res Imp screen • Res Imp before sketching of basement DID YOU KNOW THAT…

  33. Sketched basement area info can be transferred to Res Imp screen • Sketched basement DID YOU KNOW THAT…

  34. Sketched basement area info can be transferred to Res Imp screen • After basement is sketched DID YOU KNOW THAT…

  35. Sketched basement area info can be transferred to Res Imp screen • Value before bsmt sketch: 208,593 • Value after bsmt sketch: 230,076 • Value difference: 21,483 DID YOU KNOW THAT…

  36. Sketched basement area info can be transferred to Res Imp screen • Value difference: 21,483 • Source of bsmt value: • Bsmt area: 11,200 • Bsmt sketch: 10,500 • Total: 21,700 • Depr: .99 • BsmtAdj: 21,483 DID YOU KNOW THAT…

  37. Sketched basement area info can be transferred to Res Imp screen • Note that value contribution is from the sketch and the area in Bsmt Area • Must be careful not to double dip • Bsmt Area could represent unfinished basement value • Sketched Bsmt might represent basement finish contribution • With the above, you would need a Fin Bsmt sketch label & UnfinBsmt label DID YOU KNOW THAT…

  38. Sketched basement area info can be transferred to Res Imp screen • Very careful attention must be paid to the schedules that impact basement values • Improvement Labels • Basement Coverage • Basement Finish • Appraiser must be aware of how the schedules interact with data to provide value DID YOU KNOW THAT…

  39. Georgia has the 2nd oldest city in the entire country • Saint Mary’s • What is the oldest city in the USA? • St Augustine DID YOU KNOW THAT…

  40. There are two ways to change schedules in Future • #1: From the Tools >> File Maintenance >> Future Folder Tasks menu, select Send Live Schedules to Future Folder • All schedules will be sent to future • Watch out for messages concerning schedule duplications • These are update killers DID YOU KNOW THAT…

  41. There are two ways to change schedules in Future • #2: Open Future and modify schedules as needed • How do I open Future? • On the WinGAP main screen with no other WinGAP screens open, press Ctrl + F • Or, select Future Year from Property Maint menu • Changes will NOT be sent to new year during YEC DID YOU KNOW THAT…

  42. When Strucfix must be done during updates, it can be run without touching the • Press F4 to start Strucfix • Press space bar on Make sure All Users are out… • Press space bar on Proceed to check all data files… • Press space bar on Completed full check – OK • Use directional arrow to move to next year • Press Enter to select year • Repeat steps from the top DID YOU KNOW THAT…

  43. You can check for files in your FTP county folder • Use the option Download from FTP on File menu • The FTP folder will open with the files listed DID YOU KNOW THAT…

  44. A sales-only future can be designated at start of Real & Personal YEC • Check the Sales Only Future box • This tells YEC that all work done in the future year was sales related DID YOU KNOW THAT…

  45. A sales-only future can be designated at start of Real & Personal YEC • Sales Related Work • Property Transfers • Ownership changes • Sales information • Splits • Parent parcel info will not be processed • New parcel will be passed to new year DID YOU KNOW THAT…

  46. You can vary the rate of $/SF change for homes above and below the Base Area • Provides a means by which you can zero in on value differences between larger and smaller residential improvements DID YOU KNOW THAT…

  47. You can vary the rate of $/SF change for homes above and below the Base Area • Increment Factor schedule item governs the rate of change above the Base Area • Increment Factor Low schedule item governs the rate of change below the Base Area • The higher the Increment Factor the higher the rate of change DID YOU KNOW THAT…

  48. You can vary the rate of $/SF change for homes above and below the Base Area • If median ratio on smaller homes is .3631, what might you do (select only one)? • Grade them higher • Depreciate them more slowly • Increase the Increment Factor Low • Decrease the Increment Factor Low DID YOU KNOW THAT…

  49. A wild search tool has been added to NADA • Open the MH screen • Click on NADA • Wild Search button on upper right DID YOU KNOW THAT…

  50. A wild search tool has been added to NADA • Clicking Wild Search button yields the screen on the following slide • Wild Search can be performed for only mfg or only model • Wild Search can be performed for combo of mfg and model • Search locates mfg and/or model with keyword embedded anywhere in text DID YOU KNOW THAT…

More Related