tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739034d1625473614-allocation-of-revenue-from-one-to-another-allocation-of-revenue-from-one-to-another-
Sheet: Sheet1

 |  |  |  | A |  |  |  |  |  | B |  |  |  |  |  | C
Resident Sample |  |  |  | Estimated Yearly Fees By Level Of Care |  |  |  |  |  | Estimated Yearly Revenue For Resident |  |  |  |  |  | Allocation and Amortization Of Nonrefundable Entrance Fee
Name: |  |  |  | Year | IL | AL | SNF |  |  | Year | IL | AL | SNF | Total |  | Year | IL | AL | SNF | Deferred Revenue
Age: | 75
Admission Date: | 2021-07-01 00:00:00 |  |  | 2021 |  |  |  |  |  | 2021 |  |  |  |  |  | 2021
Life Expectancy - Years:
Independent Living (IL) | 10.75
Assisted Living (AL) | 2
Senior Nursing Facility (SNF) | 2.25
Contract Type: | Type A Lifetime
Entrance Fee: | 350000
Refundable or [NAME]: | NR
Inflation Rate: | 0.03
Yearly Fees:
IL | 68390
AL | 73020
SNF | 146554
 |  |  |  |  |  |  |  |  |  | Total Contract Cost:
 |  |  |  |  |  |  |  |  |  | Allocation of Nonrefundable Entrance Fee to Level of Care
Spreadsheet: 63587d1264488630-coordinating-2-files-excel-mock-list-a
Sheet: Sheet1

FIRSTNAME | LASTNAME | ADDRESS | CITY | STATE | POSTAL CODE | # OF CLIENTS
COLLEEN | [NAME] | 17 NANDINA CIR APT 1 | NORTH LITTLE ROCK | AL | 19330-9205
WILLIAM | DARLEY | 15 NANDINA CIR | NORTH LITTLE ROCK | AL | 19341-2019
[NAME] | BELIN | 6 PAR CIR APT 8 | NORTH LITTLE ROCK | AL | 19341-1759
CHESTER | HOMJAK | 2 PAR CIR APT 7 | NORTH LITTLE ROCK | AL | 19342-3338
THOMAS | GALEN | 12109 STAGECOACH RD LOT 343 | NORTH LITTLE ROCK | AL | 19350-1001
[NAME] | GRIGGS | 10 HUNTERS WOODS CT | NORTH LITTLE ROCK | AL | 19355-3427
[NAME] | MACDONALD | 8517 CALLEGHAN RD | NORTH LITTLE ROCK | AL | 19363-2805
KRISTINA | SCHERMER | 8 NEWCOMB CT | NORTH LITTLE ROCK | AL | 19363-2336
[NAME] | LUDLOW | 13600 OTTER CREEK PKWY APT 136 | NORTH LITTLE ROCK | AL | 19363-2805
SAM | DIERINGER | 20632 CONGO FERNDALE RD | NORTH LITTLE ROCK | AL | 19365-9616
KIRBY | ROEHL | 2200 DOGWOOD LN | NORTH LITTLE ROCK | AL | 19382-8328
ANGELA | MANS | 2504 LAWSON OAKS DR | NORTH LITTLE ROCK | AL | 19403-4403
HOWARD | HILLSTEAD | 4522 FLOWERWOOD LN | NORTH LITTLE ROCK | AL | 19403-4003
LOWELL | DUANE | 29 FALCON CT APT 4 | NORTH LITTLE ROCK | AL | 19403-2206
SHERWIN | GAAL | 18600 CRYSTAL VALLEY RD | NORTH LITTLE ROCK | AL | 19403-5013
THEODORE | HOKE | 16525 LAWSON RD | NORTH LITTLE ROCK | AL | 19406-2413
WALTER | EVERETT | 1302 STAGECOACH VLG | NORTH LITTLE ROCK | AL | 19406-2037
CLYDE | PATTISON | PO BOX 4580 | NORTH LITTLE ROCK | AL | 19422-3457
CAROL | HADLEY | 7310 W MARKHAM ST | NORTH LITTLE ROCK | AL | 19422-3209
EUGENE | LIN CHIANG | 10018 W MARKHAM ST | NORTH LITTLE ROCK | AL | 19425-1729
CARL | WILKE | 2114 ROMINE RD | NORTH LITTLE ROCK | AL | 19426-2712
[NAME] | FORMO | 9001 LONGACRE DR | NORTH LITTLE ROCK | AL | 19426-3905
JACK | PEDERSON | 9601 LILE DR STE 1100 | NORTH LITTLE ROCK | AL | 19438-2358
[NAME] | LUCAS | 2700 W 6TH ST | NORTH LITTLE ROCK | AL | 19438-2838
CINDY | [NAME] | 10515 W MARKHAM ST | NORTH LITTLE ROCK | AL | 19440-1709
EUGENE | VANTREASE | 216 S MARTIN ST | NORTH LITTLE ROCK | AL | 19440-2915
[NAME] | NELSON | 315 S MAPLE ST | NORTH LITTLE ROCK | AL | 19440-2603
TYRA | WOODRUFF | 110 S OAK ST | NORTH LITTLE ROCK | AL | 19446-6203
ALFRED | CLEMENS | 419 BOB WHITE DR APT 116 | NORTH LITTLE ROCK | AL | 19440-1709
VALUED | BEATY | 7820 W CAPITOL AVE APT 1105 | NORTH LITTLE ROCK | AL | 19440-2915
VALUED | [NAME] | 215 DRYAD LN | NORTH LITTLE ROCK | AL | 19440-2603
MIKE | PETERSEN | 2115 LLOYD CT | NORTH LITTLE ROCK | AL | 19446-6203
[NAME] | BRANDON | 2017 LLOYD CT | NORTH LITTLE ROCK | AL | 19440-1709
RAYMOND | RICHEL | 124 N SPRUCE ST | NORTH LITTLE ROCK | AL | 19440-2915
[NAME] | HORN | 4910 B ST | NORTH LITTLE ROCK | AL | 19440-2603
[NAME] | KELLY | 5310 C ST | NORTH LITTLE ROCK | AL | 19446-6203
DOROTHY | WELLBORN | 5600 B ST APT 3A | NORTH LITTLE ROCK | AL | 19440-2603
RODERICK | WELTON | 10515 W MARKHAM ST | NORTH LITTLE ROCK | AL | 19446-6203
Spreadsheet: 711730d1609868023-daily-sales-spreadsheet-month-target
Sheet: Sheet1

