tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_zufferli__16784__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 10  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 31 | 31.75
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 31 | 32
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 32.25 | 33.25
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 30.5 | 32
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 30.5 | 32
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 30.5 | 32
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 34.5 | 35
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 34.5 | 35
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 34.5 | 35
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 36.5 | 38
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 36.5 | 38
 |  | DEC | 33.3 |  |  |  | DEC | 36.5 | 38
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 839487d1692025235-playoff-schedule-test
Sheet: Sheet1

REGULAR SEASON FINAL STANDINGS
Place | Team Name |  | W | L | T | FW | FL | Pts | RF | RA | +/-
1st | Angels |  | 14 | 1 | 0 | 1 | 0 | 44 | 214 | 58 | 156
2nd | Guys & Dolls |  | 10 | 4 | 2 | 0 | 0 | 38 | 149 | 155 | -6
3rd | Misfits |  | 10 | 5 | 1 | 0 | 0 | 37 | 191 | 127 | 64
4th | Biohazard |  | 10 | 4 | 1 | 1 | 0 | 37 | 127 | 102 | 25
5th | Longhorns |  | 9 | 7 | 0 | 0 | 0 | 34 | 155 | 132 | 23
6th | Bulls |  | 6 | 9 | 0 | 0 | 1 | 27 | 143 | 156 | -13
7th | Cardinals |  | 3 | 11 | 2 | 0 | 0 | 24 | 76 | 154 | -78
8th | Yellowjackets |  | 3 | 12 | 1 | 0 | 0 | 23 | 129 | 203 | -74
9th | Titans |  | 1 | 13 | 1 | 0 | 1 | 18 | 85 | 182 | -97
SCHEDULE - PLAY DOWNS
Date | Time | Location |  | Place |  | Home |  | Score | Visitor |  | Score
Tuesday, August 8 | 06:30:00 | D1 |  | 2 vs. 7 |  |  |  | 13 |  |  | 2
 | 06:30:00 | D2 |  | 8 vs. 9 |  |  |  | 16 |  |  | 6
 | 08:30:00 | D1 |  | 3 vs. 6 |  |  |  | 8 |  |  | 4
Wednesday, August 9 | 06:30:00 | D1 |  | 1 vs. winner of 8v9 |  |  |  | 9 |  |  | 5
 | 08:30:00 | D1 |  | 4 vs. 5 |  |  |  | 11 |  |  | 10
Thursday, August 10 | 06:30:00 | D1 |  | W 2v7 vs. W3v6 |  |  |  | 8 |  |  | 9
 | 08:30:00 | D1 |  | W 1v8/9 vs. W4v5 |  |  |  | 6 |  |  | 12
Friday, August 11 | 07:30:00 | D1 |  | Finals |  | Misfits |  | 14 | Biohazard |  | 6
CHAMPIONS
Spreadsheet: 775154d1648848125-pasting-tables-from-power-point-some-values-are-text-unable-to-convert-to-numbers-unable-to-convert-text-to-numbers
Sheet: Sheet1

Values that I am pasting in, formating is all general. |  |  |  |  |  |  |  |  |  |  |  | Some values are of the text type, using TYPE(x)
33 | 8 | 43 | 529​ | 416​ | 1029​ | 5 | 73​ | 78 | 81 | 610
26 | 17 | 16 | 193 | 111 | 363 | 53 | 64 | 117 | 95 | 274
0 | 0 | 7 | 142 | 10 | 159 | 35 | 44 | 79 | 42 | 186
0​ | 0 | 0 | 1 | 75​ | 77​ | 7 | 5 | 12​ | 7 | 7​
0 | 2 | 2 | 27 | 0 | 31 | 12 | 11 | 23 | 14 | 40
0 | 5 | 2 | 0 | 0 | 10 | 0 | 0 | 0 | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  | Using the VALUE() comand does not work.
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: MATH & SCIENCE TITLE IIB

