tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689110d1596128709-request-formula-for-multiple-criteria-matrix-lookups-query58
Sheet: Query58

 |  |  |  |  | Index & Match (or) Multiple [NAME] to apply for |  |  | Age |  | Category
Name | Category | Age | Value | Amount | Index & Match: Col E with Col I, Age between (Col C should be between Col J and Col K), then pickup Category (if B, then, pickup from Col M (OR) if C, then pickup Col N |  | Value | Age From | Age To | A | B | C
Name01 | A | 62 | 500000 | 17000 | [NAME] output for this is: 17000 (pick [NAME]) |  | 500000 | 18 | 25 | 5200 | 1475
Name02 | B | 55 | 500000 | 3550 | For this is: 3550 (pick L7) |  | 500000 | 26 | 30 | 6500 | 1600
Name03 | B | 27 | 500000 | 1600 | For this is: 1600 (pick L4) |  | 500000 | 31 | 35 | 10000 | 1600
Name04 | A | 58 | 300000 | 9950 |  |  | 500000 | 36 | 45 | 10000 | 1600
[NAME] | A | 40 | 300000 | 8312 |  |  | 500000 | 46 | 55 | 14000 | 3550
Name06 | C | 69 | 300000 | 9000 |  |  | 500000 | 56 | 60 | 17000 | 3775
Name07 | C | 64 | 300000 | 9000 |  |  | 500000 | 61 | 70 | 17000 | 5730 | 10000
Name08 | A | 49 | 500000 | 17000 |  |  | 500000 | 71 | 90 |  |  | 13000
Name09 | B | 43 | 500000 | 1600 |  |  | 300000 | 18 | 25 | 7848 | 1955
Name10 | B | 10 | 500000 | 1475 |  |  | 300000 | 26 | 30 | 7848 | 1955
Name11 | B | 16 | 500000 | 1475 |  |  | 300000 | 31 | 35 | 7848 | 1955
Name12 | C | 88 | 500000 | 16000 |  |  | 300000 | 36 | 45 | 8312 | 2048 | 4200
Name13 | A | 51 | 300000 | 9950 |  |  | 300000 | 46 | 55 | 9950 | 2250 | 5000
Name14 | B | 36 | 300000 | 1955 |  |  | 300000 | 56 | 60 | 9950 | 2880 | 6500
Name15 | A | 34 | 500000 | 10000 |  |  | 300000 | 61 | 70 | 12000 | 3940 | 9000
[NAME] | B | 25 | 500000 | 1475 |  |  | 300000 | 71 | 90 |  |  | 12000
Name17 | B | 0 | 500000 | 1475 |  |  | 200000 | 18 | 25 | 4413
Name18 | C | 68 | 500000 | 10000 |  |  | 200000 | 26 | 30 | 4413
Name19 | C | 63 | 500000 | 10000 |  |  | 200000 | 31 | 35 | 4413
[NAME] | A | 42 | 300000 | 8312 |  |  | 200000 | 36 | 45 |  |  | 1000
Name21 | B | 45 | 300000 | 2048 |  |  | 200000 | 46 | 55 |  |  | 1900
Name22 | B | 12 | 300000 | 1955 |  |  | 200000 | 56 | 60 |  |  | 1688
Name23 | B | 7 | 300000 | 1955 |  |  | 200000 | 61 | 70 |  |  | 2530
Name24 | C | 72 | 300000 | 12000 |  |  | 200000 | 71 | 90 |  |  | 9963
Name25 | C | 61 | 300000 | 9000
Name26 | A | 26 | 300000 | 7848
Spreadsheet: 829406d1684201984-power-query-custom-column-populating-using-worksheet-names-database
Sheet: ARIZONA

 | OHIO
 | Customer # | Time & Purchase Date | Name | Gender | DOB | Units | Price per Unit ($) | Total Price ($)
 | 1 | 1151|16 Aug 2013 | [NAME] | Male | 1988-05-12 00:00:00 | 50 | 1 | 50
 | 2 | 1119|27 Nov 2002 | [NAME] | Male | 1999-05-13 00:00:00 | 79.0357142857143 | 1.05 | 30.08
 | 3 | 1758|18 Nov 2014 | [NAME] | Male | 1992-05-19 00:00:00 | 78.7857142857143 | 1.02 | 35.839
 | 4 | 1634|8 Oct 2005 | Jackson Reed | Male | 1988-05-12 00:00:00 | 46.6 | 1.137 | 55.591
 | 5 | 2134|8 Oct 2019 | [NAME] | Male | 1999-05-13 00:00:00 | 51.4 | 1.122 | 59.454
 | 6 | 1527|20 Sep 2015 | [NAME] | Male | 1999-05-13 00:00:00 | 56.2 | 1.107 | 63.317
 | 7 | 1756|14 Sep 2013 | Jackson Reed | Male | 1992-05-19 00:00:00 | 61 | 1.092 | 67.18
 | 8 | 1122|18 Jan 2009 | [NAME] | Male | 1988-05-12 00:00:00 | 65.8 | 1.077 | 71.043
 | 9 | 1222|13 July 2008 | [NAME] | Male | 1999-05-13 00:00:00 | 71 | 1.11 | 78.81
 | 10 | 2122|28 Apr 2023 | Jackson Reed | Male | 2000-05-13 00:00:00 | 75 | 1.01 | 75.75
 | 11 | 1542|19 July 2000 | [NAME] | Male | 2000-05-14 00:00:00 | 80 | 0.98 | 78.4
 | 12 | 1603|6 Oct 2008 | [NAME] | Male | 2000-05-15 00:00:00 | 85 | 1.04 | 88.4
 | 13 | 1213|10 Oct 2019 | [NAME] | Male | 1989-05-16 00:00:00 | 90 | 1.02 | 91.8
Spreadsheet: 781873d1653595860-sum-values-depending-on-several-criteria-text-and-number-criteria-test
Sheet: 538_rekapitulacija

[NAME]
Šumarija:____Ogulin__________________
Gospodarska jedinica:__Zagorska kosa___
 |  |  |  |  |  |  | T-2
[NAME] prihoda | [NAME] drveća |  | Tarifa | Površina (ha)
 |  |  |  |  | Etat | Do [NAME]
Glavni redovni | 10 |  |  |  |  |  | 7018
 | 19 |  |  |  |  |  | 637
 | 39 |  |  |  |  |  | 53
 | 60 |  |  |  |  |  | 7136
 | 61 |  |  |  |  |  | 44
 | 62 |  |  |  |  |  | 21
 |  | Ukupno:
Glavni slučajni | 60 |  |  |  |  |  | 250
 |  | Ukupno:
Ukupno glavni prihod | 10
 | 19
 | 39
 | 60
 | 61
 | 62
 |  | Sveukupno:
Prethodni redovni
 |  |  |  |  |  | Revirnik:____________________________________
 |  | Ukupno:
Glavni i prethodni prihod | 10
 | 19
 | 39
 | 60
 | 61
 | 62
 |  | Sveukupno:
Datum: |  |  |  |  |  |  | Revirnik:
Spreadsheet: 96176d1295593575-show-data-in-sequence-row-groupautolist
Sheet: Sheet1

A | GROUP1
B | [NAME]
C | GROUP3
D | GROUP3
F | GROUP3
G | GROUP3
H | [NAME]
I | [NAME]
J | [NAME]
K | [NAME]
L | [NAME]
M | GROUP1
N | GROUP1
Spreadsheet: 51250d1250782138-points-formatting-book1
Sheet: Sheet1

Player Name | WK 1 | WK2 | WK3 | WK4
[NAME] | 1 | 22 | 10 | 11
[NAME] | 2 | 21 | 9 | 12
[NAME] | 3 | 20 | 8 | 13
[NAME] | 4 | 19 | 7 | 14
Retief Goosen | 5 | 18 | 6 | 15
[NAME] | 6 | 17 | 5 | 16
[NAME] | 7 | 16 | 4 | 17
[NAME] | 8 | 15 | 3 | 18
[NAME] | 9 | 14 | 2 | 19
[NAME] | 10 | 13 | 1 | 20
[NAME] | 11 | 12 | 11 | 1
[NAME] Poulter | 12 | 11 | 12 | 2
[NAME] | 13 | 10 | 13 | 3
[NAME] | 14 | 9 | 14 | 4
[NAME] | 15 | 8 | 15 | 5
[NAME] | 16 | 7 | 16 | 6
[NAME] | 17 | 6 | 17 | 7
[NAME] | 18 | 5 | 18 | 8
[NAME] | 19 | 4 | 19 | 9
[NAME] | 20 | 3 | 20 | 10
[NAME] | 21 | 2 | 21 | 22
[NAME] | 22 | 1 | 22 | 21
Spreadsheet: 143364d1330381793-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (24) WWTP

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | WWTP
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
1 | emergency light out | [NAME] | carryover
2 | spindle needs guarding on pump | pump room | complete
3
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Overall housekeeping was okay
ESCORT:
Spreadsheet: 07ef32ac-c140-4a30-8e8b-7de7442b6ef6
Sheet: Table 3.3

Monthly Statistical Bulletin
3.3  Wages and profits share
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Wages share (a) (b) – per cent
September | 53.1 | 52.2 | 52.1 | 54 | 53.7
December | 52.5 | 52.1 | 52.4 | 54.3 | 53.2
March | 52.5 | 52.9 | 53.7 | 54 | 53
June | 51.9 | 52.3 | 54 | 53.7 | 53.5
Annual average | 52.53102365655455 | 52.41680044613256 | 53.02459296663554 | 54.02708497418395 | 53.35861056409094
Profits share (a) (c) – per cent
September | 26.9 | 28.3 | 28.8 | 26.7 | 26.7
December | 27.5 | 28.6 | 28.3 | 26.3 | 27.3
March | 27.3 | 27.4 | 27.3 | 26.5 | 27.4
June | 28.8 | 28.3 | 26.8 | 26.8 | 26.6
Annual average | 27.57540430470889 | 28.15700531158883 | 27.84552498792863 | 26.52394912633821 | 27.00534796781422
(a) Quarterly figures are seasonally adjusted.
(b) Compensation of employees as a proportion of total factor income.
(c) Gross operating surplus of financial and non-financial corporations as a proportion of total factor income.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-12-03 00:00:00
Spreadsheet: 675085d1588155815-excel-formula-counting-time-of-late-excel-test
Sheet: data

 |  |  | punch record | punch record | punch record | punch record | punch record
ID | times of late |  | 2020-04-01 00:00:00 | 2020-04-02 00:00:00 | 2020-04-03 00:00:00 | 2020-04-04 00:00:00 | 2020-04-05 00:00:00
S05 |  |  | 0:35:00 |  | 0:30:00 |  | 0:01:00
 |  |  | 1st late > 30 minutes, will COUNT 1 time of late |  | 1st + 2nd late > 30 minutes, will COUNT 2 times of late |  | 1st + 2nd + 3rd late > 30 minutes, will COUNT 3 times of late
S06 |  |  | 0:00:00 | 0:20:00 | 0:00:00 | 0:30:00 | 0:01:00
 |  |  |  | 1st late < 30 minutes, will NOT count time of late |  | 1st + 2nd late > 30 minutes, will COUNT 1 times of late | 1st + 2nd + 3rd late > 30 minutes, will COUNT 2 times of late
S07 |  |  | 0:00:00 | 0:01:00 | 0:01:00 | 0:01:00 | 0:00:00
 |  |  |  | 1st late < 30 minutes, will NOT count time of late | 1st+2nd late < 30 minutes, will NOT count time of late | 1st+2nd+3rd late < 30 minutes, will NOT count time of late
Spreadsheet: 791443d1660339013-simplify-excel-formula-more-than-64-levels-of-nested-monthly-cost-quotation-variations-on-a-theme-tms
Sheet: JT Sample

 | Complete |  |  | WeekX5 |  |  |  | 1X a week |  |  | 2X a week |  |  | 3X a week |  |  | 4X a week |  |  | 5X a week |  |  | 6X a week
 |  | 8000 |  |  |  |  |  | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete
 |  |  |  | WeekX1 |  |  | 2000
 |  |  |  | WeekX2 |  |  | 2500
 |  |  |  | WeekX3 |  |  | 3000
JT |  |  |  | WeekX4 |  |  | 3500
 |  |  |  | WeekX5 |  |  | 4000
 |  |  |  |  |  |  | 4500
=INDEX(INDIRECT(E7),MATCH(C8,Area,0),MATCH(B7,Type,0)) |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 5500
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | 6500
 |  |  |  |  |  |  | 7000
 |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  | 8000
 |  |  |  |  |  |  | 8500
 |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  | 9500
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 10500
 |  |  |  |  |  |  | 11000
 |  |  |  |  |  |  | 11500
 |  |  |  |  |  |  | 12000
 |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  | 13000
 |  |  |  |  |  |  | 13500
 |  |  |  |  |  |  | 14000
 |  |  |  |  |  |  | 14500
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 16000
 |  |  |  |  |  |  | 16500
 |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  | 18000
 |  |  |  |  |  |  | 18500
 |  |  |  |  |  |  | 19000
 |  |  |  |  |  |  | 19500
 |  |  |  |  |  |  | 20000
Spreadsheet: 21916d1210127057-multiple-variables-in-formula-eval
Sheet: ReadFirst

Staff |  | Charge | Code |  | Types | Includes
AA |  | Charge0 | 0 |  | Type0 | Charge0
BB |  | Charge1 | 1 |  | Type1 | Charge1
CC |  | Charge2 | 2 |  | Type2 | Charge2
DD |  | Charge3 | 3 |  | [NAME] | Charge1, Charge3, Charge4, Charge5
EE |  | Charge4 | 4 |  | Type4 | Charge4
FF |  | Charge5 | 5 |  | Type5 | Charge5
GG
HH
II
JJ
KK
LL
MM
Please read:
Each day staff are assigned a new patient, the number of patients varies per day with the [NAME] usually being 9 patients per day
There are actually more charges that fall into these 6 types, which is why I have the codes, but I thought it was easier to just use 6 for the example
1) In Summary I've tried using COUNTIF but in order to do this I would have to nest (correct term?) several functions to include a full week, isn't there an easier way to do it?
2) I tried naming a range Staffw1 but it didn't work in the formula (see [NAME])
3) Is there a way to name the ranges that would work because that would be much easier to enter then referring to each column?
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 08-Jan-24

Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri | summary
Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
Employee 1 | 23002 - Project 2
Employee 1 | 23003 - Project 3
Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
Employee 1 | 23006 - Project 6
Employee 1 | 23007 - Project 7
Employee 1 | 23008 - Project 8
Employee 1 | 23009 - Project 9
Employee 1 | 23010 - Project 10
Spreadsheet: 812624d1673286604-formula-excel-datas-para-calcular-meses-de-afastamento-forum-excel
Sheet: Planilha1

 |  | Descrição de Centro de Resultado | [NAME] | Data de Afastamento | Data de Retorno | 2022-01-01 00:00:00 | RESPOSTA
 |  | MARKETING - NOVOS PRODUTOS | 120 | 2022-01-05 00:00:00 | 2022-02-16 00:00:00
 |  | MARKETING | 120 | 2021-11-16 00:00:00 | 2022-03-16 00:00:00
 |  | MANUTENCAO UP2 | 85 | 2022-01-05 00:00:00 | 2022-03-31 00:00:00
 |  | EMBALAGEM UP1 | 120 | 2022-01-27 00:00:00 | 2022-05-27 00:00:00
 |  | EMBALAGEM UP2 | 120 | 2021-12-22 00:00:00 | 2022-04-21 00:00:00
 |  | EMBALAGEM UP1 | 166 | 2021-12-17 00:00:00 | 2022-06-01 00:00:00
 |  | FABRICACAO UP2 | 60 | 2022-01-21 00:00:00 | 2022-03-22 00:00:00
 |  | FABRICACAO UP2 | 10 | 2022-01-11 00:00:00 | 2022-01-21 00:00:00
 |  | FABRICACAO UP2 | 392 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 |  | CONTROLE DA QUALIDADE EMBALAGEM UP1 | 120 | 2021-12-17 00:00:00 | 2022-04-16 00:00:00
 |  | SERVICOS GERAIS UP2 | 292 | 2021-12-23 00:00:00 | 2022-10-11 00:00:00
 |  | LOJA SALVADOR BA SH DA BAHIA | 193 | 2021-12-16 00:00:00 | 2022-06-27 00:00:00
 |  | LOJA SP MOOCA PLAZA SH | 60 | 2022-01-13 00:00:00 | 2022-03-14 00:00:00
 |  | ADMINISTRAÇÃO | 120 | 2022-01-14 00:00:00 | 2022-05-19 00:00:00
 |  | LJ PHEBO HIGIENOPOLIS SP | 120 | 2022-01-04 00:00:00 | 2022-05-04 00:00:00
 |  | LOJA MS CAMPO GRANDE | 120 | 2022-01-12 00:00:00 | 2022-05-12 00:00:00
 |  | LOJA BARRA SHOPPING | 120 | 2022-01-27 00:00:00 | 2022-05-27 00:00:00
 |  | LOJA SP SAO CAETANO DO SUL | 425 | 2021-11-01 00:00:00 | 2022-12-31 00:00:00
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 5 | 722 | 213 | 940
Index | 22824 | 115693 | 130001 | 268518
Asia | . | . | 217 | 217
Europe | . | . | 127483 | 127483
North America | 22824 | 115693 | 206 | 138723
Other | . | - | 2095 | 2095
OTHER* | - | - | 48386 | 48386
TOTAL | 22829 | 116415 | 178600 | 317844
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 705736d1606288852-data-comparison-and-aggregation-looking-for-help-copy-template-1-
Sheet: analysis

 |  |  |  |  |  |  |  |  |  |  |  | post Code
