tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 134149d1325054677-conditional-formatting-if-function-demo-all-patients-bvj-
Sheet: Sheet1

 | NAME | MRN NUMBER | RED TEAM | GREEN TEAM | CLINICIAN 1 | CLINICIAN 2 | CLINICIAN 3 | CLINICIAN 4 | CLINICIAN 5 | CLINICIAN 6 | CLINICIAN 7 | CLINICIAN 8 | CLINICIAN 9 | CLINICIAN 10 | CLINICIAN 11 | CLINICIAN 12 | CLINICIAN 13 | CLINICIAN 14 | passed date | any date
 | NAME2 | 72979 | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | NAME3 | 63594 |  | X | 2011-12-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
 | NAME4 | 11593 | X |  |  |  | 2011-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | NAME5 | 29977 | X |  |  |  |  |  |  |  |  | 2011-05-08 00:00:00 |  |  |  |  |  |  | 1 | 1
 | NAME6 | 75479 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 49708d1249035305-how-to-recalculate-with-drop-down-menu-dependentdropboxes
Sheet: Sheet2

 | Option 1 | Option 2 | Option 3
Tea | 0.5 | 0.1 | 0.1
Coffee | 0.1 | 0.2 | 0.1
Hot Chocolate | 0.1 | 0.2 | 0.05
Milkshake | 0.1 | 0.2 | 0.1
Water | 0.2 | 0.1 | 0.3
Total |  |  |  |  |  | A2:A6 has been named Drinks
 |  |  |  |  |  | B2:[NAME] has been named Option1
 |  |  |  |  |  | C2:C6 has been named Option2
 |  |  |  |  |  | D2:D6 has been named Option3
Spreadsheet: 777058d1650107269-using-multiple-conditions-using-and-and-if-formula-final-v1
Sheet: Fee Slabs

Size tier |  | [NAME] dimension |  | Shipping weight ¹ |  | Fulfillment fee per unit ²
 |  |  |  |  |  |  |  | Results
 |  |  |  |  |  |  |  | HEIGHT | LENGTH | WIDTH /THICK NESS | Unit Weight | Result | Expected Result
 |  |  |  | 0 |  | 2.92 |  | 15 | 12 | 0.75 | 0.375 |  | 2.92
Small standard |  | 15" x 12" x 0.75" |  | 0.376 |  | 3.07 |  | 15 | 12 | 1 | 0.375 |  | 3.54
 |  |  |  | 0.751 |  | 3.59 |  | 18 | 12 | 8 | 0.375 |  | 3.54
 |  |  |  | 0 |  | 3.54 |  | 18 | 14 | 8 | 0.375 |  | 3.54
 |  |  |  | 0.376 |  | 3.77 |  | 10 | 6 | 0.25 | 0.375 |  | 2.92
 |  |  |  | 0.751 |  | 4.52 |  | 18 | 14 | 8 | 1 |  | 4.52
 |  |  |  | 1.001 |  | 5.14 |  | 18 | 14 | 8 | 2 |  | 5.14
Large standard |  | 18” x 14” x 8” |  | 2.001 |  | 5.79 |  | 18 | 14 | 8 | 3 |  | 5.79
 |  |  |  | 3.001 |  | $6.13 + $0.30/lb above first 3 lbs
Spreadsheet: 2a7f11a1-1af9-4f4a-af18-afa180042c6e
Sheet: Sheet1

Release: U.S. Import and Export Price Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=188
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-09 8:53 AM CST
 | Real-Time | Period