Grant: |  | Title II-B Math & Science Partnerships
CFDA # |  | 84.366
GRANT NUMBER: |  | 5366
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 283C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - SEPTEMBER 30, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013
0030 | Adams 14 | 341140 |  |  |  |  |  |  |  |  | 114719 | 17223 | 26392 |  | 33630 | 52212 | 63037 | 15768
0070 | Westminster 50 | 108631 |  |  |  |  |  |  |  |  | 7229 |  |  |  | 7319
0180 | Adams-Arapahoe 28J | 242634 |  |  |  |  |  |  |  |  |  |  |  | 38884 | 14931 | 3964 | 6867 | 61808 | 3383
0880 | Denver Public Schools | 79644 |  |  |  |  |  |  |  | 41359 |  |  |  | 4651 |  | 4971 |  |  | 321
0910 | Eagle County RE 50 | 57650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33565 |  | 24085
1010 | Colorado Springs 11 | 348221 |  |  |  |  |  |  |  |  |  | 18950 | 8456 | 8499 | 21646 | 24224 | 158940 | 20952
3120 | [NAME] 6 | 252246 |  |  |  |  |  |  |  | 19442 | 11924 | 38576 | 35239 | 12525 | 47330 | 79039 | 25291
Spreadsheet: 781285d1653134101-returning-all-values-that-mett-criteria-property-inspection-form-address-a-v3-test
Sheet: Sheet2

Report for C |  |  | Report for R
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Spreadsheet: 328143d1403795047-referencing-cell-based-on-user-input-that-corresponds-to-a-vlookup-examples
Sheet: data output

 |  |  |  | desired results in column e
 |  | Month |  | if jan
 |  | branch 1 |  | 1 |  |  | as you can see here the column changes but the row doesn’t as branch 1 is always in the same place in the data source
 |  | branch 2 |  | 21
Jan | c
Feb | d
Mar | e
Apr | f
May | g
Jun | h
Jul | i
Aug | j
Sep | k
Oct | l
Nov | m
Dec | n
Spreadsheet: 37837d1235918211-gradual-curves-for-bays-672617-track-length-2
Sheet: Sheet1

 | Compute Track Length
 |  |  |  | extrema |  |  |  |  | 1. Enter the track offset and bend radius
 | offset | 150 |  | 0 | -2007.106781186548 |  |  |  | 2. Enter the starting point for the window (arbitrary)
 | bend rad | 150 |  | 2360.660171779821 | 353.5533905932738 |  |  |  | 3. Enter segment lengths and turn angles
 | Window (go CLOCKWISE) |  |  |  |  | Track |  |  | Bends Tangents and Centers |  |  |  |  |  | Bend Points
 | seg | length | turn | x | y | x | y | length | leftx | ctrx | rightx | [NAME] | ctry | righty | Begin | Center | End
 |  |  |  | 0 | 0 | 9.18861341181465e-15 | -150
 | 1 | 300 | 90 | 300 | 1.83772268236293e-14 | 362.1320343559643 | -150 | 358.9048622548087 | 300.0000000000001 | 300.0000000000001 | 406.0660171779822 | -150 | 0 | -106.0660171779821 | 300.0000000000001 | 358.9048622548087 | 417.8097245096173
 | 2 | 500 | -45 | 653.5533905932737 | 353.5533905932738 | 715.685424949238 | 203.5533905932739 | 493.5456557976887 | 671.7514421272201 | 777.8174593052023 | 777.8174593052023 | 159.619407771256 | 53.5533905932738 | 203.5533905932739 | 793.5456557976888 | 852.4505180524974 | 911.355380307306
 | 3 | 1000 | 45 | 1653.553390593274 | 353.5533905932738 | 1591.42135623731 | 203.5533905932739 | 869.2815870857602 | 1529.289321881345 | 1529.289321881345 | 1635.355339059327 | 203.5533905932739 | 53.553390593274 | 159.619407771256 | 1662.827242883449 | 1721.732105138258 | 1780.636967393066
 | 4 | 1000 | 45 | 2360.660171779821 | -353.5533905932736 | 2210.660171779821 | -415.6854249492379 | 869.2815870857602 | 2166.726188957804 | 2060.660171779821 | 2210.660171779821 | -371.7514421272201 | -477.8174593052022 | -477.8174593052022 | 2532.108829969209 | 2591.013692224018 | 2649.918554478826
 | 5 | 1000 | 45 | 2360.660171779821 | -1353.553390593274 | 2210.660171779821 | -1291.42135623731 | 869.2815870857603 | 2210.660171779821 | 2060.660171779821 | 2166.726188957804 | -1229.289321881345 | -1229.289321881345 | -1335.355339059327 | 3401.390417054969 | 3460.295279309778 | 3519.200141564586
 | 6 | 500 | 45 | 2007.106781186548 | -1707.106781186548 | 1857.106781186548 | -1644.974746830583 | 493.5456557976888 | 1901.040764008565 | 2007.106781186548 | 1857.106781186548 | -1601.040764008565 | -1707.106781186548 | -1707.106781186548 | 3894.936072852658 | 3953.840935107467 | 4012.745797362275
 | 7 | 300 | -45 | 2007.106781186548 | -2007.106781186548 | 1857.106781186548 | -2007.106781186548 | 358.9048622548085 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | #N/A | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | #N/A | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | #N/A | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | #N/A | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | #N/A | #N/A
 | Total | 4600 |  |  |  |  |  | 4312.745797362275
 |  |  |  |  |  |  | return to wall
 |  |  |  |  | front of board size
 |  |  |  | Also add the return to wall sizes to the overall front of board size.
