tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 829800d1684448823-matching-info-from-tab-2-to-tab-1-with-one-common-cell-identifier-s666-pq-matching-info-from-tab-2-to-tab-1-with-one-common-cell-identifier
Sheet: result

Name | Certificate # | DN.1 | DOB.1 | Gender.1 | Status.1 | DN.2 | DOB.2 | Gender.2 | Status.2 | DN.3 | DOB.3 | Gender.3 | Status.3 | DN.4 | DOB.4 | Gender.4 | Status.4 | DN.5 | DOB.5 | Gender.5 | Status.5 | DN.6 | DOB.6 | Gender.6 | Status.6
[NAME] | 1000000 | [NAME] | 09/04/1969 | Female | Spouse | [NAME] | 23/02/2000 | Female | Child
[NAME] | 1000001 | [NAME] | 10/06/1976 | Female | Spouse | April Doe | 13/07/2001 | Female | Child | [NAME] | 23/03/2005 | Female | Child | [NAME] | 03/07/2008 | Male | Child | Peach Jones | 11/03/2006 | Male | Child | [NAME] | 08/04/2013 | Male | Child
Spreadsheet: 163017d1340149099-make-a-repair-and-maintenance-report-with-printable-form-testing
Sheet: Sheet1

 | ITEM # | RMR # | DATE | ESN | VAN # | ERH | SERVICE TYPE | WORK CODE | TROUBLE | PART # | PART NAME | QUANTITY | REMARKS | REMARKS FOR REPAIR HISTORY | Site Name
 | 1 | 235 | 2012-06-12 00:00:00 | 12345 | 234 | 45 | R |  |  | 12 | GASKET | 2
 | 2 | 236 | 2012-06-13 00:00:00 | 12309 | 213 | 38 | R |  |  | 13 | TIRE | 2
 | 3 | 237 | 2012-06-14 00:00:00 | 12343 | 231 | 34 | B |  |  | 11 | REF | 2
 | 4 | 238 | 2012-06-15 00:00:00 | 12342 | 198 | 33 | B |  |  | 10 | TUBE | 3
 | 5 | 235 |  |  |  |  | B |  |  | 20 | BOLT | 4 | [NAME]
 | 6 | 235 |  |  |  |  | B |  |  | 21 | NUT | 7 | [NAME]
 | 7 | 238 |  |  |  |  | B |  |  | 22 | SCREW | 3 | [NAME]
 | 8 | 235 |  |  |  |  | B |  |  | 23 | WASHER | 8 | [NAME]
 | 9 | 235 |  |  |  |  | B |  |  | 24 | BRACKET | 2 | [NAME]
 | 10 | 238 |  |  |  |  | B |  |  | 25 | HOSE | 9 | [NAME]
Spreadsheet: 24657d1215356581-creating-an-auto-counting-sheet-count
Sheet: Sheet1

DATA | TKT#1 | TKT#2 | TKT#3 | TKT#4 | TKT#5
PRO | 6071 | 6072 | 6073 | 6074 |  |  | 4
REW | 6075 | 6076 |  |  |  |  | 2
PRO | 6077 | 6078 | 6079 |  |  |  | 3
REV | 6080 |  |  |  |  |  | 1
REW | 6081 | 6081 | 6081 | 6081 | 6081 |  | 5
 | PRO | 7
 | REV | 1
 | REW | 7
Spreadsheet: 829043d1683881798-aggregate-value-calculation-with-excel-formula-agg-value-sum
Sheet: Sheet1

 |  | Customer | Sale | Product | bid | higest bid | bid ( Sum )
 |  | Abc | 123 | 1 | 10 | False
 |  | Abc | 123 | 2 | 20 | False
 |  | Abc | 123 | 3 | 30 | True
 |  | Abc | 123 | 4 | 40 | True
 |  | Abc | 123 | 5 | 50 | True
 |  | Xyz | 456 | 6 | 60 | True
 |  | Xyz | 456 | 7 | 70 | True
 |  | Xyz | 456 | 8 | 80 | False
 |  | If Col - customer & sale & higest bid ( TURE only ) , sum the value of col 'bid' ( For TRUE transactiosn ) and update the same col "bid ( sum )  Note :  I looking or a if function formula so that its getting updated as and when the data changes  we need the sum in one of the row in col 'bid (Sum), example hilighted ( Red ) for ref
