tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 817512d1676291101-all-data-pulled-from-different-sheet-to-main-consolidated-sheet-amit-agency-savings-task
Sheet: AWG

 | [NAME]
 | Name | Employee no. | Position | Contrat Hours | Softworks Start Date | Softworks Total worked hours | Approx. Savings rate | Worked weeks holiday pro-rated | Home
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | Who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | Who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | Who dis?
 | Rohankumar Purohit |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | Manpreet Kaur1 |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | we have three manpreet Kaurs check which home?
 | Kiran Kumar |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | This person shows under BNH in Usmeet file
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME] | who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | [NAME]
 | TOTAL
 |  |  |  |  |  | LESS Immigration cost
 |  |  |  |  |  | Total Savings
 | GMR
 | GMR | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | Month | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
 | Agency Care - Regular | 297 | 519.25 | 911.5 |  |  | 1096 |  |  |  | 1234.25
Spreadsheet: 293131d1390905857-find-the-match-in-between-two-column-and-print-the-matched-corresponding-value-in-column-c-excel_data_distribution_test
Sheet: Sheet1

Column A | Column B | Value |  | Ram | Column A | Column B | Value | [NAME] | Column A | Column B | Value
[NAME] | Ram | 1
Ram | [NAME] | 2
[NAME] | [NAME] | 3
Ram | [NAME] | 1
[NAME] | Ram | 1
[NAME] | [NAME] | 2
[NAME] | Ram | 1
[NAME] | [NAME] | 5
Ram | [NAME] | 1
Ram | [NAME] | 1
 | Table 1 |  |  |  |  | Table 2 (If we select [NAME]) |  |  |  | Table 3 (if we select [NAME])
 |  |  |  |  | Total for |  |  |  | Total for
Spreadsheet: 847439d1698362595-retrieve-multiple-results-sample-copy-multi
Sheet: Sheet2

Item | PO | Quantity
1
2
3
4
5
Looking to see format as per below
1 | A | 1
1 | D | 1
2 | A | 7
2 | B | 8
2 | C | 5
3 | A | 9
3 | D | 2
4 | A | 3
4 | C | 4
5 | A | 5
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-3

Monday
Deal #s | 759093 |  | 759110 | 759113 | 759114 | 759117 | 759256 | 759557
2001-09-03 00:00:00 |  |  | NP | SP | SP | PV | SP | SP
Delivery Pt. | EPMI CA Pool |  | Sale | Sale | Sale | STSW | Buy CA Imbal | STCA
Counterparty | NP | SP | EES | EES | EES, $32.00 | export | STSW | CA Imbal
Totals | 1824 | -1824 | -6000 | -2400 | -608 | -792 | 200 | -600
1 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
2 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
3 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
4 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
5 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
6 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
7 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
8 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
9 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
10 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
11 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
12 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
13 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
14 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
15 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
16 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
17 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
18 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
19 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
20 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
21 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
22 | 101 | -101 | -250 | -100 | -38 | -37 |  | -25
23 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
24 | 101 | -101 | -250 | -100 |  | -25 | 25 | -25
TIE POINTS
Spreadsheet: 202721d1356710066-auto-update-data-mastertemplate-test1
Sheet: School Details

Contact: |  |  |  | Phone:
[NAME]: |  |  |  | Fax:
Billing Information:
Agreements: |  |  |  |  | 2 HR Min: | Yes/no
On-Site CART:
Remote CART:
Other:
Signed Contract Received:
Syllabus Received:
Books Received:
Academic Calendar for ?????? Semester 20??
Classes Begin:
Classes End:
No Classes:
School Closings/Academic Calendar:
 | (insert hyperlink)
Students: | Name |  |  | [NAME]
Parking:
Providers:
Sub Providers:
Notes:
Spreadsheet: 832705d1686556790-copy-formulas-in-a-filtered-list-and-paste-as-values-visible-cells-only-excel-query-copy-forulas-paste-as-values-in-a-filtered-list
Sheet: Filtered List

 |  | X | X | July | August | September
 |  | 1 | FC | 10000 | 12500 | 10000
 |  | 2 | A
 |  | 3 | FC | 0 | 0 | 0
 |  | 4 | A
 |  | 5 | FC | 0 | 0 | 0
 |  | 6 | a
 |  |  |  |  | Filter column D on "A"
 |  |  |  |  | Copy all
 |  |  |  |  | paste special (visible cells)
 |  |  |  |  | paste as value
 |  |  |  |  | does not work
