Home

CDF USER MANUAL

1. R SON TBD ni FARUTECHMCS TED STRUCTURE TBD Cute c nj ADCS TBD and CLM p ordre ct Metodo lawat aaa FICE Decl Cones TBD mal DATA H ADUNG TBD s en me ard paced mod emm onm s PETRURENTS A twectcas CFF ecam garang tet mi 2 IM MECH Mans D end of thd m POIA 21 mor owe 5 tuectero 941 m Pe hase deg oped rra that a and a STRUCT 180 m imera IDD hewn sa apogei rabaan mi TOD Aet sm fan ot proputece crore sor po ung ran aran tei deemed b p xt en E ponn E TOD TTNG Pio jew ce dare E sanjan modd s and hatha cn ran aia bd PETANTE R PCL mon PROTEC MCS STPWCTUPE TEPMPL Mems cp afr of ove arga war cL nonum oe Tapes comes a DATA KANDUNG M 4 DIN MASS inputs Oucpues kegs Options Tradeolts Equi Ness Modest modes f Figure
2. fumes 6 2 MTU 2owenms Ui AY EB B8 Y DHS PW a 2 Poras Wanin ci prorsored Mis kne Sting TEC acie NG ln sca ca di ran i M4 rS SAD arak SWskw Catet maan comments Mercury Mirin 2 Pilihan Outputs 41 4 bm aros MOOR 8 By Shs Pad Tucker keben Lata ien THE Enoet WGN maa rx Figure 3 9 Example Cell Names in Output sheet The workbooks should be set up so that a results parameter within a working sheet is referenced by the corresponding parameter value in the Results sheet list When the value of the result changes this should automatically be seen in the Results sheet The Corresponding list in the Data Exchange should be able to update this value This means that the new value will automatically be transferred to the Data Exchange when the Domain file is saved and the Data Exchange is updated No copying and pasting of the new value is required CDF UM 01 issue 2 revision 1 Date 23 01 03 27 of 48 3 4 3 GROUPING OF PARAMETERS Within the different workbooks the output parameters must be created and grouped in a way that is consistent with the overall model The model is bei
3. T CONFIGURA Update cells that linked to the Data then changed to the current values the Data Exchange file It should be noted that the update references the data in the saved copy of the Data Exchange This may be different from the current values which appear in the open version of the file It is therefore important to know whether the opened version has been saved to the stored file or not The update process can be put into a macro so that you only have to press a button in a worksheet to update If you don t know how to do this then the System Model Engineer will do this for you 3 3 8 SETUP OF INPUT SHEETS As discuss above the Input sheet of each workbook is set up to allow the switch between manually inputted values and values gained via a reference to another workbook through the Data Exchange The switch between these values is achieved in a standard way that has been used throughout the model 1 The sheet should be set out in the correct column order as shown in section 3 3 1 2 The Linked value column should only contain cells that are either a reference to a cell in the Data Exchange workbook or that are empty The Manual Value column should only contain cells that have directly inserted values i e No links or that are empty 3 4 The Results Sheet The Results sheet of each domain is very important for the integration of the overall model at least
4. Proposed Launch Date mission mis_laun_date 07 Jan 07 Mission Duration mission Imis oper cruise 33088 mission Imis oper life REF mission mis_oper_szlif DESIGN LIFE TIME mission mis_design_life 365 5 22 Total Mission Time Final Orbit Description mission imis orb HEO E i 3 Lb HN Mass C 4 mm T NM Figure 3 6 Reference Fixing Buttons MACRO 1 Storing Correct References This macro allows any reference in the Linked Value Column to be stored The major information concerning the sheet name and cell name in the referenced Data Exchange workbook is stored in the Reference Store column IMPORTANT The cell reference in the Linked Value column must be complete Both the cell name cell reference and sheet name must be present If the sheet name has been removed it must be replaced in every cell before using the macro Using the Macro Close all other workbooks CDF JM 01 issue 2 revision 1 Date 23 01 03 19 of 48 CDF UM 001 Iss2Rev1 2 Make sure the cell references in the Linked Value column you wish to save are complete including the file path sheet name and cell name 3 Select the cells of the Linked Value column you wish to save 4 Press the STORE REFERENCES button message box will appear asking you to check you have selected the correct cells 5 Check you have selected the only
5. Suh system Parameter i Total Sub system masa without margin PYR Mass 37 kg 12 Mass 10 be applied PYR Total Mass Marg 10 13 14 Subsystem Maxmum Power 1 PYR Max Power w 15 Sub cystam Power Moda 1 Ay 1 vy 16 Panod of Maximum Powar 1 PYR_MaxPow PenadM1 v 15 Sub eystem Maximum Power Mode 2 PYR Pawan 19 Sub system Average Power Mode 2 Paweh W 20 Period af Maximum Power 2 PYR MaxPow PenadM2 A 22 Sub eystem Maximum Power Moda 3 PYR 3 WA 23 Sub eystem Average Power Mode 3 4 3 WA 24 Period of Maximum Power Mode PYR MaxPow 26 Sub zystam Maximum Power Moda 4 PYR Max vi 27 Sub systam Average Power Moda 4 A 26 Panod of Maximum Powar Mode 4 PYR_MaxPow_PemdM4 2 30 Sub eystem Mas imum Power 5 PYR Mar Powers 3 Sub system Average Power Mode 5 PYR vi ompak 280 lc agos MOOR amp 2 A S DjEelomg WASOL S Ped Tucker rj orm TH SPCD ape SFR 1672 Figure 3 10 Example Sub system parameters in Output sheet Unit Level information is placed below the System Level parameters There is a template available for the generic parameters The outputs are set out in such away that all units are numbered All CDF J
6. 3 2 GENERAL OVERVIEW sena aan a dim M Ht cas 3 2 1 LINKS BETWEEN WORKBOOKS 33 THEINPUTS SHEE aM n o ag agan nn MERDA eese dura RD ELE 14 tar pui ahaa D UE 3 3 2 LINKED AND MANUAL INPUT 3 33 REFERENCE FIXING S dco sena los 3 3 4 REFERENCING INFORMATION IN THE DATA 3 3 5 MANAGEMENT OF INPUT PARAMETERS 3 3 6 UPDATING INFORMATION FOR EXISTING INPUT PARAMETERS 3 37 UPDATING WORKBOOKS 3 3 8 SET UP OF INPUT SHEETS 34 THE RESULTS SHEET M M aU ME 22 23 342 CELE NAMES 25 343 GROUPING OF PARAMETERS e AV 27 45 WORKING SHEE US eee uu MN E 28 6 NOTES SHEET 52i 29 37 30 385 32 CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 4 of 48 CDF UM 001 Iss2Revl 3 8 1 DATA EXCHANGE MACROS PER S A 3 8 1 1 NEW INPUTS AND OUTPUTS earth ttr Rr tre er RH Eee rena 3 8 2 OVERALL DATA EXCHANGE PROCESS 3 8 2 1 THE DATA EXCHANGE ertet rtr ree rere tee et RP eere reete 3 8 2 2 STEPS TO T
7. permission to make additions on the request of domain specialists where new capability is agreed The Input and Results sheets link the workbook with the rest of the model They can also be used to link to external tools that do not appear in the core model this could include CAD for example The Output and Input sheet are created using a template which ensures all workbooks have the same format The Template gives a simple list with specific columns which varies slightly between the two sheets There are also a number of comments and warnings added to aid the user Both sheets contain parameters developed from previous studies It will be necessary to remove irrelevant parameters and add new ones where appropriate when starting new studies The other sheets Working sheets can be modified in anyway the domain specialist sees fit The only requirement is that all outputs and inputs to and from the other parts of the model are directed through the Input and Results sheets More Working sheets can be added as the user sees fit Such additions are described in the domain workbook user manuals CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 13 of 48 CDF UM 001 1562 Rev Other sheets may also be added containing templates to aid development of the design With the sub system workbooks sheets might be added to aid the design process such as requirement sheets Study workbooks contain a sheet called Notes used to stored information generat
8. Input Sheet 3 32 LINKED AND MANUAL INPUT The Input sheet of each workbook can contain two possible types of input for your working sheets these are values that are either manually put into the sheet or values linked to the Data Exchange The Input sheet has been set up to allow the use of both types of data quickly The columns required as shown in Figure 3 5 for a subsystem workbook are Linked Value column which should only contain linked information This column is the only one linked to the Data Exchange Manual Value column which should contain values which have been inserted by the user These can be values which you have not been able to link or values that the user just wishes to try out in their calculations Note External column is used for external tools or industrial study outputs Used Value column which contains the chosen values from either the manual or linked options These cells are referenced by your working sheets and used in your calculations Switch column this column allows you to quickly change whether you are using Linked or Manual values within your working sheets Each cell contain three simple options manual and linked which allows you to switch your Used Value to either the Manual Value or Linked Value columns There is a third not wed option for simply identifying that a given parameter row is not being used in your working sheets The not used option selects the Linked column for the Used Value column
9. UMTI daccrp Small Description rf naadoch 70 72 Unt PYR 17472 name Orbe Solar Array HRM Sub sy stem unit of sub system 73 Number of Un s PYR UNITZ num 74 Unt Mass thot magn PYR JMIT2 12 75 to be applied PYR UNT2 mas smargn 5 5 OTS 10 Modhed 20 Develop TE Dimension 1 PYR LNIT2 dimi mm 77 Dimension 2 PYR LMTZ dim Dimension 3 PYR UNT2 dim3 mm 78 Volume PYR_UNT2_vol Cost purposes 0 Descnption PNR I IMT2 descrp Smal Description if reedecf 8t 82 8 Unt PYR_UNITS_name HGA HRM Bub aystern of unit of subsystem ad Number of Unts PYR UNIT3 num 3 ge Unt Mass without MT 06 kg ee Margn to be spplied PYR UMTS mos emangn 5 5 OTS 10 Modified 22 8 Dimension P YR LIMITS dimi mm 88 mm mm 4 bi outputs 1 1 Gig Des gt ames 4 NA 8 Ready Start 2y Esing WASOL S Ped Tucker onte Myr TH PCO al iP ex Figure 3 11 Example Unit Level Output Sheet Parameters have also been created to be in line with the design processes developed for the facility The application of the Modes of Operation feature is very useful for the exchange of information and require output parameters to be created in a certain way 3 5 Working Sheets The user of a domain workbook can add as many working sheets that
10. ae Q fe e ps en Wed Qt i55 M Pau hiten By Meret Ward TH ennt Pom rint ial Bn 146 Figure 3 14 Example MenuSheet CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 32 of 48 CDF UM 001 Iss2Rev1 3 8 The Data Exchange Workbook This workbook acts as a central junction for all information flow in the model It should not be looked upon as a summary sheet or as the model itself Parameters available in each Results sheet is copied into the Data Exchange using the Outputs macro and therefore published for the rest of the system To update the Data Exchange a new copy of the domain Output sheet is loaded normally done by the System Analyst It is necessary to make sure the numbers in your output sheet are correct as they will be used by other members of the team in their calculations It is also important that you create and apply cell names to the value column so that a more flexible system can be created Updates can be made selectively you can update individual sheets independently This has the advantage that it is possible to keep the published values of some domains fixed while allowing others to change It also means that updates can be made quickly rather than having to wait for all the sheets to be updated which can be slow It is only necessary for a domain specialist to open the Data Exchange Read Only when he she wishes to establish
11. mechanical states that are required for the design and sizing of various sub systems such as structures AOCS propulsion These mechanical states can be related to phases of the mission or even to the Operational Modes of the Spacecraft They must be defined in the Systems workbook in a similar way to the Modes of Operation A single sheet in the Systems workbook can define the Mechanical States as shown in Figure 4 6 Only crucial states should be identified 1 e those required for sub system sizing and optimisation System Mechanical States Description of Mechanical States 22 Nov 99 Number Mode Name Definition Acronym All mechanisms stowed for launch Fuel tanks full 1 Stowed State All mechanisms deployed Solar Arrays Antenna Protected from Sun postion Deployed with Fuel State Instruments Fuel tanks full All mechanisms deployed Antenna Protected from Sun postion Fuel Tanks Mass after apogee firing Nominal State Antenna Positioned for Ground Communications not Sun protected Fuel Tanks Mass after apogee firing Communications State Figure 4 6 Example Mechanical States worksheet Once these Mechanical States have been defined it will be possible for each sub system to identify their specific mass and any other relevant mechanical properties and be added to their Results sheets To achieve a generic approach that can be used for all types of mechanica
12. network workstation wherever he logs onto the ICA client M Master 15 a reflection of the D MM drive and therefore contains exactly the same information This drive is used for archiving the information resulting from completed studies Facility administration information and reference documents and databases are also included in folders on this drive Normally permissions are granted to administrators and team leaders only W Working is a reflection of the D NW drive and therefore contains exactly the same information This drive is contains the models and documentation appropriate to on going studies Normally permissions are granted to all team members allocated to that study Permissions to the Cost directory are granted to a limited group only 2 1 Working Directory W The Working directory is used for all ongoing study activities and this contains the following structure Study A specific folder is created to contain the files for each ongoing project This is Folders identified by the project abbreviation followed by the word Study e g STORMS Study The structure within this folder is pre defined see below O Private This contains the individual working folders of the CDF study team members where any information can be stored Any team member may create a folder here Please note These files are not private Access to these folders is unrestricted Several other folders are present which are ma
13. on the preferences of the user of that workbook When links are not available values can be added here by hand however this is not recommended and assistance or co ordination must be obtained from System Analyst The template for this sheet consists of a number of columns which define each parameter and also allow a switch between manual inputs and linked reference to Data Exchange workbook inputs for parameter values The columns are described below as follows Simple Description of the parameter Parameter Name Linked Value These cells must be linked to the Data Exchange workbook referencing the corresponding cells within If no link is available it must be left blank should only store references to Data Exchange cells Manual Value These cells contain values for a given parameter which are manually input by the user of the workbook This can be useful if the linked value is not available or the user would like to experiment with different values It can also be used to compare old and new linked value The user can copy the linked value not the reference into the manual input cell so there is a record to compare against if the linked value changes External These cells contain values extracted from industrial studies for reviews or from external tools outputs Switch Each cell contains a pull down menu where either Linked Manual or Not Used can be chosen This is then used to switch be
14. the correct cells in the Linked Value column Only select this column If you would like to cancel and select the correct cells press the No button 6 If correct press the Yes button the macro will now proceed to place the sheet and cell names of the reference in the cells of the Reference Store column MACRO 2 Correcting References This macro uses the sheet and cell names in the Reference Store column and combines them with stored file paths to create a new reference in the Linked Value column To operate this macro a list of file paths has to be present in the hidden Menusheet of the workbook This list should only include the file name and its directory path so that it can be combined with the Reference Store cells to create the reference The list has been given the reference name paths the cells of which may need to be extended if many more directory paths a required There should only be one entry giving the path to the currently used Data Exchange file e g WASTORMS Study STORMSModelNData Exchange xls IMPORTANT file must be surrounded by square brackets and include Using the Macro 1 Close all other workbooks 2 Select the cells of the Linked Value column you wish to create references in 3 Press the CORRECT REFERENCES button A message box will appear asking you to check you have selected the correct cells 4 Check you have selected the only the correct cells in the Linked Value column Only select thi
15. they feel necessary for the conduct of a study However normally the available worksheets are adequate for most applications see specific domain User Manuals These sheets should contain everything necessary to produce the results required from a given domain This may include calculations directly produced in the spreadsheet or results gathered from external sources summary sheet also can be included for use when writing reports and to help others to see the design status This should be different from the Results sheet that should just be used for information passed through the various workbooks of CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 29 of 48 CDF UM 001 Iss2Rev1 the model Schematics can also be added to aid in the visual representation of the design These diagrams be linked to information within the workbook so that the information contained within them change automatically see Figure 3 12 au so Pg 3 91 Wes porr Fama Took Qua o KOTANG NGA m nes 1 9 BLD SSSR Dhe TD JM L Tha ding bra key show fe hast fow mite tortha difeetihanacass L GEND sas celis 42 o DE bif Ou Jin Orms TCS Mas and Cog Parte tit Modal Desa 1 Reo Calculate SS 71 as eid sol
16. within the Excel environment It should be remembered that once a Results sheet has been linked to the Data Exchange using the Generate Outputs macro FUNCTIONS menu the parameter list is fixed Parameters within the list can not be removed or moved to a different cell location The information for an individual parameter can be changed as long as it still refers to the same piece of data CDF JM 01 issue 2 revision 1 Date 23 01 03 23 of 48 CDF UM 001 Iss2Rev1 For example the Name of the parameter Daylight Power could be changed to Sunlight Power because this is only a change in wording A Value of a parameter can also change eg an estimate of 20kg for Sub system mass could be changed to a value which references a sum of unit masses within a working sheet giving a value of 15kg New Results parameters can be added to the bottom of or inserted in the list added to the Data Exchange To ensure that the Switch is included select the row above the inserted row and drag to the inserted row 3 4 1 LAYOUT Both the Input and Results sheets consist of similar columns of information for a given parameter Each parameter is contained n one row of the table therefore only the value cell of each row should be linked to If other links are required they should be added to a new row of the table The columns are described below see also Figure 3 8 e Parameter Simple Description of the param
17. 1 2 ICA Client Use ICA Client properties are provided in the latest issue of the CDF ICA Client User Manual 2 1 If there is a CDF icon on your desktop Double click the icon to launch the ICA client 2 If there is no CDF icon Contact the CDF Administrator for assistance 3 The NT Terminal Server log on screen will appear CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 6 of 48 CDF UM 001 Iss2Rev1 Logon Information 4 a 4 g Terminal Server Edition 1981 1998 Microsoft Corp rights reserved This product is protected by US and international copyright laws as appropriate 4 Log on using your normal user name and normal ESAID password You will now be logged on to the CDFO1 server with your own personal working environment CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 7 of 48 CDF UM 001 Iss2Rev1 2 CDF FILE DIRECTORY STRUCTURE There are several network drives on the ESTIDWTSCDFO1 server that are available to the CDF Study Team as follows D Contains the CDF Master M and CDF Working W directories Rights to this drive are controlled by permissions granted to the individual user Warning Do not access the working drive W through D when using the Excel model workbooks or all the links will be incorrect H H is the User drive and contains the settings and personal documentation available on the network to a specific user after logon as set on the user s personal
18. 4 2 S C Modes of Operations Modes2 sheet e Sub system Each sub system collects the information on its requirements for each mode via the Data Exchange Other mode information can be taken from the verbal communication of the sessions and from the mode summary sheet in the systems xls workbook This information can then be used to identify the internal Sub System modes required for each Spacecraft Mode The power data and other appropriate resources can then be calculated for each Sub System Mode The information that will be passed is as follows Power Sub System Level e Maximum Power per Mode W e Minimum Power per Mode W e Nominal Power per Mode W e Data Passing of Data information e g data rates volumes etc still has to be assessed and implemented This information can then be placed into the Domain Output sheet for use by the rest of the team via the Data Exchange CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 38 of 48 4 1 3 DESIGN CASES When the spacecraft mode information has been produced by each sub system it is possible for the other specialists who require system budgets e g power systems to size their sub systems At this stage the sub systems will not be optimised because the sizing is done at spacecraft mode level CDF UM 001 Iss2Rev1 optimise sub systems further the Design Cases have to be established based on the modal information and the knowledge about the mission timel
19. 47 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 5 of 48 CDF UM 001 Iss2 Rev 1 INTRODUCTION This manual is a guide for a new CDF Team member 0 the use of the CDF environment for technical studies The document contains an introduction to the ESTIDWTSCDFOI server locally referred to as CDFO01 that forms the environment for the CDF in particular the directory structure and the intended use of the Master and Working directories Instructions and methods are given for the use of the generic sections of the individual workbooks and an explanation is given of the data exchange process No detailed information on the use of domain specific sheets of the workbooks is provided this may be found in the respective User Manuals A general description of the CDF is provided in the CDF System Description 1 and detailed information for using the CDF network environment is provided in the CDF ICA Client User Manual 2 11 Logging in to a CDF Computer The computers at the positions in the CDF may be used by any number of people and therefore should not be customised by any individual To avoid some of the pitfalls of having multiple users logging in to one terminal at different times you are requested to use a communal login ID for logging into Windows Since your actual work will be done inside your personal ICA client environment this should have no adverse effects Log in to Windows using the Username and password CDF
20. 5 stabilisation 5 5 SpinRate s 575 Point Direction 575 Point Knowledge SYS Point Accuracy SYS Point Stability sys Miss duration ys SYS SC Name SYS SC Ref Origin description SYS SC Ref Aves description SYS Launch site latitude 000 manual output 0 SYS Launch site longitude Figure 3 7 Summary of Results sheet general use CDF UM 001 Iss2 Rev 01 issue 2 revision 1 Date 23 01 03 25 of 48 Microsoft Excel system Read Only BEE 18 Insert Format Tools Data Window FUNCTIONS Help _ E _ lel nggen na z0 B 2 7 General Characteristics H2 A B D B a H J 1 Results from System Workbook 2 4 5 Parameter Internally Linked Manual Value Units switch Shared value Remarks 7 8 General 8 Project Name 0 00 10 Version of Model 0 00 Date 00 Jan 00 12 Target Launch Mass 0 00 kg 13 Satellite Dry Mass with margins 0 00 kg 14 Satellite Launch wet Mass 0 00 kg 15 Stabilization Type 16 Spin rate Ips 17 Pointing Direction 18 Pointing Knowledge 18 Pointing Accuracy 20 21 22 Pointing Stability Determined By Bus Solar Array mounting type 023 Launch date dd mmiyy 24 Design Life time yrs 25 On S
21. CDF DOCUM ENT document title titre du document CDF USER MANUAL prepared by pr par par Ross Henderson reference r ference CDF UM 01 Issue dition 2 revision r vision 1 date of issue date d dition 23 January 2003 status tat Final Document type type de document User Manual Distribution distribution See List ESTEC CDF UM 001 Iss2Rev1 Postbus 299 NL2200 AG Noordwijk Keplerlaan NL 2201 AZ Noordwijk ZH Tel 31 71 5656565 Fax 31 715656040 S CDF UM 001 Iss2Rev1 CDF UM 01 issue 2 revision 1 Date 23 01 03 TABLE O F C ONTENTS 1 id kt uua gk 5 1 1 LOGGING IN CDF COMPUTER pM RN AU E ee 5 1 2 anna akng nb ci tak oe ace 5 2 CDF FILE DIRECTORY iiia ish b idm hdd pn dad naga na nana na nagane nana na nana ne 7 2 1 WORKING DIRECTORY QU 7 241 STRUCTURE ORA PROJECT FOLDER sapi enang en 7 22 MASTER 9 3 WORKING WITH WORKBOOKS asana asana asana nana na naga na naga na naga na nagane nana na nana nana 11 3 1 edi bna ideam 11 PASS WOR DDS sesanan age es KG Ga Ae anda a SR PAN BA gbi agan ga aaa 11 3 1 2 CONFIGURATION MANAGEMENT FORM 11
22. CDF UM 001 1562 Rev CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 17 of 48 X Microsoft Excel power2 Read Only e Ime Edit View Insert Format Tools Data Window FUNCTIONS Help lal X v C3 v 10 see rni 75 18 inputs for Power Workbook STORMS oO 12 T Parameter manual T mission manual manual 1 Values passed to Type of stabilisation Orbit duration manual T orbit Eclipse duration maz manual max 05 Orbit shape manual shape 0 Orbit inclination Manual manual inclin oo Spacecraft Sun distance min manual Ssun dist min Spacecraft Sun distance input manual Ssun dist 1 Apogee Apogee Perigee Petigee L date to Data manual and definition tion and definition manual Exchange manual M 52 manual 53 827 manual M 54 manual EA 1 0048333333 Column used to change Used Value options eese ae hours hours hours hours hours hours hours hours hours mission mission mission mission mission mission mission mission mission mission system system system system system system system system syste
23. HE PROCESS ttp Rees ana 4 MODES OF OPERATION AND MECHANICAL STATES 35 4 1 SPACECRAFT MODES OF OPERATION 6600000000000000 0000000000000000 0000000000 ao nenen ene 35 4 1 1 SUMMARY OF METHOD ittm a EN angan A a pe ede aa e nee ere e tere 4 1 2 DEFINING SYSTEM LEVEL MODES 4 1 3 DESIGN GASES e rere eerte e NE ER 42 MECHANICAL CHANGES EVENTS eese eee ee esses sebaene napase ta ton 41 5 555 43 5 1 MASS 8 43 5 1 1 Si iseng aa Tana teen e HEATH 5 1 2 SUB SYSTEM 5 5 1 3 HIDDEN MANRGINS ajap rr p terrere an BK BAGE pa agan a GA kag ehe gae aa aa 5 1 4 SYSTEM MARGIN 5 1 5 IMPLEMENTATION IN THE MODEL 5 1 5 1 A TTT 5 1 5 2 EQUIPMENT BEEVEL rtr rere err 5 1 5 3 RR t EN OR E PRENDE 6 ABBREVIATIONS AND ACRONYMS eere ene anaa nana anan en ananeng nane en 46 7 REFERENCES
24. M 01 issue 2 revision 1 Date 23 01 03 Page 28 of 48 CDF UM 001 Iss2Rev1 the parameters for a unit are distinguished by a change in unit number within the Results sheet specific information about the unit itself is stored within the value column for generic application because only the Value column will change between projects The Unit template contains parameters that various domains have requested from each sub system In some workbooks the entire template has been added whereas in others a basic set has been used with the possibility of adding parameters as the project progresses The model will be unified as time permits see example of Figure 3 11 I EE Be pk Mew yos Too Data FUNCTIONS SMTA HN E c 2 SM PK OA EER BERGEN VR 19478 san Cqupmertf 13 TA E D 58 tatal no of iniator nng PYR Total fimgknas a fe zB 50 7 Unt Mame PR LNITI name rusa Soler Arrays Sub systern ure of sub system 62 Number of Unts PYR_UNITI_ num 16 63 Unt Mass without mangn PYR UNTI 36 kg BA Margin to ba applied _ UNT marin 5 E 5 OTS 10 Modfad 20 Dadap Dimension 1 PYR dim Dimension 2 PNR dim2 mm Dimension 3 PYR UNTI dim3 mem _ UMTI vol m3 Cost purposes 59 Dascnption
25. age 47 of 48 CDF UM 001 Iss2Rev1 7 REFERENCES CDF System Description CDF SYS 01 Issue 2 rev 0 27 11 02 CDF ICA Client User Manual 27 8 01 3 CDF Documentation Management CDF PR 004 Issue 1 rev 0 26 11 02 CDF Configuration Management Issue 1 rev 0 25 11 02
26. be based on the philosophy set out in section 5 1 1 CDF UM 001 Iss2 Rev In all four parameters are required for the Mass Budget as follows Uniti Name AOCS uniti name Star Tracker Number of units_ AOCS unit Unit mee AOCS unit Mass Mass Margin to be applied AOCS unit1 MassMarg a The mass figure given for each unit equipment shall be the mass value for one item Therefore the overall mass for the total number of a given piece of equipment shall be number of units mass 5 1 5 3 TOTAL MARGIN The total margin for a sub system can be the average of the equipment margin or this can be modified by adding subtracting extra margin Therefore the Sub system mass margin can be higher or lower than the average of the equipment margins It is down to the sub system specialists to use their expertise to assess the correct sub system margin to be used CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 46 of 48 CDF UM 001 Iss2Rev1 6 ABBREVIATIONS AND ACRONYMS AOCS Attitude and Orbit Control System CAD Computer Aided Design CATIA Computer Aided CDF Concurrent Design Facility ESA European Space Agency ESTEC European Space Technical and Engineering Centre HYPER High Precision Interferometry ICA Independent Computing Architecture NT New Technology PR Procedure S C Spacecraft SI Systeme Internationale d Unit s TBC To be Confirmed CDF UM 01 issue 2 revision 1 Date 23 01 03 P
27. ch problems and try to avoid them CDF UM 001 Iss2Rev1 CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 21 of 48 It is possible for example that equipment will change but the links will remain Any ambiguities should be resolved by contacting the systems specialist or other relevant people In this way control can be gained over what constitutes a particular version of the model 3 3 6 UPDATING INFORMATION FOR EXISTING INPUT PARAMETERS When an output parameter changes within a domain sub system there is no automatic process for propagating this to the rest of the system It could in fact be detrimental to the system if this update was automatic as loops of information would move around the system without any real control A process has therefore been defined to allow the updating and downloading of information through the network of Excel workbooks This guide does not attempt to explain a process for passing any other information between domains Excel only allows for simple values letter codes or a few words to be passed through the electronic system Descriptions have to be passed manually or using other electronic means 3 3 7 UPDATING WORKBOOKS Using Supplied Macro Within every workbook is a macro which allows you to update from the Data Exchange quickly and easily In the menu bar should be the FUNCTIONS menu which contains a number of options To update from the Data Exchange simply select the menu FUNCTIONS an
28. d margins shall be placed in the Output sheets of the sub systems Masses should be given at system level and at equipment level The equipment level figure may not be available at the beginning of the study but they shall be included as soon as they become available 5 1 5 1 SUB SYSTEM LEVEL At sub system level a mass figure shall be given in the Outputs that DOES NOT include margin A second output parameter shall give the margin that will be applied to the mass figure This Margin parameter shall be in Number format and NOT in percentage format within the Cell Format options The sign shall only appear in the Units column see below This is to remo ve the problems perpetrated by receiving a figure of 0 1 rather than 10 when it is written 10 AOCS mass without margin AOCS Mass 1 992 kg AOCS mass margin AOCS Mass Marg 10 00 96 When equipment level margins are defined then sub system level shall still give the overall margin to be applied i e the sub system margin does not become the extra margin in addition to the equipment margins but it will include the equipment margins CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 45 of 48 5 1 5 2 EQUIPMENT LEVEL Each piece of equipment for each sub system shall be added to the Outputs sheet Similar to the Sub system level mass figure the Equipment mass parameter shall be without margin Again the margin to be applied shall be a separate parameter The value of the margin will
29. d the option Update Values All your links to the Data Exchange should now be refreshed NOTE You cannot use the macro if you have the Data Exchange open However when you open the Data Exchange you will automatically update your workbook You should also make sure that the correct Data Exchange is being updated i e that it is in the correct directory Read Oniy 5 8 P E Ge EX psat 1005 Daka Window Cee ea lt B4 UK S 2 Quo tan Mass amp Power De E MESS m Arm ds Press the Update Values option to update links to Outputs from AOCS Work ne Data Exchange 3 Create ced eene Back up Method The cell references to other Excel workbooks be refreshed using the Update Links command in Excel This is found in the Links option in the Edit menu To update a link select the files you want to update in this case just the Data Exchange and then press the Update Now button CDF UM 001 Iss2Rev1 CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 22 of 48 DLICT IN COS Source item Status 4 4 NG uCommon x amp Gece BUS POWEF BOL POWER Lpdete Wow RAFT HEIGH L AFT HEIGHT r PRAFT WIDTH 4 AFT BREADTI Source Fin TuchertDate Exchenges xb Xam cn Type
30. des the definition of the mode name and acronym Under the table a space is provided for the flow diagram for mode change Overall System Modes of Operation Description of Modes Deboard bancher temo tipigas cite uwag n L b Mod us oF essential COME ATUR HAITA E Sh SOR GER TO Sa No T PANNI Ka UD o capitis Areng and omma ts 140 56 dw gin SANS Cingar aad SA Cd ard oa rona pO REC Mode Sor eo Mode ia 483 wor stats CONTRO MC Contingewes possible ed Fadwe Besoprsy mode The sgacecra Lepi SUN pom deemed be p cow malam KANE ANE ano yr on ci rrt d o wah iet baal loca sace e OHE it enable Maas detec ton ca TIRE ala Faba detect andi etc sortant gead 1 Dawe a t ans skk sad Faure Hecovecy wode The SUN pom tne Asaree deemed bas ower matan e ry on ected oft rangen Safe Mode era sto OMS aa a Hue deer ton and eec i cn detect co ei the 253
31. dy CESAR Study Archive Eddington Study Eddington Study Archive F2 F3 Proposals HYPER Study Archive HYPER Study Phasel Archive HYPER Study Phasel Backup MASTER Study MASTER Study Archive MeSE Study MeSE Study Archive MISS Study MISS Study Archive Smad SOLO Study SOLO Study Archive 1 object s selected i Example structure only STORMS Study Con Study Archive 28450 Study Cd WSO Study Archive 0 Presentations amp STORMS Study X File Edit View Help STORMS Final model_ version Iof x E NA ISTORMSModell 10 STORMSModel0_11 STORMSModel 12 STORMSModel 12b 2 STORMSModel 13 2 objects STORMSModel 21 STORMSModell 31 Figure 2 29 MASTER Study Archive Folder Structure CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 11 of 48 CDF UM 001 1562 Rev 3 WORKING WITH WORKBOOKS This section provides general information about using the CDF domain workbooks for detailed specialist information please refer to the appropriate domain user manual 3 1 Opening a Workbook 3 1 1 PASSWORDS When a specific workbook is opened example below the user should be greeted with a window for entering a password for modifying the workbook Both the domain specialist and the systems specialists should know this password If you just wish to look at the file click on the Read Only button Password 2x mission xls is reserved by ESTE Enter pass
32. e and stores the sheet and cell name each reference 2 Replaces the complete references in the Linked Value column using the information stored The columns within the Input sheet required for reference macro operations are CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 18 of 48 CDF UM 001 Iss2Rev1 The Linked Value column This contains the cell references to other files and should be column D of the sheet This column should be completed by the user creating references to other workbooks as and when needed The Reference Store column This stores the sheet name and cell name from the reference in the adjacent Linked Value cell The column can filled automatically using the macro provided When revealed this is column C of the sheet 158 Edt view Insert Format Tools Data Window FUNCTIONS Help x kbo SS CAN MOB gt 0 Aria 0 B Z ub l re inputs for System Workbook RENCES Macro Buttons Store Reference adds the reference information to the 222202202000 OO saa eee Mission Correct References uses the stored reference information to Stored References column e mission imis laun Includes sheet and cell names correct the references the for the cell reference Linked Value column In n Adapter mass included with SiC Launch Mass Launcher Adapter Mass
33. ed during the Sessions This will act as a sort of chronological data store for the domains Data exchange between all the workbooks is achieved through the Data Exchange workbook This workbook links the data in all the Results using the Generate Outputs worksheet macro sheets of other workbooks whereas the Input sheets of the model workbooks are linked to certain output parameters within the Data Exchange workbook The overall structure of the model is shown in Figure 3 2 External Tool Working Sheets Figure 3 2 Model Structure and Workbooks WORKBOOK 3 2 1 LINKS BETWEEN WORKBOOKS The links required to transfer data are as follows Working Sheet Results Sheet Data Exchange Workbook Input sheet of other Domain User workbook Working sheet lt Input sheet Data Exchange Workbook Results sheet of other Domain Possible Problem If cells are copied into the Results sheet rather than pasted as link the link will not occur 1 if you change a value in the working sheets this will not show up in the outputs It is therefore important to make sure you produce a link to rather than a copy of the data CDF UM 001 Iss2Rev1 CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 14 of 48 3 3 The Inputs sheet 3 3 1 LAYOUT The Inputs sheet can be used for all inputs into the Domain workbook or just for those where the data is required from a link to another Domain Their use depends
34. ed that most information should be placed directly into the model Project Presentations containing folders for any presentations that will take place through the study e g the final presentation Project Report Contains the Word files used for the Project final report based on standard templates The following folders are contained within as follows e Project Report Inputs individual chapter inputs by domain or chapter based on standard templates from each domain specialist as author e Project Final Report chapter updates according to review cycle systems team lead and customer and final and fully compiled report and cover page e Project Yellow Book Inputs by chapter for Programme Board paper if required by study type optional e Project Cost Estimate Report Secure inputs for industrial and ground systems and operations chapters plus final compilation and cover page if required optional Table 2 1 Study Documentation Structure In Figure 2 1 below Project represents the actual study name as allocated The workbooks required for a CDF activity may include all or a subset of the workbooks available and new workbooks as required Additional workbooks are available for other activities i e Human missions ECLS Human Factors Re entry vehicles Aero thermodynamics Trajectory Instruments Antenna RF CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 9 of 48 CDF UM 001 Iss2Rev1 amp 0 Template St
35. em Level Margin The way these margins are used depends on the customer and the needs of the study Each sub system takes a margin related to the level of technical knowledge about that particular design as well as the likelihood of change This margin is first given at sub system level but when units are identified it is applied then at equipment level 5 1 1 EQUIPMENT MARGINS Every piece of equipment for each sub system is given a margin on mass based on its maturity There are three levels that are applied in the CDF model 5 for fully developed items e 10 for items to be modified e 20 for items to be developed One of these margins will be applied to each piece of equipment Each piece of equipment can be given different margins depending on their maturity In special cases it may also be necessary to give a piece of equipment a specific margin different from any of those above However in most cases the three levels above will be sufficient These equipment level margins can be used also by the cost and risk specialists to assess maturity It may be possible also to correlate directly to other parameters used for both cost and risk calculations 5 1 2 SUB SYSTEM MARGINS At the beginning of a study it will not be possible to identify all equipment or assess its maturity At that stage an estimate of sub system masses will have to be made An overall sub system margin is also estimated This can also follow the list in sectio
36. er of the spacecraft e g orbit perigee This can then be discussed and accepted or rejected If accepted the parameter is changed Save the workbook of that domain inform CDF Administrator to ensure model update The Systems station then updates the information in the Data Exchange The Systems station then Saves the Data Exchange and this downloads the new information into the file saved on the network 7 All domain workbook specialists can then update their link to the Data Exchange to get the current information 8 The domains then download the changes in their outputs due to the initial parameter change this download is done simply by Saving the domain workbook 9 Steps 5 to 8 can then be repeated a number of times to propagate the effect of the initial change around the system AU CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 34 of 48 CDF UM 001 Iss2Rev1 It must be noted that there is no real way to tell when the effect ofa parameter value change will be complete It is possible that its effect will continue to affect the system through several iterations This can complicates matters and care must be taken when updating and downloading information CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 35 of 48 CDF UM 001 Iss2Rev1 4 MODES OPERATION AND MECHANICAL STATES To allow efficient use of the model and to reduce time wasting during sessions a number of ap
37. eter Cell Name Identifies the name given to the Value column cell e Internally Linked should contain only linked information i e that in Data Exchange Manual Value should contain values inserted by the user i e initial assumtpions or those not linked to working sheets e Value Contains the data that has to be passed through the model This data can be numerical or a small amount of text e Units Give the units of the numerical information e g S I units Remarks Used to pass on information about a parameter to the user referencing that data CDF UM 001 Iss2Rev1 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 24 of 48 gt jan e fo Where you can enter comments Use the switch to say which column to export the data from fi ee O aget Launch Mass Payload Mass Dry Mass with margins Launch Wet Mass Stabilization Type Spin rate Pointing Direction Pointing Knowledge Pointing Accuracy Pointing Stability Determined By Design Life time SiC name SIC Reference frame origin SIC reference frame axes ESE B8 S ES Ft ES ES Launch site Latitude Launch site Longitude For calculated results create the link to this column For estimates enter the value here in the manual column Sys Target Taunchmass 545 patloadmass sys dry mass wm 10728 kg sys wet mass 687 28 100000 ka 54
38. f Design Cases Such design cases can then be used by other sub systems to identify their operational state during these periods resulting information can be added to the Results sheet of all sub systems which can then be linked to the sub systems that are using these design cases e g Figure 4 5 CDF UM 001 Iss2Rev1 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 40 of 48 Micrezelt Excel gropultion xc Reed 55 S 5185 SN ST 19 pi Yew Duet ods Dita Widow AUCTIONS Hep E PRAT rome gt CS ROG Enek Power Design Cases 0 Figure 4 5 Application of Design Cases to Propulsion Results Worksheet If there are operational states that are design cases for several sub systems then there must be only one source for the definition of that case It should be decided in which workbook the definition should be stored For most cases it will be added to the Power sub system workbook CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 41 of 48 CDF UM 001 Iss2Rev1 4 2 Mechanical Changes Events As well as operational modes for electrical state there is also a need for changes in mechanical states of a system This change may be a reduction in mass or a change from stowed to deployed states This will result in a change to mass values and or moments of inertia The system can define
39. g their own sub system modes of operation and then seeing what sub system modes are used during certain System level modes 3 Each sub system then supplies maximum and average power levels in each mode for each piece of equipment They can also supply other information per mode such as data rate The cell names of these values will be set out in a specific way to ease insertion into the power budget 4 The power data budgets can then be calculated and the electrical and thermal systems sized Problems can then be highlighted and specific problem areas focussed on 5 If required sizing cases can be established and published to the rest of the model 6 Sub systems then supply information on the design cases to allow more detailed sizing of the electrical systems 7 design process can then iterate using the design cases changing the requirement of these cases and to optimise the system 4 1 2 DEFINING SYSTEM LEVEL MODES As soon as possible in the design process the Spacecraft Modes of Operation should be defined This initial definition can be done off line out of session time and then verified within a session These modes should be defined within the Systems workbook systems xls using the sheets available as follows CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 36 of 48 CDF UM 001 Iss2Rev1 Modes sheet see Figure 4 1 defines the modes at system level and summarises their major features It also inclu
40. hat can be used to identify the note and filter through all of them more easily There are help comments within the Title headers of each column which explain what they should be used for The notes can then be filtered at any time using the Autofilter menus also contained within the Title headers as shown in Figure 3 13 Design Notes ME ED Figure 3 13 Autofilters in the Notes sheet This sheet can be used during design sessions and at any other time to record issues related to the specialists involved The domain specialist should add all relevant information here It can then act as a record of the design process and also be used in the creation of presentations and reports The filter allows different types of information to be displayed which can then be used to create slides e g Design Drivers etc The collection of sheets throughout the model can be used to form the minutes of sessions They can also be used to communicate greater amounts of information through the model It is important that each specialist fills in this sheet to the best level possible 37 MenuSheet This sheet is hidden from view to avoid any accidental changes and an example is shown for reference in Figure 3 14 The menu sheet was created to specify the parameters of a menu called FUNCTIONS created especially for the model Macros within the workbook use the data within the sheet to set out the menu This sheet is also used to store lists that are used in p
41. i Et isan Latu Dj OLD Beech end Danan d 2 um Figure 3 12 Example Domain Specific Worksheet As much calculation as possible must take place within the domain workbook external tools should only be used if absolutely necessary This allows the design process to proceed faster reducing the time needed to go and use analysis tools outside the design room At the minimum the working sheets should be used to store the current information available on a given domain To aid speed and simplicity databases of relevant information can be added e g information on different equipment technologies and manufacturers As the CDF develops and matures it will be possible to complete calculations on the demands of a sub system and then be automatically access equipment information from a database capable of meeting those demands The attributes of the equipment can then be passed to other domains 3 6 Notes Sheet A sheet has been added to each workbook that allows notes on various aspects of the design to be stored within Excel This sheet has been given a flexible form to allow it to be used for several types of information such as e Actions open or closed CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 30 of 48 CDF UM 001 1562 Rev Design Assumptions Design Drivers Requirements Options Any other general notes Several columns are present within the sheet t
42. ine operations Establishing Design Cases rather than sub modes of the Spacecraft Modes reduces the amount of work required to optimise the system see Figure 4 3 Some sub modes may not be Design Cases and so do not need defining during the study Design Cases may also be more specific than a sub mode focusing on the exact design issues Optimising the system with Design Cases can mean that other operational cases then become Design Cases and the initial cases are less critical This may lead to several iterations The initial Design Cases should remain stored in the model with new cases added Timeline Phase SPACECRAFT MODE Design Cases A 1 SPACECRAFT MODE 2 Sub Mode D Se ee Phase B SPACECRAFT MODE 3 Figure 4 3 Design Cases selection to reduce study timeline Design Case information can be passed across the model in a similar way to the Spacecraft modes The description of each case can be written in the relevant workbook e g power workbook for power Design Cases and so on The format can be exactly the same as for the Spacecraft Modes An example of application of design cases is shown in Figure 4 4 CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 39 of 48 CDF UM 001 Iss2Rev1 Overall System Modes of Ompmoration Description of Power Sub system Design cases ante SEP FIRING 1 SEP FIRING 2 Eclipse Operation Figure 4 4 Example Application o
43. inly used for the set up of new studies and reference material 2 1 1 STRUCTURE OF A PROJECT FOLDER Within a Project folder there are several folders related to different aspects of that study each containing files and or folders The folders are named according to the individual project CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 8 of 48 CDF UM 001 Iss2 Rev Project Admin Contains any files related to the administration of the study such as manpower information Project Meetings Stores the minutes of all the meetings held during the project Other files can be added to complement the main minutes file Project Miscellaneous Contains any other files needed for the study including the Study Reference files Project Model Contains the MS Excel model workbooks being worked on during the design There should be only one workbook for each domain No other files should be stored here This also contains a folder called CATIA and IMAGES used to store all CAD pictures The complete set of workbook files includes as standard aocs ground_systems programmatics simula tion comms instruments Propulsion structures cost mechanisms pyrotechnics system data_exchange mission Radiation thermal data_handling power Risk Project Notes This contains Word files for each domain that can be used to store information gathered during the design These files can then be used to help in the writing of the final report It should be not
44. l state is difficult To avoid overloading Results with extra parameters a very simple approach has been considered Rather than setting out very specific parameters such as the mass per unit for each mode Description and Value parameters can be used Several sets of Descriptions and Values parameters can be used for each Mechanical State to describe any change in Mechanical Property of a given sub system The Description parameter can be used to explain the change textually and the Value parameter can be used for any related numeric data such as change in mass CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 42 of 48 CDF UM 001 Iss2Revl These parameters be used for every project but the types of values and units will likely change from project to project It will be down to the users of this information to organise their inputs from project to project to deal with this difference The parameters can then be interpreted to modify results for Mechanical States and therefore Phases and Events during the mission CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 43 of 48 CDF UM 001 Iss2 Rev 5 MARGIN PHILOSOPHY Margins are a key feature of all engineering design and their application and the values allocated are provided for within the CDF model 5 1 Mass Margins There are three levels of margin that can be placed on the Mass Budget of the model 1 Equipment Level Margin 2 Sub System Level Margin 3 Syst
45. m mission Mode 53 0 Mode S4 Oper Mode E Mode Mode E3 0 Mode E4 Ope Three Mode 1 Power consumption maz Mode 1 Power consumption nominal Mode 1 Power consumption min j sheets instruments instruments instruments For each For each For each Mode 2 Power consumption maz 55 condensed Power SS Sum 4 instruments Figure 3 5 Worksheet column identification To change which value is being used in the Used Value column simply select the relevant Switch cell and choose the required option from the list given 3 3 3 REFERENCE FIXING The links references to the Data Exchange sometimes require changing due to errors with Excel s automatic reference changes or to add the workbook to a different directory or study To change the reference a macro has been included which stores references to the Data Exchange The accompanying macro takes the sheet name and cell name from the reference and stores it in the hidden column Selecting the required cells in the Linked Value column and then pressing the STORE REFERENCES macro button at the top of the page can activate this macro see Figure 3 6 Two macros have been produced as follows 1 Takes the original referenc
46. n 0582 17 By H ll e are gt s ae a A amoo n F 2 inputs for System Workbook 2 mim 4 2 a ton 3 T3 Launcher Wai n Loened Option Types 12 18 d LL E z 2 4190 Inpute Adrin Chart CESAR SUMMARY Yaman Defintion Medan cf Operator 4 Opern a Ener N SA NTA 5 Now go to the Data Exchange workbook find the parameter you wish to reference Make sure the value is usable and that the units are matched to your inputs sheet Select the Value cell of this parameter so that in the Function Bar it shows 6 Data Exchange xls domain sys_date for example 7 Then press lt gt the link should now be established Check that you have linked to a cell name and not a direct reference e g not D14 8 Change the Text colour of the input Value cell to pink to show that it has been linked 3 3 5 MANAGEMENT OF INPUT PARAMETERS Once links have been established input parameters should be managed with a workbook so that the values required for a given version of the systems are correct Some parameters might be needed for some versions and not others Also the values of certain parameters may not be correct i e the supplier has not updated for some reason You should be aware of su
47. n 5 1 1 Eventually equipment will be identified and margins produced for each of them The overall sub system margin can then be made as an average of the equipment margins It may also be appropriate to increase this margin to account for overall sub system uncertainties Example CDF JM 01 issue 2 revision 1 Date 23 01 03 44 of 48 Equipment Mass without margin kg Mass with margin kg Equipment Equipment2 222 99 CDF UM 001 Iss2Rev1 Equipment3 L TOTAL TANANAN 30 45 Addition of Subsystem margin 15 12 842 2 31 kg 27 15 In most cases it will be sufficient to leave the overall margin as the average of the equipment margins without adding any other extra margin In some cases this will be a decision made at system level 5 1 3 HIDDEN MARGINS Within each sub system there may also be margins placed on calculations or other parameters which affect the mass e g total power consumption margin It is important that these margins are highlighted and taken into account when calculating sub system mass margins 5 14 SYSTEM MARGIN A mass margin is also inserted at System level to account for possible design e g missing equipment and technology uncertainties This is placed in addition to the total system mass with sub systems margin Normally this is a figure of 20 as appropriate to the feasibility study level 5 1 5 IMPLEMENTATION IN THE MODEL masses an
48. n be added and or moved it is necessary to create cell names for every parameter These names then have to be applied to the value column so that when the sheet is copied to the Data Exchange other users can reference a cell name rather than an absolute cell position e g A1 This means that if the parameter changes its row e g row 23 to row 24 referencing the information still gets the correct values If the position 1 of the cell is the reference then when the row is moved the reference does not account for this and points to the wrong cell It must be remembered that writing a cell name into the Cell Name column is not enough the name must then be used in the Value column see below CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 26 of 48 CDF UM 001 Iss2Rev1 The first three letters of any cell name should be an acronym given to that domain 1 ABC parameter definition This acronym should be the first three letters of the domain name The rest of the name can be used to describe the parameter e g SYS total wet mass The cell names can be applied to the Value column of the Results sheet by selecting the cells of the Cell Name column and Value column Then select the Create Cell Name option on the CDF menu and the names in the Cell Name column will be applied to the Value column See example of Figure 3 9 IUUD PEST si 2 15 Wee port Fam Took Qaa Window FUNCTIONS bhp
49. ng continually developed to make parameters more generic to allow their use in different projects In many cases parameters have been grouped and given specific cell names which must not be changed CDF UM 001 Iss2Rev1 The outputs of the spacecraft sub system workbooks must be set in a uniform way that is consistent throughout the model Most of the outputs for these domains can be classed as either Sub System level information or Unit level information a Unit is defined here as one level below sub system level A template has been used known as the Unit Block which sets out generic parameters at System level and also at Unit level It is important that the cell names of the template are stuck to so that integration of the model i e referencing in the input sheets can be simplified The Sub system level parameters are placed at the top of the Results sheet and can be completed during the first iterations of the design At the beginning this information may be just an estimate but it is still important to include it within the Outputs for data exchange The basic parameters will remain the same from project to project but there will be some need for customisation between projects An example is shown in Figure 3 10 a eee ee ee ee Sel gt 6 d NIN SS Rie 4 gt 22 WA 144178 nissan Cqupmertt 13
50. oncerned and ask them to produce the value and place it in their Results sheet to enable a link If there is a major problem then the Systems Analyst should be notified Changing the Data Exchange could cause serious problems to the integration of the model You must not attempt to do anything to this book unless this is with the agreement of the caretaker of the model 3 8 2 OVERALL DATA EXCHANGE PROCESS The process for all workbooks including the Data Exchange is the same i e the user has the responsibility for implementing the updating of information and the downloading of data to the rest of the system 3 8 2 1 The Data Exchange The Data Exchange will be the responsibility of the Systems specialist They will have the responsibility for making sure the existing parameters in the Data Exchange are up to date However as mentioned in the previous sections it is the responsibility of the individual domain specialist to make their inputs reference the correct cells of the Data Exchange 3 6 2 2 Steps to the Process The ideal process for use of the model is given below however it is likely that the actual use of the Data Exchange may be more flexible This includes updating values out of a session At the beginning of a study many of the links will not be properly established Thus this will require inputs to be manually inserted in the Inputs sheet by the respective domain specialists A proposal will be made for changing a paramet
51. perg poppi LI LI bearers growod statics and Ths ac aball remem procs waco rao Comtingeney Situation etan nak t i dutec tco sip be det v ESOC proram TCR it te al anana anan a Figure 4 1 S C Modes of Operation Modes1 sheet CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 37 of 48 CDF UM 001 Iss2Rev1 Modes2 sheet see defines the requirements placed on each sub system by the system for each mode Each sub system is given a descriptive summary of the requirements placed on it This information is connected to the Results sheet and passed via the Data Exchange Microzalt Excel els awlas i oL BI ES DJ _ Mx S E is Fann Took Data Window FUNCTIONS Hp Dg SAY gt Se TAHT Oe gt 5 Hen Ronn LB f Aww 5 A 1 gt Sub system Requirements per Mode of Operation el Mode Sub system Requirements KA Jane Ez TED LGA Wher ig Sera bed of 81 DATA TED Fura FA gah I TaS Bi TETAAYANTS TED OFF mi 4 LM veces TBD Hi FOYER TBD
52. proaches have been defined for the passing of information through the model and therefore the design process It is important that design cases are identified and a clear way of passing the data relating to these cases is implemented This requires certain rules to be followed by the domain specialist within sessions and when implementing their models If these methods are deviated from then this could lead to many internal problems in the model Links have and will be set up specifically for approaches explained below Changing procedure could very well mean that the links will become invalid and new links will have to be established wasting valuable study time 4 1 Spacecraft Modes of Operation The modes of operation of the spacecraft are defined to enable the electrical data domains to size their systems An approach has been followed to be flexible generic to enable use with different projects The method has been specifically chosen for the model data transfer and to allow the power budget to be completed 4 1 1 SUMMARY OF METHOD The following method is recommended as follows 1 The modes of operation of the spacecraft are identified and defined in the Systems workbook to a level of detail that can be used by each sub system to understand the requirements imposed during each mode 2 Each sub system then identifies the equipment that is required in each mode and the period of time needed for the equipment This may mean identifyin
53. references to the various sheets of the Data Exchange to their Inputs sheet Only the Systems specialists can change and save this workbook 3 8 1 DATA EXCHANGE MACROS The workbook contains macros which allow for the update to take place A menu option called DATA EXCHANGE is available in the menu bar containing the option to update values When selected a window appears allowing the selection of one or more sheets to be updated as shown in the example below 0 3 i BL T PEE 5 tdt pst Format Window Heb dal xi OSM SAS Arial Sx fir gt gt 4X4 6 883 Y Sub system s to update data from instruments Instruments sheet is selected for update CESAR Update all Update Selected Cancel CDF JM 01 issue 2 revision 1 Date 23 01 03 Page 33 of 48 CDF UM 001 Iss2Rev1 3 6 1 1 New Inputs and Outputs It is up to the user to add inputs outputs to the tables provided by the new sheets These values can then be linked to your working sheets Links must be established so that if a value in the input sheet changes the working sheets are updated automatically Similarly when values change with your workings the Results sheet will reflect these new values automatically If a new value is required from another domain then the user must approach the specialist c
54. s column If you would like to cancel and select the correct cells press the No button If correct press the Yes button the macro will now proceed 6 A new window will appear asking you to select a file path from a list or create your own If you have any doubts read the help by clicking the button Select a file path by making it visible in the box and click on the Continue button The macro will then proceed until all selected cells have been modified 3 3 4 REFERENCING INFORMATION IN THE DATA EXCHANGE Once parameter outputs have been loaded into the Data Exchange individual workbooks can begin referencing the data A Data should only be referenced if it is certain that it gives the correct results If the cell is blank or has a zero in it then it may not be wise to reference it Contact should then be made with the supplier to verify their numbers CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 20 of 48 CDF UM 001 Iss2Rev1 Linking to Value Cells The first method can be used when you have already created the parameter in a list and only require the value cell to be linked Steps 1 Open both the Domain and Data Exchange Read Only workbooks 2 Select the domain Input sheet 3 Highlight the Linked Value cell of a required input parameter 4 Type in equals so that it appears the Function Bar CBE gv Sei e f a ES Dd 19 Ble Duet Format Inds Data CESAR Hep Type i
55. t apogee Target lax pressure constrai target target Ha Target orbit inclination 5 Target Orbit target i Target orbit right assention node SYS Target Orbit target Target orbit argument of perigee target arg per Launch site latitude ite lati Launch lat Launch site longitude 155 Launch long Launch site altitude 575 Launch Launch alt 33 Overall Drag Coefficient sgstem SYS Overall Drag Overall Drag 4 notused At the beginning of the study put in Link these cells to estimates for your inputs here if the calculations In your value in the linked column isn t calculation sheets present Figure 3 3 Summary of Input sheet use An example System Workbook Input sheet is shown in Figure 3 4 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 16 of 48 CDF UM 001 Iss2Rev1 X Microsoft Excel systems Read Only BEE File Edit Insert Format Tools Data Window FUNCTIONS Help EN DEH amp SERIE eed zh Br E inputs for System Workbook INSERT ROW Launcher Name Launch Option Type Mazimum Launcher Pasload Mass Launch Site i n Adapter mass included with S C Launch Mass auncher Adapter Mass Proposed Launch Date 07 Jan 07 Mission Duration 39089 REF REF DESIGN LIFE TIME Total Mission Time DOB4 gt 4 5 Ready pa panji T Figure 3 4 Example System Workbook
56. tation Duration REF urs 26 SIC name 27 SIC Reference frame origin description 28 SiC reference frame axes description 29 Launcher If lander define descent trajectory if cruise 30 Orbit type module define the interplanetary trajectory 31 Orbit inclination deg 32 Orbit apogee Km 33 Orbit perigee Km 34 Orbit right asc of ascending node deg 35 Orbit argument of perigee deg 36 Total Delta V mis 3 Ground Station coverage deg If lander define visibility from orbit Maximum eclipse duration min Time to reach operational orbit Select unit as appropriate 4 IMAN Administration_fNOTES Inputs Results Admin Resp 4 Regts Assumptions Drivers Trade 0ffs Options 4 Check panel Summary 4 Note This sheet is automatically completed Figure 3 8 Example Results Sheet The Results sheet of a workbook provides the essential analysis outputs It is also for data that will be passed through the system through the Excef Links using the Generate Outputs macro located in the FUNCTIONS menu This also implies that the Results sheet will contain only links to data that is stored within your working sheets 3 4 CELL NAMES Due to the limitations of Excel software the Results sheet of each Domain must be set out in a certain way The sheet should be a list of parameters set out as shown in the Template To make Results sheets flexible enough so that rows ca
57. tween the manual and linked values for use in the working sheets The colour of the cell also changes to make it easier to see which value is being used green linked Blue Manual White Not Used Cell Name Identifies the name given to the Used or Retained Value column cell One can give name to be used in the working sheets calculations Used or Retained Value This holds the value which should be referenced in the working sheets The cells contain IF statement which selects either the linked or manual value column depending on the selection in the switch cell of that row Units Give the units of the numerical information e g 5 1 units Source Used to identify where the Domain user expects that information to be generated This is also useful in the initial phases of integration to establish what is expected from each Domain output Status Can be used to give information about the parameter such as TBC for example Remarks Used for any other comment required about the data CDF JM 01 issue 2 revision 1 Date 23 01 03 15 of 48 CDF UM 001 1562 Rev Use switch to say which column to use data CORRECT REFERENCES Mass of power SS with Margin 55 MI power Mass of propulsion SS with Margin Minimum payload mass i 30 M_payl Maximum heat flux density constraint THE i lax heat flux constrai Maximum dynamic pressure constraint Target orbit perigee Target orbi
58. udy OF x File Edit View Help Project amp dmin 2 ProjectMeetings ProjectReport i ca ProjectMiscellaneous File Edit View Help ProjectModel E ProjeciNotes Project Cost Estimate Report ProjectPresentations Project Final Report Ii ProjectReport Project Final Report Inputs C Project Report Template E Project Yellow Book 9 Project Yellow Book Inputs 4 aii gt 1 object s selected 5 object s 0 bytes 7 Figure 2 1 CDF01 Working Directory Project Directory Template 2 2 Master Directory The MASTER directory contains archived data from completed CDF studies organised as folders under each study title In addition CDF documents reference databases infrastructure documents are contained herein described the CDF Documentation Management 3 Many information database and document sources are available to CDF engineers including International Space Station Ground Segment Launchers Missions Platforms Components Studies and Acronyms amongst others Access to this directory is restricted as appropriate to a data repository The structure is depicted for information in Figure 2 2 Each study folder contains the final reports and the model versions for reference CDF UM 001 Iss2Rev1 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 10 of 48 File Edit View Help 0 Information 0 Database D Infrastucture Docs 0 XLModels CESAR Stu
59. ull down menus in other sheets The list of menu option can be added to as more macros are created The names used in the menu can also be changed here The sheet is also used to contain the choices cells for the switch column of the Input sheet Both the lists for the menu and the choices cells can be extended if required The choices cell name requires re applying to the entire list if changes are made CDF UM 001 Iss2Rev1 CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 31 of 48 The sheet is also used to store the links to the system version number and date found in the Systems workbook There is also a link to the Input sheet collecting to system version number and date stored from the last time the workbook was updated These values are shown to the user when the workbook is opened to see whether the link to the Data Exchange needs updating er se el 3 8 3 As sof BI 133 Bik D 255 E a BaF 1 FUNCTIONS manual 2 Update values Subpdatevalues U linked 2 amp Change status Subchangestatus TRUE 72 not used 2 amp Create cell name create cel names TRUE 3 System ardaok Date System ardaok Version No Data Exchange System Date Data Exchange Systern Version Exchange xis systems 218 gt CIUDA 2 Tros 2 CAD aimer CAO ratus 2 COC 4 v hoo N DIOB4 5 2 A c2ziBa
60. ust close it by clicking the End button If this problem continues inform the Systems Analyst for solution CDF UM 01 issue 2 revision 1 Date 23 01 03 Page 12 of 48 CDF UM 001 Iss2Rev1 Updating the Model Remember that you responsible for updating the values in your workbook through XL links or manually Please make sure the values are up to date Last Updated 0 Current System 0 13 Version Number Version Number Last Updated 11 24 99 Current 12 14 99 System Date 1241 System Date 14 To update values from the Data Exchange now press the button below Figure 3 1 Domain Workbook Example Configuration Management Form 32 General Overview Each Domain workbook consists of a number of sheets These sheets can be categorised in three areas Results Inputs and Working sheets that are customised by each specialist for general and study specific data An Administration sheet is provided for configuration control purposes the sheet displays the following a Workbook version number for model template version control b Expert personnel responsible for the Workbook and sheets contents and c Workbook change record A sheet called MenuSheet also exists which contains information for the generation of special menus as well as cells used for other functions macros This sheet is hidden and normally not used by the domain specialist whilst working on studies However the system analyst has
61. word For write Cancel access or open read only Password Read Only OK If this window does not appear then the password should be re applied to the file This is done in the options when using the Save As function This password should be kept the same and the System Analyst should be kept informed of correct password The CDF Administrator is responsible for issuing permissions for the use of domain workbooks for each CDF study 3 12 CONFIGURATION MANAGEMENT FORM Another window should also appear when opening the workbook as shown in Figure 3 1 This Updating the Model form is used to help keep all workbooks up to date It shows the System Date and System Version number which is currently stored in the Systems workbook and the Data Exchange and compares it with that stored in the users workbook taken from the last time the workbook updated its values from the Data Exchange If the two sets of values are different then it is down to the user to update their workbook Do this by clicking the update button The values should then change to show that the workbook is consistent with the system form can then be closed Overall CDF configuration control including model version numbering is described in the CDF Configuration Management 4 The macros associated with this form require links to other files If the file is in the wrong directory for any reason then the macro will fail The debug window will appear If this appears j

CDF USER MANUAL

Contents

Download Pdf Manuals

Related Search

Related Contents