tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155280d1336750133-looking-up-values-using-multiple-criteria-dummy
Sheet: Sheet1

id1 | id2 | date of sample |  |  |  |  |  | id1 | id2 | date of admission | date of discharge
A |  | 2001-01-02 00:00:00 |  |  |  |  |  | A | 1 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00
A |  | 2001-01-03 00:00:00 |  |  |  |  |  | B | 2 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00
A |  | 2004-01-02 00:00:00 |  |  |  |  |  | C | 3 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00
A |  | 2007-01-02 00:00:00 |  |  |  |  |  | A | 4 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00
B |  | 2005-01-02 00:00:00 |  |  |  |  |  | B | 5 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00
B |  | 2002-01-02 00:00:00 |  |  |  |  |  | C | 6 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00
B |  | 2002-01-03 00:00:00 |  |  |  |  |  | A | 7 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00
C |  | 2009-01-02 00:00:00 |  |  |  |  |  | B | 8 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00
C |  | 2006-01-02 00:00:00 |  |  |  |  |  | C | 9 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00
C |  | 2009-01-03 00:00:00 |  |  |  |  |  | A | 10 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00
Notes:
I need to return the correct id2 value in column B, for each sample.
The date of sample needs to be between the date of admission and date of discharge for each id1, to give the correct id2 number.
Thanks!
Spreadsheet: 1dba3afd-399c-4010-bf1e-deeea25cfa42
Sheet: Sheet2

yes/no | order | Auth type | Compression
Yes | 1 | NONE | ENABLE
No | 2 | PAP | DISABLE
 | 3 | CHAP
 | 4 | MsCHAPV2
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
Spreadsheet: b29641ab-2be7-406e-96c7-c166d062f293
Sheet: Subaccount

Reserve Market Zonal Summary Report
[NAME]
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Real-Time Reserve
Subaccount ID | Subaccount Name | Trading Interval | Reserve Zone ID | Reserve Zone Name | Product Type | Total Asset Forward Reserve Delivered MWs | Forward Reserve Delivered MWs | Final Forward Reserve Obligation | Forward Reserve Credit | Adjusted Forward Reserve Failure-to-Reserve MWs | Forward Reserve Failure-to-Reserve Penalty Rate | Forward Reserve Failure-to-Reserve Penalty | Forward Reserve Failure-to-Activate Penalty | Forward Reserve Obligation Charge MWs | Net Forward Reserve Credit | Real-Time Reserve Credit | Final Forward Reserve Obligation Charge | Net Real-Time Reserve Credit
String | String | Hour End | Number | String | String | MWh | MWh | MWh | $ | MWh | $ | $ | $ | MWh | $ | $ | $ | $
Spreadsheet: 707841d1607501976-dividing-a-number-into-its-multiplication-factors-excel-forum-2020-12-09-a
Sheet: Sheet2

Primes
2
3
5
7
11
13
17
19
23
29
31
37
41
43
47
53
59
61
67
71
73
79
83
89
97
101
103
107
109
113
127
131
137
139
149
151
157
163
167
173
179
181
191
193
197
199
211
223
227
229
233
239
241
251
257
263
269
271
277
281
283
293
Spreadsheet: 205212d1357757553-excel-query-calculating-result-based-on-three-possible-factors-example-medavet-oeldere-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | DATA HAS CHANGED
New Dept ID | Old Dept ID | Old Manager | New Manager | Old Job Code | New Job Code | Old Status | New Status
RT465 | RT465 | [NAME] | FRED ADAMS | 4875 | 4890 | EMP | EMP
GY123 | [NAME] | [NAME] | ANDY BOND | 5362 | 7635 | EMP | EMP
[NAME] | [NAME] | ANDY MANTLE | ANDY MANTLE | 8908 | 8908 | CTR | EMP
PO908 | PO908 | MARY HALL | MARY HALL | 7564 | 1943 | EMP | EMP
FT7546 | FT7564 | SARAH HILL | TANYA SMALL | 6746 | 6746 | EMP | EMP
FT7546 | FT7546 | SARAH HILL | SARAH HILL | 6746 | 6746 | EMP | EMP
Manager AND Dept ID have changed
OR Job Code has changed
OR Status has changed
Spreadsheet: 158366d1338202200-cell-results-from-a-filtered-selection-sample
Sheet: Sheet1

 |  | stage | amount | customer
 |  | Quoted | 2 | A
 |  | Booked In | 2 | b
 |  | Quoted | 2 | A
 |  | In Progress | 3 | g
 |  | Booked In | 5 | h
 |  |  | Amount" if "Stage" = "Quoted" | 4
 |  |  | If "Stage ="Booked In" | 7
 |  |  | If "Stage ="In Progress" | 3
