tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273839d1382935305-get-set-of-multiple-values-from-a-table-based-on-condition-excelforumquestion
Sheet: Sheet1

 | 2013-10-03 00:00:00 | 2013-10-03 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-04 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-05 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-06 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-07 00:00:00 | 2013-10-07 00:00:00
 | Actual | Plan | Hrs | Actual | Plan | Hrs | Actual | Plan | Hrs | Actual | Plan | Hrs | Actual | Plan | Hrs
 | 1 | 1 | 1 |  |  |  |  | 2 |  | 1 | 1 | 1
 |  | Actual | 10/3-2 , 10/6-1 |  |  |  | This is what I need
 |  | Plan | 10/3-1, 10/5-2, 10/6-1
Spreadsheet: 710328d1608841417-opportunity-cost-calculation-opportunity-cost_3
Sheet: Sheet1

Item# | Quantity | Cost | Opportunity
12345 | 5 | 200
12346 | 10 | 200
12347 | 150 | 180
12347 | 20 | 60
12347 | 400 | 240
12348 | 10 | 200
12349 | 15 | 300
12350 | 150 | 100
12350 | 20 | 50
12351 | 10 | 200
12352 | 15 | 300
Opportunity = Zero for same Item #
Opportunity= If there is different Cost
Equals to the Sum of difference average Cost*Quantity
Example: For Item 12347, Average cost is $160, so opportunity is sum of 400x( 240-160) and 150 x (180-160)
Spreadsheet: sally_beck__34364__London EGM Middle_Back Office Resources
Sheet: Sheet1

[NAME] working on EGM and Ectric
Name |  | Job Role | Group | Date Expectation
[NAME] | Thurbin | Contract values and close outs. | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Elaine | Whiting | Documentation, log & review of termination notices | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
[NAME] | [NAME] | Contract values and close outs. | Ectric | Terminating  Jan 31, 2002
Carol | Chew | Contract values, cash allocation, cash collection | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Rebecca | Millerchip | Settlements, cash collection, etc. | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Hinesh | Thakaria | Settlements, cash collection, etc. | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Maya | Beyhum | Acctg, cash allocation | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Geraldine | Shore | Acctg, cash allocation | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
[NAME] | Horn | Assisting with all of this activity plus managing this effort. | Ectric | March 31, 2002 plus depending on info requirement for Chap 11
Note:   For the Ectric staff, they are working on shutting down approx 14 entities that are US legal entities, plus they are being partially
allocated (approx 30%) to PWC for their work on the liquids petrochemical and coal business that was UK legal enities that went into receivorship.
The split for the remaining 70% would be 50% to EGM activity, 10% to non EGM activity and 10% for special requests from Houston.
This includes handling the contracts that were once done in Singapore for Ectric.
 |  |  | Current Cost Split |  |  | Split after Jan 31, 2002
 |  | Total Number of People |  | 9 |  |  | 8
 |  | FTE for EGM wind down
 |  | FTE for ECTRIC Gas and Power
 |  | FTE for PWC
 |  | Total FTE
Spreadsheet: 844795d1696470782-invalid-reference-problem-tying-pictures-to-dropdown-list-problem-bvj-
Sheet: Database

