• Home
• org.openl.rules
• org.openl.rules.tutorials
• 5.9.0
• source code
• InsuranceData.xls

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

org.openl.rules.examples.insurance.include.InsuranceData.xls Maven / Gradle / Ivy

??ࡱ?>??	


????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????w????x	

???? !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuv????????????????????????????????????????Root Entry????????
 ?F???????
`???F	?
?Workbook
????k?
Ole

????????OlePres000????????????????????	
????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
??

?????Oh??+'??0?
HPdx??
???Stan ShorDLiauchukMicrosoft Excel@?48???
@??p??
@?b?F	?
??

??՜.??+,??0?
	
PXlt|??
?Y
?OpenRules????
?????T??
	e		x
!
4	
???


'
??'
??
???	'
??
???	 
3'
??
???	 
3'
??
???	 
3

?-




@	!?????-

?
	???@	!?
????
Arial-
	???
???

o2

EMethod void validatePolicy(Policy policy, PolicyPremiumCalculator pc)e						????
Arial-
???? Arial-
-
-
-
-
-
????-
??
"System????x8-
'
??-
-


???	

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-




T2
"3// set global variables for US and different statesc		-
"2
2setGlobalVariables
	-
s2
2{H(policy, pc); // execute rules defined in the table "setGlobalVariables"
	2
C2
Cu2
TI// validate drivers executing rules defined in the table "validateDriver"	L2
e.for(int i = 0; i < policy.drivers.length; ++i)
2
v  -
2
vvalidateDriver	-
72
vd (policy.drivers[i], policy, pc);2
?2
?x2
?K// validate vehicles executing rules defined in the table "validateVehicle"	H2
?+for(i = 0; i < policy.vehicles.length; ++i)+
2
?  -
2
?validateVehicle	-
:2
?n"(policy.vehicles[i], policy, pc); 2
?2
?32
?if (pc.rejections.size() > 0)c2
?	  return;e2
?2
?-
-
-
-
'
??-
-


???	 
3

-
-
'
??-
-


???	 
3????-
?

	???
???


????-

???-
@	!???
?-
	
???@	!???
-
?
	???
???-

??-
@	!???
?-
	
???@	!?
@	!?!
????@	!?

@	!?

-
?
	???
???-

 
!
-
@	!?

 
-

 
!
-
@	!?

 
-

*!
*-
@	!?!

*-

M!
M-
@	!?!

M-

r!
r-
@	!?!

r-

?!
?-
@	!?!

?-

?!
?-
@	!?!

?-

2!
2-
@	!?!

2-

4-
@	!?
"
-

4-
@	!?
"
-



4-
@	!?
"

?-
-
'
??-

???	??? 
3

'
??NANI	???
????\p	DLiauchuk                                                                                                    B?a
?
=

	?
ThisWorkbook??
?
=?????35%8
i@?"
?
?1???

Arial1???

Arial1???

Arial1???

Arial1?
??
Arial1??


Arial1?$?


Arial1?	?

Arial1?
	?
Arial1?	?

Arial1?
?
Arial1.???


Times New Roman1?Q?

Tahoma1&??

Courier New1&?	?

Courier New1&?
?
Courier New1?
??
Arial1.???


Times New Roman1???

Arial1?9?

Arial1???

Arial1???
?
Arial1??
?z
Calibri1?	?
?z
Calibri1?>?
?z
Calibri1?
???z
Calibri1?
4??z
Calibri1,

8??z
Calibri1

8??z
Calibri1?
8??z
Calibri1?
??z
Calibri1?
	??z
Calibri1h

8??z
Cambria1?<?
?z
Calibri1??
?z
Calibri1??
?z
Calibri1?4?
?z
Calibri1?
?
?z
Calibri1??
?z
Calibri/
#,##0"@.";\-#,##0"@."9
#,##0"@.";[Red]\-#,##0"@.";
#,##0.00"@.";\-#,##0.00"@."E 
#,##0.00"@.";[Red]\-#,##0.00"@."k*3
_-* #,##0"@."_-;\-* #,##0"@."_-;_-* "-""@."_-;_-@_-k)3
_-* #,##0_@_._-;\-* #,##0_@_._-;_-* "-"_@_._-;_-@_-{,;
_-* #,##0.00"@."_-;\-* #,##0.00"@."_-;_-* "-"??"@."_-;_-@_-{+;
_-* #,##0.00_@_._-;\-* #,##0.00_@_._-;_-* "-"??_@_._-;_-@_-?"$"#,##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\)??? ? ?
?? ?? ?
?? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ?
 ? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ???? ??? ???? ??? ???? ????? ?
??? ?? ?
??? ?? ??? ?P? ??? ?P? ??? ? ? ??? ?? ??? ?a>? ? ?? ?ff??? ?!?? ?? ?"?? ?? ????? ?#?? ?? ?$?? ?? ??? ?? ?
	?? ?? ?%?? ?`? ?&?? ?? ?
??? ?? ?
??? ?? ?'?? ?? ?
p@ @ ? ?
p!@ @ ? ?
p!@ @ ? ?
p!!@ @ ? ?
? ?
p!@ @ ? ?
? ?
p? ?
0? ?
x!!@ @ , ?
x!@ @ , ?
? ?
0? ?
x!@ @ , ?
x!!@ @ , ?
? ?

x@ @  ?

x@ @  ?
p@ @ ) ?
x!
@ @, ?
x
@ @, ?
x@ @ , ?
x@ @ , ?
x@ @ , ?
x!@ @ , ?
p@ @ ? ?1
t!!@ @ ? ?
p!@ @ , ?
x!@ @ , ?
0!@ @ ? ?
0!!@ @ ? ?
0@ @ ? ?
0!@ @ ? ?
? ?
x@ @ , ?
x@ @ , ?
x@ @ , ?
x@ @ ? ?
x@ @ , ?
x!@ @ , ?
p@ @ ? ?
p!@ @ ? ?
x!@ @ ? ?
p@ @ , ?
x@ @ , ?
x!@ @ , ?
x@ @ , ?
x@ @ ? ?
x@ @ , ?
? ?1
|@ @ ? ?1
|!@ @ ? ?1
|!@ @ ? ?1
|!!@ @ ? ?1
4@ @ ? ?1
4!@ @ ? ?

8@ @ ? ?
1
<@ @ ? ?
p@ @ , ?
0@ @ ? ?1
4@ @ ? ?
x@ @ , ?
x@ @ , ?
x!@ @ , ?
x@ @ , ?1
|@ @ ? ?
 x? ?
x@@ ?
x""@ @ ) ?
x@ @ ) ?
? ?

x@@  ?

x  @  ?
0? ?
x@@ ?
x  @ ?

x@ @  ?
x@ @  ?
x@@  ?
x  @  ?
x@  ?
x
@@  ?
x@  ?
x @  ?
x@ @  ?
x@ @  ?
x!@ @  ?
x
@  ?
x  ?
x@ @  ?
x!@ @  ?

x@ @  ?

x@ @  ?

x!@ @  ?
p@ @ ) ||?'??-}A}

00_)ef[$? -}A}

00_)ef[$? -}A}

00_)ef[$? -}A}

00_)ef[$? -}A}

00_)ef[$? -}A}

00_)ef	[$? -}A}

00_)?L[$? -}A}

00_)?L[$? -}A}

00_)?L[$? -}A}

00_)?L[$? -}A}

00_)?L[$? -}A}

00_)?L	[$? -}A}
00_)23[$? -}A}
00_)23[$? -}A}
00_)23[$? -}A}
00_)23[$? -}A} 
00_)23[$? -}A}!
00_)23	[$? -}A}"
00_)[$? -}A}#
00_)[$? -}A}$
00_)[$? -}A}%
00_)[$? -}A}&
00_)[$? -}A}'
00_)	[$? -}?}(
??v?00_)?̙?[$? -?##0.??_@_	?@_-
?}?})
????00_)????[$? -????##0.?????_@_	????@_-
????}?}*
?}?00_)????[$? -?##0.??_@_	?@_-
?}A}.
00_)[$? -}A}/
00_)??[$? -}A}0
00_)23[$? -}-}1
00_)}U}2

00_)[$? -##0.}?}3
00_)????[$? -????##0.?????_@_	????@_-
????}-}4
00_)
}A}5
?e?00_)???[$? -}A}7
??00_)????[$? -}-}8
?00_)}x}9????00_)????????[$????????##	?????????_
????????@_}A};
?}?00_)??
?[$}-}<
??00_)}A}?
a?00_)????[$?

20% - :F5=B1?M?
?
20% - :F5=B1
ef????
?%?

20% - :F5=B2?M?
"?
20% - :F5=B2
ef????
?%?

20% - :F5=B3?M?
&?
20% - :F5=B3
ef????
?%?

20% - :F5=B4?M?
*?
20% - :F5=B4
ef????
?%?

20% - :F5=B5?M?
.?
20% - :F5=B5
ef????
?%?

20% - :F5=B6?M?
2?
20% - :F5=B6
	ef????
?%?

40% - :F5=B1?M?
?
40% - :F5=B1
?L????
?%?

40% - :F5=B2?M?
#?
40% - :F5=B2
?L湸?
?%?

40% - :F5=B3?M?
'?
40% - :F5=B3
?L???
?%?

40% - :F5=B4?M?
+?
40% - :F5=B4
?L????
?%?

40% - :F5=B5?M?
/?
40% - :F5=B5
?L????
?%?

40% - :F5=B6?M?
3?
40% - :F5=B6
	?L?մ?
?%?

60% - :F5=B1?M?
 ?
60% - :F5=B1
23????????%?

60% - :F5=B2?M?
$?
60% - :F5=B2
23ٗ??????%?

60% - :F5=B3?M?
(?
60% - :F5=B3
23?֚?????%?

60% - :F5=B4?M?
,?
60% - :F5=B4
23????????%? 

60% - :F5=B5?M?
0?
60% - :F5=B5
23????????%?!

60% - :F5=B6?M?
4?
60% - :F5=B6
	23????????%?"
:F5=B1?A?
?:F5=B1
O???????%?#
:F5=B2?A?
!?:F5=B2
?PM?????%?$
:F5=B3?A?
%?:F5=B3
??Y?????%?%
:F5=B4?A?
)?:F5=B4
?d??????%?&
:F5=B5?A?
-?:F5=B5
K???????%?'
:F5=B6?A?
1?:F5=B6
	??F?????%?(
2>4 ?u?
?2>4 
??̙????v?%??
??
??
	??
?)
K2>4?u?
?K2>4
??????????%?????
?????
?????
	?????
?*

KG8A;5=85??
?
KG8A;5=85
???????}?%??
??
??
	??
?+???,?
?8?5@AAK;:0?,???&?
?5=56=K9?-???.?
?5=56=K9 [0]?.
03>;>2>: 1?K?
?03>;>2>: 1I}?%O????/
03>;>2>: 2?K?
?03>;>2>: 2I}?%???????0
03>;>2>: 3?K?
?03>;>2>: 3I}?%23?????1
03>;>2>: 4?=?
?03>;>2>: 4I}?%?
2
B>3?K?
?B>3
?%O???
O????)3
>=B@>;L=0O OG59:0???
?>=B@>;L=0O OG59:0
?????????%???????????????	??????4
0720=85?7?
?0720=85I}?%
?5
59B@0;L=K9?I?

?59B@0;L=K9
??????e?%????$?

?1KG=K9?6?	??H?
	?B:@K202H0OAO 38?5@AAK;:0?7
;>E>9???

?;>E>9
????????%?8	
>OA=5=85?9?
5?	>OA=5=85??%?9

@8<5G0=85?n?

?
@8<5G0=85
??????????
?????
?????
	?????
?:???*?
?
@>F5=B=K9?%;
!2O70==0O OG59:0?U?
?!2O70==0O OG59:0??}?%???
??-<
"5:AB ?@54C?@5645=8O?O?
?"5:AB ?@54C?@5645=8O???%?=???*?
?
$8=0=A>2K9?>???2?
?$8=0=A>2K9 [0]??
%>@>H89?A?

?%>@>H89
??????a?%?X??TableStyleMedium9PivotStyleLight16`
??m	Datatypes?ȝData Policy??Data Rating???Main Methods???Util Methods??
????

?
#
AutoInsuranceData
Properties#
	us_states?
?]
_ICPSANDBOXeclipseworkspaceopenrules.examples.autoinsurancerulesAutoInsuranceData.xlsDataMake PolicyEnvironmentY;Z

ALZ
AKZ
ASZ

AZZ
ARZ
CAZ
COZ
CTZ
DEZ
DCZ
FMZ
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
DWY2????
????

????!


;DD
#	BI_limits;

#	BI_limits=)2)2#	BI_limits=)2)2#	coverages;
!drivers=!drivers;

!drivers;

 gender;

$link_us_states9

(marital_status;#	MP_limits;#	MP_limits=)1)1#	MP_limits=)1)1#	PD_limits;#	PD_limits=)5)5#	PD_limits=)5)5#	us_states;
D#	us_states;
D#	us_states;
D"vehicles="vehicles;

"vehicles;

?
?
?
?????H
 


3???
	?
@@?

???
?GenderMaleFemaleMarital
StatusSingleIDNJnameagegender
maritalStatus	dmvPointsNameAge
DMV Points
John Smith
Mary SmithidmakemodelyearhasAbshasAlarmMakeModelYearHas ABS	Has AlarmVeh 1NissanMaximaVeh 2ToyotaCorrolaData Usage usagesusageUsage(%)Data Address addressesstreet1street2citystatezipStreet 1Street 2CityStateZipEdison08817Datatype UsageDatatype AddressDatatype Discount*Here is a datatype that describes drivers:+Here is a datatype that describes vehicles:?Here is a datatype that describes usage of vehicles by drivers:Here is a datatype Address:StringUsage[]driversvehiclesusagesintboolean
yearlyMileagedrivervehicledoubleVector	discounts
rejectionsvalueshowInPolicy	> driversAddressaddress2 Overview Ct.limitIncreased Factor	Limit ($)15/3020/4025/5050/100100/200100/300250/500300/3001,000/1,000	500/1,000increasedFactorLimit ($from/$to)
Bodily InjuryDatatype LimitsAndFactorsProperty DamagelimitBIlimitPD
> vehicleslimitMPMedical PaymentssymbolBodily Injury BasebaseBIbasePDProperty Damage BaseMedical Payments BasebaseMPSymbolaHere is a datatype to define how base premium for different coverage limites should be increased:!Datatype VehiclePremiumCalculator Datatype PolicyPremiumCalculatordesignatedDriverData LimitsAndFactors limitsPDData LimitsAndFactors limitsMPData LimitsAndFactors limitsBILimitsAndFactors50,0005,00010,00020,00025,00035,000100,000150,000200,000250,000500,000750,000	1,000,0001,0002,00075,000
>	>vehicles	>limitsBI	>limitsPD	>limitsMPdiscountsForVehiclediscountsForDriver)Here we will describe convenience methodsFHere we will present all data that describes an insurer's rating data 9Method void displayRejections(PolicyPremiumCalculator pc)	
Datatype CoverageBaseDatatype VehicleCoverageType&Data VehicleCoverageType coverageTypesData CoverageBase coverageBasesDatatype VehicleSymbol!Data VehicleSymbol vehicleSymbolsXThis datatype is used to define vehicle symbols that are keys to base coverage premiums:CThis datatype defines base coverage premiums for different symbols:>For each vehicle accumulates driver's and vehicle's discounts:;Accumulates policy-level rejections (if any) and discounts:Yearly Mileage1A datatype for discounts (<1) or surcharges (>1):ZMethod void addDiscount(Vector discounts, String type, double value, boolean showInPolicy)	
mDiscount d = new Discount();
d.type = type;
d.value = value;
d.showInPolicy = showInPolicy;
discounts.add(d);type'Method void displayDiscount(Discount d)	
8Here we present Policy data for all vehicles and drivers?for(int i=0; i maxUsage)
   { 
      index = i; maxUsage = u.usage;
   }
}
return usages[index].driver;Method void main(String[] args)	
DMethod double calculateVehiclePremium(VehiclePremiumCalculator calc)	%
H
// execute rules to validate drivers 
for(int i = 0; i < policy.drivers.length; ++i)
  validateDriver(policy.drivers[i], policy, pc);
// execute rules to validate vehicles 
for(i = 0; i < policy.vehicles.length; ++i)
  validateVehicle(policy.vehicles[i], policy, pc); 
if (pc.rejections.size() > 0)
  return false;
return true;
%We????X
Here we will describe all business objects (datatypes) used in the AutoInsurance example. First of all, there is a datatype InsurancePolicy that contains information about all vehicles and drivers at this particular address. Our InsurancePolicy also includes information about a usage of vehicles by drivers. Here is a datatype InsurancePolicy:Datatype InsurancePolicy7Method double calculatePremiums(InsurancePolicy policy)Datatype InsurableDriverData InsurableDriver driversuEach InsurableVehicle will have a selected coverage for all mandatory coverage types (BI, PD, MP, ..) from this list:Datatype InsurableVehicleInsurableDriverInsurableVehicle(InsurancePolicy p = new InsurancePolicy();
p.drivers = drivers;
p.vehicles = vehicles;
p.usages=usages;
p.address=addresses[0];
//out("*** InsurancePolicy: "+ p);
PolicyPremiumCalculator policyCalculator  = new PolicyPremiumCalculator();
policyCalculator.rejections = new Vector();
policyCalculator.discounts = new Vector();
if (validateInsurancePolicy(p, policyCalculator) == false) // rules
{
  displayRejections(policyCalculator); return;
}
double policyPremium = calculatePremiums(p);

out("*** InsurancePolicy Premium: " + format(policyPremium));
InsurableDriver[]InsurableVehicle[]Data InsurableVehicle vehiclesZMethod boolean validateInsurancePolicy(InsurancePolicy policy, PolicyPremiumCalculator pc)@Method InsurableDriver designateDriver(InsurableVehicle vehicle)?double policyPremium = 0;
for(int i=0; i???3?\`???/?[???G??\?!?-?Rk.?s?Ի?..???a濭?
??PK!?֧??6
_rels/.rels???j?0???}Q??%v/??C/?}?(h"???O?
??????=?????? ????C??h?v=??Ʌ??%[xp??{۵_?PѣLcy?'$?w=."??Q???w?nĦf???"Lc?8??_?xxp????z?'?rF?ɀI????hk?$[?Ջ???????_??G???_?z?i9^?|?????)BD?$z??????_~??o?>)???-?;4"?!;h?G?7?Wr?g[?	1uV?h??n??
?bV??Wy?$?2???CG?v(??p?Fp?sV?T
?4???;??_?\??M???x7p옶9H ?fN??G?
?c??$&
?w|????=????:??????ꘖ??C??#????2,?3?????}T?l׫d?EB@`V"|?0G?7?@ᨌdG????X?eB???/?R????q???ek?
?o??0?R???a?"??[e4oc΋?U??q??a?4??w??(F\??׹!????}??ܧ'?{??4r?f ?-!q;?7??_%cF![?L?5oJSYH?K?'????w?
?>^x.??e????y??X?4ێ,?^??t???Ms?2?VCFnK?7K(A&5s?$??*	a?&{?جA????
?!N??x?H_???%\???L???x?ە=9??3???u??Y=?r2???y5c4?	L?l?ZJ?}f-???*F4??n?????[??\?Е ?e@??p?׬ᬂ	??mA??b?p?&?!Hj#??qU??2_1??;%6???S?Vඨɾ
?I?TdW=?]f?7?R??#+?8>?,.'??N?[???󐏓?׃c.??.u#?Y??|%?۟?&?G?\?6?An2???6??DH??eh]üJ]?Ś??f?zQ??~)f??1)@??iI?G|U4vaF??>????0?A]6?̯]?P	?&#??j??6???]????6?aSn6
M??\Ē?jכ?Y?-nD??Y?,*?Y?,?aN?Xjm????\&Xq|?0?7D	\!???
?ُ??v?&?V?"41p??+??@:A??.4Nv?:?&eU??NZkY???N7?{L?Z?I?}Fe?͙?ΉŋTv?aG?v?DU?e??(L????1??V?PŻ?Ыp??`?ӕL???A?!Pwp0??En??nOD?-??ЮIq?4?A
?Uȇ?
4	0?5?? ?M??r?
Y??n??F8?F?n?
E???T??z??xI;??n?,??T???'1?f?b??????]?	-^|F'!?A3̝j͋?s??SxD?,*??”M??؆2?:?I0?6g?C07|^Uw??8??M?1?9??`
b?wb8?Vf?s?2?(٠?
	??҆??.m???M??ŗ?v??ɥ??	?-u2???t9K`8h?M???I????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
-!????[Content_Types].xmlPK
-!?֧??6
+
_rels/.relsPK
-!ky???theme/theme/themeManager.xmlPK
-!?k?r?t ?theme/theme/theme1.xmlPK
-!
ѐ??
'?
theme/theme/_rels/themeManager.xml.relsPK]
???
??
	???

KƍΖ4??

d
????MbP?_
*+?
?%?????&??'??(??)??M?:>@@84>@
??C??
?4d
X
XA4


????DINU"??	???;






?SMTJ?HP LaserJet P2015 Series PCL 6InputBinFORMSOURCERESDLLUniresDLLESPRITSupportedTrueHPPCompositeUSBGetSerialNumberhppdvq01.dll_getDeviceSerialNumberWHPPInstallTimeConfighppdvq01.dll_getDevicePPMDuplexerWResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalsePaperSizeA4MediaTypeAUTOCollateOFFEconomodeFalseTextAsBlackFalseHPXMLFileUsedhpc20156.xmlTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPPCompositeUSBFilehppdvq01.dll_getDeviceSerialNumber_getDevicePPMDuplexerDuplexNONEPrintQualityGroupPQGroup_3HPLpiSelectionNoneAlternateLetterHeadFalseHPDocUISUITrueHPDocPropResourceDatahpchl5r1.cabHPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_COLORAUTHHPBornOnDateHPBODHPJobByJobOverrideJBJOHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPPreAnalysisTrueHPMapManualFeedToTray1TrueHPPrintOnBothSidesManuallyFalseHPStraightPaperPathFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE5r1HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionPSAlignmentFileHPCLS5r1PSServicesOptionHLPWithLightsHPSmartHubInet_SID_263_BID_276_HID_265HPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_OrdersuppliesTRUEHPConsumerCustomPaperTrueHPEnableRAWSpoolingTrueHPCustomDuplexableRange3x5_8.5x14HPPaperSizeALMConstraintsEXECUTIVEHPPaperSizeDuplexConstraintsEXECUTIVEHPMediaTypeDuplexConstraintsCARDSTOCK?IUPH
x??MoAǟ?#?Fo^?豱
&?Ԛ?^RZVh?D??b[0Eox0Ư?ķ?~/?^?56~o????.?j???m??g?v??}f?v?D???I#?]v\gġk?V?Z.G}???7??O?q ۟?ٲ7ZS?	??tC???{??/3\?????My??f?
a??ܥ,[???Z?!v?뭴?Tov?yr!cD?\.1)N1x?"?(?p?[?1d?Z@???q?>???{?~??.ϔa?o?W???!o???M?w??Oț.iy?!??鐈?????#???n?/?骧Z?1DS??הu???!????fz??*?iH??r?qg??kL邘??T{M??-?G??o??#???

V?

JC?

IZ?

V9?
V	?

V9?
V
?
??????K	?

V>?
V?
??
??

?6???L?
l??
mB?
HHHH?
l9?
md?

??
??

V9?
V?
???????

V9?
V?

V9?
V?
??
??

V>?
V?
k9?
?d?

V??
V?
kC?
?f?

V??
V?
kC?
?g?

V>?
V@?
kC?
?j?

?7?
???
???????

?

?2
??
?m
??
 
V??
 VA
 L?
 V??
 VB?B X< >VF88>088<:.:48888:0!
	?@
"
	?
#
	;
@
$
	?
%
	
@
&
	?@
'
	;
@
(
	?@
)
	?
@
*
	?
+
	?@
-
	h
@
.
	

 /
	?
0
?
1
?
2
J
@
 5
?
8
?
@
:
?@
?
!
V??
!VB?
!HH?
!VD?
!V??
"
V>?
"V#?
"VD?
"V?
#L?
#V??
#Vo?
$
?8?$??L?
%???%????
&
?3
&??
'
V9?
'V&
'L?
'?n
'??
(
V9?
(V'?
(HH?
(VD?
(VE?
)
V9?
)V(?
)LL?
)VD?
)VF?
*
V9?
*V)?
+
V9?
+V*?
-
???
-???
/
?4
/??
0
l9?
0m??
1
lC?
1mG?
2
M??
2NH?
5?, |
F8&>FFB?@
C?
@
D?
@
Ew
@
F?
@
G;
@
HJ
@
Ih
@
J;
@
????P?H?
?0?(
	?
?>?@??
??//

$$
''%%--

		


&&


		




?7?
????gg
????D
	???

$????

d
????MbP?_
*+?
?%?????&??'??(??)??M6\\VALENTINAU\HP DeskJet 720C
?XC?

?
od
X

X
Letter



DINU"4$@$??

$?$
$?$
?"
d


XX????
?&?U}$	F}

?F}?F}F}?F}?	F}IF}F}		F}
$	F}

IF}
$	F
$


?

?
@


@

?


?

?

?


@

?



?


?


?

?



 
?@

?


?


?

?



 
?
@
 
?

?


?



 
+@

?

 
?

?


???
?????

????????DDDD?

~?
~?
~	?
~
?
~?DDDD?

U?
U
?
U?
U?
U?DDDD?

@~
@8@?
@
?
@~
@@?DDDD?

@~
@3@?
@?
@~
@?DDDD?DDDD?

??????????

~?
~?
~?
~?
~?
~?
~@?


~??
~~~~~z?

U?
U?
U?
U?
U?
U?
U??

@?
@?
@~
@@?@@
@~
{p?@?

@?
@ ?
@!~
@" defines this row as a place where you can put references to to other data tables, in this case list of drivers and list of vehicles
<
??


Jacob Feldmant>?@ob??jb


?2







?7?
?????
3





#"#

?
+





#
?
+





#


?
	Sheet6gg
????D
	???

/k?_???

d
????MbP?_
*+?
?)%?????&??'??(??)??M6\\VALENTINAU\HP DeskJet 720C
?XC?

?
od
X

X
Letter



DINU"4$@$??

$?$
$?$
?"
d


XX????
?&?U}IF}

?F}?F}F}IF}?F}?	F}IF}F}		F}
$	F}

IF}
$	F
/




?




 

?@


?"


?"


