tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: Petrol NEW

 | Posting Acct | 4-003
 | Date | Acct | Description | Debit | Credit | Net
 | 2008-12-17 00:00:00 | 1-002 | Cash on hand | 30 | 0 | 30
 | 2008-12-24 00:00:00 | 1-001 | National Bank - Cheque | 20 | 0 | 20
 | Total |  |  | 50 | 0 | 50
Spreadsheet: 720009d1613976399-how-to-use-vlookup-true-to-extract-values-test-4-
Sheet: Test

Scenario 1: Comparing the number after the 2nd "_" between Column A and G -> find the nearest number that is larger than Column A -> Return the matching value in Column H.
ID | Expected Result | Wrong Result |  |  |  | Target ID | Value
55B_1_3000 |  |  |  |  |  | 55B_1_0 | A
232_3_4000 |  |  |  |  |  | 55B_1_2000 | B
208_1_3500 | M |  |  |  |  | 55B_1_3200 | C
3064_1_2600 | V |  |  |  |  | 55B_1_4000 | D
 |  |  |  |  |  | 55B_1_5100 | E
 |  |  |  |  |  | 232_2_0 | F
 |  |  |  |  |  | 232_3_2000 | G
 |  |  |  |  |  | 232_3_4200 | H
 |  |  |  |  |  | 208_1_0 | I
 |  |  |  |  |  | 208_1_15243 | J
 |  |  |  |  |  | 208_1_23133 | K
 |  |  |  |  |  | 208_1_30370 | L
 |  |  |  |  |  | 208_1_3532 | M
 |  |  |  |  |  | 208_1_3533 | N
 |  |  |  |  |  | 208_1_5230 | O
 |  |  |  |  |  | 208_1_5230 | P
 |  |  |  |  |  | 208_1_5420 | Q
 |  |  |  |  |  | 208_1_5420 | R
 |  |  |  |  |  | 208_1_6393 | S
 |  |  |  |  |  | 3064_1_0 | T
 |  |  |  |  |  | 3064_1_2370 | U
 |  |  |  |  |  | 3064_1_2630 | V
 |  |  |  |  |  | 3064_1_2630 | W
 |  |  |  |  |  | 3064_1_2680 | X
 |  |  |  |  |  | 3064_1_2687 | Y
 |  |  |  |  |  | 3064_1_2687 | Z
 |  |  |  |  |  | 3064_1_3730 | AB
 |  |  |  |  |  | 3064_1_420 | AC
 |  |  |  |  |  | 3064_1_420 | AD
Scenario 2: Comparing the number after the 2nd "_" between Column A and G -> find the nearest number that is smaller than Column A -> Return the matching value in Column H.
ID | Expected Result |  |  |  |  | Target ID | Value
55B_1_3000 | B |  |  |  |  | 55B_1_0 | A
232_3_4000 | G |  |  |  |  | 55B_1_2000 | B
208_1_3500 | P |  |  |  |  | 55B_1_3200 | C
3064_1_2600 | U |  |  |  |  | 55B_1_4000 | D
 |  |  |  |  |  | 55B_1_5100 | E
 |  |  |  |  |  | 232_2_0 | F
 |  |  |  |  |  | 232_3_2000 | G
 |  |  |  |  |  | 232_3_4200 | H
 |  |  |  |  |  | 208_1_0 | I
 |  |  |  |  |  | 208_1_15243 | J
 |  |  |  |  |  | 208_1_23133 | K
 |  |  |  |  |  | 208_1_30370 | L
 |  |  |  |  |  | 208_1_3532 | M
 |  |  |  |  |  | 208_1_3533 | N
 |  |  |  |  |  | 208_1_5230 | O
 |  |  |  |  |  | 208_1_2980 | P
 |  |  |  |  |  | 208_1_5420 | Q
 |  |  |  |  |  | 208_1_5420 | R
 |  |  |  |  |  | 208_1_6393 | S
 |  |  |  |  |  | 3064_1_0 | T
 |  |  |  |  |  | 3064_1_2370 | U
 |  |  |  |  |  | 3064_1_2630 | V
 |  |  |  |  |  | 3064_1_2630 | W
 |  |  |  |  |  | 3064_1_2680 | X
 |  |  |  |  |  | 3064_1_2687 | Y
 |  |  |  |  |  | 3064_1_2687 | Z
 |  |  |  |  |  | 3064_1_3730 | AB
 |  |  |  |  |  | 3064_1_420 | AC
 |  |  |  |  |  | 3064_1_420 | AD
