tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709472d1608320231-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-222222
Sheet: A Aisle

 | Product code | Qty |  |  | Product code | Qty |  |  |  |  |  | A Aisle
A1A | apples | 3 |  | A5A |  |  |  |  |  |  |  | B Aisle
A1B | pears | 76 |  | A5B |  |  |  | want to count all of the different products |  |  |  | C Aisle
A1C | oranges | 44 |  | A5C |  |  |  | on this sheet: |  |  |  | D Aisle
A1D | grapes | 20 |  | A5D |  |  |  |  | This sheet | All sheets |  | E Aisle
A1E | plums | 50 |  | A5E |  |  |  | apples |  |  |  | F Rear Aisle
 |  |  |  |  |  |  |  | pears |  |  |  | F Front Aisle
A2A |  |  |  | A6A |  |  |  | oranges |  |  |  | G Aisle
A2B |  |  |  | A6B |  |  |  | grapes |  |  |  | Z Aisle
A2C |  |  |  | A6C |  |  |  | plums
A2D |  |  |  | A6D
A2E |  |  |  | A6E |  |  |  | Then I want to count all ths same products on the other sheets
 |  |  |  |  |  |  |  | to give me a grand total of my products.
A3A |  |  |  | A7A
A3B |  |  |  | A7B | apples | 2 |  | I have used fruit as an example
A3C |  |  |  | A7C | apples | 19
A3D |  |  |  | A7D | oranges | 5
[NAME] |  |  |  | A7E
A4A |  |  |  | A8A
A4B |  |  |  | A8B
A4C |  |  |  | A8C
A4D |  |  |  | A8D
A4E |  |  |  | A8E
 | Product code | Qty |  |  | Product code | Qty
A9A |  |  |  | A13A
A9B |  |  |  | A13B
A9C |  |  |  | A13C
A9D |  |  |  | A13D
A9E |  |  |  | A13E
A10A |  |  |  | A14A
A10B |  |  |  | A14B
[NAME] |  |  |  | A14C
A10D |  |  |  | A14D
A10E |  |  |  | A14E
A11A |  |  |  | A15A
A11B |  |  |  | A15B
A11C |  |  |  | A15C
A11D |  |  |  | A15D
A11E |  |  |  | A15E
A12A |  |  |  | A16A
A12B |  |  |  | A16B
A12C |  |  |  | A16C
A12D |  |  |  | A16D
A12E |  |  |  | A16E
 | Product code | Qty |  |  | Product code | Qty
A17A |  |  |  | A21A
A17B |  |  |  | A21B
A17C |  |  |  | A21C
A17D |  |  |  | A21D
A17E |  |  |  | A21E
A18A |  |  |  | A22A | apples | 8
A18B | pears | 44 |  | A22B | apples | 1
A18C | oranges | 6 |  | A22C
A18D | grapes | 11 |  | A22D
A18E |  |  |  | A22E
A19A |  |  |  | A23A | pears | 12
A19B | plums | 66 |  | A23B | oranges | 3
A19C | plums | 2 |  | A23C | grapes | 95
A19D |  |  |  | A23D | plums | 2
A19E |  |  |  | A23E
A20A | apples |  |  | A24A
A20B |  |  |  | A24B
A20C | pears |  |  | A24C | plums | 6
A20D | oranges |  |  | A24D
A20E | grapes |  |  | A24E
 | Product code | Qty |  |  | Product code | Qty
A25A |  |  |  | A29A
A25B |  |  |  | A29B | apples | 8
A25C |  |  |  | A29C | apples | 4
A25D |  |  |  | A29D
A25E |  |  |  | A29E
A26A |  |  |  | A30A
A26B |  |  |  | [NAME]
A26C |  |  |  | A30C
A26D |  |  |  | A30D
A26E |  |  |  | A30E
A27A |  |  |  | A31A
A27B |  |  |  | A31B
A27C |  |  |  | A31C
A27D |  |  |  | A31D
A27E |  |  |  | A31E
A28A |  |  |  | A32A
A28B |  |  |  | A32B
A28C |  |  |  | A32C
A28D |  |  |  | [NAME]
A28E |  |  |  | A32E
 | Product code | Qty
A33A
A33B
[NAME]
A33D
A33E
Spreadsheet: 648081d1572874162-dropdown-list-dependent-on-2-criterias-excel_dropdown-example-
Sheet: Data

Helper | Region | Productcode | Category | Permittance | Comments
 | USA | 123 | Clothes | Yes | Restriction
 | EU | 234 | Food | Yes | Permitted
 | ASIA | 567 | IT | Yes | Not Permitted
 | USA | 123 | IT | No | Permitted
 | EU | 345 | IT | Yes | Restriction
 | ASIA | 456 | Food | Yes | Permitted
 | USA | 123 | Boots | Yes | Restriction
 | ASIA | 566 | IT | No | Not Permitted
 | EU | 789 | Clothes | No | Not Permitted
Spreadsheet: 790108d1659538050-conditional-highlighting-across-different-sheets-and-different-columns-countif_cond-frmt-etaf
Sheet: Sheet2

A1 | 0
A2 | 1
A3 | 1
A4 | 0
A5 | 0
A6 | 0
A7 | 0
A8 | 0
A9 | 0
A10 | 1
A11 | 0
A12 | 0
Spreadsheet: 764869d1643045722-find-duplicates-sample-issue
Sheet: Sheet1

Equations
ABC : PQR : 10 : EFG : DEF
India : USA : 28 : XYZ : EST
India : USA : 7x4 : XYZ : EST
India : USA : 1x28 : XYZ : EST
EEE : AAA : 32 : BZP : PIE |  |  | As is evident, sentences highlighted in the same color are similar in meaning however written differently. How do i identify these as duplicates in excel with there being thousands of rows?
EEE : AAA : 4x8 : BZP : PIE
EEE : AAA : 16x2 : BZP : PIE
EEE : AAA : 8x4 : BZP : PIE
EEE : AAA : 1x32 : BZP : PIE
India : USA : 2x14 : XYZ : EST
EEE : AAA : 32x1 : BZP : PIE
EEE : AAA : 32x1 : BZP : PIE
BBB : ATZ : 100 : ASZ : KIT
BBB : ATZ : 10x10 : ASZ : KIT
ABC : PQR : 1 x 10 : EFG : DEF
BBB : ATZ : 1x100 : ASZ : KIT
BBB : ATZ : 5x20 : ASZ : KIT
BBB : ATZ : 25x4 : ASZ : KIT
Spreadsheet: 230233d1366719625-drop-down-list-using-multiple-worksheets-house-clearance-log-new-formula
Sheet: October 2013

