tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814477d1674431395-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test2
Sheet: CLAIM MANAGEMENT 2022FY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custo de venda final ( valor CWFS)
 | Claim Category |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLAIM COSTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material + CPO | Penalties | Rework | QAS | Transport | TOTAL
 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4880
APR | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.09 |  |  | 12.94
 | Eliminada |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167 |  |  | 12.94 | 6.7
 | A
 | Not accepted - Dispatch
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.05 |  |  | 12.94 | 6.7 |  |  |  |  |  |  | 6,7 - Transporte
MAY | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 189.63 |  |  | 12.94 | 12.94
 | Eliminada
 | NA
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 663 |  |  | 12.94 | 6.7 | 695.2
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  | 12.94 | 6.7
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
 | NA
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
 | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
JUN | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
 | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 727 |  |  |  | 6.7
 | Inquiry
JUL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 6.7
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stock zippers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204 |  | 6.7
AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
SEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 12.9
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.9 | 6.7
OCT | [NAME] ([NAME])
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.88 | 6.7
 | B
 | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.88 | 13.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 12.9 | 6.7
NOV
 | E
 | B
 | B
DEC
 | E
 | Eliminada
 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.44
Spreadsheet: 689463d1596442255-check-price-for-different-related-part-number-2020-08-03-oeldere-wongsiuon-689457d1596438351-check-price-for-different-related-part-number
Sheet: Sheet2

Part | Price | Effective from | Effective To | explanation | helpcolumn | HC2 |  | Check number | 123K4567 |  |  |  |  |  | Check Part | Current quotation | Last 1st quotation | Last 2nd quotation
123K45670 | 525 | 2015-04-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  |  | new number |  |  |  |  |  |  | 123K45674 | BLANK | 626 | 508
123K45670 | 519 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  |  | last nr |  |  |  |  |  |  |  | 123K45674 | 123K45673 | 123K45670
123K45670 | 516 | 2016-10-04 00:00:00 | 2019-10-06 00:00:00 | quotation expired |  |  |  | first |  |  |  |  |  |  | can use concatenate | 123K45674 "BLANK" | 123K45673 626 | 123K45670 508
123K45670 | 508 | 2019-10-07 00:00:00 |  | <=active quotaton
123K45671 | 541 | 2015-05-13 00:00:00 | 2017-04-18 00:00:00 | quotation expired |  |  |  |  |  |  |  |  |  |  | Notes
123K45673 | 609 | 2015-08-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  |  |  |  |  |  |  |  |  | part roll up on last part number
123K45673 | 602 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  |  |  |  |  |  |  |  |  | D5, D12 are active quotation
123K45673 | 673 | 2016-10-04 00:00:00 | 2017-10-03 00:00:00 | quotation expired |  |  |  |  |  |  |  |  |  |  | input 123K45674, want [NAME] part price for previous revision part number
123K45673 | 635 | 2017-10-04 00:00:00 | 2018-09-30 00:00:00 | quotation expired
123K45673 | 630 | 2018-10-01 00:00:00 | 2019-09-30 00:00:00 | quotation expired
123K45673 | 626 | 2019-10-01 00:00:00 |  | <=active quotaton
part roll up on last part number
…
…
…
A list of different part quotation.
…
…
…
…
…
…
 |  | please see attached excel
 |  | i have a list of part quotation. it includes all revision of part price. Some price is old (expired). when the effective date is blank, it is active price.
 |  | i want to check a list of part price with previous revision, when a part number is provided.
Spreadsheet: 605948d1547401570-problem-using-index-array-extracting-results-from-if-search-duplicate-results-search-copy-of-abroad
Sheet: Sheet2

 | Days to expiry | Device Owner (surname) | Device Owner (forename) | Device Owner (Pid) | Device | Device ID | DG Reference | Outbound Date | Return Date | Ad Hoc (Y/N) | 6M/12M dispensation | [NAME]