Name: | Start | End
U.S. Import and Export Price Indexes | 2010-03-16 00:00:00 | Current
Link:
http://www.bls.gov/mxp/ | 2010-03-16 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-03-16 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-03-16 00:00:00
2010-04-13 00:00:00
2010-05-13 00:00:00
2010-06-15 00:00:00
2010-07-14 00:00:00
2010-08-12 00:00:00
2010-09-15 00:00:00
2010-10-13 00:00:00
2010-11-10 00:00:00
2010-12-10 00:00:00
2011-01-12 00:00:00
2011-02-15 00:00:00
2011-03-15 00:00:00
2011-04-12 00:00:00
2011-05-10 00:00:00
2011-06-10 00:00:00
2011-07-13 00:00:00
2011-08-16 00:00:00
2011-09-13 00:00:00
2011-10-14 00:00:00
2011-11-10 00:00:00
2011-12-14 00:00:00
2012-01-13 00:00:00
2012-02-14 00:00:00
2012-03-14 00:00:00
2012-04-11 00:00:00
2012-05-10 00:00:00
2012-06-12 00:00:00
2012-07-12 00:00:00
2012-08-10 00:00:00
2012-09-12 00:00:00
2012-10-11 00:00:00
2012-11-09 00:00:00
2012-12-12 00:00:00
2013-01-11 00:00:00
2013-02-13 00:00:00
2013-03-13 00:00:00
2013-04-11 00:00:00
2013-05-14 00:00:00
2013-06-13 00:00:00
2013-07-11 00:00:00
2013-08-13 00:00:00
2013-09-12 00:00:00
2013-10-23 00:00:00
2013-11-15 00:00:00
Spreadsheet: 733119d1621406466-row-totals-per-column-using-dynamic-arrays-total-rows-with-dynamic-array
Sheet: Sheet1

 |  | # of years | 10
 |  | # of expenses | 5
 |  |  |  | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029
 |  | Total
 |  |  |  | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029
 |  | 2 | 4040 | 4042 | 4044 | 4046 | 4048 | 4050 | 4052 | 4054 | 4056 | 4058
 |  | 3 | 6060 | 6063 | 6066 | 6069 | 6072 | 6075 | 6078 | 6081 | 6084 | 6087
 |  | 4 | 8080 | 8084 | 8088 | 8092 | 8096 | 8100 | 8104 | 8108 | 8112 | 8116
 |  | 5 | 10100 | 10105 | 10110 | 10115 | 10120 | 10125 | 10130 | 10135 | 10140 | 10145
Spreadsheet: 148637d1333489386-pivot-table-editting-options-example-2
Sheet: Sheet2

Street | (All)
City | (All)
State | (All)
Zip | (All)
Store # | (All)
Row Labels | Sum of qty
7 - 1 abc roadgeneric [NAME] | 1
9 - 2 abc roadgeneric [NAME] | 2
11 - 3 abc roadgeneric [NAME] | 3
14 - 4 abc roadgeneric [NAME] | 4
23 - 5 abc roadgeneric [NAME] | 5
24 - 6 abc roadgeneric [NAME] | 6
25 - 7 abc roadgeneric [NAME] | 7
26 - 8 abc roadgeneric [NAME] | 8
32 - 9 abc roadgeneric [NAME] | 9
34 - 10 abc roadgeneric [NAME] | 10
35 - 11 abc roadgeneric [NAME] | 11
36 - 12 abc roadgeneric [NAME] | 12
38 - 13 abc roadgeneric [NAME] | 13
41 - 14 abc roadgeneric [NAME] | 14
44 - 15 abc roadgeneric [NAME] | 15
45 - 16 abc roadgeneric [NAME] | 16
47 - 17 abc roadgeneric [NAME] | 17
48 - 18 abc roadgeneric [NAME] | 18
49 - 19 abc roadgeneric [NAME] | 19
51 - 20 abc roadgeneric [NAME] | 20
55 - 21 abc roadgeneric [NAME] | 21
59 - 22 abc roadgeneric [NAME] | 22
60 - 23 abc roadgeneric [NAME] | 23
62 - 24 abc roadgeneric [NAME] | 24
63 - 25 abc roadgeneric [NAME] | 25
64 - 26 abc roadgeneric [NAME] | 26
65 - 27 abc roadgeneric [NAME] | 27
66 - 28 abc roadgeneric [NAME] | 28
67 - 29 abc roadgeneric [NAME] | 29
68 - 30 abc roadgeneric [NAME] | 30
71 - 31 abc roadgeneric [NAME] | 31
72 - 32 abc roadgeneric [NAME] | 32
75 - 33 abc roadgeneric [NAME] | 33
76 - 34 abc roadgeneric [NAME] | 34
80 - 35 abc roadgeneric [NAME] | 35
83 - 36 abc roadgeneric [NAME] | 36
84 - 37 abc roadgeneric [NAME] | 37
85 - 38 abc roadgeneric [NAME] | 38
86 - 39 abc roadgeneric [NAME] | 39
87 - 40 abc roadgeneric [NAME] | 40
88 - 41 abc roadgeneric [NAME] | 41
91 - 42 abc roadgeneric [NAME] | 42
101 - 43 abc roadgeneric [NAME] | 43
102 - 44 abc roadgeneric [NAME] | 44
103 - 45 abc roadgeneric [NAME] | 45
106 - 46 abc roadgeneric [NAME] | 46
107 - 47 abc roadgeneric [NAME] | 47
108 - 48 abc roadgeneric [NAME] | 48
111 - 49 abc roadgeneric [NAME] | 49
113 - 50 abc roadgeneric [NAME] | 50
117 - 51 abc roadgeneric [NAME] | 51
120 - 52 abc roadgeneric [NAME] | 52
Grand Total | 1378
Spreadsheet: 28334d1222419542-updating-amounts-depending-on-the-date-input-test
Sheet: Sheet1

