tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854060d1704024333-choose-col-with-with-filter-choose-cols-filter-with-remove-number-from-brackets
Sheet: Sheet3

 | CHOOSECOLS(FILTER(Sheet1!A6:[NAME]:[NAME]:B10<>"x")),2,3,4,11,17,18)
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
Spreadsheet: andy_zipper__135__ICE - Mar07 Power & Gas VOL
Sheet: E-Mail

 | 2001-03-07 00:00:00
 | POWER
 | PHYSICAL GAS
 | FINANCIAL GAS
 | TOTAL GAS
 |  |  |  |  |  |  | DEALS | VOLUME
 |  |  |  |  |  | POWER
 |  |  |  |  |  | PHYSICAL GAS
 |  |  |  |  |  | FINANCIAL GAS
Spreadsheet: 809444d1671095315-sort-text-with-number-as-prefix-within-a-cell-classeur4-hd-ans
Sheet: Feuil1

AA | 50 | BB |  | CC | 8 | DD | 12 | EE |  | FF
AA | 50 | BB | 100 | CC | 8 | DD | 12 | EE | 1 | FF | 2
Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet20

 |  | Status | Count Of Status
 |  | Didn't join after selection | 1
 |  | Duplicate | 13
 |  | In Progress | 6
 |  | No Show | 15
 |  | Not Interested | 20
 |  | Not Suitable | 40
 |  | Not Yet Scheduled | 9
 |  | Offer Accepted | 2
 |  | [NAME] | 3
 |  | On Hold | 2
 |  | Rejected (1st) | 43
 |  | Rejected (2nd) | 6
 |  | Rejected-Online Test | 9
 |  | Scheduled | 3
 |  | Grand Total | 172
Spreadsheet: 860605d1708631439-formula-to-find-the-last-sales-price-for-a-particiular-unit-and-formula-to-find-last-sal-sample
Sheet: Sheet1

Lot | unit | sale date | agreement sales price
1 | a | 2022-12-31 00:00:00 | 250000 |  |  | Unit | Last Sale | Last Price
2 | b | 2023-03-05 00:00:00 | 265000 |  |  | A | ? | ?
3 | c | 2023-07-15 00:00:00 | 285000 |  |  | B | ? | ?
4 | d | 2023-01-15 00:00:00 | 185000 |  |  | C | ? | ?
5 | a | 2024-02-15 00:00:00 | 235000 |  |  | D | ? | ?
6 | b | 2023-01-01 00:00:00 | 23200
7 | c | 2023-05-02 00:00:00 | 234000
8 | d | 2023-11-30 00:00:00 | 235000
9 | a | 2023-11-28 00:00:00 | 265999
10 | b | 2023-10-15 00:00:00 | 267000
11 | c | 2024-01-15 00:00:00 | 234999
12 | d | 2024-02-01 00:00:00 | 185000
13 | a | 2023-08-03 00:00:00 | 125000
14 | b | 2023-09-12 00:00:00 | 135000
15 | c | 2023-07-15 00:00:00 | 140000
16 | d | 2023-06-18 00:00:00 | 138000
17 | a | 2023-10-01 00:00:00 | 263000
18 | b | 2023-06-01 00:00:00 | 26200
19 | c | 2023-12-01 00:00:00 | 271000
20 | d | 2023-11-08 00:00:00 | 283000
Spreadsheet: 791729d1660567305-excel-database-services-and-service-providers-service-providers
Sheet: Lookup

Lookup Member | Services |  | Lookup Service | Members
[NAME] |  |  | Dog Walking
Spreadsheet: 717280d1612551883-help-in-calculation-and-filter-help-in-calculation
Sheet: Rej

Site | (All)
Year | (All)
Row Labels | Sum of TotalRejection
Jan | 15
Feb | 2
Mar | 0
Apr | 2
May | 4
Jun | 7
Jul | 0
Aug | 2
Sep | 9
Oct | 2
Nov | 0
Dec | 19
Grand Total | 62
Spreadsheet: 12019973-a96c-4424-b895-e31f98afeec9
Sheet: Sheet1

