tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859036d1707493736-colour-coded-cells-with-formulas-example3-2-
Sheet: All Data

XXXXX Details |  |  |  |  |  |  | assessment 1 |  |  | Assessment 2 |  |  | Assessment 3 |  |  | Assessment 4 |  |  | Assessment 5
Ref3 | Name | Age | Sex | Ref4 | Ref5 | Status | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term
0001 | Name1 | 25 | M | unknow1 | Ref5 |  | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd
0002 | [NAME] | 26 | M | unknow2 | Ref5 |  | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-05-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf
0003 | Name3 | 27 | M | unknow3 | Ref5
0004 | Name4 | 28 | M | unknow4 | Ref5 |  |  |  |  | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh
0005 | Name5 | 29 | M | unknow5 | Ref5 |  | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg
0006 | Name6 | 30 | M | unknow6 | Ref5
0007 | Name7 | 31 | M | unknow7 | Ref5
0008 | Name8 | 32 | M | unknow8 | Ref5
0009 | Name9 | 33 | M | unknow9 | Ref5
0010 | Name10 | 34 | M | unknow10 | Ref5
Spreadsheet: 873597d1720104322-unpivot-via-formula-from-dynamic-array-output-unpivot-columns-via-formula
Sheet: Sheet1

 | FY25 |  |  |  |  |  |  |  |  | Desired Output Result in Dynamic Array
 | Q1 |  |  |  | Q2
 | 45444 | 45474 | 45505 | Q1FY25 Total | 45536 | 45566 | 45597 | Q2FY25 Total
P.O's | 5 | 2 | 0 | 7 | 3 | 3 | 3 | 9 |  | Statement | Fiscal | Quarter | Date | Category | Amount |  |  |  | Delete - it was only used on design stage
Overheads | 1 | 1 | 1 | 3 | 2 | 2 | 2 | 6 |  |  |  |  |  |  |  |  |  |  | rows
Revenues | 15 | 35 | 45 | 95 | 30 | 40 | 50 | 120 |  |  |  |  |  |  |  |  |  |  | columns
 |  |  | Dynamic Array
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MyCells | =MyRows*MyColumns
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MyColumns | =MAX(IF(Sheet1!$B$3:$CB$3<>"";COLUMN(Sheet1!$B$3:$CB$3);""))-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MyRows | =MAX(IF(Sheet1!$A$3:$A$100<>"";ROW(Sheet1!$A$3:$A$100);""))-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StartRow | =5
Spreadsheet: 806635d1669443626-conditional-days-counting-formula-between-two-dates-conditional-days-counting-formula
Sheet: Sheet1

DATE 1 | DATE 2 | STATUS
2022-11-23 00:00:00 | 2022-04-16 00:00:00
2022-06-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-05-28 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-10-19 00:00:00
2022-10-19 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
16.08.2022 | 2022-03-16 00:00:00
2022-11-23 00:00:00 | 2022-08-02 00:00:00
2022-10-19 00:00:00
2022-11-23 00:00:00 | 2022-07-22 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-05-28 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-11-03 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-04-08 00:00:00
16.08.2022 | 2022-05-09 00:00:00
2022-05-28 00:00:00 | 2022-03-17 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-06-19 00:00:00 | 2022-01-05 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-01-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-10-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-09-14 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-09-21 00:00:00
2022-10-19 00:00:00 | 2022-06-19 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-05-28 00:00:00 | 2021-10-25 00:00:00
16.08.2022
16.08.2022 | 2022-05-09 00:00:00
2022-11-03 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-02-01 00:00:00
2022-11-23 00:00:00 | 2022-08-27 00:00:00
2022-10-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
Spreadsheet: 854053d1704012177-identify-cells-that-are-counted-in-a-countifs-function-forum_points_name
Sheet: Sheet1