Spreadsheet: 823565d1680016536-call-function-of-a-total-column-test3
Sheet: Sheet2

 |  |  |  |  | 2023-02-18 00:00:00 |  |  |  | 23:08:17 |  | Store: |  |  |  | 26049 |  |  |  |  |  |  | page: |  |  |  | 1 / 1
 | Date: 18.02.2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customers (Tickets) |  |  |  | Check average
 |  | Type |  |  |  | Description |  |  |  |  |  |  | Gross |  |  |  | Net
 |  | 1 |  |  |  | Counter
 |  |  |  |  |  |  | In House |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | Take Away |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customers (Tickets) |  |  |  | Check average
 |  | Type |  |  |  | Description |  |  |  |  |  |  | Gross |  |  |  | Net
 |  | 0 |  |  |  | In House |  |  |  |  |  |  | 5 |  |  |  | 4 |  |  | 416 |  |  |  | 5.627908653846173
 |  | 1 |  |  |  | Take Away |  |  |  |  |  |  | 5 |  |  |  | 4 |  |  | 62 |  |  |  | 4.724032258064516
 |  |  |  |  |  |  |  |  |  |  |  |  | 555 |  |  |  | 4 |  |  | 478 |  |  |  | 5.510669456066963
 |  |  |  |  |  |  |  | 544 / 3
Spreadsheet: mary_fischer__25641__111
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 766866d1644120899-multiple-rows-into-one-column-google-sheets-and-excel-teachers-and-students
Sheet: Sheet 1

Teacher ID | STUDENT1 ID | STUDENT2 ID | STUDENT3 ID | STUDENT4 ID | STUDENT5 ID | STUDENT6 ID | STUDENT7 ID | STUDENT8 ID | STUDENT9 ID | STUDENT10 ID | STUDENT11 ID | STUDENT12 ID | STUDENT13 ID
60957 | 569498 | 567882 | 683292 | 615818 | 317197 | 679689 | 673591 | 306357 | 307587 | 684986 | 600479 | 568861 | 600117
61244 | 404971 | 724404 | 722805 | 615817 | 684474 | 615776 | 681581 | 304993 | 636606 | 631893 | 685913 | 315949 | 602958
64996 | 563954 | 564470 | 564833 | 565465 | 568271 | 568936 | 568936 | 615731 | 632233 | 632249 | 634665 | 634803 | 637666
62330 | 633582 | 682508 | 559577 | 591389 | 737432 | 567181 | 686343 | 1047590 | 804743 | 671375 | 565429 | 692134 | 612771
64721 | 713261 | 656311 | 689860 | 691369 | 491563 | 684868 | 686678 | 564169 | 521232 | 564519 | 689363 | 601086 | 692000
70455 | 711751 | 604069 | 684114 | 637164 | 567994 | 304578 | 305122 | 305120 | 565455 | 566918 | 635153 | 304582 | 686630
62328 | 635148 | 568999 | 637388 | 570366 | 679868 | 564593 | 794071 | 430013 | 696793 | 663730 | 633506 | 691066 | 690247
61988 | 713261 | 686134 | 684685 | 711757 | 898741 | 559537 | 568284 | 459301 | 566632 | 590264 | 689884 | 635734 | 636435
61264 | 318039 | 398845 | 682005 | 683327 | 615842 | 683932 | 716907 | 711951 | 694713 | 568270 | 733486 | 596221 | 724379
TEACHER ID | STUDENT ID
60957 | 569498
60957 | 567882
60957 | 683292
60957 | 615818
60957 | 317197
60957 | 679689
60957 | 673591
60957 | 306357
60957 | 307587
60957 | 684986
60957 | 600479
60957 | 568861
60957 | 600117
61244 | 404971
61244 | 724404
61244 | 722805
61244 | 615817
61244 | 684474
61244 | 615776
61244 | 681581
61244 | 304993
61244 | 636606
61244 | 631893
61244 | 685913
61244 | 315949
61244 | 602958
Spreadsheet: 1af17408-c70e-4675-a425-b4903046df04
Sheet: Drop Down Lists

 | A
