tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 208418d1358820747-autopopulate-data-depending-on-the-selection-from-the-dropdown-list-dropdown-month
Sheet: Sheet1

Dropdown -> | February
 | Properties | MTD |  | YTD
 | Property 1 |  |  |  |  |  | Need to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown menu
 | Property 2
 | Property 3
 | Property 4
 | Property 5
 | Property 6
 | Property 7
 | Property 8
 | Property 9
 | Property 10
 | Property 11
 | Property 12
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
Spreadsheet: 92559d1292117840-multiple-values-calculation-daily-profit-sheet
Sheet: Sheet1

 |  |  |  |  |  |  | DAILY PROFIT
 |  | DATE | PRODUCT | PROFIT |  |  | 1st | 2nd | 3rd | 4th
 |  | 2011-01-01 00:00:00 | U224GH | 22 |  | U224GH
 |  | 2011-01-01 00:00:00 | U224GH | 22 |  | GGV224
 |  | 2011-01-01 00:00:00 | U224GH | 22 |  | UB772-2
 |  | 2011-01-01 00:00:00 | U224GH | 22 |  | UB772-3
 |  | 2011-01-01 00:00:00 | U224GH | 22 |  | JJN142
 |  | 2011-01-01 00:00:00 | GGV224 | 18 |  | RGG22-K
 |  | 2011-01-01 00:00:00 | GGV224 | 18
 |  | 2011-01-01 00:00:00 | GGV224 | 18
 |  | 2011-01-01 00:00:00 | GGV224 | 18
 |  | 2011-01-01 00:00:00 | U224GH | 22
 |  | 2011-01-01 00:00:00 | U224GH | 22
 |  | 2011-01-01 00:00:00 | U224GH | 22
 |  | 2011-01-01 00:00:00 | U224GH | 22
 |  | 2011-01-01 00:00:00 | U224GH | 22
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | GGV224 | 18
 |  | 2011-01-02 00:00:00 | U224GH | 22
 |  | 2011-01-02 00:00:00 | U224GH | 22
 |  | 2011-01-02 00:00:00 | U224GH | 22
 |  | 2011-01-02 00:00:00 | U224GH | 22
 |  | 2011-01-02 00:00:00 | U224GH | 22
Spreadsheet: 836371d1689316435-count-number-of-rows-where-any-date-between-start-and-finish-are-between-2-dates-example
Sheet: Sheet1

Start | Finish |  | 2023-05-15 00:00:00
 |  | Count:
2023-05-16 00:00:00 | 2023-06-19 00:00:00
2023-05-17 00:00:00 | 2023-06-23 00:00:00
2023-05-19 00:00:00 | 2023-07-03 00:00:00
2023-06-06 00:00:00 | 2023-07-27 00:00:00
2023-06-19 00:00:00 | 2023-08-02 00:00:00
2023-06-20 00:00:00 | 2023-07-28 00:00:00
2023-06-26 00:00:00 | 2023-08-03 00:00:00
2023-06-27 00:00:00 | 2023-07-31 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-10 00:00:00 | 2023-08-04 00:00:00
2023-07-12 00:00:00 | 2023-08-08 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-17 00:00:00 | 2023-08-11 00:00:00
2023-07-18 00:00:00 | 2023-08-21 00:00:00
2023-07-19 00:00:00 | 2023-08-15 00:00:00
2023-07-21 00:00:00 | 2023-08-17 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-08-08 00:00:00 | 2023-09-04 00:00:00
2023-08-17 00:00:00 | 2023-09-20 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-21 00:00:00 | 2023-09-15 00:00:00
2023-08-21 00:00:00 | 2023-09-01 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-25 00:00:00 | 2023-09-21 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-09-06 00:00:00 | 2023-10-04 00:00:00
Spreadsheet: 770240d1645926981-replacing-offset-to-sum-up-to-max-value-from-specific-cell-calculating-the-number-of-rows-to-be-summed-up-to-a-condition-mfeengineer-
Sheet: Data

