tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75802d1276371099-consolidate-4-worksheets-into-1-copypastetest
Sheet: interface pcb

 | [NAME] of Materials | MTTS | PCB Mainboard expansion interface
ELECTRONICS:
Author: | [NAME] | Date initial: | 2010-05-19 00:00:00
 |  | Updated: | 2010-06-08 00:00:00
PCB serial: | EXPHW-LH091130
PCB revision: | 1.1
Sequence | Designator | Type | Value | Footprint | Description | Qty | price | Ordercode | Note | Inspect1 | Reference
0 |  |  |  |  | PCB |  |  | PCB: INTERFACE |  | GBR 05 gerber interface_1.1.zip
1 | C21, C22 | ceramic | 100n | 1206 (smd) | Capacitor | 0 | 0.012 | DK: 490-1775-2-ND | do not solder
2 | R6, R7, R8 |  | 470 | 1206 (smd) | Resistor | 0 | 0.0135 | DK: P470FTR-ND | do not solder
3 | U7 | 78M05 | 500mA | (smd) | Regulator | 0 | 0.33 | [NAME]: MC78M05CDTXTR-ND | do not solder
4 | X2 | DIN96 A-C | A-C (pin) |  | A C connector | 1 |  | HT: AC-DINN-CONN-PIN
5 | T1, T2 | header for potmeter |  | pth |  | 0 |  |  | do not solder
6 | [NAME] | header for SSR |  | pth |  | 0 |  |  | do not solder
7 | JP9,JP10,JP12 | header for alarm |  | pth |  | 0 |  |  | [NAME] for alarmled, do not solder
8 | JP11 | jumper |  | pth |  | 0 |  |  | do not solder
9 | JP5,JP7,JP8 | header for sensor |  | pth |  | 3 |  | HT: CONN2
10 | JP3 | header for buzzer |  | pth |  | 0 |  |  | do not solder
11 | JP2,JP6 | header for 12V power |  | pth |  | 2 |  |  | solder wire in
12 | JP1,JP4 | header for RS485 |  | pth |  | 0 |  |  | do not solder
13 | TA0,TA1,TA2 | tempsensor asmbly | sensor DS18B20 | TO92 | 30cm audiocable+ connector+ sensor | 0 |  |  | connect to JP5,JP7, JP8
14 | ALED | alarmled asmbly | LED red frontpanel | frontpanel mount | 20cm wire+ connector+ led | 0 |  |  | connect to JP12, do not solder
15 | SSRW | ssr wire asmbly |  |  | 20cm wire+ connector | 0 |  |  | connect to JP13, do not solder
16 | POT0,POT1 | potmeter asmbly | 10K potmeter | frontpanel mount | 20cm wire+ connector+ potmeter | 0 |  |  | connect to T1,T2, do not solder
17 | POW0,POW1 | powersupply asmbly |  |  | 20cm wire | 0
18 | BUZZ | buzzer assembly | DC 3-20V buzzer | frontpanel mount | 20cm wire+ buzzer+ MUTE+ connector | 0 |  |  | connect to JP3, do not solder
19 | MUTE | buzzer mute | toggle button | frontpanel mount | " | 0 |  |  | add to buzzer assembly, do not solder
Spreadsheet: 737801d1624614011-sql-conversion-rown-into-colums-matching-same-first-value-sql-example
Sheet: Sheet1

What it looks like |  |  |  |  |  | How it should look
Name | Attr ID | Attr Name | Value |  |  | Name | Age | Height | BMI | Modified BY | Created By
[NAME] | 1 | Age | 25 |  |  | [NAME] | 25 | 5'10 | 27 | System
[NAME] | 2 | Height | 5'10" |  |  | [NAME] | 26 | 5'9" | 25 |  | User1
[NAME] | 3 | BMI | 27 |  |  | [NAME] | 29 | 6'2" |  | User2
[NAME] | 4 | Modified By | System
[NAME] | 1 | Age | 26
[NAME] | 2 | Height | 5'9"
[NAME] | 3 | BMI | 25
[NAME] | 5 | Created By | User1
[NAME] | 1 | Age | 29
[NAME] | 2 | Height | 6'2"
[NAME] | 4 | Modified By | User2
Spreadsheet: 0ddcb95c-b883-4a87-9126-7706cdc685f5
Sheet: Sheet1

 |  | Free Available Chlorine Curve Verification
