Friday, September 9, 2011

19_FileMaker Web Viewer Virtual Tour

FileMaker Pro allows you to get real-time information from the web associated with your data, without having to open a browser.  View maps to the address of your contacts, track package deliveries for your customers, display research data, track stock performance and store the results in a user friendly way that allows you to access and use the results in seconds.

Double click on the image to get a closer look.



Virtual tour of a FileMaker Pro database solution created in version 11 utilizing the Web Viewer in a semi-automated data scraping tool (Craigslist is only an example) by Erika Kidd, Klozpin FileMaker Development.


Want to know more?  Watch this short video: http://www.filemaker.com/eight_five/learning/pop_movie.html?src=T01_v1.mov

18_Residential Kitchen Redesign


The Kitchen

Before - from the Carport Door

After

Before - from the bedroom hallway

 After

Planned the new design and coordinated the talent to complete it in this 1960's brick ranch.  Removed the wall between two rooms, feathered into the existing hardwood floors, widened the door to the dining room, added skylights, a dozen recessed can lights + 3 pendants (not yet up in this photo).  Replaced all cabinetry with new IKEA products and appliances.  Added the island with bar, granite counters and glass tile backsplash. Ran crown moulding, chose colors and painted.

Estimated equity increase - double the renovation costs for labor and materials.



Sunday, June 5, 2011

17_Water Pressure Reducing Valves


Water Pressure Reducing Valves

Ensuring Practical, Safe Working Water Pressures Municipal and private water supply companies use pumps and pumping stations to boost water supply pressures in supply mains to be able to supply water for fire fighting, high rise buildings to overcome loss of pressure as the elevation increases, and to maintain water supply in water towers and supply tanks. Pressure in water supply mains can exceed 200psi. Most plumbing codes require water pressure reducing valves on domestic systems where the municipal water main's pressure exceeds 80psi. Higher pressures could rupture pipes, damage fixtures,and injure the people using them.







How Does a Pressure Reducing Valve Work?

Installed directly after the water meter in homes, commercial buildings, and manufacturing plants, a water pressure reducing valve automatically reduces the pressure from the water supply main to a lower, more sensible pressure.
Water entering the valve from municipal mains is constricted within the valve body and directed through the inner chamber controlled by an adjustable spring loaded diaphragm and disc. Even if the supply water pressure fluctuates, the pressure reducing valve ensures a constant flow of water at a functional pressure, as long as the supply pressure does not drop below the valve's pre-set pressure.

Sizing a Water Pressure Reducing Valve for Your Application

A properly sized valve prevents noisy operation ("water hammer" banging or whining pipes) or premature valve failure. 

Choosing the Correct Installation Configuration

Water pressure reducing valves can increase your water system's performance, reduce operating costs, and ensure a longer life for other plumbing fixtures. Most simple pressure reducing applications require the installation of a single regulator. 

Testing Water Pressure

Gauges like this one are available from your favorite home improvement center for less than $10 (0-120psi).  Be sure no water is being used in the house while you are testing - to get an accurate STATIC pressure reading. Attach the gauge, turn on the faucet, take the reading, turn off the faucet and disconnect the gauge.  You can also call your water supplier and ask them what it should be in your area.  The ideal pressure for inside fixtures is around 50 psi.  The PRV can be adjusted with the bolt to output different amounts of pressure.  Reduce the pressure to save water and extend the useful life of fixtures.






How much does a typical family of four use?

A typical family of four uses an average of 255 gallons of water each day for interior plumbing. This is broken down by:


  • dishwashing -        15 gallons;
  • cooking/drinking -  12 gallons;
  • utility sink -             5 gallons;
  • laundry -               35 gallons;
  • bathing -               80 gallons;
  • bathroom sink -       8 gallons;
  • toilet -                 100 gallons.


When you multiply this by a year, typical family usage totals 93,000 gallons of water. Your family particularly if it includes teenagers, would undoubtedly use more than the above averages.

How long will a Regulator last?

Regulators have been described as "life-of-mortgage" products, because historically a malfunctioning pressure regulator is not replaced but simply cleaned or repaired via an inexpensive service kit. Design wise, it is similar to the kitchen faucet in that dirt or foreign matter on the seating area can cause problems and actually it is no more difficult to repair a regulator than it is to fix the kitchen faucet.






Over time, some valves can wear out and if replacement is required expect approximately $50 + labor.  I suggest buying from a plumbing supply specialty store, as there are many models available.  






Want to read more: http://www.irrigationtutorials.com/sprinkler03.htm
___________________


Clarifying Note: Pressure Relief Valves (PRV) also exist as a safety feature for hot water tanks, and are NOT what is being discussed in this article.




___________________
Addition: 




Fluidmaster S2DBL Dual FlushToilet Conversion Kit

Between $30-40

"FLUIDMASTER" COMPLETE WATER SAVING DUAL FLUSH CONVERSION KIT 
*Converts your existing toilet to dual flush.
* Uses up to 45% less water.
* Fully adjustable for a wide range of applications.
* Adjustable Dual Float System delivers precise and powerful flushing action.
* Complete system includes: flush and fill valves and all installation accessories.
* Water Level Adjusting screw for best flush
* Durable Silicon seal for year of dependable flushes
* Has a Full and Half  flush for water savings you can see.
Turn the average 100 gallons per day of water usage at the toilet (for a family of four) into 50!
Available at: Lowe's, Home Depot, Ace Hardware and online.

Monday, February 14, 2011

15_FREE and Functional Computer Services













Who can't use 2GB of FREE storage space?
 -I use it to transfer large database files 
and offsite backup.
www.dropbox.com



Remote desktop support
and file transfer 
www.TeamViewer.com













Secure Payments 
www.PayPal.com

14_Affordable Door Transformations

Consider this example:
6' wide x 8' high
Total cost $3,000



Materials cost: New vinyl door from Home Depot $1,000
Door installation and lockset.  Glass panel inserts $500 each.
____________________________________________________
For Comparison, these doors cost: $4,500
Solid Wood Entry Door

13_Replace Window Sash and Save



How to Install Replacement Windows
Ready to replace your drafty old windows with new energy-efficient units? We'll show you the two easiest ways to pull out old windows and put new ones in — and you don't have to tear off the interior moldings or disturb exterior trim and siding to do it.
By the DIY experts of The Family Handyman Magazine:March 2003

Double-hung replacement windows

In this article, we'll show you step by step how to remove the old sash from double-hung windows and mount either a new sash kit or a wood or vinyl replacement insert inside your existing window jamb. Even a beginner can do it.
Both the sash replacement kit and the wood or vinyl replacement insert mount inside your existing window jamb, in the place that was occupied by the old sash. They both fit in the space between the outside stop, called the blind stop, and the removable interior stop (see Fig. A). The sash replacement kit is designed to replace the sash in double-hung windows only. Wood or vinyl replacement inserts, on the other hand, are self-contained units with their own jamb and sash, and can therefore be slid into almost any type of window jamb. They are available as double-hung, sliding or casement-style windows.
Either type of replacement window must be installed in a solid, rot-free jamb. Inspect your old window frame carefully for signs of water damage. Pay particular attention to the sill. Probe with a screwdriver to uncover hidden soft spots. Normal exposure to rain and snow often causes the exposed parts of poorly maintained windowsills or the lower sections of the exterior trim to rot. An experienced carpenter can usually repair these areas with sections of new wood or you can use an epoxy repair system. Rot along the top or interior parts of windows, including the window jamb, is more difficult to repair and often signals a bigger problem. Don't mess with repairs. Plan on tearing out the entire window and installing a new one.

Measure carefully

Measure very carefully before you place an order, no matter what type you install. There's nothing worse than discovering that your nonreturnable, custom-sized window doesn't fit. Measure the width between the side jambs at the top, middle and bottom and record the smallest measurement. Measure all the way to the jamb, not the blind stop or parting stop (see Fig. A). Now measure the height from the top jamb to the sill (see Fig. A). Measure both sides and the middle and record the smallest measurement. Finally, determine the sill angle (Photo 1) and specify this when you order a sash replacement kit to make sure the jamb liners fit tight to the sill. This step isn't necessary for ordering wood or vinyl replacement inserts. Keep a record of all correspondence with your window supplier and ask for a written confirmation before the windows are ordered so you can double-check the sizes.
If your house was built before about 1940, you'll likely have double-hung windows with sash weights and cords like the ones shown in this article. Newer double-hungs may have springs or jamb liners instead, but once these are removed, the installation process is the same.
Parts of a double-hung window
Parts of a double-hung window
Figure A: Window parts
It helps to understand the part of the window.

Replacement inserts or sash replacement kits?

« Previous Photo

