[9754] in Perl-Users-Digest

home help back first fref pref prev next nref lref last post

Perl-Users Digest, Issue: 3348 Volume: 8

daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Tue Aug 4 20:06:41 1998

Date: Tue, 4 Aug 98 17:01:25 -0700
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)

Perl-Users Digest           Tue, 4 Aug 1998     Volume: 8 Number: 3348

Today's topics:
        Excel-Chart OLE Perl Scripts <tfrith@vmasc.odu.edu>
        Special: Digest Administrivia (Last modified: 12 Mar 98 (Perl-Users-Digest Admin)

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

Date: Tue, 04 Aug 1998 14:13:26 -0400
From: Taylor Frith <tfrith@vmasc.odu.edu>
Subject: Excel-Chart OLE Perl Scripts
Message-Id: <35C74F45.4B639588@vmasc.odu.edu>

This is a multi-part message in MIME format.
--------------40AB6A63A36B17BE4A006040
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I've been trying to make this Perl script work properly.  It generates
the chart but some reason its not picking up the Legend names from the
A2 row (A2, B2, C2).  It just labels them Series 1, 2, 3.  I'm adding
the chart early on because I don't want to see the data being filled
into worksheet 1.  Any suggestions would be greatly appreciated.

Taylor Frith
tfrith@vmasc.odu.edu

BEGIN {
@INC = qw( ..\perl5.0\lib ..\perl5.0\ext );

}


use OLE;
$ChartTypeVal = 1;
$ExcelApp = CreateObject OLE "excel.application" || die "Unable to
create Excel Object: $!\n";
$ExcelApp->{'Visible'} = 1;
$workbook = $ExcelApp->Workbooks->Add();
$worksheet = $workbook->Worksheets(1);
$ExcelChart = $ExcelApp->Charts->Add();
$worksheet->Range("A2")->{'Value'} = "Arrived at Port";
$worksheet->Range("B2")->{'Value'} = "Parked in Staging";
$worksheet->Range("C2")->{'Value'} = "Loaded Onto Ship";
$worksheet->Range("A3")->{'Value'} = 807;
$worksheet->Range("B3")->{'Value'} = 104;
$worksheet->Range("C3")->{'Value'} = 0;
$worksheet->Range("A4")->{'Value'} = 1218;
$worksheet->Range("B4")->{'Value'} = 210;
$worksheet->Range("C4")->{'Value'} = 0;
$worksheet->Range("A5")->{'Value'} = 1635;
$worksheet->Range("B5")->{'Value'} = 371;
$worksheet->Range("C5")->{'Value'} = 0;
$worksheet->Range("A6")->{'Value'} = 1784;
$worksheet->Range("B6")->{'Value'} = 561;
$worksheet->Range("C6")->{'Value'} = 0;
$worksheet->Range("A7")->{'Value'} = 1884;
$worksheet->Range("B7")->{'Value'} = 706;
$worksheet->Range("C7")->{'Value'} = 0;
$worksheet->Range("A8")->{'Value'} = 2134;
$worksheet->Range("B8")->{'Value'} = 913;
$worksheet->Range("C8")->{'Value'} = 0;
$worksheet->Range("A9")->{'Value'} = 2334;
$worksheet->Range("B9")->{'Value'} = 1138;
$worksheet->Range("C9")->{'Value'} = 0;
$worksheet->Range("A10")->{'Value'} = 2334;
$worksheet->Range("B10")->{'Value'} = 1338;
$worksheet->Range("C10")->{'Value'} = 0;
$worksheet->Range("A11")->{'Value'} = 2434;
$worksheet->Range("B11")->{'Value'} = 1477;
$worksheet->Range("C11")->{'Value'} = 0;
$worksheet->Range("A12")->{'Value'} = 2584;
$worksheet->Range("B12")->{'Value'} = 1664;
$worksheet->Range("C12")->{'Value'} = 0;
$worksheet->Range("A13")->{'Value'} = 2584;
$worksheet->Range("B13")->{'Value'} = 1719;
$worksheet->Range("C13")->{'Value'} = 0;
$worksheet->Range("A14")->{'Value'} = 2784;
$worksheet->Range("B14")->{'Value'} = 1869;
$worksheet->Range("C14")->{'Value'} = 0;
$worksheet->Range("A15")->{'Value'} = 2934;
$worksheet->Range("B15")->{'Value'} = 2048;
$worksheet->Range("C15")->{'Value'} = 0;
$worksheet->Range("A16")->{'Value'} = 3034;
$worksheet->Range("B16")->{'Value'} = 2179;
$worksheet->Range("C16")->{'Value'} = 0;
$worksheet->Range("A17")->{'Value'} = 3284;
$worksheet->Range("B17")->{'Value'} = 2335;
$worksheet->Range("C17")->{'Value'} = 0;
$worksheet->Range("A18")->{'Value'} = 3384;
$worksheet->Range("B18")->{'Value'} = 2525;
$worksheet->Range("C18")->{'Value'} = 0;
$worksheet->Range("A19")->{'Value'} = 3484;
$worksheet->Range("B19")->{'Value'} = 2682;
$worksheet->Range("C19")->{'Value'} = 0;
$worksheet->Range("A20")->{'Value'} = 3534;
$worksheet->Range("B20")->{'Value'} = 2743;
$worksheet->Range("C20")->{'Value'} = 0;
$worksheet->Range("A21")->{'Value'} = 3784;
$worksheet->Range("B21")->{'Value'} = 2891;
$worksheet->Range("C21")->{'Value'} = 0;
$worksheet->Range("A22")->{'Value'} = 3884;
$worksheet->Range("B22")->{'Value'} = 3007;
$worksheet->Range("C22")->{'Value'} = 0;
$worksheet->Range("A23")->{'Value'} = 3984;
$worksheet->Range("B23")->{'Value'} = 3120;
$worksheet->Range("C23")->{'Value'} = 0;
$worksheet->Range("A24")->{'Value'} = 4172;
$worksheet->Range("B24")->{'Value'} = 3257;
$worksheet->Range("C24")->{'Value'} = 0;
$worksheet->Range("A25")->{'Value'} = 4272;
$worksheet->Range("B25")->{'Value'} = 3352;
$worksheet->Range("C25")->{'Value'} = 0;
$worksheet->Range("A26")->{'Value'} = 4322;
$worksheet->Range("B26")->{'Value'} = 3433;
$worksheet->Range("C26")->{'Value'} = 0;
$worksheet->Range("A27")->{'Value'} = 4422;
$worksheet->Range("B27")->{'Value'} = 3496;
$worksheet->Range("C27")->{'Value'} = 0;
$worksheet->Range("A28")->{'Value'} = 4622;
$worksheet->Range("B28")->{'Value'} = 3723;
$worksheet->Range("C28")->{'Value'} = 0;
$worksheet->Range("A29")->{'Value'} = 4672;
$worksheet->Range("B29")->{'Value'} = 3876;
$worksheet->Range("C29")->{'Value'} = 0;
$worksheet->Range("A30")->{'Value'} = 4922;
$worksheet->Range("B30")->{'Value'} = 3927;
$worksheet->Range("C30")->{'Value'} = 25;
$worksheet->Range("A31")->{'Value'} = 4972;
$worksheet->Range("B31")->{'Value'} = 3973;
$worksheet->Range("C31")->{'Value'} = 86;
$worksheet->Range("A32")->{'Value'} = 5022;
$worksheet->Range("B32")->{'Value'} = 4002;
$worksheet->Range("C32")->{'Value'} = 157;
$worksheet->Range("A33")->{'Value'} = 5222;
$worksheet->Range("B33")->{'Value'} = 4008;
$worksheet->Range("C33")->{'Value'} = 215;
$worksheet->Range("A34")->{'Value'} = 5222;
$worksheet->Range("B34")->{'Value'} = 4024;
$worksheet->Range("C34")->{'Value'} = 322;
$worksheet->Range("A35")->{'Value'} = 5322;
$worksheet->Range("B35")->{'Value'} = 4044;
$worksheet->Range("C35")->{'Value'} = 401;
$worksheet->Range("A36")->{'Value'} = 5422;
$worksheet->Range("B36")->{'Value'} = 4052;
$worksheet->Range("C36")->{'Value'} = 450;
$worksheet->Range("A37")->{'Value'} = 5422;
$worksheet->Range("B37")->{'Value'} = 4058;
$worksheet->Range("C37")->{'Value'} = 501;
$worksheet->Range("A38")->{'Value'} = 5422;
$worksheet->Range("B38")->{'Value'} = 4065;
$worksheet->Range("C38")->{'Value'} = 550;
$worksheet->Range("A39")->{'Value'} = 5672;
$worksheet->Range("B39")->{'Value'} = 4081;
$worksheet->Range("C39")->{'Value'} = 599;
$worksheet->Range("A40")->{'Value'} = 5822;
$worksheet->Range("B40")->{'Value'} = 4094;
$worksheet->Range("C40")->{'Value'} = 648;
$worksheet->Range("A41")->{'Value'} = 6194;
$worksheet->Range("B41")->{'Value'} = 4104;
$worksheet->Range("C41")->{'Value'} = 697;
$worksheet->Range("A42")->{'Value'} = 6244;
$worksheet->Range("B42")->{'Value'} = 4112;
$worksheet->Range("C42")->{'Value'} = 764;
$worksheet->Range("A43")->{'Value'} = 6394;
$worksheet->Range("B43")->{'Value'} = 4118;
$worksheet->Range("C43")->{'Value'} = 853;
$worksheet->Range("A44")->{'Value'} = 6444;
$worksheet->Range("B44")->{'Value'} = 4133;
$worksheet->Range("C44")->{'Value'} = 908;
$worksheet->Range("A45")->{'Value'} = 6544;
$worksheet->Range("B45")->{'Value'} = 4183;
$worksheet->Range("C45")->{'Value'} = 970;
$worksheet->Range("A46")->{'Value'} = 6744;
$worksheet->Range("B46")->{'Value'} = 4361;
$worksheet->Range("C46")->{'Value'} = 1023;
$worksheet->Range("A47")->{'Value'} = 6794;
$worksheet->Range("B47")->{'Value'} = 4467;
$worksheet->Range("C47")->{'Value'} = 1073;
$worksheet->Range("A48")->{'Value'} = 6794;
$worksheet->Range("B48")->{'Value'} = 4545;
$worksheet->Range("C48")->{'Value'} = 1142;
$worksheet->Range("A49")->{'Value'} = 7044;
$worksheet->Range("B49")->{'Value'} = 4617;
$worksheet->Range("C49")->{'Value'} = 1199;
$worksheet->Range("A50")->{'Value'} = 7094;
$worksheet->Range("B50")->{'Value'} = 4795;
$worksheet->Range("C50")->{'Value'} = 1264;
$worksheet->Range("A51")->{'Value'} = 7194;
$worksheet->Range("B51")->{'Value'} = 4896;
$worksheet->Range("C51")->{'Value'} = 1329;
$worksheet->Range("A52")->{'Value'} = 7344;
$worksheet->Range("B52")->{'Value'} = 5052;
$worksheet->Range("C52")->{'Value'} = 1395;
$worksheet->Range("A53")->{'Value'} = 7444;
$worksheet->Range("B53")->{'Value'} = 5197;
$worksheet->Range("C53")->{'Value'} = 1470;
$worksheet->Range("A54")->{'Value'} = 7494;
$worksheet->Range("B54")->{'Value'} = 5248;
$worksheet->Range("C54")->{'Value'} = 1527;
$worksheet->Range("A55")->{'Value'} = 7644;
$worksheet->Range("B55")->{'Value'} = 5387;
$worksheet->Range("C55")->{'Value'} = 1594;
$worksheet->Range("A56")->{'Value'} = 7744;
$worksheet->Range("B56")->{'Value'} = 5403;
$worksheet->Range("C56")->{'Value'} = 1653;
$worksheet->Range("A57")->{'Value'} = 7794;
$worksheet->Range("B57")->{'Value'} = 5549;
$worksheet->Range("C57")->{'Value'} = 1702;
$worksheet->Range("A58")->{'Value'} = 7928;
$worksheet->Range("B58")->{'Value'} = 5549;
$worksheet->Range("C58")->{'Value'} = 1779;
$worksheet->Range("A59")->{'Value'} = 7928;
$worksheet->Range("B59")->{'Value'} = 5551;
$worksheet->Range("C59")->{'Value'} = 1846;
$worksheet->Range("A60")->{'Value'} = 8073;
$worksheet->Range("B60")->{'Value'} = 5567;
$worksheet->Range("C60")->{'Value'} = 1913;
$worksheet->Range("A61")->{'Value'} = 8073;
$worksheet->Range("B61")->{'Value'} = 5570;
$worksheet->Range("C61")->{'Value'} = 1971;
$worksheet->Range("A62")->{'Value'} = 8073;
$worksheet->Range("B62")->{'Value'} = 5577;
$worksheet->Range("C62")->{'Value'} = 2038;
$worksheet->Range("A63")->{'Value'} = 8073;
$worksheet->Range("B63")->{'Value'} = 5585;
$worksheet->Range("C63")->{'Value'} = 2096;
$worksheet->Range("A64")->{'Value'} = 8073;
$worksheet->Range("B64")->{'Value'} = 5600;
$worksheet->Range("C64")->{'Value'} = 2154;
$worksheet->Range("A65")->{'Value'} = 8211;
$worksheet->Range("B65")->{'Value'} = 5604;
$worksheet->Range("C65")->{'Value'} = 2213;
$worksheet->Range("A66")->{'Value'} = 8211;
$worksheet->Range("B66")->{'Value'} = 5608;
$worksheet->Range("C66")->{'Value'} = 2267;
$worksheet->Range("A67")->{'Value'} = 8342;
$worksheet->Range("B67")->{'Value'} = 5612;
$worksheet->Range("C67")->{'Value'} = 2337;
$worksheet->Range("A68")->{'Value'} = 8342;
$worksheet->Range("B68")->{'Value'} = 5619;
$worksheet->Range("C68")->{'Value'} = 2398;
$worksheet->Range("A69")->{'Value'} = 8342;
$worksheet->Range("B69")->{'Value'} = 5625;
$worksheet->Range("C69")->{'Value'} = 2451;
$worksheet->Range("A70")->{'Value'} = 8342;
$worksheet->Range("B70")->{'Value'} = 5637;
$worksheet->Range("C70")->{'Value'} = 2518;
$worksheet->Range("A71")->{'Value'} = 8342;
$worksheet->Range("B71")->{'Value'} = 5645;
$worksheet->Range("C71")->{'Value'} = 2570;
$worksheet->Range("A72")->{'Value'} = 8342;
$worksheet->Range("B72")->{'Value'} = 5649;
$worksheet->Range("C72")->{'Value'} = 2630;
$worksheet->Range("A73")->{'Value'} = 8342;
$worksheet->Range("B73")->{'Value'} = 5654;
$worksheet->Range("C73")->{'Value'} = 2690;
$worksheet->Range("A74")->{'Value'} = 8342;
$worksheet->Range("B74")->{'Value'} = 5662;
$worksheet->Range("C74")->{'Value'} = 2743;
$worksheet->Range("A75")->{'Value'} = 8342;
$worksheet->Range("B75")->{'Value'} = 5678;
$worksheet->Range("C75")->{'Value'} = 2806;
$worksheet->Range("A76")->{'Value'} = 8342;
$worksheet->Range("B76")->{'Value'} = 5683;
$worksheet->Range("C76")->{'Value'} = 2868;
$worksheet->Range("A77")->{'Value'} = 8342;
$worksheet->Range("B77")->{'Value'} = 5687;
$worksheet->Range("C77")->{'Value'} = 2923;
$worksheet->Range("A78")->{'Value'} = 8473;
$worksheet->Range("B78")->{'Value'} = 5691;
$worksheet->Range("C78")->{'Value'} = 2988;
$worksheet->Range("A79")->{'Value'} = 8473;
$worksheet->Range("B79")->{'Value'} = 5698;
$worksheet->Range("C79")->{'Value'} = 3056;
$worksheet->Range("A80")->{'Value'} = 8473;
$worksheet->Range("B80")->{'Value'} = 5704;
$worksheet->Range("C80")->{'Value'} = 3111;
$worksheet->Range("A81")->{'Value'} = 8473;
$worksheet->Range("B81")->{'Value'} = 5710;
$worksheet->Range("C81")->{'Value'} = 3186;
$worksheet->Range("A82")->{'Value'} = 8473;
$worksheet->Range("B82")->{'Value'} = 5719;
$worksheet->Range("C82")->{'Value'} = 3250;
$worksheet->Range("A83")->{'Value'} = 8473;
$worksheet->Range("B83")->{'Value'} = 5735;
$worksheet->Range("C83")->{'Value'} = 3307;
$worksheet->Range("A84")->{'Value'} = 8473;
$worksheet->Range("B84")->{'Value'} = 5739;
$worksheet->Range("C84")->{'Value'} = 3379;
$worksheet->Range("A85")->{'Value'} = 8473;
$worksheet->Range("B85")->{'Value'} = 5743;
$worksheet->Range("C85")->{'Value'} = 3445;
$worksheet->Range("A86")->{'Value'} = 8473;
$worksheet->Range("B86")->{'Value'} = 5747;
$worksheet->Range("C86")->{'Value'} = 3503;
$worksheet->Range("A87")->{'Value'} = 8473;
$worksheet->Range("B87")->{'Value'} = 5908;
$worksheet->Range("C87")->{'Value'} = 3554;
$worksheet->Range("A88")->{'Value'} = 8473;
$worksheet->Range("B88")->{'Value'} = 6170;
$worksheet->Range("C88")->{'Value'} = 3587;
$worksheet->Range("A89")->{'Value'} = 8473;
$worksheet->Range("B89")->{'Value'} = 6428;
$worksheet->Range("C89")->{'Value'} = 3618;
$worksheet->Range("A90")->{'Value'} = 8473;
$worksheet->Range("B90")->{'Value'} = 6520;
$worksheet->Range("C90")->{'Value'} = 3636;
$worksheet->Range("A91")->{'Value'} = 8473;
$worksheet->Range("B91")->{'Value'} = 6539;
$worksheet->Range("C91")->{'Value'} = 3644;
$worksheet->Range("A92")->{'Value'} = 8473;
$worksheet->Range("B92")->{'Value'} = 6696;
$worksheet->Range("C92")->{'Value'} = 3648;
$worksheet->Range("A93")->{'Value'} = 8473;
$worksheet->Range("B93")->{'Value'} = 6812;
$worksheet->Range("C93")->{'Value'} = 3648;
$worksheet->Range("A94")->{'Value'} = 8473;
$worksheet->Range("B94")->{'Value'} = 6815;
$worksheet->Range("C94")->{'Value'} = 3650;
$worksheet->Range("A95")->{'Value'} = 8473;
$worksheet->Range("B95")->{'Value'} = 6823;
$worksheet->Range("C95")->{'Value'} = 3658;
$worksheet->Range("A96")->{'Value'} = 8635;
$worksheet->Range("B96")->{'Value'} = 6831;
$worksheet->Range("C96")->{'Value'} = 3667;
$worksheet->Range("A97")->{'Value'} = 8635;
$worksheet->Range("B97")->{'Value'} = 6837;
$worksheet->Range("C97")->{'Value'} = 3669;
$worksheet->Range("A98")->{'Value'} = 8635;
$worksheet->Range("B98")->{'Value'} = 6845;
$worksheet->Range("C98")->{'Value'} = 3669;
$worksheet->Range("A99")->{'Value'} = 8635;
$worksheet->Range("B99")->{'Value'} = 6865;
$worksheet->Range("C99")->{'Value'} = 3686;
$worksheet->Range("A100")->{'Value'} = 8635;
$worksheet->Range("B100")->{'Value'} = 6905;
$worksheet->Range("C100")->{'Value'} = 3723;
$worksheet->Range("A101")->{'Value'} = 8635;
$worksheet->Range("B101")->{'Value'} = 6945;
$worksheet->Range("C101")->{'Value'} = 3740;
$worksheet->Range("A102")->{'Value'} = 8635;
$worksheet->Range("B102")->{'Value'} = 6960;
$worksheet->Range("C102")->{'Value'} = 3756;
$worksheet->Range("A103")->{'Value'} = 8635;
$worksheet->Range("B103")->{'Value'} = 6968;
$worksheet->Range("C103")->{'Value'} = 3777;
$worksheet->Range("A104")->{'Value'} = 8635;
$worksheet->Range("B104")->{'Value'} = 6976;
$worksheet->Range("C104")->{'Value'} = 3816;
$worksheet->Range("A105")->{'Value'} = 8635;
$worksheet->Range("B105")->{'Value'} = 6978;
$worksheet->Range("C105")->{'Value'} = 3847;
$worksheet->Range("A106")->{'Value'} = 8635;
$worksheet->Range("B106")->{'Value'} = 6983;
$worksheet->Range("C106")->{'Value'} = 3864;
$worksheet->Range("A107")->{'Value'} = 8635;
$worksheet->Range("B107")->{'Value'} = 6987;
$worksheet->Range("C107")->{'Value'} = 3880;
$worksheet->Range("A108")->{'Value'} = 8635;
$worksheet->Range("B108")->{'Value'} = 6993;
$worksheet->Range("C108")->{'Value'} = 3897;
$worksheet->Range("A109")->{'Value'} = 8635;
$worksheet->Range("B109")->{'Value'} = 6997;
$worksheet->Range("C109")->{'Value'} = 3914;
$worksheet->Range("A110")->{'Value'} = 8635;
$worksheet->Range("B110")->{'Value'} = 7002;
$worksheet->Range("C110")->{'Value'} = 3960;
$worksheet->Range("A111")->{'Value'} = 8635;
$worksheet->Range("B111")->{'Value'} = 7008;
$worksheet->Range("C111")->{'Value'} = 4013;
$worksheet->Range("A112")->{'Value'} = 8635;
$worksheet->Range("B112")->{'Value'} = 7014;
$worksheet->Range("C112")->{'Value'} = 4046;
$worksheet->Range("A113")->{'Value'} = 8635;
$worksheet->Range("B113")->{'Value'} = 7019;
$worksheet->Range("C113")->{'Value'} = 4095;
$worksheet->Range("A114")->{'Value'} = 8635;
$worksheet->Range("B114")->{'Value'} = 7023;
$worksheet->Range("C114")->{'Value'} = 4137;
$worksheet->Range("A115")->{'Value'} = 8635;
$worksheet->Range("B115")->{'Value'} = 7030;
$worksheet->Range("C115")->{'Value'} = 4172;
$worksheet->Range("A116")->{'Value'} = 8635;
$worksheet->Range("B116")->{'Value'} = 7033;
$worksheet->Range("C116")->{'Value'} = 4220;
$worksheet->Range("A117")->{'Value'} = 8635;
$worksheet->Range("B117")->{'Value'} = 7038;
$worksheet->Range("C117")->{'Value'} = 4330;
$worksheet->Range("A118")->{'Value'} = 8635;
$worksheet->Range("B118")->{'Value'} = 7043;
$worksheet->Range("C118")->{'Value'} = 4456;
$worksheet->Range("A119")->{'Value'} = 8635;
$worksheet->Range("B119")->{'Value'} = 7050;
$worksheet->Range("C119")->{'Value'} = 4513;
$worksheet->Range("A120")->{'Value'} = 8635;
$worksheet->Range("B120")->{'Value'} = 7055;
$worksheet->Range("C120")->{'Value'} = 4563;
$worksheet->Range("A121")->{'Value'} = 8635;
$worksheet->Range("B121")->{'Value'} = 7061;
$worksheet->Range("C121")->{'Value'} = 4624;
$worksheet->Range("A122")->{'Value'} = 8635;
$worksheet->Range("B122")->{'Value'} = 7069;
$worksheet->Range("C122")->{'Value'} = 4712;
$worksheet->Range("A123")->{'Value'} = 8635;
$worksheet->Range("B123")->{'Value'} = 7074;
$worksheet->Range("C123")->{'Value'} = 4761;
$worksheet->Range("A124")->{'Value'} = 8635;
$worksheet->Range("B124")->{'Value'} = 7078;
$worksheet->Range("C124")->{'Value'} = 4810;
$worksheet->Range("A125")->{'Value'} = 8635;
$worksheet->Range("B125")->{'Value'} = 7081;
$worksheet->Range("C125")->{'Value'} = 4857;
$worksheet->Range("A126")->{'Value'} = 8635;
$worksheet->Range("B126")->{'Value'} = 7087;
$worksheet->Range("C126")->{'Value'} = 4910;
$worksheet->Range("A127")->{'Value'} = 8635;
$worksheet->Range("B127")->{'Value'} = 7095;
$worksheet->Range("C127")->{'Value'} = 4965;
$worksheet->Range("A128")->{'Value'} = 8635;
$worksheet->Range("B128")->{'Value'} = 7102;
$worksheet->Range("C128")->{'Value'} = 5017;
$worksheet->Range("A129")->{'Value'} = 8635;
$worksheet->Range("B129")->{'Value'} = 7111;
$worksheet->Range("C129")->{'Value'} = 5065;
$worksheet->Range("A130")->{'Value'} = 8635;
$worksheet->Range("B130")->{'Value'} = 7120;
$worksheet->Range("C130")->{'Value'} = 5111;
$worksheet->Range("A131")->{'Value'} = 8635;
$worksheet->Range("B131")->{'Value'} = 7127;
$worksheet->Range("C131")->{'Value'} = 5167;
$worksheet->Range("A132")->{'Value'} = 8635;
$worksheet->Range("B132")->{'Value'} = 7129;
$worksheet->Range("C132")->{'Value'} = 5230;
$worksheet->Range("A133")->{'Value'} = 8635;
$worksheet->Range("B133")->{'Value'} = 7129;
$worksheet->Range("C133")->{'Value'} = 5283;
$worksheet->Range("A134")->{'Value'} = 8635;
$worksheet->Range("B134")->{'Value'} = 7129;
$worksheet->Range("C134")->{'Value'} = 5341;
$worksheet->Range("A135")->{'Value'} = 8635;
$worksheet->Range("B135")->{'Value'} = 7129;
$worksheet->Range("C135")->{'Value'} = 5394;
$worksheet->Range("A136")->{'Value'} = 8635;
$worksheet->Range("B136")->{'Value'} = 7129;
$worksheet->Range("C136")->{'Value'} = 5443;
$worksheet->Range("A137")->{'Value'} = 8635;
$worksheet->Range("B137")->{'Value'} = 7129;
$worksheet->Range("C137")->{'Value'} = 5496;
$worksheet->Range("A138")->{'Value'} = 8635;
$worksheet->Range("B138")->{'Value'} = 7129;
$worksheet->Range("C138")->{'Value'} = 5549;
$worksheet->Range("A139")->{'Value'} = 8635;
$worksheet->Range("B139")->{'Value'} = 7129;
$worksheet->Range("C139")->{'Value'} = 5602;
$worksheet->Range("A140")->{'Value'} = 8635;
$worksheet->Range("B140")->{'Value'} = 7129;
$worksheet->Range("C140")->{'Value'} = 5665;
$worksheet->Range("A141")->{'Value'} = 8635;
$worksheet->Range("B141")->{'Value'} = 7129;
$worksheet->Range("C141")->{'Value'} = 5720;
$worksheet->Range("A142")->{'Value'} = 8635;
$worksheet->Range("B142")->{'Value'} = 7129;
$worksheet->Range("C142")->{'Value'} = 5774;
$worksheet->Range("A143")->{'Value'} = 8635;
$worksheet->Range("B143")->{'Value'} = 7129;
$worksheet->Range("C143")->{'Value'} = 5825;
$worksheet->Range("A144")->{'Value'} = 8635;
$worksheet->Range("B144")->{'Value'} = 7136;
$worksheet->Range("C144")->{'Value'} = 5865;
$worksheet->Range("A145")->{'Value'} = 8635;
$worksheet->Range("B145")->{'Value'} = 7136;
$worksheet->Range("C145")->{'Value'} = 5907;
$worksheet->Range("A146")->{'Value'} = 8635;
$worksheet->Range("B146")->{'Value'} = 7136;
$worksheet->Range("C146")->{'Value'} = 5941;
$worksheet->Range("A147")->{'Value'} = 8635;
$worksheet->Range("B147")->{'Value'} = 7136;
$worksheet->Range("C147")->{'Value'} = 5978;
$worksheet->Range("A148")->{'Value'} = 8635;
$worksheet->Range("B148")->{'Value'} = 7136;
$worksheet->Range("C148")->{'Value'} = 6015;
$worksheet->Range("A149")->{'Value'} = 8635;
$worksheet->Range("B149")->{'Value'} = 7136;
$worksheet->Range("C149")->{'Value'} = 6048;
$worksheet->Range("A150")->{'Value'} = 8635;
$worksheet->Range("B150")->{'Value'} = 7136;
$worksheet->Range("C150")->{'Value'} = 6077;
$worksheet->Range("A151")->{'Value'} = 8635;
$worksheet->Range("B151")->{'Value'} = 7136;
$worksheet->Range("C151")->{'Value'} = 6110;
$worksheet->Range("A152")->{'Value'} = 8635;
$worksheet->Range("B152")->{'Value'} = 7136;
$worksheet->Range("C152")->{'Value'} = 6148;
$worksheet->Range("A153")->{'Value'} = 8635;
$worksheet->Range("B153")->{'Value'} = 7136;
$worksheet->Range("C153")->{'Value'} = 6190;
$worksheet->Range("A154")->{'Value'} = 8635;
$worksheet->Range("B154")->{'Value'} = 7136;
$worksheet->Range("C154")->{'Value'} = 6215;
$worksheet->Range("A155")->{'Value'} = 8635;
$worksheet->Range("B155")->{'Value'} = 7136;
$worksheet->Range("C155")->{'Value'} = 6232;
$worksheet->Range("A156")->{'Value'} = 8635;
$worksheet->Range("B156")->{'Value'} = 7136;
$worksheet->Range("C156")->{'Value'} = 6260;
$worksheet->Range("A157")->{'Value'} = 8635;
$worksheet->Range("B157")->{'Value'} = 7136;
$worksheet->Range("C157")->{'Value'} = 6296;
$worksheet->Range("A158")->{'Value'} = 8635;
$worksheet->Range("B158")->{'Value'} = 7136;
$worksheet->Range("C158")->{'Value'} = 6331;
$worksheet->Range("A159")->{'Value'} = 8635;
$worksheet->Range("B159")->{'Value'} = 7136;
$worksheet->Range("C159")->{'Value'} = 6368;
$worksheet->Range("A160")->{'Value'} = 8635;
$worksheet->Range("B160")->{'Value'} = 7136;
$worksheet->Range("C160")->{'Value'} = 6401;
$worksheet->Range("A161")->{'Value'} = 8635;
$worksheet->Range("B161")->{'Value'} = 7136;
$worksheet->Range("C161")->{'Value'} = 6440;
$worksheet->Range("A162")->{'Value'} = 8635;
$worksheet->Range("B162")->{'Value'} = 7136;
$worksheet->Range("C162")->{'Value'} = 6482;
$worksheet->Range("A163")->{'Value'} = 8635;
$worksheet->Range("B163")->{'Value'} = 7207;
$worksheet->Range("C163")->{'Value'} = 6511;
$worksheet->Range("A164")->{'Value'} = 8635;
$worksheet->Range("B164")->{'Value'} = 7459;
$worksheet->Range("C164")->{'Value'} = 6543;
$worksheet->Range("A165")->{'Value'} = 8635;
$worksheet->Range("B165")->{'Value'} = 7711;
$worksheet->Range("C165")->{'Value'} = 6564;
$worksheet->Range("A166")->{'Value'} = 8635;
$worksheet->Range("B166")->{'Value'} = 7968;
$worksheet->Range("C166")->{'Value'} = 6580;
$worksheet->Range("A167")->{'Value'} = 8635;
$worksheet->Range("B167")->{'Value'} = 8215;
$worksheet->Range("C167")->{'Value'} = 6597;
$worksheet->Range("A168")->{'Value'} = 8635;
$worksheet->Range("B168")->{'Value'} = 8460;
$worksheet->Range("C168")->{'Value'} = 6624;
$worksheet->Range("A169")->{'Value'} = 8635;
$worksheet->Range("B169")->{'Value'} = 8614;
$worksheet->Range("C169")->{'Value'} = 6664;
$worksheet->Range("A170")->{'Value'} = 8635;
$worksheet->Range("B170")->{'Value'} = 8614;
$worksheet->Range("C170")->{'Value'} = 6713;
$worksheet->Range("A171")->{'Value'} = 8635;
$worksheet->Range("B171")->{'Value'} = 8614;
$worksheet->Range("C171")->{'Value'} = 6752;
$worksheet->Range("A172")->{'Value'} = 8635;
$worksheet->Range("B172")->{'Value'} = 8614;
$worksheet->Range("C172")->{'Value'} = 6785;
$worksheet->Range("A173")->{'Value'} = 8635;
$worksheet->Range("B173")->{'Value'} = 8614;
$worksheet->Range("C173")->{'Value'} = 6817;
$worksheet->Range("A174")->{'Value'} = 8635;
$worksheet->Range("B174")->{'Value'} = 8614;
$worksheet->Range("C174")->{'Value'} = 6854;
$worksheet->Range("A175")->{'Value'} = 8635;
$worksheet->Range("B175")->{'Value'} = 8614;
$worksheet->Range("C175")->{'Value'} = 6902;
$worksheet->Range("A176")->{'Value'} = 8635;
$worksheet->Range("B176")->{'Value'} = 8614;
$worksheet->Range("C176")->{'Value'} = 6963;
$worksheet->Range("A177")->{'Value'} = 8635;
$worksheet->Range("B177")->{'Value'} = 8614;
$worksheet->Range("C177")->{'Value'} = 7013;
$worksheet->Range("A178")->{'Value'} = 8635;
$worksheet->Range("B178")->{'Value'} = 8614;
$worksheet->Range("C178")->{'Value'} = 7060;
$worksheet->Range("A179")->{'Value'} = 8635;
$worksheet->Range("B179")->{'Value'} = 8614;
$worksheet->Range("C179")->{'Value'} = 7110;
$worksheet->Range("A180")->{'Value'} = 8635;
$worksheet->Range("B180")->{'Value'} = 8614;
$worksheet->Range("C180")->{'Value'} = 7162;
$worksheet->Range("A181")->{'Value'} = 8635;
$worksheet->Range("B181")->{'Value'} = 8614;
$worksheet->Range("C181")->{'Value'} = 7219;
$worksheet->Range("A182")->{'Value'} = 8635;
$worksheet->Range("B182")->{'Value'} = 8614;
$worksheet->Range("C182")->{'Value'} = 7277;
$worksheet->Range("A183")->{'Value'} = 8635;
$worksheet->Range("B183")->{'Value'} = 8614;
$worksheet->Range("C183")->{'Value'} = 7331;
$worksheet->Range("A184")->{'Value'} = 8635;
$worksheet->Range("B184")->{'Value'} = 8614;
$worksheet->Range("C184")->{'Value'} = 7385;
$worksheet->Range("A185")->{'Value'} = 8635;
$worksheet->Range("B185")->{'Value'} = 8614;
$worksheet->Range("C185")->{'Value'} = 7435;
$worksheet->Range("A186")->{'Value'} = 8635;
$worksheet->Range("B186")->{'Value'} = 8614;
$worksheet->Range("C186")->{'Value'} = 7483;
$worksheet->Range("A187")->{'Value'} = 8635;
$worksheet->Range("B187")->{'Value'} = 8614;
$worksheet->Range("C187")->{'Value'} = 7532;
$worksheet->Range("A188")->{'Value'} = 8635;
$worksheet->Range("B188")->{'Value'} = 8614;
$worksheet->Range("C188")->{'Value'} = 7581;
$worksheet->Range("A189")->{'Value'} = 8635;
$worksheet->Range("B189")->{'Value'} = 8614;
$worksheet->Range("C189")->{'Value'} = 7632;
$worksheet->Range("A190")->{'Value'} = 8635;
$worksheet->Range("B190")->{'Value'} = 8614;
$worksheet->Range("C190")->{'Value'} = 7683;
$worksheet->Range("A191")->{'Value'} = 8635;
$worksheet->Range("B191")->{'Value'} = 8614;
$worksheet->Range("C191")->{'Value'} = 7738;
$worksheet->Range("A192")->{'Value'} = 8635;
$worksheet->Range("B192")->{'Value'} = 8614;
$worksheet->Range("C192")->{'Value'} = 7793;
$worksheet->Range("A193")->{'Value'} = 8635;
$worksheet->Range("B193")->{'Value'} = 8614;
$worksheet->Range("C193")->{'Value'} = 7844;
$worksheet->Range("A194")->{'Value'} = 8635;
$worksheet->Range("B194")->{'Value'} = 8614;
$worksheet->Range("C194")->{'Value'} = 7907;
$worksheet->Range("A195")->{'Value'} = 8635;
$worksheet->Range("B195")->{'Value'} = 8614;
$worksheet->Range("C195")->{'Value'} = 7963;
$worksheet->Range("A196")->{'Value'} = 8635;
$worksheet->Range("B196")->{'Value'} = 8614;
$worksheet->Range("C196")->{'Value'} = 8021;
$worksheet->Range("A197")->{'Value'} = 8635;
$worksheet->Range("B197")->{'Value'} = 8618;
$worksheet->Range("C197")->{'Value'} = 8058;
$worksheet->Range("A198")->{'Value'} = 8635;
$worksheet->Range("B198")->{'Value'} = 8618;
$worksheet->Range("C198")->{'Value'} = 8089;
$worksheet->Range("A199")->{'Value'} = 8635;
$worksheet->Range("B199")->{'Value'} = 8618;
$worksheet->Range("C199")->{'Value'} = 8125;
$worksheet->Range("A200")->{'Value'} = 8635;
$worksheet->Range("B200")->{'Value'} = 8618;
$worksheet->Range("C200")->{'Value'} = 8167;
$worksheet->Range("A201")->{'Value'} = 8635;
$worksheet->Range("B201")->{'Value'} = 8618;
$worksheet->Range("C201")->{'Value'} = 8213;
$worksheet->Range("A202")->{'Value'} = 8635;
$worksheet->Range("B202")->{'Value'} = 8618;
$worksheet->Range("C202")->{'Value'} = 8253;
$worksheet->Range("A203")->{'Value'} = 8635;
$worksheet->Range("B203")->{'Value'} = 8618;
$worksheet->Range("C203")->{'Value'} = 8287;
$worksheet->Range("A204")->{'Value'} = 8635;
$worksheet->Range("B204")->{'Value'} = 8618;
$worksheet->Range("C204")->{'Value'} = 8326;
$worksheet->Range("A205")->{'Value'} = 8635;
$worksheet->Range("B205")->{'Value'} = 8618;
$worksheet->Range("C205")->{'Value'} = 8366;
$worksheet->Range("A206")->{'Value'} = 8635;
$worksheet->Range("B206")->{'Value'} = 8618;
$worksheet->Range("C206")->{'Value'} = 8404;
$worksheet->Range("A207")->{'Value'} = 8635;
$worksheet->Range("B207")->{'Value'} = 8618;
$worksheet->Range("C207")->{'Value'} = 8441;
$worksheet->Range("A208")->{'Value'} = 8635;
$worksheet->Range("B208")->{'Value'} = 8618;
$worksheet->Range("C208")->{'Value'} = 8474;
$worksheet->Range("A209")->{'Value'} = 8635;
$worksheet->Range("B209")->{'Value'} = 8618;
$worksheet->Range("C209")->{'Value'} = 8508;
$worksheet->Range("A210")->{'Value'} = 8635;
$worksheet->Range("B210")->{'Value'} = 8628;
$worksheet->Range("C210")->{'Value'} = 8541;
$worksheet->Range("A211")->{'Value'} = 8635;
$worksheet->Range("B211")->{'Value'} = 8635;
$worksheet->Range("C211")->{'Value'} = 8570;
$worksheet->Range("A212")->{'Value'} = 8635;
$worksheet->Range("B212")->{'Value'} = 8635;
$worksheet->Range("C212")->{'Value'} = 8591;
$worksheet->Range("A213")->{'Value'} = 8635;
$worksheet->Range("B213")->{'Value'} = 8635;
$worksheet->Range("C213")->{'Value'} = 8613;
$worksheet->Range("A214")->{'Value'} = 8635;
$worksheet->Range("B214")->{'Value'} = 8635;
$worksheet->Range("C214")->{'Value'} = 8631;
$worksheet->Range("A215")->{'Value'} = 8635;
$worksheet->Range("B215")->{'Value'} = 8635;
$worksheet->Range("C215")->{'Value'} = 8635;
$worksheet->Range("A216")->{'Value'} = 8635;
$worksheet->Range("B216")->{'Value'} = 8635;
$worksheet->Range("C216")->{'Value'} = 8635;
$worksheet->Range("A217")->{'Value'} = 8635;
$worksheet->Range("B217")->{'Value'} = 8635;
$worksheet->Range("C217")->{'Value'} = 8635;
$worksheet->Range("A218")->{'Value'} = 8635;
$worksheet->Range("B218")->{'Value'} = 8635;
$worksheet->Range("C218")->{'Value'} = 8635;
$worksheet->Range("A219")->{'Value'} = 8635;
$worksheet->Range("B219")->{'Value'} = 8635;
$worksheet->Range("C219")->{'Value'} = 8635;
$worksheet->Range("A220")->{'Value'} = 8635;
$worksheet->Range("B220")->{'Value'} = 8635;
$worksheet->Range("C220")->{'Value'} = 8635;
$worksheet->Range("A221")->{'Value'} = 8635;
$worksheet->Range("B221")->{'Value'} = 8635;
$worksheet->Range("C221")->{'Value'} = 8635;
$worksheet->Range("A222")->{'Value'} = 8635;
$worksheet->Range("B222")->{'Value'} = 8635;
$worksheet->Range("C222")->{'Value'} = 8635;
$worksheet->Range("A223")->{'Value'} = 8635;
$worksheet->Range("B223")->{'Value'} = 8635;
$worksheet->Range("C223")->{'Value'} = 8635;
$worksheet->Range("A224")->{'Value'} = 8635;
$worksheet->Range("B224")->{'Value'} = 8635;
$worksheet->Range("C224")->{'Value'} = 8635;
$worksheet->Range("A225")->{'Value'} = 8635;
$worksheet->Range("B225")->{'Value'} = 8635;
$worksheet->Range("C225")->{'Value'} = 8635;
$worksheet->Range("A226")->{'Value'} = 8635;
$worksheet->Range("B226")->{'Value'} = 8635;
$worksheet->Range("C226")->{'Value'} = 8635;
$worksheet->Range("A227")->{'Value'} = 8635;
$worksheet->Range("B227")->{'Value'} = 8635;
$worksheet->Range("C227")->{'Value'} = 8635;
$worksheet->Range("A228")->{'Value'} = 8635;
$worksheet->Range("B228")->{'Value'} = 8635;
$worksheet->Range("C228")->{'Value'} = 8635;
$worksheet->Range("A229")->{'Value'} = 8635;
$worksheet->Range("B229")->{'Value'} = 8635;
$worksheet->Range("C229")->{'Value'} = 8635;
$worksheet->Range("A230")->{'Value'} = 8635;
$worksheet->Range("B230")->{'Value'} = 8635;
$worksheet->Range("C230")->{'Value'} = 8635;
$worksheet->Range("A231")->{'Value'} = 8635;
$worksheet->Range("B231")->{'Value'} = 8635;
$worksheet->Range("C231")->{'Value'} = 8635;
$worksheet->Range("A232")->{'Value'} = 8635;
$worksheet->Range("B232")->{'Value'} = 8635;
$worksheet->Range("C232")->{'Value'} = 8635;
$worksheet->Range("A233")->{'Value'} = 8635;
$worksheet->Range("B233")->{'Value'} = 8635;
$worksheet->Range("C233")->{'Value'} = 8635;
$worksheet->Range("A234")->{'Value'} = 8635;
$worksheet->Range("B234")->{'Value'} = 8635;
$worksheet->Range("C234")->{'Value'} = 8635;
$worksheet->Range("A235")->{'Value'} = 8635;
$worksheet->Range("B235")->{'Value'} = 8635;
$worksheet->Range("C235")->{'Value'} = 8635;
$worksheet->Range("A236")->{'Value'} = 8635;
$worksheet->Range("B236")->{'Value'} = 8635;
$worksheet->Range("C236")->{'Value'} = 8635;
$worksheet->Range("A237")->{'Value'} = 8635;
$worksheet->Range("B237")->{'Value'} = 8635;
$worksheet->Range("C237")->{'Value'} = 8635;
$worksheet->Range("A238")->{'Value'} = 8635;
$worksheet->Range("B238")->{'Value'} = 8635;
$worksheet->Range("C238")->{'Value'} = 8635;
$worksheet->Range("A239")->{'Value'} = 8635;
$worksheet->Range("B239")->{'Value'} = 8635;
$worksheet->Range("C239")->{'Value'} = 8635;
$worksheet->Range("A240")->{'Value'} = 8635;
$worksheet->Range("B240")->{'Value'} = 8635;
$worksheet->Range("C240")->{'Value'} = 8635;
$worksheet->Range("A241")->{'Value'} = 8635;
$worksheet->Range("B241")->{'Value'} = 8635;
$worksheet->Range("C241")->{'Value'} = 8635;
$worksheet->Range("A242")->{'Value'} = 8635;
$worksheet->Range("B242")->{'Value'} = 8635;
$worksheet->Range("C242")->{'Value'} = 8635;
$worksheet->Range("A243")->{'Value'} = 8635;
$worksheet->Range("B243")->{'Value'} = 8635;
$worksheet->Range("C243")->{'Value'} = 8635;
$worksheet->Range("A244")->{'Value'} = 8635;
$worksheet->Range("B244")->{'Value'} = 8635;
$worksheet->Range("C244")->{'Value'} = 8635;
$worksheet->Range("A245")->{'Value'} = 8635;
$worksheet->Range("B245")->{'Value'} = 8635;
$worksheet->Range("C245")->{'Value'} = 8635;
$worksheet->Range("A246")->{'Value'} = 8635;
$worksheet->Range("B246")->{'Value'} = 8635;
$worksheet->Range("C246")->{'Value'} = 8635;
$worksheet->Range("A247")->{'Value'} = 8635;
$worksheet->Range("B247")->{'Value'} = 8635;
$worksheet->Range("C247")->{'Value'} = 8635;
$worksheet->Range("A248")->{'Value'} = 8635;
$worksheet->Range("B248")->{'Value'} = 8635;
$worksheet->Range("C248")->{'Value'} = 8635;
$worksheet->Range("A249")->{'Value'} = 8635;
$worksheet->Range("B249")->{'Value'} = 8635;
$worksheet->Range("C249")->{'Value'} = 8635;
$worksheet->Range("A250")->{'Value'} = 8635;
$worksheet->Range("B250")->{'Value'} = 8635;
$worksheet->Range("C250")->{'Value'} = 8635;
$worksheet->Range("A251")->{'Value'} = 8635;
$worksheet->Range("B251")->{'Value'} = 8635;
$worksheet->Range("C251")->{'Value'} = 8635;
$worksheet->Range("A252")->{'Value'} = 8635;
$worksheet->Range("B252")->{'Value'} = 8635;
$worksheet->Range("C252")->{'Value'} = 8635;
$worksheet->Range("A253")->{'Value'} = 8635;
$worksheet->Range("B253")->{'Value'} = 8635;
$worksheet->Range("C253")->{'Value'} = 8635;
$worksheet->Range("A254")->{'Value'} = 8635;
$worksheet->Range("B254")->{'Value'} = 8635;
$worksheet->Range("C254")->{'Value'} = 8635;
$worksheet->Range("A255")->{'Value'} = 8635;
$worksheet->Range("B255")->{'Value'} = 8635;
$worksheet->Range("C255")->{'Value'} = 8635;
$worksheet->Range("A256")->{'Value'} = 8635;
$worksheet->Range("B256")->{'Value'} = 8635;
$worksheet->Range("C256")->{'Value'} = 8635;
$worksheet->Range("A257")->{'Value'} = 8635;
$worksheet->Range("B257")->{'Value'} = 8635;
$worksheet->Range("C257")->{'Value'} = 8635;
$worksheet->Range("A258")->{'Value'} = 8635;
$worksheet->Range("B258")->{'Value'} = 8635;
$worksheet->Range("C258")->{'Value'} = 8635;
$worksheet->Range("A259")->{'Value'} = 8635;
$worksheet->Range("B259")->{'Value'} = 8635;
$worksheet->Range("C259")->{'Value'} = 8635;
$worksheet->Range("A260")->{'Value'} = 8635;
$worksheet->Range("B260")->{'Value'} = 8635;
$worksheet->Range("C260")->{'Value'} = 8635;
$worksheet->Range("A261")->{'Value'} = 8635;
$worksheet->Range("B261")->{'Value'} = 8635;
$worksheet->Range("C261")->{'Value'} = 8635;
$worksheet->Range("A262")->{'Value'} = 8635;
$worksheet->Range("B262")->{'Value'} = 8635;
$worksheet->Range("C262")->{'Value'} = 8635;
$worksheet->Range("A263")->{'Value'} = 8635;
$worksheet->Range("B263")->{'Value'} = 8635;
$worksheet->Range("C263")->{'Value'} = 8635;
$worksheet->Range("A264")->{'Value'} = 8635;
$worksheet->Range("B264")->{'Value'} = 8635;
$worksheet->Range("C264")->{'Value'} = 8635;
$worksheet->Range("A265")->{'Value'} = 8635;
$worksheet->Range("B265")->{'Value'} = 8635;
$worksheet->Range("C265")->{'Value'} = 8635;
$worksheet->Range("A266")->{'Value'} = 8635;
$worksheet->Range("B266")->{'Value'} = 8635;
$worksheet->Range("C266")->{'Value'} = 8635;
$worksheet->Range("A267")->{'Value'} = 8635;
$worksheet->Range("B267")->{'Value'} = 8635;
$worksheet->Range("C267")->{'Value'} = 8635;
$worksheet->Range("A268")->{'Value'} = 8635;
$worksheet->Range("B268")->{'Value'} = 8635;
$worksheet->Range("C268")->{'Value'} = 8635;
$worksheet->Range("A269")->{'Value'} = 8635;
$worksheet->Range("B269")->{'Value'} = 8635;
$worksheet->Range("C269")->{'Value'} = 8635;
$worksheet->Range("A270")->{'Value'} = 8635;
$worksheet->Range("B270")->{'Value'} = 8635;
$worksheet->Range("C270")->{'Value'} = 8635;
$worksheet->Range("A271")->{'Value'} = 8635;
$worksheet->Range("B271")->{'Value'} = 8635;
$worksheet->Range("C271")->{'Value'} = 8635;
$worksheet->Range("A272")->{'Value'} = 8635;
$worksheet->Range("B272")->{'Value'} = 8635;
$worksheet->Range("C272")->{'Value'} = 8635;
$worksheet->Range("A273")->{'Value'} = 8635;
$worksheet->Range("B273")->{'Value'} = 8635;
$worksheet->Range("C273")->{'Value'} = 8635;
$worksheet->Range("A274")->{'Value'} = 8635;
$worksheet->Range("B274")->{'Value'} = 8635;
$worksheet->Range("C274")->{'Value'} = 8635;
$worksheet->Range("A275")->{'Value'} = 8635;
$worksheet->Range("B275")->{'Value'} = 8635;
$worksheet->Range("C275")->{'Value'} = 8635;
$worksheet->Range("A276")->{'Value'} = 8635;
$worksheet->Range("B276")->{'Value'} = 8635;
$worksheet->Range("C276")->{'Value'} = 8635;
$worksheet->Range("A277")->{'Value'} = 8635;
$worksheet->Range("B277")->{'Value'} = 8635;
$worksheet->Range("C277")->{'Value'} = 8635;
$worksheet->Range("A278")->{'Value'} = 8635;
$worksheet->Range("B278")->{'Value'} = 8635;
$worksheet->Range("C278")->{'Value'} = 8635;
$worksheet->Range("A279")->{'Value'} = 8635;
$worksheet->Range("B279")->{'Value'} = 8635;
$worksheet->Range("C279")->{'Value'} = 8635;
$worksheet->Range("A280")->{'Value'} = 8635;
$worksheet->Range("B280")->{'Value'} = 8635;
$worksheet->Range("C280")->{'Value'} = 8635;
$worksheet->Range("A281")->{'Value'} = 8635;
$worksheet->Range("B281")->{'Value'} = 8635;
$worksheet->Range("C281")->{'Value'} = 8635;
$worksheet->Range("A282")->{'Value'} = 8635;
$worksheet->Range("B282")->{'Value'} = 8635;
$worksheet->Range("C282")->{'Value'} = 8635;
$worksheet->Range("A283")->{'Value'} = 8635;
$worksheet->Range("B283")->{'Value'} = 8635;
$worksheet->Range("C283")->{'Value'} = 8635;
$ExcelChart->ChartWizard($worksheet->Range("a2:C283"));
$ExcelChart->{'Type'} = $ChartTypeVal;
$ExcelChart->{'HasTitle'} = 1;
$ExcelChart->ChartTitle->{'Text'} = "Closure Profile Graph (Number of
Pieces)";
$ExcelChart->{'PlotBy'} = 0;


