tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 27795d1221453510-holdings-checking-checking-holdings
Sheet: Weekly Summary

Security code | Quoted ex date | Record Date | Payable Date | Yes/No | Weekly summary date range |  | Date of Holdings | Vlookup tab
QQCAAA | 2008-08-26 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  | 2008-08-25 00:00:00 | 2008-08-31 00:00:00 | 2008-06-15 00:00:00
QQZBBB | 2008-08-27 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-06-23 00:00:00 | 230608
QQHCCC | 31/09/2008 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-06-30 00:00:00 | 300608
[NAME] | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-07-07 00:00:00 | 70708
QQREEE | 2008-07-07 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 |  |  |  | 2008-07-14 00:00:00 | 140708
QQSFFF | 2007-06-24 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 |  |  |  | 2008-07-28 00:00:00 | 280708
QQTGGG | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 |  |  |  | 2008-08-04 00:00:00 | 40808
QQXHHH | 2008-08-11 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 |  |  |  | 2008-08-11 00:00:00 | 110808
QQZPBIII | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-08-18 00:00:00 | 180808
QBBJJJ | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-08-25 00:00:00 | 250808
QBCKKK | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 |  |  |  | 2008-09-01 00:00:00 | 10908
QBILLL | 2008-07-07 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QBJMMM | 2008-06-24 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00
[NAME] | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00
QBQOOO | 2007-08-11 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00
QBQOPPP | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QBQQQQ | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QBSSMWRRR | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QBUSSSS | 2008-07-07 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QBVTTTTTT | 2008-06-24 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00
QBWUUUU | 2008-07-01 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00
QBYVVVVVV | 2008-08-11 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QCBWWWWW | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QCKXXXXX | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QCQYYYYYY | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00
QCRZZZZZ | 2008-08-25 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00
Spreadsheet: dbf5e0f5-4ec5-4007-beed-d2c5c7580b5c
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193153623 | Jr. [NAME] | Recovery, The | 2012-10-16 | Compact Disc | Gospel | 10.99 | Y | Available
Spreadsheet: 879442d1726965100-how-to-leave-out-any-columns-that-have-all-0-00-in-them-testfile
Sheet: Misc Stats

Customer Agents |  | agt-1
 | AGT-1
Client-1 | AGT-2
Client-1 | AGT-3
Client-1 | AGT-4
0 | 0
Client-2 | AGT-1
Client-2 | AGT-2
Client-2 | AGT-3
Client-2 | AGT5
Client-2 | AGT6
Spreadsheet: 884608d1733840029-calculation-formulas-based-on-dates-2024-investment-jt-
Sheet: Investments (2)

 | Reference number | Bank | Investment Date | Maturity Date | Initial Deposit Amount | Annual Interest Rate | Deposit Duration (Days) | Status | Total Interest Earned | Total Amount to Return | ROI | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Check
 |  | Riyad | 2024-11-01 00:00:00 | 2024-12-03 00:00:00 | 33000000 | 0.05
 |  | Riyad | 2024-11-02 00:00:00 | 2024-12-04 00:00:00 | 33000001 | 0.0515
 |  | Riyad | 2024-11-03 00:00:00 | 2024-12-05 00:00:00 | 33000002 | 0.04
 |  | Riyad | 2024-11-04 00:00:00 | 2024-12-06 00:00:00 | 33000003 | 0.045
 |  | Riyad | 2024-11-05 00:00:00 | 2024-12-07 00:00:00 | 33000004 | 0.055
 |  | Workings
 |  | Riyad |  |  | 17000000 | 0.046 |  | DONE
 |  |  |  |  | End Date
 |  |  |  |  | Start Date
 |  |  |  |  | Day Difference
 |  |  |  |  | Add 1 if Start Date in Current Month or End Date after Current Month
 |  |  |  |  | Less 1 if Start Date and End Date in same month
 |  |  |  |  | Day Difference
 |  |  |  |  | Combined Formula
 |  |  |  |  | Total Day Difference
 |  |  |  |  | Check
Spreadsheet: 772241d1647103010-help-filling-a-table-from-another-table-call-taker-mealbreak-sheet-centralised-blank-matt_hooks_79-
Sheet: reference