ID | Acc Num |  |  | Value | totalValue | otherPercentage | otherCharge | My%Charged | MyCharge | MybrandCheaper? |  |  | Total value (agg  only) | family pricing % | family pricing charge
111 | 1111 |  |  | 1133059.89 | 1133059.89
111 | 1112 |  |  | 3984.4 | 3984.4
222 | 1113 |  |  | 199959.2 | 199959.2
222 | 1114 |  |  | 716513.7 | 716513.7
222 | 1115 |  |  | 55676.77 | 55676.77
333 | 1116 |  |  | 38657.34 | 38657.34
333 | 1117 |  |  | 445112.3 | 445112.3
444 | 1118 |  |  | 121 | 121
444 | 1119 |  |  | 157763.62 | 157763.62
555 | 1120 |  |  | 612748.12 | 612748.12
555 | 1121 |  |  | 906128.44 | 906128.44
666 | 1122 |  |  | 5678224.49 | 5678224.49
777 | 1123 |  |  | 456034.94 | 456034.94
777 | 1124 |  |  | 123456.29 | 123456.29
888 | 1125 |  |  | 2509.43 | 2509.43
888 | 1126 |  |  | 75748.43 | 75748.43
888 | 1127 |  |  | 12745.31 | 12745.31
999 | 1128 |  |  | 123461.02 | 123461.02
999 | 1129 |  |  | 509000.2 | 509000.2
1000 | 1130 |  |  | 131575.33 | 131575.33
1000 | 1131 |  |  | 31040.95 | 31040.95
Spreadsheet: sally_beck__35761__MgmtSum-Q1-0320
Sheet: Upside Downside

