tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 583872d1532706539-counting-how-many-players-played-a-game-with-percentages-copy-of-excelhelp2-saulgodman-
Sheet: Question

All user id's | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 |  | How many % of players played on Day 1 and Day 2?
[NAME] | [NAME] | [NAME] | [NAME] 20 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] 23 | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] 21 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] 23 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] 26 | [NAME] | [NAME]
[NAME] | [NAME] 10 | [NAME] 20 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] 21 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] 26 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] 29 | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] 23 | [NAME] | [NAME] 20 | [NAME] | [NAME] | [NAME] | [NAME] 30 | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] 23 | [NAME] | [NAME] 20 | [NAME] | [NAME] 26 | [NAME] | [NAME]
[NAME] 10 | [NAME] | [NAME] | [NAME] 29 | [NAME] | [NAME] | [NAME] 21 | [NAME] 10 | [NAME] | [NAME] | [NAME] 10
[NAME] | [NAME] | [NAME] 26 | [NAME] 30 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] 26 | [NAME] | [NAME] 23 | [NAME] | [NAME] 29 | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] 32 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] 30 | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] 15 |  |  | [NAME] 34 | [NAME] 29 | [NAME] | [NAME] 26 | [NAME] 15 | [NAME] 32 | [NAME] 10 | [NAME] 15
[NAME] |  |  |  | [NAME] 30 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  | [NAME] |  | [NAME] | [NAME] 32 | [NAME] 34 | [NAME]
[NAME] |  |  |  |  |  | [NAME] 29 | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] 30 | [NAME] 34 | [NAME] 26 | [NAME]
[NAME] 20 |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] 15
[NAME] 21 |  |  |  |  |  | [NAME] 32 | [NAME] 36 | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME]
[NAME] 23 |  |  |  |  |  | [NAME] 34 | [NAME] 38
[NAME]
[NAME]
[NAME] 26
[NAME]
[NAME]
[NAME] 29
[NAME] 30
[NAME]
[NAME] 32
[NAME]
[NAME] 34
[NAME]
[NAME] 36
[NAME]
[NAME] 38
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 004ec620-1f8a-4d2c-a65b-ead06179a700
Sheet: Sheet1

WADDELL & REED FINANCIAL INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
SC 13G/A
02/07/2013
Cognizant Technology Solutions Corporation
1 |  | NAME OF REPORTING PERSON (S.S. or I.R.S.
 |  | Identification No. of Above Person)
 |  | Ivy Investment Management Company Tax
 |  | ID No. 03-0481447
2 |  | CHECK THE APPROPRIATE BOX IF A MEMBER OF
 |  | A GROUP :
 |  | (a) [ ]
 |  | (b) [ ]
3 |  | SEC USE ONLY
4 |  | CITIZENSHIP OR PLACE OF ORGANIZATION :  Delaware
NUMBER OF SHARES BENEFICIALLY OWNED BY
EACH REPORTING PERSON WITH :
 |  | 5. SOLE VOTING POWER |  | 7,962,750 (See Item 4)
 |  | 6. SHARED VOTING POWER |  | 0
 |  | 7. SOLE DISPOSITIVE POWER |  | 7,962,750 (See Item 4)
 |  | 8. SHARED DISPOSITIVE POWER |  | 0
9 |  | AGGREGATE AMOUNT BENEFICIALLY OWNED BY
 |  | EACH REPORTING PERSON :  7,962,750 (See
 |  | Item 4)
10 |  | CHECK IF THE AGGREGATE AMOUNT IN ROW 9 EXCLUDES
 |  | CERTAIN SHARES :  [ ]
11 |  | PERCENT OF CLASS REPRESENTED BY AMOUNT
 |  | IN ROW 9 :  2.7
12 |  | TYPE OF PERSON REPORTING :  IA
Spreadsheet: 779356d1651739103-formula-to-get-difference-between-2-amounts-with-one-condition-get-actual-difference
Sheet: Matched