Brackets |  |  |  | Groups |  |  | Fields |  |  | Flags men | cell names | Men_teams |  | Flags ladies | cell names | Ladies teams
Men's bracket |  |  |  | Group A |  |  | Field 1 |  |  |  |  | Team 1 |  |  |  | Team 1 L
Ladies bracket |  |  |  | Group B |  |  | Field 2 |  |  |  |  | Team 2 |  |  |  | Team 2
 |  |  |  | Group C |  |  | Field 3 |  |  |  |  | Team 3 |  |  |  | Team 3
 |  |  |  | Group D |  |  | Field 4 |  |  |  |  | Team 4 |  |  |  | Team 4
 |  |  |  | Group E |  |  | Field 5 |  |  |  |  | Team 5 |  |  |  | Team 5
 |  |  |  | Group F |  |  | Field 6 |  |  |  |  | Team 6 |  |  |  | Team 6
 |  |  |  | Group G |  |  | Field 7 |  |  |  |  | Team 7 |  |  |  | Team 7
 |  |  |  | Group H |  |  |  |  |  |  |  | Team 8 |  |  |  | Team 8
 |  |  |  |  |  |  |  |  |  |  |  | Team 9 |  |  |  | Team 9
 |  |  |  |  |  |  |  |  |  |  |  | Team 10 |  |  |  | Team 10
 |  |  |  |  |  |  |  |  |  |  |  | Team 11 |  |  |  | Team 11
 |  |  |  |  |  |  |  |  |  |  |  | Team 12 |  |  |  | Team 12
 |  |  |  |  |  |  |  |  |  |  |  | Team 13 |  |  |  | Team 13
 |  |  |  |  |  |  |  |  |  |  |  | Team 14 |  |  |  | Team 14
 |  |  |  |  |  |  |  |  |  |  |  | Team 15
 |  |  |  |  |  |  |  |  |  |  |  | Team 16
Spreadsheet: 55596479-4b13-4dbb-96fc-eb5dd569b247
Sheet: Sheet1

[NAME] SHEET (1) |  |  |  |  |  |  | Pay Request No: |  |  |  |  | [NAME] SHEET (2) |  |  |  |  |  |  |  |  |  |  | Pay Request No:
 | [NAME]: |  |  |  |  | Period From: |  | Period To: |  |  |  | [NAME]: |  |  |  |  |  |  |  |  |  | Period From: |  | Period To:
 | Project Name: |  |  |  |  | Project No: |  |  |  |  |  |  | Project Name: |  |  |  |  |  |  |  | Project No:
 |  | * | Calculating Columns |  |  |  |  |  |  |  |  |  |  | * | Calculating Columns |  |  | If "LS" item, enter % complete as a decimal
A | B |  | C | D | E | F | G | H | I | J |  | K | L | M | N | O | P
Item No. | Description of Work |  | * Scheduled Value | Work Completed |  | Materials Presently Stored                         (Not in D or E) | * Total Completed and Stored to Date      (D + E + F) | * %                     Completed             to Date                        (G ÷ C) | * Balance                             to Finish                            (C - G) | Retention |  | Item No. | Contract Quantity | Unit Type | Unit                    Cost | Work Completed
 |  |  |  | Previous Pay App                                       (prior period                       D + E) | * Amount This Period |  |  |  |  |  |  |  |  |  |  | Quantity Completed this Period | * %           Completed this Period
1 |  |  | 0 | 0 |  | 0 |  |  |  | 0 |  | 1 | 0 |  | 0
2 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 2 | 0 |  | 0
3 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 3 | 0 |  | 0
4 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 4 | 0 |  | 0
5 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 5 | 0 |  | 0
6 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 6 | 0 |  | 0
7 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 7 | 0 |  | 0
8 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 8 | 0 |  | 0
9 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 9 | 0 |  | 0
10 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 10 | 0 |  | 0
11 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 11 | 0 |  | 0
12 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 12 | 0 |  | 0
13 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 13 | 0 |  | 0
14 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 14 | 0 |  | 0
15 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 15 | 0 |  | 0
16 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 16 | 0 |  | 0
17 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 17 | 0 |  | 0
18 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 18 | 0 |  | 0
19 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 19 | 0 |  | 0
20 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 20 | 0 |  | 0
21 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 21 | 0 |  | 0
22 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 22 | 0 |  | 0
23 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 23 | 0 |  | 0
24 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 24 | 0 |  | 0
25 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 25 | 0 |  | 0
26 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 26 | 0 |  | 0
27 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 27 | 0 |  | 0
28 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 28 | 0 |  | 0
29 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 29 | 0 |  | 0
Spreadsheet: 12641b8b-0c60-45a9-b750-70e9f5abed48
Sheet: Kellogg_ScheduleResults