Spreadsheet: 693008d1598694587-countif-formula-for-horizontal-data-with-alphabets-sample-project-attendence
Sheet: Sheet1

 |  | AUG'20
 |  | PROJECTS WORKED
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6
 | WORKERS | DAY 1 | DAY 2 | DAY 3 | DAY 4 | DAY 5
 | BABU | AL | AL | AL | AL | AL
 | NITESH | AL | AL | AL | ZU | AL
 | JAGGU | AL | ZU | DIP | DIP | AL
 | [NAME] | ZU | ZU | ZU | DIP | DIP
 | SUNU | ZU | AL | AL | AL | DIP
 | KEELU | DIP | DIP | DIP | AL | AL
 | RAMESH | DIP | DIP | AL | AL | ZU
 | KAMLESH | DIP | AL | ZU | DIP | ZU
 |  |  |  | Number of man days
 |  |  |  |  | AL | ASHOK LEYLAND
 |  |  |  |  | ZU | ZAYED UNIVERSITY
 |  |  |  |  | DIP | ALSTOM
 |  | BABU | AL
 |  | NITESH | AL
 |  | JAGGU | DIP
 |  | [NAME] | ZU
 |  | SUNU | ZU
 |  | KEELU | DIP
 |  | RAMESH | DIP
 |  | KAMLESH | DIP
Spreadsheet: 706361d1606660768-used-index-and-mutch-function-and-i-need-specific-cell-not-value-indexmuchfunction
Sheet: Data2

the column C7:C11 has a drop-down list
info1 | info2 | NAME | [NAME] | [NAME] | [NAME] | data2
 |  | PHOTO
 |  | ALPHA |  |  | text1 |  |  |  | EXAMPLE
 |  | DELTA |  |  |  |  | example: add value text1 F9 or text2 G9, then [NAME] (E9 cell), is not value (see example row 10 and 11)
 |  | PHOTO |  |  | text1 |  | I deleted the functions to show you the example
 |  | PHOTO |  |  |  | text2
 |  |  | Add text1 not value
 |  |  | Add text2 not value
Spreadsheet: 01a45f19-1ba6-4941-93c0-1a19ca6716df
Sheet: Sheet1

SPENDING PLAN FOR COMMUNITY SCHOOLS  - FY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
IRN:
Community School Name:
Contact Name:
Sponsor:
 | July | Aug | Sept. | Oct. | Nov. | Dec. | Jan. | Feb. | Mar. | Apr. | May | June
Acct./mth.
Receipts
Beginning Cash Balance
School Foundation
Federal Sub-Grant
CCIP Funds
Other
Total Receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenditures
100 Salaries
200 Fringes
400 Purchased Services
500 Supplies
600 New Equipment
700 Replace Equipment
800 Fixed Charges
Total Expenditures | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending Cash Balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spending Plan  Form D
Revised:  April 2014
Spreadsheet: 346345d1411090944-auto-populate-sheets-based-on-master-sheet-example-2-
Sheet: Edmonton

First Name | Last Name | City | Skills
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Sheet1

DALE INC COMMISSION REPORT / DAVIS WINDOWS AND DOOR SALES / JANUARY / 2024
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT
1 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
2 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
3 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
4 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
5 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
6 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
7 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.2
8 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.2
9 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.25
10 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
11 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
12 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.25
13 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.25
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
Spreadsheet: 762476d1641571456-conditional-formatting-based-on-value-in-another-cell-and-todays-date-schedule-copy
Sheet: Lookup Tables

Terminals | Terminal PM | TS/PS | Tank Type | Service Status | Inspection Status | Contractor | Project Managers | Project Schedule | TS/PS | Today | This Year | This Month | This Quarter | Quarters
Aldermaston - Gully |  | PS | AST | In-Service | N/A | N/A | [NAME] | On [NAME] (+/-) 2 Weeks | TS |  |  |  |  | Q1
Aldermaston - Top Site |  | PS | UST | In Service – Approved Postponement | Awaiting Tank Emptying | Mistras Group | [NAME] | 3-4 Weeks Behind Schedule | PS |  |  |  |  | Q2
Amsterdam |  | TS | Square | In Service – Overdue Inspection | Awaiting Tank Cleaning | Oceaneering | [NAME] | >4 Weeks Behind Schedule |  |  |  |  |  | Q3
[NAME] |  | PS | Horizontal | Out-of-Service For Inspection | Awaiting Op's Handover to PM | Rosen | [NAME] | N/A |  |  |  |  |  | Q4
Belfast |  | TS | Sphere | Out-of-Service - Under Repair | Awaiting [NAME] | TesTex NDT | [NAME]
Bramhall |  | PS | Bullet | Out-of-Service - Awaiting Contract | Awaiting Inspection | Viking NDT | [NAME]
Clydebank |  | TS |  | L.T.O.O.S | Inspection Ongoing | UltraScan NDT
Eastham |  | TS |  |  | Inspection Complete - Awaiting Report
[NAME] |  | TS |  |  | Report Issued - Awaiting Review & Repair Plan
Grays |  | TS |  |  | Repair Plan Issued - Awaiting Repairs
Hallen |  | PS |  |  | Repairs Ongoing
Immingham - East |  | TS |  |  | Repairs Complete - Awaiting Post Repair Inspection
Immingham - West |  | TS |  |  | Post Repair Inspection Complete - Awaiting Post Repair Report
Inverness |  | PS |  |  | Under Hydro Test
Killingholme |  | PS |  |  | Tank Handed Over to Operations
Mannheim - North |  | TS
Mannheim - South |  | TS
Misterton |  | PS
[NAME] |  | PS
Redcliff Bay |  | PS
Riverside |  | TS
Runcorn |  | TS
[NAME] |  | PS
[NAME] |  | TS
[NAME] |  | TS
Shannon |  | TS
Thetford |  | PS
Tyneside |  | TS
[NAME] |  | PS
Spreadsheet: 55694d1255870228-weight-calculation-book2
Sheet: Sheet1

MDF
[NAME]
0.00085
 | Plus | Plus | Minus | Minus | Minus | Total | Board | Total | Total
LETTER | Area 1 | Area 2 | Area 3 | Area 4 | Area 5 | Area | Thickness | Vol | Weight
A | 10484 |  | 2721 |  |  | 7763 | 18 | 139734 | 118.7739
B
C
D
Spreadsheet: 792745d1661138065-conditional-formatting-exclude-zero-value-from-smallest-value-ask-conditional-formatting
Sheet: Sheet1

 | CURRENT |  | -> | TARGET
 | August | Revenue |  | August | Revenue |  | Conditional Formatting
 | 1 | 400 |  | 1 | 400 |  | -How to set RED background to 100 (as the smallest revenue so far)?
 | 2 | 900 |  | 2 | 900
 | 3 | 100 |  | 3 | 100 |  | Please:
 | 4 | 300 |  | 4 | 300 |  | -Ignore Zero
 | 5 | 0 |  | 5 | 0 |  | -There are Multiple Zero (future daily revenue)
 | 6 | 0 |  | 6 | 0 |  | -Smallest Number in this case is 100 (and could be different based on daily revenue)
 | 7 | 200 |  | 7 | 200 |  | -Use formula/Automatic (Not Manual as i did, LOL)
 | 8 | 0 |  | 8 | 0
 | 9 | 0 |  | 9 | 0
 | 10 | 0 |  | 10 | 0 |  | Thank you so much
 | 11 | 500 |  | 11 | 500
 | 12 | 0 |  | 12 | 0
 | 13 | 0 |  | 13 | 0
 | 14 | 0 |  | 14 | 0
 | 15 | 600 |  | 15 | 600
 | 16 | 0 |  | 16 | 0
 | 17 | 0 |  | 17 | 0
 | 18 | 0 |  | 18 | 0
 | 19 | 0 |  | 19 | 0
 | 20 | 0 |  | 20 | 0
 | 21 | 0 |  | 21 | 0
 | 22 | 0 |  | 22 | 0
 | 23 | 0 |  | 23 | 0
 | 24 | 0 |  | 24 | 0
 | 25 | 0 |  | 25 | 0
 | 26 | 0 |  | 26 | 0
 | 27 | 0 |  | 27 | 0
 | 28 | 0 |  | 28 | 0
 | 29 | 0 |  | 29 | 0
 | 30 | 0 |  | 30 | 0
 | 31 | 0 |  | 31 | 0
Spreadsheet: 726536d1617286433-populate-text-from-other-sheet-based-on-number-or-word-entered-excelforum1345728reminders
Sheet: Example 1

Reminders
 |  | 1
Duty |  | Name | Signature
 |  | [NAME]
 | W/M | Ally
Detail Instructions |  | Dre
Weekly Minder: | 1 | [NAME]
Cleaning |  | [NAME]
 |  | Jordan
Safety |  | [NAME]
 |  | [NAME]
Safety Minder: | 1 | Venus
Observe |  | Serena
 |  | Willie
Don’t rush |  | [NAME]
 |  | Sandy
Customer Service: | 1 | Reed
Interactive |  | [NAME]
 |  | Louis
 |  | [NAME]
 |  | [NAME]
Managers | 1 | [NAME]
Sign in |  | Kenny
 |  | [NAME]
Sign out |  | Blake
 |  | Chirs
Monthly Chat | March | Kris
Attentive |  | [NAME]
 |  | Shay
Punctual |  | Destiny
 |  | [NAME]
 |  | CJ
 |  | [NAME]
 |  | Maria
 |  | Holly
 |  | [NAME]
 |  | [NAME]
Approved By
Week Ending Date
 |  |  |  |  |  | 1
Spreadsheet: 828498d1683556099-search-a-list-with-multiple-values-mm_test_book1-aligw
Sheet: Data

Item | Select Text | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
A | 21 |  | Line 21 BB | Line 21 CC
B | 33 |  | Line 33 B | Line 33 C | Line 33 D | Line 33 E
C | 33 |  | Line 33 B | Line 33 C | Line 33 D | Line 33 E
D | 45
E | 33 |  | Line 33 B | Line 33 C | Line 33 D | Line 33 E
F | 45
G | 33 |  | Line 33 B | Line 33 C | Line 33 D | Line 33 E
H | 45
Spreadsheet: 866105d1713045177-index-and-matching-sample
Sheet: Cat

FactSet Fundamentals | 2023-12-01 00:00:00
 | 31 DEC '23 | 31 DEC '22 | 31 DEC '21 | 31 DEC '20 | 31 DEC '19 | 31 DEC '18 | 31 DEC '17 | 31 DEC '16 | 31 DEC '15 | 31 DEC '14 | 31 DEC '13
Total revenues | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Recurring | 98.305577 | 98.30121 | 98.215767 | 98.148636 | 98.20475 | 98.396536 | 98.239686 | 98.300732 | 97.923032 | 98.196503 | 98.103177
Implementation and other | 1.694423 | 1.698785 | 1.784232 | 1.851363 | 1.795245 | 1.603465 | 1.760317 | 1.699272 | 2.076981 | 1.803497 | 1.896823
Implementation
Hardware
Total operating expenses | -73.352492 | -72.464074 | -75.977139 | -77.880257 | -69.332667 | -69.326513 | -81.843772 | -82.38719 | -84.671923 | -89.59776 | -91.341157
Total cost of revenues | -16.313058 | -15.46962 | -15.337026 | -14.682791 | -14.877499 | -16.026352 | -16.632837 | -16.426396 | -15.790131 | -18.099902 | -19.415248
Operating expenses | -13.207914 | -12.347569 | -12.361159 | -11.6204 | -12.110547 | -13.460384 | -14.418296 | -14.664841 | -14.150714 | -16.361335 | -17.722884
Operating expenses excluding hardware costs and system development and programming costs
Hardware costs
System development and programming costs
Depreciation and amortization | -3.105143 | -3.12205 | -2.975868 | -3.062391 | -2.766951 | -2.565968 | -2.21454 | -1.761555 | -1.639417 | -1.738566 | -1.692363
Total administrative expenses | -57.039433 | -56.994452 | -60.640114 | -63.19747 | -54.45517 | -53.300161 | -65.210939 | -65.960792 | -68.881789 | -71.497858 | -71.925911
Selling, general and administrative expenses | -53.416713 | -53.375832 | -57.247394 | -59.91676 | -51.499921 | -50.629485 | -62.946745 | -63.580657 | -66.327631 | -68.491145 | -68.504011
Sales and marketing | -24.657462 | -25.200441 | -26.147579 | -28.013605 | -24.304329 | -25.405589 | -34.756503 | -36.233106 | -41.198652 | -42.103904 | -39.665989
Research & Development | -11.746712 | -10.786872 | -11.21964 | -10.725024 | -9.906855 | -8.166001 | -7.026951 | -6.369915 | -3.840145 | -2.865586 | -1.994405
General and administrative | -17.012542 | -17.388516 | -19.880172 | -21.178131 | -17.288736 | -17.057896 | -21.163293 | -20.977636 | -21.288834 | -23.521655 | -26.843618
Depreciation and amortization | -3.622716 | -3.618626 | -3.392722 | -3.280709 | -2.955247 | -2.670676 | -2.264188 | -2.380135 | -2.554161 | -3.006712 | -3.421901
Spreadsheet: 844210d1695963420-looking-for-non-array-formula-to-do-number-numbering-sample_year-range_2
Sheet: Data

Select | 8 |  |  | 1
 |  |  | 2 | 2
 |  |  | 3 | 3
 |  |  | 4 | 4
 |  |  | 5 | 5
 |  |  | 6 | 6
 |  |  | 7 | 7
 |  |  | 8 | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 34280d1231439975-drop-down-box-vlookup-not-giving-results-estimate
Sheet: BRANCHES

CL | PH: [PHONE]     FAX: [PHONE] | 88 | 132
WC | PH: [PHONE]     FAX: [PHONE] | 83 | 124.5
MB | PH: [PHONE]     FAX: [PHONE] | 79 | 118.5
RA | PH: [PHONE]     FAX: [PHONE] | 88 | 132
CS | PH: [PHONE]     FAX: [PHONE] | 83 | 124.5
GS | PH: [PHONE]     FAX: [PHONE] | 82 | 123
GV | PH: [PHONE]     FAX: [PHONE] | 85 | 127.5
WJ | PH: [PHONE]     FAX: [PHONE] | 79 | 118.5
SV | PH: [PHONE]     FAX: [PHONE] | 84 | 126
JX | PH: [PHONE]     FAX: [PHONE] | 82 | 123
AT | PH: [PHONE]     FAX: [PHONE] | 95 | 142.5
NV | PH: [PHONE]     FAX: [PHONE] | 78 | 117
Spreadsheet: chris_germany__1924__Tallahasse Swing Cash Flow
Sheet: Actual Gas Flows

Date |  | Volume | Zone | Supplier | Comments
Tue | 2002-01-01 00:00:00 | 0
Wed |  | 0
Thu |  | 0
Fri |  | 0
Sat |  | 0
Sun |  | 925 | Zone 3 | Sequent
Mon |  | 0
Tue |  | 0
Wed |  | 885 | Zone 3 | Sequent
Thu |  | 885 | Zone 3 | Sequent
Fri |  | 2000 | Zone 3 | Sequent
Sat |  | 2000 | Zone 3 | Sequent
Sun |  | 2000 | Zone 3 | Sequent
Mon |  | 2000 | Zone 3 | Sequent
Tue |  | 2000 | Zone 3 | Sequent
Wed |  | 2000 | Zone 3 | Sequent
Thu |  | 2000 | Zone 3 | Sequent
Fri |  | 2000 | Zone 3 | Sequent
Sat |  | 0
Sun |  | 0
Mon |  | 0
Tue |  | 2000 | Zone 3 | Sequent
Wed |  | 0
Thu |  | 0
Fri |  | 0
Sat |  | 0
Sun |  | 0
Mon |  | 0
Tue |  | 0
Wed |  | 0
Thu |  | 0
 |  |  | Total Sales for Jan 2002, Sitara deal #1192959
