tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 83674d1283684309-insert-to-first-blank-row-sample-budget
Sheet: -11-Summary

 |  |  | Production Budget Summary
 |  |  | #N/A
 |  |  | -11-
 |  |  | DEPT | DEPARTMENT |  | Original | Spent To | Amount | Updated | [NAME]
 |  |  | CODE | NAME |  | Budget | Date | Remaining | Forecast
 |  |  | 4018 | SALARY & BENEFITS - Set Designer |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4020 | SALARY & BENEFITS - Costume Designer |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4022 | SALARY & BENEFITS - Lighting Designer |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4028 | SALARY & BENEFITS - Sound Designer |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4030 | SALARY - Musicians |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4036 | SALARY & BENEFITS - Additional Running Crew |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4037 | SALARY - Stage Management |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4038 | SALARY - Casual Production Personnel/OT |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4040 | SALARY - Casual Wardrobe Personnel/OT |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4042 | SALARY - Running Crew |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4044 | SALARY - Staff Construction Crew |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4046 | SALARY - Additional Construction Crew |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4049 | ACCOMODATION - Designers |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4054 | TRAVEL - Designers |  | 1800 | 74.25 | 425.75 | 500 | -1300
 |  |  | 4058 | TRAVEL - Other |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 4060 | MATERIALS - Set |  | 6500 | 3850.46 | 2649.54 | 6500 | 0
 |  |  | 4062 | MATERIALS - Properties |  | 4000 | 2090.66 | 1909.34 | 4000 | 0
 |  |  | 4064 | MATERIALS - Costumes |  | 10000 | 1084.38 | 8715.62 | 9800 | -200
 |  |  | 4066 | MATERIALS - Wigs,Make-up,Hair |  | 3000 | 0 | 3000 | 3000 | 0
 |  |  | 4068 | SERVICE - Shop to Theatre Set/Prop Delivery |  | 200 | 277.53 | 322.47 | 600 | 400
 |  |  | 4070 | MATERIALS - Designer Model/Plans |  | 200 | 0 | 200 | 200 | 0
 |  |  | 4071 | MATERIALS - Paint |  | 1100 | 1110.61 | -10.61000000000013 | 1100 | 0
 |  |  | 4072 | MATERIALS - Sound |  | 200 | 0 | 200 | 200 | 0
 |  |  | 4074 | MATERIALS - Special Effects |  | 0 | 0 | 0 | 0 | 0
 |  |  | 4076 | MATERIALS - Additional Lighting Materials |  | 500 | 0 | 500 | 500 | 0
 |  |  | 4078 | MATERIALS - Band Equipment |  | 0 | 0 | 0 | 0 | 0
 |  |  | 4082 | MATERIALS - Running Costs |  | 1000 | 0 | 1000 | 1000 | 0
 |  |  | 4094 | SERVICE - Equity OT/Fees/Penalties |  | 2093.54 | 0 | 2093.54 | 2093.54 | 0
 |  |  | 4098 | MISCELLANEOUS - Other Production Costs |  | 200 | 180.35 | 19.64999999999998 | 200 | 0
 |  |  |  |  | TOTAL SHOW RESULTS | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 844118d1695908344-calc-in-table-shows-different-results-forum
Sheet: Exc 2

Count: |  |  |  |  | Beg + end / 2 | # that falls in that range | mid x freq
 | 101 |  |  | Class | X (mid) | F (Freq) | x*f | x-x bar | x-x bar sq | x - xb sq xf
 | 108 |  | 101 | 112 | 106.5
 | 111 |  | 113 | 124 | 118.5
 | 114 |  | 125 | 136 | 130.5
 | 116 |  | 137 | 148 | 142.5
 | 117 |  | 149 | 160 | 154.5
 | 118
 | 119 |  |  |  |  | Count | Sum | sum/count=mean
 | 119
 | 120
 | 120
 | 123
 | 123
 | 124
 | 127
 | 127
 | 128
 | 130
 | 131
 | 131
 | 132
 | 135
 | 139
 | 139
 | 142
 | 150
 | 157
Spreadsheet: 295203d1391622009-further-temporal-comparison-situation-use-fee-waiver
Sheet: Sheet1