% variance | HCP max off | 999 [NAME] | Total [NAME] off |  | password | PW123 |  | [NAME] | qual
51 | 3 | 3 | 4 |  |  |  |  | E | 999
50 | 3 | 3 | 4 |  |  |  |  | W | HCP
49 | 3 | 3 | 4 |  |  |  |  | N
48 | 3 | 3 | 4
47 | 3 | 3 | 4
46 | 3 | 3 | 4
45 | 3 | 3 | 4
44 | 3 | 3 | 4
43 | 3 | 3 | 4
42 | 3 | 3 | 4
41 | 3 | 3 | 4
40 | 3 | 3 | 4
39 | 3 | 3 | 4
38 | 3 | 3 | 4
37 | 3 | 3 | 4
36 | 3 | 3 | 4
35 | 3 | 3 | 4
34 | 3 | 3 | 4
33 | 3 | 3 | 4
32 | 3 | 3 | 4
31 | 3 | 3 | 4
30 | 3 | 3 | 4
29 | 3 | 3 | 4
28 | 3 | 3 | 4
27 | 3 | 3 | 4
26 | 3 | 3 | 4
25 | 3 | 3 | 4
24 | 3 | 3 | 4
23 | 3 | 3 | 4
22 | 3 | 3 | 4
21 | 3 | 3 | 4
20 | 3 | 3 | 4
19 | 3 | 3 | 4
18 | 3 | 3 | 4
17 | 3 | 3 | 4
16 | 3 | 3 | 4
15 | 3 | 3 | 4
14 | 3 | 3 | 4
13 | 3 | 3 | 4
12 | 3 | 3 | 4
11 | 3 | 3 | 4
10 | 3 | 3 | 4
9 | 3 | 3 | 4
8 | 3 | 3 | 4
7 | 3 | 3 | 4
6 | 3 | 3 | 4
5 | 3 | 3 | 4
4 | 3 | 3 | 4
3 | 3 | 3 | 4
2 | 3 | 3 | 4
1 | 3 | 3 | 4
0 | 3 | 3 | 4
-1 | 3 | 3 | 4
-2 | 3 | 3 | 4
-3 | 3 | 3 | 4
-4 | 3 | 3 | 4
-5 | 3 | 3 | 4
-6 | 3 | 3 | 4
-7 | 3 | 3 | 4
-8 | 3 | 3 | 4
-9 | 3 | 3 | 4
-10 | 3 | 3 | 4
-11 | 2 | 2 | 3
-12 | 2 | 2 | 3
-13 | 2 | 2 | 3
-14 | 2 | 2 | 3
-15 | 2 | 2 | 3
-16 | 2 | 2 | 3
-17 | 2 | 2 | 3
-18 | 2 | 2 | 3
-19 | 2 | 2 | 3
-20 | 2 | 2 | 3
-21 | 2 | 2 | 2
-22 | 2 | 2 | 2
-23 | 2 | 2 | 2
-24 | 2 | 2 | 2
-25 | 2 | 2 | 2
-26 | 1 | 1 | 1
-27 | 1 | 1 | 1
-28 | 1 | 1 | 1
-29 | 1 | 1 | 1
-30 | 1 | 1 | 1
-31 | 0 | 0 | 0
-32 | 0 | 0 | 0
-33 | 0 | 0 | 0
-34 | 0 | 0 | 0
-35 | 0 | 0 | 0
-36 | 0 | 0 | 0
-37 | 0 | 0 | 0
-38 | 0 | 0 | 0
-39 | 0 | 0 | 0
-40 | 0 | 0 | 0
-41 | 0 | 0 | 0
-42 | 0 | 0 | 0
-43 | 0 | 0 | 0
-44 | 0 | 0 | 0
-45 | 0 | 0 | 0
-46 | 0 | 0 | 0
-47 | 0 | 0 | 0
-48 | 0 | 0 | 0
-49 | 0 | 0 | 0
-50 | 0 | 0 | 0
-51 | 0 | 0 | 0
-52 | 0 | 0 | 0
-53 | 0 | 0 | 0
-54 | 0 | 0 | 0
-55 | 0 | 0 | 0
-56 | 0 | 0 | 0
-57 | 0 | 0 | 0
-58 | 0 | 0 | 0
-59 | 0 | 0 | 0
-60 | 0 | 0 | 0
-61 | 0 | 0 | 0
-62 | 0 | 0 | 0
-63 | 0 | 0 | 0
-64 | 0 | 0 | 0
-65 | 0 | 0 | 0
-66 | 0 | 0 | 0
-67 | 0 | 0 | 0
-68 | 0 | 0 | 0
-69 | 0 | 0 | 0
-70 | 0 | 0 | 0
-71 | 0 | 0 | 0
-72 | 0 | 0 | 0
-73 | 0 | 0 | 0
-74 | 0 | 0 | 0
-75 | 0 | 0 | 0
-76 | 0 | 0 | 0
-77 | 0 | 0 | 0
-78 | 0 | 0 | 0
-79 | 0 | 0 | 0
-80 | 0 | 0 | 0
-81 | 0 | 0 | 0
-82 | 0 | 0 | 0
-83 | 0 | 0 | 0
-84 | 0 | 0 | 0
-85 | 0 | 0 | 0
-86 | 0 | 0 | 0
-87 | 0 | 0 | 0
-88 | 0 | 0 | 0
-89 | 0 | 0 | 0
-90 | 0 | 0 | 0
-91 | 0 | 0 | 0
-92 | 0 | 0 | 0
-93 | 0 | 0 | 0
-94 | 0 | 0 | 0
-95 | 0 | 0 | 0
-96 | 0 | 0 | 0
-97 | 0 | 0 | 0
-98 | 0 | 0 | 0
-99 | 0 | 0 | 0
-100 | 0 | 0 | 0
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Nov 2000