Spreadsheet: 871129d1717566403-fishing-match-calcs-help-needed-please-fishing-match-v1
Sheet: Template (for copying)

Name | lbs | oz | Oz (total) | Points
Spreadsheet: 676096d1588653160-filtering-by-number-to-the-right-size-box-count-spreadsheet
Sheet: Sheet1

Quantity Ordered | Item Weight
365 | 3
 | [NAME] (inches) | Length (inches) | Height (inches) | Empty Weight (oz) | Items In Box | Number of Boxes Needed | Weight |  |  | Weight
[NAME] | 15 | 12 | 6 | 14 | 15
[NAME] | 20 | 15 | 5 | 28 | 40
[NAME] | 20 | 15 | 9 | 32 | 70
[NAME] | 20 | 15 | 18 | 48 | 150
Spreadsheet: 825585d1681404560-trying-to-figure-out-the-proper-vlookup-to-aggregate-some-data-example-excel-copy
Sheet: Sheet1

Client | Project Description | Project Indicator | Program Manager | Project or Service Board | Project Type | T&M or Fixed Fee | AA or Prof Services | Status | Contract Date | PoP end date | Original Contract Amount | Original Budget Hours | Original Contract Amount Minus Finance Contigency | Finance Contigency - ~25% | Client Approved CRs, $ | Client Approved Change Requests, Hours | Pending Internal CRs, $ | Pending Internal CRs, Hours
[NAME] | Name | 475 | Person | Project | Sales | Fixed | PS | Closed |  | 2022-11-30 00:00:00 | 10000 | 50 |  | 0
[NAME] | Name | 100 | Person | Project | Sales | Fixed | PS | Closed |  | 2022-11-30 00:00:00 | 20000 | 100 |  | 0
Spreadsheet: 773431d1647864297-max-if-function-across-several-sheets-testing
Sheet: Master

Name | Last Contact Date |  |  |  |  | Week1
A |  |  |  |  |  | Week2
B |  |  |  |  |  | Week3
C
D
E
F
G
H
Spreadsheet: 784718d1655919038-formula-to-determine-amount-to-transfer-to-or-from-savings-funds-to-be-transferred
Sheet: Sheet1

 |  |  |  | Savings | closing Balance | Min Required Bal | Transfer from/to Savings | Manual
 |  |  |  | 150000 | 115000 |  |  | -35000
 |  |  |  | 185000 | 145000 |  |  | -5000
 |  |  |  | 195000 | -205000 |  |  | 145000 | As Savings is less than 2 max amount than can be transfrred is savings -50000
Spreadsheet: 158446d1338246708-is-this-possible-reading-data-exception-tracking-2012
Sheet: Sept by Shift

AUDIT DESCREPANCIES BY SHIFT SEPTEMBER
 | SEPTEMBER
AUDIT DESCREPANCIES / EXCEPTIONS | DAY | SWING | GRAVE
Illegible or missing signature/ badge number
Any void not completed properly
Improper Error Corrections
Inconsistent Key Return
Incorrect/ Missing Information/ Totals
Missing Time Stamp/ Manual Date
Paperwork not received in Audit
Compliance Exceptions
Totals
Total Audit Exceptions
Total Compliance Exceptions
THESE ARE THE AUDIT DISCREPANCIES RECEIVED IN SEPTEMBER!
THE GOAL FOR OCTOBER IS A 10% REDUCTION. |  |  |  | OCTOBER GOAL
Spreadsheet: 742947d1628143023-need-help-with-formula-skipping-blanks-sa1
Sheet: Sheet1

Type | NAME/NUMBER | CASTING DATE | SONIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference |  |  |  | WC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA |  | S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NC |  | P7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA |  | P8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC |  | P9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P9
Spreadsheet: 292220d1390519137-dependant-list-with-illegal-characters-and-multiple-words-list-sample
Sheet: Sheet1

 | A | B