Last Digit of Employer’s EIN | Plans Cycle | Employer EIN | Cycle | Last Day of  EGTRRA RAP Cycle | First Day of Next 5 Year  EGTRRA RAP Cycle | Last Day of Next 5 Year  EGTRRA RAP Cycle | Control Date | Control Date Less Than or Equal to LDN5YERC | Ten Years prior to FDN5YERC | Plan Established? | Plan Established Later Than or Equal to Ten Years Prior to FDN5YERC |  | Waiver | Due
0 | A | 5 |  | 2007-01-31 00:00:00 |  | 2012-01-31 00:00:00 | 2012-01-28 00:00:00 |  |  | 2001-12-31 00:00:00
1 | B | 6 |  |  |  | 2013-01-31 00:00:00 | 2013-02-01 00:00:00 |  |  | 2001-12-31 00:00:00
 | C | 2 |  |  |  | 2014-01-31 00:00:00 | 2013-05-04 00:00:00 |  |  | 2002-12-31 00:00:00
 | D | 3 |  |  |  | 2015-01-31 00:00:00 | 2014-11-15 00:00:00 |  |  | 2003-12-31 00:00:00
 | E | 4 |  |  |  | 2016-01-31 00:00:00 | 2015-06-17 00:00:00 |  |  | 2004-12-31 00:00:00
 | A | 5
6 | B
7 | C
8 | D
9 | E
Spreadsheet: 48681d1247914321-using-match-function-with-multiple-headers-drumselection
Sheet: Sheet1

 |  |  |  |  |  |  | FABRIC | 160
 |  |  |  |  |  |  | DRUM TYPE | 1
 |  |  |  |  |  |  | PLIES | 3
 |  |  |  | 315 |  |  | CATEGORY | 2
 |  |  |  | CATEGORY | PLIES
 |  |  |  |  |  | 100 | 100 | 100 | 125 | 125 | 125 | 160 | 160 | 160 | 200 | 200 | 200 | 250 | 250 | 250
 |  |  |  |  |  | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3
 |  |  |  | 3 | 2 | 160 | 160 | 125 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200
 |  |  |  | 3 | 3 | 200 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  | 3 | 4 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
 |  |  |  | 3 | 5 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630
 |  |  |  | 3 | 6 |  |  |  | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630 | 1250 | 1000 | 800
 |  |  |  | 2 | 2 | 160 | 125 | 125 | 200 | 160 | 160 | 200 | 160 | 160 | 250 | 200 | 160
 |  |  |  | 2 | 3 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315
 |  |  |  | 2 | 4 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  | 2 | 5 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
 |  |  |  | 2 | 6 |  |  |  | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630
 |  |  |  | 1 | 2 | 125 | 125 | 125 | 160 | 160 | 160 | 160 | 160 | 160 | 200 | 200 | 160
 |  |  |  | 1 | 3 | 160 | 160 | 160 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250
 |  |  |  | 1 | 4 | 200 | 160 | 160 | 250 | 200 | 200 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315
 |  |  |  | 1 | 5 | 250 | 200 | 200 | 315 | 250 | 250 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  | 1 | 6 |  |  |  | 400 | 315 | 315 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
Spreadsheet: phillip_m_love__31144__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
[NAME] on 11/02/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Kobayashi Yoko Co Limited | YG8034.1 | F | DUBA | [NAME] (Enron Japan)
National Energy & Trade, LLC | YG7967.1 YG7998.1 | F | NG | [NAME]
Wasatch Energy LLC | YG8086.1 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Barclays Capital Inc. | YG6114.1 | F | NG | Barclays Bank PLC
Conectiv, Inc. | YG8699.1 | F | NG | Conectiv Energy Supply, Inc.
Dominion Resources Inc. | YG7591.1 YG7592.1 YG8364.1 YG8366.1 YG8368.1 YG8369.1 | F | NG | Dominion Exploration & Production Inc.
Dominion Trading & Transport Inc. | YG7624.1 YG7625.1 YG7921.1/2 | F | NG | Dominion Exploration & Production Inc.
Entre Energy Corporation | YG8294.1 | F | NG | Enterprise Products Operating Company
Fletcher Challenge Energy Canada | YG8741.1 | F | NGGJ | Fletcher Challenge Industries Limited
PG&E Energy Trading-Power, LP | YG7937.1 | F | NG | PG&E Energy Trading-Gas Corporation
Southern Natural Gas Company | YG8150.2 | P | NG | Southern Natural Gas Pipeline
Valero Energy Corporation | YG8767.1 | F | HO | Valero Marketing & Supply Company
Spreadsheet: 813186d1673605857-using-if-formula-to-autofill-another-cell-for-multiple-options-group-tracking
Sheet: Sheet1

