tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1c57d8b5-c57f-40c0-b8ac-13106f9a21f8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 841100d1693348522-index-value-has-messed-up-formatting-formatting-problem-index
Sheet: Report

 | Game | 1
Offense - Game Metrics
Metric | Value ([NAME])
Total Plays
Drives
Plays Per Drive
Drive Duration
Intra-Drive Stoppage Time
Play Clock
Inter-Drive Rest Time
Defense - Game Metrics
Metric | Value ([NAME])
Total Plays
Drives
Plays Per Drive
Drive Duration
Intra-Drive Stoppage Time
Play Clock
Inter-Drive Rest Time
Spreadsheet: 684279d1593260730-how-to-count-same-last-digits-numbers-from-rows-c2-i1000000-inventory-1
Sheet: Sheet1

Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Same last Digits (Count Max one) | Same first [NAME] (Count Max one)
JA-0090-20 | SS-002245 | 125666 | 125667 | 15 | 556 | 557 | 558 | 556 | 3
JA-0090-21 | SS-002246 | 01 | 2985 | 02 | 668 | 88855 | 09 | 888 |  | 3
JA-0090-22 | SS-002247 | 333 | 345986 | 475 | 4423 | 323 | 100 | 336789 |  | 4
JA-0090-23 | SS-002248
JA-0090-24 | SS-002249
JA-0090-25 | SS-002250
Spreadsheet: 103028d1300882004-fetch-unique-values-from-a-single-column-sample-testdata2
Sheet: Testdata

EIN | Amount |  | Amount
530196605 | 10 |  | EIN | Total
530196605 | 10 |  | 42103580 | 159
530196605 | 10 |  | 123456803 | 20
530196605 | 10 |  | 272499903 | 81
42103580 | 109 |  | 368521454 | 80
272499903 | 9 |  | 530196605 | 40
911189249 | 10 |  | 752485698 | 2220
911189249 | 50 |  | 852456123 | 99
368521454 | 10 |  | 852741369 | 10144
42103580 | 50 |  | 911189249 | 60
852741369 | 10000 |  | 941156365 | 88
852741369 | 10 |  | 942443282 | 109.5
852741369 | 101 |  | 963258740 | 262.8
852741369 | 13 |  | 963852745 | 10
123456803 | 20 |  | Grand Total | 13373.3
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: 18d6b8de-db1d-4cea-ae8d-e0e2e34ed052
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2148 | 6137 | Erhard | Wolfaardt | RSA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:08:36
2148 | 5789 | Rory | [NAME] | ZIM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:18:57
2148 | 6138 | Travis | Campbell | RSA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:19:04
2148 | 10745 | Mark | Meadows | ZIM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:27:29
2148 | 10746 | [NAME] | Martin | ZIM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:31:10
2148 | 10522 | Mark | Marabini | ZIM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 02:40:08
2148 | 10747 | Nick | Nyahuye | ZIM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 02:48:59
Spreadsheet: 856382d1705639262-single-cell-formula-to-return-results-not-found-after-comparing-2-lists-kwoltman
Sheet: WS1

Username | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
A
B
C
A
B
C
A
B
C
A
B
C
A
B
D
Spreadsheet: 125515d1319066323-building-a-pivot-table-to-see-total-cost-starterfile-3
Sheet: Inventory

Item # | Current Item Count | Vendor ID | # to Order | Subtotal | Tax | Total
1001 | 3 | 1 | 1 | 5.5 | 0.31625 | 5.81625
1002 | 5 | 2 | 0 | 0 | 0 | 0
1003 | 3 | 2 | 9 | 34.2 | 1.9665 | 36.1665
1004 | 9 | 3 | 0 | 0 | 0 | 0
1005 | 4 | 3 | 1 | 12.98 | 0.8437 | 13.8237
1006 | 2 | 4 | 8 | 14.08 | 0.8096 | 14.8896
1007 | 5 | 4 | 10 | 20.5 | 1.17875 | 21.67875
1008 | 3 | 3 | 3 | 29.7 | 1.9305 | 31.6305
1009 | 6 | 1 | 0 | 0 | 0 | 0
1010 | 55 | 5 | 20 | 44.8 | 2.912 | 47.712
1011 | 78 | 5 | 47 | 35.25 | 2.29125 | 37.54125
1012 | 77 | 2 | 0 | 0 | 0 | 0
1013 | 33 | 2 | 17 | 11.05 | 0.635375 | 11.685375
1014 | 44 | 2 | 31 | 31 | 1.7825 | 32.7825
1015 | 54 | 1 | 46 | 23 | 1.3225 | 24.3225
Spreadsheet: 783435d1654810680-keeping-rows-connected-to-each-other-when-data-gets-added-to-a-sheet-dynamic-data-example
Sheet: Sheet1

Yesterday's data |  |  |  |  | Today's Data
Dynamic Data (refreshed) |  |  | Static Data |  | Dynamic Data (refreshed) |  |  | Static Data
ID | Name | Gender | My Notes |  | ID | Name | Gender | My Notes
3 | [NAME] | Female | Processed |  | 4 | Sal | Male | Processed
2 | [NAME] | Male | Not Processed |  | 3 | [NAME] | Female | Not Processed
1 | [NAME] | Male | Processed |  | 2 | [NAME] | Male | Processed
 |  |  |  |  | 1 | [NAME] | Male
Spreadsheet: 0ebc6565-ce58-4634-899f-98da386a2a5b
Sheet: Sheet1

North American Association of Central Cancer Registries | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2010 ANNUAL CONFERENCE
NCRA Recognition Number  2010-071
It is your responsibility to document the session that you attended.
Please keep this form for your credential submission.
Name: |  |  | Total Hours:
 | TOPIC | SPEAKER | CE HOURS APPROVED | RECOGNITION NUMBER | HOURS ATTENDED
2010-06-19 00:00:00 | Pre-conference, Saturday
08:30:00 | Basic SEER*Stat Software Training | [NAME] (NCI/SEER) | 7.5 | 2010-071A
2010-06-20 00:00:00 | Pre-conference, Sunday
08:00:00 | CDC Registry [NAME] | [NAME] | 3.75 | 2010-071C
08:30:00 | Advanced SEER*Stat Software Training | [NAME] (NCI/SEER) | 7.5 | 2010-071B
12:30:00 | Central Cancer Registries: A Review Short Course 1 | Herman Menck | 3.25 | 2010-012
13:00:00 | EDITS Tools: Application Overview & User Training | [NAME] | 3.75 | 2010-071F
2010-06-21 00:00:00 | Pre-conference, Monday
08:00:00 | Central Cancer Registries: A Review Short Course 2 | Herman Menck | 6 | 2010-012
2010-06-22 00:00:00 | Conference Day 1, Tuesday
09:00:00 | Keynote Address: Advance Cancer Control | [NAME], MD | 1 | 2010-071
10:30:00 | Knowledge to Action, Action to Knowledge | [NAME], PhD | 0.75 | "
11:15:00 | Transforming Cancer Care & Research | [NAME], PhD | 0.75 | "
13:30:00 | Concurrent Session 1 |  | 1.5 | "
15:30:00 | Concurrent Session 2 |  | 1.5 | "
2010-06-23 00:00:00 | Conference Day 2, Wednesday
08:30:00 | Synoptic Cancer Pathology Reporting | [NAME], MD | 0.75 | "
09:15:00 | [NAME] | [NAME] | 0.25 | "
10:00:00 | Concurrent Session 3 |  | 1.5 | "
2010-06-24 00:00:00 | Conference Day 3, Thursday
08:30:00 | Concurrent Session 4 |  | 1.5 | "
10:30:00 | Concurrent Session 5 |  | 1.5 | "
14:00:00 | NAACCR Showcase | [NAME], MPH, CTR | 1 | "
15:30:00 | Point Counter Point: The Process of Determining New Data Elements | [NAME], PhD | 1 | "
2010-06-25 00:00:00 | Post-conference, Friday
08:30:00 | Continuous Process Improvement & Managing Chng | [NAME] | 7 | 2010-071D
08:30:00 | 2010 Hematopoietic & Lymphoid Neoplasm Project | [NAME] | 7 | 2010-071E
Total Hours
Spreadsheet: 862834d1710421628-need-help-totaling-based-on-selections-mix-id-calculator-tier_addres
Sheet: Commercial Price Tab

Commercial Mix ID Calculator
Mix ID | Price |  | Add On | Price |  | Distance | Price |  | Tier | Price
COM301510 | 0 |  | Air | 3 |  | 1-10 | 0 |  | T1 | 121
COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | T2 | 126
COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | T3 | 131
COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20
COM501510 | 20 |  | 1%Retard | 0
COM601510 | 30 |  | 2%Retard | 1
COM701510 | 40 |  | 3%Retard | 2
COM801510 | 50 |  | Fiber | 7
500S | 7 |  | SRA | 75
550S | 12 |  | SS | 7
600S | 17
650S | 22
700S | 27
800S | 32
Spreadsheet: 150202d1334331875-sumif-for-multiple-column-sheet-criteria-book-2_reply
Sheet: Sheet1

Date | D_Instore | D_Name | D_NESSOFT_BATCH | Customer No. | Qty
2012-02-23 00:00:00 | 25/02/2012 | TEST NAME 2 | 105901 | 120450 | 300 |  | <SUMPRODUCT formulas (grey cells) match [NAME] and Date.
2012-02-24 00:00:00 | 25/02/2012 | TEST NAME1 | 105901 | 614534 | 250
2012-02-25 00:00:00 | 25/02/2013 | TEST NAME2 | 105901 | 120450 | 200
2012-02-26 00:00:00 | 25/02/2014 | TEST NAME3 | 105901 | 614534 | 400
2012-02-27 00:00:00 | 25/02/2015 | TEST NAME4 | 105901 | 345234 | 500
Spreadsheet: 689655d1596570927-i-need-to-get-a-random-sample-from-data-within-a-pivot-table-excel-forum-sample
Sheet: P&C Random

Template Change Request Item: Template Change ID | Random Sample | Advisor
CI-000404586 | 13 | [NAME] | Done | 1
CI-000404628 | 15 | [NAME] | Done | 2
CI-000400459 | 7 | [NAME]
CI-000403613 | 7 | Repeat
CI-000405721 | 7 | Repeat
CI-000404588 | 19 | [NAME] | Done | 3
CI-000402649 | 13 | Repeat
CI-000402699 | 19 | Repeat
[NAME] | 10 | [NAME] |  | 4
CI-000406058 | 11 | [NAME] |  | 5
CI-000406084 | 11
CI-000403308 | Done L2
CI-000404589 | 9
CI-000402550 | Done L3
CI-000404590 | 7
CI-000402778 | 18
CI-000404573 | 17
[NAME] | [NAME]
Spreadsheet: 27489d1220723877-summing-up-book1
Sheet: Sheet1

Type |  | Net
NEW | 49767 | 110000
TOP-UP | 83397.82 | 110000
TOP-UP | 16217.47 | 44000
TOP-UP | 131262.02 | 170000
NEW | 58731.38 | 110000
TOP-UP | 21787.02 | 45000
TOP-UP | 102383.76 | 150000
NEW | 105662.2 | 160000
NEW | 2547.11 | 15000
T/O | 147776.1 | 213000
T/O | 54621.66 | 75000
TOP-UP | 172724.65 | 250000
Top-Up
Spreadsheet: 456911d1461115903-conditional-formatting-checking
Sheet: PORT

Location Code | Location Name
AFBIN | [NAME]
AFBST | BOST
AFCCN | CHAKCHARAN
AFDAZ | DARWAZ
AFISQ | ESLAM QAL'EH
AFFBD | FAIZABAD
AFFAH | FARAH
AFGRG | GARDEZ
AFGZI | GHAZNI
AFHRT | HAIRATAN
AFHEA | HERAT
AFJAA | [NAME]
AFKBL | KABUL
[NAME] | KANDAHAR
AFKHT | KHOST
AFKHO | KHOWST
AFKWH | KHWAHAN
AFUND | KUNDUZ
AFKUR | KURAN-O-MUNJAN
AFMMZ | MAIMANA
AFMAS | MASHAD
AFMZR | MAZAR-I-SHARIF
AFIMZ | NIMROZ
AFLQN | QALA NAU
AFQLT | QALAT
[NAME] | [NAME]
AFSBF | SARDEH BAND
Spreadsheet: 227788d1365809717-need-help-formatting-a-workbook-with-a-search-function-example
Sheet: Ron

Stats
Name: | [NAME]
Ears
 | Pencil | Pen
First | 301 | 0
Last | 1499 | 999
Scope
First | 3001 | 2101
Last | 9999 | 4999
Scope
First | 11001 | 6001
Last | 24999 | 14999
Scope
First | 28001 | 17001
Last | 99999 | 94999
Scope
First | 150001 | 100001
Last | 200000 | 249999
Scope
MORE INPUTED DAILY
Eyes
 | Pencil | Pen
First | 301 | 0
Last | 699 | 299
Scope
First | 1201 | 751
Last | 5299 | 9779
Scope
First | 6701 | 10548
Last | 14499 | 27049
Scope
First | 16900 | 30716
Last | 73999 | 75986
Scope
First | 79055 | 84001
Last | 85000 | 340157
Scope
MORE INPUTED DAILY
Spreadsheet: 678020d1589661522-about-formula-generation-sample
Sheet: Sayfa1

294.871282
300.355509
288.1858976
303.5621434
294.7132497
294.7132497
301.3674643
300.2428122
298.068898
315.8371665
309.1218966
320.2482676
315.8371808
319.1311573
Spreadsheet: 841711d1693895243-index-match-functions-with-multiple-values-and-empty-cells-arbeitsmappe1-aligw
Sheet: Tabelle1

3 | A |  | G | A |  |  | G
5 | B |  | E | C | C | 1 | E
2 | C |  | H | I | I | 1 | H
 | D |  | C | J | J | 2 | C
1 | E |  | A |  |  | 3 | A
 | F |  | I |  |  | 3 | I
0 | G |  | J |  |  | 3 | J
1 | H |  | B |  |  | 5 | B
3 | I
3 | J
Spreadsheet: 781814d1653562266-identify-highest-numeric-value-of-duplicate-names-maxifs-aligw
Sheet: Sheet1

name | score | TRUE/FALSE | MAX AMOUNT
Spot | 5
Dino | 4
Dino | 9
Fido | 6
Spot | 2
Spot | 7
Fido | 2
Spreadsheet: 455563d1460400742-matching-customers-with-sales-reps-sample
Sheet: Sheet1

Customer Name | Invoice Date | State | AM
NAVITUS HEALTH SOLUTIONS | 02/24/2015 | WI | JOSH  (3313)
STARR COMPANIES | 03/04/2016 | IL | -
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | -
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | -
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | -
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | -
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | -
UNIVERSITY OF ALABAMA | 03/20/2015 | AL | KRISTOFER  (1879)
UNIVERSITY OF ALABAMA | 03/10/2015 | AL | KRISTOFER  (1879)
UNIVERSITY OF ALABAMA | 03/10/2015 | AL | KRISTOFER (1879)
MEDICAL SECURITY CARD | 03/04/2016 | AZ | -
NATIONAL RECOVERIES INC | 03/28/2015 | MN | TIMOTHY (N490)
CROZER CHESTER MEDICAL CENTER | [NAME] | PA | -
CROZER CHESTER MEDICAL CENTER | 03/24/2015 | PA | KEVIN  (Q047)
CROZER CHESTER MEDICAL CENTER | 03/24/2015 | PA | KEVIN  (Q047)
CROZER CHESTER MEDICAL CENTER | 02/05/2015 | PA | KEVIN  (Q047)
LAYERED TECH/DATAPIPE | 03/28/2015 | VA | MATTHEW (N537)
[NAME] ROVIRA CTR | 03/24/2015 | NY | CARRIE (6513)
ROGERS | [NAME] | AZ | -
ROGERS | [NAME] | AZ | -
ROGERS | [NAME] | AZ | -
ROGERS | 02/26/2016 | CT | -
ROGERS | 03/20/2015 | AZ | [NAME] (F064)
Spreadsheet: 749193d1632497242-concate-if-text-sample-workbook
Sheet: Sheet1

ID Number | First Name | Last Name | Notes
26958675 | Angie | Shawson
26978055 | [NAME] | Tayor | Phillips partner  was unwell 2/7/2021 [NAME] unable to come in for night duty .I  have been informed this morning that Phillips partner  has passed away RIP over the weekend
awaiting contact from [NAME] .
following a discussion with  [NAME] 13th  July2021 between [NAME] and [NAME]
it has been agreed that the period from 2/7/21 till the 8/07/21  with been self cert  the period from the 9th  July   [NAME] will be on sick leave  until 23rd July 2021.
Visiting GP today and will continue to contact us on a Monday.
[NAME] does not require  any special  leave .
[NAME]  has  contacted us today  the 26th July 2021  to say he will be returning to work  on the 6th August 2021
he explained he had picked some bank shifts up and would like to keep these, [NAME] aware of support network
and invited in by  pat should he wish to come in to work  for a coffee or catch up , [NAME] stated he would be ok .
27449114 | Kat | Sayor
26946663 | [NAME] | Jones
28230384 | [NAME] | Clown | Absent with Covid
28050522 | [NAME] | Cole
26932251 | [NAME] | [NAME] | Self isolation x2 days in preparation for medical procedure 22.09.21, as instructed by Medical team.
Works Monday/Tuesday/Friday (22.5hrs)
Spreadsheet: 06decb91-a0b6-45b2-bede-3fb8b0ea234d
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 12/19/2014 2:01:56 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 873714d1720257110-find-a-result-from-2-matrix-tables-matrix-example
Sheet: Results

 | users / groups |  |  |  |  |  |  |  | functions / groups |  |  |  |  |  |  |  |  |  |  | results
 |  | Production | Sales | Finance | Management | GROUPLIST |  |  |  | Production | Sales | Finance | Management | GROUPLIST |  |  |  |  |  |  | Order | Quote | Job | Pay | PO's | Supplier
 | User1 | x |  |  |  |  |  |  | Order | x | x | x | x |  |  |  |  |  |  | User1 | x |  | x |  | x
 | User2 | x |  |  | X |  |  |  | Quote |  | x | x |  |  |  |  |  |  |  | User2 | x |  | x |  | x
 | User3 |  | x |  |  |  |  |  | Job | x | x |  |  |  |  |  |  |  |  | User3 | x | x | x |  | x
 | User4 |  | x |  |  |  |  |  | Pay |  |  | x |  |  |  |  |  |  |  | User4 | x | x | x |  | x
 | [NAME] |  | x |  |  |  |  |  | PO's | x | x | x |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x
 | [NAME] |  |  | x |  |  |  |  | Supplier |  |  | x | x |  |  |  |  |  |  | [NAME] | x | x |  | x | x | x
 | User7 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User7 | x |  |  |  |  | x
 | User8 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User8 | x |  |  |  |  | x
 | [NAME] | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x
 | User10 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User10 | x |  | x |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the objective is (in V3)
 |  |  |  |  |  |  |  | this is looking up users / groups using "User1" as the search and GroupList as the return |  |  |  |  |  |  |  |  |  |  |  |  | search users / groups using U3 as search criteria to return the GroupList (column G find row)
 |  |  |  |  |  |  |  | this is looking up functions / groupd using "Order" as the search and GroupList as the return |  |  |  |  |  |  |  |  |  |  |  |  | search functions / groups using V2 as search criteria to return the GroupList (colum O find row)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | check Array1 results with Array2 to see if any contents match. If they do, return TRUE
 |  |  |  |  |  |  |  | Because the word 'Production is in both array lists, I would expect a return value of TRUE |  |  |  |  |  |  |  |  |  |  |  |  | This would then mark if the user has access to the group.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to see if Array1 has any contents of Array2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Array1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Array2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | result | True
Spreadsheet: 692708d1598517221-correlation-and-cross-sell-on-multiple-products-cross-sell
Sheet: Arkusz1

PRODUCT | CLIENT no | AMOUNT
BREAD | 1 | 1
MILK | 2 | 1
CAR | 2 | 2
BREAD | 5 | 1
MILK | 5 | 1
SWEETS | 5 | 1
WATER | 5 | 1
LEMONS | 6 | 1
APPLES | 6 | 1
MILK | 7 | 2
LEMONS | 7 | 1
COKE | 7 | 1
WAFFELS | 8 | 1
EGGS | 9 | 2
MILK | 9 | 1
Spreadsheet: 792009d1660691042-offset-formula-to-calculate-rolling-average-returns
Sheet: offset

3 Day Data
Date | TSLA | MSFT
 |  |  |  | Offset By
 |  |  |  | 3
Spreadsheet: 06adddd9-1b59-4b2e-a368-50d9eaf9774a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Contents |  | Page
Budget and Council Objectives |  | 2-3
Revenue Expenditure |  | 4
Summary - Gross Expenditure |  | 5
Summary - Gross Income |  | 6
Summary - Net Expenditure |  | 7
Summary by type of expenditure/income |  | 8-9
Capital Expenditure |  | 10-13
Employee Numbers |  | 14-15
Directorate Budget Analysis:
Economy |  | 16-20
People |  | 21-26
Place |  | 27-29
Districts |  | 30-35
Council Tax |  | 36-37
Glossary |  | 38
Spreadsheet: mary_fischer__25623__31Y
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME  The LINC Corp Holding Company
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 |  | Equity/Invmt Sub | complete
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A