tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 809650d1671198691-how-to-prevent-duplicate-outcome-in-excel-formula-excel-forum-help_how-to-prevent-duplicate-outcom-in-formula-1-
Sheet: Sheet1

Channel Partner | Total Stock Days |  | Conclusion
[NAME] (Jodhpur) | 40 |  |  | Here, I want to prevent duplicate outcome.
[NAME] (Osian) | 31
Fair Deal (Jodhpur-3) | 29 |  | Matoshree (Phalodi), [NAME] ([NAME]) (21 Days & 21 Days)
Sohan Communication Private Limited (Jodhpur-4) | 38
Matoshree (Phalodi) | 21 |  | The 2 highest
[NAME] (Jaisalmer) | 21
Global System(Pali) | 38
[NAME] ([NAME]) | 36
[NAME] (Balotra) | 27
Adarsh [NAME] (Jalore) | 31
[NAME] (Sanchor) | 28
Gaurav Marketing (Sirohi) | 37
Spreadsheet: 217183d1361999178-data-sorting-sampler_excel-forum
Sheet: Sheet1

CLIENT NO | ACC CODE | ACCOUNT [NAME] | Entry description | Amount in Local currency | USD |  | Testing by ABS Values
1 | 101 | Commision Paid | Commission - Client 2 | 95 | 100
2 | 102 | Commission Received | Commission - Client 1 | 2000 | -100
3 | 103 | Interst Paid | Interest for client 4 | 166 | 200
4 | 104 | Interest Received | int. reced. Client 3 | 417 | -200
5 | 105 | Service fees paid | Service fees paid -6 | 21000 | 300
6 | 106 | Service fees received | Service fees 5 | 15000 | -300
7 | 107 | Product Sale | Payment received from Mr. [NAME] | 95 | 100
8 | 108 | Product Purcahse | Product purchased from client 7 | 95 | 105
Spreadsheet: chris_germany__1870__TCO PAL Deal Beyond Prompt
Sheet: Model

Columbia Gas Parking & Lending |  |  |  |  |  |  |  | 2001-03-21 00:00:00 | Deal #
PAL Volume | 310000 |  |  | w/o Index
 |  |  | 0 |  | 0
 |  | TCO | TCO | TCO | TCO |  | PAL | PAL
 | NYMEX | Basis | Basis | Index | Index | Total | Indicator | Volume | Value | PV Factor | PV Value | PAL Fee | PV PAL Fee | PV Profit
