'' This file contains the data and examples used through out the site
'' It is collected in one place to make it easier to substitute 
'' public / private information for general distribution
'' ALL OF THE DATA IS THIS FILE IS EITHER SIMULATED OR MANGLED BEYOND RECOGNITION FROM
'' ITS ORIGINAL FORM OR AVAILABLE FROM A PUBLIC SOURCE

'' for aplyChFCat.html: AIR and RMS style samples
'' AIR Sample: random sample from a lognormal distribution
Function AIRSample()
AIRSample = "291" & vbcr & _
"1009" & vbcr & _
"1184" & vbcr & _
"1334" & vbcr & _
"1428" & vbcr & _
"2386" & vbcr & _
"2546" & vbcr & _
"2921" & vbcr & _
"2989" & vbcr & _
"4151" & vbcr & _
"4283" & vbcr & _
"6744" & vbcr & _
"7585" & vbcr & _
"7832" & vbcr & _
"7961" & vbcr & _
"9229" & vbcr & _
"9414" & vbcr & _
"10510" & vbcr & _
"10889" & vbcr & _
"11283" & vbcr & _
"12062" & vbcr & _
"12217" & vbcr & _
"12461" & vbcr & _
"15157" & vbcr & _
"15592" & vbcr & _
"16684" & vbcr & _
"17611" & vbcr & _
"18128" & vbcr & _
"18357" & vbcr & _
"18756" & vbcr & _
"19494" & vbcr & _
"19500" & vbcr & _
"20078" & vbcr & _
"20614" & vbcr & _
"22523" & vbcr & _
"22702" & vbcr & _
"22818" & vbcr & _
"23399" & vbcr & _
"25778" & vbcr & _
"26816" & vbcr & _
"27509" & vbcr & _
"27888" & vbcr & _
"28782" & vbcr & _
"29358" & vbcr & _
"29577" & vbcr & _
"30821" & vbcr & _
"31382" & vbcr & _
"33567" & vbcr & _
"33688" & vbcr & _
"36423" & vbcr & _
"39010" & vbcr & _
"39596" & vbcr & _
"39643" & vbcr & _
"41727" & vbcr & _
"42495" & vbcr & _
"44545" & vbcr & _
"45628" & vbcr & _
"47273" & vbcr & _
"47982" & vbcr & _
"47995" & vbcr & _
"50726" & vbcr & _
"50751" & vbcr & _
"51348" & vbcr & _
"51620" & vbcr & _
"53485" & vbcr & _
"54024" & vbcr & _
"55372" & vbcr & _
"55430" & vbcr & _
"55591" & vbcr & _
"58449" & vbcr & _
"64636" & vbcr & _
"66502" & vbcr & _
"68223" & vbcr & _
"69201" & vbcr & _
"69350" & vbcr & _
"72978" & vbcr & _
"73054" & vbcr & _
"75064" & vbcr & _
"75989" & vbcr & _
"77241" & vbcr & _
"81070" & vbcr & _
"82013" & vbcr & _
"84571" & vbcr & _
"92657" & vbcr & _
"92662" & vbcr & _
"93569" & vbcr & _
"93921" & vbcr & _
"98351" & vbcr & _
"100686" & vbcr & _
"108421" & vbcr & _
"112068" & vbcr & _
"113706" & vbcr & _
"115694" & vbcr & _
"118554" & vbcr & _
"119105" & vbcr & _
"139871" & vbcr & _
"149495" & vbcr & _
"161612" & vbcr & _
"164102" & vbcr & _
"165269" & vbcr & _
"168609" & vbcr & _
"185557" & vbcr & _
"188912" & vbcr & _
"192072" & vbcr & _
"197498" & vbcr & _
"198061" & vbcr & _
"198452" & vbcr & _
"202488" & vbcr & _
"203140" & vbcr & _
"210540" & vbcr & _
"213392" & vbcr & _
"218896" & vbcr & _
"219381" & vbcr & _
"221257" & vbcr & _
"224722" & vbcr & _
"250314" & vbcr & _
"259492" & vbcr & _
"264015" & vbcr & _
"268230" & vbcr & _
"269775" & vbcr & _
"275256" & vbcr & _
"277759" & vbcr & _
"298834" & vbcr & _
"310568" & vbcr & _
"313665" & vbcr & _
"320136" & vbcr & _
"326482" & vbcr & _
"330035" & vbcr & _
"360997" & vbcr & _
"373770" & vbcr & _
"376950" & vbcr & _
"391870" & vbcr & _
"392077" & vbcr & _
"396006" & vbcr & _
"412297" & vbcr & _
"438011" & vbcr & _
"443661" & vbcr & _
"459340" & vbcr & _
"469881" & vbcr & _
"472793" & vbcr & _
"483695" & vbcr & _
"506248" & vbcr & _
"519123" & vbcr & _
"520684" & vbcr & _
"537145" & vbcr & _
"556967" & vbcr & _
"602427" & vbcr & _
"611806" & vbcr & _
"618507" & vbcr & _
"631024" & vbcr & _
"653733" & vbcr & _
"675212" & vbcr & _
"715357" & vbcr & _
"720202" & vbcr & _
"754286" & vbcr & _
"772180" & vbcr & _
"863575" & vbcr & _
"867101" & vbcr & _
"964064" & vbcr & _
"1212650" & vbcr & _
"1237209" & vbcr & _
"1243018" & vbcr & _
"1252858" & vbcr & _
"1275647" & vbcr & _
"1321364" & vbcr & _
"1345907" & vbcr & _
"1395525" & vbcr & _
"1400624" & vbcr & _
"1412598" & vbcr & _
"1518257" & vbcr & _
"1527752" & vbcr & _
"1557183" & vbcr & _
"1754328" & vbcr & _
"1858451" & vbcr & _
"1862563" & vbcr & _
"1917707" & vbcr & _
"2017890" & vbcr & _
"2136908" & vbcr & _
"2245273" & vbcr & _
"2272867" & vbcr & _
"2350140" & vbcr & _
"2374936" & vbcr & _
"2559758" & vbcr & _
"2632094" & vbcr & _
"2710193" & vbcr & _
"2932366" & vbcr & _
"3055286" & vbcr & _
"3091821" & vbcr & _
"3113578" & vbcr & _
"3135630" & vbcr & _
"3443881" & vbcr & _
"3456716" & vbcr & _
"4056044" & vbcr & _
"4508293" & vbcr & _
"5086456" & vbcr & _
"11486788" & vbcr & _
"13452169" & vbcr & _
"18285584" & vbcr & _
"23737717" & vbcr & _
"26288903" 
End Function

