tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b1796b70-29f7-42bc-98bc-e933af987fcc
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP VII  GUGUS BADAN DIKLAT PROV. [NAME]. SUMBING
[NAME] Tanggal 14 - 23  Agustus  2011
Kelas : | [NAME]
No | No Peserta | Nama | Sekolah | Kab./Kota
1 | 11036157110688 | [NAME] | SMP N 18 SKA | [NAME]
2 | 11036157111058 | SUDARSO | SMK N 8 surakarta | [NAME]
3 | 11032421710737 | AHMAD FAUZAN | SMP N 1 PEGANDON | Kab. Kendal
4 | 11036221710144 | DARYONO | SMP NEGERI   6 SALATIGA | [NAME]
5 | 11036321711022 | ELLY JANIARMANTIE | SMP KRISTA MITRA | [NAME]
6 | 11032221710751 | HARTANTO | SMP N 3 TUNTANG | Kab. Semarang
7 | 11032521710609 | HERWANTO ASIS | SMP N 6 BATANG | Kab. [NAME]
8 | 11032421710730 | KUSHARTONO | SMP N 1 PATEAN | Kab. Kendal
9 | 11032221710802 | [NAME] | SMP N 2 GETASAN | Kab. Semarang
10 | 11036221710119 | MINAR | SMP NEGERI 2 SALATIGA | [NAME]
11 | 11032621710689 | NINIK EJAWATI | SMP N 1 BOJONG | Kab. Pekalongan
12 | 11032221710697 | NUGRAHENI SUPRIHATI | SMP N 2 AMBARAWA | Kab. Semarang
13 | 11036221710150 | PAMBUDIYONO | SMP NEGERI  7 SALATIGA | [NAME]
14 | 11032521710604 | SUKISNO | SMP N 1 WARUNGASEM | Kab. [NAME]
15 | 11032521710672 | SUKIYANTO | SMP N 2 TULIS | Kab. [NAME]
16 | 11036221710238 | SULISTIYO | SMK N 3 SALATIGA | [NAME]
17 | 11032821710645 | SUSANTININGSIH | SMP N 1 SLAWI | Kab. Tegal
18 | 11032521710602 | SUSBANDIYAH | SMP N 2 WARUNGASEM | Kab. [NAME]
19 | 11032621710716 | [NAME] | SMP N 3 DORO | Kab. Pekalongan
20 | 11032221710940 | TROISIEME KUSUMADI | SMP N 2 SUMOWONO | Kab. Semarang
21 | 11032621710701 | IWAN SETIAWAN | SMP N 2 TALUN | Kab. Pekalongan
22 | 11036521710237 | SRI SUWARSO | SMP N 3 | [NAME]
23 | 11036321711338 | SURDIANSYAH | SMP N 23 | [NAME]
24 | 11032821710759 | TATIK MURDIYANI | SMP N 1 DUKUHTURI | Kab. Tegal
25 | 11031821711288 | F. NIKEN HENTA PRAMUDYANI | SMP N 1 KAYEN | KAYEN, KAB. PATI
26 | 11031821711313 | ERNIATI | SMP N 8 PATI | PATI, KAB. PATI
27 | 11031821711391 | PUJIWATI | SMP N 4 PATI | PATI, KAB. PATI
28 | 11031921710437 | YUSEPIN VIPI INDRIYANTI B | SMP N 1 BAE | BAE, KAB. KUDUS
29 | 11031921710508 | ERLYN SURYANINGTYAS | SMP N 1 JATI KUDUS | [NAME], KAB. KUDUS
30 | 11031921710527 | JOKO DARONO | SMP PGRI JATI KUDUS | [NAME], KAB. KUDUS
Spreadsheet: 81306d1281536019-protecting-worksheets-with-text-boxes-example-textbox
Sheet: SAT Completion Form

Form
Line | Ring Information
1 | Text |  | Text |  | Text |  | Text |  |  | Note:  Do Not Enter Data in Shaded Cells
2 | Text |  | Text |  | Text |  | Text
3 | Text |  | Text |  | Text |  | Text
4 | Text |  | Text |  | Text |  | Text
5 | Text |  | Text |  | Text |  | Text
6 | Text |  | Text |  | Text |  | Text
7 | Text |  | Text |  | Text |  | Text
8 | Text |  | Text |  | Text |  | Text
9 | Text |  | Text |  | Text |  | Text
10 | Text |  | Text |  | Text |  | Text
11 | Text |  | Text |  | Text |  | Text
12 | Text |  | Text |  | Text |  | Text
13 | Text |  | Text |  | Text |  | Text
14 | Text |  | Text |  | Text |  | Text
15 | Text |  | Text |  | Text |  | Text
16 | Text |  | Text |  | Text |  | Text
17 | Text |  | Text |  | Text |  | Text
18 | Text |  | Text |  | Text |  | Text
19 | Text |  | Text |  | Text |  | Text
20 | Text |  | Text |  | Text |  | Text
21 | Text |  | Text |  | Text
22 |  |  |  |  |  |  |  |  |  | Note:  Do Not Enter Data in Shaded Cells
23 | opt 1 |  | etc |  | etc |  | etc
24 | opt 2 |  | etc |  | etc |  | etc
25 | opt 3 |  | etc |  | etc |  | etc
26 | opt 4 |  | etc |  | etc |  | etc
27 | opt 5 |  | etc |  | etc |  | etc
28 | opt 6 |  | etc |  | etc |  | etc
29 | Text
30 | Text |  | Text |  | Text
31 | Text |  | Text |  | Text
32 | Text |  | Text |  | Text
33 | Text |  | Text |  | Text
34 | Text |  | Text |  | Text
35 | Text |  | Text |  | Text
36 | Text |  | Text |  | Text
37 | Text |  | Text |  | Text
38 | Text |  | Text |  | Text
39 | Text |  | Text |  | Text
40 | Text |  | Text |  | Text |  |  |  |  | DATEC/METS
41 | Text |  | Text |  | Text
42 | Text |  | Text |  | Text
43 | Text |  | Text |  | Text |  |  |  |  | BVH Hours
44 | Text |  | Text |  | Text |  |  |  | 0 | 0
45 | Text |  | Text |  |  |  |  |  | 0 | 0
 | Type of Defects  (Requires Comments) |  |  |  |  |  |  |  | # of Defects | Total BVH
46 | Text |  | Text |  | Text |  | Text |  | 0 | 0
47 | Text |  | Text |  | Text |  | Text |  | 0 | 0
48 | Text |  | Text |  | Text |  | Text |  | 0 | 0
49 | Text |  | Text |  | Text |  | Text |  | 0 | 0
50 | Text |  | Text |  | Text |  | Text |  | 0 | 0
51 | Text |  | Text |  | Text |  | Text |  | 0 | 0
52 | Text |  | Text |  | Text |  | Text |  | 0 | 0
53 | Text |  | Text |  | Text |  | Text |  | 0 | 0
54 | Text |  | Text |  | Text |  | Text |  | 0 | 0
55 | Text |  | Text |  | Text |  | Text |  | 0 | 0
56 | Text |  | Text |  | Text |  | Text |  | 0 | 0
57 | Text |  | Text |  | Text |  | Text |  | 0 | 0
58 | Text |  | Text |  | Text |  | Text |  | 0 | 0
59 | Text |  | Text |  | Text |  | Text |  | 0 | 0
60 | Text |  | Text |  | Text |  | Text |  | 0 | 0
61 | Text |  | Text |  | Text |  | Text |  | 0 | 0
62 | Text |  | Text |  | Text |  | Text |  | 0 | 0
63 | Text |  | Text |  | Text |  | Text |  | 0 | 0
64 | Text |  | Text |  | Text |  | Text |  | 0 | 0
65 | Text |  | Text |  | Text |  | Text |  | 0 | 0
66 | Text |  | Text |  | Text |  | Text |  | 0 | 0
67 | Text |  | Text |  | Text
68 | Text |  | Text |  | Text
COMMENTS
Line #
44
55
66
77
88
::
Spreadsheet: 55248d1255404831-trying-to-work-formula-for-work-time-sheet-using-if-formula-time-sheet-2
Sheet: WageAG

 | 2009-10-19 00:00:00 | 2009-10-20 00:00:00 | 2009-10-21 00:00:00 | 2009-10-22 00:00:00 | 2009-10-23 00:00:00 | 2009-10-24 00:00:00 | 2009-10-25 00:00:00 |  | 2009-10-26 00:00:00 | 2009-10-27 00:00:00 | 2009-10-28 00:00:00 | 2009-10-29 00:00:00 | 2009-10-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-01 00:00:00
 | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No |  | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No | Away             Yes / No
 | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only |  | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only | Office Use Only
