tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34231d1231372723-variable-or-in-an-array-or-similar-formula-book1
Sheet: Sheet1

Problem: sum the values from column H that meet the conditions below
Cond 1 |  | Jones |  | Cond 1 | Cond 2 | Cond 3 | Value |  |  | 9 | 10 | 11 | 12
Cond 2 |  | [NAME] |  | [NAME] | Jones | 11 | 85 |  | PROOF | 0 | 0 | 85 | 0 |  |  |  |  | 0 | 0 | 1 | 1
Cond 3 |  | 10 |  | Fred | Jones | 9 | 5 |  |  | 0 | 0 | 0 | 0
 | or | 9 |  | [NAME] | Hendrix | 10 | 47 |  |  | 0 | 0 | 0 | 0
 | or | 11 |  | [NAME] | Smith | 9 | 65 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 11 | 16 |  |  | 0 | 0 | 16 | 0
Total value |  | 2261 |  | Fred | Hendrix | 9 | 83 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 9 | 58 |  |  | 0 | 0 | 0 | 0
Total value should be |  | 1261 |  | [NAME] | Jones | 11 | 91 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 12 | 79 |  |  | 0 | 0 | 0 | 0
12' in condition 3 is being wrongly |  |  |  | Fred | Smith | 12 | 41 |  |  | 0 | 0 | 0 | 0
Included (from row 37)… |  |  |  | [NAME] | Jones | 12 | 17 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 10 | 66 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 11 | 10 |  |  | 0 | 0 | 0 | 0
 |  |  |  | Fred | Jones | 12 | 54 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 10 | 21 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 10 | 19 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 10 | 30 |  |  | 0 | 30 | 0 | 0
 |  |  |  | Fred | Hendrix | 11 | 14 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 10 | 51 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 9 | 82 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 12 | 52 |  |  | 0 | 0 | 0 | 0
 |  |  |  | Fred | Smith | 9 | 39 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 9 | 28 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 9 | 285 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 10 | 100 |  |  | 0 | 100 | 0 | 0
 |  |  |  | [NAME] | Jones | 9 | 1000 |  |  | 1000 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 12 | 17 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 10 | 66 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 11 | 10 |  |  | 0 | 0 | 0 | 0
 |  |  |  | Fred | Jones | 12 | 54 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Hendrix | 10 | 21 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 10 | 19 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 9 | 30 |  |  | 30 | 0 | 0 | 0
 |  |  |  | Fred | Hendrix | 11 | 14 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Smith | 10 | 51 |  |  | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | Jones | 12 | 1000 |  |  | 0 | 0 | 0 | 1000
 |  |  |  |  |  |  |  |  |  | 1030 | 130 | 101 | 1000
Spreadsheet: 1b9b50f1-ba7c-4ff9-9bef-c45502ee44fc
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
 |  |  |  |  |  |  | Lentivirus Injection Request Form
 |  |  |  |  |  |  | University of Maryland, Baltimore    School of Medicine Transgenic Core Laboratory   Howard Hall 581    [PHONE]
 |  |  |  |  |  |  |  | [NAME] Investigator Form
 |  |  |  |  |  | Request Date |  |  |  |  | PI Name
 |  |  |  |  |  | Please indicate address where invoices should be sent: |  |  |  |  | Affiliation
 |  |  |  |  |  | Invoice contact person
 |  |  |  |  |  | Street address |  |  |  |  | Street address
 |  |  |  |  |  | City, State, Zip |  |  |  |  | City, State, Zip
 |  |  |  |  |  | Lab Contact |  |  |  |  | phone
 |  |  |  |  |  | phone |  | email |  |  | email
 |  |  |  |  |  | Animal Facility Address: |  |  |  |  |  | ARF# |  | Exp. Date
 |  |  |  |  |  | (Complete Address) |  |  |  |  |  | Please include a copy of your protocol approval letter
 |  |  |  |  |  | Veterinarian contact: |  | Phone |  |  | email |  |  | FAX
 |  |  |  |  |  | Animal Facility Contact: |  | Phone |  |  | email |  |  | FAX
 |  |  |  |  |  | [NAME] strain for injections (indicate): |  |  | B6C3F1 |  | C57BL/6NCr |  | FVB | Other
 |  |  |  |  |  | Titer must be 1-2x108 I.U./mL; Aliquot total volumes of 20-30 uL required to avoid freeze-thaw
 |  |  |  |  |  | Construct Name:
 |  |  |  |  |  |  |  | Please provide 1) a linear map of your construct
 |  |  |  |  |  | Titer: |  |  | Volume: |  |  |  | Vector source:
 |  |  |  |  |  | Plasmids included in vector system (3rd generation, 4 plasmid preferred):
 |  |  |  |  |  | Gene of interest:
 |  |  |  |  |  | Tail biopsies will be provided to PI when pups are 1 week of age, PI must take posession of pups at 28 days of age.
 |  |  |  |  |  | Please report assay results promptly to the Transgenic/Knockout Core Facility at  6-0453
 |  |  |  |  |  | Screening Assay: |  | PCR | Southern |  | Provide a gel photo (PCR) of the screening assay indicating 1) positive control,
 |  |  |  |  |  | (circle one) |  |  |  |  | 2) negative control and 3) demonstration of 1-copy gene per genome sensitivity
 |  |  |  |  |  | Do you require the Transgenic Lab to prep DNA from tail biopsies? |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Please provide a project description as it pertains to the use of transgenic animals:
 |  |  |  |  |  | Has this construct been used to generate transgenic animals previously? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Are phenotypic problems expected (i.e. [NAME])? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | if yes, explain
 |  |  |  |  |  | PI Signature: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Transgenic Lab Approval: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Return this completed form to: Transgenic Core Facility, [NAME] (FAX [PHONE])
 |  |  |  |  |  | This form and all requested information and supporting data must be received prior to project initiation