November 2000 Production Month
Cash In\Out After Bookout | 22 | Majority is Due Shippers
 | 14 | Minority is Due FGT
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ALUMINUM COMPANY OF AMERICA | CIO | -2890.76 | -665
ANHEUSER BUSCH COMPANIES, INC | CIO | -579.6 | -120
ASHLAND CHEMICAL COMPANY | CIO | -806.61 | -167
DYNEGY GAS TRANSPORTATION, INC. | CIO | -2642.01 | -547
DYNEGY POWER CORP. | CIO | -4.83 | -1
ENRON NORTH AMERICA CORP. | CIO | -15881.04 | -3288
FLORIDA GAS UTILITY | CIO | -88513.52 | -17844
FLORIDA POWER CORPORATION | CIO | -334419.54 | -69238
FLORIDA PUBLIC UTILITIES COMPANY | CIO | -53859.33 | -11151
HOUSTON PIPE LINE COMPANY | CIO | -61466.58 | -12726
LAKELAND, CITY OF | CIO | -64137.57 | -13279
NATIONAL GYPSUM COMPANY | CIO | -75611.72 | -17394
SOUTHEAST ALABAMA GAS DISTRICT | CIO | -21160.23 | -4381
TALLAHASSEE, CITY OF | CIO | -178879.05 | -37035
Total Due 14 Shippers
ADAMS RESOURCES MARKETING, LTD. | CIO | 518.88 | 0
ALABAMA POWER COMPANY | CIO | 5954.86 | 1144
AUBURNDALE POWER PARTNERS, L.P. | CIO | 5850 | 1125
BP ENERGY COMPANY | CIO | 863.2 | 166
CARGILL FERTILIZER,  INC | CIO | 15.6 | 3
CHESAPEAKE UTILITIES CORPORATION | CIO | 52 | 10
CINERGY MARKETING & TRADING, LLC | CIO | 6464.11 | 1115
CITRUS TRADING CORPORATION | CIO | 27123.2 | 5216
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 102087.16 | 17775
COASTAL MERCHANT ENERGY, L.P. | CIO | 3031.6 | 583
CORAL ENERGY RESOURCES, L.P. | CIO | 10.4 | 2
DUKE ENERGY TRADING AND MARKETING,L.L.C. | CIO | 97106.56 | 18390
EL PASO MERCHANT ENERGY, L.P. | CIO | 358.8 | 69
[NAME], L.P. | CIO | 4164.95 | 678
INFINITE ENERGY, INC. | CIO | 11824.8 | 2274
INFINITE ENERGY, INC. | CIO | 127394.8 | 24499
NOBLE GAS MARKETING, INC. | CIO | 36686 | 7055
OKALOOSA GAS DISTRICT | CIO | 59517.12 | 9538
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | 33098 | 6365
PRIOR INTRASTATE CORPORATION | CIO | 60264.88 | 11368
SOUTH FLORIDA NATURAL GAS, INC. | CIO | 5285.61 | 1015
UNOCAL ENERGY TRADING, INC. | CIO | 36400 | 7000
WESTERN GAS RESOURCES INC | CIO | 124.8 | 24
Total Due FGT   22 shippers
Spreadsheet: vkaminski__40982__CapitalTemplate1
Sheet: OurRating

 |  |  |  |  |  |  |  |  | USER INPUT
 |  |  |  |  |  |  |  |  |  | scaled linearly
 |  |  |  |  |  |  |  | Table | E-Rating | %Collateral Value | Capital Required Percentile
 |  |  |  |  | Enron Collateral % |  |  | AAA | 1 |  | 0.99
 |  | Enron Rating | D |  |  |  |  | AA+ | 1 |  | 0.99
 |  |  |  |  |  |  |  | AA | 2 |  | 0.97
 |  |  |  |  |  |  |  | AA- | 2 |  | 0.97
 |  |  |  |  | Capital Required Percentile |  |  | A+ | 2 |  | 0.97
 |  |  |  |  |  |  |  | A | 3 |  | 0.95
 |  |  |  |  |  |  |  | A- | 3 |  | 0.95
 |  |  |  |  |  |  |  | BBB+ | 4 |  | 0.9
 |  |  |  |  |  |  |  | BBB | 4 |  | 0.9
 |  |  |  |  |  |  |  | BBB- | 5 |  | 0.85
 |  |  |  |  |  |  |  | BB+ | 6 |  | 0.82
 |  |  |  |  |  |  |  | BB | 7 |  | 0.8
 |  |  |  |  |  |  |  | BB- | 8 |  | 0.78
 |  |  |  |  |  |  |  | [NAME] | 9 |  | 0.75
 |  |  |  |  |  |  |  | B | 9 |  | 0.75
 |  |  |  |  |  |  |  | B- | 10 |  | 0.73
 |  |  |  |  |  |  |  | CCC | 11 |  | 0.7
 |  |  |  |  |  |  |  | CC | 11 |  | 0.68
 |  |  |  |  |  |  |  | D | 12 |  | 0.65
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: Brownsville

 | PLANT LOCATION: |  | Brownsville, TN
 | Pipeline: |  | [NAME]
 | Delivery Point: |  | ANR ML-2
 | MW Output: |  | 454 MW
 | Heat Rate: |  | 11461
 | 16 Hour Gas Flow: |  | 83,253 [NAME]
 | Facility Costs: |  | $837,500  (ANR Pays, subject to IT crediting mechanism)
 | Start Date: |  | June, 1999
 | Transportation Arrangement:
 |  | [NAME] CONTRACT
 |  | Service: | IT/IPLS
 |  | Term: | 10 years (May - Sept)
 |  | Volume: | 83,253 MMBtu/d
 |  | Rate: | $.0922 plus fuel | Commodity
 |  | Fuel: | 0.0% on Backhaul; 2.91% on forward haul
 |  | Receipt Points: | SE Area, LA/Joliet, IL | Primary
 |  | Balancing: | $.015 per MMBtu/d out of balance
 |  |  | for volumes feed by IT contract
 |  |  | $.015 per MMBtu/d out of balance
 |  |  | for volumes feed by capacity release
 |  | FT BACK-UP CONTRACT
 |  |  | ECT has a one time right to convert to ETS
 |  |  | at any time during the first 5 years of the
 |  |  | agreement with 9/30/2004 termination.
 |  | Service: | ETS
 |  | Term: | up to 5 years (May - Sept)
 |  | Volume: | 85,253 MMBtu/d
 |  | Rate: | $.1153 | Demand
 |  |  | $.0169 plus fuel | Commodity
 |  | Receipt Points: | SE Area, LA/Joliet, IL | Primary
 | BALANCING:
 |  | IPLS at Plant Interconnect (limited to 84,000 [NAME])
 |  | IPLS service subject to economic dispatching and pipeline operational conditions
 |  | Balancing in-kind
 |  | Allows for uneven hourly flow at plant delivery point with even 24 hour supply flow
