tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.08.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-08 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 2 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 17 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 24 | 0 | 5 | 0 | 0 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 7 | 0 | 4 | 0 | 1 | 0 | 2 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 | DEF | 10 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 1 | 1 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-08 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 20 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 1
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 1 | 0
 | MNO | 12 | 6 | 7 | 0 | 3 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 3 | 1 | 0 | 0 | 1 | 2 | 0
 | Total House Census
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -48
3531 | -592346 | -489947
60667 | -312968 | -662509
60749 | 4760 | 53235
61206
61334 | -215218 | 0
62960
INDEX
2001-01-31 00:00:00 |  |  | 159600.24
2001-02-18 00:00:00
Spreadsheet: 49f7714a-0914-4ed1-963c-a194ce94792c
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
School of Business - MAPA & MANM Cohorts
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Lead Instructor | Lead Instructor ID | Percentage | Lead Instructor | Lead Instructor ID | Percentage | Contract Code | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 143553d1330458344-return-value-down-a-column-as-long-as-criteria-is-met-book1
Sheet: Sheet1

 |  |  |  |  | 2011-10-01 00:00:00 | 0.451
 |  |  |  |  | 2012-02-01 00:00:00 | 0.567
 | 2011-10-01 00:00:00 | 0.451 |  |  | 2013-01-13 00:00:00 | 0.515
 | 2011-11-01 00:00:00 | 0.451 |  |  | etc | etc
 | 2011-12-01 00:00:00 | 0.451
 | 2012-01-01 00:00:00 | 0.451
 | 2012-02-01 00:00:00 | 0.567
 | 2012-03-01 00:00:00 | 0.567
 | 2012-04-01 00:00:00 | 0.567
 | 2012-05-01 00:00:00 | 0.567
 | 2012-06-01 00:00:00 | 0.567
 | 2012-07-01 00:00:00 | 0.567
 | 2012-08-01 00:00:00 | 0.567
 | 2012-09-01 00:00:00 | 0.567
 | 2012-10-01 00:00:00 | 0.567
 | 2012-11-01 00:00:00 | 0.567
 | 2012-12-01 00:00:00 | 0.567
 | 2013-01-01 00:00:00 | 0.515
 | 2013-02-01 00:00:00 | 0.515
 | 2013-03-01 00:00:00 | 0.515
 | etc | etc
Spreadsheet: 830015d1684639946-single-let-function-to-get-sub-total-at-each-stage-sub-total
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Item | Product A | Product B | Product A | Product B | Product B | Product A
 |  |  |  |  |  |  |  |  |  |  |  |  | Month | 1 | 1 | 2 | 2 | 3 | 3
Extracted columns from Source Sheet |  |  |  |  |  |  |  |  |  |  |  |  | Quantity | 50 | 213 | 142 | 210 | 55 | 10
Item | Month | SN | Quantity | Total | Price |  | Item | Month | SN | Quantity | Total | Price
Product A | 0 | 1 | 10 | 25 | 2.5
Product A | 1 | 3 | 10 | 25 | 2.5
Product A | 1 | 5 | 15 | 60 | 4
Product A | 1 | 7 | 17 | 70 | 4.12
Product A | 2 | 9 | 20 | 66 | 3.3
Product A | 2 | 11 | 75 | 120 | 1.6
Product A | 3 | 12 | 20 | 195 | 9.75
Product A Total | 10 | 48 | 167 | 561 | 27.77
Product B | 0 | 2 | 45 | 540 | 12
Product B | 1 | 4 | 80 | 120 | 1.5
Product B | 1 | 6 | 95 | 155 | 1.63
Product B | 2 | 10 | 45 | 197 | 4.38
Product B Total | 4 | 22 | 265 | 1012 | 19.51
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Price
Spreadsheet: daren_farmer__5898__hpl0602
Sheet: Sheet1