--------------40AB6A63A36B17BE4A006040
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Taylor Frith
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Taylor Frith
n:              Frith;Taylor
org:            VMASC
adr;dom:        7000 College Dr.;;;Suffolk;VA;23435;
email;internet: tfrith@vmasc.odu.edu
title:          Research Assistant
tel;work:       (757)686-6209
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------40AB6A63A36B17BE4A006040--




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

Date: 12 Jul 98 21:33:47 GMT (Last modified)
From: Perl-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin) 
Subject: Special: Digest Administrivia (Last modified: 12 Mar 98)
Message-Id: <null>


Administrivia:

Special notice: in a few days, the new group comp.lang.perl.moderated
should be formed. I would rather not support two different groups, and I
know of no other plans to create a digested moderated group. This leaves
me with two options: 1) keep on with this group 2) change to the
moderated one.

If you have opinions on this, send them to
perl-users-request@ruby.oce.orst.edu. 


The Perl-Users Digest is a retransmission of the USENET newsgroup
comp.lang.perl.misc.  For subscription or unsubscription requests, send
the single line:

	subscribe perl-users
or:
	unsubscribe perl-users

to almanac@ruby.oce.orst.edu.  

To submit articles to comp.lang.perl.misc (and this Digest), send your
article to perl-users@ruby.oce.orst.edu.

To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.

To request back copies (available for a week or so), send your request
to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
where x is the volume number and y is the issue number.

The Meta-FAQ, an article containing information about the FAQ, is
available by requesting "send perl-users meta-faq". The real FAQ, as it
appeared last in the newsgroup, can be retrieved with the request "send
perl-users FAQ". Due to their sizes, neither the Meta-FAQ nor the FAQ
are included in the digest.

The "mini-FAQ", which is an updated version of the Meta-FAQ, is
available by requesting "send perl-users mini-faq". It appears twice
weekly in the group, but is not distributed in the digest.

For other requests pertaining to the digest, send mail to
perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
sending perl questions to the -request address, I don't have time to
answer them even if I did know the answer.


------------------------------
End of Perl-Users Digest V8 Issue 3348
**************************************

home help back first fref pref prev next nref lref last post