tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 52432d1252132892-diagonal-matrix-fill-uh1
Sheet: Convo1

 |  |  |  | Time
Time | Q | U |  | 0 | 1 | 2 | [NAME] | diff (m3/s)
0 | 0 | 0 | 2.1 | 0 | 0 | 0 | 0 | 0
1 | 11 | 4.051684179665378 | 5.3 | 8.508536777297294 | 0 | 0 | 8.508536777297294 | -2.491463222702706
2 | 41 | 10.03536991746484 | 3 | 21.07427682667617 | 21.4739261522265 | 0 | 42.54820297890267 | 1.548202978902665
3 | 84 | 8.412548837271745 |  | 17.66635255827066 | 53.18746056256365 | 12.15505253899613 | 83.00886565983045 | -0.9911343401695518
4 | 86 | 5.702211107523572 |  | 11.9746433257995 | 44.58650883754024 | 30.10610975239452 | 86.66726191573426 | 0.6672619157342581
5 | 62 | 2.883618700935565 |  | 6.055599271964686 | 30.22171886987493 | 25.23764651181524 | 61.51496465365485 | -0.4850353463451498
6 | 32 | 0 |  | 0 | 15.28317911495849 | 17.10663332257072 | 32.38981243752921 | 0.3898124375292085
7 | 9 |  |  |  | 0 | 8.650856102806696 | 8.650856102806696 | -0.3491438971933043
8 | 0 |  |  |  |  | 0 | 0 | 0
Volume | 1170000 | m3 |  |  |  | Volume | 1163838.60189272 | -6161.398107280489 | m3
Spreadsheet: 175763d1345641453-average-results-of-vlookup-book1
Sheet: Sheet1

 | Lookup values
 | A | 5
 | B | 10
 | C | 15
 | D | 20
 | E | 25
 | This is what I would normally do: |  |  |  |  | This is what I'm hoping to do:
 | A | 5 |  |  |  | A
 | B | 10 |  |  |  | B
 | C | 15 |  |  |  | C
 | D | 20 |  |  |  | D
 | E | 25 |  |  |  | E
 | Average: | 15 |  |  | Average:
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: CAD Certificates 2

COMPUTER AIDED DRAFTING & DESIGN
Certificates
Student Name:
ID #
Computer Aided Drafter | Semester | Grade
Area 1:   Mathematics (MAT 105 excluded) (3)
Technical Core
___ Computer Literacy Course (1-3) or IC3 Computer Literacy Exam
___ CAD 100 (3) Introduction to Computer Aided Design
___ CAD 102 (4) Drafting Fundamentals
___ CAD 112 (4) Engineering Graphics
___ CAD 130 (4) Descriptive Geometry
Surveying Core
Choose 9-12 hours from the following
___ CAD 108 (3) Introduction to Surveying
___ SMT 110 (3) Principles of Surveying
___ SMT 130 (3) Land Surveying Graphics
___ SMT 160 (3) Construction Surveying
___ SMT 210 (3) Advanced Surveying Measurement
___ SMT 220 (3) Surveying Lab
___ SMT 230 (3) Land Boundary Location
___ SMT 250 (3) Mine Surveying
Spreadsheet: 878571d1725672116-points-given-to-8-people-over-a-year-ef_points_given_to_8_people_over_a_year
Sheet: Calc

All staff should get 2,250 points over the year, and payout average time should be almost same
Who gets points |  |  | Shuffle | Month | Points
1 | 2 | 3 |  |  | 500
2 | 3 | 4 |  |  | 500
3 | 4 | 5 |  |  | 500
4 | 5 | 6 |  |  | 500
5 | 6 | 7 |  |  | 500
6 | 7 | 8 |  |  | 500
7 | 8 | 1 |  |  | 500
8 | 1 | 2 |  |  | 500
1 | 5 | 0 |  |  | 750
2 | 6 | 0 |  |  | 750
3 | 7 | 0 |  |  | 750
4 | 8 | 0 |  |  | 750
 |  |  | Standard Deviation