Name | Start Date | Salary | [NAME] | Date |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Employee A | 2008-01-01 00:00:00 | 30000 | 3000 | 2008-07-01 00:00:00 |  | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 30000
Employee B | 2008-01-01 00:00:00 | 50000 | 5000 | 2008-06-01 00:00:00 |  | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 4166.666666666667 | 49999.99999999999
Employee C | 2008-01-01 00:00:00 | 70000 | 7000 | 2008-10-01 00:00:00 |  | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 5833.333333333333 | 70000.00000000001
TOTAL SALARY |  | 150000 | 15000 |  |  | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 150000
Spreadsheet: 96532d1295912705-transpose-multiple-segments-sample
Sheet: Sheet1

 | Current |  |  | Needed
Data1 | ID1 |  |  | Data1 | Data2 | Data3
Data2 | ID2 |  |  | ID1 | ID2 | ID3 |  | [NAME], so confirm with ctrl+shift+enter
Data3 | ID3 |  |  | ID1A | ID2A | ID3A
Data1 | ID1A |  |  | ID1B | ID2B | ID3B |  | enter formula in E3, then drag down and sideways
Data2 | ID2A
Data3 | ID3A |  |  |  |  |  |  | rng1 and [NAME] are dynamic named ranges = they grow as your data table grows
Data1 | ID1B
Data2 | ID2B
Data3 | ID3B
Spreadsheet: 266458d1379617782-formula-for-each-month-and-number-count-for-exceptions-setup-exception-tracking-by-ae-example
Sheet: Combined Data

 | March | April | May | June | July | August | September | October | November | December
# of Exceptions
# of Submissions
% of exceptions
AE % share of total exceptions for month | March | April | May | June | July | August | September | October | November | December
Abdul | 0 | 0 | 0.04 | 0.0353
[NAME] | 0 | 0 | 0.16 | 0.0353
[NAME] | 0.5 | 0.2941 | 0.04 | 0.1294
[NAME] | 0 | 0 | 0.08 | 0.0471
[NAME] | 0 | 0 | 0.08 | 0.0353
Dirk | 0 | 0 | 0 | 0.0588
Jessica | 0.3333 | 0 | 0.08 | 0.0941
[NAME] | 0 | 0.0588 | 0.08 | 0.0824
[NAME] | 0 | 0.0588 | 0.08 | 0.1765
[NAME] | 0 | 0.1176 | 0.08 | 0.0706 | 0
Kris | 0 | 0 | 0 | 0.0118
[NAME] | 0 | 0.0588 | 0.16 | 0.1176
[NAME] | 0 | 0.2353 | 0.08 | 0.0471
[NAME] | 0 | 0.1176 | 0.04 | 0.0118
Vince | 0.1667 | 0.0588 | 0 | 0.0471
AE total submissions for month | March | April | May | June | July | August | September | October | November | December
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
Average submission count
AE exception % of their individual submissions | March | April | May | June | July | August | September | October | November | December
Abdul | 0 | 0
[NAME] | 0 | 0
[NAME]
[NAME] | 0 | 0
[NAME] | 0 | 0
Dirk | 0 | 0 | 0
Jessica |  | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
Kris | 0 | 0 | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
Vince |  |  | 0
Average exception %
Exception Type by Frequency |  |  |  |  | July | August | September | October | November | December
missing prelim or >45 |  |  |  |  | 15 | 7
pay stub >30 |  |  |  |  | 15 | 8
asset >45 |  |  |  |  | 15 | 19
asset missing pages or missing entirely |  |  |  |  | 13 | 6
missing [NAME] |  |  |  |  | 9 | 2
missing 4506 |  |  |  |  | 3 | 1
credit >45 |  |  |  |  | 0 | 2
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 11c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | <100 | <100 | <100 |  |  |  |  |  |  | <100
FRA |  |  | 578 | <100 |  | 418 |  | 342 |  | 1338
IRS- [NAME] | 691 | 584 | 334 | <100 |  | <100 | <100 | 365 | 370 | 2344
OIS |  | <100 | <100 |  |  |  |  |  |  | <100
VNS
Zero Coupon
TOTAL | 691 | 584 | 912 | <100 |  | 418 | <100 | 707 | 370 | 3682
Estimated swap transaction volumes, week ending January 25, by product type and major currency (millions of USD), all participant types, cleared and uncleared.
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 Data Dictionary for product descriptions.
**See Data Dictionary for major currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 5216b0e6-2a72-46a8-9351-26bd72622f16
Sheet: New Table 3

Table 3
Rail Deliveries to Port (carloads)1
 | Mississippi |  | Pacific | Atlantic & |  |  | Cross-Border
Week ending | Gulf | Texas Gulf | Northwest | East Gulf | Total | Week ending | Mexico3
10/15/2014p |  |  |  |  |  | 2014-10-11 00:00:00
10/08/2014r |  |  |  |  |  | 2014-10-04 00:00:00
2014 YTDr |  |  |  |  |  | 2014 YTD
2013 YTDr |  |  |  |  |  | 2013 YTD
2014 YTD as % of 2013 YTD |  |  |  |  |  | % change YTD
Last 4 weeks as % of 20132 |  |  |  |  |  | Last 4wks % 2013
Last 4 weeks as % of 4-year avg.2 |  |  |  |  |  | Last 4wks % 4 yr
Total 2013 |  |  |  |  |  | Total 2013 | 70298
Total 2012 |  |  |  |  |  | Total 2012 | 92008
1 Data is incomplete as it is voluntarily provided
2 Compared with same 4-weeks in 2013 and prior 4-year average.
3 Cross- border weekly data is aproximately 15 percent below the Association of American Railroads reported weekly carloads received by Mexican railroads
to reflect switching between KCSM and FerroMex.
YTD = year-to-date; p = preliminary data; r = revised data; n/a = not available
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 37882d1235995213-sorting-of-date-column-copy-of-date
Sheet: Sheet1

 | want to sort |  | want the diff betwn
 | this column |  | PR date and Today dt.
