tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47188d1246098846-move-row-on-cell-change-lookup-from-y_n
Sheet: Sheet1

1 | question 1 | no | reply 1 | stuff 1 | bits 1
2 | question 2 | no | reply 2 | stuff 2 | bits 2
3 | question 3 | no | reply 3 | stuff 3 | bits 3
 | question 4 |  | reply 4 | stuff 4 | bits 4
4 | question 5 | no | reply 5 | stuff 5 | bits 5
 | question 6 |  | reply 6 | stuff 6 | bits 6
 | question 7 |  | reply 7 | stuff 7 | bits 7
5 | question 8 | no | reply 8 | stuff 8 | bits 8
 | question 9 |  | reply 9 | stuff 9 | bits 9
6 | question 10 | no | reply 10 | stuff 10 | bits 10
 | question 11 |  | reply 11 | stuff 11 | bits 11
7 | question 12 | no | reply 12 | stuff 12 | bits 12
 | question 13 |  | reply 13 | stuff 13 | bits 13
 | question 14 |  | reply 14 | stuff 14 | bits 14
 | question 15 |  | reply 15 | stuff 15 | bits 15
Spreadsheet: 889342d1740132996-gather-data-from-sap-samplesheet-data-from-sap
Sheet: Tabelle1

 | Volume | 100 ml
 | Product name | 001564
 | 0.1) | Open SAP GUI and log in
 | 1) | Transaction Code |  | CS03
 | 2) | [NAME] |  | 001564-100ml
 |  | Location |  | AB01
 |  | Usecase |  | 1
 | 3) | Search for number
 | 4) | Export this as excel:
 | 5) | Import the exported excel in this file in a separate sheet
 | 5.1) | Search for another productnumber - no need to log in again. Keep beeing logged in until the the file is closed and reopened
Spreadsheet: 678814d1590072622-concatenate-multiple-rows-into-one-cell-across-multiple-columns-seedcalendar_help
Sheet: OriginalData

Taxon | Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] paniculata |  |  |  |  |  | Fl | Fl | Fl
[NAME] paniculata |  |  |  |  |  | M | M | M
Asclepias meadii |  |  |  |  | Fl | Fl
Asclepias meadii |  |  |  |  |  | Im | Im | Im | Im | Im
Asclepias meadii |  |  |  |  |  |  |  | M | M | M
Boltonia decurrens |  |  |  |  |  |  |  | Fl | Fl
Boltonia decurrens |  |  |  |  |  |  |  | M | M | M
Callirhoe bushii |  |  |  |  | Fl | Fl | Fl | Fl
Crataegus latebrosa
Crataegus latebrosa
Delphinium newtonianum |  |  |  |  |  | Fl
Delphinium treleasei |  |  |  |  | Fl | Fl
Dirca decipiens |  |  | Fl | Fl | Fl
Dirca decipiens |  |  |  | Im | Im | Im
Dirca decipiens |  |  |  |  | M | M
Echinacea paradoxa |  |  |  |  | Fl | Fl
Echinacea paradoxa |  |  |  |  |  |  |  | M | M
Spreadsheet: 764416d1642719026-amortize-bonus-accrual-by-start-date-2021-bonus-accrual-spread-test
Sheet: Employee Census (7)

