tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0c4f40e5-b393-4ad3-8a83-d6bfe27330bf
Sheet: Sheet1

Supplementary Table 3. Reproducibility of STRUCTURE runs on the combined datasets | Unnamed: 1 | Unnamed: 2
Number of Clusters |  | Individual Similarity coefficients
K=4 | 8 out of 10 runs have Africa as the 4th cluster | 0.98 - 0.99
 | 2 out of 10 have a split in Melanesia instead: New Britain (Ata/Mamusi/Baining) vs Bougainville (Aita) | 0.91
K=5 | 6 out of 10 have the split within  Melanesia: New Britain (Ata/Mamusi/Baining) vs Bougainville (Aita) | 0.90 - 0.99
 | 3 out of 10 have 3 Melanesian clusters (rather than 2 Melanesian clusters plus Africa) | 0.95 - 0.98
 | 1 run has Melanesia as one group, with both Africa and America as separate clusters.
K=6 | 5 out of 10 have America separating from Asia | 0.93 - 0.98
 | 4 out of 10 have Bainings separating from the Ata/Mamusi/Baining group | 0.96 - 0.98
 | 1 run had New Guinea separating from Melanesia
[NAME] | 5 out of 8 have [NAME] and Baining as separate clusters | 0.95 - 0.97
 | 2 out of 8 have Polynesian separating from Asia | 0.96
 | 1 out of 8 has Africa going back with Europe, with the Ata, Baining, and Polynesia forming 3 separate clusters
Note: before removing the first degree relatives from the CEPH samples, America separated at K=4 while Africa only separated at K=6
Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet: FUGG financing

Fort  Union Gas Gathering and Lost Creek Gas Gathering
Ft. Union Term Loan Amortization
Term Loan |  |  |  | Capacity Expansion
Total Project Value |  |  |  | Total Project Value
Term Loan % |  |  |  | Loan %
Term Loan Notional Value |  |  |  | Loan Notional Value
 |  |  |  | *same spreads are assumed to apply
Fixed LIBOR
Margins:
From | To | Spread
closing | 1999-12-30 00:00:00
1999-12-30 00:00:00 | 2001-12-30 00:00:00
2001-12-30 00:00:00 | 2003-12-30 00:00:00
2003-12-30 00:00:00 | 2005-12-30 00:00:00
2005-12-30 00:00:00 | 2007-12-30 00:00:00
2007-12-30 00:00:00 | 2009-12-30 00:00:00
Average
Term Loan
Period |  | 0 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
Date |  | 1999-12-30 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00
LIBOR
Spread
Coupon
Beginning Balance
Principal Payment |  | 0 | 0 | 0 | 0 | 0
Interest Payment
Ending Balance
Total Period Payment |  |  |  |  |  |  | 2157774.285773393
Total Principal Payments
Remaining Notional Amount
Each Bank's Notional Amount
EBITDA DSCR |  | 0
DSCR |  | 0
Spreadsheet: 87430d1287307223-vlookup-formula-vlookup
Sheet: Sheet1

File No. | Name | Dependent Name | [NAME] | Birth date
320 | [NAME] | Raul | Male | 2003-10-15 00:00:00
320 | [NAME] | Nida | Female | 1969-02-07 00:00:00
444 | [NAME] Naira | [NAME] | Male | 1990-06-15 00:00:00
444 | [NAME] Naira | [NAME] | Female | 1992-10-03 00:00:00
444 | [NAME] Naira | Ganim | Male | 1994-05-04 00:00:00
444 | [NAME] Naira | Sara | Female | 1997-10-04 00:00:00
444 | [NAME] Naira | [NAME] | Female | 1966-01-01 00:00:00
556 | Joby Chand Jacob | Jonaid | Male | 1995-08-10 00:00:00
556 | Joby Chand Jacob | maqsood | Male | 1996-05-05 00:00:00
556 | Joby Chand Jacob | markoosh | Male | 1988-04-03 00:00:00
556 | Joby Chand Jacob | [NAME] | Female | 1965-01-01 00:00:00
Spreadsheet: 764479d1642764954-search-by-keywords-all-8-key-trim-file-size
Sheet: Sheet1

