tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09502f64-44b0-43be-952a-0b3435a4e377
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/131 | 48.5-51.5 | 50.5-53.5 | 68.5-71.5 | 58.5-61.5 | 98.5-101.5 | 52.5-55.5 | 52.0-55.0 | 42.0-45.0
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
September | 53.81 | 55.5 | 75 | 59.75 | 104.5 | 58.21 |  | 47.19
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February1 | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2013-03-12 10:43:56.120000
Spreadsheet: 831024d1685360925-adding-days-giving-wrong-result-adddate
Sheet: Sheet1

days | date | newdate1 | newdate 2 | days |  | hrs |  | min |  | second
17.1 | 2007-04-25 16:54:01
28.5
19.95
51.3
45.6
54.15
48.45
19.95
57
Spreadsheet: 0365308d-ff3e-4738-86e8-ee0424519472
Sheet: Sheet1

 | MSYSA Director's Academy
 | GAME CHANGE REQUEST FORM
 | $100 per Game Change Request
 | Please fill out this form and return with payment (if applicable) AND a written record of both teams agreeing to the change to [EMAIL] or MSYSA, Attn: [NAME], 9401 General Dr. [NAME] 120, Plymouth, MI 48170. The $100 fee applies when the request is made 7-29 days before the originally scheduled game. There is no fee if the request is received 30 ore more days before the originally scheduled game. No schedule changes will be allowed less than 7 days before the originally scheduled game, unless due to weather or field closures. If the reschedule request is due to inclement weather or field closures, the reschedule fee does not apply. However, all other DA Rules shall apply.
 | Club
 | Team Name
 | Team Age |  | Gender
 | Game # |  | Opponent
 |  | ORIGINAL GAME DETAILS |  | NEW GAME DETAILS
 | Date |  | Date
 | Time |  | Time
 | Field |  | Field
 | Name of Person Submitting This Request |  |  | Date
 | For office use only:
 |  | Date Received |  | Payment Method
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: CommonSized

COMMON SIZED FINANCIALS
EMPRESA PRODUTORA DE ENERGIA - EPE
 |  |  |  |  | Opening | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "BS_Table"
BALANCE SHEET |  |  |  |  | Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Assets
 | Cash & Cash Equivalents
 | Inventory - Spares
 | N/R - Shareholder Loans
 | Property, Plant & Equipment
 |  | Cost (Less Sale Of VAT)
 |  | Accumulated Depreciation
 |  | Property, Plant & Equipment (Net)
 | Land
 | Deferred Tax Asset
Total Assets
Liabilities
 | Deferred Tax Liability
 | Bridge Loan
 | Senior Debt
 | Subordinated Debt
 |  | Total Liabilities
Stockholders' Equity
 | Capital Stock (Common & Preferred)
 | Sudam Tax Credit Reserve
 | Net Income
 | Cashflow Distributed
 | Total Stockholders' Equity
Total Liabilities & Stockholders' Equity
INCOME STATEMENT
Gross Revenue
Less: PIS / COFINS
 | Net Revenues
Commodity Fuel Expense
Transportation & Take Or Pay
Operations & Maintenance
 | Total Operating Expenses
Other Income / (Expenses)
Earnings Before Depr, Int, & Taxes
Depreciation
Interest Expense - Senior Debt
Interest Expense - Subordinated Debt
IDC To Be Expensed
 | Total Depreciation & Interest
Income Before Income Taxes
Less: INE Interest Expense
Provision For Income Taxes (Income & Surtax)
Add: Sudam Credits Applied Against Losses
Net Income
[NAME] |  |  |  |  | Avg | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Return on Invested Capital
ROA
ROE
Profitability
Operating Profit Margin
Net Profit Margin
Operating CF to Income
Asset Utilization
Asset Turnover
Cash Turnover |  |  |  |  | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m
Net Fixed Asset Turnover
Liquidity
Current Ratio |  |  |  |  | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m
[NAME] |  |  |  |  | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m | n/m
Interest Coverage (EBIT/Interest)
Debt Service Coverage (EBITDA/Debt Service) |  |  |  |  |  | n/a | n/a | n/a | n/a
Spreadsheet: 807428d1669900010-2-if-conditions-to-return-value-from-anothr-cell-if-true-multiple-if-returns-cell-value
Sheet: Sheet1

Person | Activity | Day |  |  | Swimming | Table Tennis | Gym
Gemma | Swimming | Friday |  | Gemma | Friday
Julie | Gym | Saturday |  | Julie |  |  | Saturday
[NAME] | Table Tennis | Monday |  | [NAME] |  | Monday
Ray | Swimming | Tuesday |  | Ray | Tuesday
[NAME] | Gym | Thursday |  | [NAME] |  |  | Thursday
 |  |  |  | Carol
 |  |  |  |  | IF B:B matches F1 and A:A matches E2, return text from cell C2
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Yifan

Maand
 | 2020-01-25 00:00:00 | 2020-02-07 00:00:00 | 2020-02-21 00:00:00
[NAME] | Space Oddity |  | Michel
 | [NAME] (by Anouk) |  | My Girl | https://www.youtube.com/watch?v=2DRgEBYt5MA
 | Let it Be |  | Chords formulas
 |  |  | Strumming patter
 |  |  | Fast Car
 | [EMAIL]
 | [NAME]
 | https://www.youtube.com/watch?v=GtDRcXtDg-4
 | [EMAIL]
 | appr | cash | cash
 | Totaal aantal lessen
 |  |  |  | een nederlands iedje
 | Space Oddity?
 | Let it be?
 | Ritme?
 | Do i wanna know?
 | 30 |  | maand
 |  | Januari
 |  | Februari
 |  | [NAME]
 |  | april
 |  | mei
 | MY Girl | juni
 |  | [NAME]
 |  | augustus
 |  | september
 |  | oktober
 |  | november
 |  | december
 | cash
Spreadsheet: 132ff8eb-9cbf-4d7d-9f38-3ddf3867e84c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 114107d1309959273-mass-copy-1-template-to-another-old-version-example
Sheet: Operation 060

 | Part # | JI-84401397 |  | Work Center | REPETITIVE WELD
 | Revision | A |  | Operation | 060
 |  |  |  |  | Sheet 1 of 1
 | Dimension | 701.8mm | 113mm | 43.6mm
 | Tolerance | ±1.5[NAME] | ±1.5[NAME] | [NAME] | ± |  | Job Number
 | Measurment [NAME] | Tape / Square | Caliper | Height gauge
 |  |  |  | Caliper
 |  |  |  |  |  |  | Initials | Date
 | 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
 | 1. Inspection frequency to follow [NAME] WI-0035
 | 2. When form is complete, place in tray outside of QA door.
 | 3.
 | 4.
 | 5.
 | 6.
 | 7.
 | 8.
 | 9.
 | 10.
Spreadsheet: 169186d1342720206-combining-if-statement-vlookup-ef128_sample-book
Sheet: All

Client Name | Client Since | Month | Industry | Budget | Traffic | Traffic Status | Leads | [NAME] | Coversion Rate | Conversions Status | New Visits | [NAME] | Page / Visits | Time on Site |  | seq
Company A |  | 2012-06-01 00:00:00 | Dental | 1199 | 190 |  | 8 |  |  |  | 0.8622 | 0.6531 | 2.35 | 1 mins 59 secs
Company B |  | 2012-06-01 00:00:00 | Dental | 1199 | 381 |  | 32 |  |  |  | 0.8338 | 0.5422 | 2.76 | 1 mins 25 secs
Company C |  | 2012-06-01 00:00:00 | Dental | 2000 | 324 |  | 39 |  |  |  | 0.7284 | 0.5247 | 2.91 | 2 mins 30 secs
Company D |  | 2012-06-01 00:00:00 | Dental | 1199 | 326 |  | 37 |  |  |  | 0.8374 | 0.6074 | 2.29 | 1 mins 26 secs
Company E |  | 2012-07-01 00:00:00 | Dental | 1199 | 424 |  | 36 |  |  |  | 0.7215 | 0.3991 | 2.69 | 2 mins 06 secs
Company F |  | 2012-07-01 00:00:00 | Dental | 699 | 1246 |  | 24 |  |  |  | 0.7191 | 0.5907 | 2.27 | 2 mins 27 secs
Company G |  | 2012-07-01 00:00:00 | Dental | 1199 | 306 |  | 12 |  |  |  | 0.7241 | 0.4483 | 4.02 | 5 mins 09 secs
Company H |  | 2012-07-01 00:00:00 | Dental | 2500 | 476 |  | 104 |  |  |  | 0.771 | 0.4811 | 3.11 | 2 mins 51 secs
Company I |  | 2012-07-01 00:00:00 | Dental | 1199 | 432 |  | 24 |  |  |  | 0.6366 | 0.0069 | 4.39 | 1 mins 59 secs
Spreadsheet: 00265fc2-46ad-4960-b54a-d224e8dbbac5
Sheet: Sheet1