Line | As Per | [NAME] of supplier | XYZ | ABC | JKL | Integrated Tax | DEF | GHI | Remarks | Difference |  | formula applied in J
2253 | PORTAL | 06XXXCX2096X1XX |  |  |  | 820.8 |  |  |  |  |  | =IF(MATCH(1,((ABS(H2-$H$2:$H$23200)<=1))*(C2=$C$2:$C$23200)*(B2<>$B$2:$B$23200),0),"Matched","")
5641 | TALLY | 06XXXCX2096X1XX |  |  |  | 820.8
2748 | PORTAL | 06XXXCX2096X1XX |  |  |  | 1111.86
5642 | TALLY | 06XXXCX2096X1XX |  |  |  | 1111.86
4472 | PORTAL | 06XXEFE2449P1X4 |  |  |  | 742.5
5656 | TALLY | 06XXEFE2449P1X4 |  |  |  | 743
4450 | PORTAL | 06XXFCC9473R1XT |  |  |  | 14.52
5666 | TALLY | 06XXFCC9473R1XT |  |  |  | 14.52
4048 | PORTAL | 06XXFCC9473R1XT |  |  |  | 45.48
5664 | TALLY | 06XXFCC9473R1XT |  |  |  | 45.52
4046 | PORTAL | 06XXFCC9473R1XT |  |  |  | 51.78
5662 | TALLY | 06XXFCC9473R1XT |  |  |  | 51.78
3588 | PORTAL | 06XXFCC9473R1XT |  |  |  | 68.23
5661 | TALLY | 06XXFCC9473R1XT |  |  |  | 68.23
1718 | PORTAL | 06XXFCC9473R1XT |  |  |  | 72.6
5657 | TALLY | 06XXFCC9473R1XT |  |  |  | 72.6
3453 | PORTAL | 07XXIPG8415E1X9 |  |  |  | 39682.8
5694 | TALLY | 07XXIPG8415E1X9 |  |  |  | 39683
5689 | TALLY | 07XXIPG8415E1X9 |  |  |  | 58039
711 | PORTAL | 07XXIPG8415E1X9 |  |  |  | 58039.2
4318 | PORTAL | 07XXIPG8415E1X9 |  |  |  | 59535
5702 | TALLY | 07XXIPG8415E1X9 |  |  |  | 59535
5376 | PORTAL | 27XXXFT5786X1XT |  |  |  | 8300.88
6026 | TALLY | 27XXXFT5786X1XT |  |  |  | 8301
6020 | TALLY | 27XXXFT5786X1XT |  |  |  | 11265
5370 | PORTAL | 27XXXFT5786X1XT |  |  |  | 11265.48
6014 | TALLY | 27XXXFT5786X1XT |  |  |  | 11858
2635 | PORTAL | 27XXXFT5786X1XT |  |  |  | 11858.4
5369 | PORTAL | 27XXXFT5786X1XT |  |  |  | 13063.68
6019 | TALLY | 27XXXFT5786X1XT |  |  |  | 13064
10940 | TALLY | 36XXXCT5268J1X1 |  |  |  | 13478
2013 | PORTAL | 36XXXCT5268J1X1 |  |  |  | 13478.4
10938 | TALLY | 36XXXCT5268J1X1 |  |  |  | 14677
1085 | PORTAL | 36XXXCT5268J1X1 |  |  |  | 14677.2
173 | PORTAL | 36XXXCT5268J1X1 |  |  |  | 16308
1512 | PORTAL | 36XXXCT5268J1X1 |  |  |  | 16308
10939 | TALLY | 36XXXCT5268J1X1 |  |  |  | 16308
10935 | TALLY | 36XXXCT5268J1X1 |  |  |  | 16308
5240 | PORTAL | 36XXXCT5268J1X1 |  |  |  | 17938.8
10946 | TALLY | 36XXXCT5268J1X1 |  |  |  | 17939
Spreadsheet: 81991d1282071065-only-one-entry-per-month-in-pivot-table-performance-revised
Sheet: D

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays
195538 | 2010-08-02 00:00:00 | 6N91 | 13 LOST NBLYACN HTONSJN | S | FPED | D | NORTH BLYTH ALCAN | 134.88 | 4
Spreadsheet: 853093d1703043779-need-help-for-counting-sales-frequency-with-a-year-based-on-criteria-sales-frequency
Sheet: Sheet1

Product | Date | Sales
Apple | 2022-12-05 00:00:00 | 5 |  | Apple sales frequency in 2023
Apple | 2023-01-01 00:00:00 | 5 |  | 8 | < the answer I want
Apple | 2023-01-03 00:00:00 | 6
Orange | 2023-01-01 00:00:00 | 5
Apple | 2023-02-01 00:00:00 | 6
Apple | 2023-03-02 00:00:00 | 3
Apple | 2023-03-03 00:00:00 | 3
Orange | 2023-04-01 00:00:00 | 3
Apple | 2023-05-01 00:00:00 | 2
Orange | 2023-06-01 00:00:00 | 3
Apple | 2023-07-01 00:00:00 | 4
Orange | 2023-08-01 00:00:00 | 2
Apple | 2023-09-01 00:00:00 | 1
Apple | 2023-10-01 00:00:00 | 3
Apple | 2023-11-01 00:00:00 | 4
Apple | 2023-11-02 00:00:00 | 5
Orange | 2023-12-01 00:00:00 | 5
Orange | 2023-12-02 00:00:00 | 3
Spreadsheet: 135021d1325764731-excel-lookup-emp0501
Sheet: Team

Sr. No. | Group | Skill Expertise | ABC | BCD | EFG | HIJ | KLM | NOP
1 | Development Tools | [NAME] | 5 | 5 | 4 | 4 | 5 | 4
2 |  | Abaqus | 3 | 5 | 3 |  |  | 2
3 | QA Tools | LMS Test Lab |  | 5 | 4 | 2
4 | New Added By Team Leader | CATIA V5 |  | 3 |  |  | 4
5 |  | LMS Virtual Lab |  | 5
6 | Added Skills by Team Members | Windows | 4 |  | 4 | 4 |  | 4
7 |  | Linux/Unix | 1 |  | 2 |  |  | 3
8 |  | HTML/XHTML 1.1/CSS 2.0 |  |  | 2 |  |  | 1
9 |  | C/C++ |  |  | 2 |  | 2 | 1
10 |  | Visual Basic |  |  | 2
11 |  | Adobe Photoshop CS4 |  |  |  |  | 2 | 2
 | EMP Name | ABC
 |  |  | 2
 | Abaqus |  | 3
 | LMS Test Lab |  | 4
 | CATIA V5 |  | 5
 | LMS Virtual Lab |  | 6
 | Windows |  | 7
 | Linux/Unix |  | 8
 | HTML/XHTML 1.1/CSS 2.0 |  | 9
 | C/C++ |  | 10
 | Visual Basic |  | 11
 | Adobe Photoshop CS4 |  | 12
Spreadsheet: 831058d1685378182-i-want-to-have-multiple-tasks-in-one-cell-example
Sheet: Sheet1

Monthly Budget Worksheet |  |  |  |  |  |  |  | INVESTING | INFORMATION | COST
Monthly Net Income |  |  |  |  | Total: |  |  | CJ | [NAME]
CJ: | Rivulis wk1 | Rivulis wk2 | [NAME] wk3 | Rivulis wk4 | Rivulis wk5 |  |  | CJ | [NAME]
 |  |  |  |  |  |  |  | CJ | [NAME] 401K
[NAME]: | Rivulis wk1 | Rivulis wk2 | [NAME] wk3 | Rivulis wk4 | Rivulis wk5 |  |  | Savings | PNC
 |  |  |  |  |  |  |  | CJ | Think or Swim
Monthly Expenses |  |  |  |  |  |  |  | [NAME] | [NAME] 401K
Systematic Investing | Type | [NAME] | [NAME] | [NAME] 401K | Savings |  |  | [NAME] | [NAME]
 | Payment |  |  |  |  |  |  | Total:
 |  |  |  |  | Total: |  |  | HOUSING | INFORMATION | COST
Housing | Mortgage/Rent Payment |  | 1(2) |  |  |  |  | Rent Payment | [NAME] | 1
 | Homeowner's Insurance |  |  |  |  |  |  | Renter's Insurance | Lemonade
 |  |  |  | Total: |  | 2 |  | Total:
Utilities | Water |  |  | Internet |  |  |  | UTILITIES | INFORMATION | COST
 | Gas/Electric |  |  | Netflix |  |  |  | Internet | Cox
 | Trash |  |  | Hulu |  |  |  | Netflix | Netflix
 | Cell Phone |  |  | Groceries |  |  |  | Hulu | Hulu
 | iCloud |  |  | Total: |  |  |  | Trash | Escondido Disposal