Spreadsheet: 819668d1677625479-if-formula-excel-help
Sheet: Sheet1

 | Items per Set | 36 | 36 | 36 | 36 | 200 | 360 | 180 | 300 | 450
 |  | SET
 | Field # | 1 Demo | 2 Demo | 3 Demo | 4 Demo | 80 A | 95 A | 100 A | 110 B | 115 A
 | IL09 | 1 |  | 2.2 |  |  |  |  |  | 3.5
 | IA50 |  | 1.5 |  |  | 0.7
 | SK43 |  |  |  | 3 |  |  |  | 2.8
 | TR40 |  | 0.8 | 1 |  |  |  |  | 4.6 | 1.9
Spreadsheet: 221258d1363447655-if-and-vlookup-help-cost-sample
Sheet: GG pur

1413 | 5 | 1000 | CROWN ROYAL 80O | 150.8 | 30.16 | 30.16
1590 | 4 | 1000 | JACK DANIELS BLACK 80O | 98.88 | 24.72 | 24.72
1907 | 1 | 1000 | PRESIDENTE BRANDY 80O | 13.29 | 13.29 | 13.29
1908 | 4 | 1750 | PRESIDENTE BRANDY 80O | 93.24 | 23.31 | 23.31
2111 | 1 | 1000 | BEEFEATER 94O | 23.42 | 23.42 | 23.42
2267 | 1 | 1000 | JOHN JAMESON 80O | 27.73 | 27.73 | 27.73
2354 | 1 | 1000 | BAILEYS IRISH CREAM 34O | 24.41 | 24.41 | 24.41
2424 | 1 | 750 | CHAMBORD ROYALE 33O | 25.14 | 25.14 | 25.14
2426 | 3 | 750 | CHAMBORD ROYALE - BAR PACK 33O | 75.42 | 25.14 | 25.14
2576 | 1 | 1000 | KAHLUA 40O | 24.38 | 24.38 | 24.38
2878 | 10 | 1000 | BACARDI SUPERIOR 80O | 149.2 | 14.92 | 14.92
2915 | 1 | 1000 | CAPTAIN MORGAN SPICED RUM 70O | 17.08 | 17.08 | 17.08
2957 | 3 | 1000 | MALIBU RUM 42O | 50.28 | 16.76 | 16.76
2973 | 1 | 1000 | MYERS DARK RUM 80O | 20.57 | 20.57 | 20.57
3340 | 1 | 750 | MACALLAN 12 YR 86O | 42.56 | 42.56 | 42.56
3497 | 1 | 750 | DON JULIO TEQUILA ANEJO 80O | 37.49 | 37.49 | 37.49
3498 | 2 | 750 | DON JULIO TEQUILA BLANCO 80O | 63.76 | 31.88 | 31.88
3598 | 1 | 750 | PATRON ANEJO TEQUILA 80O | 43.03 | 43.03 | 43.03
3599 | 9 | 750 | PATRON SILVER TEQUILA 80O | 334.08 | 37.12 | 37.12
3642 | 346 | 1000 | SAUZA WHITE 80O | 4567.2 | 14.58 | 13.2
3706 | 2 | 1000 | [NAME] | 49.68 | 24.84 | 24.84
3798 | 4 | 1000 | GREY GOOSE VODKA 80O | 125.56 | 31.39 | 31.39
3848 | 11 | 1000 | MONOPOLOWA POTATO VODKA 80O | 116.38 | 10.58 | 10.58
4641 | 82 | 1000 | HIRAM WALKER TRIPLE SEC 48O | 390.32 | 4.76 | 4.76
17448 | 1 | 750 | CORRALEJO REPOSADO TEQUILA | 24.81 | 24.81 | 24.81
17767 | 1 | 1000 | CAZADORES REPOSADO | 28.79 | 28.79 | 28.79
19777 | 22 | 1000 | EL JIMADOR BLANCO TEQUILA 80O | 368.94 | 16.77 | 16.77
20182 | 3 | 1000 | BACARDI EIGHT | 64.77 | 21.59 | 21.59
20320 | 1 | 750 | CORAZON SILVER TEQUILA | 23.09 | 23.09 | 23.09
20467 | 2 | 750 | [NAME] | 46.12 | 23.06 | 23.06
21132 | 5 | 1000 | [NAME] 80O | 159.5 | 31.9 | 31.9
21142 | 3 | 1000 | PATRON CITRONGE ORANGE LIQUEUR (MEXICO) 80O | 63.42 | 21.14 | 21.14
25088 | 8 | 1000 | GRAND MARNIER 80O | 279.52 | 34.94 | 34.94
26014 | 1 | 1000 | X-RATED FUSION LIQUEUR 34O | 27 | 27 | 27
27219 | 1 | 1000 | CAZADORES BLANCO | 25.05 | 25.05 | 25.05
31918 | 1 | 1000 | SAUZA HORNITOS PLATA 80O | 27 | 27 | 27
34425 | 4 | 750 | COINTREAU NOIR 80O | 115.48 | 28.87 | 28.87
39529 | 1 | 1000 | SAUZA BLUE REPOSADO 80O | 16.28 | 16.28 | 16.28
39530 | 1 | 750 | SAUZA BLUE REPOSADO 80O | 13.69 | 13.69 | 13.69
 | 551
 | 0
 | 0
