tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__14713__POSTION05_02
Sheet: JUL_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 107.5 | 3.912 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-05-31 00:00:00 |  | 748349.6
2001-06-27 00:00:00
60874 | 4202
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-05-31 00:00:00 |  | 275313.72
2001-06-27 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-05-31 00:00:00 |  | 663620.69
2001-06-27 00:00:00
500241
500391 | 8141
500392 | 1949
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: 702434d1604346551-formula-to-display-all-locations-when-several-are-found-book1-tony
Sheet: Sheet1

 | [NAME] | PRODUCT | QTY AVAILABLE |  | Products | Locations | Total Quantity
 | A1 | PEAS | 200 |  | PEAS
 | A2 | CARROTS | 44 |  | CARROTS |  |  |  | Want H3 to list all the locations where peas are stored as there are more than one location
 | A3 | POTATOES | 74 |  | POTATOES
 | A4 | ONIONS | 2 |  | ONIONS
 | A5 | PEAS | 50 |  | SWEDE
 | B1
 | B2 | POTATOES | 50
 | B3 | SWEDE | 10
 | B4 | SWEDE | 10
 | B5 | ONIONS | 5
 | C1 | PEAS | 45
 | C2 | PEAS | 80
 | [NAME]
 | C4
 | C5
Spreadsheet: 1a95a754-924e-4285-bf35-162587fc3c06
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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 | Unnamed: 14
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2011/12 | 1140.6 | 1080.6 | 3385.702387562465 | 1515.939 | 3658.59 | 253.8966184896708 | 5428.425618489671 |  | 2805 | 603.601 | 470.3079841901033 | 546.1856342995678 | 4425.094618489671 | 1003.331
2012/131 | 1638 | 1604 | 4216.521197007482 | 1003.331 | 6763.3 | 118.7429943049308 | 7885.373994304931 |  | 2734.836 | 655.96265 | 528.4915142231869 | 1195.334830081745 | 5114.624994304932 | 2770.749
2013/142 | 1058 | 1030 | 3787.233009708738 | 2770.749 | 3900.85 | 65 | 6736.599 |  | 2815 | 550 | 425.5990000000002 | 700 | 4490.599 | 2246
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-11-13 09:22:18.990000
Spreadsheet: 856263d1705577381-how-to-use-functions-to-lookup-and-sum-up-qty-filter-and-sum-3-aligw-
Sheet: Planilha1

 |  |  | M 1.2024 | M 1.2024 | M 2.2024 | M 2.2024 | M 2.2024 | M 3.2024 | M 4.2024 | M 5.2024 | M 6.2024 |  |  |  | M 1.2024 | M 2.2024 | M 3.2024 | M 4.2024 | M 5.2024 | M 6.2024
X |  | 1 | 100 | 1 | 200 |  |  | 300 | 400 | 500 | 600 |  | A | 3
X |  | 2 | 700 | 7 | 800 |  |  | 900 | 1000 | 1100 | 1200
X |  | 3 | 1300 | 13 | 1400 |  |  | 1500 | 1600 | 1700 | 1800 |  |  |  | want to show the answer 3232
X |  | 3 | 1900 | 19 | 2000 |  |  | 2100 | 2200 | 2300 | 2400
Y |  | 1 | 2500 | 25 | 2600 |  |  | 2700 | 2800 | 2900 | 3000
Y |  | 2 | 3100 | 31 | 3200 |  |  | 3300 | 3400 | 3500 | 3600
Z |  | 3 | 3700 | 37 | 3800 |  |  | 3900 | 4000 | 4100 | 4200
Spreadsheet: 109447d1306302552-dynamic-range-and-series-in-xy-scatter-pillar-design-start
Sheet: Names

Prob of Failure | FOS |  |  | Conditions
1 in 10,000,000 | 2.262 |  |  | Wide Panel
1 in 1,000,000 | 2.11 |  |  | [NAME]
1 in 100,000 | 1.95 |  |  | Chain Pillar
1 in 10,000 | 1.79
1 in 1000 | 1.63
1 in 100 | 1.44
2 in 100 | 1.38
5 in 100 | 1.3
1 in 10 | 1.22
5 in 10 | 1
8 in 10 | 0.87
Spreadsheet: 298807d1392912414-replace-find-search-match-to-extract-data-from-combination-of-text-and-number-base-on-list-data123
Sheet: RULES&RESULT

