tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776043d1649454352-nested-if-too-many-arguments-testsheet
Sheet: Sheet1

Sunday | ON Duty |  |  | Call Up / Book | Both
 |  |  |  |  |  |  | These Columns will be hidden
Run | Time In | Time Out | Extended | Total | [NAME] |  |  |  |  | Platform | OT | Non-Platform | Stand By | [NAME] |  | [NAME] | [NAME]
 | 600 | 630 | 640 |  | Stand-By |  |  |  |  |  |  |  |  |  |  | Non Platform | 930
 | 630 | 930 |  |  | Platform |  |  |  |  |  |  |  |  |  |  | Platform | Call Up
 | 930 | 1030 |  |  | Non Platform |  |  |  |  |  |  |  |  |  |  | Stand-By | Both
 | 1100 | 1145 |  |  | OT |  |  |  |  |  |  |  |  |  |  | OT
 | 1200 | 2200 |  |  | Platform
 |  |  |  |  |  |  |  | total
Platform
Overtime
Stand By
Non Platform
Call Up / Book
HOS Added | 0.07
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: MARYLAND-19

 | COUNTY | CODE
 | Allegany | 1
 | [NAME] | 3
 | Baltimore | 5
 | Baltimore City | 510
 | [NAME] | 9
 | Caroline | 11
 | Carroll | 13
 | Cecil | 15
 | [NAME] | 17
 | Dorchester | 19
 | [NAME] | 21
 | Garrett | 23
 | Harford | 25
 | [NAME] | 27
 | Kent | 29
 | Montgomery | 31
 | [NAME] | 33
 | [NAME] | 35
 | St. Mary's | 37
 | Somerset | 39
 | Talbot | 41
 | Washington | 43
 | Wicomico | 45
 | Worcester | 47
Spreadsheet: b576ee4b-5b3b-4872-9083-abb21f2828c2
Sheet: 8-11-2014

IRN | DISTRICT | COUNTY | FISCAL STATUS | CAUTION  DECLARED | WATCH  DECLARED | EMERGENCY  DECLARED
048462 | Black River Local SD | Medina | CAUTION | 2011-02-18 00:00:00
043711 | Canton City SD | [NAME] | CAUTION | 2007-03-22 00:00:00
046326 | Clermont Northeastern Local SD | Clermont | CAUTION | 2014-01-23 00:00:00
047845 | East Knox Local SD | Knox | CAUTION | 2012-09-04 00:00:00
043968 | Fairborn City SD | Greene | CAUTION | 2013-01-14 00:00:00
045369 | Fairport Harbor Ex Vill SD | Lake | CAUTION | 2004-04-30 00:00:00
045823 | Hillsdale Local SD | Ashland | CAUTION | 2012-06-14 00:00:00
044230 | Lockland Local SD | [NAME] | CAUTION | 2013-11-22 00:00:00
044263 | Lorain City SD | Lorain | CAUTION | 2007-06-23 00:00:00
048025 | North Fork Local SD | Licking | CAUTION | 2010-03-25 00:00:00
046599 | Richmond Heights Local SD | Cuyahoga | CAUTION | 2014-03-17 00:00:00
046003 | Shadyside Local SD | Belmont | CAUTION | 2004-04-12 00:00:00
049064 | Southern Local SD | [NAME] | CAUTION | 2011-04-11 00:00:00
048652 | Switzerland of Ohio Local SD | Monroe | CAUTION | 2010-07-31 00:00:00
045005 | Warrensville Heights City SD | Cuyahoga | CAUTION | 2008-05-05 00:00:00
049999 | Coventry Local SD | Summit | WATCH |  | 1997-05-15 00:00:00
044495 | Niles City SD | Trumbull | WATCH |  | 2003-03-10 00:00:00
043570 | Bellaire Local SD | Belmont | EMERGENCY |  |  | 2009-12-31 00:00:00
050120 | Brookfield Local SD | Trumbull | EMERGENCY |  |  | 2013-05-14 00:00:00
048488 | Cloverleaf Local SD | Medina | EMERGENCY |  |  | 2012-01-24 00:00:00
047209 | Ledgemont Local SD | [NAME] | EMERGENCY |  |  | 2010-11-09 00:00:00
050195 | Liberty Local SD | Trumbull | EMERGENCY |  |  | 2011-07-11 00:00:00
044297 | Mansfield City SD | Richland | EMERGENCY |  | 2006-12-08 00:00:00 | 2013-12-17 00:00:00
139303 | Monroe Local SD | Butler | EMERGENCY |  |  | 2012-05-09 00:00:00
Spreadsheet: 837201d1689933681-match-cell-in-range-find-2nd-highest-seq-value-but-return-date-in-adjacent-cell-excel-problem
Sheet: Cycles