Monthly Target | 2021-01-01 00:00:00 |  |  |  |  |  |  | 2021-02-01 00:00:00
62500
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  |  | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  | 0
 |  |  | 2553
TOTAL
Spreadsheet: 687772d1595407256-between-2-numbers-help-doesnt-add-up-percentage
Sheet: Analysis

 | MONTHLY BREAKDOWN OF BUDDY ANALYSIS
 | Select Month |  | Jul |  | Running Total |  |  |  | Buddy Requests
 |  |  |  |  |  |  |  |  | Buddy Paired
 | Buddy Requests |  |  |  | Awaiting Pairing |  |  |  | Awaiting Pairing
 |  |  |  |  |  |  |  |  | Contact Made
 | Buddy Paired |  |  |  | Contact Made
 |  |  |  |  | Pairing Percentage
 |  |  |  |  |  |  | *Contact Made
 |  |  |  |  | Pairing Percentage
 |  |  |  |  |  |  | *No Contact
Spreadsheet: 846773d1697912625-count-number-of-unique-values-in-a-column-example
Sheet: Sheet1

2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
Spreadsheet: 807513d1669921710-merge-table-with-power-query-primary-key-with-duplicate-values-factory
Sheet: Result

 |  |  |  | Com-Export | Com-Import | COM-BBLC | Merchandising | MERCHANDISING |  |  |  |  |  |  |  |  |  |  |  | COM_BBLC |  |  |  | [NAME] |  |  |  |  | COM_Exp |  |  |  |  |  |  |  |  | Order No | JMS-001-22
 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Order No | Buyer | PO | Style | Color | Qty | Price | Amount | OPD | Delivery | Export LC/Contract No | Date | BBLC | Date2 | BBLC Value | BBLC Item | Import consignment | Item | ETA | Imp Inv Amt | Im Under BBLC | Export Inv no | Inv Date | PO_e | Style_e | Color_e | Qty_e | Price_e | Exp Amt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Amount | Sum of BBLC Value | Sum of Imp Inv Amt | Sum of Exp Amt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 160000 | 365180 | 300000 | 80000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000 | 198000 | 23560 | 65000 | 99000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 | 231000 | 29450 | 23560 | 80000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 589000 | 418190 | 388560 | 259000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result should be: | 589000 | 429970 | 429790 | 587350