HPLN0602.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 02, 2000 |  |  |  |  |  | REVISION #3
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
Enron (FM) |  | HPL - Texoma |  | HPL | 20 | 20
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 5 | 0
Enron (ES) |  | Oasis Sealy |  | ENA | 25 | 30 | *
Enron (ES) |  | Reklaw |  | ENA | 30 | 30
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Delhi TOG #3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 219591d1362801008-conditional-sum-excel-2010-drop-down-lists-2013-planting
Sheet: fertilizer calc

 | NITROGEN |  |  | PHOS
GAL | 10-34-0 | 0.32 |  | 10-34-0
1
Spreadsheet: 727939d1618223159-count-the-numbers-and-x-in-all-calums-count-x-etaf-1
Sheet: Sheet1

a | c | 1
x | x
b | x
 |  |  |  | Count of "X"
 |  |  |  | Count of cells excluding X and blank
 |  |  |  | Count of cells including X and blank
 | The first column has 3 entry from top to bottom 3,x,1. Second column 6,x,[NAME] column 9,8,7. That goes on for 17 column from seft to right.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Spreadsheet: 718507d1613155393-adding-and-multiplying-rows-with-values-only-add-and-multiply
Sheet: Sheet2

 |  |  |  |  | 0 |  | 0 | 0
 |  |  |  | 0.2779103264677036 | 75.3207341772152 | 0.9585860902178549 | 16083 | 0.07789594724475818
 |  |  |  | 0.4611233469889466 | 62.49225316455696 | 0.4793252800341976 | 19493.7 | 0.02581218106912471
 |  |  |  | 0.04692356456606166 | 9.650632911392405 | 0.7274213823750709 | 10813.5 | 0.01642689314664951
 |  |  |  | 0.07587261970789425 | 6.233848101265822 | 0.2905978513094229 | 8278.7 | 0.005890878133567111
 |  |  |  | 0.1810751879699248 | 39.63025316455696 | 0.7740859137764099 | 26125 | 0.0437170723138018
 |  |  |  | 0.09349351790815207 | 10.77187341772152 | 0.4075031802887729 | 9639 | 0.01203512736965324
 |  |  |  | 0.03877640074211503 | 6.61407594936709 | 0.6032855805747325 | 10720 | 0.01071548621070003
 |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  | 0 |  | 0 | 0
 |  |  |  | How can I keep the formula in J2 and Still Get the Result of J1 without having "#[NAME]!"?
 |  |  |  | Values in rows 3 to 14 are not always populated and it forces me to revrite the formula to calculate only the populated rows
Spreadsheet: 32502d1228721951-autosum-or-update-of-another-worksheet-abc-co-1
Sheet: Nov'08

