tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786d3a4c-6b71-4ba9-8675-595798c99e63
Sheet: Sheet1

GRANT CLOSEOUT PACKAGE TRANSMITTAL SHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
To: | [NAME], Senior Grant Manager
 | Vermont Department of Labor
 | [NAME] 488
 | Montpelier, VT 05601-0488
From: | ____________________________________________________________________
 | ____________________________________________________________________
 | ____________________________________________________________________
 | ____________________________________________________________________
Grant Number | ________________________________________________
Grant Period | ________________________________________________
As requested, I the grantee, have taken actions related to the Closeout of the above referenced grant and I am enclosing the required documents as follows:
 | Submitted |  | Received |  | Documents
 |  |  |  |  | Financial Reconciliation Worksheet
 |  |  |  |  | Final Property Inventory Certification
 |  |  |  |  | Closeout Tax Certification
 |  |  |  |  | Grantees Release (with Signature)
 |  |  |  |  | Other (List)
FINANCIAL RECORD RETENTION
Financial records must be retained for 3 years from the date of your final Financial Closeout Package.
Unresolved issues (which may include but are not limited to audit findings, litigation, and bankruptcy) would necessitate a longer retention period. The 3-year clock would be adjusted after resolution of the issue and/or submission of a revised closeout package.
 |  |  |  |  |  | Page 1 of 6
 |  |  |  |  |  | 2007-08-01 00:00:00
Spreadsheet: 784952d1656026655-descending-ranking-based-on-two-scoring-sessions-descending-ranking-based-on-two-scoring-sessions
Sheet: Sheet1

 |  |  |  |  | Descending
 | Name | Score 1 | Score 2 |  | Final Rank |  |  | the ranking should be like this
 | A | 86459 | 86591 |  |  |  |  | 2
 | B | 86691 | 86816 |  |  |  |  | 4
 | C | 86795 | 86525 |  |  |  |  | 3
 | D | 86856 | 87178 |  |  |  |  | 5
 | E | 86941 | 86983 |  |  |  |  | 7
 | F | 86963 | 87048 |  |  |  |  | 8
 | G | 86993 | 86873 |  |  |  |  | 6
 | H | 87043 | 86363 |  |  |  |  | 1
 | I | 87162 | 87419 |  |  |  |  | 10
 | J | 87202 | 87116 |  |  |  |  | 9
no. | name | score (sorted) | rank result
1 | H-Score 2 | 86363 | 1
2 | A-Score 1 | 86459 | 2
3 | C-Score 2 | 86525 | 3
4 | A-Score 2 | 86591 | skip
5 | B-Score 1 | 86691 | 4
6 | C-Score 1 | 86795 | skip
7 | B-Score 2 | 86816 | skip
8 | D-Score 1 | 86856 | 5
9 | G-Score 2 | 86873 | 6
10 | E-Score 1 | 86941 | 7
11 | F-Score 1 | 86963 | 8
12 | E-Score 2 | 86983 | skip
13 | G-Score 1 | 86993 | skip
14 | H-Score 1 | 87043 | skip
15 | F-Score 2 | 87048 | skip
16 | J-Score 2 | 87116 | 9
17 | I-Score 1 | 87162 | 10
18 | D-Score 2 | 87178 | skip
19 | J-Score 1 | 87202 | skip
20 | I-Score 2 | 87419 | skip
Spreadsheet: 715025d1611513693-count-of-last-number-from-an-array-between-two-values-counttest
Sheet: Sheet1

 | Count of values between 0.5 and 2.5 among the last 3 instances of each | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00
