tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57674d1257886199-automatically-make-new-tables-doctor_a-2-
Sheet: Total books

 |  | Nr. Boekjes | Datum | Bedrag
 |  | 09*0102 | 2009-12-01 00:00:00 | 95
 |  | 09*0103 | 2009-12-02 00:00:00 | 100
 |  | 09*0104 |  | 100
 |  | 09*0105
 |  | 09*0106
 |  | 09*0107
 |  | 09*0108
 |  | 09*0109
 |  | 09*0110
 |  | 09*0111
 |  | 09*0112
 |  | 09*0113
 |  | 09*0114
 |  | 09*0115
 |  | 09*0116
 |  | 09*0117
 |  | 09*0118
 |  | 09*0119
 |  | 09*0120
 |  | 09*0121
 |  | 09*0122
 |  | 09*0123
 |  | 09*0124
 |  | 09*0125
 |  | 09*0126
 |  | 09*0127
 |  | 09*0128
 |  | 09*0129
 |  | 09*0130
 |  | 09*0131
 |  | 09*0132
 |  | 09*0133
 |  | 09*0134
 |  | 09*0135
 |  | 09*0136
 |  | 09*0137
 |  | 09*0138
 |  | 09*0139
 |  | 09*0140
 |  | 09*0141
 |  | 09*0142
 |  | 09*0143
 |  | 09*0144
 |  | 09*0145
 |  | 09*0146
 |  | 09*0147
 |  | 09*0148
 |  | 09*0149
 |  | 09*0150
 |  | 09*0151
 |  | 09*0152
 |  | 09*0153
 |  | 09*0154
 |  | 09*0155
 |  | 09*0156
 |  | 09*0157
 |  | 09*0158
 |  | 09*0159
 |  | 09*0160
 |  | 09*0161
 |  | 09*0162
 |  | 09*0163
 |  | 09*0164
 |  | 09*0165
 |  | 09*0166
 |  | 09*0167
 |  | 09*0168
 |  | 09*0169
 |  | 09*0170
 |  | 09*0171
 |  | 09*0172
 |  | 09*0173
 |  | 09*0174
 |  | 09*0175
 |  | 09*0176
 |  | 09*0177
 |  | 09*0178
 |  | 09*0179
 |  | 09*0180
 |  | 09*0181
 |  | 09*0182
 |  | 09*0183
 |  | 09*0184
 |  | 09*0185
 |  | 09*0186
 |  | 09*0187
 |  | 09*0188
 |  | 09*0189
 |  | 09*0190
 |  | 09*0191
 |  | 09*0192
 |  | 09*0193
 |  | 09*0194
 |  | 09*0195
 |  | 09*0196
 |  | 09*0197
 |  | 09*0198
 |  | 09*0199
 |  | 09*0200
 |  |  |  | 295
Spreadsheet: 0d49979c-2b71-463f-bd93-709d88d90f0e
Sheet: CPI-based on June12

 |  |  |  |  |  |  |  |  |  |  |  | Revised Referendum Cap Inflation Estimates
 |  |  |  |  |  |  |  |  |  |  |  | FY 2005 - FY 2021
CPI - Urban Consumers
June 2012 Update
With new formula allowances and finalized FY 2011 data
Source of CPI Data: DOF- [NAME]
Date: July 17, 2012
 |  |  | CALENDAR | CALENDAR | CALENDAR | CALENDAR | FISCAL | RATE OF | CUMMULATIVE
 |  |  | QUARTER | QUARTER | QUARTER | QUARTER | YEAR | INCREASE | RATE OF
 |  |  | 1 | 2 | 3 | 4 | AVERAGE |  | INCREASE
 |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G
 |  |  |  |  |  |  | (PYQ3+PYQ4+CYQ1+CYQ2)/4 |  |  |  |  | Projected |  | Projected |  | [NAME]. [NAME] | Projected
 |  |  |  |  |  |  |  | (CY AVG/PY AVG)-1 |  |  | Annual | Inflation | [NAME] | Inflation | Projected | Increase | Inflation
