tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 746064d1630482245-conditional-formatting-for-highlighting-month-if-dates-are-not-matched-sample1234556-1-
Sheet: Sheet1

 |  |  | Case 1 |  |  |  |  |  |  |  | Case 2
 |  |  | Month |  | Start Date | End Date |  |  |  | Start Date | End Date | Net workdays
 |  |  | 2021-08-01 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 | 5
 |  |  | 2021-08-02 00:00:00 |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 |  |  |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 | 9
 |  |  | 2021-08-03 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 | 20
 |  |  | 2021-08-04 00:00:00 |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 13
 |  |  | 2021-08-05 00:00:00 |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | 13
 |  |  | 2021-08-06 00:00:00 |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 |  |  |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | Here if the network days are not matching with [NAME] date and end date, then that particular cell to be highlighted
 |  |  | Start date, end date and month should fall within the same month . If any of the column D,F and G not matching within the month then month column should be highligted. Here [NAME], F7 adn G7 not fallling on same month hence i need to get column D7 to be highlighted nd similar to D8, F8 adn G8.
Spreadsheet: craig_dean__4353__10_26act
Sheet: Balancing

Balancing |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Load
Palo Verde |  |  |  | Artesia |  |  |  | Four Corners |  |  |  |  |  | Load |  |  | Spin
Hour | Volume | Price | Position | Hour | Volume | Price | Position | Hour | Volume | Price | Position |  | Hour | Forecast | CFE | Sum | Reserves
1 |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1 | 593.8931801059113
2 |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2 | 574.5786559337205
3 |  |  |  | 3 |  |  |  | 3 |  |  |  |  | 3 | 564.0269268475572
4 |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4 | 562.6255029515506
5 |  |  |  | 5 |  |  |  | 5 |  |  |  |  | 5 | 575.5320057599394
6 |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 | 629.0902533260534
7 |  |  |  | 7 |  |  |  | 7 |  |  |  |  | 7 | 718.6739438519002
8 |  |  |  | 8 |  |  |  | 8 |  |  |  |  | 8 | 786.7930624402995
9 |  |  |  | 9 |  |  |  | 9 |  |  |  |  | 9 | 824.4855737286546
10 |  |  |  | 10 |  |  |  | 10 |  |  |  |  | 10 | 846.242317457065
11 |  |  |  | 11 |  |  |  | 11 |  |  |  |  | 11 | 860.7178185010465
12 |  |  |  | 12 |  |  |  | 12 |  |  |  |  | 12 | 860.7488124973316
13 |  |  |  | 13 |  |  |  | 13 |  |  |  |  | 13 | 857.4795868206726
14 |  |  |  | 14 |  |  |  | 14 |  |  |  |  | 14 | 858.3966160322937
15 |  |  |  | 15 |  |  |  | 15 |  |  |  |  | 15 | 852.0760917692021
16 |  |  |  | 16 |  |  |  | 16 |  |  |  |  | 16 | 839.5706157268826
17 |  |  |  | 17 |  |  |  | 17 |  |  |  |  | 17 | 817.9170138002885
18 |  |  |  | 18 |  |  |  | 18 |  |  |  |  | 18 | 801.8741684587683
19 |  |  |  | 19 |  |  |  | 19 |  |  |  |  | 19 | 851.808786247838
20 |  |  |  | 20 |  |  |  | 20 |  |  |  |  | 20 | 878.8392086357868
21 |  |  |  | 21 |  |  |  | 21 |  |  |  |  | 21 | 854.4773211755311
22 |  |  |  | 22 |  |  |  | 22 |  |  |  |  | 22 | 801.4592566749562
23 |  |  |  | 23 |  |  |  | 23 |  |  |  |  | 23 | 721.0807479284736
24 |  |  |  | 24 |  |  |  | 24 |  |  |  |  | 24 | 645.2894465795624
Short |  |  |  | Short |  |  |  | Short
Long |  |  |  | Long |  |  |  | Long
Total |  |  |  | Total |  |  |  | Total
Spreadsheet: 84088d1284073051-sorting-data-by-sku-sku-summary
Sheet: Sheet2

 |  |  |  |  | 0
SKU | Month 1 | SKU | Month 2 |  | SKU | Month 1 | Month 2
1 | 3 | 1 | 2 |  | 1
2 | 2 | 2 | 3 |  | 2
3 | 4 | 4 | 1 |  | 3
5 | 6 | 5 | 2 |  | 4
 |  |  |  |  | 5
Spreadsheet: 233668d1367883851-list-of-names-that-needs-to-be-identical-and-updated-in-different-tables-across-sheets-example-spreadsheet
Sheet: Table2

 |  | Product Name | inventory | comments | vendor
 |  |  | 56 | words | fill
 |  |  | 4 | text | filler
 |  |  | 6 | stuff | just
 |  |  | 3 | more stuff | filling
 |  |  | 367 | things | in
 |  |  | 36 | stuff | the
 |  |  | 78 | text | space
 |  |  | 568 | words | to
 |  |  | 64 | [NAME] | have
 |  |  | 35 | blahbla | info
 |  |  | 356 | des | in
 |  |  | 68 | you | each
 |  |  | 57 | get | row
 |  |  | 46 | the | and
 |  |  | 25 | point | sort
Spreadsheet: 806969d1669702405-sum-ifs-between-dates-months-help-q-ver2
Sheet: Sheet1

MONTH | USAGE | OY # |  | OY # | Date #1 | Date #2 | Total Usage |  | Months |  | OY |  | OY | Day.1 | Day.2 | Usage
0922 | 1134.098 | OY72928 |  | OY72928 | 0922 | 1122 |  |  | 0922 |  | OY72928 |  | OY72928 | 0922 | 1122 | 9142.686
0922 | 172 | OY72928 |  | OY72085 | 1022 | 1122 |  |  | 1122 |  | OY72085 |  | OY72085 | 0922 | 1122 | 551526.997
0922 | 258 | OY72400
0922 | 78789.571 | OY72085
1022 | 2268.196 | OY72928
1022 | 344 | OY72928
1022 | 516 | OY72400
1022 | 157579.142 | OY72085
1122 | 6804.588 | OY72928
1122 | 1032 | OY72928
1122 | 1548 | OY72400
1122 | 472737.426 | OY72085
Spreadsheet: 103449d1301181729-multiplying-letters-and-numbers-copy-of-example-1-
Sheet: Sheet1

 |  |  | [NAME] | Compound Participation |  | Compound  List | CP | Reaction Formula
 | 1 | False | carbon monoxide | 0 | 1
 | 2 | False | hydrogen | 0 | 2
 | 3 | True | formic acid | 0 | 3
 | 4 | False | acetic acid | 0 | 4
 | 5 | False | propanoic acid | 0 | 5
 | 6 | False | acetone | 1 | 6
 | 7 | False | formaldehyde | 0 | 7
 | 8 | False | acetaldehyde | 0 | 8
 | 9 | False | oxaldehyde | 0 | 9
 | 10 | False | glycol aldehyde | 0 | 10
 | 11 | False | acetal | 0 | 11
 | 12 | False | cellulose acetate | 0 | 12
 | 13 | False | cellobiose | 0 | 13
 | 14 | False | fructose | 0 | 14
 | 15 | True | glucose | -1 | 15
 | 16 | False | furfurol | 0
 | 17 | False | [NAME] (5-Hydroxymethyl-2-furaldehyde) | 0
 | 18 | False | furan-2-carbaldehyde | 0
 | 19 | False | phenol | 0
 | 20 | False | isoeugenol | 0
 | 21 | False | eugenol | 0
 | 22 | False | cresol | 0
 | 23 | False | xylose | 0
 | 24 | False | furfural | 0
 | 25 | False | furfuryl alcohol | 0
 | 26 | False | methyl furan | 0
 | 27 | False | tetrahydrofurfural | 0
 | 28 | False | levulinic acid | 0
 | 29 | True | [NAME] | 0
 | 30 | False | gamma valerolactone | 0
 | 31 | False | 1,3-pentanediol | 0
 | 32 | False | 1-pentanol | 0
 | 33 | False | 2-pentanol | 0
 | 34 | False | methanol | 0
 | 35 | False | methane | 0
 | 36 | False | ethane | 0
 | 37 | False | propane | 0
 | 38 | False | n-butane | 0
 | 39 | False | n-octane | 0
 | 40 | False | [NAME] | 0
 | 41 | True | propene | 0
 | 42 | False | but-1-ene | 0
 | 43 | False | but-2-ene | 0
 | 44 | False | benzene | 0
 | 45 | False | toluene | 0
 | 46 | True | p-xylene | 2+
 | 47 | False | m-xylene | 0
 | 48 | False | o-xylene | 0
 | 49 | False | o-cresol | 0
 | 50 | False | p-cresol | 0
 | 51 | False | m-cresol | 0
 | 52 | False | indane | 0
 | 53 | False | tetralin | 0
 | 54 | False | n-nonane | 0
 | 55 | False | n-decane | 0
 | 56 | False | n-undecane | 0
 | 57 | False | n-dodecane | 0
 | 58 | False | n-tridecane | 0
 | 59 | False | 2-methyltetrahydrofuan | 0
 | 60 | True | ethanol | 2
 | 61 | False | n-pentane | 0
 | 62 | True | n-hexane | 0
 | 63 | False | carbon dioxide | 2
 | 64 | False | water | 0
 | 65 | False | glycerol | 0
 | 66 | False | [NAME] | 0
 | 67 | False | Wood | 0
 | 68 | False | BioOil | 0
 | 69 | False | [NAME] | 0
 | 70 | False | Pyrolysis Gas | 0
 | 71 | False | cellulose | 0
 | 72 | True | hemicellulose | 1+
 | 73 | True | lignin | 1+
 | 74 | False | biomass(woody) | 0
 | 75 | False | coumaryl alcohol | 0
 | 76 | False | coniferyl alcohol | 0
 | 77 | False | sinapyl alcohol | 0
 | 78 | False | [NAME]-phenylpentanoate | 0
 | 79 | False | 1-Hexene | 0
 | 80 | True | Propan-1-ol | 0
 | 81 | False | n-Butanol | 0
 | 82 | False | CycloHexane | 0
 | 83 | False | [NAME] | 0
 | 84 | False | Parrafin | 0
 | 85 | False | MTBE (tert-Butyl methyl ether ) | 0
Spreadsheet: kate_symes__19075__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-11 00:00:00 |  | 178.5 | 21120 | 115.45 | 16912
 | 2001-04-10 00:00:00 |  | 181.91 | 26368 | 109.27 | 11712
 | 2001-04-09 00:00:00 |  | 157.87 | 22000 | 113.76 | 15928
 | 2001-04-08 00:00:00 |  |  |  |  |  | 113.77 | 45888
 | 2001-04-07 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
Spreadsheet: 111468d1307834107-showing-and-calculating-dates-as-ages-yy-mm-adjusted-ages
Sheet: Ages

 |  | Actual |  |  | Adjusted
DOB | Test Date | Y | M | + or - | Y | M
2002-04-01 00:00:00 | 2011-04-01 00:00:00 |  |  | -19
2002-04-01 00:00:00 | 2011-05-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2011-06-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2011-07-01 00:00:00 |  |  | 10
2002-04-01 00:00:00 | 2011-08-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2011-09-01 00:00:00 |  |  | -5
2002-04-01 00:00:00 | 2011-10-01 00:00:00 |  |  | -9
2002-04-01 00:00:00 | 2011-11-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2011-12-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2012-01-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2012-02-01 00:00:00 |  |  | 6
2002-04-01 00:00:00 | 2012-03-01 00:00:00 |  |  | 6
Spreadsheet: 174533d1345102111-sum-if-0a32trial-f-
Sheet: Sheet1

 |  |  |  | Helper Columns |  |  |  | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | JAN |  |  | Fruits
 |  |  |  | You can hide these |  |  |  | Apple | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FEB |  |  | Apple
 |  |  |  |  |  |  |  | Orange | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | MARTC |  |  | Orange
DATE | Commodity | PRIZE |  |  |  |  |  | Grapes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | APR |  |  | Grapes
2012-06-01 00:00:00 | Apple | 2 |  |  |  |  | Annual Epenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | MAY |  |  | Total Expenses
2012-06-03 00:00:00 | Orange | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | JUN |  |  | [NAME]
2012-07-08 00:00:00 | Grapes | 2 |  |  |  |  | Month | Commodity | Expenses | Above Budget | Below Budget | South Afircan Products |  |  |  |  |  |  |  |  |  |  | 7 | JUL |  |  | Kiwi
2012-07-10 00:00:00 | Water Melon | 5 |  |  |  |  |  | Total Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | AUG |  |  | Total expenses
2012-07-16 00:00:00 | [NAME] | 5 |  |  |  |  |  | Total Expenses |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 9 | SEPT
2012-07-16 00:00:00 | Kiwi | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | OKT
2012-07-17 00:00:00 | Apple | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | NOV
2012-07-17 00:00:00 | Orange | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | DEC
2012-07-17 00:00:00 | Apple | 3
2012-07-17 00:00:00 | Orange | 5
2012-07-17 00:00:00 | Grapes | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mangoes
2012-07-17 00:00:00 | Water Melon | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pine Apple
2012-07-21 00:00:00 | [NAME] | 4.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grapes
2012-07-21 00:00:00 | Kiwi | 4.8
2012-07-22 00:00:00 | Apple | 10 |  |  |  |  |  |  |  |  | 8
2012-07-22 00:00:00 | Orange.in | 1
2012-07-22 00:00:00 | Orange.uk | 2 |  |  |  |  | Grapes
2012-07-22 00:00:00 | Orange.bl | 3 |  |  |  |  | Mangoes
2012-07-22 00:00:00 | Orange.South Africa | 2 |  |  |  |  | Pine Apple
2012-07-22 00:00:00 | Apple.South Africa | 2
2012-07-22 00:00:00 | Peach.South Africa | 6
2012-07-22 00:00:00 | Dates | 13
2012-07-22 00:00:00 | Cashew | 15
 | Pine Apple | 15
 | WD PA.Aux | 20
 | WD MN.Ind | 15
 | WD GR.SA | 30
 | Grapes | 150
Spreadsheet: 675608d1588366047-index-only-visible-cells-index-visible-cells-only
Sheet: Data

last update | Designator | Progress | R A G | SDC Name | Column1 | short activity name | Activity | Region primarily affected | Output expected / deliverables | Timeframe (date completion) | SD Theme
2020-04-24 00:00:00 | 1.01_C | 0.75 | g | Barney |  | Stuff |  |  |  |  | strategy
2020-04-24 00:00:00 | 1.02_S | 0.9 | g | Wilma |  | Build Deck |  |  |  |  | yard work
2020-04-01 00:00:00 | 1.03_S | 0.75 | g | Fred |  | Rebuild Car |  |  |  |  | boring stuff
2020-04-01 00:00:00 | 1.04_S | 0.5 | g | Barney |  | Paint House |  |  |  |  | normal work
2020-04-24 00:00:00 | 1.05_R | 1 | g | [NAME] |  | mow lawn |  |  |  |  | fitness
2020-04-24 00:00:00 | 1.06_S | 0.4 | g | [NAME] |  | Stuff |  |  |  |  | strategy
2020-04-24 00:00:00 | 1.07_C | 1 | g | Wilma |  | Build Deck |  |  |  |  | yard work
2020-04-24 00:00:00 | 1.08_R | 1 | G | Barney |  | Rebuild Car |  |  |  |  | boring stuff
2020-04-01 00:00:00 | 1.09_S | 0.5 | g | Wilma |  | Paint House |  |  |  |  | normal work
2020-04-24 00:00:00 | 1.11_S | 1 | g | Fred |  | mow lawn |  |  |  |  | fitness
2020-04-24 00:00:00 | 1.12_S | 0.5 | g | Barney |  | Stuff |  |  |  |  | strategy
2020-04-24 00:00:00 | 1.13_S | 0.25 | g | [NAME] |  | Build Deck |  |  |  |  | yard work
2020-04-24 00:00:00 | 1.14_S | 1 | g | [NAME] |  | Rebuild Car |  |  |  |  | boring stuff
2020-04-24 00:00:00 | 1.15_S | 0.75 |  | Wilma |  | Paint House |  |  |  |  | normal work
2020-04-24 00:00:00 | 1.16_S | 0.25 |  | Barney |  | mow lawn |  |  |  |  | fitness
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: SIS 

Grant: |  | School Improvement Support |  |  |  |  | School Improvement Support
CFDA # |  | 84.010 |  |  |  |  | FY2012-13 & 2013-14
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13 & 2013-14 | Funding Period March 22, 2013 - June 30, 2014
[NAME]: |  | Not allowed on this grant-verify
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2014
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
2690 | Pueblo 60 | Irving Elementary School | 44140 |  |  | 20000 | 2623
Spreadsheet: 742454d1627754673-duplicate-values-across-multiple-sheets-yard-check-digital
Sheet: Wednesday

Date: | Loaded  Trailers  - Outbound & Inbound: |  |  |  |  |  |  |  |  | CONTAINERS ON PROPERTY
Trailer #: | Location |  | Carrier |  | Inbound/Outbound |  | Date |  | Notes | Empties |  |  | Loaded
EMPTY DROP TRAILERS ON PROPERTY      -  WRITE  TRAILER #  IN  BOXES  BELOW |  |  |  |  |  |  |  |  |  |  |  |  | Red Tagged Trailers
BOYDS
CRESCO FLAT
TRINITY
CRESCO KANG
CRESCO CONEST
GRANE/CSX/ABF
EW WYLIE
JB HUNT
PRIME
RC MOTORS
CFC
CENTRAL TRANS
MELTON
WESTERN
STEVENS PIPE
DIAMOND STATE
Spreadsheet: 871335d1717718571-use-all-data-from-one-row-to-make-a-new-sheet-vt-data-sample
Sheet: Student Data

Name | Sample Student |  | Start |  |  | Badges |  |  |  | 1st attempt | 2nd attempt | 3rd attempt |  |  | 1st attempt | 2nd attempt | 3rd attempt
ID |  |  | Grad |  |  | Resume |  |  | AS110 |  |  |  |  | VT130
Status |  |  | VTNE Code |  |  | [NAME] |  |  | AS111 |  |  |  |  | [NAME]
Wonderlich |  |  | RVT |  |  | FA Exit |  |  | COMP101 |  |  |  |  | VT132
 |  |  |  |  |  |  |  |  | MTH121 |  |  |  |  | VT133
Date | Note |  |  |  |  |  |  |  | ENG122 |  |  |  |  | HUMN125
 | Make cell B2 a drop down box based on column A of All Data |  |  |  |  |  |  |  | VT120 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | VT121 |  |  |  |  | VT141
 | Then use XLOOKUP in each of the other cells |  |  |  |  |  |  |  | VT122 |  |  |  |  | VT142
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | VT143
 |  |  |  |  |  |  |  |  | MTH122
 |  |  |  |  |  |  |  |  | PSY200 |  |  |  |  | VT105
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VT150
Spreadsheet: 797479d1663917520-sum-of-product-sales-from-start-month-to-end-month-sum-of-product-sales-from-start-month-to-end-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | <- select start month
Product Sales | 2022-01-01 00:00:00 |  |  |  |  |  |  | Product Sales | 2022-04-01 00:00:00 | <- select end month
Product Sales 1 | 568 | 323 | 848 | 366 | 411 | 500 |  | Product Sales 1
Product Sales 2 | 887 | 992 | 422 | 391 | 667 | 757 |  | Product Sales 2
Product Sales 3 | 337 | 738 | 314 | 192 | 454 | 219 |  | Product Sales 3
Product Sales 4 | 960 | 150 | 190 | 872 | 206 | 670 |  | Product Sales 4
Product Sales 5 | 770 | 794 | 188 | 404 | 990 | 906 |  | Product Sales 5
Product Sales 6 | 923 | 209 | 686 | 559 | 906 | 709 |  | Product Sales 6
Product Sales 7 | 317 | 350 | 781 | 667 | 399 | 124 |  | Product Sales 7
Product Sales 8 | 980 | 715 | 590 | 717 | 544 | 107 |  | Product Sales 8
Product Sales 9 | 140 | 973 | 837 | 713 | 939 | 933 |  | Product Sales 9
Product Sales 10 | 181 | 204 | 850 | 746 | 296 | 224 |  | Product Sales 10
Product Sales 11 | 503 | 304 | 275 | 595 | 841 | 752 |  | Product Sales 11
Spreadsheet: 55b3be93-787d-4833-a724-315078d66e36
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
FMYOP | Test | FMYOP | Myositis Ab 2 Panel | Myositis Ab 2 Panel | Immunoprecipitation (IPP) and Enzyme Immunoassay (EIA) |  |  |  | 3 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). Spin down and send 3 mL of serum refrigerate in plastic vial. Note:  1. Indicate serum on request form.           2. Label specimen appropriately (serum).   [NAME] blood in a lavender-top (EDTA) tube(s). Spin down and send 3 mL of EDTA plasma refrigerate in plastic vial. Note:  1. Indicate plasma on request form.           2. Label specimen appropriately (plasma). |  | Specimens other than	Serum, plasma Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Anti-Jo-1 Ab:   Reference Range:  Negative    Negative                         <20 units Weak Positive               20-39 units Moderate Positive         40-80 units Strong Positive               >80 units     MI-2, PL-7, PL-12, EJ, OJ, SRP, KU, PM/SCL, U2 SN RNP:    [NAME]:  Negative    Test Performed By:  RDL Reference Laboratory, Inc.                               10755 Venice Boulevard                                Los Angeles, CA  90034 | Batched weekly | 14 days | 16 - 18 days |  | Profile |  |  |  |  | RDL Reference Laboratory, Inc.
FMYOP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FMYOP | Result | Z1588 | JO-1 | JO-1 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | [NAME] | MI-2 | MI-2 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2006 | PL-7 | PL-7 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2007 | PL-12 | PL-12 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2008 | EJ | EJ | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2009 | OJ | OJ | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2034 | SRP | SRP | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2010 | KU | KU | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z1586 | PM/SCL | PM/SCL | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Result | Z2033 | U2 SN RNP | U2 SN RNP | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMYOP | Billing Component | FMYOP |  | Immunoassay for analyte multiple step |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 83516
FMYOP | Billing Component | FMYOP |  | Extractable nuclear antigen |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86235
Spreadsheet: 818401d1676810655-change-if-formula-to-get-rid-of-zeros-copy-of-daily-shipments-ii-6400-
Sheet: February Data

Days of the month | Daily Shippping Goal | Daily shipments Missed | Daily Shipment | Total Shipments to Date | Total Shipments  Missed to Date |  | Total Shipments to Date |  |  |  |  |  |  |  |  |  |  | Total Shipments  Missed to Date
1 | 10 | 1
2 | 12 | 1
3 | 10 | 3
4 | 0
5 | 0
6 | 6 | 3
7 | 7 | 0
8 | 15 | 1
9 | 2 | 1
10 | 10 | 0
11 | 0
12 | 0
13 | 20 | 1
14 | 10 | 8
15 | 12 | 0
16 | 11 | 8
17 | 15 | 1
18 | 0
19 | 0
20 | 20 | 1
21 | 15 | 1
22 | 16 | 2
23 | 14 | 0
24 | 3 | 2
25 | 0
26 | 0
27 | 5 | 1
28 | 10 | 1
Spreadsheet: 152728d1335489985-automatically-transfer-data-from-master-sheet-to-others-ef91_example-book-1
Sheet: Wgtn

Area | No | Name | Flat | Address | Contact 1 | Contact 2 | CSC | Referred | Assessor | Assess Date | Install Date | Completed | Comments | Match | Wgtn
Spreadsheet: 832318d1686253788-if-statement-help-example
Sheet: Invoice

 |  |  |  | INVOICE
 |  |  |  | INVOICE # | DATE
 |  |  |  | 2023-01
BILL TO
DATE | PROJECT | [NAME] | QTY | HOURLY PRICE | AMOUNT
2023-05-22 00:00:00 | TERRAIN WORKSHOP | ESTIMATING/MEETINGS | 3
2023-05-22 00:00:00 | FOSTER | DESIGN | 4
2023-05-23 00:00:00 | FOSTER | DESIGN | 8.25
2023-05-24 00:00:00 | LAMENSDORF | DESIGN | 8.25
2023-05-25 00:00:00 | LAMENSDORF | DESIGN | 8.25
2023-05-26 00:00:00 | LAMENSDORF | DESIGN | 2.5
2023-05-26 00:00:00 | CARR | DESIGN | 1.5
2023-05-26 00:00:00 | ODOGWA | ESTIMATING | 4.25
2023-05-26 00:00:00 | ODOGWA | ESTIMATING | 0.25
2023-05-27 00:00:00 | ODOGWA | ESTIMATING | 3.5
Thank you for your business! |  |  | TOTAL
Spreadsheet: 881560d1729667815-is-there-any-other-formula-besides-vlookup-and-spill-allanortiz-vlookup-formula-spill-365-aligw
Sheet: Put formula here 

Emp. ID. No. | 0 | 0 | 0 | [NAME] | Basic Salary | Housing Allowance | Other Earnings | Deduction | 0 | 0 | 0 | 0
2340210505 | 0 | 0 | 0 |  | 5000 | 1500 | 500 | 0 | 0 | 0 | 0 | 0
2060952872 | 0 | 0 | 0 | 14000 | 10370 | 2593 | 1037 | 0 | 0 | 0 | 0 | 0
2210022188 | 0 | 0 | 0 | 8700 | 6400 | 1600 | 700 | 0 | 0 | 0 | 0 | 0
2068045588 | 0 | 0 | 0 | 6800 | 5115 | 1204 | 481 | 0 | 0 | 0 | 0 | 0
2161713041 | 0 | 0 | 0 | 6900 | 4670 | 1093 | 1185 | 48 | 0 | 0 | 0 | 0
2390118335 | 0 | 0 | 0 | 8478 | 5704 | 1426 | 1348 | 0 | 0 | 0 | 0 | 0
 |  |  | Total =