tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 485455d1476887294-formula-to-match-and-do-an-if-statement-help-book9
Sheet: Sheet1

 |  |  |  |  |  | PO Number:
 |  |  |  |  |  | 10712677
 |  |  |  |  |  | QTY | Amount
 | AN01 |  | EA | 1 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN02 |  | EA | 2 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN03 |  | EA | 3 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN04 |  | EA | 4 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN05 |  | EA | 5 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN21 |  | EA | 6 |  |  | 0 |  |  | 0 |  | 0 | 0
 | AN70 |  | EA | 7 |  |  | 0 |  |  | 0
 | AN71 |  | EA | 8 |  |  | 0 |  |  | 0
 | AN81 |  | EA | 9 |  |  | 0 |  |  | 0
 | CB01 |  | EA | 10 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CB02 |  | EA | 11 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CB11 |  | EA | 12 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CB13 |  | EA | 13 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CB14 |  | EA | 14 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CB70 |  | EA | 15 |  |  | 0 |  |  | 0
 | CM01 |  | EA | 16 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CM02 |  | EA | 17 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CM03 |  | EA | 18 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CN04 |  | EA | 19 |  |  | 0 |  |  | 0 |  | 0 | 0
 | CN06 |  | EA | 20 |  |  | 0 |  |  | 0 |  | 0 | 0
 | DL07 |  | EA | 21 |  |  | 0 |  |  | 0 |  | 0 | 0
 | GR10 |  | EA | 22 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM05 |  | EA | 23 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM13 |  | EA | 24 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM14 |  | EA | 25 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM15 |  | EA | 26 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM16 |  | EA | 27 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM17 |  | EA | 28 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PM18 |  | EA | 29 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PW08 |  | EA | 30 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PW11 |  | EA | 31 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PW14 |  | EA | 32 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PW15 |  | EA | 33 |  |  | 0 |  |  | 0 |  | 0 | 0
 | PW19 |  | EA | 34 |  |  | 0 |  |  | 0 |  | 0 | 0
 | SH11 |  | EA | 35 |  |  | 0 |  |  | 0 |  | 0 | 0
 | TL04 |  | EA | 36 |  |  | 0 |  |  | 0 |  | 0 | 0
 | TL05 |  | EA | 37 |  |  | 0 |  |  | 0 |  | 0 | 0
 | TL08 |  | EA | 38 |  |  | 0 |  |  | 0 |  | 0 | 0
 | [NAME] |  | EA | 39 |  |  | 0 |  |  | 0 |  | 0 | 0
 | TS26 |  | EA | 40 |  |  | 0 |  |  | 0
 | TS28 |  | EA | 41 |  |  | 0 |  |  | 0
 | TS60 |  | EA | 42 |  |  | 0 |  |  | 0
 | TS61 |  | EA | 43 |  |  | 0 |  |  | 0
 | TS62 |  | EA | 44 |  |  | 0 |  |  | 0
 | TS63 |  | EA | 45 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
Spreadsheet: 455606d1460429898-interpolation-466-interpolation
Sheet: Sheet1

 | Sieve Size | % Retained |  | Helper Columns |  |  |  |  |  |  | Match Values
 | 500
 | 300 |  |  |  |  |  |  | 10
 | 150 | 100
 | 100
 | 75 | 87
 | 63
 | 53 | 68
 | 37.5 | 51
 | 26.5 | 41
 | 19 | 36
 | 16
 | 13.2
 | 9.5
 | 6.7 |  |  |  |  |  |  | Interpolations
 | 4.75 | 3.5
 | 2.36 | 3.3
 | 0.075 | 2.9
Spreadsheet: f0d51247-d5e5-4f8f-8f9c-075f4fde0e8f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43460172 | 2014-10-06 05:34:29 | ALLIES | 0 | 7 | 8 | 679790 | Hermann | 15357 |  | 1940-12-24 |  |  | WWZ 2 : L'attaque de Vladivostok
43460352 | 2014-10-06 05:49:54 | AXIS | 1 | 7 | 3 | 679790 | Hermann | 15459 |  | 1944-06-06 |  | Mirror Battle
Spreadsheet: 84169d1284151596-listing-gaps-in-dates-bba-excel-csc-2-test
Sheet: Sheet2

