tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 803232d1667322802-colour-coding-based-on-grade-and-importance-excel-issue-etaf
Sheet: Sheet1

 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 | Name |  |  |  |  |  | 4
 | Grade | Importance | Supplier Assessment |  |  |  | 5
Criteria
Due Diligence |  |  |  |  |  | Importance | GRADE | Total |  |  | Importance | Grade |  |  | GREEN | orange | red
Test | 3 | 1 |  | green |  | 2 | 1 |  |  |  | 1 | 1
Test | 2 | 2 |  | red |  |  | 2 |  |  |  | 2 | 2
Test | 4 | 1 |  | green |  |  | 3 |  |  |  | 3 | 3
Test | 4 | 4 |  | green |  |  | 4 |  |  |  | 4 | 4
Test | 3 | 2 |  | green |  |  | 5 |  |  |  |  | 5
Test | 4 | 2 |  | green |  | `
Test | 5 | 1 |  | green
 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 4 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
Spreadsheet: 851543d1701759705-if-this-equals-this-then-fill-this-value-excel-post
Sheet: Amenity Block

column 1 | column 2 | row 3
GRADE | QTY
 |  | M10 | M15 | M20 | M25 | M30 | M35 | M40 | M45 | M50 | M55 | M55 SCC
M30 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | look for value in column 1 = m30
M40 | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  | then seach for the same in column 1 =m30 in row 3
M30 | 17.5
M40 | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  | fill corresponding quantity
M30 | 25
M40 | 13.5
M40 | 9
M10 | 5
M40 | 2.5
M30 | 30.5
M30 | 24
M40 | 5
M40 | 10
M30 | 5
M10 | 28
M10 | 26
M10 | 14
M40 | 18
M30 | 21.5
M30 | 3
M40 | 9.5
M10 | 30
M30 | 23.5
M30 | 1
M40 | 7.5
M10 | 21
M10 | 63
M40 | 1.5
M10 | 38.5
M30 | 21
M10 | 24
M10 | 18
Spreadsheet: 713259d1610624908-database-information-to-dashboard-training-matrix-3-
Sheet: Sheet1

 | State TT Attendance per Month for |  |  |  | 2020
 | State | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
 | CA
 | AR
 | [NAME]
 | HE
 | DL
 | MS
 | IL
 | GE
 | VC
 | TX
 | ZA
Spreadsheet: 606136d1547499894-multiple-ifs-with-many-different-criteria-meexcel-question
Sheet: Sheet1

Days | New Hires |  |  | Team | 8 | Days Worked |  |  | Possible Answers
7 | Week 0 | No Expectations |  | ID | Perf% |  |  |  | Out of 90 Days
14 | Week 1 | No Expectations |  | LBRSHALL | 0.8410595815121792 | 1228 |  |  | Above Expectations
21 | Week 2 | No Expectations |  | LBRAMOOR | 0.9409251447423844 | 81 |  |  | At Expectations
28 | Week 3 | No Expectations |  | LBRBDOUG | 0.9128514653839283 | 59 |  |  | Under Expectations
35 | Week 4 | 0.5 |  | [NAME] | 0.8813543441791069 | 59 |  |  | No Expectations
42 | Week 5 | 0.5 |  | LBRRSPEN | 0.5623666156377892 | 47
49 | Week 6 | 0.6 |  | LBRJWILL | 0.40111074278066 | 47
56 | Week 7 | 0.6 |  | LBRJDETJ | 0.6316550004841077 | 38
63 | Week 8 | 0.8 |  | LBRCBATE | 0.5262618544323603 | 25
70 | Week 9 | 0.8 |  | [NAME] | 0.4306660595560396 | 25
77 | Week 10 | 1 |  | LBRATHOM | 0.5659538877784795 | 25
84 | Week 11 | 1 |  | LBRCLEWI | 0.5029369264429011 | 25
91 | Week 12 | 1
Spreadsheet: 8a01b21c-985f-48b2-acb1-772202542148
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
PUPY | Test | PUPY | Purine and Pyrimidine Panel, [NAME] | Purine and Pyrimidine Panel, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: Urine |  |  | 3 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 3 mL Collection Instructions: Collect a random urine specimen. Additional Information: Patient's age is required. Forms: 1.    1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.    2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | URACIL 0-2 years: < or =31 mmol/mol creatinine 3-5 years: < or =30 mmol/mol creatinine 6-11 years: < or =28 mmol/mol creatinine 12-17 years: < or =26 mmol/mol creatinine > or =18 years: < or =35 mmol/mol creatinine  URIC ACID 0-2 years: < or =2,249 mmol/mol creatinine 3-5 years: < or =1,900 mmol/mol creatinine 6-11 years: < or =1,398 mmol/mol creatinine 12-17 years: < or =698 mmol/mol creatinine > or =18 years: < or =669 mmol/mol creatinine  HYPOXANTHINE 0-2 years: <53 mmol/mol creatinine 3-5 years: <49 mmol/mol creatinine 6-11 years: <43 mmol/[NAME] 12-17 years: <36 mmol/mol creatinine > or =18 years: <40 mmol/[NAME]  XANTHINE 0-2 years: <49 mmol/mol creatinine 3-5 years: <41 mmol/mol creatinine 6-11 years: <30 mmol/[NAME] 12-17 years: <16 mmol/mol creatinine > or =18 years: <51 mmol/mol creatinine | Tuesday; 8 a.m. | 7 days | 14 days | 1 | 83789 |  |  |  |  | Rochester
PUPY | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
PUPY | Result | 81420 | Uracil | Uracil | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 25140-5 | Uracil/Creatinine:ScRto:Pt:[NAME]:Qn:
PUPY | Result | 6813 | Uric Acid | Uric Acid | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 34385-5 | Urate/Creatinine:ScRto:Pt:[NAME]:Qn:
PUPY | Result | 6814 | Hypoxanthine | Hypoxanthine | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 38366-1 | Hypoxanthine/Creatinine:ScRto:Pt:[NAME]:Qn:
PUPY | Result | 6815 | Xanthine | Xanthine | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 38371-1 | Xanthine/Creatinine:ScRto:Pt:[NAME]:Qn:
PUPY | Result | 6816 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: 732672d1621144130-splashing-the-numbers-based-on-past-average-country-cost-projection
Sheet: Sheet1

 |  |  |  |  |  | May Cost projection | -5925.0600719151
 |  | Country | Export Boxes Apr | Total Cost Apr (MUSD) | Cost/Box Apr | Export Boxes May | Total Cost May (MUSD) | Cost/Box May
 |  | AE | 27329 | -1195.55932 |  | 25329
 |  | BD | 21190 | -989.15628 |  | 23163
 |  | BH | 27611 | -1013.71795 |  | 22898
 |  | BJ | 2600 | -136.81734 |  | 2436
 |  | GH | 7012 | -624.58122 |  | 8072
 |  | IN | 8943 | -246.66589 |  | 5813
 |  | LK | 30033 | -1140.09605 |  | 21816
 |  | OM | 3363 | -178.8231 |  | 3749
 |  | PK | 1079 | -82.07512 |  | 1032
 |  | QA | 2325 | -145.87179 |  | 3267
 |  | SA | 1451 | -63.13128 |  | 959
 |  | SA | 636 | -48.70572 |  | 488
 |  | SN | 4052 | -246.6625 |  | 3407
Spreadsheet: john_griffith__15679__05_14_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 440 | 30 | 33
N01-P/C | 445 | 62.5 | 64
Q01-P/C | 450 | 83 | 84
U01-P/C | 455 | 102 | 105
V01-P/C | 455 | 116 | 118
X01-P/C | 470 | 136 | 139
[NAME]-P/C | 490 | 153 | 159
F02-P/C | 495 | 171 | 177
G02-P/C | 485 | 176 | 181
H02-P/C | 465 | 161 | 165
J02-P/C | 430 | 121 | 128
K02-P/C | 420 | 113 | 120
M02-P/C | 425 | 115 | 122
U02-P/C | 430
Spreadsheet: 775951d1649410232-returning-a-value-from-a-different-colum-row-than-the-criteria-testing-testing2
Sheet: Sheet1

 | Number | Date | Hours
 | [NAME]
 |  | 2022-04-01 00:00:00
 |  |  | 4
 |  |  | 5
 |  |  | 3
 | E25468
 |  | 2022-04-03 00:00:00
 |  |  | 2
 |  |  | 8
 | E12865
 |  | 2022-04-06 00:00:00
 |  |  | 6
 |  |  | 3
 | E44386
 |  | 2022-04-07 00:00:00
 |  |  | 5
Spreadsheet: kevin_presto__19944__Final Gas Plants to Monitor
Sheet: 2001 Plants

Company | Plant | MW | Unit | Fuel | Mo | Year | City | State | NERC/Reg | Status | Service
Dynegy | Lawrence County | 500 | CC | NG | 3 | 2001 | Lawrence County | KY | ECAR | CON | Merchant
Duke Energy | St. Francis Phase II | 260 | CC | NG | 3 | 2001 | Glennonville | MO | MAIN | PLN
Constellation Power | Big Sandy Peaker Plant | 300 | GT | NG | 5 | 2001 | Wayne County | WV | ECAR | PLN | Merchant
Cinergy | West End Peaking Project | 86 | GT | NG | 6 | 2001 | Cincinnati | OH | ECAR | PLN | Peaking
Dayton Power & Light | [NAME] | 200 | CT | NG | 6 | 2001 | Lancaster, Fairfield County | OH | ECAR | PLN | Merchant
Southern Energy | Zeeland | 300 | CC | NG | 6 | 2001 | Zeeland | MI | ECAR | PLN | Merchant
Dayton Power & Light | [NAME] | 320 | GT | NG | 6 | 2001 | [NAME] (Pickaway Cty) | OH | ECAR | PLN
DPL Energy | Montpelier Gen Station | 400 | CT | NG | 6 | 2001 | [NAME], Wells County | IN | ECAR | PLN | Peaking
FirstEnergy | West Lorain | 425 | CC | NG | 6 | 2001 | [NAME] | OH | ECAR | PLN
Orion Power Holdings | [NAME] | 500 | CT | NG | 6 | 2001 | Ceredo, [NAME] | WV | ECAR | CON | Merchant
Bechtel Power / Parke Energy |  | 500 | CC | NG | 6 | 2001 |  | IN | ECAR | PLN | Merchant
Dearborn Ind. Generation | Rouge Cogen | 550 | CC | NG | 6 | 2001 | Detroit | MI | ECAR | PLN | Cogen
Ameren | Patoka | 135 | CT | NG | 6 | 2001 | [NAME] | IL | MAIN | PLN | Utility
SkyGen (Polsky) | Calumet Energy | 300 | CT | NG | 6 | 2001 | Chicago | IL | MAIN | PLN | Merchant
Power Energy Partners LLC | Crete, Will County | 390 | GT | NG | 6 | 2001 | Crete, Will County | IL | MAIN | PLN
Mid-American | Cordova | 500 | CC | NG | 6 | 2001 | Cordova | IL | MAIN | PLN
Putnam Energy Center (Spark Energy) | Putnam County | 500 | CT | NG | 6 | 2001 | Cloverdale, Putnam County | IL | MAIN | PLN | Peaking
Ameren | Grand Tower Station | 528 | CT | NG | 6 | 2001 |  | IL | MAIN | CON | Peaking Utility
Great River Energy (NRG/Tenaska) | [NAME] Junction | 486 | CT | NG | 5 | 2001 | Trimont | MN | MAPP
Great River Energy | Pleasant [NAME] phase 2 | 434 | CT | NG | 6 | 2001 | Elk River | MN | MAPP
Minnesota Power | [NAME] | 24 | CT | NG | 6 | 2001 | Cloquet | MN | MAPP
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: Conditional Markers

 | 1 | 2 | 3 | 4 | 5 |  | F9 to randomize values
target | 70 | 70 | 70 | 70 | 70
series 1
test1
Spreadsheet: 538419d1505595528-categorizing-named-ranges-testfunction
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | test1 |  |  |  | test2
 |  |  |  |  |  |  |  |  |  | NAME | CODE | PRICE |  | NAME | CODE | PRICE
 |  |  |  |  |  |  |  |  |  | ONE | 1 | 2 |  | SIX | 6 | 7
 |  |  |  |  |  |  |  |  |  | TWO | 2 | 3 |  | SEVEN | 7 | 8
 |  |  |  |  |  |  |  |  |  | THREE | 3 | 4 |  | EIGHT | 8 | 9
 |  |  |  |  |  |  |  |  |  | FOUR | 4 | 5 |  | NINE | 9 | 10
 |  |  |  |  |  |  |  |  |  | FIVE | 5 | 6 |  | TEN | 10 | 11
 |  |  | I want the function in cell D4, to search through both test1 and test2 (in first column, then return price)
 |  | DROPDOWN MENUS |  |  | one
 |  | Option3 | NINE |  |  | (the reason for the long formula, is that if you leave the second column blank, I want it to search the arrays for the other column (i.e. option1, 2 or 3… (it obviously wont work on this at the moment because it is test data))
 |  |  |  |  |  |  |  |  |  | Option1 | ONE
 |  |  |  |  | Option1 |  |  |  |  |  | TWO
 |  |  |  |  | Option2 |  |  |  |  |  | THREE
 |  |  |  |  | Option3 |  |  |  |  | Option2 | FOUR
 |  |  |  |  |  |  |  |  |  |  | FIVE
 |  |  |  |  |  |  |  |  |  |  | SIX
 |  |  |  |  |  |  |  |  |  | Option3 | SEVEN
 |  |  |  |  |  |  |  |  |  |  | EIGHT
 |  |  |  |  |  | (this is data for dropdown menus) |  |  |  |  | NINE
 |  |  |  |  |  |  |  |  |  |  | TEN
Spreadsheet: 128716d1321230114-vlookup-in-different-coumns-hooves-world-racing-syndicate-1
Sheet: Data

Helper | GROUP | POS | SCORE
 | C | 1 | 80
 | C | 2 | 60
 | C | 3 | 40
 | 1 | 1 | 60
 | 1 | 2 | 40
 | 1 | 3 | 20
 | 2 | 1 | 40
 | 2 | 2 | 20
 | 2 | 3 | 10
 | 3 | 1 | 20
 | 3 | 2 | 10
 | 3 | 3 | 5
GROUP | POS | SCORE | Helper
C | 1 | 80
C | 2 | 60
C | 3 | 40
1 | 1 | 60
1 | 2 | 40
1 | 3 | 20
2 | 1 | 40
2 | 2 | 20
2 | 3 | 10
3 | 1 | 20
3 | 2 | 10
3 | 3 | 5
Spreadsheet: 167506d1342014490-matching-entries-in-different-columns-ef117_test-worksheet
Sheet: Sheet1

 |  |  |  |  |  | seq | match_name | calc
will | 0.76 |  | ball | 0.34 |  | 1 | will | 6.333333333333334
all | 0.54 |  | keen | 0.23 |  |  | keen | 0.5217391304347826
keen | 0.12 |  | cool | 0.99 |  | 2 | cool | 1.212121212121212
done | 1.3 |  | will | 0.12
aspect | 2.4 |  | cool | 0.34
cool | 1.2 |  | keep | 0.12 |  | 3
Spreadsheet: 843806d1695652634-turning-fractions-in-to-decimals-odds-difference
Sheet: Sheet1

Fixture | Home Odds | Away Odds | Difference
[NAME] Palace 4/9 16/5 5/1 | 0.44 | 5 | 4.56
Bournemouth - Stoke 3/5 14/5 15/4 | 0.6 | 3.75 | 3.15
York City - Barnet 13/5 13/5 17/20 | 2.6 | 0.85 | -1.75
Burton - Everton U21 10/11 5/2 5/2 | 0.9 | 2.5 | 1.6
Port Vale - Sutton 4/6 11/4 10/3 | 0.66 | 3.33 | 2.67
Spreadsheet: 233318fe-31fd-48c7-b320-7711e2c297e4
Sheet: Sheet1

SUMMARY BY COUNTIES- REPUBLICAN-Vice President | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Write-in Votes | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
2008-01-08 00:00:00 | [NAME], r | Howard, r | Huck-   abee, r | [NAME], r | Keyes, r | Marchuk, r | [NAME], r | [NAME], r | Romney, r | Tancredo, r | Thompson, r
Belknap County | 187 | 0 | 207 | 53 | 28 | 1 | 276 | 97 | 164 | 5 | 104
Carroll County | 125 | 0 | 146 | 44 | 27 | 0 | 208 | 88 | 103 | 6 | 104
Cheshire County | 141 | 0 | 205 | 52 | 18 | 0 | 223 | 117 | 120 | 16 | 61
Coos County | 69 | 0 | 83 | 13 | 8 | 1 | 102 | 45 | 51 | 1 | 39
Grafton County | 160 | 2 | 213 | 26 | 35 | 1 | 262 | 128 | 114 | 9 | 110
Hillsborough County | 1018 | 1 | 943 | 309 | 115 | 10 | 1220 | 610 | 758 | 48 | 422
Merrimack County | 344 | 0 | 382 | 80 | 42 | 0 | 478 | 228 | 274 | 19 | 130
Rockingham County | 844 | 12 | 670 | 229 | 69 | 0 | 1086 | 404 | 559 | 33 | 365
Strafford County | 176 | 0 | 246 | 62 | 29 | 0 | 306 | 142 | 173 | 7 | 101
Sullivan County | 100 | 0 | 132 | 33 | 14 | 0 | 144 | 79 | 80 | 3 | 60
Total | 3164 | 15 | 3227 | 901 | 385 | 13 | 4305 | 1938 | 2396 | 147 | 1496
Candidates receiving 10 votes or less statewide: Cort, r, 5: O'Connor, r, 2: Shepard, r, 4: Supreme, r, 9:
Bryk, d, 9: Stebbins, d, 7: [NAME], d, 5: Gravel, d, 8: [NAME], d, 1: Savior, d, 1; [NAME], d, 6
2008-01-08 00:00:00 | Wuensche, r | Biden, d | [NAME], d | Edwards, d | [NAME], d | [NAME], d | Obama, d | [NAME], d | [NAME] | [NAME] | Other
Belknap County | 0 | 4 | 19 | 36 | 6 | 3 | 34 | 21 | 0 | 31 | 142
Carroll County | 0 | 2 | 10 | 22 | 0 | 1 | 19 | 9 | 0 | 25 | 138
Cheshire County | 0 | 2 | 11 | 41 | 7 | 7 | 32 | 13 | 1 | 38 | 156
Coos County | 0 | 0 | 20 | 12 | 0 | 1 | 20 | 4 | 1 | 8 | 65
Grafton County | 0 | 3 | 17 | 34 | 0 | 5 | 51 | 20 | 2 | 32 | 251
Hillsborough County | 16 | 0 | 92 | 132 | 11 | 12 | 119 | 53 | 11 | 100 | 1591
Merrimack County | 0 | 5 | 61 | 84 | 3 | 6 | 59 | 23 | 9 | 79 | 417
Rockingham County | 0 | 8 | 47 | 84 | 0 | 6 | 86 | 20 | 8 | 151 | 874
Strafford County | 0 | 3 | 25 | 36 | 0 | 1 | 26 | 6 | 2 | 48 | 268
Sullivan County | 0 | 1 | 22 | 34 | 0 | 4 | 28 | 9 | 0 | 16 | 80
Total | 16 | 28 | 324 | 515 | 27 | 46 | 474 | 178 | 34 | 528 | 3982
Spreadsheet: 204056d1357329054-data-entry-using-excel-2010-denkai-animal-subsidized-vet-clinic-pack-solution
Sheet: Service and Cost

Antibiotics | 10
Bloodwork | 75
[NAME] | 15
Cat neuter | 25
Cat neuter special | 15
Cat spay | 40
Cat spay special | 30
Check-up | 20
Cryptorchids | 25
[NAME] | 15
Dental care-cleaning | 75
Dental care-extraction, 1 | 10
Dental care-extraction, 2 | 20
Dental care-extraction, 3 | 30
Dental care-extraction, 4 | 40
Dental care-extraction, 5 | 50
Dental care-root, 1 | 100
Dental care-root, 2 | 150
Dog neuter special | 30
Dog neuter, < 65lbs | 55
Dog neuter, > 65lbs | 70
Dog spay special | 30
Dog spay, < 65lbs | 60
Dog spay, > 65lbs | 80
Ear Mite Treatment, Ivermectin-Cat | 5
E-Collar | 5
Eye Medication, Triple Antibiotic | 5
FIV/FELV Test | 23
FVRCP | 15
[NAME], level 1 | 25
[NAME], level 2 | 45
Heartworm Test | 23
Leukemia Vaccine | 15
Microchip & Registration | 25
Nail trim | 5
Other | TBD
Pain Medication | 5
Rabies , 1 year | 15
Rabies, 3 year | 25
Roundworm Treatment | 5
Tapeworm Treatment, Droncit-Cat, 1 | 5
Tapeworm Treatment, Droncit-Cat, 2 | 10
Tapeworm Treatment, Droncit-Dog, 1 | 3
Tapeworm Treatment, Droncit-Dog, 2 | 6
Tapeworm Treatment, Droncit-Dog, 3 | 9
Tapeworm Treatment, Droncit-Dog, 4 | 12
Tapeworm Treatment, Droncit-Dog, 5 | 15
Umbilical hernia | 20
Spreadsheet: 78868d1279155312-excel-2007-return-unique-values-in-drop-down-list-book1
Sheet: Sheet1

january
february
march
april
may
june
february
march
april
may
Spreadsheet: 814618d1674508802-advanced-multi-level-parent-summation-bom-type-book5-lucyl-
Sheet: Sheet1

Level | Child Values A | Multiplier | Parent / Total SUMS (manually calculated) | [NAME]
0
1 |  | 1
2 | 25 | 2 | 50
2 |  | 1
3 |  | 1
4 |  | 5
5 | 18 | 1 | 18
1 |  | 2
2 | 27 | 1 | 27
2 |  | 1
3 | 30 | 1 | 30
3 | 30 | 1 | 30
0 |  | 1
1 | 26 | 2
1 | 15 | 1
2 |  | 1
2 |  | 1
2 |  | 1
1 | 16 | 2
1 |  | 1
2 | 89 | 2
2 | 1 | 2
2 | 1 | 2
End
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - OB1-11 CENTRAL SUPPLY

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
OB1-11 CENTRAL SUPPLY
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X |  |  | X |  | X
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
UAH CHANGE OVER BUNDLE |  |  |  | CP0041 |  | 90
10-PILLOW CASE |  |  |  | GL0015 |  | 40
UPDATED:
June 17th 2009
Spreadsheet: 33e0b8ef-83e1-40d9-9a01-1bdc1fce8eea
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-08-12 10:45:53.130000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.71 | 101.585 | 101.46 | 101.085
4.25 | 100.733 | 100.608 | 100.483 | 100.108 |  | Note: | Refer To Price [NAME]
4.125 | 99.484 | 99.359 | 99.234 | 98.859 |  |  | For all Price Adjs
4 | 98.992 | 98.867 | 98.742
 |  |  |  |  |  | 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
3.75 | 101.395 | 101.27 | 101.145 | 100.77
3.625 | 100.808 | 100.683 | 100.558 | 100.183
3.5 | 100.462 | 100.337 | 100.212 | 99.837
3.375 | 100.069 | 99.944 | 99.819 | 99.444
3.25 | 99.515 | 99.39 | 99.265
 |  |  |  |  |  | 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-26 10:45:53.130000
30 DAY | 2011-09-10 10:45:53.130000
45 DAY | 2011-09-25 10:45:53.130000
60 DAY | 2011-10-10 10:45:53.130000
90 DAY | 2011-11-09 10:45:53.130000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 268228d1380520525-ter-calculations-ter
Sheet: Sheet1

ASSOCIATE NAME
 |  |  |  | Car [NAME] | : Rs 12.00/Km
ASSOCIATE CODE
 |  |  |  | 2 Wheeler | : Rs 6.00 /Km
DATE OF CLAIM
CLAIM PERIOD |  | 2013-14
Towards actual Business / Misc expenses as per the details given here under.
DATE | MODE | FROM | TO | PURPOSE | TOTAL KM | AMOUNT
 | Car |  |  |  | 10
Spreadsheet: 75051d1275573783-conditional-equations-example-9
Sheet: FINAL FORMULA

 |  | CUSTOMER | CORIN BROOM | Amount: |  | 5 | lbs
 |  | CODE
 |  | [NAME] | Blue
 |  | DATE ISSUED
 |  |  |  |  | Mix 1 |  | Mix 2 |  | Mix 3
 | COMPONENTS |  |  | % | lbs | grams | lbs | grams | lbs | grams
 | 1 | B500192 | 20 MI RESIN | 76.5 | 3.825 |  | 0.19125 |  | 0.19125
 | 2 | B800103 | B900 Antioxidant | 0.2 | 0.01
 | 3 | B800507 | CaCO3 FT | 21.8 | 1.09
 | 4 | B800702 | [NAME] | 1.5 | 0.075
 | 5 | X
 | 6 | X
 | 7 | X
 | 8 | X
 | 9 | X
 | 10 | X
 | 11 | X
 | 12 | X
 | 13 | X
 | 14 | X
 | 15 | X
 | 16 | X
 | 17 | X
 | 18 | X
 |  |  | Total | 100
 |  | INSTRUCTIONS
 |  | APPLICATION= | Injection | 0
 |  | LDR= | AS REQUEST | 0
 |  | LRN = | 03-226
 |  | DATE LTB/LTF ISSUED=
 |  | COMPLETED BY=
 |  | MATCHED TO= | LTF 62018
Spreadsheet: 79398d1279661349-compare-data-and-sum-sample1
Sheet: After

 |  |  |  |  |  |  |  |  | score | Team A | Team B | Team C | Team D | Team E | Team F
 |  |  |  |  |  |  |  |  | 3 | [NAME] | Micheal Daly 37 | [NAME] 44 | Donnacha Padries 39 | [NAME] 38 | [NAME] 75
 |  |  |  |  |  |  |  |  | 5 | Paddy Reading 32 | [NAME] 41 | [NAME] 36 | [NAME] 46 | [NAME] 52 | [NAME]
 |  | Team Home | score | score | Team Away |  |  |  | 0 | [NAME] 53 | [NAME] 32 | [NAME] 68 | [NAME] 62 | [NAME] grelly 72 | [NAME]
 |  |  |  |  |  |  |  |  | 2 | [NAME] 37 | [NAME] 50 | [NAME] 50 | [NAME] 53 | [NAME] 42 | [NAME] 27
 |  | Team A | 10 | 16 | Team D |  |  |  | 3 | [NAME] 62 | [NAME] | [NAME] 71 | Justin Sweeney 78 | [NAME] 59 | [NAME] 42
 |  |  |  |  |  |  |  |  | 1 | [NAME] 85 | [NAME] 52 | [NAME] 43 | [NAME] 37 | [NAME] 68 | [NAME] 57
 |  |  |  |  |  |  |  |  | 0 | [NAME] 47 | [NAME] 78 | [NAME] 57 | Davy Lannigan 56 | [NAME] 89 | [NAME] 47
 |  |  |  |  |  |  |  |  | 0 | [NAME] | [NAME] 90 | [NAME] 11 | [NAME] 77 | [NAME] | Martin Downes 65
 |  |  |  |  |  |  |  |  | 2 | [NAME] 62 | [NAME] 35 | [NAME] 23 | [NAME] | [NAME] 61 | [NAME] 38
 |  |  |  |  |  |  |  |  | 1 | [NAME] 78 | [NAME] 39 | [NAME] 40 | [NAME] 14 | [NAME] 32 | [NAME] 37
 |  |  |  |  |  |  |  |  | 2 | [NAME] 81 | [NAME] 54 | [NAME] 68 | [NAME] 24 | [NAME] 27 | [NAME] 53
 |  |  |  |  |  |  |  |  | 5 | [NAME] 42 | [NAME] 48 | [NAME] 67 | [NAME] 67 | [NAME] 70 | [NAME] 78
 |  |  |  |  |  |  |  |  | 0 | [NAME] 16 | Sest Tyning 22 | [NAME] 81 | [NAME] 73 | [NAME] 38 | [NAME] 40
 |  |  |  |  |  |  |  |  | 1 | [NAME] 27 | [NAME] 25 | [NAME] 76 | Paddy Doran 50 | [NAME] 68 | [NAME] 82
 |  |  |  |  |  | after button press |  |  | 1 | [NAME] 60 | [NAME] | [NAME] 19 | [NAME] 51 | [NAME] mackey 46 | [NAME] 20
 |  |  |  |  |  | This shows the result of sheet "before" names in red font are updated and are the names that were greater than there opposite col names and d7,e7 are sum of this.when result is finished I want to reset d7,e7 to 0 and pick two different teams too compare and score