tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: fee1f525-b704-4eee-9cc4-abb153f8f2ec
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
FIGER | Test | FIGER | Anti-IgE Receptor Antibody | Anti-IgE Receptor Ab | Flow cytometry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Allow blood to clot and separate with one hour. Send 1 mL of serum frozen in plastic vial. Note: 1. Serum gel tube is acceptable, but must pour off into a plastic screw cap vial and freeze.           2. Patients date of birth is required on request form for processing. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject	 Lipemia	NA Icterus	NA Other	NA | IgE Receptor Remark: In the presence of antibody to the [NAME], basophils degranulate resulting in the increased expression of a specific basophil marker. The expression of this marker is determined after incubation of susceptible donor basophils with serum from the patient.        Test Performed By: National Jewish Health                              Advanced Diagnostic Laboratories                              1400 Jackson St.                              Denver, CO  80218 | Monday, Thursday | 7  - 9 days | 11 - 14 days |  | Profile |  |  |  |  | National Jewish Health
FIGER | [NAME] | SRED | Serum Red |  |  |  | Frozen | 365 days
FIGER | Result | Z1297 | IgE Receptor Ab | IgE Receptor Ab | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
FIGER | Billing Component | FIGER |  | each additional marker |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88185
FIGER | Billing Component | FIGER |  | Flow cytometry, first marker |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88184
Spreadsheet: 800349d1665608736-remove-duplicates-within-a-cell-remove_duplicates_cell-2-
Sheet: remove_duplicates_cell

 | REMOVE DUPLICATES WITHIN A CELL
 | grade |  | formula |  | expected_result |  | Formula 1 |  | Formula 2
 | A,A,15,B,2,B,C,2,B |  | ? |  | A,15,B,2,C
 | A,B |  | ? |  | A,B
 | C,C,C |  | ? |  | C
Spreadsheet: 160066d1338954759-cell-formula-that-is-100-correct-not-working-help-server-inventory
Sheet: Total P&V-Comparison

 | Server Room A |  | Server Room B |  | Server Room C
 | Host Name | Physical / Virtual | Host Name | Physical / Virtual | Host Name | Physical / Virtual
Spreadsheet: 725789d1616861087-index-aggregate-multiple-criteria-and-columns-to-search-problem1
Sheet: Sheet1

Product | Component | Quantity | Item | Quantity |  | Product | Component | Country | Qty In | Qty Out | Value | Item | Box |  |  | Label |  |  | Bag
Beverage | [Item] Tea |  |  |  |  | Beverage | [Item] Tea | - | 50 | - | - | Beverage | Box A | 1 | 11 | [NAME] | 2 | 11 | Bag S | 8 | 11
Beverage | [Item] Juice |  |  |  |  | Beverage | [Item] Juice | - | 50 | - | - | Flower | [NAME] | 2 | 12 | [NAME] | 1 | 12 | Bag M | 5 | 12
Beverage | Box A |  |  |  |  | Flower | [Item] Tulip | - | 100 | - | - | Furniture | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Beverage | [NAME] |  |  |  |  | Furniture | [Item] Table | - | 75 | - | - | Food | Box D | 4 | 36 | [NAME] | 8 | 36 | Bag XL | 11 | 36
Beverage | Bag S |  |  |  |  | Furniture | [Item] Chair | - | 150 | - | - | Pets | Box A | 5 | 12 | [NAME] | 4 | 12 | Bag M | 3 | 12
Food | [Item] Bacon |  |  |  |  | Furniture | [Item] Couch | - | 76 | - | -
Food | [Item] Egg |  |  |  |  | Food | [Item] Bacon | - | 188 | - | -
Food | Box D |  |  |  |  | Food | [Item] Egg | - | 125 | - | -
Food | [NAME] |  |  |  |  | Pets | [Item] Cat | - | 304 | - | -
Food | Bag XL
Flower | [Item] Tulip
Flower | [NAME]
Flower | [NAME]
Flower | Bag M
Furniture | [Item] Table
Furniture | [Item] Chair
Furniture | [Item] Couch
Funiture | Box C
Funiture | [NAME]
Funiture | Bag L
Spreadsheet: 144807d1331146396-prioritizing-within-ranks-project-rank-and-priority
Sheet: Sheet1