Name | Shuffle | Staff # |  | Check
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
George
[NAME]
Payout |  | 2 get 750 each, 3 get 500 each |  |  | Points each
1 | January
2 | February
3 | March
4 | April
5 | May
6 | June
7 | July
8 | August
9 | September
10 | October
11 | November
12 | December
Spreadsheet: 785929d1656850862-comparing-lists-of-data-names-dont-match-2022-07-04-oeldere-ray1975-list
Sheet: oeldere

list1 |  | list 2 |  | list 1 in list 2 | list 2 in list 1
Abarca,Helena, |  | ,[NAME],[NAME],,
Abello,Anna, |  | ,[NAME],[NAME],,
Abreu,[NAME], |  | ABARCA,HELENA,
Agreda,Cristina, |  | [NAME],ANA, | Abello,Anna,
Aguado,Francisco,Dr. |  | ABREU,SHEILA,
Aguilera,[NAME], |  | AGUADO,DR. FRANCISCO, | Aguado,Francisco,Dr.
Aguilera,[NAME], |  | AGUILERA JUST,MARIA MONTSERRAT, | Aguilera,[NAME],
Alcaide,[NAME], |  | AGUILERA TORRES,EDWIN JESUS, | Aguilera,[NAME],
Alcaide,[NAME], |  | ALBA PEINADO,JORDI,
Alcalde,[NAME], |  | ALCAIDE,ELISABETH,
Alcaraz,[NAME], |  | ALCAIDE,MARIA DEL CARMEN,
Alhaja,Elena, |  | ALCARAZ,MONTSERRAT,
Almagro,Xavier,Dr. |  | ALHAJA,MARIA-ELENA,
 |  | ALMAGRO,DR. JAVIER,
Spreadsheet: 726094d1617038962-sumproduct-adding-date-to-time-range-only-works-for-same-date-calculate-intermediate-task-dates-and-times-with-breaks-mlan-
Sheet: Production scedule

start date | run time |  |  | working week | [NAME] | fri
2021-02-01 06:30:00 |  | = 11 modules in 74 working hours |  | start work | 06:30:00 | 06:30:00 | start break | break time
 | using sumproduct | using sumifs |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
due date before breaks | counting breaks [min] | counting breaks [min] |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  | lunch break start | 12:00:00
 |  |  |  | lunch break end | 12:25:00
 |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | Manually created scedule with correct due dates and times
 |  |  |  | mandag | tirsdag | onsdag | torsdag | fredag |  |  | mandag | tirsdag | onsdag | torsdag | fredag
 |  |  |  | 2021-02-01 06:30:00 | 2021-02-02 06:30:00 | 2021-02-03 06:30:00 | 2021-02-04 06:30:00 | 2021-02-05 06:30:00 |  |  | 2021-02-08 06:30:00 | 2021-02-09 06:30:00 | 2021-02-10 06:30:00 | 2021-02-11 06:30:00 | 2021-02-12 06:30:00
 |  |  |  | 2021-02-01 09:00:00 | 2021-02-02 09:00:00 | 2021-02-03 09:00:00 | 2021-02-04 09:00:00 | 2021-02-05 09:00:00 |  |  | 2021-02-08 09:00:00 | 2021-02-09 09:00:00 | 2021-02-10 09:00:00 | 2021-02-11 09:00:00 | 2021-02-12 09:00:00
 |  |  |  | 2021-02-01 09:20:00 | 2021-02-02 09:20:00 | 2021-02-03 09:20:00 | 2021-02-04 09:20:00 | 2021-02-05 09:20:00 |  |  | 2021-02-08 09:20:00 | 2021-02-09 09:20:00 | 2021-02-10 09:20:00 | 2021-02-11 09:20:00 | 2021-02-12 09:20:00
 |  |  |  | 2021-02-01 12:00:00 | 2021-02-02 12:00:00 | 2021-02-03 12:00:00 | 2021-02-04 12:00:00 |  |  |  | 2021-02-08 12:00:00 | 2021-02-09 12:00:00 | 2021-02-10 12:00:00 | 2021-02-11 12:00:00
 |  |  |  | 2021-02-01 12:25:00 | 2021-02-02 12:24:59.995000 | 2021-02-03 12:24:59.995000 | 2021-02-04 12:24:59.995000 |  |  |  | 2021-02-08 12:24:59.995000 | 2021-02-09 12:24:59.995000 | 2021-02-10 12:24:59.995000 | 2021-02-11 12:24:59.995000
 |  |  |  | 2021-02-01 15:15:00 | 2021-02-02 15:15:00 | 2021-02-03 15:15:00 | 2021-02-04 15:15:00 | 2021-02-05 11:50:00 |  |  | 2021-02-08 15:14:59.995000 | 2021-02-09 15:14:59.995000 | 2021-02-10 15:14:59.995000 | 2021-02-11 15:15:00 | 2021-02-12 11:50:00
 | expected results
