tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 759866d1639765423-formatting-multiple-cells-at-once-help
Sheet: Sheet1

Date | Time Frame |  | Dispatch | Arrive | Complete |  | Essentially, I need the cells in column E formatted to show red if they are greater than the cells in column B. Helping me highlight when our [NAME] time is greater than our 1st time frame number.
2021-12-01 00:00:00 | 14:00:00 |  | 16:17:00 | 14:57:00 | 15:12:00
2021-12-01 00:00:00 | 10:00:00 |  | 13:26:00 | 13:54:00 | 14:14:00
2021-12-01 00:00:00 | 10:00:00 |  | 08:59:00 | 09:32:00 | 10:00:00
2021-12-01 00:00:00 | 10:00:00 |  | 10:01:00 | 10:33:00 | 11:13:00
2021-12-01 00:00:00 | 08:00:00 |  | 08:42:00 | 09:06:00 | 09:57:00
2021-12-01 00:00:00 | 10:00:00 |  | 12:09:00 | 12:37:00 | 14:19:00
2021-12-01 00:00:00 | 17:00:00 |  | 16:15:00 | 16:25:00 | 18:10:00
2021-12-01 00:00:00 | 08:00:00 |  | 08:41:00 | 09:03:00 | 12:06:00
Spreadsheet: 742687d1627967567-cant-sum-numbers-generated-by-a-formula-cant-sum-numbers-generated-by-a-formula
Sheet: Sheet1

Transaction Date | Description 1 |  | Total $ | Eating out | Grocery | Car
7/6/2021 | PC EXPRESS |  | -155.1
7/7/2021 | ESSO |  | -51.98
7/11/2021 | BEN&JERRY |  | -13.15
7/12/2021 | STARBUCKS |  | -9.2
7/21/2021 | ULTRAMAR |  | -29.42
Spreadsheet: 132836d1323969700-combining-book1
Sheet: Sheet1

Oct | Nov
101261 | 101261
103331 | 103331
103367 | 103352
103459 | 103367
103466 | 103459
103478 | 103466
103491 | 103478
103523 | 103491
103588 | 103523
103696 | 103588
103757 | 103696
103812 | 103757
103875 | 103812
103954 | 103875
103972 | 103972
103974 | 103974
104017 | 104017
Spreadsheet: 327858d1403704531-count-values-with-conditions-count-validation
Sheet: Sheet1

Project | Project Name | Project ID | Name | location | Position | Rate
1111 | Mepz | 132 | Arun | Onsite | Manager | 50
1111 | Mepz | 133 | Arjun | Offshore | Manager | 50
1111 | Mepz | 134 | Siva | Onsite | Manager | 60
1111 | Mepz | 135 | Ram | Offshore | Manager | 60
1111 | Mepz | 136 | Raja | Onsite | Manager | 70
1111 | Mepz | 137 | Vijay | Onsite | Manager | 70
1111 | Mepz | 138 | Praveen | Offshore | Supervisor | 40
1111 | Mepz | 139 | Sherihan | Onsite | Supervisor | 40
1111 | Mepz | 140 | Sahayaraj | Offshore | Supervisor | 50
1111 | Mepz | 141 | Kishore | Onsite | Supervisor | 50
1111 | Mepz | 142 | Ramesh | Onsite | Supervisor | 100
2222 | Sez | 143 | Anbumathi | Offshore | Supervisor | 60
2222 | Sez | 144 | Ramu | Onsite | Supervisor | 70
2222 | Sez | 145 | Raju | Offshore | Senior Manager | 80
2222 | Sez | 146 | [NAME] | Onsite | Senior Manager | 50
5656 | DLF | 147 | Saj | Offshore | Senior Manager | 60
5656 | DLF | 148 | Sajesh | Onsite | general manager | 70
5656 | DLF | 149 | Vimal | Offshore | general manager | 80
Spreadsheet: tracy_geaccone__40463__2002 1N9 Forecast
Sheet: Steele

