All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.openl.rules.examples.banking.rules.Banking.xls Maven / Gradle / Ivy

Go to download 

??ࡱ?>??	?????????>????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	???@????\pStanislav Shor                                                                                               B?a?=
	???= x??(8X@?"??1???Arial1???Arial1???Arial1???Arial1??Arial1??Arial1?	?Arial1???Arial1???Arial1?	?Arial1?	?Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)?"Yes";"Yes";"No"?"True";"True";"False"?"On";"On";"Off"]?,[$? -2]\ #,##0.00_);[Red]\([$? -2]\ #,##0.00\)?"$"#,##0.00??? ? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ? ? ?+?? ?? ?)?? ?? ?,?? ?? ?*?? ?? ????? ????? ?	?? ?? ? `@ @ ) ?"x"@ @ * ?"X? ? @? ?  "@ @ ? ?  "!@ @ ? ?"x"@ @ ) ?? ?	x@ @ ) ?x@ @ ) ?p@ @ ? ?p@ @ ) ?	x!@ @ ) ?p@ @ ) ?	x!@ @ ) ?0@ @ ? ?p!@ @ ) ?p!@ @ ) ?p!!@ @ ) ??4@ @ ? ?p@ @ ) ?p? ?
x   ?x? ?x? ?P? ?? ?p""@ @ ) ?0@ @ ? ?0!@ @ ? ?0!@ @ ? ?0@ @? ?0!@ @? ?0!@ @ ? ?0!!@ @ ? ?p@ @  ?p@ @ * ?p@@ * ?x @  ?0 @  ? ?0! @  ? ?p@ @ 
 ?x"@ @ 
 ??4@ @ ? ??4!@ @ ? ?x"!@ @ 
 ??4!@ @ ? ?x""@ @  ?0! @ ? ?x"@ @
 ?0 @? ?0@ @? ?0!@ @? ?0 @ ? ?0 @ ? ?p@ @ * ??4 @ ? ??4! @ ? ??4!@ @ ? ??4!!@ @ ? ?x" @   ?0   ? ?0 @  ? ?x ?x"@   ?x"@ @  ?x"!@ @  ?p@ @* ?p@ * ?p@  * ?x"@ @ 
 ?x"@ @ 
 ?x"!@ @ 
 ?x"@ @
 ?p@@* ?p@* ?p@ * ?p@ @
 ?p@ 
 ?p@  
 ?p@ @ ?p@  ?p@   ?x@ @ 
 ?x@ @ 
 ?x!@ @ 
 ?x@ @  ?x@ @  ?x!@ @  ?x@@
 ?x@
 ?	x@ @) ?	x@ ) ?	x@  ) ?x@ @) ?x@ ) ?x@  ) ?x  ?x@@ ?x  @ ?!x  ?p@ @ 
 ?p@ @  ??????????????	??????????`??'ProblemResolutionRules??2CustomerProfile?-6UpSellRules?>CMethods??GData??OEnvironment???CBankingData.xls
Customer Data
Make CustomerEnvironmentYYYLZ#Enrollment (Online Banking)ZBill Pay EnrollmentZ"Additional Account LinkageZBrokerage EnrollmentZ-%Password Maintenance (Online Banking)Z	My Bank PasswordZ

ALZ&
Bill Pay - Gen Info/Help/OtherZ
AKZBill Pay - OverdraftZ
ASZPHBanking Product Service (Fund transfers stop payments check copies etc.)Z

AZZ
Cancel Bill PayZ
ARZ)!Technical Support (Browser Other)Z
CAZ
System OutageZ
COZConnectivity IssueZ
CTZSoftware BugZ
DEZPrivacy PolicyZ
DCZFederal TaxZ
FMZNew AccountZ
FLZ
GAZ
GUZ
HIZ
IDZ
ILZ
INZ
IAZ
KSZ
KYZ
LAZ
 MEZ
!MHZ
"MDZ
#MAZ
$MIZ
%MNZ
&MSZ
'MOZ
(MTZ
)NEZ
*NVZ
+NHZ
,NJZ
-NMZ
.NYZ
/NCZ
0NDZ
1MPZ
2OHZ
3OKZ
4ORZ
5PWZ
6PAZ
7PRZ
8RIZ
9SCZ
:SDZ
;TNZ
<TXZ
=UTZ
>VTZ
?VIZ
@VAZ
AWAZ
BWVZ
CWIZ
DWY ????????????AnswerTypes)BankingProblems;)BankingProblems;)CustomerProfile;)CustomerProfile;"problems;"Products;"Products;"Products;"Products;#	us_states;
D??`i?8??EnvironmentlanguageProductsBanking ProblemsChecking AccountEnrollment (Online Banking)Overdraft ProtectionBill Pay EnrollmentSaving AccountAdditional Account LinkageCD with 25 basis point increaseBrokerage EnrollmentCD with 50 basis point increase%Password Maintenance (Online Banking)Brokerage AccountMy Bank PasswordMoney Market Mutual FundBill Pay - Gen Info/Help/Other
Mortgage LoanBill Pay - OverdraftHome Equity LoanHBanking Product Service (Fund transfers stop payments check copies etc.)Car LoanCancel Bill PayCredit Card!Technical Support (Browser Other)Credit Card with no annual fee
System OutageDebit/ATM CardConnectivity IssueWeb BankingSoftware BugWeb Banking with no chargePrivacy PolicyFederal TaxNew AccountCustomer ProfileNewBronzeSilverGoldPlatinumorg.openl.rules.javaData Customer customersDatatype Customer	firstName
First NameJohnMaryString
middleInitialMiddle InitialD.K.lastName	Last NameSmithageAgeintstateStateNJproductsString[]problemsdoublecombinedBalanceprofileCombined BalanceProfile?-Method void resolveProblem(Response response)%Method void upSell(Response response)kCustomer customer = customers[0];
System.out.println(customer);