1 | Division | Section
2
3
4
5
6 | Divisions
7 | Finance
8 | Human Resources
9 | Facilities & Security
10 | Operations
11
12 | Finance
13 | Accounts
14 | Reporting
15 | Strategic Advice
16 | Banking
17
18 | Human Resources
19 | Employee Entitlements
20 | Conduct
21 | Analytics
22
23 | Facilities & Security
24 | Facilities Management
25 | Help Desk
26 | Personnel Security
27 | Protective Security
28
29 | Operations
30 | Team 1
31 | Team 2
32 | Team 6
Spreadsheet: 220903d1363296663-counting-formula-book3
Sheet: Sheet1

Jan Agent Totals | AR | Churn | POC/HLOF | EAM/MSB | Rep | Reslvd | Overall | LOE | Bills | How Many
1 | 0.0098 | 0.0047 | 0.5426 | 0.1
2 | 0 | 0.0005 | 0.4938 | 0.061
3 | 0 | 0.0229 | 0.6152 | 0.037 | 1 | 1 | 1 | 1 | 1
4 | 0.0571 | 0.0118 | 0.5504 | 0.014 | 1 | 1 | 0 | 1 | 1
5 | 0 | 0.0104 | 0.331 | 0.394
6 | 0 | 0.0754 | 0.5841 | 0.135 | 1 | 1 | 1 | 1 | 1
7 | 0 | 0.0074 | 0.497 | 0.141 | 1 | 1 | 0.5 | 1 | 1
8 | 0 | 0.0071 | 0.5937 | 0.035
9 | 0 | 0.0158 | 0.5136 | 0.229 | 1 | 1 | 1 | 1
10 | 0 | -0.0002 | 0.4337 | 0.092 | 1 | 1 | 1 | 1 | 1
11 | 0 | 0.0096 | 0.5988 | 0.003
 | 0.05 | 0.0179 | 0.5 | 0.1 | 0.95 | 0.9 | 0.87 | 0.91 | 0.87
FAIL IF UNDER | OVER | OVER | UNDER | UNDER | UNDER | UNDER | UNDER | UNDER | UNDER
Spreadsheet: larry_campbell__21314__LFC0700V1
Sheet: CED-PGE E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
CED | E | 2000 | 7 | MERCURY |  | dth | 11253 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 |  |  | PG&E ENERGY SERVICES END USERS
Spreadsheet: 32882d1229039857-formula-to-find-out-time-availability-test
Sheet: Sheet1

Project A | [NAME] | WW1 | WW2 | WW3 | WW4 | WW5 | WW6 | WW7 | WW8 | WW9 | WW10 | WW11 | WW12 | WW13 | WW14 | WW15 | WW16 | WW17 | WW18 | WW19 | WW20
Phase 1 | 2 wks
Phase 2 | 12 wks
Phase 3 | 1 wk
Phase 4 | 12 wks
Phase 5 | 2 wks
Phase 6 | 5 wks | 1 | 1 | 1 | 1 | 1
Phase 7 | 2 wks |  |  |  |  |  | 1 | 1
Project B | [NAME] | WW1 | WW2 | WW3 | WW4 | WW5 | WW6 | WW7 | WW8 | WW9 | WW10 | WW11 | WW12 | WW13 | WW14 | WW15 | WW16 | WW17 | WW18 | WW19 | WW20
Phase 1 | 2 wks
Phase 2 | 12 wks
Phase 3 | 1 wk
Phase 4 | 12 wks
Phase 5 | 2 wks
Phase 6 | 5 wks | 1 | 1
Phase 7 | 2 wks |  |  | 1 | 1
[NAME] from:
WW = Work Week
Spreadsheet: 881630d1729760501-value-on-an-image-standard-structures-test-xfr
Sheet: Structure List

Arata Standard Structure List
Title | Link
Charging Stations | Charging Stations Link
Counters
.25MD | Counter - .25MD
.5M | Counter-.5M
.5MR | Counter-.5MR
.5MD | Counter-.5MD
1M
1MD
1MDR
1MR
2M
2MD
2MR | 3
Other
Directionals
Entrance Units
10' or [NAME]
11' to 20'
21' to 30'
31' to 40'
Custom
Rental Units
10 x 10
10 x 20
Seating
SEG
Show Cases
Towers
Walls
Spreadsheet: 40322d1238618213-populate-a-table-from-a-log-book1
Sheet: Log