Spreadsheet: f39a3235-bfb9-4aaf-a096-66e3939382a9
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43142697 | 2014-09-13 17:54:22 | ALLIES | 1 | 4 | 2 | 1631471 | player1631471 | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
43145715 | 2014-09-13 22:04:17 | ALLIES | 1 | 7 | 6 | 1490410 | general7star | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43162076 | 2014-09-14 23:05:42 | ALLIES | 0 | 3 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43162380 | 2014-09-14 23:19:29 | AXIS | 0 | 4 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 488557d1478712507-cross-reference-then-add-values-help-09-11-16
Sheet: Sheet1

Item | Grade | No of Blocks
1 | EC100 | 2
2 | EC70 | 3.4
3 | EC40 | 6
4 | EC40 | 9.8
5 | EC100 | 1
6 | EC150 | 2.4
7 | EC40 | 5
8 | EC100 | 6.4
9 | EC100 | 3.2
10 | EC40 | 1.1
11 | EC70 | 0.7
12 | EC150 | 0.1
 | Grade | Total Blocks
 | EC40
 | EC70
 | EC100
 | EC150
Spreadsheet: 758437d1638878485-calculate-the-hourly-difference-between-the-first-time-two-status-have-been-triggered-test-data-example
Sheet: Sheet1

Application  ID | Status | Status Date/Time | time difference
40647563 | Affordability Incomplete | 04/05/2021 13:11:00
40647563 | Affordability Product Incomplete | 04/05/2021 13:32:00
40647563 | Affordability Referred | 04/05/2021 13:32:00
40647563 | Affordability Manual Assessment | 04/05/2021 13:33:00
40647563 | Affordability Accepted | 04/05/2021 13:34:00
40647563 | App incomplete | 04/05/2021 13:34:00
40647563 | App referred | 04/05/2021 22:14:00
40647563 | App Manual Assessment | 05/05/2021 10:24:00
40647563 | App accepted | 05/05/2021 10:25:00
40647563 | App Manual Assessment | 05/05/2021 10:25:00
40647563 | Awaiting documents | 05/05/2021 10:33:00
40647563 | Application awaiting QA | 12/05/2021 15:19:00
40647563 | App Manual Assessment | 13/05/2021 15:34:00
67434572 | Affordability Incomplete | 11/06/2021 12:28:00
67434572 | Affordability Product Incomplete | 11/06/2021 14:04:00
67434572 | Affordability Offered | 11/06/2021 14:09:00
67434572 | Affordability Referred | 11/06/2021 14:17:00
67434572 | Affordability Incomplete | 11/06/2021 14:36:00
67434572 | Affordability Product Incomplete | 11/06/2021 15:16:00
67434572 | Affordability Offered | 11/06/2021 15:16:00
67434572 | Affordability Incomplete | 11/06/2021 15:17:00
67434572 | Affordability Product Incomplete | 11/06/2021 15:17:00
67434572 | Affordability Offered | 11/06/2021 15:17:00
67434572 | Affordability Referred | 11/06/2021 15:23:00
67434572 | Affordability Manual Assessment | 11/06/2021 15:34:00
67434572 | Affordability Accepted | 11/06/2021 15:34:00
67434572 | Affordability Incomplete | 11/06/2021 15:40:00
67434572 | Affordability Product Incomplete | 11/06/2021 16:06:00
67434572 | Affordability Offered | 11/06/2021 16:06:00
67434572 | Affordability Referred | 11/06/2021 16:06:00
67434572 | Affordability Manual Assessment | 11/06/2021 16:13:00
67434572 | Affordability Accepted | 11/06/2021 16:13:00
67434572 | App incomplete | 11/06/2021 16:23:00
67434572 | App referred | 11/06/2021 16:48:00
67434572 | App Manual Assessment | 11/06/2021 16:57:00
67434572 | App accepted | 14/06/2021 09:50:00
67434572 | App Manual Assessment | 14/06/2021 09:50:00
67434572 | Awaiting documents | 14/06/2021 10:02:00
67434572 | App not proceeding | 16/09/2021 12:28:00
Spreadsheet: 196846d1354122474-autofilter-filter-containing-values-based-on-entries-of-table-list-in-a-sheet-sample_file
Sheet: DATA