due date incl. Breaks  using sumproduct | break minutes | expected due date |  | [NAME] and Times | Friday without breaks | Friday breaks (preliminary) | Mon - Thu without breaks | Mon - Thu breaks (prelim) | Prelim Due Date | Final Breaks | Final Due Date
 | 45
 | 45
 | 20
 | 45
 | 25
 | 40
 | 25
 | 45
 | 45
 | 45
 | 20
Spreadsheet: 290951d1390060080-how-to-get-the-a-conditional-value-and-underline-them-from-a-table-test-lowvalue180114
Sheet: Sheet1

slno | maths | geo | phy | che
1 | 29 | 7 | 20 | 29
2 | 14 | 19 | 6 | 19
3 | 36 | 12 | 19 | 11
4 | 38 | 47 | 16 | 47
5 | 5 | 10 | 32 | 10
6 | 29 | 14 | 15 | 34
7 | 11 | 32 | 41 | 22
8 | 41 | 15 | 13 | 32
9 | 9 | 41 | 47 | 15
10 | 48 | 9 | 10 | 41
Spreadsheet: 103725d1301446142-excel-2007-delete-row-12
Sheet: Sheet1

[NAME] | Punct (m) | Caz | MY (kNm)
138 | x=0.63 | 264 (K) | -68.76 | -
138 | x=0.63 | 81 (K) | -200.46 | MIN
138 | x=0.65 | 264 (K) | -69.95 | -
138 | x=0.65 | 81 (K) | -203.75 | MIN
138 | x=0.68 | 264 (K) | -71.15 | -
138 | x=0.68 | 81 (K) | -207.04 | MIN
138 | x=1.33 | 259 (K) | -269.12 | -
138 | x=1.33 | 98 (K) | -734.31 | MIN
138 | x=1.35 | 259 (K) | -265 | -
138 | x=1.35 | 98 (K) | -724.09 | MIN
138 | x=1.38 | 259 (K) | -260.88 | -
138 | x=1.38 | 98 (K) | -713.87 | MIN
195 | x=0.63 | 48 (K) | -79.94 | -
195 | x=0.63 | 144 (K) | -218.94 | MIN
195 | x=0.65 | 48 (K) | -75.46 | -
195 | x=0.65 | 144 (K) | -211.16 | MIN
195 | x=0.68 | 48 (K) | -70.99 | -
195 | x=0.68 | 144 (K) | -203.38 | MIN
195 | x=1.33 | 131 (K) | 34.49 | -
195 | x=1.33 | 143 (K) | -30.81 | -
195 | x=1.35 | 131 (K) | 39.57 | -
195 | x=1.35 | 143 (K) | -25.54 | -
195 | x=1.38 | 131 (K) | 44.65 | -
195 | x=1.38 | 143 (K) | -20.27 | -
195 | x=4.00 | 133 (K) | 239.99 | MIN
195 | x=4.00 | 317 (K) | 122.1 | -
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Phosphoric Acid

