tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772433d1647272700-combining-a-counta-range-with-a-counta-single-cell-statement-excel-formulas
Sheet: ClosingStockPrices

F:\My Documents\.. Investments\[Excel Formulas.xlsx]ClosingStockPrices |  | 2
[NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Stocks                                                     (Yellow = Own) | Symbol | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-07 00:00:00 | 2022-02-08 00:00:00 | 2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00 | 2022-02-22 00:00:00 | 2022-02-23 00:00:00 | 2022-02-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 |  | Sum Of Daily 'U' Results | Sum Of Daily "D" Results | [NAME] | Time Period
Allegheny Technologies Inc (0) | ATI | 18.809999 | 22.02 | 22.459999 | 22.709999 | 22.940001 | 23.540001 | 23.860001 | 23.57 | 23.99 | 23.89 | 23.93 | 24.2 | 24.7 | 23.97 | 23.88 | 23.68 | 23.77 | 25.46 | 25.74 | 25.46 | 26.49 | 26.16 | 26.05 | 26.48 | 26 | 25.67 | 26.98 | 26.77 |  |  |  |  | 2/1 To Date
Chevron Corporation Common Stock (4) | CVX | 134.789993 | 135.410004 | 134.199997 | 135.880005 | 139.05 | 136.43 | 137.79 | 136.02 | 139.48 | 136.9 | 134.35 | 134.36 | 133.65 | 133.28 | 132.39 | 135.59 | 134.69 | 139.9 | 143.9 | 149.75 | 154.14 | 156.27 | 158.65 | 161.45 | 165.85 | 166.26 | 170.8 | 169.94 |  |  |  |  | 2/1 To Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula in AF6 & AG6 are intended
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to count the number of "U" and "D" entries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | in row # 7
Spreadsheet: 136572d1326727475-named-ranges-and-functions-problem-teo
Sheet: Sheet1

TABLE1: AA COMPANY |  |  |  |  |  | Table: | TABLE45
NAME | AGE | ID | [NAME] | CHILDREN |  | Age+: | 45
a | 45 | a1 | 15000 | 5 |  | Salary: | 15000
b | 48 | b1 | 15000 | 1 |  | Children: | 2
c | 52 | n1 | 15000 | 2
d | 30 | g1 | 10000 | 2 |  |  | Result
f | 25 | r1 | 15000 | 1 |  |  | 2
g | 15 | e1 | 12000 | 0
[NAME]: BB COMPANY
NAME | AGE | ID | [NAME] | CHILDREN
i | 45 | a1 | 15000 | 5
j | 48 | b1 | 15000 | 2
k | 52 | n1 | 15000 | 2
l | 30 | g1 | 10000 | 2
m | 25 | r1 | 15000 | 1
n | 15 | e1 | 12000 | 0
TABLE45: MM COMPANY
NAME | AGE | ID | [NAME] | CHILDREN
o | 45 | a1 | 15000 | 5
p | 48 | b1 | 15000 | 2
q | 52 | n1 | 15000 | 2
r | 30 | g1 | 10000 | 2
s | 25 | r1 | 15000 | 1
t | 15 | e1 | 12000 | 0
TABLE90: ZZ COMPANY
NAME | AGE | ID | [NAME] | CHILDREN
u | 45 | a1 | 15000 | 5
v | 48 | b1 | 15000 | 2
w | 52 | n1 | 15000 | 2
x | 30 | g1 | 10000 | 2
y | 25 | r1 | 15000 | 1
z | 15 | e1 | 12000 | 0
Spreadsheet: 50f6f5c3-71a0-417b-8b97-15bb019013dc
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Grundarstræti 3, 420 Súðavík
Sími 456-4912 / Fax 456-4946
Umsókn um ferðaþjónustu fatlaðra                 Samkvæmt lögum um málefni fatlaðra nr. 59/1992
Upplýsingar um umsækjanda
Nafn umsækjanda: |  |  |  | Kennitala:
Lögheimili: |  |  |  |  | GSM:
Sveitarfélag: |  |  |  |  | Sími:
Aðstæður umsækjanda
Er umsækjandi 75% öryrki?
Hefur umsækandi fengið styrk frá TR til bifreiðakaupa sl. 12 mánuði)
Hefur umsækandi fengið bensínstyrk frá TR sl. 12 mánuði ?
Hefur umsækandi aðgang að eigin bifreið ?
Ferðaþjónusta sem óskað er eftir:
Tímabil sem óskað er eftir þjónustu:
Akstur til og frá:
Fjöldi ferða (á viku [NAME]):
Tímasetning ferða:
Fylgigögn umsóknar
1. Staðfestingu á örorku, ef um örorku er að ræða
Annað sem umsækjandi vill koma á [NAME]
Yfirlýsing
Ég votta með undirskrift minni að allar upplýsingar sem ég hef gefið upp í sambandi við umsókn þessa eru réttar og starfsfólki er heimilt að [NAME] nánari upplýsinga. Einnig skuldbind ég mig til að gera grein fyrir öllum breytingum [NAME] að verða á högum mínum og/eða varðandi þær upplýsingar sem ég hef gefið í sambandi við þessa umsókn.
[NAME] |  |  |  |  | Dags, umsóknar
Spreadsheet: 728227d1618382190-lookup-price-based-on-quantity-breaks-across-rows-excel-example-to-compute-part-costs-based-on-qty-breaks
Sheet: Sheet1