COURSE SCHEDULE CHANGE
Warner Pacific College/ADULT DEGREE PROGRAM
Name: |  |  |  |  | Student ID: |  |  | Cohort:
Date: |  |  |  |  | Date of Determination:
Comments:
COURSE SCHEDULE CHANGE
 |  | Includes permanent cohort change? |  |  |  | New Cohort: |  |  |  | Effective on:
 |  | Anticipated graduation ceremony
 |  | Days out of attendance great than 35? |  |  |  |  | yes |  | no
 |  | Course # | Course Title | Group $
 | Add
 | Add
 | Add
 | [NAME]
 | [NAME]
 | [NAME]
FUTURE BREAKS IN ATTENDANCE GREATER THAN 35 / POSSIBLE LOA’S
 | Dates |  |  |  | to
 | Dates |  |  |  | to
 |  |  |  |  |  |  | Total LOA days:
Please note:
 | The CSC form and any accompanying documents must be received by the ADP staff within five business days of the date on the form or it will be voided and all appropriate charges and academic policies will be applied.
 | To request a refund of textbook charges or to return unused books, please contact the ADP Bookstore at [PHONE] or download the form from the ADP website at www.adp.warnerpacific.edu.
 | Course changes and withdrawals may affect your Financial Aid; please consult with your Financial Aid Counselor.
 | Reference “Change of Student Status” and “ADP Refund Policy” in the ADP Bulletin for information regarding course withdrawals.
I have read and understand the Educational Policies as stated in the ADP Bulletin and agree to pay all charges resulting from this schedule change.
Student Signature: |  |  |  |  |  |  |  |  | Date:
For Office Use:
 | AC:
 | SS:
 | Changed AGD? New AGD: |  |  |  |  |  |  |  |  | Revised 7/7/10
Spreadsheet: 810675d1671953671-index-match-column-row-with-duplicate-variables-in-the-row-ss
Sheet: Sheet1

 | 2023-09-01 00:00:00 |  |  | Sale Date | Customer | Sale
Customer 1 | 1 |  |  | 2023-09-03 00:00:00 | Customer 2
Customer 1 |  | 3 | 4 | 2023-09-01 00:00:00 | Customer 2 |  | Retrieves the first cell with data!
Customer 2 | 2 | 2 |  | 2023-09-04 00:00:00 | Customer 2
Customer 3 |  | 2
Customer 2 | 1 |  | 1
Spreadsheet: 154230d1336325129-excel-paste-solution-file00
Sheet: Sheet1

no. | [NAME] with paste | I want like this with paste special or formula
1 | 1 | 1
 | 0 | 1
 | 0 | 1
 | 0 | 1
2 | 2 | 2
 | 0 | 2
 | 0 | 2
 | 0 | 2
3 | 3 | 3
 | 0 | 3
 | 0 | 3
 | 0 | 3
4 | 4 | 4
Spreadsheet: 8af5d383-67e7-4387-b708-98f502e8cb82
Sheet: Sheet1