Employee number | Employee | Full name | Department | Title | Level | Pro-Rate Start Date | Bonus | 2021-01-31 00:00:00
313 | [NAME] | [NAME] | Finance | Assistant | IC | 2021-07-26 00:00:00 | 15000
212 | [NAME] | [NAME] | Marketing | Coordinator | IC | 2021-01-01 00:00:00 | 20000
Spreadsheet: 821092d1678441984-vba-code-compiles-data-in-new-sheet-except-if-there-is-only-one-line-of-data-road-speed-limit-violations-new-_2023-03-10_0728
Sheet: CS3 CA367148

 |  |  |  | Road Speed Limit Violations
 |  |  |  | Time frame: Manual | Resource type: 90 Resources In 3 groups | Duration: All
 |  |  |  | Created: 10/03/2023 07:28:13 | Account: Hylton Ross Tours (Pty) Ltd
 | CS3 CA367148 Report Totals for 03/03/2023 06:30:00 - 10/03/2023 06:15:00 (UTC+02:00) Harare, Pretoria
 | No. of Events |  |  |  |  |  |  | [NAME] |  |  |  |  | Total Duration
 | 14 |  |  |  |  |  |  | 92km/h |  |  |  |  | 00h09m12s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-04 06:55:45 |  |  |  | [NAME] |  | 61 |  | 60 | 00:00:00 | 6 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 08:45:31.180000 |  |  |  | [NAME] |  | 75 |  | 60 | 00:00:08 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-04 08:46:03.150000 |  |  |  | [NAME] |  | 90 |  | 80 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-04 08:50:51.270000 |  |  |  | [NAME] |  | 90 |  | 60 | 00:00:00 | N1, [NAME], Goodwood, Western Cape
 | 2023-03-04 08:52:27.050000 |  |  |  | [NAME] |  | 90 |  | 60 | 00:00:00 | N1, Plattekloof, Parow, Western Cape
 | 2023-03-04 09:20:43.860000 |  |  |  | [NAME] |  | 62 |  | 60 | 00:00:00 | R45, 8.37 km SE of Klapmuts, Western Cape
 | 2023-03-04 09:22:19.020000 |  |  |  | [NAME] |  | 82 |  | 80 | 00:00:00 | R45, 7.89 km NE of Kylemore, Western Cape
 | 2023-03-04 09:29:47.070000 |  |  |  | [NAME] |  | 86 |  | 80 | 00:02:40 | Huguenot Road (R45), Wemmershoek Forest Reserve, Franschhoek, Western Cape
 | 2023-03-04 09:30:51.340000 |  |  |  | [NAME] |  | 84 |  | 80 | 00:02:08 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 09:34:03.520000 |  |  |  | [NAME] |  | 81 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 13:45:20.900000 |  |  |  | [NAME] |  | 84 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 13:52:16.190000 |  |  |  | [NAME] |  | 92 |  | 80 | 00:03:44 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-04 14:37:36.850000 |  |  |  | [NAME] |  | 67 |  | 60 | 00:00:00 | 116 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-08 13:30:04.440000 |  |  |  | [NAME] |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
Spreadsheet: c7d19528-da4d-4d02-a71a-f1ecce0595db
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6304-0 | [NAME] droppings Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 810897d1672154255-excell-cell-data-to-the-column-s666-f-data2columns-1-
Sheet: Sheet1

source
[NAME], Y1=3912463.269
A2 X2=520134.004, Y2=3912459.874
A3 X3=520131.852, Y3=3912457.465
A4 X4=520129.977, Y4=3912453.299
[NAME], Y5=3912449.398
[NAME], Y6=3912446.461
[NAME], Y7=3912442.777
A8 X8=520121.014, Y8=3912437.906
A9 X9=520117.419, Y9=3912433.734
Spreadsheet: 870061d1716566383-labour-hour-calculation-new-crop-logs-template
Sheet: Crop Logs

