tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 762502d1641578968-eu-date-and-time-to-us-date-and-time-with-a-formula-or-vba-import-data-convertordatetime1
Sheet: ConvertedData(USA)

Date | Time
Spreadsheet: 668766d1585039358-copy-sheet-to-another-workbook-including-data-validation-uni-calculatietool-rollenbanen
Sheet: Calculaties

[NAME]
Hoofdafmetingen pakket |  | Lengte [mm] | [NAME] [mm] |  |  | Omschrijving |  | Aantal | [NAME] | Subtotaal
[NAME]. afmetingen |  | 600 | 400 |  |  | kosten 1 |  |  | 1
Min. afmetingen |  | 250 | 150 |  |  | kosten 2 |  |  | 2
 |  |  |  |  |  | kosten 3 |  |  | 3
Transportrichting |  | SSL |  |  |  | kosten 4 |  |  | 4
[NAME] waarden |  | [mm] |  | Omschrijving |  | Aantal |  | Brutoprijs | [NAME] | Subtotaal
Aanbevolen rollengte |  |  |  | Aantal zones |  |  | stuk(s)
Aanbevolen steek |  |  |  | Ondersteuning |  |  | stuk(s) | 1
Aanbevolen zone lengte |  |  |  | Zijgeleiding |  |  | meter | 2
 |  |  |  | Connectors |  |  | stuk(s) | 3
 |  |  |  | Mechanical stop gravity |  |  | stuk(s) | 4
Pos | Omschrijving | Aantal | Pitch | [NAME] | Framelengte | Zone lengte | Zones | Volt | Brutoprijs | [NAME] | # 400 V | # zones | # [NAME] | # meter | Subtotaal
1 | Smart roller conveyor curve | 1 | 90 | 420 | 45° |  |  | 24
Spreadsheet: 785533d1656480017-index-match-for-multiple-values-in-array-sample-raehan
Sheet: Position