Spreadsheet: 741100d1626816605-match-two-columns-to-multiple-other-columns-and-return-another-column-replacer
Sheet: Find a Replacement

CCR7 (CD197) | [NAME] |  |  | CCR7 (CD197) | [NAME] | Table1.Fluor
CD123 | Super Bright 436 |  |  | CD16 | eFluor 660 | C 668
CD11c | eFluor 450 |  |  | CD4 | Alexa Fluor 647 | C 668
IgD | BV480 |  |  | CD7 | Vio667 | C 668
CD3 | BV510
CD20 | Pacific Orange
IgM | BV570
IgG | BV605
CD7 | Vio667
CD16 | eFluor 660
CD4 | Alexa Fluor 647
Spreadsheet: 101199d1299328943-replicating-chart-taken-from-word-doc-766998
Sheet: Sheet1

 |  |  |  |  |  |  |  | A | B | C | D | E | F | G |  | [NAME]
 |  |  |  |  |  |  | Price Score | 105 | 110 | 120 | 115 | 116 | 108 | 119 |  | 80
 |  |  |  |  |  |  | Non Price Score | 80.5 | 89 | 82 | 85 | 82 | 85 | 82.5 |  | 20
Spreadsheet: 803757d1667666266-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: Secção IX

[NAME]. 1069/2009 Secção IX – Unidades de Manuseamento de Subprodutos Animais ou Produtos Derivados para [NAME]
Atividades de registo
NCV (Approval Number) | Nome (Name) | Concelho (Municipality) | Categoria (Category) | Atividade (Activity) | Espécies / Produtos (Species / Products) | [NAME] (Associated Activities)
 | HUMBERTO JOÃO NEVES ALVES | Alcanena | 3 | [NAME] ) | HISKT | I(STORP), [NAME])
 | MARSIPEL -  Industria de Curtumes, S.A. | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | COURO AZUL-Indústria e Comércio de Couros, S.A. | Alcanena | 3 | [NAME] ) | HISKT | I(STORP), XIV(RM (gel)), [NAME])
 | CURTUMES BOAVENTURA, LDA | Alcanena | 3 | [NAME] ) | HISKT | I(STORP), [NAME])
 | [NAME], Sucrs, S.A. - CURTUMES FONTE VELHA | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | JOÃO ANGELINO CORREIA, SUCRS, LDA | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | FÁBRICA DE CURTUMES RUTRA, LDA | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | Gamaprópria,Lda. | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | Inducol - Indústria de Peletaria Cruz costa, SA | Santarém | 3 | [NAME] ) | HISKT | I(STORP), [NAME])
 | [NAME] Marques & Companhia, Lda | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | J C - Indústria de Curtumes, S.A. | Alcanena | 3 | [NAME] ) | HISKR, HISKT | I(STORP), [NAME])
 | CURTUMES BENJAMIM, LDA | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | Indutan – Comércio e Indústria de Peles, SA. | Alcanena | 3 | [NAME] ) | HISKT | I(STORP), [NAME])
 | Alcurte-Curtumes, S.A. | Alcanena | 3 | [NAME] ) | HISKT | I(STORP)
 | Vestan, S.A. | Montijo | 3 | Manuseamento de subprodutos animais e/ou produtos derivados [NAME] fora da cadeia alimentar(OTHER) | OTHER
 | Demoscore, Lda | Alcanena | 3 | [NAME] ) | RAW | XIV(RM (gel)), [NAME])
