tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839179d1691732601-need-help-to-make-formula-based-vba-help-for-make-a-report-from-none-indexed-data-report-joh555-
Sheet: Balance

ITEM | Opening  Balance |  | Invoice No. | INWARD | OUTWARD | BALANCE
36W FITTINGS
ADORE LED 3W DEEP SPOT 3K
ADORE LED 3W DEEP SPOT 6K
ASTRAL SPOT LIGHT 2W 3000K
CENTURA PLUS LED FLOOD LIGHT 30W 6K IP65
COMET SURFACE PANEL 6W 6K RD
CRYSTA COB SWIVEL SPOTLIGHT 3W 6500K
ELEC BALLAST EL STAR SLIM-36W
E-LITELED CURVE 20W 6K
FAN  VENTIL AIR DX 250MM HAVELLS
FAZER LED PANEL 18W 6K ROUND
INNOVA NEO LED SPOT LIGHT 6W 6K RD
KETTLE TRAVEL LITE 0.5L MAROON 1000W
LED 18W GREEN FITTINGS
LED 18W NEO FITTINGS
LED ADORE 0.5W LAMP BLUE
LED ADORE 0.5W LAMP GREEN
LED ADORE 0.5W LAMP RED
LED ADORE 0.5W LAMP WHITE
LED ADORE 0.5W LAMP YELLOW
LED ADORE 10W B22 CDL 3 STAR LAMP PRPK
LED ADORE 13W B22 CDL 4 STAR BALL LAMP
LED ADORE 15W B22 CDL BALL LAMP
LED ADORE 17W B22 CDL 4 STAR LAMP
LED ADORE 2.8W B22 CDL BALL LAMP
LED ADORE 2.8W E27 CDL BALL LAMP
LED ADORE 2.8W E27 CDL CANDLE LAMP
LED ADORE 2.8W E27 WW CANDLE LAMP
LED ADORE 20W B22 CDL 3 STAR LAMP PRPK
LED ADORE 26W 865 B22 LAMP
LED ADORE 3W B22 CDL BALL LAMP
LED ADORE 3W B22 WW BALL LAMP
LED ADORE 3W B22 WW CANDLE LAMP
LED ADORE 3W E14 CDL BALL LAMP
LED ADORE 3W E14 CDL CANDLE LAMP
LED ADORE 3W E14 WW BALL LAMP
LED ADORE 3W E27 CDL BALL LAMP
LED ADORE 5W B22 CDL 3 STAR LAMP PRPK
LED ADORE 5W B22 CDL 4 STAR LAMP
LED ADORE 5W B22 WW 3 STAR LAMP PRPK
LED ADORE 5W E27 WW 3 STAR LAMP PRPK
LED ADORE 7W B22 CDL 3 STAR LAMP PRPK
LED ADORE 7W B22 CDL 4 STAR LAMP
LED ADORE 7W B22 WW 3 STAR LAMP PRPK
LED ADORE 9W B22 CDL 3 STAR LAMP PRPK
LED ADORE 9W B22 CDL 4 STAR LAMP
LED ADORE 9W E27 CDL 4 STAR LAMP
LED ADORE LAMP 3W B22 CDL CANDLE
LED ADORE LAMP 3W E14 CANDLE LAMP WW
LED ADORE NIGHT LAMP 0.5W 6500K BEAR
LED ADORE NIGHT LAMP 0.5W 6500K PANDA
LED ADORE NIGHT LAMP 0.5W 6500K PENGUIN
LED ADORE NIGHT LAMP 0.5W 6500K RABBIT
LED ADORE NIGHT LAMP 0.5W 6500K RHINO
LED ADORE NIGHT LAMP 0.5W 6500K TENNIS
LED ADORE NIGHT LAMP 0.5W 6500K TIGER
LED ASTRAL 2W BLUE
LED CRYSTA COB 10W 3000K
Spreadsheet: 160270d1339020375-filtering-one-value-out-from-multiple-values-in-a-column-test-dropsheet
Sheet: Roster

 |  |  | Route No : 1
