tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 154013d1336149392-help-referencing-another-cell-using-a-formula-excel-project
Sheet: Sheet1

Name | Current Salary | Year 1 | Y1 %Change | Year 2 | Y2 %Change | Year 3 | Y3 %Change | 3-Year %Change
Berghardt
Bilger
Bui
Etzel
Fernandez
[NAME]
Kriebel
Lindahl
Raniere
Rohrbach
[NAME]
Swoyer
Yohe
Plesnarski
Shearer
[NAME]
Wambui
Risavy
Crispin-Smith
[NAME]
Speidel
Stauffer
Stoyer
Wills
Total
[NAME]
Step | Bachelor's | Master's | Doctorate |  | [NAME]
1 | 30000 | 33000 | 35000 |  | Year 1 | 0.05
2 | 31000 | 34000 | 36000 |  | Year 2 | 0.04
3 | 32000 | 35000 | 37000 |  | Year 3 | 0.02
4 | 33000 | 36000 | 38000
5 | 37000 | 41000 | 44000
6 | 38000 | 42000 | 45000
7 | 39000 | 43000 | 46000
8 | 40000 | 44000 | 47000
9 | 44000 | 48400 | 51700
10 | 45000 | 49400 | 52700
Spreadsheet: 140820d1328898971-vlookup-help-example
Sheet: Sheet1

169659510 | TWISTER
169659510 | TWISTER
169649510 | TWISTER HOOPLA
169649510 | TWISTER HOOPLA
169649510 | TWISTER HOOPLA
169649510 | TWISTER HOOPLA
169649510 | TWISTER HOOPLA
169649510 | TWISTER HOOPLA
169650000 | TWISTER [NAME]
169650000 | TWISTER [NAME]
169650000 | TWISTER [NAME]
974981410 | #N/A
975061410 | #N/A
974981410 | #N/A
975061410 | #N/A
974961410 | #N/A
974951410 | #N/A
974981410 | #N/A
975061410 | #N/A
605040000 | #N/A
894710000 | #N/A
206090001 | #N/A
206100001 | #N/A
206110001 | #N/A
206120001 | #N/A
206550000 | #N/A
206072840 | #N/A
975221410 | #N/A
914060000 | #N/A
Spreadsheet: 753869d1635792827-vlookup-xlookup-with-2-conditions-sample
Sheet: Sheet2

Catalogo | CODIGO | [NAME] | Piezas
21594-17241 | TRLI | Línea de Entrenamiento | 1000
21594-17241 | 125A | 125A | 800
21594-17241 | 32IN | 32IN | 900
24107-12140 | SURF | SURF | 2000
24107-12140 | SEMI | SEMI | 1200
24107-12140 | OBCT | BTC | 3492
Spreadsheet: 485432d1476882066-need-to-call-upon-workbook-and-sheetname-from-cell-excelforumindirectyr2016
Sheet: Yr2016

Year | 2016
Month |  | store 1 | store 2 | store 3 | store 4 | store 5
jan
feb
[NAME]
apr
may
jun
jul
aug
sep
oct
nov
dec
Reference: |  | http://www.excelforum.com/excel-general/1159932-need-to-call-upon-workbook-and-sheetname-from-cell.html
Reference for Indirect: |  | http://www.contextures.com/xlFunctions05.html
See the section 'Create a Reference To a Different Workbook '
Spreadsheet: 176878d1346134398-conditional-formatting-gray-out-planning-bars-conditionalformattingplanningbars
Sheet: Tabelle1

1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
1 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 1
1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Goal: draw planning bars of a given length (col W) with conditional formatting
Spreadsheet: 703649d1605100507-lost-in-vlookup-offset-index-etc-example-2-
Sheet: CALC

