Free Essay

Vba Research Paper

In:

Submitted By yaosiyue
Words 1906
Pages 8
How to access VBA in excel 2013:
Excel option—quickaccess toolbar—customized ribbonr—developer or just alt+F11
How to access VBA in excel 2013:
Excel option—quickaccess toolbar—customized ribbonr—developer or just alt+F11
VBA
1. VBA format:
a. upper left corner: project: * Automatically created when create a new workbook * Only one project per workbook * Can contain on or more modules; modules are VBA codes, which is separated into macros or procedure; macro is a set of instructions for the computer written in VBA, which is text readable.
2. Reason why create macros is to manipulate data in workbook environment
3. Programming language:
Sub myfirstmacro()

Commentary will automatically be green
Commentary will automatically be green
‘my first macro
‘This is commentary

Sheets(”Sheet 1”). Select
Range (“A3”).Select
ActiveCell. Value = 5
Sheets(“Sheet 1”). Select
Range (“B2). Select
ActiveCell. Value=62

End Sub
4. Variables:
Ex1: a=a+1, if a = 5, a now is 6. Previous value of a is not existed any more.
Ex2: c= “hi all!”. Words must be included in quotation mark.
Ex3: d=c&”Bye!” comes to hi all!bye!
a. variable names: * Must begin with a letter * Only can be letters, numbers and underscores * <=255 characters * Cannot be special reserved word like print or save

5.programming language2
Sub mathfun()
Sheets("sheet1").Select
Range("B3").Select a = ActiveCell.Value
Range("B4").Select
Summy is variable of sum of numbers; divvy is variable of division
Summy is variable of sum of numbers; divvy is variable of division b = ActiveCell.Value
Range("B5").Select
c = ActiveCell.Value summy = a + b divvy = b / c

Range("A7").Select
ActiveCell.Value = summy
Range("A8").Select
ActiveCell.Value = divvy
6.If wanna change value of variables, just need to change value and run macros. But in order to be more user friendly, better to create a run button on the worksheet not only in the VBA. Process is developer---insert----button(1st in form control)
7. message box: to deliver messages directly to the user by MsgBox function through a pop window
8. input box: obtain data from user through a pop up window
a. input a string(text):var=inputbox(text)
b.input a number:var=val(inputbox(text))
9.Relative reference * Activecell.offset(4,-2).select: means move 4 rows downward and 2 columns to the left. * All we did before of programming language is absolute reference. They only can be one box. However, if have relative reference, all distance is relative to original active cell, which is without offset function. * Programming language:
Sub info()
ActiveCell.Value = "VBA is fun."
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = "seriously."

ActiveCell.Offset(1, 1).Select
ActiveCell.Value = 100

ActiveCell.Offset(-1, 1).Select
ActiveCell.Value = 2.134

