tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675581d1588357133-show-total-spending-for-current-month-book1-3-sumproduct-today-month
Sheet: Sheet1

Invoice Sr .No | Date | Amount spend  (Inr)
1 | 2019-04-22 00:00:00 | 1000
2 | 2020-04-22 00:00:00 | 1000
3 | 2020-04-22 00:00:00 | 1000
4 | 2020-04-24 00:00:00 | 2000
5 | 2020-05-06 00:00:00 | 2000
6 | 2020-03-24 00:00:00 | 2000
7 | 2020-12-18 00:00:00 | 1500
8 | 2020-04-01 00:00:00 | 3000
9 | 2020-04-22 00:00:00 | 1000
10 | 2020-04-21 00:00:00 | 2000
11 | 2020-04-24 00:00:00 | 2000
12 | 2020-05-06 00:00:00 | 2000
13 | 2020-03-24 00:00:00 | 1500 |  |  | I WANT TOTAL SPENDING OF CURRENT MONTH AUTOMATICALLY
14 | 2019-12-18 00:00:00 | 2000 |  |  | MONTH ALSO SHOULD CHANGE AUTOMATICALLY EVERY MONTH
Spreadsheet: 773396d1647856139-matching-two-values-to-return-another-value-book1
Sheet: Raw Data

Reader | Date | Book | Pages Read | Chapters Read
[NAME] | 2022-01-01 00:00:00 | Tale of Two Cities | 6 | 1
[NAME] | 2022-01-01 00:00:00 | Lord of the Rings | 28 | 2
[NAME] | 2022-02-03 00:00:00 | Tale of Two Cities | 22 | 2
[NAME] | 2022-02-06 00:00:00 | Lord of the Rings | 12 | 1
[NAME] | 2022-02-08 00:00:00 | Lord of the Rings | 8 | 1
[NAME] | 2022-02-06 00:00:00 | Tale of Two Cities | 16 | 2
[NAME] | 2022-02-08 00:00:00 | Lord of the Rings | 3 | 1
Spreadsheet: 801316d1666171685-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-3
Sheet: Collation

Name | Position | State | Type | Done
AA | RN | SA | Var | Yes |  |  | I want to filter the ones from sheet 1, 2 & 3 that, type = new & done = yes
AB | EN | SA | New | No
AC | MR | SA | Var | Yes
AD | RN | SA | New | Yes
AE | EN | SA | New | Yes
AF | MR | WA | Var | Yes
AG | EN | WA | Var | No
AH | MR | WA | New | No
AI | RN | WA | New | No
AJ | EN | WA | New | Yes
AK | EN | WA | Var | Yes
AL | RN | NT | New | No
AM | EN | NT | New | Yes
AN | MR | NT | New | Yes
AO | EN | NT | New | No
AP | RN | NT | Var | Yes
AQ | MR | QLD | Var | No
AR | EN | QLD | New | No
AS | MR | QLD | New | No
AT | MR | QLD | New | No
BB | EN | NZ | Var | Yes
BB | MR | NZ | Var | Yes
BC | RN | NZ | New | Yes
BD | EN | NZ | New | Yes
BE | MR | NZ | New | No
BF | EN | NZ | Var | No
BG | MR | NZ | New | No
BH | RN | NZ | New | Yes
BI | EN | NZ | New | Yes
BJ | EN | NZ | New | No
BK | RN | NZ | Var | Yes
BL | EN | NZ | Var | Yes
BM | MR | NZ | New | No
BN | EN | NZ | New | Yes
BO | RN | NZ | New | No
BP | MR | NZ | Var | No
BQ | EN | NZ | Var | No
BR | MR | NZ | New | No
BS | MR | NZ | New | No
BT | MR | NZ | New | No
CC | EN | VIC | New | No
CB | EN | VIC | Var | Yes
CC | RN | VIC | New | Yes
CD | RN | VIC | New | Yes
CE | EN | VIC | Var | Yes
CF | MR | VIC | Var | No
CG | EN | VIC | New | No
CH | MR | VIC | New | No
CI | RN | ACT | New | Yes
CJ | RN | ACT | Var | Yes
CK | MR | ACT | New | No
CL | RN | ACT | New | Yes
CM | RN | ACT | New | Yes
CN | MR | ACT | New | No
CO | MR | ACT | Var | Yes
CP | RN | ACT | Var | No
CQ | MR | ACT | New | No
CR | EN | NSW | New | No
CS | RN | NSW | New | No
CT | RN | NSW | New | No
Spreadsheet: 064417c9-2134-477d-87c6-176cefe5f402
Sheet: Sheet1