Spreadsheet: 06d96dfb-14f3-4384-8688-6d85c9918175
Sheet: Sheet1

Unnamed: 0 | Course Timetable/Registration Management Changes | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  | Underline the appropriate session below (FW, SP, SU)
 |  |  |  | Fall/Winter                  Spring                            Summer
 | *See Page 2 for sample requests
 | Course | Duration | Section | Component | Adjust | Issue & Reason
 | SAMPLE |  |  |  |  | * Note course numbers below may be fictitious.  This is an example only
 | Course | Duration | Section | Component | Adjust | Issue & Reason
 | PSYC 1F90 | 1 | 1 | SEM 8 | Cancel | [NAME]’s signature requested/provided
 | TREN 2P20 | 3 | 1 | LEC/SEMS | Cancel | [NAME]’s signature requested/provided
 | HIST 2P15 | 2 | 1 | LEC/SEMS | Move to D3 | Staffing changes require balance of workload for instructor.
 | FILM 2P54 | 2 | 1 | LEC/SEMS | Add | For students in program Film Studies Year 2.  [NAME] form is in the mail, has been approved by the [NAME] (or designate)
 | ECON 1P91 | 3 | 1 | TUT 3 | Move time slot | Can only staff for two simultaneous slots in this course.
 | MATH 2P50 and MATH 2P55 | 3 3 | 1 1 | LEC LEC | Move time slot on one | MATH 2P50 and MATH 2P55 are both required in honours program Mathematics at year 2 – courses cannot conflict.
 | SOCI 2F00 | 1 2 | 1 1 | LEC LEC | Move time slot on one | SOCI 2F00 is required in coop program Sociology at year 2 and SOCI 2P21 is optional – courses should not conflict.
 | and SOCI 2P21
 | LING 1F25 and LING 5F25 | 2 2 | 2 1 | SEM 2 and LEC | Staffing | Students in the graduate course will TA in LING 1F25. Please resolve the conflict.
 | WISE 2P44 | 3 | 1 | LEC | Staffing | Adjust from instructor [NAME] to new instructor [NAME] (BUFA)
 | [NAME] | 3 | 1 | LEC | Replace this course with new number EDUC 5P44 | No longer offering 5P42 in the Calendar.  Please change to EDUC 5P44
Spreadsheet: 293969d1391150669-how-to-set-the-date-so-that-it-changes-red-after-that-date-passes-client-test-tracker-2014-_winon_rev_1
Sheet: Sheet2

 | TEST | CLIENT | DOB | TEST | DATE TEST | DATE RESULTS | DATE REPORT | Report on
 | DATE |  |  |  | SUBMITTED | DUE BACK | DUE | File
1 |  |  |  | Toxicology | 2014-01-01 00:00:00 |  |  |  |  |  | MRT |  |  |  | CBC | 1
 |  |  |  |  |  |  |  |  |  |  | Stool | 2014-01-30 00:00:00 |  |  | MRT | 7
 |  |  |  |  |  |  |  |  |  |  | CBC | 2014-01-31 00:00:00 |  |  | Stool | 23
 |  |  |  |  |  |  |  |  |  |  | Amino Acid Test | 2014-01-01 00:00:00 |  |  | Total Thyroid Test | 1
 |  |  |  |  |  |  |  |  |  |  | Total Thyroid Test | 2014-01-01 00:00:00 |  |  | Amino Acid Test | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hormone Testing | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bio Panel Test | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metabolic Testing | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toxicology | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test11 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test12 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test13 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test14 | 5
Spreadsheet: 188887d1351017303-calculating-value-between-two-points-solar2
Sheet: Yr End

2012 Report
Monthly Totals
 | Consumption / KW |  |  | Charges |  |  | Efficiency
 | Used | PG&E | Solar | Charges | Billed | Solar | Est | Actual
Jan | 693.39 | 326.01 | 367.38 | 84.8223987 | 46.29 | 38.53239869999999 | 302.307603686636 | 367.38
Feb | 784.43 | 236 | 548.43 | 100.7600335 | 35.17 | 65.5900335 | 449.3748609566185 | 548.43
Mar | 694.9399999999998 | 113 | 581.9399999999998 | 89.26504299999998 | 18.87 | 70.39504299999997 | 484.0021505376344 | 581.9399999999998
Apr | 724.7099999999999 | 121 | 603.7099999999999 | 93.0889995 | 20 | 73.0889995 | 300.5806451612903 | 603.7099999999999
May | 749.0400000000001 | 66 | 683.0400000000001 | 96.21418800000002 | 13.28 | 82.93418800000002 | 646.141935483871 | 683.0400000000001
Jun | 615.19 | 0 | 615.19 | 79.0211555 | -7.9 | 86.9211555 | 602.5032258064516 | 615.19
Jul | 1029.71 | 448 | 581.71 | 132.2662495 | 62.16 | 70.1062495 | 613.4516129032259 | 581.71
Aug | 2589.7 | 2010 | 579.7 | 563.03355582 | 376.99 | 186.04355582 | 631 | 579.7
Sep | 2004.66 | 1462 | 542.66 | 346.752736974 | 207.53 | 139.222736974 | 590.0967741935484 | 542.66
Oct | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nov | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals | 9885.77 | 4782.01 | 5103.759999999999 | 1585.224360494 | 772.39 | 812.834360494 | 4619.458808729276 | 5103.759999999999
% Consumed |  | 0.483726609055238 | 0.5162733909447619 | [NAME] | 0.4872433323944768 | 0.5127566676055232 | 1.104839378663914 | Efficient
Spreadsheet: 191426d1352117091-filtering-values-based-on-multiple-oring-criteria-without-using-pivot-copy-of-test-project
Sheet: Test

Id | Owner | Stage | Increemental | Stale | Amount
1 | ABC | Open | Y | N | 5000
2 | ABC | Closed | Y | N | 5001
3 | ABC | Rejected | N | Y | 5002
4 | ABC | Assigned | N | N | 5003
5 | DEF | Closed | Y | Y | 5004
6 | DEF | Open | N | N | 5005
7 | DEF | Closed | N | N | 5006
8 | DEF | Rejected | Y | Y | 5007
9 | DEF | Assigned | Y | N | 5008
10 | GHI | Closed | Y | N | 5009
11 | GHI | Open | N | Y | 5010
12 | GHI | Closed | N | N | 5011
13 | GHI | Rejected | Y | Y | 5012
14 | GHI | Assigned | Y | N | 5013
Required Output - Just mentioning the Stages and the Owner should produce the below output
For Stages | Open
 | Rejected
 | Assigned
Owner | Total No. | No. Of Stale | Sum of Increemental Amount
ABC
DEF
GHI
Spreadsheet: 830317d1684852572-trying-to-fill-dates-with-formula-andre-test
Sheet: Sheet1

