tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807231d1669812399-transfer-of-data-from-a-master-sheet-to-other-sheets-quest-2-1-
Sheet: g journal

Inv | Date | Decription | Debit | Credit | Amount
1 | 2022-02-01 00:00:00 | rent | Cash In Bank | Cash In Hand | 100
2 | 2022-02-02 00:00:00 | rent | Saleem | Cash In Hand | 300 |  | the item marked with yellow
3 | 2023-06-04 00:00:00 | rent | Cash In Hand | Saleem | 700 |  | is under credit in the journal.
4 | 2023-02-05 00:00:00 | rebt | Cash In Bank | Co-Operative Bank | 1000 |  | this should automatically relect
5 | 2024-06-06 00:00:00 | rett | Cash In Hand | Co-Operative Bank | 500 |  | in the credit column in cash in hand
6 | 2023-06-07 00:00:00 | rent | Shafeeq | Cash In Hand | 10000 |  | similary the green shoud appear in the
 |  |  |  |  |  |  | debit column of the cash in hand sheet
 |  |  |  |  |  |  | the list in journal will be long and therewill
 |  |  |  |  |  |  | be other sheets eg cash in bank
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -63712 | -98118
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2454815 | -2552677
58710 | -303205 | -131512
60921 | -723382 | -752098
78026 | 53935
500084 |  | -75000
500085 | -218343 | -123775
500097 | -33833
INDEX
2000-11-30 00:00:00 |  |  | 370218.8
2000-12-25 00:00:00
 |  | 300 | 7.75
 |  | 300 | 6.375
 |  | 400 | 5
 |  | 1000
Spreadsheet: 740672d1626448147-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v4-
Sheet: Version7

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | SOLD |  |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Amount | S# | Quantity | Price | Amount | Quantity | Price | Amount | Gain(+) /     Loss(-) | Gain(+) /     Loss(-) per Sales Only |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0 |  | S1
 | Purchase |  |  |  | 1.95554 | 12.8 | 0 |  | S1
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0 |  | S1
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0 |  | S1
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0 |  | S2
 | Purchase |  |  |  | 12.706329 | 39.39 | 0 |  | S2
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0 |  | S2
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0 |  | S2
 | Purchase |  |  |  | 270.208195 | 74.56 | 0 |  | S2
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0 |  | S3
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0 |  | S3
 | Purchase |  |  |  | 246.20782 | 102.55 | 0 |  | S3
 | Purchase |  |  |  | 165.37101 | 103.4 | 0 |  | S3
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0 |  | [NAME]
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0 |  | [NAME]
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0 |  | S5
 | Purchase |  |  |  | 138.149505 | 182.77 | 0 |  | S5
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
S5 | Sale | 2021-06-30 00:00:00 | Partial | Short | -100 | 50 | 0
S5 | Sale |  | Partial | Short | -50 | 50 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
 |  |  |  | SUMMARY |  | Avg price |  |  |  | [NAME]
 |  |  |  | Purchase
 |  |  |  | Sale
 |  |  |  | Diff |  |  |  |  |  |  |  |  |  |  |  | In which,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gain
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loss
Spreadsheet: 108789d1305759414-sum-based-on-a-fluid-number-book1
Sheet: Sheet1

TONNAGE REPORT |  |  |  |  |  |  |  |  |  |  | 2011-05-31 00:00:00
 |  |  | ACTIVITY |  |  |  |  |  |  |  | TOTAL | Weekly Total