Spreadsheet: 31381d1227200688-using-lists-to-find-information-in-large-excel-db-book1_nov20
Sheet: Sheet1

[NAME] | Facility Name | Product Name | clean date
Comp A
 | Plant 1A | [NAME] | 2008-11-11 00:00:00
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 | Plant 2A | Prod A1000 | 2008-12-01 00:00:00
 |  | Prod A1001
Comp B
 | Plant 1B | Prod B1 | 2008-12-05 00:00:00
 |  | [NAME]
Spreadsheet: 723998d1615983408-creating-a-new-list-based-on-criteria-in-existing-column-and-map-new-columns-to-it-excel-dummy-data
Sheet: Sheet1

Choose: | Apartment | Property | Buyers April | Buyers May | Interested buyers ->
Spreadsheet: 96035d1295516439-first-and-last-instances-of-temperature-above-zero-by-date-book1
Sheet: Sheet1

Year | Month | Day | Date | Temperature |  | Year | 1st day >0 in Jan | Last day >0 in Jan | 1st day >0 in Feb | Last day >0 in Feb
2001 | 1 | 1 |  | -5 |  | 2001
2001 | 1 | 2 |  | -2 |  | 2002
2001 | 1 | 3 |  | -1
2001 | 1 | 4 |  | 1
2001 | 1 | 5 |  | 2
2001 | 1 | 6 |  | -2
2001 | 1 | 7 |  | -3
2001 | 1 | 8 |  | 1
2001 | 1 | 9 |  | 3
2001 | 1 | 10 |  | -3
2001 | 1 | 11 |  | -4
2001 | 1 | 12 |  | -5
2001 | 2 | 1 |  | -6
2001 | 2 | 2 |  | -4
2001 | 2 | 3 |  | -8
2001 | 2 | 4 |  | -3
2001 | 2 | 5 |  | -2
2001 | 2 | 6 |  | 1
2001 | 2 | 7 |  | 4
2001 | 2 | 8 |  | -6
2001 | 2 | 9 |  | 5
2001 | 2 | 10 |  | 3
2001 | 2 | 11 |  | -6
2001 | 2 | 12 |  | -5
2002 | 1 | 1 |  | -3
2002 | 1 | 2 |  | 2
2002 | 1 | 3 |  | -6
2002 | 1 | 4 |  | -5
2002 | 1 | 5 |  | 8
2002 | 1 | 6 |  | 6
2002 | 1 | 7 |  | -4
2002 | 1 | 8 |  | -6
2002 | 1 | 9 |  | -3
2002 | 1 | 10 |  | 2
2002 | 1 | 11 |  | 5
2002 | 1 | 12 |  | -3
2002 | 2 | 1 |  | 1
2002 | 2 | 2 |  | 2
2002 | 2 | 3 |  | -6
2002 | 2 | 4 |  | -4
2002 | 2 | 5 |  | 3
2002 | 2 | 6 |  | 5
2002 | 2 | 7 |  | 7
2002 | 2 | 8 |  | 1
2002 | 2 | 9 |  | -2
2002 | 2 | 10 |  | -1
2002 | 2 | 11 |  | -3
2002 | 2 | 12 |  | -5
Spreadsheet: 0c45b620-9d5c-4529-9b5f-77510a5b2de6
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Faculty of Mathematics and Sciences
Study Year | Major [NAME] |  |  |  | Enrolment Headcount
 |  | 1999-00 | 2000-01 | 2001-02 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08
 | Single | 243 | 238 | 187 | 228 | 503 | 537 | 426 | 350 | 421
 | Combined | 3 | 4 | 6 | 4 | 2 | 6 | 6 | 11 | 7
