tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 812012d1672913999-lookup-data-between-data-blocks-test
Sheet: Sheet1

Existing Data>> | Node | Node | Length | [NAME] | New Data>> | Node | Node | Length |  | Node | Node | Length | [NAME]
 | 1 | 2 | 1 | 90 |  | 1 | 2 | 1
 | 2 | 24 | 34 | 63 |  | 2 | 3 | 31
 | 2 | 3 | 37 | 90 |  | 2 | 24 | 34
 | 3 | 4 | 47 | 90 |  | 3 | 4 | 52
 | 4 | 5 | 44 | 90 |  | 4 | 5 | 44
 | 4 | 21 | 46 | 90 |  | 5 | 6 | 36
 | 5 | 9 | 23 | 90 |  | 5 | 9 | 23
 | 5 | 6 | 36 | 63 |  | 6 | 7 | 32
 | 6 | 8 | 27 | 63 |  | 6 | 8 | 27
 | 6 | 7 | 32 | 63 |  | 10 | 9 | 33
 | 9 | 10 | 33 | 90 |  | 10 | 11 | 27
 | 10 | 11 | 27 | 63 |  | 10 | 13 | 50
 | 10 | 13 | 50 | 90 |  | 11 | 12 | 29
 | 11 | 12 | 29 | 63 |  | 13 | 14 | 50
 | 13 | 14 | 50 | 90 |  | 14 | 15 | 50
 | 14 | 15 | 50 | 90 |  | 15 | 16 | 47
 | 15 | 22 | 40 | 63 |  | 15 | 22 | 40
 | 15 | 16 | 47 | 90 |  | 16 | 17 | 48
 | 16 | 17 | 48 | 90 |  | 17 | 18 | 40
 | 17 | 18 | 40 | 90 |  | 17 | 21 | 32
 | 17 | 21 | 32 | 90 |  | 18 | 19 | 40
 | 18 | 19 | 40 | 90 |  | 19 | 20 | 35
 | 19 | 20 | 35 | 90 |  | 21 | 4 | 46
 | 22 | 23 | 39 | 63 |  | 22 | 23 | 39
 | 24 | 25 | 33 | 63 |  | 24 | 25 | 33
 |  |  |  |  |  | 21 | 26 | 15
 |  |  |  |  |  | 27 | 10 | 20
Spreadsheet: 33ecef9a-e04a-4d63-9217-6ffc6c80cb8d
Sheet: Sheet1

GS/M ID | WB ID | PRODUCT
GL50581_4543 | GL50803_17451 | Deoxynucleoside kinase
GL50581_4533 | GL50803_17231 | Kinase, NEK
GL50581_3532 and GL50581_3533 | GL50803_91324 | Hypothetical protein
GL50581_3040 and GL50581_3041 | GL50803_92664 | Spindle pole protein-like
GL50581_2268 | GL50803_28651 | Dipeptidyl-peptidase I precursor
[NAME] | GL50803_16273 | Hypothetical protein
Spreadsheet: 599528d1543163880-substracting-untill-value-is-reached-starting-from-highest-rank-onwards-example-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 3 shelves in store 1 rmoved, and 5 shelves in store 2 based on the rank
 | Data |  |  |  |  |  | Outcome
 | Store | EAN number | Rank based on margin per shelf | Shelves to be removed | Shelves filled |  | Store | EAN number | Rank based on margin per shelf | Shelves to be removed | Shelves filled | Preffered outcome (shelves removed)
 | Store 1 | EAN 1 | 2 | 3 | 2 |  | Store 1 | EAN 1 | 2 | 3 | 2 | 0
 | Store 1 | EAN 2 | 5 | 3 | 1 |  | Store 1 | EAN 2 | 5 | 3 | 1 | 1
 | Store 1 | EAN 3 | 4 | 3 | 1 |  | Store 1 | EAN 3 | 4 | 3 | 1 | 1
 | Store 1 | EAN 4 | 6 | 3 | 1 |  | Store 1 | EAN 4 | 6 | 3 | 1 | 1
 | Store 1 | EAN 5 | 1 | 3 | 6 |  | Store 1 | EAN 5 | 1 | 3 | 6 | 0
 | Store 1 | EAN 6 | 3 | 3 | 2 |  | Store 1 | EAN 6 | 3 | 3 | 2 | 0
 | Store 1 | EAN 7 | 7 | 3 | 0 |  | Store 1 | EAN 7 | 7 | 3 | 0 | 0
 | Store 1 | EAN 8 | 8 | 3 | 0 |  | Store 1 | EAN 8 | 8 | 3 | 0 | 0
 | Store 1 | EAN 1 | 1 | 5 | 2 |  | Store 2 | EAN 1 | 1 | 5 | 2 | 0
 | Store 1 | EAN 2 | 2 | 5 | 1 |  | Store 2 | EAN 2 | 2 | 5 | 1 | 0
 | Store 1 | EAN 3 | 4 | 5 | 1 |  | Store 2 | EAN 3 | 4 | 5 | 1 | 0
 | Store 1 | EAN 4 | 3 | 5 | 1 |  | Store 2 | EAN 4 | 3 | 5 | 1 | 0
 | Store 1 | EAN 5 | 6 | 5 | 6 |  | Store 2 | EAN 5 | 6 | 5 | 6 | 5
 | Store 1 | EAN 6 | 5 | 5 | 2 |  | Store 2 | EAN 6 | 5 | 5 | 2 | 0
 | Store 1 | EAN 7 | 7 | 5 | 0 |  | Store 2 | EAN 7 | 7 | 5 | 0 | 0
 | Store 1 | EAN 8 | 8 | 5 | 0 |  | Store 2 | EAN 8 | 8 | 5 | 0 | 0
