Generally speaking, there are a number of discrete, steps needed for 
updating the LRP excel spreadsheet and plots:

o  Running SPIKE to generate a resource report.
o  Reformatting the report for importing into excel
o  Importing the resource report; substituting the appropriate columns.
o  Recasting the unplanned resources.
o  Updating ancilliary columns.

Below, the details are spelled out.

======================================================================

GENERATING THE RESOURCE REPORT

o  start up a full spike image from inside an emacs window:

inanemacswindow:    shell 

o  from the unix shell that appears within the emacs window:

unixprompt> imageshell ~lrp/latest.image

o  when you get to the lisp prompt, two lisp commands to remove specific props and 
	generate the resource report, and then exit from the SPIKE image:

CL-USER(1): (remove-props '(9727 9728 9750 9803 9822 9978))

CL-USER(2): (resource-rpt "/home/lrp/c12/res_[unique_identifier_eg_lrp_name]_sans3.rpt" :sogs-start "03.160" :sogs-end "05.003")

CL-USER(3): (exit)

====================================================================

REFORMAT THE RESOURCE REPORT

unixprompt> reformat_rr /home/lrp/c12/res_[lrp_name]_sans3.rpt > /home/lrp/c12/res_[lrp_name]_sans3.txt

=====================================================================

UPDATING THE EXCEL SPREADSHEET

o  log into citrix

o  open up the most current excel plot located in T:\home\lrp\c12\excel\

o  open up the recently created text resource report:
	a)  open dialog box.
	b)  type in T:\home\lrp\c12\ 
		(caveat:  if this is your 1st time, you may need to 
		"Tools:Map network drive", depending upon the configuration
		that defaults provide)
	c)  open the new file.  
	d)  You will need to select "Delimited"  in the first pop-up dialog
	e)  Toggle the "space" checkbox.

o  you will need to scroll down in the file until you encounter the end of
the "commits" --i.e. the end of the baselined calendars.  you will be able
to see this in the resource columns as the place where there are no "0"s or
integers filling the resource columns--i.e., floating point numbers are in
the resource columns.

o  copy the neighboring two columns of total and SAA-free orbits resources starting
from the first day beyond the calendar commits (after the 0s and integers in the
resources).  Note the day number of the first row selected.

o  switch back to the window containing the excel plot and select the tab for "c12plan-data"

o  select the data starting at the same corresponding day number in the 
	neighboring two columns:  "C10/11/12 other"	"C10/11/12 other Free/d"
	(columns E & F) and past the data copied in the previous step.

o  update the execution info in the rows above in each of these two columns
	(you can just use the dummy values of 11.5 & 6 orbits/day)

o  update the "Est. Total Unplanned" (column O) for the days up to the end of 
	the calendar commits (use zeros for the unplanned values).

==============================================

November 6, 2003

*** There is a form which you can use 
    to help you organize the information for updating the unplanned column values.
    The form is only a guide, and may not apply near cycle boundaries or when
    new cycles are being assimilated.  You will need to go through your own
    logic to determine how best to use it.  Nevertheless, in general....

	1.  Fill out the blanks at the top.  These help guide and define
		the divisors you will use for distributing the unplanneds.
	2.  Fill out the top line in the table with the dates and # of weeks
		conforming to how you intend to modulate the unplanneds.  If
		you are only going to use a single, flat distribution, then
		you only need to use one of the "A/B/C" columns.
		a)  "Orbits/day" is for the entire remaining planning interval.

	3.  Fill out the next 6 lines from various reports (such as the
		unix tool "stats-on-lrp", or the OPM LRP reports.
	4.  The "Total" line at the bottom is the total of the 6 lines above and
		defines the values that will be plugged into the corresponding 
		day range in the "unplanned" column of the spreadsheet.

==============================================


o  "Save As" your work as a new excel plot file name in the T:\home\lrp\c12\ directory.

o  Print copies to hpc9 
	>if your first time, you may need to configure it:  
		a)  from the citrix windows start menu:  Start:Printers
		b)  double click "Add a printer"
		c)  call the help desk and they will help you configure from here--
			tell them you want hpc9 on "pcamss".

======================================================================