tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77356d1277843858-erase-characters-at-the-end-matching-certain-criteria-examplestar
Sheet: Sheet1

DATE | ID nummber | ID CODE
2010-05-16 00:00:00 | 32329312 | 23422342*PAN_ICBF*LOWR*RBRO*A
2010-05-16 00:00:00 | 123901923 | [PHONE]*WE*Kolis*RBBG*L
2010-05-16 00:00:00 | 2313124 | [PHONE]*RO*Kolis*RBBG*LIM
2010-05-16 00:00:00 | 12313109 | [PHONE]*RO*Kolis*RBBG*LIM
2010-05-16 00:00:00 | 1998231 | [PHONE]*VO*Kolis*RBBG*LIM
2010-05-16 00:00:00 | 74749343 | 630474EUR382330300*SO*Midas*RBBG*A
2010-05-16 00:00:00 | 26906413.4 | 630474EUR382331300*SO*Midas*RBBG*A
2010-05-16 00:00:00 | 22803243 | [PHONE]*PO*Midas*RBBG*LIM
2010-05-16 00:00:00 | 18700074 | 630477EUR382331306*RE*Midas*RBBG*A
2010-05-16 00:00:00 | 14596904.6 | [PHONE]*LE*Ponis*RBBG*L
2010-05-16 00:00:00 | 10493735 | [PHONE]*LE*Revol*RBBG*L
2010-05-16 00:00:00 | 6390565.4 | [PHONE]*LE*Hivol*RBBG*LIM
2010-05-16 00:00:00 | 2287395.8 | 234235345*LE*Onol*RBBG*LIM
2010-05-16 00:00:00 | 12313423 | 23424EUR382342330*RE*Lovis*RBBG*A
2010-05-16 00:00:00 | 12342349 | [PHONE]*LE*Dodis*RBBG*LIM
2010-05-16 00:00:00 | 2342949 | [PHONE]*LE*Kosoris*GHUE*LIM
2010-05-16 00:00:00 | 2349492 | 630494BGL382330300*RE*Kolis*FINNN*A
2010-05-16 00:00:00 | 983242423 | 630501EUR386901300*RE*Zonis*FINNN*LIM
2010-05-16 00:00:00 | 23423488 | 630502EUR382330300*RE*Noles*RBBG*A
2010-05-16 00:00:00 | 234238475 | 630511BGL386901300*RE*Mestris*RBBG*CC
2010-05-16 00:00:00 | 5732824 | 630511BGL386901300*RE*Miovin*RBBG*LIM
2010-05-16 00:00:00 | 82342495 | 734248EUR386901300*RE*Monah*RBBG*CC
2010-05-16 00:00:00 | 892324238 | 630511EUR386901300*RE*Kolis*FINN*LIM
2010-05-16 00:00:00 | 8435234232 | [PHONE]*LE*Fidas*RBBG*L
2010-05-16 00:00:00 | 7116549331.2 | [PHONE]*FER*Mestris*RBBG*L
2010-05-16 00:00:00 | 8845407624 | [PHONE]*LE*Westris*RBBG*LIM
2010-05-16 00:00:00 | 10574265916.8 | 630527EUR382330300*RE*Midas*RBBG*A
2010-05-16 00:00:00 | 12303124209.6 | [PHONE]*LE*Midas*RBBG*L
2010-05-16 00:00:00 | 14031982502.4 | [PHONE]*LE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 15760840795.2 | [PHONE]*LE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 17489699088 | [PHONE]*LE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 19218557380.8 | [PHONE]*LE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 20947415673.6 | 630544EUR386901306*RE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 22676273966.4 | [PHONE]*LE*Midas*RBBG*L
2010-05-16 00:00:00 | 24405132259.2 | 630562BGL382331306*RE*Midas*RBBG*A
2010-05-16 00:00:00 | 26133990552 | [PHONE]*LE*Hadas*RBBG*L
2010-05-16 00:00:00 | 27862848844.8 | [PHONE]*LE*Monet*RBBG*L
2010-05-16 00:00:00 | 29591707137.6 | 630592BGL386901320*RE*Midas*RBBG*LIM
2010-05-16 00:00:00 | 31320565430.4 | [PHONE]*LW*Korin*RBBG*LIM
2010-05-16 00:00:00 | 33049423723.2 | 231938EUR23434234*FE*Xtypo*RBBG*A
2010-05-16 00:00:00 | 34778282016 | [PHONE]*LE*Midas*RBBG*L
2010-05-16 00:00:00 | 36507140308.8 | 28349823BGL382330300*KER*Polis*RBBG*A
2010-05-16 00:00:00 | 38235998601.6 | 12313123*LE*Folin*RBBG*LIM
Spreadsheet: 136844d1326841704-chart-adm-and-vst-chart_pt_jpr73
Sheet: Sheet1

 |  |  |  |  | Items | visits | admits
 |  |  |  |  | [NAME] | 1267 | 96
 |  |  |  |  | Burns | 750 | 151
 |  |  |  |  | Croce | 1445 | 97
 |  |  |  |  | [NAME] | 568 | 103
 |  |  |  |  | [NAME] | 666 | 7
 |  |  |  |  | Carroll | 902 | 62
 |  |  |  |  | [NAME] | 1380 | 105
 |  |  |  |  | Sargent | 333 | 5
 |  |  |  |  | Digiovan | 1230 | 84
 |  |  |  |  | [NAME] | 259 | 16
 |  |  |  |  | Shiho | 790 | 1
 |  |  |  |  | Kouagheu | 908 | 48
 |  |  |  |  | [NAME] | 141 | 3
Spreadsheet: 122091d1316613918-how-can-i-generate-non-iterative-random-numbers-with-randbetween-25-unique-between-1-and-100
Sheet: Sheet1

0.5778211935615913 | 41
0.09397418219804177 | 91 |  | just pick top or bottom 25
0.8166002510572141 | 18 |  | f9 to recalculate
0.4008624201431648 | 63
0.7456492697573289 | 24
0.7333047542860571 | 26
0.2335324931959568 | 76
0.8151772713628456 | 19
0.566653152221408 | 43
0.9084488094852627 | 7
0.7100717312127176 | 29
0.3898941186934275 | 64
0.6653354599348809 | 31
0.94226279580122 | 5
0.02205315448093703 | 99
0.3299471994271483 | 68
0.7448111966178388 | 25
0.09237800521734307 | 92
0.5885502149072253 | 40
0.4982836479371544 | 52
0.3836005142485879 | 65
0.7578583293235222 | 23
0.7167441940618744 | 28
0.02825791510551845 | 98
0.9306411571525244 | 6
0.3067126448294468 | 72
0.8292544573141303 | 15
0.6158638027881267 | 39
0.2953058312201098 | 73
0.4860962079299922 | 55
0.3072027788309084 | 71
0.4934372381415051 | 53
0.4289615956076906 | 61
0.1541440172937425 | 84
0.3266463539845041 | 69
0.8996805228786044 | 8
0.1243250646008169 | 88
0.1243686713525842 | 87
0.1201137789100999 | 89
0.292801834164099 | 74
0.140973770362667 | 86
0.4437026954396879 | 58
0.2233741722273082 | 78
0.03784092748738921 | 96
0.9817775085392308 | 1
0.5393053630030566 | 45
0.4584826617674165 | 57
0.8606208674114308 | 13
0.5133356971978573 | 49
0.9586426169427664 | 3
0.1548024747772665 | 83
0.3753466929004157 | 66
0.9474950318770674 | 4
0.1021749392175837 | 90
0.4393457324266286 | 60
0.2329609183162109 | 77
0.177970441248827 | 81
0.6540453171224361 | 34
0.6187087356280427 | 37
0.6509243341433435 | 35
0.6162229621824642 | 38
0.8175163284224503 | 17
0.05227193782051076 | 95
0.7780370634975791 | 22
0.7976593893991628 | 21
0.6281285278262345 | 36
0.89238966742999 | 10
0.6573948896950439 | 33
0.8191123993312077 | 16
0.7245818840748459 | 27
0.5248133526924941 | 48
0.1418810851887899 | 85
0.565771015949649 | 44
0.4728571124758965 | 56
0.1616186875706154 | 82
0.6619756649064561 | 32
0.2641487337567112 | 75
0.6947206375948396 | 30
0.03266817277908274 | 97
0.08790972233535399 | 93
0.4411106842391093 | 59
0.5364826020115059 | 46
0.8986169122825354 | 9
0.3118807505950603 | 70
0.5670640757472682 | 42
0.5048227777225565 | 51
0.4910214543097053 | 54
0.964115451547148 | 2
0.803730609143523 | 20
0.8821978585483508 | 11
0.3315012017079271 | 67
0.5285314807857797 | 47
0.4057062253120769 | 62
0.8790906131635663 | 12
0.5128620460679292 | 50
0.008761578263798864 | 100
0.2156589848788271 | 79
0.2152507041318001 | 80
0.8498193461799137 | 14
0.07889841015139165 | 94
Spreadsheet: 853641d1703572635-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised
Sheet: Step2.1

Search 1 | Apple | < input field
Search 2 |  | < input field
Search 3 | Iphone | < input field
 |  |  |  | Search1 | Search2 | Search3 |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part | 2nd Sub | 2nd Sub IN | 2nd Part | HEader18
2023-09-12 00:00:00 | 8C | A-1256 | AC-125/X | Apple Inc | 12563 | Iphone 11 |  | ABC | 440 | 45 | 2563 |  |  | 564 | ABC-DSC/SE
2023-09-14 00:00:00 | DCV-25 | A/658 |  | Apple | 216 | Iphone 16 | LAS | MC | 26 | 736 | 256 | 12 | MET | 4123
 | 8C | A-1256 | AC-125/X | Apple Inc | 12563 | Iphone 11 |  | ABC | 440 | 45 | 2563 |  |  | 564 | ABC-DSC/SE
2023-09-14 00:00:00 | DCV-25 | A/658 | TC-46/6 | Apple | 216 | Iphone 16 | LAS | MC | 26 | 736 | 256 | 12 | MET | 4123
Spreadsheet: 273459d1382719709-table-results-comparison-test-eg
Sheet: Sheet1

 | Employee
Exam | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
A
B |  |  |  |  |  |  |  | X
C
D | X | X | X |  |  | X | X | X
E | X | X | X |  |  | X | X | X
F |  |  |  | X
G |  |  | X
H |  |  | X
I | X |  | X
J |  | X | X
K | X | X | X
L | X | X | X
M | X | X | X
N | X | X
O |  |  |  | X | X
P | X
Q | X | X | X
R | X | X | X
S
V |  |  |  |  | X
W |  |  |  | X | X
X |  |  |  | X | X
Y | X | X |  |  | X
Z |  | X | X
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -970 | -824
2 |  |  |  |  |  |  |  |  |  |  | -1043 | -824
3 |  |  |  |  |  |  |  |  |  |  | -872 | -824
4 |  |  |  |  |  |  |  |  |  |  | -727 | -824
5 |  |  |  |  |  |  |  |  |  |  | -670 | -824
6 |  |  |  |  |  |  |  |  |  |  | -720 | -824
7 |  |  |  |  |  |  |  |  |  |  | -648 | -824
8 |  |  |  |  |  |  |  |  |  |  | -711 | -824
9 |  |  |  |  |  |  |  |  |  |  | -466 | -824
10 |  |  |  |  |  |  |  |  |  |  | -1017 | -824
11 |  |  |  |  |  |  |  |  |  |  | -720 | -824
12 |  |  |  |  |  |  |  |  |  |  | -827 | -824
13 |  |  |  |  |  |  |  |  |  |  | -701 | -824
14 |  |  |  |  |  |  |  |  |  |  | -674 | -824
15 |  |  |  |  |  |  |  |  |  |  | -736 | -824
16 |  |  |  |  |  |  |  |  |  |  | -630 | -824
17 |  |  |  |  |  |  |  |  |  |  | -689 | -824
18 |  |  |  |  |  |  |  |  |  |  | -656 | -824
19 |  |  |  |  |  |  |  |  |  |  | -792 | -824
20 |  |  |  |  |  |  |  |  |  |  | -688 | -824
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 25186.41
2002-02-20 00:00:00
CBS Volume
 |  |  | 8555
Spreadsheet: jim_schwieger__14491__Inv_WC_true_up
Sheet: Inv & WC Value Adj

Inventory and Working Capital Calculation Statement Reconciliation
as provided in
Purchase and Sale Agreement
between
Enron Corp. "Seller"
and
AEP Energy Services Gas Holding Company "Buyer"
dated as of December 27, 2000
[NAME] (b) (e) and 2.5 (b), (e)
 |  |  |  |  |  |  | Enron Amounts |  |  | AEP Amounts |  | Difference
 |  |  | MMBtu |  | Rate |  | Value
Working Gas
 | Invoiced by Enron |  | 25924188 | (1) | 3.86
 | Actual |  | 25243641 | (2) | 3.26 | (3)
Working Gas Adjustment Due Buyer |  |  |  |  |  |  |  |  |  | 17773096.02
Add(Deduct):
 | Texas General Land Office |  | See attached Schedule I
 | Cannon |  | See attached Schedule I
 | Lyondell Citgo Adjustment |  | See attached [NAME] |  |  |  |  | -17000000
 | Centana Gas Payment |  | See attached [NAME] |  |  |  |  | See Note
 | Centana Ad Valorem Tax Proration |  | See attached [NAME]
 | Centana July Reimbursement |  | See attached [NAME] |  |  |  | 0 |  |  | 95130
 | Gas Lift Deposits |  |  |  |  |  | 25000 |  |  | 25225
 | [NAME] |  |  |  |  |  | 91000 |  |  | 91000
 | SAP to PeopleSoft Conversion |  |  |  |  |  |  |  |  | -43001.25
Adjusted Working Gas Payment
 | Interest Payment (4) |  |  |  |  |  |  |  |  | 486415.08
Adjusted Payment
Additional Invoices
 | D.L. Peterson Trust |  |  |  |  |  | 0 |  |  | 22152
 | Gregg Engineering Services Ltd. |  |  |  |  |  | -107635 |  |  | -60000
Total
 | (1) Estimated [NAME] volume as of 05/31/01
 | (2) Actual [NAME] volume as of 05/31/01
 | (3) Published Price in Inside FERC (HSC) for the month of July 2001
 | (4) Interest Payment calculated based on an assumed pay date of 10/31/01 for Daily Prime for 153 days (Enron calulcate on "Additional
 | Payment" and AEP calculated on "Workking Gas Adjustment"
Spreadsheet: 700870d1603378684-comparing-2-non-sequence-sheets-in-excel-to-find-unique-results-test-file
Sheet: Sheet2

Account Number | DOS | Visit Reason | Dx 1 | Dx 2 | Dx 3 | Dx 4 | Dx 5 | Dx 6 | Dx 7 | Dx 8 | Dx 9 | Dx 10 | Dx 11 | Dx 12
10617 | 2020-09-09 00:00:00 | Follow Up | [NAME] | E11.9 | E29.1 | I50.9 | E55.9 | E78.2 | E88.1 | F43.12 | G25.81 | K21.9 | L71.8 | M06.9
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 29632 | 30000 | 22925 | 25000
2 | 19946 | 30000 | 25047 | 25000
3 | 24779 | 29992 | 18690 | 24993
4 | 22643 | 30000 | 17753 | 25000
5 | 25628 | 30000 | 17735 | 25000
6 | 26763 | 30000 | 32416 | 25000
7 | 27062 | 30300 | 37211 | 25000
8 | 28834 | 29390 | 38206 | 32222
9 | 29402 | 30000 | 35474 | 25000
10 | 29274 | 30000 | 35344 | 25000
11 | 27694 | 30000 | 35698 | 25000
12 | 24700 | 30000 | 27304 | 31000
13 | 28925 | 29989 | 30174 | 30989
14 | 29257 | 30000 | 31971 | 28000
15 | 30136 | 29981 | 34927 | 24984
16 | 29674 | 30000 | 33990 | 28000
17 | 29616 | 30000 | 33152 | 28000
18 | 29698 | 30000 | 31574 | 28000
19 | 29720 | 30000 | 34470 | 28000
20 | 31137 | 33916 | 34208 | 27931
21 | 23948 | 35000 | 34570 | 28000
22 | 18108 | 34989 | 35411 | 27992
23 | 30974 | 35133 | 35384 | 36000
24 | 25513 | 35133 | 32454 | 36000
25 | 20844 | 35133 | 17307 | 36000
26 | 16635 | 18000 | 14722 | 15000
27 | 16202 | 16133 | 14656 | 15000
28 | 17956 | 15000 | 19505 | 12999
29 | 28080 | 29000 | 25671 | 26000
30 | 25886 | 29000 | 26480 | 26000
31 | 27301 | 29000 | 26053 | 26000
2000-11-30 00:00:00 |  | 622338.78 |  | -1050867.92
2000-12-31 00:00:00
Spreadsheet: 240547d1370357501-combining-columns-into-one-list-that-updates-itself-sorted-list-from-range-of-cells
Sheet: Sheet1

List-1 | List-2 | List-3 | List-4 | New List
2 | 6 | 9 | 13
3 | 7 | 10 | 14
4 | 8 | 11 | 15
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 181892fd-d5db-49de-bfc5-954614c14141
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37
Viceministerio de Educación para la Gestión Educativa
Dirección General de Educación Media
[NAME]
ÉNFASIS:  [NAME] Y ARTES
PLANILLA DE CALIFICACIONES/PERIODO:……………………………..
INSTITUCIÓN: ............................................................................
[NAME]: ..................................................................... |  |  |  |  |  |  |  |  |  |  | LOCALIDAD: …………....………… |  |  |  |  |  |  |  |  | REGIÓN:……………........CURSO: Tercero     SECCIÓN:..........TURNO:......... MES:..........[NAME]:………
Nº de orden | NÓMINA DE ALUMNOS | Documento |  | P L A N   C O M Ú N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAN ESPECIFICO |  |  |  |  |  |  |  | PLAN OPTATIVO |  | PROYECTO EDUCATIVO |  | Observación
 |  |  |  | Lengua, Literatura y sus Tecnologías |  |  |  |  |  |  | [NAME] y sus Tecnologías |  |  |  |  |  | Matemática y sus Tecnologías |  | [NAME] y sus Tecnologías |  | Educación Física y sus Tecnologías |  | Artes y sus Tecnologías |  | Comunicación |  |  |  |  |  | Educación para el Arte
 |  |  |  | [NAME] y Literatura |  | Guaraní        Ñe'ë |  |  |  | Lengua  Extranjera | Física |  |  |  | Química |  | Matemática |  | Filosofía |  | Educación Física |  | Artes |  | Análisis del discurso |  | Comunicación Oral |  | Comunicación Escrita |  | Educación para el Arte
 |  | [NAME] | Nº | Nº | [NAME] | Nº | [NAME] |  |  | Nº | Nº |  |  | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME] | Nº | [NAME]
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
Firma de profesores
 | ………………………………………………. |  |  |  |  |  |  | ………………………………………………. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ………………………………………………..................
 | [NAME]/a |  |  |  |  |  |  |  |  |  |  | Firma Director/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]/[NAME] y Control Administrativo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Continua en la Página siguiente
Spreadsheet: 50393d1249822610-random-card-dealings-dealings-2-
Sheet: Sheet1

 | ♣ | ♦ | ♥ | ♠
 | C | D | H | S |  | All |  | Player 1 | Player 2 | Player 3 | Player 4
1 |  |  |  |  | 0.942297891067942 | 1♣ | 1 | 1♦ | 1♠ | 2♠ | 10♠
2 |  |  |  |  | 0.5189151782587693 | 2♣ | 2 | 6♦ | 6♥ | J♦ | 5♥
3 |  |  |  |  | 0.4772926793734547 | 3♣ | 3 | 5♠ | J♥ | 8♥ | J♠
4 |  |  |  |  | 0.7027311266981524 | 4♣ | 4 | 6♣ | Q♠ | 3♥ | 2♦ |  | <<
5 |  |  |  |  | 0.7337223025548036 | 5♣ | 5 | 7♥ | K♥ | 9♥ | 4♠ |  | here write random dealings
6 |  |  |  |  | 0.09806039072655182 | 6♣ | 6 | 7♦ | 8♦ | 4♣ | 3♠
7 |  |  |  |  | 0.2624243254653848 | 7♣ | 7 | K♣ | 2♥ | 5♣ | J♣
8 |  |  |  |  | 0.4806273955441218 | 8♣ | 8 | 4♦ | 9♣ | 1♥ | 10♣
9 |  |  |  |  | 0.4529786388203547 | 9♣ | 9 | 8♠ | K♦ | Q♣ | 9♦
10 |  |  |  |  | 0.9145388547036815 | 10♣ | 10 | 4♥ | 3♣ | 7♠ | 9♠
J |  |  |  |  | 0.8974190448556048 | J♣ | 11 | 6♠ | 8♣ | 10♦ | 1♣
Q |  |  |  |  | 0.763766526894277 | Q♣ | 12 | 7♣ | 2♣ | K♠ | 10♥
K |  |  |  |  | 0.1623876286948338 | K♣ | 13 | 3♦ | Q♥ | 5♦ | Q♦
 |  |  |  |  | 0.02022841196282532 | 1♦
 |  |  |  |  | 0.8745608869074792 | 2♦
 |  |  |  |  | 0.2737973183536182 | 3♦
 |  |  |  |  | 0.1747905508843621 | 4♦
 |  |  |  |  | 0.8293272353204597 | 5♦
 |  |  |  |  | 0.03410508223481434 | 6♦
 |  |  |  |  | 0.1573396281116667 | 7♦
 |  |  |  |  | 0.4438146846790592 | 8♦
 |  |  |  |  | 0.9153452330399814 | 9♦
 |  |  |  |  | 0.8168606856572058 | 10♦
 |  |  |  |  | 0.6001208394183637 | J♦
 |  |  |  |  | 0.9980909277498391 | Q♦
 |  |  |  |  | 0.4623284311697651 | K♦
 |  |  |  |  | 0.7388495182628017 | 1♥
 |  |  |  |  | 0.4524458589750262 | 2♥
 |  |  |  |  | 0.6821079937323589 | 3♥
 |  |  |  |  | 0.193933445496401 | 4♥
 |  |  |  |  | 0.8316952201543535 | 5♥
 |  |  |  |  | 0.2900841359055981 | 6♥
 |  |  |  |  | 0.1276257288791094 | 7♥
 |  |  |  |  | 0.6236103217333215 | 8♥
 |  |  |  |  | 0.6882967429508207 | 9♥
 |  |  |  |  | 0.9736395200097152 | 10♥
 |  |  |  |  | 0.3250530154130695 | J♥
 |  |  |  |  | 0.5569913717557926 | Q♥
 |  |  |  |  | 0.4235890136392033 | K♥
 |  |  |  |  | 0.2790299506157625 | 1♠
 |  |  |  |  | 0.5644719974037395 | 2♠
 |  |  |  |  | 0.8908135021260701 | 3♠
 |  |  |  |  | 0.890731380134782 | 4♠
 |  |  |  |  | 0.08421130369437435 | 5♠
 |  |  |  |  | 0.2505405824505004 | 6♠
 |  |  |  |  | 0.7703872463646879 | 7♠
 |  |  |  |  | 0.1844735476000281 | 8♠
 |  |  |  |  | 0.926037979875953 | 9♠
 |  |  |  |  | 0.830327361734839 | 10♠
 |  |  |  |  | 0.8563465978539071 | J♠
 |  |  |  |  | 0.3912645232216176 | Q♠
 |  |  |  |  | 0.8202095595068803 | K♠