Engineering DWG | Operation | N-Blocks | Time(min.) | Helper Column1
2800026-A-05-0000 | 5 | N1 | 5
2800026-A-05-0000 | 5 | N2 | 6
2800026-A-05-0000 | 5 | N3 | 10
2800026-A-05-0000 | 5 | N4 | 5
2800026-A-05-0000 | 5 | N5 | 16
2800026-A-05-0000 | 5 | [NAME] | 17
2800026-A-05-0000 | 5 | N7 | 15
2800026-A-05-0000 | 5 | N8 | 10
2800026-A-05-0000 | 5 | N9 | 5
2800026-A-05-0000 | 5 | N10 | 6
2800026-A-05-0000 | 5 | N11 | 4
2800026-A-05-0000 | 5 | N12 | 8
2800026-A-05-0000 | 5 | N13 | 9
2800026-A-05-0000 | 5 | [NAME] | 5
2800026-A-05-0000 | 5 | N15 | 5
2800026-A-05-0000 | 5 | N16 | 2
2800026-A-05-0000 | 5 | N17 | 4
2800026-A-05-0000 | 5 | N18 | 8
2800026-A-05-0000 | 5 | N19 | 9
2800026-A-05-0000 | 5 | N20 | 5
2800026-A-05-0000 | 5 | N21 | 10
2800026-A-05-0000 | 5 | N22 | 11
2800026-A-05-0000 | 5 | N23 | 8
2800026-A-05-0000 | 5 | N24 | 9
2800026-A-05-0000 | 5 | N25 | 10
2800026-A-05-0000 | 5 | N26 | 11
2800026-A-05-0000 | 5 | N27 | 7
2800026-A-05-0000 | 5 | N28 | 6
2800026-A-05-0000 | 5 | N29 | 5
2800026-A-05-0000 | 5 | N30 | 6
2800026-A-10-0000 | 10 | N1 | 8
2800026-A-10-0000 | 10 | N2 | 10
2800026-A-10-0000 | 10 | N3 | 12
2800026-A-10-0000 | 10 | N4 | 6
2800026-A-10-0000 | 10 | N5 | 11
2800026-A-10-0000 | 10 | [NAME] | 12
2800026-A-10-0000 | 10 | N7 | 11.5
2800026-A-10-0000 | 10 | N8 | 12
2800026-A-10-0000 | 10 | N9 | 12.5
2800026-A-10-0000 | 10 | N10 | 13
2800026-A-10-0000 | 10 | N11 | 13.5
2800026-A-10-0000 | 10 | N12 | 14
2800026-A-10-0000 | 10 | N13 | 14.5
2800026-A-10-0000 | 10 | [NAME] | 15
2800026-A-10-0000 | 10 | N15 | 15.5
2800026-A-10-0000 | 10 | N16 | 16
2800026-A-10-0000 | 10 | N17 | 16.5
2800026-A-10-0000 | 10 | N18 | 17
2800026-A-10-0000 | 10 | N19 | 17.5
2800026-A-10-0000 | 10 | N20 | 18
2800026-A-10-0000 | 10 | N21 | 18.5
2800026-A-10-0000 | 10 | N22 | 19
2800026-A-10-0000 | 10 | N23 | 19.5
2800026-A-10-0000 | 10 | N24 | 20
2800026-A-10-0000 | 10 | N25 | 20.5
2800026-A-10-0000 | 10 | N26 | 21
2800026-A-10-0000 | 10 | N27 | 21.5
2800026-A-10-0000 | 10 | N28 | 22
2800026-A-10-0000 | 10 | N29 | 22.5
Spreadsheet: 806996d1669710079-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: STEPHANIE

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 |  |  |  |  |  |  |  |  |  |  | 1st Grade |  |  |  | 4th Grade
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | _ |  |  |  |  |  |  |  | _
 |  |  | _ |  |  |  | _
Spreadsheet: 866820d1713757154-conditional-rules-and-change-colour-cells-rps
Sheet: RPs

First name | Surname | BSPlan type | BSPlan date | Uploaded by | Practitioner | BSPlan due date | 7-Weeks Prior
[NAME] | Smith | interim | 2022-09-30 01:01:00 |  |  |  | 2022-11-21 00:00:00
Client | A | interim | 2023-01-30 21:13:00 |  |  |  | 2023-05-16 00:00:00
[NAME] | Doe | comprehensive | 2022-09-30 01:41:00 |  |  |  | 2023-07-27 00:00:00
Client | Burns | comprehensive | 2023-03-28 01:09:00 |  |  |  | 2024-03-27 00:00:00
Client | Cho | comprehensive | 2023-04-14 05:00:00 |  |  |  | 2024-04-05 00:00:00
Client | Doe | interim | 2023-11-20 00:00:00 |  |  |  | 2024-04-20 00:00:00
Client | F | comprehensive | 2023-07-25 10:05:00 |  |  |  | 2024-05-16 00:00:00
Client | G | interim | 2024-01-11 00:00:00 |  |  |  | 2024-07-09 00:00:00
Spreadsheet: 99902d1298436403-dropdown-used-to-fill-in-remainder-of-form-help-turbinedoc_testreport-1-
Sheet: Lookups

Engine Type |  |  |  | C20B/F/J/S/W |  |  |  |  |  |  | T63-A-720 |  |  |  |  |  |  | C20 |  |  |  |  |  |  | C20B/F/J/S/W |  |  |  |  |  |  | C20R/2 |  |  |  |  |  |  | C28 |  |  |  |  |  |  | C30 |  |  |  |  |  |  | C30P |  |  |  |  |  |  | C30R/3 |  |  |  |  |  |  | C47B |  |  |  |  |  |  | C47M
T63-A-720 |  | Setting |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min
C20 |  | SPEC GPTOT |  | 1261 |  |  | 1360 | 1490 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CM47
C20B/F/J/S/W |  | PRED SHP @ SPEC MGT
C20R/2 |  | [NAME] SHAFT PWR |  | 300 | 278 | 333 | 370 | 420
C28 |  | % DELTA FROM SPEC PWR
C30 |  | Predicted SFC
C30P |  | [NAME] SFC |  | 0.689 | 0.709 | 0.665 | 0.65 | 0.65
C30R/3 |  | % DELTA FROM SPEC SFC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test
C47B
C47M
Spreadsheet: 0c79b9a8-fb2f-4909-9abd-067130a9002f
Sheet: 2008

2008 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2007 Rank
1 | HARVARD UNIVERSITY | 11315 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 7820 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(2) | 2820 | GOVERNMENT | 3
4 | MT. AUBURN HOSPITAL | 1969 | MEDICAL | 4
5 | NOVARTIS INSTITUTE FOR BIOMEDICAL RESEARCH | 1629 | BIOTECHNOLOGY | 8
6 | BIOGEN IDEC | 1596 | BIOTECHNOLOGY | 5
7 | CAMBRIDGE HEALTH ALLIANCE | 1413 | MEDICAL | 6
8 | GENZYME CORPORATION | 1391 | BIOTECHNOLOGY | 9
9 | FEDERAL GOVERNMENT | 1286 | GOVERNMENT | 7
10 | DRAPER LABORATORY | 1175 | RESEARCH & DEVELOPMENT | 10
11 | VERTEX PHARMACEUTICALS | 1051 | BIOTECHNOLOGY | 13
12 | COMMONWEALTH OF MASSACHUSETTS | 957 | GOVERNMENT | 11
13 | QUEST DIAGNOSTICS | 853 | CLINICAL TESTING SERVICES | 14
14 | MILLENIUM PHARMACEUTICALS | 776 | BIOTECHNOLOGY | 12
15 | CAMP, DRESSER & MCKEE | 687 | ENGINEERING CONSULTANTS | 16
16 | EF INTERNATIONAL | 680 | TRAVEL & EXCHANGE PROGRAMS | 18
17 | WHOLE FOODS | 655 | SUPERMARKET | 22
18 | [NAME] CAMBRIDGE | 629 | BIOTECHNOLOGY | 15
19 | AKAMAI | 608 | INTERNET NETWORK SERVICES | 20
20 | FORRESTER RESEARCH | 552 | BUSINESS SERVICES | 23
21 | LESLEY UNIVERSITY | 519 | HIGHER EDUCATION | 21
22 | ITA SOFTWARE(3) | 441 | SOFTWARE | 29
23 | BBN TECHNOLOGIES | 439 | RESEARCH & DEVELOPMENT | 24
24 | YOUVILLE HOSPITAL & REHABILITATION CENTER | 420 | MEDICAL | 17
25 | MONITOR GROUP | 394.5 | MANAGEMENT CONSULTING | 25
Spreadsheet: 687626d1595322956-vlookup-to-return-grid-reference-sample-for-lookup
Sheet: Sheet1