Route No:DVP07022012_393 |  |  | Departure Time : 10:00 PM
Sl.No | EMP ID | Name | Process | Logout time | Cab No | Vendor | Signature
1 | INT792 | Punuru, Sudheer | 521690 - TIC Executive and Administration | 22:00:00 |  | SS
2 | A5839 | [NAME] | Database Management | 22:00:00
3 | A6391 | Lakshmikanth Yanamadala | Support - REAlDoc/CIS | 22:00:00
 |  |  | Route No : 2
Route No:DVP07022012_394 |  |  | Departure Time : 10:00 PM
Sl.No | EMP ID | Name | Process | Logout time | Cab No | Vendor | Signature
1 | INT650 | [NAME] | HR Generalist | 22:00:00 |  | ATT
2 | A3437 | [NAME] | Database Management | 22:00:00
3 | A3892 | [NAME] | Foreclosure | 22:00:00
4 | A1721 | Ganesh Balasubramanian | REO-RSC | 22:00:00
3 | INT797 | [NAME] | HR Generalist | 22:00:00
4 | A9774 | [NAME] | Human Resources | 22:00:00
5 | A9119 | Suja .R. Nambi | REALRemit PS | 22:00:00
 |  |  | Route No : 3
Route No:DVP07022012_387 |  |  | Departure Time : 10:00 PM
Sl.No | EMP ID | Name | Process | Logout time | Cab No | Vendor | Signature
1 | A413 | Laxani Meghana A | Database Management | 22:00:00 |  | SS
2 | A8229 | Devendra Kumar K S | DMS-FORECLOSURE | 22:00:00
2 | A7204 | Sirisha Malla | REO | 22:00:00
3 | A3171 | Puneet Goyal | CIS/REALDoc Product Support | 22:00:00
4 | A451 | CHANDAN CHOPRA | 521380 - Technology Development  Financial Services | 22:00:00
5 | A3125 | Shivam Jha | REALRemit PS | 22:00:00
 |  |  | Route No : 4
Route No:DVP07022012_388 |  |  | Departure Time : 10:00 PM
Sl.No | EMP ID | Name | Process | Logout time | Cab No | Vendor | Signature
1 | A9532 | Santosh Suvarna | Human Resources | 22:00:00 |  | CE
2 | A6674 | [NAME] | REO | 22:00:00
2 | A2944 | Abhay Shukla | Database Management | 22:00:00
3 | A9519 | [NAME] | FAM | 22:00:00
6 | A7471 | [NAME] | Real Resolution | 22:00:00
 |  |  | Route No : 5
Route No:DVP07022012_389 |  |  | Departure Time : 10:00 PM
Sl.No | EMP ID | Name | Process | Logout time | Cab No | Vendor | Signature
1 | A2308 | [NAME] | Database Management | 22:00:00 |  | TTPL
2 | A5045 | [NAME] | Database Management | 22:00:00
3 | A8753 | [NAME] | Human Resources | 22:00:00
4 | A3640 | Tayal Ankur | REO | 22:00:00
5 | A6772 | Shilpa.N | Corporate Training | 22:00:00
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: JAPN

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
2 | JAPN 101 | 1 | X | 1 | X | 1 | 4 | 1 | 4 | 1
3 | JAPN 102 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | JAPN 103 | 1 | X | 1
5 | JAPN 104 | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 831c39b1-b085-44ba-ba5c-694f15033f34
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
Auralex | [NAME] |  | I TUBETAK PRO | Room Treatments |  |  | Equipment | 8.99 | 818105003631
Auralex | Q'Fusor 21 3/4' x21 3/4' x 2 3/4' diffusor panel (White) - Box of 12 |  | I QFUSOR | Room Treatments |  |  | Equipment | 329
Auralex | Part Science PSSA22 SpaceArray |  | S PSSA22 | Room Treatments |  |  | Equipment | 399
Auralex | 2' [NAME] x 4' x 2' thick  - EACH - specify color |  | I STUDIOFOAM2 | Room Treatments |  |  | Equipment | 34
Spreadsheet: e2ee59ef-1a6e-44c3-aa66-58be69f5a580
Sheet: Sheet1