2001-04-01 00:00:00 |  | 0.225 |  |  |  | 5.485 |  |  |  | 0.9997235750731724
2001-05-01 00:00:00 | 5.13 | 0.25 |  | 0.01 |  |  | p |  |  | 0.9956471638194163
2001-06-01 00:00:00 | 5.3 | 0.225 |  | 0.0125 |  |  |  |  |  | 0.9915461304083709
2001-07-01 00:00:00 | 5.35 | 0.23 |  | 0.0025 |  |  |  |  |  | 0.98773044101502
2001-08-01 00:00:00 | 5.37 | 0.23 |  | 0.0025 |  |  |  |  |  | 0.9839196739755462
2001-09-01 00:00:00 | 5.35 | 0.18 |  | 0.0025 |  |  |  |  |  | 0.9801794698168694
2001-10-01 00:00:00 | 5.35 | 0.225 |  | 0.0025 |  |  |  |  |  | 0.9765746560489015
2001-11-01 00:00:00 | 5.47 | 0.28 |  | 0.03 |  |  |  |  |  | 0.9729125432089629
2001-12-01 00:00:00 | 5.415 | 0.32 |  | 0.03 |  |  | l |  |  | 0.9693663856038193
2002-01-01 00:00:00 | 5.45 | 0.31 |  | 0.03 |  |  |  |  |  | 0.9656135111511036
2002-02-01 00:00:00 | 5.43 | 0.32 |  | 0.03 |  |  |  |  |  | 0.9618798299822233
2002-03-01 00:00:00 | 5 | 0.32 |  | 0.03 |  |  |  |  |  | 0.9585146080022802
2002-04-01 00:00:00 | 4.5 | 0.205 |  | 0.0175 |  |  |  |  |  | 0.954774467165146
2002-05-01 00:00:00 | 4.5 | 0.195 |  | 0.01 |  |  |  |  |  | 0.9511687686289929
2002-06-01 00:00:00 | 4.3 | 0.205 |  | 0.0125 |  |  |  |  |  | 0.947406206186989
2002-07-01 00:00:00 |  | 0.24 |  | 0.0125 |  |  |  |  |  | 0.9436795663164272
2002-08-01 00:00:00 |  | 0.24 |  | 0.0125 |  |  |  |  |  | 0.9398293154790527
2002-09-01 00:00:00 |  | 0.21 |  | 0.0125 |  |  |  |  |  | 0.9359459581106956
2002-10-01 00:00:00 |  | 0.205 |  | 0.0125 |  |  |  |  |  | 0.9321158896693434
2002-11-01 00:00:00 |  | 0.27 |  | 0.03 |  |  |  |  |  | 0.9281628013704429
2002-12-01 00:00:00 |  | 0.31 |  | 0.03 |  |  |  |  |  | 0.9242712028653612
2003-01-01 00:00:00 |  | 0.31 |  | 0.03 |  |  |  |  |  | 0.9201984201850117
2003-02-01 00:00:00 |  | 0.29 |  | 0.03 |  |  |  |  |  | 0.9161455043140875
2003-03-01 00:00:00 |  | 0.27 |  | 0.03 |  |  |  |  |  | 0.9124201156132493
 |  |  |  |  | Spread |  |  |  |  | Totals
 |  |  |  |  | Time Value |  |  |  |  | Rate
 |  |  |  |  |  |  |  |  |  | Daily PAL Fee Rate |  | -0.0008
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending October 25, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 329511d1404325948-trouble-with-sumif-formula-on-totals-tab-example-payroll-2
Sheet: Pay Period 4

Starting Weekday | Ending Week Day
2014-08-04 00:00:00
 |  |  |  | Week 1 |  | Week 2 |  | Bi-Weekly Totals (ending on:) |  |  |  |  |  | Total Hours Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Amount Payments Received
Trainer | Session Type | Fees | Client | Frequency | Dates | Frequency | Dates | Date Billed | Date Payment Received | Hours Billed | Payment Amount | Amount Paid to [NAME] |  | Total Amount Paid to Trainers
Ceci | 30 Minute |  | Becky | 2 | 8/4, 8/7 | 2 | 8/11, 8/16, | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | Total Profit:
[NAME] | 45 Minute |  | Kelly | 1 | 2014-08-05 00:00:00 | 3 | 8/11, 8/13, 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00
Ceci | 60 Minute |  | [NAME] | 2 | 8/5, 8/10 | 1 | 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00
Kilee | Class |  | [NAME] | 2 | 8/4,  8/7 | 2 | 8/11,  8/16 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # 60 Minute Sessions
Ceci | 60 Minute |  | Muffy | 2 | 8/5, 8/10 | 1 | 8/16 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # 45 Minute Sessions
[NAME] | 60 Minute |  | [NAME] | 3 | 8/4, 8/7, 8/10 | 1 | 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # 30 Minute Sessions
[NAME] | 60 Minute |  | Leo | 4 | 8/4, 8/5, 8/7, 8/10 | 1 | 2014-08-11 00:00:00 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # [NAME]
[NAME] | 60 Minute |  | New | 1 | 8/7 | 3 | 8/11, 8/13, 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # Hours Office Work
[NAME] | 60 Minute |  | New | 2 | 8/5, 8/10 | 2 | 8/11, 8/16 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | # [NAME]
Ceci | 30 Minute |  | New | 2 | 8/4, 8/10 | 2 | 8/13, 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00
Ceci | 30 Minute |  | New | 2 | 8/5, 8/7 | 2 | 8/11, 8/13 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00
Ceci | 60 Minute |  | New | 3 | 8/4, 8/5, 8/10 | 3 | 8/11, 8/13, 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | [NAME] | Total Hours | Total Amount Paid to [NAME]
New Hire | Class |  | New | 1 | 8/7 | 4 | 8/11, 8/13, 8/16, 8/17 | 2014-08-17 00:00:00 | 2014-08-23 00:00:00 |  |  |  |  | Ceci
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilee
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire
Spreadsheet: 110007d1306815562-help-searching-for-specific-terms-and-summarizing-info-42testes
Sheet: Apoio