<*NAME OF EVENT*> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | PILOT | Name | Unnamed: 9 | Unnamed: 10 | Number
OBSERVER   REPORT   SHEET
1. All goal and drop references must be given in eight digit coordinates |  |  |  |  |  | 2. All observed infractions should be noted and reported to the [NAME].
Date | AM/PM | Fly/Follow | [NAME]. |  | Observer name |  |  | Number | Task name |  | Number
LAUNCH |  |  |  |  |  |  | INFRINGEMENTS |  |  | Rule No | [NAME] if OK
Grid Reference |  |  | - |  |  |  | Vents |  |  | 3.1.3
Permission Obtained |  |  | YES/NO |  |  |  | Alitmeter |  |  | 3.7
Passenger(s) |  |  |  |  |  |  | Numbers |  |  | 3.8
Nationality |  |  |  |  |  |  | Vehicles |  |  | 9.5
Landowner ? |  |  |  |  |  |  | Clear launch area |  |  | 9.21
 |  |  |  |  |  |  | Clear goal area |  |  | 10.3
 |  |  |  |  |  |  | Livestock & crops |  |  | 10.6
TIMES |  |  | hh.mm |  |  |  | Collision |  |  | 10.8
Start of Launch Period |  |  |  |  |  |  | Driving |  |  | 10.11
Start of hot inflation |  |  |  |  |  |  | PZ Infringement |  |  | 7.5
Signalled ready to take off |  |  |  |  |  |  | Ground contact |  |  | 11.4,5
Launchmaster permission given |  |  |  |  |  |  | Sunset |  |  | 10.14.2
Took off |  |  |  |  |  |  | LANDING
Cleared Launch Area |  |  |  |  |  |  | Type |  |  | At will/Contest
Last Marker found |  |  |  |  |  |  | Coordinates |  |  | -
Checked in at Operations at |  |  |  |  |  |  | Time of final landing
 |  |  |  |  |  |  | Did you observe the final |  |  | YES/NO
PILOT GOAL DECLARATION |  |  |  |  |  |  | landing of assigned balloon |  |  | If NO give details.
Declaration coordinates: |  |  |  | - |  |  | Did you observe the balloon make |  |  | YES/NO
Signature |  |  |  |  |  |  | ground contact prior to landing? |  |  | If YES, give details.
 |  |  |  |  |  |  | Was there any property damage ? |  |  | YES/NO
 |  |  |  |  |  |  | Was landing site private property? |  |  | YES/NO
SIGNATURE |  |  |  |  |  |  | Was landowner contacted ? |  |  | YES/NO
Pilot: |  |  |  |  |  |  | Landowner ?
Observer:
 |  |  |  |  |  |  | Give pertinent information that is not included on a suplimentory report.
DEBRIEFER/SCORER USE ONLY
 |  |  |  |  |  | TASK NO: |  | TASK NO: |  | TASK NO:
 |  | Markers | returned |  | Goal |  | - |  | - |  | -
 |  | 1st: |  |  | 1st Marker |  | - |  | - |  | -
 |  | 2nd: |  |  | 2nd Marker |  | - |  | - |  | -
 |  | 3rd: |  |  | 3rd Marker |  | - |  | - |  | -
 |  | 4th: |  |  | Method
 | Launch |  | - |  | Distance
 | Landing |  | - |  | Penalty - Rule
 |  |  |  |  | Points
Debriefer |  |  |  |  | Result
DEBRIEFER COMMENTS:
Spreadsheet: 199983d1355382341-pivot-count-values-greater-than-zero-pivot-with-filter-gt-zero
Sheet: Data

Item | Balance
ABC | 10 |  | Balance | (Multiple Items)
ABC | 5
ABC | 2 |  | Row Labels | Count of Balance2
ABC | 0 |  | ABC | 4
ABC | 20 |  | BCD | 5
BCD | 4 |  | CDE | 4
BCD | 8 |  | Grand Total | 13
BCD | 64
BCD | 24
BCD | 15
CDE | 0
CDE | 32
CDE | 15
CDE | 48
CDE | 54
CDE | 0
CDE | 0
Spreadsheet: 144e6a30-abd5-4894-85c5-f5d13b57c16e
Sheet: Correlation

