tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: robin_rodrigue__33339__IMCan_Gas_Bench
Sheet: As Reported by Canada

TIME BUCKET/KEY: |  | REPORT REGION | RISK TYPE | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | 36678 |  | 36708 |  | 36739 |  | 36770 |  | 36800 |  | 38384 |  | 38749 |  | 40575 |  | 40575 |  | 42401 |  | 42401 |  | 2016-02-01 00:00:00 |  | Total ECT |  | Prior Day
To: |  |  |  | 36678 |  | 36708 |  | 36739 |  | 36770 |  | 36800 |  | 38718 |  | 40544 |  | 42370 |  | 42370 |  | 45200 |  | 45200 |  | 2023-10-01 00:00:00 |  |  |  |  |  | Change
CANADA (INTRAMONTH)
Physical |  | IMCANADA | PHY |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Gas Daily |  | IMCANADA | G |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Notional |  | IMCANADA | D |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Equivalent |  | IMCANADA | D |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Price |  | IMCANADA | P |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 2

 | December 27 | January 3 | January 10 | January 17 | January 24
Total Interest Rate* | 734549856 | 685071453 | 690578292 | 684708161 | 659522308
SDs and MSPs** | 619220188 | 570264153 | 573961277 | 568020528 | 555545259
Other | 115329668 | 114807299 | 116617015 | 116687633 | 103977049
Total Cross-Currency | 28274953 | 28682606 | 28768464 | 28376341 | 33777797
SDs and MSPs | 24495417 | 24902200 | 25006510 | 24659602 | 30155607
Other | 3779536 | 3780406 | 3761954 | 3716739 | 3622190
Total Credit | 17160679 | 17122903 | 17588412 | 17400549 | 16358983
SDs and MSPs | 12818317 | 12811947 | 13052358 | 12911817 | 12888682
Other | 4342362 | 4310956 | 4536054 | 4488732 | 3470301
Total FX**** | 62900000 | 62900000 | 62900000 | 62900000 | 62900000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 8840000 | 8840000 | 8840000 | 8840000 | 8840000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 3400000 | 3400000 | 3400000 | 3400000 | 3400000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 855125488 | 806016962 | 812075168 | 805625051 | 784799088
Weekly snapshot, gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. Because this table shows the aggregated notional values of swaps by participant, the totals on this table are twice those displayed on the "Gross Notional Outstanding by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 34402d1231643313-multiple-condition-vlookup-copy-of-book1
Sheet: data 1

CUSIP | TRAN CODE | PMT
s87544 | int | 588.6
45rrt5y6 | int | 577.6
jgjg74h4jd | buy | 455.25
u3hhff7 | int | 2223
[NAME] | buy | 4242.32
[NAME] | int | 318554
fjnvfnfu8 | buy | 32
fvihcwyw | int | 121543
ghmlmho | int | 187944
wtwsvwr | int | 1941648
wfeyegdb | buy | 15843
sdysfw5 | int | 2
sdubgcua | int | 5
uwecdysv | pydn | 6996
Spreadsheet: 765074d1643147911-copy-dates-with-a-4-day-interval-example-date-range-
Sheet: Sheet1

Tally | Night
WC-1 | 2022-01-13 00:00:00
WL-1 | 2022-01-13 00:00:00
WC-2 | 2022-01-13 00:00:00
WL-2 | 2022-01-13 00:00:00
WC-1 | 2022-01-14 00:00:00
WL-1 | 2022-01-14 00:00:00
WC-2 | 2022-01-14 00:00:00
WL-2 | 2022-01-14 00:00:00
WC-1 | 2022-01-15 00:00:00
WL-1 | 2022-01-15 00:00:00
WC-2 | 2022-01-15 00:00:00
WL-2 | 2022-01-15 00:00:00
WC-1 | 2022-01-16 00:00:00
WL-1 | 2022-01-16 00:00:00
WC-2 | 2022-01-16 00:00:00
WL-2 | 2022-01-16 00:00:00
Spreadsheet: 798504d1664523193-complex-deferred-revenue-schedule-help-edit-sales-data
Sheet: Sheet1

 |  |  |  | 1. Sales Data - We've provided a list of customer contracts with sales data for a prospective SaaS client in the education technology space. In Columns H-CM, please calculate the monthly GAAP-basis revenue amounts for each contract factoring total revenue type, contract value, and start/end dates.
 |  |  |  | 2. Summary Slide - After completing the revenue recognition exercise, please create three summary charts and bullet points you feel highlight important qualities of the business based on the available data.
 |  |  |  | =($E2<=H$1)*(H$1<=$F2)*($D2/(($F2-$E2)/30))