Date | name | shift
2023-05-23 00:00:00 | [NAME] | Off Shift
2023-05-23 00:00:00 | [NAME]
2023-05-23 00:00:00 | [NAME]
2023-05-23 00:00:00 | Xavier
2023-05-23 00:00:00 | Ziad | Off shift
2023-05-24 00:00:00 | [NAME]
2023-05-24 00:00:00 | [NAME]
2023-05-24 00:00:00 | [NAME]
2023-05-24 00:00:00 | Xavier
2023-05-24 00:00:00 | Ziad
2023-05-25 00:00:00 | [NAME]
2023-05-25 00:00:00 | [NAME] | Off Shift
2023-05-25 00:00:00 | [NAME] | Off Shift
2023-05-25 00:00:00 | Xavier
2023-05-25 00:00:00 | Ziad
For a year | always repeat
Spreadsheet: 876462d1723138062-sort-data-by-2-criteria-sample-v2
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 5 | VS | A+
London | 1.5 | VS | A+
Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C
Seattle | 0.3 | VB | A
LA | 3 | VB | A-
Paris | 1.2 | VB | B
Milan | 1 | VB | B
Toronto | 0.7 | VB | B-
Madrid | 2 | VB | C
Spreadsheet: 1bb79af7-8dfb-4728-81ff-7e17760ceb60
Sheet: Sheet1

Political Subdivision | Receipts | Deductions | Total Dist
Beloit Village | 0 |  | 0
Campbell City | 8603.15 | 111.9 | 8491.25
Canfield City | 93668.42 | 1218.27 | 92450.15
[NAME] Village | 30709.46 | 399.41 | 30310.05
New Middletown Village | 0 |  | 0
Poland Village | 35189.44 | 457.67 | 34731.77
Sebring City | 68522.12 | 922.28 | 67599.84
Struthers City | 0 |  | 0
Youngstown City | 318754.53 | 4248.01 | 314506.52
Austintown Twp | 134969.6 | 1755.43 | 133214.17
[NAME] | 57060.17 | 742.13 | 56318.04
[NAME] | 0 |  | 0
[NAME] | 410996.9 | 5486.36 | 405510.54
[NAME] | 36634.13 | 476.47 | 36157.66
Coitsville Twp | 0 |  | 0
Ellsworth Twp | 185610.28 | 2414.09 | 183196.19
Fairfield Twp | 0 |  | 0
Goshen Twp | 0 |  | 0
Green Twp | 86441.59 | 1129.68 | 85311.91
[NAME] | 0 |  | 0
[NAME] | 13013.57 | 169.26 | 12844.31
Poland Twp | 111750.88 | 1472.06 | 110278.82
Smith Twp | 3485.78 | 45.34 | 3440.44
Springfield Twp | 0 | 0 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 195365d1353502229-manipulate-chart-datatable-877835
Sheet: Sheet1

2012 | 25.82 | 9.36 | 29.82 | 9.13 | 9 | 4.54 | 3.08
2011 | 33.08 | 9.28 | 20.07 | 10.02 | 8.36 | 4.37 | 2.65
 | jan | fev | [NAME] | abr | mai | jun | jul
 | w1 | w2 | w3 | w4 | w5 | [NAME] | w7
Spreadsheet: 678451d1589896486-index-based-on-time-period-and-value-return-value-based-on-time-period
Sheet: Sheet1

 | Name1 | [NAME] | Name3 |  |  |  |  |  |  |  | DATA
2020-05-18 00:00:00 |  |  |  | [NAME] to find "Event name" from data |  |  |  |  |  | Value | Start Date | End Date | Event name
 |  |  |  |  |  |  |  |  |  | Name1 | 2020-05-19 00:00:00 | 2020-05-24 00:00:00 | Event1
 |  | EVENT2 |  |  |  |  |  |  |  | [NAME] | 2020-05-26 00:00:00 | 2020-06-03 00:00:00 | Event2
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-05-19 00:00:00 | 2020-05-24 00:00:00 | Event3
 |  |  |  |  |  |  |  |  |  | Name1 | 2020-05-26 00:00:00 | 2020-06-04 00:00:00 | Event4
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-06-02 00:00:00 | 2020-06-07 00:00:00 | Event5
 |  |  |  |  |  |  |  |  |  | Name3 | 2020-06-08 00:00:00 | 2020-06-08 00:00:00 | Event6
Spreadsheet: 145057d1331289432-base-on-first-sheet-second-sheet-data-auto-arrange-manufacturing-report_mahju
Sheet: Planning Sheet