AROINTED |  |  | 1 | ADEINORT | UEU | LONGUEUR
[NAME] |  | s | 2 | ADEINORT |  | BLAGUEUR
ORDINATE |  | ds | 3 | ADEINORT
[NAME] |  |  | 4 | ADEINORT
ORIENTAL |  | s | 5 | AEILNORT
RELATION | p | s | 6 | AEILNORT
TAILERON |  | s | 7 | AEILNORT
ANOESTRI |  |  | 8 | AEINORST
ARSONITE |  | s | 9 | AEINORST
NOTAIRES |  |  | 10 | AEINORST
NOTARIES |  |  | 11 | AEINORST
NOTARISE |  | ds | 12 | AEINORST
ROSINATE |  | s | 13 | AEINORST
SENORITA |  | s | 14 | AEINORST
AERATION |  | s | 15 | AAEINORT
AEROLITE |  | s | 16 | AEEILORT
ETAERIOS |  |  | 17 | AEEIORST
DELATION |  | s | 18 | ADEILNOT
IDOLATER |  | s | 19 | ADEILORT
TAILORED |  |  | 20 | ADEILORT
LONGUEUR
BLAGUEUR
LIQUEURS
Spreadsheet: 682850d1592360303-automatically-fill-in-item-code-into-blank-cells-with-macro-or-formula-example
Sheet: Sheet1

Current…
Variant SKU | Handle | Title | image
99887766 | my-seat | Seat | 1
 | my-seat |  | 2
 | my-seat |  | 3
 | my-seat |  | 4
 | my-seat |  | 5
 | my-seat |  | 6
 | my-seat |  | 7
 | my-seat |  | 8
99887755 | my-table | Table | 1
 | my-table |  | 2
 | my-table |  | 3
 | my-table |  | 4
 | my-table |  | 5
 | my-table |  | 6
 | my-table |  | 7
 | my-table |  | 8
 | my-table |  | 9
 | my-table |  | 10
 | my-table |  | 11
Want it to look like…
Variant SKU | Handle | Title | image
99887766 | my-seat | Seat | 1
99887766 | my-seat |  | 2
99887766 | my-seat |  | 3
99887766 | my-seat |  | 4
99887766 | my-seat |  | 5
99887766 | my-seat |  | 6
99887766 | my-seat |  | 7
99887766 | my-seat |  | 8
99887755 | my-table | Table | 1
99887755 | my-table |  | 2
99887755 | my-table |  | 3
99887755 | my-table |  | 4
99887755 | my-table |  | 5
99887755 | my-table |  | 6
99887755 | my-table |  | 7
99887755 | my-table |  | 8
99887755 | my-table |  | 9
99887755 | my-table |  | 10
99887755 | my-table |  | 11
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 673585
 | Loans | 2600
 | Municipal | 3964
 | Recovery
 | Sovereign | 196278
Index Tranche | Asia | <1,000
 | Europe | 116087
 | North America | 136259
Index | Asia | 29030
 | Europe | 367943
 | North America | 523148
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 2048894
Estimated net notional amount outstanding, October 25 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 720728d1614271092-formula-to-alter-calculation-dependant-on-drop-down-list-value-peters-version-of-tim-recording-sheet
Sheet: Calculations

 |  |  |  |  |  |  |  |  |  | WEEK 1 | <=== Selected Week
 |  |  |  |  |  |  |  |  |  | WORK AREA
 | Monday | Minute |  |  |  |  |  |  |  | WorkArea | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Strip out [NAME] and Spaces | [NAME] to Uppercase | Count the No: of Code you're interested in | Strip out the numbers | Count the number of total codes
 | 6 |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  | 19
 | Tuesday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7 |  |  |  |  |  |  |  |  |  | Day you're Interested in |  |  | Monday
 | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 | 10 |  |  |  |  |  |  |  |  |  | Code you're interested in: |  |  | C25
 | 11 |  |  |  |  |  |  |  |  |  | Time you're interested in: |  |  | 10:00 - 10:59
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | Number of Instances for the Hour |  |  |  |  | Daily Total of all Codes
 | 14 |  |  |  |  |  |  |  |  |  | Number of Instances for the Day
 | 15 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :00
 | 16 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :10
 | 17 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :20
 | 18 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :30
 | 19 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :40
 | Wednesday | Minute |  |  |  |  |  |  |  |  | Number of Instances during: |  | :50
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 783956d1655310609-conditional-formatting-for-dates-and-other-column-data-cond-format
Sheet: Sheet1

 |  |  | [NAME] Here | Conditional format to be applied here |  | Requirement (Sample)