Alpha |  | 4 |  |  | 3 |  | 4 | 2 |  | 3 |  |  | 2
Beta |  | 0 |  |  | 2 |  | 1 | 3 |  | 0
Gamma |  | 2 |  | 3 |  | 2 |  | 0 | 1 |  | 3 |  |  |  | 1
Delta |  | 1 |  | 1 |  | 2 |  | 3 | 3 |  | 4 |  |  |  | 3
Epsilon |  | 3 |  | 0 |  | 1 |  | 2 | 0 |  | 1 |  |  |  | 2
Zeta |  | 3 |  | 0 |  | 2 |  | 0 | 0 |  | 0 |  |  |  | 2
Eta |  | 0 |  | 3 |  | 7 |  |  | 2 |  | 1 |  | 1
Theta |  | 2 |  | 5 |  | 5 |  |  | 5 |  | 4 |  | 2
Iota |  | 1 |  | 1 |  | 0 |  |  | 1 |  | 0
Kappa |  | 3 |  | 2 |  | 2 |  |  | 3 |  | 1 |  | 2
Lamda |  | 1 |  | 1 |  | 1 |  |  | 3 |  |  |  | 2
Spreadsheet: 695953d1600491964-combining-the-contents-of-two-tables-or-sets-of-data-merge2_identicaltables
Sheet: Sheet1

Column1 | Column2 |  | Column1 | Column2 |  | Column1 | Sum
A | 5 |  | A | 56 |  | A | 61
B | 4 |  | B | 6 |  | B | 10
C | 1 |  | C | 3 |  | C | 4
D | 135 |  | D | 7 |  | D | 142
E | 23 |  | E | 3 |  | E | 26
F | 4 |  | F | 35 |  | F | 39
G | 2 |  | G | 2 |  | G | 4
H | 4 |  | H | 45 |  | H | 49
I | 35 |  | I | 45 |  | I | 80
J | 35 |  | J | 686 |  | J | 721
K | 15 |  | K | 34 |  | K | 49
Spreadsheet: 6e62e1e7-bf47-4f67-b67a-6f3df56efdb6
Sheet: Sheet1

CNJC 2012 Show-n-Sell Cases Only Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Contact Name |  |  |  |  | District |  | Your Show-N-Sell order can not exceed more than 5% retail of your total 2011 Show-N-Sell and [NAME].  You can get that number from your District Executive.  If you are ordering Chocolate products you must sign the non-returnable waiver form.
E-mail |  |  |  |  | Pack #
Phone |  |  |  |  | Troop #
[NAME] |  |  |  |  | Crew #
 |  |  |  |  | Team # |  | Save, e-mail order form to [EMAIL] no later than:  August 27th.
Please refer to www.cnjcscouting.org for Council's Check Return Policy.
 | [NAME] |  |  | # [NAME]'s in Case |  | CASE Qty Needed |  |  |  | Cost Per Case | Retail Cost
 | Chocolate Lovers Collection Tin* |  |  | 1 |  |  |  | Reminder - you are entering the number of CASES you are ordering on this form! |  | 55 | 0
 | Sweet & Savory* |  |  | 1 |  |  |  |  |  | 40 | 0
C | Cheese Lover's |  |  | 1 |  |  |  |  |  | 30 | 0
 | White Chocolatey Pretzels Tin* |  |  | 6 |  |  |  |  |  | 150 | 0
 | Kettle Corn 18-Pack |  |  | 6 |  |  |  |  |  | 132 | 0
 | 18-Pack Unbelieveable Butter |  |  | 6 |  |  |  |  |  | 108 | 0
 | 18-Pack Butter Light |  |  | 6 |  |  |  |  |  | 108 | 0
 | Chocolate Triple Delight* |  |  | 8 |  |  |  |  |  | 144 | 0
 | Caramel Corn Almond/Cashew/Pecan |  |  | 8 |  |  |  |  |  | 144 | 0
 | 7 oz Cheddar Cheese Corn |  |  | 8 |  |  |  |  |  | 96 | 0
 | 11 oz. Caramel Corn |  |  | 12 |  |  |  |  |  | 120 | 0
*Chocolate Product Not Returnable/You must submit signed waiver. |  |  |  |  |  |  |  | Total Retail Cost |  |  | 0
For Office Staff Only |  |  |  | Entered on |  |  |  |  | Entered by
 | Areas in grey are not necessary to complete to place order.  However, they will populate if you enter data in Excel.
Spreadsheet: 43384d1242054016-excel-2007-pivot-table-refresh-data-book-1
Sheet: Pivot

 |  |  |  |  |  |  |  |  |  | Values
