tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715741d1611847868-absolute-sum-book1
Sheet: 2020

 |  |  |  |  |  |  |  | Q4
MVR Tracking Number | Date MVR added to tracking sheet | Date MVR Received yyyy.mm.dd | Date AG Adj Received yyyy.mm.dd |  |  |  |  | Adjustment Date Period mmm dd to mm -dd yyyy | Adjustment in GJ's |  | Comments |  | Date | Reporting Period
2019-29 | 2019.12.09 | 2019.12.09 |  |  | 2354 |  |  | [NAME] | -37 |  |  |  | 2020-01-09 00:00:00
2019-30 | 2019.12.11 | 2019.12.11 |  |  | 1234 |  |  | Sept 20-30 2019 | 2705 |  |  |  | 2020-01-09 00:00:00
2019-31 | 2019.12.13 | 2019.12.30 | 2019.12.13 |  | 2711 |  |  | Oct 13-31 2019 | 4781 |  |  |  | 2020-01-09 00:00:00
2019-32 | 2019.12.13 | 2020-01-23 00:00:00 | 2019.12.13 |  | 5103 |  |  | June, Sept Oct 2019 | 109668 |  |  |  | 2020-02-21 00:00:00
2020-01 | 2020.01.14 | 2020.01.27 | 2020.01.14 |  | 2796 |  |  | Nov 26 2019 | 153 |  |  |  | 2020-02-21 00:00:00
2020-02 | 2020.01.14 | 2020.01.23 | 2020.01.14 |  | 4377 |  |  | Nov 30 2019 | 59 |  |  |  | 2020-02-21 00:00:00
2020-03 | 2020.02.12 | 2020.03.30 | 2020.02.12 |  | 2796 |  |  | Oct 11-31 2019 | 21126 |  |  |  | 2020-04-02 00:00:00
2020-04 | 2020.03.06 | 2020.03.06 |  |  | 5209 |  |  | Jan 13-14 2020 | 4337 |  |  |  | 2020-03-30 00:00:00
2020-05 | 2020.02.12 | 2020.03.16 | 2020.02.12 |  | 2767 |  |  | Oct 25-28 2019 | 731 |  |  |  | 2020-03-30 00:00:00
2020-06 | 2020.02.12 | 1905-07-12 02:09:36 | 2020.02.12 |  | 5213 |  |  | Dec 11, 12 & 20 | 463 |  |  |  | 2020-03-30 00:00:00
2020-07 | 2020.03.16 | 2020.05.04 | 2020.03.16 |  | 1360 |  |  | May 10- Aug 7 2019 | 5998 |  |  |  | 2020-05-21 00:00:00
2020-09 | 2020.03.11 | 2020.05.04 | 2020.03.16 |  | 4397 |  |  | Nov 27 2019-Jan 31 2020 | -3219 |  |  |  | 2020-05-21 00:00:00
2020-10 | 2020.03.19 | 2020.05.04 |  |  | 12662 |  |  | Feb 2020 | -540 |  |  |  | 2020-05-21 00:00:00
2020-11 | 2020.04.14 | 2020.05.13 | 2020.04.14 |  | 3393 |  |  | Dec 26 2019- March 16  2020 | 175 |  |  |  | 2020-05-21 00:00:00
2020-12 | 2020.05.14 | 2020.05.14 |  |  | 956 |  |  | Dec 10 2019- March 12 2020 | 1267 |  |  |  | 2020-05-21 00:00:00
2020-13 | 2020.05.19 | 2020.05.19 |  |  | 5071 |  |  | March 31 2020 | 643 |  |  |  | 2020-08-25 00:00:00
2020-15 | 2020.07.16 | 2020.07.16 |  |  | 4987 |  |  | May 1-31 2020 | -939 |  |  |  | 2020-08-05 00:00:00
2020-16 | 2020.07.16 | 2020.08.17 |  |  | 1770 |  |  | May-June 2020 | 4286 |  |  |  | 2020-08-25 00:00:00
2020-17 | 2020.07.15 | 2020.09.15 | 2020.07.15 |  | 4749 |  |  | May 5-31 2020- Waiting for MVR | 16820 |  |  |  | 2020-09-21 00:00:00
2020-18 | 2020.09.14 | 2020.10.13 | 2020.09.14 |  | 5224 |  |  | July 30 - 31 2020 | 6457 |  |  |  | 2020-10-19 00:00:00
2020-19 | 2020.09.14 | 2020.10.13 | 2020.09.14 |  | 5225 |  |  | July 21- 31 2020 | -21621 |  |  |  | 2020-10-15 00:00:00
2020-20 | 2020.10.13 | 2020.10.13 |  |  | 259 |  |  | July 23-31 2020 | -1831 |  |  |  | 2020-10-19 00:00:00
Spreadsheet: ddd7fd00-e8c0-4b64-b9a1-449c4375141a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TLU | Test | TLU | Thallium, 24 Hour, [NAME] | Thallium, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL  Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.  Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-1 mcg/specimen  Reference values apply to all ages. | Tuesday, Friday; 3 p.m. | 1 day | 5 days | 1 | 83018 |  |  |  |  | Rochester
TLU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TLU | Order Question | TIME2 | Collection Duration |  | Plain Text
TLU | Order Question | VL12 | [NAME] |  | Plain Text
TLU | Result | 8603 | Thallium, 24 Hr, U | Thallium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5746-3 | Thallium:MRat:24H:[NAME]:Qn:
TLU | Result | TIME2 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
TLU | Result | VL12 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
TLU | Result | 864 | Tl Concentration | Tl Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21558-2 | Thallium:MCnc:24H:[NAME]:Qn:
Spreadsheet: 140362d1328718273-cell-reference-1-column-to-the-right-referencing-13-more-cell-reference
Sheet: Data

Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | DATA | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | Junk | DATA
2011-12-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
 |  |  |  |  |  |  |  |  |  |  |  | AWESOME |  |  |  |  |  |  |  |  |  |  |  |  | TUBULAR
