tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802281d1666768539-display-and-count-values-in-an-array-that-do-not-match-values-another-array-display_count_unmatches_v2
Sheet: Feuil1

 | UNMATCHES: | dark (1), black (8)
 |  | (expected result)
 |  |  |  |  |  |  |  |  | STEPS
 | list | control_list_split |  |  |  | authorized_values |  |  | VSTACK |  | UNMATCH
 | black |  |  |  |  | green
 | black |  |  |  |  | white |  |  | black |  | black
 | black |  |  |  |  | light |  |  | black |  | black
 | black |  |  |  |  | yellow |  |  | black |  | black
 | transparent |  |  |  |  | transparent |  |  | transparent
 | gray,white |  | white |  |  | gray |  |  | gray
 | white |  |  |  |  | red |  |  | white
 | white |  |  |  |  | [NAME] |  |  | white
 | light,yellow |  | yellow |  |  |  |  |  | light
 | dark,gray,black |  | gray | black |  |  |  |  | dark |  | dark
 | black |  |  |  |  |  |  |  | black |  | black
 | white |  |  |  |  |  |  |  | white
 | black |  |  |  |  |  |  |  | black |  | black
 | black |  |  |  |  |  |  |  | black |  | black
 | green |  |  |  |  |  |  |  | green
 | red |  |  |  |  |  |  |  | red
 | red,brown |  | [NAME] |  |  |  |  |  | red
 |  |  |  |  |  |  |  |  | white
 |  |  |  |  |  |  |  |  | yellow
 |  |  |  |  |  |  |  |  | gray
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | black |  | black
Spreadsheet: 5a9665d6-e7f7-466d-8114-fe896fcb0a52
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
Spreadsheet: 870352d1716887322-modifying-table-to-be-more-dynamic-issue
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044 | Rem.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 |  |  |  |  | 56790.11999999999 |  |  | 53790.11999999999 |  |  | 55790.11999999999 |  |  | 53790.11999999999
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 |  | 56179.39999999999 |  |  | 57179.39999999999 |  |  | 58179.39999999999 |  |  | 59179.39999999999 |  |  | 58179.39999999999
7 | Name7 |  |  | PURAVIKU6 |  |  | Client3 |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4
8 | Name8 |  |  | PURAVIKU6 |  |  | Client4.5
9 | Name9 |  |  | PURAVIKU7 |  |  | Client5 |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4 |  |  | 58179.4
Spreadsheet: 845758d1697118103-if-formula-to-calculate-banding-based-on-multiple-criteria-banding-calcs
Sheet: Sheet1

UK |  |  | Scottish |  |  | Wales |  |  |  |  |  |  |  |  |  |  |  |  | Country | Upper | Band
£0.01 - £37,700.99 | 0.2 |  | £0.01 - £2,162.99 | 0.19 |  | £0.01 - £37,700.99 | 0.2 |  |  |  |  |  |  |  |  |  |  |  | England | 37701 | 0.2
£37,701 - £150,000 | 0.4 |  | £2,163 - £13,118.99 | 0.2 |  | £37,701 - £150,000 | 0.4 |  |  |  |  |  |  |  |  |  |  |  | England | 150000.01 | 0.4
Over £150,000 | 0.45 |  | £13,119 - £31,092.99 | 0.21 |  | Over £150,000 | 0.45 |  |  |  |  |  |  |  |  |  |  |  | England | Over 150k | 0.45
 |  |  | £31,093 - £150,000 | 0.41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 2163 | 0.19
 |  |  | Over £150,000 | 0.46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 13119 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 31093 | 0.21
