tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772635d1647419884-adding-and-subtracting-a-dollar-amount-from-columns-according-to-multiple-criteria-book1
Sheet: Sheet1

 |  |  | [NAME] 100,00,000 | over 100,000,000 |  |  |  |  | 56899435.8174
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
 |  |  | 122503382.0109 | 115865906.9898
Spreadsheet: ea3d8d8e-46f6-440d-b01c-f40e63d065a6
Sheet: Doubles D

 | DOUBLES | FLIGHT "D"
 |  |  | [NAME] (SH)
 |  |  |  | [NAME]
 |  |  | BYE
 |  |  | Holdstein/Baker (Hart) |  | Palmer/McEntee(UC)
 |  |  |  |  | 82
 |  |  |  | Palmer/McEntee (UC)
 |  |  | Palmer/McEntee (UC) | 81
 |  |  |  |  |  | Palmer/McEntee(UC)
 |  |  |  |  |  | 83
 |  |  | Sandoval/Phan (BU)
 |  |  |  | Phan/Sandoval (BU)
 |  |  | [NAME] (QU) | 84
 |  |  | [NAME] (UC)/ Cusano (SH) |  | Phan/Sandoval (BU)
 |  |  |  | Duarte/ Rubinstein (Bry)
 |  |  |  | 84
 |  |  | Duarte/ Rubinstein (Bry)
 |  |  | Saturday 9:00am | Saturday | Saturday
 |  |  | UCONN | UCONN | UCONN
 |  |  | Quarter Finals | Semi Finals | Finals
Spreadsheet: 9edced88-38ab-4340-8bbb-b7854fe61d11
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 679143017048 | Diamond Rio | [NAME], A | 2012-09-04 | Printed Books | Na | 26.99 | Y | Available
Merch | 9781595552686 | Diamond Rio | (See Upc [PHONE]) [NAME], A | 2009-09-04 | Printed Books | Na | 26.99 | Y | To Be Retired
Spreadsheet: 837508d1690210228-looking-for-information-with-a-formula-document-formula-example
Sheet: Test protocol status

Requirement ID | Status | Comment
Report 1
A-1 | PASSED
A-2 | PASSED
A-3 | PASSED
A-4 | PASSED
A-5 | PASSED
A-6 | PASSED
A-7 | PASSED
A-8 | PASSED
[NAME] | PASSED
A-10 | PASSED
Report 2
A-1 | FAILED
A-2 | PASSED
A-15 | PASSED
A-25 | FAILED
[NAME] | PASSED
A-6 | PASSED
Report 3
A-2 | FAILED
A-4 | PASSED
A-5 | PASSED
A-6 | PASSED
A-7 | PASSED
A-12 | PASSED
Spreadsheet: 178080d1346650386-number-tabulation-change-by-other-cells-contents-kbs-2012_postable
Sheet:  PA  VA

 |  |  |  | Fills |  | air | PLAN
 |  |  |  |  |  |  |  | August
900 |  | launch |  | NEPAAL07 |  |  | 9 | 1030
9.15 |  | camden |  | 21 | cherry |  | 0.25 | 0
9.45 |  | done |  |  |  |  | 0.5 | 0.05
12.048 |  | va med |  | 54 | Green Melon | 26 | 2.33 | 2
3.048 |  | done |  |  |  |  | 3 | 2.5
3.048 |  | dal tile |  |  | Green Melon
3.048 |  | done |  |  |  |  |  | 1
3.048 |  | teleflex |  |  | cherry |  |  | 0.5
3.048 |  | done
3.048 |  | spring city |  |  | Green Melon
3.048 |  | done
3.048 |  | Friendship |  |  | Green Melon
3.048 |  | done
3.048 |  | paoli |  |  | Green Melon
3.048 |  | Done
3.048 |  | jwpepper |  |  | spring
3.048 |  | done
3.048 |  | [NAME] |  |  | Blue Card
3.048 |  | done
3.048 |  | lunch
3.048 |  | done
3.048 |  | exton |  |  | cherry
3.048 |  | Done
3.048 |  | spitz |  |  | Green Melon
3.048 |  | done
3.048 |  | granite run |  |  | cherry
3.048 |  | done
5.468 |  | home |  |  |  |  | 2.7 | 3.18
 |  |  |  | NEPAAL07 |  | Time home