1 | VAC (Vacation)
2 | VAC - FML (Vac for FMLA)
3 | HVA (Hrly Emp Vacation)
4 | VLB (Vac from banked)
 | B
1 | SIC (Sick / TDL)
2 | SIC - FML (Sick for FMLA)
3 | HTD (Hrly Emp Sick)
4 | SLB (Banked sick)
 | C
1 | BRV- Bereavement Leave
2 | HJD (Hrly EP Jury Duty)
3 | [NAME] (Jury Duty)
4 | LWO (Leave Without Pay)
5 | LWO - FML (LWO for FMLA)
6 | VL (Voting leave)
7 | Official Travel
Spreadsheet: 8638ae32-f6d1-4b37-9158-2ca7dedbfbf6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6397 | 45071 | Eduardo | Obregon | MEX | 0 | 00:15:40 | 00:02:31 | [NAME] | 00:01:52 | 00:23:19 | 1 | 01:18:04
6397 | 17264 | Antoine | Flipo | MEX | 0 | 00:16:05 | 00:02:14 | 00:34:32 | 00:01:54 | 00:25:58 | 2 | 01:20:43
6397 | 45072 | [NAME] | [NAME] | MEX | 0 | [NAME] | 00:02:41 | 00:41:36 | 00:02:08 | 00:29:12 | 3 | 01:30:56
6397 | 45075 | Guy | Dubernard | MEX | 0 | 00:15:17 | 00:03:27 | 00:54:01 | 00:02:29 | 00:28:07 | 4 | 01:43:21
6397 | 45074 | Eduardo | Rodriguez | MEX | 0 | 00:17:15 | 00:04:25 | 00:45:23 | 00:01:43 | 00:37:24 | 5 | 01:46:10
6397 | 45073 | Mario | [NAME] | MEX | 0 | 00:20:24 | 00:05:28 | 00:48:22 | 00:01:55 | 00:32:35 | 6 | 01:48:44
Spreadsheet: caaff8a7-8752-41cd-98ce-e97eb546479b
Sheet: Sheet1

2004 Year-End Tax Reporting | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Camden Property Trust
Form 2004 Report Date: | 2005-01-13 00:00:00
This spreadsheet and the related instructions are intended to assist REITs in providing data for tax reporting purposes.  The rules governing the proper tax characterization of distributions by mutual funds can be complex.  Each REIT should consult its ow
Please list Securities in [NAME] (Skip Rows Between Entries)
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
 |  |  |  |  |  |  |  |  | Year Included in Shareholders' Income |  |  |  |  | Box 6 | Box 1a Total | Box 1b Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 3 | Box 6 | Box 8 | Box 9
Security |  |  |  |  |  |  |  | Total | [NAME]. [NAME]. (852(b)(7)) |  |  |  |  | Foreign |  |  |  | Unrecap |  |  |  | Foreign | Cash | Noncash | Exempt
Description |  | Ticker | Estimated | Reclass | Corrected | Record | Payable | Distribution | 2003 | 2005 | 2004 | Income | Short-term | Tax | Ordinary | Qualified | Total Capital | Sec. 1250 | Section 1202 | Collectibles | Nontaxable | Tax | Liquidation | Liquidation | Interest
(Fund Name) | CUSIP | Symbol | (E) | (R) | (C) | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital  Gain | Paid | Dividends | Dividends | [NAME]. | Gain | Gain | (28%) Gain | Distributions | Paid | Distr | Distr | Dividends
 |  |  |  |  |  |  |  | (10+11+12) |  |  |  |  |  | [NAME]. 23 | (13+14) |  |  |  |  |  |  | [NAME]. 15
Camden Property Trust Common | 133131102 | CPT |  |  |  | 2004-03-31 00:00:00 | 2004-04-16 00:00:00 | 0.635 |  |  | 0.635 | 0.3234739263877536 | 0 |  | 0.3234739263877536 | 0 | 0.3115260736122464 | 0.0739566085691759 |  |  | 0 |  | 0
Camden Property Trust Common | 133131102 | CPT |  |  |  | 2004-06-30 00:00:00 | 2004-07-16 00:00:00 | 0.635 |  |  | 0.635 | 0.3234739263877536 | 0 |  | 0.3234739263877536 | 0 | 0.3115260736122464 | 0.0739566085691759 |  |  | 0 |  | 0
Camden Property Trust Common | 133131102 | CPT |  |  |  | 2004-09-30 00:00:00 | 2004-10-15 00:00:00 | 0.635 |  |  | 0.635 | 0.3234739263877536 | 0 |  | 0.3234739263877536 | 0 | 0.3115260736122464 | 0.0739566085691759 |  |  | 0 |  | 0
TOTALS |  |  |  |  |  |  |  | 1.905 |  |  | 1.905 | 0.9704217791632609 | 0 |  | 0.9704217791632609 | 0 | 0.9345782208367391 | 0.2218708257075277 |  |  | 0 |  | 0
Spreadsheet: 99414d1298037149-percentage-and-rounding-with-int-and-round-excel-forum
Sheet: Adidas & Ashworth Breakdown