RULES: | REPLACE DATA TO RESULT TO EXTRACT SPECIFIC DATA BASE ON MATCHING FROM SOURCE LIST, ONE FORMULA FOR ALL
DATA | RESULT |  | SOURCE LIST
 | EXTRACT 2011 | EXTRACT 2013 | LIST 2011 | LIST 2013
complete docs, transfer of rights per aa dated 2011-04-06-035 | 2011-04-06-035 |  | 2011-04-06-034 | 2013-08-23-076
TIN 228-944-042;loan not yet approved;6-13-08 original booking date as 10/90 conditional, transfer of rights from Ferina Martinez per aa dated 2011-10-18-044 | 2011-10-18-044 |  | 2011-04-06-035 | 2013-05-03-003
complete docs, Transfer of unit to From WWREC B13L4 per AA dated 2011-09-30-104, inclusion of Maria Their Eri Sakuma per aa dated 2013-08-23-076 | 2011-09-30-104 | 2013-08-23-076 | 2011-04-06-036 | 2013-09-12-122
complete docs, change of due date from 20 to 25th of the month per aa dated 2011-12-16-049, change term per aa dated 2013-05-03-003 | 2011-12-16-049 | 2013-05-03-003 | 2011-04-06-037 | 2013-10-31-138
complete docs, transfer of unit from FHMTW02 1037  per aa dated 2013-09-12-122 |  | 2013-09-12-122 | 2011-04-06-038 | 2013-10-31-137
complete docs,change term due to change of TO date per aa dated 2013-10-31-138 |  | 2013-10-31-138 | 2011-04-06-039 | 2013-10-31-136
 |  |  | 2011-09-30-104 | 2013-10-31-135
 |  |  | 2011-12-16-049 | 2013-10-31-134
 |  |  |  | 2013-09-12-123
 |  |  |  | 2013-05-03-002
 |  |  |  | 2013-08-23-075
Spreadsheet: 16961237-87f4-43a5-a59f-1ae6e475cc9f
Sheet: Sheet1

American Recovery and Reinvestment Act of 2009: Lead Hazard Reduction Grants | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
State | Applicant | Program* | [NAME]
AZ | City of Phoenix | HHD | 875000
AZ | City of Phoenix | LHC | 2336918
CA | City of Long Beach | HHD | 874992
CA | Esperanza Community Housing Corporation | HHD | 875000
CA | Riverside County, Department of Public Health | HHD | 875000
CA | City and County of San Francisco | LHC | 3000000
CA | City of Fresno | LHC | 3000000
CA | City of Long Beach | LHC | 2999947
CA | City of [NAME] | LHC | 2999243
CA | State of California | LHC | 3000000
CT | Connecticut Children's Medical Center | HHD | 875000
CT | City of New London | LHC | 2004538
CT | City of Norwich | LHC | 1699588
CT | City of Waterbury | LHC | 3000000
DC | District of Columbia | LHRD | 2616843
IL | University of Illinois at Chicago | HHTS | 973982
IL | City of Moline | LHC | 2114670
IN | Health and Hospital Corporation of Marion County | HHD | 874565
IN | Memorial Hospital of South Bend, Inc. | HHD | 552388
IN | City of Gary | LHC | 3000000
IN | Elkhart County | LHC | 3000000
IA | City of Marshalltown | LHC | 2591227
IA | City of Sioux City | LHC | 1983747
IA | Polk County | LHC | 3000000
ME | City of Lewiston | LHC | 2279525
MD | National Center for Healthy Housing | HHTS | 792570
MA | Self Help, Inc. | HHD | 875000
MA | University of Massachusetts Lowell | HHD | 874940
MA | City of Lowell | LHC | 3000000
MA | Commonwealth of Massachusetts | LHC | 2640000
MA | Malden Redevelopment Authority | LHC | 2984565
MO | Kansas City | LHC | 2998508
MT | Montana State Univ. Extension Service - Housing Program | HHD | 873963
NY | City of Utica | LHC | 2038081
NC | City of Charlotte | LHC | 2999903
NC | City of Greenville | LHC | 1922370
OH | Mahoning County | HHD | 875000
PA | City of Philadelphia | HHD | 875000
PA | Healthy Home Resources | HHD | 874821
PA | Pennsylvania Department of Health | HHD | 875000
PA | Philadelphia Housing Authority | HHD | 871664
SC | City of Charleston | LHC | 3000000
TX | County of Harris | HHD | 871327
TX | City of Galveston | LHC | 3000000
VA | City of Roanoke | LHC | 1406633
WA | King County Housing Authority | HHD | 875000
WA | City of Spokane | LHC | 2850000
WA | State of Washington | LHC | 3000000
WI | City of Milwaukee Health Department | HHD | 874085
WI | Kenosha County Dept of Human Services-Division of Health | HHD | 875000
WI | Wisconsin Department of Health Services | HHD | 874397
WI | County of Rock | LHC | 1100000
WI | State of Wisconsin | LHC | 3000000
* Note: Grant program abbreviations are as follows:
HHD - Healthy Homes Demonstration Grant Program
HHTS - Healthy Homes Technical Studies Grant Program
LHC - Lead Based Paint Hazard Control Grant Program
LHRD - Lead Based Paint Hazard Reduction Demonstration Grant Program
Spreadsheet: 732503d1620994713-sort-the-values-in-column-a-in-ascending-order-and-extract-corresponding-values-non-array-to-sort-values_fix
Sheet: Sheet2

