tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 23

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
10-5 | افزايش اثاثيه اداری مربوط به اقلام زيرمی باشد: | 1390/3/31
 |  | ريال
 | خريد دستگاه کانکس و کانتینر | 214500000
 | خرید  انواع مانیتور رنگی و [NAME] و اسکنر و لوازم کا مپیوتری | 439666632
 | خرید  انواع یخچال وتلویزیون و دوربین عکاسی ماشین حساب | 23880000
 | خرید  دستگاه انواع [NAME] تلفن و تلفن همراه | 18051533
 | خرید  انواع میز وصندلی فایل و [NAME] | 371754539
 | سایر | 943616296
10-6 | افزایش وسائط نقلیه در سال مالی مورد [NAME] قرار زیر است : | 1390/3/31
 |  | ريال
 | خرید یکدستگاه پژو پارس خاکستری | 205773000
 | تعمیرات وسائط نقلیه افزایش دارایی | 207171528
 |  | 1390/3/31
10-7 | کاهش اثاثیه فنی در سال مالی مورد [NAME] به اقلام زیراست: | ريال
 | فروش یکدستگاه [NAME] | 100595000
 |  | 0
 |  | 1390/3/31
10-8 | کاهش اثاثیه اداری در سال مالی مورد [NAME] به [NAME]: | ريال
 | بابت برگشت یکدستگاه تلفن همراه | 490000
 | بابت برگشت 8 دستگاه بی سیم | 9175000
Spreadsheet: 049ff6c7-7bd6-495d-b3e4-d4ea02baf5bc
Sheet: Sheet1

Unnamed: 0 | FORMULAIRE I | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1re Partie
 | ORGANISATION DE L'AVIATION CIVILE INTERNATIONALE
 | FORMULAIRE DU TRANSPORT AÉRIEN
 | TRAFIC D'AÉROPORT
 | Personne à contacter :
 | Organisation : |  |  |  |  |  |  |  |  |  | État :
 | Tél. : |  |  |  |  |  |  |  |  |  | Aéroport :
 | Fax : |  |  |  |  |  |  |  |  |  | [NAME] :
 | C. élect. : |  |  |  |  |  |  |  |  |  | Année civile :
 |  |  |  |  |  |  |  |  |  |  | Mois :
 | Description |  |  | Mouvements d'aéronef Total | Passagers |  |  |  | Fret (tonnes) |  |  | Poste (tonnes)
 |  |  |  |  | Embarqués | Débarqués | Total (Col. c + d) | En transit direct | Embarquées | Débarquées | Total (Col. [NAME]) | Embarquées | Débarquées | Total                  (Col. j + k)
 |  |  |  |  |  |  | (c+d) | Transit |  |  |  |  |  | (c+d)
 | a |  |  | b | c | d | e | f | g | h | i | j | k | l
 | [NAME] aérien commercial
 | 1. International régulier……………………………………………………………
 | 2. International non régulier……………………………………………………
 | 3. Total international (1+2)…………………………………………………………….
 | 4. [NAME] régulier et non régulier……………………………….
 | 5. Total - Transport aérien commercial (1+2+4)…………………………………..
 | 6. Services exclusif de fret/Services postaux1………………………………………………………………
 | 7. Taxi aérien et vols d'affaires commerciaux2………………………………………………………………
 | [NAME] autres mouvements………………………………………………………………………..
 | Observations (y compris indication des cas où il a été impossible de se conformer aux instructions) :
 | 1Trafic à inclure également dans les rubriques 1 à 5 (voir instructions). |  |  |  |  |  |  |  |  |  | Au besoin, utiliser des feuilles supplémentaires.
 | 2Trafic à inclure également dans les rubriques 2 à 5 (voir instructions).
Spreadsheet: 741098d1626813236-match-two-columns-to-multiple-other-columns-and-return-another-column-replacer
Sheet: Replace from

