Revision as of 07:51, 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

<TR> <TD WIDTH=90 HEIGHT=17 ALIGN=LEFT>credit card </TD> <TD WIDTH=65 ALIGN=LEFT>number</TD> <TD WIDTH=65 ALIGN=LEFT>exp date</TD> <TD WIDTH=65 ALIGN=LEFT>auth number</TD> <TD WIDTH=65 ALIGN=LEFT>name as on card</TD>

<TD WIDTH=65 ALIGN=LEFT>card type</TD> <TD WIDTH=65 ALIGN=LEFT>
</TD> <TD WIDTH=65 ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>Flight</TD> <TD ALIGN=LEFT>airline</TD>

<TD ALIGN=LEFT>travel depart</TD> <TD ALIGN=LEFT>seating</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>flight number</TD> <TD ALIGN=LEFT>arrival</TD> <TD ALIGN=LEFT>class</TD>

</TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>Window</TD> <TD ALIGN=LEFT>aisle</TD> <TD ALIGN=LEFT>
</TD>

<TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>frequent Flyer</TD>

<TD ALIGN=LEFT>airline</TD> <TD ALIGN=LEFT>id number</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR>

<TR> <TD HEIGHT=17 ALIGN=LEFT>air club</TD> <TD ALIGN=LEFT>airline</TD> <TD ALIGN=LEFT>club name </TD> <TD ALIGN=LEFT>id number</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD>

<TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>car rental</TD> <TD ALIGN=LEFT>company</TD> <TD ALIGN=LEFT>card number</TD>

<TD ALIGN=LEFT>special requests</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>Hotel</TD>

<TD ALIGN=LEFT>hotel name</TD> <TD ALIGN=LEFT>card number</TD> <TD ALIGN=LEFT>special requests</TD> <TD ALIGN=LEFT>smoking/non (Y/N)</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD>

</TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>passport</TD> <TD ALIGN=LEFT>country</TD> <TD ALIGN=LEFT>id number</TD> <TD ALIGN=LEFT>date issue</TD> <TD ALIGN=LEFT>exp date</TD>

<TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>date of birth</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD>

<TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>citizenship</TD>

<TD ALIGN=LEFT>res status</TD> <TD ALIGN=LEFT>country</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR>

</TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>Forms</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD>

<TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> </TR> <TR> <TD HEIGHT=17 ALIGN=LEFT>navigant</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD> <TD ALIGN=LEFT>
</TD>

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

@@ 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>
 			<TD WIDTH=156 HEIGHT=17 ALIGN=LEFT>Wish</TD>
@@ Line 280: / Line 243: @@
 			<TD ALIGN=LEFT><BR></TD>
 		</TR>
-	</TBODY>
 </TABLE>
-<!-- ************************************************************************** -->
 <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>
 			<TD WIDTH=112 HEIGHT=34 ALIGN=LEFT>Name</TD>
@@ Line 850: / Line 808: @@
 			<TD ALIGN=LEFT><BR></TD>
 		</TR>
-	</TBODY>
 </TABLE>
-<!-- ************************************************************************** -->
 <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>
-	<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>
 			<TD WIDTH=90 HEIGHT=17 ALIGN=LEFT>credit card </TD>
@@ Line 1,039: / Line 991: @@
 			<TD ALIGN=LEFT><BR></TD>
 		</TR>
-	</TBODY>
 </TABLE>
-<!-- ************************************************************************** -->
 <HR>
-<A NAME="table5"><H1>Sheet 4: <EM>IIT</EM></H1></A>
+<H1>Sheet 4: <EM>IIT</EM></H1>
+<TABLE>
-<TABLE FRAME=VOID CELLSPACING=0 COLS=6 RULES=GROUPS BORDER=1>
+	<TR>
-	<COLGROUP><COL WIDTH=269><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65><COL WIDTH=65></COLGROUP>
-	<TBODY>
-		<TR>
 			<TD WIDTH=269 HEIGHT=17 ALIGN=LEFT>inquiry log</TD>
 			<TD WIDTH=65 ALIGN=LEFT><BR></TD>
@@ Line 1,453: / Line 1,400: @@
 		</TR>
-	</TBODY>
 </TABLE>
-<!-- ************************************************************************** -->
-</BODY>
-</HTML>

Difference between revisions of "Spreadsheet"

Revision as of 07:51, 13 May 2006

Contents

Sheet 1: Donation

Sheet 2: Person

Sheet 3: Travel

Sheet 4: IIT

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools