All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • data.IntegrationExampleTest.xls Maven / Gradle / Ivy

    There is a newer version: 6.2.0.Final
    Show newest version
    ??ࡱ?>??	E????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????H	

 !"#$%&'()*+,-./0123456789:;<=>?@ABCD????????G????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????R???????? ?F??
D?F?Workbook????????/?SummaryInformation(?????DocumentSummaryInformation8????????????X	O?????\pCharles Moulliard                                                                                            B?a=???=??? 8?@?"??1???OArial1???OArial1???OArial1???OArial1???OTahoma1?	?OTahoma1.??OTimes New Roman1.??OTimes New Roman1??OArial1???OTahoma1???OArial1???OArial1h>?Cambria1,>?Calibri1>?Calibri1?>?Calibri1??Calibri1??Calibri1?<?Calibri1?>?Calibri1???Calibri1?4?Calibri1?4?Calibri1?	?Calibri1?
?Calibri1??Calibri1??Calibri1?	?Calibri1??Calibri3#,##0\ "? ";\-#,##0\ "? "=#,##0\ "? ";[Red]\-#,##0\ "? "?#,##0.00\ "? ";\-#,##0.00\ "? "I"#,##0.00\ "? ";[Red]\-#,##0.00\ "? "q*6_-* #,##0\ "? "_-;\-* #,##0\ "? "_-;_-* "-"\ "? "_-;_-@_-k)3_-* #,##0\ _? _-;\-* #,##0\ _? _-;_-* "-"\ _? _-;_-@_-?,>_-* #,##0.00\ "? "_-;\-* #,##0.00\ "? "_-;_-* "-"??\ "? "_-;_-@_-{+;_-* #,##0.00\ _? _-;\-* #,##0.00\ _? _-;_-* "-"??\ _? _-;_-@_-??? ? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ? ? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ???? ??? ?ff??? ?+?? ?? ?)?? ?? ?,?? ?? ?*?? ?? ??? ?? ??? ?? ??? ?P?? ??? ?P? ??? ? ?? ??? ?? ?	?? ?? ??? ???? ??? ?`? ??? ?? ??? ?? ??? ???? ?	?? ?? ?
?? ?? ??? ?a?? ??? ?? ?1 ? ?1? ?1 L? ?1 l??1 l? 0? ?
1 l/?
1 lQ/?1 l??1 |? p? p? ?
1 l??1 l/?1 l/?1(\? ?
1(|??1)|/?1(|/?
1|?
?
1|!??
1|??
1|+
?1\? ?
1<? ?
"|? ?
1"|? ?
1*<? ?1 L? ?
"|? ?
*|? ?1"|? ?1|? ?1 D? ?
1 l"/?
1"| "/?1 ? ?
1"|? ?
1"<? ?
1"|??1 <? ?1 |Q?	1Q ?? ?
1 |Q/?
1 |QQ/||l@XN?}A}
_? _-ef#0.0}A}
_? _-ef#0.0}A}
_? _-ef#0.0}A}
_? _-ef#0.0}A}
_? _-ef#0.0}A}
_? _-ef	#0.0}A}
_? _-?L#0.0}A}
_? _-?L#0.0}A}
_? _-?L#0.0}A}
_? _-?L#0.0}A}
_? _-?L#0.0}A}
_? _-?L	#0.0}A}
_? _-23#0.0}A}
_? _-23#0.0}A}
_? _-23#0.0}A}
_? _-23#0.0}A} 
_? _-23#0.0}A}!
_? _-23	#0.0}A}"
_? _-#0.0}A}#
_? _-#0.0}A}$
_? _-#0.0}A}%
_? _-#0.0}A}&
_? _-#0.0}A}'
_? _-	#0.0}A}(
??_? _-????#0.0}?})
?}?_? _-????#0.0?-;_-??\ _	?@_-@
?ӇDӇ@}?}*
_? _-????#0.0????-;_-?????\ _	????@_-@
????ӇDӇ@}-}/
?_? _-}A}0
a?_? _-????#0.0}A}1
_? _-#0.0}A}2
_? _-??#0.0}A}3
_? _-23#0.0}-}4
_? _-}?}6
??v?_? _-?̙?#0.0?-;_-??\ _	?@_-@
?ӇDӇ@}A}7
?}?_? _-???#0.0}A}8
?e?_? _-???#0.0}x}9????_? _-???????#0?????-;	??????\
?????@_}?}:
????_? _-????#0????-;	?????\
	????@_-@