Spreadsheet: 118495d1313732703-if-statement-to-compare-times-variation_calc
Sheet: Raw Parts

Average Parts Per Shift |  |  |  |  |  |  |  |  |  | Average Parts Per Shift
 | (Monday) |  |  |  |  |  |  |  |  |  | (Monday)
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
1 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 1 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
2 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 2 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
3 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 3 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
 | Shifts: |  | #REF!
 | Time:
 | Current Time: |  |  |  | 109-1 | 109-2 | 109-3 | 109-4 |  |  |  |  |  |  | 110-1 | 110-2 | 110-3 | 110-4
 | End Time |  | 06:00:00
 | Difference:
 | Coefficient
Spreadsheet: 102649d1300626675-automated-worksheet-for-accounting-filter-problem-automated-worksheets
Sheet: Track Food

 |  |  | Completed By :
SUPPLIER NAME | INVOICE # | ACCOUNT # | AMOUNT | DATE
Growers Direct (60308) | 16337 | 60308
Growers Direct (76052) | 16337 | 76052
Reflex (Brochures, Fldrs) | I-5200 | 76060
[NAME] (Statnery, Badges) | I-5200 | 76055
Sysco (164) | SY-2088391 | 60300.164
Sysco (165) | SY-2088391 | 60300.165
Sysco (167) | SY-2088391 | 60300.167
Sysco (169) | SY-2088391 | 60300.169
 |  |  | 0
Spreadsheet: 865125d1712182594-modifying-a-sequence-of-numbers-so-that-it-contains-a-0-adjust_days_left_example
Sheet: Adjust Days Left

 | Days to Expiration | 4
