tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841842d1693988601-trying-to-easily-create-a-conditional-book1-69-ans
Sheet: Sheet1

Scheduled arrival | Calculated Arrival | Departure | [NAME] | Drive Time | Break | DVIR | 10hr | Start | [NAME] to go | Drive Time | Mph | Delay 1 | Delay 2 | Delay 3
 |  | 13:12:00 | 1 |  | 0 | 0 | 10 |  | 260 | 5.2 | 50
17:00:00 |  | 14:16:00 | 18 | 0.36 |  |  |  | 14:37:00 |  | 0 | 50
 | 14:37:00 | 16:04:00 | 128 | 2.56 |  |  |  | 18:38:00 |  | 0 | 50
 | 18:38:00 | 19:26:00 | 23 | 0.46 |  |  |  | 19:53:00 |  | 0 | 50
 | 19:53:00 | 20:48:00 | 260 | 5.2 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
 | 02:00:00 | 02:00:00 |  | 0 |  |  |  | 02:00:00 |  | 0 | 50
Spreadsheet: 162343d1339803154-excel-2007-id-build-qty-based-on-lowest-cycle-time-cycle-timesample
Sheet: Sheet1

DateCompleted | Qty | assy time
2011-12-14 00:00:00 | 3 | 02:43:59
2012-01-19 00:00:00 | 1 | 02:36:35
2012-01-27 00:00:00 | 2 | 02:34:11
2012-02-06 00:00:00 | 1 | 03:38:59
2012-02-17 00:00:00 | 2 | 02:27:18
2012-03-01 00:00:00 | 1 | 04:02:59
2012-03-22 00:00:00 | 1 | 03:17:24
2012-03-23 00:00:00 | 1 | 02:10:48
2012-04-06 00:00:00 | 2 | 02:41:06
2012-04-10 00:00:00 | 1 | 02:44:24
2012-04-16 00:00:00 | 1 | 02:52:47
2012-04-23 00:00:00 | 1 | 03:35:23
2012-04-30 00:00:00 | 1 | 03:50:23
2012-05-15 00:00:00 | 1 | 03:21:35
2012-05-21 00:00:00 | 1 | 03:58:12
2012-05-29 00:00:00 | 1 | 03:24:36
2012-06-05 00:00:00 | 5 | 01:24:57
Spreadsheet: chris_germany__2899__Enron Supply - TGP
Sheet: Tenn

TGP SUPPLY FROM ENRON
From:  [NAME]  [PHONE]
To:  [NAME] ([EMAIL]), [NAME] ([EMAIL])
Phone:   [PHONE]  clarissa
Phone:  [PHONE]  [NAME]
Phone:  [PHONE] cindy
Fax:   [PHONE]
 |  |  | Tennessee
LDC | MTR # | CONFIRM | CONTRACT #
 |  |  |  | 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 | TOTAL
Bay State | 020193 | 711 | 2025 | 31 | 0
 |  |  | 31333 |  | 31 |  |  | 0 |  |  | 31 |  |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 31 |  |  | 0 |  |  |  |  |  |  |  |  | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 0 | 0
 |  |  | 32229 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 31 | 0
 |  |  | 31239 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
Berkshire | 020292 | 682 | 2025 | 50 | 0
 |  |  | 31333 |  |  | 50 |  | 0 |  |  | 50 | 40 |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 50 |  |  | 0 |  |  |  |  |  |  |  | 0 | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 0 | 0
 |  |  | 32229 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 0
 |  |  | 31239 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 20
Boston | 020118 | 680 | 2025 | 75 | 0 | 0
 |  |  | 31333 |  | 97 | 87 |  | 97 | 97 | 97 | 89 | 68 |  | 69 | 84 | 81 | 76 | 0
 |  |  | 21589 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 0 | 0
 |  |  | 32229 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 86 | 0
 |  |  | 31239 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 | 74 | 84 | 89 | 76
Ct. Natural | 020205 |  |  | 0 | 0
No. Utilities | 020206 | 711 | 2025 | 353 | 0 |  |  |  |  |  | 0 | 0
 |  |  | 31333 |  | 353 |  |  | 0 |  |  | 353 |  |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 353 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 353 | 0 | 0
 |  |  | 32229 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 | 403 | 350 | 0
 |  |  | 26926 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 0 | 0
 |  |  | 31239 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350
