tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716284d1612153951-matching-multiple-criteria-where-one-of-the-them-needs-to-match-a-range-or-closest-value-title_billrate
Sheet: Table1

Standard Title | Standard Level | Market Grade | BillRates
Title_2 |  | B | 44.55
Title_4 |  | B | 100
Title_6 |  | B | 92
Title_6 |  | B | 52.18
Title_7 |  | B | 110
Title_7 |  | B | 97.5
Title_7 |  | B | 84
Title_7 |  | B | 95
Title_7 |  | B | 112.2
Title_8 |  | B | 41.98
Title_8 |  | B | 130
Title_7 |  | A | 110
Title_7 |  | B | 110.25
Title_1 |  | B | 27.71
Title_1 |  | B | 27.97
Title_4 |  | B | 92
Title_8 |  | B | 69.5
Title_6 |  | B | 58
Title_7 |  | B | 88
Title_7 |  | B | 125
Title_7 |  | B | 119.7
Title_8 |  | B | 98
Title_8 |  | B | 112
Title_8 |  | B | 103.04
Title_8 |  | B | 93
Title_2 |  | A+ | 48
Title_5 |  | C | 86
Title_3 |  | C | 82
Title_9 |  | D | 36.2
Title_3 |  | A+ | 180
Title_2 |  | A+ | 48
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: JW

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Physiotherapy- Lucian Nakhoul

Contract Terms (*)
 |  | Revenue Target (Physiotherapy) | Incentive
 |  | Tier 1 - 0 to 130,000 | 0
 |  | [NAME] to 150,000 | 0.014
 |  | [NAME] to 160,000 | 0.024
 |  | [NAME] and ABOVE | 0.034
Doctor Calculation
 |  | Total Revenue | 122867.85
 |  | Amount to be paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 549957d1512003207-trouble-with-index-and-match-book1
Sheet: Sheet1

A01
A02
A03
A04
A05
A06
A07
A08
A09
A10
Spreadsheet: 848725d1699377716-avoid-ref-error-when-deleting-columns-excel-help-forum-examples
Sheet: AFTER Deletion

 | 2023-11-10 00:00:00 |  | Accumulated Savings: |  |  | Accumulated Savings: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Amt | Deposited? |  | Amt | Deposited? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
Income | 350 | Y | - | 350 | Y | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
Expenses | 200 | N/A | - | 200 | N/A | -
Savings |  |  |  |  | N
Rollover from previous period |  |  | N/A
Spreadsheet: 774703d1648626643-round-sales-price-up-to-next-25-50-75-cent-or-round-to-50-cent-and-full-price-list-test
Sheet: Round X.X9

Retail Price List
Last number used | Last Item Number |  | Cost Base |  |  | Calculated Cost |  |  |  |  | Sales Price
 |  | 2.2046 |  |  |  |  |  |  |  |  | 3.5 | 3.35 | 3.25 | 3.15 | 3
Type | Product # | Description | UOM | Cost | Cost | Cost 1oz | Cost 2oz | Cost 4oz | Cost 8oz | Cost lbs | Packing [NAME]
 |  |  |  | UOM | Base lbs |  |  |  |  |  | 1 | 2 | 4 | 8 | 16
 | 100158 | Product 1 | 500 | 65.5
 | 100077 | Product 2 | 500 | 13.05
 | 100125 | Product 3 | 500 | 13.08
 | 100360 | Product 4 | 1000 | 21
Spreadsheet: kate_symes__18861__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
Spreadsheet: 883616d1732238090-how-to-avoid-circular-references-in-a-user-input-auto-fill-table-components-lookup-jt-
Sheet: Example Sheet

DESIRED VOLUME | DESIGN ITEM | INGREDIENTS
1 | COMPUTER |  | Circuit Board |  | Plastic |  | Copper |  | Wire |  | Electrode
1 | CIRCUIT BOARD |  | Plastic |  | Copper |  | Gold |  | Solder
 | WIRE |  | Copper
 | COPPER |  | Ore
 | ELECTRODE |  | Copper |  | [NAME] |  | Wire
Spreadsheet: 885657d1735406210-how-to-find-projection-dates-from-a-starting-date-example
Sheet: Feuil2

FID | 2025-04-01 00:00:00
CPF - Cstr |  | 9 mois après FID
NWP - Cstr | 2026-01-01 00:00:00 | 9 mois après FID
P.camp - Cstr | 2025-03-01 00:00:00 | 1 mois avant FID
EW- Cstr | 2025-06-01 00:00:00 | 2 mois après FID
Comm. | 2027-09-01 00:00:00 | 29 mois après FID
RFSU | 2028-01-01 00:00:00 | 33 mois après FID
NA
Spreadsheet: 849529d1699973485-combine-3-sheets-data-into-1-final-sheet-book1-2-1-2-
Sheet: HOA (2)

 | Singles | Handicap | Doubles | Total | Class
 |  |  |  | 0 |  | HERE IS MY ISSUE
[NAME] |  | 89 | 80 | 169
[NAME] DOE | 90 |  |  | 90 | D |  |  | This is as close to the file set up I have without sending you the whole thing
[NAME] | 90 | 94 | 90 | 274 | B |  |  | sheet 1 - 3 are the individual events & score entries
JIMMY DOE | 84 |  |  | 84 | C |  |  | sheet 4 is broken for now..
[NAME] | 82 |  |  | 82 | A |  |  | the "WIN" tabs are made do the format will match the HOA tab
KATHY DOE |  | 90 | 80 | 170 |  |  |  | & original set up I asked for help on.
LEW DOE | 90 |  |  | 90 | A
MARK DOE |  | 87 | 82 | 169 |  |  |  | As I mentioned, when I manually type the data and use your formula, it works as asked
WILLY DOE |  | 92 | 88 | 180
 |  |  |  |  |  |  |  | When I use the data supplied from a formula, I get this end result.
 |  |  |  |  |  |  |  | The first line always shows blank w/a "0" in the total column.
Spreadsheet: 198504d1354802100-problem-with-copying-vlookup-shytot-2-a
Sheet: Sheet1

 | Range1 [NAME] | AB |  |  |  |  |  |  |  | Result needs to be
 |  | RESULTS |  |  |  | Range2 Lookup
 |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  | 21
 |  |  |  |  |  | 2012-01-02 00:00:00 |  |  |  | 22
 |  |  |  |  |  | 2012-01-03 00:00:00 |  |  |  | 23
 |  |  |  |  |  | 2012-01-04 00:00:00 |  |  |  | 24
 |  |  |  |  |  | 2012-01-05 00:00:00 |  |  |  | 25
 |  |  |  |  |  | 2012-01-06 00:00:00 |  |  |  | 26
 |  |  |  |  |  | 2012-01-07 00:00:00 |  |  | etc | 27
 |  |  |  |  |  | 2012-01-08 00:00:00 |  |  |  | 28
 |  |  |  |  |  | 2012-01-09 00:00:00 |  |  |  | 29
 |  |  |  |  |  | 2012-01-10 00:00:00 |  |  |  | 30
 |  |  |  |  |  | 2012-01-11 00:00:00 |  |  |  | 31
 |  |  |  |  |  | 2012-01-12 00:00:00 |  |  |  | 32
 |  |  |  |  |  | 2012-01-13 00:00:00 |  |  |  | 33
 |  |  |  |  |  | 2012-01-14 00:00:00 |  |  |  | 34
 |  |  |  |  |  | 2012-01-15 00:00:00 |  |  |  | 35
 |  |  |  |  |  | 2012-01-16 00:00:00 |  |  |  | 36
 |  |  |  |  |  | 2012-01-17 00:00:00 |  |  |  | 37
 |  |  |  |  |  | 2012-01-18 00:00:00 |  |  |  | 38
 |  |  |  |  |  | 2012-01-19 00:00:00 |  |  |  | 39
 |  |  |  |  |  | 2012-01-20 00:00:00 |  |  |  | 40
 |  |  |  |  |  | 2012-01-21 00:00:00 |  |  |  | 41
 |  |  |  |  |  | 2012-01-22 00:00:00 |  |  |  | 42
 |  |  |  |  |  | 2012-01-23 00:00:00 |  |  |  | 43
 |  |  |  |  |  | 2012-01-24 00:00:00 |  |  |  | 44
 |  |  |  |  |  | 2012-01-25 00:00:00 |  |  |  | 45
 |  |  |  |  |  | 2012-01-26 00:00:00 |  |  |  | 46
 |  |  |  |  |  | 2012-01-27 00:00:00 |  |  |  | 47
 |  |  |  |  |  | 2012-01-28 00:00:00 |  |  |  | 48
 |  |  |  |  |  | 2012-01-29 00:00:00 |  |  |  | 49
 |  |  |  |  |  | 2012-01-30 00:00:00 |  |  |  | 50
 |  |  |  |  |  | 2012-01-31 00:00:00 |  |  |  | 51
 |  |  |  |  |  | 2012-02-01 00:00:00 |  |  |  | 52
 |  |  |  |  |  | 2012-02-02 00:00:00 |  |  |  | 53
 |  |  |  |  |  | 2012-02-03 00:00:00 |  |  |  | 54
 |  |  |  |  |  | 2012-02-04 00:00:00 |  |  |  | 55
 |  |  |  |  |  | 2012-02-05 00:00:00 |  |  |  | 56
 |  |  |  |  |  | 2012-02-06 00:00:00 |  |  |  | 57
Spreadsheet: 2cf360c7-b1d0-4f44-9516-fdd1170c6c88
Sheet: Table S3_Primer list

Table S3. List of primers for the different experiments. Primers are sorted according to the experiments they were designed for.
IaaH and IPT qPCR
IaaH RT fwd | GTCGGCTTCAACAAAGG
IaaH RT rev | CCTCGACCAGGTGATT
[NAME] | GAGGGAGGATCTATCTCG
[NAME] | GCAGGGCGTAACATCT
ABA-dependent methylation qPCR
NDF 4 RT fwd | ACTTGCATGGTCGAGA
NDF 4 RT rev | CGAGATCATCGTCATTAGGT
[NAME] fwd | CAATATGACTGCGGGT
[NAME] rev | AATGGGACACGAGTGA
[NAME] | GCGATTTCGCTTACCG
[NAME] | GAACCCCATCACTCCT
Bisulfite sequencing of intergenic regions
IR1 BS fwd | AGAAGGGYATTTAATGGTTTTG
IR1 BS rev | ACCATTATCARATCCACCATTTT
IR2 BS 1 fwd | AAGTATTGYAYGTTTTATAAATTG
IR2 BS 1 rev | TTTCACAATTRACRTAAATTTCCCTCTA
IR2 BS 2 fwd | AGAGGGAAATTTAYGTYAATTGTGAAATAG
IR2 BS 2 rev | AAAATTARACRCARATCCATAA
Bisulfite sequencing of mCIP controls
at1g20850 BS fwd | TTATTGTTGAGGTTGGYATTTTATYATTGAGG
at1g20850 BS rev | TACRTTTRTTTTTCTTTTRTCACTT
at2g16595 BS fwd | ATTAAAATATAGAATAGAATYYGAGGTAA
at2g16595 BS rev | CCATTCATCATRCRAARCATCTTTA
at3g19250 BS fwd | TTTAAATGGTAATYAATTGAAAGAYTTAATTATTG
at3g19250 BS rev | [NAME]
at4g12760 BS fwd | AGAATATGTGTTTAAAYAGTGAAYAGGTAGGTT
at4g12760 BS rev | CCTTCAAATTATACACACTCTRAACACT
at5g58370 BS fwd | AGYAAATTGATGGTGATAGTAATGGAA
at5g58370 BS rev | [NAME]
Bisulfite sequencing of ABA-dependent promoter methylation
F12A4.4 BS fwd | TTATTTATTAAAATTGTAAAGTATGTTTTAGTTAA
F12A4.4 BS rev | TTTTTATCATAATATTTTCRTTTRATACATTTTTA
[NAME] fwd | AAGAATTTTTAAYATTAGATATAATAAAAGTTAAG
[NAME] rev | ATCATRCAACCCAATAATAAAAAATRAACAT
[NAME] fwd | TAGGAYAAAAYTGGGAGAATAAA
[NAME] rev | TARRTTTTARATTTTACAATTAAATAAAAT
Bisulfite sequencing of oncogene cluster
T-DNA 1 fwd | ATYGGGAAAGGAAGGAAAATTTA
T-DNA 1 rev | AGTAATTTYGATAAGTGGTTTGGA
T-DNA 2 fwd | TTGTATTTAATTGATAGAGTTTG
T-DNA 2 rev | CTCCCCACTACCTACTTTTA
T-DNA 3 fwd | GTAAAAGTAGGTAGTGGGGA
T-DNA 3 rev | CAAAAAACTCAAACRATAATATAAC
T-DNA 4 fwd | GTTTAATATTAATYGGTTTGTTAT
T-DNA 4 rev | AATACCCTTCTAACTACAAA
T-DNA 5 fwd | TAGTTTGTAGTTAGAAGGGT
T-DNA 5 rev | AACATACTATTCATTAACATC
T-DNA 6 fwd | GGATGTTAATGAATAGTATG
T-DNA 6 rev | TACCTTCTCACCAACTAAAAT
T-DNA 7 fwd | TGGTGAGAAGGTAGTAGTTTT
T-DNA 7 rev | CAATTATTAAAAAAAAACCTACC
T-DNA 8 fwd | GAAATTTGATGTTGAAGGTTTT
T-DNA 8 rev | TAATAAACCAAATTAATATC
T-DNA 9 fwd | ATATTAATTTGGTTTATTAAG
T-DNA 9 rev | ATCCCAATCATAAAAAAAAC
T-DNA 10 fwd | GGTGAAATATGGAGTTTTTT
T-DNA 10 rev | ATCATATAACTATTATCAAC
T-DNA 11 fwd | GGTTGATAATAGTTATATGA
T-DNA 11 rev | RATTAAATTTAAAAACTCCC
T-DNA 12 fwd | [NAME]
T-DNA 12 rev | CATCATATTATAACACACTTCAAC
T-DNA 13 fwd | TTTTATGATGTTGAAGTGTG
T-DNA 13 rev | CACCCTTAAATCAAATAAAAC
T-DNA 14 fwd | GTTGTTTTTGTATTGTTGATTT
T-DNA 14 rev | RTTCCTTTCAATTCTTCCACTAT
T-DNA 15 fwd | TAATAGTGGAAGAATTGAAAGGA
T-DNA 15 rev | TCTTTCCAAAAATCAACCAA
Spreadsheet: 76465d1277024853-sorting-a-football-soccer-league-table-football-season-2010-11
Sheet: PREDICTION

WEEK 1 | GAME 1 | GOOD LUCK
 | DATE | HOME TEAM |  | AWAY TEAM
1 |  |  | V
2 |  |  | V
3 |  |  | V
4 |  |  | V
5 |  |  | V
6 |  |  | V
7 |  |  | V
8 |  |  | V
9 |  |  | V
10 |  |  | V
11 |  |  | V
12 |  |  | V
13 |  |  | V
Spreadsheet: 690686d1597236906-textjoin-or-match-index-roster-test
Sheet: Day

 | Today
 | 2020-04-05 00:00:00
 |  | Skills1 | Skills2 | Skills3
E
Spreadsheet: 741225d1626920318-dynamic-written-down-value-depreciation-monthly-template-dynamic-written-down-value-depreciation-monthly-template
Sheet: josephteh

 |  |  |  |  |  |  |  | [NAME] required for yearly depreciation calculation based on changes in start date and useful life |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly deprecition (based on start date to end date) value is required based on split of yearly depreciation available as in columns (I to AL) for each year
 |  |  |  |  |  |  |  | 1 | 1
Asset class | Start Date | Useful life (year) | End Date | Opening gross block | Residual Value | Residual value % | Rate of Dep (year) | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value | Dep | Written down Value
Electrical Fittings | 2013-01-05 00:00:00 | 10 |  | 2510000 |  | 0.05
Computer | 2007-10-03 00:00:00 | 3 |  | 45000 |  | 0.05
Plant & Mahcinery | 2008-04-02 00:00:00 | 15 |  | 4800000 |  | 0.05
Furniture & Fixtures | 2015-01-13 00:00:00 | 8 |  | 1403580 |  | 0.05
https://www.excelforum.com/excel-formulas-and-functions/1355038-dynamic-written-down-value-depreciation-monthly-template.html
Spreadsheet: 139401d1328218579-count-occurances-using-two-dropdowns-based-on-criteria-accros-multiple-sheets-test
Sheet: Summary

 | AREA |  | FRUIT | TOTAL | VEHICLE | TOTAL | FURNITURE | TOTAL
 | 2 |  | apple |  | motorcar |  | chair
 | TOWNS |  | pear |  | boat |  | cupboard
 | town1 |  | orange |  | bike |  | desk
 |  |  | peach |  | bus
Spreadsheet: 883511d1732121242-calculating-percentage-returns-over-different-intervals-stock-returns-updated
Sheet: Holdings

Date_T1 | 2024-01-02 00:00:00 |  | <<Add this manually at the start of the year
Date_T2
Ticker | # [NAME] | PPS | Price Change | % Change | Market Value | % of Portfolio
AMD | 10
AVGO | 10
NVDA | 10
BRO | 10
MMC | 10
CMG | 10
AAPL | 10
MSFT | 10
MA | 10
V | 10
MCO | 10
BAC | 10
JPM | 10
COST | 10
LULU | 10
TSMC | 10
TSLA | 10
WKHS | 10
SPY | 10
VOO | 10
Total
Spreadsheet: 234e7b34-bd89-4ad9-92b6-a9faed02b292
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Human Resources | 1 | Providing excellent customer service to our clientele. Effectively and consistently communicating information to our clientele | 1.1 | Hire additional Human Resources Generalist | 1 | None | -- Pick One --
Human Resources | 1 | Providing excellent customer service to our clientele. Effectively and consistently communicating information to our clientele | 1.2 | Hire Human Resources Benefits Specialist | 3 | None | -- Pick One --
Human Resources | 1 | Providing excellent customer service to our clientele. Effectively and consistently communicating information to our clientele | 1.3 | Hire Employee Relations Specialist | 4 | None | -- Pick One --
Human Resources | 1 | Providing excellent customer service to our clientele. Effectively and consistently communicating information to our clientele | 1.4 | Effectively and consistently communicating information to our clientele | 9 | None | -- Pick One --
Human Resources | 3 | Efficiently recruit and hire qualified individuals. | 2.1 | Reduce the cycle time for recruitments | 8 | None | -- Pick One --
Human Resources | 3 | Efficiently recruit and hire qualified individuals. | 2.2 | Revisit a Mentoring Program for New Hires | 14 | None | -- Pick One --
Human Resources | 3 | Efficiently recruit and hire qualified individuals. | 2.3 | Conduct a salary survey to ensure competitive compensation | 2 | None | -- Pick One --
Human Resources | 4 | Ensure a safe and healthy working environment | 3.1 | Reduce the number of worker's compensation claims files | 12 | None | -- Pick One --
Human Resources | 4 | Ensure a safe and healthy working environment | 3.2 | Develop a Health and Wellness Program | 15 | None | -- Pick One --
Human Resources | 4 | Ensure a safe and healthy working environment | 3.3 | Provide District issued identification cards to all faculty, staff and administration. | 16 | None | -- Pick One --
Human Resources | 5 | Maintain and enhance the District Long Range Staffing Plan | 4.1 | Vice Chancellor will review staffing plan with the department. Will ensure that managers are up to date. | 6 | None | -- Pick One --
Human Resources | 2 | Human Resources Policies and Procedures | 5.1 | Update Human Resources Board Policies and Administrative Procedures | 7 | None | -- Pick One --
Human Resources | 2 | Human Resources Policies and Procedures | 5.2 | Create a Human Resources Standard Operating Procedures Manual | 5 | None | -- Pick One --
Human Resources | 2 | Human Resources Policies and Procedures | 5.3 | Develop Employee Handbook | 13 | None | -- Pick One --
Human Resources | 6 | Enhance the District's Training Program | 6.1 | Conduct a Training Needs Assessment with assistance from Environmental, Health and Safety Administrator | 10 | None | -- Pick One --
Human Resources | 6 | Enhance the District's Training Program | 6.2 | Develop a training program for managers and classified employees. | 11 | None | -- Pick One --
Spreadsheet: 271326d1381913423-countifs-a-b-c-or-d-ab-testing-stats-master
Sheet: iPhone

iPhone | Geek Culture |  |  | Science & Research |  |  | Personal/Opinion |  |  | Historic |  |  | AppStore Rating |  |  | Quotation |  |  | Anecdote/Fact |  |  | Question |  |  | App's Success |  |  | Country Specific |  |  | Endorsement |  |  | Love/Sex
 | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | %
Canada
UK
Australia
Germany
Russia
France
Sweden
Spain
Italy
Netherlands
Norway
Denmark
Korea
Turkey
Japan
Finland
Spreadsheet: 743796d1628728540-alternate-entry-when-multiplier-is-0-s-and-l-calcs
Sheet: Sheet1

Hole | Points | Running Total
1 | 2
2 | 2
3 | 2
4 | 1
5 | 0
6 | 2
7 | 3
8 | 2
Spreadsheet: 266706d1379701549-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: Combined Data

 | March | April | May | June | July | August | September | October | November | December
# of Exceptions
# of Submissions
% of exceptions
AE % share of total exceptions for month
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
AE total submissions for month | March | April | May | June | July | August | September | October | November | December
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
Average submission count
AE exception % of their individual submissions
Abdul
[NAME]
[NAME]
[NAME]
[NAME]
Dirk
Jessica
[NAME]
[NAME]
[NAME]
Kris
[NAME]
[NAME]
[NAME]
Vince
Average exception %
Exception Type by Frequency
Prelim (Missing or >45) |  |  |  |  | 15 | 7
Paystubs (>30) |  |  |  |  | 15 | 8
Asset ( >45) |  |  |  |  | 15 | 19
Asset Missing (pages or missing entirely) |  |  |  |  | 13 | 6
Missing W2 |  |  |  |  | 9 | 2
Missing 4506 |  |  |  |  | 3 | 1
Credit Report (>45) |  |  |  |  | 0 | 2
Bank Statement
Spreadsheet: 808805d1670665673-split-text-within-an-dynamic-array-does-not-work-splittext_inside_array
Sheet: Feuil1

 |  |  |  |  | expected result
level |  | level_array_exploded |  |  | level_array_exploded
a
b_c |  | b |  |  |  | c
c |  | c
a_d |  | a |  |  |  | d
a |  | a
b_c_f |  | b |  |  |  | c | f
b |  | b
b |  | b
b |  | b
Spreadsheet: 691047d1597426467-convert-to-dd-mm-yyy-hh-mm-forumexample
Sheet: LobbyVision3

Date/Time | Expected Result
7/1/2015 1:19 PM | 2015-07-01 13:19:00 | 2015-07-01 13:19:00
7/10/2015 1:00 PM | 2015-07-10 13:00:00 | 2015-07-10 13:00:00
[NAME] | 2015-07-11 19:07:00 | 2015-07-11 19:07:00
7/21/2015 12:28 PM | 2015-07-21 12:28:00 | 2015-07-21 12:28:00
7/21/2015 7:35 AM | 2015-07-21 07:35:00 | 2015-07-21 07:35:00
11/21/2015 7:35 AM |  | 2015-11-21 07:35:00
11/1/2015 7:35 AM |  | 2015-11-01 07:35:00
Spreadsheet: 199135d1355106050-an-if-statement-where-the-logical-test-is-true-but-returns-the-false-result-in-the-sheet-book1
Sheet: Sheet1

 | ANNUAL BUDGET - CALCULATIONS
 |  |  | Tenancies to exclude from calculation:
 | [NAME]
 | Area2 |  | M159 | M119
 | Area3
 | Area4
 | Area5
 | Build1
 | Build2
 | Reference | Net Letable Area | Area for Calc | Area2
 | DM01 | 196.31
 | DM01A | 39.6
 | DM02 | 89.9
 | DM03 | 276.88
 | DM05 | 90.16
 | IK01 | 15
 | M101 | 85.75
 | M102 | 129.06
 | M103 | 168.89
 | M106 | 300.75
 | M106A | 35.36
 | M109 | 120.04
 | M110 | 123.68
 | M111 | 137.43
 | M112 | 50.01
 | M113 | 461.86
 | M115 | 347.06
 | M117 | 65.89
 | M118 | 72.8
 | M119 | 36.5
 | M120 | 61.77
 | M121 | 100.68
 | M122 | 158.97
 | M124A | 93.67
 | M126 | 58.08
 | M127 | 174.41
 | M128 | 25.93
 | M131A | 31.08
 | M131B | 30.46
 | M132 | 43.24
 | M133 | 64.8
 | M134 | 223.86
 | M134A | 34.6
 | M140 | 291.28
 | M142 | 36.19
 | M143 | 46.77
 | M143B | 3.075
 | M148 | 552.67
 | M149 | 55.65
 | M149A | 27.81
 | M150 | 81.38
 | M150A | 99.25
 | M151 | 87.14
 | M152A | 133.61
 | M152B | 91.19
 | M153 | 113.32
 | M153A | 63.36
 | M154 | 77.97
 | M154A | 102
 | M154B | 156.4
 | M154C | 105.05
 | M154D | 105.06
 | M157 | 201.88
 | M157A | 92.62
 | M158 | 68.53
 | M159 | 3529.4
 | M160 | 3975.73
 | MF06 | 26.6
 | MF06A | 33.03
 | MK01 | 18.71
 | MK01A | 3.075
 | MK03 | 16
 | MK04 | 22.68
 | MK04A | 3.075
 | [NAME] | 31.66
 | T002 | 0
 | T004 | 1
 | T005 | 1
 | T006 | 1
 | T007 | 0
 | TMO | 50
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0