tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 468674d1467446376-copy-paste-special-between-sheets-problem1
Sheet: totalen

 | st rita2 |  |  |  | kontich |  |  |  | [NAME] | rumst |  | extra's
 | 8 velden | 8 velden |  | 8 velden | 8 velden | 8 velden | 8 velden | 4 velden | 9 velden | 6 velden | 6velden | st rita | nachtegaal
 | 9,98/u | 13,26/u |  | 13,26/u | 9,98/u | 13,26/u | 13,26/u | 6,63/u | 20/u | 14/u | 14/u
 | 24.95 | 19.89 |  | 33.15 | 24.95 | 19.89 | 33.15 | 16.58 | 70 | 35 | 24.5
 | za | za | woe | di | za | za | di | do | ma | zo | woe
 | 9-11.30 | 11.30-13 | 13-15 | 20-22.30 | 9-11.30 | 11.30-13 | 20-22.30 | 20-22.30 | 19-22.30 | 19-21.30 | 20.30-22.15
aug
sept
okt |  |  |  |  |  |  |  |  |  |  |  |  | 16.58
nov |  |  |  |  |  |  |  |  |  |  |  | 99.8 | 13.26
dec
jan
feb |  |  |  |  |  |  |  |  |  |  |  |  | 98.28
mrt
apr
mei |  |  |  |  |  |  |  |  |  |  |  |  | 65.52
jun
 |  | this is (an attempt) to check the payments for the use of badminton courts.
 |  | i must also tell you that i am 'an apprentice sorcerer'
 |  | at the beginning of the season i mark every date we booked (in the corresponding sheets)
 |  | at the end of the month we get the invoice, i check, and as a controle i mark the correct amount in a differant color
 |  | to have an overview, i copy the appropriate amounts, in the sheet='totalen'.
 |  | thus i have a control of all correct and payed invoices.
 |  | at the beginning of the season i have all black amounts and totals that i can expect to be payed
 |  | as the months pass the colors change to green when correct and payed. The amounts can also change according to actual usage of the courts
 |  | so what i expect is: that after changing the color and/or amounts in the last months sheet the data changes as well in the sheet 'totalen'
 |  | the used language is 'dutch'
 |  | suppose that it is februari and that i checked up to and including januari then this is what it should look like
aug | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 0 | 0
sept | 99.8 | 79.56 | 0 | 165.75 | 0 | 0 | 0 | 66.32 | 280 | 140 | 122.5
okt | 124.75 | 99.45 | 0 | 99.44999999999999 | 0 | 0 | 0 | 49.73999999999999 | 280 | 105 | 98
nov | 74.85 | 59.67 | 0 | 99.44999999999999 | 0 | 0 | 0 | 33.16 | 280 | 140 | 49
dec | 74.85 | 59.67 | 0 | 99.44999999999999 | 0 | 0 | 66.3 | 49.73999999999999 | 210 | 70 | 73.5
jan | 99.8 | 79.56 | 0 | 132.6 | 0 | 0 | 0 | 66.32 | 280 | 140 | 98
feb | 74.85 | 59.67 | 0 | 132.6 | 0 | 0 | 0 | 66.32 | 350 | 105 | 73.5
mrt | 74.85 | 59.67 | 0 | 165.75 | 0 | 0 | 0 | 82.89999999999999 | 210 | 105 | 98
apr | 99.8 | 79.56 | 0 | 132.6 | 0 | 0 | 0 | 66.32 | 280 | 70 | 0
mei | 24.95 | 19.89 | 0 | 66.3 | 49.90000000000001 | 39.78 | 99.44999999999999 | 49.73999999999999 | 280 | 0 | 0
jun | 24.95 | 19.89 | 0 | 0 | 74.85000000000001 | 59.67 | 132.6 | 82.89999999999999 | 280 | 0 | 0
 | 773.45 | 616.59 | 0 | 1093.95 | 124.75 | 99.45 | 298.35 | 613.4599999999999 | 2980 | 875 | 612.5
 |  |  |  | 2483.99 |  |  |  | 1136.01 | 2980 |  | 1487.5
 |  |  |  |  |  |  | 3620 |  | 2980 |  | 1487.5
 |  |  |  |  |  |  |  |  | 8380.94
