tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 483724d1475811329-inventory-issues-counting-multiple-upc-codes-and-specifying-location-inventory-issues-counting-multiple-upc-codes-and-specifying-location-v2
Sheet: Sheet3

All UPCs | 1st of uniques | Uniques |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | t | u | v | w | x | y | z
Spreadsheet: andrea_ring__46__BRLH Storage
Sheet: Aug01

August  '01 STORAGE ACTIVITY
 | ENA
Contract | 96034600
[NAME] | 85850
[NAME] | 150000
[NAME] | 2500000
 | K term: 2/28/10
Day | Injection | Withdrawal
2001-08-01 00:00:00 |  | -11390
2001-08-02 00:00:00 |  | -100711
2001-08-03 00:00:00 |  | -101196
2001-08-04 00:00:00 |  | -145000
2001-08-05 00:00:00 |  | -146846
2001-08-06 00:00:00 |  | -150000
2001-08-07 00:00:00 |  | -121704
2001-08-08 00:00:00 |  | -119069
2001-08-09 00:00:00 |  | -117757
2001-08-10 00:00:00 |  | -88851
2001-08-11 00:00:00 |  | -126316
2001-08-12 00:00:00 |  | -126316
2001-08-13 00:00:00 |  | -126316
2001-08-14 00:00:00 |  | -57696
2001-08-15 00:00:00 | 8630 | -44849
2001-08-16 00:00:00 |  | -43101
2001-08-17 00:00:00 |  | -55088
2001-08-18 00:00:00 |  | -55796
2001-08-19 00:00:00 |  | -55799
2001-08-20 00:00:00 |  | -60799
2001-08-21 00:00:00 |  | -78944
2001-08-22 00:00:00 |  | -62605
2001-08-23 00:00:00 |  | -110042
2001-08-24 00:00:00 |  | -62614
2001-08-25 00:00:00 |  | -41840
2001-08-26 00:00:00 |  | -48639
2001-08-27 00:00:00 |  | -72707
2001-08-28 00:00:00 |  | -64239
2001-08-29 00:00:00 |  | -17164
2001-08-30 00:00:00 |  | -68413
2001-08-31 00:00:00 |  | -11910
Current Month
Fuel 1%
Current Month Activity
Previous Month Bal | 2503429
[NAME]
Available Capacity
Spreadsheet: 861857d1709687879-vlookup-to-subtract-using-indirect-and-column-functions-vlookup-indirect-column-formula
Sheet: Sheet5

NODE | X | Y | HEADU
363574 | 623750 | 7156250 | 100
363575 | 625250 | 7156250 | 586.8925
363576 | 628250 | 7156250 | 590.3536
363577 | 629750 | 7156250 | 609.9778
Spreadsheet: 14d1e3d6-f40d-4db7-bf4c-15534ff361a0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | FORMULAIRE C
ORGANISATION DE L'AVIATION CIVILE INTERNATIONALE
FORMULAIRE DU TRANSPORT AÉRIEN
TRAFIC PAR ÉTAPES (TFS)
Services réguliers  (payants) - Trafic international
Personnes à contacter : |  |  |  |  |  | État :
Organisation : |  |  |  |  |  | Compagnie aérienne :
Tél. :
Fax : |  |  |  |  |  | Année :
C. élect. :
Aéroports |  |  |  | Capacité offerte |  | Trafic payant
 |  |  |  |  | Capacité
 |  |  |  | Nombre | [NAME]
 |  |  |  | de sièges- | charge payante | Passagers | Fret | Poste
De | À | Type d'aéronef | Nombre de vols | passagers | (tonnes) | (nombre | (tonnes) | (tonnes)
a | b | c | d | e | f | g | h | i
Observations (y compris indication des cas où il a été impossible de se conformer aux  instructions) :
Au besoin, utiliser des feuilles supplémentaires.
Spreadsheet: 16768864-cb1f-44d2-8024-e63b9b076ec6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7385 | 21290 | [NAME] | [NAME] | GBR | 0 | 00:27:26 | 00:03:55 | [NAME] | 00:02:09 | 00:58:51 | 1 | 02:55:27
7385 | 57445 | [NAME] | Iftach | ISR | 0 | 00:55:39 | 00:07:29 | 01:43:31 | 00:00:00 | 00:00:00 | 2 | 03:54:20
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: B

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: a4358eee-5559-471b-a58e-024a3dea473b
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
NITU | Test | NITU | Nitrogen, Total, [NAME] | Nitrogen, Total, U | [NAME] | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions: 1. 24-Hour volume is required. 2. Collect urine for 24 hours. 3. No preservative.  Additional Information: See Urine Preservatives in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Yes Frozen	Preferred 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	No Thymol	Yes Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 2 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | <16 years: not established > or =16 years: 4-20 g/24 hours | Monday, Wednesday, Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 4 days | 1 | 84999 |  |  |  |  | Rochester
NITU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
NITU | Order Question | DUR8 | Collection Duration |  | Plain Text
NITU | Order Question | TOTV | [NAME] |  | Plain Text
NITU | Result | DUR8 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
NITU | Result | TOTV | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9
NITU | Result | 17418 | Nitrogen, Total, U | Nitrogen, Total, U | Numeric |  |  |  |  | g/24 h |  |  |  |  |  |  |  |  |  | 2660-9
Spreadsheet: 95410d1295006318-condition-conditions
Sheet: Complexity

Type of Part | Hours | Complexity
Type 1 | 5 |  | Type of Part | [NAME] required in Cell C2 as follows
Type 1 |  |  | Type 1 | If Type of Part in Cell A2 = Type 1 or Type 2 or Type 3 or …….Type 12, and if B2<=9 then simple, if [NAME] then medium,
Type 1 |  |  | Type 2 | if B2>20 then complex or If Type of Part in cell A2 = Cast 1 or Cast 2 or Cast 3 or Cast 4 or ……….Cast 38,
Type 1 |  |  | Type 3 | and if B2<=45 then simple , if B2<=90 then medium, if B2>90 then complex.
Type 1 |  |  | Type 4
Type 1 |  |  | Type 5
Type 1 |  |  | Type 6
Type 1 |  |  | Type 7
Type 1 |  |  | Type 8
Type 1 |  |  | Type 9
Type 1 |  |  | Type 10
Type 1 |  |  | Type 11
Type 1 |  |  | Type 12
Type 1 |  |  | Cast 1
Type 1 |  |  | Cast 2
Type 1 |  |  | Cast 3
Type 1 |  |  | Cast 4
Type 1 |  |  | Cast 5
Type 1 |  |  | Cast 6
Type 1 |  |  | Cast 7
Type 1 |  |  | Cast 8
Type 1 |  |  | Cast 9
Type 1 |  |  | Cast 10
Type 1 |  |  | Cast 11
Type 1 |  |  | Cast 12
Type 1 |  |  | Cast 13
Type 1 |  |  | Cast 14
Type 1 |  |  | Cast 15
Type 1 |  |  | Cast 16
Type 1 |  |  | Cast 17
Type 1 |  |  | Cast 18
Type 1 |  |  | Cast 19
Type 1 |  |  | Cast 20
Type 1 |  |  | Cast 21
Type 1 |  |  | Cast 22
Type 1 |  |  | Cast 23
Type 1 |  |  | Cast 24
Type 1 |  |  | Cast 25
Type 1 |  |  | Cast 26
Type 1 |  |  | Cast 27
Type 1 |  |  | Cast 28
Type 1 |  |  | Cast 29
Type 1 |  |  | Cast 30
Type 1 |  |  | Cast 31
Type 1 |  |  | Cast 32
Type 1 |  |  | Cast 33
Type 1 |  |  | Cast 34
Type 1 |  |  | Cast 35
Type 1 |  |  | Cast 36
Type 1 |  |  | Cast 37
Type 1 |  |  | Cast 38
Spreadsheet: 60758d1261319686-searching-2-conditions-in-a-table-count-2-conditions
Sheet: Sheet1

a | 1 | 2 | 5 | 6 | 9 |  |  | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7
b | 3 | 4 | 7 | 8 | 9 |  |  | 1 |  | 2 | 0 | 1 | 1 | 2 | 0
c | 1 | 2 | 6 | 4 | 8 |  |  | 2 | 2 |  | 0 | 1 | 1 | 2 | 0
d | 7 | 9 | 6 | 5 | 4 |  |  | 3 | 0 | 0 |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 4 | 1 | 1 | 1 |  | 0 | 2 | 0
 |  |  |  |  |  |  |  | 5 | 1 | 1 | 0 | 0 |  | 2 | 1
 |  |  | I'm trying to do a conditional formula i.e. countif for each line there is a number 1, countif there is also a number 2 within the grid on the horizontal lines a-d. I would then go on to do the same for number 2,3,4 etc.  I'd be happy to do it in VB but am only a VB beginner so may need some prompting. I need to do the count for each number up to 20 on a bigger grid.  =IF(1,B1:F4,(COUNTIF(B1:F4,2))"") was my attempt! |  |  |  |  | 6 | 2 | 2 | 0 | 2 | 2 |  | 1
 |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 1 | 1 | 1 | 2
Spreadsheet: 105926d1303206683-count-formula-cf
Sheet: Sheet1

 | Status 1 | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | a | A | A | A | A | A | A | A | A | A | A
Formula Condition`s | Status 2 | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B
For Status 1, I need to write a formula to count "A" from ([NAME]) and highlight the cell count equal 30, which is (AF5)
For Status 2, I need to write a formula to count "B" from (C4:AP4) and highlight the cell count equal 40, which is (AP6)
For Status 1, I need to write a formula to count "A" from ([NAME]) and highlight the cell count equal 15, which is (Q7)
Note:No need to add any extra data to this sheet, it should be remain as it is.
Spreadsheet: 83699d1283722048-league-rank-lfc-chess
Sheet: Sheet1

Liverpool FC Chess League
Rank | Name | Played | Won | Lost | [NAME] | Games Won | Games Lost | Game Difference | Points
 | Player 1 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 2 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 3 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 4 |  | 0 | 0 | 0 | 0 | 0
 | Player 5 |  | 0 | 0 | 0 | 0 | 0
 | Player 6 |  | 0 | 0 | 0 | 0 | 0
 | Player 7 |  | 0 | 0 | 0 | 0 | 0
 | Player 8 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 142375d1329804951-value-cell-not-calculating-correctly-or-not-at-all-2-bid-fee-tabulation
Sheet: Contract Numbers

Discipline | Company | Phase I                                         Survey, Landlord App'l Package |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Architect | 300 | 1000 | 5000 | 2000 | 850 | 8300
 | Estimated Reimbursables | 50 | 100 | 500 | 200
Mechanical, Electrical & Plumbing
 | ENG A | 5 | 6 | 7 | 8 | 9 | 26
 | Estimated Reimbursables | 2 |  | 3 | 4
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Fire Protection
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil
 | CIVIL A | 1 | 2 | 3 | 4 | 6 | 10
 | Estimated Reimbursables | 1 |  | 2 | 3
Bldg. Dept. Plan Review Fees
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Geotechnical
 | GEO B | 2 | 8 | 3 | 5 | 9 | 18
 | Estimated Reimbursables | 1 |  | 3 | 5
Skylight Energy Modeling
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Expediter & Third Party Reviewer
 |  |  |  | 1500 |  | 0 | 1500
 | Estimated Reimbursables
Landscape
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 | Reimbursable Sub-total Per Phase | 54 | 100 | 508 | 212
 | SUB-TOTALS PER PHASE | #N/A | #N/A | #N/A | #N/A | 874 | 9854
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | #N/A
REIMBURSABLES | 874
GRAND TOTAL | #N/A
Spreadsheet: 862313d1710062621-dynamic-formula-to-calculate-ordinary-time-overtime-based-on-day-of-week-and-day-night-maggie-090324-query
Sheet: HOURS

[NAME] | Date of Shift | Start Time | End Time | Break Time | Total Hours | Ordinary Hours | Double Time
DAY | 2024-03-01 00:00:00 | 7:00:00 | 15:30:00 | 30 | 8
Night | 2024-02-29 00:00:00 | 7:00:00 | 17:30:00 | 30 | 10
shift | 2024-02-27 00:00:00 | 7:00:00 | 16:30:00 | 30 | 9
DAY | 2024-02-27 00:00:00 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2024-02-18 00:00:00 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2024-02-27 00:00:00 | 7:00:00 | 17:00:00 | 30 | 9.5
DAY | 2024-01-03 00:00:00 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2024-02-28 00:00:00 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2024-02-29 00:00:00 | 7:00:00 | 15:30:00 | 30 | 2
Spreadsheet: 1353bde9-e88e-4dc1-9141-2c4a418836d9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | [NAME] | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  | Bellows-Falso
 | [NAME] |  | AveryStorti | D.W. Bellows | Berarducci | [NAME] | Bright | [NAME]
Basic Service Fee | 1695 |  | 2395 | 1875 | 1950 | TOTALLY | 1145 | 1995
Embalming | 425 |  | 695 | 650 | 450 | OUT OF | 375 | 575
Other Prep. (dressing, makeup) | 125 |  | 295 | 175 | 200 | FTC | 75 | 150
Viewing | 175 |  | 275 | 375 | 400 | COMPLIANCE | 325 | 490
Funeral Ceremony | 525 |  | 375 | 550 | 250 |  | 310 | 490
Body Removal | 300 |  | 325 | 230 | 225 | IMPOSSIBLE | 225 | 195
Hearse | 270 |  | 350 | 260 | 275 | TO | 270 | 240
[NAME] | 270 |  | 350 | 260 | 275 | INTERPRET | 270 | 195
Graveside Service | 395 |  | 375 | 450 | 250 |  | 250 | 490
Total Full Service Funeral | 4180 |  | 5435 | 4825 | 4275 | 0 | 3245 | 4820
(without casket)
Cheapest Casket | 215* |  | 795 | 785 | MISSING |  | 595 | 895
Cheapest Vault | 530 |  | 900 | 725 | MISSING |  | 480 | 895
Immediate Burial (no casket) | 2225 |  | 2395 | 1775 | 2075 |  | 1590 | 1995
Direct Cremation (w/alt.cont.) | 1095 |  | 3090 | 1350 | 1850 |  | 1920 | 2295
$300 crematory fee added? | no |  | yes | yes | yes |  | yes | yes
Memorial Service |  |  | 375 | 550 | 250 |  | 310 | 490
Forwarding Remains | 1980 |  | 2395 | 1065 | 1050 |  | 990 | 1995
Receiving Remains | 1635 |  | 2395 | 995 | 1250 |  | 1590 | 1595
Sanitary Care | 92 |  | - | 100 | - |  | 110 | -
FTC Compliance | no |  | yes | NO | NO | NO | yes | no
Clarity | fair |  | good | good | poor |  | good | fair
Notes | *Likely a cardboard box.Calls cremation “disposal.” |  |  | $100 handling fee built in to IB and DC | Extremely noncompliant. Many missing diclosures/options. |  |  | Gives three different prices for the cheapest casket - confusing.
Spreadsheet: 6b9963be-5608-4a2d-9963-9e8feff8e122
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120571 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
To approve a termination agreement between the |  |  |  |  | City desires to self-manage both [NAME] and the American Royal
City of Kansas City, Missouri and AEG Kansas City |  |  |  |  | Center starting July 1, 2012
Arena, LLC for Kemper Arena and American Royal Center |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Convention and Entertainment
 |  |  |  |  |  |  |  |  | Facilities Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Convention and Entertainment
 |  |  |  |  | or Groups |  |  |  | Facilities Department
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Discussion (cont.d) |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name |  | Date
 | Title
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: vkaminski__40835__McK2
Sheet: Case 3

ENE Price |  | 48.55 | 49.55 | 50.55 | 51.55 | 52.55 | 53.55 | 54.55 | 55.55 | 56.55 | 57.55
Shares delivered
Value
ENE Price | 58.55 | 59.55 | 60.55 | 61.55 | 62.55 | 63.55 | 64.55 | 65.55 | 66.55 | 67.55 | 68.55
Shares delivered
Value
ENE Price | 69.55 | 70.55 | 71.55 | 72.55 | 73.55 | 74.55 | 75.55 | 75.89 | 77.55 | 78.55 | 79.55
Shares delivered
Value
 | ENE Price | Shares | Value
 | 48.55 |  |  |  | Terminal Price |  | Value | Value |  | Value |  | Shares
 |  |  |  |  | Bottom | Top | Bottom | Top | Slope | Delivered |  | Delivered
 |  |  |  |  | 63.37 |  |  |  |  |  | Top3
 |  |  |  |  | 0 |  | 0 |  |  |  | Bottom3
 |  |  |  |  |  |  |  |  |  |  | T3
Spreadsheet: 721061d1614446569-highlight-duplicates-based-on-several-columns-example3003
Sheet: cat

Name | Number1 | Number2 | Number3
Cat | 6145 | 6150 | 6160
Cat | 6147 | 6152 | 6162
Cat | 6189 | 6145 | 6167
Dog | 6146 | 6151 | 6161
Lion | 6149 | 6156 | 6166
Monkey | 6150 | 6155 | 6165
Pigeon | 6148 | 6153 | 6163
Pigeon | 6149 | 6159 | 6169
Tiger | 6192 | 6154 | 6164
Tiger | 6153 | 6158 | 6192
Spreadsheet: 704839d1605773359-expiry-date-with-specific-criteria-formula-search-1-ans
Sheet: Criteria

Actioned date | Outcome | [NAME] in months | [NAME] | [NAME]
2020-11-15 00:00:00 | 1st Level Warning | 3 | 3 Months | [NAME] here Based on Action date, if criteria is 1st level warning and expires in 3 months, what would the date be.
2020-10-10 00:00:00 | 2nd Level Warning | 6 | 6 Months
 | Absconded | 0 | No [NAME] (immediate)
 | Counselling | 0 | No [NAME] (immediate)
 | Deceased | 0 | No [NAME] (immediate)
 | [NAME] | 0 | No [NAME] (immediate)
 | Final Written Warning | 12 | 12 Months
 | Medical Unfit | 0 | No [NAME] (immediate)
 | Pending | 0 | No [NAME] (immediate)
 | Resignation | 0 | No [NAME] (immediate)
 | Severe Final Written Warning | 12 | 12 Months
 | Unpaid Suspension | 0 | No [NAME] (immediate)
 | Verbal Warning | 3 | 3 Months
Spreadsheet: joe_parks__15043__bridgeline 6-12
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGF3 | 3870 | 28 | 16:51:37 | 905 | 97563 | 4C | 1911 | ebc | EO-1911 | 522 | 0 | Y
B | NGN2 | 3130 | 1 | 16:09:08 | 905 | 97563 | 4C | 1239 | amk | EO-1239 | 286 | 0 | Y
B | NGN2 | 3153 | 5 | 22:02:50 | 905 | 97563 | 4C | 2700 | amk | EO-2700 | 1092 | 0 | Y
B | NGN2 | 3153 | 14 | 01:41:40 | 905 | 97563 | 4C | 2700 | amk | EO-2700 | 1183 | 0 | N
B | NGN2 | 3153 | 1 | 08:08:26 | 905 | 97563 | 4C | 2700 | amk | EO-2700 | 1840 | 0 | N
Spreadsheet: 42072d1240600837-if-statement-with-alpha-characters-question-responses-1
Sheet: Sheet1

 | Data
CompanyName | Count of Q3 | Count of Q4 | Count of Q9 | Count of Q11 | Count of SQ11 | Count of SQ12 | Count of SQ13 | Count of Q2N | Count of Q5N
CompanyX | 29 | 9 | 9 | 1 | 9 | 9 | 9 | 9 | 9
CompanyY | 27 | 11 | 11 | 6 | 11 | 11 | 11 | 12 | 12
Grand Total | 56 | 20 | 20 | 7 | 20 | 20 | 20 | 21 | 21
Spreadsheet: 765804d1643615656-1-how-to-create-a-list-based-on-user-input-2-previous-values-based-on-the-last-occurance-copy-of-questions-v1
Sheet: Question 1

Name | Profit |  |  |  |  |  | Most profitable List | Total Profit |  | USER INPUT: | 5 | PLEASE ENTER A VALUE TO KNOW THE MOST PROFITABLE NAMES
ABC | 100 |  |  |  |  | 1
RST | 50
XYZ | 300
ABC | -50
MNO | 200
RST | 600 |  |  |  |  |  |  |  |  | [NAME] needed for C2 & D2 such that:
QWE | 150 |  |  |  |  |  |  |  |  | 1) The list should appear from the formula in C2 & the list shd appear C2 downwards automatically, i.e. without copying the formula to the below cells.
RST | -150 |  |  |  |  |  |  |  |  | 2) Same for the total profit list in Col D which shd be created automatically based on the formula in [NAME] and the list to appear D2 downwards without dragging the formula down
LKJ | 300 |  |  |  |  |  |  |  |  | 3) If user input is, let's say, 5, then list of top 5 profitable names should appear in Col C along with their respective total profit in Col D
DFG | -350 |  |  |  |  |  |  |  |  | 4) But if user input is, let's say 7, then top 7 names along with their total profits to appear in Col C & D
UYT | 400 |  |  |  |  |  |  |  |  | 5) The list shd appear such that most profitable name shd be on the top (decending profit)
HGY | 100
ZXC | 200
BVC | 50
XYZ | 800
ABC | 200
Spreadsheet: 05af7dee-9db3-4e75-bbd4-e419251500ba
Sheet: Sheet1

1993 - 37th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | [NAME], Albuquerque, New Mexico, USA |  |  |  |  | 1993-10-04 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | AUT | Starkbaum | [NAME] | Röhsler | Rainer | OE-PZS Polarstern | Campbellsport | 1832 | 1900-01-02 11:29:00
2 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-OCOL Columbus II | Buffalo/Minnesota | 1557.5 | 1900-01-02 18:02:00
3 | AVI | Fraenckel | [NAME] | [NAME] | [NAME] | D-Caribbean | Wood River/Nebraska | 950.6 | 1900-01-01 21:28:00
4 | AUT | Lewetz | [NAME] | Wagner | [NAME] | OE-ZZI | Whitman/Nebraska | 899.1 | 1900-01-02 04:36:00
5 | GER | Kuinke | Volker | Schellhove | Jörg | D-Columbus | Mosca/Colorado | 305.2 | 1900-01-01 08:50:00
6 | JAP | Ichyoshi | [NAME] | Oiwa | Maico | N35SP | Roy/New Mexico | 234.8 | 21:07:00
7 | POL | Makne | [NAME] | Ozga | [NAME] | N37915 | Cimmaron/New Mexico | 219.7 | 22:10:00
8 | POL | [NAME] | Jerzy | Gózdz | Jerzy | N147SP | Wagon Mound/New Mexico | 187.4 | 20:26:00
9 | AUT | Fürstner | [NAME] | Huber | Hans | D-OBFA Ballonfabrik Augsburg | Wagon Mound/New Mexico | 186.4 | 20:41:00
10 | SUI | Spenger | [NAME] | Stoll | Christian | HB-BVZ  [NAME] | Ocate/New Mexico | 186.3 | 21:28:00
11 | USA | [NAME] | [NAME] | Senez | [NAME] | N1636S Spirit of Sprinfield | Wagon Mound/New Mexico | 185.1 | 20:45:00
12 | GER | [NAME] | Heinz | Hutmacher | [NAME] | D-Ruhrpott | Ocate/New Mexico | 181 | 19:58:00
13 | SUI | Najer | [NAME] | Fröhlin | Hansjörg | D-OCFT | Ft.Union/New Mexico | 172.1 | 19:27:00
14 | USA | Woods | [NAME] | Boring | [NAME] | N611SP | La Cueva/New Mexico | 148.1 | 18:50:00
15 | SWE | Akerstedt | Hans | Balkedal | Jan | G-ROSY | Pecos/New Mexico | 113.7 | 16:35:00
16 | AUS | Vizzard | [NAME] | Wallington | [NAME] | N5371B | Glorieta/New Mexico | 93.2 | 15:07:00
17 | FRA | Castanier | Clotaire | Villey | [NAME] | N4343J | Los Alamos/New Mexico | 85.5 | 18:23:00
18 | USA | [NAME] | [NAME] | Bradley | Troy | G-BSRT | Los Alamos/New Mexico | 79.6 | 14:53:00
19 | AVI | Soukup | [NAME] | [NAME] | [NAME] | N38JT | Albuquerque/New Mexico | 10.5 | 11:07:00
20 | CAN | Martin | [NAME] | Francoeur | Danielle | CF-IEK |  | no start