Legend |  |  |  |  |  | Today's Date |  | Room |  | Cycle |  | Plug Date | 2024-06-01 00:00:00 | # of Tables | 32
Target Event |  | Hours | Instructions |  |  | Cultivar | Sourdough |  | BPR |  |  | Harvest Date
A | Pinch |  | 1 | Pinch to 3 branches. |  | Day of Cycle | Date | Target | Actual | Event | Instructions | Instructions | Instructions | Notes |  | # of | # of | Target | Actual
B | 1st Touch | 1.375 | 2 | Pinch to 4 branches. |  | 0 |  | Event | Event | Code |  |  |  |  |  | People | Tables | Hours | Hours
C | 2nd Touch | 1.688 | 3 | Pinch to 5 branches. |  | 1
D | 3rd Touch | 1.855 | 4 | Pinch to 6 branches. |  | 2
E | 4th Touch | 1.855 | 5 | Pinch to 7 branches. |  | 3
F | 5th Touch | 1.855 | 6 | Pinch to 8 branches. |  | 4
G | 6th Touch | 1.855 | 7 | Pinch to 9 branches. |  | 5
 |  |  | 8 | Pinch to 10 branches. |  | 6
 |  |  | 9 | Pruning |  | 7
 |  |  | 10 | Defoliation |  | 8
 |  |  | 11 | [NAME] |  | 9
 |  |  | 12 | [NAME] |  | 10
 |  |  | 13 | [NAME] |  | 11 |  |  |  | B |  |  |  |  |  | 8 |  | 44
 |  |  | 14 | Main Cola Defol (Haircut) |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 | Total |  |  |  |  | 15
 | People |  |  |  |  | 16
 | (Actual) |  |  |  |  | 17
 | Total Target |  |  |  |  | 18
 | Hours |  |  |  |  | 19
 | (Projected) |  |  |  |  | 20
 | Total Actual |  |  |  |  | 21
 | Hours |  |  |  |  | 22
 | (Currently) |  |  |  |  | 23
 | Total Nets |  |  |  |  | 24
 | Used |  |  |  |  | 25
 | (Currently) |  |  |  |  | 26
 | Total Bags |  |  |  |  | 27
 | of [NAME] Used |  |  |  |  | 28
 | (Currently) |  |  |  |  | 29
 | Total Table |  |  |  |  | 30
 | Covers Used |  |  |  |  | 31
 | (Currently) |  |  |  |  | 32
 |  |  |  |  |  | 33
 |  |  |  |  |  | 34
 |  |  |  |  |  | 35
 |  |  |  |  |  | 36
 |  |  |  |  |  | 37
 |  |  |  |  |  | 38
 |  |  |  |  |  | 39
 |  |  |  |  |  | 40
 |  |  |  |  |  | 41
 |  |  |  |  |  | 42
 |  |  |  |  |  | 43
 |  |  |  |  |  | 44
 |  |  |  |  |  | 45
 |  |  |  |  |  | 46
 |  |  |  |  |  | 47
 |  |  |  |  |  | 48
 |  |  |  |  |  | 49
 |  |  |  |  |  | 50
 |  |  |  |  |  | 51
 |  |  |  |  |  | 52
 |  |  |  |  |  | 53
 |  |  |  |  |  | 54
 |  |  |  |  |  | 55
 |  |  |  |  |  | 56
 |  |  |  |  |  | 57
 |  |  |  |  |  | 58
 |  |  |  |  |  | 59
 |  |  |  |  |  | 60
 |  |  |  |  |  | 61
 |  |  |  |  |  | 62
 |  |  |  |  |  | 63
 |  |  |  |  |  | 64
 |  |  |  |  |  | 65
 |  |  |  |  |  | 66
 |  |  |  |  |  | 67
 |  |  |  |  |  | 68
 |  |  |  |  |  | 69
 |  |  |  |  |  | 70
 |  |  |  |  |  | 71
 |  |  |  |  |  | 72
 |  |  |  |  |  | 73
 |  |  |  |  |  | 74
 |  |  |  |  |  | 75
 |  |  |  |  |  | 76
 |  |  |  |  |  | 77
 |  |  |  |  |  | 78
 |  |  |  |  |  | 79
 |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total People/Hours
Spreadsheet: 788868d1658770186-extracting-city-name-from-street-address-value-extract-city-name-ans
Sheet: Sheet1

123 N Summerset RD Springfield, OH 44157 | Springfield |  | Copy "Springfield"--->Paste B2--->Ctrl+E
124 N Summerset RD Waterlooville, OH 44157 | Waterlooville
125 N Summerset RD Edmonton, OH 44157 | Edmonton
126 N Summerset RD Mysore, OH 44157 | Mysore
127 N Summerset RD Toronto, OH 44157 | Toronto
128 N Summerset RD Virginia, OH 44157 | Virginia
129 N Summerset RD Surabaya, OH 44157 | Surabaya
130 N Summerset RD Waterlooville, OH 44157 | Waterlooville
131 N Summerset RD Springfield, OH 44157 | Springfield
132 N Summerset RD Springfield, OH 44157 | Springfield
133 N Summerset RD Springfield, OH 44157 | Springfield
134 N Summerset RD Springfield, OH 44157 | Springfield
135 N Summerset RD Springfield, OH 44157 | Springfield
136 N Summerset RD Springfield, OH 44157 | Springfield
Spreadsheet: 212659d1360184310-conditional-formatting-for-dates-shooting
Sheet: WHT List

Cadet Names | .22 WHT? | Re-Test Date | L98 WHT? | Re-Test Date | L81 WHT? | Re-Test Date
 | 2012-10-25 00:00:00
 | 2011-09-22 00:00:00 |  | 2012-06-24 00:00:00
 | 2012-03-01 00:00:00 |  | 2012-06-24 00:00:00
 | 2012-10-16 00:00:00 |  | 2012-10-30 00:00:00 |  | 2012-09-29 00:00:00
 | 2012-10-28 00:00:00
 | 2012-03-18 00:00:00 |  | 2012-09-30 00:00:00
Spreadsheet: 111084d1307563886-summing-certain-values-based-on-what-is-in-another-column-779158-summing-certain-values-example
Sheet: Sheet1

 | Sheet 2 with SUMPRODUCT |  |  |  |  |  | Sheet 3 with SUMPRODUCT
 | belt | gloves | shoes | tie |  |  | belt | gloves | shoes | tie
[NAME] | 0 | 0 | 0 | 0 |  | [NAME] | 0 | 0 | 0 | 0
Dumbo | 2 | 2 | 2 | 2 |  | Dumbo | 1 | 1 | 1 | 1
Goofy | 1 | 1 | 1 | 1 |  | Goofy | 3 | 3 | 3 | 3
[NAME] | 0 | 0 | 0 | 0 |  | [NAME] | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 |  | [NAME] | 0 | 0 | 0 | 0
Minnie | 0 | 0 | 0 | 0 |  | Minnie | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 |  | [NAME] | 1 | 1 | 1 | 1
[NAME] | 0 | 0 | 0 | 0 |  | [NAME] | 0 | 0 | 0 | 0
Zippy | 0 | 0 | 0 | 0 |  | Zippy | 0 | 0 | 0 | 0
Spreadsheet: 207052d1358354098-excel-2003-how-to-move-columns-and-still-keep-formula-calculations-the-same-excel-example
Sheet: WHAT IT LOOKS LIKE