'' RMS distribution: random sample from a lognormal distribution
Function RMSDensity()
RMSDensity = "935  0.00159" & vbcr & _
"1073  0.02742" & vbcr & _
"1076  0.02195" & vbcr & _
"1428  0.00084" & vbcr & _
"1683  0.01569" & vbcr & _
"1781  0.00539" & vbcr & _
"4846  0.00805" & vbcr & _
"5318  0.02020" & vbcr & _
"7268  0.00074" & vbcr & _
"7980  0.01976" & vbcr & _
"8750  0.00670" & vbcr & _
"10002  0.02348" & vbcr & _
"11312  0.02727" & vbcr & _
"11356  0.01576" & vbcr & _
"11555  0.01895" & vbcr & _
"12086  0.02787" & vbcr & _
"12728  0.02147" & vbcr & _
"15290  0.00240" & vbcr & _
"16392  0.02577" & vbcr & _
"16726  0.02202" & vbcr & _
"17301  0.00365" & vbcr & _
"21801  0.02241" & vbcr & _
"24887  0.02345" & vbcr & _
"25387  0.00302" & vbcr & _
"27444  0.00015" & vbcr & _
"33318  0.02829" & vbcr & _
"33667  0.02051" & vbcr & _
"35809  0.00202" & vbcr & _
"37369  0.02504" & vbcr & _
"38223  0.02841" & vbcr & _
"39188  0.01506" & vbcr & _
"40651  0.02245" & vbcr & _
"41223  0.02247" & vbcr & _
"41236  0.00353" & vbcr & _
"41607  0.00216" & vbcr & _
"42698  0.00125" & vbcr & _
"46675  0.01946" & vbcr & _
"47261  0.00103" & vbcr & _
"47744  0.01460" & vbcr & _
"48788  0.00729" & vbcr & _
"51691  0.02256" & vbcr & _
"68614  0.01187" & vbcr & _
"78982  0.01441" & vbcr & _
"80924  0.02608" & vbcr & _
"86060  0.01872" & vbcr & _
"87668  0.02156" & vbcr & _
"90197  0.01206" & vbcr & _
"90773  0.01339" & vbcr & _
"91161  0.01739" & vbcr & _
"97495  0.02628" & vbcr & _
"113964  0.00904" & vbcr & _
"140095  0.02865" & vbcr & _
"156468  0.01945" & vbcr & _
"160651  0.02036" & vbcr & _
"173664  0.01246" & vbcr & _
"177031  0.01551" & vbcr & _
"183589  0.00901" & vbcr & _
"186759  0.00521" & vbcr & _
"198829  0.00462" & vbcr & _
"199777  0.00200" & vbcr & _
"203268  0.00975" & vbcr & _
"210778  0.01397" & vbcr & _
"211735  0.02445" & vbcr & _
"264590  0.00603" & vbcr & _
"278236  0.01982" & vbcr & _
"288625  0.01973" & vbcr & _
"297715  0.00439" & vbcr & _
"305856  0.01536" & vbcr & _
"307235  0.00772" & vbcr & _
"320469  0.01939" & vbcr & _
"345881  0.00801" & vbcr & _
"390793  0.02632" & vbcr & _
"454907  0.01681" & vbcr & _
"482136  0.02162" & vbcr & _
"514185  0.00614" & vbcr & _
"524739  0.00324" & vbcr & _
"538109  0.02550" & vbcr & _
"565405  0.00861" & vbcr & _
"632937  0.00798" & vbcr & _
"652705  0.01457" & vbcr & _
"753692  0.02624" & vbcr & _
"754986  0.01738" & vbcr & _
"807639  0.01259" & vbcr & _
"888391  0.00508" & vbcr & _
"1043801  0.02797" & vbcr & _
"1120574  0.00366" & vbcr & _
"1540449  0.02107" & vbcr & _
"1588792  0.00613" & vbcr & _
"1705347  0.02945" & vbcr & _
"2156745  0.01005" & vbcr & _
"2443293  0.00090" & vbcr & _
"2791118  0.00175" & vbcr & _
"2857957  0.02902" & vbcr & _
"3042890  0.01377" & vbcr & _
"3224650  0.01192" & vbcr & _
"3268735  0.02205" & vbcr & _
"6198939  0.00504" & vbcr & _
"10076928  0.01170" & vbcr & _
"10759669  0.01632" & vbcr & _
"15173606  0.01298"
End Function