prty_id | seq_no | st_date | end_date |  |  | prty_id | Start Date
AAABERGW0004 | 1 |  |  |  |  | AAABERGW0004
AAABERGW0004 | 2 | 2018-05-08 00:00:00 | 2019-05-08 00:00:00 |  |  | AAABERGW0007
AAABERGW0004 | 3 | 2019-03-19 00:00:00 | 2020-03-19 00:00:00 |  |  | AABEDFOR0014
AAABERGW0004 | 4 | 2020-02-25 00:00:00 | 2021-02-25 00:00:00 |  |  | AABROOKS0016
AAABERGW0004 | 5 | 2021-01-12 00:00:00 | 2022-01-12 00:00:00 |  |  | AABROOKS0017
AAABERGW0004 | 6 | 2021-01-19 00:00:00 | 2022-01-19 00:00:00 |  |  | AABROOKS0018
AAABERGW0004 | 7 | 2021-11-19 00:00:00 | 2022-11-19 00:00:00 |  |  | AABROOKS0019
AAABERGW0004 | 8 | 2022-10-06 00:00:00 | 2023-10-06 00:00:00
AAABERGW0007 | 1 | 2017-08-10 00:00:00 | 2018-08-10 00:00:00
AAABERGW0007 | 2 | 2017-08-10 00:00:00 | 2018-08-10 00:00:00
AAABERGW0007 | 3 | 2018-06-27 00:00:00 | 2019-06-27 00:00:00
AAABERGW0007 | 4 | 2019-05-16 00:00:00 | 2020-05-16 00:00:00
AAABERGW0007 | 5 | 2020-03-17 00:00:00 | 2021-03-17 00:00:00
AAABERGW0007 | 6 | 2020-08-21 00:00:00 | 2021-08-21 00:00:00
AAABERGW0007 | 7 | 2022-05-26 00:00:00 | 2023-05-26 00:00:00
AAABERGW0007 | 8 | 2023-05-18 00:00:00 | 2024-05-18 00:00:00
AABEDFOR0014 | 1 | 2018-05-15 00:00:00 | 2019-05-15 00:00:00
AABEDFOR0014 | 2 | 2019-03-20 00:00:00 | 2020-03-20 00:00:00
AABEDFOR0014 | 3 | 2020-01-27 00:00:00 | 2021-01-27 00:00:00
AABEDFOR0014 | 4 | 2020-01-27 00:00:00 | 2021-01-27 00:00:00
AABEDFOR0014 | 5 | 2020-11-20 00:00:00 | 2021-11-20 00:00:00
AABEDFOR0014 | 6 | 2021-09-29 00:00:00 | 2022-09-29 00:00:00
AABEDFOR0014 | 7 | 2022-08-12 00:00:00 | 2023-08-12 00:00:00
AABEDFOR0014 | 8 | 2023-06-30 00:00:00 | 2024-06-30 00:00:00
Spreadsheet: john_griffith__15580__Huntco Options
Sheet: Put Pricing

 |  |  | Hot Rolled Coil | Cold Rolled Coil | HD [NAME]. Coil
 |  |  | Yes | No
