tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139734d1328426122-converting-sumif-to-sumsomething-for-excel-2003-a-little-help-please-book2-1-
Sheet: Sheet1

 | ID01 | ID01 |  |  |  | 2012-01-01 00:00:00 |  |  | 10
 | ID02 |  |  |  |  | 2012-01-02 00:00:00 |  |  | 2
 | ID01 |  |  |  |  | 2010-01-01 00:00:00 |  |  | 3
 | ID03 |  |  |  |  | 2012-01-03 00:00:00 |  |  | 4
 | ID04 |  |  |  |  | 2012-01-04 00:00:00 |  |  | 5
 |  |  | 2007 |  | 2003
 |  | Count | COUNTIFS($B$1:$B$5,$C$1,$G$1:$G$5,">"&TODAY()-365) |  | 1
 |  | Sum | SUMIFS($I$1:$I$5,$B$1:$B$5,$C$1,$G$1:$G$5,">"&TODAY()-365) |  | 10
 |  |  |  |  | 10 | <---Your formula
Spreadsheet: 194981d1353382577-counting-unique-text-instances-with-conditions-kazaly_877344_19nov12_01
Sheet: Sheet2

Date | Item | ID | Fee | Amount |  | Unique_List | Total_Count
2012-07-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 251070289333 | [NAME] | 0.5 |  | Womans Weekly Dinner Party Cookbook
2012-08-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 261070289444 | [NAME] | 0.5
2012-09-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 382070289668 | [NAME] | 0.5
2012-09-20 00:00:00 | Womans Weekly Dinner Party Cookbook | 382070289668 | FVF | 0.5
2012-09-21 00:00:00 | Womans Weekly Dinner Party Cookbook | 261070289668 | FVF | 0.5
2012-11-21 00:00:00 | Womans Weekly Dinner Party Cookbook | 273000289888 | [NAME] | 0.5
Spreadsheet: 466193d1466060904-number-is-in-vertical-format-number-is-in-vertical-format
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Answer
 | 2995 | 2890 | 2985 | 2990 | 2930 | 2970 |  |  | 2995
 | 2930 | 0 | 2990 | 2960 | 2980 | 1135 |  |  | 2930
 | 2985 | 0 | 1870 | 2995 | 2955 | 0 |  |  | 2985
 | 2890 | 0 | 0 | 1015 | 2935 | 0 |  |  | 2890
 | 0 | 0 | 0 | 0 | 2970 | 0 |  |  | 2890
 | 0 | 0 | 0 | 0 | 2910 | 0 |  |  | 2985
 | 0 | 0 | 0 | 0 | 2980 | 0 |  |  | 2990
 | 0 | 0 | 0 | 0 | 165 | 0 |  |  | 1870
 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2990
 |  |  |  |  |  |  |  |  | 2960
 |  |  |  |  |  |  |  |  | 2995
 |  |  |  |  |  |  |  |  | 1015
 |  |  |  |  |  |  |  |  | 2930
 |  |  |  |  |  |  |  |  | 2980
 |  |  |  |  |  |  |  |  | 2955
 |  |  |  |  |  |  |  |  | 2935
 |  |  |  |  |  |  |  |  | 2970
 |  |  |  |  |  |  |  |  | 2910
 |  |  |  |  |  |  |  |  | 2980
 |  |  |  |  |  |  |  |  | 165
 |  |  |  |  |  |  |  |  | 2970
 |  |  |  |  |  |  |  |  | 1135
Spreadsheet: 65284d1265973013-index-and-match-to-return-value-between-two-dates-test-index-match-date
Sheet: Sheet1

Start | End | No of Months | Amount Payable per Month | Total
2009-01-01 00:00:00 | 2009-08-31 00:00:00 | 8 | 59.34318954204381 | 474.7455163363505
2009-09-01 00:00:00 | 2010-02-28 00:00:00 | 6 | 272.0481846630102 | 1632.289107978061
 |  |  |  | 2107.034624314412