Upside / Downside Analysis
 |  |  | Estimate |  | Plan |  | [NAME]
Actual Margin
Deals Identified
Forecast Items:
 | Financial Drift
 | ECP Accretion
 | Gas Assets
 | Kafus/Canfibre Riverside IPC
 | Cgas
Less Expenses:
 | Operating Expenses
 | Commercial & Group Expenses
 | Interest & Interest Related Charges
Identified Earnings
Potential Upsides:
 | Power Plant Valuations |  | 10
 | Sithe Interest |  | 6
 | ENE Stock Price (PSU Hedge) |  | 2.5
 | Canada Expenses |  | 1.8
Potential Downsides:
 | ECOGAS Valuation |  | -15
 | Private Valuations
 | Prudency |  | -20
 | ENE Stock Price (PSU Hedge)
 | Bonus Accrual |  | -20
Earnings Before Tax
Spreadsheet: 177962d1346567518-counting-data-on-another-worksheet-scorecard
Sheet: Data

Customer Name | Likely to Recommend
Adam | 10-- Extremely likely
[NAME] | 10-- Extremely likely
Edmond | 0-- Not likely at all
[NAME] | 10-- Extremely likely
[NAME] | 5
Adam | 8
[NAME] | 10-- Extremely likely
Edmond | 5
[NAME] | 7
[NAME] | 10-- Extremely likely
Adam | 9
[NAME] | 10-- Extremely likely
Edmond | 8
[NAME] | 7
[NAME] | 0-- Not likely at all
Adam | 0-- Not likely at all
[NAME] | 10-- Extremely likely
Edmond | 10-- Extremely likely
[NAME] | 5
[NAME] | 5
Spreadsheet: 161681d1339598217-lookup-repeated-text-and-show-data-book1
Sheet: Sheet1

 |  |  |  | 76784397423842894723847239 | Connect 84397423842894723847239 |  |  |  | Connect 84397423842894723847239 | 1
 |  |  |  | 76732131 | Connect 32131 |  |  |  | Connect 32131 | 1
 |  |  |  | 767843977673842894723847239 | Connect 843977673842894723847239 |  |  |  | Connect 843977673842894723847239 | 1
 |  |  |  | 787843977673842894723847239 | 787843977673842894723847239 |  |  |  | 787843977673842894723847239 | 1
 |  |  |  | 0767843977673842894723847239 | Connect 843977673842894723847239 |  |  |  | Connect 843977673842894723847239 | 1
 |  |  |  | 0787843977073842894723847239 | 0787843977073842894723847239 |  |  |  | 0787843977073842894723847239 | 1
 |  |  |  | test | test |  |  |  | test | 1
 |  |  |  | 767 | Connect |  |  |  | Connect | 1
