tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827938d1683128184-calculate-sales-price-to-achieve-margin-margin-calculation
Sheet: Sheet2

 | Sale price |  | 22
 | Cost price |  | 19
 | Gross margin
 | VAT = 1/6 of profit | 0.1666666666666667
 | Net margin
 | (SP-CP-VAT) | = | NM
 | => (SP-CP-VAT)/SP | = | NM%
 | => SP-CP-VAT | = | SP*NM%
 | VAT=(SP-CP)*1/6
 |  |  |  |  |  |  | For ExcelForum
 | SP-CP-VAT | = | SP*NM% |  |  |  | SP-CP-VAT = SP*NM%
 | => SP-CP-(SP-CP)*1/6 | = | SP*NM% |  |  |  | => SP-CP-(SP-CP)*1/6 = SP*NM%
 | => SP-CP-SP*1/6+CP*1/6 | = | SP*NM% |  |  |  | => SP-CP-SP*1/6+CP*1/6 = SP*NM%
 | => SP*(1-1/6)-CP*(1-1/6) | = | SP*NM% |  |  |  | => SP*(1-1/6)-CP*(1-1/6) = SP*NM%
 | => SP*(1-1/6)-SP*NM% | = | CP*(1-1/6) |  |  |  | => SP*(1-1/6)-SP*NM% = CP*(1-1/6)
 | => SP*(1-1/6-NM%) | = | CP*(1-1/6) |  |  |  | => SP*(1-1/6-NM%) = CP*(1-1/6)
 | => SP | = | CP*(1-1/6)/(1-1/6-NM%) |  |  |  | => SP = CP*(1-1/6)/(1-1/6-NM%)
 | Target NM% | = | 0.2
 | SP | =
Spreadsheet: 831314d1685545404-order-sheet-for-supplies-for-my-special-education-class-supplies
Sheet: Template

# | PRODUCT DESCRIPTION | Vendor's Name | VENDOR PROD. CODE | UNIT PRICE | QTY | TOTAL | DDSB PROD. CODE
1
Spreadsheet: 715246d1611632714-link-dropdown-in-c6-c9-to-dropdown-in-column-b2-main-dropdown-dropdown_linkcell_sample
Sheet: Names

Last Name | First Name | Name |  | Let | Name | L1 | L2 | L3 | Name1 |  | Okay | Out
Abdelnour | Habig |  |  |  | Abdelnour, [NAME] |  |  |  |  |  | Okay
Abdelrahman | Habiger |  |  |  | Abdelrahman, Habiger |  |  |  |  |  | [NAME]
Macchi | Hable |  |  |  | Abdou, Hachey
Macchia | Haby |  |  |  | [NAME], [NAME]
Macchio | Hach |  |  |  | Abdulla, [NAME]
Macchione | Hache |  |  |  | [NAME], [NAME]
Abdou | Hachey |  |  |  | [NAME], Fager
Abdul | Faga |  |  |  | [NAME], [NAME]
Abdulla | Fagan |  |  |  | Abed, [NAME]
[NAME] | Fagen |  |  |  | Abee, Yanagi
[NAME] | Fager |  |  |  | [NAME], [NAME]
[NAME] | Yampolsky |  |  |  | Abeles, [NAME]
Abed | Yan |  |  |  | Abell, Fago
Abee | Yanagi |  |  |  | Abella, Faaborg
[NAME] | Yanak |  |  |  | Macchi, Hable
Sabio | Faggart |  |  |  | Macchia, [NAME]
[NAME] | Fagin |  |  |  | Macchio, Hach
Sabiston | Yanke |  |  |  | Macchione, Hache
Sablan | Yankee |  |  |  | Sabio, Faggart
Sable | Yankey |  |  |  | Sabir, Fagin
Abeles | [NAME] |  |  |  | Sabiston, Yanke
Abell | Fago |  |  |  | Sablan, Yankee
Abella | Faaborg |  |  |  | Sable, Yankey
Spreadsheet: 78024d1278488591-sum-only-one-instance-of-duplicate-book1
Sheet: open_purchase_orders-2010-07-07

Item | SOH | $ [NAME]. | Change
R1010 | 9324 | 0.42 | 3916.08
R1010 | 9324 | 0.33 | 3076.92
R1011 | 2660 | 0.36 | 957.5999999999999
R1011 | 2660 | 0.36 | 957.5999999999999
R1012 | 160 | 0.48 | 76.8
R1012 | 160 | 0.55 | 88
R1012 | 160 | 0.58 | 92.8
Objective - subtotal column D but only sum one instance of a duplicate
ie, for R1011 only include one lot of 958 because the SOH & $[NAME] apply twice
but if an item is duplicated but the $[NAME] is different, include only the sum of the largest [NAME] (.58 * 160)
So the answer would be,  3916 + 958 + 93 = $4967
Spreadsheet: 702ca253-9d37-46f9-a96c-69109844c1d6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8897 | 68545 | Tatiana | Bregeda | RUS | 73 | [NAME] | 00:00:33 | 00:45:43 | 00:00:00 | 00:33:14 | 1 | 01:51:22
8897 | 28253 | Margarita | Ovsyannikva | RUS | 71 | [NAME] | 00:00:28 | 00:46:48 | 00:00:43 | 00:34:49 | 2 | [NAME]
8897 | 46060 | Ilaria | Titone | ITA | 72 | [NAME] | 00:00:41 | [NAME] | 00:01:15 | 00:44:06 | 3 | 02:13:45
Spreadsheet: 285909d1387912025-i-guess-theres-some-error-or-mistake-in-calculation-by-excel-inz-hours
Sheet: Inzimaam Akram

Salary For
Name: [NAME] |  |  | Month Of: September 2013 |  |  |  | Duty Hrs.: | 15
 |  |  |  |  |  |  | Salary: | 14000
[NAME]
Date | Time In | Time Out | Total Hours |  | Fine/Advance | Remarks
2013-09-01 00:00:00 | 09:00:00 | 1900-01-01 01:00:00
2013-09-02 00:00:00 | 09:00:00 | 1900-01-01 00:56:00
2013-09-03 00:00:00 | 10:02:00 | 1900-01-01 01:15:00
2013-09-04 00:00:00 | 09:00:00 | 1900-01-01 01:00:00
2013-09-05 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | Leave
2013-09-06 00:00:00 | 09:00:00 | 1900-01-01 00:55:00
2013-09-07 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  | 1300 | [NAME] # 1227 / No Time Out
2013-09-08 00:00:00 | 10:15:00 | 1900-01-01 00:00:00 |  |  |  | No Time Out
2013-09-09 00:00:00 | 00:00:00 | 1900-01-01 00:00:00 |  |  |  | Absent
2013-09-10 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | No Time In/Out
2013-09-11 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | No Time In/Out
2013-09-12 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | No Time In/Out
2013-09-13 00:00:00 | 09:05:00 | 1900-01-01 01:23:00
2013-09-14 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | No Time In/Out
2013-09-15 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | Leave
2013-09-16 00:00:00 | 13:30:00 | 1900-01-01 01:00:00
2013-09-17 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  | 130 | No Time In/Out / Bill # 3421
2013-09-18 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | Leave
2013-09-19 00:00:00 | 09:00:00 | 1900-01-01 00:00:00 |  |  |  | No Time Out
2013-09-20 00:00:00 | 00:00:00 | 00:00:00 |  |  |  | Absent
2013-09-21 00:00:00 | 00:00:00 | 00:00:00 |  |  |  | Absent
2013-09-22 00:00:00 | 10:30:00 | 1900-01-01 00:00:00 |  |  |  | No Time Out
2013-09-23 00:00:00 | 10:15:00 | 1900-01-01 01:00:00 |  |  | 1100 | *WAIVED*Longer [NAME]Bill # 5309
2013-09-24 00:00:00 | 09:20:00 | 1900-01-01 01:00:00
2013-09-25 00:00:00 | 09:00:00 | 1900-01-01 00:50:00
2013-09-26 00:00:00 | 11:30:00 | 1900-01-01 00:48:00
2013-09-27 00:00:00 | 09:00:00 | 1900-01-01 01:00:00 |  |  | 50 | Generator
2013-09-28 00:00:00 | 09:50:00 | 1900-01-01 01:07:00
2013-09-29 00:00:00 | 09:00:00 | 1900-01-01 00:31:00
2013-09-30 00:00:00 | 09:00:00 | 1900-01-01 00:35:00 |  |  | 4530 | As Advance From Salary/Bill # 6854
 | Total Minutes |  | Total Min. Spent |  | Total Amount
 | Duty Minutes Required
 | Calculations
 | Current Salary/Per Month
 | Salary Per Day
 | Salary Per Hour
 | Salary Per Min
 | Deductions
 | Fine/Advance
 | Late Join/Absent Fine/After Quitting
 | Payable
 | Net Salary
Spreadsheet: f4d5012a-8043-4dbe-9ec4-cc0a00a8ab6a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38664593 | 2013-11-23 02:08:05 | AXIS | 1 | 6 | 4 | 120834 | foirallail | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38664780 | 2013-11-23 02:31:10 | ALLIES | 0 | 2 | 6 | 120834 | foirallail | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38672856 | 2013-11-23 17:17:09 | ALLIES | 1 | 6 | 4 | 475647 | Steelie | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38673090 | 2013-11-23 17:30:15 | AXIS | 1 | 6 | 2 | 475647 | Steelie | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
38744666 | 2013-11-28 15:50:19 | AXIS | 0 | 2 | 6 | 24638 | cem0007 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38744933 | 2013-11-28 16:09:46 | ALLIES | 1 | 6 | 3 | 24638 | cem0007 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38748759 | 2013-11-28 21:33:45 | AXIS | 1 | 7 | 2 | 251270 | Mastergo - Team du Sud | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
38749225 | 2013-11-28 22:09:09 | ALLIES | 1 | 7 | 5 | 251270 | Mastergo - Team du Sud | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
38771414 | 2013-11-30 14:55:35 | ALLIES | 1 | 6 | 3 | 600568 | toftof72 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38771699 | 2013-11-30 15:13:42 | AXIS | 0 | 2 | 6 | 600568 | toftof72 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38792217 | 2013-12-01 21:44:07 | ALLIES | 0 | 3 | 6 | 506159 | Hurletout | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38792614 | 2013-12-01 22:04:17 | AXIS | 1 | 6 | 3 | 506159 | Hurletout | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38829957 | 2013-12-04 15:29:14 | ALLIES | 0 | 4 | 6 | 1453397 | Raoul35 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38830173 | 2013-12-04 15:46:04 | AXIS | 1 | 6 | 1 | 1453397 | Raoul35 | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38841188 | 2013-12-05 08:54:07 | ALLIES | 0 | 5 | 6 | 782295 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38841373 | 2013-12-05 09:09:25 | AXIS | 1 | 6 | 1 | 782295 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38844755 | 2013-12-05 17:30:42 | ALLIES | 0 | 4 | 6 | 15675 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38845064 | 2013-12-05 17:51:55 | AXIS | 1 | 6 | 2 | 15675 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38861825 | 2013-12-06 22:23:27 | ALLIES | 0 | 5 | 6 | 1051741 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
38862176 | 2013-12-06 22:40:29 | AXIS | 0 | 0 | 6 | 1051741 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
Spreadsheet: 830551d1684968986-payment-schedule-based-on-term-60-84mo-etc-book2-8-
Sheet: Blad1

 |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  | 2023-06-30 00:00:00
Account | Division | Quote | Quote Description | Purchase Cost | MSA- Monthly Payment Installment | Monthly Support | Amendment Number(s) | Amendment Net Change in Monthly Payment Installment | Confirmed TBD | [NAME] Notes
1 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
2 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
3 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
4 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
5 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
6 |  |  |  | 500000 |  |  |  |  | 2023-11-01 00:00:00
7 |  |  |  | 500000 |  |  |  |  | 2023-09-01 00:00:00
8 |  |  |  | 500000 |  |  |  |  | 2022-07-01 00:00:00
9 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
10 |  |  |  | 500000 |  |  |  |  | 2023-06-01 00:00:00
11 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
12 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
13 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
14 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
15 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
16 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
17 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
18 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
19 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
20 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
21 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
22 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
23 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
24 |  |  |  | 500000 |  |  |  |  | 2023-04-01 00:00:00
Spreadsheet: 685962d1594296623-find-and-returns-value-of-a-table-from-multiple-criteria-sample-2
Sheet: Sheet1

Date | Value | Code
2020-01-01 00:00:00 | 5.2 | ABC
2020-01-02 00:00:00 | 4.8 | DEF
2020-01-03 00:00:00 | 3.2 | HIJ
2020-01-04 00:00:00 | 45.2 | KLM
2020-01-05 00:00:00 | 32.1 | NOP
2020-01-06 00:00:00 | 56 | RST
2020-01-07 00:00:00 | 57.3 | UVW
2020-01-08 00:00:00 | 23.4 | XYZ
2020-01-09 00:00:00 | 32 | ABC
2020-01-10 00:00:00 | 0.98 | DEF
2020-01-11 00:00:00 | 11.58 | HIJ
2020-01-12 00:00:00 | 5.2 | ABC
2020-01-13 00:00:00 | 4.8 | DEF
2020-01-14 00:00:00 | 3.2 | HIJ
2020-01-15 00:00:00 | 45.2 | KLM
2020-01-16 00:00:00 | 32.1 | NOP
2020-01-17 00:00:00 | 56 | RST
2020-01-18 00:00:00 | 57.3 | UVW
2020-01-19 00:00:00 | 23.4 | XYZ
2020-01-20 00:00:00 | 32 | ABC
2020-01-21 00:00:00 | 5.2 | DEF
2020-01-22 00:00:00 | 4.8 | HIJ
2020-01-23 00:00:00 | 3.2 | ABC
2020-01-24 00:00:00 | 45.2 | DEF
2020-01-25 00:00:00 | 32.1 | HIJ
2020-01-26 00:00:00 | 56 | KLM
2020-01-27 00:00:00 | 57.3 | NOP
2020-01-28 00:00:00 | 23.4 | RST
2020-01-29 00:00:00 | 32 | UVW
2020-01-30 00:00:00 | 0.98 | XYZ
2020-01-31 00:00:00 | 11.58 | ABC
Spreadsheet: 130703d1322523842-too-much-nesting-index-based-on-your-columns_rows
Sheet: reference

 |  |  |  |  |  |  |  |  |  |  | prices
coating |  |  |  |  |  |  |  | Urethane | Splatter | Rhino | Surlyn | [NAME] | [NAME] | Teflon | No-Mar Teflon | Green Brush | Black Brush | Electro-Polish | Epoxy Paint | Rubber | UHMW | Red Urethane
1 |  |  |  |  |  |  |  | 11 | 28 | 16 | 7 | 34 | 11 | 24 | 39 | 18 | 36 | 32 | 32 | 40 | 40 | 3
2 |  |  |  |  |  |  |  | 28 | 8 | 3 | 32 | 42 | 9 | 32 | 17 | 17 | 50 | 15 | 35 | 3 | 15 | 34
3 |  |  |  |  |  |  |  | 41 | 17 | 8 | 29 | 7 | 10 | 16 | 6 | 29 | 48 | 33 | 8 | 39 | 13 | 38
4 |  |  |  |  |  |  |  | 40 | 32 | 38 | 22 | 7 | 28 | 40 | 46 | 33 | 29 | 31 | 4 | 30 | 1 | 44
5 |  |  |  |  |  |  |  | 11 | 39 | 23 | 44 | 49 | 12 | 49 | 32 | 22 | 49 | 32 | 44 | 13 | 7 | 33
6 |  |  |  |  |  |  |  | 40 | 32 | 24 | 26 | 38 | 35 | 6 | 41 | 15 | 13 | 38 | 7 | 26 | 41 | 14
7 |  |  |  |  |  |  |  | 21 | 10 | 15 | 35 | 36 | 4 | 41 | 27 | 47 | 43 | 42 | 33 | 4 | 40 | 49
8 |  |  |  |  |  |  |  | 23 | 40 | 4 | 45 | 38 | 17 | 19 | 15 | 39 | 8 | 21 | 1 | 13 | 41 | 11
9 |  |  |  |  |  |  |  | 43 | 24 | 24 | 27 | 43 | 37 | 49 | 20 | 3 | 33 | 5 | 4 | 49 | 47 | 28
10 |  |  |  |  |  |  |  | 13 | 2 | 19 | 50 | 42 | 1 | 34 | 38 | 11 | 23 | 38 | 10 | 21 | 28 | 39
11 |  |  |  |  |  |  |  | 43 | 12 | 50 | 38 | 16 | 37 | 2 | 45 | 23 | 12 | 37 | 14 | 9 | 47 | 31
12 |  |  |  |  |  |  |  | 14 | 13 | 45 | 1 | 3 | 5 | 9 | 17 | 30 | 47 | 39 | 35 | 21 | 13 | 35
13 |  |  |  |  |  |  |  | 4 | 7 | 34 | 1 | 2 | 4 | 7 | 27 | 38 | 40 | 29 | 50 | 35 | 44 | 26
14 |  |  |  |  |  |  |  | 6 | 34 | 32 | 41 | 23 | 39 | 25 | 23 | 19 | 22 | 13 | 24 | 32 | 31 | 17
15 |  |  |  |  |  |  |  | 36 | 6 | 25 | 27 | 7 | 49 | 38 | 31 | 40 | 23 | 9 | 33 | 4 | 49 | 12
16 |  |  |  |  |  |  |  | 43 | 33 | 10 | 28 | 12 | 50 | 39 | 35 | 38 | 19 | 15 | 34 | 30 | 26 | 17
17 |  |  |  |  |  |  |  | 32 | 39 | 5 | 30 | 48 | 1 | 13 | 48 | 6 | 23 | 48 | 3 | 2 | 24 | 4
18 |  |  |  |  |  |  |  | 34 | 34 | 47 | 9 | 14 | 14 | 13 | 10 | 9 | 28 | 43 | 7 | 20 | 17 | 21
19 |  |  |  |  |  |  |  | 20 | 45 | 49 | 43 | 38 | 28 | 44 | 12 | 6 | 35 | 31 | 41 | 22 | 21 | 22
Spreadsheet: 877677d1724490492-conditional-formatting-northernrunner-cf-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | 1, 11, 21, 31, 41, 51
 |  |  | 2, 12, 22, 32, 42, 52 |  |  |  |  |  |  |  |  |  |  |  |  | True |  |  | True
 |  |  | 3, 13, 23, 33, 43 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 4, 14, 24, 34, 44 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 5, 15, 25, 35, 45 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 6, 16, 26, 36, 46 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 7, 17, 27, 37, 47 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 8, 18, 28, 38, 48 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 9, 19, 29, 39, 49 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 10, 20, 30, 40, 50 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
Spreadsheet: john_zufferli__16725__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 07d3903d-12d0-4695-950d-39cf86fc084b
Sheet: Sheet1

 | [NAME]
Line
 | Income:
1 | 2011 Federal Taxable Income From Line 43, Form 1040; Line 27, Form 1040A or Line 6, Form 1040EZ | 1
2 | Cost of Living Index (COLI) | 1
3 | Adjusted Taxable Income (ATI)(FTI/COLI)
 | Loans:
4 | Total of All Eligible Loan Balances | 1
5 | 3 Year Amortized Loan Balance (ALB) (Line 4 divided by 3)
6 | Score (ATI less ALB)
 | Instructions for filling out application:
 | You should provide numbers only for shaded cells.  Other values will automatically calculate
 | Line 1:  [NAME] the amount of your 2011 Federal Taxable Income from the appropriate line in your 2011 Federal Tax Return
 | Line 2: Enter the number for your County's Cost of Living Index from the chart below.
 | Line 3: (Auto Calculates)
 | Line 4:  Enter the Total Principal Balances as of December 31, 2011 for all eligible loans.  See introduction for list of [NAME].
 | Line 5: (Auto Calculates)
 | Line 6: (Auto Calculates)
 |  |  | Cost of Living Index by County
 |  | County |  | County
 |  | Adams | 0.96 | Juniata | 0.96
 |  | Allegheny | 1 | [NAME] | 0.98
 |  | [NAME] | 0.95
 |  | Beaver | 1 | Lancaster | 1.01
 |  | Bedford | 0.94 | [NAME] | 0.97
 |  | Berks | 1.03 | Lebanon | 0.99
 |  | Blair | 0.96 | Lehigh | 1.06
 |  | Bradford | 0.94
 |  | Bucks | 1.13 | Luzerne | 0.98
 |  | Butler | 1 | Lycoming | 0.97
 |  | Cambria | 0.93 | McKean | 0.93
 |  | Cameron | 0.93 | Mercer | 0.98
 |  | Carbon | 1.06 | Mifflin | 0.96
 |  | Centre | 1 | Monroe | 1
 |  | Chester | 1.13 | Montgomery | 1.13
 |  | Clarion | 0.93 | Montour | 0.98
 |  | Clearfield | 0.93 | Northampton | 1.06
 |  | [NAME] | 0.97 | Northumberland | 0.97
 |  | Columbia | 0.97 | [NAME] | 1.04
 |  | Crawford | 0.94 | Philadelphia | 1.13
 |  | Cumberland | 1.04 | Pike | 1.16
 |  | Dauphin | 1.04 | Potter | 0.93
 |  | Delaware | 1.13 | [NAME] | 0.94
 |  | Elk | 0.93 | Snyder | 0.97
 |  | Erie | 0.97 | Somerset | 0.93
 |  | Fayette | 1 | [NAME] | 0.93
 |  | Forest | 0.93 | Susquehanna | 0.93
 |  | Franklin | 0.96 | Tioga | 0.93
 |  | Fulton | 0.93 | Union | 0.97
 |  | Greene | 0.95 | Venango | 0.93
 |  | Huntingdon | 0.94 | [NAME] | 0.94
 |  | Indiana | 0.94 | Washington | 1
 |  | [NAME] | 0.93 | Wayne | 0.95
 |  |  |  | Westmoreland | 1
 |  |  |  | Wyoming | 0.98
 |  |  |  | York | 1
Spreadsheet: 764596d1642805815-order-scheduler-formula-help-required-please-order-schedule-test-jt-johnny247-
Sheet: WK-Orders

