text:
Tutorial: Spreadsheets
IntroductionA spreadsheet is a software program you use to easily perform mathematical calculations on statistical data and, such as totaling long columns of numbers or determining percentages and averages. And if any of the raw numbers you put into your spreadsheet should change – if you obtain final figures to substitute for preliminary ones, for example – the spreadsheet will update all the calculations you've performed based on the new numbers. You also can use a spreadsheet to generate data visualizations like charts to display the statistical information you've compiled on a website. You can use free applications like Google Docs to create a spreadsheet. You just need to sign up for a free Google account. You also can purchase Microsoft's Excel spreadsheet program to run on your computer. Both spreadsheets programs work in similar ways. Excel has far more sophisticated tools and features. A Google Docs spreadsheet has the advantage of allowing you to easily create a data visualization or map mashup using other Google Apps such as Google Gadgets (see, for example, this story on how The Guardian uses Google Docs spreadsheets to produce its databases and data visualizations). This tutorial describes how to create and do calculations on a Google Docs spreadsheet, with some notations about differences in Microsoft Excel.
Spreadsheet LayoutTo create a new spreadsheet in Google Docs, sign into your Google Docs account. Then click on the Create new button on the top left and select Spreadsheet. On your screen will appear a basic spreadsheet, divided into numbered rows and lettered columns. The rows and columns intersect to create small boxes, which are called cells. Each cell is identified by its column letter and row number. Thus the very first cell in the upper left-hand corner is called A1. Just below A1 is A2. Just to the right of A1 is B1. Just below B1 is B2, and so on. In the image below, for example, cell D9 is highlighted.
Setting the View OptionsYou can select some settings to change the view of the spreadsheet or display toolbars you frequently use, such as the one for entering formulas to make calculations. To do this, in the menu at the top click on View and make sure there's a check mark next to Show Formula Bar (to display a box to enter formulas).
Entering Information in a CellYou enter information into a spreadsheet program by typing it into each of the cells. You can enter three different types of information into a cell:
- Numbers – so you then can perform mathematical calculations on them.
- Text – to identify what the numbers in the columns and rows represent, usually by typing headings across the top of the columns or on the left edge of the rows
- Formulas – to perform calculations on the numbers in a column or a row of cells.
Saving Your SpreadsheetAfter you've entered some data into a Google Docs spreadsheet, make sure you save it by clicking on File…Save and typing in a name for the spreadsheet. Once you've saved the spreadsheet, Google Docs will automatically save any additional changes you make to it.
Importing Data Into a SpreadsheetMany government agencies and private organizations provide data on their websites in a spreadsheet or other format that you can download onto your computer. See our guide on Databases of Statistical Information for locating websites with demographic and other data, including data that can be downloaded as a spreadsheet or in a format like .csv (which stands for comma separated values), which then can be easily imported into a spreadsheet program. To import a spreadsheet, .csv or other file you've downloaded on your computer into a Google Docs spreadsheet, first create a new spreadsheet in Google Docs. Then in the menu at the top click on File…Import and then Browse and select the downloaded file. Note: You also can import data on a website directly into a Google Docs spreadsheet. For instructions on doing that, see the section on Functions later in this tutorial.
Importing Sample DataLet's download some data to demonstrate how to import it into a Google Docs spreadsheet, and also to give us some sample data to use to show how to do calculations and use other features of a spreadsheet. The FBI compiles national crime statistics, including data on the types of weapons used in homicides. This data is in an Excel spreadsheet (.xls) file that can be downloaded from the FBI website and then imported into a Google Doc spreadsheet. To download the file go to this FBI web page: Expanded Homicide Data Table 8 At that page, under the heading for: Murder Victims by Weapon, 2004–2008 Click on the link at the top for: Download Excel The file will be downloaded onto your computer. (if for some reason you have trouble downloading this file, you can click here to download the file from our website) To import the file into a Google Docs spreadsheet, create a new spreadsheet and in the menu at the top click on: File…Import Click on the Browse button and navigate to the downloaded FBI file which is named 08shrtbl08.xls. Select that 08shrtbl08.xls file and click on Import. After a few seconds you'll be prompted that the file has been successfullly uploaded. Then click on Open now. You should see a Google Docs spreadsheet that looks like this: This spreadsheet shows the number of murder victims in each year from 2004 to 2008 in five columns, with the columns labeled by year in cells B4 to F4. Below that the spreadsheet shows the weapon used in the murders in 18 rows of data, with the rows labeled by type of weapon in cells A5 (which is the overall total for all weapons) to A22.
Resizing Columns or RowsYou can improve the display of the data in a spreadsheet by increasing or decreasing the width of a column or the height of a row. To change a column's width, in the gray bar at the top of the spreadsheet where the letters of the columns are displayed, move your mouse cursor to the border between any two columns. Your mouse cursor will change from a hand icon to a vertical bar with a right-pointing arrow. Click, hold down your mouse button and drag the bar to the right to increase the width of a column, or to the left to decrease the width of a column. Similarly, to change a row's height, in the gray bar at the far left of the spreadsheet where the numbers of the rows are displayed, move your mouse cursor to the border between any two rows. Your mouse cursor will change from a hand icon to a horizontal bar with a upward-pointing arrow. Click, hold down your mouse button and drag the bar down to increase the height of a row, or up to decrease the height of a row. Note for Excel: if you narrow the width of a column displaying a number too much, you will see a series of pound signs displayed in the cell: ### This doesn't mean you've lost any data – you just made the column width too narrow to fit some of the numbers in the cells in that column. To fix this, in the gray bar at the top of the spreadsheet just drag the right vertical border of that column to the right to increase the width enough to display all the contents of each cell. The pound signs will disappear and be replaced by the original data in the cells. Note for Excel: You can speed up the resizing of columns and avoid making them too narrow by moving your mouse cursor to the border separating two columns in the gray bar at the top and double-clicking on the border. This will automatically resize the column to the left, making it just wide enough to fit the longest entry on any row in that column.
Deleting or Adding Columns or RowsYou can get rid of unwanted data or other information by deleting rows or columns. For example, in our sample spreadsheet of weapons used in homicides, we might want to get rid of row 23, which is just a footnote stating that one murder in which the victim was pushed to his/her death has been included in the "Personal weapons" listing in row 14. To delete a row, hover your mouse cursor over a row number in the gray area to the left, in this case row 23. Right click and in the pop-up menu select Delete row. Use the same procedure for deleting a column. Hover your mouse cursor over a column letter in the gray area at the top, right click and in the pop-up menu select Delete column (you also can click on the tiny downward-pointing arrow to get this pop-up menu). If you want to add a column or row, again hover your mouse cursor over the appropriate column or row in the gray area above or to the left, right click and in the pop-up menu select one of the Insert options.
Formulas – Adding, Subtracting, Multiplying and DividingLearn to work with data in a spreadsheet and to create engaging charts, maps and graphs in the Berkeley Advanced Media Institute Data Visualization Workshop. With a spreadsheet you can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows. To do this you select a cell in a new column or row and then type in a formula. A formula starts with an equals sign (=) that tells the spreadsheet you want to do a calculation. A formula then has a symbol for what kind of calculation you want to perform (add, subtract, multiply, divide, etc.). The symbols a spreadsheet uses for calculations are:
- plus sign (+) for adding one number to another
- minus sign (-) for subtracting one number from another
- asterisk (*) for multiplying one number by another
- backslash (/) for dividing one number by another
Adding Numbers in ColumnsLet's write a formula for adding together a series of numbers. In the spreadsheet for types of weapons used in murders that we downloaded from the FBI website, the spreadsheet already included the total number of homicides in which any kind of firearm was used each year from 2004 to 2008. Those numbers are in row 6. But what if these totals hadn't been included in the original data and you needed to calculate them yourself using the spreadsheet (or if you wanted to use the spreadsheet to double-check the FBI's calculations). This would require totaling up for each year the column of numbers for the five weapon types in the spreadsheet:
- Handguns – row 7
- Rifles – row 8
- Shotguns – row 9
- Other guns – row 10
- Firearms, type not stated – row 11
Applying a Formula to Multiple CellsIf we now wanted to calculate the total number of gun related homicides for the other four years, 2005, 2006, 2007 and 2008, we could repeat the process of typing an addition formula into each cell in the rest of row 23. But a spreadsheet has a much faster way of accomplishing this – by letting you simply copy the formula to one or more of the other cells in the same row. To do this, click on cell: B23 Where we typed in our addition formula (=B7+B8+B9+B10+B11). Pass your mouse cursor over the bottom right corner of cell B23 and notice your cursor changes from an arrow pointer to a thin crosshairs. Click on that crosshairs, hold down your mouse button and drag your mouse to the right over the rest of the cells in row 23. An outline will appear around the cells you've selected. Continue dragging your mouse until you get to cell: F23 Release your mouse button and the total number of homicides involving firearms for each year from 2004 to 2008 will appear in row 23. Which again confirms the totals in the original FBI spreadsheet in row 6. The spreadsheet has calculated these totals for you by applying the formula you first typed in cell B23 (=F6-B6) to the rest of the cells in row 23. The spreadsheet keeps the formula (addition) the same, but shifts the cell numbers as it applies the formula to the other cells to the right (so the formula in cell C23 is =C7+C8+C9+C10+C11, the formula in cell D23 is =D7+D8+D9+D10+D11 , and so on).
Subtracting numbers in a RowAnother formula you can use in a spreadsheet is subtraction. In our sample spreadsheet of weapons used in homicides, you might want to calculate if the numbers for each type of weapon used increased or decreased between 2004, the first year of the data, and 2008, the most current year of data. To do this, you need to type a formula in a cell in one of the columns to the right of the existing data that will subtract the earliest number in 2004 from the most recent number in 2008. Let's start with the total number of murders by firearms (row G) to see how they have increased or decreased between 2004 and 2008. Click on cell: G6 Which is in the row that shows the total number of murders each year in which a firearm was used. In cell G6 type the following: =F6-B6 We're using the minus sign symbol (-) for the subtraction formula and telling the spreadsheet to take the number in cell F6 and subtract from it the number in cell B6. Thus we're subtracting the number of firearm murders in 2004 (B6) from the number of firearm murders in the most current year, 2008 (F6). Now press the enter/return key. The formula will disappear and the number 99 will appear in cell G6. This tells us there were 99 more homicides by firearm in 2008 than in 2004. Now we can apply this same formula to each of the different types of weapons used to see how the numbers for each one increased or decreased from 2004 to 2008. We do this by copying the formula we just wrote in cell G6 to the other cells in the G column. So click on cell: G6 If you move your mouse cursor over the bottom right corner of the cell, your cursor changes from an arrow pointer to a thin crosshairs. When this happens, click on that crosshairs, hold down your mouse button and drag directly down over the rest of the cells in the G column. An outline will appear around the cells you've selected. Continue dragging your mouse until you get to cell: G22 Then release your mouse button. In your spreadsheet will appear numbers in each of the G column cells. These numbers represent the increase or decrease in each type of weapon used in a homicide between 2004 and 2008. We can use the same process to apply this formula to the data in row 5 above, which is total number of murders using all types of weapons. Click on cell G6 and move your mouse cursor to the bottom right corner so the crosshairs are displayed. Click on that, hold down, drag up to cell G5 and release. You'll see the number -30 displayed in cell G5, which shows the total number of homicides using all types of weapons has decreased by 30 from 2004 to 2008.
Editing a FormulaWhen you type a formula into a cell and then hit the enter/return key, the formula will disappear, replaced by a number that's the result of the calculation. If you need to change the formula, you won't be able to do so by clicking in the cell, because all you'll see there is a number. If you start typing, it will write over the number. So how can you edit the formula? There are two ways: You can double click on the cell to display the formula in the cell and then edit or retype it there. Or you can click once on a cell and use the Formula bar above to edit it. If you click once on a cell that has a formula hidden in it (replaced by a number that's the result of the calculation), the formula you originally typed will appear in the Formula bar above the columns and rows. For example, click on cell G6, in which in the previous section we typed in the formula =F6-B6. In that cell the number 99 is now displayed. But look above the columns and rows and you'll see the =F6-B6 formula displayed in the Formula bar. To edit the formula you can click in the formula bar where the formula for this cell is displayed. Then change the existing formula or type a new one into the Formula bar, press the enter/return key and the new formula will be applied and the numbers will be recalculated in the cell.
Percent Changes and Multiplying and DividingYou also can use a spreadsheet to calculate percent changes between two numbers. For example, in our spreadsheet on murder weapons from 2004 to 2008 we can calculate not only how much the use of each weapon increased or decreased, but by what percent each one did so. This way we can better compare how the use of each type of murder weapon is changing relative to the others. To do this, we need another formula, in which we'll divide and multiply some numbers to get the percent change. First let's tidy up the spreadsheet by resizing the G column, in which we previously did calculations of the changes in the numbers of each murder weapon used between 2004 and 2008. This column is much wider than it needs to be for the numbers displayed. To resize a column, in the gray bar at the top of the spreadsheet where the letters of the columns are displayed, move your mouse cursor to the border between the G and H columns. Your mouse cursor will change from a hand icon to a vertical bar with a right-pointing arrow. Click and drag the bar to the left to decrease the width of the G column. Now let's do the percent calculation, starting with the percent change in the total number of homicides (row 5). First click on cell H5 to the right. And type in the following formula: =(F5-B5)/B5*100 This is the formula for calculating the percent change between two numbers. This formula tells the spreadsheet to subtract the number of homicides by all types of weapons in 2004 (B5) from the number of homicides by all types of weapons in 2008 (F5), then divide that by the original number of homicides in 2004 (B5), and finally multiply the result by 100 (which converts this to a percent figure). The backslash ( / ) is the symbol for dividing, while the asterisk ( * ) is the symbol for multiplying. (the parentheses in this formula are also important – see the next section on why we're using those) Now hit the enter/return key to see the final result of the percent formula in cell H5: -0.2111189 This shows that the total number of homicides by all types of weapons declined by 0.2 percent from 2004 to 2008 (in other words a decline of about two tenths of one percent). Note: We could have accomplished this same calculation by using a simpler formula: =G5/B5*100 That's because we've already set up the G column to calculate the B column minus the F column (that is, to calculate the difference in the number of homicides between 2004 and 2008). So we could have simply divided the number in the G column by the number in the B column and multiplied by 100 to get the percent change. Now let's apply the percent change formula to the rest of the murder-by-weapon numbers. Click on cell: H5 Pass your mouse over the bottom right corner of the cell until the cursor changes to thin crosshairs. Clickand drag the mouse cursor down over the rest of the cells in the H column. Release your mouse button when you get to cell: H22 The percent changes for all the different types of weapons used in homicides will appear on your screen.
Parentheses in a FormulaIn the formula for percent change we used in the previous section, parentheses ( ) were included in the formula: =(F5-B5)/B5*100 The parentheses in this formula are very important. These tell the spreadsheet to subtract the number of homicides in 2004 (B5) from the number of homicides in 2008 (F5) first, and then divide that amount by the number of homicides in 2004 (B5) and finally multiply by 100. If you didn't include the parentheses and had just typed in =F5-B5/B5*100, the spreadsheet first would divide B5 by B5 (yielding 1). Then it would multiply that by 100. Finally it would subtract the result from F5. The resulting calculation would be the total number of homicides in 2008 minus 100, a meaningless number. So if you are doing a calculation involving several steps, it is important to include parentheses so you can group the numbers properly and the spreadsheet thus knows the order in which to do the calculations.
Percentages of a Constant NumberAnother calculation you can perform with a spreadsheet is determining the percentage of a fixed number. In our spreadsheet of weapons used in homicides, for example, we might want to know what percentage of the total number of homicides involved each different type of weapon. Thus for the year 2008, we'd want to know what percentage of the total homicides that year (cell F5) was caused by each of the 17 different categories of weapons (cells F6 through F22). We can start by calculating the percentage of murders involving all kinds of firearms (cell F6) and then applying that same formula to the cells for the other types of weapons. To create our percent formula click on cell: G6 And type in this formula: =F6/F5*100 This formula tells the spreadsheet to divide the number of homicides involving firearms in 2008 (F6) by the total number of homicides that year (F5), and then multiply the result by 100 (which converts this to a percent figure). Press the enter/return key and you'll see the total is: 66.88… So firearm related homicides were about two thirds of the total number of homicides in 2008. You might then try to apply the same calculation to the cells for the other types of weapons using the applying a formula to multiple cells method we covered earlier. Thus you might click on the crosshairs in the bottom right corner of cell G6 and drag the formula to the cells below, on down to cell G22. But this will produce bizarre numbers in the G column, including that some weapons-related homicides are more than 100% of the total. What went wrong? The problem is that when the spreadsheet copies a formula using this method, it shifts the letters for both cells in the original formula (F6 and F5) as it applies that formula to other cells (resulting in F7 divided by F6 in the next cell down). But we want the number in cell F5 (the total number of homicides) to always remain constant in the formula. To fix this, we need to force the spreadsheet to always divide the numbers for each type of weapon used by a constant number – the total number of homicides in cell F5. To do this we need to anchor the F5 cell in our formula, and force the spreadsheet always to divide the number for each particular type of weapon by that same total number of homicides in F5. You accomplish this by adding some $ signs to the formula that instruct the spreadsheet not to change cell F5 when applying the formula to other cells. So go back and click on cell: F6 Which is where we typed the original formula: =F6/F5*100. Delete that formula, and instead type in this: =F6/$F$5*100 The dollar signs tell Excel to always keep anchored on cell F5 and the data in it when applying this formula to other cells. When you now press the enter/return key you'll see the same number in the F6 cell as before: 66.88… But now we can drag the formula down through the column of cells and get the correct results. So hover your mouse over cell: F6 Then click on the crosshairs in the bottom right corner of the cell and drag down to cell: F22 And release your mouse. The correct percentage figure for each weapon type will now appear in the spreadsheet. Thus the percentage of homicides in 2008 involving a firearm of any kind was about 66.9 percent of the total, those involving a handgun was about 47.6%, knives or cutting instruments about 13.4%, strangulation about 0.6%, and so on.
Adding Numbers Using the SUM FormulaIf you want to add a large group of numbers in a row or column, there's another way to do that quickly in a spreadsheet by using the SUM formula. For example, in the spreadsheet on weapons used in homicides, what if you wanted to know the total number of homicides in which a firearm was not the weapon used. To calculate that, you could add up the numbers in rows 12 – 21 for each year using the SUM formula (Note: row 22 – "Other weapons or weapons not stated" – may or may not involve a non-firearm-related homicide, so we're leaving that out of this calculation) To use the SUM formula to calculate the number of non-firearm-related homicides in rows 12 – 21, first click on cell: B23 In that cell type this formula =SUM(B12:B21) Then press the enter/return key. You'll see there were 3,969 non-firearm-related homicides in 2004. In our formula, =SUM is shorthand for telling a spreadsheet to add up a series of numbers. After typing =SUM, you type an opening parentheses, followed by the letter/number of the first cell in the column you want to add. After that type a colon, then the letter/number of the last cell in the column you want to add, followed by a closing parentheses. The colon instructs the spreadsheet to apply the SUM calculation to the numbers in all the cells between the first and last cell you've entered.
Adding Select Numbers with the SUM FormulaYou also can add up select numbers in a column, rather than a span of them, using the SUM formula. To do that, in the SUM formula you replace the colon with either plus signs ( + ) or commas ( , ), to separate the specific cells you want to total up. Thus if you wanted to total up only the number of homicides in 2004 in which either poison (cell B15) or narcotics (cell B18) was involved, you would type this formula: =SUM(B15+B18) or =SUM(B15,B18) Either of which will add the number in cell B15 to the number in cell B18 and give you the total number of homicides involving poison or narcotics in 2004 (93).
Shortcuts to Writing FormulasThere are a number of shortcuts for writing formulas in a spreadsheet. To illustrate these, in our spreadsheet on types of weapons used in homicides, let's add up the total number of firearm-related homicides from 2004 to 2008. This means adding together the numbers in cells B6, C6, D6, E6 and F6. To do this, to the right click on cell: G6 Here you could type in the SUM formula to add up the numbers: =SUM(B6:F6).
Formulas ToolBut the spreadsheet has a Formulas tool that will shorten what you have to type. Look to the far right in the toolbar just above the spreadsheet for a symbol that looks like this: (if you hover over it with your mouse, the word Formulas will appear) Click on it and you'll see a series of formulas you can select to insert into your spreadsheet. In this case pick SUM and the formula =SUM() will be inserted into cell G6. Now you just need to insert between the parentheses the span of cells you want to have totaled, such as B6:F6. Or in between the parentheses you can type in the individual cell letters/numbers separated by commas or plus signs, such as B6,C6,D6,E6,F6 or B6+C6+D6+E6+F6 Press the enter/return key and the calculation will be performed.
Selecting Cells in the SpreadsheetYou also can add the span of cells you want in the SUM formula by selecting in the spreadsheet the first and last cells in the span (such as B6 and F6 in this example). To do this, first add the SUM formula as described above to cell G6. Make sure your cursor is positioned in between the parentheses in the =SUM() formula (if needed, double-click on cell G6 to display the formula and then click in between the parentheses) Now click on cell: B6 The spreadsheet will add that to the SUM formula: =SUM(B6) Now hold down the shift key on your keyboard and click on cell: F6 The spreadsheet will add that to the SUM formula as the last cell in span that you want totaled: =SUM(B6:F6) It will also highlight on the spreadsheet the span of cells you've selected. Then press the enter/return key to apply the formula and calculate the total: 49,381 firearm related homicides between 2004 and 2008. An alternative to holding down the shift key is to click on the first cell you want in a span, hold down your mouse button and drag left-right or up-down to add more cells to the span to be totaled. Note for Excel: In Excel you can click on individual cells to total up, rather than a span of cells. Thus you an add together numbers that aren't adjacent to each other. To do this, position your cursor between the parentheses in the =SUM() formula and hold down the Command/Apple key instead of the Shift key. Then just click on the cells you want to add together, and Excel will insert them into the SUM formula, separated by commas. This feature doesn't currently exist for a Google Docs spreadsheet. So if you want to total up numbers in cells that aren't adjacent, you'll have to type the letter/number for each individual cell into the SUM formula, separated by commas.
Averaging NumbersAnother common calculation is averaging a series of numbers. In our spreadsheet on the types of weapons used in homicides, for example, what if we wanted to know the average number of firearm-related homicides each year between 2004 and 2008 (cells B6 to F6). To do this, click on cell: G6 And in that cell type: =AVERAGE(B6:F6) Or you can use the shortcuts to writing formulas described before and apply it to averages. Click on cell G6 and then in the far right of the toolbar just above the spreadsheet click on the Formulas tool symbol that looks like this: Scroll down and select: AVERAGE The formula =AVERAGE() then will be inserted into cell G6. Now you can type B6:F6 between the parentheses. Or, with your cursor positioned between the two parentheses, click on cell B6, hold down the shift key and click on cell F6. The spreadsheet will add that span of cells to the AVERAGE formula: =AVERAGE(B6:F6) Press the enter/return key and you'll see there was an average of 9,876.2 firearm-related homicides a year from 2004 to 2008.
Using Functions to Import Website DataOne advantage to Google spreadsheets is that it is designed to work with the Web. Specific functions allow you to load data dynamically directly from a website.
Import a data file published on the Web into your spreadsheetCSV files (comma separated values) can be imported directly into a spreadsheet from anywhere on the Web. CSV is one of the most common data formats and can be found with a simple Google search. Type ucla crime filetype:CSV in a Google search page and you should see this in your browser: Select the green URL below the first item and copy it. Open a new spreadsheet and click in cell A1. Type =ImportData(" Paste the URL after the quote mark then type ") and hit enter. After a moment the data will load and should look like this: Many files will not be this clean and may require cleanup. But if you can use the file as is, it's especially useful. Governments regularly update CSV files on their servers. This may happen frequently with certain files such as election results. A Google gadget made with one of these files also updates automatically if the CSV file is updated.
Import a table or list directly from a Web pageTables can frequently be imported directly from a Web page into a spreadsheet. Let's import the same data from the Expanded Homicide Data Table 8 used earlier. Right click on the link and select "copy link" from the menu. Open a new spreadsheet and click in cell A1. Type =ImportHtml(" paste the URL after the quote mark then type "; Then type "table"; This tells the function to look for the <table> html tag. Now type 1) This tells the function to pull data from the first table. To pull data from the second table on a page, replace the 1 with a 2. Hit enter and the spreadsheet should look like this: The "table" setting can be replaced with "list" so that it will look for the contents of <ul> <ol> and <dl> tags.
Load dynamic financial dataLive data from Google finance can be imported into your spreadsheet. The data updates automatically every time the spreadsheet is loaded. Quotes can have up to a 20 minute delay, which is common for financial data. Create a new spreadsheet that looks like this: Type =GoogleFinance("DJI", "price") in cell B2 Type =GoogleFinance("INX", "price") in cell B3 Type =GoogleFinance(".IXIC", "price") in cell B4 The initials at the beginning of the parentheses are stock ticker symbols. You can find the symbol for any stock at Google Finance. The cells should update in a few moments and your spreadsheet should look like this:
Load historic financial dataThe same function can be used to load historic data. Let's pull in the daily closing price of Google stock for 2009. Create a new spreadsheet. In cell A1, type =GoogleFinance("GOOG", "close", "01/01/2009" , "12/31/2009", "DAILY") Hit enter and the daily closes for 2009 should load into your spreadsheet. To do more with the GoogleFinance function, check out the documentation page.
Sorting ResultsAfter you've entered numbers or done calculations in a spreadsheet, you may want to sort the results from highest to lowest or lowest to highest. With the spreadsheet on types of weapons used in homicides, for example, you could more easily see which weapons are most frequently used by ranking them from the highest number to the lowest number for any given year. To do this, you first need to highlight the area of the spreadsheet that you want to sort. Don't just highlight a single column of numbers to sort because the spreadsheet then will sort only the cells in that column and not change the order of the corresponding cells in other columns (such as the headings that tell you which type of weapon corresponds with the numbers of homicides). To keep the headings and other data in order in our spreadsheet, in the gray area to the far left that lists the row numbers in the spreadsheet, click on the number for row: 5 Which is the row with the totals for all homicides in each year. Now hold down the shift key on your keyboard and in gray area below click on the number for row: 22 Which is the row with the totals for homicides by other weapons or where the weapon wasn't stated. You should see everything on the spreadsheet between rows 5 and 22 highlighted. The highlighted area now includes the headings for the types of weapons used and then the numbers for each type of weapon for each year. To sort the data, in the menu at the top, click on Tools…Sort… In the box that appears, you'll see the range of selected cells displayed at the top (in this case, cells A5 to J22). You now can select the column by which you want to sort the data. You also can select whether to sort that data in ascending order (A – Z) so the smallest number appears at the top of the sorted data, or descending order (Z – A) so the largest number appears at the top. In our case, we can select: Column F Which will sort the data by the most recent year, 2008. And select: Z – A So the numbers for weapons that are used the most appear at the top of the sorted data. Then click on Sort to rearrange the data. The spreadsheet now will display the types of weapons most frequently used in homicides in 2008 at the top of the chart (total firearms, then handguns, then knives…), and the least frequently used weapons at the bottom (explosives, poison, drowning). If you then want to go back to the original form of the spreadsheet, in the menu at the top click on: Edit…Undo Note for Excel: you re-sort columns by clicking in the main menu on Data…Sort or by clicking on the Sort buttons in the toolbar.
Formatting CellsA spreadsheet provides a lot of options for re-formatting the information being displayed. These are similar to the options in a word processing program like Microsoft Word or many other applications. They include:
- Changing the font size or style
- Defining the format for the kind of data in a cell, such as dates, times, currency or percents
- Changing the number of decimal places displayed in a number
- Changing the text color or the background color
- Adding borders around the cells