Sample of 'Log' Sheet
[NAME] | Account Code | Month | Billed | Payee | Amount |  | Use | Date Pd. | PMT
Water & Sewer | 804.4 | Dec | 2008-12-23 00:00:00 | City | 86.95 |  | Water & Sewer | 2009-01-07 00:00:00 | 86.95
Groceries | 306 | Jan | 2009-01-26 00:00:00 | [NAME] | 63.08 |  | Groceries | 2009-01-26 00:00:00 | 63.08
Phone | 804.3 | Dec | 2008-12-09 00:00:00 | AT&T | 43.64 |  | Phone
Medical | 805 | Dec | 2008-12-01 00:00:00 | Dept of VA | 256.03 |  | Medical
Nationwide Auto | 802.2 | Dec | 2008-12-18 00:00:00 | Nationwide Ins | 84.37 |  | Auto Ins | 2009-01-12 00:00:00 | 84.37
Auto Fuel | 803 | Mar | 2009-03-08 00:00:00 | GetGo | 19.5 |  | Gas | 2009-03-08 00:00:00 | 19.5
Gas Heat | 804.1 | Dec | 2008-12-31 00:00:00 | Columbia Gas | 108.61 |  | Home Heat
Chase Equity Line | 801.2 | Jan | 2009-01-09 00:00:00 | Chase Bank | 390.47 |  | Equity Line | 2009-01-26 00:00:00 | 390.47
Sample of 'Data' Sheet |  | What I get now
 |  | Totals | #N/A | 39 | 126.16 | #N/A | 3123.76 | 1024.12
Row 2 on 'Data Sheet' |  | Account #s | 1000 | 803 | 306 | 804.2 | 801.2 | 805
Month | Date | Type | Deposits | Auto Fuel | Groceries | Electric | Equity Line | Medical
Dec | 2008-12-23 00:00:00 | Visa | #N/A | 19.5 | 63.08 | #N/A | 390.47 | 256.03
Jan | 2009-01-26 00:00:00 | Visa |  | 19.5 | 63.08 | #N/A | 390.47 | 256.03
Dec | 2008-12-09 00:00:00 | Visa |  |  |  |  | 390.47 | 256.03
Dec | 2008-12-01 00:00:00 | [NAME] |  |  |  |  | 390.47 | 256.03
Dec | 2008-12-18 00:00:00 | Check |  |  |  |  | 390.47
Mar | 2009-03-08 00:00:00 |  |  |  |  |  | 390.47
Dec | 2008-12-31 00:00:00 |  |  |  |  |  | 390.47
Jan | 2009-01-09 00:00:00 |  |  |  |  |  | 390.47
Spreadsheet: 820414d1678099927-match-person-project-and-charge-help_match_project_person_charge
Sheet: Sheet1

Project name | Person Name 1 | Charge 1 | Person Name 2 | Charge 2
Test 1 | [NAME] | 0.2 | René | 0.3
Test 3 | René | 0.1 | [NAME] | 0.12
Test4 | [NAME] | 0.02 | René | 0.01
Spreadsheet: 867260d1714113997-can-i-get-excel-to-count-the-number-of-a-specific-digit-in-a-bunch-of-three-digit-numbers-counofdigit
Sheet: Sheet1

422 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
461 | Count of each digit in C1:L1 >>
291
234
598
884
470
739
115
127
367
498
917
471
891
594
172
960
255
812
Spreadsheet: 796490d1663312147-quickest-way-of-counting-results-example-data-2-aligw
Sheet: Sheet1

 | Data
 | Category | Result |  | Q | Question | Answer | Category |  | Category List |  |  | Result | Q1 | Q2 | Q3 | Q4
 | 1 | C |  | 1 | Do you use 1? |  |  |  | 1 |  |  | C
 | 1 | C |  | 2 | Do you use 2? |  |  |  | 2 |  |  | D
 | 1 | C |  |  |  |  |  |  | etc |  |  | E
 | 1 | C |  |  |  |  |  |  |  |  |  | F
 | 1 | D
 | 1 | E
 | 1 | E
 | 1 | D
 | 2 | D
 | 2 | E
 | 2 | E
 | 2 | F
 | 2 | F
 | etc | etc
Spreadsheet: 133522d1324454596-basic-vlookup-with-if-i-cant-work-this-out-practice
Sheet: with

 | RED | ID | Type | Title | Initial | Surname | Status | Issue | st | Amount | item | CARD | month | year | Bank | [NAME] | [NAME] | Swift | COST | Account | Date | Completed | enter | done | who | when