Data Month | ID | Name | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Data | %Change | [NAME] | Rating | Monthly Score
2012-02 | 1 | [NAME] | 477 |  |  |  | 437 |  |  |  | 40 |  |  |  | 45 |  |  |  | 6 |  |  |  |  |  |  |  | 0.0545 |  |  |  | 0.92 |  |  |  | 1
2012-03 | 1 | [NAME] | 378 | -0.2075471698113208 | -0.2075471698113208 | 1 | 347 | -0.2059496567505721 | -0.2059496567505721 | 1 | 31 | -0.225 | -0.225 | 1 | 860 | 18.11111111111111 |  |  | 8 | 0.3333333333333333 | 0.3333333333333333 | -1 | 6.771653543307087 | #N/A | #N/A | #N/A | 0.0455 | -0.1651376146788991 | -0.1651376146788991 | 1 | 0.92 | 0 | 0 | 0 | 0.7981 | -0.2019 | -0.2019 | 1 | 4
2012-04 | 1 | [NAME] | 453 | 0.1984126984126984 | 0.1984126984126984 | -1 | 407 | 0.1729106628242075 | 0.1729106628242075 | -1 | 46 | 0.4838709677419355 | 0.4838709677419355 | -1 | 756 | -0.1209302325581395 | -0.1209302325581395 | 1 | 7 | -0.125 | -0.125 | 1 | 5.6 | -0.1730232558139536 | -0.1730232558139536 | 1 | 0.0399 | -0.1230769230769231 | -0.1230769230769231 | 1 | 0.93 | 0.01086956521739131 | 0.01086956521739131 | 0 | 0.7718 | -0.03295326400200475 | -0.03295326400200475 | 0 | 1
2012-05 | 1 | [NAME] | 404 | -0.108167770419426 | -0.108167770419426 | 0 | 369 | -0.09336609336609336 | -0.09336609336609336 | 0 | 36 | -0.2173913043478261 | -0.2173913043478261 | 1 | 940 | 0.2433862433862434 | 0.2433862433862434 | -1 | 8 | 0.1428571428571428 | 0.1428571428571428 | -1 | 6.811594202898551 | 0.2163561076604556 | 0.2163561076604556 | -1 | 0.0602 | 0.5087719298245614 | 0.5087719298245614 | -1 | 0.91 | -0.02150537634408604 | -0.02150537634408604 | 0 | 0.676 | -0.1241254210935475 | -0.1241254210935475 | 1 | -2
2012-06 | 1 | [NAME] | 400 | -0.009900990099009901 | -0.009900990099009901 | 0 | 367 | -0.005420054200542005 | -0.005420054200542005 | 0 | 33 | -0.08333333333333333 | -0.08333333333333333 | 0 | 1267 | 0.3478723404255319 | 0.3478723404255319 | -1 | 8 | 0 | 0 | 0 | 7.15819209039548 | 0.05088351965380452 | 0.05088351965380452 | 0 | 0.0358 | -0.4053156146179402 | -0.4053156146179402 | 1 | 0.94 | 0.03296703296703287 | 0.03296703296703287 | 0 | 0.788 | 0.165680473372781 | 0.165680473372781 | -1 | -1
Spreadsheet: 839064d1691624383-modify-formulas-to-calculate-overtime-when-40hrs-are-not-worked-time-card-sample2
Sheet: Sheet1

 | Day | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT | E/A
 | Sun |  |  | 08:00:00 | 20:00:00
 | Mon |  |  | 08:00:00 | 18:00:00
 | Tue |  |  | 08:00:00 | 12:00:00 |  |  |  |  | y
 | Wed | y |  | holidays
 | Thu |  |  | 08:00:00 | 16:00:00
 | Fri |  |  | 08:00:00 | 16:00:00
 | Sat |  |  | 08:00:00 | 16:00:00
 | Total
Spreadsheet: 3293c68e-f304-4c32-8686-babdd9a8d6c6
Sheet: TVMobiLi

 | TVMobiLi
 | OS | Status | Detect | Plays
 | Windows XP
 | Windows 7/8 | T | D | P
 | Linux
 | OS X | T | D | P
 | T= Test  NT=Not Tested
 | D=Detectable ND=Not Detectable (have not been able to get this working yet)
 | P=Plays Movies (refer to list below)  NP=Will not play any media
 | Container | Audio Codec | Video Codec | Plays | [NAME]? | Exceptions
 | .avi | [NAME] | ac3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | msmpeg4v2 | mp3 | Y | Y
 | .avi | divx5 | mp3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | [NAME] | divx audio v2 | Y | Y
 | .avi | divx4 | mp3 | Y | Y
 | .flv | h264 | aac | N | N
 | .m4v | h264 | aac | N | Y
 | .mkv | h264 | ogg | Y | Y
 | .mkv | h264 | aac | Y | Y
 | .mp4 | h264 | aac | Y | Y | W78
 | .mpg | mpeg1 | mp2 | Y | Y
 | .mpg | mpeg2 | mp2 | Y | Y
 | Y=Plays in full  N1=Plays but doesn't recognize audio codec N2=Plays but doesn't recognize video codec NP=does not play
 | Exceptions refers to the ability to get that type of file to be played via a particular OS
 | WXP=not working in Windows XP  W78=not working in Windows 7/8  [NAME]=not working in Linux MAC=not working in MAC
 | Notes
 | When transcoding, select "Let TVMOBiLi work out best format for my device"
 | When testing .mp4 h264 aac, I had one file that worked fine and the other that told me the audio/video codecs were not supported.  Could not identify differences in files.
 | under Status in the TVMobili page, you can find the IP of your TV and change the device type to [NAME]) and it will better transcode the mkv files.  However, there may be a bit of delay.  The EU may have to wait for the transcoding process as it forms a bit of a buffer.
 | depending on if you have LG-Client or [NAME] client selected can make a difference in what file types will properly play.
 | TVMobili does play DTS audio with the proper settings.