Country | Tax Code Breakdown | Tax Free Allowance | Taxable Pay | Tax Banding | PSA Tax Rate | Banding |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | 150000.01 | 0.41
England | 1257 |  | -3145.6 | 0 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland | Over 150k | 0.46
Wales | 77 |  | -261.35 | 0 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wales | 37701 | 0.2
England | 1257 |  | 22446.37 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wales | 150000.01 | 0.4
Scotland | 1257 |  | 17344 | 0.21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wales | Over 150k | 0.45
Wales | 1257 |  | 15176.29 | 0.2
Wales | 1256 |  | -3104.610000000001 | 0 | 0.2
Wales | 1257 |  | 28572.18 | 0.2
Wales | 1257 | 12570 | 59503.56 | 0.4 | 0.4
Wales | 1257 | 12570 | 41533.83 | 0.4 | 0.4
See start of forumla in colum G, how do I build on that to give me the correct banding based on country and taxable pay. Banding is shown in tables above
Column F has the correct answers but these have been put in manually and I need a formula as over 800 lines.
Spreadsheet: 759451d1639559803-highlight-to-separate-the-cells-containing-numbers-and-letters-cf-confo-aligw
Sheet: Sheet1

Main Data Array |  |  |  |  |  | Color Scheme
A | TT | 1 | WS |  |  |  | Numerals (e.g. 1,23,7, etc.
B | S | 23 | 7 |  |  |  | Cells with 1 letter (e.g. A, B, R, D, ETC.)
GG | WE | DD | 8 |  |  |  | Cells with 2 letters (e.g. FG, SD TT, WE, etc.)
FG | R | JK | HG
D | TT | H | 43 |  |  | How can I apply this color scheme in Main Data Array by applying formula in conditional formatting?
SD | FG | JK | L
SD | DF | U | Q
Spreadsheet: 41656d1240219320-if-name-then-cell-reference-example-1-
Sheet: Summary

 | [NAME] | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Total Score % | Extra Cost £
 | Chanowsk, Ania | 0.9 | N/A | N/A | N/A | N/A | 0.9 | 10.5
 | Davies, [NAME] | N/A | 0.5 | 0.6 | N/A | N/A | 0.55 | 0
 | Hilton, [NAME] | N/A | N/A | N/A | 0.1 | 0.5 | 0.3 | 0
 | Jones, [NAME] | 0 | N/A | N/A | N/A | N/A | 0 | N/A
 | [NAME], [NAME] | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.03000000000000001 | N/A
 | Lyon, [NAME] | 0.6 | N/A | N/A | N/A | N/A | 0.6 | 0
 | McCormack, Kirsty | N/A | N/A | N/A | N/A | N/A | #N/A | 0
 | McDonald, [NAME] | N/A | N/A | N/A | N/A | N/A | #N/A | 1.27
 | Osborne, [NAME] | N/A | N/A | N/A | N/A | N/A | #N/A | N/A
 | White, [NAME] | 0.65 | 0.66 | 0.67 | 0.68 | 0.69 | 0.67 | 7
 | Yates, [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | N/A
 |  |  |  |  |  |  |  | 18.77
Spreadsheet: 222008d1363725178-search-data-to-see-if-any-rows-match-multiple-criteria-example
Sheet: Sheet1

Template Name | Commodity | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Field 10
FD_G_KWH_S | Electric | off peak usage | on peak usage | total cost
FD_S_CCF_01 | Gas | gas usage & cost | energy supply charge | [NAME] charge | usage and cost adjustments | taxes | late fee
FD_KWH_S_N_01 | Electric | electric usage | total cost
T_MMBTU_01 | Gas | usage (mmbtu) | total cost
Spreadsheet: 4811567f-45a7-445f-b17d-2e45db8ea83a
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
[NAME] | Women's Tennis | Air Force Tournament | 12:00 AM | Results
[NAME] | Women's Tennis | Air Force Tournament | 12:00 AM | Results
09/29/2013 | Women's Tennis | Air Force Tournament | 12:00 AM | Results
10/04/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/05/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/06/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/18/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/19/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/20/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/21/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
11/01/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
11/02/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
11/03/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
01/17/2014 | Women's Tennis | Akron | 12:00 AM | L, 4-3
01/25/2014 | Women's Tennis | Liberty | 12:00 AM | L, 6-1
02/01/2014 | Women's Tennis | at [NAME] | 12:00 AM | L, 6-1
02/07/2014 | Women's Tennis | Cal PA | 12:00 AM | W, 5-2
02/14/2014 | Women's Tennis | Richmond (Norfolk, Va.) | 12:00 AM | L, 4-1
02/15/2014 | Women's Tennis | at ODU | 12:00 AM | L, 6-1
02/21/2014 | Women's Tennis | University of Charleston | 12:00 AM | W, 6-1
[NAME] | Women's Tennis | Buffalo | 12:00 AM | L, 5-2
03/02/2014 | Women's Tennis | at Penn State | 12:00 AM | L, 6-1
03/08/2014 | Women's Tennis | Cornell | 02:00 PM | L, 5-2
03/09/2014 | Women's Tennis | West Virginia State University | 12:00 PM | W, 6-1
03/14/2014 | Women's Tennis | Kansas State* | 01:00 PM | L, 4-3
03/16/2014 | Women's Tennis | Kansas* | 11:00 AM | L, 7-0
03/21/2014 | Women's Tennis | at Baylor* | 05:00 PM | L, 7-0
03/23/2014 | Women's Tennis | at Texas* | 12:00 PM | L, 7-0
[NAME] | Women's Tennis | Texas Tech* | 01:00 PM | L 7-0
03/30/2014 | Women's Tennis | TCU* | 10:00 AM | L, 4-0
04/04/2014 | Women's Tennis | at Oklahoma* | 05:00 PM | L, 7-0
04/05/2014 | Women's Tennis | at Oklahoma State* | 06:00 PM | L, 7-0
04/13/2014 | Women's Tennis | Iowa State* | 11:00 AM | L, 5-2
04/24/2014 | Women's Tennis | Kansas State* (Big 12 Championship - Fort Worth, Texas) | 11:00 AM | L, 4-0
Spreadsheet: 271845d1382084107-how-to-extract-data-from-a-list-sample-sheet
Sheet: RESULT

[NAME] | qty | sell | who | date | week | Period | Value
B4W2MP | 90 | 1.65 | TOOLSTA | 2013-01-03 00:00:00 | 1 | P1 | 148.5
B4W2MP | 450 | 1.65 | TOOLSTA | 2013-01-03 00:00:00 | 1 | P1 | 742.5
B4W2MP | 30 | 1.55 | BANNH02 | 2013-01-03 00:00:00 | 1 | P1 | 46.5
B4W2MP | 30 | 1.69 | BRACKENH | 2013-01-07 00:00:00 | 2 | P1 | 50.7
B4W2MP | 420 | 1.75 | TOOLSTA | 2013-01-08 00:00:00 | 2 | P1 | 735
B4W2MP | 60 | 1.87 | HOMEHARD | 2013-01-08 00:00:00 | 2 | P1 | 112.2
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: SE-EGM-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM)
REGION: SOUTHEAST
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 33baf376-44c8-4f31-af39-1db46e8941f3
Sheet: Rankings - 2008

Player | Adjusted Rank | Adjusted Success rate (%) (90% CI) | Attempts
[NAME] | 1 | 80 (66-89) | 31
[NAME] | 2 | 79 (64-89) | 18
[NAME] | 3 | 78 (60-89) | 14
[NAME] | 4 | 78 (59-89) | 14
[NAME] | 5 | 78 (63-87) | 44
[NAME] | 6 | 76 (60-87) | 22
[NAME] | 7 | 76 (56-89) | 10
[NAME] | 8 | 76 (60-86) | 32
[NAME] | 9 | 75 (56-88) | 5
[NAME] | 10 | 73 (58-84) | 30
[NAME] | 11 | 73 (54-86) | 12
[NAME] | 12 | 73 (54-86) | 9
[NAME] | 13 | 73 (54-86) | 9
[NAME] | 14 | 73 (59-83) | 96
[NAME] | 15 | 73 (54-86) | 19
[NAME] | 16 | 72 (54-85) | 10
Jean-Baptiste Elissalde | 17 | 63 (42-80) | 12
[NAME] | 18 | 61 (41-78) | 12
Spreadsheet: 02ab93e7-6c8d-4089-9af7-54c7a9ee5f02
Sheet: Admissions

 | CMH Admissions July | CMH Discharges July | AMH Admissions July | AMH Discharges July | AMH Clients Served July | CMH Clients Served July | 19 2524 Assessments
Region 1 | 7 | 5 | 22 | 33 | 1636 | 64 | 3
Region 2 | 1 | 2 | 8 | 19 | 1409 | 67 | 1
Region 3 | 7 | 2 | 19 | 14 | 2683 | 70 | 19
Region 4 | 10 | 15 | 16 | 14 | 2673 | 121 | 22
Region 5 | 2 | 7 | 7 | 18 | 1250 | 45 | 10
Region 6 | 3 | 8 | 10 | 14 | 1514 | 54 | 11
Region 7 | 4 | 11 | 26 | 33 | 3126 | 165 | 15
Statewide Total | 34 | 50 | 108 | 145 | 14291 |  | 81
Spreadsheet: 53577d1253541468-exclusive-selection-testspqr
Sheet: Sheet1

 | Own Laptop | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | C8 | Units | Unit Fee | Connectivity Fee | Total Fee
Customer 1 |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3
Customer 2 |  |  |  |  |  |  |  |  |  | 6 | 8.5 | 0 | 8.5
Customer 3 |  |  | Yes |  |  |  |  |  |  | 6 | 8.5 | 0 | 8.5
Customer 4 |  |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 3
Customer 5 | Yes |  |  | Yes |  |  |  |  |  | 5 | 6 | 1.5 | 7.5
Customer 6 |  |  |  |  |  |  |  |  |  | 5 | 6 | 0 | 6
Customer 7 |  |  |  |  |  |  |  |  |  | 3 | 3.75 | 0 | 3.75
Customer 8 |  |  |  |  |  |  |  |  |  | 4 | 4.75 | 0 | 4.75
Customer 9 |  |  |  |  |  |  |  |  |  | 4 | 4.75 | 0 | 4.75
Customer 10 |  |  |  |  |  |  |  |  |  | 6 | 8.5 | 0 | 8.5
 |  |  |  |  |  |  |  |  |  |  |  | Daily income | 58.25
Spreadsheet: 73508d1274182786-merge-calendar-in-excel-keith-smale
Sheet: Jun 10

 | June 2010
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | [NAME] new staff training support | [NAME] / post 5.30 sales training wirh Wembley staff | [NAME] for Friction training and Normfest training | Hull Warehouse training follow up action plan setting
 |  | Bradford branch support / training | Bradford Branch support / training | Coventry new staff training support | Leicester new staff training support | Wembley Friction Expert training SA  Training | Wembley Friction Expert training SA  Training
 |  | New Branch training TBA | New Branch training TBA | New Branch training TBA | New Branch training TBA | [NAME] SDM  Training | Wembley Normfest SDM Training
 |  | Warrington sales / warehouse support (New Branch) | Warrington sales / warehouse support  (New Branch) | Warrington sales / warehouse support  (New Branch) | Warrington sales / warehouse support  (New Branch) | Warrington sales / warehouse support  (New Branch)
 |  | New Branch training TBA | New Branch training TBA | New Branch training TBA
Spreadsheet: e2e93221-ba70-4bf3-bda3-6459bf073ff8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FEWG4 | Test | FEWG4 | Egg White IgG4 | Egg White IgG4 | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <0.15 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG4 tests has not been clearly established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food related complaints, and to evaluate food allergic patients prior to food challenges. The presence of food-specific IgG4 alone cannot be taken as evidence of food allergy and only indicated immunologic sensitization to the food allergen in question.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 2 - 3 days | 4 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FEWG4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FEWG4 | Result | FEWG4 | Egg White IgG4 | Egg White IgG4 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 81602d1281714748-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records
Sheet: All_Records

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-000-000
Green llc | Stephen | Gills | Director | 123, Texas, USA | 543-333-233 | www.bigdesign.com
Green llc | [NAME] | McKay | CEO | 34B, London, UK | 432-455-354 | www.bigdesign.com
Angry [NAME] | [NAME] | Tilds | Technician | 333, NYC , USA | 111-111-111 | www.angryfox.com
TP21 Company | [NAME] | Mott |  |  | 101-101-909
 | [NAME] | Mobile |  | 33, NY
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
 | Ramon | Hobbs | Secretary | 123, AB, USA | 123-101-100
ABC LLC | [NAME] | Fard | Technician | Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 456-678-876 | www.abc.com
 | [NAME] | Folder | Sales
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
 | [NAME] | [NAME] | Production |  | 345-345-444
 | [NAME] | Bond |  | VP | 165-827-272
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000
Future Ltd | [NAME] | Farris |  | 34, New Zeland | 103-340-009 | www.futureltd.com
 | [NAME] |  |  |  | 102-090-292
Spreadsheet: 788489d1658497905-max-value-in-a-row-max-value-for-five-extra-columns
Sheet: Blad1

ARTICLENR | NR of purchases A | Purhcaser B | Purchaser c | Purchaser d | Purchaser e |  | Article nr | Highest nr of purchases
E1 | 3 | 1 | 4 |  |  |  |  | 56 |  |  | 47 |  |  | 67 |  |  | 0 |  |  | 0
E2 | 5 | 4 | 35 |  |  |  | E8 | 27 |  | E7 | 45 |  | E5 | 58 |  | E2 | 0 |  | E2 | 0
E3 | 2 | 47 | 67 |  |  |  | E5 | 23 |  | E9 | 25 |  | E2 | 35 |  | E3 | 0 |  | E3 | 0
E4 | 56 | 6 | 23
E5 | 23 | 2 | 58
E6 | 12 | 7 | 2
E7 | 17 | 45 | 4
E8 | 27 | 14 | 1
E9 | 3 | 25 | 4
E10 | 6 | 3 | 6
Spreadsheet: 143852d1330601519-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-3
Sheet: Incident_Accident

Date of Incident | Month of Indicent | Date Reported | Accident / Injury Happened To: | Name of Service User /  Staff of Other | Name of Provider | Type of notification | What happened | Date CQC notified | Conclusion | Completed by (SW) | What can be learned from this which would prevent a future occurance?
01.01.2011 | April | 01.01.2011 | STAFF | [NAME] | Sky | Illness
15.05.2011 |  | 16.05.2011 |  | [NAME] | River
16.06.2011 | April | 17.06.2011 |  | Un known | un known | Seizures
 | April |  |  |  |  | Event that adversely affects the person’s safety & welfare
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0112

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0112 |  |  | 1P
W912LP-09-P-0112 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 827250d1682580786-filter-function-breaks-the-formula-sample-workbook1
Sheet: Sheet1

 |  |  |  |  | This works |  |  | This works |  |  | LET(x,UNIQUE(FILTER(Table1[value1],Table1[value2]="a")),y,UNIQUE(x),SORTBY(x,COUNTIF(x,y),-1)) |  |  | LET(x,Table1[value1],u,UNIQUE(FILTER(x,Table1[value2]="a")),SORTBY(u,COUNTIF(x,u),-1))
 | value1 | value2 |  |  | Value | Count |  | Value
 | 123 | a
 | 123 | a |  |  | 789 |  |  | 123 |  |  | 456 |  |  | 789
 | 456 | a |  |  | 456 |  |  | 456 |  |  | 789 |  |  | 456
 | 456 | b |  |  |  |  |  | 789
 | 123 | b |  |  |  |  |  | 456
 | 123 | b |  |  |  |  |  | 123
 | 789 | a |  |  |  |  |  | 123
 | 456 | a |  |  |  |  |  | 456
 | 123 | a |  |  |  |  |  | 789
 | 123 | a |  |  |  |  |  | 456
 | 456 | a |  |  |  |  |  | 123
 | 456 | b |  |  |  |  |  | 123
 | 123 | b |  |  |  |  |  | 456
 | 123 | b |  |  |  |  |  | 789
 | 789 | a |  |  |  |  |  | 456
 | 456 | a |  |  |  |  |  | 789
 | 123 | a |  |  |  |  |  | 789
 | 123 | a |  |  |  |  |  | 789
 | 456 | a |  |  |  |  |  | 789
 | 456 | b |  |  |  |  |  | 789
 | 123 | b |  |  |  |  |  | 789
 | 123 | b |  |  |  |  |  | 789
 | 789 | a
 | 456 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 789 | a
Spreadsheet: 722105d1615041128-index-and-match-function-if-0-is-higher-or-lower-book1
Sheet: Sheet2

 |  |  |  | Example 1 | 50 |  | 0.7999999999999972 |  | 51.3 |  | 1.299999999999997 |  | 53.2 |  | 1.299999999999997
 |  |  |  | Example 2 | 52.6 |  |  |  | 49.4 |  |  |  | 51.5
 |  |  |  |  | >=50 | Y | >=0 | Y | >=50 | Y | >=0 | Y | >=50 | Y | >=0 | Y | 5 |  | 8
 |  |  |  |  | >=50 | Y | <0 | N | >=50 | Y | >=0 | Y | >=50 | Y | >=0 | Y | 5 |  | 8
 |  |  |  |  | >=50 | Y | <0 | N | >=50 | Y | <0 | N | >=50 | Y | >=0 | Y | 5 |  | 8
 |  |  |  |  | >=50 | Y | >=0 | Y | >=50 | Y | <0 | N | >=50 | Y | <0 | N | 0 |  | 5
 |  |  |  |  | >=50 | Y | <0 | N | >=50 | Y | <0 | N | >=50 | Y | <0 | N | 0 |  | 5
 |  |  |  |  | >=50 | Y | >=0 | Y | >=50 | Y | >=0 | Y | >=50 | Y | <0 | N | -8 |  | -10
 |  |  |  |  | <50 | N | <0 | N | <50 | N | <0 | N | <50 | N | >=0 | Y | -8 |  | 10
 |  |  |  |  | <50 | N | >=0 | Y | <50 | N | <0 | N | <50 | N | <0 | N | -5 |  | -8
 |  |  |  |  | <50 | N | <0 | N | <50 | N | <0 | N | <50 | N | <0 | N | -5 |  | -8
 |  |  |  |  | <50 | N | >=0 | Y | <50 | N | >=0 | Y | <50 | N | >=0 | Y | 0 |  | -5
 |  |  |  |  | <50 | N | >=0 | Y | <50 | N | <0 | N | <50 | N | >=0 | Y | 0 |  | -5
 |  |  |  |  | N |  | O |  | P |  | Q |  | R |  | S |  | T |  | U
 |  |  |  | Example 1 result
 |  |  |  | Example 2 result
 |  |  |  |  |  | 50 | 0 | 50 | 0 | 50 | 0 | TRUE ("Y") vs FALSE ("N") for values ">=" to limits in G20:L20 |  |  |  |  |  | Results
 |  |  |  |  | 2016-05-01 00:00:00 | 49.2 |  | 50 |  | 51.3
 |  |  |  |  | 2016-06-01 00:00:00 | 50 |  | 51.3 |  | 53.2
 |  |  |  |  | 2016-07-01 00:00:00 | 51.3 |  | 53.2 |  | 52.6
 |  |  |  |  | 2016-08-01 00:00:00 | 53.2 |  | 52.6 |  | 49.4
 |  |  |  |  | 2016-09-01 00:00:00 | 52.6 |  | 49.4 |  | 51.5
 |  |  |  |  | 2016-10-01 00:00:00 | 49.4 |  | 51.5 |  | 51.9
 |  |  |  |  | 2016-11-01 00:00:00 | 51.5 |  | 51.9 |  | 53.2
 |  |  |  |  | 2016-12-01 00:00:00 | 51.9 |  | 53.2 |  | 54.7
 |  |  |  |  | 2017-01-01 00:00:00 | 53.2 |  | 54.7 |  | 56
 |  |  |  |  | 2017-02-01 00:00:00 | 54.7 |  | 56 |  | 57.7
 |  |  |  |  | 2017-03-01 00:00:00 | 56 |  | 57.7 |  | 57.2
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: January

JANUARY | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0