tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685292d1593885444-multiple-conditon-formula-for-monthly-spend-example
Sheet: example

 | Date | example | example2 | example3 | example4 | Price | Paid? | [NAME]? | Notified? |  |  | Total Month Spend:
 | 2020-01-01 00:00:00 |  |  |  |  | 0.5 | Y | Y | N |  |  | Currency: | $ | £
 | 2020-01-01 00:00:00 |  |  |  |  | 12 | Y | N | N |  |  | Jan
 | 2020-03-03 00:00:00 |  |  |  |  | 50 | Y | Y | Y |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 771134d1646437651-generate-categories-from-values-if-function-match-book1-enigma909-
Sheet: Sheet1

1.0 | Apple |  | 1
1.01 | Apple1 |  | 2
1.01.01 | Apple3 |  | 3
2.0 | [NAME]
2.01 | Banana1
3.0.0.1.2 | Pear3
Spreadsheet: 169563d1342952048-problem-with-if-or-within-my-time-sheet-or-perhaps-its-just-too-early-wages
Sheet: October

DAY | IN | OUT | Tot | OT | [NAME] |  |  | Sat | Sun
2012-10-01 00:00:00
2012-10-02 00:00:00
2012-10-03 00:00:00
2012-10-04 00:00:00
2012-10-05 00:00:00
2012-10-06 00:00:00
2012-10-07 00:00:00
2012-10-08 00:00:00
2012-10-09 00:00:00
2012-10-10 00:00:00
2012-10-11 00:00:00
2012-10-12 00:00:00
2012-10-13 00:00:00
2012-10-14 00:00:00
2012-10-15 00:00:00
2012-10-16 00:00:00
2012-10-17 00:00:00
2012-10-18 00:00:00
2012-10-19 00:00:00
2012-10-20 00:00:00
2012-10-21 00:00:00
2012-10-22 00:00:00
2012-10-23 00:00:00
2012-10-24 00:00:00
2012-10-25 00:00:00
2012-10-26 00:00:00
2012-10-27 00:00:00
2012-10-28 00:00:00
2012-10-29 00:00:00
2012-10-30 00:00:00
2012-10-31 00:00:00
Spreadsheet: 546414d1510044248-limit-calculated-value-to-18-000-if-age-50-then-26-000-if-50-401-k-savings-calculator
Sheet: Desired Income

Desired Income
Annuity Calculator
Years of  Retirement | Age | 401K Savings  Balance | Desired  Annual Income |  |  | Return  Rate | Return on  Investment | Balance
Spreadsheet: 153195d1335800285-inserting-deleting-a-row-with-a-macro-new-take-off-sheet-test
Sheet: dropdown order

System List
Ballast_Controllers
Relay_Controllers
Ecolinx_LCM
Multipurpose_Controllers
Leading_Trailing_Edge_Controllers
DR2PE_Scene_Plates
DPNE_Scene_Plates
DPWE_Scene_Plates
DLPE_Scene_Plates
Touchscreens
Timeclocks
Sensors
System_Integration
Network_Acessories
Software
Remote_Controls
Leads_Plugs
Fixture_Couplers
Occuswitch
Light_Master_Modular
LMM_Scene_Setting
LMM_Panels & Additional Products
General_Purpose
Colour_Chaser_DMX_Controls
LMM_Leads_Plugs
Trios
Spreadsheet: 678140d1589729704-calculating-football-results-scores-for-fantasy-league-footy-predictions-bundesliga-aligw
Sheet: Sheet1

 |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Will
Home Team | Away Team | Home Score | Away Score | [NAME] | Home Score | Away Score | Predicted [NAME] | Score | Home Score | Away Score | Predicted [NAME] | Score | Home Score | Away Score | Predicted [NAME] | Score
Borussia Dortmund | Schalke | 4 | 0 | HW | 2 | 1 |  |  | 3 | 1 |  |  | 2 | 1
Augsburg | Wolfsburg | 1 | 2 | AW | 0 | 1 |  |  | 1 | 0 |  |  | 2 | 0
Dusseldorf | Paderborn | 0 | 0 | D | 1 | 1 |  |  | 2 | 1 |  |  | 2 | 1
RB Leipzig | Freiburg | 1 | 1 | D | 3 | 0 |  |  | 3 | 0 |  |  | 4 | 0
Hoffenheim | [NAME] | 0 | 3 | AW | 2 | 0 |  |  | 1 | 1 |  |  | 0 | 0
Frankfurt | [NAME] | 1 | 3 | AW | 1 | 3 |  |  | 1 | 3 |  |  | 1 | 1
Koln | [NAME] |  |  |  | 1 | 0 |  |  | 0 | 0 |  |  | 1 | 0
Union Berlin | Bayern Munich |  |  |  | 1 | 4 |  |  | 0 | 4 |  |  | 0 | 3
[NAME] | [NAME] |  |  |  | 1 | 2 |  |  | 1 | 1 |  |  | 0 | 0
Spreadsheet: 86230d1286251970-best-price-spreadsheet-packing-20cost-20evaluation-1-
Sheet: Greenwoods

Greenwoods
 | Price
Europa 1/1 | 1
Europa 1/2 | 2
50mm Clear Tape | 3
25mm Clear tape | 4
Fragile Tape | 5
Pallet Wrap | 6
Bubble Wrap | 7
Grip top bags 3.5"x4.5" (per 1000) | 8
Grip top bags 4.5"x4.5" (per 1000) | 9
Grip top bags 3x7.5" (per 1000) | 10
Open ended poly bags 10"x12" (per 1000) | 11
Open ended poly bags 12"x15" (per 1000) | 12
Open ended poly bags 15"x20" (per 1000) | 13
Open ended poly bags 18"x24" (per 1000) | 14
Open ended poly bags 24"x36" (per 1000) | 15
Spreadsheet: 1fe8f880-7c4c-45bf-830b-763f1dc3dddc
Sheet: Sheet1

 | IB 372/EUS 348  European Union Commercial Environment
 | [NAME], Esq.
 | DATE |  | TOPIC | Text/Reading Assignments*
 | Jan | 18 | Course Overview | Reading/Syllabus
 |  | 20 | History - The End of WWII & The Origins of the EU | Course Materials
 |  | 25 | History - Expansion and further Integration | Course Materials
 |  | 27 | History - The European Union | Course Materials
 | Feb | 1 | History - A new Century - Constitutionalism & Lisbon | Course Materials
 |  | 3 | Quiz
 |  | 8 | Structure - The Commission | Course Materials
 |  | 10 | Structure - The Council of Ministers | Course Materials
 |  | 15 | Structure - The European Council | Course Materials
 |  | 22 | Structure - The European Parliament | Course Materials
 |  | 24 | Structure - The Committees & The Court | Course Materials
 | Mar | 1 | Types of Law & Legislative Procedures | Course Materials
 |  | 3 | The Authority of EU Law | Course Materials
 |  | 8 | The Authority of EU Law | Course Materials
 |  | 10 | Midterm Exam
 |  | 15 | Spring Break
 |  | 17
 |  | 22 | Economic & Monetary Union | Course Materials
 |  | 24 | Economic & Monetary Union | Course Materials
 |  | 29 | The Free Movement of Goods | Casis
 | Apr | 5 | The Free Movement of Goods | Course Materials
 |  | 7 | The Free Movement of Services | Course Materials
 |  | 12 | The Free Movement of Services - Occupation | Course Materials
 |  | 14 | Trade Restrictions - The Public Good & The Environment | Course Materials
 |  | 19 | E-Commerce | Course Materials
 |  | 21 | E-Commerce | Course Materials
 |  | 26 | Competition | Course Materials
 |  | 28 | Culture | Course Materials
 | May | 3 | Antitrust & Monopolies | Course Materials
 |  | 5 | Course Wrap-Up/Review/Final Exam Info
 |  | 7 | FINAL EXAM (7:00 PM - 10:00 PM)
 | * note that other assignments may be included during the semester
 | SCHEDULE IS SUBJECT TO CHANGE
Spreadsheet: 674654d1587977706-need-formula-to-post-payments-with-different-dates-frequency-than-column-headers-date-range2
Sheet: CASH FLOW FORECAST

Each Payment= | 500
 | Year
 | Date: FROM | 2019-11-01 00:00:00
 | TO Date
Pay Frequency | Start Date
Weekly | 2019-12-02 00:00:00
Bi-Weekly | 2019-12-02 00:00:00
Monthly | 2019-12-02 00:00:00
[NAME] | 2019-12-02 00:00:00
Quarterly | 2019-12-02 00:00:00
Spreadsheet: 00ee2d8f-d814-4838-9765-07f14fee3f8b
Sheet: Sheet1

LEGAL SERVICES TRUST FUND PROGRAM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
PROPOSED CARRY-OVER BUDGET
 |  | Grant Year: |  | Fund: | IOLTA
 | 1. | Program Name:
 | 2. | Budget Prepared By: |  |  | Telephone #:
 |  | E-mail:
 | 3. | County: |  |  | Allocation:
 | ACCOUNT TITLE |  | (1) | (2) | (3) |  | (4)
 |  |  | CURRENT APPROVED BUDGET (TOTAL) | [NAME] THROUGH JUNE 30 | PROPOSED CARRY-OVER BUDGET (UNSPENT FUNDS ONLY) |  | REVISED BUDGET TOTAL* (Col. 2+3)
 |  |  |  |  | PROGRAM | ADMIN.
 | PERSONNEL
 | 4. | Lawyers |  |  |  |  | 0
 | 5. | Paralegals |  |  |  |  | 0
 | 6. | Other Staff |  |  |  |  | 0
 | 7. | SUBTOTAL | 0 | 0 | 0 | 0 | 0
 | 8. | Employee Benefits |  |  |  |  | 0
 | 9. | TOTAL PERSONNEL | 0 | 0 | 0 | 0 | 0
 | NON-PERSONNEL
 | 10. | Space |  |  |  |  | 0
 | 11. | Equipment Rent/Maint. |  |  |  |  | 0
 | 12. | Supplies/Printing/Postage |  |  |  |  | 0
 | 13. | Telecommunications |  |  |  |  | 0
 | 14. | Program Travel |  |  |  |  | 0
 | 15. | Training |  |  |  |  | 0
 | 16. | Library |  |  |  |  | 0
 | 17. | Insurance |  |  |  |  | 0
 | 18. | Audit |  |  |  |  | 0
 | 19. | Litigation |  |  |  |  | 0
 | 20. | Capital Additions |  |  |  |  | 0
 | 21. | Contract Services/Clients |  |  |  |  | 0
 | 22. | Contract Services/Program |  |  |  |  | 0
 | 23. | Other |  |  |  |  | 0
 | 24. | TOTAL NON-PERSONNEL | 0 | 0 | 0 | 0 | 0
 | 25. | RESERVED FUNDS
 | 26. | GRAND TOTAL | 0 | 0 | 0 | 0 | 0
 | 27. | Budget reviewed by:
 |  |  | (Program Director's signature)
 | *Budget Narrative required if column 4 is materially different from column 1, refer to Article IV of General Grant Provisions.
Spreadsheet: 874099d1720666901-reshaping-data-reshaping-data-in-excel-1-
Sheet: Output

 | Training was interesting and engaging | training content was clear to understand | The training was relevant to your work/job role | the instructor(s) demonstrated command over the subject | Queries were responded in a timely manner | I felt part of a learning community | I am likely to apply this new knowledge to my current/future work | I am likely to recommend this course to a colleague
Strongly agree
Agree
Neither agree nor disagree
Disagree
Strongly disagree
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-173

 |  |  |  |  |  |  | 7 | 173
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 878291d1725363685-text-split-reduce-problem-supervisorptcl-excel-help-forum-test-xlsx-365-aligw
Sheet: Sheet1

text strings | formula | expected result | giving result
[NAME]: MSAG-14 Firdous to L Block Gulberg-III to DC-13 61-L-1 Block Gulberg-III |  | [NAME] | OK
SMD: OLT-1 to C-43 Ichra Police Station |  | SMD | OK
3071-New Islamia Park Ufone to 3075-Clifton Colony Ufone |  | islamia park | [NAME] colony ufone
8069-Kahna (11/0/2) to C-10K Royal Residencia |  | Kahna | 10K Royal Residencia
8060-BTN to 1376-PTCL Maraka Exchange |  | BTN | PTCL Maraka Exchange
SMD: OLT-3 to [NAME] |  | SMD | OK
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 135339 | - | 51547
Cross-Currency Fixed-Fixed | - | 3351 | - | 1215
Cross-Currency Fixed-Float | - | 8464 | - | 3296
TOTAL | - | 147154 | - | 56058
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: firm9905

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-05-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.28 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.3
IFGMR (PEPL/TX/OK) |  |  | 2.22
IFGMR (ANR/LA) |  |  | 2.3
IFGMR (HENRY HUB) |  |  | 2.35
NX3 |  |  | 2.326
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5
TRIGGER* (LA) |  | 2.5
DIFFERENTIAL (TX)
DIFFERENTIAL (LA)
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
Customer prefers rounding to nearest penny.
*Check in [NAME]: Fee/Commidity/Trigger
Spreadsheet: 109595d1306416111-excel-2007-excel-dates-and-checking-elapsed-time-for-business-hours-excel-forum-query
Sheet: Sheet3

A | B | C | D | E | F
Start | End |  |  | Fix Time | Fix - 8 hr day
2011-01-02 12:24:11 | 2011-01-02 12:26:36 | Low | Service Desk |  |  |  | Based on 8 hr day
2011-01-02 12:24:54 | 2011-01-02 12:27:47 | Low | Service Desk |  |  |  | no holidays
2011-01-03 15:05:34 | 2011-01-03 15:18:29 | Low | Service Desk |  |  |  | and tickets are not opened or closed ourtside of work days
2011-01-03 15:13:22 | 2011-01-03 15:20:45 | Low | Service Desk
2011-01-03 15:32:00 | 2011-01-03 15:34:17 | Low | Service Desk
2011-01-04 08:01:48 | 2011-01-04 08:03:57 | Low | Service Desk
2011-01-04 08:45:43 | 2011-01-04 08:48:23 | Low | Service Desk
2011-01-04 08:54:19 | 2011-01-04 08:56:22 | Low | Service Desk
2011-01-04 08:53:46 | 2011-01-04 08:56:26 | Low | Service Desk
2011-01-04 08:55:04 | 2011-01-04 08:57:02 | Low | Service Desk
2011-01-04 08:56:55 | 2011-01-04 09:25:05 | Medium | Service Desk
2011-01-04 09:15:09 | 2011-01-04 09:43:47 | Low | Service Desk
2011-01-04 09:21:23 | 2011-01-04 10:12:12 | Low | Service Desk
2010-12-31 12:18:21 | 2011-01-04 10:15:18 | Low | Service Desk
2010-12-20 09:16:44 | 2011-01-04 10:19:49 | Low | Service Desk
2010-12-29 11:28:24 | 2011-01-04 10:31:01 | Low | Service Desk
2010-12-31 12:31:34 | 2011-01-04 10:56:51 | Low | Service Desk
2010-12-31 10:48:40 | 2011-01-04 11:03:00 | Low | Service Desk
2011-01-04 10:30:26 | 2011-01-04 11:19:11 | Medium | Service Desk
2011-01-04 11:04:16 | 2011-01-04 11:37:17 | Low | Service Desk
2011-01-04 10:56:47 | 2011-01-04 11:54:11 | Low | Service Desk
2011-01-04 09:59:01 | 2011-01-04 12:10:25 | Low | Service Desk
2010-12-08 10:56:10 | 2011-01-04 13:35:45 | Low | Service Desk
2011-01-04 13:58:26 | 2011-01-04 14:28:45 | Low | Service Desk
2011-01-04 14:15:54 | 2011-01-04 14:37:20 | Low | Service Desk
2010-12-31 13:29:01 | 2011-01-04 15:11:30 | Low | Service Desk
2011-01-03 15:10:25 | 2011-01-04 15:56:04 | Low | Service Desk
2011-01-02 12:24:11 | 2011-01-02 13:00:00
Spreadsheet: 694439d1599602764-counting-team-number-by-month-salcalc-2-7-
Sheet: Suggestion

Department | Start Date | End Date | Name | Monthly | Starting | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | Ju; 2019 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00
Team 1 | 2019-01-27 00:00:00 |  | [NAME] |  | 21000
Team 1 | 2018-03-20 00:00:00 |  | Nick |  | 30000
Team 1 | 2015-02-03 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 45000
Team 3 | 2018-11-10 00:00:00 |  | [NAME] |  | 18000
Team 4 | 2020-02-24 00:00:00 | 2020-06-30 00:00:00 | [NAME] |  | 25000
Team 4 | 2014-02-10 00:00:00 |  | Fred |  | 35000
Team 5 | 2020-01-27 00:00:00 |  | [NAME] |  | 35000
Team 5 | 2019-11-25 00:00:00 | 2020-05-28 00:00:00 | Abbey |  | 28000
Team 5 | 2019-07-02 00:00:00 | 2020-02-28 00:00:00 | [NAME] |  | 21500
2019-02-02 00:00:00 | [NAME] | 48000
2019-05-04 00:00:00 | [NAME] | 21000
2020-05-28 00:00:00 | Abbey | 29000
Department | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | Ju; 2019 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00
Team 1
Team 2
Team 3
Team 4
Team 5
Spreadsheet: 849851d1700228821-calculation-of-commissions-commissions-spreadsheet
Sheet: Agente A

Ammount |  | Commissions |  |  |  | Amount | % generated from the investment
From | To | First 6 months | Next 6 months | Further 6 months | Perpetual
3000 | 25000 | 0.1 | 0.05 | 0.05 | 0.02 | 10000 | 0.01
25001 | 50000 | 0.1 | 0.05 | 0.05 | 0.02 |  | 0.02
50001 | 100000 | 0.11 | 0.07 | 0.06 | 0.02 |  | 0.03
100001 | 200000 | 0.12 | 0.08 | 0.07 | 0.02 |  | 0.05
200001 | 300000 | 0.13 | 0.09 | 0.08 | 0.02 | 150000 | 0.05
300001 | 400000 | 0.14 | 0.1 | 0.09 | 0.03 |  | 0.06
400001 | 500000 | 0.15 | 0.12 | 0.1 | 0.04 |  | 0.07
500001 | 1000000 | 0.2 | 0.15 | 0.15 | 0.05 |  | 0.08
 |  |  |  |  |  |  | 0.09
Agent name | Ammount subscribed | Commission for the Agent |  |  |  |  | 0.1
 | 150000 |  |  |  |  |  | 0.11
 | 550000 |  |  |  |  |  | 0.12
 |  |  |  |  |  |  | 0.13
 |  |  |  |  |  |  | 0.14
 |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  | 0.16
 |  |  |  |  |  |  | 0.17
 |  |  |  |  |  |  | 0.18
 |  |  |  |  |  |  | 0.19
 |  |  |  |  |  |  | 0.2
total
Ammount Commission
Spreadsheet: 69467d1270003986-if-quantity-is-this-and-list-choice-is-that-then-pricing_web
Sheet: calculator

Garment price
cost of garment | 3.5
[NAME] | 2
Number of tees | 10
quantities | 1-12 | 13-24 | 25-36 | 37-71
totals | 70 | 0 | 0 | 0
Printing Costs
garment color | white |  | white | dark
1st location # of colors | 1 | 4.25
2nd location # of colors | 3 | 6.25
quantities | 1-12 | 13-24 | 25-36 | 37-71
totals | #N/A | 0 | 0 | 0
Setup costs
Art work
# of screens
quantities | 1-12 | 13-24 | 25-36 | 37-71
Total
subtotal
sales tax
total
Spreadsheet: 695374d1600181222-need-to-find-highlight-or-return-a-row-cell-based-on-a-text-input-stchg_query1
Sheet: Sheet1

Number | SR Short | SR Long | SR Task Partner | SR Task AN | SR Remark
1 | foxes and dogs and jumping | The quick brown fox jumps over the lazy dog. | jump over dog | dog lays still and plays lazy | the fox is brown
2 | [NAME] and dogs jumping | The quick yellow giraffe jumps over the lazy dog. | jump over dog | dog lays still and plays lazy | the giraffe is yellow
3 | doplhins and whales and swimming | The cute young doplhin swims underneath the hungry whale | to swim under whale | whale swims slow and is hungry | the dolphin is cute
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 48900d1248193269-converting-daily-data-to-weekly-692377-converting-daily-data-to-weekly
Sheet: Sheet1

Week | Date | Value |  |  | Date | Date
June week 27 | 2009-06-28 00:00:00 | 100 |  |  | >=39992 | <=39997
June week 27 | 2009-06-29 00:00:00 | 101
June week 27 | 2009-06-30 00:00:00 | 102 |  |  | Date 1 | Date 2 | Result
July week 27 | 2009-07-01 00:00:00 | 103 |  |  | 2009-06-28 00:00:00 | 2009-07-03 00:00:00 | 105
July week 27 | 2009-07-02 00:00:00 | 104
July week 27 | 2009-07-03 00:00:00 | 105
July week 27 | 2009-07-04 00:00:00 | 106
July week 28 | 2009-07-05 00:00:00 | 107
July week 28 | 2009-07-06 00:00:00 | 108 |  |  | See Pivot Table on Sheet2
July week 28 | 2009-07-07 00:00:00 | 109
July week 28 | 2009-07-08 00:00:00 | 110
July week 28 | 2009-07-09 00:00:00 | 111
July week 28 | 2009-07-10 00:00:00 | 112
July week 28 | 2009-07-11 00:00:00 | 113
July week 29 | 2009-07-12 00:00:00 | 114
July week 29 | 2009-07-13 00:00:00 | 115
July week 29 | 2009-07-14 00:00:00 | 116
July week 29 | 2009-07-15 00:00:00 | 117
July week 29 | 2009-07-16 00:00:00 | 118
July week 29 | 2009-07-17 00:00:00 | 119
Spreadsheet: 134769d1325625041-how-to-increase-table-size-based-on-quanity-of-an-item-increment-by-values
Sheet: Sheet2

chocolate bars
chocolate bars
chocolate bars
chocolate bars
chocolate bars
candy
candy
candy
jelly
jelly
jelly
jelly
jelly
jelly
jelly
jelly
nuts
nuts
nuts
nuts
nuts
nuts
nuts
nuts
nuts
nuts
Spreadsheet: c075fcfa-f6ca-42a4-96e6-d9cdeac13039
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-12-30 09:26:02.800000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.872 | 101.747 | 101.622 | 101.247
4.25 | 101.624 | 101.499 | 101.374 | 100.999 |  | Note: | Refer To Price [NAME]
4.125 | 101.212 | 101.087 | 100.962 | 100.587 |  |  | For all Price Adjs
4 | 100.771 | 100.646 | 100.521 | 99.896
3.875 | 100.211 | 100.086 | 99.961 | 99.336
3.75 | 99.362 | 99.237 | 99.112 | 98.487
 |  |  |  |  |  | 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
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.533 | 101.408 | 101.283 | 100.908
3.625 | 101.217 | 101.092 | 100.967 | 100.592
3.5 | 100.903 | 100.778 | 100.653 | 100.278
3.375 | 100.498 | 100.373 | 100.248 | 99.623
3.25 | 99.946 | 99.821 | 99.696 | 99.071
 |  |  |  |  |  | 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 | 2012-01-13 09:26:02.800000
30 DAY | 2012-01-28 09:26:02.800000
45 DAY | 2012-02-12 09:26:02.800000
60 DAY | 2012-02-27 09:26:02.800000
90 DAY | 2012-03-28 09:26:02.800000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 693633d1599063373-need-help-with-counting-pairs-values
Sheet: Values

1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2488
1005;2489
1005;2489
1005;2489
1005;2489
1005;2489
1005;2489
1005;2491
1005;2491
1005;2491
[NAME]
[NAME]
1005;190
1005;190
1005;190
1005;190
1016;1395
1016;2488
1016;2488
1016;2488
1016;2488
1016;2488
1016;2488
1016;796
Spreadsheet: 59177d1259660399-autofill-data-using-keywords-or-button-clicks-deviation-schedule-new-template-
Sheet: Earthing

E1 | Main earthing conductor is undersized and requires upgrading to ([NAME] in mm) | 2
E2 | Main earthing and bonding arrangement requires upgrading/attention. | 2
E3 | Main equipotential bonding to services is undersized and requires upgrading to ([NAME] in mm) | 2
E4 | unable to locate main equipotential bonding to gas/water/other services. | 3
E5 | It is advised that a PME terminal be applied for from the Local Supply Authority. | 2
E6 | Main equipotential bond to gas/water is not connected within 600mm of stop tap. | 2
E7 | Main equipotential bond to gas/water is incorrectly terminated to incoming pipe work prior to stop tap. | 2
E8 | No supplementary bonding installed/located throughout the installation. | 2
E9 | No supplementary bonding within bathroom does not comply with section 601 BS7671. | 1
E10 | No main equipotential bonding installed. | 1
E11 | No high integrity earth system is installed for circuit supplying computers. | 2