athletes_idAthletes | Rk | Nation | Date of Birth | ID Number | Last Name | First Name | Total Pts | Fenc | Swim | Ride | Comb | Swim time
39844 | 1 | RUS | 01/07/88 | M039844 | LESUN | Aleksander | 5804 | 1040 | 1340 | 1180 | 2244 | 2:01.66
1445 | 2 | HUN | 05/04/86 | M001445 | KASZA | [NAME] | 5788 | 920 | 1368 | 1180 | 2320 | 1:59.44
5255 | 3 | HUN | 20/03/90 | M005255 | DEMETER | Bence | 5784 | 880 | 1332 | 1180 | 2392 | 2:02.50
1227 | 4 | RUS | 04/04/84 | M001227 | FROLOV | Ilia | 5768 | 880 | 1332 | 1200 | 2356 | 2:02.53
4663 | 5 | BLR | 14/04/88 | M004663 | ZHURAULIOU | Stanislau | 5712 | 920 | 1284 | 1200 | 2308 | 2:06.50
1582 | 6 | RUS | 03/06/79 | M001582 | MOISEEV | [NAME] | 5644 | 1080 | 1312 | 1160 | 2092 | 2:04.18
218 | 7 | LAT | 02/11/78 | M000218 | CERKOVSKIS | Deniss | 5620 | 880 | 1276 | 1140 | 2324 | 2:07.28
1767 | 8 | CZE | 19/03/85 | [NAME] | SVOBODA | [NAME] | 5604 | 840 | 1328 | 1180 | 2256 | 2:02.87
2960 | 9 | EGY | 08/02/89 | M002960 | HEFNY | [NAME] | 5600 | 880 | 1284 | 1160 | 2276 | 2:06.39
5404 | 10 | FRA | 29/03/90 | M005404 | PATTE | [NAME] | 5596 | 760 | 1316 | 1100 | 2420 | 2:03.82
39562 | 11 | RUS | 13/08/93 | M039562 | KUKARIN | [NAME] | 5588 | 840 | 1328 | 1160 | 2260 | 2:02.97
402 | 12 | GER | 22/07/81 | M000402 | GEBHARDT | Steffen | 5564 | 800 | 1244 | 1200 | 2320 | 2:09.66
2151 | 13 | RUS | 05/01/88 | M002151 | KARYAKIN | Serguei | 5532 | 760 | 1340 | 1200 | 2232 | 2:01.82
37207 | 14 | BUL | 21/08/89 | M037207 | DIMITROV | Blagoy | 5516 | 880 | 1336 | 1160 | 2140 | 2:02.22
1901 | 15 | CZE | 17/03/88 | M001901 | POLIVKA | Ondrej | 5436 | 680 | 1320 | 1200 | 2236 | 2:03.37
39664 | 16 | RUS | 13/09/92 | M039664 | SHUGAROV | Ilya | 5412 | 880 | 1264 | 1160 | 2108 | 2:08.28
1925 | 17 | GER | 11/09/84 | M001925 | KOLLNER | [NAME] | 5388 | 720 | 1248 | 1140 | 2280 | 2:09.56
37922 | 18 | ESP | 26/11/91 | M037922 | RODRIGUEZ | Christobal | 5380 | 720 | 1320 | 1200 | 2140 | 2:03.56
1701 | 19 | UKR | 02/06/85 | M001701 | [NAME] | Dmytro | 5372 | 800 | 1304 | 1160 | 2108 | 2:04.82
1936 | 20 | UKR | 02/01/83 | M001936 | [NAME] | Pavlo | 5356 | 880 | 1272 | 1140 | 2064 | 2:07.59
5077 | 21 | CHI | 17/12/92 | M005077 | BUSTOS | Esteban | 5348 | 600 | 1248 | 1200 | 2300 | 2:09.63
39502 | 22 | POR | 24/06/84 | [NAME] | REGO | Ricardo | 5248 | 640 | 1388 | 1200 | 2020 | 1:57.68
2049 | 23 | UKR | 13/10/86 | M002049 | TYMOSHCHENKO | Pavlo | 5228 | 600 | 1236 | 1180 | 2212 | 2:10.41
1455 | 24 | AUT | 17/06/85 | M001455 | DANIEL | [NAME] | 5044 | 640 | 1236 | 1160 | 2008 | 2:10.59
Spreadsheet: 215485d1361390157-auto-filling-formulas-across-multiple-sheets-excel-percent-diff-example
Sheet: BEFORE

Subsidiary | Distributor | 2012 | % DIFF VS. [NAME] |  | 2011 | % DIFF VS. [NAME] |  | 2010 | % DIFF VS. [NAME] |  | 2009
COMPANY NAME | 1A | 164516 |  |  | 10188 |  |  | 3754 |  |  | 0
COMPANY NAME | 2A | 7072 |  |  | 44134 |  |  | 0 |  |  | 13358
COMPANY NAME | 3A | 37420 |  |  | 21182 |  |  | 48936 |  |  | 94594
COMPANY NAME | 4A | 0 |  |  | 1006 |  |  | 74166 |  |  | 92941
COMPANY NAME | 5A | 12666 |  |  | 0 |  |  | 1083 |  |  | 12477
COMPANY NAME | 6A | 308966 |  |  | 10652 |  |  | 0 |  |  | 0
COMPANY NAME | 7A | 15178 |  |  | 0 |  |  | 34094 |  |  | 25456
COMPANY NAME | 8A | 4132 |  |  | 21144 |  |  | 10936 |  |  | 209652
COMPANY NAME | 9A | 3632 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 10A | 213376 |  |  | 43898 |  |  | 121108 |  |  | 0
COMPANY NAME | 11A | 40370 |  |  | 81366 |  |  | 139506 |  |  | 0
COMPANY NAME | 12A | 133046 |  |  | 0 |  |  | 0 |  |  | 25848
COMPANY NAME | 13A | 14308 |  |  | 0 |  |  | 1700 |  |  | 5458
COMPANY NAME | 14A | 0 |  |  | 0 |  |  | 15764 |  |  | 63154
COMPANY NAME | 15A | 86386 |  |  | 620664 |  |  | 457904 |  |  | 843460
COMPANY NAME | 16A | 375926 |  |  | 319406 |  |  | 72218 |  |  | 0
COMPANY NAME | 17A | 3720 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 18A | 8970 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 19A | 13326 |  |  | 1064 |  |  | 0 |  |  | 0
COMPANY NAME | 20A | 83264 |  |  | 0 |  |  | 236834 |  |  | 138062
COMPANY NAME | 21A | 3332 |  |  | 962 |  |  | 3288 |  |  | 284
COMPANY NAME | 22A | 170446 |  |  | 344586 |  |  | 197296 |  |  | 0
COMPANY NAME | 23A | 19092 |  |  | 0 |  |  | 0 |  |  | 8814
COMPANY NAME | 24A | 9474 |  |  | 2128 |  |  | 0 |  |  | 33302
COMPANY NAME | 25A | 0 |  |  | 0 |  |  | 0 |  |  | 109082
COMPANY NAME | 26A | 27392 |  |  | 14584 |  |  | 0 |  |  | 28962
COMPANY NAME | 27A | 0 |  |  | 0 |  |  | 0 |  |  | 7500
COMPANY NAME | 28A | 13186 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 29A | 0 |  |  | 27207 |  |  | 40846 |  |  | 34188
COMPANY NAME | 30A | 59816 |  |  | 94326 |  |  | 0 |  |  | 0
COMPANY NAME | 31A | 104988 |  |  | 3008 |  |  | 0 |  |  | 162740
COMPANY NAME | 32A | 860393 |  |  | 474810 |  |  | 600634 |  |  | 1986064
COMPANY NAME | 33A | 292 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 34A | 19692 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 35A | 2644 |  |  | 0 |  |  | 0 |  |  | 5231
COMPANY NAME | 36A | 0 |  |  | 0 |  |  | 14460 |  |  | 0
COMPANY NAME | 37A | 1816 |  |  | 1238 |  |  | 62098 |  |  | 0
COMPANY NAME | 38A | 4380 |  |  | 1364 |  |  | 18374 |  |  | 0
COMPANY NAME | 39A | 11856 |  |  | 9568 |  |  | 7288 |  |  | 0
COMPANY NAME | 40A | 390 |  |  | 0 |  |  | 0 |  |  | 2303
COMPANY NAME | 41A | 87172 |  |  | 103377 |  |  | 294270 |  |  | 128284
COMPANY NAME | 42A | 539870 |  |  | 404900 |  |  | 328254 |  |  | 581508
COMPANY NAME | 43A | 328012 |  |  | 108526 |  |  | 26046 |  |  | 29732
COMPANY NAME | 44A | 0 |  |  | 0 |  |  | 0 |  |  | 45604
COMPANY NAME | 45A | 600916 |  |  | 14050 |  |  | 35922 |  |  | 239220
Spreadsheet: 33d3ca8f-48d7-4ee9-804d-2cb7a6cc126b
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.41%
Canadian Oil Sands Ltd | 3.08%
Baytex Energy Corp. | 3.02%
Crescent Point Energy Crp | 2.99%
Capital Power Corp | 2.82%
BCE Inc. | 2.72%
Northland Power Inc | 2.59%
Freehold Royalties Ltd | 2.41%
Enbridge Income Fund Hld | 2.39%
National Bank of Canada | 2.29%
Emera Inc. | 2.28%
Great-West Life Company | 2.28%
Bank of Montreal | 2.24%
Cdn Imperial Bk of Commrc | 2.21%
Pembina Pipeline Inc | 2.20%
IGM Financial Inc. | 2.19%
Power Financial Corp. | 2.19%
Rogers Communications Inc | 2.15%
Power Corporation Canada | 2.14%
Fortis Inc. | 2.13%
TransCanada Corp. | 2.13%
Inter Pipeline Ltd. | 2.12%
Bank of Nova Scotia | 2.11%
Sun Life Financial Inc. | 2.08%
Royal Bank of Canada | 2.08%
Shaw Communicatn Cl B Nvs | 2.07%
Potash Corp of Saskatchwn | 2.05%
Thomson Reuters Corp | 1.99%
Keyera Corp | 1.95%
[NAME] Cl B Nvs | 1.88%
Toronto-Dominion Bank | 1.85%
TELUS Corp. | 1.77%
Transcontinental Inc Cl A | 1.73%
ARC Resources Ltd | 1.73%
Vermilion Energy, Inc. | 1.67%
Mullen Group Ltd. | 1.66%
AGF Management Ltd Cl B | 1.63%
Enbridge Inc. | 1.58%
Husky Energy Inc. | 1.57%
Genworth MI Canada Inc | 1.55%
Wajax Corporation | 1.52%
Cineplex Inc. | 1.51%
CI Financial Corp | 1.45%
Brookfield Property Ptner | 1.36%
Aimia Inc. | 1.36%
Dorel Industries Inc Cl B | 1.33%
First Capital Realty Inc | 1.22%
Ensign Energy Srvcs Inc | 1.15%
Teck Resources Ltd Cl B | 1.08%
Canexus Corporation | 0.62%
Cash | 0.40%
Sherritt Intl Corp | 0.08%
Total Holdings in Portfolio | 52
Spreadsheet: 217946d1362260418-pulling-date-from-9-sheets-to-be-displayed-on-front-sheet-packing-list-final
Sheet: Magnum

