tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 704064d1605337232-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-example1942
Sheet: Summary

Criteria1 | Criteria2 | Sum |  |  | Criteria1 | Criteria2 | Criteria3 | Sum |  | Criteria1 | Sum
Date | Name | Amount |  |  | from Month | to Month | Name | Amount |  | Name | Amount
2020-01-01 00:00:00 | ASD |  |  |  | Jan-2020 | Mar-2020 | ASD |  |  | ASD |  |  |  | Jan
2020-01-02 00:00:00 | BCD |  |  |  | Jan-2020 | June-2020 | BCD |  |  | BCD |  |  |  | Feb
2020-02-04 00:00:00 | ASD |  |  |  | Apr-2020 | June-2020 | ASD |  |  | ABV |  |  |  | Mar
2020-03-04 00:00:00 | ABV |  |  |  | Jan-2020 | Mar-2020 | ABV |  |  | ABC |  |  |  | Apr
2020-04-01 00:00:00 | ABC |  |  |  | Jan-2020 | June-2020 | ABC |  |  | FGH |  |  |  | May
2020-05-05 00:00:00 | ABV |  |  |  | Apr-2020 | June-2020 | ABV |  |  |  |  |  |  | June
2020-06-06 00:00:00 | FGH |  |  |  | Jan-2020 | June-2020 | FGH
Spreadsheet: 214679d1361048225-transpose-data-help-creating-dummy-variables-or-transposing-missing-parameters-as-zero-plfadata
Sheet: Sheet1

 |  |  |  | FAME_ID
 |  |  |  | 2OH-c14:0
 |  |  |  | 3OH-c12:0 |  | BL025
 |  |  |  | 3OH-c14:0 |  | BL026
 |  |  |  | a15:0 |  | BL027
 |  |  |  | c12:0 |  | BL028
 |  |  |  | c14:0 |  | BL029
 |  |  |  | c15:0 |  | BL030
 |  |  |  | c16:0 |  | BL031
 |  |  |  | c16:1w9c |  | BL032
 |  |  |  | c17:0 |  | BL033
 |  |  |  | c17:1 |  | BL034
 |  |  |  | c18:0 |  | BL035
 |  |  |  | c18:1w7c/n9t |  | BL036
 |  |  |  | c18:1w9c |  | BL037
 |  |  |  | c18:2n9/3n3/2n6t |  | BL038
 |  |  |  | c18:3n6 |  | [NAME]
 |  |  |  | c20:1n9/3n3 |  | BL040
 |  |  |  | c20:4w6 |  | [NAME]
 |  |  |  | cy19:0 |  | BL042
 |  |  |  | cyc17:0 |  | BL043
 |  |  |  | i15:0 |  | BL044
 |  |  |  | i16:0 |  | BL045
 |  |  |  | i17:0 |  | BL046
 |  |  |  | UFA01 |  | [NAME]
 |  |  |  | UFA02 |  | BL048
 |  |  |  | UFA03 |  | BR049
 |  |  |  | UFA04 |  | [NAME]
 |  |  |  | UFA05 |  | BR051
 |  |  |  | UFA06 |  | BR052
 |  |  |  | UFA07 |  | BR053
 |  |  |  | UFA08 |  | BR054
 |  |  |  | UFA09 |  | BR055
 |  |  |  | UFA10 |  | [NAME]
 |  |  |  | UFA11 |  | BR057
 |  |  |  | UFA12 |  | BR058
 |  |  |  | UFA13 |  | BR059
 |  |  |  | UFA14 |  | BR060
 |  |  |  | UFA15 |  | BR061
 |  |  |  | UFA16 |  | BR062
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | BR065
 |  |  |  |  |  | BR066
 |  |  |  |  |  | BR067
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | BR069
 |  |  |  |  |  | BR070
 |  |  |  |  |  | BR071
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH001
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH003
 |  |  |  |  |  | LH004
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH006
 |  |  |  |  |  | LH007
 |  |  |  |  |  | LH008
 |  |  |  |  |  | LH009
 |  |  |  |  |  | LH010
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH012
 |  |  |  |  |  | LH013
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH017
 |  |  |  |  |  | LH018
 |  |  |  |  |  | LH019
 |  |  |  |  |  | LH020
 |  |  |  |  |  | LH021
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | LH023
 |  |  |  |  |  | [NAME]