Group | Italy Invite | [NAME] | Booklet
Group A |  | No | No
Group B |  | Yes | No
Group C |  | Yes | No
Group D |  | Yes | No
Group E |  | No | Yes
Spreadsheet: 27353d1220536311-copying-cells-between-worksheets-example-spreadsheet-for-help
Sheet: Tech

Cycle Time Targets
 |  | Duration (Days)
Target | Room | Step 1 | Step 2 | Step 1 ([NAME]) | Step 2 ([NAME]) | Step 3 | Overall Time
 | A123 | 1 | 5 | 5 | 5 | 6 | 22
 | B1234 | 1 | 5 | 5 | 5 | 6 | 22
Score Card
Batch | Room | Step 1 | Step 2 | Step 1 ([NAME]) | Step 2 ([NAME]) | Step 3 | Overall Time
123415 | A123 | 3 | 9 | 5 | 7 | 7 | 31
 | B1234 | 3 | 9 | 5 | 7 | 7 | 31
14546 | A123 | 3 | 6 | 5 | 11 | 1 | 16
 | B1234 | 0 | 0 | 0 | 0 | 0 | 0
153451 | A123 | 0 | 0 | 0 | 0 | 0 | 0
 | B1234 | 0 | 0 | 0 | 0 | 0 | 0
0 | A123 | 0 | 0 | 0 | 0 | 0 | 0
 | B1234 | 0 | 0 | 0 | 0 | 0 | 0
0 | A123 | 0 | 0 | 0 | 0 | 0 | 0
 | B1234 | 0 | 0 | 0 | 0 | 0 | 0
0 | A123 | 0 | 0 | 0 | 0 | 0 | 0
 | B1234 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: vkaminski__40664__Position_030200
Sheet: GlobalPosition

 |  |  |  |  |  |  |  |  | Mark to Market ( R$ )
 |  |  |  |  | Global  Volumes ( MWh ) |  |  |  | Long Positions |  | Short Positions
 |  |  |  |  | Peak | Off-Peak | I.P. | [NAME] | Peak | Off-Peak | Peak | Off-Peak | NPV Invest. | Acumul.
 |  |  | 1 - Price  S - Peak
 |  |  | 2 - Price  S - Off Peak
 |  |  | 3 - Price  SE - Peak
 |  |  | 4 - Price  SE - Off Peak
 |  |  | 5 - Price  N - Peak
 |  |  | 6 - Price  N - Off Peak
 |  |  | 7 - Price  NE - Peak
 |  |  | 8 - Price  NE - Off Peak
 |  |  | 9 - VN - Biomass
 |  |  | 10 - VN - PCH
 |  |  | 11 - VN - Competitiva
 |  |  | Totals
 |  |  |  |  | Long   Positions
 |  |  |  |  | [NAME] ( MWh ) |  |  |  | Mark to Market ( R$ )
 |  |  |  |  | Peak | Off-Peak | I.P. | [NAME] | Peak | Off-Peak | NPV Invest. | Acum.
 |  |  | 1 - Price  S - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2 - Price  S - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3 - Price  SE - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4 - Price  SE - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 5 - Price  N - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 6 - Price  N - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 7 - Price  NE - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 - Price  NE - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 - VN - Biomass |  | -5470.601203541029 | -54309.972350189 | 0 | 0 | 384135.4025708628 | 3816233.535596058 | 0
 |  |  | 10 - VN - PCH |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 - VN - Competitiva |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Totais
 |  |  |  |  | Short   Positions
 |  |  |  |  | [NAME] ( MWh ) |  |  |  | Mark to Market ( R$ )
 |  |  |  |  | Peak | Off-Peak | I.P. | [NAME] | Peak | Off-Peak | NPV Invest. | Acum.
 |  |  | 1 - Price  S - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2 - Price  S - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3 - Price  SE - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4 - Price  SE - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 5 - Price  N - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 6 - Price  N - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 7 - Price  NE - Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 - Price  NE - Off Peak |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 - VN - Biomass |  | 5470.601203541029 | 54309.972350189 | 0 | 0 | -7.469971227364523e-12 | -4.705810978941577e-11 | 0
 |  |  | 10 - VN - PCH |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 - VN - Competitiva |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Totais