Position Nbr | Effdt | Position Title
190765 | 2019-08-01 00:00:00 | Associate Professor
190765 | 1901-01-01 00:00:00 | Assistant Professor
196634 | 2015-03-01 00:00:00 | Assistant Professor
196634 | 2013-03-25 00:00:00 | Assistant Professor
275446 | 2013-04-11 00:00:00 | Financial/Staffing Assistant
348562 | 2017-06-16 00:00:00 | Director
348562 | 2017-06-15 00:00:00 | Associate Director
368235 | 2013-07-01 00:00:00 | Associate Librarian
385637 | 1901-01-01 00:00:00 | Assistant Manager
457152 | 2013-07-01 00:00:00 | Associate Librarian
549823 | 2014-07-01 00:00:00 | Lecturer
565728 | 2020-11-01 00:00:00 | Office Assistant
565728 | 2019-05-02 00:00:00 | Office Assistant
627837 | 2013-07-01 00:00:00 | Associate Director
628465 | 2014-07-01 00:00:00 | Financial Assistant
628465 | 1901-01-01 00:00:00 | Financial Assistant
654915 | 1901-01-01 00:00:00 | Research Associate
659204 | 2020-01-01 00:00:00 | Clinic [NAME]
659204 | 2016-01-05 00:00:00 | Clinic [NAME]
716499 | 2020-05-01 00:00:00 | Project Manager
726384 | 1901-01-01 00:00:00 | Associate Professor
798762 | 2016-12-01 00:00:00 | Manager
822345 | 2019-05-01 00:00:00 | Business Analyst
822345 | 2015-02-27 00:00:00 | Business Analyst
825593 | 2019-01-01 00:00:00 | Lecturer
913728 | 2015-11-24 00:00:00 | Clinic [NAME]/After Hours Clinic Assistant
913728 | 2014-10-01 00:00:00 | Clinic [NAME]/After Hours Clinic Assistant
918867 | 2013-09-01 00:00:00 | Administrative Secretary
918867 | 2013-05-01 00:00:00 | Administrative Secretary
991564 | 2020-05-28 00:00:00 | Associate Professor
991564 | 1901-01-01 00:00:00 | Assistant Professor
Spreadsheet: 849208d1699731792-formulas-are-turning-to-text-if-i-try-to-edit-them-in-any-way-ch-calc_v3
Sheet: TT_Calc

 |  | These numbers are all used to calculate the Bond Tool
 |  | travel times.
 |  | No need to touch any of them.
 |  | They are either constants or generated from other fields.
 |  | From Casing Size |  | casing ID |  | [NAME]
 |  | From Tool Size |  | tool OD |  | [NAME]
 |  | Calculated |  | r |  | [NAME]
 |  | 3' in mm |  | d(3') | 914 | [NAME]
 |  | 5' in mm |  | d(5') | 1524 | [NAME]
 |  | Refraction Angle - based on velocities |  | θ |  | deg
 |  | Calculated |  | x |  | [NAME]
 |  | Calculated |  | y (3') |  | [NAME]
 |  | Calculated |  | y (5') |  | [NAME]
 |  | Fluid Velocity |  | v1 |  | [NAME]/μsec
 |  | Casing Velocity |  | v2 |  | [NAME]/μsec
 |  | Tool Constant |  | c
 |  | Calculated 3' Travel Time |  | 3' TT |  | [NAME]
 |  | Calculated 5' Travel Time |  | 5' TT |  | [NAME]
 |  |  |  |  |  |  |  |  | Created by [NAME]
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Response

 |  | Correct Answers: |  | a | c | d | b | a | b | c | c | e | a | Correct Responses By Student |  |  |  |  |  |  |  |  |  | Total
Stud # | Section | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Points
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
6 | 1
7 | 1
8 | 1
9 | 1
10 | 1
11 | 1
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1
17 | 1
18 | 1
19 | 1
20 | 1
21 | 2
22 | 2
23 | 2
24 | 2
25 | 2
26 | 2
27 | 2
28 | 2
29 | 2
30 | 2
31 | 2
32 | 2
33 | 2
34 | 2
35 | 2
36 | 2
37 | 2
38 | 2
39 | 2
40 | 2
41 | 3
42 | 3
43 | 3
44 | 3
45 | 3
46 | 3
47 | 3
48 | 3
49 | 3
50 | 3
51 | 3
52 | 3
53 | 3
54 | 3
55 | 3
56 | 3
57 | 3
58 | 3
59 | 3
60 | 3
61 | 4
62 | 4
63 | 4
64 | 4
65 | 4
66 | 4
67 | 4
68 | 4
69 | 4
70 | 4
71 | 4
72 | 4
73 | 4
74 | 4
75 | 4
76 | 4
77 | 4
78 | 4
79 | 4
80 | 4
81 | 5
82 | 5
83 | 5
84 | 5
85 | 5
86 | 5
87 | 5
88 | 5
89 | 5
90 | 5
91 | 5
92 | 5
93 | 5
94 | 5
95 | 5
96 | 5
97 | 5
98 | 5
99 | 5
100 | 5
Spreadsheet: 707207d1607097085-how-to-return-results-of-a-top-5-lowest-price-top-5-highest-price-and-price-difference-clean-data
Sheet: RUSSIA

Country | RUSSIA
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | Cochlear | MedEL | OM
[NAME] | 14.144 | 19.584
Antenna cable |  | 9.792000000000002 | 3.264000000000001
Recheargable battery | 24.48 |  | 27.2
Country | RUSSIA
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | Cochlear | MedEL | OM
[NAME] | 14.144 | 19.584
Charger |  |  | 59.84
Recheargable battery | 24.48 |  | 27.2
Country | RUSSIA
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | Cochlear | MedEL | OM
[NAME] |  | 5.440000000000001 | -14.144
Recheargable battery |  | -24.48 | 2.720000000000002
Spreadsheet: vkaminski__40641__Dec2299
Sheet: Sheet1

Pricing Model for Bermudan Deal
 | Valuation Date
 |  |  | Strike | Maturity | Exercise Restriction | Exercise Frequency (times per year) | Years to Maturity | Years to first Exercise
 | Enron long 5-year put, [NAME] exercise |  | 56.125 | 2004-06-29 00:00:00 | 2000-06-30 00:00:00 | 2
 | LJM long 2.5 year put | Low Strike |  | 2002-01-14 00:00:00
 | Enron long 2.5 year put | High Strike | 65
 | LJM long call | Low Strike | 65
 | Enron long call | High Strike | 81
 |  | Quantity | RTHM Price | RTHM Volatility | Dividend | Interest rate | Steps | Do Risk (Yes=1)
 |  | 5393258 | 27 | 0.6146305723614341 | 0 |  | 301 | 0
 | Option value per share
 | Option value
Spreadsheet: 111234d1307650490-yearly-average-in-data-table-copy-of-sample-data-08-11
Sheet: Sample data

Month-year | Events | Observations | Event % | Average % event | Average for year | Column1
2008-01-01 00:00:00 | 2 | 449
2008-02-01 00:00:00 | 1 | 413
2008-03-01 00:00:00 | 1 | 461
2008-04-01 00:00:00 | 2 | 450
2008-05-01 00:00:00 | 0 | 498
2008-06-01 00:00:00 | 2 | 386
2008-07-01 00:00:00 | 0 | 408
2008-08-01 00:00:00 | 1 | 402
2008-09-01 00:00:00 | 3 | 375
2008-10-01 00:00:00 | 1 | 346
2008-11-01 00:00:00 | 0 | 325
2008-12-01 00:00:00 | 1 | 386
2009-01-01 00:00:00 | 1 | 480
2009-02-01 00:00:00 | 0 | 374
2009-03-01 00:00:00 | 1 | 467
2009-04-01 00:00:00 | 0 | 399
2009-05-01 00:00:00 | 2 | 420
2009-06-01 00:00:00 | 0 | 455
2009-07-01 00:00:00 | 1 | 434
2009-08-01 00:00:00 | 2 | 409
2009-09-01 00:00:00 | 2 | 436
2009-10-01 00:00:00 | 1 | 500
2009-11-01 00:00:00 | 1 | 510
2009-12-01 00:00:00 | 2 | 467
2010-01-01 00:00:00 | 2 | 502
2010-02-01 00:00:00 | 3 | 423
2010-03-01 00:00:00 | 1 | 443
2010-04-01 00:00:00 | 0 | 360
2010-05-01 00:00:00 | 0 | 386
2010-06-01 00:00:00 | 1 | 378
2010-07-01 00:00:00 | 1 | 461
2010-08-01 00:00:00 | 2 | 350
2010-09-01 00:00:00 | 4 | 343
2010-10-01 00:00:00 | 1 | 359
2010-11-01 00:00:00 | 0 | 288
2010-12-01 00:00:00 | 0 | 394
2011-01-01 00:00:00 | 1 | 385
2011-02-01 00:00:00 | 1 | 400
2011-03-01 00:00:00 | 3 | 390
Spreadsheet: 116688d1312000595-conditional-format-question-conditional-format
Sheet: Sheet1

1 | 53885.04 | 2009-07-30 00:00:00 | 60 Years Old | 2010-07-01 00:00:00 |  |  |  |  |  |  | 12
2 |  | 2010-07-30 00:00:00 | 61 Years Old | 2011-07-01 00:00:00 |  |  | 7368
3 | 57301.56 | 2011-07-30 00:00:00 | 62 Years Old | 2012-07-01 00:00:00 | 1812
4 |  | 2012-07-30 00:00:00 | 63 Years Old | 2013-07-01 00:00:00
5 |  | 2013-07-30 00:00:00 | 64 Years Old | 2014-07-01 00:00:00
6 |  | 2014-07-30 00:00:00 | 65 Years Old | 2015-07-01 00:00:00
7 |  | 2015-07-30 00:00:00 | 66 Years Old | 2016-07-01 00:00:00
8 |  | 2016-07-30 00:00:00 | 67 Years Old | 2017-07-01 00:00:00
Spreadsheet: 766552d1643929325-pivot-data-to-statements-to-email-sample-johanvd-
Sheet: 2.Pivot

Row Labels | Sum of Amount
Test 1 | 200
Test 10 | 218
Test 11 | 220
Test 12 | 222
Test 13 | 224
Test 14 | 226
Test 15 | 228
Test 16 | 230
Test 2 | 202
Test 3 | 204
Test 4 | 206
Test 5 | 208
Test 6 | 210
Test 7 | 212
Test 8 | 214
Test 9 | 216
Grand Total | 3440
Spreadsheet: 715680d1611832425-need-fifo-qty-and-value-in-fifo-qty-and-value-column-stock-register
Sheet: Required

Opening Balance |  |  |  | PURCHASE |  |  |  | REPROCESS |  |  |  | SALES |  |  |  | CLOSING STOCK |  |  |  | CONSUMPTION
DATE | Kgs | Rate | Value
2018-04-01 00:00:00 | 1000 | 1.2 |  | 2018-04-15 00:00:00 | 4000 | 1.21 |  | 2018-04-10 00:00:00 | 250 | 0.5 |  | 2018-04-04 00:00:00 | 500 | 1.6 |  | 2018-04-30 00:00:00 |  |  |  | 2018-04-30 00:00:00
2018-04-01 00:00:00 | 3000 | 1.19 |  |  | 4200 | 1.19 |  |  | 500 | 0.6 |  |  | 600 | 1.7 |  | 2018-04-30 00:00:00 |  |  |  | 2018-04-30 00:00:00
 |  |  |  |  | 8000 | 1.31 |  |  |  |  |  |  | 400 | 1.5
 |  |  |  |  | 4662 | 1.31 |  |  |  |  |  |  | 1000 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
 | OPENING |  | + |  | PURCHASE |  | + |  | REPROCESS |  | - |  | SALES |  | - |  | CLOSING STOCK |  | = |  | CONSUMPTION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSICAL STOCK
Spreadsheet: 68074d1268646828-automatically-change-a-column-chart-based-upon-2-data-ranges-example_no-info
Sheet: Sheet1

Y
 |  | Urban |  | Semi Rural |  | Rural
 | Total Roadway Cost | 100 |  | 90 |  | 70
 | Total Footway Cost | 50 |  | 40 |  | 20
 | Total Roadway 2 Cost |  | 15 |  | 12 |  | 10
 | Total Footway 2 Cost |  | 10 |  | 8 |  | 6
 |  | Urban |  | Semi Rural |  | Rural
 | Total Roadway Cost | 50 |  | 45 |  | 35
 | Total Footway Cost | 25 |  | 20 |  | 10
 | Total Roadway 2 Cost |  | 7.5 |  | 6 |  | 5
 | Total Footway 2 Cost |  | 5 |  | 4 |  | 3
Spreadsheet: 136330d1326544212-autoformatting-of-cells-relating-to-weekends-and-public-holidays-sickness-calendar-draft
Sheet: Jan 2012

JAN
1 | Month Number | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | n/a | n/a | n/a | n/a
Group 1
Smith | [NAME]
Doe | [NAME]
Morris | Greg
Jones | [NAME]
[NAME] | [NAME]
Group 2
[NAME] | [NAME]
[NAME] | Amanda
Brookes | [NAME]
Group 1 Totals |  | 0
Group 2 Totals |  | 0
Spreadsheet: 176664d1346061233-list-of-dates-with-each-date-twice-duplicate-date
Sheet: Sheet1

2012-10-01 00:00:00
2012-10-01 00:00:00 |  |  | Manual
2012-10-02 00:00:00
 | IF(A2<>A1,A2+1,A3)
Spreadsheet: 69667d1270218466-numbers-need-to-be-numbers-hs-grades-reading
Sheet: HS

 | Grade |  |  | % MHS | % MLG | % LMLG
0311 | A | BCH | 2008-09 | 66 | 64 | 51
0311 | A | BCH | 2007-08 | 68 | 68 | 52
0311 | B | BCH | 2006-07 | 58 | 59 | 47
0501 | C | GGH | 2008-09 | 34 | 52 | 53
0501 | F | GGH | 2007-08 | 26 | 44 | 42
0501 | D | GGH | 2006-07 | 29 | 45 | 48
0392 | A | GCH | 2008-09 | 58 | 58 | 52
0392 | A | GCH | 2007-08 | 62 | 65 | 54
0392 | B | GCH | 2006-07 | 52 | 55 | 43
0271 | D | IHS | 2008-09 | 22 | 41 | 50
0271 | F | IHS | 2007-08 | 20 | 43 | 43
0271 | F | IHS | 2006-07 | 18 | 45 | 49
0261 | C | LHS | 2008-09 | 35 | 49 | 51
0261 | D | LHS | 2007-08 | 34 | 45 | 38
0261 | D | LHS | 2006-07 | 32 | 48 | 47
0282 | D | LWH | 2008-09 | 29 | 41 | 46
0282 | D | LWH | 2007-08 | 36 | 46 | 38
0282 | C | LWH | 2006-07 | 43 | 50 | 52
0151 | C | NHS | 2008-09 | 54 | 52 | 40
0151 | A | NHS | 2007-08 | 58 | 62 | 47
0151 | C | NHS | 2006-07 | 47 | 50 | 40
0493 | C | PRH | 2008-09 | 44 | 52 | 50
0493 | B | PRH | 2007-08 | 43 | 52 | 48
0493 | C | PRH | 2006-07 | 41 | 48 | 43
Spreadsheet: 863401d1710894863-formulas-for-golf-tournament-assigning-in-separate-cell-and-listing-multiple-names-team-game-scenarios-1-
Sheet: Sheet1

[NAME] | -4 |  | [NAME]
[NAME] | 3 |  | Adam |  |  |  | In this scenario, I need  the number 25 to fill into Column E for every player listed in Column A except for the (3) highest scores (which would be Zach, [NAME], [NAME] and [NAME]). The (3) highest scores only get the number 10. Since [NAME] and [NAME] both tied for the 3rd highest score, is there a way to give them each the number 17 or 18 which would be 25+10/2?
[NAME] | -2 |  | [NAME]
[NAME] | 0 |  | [NAME]
[NAME] | -3 |  | [NAME]
[NAME] | -3 |  | [NAME]
Jake | -6 |  | [NAME]
[NAME] | 2 |  | [NAME]
[NAME] | 5 |  | Cliff
Mark | -3 |  | [NAME]
[NAME] | -5 |  | [NAME]
Pablo | -6 |  | Jake
[NAME] | 0 |  | [NAME]
[NAME] | 3 |  | [NAME]
Zach | 6 |  | [NAME]
 |  |  | Mark
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Norm
 |  |  | Pablo
 |  |  | [NAME]
 |  |  | Sly
 |  |  | [NAME]
 |  |  | Will
 |  |  | Zach
Spreadsheet: sara_shackleton__36866__ISDA
Sheet: cws

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Air Liquide America Corporation | CONTACT: | [NAME]
ADDRESS: |  | TITLE: | Manager
 |  | PHONE: | [PHONE]
 |  | FAX:
Incorporation State |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | 75000000
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX |  |  | ENA only
 |  | 75000000 | BBB+
 |  | 50000000 | BBB
 | 5000000 | 25000000 | BBB-
 |  |  | Below BBB-
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants | X
-Funded Debt to Worth | 1.5:1.0
-Minimum Net Worth | 900000000
-EBIT/Interest Expense | 1.5x
-Funded Debt / EBITDA
Non-Specific | X
-Unilateral | X - Tied to L'Air Liquide, Societe Anonyme pour L'etude et L'Exploration des Procedes Georges Claude and its subsidiaries
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 25
-Guarantor ($[NAME]) |  | 200
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X-Financials will not be required; however, audit/review rights shall be permitted upon request (available w/in 120 days from year end and 60 days from quarter end). | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7712
Spreadsheet: cara_semperger__1445__ENA_PGE_DEC01_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time |  | THIS IS AN OVER-RETURN
(PPT)
0100 |  | 0
0200 |  | 0
0300 |  | 0
0400 |  | 0
0500 |  | 0
0600 |  | 0
0700 | 0 | 1
0800 | 0 | 1
0900 | 0 | 1
1000 | 0 | 1
1100 | 0 | 1
1200 | 0 | 1
1300 | 0 | 1
1400 | 0 | 1
1500 | 0 | 1
1600 | 0 | 1
1700 | 0 | 1
1800 | 0 | 1
1900 | 0 | 1
2000 | 0 | 1
2100 | 0 | 1
2200 | 0 | 1
2300 |  | 0
2400 |  | 0
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: 451999d1458512518-ifs-and-sums-and-nests-or-something-more-simple-book1example
Sheet: Sales

 | Sale orders
Order Number | [NAME] | Total Sold | Cost of Order
1 | 200 |  | =40 x £1.12 plus 160 x £1
2 | 320 |  | =320 x £1
3 | 30 |  | =30 x £1
4 | 400 |  | =400 x £1
5 | 250 |  | =90 x £1 plus 160 x £2
6 | 100 |  | =100 x £2
7 | 400 |  | =400 x £2
8 | 240 |  | =240 x £2
9 | 240 |  | =100 x £2 plus 140 x £2.20
10 | 300 |  | =300 x £2.20
11 | 400 |  | =400 x £2.20
12 | 50 |  | =50 x £2.20
13 | 150 |  | =110 x £2.20 plus 40 x £1
Spreadsheet: 816683d1675779356-formatting-when-box-checked-example-2
Sheet: Sheet1

 |  | Food | Bread |  |  | Food | Bread |  |  |  | Food | Bread
 |  |  | Milk |  |  |  | Milk |  |  |  |  | Milk
 |  |  | Grapes |  |  |  | Grapes |  |  |  |  | Grapes
 |  |  | Juice |  |  |  | Juice |  |  |  |  | Juice
 |  | Tools | Bolts |  |  | Tools | Bolts |  |  |  | Tools | Bolts
 |  |  | Screws |  |  |  | Screws |  |  |  |  | Screws
 |  |  | Nuts |  |  |  | Nuts |  |  |  |  | Nuts
Spreadsheet: 859328d1707747721-genrate-quantity-and-avg-rate-according-to-ammount-sample-9-
Sheet: Sheet4

 |  | MIN | MAX
 |  | 39500 | 45500
NAME | QTY | AVG | AMT
AHATRAM-ALVPA1406A-CT | 130 |  | 5692989
MOHAMMAD HARIS-ACHPH4293F-CT | 59 |  | 2620328
[NAME] | 52 |  | 2299924
MOHAMMAD VAHID-ASOPV7368N-CT | 49 |  | 2175106
SHAH ALAM-CBLPA7824C-CT | 45 |  | 2000000
[NAME] | 23 |  | 986070
Bilal-CQAPB9152J-CT | 20 |  | 850523
SHADAB-MHNPS6867F-CT | 18 |  | 783922
[NAME] | 17 |  | 758181
ISHATYAK-ADFPI4620N-CT | 11 |  | 487064
NISHA-BOZPN3900E-CT | 10 |  | 437399
Mohd - Shadab-DVRPS9128C - CT | 10 |  | 403364
[NAME] | 10 |  | 403176
SHAHRUKH AHMAD-BNWPA4327A-CT | 9 |  | 391547
SHAHRUKH-FYQPS8848B-CT | 8 |  | 345911
ANAS-DLOPA6331Q-CT | 8 |  | 334738
Ms Food-OTWPS0408D-CT | 8 |  | 326653
AZAM-CALPA6053J-CT | 8 |  | 319776
MUSTAQEEM AHMAD-BEQPM7016B-CT | 7 |  | 300000
ALKMAL AHMAD-ASOPA3851D-CT | 5 |  | 200000
HASEEN-AQDPH6392K-CT | 5 |  | 200000
[NAME] | 5 |  | 200000
PRVEJ AALAM-DKCPP5184B-CT | 5 |  | 200000
SABIR-JBAPS4553Q-CT | 5 |  | 200000
SALMA-NOWPS6924A-CT | 5 |  | 191870
FARAZ-AGDPF2521J-CT | 4 |  | 171038
[NAME] | 4 |  | 157925
SHIBU VP-DHPPS4586E-CT | 4 |  | 150000
HUMA NAZ-BDZPN4074J-CT | 4 |  | 141476
FAIJAN-ADEPF3965E-CT | 3 |  | 110000
DILSHAD-EOAPD1454M-CT | 3 |  | 100000
KABIR TRADERS-ADCPF6604N-CT | 3 |  | 100000
MASHOOF ALI KHAN-AXQPK8398C-CT | 2 |  | 80000
KALIM-[PHONE]-BCT | 2 |  | 66580
SHAHZEB-[PHONE]-BCT | 2 |  | 65883
[NAME] | 2 |  | 58976
TABISH-BTUPT6938C-CT | 2 |  | 55737
MOHAMMAD INAM-[PHONE]-BCT | 2 |  | 51030
BILAL-COOPB0977H-CT | 2 |  | 50000
KALA-BUAPK8481Q-CT | 2 |  | 50000
[NAME]. Salman-RRHPS4240D-CT | 2 |  | 50000
nadeem-[PHONE]-BCT | 2 |  | 49500
PARVEJ-CQPPP9004C-CT | 2 |  | 49000
ISLAM-ACCPI1457M-CT | 2 |  | 48562
ASHRAF-AOVPA9300C-CT | 2 |  | 47530
[NAME] | 2 |  | 45542
VAQUAR-[PHONE]-BCT | 1 |  | 36314
[NAME] | 1 |  | 35000
FAHEEM-BCT | 1 |  | 23250
JUNAID ALAM-EGCPA3243P-CT | 1 |  | 20400
SHAHANAVAJ-FKFPS7069D-CT | 1 |  | 20000
[NAME] | 1 |  | 20000
 | 591
Spreadsheet: 849035d1699606902-unique-count-function-test
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector
No. of Holdings |  |  |  |  |  |  | Fund 1 | Apple | A
Answer should be | 5 | 3 |  |  |  |  | Fund 1 | Apple | A
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | TSMC | A
 |  |  |  |  |  |  | Fund 1 | TSMC | A
 |  |  |  |  |  |  | Fund 1 | AON | C
 |  |  |  |  |  |  | Fund 1 | Tesla | D
 |  |  |  |  |  |  | Fund 1 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Meta | B
 |  |  |  |  |  |  | Fund 2 | Meta | B
 |  |  |  |  |  |  | Fund 2 | Microsoft | A
 |  |  |  |  |  |  | Fund 2 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Mastercard | C
 |  |  |  |  |  |  | Fund 2 | Mastercard | C
Spreadsheet: 803189d1667307681-formula-to-get-the-value-from-a-range-of-cells-test
Sheet: Sheet1

value1 | value2 | value3 | value4 | value5 | value6 | result
#N/A | #N/A | #N/A | #N/A | #N/A | T | T
L | #N/A | #N/A | #N/A | #N/A | L | L
#N/A | #N/A | #N/A | #N/A | #N/A | P | P
L | #N/A | #N/A | #N/A | #N/A | L | L
#N/A | #N/A | #N/A | #N/A | #N/A | A | A
M | #N/A | #N/A | N | #N/A | #N/A | M
#N/A | #N/A | #N/A | #N/A | #N/A | P | P
Spreadsheet: 677979d1589642535-autofill-downwards-in-a-sequential-manner-but-only-where-an-adjacent-cell-has-content-autofill-query
Sheet: Before

ITEM |  | QTY | UNIT | RATE | TOTAL
 | ITEM 1 - WALL WORKS
 | General Allowance - No Detail
 | General Allowance to fire rate gap between slab edge &_x000D_glazing across L1,2 & 3 in lift lobby | 10 | lm | 300
 | ITEM 2 - INSTALL FIRE SUPPRESSION SYSTEM
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
 | ITEM 3 - FIRE ENGINEERING FOR LINK_x000D_BRIDGE OPENINGS
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
 | ITEM 4 - SMOKE CURTAIN
 | Signage - S & I:
 | Allowance for signage "WARNING -DROPPING FIRE CURTAIN" | 1 | Item | 250
 | Fire Services - Allow to:
 | Site Establishment & Travel | 1 | Item |  | INCL
 | Reposition single smoke detector | 2 | no | 500
 | Ceiling Makegood - Allowance:
 | Allowance to patch & paint Ceilings | 1 | Item | 500
 | ITEM 5 - INFRARED SMOKE DETECTOR
 | Walls & Ceilings - Allow to:
 | Allowance to open ceiling to enable works | 2 | hrs | 50
 | Install New smoke detector | 3 | m2 | 500
 | Allowance to makegood ceiling area including painting | 1 | Item | 600
 | ITEM 6 - SLAB IMPROVEMENTS
 | Fire separation between slabs - Allow to:
 | Allowance post-tension survey | 4 | items | 400
 | Specialised Labour allowance. | 16 | hrs | 120
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | ITEM 10 - SLAB IMPROVEMENTS
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Misc Materials | 1 | Item | 150
 | Subtotal
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 15d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index/Index Tranche | 21541 | 72135 | 95752 | 38798 | 105178 | 64216
OTHER* | 0 | 0 | 15178 | 0 | 0 | 10457
TOTAL | 21541 | 72135 | 110930 | 38798 | 105178 | 74673
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 8fa0bd46-8cc0-4b88-a09c-f91b34d5c447
Sheet: Changes

 |  | Status | Count | Status | Count
 |  | Low |  | In-Progress
 |  | Medium |  | Closed
 |  | High |  | On-Hold
ID | Description | Priority (L/M/H) | Date Reported | Requested By | Status | Assigned To | Date Closed | Resolution/Comments
1
2
3
4
5
6
7
8
9