Fri |  | 2000 | Zone 3 | Sequent | Sequent decided that doing business with ENA was too administrative and would not sell ENA gas after 2/1/02
Sat |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Sun |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Mon |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1021 plus fuel and diverted gas from Entex to Tallahassee
Tue |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1221 plus fuel and diverted gas from Entex to Tallahassee
Wed |  | 2000 | Zone 3 | Tenn Bear Creek Storage | Negotiated Tenn IT discount of $.1221 plus fuel and diverted gas from Entex to Tallahassee
Thu |  | 2000 | Zone 2 | Reliant
Fri |  | 2000 | Zone 3 | Reliant
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Spreadsheet: 218309d1362424827-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits-3
Sheet: DATA

Fruit | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total
Apple | Green | 5 | 0.4 | 2 | 5 | 0.4 | 2 | 5 | 0.4 | 2
 | Yellow | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5
 | Red | 25 | 0.3 | 7.5 | 21 | 0.3 | 6.3 |  | 0.3 | 0
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
[NAME] | Green | 22 | 0.25 | 5.5 |  | 0.25 | 0 |  | 0.25 | 0
 | Yellow | 8 | 0.29 | 2.32 |  | 0.29 | 0 | 21 | 0.29 | 6.09
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
Spreadsheet: 158239d1338106732-excel-vlookup-issue-testsetup
Sheet: Sheet1

 |  |  |  | Size | 4.333
Name | CH | LF | OP | Pan | Net Pan | Yds
WC-q | 8 | 453 | 1
Size | Result | Result2
54" 8' | 4.333 | /11*30
54" 9' | 4.333 | /9*30
54" 10' | 4.333 | /8*30
Spreadsheet: 728396d1618428528-formatting-numbers-after-decimals-a320-takeoff-qrt-beta
Sheet: CFM

 |  | AIRPORT |  | ZSPD |  | MAX CROSSWIND LIMIT INCLUDING GUST |  | 33
 |  | RWY ° |  | 16R
 |  | ELEVN ft |  | 15 |  | TODAY CROSSWIND
 |  | LENGTH m |  | 3700
 |  | SLOPE % |  | 0
 |  | CWY
 |  |  |  |  |  |  | CONF
 |  | WIND °/kt | 90 | 17 |  |  | THRUST
 |  |  | GUST | 0
 |  | OAT °C |  | 12 |  |  | V1 |  | kt
 |  | QNH hPa |  | 1007 |  |  | VR |  | kt
 |  | RWY COND |  | DRY |  |  | V2 |  | kt
 |  | TOW T |  | 65000
 |  | THRUST |  | FLEX |  |  | REV FOR COMPUTATION
 |  | CONF |  | CONF 1+F |  |  | All reversers operative
 |  | AIR COND |  | ON
 |  | A.ICE |  |  |  |  | MTOW |  | T
 |  | TOCG % |  | 33.4
Spreadsheet: b5f5dfcf-13d5-4ae4-94c8-75b87fbd44d2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  |  | Student's Training Plan
Student name: ______________________ |  |  | Graduation Checklist
Program Requirements:
PROOF OF TRAINEE REGISTRATION
IMMUNIZATION RECORDS
PHYSICAL EXAM
PASS BACKROUND CHECKS W/ FINGERPRINTS
PASS DRUG TEST
Academic Requirements:
COMPENTENCY CHECKLISTS
MEET ALL ASHP GOALS AND OBJECTIVES
PASSING GRADES IN ALL CLASSES TAKEN
Graduation Requirements:
RESUME ON FILE W/ REGISTRAR
GRADUATION MEETING
GRADUATION CHECKLIST
[NAME]
Advisory Board Requirements:
PASS CERTIFICATION EXAM
Spreadsheet: 753476d1635457630-sumif-non-continuous-cells-with-wildcard-text-strings-sample-9
Sheet: Data1

Q-1 | Total
Silk 1A | 30
Silk 2 | 90
Silk 3 | 120
Silk 8A | 85
Wool | 45
[NAME] | 30
Cotton 1 | 85
Q1 Total
Q-2 | Total
Silk 8A | 85
Wool 1 | 45
Denim 3 | 30
Cotton 1 | 85
Q2 Total
Spreadsheet: 327998d1403760633-find-the-last-occurrence-of-a-value-in-multiple-columns-or-a-matrix-lastoccurrence
Sheet: Sheet1

