tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866251d1713209626-countifs-mutiple-columns-and-criteria-times-heatmap-question
Sheet: Sheet1

DATA |  |  |  |  |  |  |  |  | RESULTING HEATMAP
 |  |  | First Visit |  | Second Visit |  |  |  |  | Mon | Tue | Wed | Thu | Fri
2024-04-15 00:00:00 |  | Person 1 | 07:00:00 | 07:45:00 |  |  |  |  | 06:45:00 | 0 | 0 | ETC…
2024-04-15 00:00:00 |  | Person 2 | 07:15:00 | 08:00:00 | 10:15:00 | 11:00:00 |  |  | 07:00:00 | 1 | 0
2024-04-15 00:00:00 |  | Person 3 | 07:30:00 | 09:00:00 |  |  |  |  | 07:15:00 | 2 | 0
2024-04-15 00:00:00 |  | Person 4 | 08:00:00 | 08:30:00 | 10:45:00 | 12:00:00 |  |  | 07:30:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 5 | 09:00:00 | 09:30:00 |  |  |  |  | 07:45:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 6 | 09:30:00 | 10:00:00 |  |  |  |  | 08:00:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 7 | 10:30:00 | 11:00:00 | 12:45:00 | 13:15:00 |  |  | 08:15:00 | 2 | 0
2024-04-16 00:00:00 |  | Person 8 | 11:00:00 | 12:00:00 |  |  |  |  | 08:30:00 | 2 | 0
2024-04-17 00:00:00 |  | ETC... |  |  |  |  |  |  | 08:45:00 | 1 | 0
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:00:00 | 1 | 1
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:15:00 | 0 | 1
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:30:00 | 0 | 2
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 09:45:00 | 0 | 1
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:00:00 | 0 | 1
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:15:00 | 1 | 0
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:30:00 | 1 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 10:45:00 | 2 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:00:00 | 2 | 2
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:15:00 | 1 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:30:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 11:45:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 12:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 12:15:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 12:30:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 12:45:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:00:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:15:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:30:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 13:45:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 14:00:00 | 0 | 0
Spreadsheet: 678079d1589704401-how-to-calculate-that-how-many-days-a-employee-worked-2020-05-17-oeldere-emmr-pt-678072d1589702763-how-to-calculate-that-how-many-days-a-employee-
Sheet: Sheet2

Date | Name | unique | help |  | Name | How Many Days Worked
2020-05-07 00:00:00 | Abul |  |  |  | Abul | 1
2020-05-07 00:00:00 | Abul |  |  |  | Babul | 3
2020-05-07 00:00:00 | Babul |  |  |  | Sumon | 3
2020-05-07 00:00:00 | Babul |  |  |  | [NAME] | 4
2020-05-07 00:00:00 | Sumon
2020-05-07 00:00:00 | [NAME]
2020-05-08 00:00:00 | Babul
2020-05-08 00:00:00 | Sumon
2020-05-08 00:00:00 | Sumon |  |  |  | Rijlabels | Som van unique
2020-05-08 00:00:00 | Sumon |  |  |  | Abul | 1
2020-05-08 00:00:00 | [NAME] |  |  |  | Babul | 3
2020-05-09 00:00:00 | Babul |  |  |  | Sumon | 3
2020-05-09 00:00:00 | Sumon |  |  |  | [NAME] | 4
2020-05-09 00:00:00 | [NAME] |  |  |  | Eindtotaal | 11
2020-05-10 00:00:00 | [NAME]
2020-05-10 00:00:00 | [NAME]
Spreadsheet: 130177d1322112586-find-matched-character-and-pull-it-next-to-the-cell-help-1-
Sheet: Sheet1

