194.6.0.55300genpref/savepref/choices21disppref/fieldLabel0disppref/valueLabel0disppref/quotesymb0disppref/realdisp0genpref/savepref/data1genpref/savepref/library1genpref/savepref/datadirC:\DOCUME~1\ataieb24\LOCALS~1\Tempgenpref/memmgr/enabled1genpref/memmgr/auto1genpref/memmgr/minmem200genpref/memmgr/maxmem250connpref/connupdate0execpref/formula/critical0genpref/savepref/savelengthTRANS2750392720081022154039Transformation 1Iteration7BoolOption200InfoBitmap7ErrorFilterGroupListSH7Connection 19024048549Connection7ConnectionNameCONNECTION1TableNameDescription7

SH90SH160

SH9Créer champs Moyenne par etudiant27024648544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code"moyenne"5"moyenne"Type"Real"5"Real"FormulaToCreate[formule]5[formule]Label5Description5Category5FieldToCopy5CreateField4InputJoin4InputSort4OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH120SH240SH110

SH11Creer Ligne Moyenne Moyenne570390485423CreateRow7RecordsNumber1FormulaRecordsNumber5OutputTableInfo7TableName5CreateFieldSpecialEntry7Code[Code]5[Code]Type[Type]5[Type]FormulaToCreate[Formule]5[Formule]Label5Description5Category5FieldToCopy5CreateField4Description7

SH121

SH12Union67035048540OutputTableInfo7TableName5Union7OnlyFieldsFirstTable200Description7

SH16Lire Metadata180110485421MetaFields7FieldChoosen211100BasicStats2000000TableInfo20AttributeInfo200AttributeTypeOutputTableInfo7TableName5Description7

SH170

SH17Sélection30011648543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection5OutputSelection7FieldSelection7FieldSelection3CodeLabelTypeFieldChoosen2100Parameters1Distinct20OutputSort4Description7Description

SH180

SH18Sélection champs différents de "Nom de l'étudiant"44512248543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection[Code] <> "Nom de l'étudiant"5[Code] <> "Nom de l'étudiant"OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH200

SH20Créer champs59012948544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameconcaténationFormulaTypesymbolicFormulaToCreateGPSTRCAT([Code],"],[")5GPSTRCAT([Code],"],[")FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3CodeFieldChoosen20Parameters1Distinct21OutputSort4Description7

SH210

SH21Créer champs ajout de avg72613448544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameformuleFormulaTypesymbolicFormulaToCreateSTRCAT( "avg([",[concaténation],"])" )5STRCAT( "avg([",[concaténation],"])" )FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3concaténationFieldChoosen20Parameters1Distinct20OutputSort4Description7

SH9-1

SH24Lire Metadata380490485421MetaFields7FieldChoosen210100BasicStats2000000TableInfo20AttributeInfo200AttributeTypeOutputTableInfo7TableName5Description7

SH270

SH26Créer champs53054048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameFormuleFormulaTypesymbolicFormulaToCreateIF ( [Code]<>"Nom de l'étudiant" , STRCAT( "GPAVG([" , [Code] , "])") , "\"Nom de l'étudiant\"")5IF ( [Code]<>"Nom de l'étudiant" , STRCAT( "GPAVG([" , [Code] , "])") , "\"Nom de l'étudiant\"")FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH11-1

SH27Créer champs44060048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameTypeFormulaTypesymbolicFormulaToCreateIF(OR([Type]="integer",[Type]="real"),"Real",[Type])5IF(OR([Type]="integer",[Type]="real"),"Real",[Type])FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3CodeTypeFieldChoosen210Parameters1Distinct20OutputSort4Description7

SH260

CONNECTION1Connection 100026j:\Desktop\notesetudiants.xls11350344610100Feuil1Feuil1122/10/2008 13:46:401CONNECTION2Connection 200026j:\Desktop\notesetudiants2.xls11350344610100Feuil1Feuil1115/10/2008 15:51:1220defaulttransformationInfo7TRANS27503927200810221540397graphicalAnnotation7FRAME57TextGraphPropCalcul des formules pour les moyennesCommonGraphProp7TextAligncenterBorderStylenormalBorderWidth0TextFontarial7info2-1100040000000000facenamearialTextColor0BorderColor0BackStyle1BackColor14348959DisplayPositionFRAME2310480620670FRAME47TextGraphPropCalcul de la formule de la moyenneCommonGraphProp7TextAligncenterBorderStylenormalBorderWidth0TextFontarial7info2-1100040000000000facenamearialTextColor0BorderColor0BackStyle1BackColor2419404DisplayPositionFRAME211070830210FRAME17TextGraphPropCalcul des MoyennesCommonGraphProp7TextAligncenterBorderStyle3dBorderWidth1TextFontarial7info2-1100040000000000facenamearialTextColor0BorderColor32768BackStyle1BackColor65535DisplayPositionFRAME2250220780470graphicalOrder3FRAME5FRAME4FRAME1SH7SH9SH11SH12SH16SH17SH18SH20SH21SH24SH26SH27groupId2-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1groupIsMaster2000000000000000windowState7TRANS27503927200810221540397windowPos200158384windowCmd3windowOrder3TRANS2750392720081022154039UniqueIdlib132401797120081022154039110241073318231premier.ASB