Name | Points |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6
[NAME] | 0 |  | Name | 2 | 3 | 6 | 4 | 1 | 2 | 1
[NAME] | 3 |  |  | [NAME] | [NAME] | Fred | [NAME] | [NAME] | [NAME] | [NAME]
Fred | 2 |  |  | [NAME] | Mark | [NAME] | [NAME] |  | Rachel
[NAME] | 4 |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] | 2 |  |  |  |  | [NAME] | Sue
[NAME] | 1 |  |  |  |  | Sharron
[NAME] | 0 |  |  |  |  | Sandra
[NAME] | 2
[NAME] | 5
[NAME] | 3
[NAME] | 2
Mark | 1
[NAME] | 1
[NAME] | 3
Rachel | 5
Sharron | 2
Sandra | 2
Sue | 3
[NAME] | 6
 |  |  | Points | 0 | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | Players
 |  |  |  | [NAME] | [NAME] | Fred | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  | [NAME] | Mark | [NAME] | [NAME] |  | Rachel
 |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | Sue
 |  |  |  |  |  | Sandra
Spreadsheet: 727141d1617727937-how-to-subtract-date-while-getting-output-considering-leap-years-age
Sheet: Sheet1

X Days | Todays Date | Member Turned 18 Years in Last X days | DOB Based on C2 -Days(18 Years) | Added as Suggested
30
31
29
Spreadsheet: 173e5fe5-b532-4c5f-a25e-fb5873a13899
Sheet: u.01.003

DIKLAT ONLINE PPPPTK IPA BANDUNG
[NAME] | : U.01.001
[NAME] | : IPA terpadu
Pengampu :
1
2
No. | Nama | NIP | Unit [NAME] | [NAME] | Alamat Instansi | [NAME] pos | [NAME] | Provinsi | No. HP | [NAME]
1 | ENDANG DUWI SITI ELIANA | 198606052009022010 | SMPN 2 SELAKAU TIMUR | GURU IPA | SELAKAU TIMUR | 79452 | sambas | [NAME] | [PHONE] | [EMAIL]
2 | KHAIRUL ANWAR, S.Pd | 197311161998021003 | SMP NEGERI 3 SITUBONDO | GURU | JL. TALKANDANG NO.1 SITUBONDO | 68356 | SITUBONDO | [NAME] | [PHONE] | [EMAIL]
3 | Drs. [NAME], MM | 196703041998021002 | SMP N 7 Bojonegoro [NAME] | [NAME]
4 | [NAME] NISWATIN FARIDA,S.Pd | 196706281990012001 | SMP NEGERI 1 TUREN | GURU | JL. PANGLIMA SUDIRMAN 1A TUREN MALANG | 65175 | KAB MALANG | [NAME] | [PHONE] | [EMAIL]
5 | [NAME] | 197204241999031003 | MTs [NAME] | Kepala Sekolah / Guru IPA | Jl. Majopahit NO 2 Payo Selincah Jambi | 36148 | [NAME] | [NAME] | [PHONE] | [EMAIL]
6 | [NAME] | - | SMA/SMP ALIRSYAD SATYA | [NAME] | [NAME] 2,7 | 40553 | [NAME] | [NAME] | [PHONE] | [EMAIL]
7 | SUMINAH | 197904102010012007 | SMP N 7 INDRALAYA UTARA | GURU | JL POROS PARIT INDRALAYA UTARA |  | KAB. OGAN ILIR | SUMATERA SELATAN | [PHONE] | [EMAIL]
8 | [NAME]. [NAME], S.Pd. | 19711011 199802 1 002 | SMP Negeri 3 Mendoyo | Guru | Jl. [NAME], Kec. Mendoyo | 82261 | Jembrana | Bali | [PHONE] | [EMAIL]
Spreadsheet: 809889d1671407652-counting-at-bats-in-a-baseball-scoresheet-league-scoring-for-excel-forum
Sheet: Teams