Spreadsheet: 799299d1665039297-extract-information-from-different-sheets-in-a-workbook-sample-file
Sheet: Required Output

GroupName | Userid
ADGroup100 | test1
ADGroup100 | test2
ADGroup100 | test3
ADGroup100 | test4
ADGroup100 | test5
ADGroup200 | test1
ADGroup200 | test2
ADGroup200 | test3
ADGroup200 | test4
ADGroup200 | test5
ADGroup300 | test11
ADGroup300 | test12
ADGroup300 | test13
ADGroup300 | test14
ADGroup300 | test15
Spreadsheet: 24093d1214211031-highlighting-date-cells-20080623-trial_spreadsheet-u
Sheet: Sheet1

 | 2008-06-23 00:00:00
 |  |  |  |  | Part 1 - Electrical |  |  |  |  |  |  |  |  |  | Part 2 - Blgs and [NAME].
 | Building N0 |  | Description |  | 12 Mnth Visual |  | 24 Mnth Full Elec |  | 11 Mnth Con Floor |  | 11 Mnth LPS |  | RCD |  | 2 Yr Tech Insp |  | 5 Yr Prof Insp |  | Comment
 |  |  |  |  | 2009-01-28 00:00:00 | -22095 | 2010-01-28 00:00:00 |  | N/A |  | N/A |  | N/A |  | REQ |  | REQ
 | 1 |  | a |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | REQ |  | REQ
 | 2 |  | b |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | REQ |  | REQ
 | 3 |  | c |  | 2008-10-01 00:00:00 |  | 2008-11-01 00:00:00 |  | N/A |  | N/A |  | N/A |  | 2012-07-01 00:00:00 |  | 2009-07-01 00:00:00
 | 4 |  | d |  | 2009-02-12 00:00:00 |  | 2011-02-12 00:00:00 |  | N/A |  | 2008-12-13 00:00:00 |  | N/A |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 5 |  | e |  | 2009-02-04 00:00:00 |  | 2010-02-04 00:00:00 |  | N/A |  | N/A |  | N/A |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 6 |  | f |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | 2009-04-01 00:00:00 |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 7 |  | g |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 8 |  | h |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 9 |  | i |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 10 |  | j |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 11 |  | k |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 12 |  | l |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 13 |  | m |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 14 |  | n |  | 2008-06-01 00:00:00 |  | 2010-01-01 00:00:00 |  | N/A |  | 2009-03-01 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 15 |  | o |  | 2009-01-21 00:00:00 |  | 2010-01-21 00:00:00 |  | N/A |  | 2009-04-15 00:00:00 |  | ? |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00
 | 16 |  | p |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | 2009-07-01 00:00:00 |  | 2012-07-01 00:00:00 |  | [NAME] 16+21 | 2009-01-16 00:00:00