4 | 34 | 123456 | Individual | Ms | S | [NAME] | l | bl | ee | 172.5 | 0 | 12334343434 | 8 | 15 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
5 | 34 |  |  |  |  |  |  | sl |  |  |  | 333333333333 | 11 | 15 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 29-Nov-11
6 | 35 | 123456 | Individual | Miss | D | [NAME] | z | sl | ee | 774.42 | 0 | 43432432 | 9 | 14 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
7 | 54 | 123459 | Individual | Mr | T | [NAME] | r | sl | ee | 1347.77 | 0 | 4234234324 | 6 | 15 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
8 | 54 | 123455 | Individual | Mr | D | manly | r | sl | ff | 1125.94 | 0 | 5665545565 | 7 | 13 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
9 | 45 | 2323232 | Individual | Ms | K | Allt | D | SF | BDA59 | 1143.61 | 1 | 32324234234 | 7 | 14 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
9 | 45 | 3434324 | Individual | Ms | K | Allt | D | SF | BDA59 | 1143.61 | 1 | 83737363636 | 7 | 14 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
8 | 54 | 123455 | Individual | Mr | D | manly | r | sl | ff | 1125.94 | 0 | 838838373 | 7 | 13 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
9 | 45 | 54432323 | Individual | Ms | K | Allt | D | SF | BDA59 | 1143.61 | 1 | 9383838 | 7 | 14 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
9 | 45 | 44545454 | Individual | Ms | K | Allt | D | SF | BDA59 | 1143.61 | 1 | 93939393939 | 7 | 14 | Credit card |  |  |  | 3985756 | BS | 29-Nov-11 | TRUE | [NAME] | 30-Nov-11
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 24

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap dollar volumes, week ending November 16, by product type and cleared status (value of all trades in millions of USD), all participant types, tenors, and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 0901c355-d156-4006-a7a8-89311497ff88
Sheet: race_all

race | read_result | math_result | sci_result
Asian/Pacific Isl. | NC | NC | NC
Black | 74.5 | 49 | 34.7
Hispanic | 83.3 | 75 | 58.3
Multi | 100 | 83.3 | 75
Native Am | NC | NC | NC
Other | NC | NC | NC
White | 93.5 | 77.4 | 61.3
Spreadsheet: 142851d1330035888-excel-2007-looking-for-help-creating-average-if-formula-bp-readings
Sheet: Sheet3

Mom's Blood Pressure Readings Using Imron Wrist Cuff unit
Starting Feb 8, 2012 |  |  | (Averages based on systolic readings >85, diastolic<85)
Date | Time | Ave. BP |  | 1st Rdg |  | 2nd Rdg |  | 3rd Rdg |  | [NAME] |  | Read by: | Style
 |  | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom
2012-02-08 00:00:00 | 03:00:00 | 132 | 62 | 132 | 62 |  |  |  |  |  |  | Home Nurse | Arm Cuff
2012-02-08 00:00:00 | 03:15:00 |  |  | 143 | 67 | 132 | 67 | 132 | 68 | 138 | 73 | Mom | Wrist Cuff
 |  |  |  | 140 | 70 | 140 | 70 | 140 | 70 | 140 | 70