Contract Value | Start Date | End Date |  | 2019-01-31 00:00:00
1100000 | 2020-09-06 00:00:00 | 2023-09-06 00:00:00
50000 | 2020-09-06 00:00:00 | NA
375000 | 2020-05-28 00:00:00 | 2021-05-28 00:00:00
172475 | 2021-02-03 00:00:00 | 2022-02-03 00:00:00
231750 | 2019-08-07 00:00:00 | 2022-08-07 00:00:00
191250 | 2020-06-26 00:00:00 | 2021-06-26 00:00:00
162560 | 2020-12-08 00:00:00 | 2023-12-08 00:00:00
127475 | 2020-12-30 00:00:00 | 2021-12-30 00:00:00
212500 | 2021-03-07 00:00:00 | 2024-03-07 00:00:00
122060 | 2020-07-25 00:00:00 | 2023-07-25 00:00:00
104125 | 2019-04-26 00:00:00 | 2022-04-26 00:00:00
99450 | 2020-03-31 00:00:00 | 2023-03-31 00:00:00
93000 | 2020-06-06 00:00:00 | 2021-06-06 00:00:00
91125 | 2020-11-25 00:00:00 | 2023-11-25 00:00:00
82445 | 2020-05-24 00:00:00 | 2021-05-24 00:00:00
82500 | 2021-04-25 00:00:00 | 2024-04-25 00:00:00
80000 | 2021-08-07 00:00:00 | 2024-08-07 00:00:00
76250 | 2019-05-23 00:00:00 | 2022-05-23 00:00:00
97500 | 2021-10-21 00:00:00 | 2022-10-21 00:00:00
53365.25 | 2019-01-31 00:00:00 | 2021-01-31 00:00:00
49020 | 2020-08-20 00:00:00 | 2023-08-20 00:00:00
42525 | 2019-01-30 00:00:00 | 2022-01-30 00:00:00
38250 | 2021-02-25 00:00:00 | 2024-02-25 00:00:00
33225 | 2021-10-25 00:00:00 | 2023-10-25 00:00:00
17500 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00
Spreadsheet: 156690d1337389887-populate-data-only-when-project-is-complete-help-2
Sheet: April

Project | Cost | Labor | Complete
AA | 1 | 1 | X
AB | 2 | 2 | X
AC | 3 | 4 | X
AD | 4 | 3 | X
AA | 5 | 8
AE | 6 | 1 | X
AF | 7 | 3 | X
AA | 8 | 7 | X
Spreadsheet: 871732d1718162393-unique-sum-with-multiple-criteria-tests2
Sheet: Result

 |  | Ref New |  | [NAME] |  | Whatsapp Note
 |  | Quantity | Value | Quantity | Value | Value
 |  | 619.66 | 189705 | 0 | 0 | 0
 | [NAME] | 1320 | 264000 | 0 | 0 | 0
 | Scented Adhesive Powder | 1015.05 | 456717 | 0 | 0 | 12788.76
 | Scented & Adhesive Clay | 238.3 | 94128.5 | 0 | 0 | 0
 | [NAME] | 8231.35 | 1970774.85 | 0 | 0 | 0
 | Freight | 7380.15 | 36900.75 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 4049.5 | 0
 | Desten & Biber | 0 | 0 | 88.3 | 38852 | 0
 | [NAME] | 0 | 0 | 30 | 3300 | 0
 | Papa | 88.3 | 38852 | 0 | 0 | 0
 | [NAME] | 30 | 3300 | 0 | 0 | 0
 | Laila Majnu | 0 | 0 | 1320 | 264000 | 0
 | My Forum | 0 | 0 | 0 | 0 | 551
 | Grand Total | 18922.81 | 3054378.1 | 1438.3 | 310201.5 | 13339.76