Fiscal |  | Calendar | 1st | 2nd | 3rd | 4th |  |  | (CY % / BASE YR %) |  | Projected | Ratio | Allow Based | Based | [NAME]. [NAME] | over | Ratio
Year |  | Year |  |  |  |  |  |  |  |  | Inflation | [NAME]. [NAME] | [NAME]. [NAME] | [NAME]. [NAME] | Gtr of C or D | FY 2004 | Alt. [NAME]*
2003 |  | 2003
 |  | 2004
 |  | 2005 |  |  |  |  |  |  |  |  | 0.0301 | 1.0301
 |  | 2006 |  |  |  |  |  |  |  |  | 0.0381 | 1.0693
 |  | 2007 |  |  |  |  |  |  |  |  | 0.0261 | 1.0973
 |  | 2008 |  |  |  |  |  |  |  |  | 0.0367 | 1.1376
 |  |  |  |  |  |  |  |  |  |  | 0.0142 | 1.1537
 |  |  |  |  |  |  |  |  |  |  | 0.0093 | 1.1644
 |  |  |  |  |  |  |  |  |  |  | 0.0203 | 1.1881
 |  |  |  |  |  |  |  |  |  |  | 0.0294 | 1.223
 | e
2014 | e | 2014
2015 | e | 2015
2016 | e | 2016
2017 | e | 2017
2018 | e | 2018
2019 | e | 2019
2020 | e | 2020
2021 | e | 2021
Notes:
1.  [NAME] no increase in formula allowance after FY 2013 as per current law.
2.  Finalized calculation through FY 2012 based on actual Bureau of Labor Statistics data.
Spreadsheet: 291835d1390417169-automatically-copy-a-row-of-data-from-one-sheet-to-another-routsheet
Sheet: 211

RO# | OWNERS NAME | TAG | ADVISOR | [NAME] OF WORK | PROMISE TIME | 10 | 12 | 2 | 4 | DISPATCH TIME
75042 | CRAMLET | 874 | 1044 | LPI | EOD
75034 | CARMAX | 669 | 1026 | TPMS | EOD
74998 | PLOW | 383 | 1052 | FILLER TUBE | EOD
75047 | VANDUYN | 876 | 1044 | NOISE | EOD
Spreadsheet: 862930d1710497618-inventory-control-system-tracking-average-price-example-stock-control-file
Sheet: End Dec 23

 | Silver Obsession stock control.  Initial stock received as per [NAME] and Watson Invoice 22/12/2021
 | Product picture | SKU | Stock Quantity | Invoice No stock purchase | Amount per unit THB | Invoice amount per product | Stock sold | Invoice number sales | New Stock Level | Ongoing Inventory Calculation THB | Current Inventory
1
 |  | 11111 | 10 | INV2021120113 22-Dec-2021 |  | 1172.73 | 5 | 2022-00004 28/05/2022
 |  |  | 5 | INV2022080018 3-Aug-2022 |  | 645.4 | 0 |  | 10
 |  |  | 6 | INV2023100127 31-Oct-23 |  | 731.29 | 6 | 2023-00015 AL 25/8/23 | 10 |  | 1218.81
2
 |  | 22222 | 10 | INV2021120113 22-Dec-2021 |  | 1665.02 | 0 |  | 10
 |  |  | 10 | INV2023020107 27-Feb-23 |  | 1658.3 | 10 | 2023-00001 MB 4/2/23 | 10
 |  |  | 5 | INV2023020107 27-Feb-23 |  | 790.75 | 5 | 2023-00002 DB 9/2/23 | 10
 |  |  | 5 | INV2023040084 28-Apr-23 |  | 826.86 | 15 | 2023-00005 DB 31/03/23 | 0 | 0 | 0
 |  |  | 15 | INV2023070109 31-Jul-23 |  | 2495.58 | 15 | 2023-00011 DB 30/6/23 | 0 | 0 | 0
3
 |  | 33333 | 10 | INV2021120113 22-Dec-2022 |  | 1170.29 | 0 |  | 10
 |  |  |  |  | 117.029 |  | 5 | 2023-00008 GZ 10/5/23 | 5 |  | 585.145
4
 |  | 44444 | 10 | INV2021120113 22-Dec-2022 | 173.104 |  | 0 |  | 10 |  | 1731.04
Spreadsheet: 840205d1692552302-countifs-word-or-another-word-but-not-in-same-cell-countifs-word-or-another-word-but-not-in-same-cell-solution-
Sheet: Sheet1

100 | this man is Good |  |  |  | 100
200 | this man is [NAME] |  |  |  | 200
300 | this man is [NAME] and Bad |  |  |  | 300 |  |  | I want make it count if any of these word exist but not in same cell so code 300 should counted 2 not 4
400 | this man is Good |  |  |  | 400
500 | this man is Good |  |  |  | 500
100 | this man is Good
200 | this man is [NAME]
300 | this man is [NAME]
400 | this man is Good
500 | this man is Good
Spreadsheet: 267538d1380106601-help-with-lookup-formulae-please-riders
Sheet: Expert_Opt1

Name | Last Name | Club | Class | No
 |  |  |  | 24 | Conditional Format
 |  |  |  |  | INSERT ONLY "EXPERT'' NUMBERS IN ORDER FROM THE RIDERS LIST WORKSHEET
Spreadsheet: 64644d1265434952-quickest-way-to-summarize-random-data-equipment
Sheet: Data

Phase | Date | Equipment | Cost/Day
4-7202-E | 2010-01-04 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-05 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-06 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-07 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-08 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-11 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-12 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-13 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-14 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-15 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-18 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-19 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-20 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-21 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-22 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-25 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-26 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-27 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-28 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-29 00:00:00 | J091763N-SUS | 120
4-7202-E | 2010-01-04 00:00:00 | J091758E | 120
4-7202-E | 2010-01-05 00:00:00 | J091758E | 120
4-7202-E | 2010-01-06 00:00:00 | J091758E | 120
4-7202-E | 2010-01-07 00:00:00 | J091758E | 120
4-7202-E | 2010-01-08 00:00:00 | J091758E | 120
4-7202-E | 2010-01-11 00:00:00 | J091758E | 120
4-7202-E | 2010-01-12 00:00:00 | J091758E | 120
4-7202-E | 2010-01-13 00:00:00 | J091758E | 120
4-7202-E | 2010-01-14 00:00:00 | J091758E | 120
4-7202-E | 2010-01-15 00:00:00 | J091758E | 120
4-7202-E | 2010-01-18 00:00:00 | J091758E | 120
4-7202-E | 2010-01-19 00:00:00 | J091758E | 120
4-7202-E | 2010-01-20 00:00:00 | J091758E | 120
4-7202-E | 2010-01-21 00:00:00 | J091758E | 120
4-7202-E | 2010-01-22 00:00:00 | J091758E | 120
4-7202-E | 2010-01-25 00:00:00 | J091758E | 120
4-7202-E | 2010-01-26 00:00:00 | J091758E | 120
4-7202-E | 2010-01-27 00:00:00 | J091758E | 120
4-7202-E | 2010-01-28 00:00:00 | J091758E | 120
4-7202-E | 2010-01-29 00:00:00 | J091758E | 120
Spreadsheet: benjamin_rogers__1294__Caledonia
Sheet: Debt Amortization

Debt Amortization
 |  |  |  | 0.5
