Tuesday, May 25, 2010

Shared Apartment Expenses Spreadsheet Template

Where can I find a copy of a shared living space expenses spreadsheet template? Right here of course! I've created a new template for my Shared Apartment Expenses spreadsheet. Please email or comment if you would like a copy. This is the first version of this document. I could use some good feedback while I am improving and working on a new version. Is it easy to use? Are there any features you would like to see added? Do you care about the statistics or not? This is a good companion spreadsheet to my Apartment Search template.

Monday, May 24, 2010

Updated Apartment Search Spreadsheet


Based on recent users suggests and feedback I have made a few additions to my Apartment Search Spreadsheet. Many of these suggestions I had never heard of before, mainly due to the fact the reader lives in a different geographic region than I do. The following is the complete list of additions:


-Added "Gym / Fitness Center" to the Yes or No options. Duh. Can't believe I forgot that obvious one.

-In the input info, added rows for "Square Feet (Bedroom 1)", "Square Feet (Bedroom 2)", "Square Feet (Bedroom 3)", "Square Feet (Living Room / Dining Room)". The reason for this is that if you are sharing an apartment with roommates they may have a different requirement for bedroom space.
 

-In move-in fees, I added "Credit Check Fee". In the states, it is very common for landlords to charge a nominal fee to check a prospective tenant's creditworthiness (cool word bro, creditworthiness).
 

-In some major metropolitan areas, such as New York City, it is very common to install a pressurized wall in a bedroom or living room so you can squeeze one more person into the apartment and decrease living costs. Usually these walls are leased, as they are temporary and must be removed before the lease is up. Sometimes they aren't even allowed. Thus, I added a "Pressurized Wall Lease / Month" in Monthly Expenses, "Pressurized Wall Installation Fee" in move-in fees, and "Pressurized Wall Allowed" in the Yes or No Options.
 

-I also added a "Rent Controlled" in Yes or No Options. Some apartments are rent-controlled to protect tenants from massive rent increases when their lease is up and they wish to renew. Of course, these apartments are extremely coveted. There are other places which have rent-controlled apartments, but apparently New York City is the most well known for it.


Hopefully now the apartment search spreadsheet can accommodate an even larger percentage of the population and address each individual's needs. Do you have any other suggestions? As usual, email me or comment below for your copy of this latest version of the Apartment Rating/Search Spreadsheet.xls.

Wednesday, May 19, 2010

New Apartment Search Rating Spreadsheet


I recently completed a new and improved version of my Apartment Search Spreadsheet. Please leave a comment or email me if you would like a copy. The instructions are included within the spreadsheet. I would appreciate any feedback you have: is it easy to use, is there any information missing, anything suggestions you have to make it better.



This rating spreadsheet utilizes a simple house of quality to give each potential apartment an overall score based on several factors in which you give an importance rating. This way, items that are important to you contribute more to the overall score if they meet your requirements. I've tried to make the process as simple as possible through the use of drop down lists.




Also, I am putting together a job search spreadsheet. I need your help. What are some items you would like to see on this spreadsheet template? I have listed a few already such as: distance to home, salary expectations, relocation paid for, etc. What other information are you most interested in when searching for a new job and to help keep it organized?


Bookmark and Share

Monday, May 10, 2010

How do I clear rows in Excel spreadsheet with a macro?

Do you have a huge spreadsheet with a ton of rows that you need to delete each time you use it? Here is a simple macro to help you. This is for a spreadsheet that is password protected. Now, I have headers in row 1 and formulas starting in row 2 that I don't want to wipe away so I select the range starting in row 3.

Sub Clear_Rows()

''' Protect User Interface Only '''

ActiveWorkbook.Sheets("sheet1").Activate

Sheets("sheet1").Protect Password:="pass1", UserInterfaceOnly:=True


 

''' Clear Rows '''

Range("a3:xfd1048576").Select

Selection.ClearContents

Range("a1").Select

End Sub