Pessoas | Pagamento | Tipos | Foto | Recorte | [NAME] | Tratamento | Renda Annual |  |  | Faturamento | Diego | Juliano | 42 | Terceirizado | Fotos | Faturamento | Fotos | Horas | Faturamento | Horas | Jobs
42 | Agendado | 360° | 0 | 0 | 0 | 0 |  |  | Janeiro
Diego | [NAME] | Arquitetura | 0.5 | 0 | 0 | 0.5 |  |  | Fevereiro
Juliano | Entregar | [NAME] | 0.5 | 0 | 0 | 0.5 |  |  | Março
Terceirizado | Pago | Corporativa | 0.6 | 0 | 0 | 0.4 |  |  | Abril
 |  | Editorial | 0 | 0 | 0 | 0 |  |  | Maio
 |  | Esportes | 0 | 0 | 0 | 0 |  |  | Junho
 |  | Evento Simples | 0.8 | 0 | 0 | 0.2 |  |  | Julho
 |  | [NAME] | 0 | 0 | 0 | 0 |  |  | [NAME]
 |  | Gastronomia | 0.5 | 0 | 0 | 0.5 |  |  | Setembro
 |  | Lomo | 0.8 | 0 | 0 | 0.2 |  |  | Outubro
 |  | Lookbook | 0.5 | 0 | 0 | 0.5 |  |  | Novembro
 |  | [NAME] | 0.2 | 0.35 | 0.15 | 0.3 |  |  | Dezembro
 |  | Produtos Simples | 0.2 | 0.5 | 0 | 0.3
 |  | Produtos Complexo | 0.3 | 0.2 | 0 | 0.5
 |  | Publicitária | 0.5 | 0 | 0 | 0.5
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Northern Dauphin

 |  |  | 2014 Northern Dauphin -  Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Every Thursday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 766923d1644167998-modify-existing-formula-to-only-include-results-based-on-a-date-range-month-test-data-for-upload
Sheet: Average Calc Sheet

 | [NAME] | Green | Green % | Total Work Found | Total Work Sold | Total Work Lost | Total Work Deferred | Average Work Found Per VHC | Average Work Sold Per VHC | Red Work Found | Red Work Sold | Red Work Sold % | Red Work Lost | Red Work Deferred | Amber Work Found | Amber Work Sold | Amber Work Sold % | Amber Work Lost | Amber Work Deferred
Nissan
Citroen
Peugeot
Toyota
Vauxhall
Honda
Group
 | [NAME] | Green | Green % | Total Work Found | Total Work Sold | Total Work Lost | Total Work Deferred | Average Work Found Per VHC | Average Work Sold Per VHC | Red Work Found | Red Work Sold | Red Work Sold % | Red Work Lost | Red Work Deferred | Amber Work Found | Amber Work Sold | Amber Work Sold % | Amber Work Lost | Amber Work Deferred
Spreadsheet: 28cc6ff4-b0e1-4a42-8dfc-1593173a99ff
Sheet: Sheet1