Date | Chorister | Organist | Hymn #1 | Hymn #1 Title | Hymn #2 | Hymn #2 Title | Hymn #3 | Hymn #3 Title
2014-10-19 00:00:00 | [NAME] | [NAME] | 140 | [NAME] ipsum | 190 | dolor sit amet | 19 | consectetur
2014-10-26 00:00:00 | [NAME] | [NAME] | 144 | adipiscing elit | 191 | Vivamus dui nisl | 141 | elementum id
2014-11-02 00:00:00 | [NAME] | [NAME] | 229 | sodales sit amet | 192 | [NAME] justo | 107 | [NAME] sollicitudin
2014-11-09 00:00:00 | [NAME] | [NAME] | 94 | [NAME] tempus | 193 | adipiscing | 237 | [NAME]
2014-11-16 00:00:00 | [NAME] | [NAME] | 21 | [NAME] | 194 | [NAME], quis | 231 | congue velit
2014-11-23 00:00:00 | Jake | [NAME] | 93 | arcu et mauris | 195 | Vestibulum | 96 | et egestas
2014-11-30 00:00:00 | Jared | June | 210 | ipsum | 202 | Aliquam | 92 | nisl metus
2014-12-07 00:00:00 | [NAME] | [NAME] | 212 | pellentesque | 197 | ac nulla id, | 211 | posuere
2014-12-14 00:00:00 | Jed | Jessica | 209 | semper nisl | 146 | In purus dui, | 213 | varius sed
2014-12-21 00:00:00 | [NAME] | [NAME] | 205 | posuere ut | 169 | [NAME] magna | 208 | Ut suscipit
2014-12-28 00:00:00 | [NAME] | Julie | 207 | [NAME] | 170 | ut consequat | 202 | Curabitur
Spreadsheet: 753639d1635601375-ranking-by-multiple-criteria-rankexcel
Sheet: Sheet1

Application | PH HRS | R HRS | S HRS | PROCESS | RANK |  | Priority | Process
4 | 12 | 151 | 170 | 937 |  |  | 1 | D1001
5 | 12 | 236 | 236 | 1011 |  |  | 2 | 1133
20 | 12 | 236 | 236 | 1011 |  |  | 3 | 1724
16 | 12 | 245 | 245 | 1724 |  |  | 4 | 1178
6 | 12 | 54 | 236 | 865 |  |  | 5 | 1011
17 | 12 | 137 | 236 | 865 |  |  | 6 | 1119
19 | 12 | 23 | 236 | 865 |  |  | 7 | 1730
22 | 12 | 122 | 236 | 865 |  |  | 8 | 937
3 | 12 | 4 | 170 | 937 |  |  | 9 | 865
12 | 11 | 165 | 230 | 1119
15 | 12 | 8 | 230 | 1119
2 | 12 | 104 | 236 | 1011
7 | 12 | 162 | 236 | 1011
9 | 12 | 118 | 236 | 1011
18 | 12 | 6 | 236 | 1011
21 | 12 | 186 | 236 | 1011
10 | 12 | 17 | 264 | 1178
8 | 11 | 140 | 245 | 1724
13 | 11 | 54 | 264 | 1133
14 | 12 | 29 | 250 | D1001
1 | 14 | 50 | 236 | 1011
11 | 13 | 169 | 250 | 1178
Spreadsheet: 98763d1297624953-vlookup-issue-appts-lookup-sample
Sheet: Main data set