text:
What are the types of scam that a person in an influential position can perpetuate?
One type of scam is to sell something that belongs to the Government at a cheaper than market rate. That buyer then sells the asset at prevailing market price and pockets a profit. Typically, discretionary land allotments fall in this category. Such benefits often accrue to 'people who are close to power' or 'loyal'.
The second type of scam is the opposite of this one. Where the influential person enters into a contract to buy something (Guns, Submarines) for the forces or Government or infrastructure at an inflated price. A variation of this is to buy substandard or outdated technology or non standard items. In either of these cases, the cost is inflated.
Now, in buying and selling assets — it is entirely possible that the official in question is naive or stupid. But to expect in these times that any politician can be so stupid as to not see his (or his backers) self interest is a little bit of a stretch. So we can assume that people at influential positions make transactions based on self interest as much as national interest (the former may trump the latter as we have seen).
Leaving stupidity aside, benefits from both the above transactions (in the former case, the profit is often a reward for loyalty) can flow back to the "person of influence". This is known as a kickback. Kickbacks can be in cash and kind. Kickbacks in kind varying from a simple job or jobs to a stake in business to real estate. Kickbacks in cash may be to varying non persons, benami friends and Swiss accounts.
The reason why this elucidation is required is because there is attempt in some quarters to shift the goalposts on the spectrum scam that the loss is notional.
The loss is not notional because some other entities made money on the spectrum almost overnight — since the spectrum was sold on 2001 valuations in 2007. The loss would have been notional, had the holders of the spectrum made no money on it.
This argument assumes that the Government does not need that extra money or that the extra money would have made the Government spend more on pork barrel schemes.
But that argument is simply stating a known fact that the Government is corrupt. If the mug does not leak, the bucket will. That is no basis to justify the underpricing of an asset and selling it off to favoured bidders.
In fact, the argument could be equally strong on the other side that the extra money would have helped the Government lower taxes or invest in defence and infrastructure and in many other much needed areas.
The second shifting is to say that customers benefited because of lower tariff on account of the low cost of spectrum sale.
On this count, if the Government was so concerned about offering low cost to customers, it should have taken a very nominal licence fee and opened the floodgates to multiple operators with a profit sharing clause. Clearly, the reason of the low cost of sale was not about benefiting customers. This is now being added to the argument — perhaps by the operators who benefited. If this was true, why did people lobby for a particular man to head the Ministry? And as far as I know, customers did not lobby for him to be there.
The fact is that the money that should have gone to the exchequer went into private hands. Whether it went into politicians hands is a matter of investigation which as we all know will run into millions of years and zillions of dead ends — by which time it will fade from public memory and the beneficiaries will enjoy the high life. The money, in the meantime, will be invested in real estate, gold or in tax havens and may even come back as FII investment in the stock markets.
But for now, it is important that we let the focus remain on the fact that the exchequer was robbed.
(This piece was published as an Op Ed in Pioneer on 26th Jan 2011)
Friday, January 28, 2011
Shifting Goalposts in the Telecom Scam
What are the types of scam that a person in an influential position can perpetuate?
Posted by ecophilo at 8:40 AM 0 comments Links to this post
Saturday, January 15, 2011
Hindi in Kerala
In my many visits to Kerala over the past many years, the one thing that I have found resilient in the state is the unstinting love for its language. The language is Malayalam. If you speak Malayalam, stuff happens. If you speak other languages, things wont move. They will, but at a slighty different pace. And while English would grudgingly win you a few brownie points for being a tourist - not too many other languages would - perhaps in the corridors of 5 star hotels, but on the street - no way. And Hindi - well, the less said the better. I was amazed at the reluctance of the state to learn Hindi.
But a few months back, on a routine visit I was amazed to see quite a few people converse in Hindi. It turns out that along with the emergence of Yadav Bhelpuri Centers there are quite a few north Indians and east Indians working in Kerala. They are there to supplement the labour pool. After all you don't want a post graduate waiter do you? So, in a hundred percent literate state, there are either no takers for certain jobs or the pay is too less - so they migrate to other states in search of jobs. And who comes in their place? People who are willing to do those jobs. Thus it has happened that there are quite a few "Northies" in Kerala and this time I heard people converse in Hindi with them. That's quite a change.
But now, as a certain Raj Thackeray asks and soon a Raj or Reji or Rehman in Kerala will ask - why arent they learning Malayalam?
Interestingly, it will also result in better North Indian food in Kerala apart from Yadav Bhelpuri centers and hopefully better phulkas and rotis...
Posted by ecophilo at 1:36 PM 2 comments Links to this post
Big B Gujarat Tourism Video
This entire GTDC video series nothing less than awesome. Its radio ads (that are playing now in the Big Bs voice) are pretty cool too.
Note the choice of words in this Somnath ad though - Foreign invaders or Videshi Hamlavar, but as the history will tell you, it was not always foreign invaders - we had local, homegrown iconoclasts too...but do enjoy the videos - they are really good and the Big Bs persuasive voice makes it awesome.
Posted by ecophilo at 9:35 AM 0 comments Links to this post
Labels: advertisement, india tourism, video
Friday, January 14, 2011
Yadav Bhelpuri Centre
Many moons ago, on our annual vacations to Kerala - we would maintain that is only the availability of Bhelpuri that makes Bombay a better place to live than Kerala and all my relatives maintained that Bhelpuri had no place in a place like Kerala.
But it looks like the Yadavs have done what the BJP has not - bought a slice of North India into Kerala. More on this later - a longer post coming up on how while once upon a time Mallus helped the middle east, today it is the Biharis and UP-ites who are heading to Kerala - for work!
Posted by ecophilo at 9:22 AM 0 comments Links to this post
Go to Antartica
On a recent visit to Kerala - we were stuck in a longish traffic jam at Kadavanthara junction - which really has to be among the top ten destinations to visit in India as far as a traffic jam is concerned.
Posted by ecophilo at 9:18 AM 1 comments Links to this post
Thursday, January 13, 2011
Riding an evil tiger
Every recent comment on Pakistan never forgets to include that it was the Senior Bhutto who first got into bed with the Islamists. Which resulted in him appointing Zia Ul Haq as his military head - for which he was duly repaid by the latter. Zia continued the path of encouraging Islamists and Islamism - as did successive governments" and the result today is there for all to see. A "pious" man who was the bodyguard of a "liberal" gunned him down - for no great offense except that he attempted to save the life of a "blasphemer". That was enough for the "pious" man to take his life. Those who claim to be shocked by this should realise by now that this was the writing on the wall all along.
As the Pakistani society is discovering, riding a tiger has its pitfalls. As the character of Bhaloo says in Jungle Book while holding a tiger by its tail - how can I let go - it has teeth at the other end. Riding a tiger or holding its tail is a nice ride until its teeth bite - and bite it will. Nobody who has ridden a tiger has got off safe and sound - either the tiger has to die or the rider. There are no two ways about it. And if the tiger in question is a nuclear teethed tiger, you can safely assume that it not go down quietly.
Today Pakistan civil society (if something like that exists) is hiding from a tiger - the same tiger that they encouraged either by denial or fear or plain ignorance or even a dash of arrogance - "it will bite others, but won't bite me". And the same tiger is out to get them.
The same applies to the US - it rode the Islamic tiger from Arabia to Afghanistan to Pakistan so that it could defeat the Soviets. "Defeat" it did, but today the same tiger is out to get the US and its interests. It has done considerable damage to the US already - something that the Soviets could never do. And the US is attempting to de-fang the tiger smoothly. Which is a historical impossibility. No evil has ever gone down silently.
What the US is learning China refuses to learn. China is in bed with various evils - North Korea, Pakistan and if it doesnt actively encourage them - it surely does not discourage them. Very soon, the tigers will come home to roost - even for China.
Posted by ecophilo at 8:09 AM 2 comments Links to this post
Labels: politics