Price | Rate | Up to Down | Right to Left | Font Change | Yellow/Orange; 25% or Less | Abstract/Realistic/Else | Symmetry | Use of Gold
30 | 88 | 1 | 0 | 0 | 1 | 0 | 0 | 0
125 | 94 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | Correlation
65 | 87 | 0 | 1 | 1 | 0 | 0 | 0 | 1
22 | 84 | 1 | 0 | 0 | 1 | 2 | 0 | 1 |  |  | Price | Rate | Up to Down | Right to Left | Font Change | Yellow/Orange | Abstract/Realistic/Else | Symmetry | Use of Gold
40 | 88 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | Price | 1
60 | 92 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  | Rate | 0.7312531827277036 | 1
16 | 84 | 0 | 0 | 1 | 1 | 0 | 1 | 0 |  | Up to Down | 0.3228829088921699 | 0.2627474496278191 | 1
35 | 83 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |  | Right to Left | -0.1777664616589963 | -0.009912383839496906 | -0.1679130353150511 | 1
55 | 88 | 1 | 0 | 0 | 1 | 0 | 1 | 1 |  | Font Change | -0.1300402278445209 | -0.1162817676004218 | -0.01723625633316747 | 0.2117793624007553 | 1
22 | 84 | 0 | 0 | 1 | 1 | 0 | 0 | 1 |  | Yellow/Orange; 25% or Less | 0.1901418009579338 | 0.0950759268560028 | 0.1366798142468305 | -0.1550587310979995 | 0.07445807910499395 | 1
23 | 91 | 0 | 1 | 1 | 1 | 0 | 0 | 0 |  | Abstract/Realistic/Else | 0.1645480024420229 | 0.007734176592948327 | 0.1999216147334189 | -0.2889891365515204 | 0.009476225544736242 | 0.04656838238096485 | 1
40 | 91 | 1 | 0 | 1 | 1 | 2 | 1 | 0 |  | Symmetry | -0.09153217462233021 | -0.0480699863519056 | 0.2143377949072843 | -0.3576408488192955 | -0.2631806779839076 | -0.02571965515905423 | 0.05985502712621092 | 1
45 | 87 | 1 | 0 | 0 | 1 | 2 | 1 | 1 |  | Use of Gold | 0.04272267121644518 | -0.02771602816686447 | 0.1258809271677703 | -0.3390621034260855 | -0.1480391313659481 | -0.1579921674056184 | 0.1271919326431982 | 0.2987012987012988 | 1
17 | 83 | 0 | 0 | 0 | 1 | 2 | 1 | 1
30 | 85 | 1 | 0 | 1 | 0 | 2 | 1 | 1
35 | 92 | 1 | 1 | 1 | 0 | 0 | 0 | 0
15 | 86 | 0 | 0 | 0 | 0 | 1 | 1 | 1
35 | 88 | 0 | 0 | 0 | 0 | 0 | 1 | 1
109 | 95 | 0 | 0 | 1 | 1 | 2 | 0 | 0
21 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1
15 | 87 | 0 | 0 | 0 | 0 | 1 | 0 | 1
10 | 83 | 0 | 0 | 1 | 1 | 0 | 1 | 1
13 | 81 | 0 | 0 | 1 | 1 | 2 | 0 | 0
50 | 89 | 0 | 0 | 1 | 0 | 0 | 0 | 1
45 | 87 | 1 | 0 | 1 | 1 | 1 | 1 | 1
27 | 89 | 0 | 0 | 0 | 0 | 1 | 1 | 1
17 | 86 | 0 | 0 | 0 | 0 | 1 | 1 | 1
62 | 94 | 1 | 0 | 0 | 1 | 0 | 1 | 1
60 | 89 | 0 | 0 | 0 | 1 | 0 | 1 | 1
20 | 89 | 0 | 1 | 1 | 1 | 0 | 0 | 0
32 | 87 | 0 | 0 | 1 | 1 | 0 | 0 | 0
62 | 89 | 1 | 0 | 1 | 0 | 2 | 1 | 1
120 | 92 | 0 | 0 | 0 | 1 | 2 | 0 | 1
24 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1
29 | 84 | 0 | 0 | 1 | 1 | 2 | 1 | 0
18 | 88 | 0 | 1 | 1 | 1 | 0 | 0 | 0
48 | 91 | 0 | 0 | 0 | 1 | 0 | 1 | 0
26 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1
22 | 83 | 0 | 0 | 1 | 0 | 0 | 0 | 0
100 | 93 | 1 | 0 | 1 | 1 | 2 | 0 | 1
10 | 82 | 1 | 0 | 1 | 1 | 0 | 1 | 1
13 | 82 | 0 | 1 | 1 | 1 | 1 | 0 | 0
55 | 87 | 0 | 0 | 0 | 1 | 0 | 0 | 0
48 | 94 | 0 | 0 | 0 | 1 | 2 | 0 | 0
11 | 86 | 0 | 0 | 1 | 0 | 1 | 0 | 0
50 | 83 | 1 | 0 | 1 | 1 | 2 | 0 | 0
20 | 83 | 0 | 1 | 0 | 0 | 0 | 0 | 0
85 | 94 | 1 | 0 | 1 | 1 | 1 | 0 | 1
12 | 84 | 0 | 0 | 1 | 1 | 2 | 0 | 1
60 | 92 | 1 | 0 | 1 | 1 | 0 | 1 | 0
Spreadsheet: 862779d1710406012-looking-back-at-most-recent-better-or-worse-result-excel-help
Sheet: Records