End Sub
10.recording macros:
Step1: developer--- use relative reference(optional)---record macros---ctrl+p
Step 2:record data---stop recording---clear content---ctrl+p
Step3: if want to have a look at programming:macros---edit
We can see the programming language like:
'
' Keyboard Shortcut: Ctrl+q
'
ActiveCell.Select ActiveCell.FormulaR1C1 = "x" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "0" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "1" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "2" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "3" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "4" ActiveCell.Offset(-5, 1).Range("A1").Select ActiveCell.FormulaR1C1 = "sin(x)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=SIN(RC[-1])" ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range("A1:A5"), Type:= _ xlFillDefault ActiveCell.Range("A1:A5").Select ActiveCell.Offset(1, 1).Range("A1").Select
End Sub
11.making better use of space:
a. multiple statement on the same line: a=34: b=a+3: c=a*b
b. continue statement on the next line: h=3+4^2/2_ +10*2
12. Data type in VBA:
a. 4 types of data type: Double(can have points), integer(no points), string(characters), Boolean(T/F)
b. recommend use option explicit: force you to declare all variables in your program
Sub main()
Double means only numbers & string means characters
Double means only numbers & string means characters
Dim height as Double, y as String
Height =5
Y=”I like pizza!”
End Sub
c. can make automatically use option explicit at the beginning:--tools---options---click require variable declaration
13. Constant variable
Can’t change constant variable value anymore
Can’t change constant variable value anymore
Option Explict
Sub main()
Dim v as Double, v0 as double, t as double
Const g as double=9.81
V0=0
t=2 v=v0-g*t MsgBox “ The velocity is “ & v & “m/s”
End sub
14. built in function:
a. sqr(): square root
b. abs(): absolute value
c.MsgBox string: create a message box display to user
d. inputbox(message to user): to obtain input from user( need them to type sth only can be characters)
e. Val(string): often used with input box to want user enter numerical value in input box
15. Introduction of sub procedure:
a. modular programming: -sub procedure(called macro); -function procedure
b.exit sub:means terminate procedure in advance. Every statement after exit sub will not be executed.
Num1 in math and num in calcdp are linked together
Num1 in math and num in calcdp are linked together
c. the # of arguments in sub procedure should be same as the # of argument in call procedure. Call subname means variables in bracket in math
Call subname means variables in bracket in math
16. Example 1 of calling a sub procedure Option Explicit Sub math() Dim num1 As Double, num2 As Double Dim diff As Double, prod As Double Sheets("sheet1").Select Range("B2").Select: num1 = ActiveCell.Value ActiveCell.Offset(1, 0).Select: num2 = ActiveCell.Value MsgBox num1 & " " & num2 & " " & diff & " " & prod diff = num1 - num2 Occurs 2 message boxes and 2 values appears on worksheet, which are the last 2 columns.
Occurs 2 message boxes and 2 values appears on worksheet, which are the last 2 columns. prod = num1 * num2 MsgBox num1 & " " & num2 & " " & diff & " " & prod ActiveCell.Offset(2, 0).Select: ActiveCell.Value = diff ActiveCell.Offset(1, 0).Select: ActiveCell.Value = prod End Sub 17. Example 2 of calling a sub procedure: Option Explicit Sub math() Dim num1 As Double, num2 As Double Dim diff As Double, prod As Double Sheets("Sheet1").Select Range("B2").Select: num1 = ActiveCell.Value ActiveCell.Offset(1, 0).Select: num2 = ActiveCell.Value MsgBox num1 & " " & num2 & " " & diff & " " & prod Call calcdp(num1, num2, diff, prod) MsgBox num1 & " " & num2 & " " & diff & " " & prod ActiveCell.Offset(2, 0).Select: ActiveCell.Value = diff ActiveCell.Offset(1, 0).Select: ActiveCell.Value = prod Sub procedure is acted prior to cll procedure;any change to sub argument 1 will affect argument 1 in math(call)
Sub procedure is acted prior to cll procedure;any change to sub argument 1 will affect argument 1 in math(call)

End Sub Sub calcdp(num1, num2, diff, prod) diff = num1 - num2 prod = num1 * num2 End Sub 18.example of reusing sub procedure(call the same sub procedure multiple times): Option Explicit Sub main() Dim a As Double, b As Double, x As Double, y As Double a = 1: b = 2: x = 5: y = 6 MsgBox "a=" & a & ", b =" & b & ", x = " & x & ", y = " & y If n changes in addy, b will be affected in main. Name is decided by sub not call
If n changes in addy, b will be affected in main. Name is decided by sub not call
Call addy(a, b) MsgBox "a=" & a & ", b =" & b & ", x = " & x & ", y = " & y Call addy(x, y) MsgBox "a=" & a & ", b =" & b & ", x = " & x & ", y = " & y End Sub Variable inside argument list is automatically declared when sub procedure begins(m,n give same data type as a b in call), but answer need to declare
Variable inside argument list is automatically declared when sub procedure begins(m,n give same data type as a b in call), but answer need to declare

