text:
Since the mid-1970s the Parties to the 1954 Supreme Court Decree, working in conjunction with the Delaware River Basin Commission (DRBC), have enacted a series of programs aimed at improving ecological conditions below the New York City Delaware Basin reservoirs. These programs have been adopted with the unanimous agreement of the Decree Parties-the States of Delaware, New Jersey, New York, and Pennsylvania, and the City of New York-and the Commission, consisting of the four states and the federal government. The primary goal of the programs for many years was to improve cold-water fishery conditions in the upper basin, while recognizing the diversions to New York City (NYC) and New Jersey authorized by the Decree, the maintenance of lower basin minimum flows required by the Decree and the constraints imposed by limited reservoir storage, particularly during drought. Although enhancement and protection of the cold-water fishery remains a key focus, in recent years, the Decree Parties have expanded the program goals to include protection of federally-listed endangered species, the dwarf wedgemussel, and improved understanding and protection of ecological flow requirements in the main stem Delaware River, including the Estuary and Bay. The following provides background and a summary of the programs.
Geographic Setting
The Catskill Mountain region of the upper Delaware River Basin is approximately 100 miles from the NYC metropolitan area. The Catskill drainage provides a high quality source of water, and NYC obtains nearly half of its municipal water supply from its three Delaware Basin reservoirs--Cannonsville, Pepacton, and Neversink. The headwaters of the Delaware River drain to New York State, Pennsylvania, New Jersey, and Delaware. Within the basin, the river supplies drinking water to much of the Philadelphia metropolitan area and major portions of New Jersey. In addition, water is diverted from the basin to both NYC and NJ. For the river's entire length, from its headwaters in New York to the Delaware Estuary and Bay, the Delaware also serves as an ecological and recreational resource. Over the past half century, as a result of the maintenance of lower basin minimum flows, cold-water fisheries have been established in the tailwaters of the East Branch Delaware, West Branch Delaware, and Neversink rivers and the upper main stem Delaware River, and most of the main stem upstream of Trenton, NJ has been designated by Congress as part of the federal Wild and Scenic Rivers system.
Supreme Court Decree
On May 4, 1931, the U. S. Supreme Court issued a decree authorizing NYC to divert an average of up to 440 million gallons of water per day (mgd) from two reservoirs it proposed to construct in the Delaware River Basin (the basin) for its water supply system in the Hudson River Basin (Ref. 1). This decree temporarily settled the case of the State of New Jersey v. the State of New York and New York City, 283 U.S. 336 (1931), and resolved an interstate dispute over NYC's diversion of water from the basin. The Decree required that NYC release sufficient water from its Delaware Basin reservoirs to maintain specified flow targets in the Delaware River at both Port Jervis, NY and Trenton, NJ.
The 1931 decree was amended and superseded by the Supreme Court on June 7, 1954 in New Jersey v. New York, 347 U.S. 995 (1954) (Ref. 2) when NYC proposed to construct a third reservoir. The amended Decree increased NYC's allowable diversion to an average of 800 mgd from all three Delaware Basin reservoirs, on condition that NYC release sufficient water from the reservoirs to maintain a minimum basic flow rate of 1,750 cubic feet per second (cfs) in the Delaware River at Montague, NJ. In addition, the 1954 amended Decree authorized New Jersey to continue its existing diversion of up to an average of 100 mgd from the basin without providing compensating releases.
Delaware River Master
The Decree established the Chief Hydraulic Engineer of the U.S. Geological Survey (USGS), or that official's designee, as the Delaware River Master (River Master) (Ref. 2). The River Master's duties include ensuring that the provisions of the 1954 Decree are met (Ref. 3). The daily operations of the River Master are conducted by the Deputy River Master through a USGS field office in Milford, PA. The annual River Master report to the Supreme Court provides a detailed daily accounting of all diversions, flows and directed releases, demonstrating compliance with the Decree requirements (Ref. 4). The 1954 Decree specifies that the River Master is to conserve the basin's waters in carrying out the duties for administration of the Decree. The River Master's performance of these duties has included communicating with upstream hydropower generators to determine their release schedules in addition to coordinating with NYC. It has also included technical assistance to and coordination with the Delaware River Basin Commission (DRBC) in its reservoir operations activities and with the River Master's Advisory Committee, whose membership is comprised of the parties to the 1954 Decree (Decree Parties).
Roles of the DRBC and the Parties to the Supreme Court Decree
The DRBC, a federal-interstate compact agency established in 1961, consists of the governors of each of the four basin states and a federal representative appointed by the president (Ref. 5). The Decree Party representatives are the governors of the four basin states and the mayor of NYC.
The compact establishing the DRBC provided the Commission with the authority, in accordance with the doctrine of equitable apportionment, to allocate the waters of the basin to and among the States that are signatory to the DRBC compact and to and among their political subdivisions, and to impose conditions, obligations and release requirements related thereto, all subject to certain conditions and limitations. A key limitation is that the Commission may not, without the unanimous consent of the parties to the 1954 amended Supreme Court decreea, diminish or otherwise adversely affect the diversions, compensating releases, rights, conditions, obligations and provisions for the administration thereof contained in the decree (Ref. 5).
With the benefit of experience and time, the Commission has identified areas where a departure from strict application of the terms of the decree can assist in the conservation of the basin's waters and resources. The Commission has worked successfully with the Decree Parties to secure their unanimous consent to a series of understandings aimed at protecting public health and welfare during times of drought and enhancing the basin's fisheries. The most significant of these understandings are a set of consensus recommendations contained in the Decree Parties' "Good Faith Recommendations" for interstate water management of 1982 (Ref. 6). The most important of these were enacted by the Commission in Resolutions Nos. 83-13, 84-7, and 88-22 (Revised) and were codified at Sections 2.5.3 through 2.5.6 of the DRBC Water Code, generally known as the "reservoir drought operating plans" (Ref. 7). The measures incorporated in these resolutions were prompted by a record drought in the 1960s and were made to conserve storage and ensure flow augmentation during a repetition of such conditions. The drought operating plans, which consist of phased reductions in diversions and releases based upon reservoir storage curves, have been invoked numerous times since their adoption in the early 1980s.
In addition to the drought operating plans resulting from the Good Faith process, further understandings have been reached through DRBC Docket D-77-20 CP and amendments thereto (Ref. 8) with respect to fishery management below the three NYC Delaware Basin reservoirs. As was the case with the DRBC drought management plans, these understandings have been adopted and amended by unanimous consent of the Decree Parties and the Commission.
Development of Release Program for the New York City Delaware Basin Reservoirs Based on Docket D-77-20 CP and its Revisions
The efforts of fisheries biologists and water resources program managers of the New York State Department of Environmental Conservation (NYSDEC), combined with negotiations among the Decree Parties, and DRBC docket approvals, have resulted in a series of programs embodied in Docket D-77-20 CP and Revisions 1 through 8 thereto, aimed at improving cold water fisheries below the three NYC Delaware Basin reservoirs. These programs have included minimum conservation releases, storage banks, and most recently, tail water flow targets downstream of the three reservoirs. A chronology of the various release programs is presented here.
Basic Conservation Releases
The Supreme Court Decrees of 1931 and 1954 contained no provisions for minimum conservation releases. The original conservation release schedules for Neversink and Pepacton Reservoirs were established via an informal agreement between the NYC Board of Water Supply and the New York State Conservation Department. The state permit to build Cannonsville Reservoir was conditioned on establishing a basic conservation release schedule for that facility. Subsequently, these conservation release schedules were established as a result of the settlement of claims of riparian landowners brought in the New York State Supreme Court. The basic conservation releases for all three reservoirs are shown in Table 1, Column 1.
1977 Experimental Program
New York State, with the agreement of NYC, proposed a two-year experimental program in 1977 based on NYSDEC Part 671 reservoir releases regulations for Cannonsville, Pepacton, and Neversink Reservoirs pursuant to Title 8 of Article 15 of the Environmental Conservation Law. The program provided for augmented conservation releases for the purpose of enhancing the downstream fishery below each of the three NYC dams. To offset the additional demand created by these augmented conservation releases, the Decree Parties unanimously agreed to suspend release of the "Excess Release Quantity" (ERQ) defined Sections III.B.1(c) and (d) of the Decree and use this volume of water to create an "Excess Release Bank" to support the augmented conservation release program. This proposal resulted in approval by DRBC of Docket D-77-20 CP on May 25, 1977. Since then, conservation releases made under the 1977 Experimental Program and all those made under subsequent fisheries releases programs have been and continue to be directed by New York State, which provides an annual accounting of the use of banked storage for review by NYC and the River Master.
DRBC Docket D-77-20 CP
DRBC Docket D-77-20 CP established a new schedule of augmented conservation releases for the three NYC Delaware Basin reservoirs. The augmented releases in this experimental program initially ranged from 25 cfs to 70 cfs, with a two-month summer release rate of 325 cfs from Cannonsville. The large rate of release from Cannonsville was a function of limitations on ability to control incremental releases from the Cannonsville outlet works. The release schedule established by D-77-20 CP was extended by a series of eight DRBC resolutions through May 31, 1983.
In addition to establishing the augmented conservation releases, Docket D-77-20 CP set up a program of special releases from the reservoirs to relieve thermal stress conditions that posed a threat to tailwater fisheries. A thermal stress "bank" provided for coldwater releases from the bottom layer of reservoir storage to control increases of stream temperature during hot weather. The total volume of the thermal bank, which became available on June 1 of each year, was approximately 3.9 billion gallons (bg), or 6,000 cfs-days. Releases could be made from the thermal bank when the water temperature at designated locations downstream of the reservoirs was expected to rise above 75° F as an instantaneous measurement or 72° F as a daily average. Any remainder in the thermal bank was automatically nullified after October 31 of each year.
The original Docket D-77-20 CP provided that the combined total of the augmented releases and thermal releases could not exceed the total quantity of water in the excess release bank. This requirement, however, was eliminated in 1983 in the first revision of the docket.
Docket D-77-20 CP also called for the formation of a task group, to include representatives of the five Decree Parties. The group was asked, among other things, to prepare criteria for defining the onset and stages of drought or water shortage emergencies. Such criteria were to include consideration of reservoir storage levels, stream flow, ground water conditions, and meteorological conditions. The responsibilities of the task group also included preparing an emergency diversion, water allocation and release plan for implementation by the Commission at various defined drought stages. The task group was the forerunner of DRBC's Flow Management Technical Advisory Committee (FMTAC), created in 1983, and its successor, the Regulated Flows Advisory Committee (RFAC), established in 2005.
DRBC Docket D-77-20 CP has been revised since 1977 through a series of Docket amendments and/or DRBC Resolutions. DRBC dockets represent commission approvals of projects that are subject to review under Section 3.8 of the DRBC Compact. Resolutions are commission actions related to DRBC regulations, DRBC administrative activities, and are also used to extend or modify existing projects approved by docket under Section 3.8 of the Compact. Whenever Docket D-77-20 CP has been revised by a DRBC resolution, a docket revision number has also been assigned to reflect the change.
DRBC Docket D-77-20 CP - Revised
Following public hearings held in the early 1980s, the experimental augmented release schedule established in the original 1977 docket became permanent when the DRBC approved the first revision to Docket D-77-20 CP on November 30, 1983. The release schedule is shown in Table 1, Column 2.
Based on findings of the task group created by the original docket, the revised 1983 docket linked the augmented conservation releases to a basin-wide drought operating plan. This plan established criteria for drought warning and drought emergency based on the combined storage of the three NYC Delaware Basin reservoirs. It also established that the augmented releases would be reduced to the basic conservation releases when the basin was determined to be in a drought warning or emergency. This had the effect of reducing the number of drought operating days caused by the augmented releases. The conservation releases would return to the augmented levels following a drought when the combined storage reached 25 billion gallons (bg) above the drought warning level and remained above that level for 15 consecutive days.
This first revision to Docket D-77-20 CP was the last modification of the fishery releases program to be approved without a requirement for reconsideration or an expiration date.
DRBC Docket D-77-20 CP (Revision 2)
The DRBC approved a temporary revision of Docket D-77-20 CP (Revised) on June 23, 1993 to provide for new summer augmented releases from Pepacton and Neversink Reservoirs on an experimental basis through May of 1996. The revised release rates for the two reservoirs are shown in Table 1, Column 3.
This action was based on the experience gained after the augmented rates were made permanent in 1983. Docket D-77-20 CP (Revision 2), however, did not call for a change to the annual total quantity of releases from the reservoirs.
The release rates at Cannonsville Reservoir were not revised, because a new conservation release valve had not yet been installed. The second revision noted that the installation of the valve, scheduled for completion by the end of 1994, would provide for better control of releases for fisheries management.
DRBC Docket D-77-20 CP (Revision 3)
In the third revision of the docket, approved on a temporary basis by the DRBC on February 26, 1997, the augmented release rates for Cannonsville Reservoir were adjusted based on the improved capability of the new conservation release valve. The maximum conservation release from Cannonsville Reservoir was reduced from 325 to 160 cfs, but was extended from June 1 through September 15. The rate was decreased to 45 cfs on September 16. These revised rates are shown in Table 1, Column 3. Docket D-77-20 CP (Revision 3) also provided an additional 2.07 bg, or 3,200 cfs-days, for thermal stress reduction and continued the experimental augmented release program for another three years, through May of 2000.
DRBC Docket D-77-20 CP (Revision 4)
Revision 4 was approved by the DRBC on April 28, 1999. It extended the release schedule for Cannonsville Reservoir that was included in Revision 3. It also implemented a temporary, two-year modification to the basin-wide drought operating plan, allowing, among other things, a portion of the Excess Release Quantity as defined in the Decree, to be used directly for enhancing the fisheries in the tailwaters below the reservoirs. A drought watch stage temporarily replaced the upper portion of the drought warning stage on the DRBC storage-based rule curve codified at Section 2.5.3 of the Water Code (See Figure 1). The drought watch stage provided for the same Trenton and Montague flow targets and NYC diversion as did the upper half of the drought warning stage in the codified drought operating plan. However, the 100-mgd diversion to northern New Jersey was not required to be reduced during drought watch. Conservation releases from the NYC reservoirs during a drought watch were decreased to 85 percent of the augmented experimental level, and the remaining thermal stress bank was decreased by 15 percent.
Revision 4 provided that, for the duration of the revision, one-half of the ERQ (approximately 5,700 cfs-days in a non-leap year) would be held and placed in a "fishery protection bank" and made available to augment releases during drought warning (the lower portion of the prior drought warning stage on the DRBC storage-based rule curve). The remaining half of the ERQ would continue to be available to benefit downbasin users or could be banked in accordance with a lower basin drought management plan. This revision extended the augmented experimental release program by two more years, through April 2001; DRBC Resolution No. 2001-5 subsequently extended Revision 4 for an additional year, through April 30, 2002.
DRBC Docket D-77-20 CP (Revision 5)
Revision 5, approved on April 3, 2002 by DRBC Resolution No. 2002-6, extended through April 30, 2003 the experimental program established by Revision 4. Revision 5 established a temporary habitat bank for support of experimental flow targets on the West Branch of the Delaware River at Hale Eddy, NY and modified the minimum releases from Cannonsville Reservoir. The source of the temporary habitat bank (5,700 cfs-days) was the half of the ERQ that had already been temporarily devoted to the fisheries under Revision 4. The remaining half of the down-basin states' ERQ continued to be available to benefit downbasin users or could be banked in accordance with a lower basin drought management plan.
DRBC Docket D-77-20 CP (Revision 5) (Amended)
Revision 5 (Amended), approved on July 17, 2002 by DRBC Resolution No. 2002-21, clarifies and extends certain provisions in Revision 5. It defined explicitly the total quantity of water in the thermal releases bank (9,200 cfs-days) and extended its use from October 31, 2002 to April 30, 2003. In addition, allowance was made (with the concurrence of New York City) to use the Habitat Bank for augmenting flows at specified locations on the tributaries below the three NYC reservoirs. It also allowed for the Habitat Bank to be used to augment conservation releases to the summer baseline release levels, during drought warning conditions.
DRBC Docket D-77-20 CP (Revision 6)
Revision 6, approved on March 19, 2003 by DRBC Resolution No. 2003-4, reduced the habitat bank that had been established in the previous Revision 5 (Amended) to 4567 cfs-days and extended the provisions of Revision 5 (Amended) through April 30, 2004. It also established more detailed rules for utilizing the Thermal and Habitat Release Banks. Finally, it reaffirmed the West Branch Delaware flow target schedule and the Cannonsville release schedule as specified in Resolution No. 2001-21.
DRBC Docket D-77-20 CP (Revision 7)
DRBC Resolution No. 2004-3 superseded and incorporated certain provisions of Dockets D-77-20 CP (Revisions 2 through 6) to establish an interim conservation release program for the NYC Delaware Basin reservoirs for the period beginning May 1, 2004 and ending May 31, 2007. The Decree Parties committed to continuing discussions with the objective of developing and implementing by May 31, 2007 a long-term flexible program to manage releases from the NYC Delaware Basin reservoirs, based upon sustainable resources, to better address the needs of the tailwater fisheries and other needs, including those associated with both withdrawal and nonwithdrawal uses on the mainstem Delaware River down through the Delaware Bay, taking into account New York City's water supply needs and the four states' water requirements.
This resolution continued the designation of drought watch and drought warning diversions and releases as specified in Revision 4. It established a 20,000 cfs-day (12.9 bg) Habitat Protection Bank (HPB) for habitat and thermal protection of the tailwaters below each of the NYC Delaware Basin reservoirs, consisting of the following three smaller, or "sub" banks:
- Excess Release Quantity Bank (ERQB) of 5,700 cfs-days
- Thermal Release Bank (TRB) of 9,200 cfs-days
- Supplemental Release Bank (SRB) of 5,100 cfs-days
The Lake Wallenpaupack drought operating plan instituted by Resolution No. 2002-33 provided for the use of lake storage to meet the Montague flow target during watch, warning and drought operations. Because the plan has the effect of conserving storage in the NYC reservoirs, it resulted in a benefit to the Basin through a substantial reduction in the modeled number of drought operating days which result from the fisheries releases. The use of water from Lake Wallenpaupack to meet the Montague target results in fewer and reduced directed releases from the NYC reservoirs - releases which directly benefit the tailwater fisheries below NYC's Delaware River Basin reservoirs. Consequently, in addition to the three-part Habitat Protection Bank, an Amelioration Bank (AB) of 3,000 cfs-days was established in Revision 7 to provide water to mitigate the potential impacts to the fisheries that may result from the Lake Wallenpaupack drought operating plan. In years during which such plan is in effect, the AB is available during drought watch, drought warning and drought operations, subject to certain conditions and limitations.
Upon entry into drought, habitat protection, including thermal protection, may be provided, subject to the availability of the ERQB and at the discretion of the downbasin parties to the Decree.
Revision 7 specified flow targets for, the East Branch Delaware River at Harvard, NY and the Neversink River at Bridgeville, NY in addition to the previous target for the West Branch Delaware River at Hale Eddy, NY. During normal hydrologic conditions, the flow targets are 225 cfs at Hale Eddy, 175 cfs at Harvard and 115 cfs at Bridgeville. These targets are reduced in drought watch, drought warning and drought in accordance with Table 2. Minimum conservation releases established by Revision 7 for the three reservoirs are shown in Table 3. The minimum summer releases are lower than those in D-77-20 CP Revision 4, provided that the flow targets below the reservoirs are met. The difference between the releases resulting from Revision 7 and the reference releases in Revision 4 are debited or credited to the HPB, except that a negative balance in the HPB is not allowed. If banks are exhausted and targets cannot be met, the conservation releases continue as specified in Revision 4.
To maintain high quality water for New York City, diversions from Cannonsville Reservoir may be curtailed and diversions of higher quality water from Neversink Reservoir may be increased. Also, flow targeting at Bridgeville may be suspended, depending on water quality criteria at Cannonsville to protect the quality of drinking water diverted to New York City. The criteria for suspension of the Bridgeville target include concentrations of total phosphorus, coliform, turbidity and total phytoplankton.
If the combined storage of the three NYC Delaware Basin reservoirs drops below 25 percent of usable capacity (67.7 bg), water can be made available from the ERQB, with the concurrence of the down-basin parties to the Decree, and flow targeting may be suspended until storage recovers to 5 bg above the Drought Watch line for one day.
Revision 7 requires that NYSDEC conduct an evaluation of the response to the new fisheries releases program of tailwater biota, particularly brown and rainbow trout populations, based on an approved Monitoring Plan. It further provides for interim progress reports by the NYSDEC to be submitted to the DRBC by February 28, 2005 and 2006. By December 31, 2006, NYSDEC must submit a draft scientific report to the DRBC of the effects on the fishery and other aquatic resources resulting from implementation of the tailwater fisheries program. A final report is to be submitted to DRBC and the Decree Parties by NYSDEC by May 31, 2007.
DRBC Docket D-77-20 CP (Revision 8)
Docket D-77-20 CP (Revision 8), approved by Resolution No. 2004-9, allowed that portion of the ERQ not earmarked for protecting tailwater fisheries below the NYC Delaware Basin reservoirs, to be used for certain purposes including aquatic resource research related to the fisheries program, including dwarf wedgemussel studies conducted at the request of the U.S. Fish and Wildlife Service. Revision 8 made no change to the terms of the Habitat Protection Bank established by Revision 7, which will expire on May 31, 2007 or earlier in accordance with the provisions of Revision 7, Paragraph 9.
Other Actions by DRBC and the Decree Parties
Formation of the Subcommittee on Ecological Flows (SEF)
Resolution No. 2003-18 formalized a process for developing and evaluating the feasibility of achieving flow targets to address instream flow and freshwater inflow requirements for aquatic ecosystems in the Delaware River Basin, including the Delaware Bay. It also established a Subcommittee on Ecological Flows (SEF) to assist the DRBC's RFAC (and formerly, the FMTAC) in developing scientifically-based ecological flow requirements for the maintenance of self-sustaining aquatic ecosystems.
The Commission and the Decree Parties committed to participating in a non-binding collaborative process to develop experimental flow management options for the Delaware River and its regulated tributaries. The objectives include development of scientifically-based ecological flow requirements, objective recreational needs assessments, a review of the estuary salinity objective, and an assessment of existing and future municipal, industrial and other water supply needs.
The purpose of the SEF is to assist in developing scientifically-based ecological flow requirements. The SEF provides regular progress reports to the RFAC and works with the DRBC's RFAC and the Water Management Advisory Committee (WMAC) in a collaborative way. Membership of the SEF includes at least one member of the RFAC who is a Decree Party member and at least one member of the WMAC who is not a Decree Party member.
Flow Modeling
Since the early 1980's, daily flow and salinity modeling has been used to compare alternative reservoir operating rules for the Delaware River Basin's major reservoirs, including Beltzville, Blue Marsh, Nockamixon and F.E. Walter Reservoirs, in addition to the NYC reservoirs. A separate document entitled "Delaware River Basin Daily Flow Model " describes the development of the flow modeling capability. This document is available from DRBC on request.
a The Compact also states that DRBC, after consultation with the River Master, may by unanimous consent of its members declare a state of emergency resulting from a drought or catastrophe and may authorize and direct an increase or decrease in any diversion permitted or releases required by the Decree, in such manner and for such limited time as may be necessary to meet such emergency condition.
- Supreme Court of the United States, Delaware Diversion Case, State of New Jersey v. State of New York and City of New York, Opinion of Justice Holmes, May 4, 1931.
- Supreme Court of the United States, Amended Decree, State of New Jersey v. State of New York and City of New York, June 7, 1954.
- U.S. Geological Survey, Office of the Delaware River Master, web site, http://water.usgs.gov/osw/odrm/.
- U.S. Geological Survey, Report of the River Master of the Delaware River, U.S. Geological Survey Open File Report, Filed Annually from 1955 to Present.
- Delaware River Basin Commission, Delaware River Basin Compact, Section 3.3, Paragraph a, October 27, 1961.
- States of Delaware, New Jersey, New York, and Pennsylvania, and New York City, Interstate Water Management Recommendations of the Parties to the U.S. Supreme Court Decree of 1954 to the Delaware River Basin Commission Pursuant to Commission Resolution 78-20.
- Delaware River Basin Commission, Delaware River Basin Water Code, December 1996.
- Delaware River Basin Commission, Docket D-77-20 CP, May 1977; Docket D-77-20 CP (Revised), November 1983; Docket D-77-20 CP (Revision 2), June 1993; Docket D-77-20 CP (Revision 3), February 1997; and Docket D-77-20 CP (Revision 4), April 1999.
Table 1
Reservoir Release Rates
|Reservoir and Operative Dates
|(Column 1)
Basic Conservation Release
|(Column 2)
Augmented Conservation Releasea
|(Column 3)
Augmented Experimental Conservation Releaseb
|1/1 - 3/31
|6 cfs
|50 cfs
|45 cfs
|4/1 - 4/7
|6 cfs
|70 cfs
|45 cfs
|4/8 - 4/30
|19 cfs
|70 cfs
|45 cfs
|5/1 - 5/31
|19 cfs
|70 cfs
|70 cfs
|6/1 - 8/31
|19 cfs
|70 cfs
|95 cfs
|9/1 - 9/30
|19 cfs
|70 cfs
|70 cfs
|10/1 - 10/31
|19 cfs
|70 cfs
|45 cfs
|11/1 - 12/31
|6 cfs
|50 cfs
|45 cfs
|1/1 - 3/31
|5 cfs
|25 cfs
|25 cfs
|4/1 - 4/7
|5 cfs
|45 cfs
|25 cfs
|4/8 - 4/30
|15 cfs
|45 cfs
|25 cfs
|5/1 - 9/30
|15 cfs
|45 cfs
|53 cfs
|10/1 - 10/31
|15 cfs
|45 cfs
|25 cfs
|11/1 - 12/31
|5 cfs
|25 cfs
|25 cfs
|4/1 - 4/15
|8 cfs
|45 cfs
|4/1 - 5/31: 45 cfs
|4/16 - 6/14
|23 cfs
|45 cfs
|6/15 - 8/15
|23 cfs
|325 cfs
|6/1 - 9/15: 160 cfs
|8/16 - 10/31
|23 cfs
|45 cfs
|11/1 - 11/30
|23 cfs
|33 cfs
|12/1 - 3/31
|8 cfs
|33 cfs
|9/16 - 3/31: 45 cfs
|aD77-20 CP Revised
bD77-20 CP Revision 2
Table 2
Habitat Protection Bank Flow Targets D-77-20 CP (Revision 7)
|Target Location
|Flow Target (cfs)
|Drought Watch
|Drought Warning
|West Branch Delaware River at Hale Eddy
|East Branch Delaware River at Harvard
|Neversink River at Bridgeville
|aSubject to the availability of the ERQB and at the discretion of the down-basin parties to the 1954 U.S. Supreme Court Decree, or availability of the Amelioration Bank (AB).
Table 3
Conservation Releases (D-77-20 CP Revision 7)
|Conservation Release (cfs)
|Drought Watch
|Drought Warning
|Cannonsville (9/1 - 5/31)
|Cannonsville (6/1 - 5/31)
Figure 1
New York City Delaware Basin Reservoir Experimental Rule Curve


text:
The Curator Is In, May 3, 2012Posted on by Minneapolis Institute of Arts
MIA: Our curators are now online. They'd like to know what you love about the MIA and what we could do better. Feel free to ask the curators questions too.
Jon S.: Hi! Just wondering if the MIA bought "The Scream"?
Christopher Atkins: Ha! I heard a rumor but nothing has been confirmed yet.
Jennifer Olivarez: Chris, if we did buy "The Scream," we'd be saving our pennies for the next few years for art purchases, at least!
Christopher Atkins: JKO: haha, saving LOTS of pennies and looking for change in the period room couch cushions.
Thomas Rassieur: If we bid that high, our trustees might look like the figure in the picture!
Kyle J.: I love the MIA – you do a fantastic job of keeping it current and changing it up to make it interesting. Still, I wish we had more Greco-Roman art. Our Doryphoros statue is superb, and our other smaller Mediterranean statues are great too. Still, this is one area I would love to see expanded. That, and our William-Adolphe Bouguereau collection – can never get enough.
Thomas Rassieur: Kyle, I love classical art, too. Unfortunately, it's really difficult to collect in this area. Much of the material that appears on the market was quite possibly looted.
Corine Wegener: Kyle, I also wish we had more Greek and Roman works of art. However, it is tough to find pieces on the art market with documented history of leaving the country of origin prior to 1970, which is part of our collecting policy for antiquities. Those that do have a documented history of ownership tend to bring very high prices.
Kyle J.: I imagine that makes things exceedingly difficult. Although the copy is not "ancient," I still love the fact that we have a Borghese Gladiator/Warrior on loan. This is a simple example of the great things the MIA does. We should borrow all the good, ancient statues! Have anything to share about Bouguereau?
Charlotte E.: I confess to being a partisan of MIA (& a professional colleague). Was there briefly on Sunday afternoon and all the galleries I visited looked great. Fabulous collections, beautifully installed, some amazing new acquisitions and recently conserved works shown in a new light. I only have KUDOS for MIA curators (& can't get get on board with the "for worse" part of this, though I appreciate the spirit of community engagement via social media). Voila: 2 cents.
Thomas Rassieur: Hi Charlotte! Sorry I missed you during your visit here, but thanks for the vote of confidence in the MIA!
Jennifer Olivarez: Thanks Charlotte! It was great to hear our colleagues' comments about the MIA during the AAM conference! We appreciate the pats on the back!
Strickland Vintage Watches: Minneapolis Institute of Arts, we so love your Facebook posts … they help assuage the pangs of not being there in person!
Monte M. M.: To the curators: Thank you!!
Laura C.: Would love to see the expansion of your Mesoamerica collection!
Joe Horse Capture: So would we! We insure that the objects we acquire comply with state, federal, and international laws. There are a very limited amount of Meso-American objects on the market that are in full compliance, which makes it difficult for us to collect. But we will be installing a small exhibition in gallery 255 this fall that will feature objects and textiles from our permanent collection.
Brad L.: Hmm…How to improve the MIA? No doubt there are ways, but it is such a treasure as it is now. Please continue the arts leadership you are so well known for. The rotating exhibits are great, love the art carts, the photography collection, well, just about everything.
Here is an additional thought. One style of exhibit that captures me the most are where everyday ancient objects are placed in the context of their time, e.g. the Chinese scholar's study and the Chinese meeting room. I don't know exactly …why I like this style so much, other than to say it feels as if I am inside the art, rather than just looking at it from the outside. The European salon exhibit captured some of this sense as well.
Dave E.: any chance of putting the sand mandala horizontal, like it was meant to be? (or putting a painting on the floor? surrounded by velvet ropes, of course)
Jennifer Olivarez: Hi Dave, it's not in my department, but yes, theoretically, we could show the mandala on the floor or horizontally, such as on a pedestal. I think it has mainly been displayed on the wall due to a need to keep floor space open, as it does take up quite a bit of floor space when shown horizontally. Something to keep in mind if we re-install the Asian art collections in the future or want to highlight the work in some way. I think it would need to be close to the ground for the best viewing of the colors and designs.
Jennifer Olivarez: We curators heard a lot at this weeks' American Association of Museums conference about including the visitors' voice in the musem in different ways. How do you visitors see yourselves being included in what we curators do here? (e.g. anyone for sharing label writing duties? Just kidding–but a serious request for your thoughts.)
Carissa G.: When I was in Boston in 2010, select works had poetry posted next to them — some of it, I believe, by patrons. Has MIA worked with poets? -cg
Jennifer Olivarez: Carissa, I have heard of that idea, or even of asking prominent people in the community to give their own audio interpretation of specific works. Definitely an interesting idea, kind of an "Art in Bloom" flower interpretation idea transferred to poetry paired with artworks.
Thomas Rassieur: I've included poetry in exhibitions but have not yet worked directly with poets. Sounds like it could be fun. Anyone have a poem on a work of art the you'd like to share right here?
Carissa G.: I will nerd out by saying that I enjoyed the "Flickr" feature recently on hauntings. More short, fun stuff like that would be great. For instance, is there documentation about where and how any particular work was displayed when it was still under private ownership? Photographs of a painting or sculpture in situ in a private mansion a century ago? -cg
Jan-Lodewijk Grootaers: In the exhibition "iAfrica: Connecting with Sub-Saharan Art" (2009-2010), we included a photograph of the apartment of Arman, the French-American artist who had an excellent collection of African art. The photo was displayed next to a fantastic West African sculpture (a rhythm pounder from the Senufo people) that is visible on the photo. It would have been even better, of course, to have an image of the object in use in a Senufo village…
Carissa G.: Excellent — and was it placed online for those of us who have to travel 350 miles each way to visit you?
Carissa G.: I must say, I loved how the museum supplemented the traveling Titian show (which I was able to attend) with its own prints. I'm sure that was an obvious move, but the "supersize" bonus was appreciated. -cg
Sheila R.: If you could buy any piece for any amount of funds, what would you get?
Ericka A.: Mucha, probably the Moravian singing group piece.
D'Arcy A.T.: I always wanted Brower Hatcher's 'Prophecy of the Ancients'…
Corine Wegener: A major piece of furniture by 18th century cabinetmaker André-Charles Boulle (and anything by Peter Paul Rubens.)
Liz Armstrong: From the universe of artworks that are available (i.e., not in other collections), it would be Ed Keinholz's 1959 "Mother Sterling," his first figurative sculpture and a turning point in modern and contemporary art.
Yesenia G.A.: Chuck Close's self portrait at the Walker has always been one of my favorites.
Jennifer Olivarez: How about Edvard Munch's "The Scream"? I have to say when I heard about the sale yesterday (for $199M) I fantasized about how we could use that painting at the MIA if it were ours.
Barbara H.: Veiled Lady – my absolute favorite
Carissa G.: Jennifer, I think the MIA's Munch is very enigmatic in its own right. -cg
Heidi Q.: or the $199 million that bought it
Jennifer Olivarez: Oops, sorry, it was only $119M…
Katie S.: Anything Degas!
Anne-Marie W.: One of Pollock's drip paintings or a great Rothko.
Casey P.: Anything Van Gogh.
Joe Z.: I love the new contemporary arts section. The feeling of seeing the contemporary art with so many classics helps bring the section full circle versus going to say the walker and spending the entire time wondering around modern art the entire time. It brings a sense of growth to modernism that is missed when its not side by side with traditional pieces..Also I was just their 2 weeks apart and wondering the hallways with the art in bloom installation was very exciting and I felt brought some unique perspectives on the pieces as well as interpretations. This was my first art in bloom I attended, and I had an absolute blast. Thanks for everything that you provide to the twin cities and Minnesota arts community. It truly is invaluable.
Carissa G.: Thank you.
Comments are closed.
Leave A Comment

subset: commoncrawl


text:
A snowstorm hit Worthington in early November 1959.
Worthington policemen making their rounds at midnight were among the few residents on city streets as the first snow storm of the season settled over southwest Minnesota and northwest Iowa Wednesday night. Officer Wayne
Radenbough (am I reading that remotely correctly?) Redenbaugh (thanks, Sea Town!) trudged through the new snow in an alley and past a dilapidated refrigerator which prompted him to remark later, "It was like an ice box out there." By dawn the snowfall totaled three inches and the temperature was 15 degrees.
Next post at noon.


text:
Grendel's Den celebrates Supreme Court win and 40 years in Harvard Square
Brock Parker / Boston.com
It's been welcoming intellectuals and people from all walks of life in Harvard Square since 1971, but when patrons raise a glass to toast Grendel's Den 40th Anniversary this weekend, a few good words may also be said about the U.S. Supreme Court.
The restaurant and bar, named for the bad guy in "Beowulf," had to wage its own battle of epic proportions against a state law that enabled a neighboring Cambridge church to veto Grendel's bid for a liquor license in the mid 1970s.
The case of separation of church and state went all the way to the U.S. Supreme Court before Grendel's owners Herbert and the late Sue Kuelzer finally prevailed.
"It has become the landmark precedent in the law of separation of church and state because it really was the first case in which the Supreme Court considered this very basic principal of whether religious bodies could be given governmental power," said Laurence Tribe, a Harvard Law professor and constitutional law scholar who argued the case before the Supreme Court on behalf of Grendel's Den.
Friday night, Grendel's Den and second-generation owner Kari Kuelzer, daughter of Herbert and Sue Kuelzer, will celebrate the 40th anniversary of restaurant and the 29th anniversary of its victory in the Supreme Court.
The restaurant at 89 Winthrop St. will have an invitation-only event Friday evening featuring remarks by Tribe and other special guests, followed by a public celebration beginning at 9 p.m. with live bands and a party that will continue to 1 a.m.
"This is a big milestone," said Kari. "There are a lot of people who care about Grendel's. It's like a home to me in a lot of ways."
Kari, who says she's roughly the same age as the family restaurant, was only 12 years old when she began working as a hostess for Sunday brunch at Grendel's. It was the same year she watched Tribe argue Grendel's case before the U.S. Supreme Court.
The case began in the mid 1970s when Grendel's neighbor, Holy Cross Armenian Church in Harvard Square used its power under state blue laws to veto a liquor license for the restaurant.
Tribe said he learned of the case while teaching constitutional law and the separation of church and state at Harvard Law School and a student raised his hand in class and said he couldn't get a beer with his lunch at Grendel's Den because a church had vetoed the restaurant's bid for a liquor license.
"I said 'You've got to be kidding,'" Tribe recalled. The professor, who had already argued several cases before the U.S. Supreme Court, investigated and was soon representing the Kuelzers in a complaint filed under federal civil rights laws against the state Alcoholic Beverage Control Commission that said the state did not have the right to give a religious body the power to decide who can serve liquor.
The courtroom battles waged for years before the Supreme Court ruled 8-1in favor of Grendel's in 1982, with Justice William Rehnquist dissenting. Grendel's received its liquor license the next year and the place quickly became known as a bar serving micro-brewed beer from Sam Adams and the Cambridge Brewing Company, Kari Kuelzer said.
Almost 30 years later, the church next to Grendel's has been torn down.
Rev. Raphael Andonian, the pastor of the church, said it moved from Harvard Square to Belmont in the late 1990s for several reasons, including the lack of parking in the square . He said church members rarely discuss the suit.
Grendel's is still in the square and still going strong.
"We don't have a lot of TVs," Kari said. "We try to leave it a good place where people can have a good conversation with each other. Obviously it gets a lot more lively in the evening. Somehow, we managed to create a Grendel persona that is much more cuddly."
And today Kari, who assumed management of Grendel's in 2004 following the death of her mother, still hangs at the restaurant's front door a framed black and white article from the New York Times in 1982 features a photo of Herbert and Sue Kuelzer celebrating their courtroom victory.
"It was a thrill," Kari said.
For more information about Grendel's Den 40th Anniversary celebration, visit the restaurant and bar's website at www.grendelsden.com.


text:
Bioremediation of TNT & DNT in Homogenized Soil
DARAMEND® bioremediation technology was applied at pilot scale to approximately 100 tons of soil from the former Raritan Arsenal in Edison, New Jersey. Area 4 at the Raritan Arsenal was formerly used as a high explosives salvage and melt-out area from World War I through the 1920s.
The Challenge
Homogenized soil from the site contained approximately 600 mg/kg of TNT/DNT.
The Solution
Soil excavated from Area 4 was placed in an Engineered Biotreatment Cell (EBC) constructed in a small building on the former arsenal property. The EBC was built using portable barrier walls overlain with a 40-mil HDPE liner. The liner was protected with an 8-inch layer of sand, and a 2-foot layer of soil from Area 4 was placed on the sand layer. The EBC also included an irrigation system and decontamination pad. Because the pilot was conducted in the winter months, the building was insulated and heated.
The Result
The pilot was scheduled to run for about 75 days. After 28 days of treatment, however, TNT concentrations had been reduced to an average of 74 mg/kg and amino-DNT was reduced to 25.9 mg/kg. These levels met the proposed Remedial Goals for the site. After 56 days, the concentration of TNT was reduced to <5 mg/kg and amino-DNT was reduced to <3 mg/kg. Because of rapid rate of treatment, the demonstration ended after only 56 days.
The Cost
Based on the results of the pilot demonstration, full-scale treatment costs were estimated at $68/ton of soil treated. This estimate assumed that the soil treated during the pilot-demonstration was representative of the entire site and that a total of approximately 5,000 tons of soil would be treated. Estimated treatment costs included all construction costs for the treatment cell, manufacture and delivery of all amendments and turnkey application of the technology to site soil. The estimate excluded excavation, UXO clearance, delivery of the soil to the treatment cell, and confirmatory analytical cost.
The Timeline
Treatment cell construction began on November 8, 1998 and continued through December 2, 1998. Immediately following construction the pilot-demonstration was initiated. Four fourteen (14) day treatment cycles were applied to the soil, and treatment was completed on February 5, 1999. A short break (8 days) was scheduled late in December 1998.


text:
DarkHeartStudio Bio
I am a novice artist and character creator. I began dabbling with DAZ Studio in 2005, and have been slowly trying to improve my skills over time.
In April of 2010, I lost my only child to suicide. The grief was overwhelming, and for many months, nothing I used to do was pleasurable anymore.
With time, I started to get back to my hobbies. Creating images was an experience that became very soothing. It was a very welcome distraction, and I think, part of my path toward healing.
It is my hope now that art will become a regular part of my life once again.


text:
I have got a citraon xsara forte! It has recently developed a problem with the heater/ventilation controls. It is stuck of full blast and won't turn down. All the other controls work so the heating works and changing where the air goes works but I cant turn it down.
Can anyone help me as to why it is has happened? And how I can fix it?
have the same problem?
Monday, May 7th, 2012 AT 3:28 PM


text:
Jayonna Trenee Parker was born at 9:41 p.m. to Jaimei D. Parker of Hinesville.
Born at Liberty Regional Medical Center, baby Jayonna weighed 7 pounds, 5 ounces and measured 19 inches.
The baby's maternal grandparents are Ywinta and James Parker of Hinesville.
The baby also is welcomed by brother Jamaree T. Parker.


text:
Membership Renewal/Registration
WAIER invites people to become members and renew their membership. To attend or present at our Forums you must be a member. Members also receive email notifications about upcoming research seminars and the latest Issues in Educational Research (IIER) journal.
Please use the payment button below if you would like to pay with Paypal or via credit card. We recommend you make the payment before you fill out the membership/registration form below. Bank transfers (EFT) should be made to BSB: 066155 Account No: 00902153 Account Name: WA Institute for Educational Research Reference: Surname.
Please ensure you complete and submit our online membership form below the payment button.
Please contact Dr Gregory Hine at firstname.lastname@example.com if you require any assistance.


text: Agriturismo Colleverde is a charming quiet place located in the heart of West Tuscany. The place is a perfect mixture of nature, confort and intimity. Being there, you feel lost somewhere between the green hills, far away from the town noise. We've found the place easily guided by our GPS. In the first day, we arrived at Colleverde around 10pm,... More


text:
There will be quite a few Camaros out racing this weekend... Here's the information...
120 Old Columbus Road South
Sealy, TX 77474
Phone: 979-877-0922
The track will open at 10:00 am on Saturday morning. The track will go hot at 11:00 am and drag racing will continue until 5:00 pm. The schedule on this day will consist of test-n-tune, 2 rounds of qualifying for the next days eliminations and 60-130 runs if you so wish.
Cost: spectators will pay $20 to LMP on Saturday. Racers will be able to purchase a "2-day tech card" on Saturday (NON-REFUNDABLE if you break on Saturday) for $80 (in addition to the $20 cost to enter). If a racer only wants to run on Sunday, the tech cards will be the same price as last year, $45 (in addition to the $20 cost to enter).
Food: concessions will be open all day
Sunday Schedule: the gates will open at 8:00 am and the track will go hot at 9:00 am. From 9:00 am until 4:00 pm we will have 1 round of qualifying and eliminations. Schedule will be as follows:
10:00 am - qualifying pass 1 (test-n-tune after)
12:00 pm - eliminations round 1 (test-n-tune after)
1:30 pm - eliminations round 2 (test-n-tune after)
2:45 pm - eliminations round 3 (test-n-tune after)
3:45 pm - final round eliminations
There will be a dedicated lane for test-n-tune ALL DAY LONG.
DRAG RACING CLASSES - same as last year
Street Car Class
This class will be administered by a sponsor that is local to Houston named ARD. They came to me with this idea and I liked it so much, I decided to give it a shot this year! Thank you to Owen Priest and ARD for helping me put this class together. This class can and should include Vettes, Porsche's, Vipers, Supra's, Camaro's, Mustang's, etc...
The rules:
--all entrants will be required to go on a 20-30 mile cruise and will have to stay behind a lead car and in front of an end car...any participant that falls out of that line for any reason during the cruise will be disqualified and entry fee will not be refunded...the cars that fall out can stay and test-n-tune all day...speeds on the cruise will be mostly highway and will be in the 60 mph range...
--the cruise will leave the front gates at Lonestar at 11:30 am...just after qualifying pass 1 and back in enough time to run qualifying pass 2 if wanted
--carpet, both front seats and door panels required
--inspection sticker required (in the state you live in)
--radio that works is required (which means you need speakers too)
--stock suspension required (all suspension components must be located in the stock locations)
--no tire rule
--no fuel rule
--no power adder rule


text:
Fast foreign recruit makes a splash in Pitt's pool. CollegeSwimming.com::Pittsburgh Splits With West Virginia With the meet tied at 94 points and swimming in his first-competition meet of the season, Plutecki (Zielan Gora, Poland/High School #VII) recorded a pool and school record in the 200 breast with a time of 1:58.98. Plutecki's time eclipsed the four-year 1:59.42 record held by Randy Gertenbach.
Plutecki's time was also a NCAA B cut time and missed the NCAA A cut time by just a second.
Monday, January 08, 2007
Pittsburgh Splits With West Virginia in the swim pool. New Polish student sets record in breast
No comments:
Subscribe to: Post Comments (Atom)


text: As usual, I'm asking here because (a) The NetBSD community is quite knowledgable, (b) this is NetBSD related, (c) I suspect that others have solved this already, and (d) googling for it will probably produce 10,000 hits that don't really quite get at what I want to do. (^& A year or so ago, I looked at internet telephony. I was disappointed that I couldn't get the only package I could find (openh23) to work. Or, rather, on the machines I tried (maybe excepting 1), it couldn't pick up any voice to speak of (no pun intended). I now believe that this is because the default audio record settings are basically of no value; one needs to use audioctl and/or mixerctl adjustments (often different with each different audio device, one per machine) to get any kind of recording. So, now I'm thinking about this again. My interest is to both send and receive calls, though receive-only would be adequate. I'd rather not pay anything above my Internet connection (which trundles along nicely on a DSL link). I have a static IP and my own domain; the main person I'd like to speak to (a brother, with whom I collaborate and consult on various topics; sometimes he helps me, sometimes I help him) has only a dynamic IP and a WIN32 box. (Though in practice his "dynamic" IP tends to stay static for long periods of time; I do not know if his provider knocks him off from time to time or just leaves him online. He tends to believe the latter.) My brother lives far enough away that a local call won't handle it (nor is it practical to meet him face to face), and my PCS phone can run up a big bill in a hurry if I use it indiscriminately during weekdays. Ideal would be for people using commercial software/providers to be able to call me (or perhaps even vice versa) without my paying for a provider---since I have my own IP. (^& (Well, even better would be the above, plus to be able to use an "Internet phone" to make outgoing calls to regular phone numbers more or less anywhere in the world at a very low rate (or perhaps even for a flat rate), and receive such calls, so that I could consider dispensing with my PCS phone.) What kinds of options are there for me on NetBSD? (Pref. on non-i386---though if building from pkgsrc, that presumably wouldn't be an issue.) Is this easy and free? What about privacy? Do any open standards have built in encryption (do they all?)? -- "I probably don't know what I'm talking about." http://www.olib.org/~rkr/


text:
Tonight's Evening Brief is brought to you by Nsolv, a Canadian clean-tech energy company with a cleaner and more economical solution for producing heavy oil. Using no water and less energy, Nsolv can help Canada achieve its climate action targets.
Evening all,
The Lead:
We begin tonight with oilpatch diplomacy. Prime Minister Justin Trudeau has been in Alberta — ground zero for both the oil crash-driven Canadian economic narrative and the political debate surrounding the role of fossil fuels in that story. After meeting with Premier Rachel Notley in Edmonton Wednesday and announcing $700 million in fast-tracked infrastructure spending and other federal assistance for the province, Trudeau met with oil industry leaders in Calgary today. Suncor CEO Steve Williams said that meeting was encouraging but, quite predictably, produced no assurances on pipeline approvals under new federal regulations.
The issue of pipeline approval, which unleashed a politicized national debate last month when Montreal Mayor Denis Coderre publicly denounced TransCanada's proposed Energy East pipeline, also came up in QP today. Our Janice Dickson has the round-up.
In Canada:
Employees at the penal institution Okimaw Ohci Healing Lodge repeatedly brought children to their workplace, threatening their safety and constituting "gross" mismanagement under the Public Servants Disclosure Protection Act, a report tabled in Parliament on Thursday shows. Janice Dickson has that file.
One of many interest groups that are pressuring the Trudeau government ahead of its first budget — expected next month — a coalition of housing sector groups called on Ottawa to spend $3.5 billion on affordable housing in the next 10 years. Our Selina Chignall has the details.
Ottawa Mayor Jim Watson is hosting some of his big-city counterparts for a pre-budget lobbying meeting of their own, with federal infrastructure spending high on the agenda. CBC has that story.
The House of Commons Standing Committee on Agriculture and Agri-Food is the epicentre of agriculture discussion on Parliament Hill, dealing with everything from animal welfare to interprovincial trade, labour, bee health and rail transportation — conversations that are closely followed by farmers and stakeholders directly involved in Canada's $106 billion industry. Our Kelsey Johnson has the new who's who on the committee.
The NDP is urging the governing Liberals to surrender majority control over the special Commons committee that's supposed to recommend an alternative to Canada's first-past-the-post electoral system. CP's Joan Bryden has that story.
While Fisheries Minister Hunter Tootoo was hailed Wednesday as being the first cabinet minister to take part in the Senate's question period, he's not even close to the first minister from the House of Commons to appear in the Senate, or to answer questions there. Our Kyle Duggan has the history.
In James Munson's Drilldown blog: Trudeau in Calgary amid oil patch woes, plus all your other resource politics news.
In Kelsey Johnson's Sprout blog: Canada signs TPP, promises consultation, plus all the other ag news you need to know.
In the 2016 U.S. presidential campaign, The Des Moines Register has called for an audit of the results of Tuesday's Democratic primary, which apparently produced a historically narrow win for Hillary Clinton. "What happened Monday night at the Democratic caucuses was a debacle, period," the editorial reads. Meanwhile, in New Hampshire, Clinton actually did this last night. On the Republican side, Marco Rubio is riding a post-Iowa surge and Jeb Bush is bringing in the big gun.
In London, at the Syria Donors Conference, the EU pledged to maintain annual funding levels of $3 billion until 2017, the United States pledged $925 billion next year, and the United Kingdom pledged $1.7 billion for the next four years. Speaking via teleconference from London, Canadian International Development Minister Marie-Claude Bibeau said she had not presented allies with specific numbers of what Canada will contribute because the government of Canada wants to announce its humanitarian and development funding for Syria at the same time as it unveils its adjusted military strategy for fighting ISIS. "The reason I didn't announce numbers today is we really want to announce a holistic approach," Bibeau said, noting the announcement will come in a matter of days. "It's important to us to do it all together." Our Amanda Connolly has the full story.
In Other Headlines:
- Obama to propose $10-a-barrel oil tax (Politico)
- Italian student found dead in Cairo with 'signs of torture' (The Guardian)
- UN panel to say Assange 'arbitrarily held' (BBC)
In opinion on Trudeau's Alberta trip: The Calgary Herald's Don Braid has, "Trudeau starts Alberta visit on right note"; The Star's Chantal Hébert has, "Support from mayors essential for any pipeline project"; and The National Post's Jen Gerson has, "Thanks for visiting Alberta, Prime Minister. But what, exactly, is the point?"
The Kicker:
Finally, from The Onion, an update from the bunker: "Slow Canadian Takeover of U.S. Going According to Plan."
Good night.


text: Jordan Wilberding wrote: > On my computer it returns: > > {ok,["lo","eth0"]} > > But anyways, the strings are just in reverse, so do this: > > lists:map(fun(X) -> lists:reverse(X) end, List) > > where List is ["51.0.861.291","22.214.171.1241"] in your case. That would produce the wrong result (192.168.0.15 instead of 192.168.0.150). Has anyone tried to investigate this strange bug? I've written C code to get the interface list on Windows, using GetAdaptorsInfo, and that function seemed to do precisely what the MSDN documentation said it should do. -- David Hopwood <>


text:
Last week I wrote Only Lovers Can Be Mighty. Being a lover and a warrior are two sides of the same coin. This week though I was reminded of a fellowship I had with Mr. Danker, an older brother in the Lord, concerning:
Who would be the most valuable person in the Lord's eyes?
Previously I considered being a lover and being the most valuable person as pretty much identical. I mean if you're a lover to someone, then by default, aren't you the most valuable person in that someone's eyes?
Our answer would, of course, be yes.


text:
LYNNWOOD — A Lynnwood man was listed in serious condition in the intensive care unit at a Seattle hospital Monday after being hit by a car as he crossed Highway 99 Sunday evening.
The man, 52, was trying to cross the road westbound in the 15000 block when the accident occurred around 7 p.m.. He was not in a crosswalk, the Washington State Patrol reported.
The man was taken by ambulance to Harborview Medical Center in Seattle.
The driver — a Lynnwood woman, 42 — was not cited.


text:
OTHER SERVICESfind out more
OTHER FACILITIESfind out more
Branches information
Savings with "KANAKAMAHALAKSHMI BANK" are secured with good returns
Gold Loans are short term loans granted against security of Gold ornaments or Jewels for meeting urgent needs.
Term Deposits provided by the bank relatively with a higher rate of interest than a regular savings account.
RD is a kind of savings to encourage thrift to be collected in monthly installments for a fixed period to be repaid at the end of the term.
Home loans are intended for purchase or construction of a new house or improvement to the existing house.
A business loan is a loan meant for working capital needs and business expansion.
Based on the deposit amount the customers will have a privilege to apply for a Loan against depost for personal or business needs .
Mortgage loan is a loan granted against the security of immovable property to suit customer requirements.
Cash Credit is a limit for a specified sum sanctioned generally for business purposes without any restriction on the operations up to the sanctioned limit. OD is generally sanctioned to individuals on similar lines.
Savings with "KANAKAMAHALAKSHMI BANK" are secured with good returns


text:
GFB are leading suppliers of specialist conservation products designed and built to a very high standard to meet all the rigours of life in some of Britain's wildest landscapes. We are committed to our founding principles of building with recycled and sustainable materials where and whenever possible and to social inclusion focusing on learning, training and employment creation, working with disadvantaged communities, groups and individuals. Our ethos is "Working together to make our countryside a richer place for wildlife and people".
Building Community
GFB has a proud history of social enterprise involvement and investment into environments, communities and people. Our company has always been involved with and supportive of local groups and trusts, particularly those associated with sustainability projects and the environment. Working alongside GFB, organisations can develop skills and knowledge enhancing their enjoyment and appreciation of the countryside, whilst achieving innovative environmental and conservation projects.
The Green Business Network
Green Future Building has a rich heritage in community development, in part through its 'sister' organisation The Green Business Network. GBN, established 1995, is a multi award-winning association with over 18 years experience in the Landfill Communities Fund (LCF), delivering over 200 successful community and conservation projects worth £4.7M. The Green Business Network is now the community grants arm of GFB.
Green Construction
GFB is an ethical organisation and aims to source certified, sustainable or alternative timber for its projects. We have worked with disadvantaged communities, groups and individuals to deliver training courses in green and sustainable building (as part of an ESF programme "Skills for Climate Change: Low Carbon Living and Working"), resulting in participants continuing on to further training, employment and self-employment. We also provided a green skills academy to improve the employment prospects of offenders, as part of a National Offender Management Service ESF "Step Change" programme.
Nature Conservation
GFB supplies products for priority species and habitats, designed and built to a high standard to meet the requirements of sensitive or designated areas. One of our recent commissions was for a bespoke FSC timber and recycled plastic hide, for the "increased monitoring, recording and understanding of natural history on a hill farm" reserve in Yorkshire Dales National Park. Everyone at GFB is passionate about the countryside and we actively participate 24/7 in monitoring and conservation for local, regional and national wildlife organisations, with hands on experience dating back to the 1970s. We are proud supporters of work at UK bird observatories, Wildlife Trusts and RSPB.
GFB/GBN Case Study
GFB grew out of one of the very first Landfill Communities Fund 'Conservation of Biodiversity' (Category DA) projects in UK. Starting in 2004, Green Business Network (GBN) worked in partnership with Calderdale Bird Conservation Group to build a bespoke bird hide and purpose-designed wetland area in an acutely exposed location, at over one thousand feet in the South Pennine Moors.
As a direct result of this "Ringstone Improvement Project" (Click to view Case Study), the GBN launched a sustainable construction arm 'ABLE2BUILD' – a social enterprise staffed entirely by underachieving young people, which later developed into GFB Ltd (Click to view Case Study).
In 2008, the GBN/ABLE team received a £2,000 prize for the best community Natural Environment project in UK, from judge Tony Richardson, Regional Director RSPB South West.
Featuring a novel bird hide and Barn Owl boxes on a UK BAP Priority Habitat, Caldervale Schools Nature Trail was 1 of only 4 winners from 234 eligible projects for this annual Biffa Award (an RSA-accredited environmental award).
One of GFB's more recent community projects has been to use specially-selected hardwoods to re-build a footbridge across the Black Brook in Halifax, at the starting point of Britain's first recreational footpath (the Grade II* Listed Clay House Park).
GFB's Clay House Link Bridge in collaboration with The Elland & District Partnership, was funded by GBN as part of its Calder Future initiative to improve the River Calder and its tributaries.
In 2015, GFB/GBN relocated alongside the social enterprises Compass Bridge and Project Colt, creating significant new opportunities to add value to project delivery.


text:
Rhubarb Strawberry Granita Recipe
Fresh rhubarb and strawberries make this sweet and icy dessert such a treat. You'll love how quickly it comes together and that it's prepared without any special equipment. —Christen Roye, Weatherford, Texas
Featured In: 32 Sweet and Tart Rhubarb Dessert Recipes
VERIFIED BY Taste of Home Test Kitchen
Popular Videos
- 3 cups water
- 1 cup plus 2 tablespoons sugar
- 1 cup diced fresh or frozen rhubarb, thawed
- 1/2 cup halved fresh strawberries
- 2 tablespoons orange liqueur or orange juice
- Fresh mint leaves, optional
- In a large saucepan, bring the water, sugar, rhubarb and strawberries to a boil. Cook and stir until sugar is dissolved. Strain; discard pulp and seeds.
- Transfer syrup to an 8-in. square dish. Stir in orange liqueur; cool to room temperature. Freeze for 1 hour; stir with a fork. Freeze 2-3 hours longer or until completely frozen, stirring every 30 minutes. Stir granita with a fork just before serving; spoon into dessert dishes. Garnish with mint if desired. Yield: 8 servings.
Editor's Note: If using frozen rhubarb, measure rhubarb while still frozen, then thaw completely. Drain in a colander, but do not press liquid out.
Originally published as Rhubarb Strawberry Granita in Simple & Delicious April/May 2011, p59
Reviews forRhubarb Strawberry Granita
My Review
Click stars to rate
Any changes to your rating or review will appear where you originally posted your review


text:
Donate Online & We'll Match It
Go to our online holiday meal ordering site and select "SOS Donation" as one of your items. Make a donation and we'll match it, up to a total of $25,000. (You can donate even if you don't place a holiday meal order!)
Buy Organic Fuji Apples
For every pound of organic Fuji apples sold at our stores, a donation goes to the campaign. Together, Whole Foods Market, Rainier Fruit Company and Columbia Marketing International will donate two cents for each pound of organic Fuji apples sold from November 14 to December 25, up to a maximum of $30,000.
Order Gift Cards Online
For each Whole Foods Market gift card ordered online from November 16 to December 31, we'll donate $1.
Use Special Coupons
Arrowhead Mills, Celestial Seasonings and Terra Chips will donate 40 cents per redeemed specially marked coupons featured in The Whole Deal value guide.Watch this video to see how your donation to Share Our Strength's No Child Hungry campaign can help the children in your community: No Kid Hungry creates partnerships with anti-hunger groups, government agencies, corporate partners and political, education and business leaders at the state and city level to break down barriers to accessing healthy food. Learn more details about our partnership with Share Our Strength's No Kid Hungry Campaign and find out how Share Our Strength is making a difference in your area.


text:
- Celeb Boutique is catching a great deal of flack for tweeting " #Aurora is trending, clearly about our Kim K inspired#Aurora dress.
- You are disgusting RT @celebboutique #Aurora is trending, clearly about our Kim K inspired #Aurora dress ;) Shop: http://celebboutique.com/aurora-white-pleated-v-neck-strong-shoulder-dress-en.html ….com/aurora-white-pleated-v-neck-strong-shoulder-dress-en.html
https://twitter.com/Zak_Bagans/status/226385271984369664— Zak Bagans (@Zak_Bagans)Fri, Jul 20 2012 18:37:09
- And also another very dark day in the war on stupid. RT @celebboutique #Aurora is trending, clearly about our Kim K inspired #Aurora dress
https://twitter.com/SeanGrandePBP/status/226388170642694144— Sean Grande (@SeanGrandePBP)Fri, Jul 20 2012 18:48:40
- Wow. You guys are disgusting. "@celebboutique: #Aurora is trending, clearly about our Kim K inspired #Aurora dress"
https://twitter.com/MostBoringGirl/status/226391568389656576— Your Mom (@MostBoringGirl)Fri, Jul 20 2012 19:02:10
- The insensitive tweet from @celebboutique has been taken down, and has been replaced one claiming they "didn't check the trend." #Aurora
https://twitter.com/EstebanHRZ/status/226391167930077184— Esteban L. Hernandez (@EstebanHRZ)Fri, Jul 20 2012 19:00:35
- Enjoy your job search (via @kayhanley ) RT @celebboutique #Aurora is trending, clearly about our Kim K inspired #Aurora dress ;)
https://twitter.com/burritosandsnow/status/226390492135440384— burritosandsnow (@burritosandsnow)Fri, Jul 20 2012 18:57:54
- Unbelievable "@celebboutique: #Aurora is trending, clearly about our Kim K inspired #Aurora dress ;) Shop: http://celebboutique.com/aurora-white-pleated-v-neck-strong-shoulder-dress-en.html ….com/aurora-white-pleated-v-neck-strong-shoulder-dress-en.html""
https://twitter.com/WriteTrash/status/226392714189606912— Writetrash (@WriteTrash)Fri, Jul 20 2012 19:06:43
- Huh. @celebboutique uses 6 tweets to apologize for its ignorance about the #Aurora, and in the middle of it, RTs "Its a fabulous friday"?
https://twitter.com/fangeeker/status/226392563131768832— jacqui (@fangeeker)Fri, Jul 20 2012 19:06:07
- The company responded by pulling the tweet and apologizing -- profusely. No word on Twitter yet from Kim Kardashian.
- We didn't check what the trend was about hence the confusion, again we do apologise.
https://twitter.com/celebboutique/status/226390298736066561— Celeb Boutique (@celebboutique)Fri, Jul 20 2012 18:57:08
- We are incredibly sorry for our tweet about Aurora - Our PR is NOT US based and had not checked the reason for the trend, at that time our
https://twitter.com/celebboutique/status/226391371001499648— Celeb Boutique (@celebboutique)Fri, Jul 20 2012 19:01:23
- social media was totally UNAWARE of the situation and simply thought it was another trending topic - we have removed the very insensitive
https://twitter.com/celebboutique/status/226391685175836672— Celeb Boutique (@celebboutique)Fri, Jul 20 2012 19:02:38
- tweet and will of course take more care in future to look into what we say in our tweets. Again we do apologise for any offense caused
https://twitter.com/celebboutique/status/226391854114037760— Celeb Boutique (@celebboutique)Fri, Jul 20 2012 19:03:18
- Some in the sports world are feeling a personal loss.
- Oh my god my friend jessica is gone
https://twitter.com/TheGoalieGuild/status/226299497163137024— The Goalie Guild (@TheGoalieGuild)Fri, Jul 20 2012 12:56:19
- Words are useless. Guns more so. If you ever had any interaction with @JessicaRedfield, you know the world is much worse off without her.
https://twitter.com/jessespector/status/226301459455692800— Jesse Spector (@jessespector)Fri, Jul 20 2012 13:04:07
- @JordanGhawi Jessica interned for us for a few months. She was a wonderful, bright, talented woman. If there is ANYTHING we can do, just ask
https://twitter.com/BurkieYCP/status/226338700471193600— Patrick Burke (@BurkieYCP)Fri, Jul 20 2012 15:32:06
- More response from athletes
- So u telling me I can't even feel safe at the movies now!!? SMH. My prayers goes out to all the families involved in Aurora, Colorado.
https://twitter.com/KingJames/status/226291198887858177— LeBron James (@KingJames)Fri, Jul 20 2012 12:23:20
- Its just not fair that innocent people have to lose their lives over someone's selfish stupidity acts! My stomach is hurting over this
https://twitter.com/KingJames/status/226292138240000000— LeBron James (@KingJames)Fri, Jul 20 2012 12:27:04
- My thoughts go out to the souls lost in Aurora Colorado last night. Not gonna lie. I am kinda nervous to go to the movies.
https://twitter.com/Hoya2aPacer/status/226343761393905666— Roy Hibbert (@Hoya2aPacer)Fri, Jul 20 2012 15:52:12
- Athletes react to Colorado theatre shootingA gunman opened fire on a crowded movie theatre Thursday night, killing twelve and wounding dozens more. Twitter quickly exploded with th...
- Chefs are also reacting to the news
- My heart and prayers go out to all the victims and families in Aurora, Colorado this morning.
https://twitter.com/Paula_Deen/status/226278949804711936— Paula Deen (@Paula_Deen)Fri, Jul 20 2012 11:34:40
Reaction to the Colorado theater shooting
Some tweets are pitch perfect, others rank a little insensitive.
byMichelle Maltais1 Like12,573 Views


text:
We recently looked at Castor, the second brightest star in Gemini and a fine multiple star. Not far away, you'll find the remnants of a dying star, the beautiful planetary nebula NGC 2392. This is one of the youngest-known planetary nebula– only 1,000 years old— and it's easily visible in a small telescope, even in city skies. In photographs, this nebula looks a bit like a clown's face; it also resembles the hooded face of a person wearing a parka, so it's sometimes called the "Eskimo Nebula"
The Basics
• The Clown Nebula lies just east of the "waist" of Gemini, near the 4th-magnitude star Wasat (which means "middle" in Arabic).
• The nebula lies within the same field of view as the 8th magnitude star HP36370. At low power, you might think these two objects are a double star. But increase magnification beyond 70-80x, and you'll notice the nebula is the one that looks "fuzzy" and a slightly green in color.
• The small size of the nebula means you can use a lot of magnification without dimming it too much.
NGC 2392 in Gemini (lower left, in cross-hairs)
Deeper View
• If you have a 6-8″ scope or larger, look for the central star of NGC 2392. This Sun-like star is puffing off its outer layers as it runs out of fuel in its core. In a few tens of thousands of years, the nebula will disappear and the star itself will become a hot and faint white dwarf.
• A UHC or OIII filter may improve the contrast of the nebula, especially if you're under urban or suburban skies. You'll likely not see the central star if you use the filter. Can you see any structure in the nebula? Perhaps an outer shell? You will not see the "Clown" or "Eskimo" visually.
Good To Know
The Hubble Space Telescope has taken some wonderful images of NGC 2392. The complexity of the glowing ionized gas near the center of the nebula defies explanation. In the outer part of the nebula, HST shows long orange filamentary structures, which may be large comet-like bodies interacting with material ejected from the central star. Here's a close-up of similar knots in the Helix Nebula.
Bonus Object
Point your scope just 2 degrees northeast of the Clown Nebula and you'll see the charming but overlooked open star cluster, NGC 2420. Use low power, certainly less than 40x, to see the full field of faint glittering stars. A very pleasant object.


text:
a new trio of high-def channels from Cox Communications, a new six-pack has found its way onto the on-deck circle. Based on an updated HD channel lineup for both of the aforementioned cities, residents can expect Sci-Fi HD (752), Lifetime HD (759), Bravo HD (763), CNBC (784), Weather Channel HD (785) and USA HD (732) to arrive in short order. Sadly, we're not sure exactly what day to expect the new half dozen, but hopefully "Coming Soon" is just hours (rather than days, weeks or months) away.
[Thanks, Philip]


text:
Reason behind general creepiness of Idol Master Home Avatars determined
They're masks! MASKS!!!
Were you creeped out by the Haruka Home avatar pictured at Gpara.com the other day?
So was I. But I've at long last finally figured out why this...
... ends up looking like this...
... when turned into a PlayStation Home avatar.
As revealed at the Idol Master official website yesterday, the Haruka avatar is actually...
[end_preview /]
... just a mask.
The Idol Master PlayStation Home content went live yesterday. I was busy writing about Dragon Quest IX delays and their effects on Final Fantasy XIII, so I haven't had a chance to check it out yet. And because I utterly despise Home, I probably won't ever check it out.
For those who are interested, the Home content for Idol Master, as detailed at the Idol Master site, includes Idol Master canned beverages that will be given away via the vending machines in the Bandai Namco virtual space. A few lucky (?) players will get, instead of beverages, Haruka masks, shirts, skirts, and boots... hopefully not all together because then you'd end up with the above.
The Idol Master site also reveals that Idol Master SP will support Ad-Hoc Party from day one. Players will be able to go through their PS3 in order to meet other Idol Master players, give clothing and accessory presents, and take part in competitive auditions. Now this is PS3 connectivity I can appreciate!


text:
Oscars Snubs and Surprises
This morning the Academy of Motion Picture Arts and Sciences announced the nominations for this year's Oscars. When it comes to snubs and surprises, there was plenty to go around. Still, the favorites hung in: Clooney for best actor, Streep for best actress, and "The Artist," "The Descendants" and "Hugo" was "Huge-o" for best picture with eleven nominations. - by Thelma Adams


text:
|Reviews for The Way I Loved You
| nkbhkjb chapter 1 . 1/19/2012
this is really good, i especially like the surfing ;)
you should definitely keep with this story.
| NightStalker97 chapter 1 . 12/26/2011
This is a good start! It's very detailed, which I like, so please, keep it up! :P
| sydneyyyhoover chapter 1 . 12/26/2011
This is really good! I am definately exctied to see more, if you want to update it (hope its not a one shot thing!). One part that really caught my attention was how you told us she was 17. Instead of coming right out and saying "I am seventeen years old," you made it so that she was explaining how she hates being called these names, and that she needs to start acting like the 17 year old she is. I love that! :)
Sorry my reviews pretty long! This is really good, hope you update it!
PS I love the suspense you leave with Tyler. You dont explain who he is, but give us breef details of who he is (i.e. paprazzi?);)


text:
Importing Phone Numbers And ContactsMay 15, 2007
How do i go about importing contacts - names, numbers, addresses that are in excel into Microsoft Outlook?View 2 Replies
How do i go about importing contacts - names, numbers, addresses that are in excel into Microsoft Outlook?View 2 Replies
I am using VBA to enter customer information into a Microsoft SQL database. I have an excel sheet with thousands of customers listed. I will be using a While loop to process each line of the sheet. Part of the While loop needs to make any format changes necessary before the data moves over to the DB. So here is the issue:
How do I turn the following phone numbers:
(410) 273-9200
276 623 4254
410 612 1100 Rob
(413) 786-1636 Cindy
304) 842-5491 Sherry
Into a uniform layout? I would prefer ###-###-####
Each of the numbers above is an example from the list I have. There may be more variations (I have over 20 seperate lists to process, with over 10000 customers per list)
I imagine I need some process that will remove all character except numbers and then break the numbers up to add the hyphens back in at the appropriate places.
I have a bunch of phone numbers that I'm trying to reformat.
Say I wanted to replace any phone number like this: 1##########
With this: ##########
Keeping the numbers intact, just getting rid of the 1 in front of them. Can't figure it out for the life of me.
Just got an answer to my phone number problem of converting two columns of numbers
to a single columns with the form XXX-XXXXXXX. Used =A1 & "-" & B1.
Works perfectly one one spread sheet and not at all in another.
When I enter the formula and hit return, instead of the correct result, all I get is the formula.
The format of the columns is the same on both spread sheets.
Formatting existing phone number. I want to remove first 2 digit from the column with 11 digit phone number ?View 1 Replies View Related
I came up with this formula trying to fix phone number but it's not working properly
=TEXT(LEFT(SUBSTITUTE(a1, "-", "") & "00##", 10), "###-###-00##")
So basically I need a formula or macro that will fix the phone number for me.
Here is an example
78512312 it should be like this 785-123-0012
785123123 it should be like this 785-123-0123. So if Len is 8 numbers long then insert two zeros counting from right to left. So if Len is 9 numbers long then insert one zeros counting from right to left.
I have thousands of phone numbers that hundreds of them are look like this:
123456-8 that means : 123456,123457,123458 or this
123456-57 that means : 123456,123457
There are not any standard of numbers after dash (-) in my data.
how can I expand them to new "rows"?
bob 123456-8 ->
bob 123456
bob 123457
bob 123458
I'm trying to simplified these numbers so each one only consists 8 numbers from the right w/out the blank space or +,-.
Tracking Number
Recip Phone
+65 9459 5540
6750 2518
I have an excel spreadsheet listing some company contacts i need to improve. At the moment the companies address and telephone number are in the same field c2 all the way down to c2120. I need to take the telephone and fax data out of the field and into column d for all the entries. The phone and fax details are in the cells as follows ....View 9 Replies View Related
I'm trying to format some cells, its some phone numbers but not in the traditional format (###) ###-####.
I need to get them to appear like this ###.###.####,
I have a column full of 10 digit pone numbers. All different numbers and many different area codes (No dashes):
Is there a way to remove the three leading numbers from all of the numbers at once for the whole column?
I have a list of mobile phone numbers from various countries. However, I do not know which country each entry is from. Ideally I would like to have a macro that looks at each number, compares to a global list of PSTN structure to determine which part of the phone number is the country code (generally the first 1-3 digits), and then put the country in a separate column.
I am certain all numbers are formatted correctly, so it is only a matter of finding out which part is the country code and putting a value for the country.
How can I use the RAND function to generate a list of simulated phone numbers.View 9 Replies View Related
I'm trying to change a
format cell to a regular phone number cell
I have a list of mobile phone numbers from various countries. However, I do not know which country each entry is from. Ideally I would like to have a macro that looks at each number, compares to a global list of PSTN structure to determine which part of the phone number is the country code (generally the first 1-3 digits), and then put the country in a separate column.
I am certain all numbers are formatted correctly, so it is only a matter of finding out which part is the country code and putting a value for the country.
I have a large list of phone numbers & some of the numbers do not have area codes. The area code is the same for all numbers. Is there a way to add the area codes to all of these numbers without keying all in manuallyView 9 Replies View Related
How can I create a vlookup function to automatically retrieve phone numbers off switchboard.com using my current mailing list?
I have a list of more than 4,000 of my customers. I want to ad in phone numbers automatically. I currently have the first and last name in one column. The address, city, state and zip are all each in their own column.
I have never use vlookup before, nor have I ever used excel other than for data entry. What is the easiest and most efficient way to do this?
I searched this site and seen vlookup mentioned for this type of automatic data entry. There may be another way or method I am not aware of.
I am looking for a formula to count the number of valid mobile phone numbers in a list and the number of valid email address in another list, 2 different formulas.
The mobile phone number formula would count the number of indervidual mobile phone numbers in a list that contain 077 and 078 and 079.
The email formula would count the number of indervidual email addresses in a list that contain ...........@..........dot com or .............@............dot co dot uk
Both lists may contain random junk text, like in the email list some one may have entered words like 'no email address' etc.
I have several text boxes on a 'picture' which is the format for a business review. The text boxes are linked to cells behind the picture which picks up company names, cities etc...
Two of the boxes have a phone# and date
The linked cells are formatted correctly but obviously the text boxes, pick up the 'values' not the formats.
is there any way for the textboxes to show the values with the proper format i.e.,
mmm yyyy
I have to take a range of phone numbers that I have to port from another carrier and manually type them out or copy into another speadsheet, removing duplicate numbers. For example, I have the following numbers:
The results on the next spreadsheet need to be:
I am looking for a way to automate this process.
I have a spreadsheet with Mobile phone numbers in the following format:
+44(0)77 7296 5210
The spreadsheet has 2500 of these phone numbers.
Is there a way to remove the brackets and the +44 to leave:
I am using Microsoft Office for Mac 2011
I've read a lot of tutorials on how to use pivot tables, but found them either too basic, or too advanced, and never finding any example of what I am looking to do.
I have a database, column A holds names, and column B their phone numbers. I'd like to generate a list of unique names and their associated telephone numbers. I figure I can use a pivot table to do this.
But I do not quite understand how to format the pivot table to put the name in one column and the phone number in the next. I will use this pivot table as a vlookup range. I assume I can do this.
I am creating a spreadsheet for use in a manufacturing environment to create a costing and cut list spreadsheet for production set up. The intent is that anyone can use this by copying and pasting an Excel Bill Of Material (BOM) that is generated out of a CAD program onto sheet 1. On sheet 2 (which they don't touch) is the costing and cut list spreadsheet that references sheet 1 and automatically generated the numbers to create cut sizes and costs.
The first challenge I had was that the measurements include the inch symbol. For example if the imported text 15 5/8" is in cell A1 I am able to remove the inch symbol by using the following formula on sheet 2: =--LEFT(Sheet1!A1,LEN(Sheet1!A1)-1). The result is: 15.6250 which is exactly what I want.
Here is the problem I am having. When the listed dimension is less than 1" and is 5/8" for example I get ###### because I have the cell formatted as a 4 decimal place number. If I change the formatting to number with zero decimal places it becomes 39941 which is how many days it has been from January 1, 1900 to May 8, 2009.
The question is what formula should I use to change the 5/8" imported text so it says 0.6250 and can be used in math formulas? Please keep in mind that the imported text could be a measurement with a small number like 1/16" to a large one such as 284 3/4" and that the imported text "is what it is" and cannot be manually changed or adjusted (because that presents the risk of people creating errors and costing the company money by ordering the wrong material sizes).
I'm pulling phone numbers out of text strings. There is text string ("Office:") indicating that the number following is an office number (the number that I need). MID and FIND take care of this. There are sometimes two instances of office numbers in single text string, so adding a second column using the third argument of FIND lets me start another search past the first instance of an office number. We have a bunch of office numbers with the qualifier "(Text)" after the original "Office" but before the phone number. How do I catch these ones?View 8 Replies View Related
Imported contacts to appear in Autocomplete?View 1 Replies View Related
I have a workbook with a list of new contacts in one sheet, and a list of old contacts on another sheet.
I want to run a duplicate check throughout the workbook to highlight and delete any contacts on my new list, that have already been contacted on my old list.
Also, I need the the duplicate checker to check for non specific names, regardless of punctuation, upper/lower case, etc.
I need to to highlight all of the following variations as possible duplicates which i can then review & delete manually;
Apple Corp,
Apple Ltd
What I can use to do this?
I am trying to merge my boss's contacts. He has one enormous set of contacts in GMail (5000+) and one enormous set of contacts in Excel (5000+) I've exported both sets into excel but how to I merge them?
The headers for each set are in a slightly different order (Home Address, Office Address, Email ...vs.....Office Address, Home Address, Email) Do I need to make sure the order of the headers match in both the GMail Sheet and the Outlook Sheet and is there a faster way to do that than just rearranging them manually?
My second question is how do I merge them? There are a lot of over-laps of people but some info might be different in Outlook than in GMail. For example I might have John Smith as a contact in both Gmail and Outlook but two different email addresses for him under the header "Email 1" how do I make sure one email doesn't eliminate the other? I just want to merge both sets of contact info for each person into one super contact.
I would like to ask about How to Tranpose mulltiple contacts from one row.
Company1Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3Company2Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3
result need to be.
Client Id Contact No. Unique Contacts 111123 12 3 111123 12 3 221123 2 2 111123 34 3 111123 5 3 221123 1 2 821123 4 1 221123 2 2
I am trying to calculate the number of unique contacts that each client has made. So in the example above Client No. 111123 has made 3 unique contacts - numbers 12,34 and 5.
However I'm not having any luck - as I suspect it will be a fiendish array formulae. Alternatively I'd settle for some VBA.
I have been trying to use VB to send contacts from contacts.xls to outlook. I have some code from MSDN that shows me how to put in ONE contact (which is already declared in the code). Well I was thinking of writing something to take a worksheet that has x number of contacts and automating x number of contacts. The problem is, I am familiar with using SQL to pull records, but I was thinking there was something easier like importing the excel namespace. So I decided to try it out this way and found this little tidbit of code which is:
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlApp = New Excel.Application
xlApp.Visible = False
xlBook = xlApp.Workbooks.Open("contacts.xls")
xlSheet = xlBook.Worksheets(1)
Dim pXLRange As Object
pXLRange = xlSheet.UsedRange
Dim i = 0
Dim j = 0
For i = 1 To UBound(pXLRange, 1)
For j = 1 To UBound(pXLRange, 2)
Debug.Print(pXLRange(i, j))
It gives me this error for the FOR i=1 to UBound line:
Unable to cast COM object of type 'System.__ComObject' to class type 'System. Array'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.
here's the namespaces i have imported:
Imports Outlook = Microsoft.Office.Interop.Outlook
Imports System.Reflection
Imports System.Data.OleDb
Imports Excel = Microsoft.Office.Interop.Excel


text:
Related publications
The London Accord 2007 - a compendium of 24 reports which set out the context for investments in climate change solutions, analyse individual opportunities and discuss the implications for the construction of investment portfolios.
Jim Reid, Nick Burns
Research organisation
Download the report
LT Asset Return Study: A Journey into the Unknown
Report Date
September 2012
Release Date
September 2012
Document summary
Economic history has been very helpful in trying to be one step ahead of the developed market's bubbles over the last decade or so. Deutsche Bank considers that economics and finance are now journeying steadily into the unknown. While past economic history has provided an understanding the state of the world, many variables are now outside any previous historical observations. A central theme is how many economic and financial variables are at levels unique to this cycle, even if the analysis is extended back centuries. This must surely reduce confidence levels in the predicting the future to fairly low levels.


text:
Faux Marble Painted Floors
Last week I wrote about painted linoleum floors in a Brooklyn rental, which anyone could do in a weekend. This week I return to a project I did a few years ago, which required repair post water damage and is much more complex in its scale and development.
I never really had good photographs of this after so many computer crashes, and it was fun to revisit it in person. The repeat is based on the classical patterns of Romans--they, the masters of Art and Design. I know I took it from my travel photos, and it could easily be from a floor or a coffered ceiling.
Colorwise, I have a list of what we used, but half of it is from Janovic and I haven't used their paint in years. But it's blues and greys and blacks and browns, and if I have one regret, it's that the one center grey that looks slightly sea foam green, I wish it was warmer. And remember, the thing that distinguishes floor paint from wall paint is that it's slightly pliable, though for thin glazes it hardly matters.
About the marbling--I never liked faux marbre until I started playing with it myself--it always seemed liked one bland, crafty thing. To do it well, you must approach your project like an artist, with a beginning, middle and an end; you have to be extremely Zen and delicate; you should be light of touch and transparent in your glazes. Technically, you're applying darks and lights with sea sponges and turkey feathers, and I find that I'm taking up as much paint as I put down with the sea sponge as I go. In this project I tried in different veining in each color, though I'm not sure that's evident in these pix. As Obi Wan said, "Use your feelings, Luke!"
(Images: Mark Chamberlain