Table 10--Global rice exporters, calendar years; monthly revisions and annual changes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2011 |  |  |  | 2012 |  |  |  |  |  | 2013 1/
 | October |  | September | October |  | Monthly | Annual |  | September | October |  | Monthly | Annual
 | 2012 |  | 2012 | 2012 |  | revisions | changes |  | 2012 | 2012 |  | revisions | changes
 |  |  |  |  |  |  | 1,000 metric tons (milled basis)
Argentina | 732 |  | 650 | 650 |  | 0 | -82 |  | 560 | 560 |  | 0 | -90
Australia | 311 |  | 450 | 450 |  | 0 | 139 |  | 500 | 500 |  | 0 | 50
Brazil | 1296 |  | 1100 | 1100 |  | 0 | -196 |  | 800 | 800 |  | 0 | -300
Burma | 778 |  | 600 | 750 |  | 150 | -28 |  | 600 | 600 |  | 0 | -150
Cambodia | 860 |  | 800 | 800 |  | 0 | -60 |  | 950 | 950 |  | 0 | 150
China | 487 |  | 500 | 400 |  | -100 | -87 |  | 600 | 500 |  | -100 | 100
Ecuador | 70 |  | 30 | 30 |  | 0 | -40 |  | 15 | 15 |  | 0 | -15
Egypt | 320 |  | 600 | 600 |  | 0 | 280 |  | 600 | 850 |  | 250 | 250
European Union-27 | 241 |  | 245 | 245 |  | 0 | 4 |  | 235 | 235 |  | 0 | -10
Guinea | 80 |  | 80 | 80 |  | 0 | 0 |  | 80 | 80 |  | 0 | 0
Guyana | 250 |  | 230 | 230 |  | 0 | -20 |  | 250 | 250 |  | 0 | 20
India | 4637 |  | 8000 | 9750 |  | 1750 | 5113 |  | 6500 | 6500 |  | 0 | -3250
Japan | 200 |  | 200 | 200 |  | 0 | 0 |  | 200 | 200 |  | 0 | 0
Korea, South | 4 |  | 5 | 5 |  | 0 | 1 |  | 5 | 5 |  | 0 | 0
Pakistan | 3414 |  | 3750 | 3750 |  | 0 | 336 |  | 4000 | 4000 |  | 0 | 250
Paraguay | 208 |  | 250 | 250 |  | 0 | 42 |  | 200 | 200 |  | 0 | -50
Peru | 50 |  | 20 | 30 |  | 10 | -20 |  | 60 | 60 |  | 0 | 30
Russia | 142 |  | 200 | 200 |  | 0 | 58 |  | 160 | 160 |  | 0 | -40
Thailand | 10647 |  | 6500 | 6500 |  | 0 | -4147 |  | 8000 | 8000 |  | 0 | 1500
Turkey | 90 |  | 75 | 75 |  | 0 | -15 |  | 80 | 80 |  | 0 | 5
Uganda | 40 |  | 35 | 35 |  | 0 | -5 |  | 35 | 35 |  | 0 | 0
United States | 3247 |  | 3500 | 3500 |  | 0 | 253 |  | 3350 | 3350 |  | 0 | -150
Uruguay | 841 |  | 850 | 850 |  | 0 | 9 |  | 850 | 800 |  | -50 | -50
Vietnam | 7000 |  | 7000 | 7000 |  | 0 | 0 |  | 7000 | 7000 |  | 0 | 0
Subtotal | 35945 |  | 35670 | 37480 |  | 1810 | 1535 |  | 35630 | 35730 |  | 100 | -1750
Other | 269 |  | 204 | 239 |  | 35 | -31 |  | 225 | 260 |  | 35 | 21
 |  |  |  |  |  |  |  |  |  |  |  | 0
World total | 36214 |  | 35874 | 37719 |  | 1845 | 1505 |  | 35855 | 35990 |  | 135 | -1729
U.S. Share | 0.08966145689512343 |  | 0.09756369515526565 | 0.09279143137410854 |  | -- | -- |  | 0.09343187839910752 | 0.09308141150319534 |  | -- | --
-- Not available.  Note: All trade data are reported on a calendar-year basis.
1/ Projected.
Source: Production, Supply, & Distribution Online Data Base, FAS/USDA, http://www.fas.usda.gov/psdonline/psdHome.aspx.
Last updated October 11, 2012.
Spreadsheet: 88721d1288591464-find-certain-number-then-copy-it-and-4-other-cells-to-other-worksheet-example
Sheet: Sheet1