Spreadsheet: 119393d1314366610-formula-to-return-the-values-in-the-attached-sheet-sheet1datespt
Sheet: Sheet1

2011-08-04 00:00:00 |  | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W
Tower | NAME | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
Net | Y | 5 | 5 | WO | 1 | 1 | 1 | 1 | 1 | WO | WO | 4 | 4 | 5 | 5 | 5 | WO | WO | 1 | 1 | 1 | 1 | 1 | WO | WO | 4 | 5 | WO | WO | 4 | 4 | 5
 |  |  |  |  | Value2 | (Multiple Items)
 |  |  |  |  | Sum of Value2
Date | Value | Value2 |  |  | Date | Total
2011-01-01 00:00:00 | 5 | 5 |  |  | 2011-01-01 00:00:00 | 5
2011-01-02 00:00:00 | 5 | 5 |  |  | 2011-01-02 00:00:00 | 5
2011-01-03 00:00:00 | WO | 0 |  |  | 2011-01-03 00:00:00 | 0
2011-01-04 00:00:00 | 1 | 1 |  |  | 2011-01-09 00:00:00 | 0
2011-01-05 00:00:00 | 1 | 1 |  |  | 2011-01-10 00:00:00 | 0
2011-01-06 00:00:00 | 1 | 1 |  |  | 2011-01-11 00:00:00 | 4
2011-01-07 00:00:00 | 1 | 1 |  |  | 2011-01-12 00:00:00 | 4
2011-01-08 00:00:00 | 1 | 1 |  |  | 2011-01-13 00:00:00 | 5
2011-01-09 00:00:00 | WO | 0 |  |  | 2011-01-14 00:00:00 | 5
2011-01-10 00:00:00 | WO | 0 |  |  | 2011-01-15 00:00:00 | 5
2011-01-11 00:00:00 | 4 | 4 |  |  | 2011-01-16 00:00:00 | 0
2011-01-12 00:00:00 | 4 | 4 |  |  | 2011-01-17 00:00:00 | 0
2011-01-13 00:00:00 | 5 | 5 |  |  | 2011-01-23 00:00:00 | 0
2011-01-14 00:00:00 | 5 | 5 |  |  | 2011-01-24 00:00:00 | 0
2011-01-15 00:00:00 | 5 | 5 |  |  | 2011-01-25 00:00:00 | 4
2011-01-16 00:00:00 | WO | 0 |  |  | 2011-01-26 00:00:00 | 5
2011-01-17 00:00:00 | WO | 0 |  |  | 2011-01-27 00:00:00 | 0
2011-01-18 00:00:00 | 1 | 1 |  |  | 2011-01-28 00:00:00 | 0
2011-01-19 00:00:00 | 1 | 1 |  |  | 2011-01-29 00:00:00 | 4
2011-01-20 00:00:00 | 1 | 1 |  |  | 2011-01-30 00:00:00 | 4
2011-01-21 00:00:00 | 1 | 1 |  |  | 2011-01-31 00:00:00 | 5
2011-01-22 00:00:00 | 1 | 1 |  |  | Grand Total | 55
2011-01-23 00:00:00 | WO | 0
2011-01-24 00:00:00 | WO | 0
2011-01-25 00:00:00 | 4 | 4
2011-01-26 00:00:00 | 5 | 5
2011-01-27 00:00:00 | WO | 0
2011-01-28 00:00:00 | WO | 0
2011-01-29 00:00:00 | 4 | 4
2011-01-30 00:00:00 | 4 | 4
2011-01-31 00:00:00 | 5 | 5
Spreadsheet: 828361d1683443673-financial-dash-board-dash-board
Sheet: Sheet1