Spreadsheet: michelle_lokay__26787__Jan02pymts
Sheet: Janinv

[NAME]
January transportation
Outstanding shipper invoices
[NAME] |  |  |  |  | Total Amt
ASTRA POWER |  |  |  |  | 56653.46
BASS ENTERPRISES PRODUCTION COMPANY |  |  |  |  | 6975
BP ENERGY CO |  |  |  |  | 1228366.24
CMS MKTG, SERVICES & TRADING CO |  |  |  |  | 349.44
CONOCO, INC. |  |  |  |  | 219.7
CORAL ENERGY RESOURCES, L.P. |  |  |  |  | 1625
DUKE ENERGY TRADING AND MARKETING,L |  |  |  |  | 500988.17
KN PROCESSING, INC. |  |  |  |  | 20150
MERCADO GAS SERVICES INC |  |  |  |  | 1490.07
NEW MEXICO NATURAL GAS INC |  |  |  |  | 889.05
PACIFIC GAS AND ELECTRIC COMPANY |  |  |  |  | 115920.73
PHILLIPS PETROLEUM COMPANY |  |  |  |  | 32550
RICHARDSON PRODUCTS COMPANY |  |  |  |  | 115363.36
SEMPRA ENERGY SOLUTIONS, LLC |  |  |  |  | 2039.45
North Start Steele |  |  |  |  | 31122.43
SID RICHARDSON GASOLINE CO. |  |  |  |  | 488.5
SOUTHERN CALIFORNIA GAS COMPANY |  |  |  |  | 53130.73 | rate dispute
STATE OF TEXAS |  |  |  |  | 730.78
TENASKA MARKETING VENTURES |  |  |  |  | 53080
TEXACO NATURAL GAS, INC. |  |  |  |  | 265458.65
TXU ENERGY TRADING COMPANY |  |  |  |  | 128810.75
VIRGINIA POWER ENERGY MARKETING |  |  |  |  | 9281.31
WASATCH ENERGY LLC |  |  |  |  | 1743.59
WILLIAMS ENERGY MARKETING & TRADING |  |  |  |  | 185934.07
WTG GAS MARKETING, INC. |  |  |  |  | 7030.88
Total unpaid
Total invoiced(including PGE prepayment collected 1/26/02) |  |  |  |  | 12603726.95
Total paid
Percentage paid
Spreadsheet: 833682d1687194564-conditional-formatting-of-multiple-conditions-based-on-a-date-in-another-cell-master-project-template-for-help-2-solution-unprotected
Sheet: Heather

 | Architect & Project Manager | Heather
 | Projects Assigned
 | Calder
Feasibility
Schematic Design
Preliminary | update client Monday
NCC Preliminary
Preliminary Engineering
Final
NCC Final
Changes After Final
Permit
Under Construction
UC Revisions
Marketing
On Hold
Consulting
[NAME]
Complete
Reuse/Plan Order
Spreadsheet: larry_may__21650__Balance Sheet0721
Sheet: Sheet2

Alabama | Alabama | Alabama | Alabama | Alabama
Arizona | Arizona | Arizona | Arizona | Arizona
Arkansas | Arkansas | Arkansas | Arkansas | Arkansas
California | California | California | California | California
Colorado | Colorado | Colorado | Colorado | Colorado
Connecticut | Connecticut | Connecticut | Connecticut | Connecticut
D.C. | D.C. | D.C. | D.C. | D.C.
Delaware | Delaware | Delaware | Delaware | Delaware
Florida | Florida | Florida | Florida | Florida
Georgia | Georgia | Georgia | Georgia | Georgia
Idaho | Idaho | Idaho | Idaho | Idaho
Illinois | Illinois | Illinois | Illinois | Illinois
Indiana | Indiana | Indiana | Indiana | Indiana
Iowa | Iowa | Iowa | Iowa | Iowa
Kansas | Kansas | Kansas | Kansas | Kansas
Kentucky | Kentucky | Kentucky | Kentucky | Kentucky
Louisiana | Louisiana | Louisiana | Louisiana | Louisiana
Maine | Maine | Maine | Maine | Maine
Maryland | Maryland | Maryland | Maryland | Maryland
Massachusetts | Massachusetts | Massachusetts | Massachusetts | Massachusetts
Michigan | Michigan | Michigan | Michigan | Michigan
Minnesota | Minnesota | Minnesota | Minnesota | Minnesota
Mississippi | Mississippi | Mississippi | Mississippi | Mississippi
Missouri | Missouri | Missouri | Missouri | Missouri
Montana | Montana | Montana | Montana | Montana
Nebraska | Nebraska | Nebraska | Nebraska | Nebraska
Nevada | Nevada | Nevada | Nevada | Nevada
New Hampshire | New Hampshire | New Hampshire | New Hampshire | New Hampshire
New Jersy | New Jersy | New Jersy | New Jersy | New Jersy
New Mexico | New Mexico | New Mexico | New Mexico | New Mexico
New York | New York | New York | New York | New York
North Carolina | North Carolina | North Carolina | North Carolina | North Carolina
North Dakota | North Dakota | North Dakota | North Dakota | North Dakota
Ohio | Ohio | Ohio | Ohio | Ohio
Oklahoma | Oklahoma | Oklahoma | Oklahoma | Oklahoma
Oregon | Oregon | Oregon | Oregon | Oregon
Pennsylvania | Pennsylvania | Pennsylvania | Pennsylvania | Pennsylvania
Rhode Island | Rhode Island | Rhode Island | Rhode Island | Rhode Island
South Carolina | South Carolina | South Carolina | South Carolina | South Carolina
South Dakota | South Dakota | South Dakota | South Dakota | South Dakota
Tennessee | Tennessee | Tennessee | Tennessee | Tennessee
Texas | Texas | Texas | Texas | Texas
Utah | Utah | Utah | Utah | Utah
Vermont | Vermont | Vermont | Vermont | Vermont
Virginia | Virginia | Virginia | Virginia | Virginia
Washington | Washington | Washington | Washington | Washington
West Virginia | West Virginia | West Virginia | West Virginia | West Virginia
Wisconsin | Wisconsin | Wisconsin | Wisconsin | Wisconsin
Wyoming | Wyoming | Wyoming | Wyoming | Wyoming
 |  |  |  | Canada
Spreadsheet: 156803d1337472998-auto-update-for-monthly-balance-countif-for-andyl3
Sheet: Feb

Feb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | P | H
 | 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 |  |  |  |  |  |  | Need formulas to "Auto update from Jan"
[NAME] | E | H | P | H | E | P | P | P | P | H | E | E | E | P | P | P | E | E | E | E | P | P | H | H | E | E | E | P |  |  |  |  |  |  | [NAME] to update balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formulas to "Auto update from Jan"
[NAME] | P | P | P | P | P | H | H | H | E | E | H | H | H | P | P | P | E | E | E | E | H | H | E | E | E | E | E | H |  |  |  |  |  |  | [NAME] to update balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formulas to "Auto update from Jan"
[NAME] | E | E | E | E | H | H | H | H | H | H | P | P | P | P | H | H | H | H | E | E | E | E | H | H | P | P | P | P |  |  |  |  |  |  | [NAME] to update balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | P | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 40 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 29 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 40 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 32 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 46 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 38 | 28
Spreadsheet: 794014d1661853014-modelling-working-capital-monthly-model-working-capital
Sheet: Sheet 1

 |  | WORKING CAPITAL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