JOB | Balance | Required dt. (RD) |  | Expected completion dt. (ED) |  | After formula is applied | Expected completion dt.
HY-05856 | 5 | 2022-05-10 00:00:00 |  | 2022-06-15 00:00:00 |  | Out | 2022-06-15 00:00:00 | If ED is greater than RD, [NAME]: Red Font
HY-05861 | 2 |  |  |  |  |  |  | If ED and RD is blank, no format to be applied
HY-05959 | 12 | 2022-06-23 00:00:00 |  | 2022-06-22 00:00:00 |  | Next week | 2022-06-22 00:00:00 | If [NAME] is less than RD and RD is in next week (Monday-Sunday), format: Fill Green
HY-05950 | 1 | 2022-06-20 00:00:00 |  | 2022-06-16 00:00:00 |  | Week | 2022-06-16 00:00:00 | If [NAME] is less than RD and RD is in this week (Monday-Sunday) and difference is more than 2 days, format: Fill Orange
[NAME] | 10 | 2022-06-20 00:00:00 |  | 2022-06-18 00:00:00 |  | Immediate | 2022-06-18 00:00:00 | If ED is 0-2 days less than RD, it is critical and format Fill Red.
HY-06250 |  |  |  |  |  |  |  | If Balance is blank, then no matter whatever the dates are, no format to be applied
HY-06202 | 4 | 2022-06-22 00:00:00 |  |  |  |  |  | If ED is blank, no format to be applied
HY-06207 | 15 |  |  | 2022-06-20 00:00:00 |  |  | 2022-06-20 00:00:00 | If RD is blank, no format to be applied
Spreadsheet: 695699d1600351113-count-a-unique-number-based-on-2-other-criteria-s-test
Sheet: Sheet1

68931921 | 405 N/L PLATINUM ATLAS | 13334501 | 2020-09-09 00:00:00 | 15:31:21 | ISS-SO | -240 | 895 | [NAME] | AFIN3538 | 129 | 20001101 |  | Aug
68931920 | 405 COV PLATINUM ATLAS | 13334301 | 2020-09-09 00:00:00 | 15:31:21 | ISS-SO | -160 | 280 | [NAME] | 3538 | 129 | 20001001 |  | Aug
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-15 00:00:00 | 08:39:04 | ISS-SO | -60 | 97 | [NAME] | AFIN | 130 | 30001001 |  | Aug
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-15 00:00:00 | 08:39:04 | ISS-SO | -60 | 100 | [NAME] | AFIN | 130 | 30001001 |  | Aug
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 10:58:51 | ISS-SO | -100 | 137 | [NAME] | AFIN | 136 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 10:58:51 | ISS-SO | -100 | 140 | [NAME] | AFIN | 136 | 30001001 |  | Sep
43023506 | BMW WINDOW ROLLER | 43023506 | 2020-09-16 00:00:00 | 10:59:00 | ISS-SO | -10000 | 156619 | [NAME] | 3602 | 135 | 20001201 |  | Sep
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 10:59:08 | ISS-SO | -60 | 37 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 10:59:08 | ISS-SO | -60 | 40 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 0.457731481 | ISS-SO | -60 | 37 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 0.457731481 | ISS-SO | -60 | 40 | [NAME] | AFIN | 134 | 30001001 |  | Sep
 | SEP
30001001
20001001
20001101
20001201
Spreadsheet: 547925d8-7d0c-48cc-b075-b697f2a272e9
Sheet: FC gene set