subset: commoncrawl


text:
Ken Sherman necesitaba un nuevo diseño de logotipo y lanzó un concurso de diseño en 99designs.
Un ganador ha sido elegido entre 46 diseños de 14 diseñadores freelance.
Modern Stone Technology or Modern Stone Technologies
Hi, thanks for viewing. We currently operate our business as This Old Grout & Stone. http://www.thisoldgrout.com.
We manufacturer products for the cleaning and restoration of natural stone, tile and grout. We also provide unique training and business opportunities for the industry. The name This Old Grout & Stone is confusing for many people that don't connect "This Old House" with This Old Grout. We started out as a service company (This Old Grout) and have grown into a mfg company, but the name doesn't fit anymore. We are competing with http://www.aquamix.com, http://www.miraclesealants.com, http://www.stonetechprofessional.com. As you'll see,our current bottle and label design are lacking; making it difficult to break into distribution outlets. We have decided on the name Modern Stone Technologies and will probably be known as Modern Stone. We'd like to start with a logo to brand our new name but we'll carry the look and feel of the logo through to our product labels, brochures, website, etc. We are a very customer focused company and have everything in place to go to the next level except the look. People pick up our competitors product before ours just because of the way it looks,while our products are equal in performance. This could end up being a long term project as we'll need everything from logo, labels, brochures, sales pages, web design, stationary, business cards,...the whole boat.
Our target audience is the tile and stone outlet distribution center that caters to the contractor. We also target the contractors themselves. Bottle should have many of the attributes of our competition, in that you would pick up a bottle of our products as likely as our competitors.
At this point, the design is an open slate. Using the look of the competition as a standard, we want to update our image and look to something that is more appealing to the contractor as a professional product and obviously to appeal more to distributors to get them to carry our products.
We'd like to start with a logo and basic product label concept that communicates simplicity with a modern edge and professional look and feel.
The new look should give the contractor confidence that the product is high quality, contractor grade if you will. The products should look good on a retail or wholesale display shelf next to our competitors products.
We'd like to find a designer that can create a concept that can be carried through our whole line of products and all aspects of our corporate communication and literature.
Also, the design should not be able to be confused with any of the aforementioned competitors products. Feel free to be creative regarding color and commercially viable designs.
Descubre cómo funciona un concurso de diseño u obtén más información sobre nuestros servicios de diseño de logo.