SPACE EVALUATION CHECKLIST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
CHARACTERISTICS | SITE 1 | SITE 2 | SITE 3 | SITE 4 | COMMENTS
Building Considerations
Building management is amenable to Green Workspace goals.
Building management has sustainable practices in place for purchasing and/or cleaning.
The building meets current codes including seismic and ADA requirements or owner will update at owner’s expense.
The building has been certified under the U.S. Green Building Council [NAME] -OR- Earth Advantage -OR- EPA Energy Star
Other:
Other:
Site Considerations
The building location provides convenient and inexpensive commute options, including easy access to mass transit and safe bicycle and pedestrian routes.
Showers and changing facilities for employees are available.
The parking area allows preferred parking spaces for carpools and bicycles
The site design supports clean watersheds by limiting impervious paving and by managing stormwater on the site.
Landscaping is primarily native or hardy plants, maintained with minimal irrigation water and without the use of chemical fertilizers, herbicides or pesticides.
The building is located close to necessities such as day care, banks, food, dry cleaners, ice cream.
Other:
Other:
Resource Efficiency
Tap water is clean and odor-free or is filtered.
The building is equipped with water-efficient fixtures meeting EPA WaterSense standard: toilets, faucet aerators and shower heads, and automatic faucet shutoffs.
Records of past energy usage are available.
The building gets some or all energy from renewable resources.
The building is enrolled in a local utility green power program.
The heating, cooling and ventilation system is within the typical service life of 15 to 30 years and has been maintained regularly.
Building HVAC and other systems have been commissioned recently.
Other:
Other:
Health Considerations
The building shows no evidence of mold or moisture damage, such as plumbing leaks, roof leaks, flooding or condensation. If either mold or moisture damage has occurred, check all documentation about remediation and follow-up testing, and have it reviewed by a knowledgeable IAQ professional before leasing.
The lease has provision for tenant protection from future moisture damage or mold caused by building failures, such as leaks.
The building has been tested/checked for the presence of hazardous materials, including radon gas, asbestos, and lead (in paint or tap water).
If testing showed the presence of hazardous materials, the management can show mitigation according to EPA guidelines, and provide evidence that levels are currently within EPA guidelines.
There are no other occupants or activities in the building that may generate odors, noise or potentially hazardous fumes.
Workspaces will be protected from odors and fumes when re-roofing occurs.
Other:
Other:
Spreadsheet: 155987d1337124678-lookup-for-a-value-select-a-value-from-results-based-on-a-condition-sample-worksheet
Sheet: Sheet1

Job | Completion Time | Next Pickup Time |  |  | Job | Pick Up Time
1 | 11:00:00 |  |  |  | 1 | 11:30:00
2 | 16:00:00 |  |  |  | 1 | 12:30:00
3 | 19:15:00 |  |  |  | 1 | 13:30:00
4 | 22:30:00 |  |  |  | 2 | 14:30:00
5 | 16:00:00 |  |  |  | 2 | 17:30:00
6 | 19:15:00 |  |  |  | 3 | 16:30:00
7 | 19:15:00 |  |  |  | 3 | 20:30:00
 |  |  |  |  | 4 | 18:30:00
 |  |  |  |  | 4 | 19:30:00
 |  |  |  |  | 4 | 23:30:00
 |  |  |  |  | 5 | 21:30:00
 |  |  |  |  | 6 | 22:30:00
 |  |  |  |  | 6 | 20:30:00
 |  |  |  |  | 7 | 21:30:00
 |  |  |  |  | 7 | 22:30:00
Spreadsheet: 880243d1727876208-counting-occurences-between-a-certain-value-based-upon-unique-identifier-test-score-interval
Sheet: Sheet1

Scenario - In Office30, I want to calculate how many test iterations have occurred between when a student first fell below an initial A and when they got their next A. I will subsequently calculate the average number of test iterations it takes for a person to get back to an A after  failing to achieve an A. I have the data in the vertical view (many other fields), but these are the key aspects (I think).  It is important to note, that one student (student 6 below) may "perpetually" bounce between an A and a B.  I would like to be able to account for each instance that occurs for that one student.
Vertical Data View |  |  |  |  | Horizontal Data View |  | Test Iteration #
Student# | Test Iteration # | Grade |  |  |  | Student | 1 | 2 | 3 | 4 | 5 | 6 | Remarks about this data
1 | 1 | A |  |  |  | 1 | A | B | A | - | - | - | Test1 - A.  Test 2 the student fell below an A, Test 3 the student got an A.  Test iterations = 1
1 | 2 | B |  |  |  | 2 | B | A | B | B | A | - | Test2 - A. Test 3 the student fell below an A, Test 5 the student got an A.  Test iterations = 2
1 | 3 | A |  |  |  | 3 | B | B | B | B | B | - | Student has never received an A.  Test iterations = 0
2 | 1 | B |  |  |  | 4 | A | A | A | A | A | - | Student has never received less than an A.  Test iterations = 0
2 | 2 | A |  |  |  | 5 | A | B | B | A | B | B | Test1 - A. Test 2 the student fell below an A, Test 4 the student got an A.  Test iterations = 2. Test 5, the student fell below an A.  But there are not enough tests to determine if the student ever increased back to an A.  Test iterations = unknown.
2 | 3 | B |  |  |  | 6 | A | B | A | B | B | A | Test1 - A.  Test2 the student fell below an A. Test 3 - A.  Test iterations = 1.  Test4, the student fell below an A.  Test 6 -  A.  Test iterations = 2
2 | 4 | B
2 | 5 | A
3 | 1 | B
3 | 2 | B
3 | 3 | B
3 | 4 | B
3 | 5 | B
4 | 1 | A
4 | 2 | A
4 | 3 | A
4 | 4 | A
4 | 5 | A
5 | 1 | A
5 | 2 | B
5 | 3 | B
5 | 4 | A
5 | 5 | B
5 | 6 | B
6 | 1 | A
6 | 2 | B
6 | 3 | A
6 | 4 | B
6 | 5 | B
6 | 6 | A
Spreadsheet: 123487d1317678619-excel-2007-data-auto-populate-hlookup-or-andif-help
Sheet: Sheet1

 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | etc
[NAME] Could be up to 15 days duration) | A | A | A | A
Date | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 2011-10-11 00:00:00 | 2011-10-12 00:00:00 | 2011-10-13 00:00:00 | 2011-10-14 00:00:00 | 2011-10-15 00:00:00 | 2011-10-16 00:00:00 | 2011-10-17 00:00:00 | 2011-10-18 00:00:00 | 2011-10-19 00:00:00 | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | etc
Task Start (Auto input from another sheet) | A |  |  |  |  |  |  |  |  |  |  |  | A
Duration (Needs to replicate row 2 at each task start) | A | A | A | A |  |  |  |  |  |  |  |  | A | A | A | A
 | Can someone please help find me a formula to feed into row 6?
 | is this an hlookup? Can it be done with AND/OR/IF?
Spreadsheet: 8a87e755-cd64-4e26-a660-7c5a419aa363
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (1 Entry):
 | 14 Wireless 14.3 Wireless applications 14.3.3 Music
No. | Company | Country | City | [NAME] | Hall/Booth
1 | GREATech GmbH | Germany | Mülheim/Ruhr | 45478 | A4.466
Spreadsheet: 169405d1342809833-inventory-age-formula-needed-for-fifo-inventory-inv-age-exercise
Sheet: Part Master Query

Part | Description | Sum Of TotalOH |  | 2012-07-01 00:00:00 |  | Jul Balance |  | 6/12/2012 Purchase |  | [NAME] |  | 5/1/2012 Purchase |  | May Balance |  | 4/1/2012 Purchase |  | April |  | [NAME] |  |  |  | 2/1/2012 Purchase |  | 2012-01-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2011-10-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-08-01 00:00:00
001042 | 3 IN POWDER COAT HOOK 2032 MM DIA
010457 | 400W MH PULSE START BALLAST | 32
010485 | T5 VHO Replacement Ballast 240 Volt | 294 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  | 150
010489 | [NAME] horse 22 | 208 |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  | 300
010491 | T5 HO BALLAST NO.B454PUNV-E010C | 11
010492 | T5HO BALLAST B254PUNV-D 54WAT | 8
010493 | Fulham T5 HO Workhorse 5 | 432 |  |  |  |  |  |  |  |  |  | 600 |  |  |  | 600 |  |  |  | 100 |  |  |  | 400 |  | 350 |  |  |  | 300 |  | 300 |  |  |  | 200
010494 | T5 VHO Replacement Ballast 120 Volt | 150 |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  | 100
010495 | T5HO BALLAST NO.B239PUNV-C 24W | 16
010496 | Fulham T5 HO Workhorse 3 | 251 |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 200
010497 | FULHAM RACE HORSE 454
010498 | Fulham T5 HO Workhorse 7 | 987 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500 |  | 150 |  |  |  | 300
010499 | T5HO BALLAST W 50IN LEADS NO.B | 77
010550 | BALLAST T-5HO 54W 2 LMP PROG S | 68
010555 | T5 HO Replacement Ballast 54W 4 Lamp | 255 |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 200 |  | 200 |  |  |  | 300 |  |  |  |  |  | 408
010560 | T5 80WATT BALLAST | 15
010565 | LIFI -STA-41-02
010675-8 | SOCKET MOUNT -  SUPER SUN | 131
010695-1 | HOUSING -  SUNGRO
010695-10 | SOCKET ADJ. STUD STRAP -  SUNGRO
010695-14 | SOCKET ASSEMBLY COMPLETE - SUNGR
Spreadsheet: mary_fischer__25619__77L
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L
COMPANY NAME   PBM Mechanical Inc.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
Payroll Taxes on Old Sytem - cutover balance |  | 0 |  |  |  | -199100
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 856175d1705518773-filter-returning-multiple-columns-not-working-inside-byrow-filter-function-returning-multiple-columns-inside-byrow
Sheet: Sheet1

ID | Name | Telp | [NAME]
A1 | [NAME] | [PHONE] | [EMAIL]
A2 | [NAME] | [PHONE] | [EMAIL]
A3 | [NAME] | [PHONE] | [EMAIL]
A4 | [NAME] | [PHONE] | [EMAIL]
Desired Result of cell B10:C11 as dynamic array
dependent on the size of column A (in this case A10:A11)
ID | Name | Telp | [NAME]
A2 | [NAME] | [PHONE] | [EMAIL]
A4 | [NAME] | [PHONE] | [EMAIL]
FILTER FUNCTION that works for each column
 | [NAME] | [PHONE] | [EMAIL]
Name | =BYROW($A$10:$A$11, LAMBDA(x, FILTER(Table1[Name], Table1[ID]=x)))
Telp | =BYROW($A$10:$A$11, LAMBDA(x, FILTER(Table1[Telp], Table1[ID]=x)))
[NAME] | =BYROW($A$10:$A$11, LAMBDA(x, FILTER(Table1[Email], Table1[ID]=x)))
Spreadsheet: 843572d1695364125-finding-values-in-a-table-when-x-is-entered-in-a-cell-test-file
Sheet: Sheet1

 | Employee 1 | Employee 2 | Employee 3 | Employee 4 | Employee 5 | Employee 6 | Employee 7 | Employee 8 | Employee 9 | Employee 10
Access 1 | x | x |  |  |  | x |  | x
Access 2 |  |  |  |  | x | x | x | x | x
Access 3 |  |  | x |  | x | x | x |  | x | x
Access 4 |  | x |  | x |  | x |  | x | x | x
Access 5 | x |  | x | x | x | x |  | x | x | x
Access 6 |  |  |  |  | x | x | x | x |  | x
Access 7 | x | x |  | x | x | x |  | x
Access 8 |  |  |  |  |  | x | x | x |  | x
Access 9 | x | x |  | x | x | x |  |  | x | x
Access 10 |  |  | x |  |  | x |  |  | x | x
Access 11 |  |  |  |  | x | x |  | x | x | x
Access 12 | x | x |  | x |  | x | x |  | x | x
Access 13 |  |  |  | x |  | x |  | x | x | x
Access 14 |  |  |  |  |  | x | x | x | x
Access 15 | x |  | x | x |  | x |  | x | x
Access 16 |  |  | x |  |  | x | x | x |  | x
Access 17 |  |  |  |  |  | x |  | x | x | x
Access 18 |  |  |  |  |  | x |  | x |  | x
DROPDOWN | Answer from table
Employee 4 | Access 4, Access 5, Access 7, Access 9, Access 12, Access 13, Access 15