DATE | ORDER# | CUSTOMER | SHADE | TEX | LENGTH | QUALITY | COUNT | "BRAND" | CONES TO PRODUCE | REQD KILOS | PLANNED KILOS | LOT #
08.03.12 | 34669 | TEXPORT I | SF-666 | TEX27 | 5000M | SSP | 40/2 | SILVER FALCON | 260 | 38.73999999999999 | 39 | 167309
08.03.12 | 34669 | TEXPORT I | SF-690 | TEX27 | 5000M | SSP | 40/2 | SILVER FALCON | 276 | 41.124 | 42 | 167310
08.03.12 | 34669 | TEXPORT I | SF-647 | TEX27 | 5000M | SSP | 40/2 | SILVER FALCON | 293 | 43.657 | 45 | 167311
08.03.12 | 34673 | TEXPORT C | AS-37935 | TEX27 | 5000M | SSP | 40/2 | SILVER FALCON | 126 | 18.774 | 19.5 | 167312A-B
08.03.12 | 34673 | TEXPORT C | AS-37935 | TEX80 | 3000M | SSP | 20/3 | SILVER FALCON | 26 | 7.280000000000001 | 7.5 | 167313
08.03.12 | 34673 | TEXPORT C | AS-37935 | TEX120 | 3000M | SSP | 20/4 | SILVER FALCON | 26 | 9.724 | 10.5 | 167314
08.03.12 | 34673 | TEXPORT C | AS-37964 | TEX27 | 5000M | PP | 45/2 | SILVER FALCON | 192 | 25.92 | 27 | 167315
08.03.12 | 34678 | AZAIBA | SP-13479 |  | 5000Y | SSP | 40/2 | BOAT | 2250 | 306 | 303 | 167316A-B
08.03.12 | 34677 | THRID | AS-38056 | TEX60 | 5000M | SSP | 20/2 | SILVER FALCON | 340 | 102.34 | 103.5 | 167317 | [NAME]
08.03.12 | 34677 | THRID | AS-38056 | TEX40 | 5000M | SSP | 40/3 | SILVER FALCON | 835 | 187.875 | 190.5 | 167318 | [NAME]
08.03.12 | 34677 | THRID | AS-38056 | TEX105 | 2000M | SSP | 12/2 | SILVER FALCON | 568 | 112.464 | 112.5 | 167319 | [NAME]
08.03.12 | 34682 | ASEEL | P-36841 | TKT120 | 4000Y | EMB | 120D/2 | SILVER FALCON | 30 | 3.6 | 4 | 167320
08.03.12 | 34682 | ASEEL | SP-36841 |  | 5000Y | SSP | 40/2 | BOAT | 640 | 87.04 | 88.5 | 167321
08.03.12 | 34686 | KWUN | AS-31599 | TEX80 | 3000M | PP | 16/2 | SILVER FALCON | 8 | 1.8 | 3 | 167322
 |  |  |  |  |  |  |  |  |  |  |  | 167323
 |  |  |  |  |  |  |  |  |  |  |  | 167324
Spreadsheet: 122610d1317026235-excel-2007-dependent-validation-on-seperate-worksheets-array-not-working-v6_testing
Sheet: Sheet1

ALL1: All Impacted | Sheet1!C1:D1 | All Objectives Impacted | Can't quantify to a single objective
ALL2: None Impacted | Sheet1!C2:D2 | No Objectives Impacted | No single Objective impacted
C&P1:Actively manage our customer relationships | Sheet1!C3:F3 | Develop the culture needed to meet the ITS challenge | More collaborative working –internally and with partners | Manage our partnerships in an integrated way | Greater Cost Awareness
C&P2:Create a new customer engagement model | Sheet1!C4:F4 | More collaborative working –internally and with partners | Manage our partnerships in an integrated way | Deliver our commitments within our budget | [NAME] to manage technology risks
C&P3:Invest in new and existing relationships and partnerships | Sheet1!C5:F5 | More collaborative working –internally and with partners | Manage our partnerships in an integrated way | A single Investment Portfolio covering all elements of the mission | Deliver our commitments within our budget
P&D1:Establish an xxxx xxxx development programme | Sheet1!C6:D6 | Grow the ITS and other skills we need through Development and Training | Supply the right people with the right skills doing the right jobs
P&D2:Identify and develop an appropriate number of high calibre staff | Sheet1!C7:D7 | Improve our leadership and engagement | Manage our people better
P&D3:Professionally manage our people and their careers | Sheet1!C8:D8 | Improve our leadership & engagement | Supply the right people with the right skills doing the right jobs
REP1:Customers have the best possible experience | Sheet1!C9:F9 | A single Investment Portfolio covering all elements of the mission | More collaborative working –internally and with partners | Minimise bureaucracy: fewer and simpler processes | Develop the culture needed to meet the ITS challenge
REP2:Market and communicate our capabilities | Sheet1!C10:E10 | More collaborative working –internally and with partners | Minimise bureaucracy: fewer and simpler processes | Greater cost-awareness
REP3:Prepare for the future | Sheet1!C11:E11 | [NAME] to manage technology risks | We encourage innovation | Technology as a cornerstone of UKUSAB
 | This column gives the range of cells containing options for the option to it's right