Course ID | Weeks | Title | Instructor | Times | Campus | Sec ID | Credits | Location | Mand 1st | Day(s) of Week
ENTR 941 |  | Innovation Lab II | Darragh, [NAME]; Parkinson, [NAME] | Mon/Thu 08:30 AM - 10:00 AM | Evanston | 61 | 1 | Jacobs | N | 1.1
MKTG 961 | B | [NAME] for Digital Marketing | [NAME], Sean | Mon 06:00 PM - 09:00 PM | Chicago | 71 | 0.5 | Wieboldt | N | 1.3
ENTR 463 |  | Successful Entrepreneurship | Shefsky, Lloyd | Mon 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 1.3
ENTR 902 | A | Entrepreneurial Selling: Skills and Strategies | [NAME], [NAME] | Mon 06:30 PM - 09:30 PM | Evanston | 81 | 0.5 | Jacobs | N | 1.3
MGMT 934 |  | Managing Turnarounds Managing Turnarounds | Shein, [NAME] | Mon 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 1.3
FINC 446 |  | Entrepreneurial Finance | Lear, [NAME] | Tue/Fri 08:30 AM - 10:00 AM | Evanston | 61 | 1 | Jacobs | N | 2.1
MGMT 441 |  | Intellectual Capital Management (formerly TECH-441-0) | [NAME], [NAME] | Tue/Fri 10:30 AM - 12:00 PM | Evanston | 61 | 1 | Jacobs | N | 2.1
ENTR 462 |  | Entrepreneurship & New Venture Formation | [NAME], [NAME] | Tue 01:30 PM - 04:45 PM | Evanston | 61 | 1 | Jacobs | N | 2.2
ENTR 965 |  | [NAME] of Private Companies | Shein, [NAME] | Tue 01:30 PM - 04:45 PM | Evanston | 61 | 1 | Jacobs | N | 2.2
ENTR 901 | A | Managing Enterprise Risk | Jacobs, [NAME] | Tue 03:15 PM - 06:15 PM | Evanston | 61 | 0.5 | Jacobs | N | 2.2
ENTR 952 |  | Nuvention: Web II | Marasco, [NAME] | TBD ([NAME], tentatively) | Evanston | 61 | 1 | Jacobs | N | 2.2
ENTR 965 |  | [NAME] of Private Companies | Sutter, [NAME], [NAME] | Tue 06:00 PM - 09:00 PM | Chicago | 71 | 1 | Wieboldt | N | 2.3
SEEK 931 |  | NUvention: Innovate for Impact II | Jones, [NAME] | Wed 03:00 PM - 06:00 PM | Evanston | 61 | 1 | Jacobs | N | 3.2
ENTR 462 |  | Entrepreneurship & New Venture Formation | Schonthal, [NAME] | Wed 06:00 PM - 09:00 PM | Chicago | 71 | 1 | Wieboldt | N | 3.3
BLAW 911 | A | Business Law for Entrepreneurs | Bradley, [NAME] | Wed 06:30 PM - 09:30 PM | Evanston | 81 | 0.5 | Jacobs | N | 3.3
ENTR 935 | B | Intellectual Property for Entrepreneurs | [NAME], [NAME] | Wed 06:30 PM - 09:30 PM | Evanston | 81 | 0.5 | Jacobs | N | 3.3
FINC 445 |  | Private Equity and Venture Capital | Hochberg, [NAME] | Wed 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 3.3
ENTR 925 |  | Start-up Programming and Management | [NAME], [NAME] | [NAME] | Evanston | 61 | 1 | Jacobs | N | 4.2
ENTR 926 |  | Venture Capital and Private Equity - The Human Element | Sutter, [NAME], [NAME] | Thu 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 4.3
FINC 471 |  | Case Studies in Venture Investment | Hochberg, [NAME] | Thu 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 4.3
MKTG 913 |  | Internet Marketing | [NAME], [NAME] | Thu 06:30 PM - 09:30 PM | Evanston | 81 | 1 | Jacobs | N | 4.3
FINC 446 |  | Entrepreneurial Finance | Fields, Venita | Sat 01:30 PM - 04:30 PM | Chicago | 76 | 1 | Wieboldt | N | 6
Spreadsheet: 41474d1239950071-look-up-multiple-columns-return-multiple-values-book1
Sheet: Sheet1

1 | A | B | C | 1 | A | B | C
2 | D | J | O | 3
3 | B | G | U | 4
4 | C | H | Q | 5
5 | B | B | D | 7
6 | G | H | M | 8
7 | F | C | Y
8 | E | B | A
Spreadsheet: 883914d1732690558-formula-to-repeat-a-set-of-values-in-a-column-when-user-enters-a-records-template_1
Sheet: Sheet1

User Entry | Item
1 | [NAME]
1 | Keyboard
1 | Speaker
1 | Wires
1 | Adapter
1 | Monitor
1 | Headphone
1 | Webcam
2
3
Spreadsheet: 794901d1662392587-random-number-with-condition-random
Sheet: Blad1

650000
1999000 | random | delta | %delta | new random
20000000
Spreadsheet: e9820282-38a2-4295-9223-4ba5342404bb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NAU | Test | NAU | Sodium, [NAME] | Sodium, U | Potentiometric, Indirect Ion-Selective Electrode | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL urine tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 25 mL of 50% acetic acid as preservative at start of collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.  Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	Yes Thymol	Yes | 1.0 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 41-227 mmol/24 hours | Monday through Sunday continuously | Same day/1 day | 2 days | 1 | 84300 |  |  |  |  | Rochester
NAU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
NAU | Order Question | TM11 | Collection Duration |  | Plain Text
NAU | Order Question | VL9 | [NAME] |  | Plain Text
NAU | Result | NA_24 | Sodium, 24 Hr, U | Sodium, 24 Hr, U | Numeric |  |  |  |  | mmol/24 h |  |  |  |  |  |  |  |  |  | 2956-1 | Sodium:SRat:24H:[NAME]:Qn:
NAU | Result | TM11 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
NAU | Result | VL9 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
NAU | Result | NACN | Sodium Concentration | Sodium Concentration | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 21525-1 | Sodium:SCnc:24H:[NAME]:Qn:
Spreadsheet: 736787d1623860675-formula-required-for-list-creation-within-worksheet-help-file
Sheet: Data

Selection 1 |  | Parts |  | List values |  | Unique list from ideal display
Selection 1 |  | Part1 |  | Selection 1 |  | I would a list to appear in column G  of all parts found on the "ideal selcetion" column B but with no duplicates.
 |  | Part2 |  | Selection 2
 |  | Part3 |  | Selection 3
 |  | Part4 |  | Selection 4
Selection 2 |  | Part1
 |  | Part2 | These are the selection list option and build ups
 |  | Part5
 |  | Part6
 |  | Part7
 |  | Part8
Selection 3 |  | Part3
 |  | Part4
 |  | Part9
 |  | Part10
 |  | Part11
 |  | Part12
 |  | Part13
 |  | Part14
Selection 4 |  | Part1
 |  | Part5
 |  | Part9
 |  | Part15
 |  | Part16
 |  | Part17
 |  | Part18
 |  | Part19
 |  | Part20
 |  | Part21
 |  | Part22
 |  | Part23
 |  | Part24
 |  | Part25
 |  | Part26
 |  | Part27
 |  | Part28
 |  | Part29
 |  | Part30
Spreadsheet: 852981d1702950903-countifs-excluding-certain-items-using-countifs-to-exclude-certain-items
Sheet: Sheet1

