tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01a31d1e-d5f9-4040-8860-d52e1a953237
Sheet: TA

1101 | PERSONNEL COMPENSATION | 15268062.18 | 237.07 |  | 439
1131 | BS PY USNON-WGE FLL TIME TEMP | 194540 | 6.54 |  | 439
1151 | CASH AND SUGGESTION AWARDS | 145145.34 | 0.05 |  | 439
1200 | PERSONNEL BENEFITS | 4712085.77 |  |  | 11003
1290 | EMPLOYEE TOS BENEFITS | 177470.66 |  |  | 360
2100 | TRVL & TRANSP OF PERSONS | 356008.13 |  |  | 411
2200 | SHIPMENT OF HOUSEHOLD GOODS | 48115.19 |  |  | 335
2300 | RENT COMMUNICATIONS&UTILITIES | 1471463.34 |  |  | 360
2400 | PRINTING AND REPRODUCTION | 4437.18 |  |  | 386
2500 | OTHER SERVICES | 1089872.16 |  |  | 389
2550 | AGREEMENTS | 1631427.3 |  |  | 437
2600 | GASOHOL | 702843.85 |  |  | 326
3140 | NON-ACCT&NON-CAP&NON-SNSTV EQP | 490803.11 |  |  | 234
3154 | FURNTR&FIXTURES ACCTBLNON-CAP | 51011.64 |  |  | 301
3155 | MOTOR VEHICLES ACCTBLNON-CAP | 236236.3 |  |  | 277
4200 | INSURANCE CLAIMS AND INDEMNIT | 4515.18 |  |  | 367
4300 | PROMPT PAYMENT ACT-INTEREST | 755.43 |  |  | 354
Spreadsheet: 01a8a2aa-7b32-4338-bda6-b315541ec653
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Math 246A
 |  | Date | Score | Date | Score | Date | Score | Date | Score
Quiz 10 | 6.1-6.3
Quiz 11 | 6.4-6.8
Test 6 | Ch. 6
Quiz 12 | 7.1-7.4
Quiz 13 | 7.5-7.8
Test 7 | Ch. 7
[NAME] | Ch. 1-7
Math 246B
 |  | Date | Score | Date | Score | Date | Score | Date | Score
Quiz 14 | 8.1-8.3
Quiz 15 | 8.4-8.6
Test 8 | Ch. 8, App. C
Quiz 16 | 9.1-9.3
Quiz 17 | 9.4-9.6
Test 9 | Ch. 9, SS 2
[NAME] | Ch. 1-9
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 11c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | <100 | <100 | <100 |  |  |  |  |  |  | <100
FRA |  |  | <100 |  |  | 436 |  | <100 |  | 436
IRS- [NAME] | 798 | 1006 | 322 | <100 |  | 274 | 286 | 160 | 546 | 3392
OIS |  | <100 |  |  |  |  |  |  |  | <100
VNS
Zero Coupon
TOTAL | 798 | 1006 | 322 | <100 |  | 710 | 286 | 160 | 546 | 3828
Estimated swap transaction volumes, week ending July 26, by product type and major currency (number of trades), all participant types, cleared and uncleared.
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 Data Dictionary for major currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 67212d1267801473-excel-2007-vlookup-with-multiple-results-separated-by-commas-scoi-report-3-1-10-thru-3-7-10
Sheet: Techs

Technician | Code | Account # | Zip | Install date | Service call date | Days old | Reason for T/C | Fix Code(s) | Resolution | Column10 | Column11 | Column12
6418 | 2 | 435632 | 18411 | 2010-02-28 00:00:00 | 2010-02-28 00:00:00 |  |  | 1,2 | FITTING,REPLACE DROP
6468 | 10 | 322663 | 18509 | 2010-02-26 00:00:00 | 2010-03-01 00:00:00 |  |  | 2,1 | REPLACE DROP,FITTING
6418 | 6 | 435632 | 18411 | 2010-02-28 00:00:00 | 2010-03-01 00:00:00 |  |  | 1 | FITTING
6468 | 10 | 322663 | 18509 | 2010-02-26 00:00:00 | 2010-03-01 00:00:00 |  |  | 3,2 | OUTSIDE DRP CONN,REPLACE DROP
6418 | 6 | 345632 | 18411 | 2010-02-28 00:00:00 | 2010-03-01 00:00:00
6472 | 15 | 435911 | 18411 | 2010-02-25 00:00:00 | 2010-03-01 00:00:00
6465 | 23 | 319734 | 18504 | 2010-02-25 00:00:00 | 2010-03-01 00:00:00
6468 | 10 | 322663 | 18509 | 2010-02-26 00:00:00 | 2010-03-01 00:00:00
6418 | 22 | 324431 | 18509 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00
6414 | 10 | 344352 | 18503 | 2010-02-24 00:00:00 | 2010-03-01 00:00:00
6423 | 20 | 349730 | 18505 | 2010-02-05 00:00:00 | 2010-03-01 00:00:00
6423 | 20 | 316514 | 18504 | 2010-02-12 00:00:00 | 2010-03-01 00:00:00
6475 | 14 | 316036 | 18504 | 2010-02-09 00:00:00 | 2010-03-02 00:00:00
6472 | 10 | 334987 | 18505 | 2010-03-02 00:00:00 | 2010-03-02 00:00:00
6482 | 1 | 343357 | 18510 | 2010-02-25 00:00:00 | 2010-03-02 00:00:00
6402 | 20 | 781563 | 18444 | 2010-02-27 00:00:00 | 2010-03-02 00:00:00
6418 | 15 | 315847 | 18504 | 2010-02-22 00:00:00 | 2010-03-02 00:00:00
6468 | 10 | 321463 | 18504 | 2010-02-26 00:00:00 | 2010-03-02 00:00:00
6472 | 10 | 334987 | 18505 | 2010-03-02 00:00:00 | 2010-03-02 00:00:00
6482 | 1 | 343357 | 18510 | 2010-02-25 00:00:00 | 2010-03-02 00:00:00
6423 | 12 | 377696 | 18651 | 2010-02-01 00:00:00 | 2010-03-02 00:00:00
6466 | 14 | 318233 | 18504 | 2010-02-15 00:00:00 | 2010-03-02 00:00:00
6475 | 14 | 416841 | 18509 | 2010-02-02 00:00:00 | 2010-03-03 00:00:00
6464 | 21 | 438053 | 18411 | 2010-02-15 00:00:00 | 2010-03-03 00:00:00
6475 | 1 | 394949 | 18505 | 2010-02-16 00:00:00 | 2010-03-03 00:00:00
Spreadsheet: 766420d1643890939-formula-to-determine-operating-date-starting-time-time-increase-by-hour-aligw
Sheet: Sheet1

 |  |  |  | Time | [NAME] |  |  | Currently, Excel "sorts" times with midnight (00:00) being the starting point
 |  |  |  | 0:00:00 |  |  |  | Ideal formula would evaluate cell B5 to determine new "starting point" that would "replace" midnight
 |  |  |  | 1:00:00 |  |  |  | I would assume some sort of "if" statement would be needed, I'm just not sure how
 | Starting Time |  |  | 2:00:00
 | 17:00:00 |  |  | 3:00:00 |  |  |  | So in this example, the new sorted data would show |  |  |  |  |  |  | Or, if [NAME] said 17:00, then the new order would be
 |  |  |  | 4:00:00
 |  |  |  | 5:00:00 |  |  |  | 20:00:00 |  |  |  |  |  |  | 17:00:00
 |  |  |  | 6:00:00 |  |  |  | 21:00:00 |  |  |  |  |  |  | 18:00:00
 |  |  |  | 7:00:00 |  |  |  | 22:00:00 |  |  |  |  |  |  | 19:00:00
 |  |  |  | 8:00:00 |  |  |  | 23:00:00 |  |  |  |  |  |  | 20:00:00
 |  |  |  | 9:00:00 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  |  | 21:00:00
 |  |  |  | 10:00:00 |  |  |  | 1900-01-01 01:00:00 |  |  |  |  |  |  | 22:00:00
 |  |  |  | 11:00:00 |  |  |  | 1900-01-01 02:00:00 |  |  |  |  |  |  | 23:00:00
 |  |  |  | 12:00:00 |  |  |  | 1900-01-01 03:00:00 |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 13:00:00 |  |  |  | 1900-01-01 04:00:00 |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  | 14:00:00 |  |  |  | 1900-01-01 05:00:00 |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  | 15:00:00 |  |  |  | 1900-01-01 06:00:00 |  |  |  |  |  |  | 1900-01-01 03:00:00
 |  |  |  | 16:00:00 |  |  |  | 1900-01-01 07:00:00 |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  | 17:00:00 |  |  |  | 1900-01-01 08:00:00 |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  | 18:00:00 |  |  |  | 1900-01-01 09:00:00 |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  | 19:00:00 |  |  |  | 1900-01-01 10:00:00 |  |  |  |  |  |  | 1900-01-01 07:00:00
 |  |  |  | 20:00:00 |  |  |  | 1900-01-01 11:00:00 |  |  |  |  |  |  | 1900-01-01 08:00:00
 |  |  |  | 21:00:00 |  |  |  | 1900-01-01 12:00:00 |  |  |  |  |  |  | 1900-01-01 09:00:00
 |  |  |  | 22:00:00 |  |  |  | 1900-01-01 13:00:00 |  |  |  |  |  |  | 1900-01-01 10:00:00
 |  |  |  | 23:00:00 |  |  |  | 1900-01-01 14:00:00 |  |  |  |  |  |  | 1900-01-01 11:00:00
 |  |  |  |  |  |  |  | 1900-01-01 15:00:00 |  |  |  |  |  |  | 1900-01-01 12:00:00
 |  |  |  |  |  |  |  | 1900-01-01 16:00:00 |  |  |  |  |  |  | 1900-01-01 13:00:00
 |  |  |  |  |  |  |  | 1900-01-01 17:00:00 |  |  |  |  |  |  | 1900-01-01 14:00:00
 |  |  |  |  |  |  |  | 1900-01-01 18:00:00 |  |  |  |  |  |  | 1900-01-01 15:00:00
 |  |  |  |  |  |  |  | 1900-01-01 19:00:00 |  |  |  |  |  |  | 1900-01-01 16:00:00