Spreadsheet: 9e7cb5cf-81b5-4f5e-83db-097fe47e31f6
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
CTF | Test | CTF | Colorado Tick Fever Antibody, IFA | Colorado Tick Fever Antibody, IFA | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL serum  refrigerated.  NOTE: Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.25 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icteric	NA | Reference Ranges:  IgG <1:16 IgM <1:20   Recent or current Colorado [NAME] is indicated by a four- fold or greater rise in IgG titer between acute and convalescent sera and/or an IgM level of 1:20 or greater.   Test Performed by: Focus Diagnostics, Inc                              5785 Corporate Avenue                              Cypress, CA 90630-4750 | Tuesday and Friday | 1 - 5 days | 3 - 7 days | 2 | 86790 |  |  |  |  | Focus Diagnositics, Inc.
CTF | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
CTF | Result | Z0583 | Colorado [NAME] IgG Ab | Colorado [NAME] IgG Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CTF | Result | Z0306 | Colorado Tick Fever IgM Ab | Colorado Tick Fever IgM Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CTF | Result | Z0307 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 43976d1242655522-sharehouse-splitting-the-bill-sharehouse-expenses
Sheet: Cuz

Cuz Expenses |  |  |  | Cost Breakdown
Description | Cost | X Split | Individual share | Himself | [NAME] | Nate | Ant | total check
nil | 0 | 0
 |  |  | Total
Spreadsheet: 209085d1359016256-filter-data-by-key-in-criteria-keyinfilterdata-1-
Sheet: Sheet2

 | Sales group | Sales district | Sales office |  | Customer A | [NAME]
 | ZAC | ZAD | ZAA |  | 100989 | 1994-08-04 00:00:00
 |  |  |  |  | 104347 | 2007-10-02 00:00:00
Spreadsheet: 866770d1713690742-conditional-sum-through-many-sheets-debit-notes-copy
Sheet: Client Summary

 | Client:
 | Year:
 | Bulk Carrier Vessels: |  |  |  |  | Persons Fixing This Account
 | Container Vessels: |  |  |  |  | Name |  | Code | Total Commission
 | Total: |  |  |  |  | person1 |  | p1
 |  |  |  |  |  | person2 |  | p2
 |  |  |  |  |  | person3 |  | p3
 | Commissions |  |  |  |  | person4 |  | p4
 | Due:
 | Received:
 | Total:
 | Vessel List
 | Bulk Carriers |  |  |  |  | Containers
 | Name | [NAME] | Year Built | Owned |  | Name | TEU | Year Built | Owned
 | v1 | 30000 | 2011 | Yes |  | v4 | 1000 | 2021 | Yes
 | v2 | 36000 | 2013 | Yes |  | v5 | 22000 | 2011 | Yes
 | v3 | 30000 | 2011 | Yes
Spreadsheet: 59419d1259914499-create-a-list-from-pivot-table-field-rows-testlist
Sheet: Sheet1

Name | skill
emp3 | skill 1
emp3 | skill 2
emp4 | skill 3
emp2 | skill 1
emp5 | skill 2
emp3 | skill 4
emp3 | skill 1
emp6 | skill 2
emp3 | skill 3
emp3 | skill 1
emp3 | skill 4
emp3 | skill 4
emp3 | skill 4
emp7 | skill 4
emp3 | skill 4
emp3 | skill 4
emp3 | skill 4
emp2 | skill 4
[NAME] | skill 4
emp2 | skill 2
emp3 | skill 3
emp9 | skill 1
emp3 | skill 2
emp3 | skill 3
emp2 | skill 1
emp9 | skill 2
[NAME] | skill 3
emp3 | skill 1
emp3 | skill 2
emp3 | skill 3
emp1 | skill 1
emp1 | skill 2
emp1 | skill 3
Spreadsheet: 491613d1480548946-calculating-employee-bonuses-based-on-salary-and-tenure-bonuscalcs
Sheet: Sheet1