Atividades:
Curtimento
Manuseamento de subprodutos animais e/ou produtos derivados [NAME] fora da cadeia [NAME] (OTHER)
Spreadsheet: 703811d1605184910-converting-a-small-amount-of-data-into-a-row-demo
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sum | no of boxes | items per box | part full box 1 | part full box 2 | part full box 3 | part full box 4
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 50 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 10 | 2 | 2 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 30
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 25 | 23
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 25
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 25
 |  |  |  |  |  |  |  |  |  |  |  | 8 | 56 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 55
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 100 | 10 | 45 | 37
 |  |  |  |  |  | What I currently have demonstrating formula I am using.
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sum | no of boxes | items per box | part full box 1 | part full box 2 | part full box 3 | part full box 4
 | 50 | 50 | 50 | 12 |  |  |  |  |  |  |  | 3 | 50 | 12
 | 10 | 10 | 2 | 2 | 2 | 3 |  |  |  |  |  | 2 | 10 | 2 | 2 | 2 | 3
 | 30 |  |  |  |  |  |  |  |  |  |  | 1 | 30
 | 25 | 25 | 25 | 25 | 25 | 23 |  |  |  |  |  | 5 | 25 | 23
 | 25 | 25 | 25 |  |  |  |  |  |  |  |  | 3 | 25
 | 25 |  |  |  |  |  |  |  |  |  |  | 1 | 25
 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 12 |  |  | 8 | 56 | 12
 | 55 | 55 |  |  |  |  |  |  |  |  |  | 2 | 55
 | 100 | 10 | 45 | 37 |  |  |  |  |  |  |  | 1 | 100 | 10 | 45 | 37
 |  |  |  |  |  | The result I need the formula to show
Spreadsheet: 172194d1344020751-create-a-drop-down-box-in-a-worksheet-based-on-certain-values-hydrotruths-workbook-example-oeldere-
Sheet: 123456

[NAME] | name | CREDITED
222222 |  | 100 |  |  | Rowlabels | [NAME]
333333 |  | 20 |  |  | 222222 | 100
999999 |  | 50 |  |  | 333333 | 45
333333 |  | 25 |  |  | 999999 | 50
 |  |  |  |  | (leeg)
 |  |  |  |  | Endtotaal | 195
 |  | 195 | Total Credited
 |  | -195 | My Balance
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Comp Info Tech 3

COMPUTER AND INFORMATION TECHNOLOGY
Associate of Applied Science Degree
Student Name:
ID #
Information Security Track | Semester | Grade
___ CIT 182 (3) Perimeter Defense
___ CIT 184 (3) Attacks and Exploits
___ CIT 217 (3) UNIX/Linux Administration
___ Approved Network Elective Course(s) (6)
___ Approved Network Elective Course (3)
___ Approved Security Elective Course (3)
___ Approved Technical Course(s) (6)
Internet Technologies Track
___CIT 155 (3) Web page Development
___ CIT 157 (3)Web Site Design and Production
___ CIT 253 (3) Date-Driven Web Pages: Topic
___ CIT 257 (3) Applied Internet Technologies
OR ___ CIT 258 (3) Internet Technologies Seminar
___ Completion of Internet Technologies Specialization Sequence (12)
Web Programming Specialization Sequence
___ Approved Level I Programming Language (3)
___ Approved Level II Programming Language (3)
___ CIT 171 (3) SQL I
___ Approved CIT Technical Course
Web Administration Specialization Sequence
___ CIT 219 (3) Internet [NAME]
___ CIT 255 (3) Web Server Administration
___ CIT 261 (3) MS Active Directory Services
AND ___ CIT 213 (3) MS Client/Server Configuration
OR ___CIT 262 (3) MS Network Infrastructure
AND ___ CIT 213 (3) MS Client/Server Configuration
OR ___ CIT 217 (3) UNIX/Linux Net Infrastructure
AND ___ CIT 218 UNIX/Linux Net Infrastructure
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 188075d1350669536-conditional-formatting-061-contagem-celulas-coloridas-format-condic
Sheet: Plan1

 | Vl
 | 0 |  |  |  |  |  | 3 | 7 | 25 | 36 | 51 | 55
 | 50 |  |  |  |  |  | 4 | 5 | 15 | 36 | 51 | 56
 | 100
 | 145 |  |  | Leg | Contag.
 | 134 |  |  |  | 10
 | 134 |  |  |  | 8
 | 134 |  |  |  | 11 |  | 15 | 24 | 25 | 37 | 49 | 51 |  | #N/A
 | 26 |  |  |  | 0
 | 78
 | 23
 | 67
 | 97
 | 45
 | 0
 | 28
 | 708
 | 345
 | 778
 | 56
 | 45
 | 78
 | 98
 | 234
 | 12
 | 17
 | 8
 | 34
 | 70
 | 123
Spreadsheet: 375982d1423433044-show-certain-detailed-data-from-other-sheet-ef683a_pulling-data-reporting-formula
Sheet: Data

Data will be updated monthly
Customers | Location Of Plant | State | Channel | Products | Sales | Price List | Rebate | Trspt Rebate |  | unique_rec |  | State |  | 0
LC Co | PJ Plant | Selangor & FT | RMX | OPC | 1000 | 400 | 50 | 15 |  |  |  | Selangor & FT
LC Co | [NAME] | [NAME] | RMX | Bag | 2000 | 300 | 40 | 10 |  |  |  | [NAME]
LC Co | Puchong | Melaka | RMX | LH | 300 | 250 | 30 | 10 |  |  |  | Melaka
BUILDCON | Kuchai Lama | Selangor & FT | IU | OPC | 400 | 400 | 50 | 15 |  |  |  | N Sembilan
BUILDCON | [NAME] 9 | Melaka | IU | OPC | 600 | 250 | 50 | 10 |  |  |  | All States
BUILDCON | [NAME] | Selangor & FT | IU | Bag | 700 | 400 | 40 | 15
BUILDCON | [NAME] ([NAME]) | N Sembilan | IU | Bag | 2000 | 200 | 40 | 20
UPC | [NAME] | Selangor & FT | Precast | LH | 400 | 400 | 30 | 15
UPC | [NAME] | [NAME] | Precast | OPC | 1000 | 300 | 50 | 10
UPC | [NAME] | Selangor & FT | Precast | OPC | 300 | 400 | 50 | 15
UPC | [NAME] | Selangor & FT | Precast | LH | 100 | 400 | 30 | 15
UPC | [NAME] | N Sembilan | Precast | LH | 100 | 200 | 30 | 20
UPC | Puncak Alam | Melaka | Precast | Bag | 200 | 250 | 40 | 10
 |  |  |  |  |  |  |  |  |  |  | step 2 | ===>
Row Labels | Location Of Plant | State | Channel | Products | Sales | Price List | Rebate | Trspt Rebate
LC Co | [NAME] | [NAME] | RMX | Bag | 2000 | 300 | 40 | 10
UPC | [NAME] | [NAME] | Precast | OPC | 1000 | 300 | 50 | 10
Grand Total
 |  |  |  |  |  |  |  |  |  |  | step 1 | ===>
Spreadsheet: 59464d1259954107-excel-2007-automatic-totals-test
Sheet: Sheet1

 |  |  |  | A | B | C | D | E | F | G | H | J | M | X |  | TOTAL |  |  |  | A | B | C | D | E | F | G | H | J | M | X
 |  |  |  | Program Management | Approvals | Associated Permit Costs | Environmental | Dozing | Survey | Expendables | Acquisition | Processing | Workstation | Contingency |  |  |  |  | Date | Program Management | Approvals | Associated Permit Costs | Environmental | Dozing | Survey | Expendables | Acquisition | Processing | Workstation | Contingency
2009-09-06 00:00:00 | b | client rep |  | n1 | mobe |  |  | 1250 |  |  |  |  |  |  |  | 1250 |  |  | 2009-09-06 00:00:00 |  |  |  |  | 1250
2009-09-07 00:00:00 | b | client rep |  | Name 1 | Scout |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-07 00:00:00 | b | permitting |  | Name 2 | mobe | 900 |  |  |  |  |  |  |  |  |  | 900 |  |  | 2009-09-07 00:00:00 |  |  | 900 |  | 1250
2009-09-08 00:00:00 | b | client rep |  | Name 1 | orientations |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-08 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-08 00:00:00 |  |  | 1800 |  | 1250
2009-09-09 00:00:00 | b | client rep |  | Name 1 | scout |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-09 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-09 00:00:00 |  |  | 1800 |  | 1250
2009-09-10 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-10 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-10 00:00:00 |  |  | 1800 |  | 1250
2009-09-11 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-11 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-11 00:00:00 |  |  | 1800 |  | 1250
2009-09-12 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-12 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-12 00:00:00 |  |  | 1800 |  | 1250
2009-09-13 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-13 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-13 00:00:00 |  |  | 1800 |  | 1250
2009-09-14 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-14 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-14 00:00:00 |  |  | 1800 |  | 1250
2009-09-15 00:00:00 | b | client rep |  | Name 1 |  |  |  | 1250 |  |  |  |  |  |  |  | 1250
2009-09-15 00:00:00 | b | permitting |  | 2 agents | [NAME] | 1800 |  |  |  |  |  |  |  |  |  | 1800 |  |  | 2009-09-15 00:00:00 |  |  | 1800 |  | 1250
Spreadsheet: f2a0674b-7eba-48fa-b357-dd1fde92288b
Sheet: Sheet1

1520 Salgótarján–Hatvan–Budapest–Kecskemét | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | KUNSÁG VOLÁN Zrt. | 2
 |  |  |  |  | _
0 | 0 | .. | .. | [NAME], aut. áll. | 15:10:00
4 | 4 | .. | .. | [NAME] ([NAME]), felülj. | 15:15:00
4.7 | 4.7 | .. | .. | Salgótarján, szécsényi útelág. | 15:16:00
12.6 | 12.6 | .. | .. | B.terenye (K.terenye), ózdi útelág. | 15:25:00
18.5 | 18.5 | .. | .. | Mátraverebély, eszpresszó | 15:32:00
21.7 | 21.7 | .. | .. | Sámsonházai elág. | 15:35:00
28.6 | 28.6 | .. | .. | [NAME], [NAME] út 73. | 15:43:00
29.2 | 29.2 | .. | .. | Pásztó, Csillag tér | 15:44:00
37.5 | 37.5 | .. | .. | [NAME] elág. | 15:53:00
39.9 | 39.9 | .. | .. | Jobbágyi, galgagutai elág. | 15:56:00
47.9 | 47.9 | .. | .. | Petőfibányai elág. | 16:03:00
58.3 | 58.3 | 0 | .. | [NAME], alsó
S | S | 1 | .. | [NAME], aut. pu. | 16:17:00
S | S | 1 | .. | [NAME], aut. pu. | 16:20:00
58.3 | 58.3 | 0 | .. | [NAME], alsó
59 | 59 | .. | .. | [NAME], [NAME] vendéglő | 16:25:00
105.4 | 105.4 | .. | .. | Budapest, Szerencs u. | 17:00:00
109.3 | 109.3 | .. | .. | Budapest, [NAME] út | 17:09:00
S | 113.1 | .. | .. | Budapest, Stadion | L 17:18
113.1 | S | .. | .. | Budapest, Stadion aut. pu. | S
113.1 | S | .. | .. | Budapest, Stadion aut. pu. | S
S | 116.9 | .. | .. | Budapest, Népliget | 17:30:00
S | 116.9 | .. | .. | Budapest, Népliget | 18:00:00
116.9 | S | .. | .. | Budapest, Népliget bej. út | S
195.1 | 195.1 | .. | .. | Kecskemét, Széchenyiváros | 19:07:00
197 | 197 | .. | .. | Kecskemét, aut. áll. | 19:10:00
[NAME]:
A járatok az [NAME], de a mezőben
fel [NAME] megállóhelyeknél [NAME] állnak meg.
0 csomagkezelést nem igénylő utasok részére
_ | Minden nap
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
L | megállás csak leszálló utasok részére
Spreadsheet: 286565d1388374784-how-to-filter-cell-by-color-in-office-2003-both-background-color-and-text-color-color-change-format
Sheet: BACK GROUND FILTER

VENDOR | DATE | INVOICE | ETD | REMARKS | back color
ACRO GAIN | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | Custom color or no fill
AVERY DENNISON | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | Custom color or no fill
C T LABEL | 2013-05-15 00:00:00 | RECEIVED |  |  | Custom color or no fill
[NAME] | 2013-05-15 00:00:00 | RECEIVED |  |  | Custom color or no fill
DURAFLEX | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | Custom color or no fill
DURAFLEX | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
EVERGREEN | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
LEEJO | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | Custom color or no fill
NUWA | 2013-05-15 00:00:00 |  |  | RECEIVED | Custom color or no fill
PCK | 2013-05-15 00:00:00 | RECEIVED |  |  | Custom color or no fill
PCK | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
PCK | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
Spreadsheet: 856759d1705943156-count-names-and-routes-using-the-unique-function-unique-sample-aligw
Sheet: Sheet1

Rte. Id | Name | Out | In |  |  |  |  | Summary
221524 | [NAME] | 09:00:00 | 09:45:00 |  |  |  |  | Name | Total # Rte |  |  | Total # Rte |  |  | Total # Rte
44489 | [NAME] | 09:00:00 | 09:42:00 |  |  |  |  | [NAME] | 3 |  | [NAME] | 1 |  | [NAME] | 1
454548 | [NAME] | 09:00:00 | 10:22:00 |  |  |  |  | [NAME] | 3 |  | [NAME] | 3 |  | [NAME] | 3
12124 | [NAME] | 09:00:00 | 10:45:00 |  |  |  |  | [NAME] | 3 |  | [NAME] | 3 |  | [NAME] | 3
564545 | [NAME] | 09:00:00 | 10:00:00 |  |  |  |  | [NAME] | 1 |  | [NAME] | 2 |  | [NAME] | 2
864466 | [NAME] | 09:00:00 | 10:50:00 |  |  |  |  | [NAME] | 3 |  | [NAME] | 1 |  | [NAME] | 1
53115 | [NAME] | 09:42:00 | 11:00:00 |  |  |  |  | [NAME] | 1 |  | [NAME] | 1 |  | [NAME] | 1
135152 | [NAME] | 09:45:00 | 11:28:00 |  |  |  |  | Total | 14 |  | [NAME] | 3 |  | [NAME] | 3
44889 | [NAME] | 10:00:00 | 11:45:00 |  |  |  |  |  |  |  | Total | 14 |  | Total | 14
15615 | [NAME] | 10:22:00 | 12:01:00
86448 | [NAME] | 11:00:00 | 13:00:00
684684 | [NAME] | 11:28:00 | 12:58:00
56465 | [NAME] | 11:45:00 | 13:15:00
135315 | [NAME] | 12:01:00 | 13:22:00
Spreadsheet: 0f97813f-928c-4e1d-b49f-43ffd0c7cbb5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Montana Snowmobile Program Financial Report
(List only expenditures against your state grooming grant.  Do not include Club expenses.)
Club Name:
Month:
Date | Payment Type or CK# | Vendor | Grooming  Costs | Repair Costs | Plowing Costs | Admin. Costs | Develop. Costs | Description of Expense |  |  |  |  |  | Total
Total for Month
Comments:
Preparers Name (Print):
Preparers Signature:
Spreadsheet: mary_fischer__25736__Browns and Giants Amort
Sheet: Giants Spon Payment

EES - SF Giants
SF Giants Amortization Schedule for Sponsorship Payments
[NAME]: Completed March 2005
Date |  | Payment | Amortization Schedule | Balance on BS
1999-12-31 00:00:00 | 1 | 125000
2000-01-31 00:00:00
2000-02-29 00:00:00
2000-03-31 00:00:00 | 2 | 1000000
2000-04-30 00:00:00
2000-05-31 00:00:00
2000-06-30 00:00:00
2000-07-31 00:00:00
2000-08-31 00:00:00
2000-09-30 00:00:00
2000-10-31 00:00:00
2000-11-30 00:00:00
2000-12-31 00:00:00 | 1 | 150000
2001-01-31 00:00:00
2001-02-28 00:00:00
2001-03-31 00:00:00 | 2 | 1000000
2001-04-30 00:00:00
2001-05-31 00:00:00
2001-06-30 00:00:00
2001-07-31 00:00:00
2001-08-31 00:00:00
2001-09-30 00:00:00
2001-10-31 00:00:00
2001-11-30 00:00:00
2001-12-31 00:00:00 | 1 | 175000
2002-01-31 00:00:00
2002-02-28 00:00:00
2002-03-31 00:00:00 | 2 | 1000000
2002-04-30 00:00:00
2002-05-31 00:00:00
2002-06-30 00:00:00
2002-07-31 00:00:00
2002-08-31 00:00:00
2002-09-30 00:00:00
2002-10-31 00:00:00
2002-11-30 00:00:00
2002-12-31 00:00:00 | 1 | 200000
2003-01-31 00:00:00
2003-02-28 00:00:00
2003-03-31 00:00:00 | 2 | 1000000
2003-04-30 00:00:00
2003-05-31 00:00:00
2003-06-30 00:00:00
2003-07-31 00:00:00
2003-08-31 00:00:00
2003-09-30 00:00:00
2003-10-31 00:00:00
2003-11-30 00:00:00
2003-12-31 00:00:00 | 1 | 350000
2004-01-31 00:00:00
2004-02-29 00:00:00
2004-03-31 00:00:00 | 2 | 1000000
2004-04-30 00:00:00
2004-05-31 00:00:00
2004-06-30 00:00:00
2004-07-31 00:00:00
2004-08-31 00:00:00
2004-09-30 00:00:00
2004-10-31 00:00:00
2004-11-30 00:00:00
2004-12-31 00:00:00
2005-01-31 00:00:00
2005-02-28 00:00:00
2005-03-31 00:00:00
 | 1 | $1MM sponsorship payment made up of 5
 |  | separate payments
 | 2 | Annual sponsorship payment of 1MM for
 |  | repayment of the $5MM dollar [NAME]
Spreadsheet: 709561d1608390614-how-to-lookup-and-match-a-day-between-2-dates-and-return-the-holiday-name-bassemch-holidays_dates
Sheet: Sheet5

Holiday name | Holiday Date | Start Date | End Date | Holiday Count
 |  | 2021-10-24 00:00:00 | 2021-11-27 00:00:00 |  | If a Holiday Day falls between start date C and End date D, then show the Holiday name in A and relative date in B
 |  | 2021-11-28 00:00:00 | 2022-01-15 00:00:00 |  |  | Holidays list and names are in Sheet "Holidays" and named holiday_dates & holiday_names
 |  | 2022-01-16 00:00:00 | 2022-02-19 00:00:00
 |  | 2022-02-20 00:00:00 | 2022-03-26 00:00:00
 |  | 2022-03-27 00:00:00 | 2022-05-15 00:00:00
 |  | 2022-05-20 00:00:00 | 2022-06-26 00:00:00
 |  | 2022-07-02 00:00:00 | 2022-08-12 00:00:00
 |  | 2022-08-13 00:00:00 | 2022-09-18 00:00:00
 |  | 2022-09-23 00:00:00 | 2022-10-29 00:00:00
 |  | 2022-10-30 00:00:00 | 2022-12-11 00:00:00
 |  | 2022-12-16 00:00:00 | 2023-02-03 00:00:00
 |  | 2023-02-04 00:00:00 | 2023-03-10 00:00:00
 |  | 2023-03-11 00:00:00 | 2023-04-21 00:00:00
 |  | 2023-04-22 00:00:00 | 2023-06-09 00:00:00
 |  | 2023-06-10 00:00:00 | 2023-08-05 00:00:00
 |  | 2023-08-06 00:00:00 | 2023-09-23 00:00:00
 |  | 2023-09-24 00:00:00 | 2023-11-03 00:00:00