text:
Women 1, 2, 3
As mentioned in the post yesterday about Tyler, racing the 4th at the Matava Crit is a Seattle tradition. In the few photos I took with an iPhone, the Women raced hard towards the bell lap
One of the best bells in the business
and our friend Erik wore his best Apres-race outfit.
Erik's Apres-race style with a Shimano trucker hat


text:
CID THE DUMMY is a platform game that grabs you straight away with its amusing blend of action and puzzle-filled gameplay. Based around the multiple opportunities for a Crash Impact Dummy to get into mischief, the game blends classic platform elements such as timed jumps, collecting pick-ups, defeating enemies, and challenging boss battles with more cerebral elements such as puzzles, clever weapon use and route finding.
Source: The Developer Website.


text:
Home Page Chess Life Online Archives New York International Begins
|New York International Begins
|By Dr. Marcus Fenner
|June 20, 2013
The 6th New York International began on Wednesday with a star studded field featuring 65 players from 18 different countries, including 9 Grandmasters and 12 International Masters. The top seeds are GM's Jaan Ehlvest (FIDE rating 2621), Giorgi Kacheishvili (2615), Sam Shankland (2601), Aleksandr Lenderman (2567), Tamaz Gelashvili (2560) and Vladimir Dobrov (2545).
The strength and depth of the field is demonstrated by the many first round upsets, including draws on three of the top four boards.
The event (one of only a handful of "Super Swisses" in the U.S.) provides players with excellent chances to achieve title norms. Last year 3 IM and 2 GM norms were awarded, more than in any other tournament in the country.
Please check the Marshall Chess Club website for pairings and standings.
The top boards are broadcast live on ICC.


