24 resultados para spreadsheet
em Iowa Publications Online (IPO) - State Library, State of Iowa (Iowa), United States
Resumo:
This project demonstrated the capabilities for load testing bridges in Iowa, developed and presented a webinar to local and state engineers, and produced a spreadsheet and benefit evaluation matrix that others can use to preliminarily assess where bridge testing may be economically feasible given truck traffic and detour lengths.
Resumo:
This report presents the results of work zone field data analyzed on interstate highways in Missouri to determine the mean breakdown and queue-discharge flow rates as measures of capacity. Several days of traffic data collected at a work zone near Pacific, Missouri with a speed limit of 50 mph were analyzed in both the eastbound and westbound directions. As a result, a total of eleven breakdown events were identified using average speed profiles. The traffic flows prior to and after the onset of congestion were studied. Breakdown flow rates ranged between 1194 to 1404 vphpl, with an average of 1295 vphpl, and a mean queue discharge rate of 1072 vphpl was determined. Mean queue discharge, as used by the Highway Capacity Manual 2000 (HCM), in terms of pcphpl was found to be 1199, well below the HCM’s average capacity of 1600 pcphpl. This reduced capacity found at the site is attributable mainly to narrower lane width and higher percentage of heavy vehicles, around 25%, in the traffic stream. The difference found between mean breakdown flow (1295 vphpl) and queue-discharge flow (1072 vphpl) has been observed widely, and is due to reduced traffic flow once traffic breaks down and queues start to form. The Missouri DOT currently uses a spreadsheet for work zone planning applications that assumes the same values of breakdown and mean queue discharge flow rates. This study proposes that breakdown flow rates should be used to forecast the onset of congestion, whereas mean queue discharge flow rates should be used to estimate delays under congested conditions. Hence, it is recommended that the spreadsheet be refined accordingly.
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
Researchers should continuously ask how to improve the models we rely on to make financial decisions in terms of the planning, design, construction, and maintenance of roadways. This project presents an alternative tool that will supplement local decision making but maintain a full appreciation of the complexity and sophistication of today’s regional model and local traffic impact study methodologies. This alternative method is tailored to the desires of local agencies, which requested a better, faster, and easier way to evaluate land uses and their impact on future traffic demands at the sub-area or project corridor levels. A particular emphasis was placed on scenario planning for currently undeveloped areas. The scenario planning tool was developed using actual land use and roadway information for the communities of Johnston and West Des Moines, Iowa. Both communities used the output from this process to make regular decisions regarding infrastructure investment, design, and land use planning. The City of Johnston case study included forecasting future traffic for the western portion of the city within a 2,600-acre area, which included 42 intersections. The City of West Des Moines case study included forecasting future traffic for the city’s western growth area covering over 30,000 acres and 331 intersections. Both studies included forecasting a.m. and p.m. peak-hour traffic volumes based upon a variety of different land use scenarios. The tool developed took goegraphic information system (GIS)-based parcel and roadway information, converted the data into a graphical spreadsheet tool, allowed the user to conduct trip generation, distribution, and assignment, and then to automatically convert the data into a Synchro roadway network which allows for capacity analysis and visualization. The operational delay outputs were converted back into a GIS thematic format for contrast and further scenario planning. This project has laid the groundwork for improving both planning and civil transportation decision making at the sub-regional, super-project level.
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
Multiplan spreadsheet solutions were developed for a set of hydraulic and highway engineering computations of common interest to county engineers. These include earthwork, vertical and horizontal curves, staking superelevated curves and sign inventories for highways. The hydraulic applications were ditch flow, runoff, culvert size and stage discharge.
Resumo:
This report contains an evaluation and design manual for strengthening and replacing low volume steel stringer and timber stringer bridges. An advisory panel consisting of county and municipal engineers provided direction for the development of the manual. NBI bridge data, along with results from questionnaires sent to county and municipal engineers were used to formulate the manual. Types of structures shown to have the greatest need for cost-effective strengthening methods are steel stringer and timber stringer bridges. Procedures for strengthening these two types of structures have been developed. Various types of replacement bridges have also been included so that the most cost effective solution for a deficient bridge may be obtained. The key results of this study is an extensive compilation, which can be used by county engineers, of the most effective techniques for strengthening deficient existing bridges. The replacement bridge types included have been used in numerous low volume applications in surrounding states, as well as in Iowa. An economic analysis for determining the cost-effectiveness of the various strengthening methods and replacement bridges is also an important part of the manual. Microcomputer spreadsheet software for several of the strengthening methods, types of replacement bridges and for the economic analysis has been developed, documented and presented in the manual. So the manual, Chp. 3 of the final report, can be easily located, blue divider pages have been inserted to delineate the manual from the rest of the report.
Resumo:
The need to upgrade understrength bridges in the United States has been well documented in the literature. The concept of strengthening steel stringer bridges in Iowa has been developed through several Iowa DOT projects. The objective of the project described in this report was to investigate the use of one such strengthening system on a three-span continuous steel stringer bridge in the field. In addition, a design methodology was developed to assist bridge engineers with designing a strengthening system to obtain the desired stress reductions. The bridge selected for strengthening was in Cerro Gordo County near Mason City, Iowa on County Road B65. The strengthening system was designed to remove overstresses that occurred when the bridge was subjected to Iowa legal loads. A two part strengthening system was used: post-tensioning the positive moment regions of all the stringers and superimposed trusses in the negative moment regions of the two exterior stringers at the two piers. The strengthening system was installed in the summers of 1992 and 1993. In the summer of 1993, the bridge was load tested before and after the strengthening system was activated. The load test results indicate that the strengthening system was effective in reducing the overstress in both the negative and positive regions of the stringers. The design methodology that was developed includes a procedure for determining the magnitude of post-tensioning and truss forces required to strengthen a given bridge. This method utilizes moment and force fractions to determine the distribution of strengthening axial forces and moments throughout the bridge. Finite element analysis and experimental results were used in the formulation and calibration of the methodology. A spreadsheet was developed to facilitate the calculation of these required strengthening forces.
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/