Sum of Amount
Period | ACTUAL CHARGE | TEST
2007-10-01 00:00:00 |  | 0
2007-11-01 00:00:00 |  | 0
2007-12-01 00:00:00 |  | 0
2008-01-01 00:00:00 |  | 0
2008-02-01 00:00:00 |  | 0
2008-03-01 00:00:00 |  | 0
2008-04-01 00:00:00 |  | 0
2008-05-01 00:00:00 |  | 0
2008-06-01 00:00:00 |  | 0
2008-07-01 00:00:00 |  | 0
2008-08-01 00:00:00 |  | 0
2008-09-01 00:00:00 |  | 0
2008-10-01 00:00:00 |  | 0
2008-11-01 00:00:00 |  | 0
2008-12-01 00:00:00 |  | 0
2009-01-01 00:00:00 |  | 59.34
2009-02-01 00:00:00 |  | 59.34
2009-03-01 00:00:00 |  | 59.34
2009-04-01 00:00:00 |  | 59.34
2009-05-01 00:00:00 |  | 59.34
2009-06-01 00:00:00 |  | 59.34
2009-07-01 00:00:00 |  | 59.34
2009-08-01 00:00:00 |  | 59.34
2009-09-01 00:00:00 |  | 272.05
2009-10-01 00:00:00 |  | 272.05
2009-11-01 00:00:00 |  | 272.05
2009-12-01 00:00:00 |  | 272.05
2010-01-01 00:00:00 |  | 272.05
2010-02-01 00:00:00 |  | 272.05
Grand Total |  | 2107.02
Spreadsheet: 83205d1283243502-ranking-based-on-3-conditions-tiebreakertest3
Sheet: Sheet1

 |  |  |  | 1st tie breaker |  |  |  |  |  | Nescessary helper columns |  |  | Can be deleted - different sub-functions of Ties 3 - just to better understand what I have done