Spreadsheet: andy_zipper__739__10_29_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22.5 | 196 | 200 | 52.2 | 53.3 | 0.75 | 2001-10-29 11:21:00
 | CL F2 | 22.5 | 328 | 338 | 51.8 | 53.3 | 0.74 | 2001-10-29 11:21:00
 | CL G2 | 22.5 | 418 | 428 | 50.6 | 51.8 | 0.72 | 2001-10-29 11:21:00
 | CL H2 | 22.5 | 468 | 478 | 48.6 | 49.7 | 0.7 | 2001-10-29 11:21:00
 | CL J2 | 22.5 | 505 | 517 | 46.8 | 47.9 | 0.67 | 2001-10-29 11:21:00
 | CL K2 | 22.5 | 520 | 535 | 43.4 | 44.7 | 0.62 | 2001-10-29 11:21:00
 | CL M2 | 22.5 | 535 | 550 | 41.5 | 42.6 | 0.59 | 2001-10-29 11:21:00
 | CL N2 | 22.5 | 540 | 560 | 39 | 40.4 | 0.56 | 2001-10-29 11:21:00
 | CL Q2 | 22.5 | 550 | 565 | 37.5 | 38.5 | 0.54 | 2001-10-29 11:21:00
 | CL U2 | 22.5 | 555 | 570 | 36 | 37 | 0.52 | 2001-10-29 11:21:00
 | [NAME] | 22 | 558 | 573 | 35.3 | 36.2 | 0.49 | 2001-10-29 11:21:00
 | CL X2 | 22 | 560 | 575 | 34 | 34.9 | 0.48 | 2001-10-29 11:21:00
 | [NAME] | 22 | 560 | 580 | 32.9 | 34 | 0.46 | 2001-10-29 11:21:00
 | CL M3 | 21.5 | 550 | 570 | 27.9 | 29 | 0.38 | 2001-10-29 11:21:00
 | CL Z3 | 21.5 | 550 | 570 | 24.9 | 25.8 | 0.34 | 2001-10-29 11:21:00
Spreadsheet: 06ee1bfd-4391-4116-b5dc-61a5cd695860
Sheet: Sheet1

各省管局备案咨询电话 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
序号 | 省份 | 网站备案咨询电话
1 | 北京通信管理局 | 010-63310094
2 | 天津通信管理局 | 022-60351158
3 | 河北通信管理局 | 0311-81582202
4 | 山西通信管理局 | [PHONE]
5 | 内蒙古通信管理局 | [PHONE]
6 | 辽宁通信管理局 | 024--86581199 | 024--86581402
7 | 吉林通信管理局 | 0431—88925397
8 | 黑龙江通信管理局 | 0451-53610153
9 | 上海通信管理局 | 021-63905006
10 | 江苏通信管理局 | 025-85039806 | 025-85039833
11 | 浙江通信管理局 | 0571-87078277
12 | 安徽通信管理局 | 0551－5680622 | [PHONE]
13 | 福建通信管理局 | 0591-28355716
14 | 江西通信管理局 | [PHONE] | [PHONE]
15 | 山东通信管理局 | 0531-82092828
16 | 河南通信管理局 | 0371-65795120
17 | 湖北通信管理局 | 027-87796833 | 027-87796001
18 | 湖南通信管理局 | 0731-82338652
19 | 广东通信管理局 | 020-87628386
20 | 广西通信管理局 | [PHONE] | [PHONE] | [PHONE]
21 | 海南通信管理局 | 0898-66533831 | 0898-66550106
22 | 重庆通信管理局 | 023-68583855
23 | 四川通信管理局 | 028-87015272 | 028-87012203
24 | 贵州通信管理局 | 0851--5611000
25 | 云南通信管理局 | [PHONE]
26 | 西藏通信管理局 | [PHONE]
27 | 陕西通信管理局 | 029-88333377 | 029-12321
28 | 甘肃通信管理局 | [PHONE] | [PHONE]
29 | [NAME] | [PHONE]
30 | 宁夏通信管理局 | [PHONE]
31 | 新疆通信管理局 | [PHONE]
Spreadsheet: 166699d1341741983-vlookup-to-impress-my-boss-may
Sheet: May

