Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Tuesday, January 29, 2008 – Permalink –

Split the Costs

Split the sheets (?)


Joe Chirilov presents a spreadsheet solution to a friendship breaker.


Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the group. How do you efficiently handle paying back multiple people while getting reimbursed for your costs at the same time?



Split Costs

You can download the spreadsheet here:Split_Costs.zip




See all Topics

Labels: , , ,


<Doug Klippert@ 6:53 AM

Comments: Post a Comment

  Wednesday, September 26, 2007 – Permalink –

Send Your Template to MS

Geek fame


According to the Inside Office Blog, over 1 million people have downloaded free templates from Microsoft.


"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.



Upload your template



See all Topics

Labels: ,


<Doug Klippert@ 7:13 AM

Comments: Post a Comment

  Wednesday, May 16, 2007 – Permalink –

Calendars - Perpetual

It's that year again


One Month and One Year perpetual calendars are available.

These Excel file calendars do not use macros and can be used in OpenOffice or other Excel compatible software.

  • Perpetual calendars with Week starting on Sunday

  • Perpetual calendars with Week starting on Monday

  • A simple "universal" one month calendar that will update for any month and any year (after 1900) just by changing a date cell.

  • A "universal" one year calendar that will show 12 months starting with a user defined Month and Year.
    Start dates can at the beginning of any year and any month.


DotXLS.com:
Perpetual calendars


Microsoft:
How to make calendars



See all Topics

Labels: ,


<Doug Klippert@ 6:13 AM

Comments: Post a Comment

  Thursday, February 08, 2007 – Permalink –

1040 on a Spreadsheet

Free tax forms


All right, we spend our waking hours SUMming with Excel and then when one of the more stressful times of the year shows up, we turn it all over to TurboTax.

Here is a collection of IRS forms Glenn Reeves has done as interlocking spreadsheets.

The formulas are already set up; ready for data entry.
"No PASSWORD is needed!

If a cell is protected, it is because it contains a calculated value.

Many times, a manual override cell is provided if you need to override the calculated value.

After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it."



(Included on the site are forms back to 1996.)

http://www.excel1040.com

or

http://home.mchsi.com/~taxcalculator/



See all Topics

Labels:


<Doug Klippert@ 6:16 AM

Comments: Post a Comment