Enron Pipeline Company (1N9)
Preferred Dividend
From ECT Investments Holding Corp. - 22Z
Dividend [NAME] (Liquidation Preference) |  |  | 100000
Days in Year |  |  | 360 | 30/day months
Interest |  |  | 3 Mnth Libor + .25% |  | 0.0025
Due Date:
Begin | January | February | March | April | May | June | July | August | September | October | November | December | Total
End
Days | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
LIBOR | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
All in Rate
Daily Rate
Dividend Base
[NAME]
# of Shares | 615 | 615 | 615 | 615 | 615 | 615 | 615 | 615 | 615 | 615 | 615 | 615
Dividend
Preferred Dividend Calculation
From ECT Investing Partners, LP - 987
Dividend [NAME] (Liquidation Preference) |  |  | 79
Days in Year |  |  | 360 | 30/day months
Interest |  |  | 3 Mnth Libor + .25% |  | 0.0025
Due Date:
Begin | January | February | March | April | May | June | July | August | September | October | November | December | Total
End
Days | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
LIBOR | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
All in Rate
Daily Rate
Dividend Base
[NAME]
# of Shares | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000 | 320000
Dividend
Spreadsheet: mary_fischer__25386__March Log2
Sheet: GRID

CLEAR SKY
GRID VARIANCE
 |  |  |  | Chargeable to: A=AEP, N=Force Majeure, E=Enron, T= TXU
Month: |  |  |  | Reason: U=unscheduled outage, S= scheduled outage, F=fluctuation
Charge | Date off | Time off | Date on | Time on | Hrs. | Reason | Comments
E | 2002-03-20 00:00:00 | 0750 | 2002-03-20 00:00:00 | 1430 | 7.16 | S | Scheduled power outage on 69kV line for moving arrestors to the correct side of gang switch and repairing damaged gang switch blade.
Spreadsheet: 28364d1222453921-vlookup-and-countif-team-league
Sheet: Sheet2

Sales Rep | Application Value | [NAME] | MPPI | HC
[NAME] | 250 | 2008-09-29 00:00:00 | BA | BA
[NAME] | 100 | 2008-09-02 00:00:00 | TA | TA
[NAME] | 600 | 2008-09-01 00:00:00 |  | JA
[NAME] | 520 | 2008-09-06 00:00:00
[NAME] | 120 | 2008-09-07 00:00:00 | MA | MA
[NAME] A | 328 | 2008-09-09 00:00:00 | SA |  |  | 1. If I delete a date in column C or enter text, below the number reduces by one (Apps on LMD). I.e. it is no longer being counted.
[NAME] | 300 | 2008-09-09 00:00:00 |  | BA
[NAME] | 278 | 2008-09-01 00:00:00 |  |  |  | 2. I now need this to happen to columns O and R.
[NAME] | 956 | 2008-09-02 00:00:00 | JA
[NAME] | 756 | 2008-09-03 00:00:00 |  | MA |  | Example in row 2 - Bob A has an application of £250, returned on 29/9, with [NAME] and HC.
[NAME] | 300 | 2008-09-01 00:00:00 | TA
[NAME] | 550 | 2008-09-01 00:00:00 |  | TA |  | If i deleted the date in C2, below in my table the results would change, as the condition has not been met, therefore cells O and R would not count them either.
[NAME] | 100 | 2008-09-05 00:00:00 | BA
[NAME] | 500 | 2008-09-05 00:00:00 | BA |  |  | This works great using the ISNUMBER.
[NAME] | 63 | 2008-09-22 00:00:00 | TA | TA
[NAME] A | 2000 | 2008-09-22 00:00:00 | SA | SA |  | However, when I enter text I.e (Cancelled) in cell C2, cell J24 removes one sale, however [NAME] and R24 stay the same.
 |  |  |  |  |  | Advisor | [NAME] | [NAME] | [NAME] | Apps on MLD | Apps Received Target | [NAME] | Total Value of apps received | MPPI Sales | MPPI Conversion | MPPI Target | HC sales | HC Conversion | HC Target
 |  |  |  |  |  | [NAME] |  | 10 | 4 | 4 | 5 | 0.8 | 1150 | 3 | 0.75 | 0.5 | 2 | 0.5 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 3 | 3 | 5 | 0.6 | 1834 | 1 | 0.3333333333333333 | 0.5 | 1 | 0.3333333333333333 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 2 | 2 | 5 | 0.4 | 876 | 1 | 0.5 | 0.5 | 2 | 1 | 0.45
 |  |  |  |  |  | [NAME] A |  | 10 | 2 | 2 | 5 | 0.4 | 2328 | 2 | 1 | 0.5 | 1 | 0.5 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 5 | 5 | 5 | 1 | 1533 | 3 | 0.6 | 0.5 | 3 | 0.6 | 0.45
 |  |  |  |  |  | Total | 0 | 50 | 16 | 16 | 25 | 0.6399999999999999 | 7721 | 10 | 0.6366666666666666 |  | 9 | 0.5866666666666667