Gene | Name
CG17492 | CG17492
CG32096 | rols
CG12908 | CG12908
CG3758 | esg
CG15085 | mae
CG14207 | CG14207
CG13425 | bl
CG3365 | drongo
CG7223 | htl
CG10275 | CG10275
CG7867 | nuf
CG10108 | phyl
CG1921 | sty
CG10250 | nau
CG6531 | wgn
CG8896 | 18w
CG11202 | Org-1
CG12052 | lola
CG3340 | Kr
CG33103 | Papilin
CG8147 | CG8147
CG3839 | l'sc
CG31043 | GUK-h
CG17077 | pnt
CG8965 | CG8965
CG31317 | [NAME]/stumps
CG4722 | bib
CG6113 | CG6113
CG18250 | Dg
CG30344 | CG30344
CG9786 | hb
CG3956 | sna
CG17724 | CG17724
CG6234 | CG6234
CG4444 | px
CG7958 | tna
CG3779 | numb
CG1225 | RhoGEF3
CG3886 | Psc
CG17871 | Or71a
CG31794 | pax
CG10197 | knot
CG1943 | CG1943
CG31151 | CG31151
CG5295 | CG5295
CG4937 | RhoGAP15B
CG3166 | aop
CG3653 | duf/kirre
CG14622 | EG:114D9.2
CG17342 | Lk6
CG1447 | Ptx1
CG9520 | CG9520
CG3619 | Dl
CG3048 | Traf1
CG7004 | fwd
CG2328 | eve
CG4944 | cib
CG32560 | CG32560
CG30344 | CG30344
CG6682 | Rapgap1
CG6534 | S59/slouch
CG8581 | fra
CG8580 | CG8580
CG5522 | CG5522
CG6520 | CG6520
CG15319 | nej
CG7250 | Toll-6
CG8780 | CG8780
CG7892 | nmo
CG17952 | CG17952
CG9461 | CG9461
CG7471 | Rpd3
CG4029 | jumu
CG9952 | ppa
CG10619 | tup
CG11100 | Mes2
CG11280 | trn
CG9398 | [NAME]
CG4125 | rst
CG4531 | argos
CG3780 | Spx
CG3036 | CG3036
CG6464 | salm
CG3385 | nvy
CG6995 | CG6995
CG7392 | Cka
CG10545 | Gbeta13F
CG17943 | comm
CG3936 | N
CG9704 | Nrt
CG2083 | CG2083
CG8597 | lark
CG18402 | InR
CG12249 | [NAME]
CG13789 | CG13789
CG31640 | CG31640
CG8384 | gro
CG7852 | CG7852
CG16738 | slp1
CG4609 | fax
CG8166 | unc-5
CG8715 | CG8715
CG30040 | [NAME]
CG12306 | polo
CG12530 | Cdc42
CG2865 | [NAME]
CG30122 | CG30122
CG1911 | CG1911
CG9135 | CG9135
CG4548 | XNP
CG1311 | CG1311
CG9139 | CG9139
CG7230 | rib
CG14447 | CG14447
CG4747 | BEST:LD22483
CG9797 | CG9797
CG17556 | CG17556
CG11312 | insc
CG6725 | [NAME]
CG31536 | CG31536
CG5405 | KrT95D
CG7109 | mts
[NAME] | [NAME]
CG2218 | CG2218
CG10967 | CG10967
CG5069 | croc
CG4261 | Hel89B
CG2086 | drpr
CG1825 | Map60
CG7187 | CG7187
CG8427 | SmD3
CG12269 | CG12269
CG3606 | caz
CG8651 | trx
CG7269 | Hel25E
CG9554 | [NAME]
CG9191 | Klp61F
CG2512 | alphaTub84D
CG10364 | msb1l
CG5408 | trbl
CG10522 | CG10522
CG8333 | HLHmgamma
CG3938 | CycE
CG11397 | [NAME]
CG17383 | CG17383
CG3800 | CG3800
CG32542 | CG32542
CG18740 | mor
CG2890 | PPP4R2R
dmrt11E | CG15749
CG5235 | CG5235
CG14334 | beat-IIa
CG3258 | ase
CG17046 | klar
CG32434 | siz
CG9985 | sktl
CG30115 | CG30115
CG4707 | CG4707
CG3830 | vg
CG12283 | kek1
CG5723 | Ten-m
CG31369 | CG31369
CG2207 | Df31
CG1849 | runt
cg17228 | pros
CG10388 | Ubx
CG6454 | CG6454
CG8544 | sd
[NAME] | [NAME]
CG17278 | CG17278
CG10504 | Ilk
CG6570 | lbl
CG9876 | CG9876
CG3871 | Six4
CG1132 | fd64A
CG10573 | [NAME]
CG8376 | ap
CG5080 | CG5080
CG6545 | lbe
CG1897 | Dr
Spreadsheet: chris_germany__1916__2001tran12
Sheet: Notes

Note: | Effective 2/1/01
 | [NAME] contract with all receipts and deliveries in Zones 0, 1, & 2.  Only deliveries to [NAME] allowed in Zone 3
 | MDQ= 144,000 dt.
 | See deal 595311
 | 2/1/2001   Transco fuels change effective 4/1/2001 |  |  |  |  |  |  |  |  |  |  | 13973 | 32603
 |  |  | Delivery |  |  |  |  |  |  |  |  | 14904 | 34776
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | 9559 | 22304
 |  | Receipt |  |  |  |  |  |  |  |  |  | 14850 | 34650
 |  | 1 | 0.0036 | 0.0082 | 0.0127 | 0.032 | 0.0475 | 0.056 |  |  |  | 29700 | 69300
 |  |  |  |  |  |  |  |  |  |  |  | 6282 | 14658
 |  | 2 |  | 0.0046 | 0.0091 | 0.0284 | 0.0439 | 0.0524 |  |  |  | 89 | 209
 |  | 3 |  |  | 0.0045 | 0.0238 | 0.0393 | 0.0478
 |  | 4 |  |  |  | 0.0193 | 0.0348 | 0.0433
 |  | 5 |  |  |  |  | 0.0155 | 0.024
 |  | 6 |  |  |  |  |  | 0.0085
 |  | Zone 4A to Zone 4A = .59%
Spreadsheet: 3315718e-2a6a-4949-9e83-11f942df58cf
Sheet: Template Landscape Calendar 

 | Titan Transit 2013-2014
 |  | = | Late Night Only |  |  |  |  |  |  | = | [NAME] |  |  |  |  |  |  | = | Late Night and Evening
 | JULY 2013 |  |  |  |  |  |  |  | AUGUST 2013 |  |  |  |  |  |  |  | SEPTEMBER 2013
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | OCTOBER 2013 |  |  |  |  |  |  |  | NOVEMBER 2013 |  |  |  |  |  |  |  | DECEMBER 2013
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | JANUARY 2014 |  |  |  |  |  |  |  | FEBRUARY 2014 |  |  |  |  |  |  |  | MARCH 2014
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | APRIL 2014 |  |  |  |  |  |  |  | MAY 2014 |  |  |  |  |  |  |  | JUNE 2014
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 594265d1539675452-populate-cell-based-on-previous-cells-formula-kopa_samsu
Sheet: Sheet1

DATA EXAMPLE #1 |  |  |  |  |  |  |  |  |  | TABLE 1 |  |  |  | TABLE 2
 |  |  |  |  |  |  |  |  |  | 1 | 11 | 111 |  | A | AA | AAA
 |  |  |  |  |  |  |  |  |  | 2 | 22 | 222 |  | B | BB | BBB
 |  |  |  |  |  |  |  |  |  | 3 | 33 | 333 |  | C | CC | CCC
 |  |  |  |  |  |  |  |  |  | 4 | 44 | 444 |  | D | DD | DDD
 |  |  |  |  |  |  |  |  |  | 5 | 55 | 555 |  | E | EE | EEE
 |  |  |  |  |  |  |  |  |  | 6 | 66 | 666 |  | F | FF | FFF
 |  |  |  |  |  |  |  |  |  | 7 | 77 | 777 |  | G | GG | GGG
 |  |  |  |  |  |  |  |  |  | 8 | 88 | 888 |  | H | HH | HHH
 |  |  |  |  |  |  |  |  |  | 9 | 99 | 999 |  | I | II | III
DATA EXAMPLE #2
DATA EXAMPLE #2
Spreadsheet: 737388d1624388329-calculating-running-average-cost-example_avg_cost-1-2-
Sheet: Sheet2_version2