Employee Name | Employee ID | Req. | Req. Date |  | Employee Name | Employee ID | Req. | Req. Date
Spreadsheet: mike_grigsby__27802__WestRateSheet
Sheet: Variable Rates

 | Fuel % | Comm $ | ENA Comm
Variable Rates
EPNG
SJ to SCAL | 3.47 | 0.026
Perm to Scal | 3.47 | 0.0436
SJ to [NAME] | 3.47 | 0.0123 | 0.0053
Perm to Waha | 0.96 | 0.0151 | 0.0053
SJ to AZ | 3.47 | 0.0288
Perm to AZ | 3.47 | 0.0315
SJ to NV | 3.47 | 0.0278
Perm to NV | 3.47 | 0.0454
SJ to PG&E Topock | 3.47 | 0.026
[NAME] to EOT | 1.56 | 0.0176
SJ to EOT | 1.31 | 0.0176
WTX to EOT | 1.31 | 0
IB to SJ Pool | 0.25 | 0.0011
IB to EPNG | 0.25 | 0.0033
PG&E on-system | 1.37 | 0
PG&E off-system | 1.1 | 0
PGT
Aeco to King | 1.2 | 0.006
Aeco to [NAME]
Aeco to Malin
King to Stan | 1.165 | 1.2805
King to Malin | 2.571 | 1.736
[NAME] to Malin | 1.4074 | 1.3556
CIG
CIG backhaul | 2.4 | 0.025
CIG fronthaul | 3.7 | 0.025
Questar
Haul | 0.8 | 1.2
Transcolorado
Haul | 1.3
Old Kern
NMuddy to Socal | 1.25 | 0.0022
New Kern
NMuddy to Socal | 4.2 | 0.06 | 7/1/01 - 04/30/02
NMuddy to Socal | 6.2 | 0.06 | 5/1/02 - 04/30/03
WIC
Fronthaul | 0.63 | 0.005
Backhaul | 0.63 | 0.005
Spreadsheet: 819877d1677744724-copy-all-sheets-data-into-one-sheet-copy-all-sheets-into-one
Sheet: Sheet2

Column1 | Column2 | Column3
1 | 1 | 1
1 | 1 | 1
1 | 1 | 1
2 | 2 | 2
2 | 2 | 2
3 | 3 | 33
Spreadsheet: 687541d1595267205-timesheet-formula-to-subtract-1-2-a-hour-lunch-only-if-6-hours-are-worked-2020-07-20-oeldere-mrsboot-687536d1595265622-timesheet-formula-to-subtract-1-2-a-hour-lunch-o
Sheet: Schedule

deleted merged cells | JON | JOE | [NAME]
2020-07-23 00:00:00 | 05:00:00 | 13:00:00 | 05:00:00
2020-07-23 00:00:00 | 13:30:00 | 16:00:00 | 13:30:00 | =[NAME])
2020-07-24 00:00:00 | 06:00:00 | 13:00:00 | 05:00:00
2020-07-24 00:00:00 | 14:30:00 | 16:00:00 | 13:30:00
2020-07-25 00:00:00 | 08:00:00 | 00:00:00 | 08:00:00
2020-07-25 00:00:00 | 13:30:00 | 00:00:00 | 13:30:00
2020-07-26 00:00:00 | 00:00:00 | 00:00:00 | 08:00:00
2020-07-26 00:00:00 | 00:00:00 | 00:00:00 | 12:00:00
2020-07-27 00:00:00 | 00:00:00 | 13:00:00 | 08:00:00
2020-07-27 00:00:00 | 00:00:00 | 18:30:00 | 12:00:00
2020-07-28 00:00:00 | 15:30:00 | 13:00:00 | 00:00:00
2020-07-28 00:00:00 | 18:30:00 | 20:30:00 | 00:00:00
2020-07-29 00:00:00 | 05:00:00 | 13:00:00 | 00:00:00
2020-07-29 00:00:00 | 13:30:00 | 20:30:00 | 00:00:00
Spreadsheet: c5bedce2-69fc-4341-b3fc-ccaab504a928
Sheet: Sheet1