inches | 10 | 14 | 18 | 22 | 26 | 30 | 34 | 38 | 42 | 46 | 50 | 54 | 58 | 62 | 64
PRODUCT 1 | 8.34 | 9.46 | 10.68 | 12.01 | 13.43 | 14.95 | 16.94333333333333 | 18.93666666666666 | 20.93 | 22.92333333333334 | 24.91666666666667 | 26.91 | 28.90333333333334 | 30.89666666666667 | 31.89333333333334
PRODUCT 2 | 8.34 | 9.46 | 10.68 | 12.01 | 13.43 | 14.95 | 16.91710526315789 | 19.08092105263158 | 21.04802631578947 | 23.01513157894737 | 24.98223684210526 | 26.94934210526316 | 28.91644736842105 | 30.88355263157895 | 32.06381578947369
PRODUCT 3 | 8.67 | 9.92 | 11.28 | 12.73 | 14.28 | 15.94 | 17.69 | 19.55 | 21.5 | 23.55 | 25.59782608695652 | 27.64565217391304 | 29.69347826086957 | 31.74130434782609 | 32.76521739130435
PRODUCT 4 | 8.46 | 9.63 | 10.91 | 12.28 | 13.75 | 15.32 | 16.99 | 18.76 | 20.63 | 22.61 | 24.57608695652174 | 26.54217391304348 | 28.50826086956522 | 30.47434782608696 | 31.45739130434783
PRODUCT 5 | 9.27 | 10.76 | 12.35 | 14.04 | 15.84 | 17.73 | 19.72 | 21.81 | 24 | 26.3 | 28.58695652173913 | 30.87391304347826 | 33.1608695652174 | 35.44782608695652 | 36.59130434782609
PRODUCT 6 | 8.98 | 10.35 | 11.83 | 13.41 | 15.09 | 16.86 | 18.74 | 20.72 | 22.8 | 24.97 | 27.14130434782609 | 29.31260869565217 | 31.48391304347826 | 33.65521739130435 | 34.74086956521739
PRODUCT 7 | 8.67 | 9.92 | 11.28 | 12.73 | 14.28 | 15.94 | 17.69 | 19.55 | 21.5 | 23.55 | 25.59782608695652 | 27.64565217391304 | 29.69347826086957 | 31.74130434782609 | 32.76521739130435
PRODUCT 8 |  |  | 12.91 | 14.72 | 16.64 | 18.65 | 20.77 | 22.99 | 25.3 | 27.72 | 30.23 | 32.85 | 35.56 | 38.38 | 39.82
PRODUCT 9 |  |  | 14.39 | 16.53 | 18.78 | 21.12 | 23.57 | 26.11 | 28.76 | 31.5 | 34.35 | 37.29 | 40.33 | 43.48 | 45.09
 |  | inches | cost
PRODUCT 2 |  | 62
 |  | find  [NAME] (cell A14) in range A2 to A10
 |  | return the cost equating to 62 in the grid which is £30.88
Spreadsheet: 868961d1715670181-embedded-excel-file-not-working-on-website-funeral-landing-page_quote_v4
Sheet: Applicant