740 est | http://maps.google.com/maps?saddr=dana+run&daddr=101+newton+ave.+camden+to:39.9436277,-75.1066956+to:39.95245,-75.13135+to:PLYMOUTH+MEETING+MALL%09PLYMOUTH+MEETING+to:1010+CANNON+AVE%09LANSDALE+to:640+N+LEWIS+RD%09LIMERICK+to:Church+St+%26+Hall+St,+Spring |  |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00
 |  |  |  |  |  |  | PLAN |  | wic |  | Wic
 | Plan fill | Planned hours |  | 75 |  | 26 | 8.780000000000001 | 9.23 | 0 | 0 | 0 | 0 | 0
 | 101 | 8.780000000000001 | 11.50341685649203 |  |  | drive | 5.28 | 5.68 | 0 | 0 | 0 | 0 | 0
 |  | Plan gross per hour |  |  |  | work | 3.500000000000001 | 3.550000000000001 | 0 | 0 | 0 | 0 | 0
 |  | 11.50341685649203 |  |  |  | Rate | 11.35535307517084 | 18.93824485373781 | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | PA Total
Springtime |  | 0 |  |  |  | 0 | 0
Green Melon | 0 | 0 | 0 | 22 | 0 | 22 | 1.375
[NAME] | 21 | 0 | 0 | 13 | 11 | 45 | 2.8125
Mandrin |  |  |  |  |  | 0 | 0
 | Clicks back to minutes |  |  | 7 | air | 67 | 74
total in clicks
9 |  |  | 0 |  | 0
9.25 |  | 9.15 | 0 |  | 9.15
9.75 |  | 9.45 | 0 |  | 9.45
12.08 |  | 12.048 | 0 |  | 12.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
15.08 |  | 15.048 | 12 |  | 3.048
17.78 |  | 17.468 | 12 |  | 5.468
17.78 |  | 17.468 | 12 |  | 5.468
17.78 |  | 17.468 | 12 |  | 5.468
^
When deleting or adding location,
fix this first row
Spreadsheet: 09e52291-b043-40ec-b44b-4732ac54afc7
Sheet: Sheet1

FY 2010/11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | EXHIBIT E4 | Unnamed: 11
[NAME]
County: |  | Merced County |  |  |  |  |  | Date:
PEI Programs |  |  | FY 10/11 Requested MHSA Funding | Estimated MHSA Funds by Type of Intervention |  |  | Estimated MHSA Funds by Age Group
 | No. | Name |  | Universal Prevention | Selected/ Indicated Prevention | Early Intervention | Children and Youth | Transition Age Youth | Adult | Older Adult
Previously Approved Programs
1 | 1 | Skills Building in Children | 561000 |  | 504900 | 56100 | 168300 | 392700
2 | 2 | Life Sills for at Risk TAY | 250000 |  |  | 250000 |  | 250000
3 | 3 | Integrated Primary Care and Mental Health | 433989 | 355870.98 |  | 78118.02 | 13019.67 | 0 | 416629.44 | 4339.89
4 |  |  | 0
5 |  |  | 0
6 |  |  | 0
7 |  |  | 0
8 |  |  | 0
9 |  |  | 0
10 |  |  | 0
11 |  |  | 0
12 |  |  | 0
13 |  |  | 0
14 |  |  | 0
15 |  |  | 0
16 | Subtotal: Programs |  | 1244989 | 355870.98 | 504900 | 384218.02 | 181319.67 | 642700 | 416629.44 | 4339.89 | Percentage
17 | Plus up to 15% County Administration |  | 149399 |  |  |  |  |  |  |  | 0.12
18 | Plus up to 10% Operating Reserve |  | 90712 |  |  |  |  |  |  |  | 0.065
19 | Subtotal: Previously Approved Programs/County Admin./Operating Reserve |  | 1485100
New Programs
1 |  |  | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
5 |  |  | 0
6 | Subtotal: Programs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Percentage
7 | Plus up to 15% County Administration
8 | Plus up to 10% Operating Reserve
9 | Subtotal: New Programs/County Admin./Operating Reserve
10 | Total MHSA Funds Requested for PEI |  | 1485100
Note: Previously Approved Programs that propose changes to Key Community Health Needs, Priority Populations, and/or funding as described in the Information Notice are considered New.
Spreadsheet: 698498d1602007176-need-to-get-reports-from-badly-formatted-exported-data-leave-example-2-
Sheet: NEW 2+ leave instances