ALL-TIME RECORDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAMES | 11
CONSECUTIVES |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME] |  |  |  | CURRENT FORM
 |  | TOTAL | TIMES |  | TOTAL | TIMES |  | TOTAL | TIMES |  |  |  |  | TOTAL | TIMES |  | TOTAL | TIMES
ALL COMPS | ALL |  | 1 |  |  | 1 | 2 |  | 1 | 2 | 3 | 4 |  |  | 1 |  |  | 1 |  |  |  | POINTS
 | HOME |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 |  |  | 1 |  |  | LEAGUE
 | AWAY |  | 1 | 2 |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1
LEAGUE ONLY | ALL |  | 1 |  |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | ALL COMPETITIONS
 | HOME |  | 1 | 2 |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  | 1 |  |  | 1
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
LONGEST RUNS |  | WITHOUT DEFEAT |  |  | WITHOUT DRAW |  |  | WITHOUT WIN |  |  |  |  |  | WITHOUT CONCEDING |  |  | WITHOUT SCORING
 |  | TOTAL | TIMES |  | TOTAL | TIMES |  | TOTAL | TIMES |  |  |  |  | TOTAL | TIMES |  | TOTAL | TIMES
ALL COMPS | ALL |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 | 2 |  | 1 |  |  | COMPARISON BETTER |  |  | MOST RECENT
 | HOME |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 | 2 |  | LEAGUE
LEAGUE ONLY | ALL |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 | 2 |  | 1
 | HOME |  | 1 |  |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | ALL COMPETITIONS
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
SEARCH BOX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPARISON WORSE
CONSECUTIVES |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME] |  |  |  | LEAGUE
 |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  |  |  |  | TOTAL |  |  | TOTAL
ALL COMPS | ALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL COMPETITIONS
 | HOME
 | AWAY
LEAGUE ONLY | ALL
 | HOME
 | AWAY
LONGEST RUNS |  | WITHOUT DEFEAT |  |  | WITHOUT DRAW |  |  | WITHOUT WIN |  |  |  |  |  | WITHOUT CONCEDING |  |  | WITHOUT SCORING
 |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  |  |  |  | TOTAL |  |  | TOTAL
ALL COMPS | ALL
 | HOME
 | AWAY
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME]
MOST |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON |  | TOTAL | SEASON
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME]
LEAST |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON |  | TOTAL | SEASON
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | SCORED IN |  |  | DIDN'T SCORE |  |  | CONCEDED IN |  |  |  |  |  | DIDN'T CONCEDE
 |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON
LEAGUE ONLY | ALL | ALL (16) | 1898/9
 | HOME | ALL | 8 TIMES
 | AWAY | ALL (16) | 1898/9