Function CommAutoSchPInc()
	'' first year 1990
	'' From One Source
 CommAutoSchPInc = "5145552 7236550 8169323 8646913 8855134 8917136 8938425 8955828 8954606 8971067" & vbcr & _
  "4960621 6964630 7758998 8236261 8302729 8376171 8429611 8423997 8439551" & vbcr & _
  "5147829 6837168 7713322 8108693 8317687 8379181 8380908 8434451" & vbcr & _  
  "5320493 7329762 8208754 8629890 8834279 8885639 8936896" & vbcr & _
  "5704613 7817095 8765450 9283116 9472721 9606042" & vbcr & _
  "5811016 7817097 8779441 9329029 9535366" & vbcr & _
  "6029287 8162855 9289973 9959833" & vbcr & _
  "6218526 8343861 9630494" & vbcr & _
  "6105337 8509133" & vbcr & _
  "6449569" 
End Function

Function CommAutoSchPPd()
 '' first year 1990
 '' NOTE: the first entry is actually 2530353, but this gives negative skewness and grief
 '' from One Source
 CommAutoSchPPd = "1930353 4182944 6092774 7365740 8106544 8491786 8691120 8783131 8825195 8860906" & vbcr & _
  "1745410 4018008 5822006 6953876 7638052 7992752 8182873 8255003 8326031" & vbcr & _ 
  "1759625 3939005 5743465 6920017 7641063 7990132 8124280 8264095" & vbcr & _  
  "1880227 4269352 6188596 7431517 8144399 8486069 8720878" & vbcr & _   
  "2166057 4681612 6657327 8030813 8773492 9238328" & vbcr & _    
  "2281592 4828765 6733638 8081130 8861559" & vbcr & _     
  "2487606 5066823 7185730 8635578" & vbcr & _      
  "2493518 5216440 7476539" & vbcr & _       
  "2504133 5348110" & vbcr & _        
  "2673260"          
End Function

'' reinsurance related incurred loss triangle
'' rescaled and noise added
Function ReinsIncTrg()
'  first year 1977
ReinsIncTrg  =" 192 1000 1541 1914 2297 2701 3895 3705 4227 3875 3851 3802 3925 3985 " & vbcr & _
" 697 1100 1510 2085 2567 2931 3226 3121 3419 3312 3351 3327 3427  " & vbcr & _
" 254 1210 1977 2164 3005 3266 3636 3570 3762 4139 4098 4011   " & vbcr & _
" 442 1331 1917 2341 2435 2962 3052 3349 3396 3341 3220    " & vbcr & _
" 395 1464 2223 2764 3347 3872 4504 5184 5189 5132     " & vbcr & _
" 575 1611 2524 3137 3417 3444 3360 3607 3640      " & vbcr & _
" 834 1772 2463 2695 3356 3659 3754 3913       " & vbcr & _
" 490 1949 3249 3786 4813 5067 5349        " & vbcr & _
" 760 2144 3178 3479 3671 4090         " & vbcr & _
" 1031 2358 3242 4277 4749          " & vbcr & _
" 893 2594 3530 4390           " & vbcr & _
" 1257 2853 6003            " & vbcr & _
" 921 3138             " & vbcr & _
" 500              " 
End Function