Spreadsheet: 83121d1283180901-lookup-and-if-dispatchers_sheet
Sheet: Driver Shifts

ID | Driver | Start Date & Time | Finish Date & Time | Finish Date & Time2 | [NAME] | test | big test
22 | [NAME] | 2010-08-30 12:40:44
20 | [NAME] | 2010-08-29 16:45:00 |  | 2010-08-30 01:30:00
21 | [NAME] | 2010-08-29 16:45:00 |  | 2010-08-30 01:30:00
18 | [NAME] | 2010-08-29 13:00:00 |  | 2010-08-29 16:45:00
19 | Big John | 2010-08-29 13:00:00 |  | 2010-08-29 16:45:00
17 | [NAME] | 2010-08-28 17:58:38 |  | 2010-08-29 02:00:00
16 | [NAME] | 2010-08-28 17:48:22 |  | 2010-08-29 02:00:00
15 | [NAME] | 2010-08-28 16:48:55 |  | 2010-08-29 02:00:00
13 | Big John | 2010-08-28 13:00:00 |  | 2010-08-28 17:47:57
14 | [NAME] | 2010-08-28 13:00:00 |  | 2010-08-28 16:48:49
10 | [NAME] | 2010-08-27 18:00:00 |  | 2010-08-28 02:00:00
11 | Sean | 2010-08-27 18:00:00 |  | 2010-08-28 00:18:21
9 | [NAME] | 2010-08-27 16:40:00 |  | 2010-08-28 02:00:00
1 | Big John | 2010-08-26 16:45:00 |  | 2010-08-26 23:30:00
Spreadsheet: 46761d1245703419-sumproduct-using-2-different-date-ranges-annual-student-report-report-template-06-22-09-fs
Sheet: Intervention Summary

Intervention Summary Report
Date | Level | Log Entry Text |  |  |  | Follow-up Text | Notes
Subtype | Sub-subtype
Action Status | Reporter |  |  |  |  |  |  |  |  |  |  | sub subtype lookup |  | status lookup |  | Level Lookup
 |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | None | 0 |  | 0 | N/A
 |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | Detention: Assignment Log | 1 | Please Select | 2 | 0
 |  |  |  |  |  |  |  |  |  | 4 | 2 | 2 | Detention: Behavioral | 2 | Pending | 3 | 1
 |  |  |  |  |  |  |  | 0 | n/a | 6 | 4 | 3 | Detention: Organization | 3 | Active | 4 | 2
 |  |  |  |  |  |  |  | 1 | n/a | 7 | 5 | 5 | Make-Up: Consequence |  |  | 6 | 4
 |  |  |  |  |  |  |  | 2 | Pending |  |  | 6 | Make-Up: Supplemental |  |  | 7 | 5
 |  |  |  |  |  |  |  | 3 | Active |  |  | 7 | Academics
 |  |  |  |  |  |  |  | 4 | Complete |  |  | 8 | Attendance
 |  |  |  |  |  |  |  |  |  |  |  | 9 | Behavior
 |  |  |  |  |  |  |  | outreach sch |  |  |  | 10 | Family
 |  |  |  |  |  |  |  | 0 | n/a |  |  | 11 | Student Snapshot: Academic Strength
 |  |  |  |  |  |  |  | 1 | n/a |  |  | 12 | Student Snapshot: Academic Need
 |  |  |  |  |  |  |  | 2 | Completed |  |  | 13 | Student Snapshot: Performance Strength
 |  |  |  |  |  |  |  | 3 | Rescheduled |  |  | 14 | Student Snapshot: Performance Need
 |  |  |  |  |  |  |  | 4 | Cancelled |  |  | 15 | Student Snapshot: Tutoring Strategies
 |  |  |  |  |  |  |  |  |  |  |  | 16 | Student Snapshot: Other
 |  |  |  |  |  |  |  | Review Status |  |  |  | 17 | Scholarship: Reduce
 |  |  |  |  |  |  |  | 0 | n/a |  |  | 18 | Scholarship: Termination
 |  |  |  |  |  |  |  | 1 | Pending |  |  | 19 | Scholarship: Reinstatement
 |  |  |  |  |  |  |  | 2 | Successfully Completed |  |  | 20 | [NAME]
 |  |  |  |  |  |  |  | 3 | Didn't [NAME] |  |  | 21 | Dismissal Voluntary: [NAME]
 |  |  |  |  |  |  |  | 4 | Progress made, but incomplete |  |  | 22 | Dismissal Voluntary: Not [NAME]
 |  |  |  |  |  |  |  | 5 | Agreements Revised