Date: |  |  | [NAME]:
Analyst: | Person and/or contract lab |  | Meter Program #:
Lab Name: | Lab that owns the meter |  | NC WW/GW Certificiation #
Comments: | If Commercial Field lab, list facilities and/or permit numbers the meter will be used for.
Instructions:  Fill in the information above.  Enter the actual concentrations of the standards in your curve in cells A19 through A23.  Enter the values that you observe on the meter in cells B19 through B23.  The % Recovery and the Correlation Coefficient will be automatically calulated.
For the curve to pass…
The Correlation Coefficient must be ≥ 0.995
and…
Standard concentrations  must have a %  Recovery between 90 - 110 %.
List standards in order of concentration from lowest to highest.
Actual, mg/L | Observed, mg/L | % Recovery | Std Pass/Fail | slope | intercept
≤ discharge limit | Std 1
Std 2 | Std 2
Mid-point of Curve | Std 3
Std4 | [NAME]
Top of Curve | Std 5
 | Corr. Coefficient = |  | Corr. Coefficient
 | Gel/Sealed Liquid Standard Observed Concentration = |  |  |  | mg/L
Gel/Sealed Liquid Standard Manufacturer: |  |  |  | Lot #:
 |  | [NAME]:
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | 0 | 547 | 547
Cross-Currency Fixed-Fixed | 0 | 51 | 51
Cross-Currency Fixed-Float | 0 | 264 | 264
TOTAL | -
Spreadsheet: 856788d1705963533-i-need-help-with-wildcard-in-formula-wildcard
Sheet: Sheet1

Computer ID | Serial # | PC Type | Location | AGE | DFI # | EXT | Notes 1 | Notes 2 | Last Updated | Assigned |  |  | REMOTE COMPUTERS
MYPC010 | 123456789 | LAPTOP | CLOSET | ANCIENT | NONE | NONE | TEST | DO NOT RELEASE | N/A | NO |  |  | COMPUTER | USER ASSIGNED
MYPC011 | 123456789 | LAPTOP | MY HYBRID | OLD | 9 | NONE |  |  |  | NO
MYPC012 | 123456789 | LAPTOP | CLOSET | OLD | NONE | NONE | DAMAGED | DO NOT RELEASE | N/A | NO
MYPC013 | 123456789 | LAPTOP | IN CLOSET | OLD | 32 | NONE | IN USE | WRONG CHARGER - 039 | 2023-12-13 00:00:00 | NO
MYPC014 | 123456789 | LAPTOP | REMOTE | OLD | 28 | NONE | IN USE | HOLD |  | NO
MYPC015 | 123456789 | LAPTOP | SC REMOTE | OLD | 4 | NONE |  |  | 2023-12-09 00:00:00 | [NAME]
MYPC016 | 123456789 | LAPTOP | REMOTE IN | OLD | 27 | NONE | IN USE | HOLD | 2023-09-12 00:00:00 | NO
MYPC017 | 123456789 | LAPTOP | MY REMOTE | OLD | 29 | NONE | IN USE | HOLD |  | NO
MYPC018 | 123456789 | LAPTOP | REMOTE | MIDDLE | 2 | NONE |  |  |  | [NAME]
Spreadsheet: 883067d1731556754-return-specific-text-based-on-text-found-in-a-cell-searchpartialtext
Sheet: Sheet1

Text | Display |  | Lookup Value | Return Value
…house of Representatives … |  |  | House of Representatives | Federal
… house of Representatives… |  |  | Senator | State
Senator is … |  |  | Mayor | Local
The house of Representatives…
A mayor …
One of the senators
Spreadsheet: 865461d1712552539-formula-to-spill-days-and-dates-date-sample-aligw
Sheet: Sheet1