1 |  | REVENUE
 |  | Total
 |  | Revenue 1 |  | 1000
 |  | Revenue 2 |  | 2000
 |  | Revenue 3 |  | 3000
 |  | Revenue 4 |  | 4000
 |  | Revenue 5 |  | 5000
 |  | % Payment per Period |  | 0.6 | 0.25 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | CASH PAYMENTS
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | 2 | 17500
 |  | 3 | 20000
 |  | 4 | 22500
 |  | 5 | 25000
 |  | 6 | 27500
 |  | 7 | 30000
 |  | 8 | 32500
 |  | 9 | 35000
 |  | 10 | 37500
 |  | 11 | 40000
 |  | 12 | 42500
Spreadsheet: 59c05b10-333a-42bb-8930-5925ea8f72d3
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
44329167 | 2014-12-06 16:58:30 | ALLIES | 0 | 4 | 6 | 1388575 | Shocking Blue | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44329453 | 2014-12-06 17:12:42 | AXIS | 1 | 6 | 2 | 1388575 | Shocking Blue | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44370586 | 2014-12-09 12:48:59 | ALLIES | 1 | 6 | 5 | 417473 | aikobo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44370731 | 2014-12-09 13:04:25 | AXIS | 0 | 3 | 6 | 417473 | aikobo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44482881 | 2014-12-17 14:57:12 | ALLIES | 1 | 6 | 1 | 55639 | Gigimat | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44483063 | 2014-12-17 15:14:48 | AXIS | 1 | 6 | 5 | 55639 | Gigimat | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44483515 | 2014-12-17 16:06:55 | ALLIES | 0 | 1 | 6 | 1616413 | célestin poux | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44483657 | 2014-12-17 16:26:52 | AXIS | 1 | 6 | 2 | 1616413 | célestin poux | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44497453 | 2014-12-18 17:47:03 | ALLIES | 1 | 6 | 1 | 1523772 | rice dolar | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: AA Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 31-01-2019 | pdf |  | 01-01) 30-01-2019 | pdf |  | 01-01) 30-01-2019 | pdf |  | 01-01) 30-01-2019 | pdf |  | 01-01) 30-01-2019 | pdf
 | 03-01) 28-03-2019 | pdf |  | 03-01) 27-03-2019 | pdf |  | 03-01) 27-03-2019 | pdf |  | 01-01) 28-01-2020 | pdf |  | 03-01) 27-03-2019 | pdf
 | 04-01) 01-04-2019 | pdf |  | 04-01) 01-04-2019 | pdf |  | 06-01) 26-06-2019 | pdf |  |  |  |  | 07-01) 18-07-2019 | pdf
 | 05-01) 15-05-2019 | pdf |  | 04-01) 09-04-2019 | pdf |  | 08-01) 21-08-2019 | pdf |  |  |  |  | 10-01) 17-10-2019 | pdf
 | 06-01) 27-06-2019 | pdf |  | 05-01) 13-05-2019 | pdf |  | 10-01) 16-10-2019 | pdf |  |  |  |  | 01-01) 30-01-2020 | pdf
 | 07-01) 18-07-2019 | pdf |  | 07-01) 17-07-2019 | pdf |  | 01-01) 29-01-2020 | pdf
 | 10-01) 17-10-2019 | pdf |  | 10-01) 16-10-2019 | pdf |  | 03-01) 25-03-2020 | pdf
 | 12-01) 19-12-2019 | pdf |  | 12-01) 18-12-2019 | pdf
 | 01-01) 30-01-2020 | pdf |  | 01-01) 16-01-2020 | pdf
 | 03-01) 26-03-2020 | pdf |  | 01-02) 29-01-2020 | pdf
 | 03-02) 29-03-2020 | pdf |  | 03-01) 25-03-2020 | pdf
 | 04-01) 30-04-2020 | pdf