Price Break Quantities & Associated Prices
Part | Qty Break 1 | Qty Break 2 | Qty Break 3 | Qty Break 4 | Qty Break 5 | Price Break 1 | Price Break 2 | Price Break 3 | Price Break 4 | Price Break 5
Part Description 1 | 0 | 101 | 201 | 301 | 401 | 5 | 4.5 | 4 | 3.5 | 3
Part Description 2 | 0 | 100 | 200 | 300 | 400 | 5 | -0.5 | -0.5 | -0.5 | -0.5
Part Description 3
Part [NAME]
Part Description 5
Part Description 6
Part Description 7
Part Description 8
Part Description 9
Part Description 10
 | Anticipated Quantities |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
Part | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Part Description 1 | 10 | 125 | 315 | 406 | 700
Part Description 2
Part Description 3
Part [NAME]
Part Description 5
Part Description 6
Part Description 7
Part Description 8
Part Description 9
Part Description 10
 | End Game = Part Costs by Year Based On Anticipated Quantities
Part | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Part Description 1
Part Description 2
Part Description 3
Part [NAME]
Part Description 5
Part Description 6
Part Description 7
Part Description 8
Part Description 9
Part Description 10
Note:  [NAME] will search for price that is at or below the quantity than the anticipated quantity
in table one & then multiply the anticipated quantity by that price.  If anticipated quantity
is greater than the maximum quantity price break then multiply by the highest quantity price.
Spreadsheet: 803614d1667573417-formula-to-find-next-available-number-day-from-range-example
Sheet: Sheet1

Day of Collection | GRP DD1 | GRP DD2 | GRP DD3 | GRP DD4 | GRP DD5 | Required Result
2 | 1 | 2 | 3 | 4 | 5 | 3
5 | 1 | 2 | 3 | 4 | 5 | 1
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
3 | 1 | 2 | 3 | 4 | 5 | 4
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
2 | 1 | 2 | 3 | 4 | 5 | 3
4 | 1 | 2 | 3 | 4 | 5 | 5
2 | 1 | 2 | 3 | 4 | 5 | 3
1 | 1 | 2 | 3 | 4 | 5 | 2
1 | 1 | 2 | 3 | 4 | 5 | 2
4 |  | 2 | 3 |  | 5 | 5
5 |  | 2 | 3 |  | 5 | 2
4 |  | 2 | 3 |  | 5 | 5
5 | 1 | 2 | 3 |  |  | 1
Spreadsheet: 267889d1380266268-average-values-from-multiple-worksheets-if-a-day-matches-member-transaction-ctbanker
Sheet: 9-3-2013

Branch
MSR | [NAME]
Date | 2013-09-23 00:00:00
 | Members | deposits | withdrawals | payments | split transactions | inquirys
