tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 126397 | 140595 |  | -14918 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 130730 | 150891 |  | -21381 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 160915 | 162126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 146983 | 153572 |  | -6935 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 216615 | 215822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 230620 | 230676 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 201058 | 210081 |  | -10154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 169372 | 171574 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 160298 | 167233 |  | -7013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 159930 | 171029 |  | -10981 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 169213 | 169874 |  | -2245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 147925 | 156137 |  | -8994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-08-31 00:00:00 |  |  |  | 70132
 | 2001-09-12 00:00:00
 | CBS Dollars
 |  |  |  | -318064
Spreadsheet: 866900d1713809127-summing-up-supplier-amounts-from-the-same-column-sample-sheet
Sheet: Sheet2

Supplier | Orders | Active Orders
Supplier A | 7.5 | 2.5
Supplier B | 13 | 4
Supplier C | 2.5 | 2.5
Supplier D | 1 | 1
Supplier E | 4 | 4
Supplier F | 3 | 3
Supplier G | 3 | 3
Spreadsheet: 6798f444-561a-4f1b-b345-6f23fc4389ee
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2923 | 15515 | Anne | Haug | GER | 50 | 00:15:56 | 00:00:00 | 00:26:06 | 00:00:00 | 00:23:18 | 1 | 1:05:23
Spreadsheet: 845257d1696782741-tax-calculation-formula-to-split-values-individually-based-on-a-summary-report-criteria-dummy-tax-cal_-1-
Sheet: REPORT

TARIFF | [NAME] | origin. | AMOUNT | ITEMISED | DUTY | VAT
94054920 | SOLAR LED LAMPS. | CN |  | 1 | 50000 | 1200
56029000 | FELT ARTICLES | CN |  | 2 | 25000 | 2500
83021000 | HINGES | CN |  | 3 | 10000 | 1500
83024900 | STEEL TUBES | FR |  | 4 | 23000 | 3000
83024900 | BASED METAL MOUNTINGS | CN |  | 5 | 1200 | 1500
 | [NAME] | origin. | Total Prix d'Achat en Devise | Itemised | Expected Results DUTY | Expected ResultsVAT
94054920 | SOLAR LED LAMPS. | CN | 576.44 | 1 | 50000 | 1200
56029000 | FELT ARTICLES | CN | 7.2 | 2 | 25000 | 2500
83021000 | HINGES | CN | 31.14 | 3 | 9999.999999999998 | 1500
83024900 | STEEL TUBES | FR | 25.15 | 4 | 23000 | 3000
83024900 | BASED METAL MOUNTINGS | CN | 252.04 | 5 | 1200 | 1500
 |  | Total | 891.97 |  | 109200 | 9700
Spreadsheet: 146413d1332173440-automaticaly-copy-data-from-worksheet-worksheet-registru-de-casa
Sheet: 1

SC FIRMA SRL |  |  |  |  | Data |  |  | Contul
 |  |  | REGISTRU DE CASA |  | Zi | Luna | An | casa
 |  |  |  |  | 1 | 1 | 2011 | 5311
Nr. [NAME] | Nr. Act casa | Nr. Anexa | Explicatii | Incasari | Plati |  |  | Simbol cont
Report/Sold [NAME] |  |  | Sold initial
1 | xc | 232 | sample | 111
2 | sd | 12 | sample 2 | 321
3 | xc | 32 | sample 3 | 2
4 | sd | 432 | sample 4 |  | 231
5 | as | 1233 | sample 5 | 331
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 |  |  | [NAME]
 |  |  | Sold final
 |  |  |  | Compartiment Financiar-Contabil
 | Casier
Spreadsheet: 73759d1274348850-match-value-that-is-closest-in-value-and-also-fulfills-other-criteria-problem1v3
Sheet: problem

STAGE 1 |  |  |  |  | including additional criteria
 | Items to be matched | items to match with |  | Desired outcome | Items to be matched | items to match with | Actual outcome | Desired outcome
 | Size in Mil$ | Size in Mil$ | PE Firm | Match | industry | industry | Match | Match