Enter Start Date | 2024-03-12 00:00:00
Week #1
Day | Date
[NAME]
Wed | 2024-03-13 00:00:00
Thur | 2024-03-14 00:00:00
Fri | 2024-03-15 00:00:00
Sat | 2024-03-16 00:00:00
Sun | 2024-03-17 00:00:00
Mon | 2024-03-18 00:00:00
Week#2
Day | Date
[NAME]
Wed | 2024-03-20 00:00:00
Thur | 2024-03-21 00:00:00
Fri | 2024-03-22 00:00:00
Sat | 2024-03-23 00:00:00
Sun | 2024-03-24 00:00:00
Mon | 2024-03-25 00:00:00
Spreadsheet: 85417997-1afe-444c-8c61-1b746a5f2b9f
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
FHEVG | Test | FHEVG | Hepatitis E Antibody (IgG) | Hepatitis E Antibody IgG | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 0.5 mL of  serum ambient.  Note: Serum gel tube is acceptable, but must pour off into plastic vial. | 0.1 mL | Specimens other than	Serum Anticoagulants other than	N/A Hemolysis	N/A Thawing	Warm OK;Cold OK Lipemia	N/A Icteric	N/A | Reference Range: Not Detected        Hepatitis E virus (HEV) is a major cause of enteric non-A hepatitis worldwide. HEV IgG is typically detected within one month after infection, and persists for months to years after recovery. Approximately 20% of the US population is positive for HEV IgG, indicating that HEV exposure is more common than previously thought.   Test Performed by: Focus Diagnostics, Inc                              5785 Corporate Avenue                              Cypress, CA 90630-4714 | Monday, Thursday | 1 - 5 days | 3 - 8 days | 1 | 86790 |  |  |  |  | Focus Diagnositics, Inc.
FHEVG | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FHEVG | Result | Z2429 | HEV IgG | HEV IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 728000d1618245004-when-using-isnumber-i-cant-change-the-cell-format-goal-and-trend-formulas-aligw
Sheet: Sheet1

Start Date | 2021-04-01 00:00:00 | Hours Goal | Sales | Gross
End Date | 2021-04-30 00:00:00 | 3000 | 265000 | 165000
Days in Month |  | Advisor Count | Advisor Count
Days Worked |  | 3 | 3
Remaining Days |  | Advisor Hours | Advisor Sales
 |  | 1000
Emp # | 7 | 8 | 16 | 24 | Grand Total
Sold Hours | 254 | 6.85 | 1263.570000000002 | 6.57 | 19253.44999999986
Trend
Goal
[NAME]
Emp # | 7 | 8 | 16 | 24 | Grand Total
Total Sales | 3167899.650000073 | 1270.6 | 337892.9400000022 | 1456.89 | 5436027.630000074
Trend
Goal
[NAME]
Spreadsheet: 831067d1685387409-formula-to-regroup-data-regrouped-data
Sheet: Sheet1

 |  | Raw Data |  |  |  |  |  |  |  |  | Regrouped data
S/N | Name | 2022-11-28 00:00:00 | 2022-12-05 00:00:00 | 2022-12-12 00:00:00 | 2022-12-19 00:00:00 | 2022-12-26 00:00:00 | 2023-01-02 00:00:00 |  | S/N | Name | 1 | 2 | 3 | 4 | 5 | 6
1 | [NAME] | 0 | 0 | 200000 | 0 | 0 | 50000 |  | 1 |  | 200000 | 50000
3 | Emmanuel | 0 | 0 | 0 | 0 | 0 | 0 |  | 2
4 | [NAME] | 130000 | 0 | 0 | 0 | 70000 | 0 |  | 3 |  | 130000 | 70000
5 | SylviA | 0 | 0 | 0 | 0 | 0 | 5000 |  | 4 |  | 5000
6 | [NAME] | 0 | 75000 | 0 | 0 | 0 | 0 |  | 5 |  | 75000
7 | Cyrille | 200000 | 75000 | 0 | 50000 | 80000 | 0 |  | 6 |  | 200000 | 75000 | 50000 | 80000
8 | [NAME] | 150000 | 0 | 0 | 0 | 0 | 0 |  | 7 |  | 150000
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Sharks

Sharks
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Gator Dawgs
2 | Mudcats
3 | Wet Farts
4 | Muckdogs
5 | [NAME]
6 | Deadbirds
7 | Pics Hitmen
8 | Thundermutts
9 | Capo Crimini
10 | Cajun Coonasses
11 | King of Queens
12 | Pics Hitmen
13 | Deadbirds
14 | King of Queens
15 | Cajun Coonasses
16 | [NAME]
17 | Muckdogs
18 | Capo Crimini
19 | Thundermutts
20 | Wet Farts
21 | Mudcats
22 | Gator Dawgs
Spreadsheet: 850200d1700577944-properly-compare-year-over-year-weeks-weektest
Sheet: Sheet2

 | 2023 |  |  |  |  |  |  |  |  | 2022