Products | Revenue | Products
x019281 | 698726
x2597211 | 426132
x9906821 | 437220
x9213320 | 19516
x6583257 | 222168
x8539221 | 855149
[NAME] | 870047
x10108100 | 279262
x9000769 | 581636
x2557358 | 877714
x3215868 | 437010
[NAME] | 414282
x10066927 | 166103
x6547815 | 800895
x182423 | 851759
x7706548 | 683927
[NAME] | 806050
x396345 | 947599
x8790141 | 400132
x1419959 | 729494
x2776728 | 371055
x1055856 | 280809
x8402480 | 201607
x9019400 | 859738
[NAME] | 340580
x8930845 | 486395
x8252790 | 56074
x2818482 | 704633
x9885446 | 618316
x7443669 | 277696
x8191171 | 74403
x6751973 | 344150
x5725039 | 736883
x9425472 | 346968
x3617826 | 352106
x8630255 | 799358
x5923195 | 541528
x5423416 | 266456
x217128 | 54624
x8848922 | 920252
x6852243 | 942153
x9023526 | 760338
x5807964 | 828084
x9346757 | 533442
x2019950 | 876967
x4459038 | 607777
x7216414 | 389048
x7037127 | 621376
x7861271 | 103933
x3014623 | 255123
x2968083 | 831934
x9506183 | 97395
x999498 | 560849
x8891982 | 404565
x2572541 | 481825
x2287391 | 871063
x7389590 | 346567
x4828249 | 497193
x4674573 | 121069
x5506219 | 199305
x2992861 | 226952
x8281798 | 339235
x2477640 | 829344
x6925780 | 47605
x6245786 | 737848
x4030139 | 499593
x1614954 | 268324
x4059280 | 199128
x3060307 | 476365
x8565149 | 25500
x1416149 | 132494
x4850608 | 824190
x6856407 | 87411
x2026520 | 914223
x143505 | 336600
x9456835 | 71288
x3651915 | 720068
x6448893 | 269399
x1461774 | 379465
x7302843 | 361093
x8520097 | 424965
x3100702 | 772052
x6452270 | 820228
x102714 | 981349
x6603751 | 494191
[NAME] | 981796
x6220988 | 104445
x8132410 | 90421
x1378961 | 656240
x6933846 | 578171
x3331464 | 698074
x2985443 | 39992
x8662778 | 297963
x5167164 | 32365
x5157474 | 101670
x3551750 | 143196
x8843342 | 657229
x6690268 | 554353
[NAME] | 929004
[NAME] | 309739
x3254260 | 304725
x1549515 | 900313
[NAME] | 338088
x9172154 | 823500
x5952909 | 357961
x5532817 | 510049
Spreadsheet: 165789d1341339248-index-and-match-3-criterias-multiple-sheets-test-sample
Sheet: Gross Margin

Gross Margin
Cars | GROSS MARGIN | Markets Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROSS MARGIN | Markets Europe
 | 2010 |  |  |  |  |  |  |  |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012
TOTAL | P1/10 | [NAME] | P3/10 | P4/10 | P5/10 | P6/10 | P7/10 | P8/10 | P9/10 | P10/10 | P11/10 | P12/10 | P1/11 | P2/11 | P3/11 | P4/11 | P5/11 | P6/11 | P7/11 | P8/11 | P9/11 | P10/11 | P11/11 | [NAME] | P1/12 | [NAME] | P3/12 | P4/12 | P5/12 | P6/12 | [NAME] | P8/12 | P9/12 | P10/12 | P11/12 | P12/12
Europe
Eurasia
MEA
SEAP
India
NA
LATAM
China
World TOTAL
Spreadsheet: 211567d1359817069-sorting-based-on-matching-characteristics-binsort3_nonunique
Sheet: Sheet1

Object | [NAME] | Color | Shape | Combined
1 | 1 | blue | circle | bluecircle
2 | 1 | red | square | redsquare
3 | 1 | blue | circle | bluecircle
4 | 2 | green | triangle | greentriangle
5 | 2 | blue | circle | bluecircle
6 | 2 | red | triangle | redtriangle
7 | 3 | yellow | circle | yellowcircle
8 | 3 | green | triangle | greentriangle
9 | 3 | blue | circle | bluecircle
Spreadsheet: 722557d1615312953-consolidate-but-calculate-the-difference-subtract-during-consolidate-dia-withrealdata
Sheet: Sheet1

Name | Sales |  |  |  |  | Unique Books | Difference first vs last
Car [NAME] 4 Version 1702 | 1061168
[NAME] 6.0 | 711601
Dansworth C1500 (Type-C) Front Engine Bus 9.2 | 703681
[NAME] 1.1 | 702367
American Road 1.7.01 | 564750
Codename : oldsfullsize 2.1 | 564143
ETK 1300 5.1 | 544355
FR17 (2018 update) 1.4 | 529730
8x8 Heavy utility truck 2016-6-5 | 506516
Car [NAME] 4 Version 1702 | 1061168
[NAME] 6.0 | 711601
Dansworth C1500 (Type-C) Front Engine Bus 9.2 | 703681
[NAME] 1.1 | 702367
American Road 1.7.01 | 564750
Codename : oldsfullsize 2.1 | 564143
ETK 1300 5.1 | 544355
FR17 (2018 update) 1.4 | 529730
8x8 Heavy utility truck 2016-6-5 | 506516