tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22336__purchase summary March - May
Sheet: EES Purchase Summary

 |  |  |  |  |  |  |  | Dollars |  |  |  | MWHs
[NAME] |  | Position to fill
Zone |  | Peak |  |  | Off-Peak |  |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
SP |  | 700 | 26.5 | Allegheney | 475 | 26.5 | Allegheney | 4128700 | 11845500
NP |  | 525 | 27.5 | Avista | 425 | 21.5 | Avista | 2997100 | 9003100
 |  |  |  |  |  |  |  | Dollars |  |  |  | MWHs
APRIL |  | Position to fill
Zone |  | Peak |  |  | Off-Peak |  |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
NP 15 |  | 400 | 40 | Allegheny | 325 | 31.3 | Allegheny | 6656000 | 3082267.5 |  |  | 166400 | 98475
 |  | 150 | 37.5 | Avista | 100 | 30 | Avista | 2340000 | 909000 |  |  | 62400 | 30300
SP15 |  | 550 | 40 | Allegheny | 200 | 31.3 | Allegheny | 9152000 | 1896780 |  |  | 228800 | 60600
 |  | 150 | 38 | Avista | 100 | 30 | Avista | 2371200 | 909000 |  |  | 62400 | 30300
 |  |  |  |  | 175 | 30.75 | AEP |  | 1630518.75 |  |  | 0 | 53025
 |  |  |  |  |  |  |  |  |  |  |  | 520000 | 272700
 |  |  |  |  |  |  |  | Dollars |  |  |  | MWHs
MAY |  | Position to fill |  |  |  |  |  |  |  |  |  | 416 | 328
Zone |  | Peak |  |  | Off-Peak |  |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
NP 15 |  | 150 | 34.65 | Allegheny | 100 | 21.75 | Allegheny | 2162160 | 713400 |  |  | 62400 | 32800
 |  | 150 | 35 | Sempra |  |  |  | 2184000 | 0 |  |  | 62400 | 0
 |  | 50 | 35 | AEP | 100 | 22 | AEP | 728000 | 721600 |  |  | 20800 | 32800
 |  | 50 | 38 | Allegheny | 50 | 24.25 | Allegheny | 790400 | 397700 |  |  | 20800 | 16400
 |  | 50 | 38 | Sempra |  |  |  | 790400 | 0 |  |  | 20800 | 0
 |  | 50 | 36.25 | Sempra | 50 | 24 | Sempra | 754000 | 393600 |  |  | 20800 | 16400
 |  |  |  |  | 75 | 24 | Avista | 0 | 590400 |  |  | 0 | 24600
 |  |  |  |  | 25 | 24 | Allegheny | 0 | 196800 |  |  | 0 | 8200
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
SP15 |  | 150 | 36.85 | Allegheny | 100 | 21.55 | Allegheny | 2299440 | 706840 |  |  | 62400 | 32800
 |  |  |  |  | 50 | 21 | Allegheny | 0 | 344400 |  |  | 0 | 16400
 |  | 150 | 37.25 | Sempra |  |  |  | 2324400 | 0 |  |  | 62400 | 0
 |  |  |  |  | 50 | 21.5 | AEP | 0 | 352600 |  |  | 0 | 16400
 |  | 100 | 39.35 | Allegheny | 50 | 23.5 | Allegheny | 1636960 | 385400 |  |  | 41600 | 16400
 |  | 50 | 39.25 | Sempra | 50 | 23.5 | Sempra | 816400 | 385400 |  |  | 20800 | 16400
 |  | 50 | 37.25 | Avista |  |  |  | 774800 | 0 |  |  | 20800 | 0
 |  | 50 | 37.25 | Sempra | 50 | 23 | Sempra | 774800 | 377200 |  |  | 20800 | 16400
 |  | 50 | 37.75 | Sempra | 50 | 23.5 | Sempra | 785200 | 385400 |  |  | 20800 | 16400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 457600 | 262400
Spreadsheet: 01911b9e-b5c8-4385-92f0-8dacf051ce21
Sheet: approved special ed licensure