?



;

	

J

 



 

?
@




!





?


?


?


?


?


?


?




 

?




 

?


?




 

?


?@


?!
 
?P
?


???
?????

???????

fB?
d_?
d`?
gb?

fa?
d??
d??
g??

f??
d\?
d^?
gc?

h?
eU?
rt?
st?
	
i?
	jS?
	tx?
	ux

a?

?r
??
?p
??
?q
??


bM?

[Z?

bM?

[Z?

bM?

[Z?

c[?
\N?
cO?
\N?
cO?
\N?	DDDD?

_P~
]???
vu~
]??
D?
v?~
]???	DDDD?

_Q]??(\?????
vv]?G?z??
D?
v?~
]
@e@?	DDDD?

_R~
]
?]@?
vw~
]
?]@
D?
vu~
]
?p@?	DDDD?

_S~
]
?a@?
vx~
]
^@
D?
vv~
]
?u@?	DDDD?

_T~
]
?c@?
vy~
]
@^@
D?
vx]?G?z@?	DDDD?

_U~
]
?c@?
vt~
]
?^@
D?
vt~
]
p?@?	DDDD?

_V~
]
@e@?
vz~
]
`@
D?
v?~
]@?	DDDD?

_W~
]
@e@?
v{~
]
?`@
D?
wz~
^
p?@?	DDDD?

_Y~
]???
v|~
]
?`@?DDDDD?

`X~
^
 f@?
v}~
]
 a@?DDDDDDD?
v~~
]
?a@?DDDDDD?
v~
]
?a@?DDDDDD?
w?~
^
?a@?DDDDDD?DDDDDD?

???????

nd?
nf?
ng?
nj?
 
nk?
 ne?
 nh?
 ni?>
0 88888
HTfpxpptpppPP2228!
?
"
?
#
?
$
?
%
?
&
?
)
?
*
?
+
?
,
?
-
?
.
?
?!
???o?l@xY@o?M@?"
?@on@x?[@oO@?#
y@x?n@x?[@xP@?$
y@x@o@x?\@xQ@?%
y@x?p@x@]@x@Q@?&
y@x?q@x?]@x?Q@?
)
?
*
?
+
?
,
?
-
?
.
??""""""?P?H0?
?0?(
	?
?>?@??



?2





?7?
?????
,






'
!"
?
+





#
	?
+





#
	?
+





#
	

?
+





#
	?
	Sheet8gg
????D
	???

	 ???

d
????MbP?_
*+?
?%?????&??'??(??)??M6\\VALENTINAU\HP DeskJet 720C
?XC?

?
od
X

X
Letter



DINU"4$@$??

$?$
$?$
?"
d


XX????
?&?U}}

?C}?}$A}m
	


;
@

?@



 
,
@
 
?
@
 
?

?

?	
?


P?

??

P??

???

???
???

???
Q??

???
??
??

P?
??

R?
??b
?4
?P?H@?
?0?(
	?
?>?@???



?

?7?
?????
	Sheet7gg
????D
	???

E???

d
????MbP?_
*+?
?%?????&??'??(??)??M6\\VALENTINAU\HP DeskJet 720C
?XC?

?
od
,


,

Letter



DINU"4$@$??

$?$
$?$
?"
d


,
,
????
?&?U}mO}

?BO}$O}IO}
$	O



?


@

T@

I@

?@
	
?


?@
?


O??

Q??

R??

Q??

R??
	
P??


R???x?P?HP?
?0?(
	?
?>?@??






?7gg
????D
SummaryInformation(
????
?DocumentSummaryInformation8?????????????

CompObj????????????
m????????????

DatatypesData PolicyData Rating
Main Methods
Util Methods'Data Rating'!BI_limitsdrivers'Data Rating'!MP_limits'Data Rating'!PD_limits	vehicles???????????????? ?????????
??
???? ?F!???? Microsoft Office Excel 2003Biff8Excel.Sheet.8?9?q