Start Time
Finish
Workshop |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Travel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Site Preparation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Product Activity/ Application |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Site Preparation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Product Activity / Application |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Workshop Duties / Admin | The hours worked is usually rounded up to the nearest 15 mins so .25 is the min amount worked and 7.75 is the [NAME] worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Reworks / Defects | 15 | 8 | 0.25 | 7.75 | 8.5 |  |  |  |  |  |  |  |  |  |  | 39.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total | 15 | 8 | 0.25 | 7.75 | 8.5 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39.5
[NAME] | 8 | 8 | 0.25 | 7.75 | 8 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 32
1.5 x Normal Rate | 2 | 0 | -7.75 | -0.25 | 0.5 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | -5.5
2 x Normal Rate | 5 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 5
Weekend/Away Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1.5 x Weekend / Away rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Allowance: ([NAME], Fibreglass, MV, Meal) | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31.5
Private MV Use Km Travelled
Spreadsheet: 274808d1383227484-help-with-the-ranking-function-evaluation-grid-2014-2015
Sheet: Final Ranking

 | Project Reviews Ranking |  |  |  |  | *The ranking is performed automatically every time a data is changed in "Scoring Grid" sheet.
 | Rank | Project ID | Score
 | 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
 | 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
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 33881 | 31700
2 | 31257 | 31700
3 | 31828 | 31700
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
2001-11-30 00:00:00 |  |  | 77766
2001-12-03 00:00:00
CBS Volume
 |  |  | 52220
Spreadsheet: 4231167f-ee42-4c8a-b359-af48e448f061
Sheet: Thru01

2902 | = DISTRICT NUMBER |  | ENTER DISTRICT NUMBER IN CELL A1.  YOU DON'T NEED TO RUN ANY MACROS.
REFERENDUM PHASEOUT REPORT
 |  |  |  | BREAKDOWN BY INDIVIDUAL AUTHORITY
ALLOWANCES SHOWN THROUGH FY 2003 ARE FINAL.
ALLOWANCES AFTER FY 2003 MAY BE CHANGED |  |  |  |  |  |  |  |  | CY 1999 FOR
BY LATER ELECTIONS. |  |  |  | CONVERSION | PRE-2000 | PRE-2000 | PRE-2000 | PRE-2000 | PAY 2001
 |  |  | TOTAL | LAWS 2001 | 1ST | 2ND | 3RD | 4TH | & 01/01/00 | AFTER | MISC
 |  |  | ALLOWANCE | EFFECTIVE FY 2003 | PHASEOUT | PHASEOUT | PHASEOUT | PHASEOUT | TO 04/30/01 | 04/30/01 | ADJUST
 |  | GROSS $/RMCPU | N/A |  |  |  |  |  |  |  | N/A
 |  | CALENDAR YEAR CREATED | N/A |  |  |  |  |  |  |  | N/A
 |  | FIRST FISCAL YEAR | N/A |  | N/A | N/A |  | N/A |  |  | N/A
FY |  | LAST FISCAL YEAR | N/A | 2012 |  |  |  |  |  |  | N/A
2001 |  | BEFORE CAP & REDUCTION |  |  |  |  |  |  | 0 | 0
 |  | CAP
 |  | SUBTRACTION FOR CAP |  |  |  |  |  |  | 0 | 0 | 0
 |  | AFTER CAP BEFORE REDUCTION
 |  | REDUCTION |  |  |  |  |  |  | 0 | 0 | 0
 |  | FINAL ALLOWANCE
2002 |  | FINAL ALLOWANCE |  |  |  |  |  |  |  | 0 | 0
2003 |  | BEFORE TRANSFER |  |  |  |  |  |  |  |  | 0
 |  | TRANSFER |  |  |  |  |  |  |  | 0 | 0
 |  | FINAL ALLOWANCE |  |  |  |  |  |  |  |  | 0
2004 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE
 |  | FINAL ALLOWANCE |  |  |  |  |  |  |  |  | 0
 |  | FINAL ALLOWANCE |  |  |  |  |  |  |  |  | 0
 |  | FINAL ALLOWANCE |  | 0 |  |  |  |  |  |  | 0
 |  | FINAL ALLOWANCE |  | 0 |  |  |  |  |  |  | 0
 |  | CONVERSION OF RATE-BASED AUTHORITY TO REVENUE PER RMCPU: |  |  |  |  | CALCULATION OF REFERENDUM CONVERSION ALLOWANCE
1 |  | AUTHORIZED RATE |  |  |  | A | FY 2002 TRANSITION REVENUE PER RMCPU
2 |  | 1998 NTC |  |  |  | B | FY 2002 SUPPLEMENTAL REVENUE PER RMCPU
3 |  | FY 2001 RMCPU |  |  |  | C | POTENTIAL $[NAME] FOR INTEREST LOSS
 |  |  |  |  |  | D | POTENTIAL CONVERSION ALLOWANCE = A+B+C =
4 |  | FY 2001 GROSS AUTHORITY |  |  |  | E | DID THE DISTRICT CONVERT? (1=YES; 0=NO)
 |  | = 1.231716469 X (1) X (2) =
5 |  | FY 2001 GROSS/RMCPU = (4)/(3) = |  |  |  | F | ACTUAL CONVERSION ALLOWANCE = D X E =
Spreadsheet: 729089d1618907485-match-returning-na-index-match
Sheet: VLOOKUP Function

 | Emp ID | First Name | Last Name | Dept | Pay Rate
 | 1054
 | 1056
 | 1067
 | 1075
 | 1078
 | 1152
 | 1196
 | 1284
 | 1302
 | 1310
 | 1329
 | 1333
 | 1368
Spreadsheet: 858673d1707282990-wta-how-to-only-capture-date-within-month-only-testing-date
Sheet: Summary

SEP | 2024
Date | Day | AAs received | AAs cleared | AAs carried forward | Workforce | Average productivity | Daily Utilization |  |  | public holiday
 |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | New Year
 |  | 2024-01-03 00:00:00 |  |  |  |  |  |  |  | 2024-01-25 00:00:00 | [NAME]
 |  | 2024-01-04 00:00:00 |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | Feb
 |  | 2024-01-05 00:00:00 |  |  |  |  |  |  |  | 2024-02-12 00:00:00 | Feb
 |  | 2024-01-08 00:00:00 |  |  |  |  |  |  |  | 2024-03-28 00:00:00 | Feb
 |  | 2024-01-09 00:00:00 |  |  |  |  |  |  |  | 2024-04-08 00:00:00 | test
 |  | 2024-01-10 00:00:00
 |  | 2024-01-11 00:00:00
 |  | 2024-01-12 00:00:00
 |  | 2024-01-15 00:00:00
 |  | 2024-01-16 00:00:00
 |  | 2024-01-17 00:00:00
 |  | 2024-01-18 00:00:00
 |  | 2024-01-19 00:00:00
 |  | 2024-01-22 00:00:00
 |  | 2024-01-23 00:00:00
 |  | 2024-01-24 00:00:00
 |  | 2024-01-26 00:00:00
 |  | 2024-01-29 00:00:00
 |  | 2024-01-30 00:00:00
 |  | 2024-01-31 00:00:00