text:
Fox extends early movie releases to Australia
Blockbuster movies are online weeks before their DVD/Blu-ray release as Fox extends its Digital HD program to Australia.
For several years the movie houses have been promising to reduce the so-called "piracy window" between when a movie appears in the cinemas and when it is available to buy. This wait is seen by some people as a key factor behind movie piracy, especially when Australians are forced to wait longer than Americans and then expected to pay more simply because they're Australian.
Back in 2012, 20th Century Fox kicked off its "Digital HD" program in the US, offering movies for sale as digital downloads several weeks before you could buy them on DVD or Blu-ray. Ridley Scott's Alien prequel Prometheus was the first cab off the rank – available for download on September 18, more than three weeks before the disc hit the shelves.
Digital HD is not a great name because you could be forgiven for thinking that high-definition is the selling point, rather than the early release date. The haphazard approach to early releases, from all the movie studios, has also clouded the issue. We've seen early releases pop up on Apple's iTunes store for a while in Australia but there don't seem to be any hard and fast rules.
Digital HD is supposedly kicking off in Australia this month but 20th Century Fox has offered a handful of early releases in the past. What's changed is that EzyFlix is the first Australian retailer to officially adopt the Digital HD tag, although the movies are also available via iTunes, Google Play, Xbox Video and the Sony Entertainment Network.
EzyFlix's upcoming release schedule from various movie houses includes;
- Sleeping Beauty - Walt Disney - online 6/08/2014 - DVD 13/08/2014
- Batman: Assault on Arkham - Warner Brothers - online 6/08/2014 - DVD 20/08/2014
- The Amazing Spider-Man 2 - Sony - online 7/08/2014 - DVD 14/08/2014
- Captain America: Winter Soldier - Walt Disney - online 12/08/2014 - DVD 20/08/2014
- Noah - 20th Century Fox - online 13/08/2014 - DVD 27/08/2014
- The Monuments Men - 20th Century Fox - online 20/08/2014 - DVD 3/09/2014
- Transcendence - Roadshow - online 22/08/2014 - DVD 27/08/2014
- Tinker Bell and the Pirate Fairy - Walt Disney - online 5/11/2014 - DVD 12/11/2014
- Guardians of the Galaxy - Walt Disney - online 26/11/2014 - DVD 3/12/2014
It's great to see the movie houses responding to the piracy threat by actually meeting demand rather than calling in the lawyers or offering pathetic gestures like Australia's Digital Content Guide. It will be interesting to see how much of an impact the early release approach has on piracy.
There is one interesting entry on that list, Tinker Bell and the Pirate Fairy, which might not be to your taste but highlights the delays which Australian movie fans still face.
The latest Tinker Bell movie came to Australian cinemas on June 26, in time for the school holidays, but at the time it was already on Netflix – which saved some Aussie parents a few bucks. Tinker Bell and the Pirate Fairy was released in US cinemas on February 13, came out on DVD on April 1 and hit Netflix on April 29. Admittedly it's not as popular as something like the The Lego Movie, but why did it take six weeks to come to DVD in the US and 20 weeks in Australia? Until the movie houses stop treating Australians as second-class citizens they'll always face the problem of Aussie movie fans bending and breaking the law.
Are you more likely to hand over your money for a movie thanks to early release programs like Fox's Digital HD? If not, what would it take to win you over?
Adam Turner is an award-winning Australian technology journalist and co-host of weekly podcast Vertical Hold: Behind The Tech News.


text:
The VTB Arena Park project in Moscow is successfully integrating a shopping experience within a stadium, as well as combining a modern approach to the sports and entertainment industry at unique location within Moscow's historical centre.
Colliers International Moscow advised on concept development and lease of the leisure and entertainment component of the large-scale VTB Arena Park project, including the Dynamo Central Stadium. VTB Arena – Dynamo Central Stadium, a sports and entertainment centre, is being developed within the framework of reconstruction and modernisation of the big sports arena for the FIFA World Cup 2018.
The three-level leisure and entertainment component with a GBA of 119,000 square metre (GLA – 49,000 square metre) will be located beneath the sports arena of the Dynamo Central Stadium and will include a large entertainment centre (7,000 square metre), a multiplex (6,000 square metre), a sports museum, a large food court area, an area of concept stores selling sports and outdoor activity goods, as well as children's stores.
We are proud to provide leasing and consultancy services for this unique project.
Direct: +47 40 20 17 00
Colliers was one of the first global companies to enter into Asia, Central Europe and Latin America. We're committed to providing our clients with access to emerging markets around the world.
Fill out this short form and we'll connect you right away.
Data for your saved properties is currently unavailable, please check back again later.
{{Summary}} Remove
Select properties to email by checking or unchecking each property to the left.
One or more errors were found with the information you entered into the form. Please correct the information and submit again.
Your message has been sent successfully.
Sorry, there was an error in submitting your email. Please try again later or contact the site administrators if the problem persists
You have no saved properties. Click the 'save' button associated with a property listing to see it displayed here.
The saved properties feature requires cookies to function. Please enable cookies and refresh the page to use this feature.


text:
Clay Aiken took to his personal website (available to view for the low, low price of $29.95/year) to rip "Idol" and its king of glam runner-up Adam Lambert. As Gawker pointed out, despite only hearing Lambert sing once, Aiken claimed he thought his "ears would bleed" when he belted out "Ring of Fire." Pot, perhaps you've met kettle?
Then Aiken played the "it was better back in my day" card and wrote, "The show was different then, and folks made it in seasons 1-3 because they were 'real' people who happened to sing/entertain well. But, somewhere along the way, AI stopped being about real people."
Note to Clay -- real people don't charge other real people $29.95/year to access their website.


text:
As of 11/1/11, H2OChills, a company located in Brookfield, Wisconsin, and designer and distributor of patent pending recreational flotation devices, launched its new suite of products into the market via its online sales channel: www.h2ochills.com. Obvious head-turners by appearance, the H2OChills water floats are ear benders by name: Water Bosom, Ball Sling, and 3-Ball Package.
With the two founders of the company, Brian Callahan and Dan McGinley, both sharing a lifelong love of the water-life, and both having had previous success in building start-up organizations, the two business partners sought to create, patent, and market a new water float product that was innovative in design, provided form fitting comfort, was of durable construction and material, and would allow occupants free range of motion in the water, as opposed to the float on the water model provided by traditional water tubes and floats. The design process outcome was nothing short of spectacular. Says McGinley, "The H2OChills brand water floats are not only ridiculously comfortable, but they're also extremely versatile. Unlike traditional floats which restrict your movement and limit the positions in which you can use them, much like a Lazy Boy chair, the H2OChills water floats allow occupants any number of positions in which to relax in the water."
Though many water float designs have attempted to accomplish what H2OChills seems to have perfected, one of the industry shortcomings has been the inability to balance ease of set-up, with ease of use, maintenance, and storage or portability.The H2OChills designs have overcome all of these challenges. According to Callahan, "My family spends a great deal of our summer days on the family lake here in Wisconsin, as well as in our pool down in Hilton Head, South Carolina. In the past, the number of float products that we've had to pack away in the boathouse, boat,and car top carrier has been a source of considerable frustration. And the numberof times that a foam tube float was lifted from one of our moving boats and into the water, I couldn't even tell you. The water floats market needed products like ours to decrease the hassle and clutter and increase the amount of time spent enjoying the water."
In addition to all of the functional benefits mentioned by the owners of the company, the product designs themselves are very intriguing, flipping traditional designs on their heads. Unlike other inflatables on the market, the H2OChills products are actually polyester/spandex skins, hand sewn in the U.S.. The skins themselves do not float, but each skin contains at least one pocket, which securely houses a PVC or rubber inflatable ball. The benefit? Unlike the constant patching and repair required of other inflatable float products, if an H2OChills ball float were to be punctured, all that's required is a replacement ball, conveniently found at just about any local big box retailer. Thinking like no other manufacturer of water float products, has produced a water float product like no other.
In addition to selling the H2OChills products online, Callahan and McGinley plan to market the products to water parks, boaters, pool and spa owners, and the outdoorrecreational industry at large via industry trade shows and consumer publications.
Information for purchasing, making inquiries, or finding out more information about the H2OChills brand water floats can be found at www.h2ochills.com and www.waterbosom.com, or to follow the company: www.facebook.com/pages/H2OChills/309039202455170 and http://twitter.com/#!/H2OChills.
About H2OChills:H2OChills is an exciting company that makes the best products for fun, relaxing times in the water. For all those boaters, beach bums, beach bunnies, swimmers, sailors, surfers, and sand lovers, we offer innovative new products for recreational use in a wide-variety of water environments. Perfect for those hot days when you just want to chill in the water!www.h2ochills.com
Like what you read?
Want to know when we have important news, updates or interviews?
Join our newsletter today!
Send to your friends!