213424
73313
2378
53500
6836
10953
139164
0
0
0
144303
58683
79650
3110
25758
1399
4053
28984
0
0
0
143400
59492
44950
1467
22157
1358
4391
28802
0
0
0
64437
20877
10354
818
22449
5668
6727
12942
0
0
0
32218.5
10438.5
5177
409
11224.5
2834
3363.5
6471
0
0
0
13127
8550
2588.5
204.5
5612.25
1417
1681.75
2637
0
0
0
177343
73959
73125
1601
35258
1690
-15325
35620
0
0
0
1267692.5
445423.5
289157.5
9987.5
175958.75
21202
15844.25
254620
47333
1142
8972
611657
239924
73313
2726
46047
3416
28782
120535
0
0
0
209543
76495
79650
2133
34505
1266
13994
41293
0
0
0
136497
55004
80910
1636
27889
856
5647
26899
0
0
0
10192
4449
15531
788
18937
5030
2995
2009
0
0
0
14886
11625
6000
987
10632
1000
1029
2933
0
0
0
656
190
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
983431
387687
255404
8270
138010
11568
52447
193669
14000
16000
4206
Spreadsheet: 860283d1708439628-formula-for-entering-a-beginning-number-and-ending-number-and-result-is-lower-or-higher-john-asset-management-sheet
Sheet: IRA Rob

IRA [NAME]
 | Opening | Closing | Total Value | Percent Change
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 782928d1654428403-add-weekly-hours-to-get-4-weekly-total-hours-asda-wages
Sheet: Asda Wages

[NAME] May - 11 June |  |  |  |  |  |  |  |  | Break Entitlement
 |  |  |  |  |  |  |  |  | Shift | Entitlement
 |  |  |  |  |  |  |  |  | 00:00 - 04:10 | 00:00
Week 1: 15 May - 21 May |  |  |  |  |  |  |  |  | 04:10 - 06:10 | 00:15
 |  |  |  |  |  |  |  |  | 06:10 - 08:10 | 00:30
Date | Contract | In | Out | Break | Hours | Pay | Up / Down |  | 08:10 - 09:10 | 00:45
2022-05-16 00:00:00 | 07:30:00 | 14:00:00 | 22:17:00 | 00:30:00 |  |  |  |  | 09:10 - 11:10 | 00:60
2022-05-18 00:00:00 | 07:00:00 | 11:00:00 | 20:51:00 | 00:00:00 |  |  |  |  | 11:10 - 20:00 | 01:30
2022-05-19 00:00:00 | 07:30:00 | 14:00:00 | 21:09:00 | 00:30:00
2022-05-21 00:00:00 | 07:30:00 | 08:00:00 | 15:16:00 | 00:00:00
Week 2: 22 May - 28 May
Date | Contract | In | Out | Break | Hours | Pay | Up / Down
2022-05-22 00:00:00 | 07:30:00 | 14:30:00 | 22:00:00 | 00:00:00
2022-05-23 00:00:00 | 07:30:00 | 14:00:00 | 21:26:00 | 00:00:00
2022-05-25 00:00:00 | 07:00:00 | 15:00:00 | 22:51:00 | 00:00:00
2022-05-26 00:00:00 | 07:30:00 | 10:30:00 | 19:09:00 | 00:00:00
Week 3: 29 May - 4 June
Date | Contract | In | Out | Break | Hours | Pay | Up / Down
2022-05-29 00:00:00 | 07:30:00 | 17:45:00 | 20:45:00 | 00:00:00
2022-05-30 00:00:00 | 07:30:00 | 14:30:00 | 21:53:00 | 00:00:00
2022-05-31 00:00:00 | 00:00:00 | 15:00:00 | 19:48:00 | 00:00:00
2022-06-01 00:00:00 | 07:00:00 | 16:00:00 | 20:32:00 | 00:00:00
2022-06-02 00:00:00 | 07:30:00 | 14:00:00 | 19:21:00 | 00:00:00
Week 4: 5 June - 11 June
Date | Contract | In | Out | Break | Hours | Pay | Up / Down
2022-06-05 00:00:00 | 07:30:00 |  |  | 00:00:00
2022-06-06 00:00:00 | 07:30:00 |  |  | 00:00:00
2022-06-07 00:00:00 | 00:00:00 |  |  | 00:00:00
2022-06-08 00:00:00 | 07:00:00 |  |  | 00:00:00
2022-06-09 00:00:00 | 07:30:00 |  |  | 00:00:00
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: Piotr Gwozdz