08:00:00
09:00:00 | 1 |  |  |  |  | 1
10:00:00 | 4 |  | 3
11:00:00 | 7 | 2 | 1 |  | 2 | 3
12:00:00 | 3 | 1 | 3 |  |  | 3
13:00:00 | 5 | 3 | 1 |  |  | 1
14:00:00 | 3 | 1 | 2
15:00:00 | 4 |  |  |  |  | 2
16:00:00 | 1
17:00:00
18:00:00
totals
Spreadsheet: 65621d1266336233-date-time-formula-timesample
Sheet: Sheet1

Ref Number | Start Time | 24 hours | 48 hours | 72 hours | End Time | Current | Total Time spent | Accumulated hours
 | [NAME]/dd/yy 00:00 |  |  |  | [NAME]/dd/yy 00:00
1 | 2010-02-01 02:00:00 | 2010-02-02 02:00:00 | 2010-02-03 02:00:00 | 2010-02-04 02:00:00 | 2010-02-02 03:00:00 | 2010-02-16 11:00:02 | 24.99999999994179 | 24.99999999994179
2 | 2010-02-03 08:00:00 | 2010-02-04 08:00:00 | 2010-02-05 08:00:00 | 2010-02-06 08:00:00 | 2010-02-05 08:30:00 | 2010-02-16 11:00:02 | 48.49999999988358 | 73.49999999982538
3 | 2010-02-15 10:48:00 | 2010-02-16 10:48:00 | 2010-02-17 10:48:00 | 2010-02-18 10:48:00 |  | 2010-02-16 11:00:02 | 24.20058333344059 | 97.70058333326597
Spreadsheet: 4d421981-075a-48a0-b6b5-137cd59f57ec
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CORT | Test | CORT | Cortisol, Serum | Cortisol, S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL Collection Instructions: Morning (8 a.m.) and afternoon (4 p.m.) specimens are preferred. Additional Information: 1. Include time of draw. 2. If multiple specimens are drawn, send separate order for each specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | a.m.: 7-25 mcg/dL p.m.: 2-14 mcg/dL | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 82533 |  |  |  |  | Rochester
CORT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CORT | Order Question | COLT4 | Collection Time in Military Time |  | Plain Text
CORT | Result | CORTP | Cortisol, S | Cortisol, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2143-6
CORT | Result | CAM | AM Result | AM Result | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9813-7
CORT | Result | CPM | PM Result | PM Result | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9812-9
Spreadsheet: 148728d1333538223-to-show-yes-in-the-macth-column-pawan
Sheet: Sheet1

 | Set A | Set B | Match
Spreadsheet: 798652d1664618800-find-next-bigger-value-than-input-capture
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | input | 10
 |  |  |  |  | 562.0909090909091 |  |  |  | Output | 14.59
 |  |  |  |  | 562.9215686274509
 |  |  |  |  | 586.7333333333333
 |  |  |  |  | 168.4602076124567
 |  |  |  |  | 31.03960396039604
 |  |  |  |  | 118.04
 |  |  |  |  | 148.7540983606557
 |  |  |  |  | 50.95435684647303
 |  |  |  |  | 45.46078431372549
 |  |  |  |  | 22.73117181516467
 |  |  |  |  | 67.86530612244898
 |  |  |  |  | 37.96379196840027
 |  |  |  |  | 26.75398230088496
 |  |  |  |  | 20.3616937079541
 |  |  |  |  | 14.59882697947214
 |  |  |  |  | 4.242428109579717
 |  |  |  |  | 5.994610778443114
 |  |  |  |  | 4.481346998535871
 |  |  |  |  | 3.668590272052762
 |  |  |  |  | 1.734793921339417
 |  |  |  |  | 1.67544936920844
 |  |  |  |  | 1.037091342667934
Spreadsheet: 198131d1354662130-how-do-i-map-and-hyperlink-100-worksheets-excel-sheet-mapping-1-
Sheet: Sheet1

sheet1 | 1 |  |  | [NAME] | CELL REF
sheet2 | 2 |  |  | [excel sheet mapping (1).xlsx] | !D1
sheet3 | 3
sheet4 | 4
sheet5 | 5
sheet6 | 6
sheet7 | 7
sheet8 | 8
Spreadsheet: 51770d1251380717-summing-numbers-with-multiple-criteria-697346_aaaarrrggh
Sheet: Sheet1

START DATE | FINISH DATE | ETHN. | TOTAL HRS. PER WEEK
2009-02-24 00:00:00 | 2009-07-15 00:00:00 | A2 | 7
2009-05-27 00:00:00 | 2009-08-19 00:00:00 | A9 | 5
2009-02-24 00:00:00 | 2009-06-17 00:00:00 | B2 | 6
2009-06-02 00:00:00 | 2009-06-23 00:00:00 | A1 | 3
2009-02-10 00:00:00 | 2009-09-10 00:00:00 | W9 | 6
2009-06-03 00:00:00 | 2009-07-15 00:00:00 | W9 | 2
2009-04-27 00:00:00 | 2009-07-06 00:00:00 | B2 | 3
2009-04-29 00:00:00 | 2009-07-08 00:00:00 | B9 | 2
2009-04-21 00:00:00 | 2009-09-07 00:00:00 | W9 | 2.5
2009-04-23 00:00:00 | 2009-07-09 00:00:00 | W9 | 2.5
2009-04-21 00:00:00 | 2009-07-07 00:00:00 | W1 | 6
2008-12-01 00:00:00 | 2009-03-23 00:00:00 | W1 | 8
2009-04-22 00:00:00 | 2009-07-03 00:00:00 | W1 | 8
2009-04-22 00:00:00 | 2009-10-21 00:00:00 | B1 | 8
2009-02-02 00:00:00 | 2009-06-18 00:00:00 | A1 | 8
2009-04-21 00:00:00 | 2009-06-23 00:00:00 | W1 | 1.5
2009-04-22 00:00:00 | 2009-06-24 00:00:00 | W1 | 1.5
2009-04-30 00:00:00 | 2009-07-09 00:00:00 | W1 | 2.5
2009-01-12 00:00:00 | 2009-06-29 00:00:00 | W9 | 4
2009-07-06 00:00:00 | 2009-07-10 00:00:00 | W1 | 40
2008-09-24 00:00:00 | 2009-07-01 00:00:00 | B1 | 3.5
2008-09-16 00:00:00 | 2009-07-07 00:00:00 | B1 | 10
2009-03-09 00:00:00 | 2009-06-29 00:00:00 | W1 | 8
2009-04-16 00:00:00 | 2009-12-10 00:00:00 | W1 | 11
2009-01-31 00:00:00 | 2009-05-02 00:00:00 | W1
2009-05-05 00:00:00 | 2009-12-17 00:00:00 | A9 | 24
2009-04-20 00:00:00 | 2009-08-28 00:00:00 | A9 | 37.5
2008-12-01 00:00:00 | 2009-03-23 00:00:00 | W1 | 8
2008-09-29 00:00:00 | 2009-06-03 00:00:00 | W1 | 9
2009-01-22 00:00:00 | 2009-07-16 00:00:00 | B2 | 16
2009-05-27 00:00:00 | 2009-08-21 00:00:00 | W1 | 10
2008-09-15 00:00:00 | 2009-07-03 00:00:00 | A1 | 19
2009-04-25 00:00:00 | 2009-08-29 00:00:00 | A1 | 3
2008-12-09 00:00:00 | 2009-07-02 00:00:00 | W9 | 27
2009-01-22 00:00:00 | 2009-07-03 00:00:00 | W9 | 23
Spreadsheet: 1f1ea6e8-92d1-437d-b473-26b865761685
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (14 Entries):
 | 13 Automotive 13.6 Active safety
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AB Mikroelektronik GmbH | Austria | [NAME] | 5020 | A6.321
2 | DSP-Weuffen GmbH | Germany | Amtzell | 88279 | A6.313
3 | Emerson & Cuming Microwave Products N.V. | Belgium | Westerlo | 2260 | B5.209
4 | Helion GmbH | Germany | Duisburg | 47057 | A6.313
5 | InnoSenT GmbH | Germany | Donnersdorf | 97499 | A2.114
6 | Integrated Micro-Electronics Inc. (IMI) | Philippines | Binan, Laguna | 4024 | B1.361
7 | Maxell Europe Ltd. | United Kingdom | Maidenhead, Berkshire | [NAME] | B2.637
8 | MENTOR GmbH & Co. Präzisions-Bauteile KG | Germany | Erkrath | 40699 | B5.255
9 | Samsung Electro-Mechanics GmbH | Germany | Schwalbach | 65824 | B6.173
10 | Schaffner Group | Switzerland | Luterbach | 4542 | B2.612
11 | Silicon Sensor International AG | Germany | Berlin | 12459 | A2.307
12 | Vishay Europe Sales GmbH c/o Vishay Electronic GmbH | Germany | Selb | 95100 | A5.143
13 | Willow Technologies Limited | United Kingdom | Lingfield | [NAME] | B5.168
14 | Xylon | Croatia | Zagreb | 10000 | A5.470
Spreadsheet: 1c1ed5bf-d44e-4933-9bef-e88e2ab518dd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-07-21 09:24:14.990000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.357 | 101.232 | 101.107 | 100.732
4.625 | 100.424 | 100.299 | 100.174 | 99.799 |  | Note: | Refer To Price [NAME]
4.5 | 99.947 | 99.822 | 99.697 | 99.322 |  |  | For all Price Adjs
4.375 | 99.324 | 99.199 | 99.074
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.654 | 101.529 | 101.404 | 101.029
4 | 101.334 | 101.209 | 101.084 | 100.709
3.875 | 100.933 | 100.808 | 100.683 | 100.308
3.75 | 100.335 | 100.21 | 100.085 | 99.71
3.625 | 99.409 | 99.284 | 99.159
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-08-04 09:24:14.990000
30 DAY | 2011-08-19 09:24:14.990000
45 DAY | 2011-09-03 09:24:14.990000
60 DAY | 2011-09-18 09:24:14.990000
90 DAY | 2011-10-18 09:24:14.990000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 473916d1470493518-how-to-return-a-blank-cell-until-condition-is-met-workbook2
Sheet: Sheet1