Nisha |  | [NAME]
 |  | [NAME]
Packing No. | Collection Date | Packed | Collected | date | Collections Key
5237 | 2013-12-03 00:00:00
5226 | 2013-12-03 00:00:00
5218 | 2013-03-14 00:00:00
4878 | 2013-03-14 00:00:00
4453 | 2013-02-27 00:00:00
 | 2013-02-28 00:00:00
Spreadsheet: 00a9de89-27b8-4fbd-8037-02190d84481d
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
ALB | Test | ALB | Albumin, Serum | Albumin, S | Photometric, Bromcresol Green | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =12 months: 3.5-5.0 g/dL  Reference values have not been established for patients who are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82040 |  |  |  |  | Rochester
ALB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 150 days
ALB | Result | ALB | Albumin, S | Albumin, S | Numeric |  |  |  |  | g/dL |  |  |  |  |  |  |  |  |  | 1751-7 | Albumin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: phillip_m_love__30632__9911 Texas FRED
Sheet: ASum 

TAGG | Counterparty | Amount
E05136.5 Total |  | 531.01
E05228.4 Total |  | 2550
E06912.S Total |  | 93075
E07001.7 Total |  | 49492.53
E07001.A Total |  | -13499.85
E24155.4 Total |  | 18.35
E24161.4 Total |  | 245.86
E24336.4 Total |  | 283.5
E24344.3 Total |  | 59.35
[NAME] |  | 31.5
E24371.5 Total |  | 1049.94
E24371.6 Total |  | -1049.94
E25904.5 Total |  | 1364.94
E26357.4 Total |  | 720
E26418.4 Total |  | 600
E33520.9 Total |  | 12672
E33520.B Total |  | 6162.84
E43532.4 Total |  | 13937.42
E50361.3 Total |  | 59.4
E99035.3 Total |  | 862.5
EK1314.1 Total |  | 100000
EK1331.3 Total |  | -93075
EO3094.1 Total |  | -14919
EO3094.2 Total |  | 14919
ET5235.1 Total |  | -100000
ET5235.2 Total |  | 100000
EY2670.1 Total |  | 1664.85
N09275.2 Total |  | -2850
N22982.1 Total |  | 338400
N22982.3 Total |  | -192000
N22982.6 Total |  | -133500
N24195.1 Total |  | -282000
N24653.1 Total |  | 633000
N24653.2 Total |  | 678000
N25017.2 Total |  | 7350
N25817.1 Total |  | 492000
N26342.1 Total |  | -874000
N26342.2 Total |  | -422000
N26342.3 Total |  | -168165
N26904.1 Total |  | -221000
N27611.2 Total |  | -304500
N28285.1 Total |  | -104750
N28611.1 Total |  | 243000
N28621.1 Total |  | 167000
N28665.1 Total |  | -96000
N29400.5 Total |  | 279000
N29400.6 Total |  | 387500
N30078.1 Total |  | -202000
N30757.4 Total |  | -202000
N30757.8 Total |  | -56000
N32070.1 Total |  | -36000
N32070.3 Total |  | -43500
N32429.1 Total |  | 117000
N33262.1 Total |  | -92000
N34650.2 Total |  | -11850
N34659.2 Total |  | -11850
N36041.1 Total |  | -37000
N36141.2 Total |  | 218400
N36159.2 Total |  | -218400
N36169.2 Total |  | -109200
N36647.2 Total |  | -6000.03
N37324.2 Total |  | -163647
N37325.2 Total |  | -163647
N37326.2 Total |  | -166547
N37960.2 Total |  | 144797
N37961.2 Total |  | 146247
N38248.1 Total |  | 107650.9
N39345.2 Total |  | -67925
N40311.2 Total |  | -51475
N40313.2 Total |  | -102950
N40314.2 Total |  | -51475
N40914.2 Total |  | -45496
N41542.2 Total |  | 68500
N42729.1 Total |  | 21072.9
N47001.2 Total |  | 29104
N48356.1 Total |  | -4648
N50438.1 Total |  | 650000
Grand Total |  | 3013048.78
Spreadsheet: 788777d1658730559-leveraging-countif-to-calculate-count-of-non-highlighted-cells-countif-question-1-
Sheet: Sheet1

 |  |  |  |  |  |  | >=3
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 8
 |  |  |  | 4
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 18
 |  |  |  | 2
 |  |  |  | 6