Spreadsheet: 799968d1665419480-cell-value-dependent-on-2-other-cells-metadata-example
Sheet: Deliverables

Document Reference | Title | Existing NG DWG Ref_Rev | WP | WP/DISC | G35 Part B Ref
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title1 | 60110802000006_G | WP02 | ELECTRICAL
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title2 | 60110802000003x2_K | WP05 | INSTRUMENT AND SOFTWARE
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title3 | 60110802000003x2_K | WP01 | CIVIL
Spreadsheet: 836942d1689748689-vba-get-number-of-days-of-hijri-month-in-a-gregorian-month-based-on-input-gregorian-year-book1
Sheet: Sheet1

 | Input Gregorian Year
 | Gregorian Month | Jan |  | Total Days | Feb |  | Total Days | Mar |  | Total Days | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 | Hijri Month | Month Name | Month name |  | Month Name | Month name |  | Month Name | Month name
 | Number of Days | Result Based on input value | Result Based on input value | 31 | Result | Result | 28 | Result | Result | 31
Spreadsheet: john_griffith__15647__05_09_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 420 | 38 | 42
N01-P/C | 430 | 66 | 69
Q01-P/C | 435 | 86 | 90
U01-P/C | 440 | 104 | 107
V01-P/C | 445 | 118 | 122
X01-P/C | 460 | 135 | 139
[NAME]-P/C | 480 | 156 | 161
F02-P/C | 490 | 170 | 177
G02-P/C | 475 | 172 | 180
H02-P/C | 460 | 159 | 166
J02-P/C | 425 | 119 | 125
K02-P/C | 420 | 110 | 120
M02-P/C | 430
U02-P/C | 435
Spreadsheet: 8f59804d-d71e-4beb-9d49-2c4806de210e
Sheet: Sheet1

Ergebnisübersicht IDM im [NAME] in Rostock Tag 2 - 24.06.2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
WK 3 2,5 km Jugend männlich
Rg | Name | [NAME] | Zeit
1 | [NAME] | [NAME] | 00:30:31.62
2 | [NAME] | [NAME] | 00:30:32.00
3 | [NAME] | [NAME] | 00:30:36.13
WK 4 2,5 km Jugend weiblich
Rg | Name | [NAME] | Zeit
1 | Lena-Sophie Bermel | Swim-Team Elmshorn | 00:31:05.23
2 | [NAME] | [NAME] | 00:31:24.85
3 | Finnia Wunram | Swim-Team Elmshorn | 00:31:27.35
WK 5 5 km Masters männlich
Rg | Name | [NAME] | Zeit
1 | [NAME] | SSV Offenburg | 01:03:10.13
2 | [NAME] | TSV RW Niebüll | 01:03:14.19
3 | [NAME] | SG Berliner Wasserratten | 01:03:30.73
WK 6 5 km Masters weiblich
Rg | Name | [NAME] | Zeit
1 | [NAME] | Swim-Team Elmshorn | 01:08:28.59
2 | [NAME] | SGR Karlsruhe | 01:12:20.90
3 | [NAME] | [NAME] | 01:12:25.41
Spreadsheet: 178612d1346853644-pre-filling-data-based-on-a-cell-birthdayvoucher
Sheet: Birthday List