Spreadsheet: 767921d1644737108-top-n-values-top-n-students-aligw
Sheet: Sheet1

Student | Marks
Rajesh |  |  | Top N | Student | Marks
[NAME] |  |  | 2
Milton
Mark
Ramesh
Martin
Spreadsheet: 867032d1713943757-populate-sheet-with-specific-data-from-a-different-sheet-test-report
Sheet: Sprint Roadmap

Sprint 1 |  |  | Sprint 2 |  |  | Sprint 3 |  |  | Sprint 4
Issue Number | Summary | Points | Issue Number | Summary | Points | Issue Number | Summary | Points | Issue Number | Summary | Points
1 | Work Summary 1 | 1 | 4 | Work Summary 4 | 2 | 48 | work 4 | 1 | 9 | Work Summary 9 | 1
2 | Work Summary 2 | 1 | 5 | Work Summary 5 | 3 | 49 | work 5 | 3 | 10 | Work Summary 10 | 2
3 | Work Summary 3 | 2 |  |  |  | 50 | work 6 | 2
Spreadsheet: 155463d1336858104-need-help-with-macros-for-invoice-worksheet-invoice-sheet-rev2
Sheet: Sheet1

Code | Description | Price |  | STOCK |  |  | STOCK
203010 | PART A | 2 |  | 10 |  |  | 10
203011 | PART B | 4 |  | 20 |  |  | 20
203012 | PART C | 6 |  | 30 |  |  | 30
203013 | PART D | 8 |  | 40 |  |  | 40
203014 | PART E | 10 |  | 50 |  |  | 50
203015 | PART F | 12 |  | 60 |  |  | 60
203016 | PART G | 14 |  | 70 |  |  | 70
Spreadsheet: 750833d1633671954-compare-1-value-whether-it-is-either-1st-2nd-or-3rd-largest-with-multiple-criterias-compare-with-3-largest-values-with-multiple-criteria
Sheet: Main

Branchwise Business Summary
Branch | Location Head | [NAME] | Amt
Mumbai | Mumbai Total | M1
[NAME] | P-1 | M1 | 20
[NAME] | P-2 | M1 | 80 |  | T1
Vishwas [NAME] | P-3 | M1 | 40
Mumbai Unaccounted | Mumbai Unaccounted | M1 | 10
M1 Total
Bangalore | Bangalore Total | M2
Pradesh [NAME] | P-4 | M2 | 35
D [NAME] | P-5 | M2 | 60 |  | T3
Bangalore Unaccounted | P-6 | M2 | 70 |  | T2
M2 Total
PAN INDIA
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Development Costs

HR&A Advisors, Inc.
Inner Loop East Reconstruction Project
Real Estate Development Construction Cost Estimates
Zip Code | 14607
Construction Type | Floors | SF | Cost | Cost/SF
Apartment | 1 to 3 | 100000 | 12288600
Apartment | 4 to 7 | 100000 | 14682600
Office 2 | 2 to 4 | 20000 | 32000000 | 160
Store Retail | 1 | 10000 | 1016100 | 110
Store Retail | 1 | 20000 | 1742850 | 100
Supermarket | 1 | 30000 | 3307050
 |  | per unit | per sf