ID | Team | Status | Rank | Manual Team_Priority | Formulaic Team_Priority
1572 | team a | wip | 1
1578 | team a | wip | 2
UP03 | team b | hold | 3
1556 | team c | wip | 4
1652 | team c | wip | 5
1605 | team d | wip | 6
1618 | team e | deck | 7 | 1 | 1
1648 | team a | wip | 8
1621 | team a | deck | 9 | 1 | 1
1598 | team i | hold | 10
1595 | team h | deck | 11 | 1 | 1
1654 | team c | deck | 12 | 1 | 1
1579 | team g | wip | 13
1597 | Mgmt | wip | 14
WS | team b | wip | 15
1570 | team a | deck | 16 | 2 | 2
1585 | team c | assess | 17 | 2 | 2
1599 | team g | wip | 18
1616 | team a | deck | 19 | 3 | 3
1630 | team f | deck | 20 | 1 | 1
1591 | team f | deck | 21 | 2 | 2
1622 | team b | deck | 22 | 1 | 1
1643 | team c | wip | 23
1544 | team a | deck | 24 | 4 | 4
1617 | team a | deck | 25 | 5 | 5
1552 | team j | deck | 26 | 1 | 1
[NAME] | team b | deck | 27 | 2 | 2
1657 | team a | assess | 28 | 6 | 6
1650 | team c | deck | 29 | 3 | 3
1594 | team f | deck | 30 | 3 | 3
PLRpt1 | team h | wip | 31
1587 | team h | wip | 32
1568 | team b | wip | 33
1581 | team a | deck | 34 | 7 | 7
Spreadsheet: e04f24cb-83ba-46b8-b58d-80b95a540cfb
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
WORM | Test | WORM | Wormwood, IgE | Wormwood, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top		 Acceptable: Serum gel				 Specimen Volume: 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
WORM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
WORM | Result | WORM | Wormwood, IgE | Wormwood, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6286-9 | Artemisia absinthium Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 689409d1596383055-how-to-drag-a-formula-and-make-the-reference-data-skip-a-column-example
Sheet: Sheet1

 |  | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-08 00:00:00
Operator
Labourer
Supervisor
Spreadsheet: mary_fischer__25618__42D
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  42D
COMPANY NAME  Enron Facility Services
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 725835d1616920549-how-to-categorize-using-multiple-currency-rate-multiple-currency-rev1
Sheet: Sheet2

Team |  | Request Ticket | Item | Category | Case code | Total Value | Currency | USD | Threshold
Plato |  | 12580243 | 10 | X |  | 15000 | USD
Maxwell |  | 17185628 | 10 | X |  | 100000 | USD
Maxwell |  | 55723648 | 40 | X |  | 2300000 | EUR
Plato |  | 51858337 | 30 | X |  | 1700 | USD
Plato |  | 11467077 | 10 | X |  | 70000 | [NAME]
Plato |  | 4420109 | 10 |  | ABC54656 | 170.14 | EUR
 |  | 11518185 | 10 |  |  | 2920 | AUD
 |  | 11518185 | 20 |  |  | 5920 | USD
Spreadsheet: 0e673fea-7597-4c41-a7c4-2f684c7c0f80
Sheet: Sheet1