Spreadsheet: 549919d1511985863-create-100-stacked-bar-chart-based-on-date-and-multiple-variables-in-single-column-example
Sheet: Sheet1

Date | Variable | Value |  |  | Sum of Value | Column Labels
October | A | 100 |  |  | Row Labels | A | B | C | D | E | F | G | H | I | Grand Total
October | B | 15 |  |  | October | 100 | 15 | 200 | 195 | 250 | 300 |  |  |  | 1060
October | C | 200 |  |  | November | 200 | 150 | 250 | 145 | 200 | 125 |  |  |  | 1070
October | D | 195 |  |  | December | 250 | 300 | 200 | 150 | 250 | 145 | 200 | 150 | 200 | 1845
October | E | 250 |  |  | Grand Total | 550 | 465 | 650 | 490 | 700 | 570 | 200 | 150 | 200 | 3975
October | F | 300
November | A | 200
November | B | 150
November | C | 250
November | D | 145
November | E | 200
November | F | 125
December | A | 250
December | B | 300
December | C | 200
December | D | 150
December | E | 250
December | F | 145
December | G | 200
December | H | 150
December | I | 200
Spreadsheet: 168950d1342637683-spreadsheet-with-unknown-columns-cash-report-july-2012-v1
Sheet: current

 | Bank Balance | 2012-07-11 00:00:00 |  | 360.59
 |  | Due Date | Amount
Add | Deposits
 | Visa/Mastercard/Amex Deposits |  | 125
 | Daily Deposits
 | Cash Transfer - Owner Investment
 | Health Care Authority (Actual) | 2012-07-11 00:00:00
 | Health Care Authority (Estimate)
 |  |  | DEPOSITS=
Less | Outstanding Checks
4991 | LPC Revolving Fund (Dr. Ivy renewal) | 2012-06-27 00:00:00 | -80
4992 | LPC Revolving Fund (Dr. [NAME] renewal) | 2012-06-29 00:00:00 | -80
5009 | [NAME] | 2012-07-04 00:00:00 | -1022.2
5001 | [NAME] | 2012-07-04 00:00:00 | -133.39
4996 | [NAME] | 2012-07-04 00:00:00 | -613.19
5004 | [NAME] | 2012-07-04 00:00:00 | -2256.65
5013 | [NAME] | 2012-07-04 00:00:00 | -513.58
5016 | Smart Image Systems | 2012-07-06 00:00:00 | -391.22
ACH071112 | Security Bankcard Center Inc. | 2012-07-09 00:00:00 | -3900
 |  |  | O/S CHECKS=
Less | Online [NAME]Other
 | State of Oklahoma W/H for May 2012 | 2012-06-20 00:00:00 | -1626 | Need to pay
 | IRS FED W/H PPE 06-20-12 | 2012-06-27 00:00:00 | -5215.7 | Need to pay
 | Cash Transfer - Dr. [NAME] | 2012-07-16 00:00:00 | -500
 | IRS FED W/H PPE 07-04-12 | 2012-07-11 00:00:00 | -5169.11
 | OG&E | 2012-07-11 00:00:00
 | Shred-It | 2012-07-11 00:00:00
 | Cox (Phones/Internet) | 2012-07-12 00:00:00 | -328.89
 | USA Vision | 2012-07-12 00:00:00 | -66.4
 | AT&T Advertising | 2012-07-13 00:00:00 | -365.28
 | IRS Payment plan | 2012-07-13 00:00:00 | -3000 | Need to pay
 | Old Glory | 2012-07-13 00:00:00 | -388
 | [NAME] | 2012-07-13 00:00:00 | -25
 | [NAME] | 2012-07-13 00:00:00 | -280.66
 |  |  | O/S BILL PAY =
 |  |  | Ending Cash Balance
 | DAILY CASH RECONCILIATION - not used for forecast
 | Ending Cash Balance G/L | Quickbooks
 | O/S Checks | Add from above
 | Total
 | Bank Balance | Bank Bal plus todays deposit
 | Difference | Quickbooks vs Arvest