PETTY CASH
DATE | IN | OUT | RECEIPT NO | [NAME] | BALANCE
2016-08-01 00:00:00 |  |  |  | Bal B/F | -20
2016-08-02 00:00:00 | 150
2016-08-03 00:00:00 |  | 5
2016-08-04 00:00:00 |  | 2.75
2016-08-05 00:00:00 |  | 16.45
2016-08-06 00:00:00 |  | 45
2016-08-07 00:00:00 |  | 2.99
2016-08-08 00:00:00 |  | 60
2016-08-09 00:00:00 | 150
2016-08-10 00:00:00 |  | 2.25
2016-08-11 00:00:00 |  | 1.16
2016-08-12 00:00:00 |  | 15.99
2016-08-13 00:00:00 |  | 25
2016-08-14 00:00:00 |  | 14.3
2016-08-15 00:00:00 |  | 28
2016-08-16 00:00:00 |  | 19.99
2016-08-17 00:00:00 |  | 74
2016-08-18 00:00:00 | 150
2016-08-19 00:00:00 |  | 16
2016-08-20 00:00:00 |  | 25
2016-08-21 00:00:00 |  | 35
2016-08-22 00:00:00 |  | 1.5
2016-08-23 00:00:00 |  | 25
2016-08-24 00:00:00 |  | 10
2016-08-25 00:00:00 |  | 2.5
2016-08-26 00:00:00 | 150
2016-08-27 00:00:00
2016-08-28 00:00:00
2016-08-29 00:00:00
2016-08-30 00:00:00
2016-08-31 00:00:00
2016-09-01 00:00:00
2016-09-02 00:00:00
2016-09-03 00:00:00
2016-09-04 00:00:00
2016-09-05 00:00:00
2016-09-06 00:00:00
2016-09-07 00:00:00
2016-09-08 00:00:00
2016-09-09 00:00:00
2016-09-10 00:00:00
2016-09-11 00:00:00
Spreadsheet: 161942d1339677300-ordering-random-letters-for-a-chance-random-based-tv-gameshow-random-example-1-
Sheet: Sheet1

R | R | G | R | R | V | R | R | V | V | R | R | R | V | V | R | R | V | R | V | R | R | V | V | R | V | R | G | R | G | R | V | R | V | R | R | V | V | R | R | R | V | V | R | V | V | V | R | R | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Search Cell | First V | Second V | No of G's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA
Spreadsheet: 827036d1682440868-countifs-matchif-forumla-finding-criteria-on-two-sheets-then-comparing-then-count-countifs-help
Sheet: Report