1 | a | b | c | d | 6 | e | f | g | h
2 | aa | bb | cc | dd | 7 | ee | ff | gg | hh
3 | aaa | bbb | [NAME] | ddd | 8 | eee | [NAME] | ggg | hhh
4 | aaaa | bbbb | cccc | dddd | 9 | eeee | ffff | gggg | hhhh
5 | aaaaa | bbbbb | ccccc | ddddd | 10 | eeeee | [NAME] | ggggg | hhhhh
Spreadsheet: 733708d1621756956-rental-calculation-for-a-list-of-shops-rental-question_revised-ans
Sheet: Rent Roll 

A. Monthly Rental |  |  |  |  |  |  |  | Rent Free
Floor | Shop | Tenant | Area |  | Start | End | Rental | Start | End | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | ABC | 1216 | Period 1 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00 | 100 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00
 |  |  |  | Period 2 | 2021-01-16 00:00:00 | 2022-12-15 00:00:00 | 150
B2 | 2 | DEF | 450 | Period 1 | 2018-07-20 00:00:00 | 2019-07-19 00:00:00 | 2000 | 2018-07-20 00:00:00 | 2018-09-19 00:00:00
 |  |  |  | Period 2 | 2019-07-20 00:00:00 | 2020-07-19 00:00:00 | 3000
 |  |  |  | Period 3 | 2020-07-20 00:00:00 | 2021-07-19 00:00:00 | 4000
 |  |  |  | Period 4 | 2021-07-20 00:00:00 | 2022-07-19 00:00:00 | 5000
Spreadsheet: 2b81cc6b-c93b-4cc8-89c9-0d95705aa0a5
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: |  |  | 2013-12-03 09:26:12.040000
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.875 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.75 | 102.177 | 102.052 | 101.927 | 101.552
4.625 | 101.705 | 101.58 | 101.455 | 101.08 |  | Note: | Refer To Price [NAME]
4.5 | 100.798 | 100.673 | 100.548 | 100.173 |  |  | For all Price Adjs
4.375 | 99.837 | 99.712 | 99.587 | 98.962
4.25 | 99.08 | 98.955 | 98.83 | 98.205
4.125 | 98.265 | 98.14 | 98.015 | 97.39
4 | 97.259 | 97.134 | 97.009 | 96.384
3.875 | 96.208 | 96.083 | 95.958 | 95.333 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.248 | 102.123 | 101.998 | 101.623
3.75 | 101.601 | 101.476 | 101.351 | 100.976
3.625 | 101.182 | 101.057 | 100.932 | 100.557
3.5 | 100.654 | 100.529 | 100.404 | 100.029
3.375 | 99.899 | 99.774 | 99.649 | 99.024
3.25 | 99.17 | 99.045 | 98.92 | 98.295
3.125 | 98.123 | 97.998 | 97.873 | 97.248 |  | 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 | 2013-12-17 09:26:12.040000
30 DAY | 2014-01-01 09:26:12.040000
45 DAY | 2014-01-16 09:26:12.040000
60 DAY | 2014-01-31 09:26:12.040000
90 DAY | 2014-03-02 09:26:12.040000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 3b39c74e-fd69-471a-b775-bf2365d7d2a4
Sheet: Output - Summary Exhibit

 |  |  |  |  |  | Prepared:
 |  | Occupancy Assumptions
 |  | Unit Type |  | Total # Beds | UW Occupancy | Number of Preleases | [NAME]. Monthly Absorption
 |  | Totals
 |  |  |  |  |  | Rounded Operating Deficit Total:
 |  |  | Occupied | Occupied | Income | Exp. & Mort. | Income/Loss
 |  | Period | Units | Percent | per Period | per Period | per Period
 |  | Month 1
 |  | Month 2
 |  | Month 3
 |  | Month 4
 |  | Month 5
 |  | Month 6
 |  | Month 7
 |  | Month 8
 |  | Month 9
 |  | Month 10
 |  | Month 11
 |  | Month 12
 |  | Month 13
 |  | Month 14
 |  | Month 15
 |  | Month 16
 |  | Month 17
 |  | Month 18
 |  | Month 19
 |  | Month 20
 |  | Month 21
 |  | Month 22
 |  | Month 23
 |  | Month 24
 |  | Month 25
 |  | Month 26
 |  | Month 27
 |  | Month 28
 |  | Month 29
 |  | Month 30
 |  | Month 31
 |  | Month 32
 |  | Month 33
 |  | Month 34
 |  | Month 35
 |  | Month 36