Spreadsheet: 231b50f5-c17c-462d-8614-2037fd49cd24
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: |  |  | 2014-01-29 09:18:48.160000
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 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.734 | 102.609 | 102.484 | 102.109
4.625 | 102.504 | 102.379 | 102.254 | 101.879 |  | Note: | Refer To Price [NAME]
4.5 | 101.603 | 101.478 | 101.353 | 100.978 |  |  | For all Price Adjs
4.375 | 100.661 | 100.536 | 100.411 | 99.786
4.25 | 100.005 | 99.88 | 99.755 | 99.13
4.125 | 99.206 | 99.081 | 98.956 | 98.331
4 | 98.221 | 98.096 | 97.971 | 97.346
3.875 | 97.19 | 97.065 | 96.94 | 96.315 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.692 | 102.567 | 102.442 | 102.067
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 101.725 | 101.6 | 101.475 | 101.1
3.5 | 101.151 | 101.026 | 100.901 | 100.276
3.375 | 100.398 | 100.273 | 100.148 | 99.523
3.25 | 99.596 | 99.471 | 99.346 | 98.721 |  | 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 | 2014-02-12 09:18:48.160000
30 DAY | 2014-02-27 09:18:48.160000
45 DAY | 2014-03-14 09:18:48.160000
60 DAY | 2014-03-29 09:18:48.160000
90 DAY | 2014-04-28 09:18:48.160000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 150872d1334705096-excel-2007-index-match-or-multi-vlookup-multilookup
Sheet: TableOfVals

 | Column
ID
123456 | 2 | 4 | 2 | 0 | 0 | 2 | 3 | 3 | 3 | 4 | 1 | 1 | 1 | 3 | 0 | 0 | 0
123457 | 1 | 3 | 1 | 1 | 1 | 3 | 0 | 2 | 0 | 1 | 2 | 0 | 0 | 2 | 3 | 2 | 0
123458 | 4 | 2 | 2 | 1 | 0 | 2 | 3 | 1 | 4 | 3 | 1 | 4 | 4 | 1 | 0 | 1 | 0
123459 | 1 | 2 | 3 | 2 | 2 | 0 | 1 | 0 | 1 | 2 | 2 | 3 | 0 | 0 | 1 | 0 | 0
123460 | 4 | 3 | 2 | 3 | 0 | 4 | 0 | 3 | 0 | 4 | 4 | 2 | 1 | 1 | 4 | 2 | 1
123461 | 0 | 1 | 0 | 3 | 0 | 0 | 4 | 1 | 2 | 2 | 1 | 4 | 4 | 2 | 0 | 1 | 4
123462 | 4 | 2 | 1 | 4 | 4 | 1 | 0 | 2 | 1 | 4 | 1 | 1 | 3 | 0 | 3 | 2 | 3
123463 | 0 | 2 | 4 | 4 | 1 | 4 | 1 | 0 | 4 | 2 | 4 | 2 | 0 | 2 | 2 | 0 | 1
123464 | 3 | 0 | 3 | 0 | 2 | 2 | 1 | 0 | 2 | 0 | 3 | 2 | 3 | 4 | 0 | 1 | 1
123456 | 4 | 4 | 4 | 1 | 1 | 1 | 4 | 4 | 3 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2
123464 | 0 | 4 | 0 | 3 | 1 | 4 | 2 | 1 | 1 | 4 | 1 | 3 | 1 | 1 | 2 | 4 | 2
123464 | 2 | 0 | 1 | 4 | 2 | 3 | 4 | 3 | 4 | 3 | 2 | 3 | 0 | 0 | 0 | 0 | 0
123456 | 1 | 4 | 1 | 0 | 0 | 4 | 3 | 4 | 1 | 2 | 3 | 1 | 1 | 1 | 2 | 4 | 1
123464 | 1 | 4 | 1 | 0 | 3 | 2 | 2 | 1 | 3 | 2 | 1 | 4 | 0 | 0 | 0 | 4 | 0
123464 | 4 | 3 | 1 | 2 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1
123461 | 0 | 3 | 4 | 3 | 1 | 4 | 2 | 1 | 1 | 4 | 0 | 1 | 1 | 4 | 2 | 4 | 1
123461 | 4 | 2 | 3 | 0 | 3 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | =non unique ID
Spreadsheet: 9b13ddfd-810f-4629-9a82-4491d95d2d4a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2839 | 15564 | Josiah | Middaugh | USA | 0 | 00:29:46 | 00:00:43 | 00:52:22 | [NAME] | 00:33:45 | 1 | 01:57:29
2839 | 8278 | [NAME] | [NAME] | USA | 0 | 00:30:44 | 00:01:12 | 00:53:25 | 00:01:21 | 00:35:09 | 2 | 02:01:51
2839 | 15567 | Lars | Finanger | USA | 0 | 00:31:22 | 00:01:04 | 00:51:13 | [NAME] | 00:37:28 | 3 | 02:02:34
2839 | 15602 | [NAME] | [NAME] | USA | 0 | 00:36:57 | 00:01:58 | 01:05:19 | 00:03:08 | 00:55:39 | 4 | [NAME]
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Elari Reili

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
[NAME]
[NAME]
Add as a friend Send message Donate
Experience level 27
12,070 / 15,000
Location: FranceFrance, Corsica Citizenship: CroatiaCroatia
eRepublik birthday
May 11, 2009
National rank: 1230
Party Member
Hrvatska demokratska strankaHrvatska demokratska stranka Center-left Wing
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Orchidaceae
Friends(359)
K3ndu
rappimez
Laurencius
Liiverr
[NAME]
Cioa
etc_Marc
Degenhardt
Marduuhin
view all
Land of Elari Reili: 10 buildings
Visit
About me
Wiki page
Current ePhilippines Military advisor to President
Former eUS Army, Captain
Former Congressman in ePhilippines.
Former ePhilippines Minister of Defense
Former ePhilippines Minister of Education
Achievements
hard worker
7
Hard Worker
Worked 30 days in a row
congressman
7
Congress Member
Won the Congress elections
president
1
Country President
Won the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
1
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
7
Super Soldier
Advance 250 strength points
society builder
1
Society Builder
Invited 10 people to eRepublik and helped them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
1,781.74
Super soldier:1,781 / 2,000
Rank
Colonel **Colonel **
Rank points:
457,245 / 540,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 267380d1380058034-need-a-function-s-to-search-data-with-two-criteria-sizes
Sheet: Sheet1