Marker | Fluor | Search For | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
CD4 | C 610 | PE-eFluor 610 | PE-Texas Red | PE-CF594 | Alexa Fluor 568 | Alexa Fluor 594 | PE-Vio 615 | eFluor 615 | NovaYellow 610 | LIVE DEAD Red
CD4 | C 584 | Alexa Fluor 546 | Northern Lights 557 | Spark YG 581 | Spark YG 570 | Alexa Fluor 555 | eFluor 570 | iFluor 546 | RFP | NovaYellow 570
CD8 | C547 | Pacific Orange | [NAME] 540 | Live-or-Dye 405/545 | CF405L | Spark Violet 538
CD16 | C 668 | Alexa Fluor 647 | eFluor 660 | DyLight 650 | Vio667 | Northern Lights 637 | sVio667 | VioBright 667 | LIVE DEAD Far Red | NovaBlue 660
CD4 | C 668 | Alexa Fluor 647 | eFluor 660 | DyLight 650 | Vio667 | Northern Lights 637 | sVio667 | VioBright 667 | LIVE DEAD Far Red | NovaBlue 660
CD66a/c/e | C 668 | Alexa Fluor 647 | eFluor 660 | DyLight 650 | Vio667 | Northern Lights 637 | sVio667 | VioBright 667 | LIVE DEAD Far Red | NovaBlue 660
CD7 | C 668 | Alexa Fluor 647 | eFluor 660 | DyLight 650 | Vio667 | Northern Lights 637 | sVio667 | VioBright 667 | LIVE DEAD Far Red | NovaBlue 660
Spreadsheet: 64122d1264992961-returning-value-by-date-key-match-calbear81
Sheet: price list

product name | 2009-06-15 00:00:00 | 2009-11-01 00:00:00 | 2010-01-31 00:00:00
a | 19 | 342 | 252
b | 91 | 222 | 441
c | 97 | 291 | 51
d | 151 | 288 | 416
e | 490 | 385 | 59
f | 37 | 387 | 312
g | 123 | 331 | 245
h | 417 | 428 | 339
i | 121 | 424 | 291
j | 377 | 392 | 247
k | 432 | 178 | 229
l | 490 | 252 | 470
m | 211 | 452 | 355
n | 392 | 407 | 73
o | 411 | 139 | 374
p | 12 | 291 | 125
q | 219 | 283 | 46
r | 223 | 404 | 132
Spreadsheet: 882464d1730845582-random-sample-of-rows-and-assigning-teams-individuals-sample-peer-review
Sheet: Desired Output case of 2

 |  |  |  |  |  |  |  |  |  |  | What my desired output looks like
Press F9 to Refresh
charts sampled | 2 |  |  | orange cells changed. Also solver variables and constraints adopted to changed ranges
This is where I am verifying my sample totals.
 |  | Attempt 2 | Attempt 2 | assigned reports
Staff | # Charts | # Sampled | # to review | prepare as many columns as needed in B5 |  |  |  |  |  | report index | Cert Dt | Participant ID | Staff | Reviewer | Check
 |  |  |  | 6 | 23
