Difference between revisions of "Spreadsheet"

From NVCWiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
−
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+
<H1>Sheet 1: <EM>Donation</EM></H1>
−
 
+
<TABLE>
−
<HTML>
 
−
<HEAD>
 
−
 
−
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=utf-8">
 
−
<TITLE></TITLE>
 
−
<META NAME="GENERATOR" CONTENT="NeoOffice 1.2.2  (Unix)">
 
−
<META NAME="AUTHOR" CONTENT="CNVC">
 
−
<META NAME="CREATED" CONTENT="20060316;13034700">
 
−
<META NAME="CHANGEDBY" CONTENT="J Manske">
 
−
 
 
−
<META NAME="CHANGED" CONTENT="20060509;8415200">
 
−
 
−
<STYLE>
 
−
<!--
 
−
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }
 
−
-->
 
−
</STYLE>
 
−
 
−
</HEAD>
 
−
 
 
−
<BODY TEXT="#000000">
 
−
<HR>
 
−
<P><CENTER>
 
−
<H1>Overview</H1>
 
−
<A HREF="#table0">Donation</A><BR>
 
−
 
 
−
<A HREF="#table1">Person</A><BR>
 
−
<A HREF="#table3">Travel</A><BR>
 
−
<A HREF="#table5">IIT</A><BR>
 
−
 
−
</CENTER></P>
 
−
<HR>
 
−
<A NAME="table0"><H1>Sheet 1: <EM>Donation</EM></H1></A>
 
−
<TABLE FRAME=VOID CELLSPACING=0 COLS=9 RULES=GROUPS BORDER=1>
 
−
<COLGROUP><COL WIDTH=156><COL WIDTH=78><COL WIDTH=142><COL WIDTH=161><COL WIDTH=90><COL WIDTH=101><COL WIDTH=65><COL WIDTH=65><COL WIDTH=192></COLGROUP>
 
−
 
 
−
<TBODY>
 
 
<TR>
 
<TR>
 
<TD WIDTH=156 HEIGHT=17 ALIGN=LEFT>Wish</TD>
 
<TD WIDTH=156 HEIGHT=17 ALIGN=LEFT>Wish</TD>
Line 280: Line 243:
 
<TD ALIGN=LEFT><BR></TD>
 
<TD ALIGN=LEFT><BR></TD>
 
</TR>
 
</TR>
−
</TBODY>
 
 
</TABLE>
 
</TABLE>
−
<!-- ************************************************************************** -->
 
 
<HR>
 
<HR>
−
<A NAME="table1"><H1>Sheet 2: <EM>Person</EM></H1></A>
+
<H1>Sheet 2: <EM>Person</EM></H1>
−
<TABLE FRAME=VOID CELLSPACING=0 COLS=18 RULES=GROUPS BORDER=1>
+
<TABLE>
−
<COLGROUP><COL WIDTH=112><COL WIDTH=67><COL WIDTH=67><COL WIDTH=84><COL WIDTH=119><COL WIDTH=94><COL WIDTH=67><COL WIDTH=67><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65></COLGROUP>
 
−
 
 
−
<TBODY>
 
 
<TR>
 
<TR>
 
<TD WIDTH=112 HEIGHT=34 ALIGN=LEFT>Name</TD>
 
<TD WIDTH=112 HEIGHT=34 ALIGN=LEFT>Name</TD>
Line 850: Line 808:
 
<TD ALIGN=LEFT><BR></TD>
 
<TD ALIGN=LEFT><BR></TD>
 
</TR>
 
</TR>
−
</TBODY>
 
 
</TABLE>
 
</TABLE>
−
<!-- ************************************************************************** -->
 
 
<HR>
 
<HR>
−
<A NAME="table3"><H1>Sheet 3: <EM>Travel</EM></H1></A>
+
<H1>Sheet 3: <EM>Travel</EM></H1>
−
<TABLE FRAME=VOID CELLSPACING=0 COLS=8 RULES=GROUPS BORDER=1>
+
<TABLE>
−
<COLGROUP><COL WIDTH=90><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65></COLGROUP>
 
−
<TBODY>
 
−
 
 
 
<TR>
 
<TR>
 
<TD WIDTH=90 HEIGHT=17 ALIGN=LEFT>credit card </TD>
 
<TD WIDTH=90 HEIGHT=17 ALIGN=LEFT>credit card </TD>
Line 1,039: Line 992:
 
<TD ALIGN=LEFT><BR></TD>
 
<TD ALIGN=LEFT><BR></TD>
 
</TR>
 
</TR>
−
</TBODY>
 
 
</TABLE>
 
</TABLE>
−
<!-- ************************************************************************** -->
 
 
<HR>
 
<HR>
−
<A NAME="table5"><H1>Sheet 4: <EM>IIT</EM></H1></A>
 
  
−
<TABLE FRAME=VOID CELLSPACING=0 COLS=6 RULES=GROUPS BORDER=1>
+
<H1>Sheet 4: <EM>IIT</EM></H1>
−
<COLGROUP><COL WIDTH=269><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65></COLGROUP>
+
<TABLE>
−
<TBODY>
+
<TR>
−
<TR>
 
 
<TD WIDTH=269 HEIGHT=17 ALIGN=LEFT>inquiry log</TD>
 
<TD WIDTH=269 HEIGHT=17 ALIGN=LEFT>inquiry log</TD>
 
<TD WIDTH=65 ALIGN=LEFT><BR></TD>
 
<TD WIDTH=65 ALIGN=LEFT><BR></TD>
Line 1,453: Line 1,402:
 
</TR>
 
</TR>
  
−
</TBODY>
 
 
</TABLE>
 
</TABLE>
−
<!-- ************************************************************************** -->
 
−
</BODY>
 
−
 
−
</HTML>
 

Latest revision as of 07:53, 13 May 2006

Sheet 1: Donation

Wish
















auto discount for sales time period 12 month period














Donor general info extracts from person data
















Contribution
Date recvd amt given classified to… Thank you sent Donor call Tickler Timed output







Feedback


Source:led to donating committment/time period Amt pledged


Resource: exp. Are they willing to sponsor a donor event or training. willing to organize, raise funds and/or awareness


















restricted fund request



















association interests









Form letters







pledge form







donation form







thank you letter-one time







annual thank you letter







Sheet 2: Person

Name Title Given Secondary Family Suffix











Company
















Previous address
















Street Bldg Street street2 flat/apt/ste












City/town
















State/Prov
















Postal code
















Country
















phone home office mobile alt phone












fax
















E-mail 1 2














IM (categories) Skype MSN Yahoo other












IM ID
















Relative(if in DB) Spouse Mother Father Brother Sister Associate










Rel Name in DB
















gender
















Language(s) http://www.123world.com/languages/















Affliation name service web address













Emergency
















Dietary meat pref dairy wheat eggs other allergies










Special needs
















Medical insurance policy # doctor name doctor state/country doctor contact
condition









CNVC affliation IIT Part SS Part Proj Coor Organ Donor Staff Volunteer GCC Mem Board Mem Vendor Fondation Ponential Donor Apr Cert Cand CNVC Trainer customer iit other training
Source of contact
















date initiated
















Sheet 3: Travel

credit card number exp date auth number name as on card card type

Flight airline travel depart seating
flight number arrival class



Window aisle


























frequent Flyer airline id number




air club airline club name id number



car rental company card number special requests



Hotel hotel name card number special requests smoking/non (Y/N)


passport country id number date issue exp date


date of birth






citizenship res status country












Forms






navigant






Sheet 4: IIT

inquiry log










all comments




conversations




correspondence link email









IIT master file




participant




person data




assignment #'s ?



accounting info




scholarship parity rate CT waiver discount requested amount vs.given
room request room assignment substitute options



roommate single preference

payment directions payment type intended payment date


donated check box









venue module




room availability




cost




persons per room




room type




room management special instances









forms




application gen



scholarship gen



bis iit



enrollment form iit



emergency gen



trainers contract




organizer agreement










IIT staffing




org payment option commission


trainer " fee


translator " fee volunteer







waiting list




standby temp void other













NOTES ALL










Tickler




Retrieved from "http://en.nvcwiki.com/index.php?title=Spreadsheet&oldid=3120"