Name | [NAME] | Day/Month | Year | Key |  |  | DOB LOOKUP
[NAME] | [EMAIL] | 2012-09-24 00:00:00 | 1988
[NAME] | [EMAIL] | 2012-01-15 00:00:00 | 1985
[NAME] | [EMAIL] | 2012-06-16 00:00:00 | 1980
[NAME] | [EMAIL] | 2012-10-02 00:00:00 | 1982
[NAME] | [EMAIL] | 2012-03-01 00:00:00 | 1976
[NAME] | [NAME] | 2012-07-19 00:00:00 | 1981
[NAME] | [EMAIL] | 2012-09-12 00:00:00 | 1977
[NAME] | [EMAIL] | 2012-11-29 00:00:00 | 1988
Spreadsheet: ca89a933-14b3-4115-ade6-203b88a4f7a4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Convocatòria 2011 |  |  | Imprès 2
FORMULARI DE PRESENTACIÓ DEL PROJECTE I/O SERVEI
ENTITAT SOL·LICITANT:
[NAME] O SERVEI:
1. Identificació de l'entitat sol·licitant
Nom:
CIF: |  | [NAME]: |  | Fax:
Adreça:
Localitat: |  |  | Municipi:
Codi postal: |  | Fax: |  | [NAME]:
Adreça electrònica: |  |  | Web:
Representat legal: |  |  |  | Càrrec:
NIF/NIE: |  |  | [NAME] (i/o mòbil):
Representant del projecte: |  |  |  | Càrrec:
NIF/NIE: |  |  | [NAME] (i/o mòbil):
2. Identificació del projecte i/o servei
Tipus de projecte (en el cas de la convocatòria 0-3 anys també s'hi inclou [NAME]):
 |  |  | [NAME]
Projecte de continuïtat
 |  |  | Activitats
 |  |  | [NAME] d'infraestructures
Projecte nou
 |  |  | Activitats
Àmbits d'intervenció o col·lectius d'atenció:
 |  | Primera infància (0-3 anys)
 |  | Famílies desafavorides
 |  | Situació de risc
 |  | Famílies monoparentals
 |  | Dones joves embarassades i mares i pares joves
 |  | D'altres relacionats amb l'àmbit familiar
Tipus de població atesa ([NAME] principal o majoritari):
Infants
Joves
Adults
Gent gran
Àmbit geogràfic d'intervenció (localitat-illa). [NAME] on s'ubica el servei:
[NAME] població objectiu (edat, sexe i situació de necessitat):
Nombre de beneficiaris directes (és obligatori quantificar-los numèricament):
3. Descripció breu
4. Fonamentació
Necessitats a què respon el projecte:
Antecedents del projecte:
5. Descripció del projecte
Objectius generals:
Objectius específics |  |  | Indicadors de l'objectiu |  |  | % assoliment previst
Activitats |  |  | Indicadors de les activitats |  |  | % assoliment previst
6. [NAME]
7. Temporalització
Data d'inici: |  |  | Data de finalització:
Emplenar l'Annex 1. Cronograma, en aquest full excel.
8. Activitat de difusió (fullets, tríptics…)
9. [NAME] humans
[NAME]. [NAME] humans, en aquest full d'excel.
10. Recursos materials
11. Organització
Organització interna (espais de reunió, grups [NAME], sistema de direcció…):
Coordinació externa (servei i/o entitat):
12. Avaluació
Mecanismes de seguiment, registre i avaluació prevists:
13. Pressupost
Emplenar l'Annex 3. Pressupost, en aquest full d'excel.
Data:
[rúbrica del representant legal de l'entitat sol·licitant, i segell]
Spreadsheet: 186724d1350172842-vlookup-to-return-a-start-date-if-it-falls-between-two-dates-otherwise-leave-blank-sart_12-10-12_sample
Sheet: Secondary Data

School Number | School Name | School Type | Location | Customer Status | Subscription [NAME] | Column1 | Column2 | Renewing Quarter | Sub Start date 12-13 | Renewal date
20
38
59
62
66
68
75
83
91
97
100
108
116
519
Spreadsheet: 26ada591-8e16-45d4-8c44-95266a178826
Sheet: Sheet1

Brock University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Financial and Administrative Services
PETTY CASH FUND AMENDMENT
[NAME]:
Requesting Department:
Please process the following regarding our departmental petty cash:
 | Initial Request for fund | $
 | Increase fund from | $ |  | to | $
 | Decrease fund from | $ |  | to | $
 | Change in Custodian
 | From: |  |  | to
 | Effective
 |  |  | [NAME]/dd/yyyy
 | Delete Fund - current value 1 | $
 | Please explain why the change is required:
Note 1: Before a petty cash fund can be deleted, it must be reconciled and any unspent funds returned to the
 | cashier in the Finance Office along with a journal entry distributing expenses for receipts already paid.
 | Original receipts should be attached to the journal entry in the order listed.
 | CERTIFICATION
 | I acknowledge that I am aware of the Petty Cash Policy and Procedures and maintain the fund in
 | accordance with the policy. The Petty Cash Policy can be found at:
 | http://www.brocku.ca/finance/general-information-financial-services/Policies-and-Procedures
 | PETTY CASH CUSTODIAN
 | Print Name: |  |  | Title:
 | Signature: |  |  | Date:
 |  |  |  |  |  | [NAME]/dd/yyyy
 | IMMEDIATE SUPERVISOR
 | Print Name: |  |  | Title:
 | Signature: |  |  | Date:
 |  |  |  |  |  | [NAME]/dd/yyyy
 | CONTROLLER & MANAGER OF FINANCE
 | Print Name:
 | Signature: |  |  | Date:
 |  |  |  |  |  | [NAME]/dd/yyyy
Spreadsheet: daren_farmer__6642__egmnom-Apr
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-04-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-04-30 00:00:00
RECEIPTS |  |  | Apr
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | AQUILLA
4132 | EXXON KATY | Kn Marketing 92155
6780 | Oasis [NAME] | Tenaska
XXXX | IMBALANCE | ENTEX/HPL
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY | 0
1373 | [NAME] | MORGAN STANLEY | 10000
1485 | OXY BATTLEGROUND | OXY
1511 | Port Arthur - Clark | [NAME] | 0
1505 | DEER PARK | DUPONT | 0
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 0
1394 | HILL PETRO | DYNEGY | 0
8001 | AIR LIQUIDE | AIR LIQUIDE
XXXX | IMBALANCE | ENTEX/HPL
 |  | DELIVERY TOTAL
Spreadsheet: 806884d1669648113-dynamic-array-formula-to-return-nth-occurrence-match-nt-instance
Sheet: Sheet1

Description_1 | Date_1 | Date_2 | 1 | 2 | 3 | 4 | 5 | 6 |  | 8 | 9 | 10
AAAA | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
AAAA | 2022-01-02 00:00:00 | 2022-01-02 00:00:00 |  |  |  |  | AAAA
AAAA | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 |  | BBBB |  |  | AAAA | BBBB
AAAA | 2022-01-04 00:00:00 | 2022-01-03 00:00:00 |  | BBBB |  |  | AAAA | BBBB
BBBB | 2022-03-05 00:00:00 | 2022-01-04 00:00:00 |  | CCCC |  |  | AAAA | CCCC
BBBB | 2022-09-06 00:00:00 | 2022-01-04 00:00:00 |  | CCCC |  |  | AAAA | CCCC
BBBB | 2022-01-03 00:00:00 | 2022-03-05 00:00:00 |  |  |  |  | BBBB
BBBB | 2022-03-08 00:00:00 | 2022-03-08 00:00:00 |  |  |  |  | BBBB
BBBB | 2022-03-09 00:00:00 | 2022-03-09 00:00:00 |  |  |  |  | BBBB
CCCC | 2022-09-03 00:00:00 | 2022-06-08 00:00:00 |  |  |  |  | CCCC
CCCC | 2022-01-04 00:00:00 | 2022-06-09 00:00:00 |  |  |  |  | CCCC
CCCC | 2022-06-08 00:00:00 | 2022-06-10 00:00:00 |  |  |  |  | CCCC
CCCC | 2022-06-09 00:00:00 | 2022-06-11 00:00:00 |  | DDDD |  |  | CCCC | DDDD
CCCC | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 |  | DDDD |  |  | CCCC | DDDD
CCCC | 2022-06-11 00:00:00 | 2022-09-03 00:00:00 |  | DDDD |  |  | CCCC | DDDD
DDDD | 2022-09-03 00:00:00 | 2022-09-03 00:00:00 |  | DDDD |  |  | CCCC | DDDD
DDDD | 2022-06-11 00:00:00 | 2022-09-05 00:00:00 |  |  |  |  | DDDD
DDDD | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 |  | DDDD |  |  | BBBB | DDDD
DDDD | 2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | DDDD |  |  | BBBB | DDDD
DDDD | 2022-09-07 00:00:00 | 2022-09-07 00:00:00 |  |  |  |  | DDDD
DDDD | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 |  |  |  |  | DDDD
Spreadsheet: 89597d1289385251-picking-a-value-out-of-a-range-book1
Sheet: data

day | User | Department | In_Out | IE | Calls
01/11/10 | [NAME] | Support Level II | Outgoing | External | 1
01/11/10 | [NAME] | Support Level II (shift) | Incomming | External | 1
01/11/10 | [NAME] | Support Level II (shift) | Outgoing | External | 1
01/11/10 | [NAME] | Support Level II | Outgoing | External | 1
01/11/10 | [NAME] neale | Service Desk | Incomming | External | 10
01/11/10 | Bharat Sisodiya | Support Level II | Incomming | External | 1
01/11/10 | [NAME] | Support Level I | Outgoing | External | 1
01/11/10 | [NAME] | Support Level II | Outgoing | External | 12
01/11/10 | [NAME] | Support Level II | Incomming | External | 1
01/11/10 | [NAME] | Support Level II | Outgoing | External | 6
01/11/10 | [NAME] | Support Level I | Outgoing | External | 1
01/11/10 | davion simmonds | Support Level II | Outgoing | External | 5
01/11/10 | dion hura | Support Level II (shift) | Incomming | External | 5
01/11/10 | dion hura | Support Level II (shift) | Outgoing | External | 3
01/11/10 | [NAME] | Support Level II (shift) | Incomming | External | 1
01/11/10 | [NAME] | Support Level II (shift) | Outgoing | External | 1
01/11/10 | [NAME] | Support Level I | Outgoing | External | 1
01/11/10 | gurpreet ahluwalia | Support Level I (shift) | Incomming | External | 2
01/11/10 | hardeep [NAME] | Support Level II | Outgoing | External | 1
01/11/10 | irene ash | Service Desk | Incomming | External | 3
Spreadsheet: 740486d1626356511-multiple-dates-entries-in-a-gantt-chart-in-a-single-row-scheduler-3a-with-new-tab-1-ans
Sheet: Leave Tracker

 |  |  |  |  |  |  | 1
 | Select Month |  |  | Select Month
EMP ID | EMP Name
1001 | [NAME]
1002 | Georgia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LWP | Leave without pay
1003 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL | Sick leave
1004 | Sook |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CL | Casual leave
1005 | Charlotte |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ML | Maternity leave
1006 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OL | Other leave
1007 | Franziska
1008 | Emer
1009 | [NAME]
1010 | Evie
1011 | Puja
1012 | [NAME]
1013 | [NAME]
1014 | [NAME]
1015 | Jordan
1016 | Takao
1017 | [NAME]
Spreadsheet: 45182d1243955824-insert-date-automatic-calculate-seroleh-6
Sheet: Sheet1

 |  | Change (station) | Station | 1 IN | 1 OUT | Station | 2 IN | 2 OUT | Station | 3 IN | 3 OUT | Station | 4 IN | 4 OUT
 |  |  | a | 1985-05-03 00:00:00 | 1995-03-31 00:00:00 | d | 1995-04-01 00:00:00 | 1999-05-03 00:00:00 | b | 1999-05-04 00:00:00 | 2007-03-31 00:00:00 | c | 2007-04-01 00:00:00
 |  |  | b | 1995-01-07 00:00:00 | 2001-07-12 00:00:00 | c | 2001-07-13 00:00:00 | 2007-01-07 00:00:00 | a | 2007-01-08 00:00:00
 |  |  | c | 1989-03-18 00:00:00 | 1999-06-12 00:00:00 | b | 1999-06-13 00:00:00 | 2006-03-18 00:00:00 | d | 2006-03-19 00:00:00
 |  |  | d | 1993-01-09 00:00:00 | 2003-06-20 00:00:00 | a | 2003-06-21 00:00:00 | 2008-01-09 00:00:00 | b | 2008-01-10 00:00:00 | 2009-01-20 00:00:00 | d | 2009-01-21 00:00:00 | 1900-01-03 00:00:00
Spreadsheet: 62561d1263482306-filtering-data-excel-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 0
Data |  |  |  |  | Filtered Data |  |  |  | Unique Names |  |  | Filtered Criteria
Case No | Adjusted Case Name | Owner name | Amount |  | Owner name | Adjusted Case Name | Amount |  | Adjusted Case Name | Total |  | Amount | Amount
171398 | Dianthus | Harriet | 2544442065 |  | Harriet | Dianthus | 2544442065 |  | Dianthus | 4905466161 |  | >50000000 | <[PHONE]
169583 | Dianthus | [NAME] | 1814014469.52 |  | [NAME] | Dianthus | 1814014469.52 |  | Dianthus | 5409836366.650001
169583 | Dianthus | Becky | 1539032278.04 |  | Becky | Dianthus | 1539032278.04 |  | Lily | 207829329.49
169615 | Dianthus | Becky | 1285979834.24 |  | Becky | Dianthus | 1285979834.24 |  | Hyacinth | 41532639.51
171398 | Dianthus | Yvette | 1078571393 |  | Yvette | Dianthus | 1078571393 |  | Jasmine | 34227480.98
171398 | Dianthus | Yvette | 889807703 |  | Yvette | Dianthus | 889807703 |  | Mantle | 33330989.43
171398 | Dianthus | Yvette | 315000000 |  | Yvette | Dianthus | 315000000 |  | Bellflower | 22317836.12
169590 | Dianthus | Yvette | 271700032 |  | Yvette | Dianthus | 271700032 |  | Celandine | 21549431.09
171160 | Lily | Harriet | 187000000 |  | Harriet | Lily | 187000000
171216 | Dianthus | Harriet | 161296240.22 |  | Harriet | Dianthus | 161296240.22
171216 | Dianthus | George | 74682158.51 |  | George | Dianthus | 74682158.51
171216 | Dianthus | George | 60698084.36 |  | George | Dianthus | 60698084.36
169591 | Dianthus | Yvette | 50335102.53 |  | Yvette | Dianthus | 50335102.53
171398 | Dianthus | Yvette | 48675000
169615 | Dianthus | Harriet | 44763923.58
164663 | Hyacinth | George | 41532639.51
164620 | Jasmine | George | 34227480.98
171217 | Dianthus | Harriet | 33687228.42
43998 | Mantle | George | 33330989.43
169564 | Dianthus | Harriet | 30508319.96
171485 | Dianthus | Yvette | 28970000
169583 | Dianthus | Harriet | 22873394.26
166109 | Bellflower | George | 22317836.12
169601 | Celandine | Harriet | 21549431.09
171160 | Lily | Ricky | 20829329.49
169588 | Dianthus | Harriet | 20265301.01
Spreadsheet: 127246d1320252154-pivot-table-report-help-test-2-ccm-reporting-sumproduct
Sheet: pivottable

Reporting Quarter | (All)
 | Column Labels
 | A |  | Total CCM target | Total total
Row Labels | CCM target | total
P 1 | 5 | 5 | 5 | 5
P 2 | 1 | 1 | 1 | 1
P 3 | 1 | 1 | 1 | 1