Between 01-Sep-2020 and 30-Sep-2020
Location
Location |  |  |  |  |  |  | Leave | Start | End | Days | Hours | Who
Surname, Name A
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-14 00:00:00 | 2020-09-18 00:00:00 | 5 | 37.5
Total Holiday | 5 | 37.5
Employee Total: Surname, Name A | 5 | 37.5
Surname, Name B
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2 | 15
Total Holiday | 2 | 15
Employee Total: Surname, Name B | 2 | 15
Surname, Name C
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-25 00:00:00 | 2020-09-25 00:00:00 | 0.5 | 3.75
Total Holiday | 0.5 | 3.75
Employee Total: Surname, Name C | 0.5 | 3.75
Surname, Name D
Ordinary Maternity Leave | [NAME] | Absence End | Duration | Hours | Reason
2020-05-10 00:00:00 | 2020-11-07 00:00:00 | 130 | 975
Total Ordinary Maternity Leave | 22 | 165
Employee Total: Surname, Name D | 22 | 165
Surname, Name E
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-01 00:00:00 | 2020-09-04 00:00:00 | 4 | 28.5
Total Holiday | 4 | 28.5
Employee Total: Surname, Name E | 4 | 28.5
Surname, Name F
Holiday | [NAME] | Absence End | Duration
2020-09-11 00:00:00 | 2020-09-11 00:00:00 | 1 | 7.5
2020-09-25 00:00:00 | 2020-09-25 00:00:00 | 1 | 7.5
Total Holiday | 2 | 15
Employee Total: Surname, Name E | 2 | 15
Spreadsheet: 93174d1292779168-how-do-you-match-2-columns-and-if-text-matches-display-info-from-3rd-column-to-a-4th-sample-workbook
Sheet: Sheet1

Product ID | Price |  | Product ID2 | Price for Prod2
C4965A | 504.124 |  | C4965A
C5000A | 1200.652 |  | C5000A
C5001A | 1200.652 |  | C5001A
C5002A | 1200.652 |  | C5002A
C5003A | 1200.652 |  | C5003A
C5004A | 1200.652 |  | C5004A
C5005A | 1200.652 |  | C5005A
KSW-32 BLACK | 24.358 |  | KSW-32 BLACK
KSW-64 BLACK | 36.538 |  | KSW-64 BLACK
KSW-208 | 97.43800000000002 |  | KSW-208
CDW-64 | 36.538 |  | CDW-64
CDW-264 | 121.798 |  | CDW-264
F1D9000-10 | 55.396 |  | F1D9000-10
2200-06325-001 | 654.736 |  | 2200-06325-001
SV231USB | 240.322 |  | SV231USB
RBC22 | 686.8240000000001 |  | RBC22
RBC23 | 1033.408 |  | RBC23
RBC24 | 1219.804 |  | RBC24
TLP602 | 19.108 |  | TLP602
TLP604TEL | 28.348 |  | TLP604TEL
TLP808TEL | 88.19800000000001 |  | TLP808TEL
TLP808TELTV | 102.898 |  | TLP808TELTV
TLP810NET | 129.526 |  | TLP810NET
TLP810SAT | 126.25 |  | TLP810SAT
BK500BLK | 432.052 |  | BK500BLK
SUPER7TEL | 66.86200000000001 |  | SUPER7TEL
SUPER7TEL15 | 106.258 |  | SUPER7TEL15
U209-000-R | 53.212 |  | U209-000-R
SUPER7 | 52.498 |  | SUPER7
PV1000HF | 709.294 |  | PV1000HF
PV1800HF | 992.962 |  | PV1800HF
BK350 | 295.3 |  | BK350
TLP808 | 62.62 |  | TLP808
SNMPWEBCARD | 775.78 |  | SNMPWEBCARD
48121 | 55.48 |  | 48121
ST122PRO | 141.538 |  | ST122PRO
C4890A | 744.154 |  | C4890A
C4891A | 744.154 |  | C4891A
C4892A | 744.154 |  | C4892A
[NAME] | 744.154 |  | [NAME]
4563A001 | 431.758 |  | F200-003-R
1491A002 | 510.7180000000001 |  | 4563A001
636070 | 15.454 |  | 1491A002
PA410U | 127.132 |  | 636070
67255 | 1019.254 |  | PA410U
PS2408 | 123.226 |  | 67255
RS-1215 | 154.39 |  | PS2408
PS3612 | 135.7 |  | RS-1215
PS4816 | 145.276 |  | PS3612
PS6020 | 170.56 |  | PS4816
BCPRO1400 | 1448.41 |  | PS6020
OMNISMART1400 | 1411.618 |  | BCPRO1400
5165 | 101.386 |  | OMNISMART1400
RBC12 | 1245.592 |  | 5165
A3L791-14-S | 21.67 |  | RBC12
49097 | 114.91 |  | A3L791-14-S
[NAME] | 243.808 |  | 49097
93841 | 270.73 |  | [NAME]
49107 | 265.9420000000001 |  | 93841
72121 | 71.56600000000002 |  | 49107
TSB212 | 207.646 |  | 72121
Spreadsheet: 857852d1706720783-formula-to-extract-data-in-col-a-and-b-into-col-c-formula-to-extract-data-from-col-a-and-b-into-col-c
Sheet: Sheet1