item 1 |  | 55 | 0 |  |  | 3 |  | N/A
item 2 | 98.741 |  | 0 |  | 5 |  |  | N/A
item 3 |  | 107 | 1 |  |  | 4 |  | N/A
item 4 |  | 833.354 | 1 |  |  | 3 |  | N/A
item 5 |  | 103 | 1 |  |  | 4 |  | N/A
Spreadsheet: tracy_geaccone__40328__CorpCharge_Model_Hyp_Actual - NEW
Sheet: Sum

Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O:\Corporate\GPGFin\Cfp\0103Plan\[capcharge.xls]Capital Charge Template
CAPITAL CHARGE CALCULATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36955.60077094907
2001
(Millions of Dollars)
 |  |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
ETS
ENA
Europe
EGA
EGM
EIM
ENW
EES
EEOS
EBS
EGEP
EREC
CF
EES - Wholesale
Total
Spreadsheet: 628909d1560957683-help-calendar-correction-employee-absence-schedule-current-6-13-19-amaramassage-
Sheet: February

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | February | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee 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 | 26 | 27 | 28 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s |  |  |  |  |  |  | v |  |  |  |  | s | s
 | Lynda
 | [NAME]
 | Heather |  |  |  |  |  |  | v | v
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | p | p
 | Emili |  |  |  |  |  | v | p | p |  |  |  | s | s | s |  |  |  |  |  |  |  | p
 | Amber |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v
 | Meredith
 | Julie |  |  |  |  | s | s | v
Spreadsheet: 884827d1734092320-automatically-generating-rows-based-subposts-forum
Sheet: Sheet1

 | Description - desired result |  |  | Table 2 |  |  |  | Table 1
 | Item | Item with sub-posts |  | Number of rows | Item | Reference number |  | Reference number | 1 | 2 | 3 |  | Chat-gpt
 | Beam01 | Beam01 |  |  | Beam01 | 1 |  | Number of rows
 | Beam01 | Formwork |  |  | [NAME] | 1 |  | Construction-type | Beam | Column | Wall
 | Beam01 | Reinforcement |  |  | Column01 | 2 |  | Sub-post 1 | Formwork | Formwork | Formwork
 | Beam01 | Casting |  |  | Column02 | 2 |  | Sub-post 2 | Reinforcement | Reinforcement | Recesses
 | Beam01 | Surface treatment |  |  | Wall01 | 3 |  | Sub-post 3 | Casting | Casting | Installation steel plates
 | [NAME] | [NAME] |  |  | Wall02 | 3 |  | Sub-post 4 | Surface treatment |  | Reinforcement
 | [NAME] | Formwork |  |  | Beam03 | 1 |  | Sub-post 5 |  |  | Casting |  |  | <--should be formwork
 | [NAME] | Reinforcement |  |  |  |  |  | Sub-post 6 |  |  | Surface treatment
 | [NAME] | Casting |  |  |  |  |  | Sub-post 7
 | [NAME] | Surface treatment |  |  |  |  |  | Sub-post 8
 | Column01 | Column01 |  |  |  |  |  | Sub-post 9
 | Column01 | Formwork |  |  |  |  |  | Sub-post 10
 | Column01 | Reinforcement |  |  |  |  |  | Sub-post 11
 | Column01 | Casting
 | Column02 | Column02
 | Column02 | Formwork
 | Column02 | Reinforcement
 | Column02 | Casting
 | Wall01 | Wall01
 | Wall01 | Formwork
 | Wall01 | Recesses
 | Wall01 | Installation steel plates
 | Wall01 | Reinforcement
 | Wall01 | Casting
 | Wall01 | Surface treatment
 | Wall02 | Wall01
 | Wall02 | Formwork
 | Wall02 | Recesses
 | Wall02 | Installation steel plates
 | Wall02 | Reinforcement
 | Wall02 | Casting
 | Wall02 | Surface treatment
 | Beam03 | Beam03
 | Beam03 | Formwork
 | Beam03 | Reinforcement
 | Beam03 | Casting
 | Beam03 | Surface treatment