ActRecordid | ActKey | ActDate | ActTime | ActCompletionDate | ActionCode | Result | FirstName | LastName
019P91KITX | [NAME] | 2010-08-17 00:00:00 | 00:00 | 2010-08-17 00:00:00 | INCALL | APPOINT | [NAME] | Kromer
019P91KITX | RQ6VFKA761 | 2010-08-17 00:00:00 | 10:56 | 2010-08-17 00:00:00 | INCALL | APPOINT | [NAME] | Kromer
01OC5EMITX | VYBES7RWR1 | 2010-09-17 00:00:00 | 15:45 | 2010-09-17 00:00:00 | INCALL | APPOINT | DOUGLAS | SESSOMS
01OC5EMITX | [NAME] | 2010-07-16 00:00:00 | 00:00 | 2010-07-16 00:00:00 | INCALL | APPOINT | DOUGLAS | SESSOMS
000HBDVITX | RD4M7Z8TRG | 2010-11-05 00:00:00 | 00:00 | 2010-11-08 00:00:00 | BROCHCALL | APPOINT | fernando | sandoval
001L2X8ITX | OA3BJY0ITX | 2010-08-23 00:00:00 | 00:00 | 2010-08-23 00:00:00 | INCALL | APPOINT | LILIAN | BAEZ
00LU0UQITX | AGB18ZLIM1 | 2010-11-29 00:00:00 | 22:21 | 2010-11-29 00:00:00 | INCALL | APPOINT | BRADLEY | WESTFALL
00LU0UQITX | DQGIJ35TRG | 2010-11-20 00:00:00 | 22:40 | 2010-11-22 00:00:00 | NOSHOWCALL | APPOINT | BRADLEY | WESTFALL
00LU0UQITX | 7MXSZRPTRG | 2010-11-08 00:00:00 | 00:00 | 2010-11-09 00:00:00 | CANCELCALL | APPOINT | BRADLEY | WESTFALL
Spreadsheet: 836764d1689626786-average-of-average-in-one-formula-book1
Sheet: Sheet1

2023-01-31 00:00:00 | 0.01
2023-02-28 00:00:00
2023-03-31 00:00:00 | 0.02
2023-04-30 00:00:00
2023-05-31 00:00:00
2023-06-30 00:00:00 | 0.03
2023-07-31 00:00:00
2023-08-31 00:00:00
2023-09-30 00:00:00 | 0.04
2023-10-31 00:00:00
2023-11-30 00:00:00
2023-12-31 00:00:00 | 0.05
2024-01-31 00:00:00 | 0.06
2024-02-29 00:00:00 | 0.07
2024-03-31 00:00:00 | 0.08
2024-04-30 00:00:00
2024-05-31 00:00:00
2024-06-30 00:00:00 | 0.09
2024-07-31 00:00:00
2024-08-31 00:00:00
2024-09-30 00:00:00
2024-10-31 00:00:00
2024-11-30 00:00:00
2024-12-31 00:00:00
Date Value | Output Value | Average of 3-Month
2023 Average of Col B |  | =AVERAGE(B1:B12)
2023 Average of Col C |  | =AVERAGE(C1:C12)
2024 Average of Col B |  | =AVERAGE(B13:B24)
2024 Average of Col C |  | =AVERAGE(C13:C24)
2024 Average of Col C |  | =AGGREGATE(1,6,C13:C24)
Spreadsheet: 841538d1693728282-update-the-values-in-a-column-based-on-matching-data-in-other-columns-intended-result-updated-aligw
Sheet: Intended Result

TIME | DC
1030 | 4 |  |  |  | 4
1031 | 4 |  |  | 1031 | 4
1032 | 4 |  |  | 1032 | 4
1033 | 7 |  |  | 1033 | 7
1034 | 7 |  |  | 1034 | 7
1035 | 7 |  |  | 1035 | 7
1036 | 8 | 7? |  | 1036 | 7
1037 | 8 |  |  | 1037 | 8
1038 | 8 |  |  | 1038 | 8
1039 | 8 |  |  | 1039 | 8
1040 | 8 |  |  | 1040 | 8
1041 | 8 |  |  | 1041 | 8
1042 | 4 |  |  | 1042 | 4
1043 | 4 |  |  | 1043 | 4
1044 | 4 |  |  | 1044 | 4
1045 | 4 |  |  | 1045 | 4
1046 | 4 |  |  | 1046 | 4
1047 | 6 |  |  | 1047 | 6
1048 | 6 |  |  | 1048 | 6
1049 | 6 |  |  | 1049 | 6
1050 | 6 |  |  | 1050 | 6