RefWorks | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
2006-2007
Metric | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Cost per unit
New Users | 3 | 7 | 21 | 16 | 16 | 7 | 3 | 98 | 9 | 21 | 5 | 6 | 212 | 11025 | 52.00471698113208
Repeat Users | 12 | 4 | 14 | 25 | 37 | 27 | 18 | 33 | 77 | 69 | 49 | 16 | 381 | 11025 | 28.93700787401575
Total Monthly Users | 15 | 11 | 35 | 41 | 53 | 34 | 21 | 131 | 86 | 90 | 54 | 22 | 593 | 11025 | 18.59190556492412 | per user
Total Sessions per month | 79 | 25 | 87 | 161 | 236 | 187 | 98 | 351 | 484 | 589 | 192 | 128 | 2617 | 11025 | 4.212839128773405 | per session
Average Sessions Per User | 5.27 | 2.27 | 2.49 | 3.93 | 4.45 | 5.5 | 4.67 | 2.68 | 5.63 | 6.54 | 3.56 | 5.82 | 52.81 | 11025 | 208.7672789244461
Total Subscriber References added | 728 | 136 | 144 | 740 | 3492 | 592 | 174 | 617 | 1202 | 1186 | 581 | 464 | 10056 | 11025 | 1.096360381861575 | per reference added
Average References added per user | 48.53 | 12.36 | 4.11 | 18.05 | 65.89 | 17.41 | 8.29 | 4.71 | 13.98 | 13.18 | 10.76 | 21.09 | 238.36 | 11025 | 46.25356603456956
Spreadsheet: 57517d1257743153-combine-multiple-sheet-data01
Sheet: RESULT

type | date | code | packet | des | vb | tax | deliv | price | qty | ttl
RPP0124260 | 2009-02-08 00:00:00 | C | BEG700 | GLOS (x2) | 67 | 0 | 0 | 160 | 1 | 160
RPP0124260 | 2009-02-08 00:00:00 | F | BFG700 | GLOS (x2) | 50 | 0 | 0 | 120 | 1 | 120
RPP0124264 | 2009-04-08 00:00:00 | C | BEG700 | GLOS (x2) | 67 | 0 | 0 | 160 | 1 | 160
RMM00175536 | 2009-06-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 889523d1740382904-create-a-new-column-based-on-unique-prices-test3
Sheet: Φύλλο1

TEST1 | TEST2 |  | NEW COLUMN
A | 10 |  | A
B | 0 |  | B
C | 20 |  | C
D | 0 |  | S
E | 0
A | 2
B | 2
S | 4
S | 2
Spreadsheet: 770180d1645871998-need-formula-to-calculate-sick-day-entitlement-based-on-anniversary-date-sick-day-example-ans
Sheet: Sheet1

Employee ID | Employee First Name | Employee Last Name | Date Of Hire | 90 days from DOH | Location | Sick Days at Start of Provision (Jan 1, 2022) | Sick Days Based on Anniversary Date | Sick Days Taken | Sick Days Left 2022
15179 | [NAME] | Smith | 2009-07-15 00:00:00 |  | Sample-Financial-Location
49872 | [NAME] | Doe | 2009-08-01 00:00:00 |  | Sample-Financial-Location
92636 | [NAME] | Boom | 2013-02-11 00:00:00 |  | Sample-Financial-Location
25615 | [NAME] | Wood | 2013-03-01 00:00:00 |  | Sample-Financial-Location
15652 | [NAME] | Hortons | 2022-02-15 00:00:00 |  | Sample-Financial-Location
59220 | First | Last | 2022-02-15 00:00:00 |  | Sample-Financial-Location
Spreadsheet: 188249d1350767747-sorting-simultaneous-columns-for-same-data-names-corresponding-to-appointments-sample
Sheet: Sheet1