Spreadsheet: 101898d1299954911-new-column-formula-change-exampleforprofitloss
Sheet: CashFlow_8

 | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec | TOTALS
Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Sales | 13919.582 | 10826.0524 | 14584.2015 | 12736.2449 | 14631.1591 | 16635.6044 | 14655.6216 | 11548.2692 | 13512.9194 | 14050.3503 | 16748.2806 | 16016.3327 | 169864.6181
Total Cash Inflow | 13919.582 | 10826.0524 | 14584.2015 | 12736.2449 | 14631.1591 | 16635.6044 | 14655.6216 | 11548.2692 | 13512.9194 | 14050.3503 | 16748.2806 | 16016.3327 | 169864.6181
Payments | 1020 | 640 | 720 | 700 | 620 | 422 | 511 | 612.17 | 253.25 | 410.25 | 265.89 | 428.5 | 6603.06
Salary | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 48000
Advertising | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 3000
Rent | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 15000
Other overhead costs | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1200
Total Cash Outflow | 6620 | 6240 | 6320 | 6300 | 6220 | 6022 | 6111 | 6212.17 | 5853.25 | 6010.25 | 5865.89 | 6028.5 | 73803.06
Net cash flow | 7299.582000000002 | 4586.0524 | 8264.2015 | 6436.2449 | 8411.159099999999 | 10613.6044 | 8544.6216 | 5336.099199999999 | 7659.669399999999 | 8040.100299999998 | 10882.3906 | 9987.832699999999 | 96061.55809999998
Opening Balance | 10000 | 17299.582 | 21885.6344 | 30149.8359 | 36586.0808 | 44997.2399 | 55610.8443 | 64155.4659 | 69491.5651 | 77151.2345 | 85191.33480000001 | 96073.72540000001 | 608592.5430000001
Closing Balance | 17299.582 | 21885.6344 | 30149.8359 | 36586.0808 | 44997.2399 | 55610.8443 | 64155.4659 | 69491.5651 | 77151.2345 | 85191.33480000001 | 96073.72540000001 | 106061.5581 | 704654.1011000001
 |  | 2011
Spreadsheet: 091dd321-b9ba-481e-8237-bded4bb4e1c5
Sheet: Excel Instruction