Raw Material |  | Phosphoric Acid
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 172.94
Total
Spreadsheet: 67331d1267958346-look-up-with-multiple-criteria-and-list-box-new-resource-03-help-v2
Sheet: Graphs

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 4.172888425928249
 |  |  |  |  |  |  |  |  |  |  |  | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00 | 2010-04-23 00:00:00 | 2010-04-30 00:00:00 | 2010-05-07 00:00:00 | 2010-05-14 00:00:00 | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 2010-06-04 00:00:00 | 2010-06-11 00:00:00 | 2010-06-18 00:00:00 | 2010-06-25 00:00:00 | 2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 2010-07-16 00:00:00 | 2010-07-23 00:00:00 | 2010-07-30 00:00:00 | 2010-08-06 00:00:00 | 2010-08-13 00:00:00 | 2010-08-20 00:00:00 | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00 | 2011-01-14 00:00:00 | 2011-01-21 00:00:00 | 2011-01-28 00:00:00 | 2011-02-04 00:00:00 | 2011-02-11 00:00:00 | 2011-02-18 00:00:00 | 2011-02-25 00:00:00 | 2011-03-04 00:00:00 | 2011-03-11 00:00:00 | 2011-03-18 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-08 00:00:00 | 2011-04-15 00:00:00 | 2011-04-22 00:00:00 | 2011-04-29 00:00:00 | 2011-05-06 00:00:00 | 2011-05-13 00:00:00 | 2011-05-20 00:00:00 | 2011-05-27 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 | 2011-06-17 00:00:00 | 2011-06-24 00:00:00 | 2011-07-01 00:00:00
 | Hours available to work
 | Project Hours |  |  |  |  |  |  |  |  |  |  | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Proposal Hours |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Workload Hours |  |  |  |  |  |  |  |  |  |  | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -142080 | -142462
2 | -138699 | -136853
3 | -135130 | -133387
4 | -125244 | -125558
5 | -106895 | -107400
6 | -115168 | -114773
7 | -98089 | -97774
8 | -101801 | -102186
9 | -101660 | -102186
10 | -102426 | -102249
11 | -84075 | -83302
12 | -93592 | -91846
13 | -134859 | -133317
14 | -107262 | -102870
15 | -87749 | -87755
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-08-31 00:00:00 |  | 47553
 | 2001-09-15 00:00:00
CBS Dollars
 |  |  | -252720.37
Spreadsheet: 215923d1361542463-converting-data-from-a-grid-into-a-list-copy-of-grid-to-list-data-conversion1
Sheet: Planning Sheet

week 1
 | 2012-01-02 00:00:00
A | RESTUARANT |  | CAFE |  | TAKEAWAY
B |  | SERVICE STATION |  | BOOKIES
C | OFFICE 1 |  | OFFICE 2 |  | FORECOURT
D |  | FORECOURT |  | TAKEAWAY
week 2
A |  | OFFICE 3 |  | BOOKIES
B | TAKEAWAY |  | FORECOURT |  | RESTUARANT
C |  | GYM |  | SHOP
D | OFFICE 4 |  | WAREHOUSE |  | LEISURE CENTRE
Would like it to show:
Engineer | Date | site
A | 2012-01-02 00:00:00 | RESTUARANT
A | 2012-01-04 00:00:00 | CAFE
A | 2012-01-06 00:00:00 | TAKEAWAY
A | 2012-01-10 00:00:00 | OFFICE 3
A | 2012-01-06 00:00:00 | BOOKIES
B | 2012-01-03 00:00:00 | SERVICE STATION
B | 2012-01-05 00:00:00 | BOOKIES
B | 2012-01-07 00:00:00 | TAKEAWAY
B | 2012-01-11 00:00:00 | FORECOURT
B | 2012-01-13 00:00:00 | RESTUARANT
C | 2012-01-02 00:00:00 | OFFICE 1
C | 2012-01-04 00:00:00 | OFFICE 2
C | 2012-01-06 00:00:00 | FORECOURT
C | 2012-01-10 00:00:00 | GYM
C | 2012-01-06 00:00:00 | SHOP
D | 2012-01-03 00:00:00 | FORECOURT
D | 2012-01-05 00:00:00 | TAKEAWAY
D | 2012-01-07 00:00:00 | OFFICE 4
D | 2012-01-11 00:00:00 | WAREHOUSE
D | 2012-01-13 00:00:00 | LEISURE CENTRE
Spreadsheet: 118393d1313658717-track-unique-changes-in-two-tables-ranges-spreadsheet-changes
Sheet: Sheet1

 | Existing |  |  |  |  | New
 | Cover levels |  |  |  |  | Cover levels
Company | C.C. | Excess |  |  | Company | C.C. | Excess
1 | Optional | 50 |  |  | 1 | Optional | 50
2 | Standard | 100 |  |  | 2 | Standard | 100
3 | Standard | 150 |  |  | 3 | Standard | 150
4 | Optional | 100 |  |  | 4 | Standard | 150
Spreadsheet: 808716d1670597890-counting-rows-between-specific-events-book1
Sheet: Sheet1

