6 resultados para EXCEL
em Iowa Publications Online (IPO) - State Library, State of Iowa (Iowa), United States
Resumo:
Provide an outstanding educational program that enables our graduates to become leaders in their professions by imparting fundamental principles, skills, and tools to innovate and excel. Pursue the discovery of fundamental knowledge and its applications to position the department among the leaders in research. Respond to the needs of the State of Iowa and the nation by building a strong outreach program that serves industry and the engineering profession.
Resumo:
Provide an outstanding educational program that enables our graduates to become leaders in their professions by imparting fundamental principles, skills, and tools to innovate and excel. Pursue the discovery of fundamental knowledge and its applications to position the department among the leaders in research. Respond to the needs of the State of Iowa and the nation by building a strong outreach program that serves industry and the engineering profession.
Resumo:
Iowa’s infrastructure is at a crossroads. A stalwart collection of Iowans dared to consider Iowa’s future economy, the way ahead for future generations, and what infrastructure will be required – and what will not be required – for Iowa to excel. The findings are full of opportunity and challenge. The Infrastructure Plan for Iowa’s Future Economy: A Strategic Direction tells the story and points the way to a strong economy and quality of life for our children and our children’s children. This plan is different from most in that the motivation for its development came not from a requirement to comply or achieve a particular milestone, but, rather, from a recognition that infrastructure, in order to ensure a globally-competitive future economy, must transform from that of past generations. It is not news that all infrastructure – from our rich soil to our bridges – is a challenge to maintain. Prior to the natural disasters of 2008 and the national economic crisis, Iowa was tested in its capacity to sustain not only the infrastructure, but to anticipate future needs. It is imperative that wise investments and planning guide Iowa’s infrastructure development. This plan reflects Iowa’s collective assessment of its infrastructure– buildings, energy, natural resources, telecommunications, and transportation – as, literally, interdependent building blocks of our future. Over the months of planning, more than 200 Iowans participated as part of committees, a task force, or in community meetings. The plan is for all of Iowa, reflected in private, nonprofit, and public interests and involvement throughout the process. Iowa’s success depends on all of Iowa, in all sectors and interests, to engage in its implementation. The Infrastructure Plan for Iowa’s Future Economy: A Strategic Direction sets a clear and bold direction for all stakeholders, making it clear all have a responsibility and an opportunity to contribute to Iowa’s success.
Resumo:
We compute the fertilizer use in corn, cotton, soybeans, and rapeseed in the period from 1990 to 2010 for a set of selected countries. In each case, we present the consumption of nitrogen, phosphate, and potash by crop and by year, reporting both the fertilizer application rates (in kilograms per hectare) and the fertilizer consumption (in thousand metric tonnes). We allocate a country’s total nutrient consumption in a given year among competing crops based on publicly available statistics. The resulting allocation of fertilizer among crops is a function of the country’s nutrients total use, the country’s cropped areas, crop world prices, and crop- and country-specific fertilizer application rates for some years. In this report we show results on fertilizer consumption by crop for the top fertilizer consuming countries, and a downloadable MS Excel file “FertilizerDemandByCropData.xls” shows the complete set of results.
Resumo:
The goal of this project was to provide an objective methodology to support public agencies and railroads in making decisions related to consolidation of at-grade rail-highway crossings. The project team developed a weighted-index method and accompanying Microsoft Excel spreadsheet based tool to help evaluate and prioritize all public highway-rail grade crossings systematically from a possible consolidation impact perspective. Factors identified by stakeholders as critical were traffic volume, heavy-truck traffic volume, proximity to emergency medical services, proximity to schools, road system, and out-of-distance travel. Given the inherent differences between urban and rural locations, factors were considered, and weighted, differently, based on crossing location. Application of a weighted-index method allowed for all factors of interest to be included and for these factors to be ranked independently, as well as weighted according to stakeholder priorities, to create a single index. If priorities change, this approach also allows for factors and weights to be adjusted. The prioritization generated by this approach may be used to convey the need and opportunity for crossing consolidation to decision makers and stakeholders. It may also be used to quickly investigate the feasibility of a possible consolidation. Independently computed crossing risk and relative impact of consolidation may be integrated and compared to develop the most appropriate treatment strategies or alternatives for a highway-rail grade crossing. A crossing with limited- or low-consolidation impact but a high safety risk may be a prime candidate for consolidation. Similarly, a crossing with potentially high-consolidation impact as well as high risk may be an excellent candidate for crossing improvements or grade separation. The results of the highway-rail grade crossing prioritization represent a consistent and quantitative, yet preliminary, assessment. The results may serve as the foundation for more rigorous or detailed analysis and feasibility studies. Other pertinent site-specific factors, such as safety, maintenance costs, economic impacts, and location-specific access and characteristics should be considered.
Resumo:
Most local agencies in Iowa currently make their pavement treatment decisions based on their limited experience due primarily to lack of a systematic decision-making framework and a decision-aid tool. The lack of objective condition assessment data of agency pavements also contributes to this problem. This study developed a systematic pavement treatment selection framework for local agencies to assist them in selecting the most appropriate treatment and to help justify their maintenance and rehabilitation decisions. The framework is based on an extensive literature review of the various pavement treatment techniques in terms of their technical applicability and limitations, meaningful practices of neighboring states, and the results of a survey of local agencies. The treatment selection framework involves three different steps: pavement condition assessment, selection of technically feasible treatments using decision trees, and selection of the most appropriate treatment considering the return-on-investment (ROI) and other non-economic factors. An Excel-based spreadsheet tool that automates the treatment selection framework was also developed, along with a standalone user guide for the tool. The Pavement Treatment Selection Tool (PTST) for Local Agencies allows users to enter the severity and extent levels of existing distresses and then, recommends a set of technically feasible treatments. The tool also evaluates the ROI of each feasible treatment and, if necessary, it can also evaluate the non-economic value of each treatment option to help determine the most appropriate treatment for the pavement. It is expected that the framework and tool will help local agencies improve their pavement asset management practices significantly and make better economic and defensible decisions on pavement treatment selection.