Spreadsheet: 154914d1336596644-getting-values-from-different-columns-in-one-formula-excel-prob
Sheet: Ark1

Ex. 1
 | A |  |  | B |  |  | C
 | y | x |  | y | x |  | y | x
 | 0 | 0.3 |  | 1 | 0.8 |  | 0 | 0.3
 | 0 | 0.5 |  | 1 | 0.3 |  | 0 | 0.3
 | 0 | 0.4 |  | 0 | 0.4 |  | 0 | 0.2
 | 1 | 0.35 |  | 1 | 0.55 |  | 1 | 0.4
 | 0 | 0.1 |  | 0 | 0.1 |  | 0 | 0.1
 | 1 | 0.6 |  | 1 | 0.6 |  | 1 | 0.6
 | 1 | 0.55 |  | 1 | 0.7 |  | 1 | 0.55
 | 1 | 0.53 |  | 1 | 0.53 |  | 1 | 0.2
 | 0 | 0.51 |  | 0 | 0.51 |  | 0 | 0.51
 | 1 | 0.59 |  | 1 | 0.59 |  | 1 | 0.59
Ex.2 | Lined up in the same column
 |  |  |  |  | Linregr formula for example 2
A | 0 | 0.3 |  |  |  | -0.1273632459156756
 | 0 | 0.5
 | 0 | 0.4
 | 1 | 0.35 |  |  | Would it be possible to do a Linregr formula and get all the X and y values in one formula without lining them up in one column (like in the first example?).
 | 0 | 0.1
 | 1 | 0.6
 | 1 | 0.55
 | 1 | 0.53
 | 0 | 0.51
 | 1 | 0.59
B | 1 | 0.8
 | 1 | 0.3
 | 0 | 0.4
 | 1 | 0.55
 | 0 | 0.1
 | 1 | 0.6
 | 1 | 0.7
 | 1 | 0.53
 | 0 | 0.51
 | 1 | 0.59
C | 0 | 0.3
 | 0 | 0.3
 | 0 | 0.2
 | 1 | 0.4
 | 0 | 0.1
 | 1 | 0.6
 | 1 | 0.55
 | 1 | 0.2
 | 0 | 0.51
 | 1 | 0.59
Spreadsheet: 879153d1726595487-most-efficient-way-to-program-this-book-copy-of-employee-sales-target-week-37
Sheet: Tue