Spreadsheet: 472634d1469690499-getpivotdata-formula-with-two-variables-month-and-country-example-file2
Sheet: PivotTable

CurrentDate
Country | MonthName | Sum of Traffic
Australia | January | 20
 | February | 20
 | March | 20
 | April | 20
 | May | 20
 | June | 20
 | July | 100
France | January | 10
 | February | 10
 | March | 10
 | April | 10
 | May | 10
 | June | 10
 | July | 300
US | January | 50
 | March | 50
 | April | 50
 | May | 50
 | June | 50
 | July | 200
 | Feburary | 50
Spreadsheet: 677d5144-f27b-4fd5-806c-c0a642d4e49c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | ANNEX I
 | [NAME]: |  |  |  |  |  | NIF:
 | Data de la Resolució: |  |  | Import ajuda concedida: |  |  | Import altres ajudes:
 | LLISTA ENUMERATIVA DE LES DESPESES DERIVADES DE L'EXPEDIENT |  |  |  |  |  | DE
N. | Núm. Fra. | Data Fra.  (DD/MM/AAAA) | Proveïdor | Concepte | Total base imposable | IVA | TOTAL | Data  pagament (DD/MM/AAAA) | Forma Pagament | Cost Imputable (sense IVA) *
Aquesta relació correspon [NAME] cost total definitiu del projecte subvencionable, els justificants del qual s'adjunten. |  |  |  |  | * Import de la factura que s'imputa al projecte subvencionat. En el cas que sigui la totalitat de la factura es repeteix [NAME] imposable.
 | Data:
 | [NAME]: |  |  |  |  |  |  |  |  | Full nº ________ de _________
N. | Núm. Fra. | Data Fra.  (DD/MM/AAAA) | Proveïdor | Concepte | Total base imposable | IVA | TOTAL | Data  pagament (DD/MM/AAAA) | Forma Pagament | Cost Imputable (sense IVA)
Aquesta relació correspon [NAME] cost total definitiu del projecte subvencionable, els justificants del qual s'adjunten.
 | Data:
 | [NAME]: |  |  |  |  |  |  |  |  | Full nº ________ de _________
Spreadsheet: 15d4df66-fe9f-472c-bba1-ccacc8986680
Sheet: Sheet1

CG number | gene name | VDRC transformant ID
CG12082* |  | v17567
CG14619 |  | v37929
CG15817 |  | v41605
CG3016 |  | v7090
CG30421 | CG3872 | v33726, v33727
CG32479 | CG13903 | v37858, v37859
CG4165* | USP45 | v41976, v41977
CG5384 | USP14 | v27405
CG5794 |  | v27517
CG5798* | USP8/UBPY | v8931, v107623
CG7023 |  | v27799, v27802
CG7288* |  | v47663
CG8445 | BAP1 | [NAME]
CG8334 |  | v18981
CG8494 | USP33 | v28910, v42609
CG8830 |  | v28960
CG5603* | CYLD | v15340
CG2904* | Ec | v106671
CG1945* | [NAME] | v2956, v30679
CG11025 | Isopeptidase-T-3 | v45496
CG4166* | NOT | v45775
CG5486 | UBP64E/USP47 | [NAME]
CG3431 | UCHL3 | v34617, v103481
CG4265 | UCHL1 | v26468, v103614
CG12359 | ULP1 | v31744
CG5505* | USP36 | v11152
CG1490* | USP7 | v18231, v110324
CG9448* |  | v24030
CG4968 |  | v21798
CG8877 | PRP8/PRPF8 | v18565, v18567
CG4603 | YOD1 | v21893, v21894
CG3416 | MOV34/PSMD7 | v108753
CG6932 | CSN6/COPS6 | v105385, v22307
Spreadsheet: 747265d1631321099-race-position-tracker-calc-ahead-and-behind-relative-to-own-position-race-position-tracker-calc-rev-1
Sheet: Lap Chart

 | Lap (Secs) | 74 |  |  |  | On Speedhive it's [NAME] |  |  |  |  |  |  |  | Speedhive Diff |  |  |  |  |  | Time to leader
 | Kart positions at pit in time |  |  |  |  |  |  |  |  |  |  |  |  | Speedhive Gap |  |  |  |  |  | Time between |  | <- Confirm GAP in mult-class is between class racers
 | Stop# | 1 |  |  |  |  |  | 2 |  |  |  |  |  | 3 |  |  |  |  |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20
 | Posn/Time
 |  | Kart | Gap | Help1 | Diff | Help2 | AB | Kart | Gap | Help1 | Diff | Help2 | AB | Kart | Gap | Help1 | Diff | Help2 | AB | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart |  | Kart
 | 1 | 99 |  |  |  |  |  | 99 |  |  |  |  |  | 99
 | 2 | 14 | 10 |  |  |  |  | 22 | 8 |  |  |  |  | 22 | 5
 | 3 | 22 | 4 |  |  |  |  | 14 | 2 |  |  |  |  | 14 | 3
 | 4 | 01 | 12 |  |  |  |  | 66 | 12 |  |  |  |  | 1 | 3
 | 5 | 66 | 5 |  |  |  |  | 1 | 5 |  |  |  |  | 66 | 8
74 | 6 | 11 | 12 |  |  |  |  | 11 | 12 |  |  |  |  | 11 | 12
148 | 7 | 44 | 20 |  |  |  |  | 77 | 20 |  |  |  |  | 44 | 2
222 | 8 | 77 | 2 |  |  |  |  | 44 | 2 |  |  |  |  | 77 | 6
 | 9 | 653 | 3 |  |  |  |  | 653 | 4 |  |  |  |  | 653 | 5
 | 10 | 666 | 8 |  |  |  |  | 666 | 10 |  |  |  |  | 666 | 12
 | 11 | 172 | 24 |  |  |  |  | 172 | 26 |  |  |  |  | 172 | 25
 | 12 | 171 | 14 |  |  |  |  | 171 | 16 |  |  |  |  | 171 | 12
 | 13 | 12 | 22 |  |  |  |  | 67 | 4 |  |  |  |  | 12 | 5
 | 14 | 67 | 2 |  |  |  |  | 12 | 4 |  |  |  |  | 67 | 5
 | 15 | 13 | 10 |  |  |  |  | 13 | 14 |  |  |  |  | 13 | 15
 | 16 | 27 | 2 |  |  |  |  | 27 | 4 |  |  |  |  | 27 | 6
 | 17 | 33 | 6 |  |  |  |  | 33 | 8 |  |  |  |  | 33 | 9
 | 18 | 31 | 10 |  |  |  |  | 31 | 13 |  |  |  |  | 31 | 1L
 | 19 | 6 | 2L |  |  |  |  | 6 | 2L |  |  |  |  | 6 | 2L
 | 20 | 7 | 3L |  |  |  |  | 7 | 4L |  |  |  |  | 7 | 4L
 | 21 | 9 | 5L |  |  |  |  | 9 | 6L |  |  |  |  | 9 | 7L
Spreadsheet: 65539d1266262690-excel-2007-conditional-formatting-panel-ckt-shell-office7-r4
Sheet: Panels

 |  | =+C5*$C4+D5*D$4
 | A | C | 4
 | A1 | D | 5
 | A2 | E
 | A3 | F
 | B | G
 | B1 | H
 | C | I
 | C1 | J
 | D | K
 | D1 | L
 | D2 | M
 | D3 | N
 | E | O
 | E1 | P
 | F | Q
 | F1 | R
 | F2 | S
 | F3 | T
 | G | U
 | [NAME] | V
 | H | W
 | H1 | X
 | J | Y
 | J1 | Z
 | K | AA
 | L | AB
 | M | AC
 | N | AD
 | P | AE
 | R | AF
 | S | AG
 | T | AH
 | U | AI
 | V | AJ
 | W | AK
 | X | AL
 | X1 | AM
Spreadsheet: 222640d1363896000-copying-down-into-blank-cells-tried-special-goto-and-blanks-not-working-trialfile-1-
Sheet: Forecast

 |  | 2013-03-17 00:00:00
Forecast |  | 179 | 411 | 466 | 517 | 538 | 513 | 521 | 521 | 521 | 521 | 265 | 265 | 215 | 165 | 165
Lot code | Quantity
RE10163B | 1260
Spreadsheet: 791986d1660681145-check-tab-not-checking-out-help
Sheet: Provided Forecast

Event | [NAME] | [NAME] | 2H Forecast
CEILING FANS |  |  |  |  | MAP
SPRING GIFT CENTER
OUTDOOR CLEANING TRAIN |  |  |  |  | Q3 | 1168953387
GRILL EVENT |  |  |  |  | Q4 | 1375960044
Q2 SPECIAL BUYS |  |  |  |  | DIV
SUMMER PAINT EVENT
HURRICANE TRAIN
POWER TRAIN WAVE 3
TOOL DAYS
BACK TO CAMPUS
BRUSHFIRE AND BLACKOUT TRAIN
Q2 CLEANING TRAIN
POWER TRAIN WAVE 4
Q3 SPECIAL BUYS
SUMMER CLEANING TRAIN
SUMMER STORAGE
GARAGE STORAGE
BATTERY TRAIN
SUMMER BATH
HEATED GEAR AND WORKWEAR
LABOR DAY PAINT
HALLOWEEN
HALLOWEEN HOOKUP
FIRE & SAFETY
POWER TRAIN WAVE 5
FALL CLEANUP
HOLIDAY HOOKUP
DECO HOLIDAY
HOLIDAY SPECIAL BUYS
[NAME]
SMART HOME TRAIN
WINTER STORAGE
Q4 TOOL STORAGE
2023 Q1 EVENTS
TOTAL
 | Forecast has been fully validated by Core Merch and Merchant
 | Forecast based off 85% of IPR/SEP buy data
 | Forecast provided by Merchant/AP
 | Forecast flat to LY
Spreadsheet: 481097d1474281914-create-a-number-in-a-cell-which-results-in-a-disired-value-in-an-other-cell-excel-forum
Sheet: Sheet1

number that create a value higher than 95% in column D | coefficent | variable | outcome
41 |  | 0.54
17 |  | 0.78
47 |  | 0.478
What is the formula that automatically fills a value that creates a value of >=95 in column D
 | 0.95 | 3 | 2
value in C3 need to be adjusted automatically to make sure that the value in Colomn A is above 95%
Spreadsheet: 118360d1313620767-countif-or-a-better-solution-pivottable
Sheet: Sheet4

Row Labels | Sum of Qty
9 AM | 2
11 AM | 1
12 PM | 1
1 PM | 1
2 PM | 2
3 PM | 2
4 PM | 1
5 PM | 1
6 PM | 2
7 PM | 2
8 PM | 1
Grand Total | 16
Spreadsheet: 121055d1315815200-the-frequency-formula-question-attachedfile
Sheet: Sheet2

 | meeting ID | Full name | presence | absence | תאריך ישיבה | quarter | year | company name
 | 1 | person 1 | 0 | 1 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 1 | person 2 | 1 | 0 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 1 | person 3 | 1 | 0 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 3 | 1 | 1 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 1 | 0 | 1 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple2 |  | #N/A
 | 2 | person2 | 1 | 0 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple2 |  | #N/A
 | 2 | person 3 | 1 | 0 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple2 |  | #N/A
 | 3 | person 1 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple |  | 1
 | 3 | person 3 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 1 | person 1 | 0 | 1 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple3 |  | 1
 | 1 | person 2 | 1 | 0 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple3 |  | #N/A
 | 1 | person 3 | 1 | 0 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple3 |  | 0
 | 2 | person 1 | 1 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 2 | person 1 | 0 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 2 | person2 | 1 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 3 | 1 | 0 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 3 | person 1 | 0 | 1 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 3 | person 2 | 0 | 1 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
Spreadsheet: 852843d1702820748-automating-this-action-over-an-entire-workbook-replace2
Sheet: Sheet2

WORD | GIVE NUMBER | CHANGE TO ZERO
yellow |  | 12
blue |  | 12
private |  | 66
yellow |  | 14
 |  | 14
yellow |  | 24
private |  | 2
yellow |  | 30 |  |  | 2
 |  | 176
yellow |  | 10
red |  | 4
red |  | 14
private |  | 68
red |  | 22
private |  | 36
blue |  | 34
 |  | 12
blue |  | 90
private |  | 152
yellow |  | 64
red |  | 152
private |  | 46
 |  | 4
Spreadsheet: 726839d1617532826-match-codes-from-file-sweep-savings-v1
Sheet: Weekly Code

 | 534199 16SPM
 | 555412 2SPM
 | 555320 SPM
 | 555933 2SPM
 | 554601 2CBPF
 | 579305 2CB
 | 570177 CB
 | 555765 CB
 | 589336 CB
 | 589502 1CB
 | 581311 CB
 | 589149 CB
 | 575975 CB
 | 541584 [NAME]
 | 579304 2CB
 | 050001 34522641
 | 534199 2SPM
 | 537503 SPM
 | 585309 10SPM
 | 585309 1SPM
 | 580606 SPM
 | 513475 CB
 | 589411 CB
 | 513063 3CB
 | 868161 CB
 | 589039 CB
 | 543028 CB
 | 554811 2CB
 | 555858 CB
 | 050001 33223280
 | 589709 CB
 | 581346 3CB
 | 589580 CB
 | 514374 SPM
 | 543075 CBI
 | 589521 CB
 | 523429 CB
 | 589911 CB
Spreadsheet: 027f969b-ab32-4b48-a6d0-a14db366c3ba
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC SGP Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 224 | 169 | 0 | 186 | 214
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 362 | 264 | 0 | 290 | 289
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 1 | 0 | 3 | 2
Term Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 505
Academic Year |  |  |  |  |  |  |  |  |  |  |  |  | 975 |  |  | 847 |  |  | 828
% of Total | Credit Headcount % of Total
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.38 | 0.39 |  | 0.39 | 0.4238
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.61 | 0.61 |  | 0.6 | 0.5723
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 | 0.01 |  | 0.01 | 0.004
Success Rate | Success Rate
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  | 0.72 | 0.81 |  | 0.76 | 0.67 |  | 0.62 | 0.63 |  | 0.6 | 0.52 |  | 0.6 | 0.57 |  | 0.63 | 0.67 |  | 0.61 | 0.63
Female |  | 0.75 | 0.73 |  | 0.65 | 0.7 |  | 0.59 | 0.6 |  | 0.69 | 0.65 |  | 0.68 | 0.65 |  | 0.7 | 0.67 |  | 0.65 | 0.58
Undeclared |  | 1 | 0.5 |  | 0.83 | 0.6 |  | 0.71 | 0.63 |  | 0.67 | 0.58 |  | 0.86 | 0.71 |  | 0.63 | 1 |  | 0.83 | 1
Term Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.67 | 0.67 |  | 0.64 | 0.61
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 719378d1613652722-populate-same-cell-with-2-possible-out-comes-with-if-isblank-test
Sheet: 2019

2019 | Record of Continuous Employment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re-Cert | Eye Sight Test Due | Last Eye Sight Test | Eye Sight Test Date
Month | O | N | D | J | F | M | A | M | J | J | A | S | O | N | D
M Mouse | Assessment required for |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-07 00:00:00
Spreadsheet: 795107d1662520115-filter-to-match-up-range-and-spill-data-in-range-array-filter-test-t1-
Sheet: Correct Answer

 |  |  |  |  |  |  | ********* Correct Answer***************
Matching Column |  |  |  |  |  |  | Extract 1 | Extract 2 | Extract 3 | Extract 4
300669661 |  |  |  |  |  |  | 0 | 0 | 446 | 0
618506401 |  |  |  |  |  |  | 0 | -68966.2 | 65 | 0
300496383 |  |  |  |  |  |  | 952813.58 | 910317.34 | 0 | 0
115942707 |  |  |  |  |  |  | 160592.78 | 160592.78 | 0 | 95
3669746 |  |  |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: 188036d1350661562-sort-numbers-that-are-stored-as-text-sortcolumn
Sheet: Sheet1

CopyResults
1.1-8x24mm
1.25-4x20mm
1.25-4x24mm
1.25-4x32[NAME]
1.25-8x32mm
1.25x20mm
1.5-4.5x20mm
1.5-4.5x32mm
1.5-4x20mm
1.5-5x20mm
1.5-5x32mm
1.5-6x40mm
1.5-6x42mm
1.5-6x44[NAME]
1.5x16[NAME]
1.5x24mm
1.75-4x24mm
1.75-4x32[NAME]
1.75-5x32mm
1.75-6x32mm
10-30x60mm
10-40X50mm
10-40X56mm
10-50x60mm
10x40mm
10x42mm
10x50mm
1-12x30mm
12.5-7x28mm
12-40x60mm
12x40mm
1-3x14mm
1-4x20mm
1-4x24mm
1-4x25mm
1-4x32mm
1-5x24mm
1-6.5x24mm
1-6x24mm
16x40mm
1x
1x14[NAME]
1x20[NAME]
1x24mm
1x25mm
1x26mm
1x27mm
1x28mm
1x30[NAME]
1x32mm
1x35mm
1x42mm
1x45[NAME]
2.5-10x40mm
2.5-10x42
2.5-10x42mm
2.5-10x44mm
2.5-10x50mm
2.5-10x56mm
2.5-15x56mm
2.5-16x42mm
2.5-16x50mm
2.5-7x32mm
2.5-8x32mm
2.5-8x36mm
2.5x20mm
2.5x28mm
2.5x30[NAME]
2.75x27mm
20-60x80mm
2-10x38mm
2-10x42mm
2-10x50mm
2-12x42
2-12x42mm
24x44mm
25x40mm
2-6x28mm
2-6x32mm
2-7x28mm
2-7x32mm
2-7x33mm
2-7x35mm
2-7x36mm
2x20mm
2X30mm
3.25x
3.5-10x36mm
3.5-10x40mm
3.5-10x42mm
3.5-10x44mm
3.5-10x50mm
3.5-10x56mm
3.5-21x50mm
3.5-25x56mm
3.5x-10x-40mm
3.5x35mm
30x40mm
3-10x40mm
3-10x44mm
3-12x32mm
3-12x40mm
3-12x42mm
3-12x44mm
3-12x50mm
3-12x52mm
3-12x56mm
3-15x42mm
3-15x50
3-15x50mm
3-18x44mm
35x45mm
36x42mm
3-7x20mm
3-9x32mm
3-9x33mm
3-9x38mm
3-9x40mm
3-9x42
3-9x42 mm
3-9x42mm
3-9x50mm
3-9x52mm
3x
3x30mm
3x32mm
3x-9x50[NAME]
3x-9x-50mm
4.5-14x32mm
4.5-14x40mm
4.5-14x42mm
4.5-14x44mm
4.5-14x50mm
4.5-14x56mm
4.5-18x 44mm
4.5-30x50mm
40x45mm
4-12x40mm
4-12x42mm
4-12x44mm
4-12x50mm
4-16x40mm
4-16x42mm
4-16x50mm
4-20x50mm
45x45mm
4x
4x15mm
4x-16x50mm
4x-16x-50[NAME]
4x20 [NAME]
4x22mm
[NAME]
[NAME]
4x30[NAME]
4x32[NAME]
4x33mm
[NAME]
5.5x50mm
5-15x40mm
5-20x50mm
5X-36mm
6.20x40mm
6.5-20x40mm
6.5-20x50mm
6.5-20x56mm
6-12x50mm
6-18x40mm
6-18x44mm
6-18x50mm
6-21x44mm
6-24x40mm
6-24x42mm
6-24x44mm
6-24x50mm
6x32[NAME]
6x36mm
6x42mm
6x48mm
7x24mm
8.5-25x50mm
8.5-32x50mm
8-26x50mm
8-32x40mm
8-32x50mm
8-32x56mm
8x30mm