Spreadsheet: 36827d1234796429-active-task-list-active-task-list
Sheet: Sheet1

ID | Task | Date Set | Date Due | Comments | Completed
1 | task1 | 2009-01-14 00:00:00 | 2009-01-31 00:00:00 |  | yes
2 | [NAME] | 2009-01-14 00:00:00 | 2009-04-30 00:00:00
3 | task3 | 2009-01-14 00:00:00 | 2009-06-30 00:00:00
4 | task4 | 2009-01-15 00:00:00 | 2009-06-30 00:00:00
5 | task5 | 2009-01-14 00:00:00 | 2009-01-31 00:00:00 |  | yes
6 | task6 | 2009-01-14 00:00:00 | 2009-02-07 00:00:00 |  | yes
7 | [NAME] | 2009-01-14 00:00:00 | 2009-01-23 00:00:00
8 | task8 | 2009-01-15 00:00:00 | 2009-06-30 00:00:00
9 | task9 | 2009-01-15 00:00:00 | 2009-09-30 00:00:00
10 | task10 | 2009-01-27 00:00:00 | 2009-03-31 00:00:00
Spreadsheet: 841078d1693326914-multiply-by-different-qty-depending-on-txt-sample
Sheet: Sheet1

item # | description | um | due date | mo | department | qty
MIX10 | 12% MATCHA GREEN TEA | [NAME] | 2023-08-29 00:00:00 | MO00029197 | PA01 | 3000
9830 | 3 GALLON MATCHA GREEN TEA | CAN | 2023-08-29 00:00:00 | MO00029198 | PA02 | 2033
COATING04 | COATING - MANGO | LBS | 2023-08-29 00:00:00 | MO00029003 | PA04 | 20860
8102 | 24 - SINGLES MY/MOCHI MANGO IN DISPLAY | CASE | 2023-08-29 00:00:00 | MO00029011 | PA06 | 1408
9992 | MY/MOCHI ICE CREAM MANGO 6 PCS | CASE | 2023-08-29 00:00:00 | MO00029012 | PA06 | 2200
9938TR | MY/MOCHI MANGO SINGLE SERVE | CASE | 2023-08-29 00:00:00 | MO00029013 | PA06 | 540
9992TC | MY/MOCHI MANGO REPACK TRAY CHIPBOX | EA | 2023-08-29 00:00:00 | MO00029139 | PA06 | 4968
Spreadsheet: 138158d1327534352-hyperlink-with-a-vlookup-for-web-addresses-excel-test-sheet
Sheet: Training Plan