EBITDA
DSCR - Tranche A
DSCR - Tranche B
DSCR - Tranche C
Interest Rate For Period, Tranche A
Interest Rate For Period, Tranche B
Interest Rate For Period, Tranche C
Total Annual CFAFDS
NPV of CFAFDS Tranche A
NPV of CFAFDS Tranche B
NPV of CFAFDS Tranche C
NPV of Total CFAFDS
Tranche A
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche B
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche C
Beginning Balance | `
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
TOTAL ANNUAL DEBT AMORTIZATION
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Check
Actual Debt Coverage Ratio
Error catch line
TRANCHE 1
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 2
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 3
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Tranche A
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0 | 0 | 0.02 | 0.02 | 0.03 | 0.03 | 0.03 | 0.04 | 0.04 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.12 | 0.15 | 0.17 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Ameed

 |  | Total Revenue
 |  | Anesthesia | 0
 |  | Dental Lab
 |  | Net Revenue
 |  | Dr. Percentage 50%
 |  | Total Lab | 0
 |  | Lab Cost | 0
 |  | Net Lab
 |  | Dr. Percentage 10%
 |  | Net Payment
 |  | Salary | 0
 |  | Monthly Housing Allowance | 0
 |  | Net To Pay
 |  |  | Doctor [NAME] ……………
Spreadsheet: b4ba81d2-ec92-48b7-9df0-47e5a9decdae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | BUND DEUTSCHER RADFAHRER e. V. | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  | Amtliche Nennung des |  |  |  |  |  |  |  |  | zur Teilnahme bei
 |  |  |  | (Name des Vereins)
 |  | am |  |  | in |  |  |  |  |  |  | lt. Ausschreibung im "Radsport" Nr. |  | vom
[NAME]. | Zu- und [NAME] |  |  |  |  | Geburtsdatum | Lizenznummer |  | UCI-Code 2) |  | Klasse | Team/Sponsor 3) | [NAME]) |  | Nenngeld
Nr. 1)
Nenngeld in Höhe von 5) |  |  |  |  |  |  |  |  |  |  |  |  | (Zutreffendes ist anzuklicken!)
Es wird ausdrücklich bestätigt, dass alle Fahrer ihr Einverständnis zur Meldung gegeben haben, für den meldenden Verein startberechtigt, im [NAME] einer gültigen Lizenz und Amateure im [NAME] des BDR sind, dessen [NAME]
[NAME].
 |  |  |  |  |  | ,den
 |  |  |  |  |  |  |  |  |  |  |  | Bitte beachten:
1) | Feld wird [NAME], wenn der Name der Fahrerin/des Fahrers
 | eingegeben wird, also hier nichts eingeben!
2) | UCI-Code setzt sich wie folgt zusammen: Nation ([NAME] für Deutschland) + |  |  |  |  |  |  |  |  |  |  | Nach Einsendung der [NAME] an uns erhalten Sie keine weitere
 | Geburtsjahr(4-stellig) + Geburtsmonat (2-stellig) + Geburtstag (2-stellig), |  |  |  |  |  |  |  |  |  |  | Bestätigung. Sie finden sich zum angemeldeten [NAME] ein, wie es
 | [NAME] 19660508 für das Geburtsdatum 08.05.1966 |  |  |  |  |  |  |  |  |  |  | [NAME], Tag und Zeit in der [NAME] angegeben ist.
3) | Bundesliga-Team (bei Bundesliga-Wertung) bzw. Sponsor (bei MTB-Rennen) |  |  |  |  |  |  |  |  |  |  | Wir empfehlen Ihnen daher, eine Kopie der [NAME] mit Sendebe-
4) | [NAME] der [NAME] (bei [NAME]), [NAME] (bei [NAME]) |  |  |  |  |  |  |  |  |  |  | richt bzw. E-Mail-Ausdruck mit Absendedatum zur Veranstaltung
5) | [NAME] wird [NAME], also hier nichts eingeben! |  |  |  |  |  |  | Stempel  und Unterschrift des Vereins |  |  |  | mitzubringen um die rechtzeitige [NAME].
Spreadsheet: 854282d1704212929-excel-subtotal-feature-handling-duplicate-barcodes-excelforum-afternoon
Sheet: Applying subtotal in data Tab 

barcode | quantity
6201-02-20 | 5
6201-02-20 Total
4170-06-01 | 4
4170-06-01 Total
4202-02-04 | 5
4202-02-04 Total
4202-03-02 | 5
4202-03-02 Total
4202-03-04 | 6
4202-03-04 Total
4202-03-05 | 3
4202-03-05 Total
4202-03-21 | 5
4202-03-21 Total
4202-04-01 | 1
4202-04-01 Total
4202-04-02 | 10
4202-04-02 Total
4202-04-05 | 6
4202-04-05 Total
4202-04-21 | 5
4202-04-21 Total
4202-05-02 | 5
4202-05-02 Total
4202-05-04 | 5
4202-05-04 Total
4202-05-21 | 1
4202-05-21 Total
4202-06-01 | 10
4202-06-01 Total
4202-06-02 | 2
4202-06-02 Total
4202-06-04 | 3
4202-06-04 Total
4202-06-05 | 1
4202-06-05 Total
4202-06-21 | 6
4202-06-21 Total
4202-06-21 | 1
4202-06-21 Total
4202-07-02 | 5
4202-07-02 Total
4202-07-05 | 1
4202-07-05 Total
4202-07-21 | 3
4202-07-21 Total
4202-08-04 | 6
4202-08-04 Total
4591-06-03 | 7
4591-06-03 Total
4591-07-21 | 2
4591-07-21 Total
6201-03-20 | 5
6201-03-20 Total
6201-04-20 | 3
6201-04-20 Total
6201-05-20 | 8
6201-05-20 Total
Grand Total
Spreadsheet: 132402d1323728594-pick-out-the-min-max-in-a-running-lists-and-if-index
Sheet: Sheet1

 |  |  |  |  | result
1847 | -3.38401 | -98.18226 |  |  | 1856 | -3.40283 | -125.94379
1848 | -3.38451 | -91.28931 |  |  | 1868 | -3.4245 | -129.32533
1849 | -3.38517 | -84.80958
1850 | -3.39 | -90.98323
1851 | -3.39183 | -96.88142
1852 | -3.39399 | -102.70217
1853 | -3.39633 | -108.7611
1854 | -3.3985 | -114.54858
1855 | -3.40066 | -120.31826
1856 | -3.40283 | -125.94379 | 11
1857 | -3.40467 | -118.2516
1858 | -3.40517 | -110.03141
1859 | -3.40567 | -101.9672
1860 | -3.40617 | -95.01661
1861 | -3.40684 | -88.25921
1862 | -3.41183 | -94.05978
1863 | -3.41366 | -99.88268
1864 | -3.41583 | -105.72916
1865 | -3.41799 | -111.50193
1866 | -3.42016 | -117.43785
1867 | -3.42233 | -123.41609
1868 | -3.4245 | -129.32533 | 23
1869 | -3.42717 | -120.90909
1870 | -3.42751 | -114.71156
1871 | -3.42784 | -108.49783
1872 | -3.42818 | -102.66275
Spreadsheet: 53827d1253750762-variable-number-format-before-value-entered-variable-number-format-without-value
Sheet: NES List

Column1 | Column2 | Column3
INS | 10 | ####0.00
RES | 3 | ####0.00
SIL | 0.1 | ####0.00
ASB | 0.1 | ####0.00
-MN | 1 | ####0.00
WLD | 5 | ####0.00
DP | 0.08 | ####0.00
-AS | 0.05 | ####0.00
-CD | 0.01 | ####0.0000
CRM | 0.05 | ####0.00
CUF | 0.2 | ####0.00
-PB | 0.15 | ####0.00
-HG | 0.025 | ####0.000
Tol | 100 | ####0.0
Tri | 50 | ####0.0
NH3 | 25 | ####0.0
MEK | 150 | ####0.0
-NI | 1 | ####0.00
-ZN | 5 | ####0.00
Spreadsheet: 705275d1605983912-start-a-ranked-list-from-a-value-other-than-1-sample-workbook
Sheet: Sheet1

 | Applied formula working correctly from D8:D17
 |  | YEAR 1
 | Stock No. | Sale Date/Time | Invoice No.
 | 1 | 2019-11-03 15:00:00
 | 2 | 2019-11-01 13:00:00
 | 3
 | 4 | 2019-11-10 10:00:00
 | 5
 | 6
 | 7 | 2019-11-10 15:00:00
 | 8 | 2019-11-05 17:00:00
 | 9
 | 10 | 2019-11-15 12:00:00
 | Now applying the same formula as above in Year 2 below, however showing incorrect invoice numbers from D26:D35
 |  | YEAR 2
 | Stock No. | Sale Date/Time | Invoice No.
 | 3 | 2020-01-01 00:00:00
 | 5
 | 6 | 2020-01-10 00:00:00
 | 9
 | 11 | 2020-01-05 00:00:00
 | 12
 | 13
 | 14
 | 15 | 2020-01-15 00:00:00
 | 16
 | What I would like Year 2 to represent with the correct invoice number from D44:D53
 |  | YEAR 2
 | Stock No. | Sale Date/Time | Invoice No.
 | 3 | 2020-01-01 00:00:00 | 7
 | 5
 | 6 | 2020-01-10 00:00:00 | 9
 | 9
 | 11 | 2020-01-05 00:00:00 | 8
 | 12
 | 13
 | 14
 | 15 | 2020-01-15 00:00:00 | 10
 | 16
Spreadsheet: 717056d1612460464-check-if-a-weekly-time-interval-falls-within-one-of-several-weekly-time-intervals-in-table-check-if-a-weekly-time-interval-falls-within-one-of-several-weekly-time-intervals-in-table
Sheet: Time interval

Day from | Time from | Day to | Time to
Wednesday | 04:30:00 | Wednesday | 05:00:00
Day from | Time from | Day to | Time to
Monday | 00:00:00 | Monday | 07:00:00
Monday | 23:00:00 | Tuesday | 00:00:00
Tuesday | 00:00:00 | Tuesday | 07:00:00
Tuesday | 23:00:00 | Wednesday | 00:00:00
Wednesday | 00:00:00 | Wednesday | 07:00:00
Wednesday | 23:00:00 | Thursday | 00:00:00
Thursday | 00:00:00 | Thursday | 07:00:00
Thursday | 23:00:00 | Friday | 00:00:00
Friday | 00:00:00 | Friday | 07:00:00
Friday | 15:00:00 | Saturday | 00:00:00
Saturday | 00:00:00 | Sunday | 00:00:00
Sunday | 00:00:00 | Monday | 00:00:00
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: Final Euro 2020

⚽Updated scores⚽
Italy 🍕 🆚 England 🏴󠁧󠁢󠁥󠁮󠁧󠁿
⚽8pm kick-off⚽
〰〰〰〰〰〰〰〰〰
⚽ Amin A: 1-4
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Arif J: 1-2
⚽ Din: 2-3
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Hanif E: 1-1
[NAME]: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Mehboob: N-S
⚽ Mohamed: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Muizz: 1-2
⚽ [NAME]: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Rahim V: 1-2
⚽ Rayyan: 0-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Sahir: 1-2
⚽ Salim: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Salman: 1-1
[NAME]: 1-3
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Shafiq: 1-2
[NAME]: 1-0
[NAME]: 1-2
Spreadsheet: 213473d1360533530-formula-to-return-an-offset-value-depending-on-a-condition-report
Sheet: Write Term Report

 | Writing Progress Term Assessment |  |  |  |  | Year.6 |  |  | [NAME] |  |  |  | 2013-02-10 00:00:00
 |  | Autumn Term |  |  | [NAME] |  |  | [NAME]
 | Name | T1 | T1 | Levels | T2 | T2 | Levels | T3 | T3 | Levels |  | YTD | Comments
 |  | Start | Finish | Moved | Start | Finish | Moved | Start | Finish | Moved |  | Levels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do Not Remove |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wc | 1 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wb | 2 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wa | 3 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b | 5 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1a | 6 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2c | 7 | 15 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2b | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2a | 9 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3c | 10 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3b | 11 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3a | 12 | 20 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4c | 13 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4b | 14 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4a | 15 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5c | 16 | 24 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5b | 17 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5a | 18 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  | 2c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
Spreadsheet: 128650d1321155940-excel-2007-data-filter-filter
Sheet: Table1

Code | Inventory
111 | 30
112 | 20
113 | 102
114 | 424
115 | 5
116 | 6
117 | 34
118 | 235
119 | 436
120 | 332
121 | 43
122 | 34
123 | 67
124 | 45
125 | 363
126 | 3
127 | 23
128 | 364
129 | 7
130 | 37
111 | 7
112 | 47
113 | 3
134 | 7
135 | 7
136 | 73
137
138 | 32
139
Spreadsheet: 171194d1343657482-vlookup-index-match-for-forum
Sheet: new template

 |  | Site Name |  |  | Region |  |  | Touring Pitches
 |  | Blackpool South Caravan Club Site
 |  | Business Partners |  | Site Bookings |  | Avg Bookings per BP |  | Number of Nights |  | Avg Number of Nights |  | [NAME] |  | [NAME] of BP
 | 2010
 | 2011
 | % Diff
 | I am trying to populate the area in yellow with the data from Tab Visitor Stats as seen above C20:O20
 | The aim is that the user chooses a site from the drop down in C13 and this populates itself.
 | =VLOOKUP(_2011&_SN,tblData2,7,FALSE) I have used a [NAME] but had to change the column bith manually. I tried to use COLUMNS(ARRAY) bur this kept returning data from the first row of the table.
 | Therefore, I have two questions:
 | 1) how would i use Columns(array) in this case to save myself manually changing it
 | 2) is there a better way of achivieng my desired result? Maybe with index match
 | Many thanks
Spreadsheet: 841129d1693384822-how-to-calculate-networkdays-intl-excel-form-leave-record
Sheet: Leave Record 2023

Employee | Leave Type | Start Date | Day of Start | End Date | Day of End | Total Days | Holiday | Adjustment | Final Total Days | Remarks |  | Holiday
[NAME] | AL | 2023-04-26 09:00:00 |  | 2023-05-12 18:00:00 |  |  |  |  | 12 | labor day ? |  | 0
[NAME] | AL | 2023-09-21 14:00:00 |  | 2023-10-02 18:00:00 |  |  |  |  | 5.5 | Autumn? |  | 0
[NAME] | AL | 2023-09-22 09:00:00 |  | 2023-10-06 18:00:00 |  |  |  |  | 10 | labor day ? |  | 1
Total
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 0009
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Chicago
Northeast | 0 |  | 0 |  | 0 | 0
East-EGM
East-MKT East
East-LRC
FT-East
Transport
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
FT - Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 3002839
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 9a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 7433349 | 15693580 | 23126929
 | FRA | 32112025 | 23956884 | 56068910
 | Exotic |  | 3533055 | 3533055
 | Inflation |  | 2534967 | 2534967
 | IRS- [NAME] | 112253061 | 101048629 | 213301690
 | OIS | 19958587 | 18433433 | 38392020
 | VNS | <10,000 |  | <10,000
 | Zero Coupon | 175579 |  | 175579
With Optionality | Callable Swap |  | 851959 | 851959
 | Cap/Floor |  | 10469762 | 10469762
 | Debt Option |  | 674243 | 674243
 | Exotic Option |  | 1400144 | 1400144
 | Swaption |  | 28939583 | 28939583
Cross-Currency | Exotic |  | 95291 | 95291
 | Swap |  | 16363017 | 16363017
TOTAL |  | 171932601 | 223994548 | 395927149
Estimated gross notional amount outstanding, November 9 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].