Bonus Date | 2016-12-31 00:00:00
Bonus Pool | 400000 |  |  |  |  |  |  | 0.33 | 0.33
 |  | Employee Name | Date of Hire | Days Since Hire | Days as a % of All Days | Annual Salary | [NAME] as a % of All Salaries | Bonus Amount
 |  | Employee A | 2014-01-01 00:00:00 |  |  | 80000
 |  | Employee B | 2014-07-01 00:00:00 |  |  | 70000
 |  | Employee C | 2015-02-01 00:00:00 |  |  | 100000
 |  | Employee D | 2015-08-01 00:00:00 |  |  | 60000
 |  | Employee E | 2015-12-15 00:00:00 |  |  | 200000
 |  | Employee F | 2016-01-01 00:00:00 |  |  | 150000
 |  | Employee G | 2016-04-01 00:00:00 |  |  | 90000
 |  |  | Total payroll
Spreadsheet: 770106d1645810275-tracing-and-summing-from-numerous-sheet-sumifs-qs2-v2
Sheet: Google Analytics

Channel | Channel | Sub-Channel | Sessions | Transactions | Revenue
B26 | B7 | C16 | 95 | 0 | 0
B17 | B43 | C10 | 14 | 0 | 0
B17 | B43 | C10 | 1 | 0 | 0
B42 | B33 | C17 | 30 | 0 | 0
B26 | B7 | C16 | 60 | 1 | 169.7531111111111
B17 | B43 | C10 | 1 | 0 | 0
B27 | B37 | C26 | 66 | 0 | 0
B36 | B32 | C20 | 567 | 36 | 2460.045111111111
B37 | B5 | C15 | 53992 | 1144 | 100183.9622222222
Spreadsheet: 225103d1364896744-help-with-timetable-lesson-planner
Sheet: Y10 LESSONS

 |  | Week | Monday | TUESDAY 1 | TUESDAY 6 | Thursday | Friday
 | 2011-09-05 00:00:00 | 1
 | 2011-09-12 00:00:00 | 2
 | 2011-09-19 00:00:00 | 3
 | 2011-09-26 00:00:00 | 4
 | 2011-10-03 00:00:00 | 5
 | 2011-10-10 00:00:00 | 6
 | 2011-10-17 00:00:00 | 7
 | 2011-10-24 00:00:00
 | 2011-10-31 00:00:00 | 8
 | 2011-11-07 00:00:00 | 9
 | 2011-11-14 00:00:00 | 10
 | 2011-11-21 00:00:00 | 11
 | 2011-11-28 00:00:00 | 12
 | 2011-12-05 00:00:00 | 13
 | 2011-12-12 00:00:00 | 14
 | 2011-12-19 00:00:00
 | 2011-12-26 00:00:00
 | 2012-01-02 00:00:00 | 15
 | 2012-01-09 00:00:00 | 16
 | 2012-01-16 00:00:00 | 17
 | 2012-01-23 00:00:00 | 18
 | 2012-01-30 00:00:00 | 19
 | 2012-02-06 00:00:00 | 20
 | 2012-02-13 00:00:00
 | 2012-02-20 00:00:00 | 21
 | 2012-02-27 00:00:00 | 22
 | 2012-03-05 00:00:00 | 23
 | 2012-03-12 00:00:00 | 24
 | 2012-03-19 00:00:00 | 25
 | 2012-03-26 00:00:00 | 26
 | 2012-04-02 00:00:00
 | 2012-04-09 00:00:00
 | 2012-04-15 00:00:00 | 27 |  | P&P CHARACTER QUOTES - match lines to characters | P&P READ CH 15&16 - NOTES ON WICKHAM | P&P READ CH 17&18 - DARCY AND WICKHAM
 | 2012-04-22 00:00:00 | 28 | REVISE ROMEO | REVISE OMAM | REVISE ANTHOLOGY | REVISE WRITING
 | 2012-04-29 00:00:00 | 29 | MATHS EXAM | LANG EXAM | REVISE P&P | MATHS EXAM
 | 2012-05-06 00:00:00 | 30 | BANK HOL | LIT EXAM | P&P - DVD | P&P - CH 19 - COLLINS' PROPOSAL
 | 2012-05-13 00:00:00 | 31 | ANTHOLOGY - | P&P- READING | P&P - DVD | ANTHOLOGY -
 | 2012-05-20 00:00:00 | 32 | P&P- READING | P&P- READING | P&P - DVD | P&P - DVD
 | 2012-05-27 00:00:00
 | 2012-06-03 00:00:00 | 33
 | 2012-06-10 00:00:00 | 34
 | 2012-06-17 00:00:00 | 35
 | 2012-06-24 00:00:00 | 36
 | 2012-07-01 00:00:00 | 37
 | 2012-07-08 00:00:00 | 38
 | 2012-07-15 00:00:00 | 39
 | 2012-07-22 00:00:00 | 40