Spreadsheet: 787623d1657896858-excel-formula-to-calculate-special-initial-tax-allowance-a-sia
Sheet: Sheet1

 | I'm kindly asking for the excel formula to calculate special initial allowance and income tax value as shown by the desired answer
 | Notes: Special Initial Allowance
 | if cost is greater than deemed cost - multiply deemed cost by 25%
 | if cost is less than deemed cost - multiply cost by 25%
 | if cost is equal to deemed cost - multiply cost by 25%
 | if deemed cost is 0 - multiply cost by 25%
 | Notes: Income Tax Value
 | if cost is greater than deemed cost - Subract deemed cost by Special intial allowance
 | if cost is less than deemed cost - Subract cost by Special intial allowance
 | if cost is equal deemed cost - Subract cost by Special intial allowance
 | if deemed cost is 0  - Subract cost by Special intial allowance
 | Special Initial Allowance
 | Asset | Passenger Motor vehicle 1 | Passenger Motor vehicle 2 | Passenger Motor vehicle 3 | Passenger Motor vehicle 3
 | Cost | 1350001 | 1000000 | 1300000 | 1300000
 | [NAME] cost | 1300000 | 1200000 | 1300000 | 0
 | Special Initial Allowance
 | Income Tax Value
 | Desired Outcome
 | 0.25
 | Asset | Passenger Motor vehicle 1 | Passenger Motor vehicle 2 | Passenger Motor vehicle 3 | Passenger Motor vehicle 4
 | Cost | 1350001 | 1000000 | 1300000 | 1300000
 | [NAME] cost | 1300000 | 1200000 | 1300000 | 0
 | Special Initial Allowance
 | Income Tax Value
Spreadsheet: 41300d1239794881-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Dec 22-27

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2008-12-22 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2008-12-23 00:00:00 | 06:30:00 | 08:00:00 | 1.5 | 28114 |  | CNC-M
 | 08:00:00 | 09:30:00 | 1.5 | 28115 |  | CNC-M
 | 09:30:00 | 01:30:00 | 3.5 | SHOP
 | 01:30:00 | 03:00:00 | 1.5 | VAC. | 8 | VACATION
2008-12-24 00:00:00 | 06:30:00 | 10:30:00 | 4 | SHOP
 | 10:30:00 | 01:00:00 | 2.5 | VAC.
 | 01:00:00 | 02:30:00 | 1.5 | SHOP | 8 | PARTY
2008-12-25 00:00:00 |  |  |  |  | 8 | HOLIDAY
2008-12-26 00:00:00 |  |  |  |  | 8 | HOLIDAY
 |  |  |  |  |  |  |  | VACATION 65 HRS
 |  | SHOP | 17
 |  | 28114 | 1.5
 |  | 28115 | 1.5
 |  | VACATION | 4
 |  | HOLIDAY | 16
 |  |  | 40 | TOTAL | 40