876689
876982
877822
877888
877850
877851
877859
877860
877861
877863
877865
877868
877870
707127Y
877881
877886
877897
877500
877508
877507
877509
877511
877515
877518
877520
Unallocated
877586
877556 | 876915
876708 | 877018
877037 | 817255
877219 | 877088
109952 | 877061
877828 | 877078
877871 | 877075
877878 | 877076
9985524X | 972023
877889 | 972025
877505
877506
877523
877525
877527
877529
877531
877551
877555
Spreadsheet: 73209d1273844667-lookup-with-multiple-references-report
Sheet: Data

Date | code | quantity | revenue
2010-05-01 00:00:00 | SG | 3 | 30
2010-05-01 00:00:00 | MLK | 2 | 30
2010-05-01 00:00:00 | BR | 5 | 25
2010-05-02 00:00:00 | SG | 1 | 10
2010-05-03 00:00:00 | MLK | 3 | 45
2010-05-03 00:00:00 | BR | 6 | 30
2010-05-03 00:00:00 | SG | 6 | 60
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Allocations 2002

 | 2002 Cost Allocated % | 2001 Cost Allocated | 2001 imputed headcount
 | Total
Direct Costs |  | 1
UK Power Trading |  |  | 1
UK Gas Trading |  |  | 1
UK Power Originations |  |  | 0
UK Gas Originations |  |  | 0
UK Finance Originations |  |  | 1
UK Financial Books |  |  | 0
Continental Gas Trading |  |  | 1
Teesside |  |  | 0
Watershed |  |  | 0
UK Total
Continental Origination - Germany |  |  | 1
Continental Origination - Benelux/France |  |  | 0
Continental Origination - Italy |  |  | 0
Continental Origination - Poland/Russia |  |  | 0
Continental Origination - Czech/Slovak/Hungary |  |  | 0
Continental Origination - Turkey/Balkans |  |  | 0
Continental Origination - Switzerland/Austria |  |  | 0
Continental Origination - Spain |  |  | 0
Continental Origination - Arcos |  |  | 2
Continental Origination - Executive |  |  | 1
Continental Origination
Bilateral Power Trading |  |  | 1
Pool Power Trading |  |  | 0
Continental
Enron Credit Executive |  |  | 0
Enron Credit Trading |  |  | 1
Enron Credit Syndication |  |  | 1
Enron Credit Quant |  |  | 0
Enron Credit Origination |  |  | 0
Enron Credit Pricing |  |  | 0
Enron Credit Marketing |  |  | 0
Enron Credit Product Development |  |  | 0
Enron Credit Structured Finance Group |  |  | 0
Enron Credit
Metals Trading |  |  | 0
LME Execution |  |  | 1
Metals Marketing |  |  | 1
[NAME] |  |  | 1
Recycling |  |  | 1
Metals
Middle East |  |  | 0
Finland |  |  | 0
Norway |  |  | 1
Sweden |  |  | 0
EnergyDesk |  |  | 0
Weather |  |  | 0
Scandinavia
Japan |  |  | 0
Australia |  |  | 0
EnCom/E Power |  |  | 0
Non Region Specific |  |  | 4
TOTAL ENRON EUROPE
Continental  Assets (Trakya, ENS, Sarlux, Gaza) |  |  | 1
EES Energy Services (EES Outsourcing) |  |  | 1
EES Enron Direct UK |  |  | 0
EES Enron Direct NL |  |  | 0
EES Enron Directo |  |  | 0
EES Torpy |  |  | 0
EES Erpag |  |  | 0
EES
EBS |  |  | 0
EIM |  |  | 2
ENW |  |  | 0
EGM |  |  | 5
Enron Corp |  |  | 0
India |  |  | 0
Enron Principle Investments |  |  | 1
NEPCO |  |  | 0
ENA |  |  | 0
Enron Wind |  |  | 1
Total Non-Enron Europe
Total All Regions
Support |  |  | 5
Total Labour Distribution Must equal 100%
Commments | This is the allocation of total Direct Cost and is not fully loaded
 | The Office and support services costs are not included (Approx: $100k/per person pa)
UK Total | 0.1111111111111111
Continental | 0.1388888888888889
Enron Credit | 0.05555555555555555
Metals | 0.1111111111111111
Scandinavia | 0.02777777777777778
Non Region Specific | 0.1111111111111111
Continental  Assets (Trakya, ENS, Sarlux, Gaza) | 0.02777777777777778
EES | 0.02777777777777778
EIM | 0.05555555555555555
EGM | 0.1388888888888889
Enron Principle Investments | 0.02777777777777778
Enron Wind | 0.02777777777777778
Support | 0.1388888888888889
Spreadsheet: 773227d1647711847-vlookup-and-if-functions-example
Sheet: All Task Orders

[NAME]
ID | Name | TO 01 | TO 02 | TO 03
1001 | [NAME], [NAME]
2403 | Doe, [NAME]
2050 | Fisher, Mary
1920 | [NAME], [NAME]
Answer
ID | Name | TO 01 | TO 02 | TO 03
1001 | [NAME], [NAME] | 15
2403 | Doe, [NAME] | 63
2050 | Fisher, Mary | 72
1920 | [NAME], [NAME] | 0
 | SUMs hours based on emplouee ID and TO from the "by task order" tab.  Need it be able to sum a certain range (i.e. Jan - Apr or Apr - Dec)
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R23

Ime artikla
Spreadsheet: 861391d1709261455-looking-to-count-a-number-of-cells-with-changing-rows-and-column-availabilty-monitoring-dj
Sheet: Availability Report

[NAME] for: |  |  |  | 2024-02-29 00:00:00
 | Full Practice | Modified Practice | Medically Unavailable | Rehab |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  |  |  |  |  |  | FP | Full Practice
 |  |  |  |  |  | Name |  |  | MP | Modified Practice
 |  |  |  |  |  |  | Rehab | Full Practice | MU | Medically Unavailable
 |  |  |  | Athlete 28 |  | Athlete 72 | Modified Practice | Full Practice | R | Rehab
 |  |  |  | Athlete 63 |  | Athlete 93 | Medically Unavailable | Full Practice
 |  |  |  | Athlete 66
 |  |  |  | Athlete 75
 |  |  |  | Athlete 77
 |  |  |  | Athlete 103
 |  |  |  | Athlete 104
 |  |  |  | Athlete 105
 |  |  |  | Athlete 110 |  |  |  |  |  |  | EXPECT RESULTS
 |  |  |  | Athlete 113 |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  | Athlete 115 |  |  |  |  |  | Full Practice | 9 | 8 | 8 | 5 | 16 | 12 | 6 | 7 | 5 | 12 | 5
 |  |  |  | Athlete 117 |  |  |  |  |  | Modified Practice | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  |  | Medically Unavailable | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Rehab | 0 | 1 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 7 | 0
Spreadsheet: 787122d1657637917-if-cell-content-equals-content-of-address-in-another-cell-return-x-dummy-data-aligw
Sheet: Sheet2

id site | event id
a108
a109
a110
a111
a112
a113
a114
[NAME]
a116
a117
Spreadsheet: 754429d1636166180-calculate-isblank-with-multiple-conditions-cableghost-trades-template-
Sheet: RESULTS 1

 | BREAKOUT STRATEGY NOTES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEAN G/L | >= 4 | >= 5 | >= 6 | >= 7 | >= 8 | >= 9 | >= 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All-TIME (5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 10 Wk
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 5 Wk
 | Trading Days | 252 | Annual calendar trading days
 | No Trade Days | 15 | Days w/ no trades available |  |  |  |  |  |  |  |  |  |  |  |  | TRADES | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Days Off | 0 | Vacation or other days w/ no trading |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Traded % |  | Used in Annualized Gain calculations |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | RULES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Enter only on 1 of 7 ideal setups |  |  |  |  |  |  |  | WEEKLY
 | Entry is within 10c of identified entry level |  |  |  |  |  |  |  | WEEK | TRADES | WIN % | POINTS | G/L $ | ENTRY % |  | ENTRY (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | [NAME] stop loss for entry price < 20 is 30c, > 20 is 50c |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Primary exit is 5x20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | ANNUALIZED GAIN CALCULATOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN % (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Net Profit |  |  | ATI |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 |  | All-time | Last 3 Wk | > 1 pt | > 2 pt | > 3 pt | > 4 pt
 | Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Profit % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Days (Traded) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Wins |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Points (Net)
 | Points % (Net)
 | Points (Wk Ave)
 | Points (Annualized)
 | Entry Success %
 | Negative trades |  |  | Greatest sequence of negative trades
 | Ave [NAME] trades |  |  | Average sequence of negative trades
 | PM Trades
 | PM Trades %
 | PM Points (Net)
 | PM Win %
 | SETUP RESULTS
 | Setup | Trades | Trades % | Win % | Last 3 Wk | Points G/L | Entry %
 | PMH
 | PM Consolidation
 | Pivot
 | HOD
 | R2G
 | Daily
 | Consolidation
 | MAX GAIN
 |  | Ave | Mean 20%
 | Entry-High
 | High-Exit
 |  |  |  | > 1 pt | > 2 pt | > 3 pt | > 4 pt
 | Trades
 | % of All
 | ENTRY TIMES
 |  | Trades | Trades % | Ave
 | 8:30-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-15:59
Spreadsheet: 57547d1257769076-two-cells-which-have-formulas-stopping-error-messages-show-an-error-when-added-example
Sheet: Sheet1

Example
Total1 | Total2 | Grand Total
13 | 6 | 19 |  |  |  |  | 13 | 6 |  |  |  |  |  |  | 6 | 3 | 4
7 | 9 | 16 |  |  |  |  | 7 | 9 |  |  |  |  |  |  | 3 | 2 | 2
6 | 12 | 18 |  |  |  |  | 6 | 12 |  |  |  |  |  |  | 3 | 1 | 2
 | 4 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | -20 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 | 1 | 1
Spreadsheet: 94543d1294331680-find-min-value-omitting-blanks-or-zeros-for-help-min
Sheet: Sheet1

Setup |  |  | SUBCONTRACTS |  |  |  |  | SHEET 2
Code
6012 | CONTROLS | Base Bid | Adds | Adds | Adds | Total Bid | LOW BID | Committed
 | Vendor 1 | 10 | 50
 | Vendor 2 |  | .
 | Vendor 3 | 20
 | Vendor 4
 | Vendor 5 | 30
 | Vendor 6
 |  | 70
 | PLUG NUMBER
6002 | AIR & WATER BALANCE | Base Bid | Commission | Leak Test | Adds | Total Bid | LOW BID | Committed
 | Air Vendor 1 | 10 | 10 | 10 | 10
 | Air Vendor 2 | 20 | 20 | 20 | 20
 | Air Veendor 3 | 30 | 30 | 30 | 30
 | PLUG NUMBER
6001 | INSULATION | HVAC | Plumbing | Adds | Adds | Total Bid | LOW BID | Committed
 | Insul Vendor 1 | 60 | 20
 | Insul Vendor 2
 | Insul Vendor 3
 | Insul Vendor 4
 | Insul Vendor 5
 | Airside Plug
 | Piping Plug
 | Plumbing Plug | 10