Customer Name | Customer Address | Postcode | Date Enquiry Taken | Heard of us how? | Call Centre Member | Viewing Booked? Y/N | Viewing Date & Time | Viewer | Price Quoted | Clearance Booked? Y/N | Clearance Date | [NAME]? Y/N | Amount Received
Mr. [NAME] | 23 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-15 00:00:00 | Word of Mouth | Anne | yes | 2011-05-20 00:00:00 | Siôn | 300 | Yes | 2013-05-25 00:00:00 | Yes | 300
Mr. [NAME] | 24 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-16 00:00:00 | Leaflet | Leanne | yes | 2011-05-21 00:00:00 | Siôn | 200 | Yes | 2013-05-26 00:00:00 | Yes | 200
Ms. [NAME] | 25 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-17 00:00:00 | Leaflet | Helena | yes | 2011-05-22 00:00:00 | Siôn | 250 | Yes | 2013-05-27 00:00:00 | Yes | 250
Mr. [NAME] | 26 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-18 00:00:00 | Website | Leanne | yes | 2011-05-23 00:00:00 | Siôn | 200 | Yes | 2013-05-28 00:00:00 | Yes | 200 |  | Total Prices Quoted
Mrs. [NAME] | 27 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-19 00:00:00 | Store Visit | Anne | yes | 2011-05-24 00:00:00 | Siôn | 300 | Yes | 2013-05-29 00:00:00 | Yes | 300 |  | Total Amounts Received
Mr. [NAME] | 28 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-20 00:00:00 | Word of Mouth | [NAME] | yes | 2011-05-25 00:00:00 | Siôn | 250 | Yes | 2013-05-30 00:00:00 | No | 0
Spreadsheet: a31daac4-c067-41e2-9e8c-5280b3b3f90b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: July 29, 2014 (4:55 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 767266d1644386658-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation6
Sheet: Daily

Daily
Click Consulting
Purpose | To allocate the amount of each item based on a daily amount and the number of dates in each column.
Allocation
 | Amount | Alloc Start | Alloc End |  | Days | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 | 600 | 2014-01-01 00:00:00 | 2014-06-30 00:00:00
 | 900 | 2014-01-01 00:00:00 | 2014-12-31 00:00:00
 | -750 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 | 800 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00
 | 650 | 2016-01-01 00:00:00 | 2016-03-31 00:00:00
 | 850 | 2012-01-01 00:00:00 | 2012-03-31 00:00:00
Spreadsheet: 122440d1316799110-pivot-table-value-dummy1
Sheet: Pivot

 | Manager | (All)
 | Count of 1 - Month (Behavior Segment) | Column Labels
 | Row Labels | 1 - Super stars | 2 - Performing | 3 - Showing Potential | 4 - Improvement Needed | 5 - Missing All Metrics | (blank) | Grand Total
 | Adams, Louis |  | 1 | 2 | 6 | 5 |  | 14
 | Alexis, Demarcus |  | 1 | 4 | 3 | 2 |  | 10
 | Alvarado, Bernardo |  |  |  | 3 |  |  | 3
 | Artale, [NAME] |  |  | 5 | 5 | 2 |  | 12
 | Barras, Eula |  | 1 | 2 | 1 |  |  | 4
 | [NAME], [NAME] |  |  |  | 4 | 25 |  | 29
 | Blake, Tameika |  |  | 4 |  | 2 |  | 6
 | Bradleyjr, Reginald |  |  | 1 | 3 | 4 |  | 8
 | Brown, [NAME] |  | 1 | 3 | 3 | 3 |  | 10
 | Bryant, [NAME] | 1 |  | 2 | 2 | 1 |  | 6
 | [NAME], Teresa |  |  |  | 2 | 1 |  | 3
 | Crear, Persephone |  | 2 | 1 |  |  |  | 3
 | [NAME], [NAME] |  |  | 1 | 1 | 1 |  | 3
 | [NAME], Sean |  |  |  |  | 19 |  | 19
 | Dennis, [NAME] |  |  |  | 5 | 20 |  | 25
 | Dominguez, Maria |  | 1 |  | 1 | 1 |  | 3
 | [NAME], [NAME] |  |  | 1 |  | 22 |  | 23
 | Gachoka, Regina |  |  | 1 | 1 |  |  | 2
 | [NAME], Christina |  | 1 | 3 | 8 | 3 |  | 15
 | Herron, [NAME] |  |  | 1 | 2 | 1 |  | 4
 | Hopkins, [NAME] |  |  | 1 | 1 |  |  | 2
 | [NAME], [NAME] |  |  | 3 | 9 | 4 |  | 16
 | Jones, [NAME] |  |  | 1 | 3 | 3 |  | 7
 | Lavergne, [NAME] |  |  | 1 | 1 |  |  | 2
 | Lopez, [NAME] |  | 1 |  | 4 | 8 |  | 13
 | Louis, [NAME] |  | 1 | 1 |  |  |  | 2
 | Mims, Nakia |  |  | 2 | 2 | 2 |  | 6
 | Moore, [NAME] |  |  | 4 | 3 | 25 |  | 32
 | Mudunuri, [NAME] |  |  |  | 1 |  |  | 1
 | Murray, Sincereye |  |  | 1 | 2 | 6 |  | 9
 | [NAME], [NAME] |  |  | 1 |  | 1 |  | 2
 | Olaiueji-Ojo, Oluwaseun |  |  | 1 | 5 | 2 |  | 8
 | Pam, [NAME] |  |  | 10 | 12 | 3 |  | 25
 | Parish, [NAME] |  |  | 2 | 8 | 2 |  | 12
 | [NAME], [NAME] |  | 1 | 1 |  | 7 |  | 9
 | Pettaway, Lawalden |  |  | 1 | 1 |  |  | 2
 | Piper, Leah |  |  |  |  | 2 |  | 2
 | Rahming, Alvena |  | 1 | 1 |  |  |  | 2
 | [NAME], [NAME] |  |  |  |  | 1 |  | 1
 | [NAME], [NAME] |  | 1 | 1 |  |  |  | 2
 | Scott, Edna |  |  | 1 |  | 1 |  | 2
 | Sellers, [NAME] | 2 | 1 | 3 | 4 |  |  | 10
 | Session, Byron |  |  |  | 2 |  |  | 2
 | Shambo, Marina |  |  | 2 |  | 1 |  | 3
 | Smail, [NAME] |  |  |  |  | 1 |  | 1
 | Smith, Deshundra |  | 1 | 6 | 9 | 1 |  | 17
 | Smith, [NAME] |  |  | 1 |  | 23 |  | 24
 | Thompson, [NAME] |  |  | 4 | 2 | 8 |  | 14
 | Tyus, Ivory |  |  | 2 | 8 | 2 |  | 12
 | Vannoy, Jermaine |  |  | 1 | 3 | 4 |  | 8
 | Veals, Hosea |  | 1 | 5 |  | 4 |  | 10
 | Warner, Carlisietta |  | 3 | 2 | 3 | 19 |  | 27
 | [NAME], [NAME] |  |  |  | 2 |  |  | 2
 | Webb, [NAME] |  |  | 1 |  |  |  | 1
 | [NAME], Chad |  |  | 1 | 1 | 7 |  | 9
 | (blank)
 | Grand Total | 3 | 19 | 92 | 136 | 249 |  | 499
Spreadsheet: 689252d1596218020-issue-while-consolidating-multiple-excel-sheet-daily-work-control-and-time-sheet-jjacob84-
Sheet: Sheet1

 |  |  | DESIGNATION | Working Time | Time allocation
 | MATHEW
 | KESHVAN
 | SIVADAS RAMANKUTTY
 | SHAMIM  ANSARI
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 | RAGESH
 | MUKUNDAKSHAN
 | SATIYAR AJAM ABBASI
 | UPENDRA KUMAR RAM
 | MARTIN
 | SAMUEL
 | FELIX LUCAZINHO
 | DIPAK GOVINDA SALUNKE
 | SATHYAPALAN
 | RAJEEV
 | [NAME]
 | FLORENCIO
 | [NAME]
 | SAMBHU
 | RAJASEKAR
 | FRANCIS JOSEPH
 | SONU  CHAUHAN  HARDEV
 | SIMHACHALAM
 |  | Daily Work Control And Time Sheet (Jjacob84)
 | [NAME] MALIK
 | SIVA
 | SURENDRA NISHAD
 | RAVI
 | HEMRAJ
 | AJMER SINGH GURBAX SINGH
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 |  | Daily Work Control And Time Sheet (Jjacob84)
 | ABDUR RASHID
 | BALJIT SINGH
Spreadsheet: 783947d1655307373-match-the-next-item-if-match-if-question
Sheet: Var check

Customer | [NAME] |  | Customer | [NAME]
A | -1055
 | 0
 | 0
 | 0
 | -1055
 | 2110
 | 0
 | 0
 | 0
 | 500
 | 0
 | 0
 | 2055
 | 0
 | 0 |  | TOTAL
 | -500
 | 0
Spreadsheet: 55651d1255763216-calculation-on-last-inputs-into-a-list-example-1-
Sheet: Sheet1

945 | 4819.75 |  | Last current: | 1000 |  |  |  | Current
Quantity (in Lbs) | Cost | Cost /Lb |  |  |  |  |  | Inventory (in Lbs)
100 | 505 | 5.05 |  | 145 | 145 | 728.625 |  | 400 | #N/A | #N/A
120 | 606 | 5.05 |  | 200 | 200 | 1000 |  | 500 | #N/A | #N/A
90 | 472.5 | 5.25 |  | 80 | 80 | 428 |  | 400 | #N/A | #N/A
75 | 401.25 | 5.35 |  | 135 | 135 | 678.375 |  | 300 | #N/A | #N/A
135 | 678.375 | 5.025 |  | 75 | 75 | 401.25 |  | 200 | #N/A | #N/A
80 | 428 | 5.35 |  | 90 | 90 | 472.5 |  | 800 | #N/A | #N/A
200 | 1000 | 5 |  | 120 | 120 | 606 |  | 944 | #N/A | #N/A
145 | 728.625 | 5.025 |  | 100 | 100 | 505 |  | 1000 | #N/A | #N/A
 |  |  |  | 0 | 0 | 0 |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
Spreadsheet: 687536d1595265622-timesheet-formula-to-subtract-1-2-a-hour-lunch-only-if-6-hours-are-worked-time-sheet-formula-test
Sheet: Schedule

 | JON | JOE | [NAME]
2020-07-23 00:00:00 | 05:00:00 | 13:00:00 | 05:00:00
 | 13:30:00 | 16:00:00 | 13:30:00
2020-07-24 00:00:00 | 06:00:00 | 13:00:00 | 05:00:00
 | 14:30:00 | 16:00:00 | 13:30:00
2020-07-25 00:00:00 | 08:00:00 | 00:00:00 | 08:00:00
 | 13:30:00 | 00:00:00 | 13:30:00
2020-07-26 00:00:00 | 00:00:00 | 00:00:00 | 08:00:00
 | 00:00:00 | 00:00:00 | 12:00:00
2020-07-27 00:00:00 | 00:00:00 | 13:00:00 | 08:00:00
 | 00:00:00 | 18:30:00 | 12:00:00
2020-07-28 00:00:00 | 15:30:00 | 13:00:00 | 00:00:00
 | 18:30:00 | 20:30:00 | 00:00:00
2020-07-29 00:00:00 | 05:00:00 | 13:00:00 | 00:00:00
 | 13:30:00 | 20:30:00 | 00:00:00
Spreadsheet: 739786d1625930904-predicting-concentration-values-y-from-rlu-values-y-by-regression-analysis-rlu_calc
Sheet: Sheet1

 | Relative Light Unit (RLU) = value of x | Concentration | Master [NAME]
 |  |  | RLU | Concn
1 | 324317 |  | 644910 | 0
2 |  |  | 520101 | 34.3
3 |  |  | 361151 | 95.8
4 |  |  | 140776 | 294
5 |  |  | 56984 | 550
6 |  |  | 16919 | 1396
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
Spreadsheet: 00ddc716-174a-46f8-a394-7650a9651964
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I–WEST O‘AHU
FALL 1998 TO FALL 2008
FALL SEMESTER |  |  | TOTAL |  |  |  | Classified  Undergraduates |  |  |  |  |  |  |  |  |  | Unclassified |  |  |  |  |  | HOME-BASED |  | No
 |  |  | No. |  | % Chng |  | Subtotal |  | Fresh |  | Soph |  | Junior |  | Senior |  | Subtotal |  | Undergrad |  | Grad |  | AT OTHER UH  4/ |  | Data
 | 1998 .............................................. |  | 685 |  | 5.7 |  | 626 |  |  |  |  |  | 381 |  | 245 |  | 59 |  | 54 |  | 5
 | 1999 .............................................. |  | 687 |  | 0.3 |  | 613 |  |  |  |  |  | 376 |  | 237 |  | 74 |  | 72 |  | 2
 | 2000 .............................................. |  | 665 |  | -3.2 |  | 621 |  |  |  |  |  | 328 |  | 293 |  | 44 |  | 43 |  | 1
 | 2001 ............................................. |  | 740 |  | 11.3 |  | 625 |  |  |  |  |  | 379 |  | 246 |  | 106 |  | 103 |  | 3 |  |  |  | 9
 | 2002 ............................................. |  | 834 |  | 12.7 |  | 724 |  |  |  |  |  | 446 |  | 278 |  | 109 |  | 96 |  | 13 |  |  |  | 1
 | 2003  1/ ............................................. |  | 810 |  | -2.9 |  | 636 |  |  |  |  |  | 274 |  | 362 |  | 43 |  | 43 |  | 0 |  | 42 |  | 89
 | 2004 ............................................. |  | 834 |  | 3 |  | 700 |  |  |  |  |  | 339 |  | 361 |  | 34 |  | 34 |  | 0 |  | 37 |  | 63
 | 2005............................................. |  | 858 |  | 2.9 |  | 800 |  |  |  |  |  | 384 |  | 416 |  | 29 |  | 29 |  | 0 |  | 29
 | 2006  2/ ............................................. |  | 866 |  | 0.9 |  | 795 |  |  |  | 5 |  | 280 |  | 510 |  | 40 |  | 40 |  | 0 |  | 31
 | 2007  3/ ............................................. |  | 940 |  | 8.5 |  | 876 |  | 39 |  | 23 |  | 317 |  | 497 |  | 31 |  | 31 |  | 0 |  | 33
 | 2008............................................. |  | 1140 |  | 21.27659574468085 |  | 1094 |  | 229 |  | 47 |  | 266 |  | 552 |  | 20 |  | 20 |  |  |  | 26
 | 1/  Migration to a new student registration system took place in Fall 2003.  Unclassified graduate level no longer available.
 | 2/  Prior to Fall 2006, headcount for juniors includes records which were coded in IRO Base as freshmen and sophomore ed level.
 | Coding of lower division may have resulted from late input of transfer credits.
 | 3/  First freshmen class admitted in Fall 2007.
 | 4/  Students whose primary campus, as identified in Banner / ODS, is not UH West O‘ahu.
 | Data for Fall 2003 and 2004 are from SIMS Base files, with information on primary campus added from Banner / Datamart.
Spreadsheet: 759505d1639579895-index-match-and-return-cell-link-excel-forum-help
Sheet: Process Safety

 | Plant: |  |  |  |  |  |  |  |  |  |  |  | Date:                                                            .
1 | 1.         001.04—Stepped Approach to SH&E
 | BP | Item | Audit Questions (Review Standard for Additional Information) | Additional Considerations | Finding | ELE | Comments | Who to Ask (suggested)
 | END OF SECTION
2 | 2.         Where is Your Next Recordable (WYNR) Initiative
 | BP | Item | Audit Questions (Review Standard for Additional Information) | Additional Considerations | Finding | ELE | Comments | Who to Ask (suggested)
 | END OF SECTION
3 | 3.         001.10—Record Keeping
 | BP | Item | Audit Questions (Review Standard for Additional Information) | Additional Considerations | Finding | ELE | Comments | Who to Ask (suggested)
 | END OF SECTION
Spreadsheet: 695614d1600307622-need-help-to-loop-a-statement-to-shorten-code-test-2-
Sheet: Table2

Number | 0
101010405120W300 | 429
101021105020W300 | 414
Spreadsheet: 758568d1638953231-count-same-set-of-numbers-from-each-row-test-01
Sheet: Sheet1

a | b | c | d | e | f | g | count same set numbers | Comment
4 | 4 | 3 | 7 | 3 | 7 | 7 | 22 | 44 is 1st same set of numbers & 77 is 2nd same set of numbers, therefore the result will be 2 & 2 (22)
1 | 1 | 1 | 6 | 1 | 2 | 2 | 32 | 111 is 1st same set of numbers & 22 is 2nd same set of numbers, therefore the result will be 3 & 2 (32)
4 | 4 | 4 | 4 | 4 | 3 | 5 | 5
8 | 2 | 8 | 2 | 8 | 2 | 3 | 0
1 | 1 | 2 | 2 | 0 | 0 | 1 | 222 | 11 is 1st same set of numbers & 22 is 2nd same set of numbers & 00 3rd same set of numbersis,  therefore the result will be 2 & 2 & 2 (222)
3 | 0 | 2 | 4 | 9 | 9 | 9 | 3
0 | 0 | 0 | 0 | 0 | 8 | 8 | 52
3 | 4 | 4 | 2 | 1 | 4 | 4 | 22
8 | 8 | 8 | 8 | 3 | 8 | 8 | 42 | 8888 is 1st same set of numbers & 88 is 2nd same set of numbers, therefore the result will be 4 & 2 (42)
Spreadsheet: 125286d1318953435-if-function-jea-checking-dates
Sheet: Sheet1

1980-01-01 00:00:00
2010-09-27 00:00:00
2010-09-28 00:00:00
2010-09-29 00:00:00
2010-09-30 00:00:00
2011-01-01 00:00:00
2011-09-30 00:00:00
2011-10-01 00:00:00
2011-10-02 00:00:00
2012-01-01 00:00:00
Spreadsheet: 875472d1722026989-index-match-w-multiple-criteria-and-string-book1
Sheet: Sheet1

 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
THIS_IS_100_TEXT | Unrelated Field 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
THIS_IS_200_TEXT | Unrelated Field 2 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
THIS_IS_300_TEXT | Unrelated Field 3 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72
THIS_IS_400_TEXT | Unrelated Field 4 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96
[NAME] | Unrelated Field 5 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120
Spreadsheet: 00083345-0d6a-4d46-8e4e-f85439e47e23
Sheet: Personnel Licensing & Training

النموذج نون |  |  |  |  |  |  | FORM N
[NAME]
نموذج الإبلاغ عن النقل الجوي
ترخيص وتدريب العاملين في الطيران
[NAME]: |  |  |  | الدولة:
المنظمة:
الهاتف: |  |  |  | السنة:
[NAME]:
البريد الالكتروني:
مؤهلات العاملون في الطيران
رمز الايكاو | فئة المؤهلات |  | اصدار المؤهلات (سنوي) | مجموع المؤهلات  النشطة | التجديد/[NAME] السنوي | مجموع التجديدات/التحويلات | سن التقاعد
 | a |  | b | c | d | e | f
 | 1 | رخصة طيار [NAME] (ATPL)
 | 2 | رخصة طيار تجاري (CPL)
 | 3 | رخصة طيار طاقم مختلط (MPL)
 | 4 | رخصة طيار خاص (PPL)
 | 5 | تقييم معلم الطيران
 | 6 | تراخيص محددة
 | 7 | اجازات صيانة الطائرات
 | 8 | [NAME] الحركة الجوية
قدرات العاملون في [NAME] التدريب في المستقبل
رمز الايكاو | [NAME] |  | تنظيمات التدريب  (حاليا) | تنظيمات التدريب  (5 سنوات) | [NAME]  (5 سنوات)
 | g |  | h | i | j
 | 9 | طيارون (PPL/CPL/ATPL)
 | 10 | طيارون (MPL)
 | 11 | اجازات صيانة الطائرات
 | 12 | [NAME] الحركة الجوية
Spreadsheet: 64093d1264964222-10-unknowns-using-10-simultaneous-equations-10-equations-10-unknowns
Sheet: Sheet1

a | b | c | d | e | f | g | h | i | j | k
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | ANSWERS
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A