Name | [NAME] | (desired output) # of Current Access items that match Agreed Access | (desired output) # of Current Access items that do not match Agreed Access
Smith | [EMAIL]
[NAME] | [EMAIL]
Adam | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
 |  | I need the formula to find (person/email) on the Agreed Access sheet then count how many of his access rights match what is on the Current Access sheet. I've tried countifs, Matchif, and vlookup wrapped with countif, and all my attempts have resulted in excel telling me my argument is broken. | Inversely I need the formula to find (person/email) on the Current Access sheet then count how many of his access rights do not match what is on the Agreed Access sheet. I simplified it by adding the items in red on Current Access.
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(LA) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(LA): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2011-12
 | Major Group | LA Liberal Studies
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 7 | 7 | 0 | 0
 |  | Part Time | 2 | 5 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | 6 | 18 | 0 | 2
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | 0 | 0 | 0 | 0
 | [NAME]. graduates admitted to graduate school |  | 0 | 0 | 0 | 0
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
NA denotes we do not offer the program.  We do not track graduates.
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 8788

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
 | [NAME]
 | [NAME]
 | [NAME]
 | Hill Palace
 | Kumarakam
Spreadsheet: 709350d1608259861-identifying-first-occurrence-based-on-a-criteria-book1
Sheet: Sheet1

ID | Status
1 | PASS |  | PASS
2 | PASS |  | FAIL
2 | PASS
2 | FAIL
3 | FAIL
3 | FAIL
4 | FAIL
4 | FAIL
4 | PASS
SUM of unique first pass | 2
SUM of subsequent pass | 1
Spreadsheet: 52719d1252547674-filtering-for-multiple-pay-types-demo-book
Sheet: Sheet4

 |  | Data
OPERNO | OPER_TYPE | Sum of OPER_AMT | Sum of OPER_PART_COST | Sum of OPER_PART_AMT | Sum of OPER_AMT_2
27 | C | 0 | 0 | 0 | 0
02 | C | 16 | 18.35 | 23.95 | 16
 | I | 16 | 18.35 | 23.95 | 16
27 | C | 0 | 0 | 0 | 0
AD | C | 0 | 0 | 0 | 0
 | I | 17 | 65.27 | 84.48 | 17
ADD25 | C | 98.56 | 78.1 | 101.39 | 98.56
ADD50 | C | 216.44 | 100.37 | 173.51 | 216.44
Afcs | C | 7.5 | 4.76 | 12.45 | 7.5
 | I | 7.5 | 12.02 | 12.45 | 7.5
AFT | I | 8.5 | 17.22 | 28.45 | 8.5
C0182 | W | 66.4 | 57.98 | 81.17 | 66.4
CAB | C | 17 | 37.29 | 42.95 | 17
 | I | 17 | 37.29 | 42.95 | 17
Cert | I | 170 | 0 | 0 | 170
E5840 | W | 66.4 | 106.5 | 149.1 | 66.4
[NAME] | I | 42.9 | 71.4 | 84.76 | 42.9
N0734 | W | 16.6 | 0.42 | 0.59 | 16.6
N0735 | W | 16.6 | 0.42 | 0.59 | 16.6
[NAME] | W | 41.5 | 0 | 0 | 41.5
PSF | C | 53.96 | 23.99 | 35.99 | 53.96
Rech | C | 110.5 | 55.86 | 130.2 | 110.5
RMS | C | 0 | 0 | 0 | 0
SI | C | 96 | 0 | 0 | 96
 | I | 48 | 0 | 0 | 48
SS | C | 21.95 | 14.11 | 18 | 21.95
SS8 | C | 65.85 | 55.05 | 72 | 65.85
SSS | C | 26.45 | 36.98 | 43.5 | 26.45
UVI | I | 85 | 0 | 0 | 85
V1321 | W | 58.1 | 0 | 0 | 58.1
V1993 | W | 16.6 | 12.49 | 17.49 | 16.6
Wipers | C | 5.45 | 9.14 | 14.5 | 5.45
(blank) | C | 449.95 | 340.72 | 622.03 | 449.95
Grand Total |  | 1879.71 | 1174.08 | 1816.45 | 1879.71