Spreadsheet: 717130d1612498014-return-latest-value-balance-between-two-dates-forum-excel-4-f-v-2021-ans
Sheet: Paiement

Date | Description | Montant | Mode paiement | [NAME]
2020-01-01 00:00:00 |  | 0 | Virement | Pmnt Loyer/Int/Hyd
2020-03-09 00:00:00 |  | 150 | Virement | Pmnt Loyer/Int/Hyd
2020-03-09 00:00:00 |  | 100 | Virement | Pmnt Loyer/Int/Hyd
2020-03-19 00:00:00 |  | 450 | Virement | Pmnt Loyer/Int/Hyd
2020-03-19 00:00:00 |  | 390 | Virement | Pmnt Loyer/Int/Hyd
2020-08-14 00:00:00 |  | 700 | Comptant | Pmnt Loyer/Int/Hyd
2020-09-16 00:00:00 |  | 1000 | Carte débit | Trsf Investissement
2021-01-17 00:00:00 |  | 1400 | Virement | Pmnt Loyer/Int/Hyd
Spreadsheet: 86237d1286263832-excel-2007-combining-data-from-multiple-excel-files-sample2
Sheet: Summary

Center | Period | Category | Level | Price | QTY | Less | Total | Total Amount
XXXX | week 1 | Y | 0 | 5 | 1 |  |  | 5
XXXX | week 1 | Y | 1 | 10 | 2 |  |  | 20
XXXX | week 1 | Y | 2 | 15 | 3 | 1 |  | 30
XXXX | week 1 | Y | 3 | 20 | 4 | 1 |  | 60
XXXX | week 1 | Z | 0 | 5 | 20 |  | 20 | 100
XXXX | week 1 | Z | 1 | 10 | 100 |  | 100 | 1000
XXXX | week 1 | Z | 2 | 15 | 200 |  | 200 | 3000
XXXX | week 1 | Z | 3 | 20 | 500 |  | 500 | 10000
Spreadsheet: 156557d1337346121-networkdays-of-months-sample_daddy
Sheet: Φύλλο1

JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
Spreadsheet: 706748d1606872514-help-matching-a-numbered-value-with-a-text-value-multiple-times-file
Sheet: Sheet1

DATE | JOB | JOB # | FOREMAN | PROD LEVEL | CREW SIZE | SHOOT TYPE | SQFT | Actual | VOLUME M3 | THICKNESS | TARGET SQ/MD | ACTUAL SQFT/MD | % of TARGET | WAIT TIME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAFETY(Y/N) | SUPPLIER | QA | TOTAL |  |  | 1
2020-04-30 00:00:00 | The Well | 22 | LJ | 3 | 12 | B | 620 |  | 25 | 12" | 64.3 | 46.6 | 0.72 | .33hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | CBM | 99 | 0.72 |  |  | 2
2020-05-01 00:00:00 | 205 Queen | 45 | NP | 1 | 13 | A-Surfacing | 1768 |  | 35 | 2"-5" | 181.3 | 142.35 | 0.785 | .5hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | NA | 0.79 |  |  | 3
2020-05-05 00:00:00 | 205 Queen | 45 | NP | 1 | 13 | A-Surfacing | 1190 |  | 24 | 2"-5" | 132 | 76.42 | 0.58 | 1.75hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | NA | 0.58 |  |  | 4
2020-05-06 00:00:00 | Lombard | 47 | LJ | 2 | 10 | B | 520 |  | 12 | 8" | 89.6 | 80.8 | 0.9 | 1hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | 99 | 0.9
2020-05-06 00:00:00 | 19 [NAME] | 16 | SS | 3 | 11 | C | 780 |  | 56 | 30" | 0.69 | 43.4 | 0.65 | .25hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | 100 | 0.62
2020-05-06 00:00:00 | Due East | 15 | CP | 1 | 10 | A | 1218 |  | 38 | 13" | 127 | 122.7 | 0.96 | .75hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Metrix | TBD | 0.96
2020-05-07 00:00:00 | Due East | 15 | CP | 1 | 11 | A | 1200 |  | 38 | 13" | 122.5 | 104.3 | 0.85 | 0hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Metrix | TBD | 0.85
2020-05-07 00:00:00 | 19 [NAME] | 16 | SS | 3 | 10 | C | 550 |  | 24 | 16" | 74.6 | 58.6 | 0.785 | .75hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | 100 | 0.785
2020-05-07 00:00:00 | [NAME] | 46 | LJ | 1 | 8 | A | 1000 |  | 32 | 13" | 100.7 | 117.2 | 1.163 | 2.75hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | CBM | 100 | 1.163
2020-05-08 00:00:00 | UofT | 2 | LJ | 2 | 11 | A | 1001 |  | 48 | 18"-28" | 88.5 | 51.4 | 0.58 | 3.25hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Innocon | TBD | 0.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
Spreadsheet: 0d7bd48d-11d3-4222-b74e-f5140be59f3c
Sheet: Sheet1

EXTENSION COUNCIL EXECUTIVE BOARD MEMBERS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
(Commissioner [NAME] or At Large)
 | Name | Address | Town | State | Zip | Phone | E-mail | *Dist #
Chair |  |  |  | KS
Vice Chair |  |  |  | KS
Secretary |  |  |  | KS
Treasurer |  |  |  | KS
Other Members
Member |  |  |  | KS
Member |  |  |  | KS
Member |  |  |  | KS
Member |  |  |  | KS
Member |  |  |  | KS
This is to certify that the above officers and members of the Executive Board were duly elected on
 |  |  |  |  | Date
 |  |  |  |  | Chair
[NAME] CERTIFICATE
This is to certify that the list of County Extension Council Members and officers has been filed in this office.  The Executive Board Members have signed the usual oath of office.  The treasurer's bond has been approved by me and filed in my office.
Witness my hand and seal this _______________________ day of ___________________________________________, ___________.
 |  |  |  | _________________________________________________
 | (Seal) |  |  |  |  | [NAME]
 |  |  |  | _____________________________County, Kansas