CHARTER SCHOOL NAME: _________________________________________ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
PROGRAM OR FUNCTION: _______________________________ |  |  |  | FISCAL YEAR: ______________
A | B | C | D | E | F
Object Code | Title of Position or  Description of Item | FTE | Quantity | Unit Amount / Calculations | Total Amount
100 | PERSONNEL |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
200 | BENEFITS |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
300 | PURCHASED PROFESSIONAL |  |  |  | 0
 | AND TECHNICAL SERVICES |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
400 | PURCHASED PROPERTY |  |  |  | 0
 | SERVICES |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
500 | OTHER PURCHASED SERVICES |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
600 | SUPPLIES |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
800 | DEBT SERVICE AND |  |  |  | 0
 | [NAME] |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
Subtotal Objects 100-600 & 800 |  |  |  |  | 0
Approved Indirect Cost Rate: |  | 0 |  | X Subtotal | 0
700 | EQUIPMENT |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | NARRATIVE
 |  |  |  | TOTAL | 0
GRAND TOTAL |  |  |  |  | 0
Posted 8/26/2009
Spreadsheet: 168705d1342546337-is-this-pivot-table-possible-a-need-pivot-table
Sheet: Door Count

COUNT | DOOR ELEVATION | SIZE |  | DOOR FINISH | RATING | COMMENTS
69 | D1 | 3 | 3'-0" x 7'-0" | P-10 | (blank) | (blank)
 |  | 1 |  | P-11
 |  | 3 |  | P-13
 |  | 1 |  | P-3
 |  | 1 |  | P-8 | 45 | CLOSER
 |  | 1 | 2'-0" x 7'-0" | WD-1 | (blank) | (blank)
 |  | 6 | 3'-0" x 7'-0" |  | 45 | CLOSER
 |  | 2 |  |  | (blank) | DOUBLE ACTING
 |  | 39 |  |  |  | (blank)
 |  | 8 | 4'-0" x 7'-0"
 |  | 2 | 4'-8" x 7'-0"
 |  | 2 | 6'-0" x 7'-0"
1 | D-2 | 1 | VIF | MATCH HISTORIC | 45 | CLOSER; PUSH BAR EXIT, DOOR TO MATCH EXISTING
2 | D3 | 2 | 3'-0" x 7'-0" | P-8 | (blank) | (blank)
1 | D4 | 1 | 3'-6" x 7'-0" | MATCH HISTORIC | (blank) | CARD READER; CLOSER
2 | D5 | 2 | 6'-0" x 7'-0" | F20 | (blank) | CLOSER
1 | D6 | 1 | 3'-6" x 7'-0" | WD-1 | (blank) | (blank)
18 | EXIST. | 7 | EXIST. | EXIST. | 45 | CLOSER
 |  | 1 |  |  |  | CLOSER; LEVER HANDLE
 |  | 1 |  |  | (blank) | LEVER HANDLE
 |  | 3 |  |  |  | [NAME]; CLOSER
 |  | 1 |  |  |  | PUSH BAR EXIT
 |  | 4 |  |  |  | (blank)
 |  | 1 | EXIST. | MATCH HISTORIC |  | PUSH BAR EXIT