text:
Fabian Cartwright
Henry VHD
IMDb: 7.7
137 min
King Henry V of England is insulted by the King of France. As a result, he leads his army into battle against France. Along the ...
Country: UK
Actor: Derek Jacobi, Kenneth Branagh, Simon Shepherd, James Larkin, Brian Blessed, James Simmons, Paul Gregory, Charles Kay, Alec McCowen, Fabian Cartwright, Stephen Simms, Jay Villiers, Edward Jewesbury, Ian Holm, Danny Webb


text:
Set the mood at your next barbeque, pool party or picnic with MobiOut, a splash-proof and rugged yet elegant Bluetooth speaker that combines high-fidelity sound with wireless portability. MobiOut is sturdily constructed to withstand a few knocks and bumps, and contains a passive radiator that provides deep, resonant bass. Control your music and calls with top-mounted volume and playback buttons that are sealed to keep water out. It also contains a hands-free speakerphone with a built-in microphone so you can even take calls. What's especially unique about MobiOut is that it features Jump-Start Technology, which means that you can use it as an external power source to charge your phone. It can be frustrating when your speakers are charged but your phone isn't, so we added this additional feature to improve MobiOut's functionality.
Spend Worry-Free Hours by the Pool
MobiOut was meant to go outside. Designed with a rugged construction and sealed controls, this little speaker is hardier than you think. Take it with you confidently to the pool and lounge comfortably knowing that it won't sputter and die with the smallest splash.
Please the Crowd with Powerful Sound
You won't know until you try it for yourself, but take it from us - MobiOut has great sound. It's equipped with 2 full-range speakers for high-quality acoustics, and a passive radiator for satisfyingly deep bass. First and foremost, MobiOut is an amazing speaker that won't disappoint.
Jump-Start Your Phone with Jump-Start Technology
When your phone is out of juice, restart it with MobiOut. MobiOut features what we call Jump-Start Technology, which allows you to use MobiOut's lithium-ion battery to directly charge your phone. Because there's no point in having a fully charged speaker when the source of your music is dead.
Never Miss a Call with Handsfree
MobiOut is fitted with a built-in microphone and speakerphone so you can have convenient hands free conversations at the touch of a button. When you?re finished with your call, return to your music by hitting the same button. Never miss a call again, even with the music pumped up.
Listen for Hours on a Single Charge
MobiOut is equipped with a lithium-ion rechargeable battery that will give you up to 9 hours of uninterrupted playtime on a single charge. How many songs is that?


text:
I've been online most of the day, probably from around 1:30pm till 00:35am (UK Time) and its finally happened, I've been able to add the Minfernal pet to my list! Weeeeeeeeeeeeeeeeee! :D! and the best part is, the only spawn that was there was mine, no-one tried to gank me, (which has been happening alot today...), no-one else farming, literally just me and him. The bonus part is that it was a RARE, SAY WHAT! So I get to keep my flawless magic pet stone for now.. not sure who to use it on.
|Co-ords approx 41,44 SouthEastern part of Shattered Vale
I think my breakthrough for getting it was changing tactics on my 'rage random killing' which involved both the infernals and fire elementals around the Shattered Vale, and also the rat critters I found. I have been doing this for AGES thinking that was the way forward, my theory was kill the stuff to make new stuff appear. Naturally I got 1-2 catchable rats every hour or so, but I accidently killed one of them, making me think, what if I killed the catchable pet spawns in the zone? Surely that is the way to get a catchable pet, you wipe out the rest to make new ones spawn, and I'm now sitting here able to talk about my new pet...coincidence? Try it yourself and pleaseeee let me know, I'm going to try for the Scourged Whelp using this 'theory' (more like grasping at straws to keep me entertained while farming... :D)
The feeling of getting some rare in game is always so frantic and a completely insane heart pounding moment, definately in this case, hope to update with another whelp related post soon, but I am more than happy with my Minfernal for now, can't wait to level him!
So with the new addition, current pet total is 498!
Off to Icecrown to stalk some dragons...gonna be a late one!


text:
I am the happiest person right now, I can't believe weekend is already here!
Yay, I am finally done with my phase test and presentation and I actually managed to get a really great grade, couldn't be happier about it! Now all I want to do is relax, blog and relax again. Hope you all had a great week and an amazing Valentine's day. How did you celebrate it? For us a movie and a diner at home was the best idea ❤
I think there is something extra special and unique when you combine this sweater with a bow shirt! I don't know if it's just me, but in my opinion bow shirts add such a chic and sophisticated touch to every outfit. I love wearing skirts and I was so happy the wind was finally on my side that day. My black heels were the perfect finishing touch for this outfit!
I am wearing:
Sweater - Tally Weijl
Shirt - New Yorker
Skirt - Missguided
Heels - New Look
Bag - Primark
Rings - Warren James & Primark


text:
We are here for you. Spiritualvisit.com family is there as Matura. We will visit the Shree Bankey Bihari temple on your behalf. Seek Lord Krishna blessings. And, will send you Prasad in return from there.
You can seek these divine blessings of Lord SHREE KRISHNA along with your family.
To get Prasad from Bankey Bihari Temple, please visit http://spiritualvisit.com/index.php?route=product/product&path=81&product_id=127
Spiritualvisit.com not a temple representative. We act as your representative to offer & deliver Prasad to your doorstep. The price of Rs. 501 will be used to buy and offer Prasad at the temple. And, to cover all miscellaneous costs such as -
• Packaging,
• Professional handling and logistics,
• Shipping,
• Payment collection, and
• Government taxes
Please feel free to give us a missed call at +91 801-010-1997 for any questions.


text:
Chris Young Donates Audio Equipment to Alma Mater
Chris Young has become known for his philanthropic work to better music education, and he just continued in that work, donating some of his own audio equipment as well as other accessories to his alma mater. Now, Middle Tennessee State University's Department of Production Services can offer even better music education to their students, and they have one celebrity country singer to thank for that.
"MTSU has been a great supporter over the years, and I'm glad for the chance to share this equipment with the University's music and production students," Young told the Tennessean. And the school was equally glad to be on the receiving end of the transaction, which will help serve more than 100 MTSU students.
"We are pleased that Chris chose to donate some of his touring equipment to the University," Joe Bales, vice president for development and university relations, said. "This donation represents his latest efforts to give back."
The donation is just one of many moves Young has taken of late to further music education in Tennessee. He most recently hosted the third annual CMA Keep the Music Playing all stars concert Jan. 31 at Nashville's Schermerhorn Symphony Center. The show featured performances from five area school groups and saw a donation pledge of $1.4 million from the CMA Foundation to bolster the music education programs in Nashville's middle schools.
Young is currently up for two ACM Awards for Male Vocalist of the Year and Single of the Year with 'Tomorrow,' and he's kept busy on the road with Miranda Lambert's 'On Fire' tour. His single 'You' just became his fifth straight No.1 hit.


text: In Greenville we currently have one plumber and related contractors. CallaPlumber.net features the following plumbers in FL. Select a plumbing contractor serving the city of Greenville for additional information on the business including details on the plumbing and related services provided by each contractor plus additional contact information, maps and directions.


text:
Wyatt robs banks, and lifts payrolls. Most men like him are dead or in gaol. But Wyatt stamps a cold, pitiless style on his heists - and makes sure that he never gets caught.
Now his funds are low and his luck is running out - until the day Anna Reid explains about the kickback in her partners's safe. Other players are involved: Bauer - who learnt his trade shooting blacks in Southern Africa; Ivan Younger - small-time boss; Sugarfoot Younger - sullen urban cowboy.
In the world of Kickback there is no yielding, no redemption. When Wyatt is crossed, the outcome is inevitable.


