tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56499d1256670697-formula-to-show-combine-answer-and-text-in-1-cell-from-2-different-conditional-formatting
Sheet: Sheet1

 |  | Carriers----> | fedEx | FXNL | Old D | R+L | Conway | Lowest Carrier + cost | FXF | FXNL | Old D | R+L | Conway |  | fedEx | FXNL | Old D | R+L | Conway |  | FXF | FXNL | Old D | R+L | Conway
 |  | weights----> | 200 | 200 | 200 | 200 | 200 |  | 250 | 250 | 250 | 250 | 250 |  | 300 | 300 | 300 | 300 | 300 |  | 350 | 350 | 350 | 350 | 350
[NAME] | 1001 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1002 |  | 125.09 | 72 | 70 | 80 | 75.25 | $70.00    Old D | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 22 | 80 | 75.25
[NAME] | 1003 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1004 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1005 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1007 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1008 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
[NAME] | 1009 |  | 125.09 | 72 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
 |  |  | ok I want to try a different aproach on this and I hope someone can help
 |  |  | What I want to do is find the lowest dollar value out of all 5 carriers in each weight range per des zip
 |  |  | I know about the =min(D3:H3) formula which will give me the lowest value which in this case is F3 and my answer will show up in cell I3
 |  |  | What I need to know is,,,is there a way to also have the name of the lowest carrier in cell I3 as well with the cost for example see cell  I4
Spreadsheet: 849828d1700209450-calculation-of-commissions-commissions-spreadsheet
Sheet: Agente A

Ammount |  | Commissions |  |  |  | % generated from the investment
From | To | First 6 months | Next 6 months | Further 6 months | Perpetual
3000 | 25000 | 0.1 | 0.05 | 0.05 | 0.02 | 0.01
25001 | 50000 | 0.1 | 0.05 | 0.05 | 0.02 | 0.02
50001 | 100000 | 0.11 | 0.07 | 0.06 | 0.02 | 0.03
100001 | 200000 | 0.12 | 0.08 | 0.07 | 0.02 | 0.04
200001 | 300000 | 0.13 | 0.09 | 0.08 | 0.02 | 0.05
300001 | 400000 | 0.14 | 0.1 | 0.09 | 0.03 | 0.06
400001 | 500000 | 0.15 | 0.12 | 0.1 | 0.04 | 0.07
500001 | 1000000 | 0.2 | 0.15 | 0.15 | 0.05 | 0.08
 |  |  |  |  |  | 0.09
Agent name | Ammount subscribed | Commission for the Agent |  |  |  | 0.1
 | 150000 | 0 |  |  |  | 0.11
 |  | 0 |  |  |  | 0.12
 |  | 0 |  |  |  | 0.13
 |  | 0 |  |  |  | 0.14
 |  | 0 |  |  |  | 0.15
 |  | 0 |  |  |  | 0.16
 |  | 0 |  |  |  | 0.17
 |  | 0 |  |  |  | 0.18
 |  | 0 |  |  |  | 0.19
 |  | 0 |  |  |  | 0.2
total | 150000 | 0
Ammount Commission |  | 0
Spreadsheet: 839084d1691651300-how-to-create-a-dynamic-date-dynamic-date-1-
Sheet: Sheet1

 | The date is automatically update based on the Data in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | The data in this  table will be copied manually
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 |  |  |  |  |  | 2023-01-04 00:00:00 | 4 | Nokia | 150
 |  |  |  |  |  | 2023-01-04 00:00:00 | 4 | Earpod | 30
 |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 850
 |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 750
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Nokia | 150
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Earpod | 30
 |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 850
 |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 750
Spreadsheet: 677471d1589371419-aggregate-function-multiple-aggregateexample
Sheet: Sheet1

Venue | Cran
Distance | 699
 |  | Split 1 | Split 3 |  | Split 1 | Split 3
Cran | 311 | 9.34 | 17.381 |  | 7.13 | 40.73
 | 520 | 5.25 | 29.595
 | 699 | 7.13 | 40.73
[NAME] | 390 | 7.83 | 21.638
 | 450 | 6.24 | 24.751
 | 545 | 6.5 | 30.319
 | 660 | 12.42 | 37.475
Spreadsheet: c5a96384-a247-4290-a77d-236041b88f0d
Sheet: Sheet1

k | TPs | FPs | FNs | Recall | Precision
1 | 100427 | 64221 | 76735 | 0.5668653548729411 | 0.609949710898401
2 | 124139 | 97654 | 53023 | 0.700708955645116 | 0.5597065732462251
3 | 134672 | 114957 | 42490 | 0.760163014641966 | 0.5394886010840091
inf | 142545 | 131562 | 34617 | 0.804602567141938 | 0.520034147249067
Spreadsheet: 148090d1333131772-help-with-getting-unique-output-dependent-on-two-data-validation-lists-sample-book
Sheet: Sample Data

 |  | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9 | Hole 10 | Hole 11 | Hole 12 | Hole 13 | Hole 14 | Hole 15 | Hole 16 | Hole 17 | Hole 18
1 | a | 3 | 3 | 6 | 5 | 2 | 5 | 3 | 2 | 5 | 4 | 6 | 4 | 6 | 3 | 3 | 3 | 3 | 3
2 | a | 5 | 4 | 3 | 6 | 2 | 4 | 5 | 4 | 6 | 2 | 4 | 5 | 4 | 4 | 6 | 2 | 4 | 5
3 | a | 3 | 5 | 6 | 6 | 6 | 4 | 3 | 5 | 4 | 3 | 2 | 4 | 3 | 6 | 3 | 4 | 6 | 2
1 | b | 3 | 4 | 6 | 2 | 3 | 3 | 5 | 2 | 5 | 3 | 3 | 2 | 5 | 5 | 5 | 5 | 3 | 2
2 | b | 2 | 6 | 4 | 6 | 5 | 2 | 3 | 6 | 4 | 2 | 5 | 6 | 5 | 5 | 4 | 6 | 3 | 5
3 | b | 5 | 3 | 4 | 2 | 4 | 5 | 4 | 6 | 3 | 5 | 5 | 5 | 5 | 5 | 6 | 2 | 5 | 6
1 | c | 2 | 5 | 2 | 3 | 6 | 6 | 3 | 6 | 5 | 6 | 6 | 5 | 4 | 2 | 2 | 4 | 3 | 5
2 | c | 3 | 5 | 3 | 5 | 6 | 3 | 4 | 3 | 6 | 3 | 2 | 2 | 5 | 3 | 4 | 4 | 5 | 4
3 | c | 4 | 6 | 3 | 2 | 4 | 3 | 6 | 2 | 6 | 3 | 4 | 6 | 2 | 6 | 6 | 6 | 3 | 5
1 | d | 6 | 5 | 5 | 2 | 6 | 2 | 5 | 4 | 2 | 4 | 2 | 2 | 2 | 4 | 6 | 5 | 6 | 6
2 | d | 3 | 2 | 3 | 3 | 4 | 2 | 2 | 6 | 6 | 5 | 6 | 6 | 3 | 2 | 2 | 5 | 2 | 2
3 | d | 3 | 2 | 6 | 4 | 5 | 4 | 2 | 2 | 3 | 5 | 5 | 4 | 6 | 2 | 5 | 3 | 3 | 5
 |  |  |  | Players
 |  | Courses |  | ID's | Name
 |  | a |  | 1 | [NAME]
 |  | b |  | 2 | [NAME]
 |  | c |  | 3 | [NAME]
 |  | d
Spreadsheet: 855002d1704737690-formula-stops-working-when-using-dynamic-array-sample-sheet-jac
Sheet: Sheet1

 |  |  |  |  |  |  | Outcome
 | English Phrase |  |  |  |  |  | English
 | I can't believe it! We won the lottery of 345.23!  It's a mystery. Who committed the crime?  The movie was so suspenseful! I couldn't stop watching if for 2.3 hours. |  |  |  |  |  | I can't believe it! We won the lottery of 345.23!  It's a mystery. Who committed the crime?  The movie was so suspenseful! I couldn't stop watching if for 2,3 hours.
 |  |  |  |  |  |  | [NAME] returns only the initial number and I need to replace it in all iterations of dots between numbers
 | I
 | c
 | a
 | n
 | '
 | t
 | b
 | e
 | l
 | i
 | e
 | v
 | e
 | i
 | t
 | !
 | W
 | e
 | w
 | o
 | n
 | t
 | h
 | e
 | l
 | o
 | t
 | t
 | e
 | r
 | y
 | o
 | f
 | 3
 | 4
 | 5
 | .
 | 2
 | 3
 | !
 | I
 | t
 | '
 | s
 | a
 | m
 | y
 | s
 | t
 | e
 | r
 | y
 | .
 | W
 | h
 | o
 | c
 | o
 | m
 | m
 | i
 | t
 | t
 | e
 | d
 | t
 | h
 | e
 | c
 | r
 | i
 | m
 | e
 | ?
 | T
 | h
 | e
 | m
 | o
 | v
 | i
 | e
 | w
 | a
 | s
 | s
 | o
 | s
 | u
 | s
 | p
 | e
 | n
 | s
 | e
 | f
 | u
 | l
 | !
 | I
 | c
 | o
 | u
 | l
 | d
 | n
 | '
 | t
 | s
 | t
 | o
 | p
 | w
 | a
 | t
 | c
 | h
 | i
 | n
 | g
 | i
 | f
 | f
 | o
 | r
 | 2
 | .
 | 3
 | h
 | o
 | u
 | r
 | s
 | .
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 775807 | 800940
78311 |  | 273783 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
78308 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500238 | 762994 | 892601
500239 | 886988 | 798084
500293 | 410180 | 486635
500302 |  | 7672
500303 |  | 22440
500305 | 1179804 | 1263220
500307 | 78593 | 48685
500313 |  | 2311
500314
500655 | 176610
500657 | 95400 | 50392
INDEX
2002-01-31 00:00:00
2002-02-24 00:00:00
CBS Volume
Spreadsheet: 744759d1629444295-index-match-return-data-based-on-value-eh_skills-matrix
Sheet: Skills Matrix

 | Granit | [NAME] | Julie | Lauren | Lam | [NAME] | Sard |  |  |  |  | Upcoming tasks/projects
GCD | 3 | 1 | 1 | 1 | 2 | 1 | 1 |  |  |  |  | Name | Client | Start date | Capable | Allocated to
Excel | 3 | 2 | 2 | 3 | 2 | 1 | 2 |  |  |  |  | Client meeting |  | 2021-08-20 00:00:00 | Granit, [NAME], [NAME], Lauren, Lam, Sard
Tickets | 3 | 1 | 3 | 2 | 2 | 1 | 1
Coding | 3 | 2 | 2 | 1 | 2 | 1 | 3
NPDs | 2 | 2 | 3 | 1 | 3 | 1 | 2
Client meeting | 3 | 2 | 2 | 2 | 2 | 1 | 2
Off the job | 3 | 1 | 3 | 2 | 2 | 1 | 1
[NAME] | 3 | 2 | 2 | 1 | 2 | 1 | 3
PRM Testing | 2 | 2 | 3 | 1 | 3 | 1 | 2
Coding
[NAME]
Excel
GCD
NPDs
Off the job
PRM Testing
Tickets
0
Spreadsheet: e341fff4-b903-4e27-9b4a-912bcc0ba1e5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43495739 | 2014-10-08 21:00:31 | AXIS | 1 | 6 | 4 | 417473 | aikobo | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43495991 | 2014-10-08 21:14:06 | ALLIES | 0 | 1 | 6 | 417473 | aikobo | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43496247 | 2014-10-08 21:46:33 | AXIS | 1 | 10 | 6 | 1617192 | Spernatz42 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43496702 | 2014-10-08 22:11:54 | ALLIES | 0 | 5 | 10 | 1617192 | Spernatz42 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43504565 | 2014-10-09 13:07:09 | ALLIES | 1 | 6 | 4 | 1542223 | Barkhorn4 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43504719 | 2014-10-09 13:25:30 | AXIS | 0 | 5 | 6 | 1542223 | Barkhorn4 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43562682 | 2014-10-13 11:58:22 | ALLIES | 0 | 4 | 6 | 1599575 | lukgostynski | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
43562805 | 2014-10-13 12:12:58 | AXIS | 1 | 6 | 1 | 1599575 | lukgostynski | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
43562916 | 2014-10-13 12:37:15 | AXIS | 1 | 6 | 1 | 1599575 | lukgostynski | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43576240 | 2014-10-14 09:01:01 | ALLIES | 1 | 7 | 4 | 979406 | homez | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
43595442 | 2014-10-15 20:39:02 | AXIS | 0 | 4 | 6 | 1218527 | platypus44 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
43595596 | 2014-10-15 20:57:41 | ALLIES | 0 | 5 | 6 | 1218527 | platypus44 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
Spreadsheet: 682033d1591882990-have-slicer-generate-slicers-depending-on-selection-car-brands-and-models-gtotheurra-
Sheet: Blad1

Car brands |  |  | Volvo |  | Saab |  |  |  | Brand | Model |  | Brand | Model
Volvo |  |  | V40 |  | Saab 900 |  |  |  | Volvo | V40 |  | Volvo | S60
SAAB |  |  | S60 |  | Saab 99 |  |  |  | Volvo | S60 |  |  | V40
 |  |  | V70 |  | Saab |  |  |  | Volvo | V70 |  |  | V70
 |  |  |  |  |  |  |  |  | SAAB | Saab 900
 |  |  |  |  |  |  |  |  | SAAB | Saab 99
 |  |  |  |  |  |  |  |  | SAAB | Saab
Row Labels |  |  | Row Labels |  | Row Labels
SAAB |  |  | S60 |  | Saab
Volvo |  |  | V40 |  | Saab 900
Grand Total |  |  | V70 |  | Saab 99
 |  |  | Grand Total |  | Grand Total
Spreadsheet: 0264969a-a5ab-4584-adb1-9d0d2c229817
Sheet: Degrees

Degrees
C& I meeting Date | New Degrees | [NAME] | Modification Details | [NAME] | Effective Date | Approved by AA | Date BOT approved | CO's Approval Date
2013-05-08 00:00:00 | NA | Speech Communications AA degree | Delete SPCH 100 and SPCH 107 form the list of elective courses on the degree.
2013-05-08 00:00:00 | AA T Geograpgy Degree | NA | NA | NA |  | 2013-06-24 00:00:00 | 2013-07-20 00:00:00
2013-06-12 00:00:00 | AS T Administration of Justice Degree | NA | NA | NA |  | 2013-06-24 00:00:00 | 2013-07-20 00:00:00
2013-06-12 00:00:00 | AST Business Administration Degree | NA | NA | NA |  | 2013-06-24 00:00:00 | 2013-07-20 00:00:00
2013-06-12 00:00:00 | AS T Physics Degree | NA | NA | NA |  | 2013-06-24 00:00:00 | 2013-07-20 00:00:00
2013-06-12 00:00:00 | AA T English Degree | NA | NA | NA |  | 2013-06-24 00:00:00 | 2013-07-20 00:00:00
Spreadsheet: d776d21e-3993-4768-b518-a76370f56c09
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
CD4NY | Test | CD4NY | CD4 Count for Monitoring, New York, Blood | CD4 T-Cell Count, New York | Flow Cytometry, Single Platform (CD3, CD4, CD8, CD45) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | [NAME] must arrive within 48 hours of draw. Draw and package specimen as close to shipping time as possible. Ship specimen overnight.   Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Do not aliquot.  Additional Information:  1. Date of draw is required. 2. For serial monitoring, we recommend that specimen draws be performed at the same time of day. | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	NA Other	ACD, sodium heparin, or lithium heparin blood specimen; or specimen in aliquot tube (not in original [NAME]) | The appropriate age-related reference values will be provided on the report. | Monday through Sunday | 3 days | 4 days |  | Profile |  |  |  |  | Rochester
CD4NY | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 48 hours
CD4NY | Result | 3321 | CD45 [NAME], Flow | CD45 [NAME], Flow | Numeric |  |  |  |  | thou/mcL |  |  |  |  |  |  |  |  |  | 27071-0 | Cells.CD45:NCnc:Pt:[NAME]:Qn:
CD4NY | Result | 3316 | % CD3 (T Cells) | % CD3 (T Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 8124-0 | Cells.CD3/100 cells:NFr:Pt:[NAME]:Qn:
CD4NY | Result | 3319 | % CD4 (Helper Cells) | % CD4 (Helper Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process | Cells.CD4/100 cells:NFr:Pt:[NAME]:Qn:
CD4NY | Result | 3320 | % CD8 (Supp'r Cells) | % CD8 (Supp'r Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process | Cells.CD8/100 cells:NFr:Pt:[NAME]:Qn:
CD4NY | Result | 3322 | CD3 (T Cells) | CD3 (T Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | In Process | Cells.CD3:NCnc:Pt:[NAME]:Qn:
CD4NY | Result | 3325 | CD4 (Helper Cells) | CD4 (Helper Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | In Process | Cells.CD4:NCnc:Pt:[NAME]:Qn:
CD4NY | Result | 3326 | CD8 (Supp'r Cells) | CD8 (Supp'r Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | In Process | Cells.CD8:NCnc:Pt:[NAME]:Qn:
CD4NY | Result | 3327 | H/S Ratio | H/S Ratio | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process | Cells.CD4/Cells.CD8:NRto:Pt:[NAME]:Qn:
CD4NY | Result | 28358 | Reviewed by | Reviewed by | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CD4NY | Billing Component | CD4NY |  | Absolute CD4/CD8 Count |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86360
CD4NY | Billing Component | CD4NY |  | T-cells total count |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86359
Spreadsheet: 708688d1607968318-how-to-move-data-from-rows-to-columns-while-skipping-some-rows-sample-address
Sheet: Raw

EMPLOYEE NAME | Street | City, State, Zip
[NAME], [NAME] | 57 Main St | FRESNO CA  93737
57 Main St
FRESNO CA  93737
[NAME], [NAME] | 107 Pine St | FRESNO CA  93705
107 Pine St
FRESNO CA  93705
Jones, [NAME]
8742 1st st
FRESNO  CA  93704
Jones, [NAME]
1432 5th St
FRESNO  CA  93710
[NAME], [NAME]
1 Disney Way
FRESNO  CA  93704
Mouse, Minnie
2 Disney Way
FRESNO  CA  93710
Spreadsheet: 198628d1354834284-help-with-vlookup-book10
Sheet: Sheet2

Date | [NAME] | ID # | Account | Country | Name
2012-12-05 00:00:00 | Yes | number | account | country | [NAME]
2012-12-05 00:00:00 | No | number | account | country | [NAME]
2012-12-05 00:00:00 | No | number | account | country | [NAME]
2012-12-05 00:00:00 | Yes | number | account | country | Elena
Spreadsheet: 27396d1220571302-multiple-criteria-formula-populate-based-on-criteria1
Sheet: Sheet1

 | DATA |  |  |  |  | [NAME]
 | Policy Number | Code | Date |  |  | Policy Number | Medical | Non Medical | Date
 | 11224578 | B21 | 2008-09-04 00:00:00 |  |  | 11224578 |  | 11224578 | 2008-09-15 00:00:00
 | 11224578 | B21 | 2008-09-05 00:00:00 |  |  | 11224579 |  | 11224579 | 2008-09-04 00:00:00
 | 11224578 | B21 | 2008-09-06 00:00:00 |  |  | 11224580 |  | 11224580 | 2008-09-05 00:00:00
 | 11224578 | B21 | 2008-09-07 00:00:00 |  |  | 11224581 | 11224581 |  | 2008-09-06 00:00:00
 | 11224578 | B21 | 2008-09-08 00:00:00 |  |  | 11224582 | 11224582 |  | 2008-09-10 00:00:00
 | 11224578 | B26 | 2008-09-09 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B27 | 2008-09-10 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B28 | 2008-09-11 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B29 | 2008-09-12 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B30 | 2008-09-13 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B31 | 2008-09-14 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224578 | B32 | 2008-09-15 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224579 | B33 | 2008-09-04 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224580 | B34 | 2008-09-05 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224581 | B04 | 2008-09-06 00:00:00 |  |  |  |  | 0 | #N/A
 | 11224582 | B05 | 2008-09-07 00:00:00
 | 11224582 | B37 | 2008-09-08 00:00:00
 | 11224582 | B38 | 2008-09-09 00:00:00
 | 11224582 | [NAME] | 2008-09-10 00:00:00
Spreadsheet: 160606d1339138741-finding-player-and-avg-top-3-scores-copy-of-copy-of-ringer-percent-experiment4
Sheet: Sheet2

 |  |  |  |  |  | bc canstat
card # | Name |  | Prov | Div | ringer avg | best 3 avg | events
614111 | Smith | [NAME] | bc |  | 43.85714285714285 | #N/A | 7
614112 | Cole | [NAME] | bc |  | 2.4 | #N/A | 5
614016 | Moffat | [NAME] | bc |  | 1.375 | #N/A | 8
Spreadsheet: 328576d1403951927-how-to-increment-only-number-in-list-when-it-contains-both-number-and-alphabets-book1
Sheet: Sheet4

001_TCO_BGH_AG | 001 | _TCO_GHJ
002_TCO_BGH_AG | 002
 | 003
 | 004
 | 005
 | 006
 | 007
 | 008
 | 009
 | 010
 | 011
 | 012
 | 013
 | 014
 | 015
 | 016
 | 017
 | 018
 | 019
 | 020
 | 021
Spreadsheet: 218387d1362440395-return-the-unique-data-from-a-list-unique
Sheet: Sheet3

1 | 311 |  |  |  |  | list
2 | 311
3 | 222
4 | 156
5 | 156
6 | 156
7
8
9
10
Spreadsheet: 668589d1584909736-hundreds-of-row-hundreds-of-tabs-there-has-to-be-a-faster-way-sample
Sheet: 001

 |  |  |  | Sole Source: |  | QTY: |  | Spares: | 0 | LOA Line: | Index!A1 | Costs:
Note:  (Note 1, 188)  - This item will resist XXXXX.  Condense training.  This line provides for the production of twelve XXXX Block XXXXX to  include, but  not  limited  to: [NAME] to LO-D-SAA Signed 2 |  |  |  |  |  |  |  |  |  |  |  | (a) Unit | (b) Line Value
# | Item | NSN | PN | Need Date | Date Ordered | Document/ Requisition Number |  | Date Delivered | Date Installed | XXXX Installed | Line Manager Code | $ | $
1 | [NAME] and In Depth Module Sim | XXXX | XXXX | 2022-01-01 00:00:00 | 2020-11-19 00:00:00 | 458994521 |  | -- |  |  |  | 51937377.91
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
S
S
S
S
S
Spreadsheet: phillip_m_love__30687__OA Form
Sheet: OA Form

 |  |  |  |  |  |  |  |  |  |  |  | ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  | Date Prepared:
 |  |  |  |  |  |  |  |  |  |  |  | ENERGY OPERATIONS |  |  |  |  |  |  |  | Time Prepared:
 |  |  |  |  |  |  |  |  | OPERATIONAL ANALYSIS FORM
REGION: |  | HPLC 012 |  |  |  |  |  |  |  |  | Client Services Input |  |  |  |  |  |  |  | Adjustment by Gas Accounting
PROD MONTH: |  | 2000-02-01 00:00:00 |  |  |  |  |  |  | ECONOMIC ESTIMATE |  | DOWNLOAD UNIFY (G/L EST.) |  | UNIFY/GL SHOULD BE |  |  |  |  |  | MANUAL ACCRUALS |  | ECONOMIC ESTIMATE  ADJ.
TRANS TYPE: |  | S |  |  |  |  |  |  | A |  | B |  | C |  |  |  |  |  | C - B |  | C - A
(S or P) |  |  |  |  |  |  | VOLUME |  |  |  | 3012982 |  | 3023442
 |  |  |  |  |  |  | RATE |  |  |  |  |  |  |  |  |  |  |  |  |  | -
COUNTERPARTY: |  | Mobil Oil - Beaumont |  |  |  |  | AMOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  | -
CONTRACT #: |  | 96001534 |  |  |  |  | MISC. CHARGES*
Sitara #: |  | 93472 |  |  |  |  | LIQUIDATION |  |  |  | - |  | 0 |  |  |  |  |  | -
TAGG #: |  | ee9211 |  |  |  |  | TOTAL AMOUNT
 |  |  |  |  |  |  | NET RATE
FACILITY #: |  | 1040, 1576
 |  |  |  |  |  |  | FIRM VOLUME |  | 2610000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UAF RATE |  | 2.516
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET P/(L) IMPACT
ACCT COORD: |  | [NAME] |  |  |  |  | TRANSFERS
EXTENSION: |  | 35060 |  |  |  |  |  |  |  |  | (FROM) |  | TO |  |  | LIQUIDATION TRANSFERS
 |  |  |  |  |  |  |  |  | COUNTERPARTY/REGION |  |  |  |  |  |  |  |  |  | (FROM) |  | TO
 |  |  |  |  |  |  |  |  | VOLUME |  | 0 |  | 0 |  |  | REGION
 |  |  |  |  |  |  | Transfer Type (Econ. or Unify): |  | RATE |  | 0 |  | 0 |  |  | TRANSACTION TYPE
 |  |  |  |  |  |  |  |  | AMOUNT |  |  |  |  |  |  | COUNTERPARTY
APPROVAL: |  |  |  | DATE: |  |  |  |  |  |  |  |  |  |  |  | AMOUNT
 |  |  |  |  |  |  |  |  | UAF REGION RATE
Deal Validation |  |  |  |  |  |  |  |  | UAF RATE
 |  |  |  |  |  |  |  |  | NET P/(L) IMPACT
APPROVAL: |  |  |  | DATE: |  |  |  |  |  |  |  |  |  | Economic Impact for Desk Price vs. Volume Variances
Economics |  |  |  |  |  |  | Desk Price [NAME] |  |  |  | Correct Desk Price |  |  |  |  |  |  | Price [NAME]
 |  |  |  |  |  |  | Customer Price [NAME] |  |  |  | Correct Customer Price |  |  |  |  |  |  | Volume Variance
APPROVAL: |  |  |  | DATE: |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Estimate Variance
Logistics/Volume Mgmt. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UA4 Volume Variance
APPROVAL: |  |  |  | DATE: |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Variance
OA
 |  |  |  |  |  |  | REASON FOR [NAME]: |  | [NAME] updated after flash
 |  |  |  |  |  |  | OA REASON CODE: |  | C-Volume
Spreadsheet: 706517d1606753922-how-to-convert-price-in-eur-from-a-column-with-many-currencies-values-and-n-a-values-clean-data
Sheet: GDP

Country | GDP (millions) | Level |  |  |  | Level of GDP
FRANCE | 2715518.27422745 |  |  |  |  | Low
SPAIN | 1394116.31076863 |  |  |  |  | Medium
PORTUGAL | 237686.075634698 |  |  |  |  | High
ITALY | 2001244.39204157
GERMANY | 3845630.03082352
USA | 21427700
AUSTRALIA | 1392680.58932914
NEW-ZEALAND | 206928.765543935
DENMARK | 348078.018463905
BRAZIL | 1839758.04076562
POLAND | 592164.400687607
ALGERIA | 169988.236398126
MOROCCO | 118725.27959613
UK | 2827113.18469558
CANADA | 1736425.62951996
RUSSIA | 1699876.57887135