* For "At Large" members do not list District Number.
The complete County Extension Council member list is attached.
KSU 8-4a & b (June 2009)
Spreadsheet: 858057d1706832529-embedding-max-min-in-sumproduct-formula-sjpeters75-opportunity-calculator
Sheet: Sheet1

Opportunities |  |  |  |  |  |  | Holidays
Contract | $/hr | Start | End |  |  |  | 2024-01-01 00:00:00
Contract 1 | 1 | 2024-01-01 00:00:00 | 2024-07-06 00:00:00 |  |  |  | 2024-01-15 00:00:00
Contract 1 | 2 | 2024-05-01 00:00:00 | 2024-12-09 00:00:00 |  |  |  | 2024-02-19 00:00:00
Contract 2 | 1 | 2024-09-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  | 2024-05-27 00:00:00
Contract 3 | 1 | 2024-02-04 00:00:00 | 2024-02-08 00:00:00 |  |  |  | 2024-06-19 00:00:00
 |  |  |  |  |  |  | 2024-07-04 00:00:00
 |  |  |  |  |  |  | 2024-09-02 00:00:00
 |  |  |  |  |  |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  | 2024-11-11 00:00:00
 |  |  |  |  |  |  | 2024-11-28 00:00:00
 |  |  |  |  |  |  | 2024-12-25 00:00:00
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Contract 1
Contract 2
Contract 3
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Contract 1 | 168 | 160 | 168 | 176 | 880 | 760 | 736 | 704 | 640 | 704 | 608 | 192
Contract 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 176 | 152 | 168
Contract 3 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 06edc1dd-d75a-4033-bd23-917bb109855c
Sheet: Reading Grade 5

2013 Minnesota Comprehensive Assessments-Modified
Grade 5 Reading
Raw Score | Scale Score | Level
0 | 90 | D
1 | 115 | D
2 | 129 | D
3 | 138 | D
4 | 145 | D
5 | 150 | D
6 | 155 | D
7 | 159 | D
8 | 163 | D
9 | 166 | D
10 | 169 | D
11 | 172 | D
12 | 175 | D
13 | 177 | D
14 | 180 | D
15 | 183 | D
16 | 185 | D
17 | 188 | D
18 | 190 | P
19 | 192 | P
20 | 195 | P
21 | 197 | P
22 | 200 | M
23 | 203 | M
24 | 205 | M
25 | 208 | E
26 | 211 | E
27 | 214 | E
28 | 218 | E
29 | 222 | E
30 | 226 | E
31 | 232 | E
32 | 238 | E
33 | 247 | E
34 | 261 | E
35 | 286 | E
End of Worksheet
Spreadsheet: 221033d1363352457-vlookup-or-other-tools-to-retun-more-than-1-match-from-2-criteria-datavalidation-with-formula
Sheet: DataValidationLists

 |  | Data Validation Lists
City |  | Type |  | Model |  | Result
Select |  | Select |  | Select
A |  | P |  | 4
B |  | V |  | 6
H |  | C |  | 8
S |  |  |  | 12
U
A | 12 | 24
A | 4 | 12
A | 6 | 12
A | 8 | 24
A | 8 | 48
B | 4 | 12
B | 8 | 24
B | 8 | 48
H | 4 | 12
H | 8 | 24
H | 8 | 48
U | 4 | 12
U | 8 | 24
U | 8 | 48
S | 12 | 24
S | 4 | 12
S | 6 | 12
S | 8 | 24
S | 8 | 48
Spreadsheet: 819820d1677701378-create-a-rolling-60-minute-window-to-assess-busiest-time-period-rolling60minsample-copy
Sheet: Sheet1