EXCEL INSTRUCTIONS FOR FY 2014 AND FY 2015 BUDGET PUBLICATION
BY MINNESOTA SCHOOL DISTRICTS
The FY 2014 and FY 2015 Budget Publication Form ED-00110-36 is provided in an Excel format to include formulas for budget calculations.  The following steps reference cell entries and formulas for both manual and automatic budget section calculations.  FY 2014 BEGINNING FUND BALANCES MAY INCLUDE NEGATIVE NUMBERS.  POSITIVE NUMBERS MUST BE ENTERED IN ALL OTHER CELLS WITHOUT FORMULAS OR THE EXCEL ENTRIES WILL BE INCORRECT.  Cells with formulas have been highlighted in yellow:
FY 14 AND FY 15 ACTUAL/BUDGET COLUMNS AND APPLICABLE FUND CATEGORY ENTRIES
1.  In cells C8-C18, enter FY 2014 Beginning Fund Balances.
2.  In cells [NAME] and D16-D18, enter FY 2014 Actual Revenues and Transfers In.
3.  In cells E8-E14 and E16-E18, enter FY 2014 Actual Expenditures and Transfers Out.
4.  In cell F15, enter the Internal Service Fund June 30, 2014 Actual Fund Balance.
5.  In cells G8-G14 and G16-G18, enter estimated FY 2015 Budgeted Revenues and Transfers In.
6.  In cells H8-H14 and H16-H18, enter estimated FY 2015 Budgeted Expenditures and Transfers Out.
7.  In cell [NAME], enter the Internal Service Fund June 30, 2015 Projected Fund Balance.
[NAME] have been provided in the following cells to automatically calculate entries in items 1 - 7 above:
8.  June 30, 2014 Actual Fund Balances:  Cells F8-F14; F16-F18
9.  June 30, 2015 Projected Fund Balances:  Cells I8-I14; I16-I18
10.Total - All Funds:  Cells C19-I19
LONG-TERM DEBT ENTRIES
1.  In cell C21, enter the Long-Term Debt Outstanding Beginning Balance as of July 1, 2013.
2.  In cell C22, enter the New Issues added to the Long-Term Debt (positive amount).
3.  In cell C23, enter the Redeemed Issues to the Long-Term Debt (positive amount).
4.  A formula has been entered in cell C24 to automatically calculate item 1, plus item 2, minus item 3 to display the Outstanding June 30, 2014 Long-Term Debt balance.
SHORT-TERM DEBT ENTRIES
1.  In cell C26, enter Short-Term Certificates of Indebtedness according to the General Instructions, Section C1.
2.  In cell C27, enter Other Short-Term Indebtedness according to the General Instructions, Section C2.
CURRENT STATUTORY OPERATING DEBT PER MINNESOTA STATUTES, SECTION 123B.81
1.  In cell H22, enter the amount of General Fund Deficit, if any, in excess of 2.5% for General Fund  expenditures 06/30/2014.
COST PER STUDENT - AVERAGE DAILY MEMBERSHIP (ADM) 06/30/14 ENTRIES
1.  In cell H25, enter Total Operating Expenditures according to the General Instructions, Section E1.
2.  In cell H26, enter [NAME] calculated according to the General Instructions, Section E2.
3.  A formula has been entered in cell H27 to automatically calculate item 1, divided by item 2 to display the total FY 2014 Operating Cost Per ADM.
End of worksheet
Spreadsheet: 271365d1381920726-inventory-and-stock-sheet-running-total-calculation-inventory-data
Sheet: stock