[NAME] | Pipe Length
1 | 2
1 | 4 |  |  |  | A Known Pipe Size |  | Length must be the next one larger than this |  |  |  |  | Length Necessary:
1 | 6 |  |  |  | 1 |  | 4
1 | 8 |  |  |  | 2 |  | 2.3
1 | 10 |  |  |  | 2 |  | 3.7
2 | 1 |  |  |  | 3 |  | 4.9
2 | 3 |  |  |  | 3 |  | 7.2
2 | 4 |  |  |  | 3 |  | 7.2
2 | 5 |  |  |  | 3 |  | 8.8
3 | 7 |  |  |  | 4 |  | 0.34
3 | 8 |  |  |  | 4 |  | 0.53
3 | 9 |  |  |  | 4 |  | 1.7
3 | 10
4 | 0.5
4 | 1
4 | 1.5
4 | 2
4 | 5
5 | etc
5 | etc
5 | etc
5 | etc |  |  |  | Column A is a standard list of pipe sizes, with Column B reflecting an available length said pipe is availble in.
6 | etc
6 | etc
6 | etc |  |  |  | For a Known Pipe Size, (Column F), and a Minimum Length (Column H), I need to determine the shortest available length for the given pipe size.
6 | etc
6 | etc
Spreadsheet: ee13e540-c2af-43c9-9352-235bef028b63
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
CASE | Test | CASE | Casein, IgE | Casein, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CASE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CASE | Result | CASE | Casein, IgE | Casein, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6062-4 | [NAME].IgE:ACnc:Pt:Ser:Qn: