tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 077f19b4-e9a5-43c8-ab7b-3f71111698ae
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: |  |  | 2012-08-20 09:56:27.850000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.06 | 100.935 | 100.81 | 100.435
3.75 | 100.875 | 100.75 | 100.625 | 100.25 |  | Note: | Refer To Price [NAME]
3.625 | 100.438 | 100.313 | 100.188 | 99.813 |  |  | For all Price Adjs
3.5 | 99.744 | 99.619 | 99.494 | 98.869
3.375 | 98.787 | 98.662 | 98.537 | 97.912
3.25 | 97.747 | 97.622 | 97.497 | 96.872
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.851 | 101.726 | 101.601 | 101.226
3.25 | 101.503 | 101.378 | 101.253 | 100.878
3.125 | 101.185 | 101.06 | 100.935 | 100.56
3 | 100.847 | 100.722 | 100.597 | 100.222
2.875 | 100.174 | 100.049 | 99.924 | 99.299
2.75 | 99.496 | 99.371 | 99.246 | 98.621
 |  |  |  |  |  | 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-09-03 09:56:27.850000
30 DAY | 2012-09-18 09:56:27.850000
45 DAY | 2012-10-03 09:56:27.850000
60 DAY | 2012-10-18 09:56:27.850000
90 DAY | 2012-11-17 09:56:27.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 588035d1535455316-using-index-function-with-multiple-input-values-spreadsheet-select-v4
Sheet: Type A

Size | 100 | 125 | 150 | 175 | 200 | 225 | 250 | 275 | 300 | 325 | 350
Length | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400
[NAME] | 700 | 1000 | 1300 | 1600 | 1900 | 2200 | 2500 | 2800 | 3100 | 3400 | 3700
Spreadsheet: 566593d1521593747-convert-time-series-ohlc-data-frequency-book2-2-
Sheet: Week

Week | Open | High | Low | Last | Change | Settle | Volume | Previous Day Open Interest
9
Spreadsheet: john_zufferli__16762__EOLProductsatNetco
Sheet: Products

Financial Products |  |  |  |  | Physical Products
AECO (Cowan) |  |  |  |  | AECO (Cowan)
 | Fixed vs Daily ROM |  |  |  | Physical Gas for Daily Index
 | Fixed vs Daily Prompt month |  |  |  | Fixed Price ROM
 | Fixed vs Daily Prompt month + 1 |  |  |  | Physical Gas for Monthly Index Prompt month
 | Daily Basis Prompt month |  |  |  | Fixed Price Prompt month
 | Daily Basis Prompt month + 1 |  |  |  | Physical Gas for Monthly Index Prompt month + 1
 | Daily for Monthly Index |  |  |  | Fixed Price Prompt month + 1
 |  |  |  |  | Basis Prompt month
 |  |  |  |  | Basis Prompt month + 1
AECO Basis ([NAME]) |  |  |  |  | AECO Monthly Index ([NAME])
 | Monthly Basis Prompt month |  |  |  | Monthly Index Prompt month
 | Monthly Basis Prompt month + 1 |  |  |  | Monthly Index Prompt month + 1
 | Balance of Season Basis |  |  |  | Balance of Season Index
 | Prompt Winter Basis |  |  |  | Prompt Winter Index
 | Prompt Summer Basis |  |  |  | Prompt Summer Index
 | Prompt Calendar Basis |  |  |  | Prompt Calendar Index
 | Prompt Winter + 1 Basis |  |  |  | Prompt Winter + 1 Index
 | Prompt Summer + 1 Basis |  |  |  | Prompt Summer + 1 Index
 | Prompt Calendar + 1 Basis |  |  |  | Prompt [NAME]
AECO Options (Draper)
 | Prompt month Straddle
 | Prompt month + 1 Straddle
 | Prompt month + 2 Straddle
 | Prompt Winter Straddle
 | Prompt [NAME]
Sumas Basis (Dorland) |  |  |  |  | Sumas Monthly Index (Dorland)
 | Monthly Basis Prompt month + 1 |  |  |  | Monthly Index Prompt month + 1
 | Balance of Season Basis |  |  |  | Balance of Season Index
 | Prompt Winter Basis |  |  |  | Prompt Winter Index
 | Prompt Summer Basis |  |  |  | Prompt Summer Index
 | Prompt Winter + 1 Basis |  |  |  | Prompt Winter + 1 Index
 | Prompt Summer + 1 Basis |  |  |  | Prompt Summer + 1 Index
Sumas ([NAME]) |  |  |  |  | Sumas ([NAME])
 | Fixed vs Daily ROM |  |  |  | Physical Gas for Daily Index
 | Fixed vs Daily Prompt month |  |  |  | Fixed Price ROM
 | Monthly Basis Prompt month |  |  |  | Physical Gas for Monthly Index Prompt month
 | Daily Basis Prompt month |  |  |  | Fixed Price Prompt month
 | Daily for Monthly Index |  |  |  | Basis Prompt month
Power Pool of Alberta (Richey/Zufferli)
 | Hourly Swap
 | Next Day Swap
 | Rest Of Month Swap
 | Prompt month Swap
 | Prompt month +1 Swap
 | Rest of Quarter
 | Q1, Q2, [NAME], Q4
 | Rest of Year
 | Prompt Calendar
 | Prompt Calendar +1
Spreadsheet: 792100d1660738408-tier-value-deductions-tier-math-deduction-example-1-
Sheet: Sheet1

Example 1
Allocated Units |  | 842
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499 |  |  |  | 500
[NAME] | 501 | 1000 |  | 0.75 |  | 341 |  |  |  | 342
Tier 3 | 1001 | 1500 |  | 1 |  | 0
[NAME] | 1501 | 1600 |  | 1.25 |  | 0
[NAME] per unit
Example 2
Allocated Units |  | 1247
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499 |  |  |  | 500
[NAME] | 501 | 1000 |  | 0.75 |  | 499 |  |  |  | 500
Tier 3 | 1001 | 1500 |  | 1 |  | 249 |  |  |  | 247
[NAME] | 1501 | 1600 |  | 1.25 |  | 0
[NAME] per unit
Example 3
Allocated Units |  | 1527
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499 |  |  |  | 500
[NAME] | 501 | 1000 |  | 0.75 |  | 499 |  |  |  | 500
Tier 3 | 1001 | 1500 |  | 1 |  | 499 |  |  |  | 500
[NAME] | 1501 | 1600 |  | 1.25 |  | 26 |  |  |  | 27
[NAME] per unit
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 519081 | 8255189 | 519081 | 797368 | 1038162 | 9052557
 | Loans |  | 28583 |  | 1127 |  | 29710
 | Municipal |  | 3308 |  | <1,000
 | Recovery
 | Sovereign | 32951 | 2626702 | 32951 | 247107 | 65903 | 2873810
Index Tranche | Asia |  | <1,000 |  | <100 |  | <1,000
 | Europe |  | 782388 |  | 86189 |  | 868577
 | North America |  | 1217109 |  | 38521 |  | 1255630
Index | Asia | 1211 | 318959 | 1513 | 48843 | 2725 | 367802
 | Europe | 285332 | 2593038 | 285332 | 379679 | 570663 | 2972717
 | North America | 498330 | 1592669 | 514256 | 314049 | 1012586 | 1906718
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL* |  | 1336905 | 17417946 | 1353133 |  | 2690038
Estimated gross notional amount outstanding, November 9 weekly snapshot, by product type (millions of USD), all participant types, tenors 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 Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 799613d1665157548-pull-consonant-f-column-minus-a-column-pull-alpha-and-letter
Sheet: Sheet1