Date Invoiced | Invoice Number | Invoice Value | Payment Due | Net Amount | CIS Amount | Paid Employee | Paid CIS | Overdue |  | Amounts Match? |  | Yes/No Options
2011-05-08 00:00:00 | 1 | 875 |  |  |  |  |  |  |  |  |  | Yes
2011-05-15 00:00:00 | 2 | 625 |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 49620d1248974317-how-to-recalculate-with-drop-down-menu-drop-down-calculations
Sheet: Sheet3

(m) |  | (N) | (O) | (P) | (Q) | (R)
values |  | Tea | Coffee | Hot Chocolate | Milkshake | Water
1000
1500
500
100
500
 |  | the calculations above are based on sheet 2, column B: B2 to B6
 |  | what I need to do is to be able to use sheet 1 to choose option 1, or 2 or 3 from sheet 2
 |  | then I need the calculations above to be changed according to what drop down choice has been made
Spreadsheet: 685959d1594296030-look-up-postcode-and-allocate-region-example
Sheet: UK Postcode

Postcode | In Use? | County | District | Region
BA1 0AQ | Yes | Somerset | Bath and North East Somerset | Scott
BA1 0AZ | Yes | Somerset | Bath and North East Somerset | Scott
BA1 0BT | Yes | Somerset | Bath and North East Somerset | Scott
BA1 0DH | Yes | Somerset | Bath and North East Somerset | Scott
BA1 0DS | Yes | Somerset | Bath and North East Somerset | Scott
BA1 0EJ | Yes | Somerset | Bath and North East Somerset | Scott
B79 0PJ | Yes | Leicestershire | North West Leicestershire | [NAME]
CV10 0RY | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV10 0SB | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV10 0TT | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV10 0TU | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV10 0TZ | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV10 0UA | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
CV11 6BE | Yes | Leicestershire | Hinckley and Bosworth | [NAME]
Spreadsheet: 827444d1682696609-how-to-filter-a-spilling-range-filter-spilling-range
Sheet: Feuil1 (2)

ref | price |  |  |  | ref |  | number of ref (expected results) |  |  | does not work why?
A | 50 |  |  |  |  |  | 5
A | 300 |  |  |  | A |  | 5
A | 250 |  |  |  | A |  | 5
A | 500 |  |  |  | A |  | 5
A | 1000 |  |  |  | A |  | 5
B | 250 |  |  |  | B |  | 3
B | 100 |  |  |  | B |  | 3
B | 25 |  |  |  | B |  | 3
Spreadsheet: 802172d1666691709-raffle-sheet-formula-for-random-draw
Sheet: Sheet2

Ticket Number | Name
1 | [NAME]
2 | [NAME]
3 | [NAME] |  | Numbers to be allocated at Random rather than in sequence
4 | [NAME] |  | Must not allocate same number more than once
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  | -282710.67
2000-12-09 00:00:00
Spreadsheet: 0c1e927c-641a-4009-b318-3b2224d54c9b
Sheet: Sheet1