Surface Parking |  | 15000
Structured Parking |  | 3000
Spreadsheet: sara_shackleton__36451__ML ENE ISDA
Sheet: ms

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER:
COUNTERPARTY: | Merrill Lynch International | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | Enron Corp
GUARANTOR (RATING) | Merrill Lynch & Co., Inc.
LIMIT $ MILLIONS | uncapped
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $
COLLATERAL ROUNDING
Delivery Amount
Return Amount
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - Additional E of D
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change
-Below = S&P/Moody's | BBB- | BBB-
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100
-Guarantor ($[NAME]) |  | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | 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] | x3-3559
Spreadsheet: 794234d1661952701-vlookup-with-multiple-conditions-template-mock
Sheet: Products

 | S # | Panels | Length | [NAME] | Price
 |  | KNP-FLAT
 |  | KNP-4-SIDED |  |  |  |  | PWC Colors | Powder  per LB | Touch up
 |  | V-GROOVE |  |  |  |  | White-KIN-W (RAL 9016) | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] (RAL 1013) | [NAME] | [NAME]
 | S # | Steel Detail | Length | [NAME] | Price |  | [NAME] (RAL 7035) | [NAME] | [NAME]
 |  | J-CHANNEL AS PER T-2017JCG2-00 |  | 2.3091 |  |  | [NAME] (RAL 7045) | [NAME] | [NAME]
 |  | Z-Clips as per T-2010Z | 3 | 1.5 |  |  | Black-KIN-B (RAL 9004)
 |  | J-Channel as per T-2008CD2 |  | 2.9157 |  |  | [NAME] (RAL 8014) | [NAME] | [NAME]
 |  | Z-Clips as per 11.040-00 drawing | 3 | 1.5 | 0.2 |  | [NAME] (RAL 7038) | [NAME] | [NAME]
 |  | 4” Offset Bracket as per KNP OFFSET4IN | 4 | 1 |  |  | Venetian Cream-KIN-VC (RAL 9001)
 |  | L-Brackets as per LBRACKET-000 drawing | 4 | 1.5 |  |  | [NAME] (RAL 8023) | [NAME] | [NAME]
 |  | [NAME] as per T-2008LCLIPD2 | 1.9375 | 1.9375 |  |  | [NAME] (RAL 7032) | [NAME] | [NAME]
 |  | 1" Offset bracket as per INSTALL19A | 1 | 1 |  |  | CUSTOM COLOR | [NAME] | [NAME]
 |  | J-Channel as per T-2008CD2V |  | 2.9157 |  |  | CUSTOM COLOR | [NAME] | [NAME]
 |  | Z-Channel as per T-2008ZD2V |  | 2.8532 |  |  | CUSTOM COLOR | [NAME] | [NAME]
 |  | 2" GALV Z-CHAN W 1" OFFSET |  | 2.3091 |  |  | CUSTOM COLOR | [NAME] | [NAME]
 |  | 2" Offset bracket as per INSTALL19A | 2 | 1
 |  | 3" Offset bracket as per T-2021_OS-3 | 3 | 1
 |  | J-Channel as per T-2017JCG2-00 |  | 3.125
 | 15 | Z-Channel as per T-2008ZD2V
 | 16 | 1" Offset bracket as per T-2020_0S-1”
 | 17 | 2" GALV J‐CHANNEL W/1" OFFSET
 | 18 | 2" GALV, J‐Z‐CHANNEL W/1" OFFSET
 | 19 | Touch Up paint
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
Spreadsheet: 167135d1341913486-copy-data-with-3-horisontal-or-vertical-criterias-index-and-match-test-excel-sample
Sheet: Data Source

Cars | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909
Eurasia | 1353 | 1953 | 2553 | 3153 | 3753 | 4353 | 4953 | 5553 | 6153 | 6753 | 7353 | 7953
MEA | 797 | 707 | 617 | 527 | 437 | 347 | 257 | 167 | 77 | 99 | 8803 | 9193
SEAP | 241 | 261 | 281 | 301 | 321 | 341 | 361 | 381 | 401 | 421 | 441 | 461
India | 8989 | 8766 | 8543 | 8320 | 8097 | 7874 | 7651 | 7428 | 7205 | 6982 | 6759 | 6536
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287
Boats | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 2083 | 235 | 876 | 1517 | 2158 | 2799 | 3440 | 4081 | 4722 | 5363 | 6004 | 6645
Eurasia | 1953 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225
MEA | 1823 | 215 | 888 | 1561 | 2234 | 2907 | 3580 | 4253 | 4926 | 5599 | 6272 | 6945
SEAP | 1693 | 205 | 999 | 1793 | 2587 | 3381 | 4175 | 4969 | 5763 | 6557 | 7351 | 8145
India | 1563 | 195 | 876 | 1557 | 2238 | 2919 | 3600 | 4281 | 4962 | 5643 | 6324 | 7005
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287 | 2287
Spreadsheet: 148283d1333326012-vlookup-return-multiple-values-into-separate-cells-example
Sheet: Sheet2

products_id
104
113
217
218
225
279
280
501
503
642
643
644
645
646
649
653
913
1109
1111
1113
1265
1266
1267
1269
1271
1280
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1573
1574
1579
1581
1718
1719
1821
1961
1962
1964
1965
2010
2011
2080
2272
2300
2360
2389
2390
2636
2637
2638
2639
2640
2641
2642
2643
2644
2645
2647
2648
2649
2650
2651
2652
2653
2654
2749
2750
2759
2760
2762
2776
2886
2938
2940
2979
2980
2981
2982
2983
2984
3296
3303
3304
3305
3556
3557
3558
3559
3560
3561
Spreadsheet: jonathan_mckay__16900__Area Managers
Sheet: Chestermere

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Chestermere Regional Community Association |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 898.88
 | February | 625.16
 | March | 457.42
 | April | 500.9
 | May | 136.34
 | June | 182.8
 | July | 143.81
 | August | 88.25
 | September | 113.21
 | October | 367.22
 | November | 545.53
 | December | 759.66
 | TOTAL:
Spreadsheet: 160149d1338989127-need-formula-that-calculates-sums-of-multiple-cycles-within-column-example
Sheet: Sheet1

TIME | HFACTOR | BLOWPT | COOKTIME
1900-01-01 00:00:00 | 0.63457 | NOBLOW
00:01:00 | 1.23741 | NOBLOW |  |  |  |  | TIME | HFACTOR | BLOWPT
00:02:00 | 2.37568 | NOBLOW |  |  |  |  |  | >5 | NOBLOW
00:03:00 | 4.79514 | NOBLOW |  |  |  |  |  | 5 | NOBLOW
00:04:00 | 6.12894 | NOBLOW
00:05:00 | 12.29853 | NOBLOW
00:06:00 | 39.79284 | BLOW
00:07:00 | 39.79284 | BLOW
00:08:00 | 39.79284 | BLOW
00:09:00 | 0.76581 | NOBLOW
00:10:00 | 1.45827 | NOBLOW
00:11:00 | 3.7829 | NOBLOW
00:12:00 | 11.73659 | NOBLOW
00:13:00 | 32.48762 | NOBLOW |  |  | [NAME] that Worked for counting total of, but not cycle
00:14:00 | 49.31267 | BLOW |  |  | DCOUNT(A3:C19, [NAME], I5:J6)
00:15:00 | 49.31267 | BLOW |  |  | SUMPRODUCT(--(B4:B19>5),--(C4:C19="NOBLOW"))
Spreadsheet: 59449a14-aa6f-4df5-bd35-c8a6e10734cd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTIK | Test | FFTIK | [NAME] and Identification by [NAME] burgdorferi | [NAME] | Polymerase Chain Reaction (PCR) |  |  |  |  |  | [NAME] submitted in sterile, dry container. Ship ambient.  Note:  Specimens received in formalin or alcohol will be rejected. |  | Specimens other than	Tick Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Negative   Test Performed By:  IMUGEN Reference Diagnostic Division                                         315 Norwood Park South                                         Norwood, MA  02062 | Peak season - 2 times per week | 11-15 days | 12-15 days |  |  |  |  |  |  | IMUGEN Reference Diatnostics Division
FFTIK | [NAME] | INSECT | Insect |  |  |  | Ambient
FFTIK | Result | Z0914 | Specimen Number | Specimen Number | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTIK | Result | Z0915 | Species | Species | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTIK | Result | Z0916 | Sex | Sex | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTIK | Result | Z0917 | Stage | Stage | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTIK | Result | [NAME] | Test Result | Test Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 763045d1641957311-how-do-i-create-an-autofill-template-excel-template-2
Sheet: Sheet1