Sub addy(m, n) Dim answer As Double answer = m + n MsgBox " The sum of " & m & "+" & n & " = " & answer m = 900 End Sub **msgbox happening orders: 1st : 1st sub procedure’s msgbox 2nd: 2nd sub procedure’s msgbox 3rd: 1st call procedure’s msgbox 4th: 2nd call procedure’s msgbox(variable changed still remain here, ex a=900 same in the 4th msgbox. 19. variable scope and lifetime a. projectprocedurevariable (variables are all locally defined, which means only in one procedure) b.example: Option Explicit Call subby halts and waits for sub subby to finishi before continuing in main
Call subby halts and waits for sub subby to finishi before continuing in main
Sub main() Dim a As Double, b As Double, x As Double, y As Double a = 1: b = 2: x = 5: y = 6 MsgBox "before subby: " & a & " " & b & " " & x & " " & y Call subby(a, b, x, y) MsgBox "after subby: " & a & " " & b & " " & x & " " & y End Sub Sub subby(m, n, a, b) Variables a and b in main not linked to var a and b in subby(not correct order);also,in subby,we use 2 additional var x and y, default zero,if x and y changes, no affect to call subby.
Variables a and b in main not linked to var a and b in subby(not correct order);also,in subby,we use 2 additional var x and y, default zero,if x and y changes, no affect to call subby.
Dim x As Double, y As Double MsgBox "start of subby:" & a & " " & b & " " & x & " " & y m = 15: n = 40: a = 100: b = 200: x = 0.1: y = 0.2 MsgBox "end of subb:" & a & " " & b & " " & x & " " & y End Sub **total 10 variables: 4 var in sub procedure and 6 in sub procedure 2. And (abxy) is linked with (mnab); advice: when working through program, write down all variables. When one sub procedure ends, all vars end too. Final result:before subby 1256; start of subby 5600; end of subby 100 200 0.1 0.2; after subby:15 40 100 200. 20. passing by reference vs passing by values. a. passing by reference call changeval(a,b,c,d) sub changeval(w,x,y,z) d in main and z in changeval refer to the same location in memory b. passing by values: call cangeval((a),b,(c),d) sub changeval(w,x,y,z) It means only the value of a and c in main passed to var w and y, not all reference. Therefore, any changes in w and y won’t effect a and c in call. **Comparision: passing by vaue allows information to flow in one direction only;passing by reference means you allow the sub procedure to modify argument(two direcitons) 21. sub procedure vs function procedure: Sub has call statement but function doesn’t. And sub doesn’t return a value to the location where it is invoked. But every sub procedure can be completed in function procedure.

Similar Documents

Premium Essay

Paperless Environment

...Part 1 Final Project “Will a paperless environment improve the Veterans Benefit Processing?” Timberly M Williams Kaplan University GM505 Action Research and Consulting Skills Professor Dr. Barbara-Leigh Tonelli 08/20/2013 Part One of Final Project This paper explains the benefits of a paperless environment within the Department of Veteran Affairs. Here I will research all of the positive and negative benefits on how this process will help eliminate Veterans wait time on benefit approval. Scope and Purpose VBA is responding to the significant expansion in the scope and complexity of its mission. While VA completed a record-breaking 1 million claims per year over the past three years, the number of claims received continues to exceed the number processed and the backlog of claims has grown. In response, VA is implementing a comprehensive Transformation plan—a series of people, process and technology initiatives—to increase productivity and accuracy of disability claims processing. Once the Transformation is fully implemented, VA expects to systematically reduce the backlog and reach its 2015 goal - to eliminate the claims backlog and process all claims within 125 days with 98 percent accuracy. | VBA Compensation Benefits There are currently 3.9 million Veterans receiving disability benefits from VA. In the past four years, VA has added more than 940,000 Veterans to the VA compensation rolls, more than the active duty Army and Navy combined. In fiscal year 2012...

Words: 1831 - Pages: 8

Premium Essay

Super Man

...CD-ROM Included! “John Walkenbach’s writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won’t find a more comprehensive book on Excel 2010 than this!” —Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com • Searchable PDF of the book • Understand functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 ...

Words: 167105 - Pages: 669

Premium Essay

Exel 2010 Formulas

...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...

Words: 49651 - Pages: 199

Free Essay

Department of Veterans Affairs

...Iraqi Freedom and several other operations. However, when I left the Service it became clear to me years later that Veterans Affairs weren’t ready to treat our Men and Women coming back from War. So I did some extensive research on how the system may have failed the people it was supposed to serve. And a good example of the system’s failure was the second Fort Hood incident in 2014. Keywords: Veterans Affairs, Fort Hood, Service The Department of Veterans Affairs Information Management System: Serving those that Served The reason why I chose this subject is because it is close to home and it also affects me. After two weeks of this class I wanted to dive deep into information management. I want to know why our system at the Department of Veterans Affairs do not stand ready to serve the Veteran population of our Nation properly. So many Veterans complain about loss or insufficient pensions because the VA hasn’t track them sufficiently. Sitting at Veterans Hospital in Orlando, FL I hear two Vietnam era Veterans talk about not having VA ID Cards. And they have been waiting for it since 2009. I asked them why it took this long, and they said, “The system was backlogged”, or at least that’s what the VA told them and this was back in 2009. So the premise of this paper is really for me to uncover answers to three major Questions that I personally have: 1. How long is the integration process as far as Service Member transitioning from Active Duty to Veteran status in order for their...

Words: 1987 - Pages: 8

Premium Essay

Vu Doc

...M Finance Vrije Universiteit Amsterdam - Fac. der Economische Wet. en Bedrijfsk. - M Finance - 2012-2013 Vrije Universiteit Amsterdam - Fac. der Economische Wet. en Bedrijfsk. - M Finance - 2012-2013 I Inhoudsopgave Vak: Institutional Investments and ALM Vak: Valuation and Corporate Governance Vak: Thesis Vak: Asset Pricing Vak: Derivatives and Asset Management Vak: Empirical Finance Vak: Research Project Finance Vak: Financial Markets and Institutions Vak: Private Equity and Behavioral Corporate Finance for Finance Vak: Financial Risk Management (Quantitative Finance) Vak: Real Estate Management Vak: Adv Corporate Finance 4.1 Vak: Valuation and Corporate Governance for Finance Vak: Institutional Investments and ALM for Finance 1 2 3 3 4 6 7 9 10 11 12 13 14 14 Vrije Universiteit Amsterdam - Fac. der Economische Wet. en Bedrijfsk. - M Finance - 2012-2013 II Institutional Investments and ALM Course code Credits Language of tuition Faculty Coordinator Teaching staff Teaching method(s) E_FIN_IIALM () 6.0 English Fac. der Economische Wet. en Bedrijfsk. prof. dr. C.G.E. Boender prof. dr. C.G.E. Boender, prof. dr. T.B.M. Steenkamp Lecture Course objective Achieve advanced knowledge of the investment process of institutional investors, like pension funds and insurers. The main objective is to fully understand the most important theoretical concepts in the institutional investment process and the way these concepts are used in practice. After following the...

Words: 5495 - Pages: 22

Premium Essay

Case Studies on Performance Management

...CASE STUDIES IN PERFORMANCE MANAGEMENT A Guide from the Experts TONY ADKINS John Wiley & Sons, Inc. CASE STUDIES IN PERFORMANCE MANAGEMENT CASE STUDIES IN PERFORMANCE MANAGEMENT A Guide from the Experts TONY ADKINS John Wiley & Sons, Inc. This book is printed on acid-free paper. Copyright © 2006 by SAS Institute. All rights reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, 978-750-8400, fax 978-646-8600, or on the web at www.copyright.com. Requests to the publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, 201-748-6011, fax 201-748-6008, or online at http://www.wiley.com/go/permissions...

Words: 77510 - Pages: 311

Free Essay

Digital Banking

...IN-FIN-NITIE Vol 7 Issue 1 MESSAGE FROM THE CONVENOR Want to become an Investment Banker or a Financial Research Analyst Stop dreaming…Add the skill sets required to become one… IIQF is the pioneer of high-end finance education in India. It is an education initiative of top industry practitioners who have pioneered the most sophisticated financial technologies in India like Portfolio Risk Management Models and Systems and Algorithmic Trading Systems using High Performance Parallel Computing. “A mere 25% of graduates that India produces every year is actually employable. Even though India is poised to become the third largest economy in the world by 2050, out of all the graduates that pass out in an academic year, only 25% are suitable for getting inducted into the industry.” Jeffrey Fuller, Principal Advisor of Human Capital. There exists a huge gap between the skills that are required by the industry and what the Indian academic system produces. The objective of IIQF is to impart training to students in those skill-sets that are in demand in the industry and make them industry ready, or as we call them “The Street-Ready”. Certificate Program in Advanced Financial Modelling in Excel and VBA Certificate Program in Financial Modelling in Excel A course geared towards teaching the practical skills required for making a career in Investment Banking, Equity Research, M&A Specialist, Company Valuations, etc. This is a program where practicing Investment Bankers and...

Words: 17797 - Pages: 72

Premium Essay

Multiple Criteria Decision Making

...INFORMS Multiple Criteria Decision Making, Multiattribute Utility Theory: Recent Accomplishments and What Lies Ahead Author(s): Jyrki Wallenius, Peter C. Fishburn, Stanley Zionts, James S. Dyer, Ralph E. Steuer and Kalyanmoy Deb Source: Management Science, Vol. 54, No. 7 (Jul., 2008), pp. 1336-1349 Published by: INFORMS Stable URL: http://www.jstor.org/stable/20122479 Accessed: 15-10-2015 13:28 UTC Your use of the JSTOR archive indicates your acceptance of the Terms & Conditions of Use, available at http://www.jstor.org/page/ info/about/policies/terms.jsp JSTOR is a not-for-profit service that helps scholars, researchers, and students discover, use, and build upon a wide range of content in a trusted digital archive. We use information technology and tools to increase productivity and facilitate new forms of scholarship. For more information about JSTOR, please contact support@jstor.org. INFORMS is collaborating with JSTOR to digitize, preserve and extend access to Management Science. http://www.jstor.org This content downloaded from 130.243.57.230 on Thu, 15 Oct 2015 13:28:04 UTC All use subject to JSTOR Terms and Conditions SCIENCE MANAGEMENT WjEE. Vol. 54, No. 7, July 2008, 1336-1349 pp. DOI io.l287/nmsc.l070.0838 ISSN 0025-19091EISSN1526-55011081540711336@2008 INFORMS Criteria Decision Making, Multiattribute Multiple Utility Theory: Recent Accomplishments and What Lies Ahead School Helsinki Jyrki Wallenius of...

Words: 11852 - Pages: 48

Free Essay

Vissim

...from freeways, the achievable throughput is subject to regulatory constraints such as speeds and societal limitations such as headways between vehicles. Historical traffic volumes indicate that hourly throughputs per lane are generally increasing over time. This reflects a reduction in headways between vehicles as motorists’ acceptable and safe gaps between vehicles become smaller. As a direct consequence, the capacity of freeways has been observed to increase over time. The most recent edition of the US Highway Capacity Manual indicates a ceiling value significantly higher than that applied fifteen years prior. This paper has set out to identify the changing values of capacities over time as applied to freeway traffic conditions. The paper examines capacity in the context of observed volumes to date from both an Australian and International experience. This paper then examines the car following algorithm in the VISSIM microsimulation software to benchmark the similarity of the maximum freeway capacity against these observed volumes. This review of existing literature was initially undertaken when developing a VISSIM microsimulation model to examine the application of forecast...

Words: 6957 - Pages: 28

Premium Essay

Electronic Banking

...CONTENTS S.No. Title 1 Introduction 1.1 project background 1.2 Problem statement 1.3 Project objectives 2 Project Deliverables 2.1 Introduction project management and 2.2 planning 2.3 Analysis 2.4 Design 2.5 Implementation 2.6 2.7 3 Testing Evaluation Research 3.1 Research on strategy 3.2 Research on similar project 3.3 Research on methodologies Research on Development 3.4 tools 4 References Page Number 1 1 3 3 3 3 4 5 5 6 7 8 8 8 8 9 12 14 1 THE WORKING OF ATM Chapter 1: Introduction 1.1 project background Automated teller Goods (Automatic teller equipment) will often be a growing number of utilized these days as a possible easy and simple, hassle-free assortment with regards to guide Tellers. However, there may be present research upwards with regards to quite a few apparent many different numerous insecurities by way of ATMs, their own features and the way they may be successful. This kind of forms identifies what sort of financial institution works usually in addition to signifies specific issues regarding security through employing these kinds of Cash machine gadgets. Evaluation signifies that existing Bank techniques appear to offer we “security through obscurity” instead of the a lot encouraged “open, specialist review” strategy. This may at risk of become due to Financial institution businesses never improving their unique executive so that we can preserve computability along with ATM machine vendors. Work with a considerably guarded style concerning financial...

Words: 5025 - Pages: 21

Free Essay

Post Traumatic Stress Disorder in the Military

...EXECUTIVE SUMMARY This paper analyzes the cost/benefit of long-term care of Soldiers returning from Iraq and Afghanistan and the constraints the Department of Veterans Affairs faces in trying to meet the needs of these Soldiers. This paper uses data collected from government sources like the Department of Veterans Affairs and the Veterans Benefit Administration. The conclusions of the analysis are that: (a) The Veterans Health Administration (VHA) is already overwhelmed by the number of patients it currently sees and the addition of these new Veteran’s seeking care will put a severe strain on the resources that are currently available; (b) The Veterans Benefit Association (VBA) is in need of restructuring to be able to handle the influx on claims it is currently experiencing. As it stands now the current wait time is up to 90 days before a Veteran will receive their disability rating and that time can increase with these additional claims; and (c) Providing medical care and disability compensation benefits to the Soldiers returning from the conflicts in Iraq and Afghanistan can cost anywhere from $400 - $900 billion depending on the type of care required, how quickly they file their claims, and the growth rate of those benefits. The recommendations that need to be considered include: increasing the staff as well as the budget for Veterans Medical Centers especially those that specialize in mental health treatment; restructure the claims process and increase...

Words: 5865 - Pages: 24

Free Essay

Refuelling Schedule for Airport

...Refuelling Schedule for Airports By Kiran R K Jitha Babu Shyam S Sreeraj S CHAPTER 1 INTRODUCTION 1.1 REFUELLING Refuelling is an important aspect with respect to the airports since it determines the ground time of an aero plane. Aircraft fuelling can take up to 90 minutes of ground time. Hence, precise planning and allocation is absolutely essential. Once a flight lands in an airport it has to be refueled for the next flight. The quantity of fuel required depends on the distance it has to travel to reach the next station and type of flight. Aviation fuel is a specialized type of petroleum-based fuel used to power aircraft. It is generally of a higher quality than fuels used in less critical applications such as heating or road transport, and often contains additives to reduce the risk of icing or explosion due to high temperatures, amongst other properties. Aviation fuels consist of blends of over a thousand chemicals, primarily Hydrocarbons (paraffins, olefins, naphthenes, and aromatics) as well as additives such as antioxidants and metal deactivators, and impurities. Principal components include n-octane and isooctane. Like other fuels, blends of Aviation fuel are often described by their...

Words: 9437 - Pages: 38

Free Essay

Creative Atif Aslam

...Overview of Applications by Discipline ECONOMICS Estimating sensitivity of demand to price 352–356 Pricing problems 352–366, 422–427 Estimating cost of power 363–366 47–56, Assessing a utility function 554–556 Estimating demand for products 632–638, 649–650, 764–771, 965 Subway token hoarding 792 FINANCE AND ACCOUNTING Collecting on delinquent credit accounts 14–16 Cost projections 29–33 Finding a breakeven point 33–41 Calculating NPV 57–62 Calculating NPV for production capacity decision 58–62 Portfolio management 173–178, 345–346, 387–394, 442–444, 689–691 Pension fund management 178–182 Financial planning 210–214, 676–681, 734–735 Arbitrage opportunities in oil pricing 215–219 Currency trading 220 Capital budgeting 290–295 Estimating stock betas 396–401 Hedging risk with put options 407–408 Stock hedging 407–408 Asset management 409–410 New product development 503–504, 574, 673–676, 715–722 Bidding for a government contract 513–518, 523–533, 653–657 Investing with risk aversion 557–560 Land purchasing decision 575 Risk analysis 582–583 Liquidity risk management 651–653 Estimating warranty costs 657–661 Retirement planning 681–685 Modeling stock prices 685–686 Pricing options 686–689, 691–693 Investing for college 732 Bond investment 733 HUMAN RESOURCES AND HEALTH CARE Fighting HIV/AIDS 23–24 DEA in the hospital industry 184–189 Salesforce allocation problems 454–456 Assigning MBA students to teams 462 Selecting...

Words: 68271 - Pages: 274

Free Essay

Eco203

...AFGE 2013 Issue Papers Table of Contents Another Manufactured Crisis: What’s Next in the Fiscal Showdown………1 Federal Pay……………………………………………………………….…..…..4 Federal Employees’ Health Benefits Program……………………………….15 Official Time for Federal Employee Union Representatives………….........22 Arbitrary Cuts in Civil Servants………………………………………………..26 Sourcing: Complying with the Law……………………………………….......31 Capping Taxpayer-Funded Service Contractor Compensation……………43 Transportation Security Administration and TSOs…………………………..46 Domestic Partnership Benefits……………………………..………………….49 Employment Non-Discrimination Act……………………………………..…..55 Paid Parental Leave………………………………………………..…………..57 One America, Many Voices Act………………………………………….…....60 Department of Veterans Affairs…………………………………..……………62 Department of Defense……………………………...……….………………...71 Federal Prisons………………………………………………………………….90 Social Security Administration ……………………………………….…...…103 National Guard/Reserve Technicians ………………………...……….……108 D.C. Workers’ Issues …………………...……………………………..…..…117 Equal Employment Opportunity Commission. ……………………..……...120 Another Manufactured Crisis: What’s Next in the Fiscal Showdown? Background At the beginning of January, President Obama signed a tax deal that restored higher Clinton-era rates to those making over $450,000, and funded an extension of unemployment insurance benefits to the long-term unemployed, extended for another year the $240 monthly transit subsidy, but did not...

Words: 54164 - Pages: 217

Premium Essay

Wns Hand Book123

...Student Handbook 2012 WELCOME TO WAIKATO Welcome to the University of Waikato. I hope you make the most of your time here and the opportunities that will present themselves during the course of your study. You have come to an excellent university that is ranked top in 10 subjects under the Government’s Performance Based Research Fund. We are also internationally connected; we have research connections and student exchanges with some of the world’s top universities. I urge you to consider taking part in these while you are with us. Here at the University of Waikato, you will be taught by lecturers who are leaders in their fields of research and who win national teaching awards. We are proud of our academic quality and the fact that we turn out sought-after graduates who go on to take up important roles in all parts of the world. You will already have noticed our beautiful campus which is set in 68 hectares of gardens, green space and lakes. At the heart of it all is the new Student Centre, which was completed in 2011. With its accessible areas, Library services and multitude of facilities, it is a place for students to study or just gather together and we are very proud of this building. In 2011 we celebrated 10 years of another important building, the Gallagher Academy of Performing Arts. This world-class facility was the vision of a group of driven Waikato people. It quickly became a focal point in the campus and continues to be an important venue for the performing...

Words: 126279 - Pages: 506