Family | Percent | related other family or orther family members | suport clan
CYP52 | 38 | CYP585B1 | clan 52
CYP58 | 38 | $
CYP59 | 27.5 | CYP586 CYP587 CYP662 | clan 59
CYP65 | # | #
CYP68 | 30 | CYP595 CYP596 CYP597 CYP598 CYP622 CYP650 CYP651 CYP652 | clan 68
CYP504 | 37 | $
CYP526 | 35.5 | CYP644 | clan 526
CYP529 | 39 | CYP545 | clan 529
CYP531 | 35.5 | $
CYP532 | # | #
CYP539 | 37.5 | $
CYP540 | 36 | $
CYP545 | 39 | CYP529 | clan 529
CYP546 | 37 | $
CYP547 | 35 | CYP617 | clan 547
CYP548 | 35 | $
CYP552 | 29 | CYP58 CYP542 CYP551 CYP680 CYP681 CYP682 | clan 58
CYP562 | 39 | CYP65H1
CYP567 | 31 | $
[NAME] | 37 | $
CYP585 | 38 | CYP52 | clan 52
CYP587 | 34.5 | CYP59 | clan 59
CYP593 | 30 | $
[NAME] | 38.5 | $
CYP605 | 37.5 | $
CYP606 | 38 | $
CYP617 | 38.5 | $
CYP631 | 38.5 | CYP532E1 | clan 531
CYP643 | 36.5 | $
CYP650 | 39 | CYP68L1 | clan 68
CYP682 | 30.5 | CYP58 CYP551 CYP552(6/10) CYP680 CYP682 | clan 58
# indicates standard family was split into different clans (see text).
$ [NAME] family rejoined to a group exclusively consisting of this family members.
Spreadsheet: 598592d1542619532-populate-formatted-race-cards-from-data-on-separate-sheet-race-cards
Sheet: Race Cards

 |  |  |  |  |  |  |  |  | Distance |  | Going: |  |  | Runners: |  | Class:
RH_DateAndTime | RH_RaceName | RH_NumberOfRunners | RT_Description | C_Name | G_Going | RH_ClassNumber | RH_Distance | H_ID | Horse | Trainer SR | [NAME] | RnkROF | RnkDPref | RnkGPref | RnkCPref | RnkSPref | RnkPFPClL | RnkPFPClGR | RnkPFP | RnkEClL | RnkSClL | RnkACPFPCl | RnkSPDFIGLr | RnkSHorPro | RnkSHorAvD | RnkSHorAvT | RnkSHorAvG | RnkSHorAvS | RnkJckyTrnrO | RnkJOR | RnkJSR | RnkCon | RnkDrawIV | RnkWH | RnkCB | RnkCBR | RnkCA | RnkAPV | RnkQMPV | ROF | [NAME] | HFP Races | [NAME] | Class Movement | CD Winner | Contender | 5278 Contender Finder Rank
 |  |  |  |  |  |  |  |  | Distance |  | Going: |  |  | Runners: |  | Class:
RH_DateAndTime | RH_RaceName | RH_NumberOfRunners | RT_Description | C_Name | G_Going | RH_ClassNumber | RH_Distance | H_ID | Horse | Trainer SR | [NAME] | RnkROF | RnkDPref | RnkGPref | RnkCPref | RnkSPref | RnkPFPClL | RnkPFPClGR | RnkPFP | RnkEClL | RnkSClL | RnkACPFPCl | RnkSPDFIGLr | RnkSHorPro | RnkSHorAvD | RnkSHorAvT | RnkSHorAvG | RnkSHorAvS | RnkJckyTrnrO | RnkJOR | RnkJSR | RnkCon | RnkDrawIV | RnkWH | RnkCB | RnkCBR | RnkCA | RnkAPV | RnkQMPV | ROF | [NAME] | HFP Races | [NAME] | Class Movement | CD Winner | Contender | 5278 Contender Finder Rank
Spreadsheet: 742817d1628065198-sumproduct-formula-can-i-lock-cell-contents-to-row-problem-w-table-sorting-formula-sorting-issues-aligw
Sheet: Applications