Spreadsheet: 695020d1599971816-automatic-filter-calculation-does-not-repeat-the-number-problem-sample0913
Sheet: Sheet1

Code | category |  |  | 45
3114251573 | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | D
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | C
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | C
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | D
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | C
[PHONE] | C
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | A
[PHONE] | B
[PHONE] | C
Spreadsheet: larry_may__21650__Balance Sheet0721
Sheet: agaupdates

pira | producing | east | west
 | east | producing | west |  | AGA |  |  | pira |  |  | ADJ |  |  |  |  | AGA
 | 2 | 3 | 4 |  | east | producing | west | east | producing | west | east | producing | west | east | west | producing | east | west
OCT-98 |  |  |  |  | 1763 | 896 | 435 | 1763 | 896 | 435 | 0 | 0 | 0
NOV-98 |  |  |  |  | 1719 | 906 | 452 | 1719 | 906 | 452 | 0 | 0 | 0 | 1864 | 387 | 912 | 1725 | 452
DEC-98 |  |  |  |  | 1564 | 847 | 392 | 1564 | 847 | 392 | 0 | 0 | 0 | 1608 | 319 | 799 | 1483 | 386
JAN-99 |  |  |  |  | 1195 | 616 | 284 | 1195 | 616 | 284 | 0 | 0 | 0 | 1190 | 275 | 633 | 1051 | 329
FEB-99 |  |  |  |  | 933 | 575 | 237 | 933 | 575 | 237 | 0 | 0 | 0 | 595 | 220 |  |  |  |  | -69.66400911161725 | -44.04897494305237 | -16.2870159453303
MAR-99 |  |  |  |  | 720 | 520 | 220 | 720 | 520 | 220 | 0 | 0 | 0 | 544 | 200 |  |  |  |  | -104.4176706827309 | -75.73761713520747 | -27.84471218206158
APR-99 |  |  |  |  | 768 | 570 | 235 | 768 | 566 | 235 | 0 | 0 | 0
MAY-99
JUN-99
JUL-99
AUG-99
SEP-99
OCT-99
NOV-99
DEC-99
Spreadsheet: 768642d1645058207-stacking-multiple-ranges-to-one-combined-range-pq-append-week
Sheet: Wednesday

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
Run | Run | Start_Time | End_Time | Day of Week | Route | Block | EE ID
FT_2 | 856 | 0.2604166666666667 | 0.5833333333333334 | Wednesday | 856 | 856 | 1050295
FT_3 | 303 | 0.2708333333333333 | 0.65625 | Wednesday | 303 | 303 | 1050311
FT_4 | 304 | 0.2708333333333333 | 0.65625 | Wednesday | 304 | 304 | 1050800
FT_5 | 305 | 0.2708333333333333 | 0.65625 | Wednesday | 305 | 305 | 1050308
FT_6 | 306 | 0.2708333333333333 | 0.65625 | Wednesday | 306 | 306 | 1050292
FT_7 | 307 | 0.2708333333333333 | 0.65625 | Wednesday | 307 | 307 | 1050288
FT_8 | 308 | 0.2708333333333333 | 0.65625 | Wednesday | 308 | 308 | 1050290
FT_9 | 309 | 0.2708333333333333 | 0.65625 | Wednesday | 309 | 309 | 1050285
FT_10 | 310 | 0.2708333333333333 | 0.65625 | Wednesday | 310 | 310 | 1050331
FT_11 | 311 | 0.2708333333333333 | 0.65625 | Wednesday | 311 | 311 | 1050387
FT_19 | 312 | 0.2708333333333333 | 0.65625 | Wednesday | 312 | 312 | 1050334
[NAME] | 313 | 0.2708333333333333 | 0.65625 | Wednesday | 313 | 313 | 1050414
[NAME] | 314 | 0.2708333333333333 | 0.65625 | Wednesday | 314 | 314 | 1050383
FT_22 | 300 | 0.2604166666666667 | 0.5833333333333334 | Wednesday | 300 | 300 | 1050284
FT_23 | 301 | 0.2604166666666667 | 0.5833333333333334 | Wednesday | 301 | 301 | 1050418
Spreadsheet: 526119d1499135077-help-with-indirect-match-formula-help-with-indirect
Sheet: Review

ENTER MONTH HERE |  |  |  |  |  |  |  | Feb
 | Retail PI Accuracy |  | Freight Flow Channel & Receipts |  |  |  |  |  |  |  | Markdowns |  |  | Inventory | Sales |  | Return On Investment
 |  |  | HO Push |  |  |  | Manual Orders |  | Store PO |  |  |  |  |  |  |  | Inv: Sales Ratio
ORD DEPT # | SKU vs. Book $ | % Diff | [NAME] | Buyer Class | [NAME] | TAB Class | Manual Store | Manual % | Store Receipts | Class Receipts | Current $ | Promtional Deleted Inv | Modular Deleted Inv | Ending Book | YTD Sales | Current Sales | Store | Class
1
2
3
4
5
6
7
8
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
40
46
56
60
67
69
71
72
74
79
81
82
87
90
91
92
95
96
97
TOTALS
 |  |  |  |  |  |  |  |  |  | Percent of Inventory is deleted
Spreadsheet: 132380d1323723494-performing-an-if-statement-on-a-count-of-unique-records-test
Sheet: Sheet1

No. | Occurance | Wish
110401094 |  | 1
110700660 |  | 1
110802705 |  | 1
110602559 |  | 1
110602559 |  | 0
110602559 |  | 0
110602559 |  | 0
110602559 |  | 0
110802791 |  | 1
110802791 |  | 0
110802791 |  | 0
110400814 |  | 1
110400814 |  | 0
110400814 |  | 0
110802403 |  | 1
110700133 |  | 1
110700133 |  | 0
110702802 |  | 1
110702802 |  | 0
110500422 |  | 1
111104624 |  | 1
111102834 |  | 1
111000902 |  | 1
110500869 |  | 1
110303594 |  | 1
110303594 |  | 0
Spreadsheet: 858296d1707030186-in-order-from-the-largest-with-a-combination-of-cells-with-the-same-last-name-zeszyt1-robert-dj
Sheet: Arkusz1

 | name | amount |  |  | name | amount |  |  | [NAME] | Sum of amount
 | Beata | 2350 |  |  | [NAME] |  |  |  | [NAME] | 10500
 | [NAME] | 6000 |  |  | Renata |  |  |  | Renata | 9300
 | Agata | 1300 |  |  | [NAME] |  |  |  | [NAME] | 7000
 | Renata | 9300 |  |  | Andrzej |  |  |  | Andrzej | 3400
 | [NAME] | 5000 |  |  | Beata |  |  |  | Beata | 2350
 | Andrzej | 3400 |  |  | Agata |  |  |  | Agata | 1300
 | Baltazar | 1000 |  |  | Baltazar |  |  |  | Dorota | 1000
 | [NAME] | 2000 |  |  | Dorota |  |  |  | Baltazar | 1000
 | [NAME] | 4500 |  |  |  |  |  |  | Total Geral | 35850
 | Dorota | 1000 |  |  | name | amount
Spreadsheet: 104138d1301780627-add-every-value-in-categories-with-certain-prefixes-sample-workbook
Sheet: Sheet1

 | Category | Jan | Feb
 | RUX | 25 | 80
 | RUL |  | 18
 | RUC | 62 | 96
 | RUB | 120 | 270
 | RUA | 1 | 119
 | RVX |  | 7
 | RVL | 2 | 30
 | RVC | 5 | 5
 | RVB | 17 | 60
 | RVA |  | 26
Spreadsheet: 877096d1723773156-count-number-of-entries-with-duplicates-once-in-a-filtered-worksheet-count-duplicates-once-avijit74-
Sheet: Sheet1

 |  | Total Regd. Issued | Total Students applied
Sl. No. | Year | Registration No. | Student Name | Father's Name | Include in total regd. Issued
1 | 2022 | 1001-070204 | RAHUL ROY | ROHIT ROY
2 | 2022 | 1001-070205 | ISHAN MALLICK | PRABIR MALLICK
3 | 2022 | 1001-070206 | ROHIT BAL | RATAN BAL
4 | 2022 | 1001-070207 | SANJEEV KAPOOR | JITENDRA KAPOOR
5 | 2022 | 1001-070208 | NAYAN ARORA | SUNIL ARORA
6 | 2022 | 1001-070209 | SAYAN GHOSH | JIBAN GHOSH
7 | 2022 | NOT REGISTERED | NAVEEN DAS | TAPAN DAS
8 | 2023 | 1001-070210 | [NAME] | KABIR CHHETRI
9 | 2022 | 1001-070207 | SANJEEV KAPOOR | JITENDRA KAPOOR
10 | 2023 | 1001-070212 | JHUMA PAL | SOHAN PAL
11 | 2023 | 1001-070213 | RAHUL ROY | ROHIT ROY
12 | 2023 | 1001-070214 | KARAN KAPOOR | ARJUN KAPOOR
13 | 2023 | 1001-070215 | [NAME] | [NAME]
14 | 2023 | NOT REGISTERED | GOPAL GHOSH | KUNTAL GHOSH
15 | 2023 | 1001-070216 | PRIYA SANYAL | KAMAL SANYAL
16 | 2023 | 1001-070210 | [NAME] | KABIR CHHETRI
17 | 2023 | 1001-070218 | RAJEEV KUMAR | KIRAN KUMAR
18 | 2023 | 1001-070219 | SAYAN GHOSH | SUKUMAR GHOSH
19 | 2023 | 1001-070220 | PRIYANKA SINGH | MANJEET SINGH
20 | 2023 | 1001-070221 | SUNIL KUMAR | KAPIL KUMAR
21 | 2024 | NOT REGISTERED | RAJEEV KUMAR | KIRAN KUMAR
22 | 2024 | 1001-070222 | RONIT DAS | RATUL DAS
23 | 2024 | 1001-070223 | PUJA BANERJEE | DIBAKAR BANERJEE
24 | 2023 | 1001-070215 | [NAME] | [NAME]
25 | 2024 | 1001-070225 | ANUJ AGARWAL | BISHAL AGARWAL
In column C I have registration numbers. Some are not registered and some with same registration number. I want to have the total count of registration numbers issued with duplicates once and excluding those not registered in C2.  [NAME] should work.
In column D I have student names. Some names have the same father's name. That is the same person. Some names are same but father's name is different, that means different person. some names have same father's name but have different registration number, that means different person. Now, I want to have the total count of students to whom unique registration numbers were issued with duplicates once and including those not registered in C3. Filter should work.
Please help. Thank you so much.
Spreadsheet: 88167d1288086786-grab-from-one-table-and-insert-into-another-minus-empty-fields-sort-data-in-one-box-to-another-box
Sheet: Sheet1

 | Crew | Msn Number
Location A
Location A | Doe, [NAME] | 123
Location A
Location A
Location A
Location A
Location B
Location B
Location B | [NAME], [NAME] | 456
Location B |  |  |  |  |  | Crew | Msn Number
Location B |  |  |  |  |  | Doe, [NAME] | 123 | <--Auto populate from B2:C25
Location B |  |  |  |  |  | [NAME], [NAME] | 456
Location C |  |  |  |  |  | Jones, [NAME] | 789
Location C
Location C | Jones, [NAME] | 789
Location C
Location C
Location C
Location D
Location D
Location D
Location D
Location D
Location D
Spreadsheet: 773507d1647886826-compare-2-lists-to-identify-matches-existing-values-test1
Sheet: Sheet2

 |  |  | ID |  |  |  | Team
 |  |  | [PHONE] |  |  |  | ABCD
 |  |  | [PHONE] |  |  |  | ABCD,XYZ
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE] |  |  |  | ABCD
 |  |  | [PHONE]