Bib | Firstname | Lastname | City | State | TeamName | Age | Gender | AgeGroup | [NAME] | Lap2 | Lap3 | Finish | AG Place | OverAll | Order | Masters | Penalty
135 | [NAME] | Wrobel | Papillion | NE | Nebraska Masters Swim Club | 48 | F | F45-49 | 00:28:19.400000 | 00:30:31.130000 | 00:20:36.160000 | 01:19:26.690000 | -- | 1 | 5
40 | Aryn | Flood | Des Moines | IA | [NAME] Traithlon | 33 | F | F30-34 | 00:30:57.270000 | 00:34:28.510000 | 00:23:04.330000 | 01:28:30.110000 | -- | 2 | 10
92 | Sue | Nutty | Omaha | NE | Nebraska Masters Swim Club | 57 | F | F55-59 | 00:33:01.910000 | 00:33:45.590000 | 00:23:32.840000 | 01:30:20.340000 | -- | 3 | 13
32 | [NAME] | [NAME] | Des Moines | IA |  | 46 | F | F45-49 | 00:32:54.280000 | 00:34:06.820000 | 00:23:43.050000 | 01:30:44.150000 | 1 | 4 | 15
115 | [NAME] | [NAME] | Des Moines | IA |  | 44 | F | F40-44 | 00:32:29.730000 | 00:34:31.990000 | 00:23:59.430000 | 01:31:01.150000 | 1 | 5 | 17
9 | [NAME] | [NAME] | [NAME] | IL |  | 24 | F | F20-24 | 00:33:04.020000 | 00:34:27.290000 | 00:24:08.800000 | 01:31:40.110000 | 1 | 6 | 18
57 | [NAME] | Hesson | Vinton | IA | MWX Tri Club | 28 | F | F25-29 | 00:34:34.100000 | 00:36:04.890000 | 00:25:22.460000 | 01:36:01.450000 | 1 | 7 | 20
63 | Becky | [NAME] | Des Moines | IA | Y rats | 40 | F | F40-44 | 00:34:01.460000 | 00:36:48.030000 | 00:26:26.430000 | 01:37:15.920000 | 2 | 8 | 21
90 | kaiti | Muelhaupt | Des Moines | IA | Y rats | 40 | F | F40-44 | 00:35:11.220000 | 00:37:12.330000 | 00:26:23.590000 | 01:38:47.140000 | 3 | 9 | 24
51 | [NAME] | Happel | Fort Dodge | IA | Milky Way Masters | 48 | F | F45-49 | 00:36:14.180000 | 00:37:23.860000 | 00:26:02.550000 | 01:39:40.590000 | 2 | 10 | 25
44 | [NAME] | [NAME] | Story City | IA |  | 32 | F | F30-34 | 00:38:37.280000 | 00:38:28.950000 | 00:27:04.630000 | 01:44:10.860000 | 1 | 11 | 28
50 | Sara | Hanley | Ankeny | IA |  | 41 | F | F40-44 | 00:46:42.280000 | 00:00:16.450000 | 01:19:53.040000 | 02:06:51.770000 | 4 | 12 | 32
Spreadsheet: 472795d1469778019-vlookup-based-on-a-criteria-account-client-wise
Sheet: Zakawdeen

NO. | IMEI | STATUS | CLIENT | PRICE | CLIENT PAID BY | CLIENT PAID ME | PAID DATE | REMARKS
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
54
55
 | TOTAL
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT
Spreadsheet: daren_farmer__5074__SDSNOM
Sheet: Sheet1

SDSNOM.xls
TO:    [NAME]
CC:   [NAME], [NAME], [NAME]/HPL
FROM:   [NAME] - TXU Fuel Company (Previously TUFCO) |  |  |  |  |  |  |  |  |  |  | June |  | 35 |  | 30
 |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
SUBJECT:   Gas Sales and Purchase Contract between TXU Fuel Co. and SDS |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
Nomination of Estimated Monthly Quantity |  |  |  |  |  |  |  |  |  |  | September |  | 25 |  | 30
 |  |  |  |  |  |  |  |  |  |  | October |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 0 |  | 30
 |  | Date |  | Estimated |  | Estimated |  |  |  |  | December |  | 24.516 |  | 31
Nomination Month |  | Nominated |  | Daily Quantity |  | Monthly Quantity
 |  |  |  | MMBtu |  | MMBtu
2001 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
January |  | 2000-12-21 00:00:00 |  | 30000
February |  | 2001-01-25 00:00:00 |  | 30000
March |  | 2001-02-22 00:00:00 |  | 20000 |  |  |  |  |  |  | January |  | 30 |  | 31
April |  | 2001-03-23 00:00:00 |  | 20000 |  |  |  |  |  |  | February |  | 30 |  | 28
May |  | 2001-04-24 00:00:00 |  | 20000 |  |  |  |  |  |  | March |  | 20 |  | 31
June |  | 2001-05-24 00:00:00 |  | 30000 |  |  |  |  |  |  | April |  | 20 |  | 30
July |  |  |  |  |  |  |  |  |  |  | May |  | 20 |  | 31
August |  |  |  |  |  |  |  |  |  |  | June |  | 30 |  | 30
September |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
October |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
November |  |  |  |  |  |  |  |  |  |  | September |  | 35 |  | 30
December |  |  |  |  |  |  |  |  |  |  | October |  | 22.1 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 0 |  | 30
 |  |  |  |  | Total |  |  |  |  |  | December |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
Note:  Please advise immediately should you have any questions concerning the above.
C:      R. Skerik
D. Avila
G. Green
M. Jones
Spreadsheet: 814584d1674498290-transfer-selected-data-from-a-master-sheet-to-another-sheet-in-a-different-cell-address-player-test
Sheet: LONDON

 |  | LONDON
 | TEE | LAST NAME | FIRST NAME | ORDER
Spreadsheet: 55491d1255610147-nested-if-statement-sample_3
Sheet: Sales Agents Performance

AM/BA | [NAME] | Performance |  | Very Low | Low | Medium | Good | Very Good
 |  |  |  | -0.8903588073316049 | 0.3979212046118568 | 2.97448122849878 | 4.262761240442241 | 5.551041252385703
 | -0.03418803418803419 | Very Low |  | 4 | 31 | 0 | 1 | 1
 | 0.2 | Very Low
 | -1.454545454545455 | Very Low
 | 5.913298747763864 | Very Good
 | 2.078165680473373 | Low
 | 1.662967142857143 | Low
 | 1.322288874288217 | Low
 | 2.181692482915718 | Low
 | 2.510054844606947 | Low
 | 1.134596957403651 | Low
 | 2.408926417370326 | Low
 | 1.280821917808219 | Low
 | 0.9927234927234927 | Low
 | 4.503560364464692 | Good
 | 0.9310344827586207 | Low
 | 2.25282722513089 | Low
 | 1.009708737864078 | Low
 | 2.968716289104639 | Low
 | 1.966618769185791 | Low
 | 2.825037707390649 | Low
 | 2.272506082725061 | Low
 | 2.752896665878458 | Low
 | 1.157601115760112 | Low
 | 2.666881147540983 | Low
 | 1.515672358355285 | Low
 | 1.286964888996139 | Low
 | -0.9 | Very Low
 | 1.573924774010061 | Low
 | 1.700892857142857 | Low
 | 0.8565759637188208 | Low
 | 1.815443592552026 | Low
 | 1.83733929569592 | Low
 | 0.9304029304029304 | Low
 | 0.9322033898305084 | Low
 | 1.489347462353597 | Low
 | 1.587097693879537 | Low
 | 2.259388148327678 | Low
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 12 - Table 2

LAS results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 33854.34600000001 | 0 | 0 | 710.3799999999901 | 34564.726 | 0.02098342115366791 | 0.02098342115366783
Net revenue | 3857.26 | 0 | -323.0505900627109 | 954.675590062711 | 4488.885 | 0.1637496564919139 | 0.2475009696164404
Net revenue/hl | 113.936922603674 | 0 | -9.346250569517343 | 25.27828743625841 | 129.868959470415 | 0.1398320799146047 | 0.2218621221163586
[NAME] | -1500.275 | 0 | 132.2273245955516 | -372.7133245955516 | -1740.761 | 0.1602946126543465 | 0.2484300042295923
[NAME]/hl | -44.31558063475808 | 0 | 3.825498995581555 | -9.87227332351 | -50.36235496268653 | 0.136448044712874 | 0.2227720630555582
Gross profit | 2356.985 | 0 | -190.8232654671592 | 581.9622654671593 | 2748.124 | 0.165948871121369 | 0.2469096177816827
Gross margin | 0.611051627320948 | 0 | 0 | 0 | 0.6122063719609658 | 10 | 0
SG&A excl. deprec.&amort. | -789.716 | 0 | 68.2546197674842 | -178.1996197674843 | -899.6610000000001 | 0.1392209351209803 | 0.22565025878605
SG&A deprec.&amort. | -71.628 | 0 | 6.812200718997204 | -13.7932007189972 | -78.609 | 0.09746188641313447 | 0.1925671625481265
SG&A total | -861.3440000000002 | 0 | 75.06682048648179 | -191.9928204864815 | -978.2699999999999 | 0.1357483189062672 | 0.2228991210091223
Other operating income/expenses | -13.899 | 0 | 3.953974304029019 | 11.98102569597098 | 2.036000000000003 | nm | nm
Normalized EBIT | 1481.742 | 0 | -111.8024706766484 | 401.9504706766488 | 1771.89 | 0.1958154658503304 | 0.2712688650768141
Normalized EBIT margin | 0.3841436667478988 | 0 | 0 | 0 | 0.394728312264627 | 110 | 70
Normalized EBITDA | 1763.988 | 0 | -131.1346594078725 | 426.4366594078727 | 2059.29 | 0.1674059007204132 | 0.2417457825154552
Normalized EBITDA margin | 0.4573163333558017 | 0 | 0 | 0 | 0.4587531202069111 | 10 | -20
Spreadsheet: a01c0ae8-e7e1-4778-b3db-1e588504c1e1
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
CRYPF | Test | CRYPF | [NAME], Pleural Fluid | Cryptococcus Ag, Pleural Fluid | Latex Agglutination | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.5 | mL | Container/Tube: Sterile vial [NAME]: 0.5 mL | 0.25 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative | Monday through Sunday; 2 p.m. | Same day\1 day | 2 days | 1 | 86403 |  |  |  |  | Rochester
CRYPF | [NAME] | PLRFLD | Pleural Fluid |  |  |  | Refrigerated | 14 days
CRYPF | Result | 60320 | Cryptococcus Ag, Pleural Fluid | Cryptococcus Ag, Pleural Fluid | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43228-6 | Cryptococcus sp Ag:ACnc:Pt:[NAME]:[NAME]:LA
Spreadsheet: 327926d1403724299-formula-for-different-options-to-return-a-value-based-upon-the-selections-example
Sheet: Torque Calculator (Example)

 | Manual Torque Calculator
 | Tubular Size & Connection |  | Outside Diameter | Inside Diameter | [NAME] | Length Of Tongs |  | Single Line Pull (Ft./Lbs.) |  | Double Line Pull (Ft./Lbs.) |  | [NAME] (PSI)
 | API NC 23 |  | 3 | 1 | 2508 |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 | API NC 26 |  | 3.75 | 1.5 | 4668 |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
 |  |  |  |  |  |  | Foot / Feet
Spreadsheet: 151e628a-e66a-43b6-a8b5-4386a348d9c4
Sheet: Primers2

OGS number | GT (Gland transcriptome) number | Usage of primers | Primer-forward | Primer-reverse | Expected length(bp) | Ta-Taq polymerase | Ta-Phusion polymerase
TC011211 | GT39 | second dsRNA | ACGCGGGGAGTTATTG | TCGTACGACTGGAGACCATG | 308 | 56 | 67
TC015151 | GT62 | second dsRNA | GCACAGTTAACATGAAAATACTTCTCCTT | GCAGGCGAAAACCGCTCACTACC | 325 | - | 69
TC015346 | GT63 | second dsRNA | GTCCAGACAAATCTCCATTTGTGC | TTTTGGATTCGGAGGATTGAGATGCG | 402 | - | 65
TC011211 | GT39 | 3'RACE | CCAGGAGAGTTGTGGGACGGTTGATT |  | >600 | 68 | -
TC011211 | GT39 | 5'RACE |  | GAGGTCATCCACGGCGGAAACAA | >400 | 67 | -
TC015151 | GT62 | 3'RACE | CGAAGGTGGCACATACGATGGATA |  | ~500 | 64 | -
TC015151 | GT62 | 5'RACE |  | GGTAGTGAGCGGTTTTCGCCTGC | >300 | 67 | -
TC015346 | GT63 | 3'RACE | TTTTCAATCATCACACTTCTGGGCGG |  | ~1500 | 68 | -
TC015346 | GT63 | 5'RACE |  | TTTTGGATTCGGAGGATTGAGATGCG | ~500 | 69 | -
Spreadsheet: 11886246-1765-4f6d-b985-b93f5a0afa47
Sheet: Sheet1

Agent Name | License Number | County | Expires | Agent Address | Agent City | Agent State | Agent Zip | Salvage Dealer Name | Region
ALMANSORI,AHMED | 057A45822 | DALLAS | 2014-10-21 00:00:00 | 2440 W IRVING BLVD #190 | IRVING | TX | 75061 | TEXAS AUTO SERVICE | DALLAS
ARELLANO,JOHNNY MEZA | 221A44701 | TAYLOR | 2015-05-07 00:00:00 | 3023 CREST RIDGE DR | DALLAS | TX | 75228 | U S A  AUTO SALES | ABILENE
BOHANNON,TINA MARIE | 220A54754 | TARRANT | 2015-07-29 00:00:00 | 1121 CANTRELL SANSOM ROAD | FORT WORTH | TX | 76131 | TRUCKCENTER.COM | FORT WORTH
CARTER,[NAME] | 057E00465 | DALLAS | 2015-02-02 00:00:00 | 7321 ASHCREST | DALLAS | TX | 75249 | PICK N PULL AUTO DISMANTLERS | DALLAS
COX,STEVEN | 015A50571 | BEXAR | 2014-10-19 00:00:00 | 7439 OBBLIGATO LN | SAN ANTONIO | TX | 78266 | CAR QUICK | SAN ANTONIO
CRUZ,JORGE OSVALDO | 108A48874 | HIDALGO | 2015-02-24 00:00:00 | 6707 VALDIVIA ST | PHARR | TX | 78577 | CRUZ AUTO SALES | PHARR
FLORES,ERNESTO ANTONIO | 227A51348 | TRAVIS | 2015-03-31 00:00:00 | 5920 LOMITA VERDE CIR | AUSTIN | TX | 78749 | ATIVO AUTO SALES | AUSTIN
HARLEY,DON WARD | 116B03088 | [NAME] | 2015-04-20 00:00:00 | 2244 HWY 69 S | GREENVILLE | TX | 75402 | WARDS AUTO PARTS & SALVAGE | DALLAS
HAYNES,PHIL D. | 188D47046 | POTTER | 2015-05-16 00:00:00 | [NAME] | [NAME] | TX | 79108 | HOWELL EQUIPMENT COMPANY | [NAME]
HOWELL,JACOB DUSTIN | 188C47046 | POTTER | 2015-05-06 00:00:00 | [NAME] | [NAME] | TX | 79108 | HOWELL EQUIPMENT COMPANY | [NAME]
[NAME],MARIE | 101A43113 | HARRIS | 2015-08-26 00:00:00 | PO BOX 722394 | HOUSTON | TX | 77272 | APEX MOTORS | HOUSTON
[NAME] | 014A31007 | BELL | 2015-08-30 00:00:00 | 626 GILL DRIVE | ABILENE | TX | 79601 | ATC AUTO GROUP | WACO
JUAN MONTOYA | 123A51391 | JEFFERSON | 2015-03-15 00:00:00 | 3148 25TH ST | PORT ARTHUR | TX | 77642 | PORT ARTHUR AUTO MOTIVE | BEAUMONT
KING,[NAME] | 020A46271 | BRAZORIA | 2015-01-10 00:00:00 | 110 TANNER ST | BRAZORIA | TX | 77422 | M & M SALVAGE | HOUSTON
MCCRARY,LEE | 037B31910 | CHEROKEE | 2015-04-27 00:00:00 | 506 FRANKSTON ST | JACKSONVILLE | TX | 75766 | DAVES AUTOMOTIVE | LONGVIEW
MELIA,WALLACE G | 101A43502 | HARRIS | 2014-12-21 00:00:00 | 10011 NORTH LOOP EAST | HOUSTON | TX | 77029 | HOUSTON FREIGHTLINER,STERLING &WESTERN STAR | HOUSTON
NGUYEN,LAN T | 220A40380 | TARRANT | 2015-05-01 00:00:00 | 1105 COLORADO LN #[NAME] | ARLINGTON | TX | 76015 | LEES BODY AUTO REPAIR SALES INC | FORT WORTH
PEREZ,[NAME] | 101B41487 | HARRIS | 2014-09-30 00:00:00 | 13502 ROBBINS RD | CYPRESS | TX | 77429 | [NAME]'S CENTRO #2 | HOUSTON
SEGOVIA,JESUS | 057B42330 | DALLAS | 2015-05-12 00:00:00 | 9810 BRIERHILL DR | DALLAS | TX | 75217 | FAMA AUTO SALES | DALLAS
TARCO,RICHARD VIRGILIO | 101A02536 | HARRIS | 2015-05-31 00:00:00 | 2635 ANNISTON DR | HOUSTON | TX | 77080 | V & R AUTO SALES | HOUSTON
[NAME],ADA LEYDA | 101A41942 | HARRIS | 2015-02-10 00:00:00 | 6310 SPRUCE FOREST | HOUSTON | TX | 77092 | MOLINA | HOUSTON
WARD,[NAME] | 116A03088 | [NAME] | 2015-04-04 00:00:00 | 2244 HWY 69 S | GREENVILLE | TX | 75402 | WARDS AUTO PARTS & SALVAGE | DALLAS
Spreadsheet: 149151d1333723168-from-alfa-numeric-data-substitute-numeric-data-data
Sheet: TEST

DATA | 1 | 2 | 3 | 4 | 5 | 10 | 20 | 30 | 40 | 50 | ALFA
1H | X |  |  |  |  |  |  |  |  |  | H
2P |  | X |  |  |  |  |  |  |  |  | P
3D |  |  | X |  |  |  |  |  |  |  | D
4M |  |  |  | X |  |  |  |  |  |  | M
5Q |  |  |  |  | X |  |  |  |  |  | Q
10H |  |  |  |  |  | X |  |  |  |  | H
11T | X |  |  |  |  | X |  |  |  |  | T
12H |  | X |  |  |  | X |  |  |  |  | H
13H |  |  | X |  |  | X |  |  |  |  | H
14H |  |  |  | X |  | X |  |  |  |  | H
15H |  |  |  |  | X | X |  |  |  |  | H
20H |  |  |  |  |  |  | X |  |  |  | H
21H | X |  |  |  |  |  | X |  |  |  | H
22H |  | X |  |  |  |  | X |  |  |  | H
23H |  |  | X |  |  |  | X |  |  |  | H
24H |  |  |  | X |  |  | X |  |  |  | H
25H |  |  |  |  | X |  | X |  |  |  | H
30H |  |  |  |  |  |  |  | X |  |  | H
31H | X |  |  |  |  |  |  | X |  |  | H
32H |  | X |  |  |  |  |  | X |  |  | H
33H |  |  | X |  |  |  |  | X |  |  | H
34H |  |  |  | X |  |  |  | X |  |  | H
35H |  |  |  |  | X |  |  | X |  |  | H
40H |  |  |  |  |  |  |  |  | X |  | H
41H | X |  |  |  |  |  |  |  | X |  | H
42H |  | X |  |  |  |  |  |  | X |  | H
43H |  |  | X |  |  |  |  |  | X |  | H
44H |  |  |  | X |  |  |  |  | X |  | H
45H |  |  |  |  | X |  |  |  | X |  | H
50H |  |  |  |  |  |  |  |  |  | X | H
51H | X |  |  |  |  |  |  |  |  | X | H
52H |  | X |  |  |  |  |  |  |  | X | H
53H |  |  | X |  |  |  |  |  |  | X | H
54H |  |  |  | X |  |  |  |  |  | X | H
55H |  |  |  |  | X |  |  |  |  | X | H
Spreadsheet: 2c84a185-d72e-4169-a210-475cc1885e60
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7840 | 17436 | [NAME] | Coto | ESP | 196 | [NAME] | 00:02:21 | 01:30:12 | 00:01:22 | 00:45:21 | 1 | 02:38:56
7840 | 58901 | Gerda | Kloet-Huybers | NED | 191 | 00:21:22 | [NAME] | 01:25:46 | 00:02:35 | [NAME] | 2 | 02:43:04
7840 | 58900 | Hilde | Van Heuveln | NED | 194 | 00:20:23 | 00:02:13 | 01:35:12 | 00:01:18 | 00:54:40 | 3 | 02:53:45
7840 | 58902 | [NAME] | [NAME] | NED | 192 | 00:24:52 | 00:02:01 | 01:38:24 | 00:01:19 | 00:54:57 | 4 | 03:01:33
7840 | 58903 | [NAME] | [NAME] | NED | 195 | 00:28:01 | [NAME] | 01:44:36 | 00:01:55 | 01:08:31 | 5 | 03:25:03
Spreadsheet: 584913d1533523170-matching-cell-values-to-check-for-duplicates-or-not-test-data-file
Sheet: Voters

DATA FILE 1 | ID 1
2 | 2
1015 | 1015
1014 | 1014
1015 | 1015
#N/A | 1016
#N/A | 1017
1018 | 1018
8 | 8
#N/A | ZZ
#N/A | 1024
#N/A | 1025
1030 | 1030
1031 | 1031
1032 | 1032
1033 | 1033
DATA FILE - 2 | ID 2
 | 2
 | 1013
 | 1014
 | 1015
 | 3
 | 4
 | 1018
 | 2
 | 2
 | 8
 | 9
 | 1
 | 11
 | XX
 | 1030
 | 1031
 | 1032
 | 1033
Spreadsheet: 598588d1542617384-working-out-a-bmr-formula-bmr-calculation
Sheet: Sheet1

 | Personal Information
 | Name
 | Age | 32
 | Height (m) | 1.76
 | Weight ([NAME]) | 80
 | BMR
 | BMI
 | PRMC Date
 | Todays Date
 | Days Remaining
 | Until PRMC
 | Personal Information
 | Name
 | Age
 | Height (m)
 | Weight ([NAME])
 | BMR
 | BMI
 | PRMC Date
 | Todays Date
 | Days Remaining
 | Until PRMC
Spreadsheet: 170692d1343362121-conditional-formatting-question-conditional-formatting-matching-records
Sheet: Sheet1

Account Number | Used
4 | 1
1
4 | 5
5
1
4 | 1
1
5
4 | 3
2
2
4 | 7
5
1
5
4 | 1
3
1
1
Spreadsheet: 586258d1534274941-matching-date-data-between-2-sheets-daily-price-4
Sheet: daily sales

SKU | Date
83-DT5000 | 2018-08-01 00:00:00 | 2018-08-02 00:00:00
total sales | 1 | 1
Daily price | 14.99 | 13.99 | I want to get the daily pricing from Format 3 page into the yellow area
83-DT5002 | 1 | 1
total sales
Daily price
83-DT5003 | 1 | 1
total sales
Daily price
Spreadsheet: a3d14bc3-2d95-40a5-b1e5-431d77ca8f63
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3839 | 8132 | [NAME] | Rolston | NZL | 0 | 00:57:28 | 00:01:06 | [NAME] | 00:01:35 | [NAME] | 1 | 03:14:48