In Master Page Replace everything in <asp:ContentPlaceHolder id="PlaceHolderLeftNavBar" runat="server"> with

      <ASP:TreeView ID="CurrentNav" runat="server" datasourceID="SiteMapDS"
        AccessKey="3" CssClass="leftNav" ExpandDepth="1"
        SkipLinkText="<%$Resources:cms,masterpages_skiplinktext%>">
      </ASP:TreeView>
      <PublishingNavigation:PortalSiteMapDataSource ID="SiteMapDS" Runat="server"
       SiteMapProvider="CurrentNavSiteMapProviderNoEncode" EnableViewState="true"
       StartFromCurrentNode="true" StartingNodeOffset="0" ShowStartingNode="false"
       TrimNonCurrentTypes="Heading"/>

We striped out some of the item level tags and chaged from a sharepoint:aspMenu to a ASP:Treeview.  Then we need to tweak the web.config. Add 'RequireUniqueKeysForNodes="true"' to CurrentNavSiteMapProviderNoEncode to make it look like this.

<add name="CurrentNavSiteMapProviderNoEncode"
   description="CMS provider for Current navigation, no encoding of output"
   type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral,PublicKeyToken=71e9bce111e9429c"
   NavigationType="Current" EncodeOutput="false" RequireUniqueKeysForNodes="true" />

reset ISS and roll

I found this great post and man is it helping me do some simple formating of sharepoint lists.  CHeck it out i have also attached a word doc with the content in case it ever disappears.

http://pathtosharepoint.wordpress.com/2008/09/01/using-calculated-columns-to-write-html/

my favorite ="<DIV><IMG src='/_layouts/images/KPIDefault-"&(IF([Days Till Due]>7,0,IF([Days Till Due]>2,1,2)))&".gif' /></DIV>" with days till due a calc column =[Due Date]-Today

CalcColumnFormating.docx (98.92 KB)

TextToHtml.js (1.26 KB)

(from http://office.microsoft.com/en-us/sharepointtechnology/HA101215881033.aspx )

Formulas overview

Formulas are equations that perform calculations on values in a list or library. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result.

=5+2*3

You can use a formula in a calculated column and to calculate default values for a column. A formula can contain functions (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.), column references, operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.), and constants (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.), as in the following example.

=PI()*[Result]^2

A formula might use one or more of the elements from the previous table. Here are some examples of formulas (in order of complexity).

Simple formulas (such as =128+345)

The following formulas contain constants and operators.

Formulas that contain column references (such as =[Revenue] >[Cost])

The following formulas refer to other columns in the same list or library.

Formulas that call functions (such as =AVERAGE(1, 2, 3, 4, 5))

The following formulas call built-in functions.

Formulas with nested functions (such as =SUM(IF([A]>[B], [A]-[B], 10), [C]))

The following formulas specify one or more functions as function arguments.

Other Great links

http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx

http://office.microsoft.com/en-us/sharepointtechnology/HA101054791033.aspx

So you want to use the Today function in a calculated list column.  Well here's a way to trick sharepoint into letting you use it, when it says it won't allow it.  First create a string cloumn named Today and save the list.  Now create a calculated column named GetDate and but Today as the calculated field.  Now we delete the today column and ta-da the GetDate column will always have todays date in it.  We do this so we don't have to keep adding the temp Today field every time we edit the list item with a calc field using the today function.  Now this is different from creating a data field and setting the date to current date, this date will stay set after it have been filled out.

So you want to get rid of your left nav in moss.  Well the first way to do this would be to create a webpart page with no nav.

1)View all site content
2)Create
3)Web part page

This one will have no nav so you should be looking good.

Now say this page still doens't work for you, but you don't want to have to work in designer of customize any HTML.  A little trick is to hide some css styles in a content editor web part. Paste this snippit into a it and to-da your left nav will be hidden away

<style>
.ms-quicklaunch
{
display:none;
}
.ms-navframe
{
display: none;
}
.leftNav
{
display: none;
}
.leftNavSpacer
{
display: none;
}
.mainContainer
{
width: 100%
}
</style>

For those of you looking inot building up a custom app with sharepoint as the platform here's a good start.

http://www.microsoft.com/downloads/details.aspx?FamilyID=5474a014-0298-4c45-a8f4-f3e38abfc424&DisplayLang=en

Have you ever used webservices in Infopath and then needed to move then to a new enviorment with new urls.  Wells here's a way to script it out, other have done the work I'll just put the links in for you to use.

Use a scripting tool called xsnFixup.js http://msdn.microsoft.com/en-us/library/bb608315.aspx

If you need some help with you xPath here's a tool a college sent me and here's the location of the creator's site.

http://weblogs.asp.net/nleghari/articles/visualxpath.aspx

Have you ever used webservices in Infopath and then needed to move then to a new enviorment with new urls.  Wells here's a way to script it out, other have done the work I'll just put the links in for you to use.

Use a scripting tool called xsnFixup.js http://msdn.microsoft.com/en-us/library/bb608315.aspx

If you need some help with you xPath here's a tool a college sent me and here's the location of the creator's site.

http://weblogs.asp.net/nleghari/articles/visualxpath.aspx

Have you ever looked at your SQL server and found a huge LDF file sitting out there?  Well the other day i found a 14 gig one just eating up space.  If you work with sharepoint you can find some very large ones if the sql server wasn't config right.  SO here is a quick how to with screen shots on eliminating your log files from SQL server.  Good luck...

Here are some of the url switches i have found useful in MOSS 2007.  I swear i had displaymode=edit working once but i can't seem to get it working now, also the mode=edit dosn't seem to be working. 

To change everyone's view of a particular page, append ?PageView=Shared&ToolPaneView=2 to the URL.

Contents=1  This is probably the most useful of querystrings. Using this on any "Web Part Page" will take you to what is called the "Web Part Page Maintenance" page (screenshot below) which allows you to delete web parts from both personal and shared views. This feature is especially useful if you have added a misbehaving web part. In this situation you can find yourself in a "chicken and egg" situation, whereby you can’t access the page to remove the web part because the web part you have added is causing an error on the page.
Mode=Edit This flips a "Web Part Page" into edit mode, its the same as clicking on "Edit Page"
Mode=View This flips a "Web Part Page" into view mode, it’s the same as clicking on "View Page"
PageView=Personal Displays your Personal view of a "Web Part Page", this is the same as selecting "Personal View" from the "Modify Shared/My Page" dropdown.
PageView=Shared Displays the Shared view of a web part page, this is the same as selecting “Personal View” from the "Modify Shared/My Page" dropdown.
ToolPaneView=2 Shows the "Add Web Parts" toolpane, allowing you to drag and drop web parts onto a "Web Part Page".
ToolPaneView=3 Shows the "Search" toolpane, letting you search through the web part galleries before adding a web part to the page.

Heres a sweet trick to be able to treat the GAC like any other folder.  Including droping PDB file in there so we can attache to a process and debug. (MOSS Workflows)

Create a short cut and paste in this for the destination, THATS IT.....

%systemroot%\Assembly\GAC_MSIL