PR no | PR date | Today Date | Diff | Item Code | Item Description
1400002808 | 2008-12-25 00:00:00 | 25/02/2009 | 67 | R-100984 | CALIBRATION OF HAND TACHOMETER
1400002835 | 2009-01-10 00:00:00 | 25/02/2009 | 51 | R-100309 | REPLACEMENT COMPR., AW-1500
1400002823 | 2009-01-18 00:00:00 | 25/02/2009 | 43 | R-101125 | REPAIRING OF THRUST BRAKE MOTOR
1400002860 | 2009-01-22 00:00:00 | 25/02/2009 | 39 | R-101169 | REPARING OF 280 KW CONTROL CARD
1400002892 | 2009-01-30 00:00:00 | 25/02/2009 | 31 | R-101008 | RECONDITIONING/REPAIRING  OF CENTRIFUGE
1400002892 | 2009-01-30 00:00:00 | 25/02/2009 | 31 | R-100398 | DRIVE RATING OF 5 HP
1400002862 | 2009-02-01 00:00:00 | 25/02/2009 | 29 | [NAME] | REWIND CEILING FAN NEW MODEL
1400002966 | 2009-02-07 00:00:00 | 25/02/2009 | 23 | [NAME] | REPAIR OF DEMOLITION HAMMER -H60MB/H60MA
1400002927 | 2009-02-10 00:00:00 | 25/02/2009 | 20 | R-100262 | GAS CHARGING SAS
1400002897 | 2009-02-14 00:00:00 | 25/02/2009 | 16 | R-101139 | REPARING OF OP-7 D.P  OPERATOR( DISPLAY
1400003002 | 2009-02-25 00:00:00 | 25/02/2009 | 5 | R-100354 | LEVEL TRANSMITTER - EMERSON MAKE
1400002995 | 2009-02-25 00:00:00 | 25/02/2009 | 5 | R-100762 | REPAIR OF COMPUTER HARD DISK
1400002920 | 2009-02-25 00:00:00 | 25/02/2009 | 5 | R-101165 | REPAIRING OF DIGITAL INDICATOR
1400003007 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | [NAME] | REPAIR OF DEMOLITION HAMMER -H60MB/H60MA
1400003007 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | R-100745 | REPAIR OF DEMOLITION HAMMER -H90SE
1400003007 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | R-101155 | REPAIRING OF WEIGHT INDICATOR-WB
1400003007 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | R-100981 | REPAIRING OF ELECTRONI GA -30 REGULATOR
1400003000 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | [NAME] | REPAIRING OF OPACITY MONITOR MICRO PCB 1
1400002936 | 2009-02-28 00:00:00 | 25/02/2009 | 2 | R-100375 | CONTROL VALVE - VALFLO MAKE, SIZE: 6"
1400002960 | 2009-03-05 00:00:00 | 25/02/2009 | -3 | R-100745 | REPAIR OF DEMOLITION HAMMER -H90SE
1400002964 | 2009-03-07 00:00:00 | 25/02/2009 | -5 | R-100259 | DISMANTIE/ASSEMBLE (SAS 1.5 T)
1400003013 | 2009-03-10 00:00:00 | 25/02/2009 | -8 | [NAME] | LEAK &  PRESSURE TEST (A.C)
1400002967 | 2009-03-10 00:00:00 | 25/02/2009 | -8 | R-100193 | WINDOW AC SERVICEING CHARGES / CALL/AC
1400003018 | 2009-03-11 00:00:00 | 25/02/2009 | -9 | [NAME] | DRIVE RATING OF 40 HP
1400002990 | 2009-03-16 00:00:00 | 25/02/2009 | -14 | [NAME] | REPAIRING OF SMPS - POWER SUPPLY
1400002999 | 2009-03-18 00:00:00 | 25/02/2009 | -16 | [NAME] | REPAIRING OF BALANCING OF CENTRI. BOWL
1400002998 | 2009-03-18 00:00:00 | 25/02/2009 | -16 | R-100566 | REPAIR OF  PLC AB MAKE TYPE-MICROLOGIC
1400003012 | 2009-03-25 00:00:00 | 25/02/2009 | -23 | R-101134 | REPAIRING OF GATE DRIVER CARD OF 2 * 20
1400003012 | 2009-03-25 00:00:00 | 25/02/2009 | -23 | R-101139 | REPARING OF OP-7 D.P  OPERATOR( DISPLAY
1400002372 | 2009-08-15 00:00:00 | 25/02/2009 | -166 | R-100336 | MULTILOOP CONTROLLER, MODEL-AC-20
Spreadsheet: 36480d1234364148-invoice-address-query-vlookup-dropdown-list-box
Sheet: Invoice

Name | Address | City | State | Zip | Amount Owed
[NAME]
 | A2 is a drop-down
TEST IT | First goto the Names sheet and name the range as per instructions.
 | In this sheet in Click in A2, Click the Data tab and in the data tools Click Data Validation.
 | In the [NAME]: change it to list.  In the Source: type in  =test, this is what I named the range in the Names sheet.  The = is important
 | When you choose a name from the dropdown list the value is placed in cell A2.  We then use that value to do a [NAME] to find the other values.
The [NAME] goes like this,  =Vlookup(Value to lookup,[NAME],Column to bring value back from,False means exact match)
=VLOOKUP($A$2,Names!$A$2:$F$12,2,FALSE)
This is the real formula from B2.  It is going to look for the value you choose in A2.  It is going to look in the range A2 through F12, you must include all cells that you might wnt to get a value from.  When it finds a match it is going to look in the second column, the first being the names, False means that the Value from A2 must be exact match.
Spreadsheet: 797728d1664102548-getting-a-specific-value-for-the-current-month-sample
Sheet: Budget-USD

Monthly Budget
Month | Net Closing Balance |  | Net Income Summary |  |  |  | Net Expense Summary
 | General-Funds | Emergency-Funds | Regular | Others | Emergency | Net-Income | Regular | Events | Emergency | Net-Expenses
2022-07-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2022-08-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2022-09-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2022-10-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2022-11-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2022-12-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-01-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-02-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-03-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-04-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-05-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
2023-06-01 00:00:00 |  |  | 100 | 0 |  |  | 25 | 0 | 0
Spreadsheet: 684939d1593622934-sumproduct-returning-value-error-supervisortest
Sheet: Banks

For:
Activity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | Finals | Prelims
Month
2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 | 2020-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | 2020-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00 | 2020-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00 | 2020-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | 2020-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00 | 2020-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 2021-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | 2021-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | 2021-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-06-30 00:00:00
Quarter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-30 00:00:00 | Quarter 1
1st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-31 00:00:00 | Quarter 2
2nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-31 00:00:00 | Quarter 3
3rd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-30 00:00:00 | Quarter 4
4th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00 |  | Quarter 1
Year
Spreadsheet: 265222d1379111070-conditional-formatting-on-due-date-conditionalformattingduedate
Sheet: Sheet1

 | Training 1 | Training 2 | Training 3 | Training 4 | Training 5
[NAME] | 2012-09-04 00:00:00 | 2013-09-01 00:00:00 | 2012-09-27 00:00:00 | 2012-09-27 00:00:00
colon | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00
[NAME] | 2012-09-29 00:00:00 | 2012-09-03 00:00:00 | 2012-09-29 00:00:00 |  | 2012-09-29 00:00:00
Ba | 2013-04-29 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00
Spreadsheet: 880257d1727880703-counting-occurences-between-a-certain-value-based-upon-unique-identifier-test-score-interval
Sheet: Sheet1

Scenario - In Office30, I want to calculate how many test iterations have occurred between when a student first fell below an initial A and when they got their next A. I will subsequently calculate the average number of test iterations it takes for a person to get back to an A after  failing to achieve an A. I have the data in the vertical view (many other fields), but these are the key aspects (I think).  It is important to note, that one student (student 6 below) may "perpetually" bounce between an A and a B.  I would like to be able to account for each instance that occurs for that one student.
Vertical Data View |  |  |  |  | Horizontal Data View |  | Test Iteration #
Student# | Test Iteration # | Grade |  |  |  | Student | 1 | 2 | 3 | 4 | 5 | 6 |  | Remarks about this data
1 | 1 | A |  |  |  | 1 | A | B | A | - | - | - |  | Test1 - A.  Test 2 the student fell below an A, Test 3 the student got an A.  Test iterations = 1
1 | 2 | B |  |  |  | 2 | B | A | B | B | A | - |  | Test2 - A. Test 3 the student fell below an A, Test 5 the student got an A.  Test iterations = 2
1 | 3 | A |  |  |  | 3 | B | B | B | B | B | - |  | Student has never received an A.  Test iterations = 0
2 | 1 | B |  |  |  | 4 | A | A | A | A | A | - |  | Student has never received less than an A.  Test iterations = 0
2 | 2 | A |  |  |  | 5 | A | B | B | A | B | B |  | Test1 - A. Test 2 the student fell below an A, Test 4 the student got an A.  Test iterations = 2. Test 5, the student fell below an A.  But there are not enough tests to determine if the student ever increased back to an A.  Test iterations = unknown.
2 | 3 | B |  |  |  | 6 | A | B | A | B | B | A |  | Test1 - A.  Test2 the student fell below an A. Test 3 - A.  Test iterations = 1.  Test4, the student fell below an A.  Test 6 -  A.  Test iterations = 2
2 | 4 | B
2 | 5 | A
3 | 1 | B |  |  |  |  | 1
3 | 2 | B |  |  |  | 2 | 1,2
3 | 3 | B |  |  |  | 3
3 | 4 | B |  |  |  | 4
3 | 5 | B |  |  |  | 5 | 2
4 | 1 | A |  |  |  | 6 | 1,2
4 | 2 | A
4 | 3 | A
4 | 4 | A
4 | 5 | A
5 | 1 | A
5 | 2 | B
5 | 3 | B
5 | 4 | A
5 | 5 | B
5 | 6 | B
6 | 1 | A
6 | 2 | B
6 | 3 | A
6 | 4 | B
6 | 5 | B
6 | 6 | A
Spreadsheet: 786059d1656953554-help-with-countifs-and-unique-values-formula-kpi-test-data
Sheet: CS Register

Name / ID Number | Sex | 2021 Group | 2021 Groups NP
Bluebell | F | 75 | 0
[NAME] | M |  | 0 |  | Data should count cells in this column with 0
Bounty | F |  | 0 |  | And count unique values where 0 is in the other column
[NAME] | F | 75 | 0
[NAME] | F | 8 | 7 |  | Answer should be 3
Karlos | M | 41 | 0 |  | 75, 41 and 31
Katerina | F | 41 | 0
Kristoff | M | 8 | 7
[NAME] | M | 75 | 0
Mercury | M | 31 | 0
Violet | F | 8 | 7
Spreadsheet: 25425d1216734380-using-a-list-to-generate-different-data-for-each-choice-book3
Sheet: Sheet2

Service technicians
[NAME]
[NAME]
Monty Fant
[NAME]
[NAME]
Troy Pater
[NAME] | 115 | 172.5 | 172.5 | 230 | 230
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 224536524 | 94151888 | 24884042 | 46000713
FRA | 98708642 | 14660258 | 6004725 | 3155315
OIS | 56248653 | 14431416 | 7854471 | 5995807
OTHER* | 12694198 | 67765990 | 838299 | 22147445
TOTAL
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.