BERTHA |  |  |  | 8 | 17 |  |  |  |  | 8 | 2024-09-06 00:00:00 |  |  | BERTHA
CECILIA |  |  |  | 31 | 9 |  |  |  |  | 31 | 2024-09-07 00:00:00 |  |  | CECILIA
CRYSTAL |  |  |  | 10 | 7 |  |  |  |  | 10 | 2024-09-11 00:00:00 |  |  | CRYSTAL
DANIELA |  |  |  | 27 | 11 |  |  |  |  | 27 | 2024-09-13 00:00:00 |  |  | DANIELA
[NAME] |  |  |  | 15 | 14 |  |  |  |  | 15 | 2024-09-13 00:00:00 |  |  | [NAME]
GUADALUPE |  |  |  | 3 | 2 |  |  |  |  | 3 | 2024-09-18 00:00:00 |  |  | GUADALUPE
KARLA |  |  |  | 24 | 16 |  |  |  |  | 24 | 2024-09-18 00:00:00 |  |  | KARLA
KENDRA |  |  |  | 12 | 18 |  |  |  |  | 12 | 2024-09-18 00:00:00 |  |  | KENDRA
Melinda |  |  |  | 29 | 26 |  |  |  |  | 29 | 2024-09-20 00:00:00 |  |  | Melinda
Nicole |  |  |  | 25 | 13 |  |  |  |  | 25 | 2024-09-28 00:00:00 |  |  | Nicole
[NAME] |  |  |  | 19 | 28 |  |  |  |  | 19 | 2024-09-24 00:00:00 |  |  | [NAME]
PRISCILLA |  |  |  | 1 | 5 |  |  |  |  | 1 | 2024-09-26 00:00:00 |  |  | PRISCILLA
REBECCA |  |  |  | 20 | 4 |  |  |  |  | 20 | 2024-09-30 00:00:00 |  |  | REBECCA
Rosmy |  |  |  | 22 | 21 |  |  |  |  | 22 | 2024-09-03 00:00:00 |  |  | Rosmy
Violeta |  |  |  | 32 | 30 |  |  |  |  | 32 | 2024-09-03 00:00:00 |  |  | Violeta
(16 staff) |  |  |  |  |  |  |  |  |  | 23 | 2024-09-03 00:00:00 |  |  | ANGEL
 |  |  |  |  |  |  |  |  |  | 17 | 2024-09-04 00:00:00 |  |  | BERTHA
there are 2 people reviewed more than once, but that is ok |  |  |  |  |  |  |  |  |  | 9 | 2024-09-04 00:00:00 |  |  | CECILIA
because there were two people with only 1 chart to sample |  |  |  |  |  |  |  |  |  | 7 | 2024-09-04 00:00:00 |  |  | CRYSTAL
 |  |  |  |  |  |  |  |  |  | 11 | 2024-09-05 00:00:00 |  |  | DANIELA
standard deviation as a measure of dispersion |  |  |  |  |  |  |  |  |  | 14 | 2024-09-06 00:00:00 |  |  | [NAME]
aim - minimize |  |  |  |  |  |  |  |  |  | 2 | 2024-09-06 00:00:00 |  |  | GUADALUPE
 |  |  |  |  |  |  |  |  |  | 16 | 2024-09-09 00:00:00 |  |  | KARLA
constraint: number of self-reviews = 0 |  |  |  |  |  |  |  |  |  | 18 | 2024-09-16 00:00:00 |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  | 26 | 2024-09-25 00:00:00 |  |  | Melinda
 |  |  |  |  |  |  |  |  |  | 13 | 2024-09-25 00:00:00 |  |  | Nicole
 |  |  |  |  |  |  |  |  |  | 28 | 2024-09-26 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 5 | 2024-09-26 00:00:00 |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  | 4 | 2024-09-23 00:00:00 |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  | 21 | 2024-09-20 00:00:00 |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  | 30 | 2024-09-20 00:00:00 |  |  | Violeta
Spreadsheet: 885794d1735631876-searching-for-common-text-among-different-sheets-andrewli-spill-365-aligw
Sheet: Sheet1

Smith | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Gavin
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 0bfabfec-f902-42ff-84aa-10a671b70e44
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Street Name Change: [NAME]'s [NAME] Plat
Brief Title |  |  | Approval Deadline |  | Reason
 | Changing the name of N Lane Avenue to N Hunter Avenue within [NAME]'s [NAME] Plat
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], AICP
 |  |  |  |  |  | Director, Department of City Planning and Development
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 | Reason for Legislation |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Street Naming Committee
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Fact Sheet Prepared By: |  |  | Date:   3-30-07
 | [NAME]
 | Planner
Reviewed by: |  |  | Date:   3-30-07
 | [NAME], Manager
 | Development Management
Reference Numbers
 | Changing the name of N Lane Avenue to N Hunter Avenue within [NAME]'s [NAME] Plat
 | [NAME] (continued)
Spreadsheet: 135372d1325979926-help-autofilling-on-amazing-spreadsheet-i-have-created-boostrosterprojectionv6
Sheet: Projection

0
WEEK 1 of FORTNIGHTLY PROJECTIONS
 | Week Ending |  |  |  |  |  |  |  |  |  |  | Weekly Totals
Name | DOB | Age | POS | Rate | Mon | Tue | Wed | Thu | Fri | Sat | Sun | $'s | Super | Pay Tax | Hours | %
Full Time |  |  |  |  |  |  |  |  |  |  |  |  | Monday 14th
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
Part Time |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | #N/A
Casual |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | #N/A
 |  | Daily Total $'s: |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Daily Total Hours: |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0
 |  | CID - GST: |  |  |  |  |  |  |  |  |  | 0
 |  | WAGE %: |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | AHR |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | SPMH |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
Spreadsheet: 864190d1711464206-need-help-to-show-duplicate-values-and-count-it-with-or-without-specific-criteria-duplicate-values
Sheet: Sheet1

I need Help : | 1. what is the formula to show the duplicate values or text with specific length (ex : text with the length is 11)
 | 2. what is the formula to count the number of duplicate values or text with specifit length
 | 2. what is the formula to count the number of all duplicate values |  |  |  |  |  |  |  |  |  | Helper columns of formulas
Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10 | Name 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Count Duplicate specific criteria | Count all duplicate Value (not blank)
MRTU2238220 | MRTU2200250 | MRTU9604228 | A | A | B | B
MRTU2227884
MRTU9608579
MRTU2242282 | MRTU2185372 | MRTU2242282 | MRTU2200857 | MRTU2242282 | MRTU2200857 | HPCU2232947 | HPCU2231489 | HPCU2230435 | A | A
MRTU2056267 | MRTU2128808
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Legal

Legal
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90006327 | ADAMS, SUZANNE | [NAME] | ASSTSR-CS
90040949 | COOK, MARY H | Counsel SR | DIR-ST
90009556 | FITZGERALD, GENIA E | Spec SR Legal | SPECSR-CS
90151022 | HALL, STEPHEN C | Counsel SR | DIR-ST
90124091 | HANSEN, LESLIE | Counsel SR | DIR-ST
90009693 | HEARD, MARIE T | Spec SR Legal | SPECSR-CS
90009558 | HODGE, JEFFREY T | VP & Asst Gen Cnsl | VP-ST
90009696 | JONES, TANA L | Spec SR Legal | SPECSR-CS
90007205 | KEISER, HOLLY S | [NAME] | ASSTSR-CS
90009570 | KOEHLER, ANNE C | Counsel SR | DIR-ST
90009574 | MCCULLOUGH, TRAVIS C | VP & Asst Gen Cnsl | VP-ST
90009715 | NEMEC, [NAME] R | Attorney | MGR-ST
90123345 | NETTELTON, [NAME] | Counsel SR | DIR-ST
90009740 | PINTO-LEITE, FRANCISCO P | Counsel SR | DIR-ST
90009559 | PORTZ, [NAME] | Counsel SR | DIR-ST
90009587 | RASMUSSEN, [NAME] | Counsel SR | DIR-ST
90009561 | SAGER, [NAME] A | VP & Asst Gen Cnsl | VP-ST
90009697 | ST. CLAIR, CAROL L | [NAME] Asst | DIRSR-ST
90012960 | TAYLOR, MARK E | VP & Gen Cnsl | VP-ST
90009711 | VAN HOOSER, [NAME] | [NAME] Asst | DIRSR-ST
90009585 | YODER, CHRISTIAN G | Counsel SR | DIR-ST
 |  | Employees