Team | RANK | Ties | Final Rank with ties shown correctly | Add hi/low ranks for tie breaker | see only ties |  | Correct answer doing it by hand | [NAME] after tie-breaker | Correct answer? | Ties 2 | Ties 3 |  | Identify min of 3 | identify [NAME] of 3
A | 2 |  |  | 14.5 |  |  | 2 | 2
B | 2 |  |  | 8 |  |  | 1 | 1
C | 5 |  |  | 28.5 |  |  |  | 5
D | 8 |  |  | 39 |  |  | 9 | 9
E | 8 |  |  | 37.5 |  |  | 8 | 8
F | 6 |  |  | 31 |  |  |  | 6
G | 7 |  |  | 35 |  |  |  | 7
H | 11 |  |  | 55 |  |  | 12 | 12
I | 4 |  |  | 24.5 |  |  |  | 4
J | 11 |  |  | 45 |  |  | 11 | 11
K | 10 |  |  | 38.5 |  |  |  | 10
L | 2 |  |  | 18.5 |  |  | 3 | 3
 |  |  |  |  |  | If Col C=2, then look at D and find the duplicate. Then look at E to find out which number is the lowest.  The lower number, subtract 0.5 from ColumnD.  If they are equal, add 0 (and we'll go on to tie-breaker #2).  If it is the higher number, add 0.5.
 |  |  |  |  |  | If Col C=3, then look at D to find the other 2 duplicates.  Then look at E to find out which number is the lowest.  The lower number, subtract 1 from ColumnD.  The middle number stays the same, add 0.  If it is the higher number, add 1.
Spreadsheet: 765127d1643186922-need-help-in-finding-any-formula-to-get-difference-of-in-and-out-timing-sample
Sheet: Manual format

 |  |  | Status |  | Status |  | Status
Employee Name | Emp Number | 22/01/2022 | 22/01/2022 | 23/01/2022 | 23/01/2022 | 25/01/2022 | 25/01/2022
A | SP-01
B | SP-06
C | SP-07
D | SP-09
Vlookup in the SYSTEM EXTRACTED tab, the difference between IN and OUT if for the employee is 8 HOURS show nothing.
if the difference in IN and OUT is less then 8 hours and above 4 hours show Half Day
if the difference in IN and OUT is less then 8 hours and above 2 hours show Short Leave
Spreadsheet: 356732d1415197538-matching-comparing-data-from-2-tables-example-for-excel-thread-v1
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Table 3A (Desired Results) |  |  |  | Table 3B (Secondary Desired Results if Table 3A isn't possible)
Name | Value |  |  |  | Name | State |  |  |  | Name | State | Value |  | Name | State | Value
[NAME] | 1000 |  |  |  | Benard | Texas |  |  |  | [NAME] | Alabama | 1000 |  | [NAME] | Alabama | 1000
Benard | 2000 |  |  |  | [NAME] | Tennessee |  |  |  | Benard | Texas | 2000 |  | Benard | Texas | 2000
[NAME] | 3000 |  |  |  | Emily | South Carolina |  |  |  | [NAME] | Kentucky | 3000 |  | [NAME] | Kentucky | 3000
[NAME] | 4000 |  |  |  | [NAME] | Kentucky |  |  |  | [NAME] | N/A | 4000 |  | Emily | South Carolina | 5000
Emily | 5000 |  |  |  | [NAME] | Alabama |  |  |  | Emily | South Carolina | 5000 |  | [NAME] | Tennessee | 6000
[NAME] | 6000 |  |  |  |  |  |  |  |  | [NAME] | Tennessee | 6000
Gayle | 7000 |  |  |  |  |  |  |  |  | Gayle | N/A | 7000
Spreadsheet: 21449d1208982360-autofill-cells-from-a-formula-seperating-rows-based-on-colume-data
Sheet: Sheet1

Call Order | First & Last Name | Address | City | State | Bull | Bronc_B | Bronc_S | GBR | TR | CD | TDR | SW | Waiver
1 | [NAME] | 868 N Centerline Apt B | White Cloud | MI | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | Yes
2 | [NAME] | 23585 11 Mile Rd | Big Rapids | MI | 2 | 0 | 2 | 0 | 0 | 0 | 2 | 2 | Yes
3 | [NAME] | 18923 RDK | West Unity | OH | 3 | 3 | 3 | 0 | 0 | 3 | 0 | 3 | No
4 | [NAME] | 6456 W Mead Rd | [NAME] | MI | 4 | 4 | 4 | 0 | 0 | 4 | 4 | 4 | Yes
5 | [NAME] | 3570 N. Black Corners Rd | Imlay City | MI | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No
6 | [NAME] | 1545 Dodd Rd | Niles | MI | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Yes
7 | [NAME] | 2212 E Cidermill Rd | Columbia City | IN | 7 | 7 | 7 | 0 | 7 | 7 | 0 | 7 | Yes
8 | [NAME] | 4034 Henderson Lake Rd | Prescott | MI | 8 | 8 | 0 | 0 | 0 | 8 | 8 | 0 | Yes
9 | [NAME] | 6412 Lovejoy Rd | [NAME] | MI | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | Yes
10 | [NAME] | 3935 Barnard Rd | Saginaw | MI | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | No
 | How do I write a formula to have each line copy to another tab in my worksheet with the condition being, in colume F, data that is >0 (or =>1), whichever is prefered.
 | Also I want them to stay in the exact order.
Spreadsheet: 725224d1616593469-dynamic-counta-example
Sheet: Data

LoadDate | LoadRef | Supplier | CollPostcode | Pallets | SubContractor | Plt rate per PC | MAX plt rate | MAX plt rate per load
2021-03-24 00:00:00 | 30178 | AAA | LS9 0SJ | 52 | TEST
2021-03-24 00:00:00 | 30178 | BBB | CW10 9UN | 52 | TEST
2021-03-24 00:00:00 | 30178 | CCC | LU5 5BN | 26 | TEST
Spreadsheet: 835071d1688278503-formula-to-allocate-my-reorder-quantity-in-quarter-columns-based-on-reorder-points-book3
Sheet: Sheet1

 |  |  | TSL
Part Number | Part Name | Reorder Point | TSL (Stock [NAME]) | Reorder Quanity (= TSL-Reorder point) | Units on Hand (Global OH Serviceable from BSAS by Location) | On Order | IN Repair | Unserviceable Inventory | Total Inventory (=Sum(OH+OO+IN+UNSER)) | Forecast Demand | Forecast Quarterly | Intitial Order Quanity or Deplete stock to ROP (TOI-ROP= IOQ) | Number of Quarters till First Reorder Point (=roundup(IOQ/Quarterly Forecast Demand) | Count of Quarters till first ROP | Number of Quarters till 2nd Reorder Point and Beyond (=roundup(ROQ/QU)) | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 | Q1 2025 | Q2 2025 | Q3 2025 | Q4 2025 | Q1 2026 | Q2 2026 | Q3 2026 | Q4 2026
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 43 | 0 | 0 | 43 | 0 | 0 | 43 | 0
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355
Spreadsheet: john_griffith__15924__11_14_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 57 | 400 | 500 | 46.6 | 58.3 | 1.88 | 2001-11-14 11:15:00
 | HO F2 | 58 | 800 | 900 | 51.2 | 57.7 | 1.99 | 2001-11-14 11:15:00
 | HO G2 | 58 | 1070 | 1170 | 51.5 | 56.4 | 1.97 | 2001-11-14 11:15:00
 | [NAME] | 58 | 1200 | 1300 | 49.5 | 53.6 | 1.88 | 2001-11-14 11:15:00
 | HO J2 | 57 | 1200 | 1400 | 44.8 | 52.3 | 1.74 | 2001-11-14 11:15:00
 | HO K2 | 56 | 1250 | 1450 | 42.9 | 49.8 | 1.63 | 2001-11-14 11:15:00
 | HO M2 | 56 | 1300 | 1500 | 40.9 | 47.2 | 1.55 | 2001-11-14 11:15:00
 | HO N2 | 57 | 1325 | 1525 | 38.4 | 44.2 | 1.48 | 2001-11-14 11:15:00
 | HO Q2 | 57 | 1400 | 1550 | 38.1 | 42.3 | 1.44 | 2001-11-14 11:15:00
 | HO U2 |  |  |  | 35.9 | 40.1 | 1.46 | 2001-11-09 14:51:00
 | [NAME] |  |  |  | 34.3 | 38.9 | 1.4 | 2001-11-08 14:49:00
 | HO X2 |  |  |  | 33.2 | 37.3 | 1.31 | 2001-11-07 14:56:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 714614d1611308739-multiple-matches-in-a-cell-separated-by-line-break-multiple-matches-with-line-break
Sheet: Sheet1

Input | Match |  |  | Source: | Country | ID
China, Russia, Brazil | 1234 5432 6789 |  |  |  | China | 1234
China Russia | 1234 5432 |  |  |  | Russia | 5432
Rusia,Brazil | 6789 |  |  |  | Brazil | 6789
Brazil,-Russia, RSA | 5432 6789 9999 |  |  |  | RSA | 9999
China | 1234
Spreadsheet: 864343d1711552659-date-wise-data-output-in-index-function-new-inward-and-outward-ramesh-h-and-m-
Sheet: OUTPUT DATA

OUTPUT DATA |  |  |  |  |  |  |  |  |  |  | OUTPUT DATA
246 EMB PANEL | JAI VISHNU |  | UNIT 1 |  | 246 EMB PANEL | SRI FASHION |  | UNIT 1 |  |  | AAA | [NAME] |  | YYY |  | CCC | ZZZ |  | [NAME]
DATE | DC NO | SENT | RECEIVED |  | DATE | DC NO | SENT | RECEIVED |  |  | DATE | DC NO | SENT | RECEIVED |  | DATE | DC NO | SENT | RECEIVED
 |  |  |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00 | TBC | 720 |  |  | 2024-02-28 00:00:00 | TBC | 820
 |  |  |  |  |  |  |  |  |  |  | 2024-02-23 00:00:00 | 3017 |  | 220 |  | 2024-02-28 00:00:00 | 3624 |  | 121
 |  |  |  |  |  |  |  |  |  |  | 2024-02-24 00:00:00 | TBC | 720
 |  |  |  |  |  |  |  |  |  |  | 24.02.2024 | 3018 |  | 220
 |  |  |  |  |  |  |  | SUBTOTAL(109,ReportTable13[RECEIVED]) |  |  |  | 1 | 220 | 720 |  |  | 1 | 220 | SUBTOTAL(109,ReportTable13[RECEIVED])
 | Balance |  |  |  |  | Balance |  |  |  |  |  | Balance | -500 |  |  |  | Balance | #[NAME]!
Spreadsheet: 842653d1694682573-formula-to-bring-back-latest-cell-not-value-from-a-column-that-meets-other-criteria-sample
Sheet: Sheet1

Type | Trip | name |  | add | call | [NAME] | [NAME] | code | start loc | end loc | Pos |  | Start
YES | 1 |  |  |  |  |  | 02:59 Sat
no | 1 |  |  |  |  | 02:59 Sat | [NAME] |  |  |  |  |  |  |  | I need to bring back if cell in column A = Job then give me the latest information on column J but within the same trip number in column B
no | 1 |  |  |  | 1 | 03:30 Sat | 03:40 Sat |  | A | A
no | 1 |  |  |  | 2 | [NAME] | [NAME] |  | A | A
no | 1 |  |  |  |  | [NAME] | [NAME]
no | 1 |  |  |  |  | 12:48 Sat |  |  | ABCD | ABCD
YES | 2 |  |  |  |  |  | 02:59 Sat
no | 2 |  |  |  |  | 02:59 Sat | [NAME]
no | 2 |  |  |  | 1 | 03:30 Sat | 03:40 Sat |  | B | B
no | 2 |  |  |  | 2 | 06:09 Sat | [NAME] |  | B | B
no | 2 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  | SO CELL N2 SHOULD READ ABCD from Column J AS ITS WITHIN TRIP 1 BUT THE LAST TRIP.
no | 2 |  |  |  |  | 09:44 Sat | 10:00 Sat
no | 2 |  |  |  | 3 | 10:00 Sat | 10:15 Sat |  | B | B
no | 2 |  |  |  | 4 | 10:40 Sat | 11:10 Sat |  | B | B
no | 2 |  |  |  | 5 | 11:10 Sat | 11:40 Sat |  | B | B
no | 2 |  |  |  | 6 | 12:05 Sat | [NAME] |  | YESNOYESNO | YESYESYESYE
no | 2 |  |  |  |  | 12:21 Sat
YES | 3 |  |  |  |  |  | [NAME]
no | 3 |  |  |  |  | [NAME] | 03:59 Sat
no | 3 |  |  |  | 1 | [NAME] | 04:10 Sat |  | D | D
no | 3 |  |  |  | 2 | [NAME] | 08:49 Sat |  | D | D
no | 3 |  |  |  |  | 08:59 Sat | 09:44 Sat
no | 3 |  |  |  |  | 13:52 Sat
no | 4 |  |  |  |  |  | 04:29 Sat
no | 4 |  |  |  |  | 04:29 Sat | 04:59 Sat
no | 4 |  |  |  | 1 | 05:00 Sat | 05:10 Sat |  | D | D
no | 4 |  |  |  | 2 | 09:12 Sat | 09:32 Sat |  | PEPEPEPEPE | PEPEPADFSADD
no | 4 |  |  |  |  | 09:59 Sat | 10:44 Sat
no | 4 |  |  |  |  | 14:18 Sat
Spreadsheet: 730032d1619507213-pulling-data-from-another-sheet-based-on-certain-criteria-without-creating-blank-rows-media-fill-requalification
Sheet: Overview

GMF [NAME] in < 30 Days | Days Until
Spreadsheet: 742051d1627494193-inventory-tracking-formula-to-find-beginning-inventory-and-ending-inventory-based-inventory-worksheet
Sheet: Sheet1

Date | Commodity | Weight | Wt Tag # | [NAME] | Month /Yr
2021-02-01 00:00:00 | Wheat | 47980 | 27 |  |  |  |  | Period Beginning | 2021-06-01 00:00:00
2021-03-01 00:00:00 | Corn | 48760 | 19 |  |  |  |  | Period Ending | 2021-06-30 00:00:00
2021-03-12 00:00:00 | Wheat | 54870 | 28
2021-04-01 00:00:00 | Corn | 49760 | 20
2021-04-02 00:00:00 | [NAME] | 48750 | 33
2021-04-27 00:00:00 | Corn | -47860 | 21
2021-04-29 00:00:00 | Wheat | -49850 | 29 |  |  |  |  | Commodity | [NAME] | Ending Inventory - Tons
2021-05-13 00:00:00 | Wheat | 46890 | 22 |  |  |  |  | Corn | 25.33 | 50.24
2021-05-13 00:00:00 | Wheat | 46980 | 30 |  |  |  |  | [NAME]
2021-05-17 00:00:00 | Wheat | 45760 | 23 |  |  |  |  | Wheat
2021-05-17 00:00:00 | [NAME] | 49320 | 34 |  |  |  |  | Grand Total
2021-05-21 00:00:00 | [NAME] | 49870 | 14
2021-05-27 00:00:00 | [NAME] | -46870 | 17
2021-06-01 00:00:00 | Wheat | 46980 | 12
2021-06-03 00:00:00 | [NAME] | 49870 | 32
2021-06-12 00:00:00 | Wheat | 49780 | 26
2021-06-17 00:00:00 | Wheat | -48950 | 24
2021-06-18 00:00:00 | Wheat | 49870 | 13
2021-06-21 00:00:00 | [NAME] | 48750 | 15
2021-06-22 00:00:00 | Wheat | 49870 | 31
2021-06-27 00:00:00 | Corn | 49820 | 18
2021-07-01 00:00:00 | Corn | 48760 | 1
2021-07-01 00:00:00 | Wheat | 51560 | 25
2021-07-02 00:00:00 | Wheat | 46890 | 4
2021-07-05 00:00:00 | Corn | 49760 | 2
2021-07-10 00:00:00 | Corn | -47860 | 3
2021-07-10 00:00:00 | Wheat | 45760 | 5
2021-07-12 00:00:00 | Wheat | 49780 | 8
2021-07-13 00:00:00 | [NAME] | 49320 | 16
2021-07-14 00:00:00 | Wheat | 47980 | 9
2021-07-15 00:00:00 | Wheat | -49850 | 11
2021-07-16 00:00:00 | Wheat | -48950 | 6
2021-07-18 00:00:00 | Wheat | 54870 | 10
2021-07-21 00:00:00 | Wheat | 51560 | 7
2021-07-21 00:00:00 | [NAME] | -46870 | 35
2021-07-27 00:00:00 | Corn | 49820 | 36
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1564019 | 1170705 | 2018508 | 2894305 | 3932996 | 1771637 | 1302192 | 96641 | 14751003
Fixed-Float | 11036541 | 8183544 | 15987766 | 29544054 | 65101477 | 44332324 | 20736792 | 2065588 | 196988086
FRA | 24738515 | 13019183 | 13130420 | 3944377 | 252469 | 0 | 0 | 0 | 55084964
OIS | 14298150 | 5461285 | 8786685 | 5868198 | 2091739 | 377952 | 211449 | 18049 | 37113507
Swaption | 3959482 | 1745513 | 3165014 | 3783498 | 4621277 | 2295516 | 1056141 | 15817 | 20642258
OTHER* | 2388448 | 1078278 | 1517320 | 2171792 | 4855302 | 4128370 | 2401159 | 195066 | 18735735
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 748789d1632346619-sum-across-multiple-sheets-with-sheets-names-as-references-demo
Sheet: San Diego

 | Showrooms
 | Round Up Floor
 | Actual
 | [NAME] Target
 | Lab
 | Shape |  |  | County by City | Count by City
 | type 1 |  |  | 65 | 0.4676258992805755
 | Type 2 |  |  | 42 | 0.302158273381295
 | type 3 |  |  | 9 | 0.06474820143884892
 | type 4 |  |  | 10 | 0.07194244604316546
 | type 5 |  |  | 4 | 0.02877697841726619
 | type 6 |  |  | 6 | 0.04316546762589928
 | type 7 |  |  | 2 | 0.01438848920863309
 | type 8 |  |  | 1 | 0.007194244604316547
 | type 9 |  |  | 0 | 0
 | type 10 |  |  | 0 | 0
 | Calc Total |  |  | 139 | 1
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Jun

June Valet Totals
PIPER |  |  |  | MAIN |  |  |  | TOTAL
Average Wait Time |  |  |  | Average Wait Time |  |  |  | Average Wait Time
Average Storage Length |  |  |  | Average Storage Length |  |  |  | Average Storage Length
 | Average/hour | Scheduled Productive Hours |  |  | Average/hour | Scheduled Productive Hours |  |  | Average/hour | Scheduled Productive Hours
5:00am-5:59am | 5.2 | 1 |  | 5:00am-5:59am | 0 | 0 |  | 5:00am-5:59am | 2.6 | 1
6:00am-6:59am | 8.2 | 2 |  | 6:00am-6:59am | 0 | 0 |  | 6:00am-6:59am | 4.1 | 2
7:00am-7:59am | 16.5 | 3.5 |  | 7:00am-7:59am | 3.5 | 2 |  | 7:00am-7:59am | 10 | 5.5
8:00am-8:59am | 29.8 | 5 |  | 8:00am-8:59am | 8 | 2 |  | 8:00am-8:59am | 18.9 | 7
9:00am-9:59am | 39 | 5.5 |  | 9:00am-9:59am | 12.7 | 2 |  | 9:00am-9:59am | 25.85 | 7.5
10:00am-10:59am | 46 | 5 |  | 10:00am-10:59am | 17.8 | 3 |  | 10:00am-10:59am | 31.9 | 8
11:00am-11:59am | 37.5 | 5 |  | 11:00am-11:59am | 17.5 | 3 |  | 11:00am-11:59am | 27.5 | 8
12:00pm-12:59pm | 39.7 | 5 |  | 12:00pm-12:59pm | 17.1 | 2 |  | 12:00pm-12:59pm | 28.4 | 7
1:00pm-1:59pm | 36.8 | 5 |  | 1:00pm-1:59pm | 17.5 | 2 |  | 1:00pm-1:59pm | 27.15 | 7
2:00pm-2:59pm | 34.9 | 4.5 |  | 2:00pm-2:59pm | 17.7 | 3 |  | 2:00pm-2:59pm | 26.3 | 7.5
3:00pm-3:59pm | 30.5 | 3.5 |  | 3:00pm-3:59pm | 11.5 | 3 |  | 3:00pm-3:59pm | 21 | 6.5
4:00pm-4:49pm | 17.4 | 1.5 |  | 4:00pm-4:49pm | 8.8 | 2 |  | 4:00pm-4:49pm | 13.1 | 3.5
5:00pm-5:59pm | 10.6 | 1 |  | 5:00pm-5:59pm | 6.4 | 2 |  | 5:00pm-5:59pm | 8.5 | 3
6:00pm-6:59pm | 5.5 | 1 |  | 6:00pm-6:59pm | 5.3 | 2 |  | 6:00pm-6:59pm | 5.4 | 3
7:00pm-8:00pm | 0 | 0 |  | 7:00pm-8:00pm | 3.7 | 2 |  | 7:00pm-8:00pm | 1.85 | 2
 | 23.84 | 48.5 |  |  | 9.833333333333334 | 30 |  |  | 16.83666666666667 | 78.5
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* |  | <100 | <100 | <100 | 139 | 106 | 120 | 365
FRA | 5504 | 4505 | 3566 | 4068 | <100 |  |  | 17643
IRS- [NAME] | <100 | 211 | 357 | 1688 | 6435 | 10429 | 10534 | 29654
OIS | 302 | 298 | 206 | 794 | 286 |  |  | 1886
VNS |  |  |  |  |  |  | <100 | <100
Zero Coupon |  |  | <100 | <100 | <100 | <100 | 162 | 162
TOTAL | 5806 | 5014 | 4129 | 6550 | 6860 | 10535 | 10816 | 49710
Estimated swap transaction volumes, January 11 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
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 tenor bucket 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: 856876d1706046414-calculate-a-figure-which-is-the-result-of-several-items-automatically-please-see-file-question-solution-
Sheet: Solution

 |  | Initial Cost of the unit |  | Learning | Porcentage reduction because of the learning |  | Year | Number of units produced per year | Cost without learning | Cost with learning
 |  | 600 |  | 1st unit | 1 |  | 1st | 2
 |  | 600 |  | 2nd unit | 0.95 |  | 2nd | 2
 |  | 600 |  | 3rd unit | 0.9 |  | 3rd | 1
 |  | 600 |  | 4th unit | 0.85 |  | 4th | 3
 |  | 600 |  | 5th unit | 0.85 |  | 5th | 1
Spreadsheet: 864290d1711507602-find-the-most-recent-buy-value-find_buy_price_example_v2
Sheet: Sheet1

Date | Signal | Price | #[NAME] | Value | Profit | % Profit
2014-03-27 00:00:00 | Buy | 184.58
2014-03-28 00:00:00 | Ignore | 185.49
2014-03-31 00:00:00 | Sell | 187.01
2014-08-28 00:00:00 | Buy | 200.14
2014-08-29 00:00:00 | Sell | 200.71
2014-09-30 00:00:00 | Buy | 197.02
2014-10-01 00:00:00 | Ignore | 194.35
2014-10-02 00:00:00 | Ignore | 194.38
2014-10-03 00:00:00 | Sell | 196.52
2014-12-31 00:00:00 | Buy | 205.54
2015-01-02 00:00:00 | Ignore | 205.43
2015-01-05 00:00:00 | Ignore | 201.72
2015-01-06 00:00:00 | Ignore | 199.82
2015-01-07 00:00:00 | Ignore | 202.31
2015-01-08 00:00:00 | Sell | 205.9
The $[NAME] after each buy needs to stay constant (Green).
It should only change with the next buy according to =INT(10000/C2) etc
Spreadsheet: 703541d1605036618-craps-game-spreadsheet-need-help-with-formulas-6-8-outcomes-3-
Sheet: 6,8 outcomes (3)

D1 | D2 | Total |  | Roll Count | COR? | # Rolled | SP, 7out, MP | W/L | Net | B? | B Level |  |  | COR | SP | B Level | Net
 |  |  |  | 1 | COR | 10 |  |  |  |  |  |  |  | 2 | 4 | 11 | 35
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 3 | 5 | 21
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 7 | 6 | 22 | 31
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 11 | 8 | 31
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 12 | 9 | 32 | 27
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 10 | 41
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 42 | 36
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 52 | 50
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 62 | 49
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 72 | 38
 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 82 | 44
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 92 | 40
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 102 | 35
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 111
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 112 | 41
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 121
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 122 | 40
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 131
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 132 | 42
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 141
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 142 | 43
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 8
 |  |  |  |  |  | 7
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 7
Spreadsheet: 550007d1512045078-count-how-many-values-from-a-list-are-within-ranges-book1
Sheet: Sheet1

17 |  | 5 | 25
20
34
20
31
29
37
44
34
28
7
43
16
37
28
38
7
10
30
37