Spreadsheet: 866249d1713205627-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1-2-
Sheet: Timeline Calendar

 | April | 2024
 |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS
 | All Digital | 16.79 | All Digital | 20.83 | All Digital | 12.75 | All Digital | 10.61 | All Digital | 4.4 | All Digital |  | All Digital
 | All Fabric | 23.45 | All Fabric | 0.28 | All Fabric | 0 | All Fabric | 3.85 | All Fabric | 1.16 | All Fabric |  | All Fabric
 | 246457 | 6.25 |  |  |  |  | 246465 | 3.3 | HHGJ 273 | 3.3
 |  |  |  |  |  |  | HHGJ 274 | 0.23 | HHGJ 239 | 2.89
 |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS |  | PRINT HRS
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 |  | PRINT HRS |  | PRINT HRS
 | All Digital |  | All Digital
 | All Fabric |  | All Fabric
Spreadsheet: 0c114c1c-d652-45c5-a37f-48b73395480d
Sheet: Fall Semester Budget

 | Proposed Budget for the Upcoming Semester
 |  |  | Estimated | Actual
 | Professional Development | Description
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 | Total |  |  | 0
 | Events | Description
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 | Total
 | T- Shirts | Description
 |  |  | 0 | 0
 |  |  | 0 | 0
 | Total
 | Miscellaneous | Description
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 | Total
 | Totals
Spreadsheet: 727573d1617968578-find-nearest-upper-and-lower-values-in-a-table-index-and-match-lookup-number-example
Sheet: Table1

Values | [NAME] | [NAME] | X-3 | Y-1 | Y-2 | Y-3 | XY0 |  |  | Type | Value | Result
0.001 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2 |  | example1 | X-3 | 50
0.002 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2 |  | example2 | Y-2 | 7500 | 375
0.005 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2
0.01 | 0.003 | 0.008 | 0.025 | 0.08 | 0.25 | - | 0.25
0.02 | 0.003 | 0.01 | 0.03 | 0.1 | 0.3 | - | 0.3
0.05 | 0.004 | 0.012 | 0.04 | 0.12 | 0.4 | - | 0.4
0.1 | 0.005 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6 | 0.5
0.2 | 0.006 | 0.02 | 0.06 | 0.2 | 0.6 | 2 | 0.6
0.5 | 0.008 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 | 0.8
1 | 0.01 | 0.03 | 0.1 | 0.3 | 1 | 3 | 1
2 | 0.012 | 0.04 | 0.12 | 0.4 | 1.2 | 4 | 1.2
5 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6 | 5 | 1.6
10 | 0.02 | 0.06 | 0.2 | 0.6 | 2 | 6 | 2
20 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 | 8 | 2.5
50 | 0.03 | 0.1 | 0.3 | 1 | 3 | 10 | 3
100 | 0.05 | 0.16 | 0.5 | 1.6 | 5 | 16 | 5
200 | 0.1 | 0.3 | 1 | 3 | 10 | 30 | 10
500 | 0.25 | 0.8 | 2.5 | 8 | 25 | 80 | 25
1000 | 0.5 | 1.6 | 5 | 16 | 50 | 160 | 50
2000 | 1 | 3 | 10 | 30 | 100 | 300 | 100
5000 | 2.5 | 8 | 25 | 80 | 250 | 800 | 250
10000 | 5 | 16 | 50 | 160 | 500 | 1600 | 500
20000 | 10 | 30 | 100 | 300 | 1000 | 3000 | 1000
50000 | 25 | 80 | 250 | 800 | 2500 | 8000 | 2500
100000 | - | 160 | 500 | 1600 | 5000 | 16000 | 5000
200000 | - | 300 | 1000 | 3000 | 10000 | 30000 | 10000
500000 | - | 800 | 2500 | 8000 | 25000 | 80000 | 25000
1000000 | - | 1600 | 5000 | 16000 | 50000 | 160000 | 50000
2000000 | - | - | 10000 | 30000 | 100000 | 300000 | 100000
5000000 | - | - | 25000 | 80000 | 250000 | 800000 | -
Spreadsheet: 52416d1252099874-summing-based-on-conditions-book1
Sheet: Data

 | Start Date
 | End Date
 |  |  |  |  |  |  |  | AMER:Consumer Online
 |  |  |  |  |  |  |  | [NAME]:Consumer Online
 |  |  |  |  |  |  |  | APJ:Consumer Online
 |  |  |  |  |  |  |  | Consumer
 |  |  | Region:Request Segment | Visits |  |  | Visits
 |  |  | AMER:General Content
 |  |  | AMER:Consumer Online
 |  |  | EMEA:General Content
 |  |  | APJ:General Content
 |  |  | AMER:BSDT Online
 |  |  | [NAME]:Consumer Online
 |  |  | APJ:Consumer Online
 |  |  | not set:undefined
 |  |  | None
 |  |  | APJ:BSDT Online
 |  |  | [NAME]:BSDT Online
 |  |  | not set:General Content
 |  |  | AMER:ATG Online
 |  |  | AMER:Consumer ARB Online
 |  |  | AMER:SMB ARB Online
 |  |  | AMER:ARB Online
 |  |  | AMER:BSDR Online
 |  |  | AMER:undefined
 |  |  | :General Content
 |  |  | [NAME]:Consumer ARB Online
 |  |  | :BSDT Online
 |  |  | [NAME]:ARB Online
 |  |  | [NAME]:undefined
 |  |  | APJ:ARB Online
 |  |  | APJ:undefined
 |  |  | not set:Consumer Online
 |  |  | not set:BSDT Online
 |  |  | :Consumer Online
 |  |  | [NAME]:SMB ARB Online
 |  |  | AMER:PCA Online
 |  |  | APJ:SOHO Online
 |  |  | :undefined
 |  |  | AMER:LB Online
 |  |  | AMER:Provincial Online
 |  |  | APJ:Consumer ARB Online
 |  |  | [NAME]:ATG Online
 |  |  | APJ:ATG Online
 |  |  | APJ:SMB ARB Online
 |  |  | AMER:Global Online
 |  |  | not set:ARB Online
 |  |  | APJ:BSDR Online
 |  |  | :ATG Online
 |  |  | not set:SMB ARB Online
 |  |  | AMER:EBD Online
 |  |  | not set:Consumer ARB Online
 |  |  | EMEA:BSDR Online