Room no. | A0001
Area
Height
Volume
Heat load |  | 101
Cooling load |  |  | 202
Room no. | A0002
Area
Height
Volume
Heat load |  | 200
Cooling load |  |  | 400
Room no. | A0003
Area
Height
Volume
Heat load |  | 200
Cooling load |  |  | 400
Room no. | A0004
Area
Height
Volume
Heat load |  | 200
Cooling load |  |  | 400
Spreadsheet: 81283f12-601c-4953-b818-480fbc8a7c99
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Výsledky volieb na post poslancov  podľa počtu hlasov
[NAME] | Meno | číslo na HL | Názov pol. strany - nezávislý kandidát | Poč.hlasov
Baráti, Ing. | Tomáš | 3 | MOST-HÍD | 1027
Lőwy, Ing. | Ján | 30 | MOST-HÍD | 974
Hammersmidt, [NAME]. | Vojtech | 13 | SDKÚ-DS,KDH,SMER,[NAME] | 934
Zachar, Ing. | Pál | 56 | SMK-MKP | 834
Póczik, MUDr. | Gábor | 45 | SMK-MKP | 791
Hudec, Ing. | Pavel | 16 | SDKÚ-DS,KDH,SMER,[NAME] | 727
Oros | Zoltán | 40 | SMK-MKP | 683
Pálffy, Mgr. | Dezider | 43 | SMK-MKP | 683
Sasváry, MUDr., PhD. | Ferdinand | 47 | [NAME] | 672
[NAME], [NAME]. | Pavol | 50 | [NAME] | 664
Bóna, Mgr. | [NAME] | 6 | SMK-MKP | 653
Kötelesová | [NAME] | 21 | MOST-HÍD | 633
Makovínyi, RNDr. | Pavel | 31 | [NAME] | 592
Gémesi | Zoltán | 9 | MOST-HÍD | 581
Križan | Karol | 23 | SDKÚ-DS,KDH,SMER,[NAME] | 573
Orbán, Ing. | Dezider | 39 | SMK-MKP | 540
Hanuska, Ing. | [NAME] | 14 | SDKÚ-DS,KDH,SMER,[NAME] | 532
Gašparík, Ing. | [NAME] | 8 | MOST-HÍD | 518
Murín | Vojtech | 36 | MOST-HÍD | 517
Pénz, Ing. | [NAME] | 44 | SMK-MKP | 513
[NAME] | [NAME] | 2 | SMK-MKP | 510
[NAME]. | [NAME] | 10 | SaS | 498
Kázmér, [NAME]. | František | 19 | SDKÚ-DS,KDH,SMER,[NAME] | 485
Mezőszállási | [NAME] | 33 | MOST-HÍD | 465
Hajdú | Ondrej | 11 | SDKÚ-DS,KDH,SMER,[NAME] | 461
Moys, Mgr. | [NAME] | 35 | SMK-MKP | 448
Bodonyi | Ondrej | 5 | MOST-HÍD | 443
[NAME] , [NAME]. | [NAME] | 51 | SDKÚ-DS,KDH,SMER,[NAME] | 440
Kapa | [NAME] | 18 | SMK-MKP | 429
Kolevová, PaedDr., PhD. | Adriena | 20 | [NAME] | 413
Príbus, Ing. | [NAME] | 46 | SDKÚ-DS,KDH,SMER,[NAME] | 410
Kútnik, Mgr. | Ján | 25 | SDKÚ-DS,KDH,SMER,[NAME] | 407
Zolcerová, Ing. | Mária | 57 | SDKÚ-DS,KDH,SMER,[NAME] | 405
Bélik | György | 4 | [NAME] | 396
Lendvay | Tibor | 28 | MOST-HÍD | 394
Lóšková, Bc. | Monika | 29 | SDKÚ-DS,KDH,SMER,[NAME] | 391
Sógel | Ján | 49 | MOST-HÍD | 367
Kutaková | Adriena | 24 | [NAME] | 361
Vanek | [NAME] | 54 | SMK-MKP | 334
Latkóczy, Ing. | Adrián | 27 | MOST-HÍD | 326
Melicherová, Ing. | [NAME] | 32 | SMK-MKP | 319
Szőllősy | [NAME] | 52 | [NAME] | 291
[NAME] | Patrik | 12 | [NAME] | 253
Olczár, [NAME]. | [NAME] | 38 | OKS | 226
Hudák | Ondrej | 15 | SaS | 225
[NAME] | Ján | 1 | [NAME] | 220
Králik | František | 22 | MOST-HÍD | 214
Vida, Ing. | [NAME] | 55 | [NAME] | 190
Nagy | Imrich | 37 | SDĽ | 189
Lacko | [NAME] | 26 | [NAME] | 186
Ostrolucký | Erzsébet | 41 | SaS | 185
Kajtor, Ing. | Pavel | 17 | [NAME] | 159
Ostrolucký, Bc. | [NAME] | 42 | SaS | 133
Čákyová | Valéria | 7 | SNS | 114
[NAME] | Ľudovít | 48 | ZRS | 106
Močárová | Mária | 34 | SNS | 84
[NAME], Mgr. | [NAME] | 53 | SNS | 76
Výsledky volieb na post primátora podľa počtu hlasov
[NAME] | Číslo na HL |  |  | Poč.hlasov
Ján Lőwy, Ing. | 1 |  |  | 1469
[NAME], Ing | 2 |  |  | 1370
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 84

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
Spreadsheet: 525829d1498939130-conditional-formatting-future-dates-on-cell-tobe-formatted-conditionalformat130
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 843447d1695284921-sorting-overtime-hours-to-day-and-night-test_ot_night-day
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Shift length |  |  | Night start | Night end
 |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  | 22:00:00 | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  | problematic ones
 |  | # test | Start of the work | End of the work |  |  |  | Start of the work ([NAME]) | End of the work ([NAME]) | Total hours worked | Overtime total | Day overtime | Night overtime | Night hours worked | testing if ok |  | Expected results
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day OT | Night OT | Total OT | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  | 1. | 13:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 1.1. | 15:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 1.2. | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | 2. | 15:00:00 | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 2.1. | 13:00:00 | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | 3. | 19:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7 | 8 | 9 | 10 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  | 3.5 | 21:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
 |  | 4. | 23:00:00 | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 4.5 | 22:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  | 5. | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 5.5 | 21:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  | 6. | 02:00:00 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | 6.5 | 02:00:00 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 7. | 08:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | 7.1 | 06:00:00 | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  |  |  |  |  |  | K68 | [NAME] | M68
 |  |  |  |  |  |  |  |  |  | 1000.34 | 999.33 | 1.01