Week | Product Code | Description | Order | [NAME] | Date Required (Week Commencing) | [NAME] | New Order | Amended Order | Delayed | Brought forward | Remove from  following weeks
1 | Product 1 |  | 468549 | 2028 | 2021-12-13 00:00:00
1 | Product 1 |  | 468550 | 2028 | 2021-12-13 00:00:00
1 | Product 10 |  | 456820 | 3042 | 2022-01-03 00:00:00
1 | Product 10 |  | 477069 | 3042 | 2022-03-07 00:00:00
1 | Product 2 |  | 460308 | 1820 | 2021-12-27 00:00:00
1 | Product 2 |  | 464637 | 1820 | 2022-01-03 00:00:00
1 | Product 2 |  | 469944 | 1820 | 2022-01-24 00:00:00
1 | Product 2 |  | 477063 | 1820 | 2022-02-21 00:00:00
1 | Product 3 |  | 468542 | 1820 | 2022-01-10 00:00:00
1 | Product 3 |  | 472923 | 1820 | 2022-01-24 00:00:00
1 | Product 4 |  | 463345 | 1820 | 2021-12-20 00:00:00
1 | Product 4 |  | 469945 | 1820 | 2022-01-31 00:00:00
1 | Product 4 |  | 477064 | 1820 | 2022-02-21 00:00:00
1 | Product 5 |  | 477065 | 2028 | 2022-02-21 00:00:00
1 | Product 6 |  | 467287 | 3042 | 2022-02-07 00:00:00
1 | Product 7 |  | 439127 | 3042 | TBC
1 | Product 7 |  | 442911 | 3042 | TBC
1 | Product 7 |  | 444593 | 3042 | TBC
1 | Product 8 |  | 456819 | 3042 | 2021-12-27 00:00:00
1 | Product 8 |  | 463348 | 3042 | 2022-01-17 00:00:00
1 | Product 8 |  | 477066 | 3042 | 2022-02-28 00:00:00
1 | Product 9 |  | 455372 | 2704 | 2022-01-03 00:00:00
1 | Product 9 |  | 463349 | 2704 | 2022-01-10 00:00:00
1 | Product 9 |  | 477067 | 2704 | 2022-02-07 00:00:00
1 | Product 9 |  | 477068 | 2704 | 2022-02-28 00:00:00
2 | Product 1 |  | 468550 | 2000 | 2021-12-13 00:00:00
2 | Product 10 |  | 456820 | 3042 | 2022-02-07 00:00:00
2 | Product 10 |  | 477069 | 4000 | 2022-03-14 00:00:00
2 | Product 2 |  | 469944 | 1850 | 2022-01-24 00:00:00
2 | Product 3 |  | 468542 | 1820 | 2022-01-10 00:00:00
2 | Product 3 |  | 472923 | 1820 | 2022-01-17 00:00:00
2 | Product 3 |  | 479841 | 1820 | 2022-03-07 00:00:00
2 | Product 4 |  | 469945 | 1820 | 2022-01-17 00:00:00
2 | Product 4 |  | 477064 | 1820 | 2022-01-31 00:00:00
2 | Product 4 |  | 478386 | 1820 | 2022-03-07 00:00:00
2 | Product 4 |  | 478387 | 1820 | 2022-03-28 00:00:00
2 | Product 5 |  | 477065 | 2028 | 2022-02-21 00:00:00
2 | Product 6 |  | 467287 | 3042 | 2022-01-24 00:00:00
2 | Product 6 |  | 481161 | 3042 | 2022-02-07 00:00:00
2 | Product 6 |  | 481162 | 3042 | 2022-03-07 00:00:00
2 | Product 7 |  | 439127 | 3042 | TBC
2 | Product 7 |  | 442911 | 3042 | TBC
2 | Product 7 |  | 444593 | 3042 | TBC
2 | Product 8 |  | 463348 | 3042 | 2022-02-17 00:00:00
2 | Product 9 |  | 477067 | 2704 | 2022-02-07 00:00:00
2 | Product 9 |  | 477068 | 2660 | 2022-02-28 00:00:00
2 | Product 9 |  | 479842 | 2704 | 2022-03-21 00:00:00
3 | Product 8 |  | 477066 | 4000 | 2022-02-28 00:00:00
4 | Product 2 |  | 464637 | 1820 | 2022-01-23 00:00:00
Spreadsheet: 545436d1509466995-count-number-after-text-sample-abscence-calander
Sheet: Abdue , Albert B (2)

Day | January | Februrary | March | April | May | June | July | August | September | October | November | December
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31