PRICING ASSUMPTIONS
Product: | Hot Rolled Coil
Spot Price:
Is Spot Price a Forward Price?: | Yes
Forward Price Used: | COC
Cost Of Carry: | 0.07
Strike Price: | 225
Implied Volatility: | 0.18
Underlying Volume (NT's): | 10000
Current Date:
Option Expiry: | 2001-07-31 00:00:00
Cost of Money: | 0.0575
 | Per NT | Total | Delta | Delta Position (NT's)
European Call
American Call
European Put
American Put
 |  |  | Date | Put Premium |  | Date | Delta
Date | Mid Price |  |  | 225 |  |  | 225 |  |  | COC | Curve
2001-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 245
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 250
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 260
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 260
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 265
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 270
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 280
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 285
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 290
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 290
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 290
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 290
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 285
 |  |  |  | #[NAME]? |  |  | #[NAME]? |  |  |  | 280
Spreadsheet: 198905d1354927205-return-a-date-if-records-match-fileb
Sheet: Sheet1

ID | ADMISSION
353622
353622
353622
353622
353622
658912
658912
658912
658912
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
698236
711504
711504
711504
711504
711504
711504
711504
711504
Spreadsheet: 718161d1613028319-required-formula-to-monitor-expenses-sampledata_expenses
Sheet: Expected

 | Select Week ---->  Drill down option to select particular week or all the weeks
 | Weekly
 | Name | Week | Total Expenses
 | [NAME] | 24-Jan-21 To 30-Jan-21 | 80
 | [NAME] | 27-Dec-20 To 02-Jan-21 | 39
 | [NAME] | 07-Feb-21 To 13-Feb-21 | 23
 | Vincy | 24-Jan-21 To 30-Jan-21 | 13
 | Vincy | 07-Feb-21 To 13-Feb-21 | 10
 | Glady | 24-Jan-21 To 30-Jan-21 | 22
 | Glady | 07-Feb-21 To 13-Feb-21 | 16
 | [NAME] | 14-Feb-21 To 20-Feb-21 | 15
 | Meryl | 07-Feb-21 To 13-Feb-21 | 18
 | Meryl | 14-Feb-21 To 20-Feb-21 | 22
 | Select Month ---->  [NAME] down option to select particular month or all the months
 | Monthly
 | Name | Month | Total Expense
 | [NAME] | Jan-21 | 119
 | [NAME] | Feb-21 | 23
 | Vincy | Jan-21 | 13
 | Vincy | Feb-21 | 10
 | Glady | Jan-21 | 22
 | Glady | Feb-21 | 16
 | [NAME] | Feb-21 | 15
 | Meryl | Feb-21 | 40
Spreadsheet: 716836d1612375600-appending-dynamic-arrays-workbook
Sheet: Sheet1

DA 1 | DA 2 | Needed Appended Array
 |  | 1
2 | 3 | 2 | 2
3 | 5 | 3 | 3
4 | 7 | 4 | 4
 |  | 1 | 1
 |  | 3 | 3
 |  | 5 | 5
 |  | 7 | 7
Spreadsheet: 820640d1678209618-formula-for-finding-percent-mastery-class-grades
Sheet: 7th

Listening, speaking, reading, writing, and thinking using multiple texts. The student responds to an increasingly challenging variety of sources that are read, heard, or viewed.
8.6.D: [NAME] and summarize texts in ways that maintain meaning and logical order.
Student  First | Student Last | Summarize & Notetakinig Pretest | Summarize & Notetakinig Mid Year | Summarize & Notetakinig End of Year | Determine the main idea of a passage | Analyze the development of informational passages: set 1 | Organize information by main idea | Analyze the development of informational passages
[NAME] | Alter | 62 | 75
Akilha | Berry | 68 | 72
[NAME] | Chaman | 72 | 76
[NAME] | Dominguez | 72 | 72
Adam | [NAME] | 48 | 52
[NAME] | Lupian | 68 | 76
Xzhander | Meza | 78 | 82
[NAME] | [NAME] | 72 | 82
[NAME] | Schrock | 78 | 76
Spreadsheet: 844544d1696333399-extracting-values-vertically-based-on-two-categories-sample-workbook
Sheet: Input

S.No | Fruits | Country | Engagement view links
 | Apple | India | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Orange | Singapore | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Pineapple | Nepal | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Mango | India | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Mango, Orange, Pineapple | Singapore | https://www.excelforum.com/excel-formulas-and-functions/
 | Orange | France | https://www.excelforum.com/excel-formulas-and-functions/
 | Orange | USA | https://www.excelforum.com/excel-formulas-and-functions/
 | Orange,Apple | Nepal | https://www.excelforum.com/excel-formulas-and-functions/
 | Orange, Mango | France | https://www.excelforum.com/excel-formulas-and-functions/
 | Pineapple | India | https://www.excelforum.com/excel-formulas-and-functions/
 | Orange, Mango,Apple | USA | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Mango, Orange, Pineapple | France | https://www.excelforum.com/excel-formulas-and-functions/
 | Pineapple | Nepal | https://www.excelforum.com/excel-formulas-and-functions/
 | Pineapple, Orange | Singapore | https://www.excelforum.com/excel-formulas-and-functions/
 | Mango | India | https://www.excelforum.com/excel-formulas-and-functions/
 | Apple, Orange, Pineapple | USA | https://www.excelforum.com/excel-formulas-and-functions/
 | Mango | France | https://www.excelforum.com/excel-formulas-and-functions/
 | Mango,Pineapple | USA | https://www.excelforum.com/excel-formulas-and-functions/
 | Mango,orange | India | https://www.excelforum.com/excel-formulas-and-functions/
Spreadsheet: f527ac34-4d4e-41e5-92c3-240b0136567a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Current Population Survey/Housing Vacancy Survey, Series H-111, Bureau of the Census, Washington DC 20233
 |  | Rate: United States
 |  | Not Seasonally Adjusted Rental Vacancy Rate [Percent]
 |  | Period: 1956 to 2013
 |  | Data Extracted on: July 29, 2014 (9:15 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
1956 | 6.2 | 5.9 | 6.3 | 5.8
1957 | 5.3 | 5.3 | 5.7 | 5.8
1958 | 6.3 | 6.5 | 6.3 | 6.6
1959 | 6.8 | 7.3 | 7.2 | 7
1960 | 8 | 8 | 8.3 | 8.4
1961 | 8.9 | 8.8 | 8.6 | 8.5
1962 | 8.5 | 8.1 | 8 | 8.1
1963 | 8 | 8.2 | 8.3 | 8.3
1964 | 8.1 | 8.1 | 8.4 | 8.3
1965 | 8.5 | 8.2 | 7.8 | 8.5
1966 | 8.3 | 7.4 | 7.4 | 7.7
1967 | 7.3 | 6.9 | 7 | 6.2
1968 | 6.1 | 6.2 | 5.9 | 5.4
1969 | 5.6 | 5.7 | 5.5 | 5.1
1970 | 5.4 | 5.4 | 5.3 | 5.2
1971 | 5.3 | 5.3 | 5.6 | 5.6
1972 | 5.3 | 5.5 | 5.8 | 5.6
1973 | 5.7 | 5.8 | 5.8 | 5.8
1974 | 6.2 | 6.3 | 6.2 | 6
1975 | 6.1 | 6.3 | 6.2 | 5.4
1976 | 5.5 | 5.8 | 5.7 | 5.3
1977 | 5.1 | 5.3 | 5.4 | 5.1
1978 | 5 | 5.1 | 5 | 5
1979 | 5.1 | 5.5 | 5.7 | 5.4
1980 | 5.2 | 5.6 | 5.7 | 5
1981 | 5.2 | 5 | 5 | 5
1982 | 5.3 | 5.1 | 5.3 | 5.5
1983 | 5.7 | 5.5 | 5.8 | 5.5
1984 | 5.6 | 5.5 | 6 | 6.3
1985 | 6.3 | 6.2 | 6.8 | 6.7
1986 | 6.9 | 7.3 | 7.5 | 7.7
1987 | 7.4 | 7.5 | 8.1 | 7.8
1988 | 8 | 7.7 | 7.8 | 7.3
1989 | 7.5 | 7.4 | 7.6 | 7.1
1990 | 7.5 | 7 | 7.2 | 7.2
1991 | 7.5 | 7.3 | 7.6 | 7.3
1992 | 7.4 | 7.7 | 7.3 | 7.1
1993 | 7.8 | 7.6 | 7 | 6.9
1994 | 7.5 | 7.4 | 7.2 | 7.4
1995 | 7.4 | 7.7 | 7.7 | 7.7
1996 | 7.9 | 7.8 | 8 | 7.7
1997 | 7.5 | 7.9 | 7.9 | 7.7
1998 | 7.7 | 8 | 8.2 | 7.8
1999 | 8.2 | 8.1 | 8.2 | 7.9
2000 | 7.9 | 8 | 8.2 | 7.8
2001 | 8.2 | 8.3 | 8.4 | 8.8
2002 | 9.1 | 8.4 | 9 | 9.3
2003 | 9.4 | 9.6 | 9.9 | 10.2
2004 | 10.4 | 10.2 | 10.1 | 10
2005 | 10.1 | 9.8 | 9.9 | 9.6
2006 | 9.5 | 9.6 | 9.9 | 9.8
2007 | 10.1 | 9.5 | 9.8 | 9.6
2008 | 10.1 | 10 | 9.9 | 10.1
2009 | 10.1 | 10.6 | 11.1 | 10.7
2010 | 10.6 | 10.6 | 10.3 | 9.4
2011 | 9.7 | 9.2 | 9.8 | 9.4
2012 | 8.8 | 8.6 | 8.6 | 8.7
2013 | 8.6 | 8.2 | 8.3 | 8.2
Spreadsheet: 173641d1344628146-using-formula-on-a-cell-with-data-validation-sample-book
Sheet: Sheet3

Tundra | Truck | Foreign
Focus | Car | American
Compass | SUV | American
Envoy | SUV | American
Cruze | Car | American
Matrix | Car | Foreign
Prius | Car | Foreign
Spreadsheet: 152938d1335621350-find-best-combination-based-on-two-columns-solver_max
Sheet: Solver Max

500 | 5
600 | 3
700 | 5
800 | 5
700 | 10
1000 | 3
2200 | 25
Criteria | 0 |  | 40 | [NAME] val crit
Object f | 0 | To be maximised
Spreadsheet: 874075d1720639491-trying-to-return-a-value-from-a-row-that-a-certain-combination-exists-into-another-row-book2_formula
Sheet: Sheet1

 | Worker | Plan | Amount |  | Shadow Amount
 | Heather Carter | FrontLoad | 55
 | [NAME] | FrontLoad | 80
 | [NAME] | FrontLoad | 63
 | [NAME] | FrontLoad | 76
 | [NAME] | FrontLoad | 81
 | [NAME] | FrontLoad | 55
 | [NAME] | FrontLoad | 102
 | Heather Carter | Shadow | 25
 | [NAME] | Shadow | 16
 | [NAME] | Shadow | 11
 | [NAME] | Shadow | 14
 | [NAME] | Shadow | 8
 | [NAME] | Shadow | 6
Spreadsheet: 7c96d2f6-ea86-4d52-9bf0-5b0f35f4f22c
Sheet: FVD-Historic

Year | FVD
1968 | 1855087233
 | 1959734730
 | 2280968664
 | 2687570579
 | 3346317205
 | 4090132633
 | 4632019657
 | 6674571292
 | 11681897320
 | 17105126829
 | 21344147789
 | 25003954890
 | 26756269443
 | 29780286180
 | 35241743816
 | 39025702580
 | 45009767610
 | 48915236700
 | 52116775100
 | 47844222650
 | 42250308590
 | 39563979830
 | 39668486410
 | 40902463940
 | 42278195580
 | 42357481450
 | 43829908630
 | 44402066980
 | 45265505220
 | 47028720910
 | 47484485830
 | 48876809990
 | 50443432410
 | 52947103540
 | 54963378640
 | 58075191459
 | 61185327129
 | 66023110165
 | 74840723759
 | 83914538212
 | 90191645982
 | 95356424475
 | 98062427420
 | 98969409150
Spreadsheet: 140351d1328715115-sum-of-data-from-consecutive-nonconsecutive-dates-example1
Sheet: Sheet1

Date | Score |  | Date | Score |  |  | Non Consecutive |  |  | Consecutive
2011-12-27 00:00:00 | 106 |  | 2011-12-28 00:00:00 | 101 |  |  | Sum: | 1815 |  | Sum: | 396
2011-12-31 00:00:00 | 84 |  | 2011-12-30 00:00:00 | 105
2012-01-02 00:00:00 | 100 |  | 2012-01-05 00:00:00 | 109
2012-01-03 00:00:00 | 74 |  | 2012-01-07 00:00:00 | 109
2012-01-06 00:00:00 | 102 |  | 2012-01-12 00:00:00 | 111
2012-01-09 00:00:00 | 106 |  | 2012-01-14 00:00:00 | 93
2012-01-11 00:00:00 | 84 |  | 2012-01-16 00:00:00 | 93
2012-01-20 00:00:00 | 76 |  | 2012-01-18 00:00:00 | 92
2012-01-25 00:00:00 | 97 |  | 2012-01-21 00:00:00 | 121
2012-01-27 00:00:00 | 83 |  | 2012-02-02 00:00:00 | 77
2012-01-29 00:00:00 | 107 |  | 2012-02-04 00:00:00 | 87
2012-01-31 00:00:00 | 94
Spreadsheet: 293594d1391029706-help-with-combining-information-from-two-workbooks-adriscott-sample-1-
Sheet: Sheet1

Business Name | # | Street
Pizza Time | 87 | 7th Avenue
[NAME]'s Coffee | 89 | 7th Avenue
Linen Shop | 95 | 7th Avenue
Auto repair,llc | 95 | 7th Avenue
Day Care Fun | 95 | 7th Avenue
Victoria's Flowers | 95 | 7th Avenue
Insurance and more | 97 | 7th Avenue
Pops bagels | 108 | 7th Avenue
Spreadsheet: 207518d1358476421-how-to-count-unique-texts-only-with-several-conditions-datafile-for-question
Sheet: Sheet1

Occupation | Name | Country
Teacher | [NAME] | ALGERIA |  |  |  | Country group A
Teacher | [NAME] | ALGERIA |  |  |  | ALGERIA
Manager | Amie | ANGOLA |  |  |  | ANGOLA
Manager | [NAME] | ANGOLA |  |  |  | AUSTRALIA
Manager | [NAME] | ANGOLA |  |  |  | AUSTRIA
Teacher | Lily | ANTIGUA |  |  |  | BELGIUM
Teacher | lily | ANTIGUA |  |  |  | BELARUS
Teacher | [NAME] | ARMENIA
Teacher | [NAME] | AUSTRALIA
Teacher | [NAME] | AUSTRALIA
Teacher | [NAME] | AUSTRALIA
Doctor | Kelly | AUSTRALIA
Doctor | [NAME] | AUSTRALIA
Doctor | [NAME] | AUSTRALIA
Doctor | [NAME] | AUSTRALIA
Teacher | [NAME] | AUSTRALIA
Teacher | [NAME] | AUSTRALIA
Teacher | [NAME] | AUSTRALIA
Teacher | Kathy | AUSTRALIA
Doctor | [NAME] | AUSTRALIA
Doctor | [NAME] | AUSTRALIA
Teacher | Coco | AUSTRIA
Teacher | [NAME] | AUSTRIA
Teacher | [NAME] | AUSTRIA
Teacher | [NAME] | BAHAMAS
Teacher | [NAME] | BANGLADESH
Teacher | Heather | BELARUS
Teacher | Heather | BELGIUM
Doctor | Quinne | [NAME]
Spreadsheet: 848472d1699206108-excel-formular-for-receipts-contents-invoice-vat-jacc-1-
Sheet: Fiscal Tax Invoice

 | Kindly asking for excel formula to fill receipt contents using information from sales worksheet
 | The desired solution is on row B26
 | Fiscal Tax Invoice
 |  | Invoice Number |  | BK 006
 | Received From:
 | VAT Number
 | BP Number
 | Desired solution using information on sales worksheet
 | Description | Quantity | Price  Per Unit | Amount | VAT | Net Amount
 | TOPPERS
 | GREEN
 |  | Total Net Amount
 |  | Total VAT
 |  | Invoice Total
Spreadsheet: 728812d1618668599-trendline-formula-wrong-what-mistake-did-i-make-landing-reference-brake-energy-per-brake
Sheet: Blad1

 | LANDING REFERENCE BRAKE ENERGY PER BRAKE
EVENT | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
MAX MAN | 4.8 | 13.6 | 22.1 | 30.5 | 38.8 | 47 | 55.2 | 63.4 | 71.7 | 80
MAX AUTO | 3 | 10.1 | 17.3 | 24.5 | 31.9 | 39.6 | 47.5 | 55.9 | 64.7 | 74
AUTOBRAKE 4 | 2.5 | 7.9 | 13.5 | 19.4 | 25.6 | 32.1 | 39.1 | 46.6 | 54.7 | 63.4
AUTOBRAKE 3 | 1.6 | 5.5 | 9.7 | 14.2 | 19.1 | 24.5 | 30.3 | 36.6 | 43.4 | 50.7
AUTOBRAKE 2 | 0.9 | 3.6 | 6.6 | 10 | 13.7 | 17.8 | 22.4 | 27.4 | 32.8 | 38.7
AUTOBRAKE 1 | 0.6 | 2.7 | 5 | 7.5 | 10.3 | 13.4 | 16.8 | 20.7 | 25.1 | 30.1
Spreadsheet: 268699d1380739739-can-i-nest-countifs-statements-in-an-if-or-statement-sample
Sheet: Summary

 |  | Times it Appears
 | DATE | DOW | Type 1 | Type 2 | Total |  | Geocode
 | 2013-09-26 00:00:00 |  |  |  |  |  | 1909
 | 2013-09-27 00:00:00 |  |  |  |  |  | 1915
 | 2013-09-28 00:00:00 |  |  |  |  |  | 1924
 | 2013-09-29 00:00:00 |  |  |  |  |  | 1925
 | 2013-09-30 00:00:00 |  |  |  |  |  | 1984
 | 2013-10-01 00:00:00 |  |  |  |  |  | 1999
 | Looking for ABC,ACD,ADF,DFG that occur on specific dates in the geocode areas
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 53256 | 50455
2 | 35225 | 42864
3 | 9749 | 31925
4 | 13680 | 13148
5 | 39257 | 39446
6 | 39309 | 39455
7 | 17078 | 21455
8 | 38021 | 38122
9 | 50313 | 34788
10 | 41422 | 41455 | -663
11 | 41404 | 41455 | -302
12 | 51512 | 46739
13 | 46816 | 46871
14 | 44923 | 44937
15 | 49883 | 44937
16 | 51915 | 46937
17 | 54916 | 49937
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00
2001-08-17 00:00:00
CBS Dollars
Spreadsheet: 682435d1592090230-average-calculation-with-specific-criteria-sample
Sheet: Sheet2

 |  |  |  |  | ab1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | ab2 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 8
 |  |  |  |  | ab4 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  | ab5 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | ab1 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | ab5 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  | ab1 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  | ab1 |  |  |  |  |  |  |  |  | 9
Spreadsheet: 209222d1359044235-how-to-format-spreadsheet-to-change-color-after-x-dates-in-excell-2007-example2_date_con_etaf-3-
Sheet: Sheet1

2012-02-06 00:00:00 | 2012-10-10 00:00:00 | 2012-12-04 00:00:00 | 2012-12-19 00:00:00
2012-03-16 00:00:00 | TCS | 2012-06-29 00:00:00 | 2012-06-29 00:00:00
2012-10-10 00:00:00 | 2012-10-10 00:00:00 | 2012-09-12 00:00:00 | 2012-10-10 00:00:00
2012-03-13 00:00:00 | 2012-10-10 00:00:00 | 2012-12-04 00:00:00 | 2012-03-26 00:00:00
 |  |  | 2012-11-15 00:00:00
2012-09-12 00:00:00 | 2012-10-10 00:00:00 | 2012-12-18 00:00:00 | 2012-08-03 00:00:00
2012-03-13 00:00:00 | 2012-10-10 00:00:00 | 2012-01-05 00:00:00 | 2012-01-07 00:00:00
2012-03-13 00:00:00 |  | 2013-01-08 00:00:00 | 2013-01-08 00:00:00
2012-03-06 00:00:00 | 2013-01-09 00:00:00 | 2012-02-14 00:00:00 | 2012-07-17 00:00:00
Spreadsheet: 52909d1252767967-annual-leave-entitlement-that-resets-to-original-number-after-passing-year-leaves
Sheet: Personal Data

Overtime/Meal/Transport/Midnight/Acting Allowance Claim Form
Year
2009-09-12 00:00:00
Name
Team |  |  | 1,2,3 or 4
Basic salary |  |  | 0 | 0 | 0
Race |  |  | C=Chinese,M=Muslim,I=Indian
Date of Birth |  |  | [NAME]/dd/yyyy |  |  |  | Age | 2009-09-12 00:00:00
Maritius Status |  |  | S=Single,M=Married
GESPP
Shell Staff Co-op
Date of Joining |  |  | [NAME]/dd/yyyy |  |  | Year of Service |  | 1900-01-01 00:00:00
Shift Allowance |  | 775
Night Shift Allowance |  | 25
Meal Allowance |  | 12
Transport Allowance |  | 15
Leave Balance
Time Account |  | Deductible From |  | Deductible To |  | Entitlement | Remainder
SG-Medical Leave |  | 01/01/ | 2009-09-12 00:00:00 | 31/12/ | 2009-09-12 00:00:00 | 14 | 14
SG-Hospitalisation Leave |  | 01/01/ | 2009-09-12 00:00:00 | 31/12/ | 2009-09-12 00:00:00 | 60 | 60
SG-Child Care Leave |  | 01/01/ | 2009-09-12 00:00:00 | 31/12/ | 2009-09-12 00:00:00 | 0 | 0
SG-Carried Forward Leave |  | 01/04/ | 2009-09-12 00:00:00 | 31/03/ | 2010-09-12 00:00:00 |  | 0
SG-Other Leave Credit |  | 01/04/ | 2009-09-12 00:00:00 | 31/03/ | 2010-09-12 00:00:00 |  |  | 0
SG-Yearly Entitled Leave |  | 01/04/ | 2009-09-12 00:00:00 | 31/03/ | 2010-09-12 00:00:00 | 10 |  | 10
Please fill in your particulars here before you proceed to key in on the respective months
On the "Remarks" column in each sheet, key in "AL" for Annual Leave,"MC" for Medical Leave,"HL" for  Hospitalisation Leave and "CCL" for Childcare Leave. Not following this format will result in the Leave Balance not calculated properly.
Spreadsheet: 877978d1724924931-dynamic-drop-down-dependent_data_validation
Sheet: Banana

[NAME]
Branch | [NAME]
Area
Schools | Type | Model | Grade
School 4
School 5
School 7
School 8
School 8
Spreadsheet: jim_schwieger__14303__Bronco Playoff Schedule
Sheet: Sheet3

Bronco Gray Consolation Playoff Bracket/Schedule
#9 Reds-Labay
#13 Pirates-Hamilton | Monday 8:00pm @ | Winner of Round 2
 | [NAME]
Wednesday 5/16 | #13 Pirates-Hamilton
WLY#5 @ 8:00pm
#20 Mariners-Bleyl
 |  |  | Winner Round 3
#14 Padres-Arnold
Saturday 5/19 | Winner of 14 vs.19
BC#2 @ 10:00am
#19 Marlins-Bleyl |  | Winner of Round 2
#12 Dodgers-Truitt
 |  | Monday 5/21
#11 Cubs-Hamilton
#15 Braves-Thorton |  | Winner of Round 2
Thursday  5/17 | Winner of 15 vs. 18
WLY#5 @ 6:00pm
#18 White Sox-Arnold
 |  |  | Winner Round 3
#17 Tigers-Campbell 11
Tuesday 5/15 | #16 Twinns-Truitt
WLY#5 @ 8:00pm | Thursday 8:00pm
#16 Twinns-Truitt 13 | WLY#5 | Winner of Round 2
#10 Cardinals-Cook
Spreadsheet: 716489d1612236159-return-column-header-based-on-1st-2nd-3rd-match-and-possible-offset-return-headers-based-on-values-followup
Sheet: Sheet1

 | Help on retieving column headers based on cell values in range
 | list for lookup |  |  |  |  |  |  |  |  |  |  |  | Output |  |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  | lookup value | EXPECTED FORMULA BELOW |  |  |  | lookup value | EXPECTED FORMULA BELOW
 |  |  | Name | Header 1 |  | Name | [NAME] |  | Name | [NAME] |  |  | a |  |  |  |  | a | Header 1 | [NAME]
 | a |  | a | 1 |  | b | 2 |  | a | 3 |  | values---> |  | 1 | 3 |  |  | b | [NAME]
 | b |  | c | 2 |  | d | 3 |  | c | 7 |  |  | d |  |  |  |  | d | [NAME]
 | c |  |  |  |  | c | 5 |  |  |  |  | values---> |  | 3 |  |  |  | c | Header 1 | [NAME] | [NAME]
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k