Year I | Sub-Total: | 246 | 242 | 193 | 232 | 505 | 543 | 432 | 361 | 428
 | Gen/Integ Studies | 11 | 49 | 37 | 39 | 49 | 24 | 43 | 59 | 83
 | Total: | 257 | 291 | 230 | 271 | 554 | 567 | 475 | 420 | 511
 | Single | 253 | 292 | 287 | 251 | 239 | 371 | 370 | 316 | 252
 | Combined | 16 | 11 | 10 | 16 | 8 | 15 | 17 | 15 | 14
Year II | Sub-Total: | 269 | 303 | 297 | 267 | 247 | 386 | 387 | 331 | 266
 | Gen/Integ Studies | 10 | 30 | 38 | 35 | 28 | 28 | 19 | 35 | 50
 | Total: | 279 | 333 | 335 | 302 | 275 | 414 | 406 | 366 | 316
 | Single | 376 | 318 | 312 | 303 | 246 | 202 | 302 | 297 | 235
 | Combined | 39 | 30 | 30 | 22 | 21 | 17 | 22 | 22 | 19
Year III | Sub-Total: | 415 | 348 | 342 | 325 | 267 | 219 | 324 | 319 | 254
 | Gen/Integ Studies | 26 | 23 | 45 | 38 | 42 | 37 | 38 | 21 | 35
 | Total: | 441 | 371 | 387 | 363 | 309 | 256 | 362 | 340 | 289
 | Single | 77 | 144 | 154 | 172 | 192 | 113 | 103 | 191 | 211
 | Combined | 17 | 22 | 14 | 16 | 19 | 8 | 8 | 20 | 18