ADDRESS |  |  |  |  | ADDRESS
the larches |  |  |  |  | AAA*
freemount lane
freemount street
freemount lane 7
5 the hill
18 freemount street
16 the grange
17 the grange
18 the grange
23 warren road
18 the grange close
34 smith street
18 park rd
the larches smith street
AAA1
AAA2
AAA3
AAA4
AAA5
AAA6
AAA7
AAA8
AAA9
AAA10
AAA11
AAA12
AAA13
AAA14
AAA15
AAA16
AAA17
AAA18
AAA19
AAA20
AAA21
AAA22
AAA23
AAA24
AAA25
AAA26
AAA27
AAA28
AAA29
AAA30
AAA31
AAA32
AAA33
AAA34
AAA35
AAA36
AAA37
AAA38
AAA39
AAA40
AAA41
AAA42
AAA43
AAA44
AAA45
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - M.Predial-Blindagem

 |  | CENTROS DE CUSTOS
 |  | Vale - M.Predial-Blindagem
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-09-14 00:00:00 | Combustivel | 54620 | 4176.6 | Gerador
 |  | 2020-09-09 00:00:00 | Frete |  | 40950 | Camiao [NAME]
 |  | 2020-09-10 00:00:00 | Frete |  | 40950 | Camiao [NAME]
 |  | 2020-09-11 00:00:00 | Frete |  | 40950 | Camiao [NAME]
 |  | 2020-09-17 00:00:00 | Combustivel | 54635 | 4054.7 | Logistica
 |  | 2020-09-18 00:00:00 | Combustivel | 54646 | 5390.6 | Gerador
 |  | 2020-09-24 00:00:00 | Combustivel | 54683 | 4176.6 | Gerador
 |  | 2020-09-29 00:00:00 | Combustivel | 54720 | 4487.2 | Logistica
 |  | 2021-01-25 00:00:00 | Combustivel | 55440 | 3703.2 | Logistica
 |  | 2021-01-27 00:00:00 | Combustivel | 55486 | 5079.8 | Logistica
 |  | 2021-01-28 00:00:00 | Combustivel | 55485 | 4073.4 | Gerador
 |  | 2021-01-31 00:00:00 | Combustivel | 55513 | 3250.7 | Logistica
 |  | 2021-01-20 00:00:00 | Combustivel | 55439 | 3288.42 | Logistica
 |  | 2021-01-20 00:00:00 | Combustivel | 55453 | 1885.2 | Logistica
 |  | 2021-01-29 00:00:00 | Combustivel | 55501 | 3952 | Logistica
 |  | 2021-02-04 00:00:00 | Combustivel | 55512 | 3921.2 | Logistica
 |  | 2021-02-04 00:00:00 | Combustivel | 55536 | 7000 | Logistica
 |  | 2021-02-07 00:00:00 | Combustivel | 55554 | 4059.46 | Logistica
 |  | 2021-02-10 00:00:00 | Combustivel | 55555 | 3214.9 | Logistica
 |  | 2021-02-13 00:00:00 | Combustivel | 55596 | 4150 | Logistica
 |  | 2021-02-15 00:00:00 | Combustivel | 55608 | 3820.7 | Logistica
 |  | 2021-02-17 00:00:00 | Combustivel | 55627 | 3876.6 | Logistica
 |  | 2021-02-19 00:00:00 | Combustivel | 55646 | 3742.12 | Logistica
Spreadsheet: 491017d1480265359-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-14-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1
2
3
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARINGS (Week End Total):
Spreadsheet: 149893d1334175308-excel-2007-sumproduct-across-multiple-worksheets-value-error-sample
Sheet: Sheet1

 | 100 | 101 |  |  |  | SUMPRODUCT(SUMIF(INDIRECT("'"&$M$9:$M$10&"'!$A$2:$A$4"),$A2,INDIRECT("'"&$M$9:$M$10&"'!$C$2:$B$4")))