Day of Week | Date | Signal | Tentative Days left | Actual Days left
 | 2014-03-27 00:00:00 | Buy
 | 2014-03-28 00:00:00 | DBuy
 | 2014-03-31 00:00:00 | Sell
 | 2014-08-28 00:00:00 | Buy
 | 2014-08-29 00:00:00 | Sell
 | 2014-09-30 00:00:00 | Buy
 | 2014-10-01 00:00:00 | DBuy
 | 2014-10-02 00:00:00 | DBuy
 | 2014-10-03 00:00:00 | Sell
 | 2014-12-31 00:00:00 | Buy
 | 2015-01-02 00:00:00 | DBuy
 | 2015-01-05 00:00:00 | DBuy
 | 2015-01-06 00:00:00 | DBuy
 | 2015-01-07 00:00:00 | DBuy
 | 2015-01-08 00:00:00 | Sell
 | 2015-01-28 00:00:00 | Buy
 | 2015-01-29 00:00:00 | DBuy
 | 2015-01-30 00:00:00 | DBuy
 | 2015-02-02 00:00:00 | DBuy
 | 2015-02-03 00:00:00 | Sell
 | 2015-02-26 00:00:00 | Buy
 | 2015-02-27 00:00:00 | DBuy
 | 2015-03-02 00:00:00 | Sell
 | 2015-03-25 00:00:00 | Buy
 | 2015-03-26 00:00:00 | DBuy
 | 2015-03-27 00:00:00 | DBuy
 | 2015-03-30 00:00:00 | Sell
 | 2015-04-30 00:00:00 | Buy
 | 2015-05-01 00:00:00 | DBuy
 | 2015-05-04 00:00:00 | Sell
 | 2015-05-26 00:00:00 | Buy
 | 2015-05-27 00:00:00 | DBuy
 | 2015-05-28 00:00:00 | DBuy
 | 2015-05-29 00:00:00 | DBuy
 | 2015-06-01 00:00:00 | DBuy
 | 2015-06-02 00:00:00 | DBuy
 | 2015-06-03 00:00:00 | Sell
 | 2015-06-25 00:00:00 | Buy
 | 2015-06-26 00:00:00 | DBuy
 | 2015-06-29 00:00:00 | DBuy
 | 2015-06-30 00:00:00 | DBuy
 | 2015-07-01 00:00:00 | DBuy
 | 2015-07-02 00:00:00 | DBuy
 | 2015-07-06 00:00:00 | DBuy
 | 2015-07-07 00:00:00 | Sell
 | 2015-07-27 00:00:00 | Buy
Spreadsheet: 641872d1568789277-trying-to-output-a-chinese-zodiac-animal-if-the-birth-year-matches-the-corresponding-year-chinese-zodiac-birthdays-and-animals
Sheet: Chinese Zodiac Years

Zodiac Animal | Recent Years | Personality Traits
Rat | 1924 1936 1948 1960 1972 1984 1996 2008 2020
Ox | 1925 1937 1949 1961 1973 1985 1997 2009 2021 | Diligent, dependable, strong, determined
Tiger | 1926 1938 1950 1962 1974 1986 1998 2010 2022 | Brave, confident, competitive
Rabbit | 1927 1939 1951 1963 1975 1987 1999 2011 2023 | Quiet, elegant, kind, responsible
Dragon | 1928 1940 1952 1964 1976 1988 2000 2012 2024 | Confident, intelligent, enthusiastic
Snake | 1929 1941 1953 1965 1977 1989 2001 2013 2025 | Enigmatic, intelligent, wise
Horse | 1930 1942 1954 1966 1978 1990 2002 2014 2026 | Animated, active, energetic
Goat | 1931 1943 1955 1967 1979 1991 2003 2015 2027 | [NAME], gentle, sympathetic
Monkey | 1932 1944 1956 1968 1980 1992 2004 2016 2028 | Sharp, smart, curiosity
Rooster | 1933 1945 1957 1969 1981 1993 2005 2017 2029 | Observant, hardworking, courageous
Dog | 1934 1946 1958 1970 1982 1994 2006 2018 2030 | Lovely, honest, prudent
Pig | 1935 1947 1959 1971 1983 1995 2007 2019 2031 | Compassionate, generous, diligent
Spreadsheet: 87096d1286995468-counting-until-a-condition-and-then-again-counting-from-start-counting-sheet
Sheet: Sheet1

 | 1
 | P | P | P | P | P | P | P | P | P | P | A | P | P | P | A | P | P | P | P | P | P | P | A | A | A | A | P | P | P | P | P
Result expected | 10 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | 5
 | I want to count "P" till "A" comes and then, again start counting "P" from 1 until next "A"
Spreadsheet: 743857d1628779964-2-columns-in-one-column-but-looping-pq-unpivot-2-columns
Sheet: Sheet1

Column1 | Column2 | Value
sa | 5 | sa
132 | 555 | 5
32132 | 54646 | 132
586 | 4646 | 555
 | sder | 32132
 |  | 54646
 |  | 586
 |  | 4646
 |  | sder
Spreadsheet: 544885d1509086566-reservation-system-reservation-system
Sheet: After

