tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1899__Transco_Doyle_confirms_May_2001
Sheet: external

DOYLE
MAY    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  |  |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  | STA 85 Gas Daily +0.05 |  | FT | IT @ .1861 | COST
DAY | REQUEST * |  |  |  |  |  |  |  | none for May |  | DEL'd x Comm.
2001-05-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-02 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
*   3-May | 4030 | 4250 | 4250 | 4027 |  |  | fixed price del'd $4.90 |  | 0.0306 | 0.1861 | 0
2001-05-04 00:00:00 | 0 | 0 |  | 5 |  |  |  |  | 0.0306 | 0.1861
2001-05-05 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-06 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-07 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-08 00:00:00 | 4500 | 4500 |  | 5683 |  |  | 4.395 |  | 0.0306 | 0.1861
2001-05-09 00:00:00 | 10000 | 10000 |  | 6586 |  |  | 4.29 |  | 0.0306 | 0.1861
2001-05-10 00:00:00 | 12500 | 10000 |  | 11781 |  |  | 4.2 |  | 0.0306 | 0.1861
2001-05-11 00:00:00 | 5250 | 5500 |  | 4859 |  |  | 4.245 |  | 0.0306 | 0.1861
2001-05-12 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-13 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-14 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-15 00:00:00 | 0 | 0 |  | 5 |  |  |  |  | 0.0306 | 0.1861
2001-05-16 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
**  17-May | 32000 | 32000 |  | 34031 |  |  | fixed price @ Sta 85=$4.40 |  | 0.0306 | 0.1861
2001-05-18 00:00:00 | 14500 | 15000 |  | 14675 |  |  | 4.29 |  | 0.0306 | 0.1861
2001-05-19 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-20 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-21 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-22 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-23 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-24 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-25 00:00:00 | 0 | 1893 |  | 0 |  |  | 4.22 |  | 0.0306 | 0.1861
2001-05-26 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-27 00:00:00 | 0 | 0 |  | 3 |  |  |  |  | 0.0306 | 0.1861
2001-05-28 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-29 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-30 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-31 00:00:00 | 0 | 5 |  | 2 |  |  | 3.82.5 |  | 0.0306 | 0.1861
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | * Interruptible transport restricted for May 1 - 5, gas purchased from ENA at a delivered price at gate.
 | ** called for 17th @ 3:00pm on 16th.
 | Total Transport Commodity charges for May = $14405.41
Spreadsheet: 129055d1321431721-excel-2007-identify-duplicate-forum-1-
Sheet: Arkusz1