Spreadsheet: 876026d1722670144-placing-names-on-teams-learning-the-ropes-book-2-aligw
Sheet: Solution

Player Number | First Name | Last Name | Assigned Team # |  | Team Number | TEAM MEMBERS
1 | Afera | Quick | 4 |  | 1
2 | Al | Knol | 6 |  | 2 | Bob Stout & Nate Late
3 | Barb | Tamp | 9 |  | 3 | Bryan Smith & Mac  Long
4 | Barb | Pine | 1 |  | 4 | Afera Quick & Steve  Ready
5 | [NAME] | [NAME] | 10 |  | 5 | Cindy Dime & Ned Brow
6 | [NAME] | Stout | 2 |  | 6 | Al Knol & Dave  Radcliff
7 | [NAME] | Smith | 3 |  | 7 | [NAME]
8 | [NAME] | Dime | 5 |  | 8 | [NAME] Early
9 | [NAME] | Radcliff | 6 |  | 9 | Barb Tamp & Ray Erskine
10 | George | Plum | 8 |  | 10 | [NAME]
11 | [NAME] |  | 10
12 | [NAME] | Slow | 1
13 | [NAME] | [NAME] | 7
14 | Mac | Long | 3
15 | Nate | Late | 2
16 | Ned | Brow | 5
17 | Ray | Erskine | 9
18 | Shelly | Early | 8
19 | [NAME] | Ready | 4
20 | Sue | Baxter | 7
Spreadsheet: 390286d1429585904-need-formula-to-calculate-if-date-is-within-range-calculate-if-date-is-within2
Sheet: Monthly