Transportation/Auto | Vehicle Fuel |  |  | Vehicle Insurance |  |  |  | Water | [NAME]
 | Parking |  |  | Inspections |  |  |  | Cell Phone | Verizon
 | Service |  |  | Licenses |  |  |  | Electric | SDG&E
 | Cleaning |  |  | Registrations |  |  |  | Groceries | Groceries
 | Fast Track |  |  | Total: |  |  |  | iCloud | Apple
Miscellaneous | Climbing Gym |  |  | Vacation Travel |  |  |  | Total:
 | Snakes |  |  | Magazines |  |  |  | Transportation/Auto | INFORMATION | COST
 | Cats Food |  |  | Exploring/Weekend Fun |  |  |  | Vehicle Fuel
 | Cat Litter |  |  | Personal Trainer |  |  |  | Parking
 | Cat Snacks |  |  | Dry Cleaners |  |  |  | Service | Toyota
 | Dining Out |  |  | Coffee Nespresso |  |  |  | Cleaning | Adrian
 | Relaxation |  |  |  |  |  |  | Fast Track | [NAME]
 |  |  |  | Total: |  |  |  | Vehicle Insurance | AAA
Credit Cards | CJ Capital One |  |  | Barclay |  |  |  | Inspections | Smog
 | Ashley Capital One |  |  |  |  |  |  | Licenses | ID's
 | [NAME] |  |  | Total: |  |  |  | Registration | Vehicle Registration
Monthly Bills |  |  |  | Total: | 2 |  |  | Total:
Weekly Requirements For Bills |  |  |  | Total: |  |  |  | [NAME] | INFORMATION | COST
Total Monthly Expenses |  |  |  | Total: |  |  |  | Climbing Gym | Mesa Rim
Weekly Requirements For Total Monthly Expenses |  |  |  | Total: |  |  |  | Snakes | [NAME]
Monthly Discretionary Income |  |  |  | Total: |  |  |  | Cat Food | Petco
 |  |  |  |  |  |  |  | Cat Litter | Petco
 |  |  |  |  |  |  |  | Cat Snacks | Petco
 |  |  |  |  |  |  |  | Dinning Out
 |  |  |  |  |  |  |  | Relaxation
 |  |  |  |  |  |  |  | Vacation/Travel
 |  |  |  |  |  |  |  | Magazines | Southern Living/Sailing
 |  |  |  |  |  |  |  | Exploring/Weekend Fun
 |  |  |  |  |  |  |  | Personal Trainer
 |  |  |  |  |  |  |  | Dry Cleaners
 |  |  |  |  |  |  |  | Coffee Nespresso | Coffee
 |  |  |  |  |  |  |  | Total
Spreadsheet: 120910d1315627116-if-function-vlookupexample
Sheet: Product Price

No of Product | Product 1 | Product 2
0-99 | US$ 160 | US$ 260
100-499 | US$ 230 | US$ 380
500-999 | US$ 340 | US$ 570
1000 or more | US$ 600 | US$ 1000
No of Product | Product 1 | Product 2
0 | 160 | 260
100 | 230 | 380
500 | 340 | 570
1000 | 600 | 1000
10000000
Spreadsheet: 813745d1673966575-help-with-a-vlookup-formula-test-weekly-sales-yoy-by-customer
Sheet: 2023

 | 2023-01-03 00:00:00 |  |  | 2023-01-10 00:00:00
Customer J | 1146.6 |  | Customer I | 1528.93
Customer I | 1344.24 |  | Customer H | 1797.84
Customer F | 1795.68 |  | Customer G | 1866
Customer E | 2788.550000000001 |  | Customer k | 2376
Customer D | 3345 |  | Customer D | 2567.04
 |  |  | Customer C | 2643.84
 |  |  | Customer A | 3301.47