Division | Reg No | SLM # | Sls Name | Cust No | Customer Name | Cust PO No | Inv No | Item No | Inv Date | Sum of Commission Sales | Sum of New Commission Amount
SER | 30 | SLM # 2 | SLM # 2NAME | 12345 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 111.68
 |  |  |  | 123456 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 22336.16 | 446.72
 |  |  |  | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 27920.2 | 558.4000000000001
 |  |  | SLM # 2NAME Total |  |  |  |  |  |  | 55840.4 | 1116.8
Grand Total |  |  |  |  |  |  |  |  |  | 55840.4 | 1116.8
Spreadsheet: 5484962d-7538-40a8-9327-bbba503783f7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DFIR | Test | DFIR | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
DFIR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DFIR | Result | DFIR | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7310-6
Spreadsheet: 736286d1623458943-calculating-running-average-cost-example_avg_cost
Sheet: Sheet1

Limits:
Trade Symbol | Transaction | Date | [NAME] | Quantity | Price | Total Cost | Buy Fees | Sell Fees |  | [NAME] | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L
 | Buy | 2021-02-22 00:00:00 |  | 3.514923 | 14.21 |  | 0 | 0
 |  |  |  | 1.95554 | 12.8 |  | 0 | 0
 | Buy | 2021-02-23 00:00:00 |  | 2.121327 | 11.78 |  | 0 | 0
 | Buy | 2021-03-24 00:00:00 |  | 374.242645 | 13.45 |  | 0 | 0
 | Sell | 2021-03-29 00:00:00 | Short | -381.834442 | 13.34 |  | 0 | 0
 | Buy | 2021-04-17 00:00:00 |  | 13.380624 | 37.72 |  | 0 | 0
 |  |  |  | 12.706329 | 39.39 |  | 0 | 0
 | Buy | 2021-04-27 00:00:00 |  | 28.600846 | 35.18 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 74.626678 | 67.52 |  | 0 | 0
 |  |  |  | 270.208195 | 74.56 |  | 0 | 0
 | Sell | 2021-05-04 00:00:00 | Short | -399.522672 | 78.52 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 179.734944 | 84.04 |  | 0 | 0
 |  | 2021-05-05 00:00:00 |  | 49.622456 | 101.4 |  | 0 | 0
 |  |  |  | 246.20782 | 102.55 |  | 0 | 0
 |  |  |  | 165.37101 | 103.4 |  | 0 | 0
 | Sell | 2021-05-05 00:00:00 | Short | -640.93623 | 104.18 |  | 0 | 0
 | Buy | 2021-05-05 00:00:00 |  | 30.301633 | 99.03 |  | 0 | 0
 |  | 2021-05-06 00:00:00 |  | 276.819944 | 145.41 |  | 0 | 0
 | Sell | 2021-05-06 00:00:00 | Short | -307.121577 | 168.49 |  | 0 | 0
 | Buy | 2021-05-06 00:00:00 |  | 277.1079 | 182.23 |  | 0 | 0
 |  |  |  | 138.149505 | 182.77 |  | 0 | 0
 | Sell | 2021-05-08 00:00:00 | Short | -107.381606 | 127.43 |  | 0 | 0
Totals:
Average Price:
Spreadsheet: 774361d1648426077-calculating-due-installment-dates-based-on-duration-number-of-instalments-qoutation-creator-eba
Sheet: Calculation

 |  |  |  |  |  |  |  |  |  |  |  | Yearly contract
 |  |  |  |  |  |  |  | first payment |  |  |  | 2 | 6
 |  |  |  |  |  |  |  | VAT |  |  |  | 3 | 4
 |  |  |  |  |  |  |  | Municipality charges |  |  |  | 4 | 3
 |  |  |  |  |  |  |  | security |  |  |  | 6 | 2
 |  |  |  |  |  |  |  | charges fees
 |  |  |  |  |  |  |  | total
Spreadsheet: 00ff0bbb-7eeb-4a74-b13f-bb0d246df010
Sheet: Adults

BIKE RENTAL INFORMATION
Group Name:
Event Date:
Time of Arrival:
Adults:
Changes |  |  | General Information | Guide Information |  |  |  |  |  | Rentals Information
 |  |  |  | Rider Type