Option 1: Wood or vinyl replacement inserts
For a maintenance-free window that doesn't require any painting or staining, consider vinyl replacement windows. Some companies even make a simulated wood grain interior. Since wood or vinyl replacement inserts have their own jamb, they can be installed in window jambs that are slightly out of square. Ask your window dealer for help measuring, though, since you'll have to downsize the window slightly to fit.
Shopping for replacement windows is a little trickier than buying sash kits because the quality of the windows varies dramatically and many are available only to contractors. Make sure to inspect and operate an actual working model of the window before you order. Look closely at details like the locking system, weatherstripping, and sash and frame joints. Then consider the overall appearance. Some windows, like ours, have narrow vinyl sash parts that allow more light and a better view than windows with wide sash frames.
Option 2: Double-hung sash replacement kits
If you want to retain the authentic wood look of your old double-hung windows, sash replacement kits are the best option. You can order the sashes with grilles to match the rest of the windows in your house and paint or stain the wood. (You can choose grilles that either snap in or are glued to the glass.) But your old window jamb must be square and rot-free. Measure diagonally. If the diagonal measurements differ by more than 1/2 in., the new sash won't seal properly and you should replace the window or use a vinyl replacement window instead.
Double-hung sash replacement kits consist of two new wood window sashes, two vinyl jamb liners and installation hardware. Features like energy-efficient low-E glass, simulated divided lites and maintenance-free exterior cladding are available for an extra cost. Contact the manufacturer for more information about options and to find out where to order windows in your area.

Installing wood or vinyl replacement inserts

« Previous Photo

Start your replacement insert installation by removing the interior stop, sash and parting stop. The parting stop is usually caked with paint and difficult to remove. Use a pliers (Photo 3) to break out the lower section. If the upper sash is stuck, pry or break out the upper section of parting stop with a chisel. If your windows have spring balances or metal jamb liners rather than sash weights like ours, start by removing the interior stops (Photo 1). Then look for the screws or nails that secure the sash hardware and remove them. The goal is to remove all hardware back to the blind stops (Photo 2). You don't have to worry about dinging up the jamb and sill because they’ll be covered. If your window has a sash weight cavity, stuff it with insulation.
Make sure your window insert is square
Your wood or vinyl replacement insert will be slightly smaller than the window jamb opening to allow for shimming. The key to a window that operates smoothly and seals properly is getting the frame perfectly square and the sides straight. Photos 4 — 6 show how. Don't be afraid to remove the screws and readjust the window in the opening if necessary. In addition to checking the window by measuring the diagonals (Photo 5), open and close the sashes to make sure the tops and bottoms are parallel with the sill and top jamb and that the top and bottom sashes are parallel to each other where they meet in the middle. Keep tweaking the shims until everything is square and lined up. Then snug but don't overtighten the screws. Complete the installation by reinstalling the interior stops (Photo 7) and sealing up the exterior (Photos 8 and 9). You can also install wood or vinyl replacement inserts in casement and sliding window jambs. We won't talk about them in detail here. Be sure to read the installation instructions that come with each window.
CAUTION!
Houses built before 1978 may contain lead paint. Before disturbing any surface, get a lab analysis of paint chips from it. Contact your public health department for information on how to collect samples and where to send them. Do-it-yourself lead testing kits are also available at home centers and hardware stores.

Installing double-hung sash kits

« Previous Photo

The toughest part of sash replacement is tearing out the old window. You have to pry off the stop (carefully for reuse) and the parting stop (which you can discard; see Photo 3). You can either nail or screw the new liner clips in place (Photo 4). We chose screws because driving nails can be difficult in old window jambs. Be sure to leave a 1/16-in. space between the clip and the blind stop or the jamb liner won't snap in (Photo 5). Then replace the interior stops and top parting stop (Photo 6). Read the instructions included with your window for the exact procedure to use for lowering the sash lifts (Photo 7) and tilting the sash into place. If you have trouble pushing in the sash after you tilt it up, try working with one side at a time.
Compress the jamb liner with one hand while you ease one top corner of the sash in with the other. Then repeat the process on the other side. Also position the top of the sash toward the center of the opening.


Cost $100-$500 per window depending on the features you select.
Source:
http://www.familyhandyman.com/DIY-Projects/Doors---Windows/Window-Replacement/how-to-install-replacement-windows/Step-By-Step


Local Atlanta supplier:
http://www.stockbuildingsupply.com/doorswindowsstairs