Spreadsheet: 299557d1393233937-copy-if-criteria-is-met-daily-sales-report
Sheet: Index

CP001 | Electronics
CP002 | Photo
CP003 | T-Shirts
CP003 | [NAME]
CP003 | [NAME]
CP003 | Long Sleeves
CP003 | [NAME]
CP003 | Hoodies
CP004 | [NAME]
CP005 | Frame
CP006 | Dog Tag
CP007 | Engraving
CP008 | [NAME]
CP009 | Hat
CP010 | Unit Order
Spreadsheet: 39917d1238163967-nested-if-and-lookup-can-anyone-spot-the-problem-with-these-formulas-book1
Sheet: Sheet2

 |  |  |  |  |  |  |  | LOOKUP(I24,{22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0},{"A1”,”A2”,”A3”,”A4”,”A5",” B1”,”B2”,”B3”,”C1”,”C2”,”C3”,”D1”,”D2”,”D3”,”E1”,”,E2”,”E3”,”F1”,”F2”,”F3”,”G1”,”G2”,”H"})
 |  | 22 | A1
 |  | 21 | A2
 |  | 20 | A3
 |  | 19 | A4
 |  | 18 | A5
 |  | 17 | B1
 |  | 16 | B2
 |  | 15 | B3
 |  | 14 | C1
 |  | 13 | C2
 |  | 12 | [NAME]
 |  | 11 | D1
 |  | 10 | D2
 |  | 9 | D3
 |  | 8 | E1
 |  | 7 | E2
 |  | 6 | E3
 |  | 5 | F1
 |  | 4 | F2
 |  | 3 | F3
 |  | 2 | [NAME]
 |  | 1 | G2
 |  | 0 | H
Spreadsheet: 889122d1739828130-very-large-data-base-has-formulas-in-columns-book3
Sheet: Sheet1

Div | Incident | actual | Rpt | Code | crime | crime2 | address
HCSO | 241108717 | 2024-11-24 14:17:00 | 2024-11-24 14:18:00 | 240 | STOLEN VEHICLE | MOTOR VEHICLE THEFT | 13100 TRADERS VILLAGE DR/N ELDRIDGE PKWY, HOUSTON TX 77041
HCC3 | 241100250 | 2024-11-16 06:23:00 | 2024-11-16 06:24:00 | 90Z | TRANSPORTATION CODE N/A | ALL OTHER OFFENSES | 5101 WADE RD, BAYTOWN TX 77520
HCC4 | 240903729 | 2024-09-30 03:12:00 | 2024-09-30 03:12:00 | 13A | ASSAULT FAMILY/HOUSE MEMBER | AGGRAVATED ASSAULT | 8718 SILVER LURE DR, [NAME]
HCC6 | 241200126 | 2024-12-12 12:54:00 | 2024-12-12 12:54:00 | 23C | THEFT SHOPLIFTING | SHOPLIFTING | 6526 LYONS AVE, HOUSTON TX 77020
HCC4 | 241102191 | 2024-11-18 01:48:00 | 2024-11-18 01:49:00 | 35A | POSS CS PG 1 | DRUG/NARCOTIC VIOLATIONS | 17899 WOODLAND HILLS DR/WILL CLAYTON PKWY, [NAME]
HCSO | 241207259 | 2024-12-20 11:37:00 | 2024-12-20 11:38:00 | 90Z | EXECUTION OF CAPIAS OR ARREST WARRANT | ALL OTHER OFFENSES | 10000 N GREEN RIVER DR, HOUSTON TX 77078
Spreadsheet: robin_rodrigue__33235__DAILY_PID
Sheet: Sheet1

857383 | 741787 | 1 | Price
857382 |  | 2 | Basis
857113 |  | 3 | FX Price
857099 |  | 4 | Physical
764920 |  | 5 | FX Index
818873 |  | 6 | Nymex Based
857114 |  | 7 | Gas Daily
857108 |  | 8 | [NAME] Out
857118 |  | 9 | Cove-P
857119 |  | 10 | Cove-B