Spreadsheet

From NVCWiki
Revision as of 07:43, 13 May 2006 by Jw4nvc (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Overview

<A HREF="#table0">Donation</A>
<A HREF="#table1">Person</A>
<A HREF="#table3">Travel</A>
<A HREF="#table5">IIT</A>


<A NAME="table0">

Sheet 1: Donation

</A> <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> </TBODY>
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








<A NAME="table1">

Sheet 2: Person

</A> <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> </TBODY>
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

















<A NAME="table3">

Sheet 3: Travel

</A> <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> </TBODY>
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







<A NAME="table5">

Sheet 4: IIT

</A> <COLGROUP><COL WIDTH=269><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65></COLGROUP> <TBODY> </TBODY>
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