94 | Grand Total | 94
Spreadsheet: ed0b9db8-c057-44ee-a912-7d0a70c9379e
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
FAZAT | Test | FAZAT | Azathioprine (Imuran) as 6-Mercaptopurine | Azathioprine (Imuran) | High Performance Liquid Chromatography with Ultraviolet Detection (HPLC-UV) |  |  |  | 2 | mL | Submit only 1 of the following specimens:  Serum Draw blood in a plain, red-top tube(s). Spin down and send 2 mL of serum refrigerate in plastic vial. NOTE: Trough levels are most reproducible.  [NAME] blood in a green-top (Sodium or Lithium) tube(s). Spin down and send 2 mL of heparinized plasma refrigerate in plastic vial. NOTE: Trough levels are most reproducible. | 0.3 mL | Specimens other than	Serum, plasma Anticoagulants other than	Heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Azathioprine is measured as the metabolite, 6-mercaptopurine. Therapeutic and toxic ranges have not been established. Usual therapeutic doses produce 6-mercaptopurine serum concentrations of less than 1000 ng/ml.  Test Performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                       St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FAZAT | Result | [NAME] | 6-Mercaptopurine | 6-Mercaptopurine | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1cf9ec50-a14a-4f8f-b6dd-e54af8e0e402
Sheet: Sheet1

 |  | Vacation |  |  |  |  | Sick |  |  |  |  | Holiday |  |  |  |  | Comp**
 |  | Prev | Earn(+) | Used(-) | Bal |  | Prev | Earn(+) | Used(-) | Bal |  | Prev | Earn(+) | Used(-) | Bal |  | Prev | Earn(+) | Used(-) | Bal
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 788586d1658562843-bifurcate-the-amount-as-per-date-day-difference-duty-exemption-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Calculation 3 (of [NAME])
 | Duty Amount | Debit | Credit | Duty Date |  |  |  |  |  | 2020-09-19 00:00:00
 | 2028.59 |  |  | 2019-04-18 00:00:00 |  |  |  |  |  | 2020-09-20 00:00:00
 | 7514.71 |  |  | 2019-05-18 00:00:00 |  |  |  |  |  | 2020-09-21 00:00:00
 | 8983.9 |  |  | 2019-06-20 00:00:00 |  |  |  |  |  | 2020-09-22 00:00:00
 | 13777.19 |  |  | 2019-07-20 00:00:00 |  |  |  |  |  | 2020-09-23 00:00:00
 | 10017.56 |  |  | 2019-08-14 00:00:00 |  |  |  |  |  | 2020-09-24 00:00:00
 | 12514.5 |  |  | 2019-09-13 00:00:00 |  |  |  | This is the Calculation for Cell D19 |  | 2020-09-25 00:00:00
 | 16125.19 |  |  | 2019-10-18 00:00:00 |  |  |  |  |  | 2020-09-26 00:00:00
 | 12128.63 |  |  | 2019-11-15 00:00:00 |  |  |  |  |  | 2020-09-27 00:00:00
 | 11580.19 |  |  | 2019-12-13 00:00:00 |  |  |  |  |  | 2020-09-28 00:00:00
 | 15710.72 |  |  | 2020-01-20 00:00:00 |  |  |  |  |  | 2020-09-29 00:00:00
 | 9687.69 |  |  | 2020-02-13 00:00:00 |  |  |  |  |  | 2020-09-30 00:00:00
 | 13626.72 |  |  | 2020-03-17 00:00:00 |  |  |  |  |  | 2020-10-01 00:00:00
 | 17517.93 |  |  | 2020-05-22 00:00:00 |  |  |  |  |  | 2020-10-02 00:00:00
 | 12616.13 |  |  | 2020-07-11 00:00:00 |  |  |  |  |  | 2020-10-03 00:00:00
 | 10595 |  |  | 2020-08-13 00:00:00 |  |  |  |  |  | 2020-10-04 00:00:00
 | 12114.33 |  | 12114.33 | 2020-09-19 00:00:00 |  |  |  |  |  | 2020-10-05 00:00:00
 | 8298.93 |  | 3830.275384615385 | 2020-10-15 00:00:00 |  |  |  |  |  | 2020-10-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-07 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-09 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-11 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-12 00:00:00
Extra Duty Collection Date From | 2019-04-01 00:00:00 | To | 2019-08-08 00:00:00 |  |  |  |  |  |  | 2020-10-13 00:00:00
Duty Relief Date From | 2019-12-01 00:00:00 | To | 2020-10-01 00:00:00 |  |  |  |  |  |  | 2020-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-15 00:00:00
Spreadsheet: 846673d1697804818-forumula-not-working-in-old-version-excel-sample-extract-number-ans
Sheet: MASTER CARD

 |  |  |  |  |  |  |  |  | NAME | SER | CODE | AMOUNT
 |  |  |  |  |  |  |  |  | AL SAFA/AZEEM 1 | 1 | 1
 |  |  |  |  |  |  |  |  | NAFEES ABDULLAPUR 443 | 2 | 443
 |  |  |  |  |  |  |  |  | TARIF AMBT 93 | 3 | 93
 |  |  |  |  |  |  |  |  | ASHU AMBT 25 | 4 | 25
 |  |  |  |  |  |  |  |  | ASHU AMBT 25 | 5 | 25
 |  |  |  |  |  |  |  |  | FIROZ KP 37 | 6 | 37
 |  |  |  |  |  |  |  |  | ARIF AMBT 21 | 7 | 21
 |  |  |  |  |  |  |  |  | NAFEES ABDULLAPUR 443 | 8 | 443
 |  |  |  |  |  |  |  |  | AURANGZEB VL 6 | 9 | 6
 |  |  |  |  |  |  |  |  | Y S AGRO INDIA/H SADIK MZN 43 | 10 | 43 |  | extra space at the end.
 |  |  |  |  |  |  |  |  | MEHARBAN G PB 163 | 11 | 163
 |  |  |  |  |  |  |  |  | Y S AGRO INDIA/H SADIK MZN 43 | 12 | 43 |  | extra space at the end.
 |  |  |  |  |  |  |  |  | [NAME] | 13 | 3
 |  |  |  |  |  |  |  |  | TARIF AMBT 93 | 14 | 93
 |  |  |  |  |  |  |  |  | ANAS DASSI 16 | 15 | 16
 |  |  |  |  |  |  |  |  | WAHID G 206 | 16 | 206
 |  |  |  |  |  |  |  |  | TASLEEM AMBT 228 | 17 | 228
 |  |  |  |  |  |  |  |  | FARMAN KP 234 | 18 | 234
 |  |  |  |  |  |  |  |  | SHARIB DASSI 88 | 19 | 88
 |  |  |  |  |  |  |  |  | SHAKIR SONU SRE PB 165 | 20 | 165
Spreadsheet: 878546d1725634911-formula-to-compute-net-effective-gains-samplecalculation
Sheet: Sheet1

Assumptions
Win / Loss Ratio | 50:50 |  |  |  |  | No. of | Average % | Average |  | Net | Total %
Average Gain per Trade | 0.125 |  |  | Trades | % | Trades | Gain/(Loss) | Gain/(Loss) | Exposure | Gain/(Loss) | Gain/(Loss)
Average Loss per Trade | 0.0625 |  |  | Winning Trades | 0.5 |  | 0.125
Position Size per Trade | 0.25 |  |  | Losing Trades |  |  | -0.0625
No.Of Trades | 124
Exposure per Trade | 0.25
Calculation
Effecive Gain per Trade
Compounded Growth
Spreadsheet: 71903d1272570379-vlookup-vlookup
Sheet: Sheet1

NAME | EMP #
[NAME]
[NAME]
[NAME] John
Spreadsheet: 201306d1355941162-inventory-files-combing-example-1-solution
Sheet: Combo

 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
1. RSR Stock Number | 2. UPC Code (if available or blank filler) | 3. Product Description | 4. Department Number | 5. Manufacturer Id | 6. Retail Price (if available or .00) | 7. RSR Regular Price | 8. [NAME] (oz.) | 9. Inventory Quantity | 10. Model | 11. [NAME] | 12. Manufacturer Part Number | 14. Expanded Product Description | 15. Image name | Manufacturer id | Accessories | Action | Type of Barrel | Barrel Length | Catalog Code | Chamber | Chokes | Condition | Capacity | Description | [NAME] | Edge | Firing casing | Finish/Color | Fit | Fit   ** | Feet per second | Frame/Material | Caliber | Caliber   ** | [NAME] | Grips/Stock | Hand | Manufacturer | Manufacturer part #   (added June 2010) | Manufacturer weight | MOA | Model | Model   ** | New Stock # | NSN (National Stock #)    (added June 2010) | Objective | Ounce of shot | Packaging | Power | Reticle | Safety | Sights | Size | Type | Units per box | Units per case | [NAME]
21976
511-40011-010-L
Spreadsheet: phillip_m_love__30019__Book Request1
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | Administrator* | MTM | Prud | Realized
 | FT-ONT-TRANS | Firm-Ontario-Transport |  |  | x |  | Ontario | x | x | x | x |  | NG/MMBTU/USD | See below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - |  | - | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - |  | - | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | Same as FT-Central and FT-Ont-Central
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x31462)
Spreadsheet: 130837d1322606604-conditional-formating-win-loss
Sheet: Sheet1

Wins | Loses | total
3 | 2
4
4 | 1
1 | 5
 | 5
4 | 2
3
5 | 3