Spreadsheet: 118450d1313696370-product-numbers-and-dist-channels-pivottable
Sheet: Data

Prod ID | Dist Channel | 10_20
100 | 10
200 | 10
300 | 10
400 | 10
500 | 10
100 | 20
600 | 10
700 | 10
200 | 20
800 | 10
Spreadsheet: 59828d1260371805-generate-a-master-worksheet-from-individual-worksheets-rc1272
Sheet: Guide

L:/Reimmeth/RCF6-30-09/Cost Reports |  |  |  |  | File Name: | RC1272
 |  |  |  |  | Tab: | Guide
 |  |  |  |  | Pprd By: | PR
GUIDE FOR RCF.IPC COST REPORT
 |  |  | 7/1/2008 - 6/30/2009
Provider: | South Island
RC#: | RC1272
# [NAME] |  |  |  |  | Notes:
Per C/R |  |  |  | 32
Per Medstat |  |  |  | 32
Per DHEC - Web address below.  Ck variance w/ K. Varn. |  |  |  | 32
www.scdhec.net/hr/licen/hrtypfac.htm
Max # [NAME] served-Will not apply for 6/30/2005 and fwd |  |  |  |  | Problems w/ Errors in Reporting that I.T. is not correcting.
If [NAME] is > # beds, see "Director"
# DAYS |  |  |  | OSS/SSI | IPC | Private | Notes:
Per C/R |  |  |  | 3151 | 4781 | 2383 | Removed PIC from OSS
Per Medstat |  |  |  | 3092 | 4791
[NAME] |  |  | 0.006177508825012607 | 59 | -10
If close, no change necessary.
INCOME |  |  |  | OSS/SSI | IPC | Private | Notes:
Per C/R |  |  |  | 100690 | 29332 | 126129
Per Medstat |  |  |  | 252369.16 | 76656
[NAME]  =  (OSS Net Payment) + (SSI) + (Calculated IPC SSI) - (PNA)
[NAME] |  |  | -1.530534524926551 | -151679.16 | -47324 |  | DA#1 - Use medstat income
If close, no adjustment necessary.
Calculated IPC - SSI |  |  |  | 121792
Personal Needs Income July - Dec |  |  |  | 7434
Personal Needs Income Jan - Jun |  |  |  | 7063
Total Personal Needs Income |  |  |  | 14497
Ensure the following expenses are reported: |  |  |  |  |  | (Key DA# &/or any explanations below)
 | [NAME] (in salaried cost centers) |  |  |  | Y
 | Total Salaries |  | 174955
 | Total Fringes |  | 17857
 | Telephone |  |  |  | Y
 | OTC's |  |  |  | N
 | Prescription Drugs |  |  |  | N
 | Food |  |  |  | Y
 | Utilities |  |  |  | Y
 | Property Tax |  |  |  | Y
 | Building Depreciation |  |  |  | N
 | Building Rent |  |  |  | Y
ESTIMATED Expenses |  |  |  |  | N
DDSN Facility |  |  |  |  | N
DMH Facility |  |  |  |  | N
IPC Facility |  |  |  |  | Y
DAA Made |  |  |  |  | Y
Notes:
Spreadsheet: 59842d1260378877-how-to-remove-a-digit-sun
Sheet: Sheet1

 |  |  |  |  | FIRST | SET
 | 000 | 001 | 002 | 003 | 004 | 005 | 006 | 007 | 008 | 009 |  | NO WANT
 | 011 | 012 | 013 | 014 | 015 | 016 | 017 | 018 | 019 | 022 |  | 0 |  | 333-334-335-336-337-338-339-344-345-346
 | 023 | 024 | 025 | 026 | 027 | 028 | 029 | 033 | 034 | 035 |  | 1 | ANSWER | 347-348-349-355-356-357-358-359-366-367
 | 036 | 037 | 038 | 039 | 044 | 045 | 046 | 047 | 48 | 049 |  | 2 |  | 368-369-377-378-379-388-389-399-444-445
 | 055 | 056 | 057 | 058 | 059 | 066 | 067 | 068 | 069 | 077 |  |  |  | 446-447-448-449-455-456-457-458-459-466
 | 078 | 079 | 088 | 089 | 099 | 111 | 112 | 113 | 114 | 115 |  |  |  | 467-468-469-477-478-479-488-489-499-555
 | 116 | 117 | 118 | 119 | 122 | 123 | 124 | 125 | 126 | 127 |  |  |  | 556-557-558-559-566-567-568-569-577-578
 | 128 | 129 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 144 |  |  |  | 579-588-589-599-666-667-668-669-677-678
 | 145 | 146 | 147 | 148 | 149 | 155 | 156 | 157 | 158 | 159 |  |  |  | 679-688-689-699-777-778-779-788-789-799
 | 166 | 167 | 168 | 169 | 177 | 178 | 179 | 188 | 189 | 199 |  |  |  | 888-889-899-999-
 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 233 | 234
 | 235 | 236 | 237 | 238 | 239 | 244 | 245 | 246 | 247 | 248
 | 249 | 255 | 256 | 257 | 258 | 259 | 266 | 267 | 268 | 269
 | 277 | 278 | 279 | 288 | 289 | 299 | 333 | 334 | 335 | 336
 | 337 | 338 | 339 | 344 | 345 | 346 | 347 | 348 | 349 | 355 |  | WANT |  | 334-337-344-345-346-347-348-349-357-367
 | 356 | 357 | 358 | 359 | 366 | 367 | 368 | 369 | 377 | 378 |  | 7 | ANSWER | 377-378-379-444-445-446-447-448-449-455
 | 379 | 388 | 389 | 399 | 444 | 445 | 446 | 447 | 448 | 449 |  | 4 |  | 456-457-458-459-466-467-468-469-477-478
 | 455 | 456 | 457 | 458 | 459 | 466 | 467 | 468 | 469 | 477 |  |  |  | 479-488-489-499-557-567-577-578-579-667
 | 478 | 479 | 488 | 489 | 499 | 555 | 556 | 557 | 558 | 559 |  |  |  | 677-678-679-777-778-779-788-789-799-
 | 566 | 567 | 568 | 569 | 577 | 578 | 579 | 588 | 589 | 599
 | 666 | 667 | 668 | 669 | 677 | 678 | 679 | 688 | 689 | 699
 | 777 | 778 | 779 | 788 | 789 | 799 | 888 | 889 | 899 | 999
Spreadsheet: 135040d1325772703-filtering-the-contents-of-a-dropdwon-list-ranaldproblem3
Sheet: Sheet1

 | Results table |  |  |  |  |  |  |  | Archive table
 | Item | Code |  |  |  |  |  |  | Item | Code
 | Toaster | H1 |  |  |  |  |  |  | Toaster | T1
 | [NAME] | H2 |  |  |  |  |  |  | House | H1
 | Eggs | H3 |  |  |  |  |  |  | [NAME] | W1
 |  |  |  |  |  |  |  |  | Eggs | EGG001
 |  |  |  |  |  |  |  |  | Milk | M1
 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Toaster | T2
 |  |  |  |  |  |  |  |  | Eggs | EGG002
 |  |  |  |  |  |  |  |  | Milk | M2
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q3FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3865 |  | 0 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4204
Cost of revenue | 1552 |  | -28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -1 |  | 0 |  | 1523
Gross profit | 2313 |  | 28 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 2681
Operating expenses:
Marketing and sales | 825 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 802
General and administrative | 335 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -37 |  | 0 |  | 298
Research and development | 1256 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -106 |  | 0 |  | 1150
Acquisition-related contingent consideration | 16 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 50 |  | -50 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | 0 |  | 0 |  | 0
Total operating expenses | 2498 |  | -66 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | -166 |  | 0 |  | 2250
Operating income (loss) | -185 |  | 94 |  | 0 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
 | 2498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gain on strategic investments | -185 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.92
Interest and other income (expense), net | -9 |  | 0 |  | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for (benefit from) income taxes | -194 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
Provision for (benefit from) income taxes | -21 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 141 |  | 120
Net income (loss) | -173 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | -141 |  | 311
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.54 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.92
Spreadsheet: 688299d1595695204-extract-dates-from-vlookup-vlookup-problem
Sheet: Sheet1

 |  | Misuse |  |  |  | Other
Id | Location Name | Events | 1st Event | 2nd Event | 3rd Event | Events | 1st Event | 2nd Event | 3rd Event
2125 | Location A |  |  |  |  | 3
Spreadsheet: 14b4d7cd-266a-4462-aa77-af460be24771
Sheet: CDS-J

[NAME]
J1 | Degrees conferred between July 1, 2012 and June 30, 2013
J1 | For each of the following discipline areas, provide the percentage of diplomas/certificates, associate, and bachelor’s degrees awarded. To determine the percentage, use majors, not headcount (e.g., students with one degree but a double major will be represented twice). Calculate the percentage from your institution’s IPEDS Completions by using the sum of 1st and 2nd majors for each CIP code as the numerator and the sum of the Grand Total by 1st Majors and the Grand Total by 2nd major as the denominator. If you prefer, you can compute the percentages using 1st majors only.
J1 | Category | Diploma/Certificates | Associate | Bachelor’s | CIP 2010 Categories to Include
J1 | Agriculture |  |  |  | 1
J1 | Natural resources and conservation |  |  |  | 3
J1 | Architecture |  |  |  | 4
J1 | Area, ethnic, and gender studies |  |  |  | 5
J1 | Communication/journalism |  |  |  | 9
J1 | Communication technologies |  |  |  | 10
J1 | Computer and information sciences |  |  | 0.02 | 11
J1 | Personal and culinary services |  |  |  | 12
J1 | Education |  |  |  | 13
J1 | Engineering |  |  |  | 14
J1 | Engineering technologies |  |  |  | 15
J1 | Foreign languages, literatures, and linguistics |  |  | 0.03 | 16
J1 | Family and consumer sciences |  |  |  | 19
J1 | Law/legal studies |  |  |  | 22
J1 | English |  |  | 0.07 | 23
J1 | Liberal arts/general studies |  |  | 0.04 | 24
J1 | Library science |  |  |  | 25
J1 | Biological/life sciences |  |  | 0.09 | 26
J1 | Mathematics and statistics |  |  | 0.04 | 27
J1 | Military science and military technologies |  |  |  | 28 & 29
J1 | Interdisciplinary studies |  |  | 0.07 | 30
J1 | [NAME] and recreation |  |  |  | 31
J1 | Philosophy and religious studies |  |  | 0.01 | 38
J1 | Theology and religious vocations |  |  |  | 39
J1 | Physical sciences |  |  | 0.04 | 40
J1 | Science technologies |  |  |  | 41
J1 | Psychology |  |  | 0.1 | 42
J1 | Homeland Security, law enforcement, firefighting, and protective services |  |  |  | 43
J1 | Public administration and social services |  |  |  | 44
J1 | Social sciences |  |  | 0.25 | 45
J1 | Construction trades |  |  |  | 46
J1 | Mechanic and repair technologies |  |  |  | 47
J1 | Precision production |  |  |  | 48
J1 | Transportation and materials moving |  |  |  | 49
J1 | Visual and performing arts |  |  | 0.05 | 50
J1 | Health professions and related programs |  |  |  | 51
J1 | Business/marketing |  |  | 0.14 | 52
J1 | History |  |  | 0.05 | 54
J1 | Other
J1 | TOTAL (should = 100%)
Spreadsheet: 173452d1344555804-help-calculating-results-of-last-10-games-and-win-loss-tie-streak-in-standings-workbook-2003-04-nhl-season
Sheet: Playoffs (League)

 |  | First Round |  |  |  |  | Quarter-finals |  |  |  |  | Semi-finals |  |  |  |  | Stanley Cup Finals
 | 1
 | 16
 | 8
 | 9
 | 4
 | 13
 | 5
 | 12
 | 3
 | 14
 | 6
 | 11
 | 2
 | 15
 | 7
 | 10
Spreadsheet: 77556d1278001630-monthly-template-book1
Sheet: Data

NPS Officer | Licence type | [NAME] | NPS number | Advertising | Days | KPI | Time recording | Time (hrs) | hours | Minutes
[NAME] | Full | A | 1 | no | 92 | PASS | 2900 | 48.33333333333334 | 48 | 20.00000000000014
[NAME] | Full | B | 2 | no | 120 | PASS | 2425 | 40.41666666666666 | 40 | 24.99999999999986
[NAME] | Full | C | 3 | no | 164 | FAIL | 3110 | 51.83333333333334 | 51 | 50.00000000000014
[NAME] | Full | D | 4 | no | 177 | FAIL | 2397.5 | 39.95833333333334 | 39 | 57.50000000000014
[NAME] | Full | E | 5 | no | 178 | FAIL | 2397.5 | 39.95833333333334 | 39 | 57.50000000000014
[NAME] | Full | F | 6 | no | 174 | FAIL | 3515 | 58.58333333333334 | 58 | 35.00000000000014
[NAME] | Full | G | 7 | no | 90 | PASS | 4877 | 81.28333333333333 | 81 | 16.99999999999989
[NAME] | Full | H | 8 | no | 91 | PASS | 4385 | 73.08333333333333 | 73 | 4.999999999999716
[NAME] | Full | I | 9 | no | 91 | PASS | 5619 | 93.65 | 93 | 39.00000000000034
[NAME] | Full | J | 10 | yes | 120 | PASS | 4500 | 75 | 75 | 0
[NAME] | Full | K | 11 | no | 119 | PASS | 3120 | 52 | 52 | 0
[NAME] | Full | L | 12 | no | 50 | PASS | 2400 | 40 | 40 | 0
[NAME] | Hydropower | M | 13 | yes | 129 | PASS | 3500 | 58.33333333333334 | 58 | 20.00000000000014
[NAME] | Hydropower | N | 14 | yes | 129 | PASS | 3500 | 58.33333333333334 | 58 | 20.00000000000014
[NAME] | Pre-app | O | 15 | no |  |  | 285 | 4.75 | 4 | 45
[NAME] | Withdrawn | P | 16 | no |  | 0 | 760 | 12.66666666666667 | 12 | 39.99999999999996
[NAME] | Pre-app | Q | 17 | no |  |  | 195 | 3.25 | 3 | 15
Spreadsheet: 130027d1322025236-lookup-value-of-a-code-to-different-code-which-is-almost-common-to-a-lookup-value-1234
Sheet: Target

S.No. | [NAME]
1 | 11200198900
2 | 11100KWA900
3 | 11200KST870
4 | 11200KVH950
5 | 11200KWA900
6 | 11330KCC730
7 | 11330KST901
8 | 11330KTC901
9 | 11330KVH760
10 | 11330KWA900
11 | 11330KWHY00
12 | 11341KCC900
13 | 11341KST870
14 | 11341KTC900
15 | 17511KWH970ZA
16 | 77236KCC900ZV
17 | 77240KWA930ZD
18 | 77250KWA930ZE
19 | 83300KVH760ZA
20 | 83400KST930ZA
21 | 83400KVH760ZA
22 | 83400KWA910ZA
23 | 83400KWA910ZA
24 | 83400KWA910ZA
25 | 83501KCC905ZA
26 | 83505KST860ZD
27 | 83601KCC905ZA
28 | 83605KST880ZC
Spreadsheet: 68318d1268841428-countifs-with-or-functions-catabcharthelp
Sheet: Sheet1

barclays premier league | jo |  |  | cat a | cat b |  | Cat A | Cat B | Cat C
barclays premier league | mark |  | jo |  |  |  | International | The Championship | Everything Else
barclays premier league | dean |  | mark |  |  |  | Champions League | Clydesdale Bank Premier
barclays premier league | dean |  | dean |  |  |  | Carling Cup | UEFA Cup
barclays premier league | dean |  | rich |  |  |  | FA Cup | Bundesliga
barclays premier league | mark |  | [NAME] |  |  |  | Barclays Premier League | Serie A
barclays premier league | rich |  | [NAME] |  |  |  | World Cup | Primera Division
barclays premier league | [NAME]
barclays premier league | [NAME]
barclays premier league | [NAME]
Clydesdale Bank Premier | [NAME]
fa cup | jo
Bundesliga | jo
barclays premier league | jo
barclays premier league | rich
barclays premier league | jo
FA Cup | mark
Barclays Premier League | mark
World Cup | [NAME]
dutch | [NAME]
hungarian | jo
romanian | mark
Spreadsheet: 695127d1600070347-average-if-todays-date-has-month-in-cell-example
Sheet: Sheet1

Month | Monthly Total # | # of Pass | % Pass
July 2020 | 3 | 3 | 100
August 2020 | 6 | 6 | 100
September 2020 | 1 | 1 | 100
October 2020 | 0 | 0 | 0
November 2020 | 0 | 0 | 0
December 2020 | 0 | 0 | 0
 |  | Average | ???
Spreadsheet: 484123d1476122336-adding-data-relating-to-both-blank-and-ful-lcells-query
Sheet: Sheet1

 |  |  |  | À | B | C
 |  |  |  | Name | Time | Amount |  | Required
 |  |  | 1 | B | 09:00:00 | 100 |  | Amount
 |  |  | 2 |  |  | 200 |  | 600
 |  |  | 3 |  |  | 300
 |  |  | 4 |  | 10:00:00 | 400
 |  |  | 5 |  |  | 400
 |  |  | 6 |  |  | 200
 |  |  | 7 |  |  | 300
Spreadsheet: 734469d1622187173-multi-if-and-function-for-range-of-cell-something-wrong-in-formula-multi-if
Sheet: Sheet2

Well | AAAA | BBBB | CCCC | DDDD | Sum | Interpret |  |  |  |  |  | Sum | Interpretation
A01 |  |  |  |  |  |  |  |  |  |  |  | 2 | Negative
A02 |  |  |  |  |  |  |  |  |  |  |  | 0 | Invalid
A03 |  |  |  |  |  |  |  |  |  |  |  | 15 | Positive
A04 |  |  |  |  |  |  |  |  |  |  |  | 13 | Positive
A05 |  |  |  |  |  |  |  |  |  |  |  | 11 | Positive
A06 |  |  |  |  |  |  |  |  |  |  |  | 9 | Positive
A07 |  |  |  |  |  |  |  |  |  |  |  | 14 | Positive
A08 |  |  |  |  |  |  |  |  |  |  |  | 12 | Positive
A09 |  |  |  |  |  |  |  |  |  |  |  | 10 | Like
A10 |  |  |  |  |  |  |  |  |  |  |  | 8 | Like
A11 |  |  |  |  |  |  |  |  |  |  |  | 7 | Unreliable
A12 |  |  |  |  |  |  |  |  |  |  |  | 5 | Unreliable
B01 |  |  |  |  |  |  |  |  |  |  |  | 3 | Unreliable
B02 |  |  |  |  |  |  |  |  |  |  |  | 1 | Unreliable
B03 |  |  |  |  |  |  |  |  |  |  |  | 6 | Unreliable
B04 |  |  |  |  |  |  |  |  |  |  |  | 4 | Unreliable
B05
B06
B07
B08
B09
B10
B11
B12
C01
C02
C03
C04
C05
C06
C07
C08
C09
C10
C11
C12
D01
D02
D03
D04
D05
D06
D07
D08
D09
D10
D11
D12
E01
E02
E03
E04
E05
E06
[NAME]
E08
E09
E10
E11
E12
Spreadsheet: 863438d1710933368-creating-lists-with-multiple-criteria-sample-excel
Sheet: Output

Title
Name | Bank | Current Balance
 |  | USD
[NAME] | Bank 2 | 35000
[NAME] | Bank 5 | 50000
[NAME] | Bank 2 | 125000
[NAME] | Bank 2 | 26000
[NAME] | Bank 3 | 35000
[NAME] | Bank 5 | 30000
 | TOTAL
Spreadsheet: 44608d1243383607-multiple-lookup-values-employeepayroll-we-052309
Sheet: Employee Information

Name | [NAME] | Job Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Type
[NAME] | 10 | HourlyAttend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HourlyAttend
[NAME] | 10 | HourlyAttend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PerJobAtt
[NAME] | 12 | Scrapbook |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scrapbook
[NAME] | 15 | OldBooth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OldBooth
[NAME] | 18 | HourlyAttend
Krystal Brisse | 4 | HourlyAttend
[NAME] | 13 | HourlyAttend
[NAME] | 53 | HourlyAttend
[NAME] 2 | 687 | HourlyAttend
[NAME] | 34 | HourlyAttend
[NAME] 2 | 64 | HourlyAttend
[NAME] | 24 | HourlyAttend
[NAME] | 75 | HourlyAttend
[NAME] | 875 | PerJobAtt
[NAME] | 34 | HourlyAttend
[NAME] | 2375 | HourlyAttend
[NAME] | 5 | HourlyAttend
Heather Koczara | 63 | PerJobAtt
[NAME] | 34 | HourlyAttend
[NAME] | 76 | HourlyAttend
[NAME] | 354 | PerJobAtt
Roxanne- B | 6 | HourlyAttend
[NAME] | 4 | HourlyAttend
[NAME] | 3 | PerJobAtt
Spreadsheet: 113188d1309174963-formula-required-which-meets-12-conditions-maybelike-this
Sheet: Sheet1

 | 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
 | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N
 | A | M | D | E | N | A | A | A | M | M | C | D | D | M | M | M | N | N | N | A | A | A | D | D | D | E | E | E | A | A | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF D3= "O"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | E | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | C | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | A | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | M | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | N | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if D3= ("A","M","N")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | E | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | C | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | A | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | M | 0
 | What is required a Formula in D5 where all these ~ 12 conditions are met |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | N | 0
 | Explanation
 | We have two major conditions and each major condition have 6 sub conditions
 | 1) | IF D3="O"then in D4 if one of the six conditions true like "D,E,C,A,M,N" then answer is either 12, 16, or 8 and IF false answer is 0
 | 2) | IF D3="A,M,N"then in D4 if one of the six conditions true like "D,E,C,A,M,N" then answer is either 4, 8, or 0 and IF false answer is 0
Spreadsheet: 7c23167e-b95c-4679-8573-44dcab067a99
Sheet: User Rate Change Summary

Table 7.5.  User Rates Needed to Finance Project
Current Sewer Bill ($/5,000 gallons): |  | Current Water Bill ($/5,000 gallons):
 | Funding Source | User Rate Increase Due to Project @ Current Interest Rate (All Users) | User Rate Increase Due to Project @ Worst-Case Interest Rate (All Users) | User Rate Increase Due to Project @ Current Rate (Residential Users Only) | User Rate Increase Due to Project @ Worst-Case Interest Rate (Residential Users Only)
Main IFS Funding Source:
Funding Source 1:
Funding Source 2:
Funding Source 3:
Funding Source 4:
Funding Source 5:
 | Total User Rate Increase Due to IFS Loan(s) ($/5,000 gal.):
 | Total Increase Due to All Loans(s) ($/5,000 gal.):
 | New Sewer [NAME] to IFS Loan(s) ($/5,000 gal.):
New Sewer [NAME] to All Loan(s) ($/5,000 gal.):
 | Percent Change in Sewer Bill Due to IFS Loan(s):
Percent Change in Sewer Bill Due to All Loan(s):
 | New Sewer & Water Bills Due to IFS Loan(s) ($/5,000 gal.):
 | New Water & Sewer Bills Due to All Loan(s) ($/5,000 gal.):
 | Percent Change in Sewer & Water Bills Due to IFS Loan(s):
 | Percent Change in Sewer & Water Bills Due to All Loan(s):
aChange in User Fee to finance IFS Loan.
bChange in User Fee to finance ALL funding sources.