Spreadsheet: 693770d1599142270-return-the-next-working-day-taking-in-consideration-the-days-off-on-a-2-days-interval-sample_2
Sheet: Admin

 |  |  |  |  | HOLIDAY LEAVE |  |  | LEGAL DAYS OFF |  |  | V | W1 D1 | W1 D2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W5 D1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W7 D1 | [NAME] | W8 D1 | W8 D2
 |  |  |  | Crit. | Start | End |  | 2020-06-01 00:00:00 |  |  | 2020-01-18 00:00:00
 |  |  |  | 1 | 2020-01-02 00:00:00 | 2020-01-05 00:00:00 |  | 2020-06-07 00:00:00 |  |  | 2020-01-13 00:00:00
 |  |  |  |  | 2020-01-15 00:00:00 | 2020-01-17 00:00:00 |  | 2020-06-08 00:00:00 |  |  | 2020-01-14 00:00:00
 |  |  |  |  | 2020-02-09 00:00:00 | 2020-02-19 00:00:00 |  | 2020-08-15 00:00:00 |  |  | 2020-02-14 00:00:00
 |  |  |  |  | 2020-06-09 00:00:00 | 2020-06-12 00:00:00 |  | 2020-11-30 00:00:00 |  |  | 2020-01-25 00:00:00
 |  |  |  |  | 2020-09-14 00:00:00 | 2020-09-19 00:00:00 |  | 2020-12-01 00:00:00 |  |  | 2020-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | ok | ok | ok | 2020-01-20 00:00:00 | 2020-01-22 00:00:00 | 2020-01-24 00:00:00 |  |  |  | and so on
 |  |  |  |  |  |  |  |  |  | Based on the dates found in column L, if date falls in the holiday leave range or legal days off range, then W1 D1 should be the next working day. But if the found date is a Monday or Tuesday, then W1 D1 should be Wednesday. If is not Monday or Tuesday, then it should move to next week - Monday. If [NAME] is Wednesday then [NAME] should be Thursday, [NAME] should be Friday, otherwise, if [NAME] is Monday, then [NAME] should be Wednesday and [NAME] should be Friday. This should be the case up untill [NAME]. For W7 and W8, it should have the same rules but only for 2 days, Monday and Thursday.  The main point is that it should jump over the holiday intervals or legal days off.  I hope that is not too confusing
Spreadsheet: 812050d1672929385-search-in-a-range-of-cells-to-see-if-date-is-in-the-same-week-number-annual-leave-log-april-2022-march-2023-1-
Sheet: OVERVIEW

todays date |  | weeknum
 | Staff Holidays Remaining
 |  |  | hours left? | days left? |  |  |  | WHO IS ON HOLIDAY this week
 | Employee 1 |  |  |  |  |  |  | Ian
 | Employee 2 |  |  |  |  |  |  | [NAME]
 | Employee 3 |  |  |  |  |  |  | [NAME]
 | Employee 4
 |  |  |  |  |  |  |  | WHO IS ON HOLIDAY this week
 |  |  |  |  |  |  |  | Ian
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 740221d1626247257-counting-non-empty-cells-based-on-a-criteria-accross-colums-score-sample
Sheet: Sheet1

 | round 1 | round 2 | round 3 |  |  | Results
 |  |  |  |  |  | rounds
Mark | 3 | 0 | 1 |  | Mark
Martin | 1 |  |  |  | Martin
Mark | 3 | 0
Martin | 2
Spreadsheet: 539077d1505949904-scatter-chart-different-color-dots-s666v3-1201756-scatter-chart-different-color-dots
Sheet: After