Category 1 | Category 2 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00
Labor | Internal
Labor | External
Hardware | Server
Hardware | Maintenance
Spreadsheet: 37428d1235441247-formula-to-calculate-months-cover-inventory-question
Sheet: Inventory Cover

 |  |  |  |  | Target  Month | 2008-12-01 00:00:00 |  | 2009-01-01 00:00:00 |  | 2009-02-01 00:00:00 |  | 2009-03-01 00:00:00 |  | 2009-04-01 00:00:00 |  | 2009-05-01 00:00:00 |  | 2009-06-01 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-08-01 00:00:00 |  | 2009-09-01 00:00:00 |  | 2009-10-01 00:00:00 |  | 2009-11-01 00:00:00 |  | 2009-12-01 00:00:00
 |  |  |  |  |  | BGT | ACT | BGT | ACT | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST | BGT | FCST
 |  | Product 2 |  | In |  |  |  | 5211 | 2672 | 7815 | 2514 | 5590 | 3752 | 5651 | 4706 | 5306 | 4334 | 1125 | 5500 | 5000 | 3000 | 5141 | 6000 | 5487 | 5252 | 6000 | 4000 | 5422 | 4500 | 46590 | 5280
 |  |  |  | Out |  |  |  | 5800 | 5380 | 8222 | 5212 | 6451 | 5303 | 5990 | 5392 | 5719 | 5148 | 2000 | 5000 | 6000 | 2000 | 2000 | 7000 | 5835 | 5252 | 6000 | 4000 | 5462 | 5500 | 5833 | 6541
 |  |  |  | Inventory |  | 29745 | 21277 | 29156 | 18569 | 28749 | 15871 | 27888 | 14320 | 27549 | 13634 | 27136 | 12820 | 26261 | 13320 | 25261 | 14320 | 28402 | 13320 | 28054 | 13320 | 28054 | 13320 | 28014 | 12320 | 68771 | 11059
 |  |  |  | month | 3 |  |  | 5.13
Spreadsheet: 838529d1691093354-rotate-a-list-of-names-based-on-who-took-the-last-turn-book1
Sheet: Sheet1

 | [NAME]
 | [NAME]
 | Fred
 | Carol
 | Sue
Spreadsheet: 77750d1278206582-countif-problem-with-multiple-criteria-book-sample
Sheet: Sales Stats

ID | Product | Category | Sold
[NAME] | Apples | Fruit
G-002 | Oranges | Fruit
G-003 | Pears | Fruit
G-004 | Bananas | Fruit
G-005 | Carrots | Vegetables
G-006 | Potatoes | Vegetables
G-007 | Onions | Vegetables
G-008 | Broccoli | Vegetables
Spreadsheet: 848005d1698827535-cannot-get-closest-match-to-work-within-reverse-lookup-with-a-2-dimensional-array-testdata-revlookup-closestmatch-2darray-jacc
Sheet: Rev Lkup TestData

Category | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 |  | SAMPLE REVERSE LOOKUP -2 INPUTS, 1 OUTPUT |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1414490-cannot-get-closest-match-to-work-within-reverse-lookup-with-a-2-dimensional-array.html
1001 | 100 | 150 | 250 | 300 | 500 | 700 |  | Exact match works; Closest match does not work.
1002 | 50 | 60 | 70 | 80 | 95 | 120 |  | 2 INPUTS: | Category | Units |  | 1 OUTPUT: | Percentile
1003 | 1000 | 2000 | 3000 | 5000 | 6000 | 7000 |  | Example: Sold 68 Units of Category 1002.  Closest percentile rank for that category is 3%tile.
1004 | 5 | 15 | 25 | 30 | 35 | 37 |  | Category | 1002
1005 | 30000 | 35000 | 40000 | 42000 | 44000 | 50000 |  | Units Sold | 68
 |  |  |  |  |  |  |  | %tile |  | Any value between the two table values returns the lower value, instead of closest match.
Issue: Difficulty applying closest match reverse lookup in a 2 dimensional array.
 |  |  |  |  |  |  |  | SAMPLE REVERSE LOOKUP -1 INPUT, 1 OUTPUT
 |  |  |  |  |  |  |  | Both exact match and closest match work.
 |  |  |  |  |  |  |  | 1 INPUT: | Units |  |  | 1 OUTPUT: | Percentile
 |  |  |  |  |  |  |  | Example: Sold 68 Units of Category 1002.  Closest percentile rank for that category is 3%tile.
 |  |  |  |  |  |  |  | Category = 1001 |  | ONLY OPTION AVAILABLE WITHIN FORMULA
 |  |  |  |  |  |  |  | Units Sold | 295
 |  |  |  |  |  |  |  | %tile |  | Note: Current version of Excel requires [Ctrl+Shift+Enter] instead of just [Enter]
 |  |  |  |  |  |  |  | Random numbers for testing only | Random numbers for testing only | Results |  | Hit F9 for new random numbers to test!