Year IV | Sub-Total: | 94 | 166 | 168 | 188 | 219 | 121 | 111 | 211 | 229
 | Gen/Integ Studies | 2 | 46 | 37 | 33 | 52 | 39 | 31 | 40 | 34
 | Total: | 96 | 212 | 205 | 221 | 271 | 160 | 142 | 251 | 263
 | Single | 949 | 992 | 940 | 954 | 1180 | 1223 | 1201 | 1154 | 1119
 | Combined | 75 | 67 | 60 | 58 | 50 | 46 | 53 | 68 | 58
TOTAL: | Sub-Total: | 1024 | 1059 | 1000 | 1012 | 1230 | 1269 | 1254 | 1222 | 1177
 | Gen/Integ Studies | 49 | 148 | 157 | 145 | 171 | 128 | 131 | 155 | 202
 | Total: | 1073 | 1207 | 1157 | 1157 | 1401 | 1397 | 1385 | 1377 | 1379
 | Adjusted Total: | 1021 | 1176 | 1137 | 1136 | 1401 | 1397 | 1385 | 1377 | 1379
Male |  |  | 711 | 700 | 699 | 793 | 789 | 761 | 746 | 732
Female |  |  | 496 | 457 | 458 | 608 | 608 | 624 | 631 | 647
Full-Time |  |  | 997 | 924 | 934 | 1190 | 1192 | 1195 | 1181 | 1199
Part-Time |  |  | 210 | 233 | 223 | 211 | 205 | 190 | 196 | 180
Spreadsheet: 144048d1330696484-add-table-0177
Sheet: Sheet2

 |  |  |  | it | hr | fin | it
 |  |  | apple | 1 | 2 | 3 | 4
 |  |  | pear | 5 | 6 | 7 | 8
 |  |  | apple | 9 | 10 | 11 | 12
 |  |  | orange | 13 | 14 | 15 | 16
 |  | apple | it | 26 | 26
 |  | pear | it | 13 | 13
 |  | orange | it | 29 | 29
