tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 44018d1242695804-excel-2007-sumif-problem-book1
Sheet: PURCHASES

 |  |  | GROCERY |  | DESIRED OUTPUT
AMZ*Amazon Payments AMZN.COM/BILL WA | 75.87 |  | 0 |  | 0
PAYPAL *LANPIN [PHONE] CA | 43.98 |  | 0 |  | 0
NCSU BOOKSTORE RALEIGH NC | 295.27 |  | 0 |  | 0
NCSU ALL CAMPUS MICROS RALEIGH NC | 1.28 |  | 0 |  | 0
Amazon.com AMZN.COM/BILL WA | 112.61 |  | 0 |  | 0
[NAME] [PHONE] | 4.95 |  | 0 |  | 0
PAYPAL *BENSONBOOKS [PHONE] CA | 55.45 |  | 0 |  | 0
FOOD LION #1454 RALEIGH NC | 6.75 |  | 0 |  | 6.75
[NAME] RALEIGH NC | 31.44 |  | 0 |  | 31.44
NCSU ALL CAMPUS MICROS RALEIGH NC | 2.19 |  | 0 |  | 0
SUBWAY # 1880 RALEIGH NC | 3.98 |  | 0 |  | 3.98
NCSU ALL CAMPUS MICROS RALEIGH NC | 3.01 |  | 0 |  | 0
NCSU ALL CAMPUS MICROS RALEIGH NC | 3.01 |  | 0 |  | 0
NCSU BOOKSTORE RALEIGH NC | 18.09 |  | 0 |  | 0
[NAME] CORN RALEIGH NC | 15.06 |  | 0 |  | 0
LOWES #00426* CARY NC | 21.34 |  | 0 |  | 0
WESTERN LANES BOWLING CEN RALEIGH NC | 70 |  | 0 |  | 0
 |  |  | 0 |  | 0
Spreadsheet: 86044d1286018633-compare-column-a-between-2-worksheets-and-sum-respective-columns-totalsacrosssheets
Sheet: Totals

INHI_ItemNbr | INHI_CurrQty_1 | INHI_CurrQty_2 | INHI_CurrQty_3 | INHI_CurrQty_4 | INHI_CurrQty_5 | INHI_CurrQty_6 | INHI_CurrQty_7 | INHI_CurrQty_8 | INHI_CurrQty_9
00100907 | 6 | 3 | 3 | 1.8 | 5 | 3 | 6 | 4 | 2
005055 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
010110 | 2 | 2 | 2 | 3 | 2 | 2 | 3 | 3 | 2
010310 | 163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
010350 | 66 | 79 | 69 | 0 | 15 | 64 | 65 | 110 | 48
010380 | 10 | 10 | 7 | 0 | 0 | 8 | 10 | 8 | 9
010391 | 20 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0
015110 | 2 | 2 | 2 | 3 | 1 | 1 | 1 | 2 | 1
015130 | 2 | 1 | 0 | 3 | 2 | 2 | 3 | 1 | 1
015170 | 2 | 0 | 0 | 1 | 2 | 3 | 1 | 0 | 1
020100 | 8 | 4 | 16 | 12 | 3 | 15 | -1 | 20 | 4
020120 | 14 | 19 | 14 | 16 | 23 | 7 | 5 | 11 | 27
020140 | 44 | 38 | 81 | 54 | 51 | 53 | 25 | 47 | 42
020150 | 118 | 148 | 154 | 148 | 124 | 164 | 108 | 96 | 79
020160 | 64 | 28 | 42 | 96 | 27 | 43 | 28 | 25 | 48
020200 | 209 | 54 | 166 | 142 | 173 | 105 | 28 | 42 | 248
020210 | 85 | 52 | 85 | 64 | 52 | 103 | 67 | 83 | 80
020220 | 26 | 32 | 35 | 32 | 28 | 5 | 21 | 30 | 53
020280 | 74 | 17 | 59 | 46 | 49 | 37 | 32 | 34 | 27
020296 | 3 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0
020300 | 78 | 76 | 84 | 58 | 81 | 82 | 87 | 70 | 53
020310 | 167 | 173 | 148 | 211 | 233 | 168 | 204 | 138 | 204
020320 | 340 | 282 | 276 | 359 | 387 | 368 | 277 | 201 | 512
020370 | 1 | 1 | 6 | 6 | 5 | 7 | 7 | 0 | 0
020375 | 3 | 5 | 1 | 1 | 0 | 3 | 7 | 0 | 3
020377 | 23 | 21 | 4 | 5 | 7 | 5 | 10 | 4 | 3
020380 | 22 | 19 | 23 | 26 | 3 | 11 | 16 | 15 | 35
020385 | 106 | 36 | 67 | 89 | 57 | 48 | 46 | 42 | 86
020440 | 26 | 14 | 139 | 28 | 82 | 48 | 57 | 44 | 71
020450 | 1 | 14 | 5 | 7 | 10 | 5 | 6 | 6 | 5
020630 | 5 | 11 | 5 | 4 | 7 | 13 | 9 | 12 | 4
020660 | 39 | 73 | 16 | 4 | 14 | 12 | 6 | 1 | 9
020695 | 7 | 3 | 13 | 10 | 3 | 6 | 5 | 6 | 4
020785 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020930 | 6 | 8 | 9 | 11 | 6 | 10 | 6 | 4 | 14
020940 | 14 | 1 | 1 | 7 | 23 | 5 | 1 | 3 | 13
025020 | 6 | 4 | 7 | 5 | 10 | 8 | 5 | 12 | 8
025080 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1
025140 | 5 | 0 | 15 | 4 | 1 | 0 | 0 | 3 | 1
025150 | 1 | 0 | 18 | 0 | 4 | 0 | 0 | 5 | 10
025170 | 7 | 0 | 15 | 0 | 9 | 1 | 1 | 2 | 0
025180 | 1 | 0 | 8 | 0 | 2 | 6 | 2 | 4 | 13
025190 | 8 | 14 | 29 | 7 | 6 | 8 | 11 | 14 | 18
025200 | 1 | 5 | 2 | 3 | 1 | 2 | 4 | 2 | 3
025210 | 7 | 7 | 5 | 5 | 8 | 9 | 8 | 11 | 10
025245 | 3 | 1 | 3 | 3 | 5 | 2 | 2 | 3 | 4
025290 | 1 | 3 | 2 | 1 | 1 | 1 | 1 | 4 | 0
025480 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2 | 2
Spreadsheet: 785161d1656204082-dynamic-dates-project-data
Sheet: Sheet1

 |  |  |  | Start Date | End Date
 |  |  | Procurement | 2022-05-30 00:00:00 | May, 2022
 |  |  | Category 1
 |  |  | Task | 2022-06-01 00:00:00 | 2022-06-06 00:00:00
 |  |  | Task | 2022-06-07 00:00:00 | 2022-06-15 00:00:00
 |  |  | Task | 2022-06-15 00:00:00 | 2022-07-07 00:00:00
 |  |  | Task | 2022-07-01 00:00:00 | 2022-07-07 00:00:00
 |  |  | Task | 2022-07-07 00:00:00 | 2022-07-15 00:00:00
 |  |  | Task | 2022-07-15 00:00:00 | 2022-07-30 00:00:00
 |  |  | Category 2
 |  |  | Task | 2022-07-15 00:00:00 | 2022-08-15 00:00:00
 |  |  | Task | 2022-07-15 00:00:00 | 2022-08-15 00:00:00
 |  |  | Task | 2022-07-15 00:00:00 | 2022-08-15 00:00:00
 |  |  | Task | 2022-07-15 00:00:00 | 2022-08-15 00:00:00
 |  |  | Task | 2022-07-25 00:00:00 | 2022-07-30 00:00:00
 |  |  | Category 3
 |  |  | Task | 2022-08-01 00:00:00 | 2022-08-05 00:00:00
Spreadsheet: 09a0d050-8420-4138-90fe-2576314f0c77
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 35. LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413911L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413912R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413913T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413914V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413915W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413916X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413917A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413918C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413919F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413920R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413921T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413922V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413923W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413924X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413925A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413926C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 683244d1592575813-formula-aggregate-and-rank-not-with-pivot-service-pilot
Sheet: Data

DATA
month | service | cost (EUR)
1 | car | 100
1 | car | 120
2 | car | 20
2 | car | 30
1 | train | 80
1 | train | 190
2 | train | 10
1 | bus | 10
2 | bus | 30
2 | bus | 20
RESULTS | formula should be in orange cells below | <-- | I do ranking here manualy from pivot table (as mentioned; I would like to have formulas; and not pivot table as solution)
criteria for rank | service/month
top month | 1
top service | train
2nd top service | car
top service in month 2 | bus |  | comment: car has the same RANK (both cost 50); and it would be nice to be able to set preference for lets say - bus (i.e. - we do the ranking; but if 'bus' is tight with some other service; then 'bus' is listed (THIS funcionality is not crucial for me)
Spreadsheet: 463255d1464370827-how-to-change-values-based-on-selection-in-drop-down-menu-copy-of-fiscal-year-calendar
Sheet: Data

 | Code Description |  |  | Name
 | P |  |  | Brown, [NAME]
 | V |  |  | Brown, [NAME]
 | O |  |  | Brown, Donkeisha
 | X |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | Emerson, [NAME]
 |  |  |  | Farmer, Derrell
 |  |  |  | Harris, Meagan
 |  |  |  | [NAME], Iesha
 |  |  |  | Jones, [NAME]
 |  |  |  | Marshall, Rubia
 |  |  |  | Mcbean, [NAME]
 |  |  |  | Trice, Haywood
Spreadsheet: mike_grigsby__27674__New_Gen_Sheet_ver2
Sheet: New Gen

New Generation Additions
1- Under Construction or Completed; 2 - Regulatory Approval Received; 3 - Application under review; 4-Starting app process; 5- Press Release only; 6 - Word of mouth
Region | 1 | 2 | 3 | 4 | 5 | 6
NP15 | 1000 | 880 | 2720 | 1178.7
SP15 |  | 720 | 3136 | 1200
ZP26 | 1048 |  | 1570 | 1530
AZ | 1565 | 660 | 3120 | 825 | 5961
NV |  |  |  | 1280 | 1880 | 500
NM | 140 |  |  |  | 1407
CO | 276 | 550 | 160 | 350 | 160 | 200
OR | 525 | 756 |  |  | 1345 | 45
WA | 248 | 2235 | 660 | 1100
ID, MT, UT, WY | 430 | 244 |  | 485 | 2160
 |  |  |  |  |  | NP15 | ZP26 | SP15 | NW | SW | RO
 |  |  |  |  | 2000-06-01 00:00:00 |  |  |  | 4 | 140
 |  |  |  |  | 2000-07-31 00:00:00 |  |  |  |  |  |  |  |  | 500 | 500 |  |  |  |  |  |  |  | 880
 |  |  |  |  | 2000-08-31 00:00:00
 |  |  |  |  | 2000-09-30 00:00:00
 |  |  |  |  | 2000-10-31 00:00:00
 |  |  |  |  | 2000-11-30 00:00:00
 |  |  |  |  | 2000-12-31 00:00:00
 |  |  |  |  | 2001-01-31 00:00:00
 |  |  |  |  | 2001-02-28 00:00:00
 |  |  |  |  | 2001-03-31 00:00:00
 |  |  |  |  | 2001-04-30 00:00:00
 |  |  |  |  | 2001-05-31 00:00:00
 |  |  |  |  | 2001-06-30 00:00:00
 |  |  |  |  | 2001-07-31 00:00:00
 |  |  |  |  | 2001-08-31 00:00:00
 |  |  |  |  | 2001-09-30 00:00:00 |  | 1048
 |  |  |  |  | 2001-10-31 00:00:00
 |  |  |  |  | 2001-11-30 00:00:00
 |  |  |  |  | 2001-12-31 00:00:00
 |  |  |  |  | 2002-01-31 00:00:00
 |  |  |  |  | 2002-02-28 00:00:00
 |  |  |  |  | 2002-03-31 00:00:00
 |  |  |  |  | 2002-04-30 00:00:00
 |  |  |  |  | 2002-05-31 00:00:00
 |  |  |  |  | 2002-06-30 00:00:00 | 1880
 |  |  |  |  | 2002-07-31 00:00:00 | 1880
 |  |  |  |  | 2002-08-31 00:00:00 | 1880
 |  |  |  |  | 2002-09-30 00:00:00 | 1880
 |  |  |  |  | 2002-10-31 00:00:00 | 1880
 |  |  |  |  | 2002-11-30 00:00:00 | 1880
 |  |  |  |  | 2002-12-31 00:00:00 | 1880
Spreadsheet: 775377d1649068357-create-cell-with-all-dimensions-listed-from-the-same-post-id-size-attribute
Sheet: Sheet1

 | Name | post ID | ID | unike NO | dimensions | all dimensions
1 | Pass &#038; Tok Army-Canvas | 11001 | 18512 | 733003555 | 100x70 | 100x70
2 | Pass &#038; Tok Army-Canvas | 11001 | 18517 | 733001414 | 100x70
3 | Pass &#038; Tok Star | 11002 | 18522 | 733003562 | 100x70 | 100x70
4 | Pass &#038; Tok Star | 11002 | 18527 | 733001421 | 100x70
5 | Pass &#038; Tok Star | 11002 | 18549 | 733003586 | 100x70
6 | Pass &#038; Tok Star | 11002 | 18554 | 733001445 | 100x70
7 | Pass &#038; Tok Star | 11002 | 18569 | 733003609 | 100x70
8 | Pass &#038; Tok Star | 11002 | 18574 | 733001469 | 100x70
9 | Pass &#038; Tok Boutique | 11003 | 18589 | 733003623 | 100x70 | 100x70
10 | Pass &#038; Tok Boutique | 11003 | 18594 | 733001483 | 100x70
11 | Pass &#038; [NAME] | 11004 | 18599 | 733003715 | 85x60 | 85x60|100x70|120x80 |  |  | 100x70 | 120x80
12 | Pass &#038; [NAME] | 11004 | 18604 | 733001575 | 85x60
13 | Pass &#038; [NAME] | 11004 | 18609 | 733003746 | 100x70
14 | Pass &#038; [NAME] | 11004 | 18614 | 733001605 | 100x70
15 | Pass &#038; [NAME] | 11004 | 18619 | 733003753 | 100x70
16 | Pass &#038; [NAME] | 11004 | 18624 | 733001612 | 100x70
17 | Pass &#038; [NAME] | 11004 | 18629 | 733003777 | 120x80
18 | Pass &#038; [NAME] | 11004 | 18634 | 733001636 | 120x80
19 | Pass &#038; [NAME] | 11004 | 18639 | 733003791 | 120x80
20 | Pass &#038; [NAME] | 11004 | 18644 | 733001643 | 120x80
21 | Pass &#038; [NAME] | 11004 | 23749 | 733001650 | 120x80
22 | Pass &#038; [NAME] | 11005 | 23751 | 733001667 | 100x70 | 100x70
23 | Pass &#038; [NAME] | 11005 | 23753 | 733003807 | 100x70
Spreadsheet: 75221d1275775130-how-to-make-formulas-with-numbers-from-several-sheets-book1
Sheet: number4

1
20
30
4
23
33
7
26
36
10
29
39
13
32
42
16
35
45
19
38
0
40
50
Spreadsheet: 71066d1271798757-assigning-values-from-fixed-data-set-to-variable-data-set-zipcode_class
Sheet: Variable

ZIP | Class
613 | U
614 | U
616 | U
617 | U
622 | R
623 | U
624 | U
627 | U
631 | R
636 | U
637 | U
638 | U
641 | S
660 | U
662 | U
664 | S
667 | U
669 | U
670 | R
674 | U
676 | U
198 | R
199 | R
501 | U
544 | U
601 | R
602 | U
Spreadsheet: 121954d1316524385-count-if-mutiple-criteria-but-same-range-is-this-possible-help
Sheet: Sheet3

x | y | Site 1 | 2 | 3
222 | 334 | A
223 | 335 | A | B
224 | 336 | A | B
225 | 337 | B | A
226 | 338 | C | A | B
227 | 339 | B | C | A
228 | 340 | C
229 | 341 | B
PIVOT | A | B | C
A | 0 | 5 | 2
B | 5 | 0 | 2
C | 2 | 2 | 0
Spreadsheet: 857082d1706161076-rearrange-workfile-transpose-formulas-extract
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  |  | London | Paris | Milan | Rome | Madrid | Barcelona | Sofia | [NAME] | Porto | Berlin | Warsaw | [NAME] | Gdansk | Wroclaw | Brussels
Country | Travel | Aircraft 1 | Aircraft 2 |  |  |  |  | [NAME]
London | 20 | 0 | 20 |  |  |  |  | [NAME] | 18 | 12 |  | 7 |  |  |  |  |  |  |  | 0 | 0 | 1 | 2
Paris | 10 | 0 | 10
Milan | 5 | 0 | 5
Rome | 8 | 0 | 8
Madrid | 1 | 0 | 1
Barcelona | 0 | 0 | 0
Sofia | 0 | 0 | 0
[NAME] | 9 | 0 | 9
Porto | 2 | 0 | 2
Berlin | 1 | 0 | 1
Warsaw | 5 | 0 | 5
[NAME] | 0 | 0 | 0
Gdansk | 0 | 0 | 0
Wroclaw | 1 | 0 | 1
Brussels | 2 | 0 | 2
[NAME]
Country | Travel | Aircraft 1 | Aircraft 2
London | 10 | 0 | 18
Paris | 8 | 0 | 12
Milan | 2 | 0
Rome | 3 | 0 | 7
Madrid | 1 | 0
Barcelona | 0 | 0
Sofia | 0 | 0
[NAME] | 7 | 0
Porto | 2 | 0
Berlin | 1 | 0
Warsaw | 4 | 0
[NAME] | 0 | 0 | 0
Gdansk | 0 | 0 | 0
Wroclaw | 1 | 0 | 1
Brussels | 2 | 0 | 2
[NAME]
Spreadsheet: 808950d1670790545-summary-pivot-table-from-more-extensive-data-data-query
Sheet: Power Query

Date | Action | Name1 | [NAME]
2023-01-02 00:00:00 | Booked | [NAME] | [NAME]
2023-01-03 00:00:00 | Booked | [NAME] | [NAME]
2023-01-03 00:00:00 | None | [NAME] | [NAME]
2023-01-03 00:00:00 | None | [NAME] | [NAME]
2023-01-04 00:00:00 | Booked | [NAME] | [NAME]
2023-01-04 00:00:00 | Booked | [NAME] | [NAME]
2023-01-05 00:00:00 | None | [NAME] | [NAME]
2023-01-05 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-05 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-06 00:00:00 | Booked | [NAME] | [NAME]
2023-01-06 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-06 00:00:00 | Booked | [NAME] | [NAME]
Spreadsheet: 45081d1243868184-using-boolean-to-compile-knowledge-flags-send
Sheet: LAMCAR

8 | Country | Sent | Received | Location | Contact | Notes
0 | Argentina
0 | Belize
0 | Bolivia
0 | Brazil
0 | Chili
0 | Colombia
0 | Costa Rica
9 | Cuba | Yes
0 | Dominican Republic
0 | Ecuador
0 | El Salvador
0 | Guatemala
0 | Guyana
0 | Haiti
0 | Honduras
0 | Jamaca
0 | Mexico
0 | Nicaragua
0 | Panama
0 | Paraguay
0 | Peru
0 | Puerto Rico
0 | Trinidad
0 | Uruguay
0 | Venezuela
0
0
0
0
0
0
0
0
Spreadsheet: 681705d1591707155-formula-that-identifies-marks-same-priority-levels-across-all-items-formula-to-identify-same-priorities-throughout
Sheet: Sheet1

Priority | Organization (e.g., US State) | Manually Identified | [NAME]
1 | CA
2 | CA
1 | FL
2 | FL
3 | FL
4 | FL
1 | IN | x
1 | IN | x
1 | IN | x
1 | IN | x
1 | IN | x
1 | IN | x
1 | NY
2 | NY
2 | NY
2 | NY
5 | NY
6 | NY
7 | NY
7 | NY
9 | NY
10 | NY
11 | NY
Spreadsheet: 734506d1622210155-take-the-most-recent-month-from-my-data-and-the-days-and-the-qty-associated-with-it-work-in-progress-1-
Sheet: Formulas

Month | Qty |  |  |  | Month | Qty |  |  |  |  | Current Month |  |  | 2021-05-01 00:00:00
 |  |  |  |  | 1 |  |  |  |  |  | Date | Qty
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 10
 |  |  |  |  | 11
 |  |  |  |  | 12
Spreadsheet: scott_neal__37895__STOR9804
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9804
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-11-03 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 666 | 687
(TX, LA, OK, KS, MS)
Market Area - East |  | 1661 | 1678
Market Area - West |  | 385 | 383
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: mary_fischer__25605__926
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0926
COMPANY NAME Artemis Associates
ANALYSIS OF A/R - OTHER
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Intercompany with 42D, 614-MA |  | -301 |  | 0 |  |  |  | -86.98
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Misc Other |  |  |  |  |  |  |  | 488
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 69107d63-7509-4a62-b6c1-8088dbd99de7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3593 | 13940 | [NAME] | Tiefengraber | AUT | 159 | 00:22:18 | 00:00:00 | [NAME] | 00:00:00 | 00:26:58 | 1 | 01:23:22
3593 | 10307 | [NAME] | De Marcellis | ITA | 158 | 00:22:38 | 00:00:00 | 00:35:40 | 00:00:00 | 00:29:28 | 2 | [NAME]
3593 | 15466 | Siegfried | Schütze | GER | 155 | 00:25:04 | 00:00:00 | 00:39:14 | 00:00:00 | 00:29:55 | 3 | 01:34:13
3593 | 21944 | Joachim | Fischer | GER | 156 | 00:28:15 | 00:00:00 | 00:46:34 | 00:00:00 | 00:34:43 | 4 | 01:49:32
3593 | 21945 | Petr | [NAME] | GER | 157 | 00:28:17 | 00:00:00 | 00:40:16 | 00:00:00 | 00:42:48 | 5 | 01:51:21
Spreadsheet: 713244d1610618043-need-formula-to-calculate-days-used-in-month-initiated-in-previous-and-selected-month-hire-days
Sheet: Sheet1

 |  |  |  |  |  |  | Days hired in March
Month: | 2019-03-01 00:00:00
 | From | To | Days |  | From | To | From Jan | From Feb | From March | Total Days
 | 2019-01-01 00:00:00 | 2019-01-19 00:00:00
 | 2019-01-11 00:00:00 | 2019-04-02 00:00:00 |  |  |  |  | 31
 | 2019-01-20 00:00:00 | 2019-02-18 00:00:00
 | 2019-02-04 00:00:00 | 2019-03-22 00:00:00 |  |  |  |  |  | 22
 | 2019-02-12 00:00:00 | 2019-03-19 00:00:00 |  |  |  |  |  | 19
 | 2019-02-22 00:00:00 | 2019-03-05 00:00:00 |  |  |  |  |  | 5
 | 2019-03-08 00:00:00 | 2019-03-20 00:00:00 |  |  |  |  |  |  | 13
 | 2019-03-15 00:00:00 | 2019-04-06 00:00:00 |  |  |  |  |  |  | 17
 |  |  |  |  | Total S/Be:
 | Month: | 2019-03-01 00:00:00
 | TOTAL HIRE: |  |  |  |  | s/BE:
Spreadsheet: 711622d1609805200-if-statement-help-excelifhelp-1-
Sheet: Sheet1

Away | AS | Home | HS | HomeWin | AwayWin
Indianapolis | 36 | Buffalo | 38.01 | 1 | 0
[NAME] | 31 | Seattle | 34 | 1 | 0
Tampa Bay | 26.1 | Washington | 33 | 1 | 0
Baltimore | 29.1 | Tennessee | 19 | 0 | 1
Chicago | 22 | New Orleans | 53.01 | 1 | 0
Cleveland | 30 | Pittsburgh | 27.01 | 0 | 1
Cleveland |  | Kansas City
 |  | New Orleans
Washington |  | Green Bay
 |  | Buffalo
Spreadsheet: 39823d1238088585-looking-up-a-range-of-cells-with-criterias-attached-forum-example
Sheet: Information

 |  |  |  |  |  |  | Results
Euro | ROI PI | FARM | UK NB | IRL NB | PEN | All-In-One | 0
0.36 | 0.21 | 0.15 | 0.11 | 0.1 | 0.12 | 0.19 | 0.8 |  | Anything lower than these percentages in Row 3 will equal 0
0.41 | 0.25 | 0.19 | 0.17 | 0.14 | 0.16 | 0.23 | 1 |  | E.G. a rate of 12.5% under IRL NB would equal the value of 0.8
0.51 | 0.31 | 0.25 | 0.23 | 0.2 | 0.22 | 0.29 | 1.2 |  | And anything above 26% under IRL NB would equal 1.4
0.55 | 0.37 | 0.31 | 0.29 | 0.26 | 0.28 | 0.35 | 1.4
Spreadsheet: 854519d1704363519-trying-to-use-unique-function-to-create-tracker-trial-sheet
Sheet: Calc

DATE | Enitity | DEPARTMENT | CLASS | Session 1 | Session 2 | Session 3 |  |  |  | Example
 | AQWCH | Finance |  |  |  |  |  |  |  | 2023-11-24 00:00:00 |  | Finance |  | 2 | 2
2023-11-24 00:00:00 | AQWCH | Front Office |  |  |  |  |  |  |  | 2023-11-24 00:00:00 |  | Front Office |  | 6 | 6
2023-11-29 00:00:00 | AQWCH | Physician |  |  |  |  |  |  |  | 2023-11-29 00:00:00 |  | Nurses |  | 13 | 13 | 13
2023-11-29 00:00:00 | AQWCH | Nurses |  |  |  |  |  |  |  | 2023-11-29 00:00:00 |  | Physicians |  | 27
2023-12-08 00:00:00 | AQWCH | Front Office |  |  |  |  |  |  |  | 2023-12-08 00:00:00 |  | Finance |  | 2 | 2
2023-12-08 00:00:00 | AQWCH | Finance |  |  |  |  |  |  |  | 2023-12-08 00:00:00 |  | Front Office |  | 4 | 4
2023-12-13 00:00:00 | AQWCH | Front Office |  |  |  |  |  |  |  | 2023-12-15 00:00:00 |  | Finance |  |  |  | 1
2023-12-19 00:00:00 | AQWCH | Nurses |  |  |  |  |  |  |  | 2023-12-16 00:00:00 |  | Finance |  |  |  | 1
2023-12-21 00:00:00 | AQGH | Finance
2023-12-21 00:00:00 | AQGH | Front Office
2023-12-25 00:00:00 | AQGH | Nurses
2023-12-20 00:00:00 | AQGH | Nurses
2023-12-19 00:00:00 | AQGH | Nurses
2023-12-22 00:00:00 | AQGH | Nurses
2023-12-21 00:00:00 | AQGH | Nurses
2023-12-23 00:00:00 | AQGH | Nurses
2023-12-18 00:00:00 | AQGH | Nurses
2023-12-26 00:00:00 | AQGH | Nurses
2023-12-24 00:00:00 | AQGH | Nurses
2023-12-27 00:00:00 | AQGH | Nurses
2023-12-28 00:00:00 | AQGH | Nurses
2023-12-29 00:00:00 | AQGH | Front Office
2023-12-30 00:00:00 | AQGH | Nurses
2024-01-01 00:00:00 | AQGH | Nurses
2023-12-29 00:00:00 | AQGH | Nurses
2024-01-02 00:00:00 | AQGH | Nurses
2023-12-20 00:00:00 | AQWCH | Nurses
2023-12-01 00:00:00 | AQWCH | Finance
2023-12-01 00:00:00 | AQWCH | Front Office
2023-12-15 00:00:00 | AQWCH | Front Office
2023-12-15 00:00:00 | AQWCH | Finance
2023-12-16 00:00:00 | AQWCH | Finance
2023-12-21 00:00:00 | AQWCH | Nurses
2024-01-03 00:00:00 | AQGH | Nurses