text:
Espa ol
The best thing to come out of the first Persian Gulf War was Sufi scholar Faouzi Skali's idea for a World Sacred Music Festival in Fez, Morocco, now in its 14th year. The philosophical underpinning is to bridge differences between Islam and the West—there's a serious conference and lecture series as part of the 10-day-long festivities—but it's just plain fun to immerse oneself in glorious music from all corners of the globe, presented at different venues around the world's biggest, bustling medina.
After a disappointing opening night at the biggest venue, Bab El Makina—Afro-American soprano Jessye Norman was consistently flat while delivering Bach and Handel arias, in addition to being out of synch with the orchestra, and only fared a little better when doing a few gospel tunes—things bounced back the following day at an afternoon concert in the geometrically tiled courtyard of the Batha Museum. Underneath the gigantic oak, Lebanese singer Ghada Shbeir offered Christian chants from the first to fourth centuries A.D., many of which were sung in Aramaic. Her supple, clear voice was accompanied only by a qanun (zither), a non-well-tempered instrument, deliciously peppered with quartertones. At one point, there was an exquisite relay between qanun and voice of mesmerizing melismas.
The Festival programmers like to play matchmaker with groups not normally heard together, expressing the festival's goal of common ground. This year they brought together Craig Adams and the Voices of New Orleans and Pakistan's Faiz Ali Faiz, bringing together black gospel and qawwali. After presenting sets separately, the two came together near the end and better than expected—a buoyant, syncretic affair that did its job well enough without a whole helluva lot musical daring.
More of Faiz Ali Faiz's qawwali artistry was on display, undiluted, as part of  Sufi Nights, which occurs at 11pm each night in the gardens of the palace Dar Tazi.  Faiz is clearly the heir of Nusrat Fateh Ali Khan, and offered a joyous night of layered sound, ecstatic relays between different voices and instruments, plus other phenomenal details of ever-changing vocal textures.
Back at Batha, I was treated to a Lapp singer from Norway, Mari Boine, the musical ambassador of the Sami people who have animist tendencies. This interesting tradition was fused with some jazz elements, as in the song "Brother Eagle" in which a Miles-Davis influenced trumpet player flickers his tones, some of which are sampled and recycled, with Boine's voice. She's capable of extended vocal techniques, and can do some "Joik" throat singing. She also did some rather earthbound Lapp dancing.
Another highlight at Batha was the Malian group Tartit. Composed of five Tuareg women and four men, it was interesting to note how physically similar the women were:  light-skinned, broad open faces, sensuous lips, and beautifully beaded and braided hair. Sisters and cousins? The men, however, looked ethnically distinct: tall, thin, and darker—and they cover their faces, not the women! The women play the drums and clap hands, while singing with mesmerizing voices, occasionally producing those high shrills Arabic women are famous for. Absolutely hypnotic.
RSS Feeds
RSS Feeds
Contact us |
Press Room |
Contests |
About Global Rhythm magazine |
Advertise / Media Kit
Privacy Statement |
Terms of Use |
Global Rhythm Contributors |
Link to Us |
Back Issues
Copyright © 2008 Zenbu Media. All rights reserved.


text:
Anise Candy
5 Items
- Anise Jelly Bears - 5 lb.$21.63Out of stock
5 Items
People either love anise flavor or they hate it, so haters, look elsewhere while we talk to the fans.
If you love anise, this is where you will find the tried-and-true favorites, the time-honored treats that have been beloved for decades. We carry Anise Mints, Anise Squares, Anise Bears (like the ones your grandmother probably had), and Edas Sugar Free Licorice in bulk.
Did you know that anise is an herb that is often used to soothe upset tummies? If you needed an excuse to order, there you have it.


text:
BAFTA New York Elects new Vice Chairman
BAFTA New York is pleased to announce the election of Board member Charles Tremayne
to the position of Vice Chairman of the Board of BAFTA New York.
Charles has been Chair of the Television Committee for the past three years and was responsible for the very successful TITANIC evening among many other events.
The Vice Chairman is elected by the current Board and takes on the role of Vice Chairman, replacing the current retiring Vice Chairman. After one year the current Vice Chairman will step up to serve as Chairman of the BAFTA New York Board.


text:
A?huge collective sigh of relief was heard around Bluffton and even all of Beaufort County as a section of Bluffton Parkway was officially opened to traffic this week.
The 1.2-mile, four-lane divided road extends the parkway from Burnt Church Road to Malphrus Road.
It may seem like a small step to some, but opening up another way for motorists to avoid U.S. 278 is a good step all the way around.
Transportation is critical and finding a way for people to travel to and fro without the anxiety of using just one major artery is a victory in our eyes.
The opening comes at a time when tourists already have descended on the area and their desire to travel without impediments or construction is evident. We know there are plenty of residents and tourists who use U.S. 278 because they are frequenting the outlet malls or live on that side of town. They also will find better travel patterns as the congestion is sure to lessen with another option open.
Completion of the project - known as Phase 5A Segment 1A - comes at a time when all eyes are on how local, state and federal dollars are being spent on road projects. And rightfully so with only so much money in the transportation pot.
This section of the parkway came with a price tag of about $11.5 million and work was done by a local company. Cleland Site Prep of Ridgeland was awarded the contract in August 2010.
Prioritizing which projects come first and move to the top of the list is often political and leaves some scratching their heads.
The Bluffton Parkway is an important roadway for Bluffton, Hilton Head Island and visitors working to make their way off Interstate 95 to Hilton Head without shooting straight up U.S. 278.
There are plenty of other road projects that need support. But the parkway is one we can get behind and support.
The next phase of the parkway project is Phase 5A Segment 1B from Malphrus Road to Buckingham Plantation Drive. This section is expected to be completed by August.
Bluffton Parkway has evolved and with it has come retail, commercial and residential development. All good signs of a healthy community that is doing its level best to plan for growth and development.
A wrong decision by the Hardeeville Municipal Election Commission has cost the city of Hardeeville up to $1,500 - so far.
That's the amount city agreed to pay City Council candidate Scott Ready's attorney for representing him in his appeal of a wrongful disqualification by the local election commission.
We understand that officials agreed to the settlement to avoid a lawsuit and potential other costs associated with such a lawsuit. But we also know the city attorney and city clerk attempted to give counsel to the three-member local election commission before it made the decision on March 15 to rule Ready ineligible. They apparently would not take any advice.
It took action by a 14th Court of Appeals judge on April 3 to reverse the commission's decision and declare Ready a candidate.
Next comes the State Ethics Commission and an expected May hearing in Columbia.
We don't know if Ready's complaint filed March 16 alleging conflict of interest by the local election commission because the chair of the group is the mother-in-law of a member of City Council seeking re-election on May 8 will result in a fine or even any reprimand at all. But we do know that since the local election commission is appointed by City Council, whatever the end result is, it will affect the city - and it should.
The time and energy spent on the issue is taking focus away from important issues like economic development, education, road projects and even every day work.
It's time for the local election commission members to admit their error and to step down. They have no credibility and the city has paid enough already.


text:
Message Board
Sue Haasler Message Board
Talk about the novels, new and used books that Haasler has written!
Author Haasler's Book Reviews
Time After Time
St. Martin's, Mar 2004, 13.95, 263 pp. ISBN: 0312306431 In the London vicinity, Cass Thomson is struggling to come up with a fiscal plan that will save historic Coltsfoot Hall, a former family manor converted into a museum before realtors kill history again by turning the place into the latest sprawling development. If she fails not only will the former manor house be gone and she out of a job, she will need a place to live as she resides inside...