Spreadsheet: 5c5cdce2-ee10-47aa-a186-2a855a7827c3
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Eiendomsforvaltning og -utvikling
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Veidekke ASA | [NAME] v 4 | 0278 | Oslo | 21 05 50 00 | 21 05 50 01
OBOS Eiendomsforvaltning AS | Hammersborg Torg 1 | 0179 | Oslo | 22 86 59 99 | 22 86 59 76
[NAME] | Spikkestadv. 90 | 3440 | [NAME] | 31 29 79 50
Bryn Eiendom AS | [NAME] v 2 | 0667 | Oslo | 23 37 98 00 | 22 65 65 65
[NAME] | Hyggenv. 35 | 3440 | [NAME] | 31 29 79 50
Scandinavian Development AS | Parkv. 33 | 0258 | Oslo | 24 11 56 56 | 24 11 56 57
Profier AS | Erteløkka 7 | 1384 | Asker | 66 79 99 00
Steen Holding AS | [NAME]. 41 | 2317 | Hamar | 62 52 79 95
AVA Eiendom AS | Hagaløkkv. 7 | 1383 | Asker | 66 85 08 50
StorBergen Boligbyggelag | [NAME] | 5008 | Bergen | 55 94 27 00 | 55 94 27 01
Enqvist Eiendom-Enqvist Eiendomsdrift | Konghelleg. 3 | 0569 | Oslo | 22 80 95 95 | 22 80 95 96
[NAME] | Gartnerv. 16 | 4016 | Stavanger | 51 82 10 00 | 51 82 10 01
Mørstad Invest AS | Industriv. 29 | 2020 | Skedsmokorset | 63 87 65 05 | 63 87 64 87
Tjelta AS | Chr Aug Thorings v 11 | 4033 | Stavanger | 400 01 905
Oslo og Omegn Boligforvaltning AS | Sandakerv. 64 | 0484 | Oslo | 22 12 23 40 | 22 12 23 50
Coor Service Management AS | Veritasv. 1 | 1363 | Høvik | 67 57 92 00 | 67 57 99 45
Reitan Eiendom AS | [NAME] | 7440 | Trondheim | 73 89 10 00 | 73 89 10 33
Constructive Development AS | Parkv. 33 | 0258 | Oslo | 24 11 56 56 | 24 11 56 57
[NAME] |  | 7882 | Nordli | 74 34 34 66 | 74 34 34 66
IHus Eiendomsmegling avd Grünerløkka | Thv Meyers g 44 | 0552 | Oslo | 22 04 08 40 | 22 04 08 48
Pellerin AS | Strandtorget 1 | 9008 | Tromsø | 77 75 55 00 | 77 75 55 01
NCC Property Development AS | Innspurten 9 | 0663 | Oslo | 22 98 68 00
Furuholmen Eiendom AS | Sørkedalsv. 24 | 0369 | Oslo | 23 19 62 80 | 23 19 62 99
[NAME] bygg AS | Luramyrv. 59 | 4313 | Sandnes | 926 51 041
Hinna Park AS | [NAME]. 7 | 4020 | Stavanger | 51 95 73 00 | 51 95 73 01
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 1bc52e83-8346-4bc7-95d8-fabfc7f3cb70
Sheet: NZ Grads

 | Data from Education Statistics Reports |  |  |  |  | Data from Individual Universities
 | Bachelor | Bachelor Honours | Masters | PhD |  | Bachelor | Bachelor Honours | Masters | PhD