Spreadsheet: 705181d1605903927-help-with-sumproduct-formula-to-disregard-a-column-if-not-applicable-sample-file-2
Sheet: what I want it to be

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lookup
Location 2 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Arizona | 15 |  |  |  | Location 1 | Arizona
 |  |  |  |  |  |  |  |  |  | Landscaper |  | Arizona | 32 |  |  |  | Location 2 | Arizona
Arizona |  |  |  |  |  |  |  |  |  | Manager |  | Arizona | 50 |  |  |  | Location 3 | Colorado
 |  |  |  |  |  |  |  |  |  | Housekeeper | Location 1 | Arizona | 15.5 |  |  |  | Location 4 | Colorado
 |  |  |  |  |  |  |  |  |  | Landscaper | Location 1 | Arizona | 28 |  |  |  | Location 5 | Colorado
Job | Start Date | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  |  | Manager | Location 1 | Arizona | 52 |  |  |  | Location 6 | Virginia
Housekeeper | 2021-01-01 00:00:00 | 15 | 15 | 15 |  |  |  |  |  | Housekeeper |  | Colorado | 17 |  |  |  | Location 7 | Virginia
Landscaper | 2021-01-01 00:00:00 | 32 | 32 | 32 |  |  |  |  |  | Landscaper |  | Colorado | 29 |  |  |  | Location 8 | Virginia
Manager | 2021-03-01 00:00:00 | 0 | 0 | 50 |  |  |  |  |  | Manager |  | Colorado | 60 |  |  |  | Location 9 | Virginia
 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Virginia | 14
 |  |  |  |  |  |  |  |  |  | Landscaper |  | Virginia | 30
 |  |  |  |  |  |  |  |  |  | Manager |  | Virginia | 55
 |  |  |  |  |  |  |  |  |  | Manager | Location 7 | Virginia | 59
Spreadsheet: kate_symes__18104__Deal Correction 12-20
Sheet:  Current  Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-12-20 00:00:00 | 2000-12-20 00:00:00 | 2000-12-19 00:00:00 | LTNW | MS | MS | Prebon | From buy to sell/From SP to NP |  | 482606 | NP-15 | Cal-01 | On [NAME] | 25 | 250 | Merrill
 | 2000-12-20 00:00:00 | 2000-12-20 00:00:00 | 2000-12-19 00:00:00 | LTNW | MS | MS | Prebon | From forward to swap deal |  | Killed 482843/Created 483771 | Mid-C | Cal-03 | RTC | 25 | 71 | Morgan
 |  |  |  | MS Count
 | 2000-12-20 00:00:00 | 2000-12-20 00:00:00 | 2000-12-19 00:00:00 | LTNW | KS | Houston | Prebon | Deleted extra strips created when deal term changed |  | 482593 | COB N/S | Cal-02 | On [NAME] | 25 | 117 | Sempra
 |  |  |  | KS Count
 |  |  |  | Grand Count
Spreadsheet: 327939d1403726096-conditional-formatting-or-addition-to-existing-formula-daily-sheet
Sheet: Sheet1

Green | RTN# | 3
Hot Food | #
Friday - 1 | 0 |  | formulas that is in cells in column b is
*Fish and Chips (Frozen) 54325.1 | 1 |  | IFERROR(INDEX('UH'!$D$8:$K$352,MATCH(a5,'UH'!$A$8:$A$352,0),MATCH($D$1,'UH'!$D$5:$J$5,0)),0)
*Spicy Black Bean Quesadilla-B,... 56953 | 2 |  | so I need to add something to the formula or make a conditional format…I think!
 | 0 |  | Would like column B to show only the numbers that match the rotation week of 1, 2 or 3
 | 0 |  | which is found in cell C1
Friday - 2 | 0
*Fish and Chips (Frozen) 54325.1 | 3
*Sweet and [NAME] 57379 | 4
 | 0
 | 0
Friday - 3 | 0
*Fish and Chips (Frozen) 54325.1 | 4
*Autumn Tortellini-B,V 54273 | 5
 | 0
 | 0
Spreadsheet: larry_campbell__21589__Winter_icap_auction_monthly_bid_form_09-27-01_19_30
Sheet: Apr OPP