P# W#
Name | Associate Number | Performance % |  |  | Name: | Associate Number
 | 523095 | 29.3 |  |  | [NAME] | 408123
 | 827943 | 40.5 |  |  | [NAME] | 120421
 | 987234 | 49.5 |  |  | [NAME] | 523095
 | 120421 | 63.4 |  |  | Jeremiah | 827943
 | 408123 | 76.7 |  |  | [NAME] | 987234
 | 879634 | 96.6 |  |  | Jasmine | 918347
 | 918347 | 99.5 |  |  | [NAME] | 879634
 |  | Goal: 70%
 |  |  |  |  | Quarter | Period | Week | Year | Every Period has 4 weeks with the exception of p13 2023/2024 which has 5. I want excel to detect the date and determine which P and W we're on.
 |  |  |  |  | 1 | 1 | 01/30-02/26 | 2022
 |  |  |  |  | 1 | 2 | 02/27-03/26 | 2022
 |  |  |  |  | 1 | 3 | 03/27-04/23 | 2022 |  | Example of weeks
 |  |  |  |  | 1 | 4 | 04/24-05/21 | 2022 |  | PERIOD | WEEK | DATES
 |  |  |  |  | 2 | 5 | 05/22-06/18 | 2022 |  | 1 | 1 | 1/29-2/04
 |  |  |  |  | 2 | 6 | 06/19-07/16 | 2022 |  | 1 | 2 | 2/5-2/11
 |  |  |  |  | 2 | 7 | 07/17-08/13 | 2022 |  | 1 | 3 | 2/12-2/18
 |  |  |  |  | 3 | 8 | 08-14-09/10 | 2022 |  | 1 | 4 | 2/19-2/25
 |  |  |  |  | 3 | 9 | 09/11-10/8 | 2022 |  | 2 | 1 | 2/26-3/4
 |  |  |  |  | 3 | 10 | 10/9-11/5 | 2022 |  | 2 | 2 | 3/5-3/11
 |  |  |  |  | 4 | 11 | 11/6-12/3 | 2022 |  | 2 | 3 | 3/12-3/18
 |  |  |  |  | 4 | 12 | 12/4-12/31 | 2022 |  | 2 | 4 | 3/19-3/25
 |  |  |  |  | 4 | 13 | 1/1/-1/28 | 2023
 |  |  |  |  | 1 | 1 | 1/29-2/25 | 2023
 |  |  |  |  | 1 | 2 | 2/26-3/25 | 2023
 |  |  |  |  | 1 | 3 | 3/26-4/22 | 2023
 |  |  |  |  | 1 | 4 | 4/23-5/20 | 2023
 |  |  |  |  | 2 | 5 | 5/21-6/17 | 2023
 |  |  |  |  | 2 | 6 | 6/18-7/15 | 2023
 |  |  |  |  | 2 | 7 | 7/16-8/12 | 2023
 |  |  |  |  | 3 | 8 | 8/13-9/9 | 2023
 |  |  |  |  | 3 | 9 | 9/10-10/7 | 2023
 |  |  |  |  | 3 | 10 | 10/8-11/4 | 2023
 |  |  |  |  | 4 | 11 | 11/5-12/2 | 2023
 |  |  |  |  | 4 | 12 | 12/3-12/30 | 2023
 |  |  |  |  | 4 | 13 | 12/31-2/3 | 2023/2024
Spreadsheet: da04cdee-a934-47eb-981c-2644121dae58
Sheet: Sheet1

Judgeship Number 5 - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/22/2013 8:30:18 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 0201 | 153 | 105 | 258
Precinct 0206 | 16 | 16 | 32
Precinct 0207 | 17 | 19 | 36
Precinct 0402 | 43 | 19 | 62
Precinct 0403 | 45 | 12 | 57
Precinct 0404 | 20 | 10 | 30
Precinct 0405 | 19 | 8 | 27
Precinct 0408 | 16 | 5 | 21
Precinct 0409 | 19 | 16 | 35
TOTAL | 348 | 210 | 558
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 63061d1264018849-solved-conditional-formatting-with-more-than-three-values-sample-worksheet2
Sheet: Staff Report

 |  | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | [NAME] |  |  |  | H
 | [NAME] |  |  |  |  |  | 15
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  |  | S
 | Cat
 | [NAME] |  |  |  |  |  |  |  | A
 | [NAME] |  |  |  |  | U
Spreadsheet: 118633d1313810146-shorten-formula-to-avoid-maxing-of-cpu-master-budget-twitt-adjustments-ttrial
Sheet: PC & PS Allowances

 | Int. Strip Flooring 1950Lm @ $5.20
 | [NAME]
 | Plumbing PC Items
 | Electrical Fittings
 | Door Hardware
 | Cabinetmaker
 | Tile Supply (345m2 @ $27 m2 Inc GST)
 | Shower Screens , Mirrors and Pool Fencing
 | Carpet. Supply and Fit.
 | Driveway
 | TV [NAME]
 | [NAME] and balustrading and pool fencing
 | [NAME]
 | [NAME]
 | Fireplaces
 | Security System
 | [NAME]
 | Pool
 | Supply & Fit Air Conditioning
 | White Goods
 | Bore Connection
 | TOTAL PC & PS ALLOWANCES
Spreadsheet: 887159d1737370906-sumifs-based-on-2-variables-in-a-specific-sequence-and-upto-a-specific-value-sample
Sheet: Sheet1

 | Cumulative | UP TO | ONE OVER | desired result
 | 200 |  |  | 1.2
 | 500 |  |  | 2
 | 1000 |  |  | 2.3
Fund | Market value | Sequence | Impact cost
F | 110 | 1 | 0.7
B | 50 | 2 | 0.4
A |  | 3 | 0.1
D | 60 | 4 | 0.6
C | 300 | 5 | 0.2
E | 90 | 6 | 0.3