Item Number | 1 | 2 | 3 | Path
180005432137 |  |  |  | M:\christianneve - [PHONE]\christianneve - [PHONE].dll.htm
6637176179 |  |  |  | M:\eurosurpie - [PHONE]\eurosurpie - [PHONE].dll.htm
110046134855 |  |  |  | M:\gypo22 - [PHONE]\gypo22 - [PHONE].dll.htm
6638482936 |  |  |  | M:\hotminicooper - [PHONE]\hotminicooper - [PHONE].htm
180007186487 |  |  |  | M:\cnlee88 - Didn't Win\l13bsl - [PHONE]\l13bsl - [PHONE].dll.htm
6284673229 |  |  |  | M:\medalmike92 - [PHONE]\medalmike92 - [PHONE].dll.htm
330003656526 |  |  |  | M:\pre1945collector - [PHONE]\pre1945collector - [PHONE].htm
 |  |  |  | [NAME]
 |  |  |  | M:\turveytop - [PHONE]\turveytop - [PHONE].dll.htm
 |  |  |  | M:\ukmilitaria - [PHONE]\ukmilitaria - [PHONE].dll.htm
 |  |  |  | M:\7580martinh - [PHONE]\7580martinh - [PHONE].htm
 |  |  |  | M:\aberventure - [PHONE]\aberventure - [PHONE].dll.htm
 |  |  |  | M:\aamnottm - [PHONE]\amnottm - [PHONE].htm
 |  |  |  | M:\casey3101 - [PHONE]\casey3101 - [PHONE].htm
Spreadsheet: 64536d1265368017-counting-with-variable-requirements-example
Sheet: Sheet1

Company | Date Raised | Days to Close
Company A | 2009-10-07 00:00:00 | 5
Company B | 2009-09-29 00:00:00 | 15
[NAME] | 2009-09-21 00:00:00 | 10
Company A | 2009-10-22 00:00:00 | 25
Company B | 2009-11-18 00:00:00 | 14
[NAME] | 2009-11-19 00:00:00 | 7
Company A | 2009-12-21 00:00:00 | 6
Company B | 2010-01-26 00:00:00 | 3
[NAME] | 2010-01-26 00:00:00 | 5
Company A | 2010-01-21 00:00:00 | 8
Company B | 2010-01-28 00:00:00 | 4
[NAME] | 2010-01-25 00:00:00 | 8
Company A | 2010-02-01 00:00:00 | 9
Company B | 2010-02-01 00:00:00 | 4
[NAME] | 2010-02-01 00:00:00 | 2
Spreadsheet: 485091d1476703625-look-in-2d-named-range-and-return-the-row-column-number-of-a-reference-cell-value-sample-13
Sheet: After

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 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
 |  |  |  |  |  |  |  |  | Named List = List1 |  |  |  |  |  | GROUP 2 |  |  |  | GROUP 3 |  |  |  | GROUP 4 |  |  |  | GROUP 5 |  |  |  | GROUP 6
 |  |  |  |  |  |  |  |  | Named Range Table = Table1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN100
 |  |  |  |  |  |  |  |  | Named Range For each Group
 |  |  |  |  |  |  |  |  | Groups 1 to 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN8400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUP 1 |  |  |  | GROUP 7 |  |  |  | GROUP 8 |  |  |  | GROUP 9 |  |  |  | GROUP 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
 |  |  |  |  |  |  |  |  | Dynamic List of Valves (List1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Row | Column
 |  |  |  |  |  |  |  |  | Dis Joint DN 80 |  |  |  |  |  | I've hidden as many rows and columns as possible. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Vlv DN80 |  |  |  |  |  | Each name in the yellow list is unique, so there is no chance to repeat itself on the Table1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 | 20
 |  |  |  |  |  |  |  |  | Vlv DN100 |  |  |  |  |  | The position of names in Table1 don't have pattern and may change randomly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 | 27
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Vlv DN200 |  |  |  |  |  | I need to determine the 3 values(Group,Row, Column) that define the location of each Name in Table1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 16
 |  |  |  |  |  |  |  |  | Vlv DN8400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 13 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In the After-Tab, I've filled TABLE 2 by hand, to show a way the results could appear
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If a Name doesn't appear in Table1, should have 0 values
 |  |  |  |  |  |  |  |  | Blank Cells |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank Cells
Spreadsheet: 60709d1261235467-excel-graphs-711406-excel-graphs
Sheet: Sheet4

Search Engine | (All)
Month | (All)
Sum of Work Rank
Keyword | Total
keyword13 | 164
[NAME] | 158
keyword34 | 120
keyword25 | 82
keyword10 | 80
keyword4 | 74
keyword20 | 62
[NAME] | 58
keyword6 | 52
[NAME] | 46
keyword7 | 46
keyword12 | 42
keyword28 | 42
keyword32 | 40
keyword9 | 36
keyword24 | 34
keyword1 | 32
keyword22 | 28
keyword5 | 24
[NAME] | 22
keyword18 | 20
[NAME] | 18
keyword8 | 18
keyword2 | 16
keyword30 | 16
keyword33 | 16
keyword11 | 14
keyword3 | 14
keyword17 | 12
[NAME] | 12
keyword21 | 0
keyword23 | 0
[NAME] | 0
keyword29 | 0
Grand Total | 1398
Spreadsheet: 883963d1732774544-calculating-using-multiple-variables-chrissstresults-example-254-spill-365-aligw
Sheet: 2024Events

 |  | LEAD |  |  | Gross | Company | BJ | CB
500 | 2024-02-06 00:00:00 | CB | Wednesday, December 13, 2023 | NHIAA/PEA | 500 |  | 50 | 200 |  |  |  |  | Team | Lead | Partner | Company
400 | 2024-02-22 00:00:00 | BJ | Thursday, December 14, 2023 | Dual Valley Conference/Northbridge H.S. #1 | 400 | 300 | 50 | 150 |  |  |  |  | BJ | 0.6 | 0.1 | 0.3
1000 | 2024-02-06 00:00:00 | BJ | Saturday, December 16, 2023 | NHIAA/PEA | 1000 | 300 | 50 | 150 |  |  |  |  | CB | 0.5 | 0.1 | 0.4
1500 | 2024-01-01 00:00:00 | CB | Saturday, December 16, 2023 | NHIAA/PSU | 1500 | 250 | 50 | 200 |  |  |  |  | CBJ | 0.45 | 0.45 | 0.1
1000 | 2024-01-01 00:00:00 | CBJ | Thursday, December 21, 2023 | NHIAA/UNH | 1000 | 225 | 225 | 50
1500 | 2024-01-01 00:00:00 | CB | Saturday, December 23, 2023 | NHIAA/PSU | 1500 | 250 | 50 | 200
 |  |  |  |  |  |  |  |  |  | HSTACK(G1,BYCOL(H1:I1,LAMBDA(c,IF(c=C2,"Lead","Partner")))) - works out which order the values from the lookup table should be drawn for eacgh row (row 2 below)
 |  |  |  |  |  |  |  |  |  |  | Partner | Lead
 |  |  |  |  |  |  |  |  |  | BYCOL(h,[NAME],F2*XLOOKUP(c,h,[NAME]:Q5,N3:N5=y)))) - fetches the values matching the headers in h above (row 2 below)
 |  |  |  |  |  |  |  |  |  |  | 50 | 200
Spreadsheet: 882584d1730976590-if-a-cell-has-a-number-in-with-a-certain-text-for-it-then-to-be-added-in-a-different-cel-hallanita-molecular-spill-365-aligw
Sheet: Sheet1

Molecular
Panel 1 |  |  | MCP's | smokes | heats | bases | sounder bases | sounder beacon bases | wall sounder beacons | I/O's
Loop 1 |  |  |  | 0 | 44 | 0 | 57 | 14 | 15 | 17
MCP's-3 |  |  | 36 | 147 | 44
Opticals-30
Heats-0
Sounder Bases-19
[NAME] Bases-4
Wall Sounder Beacons-2
I/O's-3
Panel 1
[NAME]
MCP's-9
Opticals-3
Heats-37
Multi's-2
Wall Sounder Beacon-9
I/O's-7
Panel 2
Loop 1
MCP's-11
Opticals-49
Heats-3
Multi's-1
Sounder Bases-17
[NAME] Bases-6
Wall Sounder Beacons-5
I/O's-1
Panel 2
[NAME]
MCP's-1
Opticals-1
Sounder Bases-1
Panel 3
Loop 1
MCP's-4
Opticals-17
Heats-2
Sounder Bases-6
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-1
Panel 4
Loop 1
MCP's-2
Opticals-9
Wall Sounder Beacons-2
Panel 5
Loop 1
MCP's-5
Opticals-37
Heats-2
Sounder Bases-13
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-4
Panel 6
Loop 1
MCP's-1
Opticals-1
Sounder Bases-1
I/O's-1
Spreadsheet: 746341d1630651450-identify-weeks-in-rolling-12-month-calculations-bo-backtesting-1-ans
Sheet: CALCS

TIME (WINNING TRADES)
START | END | TOTAL TIME | ENTRIES | AVE PRICE | TRADED %
08:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
FED INCOME TAX
Income
Tax Rate
INCOME | RATE
19750 | 0.1
80250 | 0.12
171050 | 0.22
326600 | 0.24
414700 | 0.32
622050 | 0.35
 | 0.37
Spreadsheet: 81443421-1f88-472f-9801-4cc52543da7e
Sheet: Sheet1

Unnamed: 0 | Table S2. Summary of results from locus-by-locus CpG methylation versus covariates. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | n CpG loci*
 | Variable | P < 0.001 | Q < 0.01 | Q < 0.05
 | Tumor grade | 72 | 72 | 209
 | Estrogen receptor status | 85 | 76 | 183
 | Triple negative status** | 65 | 52 | 130
 | Tumor size ([NAME] longest axis) | 37 | 23 | 74
 | Progesterone receptor status | 44 | 26 | 69
 | Lymph node status | 11 | 0 | 4
 | Tumor stage | 9 | 0 | 2
 | Folic acid intake (mg/day) | 3 | 1 | 1
 | Total dietary folate (mg/day) | 1 | 1 | 1
 | ERBB2 overexpression | 3 | 0 | 0
 | Age | 2 | 0 | 0
 | Alcohol (ever drinker) | 1 | 0 | 0
 | Birth control pill use | 1 | 0 | 0
 | Caucasian | 1 | 0 | 0
 | Education level (quartiles) | 1 | 0 | 0
 | Family history of  disease | 1 | 0 | 0
 | Histology, [NAME] vs. Ductal | 1 | 0 | 0
 | Income (tertiles) | 1 | 0 | 0
 | Parity | 1 | 0 | 0
 | *Alcohol intake (g/day) and body mass index were also tested and no loci met these significance criteria
 | **ER, PR and ERBB2 negative
Spreadsheet: 807540d1669937486-adjust-array-to-column-guided-by-cell-value-test-document
Sheet: Mold

 | Item | 1 | 2 | 3
 | Machine Size | 300 | 200 | 400
 | 1 | 100 | 400 | 300
 | 2 | 200 | 300 | 400
 | 3 | 300 | 200 | 100
 | 4 | 400 | 100 | 200
 |  | 200 | 300 | 400
 |  | 300 | 200 | 100
 |  | 400 | 100 | 200
Spreadsheet: 800887d1665976068-how-to-have-a-chart-showing-no-flat-area-book11-bvj-2-
Sheet: Sheet1

Deposit # | Balance |  | Deposit # | Balance | change in balance
1 | 10
2 | 12
3 | 13
4 | -15.23
5 | 14.75
6 | 21
7 | 53
8 | 60
9 | 0
10 | -25
11 | 60
12 | 60
13 | 60
14 | 76.5576923076923
15 | 82.0192307692308
16 | 87.4807692307693
17 | 87.4807692307693
18 | 87.4807692307693
Spreadsheet: 31576d1227499713-removing-duplicates-for-dependant-listboxes-question-listbox
Sheet: Sheet1

 | ProdName | ProdCode | PN
 | A | A1 | 1
 | A | A2 | 2
 | A | A3 | 3
 | B | B1 | 4
 | B | B2 | 5
 | C | C1 | 6
 | D | D1 | 7
 | D | D2 | 8
 | D | D3 | 9
 | D | D4 | 10
 | Need to create a drop down list box for the operators so that when they select the prodname
 | a drop down box for product code will list only the corresponding prodcodes for that product
 | .Based on that selection the PartNumber(PN) drop box will list only the corresponding number
 | Have allready created the drop boxes….no Issues there…only problem is how do I remove the
 | duplicates from prodname and still be able to drop down to corresponding prodcodes and PNs
 | Right now have like all 3 "As" + 2 "Bs" etc showing in the drop box…which is a bit redundant.
Spreadsheet: 817745d1676424392-weekday-formula-weekday-spreadsheet
Sheet: Sheet1

 |  | 2023-02-12 00:00:00
 |  | 2023-02-13 00:00:00
 |  | 2023-02-14 00:00:00
 |  | 2023-02-15 00:00:00
 |  | 2023-02-16 00:00:00
 |  | 2023-02-17 00:00:00
 |  | 2023-02-18 00:00:00
 |  | 2023-02-19 00:00:00
 |  | 2023-02-20 00:00:00
 |  | 2023-02-21 00:00:00
 |  | 2023-02-22 00:00:00
 |  | 2023-02-23 00:00:00
 |  | 2023-02-24 00:00:00
 |  | 2023-02-25 00:00:00
 |  | 2023-02-26 00:00:00
 |  | 2023-02-27 00:00:00
Spreadsheet: 739330d1625651383-index-and-match-3-criteria-for-result-sample-data
Sheet: sUMMARY

 | P2
 | EMEAR |  |  |  |  |  |  |  |  |  |  | P1 | US
Sunday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Monday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Tuesday |  |  |  |  |  |  |  |  |  |  |  | P2 | US
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Thursday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Friday |  |  |  |  |  |  |  |  |  |  |  | P3 | US
Saturday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P4 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P5 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Spreadsheet: 806531d1669368617-matching-notes-from-yesterdays-data-to-todays-newly-imported-data-example-50-
Sheet: Today

Inv | Date | Supplier | Cost
1 | 2022-11-20 00:00:00 | A Bloggs | 1
2 | 2022-11-21 00:00:00 | B [NAME] | 2
3 | 2022-11-22 00:00:00 | C [NAME] | 3
4 | 2022-11-23 00:00:00 | D Bloggs | 4
5 | 2022-11-24 00:00:00 | E Bloggs | 5
Spreadsheet: 860573d1708615413-sum-function-not-capturing-all-amount-wip-and-po-analysis-v_1a
Sheet: Sheet2

Project No | 2023-200
Client | EFAB
Proposal | PO Number | Sum_Value | Sum_Amount_DC
WSG23-365 | [PHONE] | 7708 | 3219
 | 470284536 | 58991.2 | 4541
WSG23-365.1 | [PHONE] | 62978.2 | 16655
WSG23-486 | [PHONE] | 33874.8 | 44
WSG23-522 | [PHONE] | 247138.04 | 2944
WSG23-523 | [PHONE] | 32362 | 1355
WSG23-523.1 | [PHONE] line 1 | 37428.5 | 9891
WSG23-598.1 | [PHONE] line 4 | 87655.8 | 3656
WSG23-609 | [PHONE] | 14169.86 | 115
WSG23-610 | [PHONE] | 8593.57 | 700
 | [PHONE] line 3 | 37953.7 | 4146
WSG23-611 | [PHONE] | 14254 | 190
 | [PHONE] Line 2 | 66138.5 | 1763
Grand Total |  | 709246.17 | 49219
Spreadsheet: 158815d1338401279-compare-a-range-of-cells-to-a-specific-cell-if-match-compare-another-cell-on-same-row-12-13-budget
Sheet: Reference List

Departments |  | Account
AG |  | 11000 - 301010
ESA |  | 11000 - 301020
BIOL |  | 11000 - 301030
CHEM |  | 17800 - 301010
MCS |  | NO FUNDS GRANTED
PENG |  | POD FUNDS
GRANTS |  | SPECIAL FUND
 |  | Animal
Months |  | Anthropology
Jan |  | Biology
Feb |  | Chemistry
Mar |  | Earth Sciences
April |  | Horticulture
May |  | Math
Jun |  | NSD
July |  | Physics Engineering
Aug |  | RVT
Sep |  | Wildlife
Oct |  | Student-Budget Holding
Nov
Dec |  | Student Accounts
 |  | Animal
Rates |  | Anthropology
8 |  | Biology
8.75 |  | Chemistry
10 |  | Earth Sciences
11.25 |  | Horticulture
12.5 |  | Math
 |  | NSD
 |  | Physics Engineering
 |  | RVT
 |  | Wildlife
 |  | Student-Budget Holding
Spreadsheet: 274890d1383250999-copying-row-of-information-to-table-on-different-sheet-based-off-drop-down-selection-autosort-with-index-match
Sheet: Entry

 | [NAME] | Amount | Due Date | Record ID
 | Feed the Unicorns | 50 | 2013-08-01 00:00:00 |  |  |  |  | =IF(OR(C14=$C$33,C14=$C$47,C14=$C$61),COUNTIF($C$14:$C$25,C14)-((SUMPRODUCT(($C$14:$C$25=C14)*($D$14:$D$25>D14))+1)+COUNTIFS($D$14:D14,D14,$C$14:$C14,C14)-1)+1,"")
 | Feed the Unicorns | 50 | 2013-08-15 00:00:00
 | Rent | 200 | 2013-09-01 00:00:00
 | Dead Body Removal | 16000 | 2013-09-01 00:00:00
 | Bribing the Forum Mods | 300 | 2013-09-01 00:00:00
 | Feed the Unicorns | 50 | 2013-09-01 00:00:00
 | Rent | 200 | 2013-10-01 00:00:00
 | Bribing the Forum Mods | 300 | 2013-10-01 00:00:00
 |  |  | =COUNTIF($C$14:$C$25,C14)-((SUMPRODUCT(($C$14:$C$25=C14)*($D$14:$D$25>D14))+1)+COUNTIFS($D$14:D14,D14,$C$14:$C14,C14)-1)+1
Spreadsheet: 135227d1325874815-can-you-lock-cells-so-they-can-never-be-changed-again-pat
Sheet: Sheet1

ID NO. | APPLIANCE DESCRIPTION | APPLIANCE LOCATION | Order No. | CLASS | VISUAL INSPECTION | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  | Functional | DATE OF NEXT TEST | PASS OR FAIL | COMMENTS |  |  | SIGNATURE
 |  |  |  |  |  | Ohms |  |  |  |  | INSULATION
 |  |  |  |  |  | N | E | L1 | L2 | L3 | L1-N | L1-E | L2-N | L2-E | L3-N | L3-E | L1-L2 | [NAME] | [NAME]
Spreadsheet: 175553d1345567963-dragging-vertical-column-cells-horizontally-without-changing-the-letter-simple-example
Sheet: Sheet1

10
20
30
40
50
60
70
80
90
100
110
120
130
140
150
160
170
180
190
200
210
220
230
240
250
Spreadsheet: 152141d1335273295-have-values-in-column-change-color-after-a-certain-total-is-reached-forumsample-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | This is the column!
April 13th | 1000 |  | 800
April 20th | 700 |  | 613
April 27th | 950 |  | 800 | 191
May 4th | 500 |  |  | 382
May 11th | 950 |  |  | 189 | 200 |  |  |  |  |  |  | 300
May 18th | 500 |  |  |  |  |  |  |  |  |  |  | 400
May 25th | 950 |  |  | 150 | 200 |  |  |  |  |  |  | 500
June 1st | 500 | 90 |  |  |  |  |  |  |  |  |  | 200
June 8th | 950 |  |  |  |  |  |  |  |  |  |  | 700
June 15th | 500 |  |  |  |  |  |  |  |  |  |  | 300
June 22nd | 950 |  |  |  |  |  |  |  |  |  |  | 200
June 29th | 500 |  |  |  |  |  | 200 |  |  |  |  | 200
July 6th | 950 | 90 |  | 150 | 200 |  | 100 |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  | 1000
Spreadsheet: 10a2cbcf-388a-48dd-b507-b87944971856
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 9/30/2009
(As of 10/19/2009)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 6641.81
Ames, [NAME] | At-will staff for Mayor [NAME]
Birge, [NAME] | At-will staff for Mayor [NAME] |  | Yes, Values not Given
Fish, [NAME] | Commissioner | 208
Fritz, Amanda | Commissioner
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
Leonard, [NAME] | Commissioner
[NAME], [NAME] | At-will staff for Mayor [NAME] | 25.95
Lord II, Reese | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME] | 3626.81
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Oppenheim, [NAME] | At-will staff for Mayor [NAME] | 50
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ponder, [NAME] | At-will staff for Mayor [NAME]
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | At-will staff for Mayor [NAME] | 80 | 1258
[NAME], [NAME] | Director of Bureau of Police
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME] | 10
Spreadsheet: e6bb78d6-91c6-40a2-b9b6-e49256aa65c5
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
CBN | Test | CBN | Castor [NAME], IgE | Castor [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CBN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CBN | Result | CBN | Castor [NAME], IgE | Castor [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6063-2 | Ricinus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 547397d1510537563-concatenate-strings-unresolved-s666-pivot-2__2017
Sheet: Sheet1

Categories | Count | %
abc | 163 | 0.07422586520947176
ddd | 166 | 0.075591985428051
[NAME] | 163 | 0.07422586520947176
hhh | 529 | 0.2408925318761384
yyy | 536 | 0.24408014571949
xx | 305 | 0.1388888888888889
ttt | 169 | 0.07695810564663023
uuu | 165 | 0.07513661202185792
Grand Total | 2196 | 1