B | S
345.25 | 352
335.25 | 351.75
330.25 | 381
349 | 376
349.5 | 363 |  | `
351.25 | 422
350 | 409
349.25 | 424
 | 420
Spreadsheet: 97c074e8-8490-4d2e-a5e7-17a0ffa26adf
Sheet: Cost Detail

ARRA PROJECT BUDGET
Institution:
[NAME] No.:
Project Title: | ARRA GSF Incentive 2011 Project
CODE | CATEGORY | [NAME]
I.  LABOR COSTS |  |  |  | #months | 12 | Inflation factor | 1
 | SALARIES & WAGES | Job Classification/Titles | Monthly [NAME] | % Effort | Amount $/mo. | Monthly w/ Inflation | Total
 |  | TOTAL SALARIES
 | FRINGE BENEFITS | Job Classification | Salary Amount $/mo. | Approx.[NAME] % | Med/Life | Benefit Amt. $/mo. | Total
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  |  |  | 0.25 | 0
 |  | TOTAL FRINGE BENEFITS
 |  | SUBTOTAL LABOR COSTS
II.  OTHER DIRECT
 | TRAVEL | Reference Travel [NAME]
 |  | TOTAL TRAVEL
 | EQUIPMENT |  |  |  |  |  | 0
 |  | TOTAL EQUIPMENT
 | SUPPLIES | Program Consumables |  |  |  |  | 0
 |  | TOTAL SUPPLIES
 | CONTRACTUAL | Total Subcontracts/Subgrants <$25K |  |  |  |  | 0
 |  | Total Subcontracts/Subgrants >$25K |  |  |  |  | 0
 |  | TOTAL CONTRACTUAL
 | OTHER EXPENSES | Item Description
 | Other |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | TOTAL OTHER EXPENSES
 |  | SUBTOTAL OTHER DIRECT
 |  | TOTAL DIRECT COSTS
TOTAL PROJECT BUDGET
Spreadsheet: 853154d1703080913-if-function-help-deals-eba
Sheet: 2024

 |  |  |  |  |  |  | 12500 | 37500 | 150000
 |  | Month | Volume | Comms | to Target |  | Q2 | Comms
 |  | January
 |  | February
 |  | March
 |  | Q1 |  |  |  |  | Total
 |  | Month | Volume | Comms | to Target | 0.05 | 0-15000
 |  | April |  |  |  | 0.1 | 15001-35000 | 2000
 |  | May |  |  |  | 0.2 | 35000+ | 500
 |  | June |  |  |  |  | Pay | 3250
 |  | Q2
 |  | Month | Volume | Comms | to Target
 |  | July
 |  | August
 |  | September
 |  | Q3
 |  | Month | Volume | Comms | to Target
 |  | October
 |  | November
 |  | December
 |  | Q4
 |  | Month | Volume | Comms | to Target
 |  | YTD
Spreadsheet: kam_keiser__18057__status of form a
Sheet: Sheet1

Form A status
 | Some commodities have included interco and must redo their schedules
 |  |  | Form A - original |  |  |  | Form A - without intercos
 |  |  | Form A | Form A rec to DPR | Reviewed | Sent to E&Y | Form A - without intercos | Form A rec to DPR | Reviewed | Sent to E&Y
ENRON AMERICA
 | N America Natural Gas (includes Canada)
 |  | US | x | x | x | x | x | x
 |  | Canada
 | N America Electricity (includes Canada)
 |  | East | x | x | x | x | x | x | x | x
 |  | West | x | x | x | x | x | x | x | x
 |  | Canada | x | x | x | x | x | x | x | x
EES
 | Gas
 | Power
ENRON GLOBAL MARKETS
 | Global Products - still waiting on version with options |  | x |  | x | x | x (although does have intercos with ECTRIC)
 | LNG
 | Weather |  | rec'd in draft, must be redone
 | Coal |  | x | x | x | x
 | Freight Markets
 | Emmissions
 | Global Risk Markets Trading
 | Financial Trading - equity
 | Financial Trading convertible arbitrage
 | Financial Trading - fx - have a file, but not in E&Y's format
 | Financial Trading - IR - have a file, but not in E&Y's format
ENRON INDUSTRIAL MARKETS
 | Pulp & Paper |  | x | x | x | x
 | Lumber
 | Steel |  | x | x | x | x
ENRON BROADBAND SERVICES
 | Bandwidth
 | Advertising
ENRON GLOBAL ASSETS
 | S America Natural Gas |  | are not part of this
 | S America Electricity |  | are not part of this
 | Steel |  | are not part of this
ECTRIC & other UK cos not in receivership
 | Pulp & paper
 | Steel - none
 | Lumber  - none
 | Global Products
 | LNG
 | Weather
 | Coal
 | Vessel
 | Emmissions - none
 | Gas
 | Power
Spreadsheet: 58f988cb-3be5-48b1-9653-8a8b4ead1bbc
Sheet: Sheet1

error rate: 1 in 1000 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | error rate: 1 in 100 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | error rate: 1 in 10 | Unnamed: 9 | Unnamed: 10
Redundant |  |  |  | Redundant |  |  |  | Redundant
 | 0 mismatch | 0 or 1 mismatch |  |  | 0 mismatch | 0 or 1 mismatch |  |  | 0 mismatch | 0 or 1 mismatch
Plus | 1106385 | 1107492 |  | Plus | 1096418 | 1107492 |  | Plus | 996743 | 1107492
Minus | 69110 | 69179 |  | Minus | 68488 | 69179 |  | Minus | 62262 | 69179
Non-redundant |  |  |  | Non-redundant |  |  |  | Non-redundant
 | 0 mismatch | 0 or 1 mismatch |  |  | 0 mismatch | 0 or 1 mismatch |  |  | 0 mismatch | 0 or 1 mismatch
Plus | 19852 | 20924 |  | Plus | 19807 | 28640 |  | Plus | 19285 | 74503
Minus | 8974 | 9043 |  | Minus | 8946 | 9630 |  | Minus | 8633 | 15016
Ratios 0 vs 0 or 1 mismatches
Redundant | 1/1000 | 1/100 | 1/10
Plus | 0.9990004442470013 | 0.9900008307057748 | 0.900000180588212
Minus | 0.9990025874904234 | 0.990011419650472 | 0.9000130097283858
Non-redundant | 1/1000 | 1/100 | 1/10
Plus | 0.9487669661632575 | 0.6915851955307263 | 0.2588486369676389
Minus | 0.992369788786907 | 0.9289719626168225 | 0.5749200852424081
Spreadsheet: 5d5ccc65-a35f-44c3-98d7-e279ed91b649
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
40801961 | 2014-04-02 00:31:38 | AXIS | 1 | 6 | 4 | 1117952 | scruffyshadow | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
40814154 | 2014-04-02 22:50:24 | AXIS | 1 | 10 | 7 | 247993 | Mccy | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 801063d1666059452-how-to-use-averageifs-and-offset-to-get-rolling-average-sampleaverage
Sheet: Sheet1

1 | 0.25 | 2022-03-16 00:00:00 | 7 | 66 | 7 | 0.25 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F1;B:[NAME])
2 | 0.5 | 2022-03-17 00:00:00 | 14 | 100 | 14 | 0.5 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F2;B:B;G2)
3 | 0.5 | 2022-03-17 00:00:00 | 14 | 12 | 24 | 1 | AVERAGEIFS(OFFSET(E1;COUNT(E:E);0;-3);E:E;D:D;F3;B:B;G3)
4 | 1 | 2022-03-19 00:00:00 | 24 | 55
5 | 1 | 2022-03-19 00:00:00 | 24 | 15
6 | 0.5 | 2022-03-19 00:00:00 | 14 | 22
7 | 0.5 | 2022-03-23 00:00:00 | 14 | 44
8 | 1 | 2022-03-23 00:00:00 | 24 | 66
9 | 0.5 | 2022-03-24 00:00:00 | 14 | 76
10 | 1 | 2022-03-24 00:00:00 | 24 | 87
11 | 0.5 | 2022-03-24 00:00:00 | 14 | 33
12 | 1 | 2022-03-24 00:00:00 | 24 | 36
13 | 0.5 | 2022-03-25 00:00:00 | 14 | 33
14 | 1 | 2022-03-25 00:00:00 | 24 | 28
15 | 1 | 2022-03-26 00:00:00 | 24 | 29
16 | 1 | 2022-03-28 00:00:00 | 24 | 20
Spreadsheet: scott_neal__38686__East
Sheet: East - Orig

 | East Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  |  |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | 30000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 200000
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  | 20000
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  | 197
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0 |  |  | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0 |  |  | 20000
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0 |  |  | 2
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0 |  |  | 5652
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0 |  |  | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | [NAME] |  |  |  |  |  | Vice President
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Manager
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: San Benito High

REGIONAL DIRECTORY 2014/2015
SAN BENITO HIGH SCHOOL DISTRICT
[NAME], Superintendent | [NAME], Director of Educational Services (MEP Administrator) | [NAME], Fiscal Officer
1220 Monterey Street | 1220 Monterey Street | 1220 Monterey Street
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] x133 | O: [PHONE] x162 | O: [PHONE] x155
F: [PHONE] | F: [PHONE] | F: [PHONE]
[NAME] | [EMAIL] | [EMAIL]
[NAME], MEP Program Specialist | [NAME], Migrant Clerk/Health/Recruiter | [NAME], Case Manager/[NAME]
1220 Monterey Street | 1220 Monterey Street | 1220 Monterey Street
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] x195 | O: [PHONE] x189 | O: [PHONE] x154
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], CaseManager/Recruiter
1220 Monterey Street
Hollister, CA 95023
O: [PHONE] x156
F: [PHONE]
[EMAIL]