ABC Co., Ltd
Company Performance Summary Report (Nov'08)
2. Customer Sales
Customer | 1st Week | 2nd Week | 3rd Week | 4th Week | 5th Week | 6th Week | Total Month
Solectron | 0 | 128791.78 | 0 | 0 | 0 | 0 | 128791.78
Dage | 0 | 1486 | 0 | 0 | 0 | 0 | 1486
K&S | 0 | 2280 | 0 | 0 | 0 | 0 | 2280
Flextronic | 0 | 387.8 | 0 | 0 | 0 | 0 | 387.8
[NAME] | 0 | 0 | 6261.440000000001 | 0 | 0 | 0 | 6261.440000000001
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 0 | 132945.58 | 6261.440000000001 | 0 | 0 | 0 | 139207.02
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Old Due Amounts

 |  | Doctor | Month | Department | Amount
 |  | Dr. [NAME] | 2016-03-01 00:00:00 | Plastic Surgery | 1489
 |  | Dr. [NAME] | 2016-03-01 00:00:00 | Plastic Surgery | 6762
 |  | Dr. [NAME] | 2016-01-01 00:00:00 | Plastic Surgery | 39247
 |  | Dr. [NAME] | 2016-02-01 00:00:00 | Plastic Surgery | 1619
 |  | Dr. [NAME] | 2016-03-01 00:00:00 | Plastic Surgery | 77190
 |  | Dr. [NAME] | 2015-12-01 00:00:00 | Dental | 2491
 |  | Dr. [NAME] | 2016-01-01 00:00:00 | Dental | 4338
 |  | Dr. [NAME] | 2016-02-01 00:00:00 | Dental | 4391
 |  | Dr. [NAME] | 2016-03-01 00:00:00 | Dental | 2244
 |  | [NAME] | 2016-01-01 00:00:00 | Laser | 2217
 |  | [NAME] | 2016-02-01 00:00:00 | Laser | 2172
 |  | [NAME] | 2016-03-01 00:00:00 | Laser | 4562
 |  | Dr. [NAME] | 2016-03-01 00:00:00 | Dental | 760
 |  | Dr. [NAME] | 2016-04-01 00:00:00 | Dental | 950
 |  | Total
Spreadsheet: 165bb19a-1e8d-4690-b62c-6056e759140b
Sheet: Sheet1

EastGroup Properties, Inc. | 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
Form for Providing 2000 Year-End Tax Reporting Information
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Income |  |  |  |  |  |  |  |  |  |  |  |  |  | Unrecaptured
 | Allocations |  |  |  |  |  |  |  | Cash | Taxable |  |  |  |  | Section 1250 |  | Exempt- | Alternative | Foreign
 | F=Final | Security |  | Ticker | Issuer | Declaration | Record | Payable | Distribution | Ordinary | Short-term | Return of | 28 Percent | 20 Percent | Gain | Section 1202 | Interest | Minimum | Tax
Status | E=Estimated | Description | CUSIP | Symbol | Class. | Date | Date | Date | Per Share | Dividend | Capital  Gain | Capital | Rate  Gain | Rate Gain | (25 Percent) | Gain | Dividend | Tax Amount | Gross Up
 |  | Common | 277276101 | EGP | 1 | 2000-03-09 00:00:00 | 2000-03-22 00:00:00 | 2000-03-31 00:00:00 | 0.38 | 0.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Common | 277276101 | EGP | 1 | 2000-06-01 00:00:00 | 2000-06-21 00:00:00 | 2000-06-30 00:00:00 | 0.38 | 0.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Common | 277276101 | EGP | 1 | 2000-09-11 00:00:00 | 2000-06-20 00:00:00 | 2000-09-29 00:00:00 | 0.41 | 0.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Common | 277276101 | EGP | 1 | 2000-12-05 00:00:00 | 2000-12-20 00:00:00 | 2000-12-29 00:00:00 | 0.41 | 0.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | F | Totals for 2000 |  |  |  |  |  |  | 1.58 | 1.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0525 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  | Series A Preferred | 277276200 | EGPpA | 1 | 2000-03-09 00:00:00 | 2000-03-31 00:00:00 | 2000-04-15 00:00:00 | 0.5625 | 0.5625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Series A Preferred | 277276200 | EGPpA | 1 | 2000-06-01 00:00:00 | 2000-06-30 00:00:00 | 2000-07-15 00:00:00 | 0.5625 | 0.5625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Series A Preferred | 277276200 | EGPpA | 1 | 2000-09-11 00:00:00 | 2000-09-30 00:00:00 | 2000-10-15 00:00:00 | 0.5625 | 0.5625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Series A Preferred | 277276200 | EGPpA | 1 | 2000-12-05 00:00:00 | 2000-12-30 00:00:00 | 2001-01-15 00:00:00 | 0.5625 | 0.5625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | F | Totals for 2000 |  |  |  |  |  |  | 2.25 | 2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0525 | 0
Notes:
Spreadsheet: 843086d1695050355-use-drop-down-list-value-to-change-row-values-else-where-on-sheet-welchs101-jr_sr_excel_forum_question
Sheet: SR

Info
Name | Hauser Inc
Group | SR
Date | 2023-08-10 00:00:00
Time | 16:00 PM
SR Team | [NAME], [NAME]
SR Attendees | [NAME], [NAME], [NAME]
Comment
Project Timelines
Timelines | Date | Comments
ABCD | 2018-01-01 00:00:00
GRE | 2024-04-15 00:00:00
FPU | 2024-07-15 00:00:00
GHY | 2024-09-15 00:00:00
SR Information:
SR Amount
SR Number
SR Bono
SR Request
ID | Number
ID123456 | 123456
Spreadsheet: 881334d1729387205-removing-the-checkmark-box-from-yahoo-finance-pasting-1-checkmark-problem
Sheet: Nov 2024

Ticker | $ | Last Price | Change | % of List | 90000 | Shrs To Buy | $ Spent |  | # Of [NAME]
SCHD | 28.81 | 14.98 | 0.65
FSTA | 50.78 | 7.25 | 0.21
FDIS | 87.93 | 10.64 | 0.22
ONEQ | 72.88 | 37.42 | 0.32
FHLC | 72.56 | 101.91 | -2.93
FTEC | 179.45 | 68.33 | 0.86
Spreadsheet: 483443d1475668663-returing-a-negative-or-posivtive-value-based-on-certain-critera-example
Sheet: Sheet1

Type | Amount | example | example | example
Debit | 147.9
Debit | 113
Debit | 110
Debit | 55
Credit | 15
Debit | 45
Credit | 85
Debit | 25
Debit | 142
Debit | 51
Debit | 103
Debit | 38
Debit | 129
Debit | 38
Debit | 38
Spreadsheet: 842131d1694186648-if-and-only-works-on-the-same-row-123
Sheet: Shipping rates

 | Shipping zone A |  |  |  |  |  |  | Shipping zone B
 | 1 |  | ireland, usa, norway, finland, canada |  |  |  |  | 1 | Norway, Finland, Denmark, Sweden
 | 2 |  | austria, italy, belgium, UK, germany, netherlands, hong kong, greece, japan, spain, poland, france, russia, switzerland |  |  |  |  | 2 | Austria, Italy, Irland, Belgium, UK, Germany, Netherlands, Spain, Poland, Portugal, France, Switzerland
 | 3 |  | denmark, portugal, sweden |  |  |  |  | 3 | Greece
 | 4 |  | south korea, singapore, thailand |  |  |  |  | 4 | Hong Kong, Japan, China, South Korea, Thailand
 |  |  |  |  |  |  |  | 5 | US
 | Package weight / g |  |  |  |  |  |  |  | Package weight / g
Shipping zone A | 250 | 500 | 750 | 1000 | 1500 | 2000 |  | Shipping zone B | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000 | 10000
1 | 47.3 | 56.5 | 67.9 | 79.4 | 96.1 | 118.5 |  | 1 | 206.6 | 224.4 | 242.2 | 260 | 277.8 | 295.6 | 313.4 | 331.2
2 | 44.1 | 50.4 | 58.2 | 66 | 77.3 | 92.4 |  | 2 | 174.6 | 189.9 | 205.2 | 220.5 | 235.8 | 251.1 | 266.4 | 281.7
3 | 44.8 | 51.7 | 60.4 | 68.9 | 81.5 | 98.2 |  | 3 | 177.4 | 196.6 | 215.8 | 235 | 254.2 | 273.4 | 292.6 | 311.8
4 | 45.1 | 53.8 | 64 | 75.1 | 90.06 | 111.3 |  | 4 | 184.2 | 213.3 | 242.2 | 271.5 | 300.6 | 329.7 | 358.9 | 387.9
 |  |  |  |  |  |  |  | 5 | 187 | 213.5 | 240 | 266.5 | 293 | 319.5 | 346 | 372.5
 |  |  |  |  |  |  |  | 6 | 250.2 | 294.8 | 339.4 | 384 | 428.6 | 473.2 | 517.8 | 562.4
Spreadsheet: 166123d1341476725-how-to-calculate-the-sum-of-values-in-cells-which-contain-formulas-project-dates1
Sheet: Main Input

Job Name | start | finish | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00
Leeds | 2012-05-14 00:00:00 | 2012-05-16 00:00:00
[NAME] | 2012-05-16 00:00:00 | 2012-05-21 00:00:00
Bromley | 2012-05-15 00:00:00 | 2012-05-21 00:00:00
Bristol | 2012-06-04 00:00:00 | 2012-06-22 00:00:00
Hull | 2012-06-11 00:00:00 | 2012-06-27 00:00:00
Ayr | 2012-06-18 00:00:00 | 2012-06-21 00:00:00
Ilford | 2012-05-21 00:00:00 | 2012-06-22 00:00:00
Cardiff | 2012-06-04 00:00:00 | 2012-06-14 00:00:00
Scunthorpe | 2012-05-28 00:00:00 | 2012-06-08 00:00:00
Gloucester | 2012-05-28 00:00:00 | 2012-06-22 00:00:00
Edinburgh | 2012-05-14 00:00:00 | 2012-05-25 00:00:00
totals
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Indus Maint Certs 2

INDUSTRIAL MAINTANANCE TECHNOLOGY
Certificates
Student Name:
ID #
Industrial Maintenance Mechanic Level I | Semester | Grade
___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
OR ___ ELT 265 (3) Applied Fluid Power
___ IMT 110 (3) Industrial Maintanence Electrical Principles
AND ___ IMT 111 (2) Industrial Maintenance Electrical Principles Lab
OR ___ ELT 110 (5) Circuits I
___ IMT 150 (3) Maintaining Industrial Equipment I
___ IMT 151 (2) Maintaining Industrial Equipment I Lab
Industrial Maintenance Mechanic Level II
___ BRX 120 (3) Basic Blueprint Reading
OR ___ BRX 110 (2) Basic Blueprint Reading for Machinist
OR ___ BRX 112 (4) Blueprint Reading for Machinist
OR ___ ELT 102 (2) Blueprint Reading
___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
OR ___ [NAME] (3) Applied Fluid Power
___ IMT 110 (3) Industrial Maintenance Electrical Principles
AND ___ IMT 111 (2) Industrial Maintenance Electrical Principles Lab
OR ___ ELT 110 (5) Circuits I
___ IMT 100 (3) Welding for Maintenance
AND ___ IMT 101 (2) Welding for [NAME]
OR ___ WLD 120 (2) Shielded Metal Arc Welding
AND ___ WLD 121 (3) Shielded Metal Arc Welding Fillet Lab
OR ___ WLD 152 (5) Basic Weldiing II
___ IMT 115 (2) [NAME] I
AND ___ IMT 116 (5) [NAME]
OR ___ CMM 114 (7) Fundamentals of Machine Tools
AND ___ CMM 110 (3) Fundamentals of Machine Tools - A
AND ___ CMM 112 (4) Fundamentals of Machine Tools - B
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 41400d1239874127-excel-2003-pivot-table-show-the-content-of-the-cell-non-calculation-679963_niconatu
Sheet: Sheet2

 | Store
 | Version | Colour | Version | Colour | Version | Colour | Version | Colour
Model | HH |  | OO |  | PP |  | QQ
1 | a | zz
2 |  |  |  |  |  |  | b | xx
3 |  |  | c | yy
4 |  |  |  |  | d | ww
Spreadsheet: 47652d1246790567-array-formula-problem-consumables-stored-in-am-rack
Sheet: Location Search

CONSUMABLES STORAGE LOCATION SEARCH BY INDIVIDUAL ITEM.
 | ENTER CODE | 24959
 | [NAME]
 | TOTAL QTY IN STOCK
 |  | Slot No | QTY
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
Spreadsheet: 155423d1336825909-random-table-of-data-need-to-find-every-cell-that-contains-specific-data-random-tables-3-1-
Sheet: Card

 |  | I would like to know every cell that contains the following initials
 |  | Rows |  |  |  |  |  |  |  | Columns
 |  | 232 | 043 | 125 | 532 | 324 | 354 | 345
 |  | 421 | 453 | 344
 |  | I would like to start on the left and keep listing the locations where these variables until no more are found. Preference would be to order results for each variable in order from smallest to largest but that is not critical.
Spreadsheet: 172945d1344377643-calculation-time-too-high-ex4
Sheet: Sheet1

 | 010383S^^^^0
 | 010426R-CO^^^^200
 | 510426R-CO^^CCN35-89NV-XL^03/26/2012^20
 | 010455R^^^^0
 | 010455R^^^^0
 | 010455R^^^^0
 | 010455R^^^^0
 | 010455R^^^^0
 | 010455R^^^^0
 | 010491R^^^^450
 | 810491R^^CFRZC-65WH-L^06/12/2012^4
 | 810491R^^CFRZC-65WH-M^06/12/2012^21
 | 810491R^^CFRZC-65WH-XL^06/12/2012^10
 | 010502R^^^^0
 | 010502R^^^^0
 | 010520S-CO^^^^0
 | 010520S-CO^^^^157
 | 010520S-CO^^Note^^1
 | 010520S-CO^^Alteration^05/31/2012^10
 | 010520S-CO^^Alteration^05/31/2012^47
Spreadsheet: 842569d1694609266-split-3-col-dynamic-arrays-into-nested-1-column-list-split-to-list-aligw
Sheet: Feuil1

 |  |  |  |  |  |  | LIST (dynamic array) |  |  |  | EXPECTED RESULT
A | id_a1 | id_a1.4 |  |  |  |  |  | id_a1 | id_a1.4 |  | A
A | id_a1 | [NAME] |  |  |  |  | A | id_a1 | [NAME] |  | id_a1 |  | id_a1
A | id_a3 | [NAME] |  |  |  |  | A | id_a3 | [NAME] |  | [NAME] |  | id_a1.4
A | id_a2 | id_a2.3 |  |  |  |  | A | id_a2 | id_a2.3 |  | id_a1.4 |  | [NAME]
B | id_b1 | id_spec1 |  |  |  |  | B | id_b1 | id_spec1 |  | id_a2 |  | id_a2
B | id_b2 | id_b2.1 |  |  |  |  | B | id_b2 | id_b2.1 |  | id_a2.3 |  | id_a2.3
B | id_b2 | id_b2.2 |  |  |  |  | B | id_b2 | id_b2.2 |  | id_a3 |  | id_a3
B | id_b3 | id_b3.1 |  |  |  |  | B | id_b3 | id_b3.1 |  | id_a3.1 |  | id_a3.1
C | id_c1 | id_c1.5 |  |  |  |  | C | id_c1 | id_c1.5 |  | B |  | B
C | id_c1 | id_c1.2 |  |  |  |  | C | id_c1 | id_c1.2 |  | id_b0 |  | id_b0
C | id_c2 | id_c2.10 |  |  |  |  | C | id_c2 | id_c2.10 |  | aze |  | aze
C | id_spec3 | id_c3.1 |  |  |  |  | C | id_spec3 | id_c3.1 |  | id_b1 |  | id_b1
C | id_c4 | id_c4.6 |  |  |  |  | C | id_c4 | id_c4.6 |  | id_spec1 |  | id_spec1
C | id_c5 | id_c5.1 |  |  |  |  | C | id_c5 | id_c5.1 |  | id_b2 |  | id_b2
B | id_b0 | aze |  |  |  |  | B | id_b0 | aze |  | id_b2.1 |  | id_b2.1
 |  |  |  |  |  |  |  |  |  |  | id_b2.2 |  | id_b2.2
 |  |  |  |  |  |  |  |  |  |  | id_b3 |  | id_b3
 |  |  |  |  |  |  |  |  |  |  | id_b3.1 |  | id_b3.1
 |  |  |  |  |  |  |  |  |  |  | C |  | C
 |  |  |  |  |  |  |  |  |  |  | id_c1 |  | id_c1
 |  |  |  |  |  |  |  |  |  |  | id_c1.2 |  | id_c1.5
 |  |  |  |  |  |  |  |  |  |  | id_c1.5 |  | id_c1.2
 |  |  |  |  |  |  |  |  |  |  | id_c2 |  | id_c2
 |  |  |  |  |  |  |  |  |  |  | id_c2.10 |  | id_c2.10
 |  |  |  |  |  |  |  |  |  |  | id_c4 |  | id_c4
 |  |  |  |  |  |  |  |  |  |  | id_c4.6 |  | id_c4.6
 |  |  |  |  |  |  |  |  |  |  | id_c5 |  | id_c5
 |  |  |  |  |  |  |  |  |  |  | id_c5.1 |  | id_c5.1
 |  |  |  |  |  |  |  |  |  |  | id_spec3 |  | id_spec3
 |  |  |  |  |  |  |  |  |  |  | id_c3.1 |  | id_c3.1
Spreadsheet: 779316d1651692712-rounding-issue-rounded-sum
Sheet: Sheet1

15 | 15 | 15 |  |  | 15 | 15 | 15
22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
Wrong:
 | sum of ROUND values
 | SUMPRODUCT of ROUND values
Corrected?:
 | ROUNDed sum
 | ROUNDed SUMPRODUCT
Spreadsheet: 794992d1662457210-formula-for-sumup-of-data-based-on-wildcard-criteria-masterfile-ihhn-flood-relief-2022-data
Sheet: Province Wise Consolidation

S.No | Description | Sindh | Punjab | Baluchistan | KPK
1 | District | Karachi, [NAME], Thatta, Sanghar, Sujawal | Rajanpur | Lasbella, Khuzdar | DIK, Tank, Nowshera
2 | UC Name
3 | Affected Population in the Camp Area
4 | Total Number of Camps
5 | Total Number of Patients Treated
 | [NAME]
 | [NAME]
 | Less than 5 Male
 | Less than 5 Female
6 | Nature of Intervention
7 | Diseases Treated
 | Diarrhea
 | Acute Respiratory Infection (ARI)
 | Gastroenteritis
 | Skin Infections
 | Malaria
 | UTI
 | Others
8 | Specific Outbreaks
9 | Number of CEC Sessions
10 | Number of Critical Kits Distributed
 | Household Items/Hygiene Kits
 | Food
 | Clothing
 | Shelter
11 | Planned Upcoming Activities
12 | Laboratory Tests
 | CBC
 | Lab Test
 | Chemistry Test
 | Glucose by [NAME]
 | Malaria test
Spreadsheet: 872662d1719022950-getting-data-from-one-workbook-to-another-ghm-team
Sheet: Girls

 | Name | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2012
12 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2013
11 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2014
10 Years
2015 |  | 100 | 200 | Long
9 Years
Spreadsheet: 266866d1379789528-scrollbar-date-setting-depreciation-schedule_new_2
Sheet: Schedule

 |  |  |  |  |  | 0
 | Asset | Price | Year | Salvage | Life
 | Asset Name | 9000 | 2010-03-01 00:00:00 | 500 | 3
 | Asset Name | 9000 | 2012-05-13 00:00:00 | 500 | 7
 | Asset Name | 9000 | 2012-07-09 00:00:00 | 500 | 5
 | Asset Name | 9000 | 2011-08-11 00:00:00 | 500 | 5