Room | Slot | Day |  |  |  |  |  | Time | Party 1 | Party 2 | Both parties (auto filled)
Room 1 | 1 | Wednesday | 08:00:00 | 08:15:00 |  |  |  | 08:00 to 08:15 | bob | [NAME]
Room 2 | 2 | Wednesday | 16:00:00 | 16:15:00 |  |  |  | 16:00 to 16:15 | [NAME] | bob
Room 2 | 5 | Thursday | 15:00:00 | 15:15:00 |  |  |  | 15:00 to 15:15 | [NAME] | mark
Room 1 | 1 | Wednesday | 08:45:00 | 09:00:00 |  |  |  | 08:45 to 09:00 | mark | bob
Room 4 | 2 | Wednesday | 14:15:00 | 14:30:00 |  |  |  | 14:15 to 14:30 | [NAME] | [NAME]
Room 2 | 2 | Wednesday | 13:45:00 | 14:00:00 |  |  |  | 13:45 to 14:00 | mark | bob
Room 1 | 1 | Wednesday | 09:30:00 | 09:45:00 |  |  |  | 09:30 to 09:45 | [NAME] | [NAME]
Room 5 | 1 | Wednesday | 10:15:00 | 10:30:00 |  |  |  | 10:15 to 10:30 | [NAME] | mark
Room 7 | 3 | Wednesday | 20:15:00 | 20:30:00 |  |  |  | 20:15 to 20:30 | [NAME] | [NAME]
Room 9 | 6 | Thursday | 19:00:00 | 19:15:00 |  |  |  | 19:00 to 19:15 | [NAME] | [NAME]
Spreadsheet: mike_grigsby__27807__WESTminusPA
Sheet: Temp

 |  | Sum = |  |  |  |  |  | Sum = |  | Sum =
 | Ref |  | Net |  |  | Ref |  |  | Net | RollOff | Final | Conversion | Converted | Liquidation
[NAME] | Period | Curve Code | Qty |  | [NAME] | Period | Curve Code | Pub Cd | Qty | Qty | Qty | Factor | Qty | (%)
Spreadsheet: 806971d1669702644-transfer-of-data-from-a-master-sheet-to-other-sheets-quest
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit
Spreadsheet: 2f57b499-bae0-4297-8f51-5ce67532b9f6
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-06-15 09:40:55.560000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.057 | 100.932 | 100.807 | 100.432
4.625 | 100.142 | 100.017 | 99.892 | 99.517 |  | Note: | Refer To Price [NAME]
4.5 | 99.64 | 99.515 | 99.39 | 99.015 |  |  | For all Price Adjs
4.375 | 98.982 | 98.857 | 98.732
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.196 | 101.071 | 100.946 | 100.571
4 | 100.874 | 100.749 | 100.624 | 100.249
3.875 | 100.461 | 100.336 | 100.211 | 99.836
3.75 | 99.853 | 99.728 | 99.603 | 99.228
3.625 | 98.766 | 98.641 | 98.516
 |  |  |  |  |  | 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-06-29 09:40:55.560000
30 DAY | 2011-07-14 09:40:55.560000
45 DAY | 2011-07-29 09:40:55.560000
60 DAY | 2011-08-13 09:40:55.560000
90 DAY | 2011-09-12 09:40:55.560000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: PRESIDENTS

 |  | THE CROWN GOLF SOCIETY ANSTEY LEICESTER
 |  |  | RESULT  G.C 2012
 | PLAYER | HANDICAP | POINTS SCORED | LEADERBOARD POINTS
1ST |  |  |  | 30
2ND |  |  |  | 29
3RD |  |  |  | 28
4TH |  |  |  | 27
5TH |  |  |  | 26
6TH |  |  |  | 25
7TH |  |  |  | 24
8TH |  |  |  | 23
9TH |  |  |  | 22
10TH |  |  |  | 21
11TH |  |  |  | 20
12TH |  |  |  | 19
13TH |  |  |  | 18
14TH |  |  |  | 17
15TH |  |  |  | 16
16TH |  |  |  | 15
17TH |  |  |  | 14
18TH |  |  |  | 13
19TH |  |  |  | 12
20TH |  |  |  | 11
21ST |  |  |  | 10
22ND |  |  |  | 9
23RD |  |  |  | 8
24TH |  |  |  | 7
25TH |  |  |  | 6
26TH |  |  |  | 5
27TH |  |  |  | 4
28TH |  |  |  | 3
29TH |  |  |  | 2
30TH |  |  |  | 1
31st |  |  |  | 0
32nd |  |  |  | 0
33rd |  |  |  | 0
34th |  |  |  | 0
35th |  |  |  | 0
36th |  |  |  | 0
37th |  |  |  | 0
38th |  |  |  | 0
39th |  |  |  | 0
40th |  |  |  | 0
41st |  |  |  | 0
42nd |  |  |  | 0
43rd |  |  |  | 0
44th |  |  |  | 0
45th |  |  |  | 0
46th |  |  |  | 0
47th |  |  |  | 0
48th |  |  |  | 0
49th |  |  |  | 0
50th |  |  |  | 0
 | LONGEST DRIVE |  |  | 25TH AUGUST 2012
 | NEAREST PIN