Friday, December 1, 2017 | Reservations
Student Number | Cameras | Tripods | Microphones |  | CAMERAS | AVAILABILITY | CameraDropDown | TRIPODS | AVAILABILITY | TRIPODSDropDown | MICROPHONES | AVAILABILITY | MICROPHONESDraopDown
456789098 | Camera 2 | [NAME] | Microphone 2 |  | Camera 1 |  |  | Tripod 1 |  |  | Microphone 1
242424242 | Camera 3 | [NAME] | Microphone 3 |  | Camera 2 |  |  | [NAME] |  |  | Microphone 2
123456789 | Camera 4 | [NAME] | Microphone 4 |  | Camera 3 |  |  | [NAME] |  |  | Microphone 3
987654321 | Camera 7 | [NAME] | Microphone 7 |  | Camera 4 |  |  | [NAME] |  |  | Microphone 4
 |  |  |  |  | Camera 5 |  |  | Tripod 5 |  |  | Microphone 5
 |  |  |  |  | Camera 6 |  |  | Tripod 6 |  |  | Microphone 6
 |  |  |  |  | Camera 7 |  |  | [NAME] |  |  | Microphone 7
 |  |  |  |  | Camera 8 |  |  | [NAME] |  |  | Microphone 8
 |  |  |  |  | Camera 9 |  |  | Tripod 9 |  |  | Microphone 9
 | https://www.excelforum.com/excel-general/1206318-reservation-system.html
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 15 - Table 2

Canada results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 11231.64068944 | -882.032 | 0 | -210.2862224400009 | 10139.322467 | -0.097253665127215 | -0.02031827760353508
Net revenue | 3665.567 | -92.881 | -41.37665535869914 | -25.8893446413008 | 3505.42 | -0.04368955744090885 | -0.007246465164109244
Net revenue/hl | 326.3607785678516 | 18.83932582308182 | -4.080810674812483 | 4.605976528408121 | 345.725270244529 | 0.05933461662168305 | 0.01334291754208721
[NAME] | -1154.888 | 50.526 | 12.35118673789891 | 45.64981326210121 | -1046.361 | -0.09397188298778758 | -0.04133591454803878
[NAME]/hl | -102.8245144171881 | -3.881162400024479 | 1.218147147217948 | 2.289214062068723 | -103.1983156079259 | 0.003635331446557588 | -0.02145353584130448
Gross profit | 2510.679 | -42.355 | -29.02546862080023 | 19.76046862080041 | 2459.059 | -0.02056017515580444 | 0.008005621879785802
Gross margin | 0.6849360549131963 | 0 | 0 | 0 | 0.7015019598222182 | 170 | 110
SG&A excl. deprec.&amort. | -1141.929 | 2.574 | 13.41902428626652 | -9.864024286266464 | -1135.8 | -0.005367233864802534 | 0.008657551234045985
SG&A deprec.&amort. | -48.996 | 0 | 0.4811974200740963 | 7.83280257992591 | -40.682 | -0.1696873214139931 | -0.1598661641751553
SG&A total | -1190.925 | 2.574 | 13.90022170634081 | -2.031221706340554 | -1176.482 | -0.01212754791443649 | 0.001709277567268049
Other operating income/expenses | 1.537 | 0 | -0.1065400401550756 | 7.839540040155075 | 9.27 | nm | nm
Normalized EBIT | 1321.291 | -39.781 | -15.2317869546145 | 25.56878695461494 | 1291.847 | -0.02228426591871113 | 0.01995207759175889
Normalized EBIT margin | 0.3604601961988418 | 0 | 0 | 0 | 0.3685284502285033 | 80 | 100
Normalized EBITDA | 1508.062 | -39.781 | -17.16312581422557 | 4.266125814225618 | 1455.384 | -0.03493092459063352 | 0.002905524088526391
Normalized EBITDA margin | 0.4114130228693132 | 0 | 0 | 0 | 0.4151810624689766 | 40 | 40
Spreadsheet: 1de9f578-572f-4e60-94ee-cdc9b0b32d71
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LCMC | Test | LCMC | Identification, M.chelonae and M.abscessus,PCR | Id,M.chelonae and M.abcessus,PCR |  |  |  |  |  |  | **For billing purposes only |  |  |  |  |  |  | 1 | 87149 |  |  |  |  | Rochester
LCMC | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 3 | 1 | 10 | 19 | 34 | 29 | 32 | 3 | 131
Cap/Floor | 8 | 1 | 2 | 22 | 41 | 11 | 4 | 0 | 89
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 15 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 19
Fixed-Float | 128 | 127 | 324 | 702 | 3977 | 3877 | 4396 | 716 | 14247
FRA | 100 | 266 | 583 | 529 | 7 | 0 | 0 | 0 | 1485
Inflation | 1 | 2 | 14 | 12 | 61 | 10 | 14 | 10 | 124
OIS | 38 | 22 | 49 | 33 | 46 | 37 | 7 | 0 | 232
Swaption | 0 | 0 | 0 | 32 | 188 | 165 | 290 | 133 | 808
TOTAL
Spreadsheet: 152532d1335427944-macro-for-charting-book1
Sheet: Sheet1