Spreadsheet: 851654d1701837982-generate-unique-list-and-convert-data-layout-unique
Sheet: Sheet1

China | Malaysia | Japan |  |  | *how do I generate the list of unique name base on A2:C5?
[NAME] | [NAME] | [NAME] |  |  | I want to get
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  | [NAME]
Attribute | Value |  |  |  | [NAME]
China | [NAME]
Malaysia | [NAME] |  |  |  | * Is it possible to use formula to convert the data to be like the below?
Japan | [NAME] |  |  |  | [NAME] | China
China | [NAME] |  |  |  | [NAME] | Japan
Malaysia | [NAME] |  |  |  | [NAME] | Malaysia
Japan | [NAME] |  |  |  | [NAME] | China
China | [NAME] |  |  |  | [NAME] | Japan
Malaysia | [NAME] |  |  |  | [NAME] | China
Japan | [NAME] |  |  |  | [NAME] | Malaysia
China | [NAME] |  |  |  | [NAME] | Japan
Malaysia | [NAME] |  |  |  | [NAME] | Malaysia
Japan | [NAME] |  |  |  | [NAME] | China
 |  |  |  |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Malaysia
Spreadsheet: 24a8228e-9269-498f-8e2e-8443fff77687
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Computer Science
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 154135d1336237484-need-help-how-to-count-occurrences-of-a-text-character-in-a-range-intake050512
Sheet: Sheet1

Unit 1 | Midnight: | 13 |  |  | 1 |  |  |  |  | Unit 2 | Midnight: | 5
 | Discharges: | 2 |  |  |  |  |  |  |  |  | Discharges: | 1
Name: | Apt | [NAME] | To Unit | Staff | Status |  |  | Notes |  | Name: | Apt | [NAME] | To Unit | Staff | Status |  |  | Notes
 |  |  |  |  |  |  |  |  |  | Jones | 19:00:00 | 1900-01-01 00:00:00 | 01:50:00 | KS | @
 |  |  |  |  |  |  |  |  |  | [NAME] | WI | 09:05:00 | 11:09:00 | BW | @
Smith |  |  |  |  | @ |  |  |  |  | [NAME] |  | 10:17:00 |  | BW
 |  |  |  |  |  |  |  |  |  | [NAME] |  | 10:00:00
Unit 3 | Midnight: | 30 |  |  |  |  |  |  |  | Unit 5 | Midnight: | 19
 | Discharges: | 6 |  |  |  |  |  |  |  |  | Discharges: | 5
Name: | Apt | [NAME] | To Unit | Staff | Status |  |  | Notes |  | Name: | Apt | [NAME] | To Unit | Staff | Status |  |  | Notes
Spreadsheet: 101641d1299729294-countif-function-with-dates-and-due-dates-elapsed
Sheet: Sheet1

Due in 7 Days
Due in 30 Days
Due in 90 Days
Lapsed
DATE
2009-01-01 00:00:00
2010-04-10 00:00:00
2011-03-11 00:00:00
2011-04-04 00:00:00
2011-04-18 00:00:00
2011-04-18 00:00:00
2011-04-20 00:00:00
2011-04-24 00:00:00
2011-04-30 00:00:00
2011-05-01 00:00:00
2011-05-21 00:00:00
2011-05-25 00:00:00
2011-05-31 00:00:00
2011-06-17 00:00:00
2011-06-23 00:00:00
2011-06-25 00:00:00
2011-06-25 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00
2011-06-26 00:00:00
2011-06-27 00:00:00
2011-06-27 00:00:00
2011-07-16 00:00:00
2011-07-20 00:00:00
2011-08-08 00:00:00
2011-08-16 00:00:00
2011-08-21 00:00:00
2011-09-08 00:00:00
2011-09-13 00:00:00
2011-09-16 00:00:00
2011-09-25 00:00:00
2011-09-28 00:00:00
2011-10-08 00:00:00
2011-10-09 00:00:00
Spreadsheet: 874094d1720653787-needs-if-formula-for-certain-condition-to-meet-team-bonus-farooq48-
Sheet: BONUS CALCULATOR

 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  | ACTUAL PAYMENT FACTORS
Employee ID | Full Name | Designation | Under Pre-Opening? (Yes/No) | Local Currency | Net / Gross | Annual Salary | Hire Date (M/D/YYYY) | Begin Date (M/D/YYYY) | End Date (M/D/YYYY) | Eligible? (Yes/No) | # of Eligible Days | % of Eligibility | Target Full Year Bonus Opportunity % | Actual [NAME] Achieved - Manager to indicated award % Mixed - 0%-75% Strong - 100%-150% Exceptional - 150%-200% | OP %  (30% weighting) | Core Team metrics i.e. PGI% + GSI% + RGI% (70% weighting) | Actual Bonus Award % | Reduction Factor (applicable only if GOP achieved is less than 95% of budget) | Final Bonus Award after applying reduction factor % | Bonus Amount (Local Currency) | Bonus Payment (IN USD) | Actual Bonus as % of Base | Comments
Input | Input | Dropdown | Dropdown | Input | Input | Input | Input | Calc | Input | Calc/Input | Calc | Calc | Calc | Input | Calc | Calc | Calc | Calc | Calc | Calc | Calc | Calc | Input
1262 | Test | test | No | USD | 100 |  | 2023-03-26 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Local Currency is SAR
 |  | GOP (absolute) |  |  |  | PERFORMANCE RESULTS: |  |  |  |  |  |  |  |  | Not a preopenning Team
 | Actual Achievement | 950 |  |  |  |  |  |  |  |  |  |  |  |  | All Employee eligible
 | [NAME] GOP amount | 1000 |  |  |  | Measures | % of Budget Achieved | % Target Payment Factor | % Actual Payment Factor |  |  |  |  |  | Target Full year Bonus opportunity is 20%
 | % of GOP Budget Achieved |  |  |  |  | %PGI | 1.1 |  |  | <<<<<
 |  |  |  |  |  | RGI | 0.95
 | Meet GOP Target? |  |  |  |  | GSI | 0.95
 |  |  |  |  |  | Totals
 | If GOP Actual Results for the current year are less than 95% of Target GOP then the Multipler equals "0.00" - no payout will be achieved.
 | Metric achievement | Payout
 | 1.2 | 2
 | 1.1 | 1.5
 | 1 | 1
 | 0.95 | 0.5
 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<<<<<<<<<<<<<
Spreadsheet: 763389d1642152195-populate-cells-based-on-content-clause
Sheet: Clause

Clause | A | B | C |  |  |  | A | B | C
1.1 | Yes | No | Yes
1.2 | No | No | Yes
1.3 | No | Yes | Yes
1.4 | Yes | Yes | No
1.5 | No | Yes | No
1.6 | Yes | No | Yes
1.7 | Yes | No | No
1.8 | Yes | No | Yes
1.9 | Yes | Yes | No