1960 |  |  |  |  |  | 25 |  | 4 | 0
1961 |  |  |  |  |  | 27 |  | 8 | 0
1962 |  |  |  |  |  | 17 |  | 6 | 0
1963 |  |  |  |  |  | 38 |  | 7 | 0
1964 | 119 | 15 | 32 | 0 |  | 48 |  | 18 | 0
1965 | 124 | 22 | 18 | 10 |  | 56 |  | 12 | 0
1966 | 133 | 25 | 14 | 3 |  | 52 |  | 10 | 0
1967 | 182 | 25 | 22 | 2 |  | 61 |  | 13 | 1
1968 | 204 | 35 | 12 | 0 |  | 92 |  | 18 | 0
1969 | 222 | 31 | 45 | 0 |  | 119 |  | 31 | 0
1970 |  |  |  |  |  | 106 |  | 43 | 0
1971 | 215 | 36 | 31 | 0 |  | 123 |  | 25 | 0
1972 | 191 | 30 | 26 | 1 |  | 96 |  | 22 | 0
1973 | 290 | 39 | 25 | 3 |  | 112 |  | 17 | 1
1974 | 258 | 39 | 22 | 2 |  | 66 |  | 17 | 0
1975 | 255 | 30 | 22 | 3 |  | 62 |  | 13 | 2
1976 | 182 | 36 | 31 | 2 |  | 56 |  | 11 | 2
1977 | 180 | 30 | 20 | 5 |  | 41 |  | 10 | 0
1978 | 233 | 38 | 21 | 5 |  | 50 |  | 15 | 2
1979 | 178 | 45 | 20 | 5 |  | 49 |  | 10 | 2
1980 | 208 | 26 | 19 | 7 |  | 67 |  | 15 | 0
1981 | 198 | 32 | 11 | 1 |  | 58 |  | 8 | 0
1982 | 210 | 35 | 20 | 2 |  | 59 |  | 5 | 3
1983 | 187 | 32 | 26 | 5 |  | 54 |  | 14 | 2
1984 | 148 | 43 | 12 | 0 |  | 74 |  | 9 | 2
1985 | 203 | 30 | 19 | 4 |  | 97 |  | 11 | 1
1986 | 204 | 25 | 10 | 6 |  | 98 |  | 12 | 0
1987 | 178 | 32 | 8 | 2 |  | 49 |  | 7 | 1
1988 | 197 | 16 | 26 | 0 |  | 74 |  | 4 | 2
1989 | 296 | 29 | 23 | 3 |  | 87 |  | 11 | 2
1990 | 222 | 52 | 18 | 3 |  | 103 |  | 1 | 6
1991 |  |  |  |  |  | 133 |  | 1 | 5
1992 |  |  |  |  |  | 190 |  | 2 | 8
1993 |  |  |  |  |  | 210 |  | 2 | 7
1994 |  |  |  |  |  | 226 |  | 7 | 13
1995 |  |  |  |  |  | 228 |  | 6 | 16
1996 |  |  |  |  |  | 253 |  | 2 | 15
1997 |  |  |  | 13 |  | 234 |  | 4 | 18
1998 |  |  |  | 13 |  | 259 |  | 10 | 15
1999 |  |  |  |  |  | 408 |  | 16 | 19
2000 |  |  |  |  |  | 425 |  | 6 | 25
2001 |  |  |  |  |  | 422 |  | 10 | 29
2002 |  |  |  |  |  | 403 |  | 12 | 16
2003 |  |  |  |  |  | 455 |  | 11 | 28
2004 |  |  |  |  |  | 529 |  | 21 | 38
2005 |  |  |  |  |  | 485 |  | 21 | 30
2006 |  |  |  |  |  | 590 |  | 14 | 30
2007 |  |  |  |  |  | 475 |  | 16 | 38
2008 |  |  |  |  |  | 357 |  | 14 | 27
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 615 | - | 348
Index/OTHER* | 282019 | 79932 | 189739 | 56777
TOTAL | 282019 | 80547 | 189739 | 57125
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 59919d1260446979-formula-query-possible-if-function-testcosting
Sheet: All Works

Project No. | Date | Site | Cost | Site Start Date | Site Completion Date | Month Work Completed |  | To Test : Input Date in Column F or just F2 and Enter
J16022 | 2008-12-18 00:00:00 | High Street, Tenterden, [NAME] | 695
J16023 | 2008-12-19 00:00:00 | Royal Hospital | 995 | 2008-12-24 00:00:00
J16024 | 2008-12-19 00:00:00 | Kingsland House | 795
[NAME] | 2008-12-22 00:00:00 | 43 [NAME] | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00 | Jan
J16026 | 2008-12-22 00:00:00 | 900 Kingsbury Road | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00 | Jan
J16027 | 2008-12-22 00:00:00 | Crewe First Class Lounge | 750 | 2009-01-06 00:00:00 | 2009-01-06 00:00:00 | Jan
J16028 | 2008-12-22 00:00:00 | 242 Fairway Court |  | 2009-01-05 00:00:00
J16029 | 2008-12-23 00:00:00 | [NAME] | 3000 | 2009-01-07 00:00:00 | 2009-01-09 00:00:00 | Jan
[NAME] | 2008-12-23 00:00:00 | Albion Street | 2485 | 2009-01-13 00:00:00 | 2009-01-15 00:00:00 | Jan
J16031 | 2008-12-23 00:00:00 | Travel Shop | 1125 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00 | Jan
J16032 | 2008-12-23 00:00:00 | BUPA Offices | 10453 | 2009-01-12 00:00:00 | 2009-01-23 00:00:00 | Jan
J16033 | 2008-12-23 00:00:00 | 49 Jenkin Road | 595 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00 | Jan
J16034 | 2008-12-23 00:00:00 | [NAME] | 2200 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00 | Jan
Spreadsheet: 817138d1676017117-need-help-with-a-multiple-countif-and-if-statement-example4
Sheet: Sheet1