Cover | (18-24) | (25-34) | (35-44) | (45-54) | (55-64)
0 | 0 | 0 | 0 | 0 | 0
2000 | 10 | 11 | 13 | 14 | 18
4000 | 18 | 21 | 25 | 28 | 36
10000 | 45 | 53 | 59 | 67 | 89
14000 | 62 | 74 | 83 | 94 | 124
20000 | 89 | 105 | 118 | 133 | 177
24000 | 103 | 123 | 138 | 155 | 206
30000 | 120 | 142 | 160 | 180 | 239
50000 | 184 | 219 | 245 | 276 | 367
100000 | 353 | 420 | 471 | 530 | 707
Age | Cover Amount |  | Premium
 | 5000
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, February 1 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: michelle_lokay__26824__sharris1000wk1
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-10-06 10:28:51.040000
 |  | October, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8361679908999999 | 0.06296799090000005 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 1.0849816046 | -0.04041839540000014 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1709 | 0.15106711032 | -0.01983288967999999 |  | Lower East IT Rates
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1636521197 | 0.1047521197 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.04978011552 | 0.4115801155199961
[NAME] due to Price |  |  |  | 0.9727377102088747 |  | Current index price of $5.15
[NAME] due to net fuel retention. |  |  |  | -0.157155603185528
Hedging Adjustment |  |  |  | -0.1255500000000002
Unaccounted for Variance |  |  |  | -0.021
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.6690321070233465
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 1.080612222543343
 |  |  |  | ========
Resolution of El Paso Fuel Dispute |  |  |  | 3.0074
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 4.088012222543343
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through September) |  | 122.2891 | 17.1504 | 139.4395
Actuals through August with Sept. Wkly. |  | 123.62738011552 | 22.35494115790635 | 145.9823212734263
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 1.338280115519979 | 5.204541157906341 | 6.54282127342632
 |  | ------------- | ------------- | -------------
Resolution of El Paso Fuel Dispute (Booked in Oct.,NOT Sept.) |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 9.54282127342632
 |  |  |  | ========
Spreadsheet: 60190d1260741222-multiple-if-statement-problem-putnum
Sheet: CurrentPayCheck

Pay Check | Date | Finger Print | Item Name | Categories | Tags | Tag Amount | Bank Amount | Comments
1301 | 2009-12-25 00:00:00 | 1 | Walmart |  |  |  | -270
 | 2009-12-25 00:00:00 | 1 | WalMart | Food | Food - Adam's Groceries | 90 |  | Bought Chicken
Left Over | 2009-12-25 00:00:00 | 1 | Walmart | Clothing | Clothing - Adam | 90 |  | Bought Underware
 | 2009-12-25 00:00:00 | 1 | WalMart | Auto | Auto - Maintenance - VW | 90 |  | windsheild washer vw
Filter |  | 2 | Sonic | Food | Food - Adam Eating Out | 2.23 | -2.23
1
Budget Check |  | 3 | RaceTrack | Auto | Auto - Gas - VW | 32.12 | -32.12 | Got Gas
Finger Print
Spreadsheet: 694003d1599279841-formula-to-count-cells-that-contain-exact-texts-across-column-count_exact_now
Sheet: Sheet2

 | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13 | Same Text/Exact Text | Different Text
1
2
3
4
5
6
7
8
9
Spreadsheet: 151383d1334876970-index-and-match-formulas-exceltest
Sheet: CURINVENTORY

PNAME1 | pmast | SumOfQOH | PCLASS
Prod1 | 6PPD | 1799.68 | ACCEL
Prod2 | ALCTPIOP | 0 | ACCEL
Prod3 | ALEW100 | 545.1498 | ACCEL
Prod4 | MBPA25 | 5562.1011 | ACCEL
Prod5 | [NAME] | 149812.526 | ACCEL
Prod6 | CBSPDR25 | 674.4196999999999 | ACCEL
Prod7 | 01045 | 15264.832 | ACCEL
Prod8 | 03040 | 14825.935 | ACCEL
Spreadsheet: 86951d1286898009-pivot-tables-adjacent-formulas-book1
Sheet: Sheet1