Spreadsheet: 123755d1317837646-using-a-command-button-to-switch-tabs-in-excel-2007-rosterphnyc
Sheet: Dining Room

 | August | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2011 | 31 |  | 4
 | DINING ROOM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | Name | 10
 | Name
 | Name
 | Name
 | Name
 | Name
 | Name
Spreadsheet: 180466d1347613859-blank-cells-to-0s-example
Sheet: Sheet1

 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
Jan
Feb | 4 |  |  |  | 4
Mar |  |  | 6 | 6
Apr |  | 6
May | 3 | 6
Jun |  |  | 3
Jul |  |  | 5
Aug |  | 2 |  |  | 6
Sep |  |  |  | 6
Oct |  | 2
Nov |  |  | 7
Dec
Spreadsheet: 687072d1594938296-min-max-calc-for-financial-projection-fm-mhc-model-excelforum-
Sheet: Homes

HOMES
Lot | O/V | S/M | Home rent | Insurance | Property Tax | [NAME] |  | O Chr | O Credits | Total Due | Sec Dep | Move-In Date | O/V/A | Unit Code
1 | Occupied | S | 164
2 | Occupied | S | 164
3 | Occupied | S | 164
4 | Occupied | S | 164
5 | Occupied | S | 164
6 | Occupied | S | 164
7 | Occupied | S | 164
8 | Occupied | S | 164
9 | Occupied | S | 164
10 | Occupied | S | 164
11 | Occupied | S | 164
12 | Occupied | S | 164
13 | Occupied | S | 164
14 | Occupied | S | 164
15 | Occupied | S | 164
16 | Occupied | S | 164
17 | Occupied | S | 164
18 | Occupied | S | 164
19 | Occupied | S | 164
20 | Occupied | S | 164
21 | Occupied | S | 164
22 | Occupied | S | 164
23 | Occupied | S | 164
24 | Occupied | S | 164
25 | Occupied | S | 164
26 | Occupied | S | 164
27 | Occupied | S | 164
28 | Occupied | S | 164
29 | Vacant | S | 164
30 | Vacant | S | 164
31 | Vacant | S | 164
32 | Vacant | S | 164
33 | Vacant | S | 164
34 | Vacant | S | 164
35 | Vacant | S | 164
36 | Vacant | S | 164
37 | Vacant | S | 164
38 | Vacant | S | 164
39 | Vacant | S | 164
40 | Vacant | S | 164
41 | Vacant | S | 164
42 | Vacant | S | 164
43 | Vacant | S | 164
Spreadsheet: 867635d1714462518-find-the-data-on-the-first-cell-from-the-column-where-a-specific-value-is-book1-2-
Sheet: Sheet1