WHEEL 1 | WHEEL 2 | WHEEL 3 |  |  |  |  | DELAY | TIMES
R | R | G |  |  |  |  | 0
G | B | R |  |  |  |  | 1
B | B | B |  |  |  |  | 2
B | R | R |  |  |  |  | 3
R | B | G |  |  |  |  | 4
B | G | B |  |  |  |  | 5
B | S | R |  |  |  |  | 6
S | B | B |  |  |  |  | 7
S | S | S |  |  |  |  | 8
R | G | R |  |  |  |  | 9
R | G | G |  |  |  |  | 10
R | G | R |  |  |  |  | 11
G | R | R |  |  |  |  | 12
B | S | S |  |  |  |  | 13
B | G | R |  |  |  |  | 14
G | B | B |  |  |  |  | 15
B | R | G |  |  |  |  | 16
S | S | S |  |  |  |  | 17
R | R | B |  |  |  |  | 18
B | B | B |  |  |  |  | 19
R | R | B |  |  |  |  | 20
G | G | G |  |  |  |  | 21
B | G | G |  |  |  |  | 22
R | R | R |  |  |  |  | 23
B | G | R |  |  |  |  | 24
G | R | R |  |  |  |  | 25
S | R | R |  |  |  |  | 26
B | B | R |  |  |  |  | 27
R | G | G |  |  |  |  | 28
R | G | R |  |  |  |  | 29
G | R | G |  |  |  |  | 30
B | R | R
G | B | R
Spreadsheet: 05a2c932-597c-49ba-a9c3-19591b172b1e
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: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34
Center for Student Support and Education Options
Office of Quality School Choice and Funding
SF-6
JVS Attachment Form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY-20
A.
 |  | Joint Vocational School |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