Away Team: | CPU Tigers
Home Team: | Deuvray League Angels |  | Hitters |  |  |  |  |  |  |  | Hitters
 |  |  | UIG | OVR | POS | Player | Series | PLY | BO |  | UIG | OVR | POS | Player | Series | PLY | BO
 |  |  | Pitchers |  |  |  |  |  |  |  | Pitchers
 |  |  | UIG | OVR | POS | Player | Series | PLY |  |  | UIG | OVR | POS | Player | Series | PLY
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T14

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
14 | Supernaturals | Player42 |  |  |  |  |  |  | Week 1
 |  | Player43 |  |  |  |  |  |  | Week 2
 |  | Player44 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player42 | 94 |  |  |  |  |  | Week 11
 |  | Player43 | 31 |  |  |  |  |  | Week 12
 |  | Player44 | 100 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 860387fe-3d8e-467d-a4d4-e7f54ccb6a78
Sheet: Sheet1

Genes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | RNA Genes | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
[NAME] RefSeq Genes Track |  |  |  |  | UCSC GenomeBrowser RepeatMasker Track
 | # of genes | gene/10Mbp |  |  |  | # of genes | gene/10Mbp
 | OR |  | p-value (Fisher's exact test) |  |  | 5S |  | p-value (Fisher's exact test)
NADs | 76 | 6.021339389110558 | 8.321477e-32 |  | NADs | 108 | 8.55664018452553 | 7.063177e-11
genome | 394 | 1.26782791579787 |  |  | genome | 1280 | 4.118831807668209
LADs | 306 | 2.323086545525644 | 1.306535e-57 |  | LADs | 552 | 4.190665925261947 | 0.001963615
 | ZNF |  |  |  |  | tRNA
NADs | 98 | 7.764358685958351 | 3.43017e-30 |  | NADs | 130 | 10.29965948137332 | 5.884928999999999e-07
genome | 711 | 2.287882355665701 |  |  | genome | 1956 | 6.294089856092982
LADs | 114 | 0.8654636149997499 | 0.9993365000000001 |  | LADs | 720 | 5.466085989472104 | 0.4292203
 | DEF |  |  |  |  | other*
NADs | 42 | 3.327582293982151 | 3.1841e-35 |  | NADs | 286 | 2.265925085902131 | 0.9794898000000001
genome | 63 | 0.2027237530336697 |  |  | genome | 7888 | 2.538230101475534
LADs | 57 | 0.4327318074998749 | 9.408839e-14 |  | LADs | 2397 | 1.819751127328421 | 1.155187e-18
 |  |  |  |  | [NAME] RNA Genes Track
 |  |  |  |  |  | # of genes
 |  |  |  |  |  | active | gene/10Mbp
 |  |  |  |  | NADs | 98 | 7.764358685958351 | 5.859335e-05
 |  |  |  |  | genome | 1093 | 3.517096223266682
 |  |  |  |  | LADs | 192 | 1.457622930525895 | 1.82408e-25
 |  |  |  |  |  | pseudogenes* | gene/Mbp
 |  |  |  |  | NADs | 355 | 2.812599319913485 | 1.813372e-09
 |  |  |  |  | genome | 6111 | 1.966420404426596
 |  |  |  |  | LADs | 1918 | 1.456104573306596 | 3.791354e-11
 |  |  |  |  |  | active tRNA+5S | gene/Mbp
 |  |  |  |  | NADs | 42 | 3.327582293982151 | 5.859335e-05
 |  |  |  |  | genome | 509 | 1.637879211018061
 |  |  |  |  | LADs | 140 | 1.062850053508465 | 0.0007355395
 |  |  |  |  |  |  |  | Table S5
Spreadsheet: 00fa8d5a-ab0f-47a1-b2aa-b7f2bef5c722
Sheet: Sheet1

Pre-requisites | CERTIFICATE | COURSE TITLE | NO | SECT | CREDS | PROFESSOR | DAY/TIME | ROOM | EXAM DATE | EXAM TIME
 |  | CONFLICTS | 700 | 1 | 3 | SEALING | MT 8:00 - 9:50 PM / TH 6:00 - 7:50 PM
 |  | CRIMINAL PROCEDURE | 506 | 1 | 3 | DIMINO | MT 8:00 - 9:50 PM / TH 6:00 - 7:50 PM
 |  | PROFESSIONAL RESPONSIBILITY | 702 | 1 | 3 | ROBINETTE | MT 6:00 - 7:50 PM / TH 8:00 - 9:50 PM
 |  | SEMINAR: TAX POLICY@ | 950 | 1 | 2 | HUSSEY | T 6:00 - 7:50 PM / TH 8:00 - 9:50 PM
NON -CLASSROOM CREDITS
Coreq: Prof. [NAME]. Prereq:  Evidence |  | [NAME] | 803 | 1 | 2-4 | [NAME] | M 5:00 - 5:55 PM
Coreq: Prof. [NAME]. Prereq:  Evidence |  | JUDICIAL EXTERNSHIP | 809 | 1 | 2-4 | [NAME] | M 5:00 - 5:55 PM
Evidence | Trial Ad Cert | I.T.A.P.# | 779 | 1 | 3 | LOCKARD | MAY 16 - MAY 23
Pro. Resp. and Evidence |  | PA CIVIL CLINIC# | 925 | 1 | 4 | LOCKARD
 |  | Textbook information (e.g., price, title, ISBN number, etc.) is available at www.widenerlawbookstore.com
 |  | # [NAME] SATISFY THE SKILLS REQUIREMENT             @ WILL SATISFY THE WRITING REQUIREMENT (Final grade will be based on either an exam or a research paper)
Spreadsheet: 747206d1631280417-help-with-inputting-data-from-one-sheet-into-calendar-room-bookings-trial
Sheet: December

 |  |  | Calendar of events
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 12 |  | <== Enter MONTH - 1 to 12
2 |  |  |  |  |  |  |  |  | Year | 2021 |  | <== Enter YEAR - 2018 to 2030
3
4
5
6
7
8
1
2
3
4
5
6
7
8
1
2
3
4
5
6
7
8
1
2
3
4
5
6
7
8
1
2
3
4
5
6
7
8
Spreadsheet: 93691d1293440230-highlight-rows-based-on-duplicate-with-conditions-highlight-dups-based-on-condtions-2
Sheet: Sheet1

Found | Option 1 | Target | Source | option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Option 7
FOUND | yes | / | source 1 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 2 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 3 | [NAME] |  |  |  | YES | option 1
FOUND | yes | / | source 4 | anyword 2 |  |  |  | YES | option 1
FOUND | yes | /2 | source 5 | anyword 3 |  |  |  | YES | option 2
FOUND | no | / | source 6 | [NAME] |  |  |  | YES | option 2
Spreadsheet: 849055d1699618941-unique-count-function-test2-1-
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector | weight
No. of Holdings |  | 3 |  |  |  |  | Fund 1 | Apple | A | 0.098
 |  |  |  |  |  |  | Fund 1 | Apple | A | 0.062
Concentration of top 3 |  | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.081
should be | 0.461 | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.059
 |  |  |  |  |  |  | Fund 1 | Alphabet | B | 0.033
 |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.093
 |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.035
 |  |  |  |  |  |  | Fund 1 | AON | C | 0.045
 |  |  |  |  |  |  | Fund 1 | Tesla | D | 0.071
 |  |  |  |  |  |  | Fund 1 | Bond | Cash | 0.028
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.041
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.025
 |  |  |  |  |  |  | Fund 2 | Microsoft | A | 0.035
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.079
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.042
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.05
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.052
Spreadsheet: 886867d1736966604-multiply-and-add-if-table-exist-certain-word-mdm-sheet
Sheet: Ohjelmien työkirja 2025

 |  |  | OVERALL
 |  |  | Code | Definition | W1 | [NAME]
 |  |  | YT
 |  |  | YV
 |  |  | AE
 |  |  | AT
 |  |  | C
 |  |  | P
 |  |  | H
 |  |  | O
 |  |  | W1
 |  |  | Code | Definition |  | A | B |  | In this scenario:
 |  |  | YT |  |  | 3 | 6 |  | If W1 table exist code YT it should multiply column A with column B
 |  |  | V |  |  | 3 | 6 |  | and add it up to overall table under W1 column
 |  |  | C |  |  | 4 | 5
 |  |  | YT |  |  | 4 | 5 |  | VLOOKUP finds only first of YT's figures, but not the second one
 |  |  | G |  |  | 2 | 3
Spreadsheet: 548714d1511284710-formula-to-perform-calculation-with-n-number-of-rows-based-on-cell-value-book1
Sheet: Sheet1

1 |  |  |  |  |  |  |  | Group Size: | 5 |  |  |  | dynamic
2
3 |  |  |  |  | Data point
4 |  |  |  |  | 1 | 4.55 | group 1 |  | AVERAGE St.Dev:
5 |  |  |  |  | 2 | 4.34
6 |  |  |  |  | 3 | 6.78
7 |  |  |  |  | 4 | 4.44
8 |  |  |  |  | 5 | 5.23
 |  |  |  |  | 6 | 3.35 | group 2 |  | LIST OF GROUP RESULTS:
 |  |  |  |  | 7 | 4.37
 |  |  |  |  | 8 | 4.14142857142857
 |  |  |  |  | 9 | 3.99607142857143
 |  |  |  |  | 10 | 3.85071428571429
 |  |  |  |  | 11 | 3.70535714285714 | group 3
 |  |  |  |  | 12 | 3.56
 |  |  |  |  | 13 | 3.41464285714286 |  |  | IGNORED
 |  |  |  |  | 14 | 3.26928571428571
 |  |  |  |  | 15 | 3.12392857142857
 |  |  |  |  | 16 | 2.97857142857143 | group 4
 |  |  |  |  | 17 | 2.83321428571429
 |  |  |  |  | 18 | 4.14142857142857
 |  |  |  |  | 19 | 3.99607142857143
 |  |  |  |  | 20 | 3.85071428571429
 |  |  |  |  | 21 | 3.70535714285714 | group 5
 |  |  |  |  | 22 | 3.26928571428571
 |  |  |  |  | 23 | 3.12392857142857
 |  |  |  |  | 24 | 2.97857142857143
 |  |  |  |  | 25 | 3.26928571428571
 |  |  |  |  | 26 | 3.12392857142857 | [NAME]
 |  |  |  |  | 27 | 2.97857142857143
 |  |  |  |  | 28 | 4.14142857142857
 |  |  |  |  | 29 | 3.99607142857143
 |  |  |  |  | 30 | 3.85071428571429
 |  |  |  |  | 31 | 3.44 | group 7 | IGNORE! GROUP NOT COMPLETE
 |  |  |  |  | 32 | 3.67
Spreadsheet: 220050d1363040654-help-extracting-certain-portion-of-a-cell-xlf-pendingtransactions-template
Sheet: Batch

TxnType | Account | MerchantReference | CardNumber | ExpiryDate | Amount | PreAuthNumber | CPC | CarHolderName
Spreadsheet: 0f4f8742-182a-48b3-8d67-a2e40d957c98
Sheet: Fixed Costs

Mt San Jacinto Community College
Fiscal Year 2013-2014
Tentative Fixed Costs & H&W Object Codes
Instructions:
1. Determine employee's object code and whether PERS or STRS. (If employee does not pay into STRS or PERS just exclude that amount from the total fixed costs.)
2. Enter salary amount in box below "Salary".
3. [NAME] will calculate amount of fixed costs on that salary and will provide a total.
Non-Instructional Certificated |  |  |  | Instructional |  |  |  | Non-Instructional Classified
12XX |  |  |  | 11XX          22XX |  |  |  | 21XX
14XX |  |  |  | 13XX          24XX |  |  |  | 23XX
Description | Object Code | % of Wages |  | Description | Object Code | % of Wages |  | Description | Object Code | % of Wages
STRS | 3130 | 0.0825 |  | STRS | 3110 | 0.0825 |  | STRS | 3120 | 0.0825
PERS | 3230 | 0.11442 |  | PERS | 3210 | 0.11442 |  | PERS | 3220 | 0.11442
FICA | 3330 | 0.062 |  | FICA | 3310 | 0.062 |  | FICA | 3320 | 0.062
MEDICARE | 3335 | 0.0145 |  | MEDICARE | 3315 | 0.0145 |  | MEDICARE | 3325 | 0.0145
UNEMPLOYMENT | 3530 | 0.0005 |  | UNEMPLOYMENT | 3510 | 0.0005 |  | UNEMPLOYMENT | 3520 | 0.0005
WORKER'S COMP | 3630 | 0.02331 |  | WORKER'S COMP | 3610 | 0.02331 |  | WORKER'S COMP | 3620 | 0.02331
H&W | 3430 | MONTHLY |  | H&W | 3410 | MONTHLY |  | H&W | 3420 | MONTHLY
PERS EMPLOYEE |  |  |  | PERS EMPLOYEE |  |  |  | PERS EMPLOYEE
Salary: |  |  |  | Salary: |  |  |  | Salary:
 | 3230 |  |  |  | 3210 |  |  | 30000 | 3220
 | 3330 |  |  |  | 3310 |  |  |  | 3320
 | 3335 |  |  |  | 3315 |  |  |  | 3325
 | 3530 |  |  |  | 3510 |  |  |  | 3520
 | 3630 |  |  |  | 3610 |  |  |  | 3620
 | 3430 |  |  |  | 3410 |  |  |  | 3420
 | Total |  |  |  | Total |  |  |  | Total
STRS EMPLOYEE |  |  |  | STRS EMPLOYEE |  |  |  | STRS EMPLOYEE
Salary: |  |  |  | Salary: |  |  |  | Salary:
 | 3130 |  |  |  | 3110 |  |  |  | 3120
 | 3330 |  |  |  | 3310 |  |  |  | 3320
 | 3335 |  |  |  | 3315 |  |  |  | 3325
 | 3530 |  |  |  | 3510 |  |  |  | 3520
 | 3630 |  |  |  | 3610 |  |  |  | 3620
 | 3430 |  |  |  | 3410 |  |  |  | 3420
 | Total |  |  |  | Total |  |  |  | Total
Spreadsheet: 690571d1597168850-need-vlookup-to-return-the-value-to-the-right-test
Sheet: data

CSPDUEDATE | CSPCHAMAK | CSPCHAMOD | CSPCHAVIN | Est Date
06/25/2020 | - FTL | M2 | [NAME]
07/01/2020 | FTL | M2 | MN2501
07/10/2020 | FTLINER | M2-106 | MP1566
07/10/2020 | FTLINER | M2-106 | MP1567
07/13/2020 | FTLINER | M2 | MN6814
07/13/2020 | FTLINER | CASCADIA | MN8047
07/14/2020 | FTLINER | M2 | MN6812
07/14/2020 | FTLINER | M2 | MN6805
07/15/2020 | FTLINER | CASCADIA | MN8048
07/17/2020 | FTL | M2 | MP4990
07/20/2020 | FTLINER | M2 | MP3271
08/07/2020 | FTL | M2 | MM3845
08/10/2020 | FTLINER | M2 | MP6904
08/10/2020 | FTLINER | M2 | MP6903
08/10/2020 | FTLINER | M2 | MP6801
08/14/2020 | FTLINER | M2 | MP9409
08/14/2020 | FTLINER | M2 | MP9408
08/28/2020 | FTL | M2-106 | -
08/28/2020 | FTL | M2-106 | -
11/14/2020 | Int'l | MV607 | 326702
11/14/2020 | Int'l | MV607 | 327093
08/21/2020 | Int'l | MV607 | 241672
08/21/2020 | Int'l | MV607 | 241687 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
08/21/2020 | Int'l | MV607 | 241717 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
08/21/2020 | Int'l | MV607 | 241688 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
08/21/2020 | Int'l | MV607 | 241796 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
08/21/2020 | Int'l | MV607 | 241718 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
11/28/2020 | Int'l | MV607 | 657871 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
09/04/2020 | Int'l | MV607 | 589659 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Spreadsheet: 731618d1620460536-counting-the-number-of-diagnosis-codes-by-context-specialty-and-provider-sample-data-excel-ans
Sheet: Input

contextid | visitbillid | specialtyname | providername | Diagnosis code |  | HELPER
78 | 34 | OB | TITLO | Z01419,Z951,E663,M810
78 | 35 | OB | TITLO | Z01419,N952,E663,E559
78 | 36 | OB | TITLO | [NAME]
78 | 37 | OB | TITLO | Z01411,N952,E663,E559,Z780,Z713
712 | 89 | Medicine | JAGLO | Z00129,Z130,Z1388,Z713,Z6853
712 | 90 | Medicine | JAGLO | Z00129,Z713,Z7182,Z6852
712 | 91 | Medicine | JAGLO | Z00121,H50011,Z713,Z6851,Z7182
712 | 92 | Medicine | JAGLO | H6693,T85628A,Y838
Spreadsheet: joe_parks__14549__Febfisrt2002
Sheet: 1856 Cleburne Interstate

TRANSPORTATION NOMINATION
TXU LONE STAR |  |  |  |  |  |  |  |  |  | Page
PIPELINE COMPANY |  |  |  |  |  |  |  |  |  | From: |  | Enron Capital & Trade
301 South Harwood |  |  |  |  |  |  |  |  |  | Shipper: |  | Enron Capital & Trade
Dallas, TX 75201-5696 |  |  |  |  |  |  |  |  |  | Contact: |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Phone: |  | [PHONE]
Attn: |  | Scheduling Department-Wilma Easter |  |  |  |  |  |  |  | Fax: |  | [PHONE]
Fax: |  | [PHONE] |  |  |  |  |  |  |  | Date:
 |  | Contract #: | LS-MC-1856 | Start Date: | 2002-01-01 00:00:00 | End Date: | 2002-01-31 00:00:00
Receipt Point Information
Station # |  | Station Location Description |  | Upstream Shipper & Contract # |  | Previous Nom |  | Nominated |  | Fuel % | Fuel Amt. | Net Quantity
 |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
17-0547-01 |  | El Paso Waha |  | 9J6Z |  | 0 |  | 0 |  | 0.01
17-7462-50 |  | EPGT-PGE Waha |  | 5095037 |  | 0 |  | 0 |  | 0.01
18-0006-00 |  | TW Pecos |  | 27600 |  | 0 |  | 0 |  | 0.01
17-7462-50 |  | EPGT-PGE Waha |  | 5097039 |  | 0 |  | 0 |  | 0.01
Delivery Point Information
Station # |  | Station Location Description |  | Downstream Shipper & Contract # |  | Previous Nom |  | Nominated |  |  |  | Net Quantity
 |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
25-0002-00 |  | [NAME] |  |  |  | 0 |  | 0
17-0976-13 |  | HPL Texoma |  | 96061532 |  | 0 |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 9900
17-6405-00
Spreadsheet: 826769d1682261870-let-me-add-values-to-an-array-array-merged-aligw
Sheet: Sheet1

 | 7
2
3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 3
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 2 | 3 | 4 | 5 | 7
TEXTJOIN/TEXTSPLIT
2
3
4
5
7
Spreadsheet: 219176d1362677792-make-a-list-from-items-not-checked-off-isolation-blinds-tracker
Sheet: Dashboard

BLIND List
February 2013 Refinery Shutdown
 | Total Blinds |  |  |  |  | % Complete
 | Total Blinded
Unit | Total Blinds | [NAME] | [NAME] | [NAME] | Needs Insulation Removed | Ready to Blind | Blinded
500
600
700
800
900
1100
1400
1700/2200
1800
2800
2900
4200
4300