Spreadsheet: 0bbaf2a6-23a1-4e94-96e2-98e51a2d30db
Sheet: Sheet1

Place | club | Buthiers | Epinay | Meaux | Chessy | Verneuil | Total
1 | ENVY - Epinay |  | 250 | 220 | 220 |  | 690
2 | Palaiseau |  | 220 | 200 | 180 |  | 600
3 | [NAME] |  |  |  | 250 |  | 250
4 | Torcy |  |  | 180 | 200 |  | 380
5 | Club Yerrois |  | 200 |  |  |  | 200
6 | Trinosaure |  |  |  | 160 |  | 160
7 | ASPS Sénart |  |  |  | 150 |  | 150
8 | Levallois |  |  |  | 140 |  | 140
9 | Andrésy |  |  |  | 130 |  | 130
10 | Draveil |  |  |  | 120 |  | 120
11 | [NAME] |  |  |  | 110 |  | 110
12 | [NAME] |  |  |  | 100 |  | 100
13 | Ozoir VSOP |  |  |  | 90 |  | 90
14 | Chessy |  |  | 150 | 80 |  | 230
15 | Les Tritons Meldois |  |  |  | 70 |  | 70
16 | Courbevoie |  |  | 160 |  |  | 160
17 | [NAME] |  |  | 250 |  |  | 250
Place | club | Buthiers | Epinay | Meaux | Chessy | Verneuil | Total
1 | Palaiseau |  | 250 | 200 | 250 |  | 700
2 | ENVY - Epinay |  | 220 | 180 | 180 |  | 580
3 | Club Yerrois |  | 200 | 40 | 50 |  | 290
4 | Draveil |  | 160 |  | 80 |  | 240
5 | Issy |  |  | 120 | 220 |  | 340
6 | Versailles |  |  | 160 | 200 |  | 360
7 | [NAME] |  | 180 | 80 | 20 |  | 280
8 | ASPS Sénart |  |  | 20 | 160 |  | 180
9 | [NAME] |  |  |  | 150 |  | 150
10 | [NAME] |  |  | 140 | 140 |  | 280
11 | VMT |  |  | 150 | 130 |  | 280
12 | Levallois |  |  |  | 120 |  | 120
13 | TSR 78 |  |  |  | 110 |  | 110
14 | Torcy |  |  |  | 100 |  | 100
15 | [NAME] |  |  | 110 | 90 |  | 200
16 | Andrésy |  |  |  | 70 |  | 70
17 | Chessy |  |  | 70 | 60 |  | 130
18 | Meudon |  |  |  | 40 |  | 40
19 | Aquacyclopedus |  |  | 10 | 30 |  | 40
20 | Les Tritons Meldois |  |  | 250 | 10 |  | 260
21 | TCSQY |  |  | 220 |  |  | 220
22 | Trinosaure |  |  |  | 10 |  | 10
23 | Villepinte |  |  | 90 | 10 |  | 100
24 | [NAME] |  |  |  | 10 |  | 10
25 | Ozoir VSOP |  |  | 10 | 10 |  | 20
26 | Créteil |  |  | 100 | 10 |  | 110
27 | Sartrouville |  |  | 10 |  |  | 10
28 | Pompiers TRI 78 |  |  | 10 |  |  | 10
29 | Vélizy |  |  | 10 |  |  | 10
30 | ACBB |  |  | 10 |  |  | 10
31 | courbevoie |  |  | 30 |  |  | 30
32 | US METRO |  |  | 60 |  |  | 60
33 | Champigny |  |  | 50 | 10 |  | 60
34 | ANSA |  |  | 130 |  |  | 130
35 | SP VAL D'YERRES |  |  |  | 10 |  | 10
36 | CCSC Triathlon |  |  |  | 10 |  | 10
37 | [NAME] |  |  |  | 10 |  | 10
Spreadsheet: 50005d1249416425-array-range-from-multiple-selections-694311-array-range-from-multiple-selections
Sheet: Sheet1

Enter Start Date | 2009-07-02 00:00:00 |  |  | Return | -2.980232238769531e-09
Enter End Date | 2009-07-05 00:00:00
Date | Amount |  |  |  | Defined Names usd in this workbook
2009-07-01 00:00:00 | -100
2009-07-02 00:00:00 | 1000 |  |  |  | All_Dates
2009-07-03 00:00:00 | 10000 |  |  |  | Mydates
2009-07-04 00:00:00 | 80 |  |  |  | MyVals
2009-07-05 00:00:00 | -100 |  |  |  | StartDate
2009-07-06 00:00:00 | 120 |  |  |  | EndDate
2009-07-07 00:00:00 | 120
2009-07-08 00:00:00 | 121
2009-07-09 00:00:00 | -80
2009-07-10 00:00:00 | 0
Spreadsheet: 140730d1328875507-solved-lookup-specific-date-from-a-list-of-date-ranges-and-return-related-data-clinic-workload
Sheet: Clinics

cl [NAME] | Day Factor | 50-70 + 16% | round | Start 8th | End 8th
33 | 5 | 1894 | 1.794520547945206 | 2011-05-27 00:00:00 | 2011-10-19 00:00:00
33 | 5 | 1294 | 2.134246575342466 | 2011-10-20 00:00:00 | 2012-01-16 00:00:00
33 | 5 | 2429 | 2.142465753424657 | 2012-01-17 00:00:00 | 2012-02-27 00:00:00
33 | 5 | 920 | 1.947945205479452 | 2012-02-28 00:00:00 | 2012-04-26 00:00:00
33 | 3.5 | 889 | 2.101369863013699 | 2012-04-27 00:00:00 | 2012-07-01 10:26:06
33 | 3.5 | 144 | 2.165574761311749 | 2012-07-02 10:26:06 | 2012-07-11 17:42:48
33 | 3.5 | 933.8 | 2.177364549605648 | 2012-07-12 17:42:48 | 2012-09-27 01:36:46
33 | 4 | 757.48 | 2.326211506849309 | 2012-09-28 01:36:46 | 2012-11-09 21:18:24
33 | 4 | 1566 | 2.366815819012038 | 2012-11-10 21:18:24 | 2013-03-02 03:56:29
33 | 4 | 847.96 | 2.548395146533834 | 2013-03-03 03:56:29 | 2013-04-23 14:23:31
33 | 4 | 1858.32 | 2.62356072395186 | 2013-04-24 14:23:31 | 2013-08-23 09:37:31
33 | 5 | 1876.88 | 2.814797416355338 | 2013-08-24 09:37:31 | 2013-11-18 16:21:24
33 | 5 | 1324.72 | 2.919675433125777 | 2013-11-19 16:21:24 | 2014-02-05 18:59:02
33 | 5 | 864.2 | 2.944632853466175 | 2014-02-06 18:59:02 | 2014-03-17 20:58:15
33 | 5 | 13.92 | 2.93664049813201 | 2014-03-18 20:58:15 | 2014-03-19 12:04:45
33 | 5 | 10.44 | 2.941104940473232 | 2014-03-20 12:04:45 | 2014-03-20 23:24:38
33 | 5 | 911.76 | 2.945138203736003 | 2014-03-21 23:24:38 | 2014-05-06 09:49:06
Spreadsheet: 148280d1333323036-excel-2007-unable-to-make-totals-balance-both-up-and-down-moates-bvj-
Sheet: Sheet1

 | Weight(Lbs) | Weight(MT) | rounded to one decimal place
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 0
Spreadsheet: 717123d1612494063-index-match-combination-issues-supplylistef-dexter2-
Sheet: Special

Name of Item |  |  |  |  | Invoice | Item | Manufacturer