Week | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday |  | Week | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
1 |  | 2023-01-01 00:00:00 |  |  |  |  |  |  | 1 | 2022-01-01 00:00:00
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
42 |  |  |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  |  |  | 43
44 |  |  |  |  |  |  |  |  | 44
45 |  |  |  |  |  |  |  |  | 45
46 |  |  |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  |  |  | 47
48 |  |  |  |  |  |  |  |  | 48
49 |  |  |  |  |  |  |  |  | 49
50 |  |  |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  |  |  | 51
52 |  |  |  |  |  |  |  |  | 52
53 |  |  |  |  |  |  |  |  | 53
Spreadsheet: 688645d1595887050-help-with-sumifs-formula-across-multiple-sheets-sample-worksheet
Sheet: Summary

 | Clinician
Month | SEAN | ANGIE | STEPHANIE
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: 806128d1669120201-getting-the-date-of-each-mondays-between-two-dates-test-date
Sheet: Sheet1

 | Monday | 2022-10-03 00:00:00 |  |  |  |  |  | Starting Date | 2022-10-02 00:00:00
 | Monday | 2022-10-10 00:00:00 |  |  |  |  |  | Ending Date | 2023-01-12 00:00:00
 | Monday | 2022-10-17 00:00:00
 | Monday | 2022-10-24 00:00:00
 | Monday | 2022-10-31 00:00:00
 | Monday | 2022-11-07 00:00:00
 | Monday | 2022-11-14 00:00:00
 | Monday | 2022-11-21 00:00:00
 | Monday | 2022-11-28 00:00:00
 | Monday | 2022-12-05 00:00:00
 | Monday | 2022-12-12 00:00:00
 | Monday | 2022-12-19 00:00:00
 | Monday | 2022-12-26 00:00:00
 | Monday | 2023-01-02 00:00:00
 | Monday | 2023-01-09 00:00:00
Spreadsheet: 43240d1241804303-pivottables-and-percent-of-total-pivotexample
Sheet: Sample Data

Date | Color | Sum |  |  |  | Sum of Sum | Color
2009-01-01 00:00:00 | Red | 189 |  |  |  | Date | Blue | Green | Red | Grand Total
2009-01-01 00:00:00 | Blue | 833 |  |  |  | 2009-01-01 00:00:00 | 0.4202825428859738 | 0.4843592330978809 | 0.09535822401614531 | 1
2009-01-01 00:00:00 | Green | 960 |  |  |  | 2009-02-01 00:00:00 | 0.02953586497890295 | 0.4377637130801688 | 0.5327004219409283 | 1
2009-02-01 00:00:00 | Red | 505 |  |  |  | 2009-03-01 00:00:00 | 0.3711340206185567 | 0.4117983963344788 | 0.2170675830469645 | 1
2009-02-01 00:00:00 | Blue | 28 |  |  |  | Grand Total | 0.3227117194183062 | 0.4478186484174508 | 0.2294696321642429 | 1
2009-02-01 00:00:00 | Green | 415
2009-03-01 00:00:00 | Red | 379
2009-03-01 00:00:00 | Blue | 648
2009-03-01 00:00:00 | Green | 719
Spreadsheet: 0af3e029-6f66-4f19-a12c-d5e5fc1c7b2c
Sheet: M

Course color corresponds with term of offering. RED  for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term. Blue comments for summer school.
 | AOK Designation | CAR Designation | Comment