Minnesota Approved Special Education Teacher Licensure Programs
Key:   B = offered at both undergrad and graduate levels   G = offered at graduate level only   U = offered at undergraduate level only   D = discontinued program | U of M System | University of MN-Duluth | University of MN-Twin Cities | State University System | Bemidji State University | MN State University, Mankato | MN State University, Moorhead | Saint Cloud State University | Southwest MN State University | Winona State University | Private Institutions | Augsburg College | Bethel University | Capella University | Concordia University - St. Paul | Hamline University | St. Mary's University | University of St. Thomas | Walden University
Teacher Licensure Program Name
Special Ed: Academic and Behavioral Strategist K-12 (ABS) |  | B | G |  |  | U | U | B |  |  |  | B | G |  |  |  |  | G | G
Special Ed: Autism Spectrum Disorders Birth-12 |  |  | G |  |  | G | G | G |  |  |  |  |  |  | G |  | G | G
Special Ed: Autism Spectrum Disorders ADDED to ABS
Special Ed: Blind or Visually Impaired  Birth-12 |  | D |  |  | D |  | D | D |  |  |  |  | D
Special Ed: Deaf or Hard of Hearing  Birth-12 |  |  | G
Special Ed: Developmental Adapted Phy Ed  PreK-12 |  |  |  |  |  | D | U |  | D |  |  |  | D
Special Ed: Developmental Disabilities  K-12 |  |  | D |  |  | G | B | G |  |  |  |  |  |  |  |  |  | G
Special Ed: Developmental Disabilities ADDED to ABS
Special Ed: Early Childhood  Birth-Age 6 |  |  | G |  |  | G | G | D |  | D |  |  |  |  |  |  |  | G
Special Ed: Emotional or Behavioral [NAME] |  | D | D |  | G | G | B | G |  |  |  | D | D |  | G | D | G | G | D
Special Ed: Emotional or Behavioral Disorders ADDED to ABS
Special Ed: Learning Disabilities  K-12 |  | D | D |  | G | G | B | G |  |  |  | D | D | D | G | D | G | G | D
Special Ed: Learning Disabilities ADDED to ABS
Special Ed: Physical and Health Disabilities Birth-12 |  |  |  |  |  |  | G | D
Teacher/Coordinator Work Based Learning 9-12 |  |  | G |  | B |  |  |  |  |  |  |  | G
Teachers of Career/Tech Educ Accomodations for SPED
Revised March 1, 2013
Periodically check Minnesota Department of Education's Special Education Licensure webpage for current program status as it can change.
Spreadsheet: 748994d1632450098-optimize-value-while-staying-in-budget-optimize-value-without-going-over-cost
Sheet: Feuil1

List A |  |  |  | List B |  |  |  | List C
Items | Value | Cost |  | Items | Value | Cost |  | Items | Value | Cost
A | 110 | 100 |  | Q | 150 | 150 |  | W | 125 | 110
B | 90 | 75 |  | R | 115 | 100 |  | X | 100 | 100
C | 85 | 74 |  | S | 100 | 90 |  | Y | 75 | 30
D | 70 | 70 |  | T | 50 | 60 |  | Z | 50 | 10
E | 60 | 50 |  | U | 45 | 50
F | 45 | 40 |  | V | 30 | 10
G | 40 | 30
H | 39 | 30
I | 35 | 30
J | 34 | 20
K | 33 | 10
L | 20 | 9
M | 19 | 8
N | 18 | 7
O | 17 | 6
P | 15 | 5
Spreadsheet: 09305513-76fa-41b1-997c-db7d8cb974aa
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 860774d1708758483-solutions-tracking-truck-status-moviments-delivered-ans
Sheet: Hoja1

 |  |  |  |  | truck | status           8AM | status          10AM | status        12PM | status           14PM | status            15PM | status          16PM | status          17PM | %
 |  |  |  |  | truck1 | on Route | on Route | on Route | on Route | on Route | on Route | delivered
 |  |  |  |  | truck2 | on Route | on Route | on Route | delivered | - | - | -
 |  |  |  |  | [NAME] | on Route | on Route | on Route | on Route | on Route | delivered | -
 |  |  |  |  | truck4 | on Route | on Route | delivered | - | - | - | -
 |  |  |  |  | truck5 | delivered | - | - | - | - | - | -
 |  |  |  |  | truck6 | on Route | on Route | refused | - | - | - | -
 |  |  |  |  | truck7 | on Route | on Route | on Route | on Route | on Route | refused | -
 |  |  |  |  | truck8 | on Route | on Route | on Route | on Route | on Route | on Route | motivated
 |  |  |  |  | truck9 | on Route | motivated | - | - | - | - | -
 |  |  |  |  | truck10 | refused | - | - | - | - | - | -