Time | Occurences | TimeToVal |  | Rolling 60 minute total? |  | RH Time Start | RH Total |  | [NAME] | Peak RH start | Peak RH finish
0005 | 4 |  |  |  |  | 00:00:00
0005 | 5
0010 | 5
0010 | 4
0010 | 5
0010 | 2
0010 | 9
0020 | 1
0030 | 2
0045 | 1
0105 | 13
0105 | 13
0105 | 13
0210 | 1
0430 | 31
0510 | 31
0510 | 31
0510 | 26
0525 | 1
0530 | 30
0530 | 30
0530 | 31
0530 | 31
0530 | 26
0540 | 31
0540 | 21
0540 | 23
0540 | 16
0540 | 1
0550 | 25
0550 | 8
0550 | 31
0600 | 3
0600 | 29
0620 | 31
0620 | 21
0620 | 20
0625 | 1
0630 | 1
0630 | 7
0630 | 28
0630 | 30
0630 | 31
0630 | 31
0630 | 31
0630 | 28
0635 | 9
0640 | 30
0645 | 8
0645 | 8
Spreadsheet: 544174d1508785697-conditionally-summing-across-a-varying-number-of-worksheets-example-book
Sheet: 1

Stock = | Stock 1 |  |  |  |  | Type = | Fund Type |  |  | These merged cells are successfully pulled by indirectly refernceing B1 and H1
Date |  | Event |  | Units |  | Transaction amount |  |  | Year | <- there are other colomuns of data which are calculated but I cannot disclose what they are so in this example the year in column J is the reference to AJ in the post
2011-01-01 00:00:00 |  | Buy |  | 6000 |  | 7000
2011-01-20 00:00:00 |  | Dividend |  | 0 |  | 50
2011-02-28 00:00:00 |  | Sell |  | -500 |  | 580
2011-03-20 00:00:00 |  | Dividend |  | 0 |  | 45
2012-04-20 00:00:00 |  | Dividend |  | 0 |  | 45
2012-05-02 00:00:00 |  | Sell |  | -450 |  | 470
2013-05-20 00:00:00 |  | Dividend |  | 0 |  | 40
2013-06-20 00:00:00 |  | Dividend |  | 0 |  | 40
2015-07-20 00:00:00 |  | Dividend |  | 0 |  | 40
2015-08-05 00:00:00 |  | Sell |  | -1500 |  | 1740
2015-08-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-09-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-10-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-11-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-12-20 00:00:00 |  | Sell |  | -2000 |  | 2000
2016-01-01 00:00:00 |  | Buy |  | 400 |  | 400
2016-01-20 00:00:00 |  | Dividend |  | 0 |  | 20
2016-02-28 00:00:00 |  | Buy |  | 50 |  | 52
2016-03-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-04-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-05-02 00:00:00 |  | ROC |  | 0 |  | 25
2016-05-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-06-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-07-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-08-05 00:00:00 |  | Buy |  | 500 |  | 506
2016-08-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-09-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-10-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-11-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-12-20 00:00:00 |  | Dividend |  | 0 |  | 35
Spreadsheet: 00b3df58-7541-423c-a527-5d9fdee638b6
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
Date: |  |  |  |  |  |  | TRANSPORT RECORD - NEW Food Based Menu Planning--Lunch |  |  |  |  |  |  |  | Reimbursable Meal Counts
 |  |  |  |  |  |  |  |  | Grain servings |  |  |  |  |  | Grade Group | Planned | Actual
School: |  |  |  |  | Veg servings |  | Fruit servings |  |  | Weekly |  | Milk |  |  | PreK
 |  |  |  | Grade | Daily | Weekly | Daily | Weekly | Daily | Min | [NAME] | Daily | Weekly |  | K-5
Offer [NAME]?    Yes____ No____ |  |  |  | PreK | 1/2 C |  | 1/2 C |  | 1/2 serv |  |  | 6 oz |  |  | 6-8
Grades: |  |  |  | K-5 | 3/4 C | 3 3/4 C | 1/2 C | 2 1/2 | 1 (oz eq) | 8 (oz eq) | 9 (oz eq) | 1 C | 5 C |  | 9-12
Seconds/A la Carte?  Yes____ No_____ |  |  |  | 6-8 | 3/4 C | 3 3/4 C | 1/2 C | 2 1/2 | 1 (oz eq) | 8 (oz eq) | 10(oz eq) | 1 C | 5 C |  | Adults
 |  |  |  | 9-12 | 1 C | 5 C | 1 C | 5 C | 2 (oz eq) | 10 (oz eq) | 12(oz eq) | 1 C | 5 C |  | Total