Spreadsheet: 68136d1268684894-time-based-calculation-ot-calcs
Sheet: Sheet1

 | Date |  | Start Time | End Time | Hours | Call Out
 |  |  |  |  |  |  |  |  | Manually | Calculated
 | 2010-01-04 00:00:00 | W | 17:30:00 | 03:00:00 | 9.5 | 1 |  | call out 23:00 - 02:00, 1 hr OT 02:00 - 03:00 | 1
 | 2010-01-05 00:00:00 | W | 1900-01-01 00:00:00 | 05:00:00 | 5 | 1 |  | Call out 00:00 - 03:00 0 hours OT | 0
 | 2010-01-06 00:00:00 | W | 18:00:00 | 03:00:00 | 9 | 1 |  | call out 23:00 - 02:00, 1 hr OT 02:00 - 03:00 | 1
 | 2010-01-07 00:00:00 | W | 07:30:00 | 15:30:00 | 8 | 0 |  | Nothing | 0
 | 2010-01-08 00:00:00 | W | 12:00:00 | 23:30:00 | 11.5 | 1 |  | Callout 23:00 - 23:30, 0 hours OT | 0
 | 2010-01-09 00:00:00 | S | 05:30:00 | 14:00:00 | 8.5 | 1 |  | [NAME], 0 hours OT | 0
 | 2010-01-10 00:00:00 | S | 23:00:00 | 06:00:00 | 7 | 1 |  | Callout 23:00 - 02:00, 4 hours OT - 06:00 | 4
 | 2010-01-11 00:00:00 | W | 18:30:00 | 02:30:00 | 8 | 1 |  | Callout 23:00 - 02:00, .5 hours OT - 02:30 | 0.5
 | 2010-01-12 00:00:00 | W | 18:30:00 | 22:59:00 | 4.483333333395422 | 0 |  | Nothing | 0
 | 2010-01-13 00:00:00 | W | 18:30:00 | 02:30:00 | 8 | 1 |  | Callout 23:00 - 02:00, .5 hours OT - 02:30 | 0.5
 | 2010-01-14 00:00:00 | W | 12:00:00 | 23:00:00 | 11 | 1 |  | Nothing | 0
 | 2010-01-15 00:00:00 | W | 18:30:00 | 01:30:00 | 7 | 1 |  | Callout 23:00 - 02:00, .5 hours OT - 02:30 | 0
 | 2010-01-16 00:00:00 | S | 18:30:00 | 06:00:00 | 11.5 | 1 |  | Callout 23:00 - 02:00, 4 hours OT - 06:00 | 4
 | 2010-01-17 00:00:00 | S | 21:00:00 | 22:00:00 | 1 | 0 |  | Nothing | 0
 | 2010-01-18 00:00:00 | W | 09:00:00 | 22:59:00 | 13.98333333339542 | 0 |  | Nothing | 0
 | 2010-01-19 00:00:00 | W | 21:00:00 | 09:00:00 | 12 | 1 |  | Callout 23:00 - 02:00, 4 hours OT - 06:00 | 4
 | 2010-01-20 00:00:00 | W | 1900-01-01 00:00:00 | 05:00:00 | 5 | 1 |  | Callout 00:00 - 03:00, 2 hours OT - 05:00 | 2
 | 2010-01-21 00:00:00 | W | 03:00:00 | 12:00:00 | 9 | 1 |  | Callout 03:00 - 06:00, 0 hours OT | 0
 | Overtime is Paid Between 23:00 and 06:00
 | A Flat rate (Call Out) covers the first 3 hours of a shift
 | A Call out can be claimed if you work ANY time between 23:00 and 06:00
 | Weekends are to be ignored
Spreadsheet: kevin_ruscitti__20264__NSS 2001 Rights
Sheet: Rights

Projected NSS Rights for 2001
Daily Contract Flexibilities |  |  | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | Total
Tariff | Total | MDIQ | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126 | 128126
Tafiff | Total | MDWQ | -179375 | -179375 | -179375 | -179375 | -179375 | -219150 | -219150 | -219150 | -179375 | -179375 | -179375 | -179375
PGLC Rights | Gulf | IQ | 42500 | 29000 | 29000 | 29000 | 29000 | 29000 | 42500 | 42500 | 42500 | 42500 | 42500 | 42500
PGLC Rights | Gulf | WQ | -75000 | -29166 | -29166 | -29166 | -29166 | -29166 | -75000 | -85000 | -40000 | -110000 | -110000 | -95000
EMW | Gulf | IQ
EMW | Gulf | WQ
EMW | Amarillo | IQ | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5 | 32031.5
EMW | Amarillo | WQ | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75 | -44843.75
Field Area Balancing
PGE | Gulf | IQ | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
NICOR | Gulf | IQ | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Coral | Gulf | IQ | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
PGE | Gulf | WQ | -40000 | -40000 | -40000 | -40000 | -40000 | -40000 | -40000
NICOR | Gulf | WQ | -20000 | -20000 | -20000 | -20000 | -20000 | -20000 | -20000 | -20000 | -20000
Coral | Gulf | WQ | -40000 | -40000 | -40000 | -40000 | -40000 | -40000 | -40000 | -40000 | -40000
EMW Remaining Rights
Net EMW | Gulf | IQ
Net EMW | Gulf | WQ
Net EMW | Amarillo | IQ
Net EMW | Amarillo | WQ
Demand Payments
 |  | MSV
 | PGE | 1000000
 | Coral | 1000000 | 44444 | 44444 | 44444 | 44444 | 44444 | 44444 | 44444 | 44444 | 44448
 | Nicor | 500000 | 18333 | 18333 | 18333 | 18333 | 18333 | 18333 | 18333 | 18333 | 18336
 | Notional Value
 | NSS Value |  | -89206 | -89206 | -89206 | -89206 | -89206 | -89206 | -89206 | -62777 | -62781
 | [NAME] (enovate value)
 | PV Factor |  | 0.9956068484949633 | 0.9915018403407411 | 0.9872621978860666 | 0.9833220269253253 | 0.979351417134367 | 0.9754308371961399 | 0.971646721003236 | 0.9677877859196865 | 0.9640397666013005
 | PV Value