Fred
[NAME] |  |  |  |  |  | SUMPRODUCT(($G$15:$G$18=G23)*($H$14:$K$14=$H$22)*($H$15:$K$18))
Darry
 |  |  |  |  |  |  |  |  |  |  |  | 100 | 101 | 102
 |  |  |  |  |  |  |  |  |  |  | Fred | Sheet2
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Sheet3
 |  |  |  |  |  |  | 100 | 101 | 100 | 101
 |  |  |  |  |  | Fred | 1 | 2 | 3 | 4
 |  |  |  |  |  | Darry | 5 | 6 | 7 | 8
 |  |  |  |  |  | Susi | 9 | 10 | 11 | 12
 |  |  |  |  |  | [NAME] | 13 | 14 | 15 | 16
 |  |  |  |  |  |  | 100 | 101
 |  |  |  |  |  | Fred
 |  |  |  |  |  | Darry
 |  |  |  |  |  | Susi
 |  |  |  |  |  | [NAME]
Spreadsheet: 725458d1616684940-aderence-forumla-help-please-adherence
Sheet: Adherence

 | Lunch |  |  |  |  |  |  |  | Comfort
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2021-03-01 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00
2021-03-02 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-02 00:00:00
2021-03-03 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-03 00:00:00
2021-03-04 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-04 00:00:00
2021-03-05 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-05 00:00:00
2021-03-06 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-06 00:00:00
2021-03-07 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-07 00:00:00
2021-03-08 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-08 00:00:00
2021-03-09 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-09 00:00:00
2021-03-10 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-10 00:00:00
2021-03-11 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-11 00:00:00
2021-03-12 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-12 00:00:00
2021-03-13 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-13 00:00:00
2021-03-14 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-14 00:00:00
2021-03-15 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-15 00:00:00
2021-03-16 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-16 00:00:00
2021-03-17 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-17 00:00:00
2021-03-18 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-18 00:00:00
2021-03-19 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-19 00:00:00
2021-03-20 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-20 00:00:00
2021-03-21 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-21 00:00:00
2021-03-22 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-22 00:00:00
2021-03-23 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-23 00:00:00
2021-03-24 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-24 00:00:00
2021-03-25 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-25 00:00:00
2021-03-26 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-26 00:00:00
2021-03-27 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-27 00:00:00
2021-03-28 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-28 00:00:00
2021-03-29 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-29 00:00:00
2021-03-30 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-30 00:00:00
2021-03-31 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-31 00:00:00
Spreadsheet: 41118d1239644773-converting-score-sheet-to-lookup-formula-determine-20rating-1-
Sheet: Sheet1

Age |  | Excellent | Good | Average | Fair | Low
20-29 |  | > 35 | 29-35 | 22-28 | 17-21 | < 17
30-39 |  | > 29 | 22-29 | 17-21 | 12-16 | < 12
40-49 |  | > 21 | 17-21 | 13-16 | 10-12 | < 10
50-59 |  | > 20 | 13-20 | 10-12 | 7-9 | < 7
60-69 |  | > 17 | 11-17 | 8-10 | 5-7 | < 5
If I have a person that is 42 years old who scores a 19, I need to know how to lookup the correct rating, which should be 'Good'.
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
20 | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Fair | Fair | Fair | Fair | Fair | Average | Average | Average | Average | Average | Average | Average | Good | Good | Good | Good | Good | Good | Good | Excellent
30 | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Fair | Fair | Fair | Fair | Fair | Average | Average | Average | Average | Average | Good | Good | Good | Good | Good | Good | Good | Good | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
40 | Low | Low | Low | Low | Low | Low | Low | Low | Low | Low | Fair | Fair | Fair | Average | Average | Average | Average | Good | Good | Good | Good | Good | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
50 | Low | Low | Low | Low | Low | Low | Low | Fair | Fair | Fair | Average | Average | Average | Good | Good | Good | Good | Good | Good | Good | Good | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
60 | Low | Low | Low | Low | Low | Fair | Fair | Fair | Average | Average | Average | Good | Good | Good | Good | Good | Good | Good | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
Person name | Age | Score
Person name | Age | Score
[NAME] | 22 | 16 | Low
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Person name | Age | Score
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Seasonal

Location | Trainee First Name | Trainee Last Name | Position | Needs to Attend:               Day 1 and 2    (Y/N) | Needs to Attend:               DOT- Day 3          (Y/N) | [NAME] | [NAME]
Spreadsheet: 137364d1327076619-how-to-filter-this-data-correctly-audit-template
Sheet: Audit Programme 