2011-05-02 00:00:00 | Monday | 19 |  |  |  |  |  |  | 0 | 0 | 0 |  | I need a formula in M that will sum the totals in L based on the week
2011-05-03 00:00:00 | Tuesday | 19 |  |  |  |  |  |  | 0 | 0 | 0 |  | number in C.  As you can see, as the date in L1 changes, so does the
2011-05-04 00:00:00 | Wednesday | 19 |  |  |  |  |  |  | 0 | 0 | 0 |  | information in A, B and C.
2011-05-05 00:00:00 | Thursday | 19 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-06 00:00:00 | Friday | 19 |  |  |  |  |  |  | 0 | 0 | 0 | 0
2011-05-09 00:00:00 | Monday | 20 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-10 00:00:00 | Tuesday | 20 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-11 00:00:00 | Wednesday | 20 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-12 00:00:00 | Thursday | 20 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-13 00:00:00 | Friday | 20 |  |  |  |  |  |  | 0 | 0 | 0 | 0
2011-05-16 00:00:00 | Monday | 21 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-17 00:00:00 | Tuesday | 21 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-18 00:00:00 | Wednesday | 21 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-19 00:00:00 | Thursday | 21 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-20 00:00:00 | Friday | 21 |  |  |  |  |  |  | 0 | 0 | 0 | 0
2011-05-23 00:00:00 | Monday | 22 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-24 00:00:00 | Tuesday | 22 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-25 00:00:00 | Wednesday | 22 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-26 00:00:00 | Thursday | 22 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-27 00:00:00 | Friday | 22 |  |  |  |  |  |  | 0 | 0 | 0 | 0
2011-05-30 00:00:00 | Monday | 23 |  |  |  |  |  |  | 0 | 0 | 0
2011-05-31 00:00:00 | Tuesday | 23 |  |  |  |  |  |  | 0 | 0 | 0
2011-06-01 00:00:00 | Wednesday | 23 |  |  |  |  |  |  | 0 | 0 | 0
Monthly Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 7d47b508-2b48-4a18-96bd-f30db26a46ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: U.S. International Trade in Goods and Services
 |  | Balance of Payment Goods and Services: United States
 |  | Seasonally Adjusted Balance [Millions of Dollars]
 |  | Period: 1992 to 2014
 |  | Data Extracted on: October 20, 2014 (6:24 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | -2026 | -831 | -2641 | -3109 | -3919 | -2824 | -2781 | -4455 | -3530 | -3520 | -3968 | -5603
1993 | -3871 | -3596 | -6777 | -6445 | -4369 | -6929 | -6382 | -5581 | -7031 | -6594 | -7016 | -5719
1994 | -6207 | -9245 | -6466 | -7887 | -7728 | -8380 | -8739 | -8303 | -8310 | -9158 | -9615 | -8456
1995 | -9324 | -8817 | -9708 | -9609 | -9090 | -10623 | -7688 | -6704 | -5924 | -6114 | -6514 | -6271
1996 | -8465 | -7319 | -7756 | -8744 | -9259 | -7460 | -10132 | -10357 | -10195 | -6635 | -7268 | -10475
1997 | -11269 | -9776 | -8383 | -8086 | -8394 | -7154 | -7033 | -8743 | -9269 | -9089 | -9786 | -11289
1998 | -10776 | -11564 | -12880 | -13940 | -14202 | -13247 | -13949 | -16028 | -14820 | -14815 | -15173 | -14745
1999 | -15946 | -18786 | -17900 | -18254 | -20229 | -23115 | -23421 | -22977 | -22899 | -23531 | -25224 | -26337
2000 | -27088 | -29930 | -31154 | -28800 | -29813 | -30966 | -31426 | -30035 | -34018 | -33224 | -32607 | -33454
2001 | -34817 | -29349 | -32732 | -31217 | -27446 | -29140 | -30081 | -28171 | -31141 | -30839 | -29737 | -26839
2002 | -29355 | -32287 | -30825 | -33666 | -33921 | -34900 | -33650 | -35743 | -36519 | -35171 | -39624 | -43294
2003 | -40740 | -39363 | -43355 | -41987 | -40779 | -39621 | -41363 | -39802 | -41706 | -41271 | -39841 | -44064
2004 | -44352 | -44322 | -46484 | -47479 | -48169 | -54702 | -51293 | -53316 | -51489 | -54961 | -58819 | -54500
2005 | -55561 | -57454 | -52619 | -57115 | -56264 | -58260 | -58063 | -58388 | -64923 | -67140 | -64090 | -64366
2006 | -66680 | -62851 | -62574 | -62844 | -64844 | -63481 | -66525 | -67823 | -64936 | -58990 | -58575 | -61592
2007 | -57656 | -58478 | -61797 | -60514 | -59288 | -59520 | -59914 | -57005 | -57794 | -56538 | -59717 | -57154
2008 | -61139 | -64348 | -60064 | -63528 | -62151 | -60670 | -66842 | -62108 | -60499 | -60191 | -44724 | -42463
2009 | -37842 | -27767 | -29162 | -29705 | -25372 | -26367 | -32790 | -31267 | -34491 | -33826 | -37203 | -37983
2010 | -37154 | -41034 | -39766 | -40864 | -41333 | -46557 | -40413 | -44921 | -44042 | -39998 | -37762 | -40815
2011 | -47123 | -43718 | -43478 | -42227 | -47220 | -49433 | -45689 | -44968 | -43305 | -44962 | -47044 | -49460
2012 | -51266 | -43338 | -49850 | -47773 | -47184 | -43078 | -43834 | -44536 | -40150 | -42358 | -46604 | -37634
2013 | -42205 | -41770 | -36973 | -40417 | -44831 | -36552 | -39419 | -39515 | -42263 | -39083 | -35972 | -37393
2014 | -39181 | -42230 | -43124 | -45977 | -43465 | -40810 | -40321 | -40109
Spreadsheet: 690396d1597079813-function-more-activity-in-rows-and-pass-the-result-of-the-last-result-in-start-cell-query-for-function-1
Sheet: COLUMN

 |  | Column | Activity | Date | Condition
 |  |  | Activity_1 | 2020-02-01 00:00:00
 |  |  | Activity_2 | 2020-02-02 00:00:00
 |  |  | Activity_3 | 2020-02-03 00:00:00
 |  |  | Activity_4 | 2020-02-04 00:00:00
 |  |  | Activity_5 | 2020-02-05 00:00:00
 |  |  | Activity_6 | 2020-02-06 00:00:00
 |  |  | Activity_7 | 2020-02-07 00:00:00
 |  |  | Activity_8
 |  |  | Activity_9
 |  |  | Activity_10
 |  |  | Activity_11
 |  |  | Activity_12
 |  |  | Activity_13
 |  |  | Activity_14
 |  |  | [NAME]
 |  |  | Activity_16
 |  |  | Activity_17
 |  |  | Activity_18
 |  |  | Activity_19
Spreadsheet: 124984d1318788406-working-with-a-table-pivot
Sheet: Sheet1

NAME | EVENT | COUNT |  |  |  | Sum of COUNT | Column Labels
aa | a1 | 2 |  |  |  | Row Labels | aa | bb
aa | a2 | 1 |  |  |  | a1 | 2 | 3
bb | a1 | 3 |  |  |  | a2 | 1
bb | c2 | 4 |  |  |  | c2 |  | 4
Spreadsheet: 725067d1616516517-deleting-duplicates-by-value-sample-sheet
Sheet: Sheet1

Links | Number | Category | Date | Time | Convey # | Bldg Name | Type | Status
<a href="URL/2021-02/9ca84794-5225-4fbb-9beb-07f73cb3fa2e.htm">View</a> | ED 459486 | VCJ | 2021-02-26 00:00:00 | 15:07 | EC6026 | Courthouse | Periodic | PASS
<a href="URL/2021-03/7960c00a-882c-4d1c-a687-9932e1040683.htm">View</a> | ED 459566 | VCJ | 2021-03-05 00:00:00 | 15:10 | FB11001 | Community Building | Periodic | FAIL
<a href="URL/2021-03/9b54ba82-b5ff-4701-8cea-0889e793cf22.htm">View</a> | ED 459563 | VCJ | 2021-03-05 00:00:00 | 14:25 | FB11292 | A High School | Periodic | PASS
<a href="URL/2021-02/a5a2a938-7543-4489-8e69-7028addff7ae.htm">View</a> | ED 459473 | VCJ | 2021-02-24 00:00:00 | 19:01 | FB11292 | A High School | Periodic | FAIL
<a href="URL/2021-01/a960e6dc-5673-424e-b4d9-a57a410c8ac5.htm">View</a> | ED 459228 | VCJ | 2021-01-27 00:00:00 | 18:54 | FB11328 | Estates | Periodic | PASS
<a href="URL/2021-03/9cbf9d8e-eae4-48c5-a73b-acde8a8881ff.htm">View</a> | ED 459564 | VCJ | 2021-03-05 00:00:00 | 14:26 | FB11329 | B High School | Periodic | PASS
<a href="URL/2021-02/aa1dff24-43bd-4ad6-b194-70de0189326e.htm">View</a> | ED 459472 | VCJ | 2021-02-24 00:00:00 | 18:49 | FB11329 | B High School | Periodic | FAIL
<a href="URL/2021-02/aa1dff24-43bd-4ad6-b194-70de0189326e.htm">View</a> | ED 459472 | VCJ | 2021-02-02 00:00:00 | 18:49 | FB11329 | B High School | Periodic | FAIL
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: January

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  | 1 | First Choice |  |  | 2 | Second Choice |  |  | 3 | Third Choice |  |  | A | Available
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days
 | [NAME] |  |  | V | V | V | V |  |  |  |  |  |  | V
 | [NAME] |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  |  |  | V | V | V
 | [NAME] |  |  | P |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 | Jan |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 | [NAME] |  |  |  | S | V | V |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  | S |  |  |  |  |  |  | V
Spreadsheet: 863878d1711275785-exchanging-no-s-for-names-examplebook1golf-3-aligw
Sheet: Sheet2

 |  |  | 0 |  | 0
 |  |  | 1
 |  |  | 1 |  | 1 |  | 0
 |  |  | 0 |  |  |  |  |  |  | these players corespond to the list in sheet 1
 |  |  | 0
 |  |  | 1 |  | 0 |  | 1
 |  |  | 0
 |  |  | 1 |  | 1
 |  |  | 0 |  | 0
fred (player 2) |  |  | 1
bill
[NAME] |  |  | 1 |  | 1 |  | 0
[NAME] |  |  | 0
alf
[NAME] |  |  | 0
[NAME] |  |  | 1 |  | 0 |  | 1
 |  |  | 0
 |  |  | 1 |  | 1
Spreadsheet: 50356d1249746485-how-do-i-skip-a-cell-and-move-on-to-the-next-one-indexmatchkey-simple-modified-
Sheet: Items

 | Time | Start Time | End Time |  | Items | 4
1 | Office | 500 | 600
2 | Field | 600 | 700
3 | Office | 800 | 900
4 | Field | 1000 | 1100
5
6
7
8
9
10
Spreadsheet: 828239d1683311554-unable-to-find-formulas-gantt-project-planner_template
Sheet: Project Planner

 | Project Planner
 | Select a period to highlight at right.  A legend describing the charting follows. |  |  |  |  | Period Highlight: | 1 |  |  | Plan Duration |  |  |  |  |  | Actual Start |  |  |  |  | % Complete |  |  |  |  | Actual (beyond plan) |  |  |  |  |  |  |  | % Complete (beyond plan)
 | ACTIVITY | PLAN START | PLAN DURATION | ACTUAL START | ACTUAL DURATION | PERCENT COMPLETE | PERIODS
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
 | Activity 01 | 1 | 5 | 1 | 4 | 0.25
 | Activity 02 | 1 | 6 | 1 | 6 | 1
 | Activity 03 | 2 | 4 | 2 | 5 | 0.35
 | Activity 04 | 4 | 8 | 4 | 6 | 0.1
 | Activity 05 | 4 | 2 | 4 | 8 | 0.85
 | Activity 06 | 4 | 3 | 4 | 6 | 0.85
 | Activity 07 | 5 | 4 | 5 | 3 | 0.5
 | Activity 08 | 5 | 2 | 5 | 5 | 0.6
 | Activity 09 | 5 | 2 | 5 | 6 | 0.75
 | Activity 10 | 6 | 5 | 6 | 7 | 1
 | Activity 11 | 6 | 1 | 5 | 8 | 0.6
 | Activity 12 | 9 | 3 | 9 | 3 | 0
 | Activity 13 | 9 | 6 | 9 | 7 | 0.5
 | Activity 14 | 9 | 3 | 9 | 1 | 0
 | Activity 15 | 9 | 4 | 8 | 5 | 0.01
 | Activity 16 | 10 | 5 | 10 | 3 | 0.8
 | Activity 17 | 11 | 2 | 11 | 5 | 0
 | Activity 18 | 12 | 6 | 12 | 7 | 0
 | Activity 19 | 12 | 1 | 12 | 5 | 0
 | Activity 20 | 14 | 5 | 14 | 6 | 0
 | Activity 21 | 14 | 8 | 14 | 2 | 0.44
 | Activity 22 | 14 | 7 | 14 | 3 | 0
 | Activity 23 | 15 | 4 | 15 | 8 | 0.12
 | Activity 24 | 15 | 5 | 15 | 3 | 0.05
 | Activity 25 | 15 | 8 | 15 | 5 | 0
 | Activity 26 | 16 | 28 | 16 | 30 | 0.5
Spreadsheet: 776064d1649483886-spill-filter-formula-upwards-book1
Sheet: Sheet1

 |  | CURRENT FORMAT |  |  |  |  |  |  |  | PREFERRED [NAME]
 |  | Shovel |  |  |  |  |  |  |  | Shovel
 |  | 4100C BOSS | 6020B | EX2500 | EX8000 |  |  |  |  | 4100C BOSS | 6020B | EX2500 | EX8000
 |  | F1601 |  |  |  | F1601 |  |  |  | F1601
 |  | F1602 |  |  |  | F1602 |  |  |  | F1602
 |  | F1603 |  |  |  | F1603 |  |  |  | F1603
 |  | F1604 |  |  |  | F1604 |  |  |  | F1604
 |  | F1605 |  |  | F1401 | F1605 |  |  | F1401 | F1605 |  |  | F1401
 |  | F1606 |  |  | F1402 | F1606 |  |  | F1402 | F1606 |  |  | F1402
 |  | F1607 | R0248 | F1302 | F1403 | F1607 | R0248 | F1302 | F1403 | F1607 | R0248 | F1302 | F1403
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | 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
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8219 | 26147.57 | 7 | -3145.64
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -12660 | -29016.72 | 4434 | 10157.72
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4441 | 12909.99 | -4441 | -12909.99
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 6.47
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -12660 | -178.95 | 4441 | 44.42
 | 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 |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 718116d1612989596-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 11

 |  |  | Date | 2021-01-11 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 10:00:00 | 12:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 15:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 08:00:00 | 09:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine5 | 10:00:00 | 11:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine5 | 13:00:00 | 14:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine5 | 15:00:00 | 16:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 160409d1339079705-multiple-orders-per-client-ef105_combine_multi_orders
Sheet: Sheet2

Client Name | Order1 | Order2 | Order3 | Order4 | Order5 | Order6 | Order7 | Order8 | Order9 | Order10
[NAME]
[NAME]
^
List clients in any order
Copy formula in B2 across
and down to suit
Spreadsheet: 672363d1586845708-get-the-count-of-the-column-entries-comparing-2-sheets-data
Sheet: Sheet1

ID | Name | Priority list | Comments
1 | AA | 3 | NA
2 | BB | 4 | NA
3 | AA | 4 | NA
4 | CC | 3 | NA
5 | DD | 4 | NA
6 | AA | 5 | NA
7 | DD | 5 | NA
8 | AA | 4 | NA
Spreadsheet: eac4db15-3ec4-49f0-956a-5c20d80a1cd7
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 5/24/2013 1:43:50 PM
 | Debbie G Kleven - NON | [NAME]
Judgeship Number 5 - NON | 7198 | 1483
TOTAL | 7198 | 1483
 | [NAME] | [NAME]
Judgeship Number 5 - NON | 7897 | 5695
TOTAL | 7897 | 5695
 | [NAME]
Judgeship Number 6 - NON | 15316
TOTAL | 15316
 | [NAME]
Judgeship Number 6 - NON | 23659
TOTAL | 23659
 | [NAME]
Judgeship Number 7 - NON | 15323
TOTAL | 15323
 | [NAME]
Judgeship Number 7 - NON | 23704
TOTAL | 23704
 | [NAME]
Judgeship Number 8 - NON | 23060
TOTAL | 23060
 | [NAME] | [NAME]
Judgeship Number 9 - NON | 9956 | 7945
TOTAL | 9956 | 7945
 | [NAME] | [NAME] | [NAME]
Judgeship Number 1 - NON | 3951 | 10268 | 1631
TOTAL | 3951 | 10268 | 1631
 | [NAME]
Judgeship Number 1 - NON | 24071
TOTAL | 24071
 | [NAME] | [NAME]
Judgeship Number 2 - NON | 7510 | 7124
TOTAL | 7510 | 7124
 | Lester Ketterling - NON
Judgeship Number 3 - NON | 13318
TOTAL | 13318
 | [NAME]
Judgeship Number 4 - NON | 7734
TOTAL | 7734
 | [NAME]
Judgeship Number 4 - NON | 13097
TOTAL | 13097
 | [NAME]
Judgeship Number 5 - NON | 15280
TOTAL | 15280
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Tax

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  |  | Per HC |  | New HC |  | Adjusted Amts | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation |  | 0 |  | 4
 | Special Pays | 0
 | Analysts & Associates | 0 |  |  |  |  |  |  | Other |  |  |  | 4
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 30000
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | Admins | 40000
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 41000
ENATECH | Technology |  |  |  |  |  |  |  | Analysts | 48000
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 52000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr Specialst | 62000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Managers | 75000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | 1 | Directors
 |  |  |  |  |  |  |  | 3 | Sr Director
 | Headcount |  |  | 27 | 5 |  |  |  | Vice President | 180000 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | [NAME] | 260000
 | Analysts & Associate Headcount |  |  | 0
 | Total Headcount |  |  |  |  |  |  |  | Benefits & Taxes |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 | Outside Services | 195340 |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC |  | Exp/New HC
 |  |  |  |  |  |  |  | Also adjusted up to reach a total of $800k.