''Greg Taylor triangle
Function TaylorTriangle()
TaylorTriangle = "9268 18263 20182 22383 22782 26348 26172 26184 25455 25740 25711 25452 25460 25422 25386 25520 25646 25469" & vbcr & _
"9848 16123 17099 18544 20534 21554 23219 22381 21584 21408 20857 21163 20482 19971 19958 19947 19991 " & vbcr & _
"13990 22484 24950 33255 33295 34308 34022 34023 33842 33933 33570 31881 32203 32345 32250 32168 " & vbcr & _ 
"16550 28056 39995 42459 42797 42755 42435 42302 42095 41606 40440 40432 40326 40337 40096  " & vbcr & _ 
"11100 31620 40852 38831 39516 39870 40358 40355 40116 39888 39898 40147 39827 40200  " & vbcr & _  
"15677 33074 35592 35721 38652 39418 39223 39696 37769 37894 37369 37345 37075  " & vbcr & _   
"20375 33555 41756 45125 47284 51710 52147 51187 51950 50967 51461 51382 " & vbcr & _     
"9800 24663 36061 37927 40042 40562 40362 40884 40597 41304 42378 " & vbcr & _      
"11380 26843 34931 37805 41277 44901 45867 45404 45347 44383 " & vbcr & _       
"10226 20511 26882 32326 35257 40557 43753 44609 44196 " & vbcr & _        
"8170 18567 26472 33002 36321 37047 39675 40398" & vbcr & _          
"10433 19484 32103 38936 45851 45133 45501   " & vbcr & _        
"9661 23808 32966 42907 46930 49300" & vbcr & _            
"14275 25551 33754 38674 41132 " & vbcr & _            
"13245 29206 36987 44075  " & vbcr & _            
"14711 27082 34230" & vbcr & _
"12476 23126" & vbcr & _
"9715"
End Function

'' light, mostly ppt fleet, altered from original
Sub lightEG_onclick()
	LLL.value = "103000 108000 108000 109000 110000 136000 113000 151000 131000 122000 142000 104000 146000 155000 171000 155000 177000 171000 162000 183000 184000 174000 203000 252000 230000 245000 250000 260000 266000 287000 268000 297000 355000 303000 348000 412000 420000 402000 483000 521000 570000 520000 600000 600000 660000 780000 852000 902000 990000 1000000"
	dataLimit.value = 100000
	polLimit.value = 0	
End Sub

'' large, trucking related losses, with some changes
Sub heavyEG_onclick()
	LLL.value = "250000" & vbcr & _
"250000" & vbcr & _
"250000" & vbcr & _
"252000" & vbcr & _
"250000" & vbcr & _
"252500" & vbcr & _
"300000" & vbcr & _
"306000" & vbcr & _
"333000" & vbcr & _
"350000" & vbcr & _
"350000" & vbcr & _
"360000" & vbcr & _
"375000" & vbcr & _
"387000" & vbcr & _
"401000" & vbcr & _
"400000" & vbcr & _
"410000" & vbcr & _
"450000" & vbcr & _
"460000" & vbcr & _
"470000" & vbcr & _
"520000" & vbcr & _
"510000" & vbcr & _
"587000" & vbcr & _
"568000" & vbcr & _
"635000" & vbcr & _
"730000" & vbcr & _
"870000" & vbcr & _
"880000" & vbcr & _
"980000" & vbcr & _
"1143000" & vbcr & _
"1152000" & vbcr & _
"1125000" & vbcr & _
"1278000" & vbcr & _
"1320000" & vbcr & _
"1450000" & vbcr & _
"1550000" & vbcr & _
"1680000" & vbcr & _
"1800000" & vbcr & _
"2000000" & vbcr & _
"2000000" & vbcr & _
"2250000" & vbcr & _
"2620000" & vbcr & _
"2910000" & vbcr & _
"3210000" & vbcr & _
"5000000"
dataLimit.value = 250000
polLimit.value = 0
End Sub