Audit Title | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
ATM Module Repair |  |  |  |  |  |  |  |  | 2011
Completed
Planned
Overdue
Spreadsheet: 99267d1297959245-cell-not-duplicated-on-three-rows-but-need-to-use-it-in-function-possible-example1
Sheet: Master

AccountID | CFType |  | January | February | March | April | May | June | July | August | September | October | November | December
123 | 1
 | 2
 | 3
432 | 1
 | 2
 | 3
444 | 1
 | 2
 | 3
5423 | 1
 | 2
 | 3
544 | 1
 | 2
 | 3
Spreadsheet: 856062d1705445067-dynamic-conditional-formatting-on-activity-calendar-cal-workbook
Sheet: Week 1 (2)

 | STUDY SCHEDULE |  |  |  |  | SCHEDULE START | TIME INTERVAL | Class List
 |  |  |  |  |  | 06:00:00 | 15 MIN
 | TIME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 117632d1312917652-referencing-group-summary-and-sorting-example1-1-
Sheet: Overview

 | Example
ID | Merchant Name | Amount | Sold | Total | Available | Month
3816 |  |  | 354
3816 |  |  | 37
6367 |  |  | 213
3816 |  |  | 7
6367 |  |  | 6
6748 |  |  | 202
3816 |  |  | 4
6367 |  |  | 5
3816 |  |  | 27
 |  |  | -55
 | Merchant A | 10000 |  | 800 |  | 2011-02-01 00:00:00
 | Merchant B | 20000 | 1142 | 1142 |  | 2011-02-01 00:00:00
 | Merchant C | 40000 | 4024 | 4000 |  | 2011-03-01 00:00:00
 | Merchant D | 15750 | 3000 | 3000 |  | 2011-03-01 00:00:00
5694 |  |  | 293
5694 |  |  | 125
5694 |  |  | 67
5694 |  |  | 808
5694 |  |  | 232
5694 |  |  | 14
 | Merchant E | 10000 |  | 1516 |  | 2011-03-01 00:00:00
 | Merchant F | 20000 | 2793 | 2778 |  | 2011-04-01 00:00:00
 |  |  | 473
6056 |  |  | 6
6375 |  |  | 1048
 |  |  | 1806
 | Merchant G | 25000 |  | 3333 |  | 2011-05-01 00:00:00
 | Merchant H | 10000 | 3439 | 1333 |  | 2011-05-01 00:00:00
6518 |  |  | 472
6518 |  |  | 175
6518 |  |  | 591
 |  |  | 33
 | Merchant I | 10000 |  | 1000 |  | 2011-05-01 00:00:00
 | Merchant J | 12750 | 100 | 100 |  | 2011-05-01 00:00:00
6489 |  |  | 1267
6489 |  |  | 424
6489 |  |  | 1134
 | Merchant K | 10000 |  | 2778 |  | 2011-05-01 00:00:00
 |  |  | 351
 |  |  | 49
 | Merchant L | 5400 |  | 200 |  | 2011-07-01 00:00:00
 |  |  | 404
 |  |  | 452
 |  |  | 69
 |  |  | 48
 |  |  | 36
 |  |  | 164
 |  |  | 55
 |  |  | 4
 | Merchant M | 10000 |  | 1538 |  | 2011-01-01 00:00:00
 |  |  | 454
 |  |  | 140
 |  |  | 184
 |  |  | 208
 |  |  | 171
 |  |  | 156
 |  |  | 402
 |  |  | 15
 | Merchant N | 10000 |  | 2425 |  | 2011-01-01 00:00:00
 |  |  | 364
 |  |  | 42
 |  |  | 56
 |  |  | 65
 |  |  | 18
 |  |  | 16
 |  |  | 5
 | Merchant O | 10010 |  | 572 |  | 2011-02-01 00:00:00
 |  |  | 410
 |  |  | 302
 |  |  | 6
 |  |  | 200
 |  |  | 132
 |  |  | 402
 |  |  | 51
 |  |  | 47
 |  |  | 142
 | Merchant P | 7500 |  | 2500 |  | 2011-02-01 00:00:00
 |  |  | 126
 |  |  | 75
 |  |  | 33
 |  |  | 12
 |  |  | 2
 |  |  | 287
 |  |  | 7
 | Merchant Q | 5000 |  | 1000 |  | 2011-02-01 00:00:00