tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 | 7 | UMT Industrial | Automatic door switch |  | 13/10 |  |  | 8437 |  |  |  |  |  | 8437 |  | 0 |  |  | 3796.65 |  | 0 |  |  | 8437
 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 8437 |  |  |  |  |  | 8437 |  |  |  |  | 3796.65 |  |  | Total spent = |  | 8437
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 3398400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 3389963
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 0.9975173611111111
Spreadsheet: 692320d1598277879-if-statement-using-date-and-pulling-values-sample
Sheet: Sheet1

Invoice #11255
Name: Vender Invoice |  | Invoice Date: 4/8/2020 |  |  |  | `
Description: For Services Rendered through Nov 31, 2019
Total Invoice Amount: | 5000
Allocations
Legal Expense Allocation |  | This date we manual enter |  |  |  | This amount I want to populate based on the date I enter is C12-14
First |  | as of 11/1/2019 |  | First |  | 418000000
Second |  | as of 11/1/2019 |  | Second |  | 33166038.3458
Third |  | as of 11/1/2019 |  | Third |  | 298200133.7703
Total Amount:
First
Second
Third
The information here is in a separate workbook:
Month Start | First | Second | Third
2019-08-01 00:00:00 | 417200000 | 70311826.0007 | 295070862.0743
2019-09-01 00:00:00 | 429400000 | 30436638 | 296401058.45
2019-10-01 00:00:00 | 425100000 | 36519382.6642 | 297170046.9302
2019-11-01 00:00:00 | 418000000 | 33166038.3458 | 298200133.7703
As a last step the information from the 1st part get logged in a sheet like this.  So some how linking this one too would be great.  This is also a separate workbook.
Status | Fund Exp/ Mgmt Company | Date Invoice Received | Invoice Due date | Date Invoice Paid | Payment By | Tax Year | Invoice # | Company | Notes | Allocation Details | Total Invoice amount | first | Second | Third
Paid |  |  | 2020-04-08 00:00:00 |  |  | 2019 | 11255 | Vender invoice |  |  | 5000 | 2789.02 | 221.3 | 1989.68
Spreadsheet: 836720d1689605629-find-true-find-true
Sheet: Blad1

# | [NAME]
 | Look for value A2 in 'column A' on 'sheet2' and return value 'True' if value A2 is found in 'column A' on 'sheet2'.
6.01
6.02
6.03
6.04 | True
6.05
6.06
6.07
6.08
6.09
6.10
6.11
6.12
6.13
6.14
6.15
6.16
6.17
6.18
6.19
6.20
6.21
6.22 | True
6.23
6.24
6.25
6.26
6.27
6.28
6.29
6.30
6.31
6.32
6.33
6.34
6.35
6.36
6.37
6.38
6.39
6.40
6.41 | True
6.42
6.43
6.44
6.45 | True
6.46 | True
6.47 | True
6.48
6.49
6.50
6.51
6.52
6.53
6.54
6.55
6.56
6.57
6.58
6.59
6.60
6.61
6.62
6.63
6.64 | True
6.65 | True
6.66 | True
6.67 | True
6.68 | True
6.69 | True
6.70
6.71
6.72
6.73
6.74
6.75
6.76
6.77
6.78
6.79
6.80
6.81
6.82
8.83
8.84
8.85
7.01
7.02
7.03
7.04
7.05
7.06
7.07
7.08
7.10
8.01
8.02
8.03
8.04
8.05
8.06
8.07
9.01
9.02
9.03
9.04
9.05
Spreadsheet: 852452d1702484613-account-for-n-a-when-summing-book1
Sheet: Sheet3

Lv | Mat 1 | Mat 2
-6 | Paper
-6 |  | Rock
-6 | Paper
-6 | Paper | Paper
-5 | Paper
 | Paper | Rock
Lv | Nr | Nr
-10
-9
-8
-7
-6
-5
-4
-3
-2
-1
∑
∑ Check
Spreadsheet: 733492d1621600449-automatically-add-newly-created-column-headers-to-new-row-in-another-table-best-practice-for-total-points
Sheet: Example Gradebook 101

 |  |  |  |  |  |  | CURRENTLY using /N in the header row to keep track of assignment total points. The numbers can't be used in formulas, but things stay together as they should when I move columns. What's the best way to automatically duplicate what's typed in an Assignment header (such as future assignment D, E, etc) into the sheet "Assignments Master"? I have maaaany more classes and assignments than this example has, so the more automatic, the better
Class | Seat Number | Name | Overall Grade | Assignment A /3 | Assignment B /2 | Assignment C /1
101 | 1 | [NAME]
101 | 2 | [NAME]
101 | 3 | [NAME]
101 | 4 | [NAME]
101 | 5 | [NAME]
101 | 6 | [NAME]
101 | 7 | Greg
101 | 8 | Horace
101 | 9 | Iguana
101 | 10 | [NAME]
Total
Spreadsheet: 864481d1711635811-how-to-assign-values-diet_plan
Sheet: Tabelle1

 |  |  |  |  |  |  | Diet Plan
List |  |  |  | Monday | Product | Quantity | Calories | Total Cal.
Product | Quant.[NAME] | Kcal |  | Breakfast | [NAME] | 200 g
[NAME] | 100 g | 180 |  |  | Bread | 4 pcs.
Bread | 1 pcs. | 120
[NAME] | 100 g | 170
Spreadsheet: 161447d1339522380-copy-multiple-columns-of-data-from-duplicates-in-1st-column-into-separate-sheets-0i-and-m1
Sheet: A

A | ChildPartNumber | ParentPartNumber
A | PART1 | FPART201
A | PART2 | FPART203
A | [NAME] | FPART201
A | PART20 | FPART307
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
Spreadsheet: 177456d1346317111-drop-down-list-hyperlink-to-sheets-in-another-workbook-stock-plan-store
Sheet: Sheet5

 |  | Description
 | 5 | Code:
 |  | Brand: |  | Supplier
 |  | Stock Movement (Control)
 | Rack |  | IN | OUT | Balance
 | No. | Date | (PCS) | (PCS)
 |  | Last Balance |  |  | 0
 | 1 |  |  |  | 0
 | 2 |  |  |  | 0
 | 3 |  |  |  | 0
 | 4 |  |  |  | 0
 | 5 |  |  |  | 0
 | 6 |  |  |  | 0
 | 7 |  |  |  | 0
 | 8 |  |  |  | 0
 | 9 |  |  |  | 0
 | 10 |  |  |  | 0
 | 11 |  |  |  | 0
 | 12 |  |  |  | 0
 | 13 |  |  |  | 0
 | 14 |  |  |  | 0
 | 15 |  |  |  | 0
 | 16 |  |  |  | 0
 | 17 |  |  |  | 0
 | 18 |  |  |  | 0
 | 19 |  |  |  | 0
 | 20 |  |  |  | 0
 | 21 |  |  |  | 0
 | 22 |  |  |  | 0
 | 23 |  |  |  | 0
 | 24 |  |  |  | 0
 | 25 |  |  |  | 0
 | 26 |  |  |  | 0
 | 27 |  |  |  | 0
 | 28 |  |  |  | 0
 | 29 |  |  |  | 0
 | 30 |  |  |  | 0
 | 31 |  |  |  | 0
 | 32 |  |  |  | 0
 | 33 |  |  |  | 0
 | 34 |  |  |  | 0
 | 35 |  |  |  | 0
 | 36 |  |  |  | 0
 | 37 |  |  |  | 0
 | 38 |  |  |  | 0
 | 39 |  |  |  | 0
 | 40 |  |  |  | 0
 | 41 |  |  |  | 0
 | 42 |  |  |  | 0
 | 43 |  |  |  | 0
 | 44 |  |  |  | 0
 | 45 |  |  |  | 0
 | 46 |  |  |  | 0
 | 47 |  |  |  | 0
 | 48 |  |  |  | 0
 | 49 |  |  |  | 0
 | 50 |  |  |  | 0
 | 51 |  |  |  | 0
 | 52 |  |  |  | 0
 | 53 |  |  |  | 0
 | 54 |  |  |  | 0
 | 55 |  |  |  | 0
 | 56 |  |  |  | 0
 | 57 |  |  |  | 0
 | 58 |  |  |  | 0
 | 59 |  |  |  | 0
 | 60 |  |  |  | 0
 | 61 | 0
 |  | #[NAME]! | 0 | 0 | 0
Spreadsheet: john_griffith__15741__10_16_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 63 | 340 | 440 | 40.9 | 52.9 | 1.86 | 2001-10-16 10:22:00
 | HO Z1 | 64 | 800 | 900 | 46.4 | 52.2 | 1.98 | 2001-10-16 10:22:00
 | HO F2 | 65 | 1050 | 1150 | 46.3 | 50.7 | 1.98 | 2001-10-16 10:22:00
 | HO G2 | 64 | 1180 | 1280 | 43.9 | 47.6 | 1.84 | 2001-10-16 10:22:00
 | [NAME] | 63 | 1200 | 1325 | 40.4 | 44.6 | 1.68 | 2001-10-16 10:22:00
 | HO J2 | 62 | 1200 | 1325 | 37.4 | 41.3 | 1.53 | 2001-10-16 10:22:00
 | HO K2 | 61 | 1200 | 1325 | 34.9 | 38.6 | 1.41 | 2001-10-16 10:22:00
 | HO M2 | 60 | 1175 | 1325 | 32.2 | 36.4 | 1.29 | 2001-10-16 10:22:00
 | HO N2 | 60 | 1175 | 1325 | 30.5 | 34.4 | 1.22 | 2001-10-16 10:22:00
 | HO Q2 |  |  |  | 29.1 | 31.4 | 1.2 | 2001-10-12 14:53:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: d866a217-4dd3-4007-8de9-664810ff01a9
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688857028 | Group 1 Crew Ft. [NAME] August | He Said | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Spreadsheet: 456696d1460999437-formula-adding-data-brief-new
Sheet: DATA BRIEF

Document Date: |  |  |  |  |  |  |  |  |  | Fox contact: |  |  | FOX DROP DOWN MENU HERE |  |  |  |  |  |  |  |  |  | Previous Job No:
Job No: |  |  |  |  |  |  |  |  |  | Client: |  |  | CLIENT DROP DOWN MENU HERE
Job Title:
[NAME] (guide only): |  |  |  |  |  |  | JOB FORMAT DROP DOWN MENU HERE
Perso Method: |  |  |  |  | PERSO METHOD DROP DOWN MENU HERE |  |  |  |  |  |  |  |  |  |  |  | Number Up: |  |  |  | NUMBER UP DROP DOWN MENU HERE |  |  |  | Gutter:
RAW DATA FILES SUPPLIED
File ID |  | File Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
MERGE / SPLIT DETAILS
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity
A |  | 001 + |  | 009 + |  | 003 +
B
C
D
E
F
G
H
I
[NAME]
[NAME] |  | SORTATION LEVEL |  |  |  |  |  |  |  |  |  | Pack Size |  |  | UK Postage |  |  | No. AB's |  | Pack Weight |  |  | Mail Date |  |  |  |  | Quantity
A |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Large Letter (>10, <25mm) |  |  | O' Post / Whistl
B |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
C |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
D |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
E |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
F |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
G |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
H |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
I |  | MXO - BUSINESS MAIL LO SORT ECONOMY BARCODE |  |  |  |  |  |  |  |  |  | Lge Let (<10mm thick) |  |  | O' Post / Whistl
Spreadsheet: 778265d1650964851-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-time-between-hours-1-1-
Sheet: SLA

Start datetime | End datetime | HH:[NAME]:ss |  | << TOTAL SECONDS
2022-04-02 05:00:00 | 2022-04-30 05:00:00
2022-04-05 21:00:00 | 2022-05-01 05:00:00
2022-04-25 05:00:00 | 2022-05-02 05:00:00
2022-04-20 05:00:00 | 2022-05-03 10:00:00 |  |  |  | I have multi period
2022-03-06 05:00:00 | 2022-04-04 05:00:00
Spreadsheet: 103015d1300874541-fetch-unique-values-from-a-single-column-sample-testdata
Sheet: Testdata

 |  |  | EIN | 752485698
EIN | Amount |  | Amount | Total
530196605 | 10 |  | Total | 2220
530196605 | 10
530196605 | 10
530196605 | 10
42103580 | 109
272499903 | 9
911189249 | 10
911189249 | 50
368521454 | 10
42103580 | 50
852741369 | 10000
852741369 | 10
852741369 | 101
852741369 | 13
123456803 | 20
272499903 | 9
368521454 | 10
368521454 | 10
368521454 | 10
368521454 | 10
368521454 | 10
941156365 | 78
941156365 | 10
272499903 | 9
368521454 | 10
368521454 | 10
942443282 | 10
963258740 | 10
963258740 | 10
963258740 | 10
272499903 | 9
963258740 | 11
963258740 | 10
272499903 | 9
942443282 | 99.5
963258740 | 50.5
963258740 | 10
272499903 | 9
852456123 | 99
272499903 | 9
963258740 | 11
963258740 | 10
272499903 | 9
963258740 | 10.5
963258740 | 10
963258740 | 10
272499903 | 9
963258740 | 99.8
852741369 | 10
963852745 | 10
852741369 | 10
752485698 | 120
752485698 | 2100
Spreadsheet: 672847d1587043735-summing-a-block-of-sequential-values-book1-1-
Sheet: Sheet1

FY | FY Totals
2015 | 2100
2016 | 4000
2017 | 4650
2018 | 5900
2019 | 5850
2020 | 5550
2021 | 6000
2022 | 6000
2023 | 6000
2024 | 7500
2025 | 12000
2026 | 12000
2027 | 12000
2028 | 12000
2029 | 12000
2030 | 12000
2031 | 12000
2032 | 12000
2033 | 12000
2034 | 12000
2035 | 12000
2036 | 12000
2037 | 12000
2038 | 12000
2039 | 12000
2040 | 12000
2041 | 12000
2042 | 12000
2043 | 12000
2044 | 12000
2045 | 12000
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -24245 | -16077
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1066163 | -1093157
58710 | -17913 | -588
60921 | 792735 | 741764
78026 | 8690 | 19248
500084 | -2442 | -10000
500085 | -1
500097 | -512
INDEX
2001-06-30 00:00:00 |  |  | 692868.31
2001-07-10 00:00:00
Spreadsheet: 273489d1382725151-change-date-into-text-if-today-and-adding-text-if-cell-isblank-into-an-array-help-x-
Sheet: Staff Summary - AQ

 | This is how I wish the new data comes out. |  |  | This is the original formula that worked
EMPLOYEE | [NAME] | [NAME] |  | [NAME] | [NAME]
WHMIS | No Exp | No Exp NC
Transportation of Dangerous Goods (TDG)
Light Vehicle Maintenance & Repair **NEW**
Defensive Driving |  | 2015-08-28 00:00:00
Trailering | EXPIRED
Remedial Driving
ARGO - CSC - Level 1
ARGO - Manufacture |  | EXPIRED
Maintenance - ARGO
ATV | EXPIRED NC | 2014-04-26 00:00:00
UTV |  | 2015-08-28 00:00:00
Spreadsheet: 764625d1642830974-how-to-exclude-blank-cell-from-drop-down-list-non-blank-drop-down
Sheet: Sheet1

Inst. Short Name | Dept Short Name
MPI | ET |  |  | MIMT | MIST | MPI | MPPI | NMPI | VIMT |  | MPI | CT
MPI | CT
MPI | MT |  |  |  | EmT | CT
MPI | PT |  |  |  |  | ENT
MPI | CmT |  |  |  |  | ET
MPI | ENT |  |  |  |  | MT
MIST | EmT |  |  |  |  | PT
MIST | CT
MIMT | MT |  |  |  | =INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0))
BPI | PT |  |  |  | =FILTER(INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0)),INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0))<>"")
VIMT | CmT
MPPI | EnT
NMPI | EmT
Spreadsheet: 105562d1302876214-excel-2007-newbie-formatting-help-requested-book1_duckhunter
Sheet: Sheet1

2010-01-01 00:00:00 | 1.123 |  | 1123000
2010-01-02 00:00:00 | 2.123 |  | 2123000
2010-01-03 00:00:00 | 3.123 |  | 3123000
2010-01-04 00:00:00 | 4.123 |  | 4123000
2010-01-05 00:00:00 | 5.123 |  | 5123000
2010-01-06 00:00:00 | 6.123 |  | 6123000
2010-01-07 00:00:00 | 7.123 |  | 7123000
2010-01-08 00:00:00 | 8.123 |  | 8122999.999999999
2010-01-09 00:00:00 | 9.123 |  | 9123000
2010-01-10 00:00:00 | 10.123 |  | 10123000
2010-01-11 00:00:00 | 11.123 |  | 11123000
2010-01-12 00:00:00 | 12.123 |  | 12123000
2010-01-13 00:00:00 | 13.123 |  | 13123000
2010-01-14 00:00:00 | 14.123 |  | 14123000
2010-01-15 00:00:00 | 15.123 |  | 15123000
2010-01-16 00:00:00 | 16.123 |  | 16123000
2010-01-17 00:00:00 | 17.123 |  | 17123000
2010-01-18 00:00:00 | 18.123 |  | 18123000
2010-01-19 00:00:00 | 19.123 |  | 19123000
2010-01-20 00:00:00 | 20.123 |  | 20123000
2010-01-21 00:00:00 | 21.123 |  | 21123000
2010-01-22 00:00:00 | 22.123 |  | 22123000
2010-01-23 00:00:00 | 23.123 |  | 23123000
2010-01-24 00:00:00 | 24.123 |  | 24123000
2010-01-25 00:00:00 | 25.123 |  | 25123000
2010-01-26 00:00:00 | 26.123 |  | 26123000
2010-01-27 00:00:00 | 27.123 |  | 27123000
2010-01-28 00:00:00 | 28.123 |  | 28123000
2010-01-29 00:00:00 | 29.123 |  | 29123000
2010-01-30 00:00:00 | 30.123 |  | 30123000
2010-01-31 00:00:00 | 31.123 |  | 31123000
2010-02-01 00:00:00 | 32.123 |  | 32123000
2010-02-02 00:00:00 | 33.123 |  | 33123000
2010-02-03 00:00:00 | 34.123 |  | 34123000
2010-02-04 00:00:00 | 35.123 |  | 35123000
2010-02-05 00:00:00 | 36.123 |  | 36123000
Spreadsheet: john_griffith__15854__Daily Settles
Sheet: Sheet1

Today's Settles
$5 Swaption on CY 02 |  | 0
Cal 02 |  | 3.255
$6 Calls on Q1 02 |  | .045 @ .065 | 10 delta
$5.25 Calls on Cal 02 |  | .11 @ .13 | 18 delta
Jan 02 3.50 Calls |  | .315 @ .335 | 47 delta
Dec 01 $2.25 Puts (Gas Daily) |  | .05 @ .07 | -15 delta
Dec 01 $3.50 Calls (Gas Daily) |  | .22 @ .24 | 40 delta
Spreadsheet: 140025d1328597319-how-can-i-count-multiple-conditions-where-the-data-is-not-in-order-count-multiple-criterias
Sheet: Sheet1

A | 1 | 2 | 1
B | 2 | 2 | 1
A | 3 | 2 | 1
C | 3 | 1 | 3
B | 2 | 3 | 2
A | 1 | 2 | 3
How can I count number of times that A answered 1?
I am trying to avoid using SORT.
Spreadsheet: kate_symes__18156__EESSales_dailyfeb
Sheet: 2-17

NP15 | 2001-02-17 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 334.44 | Fixed Off Peak | 309.7 |  |  |  | Fixed Peak | 332.5 |  | Fixed Off Peak | 276 |  |  | Fixed Peak | 332.5 | Fixed Off Peak | 276
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -8.9 | -8.9 |  |  | 1 | -210.05 | 0 | -54 | -194.05 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | 0 | 0 | -8.02 | -8.02 |  |  | 2 | -210.96 | 0 | -54 | -181.96 |  |  | 2 | -1.94 | 0 | 0 | -1.94
3 | 0 | 0 | -7.42 | -7.42 | 0 |  | 3 | -211.14 | 0 | -44 | -177.14 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | 0 | 0 | -7.24 | -7.24 |  |  | 4 | -211.51 | 0 | -44 | -176.51 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | 0 | 0 | -7.43 | -7.43 |  |  | 5 | -211.02 | 0 | -44 | -181.02 |  |  | 5 | -1.92 | 0 | 0 | -1.92
6 | 0 | 0 | -8.08 | -8.08 |  |  | 6 | -210.23 | 0 | -54 | -198.23 |  |  | 6 | -1.94 | 0 | 0 | -1.94
7 | 0 | 0 | -9.54 | -9.54 |  |  | 7 | -177.3 | 0 | -54 | -167.3 |  |  | 7 | -2 | 0 | 0 | -2
8 | 0 | 0 | -11.54 | -11.54 |  |  | 8 | -174.62 | 0 | -54 | -178.62 |  |  | 8 | -2.09 | 0 | 0 | -2.09
9 | 0 | 0 | -13.5 | -13.5 |  |  | 9 | -172.85 | 0 | -54 | -195.85 |  |  | 9 | -2.17 | 0 | 0 | -2.17
10 | 0 | 0 | -14.11 | -14.11 |  |  | 10 | -171.89 | 0 | -54 | -210.89 |  |  | 10 | -2.2 | 0 | 0 | -2.2
11 | 0 | 0 | -14.35 | -14.35 |  |  | 11 | -171.86 | 0 | -54 | -218.86 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | 0 | 0 | -14.07 | -14.07 |  |  | 12 | -172.19 | 0 | -54 | -222.19 |  |  | 12 | -2.2 | 0 | 0 | -2.2
13 | 0 | 0 | -13.91 | -13.91 |  |  | 13 | -172.24 | 0 | -54 | -222.24 |  |  | 13 | -2.18 | 0 | 0 | -2.18
14 | 0 | 0 | -13.31 | -13.31 |  |  | 14 | -172.9 | 0 | -54 | -221.9 |  |  | 14 | -2.16 | 0 | 0 | -2.16
15 | 0 | 0 | -12.68 | -12.68 |  |  | 15 | -174.12 | 0 | -54 | -219.12 |  |  | 15 | -2.13 | 0 | 0 | -2.13
16 | 0 | 0 | -12.69 | -12.69 |  |  | 16 | -173.41 | 0 | -54 | -217.41 |  |  | 16 | -2.14 | 0 | 0 | -2.14
17 | 0 | 0 | -12.96 | -12.96 |  |  | 17 | -173.59 | 0 | -54 | -213.59 |  |  | 17 | -2.15 | 0 | 0 | -2.15
18 | 0 | 0 | -14.56 | -14.56 |  |  | 18 | -171.34 | 0 | -54 | -217.34 |  |  | 18 | -2.22 | 0 | 0 | -2.22
19 | 0 | 0 | -16.8 | -16.8 |  |  | 19 | -169.4 | 0 | -54 | -218.4 |  |  | 19 | -2.31 | 0 | 0 | -2.31
20 | 0 | 0 | -16.19 | -16.19 |  |  | 20 | -170.31 | 0 | -54 | -210.31 |  |  | 20 | -2.29 | 0 | 0 | -2.29
21 | 0 | 0 | -15.19 | -15.19 |  |  | 21 | -170.62 | 0 | -54 | -201.62 |  |  | 21 | -2.25 | 0 | 0 | -2.25
22 | 0 | 0 | -13.99 | -13.99 |  |  | 22 | -172.12 | 0 | -54 | -189.12 |  |  | 22 | -2.19 | 0 | 0 | -2.19
23 | 0 | 0 | -12.28 | -12.28 |  |  | 23 | -206.36 | 0 | -54 | -221.36 |  |  | 23 | -2.11 | 0 | 0 | -2.11
24 | 0 | 0 | -10.5 | -10.5 |  |  | 24 | -207.63 | 0 | -54 | -207.63 |  |  | 24 | -2.04 | 0 | 0 | -2.04
Spreadsheet: 811138d1672303977-if-name-change-then-change-the-number-sample-15-2-
Sheet: Sheet1

 | NAME | SERIES
 | ABDUL
 | AFAAQ
 | DEVID
 | SMITH
 | SMITH
 | SMITH
 | CHAND
 | CHAND
 | YUSUF
 | YUSUF
 | YUSUF
 | YUSUF
 | BARNER
 | BARNER
 | EXTRA
 | EXTRA
 | EXTRA
 | EXTRA
 | EXTRA
 | FAIZ
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Credit

 | Credit
 | 2002 Plan
 |  |  |  |  |  |  |  | Credit
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation | 0 |  | 2625993
 | Special Pays | 0 |  |  |  | 0 |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes | 0
ENAEMPEX | Employee Expense | 115211.17 |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense | 158715.86
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total
ENASUPP | Supplies Expense | 28163.05
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent | 1844.33 |  |  |  |  |  | Admins | 49200 | 1
 |  |  |  |  |  |  |  | Exec. [NAME]. | 63600 | 0
ENATECH | Technology | 29491.73 |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 1
ENAOTHEX | Other Expenses | 2056.67 |  |  |  |  |  | Specialist | 66000 | 1
ENATAXES | Taxes Other than Income | 0 |  |  |  |  |  | Sr Specialist | 84000 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Managers | 105600 | 5
 |  |  |  |  |  |  |  | Directors | 156000 | 2
 | Headcount |  |  | 58 |  |  |  | Sr Director | 184800 | 2 |  |  |  | 1
 |  |  |  |  |  |  |  | Vice President | 210000 | 1
 | A&A Headcount |  |  | 0 |  |  |  | EVP/CRO | 476400 | 0 |  |  |  | 1
 | Total Headcount
 |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent |  |  |  |  |  | Other Expense Calculation
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 149613d1334055682-find-first-left-condition-and-return-another-value-in-the-same-row-example
Sheet: Sheet1

 | 2012-02-09 00:00:00 | N/A | 2012-02-15 00:00:00 | 2012-03-08 00:00:00 | N/A | 2012-03-26 00:00:00 | N/A | 2012-03-26 00:00:00 | N/A | E: 28-Apr-12 | E: 04-May-12 |  | 2012-02-09 00:00:00 | N/A | 2012-02-15 00:00:00 | 2012-03-08 00:00:00 | N/A | 2012-03-26 00:00:00 | N/A | 2012-03-26 00:00:00 | N/A | 2012-04-28 00:00:00 | 2012-05-04 00:00:00