Q2 Sales Training Plan
[NAME] for Q2:
Class Name | Category | Focus Area/Objectives | Required or Optional | Course/Registraiton Link or [NAME] | Credits
Business Code | General
FGHJ | Technical
RTFD | Various
Road Show | Portfolio
New Course Offerings for Q2
Business |  | Develop skills in Accounting |  | Business | 1
Accounting |  | Develop Skills in Accounting |  | Accounting | 1
Spreadsheet: 224485d1364582468-automatic-updating-list-of-current-members-from-table-of-all-time-members-pandora-level-tracker
Sheet: Full Member List

 | Name Of | Date | Current | Date
 | Member | Joined | Status | Left |  | Current Member Total: |  |  | 'Full Member List'!C3 | 'Full Member List'!C3 | 'Full Member List'!C3
 | Member 1 | 2013-01-12 00:00:00 | Member |  |  |  |  |  | 'Full Member List'!C3 | 'Full Member List'!C3 | 'Full Member List'!C3
 | Member 2 | 2013-01-15 00:00:00 | Member
 | Member 3 | 2013-08-23 00:00:00 | Left Faction | 2013-10-06 00:00:00
 | Member 4 | 2013-12-04 00:00:00 | Booted |  |  |  | Member [NAME]
 | Member 5 | 1935-01-01 00:00:00 | Left Faction | 2013-05-19 00:00:00 |  |  | Member 1
 | Member 6 | 2013-10-02 00:00:00 | Member |  |  |  | Member 2
 | Member 7 | 2013-10-05 00:00:00 | Left Faction | 2013-11-02 00:00:00 |  |  | Member 6
 | Member 8 | 2013-05-12 00:00:00 | Left Faction | 2013-07-01 00:00:00 |  |  | Member 11
 | Member 9 | 2013-03-15 00:00:00 | Booted |  |  |  | Member 12
 | Member 10 | 2013-06-04 00:00:00 | Left Faction | 2013-06-10 00:00:00 |  |  | Member 13
 | Member 11 | 2013-09-28 00:00:00 | Member |  |  |  | Member 14
 | Member 12 | 2013-09-28 00:00:00 | Member |  |  |  | Member 15
 | Member 13 | 2013-05-23 00:00:00 | Member |  |  |  | Member 20
 | Member 14 | 2013-08-24 00:00:00 | Member |  |  |  | Member 21
 | Member 15 | 2013-09-23 00:00:00 | Member |  |  |  | Member 22
 | Member 16 | 2013-12-04 00:00:00 | Left Faction | 2013-01-12 00:00:00 |  |  | Member 26
 | Member 17 | 2013-12-06 00:00:00 | Booted
 | Member 18 | 2013-12-08 00:00:00 | Booted
 | Member 19 | 2013-10-06 00:00:00 | Left Faction | 2013-11-12 00:00:00
 | Member 20 | 2013-10-09 00:00:00 | Member
 | Member 21 | 2013-09-23 00:00:00 | Member
 | Member 22 | 2013-06-15 00:00:00 | Member
 | Member 23 | 2013-06-24 00:00:00 | Left Faction | 2013-11-08 00:00:00
 | Member 24 | 2013-07-25 00:00:00 | Left Faction | 2013-09-23 00:00:00
 | Member 25 | 2013-03-12 00:00:00 | Left Faction | 2013-05-10 00:00:00
 | Member 26 | 2013-03-06 00:00:00 | Member
 | Member 27 | 2013-06-05 00:00:00 | Left Faction | 2013-09-21 00:00:00
 | Member 28 | 2013-08-23 00:00:00 | Booted
 | Member 29 | 2013-11-15 00:00:00 | Booted
 | Member 30 | 2013-11-09 00:00:00 | Booted
Spreadsheet: 59746d1260309702-sumproduct-returning-incorrect-value-sample-7-
Sheet: Exec Summary Team View 

 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
