tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2636fa40-0d83-4baf-8bc5-7d27c61e8a9a
Sheet: Sheet1

CIA Jury Board | Event Juries 2013 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | 2013-03-21 00:00:00
Event/place | Date | Jury | [NAME] | Nat | Position
COUPE d'EUROPE | 1 – 4 Aug 2013 | [NAME] | S5 | GBR | President
Mainfonds, France |  | [NAME] | I4 | GER
ED: [NAME] |  | [NAME] | I3 | AUT
CIA delegate: [NAME]
[EMAIL]
Contact: [EMAIL]
Event/place | Date | Jury | [NAME] | Nat | Position
57th COUPE GORDON BENNETT | 22-31 Aug 2013 | [NAME] | I3 | USA | president
[NAME], France |  | [NAME] WEBER | [NAME] | LUX
ED: Marcus Haggeney |  | [NAME] | [NAME] | SWE
CIA delegate: [NAME]
[EMAIL]
http://www.gordonbennett2013.org/
Event/place | Date | Jury | [NAME] | Nat | Position
18th European HAB Championship | 6-14 Sep 2013 | Moniek vande VELDE | I3 | BEL | president
Wloclavek, Poland |  | Sandor HIDAS | I3 | HUN
ED: Mathijs de Bruijn |  | Tomasz KUCHCINSKI | E3 | POL
[NAME]: [EMAIL]
http://europeans2013.com/
Event/place | Date | Jury | [NAME] | Nat | Position
2013 TOCHIGI Hot Air Balloon Championship & 2013 Japan Honda GP final | 19-24 November | [NAME] | S5 | SWE | president
 |  | [NAME] | I3 | FRA
 | 2013 | [NAME] | E5 | USA
Tochigi, Japan
ED: Les Purfield
Contact: Hiromori Soejima
[EMAIL]
Spreadsheet: 97993d1297099805-help-with-how-to-remove-n-a-that-is-displayed-from-formula-results-fte-calculator2
Sheet: FTE Calculations

FTE by Discipline Activities |  |  | FTE by Discipline |  |  | FTE by Activity
 |  |  | Total
 |  |  | Total
 |  |  | Total
Spreadsheet: 844894d1696518404-write-formula-to-compare-planned-amounts-by-vendor-in-one-sheet-to-approved-amounts-by-ven-workbook-sample-for-formula-excelmuch-
Sheet: Data

Initiative Name | [NAME] | Planned Amount | Project ID | Planned Amount QA Formula
Initiative 1 | Vendor 1 | 24000 | Project ID TEST1
Initiative 1 | Vendor 2 | 5500 | Project ID TEST1
Initiative 2 | Vendor 1 | 3400 | Project ID TEST1
Initiative 2 | Vendor 3 | 7100 | Project ID TEST1
Initaitive 3 | Vendor 4 | 1400 | Project ID TEST2
Initaitive 3 | Vendor 5 | 892000 | Project ID TEST2
Initaitive 3 | Vendor 6 | 16000 | Project ID TEST2
Initaitive 3 | Vendor 7 | 28 | Project ID TEST2
Initaitive 3 | Vendor 2 | 5300 | Project ID TEST2
Initiative 4 | Vendor 8 | 212000 | Project ID TEST3
Initiative 4 | Vendor 9 | 46 | Project ID TEST3
Initiative 4 | Vendor 2 | 394000 | Project ID TEST3
Initiative 4 | Vendor 1 | 16257 | Project ID TEST3
Spreadsheet: 187934d1350636167-stacking-and-layering-in-excel-options-stacking-combinations
Sheet: Stacking options

Stacking option | Stack Weight | Stack height
A | 1.2 | 0.23
B | 2.5 | 0.4
C | 1 | 0.12
D | 5 | 0.08
A B | 3.7 | 0.63
A C | 2.2 | 0.35
B C | 3.5 | 0.52
A B C | 4.7 | 0.75
Spreadsheet: 169223d1342730335-average-values-with-the-corresponding-name-but-exclude-zeros-and-blanks-average-example
Sheet: Sheet3

 | Competitive NF
Overall Average
NWP (Sumas) | 1.333333333333333 |  | This part gives the average of the values for the associated names. I.E. all of the NWP (Sumas) values are averaged, however they include the zeros. I need the formula to skip zeros or blanks.
Northern Border (Ventura) | 3.047666666666667
[NAME] (Malin) | 1.2330307
Northern Border (Chicago) | 1.07892
GLGT (Dawn) | 3.172924873128667
Viking (Chicago) | 1.858666666666666
Alliance | 1.858666666666666
GLGT (SH - Central) | 3.111403746666667
GLGT (SH - West) | 1.272628533333333
TCPL (Dawn) | 3.172924873128667
[NAME] (Iroquois) | 3.0971267
PNGTS | 0
Summer 2012
NWP (Sumas) | 2
Northern Border (Ventura) | 2.788
[NAME] (Malin) | 0
Northern Border (Chicago) | 1.61838
GLGT (Dawn) | 2.8154362882
Viking (Chicago) | 2.788
Alliance | 2.788
GLGT (SH - Central) | 2.88360562
GLGT (SH - West) | 0
TCPL (Dawn) | 2.8154362882
[NAME] (Iroquois) | 2.99438005
PNGTS | 0
Winter 12/13
NWP (Sumas) | 0
Northern Border (Ventura) | 3.567
Northern Border (Chicago) | 0
[NAME] (Malin) | 3.6990921
[NAME] (Iroquois) | 3.30262
GLGT (Dawn) | 3.887902042986001
Viking (Chicago) | 0
GLGT (SH - Central) | 3.567
GLGT (SH - West) | 3.817885599999999
Alliance | 0
TCPL (Dawn) | 3.887902042986001
PNGTS | 0
2012-05-12 00:00:00
NWP (Sumas) | 2
Northern Border (Ventura) | 2.788
[NAME] (Malin) | 0
Northern Border (Chicago) | 1.61838
Viking (Chicago) | 2.788
Alliance | 2.788
GLGT (SH - Central) | 2.88360562
GLGT (SH - West) | 0
GLGT (Dawn) | 2.8154362882
TCPL (Dawn) | 2.8154362882
[NAME] (Iroquois) | 2.99438005
PNGTS | 0
Spreadsheet: 878856d1726156765-index-match-match-2nd-instance-index-match-match-workbook
Sheet: TY SBCs

 | 2022 |  | 2023 |  | 2024 |  |  | Output 2nd instance
 | 1 |  | 1 |  | 1 |  | Cost per unit | 0.65
Category | Fruit |  | Fruit |  | Fruit |  | Cost per bunch | 0.15
Name | Apple |  | [NAME] |  | Apple |  | Cost per pack | 11
 |  |  |  |  |  |  | Pallet Cost | 58
Cost per unit | 0 |  | 0 |  | 0
Cost per bunch | 0 |  | 0 |  | 0
Cost per pack | 0 |  | 0 |  | 0
Pallet Cost | 0 |  | 0 |  | 0
Cost per unit | 0.5 |  | 0.55 |  | 0.65
Cost per bunch | 3 |  | 0.1 |  | 0.15
Cost per pack | 10 |  | 10.5 |  | 11
Pallet Cost | 50 |  | 55 |  | 58
Spreadsheet: 865167d1712225891-indirect-function-with-multiple-criteria-indirect-formula-with-multiple-criteria-aligw
Sheet: Summary (Day)

2024-04-02 00:00:00 | Total
Description | Shear | Details | BeamWeld | Total
Manpower on Board
Manpower Attended
Absent %
Output
Net Man Hrs / MT
Requirement:
Need formula using INDIRECT function to get data from Worksheets w.r.t. Heading name (Row:2). Other criterias are: to get data on the basis on [NAME] (A1), Text in B1 and Description (Row: A:A)
Note: Will be adding sheets and columns and will ensure Sheet Names and Headings are same.
Spreadsheet: 124914d1318716020-indoor-soccer-league-table-tiebreaker-help-headtoheadstandings
Sheet: Standings

 | RANK | TEAM |  | PTS | W | L | T | GB | GF | GA | DIFF | PF/G | PA/G
Spreadsheet: 792975d1661248398-creating-a-results-list-of-multiple-races-results-gk-
Sheet: Sheet1

 |  | Plaats | place | Race 2 | Race 3 | Race 4 |  |  |  | Flag | Race SUM
 |  | 1 | 147 | 85 | 147 | 85 |  |  |  |  | 2
 |  | 2 | 200 | 7 | 114 | 63 |  |  |  | 133 | 8
 |  | 3 | 7 | 63 | 14 | 133 |  |  |  | 6 | 11
 |  | 4 | 220 | 250 | 19 | 222 |  |  |  | 7 | 11
 |  | 5 | 48 | 133 | 222 | 19 |  |  |  | 250 | 11
 |  | 6 | 14 | 222 | 7 | 1015 |  |  |  | 57 | 14
 |  | 7 | 87 | 113 | 250 | 200 |  |  |  | 3 | 15
 |  | 8 | 1015 | 19 | 85 | 220 |  |  |  | 222 | 15
 |  | 9 | 199 | 87 | 48 | 113 |  |  |  | 47 | 16
 |  | 10 | 63 | 220 | 113 | 87 |  |  |  | 599 | 17
 |  | 11 | 85 | 200 | 63 | 6 |  |  |  | 147 | 18
 |  | 12 | 145 | 2 | 2 | 145 |  |  |  | 200 | 20
 |  | 13 | 19 | 48 | 87 | 1013 |  |  |  | 85 | 21
 |  | 14 | 57 | 960 | 1015 | 960 |  |  |  | 220 | 22
 |  | 15 | 3 | 14 | 960 | 2 |  |  |  | 14 | 24
 |  | 16 | 2 | 147 | 1013 | 47 |  |  |  | 63 | 26
 |  | 17 | 960 | 199 | 145 | 599 |  |  |  | 113 | 26
 |  |  |  |  |  |  |  |  |  | 199 | 26
 |  |  |  |  |  |  |  |  |  | 48 | 27
 |  |  |  |  |  |  |  |  |  | 1015 | 28
 |  |  |  |  |  |  |  |  |  | 1013 | 29
 |  |  |  |  |  |  |  |  |  | 19 | 30
 |  |  |  |  |  |  |  |  |  | 87 | 39
 |  |  |  |  |  |  |  |  |  | 145 | 41
 |  |  |  |  |  |  |  |  |  | 2 | 55
 |  |  |  |  |  |  |  |  |  | 960 | 60
Spreadsheet: 271484d1381950837-counting-function-non-blank-lookup-multiple-categories-count-function
Sheet: January

Employee Calendar
 | Day of the month
Employee | 1 | 2 | 3 | 4 | 5
Adam | Away | Away
[NAME] |  |  | Away | Away
Marci |  | Away | Away
[NAME] |  |  |  |  | Away
Shawn |  |  |  | Away | Away
Total out of office | 0 | 1 | 2 | 2 | 1
Employee Workplace
Employee | Field
Adam | Yes
[NAME] | No
Marci | No
[NAME] | Yes
Shawn | No
Spreadsheet: louise_kitchen__23097__EES Risk - Ops - IT
Sheet: ENW IT

ENW IT | Dayao, [NAME] | 1
 | Lapsley, Carol | 1
 | Yeargain, [NAME] | 1
 | Calderon, Eduardo | 1
 | Chand, Navneet | 1
 | Zaccour, [NAME] | 1
 | Marquez, [NAME] | 1
 | Ha, Kenny | 1
 | [NAME], Pablo | 1
 | Weng, [NAME] | 1
 | Kulkarni, Ravi | 1
 | Cung, Huy | 1
 | [NAME], [NAME] | 1
 | Riall, Debbie | 1
 | Sweet, [NAME] | 1
 | Lopez, [NAME] | 1
 | [NAME], [NAME] | 1
 | [NAME], [NAME] | 1
 | Sharma, Larrissa | 1
 | Reed, [NAME] | 1
 | [NAME], Lance | 1
 | Haynes, Trenton | 1
 | Karkare, Siddharth | 1
 | White, [NAME] | 1
 | [NAME], [NAME] | 1
 | Gullion, [NAME] | 1
 | Symms, [NAME] | 1
 | McDonald, [NAME] | 1
 | [NAME], [NAME] | 1
 | [NAME], Salima | 1
 | Sturgis, Jeramy | 1
 | Hart, Vivian | 1
 | Devireddy, Pradeep | 1
 | [NAME], Sung-Hang | 1
 | Light, [NAME] | 1
 | Hall, Donnie | 1
 | Ku, Karl | 1
 | [NAME], Niraj | 1
 | Chew, [NAME] | 1
 | Bailey, [NAME] | 1
 | Narra, Suchitra | 1
 | Fink, [NAME] | 1
 | Nguyen, Christine | 1
 | May, [NAME] | 1
 | Faust, [NAME] | 1
 | Presley, Daniel | 1
 | [NAME], Todd | 1
 | Xie, [NAME] | 1
 | Rutledge, [NAME] | 1
 | Prammagnanam, [NAME] | 1
 | Scott, [NAME] | 1
 | Guo, [NAME] | 1
 | Kapoor, [NAME] | 1
 | Jain, Sushant | 1
 | Lokhande, Ajay | 1
 | Wang, [NAME] | 1
 | Gay, [NAME] | 1
ENW IT | Chee, [NAME] | 1
Critical Contractors | Vaddi, Shastry | 1
 | Peek, Todd | 1
 | Cao, [NAME] | 1
 | Kavi, Nagesh | 1
Spreadsheet: 54310d1254318030-how-to-calculate-a-total-dependant-on-variables-preq-20template-1-2
Sheet: Sheet1

 |  |  | Purchase Requisition
 | All items marked with a * must be completed by requester
 |  |  |  | *Delivery Address |  |  |  | Order No. Issued by [NAME]
 | *Requester's Name
 | Department & Tel. No. |  |  |  |  |  |  | *Division Cost Centre
 | *Suggested Supplier :
 | *Suppliers Address:
 |  |  |  |  |  |  |  | *Requesters Reference No.
 | Suppliers A/C Number
 | Quote / Contract Ref |  |  |  |  |  |  | *Today's date
 | *Delivery Date Required |  |  |  |  |  |  | 2009-09-30 00:00:00
 |  | (Important :Delivery Date must be a date.  [NAME] will be acted on before " ASAP" )
pos | Product Code | *Description of Material / Services | *Unit of | *Quantity | *Unit Price | *Line Value | *Project Code |  | Activity | *Tax
 |  | Everything the supplier will charge you for should be detailed  on this Requisition…eg. Carriage : Service Costs etc | Purchase |  | + | ex VAT |  |  | Code | System
1 |  | Stuff | EA | 1 | 100 | 100 | X |  | X | A
2 |  | More Stuff | EA | 2 | 50 | 100 | X |  | X | B
3 |  | Yet More Stuff | EA | 1 | 25 | 25 | X |  | X | Z
4 |  |  |  |  |  | 0
5 |  |  |  |  |  | 0
6 |  |  |  |  |  | 0
7 |  |  |  |  |  | 0
8 |  |  |  |  |  | 0
9 |  |  |  |  |  | 0
10 |  |  |  |  |  | 0
 |  |  |  |  | Order Value | 191.25
 | Tax System
A | 0.15 | VAT
B | 0.05 | VAT
M | 0 | Medical Use
E | 0.5 | Exempt
Z | 0 | Zero Rated
Spreadsheet: 739819d1625980284-trying-to-interpolate-a-table-help-please
Sheet: Sheet1

 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40
41 |  |  |  |  | 30 | 7 | 0 | 4 | 16 | 33
 |  |  |  | 22 | 4 | 0 | 4 | 15 | 30 | 45
 |  | 37 | 14 | 2 | 0 | 5 | 15 | 28 | 43 | 56
 | 23 | 7 | 0 | 0 | 6 | 16 | 28 | 41 | 54 | 64
 | 2 | 0 | 2 | 8 | 18 | 29 | 41 | 53 | 62 | 68
 | 0 | 4 | 11 | 21 | 31 | 42 | 52 | 61 | 67 | 70
 | 7 | 15 | 24 | 34 | 43 | 53 | 61 | 67 | 70 | 70
 | 19 | 27 | 36 | 45 | 54 | 61 | 66 | 70 | 70 | 68
 | 31 | 40 | 48 | 55 | 62 | 67 | 70 | 70 | 69 | 64
 | X | 50
 | Y | 31
 |  |  | ANSWER | ?
Spreadsheet: 880688d1728529122-schedule-finding-the-right-formula-excel-forum
Sheet: Sheet1

STAFF | SCHEDULE | DUTY WITH |  |  |  |  |  | CODE | DURATION
PERSON 1 | 111,222,444,888,4321,111 |  |  |  |  |  |  | 111 | 01:00:00
 |  |  |  |  |  |  |  | 222 | 02:00:00
PERSON 2 | 333,444,888,1423 |  |  |  |  |  |  | 333 | 01:30:00 |  |  | SUM TOTAL DURATION
 |  |  |  |  |  |  |  | 444 | 01:00:00 |  |  |  |  |  |  | ignore 4 digits
PERSON 3 | 222,555,666,777 |  |  |  |  |  |  | 555 | 03:00:00 |  |  | 222 | 02:00:00 |  |  |  | 222 | 444 | 888 | 111
 |  |  |  |  |  |  |  | 666 | 02:30:00 |  |  | 444 | 01:00:00 |  |  | ignore 4 digits and duplicates
PERSON 4 | 555,777,888,1234 |  |  |  |  |  |  | 777 | 03:30:00 |  |  | 888 | 02:00:00 |  |  |  | 222 | 444 | 888
 |  |  |  |  |  |  |  | 888 | 02:00:00
 |  |  |  |  |  |  |  | 999 | 01:00:00
https://www.excelforum.com/excel-formulas-and-functions/1429190-schedule-finding-the-right-formula-new-post.html
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DUTY TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | solution1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | solution3
Spreadsheet: 109669d1306451244-average-a-cell-in-a-column-if-matching-a-set-of-criteria-template
Sheet: TOTALS

CALL LOG: WEEK OF
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7012 | name
7023 | name
7014 | name
7008 | name
7011 | name
7032 | name
7009 | name
7018 | name
7015 | name
7013 | name
COURT TOTALS
COURT AVERAGE
7010 | name
7022 | name
7019 | name
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 885836d1735702021-generating-a-sequential-enquiry-number-using-a-formula-leasehold-enquiry-tracker-test-copy4
Sheet: Data analysis

 | LEASEHOLD ENQUIRY TRACKER
 | Number of leaseholders |  |  |  | Number of enquiries |  |  |  |  |  |  |  |  | Enquiry types
 | Status | Number of leaseholders |  |  | Date range | Number of enquiries |  |  |  |  |  |  |  | Date range | Number of enquiries
 | Active | 297 |  |  | 2024 | 30 |  |  |  |  |  |  |  | 2024 | 29
 | Grand Total | 297 |  |  | Oct | 4 |  |  |  |  |  |  |  | 2025 | 1
 |  |  |  |  | Nov | 24 |  |  |  |  |  |  |  | Grand Total | 30
 |  |  |  |  | Dec | 2
 |  |  |  |  | 2025 | 1
 |  |  |  |  | Grand Total | 31
Spreadsheet: 382ca1ff-dc1f-4eba-a809-2b29c43c9779
Sheet: Page 2

Did the application rates exceed the limits in Attachment B of your permit?
Were adequate measures taken to prevent effluent ponding in or runoff from the sites?
Was a suitable vegetative cover maintained on all sites as specified in your permit?
Were all setbacks listed in your permit maintained for every application to each permitted site?
Were all freeboards maintained in accordance with the specified freeboard heights in your permit?
If the facility is non-compliant, please explain in the space below the reason(s) the facility was not in compliance.  Provide in your explanation the date(s) of the non-compliance and describe the corrective action(s) taken. Attach additional sheets if necessary.
Operator in Responsible Charge (ORC) Certification |  |  |  |  |  |  |  |  |  |  |  | Permittee Certification
ORC: |  |  |  |  |  |  |  |  |  |  |  | Permittee:
Certification No.: |  |  |  |  |  |  |  |  |  |  |  | Signing Official:
Grade: |  |  |  |  | Phone Number: |  |  |  |  |  |  | Signing Official's Title:
Has the ORC changed since the previous NDAR-3? |  |  |  |  |  |  |  |  |  |  |  | Phone Number: |  |  |  |  | Permit Exp.:
Signature |  |  |  |  |  |  |  |  |  | Date |  | Signature |  |  |  |  |  |  |  | Date
By this signature, I certify that this report is accurrate and complete to the best of my knowledge. |  |  |  |  |  |  |  |  |  |  |  | I certify, under penalty of law, that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that all qualified personnel properly gathered and evaluated the information submitted. Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete. I am aware that there are significant penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations.
Mail Original and Two Copies to:
Division of Water Quality
Information Processing Unit
1617 Mail Service Center
Raleigh, North Carolina 27699-1617
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Tenancy Schedule

Tenancy Schedule
 |  |  |  |  | Lease Dates
Address |  | Tenant | Unit Type | Term | Start | Break | [NAME] | ULT | WAULT | Rent P.A | Area | Rent psf | Rent % | EMV | Yield | Comment
Spreadsheet: 32922751-f6aa-4452-a285-43ab4cf00da8
Sheet: Sheet1

Supplementary table 3: Conserved and unique repeats found in OSGIV, RBIV, and ISKNV | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | OSGIV |  |  |  | RBIV |  |  |  | ISKNV
Sequence | Indices | Period size | Copy number | Match identity | Indices | Period size | Copy number | Match identity | Indices | Period size | Copy number | Match identity
CONSERVED REPEATS
tgcag gggccgctca [NAME] | 56544--56605 | 27 | 2.3 | 97 | 56236--56297 | 27 | 2.3 | 97
accacca ccactgtggc acctacaaca | 21975--22048 | 27 | 2.7 | 95 | 21974--22047 | 27 | 2.7 | 95
cac caccttacca gccgcctgct attcccccca | 106749--106812 | 33 | 1.9 | 96 | 106318--106381 | 33 | 1.9 | 96
c aatttgcatc aagtgacttt atttctacat tgtattg | 93667--93742 | 38 | 2 | 100 | 93160--93235 | 38 | 2 | 100
ggcac cggagatggt ggtcgcgctg gcaccggaac tggtacc | 18727--18806 | 42 | 1.9 | 97 | 18726--18805 | 42 | 1.9 | 97
tag cggcgacccc cgcctgttag gctaagaagg gtcgccacgt [NAME] tgtccc | 52385--52559 | 69 | 2.5 | 97 | 52078--52252 | 69 | 2.5 | 96
UNIQUE REPEATS
aca ggcccgacgc gtaccacagg cccgacgtgt accacaggcc cgacgcgcac cacaggcccg acgtgtacca caggcctg | 24458--24639 | 81 | 2.2 | 100
cacctgta [NAME] aaatgtgcaa cactacagtg gtataacaga ccgacgtgca ggagatatca ccatacgagc ctccaa | 89243--89432 | 94 | 2 | 100
acaggccc gacgcgtacc acaggcccga cgtgtaccac aggcccgacg cgcaccacag gcccgacgtg taccacaggc ctgacaggcc cgacgcgtac cacaggcccg acgcgtacca [NAME] | 24323--24617 | 135 | 2.2 | 98
gaaga gatgtccata tgtc |  |  |  |  | 66776--66812 | 19 | 1.9 | 100
[NAME] ctcctggccg cct |  |  |  |  | 69064--69104 | 20 | 2 | 100
ct ccaacaggcg acagtatgca  tcattcttct gggcgtgcat tggcacaggc ttaacagg |  |  |  |  | 101139--101255 | 60 | 2 | 100
[NAME] actcattgtg tgcaacacac atgggcctgt acggctgctt gttgcaa |  |  |  |  | 14136--14258 | 61 | 2 | 100
[NAME] cacta |  |  |  |  |  |  |  |  | 22099--22194 | 47 | 2 | 100
[NAME] cct |  |  |  |  |  |  |  |  | 23446--23484 | 18 | 2.2 | 95
gacg cgtaccacag gcct |  |  |  |  |  |  |  |  | 23617--23655 | 18 | 2.2 | 95
a gggtcgccac gtcgcagagg aacacgagcc tcccttgttt gtctttggtg gcgaccccgc ctgttgcggc  taag |  |  |  |  |  |  |  |  | 51470--51612 | 75 | 1.9 | 97
gctgcgt agtggatgtc ctggaccatc gtggctacg |  |  |  |  |  |  |  |  | 52284--52356 | 36 | 2 | 97
ga tggcagcggt gcgtcggttc caacggta |  |  |  |  |  |  |  |  | 86499--86556 | 30 | 1.9 | 96
Spreadsheet: 598828d1542730427-formula-containing-index-match-isnumber-and-search-with-a-few-ifs-thrown-in-not-working-data-checking
Sheet: Subjects Status

Surname Forename | Gender | NC Year | Admission No | Spanish - BLP | Technology - WA | Technology - BLP | Spanish - BLP Grade Check | Technology - WA Grade Check | Technology - BLP Grade Check | Spanish - BLP Class | Technology - WA Class | Technology - BLP Class
aaa | F | 8 | 8541
bbb | F | 8 | 8544
[NAME] | F | 8 | 8545
ddd | F | 8 | 8546
eee | F | 8 | 8547 | 5
[NAME] | F | 8 | 8550 | 6
ggg | F | 8 | 8557 | 6
hhh | F | 8 | 8565
jjj | F | 8 | 8855 | 5
Spreadsheet: 864320d1711542886-rolling-stock-levels-for-assembly-component-levels-stock-control-1
Sheet: Sheet2

Sheet1
Order Number | Date | Qty | Customer | Product | Value
2032 | 2024-03-27 00:00:00 | 3 | XYZ Company Ltd | Big Box | 120
2033 | 2024-03-27 00:00:00 | 1 | ABC Company Ltd | Big Box | 40
2034
2035
2036
2037
2038
2039
2040
Sheet2
Big Box Assembly |  |  | Item | Total Quantity
Magnet | 5 |  | Magnet | 15000
Case | 1 |  | Case | 2500
Cloth | 1 |  | Cloth | 1200
Stickers 8mm | 4 |  | Stickers 8mm | 12000
Stickers 10mm | 2 |  | Stickers 10mm | 6000
Stickers 12mm | 2 |  | Stickers 12mm | 6000
Stickers 16mm | 2 |  | Stickers 16mm | 6000
Blister | 1 |  | Blister | 420
Spreadsheet: 116750d1312112952-live-linked-spreadsheets-two
Sheet: two

mater | slave
34
24
543
54
4t34rr
Spreadsheet: 145086d1331297505-how-to-shorten-the-formula-if-sum-countif-book1
Sheet: Sheet1

T/NT? | Description
NT | subscription for iback up
NT | ibackup subscription
NT | monthly iback-up subscription fees
NT | vaccination for india trip
T | malaria tablets
[NAME]
IF(SUM(COUNTIF(B2,{"*VACCIN*","*IBACK*","*BUSINESS*","*ICAEW*","*RECRUIT*"}))>0,"NT","T")
Summary
word | result
vaccin | NT
iback | NT
business | NT
ICAEW | NT
Recruit | NT
Spreadsheet: 141523d1329315100-excel-2007-solved-set-a-text-in-a-cell-base-on-another-text-in-another-cell-excelforum-814823-lookups
Sheet: lookups

Expense Type | Category
Breakfast | Food
Dinner | Food
Dustbin | Home Appliance
Family | Family
Food | Food
Household | Household
Lunch | Food
Newspaper | Miscellaneous
Petrol | Petrol
Toll | Travel
Spreadsheet: 1d31dd43-caff-4359-998c-d0c73a75b3a3
Sheet: Sheet1

PURCHASE ORDER | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
WEST VIRGINIA STATE UNIVERSITY |  |  |  |  |  | Submit invoice to:
 |  |  |  |  |  | West Virginia State University
[NAME] |  |  | GUS R. |  |  | Research and Development Corporation
& DEVELOPMENT |  | AND | DOUGLASS |  |  | 201 ACEOP BUILDING |  |  | PO Box 1000
CORPORATION |  |  | INSTITUTE |  |  | INSTITUTE, WEST VIRGINIA |  |  | 25112 - 1000
 |  |  |  |  |  | PHONE (304) 204-4306 |  | FAX (304) 766-4292
PROGRAM | EPSCOR |  |  |  |  | TAX EXEMPTION # |  | PO NUMBER
 |  |  |  |  |  | 501(C)3 55-0708567
 | Note to Vendor:  Invoices Must Show Purchase Order Number
V |  |  |  |  |  | S |  | WV State University
E |  |  |  |  |  | H |  | Physical Facilities
N |  |  |  |  |  | I |  | Inventory Control
D |  |  |  |  |  | P |  | Institute, WV 25112
O |  |  |  |  |  | T
R |  |  |  |  |  | O
ITEM NO. | DETAILED [NAME] ([NAME]) |  |  |  |  |  | QUANTITY | UNIT PRICE | AMOUNT
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | SubTotal | 0
 |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  | Freight | 0
 |  |  |  |  |  |  |  | TOTAL | 0
Contact Person:
Phone: |  |  |  |  | Approved By:  Supervisor/Program Leader |  |  |  | Date
Building:
Room # |  |  |  |  | Approved by :Research/Outreach Coordinator |  |  |  | Date
Reason for [NAME]: |  |  |  |  | EPSCOR Coordinator: |  |  |  | Date
 |  |  |  |  | Other Signature: |  |  |  | Date
 |  |  |  |  | Budget Office |  |  |  | Date
 |  |  |  |  | Approved by: Director of Business and Finance |  |  |  | Date
Requested By: |  |  |  | Date: | Approved by: Vice President of Research and Public Service |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Oasis

POI  8516
 | Scheduled | Measured | Imbal
1 | 106094 | 103793
2 | 97525 | 95166
3 | 97475 | 95009
4 | 97525 | 96856
5 | 102135 | 101639
6 | 82735 | 82655
7 | 94635 | 94027
8 | 134131 | 136018
9 | 71735 | 72648
10 | 71735 | 86862
11 | 71685 | 71511
12 | 84166 | 84634
13 | 72703 | 73788
14 | 98337 | 98796
15 | 80637 | 80688
16 | 121128 | 120967
17 | 134798 | 134333
18 | 97710 | 97329
19 | 51492 | 52093
20 | 78940 | 80724
21 | 59500 | 59403
22 | 75046 | 75023
23 | 133085 | 133535
24 | 116924 | 118622
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  | 1307
 | 2001-06-24 00:00:00