Employee | Sales transactions | Gross Sales | Net Sales | Discount | Gross Margin | Gross Margin Ratio | Cost of Goods |  |  |  | ATV
[NAME] | 1 | 210 | 210 | 45 | 158 | 0.75 | 52
[NAME] | 4 | 765 | 760 | 461 | 452 | 0.594 | 308
Total | 5 | 975 | 970 | 506 | 609 | 0.628 | 361
Spreadsheet: 131843d1323355721-nested-if-or-and-matched-indexed-statements-2012_eu22-jv-version-1
Sheet: Ams, Ber, Pra, Vie, Ven

Rooming allocation for Amsterdam, Berlin, Prague, Vienna, Venice
Type | # of Rms
Singles
Twins
Triples
Quads
5 bed
6 bed
Total Pax
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
=IF(ISNONTEXT(a14),"",(INDEX('Names List'!$D17,MATCH("twin",IF(OR('Names List'!$C17="EU",'Names [NAME]))))
Spreadsheet: 857083d1706162361-rearrange-workfile-transpose-formulas-extract-2-
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  |  | London | Paris | Milan | Rome | Madrid | Barcelona | Sofia | [NAME] | Porto | Berlin | Warsaw | [NAME] | Gdansk | Wroclaw | Brussels
Country | Travel | Aircraft 1 | Aircraft 2 |  |  |  |  | [NAME]
London | 20 | 0 | 20 |  |  |  |  | [NAME] | 18 | 12 |  | 7 |  |  |  |  |  |  |  | 0 | 0 | 1 | 2
Paris | 10 | 0 | 10
Milan | 5 | 0 | 5
Rome | 8 | 0 | 8
Madrid | 1 | 0 | 1
Barcelona | 0 | 0 | 0
Sofia | 0 | 0 | 0
[NAME] | 9 | 0 | 9
Porto | 2 | 0 | 2
Berlin | 1 | 0 | 1
Warsaw | 5 | 0 | 5
[NAME] | 0 | 0 | 0
Gdansk | 0 | 0 | 0
Wroclaw | 1 | 0 | 1
Brussels | 2 | 0 | 2
[NAME]
Country | Travel | Aircraft 1 | Aircraft 2
London | 10 | 0 | 18
Paris | 8 | 0 | 12
Milan | 2 | 0
Rome | 3 | 0 | 7
Madrid | 1 | 0
Barcelona | 0 | 0
Sofia | 0 | 0
[NAME] | 7 | 0
Porto | 2 | 0
Berlin | 1 | 0
Warsaw | 4 | 0
[NAME] | 0 | 0 | 0
Gdansk | 0 | 0 | 0
Wroclaw | 1 | 0 | 1
Brussels | 2 | 0 | 2
[NAME]
Spreadsheet: 111705d1308040178-vlookup-in-multiple-sheets-vlookup-in-multiple-sheets
Sheet: $100-250M

CompanyName | websites | employeerange | RevenueRange | state
Company 200 | 10000 | 20000 | 30000 | 40000
Company 201 | 10001 | 20001 | 30001 | 40001
Company 202 | 10002 | 20002 | 30002 | 40002
Company 203 | 10003 | 20003 | 30003 | 40003
Company 204 | 10004 | 20004 | 30004 | 40004
Company 205 | 10005 | 20005 | 30005 | 40005
Company 206 | 10006 | 20006 | 30006 | 40006
Company 207 | 10007 | 20007 | 30007 | 40007
Company 208 | 10008 | 20008 | 30008 | 40008
Company 209 | 10009 | 20009 | 30009 | 40009
Company 210 | 10010 | 20010 | 30010 | 40010
Company 211 | 10011 | 20011 | 30011 | 40011
Company 212 | 10012 | 20012 | 30012 | 40012
Company 213 | 10013 | 20013 | 30013 | 40013
Company 214 | 10014 | 20014 | 30014 | 40014
Company 215 | 10015 | 20015 | 30015 | 40015
Company 216 | 10016 | 20016 | 30016 | 40016
Company 217 | 10017 | 20017 | 30017 | 40017
Company 218 | 10018 | 20018 | 30018 | 40018
Company 219 | 10019 | 20019 | 30019 | 40019