tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92825d1292360091-if-formula-problem-checking-each-cell-for-an-answer-book1
Sheet: Sheet1

1 | xxxxxxx | xxxxxxx | 9 | 6 | 9 | 10 | 10 | 7 | 9 | 7 | 10 | 8 | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.055555555555555
2 | yyyyyyy | yyyyyyyy | 9 | 6 | 10 | 7 | 9 | 9 | 9 | 6 | 10 | 8 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.88888888888889
3 | aaaaaaaaa | aaaaaaaaaaa | 10 | 10 | 9 | 7 | 9 | 8 | 9 | 8 | 10 | 10 | 10 | 9 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.38888888888889
4 | bbbbbbb | bbbbbbb | 7 | 8 | 9 | 4 | 9 | 9 | 9 | 6 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.722222222222221 | #N/A
5 | cccccccccc | ccccccccccc | 7 | 8 | 8 | 7 | 9 | 8 | 8 | 6 | 10 | 8 | 10 | 7 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 8.666666666666666
6 | ddddddddd | ddddddd | 8 | 9 | 9 | 7 | 9 | 7 | 7 | 7 | 9 | 9 | 10 | 7 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.722222222222221
7 | eeeeeeee | eeeeeee | 9 | 9 | 9 | 7 | 9 | 9 | 8 | 7 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.11111111111111
8 | [NAME] | ffffffff | 10 | 10 | 10 | 8 | 10 | 8 | 8 | 8 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 9.333333333333334
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: apr 2

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00
[NAME] | off | 8:30-5:30 | 8:00-5:00 | 9:00-5:30 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 11:30-12:30
[NAME] | fmla | fmla | fmla | fmla | fmla | fmla
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 8:00-5:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 12:30-1:30
Mark | 8:30-5:30 | 8:30-5:30 | 8:30-5:30 | 8:30-5:30 | 8:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00
[NAME] | 9:30-5:30 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:30-5:30-counter | 9:15-5:15
ctr 12-2 | 11:00-12:00 |  | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 | 1:30-2:30
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 11:30-12:30
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 98054d1297137498-lookup-formula-sample
Sheet: PLATT

AGRI (IMV-1)
Case No. | Customer Order No. | Order Reference No. | Customer Code | TTC P/N | Cust P/N | Display P/N | Description | [NAME] | SPQ | Order Lot | Qty | Part G/W | N/Weight | M3 | Inner Pkg
PK036000006 |  |  |  |  | 90389-T0001 |  |  |  |  |  | 210
PK036000006 |  |  |  |  | A0181-01203 |  |  |  |  |  | 200
PK036000006 |  |  |  |  | A0181-01315 |  |  |  |  |  | 400
PK036000006 |  |  |  |  | A0201-02614 |  |  |  |  |  | 200
PK036000006 |  |  |  |  | A0201-03986 |  |  |  |  |  | 210
PK036000006 |  |  |  |  | A0201-05927 |  |  |  |  |  | 200
PK036000006 |  |  |  |  | A0202-59009 |  |  |  |  |  | 100
PK036000006 |  |  |  |  | A0202-59010 |  |  |  |  |  | 100
Spreadsheet: 747663d1631634085-using-sumifs-combined-with-vlookup-help-zohan1
Sheet: Sheet1

Stock Location and Amount
TOKEN | TOTAL | Shop1 | Shop2 | Shop3 | Shop4 | Shop5 | Bank
Apples
Pears
Bananas
Oranges
Bank |  |  |  |  |  |  | 1000
September Stock Movement
September Stock Movement
Date | Buy/Sell/Transfer | Item | Amount | Venue (from) | Venue (To)
2021-09-14 00:00:00 | Transfer | Pears | 1 | Shop4 | Shop1
2021-09-14 00:00:00 | Transfer | Apples | 4 | Shop5 | Shop4
2021-09-14 00:00:00 | Transfer | Oranges | 2 | Shop2 | Shop3
2021-09-14 00:00:00 | Transfer | Bananas | 1 | Shop1 | Shop2
2021-09-14 00:00:00 | Buy | Apples | 20 | Bank | Shop1
2021-09-14 00:00:00 | Sell | Bananas | 5 | Shop3 | Bank
Value of Item
Apples | 1
Pears | 2
Bananas | 3
Oranges | 4
Spreadsheet: lisa_gang__22280__ENA_PGE_APRIL_30_2002
Sheet: COB-SYS BR TY&DONNA

From: | EPMI
To: | PGE System Transactions
Date: | 2002-04-30 00:00:00
Total Transmission
HE
ENDING |  |  | TOTAL |  |  | TOTAL | TOTAL
Pacific Prevailing
Time | NOT TO BE PUT ON | SALE AT SYSTEM | BUY/RESALE |  |  | COB/JD | [NAME] USED
(PPT) | PORTLAND TRANSMISSION |  | [NAME] |  |  | Total In To PGE Trans S > N | Total In To PGE Trans
0100 | 0 | 0 |  |  |  | 0
0200 | 0 | 0 |  |  |  | 0
0300 | 0 | 0 |  |  |  | 0
0400 | 0 | 0 |  |  |  | 0
0500 | 0 | 0 |  |  |  | 0
0600 | 0 | 0 |  |  |  | 0
0700 | 0 | 0 |  |  |  | 0
0800 | 0 | 0 |  |  |  | 0
0900 | 0 | 0 |  |  |  | 0
1000 | 0 | 0 |  |  |  | 0
1100 | 0 | 0 |  |  |  | 0
1200 | 0 | 0 |  |  |  | 0
1300 | 0 | 0 |  |  |  | 0
1400 | 0 | 0 |  |  |  | 0
1500 | 0 | 0 |  |  |  | 0
1600 | 0 | 0 |  |  |  | 0
1700 | 0 | 0 |  |  |  | 0
1800 | 0 | 0 |  |  |  | 0
1900 | 0 | 0 |  |  |  | 0
2000 | 0 | 0 |  |  |  | 0
2100 | 0 | 0 |  |  |  | 0
2200 | 0 | 0 |  |  |  | 0
2300 | 0 | 0 |  |  |  | 0
2400 | 0 | 0 |  |  |  | 0
 | NCPA(G)SYS | PGE(G)SYS COB SN/SYS BR | SHOULD BE ZERO
 | CISO(T)NCPA/CJ | EPMI(PSE)
 | [NAME]) | PGE(L,R)SYS  SYS/MIDC
 | EPMI(PSE) | NOT TO BE PUT ON
 | PGE(PSE) | PORTLAND TRANSMISSION
 | PGE(T)CJ/JD
 | BPA(T)JD/PGE SYS
 | PGE(L,R)SYS  SYS/COB BR
 | NOT TO BE PUT ON
 | PORTLAND TRANSMISSION
Spreadsheet: 64275d1265142381-how-lookup-numbers-between-range-numbers-in-1-cell-question
Sheet: Sheet1

Number | Column
 | A | B | C
4-6 | 1.1 | 1 | 0.9
7-10 | 1.3 | 1.2 | 1.1
Up 10 | 1.5 | 1.4 | 1.3
t | #N/A | ???
Spreadsheet: fda1b0d3-d150-4d06-b45b-7f513ec449cd
Sheet: Operating

OPERATING/PROGRAMMATIC
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Congestion Mitigation and Air Quality (CMAQ No. 3301),
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2010-11 |  |  | FY 2011-12
 | General Fund
 | Special Revenue |  |  |  |  |  |  | 670000
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | Justice [NAME] funds
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2010-11 |  |  | FY 2011-12
 | General Fund |  |  |  |  |  |  | 0
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | This grant program allows state and local law enforcement agencies to support a broad range of activities
and initiatives which prevent and deter crime and improve the criminal justice system.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 167400d1341980621-how-is-grand-total-of-an-average-column-calculated-in-a-pivot-table-pt-total-average
Sheet: Sheet1

Name | Amt
[NAME] | 5
[NAME] | 6 |  | Row Labels | Average of Amt
[NAME] | 7 |  | [NAME] | 5.5
[NAME] | 8 |  | [NAME] | 8
[NAME] | 9 |  | Grand Total | 7 | <<This is the average of all the Amts
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 9a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 7469286 | 15919240 | 23388527
 | FRA | 32935805 | 23600261 | 56536066
 | Exotic |  | 3625047 | 3625047
 | Inflation |  | 2538402 | 2538402
 | IRS- [NAME] | 111518585 | 100210281 | 211728866
 | OIS | 19581138 | 17868994 | 37450131
 | VNS | <10,000 |  | <10,000
 | Zero Coupon | 221435 |  | 221435
With Optionality | Callable Swap |  | 843049 | 843049
 | Cap/Floor |  | 10359268 | 10359268
 | Debt Option |  | 672963 | 672963
 | Exotic Option |  | 1398543 | 1398543
 | Swaption |  | 28638291 | 28638291
Cross-Currency | Exotic |  | 94385 | 94385
 | Swap |  | 16381698 | 16381698
TOTAL |  | 171726249 | 222150421 | 393876670
Estimated gross notional amount outstanding, November 16 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 86654d1286579676-excel-2007-automatically-copy-data-from-master-sheet-new-microsoft-office-excel-worksheet-ii
Sheet: India

4 | 1 | 4 | [NAME] | Midwell | Soap
 |  | 6 | pike | moruya | shaving cream
6 | 3 | 7 | pike | moruya | Toilet paper
7 | 4 | 8 | pike | moruya | shaving cream
8 | 5 |  | 0 | 0 | 0
Spreadsheet: mary_fischer__25624__31X
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  | 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: 646b35df-48e0-4b70-859e-77e5230df143
Sheet: CDS-D

D. TRANSFER ADMISSION
 | Fall Applicants
D1 |  |  |  | Yes | No
D1 | Does your institution enroll transfer students?  (If no, please skip to Section E) |  |  | X
D1 | If yes, may transfer students earn advanced standing credit by transferring credits earned from course work completed at other colleges/universities? |  |  | X
D2 | Provide the number of students who applied, were admitted, and enrolled as degree-seeking transfer students in Fall 2011.
D2 |  | Applicants | Admitted Applicants | Enrolled Applicants
D2 | Men | 1235 | 1235 | 547
D2 | Women | 1750 | 1750 | 671
D2 | Total
 | Application for Admission
D3 | Indicate terms for which transfers may enroll:
D3 | Fall | X
D3 | Winter
D3 | Spring | X
D3 | Summer | X
D4 |  |  |  | Yes | No
D4 | Must a transfer applicant have a minimum number of credits completed or else must apply as an entering freshman? |  |  |  | X
D4 | If yes, what is the minimum number of credits and the unit of measure?
D5 | Indicate all items required of transfer students to apply for admission:
D5 |  | Required of All | Recommended of All | Recommended of Some | Required of Some | Not Required
D5 | High school transcript |  |  |  |  | X
D5 | College transcript(s) |  |  |  |  | X
D5 | Essay or personal statement |  |  |  |  | X
D5 | Interview |  |  |  |  | X
D5 | Standardized test scores |  |  |  |  | X
D5 | Statement of good standing from prior institution(s) |  |  |  |  | X
D6 | If a minimum high school grade point average is required of transfer applicants, specify (on a 4.0 scale):
D7 | If a minimum college grade point average is required of transfer applicants, specify (on a 4.0 scale):
D8 | List any other application requirements specific to transfer applicants:
D9 | List application priority, closing, notification, and candidate reply dates for transfer students. If applications are reviewed on a continuous or rolling basis, place a check mark in the “Rolling admission” column.
D9 |  | Priority Date | Closing Date | Notification Date | Reply Date | Rolling Admission
D9 | Fall |  |  |  |  | X
D9 | Winter
D9 | Spring |  |  |  |  | X
D9 | Summer |  |  |  |  | X
D10 |  |  |  | Yes | No
D10 | Does an open admission policy, if reported, apply to transfer students? |  |  | X
D11 | Describe additional requirements for transfer admission, if applicable:
 | Transfer Credit Policies
D12 | Report the lowest grade earned for any course that may be transferred for credit:
D13 |  |  |  | Number | Unit Type
D13 | Maximum number of credits or courses that may be transferred from a two-year institution: |  |  | 45 | Credits
D14 |  |  |  | Number | Unit Type
D14 | Maximum number of credits or courses that may be transferred from a four-year institution: |  |  | 45 | Credits
D15 | Minimum number of credits that transfers must complete at your institution to earn an associate degree: |  |  | 15
D16 | Minimum number of credits that transfers must complete at your institution to earn a bachelor’s degree:
D17 | Describe other transfer credit policies:
Spreadsheet: 771718d1646813578-countif-and-vlookup-help-myexcel
Sheet: Lookup

Town | Case1 | Case 2 | Case 3
[NAME] | Covid | Covid | Covid |  | Province | Covid
Mt Hagen | Covid | Covid | Covid |  | Total
Rabaul | TB | TB | TB |  | Mt Hagen
Lae | Malaria | Malaria | Malaria
Mt Hagen | Covid | Covid | Covid
Mt Hagen | Covid | Covid | Covid
Lae | Malaria | Malaria | Malaria
Mt Hagen | Covid | Covid | Covid
Lae | Covid | Covid | Covid
Rabaul | TB | TB | TB
Spreadsheet: 67421d1268062912-simple-training-matrix-training-matrix-2
Sheet: Employees

employee id | GLC
1001 | Office
1002 | Drilling
1003 | Explosives
1004 | Office
1005 | Drilling
1006 | Explosives
1007 | Office
1008 | Drilling
1009 | Explosives
1010 | Office
1011 | Drilling
1012 | Explosives
1013 | Office
1014 | Drilling
1015 | Explosives
1016 | Office
1017 | Drilling
1018 | Explosives
Spreadsheet: 149417d1333953745-fuzzy-cell-value-find-match-most_close_value
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  | Input Value | Cal Field | Cal Field | Cal Field | Result Close Value
 | 1 | 20 | 60 | 40 | 100 | 200 |  | 15
 | 2 | 25 | 50 | 75 | 100 | 200 |  | 40
 | 3 | 25 | 50 | 75 | 100 | 200
 | 4 | 25 | 50 | 75 | 100 | 200
 | 5 | 20 | 40 | 60 | 100 | 200
 | 6 | 25
 | 7 | 25
 | 8 | 20 |  |  |  |  |  | 250
Spreadsheet: 103044d1300893560-excel-2007-data-validation-du
Sheet: Sheet2

[NAME] | 123 | 124 | 125 | 126
[NAME] | 124 | 125 | 126 | 127
[NAME] | 125 | 126 | 127 | 128
[NAME] | 126 | 127 | 128 | 129
Spreadsheet: 812462d1673167831-list-of-upcoming-birthday-this-month-and-next-month-book1-9
Sheet: Upcoming Birthday

 |  | DATE
 |  |  |  |  |  |  |  |  |  |  | UPCOMING BIRTHDAY THIS MONTH AND NEXT MONTH
 |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE |  |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE
Spreadsheet: 750737d1633612820-how-to-add-new-column-with-vlookup-formula-in-powerquery-connection-powerquery-vlookup
Sheet: Source Data

First Name | Surname | Age | 1st line of address | Town
First name 1 | Surname 1 | 22 | Address 1 | Town 1
First name 2 | Surname 2 | 45 | Address 2 | Town 2
First name 3 | Surname 3 | 65 | Address 3 | Town 3
First name 4 | Surname 4 | 11 | Address 4 | Town 4
First name 5 | Surname 5 | 13 | Address 5 | Town 5
First name 6 | Surname 6 | 15 | Address 6 | Town 6
First name 7 | Surname 7 | 24 | Address 7 | Town 7
First name 8 | Surname 8 | 26 | Address 8 | Town 8
First name 9 | Surname 9 | 32 | Address 9 | Town 9
First name 10 | Surname 10 | 38 | Address 10 | Town 10
First name 11 | Surname 11 | 42 | Address 11 | Town 1
First name 12 | Surname 12 | 24 | Address 12 | Town 2
First name 13 | Surname 13 | 47 | Address 13 | Town 3
First name 14 | Surname 14 | 67 | Address 14 | Town 4
First name 15 | Surname 15 | 13 | Address 15 | Town 5
First name 16 | Surname 16 | 15 | Address 16 | Town 6
First name 17 | Surname 17 | 17 | Address 17 | Town 7
First name 18 | Surname 18 | 26 | Address 18 | Town 8
First name 19 | Surname 19 | 28 | Address 19 | Town 9
First name 20 | Surname 20 | 34 | Address 20 | Town 10
First name 21 | Surname 21 | 40 | Address 21 | Town 7
First name 22 | Surname 22 | 44 | Address 22 | Town 8
First name 23 | Surname 23 | 26 | Address 23 | Town 9
First name 24 | Surname 24 | 49 | Address 24 | Town 10
First name 25 | Surname 25 | 69 | Address 25 | Town 1
First name 26 | Surname 26 | 15 | Address 26 | Town 2
First name 27 | Surname 27 | 26 | Address 27 | Town 3
First name 28 | Surname 28 | 32 | Address 28 | Town 4
First name 29 | Surname 29 | 38 | Address 29 | Town 7
First name 30 | Surname 30 | 42 | Address 30 | Town 8
First name 31 | Surname 31 | 36 | Address 31 | Town 9
First name 32 | Surname 32 | 42 | Address 32 | Town 10
First name 33 | Surname 33 | 46 | Address 33 | Town 1
First name 34 | Surname 34 | 28 | Address 34 | Town 2
First name 35 | Surname 35 | 51 | Address 35 | Town 3
First name 36 | Surname 36 | 71 | Address 36 | Town 4
First name 37 | Surname 37 | 17 | Address 37 | Town 5
First name 38 | Surname 38 | 28 | Address 38 | Town 6
First name 39 | Surname 39 | 34 | Address 39 | Town 7
First name 40 | Surname 40 | 40 | Address 40 | Town 8
First name 41 | Surname 41 | 44 | Address 41 | Town 9
Spreadsheet: 07aca667-60dd-4556-9e4e-44e030c89cb5
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
FCRDE | Test | FCRDE | [NAME]Red Dye Cochineal (Dactylopius coccus) IgE (Red # 4) | [NAME]Red Dye IgE | ImmunoCAP FEIA | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 1 - 3 days | 3 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FCRDE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCRDE | Result | [NAME] | [NAME]Red Dye IgE | [NAME]Red Dye IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCRDE | Result | Z3083 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: d13135e7-c3fb-4884-9d62-2f8189e6363e
Sheet: Sheet1

Judgeship Number 8 - NON (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/18/2013 8:01:55 PM
Precincts Reporting: 565/565 - Total Ballots Cast: 111325
2006 Primary Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 12 | 2352 | 2352
District 14 | 637 | 637
District 20 | 278 | 278
District 23 | 992 | 992
District 24 | 2935 | 2935
District 25 | 1898 | 1898
District 26 | 2391 | 2391
Results provided by the Office of North Dakota Secretary of State | 910 | 910
District 29 | 1978 | 1978
TOTAL | 14371 | 14371
Spreadsheet: 769686d1645636212-would-like-to-create-an-intelligent-variable-list-capability-matrix-test
Sheet: Lookup Tables

Technology | Drinks prices | Menu | Wild Animals | Police | Climate | Column1 | Column2 | Column3 | Column4 | Column5 | Column6
Jetskiing | 1 | 0 | 0 | 2 | 3
Tennis | 2 | 2 | 2 | 2 | 2
Fox-hunting | 2 | 1 | 3 | 1 | 1
Drinking | 0 | 4 | 4 | 3 | 5
Dancing | 0 | 2 | 2 | 2 | 5
Smoking | 3 | 2 | 0 | 4 | 2
Fighting | 4 | 0 | 1 | 3 | 4
3         This Table is the minimum requirements for each activity
Criterion _1 | Criterion _2 | SUM | Site |  | Drinks prices | Menu | Wild Animals | Police | Climate
 |  |  |  |  | 4       This array is the quality of the match for each location vs the minimum requirements
5   This is the column
that is used to determine
how good a match is
0 = great match
1 = OK match
>2 = not a match
Now go back to "Front"
Spreadsheet: 165354d1341195143-excel-2007-encrypted-files-how-do-i-undo-that-002106-
Sheet: Sheet1

 |  | "ROCK & ROLL" DESIGNS
 |  |  | Group Reference #URR
***Please order by group*** |  |  |  |  | [NAME] -  ALL Over Front
Your Price
Packed: 6dz Asst Colors and Sizes |  |  |  |  | [NAME]
18 | 2000URR [NAME] |  |  | 27 | M-2X - 1-2-2-1 | ***Colors and prints vary
18 | 923URR   Juniors Tee |  |  | 27 | S-XL  - 1-2-2-1 | depending on gender***
18 | 8000URR   [NAME] |  |  | 27 | M-2X  - 1-2-2-1
15 | 11736URR   [NAME] |  |  | 21 | S-XL   - 1-2-2-1
REF# URR01 |  |  |  |  | REF# URR02 | REF# [NAME]
REF #URR04 |  |  |  | REF #URR05 |  | REF #URR06
 |  |  |  |  | REF #[NAME]
 |  |  |  |  |  |  | 21
Spreadsheet: 71678d1272431577-formula-like-vlookup-for-sub-total-question
Sheet: Sheet1

Name | Price
[NAME] | -14611.36
[NAME] | -13486.13372093023
[NAME] | -12874.81052631579 |  |  |  | Total
[NAME] | -9691.4 |  |  | [NAME]
[NAME] | -8722.039999999994 |  |  | [NAME]
[NAME] | -8414.54 |  |  | [NAME]
[NAME] | -8387.91 |  |  | Total | 0
[NAME] | -7702.974999999999
[NAME] | -7574.703333333335
[NAME] | -6907.255813953489 |  | How can I write a formula in cell  F5,  F6  &  F7  to show the  Sub-Total Value for John, Mary & Peter?
[NAME] | -6773.65 |  |  | Price
[NAME] | -5945.5 |  |  | Name | Total
[NAME] | -5871.335555555555 |  |  | [NAME] | -49791.84
[NAME] | -5454.45 |  |  | [NAME] | -55547.3800611995
[NAME] | -5247.9 |  |  | [NAME] | -46138.23170498085
[NAME] | -5142.6 |  |  | Total | -151477.4517661804
[NAME] | -5079.62 |  |  | Grand Total | -302954.9035323607
[NAME] | -4660.566666666667
[NAME] | -4523.1
[NAME] | -4405.601149425288
Total | -151477.4517661804
Spreadsheet: 41279d1239774844-markup-multiple-values-in-multiple-sheets-when-file-is-opened-markupforcemacros
Sheet: Sheet1

 | Items | Prices | Please reopen sheet with macros enabled!! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Factor | 1.33
 | Item1 | #N/A |  | Look out in cell AA1
 | Item2 | #N/A
 | Item3 | #N/A
 | Item4 | #N/A
 | Item5 | #N/A
 | Item6 | #N/A
 | Item7 | #N/A
 | Item8 | #N/A
 | Item9 | #N/A