resolveBankingProblem(customer,response);
Customer customer = customers[1];
System.out.println(customer);

setCustomerProfile(customer);
upsellRules(customer,response);
C1$contains(profiles, customer.profile)String[] profilesIf Customer Profile isC2(contains(customer.products, yesProducts)String[] yesProducts!And Customer Already Has ProductsC30contains(customer.products, noProducts) == falseString[] noProductsBut Does NOT Have ProductsA1%response.setProducts(offeredProducts)String[] offeredProductsOffer ProductsA2response.setComment(comment)String commentSet CommentGold PackagePlatinum Package>Rules void upsellRules(Customer customer, Response response)  
customer.combinedBalance >= min
double minCombined Balance Mincustomer.combinedBalance < max
double maxCombined Balance Max4customer.profile = profile;
out("Profile="+profile);String profileSet Profile2Rules void setCustomerProfile(Customer customer)  
#contains(customer.problems,problem)String problem#If Customer Faces a Banking ProblemAnd Already Has ProductsC4customer.combinedBalance > minAnd Combined Balance Mincustomer.combinedBalance <= maxAnd Combined Balance Max-response.setComment(comment);
//out(comment);?You have been approved for a $1,000 Overdraft Protection Line of Credit which is attached to your checking account.  If you are interested, I will forward you one of our sales representatives to provide more detail?I can immediately activate a link between your checking account and your savings account. If you overdraw the account in the future, money will be transferred between the accounts and we will email you a notification.   Would you like to do this?GRules void resolveBankingProblem(Customer customer, Response response) 
/Method boolean contains(String[] ary, String s)Zfor(int ii = 0; ii < ary.length; ++ii)
  if (ary[ii].equals(s)) return true;
return false;4Method boolean contains(String[] ary, String[] ary2)bfor(int ii = 0; ii < ary2.length; ++ii)
  if (!contains(ary, ary2[ii])) return false;
return true;Method void out(Object o)System.out.println(o)import org.openl.rules.examples.banking??:???y?W+??r?i;?u???rv H!??!??"?	?$h>'
	???@?+j1
d????MbP?_*+??%g????MHP LaserJet 6L - local?4C??
odXXLetter????DINU"4_*??"dXX????U}?}}?,}?}}?&}?)}?}q}		?
}


}?	}
}

U}	?@@ *@ ?@?@?@ w@?@?@ 	?@
?@ ?@?@
Y@ '@ ?
Vy?VVVVVVV.....
?
@L?
;m?
<n?
Ho?
I?
J?
JK?
dP?
ZQ?
aR?
]p?
L?
3?
34?e[b^M?
&?
&5?f\c_G889?
dT?
ZU?
aV?
]W?
L?
3?
34?e[b^M&&5?f\c`G889?
	dq?
	Nr?
	<d?
	As~
	O@?@?	BBC
f?

Nt?

<g?

Du?
PQQR?
gX?
ZY?
aZ?
W[?
L?
3?
34?h[bXM&&5?
i\cYG889?
:\?
;v?
<^?
S_?
Tw?
Ux?
>??"?0bb0bVFb>?@?r	




?7??????3#
?+#
	???@	u3?5
d????MbP?_*+??%?????"????U}?}}8}U}		?	

 

 
 ?
Vl?VVVVVVVV	?
|L?
;c?
<d?
Ae?$BB@@B@?@B??@CL?@	?
|P?
;f?
<g?
Dh?$*@@*@?@*??@*L?@E?cA	?
}X?
;i?
<j?
Fk?
G%?
8&?
8'?
8(?
	9)??<(``>?@?
	?7??????+?#@E	
	???@?9?A
d????MbP?_*+??%g????MHP LaserJet 6L - local?4C??
odXXLetter????DINU"4_*??"dXX????U}?}q}?(}?}?}U}		?}

?
}
}?	}


}U}	?@@ ?@?@?@ ?@?@?@ ?@	?@
?@ 
@?@
@?@+@
Y@ 
g@ ?
Vb? VVVVVVVV.....?
dL?
ZM?
aN?
pO?
3%?
3%?
3%?
3(?
	4)?e[bq?
&&?
&&?
&&?
&5	?f\cq?
6'?
6'?
6'?
67	?
dP?
ZQ?
aR?
jS?
3?
3?
3?
3?
	4?e[bk&?
&?
&&?
	5?f\cl88889	?
dT?
ZU?
aV?
jW?
3?
3
?
3
?
3?
	4?	e[bk&?
	&?
	&?
	&?
		5?
f\cl8?

8?

8?

8?

	9?
gX?
ZY?
aZ?
m[?
3?
3
?
3?
3?
	4?h[bn?
&?
&?
&?
&?
	5?
h[bn?

&?

&?

&?

&?

	5?h[bn&&?
&?
&?
	5?h[bn&&?
&?
&?
	5 ?i\co888?
8?
	9?
:\?
;]?
<^?
=_?>>>?
>`?
	?a?(?T2~JJ~H~LL~XX@@4>?@?	
??	



?7??????+#		?+#	
	???@?CFG
d????MbP?_*+??%?????"????U}?*}?}q+??w?1 ?T?1 ?h?1? 	?$ 
? ? ,?
-H.?
-I??///,00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000??
2J?
2K?
-z?
-|?
	2{?
	2}?

-~?
2?x>?@?7
	???@OHeN
d????MbP?_*+??%?????"????0U}	}U}?}}U}U}?}	}}
	}U}	 ?@ ?@	,@
 
;@?
x+?xxx?
y,z?
-?
 .?
!/?
!0?
"1?
#-?
2?
 3?
!4?
!5?
$1?
%2?
6?
 7?
!8?
!8?
$1?
%6?
9?
 :?&<@&9@?
$;?
%9?
<?
 =?
&>?
&>?
$1?
%<?
r??
u?
&?
&?
$@?
'??
sv?
&&?
$@?
'A?	sv&&?
	$B?
	'C?
sv&&?

(1?

)D?tw&&?
rA?
u?
&?
&?
sv&&?sv&&?sv&&?tw&&?
C?
 E?*p?@*??@?
+D?
 F?
&G?
&G?*>h6TTTNTTB..82>?@?2?7??????8	j??	?חA?+#???+#???+#??
	???@#?S?Z=[
d????MbP?_*+??%????MHP LaserJet 6L - local?4C??
odXXLetter????DINU"4_*??"dXX????U}?}?}U}q>}q
}?# 	

    ?
{{?
?
*?
??
??
?
?
?
?
?
?
?
?
?
?
	?
?
	
	?
	?
	?


?


?

?
?
?
?
?
?
?


?

?

?
?
?
?
?
?
?
?
?
?
?
?
??
?
??
 ?
!??
"??
#????
$?
?
%?
&?
'?
(?
)?@?D44444444444666((&""?>?@?
?7??????+??#?
???????Oh??+'??0?@H\t?
???StanislavSStanislav ShorMicrosoft Excel@???@??1???????՜.??+,??0 	PXhpx??
??? Exigen?	ProblemResolutionRulesCustomerProfileUpSellRulesMethodsDataEnvironmentWorksheets	

 !"#$%&'()*+,-????/012345????789:;<=????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????Root Entry???????? ?F????Workbook?????????????[SummaryInformation(????.DocumentSummaryInformation8????????????6




© 2015 - 2024 Weber Informatics LLC | Privacy Policy