TT | ATAATAS |  |  | 30781 | AAAASTT | AAAA | S
TT | TAUPATA |  | s | 28541 | AAAPTTU | AAAU | P
TT | TUATARA |  | s | 21481 | AAARTTU | AAAU | R
TT | BATTEAU |  | x | 13666 | AABETTU | AAEU | B
TT | ACETATE |  | ds | 11347 | AACEETT
TT | ACTUATE |  | ds | 13668 | AACETTU
TT | AGITATE |  | ds | 3514 | AAEGITT
TT | APATITE |  | s | 5977 | AAEIPTT
TT | ARIETTA |  | s | 972 | AAEIRTT
TT | AETATIS |  |  | 2224 | AAEISTT
TT | SATIATE |  | ds | 2225 | AAEISTT
TT | TUATERA |  | s | 4537 | [NAME]
TT | AGITATO |  | r | 6591 | AAGIOTT
TT | TAUTAUG |  | s | 28371 | AAGTTUU
TT | TITANIA |  | s | 7797 | AAIINTT
TT | TUTANIA |  | s | 6921 | [NAME]
TT | AUTOMAT |  | aes | 18052 | AAMOTTU
TT | TATOUAY |  | s | 18055 | AAOTTUY
TT | TUATUAS |  |  | 27033 | AASTTUU
TT | OUTDATE |  | ds | 2249 | ADEOTTU
TT | AILETTE |  | s | 1131 | AEEILTT
TT | TEATIME |  | s | 3593 | AEEIMTT
TT | TAENITE |  | s | 447 | AEEINTT
TT | ARIETTE |  | s | 449 | AEEIRTT
TT | ITERATE | l | ds | 450 | AEEIRTT
TT | AVIETTE |  | s | 3596 | AEEITTV
TT | EVITATE | l | ds | 3597 | AEEITTV
TT | OUTGATE |  | s | 3618 | AEGOTTU
TT | IMITATE |  | ds | 5981 | AEIIMTT
TT | VITIATE |  | ds | 5985 | [NAME]
TT | OATIEST | g |  | 323 | AEIOSTT
TT | OSTIATE |  |  | 324 | AEIOSTT
TT | TOASTIE |  | rs | 325 | AEIOSTT
TT | SITUATE |  | ds | 1772 | AEISTTU
TT | ATTUITE |  | ds | 10152 | AEITTTU
TT | OUTTAKE |  | ns | 10753 | AEKOTTU
TT | TAKEOUT | s | s | 10754 | AEKOTTU
TT | TOLUATE |  | s | 2250 | AELOTTU
TT | OUTRATE |  | ds | 1018 | AEORTTU
TT | OUTEATS |  |  | 2252 | AEOSTTU
TT | NOTITIA |  | es | 2263 | AIINOTT
TT | PITUITA |  | s | 16639 | AIIPTTU
TT | OUTWAIT |  | s | 8881 | AIOTTUW
TT | AUTOPUT |  | s | 25857 | AOPTTUU
TT | BIOTITE |  | s | 6912 | BEIIOTT
TT | ENTETEE |  |  | 19353 | EEEENTT
TT | FOUETTE |  | s | 11597 | EEFOTTU
TT | TOEIEST |  |  | 1552 | EEIOSTT
TT | TOETOES |  |  | 7926 | EEOOSTT
TT | PETITIO |  | ns | 6915 | EIIOPTT
TT | PITUITE |  | s | 13690 | EIIPTTU
TT | TIMEOUT |  | s | 6216 | EIMOTTU
TT | TOOTSIE |  | s | 3506 | EIOOSTT
TT | TOUTIER |  |  | 1044 | EIORTTU
TT | TOUSTIE |  | r | 2261 | EIOSTTU
TT | OUTVOTE |  | drs | 16283 | EOOTTUV
TT | OUTFOOT |  | s | 30363 | FOOOTTU
TT | TUITION |  | s | 7950 | IINOTTU
TT | TOITOIS |  |  | 14179 | IIOOSTT
TT | OUSTITI |  | s | 11898 | IIOSTTU
TT | OUTTOOK |  |  | 31919 | KOOOTTU
TT | OUTROOT |  | s | 24880 | OOORTTU
Spreadsheet: 163305d1340273309-finding-discount-via-vlookup-coursefeespaidterm3
Sheet: Sheet1 (2)

Student Name | Course  Code | Course Name | Date Course Commences | Date Paid | Course Fee | Days Paid In Advance | Discount | Course Fee Paid
[NAME] | 40748 | Bookkeeping | 2012-09-09 00:00:00 | 2012-09-01 00:00:00 | 395 |  |  |  |  |  | days | days | DIS
[NAME] | 43255 | Time Management | 2012-09-12 00:00:00 | 2012-09-11 00:00:00 | 250 |  |  |  |  |  | 0 | 6 | 0
[NAME] | 40847 | Office/Reception Skills | 2012-09-15 00:00:00 | 2012-08-31 00:00:00 | 300 |  |  |  |  |  | 7 | 13 | 0.05
[NAME] | 40288 | Workplace Assessment | 2012-09-01 00:00:00 | 2012-08-05 00:00:00 | 690 |  |  |  |  |  | 14 | 20 | 0.08
[NAME] | 40748 | Bookkeeping | 2012-09-09 00:00:00 | 2012-08-31 00:00:00 | 395 |  |  |  |  |  | 21 | - | 0.1
[NAME] | 40847 | Office/Reception Skills | 2012-09-15 00:00:00 | 2012-08-20 00:00:00 | 300
Spreadsheet: 32571d1228763541-relative-formula-copied-across-worksheets-example01
Sheet: 3

 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
 |  | 10 | 11 |  |  | 12 | 13
Total to day |  | 50 | 55 |  |  | 60 | 65
Total to Date |  | 60
 |  | The   1   in this formula refers to sheet 1 I need it to change to sheet  2  when I copy it. I don't need it to be absolute, I need it relative.
Spreadsheet: 161536d1339539873-vlookup-matching-two-criteria-then-return-adjacent-column-ef-test-file-vlookup-or-match
Sheet: Sheet1

 | Excel Forum Dummy Test File
 | Data File - Sheet 1 |  |  |  |  |  | Report File - Sheet 2 (shows sold out of total inventory)
 | Combined | Date | Letter | Total Inventory | Sold |  | Date | A | B | C
 |  | 2012-06-12 00:00:00 | A | 10 | 7 |  | 2012-06-12 00:00:00
 |  | 2012-06-12 00:00:00 | B | 10 | 6 |  | 2012-06-13 00:00:00
 |  | 2012-06-12 00:00:00 | C | 10 | 4 |  | 2012-06-14 00:00:00
 |  | 2012-06-13 00:00:00 | A | 10 | 8 |  | 2012-06-15 00:00:00
 |  | 2012-06-13 00:00:00 | B | 10 | 5 |  | 2012-06-16 00:00:00
 |  | 2012-06-13 00:00:00 | C | 10 | 2 |  | 2012-06-17 00:00:00
 |  | 2012-06-14 00:00:00 | A | 10 | 4
 |  | 2012-06-14 00:00:00 | B | 10 | 3
 |  | 2012-06-14 00:00:00 | C | 10 | 2
 |  | 2012-06-15 00:00:00 | A | 10 | 5
 |  | 2012-06-15 00:00:00 | B | 10 | 3
 |  | 2012-06-15 00:00:00 | C | 10 | 1
 |  | 2012-06-16 00:00:00 | A | 10 | 4
 |  | 2012-06-16 00:00:00 | B | 10 | 3
 |  | 2012-06-16 00:00:00 | C | 10 | 2
 |  | 2012-06-17 00:00:00 | A | 10 | 3
 |  | 2012-06-17 00:00:00 | B | 10 | 2
 |  | 2012-06-17 00:00:00 | C | 10 | 1
Spreadsheet: 768499d1645001577-how-to-add-an-extra-text-valve-to-search-excel-help-
Sheet: Sheet1

Contract | Depot | Margin % | No. nights accom | TM Days | m3       Monday | m3       Tuesday | m3 Wednesday | m3     Thursday | m3            Friday | m3      Saturday | m3         Sunday
Norfolk | [NAME] | 0.4354011579818031 |  |  | 1 | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X |  |  |  | I would like this to count TRUCK BREAK DOWN AND UNIT BREAK DOWN AS WELL AS WEATHER
 |  | 0 |  |  | X | X | X | X | X | X | X |  |  | HEREFORD DAYS LOST
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Cornwall | Scorier | 0.3897687861271676 |  |  | 1 | WEATHER | 2 | X | X | X | X
Herefordshire | Thorne | 0 |  |  | X | WEATHER | TRUCK BREAK DOWN | UNIT BREAKDOWN | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Norfolk | [NAME] | 0.3465339495200853 |  |  | 1 | WEATHER | 1 | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Cornwall | [NAME] | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Cornwall | [NAME] | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Cornwall | [NAME] | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Cornwall | [NAME] | 0 |  |  | X | X | X | X | X | X | X
Cornwall | [NAME] | 0 |  |  | X | X | X | X | X | X | X
Cornwall | Scorier | 0 |  |  | X | X | X | X | X | X | X
Norfolk | [NAME] | 0 |  |  | X | X | X | X | X | X | X
Herefordshire |  | 0 |  |  | X | 1 | 2 | WEATHER | 1 | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
 |  | 0 |  |  | X | X | X | X | X | X | X
Spreadsheet: 794562d1662115669-highlighting-duplicate-cells-example
Sheet: Sheet1

Engine speed | Ambient pressure | Engine mode
1325 | 100 | 1
1300 | 100 | 1
1200 | 100 | 1
1125 | 100 | 1
1088 | 100 | 1
1000 | 100 | 1
900 | 100 | 1
900 | 100 | 1
850 | 100 | 1
800 | 100 | 1
700 | 100 | 1
700 | 100 | 1
600 | 100 | 1
600 | 100 | 1
550 | 100 | 1
550 | 100 | 1
550 | 100 | 1
550 | 100 | 1
1125 | 100 | 1
1125 | 93 | 1
900 | 93 | 1
550 | 93 | 1
550 | 93 | 1
1125 | 88 | 1
900 | 88 | 1
550 | 88 | 1
550 | 88 | 1
900 | 80 | 1
550 | 80 | 1
550 | 80 | 1
900 | 77 | 1
550 | 77 | 1
550 | 77 | 1
900 | 71 | 1
550 | 71 | 1
550 | 71 | 1
550 | 66 | 1
550 | 66 | 1
550 | 60 | 1
550 | 60 | 1
1700 | 100 | 2
1600 | 100 | 2
1563 | 100 | 2
1500 | 100 | 2
1400 | 100 | 2
1325 | 100 | 2 | fault
1300 | 100 | 2 | fault
1200 | 100 | 2 | fault
1125 | 100 | 2 | fault
1125 | 100 | 2 | ok
1088 | 100 | 2 | fault
1000 | 100 | 2 | fault
900 | 100 | 2 | fault
850 | 100 | 2 | fault
800 | 100 | 2 | fault
800 | 100 | 2 | ok
700 | 100 | 2 | fault
700 | 100 | 2 | ok
600 | 100 | 2 | fault
600 | 100 | 2 | ok
600 | 100 | 2 | ok
600 | 100 | 2 | ok
550 | 100 | 2 | fault
550 | 100 | 2 | ok
900 | 60 | 2
1325 | 66 | 2
1125 | 66 | 2
900 | 66 | 2
1325 | 71 | 2
1125 | 71 | 2
900 | 71 | 2 | fault
1500 | 77 | 2
1325 | 77 | 2
1125 | 77 | 2
1500 | 80 | 2
1325 | 80 | 2
1125 | 80 | 2
1500 | 88 | 2
1325 | 88 | 2
1125 | 88 | 2 | fault
1500 | 93 | 2
900 | 93 | 2 | fault
1600 | 100 | 2 | fault
1500 | 100 | 2 | fault
900 | 100 | 2 | fault
Spreadsheet: 678874d1590091162-timesheet-with-rules-team-weekly-times-ww21
Sheet: Sheet1

WW21 | Friday |  |  | Saturday | Sunday | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Weekly Hours
Name | In | Out | Hours |  |  | In | Out | Hours | In | Out | Hours | In | Out | Hours | In | Out | Hours
[NAME] | 07:27:00 | 14:59:00 |  |  |  | 07:27:00 | 17:57:00 |  | 07:32:00 | 18:53:00 |  | 07:30:00 | 17:20:00 |  | 07:34:00 | 18:30:00
[NAME] | 08:00:00 | 17:00:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:14:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00
[NAME] | 08:00:00 | 17:30:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 13:00:00 | 17:00:00
[NAME] | 07:50:00 | 17:15:00 |  |  |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 18:30:00
[NAME] | 07:00:00 | 16:22:00 |  |  |  | 08:13:00 | 21:15:00 |  | 08:07:00 | 17:56:00 |  | 08:01:00 | 17:11:00 |  | 08:05:00
Ricardo Cardoso | 07:54:00 | 17:39:00 |  |  |  | 07:58:00 | 18:09:00 |  | 08:04:00 | 17:54:00 |  | 08:00:00 | 18:17:00 |  | 07:56:00
Hours worked = total time - 30 mins [NAME] break (should be built in)
If In OR Out times not entered then hours  = 0
If In AND Out times not entered then hours  = 0
If hours worked exceed 8.5 hours, then hours = 8.5
Spreadsheet: 463093d1464290709-trying-to-match-unique-values-in-single-column-against-multiple-columns-test-isnumber-index-match
Sheet: L1

Company | Email1 | Email2 | Email3 | FN | LN | Dept
Toyota | [EMAIL] | [EMAIL] |  | [NAME] | Billy | HR
Honda | [EMAIL] | [EMAIL] | [EMAIL] | [NAME] | [NAME] | Finance
Kia | [EMAIL] | [EMAIL] |  | [NAME] | Charlies | IT
Spreadsheet: 783890d1655279808-lookup-function-to-display-multiple-results-from-multiple-sheets-test-file
Sheet: Test case 2

 | Test Case Scenario
 |  | Test title
 |  | System |  |  | Test case No. | 1
 |  | Sub system |  |  | Version | V1
 |  | Designed by |  |  | Executed by
 |  | Design date |  |  | Execution date
 |  | Short description |  |  | Overall status
 | Pre condition
 | # | User Story/ description | Step instruction | Expected result | Status | Describe the issue or include the error printscreeen
 | 1 |  | 1. 2. 3. |  | Failed | system not accepting upload
 | 2 |  |  |  | Passed
 | 3 |  |  |  | Passed
 | 4 |  |  |  | In process
 | 5 |  |  |  | Failed | system not saving image
 | 6 |  |  |  | Not started
 | 7 |  |  |  | Not started
 | 8 |  |  |  | Not started
 | 9 |  |  |  | Not started
 | 10 |  |  |  | Not started
 | Post condition:
Spreadsheet: 872180d1718561070-total-is-hidden-when-filtering-data-book1
Sheet: Sheet1

Brand | Model | Print Speed © | Duty | Unit Price | Toner |  | Toner Price
Brother | HL-L3230 | 18 | 1500 | 4931 | [NAME] | 1300 | 113000
Brother | HL-L3240 | 26 | 1500 | 4835 | TN269 | 1200 | 0
Brother | HL-L3270 | 24 |  | 5315 | [NAME] | 1300 | 113000
Brother | HL-L3280 | 26 | 1500 | 5315 | TN269 | 1200
Brother | HL-L8260 | 31 | 5500 | 7150 | TN451 | 1800 | 155000
Brother | HL-L8360 | 31 | 3000 | 8125 | TN451 | 1800 | 155000
HP | 4203 | 35 | 750-4000 |  | HP 230A | 1800
HP | M155 | 17 | 150-1500 |  | HP 215A | 850 | 0
HP | M255 | 22 | 150-2500 |  | HP 206A | 1250 | 200000
HP | M451 | 21 | 750-2000 |  | HP 305A | 2600
HP | M454 | 28 | 750-4000 |  | HP 414A | 2100 | 87000
HP | M455 | 29 | 900-4800 |  | HP 415A | 2100
Spreadsheet: 816427d1675616781-lookup-for-match-and-mismatch-example-etaf
Sheet: Sheet1

Pipe Number | Spex | Result |  | index | Pipe Number | Spec |  | count
2-P311.02 | F40 | Do Not Match | <- The result I want to be calculated. |  | 2-P311.02 | F40
2-P311.03 | F40 | Match | <- The result I want to be calculated. |  | 2-P311.03 | F40
 |  |  |  |  | 2-P311.10 | [NAME]
 |  |  |  |  | 2-P314.01 | F40
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P311.02 | A30
 |  |  |  |  | 2-P314.08 | F40
 |  |  |  |  | 2-P314.20 | F40
 |  |  |  |  | 2-P311.02 | F40
 |  |  |  |  | 2-P315.04 | [NAME]
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P316.20 | [NAME]
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P317.11 | F40
 |  |  |  |  | 2-P323.05 | F40
 |  |  |  |  | 2-P323.50 | F40
 |  |  |  |  | 2-P326.01 | F63
 |  |  |  |  | 2-P326.03 | F63
 |  |  |  |  | 2-P326.04 | F63
 |  |  |  |  | 2-P326.05 | F63
 |  |  |  |  | 2-P326.06 | F63
 |  |  |  |  | 2-P326.07 | F63
Spreadsheet: 715822d1611872093-search-between-tabs-doesnt-work-index-match-max403-
Sheet: Processo

contato_fornecedor | local | Data do Envio | mes_conclusao
 |  | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-02-08 00:00:00
 |  | 2021-02-09 00:00:00
 |  | 2021-02-10 00:00:00
 |  | 2021-03-11 00:00:00
 |  | 2021-03-12 00:00:00
 |  | 2021-03-13 00:00:00
 |  | 2021-03-14 00:00:00
 |  | 2021-03-15 00:00:00
 |  | 2021-03-16 00:00:00
 |  | 2021-03-17 00:00:00
 |  | 2021-03-18 00:00:00
 |  | 2021-03-19 00:00:00
 |  | 2021-03-20 00:00:00
 |  | 2021-03-21 00:00:00
 |  | 2021-03-22 00:00:00
Spreadsheet: 174975d1345274359-how-to-convert-duplicated-rows-into-single-rows-extracting-some-data-from-deleted-rows-sample-input-outputwithcode
Sheet: Sheet1

What I have |  |  |  |  |  |  |  |  | What I would like to have
[NAME] | Panidha | 1 | EC102
[NAME] | Panidha | 1 | EC400
[NAME] | Panidha | 1 | EC201
[NAME] | Alia | 4 | EC102
[NAME] | Alia | 4 | EC201
Spreadsheet: 356150d1415008810-if-command-or-any-other-for-correct-answer-blink-answers
Sheet: Sheet1

 |  | Answers are typed in here and compared to the correct answers in column E Also works if answers are given in small caps Works if the correct answer column is hidden
 | question | answer | Correct or wrong | CORRECT ANSWERS
 | lahore | lhe | CORRECT | LHE
 | Islamabad | isb | CORRECT | ISB
 | chitral | cjl | CORRECT | CJL
 | Haidrabad | hhh | WRONG | HDD
 | Muzafrabad | muf | CORRECT | MUF
 | Nawabshah | WNS | CORRECT | WNS
 | Karachi | KHJ | WRONG | KHI
 | Abbotabad | AAW | CORRECT | AAW
 | Gawader | GWD | CORRECT | GWD
 | [NAME] | MUX | CORRECT | MUX
 | Peshawar | Per | WRONG | PEW
Spreadsheet: 275882d1383671686-using-conditional-formatting-with-other-formulas-testconditional
Sheet: Sheet1

 |  | Current: | 2013
 |  |  | 2013
 |  | Bought | 10 | 15 | 20 | 25 | 30 | 35
 |  | Sold | 9 | 12 | 13 | 22 | 29 | 35
Spreadsheet: 84372d1284414628-using-multi-conditional-formats-for-a-calendar-index
Sheet: Sheet3

SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  | 2010-01-01 00:00:00 | 2010-01-02 00:00:00
2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00
Spreadsheet: 39602d1237898323-time-format-please-help-avg-time-spent
Sheet: sheet1

 | Avg. Time Spent in Excel | Avg Time Spent In Google Analytics Report
Country/Territory | Avg. Time on Site
India | 1900-06-18 20:09:08
United Arab Emirates | 1900-06-17 12:27:44
United States | 1900-06-06 22:28:20
Saudi Arabia | 1900-08-13 08:58:16
Qatar | 1900-07-17 20:48:53
United Kingdom | 1900-05-20 09:45:57
Kuwait | 1900-09-04 19:29:35
Oman | 1900-06-11 02:47:51
Singapore | 1900-05-20 05:57:39
Canada | 1900-05-26 12:55:23