B.
 |  | Resident District - City, Exempted Village, Local or Community School |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
 | SSID |  |  |  |  |  |  |  |  |  |  |  |  |  | Disability |  |  |  |  | EMIS |  |  | Dates of |  |  |  |  |  | Total |  |  | FTE |  | *Billing
 | Number |  |  |  |  |  |  |  |  |  |  |  |  |  | Condition |  |  |  |  | Status |  |  | Enrollment |  |  |  |  |  | Days |  |  | at |  | FTE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From Section |  |  |  |  | Code |  |  | From |  |  | To |  |  | Enrolled |  |  | JVS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 C
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 | *Billing FTE = Total days enrolled x FTE at JVS ÷ 180 days.
EMIS Student Status Codes
10  - |  | Resident |  |  |  |  |  |  |  |  |  |  | 1C  - |  | Court placed (foster) |  |  |  |  |  |  |  |  |  |  | 1S  - |  | Non-resident (superintendent)
17  - |  | Non-resident (grandparent) |  |  |  |  |  |  |  |  |  |  | 1P  - |  | Court placed (institutional) |  |  |  |  |  |  |  |  |  |  | 19  - |  | Open enrolled (jointure)
18  - |  | Non-resident (senior) |  |  |  |  |  |  |  |  |  |  | 1T  - |  | Parental (institutional placed) |  |  |  |  |  |  |  |  |  |  | 49  - |  | Open enrolled (non-jointure
1A  - |  | Non-resident (employee) |  |  |  |  |  |  |  |  |  |  | 1D  - |  | Direct pay tuition
Spreadsheet: 778710d1651237358-building-a-dynamic-formula-to-simplify-relations-substitute-len-excel-simplify-relations_substitute_len_countif_search
Sheet: Sheet1

 |  | Can someone guide me in the right direction… to go from yellow to green, with a dynamic (in-between) formula in blue
 |  |  |  | Helper Cells |  | (LEN($B6)-LEN(SUBSTITUTE($B6;E$5;"")))/LEN(E$5)
 | Relations between people | [NAME] |  | Anna | [NAME] | Casper | Dirk | Eva | [NAME] | Gerard | Hilde | Isabel |  | Group of relations
 | Anna-Dirk, [NAME], Casper-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Casper-Fiona
 | [NAME], Isabel-Boris, Eva-Isabel, [NAME], Dirk-Boris, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Boris-Dirk, Fiona-Eva, [NAME], Dirk-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Boris-Dirk-Hilde, [NAME]
 | Isabel-Anna, Eva-Boris, Hilde-Casper, Isabel-Gerard, Fiona-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Isabel-Anna-Gerard, Eva-Boris, Hilde-Casper, Fiona-Dirk
 | Dirk-Casper, Fiona-Eva, [NAME], Dirk-Hilde, [NAME], Fiona-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Casper-Hilde-Fiona-Isabel-Gerard-Eva
 | [NAME], Isabel-Anna, Eva-Hilde, Dirk-Casper |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Eva-Hilde, Dirk-Casper
 | Eva-Isabel, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Eva-Isabel-Dirk
 | …
 | [NAME], [NAME], Casper-Eva, Isabel-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 | Sample DATA in [B6:B14] |  |  | List of 9 People: |  |  |  |  |  |  |  |  |  | I Hardcoded the preferred FORMAT in [O6:O14]
 |  | I've been stuck on this (seemingly simple) dynamic formula-problem, for over 2 years now (since 2019)…
Spreadsheet: 1a45049e-e8da-429d-b06b-a5b6b95f0498
Sheet: Sheet1

Autosomes | [NAME] | nsites_GH2 | PI_GH2 | TH_GH2 | [NAME] | [NAME] | [NAME] | TH_BRE | D_BRE
Chr_1 | 2619 | 29.6 (3 - 219) | 1.8e-04 (2.0e-05 - 1.7e-03) | 2.7e-04 (4.5e-05 - 1.6e-03) | -1.259 (-2.441 - 0.592) | 20.5 (2 - 226) | 1.7e-04 (1.5e-05 - 2.1e-03) | 2.1e-04 (2.4e-05 - 2.1e-03) | -0.998 (-2.449 - 0.843)
Chr_2 | 1378 | 42.5 (4 - 464) | 2.7e-04 (2.8e-05 - 5.1e-03) | 3.6e-04 (5.4e-05 - 5.0e-03) | -1.283 (-2.464 - 0.534) | 27.7 (3 - 288) | 2.2e-04 (1.1e-05 - 3.4e-03) | 2.6e-04 (2.4e-05 - 3.5e-03) | -0.975 (-2.106 - 0.802)
Chr_3 | 1118 | 33.3 (5 - 356) | 2.0e-04 (1.2e-05 - 3.0e-03) | 2.9e-04 (3.5e-05 - 2.6e-03) | -1.307 (-2.395 - 0.627) | 22.7 (2 - 287) | 1.8e-04 (1.2e-05 - 3.1e-03) | 2.3e-04 (3.5e-05 - 2.8e-03) | -1.026 (-2.469 - 0.709)
Chr_4 | 1284 | 30 (5 - 259) | 1.8e-04 (3.4e-05 - 2.9e-03) | 2.7e-04 (6.8e-05 - 2.9e-03) | -1.302 (-2.368 - 0.617) | 21.7 (2 - 227) | 1.8e-04 (1.0e-05 - 2.9e-03) | 2.2e-04 (1.7e-05 - 2.8e-03) | -1.002 (-2.24 - 0.573)
Chr_5 | 375 | 39 (3 - 304) | 2.4e-04 (4.2e-05 - 2.4e-03) | 3.4e-04 (8.8e-05 - 2.3e-03) | -1.299 (-2.261 - 0.068) | 25.6 (1 - 214) | 2.1e-04 (2.5e-05 - 1.6e-03) | 2.6e-04 (4.1e-05 - 1.5e-03) | -0.957 (-2.295 - 0.445)
Chr_6 | 801 | 34.4 (3 - 164) | 1.9e-04 (2.7e-05 - 1.7e-03) | 3.0e-04 (5.9e-05 - 1.5e-03) | -1.37 (-2.448 - 0.352) | 22.8 (4 - 381) | 1.8e-04 (2.5e-05 - 3.0e-03) | 2.3e-04 (4.6e-05 - 3.2e-03) | -1.009 (-2.208 - 0.257)
Chr_7 | 389 | 32.1 (10 - 121) | 1.7e-04 (3.0e-05 - 1.0e-03) | 2.7e-04 (8.2e-05 - 1.1e-03) | -1.426 (-2.316 - -0.226) | 20.5 (4 - 123) | 1.6e-04 (1.4e-05 - 1.4e-03) | 2.1e-04 (3.2e-05 - 1.3e-03) | -1.075 (-2.297 - 0.105)
Total | 7964 | 33.5 (3 - 464) | 2.0e-04 (1.2e-05 - 5.1e-03) | 2.9e-04 (3.5e-05 - 5.0e-03) | -1.298 (-2.464 - 0.627) | 22.7 (1 - 381) | 1.8e-04 (1.0e-05 - 3.4e-03) | 2.3e-04 (1.7e-05 - 3.5e-03) | -1.002 (-2.469 - 0.843)
Column legends
[NAME] | number of 50kb windows
nsites_GH2 | average (min - max) number of polymorphic sites per windows (according to the criteria of covergae, base quality... Chosen: cf mat&meth) in the GH2 strains
PI_GH2 | Average (min - max) Tajima's Pi estimator of nucleotide diversity per window in the GH2 strains
TH_GH2 | Average (min - max) [NAME] estimator of nucleotide diversity per window in the GH2 strains
[NAME] | Average (min - max) Tajima D per window in the GH2 strains
[NAME] | average (min - max) number of polymorphic sites per windows (according to the criteria of covergae, base quality... Chosen: cf mat&meth) in the BRE strains
[NAME] | Average (min - max) Tajima's Pi estimator of nucleotide diversity per window in the BRE strains
TH_BRE | Average (min - max) [NAME] estimator of nucleotide diversity per window in the BRE strains
D_BRE | Average (min - max) Tajima D per window in the BRE strains
Spreadsheet: 33733d1230423598-consolidate-multiple-rows-of-data-into-1-row-for-each-record-consolidation_example
Sheet: Input

field1 | record1-field1number
field2 | record1-field2text
[NAME] | record1-field3text
[NAME] | record1-field4text | record1-field4text | record1-field4text
 | record1-field4text | record1-field4text
field1 | record2-field1number
field2 | record2-field2text
[NAME] | record2-field3text
[NAME] | record2-field4text | record2-field4text | record1-field4text
 | record2-field4text | record2-field4text
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9912

December 1999 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers | Data Source
HPLC | 12 |  | 14583.51 |  |  |  | Black Marlin | 96022051 | Unify Expense Report - Settlements
HPLC | 12 |  |  |  |  |  | Houston Pipeline Company | 96021987/ 96021988 | CPR (Basis Adj) Report | Accrual Expense |  | 834449 | not included in this flash
 |  |  |  |  |  |  |  |  | + estimated intrazone expense
HPLC | 12 |  | 4208.12 |  |  |  | Humble Gas Pipeline |  | CPR (Basis Adj) Report
HPLC | 12 |  | 0 |  |  |  | MidCon Texas Pipeline Corp. | 96006770 | Unify Expense Report - Settlements
HPLC | 12 |  | 495.63 |  |  |  | Southland Energy Corporation | 96008703 | CPR (Basis Adj) Report
ECT/Texas | 16 |  | 1140 |  |  |  | Northern Natural Gas/Black Marlin | 96020553 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 74701 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 960.92 |  |  |  | Pan Grande Pipeline, LLC | 96019628 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 77034.72 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96009903/ 96011842 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 0 |  | 98300 |  | Centana Storage Demand Charge | 96019236 | Unify Expense Report - Settlements
ECT/Texas | 16 |  |  |  |  |  | Houston Pipeline Company | 96007846/ 96007849 | CPR (Basis Adj) Report |  |  | 165443 | Flashed but needs to be part of manual entry
 |  |  |  |  |  |  |  |  | + estimated intrazone expense
Totals
DEMAND CHARGE NOTES:
 |  |  |  | $93,300 demand charge is in line 36 of OA Flash Page
ISSUES: | CPR estimate does not tie with Unify actuals as of 8/2/99
NOTE: | Because Unify does not tie with CPR, and because Unify does not seem to have flashed all pipelines, we used CPR tickets to flash
 | Boxed items show total expense that should show up on HPLC Transport Revenue - HPLR/ECT line