Spreadsheet: 4ffdd3ed-c927-4e19-823d-f1d8ef4d651d
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
SQUID | Test | SQUID | Squid, IgE | Squid, 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
SQUID | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SQUID | Result | SQUID | Squid, IgE | Squid, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6858-5 | Loligo sp Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: tracy_geaccone__40136__99vs00_Margin_Variance
Sheet: TWRev

[NAME]
Marign Variance - Total Year 2000 vs. 1999
 |  |  | 2000 |  | 1999 |  | [NAME]
Margin Total |  |  | 150.3 |  | 141.6
West Deliveries: |  |  | 10.2
Gallop | 5.85
Current Firm Customers Rate Increase | 1.56
Higher Rates & Volumes | 2.8
East Deliveries:
Contract Terminations & Lower Rates & Volumes |  |  | -2.8
[NAME]:
Increased Rates & Volumes |  |  | 1.3
Total Variance
Spreadsheet: kate_symes__19108__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 |  |  |  |  |  | ..
Spreadsheet: 852181d1702287090-any-idea-for-data-arrangement-dataarrange-1-
Sheet: output

Name | bit_count | Address1 | max_bit | min_bit | Address2 | max_bit2 | min_bit2
XYZ | 10 | 0x00 | 7 | 6 | 0x01 | 7 | 0
PQ | 6 | 0x00 | 5 | 4 | 0x02 | 7 | 4
ABC | 4 | 0x00 | 3 | 0
 | 10 | 0x00 | 7 | 6 | 0x01 | 7 | 0
PQ | 6 | 0x00 | 5 | 4 | 0x02 | 7 | 4
ABC | 4 | 0x00 | 3 | 0
 | 10 | 0x00 | 7 | 6 | 0x01 | 7 | 0
PQ | 6 | 0x00 | 5 | 4 | 0x02 | 7 | 4
ABC | 4 | 0x00 | 3 | 0
Spreadsheet: 686162d1594394451-array-formula-across-multiple-worksheets-and-columns-per-diem-test
Sheet: Schedule Summary

Start Date | State | City | PerDiem | M&IE
2019-10-03 00:00:00 | AL | Gulf Shores
2019-11-10 00:00:00 | AR | Hot Springs
2019-12-05 00:00:00 | VA | [NAME]
2020-01-02 00:00:00 | TX | Dallas
2020-02-05 00:00:00 | VA | Arlington
2020-03-04 00:00:00 | MD | Rockville
2020-04-10 00:00:00 | LA | New Orleans
2020-05-06 00:00:00 | NC | Fayetteville
2020-06-10 00:00:00 | SC | Columbia
2020-07-12 00:00:00 | CA | Los Angeles
2020-08-01 00:00:00 | AZ | Phoenix
2020-09-28 00:00:00 | MN | Minneapolis
2020-10-03 00:00:00 | GA | Atlanta
2020-11-15 00:00:00 | WA | Seattle
2020-12-10 00:00:00 | PA | Pittsburg
Spreadsheet: 168804d1342591421-changing-cell-refernce-in-sum-formula-according-to-list-selection-date-change-example
Sheet: Sheet1

Report Date | 2012-07-01 00:00:00
 |  |  | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00
 |  | Value | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5
Total
In the formula in B6, I would like to be able to change the first cell reference to match the date in B1  eg, if I change B1 to 19-Aug-12, the formula should be =SUM(K3:Q3)
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -68011 | -37500 | -90 | -29410
2 | -49057 | -20000 |  | -27910
3 | -48415 | -11000 |  | -36910
4 | -29951 |  |  | -29410
5 | -29999 |  |  | -29410
6 | -29297 |  |  | -28307
7 | -64051 | -11000 |  | -51049
8 | -35246 |  |  | -34257
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 36339
 | 2001-08-08 00:00:00
CBS Dollars
 |  |  | -29968.41
Spreadsheet: thomas_martin__39745__Vac Time thru 093001
Sheet: Off_Duty_report_20011015_111445

CCode | CCenter | Name | Pernr | Leave as of | Vacation Taken | Family | Personal | Non-Discr | Sick | 90% Sick | Other Sick | [NAME] Holiday | Home Leave | Other Leave | Grand Total | Vac Carry Over | [NAME] | Vac Balance
12 | 106012 | Martin, Thomas A * | 501166 | 2001-01-31 00:00:00 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8
12 | 106012 | Martin, Thomas A * | 501166 | 2001-02-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 106012 | Martin, Thomas A * | 501166 | 2001-03-31 00:00:00 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40
12 | 106012 | Martin, Thomas A * | 501166 | 2001-04-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 106012 | Martin, Thomas A * | 501166 | 2001-05-31 00:00:00 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16
12 | 106012 | Martin, Thomas A * | 501166 | 2001-06-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
413 | 150297 | Martin, Thomas A * | 501166 | 2001-06-30 00:00:00 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16
413 | 150297 | Martin, Thomas A * | 501166 | 2001-07-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
413 | 150297 | Martin, Thomas A * | 501166 | 2001-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
413 | 150297 | Martin, Thomas A * | 501166 | 2001-09-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 200 | 128
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 |  | -115
2 | -4125
3 |  | -4
4 | -24674
5 | -62427 | -29082
6 | -88065 | -70000
7 | -97070 | -108756
8 | -94202 | -117060
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -351170.32
2001-08-08 00:00:00
CBS Volume
 |  |  | -150287
Spreadsheet: 45776d1244576356-formula-vlookup-perhaps-that-moves-info-from-one-sheet-to-another-example
Sheet: May

Information | Status
bla 6 | Completed
bla 7 | Continuing
bla 8 | Completed
bla 9 | Continuing
bla 10 | Completed
[NAME] | Completed
bla 12 | Completed
bla 13 | Continuing
bla 14 | Completed
bla 15 | Completed
Spreadsheet: 680265d1590897055-array-with-multiple-ranges-sample
Sheet: Sheet1

Name |  | Name |  | Goal
[NAME] |  | [NAME] |  | [NAME] |  | My goal is to create an array from multiple ranges that skip blank entries.
[NAME] |  | [NAME] |  | [NAME] |  | A2:A10 and C2:C10 contain the data to extract with the array, populated in "Goal" E2:E10
Jon |  | [NAME] |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | Jon
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 889654d1740562435-calculating-pick-errors-with-yes-no-test-pick-data
Sheet: PickersData

NAME | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | JAN | FEB | TOTAL
[NAME]
[NAME] |  |  |  |  |  |  |  |  | 100 | 100
[NAME] |  |  |  |  |  |  |  |  | 99.19871794871796 | 100
[NAME] |  |  |  |  |  |  |  |  | 100 | 99.13793103448276
Ava Sinclair |  |  |  |  |  |  |  |  | 0 | 100
[NAME] |  |  |  |  |  |  |  |  | 100 | 100
[NAME] |  |  |  |  |  |  |  |  | 99.8798076923077 | 100
[NAME] |  |  |  |  |  |  |  |  | 96.49122807017544 | 99.80340760157273
[NAME] |  |  |  |  |  |  |  |  | 0 | 100
 |  |  |  |  |  |  |  |  | 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: 686606d1594713272-condtional-formatting-from-last-non-blank-cell-client-hub_engagement-overview_eh
Sheet: Clients

Argyll Holidays |  |  |  |  |  | Argyll Holidays
Argyll Holidays |  |  |  |  |  | [NAME]
Argyll Holidays |  |  |  |  |  | Browne White Limited t/a ScotlandShop.com
Argyll Holidays |  |  |  |  |  | CJ Wildlife
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | H. Garlick Ltd t/a ElectricaldiscountUK
[NAME] |  |  |  |  |  | Holiday At Home Limited
[NAME] |  |  |  |  |  | Hughes Electrical Direct
Browne White Limited t/a ScotlandShop.com |  |  |  |  |  | Ingresso Group Limited
Browne White Limited t/a ScotlandShop.com |  |  |  |  |  | Mattress Online.co.uk Limited
Browne White Limited t/a ScotlandShop.com |  |  |  |  |  | [NAME]
Browne White Limited t/a ScotlandShop.com |  |  |  |  |  | [NAME]'s Cottages
CJ Wildlife
CJ Wildlife
CJ Wildlife
CJ Wildlife
[NAME]
[NAME]
[NAME]
[NAME]
H. Garlick Ltd t/a ElectricaldiscountUK
H. Garlick Ltd t/a ElectricaldiscountUK
H. Garlick Ltd t/a ElectricaldiscountUK
H. Garlick Ltd t/a ElectricaldiscountUK
Holiday At Home Limited
Holiday At Home Limited
Holiday At Home Limited
Holiday At Home Limited
Hughes Electrical Direct
Hughes Electrical Direct
Hughes Electrical Direct
Hughes Electrical Direct
Ingresso Group Limited
Ingresso Group Limited
Ingresso Group Limited
Ingresso Group Limited
Mattress Online.co.uk Limited
Mattress Online.co.uk Limited
Mattress Online.co.uk Limited
Mattress Online.co.uk Limited
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]'s Cottages
[NAME]'s Cottages
[NAME]'s Cottages
[NAME]'s Cottages
Spreadsheet: 129860d1321939766-excel-2007-add-an-alert-message-to-a-radio-button-in-a-group-radiobuttontest
Sheet: Sheet1

Yes/No |  | Yes=1 | No=2
1
2
1 |  | Explain the actions planned to fully comply with the requirements
1
1
12
0
4
1
2
1
1
5
1
1
0
1
1
4
2
1
1
1
4
1
1
1
1
1
2
1
1
3
1
1
1
1
1
1
1
1
1
1
1
1
1
46
0.7391304347826086
Spreadsheet: 98d6ffd4-ed08-4fff-9347-0a532eec6cea
Sheet: Table 5.5

Monthly Statistical Bulletin
5.5 Stock exchange indexes
Month
All ordinaries index (a)
July
August
September
October
November
December
January
February
March
April
May
June
S&P/ASX 200 index (b)
July
August
September
October
November
December
January
February
March
April
May
June
(a) Index at the end of the month. Base: December 1979 = 500.0. (In March 2000 the
all ordinaries index was at 3 133.3, and this was the base used for the S&P/ASX200
index.)
(b) Index at the end of the month. Base: March 2000 = 3 133.3.
Source: Australian Financial Review | http://www.afr.com/home/
 |  |  |  |  |  |  |  | Update
Spreadsheet: 329738d1404394506-how-to-sort-month-and-year-into-oldest-to-new-a-z-order-book-raysrains
Sheet: Aging

Row Labels | Sum of Sterling Value
INTERCO | 2106113.96
2014-05-31 00:00:00 | 10562.02
2014-06-30 00:00:00 | 88725.01999999999
2014-07-31 00:00:00 | 741469.7100000004
2014-08-31 00:00:00 | 300326.6199999998
2014-09-30 00:00:00 | 128029.96
2014-10-31 00:00:00 | 313858.46
2014-11-30 00:00:00 | 2647.17
2014-12-31 00:00:00 | 23636
2015-01-31 00:00:00 | 496859
2020-12-31 00:00:00 | 0
REAL | 7083402.37
2014-01-31 00:00:00 | 1818
2014-04-30 00:00:00 | 3070
2014-05-31 00:00:00 | 27364
2014-06-30 00:00:00 | 165106.39
2014-07-31 00:00:00 | 2508826.610000001
2014-08-31 00:00:00 | 1152722.3
2014-09-30 00:00:00 | 1057579.51
2014-10-31 00:00:00 | 426863.9700000001
2014-11-30 00:00:00 | 59028.64
2014-12-31 00:00:00 | 489520.7300000002
2015-01-31 00:00:00 | 46718.5
2015-02-28 00:00:00 | 7548
2015-03-31 00:00:00 | 7548
2015-04-30 00:00:00 | 7548
2015-05-31 00:00:00 | 7548
2015-10-31 00:00:00 | 3800
2015-12-31 00:00:00 | 1110791.72
Grand Total | 9189516.330000002
How to sort BELOW month and year into oldest to new (A-Z)
 |  |  |  | New figures Can place below
INTERCO