????ӇDӇ@}-}<
_? _-}U}=
_? _-#0-;	}-}>
??_? _-?
20% - Accent1?M??
20% - Accent1ef?????%?
20% - Accent2?M?"?
20% - Accent2ef?????%?
20% - Accent3?M?&?
20% - Accent3ef?????%?
20% - Accent4?M?*?
20% - Accent4ef?????%?
20% - Accent5?M?.?
20% - Accent5ef?????%?
20% - Accent6?M?2?
20% - Accent6	ef?????%?
40% - Accent1?M??
40% - Accent1?L?????%?
40% - Accent2?M?#?
40% - Accent2?L渷??%?
40% - Accent3?M?'?
40% - Accent3?L????%?
40% - Accent4?M?+?
40% - Accent4?L?????%?
40% - Accent5?M?/?
40% - Accent5?L?????%?
40% - Accent6?M?3?
40% - Accent6	?L?մ??%?
60% - Accent1?M? ?
60% - Accent123????????%?
60% - Accent2?M?$?
60% - Accent223ږ??????%?
60% - Accent3?M?(?
60% - Accent323?כ?????%?
60% - Accent4?M?,?
60% - Accent423????????%? 
60% - Accent5?M?0?
60% - Accent523????????%?!
60% - Accent6?M?4?
60% - Accent6	23????????%?"Accent1?A??Accent1O???????%?#Accent2?A?!?Accent2?PM?????%?$Accent3?A?%?Accent3??Y?????%?%Accent4?A?)?Accent4?d??????%?&Accent5?A?-?Accent5K???????%?'Accent6?A?1?Accent6	??F?????%?(Bad?9??Bad????????%?)Calculation????Calculation???????}?%??????	???*
Check Cell???
Check Cell?????????%???????????????	??????+??? ??Comma?,???(??	Comma [0]?-???&??Currency?.???.??Currency [0]?/Explanatory Text?G?5?Explanatory Text??%?	0Good?;??Good??????a?%?1	Heading 1?G??	Heading 1I}?%O????2	Heading 2?G??	Heading 2I}?%???????3	Heading 3?G??	Heading 3I}?%23?????4	Heading 4?9??	Heading 4I}?%?5???(??	Hyperlink?
6Input?u??Input??̙????v?%??????	???7Linked Cell?K??Linked Cell??}?%?????8Neutral?A??Neutral??????e?%????"??Normal?	9Note?b?
?Note????????????????????	??????:Output?w??Output??????????%???????????????	??????;???$??Percent?
<Title?1??TitleI}?%?
=Total?M??Total?%O???O????>Warning Text????Warning Text???%?X??TableStyleMedium9PivotStyleMedium4??8?????????????d??q:F?????????????3f??????ff???f??????????????????????????????????̙??̙3f?3?????????fff????3f3?f333?3?3f33?333\???`?nBTables?
bLists??eTables_2??????$
ClaimTypes;???"???j?b?(3???	?@@?
???@RuleSetSome business rules/For help: http://www.drools.org/Decision+TablesImport
SequentialtrueRuleTable Cheese fans	CONDITIONACTIONPersonCheeselist(descriptions)agetype
add("$param")CasePersons ageCheese typeLogOld guystiltonOld man stilton	Young guycheddarYoung man cheddar	Variablesjava.util.List listCheese Typesbrie@org.drools.camel.example.Cheese, org.drools.camel.example.Person?"Q2?2?43??3J??PK!??pO?[Content_Types].xml???j?0E????ж?r?(??΢?]??yl??#!MB??;.??n?̽?̨\?A?1&?ҫ??
???QW???Kv?Ub?OX?#&??????1`R??T?9<?l?#??$??>??r??	`?С?-?;c=1g?h?i?Ift??z?#??_Vu:??ۜ&.%$f5??s??/N?X?pª?U\'?t%?*?X*?tDG?HY7?}+N??j?~?V?K)=???s^?.??PZ7$??6?w???^PƦj??Sizo	(????g6??܈e1??Z??W?h??J???;L^???5??A???;???K?~3j?[n1^?f\?km?qH????5}?"?6????y7k?V??,?	??񳣑k#??????jn?]?^????go;]xL2p?Խ fJب?1M??5??G??[?I?LHu?el}h>?b?^???n?`?j?d7)?]????j׵d? ??:?2?mg_s$?KE?4/ќ-???M?>!?p`aZ??隶???bk?4?3-Cg?1?b???>?)2Β<)e0o?@?Zٍrﮊ???R???g??r'?P{ ??]??Δ?Dž?9?P?`"???h?Z?Ƈ#f?W?????a?6??FHP('*??,?軁???˒?LDUĕ?{N.?i?h?P?n?$?Cw=???X.??D??7??D??g$??j?	?C?F?q?8
	?W4Վ?_kw?6*Z?o??:?:#m?vq_?e??????44??/??bO?Є?P?	?v?d(?lJN?їm??)??J'?RЁ?ãI?q?jv??ͽV?4????h?h?w:???h8????!?0$?ش²??~??3?f?Te˺n??F¶??n???????y??R]??;??V??-|?[?y?????_?xA?i5?<\???3?o?888`4OCg??,????)???݃.??@???М??y?̠????ݜ??Ͳ9???_k~Qq??7????Fw?jz>??Ўe?_?)|?a?v???* 0?N??
??d?????PK!
ѐ??'theme/theme/_rels/themeManager.xml.rels??M
?0???wooӺ?&݈Э???5
6?$Q??
?,.?a??i????c2?1h?:?q??m??@RN??;d?`??o7?g?K(M&$R(.1?r'J??ЊT???8??V?"??AȻ?H?u}??|?$?b{??P????8?g/]?QAsم(????#??L?[??????PK-!??pO?[Content_Types].xmlPK-!?֧??6-_rels/.relsPK-!ky???theme/theme/themeManager.xmlPK-!?6?}?8&?theme/theme/theme1.xmlPK-!
ѐ??'?theme/theme/_rels/themeManager.xml.relsPK]?
	O?ZC.I
d????MbP?_*+??%?????&333333??'J??I????([?[???)?????????"	d,,?`?`???`?`??U
}*?}??}??}??}?@}??}??}??}??}		??}
*	?
?
?
?
?
?
?
?
?
A	
?A

?
?
?

??A
??A
??N:@?@?@????ggg?ggg?ggg?ggg?ggg?ggg?ggg?AgggB?
C?
h?
hD?
i?
ii		B?
	E?
	j?
	jD?	iii	
B?

F?

k?

kDAG?
H?IIJJJJJ	
K?

L?

M?

MK?
L	?
M
?
M?
O?
P
?
Q?
Q?
R?
S?
T?
UV?
W~
X??
Y?
Z[?
W~
\V?
]?
Z[?^^_^^^^^`
?
a?
b?_^^^^^c
?^^_^^^^^	?0?PD4
0448BBB4???D??,?(	?
????
?
??H?XX?m???X?P?P???$???
?x???]4
?
??C<DA keyword of "Ruleset" means that this worksheet is a ruleset, and it has a name in the next cell across. In the following lines, we can have imports, or other ruleset directives if we need to ad them in future.

Perhaps this is not needed - ruleset name can be XLS name, and imports are not really needed most of the time.<?C?????
?
??H??Z?m???X?P?P???$???
?F?
??]4
??
?? <!This is the name of the ruleset
< ?????
?
??H??Z?m???X?P?P???$???
?x?
??]4
??
??U<VI become a import at the ruleset level in drools. Normally this chunk will be hidden.<U?????
?
??H?X^?m???X?P?P???$???
?????]4
??
??"<#a comma seperated list of imports
<"?????
?
??H?xb?m???X?P?P???$???
?x????]4
??
??l<mThis is the flag that tells us that we need to set "salience" to be the row number for each rule generated.
<l?????
?
??H?Xe?m???X?P?P???$???
?	??	??]4
??
??'<(Maybe true or false (default is false)
<'?????
?
??H??g?m???X?P?P???$???
?\/7^?]4
??
??O<PLook at me !! I tell you that I am the start of a rule table, and what parameters I require !
(and their types).
The "RuleTable" keyword must appear on top of the first condition column.

You can have as many "RuleTables" as you like, just separate them by a line.

Note that all the columns to the left of this column will be ignored.<^O?????
?
??H?8a?m???X?P?P???$???
?=?At?]4
??
???<?Look at me !!
I tell you that I am a condition colmn. The next row down has the rule "template" and the row below that is a comment. After that, it is all rule data until an empty line !

Note that if there is no data in a row, then this condition does not apply. 

each row of rule data combines with a template to make a condition. Each row of rule data equates to a whole rule in a DRL file. 

Other column types: ACTION, NAME, PRIORITY, DURATION - refer to http://drools.org/Decision+Tables for details<??????
?	
??H?l?m???X?P?P???$???
???U?]4	
??
??<I am an action column.
<?????
?

??H?hl?m???X?P?P???$???
??
??]4

??
??A<Bnote that actions end with a semi colon - this is a drools thing.<A?????
?
??H?q?m???X?P?P???$???
?M2o??]4
??
??z<?Ignore me&  this column is really optional (as there is no "C" or "A" at the top etc) and is just for descriptive purposes
<z?????
?
??H?t?m???X?P?P???$???
?q?
??]4
??
??R<SI am the description of this condition that should be visible - just plain text. 
<R?????
?

??H?Hh?m???X?P?P???$???
??2??]4

??
??+<,I am the description of the action column.
<+?????
?
??H??w?m???X?P?P???$???
?vk?]4
??
??M<NMichael Neale:
This makes the "list" variable available to the rule templates<M		



	

>?@??@


?*	?*				