Adults Age 18 Years and Over With Current Asthma, by County and Public Health District, Maine 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Unweighted Number | Weighted Number |  | % | LCL | UCL
Maine total |  | 843 | 103702.137018238 |  | 9.981670397443672 | 9.10325316709372 | 10.86008762779362
US |  |  | NA |  | 9.1
County
 | Androscoggin | 53 | 6695.606772007013 |  | 8.877009829857421 | 5.892818152259816 | 11.86120150745503
 | Aroostook | 52 | 6294.892493429435 |  | 9.175915742795544 | 6.329880190440583 | 12.02195129515051
 | Cumberland | 128 | 17445.96131173175 |  | 9.198250557365025 | 7.21820692707555 | 11.1782941876545
 | Franklin | 28 | 2168.603331033284 |  | 8.334917850378485 | 4.827208479907828 | 11.84262722084914
 | Hancock | 43 | 5026.24926607828 |  | 9.996547687514843 | 6.667704931322 | 13.32539044370769
 | Kennebec | 66 | 8954.965053689308 |  | 10.4100129232634 | 7.322468632192108 | 13.49755721433469
 | Knox | 41 | 3388.769561258889 |  | 10.55911264785793 | 6.94981595258217 | 14.1684093431337
 | Lincoln | 41 | 4001.739136981656 |  | 12.69665840669804 | 7.927356395781554 | 17.46596041761453
 | Oxford | 31 | 4705.349966899004 |  | 9.856042479819884 | 5.717152381099712 | 13.99493257854005
 | [NAME] | 79 | 11732.134141327 |  | 11.56526539945658 | 8.498183946372965 | 14.6323468525402
 | Piscataquis | 23 | 1991.155661347637 |  | 11.02976405350937 | 6.181786970608922 | 15.87774113640982
 | Sagadahoc | 26 | 2321.189230975377 |  | 7.46039205456563 | 3.903068806435291 | 11.01771530269597
 | Somerset | 32 | 3036.781893913435 |  | 7.143105099996452 | 4.22672711260093 | 10.05948308739197
 | [NAME] | 36 | 3586.034776261811 |  | 10.28386505511534 | 5.167870974480674 | 15.39985913575001
 | Washington | 51 | 4636.88426737746 |  | 15.6515599164273 | 10.23154450258063 | 21.07157533027397
 | York | 90 | 14108.85620749451 |  | 9.727477659614362 | 6.967602333848346 | 12.48735298538038
District
 | Aroostook | 52 | 6294.892493429435 |  | 9.175915742795544 | 6.329880190440583 | 12.02195129515051
 | Central | 98 | 11991.74694760274 |  | 9.329479062067945 | 7.038258559221987 | 11.6206995649139
 | Cumberland | 128 | 17445.96131173175 |  | 9.198250557365025 | 7.21820692707555 | 11.1782941876545
 | Downeast | 94 | 9663.133533455739 |  | 12.0931942393848 | 9.160814771154216 | 15.02557370761539
 | [NAME] | 144 | 13297.73270547773 |  | 10.26096313218381 | 8.065045515517298 | 12.45688074885032
 | Penquis | 102 | 13723.28980267463 |  | 11.48436543585737 | 8.77938359214442 | 14.18934727957032
 | Western | 112 | 13569.5600699393 |  | 9.095767507648702 | 6.996282529176254 | 11.19525248612115
 | York | 90 | 14108.85620749451 |  | 9.727477659614362 | 6.967602333848346 | 12.48735298538038
Data Source:  Maine Behavioral Risk Factor Surveillance System.
All percentges are weighted to be more representative of the general child population of Maine and to adjust for non-response.
LCL = Lower confidence limit; UCL = Upper confidence limit
Spreadsheet: 864399d1711577861-index-match-reversed-need-to-find-the-value-in-column-a-index-match-reversed-need-to-find-the-value-in-column-a-
Sheet: Feuil1