Mathematics
MATH 105 | Natural & Mathematical Sciences-Mathematics |  | Also taught in Summer School 2014.
MATH 107 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 111 | Natural & Mathematical Sciences-Math Sci other |  | Also taught in Summer School 2014.
MATH 113 | Natural & Mathematical Sciences-Math Sci other | Computing
MATH 120 | Natural & Mathematical Sciences-Mathematics |  | Also taught in Summer School 2014.
MATH 123 | Natural & Mathematical Sciences-Mathematics
MATH 131 | Natural & Mathematical Sciences-Mathematics
MATH 132 | Natural & Mathematical Sciences-Mathematics
MATH 141 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 142 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 170 | Natural & Mathematical Sciences-Mathematics | Travel; Non-Western
MATH 203 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 220 | Natural & Mathematical Sciences-Mathematics
MATH 270 |  | Experiential-Travel; Non-Western
MATH 415 |  | Capstone
MATH 470 |  | Experiential-Travel
MATH 487 |  | Experiential-Research
MATH 488 |  | Experiential-Research
Music
MUSC 101 | Arts & Literature-Arts
MUSC 110 | Arts & Literature-Arts
MUSC 111 | Arts & Literature-Arts
MUSC 200 | Arts & Literature-Arts
MUSC 210 | Arts & Literature-Arts
MUSC  211 | Arts & Literature-Arts
MUSC 212 | Arts & Literature-Arts
MUSC 215 | Arts & Literature-Arts
MUSC 221 | Arts & Literature-Arts
MUSC 222 | Arts & Literature-Arts
MUSC 230 | Arts & Literature-Arts
MUSC 231 | Arts & Literature-Arts
MUSC 232 | Arts & Literature-Arts
MUSC 240 | Arts & Literature-Arts | Non-Western
MUSC 243 | Arts & Literature-Arts | Experiential-Travel; Non-Western
MUSC 260 | Arts & Literature-Arts
MUSC 270 |  | Computing
MUSC 278 | Arts & Literature-Arts | Experiential-Travel; Experiential-Research
MUSC 301-309 | Arts & Literature-Arts (3 1-hour courses with same course number)
MUSC 310 | Arts & Literature-Arts (3 times at 1 hour)
MUSC 321 | Arts & Literature-Arts
MUSC 322 |  | Computing
MUSC 371 |  | Computing
MUSC 381 | Arts & Literature-Arts | Non-Western | Fall 2013(non-travel) and J-Term 2013(Music of Brazil)
MUSC 381 | Arts & Literature-Arts | Experiential-Travel | J-Term 2014(Choral Music of Greece, Turkey & Italy); J-Term 2010 (Music of the Reformation)
MUSC 420 | Arts & Literature-Arts | Experiential-Research
MUSC 422 | Arts & Literature-Arts | Experiential-Research; Capstone
MUSC 450 |  | Experiential-Internship
Spreadsheet: phillip_allen__29447__COLONIAL OAKS CASH ON CASH
Sheet: Sheet1

CASH ON CASH RETURN - COLONIAL OAKS
SALES PRICE |  |  | 2500000
20% DOWNPAYMENT |  |  | 500000
LOAN AMOUNT
MONTHLY PMT. @  7.5 |  |  | 14584.47 |  | Amortized for
ANNUAL PAYMENT |  |  | 179000 |  | 25 years
NOI |  |  | 240000
LESS ANNUAL PAYMENT
NOI AFTER DEBT SERVICE
NOI AFTER DEBT\DOWNPAYMENT = |  |  |  |  | CASH ON
 |  |  |  |  | CASH RETURN
Spreadsheet: 853660d1703597914-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans-1-
Sheet: Step2.1

Search 1 | microsoft | < input field
Search 2 |  | < input field
Search 3 |  | < input field |  | words like > |  | watch | 11 | 16 | wat
 |  |  |  | Search1 | Search2 | Search3 |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part | 2nd Sub | 2nd Sub IN | 2nd Part | HEader18
2023-09-13 00:00:00 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  |  | SALMON-50/TC-15 | <Missing
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75 |  | Shown
 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  | 792 | SALMON-50/TC-15 | <[NAME] by [NAME]
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75
Spreadsheet: 378009d1424246409-how-to-filter-out-the-last-ten-values-and-find-how-many-times-it-exceeds-x-sample_3
Sheet: PIVOT

date | (All)
counter | (Multiple Items)
Count of value | sample
[NAME] | A | B | C | Grand Total
between 0 and 5 | 2 |  |  | 2
between 5 and 10 | 1 | 2 | 1 | 4
between 10 and 20 | 7 | 8 | 2 | 17
over 20 |  |  | 1 | 1
Grand Total | 10 | 10 | 4 | 24
Spreadsheet: andy_zipper__195__Global_Prod 5-23-01 EM
Sheet: New on 5-22-01 - 24 Hr