2012-01-05 00:00:00 | 0.315
2012-01-06 00:00:00 | 0.315
2012-01-09 00:00:00 | 0.315
2012-01-10 00:00:00 | 0.315
2012-01-11 00:00:00 | 0.32
2012-01-12 00:00:00 | 0.32
2012-01-13 00:00:00 | 0.315
2012-01-16 00:00:00 | 0.33
2012-01-17 00:00:00 | 0.33
2012-01-18 00:00:00 | 0.335
2012-01-19 00:00:00 | 0.325
2012-01-20 00:00:00 | 0.33
2012-01-25 00:00:00 | 0.33
2012-01-26 00:00:00 | 0.335
2012-01-27 00:00:00 | 0.355
2012-01-30 00:00:00 | 0.36
2012-01-31 00:00:00 | 0.355
2012-02-01 00:00:00 | 0.36
2012-02-02 00:00:00 | 0.38
2012-02-03 00:00:00 | 0.365
2012-02-04 00:00:00
2012-02-05 00:00:00
2012-02-06 00:00:00
2012-02-07 00:00:00
2012-02-08 00:00:00
2012-02-09 00:00:00
2012-02-10 00:00:00
2012-02-11 00:00:00
2012-02-12 00:00:00
Spreadsheet: 377084d1423784052-calculate-the-home-win-streak-for-a-team-win-streak-2
Sheet: Sheet1

 |  |  |  |  |  | Venue |  |  |  | Home | OPP |  | W/L |  |  |  | Home Rec | Home Streak | SHG
 |  |  |  |  |  | vs |  |  |  | 73 | 42
 |  |  |  |  |  | vs |  |  |  | 81 | 74
 |  |  |  |  |  | vs |  |  |  | 85 | 41
 |  |  |  |  |  | vs |  |  |  | 85 | 50
 |  |  |  |  |  | vs |  |  |  | 107 | 74
 |  |  |  |  |  | vs |  |  |  | 80 | 47
 |  |  |  |  |  | vs |  |  |  | 85 | 63
 |  |  |  |  |  | vs |  |  |  | 64 | 35
 |  |  |  |  |  | @ |  |  |  | 67 | 78
 |  |  |  |  |  | vs |  |  |  | 82 | 58
 |  |  |  |  |  | @ |  |  |  | 74 | 66
 |  |  |  |  |  | vs |  |  |  | 70 | 50
 |  |  |  |  |  | vs |  |  |  | 69 | 40
 |  |  |  |  |  | vs |  |  |  | 87 | 54
 |  |  |  |  |  | @ |  |  |  | 70 | 74
 |  |  |  |  |  | vs |  |  |  | 70 | 40
 |  |  |  |  |  | @ |  |  |  | 76 | 47
 |  |  |  |  |  | @ |  |  |  | 74 | 79
 |  |  |  |  |  | vs |  |  |  | 80 | 63
 |  |  |  |  |  | @ |  |  |  | 79 | 45
 |  |  |  |  |  | vs |  |  |  | 78 | 54
 |  |  |  |  |  | vs |  |  |  | 64 | 49
 |  |  |  |  |  | @ |  |  |  | 58 | 52
 |  |  |  |  |  | vs |  |  |  | 87 | 84
 |  |  |  |  |  | vs |  |  |  | 48 | 58
 |  |  |  |  |  | @ |  |  |  | 78 | 68
 |  |  |  |  |  | @ |  |  |  | 51 | 56
 |  |  |  |  |  | vs |  |  |  | 83 | 67
 |  |  |  |  |  | vs |  |  |  | 60 | 63
 |  |  |  |  |  | @ |  |  |  | 75 | 73
Spreadsheet: 140898d1328933873-returning-borrowed-amounts-borrowed-amounts2
Sheet: Sheet1