Spreadsheet: 25340d1216631245-sum-countif-format2
Sheet: Sayfa1

2 | 10 | 27 | 30 | 32 | 54
 |  |  |  |  |  |  | ADET
24 | 36 | 12 | 23 | 31 | 19
1 | 34 | 39 | 16 | 3 | 26
16 | 24 | 31 | 30 | 5 | 30
25 | 47 | 4 | 28 | 24 | 33
7 | 30 | 29 | 6 | 10 | 47
8 | 3 | 38 | 44 | 32 | 16
11 | 20 | 13 | 48 | 13 | 42
23 | 11 | 19 | 28 | 49 | 4
3 | 9 | 12 | 39 | 18 | 37
48 | 34 | 40 | 13 | 5 | 30
14 | 19 | 4 | 17 | 40 | 5
29 | 36 | 6 | 20 | 16 | 44
20 | 33 | 43 | 27 | 25 | 33
23 | 22 | 29 | 35 | 34 | 20
35 | 25 | 7 | 23 | 37 | 6
3 | 21 | 28 | 23 | 23 | 45
22 | 19 | 42 | 43 | 41 | 10
49 | 12 | 10 | 18 | 18 | 28
18 | 8 | 24 | 10 | 49 | 49
14 | 18 | 49 | 36 | 27 | 32
49 | 47 | 15 | 7 | 9 | 3
34 | 7 | 7 | 49 | 22 | 16
35 | 42 | 10 | 43 | 18 | 27
48 | 22 | 40 | 27 | 31 | 31
29 | 38 | 2 | 33 | 19 | 30
11 | 13 | 33 | 34 | 11 | 3
Spreadsheet: 876192d1722872477-excel-countifs-with-dates-edneco-excel_countifs-aligw
Sheet: Folha1

Date | Quotes | [NAME] |  |  |  | 2024-04-01 00:00:00 | [NAME]) | [NAME] (Month) | Qty Quotes(Year) | [NAME] (Year)
25.05.2024 | 14725 | Rödhammer |  |  |  | Fehling
01.04.2024 | 14725 | Fehling |  |  |  | [NAME]
28.06.2024 | 37500 | Fehling |  |  |  | Rödhammer
11.04.2024 | 22300 | Fehling |  |  |  | Bude
18.08.2024 | 12500 | Fehling |  |  |  | Harder
07.06.2024 | 39000 | Whitlam |  |  |  | Willem
19.04.2024 | 29900 | [NAME] |  |  |  | Segatto
22.06.2024 | 11600 | Fehling |  |  |  | Whitlam
14.08.2024 | 13800 | Rödhammer |  |  |  | [NAME]
05.07.2024 | 31500 | Rödhammer |  |  |  | Vizuete
04.05.2024 | 21600 | [NAME]
13.07.2024 | 7910 | Vizuete
13.04.2024 | 17600 | Harder
07.04.2024 | 34100 | [NAME]
26.04.2024 | 18300 | [NAME]
Spreadsheet: 188642d1350938712-how-to-calculate-the-time-between-purchases-for-multiple-customers-repeatcustomers
Sheet: Data

Customers | Month | HW | SW | P |  | Since Last Purchase (days) | Purchase #
A | 2005-01-01 00:00:00 |  |  | 107403.75
 | 2006-02-01 00:00:00
 | 2006-11-01 00:00:00 | 0 | 52447.5
 | 2006-12-01 00:00:00 | 0 | 19980
 | 2008-01-01 00:00:00 | 0 | 0
 | 2008-02-01 00:00:00 | 0 | 0
B | 2010-03-01 00:00:00 | 0 | 0
 | 2010-11-01 00:00:00 | 20400 | 0
C | 2011-12-01 00:00:00 | 21350 | 21360.94
 | 2012-03-12 00:00:00 | 0 | 11594
D | 2012-05-01 00:00:00 | 0 | 0
 | 2012-06-12 00:00:00 | 0 | 4800
 | 2012-09-01 00:00:00 | 0 | 0
E | 2010-09-01 00:00:00 | 24320 | 20820
F | 2011-03-01 00:00:00 | 0 | 17440
 | 2011-09-01 00:00:00 | 0 | 0
 | 2012-02-12 00:00:00 | 0 | 2000
 | 2012-04-01 00:00:00 | 0 | 0
G | 2011-05-11 00:00:00 | 12200 | 3200
H | 2012-06-04 00:00:00 | 25225 | 22875
 | 2012-09-01 00:00:00 | 72540 | 9900
I | 2012-02-12 00:00:00 | 8200 | 10800
J | 2011-02-01 00:00:00 | 135000 | 288000
 | 2011-04-11 00:00:00 | 0 | 0
 | 2011-09-11 00:00:00 | 0 | 0
K | 2012-03-12 00:00:00 | 70400 | 99000
 | 2012-07-01 00:00:00 | 0 | 0
L | 2012-09-01 00:00:00 | 0 | 52200
M | 2011-12-11 00:00:00 | 12700 | 18000
O | 2008-07-01 00:00:00 | 40000 | 14375.42
 | 2008-10-01 00:00:00 | 0 | 5000
 | 2009-06-01 00:00:00 | 20000 | 15000
 | 2009-10-01 00:00:00 | 0 | 0
 | 2010-02-01 00:00:00 | 0 | 0
 | 2010-08-01 00:00:00 | 0 | 0
 | 2010-10-01 00:00:00 | 0 | 0
 | 2011-01-01 00:00:00 | 0 | 0
 | 2011-02-01 00:00:00 | 0 | 26000
 | 2011-10-11 00:00:00 | 0 | 0
 | 2012-02-12 00:00:00 | 35400 | 29310
 | 2012-07-01 00:00:00 | 0 | 0
P | 2012-04-01 00:00:00 | 28975 | 14250
Q | 2011-10-11 00:00:00 | 20400 | 33500
R | 2012-06-08 00:00:00 | 0 | 0
S | 2012-08-12 00:00:00 | 0 | 0
T | 2011-07-11 00:00:00 | 18500 | 0
U | 2009-10-01 00:00:00 | 50750 | 214500
 | 2009-11-01 00:00:00 | 0 | 0
 | 2010-11-01 00:00:00 | 0 | 0
 | 2011-01-01 00:00:00 | 0 | 0
 | 2011-03-11 00:00:00 | 0 | 0
 | 2011-09-11 00:00:00 | 0 | 0
 | 2012-04-01 00:00:00 | 0 | 39000
 | 2012-10-01 00:00:00 | 0 | 0
V | 2012-09-01 00:00:00 | 190260 | 0
W | 2006-05-01 00:00:00 | 20290 | 0
 | 2007-05-01 00:00:00 | 0 | 0
 | 2008-04-01 00:00:00 | 0 | 95840
 | 2008-05-01 00:00:00 | 0 | 0
 | 2009-04-01 00:00:00 | 0 | 0
 | 2009-05-01 00:00:00 | 0 | 0
 | 2009-12-01 00:00:00 | 17000 | 0
 | 2010-04-01 00:00:00 | 0 | 0
 | 2011-05-11 00:00:00 | 0 | 0
 | 2012-05-01 00:00:00 | 0 | 0
 | 2012-05-24 00:00:00 | 0 | 18000
X | 2009-12-01 00:00:00 | 20000 | 7500
 | 2010-09-01 00:00:00 | 0 | 12000
 | 2010-12-01 00:00:00 | 0 | 26000
 | 2012-06-08 00:00:00 | 9000 | 0
 | 2012-07-01 00:00:00 | 0 | 0
Y | 2011-12-11 00:00:00 | 35375 | 41300
Z | 2008-06-01 00:00:00 | 59740 | 104062.5
 | 2009-06-01 00:00:00 | 0 | 0
 | 2010-08-01 00:00:00 | 0 | 0
Spreadsheet: 61d8c399-74fb-4353-8127-9c1253fa091e
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688901424 | Big Daddy Weave | Ring The Bells (Feat. [NAME]) | 2014-11-11 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | NYP
Word Records | 80688900724 | Big Daddy Weave | Overwhelmed | 2014-09-16 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | NYP
Word Records | 80688856625 | Big Daddy Weave | Only Name (Yours Will Be), The | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688856526 | Big Daddy Weave | Redeemed | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688856427 | Big Daddy Weave | If You Died Tonight | 2012-09-04 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688856328 | Big Daddy Weave | Love Come To Life | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688856120 | Big Daddy Weave | [NAME] | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688798123 | Big Daddy Weave | I'Ll Be Brave This Christmas | 2009-11-03 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688795825 | Big Daddy Weave | Glory | 2009-11-03 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688856229 | Big Daddy Weave | Magnificent God | 2012-11-04 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688774929 | Big Daddy Weave | You Found Me | 2008-09-09 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688701222 | Big Daddy Weave | Only [NAME] | 2006-10-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688701123 | Big Daddy Weave | Hold Me [NAME] | 2007-04-17 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688701024 | Big Daddy Weave | Every Time I Breathe | 2006-11-21 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688702427 | Big Daddy Weave | Let It Rise | 2007-05-22 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688647520 | Big Daddy Weave | Christ Is Come | 2005-11-22 | Studio Series 3-Key CD Trax | Chr | 9.99 | N | To Be Retired
Word Records | 80688645328 | Big Daddy Weave | Heart Cries Holy | 2005-11-08 | Studio Series 3-Key CD Trax | Chr | 9.99 | N | To Be Retired
Word Records | 80688645229 | Big Daddy Weave | Fields Of Grace | 2005-11-08 | Studio Series 3-Key CD Trax | Chr | 9.99 | N | To Be Retired
Word Records | 80688645120 | Big Daddy Weave | [NAME] Of My Praise | 2005-09-13 | Studio Series 3-Key CD Trax | Chr | 9.99 | N | To Be Retired
Word Records | 80688645427 | Big Daddy Weave | Audience Of One | 2005-09-13 | Studio Series 3-Key CD Trax | Chr | 9.99 | N | To Be Retired
Spreadsheet: 99116d1297865228-data-analyzing-problem-example
Sheet: Sheet1

 | a | b | c | d | e |  | a | b | c | d | e |  | a | b | c | d | e
01.01.2000 | 0.52 | 0.4567 | 0.5534 | 0.4999 | 0.3876 |  | 2 | 4 | 1 | 3 | 5 |  | -1 | -2 | 2 | 1 | 0
02.01.2000 | 0.5899 | 0.5023 | 0.5672 | 0.4222 | 0.43333 |  | 1 | 3 | 2 | 5 | 4 |  | 0 | -1 | 1 | -1 | 1
03.01.2000 | 0.5325 | 0.5679 | 0.511 | 0.4228 | 0.3678 |  | 2 | 1 | 3 | 4 | 5 |  | -1 | 1 | 0 | 0 | 0
04.01.2000 | 0.5555 | 0.5444 | 0.501 | 0.4998 | 0.3678 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 146838d1332369316-7-dependent-drop-down-lists-stuck-best-way-to-go-about-it-copy-of-demo-calculator
Sheet: measurer

 |  | # | Extruder | System | Style | top | bottom | center | sides
 |  | 1 | Eastern metals | R SHUTTER
 |  | 2 | Eastern metals | R SHUTTER
 |  | 3 | Eastern metals | R SHUTTER
 |  | 4 | Eastern metals | R SHUTTER
 |  | 5 | Eastern metals | R SHUTTER