tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 986475c9-f6ee-4df2-b2a0-49c30b573e6d
Sheet: Sheet1

Symbol | HPV1 | HPV5 | HPV8 | HPV9 | HPV3 | HPV18 | HPV33 | HPV16 | HPV39 | [NAME] | HPV11 | HPV32
BAZ1A | 62.95 | 107.11 | 43.33 | 91.73 | 8.14 | 7.37 | 6.58 | 5.52 | 3.73 | 3.68 | 6.87 | 1.93
BRD4 CTD | 67.2 | 200.56 | 200.9 | 153.11 | 14.25 | 26.4 | 71.59 | 6.89 | 22.97 | 27.15 | 35.94 | 21.65
COPS5 | 1.67 | 2.48 | 2.87 | 11.07 | 2.6 | 1.5 | 1.32 | 0.72 | 0.76 | 0.63 | 1.11 | 0.7
ENO1 | 4.21 | 7.03 | 4.18 | 18.8 | 4.1 | 1.67 | 1.81 | 1.09 | 1.02 | 0.71 | 1.08 | 0.7
GTF2B | 1 | 1.58 | 0.95 | 1.09 | 0.66 | 1.04 | 1.86 | 4.17 | 1.34 | 0.75 | 0.83 | 0.74
GPS2 | 19.55 | 37.52 | 14.67 | 38.77 | 4.03 | 8.16 | 9.44 | 10.08 | 4.24 | 2.12 | 3.22 | 1.99
HOXC9 | 10.04 | 10.88 | 7.01 | 41.6 | 4.26 | 2.62 | 7.5 | 5.88 | 3.9 | 2.84 | 2.82 | 2.01
MED11 | 5.37 | 6.84 | 2.53 | 8.71 | 2.09 | 1.62 | 3.28 | 1.3 | 2.37 | 1.25 | 1.62 | 0.55
MGA | 44.53 | 46.24 | 28.14 | 26.55 | 3.92 | 3.74 | 6.03 | 6.88 | 4.37 | 4.58 | 4.53 | 2.31
MYST2 | 15.36 | 28.16 | 44.61 | 23.38 | 2.98 | 6.13 | 10.93 | 4.08 | 4.8 | 3.93 | 4.89 | 1.93
NFE2L2 | 4.68 | 25.04 | 13.45 | 5.93 | 6.59 | 1.69 | 4.69 | 2.51 | 3.14 | 4.02 | 4.74 | 4.46
NMI | 26.89 | 30.6 | 40.06 | 67.9 | 37.2 | 12.82 | 5.81 | 6.22 | 4.28 | 4.75 | 5.13 | 1.87
NR4A1 | 25.71 | 44.77 | 32 | 62.6 | 6 | 10.29 | 16.76 | 9.37 | 7.8 | 6.92 | 6.87 | 4.37
PIAS1 | 4.23 | 5.8 | 3.33 | 6.71 | 2.58 | 1.64 | 2.71 | 1.11 | 1.16 | 0.8 | 1.72 | 0.73
PIAS4 | 3.68 | 5.76 | 3.17 | 16.77 | 1.83 | 1.66 | 3.59 | 2.46 | 2.29 | 1.04 | 1.63 | 0.73
RSF1 | 35.57 | 34.15 | 34.67 | 61.1 | 89.78 | 6.85 | 4.92 | 6.25 | 7.99 | 8.15 | 4.88 | 2.12
RUNX2 | 5.75 | 8.46 | 5.58 | 17.59 | 2.5 | 2.47 | 5.2 | 2.74 | 3.9 | 1.71 | 2.55 | 1.5
SCYL1 | 21.49 | 14.5 | 16.29 | 22.37 | 4.35 | 7.94 | 2.97 | 3.62 | 1.41 | 1.94 | 5.75 | 2.3
SFRS2 | 20.5 | 13.78 | 10 | 45.77 | 1.99 | 1.76 | 3.06 | 1.64 | 1.81 | 1.04 | 1.79 | 0.8
TBP | 25.73 | 38.14 | 27.17 | 25.48 | 18.22 | 19.51 | 36.99 | 8.14 | 12.94 | 6.84 | 16.73 | 7.16
TOB1 | 4.74 | 8.81 | 4.74 | 44.46 | 1.8 | 1.98 | 3.09 | 0.94 | 0.91 | 1.14 | 1.18 | 0.68
TP53 | 14.23 | 26.43 | 17.11 | 31.42 | 23.81 | 11.38 | 12.83 | 5.68 | 6.61 | 4.71 | 7.89 | 6.58
ZBTB38 | 10.34 | 16.94 | 10.24 | 38.02 | 2.94 | 2.24 | 4.99 | 3.22 | 6.62 | 4.13 | 4.23 | 2.03
ZNF251 | 6.91 | 32.82 | 38.13 | 32.14 | 1.34 | 3.13 | 4.04 | 1.76 | 6.63 | 1.26 | 3.55 | 0.8
ZNF669 | 2.11 | 7.27 | 2.51 | 3.04 | 1.04 | 0.54 | 1.16 | 0.55 | 6.64 | 0.41 | 1.11 | 0.34
ZNF84 | 9.58 | 27.72 | 34.62 | 24.95 | 1.33 | 1.41 | 2.94 | 3.43 | 6.65 | 1.38 | 3.11 | 0.76
Spreadsheet: 93e229ba-b1cf-480f-a376-93ec96708624
Sheet: Sheet1

Centromere | CDEI | CDEII Length | CDEII AT% | CDEIII | Scaffold | Co-ordinates
Kwal_CEN1* | ?? | ?? bp | ??% AT | TGTTTGTGAGTTCCGAACATATAT | s23 | (1030091..1030217)
Kwal_CEN2 | TCACCTG | 93 bp | 83% AT | TTTTTGAGCTTTCCGAACCAAAGT | s27 | (590462..590585)
[NAME] | TCACCTG | 94 bp | 86% AT | GGTTGATAGTTTCCGAACATTTTT | s26 | (571110..571234)
Kwal_CEN4 | TCACGTG | 94 bp | 79% AT | TGTTTGAAACTTCCGAATATAATT | s47 | complement(471794..471918)
[NAME] | TCACCTG | 95 bp | 84% AT | [NAME] | s33 | (1009228..1009353)
Kwal_CEN6 | TCATGTG | 93 bp | 86% AT | AGTATAAGCTTTCCGAAACGATTT | s55 | (604523..604646)
Kwal_CEN7 | TCAGGTG | 93 bp | 85% AT | TGTTTTTCCGTTCCGAACATATTA | s56 | complement(133149..133272)
Kwal_CEN8 | TCACCTG | 105 bp | 81% AT | TATTTGCATTTTCCGAAATGATAA | s0 | (135133..135268)
Genome sequence available here:
http://wolfe.gen.tcd.ie/ygob/data/v4-May2010/Kwaltii_sequence.fsa
* CEN1 is a difficult case as the region in question is near (at the CDEI end) a contig join on scaffold s23 which includes an overlap between two contigs.
† The previously annotated CEN3 did not have any of the expected CDEI/III motifs, however the above annotated CDE region was found in the same intergenic region, and is used instead.
Spreadsheet: 700536d1603220289-index-of-a-cell-next-to-the-cell-satisfiying-the-condition-tasks
Sheet: Sayfa1

9. Sınıf | time |  |  |  |  |  |  |  |  | HELPER COL.
 |  |  |  | R-1 | R-2 |  | R-1 | R-2
21 Ekim 2020 Çarşamba | 13.30 | xxxx | Name1 | 9A | 9A | Name7 | 10A | 9A
22 Ekim 2020 Perşembe | 13.30 | ssss | [NAME] | 9A | 9A | Name7 | 10A | 9A
23 Ekim 2020 Cuma | 13.30 | tttt | Name3 | 9A | 9A | Name8 | 10A | 9A
26 [NAME] 2020 Pazartesi | 13.30 | mmmm | Name4 | 9A | 9A | Name7 | 10A | 9A
27 Ekim 2020 Salı | 13.30 | iiii | Name5 | 9A | 9A | Name4 | 10A | 9A
28 Ekim 2020 Çarşamba | 12.00 | cccc | Name6 | 9A | 9A | [NAME] | 10A | 9A
30 Ekim 2020 Cuma | 13.30 | kkkk | Name3 | 9A | 9A | Name8 | 10A | 9A
2 Kasım 2020 Pazartesi | 13.30 | ffff | Name4 | 9A | 9A | Name7 | 10A | 9A
3 Kasım 2020 Salı | 13.30 | tttt | Name5 | 9A | 9A | Name4 | 10A | 9A
4 Kasım 2020 Çarşamba | 13.30 | Biy | Name1 | 9A | 9A | Name7 | 10A | 9A
5 Kasım 2020 Perşembe | 13.30 | Alm | [NAME] | 9A | 9A | Name7 | 10A | 9A
6 Kasım 2020 Cuma | 13.30 | eeee | Name3 | 9A | 9A | Name8 | 10A | 9A
9 Kasım 2020 Pazartesi | 13.30 | ddd | Name4 | 9A | 9A | Name7 | 10A | 9A
10. Sınıf | [NAME]
 |  |  |  | R-1 | R-2 |  | R-1 | R-2
21 Ekim 2020 Çarşamba | 12.00 | Ast | Name7 | 10A | 10A | Name14 | 11A | 10A
23 Ekim 2020 Cuma | 12.00 | Fel | Name9 | 10A | 10A | Name18 | 11A | 10A
26 [NAME] 2020 Pazartesi | 12.00 | mmmm | Name10 | 10A | 10A | Name3 | 11A | 10A
27 Ekim 2020 Salı | 12.00 | iiii | Name11 | 10A | 10A | Name15 | 11A | 10A
28 Ekim 2020 Çarşamba | 10.30 | cccc | Name12 | 10A | 10A | [NAME] | 11A | 10A
30 Ekim 2020 Cuma | 12.00 | kkkk | Name9 | 10A | 10A | Name18 | 11A | 10A
2 Kasım 2020 Pazartesi | 12.00 | ffff | Name10 | 10A | 10A | Name3 | 11A | 10A
3 Kasım 2020 Salı | 12.00 | tttt | Name11 | 10A | 10A | Name15 | 11A | 10A
4 Kasım 2020 Çarşamba | 12.00 | Biy | Name7 | 10A | 10A | Name14 | 11A | 10A
5 Kasım 2020 Perşembe | 12.00 | Alm | Name13 | 10A | 10A | Name17 | 11A | 10A
6 Kasım 2020 Cuma | 12.00 | eeee | Name9 | 10A | 10A | Name18 | 11A | 10A
9 Kasım 2020 Pazartesi | 12.00 | ddd | Name10 | 10A | 10A | Name3 | 11A | 10A
Spreadsheet: 717369d1612616639-how-to-match-and-paste-value-for-multiple-conditions-volume-file
Sheet: Volume

 |  |  | Destination Port
Origin Port | Equipment type | Total volume | NLRTM PT | DEBRV PT | DEHAM PT
CNNBO PT | 20DC | 169 | 84.5 | 42.25 | 42.25 |  |  | NLRTM PT | 0.5
CNXAM PT | 20DC | 112 | 56 | 28 | 28 |  |  | DEBRV PT | 0.25
VNSGN PT | 20DC | 34 | 17 | 8.5 | 8.5 |  |  | DEHAM PT | 0.25
INNSA PT | 20DC | 34 | 17 | 8.5 | 8.5
CNSNZ PT | 20DC | 35 | 17.5 | 8.75 | 8.75
CNSGH PT | 20DC | 11 | 5.5 | 2.75 | 2.75
CNFZH PT | 20DC | 12 | 6 | 3 | 3
IDSUB PT | 20DC | 9 | 4.5 | 2.25 | 2.25
INMAA PT | 20DC | 24 | 12 | 6 | 6
CNYTN PT | 20DC | 7 | 3.5 | 1.75 | 1.75
BDCGP PT | 20DC | 8 | 4 |  | 2
KHKOS PT | 20DC | 7 | 3.5 | 1.75 | 1.75
MMRGN PT | 20DC | 5 | 2.5 | 1.25 | 1.25
VNHPH PT | 20DC | 5 | 2.5 | 1.25 | 1.25
PKKHI PT | 20DC | 6 | 3 | 1.5 | 1.5
THBKK PT | 20DC | 5 | 2.5 | 1.25 | 1.25
CNWZO PT | 20DC | 5 | 1 | 1 | 1
IDJKT PT | 20DC | 1 | 0.5 | 0.25 | 0.25
CNQIN PT | 20DC | 3 | 1 | 1 | 1
INNSA PT | 20DC | 38 | 18 | 10 | 10
HKHKG PT | 20DC | 0 | 0 | 0 | 0
INCOK PT | 20DC | 1 | 0.5 | 0.25 | 0.25
PKKHI PT | 20OT | 5 | 3 | 1.5 | 1.5
CNNBO PT | 40DC | 250 | 120 | 60 | 60
CNXAM PT | 40DC | 132 | 66 | 33 | 33
VNSGN PT | 40DC | 36 | 18 | 9 | 9
INNSA PT | 40DC | 9 | 4.5 | 2.25 | 2.25
CNSNZ PT | 40DC | 34 | 17 | 8.5 | 8.5
CNSGH PT | 40DC | 22 | 11 | 5.5 | 5.5
CNFZH PT | 40DC | 11 | 5.5 | 2.75 | 2.75
IDSUB PT | 40DC | 15 | 7.5 | 3.75 | 3.75
INMAA PT | 40DC | 6 | 3 | 1.5 | 1.5
CNYTN PT | 40DC | 12 | 6 | 3 | 3
BDCGP PT | 40DC | 8 | 4 | 2 | 2
KHKOS PT | 40DC | 10 | 5 | 2.5 | 2.5
MMRGN PT | 40DC | 3 | 1 | 1 | 1
VNHPH PT | 40DC | 7 | 3.5 | 1.75 | 1.75
PKKHI PT | 40DC | 3 | 1.5 | 0.75 | 0.75
THBKK PT | 40DC | 3 | 1.5 | 0.75 | 0.75
CNWZO PT | 40DC | 4 | 2 | 1 | 1
IDJKT PT | 40DC | 3 | 1.5 | 0.75 | 0.75
HKHKG PT | 40DC | 1 | 0.5 | 0.25 | 0.25
INCOK PT | 40DC | 0 | 0 | 0 | 0
CNNBO PT | 40HC | 173 | 86.5 | 43.25 | 43.25
CNXAM PT | 40HC | 145 | 72.5 | 36.25 | 36.25
VNSGN PT | 40HC | 29 | 14.5 | 7.25 | 7.25
INNSA PT | 40HC | 45 | 22.5 | 11.25 | 11.25
CNSNZ PT | 40HC | 18 | 9 | 4.5 | 4.5
CNSGH PT | 40HC | 7 | 3.5 | 1.75 | 1.75
CNQIN PT | 40DC | 1 | 0.5 | 0.25 | 0.25
CNFZH PT | 40HC | 10 | 5 | 2.5 | 2.5
IDSUB PT | 40HC | 7 | 3.5 | 1.75 | 1.75
INMAA PT | 40HC | 5 | 2.5 | 1.25 | 1.25
CNYTN PT | 40HC | 6 | 3 | 1.5 | 1.5
BDCGP PT | 40HC | 9 | 4.5 | 2.25 | 2.25
KHKOS PT | 40HC | 4 | 2 | 1 | 1
MMRGN PT | 40HC | 6 | 3 | 1.5 | 1.5
KHKOS PT | 40RF | 4 | 2 | 1 | 1
VNHPH PT | 40HC | 0 | 0 | 0 | 0
PKKHI PT | 40HC | 3 | 1 | 1 | 1
THBKK PT | 40HC | 0 | 0 | 0 | 0
CNWZO PT | 40HC | 0 | 0 | 0 | 0
IDJKT PT | 40HC | 0 | 0 | 0 | 0
CNQIN PT | 40HC | 0 | 0 | 0 | 0
HKHKG PT | 40HC | 0 | 0 | 0 | 0
INCOK PT | 40HC | 0 | 0 | 0 | 0
Spreadsheet: 218605d1362506921-need-a-formula-to-explain-to-a-smaller-unit-sample-2-
Sheet: Sample

DATA |  |  |  |  |  |  | REPORT
MENU | QTY |  | NETTO |  |  |  | MENU | QTY |  | NETTO
 |  |  | ML |  | OZ |  |  |  |  | BTL | OZ
A | 1 | = | 750 | = |  |  | A | 1000 | =
B | 1 | = | 700 | = |  |  | B | 500 | =
C | 1 | = | 630 | = |  |  | C | 1000 | =
D | 1 | = | 500 | = |  |  | D | 1000 | =
E | 1 | = | 800 | = |  |  | E | 1000 | =
 |  |  |  |  |  |  | QUESTIONS
 |  |  |  |  |  | 1. | I need a function to automaticaly written on the Green area, as the explanation from QTY area
 |  |  |  |  |  | 2. | Is it possible to use Center Across Selection for a vertical text alignment? (in blue area)
 |  |  |  |  |  |  | Like horizontal text alignment that I used in the Yellow area
Spreadsheet: 549433d1511714511-combine-cells-based-on-partial-string-rsmc-test
Sheet: PPOSEnew (2)

 |  |  |  |  |  |  |  | Code1 | Code2 |  | DESIRED RESULT 1 |  | DESIRED RESULT 2
 |  |  |  |  |  |  |  | BRITAIN (BR) SS0029 | RSMC
 |  |  |  |  |  |  |  | BIG MAC | MAC
 |  |  |  |  |  |  |  | FRENCH FRY | FRY
 |  |  |  |  |  |  |  | CHICKEN NUGGETS | NUGGETS
 |  |  |  |  |  |  |  | HOT COFFEE | COFFEE
 |  |  |  |  |  |  |  | CHOCOLATE MUFFIN | MUFFIN
 |  |  |  |  |  |  |  | QUARTER POUNDER | POUNDER
 |  |  |  |  |  |  |  | CANADA (CA) SS00012 | RSMC
 |  |  |  |  |  |  |  | GARDEN SALAD | SALAD
 |  |  |  |  |  |  |  | GARDEN SALAD (AUS) SS89754 | RSMC
 |  |  |  |  |  |  |  | LARGE COKE (CH) SS11123 | RSMC
 |  |  |  |  |  |  |  | LARGE GINGER ALE | ALE
 |  |  |  |  |  |  |  | CHOCOLATE SUNDAE (USA) SS 98743 | RSMC
 |  |  |  |  |  |  |  | *** IF COL J HAS THE TEXT RSMC
Spreadsheet: 40065d1238398084-running-totals-in-column-utility-billing
Sheet: ELECTRICITY

Tariff Costs |  |  |  |  |  |  | Billing |  |  |  | Monthly Readings
Standard Energy |  | 0.1871 |  |  |  |  | Date | Usage | Total |  | Date | Reading | Usage
Discounted Energy |  | 0.1236 |  |  |  |  |  |  |  |  | 2009-02-27 00:00:00 | 85654
Direct Debit Discount |  | 0.06 |  |  |  |  |  |  |  |  | 2009-03-30 00:00:00
VAT |  | 0.05
 |  | Last Reading | This Reading | Usage
Date | 2009-02-27 00:00:00 | 81987 | 85654
 |  |  | Units | Cost
Standard Energy |  |  | 225
Discounted Energy
Monthly DD Discount
Sub Total
VAT
Total
Spreadsheet: 63d4cfcc-be8f-4c33-a617-56b0bee23576
Sheet: MSport

2014 National Junior Olympic Championships
25m Sport Pistol Men Results
12 April 2014
Champion |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 576
2nd Place |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 573
3rd Place |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 558
J2 1st Place |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 553
J2 2nd Place |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 535
J2 3rd Place |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 529
 |  |  |  |  |  |  | Precision |  |  | Rapid
Rank | Bib | First | LAST | Membership | State | Cat | 1 | 2 | 3 | 4 | 5 | 6 | Qual | X | Final | SO | Medal | Pts | Total | SO
1 | 156 | [NAME] | CHICHKOV | 112788 | FL | J1 | 97 | 96 | 95 | 92 | 93 | 96 |  | 11 | 13 |  | 3 | 7
2 | 296 | [NAME] | [NAME] | 1030441 | CA | J1 | 89 | 90 | 92 | 96 | 100 | 98 |  | 15 | 14 |  | 7 | 8
3 | 527 | [NAME] | ZIMMERMAN | 1030003 | OH | J1 | 93 | 92 | 97 | 93 | 84 | 93 |  | 18 | 10 |  | 8 | 6 |  | 1
4 | 154 | [NAME] | CHEON | 1033965 | CA | J2 | 92 | 93 | 91 | 94 | 94 | 89 |  | 8 | 9 | 2 | 6 | 5 |  | 0
5 | 383 | Caleb | PATERSON | 1030408 | KS | J1 | 92 | 86 | 88 | 94 | 91 | 94 |  | 9 | 7 |  |  | 3
6 | 345 | [NAME] | MCCOLLUM | 1034332 | MO | J1 | 93 | 85 | 89 | 92 | 95 | 92 |  | 7 | 5 |  |  | 1
7 | 160 | [NAME] | CHUNG | 1031167 | CA | J2 | 87 | 94 | 93 | 86 | 85 | 90 |  | 11 | 7 |  |  | 2
8 | 152 | [NAME] | [NAME] | 31934 | MA | J1 | 86 | 86 | 91 | 89 | 90 | 91 |  | 5 | 9 | 0 |  | 4
9 | 149 | Quentin | CAUFFMAN | 2382 | WIS | J1 | 89 | 90 | 87 | 92 | 85 | 88 |  | 5
10 | 103 | Justin | AHN | 1033882 | CA | J2 | 87 | 88 | 88 | 85 | 89 | 92 |  | 10
11 | 489 | Brett | [NAME] | 1031808 | OH | J1 | 88 | 88 | 86 | 82 | 94 | 91 |  | 6
12 | 123 | [NAME] | BENNETT | 116927 | MA | J2 | 83 | 90 | 88 | 85 | 91 | 85 |  | 4
13 | 287 | [NAME] | JUDE | 1033980 | TX | J1 | 86 | 90 | 93 | 91 | 83 | 79 |  | 3
14 | 396 | Pryce | PINNEY | 116360 | NE | J1 | 90 | 88 | 83 | 83 | 89 | 87 |  | 2
15 | 229 | [NAME] | GIANCARLI | APPLIED | MD | J1 | 89 | 82 | 65 | 95 | 90 | 95 |  | 5
16 | 297 | [NAME] | [NAME] | 1034705 | CA | J2 | 90 | 83 | 87 | 81 | 84 | 85 |  | 2
17 | 241 | Cade | HAIBY | 1030979 | MN | J2 | 82 | 86 | 84 | 85 | 85 | 88 |  | 2
18 | 316 | [NAME] | LE | APPLIED | MD | J1 | 79 | 82 | 85 | 91 | 83 | 87 |  | 2
19 | 294 | Tyler | KELLY | 1029946 | AK | J2 | 71 | 84 | 85 | 85 | 86 | 88 |  | 5
20 | 145 | Brett | CARLSON | 1034338 | MN | J2 | 79 | 82 | 77 | 81 | 90 | 84 |  | 5
21 | 398 | [NAME] | PLATT | 1032152 | CO | J2 | 76 | 88 | 79 | 75 | 87 | 85 |  | 4
22 | 453 | Logan | SPENCER | 1031716 | AK | J2 | 79 | 75 | 83 | 82 | 85 | 77 |  | 3
23 | 128 | Sean | BLANTON | 28987 | SC | J1 | 89 | 82 | 68 | 75 | 70 | 75 |  | 1
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: tadmartin

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name       H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name       H/caps |  | Front 9 | Back 9 | Total | Points
 |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | Team Ball     N turner, R duce, M stokes 62 points
 | Handicap change G greenfield 12, N Turner 14, A smith 21
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: IUNIE

 |  | NR. CRT | DATA | NR. CAPETE | GREUTATE VIU | [NAME] | LOT | Greutate [NAME] | Greutate [NAME] | Carcase crihala | GREUTATE CARCASA CU CAP | GREUTATE ORGANE | RANDAMENT
 |  | 1 | 2022-06-02 00:00:00 | 6 | 658 |  | 306 | 260 | 260 |  |  | 26
 |  | 2 | 2022-06-07 00:00:00 | 5 | 548 |  | 307 |  |  |  |  | 23
 |  | 3 | 2022-06-08 00:00:00 | 2 | 218 |  | 308 | 175 |  |  |  | 8.8
 |  | 4 | 2022-06-09 00:00:00 | 4 | 465 |  | 309 |  |  |  |  | 16.5
 |  | 5 | 2022-06-10 00:00:00 | 3 | 328 |  | 310 |  |  |  |  | 13
 |  | 6 | 2022-06-13 00:00:00 | 5 | 553 |  | 311 |  |  |  |  | 22
 |  | 7 | 2022-06-15 00:00:00 | 6 | 665 |  | 312 |  |  |  |  | 26
 |  | Total
Spreadsheet: 875901d1722522364-send-calculated-value-of-a-cell-to-another-cell-with-formula-in-excel-tnasir-example-sheet-aligw-tms-
Sheet: Sheet1

 | Basic Salary | 10000
 | Raise (%) | 0.07 | [NAME] in %
 | Starting month | 5 | [NAME] in Starting Month
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Salary | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
 | [NAME]'s solution:
 |  | [NAME] is raised @7% from the m/o May. I need to automatically update the salary from the relative month
Spreadsheet: 025c13ce-b422-42bb-85bc-2c15da556871
Sheet: Budget Revision

BR5 Revision (2/12) |  |  |  |  |  |  |  |  |  | Request #:
LINCOLN UNIVERSITY
REQUEST FOR BUDGET REVISION
Department: |  |  |  |  |  |  |  |  |  | Date:
INSTRUCTIONS: 1. Complete two (2) copies.  2. Indicate complete account number and project number.  3. Provide reason(s) for requesting revision.  4. Secure the required signatures.  5. Transmit one copy to the Grant Accounting Office, keep the second copy for your records.
Increase |  |  |  |  |  |  | Decrease
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Account Number: |  |  | Project # | Amount |  |  | Account Number: |  |  | Project # | Amount
Account Description: |  |  |  |  |  |  | Account Description:
Total Request: |  |  |  |  |  |  | Total Request:
REASON(S):
Department Head Signature |  |  |  | Date |  |  | Other Signature (if applicable) |  |  |  | Date
Vice-President\A.D.\Dean Signature |  |  |  | Date |  |  | President's Signature (if applicable) |  |  |  | Date
For The Grant Accounting Office
INCREASE |  |  |  |  |  |  | DECREASE
Signed |  |  |  |  |  |  | Date
Spreadsheet: 598605d1542625259-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms-v2
Sheet: SFL-SSO

 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
LSSO Authorized |  |  |  |  |  |  |  |  | 2
LSSO Billable Hours
[NAME]
LSSO Billable OT
[NAME]
SSO Authorized |  |  |  |  |  |  |  |  | 10.5
SSO Billable Hours
SSO Non-Billable Hours
SSO Billable OT
SSO Non-Billable OT
Burn Rate
Spreadsheet: 811251d1672378592-vlookup-in-multiple-column-vlookup_multiplecolumns-ans
Sheet: Data

Center | Area | Location
0001 | 0001 | 100
0001 | 0088 | 001
0001 | 0100 | 001
2000 | 0003 | 801
2000 | 0004 | 803
2048 | 0003 | 248
2048 | 0004 | 248
2048 | 0005 | 248
2048 | 0006 | 248
2048 | 0008 | 248
2048 | 0009 | 248
2048 | 0010 | 248
2048 | 0011 | 248
2048 | 0015 | 248
2048 | 0016 | 248
Spreadsheet: 853705d1703668548-excel-cross-tabulated-dynamic-arrays-in-one-cell-excel-cross-tabulated-dynamic-arrays-in-one-cell-2-
Sheet: TabDin

Data | Ano | Mês | Mês/Ano | [NAME] | [NAME] | [NAME] sem | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-04 00:00:00 |  |  |  |  |  |  | 2 |  | 2 | 6 | 1 | 2 |  |  |  |  |  | Just one formula in cell S9
2023-12-05 00:00:00 |  |  |  |  |  |  | 4 |  | 4 | 3 | 2 | 3
2023-12-06 00:00:00 |  |  |  |  |  |  | 5 |  | 1 | 1 | 3 | 6
2023-12-07 00:00:00 |  |  |  |  |  |  | 7 |  | 1 | 4 | 1 |  |  |  |  |  | 50 | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-09 00:00:00 |  |  |  |  |  |  | 1 |  |  |  | 3 |  |  |  |  |  |  |  | 1 | 0 | 5 | 2 | 2
2023-12-10 00:00:00 |  |  |  |  |  |  |  | 1 |  | 5 | 2 | 2 |  |  |  |  | Seg | 4 | 3 | 0 | 3 | 4 | 4
2023-12-11 00:00:00 |  |  |  |  |  |  | 4 | 3 |  | 3 | 4 | 4 |  |  |  |  | Ter | 4 | 5 | 3 | 6 | 5 | 1
2023-12-12 00:00:00 |  |  |  |  |  |  | 4 | 5 | 3 | 6 | 5 | 1 |  |  |  |  | Qua | 4 | 4 | 2 | 8 | 6 | 9
2023-12-13 00:00:00 |  |  |  |  |  |  | 4 | 4 | 2 | 8 | 6 | 9 |  |  |  |  | Qui | 7 | 13 | 1 | 1 | 7 | 0
2023-12-14 00:00:00 |  |  |  |  |  |  | 7 | 13 | 1 | 1 | 7 |  |  |  |  |  | Sex | 2 | 3 | 0 | 3 | 1 | 7
2023-12-15 00:00:00 |  |  |  |  |  |  | 2 | 3 |  | 3 | 1 | 7 |  |  |  |  | Sáb | 2 | 1 | 1 | 0 | 8 | 0
2023-12-16 00:00:00 |  |  |  |  |  |  | 2 | 1 | 1 |  | 8
2023-12-18 00:00:00 |  |  |  |  |  |  | 4 | 1 | 3 |  | 2 | 3
2023-12-19 00:00:00 |  |  |  |  |  |  | 9 | 3 |  | 6 | 4 | 5
2023-12-20 00:00:00 |  |  |  |  |  |  | 4 | 2 | 1 |  | 6 | 2
2023-12-21 00:00:00 |  |  |  |  |  |  | 7 | 14 | 1 | 8
2023-12-26 00:00:00 |  |  |  |  |  |  |  | 1 |  | 9
Spreadsheet: 714754d1611344505-help-with-commission-calculations-question
Sheet: Sheet1

customer | SP | stock# | Date | Type | PROFIT | COMMISSION | NET INCOME
kluger shimon | YK | 884230 | 2021-01-25 00:00:00 | A | 3400
[NAME] | YK | 86359 | 2021-01-27 00:00:00 | B | 860
 |  |  |  | A | 1000
 |  |  |  | A | 1650
 |  |  |  | A | 2300
 |  |  |  | A | 2950
 |  |  |  | B | 1000
 |  |  |  | B | 1650
 |  |  |  | B | 2300
Profit – 150 |  |  |  | B | 2950
If [NAME]  less than $1500  35%  , anything higher than 1500 is 50%
If [NAME]  less than $1500  25%  , anything higher than 1500 is 40%
Spreadsheet: 836336d1689271926-how-to-rank-data-with-multi-criteria-without-duplicate-and-sum-by-group-rank-and-sum-by-group
Sheet: Sheet3

Problem 1 |  |  |  |  |  |  |  |  |  |  |  | Problem 2
Week No. | Department | Categories | Sales | sum | Rank | Rank without duplicated |  |  |  |  |  | Package | Product Code | Unit | Total | Expected
2 | A | Apple | 50 |  |  | 1 |  |  |  |  |  | 4 | CK0201
2 | A | Mango | 25 |  |  | 2 | Change it to rank 2 or 3 without duplicate |  |  |  |  | 4 | AP001
2 | B | [NAME] | 15 |  |  | 2 |  |  |  |  |  | 4 | JK0021
2 | A | Orange | 55 |  |  | 3 | Change it to rank 2 or 3 without duplicate |  |  |  |  | 4 | JK0021 |  |  | 4
2 | A | Apple | 20 |  |  | - |  |  |  |  |  | 2 | MK002
2 | A | Mango | 30 |  |  | - |  |  |  |  |  | 2 | MK002
2 | B | Watermelon | 20 |  |  | 1 |  |  |  |  |  | 2 | MK002
2 | C | Papaya | 75 |  |  | 1 |  |  |  |  |  | 2 | AP001 |  |  | 4
2 | C | Dragon fruits | 15 |  |  | 2 |  |  |  |  |  | 5 | AP001
3 | C | [NAME] | 60 |  |  | 2 |  |  |  |  |  | 5 | PD0012
3 | A | Apple | 30 |  |  | 2 |  |  |  |  |  | 5 | Pen01
3 | C | [NAME] | 70 |  |  | 1 |  |  |  |  |  | 5 | [NAME]
3 | C | Grapes | 30 |  |  | 4 |  |  |  |  |  | 5 | AKW001
3 | C | Durian | 20 |  |  | 5 |  |  |  |  |  | 5 | MK002
3 | A | Orange | 55 |  |  | 1 |  |  |  |  |  | 5 | MK002 |  |  | 7
3 | B | [NAME] | 35 |  |  | 2
3 | C | Pineaple | 55 |  |  | 3
3 | A | Orange | 10 |  |  | -
3 | B | Watermelon | 40 |  |  | 1
Spreadsheet: 741693d1627281600-countifs-with-three-identifier-checks-and-between-specific-time-countifs_samplesheet
Sheet: Sheet1

Type | Time | Name | Destination
Reg | 2021-07-19 21:48:41 | Name One | 156
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  | Destination |  | 155 | Type | Reg
Reg | 2021-07-19 17:57:55 | Name Two | 156
SL | 2021-07-19 18:03:09 | Name Two | 157 |  |  |  | Time Start | Time End | Name One | Name Two | Name Three | Name Four | Name Five
SL | 2021-07-19 18:20:02 | Name Three | 268 |  |  |  | 13:00:00 | 13:30:00
Reg | 2021-07-19 21:49:55 | Name Four | 268 |  |  |  | 13:30:00 | 14:00:00
SL | 2021-07-13 19:46:57 | Name One | 155 |  |  |  | 14:00:00 | 14:30:00
SL | 2021-07-13 21:51:28 | Name Three | 157 |  |  |  | 14:30:00 | 15:00:00
SL | 2021-07-15 13:58:08 | Name Five | 157 |  |  |  | 15:00:00 | 15:30:00
SL | 2021-07-14 21:27:44 | Name Two | 156 |  |  |  | 15:30:00 | 16:00:00
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  |  | 16:00:00 | 16:30:00
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  |  | 16:30:00 | 17:00:00
Reg | 2021-07-12 20:09:42 | Name Three | 155 |  |  |  | 17:00:00 | 17:30:00
Reg | 2021-07-12 20:09:42 | Name Five | 156 |  |  |  | 17:30:00 | 18:00:00
 |  |  |  |  |  |  | 18:00:00 | 18:30:00
 |  |  |  |  |  |  | 18:30:00 | 19:00:00
 |  |  |  |  |  |  | 19:00:00 | 19:30:00
 |  |  |  |  |  |  | 19:30:00 | 20:00:00
 |  |  |  |  |  |  | 20:00:00 | 20:30:00
 |  |  |  |  |  |  | 20:30:00 | 21:00:00
 |  |  |  |  |  |  | 21:00:00 | 21:30:00
 |  |  |  |  |  |  | 21:30:00 | 22:00:00
 |  |  |  |  |  |  | 22:00:00 | 22:30:00
 | The goal is to have the table take an accurate count if the Destination matches, the [NAME] matches, the Type matches, and it is Equal to or between the specified times.
 | For this example it should report on the row for 20:00 to 20:30, 3 for Name One and 1 for Name Three.