Borrower | Amount ($) | Start Date | Repay Date | # of days | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
[NAME] | 100 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
[NAME] | 120 | 2012-01-04 00:00:00 | 2012-01-06 00:00:00
[NAME] | 150 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00
A manual input will be made in cells ranging from B2 to D4,
Diagram 2
Borrower | Amount ($) | Start Date | Repay Date | # of days | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
[NAME] | 100 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 |  |  |  | 100 | 100
[NAME] | 120 | 2012-01-04 00:00:00 | 2012-01-06 00:00:00 |  |  | 120 | 120 | 120
[NAME] | 150 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 |  | 150 | 150
I wish for each of the 12 cells in range F12 to I14 have a function embedded which will automatically find, return and populate the values as shown in Diagram 2.
Diagram 2 is the end result I am seeking, which will be calculated automatically with a special function.  What is this function?  PLEASE HELP.
Spreadsheet: 755079d1636650824-countrows-help-customer-count
Sheet: Problem

[NAME] | Exit |  |  |  | Row Labels | Active Customers
2019-09-01 02:28:00 | 2019-09-01 03:26:00 |  |  |  | 02:00:00 | 1
2019-09-01 07:55:00 | 2019-09-01 14:43:00 |  |  |  | 03:00:00 | 1
2019-09-01 06:46:00 | 2019-09-01 09:34:00 |  |  |  | 04:00:00 | 1
2019-09-01 06:04:00 | 2019-09-01 08:00:00 |  |  |  | 05:00:00 | 1
2019-09-01 04:31:00 | 2019-09-01 05:03:00 |  |  |  | 06:00:00 | 3
2019-09-01 06:02:00 | 2019-09-01 10:04:00 |  |  |  | 07:00:00 | 5
2019-09-01 07:37:00 | 2019-09-01 09:05:00 |  |  |  | 08:00:00 | 5
2019-09-01 12:34:00 | 2019-09-01 16:09:00 |  |  |  | 09:00:00 | 5
2019-09-01 09:26:00 | 2019-09-01 12:00:00 |  |  |  | 10:00:00 | 3
2019-09-01 23:22:00 | 2019-09-02 02:05:00 |  |  |  | 11:00:00 | 2
 |  |  |  |  | 12:00:00 | 3
 |  |  |  |  | 13:00:00 | 2
 |  |  |  |  | 14:00:00 | 2
 |  |  |  |  | 15:00:00 | 1
 |  |  |  |  | 16:00:00 | 1
 |  |  |  |  | Grand Total | 10
Spreadsheet: 839833d1692261534-using-if-function-or-similar-function-rebar-counting-at-p2
Sheet: Sheet2

BANDARANAYAKE INTERNATIONAL AIRPORT DEVELEOPMENT - Phase II Stage 2 Package A
REBAR WEIGHING AT PIER 2
Truck No | Empt. Wgt. ([NAME]) | Truck No | Empt. Wgt. ([NAME]) | Truck No | Empt. Wgt. ([NAME]) | Truck No | Empt. Wgt. ([NAME])
LY-3618 | 15300 | LY-4098 | 17290 | LY-3486 | 13470 | [NAME] | 13010
Date | Location | [NAME]. | Ticket No. | weight with rebar(kg) | Weight of rebar (kg) |  | Remarks
15.08.2023 | P2 | Ly-3618 | 15743 | 44180
 |  | LY-3486 | 15744 | 42730
 |  | LY-4098 | 15746 | 33130
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-11-P-0147

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
[NAME] |  |  | 1P
[NAME] |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 715798d1611868184-year-to-date-comparison-formula-excel-1
Sheet: Sheet1

 | Es | OM | NV | OV | TM | 2020 Total | Average | Year to Date Average
2020-01-01 00:00:00 | 38 | 59 | 11 | 922 | 0
2020-02-01 00:00:00 | 69 | 41 | 10 | 1026 | 0
2020-03-01 00:00:00 | 52 | 22 | 12 | 796 | 7
2020-04-01 00:00:00 | 33 | 22 | 9 | 347 | 29
2020-05-01 00:00:00 | 94 | 44 | 83 | 409 | 32
2020-06-01 00:00:00 | 48 | 23 | 198 | 1060 | 138
2020-07-01 00:00:00 | 86 | 22 | 243 | 1550 | 97
2020-08-01 00:00:00 | 53 | 28 | 24 | 785 | 72
2020-09-01 00:00:00 | 81 | 25 | 48 | 665 | 43
2020-10-01 00:00:00 | 70 | 21 | 142 | 796 | 24
2020-11-01 00:00:00 | 33 | 23 | 112 | 781 | 37
2020-12-01 00:00:00 | 44 | 17 | 142 | 1147 | 111