Branch | Value
BR1 | -10284.97 | 1
BR2 | -21450.98 | 2
BR3 | -14505.88 | 3
BR4 | -763.22 | 4
BR5 | -30525.45 | 5
BR6 | 53670.93
BR7 | 116185.79
BR8 | 26335.18
BR9 | -30434.27 | 6
HeadofficeBR1 | -243165.81
[NAME] | -7365.02 | 7
BL2 | -6866.73 | 8
Headoffice-BL | 45088.79
Br10 | -19117.95 | 9
Headoffice BN1 | 6763.28
BN1 | -17464.79 | 10
BN2 | -14237.22 | 11
BN3 | -399.88 | 12
BN4 | -7980.61 | 13
BN5 | -6294.04 | 14
No of Items less then Zero, Excluding admin branches
Spreadsheet: 477094d1472137136-how-to-get-data-based-on-multiple-criteria-without-duplicating-the-data-oeldere-477085d1472133989-how-to-get-data-based-o-multiple-criteria-without-duplicating-the-d
Sheet: Blad1

Som van Quantity Sold | Kolomlabels
Rijlabels | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-08 00:00:00 | 2016-01-09 00:00:00 | 2016-01-10 00:00:00 | Eindtotaal
Calamari Rings | 5 | 8 | 3 | 7 | 11 | 14 | 48
Crinkle Cut | 15 | 20 | 30 | 5 | 3 | 9 | 82
Fish Fillet |  |  |  | 5 | 1 | 13 | 19
Shoestring | 10 | 6 | 11 | 10 | 21 | 14 | 72
Spicy Wedges | 11 | 2 | 10 | 9 | 6 | 31 | 69
Straight Cut | 20 | 8 | 18 | 5 | 19 | 17 | 87
Eindtotaal | 61 | 44 | 72 | 41 | 61 | 98 | 377
Spreadsheet: 732733d1621190568-expected-output-based-on-3-dropdowns-sample-workbook-with-multiple-criteria
Sheet: Status

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ownership Filter |  |  | Status Filter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC |  | RNR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL |  | ALL
 |  | DEF |  | Ownership |  | 1st Drop Down |  |  |  |  |  |  |  |  |  |  | ABC |  | RNR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEF |  | Complete
 |  | WNS |  | Status |  | 2nd Drop Down |  |  |  |  |  |  |  |  |  |  | GHI |  | WNS
EXPECTED OUTCOME |  | Unique Names | Unique Names | Count | Count
 |  | Ownership | Reconciler | Status | Approved | Grand Total
Spreadsheet: 872590d1718965392-dashboard-with-tables-linking-to-specific-person-90paulwilson-hr-dashboard-anon-aligw
Sheet: Data

Absences
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | All Staff
 |  | January | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  |  | January |  |  |  | Reporting Error
 |  | February | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 |  |  |  | February | 4 |  | [NAME] | Commissioning Error
 |  | March | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  |  | March | 6 |  | [NAME] | Customer Service
 |  | April | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  |  | April | 6 |  | [NAME] | Customer Service
 |  | May | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 |  |  |  | May | 2 |  | [NAME] | Install Error
 |  | June | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  |  | June | 4
 |  | July | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 2 |  |  |  | July | 9
 |  | August | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 |  |  |  | August | 3
 |  | September | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  |  | September | 5
 |  | October | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  |  | October | 6
 |  | November | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  |  | November | 6
 |  | December | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |  |  |  | December | 4
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 61
Spreadsheet: 684310d1593284828-counting-formula-in-decending-order-countif-example
Sheet: Sheet1

AMY | 1 |  |  | I need the numbers to count in the order in column B
AMY | 2
AMY | 3
AMY | 4
AMY | 5
AMY | 6
AMY | 7
AMY | 8
AMY | 9
AMY | 10
AMY | 11
[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
[NAME] | 5
[NAME] | 6
[NAME] | 7
MARY | 1
MARY | 2
MARY | 3
MARY | 4
MARY | 5
MARY | 6
MARY | 7
MARY | 8
MARY | 9
MARY | 10
MARY | 11
MARY | 12
MARY | 13
MARY | 14
MARY | 15
MARY | 16
MARY | 17
MARY | 18
MARY | 19
MARY | 20
MARY | 21
MARY | 22
MARY | 23
MARY | 24
MARY | 25
MARY | 26
STEVE | 1
STEVE | 2
STEVE | 3
STEVE | 4
STEVE | 5
STEVE | 6
STEVE | 7
STEVE | 8
STEVE | 9
STEVE | 10
STEVE | 11
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 57220978 | 253332314
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 12484802 | 51523816
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 69705780 | 304856130
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -55803448 | -241501122
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -12792888 | -52728873
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | -262842 | -1006304
 | Total Purchases: |  | -68859178 | -295236299
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 1582745 | 6332608
12 |  | Purchases | -226883 | -866256
 | Total Intra CTS Sales / Purchases |  | 1355862 | 5466352
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 35065 | 131336
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -2124217 | -10386405
 | Total Imbalances: |  | -2089152 | -10255069
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 112536 | 345054
18 |  | W/D (Purchase from Stg) | -209037 | -681058
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -209037 | -681058
 | Total Storage: |  | -96501 | -336004
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -16811 | -72121.88612754348
 |  |  | 0 | 0
23 | Fuel: |  | 262842 | 1006304
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -318416
25 |  | Demand | 0 | -1123176.92
 | Total Transport Expense: |  | 0 | -1441592.92
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance | 18364574
 |  | Total MTM Income | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -528305
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | [NAME] | 0 | 0
40 |  | Miscellaneous | 0 | -131377
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 88992ad2-b4f8-4e63-b133-e6729e1f7807
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FENTQ | Test | FENTQ | Enterovirus RNA, Qualitative, RT-PCR | Enterovirus RNA, Qualitative,RT-PCR | Reverse transcriptase-PCR (RT-PCR) | Viral Transport Media: VirTnsMed |  |  | 0.5 | mL | Submit only 1 of the following specimens:   Throat or rectal swab: Collect 0.7 mL viral transport medium. M4 media, V-C-M medium (green top) tube, equivalent (UTM), or M-5 media (supply T484) is acceptable. Ship specimen frozen.    Plasma: Draw blood in a yellow top (ACD), lavender top (EDTA) tube or plasma separator tube (PPT). Spin down and transfer 0.7 mL ACD or EDTA plasma into a plastic, screw-top vial. Ship specimen frozen.   [NAME]: Draw blood in a no-additive, red-top tube. Spin down and submit 0.7 mL serum. Ship specimen frozen.   Stool: Collect 1 gram random stool in a sterile, plastic container. Freeze immediately and ship frozen. |  | Specimens other than	Throat swab, rectal swab, serum, plasma, stool Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE: NOT DETECTED        This test was developed and its performance characteristics have been determined by Focus Diagnostics. Performance characteristics refer to the analytical performance of the test. This test is performed pursuant to a license agreement with Roche Molecular Systems, Inc.        Test Performed By:   Focus Diagnostics, Inc.                                5785 Corporate Ave.                                Cypress, CA 90630-4750 | Monday through Sunday | 1-3 days | 3-5 days | 1 | 87498 |  |  |  |  | Focus Diagnositics, Inc.
FENTQ | [NAME] | VARIES | Varies |  |  |  | Frozen | 30 days
FENTQ | Order Question | Z0430 | Source |  | Plain Text
FENTQ | Result | Z0430 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FENTQ | Result | Z0679 | Enterovirus Detection, RT-PCR | Enterovirus Detection, RT-PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 889584d1740458135-not-posting-a-value-to-a-validation-cell-example-dropdown-list-error-2025-02-25-01
Sheet: Sheet1

Data Completion |  |  |  |  | Complete: | No
Letter | Name | Position | Number
A
Letter | Name | Position | Number
B
Letter | Name | Position | Number
C
Letter | Name | Position | Number
D
Letter | Name | Position | Number
E
Data
Letter | Name | Position | Number |  | List_Numbers
A | [NAME] | Receptionist | 1
B | [NAME] | Manager | 2 |  | 1
C | Philip Mant | PCT | 3 |  | 2
D | [NAME] | PHO | 4 |  | 3
E | [NAME] | GDB |  |  | 4