Add | Delete |  | Name | Novice | Intermediate | Adv/Expert | Gender | Age | Height (Feet/Inches) or (cm) |  | Weight (lbs) or (kg)
EXAMPLE |  |  | [NAME] |  | x |  | M | 37 | 5 | 6 | 125
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
Spreadsheet: kate_symes__18370__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-24 00:00:00 |  | 243.16 | 31536 | 120.55 | 14744
 | 2001-04-23 00:00:00 |  | 198.65 | 24160 | 106.45 | 10872
 | 2001-04-22 00:00:00 |  |  |  |  |  | 106.45 | 32616
 | 2001-04-21 00:00:00 |  | 168.17 | 28800 | 95.7 | 15664
 | 2001-04-20 00:00:00 |  | 168.28 | 28640 | 95.7 | 15664
 | 2001-04-19 00:00:00 |  | 226.06 | 24784 | 106.19 | 15024
 | 2001-04-18 00:00:00 |  | 226.06 | 24784 | 106.19 | 15024
 | 2001-04-17 00:00:00 |  | 226.16 | 22784 | 106.19 | 15024
 | 2001-04-16 00:00:00 |  | 228.61 | 26144 | 118.81 | 10960
 | 2001-04-15 00:00:00 |  |  |  |  |  | 118.69 | 32280
 | 2001-04-14 00:00:00 |  | 156.91 | 19840 | 95.93 | 14120
 | 2001-04-13 00:00:00 |  | 156.91 | 19840 | 95.93 | 14120
 | 2001-04-12 00:00:00 |  | 176.32 | 27632 | 107.12 | 14896
 | 2001-04-11 00:00:00 |  | 178.5 | 21120 | 115.45 | 16912
 | 2001-04-10 00:00:00 |  | 181.91 | 26368 | 109.27 | 11712
 | 2001-04-09 00:00:00 |  | 157.87 | 22000 | 113.76 | 15928
 | 2001-04-08 00:00:00 |  |  |  |  |  | 113.77 | 45888
 | 2001-04-07 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
Spreadsheet: 869651d1716262795-rank-list-rank
Sheet: Sheet1

Name | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS | 1ST HIGH
[NAME] | 70 | 15 | 35 | 25 | 70 | 55 | 75 | 30 | 40 | 35 | VLBM
ANDRIAN | 55 | 15 | 35 | 25 | 70 | 55 | 75 | 90 | 40 | 90 | EKSIS
ROSLAN | 45 | 25 | 40 | 35 | 15 | 60 | 85 | 90 | 70 | 90 | INTER
Name | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS | 1ST HIGH
[NAME] | 70 | 15 | 35 | 25 | 70 | 55 | 75 | 30 | 40 | 35
ANDRIAN | 55 | 15 | 35 | 25 | 70 | 55 | 75 | 90 | 40 | 90
ROSLAN | 45 | 25 | 40 | 35 | 15 | 60 | 85 | 90 | 70 | 90
Hi, what is the appropriate formula to choose the highest result. the condition to choose the highest result is read from left to right even if the results obtained are the same. the highest result in the 1st high column is not recorded with a number but with the name of the result
Spreadsheet: 53618d1253560107-multiple-criterias-in-spreadsheet-example-of-what-is-required
Sheet: Sheet1

MASTER LIST |  |  |  |  |  | CLIENT LIST
ID | Acct # | Amount | List_name |  |  | ID | Acct # | Amount
11111 | AAA | 500 | Master |  |  | 11111 | AAA | 1000
11111 | AAA | 1000 | Master |  |  | 11111 | AAA | 500
22222 | BBB | 5000 | Master |  |  | 22222 | BBB | 5000
22222 | ZZZ | 2500 | Master |  |  | 22222 | ZZZ | 2500
33333 | CCC | 500 | Master |  |  | 33333 | CCC | 500
44444 | DDD | 2500 | Master |  |  | 44444 | DDD | 2500
44444 | DDD | 1500 | Master |  |  | 44444 | EEE | 1500
55555 | GGG | 1500 | Master |  |  | 66666 | FFF | 200
55555 | GGG | 1500 | Master |  |  | 66666 | FFF | 200
Summary Totals |  | 16500 | Master |  |  |  |  | 13900 |  | 2600
 |  |  |  |  |  |  |  |  |  |  | [NAME] should explain what is the difference and why.