Limits:
Trade Symbol | Transaction | Date | [NAME] | Quantity | Price | Total Cost | Buy Fees | Sell Fees |  | Running Qty | [NAME] | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L
 | Buy | 2021-02-22 00:00:00 |  | 3.514923 | 14.21 |  | 0 | 0
 |  |  |  | 1.95554 | 12.8 |  | 0 | 0
 | Buy | 2021-02-23 00:00:00 |  | 2.121327 | 11.78 |  | 0 | 0
 | Buy | 2021-03-24 00:00:00 |  | 374.242645 | 13.45 |  | 0 | 0
 | Sell | 2021-03-29 00:00:00 | Short | -381.834442 | 13.34 |  | 0 | 0
 | Buy | 2021-04-17 00:00:00 |  | 13.380624 | 37.72 |  | 0 | 0
 |  |  |  | 12.706329 | 39.39 |  | 0 | 0
 | Buy | 2021-04-27 00:00:00 |  | 28.600846 | 35.18 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 74.626678 | 67.52 |  | 0 | 0
 |  |  |  | 270.208195 | 74.56 |  | 0 | 0
 | Sell | 2021-05-04 00:00:00 | Short | -399.522672 | 78.52 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 179.734944 | 84.04 |  | 0 | 0
 |  | 2021-05-05 00:00:00 |  | 49.622456 | 101.4 |  | 0 | 0
 |  |  |  | 246.20782 | 102.55 |  | 0 | 0
 |  |  |  | 165.37101 | 103.4 |  | 0 | 0
 | Sell | 2021-05-05 00:00:00 | Short | -640.93623 | 104.18 |  | 0 | 0
 | Buy | 2021-05-05 00:00:00 |  | 30.301633 | 99.03 |  | 0 | 0
 |  | 2021-05-06 00:00:00 |  | 276.819944 | 145.41 |  | 0 | 0
 | Sell | 2021-05-06 00:00:00 | Short | -307.121577 | 168.49 |  | 0 | 0
 | Buy | 2021-05-06 00:00:00 |  | 277.1079 | 182.23 |  | 0 | 0
 |  |  |  | 138.149505 | 182.77 |  | 0 | 0
 | Sell | 2021-05-08 00:00:00 | Short | -107.381606 | 127.43 |  | 0 | 0
Totals:
Spreadsheet: 267359d1380052781-index-match-vlookup-if-then-help-example
Sheet: Sheet1

Pet | Type | Cost
Spot | Dog | 150
Rover | Dog | 250
[NAME] | Cat | 5
Reuben | Dog | 50
Mr. Pig | Dog | 0
[NAME] | Cat | 68
Buttons | Dog | 0
Spreadsheet: 62bf08eb-0848-4daa-bd01-2b348e256138
Sheet: Summary

Summary Sheet
 | Service 1 | Service 2
ANNUAL COSTS
Salaries and [NAME]
Travel
Operating Costs
Equipment < $5,000
Capital equipment depreciation
TOTAL ANNUAL COSTS
% of Total Costs
Prior Year Balance (Add Deficit, Subtract Surplus)
Estimated 2 months working capital
TOTAL REVISED COSTS
# of Annual Units
Unit Base
CALCULATED RATE PER SERVICE PER UNIT
UNIT RATE THAT WILL BE CHARGED TO CUSTOMERS | 0 | 0
SUBSIDY
Subsidized Rate
Spreadsheet: 724601d1616254206-dynamic-graph-with-dropdown-date-list-only-works-with-one-value-range-pivot-table-with-slicer-gijs-
Sheet: Sheet1