Spreadsheet: mary_fischer__25633__31P
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 51258d1250790849-excel-2007-if-and-true-false-and-two-criteria-ifandhelp
Sheet: Data2

Name | Finished
[NAME] | 1965-12-25 00:00:00
[NAME] | 1966-02-03 00:00:00
[NAME] | 1968-12-09 00:00:00
[NAME] | 1969-01-27 00:00:00
[NAME] | 1970-12-01 00:00:00
[NAME] | 1970-12-01 00:00:00
[NAME] | 1971-01-09 00:00:00
[NAME] | 1971-12-01 00:00:00
[NAME] | 1971-12-25 00:00:00
[NAME] | 1972-12-03 00:00:00
[NAME] | 1972-12-08 00:00:00
[NAME] | 1973-01-03 00:00:00
[NAME] | 1973-12-04 00:00:00
[NAME] | 1973-12-08 00:00:00
[NAME] | 1974-12-01 00:00:00
[NAME] | 1974-12-12 00:00:00
[NAME] | 1976-01-16 00:00:00
[NAME] | 1977-12-08 00:00:00
[NAME] | 1980-01-27 00:00:00
[NAME] | 1983-12-04 00:00:00
[NAME] | 1983-12-25 00:00:00
[NAME] | 1984-12-12 00:00:00
[NAME] | 1985-07-01 00:00:00
[NAME] | 1985-12-01 00:00:00
[NAME] | 1987-10-01 00:00:00
[NAME] | 1994-02-12 00:00:00
[NAME] | 1999-02-04 00:00:00
[NAME] | 1999-06-04 00:00:00
[NAME] | 2001-01-12 00:00:00
[NAME] | 2001-02-04 00:00:00
[NAME] | 2002-05-31 00:00:00
[NAME] | 2003-12-25 00:00:00
[NAME] | 2004-04-04 00:00:00
[NAME] | 2004-07-03 00:00:00
[NAME] | 2004-12-01 00:00:00
[NAME] | 2007-02-28 00:00:00
[NAME] | 2007-11-01 00:00:00
Spreadsheet: 217436d1362068050-complex-sorting-music-new
Sheet: Genres

 | [NAME] | Artists | Albums | Tracks | Total Time | Release Year
 | Alternative | 2 | 5 | 103 | 06:31:50 | 3605
 | Christian | 2 | 10 | 142 | 09:38:46 | 2001.1
 | [NAME]
 | Comedy
 | Country
 | Grunge
 | New Age
 | Oldies
 | Pop
 | Rock
 | Soundtrack
 | Total | 4 | 15 | 245 | 16:10:36 | 2535.733333333333
 |  | Eat Shit | Yes | Eat Shit | Eat Shit