?????y??????K?0For help: http://www.drools.org/Decision+Tables???y??????K?Lhttp://www.drools.org/Decision+Tablesgg????D
	O??b?d
d????MbP?_*+??%?????&????????'????????(?'}?'}??)?'}?'}???"d,,?`?`???`?`??U
}}???????	?
???
????
?
d?
e?
dee	e
eee
efd???







?P?H ??0?(	?
?>?@??@??gg????D
	O??fXl
d????MbP?_*+??%?????&333333??'J??I????([?[???)?????????"	d,,?`?`???`?`??U
}*?}??}??}??}?@}??}??}??}??}		??}
*	?
?
?
?
?
?
?
?
?
A	
?A

?
?
?

??A
??A
??N:@?@?@????ggg?ggg?ggg?ggg?ggg?ggg?ggg?AgggB?
C?
h?
hD?
i?
ii		B?
	E?
	j?
	jD?	iii	
B?

F?

k?

kDAG?
H?IIJJJJJ	
K?

L?

M?

MK?
L	?
M
?
M?
O?
P
?
Q?
Q?
R?
S?
T?
UV?
W~
X??
Y?
Z[?
W~
\f?
]?
Z[?^^_^^^^^`
?
a?
b?_^^^^^c
?^^_^^^^^	?0?PD4
0448BBB4???D0??,?(	?
????
?
??H???m???X?P?P???$???
?x???]4
?
??C<DA keyword of "Ruleset" means that this worksheet is a ruleset, and it has a name in the next cell across. In the following lines, we can have imports, or other ruleset directives if we need to ad them in future.

Perhaps this is not needed - ruleset name can be XLS name, and imports are not really needed most of the time.<?C?????
?
??H????m???X?P?P???$???
?F?
??]4
??
?? <!This is the name of the ruleset
< ?????
?
??H?X??m???X?P?P???$???
?x?
??]4
??
??U<VI become a import at the ruleset level in drools. Normally this chunk will be hidden.<U?????
?
??H????m???X?P?P???$???
?????]4
??
??"<#a comma seperated list of imports
<"?????
?
??H??t?m???X?P?P???$???
?x????]4
??
??l<mThis is the flag that tells us that we need to set "salience" to be the row number for each rule generated.
<l?????
?
??H?8??m???X?P?P???$???
?	??	??]4
??
??'<(Maybe true or false (default is false)
<'?????
?
??H????m???X?P?P???$???
?\/7^?]4
??
??O<PLook at me !! I tell you that I am the start of a rule table, and what parameters I require !
(and their types).
The "RuleTable" keyword must appear on top of the first condition column.

You can have as many "RuleTables" as you like, just separate them by a line.

Note that all the columns to the left of this column will be ignored.<^O?????
?
??H????m???X?P?P???$???
?=?At?]4
??
???<?Look at me !!
I tell you that I am a condition colmn. The next row down has the rule "template" and the row below that is a comment. After that, it is all rule data until an empty line !

Note that if there is no data in a row, then this condition does not apply. 

each row of rule data combines with a template to make a condition. Each row of rule data equates to a whole rule in a DRL file. 

Other column types: ACTION, NAME, PRIORITY, DURATION - refer to http://drools.org/Decision+Tables for details<??????
?	
??H????m???X?P?P???$???
???U?]4	
??
??<I am an action column.
<?????
?

??H???m???X?P?P???$???
??
??]4

??
??A<Bnote that actions end with a semi colon - this is a drools thing.<A?????
?
??H????m???X?P?P???$???
?M2o??]4
??
??z<?Ignore me&  this column is really optional (as there is no "C" or "A" at the top etc) and is just for descriptive purposes
<z?????
?
??H????m???X?P?P???$???
?q?
??]4
??
??R<SI am the description of this condition that should be visible - just plain text. 
<R?????
?

??H????m???X?P?P???$???
??2??]4

??
??+<,I am the description of the action column.
<+?????
?
??H????m???X?P?P???$???
?vk?]4
??
??M<NMichael Neale:
This makes the "list" variable available to the rule templates<M		



	

>?@??@			?*	?*				

?????y??????K?0For help: http://www.drools.org/Decision+Tables???y??????K?Lhttp://www.drools.org/Decision+Tablesgg????D
????	
??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
?????Oh??+'??0?08T
x?'Charles MoulliardMicrosoft Macintosh Excel@???;???
??՜.??+,??D??՜.??+,???HPX`hp
x?'TablesLists	Tables_2WorksheetsL 8@_PID_HLINKS'AxG&http://www.drools.org/Decision+TablesxG&http://www.drools.org/Decision+Tables?????? ?F$Microsoft Excel 97 - 2004 Worksheet????8FIBExcel.Sheet.8CompObj????????????
b????????????????????????????????????




    © 2015 - 2025 Weber Informatics LLC | Privacy Policy