Basically, at the end of the day, I need a summary and details spreadsheet providing me with the following issues:  Master List Amt Total vs. Client List Amt Total -- The difference broken down in a detail spreadsheet(s) --- Could be something like [Perfect Match Spreadsheet] and [Amounts don't match] [ID and amounts match but Acct # is different][Remaining members from Master List] and [Remaining members from Client List]
As an added note, I've tried a VLOOKUP function, but doesn't seem to be the right way of doing this… see example of what happens on the next sheet.  Please help.  I've been working on this for 5 days now..
Spreadsheet: 120113d1314981198-separate-data-in-a-cell-separate-example-01
Sheet: Sheet1

1500 W Southern Ave   -   Bucyrus,  OH   44820
5128 Lincoln Highway East   -   Bucyrus,  OH   44820
East Bucyrus Street and Route 181   -   Crestline,  OH 42440
545 [NAME],  OH   44833
119 East Mansfield   -   New Washington,  OH   44854
1874 E [NAME]Bucyrus,  OH   44820
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: BGC-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BOSTON GAS
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 51815d1251407881-using-name-ranges-to-group-customers-into-different-pricing-brackets-book2
Sheet: Sheet1

Blackpool | JLP
colchester | JLP | JLP | 1
plymouth | JLP | [NAME] | 2
london | JLP | Sil | 3
norwich | JLP | Ind | 1.5
leeds | JLP
liverpool | JLP
manchester | JLP
ipswich | JLP
fred | JLP
[NAME] | JLP
bill | JLP
[NAME] | JLP
[NAME] | [NAME]
[NAME] | Sil
MBD | Ind
asp | Ind | Customer | MBD |  |  | #N/A
ted | Ind
bob | Ind
stephen | Ind
[NAME] | Ind | price | 123
[NAME] | Ind
wine | Ind
womwn | Ind
Spreadsheet: 218865d1362596215-excel-magic-regression-with-intercept-specified-regression
Sheet: Sheet1

Standard reression intercept not forced |  |  |  |  |  |  |  |  | Intercept forced through 0.2
 | x | y
 | 1 | 0.45 |  |  |  |  |  |  |  | x | y
 | 2 | 0.7 |  |  |  |  |  |  |  | 1 | 0.45
 | 3 | 0.8500000000000003 |  |  |  |  |  |  |  | 2 | 0.7
 |  |  |  |  |  |  |  |  |  | 3 | 0.8500000000000003
X | 1 | 1 | 1 | Y | 0.45
 | 1 | 2 | 4 |  | 0.7 |  |  |  | X | 1 | 1 |  | Y | 0.25
 | 1 | 3 | 9 |  | 0.85 |  |  |  |  | 2 | 4 |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 3 | 9 |  |  | 0.65
X' | 1 | 1 | 1
 | 1 | 2 | 3 |  |  |  |  |  | X' | 1 | 2 | 3
 | 1 | 4 | 9 |  |  |  |  |  |  | 1 | 4 | 9
X'*X
 |  |  |  |  |  |  |  |  | X'*X
(X'*X)^-1 |  |  |  |  | X'Y
 |  |  |  |  |  |  |  |  | (X'*X)^-1 |  |  |  |  | X'Y
Coefficients |  |  |  |  |  |  |  |  | Coefficients | intercept is 0.2 as that is where you have forced it to be
Spreadsheet: 0622e48c-35a1-49d7-8869-fb55bf44f83f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
 |  | 2008-05-01 00:00:00 |  | 2008-06-01 00:00:00 |  | 2008-07-01 00:00:00 |  | 2008-08-01 00:00:00 |  | 2008-09-01 00:00:00 |  | 2008-10-01 00:00:00 |  | 2008-11-01 00:00:00 |  | 2008-12-01 00:00:00 |  | 2009-01-01 00:00:00 |  | 2009-02-01 00:00:00 |  | 2009-03-01 00:00:00 |  | 2009-06-01 00:00:00
Spreadsheet: 809382d1671050593-formula-to-look-ahead-based-on-known-lead-time-sample-mrp
Sheet: Sheet1

 |  |  | Customer | Sub Assemblies
Week | Beg | End | Order | #1 | #2 | #3
Parts per Top Assembly |  |  |  | 2 | 1 | 3
Lead Time (Weeks) |  |  |  | 3 | 4 | 5
1 | 2023-01-01 00:00:00
 |  |  | 10
Spreadsheet: 700106d1602958636-instantaneous-value-at-each-hour-from-start-and-end-time-power
Sheet: Sheet1

 | Sl.NO | Name  of  Appliance | Power (W) | Time of  Start | Time of  End | Quantity |  |  |  | Time
 | 1 | Lamp | 20 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 30
 | 2 | PC | 80 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 12
 | 3 | Moniter | 155 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 4
 | 4 | Security Camera | 40 | 2020-10-16 01:00:00 | 2020-10-16 12:59:00 | 10
Spreadsheet: drew_fossum__8992__Fixed3
Sheet: Avista_2_Expired

[NAME]
FUEL HEDGING BOOK
Avista_2
DEAL EXPIRED
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
1998-10-01 00:00:00 |  | Avista
1998-11-01 00:00:00 |  | Avista |  |  |  | 1.92
1998-12-01 00:00:00 |  | Avista |  |  |  | 1.99
1999-01-01 00:00:00 |  | Avista |  |  |  | 1.73
1999-02-01 00:00:00 |  | Avista |  |  |  | 1.66
1999-03-01 00:00:00 |  | Avista |  |  |  | 1.54
1999-04-01 00:00:00 |  | Avista |  |  |  | 1.66
1999-05-01 00:00:00 |  | Avista |  |  |  | 2.16
1999-06-01 00:00:00 |  | Avista |  |  |  | 2.08
1999-07-01 00:00:00 |  | Avista |  |  |  | 2.17
1999-08-01 00:00:00 |  | Avista |  |  |  | 2.46
1999-09-01 00:00:00 |  | Avista |  |  |  | 2.78
1999-10-01 00:00:00 |  | Avista |  |  |  | 2.42
1999-11-01 00:00:00 |  | Avista |  |  |  | 2.87
1999-12-01 00:00:00 |  | Avista |  |  |  | 2.08
 |  |  |  |  |  | TW Index
1998-10-01 00:00:00 |  | Over-retention |  |  |  | 1.78
1998-11-01 00:00:00 |  | Over-retention |  |  |  | 1.99
1998-12-01 00:00:00 |  | Over-retention |  |  |  | 1.74
1999-01-01 00:00:00 |  | Over-retention |  |  |  | 1.73
1999-02-01 00:00:00 |  | Over-retention |  |  |  | 1.63
1999-03-01 00:00:00 |  | Over-retention |  |  |  | 1.59
1999-04-01 00:00:00 |  | Over-retention |  |  |  | 1.94
1999-05-01 00:00:00 |  | Over-retention |  |  |  | 2.06
1999-06-01 00:00:00 |  | Over-retention |  |  |  | 2.07
1999-07-01 00:00:00 |  | Over-retention |  |  |  | 2.11
1999-08-01 00:00:00 |  | Over-retention |  |  |  | 2.51
1999-09-01 00:00:00 |  | Over-retention |  |  |  | 2.36
1999-10-01 00:00:00 |  | Over-retention |  |  |  | 2.62
1999-11-01 00:00:00 |  | Over-retention |  |  |  | 2.17
1999-12-01 00:00:00 |  | Over-retention |  |  |  | 2.24
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 696488d1600852701-total-and-percentage-of-another-value-new-microsoft-excel-worksheet
Sheet: Sheet1

Year | Total Cases | In Warranty Cases | Out Warranty Cases | Unknown Warranty Cases | % In Warranty  Cases | % Out Warranty Cases | % Unknown Warranty Cases |  | Revised In Warranty Cases | Revised Out Warranty Cases | Revised In Warranty Cases % | [NAME] Warranty Cases %
2013 | 26 | 12 | 4 | 10
2014 | 51 | 20 | 11 | 20
2015 | 123 | 64 | 19 | 40
2016 | 275 | 146 | 49 | 80
2017 | 397 | 190 | 99 | 108
2018 | 739 | 299 | 227 | 213
2019 | 949 | 409 | 368 | 172
2020 | 486 | 204 | 199 | 83