So. Conn. | 020126 |  | 32295 | 571 | 0 |  |  |  |  |  | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 481 | 0 | 0
 |  |  | 32295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 519 | 0 | 0
 |  |  | 32229 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 401 | 0
Yankee | 020125 |  |  | 0
Yankee | 020127 |  |  | 0
Spreadsheet: 04c49b14-aecf-46cc-83a3-67101b481a4c
Sheet: Sheet1

Project: | Example Residence Portland, OR | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
House area in square feet | 1800
EUI kbtu/sf/yr | 32.94357888888889
 | Enter your utility kwh in this column | kwh converted to kbtu | Enter your utility therms in this column | therms converted to kbtu | total kbtu per month
July | 300 | 1023.9 | 9 | 900 | 1923.9
August | 310 | 1058.03 | 8 | 800 | 1858.03
September | 345 | 1177.485 | 10 | 1000 | 2177.485
October | 412 | 1406.156 | 25 | 2500 | 3906.156
November | 410 | 1399.33 | 40 | 4000 | 5399.33
December | 525 | 1791.825 | 75 | 7500 | 9291.825
January | 620 | 2116.06 | 110 | 11000 | 13116.06
February | 450 | 1535.85 | 65 | 6500 | 8035.85
March | 435 | 1484.655 | 45 | 4500 | 5984.655
April | 375 | 1279.875 | 20 | 2000 | 3279.875
May | 340 | 1160.42 | 12 | 1200 | 2360.42
June | 312 | 1064.856 | 9 | 900 | 1964.856
Annual totals | 4834 |  | 428 |  | 59298.442
 | kwh |  | therms |  | kbtu
Replace numbers in yellow squares with information from your utility bills. The table automatically converts energy units to kbtu and calculates your energy use index. |  |  |  |  |  | Replace numbers in gray squares by observing the bars in the chart Annual Energy Use
 |  |  |  |  |  | avg monthly domestic hot water in kbtu |  | annual space heat in kbtu | 35298.442 | 0.59526761259596
 |  |  |  |  |  | 1000 |  | annual DHW in kbtu | 12000 | 0.2023661937020201
 |  |  |  |  |  | avg monthly non-heat electric in kbtu
 |  |  |  |  |  | 1000 |  | annual non-heat electric in kbtu | 12000 | 0.2023661937020201
Spreadsheet: 855716d1705240432-formula-to-get-a-ranking-based-on-three-columns-formula-to-get-a-ranking-based-on-three-columns
Sheet: Sheet1

Weightage | 0.5 | 0.3 | 0.2 |  |  |  |  |  |  | [NAME] to get a ranking based on three columns
Highest Possible Score |  |  |  | inversely | directly | directly |  |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1417686
Lowest Possible Score |  |  |  | proportional | proportional | proportional
EMPLOYEE | COMBINED AVG. | [NAME] | Cleanliness AVG. | COMBINED AVG. SCORE | ATTENDANCE SCORE | Cleanliness AVG SCORE | Weighted Total Score | Ranking |  | Continuing on the good work by Gregb11, I have added 3 attributes/fields to give flexibility in the scoring computation:
[NAME] | 80 | 1 | 3 |  |  |  |  |  |  | 1) Weightage in B1:D1 - the weightage to be given for each of the scores
Ana | 33.49 | 1 | 1 |  |  |  |  |  |  | 2) Highest possible score in B2:D2 - I am taking the maximum of available scores as the highest possible score; if the maximum score for [NAME] is 100 and [NAME] is 5, then put 100 in cell B2 and 5 in cell D2
[NAME] | 50.2 | 1 | 1.5 |  |  |  |  |  |  | 3) Lowest possible score in B3:D3 - I am taking the minimum of available scores as the lowest possible score; if the lowest possible scores for all is 0 or 0%, then key in 0 in B3:D3
[NAME] | 39.04 | 1 | 1.5 |  |  |  |  |  |  | 4) Recompute percentage score for [NAME] in E5=(B$2-[@[COMBINED AVG.]])/(B$2-B$3), copy down
Kayla | 80 | 1 | 0 |  |  |  |  |  |  | 5) Recompute percentage score for [NAME] in [NAME]), copy down
Kaylie | 54.38 | 1 | 2 |  |  |  |  |  |  | 6) Recompute percentage score for Cleanliness Avg. in G5=([@[Cleanliness AVG.]]-D$3)/(D$2-D$3), copy down
[NAME] | 46.97 | 0.75 | 3 |  |  |  |  |  |  | 7) Weighted Total Score in H5=[NAME]. SCORE]:[Cleanliness AVG SCORE]],$B$1:$D$1), copy down
Melin | 44.41 | 1 | 3 |  |  |  |  |  |  | 8) Ranking in I5=RANK.EQ([@[Weighted Total Score]],[Weighted Total Score]), copy down
Petra | 41.14 | 1 | 2.5
Tira | 56.93 | 0.67 | 2.5
Tomi | 71.7 | 0.5 | 3
Spreadsheet: 824898d1680945773-sum-by-item-and-year-from-another-sheet-book1
Sheet: Sheet1

 | TRAIL BALANCE
Account | Account Type | Debit | Credit | Balance
Cash In Hand | ASSEST
Cash In Bank | ASSEST |  | 0
Misc Income | INCOME | 0 | 1250
Rent Accrual | ASSEST | 0 | 0
Interest Received | ASSEST | 0 | 0
Acc.Payable | LIABILITY | 0 | 0
Spreadsheet: 875168d1721745867-calculation-of-leave-days-leave-calculator
Sheet: Sheet1

Length of Service Years | Leave Days
1 - 9 years | 18
10 years and above | 21
Leave monthly calculation | Annual Leave days | Monthly Leave days
1 - 9 years | 18
10 years and above | 21
 | 1 - 9 years | Accrued Days
2024-07-01 00:00:00 | 1.5
2024-08-01 00:00:00 | 1.5
2024-09-01 00:00:00 | 1.5
2024-10-01 00:00:00 | 1.5
2024-11-01 00:00:00 | 1.5
2024-12-01 00:00:00 | 1.5
2025-01-01 00:00:00 | 1.5
2025-02-01 00:00:00 | 1.5
2025-03-01 00:00:00 | 1.5
2025-04-01 00:00:00 | 1.5
2025-05-01 00:00:00 | 1.5
2025-06-01 00:00:00 | 1.5
 | 10 years and above | Accrued Days
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
 | 1.75
Spreadsheet: cdb9c9bd-e985-4355-97cd-769c7fa776e9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4356 | 7963 | Etienne | Caprin | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 03:08:05
Spreadsheet: 820174d1677902083-extracting-details-from-a-row-that-matches-criteria-and-inserting-into-another-sheet-sample-2023-03-03t212910-atombomb99-
Sheet: Sheet1

 | Staff member | Overdue Mandatory |  |  | (Dropdown slection box below in F5)
 |  |  |  |  | User, testing | Mandatory courses overdue | Was due By
 | TOTALS
Spreadsheet: 29081d1223833844-automatically-changing-cell-value-on-a-given-date-budget-08-example2
Sheet: Sheet1

Starting Balance | 500 |  |  | 110
Current Balance | 500 |  |  | 110
 | 2008-10-01 00:00:00 |  |  | 2008-11-01 00:00:00
Expenditure | Budget | Remaining | Spent to date | Budget | Remaining | Spent to date
Rent | -300 | -300 | 0 | -300 | -300 | 0
Council Tax | -50 | -50 | 0 | -50 | -50 | 0
Utilities | -40 | -40 | 0 | -40 | -40 | 0
Final Balance | 110 |  |  | -280
Spreadsheet: andy_zipper__168__DYNEGY-ICE VOL Apr12
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  |  | ENRON PERCENTAGE: |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Count of Deal ID | Sum of Total Quantity |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 2 | 2737500 |  | Carson , M | Firm-LD Peak | MWhs | 1 | 1600
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 6 | 4735000 |  | [NAME], R | Firm-LD Peak | MWhs | 1 | 8000
Grand Total |  |  | 8 | 7472500 |  | Grand Total |  |  | 2 | 9600
Spreadsheet: 53715d1253635983-transferring-data-from-many-sheets-to-a-single-sheet-mohit-bank-sample
Sheet: Report

DAILY CONSOLIDATED BANK REPORT |  |  |  |  |  | 2009-06-30 00:00:00 | 39994 | >39994
A/c Details | Clear Balance As On | Cheques Issued for Today | Total Post Dated Cheques Issed | Expected Receipts | Shoftfall/Surplus for Next Day | Shortfall/Surplus Overall |  |  | Remarks
 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00
Kotak 811 | -30466.31 | 46000 | 46000 | 250000 | -76466.31 | 173533.69
Citi 018
ICICI T1
ICICI T2
ICICI D1
ICICI D2
ICICI B1
ICICI B2
BOB 229
ICICI P2
ICICI H2
ICICI K2
ICICI C2
ICICI T3
ICICI KC2
ING CC
ING 560
DAILY TRANSACTIONS REPORT FOR 30-Jun-09
 |  |  |  |  |  |  | Balance | Remarks
Kotak Mahindra Bank xxxxxxxxxxxxxxxx811
Clearing Dt | Issue Dt | Dr/Cr | Particulars | Chq No | Deposits | Withdrawal
2009-06-30 00:00:00 | 2009-06-27 00:00:00 | Cr | Royal Securities | 000821 |  | 8000
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | G.G. Service Station | 000825 |  | 19636
2009-06-30 00:00:00 | 2009-06-27 00:00:00 | Cr | Star enterprises | 000816 |  | 3321
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | C.Cantt | 000823 |  | 25000
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | Cash Manpada |  | 80000
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | Arihant Tyres | 000822 |  | 74500
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | FTD From 831.210.20 To 656.200.811 |  | 50528
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | RTGS RAVI ROAD LINES INDIA PVT LTD SHO |  | 375000
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Cr | Contra |  |  | 500000
Citibank xxxxxxxxxxxxxxx018
Clearing Dt | Issue Dt | Dr/Cr | Particulars | Chq No | Deposits | Withdrawal
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Dr | XYZ Corp |  | 34000
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Cr | Battery Supplier |  |  | 180
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Cr | NEFT/PK Enterprises |  |  | 15000
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | Baby Seats Mfg. |  |  | 15000
Spreadsheet: 109279d1306185136-comparing-grades-and-using-conditional-formatting-example
Sheet: Sheet3

9 | U
9.375 | U
9.545454545454545 | U
9.642857142857142 | U
14.4 | G
15 | G
15.27272727272727 | G
15.42857142857143 | G
15.52941176470588 | G
19.8 | F
20.625 | F
21 | F
21.21428571428572 | F
21.35294117647059 | F
21.45 | F
25.2 | E
26.25 | E
26.72727272727273 | E
27 | E
27.17647058823529 | E
27.3 | E
27.39130434782609 | E
31.875 | D
32.45454545454545 | D
32.78571428571428 | D
33 | D
33.15 | D
33.26086956521739 | D
33.34615384615385 | D
38.18181818181818 | C
38.57142857142857 | C
38.8235294117647 | C
39 | C
39.1304347826087 | C
39.23076923076923 | C
39.31034482758621 | C
44.35714285714285 | B
44.64705882352941 | B
44.85 | B
45 | B
45.11538461538461 | B
45.20689655172414 | B
50.47058823529412 | A
50.7 | A
50.8695652173913 | A
51 | A
51.10344827586207 | A
56.55 | A*
56.73913043478261 | A*
56.88461538461539 | A*
57 | A*
Spreadsheet: tracy_geaccone__40256__C0366-112458
Sheet: Summary

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
INVOICE
 | BILL TO:EOC - Executive
 | 1400 Smith Street
 | Houston, TX 77251
 | ATTN:[NAME]
 | DATE OF SERVICES |  | INVOICE DATE |  | INVOICE NO.
 | May, 2001 |  | Friday, June 01, 2001 |  | [PHONE]
 | COMPANY | RC NO | DESCRIPTIONS | AMOUNT
 | 0366-112458 | 100150 | TRAVEL | 536.42
 |  | 100152 | SHIPPING/RECEIVING | 49.88
 |  | 100154 | FORMS MANAGEMENT | 262.77
 |  | 100158 | PHONE OPERATORS | 3.75
 |  | 100159 | MAIL CENTER | 14.34
 |  | 100164 | FACILITY MAINT. | 3.6
 |  | 100166 | SECURITY CHARGES | 6.3
 |  | 100182 | BUILDING SERVICES | 2.7
 |  | 100186 | FACILITY OPERATIONS | 4.23
 |  | 100187 | CONVENIENCE COPIERS | 1.52
 |  | 100192 | CAFETERIA | 14.08
 |  | 100193 | ENRON BUILDING | 187.5
 |  | 100196 | PARKING | 110.92
 | Total:
Spreadsheet: 866957d1713872968-convert-different-rows-to-one-column-example-2-_unpivot
Sheet: Sheet1

 |  |  |  |  |  |  |  | Value
 | Column1 | Column2 | Column3 | Column4 |  | P-11 |  | P-1
 | P-1 | P-11 | P-1017 | P-1068 |  | P-1017 |  | P-11
 | P-2 | P-12 | P-1018 | P-1069 |  | P-1068 |  | P-1017
 | P-3 | P-13 | 0 | P-1070 |  | #N/A |  | P-1068
 | 0 | P-14 | P-1020 | P-1071 |  | #N/A |  | P-2
 | P-5 | P-15 | P-1021 | P-1072 |  | #N/A |  | P-12
 | P-6 | P-16 | [NAME] | P-1073 |  | #N/A |  | P-1018
 | P-7 | 0 | P-1023 | NA |  | #N/A |  | P-1069
 | P-8 | P-18 | P-1024 | P-1075 |  | #N/A |  | P-3
 | P-9 | P-19 | P-1025 | P-1076 |  | #N/A |  | P-13
 | P-10 | P-20 | NA | P-1077 |  | #N/A |  | P-1070
 | P-11 | P-21 | P-1027 | NA |  | #N/A |  | P-14
 |  |  |  |  |  | #N/A |  | P-1020
 |  |  |  |  |  | #N/A |  | P-1071
 |  |  |  |  |  | #N/A |  | P-5
 |  |  |  |  |  | #N/A |  | P-15
 |  |  |  |  |  | #N/A |  | P-1021
 |  |  |  |  |  | #N/A |  | P-1072
 |  |  |  |  |  | #N/A |  | P-6
 |  |  |  |  |  | #N/A |  | P-16
 |  |  |  |  |  | #N/A |  | [NAME]
 |  |  |  |  |  | #N/A |  | P-1073
 |  |  |  |  |  | #N/A |  | P-7
 |  |  |  |  |  | #N/A |  | P-1023
 |  |  |  |  |  | #N/A |  | P-8
 |  |  |  |  |  | #N/A |  | P-18
 |  |  |  |  |  | #N/A |  | P-1024
 |  |  |  |  |  | #N/A |  | P-1075
 |  |  |  |  |  | #N/A |  | P-9
 |  |  |  |  |  | #N/A |  | P-19
 |  |  |  |  |  | #N/A |  | P-1025
 |  |  |  |  |  | #N/A |  | P-1076
 |  |  |  |  |  | #N/A |  | P-10
 |  |  |  |  |  | #N/A |  | P-20
 |  |  |  |  |  | #N/A |  | P-1077
 |  |  |  |  |  | #N/A |  | P-11
 |  |  |  |  |  | #N/A |  | P-21
 |  |  |  |  |  | #N/A |  | P-1027
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
Spreadsheet: 814263d1674245609-pull-in-multiple-rows-of-data-searching-by-date-summary-sheet
Sheet: 18

[NAME]
 |  |  |  |  | Retentate Weighted Average
Sweet Cream Load outs | BF% | Protein | TS | PO#
 |  |  |  |  | Sweet Cream Weighted Average
Spreadsheet: 810681d1671955496-distribute-the-amount-based-on-day-difference-if-date-condition-met-true-amount-distributor-2-1-0
Sheet: Sheet1 (3)

Recovery Period From | 2020-10-17 00:00:00 | To | 2021-04-25 00:00:00
Exemption Period From | 2021-06-22 00:00:00 | To | 2021-10-01 00:00:00
 |  |  |  |  | EXPECTED RESULT
ELECT-DUTY | RECOVERY | EXEMPTION | BILL-DATE |  | RECOVERY | EXEMPTION
430 |  |  | 2020-09-19 00:00:00
528.08 |  |  | 2020-10-13 00:00:00
1252.08 |  |  | 2020-11-20 00:00:00 |  | 1120.282105263158
864.08 |  |  | 2020-12-14 00:00:00 |  | 864.08
854.09 |  |  | 2021-01-09 00:00:00 |  | 854.09
995.07 |  |  | 2021-02-12 00:00:00 |  | 995.07
628.11 |  |  | 2021-03-02 00:00:00 |  | 628.11
686.83 |  |  | 2021-03-27 00:00:00 |  | 686.83
791.2 |  |  | 2021-04-26 00:00:00 |  | 764.8266666666667
718.04 |  |  | 2021-05-25 00:00:00
727 |  |  | 2021-06-25 00:00:00 |  |  | 93.80645161290323
5812.24 |  |  | 2021-07-24 00:00:00 |  |  | 5812.24
7404.36 |  |  | 2021-08-26 00:00:00 |  |  | 7404.36
6131.32 |  |  | 2021-09-27 00:00:00 |  |  | 6131.32
5814.71 |  |  | 2021-10-30 00:00:00 |  |  | 704.8133333333334
4130.82 |  |  | 2021-12-01 00:00:00
Spreadsheet: kevin_ruscitti__20327__NGPL_StorageE_Test
Sheet: Update Page

[NAME] Curves:
Assumptions:
1 | Effective Curve Date (FetchMids Worksht) is the date that you want to retrieve the curve for.  In the morning, the latest curves would be yesterday's,
 | and in the late afternoon, you could pull today's curves.
 | 1 | Jan
 | 2 | Feb
 | 3 | Mar
 | 4 | Apr
 | 5 | May
 | 6 | Jun
 | 7 | Jul
 | 8 | Aug
 | 9 | Sep
 | 10 | Oct
 | 11 | Nov
 | 12 | Dec
Spreadsheet: eric_saibi__9749__011602R
Sheet: Bailly 08

Owner Name |  | Northern Indiana Public Service Co.
Station Name |  | Bailly Power Station
Unit Name |  | Bailly 08
NERC Region |  | ECAR
State |  | IN
Fuel Type |  | Coal/ Nat. gas
Capacity |  | 422 MW
Start Date |  | 2001-12-27 00:00:00
End Date |  | 2002-01-19 00:00:00
Prv. Start Date |  | 2001-12-27 00:00:00
Prv. End Date |  | 2002-01-16 00:00:00
Comments |  | [NAME], valve work.
SIC |  | 4911
Plant ID |  | 1010662
Unit ID |  | 1004703
Outage ID |  | 17054
Spreadsheet: 257605d1376448087-formula-to-lookup-up-text-in-a-table-and-list-in-sequential-rows-example
Sheet: Data

 | Name |  | Stage | Cycle |  |  | District | Revenue
250-1 | Mr. [NAME] | 291 | Audit | Standard Sales Cycle | Audit Not Complete | 840197 | 10 | 20000
283-1 | Mr. [NAME] | 339 | Awaiting Signature | Complex Sales Cycle | 19 | 840197 | 11 | 15000
370-1 | [NAME] | 452 | Customer Presentation | Standard Sales Cycle | 21 | 840094 | 10 | 18000
416-1 | JFK Medical Center | 544 | Awaiting Signature | Standard Sales Cycle | 11 | 840093 | 11 | 16815.93
589-1 | Barnabas Kimball 1 | 82 | Audit | Standard Sales Cycle | Audit Not Complete | 840100 | 10 | 0
615-1 | Barnabas Kimball 2 | 841 | Audit | Exterior Project Sales Cycle | Audit Not Complete | 840100 | 10 | 11000 |  | 10
617-1 | [NAME] | 844 | Audit | Standard Sales Cycle | Audit Not Complete | 840100 | 12 | 0 |  | 11
731-1 | Meridian Ocean Medical 1 | 543 | Audit | Exterior Project Sales Cycle | Audit Not Complete | 840100 | 10 | 50000 |  | 12
735-1 | Meridian Ocean Medical 2 | 937 | Audit | Standard Sales Cycle | Audit Not Complete | 840100 | 14 | 23000 |  | 14
741-1 | Meridian Ocean Medical 3 | 940 | Audit | Exterior Project Sales Cycle | Audit Not Complete | 840100 | 10 | 0
 | Choose District
Spreadsheet: 201642d1356053186-formula-not-working-after-copying-a-file-bdays
Sheet: Sheet1

First | Last | Full Name | Age | Birthday | Year Born | yes |  |  |  | #N/A | row | Name | B'Day | Age
Name | 1 | Name 1 | 75 | 1937-03-31 00:00:00 | 1937-03-31 00:00:00 | yes | #N/A | 75 Years, 8 Months, 19 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 2 | Name 2 | 67 | 1945-02-22 00:00:00 | 1945-02-22 00:00:00 | yes | #N/A | 67 Years, 9 Months, 28 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 3 | Name 3 | 67 | 1945-05-16 00:00:00 | 1945-04-28 00:00:00 | yes | #N/A | 67 Years, 7 Months, 4 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 4 | Name 4 | 64 | 1948-06-07 00:00:00 | 1948-06-07 00:00:00 | yes | #N/A | 64 Years, 6 Months, 13 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 5 | Name 5 | 62 | 1950-07-30 00:00:00 | 1950-07-30 00:00:00 | yes | #N/A | 62 Years, 4 Months, 20 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 6 | Name 6 | 62 | 1950-08-10 00:00:00 | 1950-08-10 00:00:00 | yes | #N/A | 62 Years, 4 Months, 10 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 7 | Name 7 | 62 | 1950-06-07 00:00:00 | 1950-06-07 00:00:00 | yes | #N/A | 62 Years, 6 Months, 13 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 8 | Name 8 | 59 | 1953-04-29 00:00:00 | 1953-04-29 00:00:00 | yes | #N/A | 59 Years, 7 Months, 21 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 9 | Name 9 | 57 | 1955-01-27 00:00:00 | 1955-01-27 00:00:00 | yes | #N/A | 57 Years, 10 Months, 23 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 10 | Name 10 | 57 | 1955-05-08 00:00:00 | 1955-05-08 00:00:00 | yes | #N/A | 57 Years, 7 Months, 12 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 11 | Name 11 | 57 | 1955-05-04 00:00:00 | 1955-05-04 00:00:00 | yes | #N/A | 57 Years, 7 Months, 16 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 12 | Name 12 | 57 | 1955-07-26 00:00:00 | 1955-07-26 00:00:00 | yes | #N/A | 57 Years, 4 Months, 24 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 13 | Name 13 | 54 | 1958-04-06 00:00:00 | 1958-04-06 00:00:00 | yes | #N/A | 54 Years, 8 Months, 14 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 14 | Name 14 | 53 | 1959-02-07 00:00:00 | 1959-02-07 00:00:00 | yes | #N/A | 53 Years, 10 Months, 13 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 15 | Name 15 | 52 | 1960-05-08 00:00:00 | 1960-05-08 00:00:00 | yes | #N/A | 52 Years, 7 Months, 12 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 16 | Name 16 | 50 | 1962-02-20 00:00:00 | 1962-02-20 00:00:00 | yes | #N/A | 50 Years, 10 Months, 0 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 17 | Name 17 | 50 | 1962-04-13 00:00:00 | 1962-04-13 00:00:00 | yes | #N/A | 50 Years, 8 Months, 7 Days |  |  | #N/A | #N/A | #N/A | #N/A
Name | 18 | Name 18 |  |  |  | no | #N/A | unkown
Name | 19 | Name 19 |  |  |  | no | #N/A | unkown
Name | 20 | Name 20 |  |  |  | no | #N/A | unkown
Name | 21 | Name 21 |  |  |  | no | #N/A | unkown
Name | 22 | Name 22 |  |  |  | no | #N/A | unkown
Name | 23 | Name 23 |  |  |  | no | #N/A | unkown