ID | Date of submission | Your name | Why do you want money | Amount applying for | Reference | Whose money do you want
3 | 2021-08-01 00:00:00 | [NAME] | C | 100 |  | Princeton, [NAME]
4 | 2021-08-02 00:00:00 | [NAME] | D | 100 |  | Princeton, [NAME]
2 | 2021-07-31 00:00:00 | [NAME] | B | 100 |  | Princeton, [NAME]
1 | 2021-07-30 00:00:00 | [NAME] | A | 100 |  | Princeton, [NAME]
5 | 2021-08-03 00:00:00 | [NAME] | E | 100000 |  | AliGW
6 | 2021-08-04 00:00:00 | [NAME] | F | 10000000 |  | Princeton, [NAME]
Spreadsheet: 116463d1311859153-how-to-match-a-value-appearing-several-times-in-the-rang-with-multiple-combination-price-list
Sheet: Sheet1

type | part no | class | Unit Price |  |  |  | type | NJ | NJ
NJ | 202 |  |  |  |  |  | PART NO | G4 TO G8 | G4 TO G8
NJ | 202 | E | 3.8868 |  |  |  | CLASS | E | BLANK
NJ | 202 | EM | 4.5264 |  |  | PART NO
NU | 202 | E | 3.6408 |  |  | 202
NU | 202 | EM | 4.231199999999999 |  |  | 203
NU | 202 | EMA | 4.231199999999999 |  |  | 204
NU | 202 | ETN | 3.6408 |  |  | 205
NJ | 203 |  | 4.1205 |  |  | 206
NJ | 203 | EM | 5.276699999999999
NJ | 203 | EMA | 5.276699999999999
NU | 203 |  | 3.8007
NU | 203 | EM | 4.870799999999999
NU | 203 | EMA | 4.870799999999999
NU | 203 | ETN | 4.181999999999999
NUP | 203 |  | 4.723199999999999
NUP | 203 | ETN | 5.190599999999999
NJ | 204 |  | 4.255799999999999
NJ | 204 | E | 4.686299999999999
NJ | 204 | EM | 5.448899999999999
NJ | 204 | EMA | 5.448899999999999
NJ | 204 | ETN | 4.686299999999999
NU | 204 |  | 3.8007
NU | 204 | E | 4.181999999999999
NU | 204 | EM | 4.8585
NU | 204 | EMA | 4.8585
NU | 204 | ETN | 4.181999999999999
NUB | 204 | E | 5.092199999999999
NUP | 204 | E | 5.707199999999999
NUP | 204 | EMA | 6.642
NUP | 204 | ETN | 5.707199999999999
NJ | 205 |  | 4.563299999999999
NJ | 205 | E | 5.018399999999999
NJ | 205 | EM | 5.842499999999999
NJ | 205 | EMA | 5.842499999999999
NJ | 205 | ETN | 5.018399999999999
NU | 205 |  | 4.058999999999999
NU | 205 | E | 4.464899999999999
NU | 205 | EM | 5.2029
NU | 205 | EMA | 5.2029
NU | 205 | ETN | 4.464899999999999
NUB | 205 | E | 5.3628
NUP | 205 | E | 6.027
NUP | 205 | EM | 7.023299999999999
NUP | 205 | EMA | 7.023299999999999
NUP | 205 | ETN | 6.027
NJ | 206 |  | 5.264399999999999
NJ | 206 | E | 5.793299999999999
NJ | 206 | EM | 6.7404
NJ | 206 | EMA | 6.7404
NJ | 206 | ETN | 5.793299999999999
NU | 206 |  | 4.7601
NU | 206 | E | 5.239799999999999
NU | 206 | EK | 5.239799999999999
NU | 206 | EM | 6.1008
NU | 206 | EMA | 6.1008
NU | 206 | ETN | 5.239799999999999
NU | 206 | ETNK | 5.239799999999999
NUB | 206 | E | 5.9655
NUP | 206 |  | 6.1254
NUP | 206 | E | 6.7404
NUP | 206 | M | 7.650599999999998
NUP | 206 | EM | 7.835099999999999
NUP | 206 | EMA | 7.835099999999999
NUP | 206 | ETN | 6.7404