Run Rate Reduction | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Team | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
Total Target | 0 | 12.5 | 14.5 | 20 | 20 | 20 | 23 | 34.4 | 34.4 | 34.4 | 37.2 | 38.3 | 288.7 |  | 3.4
Net | 0 | -12.5 | -14.5 | -1.800000000000001 | -1.800000000000001 | -1.800000000000001 | -4.800000000000001 | -16.2 | -16.2 | -16.2 | -19 | -20.1 | -124.9
DTO - US | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 218.4 | 1.8 | 2.1 | 2.9 | 2.9 | 2.9 | 3.4 | 5.1 | 5.1 | 5.1 | 5.5 | 5.6 | 260.8 |  | 0.5
Net | -218.4 | -1.8 | -2.1 | -2.9 | -2.9 | -2.9 | -3.4 | -5.1 | -5.1 | -5.1 | -5.5 | -5.6 | -260.8
Run Rate Reduction Total | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
Capacity Creation | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Team | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DTO - US | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Capacity Creation Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: fa5715fd-1738-4777-813a-c69cdc976784
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Business Name:
Start Up Costs Calculator
Only enter information into the shaded green cells |  |  | NB: Only start up costs not on-going expenditure
 |  |  | PLEASE EXPLAIN WHY THIS COST NEEDS TO BE INCURRED
Premises
Premises Down Payment
Security System Installation
Signage
Lease Security Deposit
Other
Total | 0
Utilities
Public Utilities Deposits
Internet Setup Fee
Telephone Installation
Other
Total | 0
Professional
Legal/Professional Fees
Business Licenses/Permits
Other
Total | 0
Fixed Assets
Vehicles
Machinery
Computer Hardware/Software
Furniture/Equipment
Point of Sale Hardware
Tools & Supplies
Other
Total | 0
Marketing
Advertising for Opening
[NAME]
Brand Development
Business Cards
Other
Total | 0
Capital
Operating Cash (Working Capital)
Other
Total | 0
Other Costs
Other 1 (specify)
Other 2 (specify)
Other 3 (specify)
Other 4 (specify)
Other 5 (specify)
Total | 0
Total Start Up Costs | 0
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: scale

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 10 | 3.455 |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 | 15 | 3.465 |  |  |  |  |  |  |  |  | NEW DEALS
 | 20 | 3.475
 | 30 | 3.485 |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  | Position |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  | 3.52 | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
the trend days are in relation to the PH, PL. 30 min above the PH or 30 min below the PL changes, confirms the short term trend. The daily av at 3717 is what i think the market needs to close below today to suggest a top is in and to look for a downmove next week. a close between 3720-3780 today is neutral/up bias.  a close above 3780 indicates up next week to make new highs. back to the trend day rules: I take a 5 min bar chart. and i look for 6 consecutive closes above the PH or below the PL(30 min) If that happens then i get a trend day status. If only get 4 bars outside the PH,PL and closes back within the predicted ranges then i start the counting over again
Spreadsheet: 769471d1645550681-searching-for-specific-text-and-using-index-and-match-beth-forum
Sheet: Sheet1

MRN | LEAD, VENOUS | Prenatal Screen | HIV-1/2 AG/AB SCREEN *** (Basically  looking for HIV ) | HCG, QUANTITATIVE, PREGNANCY ***( Basically Looking for HCG) | POCT Urine Pregnancy or POCT URINALYSIS PRENATAL or Urine Culture And Sensitivity *** ( Basically looking for  URIN*) | TYPE & SCREEN, PRNATAL | Chlamydia And Neisseria By PCR |  | MRN | [NAME] | Status
418077 |  |  |  |  |  |  |  |  | 418077 | Chlamydia And Neisseria By PCR | Complete
845238 |  |  |  |  |  |  |  |  | 418077 | HIV-1/2 AG/AB SCREEN | Complete
1116441 |  |  |  |  |  |  |  |  | 418077 | LEAD, VENOUS | Complete
1489616 |  |  |  |  |  |  |  |  | 418077 | PRENATAL SCREEN | Complete
4038535 |  |  |  |  |  |  |  |  | 418077 | [NAME] | Complete
4236253 |  |  |  |  |  |  |  |  | 845238 | HCG, Quantitative | Complete
 |  |  |  |  |  |  |  |  | 845238 | HIV-1/2 Ag/Ab SCREEN | Complete
 |  |  |  |  |  |  |  |  | 845238 | Prenatal Screen | Complete
 |  |  |  |  |  |  |  |  | 845238 | TYPE & SCREEN, PRNATAL | Complete
 |  |  |  |  |  |  |  |  | 845238 | [NAME] | Complete
 |  |  |  |  |  |  |  |  | 1489616 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 1489616 | POCT URINE PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | HCG, QUANTITATIVE, PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | HIV-1/2 AG/AB SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4038535 | LEAD, VENOUS | Complete
 |  |  |  |  |  |  |  |  | 4038535 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 4038535 | POCT URINE PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | PRENATAL SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4038535 | [NAME] | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Chlamydia And Neisseria By PCR | Complete
 |  |  |  |  |  |  |  |  | 4236253 | HCG, QUANTITATIVE, PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4236253 | HIV-1/2 Ag/Ab SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Lead, Venous | Complete
 |  |  |  |  |  |  |  |  | 4236253 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Prenatal Screen | Complete
 |  |  |  |  |  |  |  |  | 4236253 | TYPE & SCREEN, PRNATAL | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Urine culture | Complete
 |  |  |  |  |  |  |  |  | 4236253 | [NAME] | Complete
Spreadsheet: 837572d1690267216-formula-needed-for-income-tax-calculation-spreadsheet-as-per-the-attachment-it-calculation-formula
Sheet: Sheet1

EXAMPLE |  | FORMULA NEEDED AS PER BELOW CRITERIA
VALUE | RESULT
285475 | 0 | If "Value" is Less than 3,00,000, then "Result" should be 0
485765 |  | If "Value" is more than 3,00,000 but Less than 6,00,000, then "Result" should be (=15,000+(Value-3,00,000)*5%)
755675 |  | If "Value" is more than 6,00,000 but Less than 9,00,000, then "Result" should be (=45,000+(Value-6,00,000)*10%)
1152850 |  | If "Value" is more than 9,00,000 but Less than 12,00,000, then "Result" should be (=90,000+(Value-9,00,000)*15%)
1350600 |  | If "Value" is more than 12,00,000 but Less than 15,00,000, then "Result" should be (=1,50,000+(Value-12,0,0000)*20%)
1750500 |  | If "Value" is more than 15,00,000, then "Result" should be (=1,50,000+(Value-15,00,000)*30%)
 |  | * So, if the "Value" is input as any number between 0-1500001, then the result should be based on the above required Criteria
 |  | RANGE
 |  | 0 | 300000 | 0 |  |  | Value | 485765
 |  | 300001 | 600000 | 0.05 | 15000 |  | Result
 |  | 600001 | 900000 | 0.1 | 45000
 |  | 900001 | 1200000 | 0.15 | 90000
 |  | 1200001 | 1500000 | 0.2 | 150000
 |  | 1500001 | 100000000 | 0.3 | 150000
Spreadsheet: 95282d1294910378-auto-sort-values-from-highest-to-lowest-based-off-of-value-excelforum-759801-auto-sort
Sheet: Results

Row # | Supervisor | ATT
188 | Manila Supervisor 17 | 572.7446808510639
108 | Manila Supervisor 9 | 544.451219512195
162 | Manila Supervisor 15 | 539.7089947089947
48 | Manila Supervisor 4 | 530.9059829059829
131 | Manila Supervisor 11 | 490.581560283688
58 | Manila Supervisor 5 | 486.1592356687898
175 | Manila Supervisor 16 | 477.1329787234042
212 | Manila Supervisor 19 | 450.3262711864406
72 | Manila Supervisor 6 | 444.9902912621359
19 | Manila Supervisor 2 | 444.225352112676
151 | Manila Supervisor 14 | 434.8048780487806
6 | Manila Supervisor 1 | 429.605504587156
96 | Manila Supervisor 8 | 421.463687150838
33 | Manila Supervisor 3 | 419.9670329670329
85 | Manila Supervisor 7 | 411.4381443298969
139 | Manila Supervisor 13 | 408.6975308641976
201 | Manila Supervisor 18 | 392.4905660377358
120 | Manila Supervisor 10 | 367.0920245398773
Spreadsheet: 526225d1499195115-how-to-rank-the-value-with-respective-to-name-and-place-rank_with_two_criteria
Sheet: Sheet1

Place | Name | Marks | Rank
Chennai | A | 100
Bangalore | A | 70
Mumbai | A | 50
Delhi | A | 40
Bangalore | B | 90
Mumbai | B | 50
Delhi | B | 75
Chennai | C | 100
Bangalore | C | 20
Delhi | C | 30
See Sheet name One city name
Spreadsheet: 727168d1617738496-the-get-the-value-on-specific-date-sample1
Sheet: Sheet1

 |  | INDEX, MATCH
 |  | SUMMARY TABLE
 |  |  |  |  |  |  | 2021-04-06 00:00:00
 |  | ABC | A1 | CIR |  |  | 5 | 8 | 7 | 9 | 1 | 5 | 3 | 2
 |  | [NAME] | B2 | REC |  |  | 21 | 22 | 31 | 51 | 15 | 12 | 2 | 1
 |  | TRT | [NAME] | TRI |  |  | 25 | 45 | 85 | 99 | 12 | 5 | 6 | 8
 |  | MCA | D4 | SQU |  |  | 8 | 9 | 54 | 61 | 70 | 53 | 32 | 1
 |  |  |  |  | CRITERIA4 | 2021-04-08 00:00:00 | <== to be change
 |  | CRITERIA1 | CRITERIA2 | CRITERIA3 | A1 | B2 | [NAME] | D4
 |  | ABC | CIR |  | 7 |  |  |  |  |  | -- WHAT FORMULA TO GET THE VALUE OF THE HIGHLIGHTED BY BLUE
 |  | [NAME] | REC |  |  | 31 |  |  |  |  | -- THERE ARE FOUR CRITERIA TO GET IN SUMMARY TABLE (HIGHLIGHTED BY YELLOW)
 |  | TRT | TRI |  |  |  | 85
 |  | MCA | SQU |  |  |  |  | 54
Spreadsheet: 58687d1258964329-sumproduct-problem-project-20cost-1-
Sheet: Sheet1

PROJECT COST SCHEDULE
 | Door x 100 |  | Panel x 125 |  | Drawer x 150 |  | Pelmet x 175 |  | Cornice x 200 |  | TOTAL COST
Project Cost Ref | Qty | € Unit Price | Qty | € Unit Price | Qty | € Unit Price | Qty | € Unit Price | Qty | € Unit Price
125/09/12 | 4 | 125.5 | 5 | 3.6 | 7 | 18.5 | 12 | 25 | 5 | 17 | 1034.5 | 1034.5
125/09/13 | 6 | 125.5 | 4 | 3.6 | 10 | 18.5 | 2 | 25 | 2 | 17 | 1036.4 | 1036.4
125/09/14 | 2 | 125.5 | 12 | 3.6 | 5 | 18.5 | 2 | 25 | 6 | 17 | 538.7 | 538.7
125/09/15 | 0 | 125.5 | 15 | 3.6 | 6 | 18.5 | 6 | 25 | 16 | 17 | 587 | 587
125/09/16 | 0 | 125.5 | 20 | 3.6 | 9 | 18.5 | 1 | 25 | 33 | 17 | 824.5 | 824.5
125/09/17 | 2 | 125.5 | 0 | 3.6 | 8 | 18.5 | 2 | 25 | 15 | 17 | 704 | 704
125/09/18 | 10 | 125.5 | 0 | 3.6 | 5 | 18.5 | 3 | 25 | 6 | 17 | 1524.5 | 1524.5
125/09/19 | 25 | 125.5 | 12 | 3.6 | 14 | 18.5 | 6 | 25 | 0 | 17 | 3589.7 | 3589.7
125/09/20 | 14 | 125.5 | 14 | 3.6 | 11 | 18.5 | 4 | 25 | 0 | 17 | 2110.9 | 2110.9
125/09/21 | 6 | 125.5 | 6 | 3.6 | 22 | 18.5 | 5 | 25 | 12 | 17 | 1510.6 | 1510.6
125/09/22 | 6 | 125.5 | 15 | 3.6 | 33 | 18.5 | 5 | 25 | 5 | 17 | 1627.5 | 1627.5
125/09/23 | 12 | 125.5 | 22 | 3.6 | 5 | 18.5 | 5 | 25 | 9 | 17 | 1955.7 | 1955.7
TOTAL MATERIAL COST FOR ALL PROJECTS |  |  |  |  |  |  |  |  |  |  | 17044