Spreadsheet: 694830d1599829337-count-number-of-x-if-it-appears-in-y-importances-on-rlms
Sheet: Sheet1

List Appearance | Importance | Count
HMNS30280: Children's &amp;Young Peoples MH Full Year | Core Text
MCLT20312: The City and Popular Culture Half Year 1 | Independent Research
LAW_22355: Client Finance Half Year 2 | Core Text
LAW_22348: Public International Law Full Year | Recommended Reading
BIOL33171: Immunology and Virology Full Year | Core Text
LAW_40460: Public Int & Humanitarian Law Flex Prog 1 | Core Text
ARES40150: Equine Health Half Year 1 | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
ULPI10402/10904: ULP Italian stage 4 Full Year | Recommended Reading
CARG30160: Law,Sentencing& the Courts Full Year | Recommended Reading
ULPI10502/602/10905/6: ULP Italian stage 5/6 FullYear | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
LAW_40370: Sport Law & Reg: UK & Int Pers Flex Prog 1 | Recommended Reading
HIST20417: The Eagle &amp; the Snake Half Year 2 | Core Text
CHEM10181\10203: [NAME] to Physical Chemistry | Recommended Reading
THTR10057: Introduction to Theatre Design Full Year | Core Text
RSCH ARES Postgraduate Research Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CIVE20001: Construction Pract &amp; the Env | Core Text
FREN32005: Contemporary France Full Year | Core Text
LAW_40486: Sport, IP Law and Commerce Full Year | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
PRPG30221: L&amp;T:Curriculum&amp;PedagogyL6 Full Year | Core Text
CORP11173: Contemp Organisat'l Design Flex Prog | Core Text
PSYC30835: Psychology of the Paranormal Full Year | Core Text
INTR40145 Gender and Security | Core Text
HIST20517: Age of Reformations Half Year 1 | Core Text
BUSI11020: Fundamentals of Marketing Full Year | Core Text
LAW_40573: Int'l Comm Transactions (Jan) Flex Prog 1 | Core Text
GEOG20041: Principles/Prac in Geography Half Year 1 | Core Text
LAW_40394: World Trade Organisation Flex Prog 1 | Core Text
LAW_36596: International Trade Law (HY2) Half Year 2 | Core Text
Spreadsheet: 55078d1255169346-vlookup-or-if-needed-problem
Sheet: ASSURED