Scale | Pointing1 | Pointing2 | Pointing3 | Pointing4
0 | Horrible | 1,10 and more GJ/m2 | 0-20% | Extreme
1 | Bad | 0,95 to 1,09999 GJ/m2 | 20-40% | Very high
2 | Passable | 0,8 to 0,94999 GJ/m2 | 40-60% | High
3 | Average | 0,65 to 0,79999 GJ/m2 | 60-80% | Moderate
4 | Good | 0,5 to 0,64999 GJ/m2 | 80-100% | Low
5 | Excellent |  |  | Very low
 |  |  | Expected result
Criterion 1 : | Pointing3 | 60-80% | 3
Criterion 2 | Pointing1 | Excellent | 5 |  |  |  | [NAME] to give me the scale according to the Pointing column and the date in said column.
Spreadsheet: 191217d1351972202-number-of-subjects-help-book1
Sheet: Sheet1

Subject Initials | Papillary | PapRE | [NAME] | Pap mean | Schirmer | RE | LE | Schirmer mean | Helper | Without Helper
LC |  | 3 | 3 | 3 |  | 10 | 12 | 11 |  | 2
MP JR |  | 2 | 2 | 2 |  | 35 | 35 | 35 |  | Or with helper Col 10
KP |  | 2 | 2 | 2 |  | 12 | 20 | 16 |  | 2
GE |  | 0.5 | 0.5 | 0.5 |  | 11 | 35 | 23
TE |  | 2 | 1 | 1.5 |  | 20 | 9 | 14.5
C |  | 2 | 2.5 | 2.25 |  | 18 | 15 | 16.5
DD |  | 1 | 2 | 1.5 |  | 20 | 5 | 12.5
[NAME] |  | 2 | 1.5 | 1.75 |  | 2 | 14 | 8
ER |  | 0 | 0 | 0 |  | 2 | 11 | 6.5
TS |  | 0 | 0 | 0 |  | 3 | 0 | 1.5
AC |  | 3 | 2 | 2.5 |  | 29 | 34 | 31.5
JP |  | 1.5 | 0.5 | 1 |  | 6 | 7 | 6.5
TH |  | 2 | 1 | 1.5 |  | 22 | 8 | 15
JB |  | 1.5 | 1.5 | 1.5 |  | 1 | 3 | 2 | 1
DR |  | 1.5 | 1.5 | 1.5 |  | 4 | 2 | 3 | 1
AT |  | 1 | 1.5 | 1.25 |  | 16 | 13 | 14.5
RW |  | 2 | 1.5 | 1.75 |  | 35 | 35 | 35
AW |  | 1.5 | 1.5 | 1.5 |  | 24 | 19 | 21.5
ES |  | 2 | 2.5 | 2.25 |  | 35 | 25 | 30
CS |  | 1.5 | 1 | 1.25 |  | 20 | 30 | 25
Pap mean greater or equal to 1 AND Schirmer mean less than or equal to 5?
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: SETTINGS

N° Client | Location | Name | Path | Sheet Name
1 | Paris |  |  | PMarcP
2 | Paris | ALFRED | PriceALPa | PAlfredP
3 | Paris | PIERRE | PricePIPa | PPierreP
1 | London | MARC | PriceMALo | PMarcL
2 | London | ALFRED | PriceALLo | PAlfredL
3 | London | PIERRE | PricePILo | PPierreL
Spreadsheet: 121465d1316084740-automatically-fill-data-depending-on-choice-from-drop-down-menu-excel-help-solved
Sheet: Summery

Reporting Period: |  | P08 |  |  | HR Scorecard
 |  |  |  |  | Key Performance Indicator
 | Result Level: |  | SE Region | KPI Definition
 | BU:
 |  |  | KPIs | Unit | P 08/11 | P 09/11 | P 10/11 | P 11/11 | P 12/12 | Target | Comment
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please Select Required Level
 |  |  |  | % |  |  |  |  |  | JG 9-11 covered (15-25%-30); JG12-13 covered (30-45%-52.5) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE Region
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Italy/Spain
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Portugal
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania | CL. Portugal
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Israel/Greece/Cyprus/Malta/Albania
 |  |  |  | € |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania
 |  |  |  | Avearge number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | %
 |  |  |  | Avearge number
 |  |  |  | %
 |  |  |  | %
 |  |  |  | %
 |  |  |  | %
 |  |  |  | %
 |  |  |  | %
 |  |  |  | %
Spreadsheet: 41211d1239720569-countif-with-multiple-conditions-help_count
Sheet: Form

Year | (All)
Count of Emp Name
Emp Name | [NAME] | [NAME] | Pj  No. | Total
ABDUS SALAM |  |  |  | 2
ABDUS SAMAD | Multi | Large | 6204 | 1
 | Single | Small | 7280 | 1
ABID HAFEEZ | Single | Small | 7299 | 1
AHMAD WAHEED ANWAR |  |  |  | 2
[NAME] | Single | Small | 7300 | 1
 |  |  | 7303 | 1
AMIR MANSOOR LOHANI | Single | Small | 7320 | 1
[NAME] | Multi | Small | 6186 | 1
AMJAD RAFIQ CHISHTI |  |  |  | 1
ATIF AWAN | Single | Medium | 7278 | 1
 |  | Small | 7293 | 1
FANSUR NAZIR | Single | Large | 7289 | 1
 |  | Medium | 7308 | 1
 |  | Small | 6220 | 1
GUL MUHAMMAD | Single | Small | 6238 | 1
 |  |  | 6263 | 1
HAFIZ MUJTABA AHMAD | Multi | Medium | 6246 | 1
 |  | Small | 6195 | 1
 |  |  | 6202 | 1
 | Single | Medium | 7310 | 1
HAMID HASAN |  |  |  | 2
HASSAN RAZA | Multi | Small | 6275 | 1
IMRAN MAHMOOD | Multi | Medium | 6316 | 1
 |  | Small | 6272 | 1
 |  |  | 6324 | 1
IMRAN MAQBOOL | Multi | Small | 6218 | 1
IMRAN SIDDIQUE | Single | Small | 7317 | 1
[NAME] | Single | Medium | 7304 | 1
 |  | Small | 7267 | 1
 |  |  | 7268 | 1
 |  |  | 7290 | 1
KASHIF | Single | Large | 7266 | 1
 |  |  | 6276 | 1
 |  | Small | 7313 | 1
KHALID MAHMOOD |  |  |  | 2
KHALID NASIM | Single | Small | 7264 | 1
 |  |  | 6300 | 1
 |  |  | 7309 | 1
KHAWAJA JUNAID NASIR | Multi | Large | 6295 | 1
KHURRAM NAZIR | Single | Small | 7312 | 1
MAHMUD ASHRAF [NAME] | Multi | Large | 6200 | 1
 |  | Small | 6189 | 1
 | Single | Small | 7257 | 1
MASOOD ALAM |  |  |  | 1
MOHAMMAD ALI |  |  |  | 1
MOHAMMAD FAISAL ZAHEER | Single | Small | 6328 | 1
 |  |  | 7322 | 1
MOHAMMAD SHAFIQUE AHMED | Single | Small | 6261 | 1
MOHSIN JAMEEL | Multi | Small | 6221 | 1
 |  |  | 6241 | 1
 |  |  | 6273 | 1
 |  |  | 6278 | 1
MUDASSAR RAFIQUE | Single | Small | 6242 | 1
 |  |  | 6256 | 1
 |  |  | 6274 | 1
MUHAMMAD ADEEL BAIG |  |  |  | 2
MUHAMMAD ALIM UR RAHMAN | Multi | Large | 6271 | 1
MUHAMMAD AMIR RAZA | Multi | Large | 6265 | 1
MUHAMMAD ASHRAF [NAME] | Single | Small | 7296 | 1
 |  |  | 7314 | 1
[NAME] | Single | Small | 6225 | 1
 |  |  | 6239 | 1
MUHAMMAD SHAHZAD IQBAL |  |  |  | 1
MUHAMMAD TAHIR HAMEED | Multi | Small | 6228 | 1
MUNIR AHMAD | Multi | Small | 6286 | 1
NASIR RIAZ |  |  |  | 1
OMAR QAMAR | Multi | Small | 6255 | 1
RAJA RIZWAN AHMAD | Single | Small | 7321 | 1
RASHID MAQBOOL |  |  |  | 6
[NAME] | Multi | Large | 6303 | 1
SAMINA WASIM | Multi | Small | 6298 | 1
 | Single | Small | 7248 | 1
 |  |  | 7253 | 1
 |  |  | 7275 | 1
 |  |  | 7276 | 1
[NAME] ABBAS | Single | Small | 7307 | 1
SHAHID NAWAZ |  |  |  | 1
[NAME] | Multi | Medium | 6249 | 1
[NAME] | Multi | Large | 6184 | 1
[NAME] | Multi | Large | 6247 | 1
 |  | Small | 6229 | 1
 |  |  | 6279 | 1
SYED ZAFAR ABBAS ZAIDI | Multi | Large | 6292 | 1
SYED ZAKI MURTAZA NAQVI | Multi | Medium | 6293 | 1
 |  |  | 6315 | 1
 |  | Small | 6290 | 1
 | Single | Small | 6317 | 1
TAHIR FAROOQ |  |  |  | 4
UMER RAZA |  |  |  | 2
YASIR ALI | Multi | Medium | 6266 | 1
[NAME] | Multi | Large | 6236 | 1
ZIA-UR-REHMAN | Multi | Large | 6284 | 1
 | Single | Small | 6227 | 1
 |  |  | 7318 | 1
Grand Total |  |  |  | 109
Spreadsheet: 119367d1314353934-counting-lines-with-certain-information-corner
Sheet: Sheet1

data 1 | data 2 | data 3 | data 4 |  | corner | natural | left
corner | left | success | Natural | 1
left | success | natural | corner | 1 |  | total | 6
success | right | cambiado | corner | 0
corner | natural | success | left | 1
success | cambiado | left | corner | 0
natural | success | left | corner | 1
corner | natural | left | cambiado | 1
success | left | cambiado | corner | 0 |  | put criteria in cells f1:i1
left | success | natural | corner | 1 |  | so add success to i1 total =5
corner | cambiado | success | left | 0
success | right | cambiado | corner | 0
Spreadsheet: 847052d1698150990-how-to-visualize-two-separate-tables-book1
Sheet: Dashboard

Preferably 1 slicer. Example from the right, I would have selected [NAME], [NAME] and [NAME] from the slicer. |  | Table1
 |  | Name | Fruit | Quantity
 |  | [NAME] | Pear | 3
 |  | [NAME] | Pear | 2
 |  | Table2
 |  | Name | Age | Car
 |  | [NAME] | 63 | Toyota
 |  | [NAME] | 12 | Toy
Spreadsheet: 194983d1353383082-calculating-overtime-and-regular-time-based-on-shift-schedule-shift-reg-time-v-ot-rv
Sheet: Sheet1

 | SHIFT START | SHIFT END
 | 07:00:00 | 15:00:00
DATE | START TIME | END TIME | TOTAL HOURS PER MAN | REG HOURS | OT HOURS
2012-10-28 00:00:00 | 07:00:00 | 16:45:00
2012-10-30 00:00:00 | 14:30:00 | 22:36:00
2012-10-30 00:00:00 | 14:30:00 | 22:36:00
2012-10-31 00:00:00 | 07:00:00 | 13:00:00
2012-10-31 00:00:00 | 06:00:00 | 23:59:00
2012-11-01 00:00:00 | 00:00:00 | 00:52:00
2012-11-01 00:00:00 | 06:00:00 | 02:00:00