Issues
 | April  and October Rights - Will PGLC utilize withdrawal of 75,000/d?
 | Daily/Monthly Communication
 | Inventory Tracking
Notes | *3rd Party Activity will not affect PGL inventory costs, carrying costs, or fuel costs.
Spreadsheet: 478229d1472682649-attendance-sheet-how-to-best-summarise-data-time-clock
Sheet: Sheet8

Row Labels
[NAME]
2016-08-31 00:00:00
06:54:00
15:30:00
2016-09-01 00:00:00
06:58:00
15:35:00
2016-09-02 00:00:00
06:45:00
15:28:00
2016-09-03 00:00:00
07:05:00
15:30:00
[NAME]
2016-08-31 00:00:00
5:55AM
14:30:00
2016-09-01 00:00:00
5:58AM
14:20:00
2016-09-02 00:00:00
5:59AM
14:29:00
[NAME]
2016-08-31 00:00:00
07:31:00
16:05:00
2016-09-01 00:00:00
07:17:00
16:10:00
2016-09-02 00:00:00
07:21:00
16:02:00
(blank)
(blank)
(blank)
Grand Total
Spreadsheet: 181254d1347976281-get-info-from-three-other-tabs-into-a-fourth-tab-for-one-single-entry-without-vba-solutiontest
Sheet: fees

State | County | Recorder | Name | PayableTo | SatisfactionFee | SatisfactionTerms | PagesFee | PagesTerms
NY | SUFFOLK | NRE |  | Department of Natural Resources | 20 | $5/P/2/ON
NY | [NAME] | NRE |  | Department of Natural Resources | 20 | $5/P/2/ON
FL | Pasco | ARA | Dotson | DEPARTMENT OF NATURAL RESOURCES | 20 | $5/P/2/ON
FL | Hillsborough | CDE | Dotson | DEPARTMENT OF NATURAL RESOURCES | 20 | $5/P/2/ON
GA | Kindest | DGG |  | Department of Natural Resources | 20 | $5/P/2/ON
PR | AGUADILLA | GDGGH |  | Department of Natural Resources | 20 | $5/P/2/ON
PR | Mayaguez | CDG |  | Department of Natural Resources | 20 | $5/P/2/ON
NV | Henderson | NER | Narias | DEPARTMENT OF REVENUE | 20 | $5/P/2/ON
FL | Polk | ARGG |  | Department of Natural Resources | 20 | $5/P/2/ON
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: Champion-Sun

DIVISION:      JUNIOR GIRLS
 | NAME | Home Town | Total Points
ALL AROUND:
RUNNER UP:
EVENT:  Trail Course |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT: Pole Bending |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT:  GOAT TYING |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT: Barrels |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT:  Breakaway |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
Spreadsheet: 697836d1601564372-sum-if-s-and-round-up-incorrect-formulae-tally-23
Sheet: sheet3

[NAME] |  |  |  |  | Price per Kilo Summary
Species | Presentation | Boxes | Total (Kg) |  | Species | Grade | Presenattion | Boxes | Lowest (Kg) Price | Highest (Kg) Price | [NAME]