New Global Products made available on
that were not available on
Global Product Short Desc.
Credit Dflt Swap AT & T                  5 Years         bpa/USDm
Credit Dflt Swap BMW AG                  5 Years         bpa/USDm
Credit Dflt Swap DaimlerChrysler         5 Years         bpa/USDm
Credit Dflt Swap Fiat SpA                5 Years         bpa/USDm
Credit Dflt Swap Ford Credit             3 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           3 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           5 Years         bpa/USDm
Credit Dflt Swap Vattenfall              5 Years         bpa/USDm
Credit Dflt Swap Volkswagen              3 Years         bpa/USDm
Credit Dflt Swap Volkswagen              5 Years         bpa/USDm
Credit Dflt Swap Volvo                   5 Years         bpa/USDm
EUR Plastic Swap LDPE F ICIS Ger         Jul01-Jun02     DEM/kg
EUR Plastic Swap LDPE F ICIS Ger         Jul-Dec01       DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Jul01-Jun02     DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Jul-Dec01       DEM/kg
For Curr Exch    Forward                 25May01         JPY/USD
For Curr Exch    Forward                 25May01         USD/EUR
For Curr Exch    Forward                 25May01         USD/GBP
For Curr LME     LME (Spot)              25May01         JPY/USD
For Curr LME     LME (Spot)              25May01         USD/EUR
For Curr LME     LME (Spot)              25May01         USD/GBP
Foreign Currency Reuters BOFC            23May01         CAD/USD
Gasoil CIF Med   Platts Hi               Jun01           USD/mt
SG Dub Time Spd  Platts                  Q3 01 v Q4 01   USD/bl/m
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG HSFO Swap     Platts AP 180           Jun01           USD/mt
US Crude Fin Opt NYMEX WTI    EC30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC30.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC32.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC32.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC33.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP27.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP28.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP28.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP29.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP29.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.5     Jul01           USD/bl/m
US Jet Kero Swap GC vs NYMEX HO          CAL 2002        c/Gl-b
US METH FOB Phy  Houston                 Jul01           USD/Gl-b
US METH FOB Phy  Houston                 Jun01           USD/Gl-b
Spreadsheet: 887648d1737913997-sum-values-based-on-values-in-another-column-sample-sheet
Sheet: Sheet1

Value | Column1 | Category |  |  |  | Category | Total |  |  | Value
15266.35 |  | A |  |  |  | A | 169981.17 |  | A | 169981.17
154714.82 |  | A | = [NAME] |  |  | B | 153309.18 |  | B | 153309.18
78093.31 |  | B |  |  |  | C | 835.11 |  | C | 835.11
75215.87 |  | B | =A4 + A5 |  |  | D | 42226.23 |  | D | 42226.23
835.11 |  | C | = A6 |  |  | E | 104602 |  | E | 104602
904.57 |  | D |  |  |  | F | 9185 |  | F | 9185
7300 |  | D |  |  |  | G | 37277.99 |  | G | 37277.99
34021.66 |  | D | = sum(A7:A9) |  |  |  |  |  | Total | 517416.6799999999
104602 |  | E | = A10
5177.22 |  | F
4007.78 |  | F | = A11 + A12
18640.76 |  | G
18637.23 |  | G | = A13 +A14
Spreadsheet: 881755d1729905650-power-query-internal-lookup-date2
Sheet: Sheet1

 |  |  | Starting Point |  | Trans Date | Trans Type | Ref
 |  |  |  |  | 2023-01-01 00:00:00 | Invoice | 123
 |  |  |  |  | 2023-01-02 00:00:00 | Invoice | 456
 |  |  |  |  | 2023-01-03 00:00:00 | Credit Note | 163
 |  |  | Required Outcome |  | Trans Date | Trans Type | Ref | Dte 2
 |  |  |  |  | 2023-01-01 00:00:00 | Invoice | 123
 |  |  |  |  | 2023-01-02 00:00:00 | Invoice | 456
 |  |  |  |  | 2023-01-03 00:00:00 | Credit Note | 123
Spreadsheet: 883566d1732188255-trying-to-count-dates-before-today-from-a-filtered-column-glengle-book1-391-365-aligw
Sheet: Sheet2

Backlog
 |  |  |  |  |  |  | B1 - Trying to count any dates sheet 1 before today, that have not been filtered out, this should currently be '0' but I cannot get this formula to work at all
 |  |  |  |  |  |  | B2 - trying to count dates on sheet 1 matching A2 that haven't been filtered out, but the formula I'm using is just counting everything that remains after the filer is applied
Spreadsheet: sally_beck__33987__MgmtSum-Q201-Global-0412
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-12-01 00:00:00 | 2nd QUARTER 2001 DIRECT EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Crude & Products |  |  | 6994.312
COAL | Coal |  |  | 4077.215
 | Vessel Trading |  |  | 0
SO2 | Emissions
WEATHER | Weather
INSURANCE | Global Risk Markets |  |  | 2304.121
ECT_INV_IRFX | Financial Trading |  |  | 3742.614
 | Freight Markets |  |  | 578.553
 | LNG |  |  | 1430.25
 | Puerto Rico
 | Finance and Structuring |  |  | 695.866
 | Office of the Chairman |  |  | 537.2
 | Subtotal Commercial
 | Group
 | Other Interest Related Charges |  | 0 | 0
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0