ashPresentom: July 2008

MS Excel: formulas that make your work easier

Thursday, July 24, 2008 at Thursday, July 24, 2008 Posted by ashPresentom (aP)

# To return a latest value of a column. (the column can not have empty cells between 1st value and last value)

=INDEX(H8:H14,COUNT(H8:H14))

in this formula, the range H8 to H14 we will get the latest value or the bottom most value in the correspondent cell that hold this formula.

Explanation:
count formula here counts the number of cells that has values.
using index formula, we find the index value within the given range, in this case H8:H14, and we want the index value of the 5th cell that is from top to down (the last cell with the values), which is the value given from Count formula.

Gas price has its effect on indivituals: financial perspective

at Thursday, July 24, 2008 Posted by ashPresentom (aP)

Fair enough gas prices are going up day by day even though we saw a slight decrease of the price in past week or so. But gas prices has shown an exponential growth overall, rather average price graph over past 8 years.

I have been keeping track of grocery expenses in a spread sheet. In the past few months I was able to identify this increase in gas price clearly showing off in my spread sheet. Over past three months, April, May, & June; the groceries price per day per item value showed a clear integrated increase in my analysis of the expenses.

Even though you went to the grocery store and didnt identify much of a increase in food prices or even good prices, overall it has gone up. As you may know gas price increase causing good/food item prices to go up as in forms of transportation of goods, storage, etc.

There is a heavy need for alternative fuel source that we can rely on just like gas with less pollution and cost efficient.

Read more about environmental effects of gasoline prices and depletion of resources at http://apenvirom.blogspot.com/

Economy: A bigger-than-expected drop in existing home sales and Ford's worst earnings report ever weighed on the market

at Thursday, July 24, 2008 Posted by ashPresentom (aP)

Having passed a House vote, the housing bill -- revised with provisions for more explicit government guarantees of the mortgage agency portfolios -- is now headed for a Senate vote, which could come as early as Thursday.

Bill Gross, managing director of bond house Pimco, weighed in on the housing bill currently before Congress, calling the legislation that is designed to lower the cost of mortgage credit "the best way to begin the long journey back to normalcy" in the housing market.

New York Fed President Timothy Geithner, speaking before the House Financial Services Committee, warned that strong financial supervision will be needed to reduce the moral hazard of recent Fed and government backstops such as the Bear Stearns bailout and expanded capabilities of the Treasury and Fed to support the government-sponsored agencies.

Oil prices rebounded from their lows despite ongoing concerns about demand destruction as government data showed higher refined product supplies on Wednesday. August WTI crude oil futures settled $1.05 cents higher at $125.49 a barrel on Thursday.

Source: David Bogoslaw
Full Article: http://www.businessweek.com/investor/content/jul2008

Photoshop enpowerment: presentom

Sunday, July 20, 2008 at Sunday, July 20, 2008 Posted by ashPresentom (aP)

Newest experiment with Photoshop and Illustrator vector floral designs and its use effectively to generate eye catching graphic content. Such floral content could also be found as brush format, if you are interested in creating this type of a graphic with the minimum of effort.

This post contain copy right material, prohibited from reproducing or using without presentom's permission. This Graphic is exclusively a property of ashPresentom.