1
1
2
3
4, 5
4
6
6
5
7
7
7
8
fgd
dfg
fdg
dfg
dfg
Spreadsheet: john_griffith__16003__QuantoMC
Sheet: Sheet1

 | Quanto Swap Simulation
 |  | Valuation | 2001-07-01 00:00:00
 |  |  | Premium
 |  | Gas Price | 5 |  | HDD | 30
 |  | Gas Vol | 0.5 |  | HDD STD | 10
 |  | Omm. Vol | 0.8 |  |  |  |  | Correl r | 0.8
 |  | Blend Vol |  |  | TS | 1 |  | sqrt(1-r2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hedge
 |  |  |  |  |  | Natural Gas |  | HDD |  |  |  | Blended | HDD | Blended |  | Mark to Market |  |  | Quanto Delta Positions |  |  |  |  |  |  |  | RNDS |  |  |  |  |  |  |  |  |  |  |  |  |  | RNDS
 |  |  | Date | tline |  | Price | Ln(Pt/Pt-1) | Value | Change |  | Correl | Gas Vol | STD | Correl |  | Value | Change |  | Dp | DHDD | Change |  |  | Difference |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Beg. Month
 | Corr. Period
Spreadsheet: 0dca4700-a95c-48e7-8853-96d62f7dc103
Sheet: BDO&Saba 

 | List of BDO/ Executive Officers under  Suri-I Development Block / Panchayat Samity |  |  |  |  |  | List of  Sabhapatis under Sur-I Panchayat Samity
 | Sl No | Name of BDO/EOs |  | From | To |  | Sl No | Name of Sabhapatis | From | To
 | 1 | [NAME] | W.B.C.S. | 30.06.1978 | 25.09.1978 |  | 1 | [NAME] | 30.06.1978 | 17.08.1983
 | 2 | [NAME] | I.A.S. |  | 15.12.1978 |  | 2 | [NAME] | 18.08.1983 | 01.07.2008
 | 3 | [NAME] | W.B.C.S. |  | 25.01.1979 |  | 3 | Smt. [NAME] | 02.07.2008 | 29.07.2009
 | 4 | [NAME] | W.B.C.S. |  | 06.11.1980 |  | 4 | Smt.[NAME] | 30.07.2009 | 19.08.2009
 | 5 | Sri Debiprasad Patra | I.A.S. |  | 08.01.1981 |  | 5 | Smt.[NAME] | 20.08.2009 | 23.08.2011
 | 6 | [NAME]. Paramanik | W.B.C.S. |  | 08.05.1986 |  | 6 | Smt.[NAME] | 24.08.2011 | 18.09.2011
 | 7 | [NAME]. Chakraborty | W.B.C.S. |  | 01.07.1991 |  | 7 | Smt.[NAME] | 19.09.2011 | Till date
 | 8 | [NAME] Mukherjee | W.B.C.S. |  | 04.09.1992
 | 9 | Sri Debasis Das | W.B.C.S. |  | 20.10.1997
 | 10 | [NAME]. Dutta | W.B.C.S. |  | 23.04.2002
 | 11 | [NAME]. Guin | W.B.C.S. |  | 17.02.2004
 | 12 | [NAME] Gopal Mondal | W.B.C.S. |  | 19.09.2005
 | 13 | [NAME]. Gunguly | BDO in Charge |  | 25.12.2005
 | 14 | Smt. [NAME] | W.B.C.S. |  | 01.10.2007
 | 15 | [NAME] | W.B.C.S. |  | 10.11.2009
 | 16 | [NAME] | BDO in Charge |  | 30.12.2009
 | 17 | Smt.[NAME] | W.B.C.S. |  | [NAME]
 | 18 | Smt. Nurzahat Jainab | W.B.C.S. |  | 30.04.2010
 | 19 | [NAME] | W.B.C.S. |  | Till date
Spreadsheet: 869235d1715858023-required-multilevel-sequence-serial-numbers-book2
Sheet: Sheet1

 | C Index | C-Title | M-Index | M-Title | CM Index | CM Title
 | C-1 | ABC | M-1.1 | AAA | [NAME] | ACD
 |  |  |  |  | CM-1.1.2 | DAA
 |  |  |  |  | CM-1.1.3 | KJFF
 |  |  | M-1.2 | BBB | CM-1.2.1 | SKSD
 |  |  |  |  | [NAME] | AWR
 |  |  |  |  | CM-1.2.3 | AD
 |  |  |  |  | CM-1.2.4 | RE
 |  |  | M-1.3 | CCC | CM-1.2.1 | ERE
 |  |  |  |  | [NAME] | AF
 | C-2 | XYZ | M-2.1 | DDD | [NAME] | EERE
 |  |  |  |  | CM-2.1.2 | ADF
 |  |  |  |  | CM-2.1.3 | ADFFE
 |  |  |  |  | CM-2.1.4 | AVE
 |  |  | [NAME] | EEE | CM-1.2.1 | ETER
 |  |  |  |  | [NAME] | EREA
 |  |  |  |  | CM-1.2.3 | AFA
 |  |  |  |  | CM-1.2.4 | ADFE
 |  |  |  |  | CM-1.2.5 | ADF
 |  |  |  |  | CM-1.2.6 | E
 |  |  | M-2.3 | FFF | CM-1.3.1 | ERE
 |  |  |  |  | CM-1.3.2 | RE
 |  |  |  |  | CM-1.3.3 | A
Spreadsheet: 815733d1675174579-formula-that-combines-cells-calculates-new-value-book1
Sheet: Sheet1

 | ABC123 |  |  |  | ABC123 |  |  |  | 9 |  | ABC123
 | 01.01 |  |  | ABC123-02-010 | 01.01 |  |  |  |  |  | 01.01
 | 01.02 |  |  | ABC123-02-011 | 01.02 |  |  |  |  |  | 01.02
 | 01.03 |  |  | ABC123-02-012 | 01.03 |  |  |  |  |  | 01.03
 | 01.04 |  |  | ABC123-02-013 | 01.04 |  |  |  |  |  | 01.04
 | 01.05 |  |  | ABC123-02-014 | 01.05 |  |  |  |  |  | 01.05
 | 01.06 |  |  | ABC123-02-015 | 01.06 |  |  |  |  |  | 01.06
 | 01.07 |  |  | ABC123-02-016 | 01.07 |  |  |  |  |  | 01.07
 | 01.08 |  |  | ABC123-02-017 | 01.08 |  |  |  |  |  | 01.08
 | 02.01 |  |  | ABC123-02-018 | 02.01 |  |  |  |  |  | 02.01
 | 02.02 |  |  | ABC123-02-019 | 02.02 |  |  |  |  |  | 02.02
 | 02.03 |  |  | ABC123-02-020 | 02.03 |  |  |  |  |  | 02.03
 | 02.04 |  |  | ABC123-02-021 | 02.04 |  |  |  |  |  | 02.04
 | 02.05 |  |  | ABC123-02-022 | 02.05 |  |  |  |  |  | 02.05
 | 02.06 |  |  | ABC123-02-023 | 02.06 |  |  |  |  |  | 02.06
 | 03.01 |  |  | ABC123-02-024 | 03.01 |  |  |  |  |  | 03.01
 | 03.02 |  |  | ABC123-02-025 | 03.02 |  |  |  |  |  | 03.02
 | 03.03 |  |  | ABC123-02-026 | 03.03 |  |  |  |  |  | 03.03
 | 04.01 |  |  | ABC123-02-027 | 04.01 |  |  |  |  |  | 04.01
 | 04.02 |  |  | ABC123-02-028 | 04.02 |  |  |  |  |  | 04.02
Spreadsheet: 195229d1353448728-how-to-stop-value-appearing-rate-calculatortest
Sheet: Purchases

 |  | `
 | [NAME] | UNIT | QUANTITY | UNIT COST | TOTAL
 | RATE 1 |  | 2
 | RATE 2 |  | 1
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Costilla

Costilla Energy
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 951757 | 953138
VALUE | 2409693.97
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Asset Deal
Spreadsheet: 54807d1254855063-extracting-text-into-desired-format-in-excel-textextractionexample
Sheet: After

Kempton, 30 September 2009 | LUTHIEN (IRE) | [NAME], the rider of LUTHIEN (IRE), reported that the filly stopped quickly.
Kempton, 30 September 2009 | MUBROOK (USA) | [NAME], the rider of MUBROOK (USA), reported that the gelding suffered interference in running.
Kempton, 30 September 2009 | LAKE KALAMALKA (IRE) | The Stewards considered the running of LAKE KALAMALKA (IRE), ridden [NAME] and trained by J L Dunlop, which finished unplaced, but having received a report from the trainer’s representative, that the gelding had had a long season, the [NAME] decided not to hold an enquiry.
Kempton, 30 September 2009 | KEIBLA SPIRIT | [NAME], the rider of KEIBLA SPIRIT, reported that the filly had bled from the nose.
Newcastle, 30 September 2009 | THUNDER BAY | The Stewards considered the running of THUNDER BAY, ridden by [NAME] and trained by [NAME], who started joint favourite and finished unplaced. However, having received a report that the trainer was unable to offer any explanation and in the absence of any other relevant information, they decided not to hold an enquiry. The Stewards ordered THUNDER BAY to be routine tested.
Newcastle, 30 September 2009 | FOREIGN RHYTHM (IRE) | D. O’Donohoe, the rider of FOREIGN RHYTHM (IRE), reported that the filly was denied a clear run.
Newcastle, 30 September 2009 | DROP THE HAMMER | [NAME], the rider of DROP THE HAMMER, reported that the filly had no more to give.
and so on
Spreadsheet: 680685d1591135840-baseball-line-up-how-to-generate-book1
Sheet: Sheet1

 |  |  |  |  | Game 1
 | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th
Pitcher | [NAME] | [NAME] | [NAME] | [NAME]
Catcher | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1st Base | [NAME] | [NAME] | [NAME] | [NAME]
2nd Base | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
3rd Base | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Shortstop | [NAME]
Left field | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Center field | [NAME]
Right field | Mark
Bench | [NAME] |  | [NAME] |  | [NAME] |  |  |  | [NAME]
Bench | Jeremy
Spreadsheet: 828043d1683204490-ifs-formula-issue-ifs-question
Sheet: Sheet1

 |  | Car | Year | KM Driven | Color | Transimission | Owner | Price (USD) | Manufacturer | Country | Price per Owner
 |  | BMW X5 | 2012 | 342358 | White | Automatic | 1st owner | $15400
 |  | [NAME] | 2017 | 130000 | Red | Manual | 2nd owner | $24321
 |  | Mercedes S-Class | 2020 | 92450 | Black | Automatic | 3rd owner | $102342
 |  | BMW X5 | 2020 | 76240 | White | Automatic | 2nd owner | $55272
 |  | BMW X3 | 2021 | 17283 | White | Manual | 1st owner | $42000
 |  | Lexus RX350 | 2020 | 98312 | Red | Automatic | 3rd owner | $51292
 |  | BMW X3 | 2018 | 156784 | Blue | Manual | 3rd owner | $37605
 |  | BMW X5 | 2019 | 52034 | Blue | Automatic | 1st owner | $45000
 |  | BMW 3 Series | 2011 | 205204 | Red | Automatic | 2nd owner | $13241
 |  | Mercedes S-Class | 2014 | 152985 | Black | Automatic | 2nd owner | $49344
 |  | [NAME] | 2018 | 76429 | Yellow | Automatic | 1st owner | $52432
 |  | Volvo XC90 | 2013 | 254028 | Black | Manual | 2nd owner | $17452
 |  | Audi Q7 | 2014 | 45832 | White | Manual | 1st owner | $23250
 |  | Cadillac XT5 | 2018 | 67591 | Blue | Automatic | 2nd owner | $32420
 |  | Jaguar XF | 2013 | 85320 | White | Automatic | 2nd owner | $18454
 |  | Lexus RX350 | 2016 | 5000 | White | Automatic | 1st owner | $41000
 |  | BMW 428i | 2017 | 92450 | Red | Manual | 2nd owner | $35240
 |  | Lexus RX350 | 2015 | 130000 | Black | Automatic | 4th owner | $22520
Spreadsheet: 686520d1594665780-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data
Sheet: Top 5 vendors 

Top 5 vendors for Backorder
[NAME] | Refunds |  | [NAME] | Total Refund
 |  |  | sirsara | 31263
 |  |  | vimosa | 8371
 |  |  | lilosale | 6762
 |  |  | circarch | 2718
Top 5 vendors for Pre-sell
[NAME] | Sum of Refunds
 |  |  |  |  |  |  | TicketReason | Pre-Sell
 |  |  |  |  |  |  | [NAME] | Sum of Refunds
 |  |  |  |  |  |  | vimosa | 61948
 |  |  |  |  |  |  | silocha | 21557
 |  |  |  |  |  |  | simsa | 5765
 |  |  |  |  |  |  | [NAME] | 1713
 |  |  |  |  |  |  | Grand Total | 90983
Spreadsheet: 798077d1664293208-merged-cells-in-dynamic-array-jade-help-file
Sheet: Tracking Sheet

321 | Centre
5731 | Program
621A0921 | Group
2020 | Year
Fiche | Last Name | First Name |  | 961024 | 961034 | 961042 | 961054 | 961066 | 961074 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2
3
4
5
6
7
Graduated
Fiche | Last Name | First Name |  | 961024 | 961034 | 961042 | 961054 | 961066 | 961074 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
"=IFERROR(FILTER(Program!A:A,(Program!N:N='Tracking Sheet'!$A$2)*(Program!E:E='Tracking Sheet'!$A$1)*(Program!R:[NAME]:B>=$A$4)),"")"
Withdrawn
Fiche | Last Name | First Name |  | 961024 | 961034 | 961042 | 961054 | 961066 | 961074 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
"=IFERROR(FILTER(Program!A:A,(Program!N:N='Tracking Sheet'!$A$2)*(Program!E:E='Tracking Sheet'!$A$1)*(Program!R:R<>"22")*(Program!R:R>0)*(Program!R:R<>"10")*(Program!B:B>=$A$4)),"")"
Spreadsheet: 111747d1308063639-help-for-multiple-adding-exctest
Sheet: Sheet1

Name |  | [NAME]
Fees |  | 20
Owed |  | 5
Total
Name |  | [NAME]
Fees |  | 20
Owed |  | 5
Total
Name |  | [NAME]
Fees |  | 20
Owed |  | 5
Total
Name |  | [NAME]
Fees |  | 20
Owed |  | 5
Total
Name |  | [NAME]
Fees |  | 20
Owed |  | 5
Total
Spreadsheet: 2388f40f-dc06-4398-9523-c2d77e8010d0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PBAB | Test | PBAB | [NAME], Molecular Detection, PCR, Blood | Babesia microti PCR, B | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Anticoagulants other than EDTA | Negative | Monday through Saturday; Varies | Same day/1 day | 4 days | 1 | 87798 |  |  |  |  | Rochester
PBAB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
PBAB | Result | 81147 | Babesia microti PCR, B | Babesia microti PCR, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21089-8
Spreadsheet: 42677d1241211177-copying-data-from-a-column-to-a-row-sample1
Sheet: Sheet1

SFID | 12346 | 12347 | 12349 | 12350 | 12401 | 12572 | 12601 | 12708 | 22255 | 89977 | 75520 | 99525 | 44452 | 33325 | 22154 | 75525 | 11122 | 44455 | 99977 | 10155 | 100943 | 91666
Commission Income | 2408 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spiff Income | -1380 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Comm. Chargebacks | 7183.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AMF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: lindy_donoho__21990__CASplog
Sheet: Active Plogs

Plog# | Function | Description of Problem/Enhancement | Reported By/Date | Assigned To/Date | Priority | Comments | Release Date | Retested | by
83 | Reports | Not looking at Point date ranges | [NAME] 01/18 | [NAME] |  | In Model Office | 2002-02-04 00:00:00
84 | Evaluation | When reducing quantity at a point causes groups r/d adj. To be reduced also | [NAME] | Benito
85 | Timeout | Receiving error message | [NAME] |  |  | Need screen print of error message - timeout is set at 12 hours
86 | Date range selection | Year selection set at 365 days | [NAME] | [NAME] |  | Remove limitation of 1 Year on Inquiry
87 | Reports | Default date to current date | [NAME]
88 | Post Capacity | Allow for on-demand schedule to post Capacity to the Web | [NAME] |  |  | [NAME] procedures with DBA, impl permanent solution with FGT CAS
89 | Evaluation | Bi-Directional/ in/out thru a segment | Mktrs 2/1 |  |  | Meeting to be scheduled to discuss impact
90 | Testing | Speed up testing when changes made | [NAME] 2/1 |  |  | Create test scripts for evaluation and calculation of groups and points
Spreadsheet: 715848d1611881589-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Liste

 | Revenus total de toutes sources |  | Dépenses totale de toutes sources |  | Paiements carte de crédit / dépenses famille
 | Épargne et investissements
 | Source de revenu | [NAME] réception | [NAME] | Mode pmnt | Néc. / Luxe | Rev. et Dép. | Mois | Année | Année financière | Code d'année
 | Autre | Autre | Assurance auto | Autre | Nécessité | Année financière | [NAME] | 2012 | Janvier-Décembre
 | Crédit Solidarité Qc | Chèque | Assurance habitation | Carte cadeau | Luxe | Dernier 12 mois | [NAME] | 2013 | Février-Janvier
 | Intérêt Banque | Comptant | Autre | Carte crédit | " |  | Mars | 2014 | Mars-Février
 | Paye travail | [NAME] direct | Divertissement | Carte débit |  |  | Avril | 2015 | Avril-Mars
 | Paye vacance | Virement | [NAME]/chauffage | Chèque | Cycle | Oui/Non | Mai | 2016 | Mai-Avril
 | Remb. Impot Canada |  | Épicerie | Comptant | Régulier | Oui | [NAME] | 2017 | Juin-Mai
 | Remb. Impot Québec |  | Essence | Virement | Irrégulier | Non | Juillet | 2018 | [NAME]
 | [NAME]. prêt fam./ami |  | Facture médicament |  | " |  | [NAME] | 2019 | Août-Juillet
 | Remb. TPS |  | Forfait cellulaire |  |  |  | Septembre | 2020 | [NAME]
 | Retrait placement CÉLI |  | Impôt retenu Canada | Mode paiement | Comptes |  | Octobre | 2021 | Octobre-Septembre
 | Retrait placement REER |  | Impôt retenu Québec | Autre | Argent métal |  | Novembre | 2022 | Novembre-Octobre
 |  |  | Internet | Carte cadeau | Chèque |  | Décembre | 2023 | Décembre-Novembre
 |  |  | Logement | Carte crédit | FTQ (REER) |  |  | 2024
 |  |  | Paiement avance | Carte débit | [NAME] (CÉLI) |  |  | 2025
 |  |  | Permis conduire | Chèque | Urgence
 |  |  | Plaque immatriculation | Comptant
 |  |  | Prêt famille/amis | En ligne (cpt. Chèque)
 |  |  | Réparation / entretien auto | Virement
 |  |  | Restaurant
 |  |  | [NAME] (thérapeute divers)
 |  |  | Transfert cpt. Ép./Inv./Urg.
 |  |  | Vacance/voyage
Spreadsheet: 328838d1404112994-help-with-data-validation-and-list-with-formula-teachers-schedule
Sheet: Avaliability

Date | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00 | 2014-07-08 00:00:00 | 2014-07-09 00:00:00 | 2014-07-10 00:00:00 | 2014-07-11 00:00:00 | 2014-07-12 00:00:00 | 2014-07-13 00:00:00 | 2014-07-14 00:00:00 | 2014-07-15 00:00:00 | 2014-07-16 00:00:00 | 2014-07-17 00:00:00 | 2014-07-18 00:00:00 | 2014-07-19 00:00:00 | 2014-07-20 00:00:00 | 2014-07-21 00:00:00 | 2014-07-22 00:00:00 | 2014-07-23 00:00:00 | 2014-07-24 00:00:00 | 2014-07-25 00:00:00 | 2014-07-26 00:00:00 | 2014-07-27 00:00:00 | 2014-07-28 00:00:00 | 2014-07-29 00:00:00 | 2014-07-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-01 00:00:00 | 2014-08-03 00:00:00
Day | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Sunday
[NAME]
Harley | Harley | Harley | Harley |  | Harley |  | Harley |  | Harley | Harley
Heloisa |  |  |  |  |  |  |  |  |  |  |  | Heloisa |  | Heloisa | Heloisa |  | Heloisa |  | Heloisa |  |  | Heloisa |  | Heloisa |  |  |  |  | Heloisa |  | Heloisa
Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia |  | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia
[NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
Thais | Thais | Thais | Thais |  | Thais |  | Thais |  | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais
Salete | Salete |  | Salete |  |  |  |  |  |  | Salete |  |  |  |  | Salete |  | Salete
[NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME]
New 1
New2-Klaus
Helper Data
Spreadsheet: 123313d1317555797-vlookup-help-compspider_sample
Sheet: Sheet1

Company Name | Tracking number | Ticket number / PO number | Date | Item shipped | Ticket number | Count of TNs | PO number |  |  |  |  |  |  |  | Unique TNs
XYZ 1 | 1Z456789456 | TN123456   PO456725 | 09.09.2011 | Pen
XYZ 2 | 1Z456789457 | TN123457   PO456726 | 09.09.2012 | Station |  |  |  |  | Search function
XYZ 3 | 1Z456789458 | TN123458   PO456727 | 09.09.2013 | shirt |  |  |  |  | Item | Ticket Number | Tracking number | Company Name | Item shipped
[NAME] | 1Z456789459 | TN123459       PO456728 | 09.09.2014 | car |  |  |  |  |  | TN123481
XYZ 5 | 1Z456789460 | TN123460   PO456729 | 09.09.2015 | motorcycle
XYZ 6 | 1Z456789461 | [NAME] | 09.09.2016 | Pen
XYZ 7 | 1Z456789462 | TN123462       PO456731 | 09.09.2017 | Station
[NAME] 8 | 1Z456789463 | TN123463       PO456732 | 09.09.2018 | shirt
XYZ 9 | 1Z456789464 | TN123464   PO456733 | 09.09.2019 | car
XYZ 10 | 1Z456789465 | TN123465   PO456734 | 09.09.2020 | motorcycle
XYZ 11 | 1Z456789466 | TN123466   PO456735 | 09.09.2021 | Pen
XYZ 1 | 1Z456789467 | TN123467   PO456736 | 09.09.2022 | Station
XYZ 2 | 1Z456789468 | [NAME] | 09.09.2023 | shirt
XYZ 3 | 1Z456789469 | TN123469   PO456738 | 09.09.2024 | car
[NAME] | 1Z456789470 | TN123470       PO456739 | 09.09.2025 | motorcycle
XYZ 5 | 1Z456789471 | TN123471       PO456740 | 09.09.2026 | Pen
XYZ 6 | 1Z456789472 | TN123472   PO456741 | 09.09.2027 | Station
XYZ 7 | 1Z456789473 | TN123473   PO456742 | 09.09.2028 | shirt
[NAME] 8 | 1Z456789474 | TN123474   PO456743 | 09.09.2029 | car
XYZ 1 | 1Z456789475 | TN123475       PO456744 | 09.09.2030 | motorcycle
XYZ 2 | 1Z456789476 | TN123476       PO456745 | 09.09.2031 | Pen
XYZ 3 | 1Z456789477 | TN123477       PO456746 | 09.09.2032 | Station
[NAME] 8 | 1Z456781111 | PO456721 TN456421 | 12.12.2011 | Laptop
XYZ 1 | 1Z456123451 | PO451232       TN123499 | 12.13.2011 | computer
XYZ 2 | 1Z789542154 | O4572345  TN7894231 | 04.05.2011 | bag
XYZ 3 | 1Z456789478 | TN123478       PO456747 | 09.09.2033 | shirt
XYZ 5 | 1Z456789479 | TN123479       PO456748 | 09.09.2034 | car
XYZ 6 | 1Z456789480 | TN123480       PO456749 | 09.09.2035 | motorcycle
XYZ 7 | 1Z456789481 | TN123481       PO456750 | 09.09.2036 | Pen
XYZ 7 | 1Z456789499 | TN123481       PO456756 | 09.10.2036 | boat
What about an instance if the ticket number has more than one entry?