Date | Sum of Current | Sum of DJIA
2015-12-31 00:00:00 | 42654.13 | 85068.45
2016-03-31 00:00:00 | 128802.56 | 82697.69
2016-06-30 00:00:00 | 125210.02 | 81378.65
2016-09-30 00:00:00 | 125322.47 | 84081.78
2016-12-31 00:00:00 | 126480 | 79076
2017-03-31 00:00:00 | 127067.05 | 86547.22
2017-06-30 00:00:00 | 124569.86 | 94573.42
2017-09-30 00:00:00 | 125181.8 | 99603.23
2017-12-31 00:00:00 | 126657.67 | 100986.58
2018-03-31 00:00:00 | 128130 | 99523.15
Grand Total | 1180075.56 | 893536.17
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Sheet4

 |  | # | Player | Club
 |  | 1 | [NAME] | Manchester City
 |  | 2 | Destiny [NAME] | [NAME]
 |  | 3 | [NAME] [NAME] | Arsenal FC
 |  | 4 | [NAME] | Liverpool FC
 |  | 5 | Pervis Estupiñán | Brighton & Hove Albion
 |  | 6 | [NAME] | [NAME]
 |  | 7 | [NAME] | [NAME]
 |  | 8 | [NAME] | Chelsea FC
 |  | 9 | [NAME] | [NAME]
 |  | 10 | [NAME] | Chelsea FC
 |  | 11 | [NAME] | [NAME]
 |  | 12 | [NAME] | Arsenal FC
 |  | 13 | [NAME] | Crystal Palace
 |  | 14 | Konstantinos Tsimikas | Liverpool FC
 |  | 15 | Antonee Robinson | Fulham FC
 |  | 16 | [NAME] | AFC Bournemouth
 |  | 17 | [NAME] | Newcastle United
 |  | 18 | [NAME] | [NAME]
 |  | 19 | Nuno Tavares | [NAME]
 |  | 20 | [NAME] | Brighton & Hove Albion
 |  | 21 | [NAME] | [NAME]
 |  | 22 | [NAME] | [NAME]
 |  | 23 | Lucas Digne | [NAME]
 |  | 24 | Emerson | West Ham United
 |  | 25 | [NAME] | Newcastle United
 |  | 26 | [NAME] | [NAME]
 |  | 27 | [NAME] | Manchester City
 |  | 28 | [NAME] | Newcastle United
 |  | 29 | [NAME] | [NAME]
 |  | 30 | [NAME] | [NAME]
 |  | 31 | [NAME] | Sheffield United
 |  | 32 | [NAME] | Burnley FC
 |  | 33 | [NAME] | Fulham FC
 |  | 34 | [NAME] | Sheffield United
 |  | 35 | Amari'i Bell | [NAME]
 |  | 36 | [NAME] | Sheffield United
 |  | 37 | [NAME] | [NAME]
 |  | 38 | [NAME] | West Ham United
 |  | 39 | [NAME] | [NAME]
 |  |  | # | Player | Club
 |  |  | 1 | Trent [NAME] | Liverpool FC
 |  |  | 2 | [NAME] | Arsenal FC
 |  |  | 3 | [NAME] | Chelsea FC
 |  |  | 4 | [NAME] | [NAME]
 |  |  | 5 | [NAME] | Manchester City
 |  |  | 6 | Tino Livramento | Newcastle United
 |  |  | 7 | [NAME] | [NAME]
 |  |  | 8 | [NAME] | Chelsea FC
 |  |  | 9 | [NAME] | Arsenal FC
 |  |  | 10 | [NAME] | [NAME]
 |  |  | 11 | [NAME] | [NAME]
 |  |  | 12 | [NAME] | [NAME]
 |  |  | 13 | [NAME] | AFC Bournemouth
 |  |  | 14 | Emerson Royal | [NAME]
 |  |  | 15 | [NAME] | Fulham FC
 |  |  | 16 | [NAME] | [NAME]
 |  |  | 17 | [NAME] | Fulham FC
 |  |  | 18 | [NAME] | Crystal Palace
 |  |  | 19 | Conor Bradley | Liverpool FC
 |  |  | 20 | [NAME] | [NAME]
 |  |  | 21 | [NAME] | Manchester City
 |  |  | 22 | [NAME] | Brighton & Hove Albion
 |  |  | 23 | [NAME] | [NAME]
 |  |  | 24 | [NAME] | Newcastle United
 |  |  | 25 | [NAME] | Brighton & Hove Albion
 |  |  | # | Player | Club
 |  |  | 26 | [NAME] | [NAME]
 |  |  | 27 | [NAME] | [NAME]
 |  |  | 28 | [NAME] | Burnley FC
 |  |  | 29 | [NAME] | [NAME]
 |  |  | 30 | [NAME] | West Ham United
 |  |  | 31 | [NAME] | West Ham United
 |  |  | 32 | [NAME] | [NAME]
 |  |  | 33 | Vitinho | Burnley FC
 |  |  | 34 | [NAME] | [NAME]
 |  |  | 35 | Jayden Bogle | Sheffield United
 |  |  | 36 | [NAME] | Sheffield United
 |  |  | 37 | [NAME] | Newcastle United
 |  |  | 38 | [NAME] | [NAME]
 |  |  | 39 | [NAME] | Arsenal FC
 |  |  | 40 | Daiki Hashioka | [NAME]
 |  |  | 41 | [NAME] | Crystal Palace
 |  |  | 42 | [NAME] | AFC Bournemouth
 |  |  | 43 | [NAME] | AFC Bournemouth
 |  |  | 44 | [NAME] | Crystal Palace
 |  |  | 45 | [NAME] | [NAME]