Spreadsheet: 161167d1339434465-time-tracking-excluding-nonworking-hours-vsm-correction-tracking
Sheet: AC

Assembled Components
Date | # of Lots through QC | Lot Number | Date/Time Discovered | Date/Time Resolved | Time to Resolve | Type of errors
2012-06-07 00:00:00 | 4 |  |  |  | 1900-01-01 00:00:00
2012-06-08 00:00:00 | 5 |  |  |  | 1900-01-01 00:00:00
2012-06-11 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-12 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-13 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-14 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-15 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-16 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-17 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-18 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-19 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-20 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-21 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-22 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-23 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-24 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-25 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-26 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-27 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-28 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-29 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-30 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
Spreadsheet: 231433d1367061350-parsing-reordering-data-for-easy-duplicate-finding-book1
Sheet: Sheet1

What I Have |  |  |  | What I Need
Department | Permission Name | Value |  |  | Dept. A | Dept. B | Dept. C
Dept. A | Create | Y |  | Create | Y | N | Y
Dept. A | View | Y |  | View | Y | N | Y
Dept. A | Edit | N |  | Edit | N | Y | N
Dept. A | Delete | Y |  | Delete | Y | Y | Y
Dept. B | Create | N
Dept. B | View | N |  | ...So I Can Get This...
Dept. B | Edit | Y |  |  | Dept. A | Dept. B | Dept. C
Dept. B | Delete | Y |  | Create | Y | N | Y
Dept. C | Create | Y |  | View | Y | N | Y
Dept. C | View | Y |  | Edit | N | Y | N
Dept. C | Edit | N |  | Delete | Y | Y | Y
Dept. C | Delete | Y |  |  | "=F10&F11&F12&F13" | "=G10&G11&G12&G13 | "=[NAME]
 |  |  |  |  | YYNY | NNYY | YYNY
 |  |  |  | ...In Order to Find Duplicates
 |  |  |  |  | Dept. A | Dept. B | Dept. C
 |  |  |  | Create | Y | N | Y
 |  |  |  | View | Y | N | Y
 |  |  |  | Edit | N | Y | N
 |  |  |  | Delete | Y | Y | Y
Spreadsheet: 861964d1709776085-sumif-function-with-multiple-criteria-from-a-data-list-to-get-orders-and-returns-sumif-function-with-multiple-criteria-from-a-data-list-to-get-orders-and-returns-mohamedgadal
Sheet: Data