Menu                                                (include Recipe No. or Brand and product name) |  |  | Quantity Prep (# of servings, pounds, cans) | Temperature Prepared/Sent | Grades:  K-5 |  |  | Grades: 6-8 |  |  | Grades: 9-12 |  |  | Adults/ a la carte: |  | Total Amount Received | Temperature Received/ Served | Actual Served |  |  |  | Leftover/ Comments
 |  |  |  |  | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings |  |  | K-5 | 6-8 | 9-12 | Adults/ a la carte
Meat/Meat Alternate
Vegetables: DG, RO, BP (legumes), S, O -- Identify in Component Column
Fruits
Grain/Bread: þ  if [NAME] rich in Component Column
Other Foods (Condiments, etc.)
Milk 1%  or Fat Free (2 varieties per day)
Subgroup Legend: DG ([NAME]), RO (Red/Orange), BP (Beans/Peas), S (Starchy), O (Other)
*** Reminder: Make sure to document Special Diet Meals and Substitutions.
***For substitutions use nutritionally equivalent food and date when the substitution was know.
Spreadsheet: 187855d1350597818-formatting-formula-task-list
Sheet: Stansted Task List

 | Task List
 |  |  |  |  |  |  |  | Highlight Activities
 |  |  |  |  |  |  |  | This Week [15 Oct - 21 Oct]
 | Task Name | Assigned To | Status | Priority | Due Date | % Done | Progress | Notes
 | U83 - Install LED Sign (Ticker Tape) | [NAME] | Not Started | Medium | 2012-12-17 00:00:00 | 0.25
 | U88 - Fix LED Sign | Darren Haste | Complete | High | 2012-10-17 00:00:00 | 1
 | U81 - Re-open | Darren Haste | On Track | High | 2012-11-01 00:00:00 | 0.35
 | Operation U83 - Incentive Trial | Darren Haste | In Progress | High |  | 0.4
 | Growth Incentive | Darren Haste | In Progress | High | 2012-10-29 00:00:00 | 0.3
 | Rate Boards - Turning Portrait | [NAME] | In Progress | Low |  | 0.2
 | [NAME] for Staff | [NAME] |  |  |  | 0
 | Team Changes - Supervisors & Seniors | [NAME] | In Progress | Medium | 2012-11-05 00:00:00 | 0.2
 | Rota/FTE | [NAME] | In Progress | High | 2012-10-29 00:00:00 | 0.75
 | Holiday Management | Darren Haste & [NAME] | In Progress | Medium
 | Support Team Incentive | Jackie Prescott & Darren Haste | Not Started | High | 2012-11-01 00:00:00
 | Open Sessions FAQ's | Darren Haste | In Progress | High | 2012-10-19 00:00:00 | 0.3
 |  | Darren Haste | Not Started | High | 2012-11-04 00:00:00 | 0
Spreadsheet: 734493d1622203594-take-the-most-recent-month-from-my-data-and-the-days-and-the-qty-associated-with-it-work-in-progress
Sheet: Formulas

Month | Qty |  |  |  | Month | Qty |  |  |  |  | Current Month
 |  |  |  |  | 1 |  |  |  |  |  | Date | Qty
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 10
 |  |  |  |  | 11
 |  |  |  |  | 12
Spreadsheet: 677448d1589363722-i-need-an-alternative-to-an-if-function-as-i-have-too-many-queries-to-be-able-o-use-the-if-stock-level-analysis
Sheet: Sheet2

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Nothing