ADIDAS & ASHWORTH COMBINED | Adidas v1 | Ashworth v1 | 2010 v1 | 2010% v1 | Adidas v3 | Ashworth v3 | 2010 v3 | 2010% v3 | Adidas | Ashworth | 2009 | 20.09 |  | Adidas 08 | Ashworth 08 | 2008 | 20.08
[NAME] (SMU'S) | 0 | 2250 |  |  | 0 | 2700 |  |  | 5500 |  |  |  |  | 5380
Men's Polo Total | 6260 | 1700 |  |  |  | 2375 |  |  | 2158.8 | 1480 |  |  |  | 3346 | 1850
GARCIA SCRIPT Total | 400 |  |  |  |  |  |  |  | 150 |  |  |  |  | 190 | 0
ADIPURE | 705 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
MEN'S KNITS Total |  | 650 |  |  |  | 750 |  |  | 507 | 64 |  |  |  | 527 | 0
MEN'S TOPS AND OUTERWEAR Total | 1235 | 200 |  |  |  | 500 |  |  | 1060 | 192 |  |  |  | 1155 | 571
MENS COMPRESSION Total | 140 |  |  |  |  |  |  |  | 233 | 0 |  |  |  | 130 | 0
MEN'S TROUSERS Total | 280 | 180 |  |  |  | 200 |  |  | 142 | 0 |  |  |  | 0 | 0
WOMEN'S POLOS total | 2080 |  |  |  |  |  |  |  | 1230 | 210 |  |  |  | 1601 | 184
WOMEN'S BOTTOMS total | 470 |  |  |  |  |  |  |  | 195 | 0 |  |  |  | 169
WOMEN'S OUTERWEAR Total | 470 |  |  |  |  |  |  |  | 289 |  |  |  |  | 370 | 204
WOMEN'S KNITS Total |  |  |  |  |  |  |  |  | 294 | 126 |  |  |  | 330 | 72
Spreadsheet: 207457d1358459016-how-to-filter-for-results-in-two-columns-toy-inventory
Sheet: Sheet1

 | Flight | Departs | Time | Arrives | Time
 | 1001 | New York | 02:00:00 | Boston | 03:00:00
 | 1002 | New York | 02:30:00 | Philadelphia | 03:15:00
 | 1003 | Boston | 02:45:00 | Philadelphia | 04:00:00
 | 1004 | Washington DC | 03:00:00 | New York | 04:00:00
 | 1005 | Philadelphia | 03:30:00 | Boston | 05:00:00
 | 1006 | Boston | 04:00:00 | Washington DC | 05:30:00
Spreadsheet: 72375d1273058915-skipping-blank-cells-with-if-function-fpl
Sheet: Log

 | FOOSBALL PREMIER LEAGUE
 | Pos |  | P | W | L | D | GF | GA | [NAME] | PTS
 | 1 | Warrick | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 2 | [NAME] | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 3 | [NAME] | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 4 | [NAME] | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 5 | Mark | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 6 | [NAME] | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
 | 7 | [NAME] | 12 | 0 | 0 | 12 | 0 | 0 | 0 | 12
Spreadsheet: 49187d1248440082-look-up-problem-packaging-codes
Sheet: Sheet1

Sku | Packaging Code | Sku | Packaging Codes
A4038100414 | A4038101148
A4038100414 | [NAME]
A4038100414 | [PHONE]
A4038100414 | [PHONE]
BASILI00814 | BASILI00100
BASILI00814 | BASILI00102
BASILI00814 | BASILI00103
BASILI00814 | BASILI00129
BASILI00814 | BASILI00131
BASILI00814 | [PHONE]
CIHHAI14159 | CIHHAI04988
CIHHAI14159 | [PHONE]
CIHHAI14159 | [PHONE]
CIHHAI22342 | CIHHAI22341
CIHHAI22342 | [PHONE]
CIHHAI22342 | [PHONE]
DBARON00814 | DBARON00100
DBARON00814 | DBARON00102
DBARON00814 | DBARON00103
DBARON00814 | DBARON00129
DBARON00814 | DBARON00131
DBARON00814 | [PHONE]
DBARON00814 | [PHONE]
DBARON00814 | [PHONE]
DCOUNT00814 | DCOUNT00100
DCOUNT00814 | DCOUNT00102
Spreadsheet: 287109d1388655400-drop-lists-automatic-input-book2
Sheet: Sheet1

 | PRODUCT REFERENCE | SUPPLIER NAME | UNIT SPECS (E.G WEIGHT, NUMBER OF CASES ETC...) | UNIT PRICE
 | Orange Juice | [NAME] | [NAME] | 25
 | Plain Water (or invoice ref) | YYY | YYY | 50
 | Sodas (or invoice ref) | ZZZ | ZZZ | 40
 | Wine (or invoice ref)) |  |  | 25
 | Beer(or invoice ref)) |  |  | 50
 | Pork meat (or ref as described on supplier's invoice) |  |  | 40
 | Chicken meat (or ref as described on supplier's invoice) |  |  | 25
 | Tomatoes (or ref as described on supplier's invoice) |  |  | 50
 | Cucumbers  (or ref as described on supplier's invoice) |  |  | 40
 | Fresh Noodles (or ref as described on supplier's invoice) |  |  | 25
 | [NAME] (or ref as described on supplier's invoice) |  |  | 50
 | [NAME] et Augstin Chocolate Cookies (or ref as described on supplier's invoice) |  |  | 40
Spreadsheet: 850872d1701188406-data-filtering-with-formulas-bbt-1-
Sheet: Example data

Id numeric | Product | Brew number | Sampling point | ABV_DUTY | MES_ABV | MES_ABVout | MES_AE | MES_AEout | MES_AENOM | MES_CO2 | MES_CO2out | MES_COL | MES_COLNOM | MES_HAZE11 | MES_HAZE90 | MES_O2 | MES_O2out | oe_calc1 |  | MES_ABV | MES_ABVout | MES_AE | MES_AEout | MES_CO2 | MES_CO2out | MES_COL | MES_HAZE11 | MES_HAZE90 | MES_O2 | MES_O2out |  | ABV | AE | AE_NOM | COL | COL_NOM | HAZE_25DEG | HAZE_90DEG | VISUAL
Spreadsheet: 65407d1266105269-formula-to-distinguish-month-year-from-prior-month-years-excel-spreadsheet-with-formulas
Sheet: Tab 5

 | Date | Company | Invoice # | Description |  |  | Special Inspections
1 | 2009-01-06 00:00:00 |  |  |  |  | 3700
2 | 2009-03-03 00:00:00 |  |  |  |  | 1300
3 | 2009-04-04 00:00:00 |  |  |  |  | 500
4 | 2009-03-31 00:00:00 |  |  |  |  | 2500
5 | 2009-03-31 00:00:00 |  |  |  |  | 750
6 | 2009-03-31 00:00:00 |  |  |  |  | 25680
7 | 2009-03-31 00:00:00 |  |  |  |  | 5980
8 | 2009-06-30 00:00:00 |  |  |  |  | 1950
9 | 2009-09-02 00:00:00 |  |  |  | 390
 |  |  |  |  | 390 | 42360 | 0
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: TX-HPL-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  |  |  | 335355
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 773984d1648143056-want-to-sum-up-specific-cells-in-a-cohort-table-sum-column-to-right
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
April | 100
May | 80 | 100
June | 70 | 80 | 80
July | 60 | 70 | 70 | 70
August | 50 | 60 | 60 | 60 | 70
September | 40 | 50 | 50 | 50 | 60
October | 30 | 40 | 40 | 40 | 50
Spreadsheet: 852475d1702496852-help-with-formula-nov-2023-monthly-cash-summary
Sheet: Due To From

 |  |  | Type | Date | Num | Name | Memo | Split | Debit | Credit | Balance
 | 1399 · Bachmann - Due To / From |  |  |  |  |  |  |  |  |  | -374991.95
 |  |  | Check | 2023-10-06 00:00:00 | ACH1047 | Bachmann Industries, Inc. (ACH) |  | 1010 · Bank of America USD 9312 | 10000 |  | -364991.95 |  |  |  |  |  | Bachmann Industries, Inc. (ACH)
 |  |  | Check | 2023-10-13 00:00:00 | ACH1064 | Bachmann Industries, Inc. (ACH) |  | 1010 · Bank of America USD 9312 | 10000 |  | -354991.95 |  |  |  |  |  | InterCo
 |  |  | Check | 2023-10-20 00:00:00 | ACH1081 | Bachmann Industries, Inc. (ACH) |  | 1010 · Bank of America USD 9312 | 10000 |  | -344991.95
 |  |  | Check | 2023-10-23 00:00:00 | ACH1097 | Bachmann Industries, Inc. (ACH) |  | 1010 · Bank of America USD 9312 | 10000 |  | -334991.95
 |  |  | Check | 2023-10-23 00:00:00 | ACH1098 | Bachmann Industries, Inc. (ACH) |  | 1010 · Bank of America USD 9312 | 10000 |  | -324991.95
 |  |  | General Journal | 2023-10-31 00:00:00 | 1023 ME |  | Monthly Cost allocation | 8000 · Intercompany Cost Sharing G&A |  | 20833 | -345824.95
 |  |  | General Journal | 2023-10-31 00:00:00 | 1023 ME |  | Monthly Accounting Fee Charges | 8000 · Intercompany Cost Sharing G&A |  | 625 | -346449.95
 |  |  | General Journal | 2023-10-31 00:00:00 | DS cc 10/23 |  | [NAME] | 6415 · Truck Gas |  | 393.48 | -346843.43
 |  |  | General Journal | 2023-10-31 00:00:00 | FB cc 10/23 |  | [NAME] | 7750 · Bachmann - Meals |  | 132.74 | -346976.17
 |  |  | General Journal | 2023-10-31 00:00:00 | JM cc 10/23 |  | [NAME] | 7210 · SM Airfare, Car, Lodging |  | 424.4 | -347400.57
 |  |  | General Journal | 2023-10-31 00:00:00 | KS cc 10/23 |  | [NAME] | 7982 · Employee Goodwill |  | 928.44 | -348329.01
 |  |  | General Journal | 2023-10-31 00:00:00 | TI cc 10/23 |  | Terri Early CC | 7830 · Computer, IT & Software Expense |  | 964.96 | -349293.97
 |  |  | General Journal | 2023-10-31 00:00:00 | TM cc 10/23 |  | [NAME] | 2325 · Accrued Credit Card |  | 82.39 | -349376.36
 |  |  | General Journal | 2023-10-31 00:00:00 | TE cc 10/23 |  | Tiffany English CC | 2325 · Accrued Credit Card |  | 985.93 | -350362.29
 |  |  | General Journal | 2023-10-31 00:00:00 | NW cc 10/23 |  | [NAME] | 7982 · Employee Goodwill |  | 37.4 | -350399.69
 |  |  | General Journal | 2023-10-31 00:00:00 | Bills |  | Expenses paid by Bachmann (verizon, TE (airfare/meals), UPS) | 7770 · Phones& Internet Admin |  | 1512.69 | -351912.38
 | Total 1399 · Bachmann - Due To / From
TOTAL