SUBMIT TO: |  |  |  |  |  | New York Independent System Operator
[EMAIL] |  |  |  |  |  | Installed Capacity (UCAP) Monthly Auction
 |  |  |  |  |  | Bids to Purchase
Auction Month: |  | April |  | 1 |  |  | Date submitted:
 |  |  |  | Submittal Number
Registrant Name: |  |  |  |  |  |  | Time submitted:
 |  |  |  |  |  |  | Location of Capacity to be Purchased
Use Only For Monthly Auction |  |  |  |  | In each location you must enter the number 1 for yes or 0 for no*
 |  |  |  |  | Capacity must be |  | Capacity can be located
 |  |  |  |  | located here |  | in any of the following areas
 | Purchaser's | Maximum Price | Amount (MW) | Total
Bid # | Name | [($/kW- per 1 month) | [express to | Bid ($) | NYC | LI | PJM-ISO | ISO-NE | HQ | O-IMO
 |  | express to nearest $.01] | nearest 0.1 MW]
1 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Instructions:
* Rest of State - New York Control Area outside of New York City & Long Island
 | Do Not Delete Yellow Row
 | Do Not Enter Information
 | Contact Name: |  |  |  |  |  | Contact Phone#:
 |  |  |  |  | Comments:
 | Company Name:
 | Company Address:
 | Contact E-Mail:
Short Name
1stRoch
3mP&P
AdvantEn
AEPSysOp
AESCreRe
AESEastE
AESNuEn
AgwayES
AllegEnS
AllegPwr
AmerHess
AmherUtl
AquilEPM
AstGenCo
BlueCir
CanaEmir
CanNiaPwr
CargAlli
CHEnt
CHGE
CingyEnM
CingySvr
CityBuff
CoastMEn
ColumEN
ConecEn
ConEdEn
ConEdNY
[NAME]
ConstPwr
ConSuPwL
CoralPwr
CountEri
CountMon
CountNia
[NAME]
DynegyPM
EastCoas
ECNY
Econnerg
EdisnMMT
Electrox
ElPasMEn
EmpiNatG
Energetx
EnronEnS
EnronPM
EntNucIP
EntNukFz
EntPwrM
Essent
FedEG
FiberEn
FortUSEn
FPLEnPwM
Freeport
FrtDrum
FstEnTSv
GrtBayPw
HessEn
HQEnSvUS
IndCorin
IndIllio
IndOlean
IndOsweg
IndYerks
IntlPapr
ISODfAPR
ISODfAUG
ISODfDEC
ISODfFEB
ISODfJAN
ISODfJUL
ISODfJUN
ISODfMAR
ISODfMAY
ISODfNOV
ISODfOCT
ISODfSEP
ISOMoAPR
ISOMoAUG
ISOMoDEC
ISOMoFEB
ISOMoJAN
ISOMoJUL
ISOMoJUN
ISOMoMAR
ISOMoMAY
ISOMoNOV
ISOMoOCT
ISOMoSEP
isostrpS
isostrpW
ISOSuApr
ISOSuAug
ISOSuDec
ISOSuFeb
ISOSuJan
ISOSuJul
ISOSuJun
ISOSuMar
ISOSuMay
ISOSuNov
ISOSuOct
ISOSuSep
[NAME]
Kaleida
KeySpEn
KeySpRav
KochEnT
LIPA
LockpEnA
MEGA
MetroEN
Metrogen
MirabiGE
MLCS
MorgStan
NatlFuel
NEPAEn
NEUtilSv
NewLSE
NewSuppl
NFRPwr
NIMOEM
NIMOPC
NRGPwrM
NYMPA
NYPA
NYSEG
NYSEGSol
OccidChm
OnonCogn
OntPwrGn
OrionEnS
ORUtil
OutHQ
OutIMO
OutNE
OutPJM
PECoEn
PGENTPwr
PPLEnPl
Praxair
PrimPwrM
ProjOrgA
PSCoCol
PSEG
PSEGEnRT
PSEGEnT
RelintEn
RGE
RockvCtr
SelEn
SelkCogn
SemprEnt
SenecaEn
SenecaFL
SingRobO
[NAME]
SithePwM
SmartEn
SMEC
SoCoEnM
StatEnSv
StratgEn
StratgPM
SUNYBuff
TGE
TMassena
TopsMkts
TranAEnM
TrnCanPM
TXUEnSev
UofR
VirgPwrM
Wegmans
WeschRes
WestNYWi
WillEnMT