DOG | CAT | [NAME] | RABBIT | VENDOR
5 | 3 | 3 | 0 | STOCK
 |  |  |  | [NAME]
COUNTIF D8:D260 = "Y" AND A8:A260 = "DOG" FIND THE FORMULA
ANIMAL | XXXXX | XXXX | RETURNED
DOG | XXXXX | XXXX | N
DOG | XXXXX | XXXX | Y
CAT | XXXXX | XXXX | N
[NAME] | XXXXX | XXXX | N
[NAME] | XXXXX | XXXX | Y
CAT | XXXXX | XXXX | N
DOG | XXXXX | XXXX | N
CAT | XXXXX | XXXX | N
[NAME] | XXXXX | XXXX | N
DOG | XXXXX | XXXX | Y
DOG | XXXXX | XXXX | N
everytime either of the names dog cat mouse etc has a Y opposite it (D Column) I need the relevent cells (A4 B4 C4 D4) to contain a count of 1.
here is a mock up f the above example
DOG | CAT | [NAME] | RABBIT
5 | 3 | 3 | 0
2 |  | 1
Spreadsheet: cd3025f5-8e10-4f80-b586-8ad258b7ba3e
Sheet: F3

 | 3 |  |  |  |  |  |  |  | Purchased Cost of Nutrient
 | Inputs
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the name of this feed? |  | [NAME] (Good) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feed | Price per Unit | lbs per unit | %DM | CP | TDN |  |  |  | Rate per mile | miles | Units per load |  | Waste (per cent) |  | Price per Unit | Waste (per cent) |  | Price per Unit | Waste (per cent) | Units consumed
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much does this feed cost? | $ | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | The above price is for how many pounds of feed? |  | 2000 | pounds per unit
 |  | What is the percent dry matter? |  | 0.9 |  |  |  |  | Delivered Cost of Nutrient
 |  | What is the percent Crude Protein (on a DM basis) |  | 0.184 |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the percent TDN (on a DM basis) |  | 0.59 |  |  |  |  |  | $ |  | per pound of TDN
 |  | How far will this feed be transported? |  | 80 | miles |  |  |  |  | $ |  | per pound of DM
 |  | What is the cost per loaded mile? | $ | 4.5 | per mile
 |  |  |  |  |  |  |  |  | Fed Cost of Nutrient
 |  |  |  | 20
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | How much of the feed will be lost in hauling? |  | 0.005
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much will it cost to store this feed? | $ | 1
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | How much of the feed will be lost in storage? |  | 0.01
 |  | How much will it cost to feed this feed? | $ | 7 |  |  |  |  | Consumed Cost of Nutrient
 |  | How much will be lost when feeding? |  | 0.1 |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
Spreadsheet: benjamin_rogers__1013__Pro Forma2
Sheet: IS-ENA

Project Income Statement
Project Revenues:
Capacity Charges
Option Revenue
Spot Revenue
Total Project Revenues
Project Operating Expenses:
Fuel Charges
O&M
Other O&M
Total Operating Expenses
Operating Income
Project Interest Expense:
Long Term Debt
LC Charge on DSRF
Interest Income
Total Debt Services
EBDT
Depreciation & Amortization
Earnings Before Taxes
VA Income Taxes
Book Income Taxes
Total Taxes
NET BOOK INCOME
Spreadsheet: geir_solberg__11270__9_22act
Sheet: EPEData

 | 37248.87361111111
 | NEWMAN 1 ,ECON, 36  , 75  , 35  , 83  , 38  ,1
 | NEWMAN 2 ,ECON, 35  , 75  , 34  , 83  , 40  ,1
 | NEWMAN 3 ,UNAV, -0  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,175  ,215  , 86  ,214  , 40  ,1
 | NEWMAN   ,, 243 ,  365,  155, 380 , 118 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 36  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,ECON, 66  ,120  , 56  ,151  , 21  ,1
 | RIOGRANDE,, 103 ,  158,   88, 200 ,  21 ,
 | PALOVERDE,MANL,504  ,504  ,504  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 98  , 98  , 98  ,104  ,  0  ,1
 | LAMBDA, 29.37,  788,  859,  155,    4,   71,17686,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1