English Language | English Literature | Mathematics | New Formula | What I need it to show
4 | 3 | 4 |  | 4
4 | 4 | u |  | 2
4 | u | u |  | 2
u | u | 3 |  | 2
3 | 3 | 3 |  | 4
u | 3 | 3 |  | 4
3 | u | 3 |  | 4
Spreadsheet: rick_buy__32745__0823_Violation
Sheet: Sheet1

 | To: |  | [NAME], [NAME] and [NAME]
 | Copy to: |  | Distribution
 | From: |  | Global Risk Management Operations
 | Date: |  | 2001-08-24 00:00:00
 | Re: |  | Limit Violations and Notifications for August 23, 2001
 |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  | Violation/
 |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  | ($MMs) |  |  |  |  |  | ($MMs) |  | ($MMs)
1 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 2 Mil Bbl WTI | Net Open Position | (4.37) Mil Bbl WTI | 29 |  | -4065 |  | -32506 |  |  | Due to the $2 October 2001 price increases, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
2 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 3 Mil Bbl WTI | Maturity Gap Risk | (4.37) Mil Bbl WTI | 21 |  | -4065 |  | -32506 |  |  | Due to the $2 October 2001 price increases, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
3 | Enron Global Markets |  | EOL 24/7 Crude Trading | B | 3 |  | VAR | 3.23 | 15 |  | -4065 |  | -32506 |  |  | The Crude EOL VAR violation is due to the portfolio having a 4.37 million bbl short position and the September Nymex contract increased $.26/bbl.
4 | Enron Americas |  | Gas Trading | B |  | 200 Bcf | Maturity Gap Risk | (410) Bcf | 53 |  | -15512 |  | 649777 |  |  | The Maturity Gap Risk violation is driven by short fixed price positions in the three month period between March 2002 and May 2002. The Financial Desk is carrying the majority of those positions, (365) Bcf, between March 2002 and May 2002.
5 | Enron Americas |  | Gas Trading | B |  | 500 Bcf | Net Open Position | (580) Bcf | 19 |  | -15512 |  | 649777 |  |  | The Net Open Position violation is driven by Alberta Power Desk’s (247) Bcf short gas positions, the Financial Desk’s (120) Bcf short positions and the East Power Desk’s (75) Bcf short gas positions.
 | B= Business Unit Violation |  | C= Concentration Violation
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 886581d1736616417-date-formula-subscription
Sheet: Subscription

LAST NAME | FIRST NAME | MI | ADDRESS | CITY | STATE | ZIP CODE | PHONE NUMBER | [NAME] | DATE JOINED | Subscription Date | Renewal Due
Last | First |  | 123 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2012-03-24 00:00:00 | 2025-01-05 00:00:00
Last | First |  | 124 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] |  | 2025-01-07 00:00:00
Last | First |  | 125 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2023-07-31 00:00:00
Last | First |  | 126 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2012-03-24 00:00:00 | 2024-12-25 00:00:00
Last | First |  | 127 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2018-04-27 00:00:00
Last | First |  | 128 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2015-11-20 00:00:00
Last | First |  | 129 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] |  | 2025-01-10 00:00:00
Last | First |  | 130 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2012-03-24 00:00:00
Last | First |  | 131 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL] | 2012-03-24 00:00:00
Last | First |  | 132 America St | Seattle | WA | 12345 | [PHONE] | [EMAIL]