Serial number |  |  | Type |  |  | Delivery quantity |  |  | Customer # |  |  |  |  |  |  |  |  |  |  |  | Created on |  |  |  |  |  |  |  |  | required results | customer # | Start Date | Order | Return
1 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2022 |  |  |  |  |  |  |  |  |  | 674700 | 10/1/2023 | 6 | 4
0 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2022
1 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023 |  |  |  |  |  |  |  |  | formula result | customer # | Start Date | Order | Return
2 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023 |  |  |  |  |  |  |  |  |  | 674700 | 10/1/2023
3 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
4 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
3 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
5 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
6 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
2 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
7 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
0 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
5 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
6 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
Spreadsheet: 66010d1266622095-conditional-formatting-golfleague-5
Sheet: Sheet1

Player | Quota | Week 3 | Quota | Week 4 | Quota | Week 5 | Quota | Week 6 | Quota | Week 7 | Quota | Week 8 | Quota | Week 9 | Quota | Week 10 | Quota | Week 11 | Quota | Week 12 | Quota | Week 13 | Quota | Week 14 | Quota | Week 15 | Quota | Week 16 | Quota | Week 17 | Quota | Week 18 | Quota
Crank | 22 | 24 | 23 | 23 | 23 | 22 | 23 | 24 | 23 | 16 | 20 | 19 | 20 | 19 | 20 | 19 | 20 | 21 | 20 | 22 | 21
Sweet | 22 | 12 | 17 | 17 | 17 | 17 | 17 | 19 | 18 | 18 | 18 | 18 | 18 | 21 | 19 | 23 | 21 | 26 | 23 | 14 | 19
Kelly | 21 | 16 | 19 | 22 | 20 | 16 | 18 | 16 | 17 | 15 | 16 | 7 | 12 | 12 | 12 | 23 | 17 | 19 | 18 | 19 | 18
[NAME] | 20 | 13 | 17 | 17 | 17 | 18 | 17 | 22 | 19 | 17 | 18 | 18 | 18 | 19 | 18 | 24 | 21 | 21 | 21 | 21 | 21
T. Hennecke | 19 | 17 | 18 | 20 | 19 | 19 | 19 | 12 | 16 | 17 | 16 | 18 | 17 | 13 | 15 | 15 | 15 | 15 | 15 | 17 | 16
Scherbarth | 19 | 15 | 17 | 14 | 16 | 14 | 15 | 20 | 17 | 17 | 17 | 18 | 17 | 15 | 16 | 17 | 16 | 15 | 16 | 14 | 15
Jambois | 19 | 17 | 18 | 18 | 18 | 21 | 19 | 24 | 21 | 19 | 20 | 24 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
Fahl | 18 | 18 | 18 | 17 | 18 | 16 | 17 | 17 | 17 | 21 | 19 | 17 | 18 | 17 | 18 | 19 | 18 | 23 | 20 | 18 | 19
March | 18 | 17 | 18 | 17 | 18 | 17 | 18 | 19 | 18 | 19 | 18 | 14 | 16 | 17 | 16 | 18 | 17 | 18 | 17 | 23 | 20 | 9 | 15
Kaufmann | 18 | 16 | 17 | 20 | 18 | 16 | 17 | 19 | 18 | 15 | 17 | 14 | 16 | 20 | 18 | 20 | 19 | 19 | 19 | 20 | 19
Shaw | 17 | 17 | 17 | 19 | 18 | 13 | 16 | 13 | 15 | 11 | 13 | 13 | 13 | 19 | 16 | 12 | 14 | 15 | 14 | 19 | 16
Ga. Schroeder | 17 | 18 | 17 | 18 | 17 | 17 | 17 | 20 | 18 | 20 | 19 | 17 | 18 | 20 | 19 | 19 | 19 | 17 | 18 | 18 | 18
Gr. Schroeder | 17 | 17 | 17 | 18 | 17 | 15 | 16 | 16 | 16 | 16 | 16 | 10 | 13 | 13 | 13 | 12 | 13 | 18 | 15 | 23 | 19
Kinney | 17 | 17 | 17 | 15 | 16 | 13 | 15 | 18 | 16 | 18 | 17 | 21 | 19 | 12 | 16 | 13 | 15 | 12 | 14 | 14 | 14
[NAME] | 16 | 12 | 14 | 14 | 14 | 14 | 14 | 11 | 13 | 14 | 13 | 21 | 17 | 19 | 18 | 14 | 16 | 11 | 14 | 19 | 16
Wilson | 15 | 9 | 12 | 11 | 12 | 10 | 11 | 10 | 11 | 8 | 10 | 12 | 11 | 8 | 10 | 13 | 11 | 7 | 9 | 13 | 11
Stelter | 15 | 10 | 13 | 12 | 13 | 13 | 13 | 9 | 11 | 7 | 9 | 15 | 12 | 15 | 13 | 16 | 14 | 11 | 13 | 13 | 13
Boney | 13 | 13 | 13 | 18 | 15 | 18 | 16 | 22 | 19 | 14 | 17 | 21 | 19 | 15 | 17 | 26 | 21 | 18 | 20 | 8 | 14
[NAME] | 13 | 10 | 12 | 10 | 11 | 11 | 11 | 12 | 11 | 13 | 12 | 17 | 14 | 15 | 14 | 14 | 14 | 13 | 14 | 15 | 14
Langley | 11 | 10 | 11 | 9 | 10 | 5 | 8 | 10 | 9 | 11 | 10 | 10 | 10 | 10 | 10 | 5 | 8 | 13 | 10 | 12 | 11
Spreadsheet: 28343d1222429611-sumif-with-2-variables-book1
Sheet: Analysis