PartDesc | Stock | Current Stock
Dual Media Convertor | 20 | 5
Single Media Convertor | 20 | 4
Media Convertor Rack | 20
8 Port I-Ball | 20
16 Port I-Ball | 20
Cat-5 Cable I-Ball 2 Pair | 20
16 Port TP-Link | 20
6 [NAME] | 20
9 [NAME] | 20
15 U Box Wall Rack | 20
15 U Box Floor Standing Rack | 20
22 U Box Floor Standing Rack | 20
FMS 48 Core | 20
FMS 24 Core | 20
Patch Panel Box | 20
Termination Box | 20
Enclosure | 20
48 Fiber With Rope | 20
48 Fiber Armored & Unarmored | 20
24 Fiber Armored & Unarmored | 20
12 Fiber Armored & Unarmored | 20
48 CoreFiber  Unarmored | 20
24 Core Fiber Unarmored | 20
12 Core Fiber Unarmored | 20
6 Core Fiber Unarmored | 20
4 Core Fiber Unarmored | 20
[NAME] | 20
[NAME] | 20
5 MM Steel Rope | 20
4 MM Steel Rope | 20
4.8 MM Steel Rope | 20
Steel Clip 6 Core | 20
Steel Clip 12 Core | 20
Steel Clip 24 Core | 20
Steel Clip 48 Core | 20
[NAME] [[NAME] | 20
Lock | 20
3750 Cisco 24 Port Switch | 20
2960 Cisco 24 Port Switch | 20
2950 Cisco 24 Port Switch | 20
Power Supply Cable | 20
15 [NAME] | 20
Cable Manager | 20
Spreadsheet: 155133d1336677189-change-values-based-on-value-in-combo-box-testrun-spreadsheet-combo-box
Sheet: Query

COLOR | NUMBER | LETTER
white | 1 | a
black | 2 | b |  | number:
grey | 3 | c |  | letter:
yellow | 4 | d
 |  |  | 2
Spreadsheet: 841192d1693416555-extract-text-from-a-cell-extract-text-question-tms
Sheet: Sheet1

 | Expected Answer | Single | Dynamic | Array
AAAA (MRN - 2132321); BBBB (SCH - 23131) | MRN - 2132321
[NAME] (SCHS - 2132321); BadawqB (MRN- 9999) | MRN- 9999 |  | MRN- 9999 | MRN- 9999
CBCDS (SDO - 2132321); BBBB (MRN- 891230); aoqwe (SDHI - 2318923) | MRN- 891230 |  | MRN- 891230 | MRN- 891230
 |  | With Array:
 |  |  | Select all cells first
 |  |  | Enter formula in first cell
 |  |  | Confirm with Ctrl-Shift-Enter
 |  | Dynamic:
 |  |  | may or may not work in 2016
Spreadsheet: 98579d1297435202-excel-2007-transpose-and-offset-fruit
Sheet: Sheet2

If you structure you data like the below in a TABLE you can do [NAME], Exampled below
Fruit | Day | Number
Apples | Monday | 15 |  | Sum of Number | Fruit |  |  |  | Sum of Number | Day
Apples | Tuesday | 20 |  | Day | Apples | Oranges | Grand Total |  | Fruit | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Grand Total
Apples | Wednesday | 22 |  | Sunday | 18 | 23 | 41 |  | Apples | 18 | 15 | 20 | 22 | 30 | 45 | 12 | 162
Apples | Thursday | 30 |  | Monday | 15 | 10 | 25 |  | Oranges | 23 | 10 | 12 | 34 | 23 | 12 | 65 | 179
Apples | Friday | 45 |  | Tuesday | 20 | 12 | 32 |  | Grand Total | 41 | 25 | 32 | 56 | 53 | 57 | 77 | 341
Apples | Saturday | 12 |  | Wednesday | 22 | 34 | 56
Apples | Sunday | 18 |  | Thursday | 30 | 23 | 53
Oranges | Monday | 10 |  | Friday | 45 | 12 | 57
Oranges | Tuesday | 12 |  | Saturday | 12 | 65 | 77
Oranges | Wednesday | 34 |  | Grand Total | 162 | 179 | 341
Oranges | Thursday | 23
Oranges | Friday | 12
Oranges | Saturday | 65
Oranges | Sunday | 23
Spreadsheet: 11e7a320-67da-49fd-98d9-9cbcc2c1e7f8
Sheet: Glucose oxidation

 | Gibbs reaction energy of glucose oxidation as a function of  H2 concentration and temperature
 | Standard gibbs reaction energy |  |  |  |  |  |  |  | H2 aq
 |  |  |  |  |  |  |  |  | kJ/reaction
 |  |  |  |  |  |  |  |  | 25oC |  | 70oC
 | [NAME] H+ + 4 H2 |  |  |  |  |  | eq1
 | [NAME] H+ |  |  |  |  |  | eq2
 | Glucose -> 2 Lactate- + 2 H+ |  |  |  |  |  | eq3
 | Gibbs fromation energy |  |  |  | -ΔGfº
 |  |  |  | KJ/mol
 |  |  |  | 25oC |  | 70oC
 |  |  |  | 298.15 |  | 343.15
 |  | a-D-Glucose, aq |  | -910.3 |  | -923.64 |  | from Amend and [NAME] 2001
 |  | CO2, g |  | -394.36 |  | -404.1 |  | from Amend and Shock 2001
 |  | CO2, aq |  | -387.44 |  | -391.99 |  | from Amend and Shock 2001
 |  | HCO3-, aq |  | -586.94 |  | -591.29 |  | from Amend and Shock 2001
 |  | [NAME], aq |  | -369.33 |  | -373.31 |  | from Amend and Shock 2001
 |  | Lactate-, aq |  | -512.67 |  | -519.06 |  | from Amend and Shock 2001
 |  | Ethanol, aq |  | -181.3 |  | -188.9 |  | from Amend and Shock 2001
 |  | H+, aq |  | 0 |  | 0 |  | from Amend and Shock 2001
 |  | H2, gas |  | 0 |  | -5.97 |  | from Amend and Shock 2001
 |  | H2, aq |  | 17.72 |  | 14.62 |  | from Amend and Shock 2001
 |  | H+ (neutrality), aq |  | -39.98 |  | -42.07 |  | from Amend and Shock 2001
 |  | H20, liq |  | -237.18 |  | -240.57 |  | from Amend and Shock 2001
 |  |  |  | ΔG′ = ΔGo′ + RT ln([C][D] / [A][B]).
 |  | R gas constant (J/mol*K)
 |  | 8.3144621 |  |  |  | M |  |  | [NAME] |  |  | uM
 |  |  |  |  |  | 1 | 0.1 | 0.01 | 0.001 | 0.0001 | 1e-05 | 1e-06 | 1e-07 | 1e-08
 |  | R*T (J/mol) |  |  | LN(x)
 | 298.15 K |  |  |  | (RT)*LN(x)
 | 343.15 K |  |  |  | (RT)*LN(x)
 |  | R | T | ΔGo′ |  | ΔG′
H2 (aq), 298.15 K |  |  | 298
H2 (aq), 343.15 K |  |  | 343.15
 |  |  |  | Lac, 298.15
 |  |  |  | Lac, 343.15
 |  |  |  | EtOH, 298.15
 |  |  |  | EtOH, 343.15
 |  |  |  |  |  |  |  | Intercepts |  | Ace, Lac | Ace, EtoOH
 |  |  |  |  |  |  |  |  |  | M | M
 |  |  |  |  |  |  |  | H2 (aq), 298.15 K
 |  |  |  |  |  |  |  | H2 (aq), 343.15 K
Spreadsheet: 215129d1361275228-product-price-list-and-invoice-electrician_parts_db_example
Sheet: db

name | cost ($) | type | etc (other cathegories)
screwdriver | 1 | tool | x
cable | 2 | material | x
connector | 3 | product | x
lightbulb | 4 | product | x
Spreadsheet: 721023d1614431892-adding-a-column-of-euros-book2
Sheet: Sheet1

 | EU €8.12
 | EU €8.12
 | EU €8.12
 | EU €8.13
 | EU €8.19
 | EU €8.22
 | EU €8.24
 | EU €8.37
 | EU €8.49
 | EU €8.86
 | EU €8.86
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.90
 | EU €9.98
TOTAL
Spreadsheet: sally_beck__35235__EGM_MgmtSum-Q4-1116
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-12-01 00:00:00 | 4TH QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Liquids |  |  | 6246
COAL | Coal |  |  |  |  |  | McKinsey study expenses transferred to Transportation
SO2 | Emissions |  |  |  |  |  | Nox Tech R&D Project
WEATHER | Weather
INSURANCE | Global Risk Markets
ECT_INV_IRFX | Financial Trading
 | Transportation |  |  | 0 |  |  | McKinsey study
 | Office of the Chairman |  | 750 | 0 |  |  | Addition of Finance Group
 | Subtotal
 | LNG |  |  | 1385 |  |  | Development expenses over plan
 | Middle East |  | 2044 | 1536 |  |  | Increase in overhead cost
 | Puerto Rico |  | 1056 |  |  |  | Development expenses under plan
 | Subtotal Commercial
 | Total
 | Group |  |  |  |  |  | Unplanned IT and legal expenses
 | Other Interest Related Charges |  | 0 | 0
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
Spreadsheet: 121912d1316507125-sumproduct-array-not-working-failed-sumproduct-array
Sheet: Sheet1

Date | Sales | Cost
2009-01-01 00:00:00 | 6 | 35
2009-01-01 00:00:00 | 15 | 22
2009-01-01 00:00:00 | 2 | 17
2009-01-01 00:00:00 | 18 | 35
2009-01-02 00:00:00 | 65 | 20
2009-01-02 00:00:00 | 15 | 10
Spreadsheet: 772314d1647195215-filter-texts-with-no-duplicated-sample
Sheet: Sheet1

Department | Name |  | Criteria |  | Result
QWE | QQ |  | AA |  | ASD
ASD | AA |  |  |  | ZD
ADS | DD
ZD | AA
FDS | SS
GFT | DD
ASD | AA
EWQ | QQ
QWE | QQ
Spreadsheet: eric_saibi__9821__092601R
Sheet: Bucksport 01 CTHRSG

Owner Name | Bucksport Energy LLC
Station Name | Bucksport Cogen
Unit Name | Unit 01 CT/HRSG
NERC Region | NPCC
State | ME
Fuel Type | Natural Gas
Capacity | 175 MW
Start Date | 2001-09-25 00:00:00
End Date | 2001-09-27 00:00:00
Prv. Start Date | 2001-09-25 00:00:00
Prv. End Date | 2001-09-26 00:00:00
Comments | [NAME]
SIC | 4931
Plant ID | 1037915
Unit ID | 1012261
Outage ID | 15790
Spreadsheet: 01b51d9f-dd39-4ba0-8004-a624752f6cb0
Sheet: +40 MS 

BWF World Senior Championships 2013
MS 40 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 71641 |  | DEN |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 92663 |  | SRI |  | Ajith Upendra [NAME] Samarakoon Miriyagodage
4 | 73649 |  | NOR |  | [NAME]
5 | 99763 |  | IND |  | [NAME]
6 | 77664 |  | FRA |  | Romain Haug
7 | 62831 |  | BEL |  | [NAME]
8 | 58353 |  | TUR |  | [NAME]
9 | 3094 |  | SWE |  | [NAME] [5/8]
10 | 2974 |  | CZE |  | [NAME] Gregor
11 | 94700 |  | JPN |  | [NAME]
12 | 10269 |  | GER |  | [NAME]
13 | 69043 |  | ENG |  | [NAME]
14 | 81963 |  | SLO |  | Aljosa Rovan
15 | 2279 |  | RUS |  | Vadim Nazarov
16 | 68206 |  | ESP |  | Adolfo [NAME]
17 | 64694 |  | JPN |  | Kempo Tsuchiya [3/4]
18 |  |  |  |  | Bye 3
19 | 67384 |  | GER |  | [NAME]
20 | 85353 |  | ENG |  | [NAME]
21 | 61196 |  | NOR |  | [NAME]
22 | 65277 |  | TUR |  | [NAME]
23 | 87906 |  | IND |  | [NAME]
24 | 60171 |  | AUT |  | [NAME]
25 | 5611 |  | INA |  | [NAME] ~ [5/8]
26 | 2009 |  | HUN |  | [NAME]
27 | 3283 |  | SWE |  | [NAME]
28 | 60858 |  | BUL |  | [NAME]
29 | 8273 |  | CZE |  | [NAME]
30 | 77449 |  | DEN |  | Jakob Oestergaard
31 | 86973 |  | FRA |  | Sebastien Grad
32 | 61277 |  | FIN |  | [NAME]
33 | 3947 |  | SUI |  | [NAME]
34 | 7033 |  | CZE |  | [NAME]
35 | 55041 |  | RUS |  | [NAME]
36 | 1583 |  | NOR |  | Oystein Espedal Larsen
37 | 59772 |  | UKR |  | [NAME]
38 | 50593 |  | FRA |  | [NAME]
39 | 4073 |  | IND |  | Srikant [NAME]
40 | 2923 |  | SWE |  | Ulf Svensson [5/8]
41 | 75622 |  | FIN |  | Mika Nissinen
42 | 98071 |  | TUR |  | [NAME]
43 | 76145 |  | ENG |  | [NAME]
44 | 74638 |  | HUN |  | [NAME]
45 | 97512 |  | DEN |  | [NAME]
46 | 75372 |  | JPN |  | [NAME]
47 | 83980 |  | INA |  | [NAME]
48 | 2978 |  | ESP |  | [NAME] [3/4]
49 | 85786 |  | SWE |  | [NAME]
50 | 78113 |  | JPN |  | Takuya Yamamoto
51 | 15473 |  | SRI |  | [NAME]
52 | 99939 |  | IND |  | [NAME]
53 | 5829 |  | CZE |  | [NAME]
54 | 7674 |  | AUT |  | Reinhard Hechenberger
55 | 50592 |  | FRA |  | Phillipe Talbert
56 | 6849 |  | GER |  | [NAME] [5/8]
57 | 76709 |  | CRO |  | [NAME]
58 | 6860 |  | ENG |  | [NAME]
59 | 50024 |  | DEN |  | Aarup Morten
60 | 68551 |  | FIN |  | [NAME]
61 | 7667 |  | TUR |  | [NAME]
62 | 56235 |  | RUS |  | [NAME]
63 |  |  |  |  | Bye 2
64 | 77915 |  | TPE |  | [NAME] [2]
Spreadsheet: 266067d1379493656-help-to-create-forumla-that-automatically-fills-a-row-of-info-when-conditions-match-auto-invoicing
Sheet: Sheet1

Floor | Plot | Unit Type |  | Stage 1 |  |  | Stage 2
GF | 1 | A | Value | 200 | Date | Invoice Ref | 100 | Date | Invoice Ref | THESE FIGURES ARE THE PRICE WE CHARGE THE CUSTOMER
 |  |  | Invoiced | 200 | 2013-01-04 00:00:00 | 455 | 100 | 2013-02-04 00:00:00 | 456 | THESE FIGURES ARE MANUALLY INPUT BY US WHEN WE INVOICE
 |  |  | Paid | 200 | 2013-02-10 00:00:00 |  |  |  |  | THESE FIGURES ARE MANUALLY INPUT BY US WHEN WE GET PAID BY THE CUSTOMER
 |  |  | Outstanding
GF | 2 | B | Value | 300 | Date | Invoice Ref | 130 | Date | Invoice Ref
 |  |  | Invoiced | 300 | 2013-03-04 00:00:00 | 502 | 130 | 2013-04-04 00:00:00 | 671
 |  |  | Paid
 |  |  | Outstanding
SF | 3 | C | Value | 400 | Date | Invoice Ref | 160 | Date | Invoice Ref
 |  |  | Invoiced | 400 | 2013-05-04 00:00:00 | 722 | 160 | 2013-05-04 00:00:00 | 722
 |  |  | Paid
 |  |  | Outstanding
When I manually type in the invoice Ref, I want the floor, plot, house type, stage and amount to appear as a list on sheet 2.
Spreadsheet: 220615d1363203246-question-on-how-to-return-maximum-value-out-of-a-conditional-statement-testjobs-solution
Sheet: 2.17 Source Data

Start Date | Workload Name | [NAME] | Service Start Time | Service End Time | Delay Time | Running Seconds | Estimated Cost | Actual CPU Cost
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:00.910000 | 2012-02-17 07:00:01.980000 | 2012-02-17 07:00:06.470000 | 1.07 | 4.49 | 57 | 12.5
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:00.950000 | 2012-02-17 07:00:01.690000 | 2012-02-17 07:00:08.250000 | 0.74 | 6.56 | 306 | 35.446
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:01.910000 | 2012-02-17 07:00:02 | 2012-02-17 07:00:05.640000 | 0.09 | 3.64 | 537 | 35.911
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:02.820000 | 2012-02-17 07:00:02.860000 | 2012-02-17 07:00:05.010000 | 0.04 | 2.15 |  | 2.548
2012-02-17 00:00:00 | WD_ADHOC_MEDIUM | 2012-02-17 07:00:03.170000 | 2012-02-17 07:00:50.910000 | 2012-02-17 07:01:24.040000 | 47.74 | 33.13 | 3194 | 304.218
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:03.620000 | 2012-02-17 07:00:05.460000 | 2012-02-17 07:00:06.340000 | 1.84 | 0.88 | 669 | 53.279
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:05.040000 | 2012-02-17 07:00:10.780000 | 2012-02-17 07:00:22.960000 | 5.74 | 12.18 | 1338 | 79.027
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:06.320000 | 2012-02-17 07:00:06.500000 | 2012-02-17 07:00:08.300000 | 0.18 | 1.8 | 548 | 77
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:07.090000 | 2012-02-17 07:00:07.100000 | 2012-02-17 07:00:07.750000 | 0.01 | 0.65 | 669 | 50.139
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:07.280000 | 2012-02-17 07:00:07.380000 | 2012-02-17 07:00:08.510000 | 0.1 | 1.13 | 80 | 8.554
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:08.290000 | 2012-02-17 07:00:08.450000 | 2012-02-17 07:00:12.360000 | 0.16 | 3.91 | 306 | 33.735
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:08.340000 | 2012-02-17 07:00:08.530000 | 2012-02-17 07:00:10.870000 | 0.19 | 2.34 |  | 16.403
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:08.340000 | 2012-02-17 07:00:08.390000 | 2012-02-17 07:00:09.030000 | 0.05 | 0.64 | 669 | 47.725
2012-02-17 00:00:00 | WD_REPORT_MEDIUM | 2012-02-17 07:00:08.480000 | 2012-02-17 07:20:10.230000 | 2012-02-17 07:20:14.400000 | 1201.75 | 4.17 | 2576 | 257.336
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:08.910000 | 2012-02-17 07:00:08.990000 | 2012-02-17 07:00:10.770000 | 0.08 | 1.78 | 153 | 12.576
2012-02-17 00:00:00 | [NAME] | 2012-02-17 07:00:08.910000 | 2012-02-17 07:00:09.110000 | 2012-02-17 07:00:11.320000 | 0.2 | 2.21 | 75 | 17.682
2012-02-17 00:00:00 | WD_ADHOC_MEDIUM | 2012-02-17 07:00:09.640000 | 2012-02-17 07:04:50.270000 | 2012-02-17 07:16:29.970000 | 280.63 | 699.7 | 144710 | 31229.66
2012-02-17 00:00:00 | WD_REPORT_MEDIUM | 2012-02-17 07:00:09.800000 | 2012-02-17 07:20:14.400000 | 2012-02-17 07:20:45.460000 | 1204.6 | 31.06 | 21725 | 294.181
Spreadsheet: 52373d1252067640-populate-cells-depending-on-criteria-of-other-cell-uploadfile
Sheet: Handicap Groups

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | Old Links |  | Group 1 (0-13.4) = Black
 |  | [NAME] | 7 | 7 |  |  | 8 | 8 | 8 | 8 |  |  |  |  | Group 2 (13.6 - 20.4) = Blue
 |  | BS | 8 | 9 |  |  | 9 | 7 | 7 | 8 |  |  | Fairhaven |  | Group 3 (20.6 - 33.4) = [NAME]
 |  | JF | 7 | 7 |  |  | 8 | 6 | 6 | 7 |  |  |  |  | Group 4 (33.6 - 40) = Green
 |  | BB | 13 | 13 |  |  | 13 | 13 | 13 | 12 |  |  | Clitheroe
 |  | PC | 13 | 13 |  |  | 13 | 13 | 14 | 14
 |  | AL | 13 | 11 |  |  | 11 | 10 | 10 | 10 |  |  | Lancaster
 |  | PM | 13 | 13 |  |  | 13 | 13 | 13 | 13
 |  | SG | 19 | 20 |  |  | 20 | 21 | 21 | 22 |  |  | Pleasington
 |  | MB | 16 | 16 |  |  | 17 | 17 | 17 | 14
 |  | AW | 17 | 17 |  |  | 18 | 18 | 19 | 19 |  |  | Fleetwood
 |  | PW | 18 | 18 |  |  | 19 | 19 | 20 | 20
 |  | TD | 26 | 27 |  |  | 27 | 28 | 28 | 29 |  |  | Shaw Hill
 |  | DS | 27 | 28 |  |  | 23 | 23 | 23 | 24
 |  | [NAME] | 30 | 30 |  |  | 31 | 31 | 31 | 32 |  |  | Green Drive