David, Here's the information for the Portland database: Machine name: napdx-sql1 user id: gasintranet password: fundamentals The Access database I created is located at: O:\fundy_ops\west desk\generation database\power_link_database.mdb The qry_curtailments is the query i'm currently using (although it only has fields for today and yesterday, and i think i need more). The tables for the query are dbo_LkpOUT_PlantCharacteristics and dbo_LkpOUT_PlantOutage. In general, I think I need two tables. One needs to show each plant and the other needs to summarize the outages by region and fuel type (both in the Plant table). I don't really have a query that prepares the data for the summary table. the other two queries in the Access database are a start. The attached Excel file has two sheets with what I would ideally like the report to look like. It might be good to group the first table by region and then fuel type as well. When you have a chance to look this stuff over, I'd be happy to discuss it further. Thanks. Mat
Answer: Portland Database
All, The RUNM application will be changed in the near future. We urge all the users to please test the application by typing the following: runmm - to run it in production runmt - to run it in egstest runmd - to run it in egsdevel Please note that runm will eventually be replaced by runmm. If you have any further questions or queries, please do not hesitate to contact me at x57252 or Francis Lim at x35906. Thank you so much for your cooperation and support. Regards,
Answer: RUNM changes
Just wanting to verify that we are going to continue the "funky" way of booking gas daily deals (ie 2 legs and 4 legs). Please advice before I begin testing the logic. Dawn
Answer: Gas Daily Deals
Per our phone conversation this morning..... I know you are well aware of these happenings (Southern Trails disappointing CPUC decision and the KMI Sonoran pipeline to California) but I thought these two articles were timely. Since it sounds like the Southern Trails gas is getting stranded wouldn't it be great if we could give KMI some competion for the new Power Plant being proposed in the four corners area. Southern Trails might be willing to offload some of the system cheap following the outcome of the CPUC decision. You may or may not be aware, but TW was working with D. Hawkins at providing operating services of this Souther Trails system for Questar so we have pretty good info. on the Questar system (or Don does I would guess). Anyhow, I know the Southern Trails system has to be in close proximity to this proposed power plant. (If I am driving you nuts with this junk mail Kim, please let me know.) Southern Trails Disappointed by CPUC Decision; Decision Discourages Development of New Natural Gas Pipeline Capacity SALT LAKE CITY, Aug. 8 /PRNewswire/ -- Officials from Questar Southern Trails
Answer:
Southern Trails/Regent Power Plant