Name | MOS2 | Amount | Age
Homer | Beginning Weight | 245 | 47
Jethro | Beginning Weight | 210 | 40
[NAME] | Beginning Weight | 185 | 34
Barney | Beginning Weight | 98 | 20
[NAME] | Beginning Weight | 187 | 32
Barack | Beginning Weight | 178 | 30
Sad Sack | Beginning Weight | 114 | 24
Droopy | Beginning Weight | 58 | 12
Dopey | Beginning Weight | 42 | 10
Homer | Ending Weight | 243 | 47
Jethro | Ending Weight | 213 | 40
[NAME] | Ending Weight | 183 | 34
Barney | Ending Weight | 101 | 20
[NAME] | Ending Weight | 185 | 32
Barack | Ending Weight | 181 | 30
Sad Sack | Ending Weight | 112 | 24
Droopy | Ending Weight | 61 | 12
Dopey | Ending Weight | 40 | 10
Spreadsheet: 852733d1702667117-sum-range-based-on-multiple-cell-values-schedule-to-excel-forum
Sheet: Sheet1

 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo |  |  | Total Time
 | [NAME] |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 0 | 8 |  |  | 8 | 8 | 0 | 5 | 8 |  |  | 8 | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  | [NAME] | 40
 | [NAME] |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 4 |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 | 8
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired formula goes in cell [NAME]
 | [NAME] |  |  |  |  |  | 8 |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | Mac |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | [NAME] |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 2 |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
 | [NAME]
 | [NAME]
 | Reni
 | [NAME] |  |  |  |  |  |  |  |  |  | 5 | 8 | 8 |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 4 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2
 | EX - I want all of the numbers associated with [NAME] in the dataset B5:B16
 | [NAME] = 40 for range B5:B16
Spreadsheet: 865521d1712592365-how-to-drag-formula-vertically-but-change-horizontal-reference-example
Sheet: Sheet2

 | Sum of Values | Notes
2024-01-01 00:00:00 | =SUM(Sheet1!B2:B7) | returns correct value of "15"
2024-02-01 00:00:00 | =[NAME]:B8) | when B2 draged down, row reference advances, need column ref to advance instead
2024-03-01 00:00:00
2024-04-01 00:00:00 | =SUM(Sheet1!E$2:E$7) | I can lock the rows with "$" but still need the column to advance on vertial drag
2024-05-01 00:00:00 | =SUM(Sheet1!E$2:E$7) | result of drag with row$
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 14 | 429
2 | 39 | 429
3 | 3 | 429
4 |  | 429
5 |  | 247
6 |  | 388
7 |  | 381
8 |  | 346
9 |  | 429
10 |  | 418
11 |  | 429
12 |  | 429
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 1032
2002-03-12 00:00:00
CBS Volume
 |  |  | 487
Spreadsheet: 684523d1593429101-counting-multiplicative-divisible-pairs-and-consecutive-numbers-from-rows-inventory
Sheet: Cover

Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Count multiplicative pairs ([NAME] one)
JA-0090-20 | SS-002245 | 720 | 5 | 10 | 15 | 20 | 2550 | 350000 | 4
JA-0090-21 | SS-002246 | 6 | 12 | 500 | 2 | 4 | 6 | 150 | 3
JA-0090-22 | SS-002247 | 700 | 7 | 14 | 21 | 28 | 35 | 350 | 6
JA-0090-23 | SS-002248
Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Count divisible pairs  ([NAME] one)
JA-0090-20 | SS-002245
JA-0090-21 | SS-002246
JA-0090-22 | SS-002247
JA-0090-23 | SS-002248
Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Count same first digits ([NAME] one)
JA-0090-20 | SS-002245 | 2 | 6 | 22 | 222 | 2222 | 2550 | 350000 | 4 | If the number is less than 10 then the formula shouldn't consider for counting. Because numbers less than 10 starts with 0 for example 01, 02, 03….
JA-0090-21 | SS-002246 | 82 | 2 | 3 | 33 | 39 | 43 | 55 | 2
JA-0090-22 | SS-002247 | 5 | 1 | 10 | 15 | 18 | 18888 | 25 | 3
JA-0090-23 | SS-002248
Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Count consecutive numbers ([NAME] one)
JA-0090-20 | SS-002245 | 56 | 57 | 54 | 754 | 755 | 756 | 757 | 4
JA-0090-21 | SS-002246 | 658 | 520 | 156 | 157 | 158 | 201 | 202 | 3
JA-0090-22 | SS-002247
JA-0090-23 | SS-002248