[NAME] | Class | ene | feb | [NAME] | abr | may | jun | jul | ago | sep | oct | nov | dic
Materiales | m
Material pequeño | h | 0
Herramientas, estanterías | w
Prestaciones ajenas | f
Comisiones | k
Personal, Sueldos, SS, [NAME] | s
[NAME] | g
Alquiler | n
Transporte, [NAME], aparcamiento, bombona, furgoneta, vuelos | t
Oficina, electricidad | o
Comunicación, correo, teléfono, internet | c
Asesoría, Información legal | a
Publicidad, Marketing | p
Seguros | v
[NAME], comisiones creditos, dietas | b
Pagos extraordinarios, préstamos, notaria, marca solartex | x
[NAME] 110,115 | z
Dietas | d
Spreadsheet: 786561d1657269028-return-value-or-address-which-is-not-ok-question
Sheet: Sheet1

[NAME] Y (3155 mm)
Side | MP | Deviation | BL | Deviation | Misalignment
Left | 3151 |  | 3152.9
Right | 3145 |  | 3157.3
 | I would like for Excel to give me the address and/or value which is not OK hence NOK. In this case F4 or 12.3
Spreadsheet: 853336d1703197063-rota-return-data-based-on-3-criteria-from-table-rotatest
Sheet: Rota

Name | Duty | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00
[NAME] | 05:00:00 |  |  | R | R | R | R
Fred | 05:00:00 | R |  |  |  |  |  | R
[NAME] | 07:00:00 | r | r | r
[NAME] | 08:00:00 |  |  |  | R | R | R | R
[NAME] | 08:00:00 | R | R | R | R
[NAME] | 10:00:00 |  |  |  |  | r | r | r
Marge | 10:00:00 | r | r | r | r
 |  | 2024-01-28 00:00:00
 | 05:00:00 | [NAME] | [NAME] |  |  |  | [NAME]
 | 05:00:00 |  | Fred | Fred | Fred | Fred
 | 07:00:00 |  |  |  | [NAME] | [NAME] | [NAME]
 | 08:00:00 | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME]
 | 10:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | Marge | Marge
Spreadsheet: 831941d1686013487-order-sheet-for-supplies-for-my-special-education-class-pq-supplies-aligw
Sheet: Totals

 | Order Information
 | Class | Total Supplies Ordered | Total Cost
 | AR
 | PLP1
 | [NAME]
 | PLP3
 | SSP1
 | SSP1
 | [NAME]