text:
Physicians have primum non nocere – a Latin phrase that means "First, do no harm". (Thank you, WikiPedia.) I think for techies, our principal precept is primum RTFM. (Here's more Wikipedia, if you missed the joke.)
I don't know as much about SQL Server as I should, or as I would like. I have at my disposal uncounted blogs, books, articles, magazines, seminars, webinars, deep-dive courses, conferences, MVPs, forums (fori?), and #SQLHelp on Twitter. This wealth of information is a great blessing, but it carries with it the curse of the information age: What to read, and when, and why, and for how long? I have neglected the basics…I have not primum RTFM. Brothers and sisters, it is time that I start.
For the next year, I will read from SQL Server Books Online - the FM, in this case – a little every day, and blog about it weekly. Is this project sexy? No. Exciting? Not so much.
Useful? Educational? Interesting? You bet your Shasta.
Here is an excerpt from an email with Don Gill (Twitter, blog), the primary POC for BOL content. Don spoke about this in our interview at PASS Summit 2010, so I'm going to presume he's good with the reprint. (All emphases are mine.)
…the most recent release of BOL was approximately 8.5 million localizable words (eg, non-boilerplate, precanned), was translated to 12 core languages with portions translated to a total of 23 languages world-wide. In addition to BOL itself, SQL content ships in partnership with Office, Windows, Visual Studio, the .NET SDK and several standalone applications (eg, Reporting Services, Data-Mining Plugins, Dashboards, etc). As a frame of reference for visualizing the size of BOL, the King James version of the Bible only has 775K words (though it is undoubtedly translated to more languages than BOL). Tolstoy's "War and Peace" (translated to English) has only 560K words. Simply put, we write, augment and maintain "War and Peace" from beginning to end, more than 15 times in a given two to three year period.
8.5 million words…the mind boggles.
There's no way I'll get through all of BOL in a year. There's very little chance I'll hit every major area of BOL. But I intend to learn quite a lot, just by reading TFM.
Come on boys and girls, sing along, okay? Download SQL Server Books Online from Technet, and follow along with this blog series via the RTFM365 tag.
Happy, informative days,
Jen McCown


text:
The Pilot Shortage Crisis Is Nigh! Or Not
People in the aviation industry have been talking about a looming U.S. pilot shortage for decades, but you may be hard pressed to find anyone in the U.S. who's actually experienced one during the past 20 years.
Actually, 20 years ago, I remember receiving materials from an outfit that explained just how strong the demand would soon be. Now, the warnings are back (if they ever went away). So, should you believe them this time? If you think the hype is overblown, you're not alone.
"Shortage" is relative, and if history is any indicator, any future shortage may depend more on real world market conditions than projections developed years earlier (a.k.a., today). For example, if there were any projections for a shortage this past decade, market forces turned that shortage into massive furloughs that took place around 2003 and slashed benefits for many pilots lucky enough to keep their jobs through that decade. Back then, Northwest Airlines was on pace for 1,068 total furloughs. United and Delta had actually each hired furloughed pilots � to serve as furlough administrators. Not long after that, in 2008, the world's economy fell off a cliff.
Now, as the economy recovers and the the major carriers forge ahead, the picture remains complicated. Shortly after the majors began to shrink, the regionals grew. The practical result is that one trend may now start to reverse. The majors are regaining their footing following a series of mergers (recall Delta and Northwest circa 2008; United and Continental in 2010; and American and US Airways just this year) that created the largest carriers in the world. They've been re-absorbing pilots furloughed in the last decade and could expand their service to take back some that the regionals had grown to acquire. That suggests more pilots could be needed for the majors, but fewer for the regionals. Don't think the complications end there.
Warnings, Predictions, Concerns
In 2010, a panel of "experts on pilot hiring and screening" told the NTSB that over the next decade airlines will need to hire "about 42,090 pilots," AP reported. The figure was predicted as the result of both retirements and industry growth. Participants also told the NTSB that fewer military pilots would be leaving their positions for jobs with the airlines and, because they see it as an economic cul-de-sac, careers in aviation are attracting fewer college students. Airlines, the experts said in 2010, are fighting with corporations for pilots.
In 2012, Boeing forecast that almost 70,000 pilots will be needed in North America between now and 2031. The global demand would be more than six times higher than that, it said. In the states, demand would be affected by a confluence of events. The FAA raised the mandatory retirement age for pilots from 60 to 65 on Dec., 13, 2007, which suggests that affected pilots would be forced into retirement starting last year. That couples with forecast growth at the majors and more stringent pilot training requirements at the regionals.
The training rules are expected to go into effect in late summer 2013 (more on that, later), but one year ago they already had the FAA's director of flight services, John Allen, concerned about the affects of fast-growing demand. "I'm concerned because it has safety implications," Allen told The Associated Press in July 2012, "someone getting into the system that maybe isn't really the right person to be a pilot."
The Pilot Pool
As for attracting new pilots, a quick trip around the web might find you a professional flight school like one we found in Florida. A page currently on the school's website shows a graph of "commercial and airline pilot salaries." Of six companies listed, including American Airlines and UPS, four have starting salaries of $36,000 or less. It should be noted, however, that among them is ATA -- which declared bankruptcy and ceased operations in 2008. (This suggests that the numbers presented to prospective students may be less current than their placement would suggest). The other five companies sharing real estate on the graph do still exist. And while the starting salaries posted there may suggest why young people could see airline pilot jobs as a financial dead-end, the graph also shows figures for 10th year captains. All of those, according to the flight school, earn more than $120,000 per year and two clear the $200,000 mark.
At this point it may be worth noting that, as a pilot training center, the company that provided these figures is in the business training pilots. That also means it's in the business of finding pilots to train. It does support a webpage that states "airlines are hiring pilots and demand for airline pilots continues to grow" and is candid that India, China, and Middle Eastern airlines will see strong growth.
At best, this is predictive economics. At worst, its crystal ball fortunetelling delivered by people who could see financial gains from the information they deliver. Here at AVweb, we've seen a number of reactions -- both formal and informal -- to the current economic and regulatory state of affairs in the airline industry and projected future hiring.
Regulating Competence
Most recently, Kent Lovelace, chair of the aviation department at the University of North Dakota (UND), this month told AVweb that the law not yet in force (and noted above with regard to the Boeing forecast) is already having an effect. Referring to the law that would require first officers of regional aircraft to hold at least an ATP certificate, Lovelace said regionals already have started to reject applicants who aren't likely to hit the 1,500 hour minimum by summer. He also said that the law (that's scheduled to take effect this August) was causing some students to choose a different career path. The result, he said, was that the applicant pool for some regionals already had shrunk "to where some carriers, the usable applications they have on file are virtually nil." Among AVweb's audience, Lovelace's opinion quickly found its critics.
In response to Lovelace's comments one reader wrote, "as one of the qualified pilots with no intention of flying for free, I can assure you the regionals will see a shortage of 'qualified' applicants only because I can make more than their senior captains as a commercial pilot." The pilot then argued that any increase in the experience requirements for pilot applicants at the regionals should logically correspond with higher entry-level pay at the regionals. He'd checked on that, he said, and it wasn't happening.
And then there was Brant Harrison. Harrison is a pilot flying for a regional carrier. Like many currently employed pilots working the low end of the pay scale, he's been waiting for the forecast pilot shortage with great anticipation. Pilots like him have invested thousands, or tens of thousands of dollars in civilian pilot training. Some have gone through intensive pilot training academies, coupling their aviation education with a college degree and bringing debts in the range of 100s of thousands of dollars. Many of those pilots have now been sitting for years in low paying jobs with little apparent mobility. Some have also been sitting with loan repayment that began once they left school.
Balancing Budgets
Harrison's observations are that the civilian path to a job in an airline cockpit often begins with a job in flight instruction. From there it may advance to one flying night cargo, and from there, to a job flying for the regionals. Mirroring the comments of our aforementioned AVweb subscriber, Harrison notes that the career path means that once at the regionals, pilots might well start with a lower salary than they held at their last job. In his experience, that translates to starting pay somewhere near the $19,000 to $24,000 range. That's for a pilot who, if nothing changes, will by this summer need to have a minimum of 1,500 hours flight time before being hired and could need a college degree before flying for the majors.
Harrison describes the regional carrier job is an entry level position that follows a series of entry level positions in the same industry. "I saw my peers � instructors who had spent tens of thousands on flight training and I could see how difficult it was for them. By then," he said, "some had families."
Harrison concedes that the first year at a regional is considered probationary. Salaries jump the second year � "usually to the $25,000 to $35,000 range," he says, with a slow climb of one or two thousand dollars each year after that spent flying as a first officer. "It takes upward of six years before you move to a regional airline. A lot of guys arrive in their late 20s and early 30s. When they get in, they're in debt, and they're starting at $1,800/month." And in Harrison's experience, they'll be flying the right seat at the regional for another five years, on average.
The goal of it all is to make it to the major airlines. If and when he's selected by one, Harrison expects his starting pay to fall within a $45,000 to $60,000 range and then quickly move to something closer to $70,000 to $110,000. If all goes well, Harrison expects that his career with the airlines could see his salary peak at anywhere from $100,000 to $200,000. "But," he says, "that's the last five to 10 years of your career."
Boots On The Ground
While flying for a regional carrier and waiting for the great pilot shortage to occur, Harrison has taken his own look at the numbers. He's authored his own 170-page report and discussed it with AVweb earlier this month. Following up with him this week, Harrison said that from his perspective the pilot job market looks different from what forecasts and what he termed "rumors" suggest. In his view, the numbers don't necessarily bear out an impending pilot shortage crisis.
Contrary to what experts told the NTSB in 2010 and what UND's Lovelace said just this year, Harrison thinks that the situation at the regionals isn't what most people would call a looming pilot shortage. In his view, following massive furloughs and restructuring at the airlines, the landscape is more of a basic economic curve that "is finally getting back to where the supply is matching the demand." Toward that end, Harrison believes the market is doing what it does and "those guys who are applying may not have as much trouble finding jobs." But looking ahead, he doesn't put too much faith in any talk of an impending pilot shortage crisis.
Harrison's research is based strongly on aircraft orders. It told him that total pilot demand among all carriers, regional and airline, would amount to 632 pilots this year, based on fleet growth and attrition. His math says that the numbers jump up to 2500 by 2019 and may reach into the 3-4,000s beyond 2021. "You can't get a perfect outlook,' he says. But, in the end, Harrison says his figures match well with Boeing's projected fleet growth of about 1.4-percent domestically, each year for the next 10 years. Where he may disagree is in the new staffing required to support that growth. In Harrison's view, the personnel required by the airlines will not produce a pilot shortfall that can't be met by natural market reactions.
In The Real World
As it is, Harrison says "the last few years, things have stagnated. The over-60 rule should have brought attrition last year and into this year." But other factors have had an impact on the jobs market and upward mobility for pilots. "The regional industry saw explosive growth in the last decade. That led to quick upgrades for pilots moving from the right to the left seat, but when that came to a stop, and oil prices climbed, and all sectors were depressed�. What had been a 2-3 year stint in the right seat grew to six or seven before pilots moved left."
At the same time, the majors were shrinking. "They furloughed pilots and and those that weren't furloughed at the majors saw their road to the left seat of an airliner stretch as high as 20 years," says Harrison. "The good news now is that the majors are done with cutting and now are looking at long slow steady growth at about 1.4-percent. That could push the promotion timeframe for copilots seeking a captain position back down into the low teens." But there are still complications.
"If the regionals slowly shrink over the next five to six years, that will make up for some of the loss of pilots to the majors," says Harrison. In his own model, Harrison sees the majors growing enough "to hire off the street," and he expects market forces "may put pressure on the right seat at regionals" that could translate to opportunity for pilots moving into the regionals. Even then, Harrison thinks those pilots can expect to spend three to six years at the job before moving up to the majors.
In short, from his position inside the industry, Harrison's outlook is not nearly as bullish as that of some of the major players who are currently raising concern over a looming pilot shortage. He has, however, grown "cautiously optimistic about the industry as a whole." Harrison says he hopes his view (and report) simply provides "a more realistic view of what people can really expect." "It's going to be a competitive environment. Thousands of pilots will be seeking major airline jobs � it's going to be competitive and that won't change until early next decade."
Finding Answers
Within the regional industry that could force compensation packages up to meet a rising demand, but even there, the outcome may not be so simple. "The contract system in the regionals tends to slow the adaptation to new the new cost realities of supply and demand." Harrison believes the market will react, but maybe in other ways.
"The pilot pool is becoming something that the airlines will need to pay attention to," says Harrison, but that doesn't necessarily mean more pay. "I imagine it's very possible that we could see loan enhancement programs that allow selected pilots to move through the system more easily. If the airlines don't want to flex on compensation, then loan repayment, or better rates, or a guaranteed pipeline are also forms of compensation that airlines may use to facilitate supply."
Bottom line? ... Stay tuned.