a | b | c | d
Doug | [NAME] | [NAME] | [NAME]
Ruby | [NAME] | Joy | [NAME]
[NAME] | [NAME] | Fredrick | Peggy |  | [NAME]
[NAME] |  | [NAME] | Scott |  | [NAME]
Nazia |  | Ingrid
 |  | [NAME]
 |  | Amber
 |  | April
Spreadsheet: 694002d1599272341-formula-to-count-cells-that-contain-exact-texts-across-column-count_exact_now
Sheet: Sheet2

 | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13 | Same Text/Exact Text | Different Text
1
2
3
4
5
6
7
8
9
Spreadsheet: 784d290c-853c-4ee2-95c2-08d6e5d03bb7
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43609499 | 2014-10-16 21:40:36 | AXIS | 1 | 5 | 3 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609660 | 2014-10-16 21:51:59 | ALLIES | 1 | 5 | 2 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43694294 | 2014-10-22 20:53:51 | AXIS | 1 | 5 | 1 | 1634155 | toconarus | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43694472 | 2014-10-22 21:13:14 | ALLIES | 0 | 3 | 5 | 1634155 | toconarus | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43795101 | 2014-10-29 21:18:49 | AXIS | 1 | 6 | 4 | 1088314 | bino_zoet | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43795310 | 2014-10-29 21:32:16 | ALLIES | 1 | 6 | 4 | 1088314 | bino_zoet | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch