tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: USGT 500621

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 00/12 | 500621 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  | 2773 |  |  |  |  | 0.05 | 0.3883
8 |  | Note: RIDE NOT AVAILABLE |  |  |  |  |  |  |  |  | 0 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  | -674 |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
16 |  |  |  |  |  |  | -699 |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  | -699 |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  | -699 |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  | 4413 | -2 |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  | -4413 |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  | -583 |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  | 583 |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
 |  |  |  |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total Injection
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 7909b900-7d8b-4d1f-8a00-8113c8f43ccd
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
TPPA | Test | TPPA | [NAME] by TP-PA, Serum | [NAME] by TP-PA, S | Particle Agglutination | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday, Wednesday, Friday, 9 a.m. | Same day/1 day | 4 days | 1 | 86780 |  |  |  |  | Rochester
TPPA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TPPA | Result | 61480 | [NAME] by TP-PA, S | [NAME] by TP-PA, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6561-5
Spreadsheet: 271288d1381892678-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: WE 5th Jan

Date | Order # | Company | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
03.01.14 | 102498 | Bearing Centre | 2x A54 belts | (to suit [NAME] T810 pump) | 1x T5-640 (20[NAME] wide) timing belt
 |  | Area: | Stock |  | QBR
 |  | Req'd By: | Daryl |  | [NAME]
 |  | Code: | 40Z |  | 1C
 |  | Item Cost: | 28.9 |  | 53.5
 |  | Request No. | 102498 |  | 102499
03.01.14 | 104978 | Southern Steel | 40m - 12mm deformed bar | 2x sheets - 2400x1200x2mm
 |  | Area: | CAPITAL: Job #01 | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1B
 |  | Item Cost: | 80.08 | 440
 |  | Request No. | 104978 | 104978
03.01.14 | 106798 | Norgen | 2x air cyliners per sample
 |  | Area: | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1C
 |  | Item Cost: | 1200.9
 |  | Request No. | 106798
Spreadsheet: 790129d1659541152-conditional-highlighting-across-different-sheets-and-different-columns-example
Sheet: Sheet2

A109 | 4
A110 | 4
A111 | 4
A112 | 4
A113 | 2
A114 | 4
A115 | 4
A116 | 4
B101 | 4
B102 | 4
B103 | 3
B104 | 3
B105 | 1
B106 | 5
Spreadsheet: 868756d1715433735-check-multiple-sheets-for-data-and-when-found-displays-it-on-last-sheet-work-in-progress
Sheet: 64 Tables

 | Inventory Count: |  |  |  |  |  |  | TABLE COUNT DATA
 | As of: |  |  | Cultivar | # of Tables |  |  | Table | BPR # | Initial # Plants Plugged | Kill | Current room Count | Harvested Amount | Harvest Date | Density | BPR Variation | Pinched
 |  |  |  |  |  |  |  | 1
 | Plug Date: |  |  |  |  |  |  | 2
 | Cycle: |  |  |  |  |  |  | 3
 | Room: |  |  |  |  |  |  | 4
 | Status: | Flower |  |  |  |  |  | 5
 | Estimated Harvest Date |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 | Room Total Counts |  |  |  |  |  |  | 8
 | Cultivar | Biotrack Count | Room Count | [NAME] | Initial # Plugged | % Remaining |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 | Total |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 | Room Activity |  |  |  |  |  |  | 18
 | Date | Table | BPR # | Activity | Quantity |  |  | 19
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | Rm4 - Short Tables | 31
 |  |  |  |  |  |  | Rm4 - Short Tables | 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
 |  |  |  |  |  |  | Rm4 - Short Tables | 63
 |  |  |  |  |  |  | Rm4 - Short Tables | 64
 |  |  |  |  |  |  |  | Total
Spreadsheet: 61155d1261934585-excel-2007-dropdown-sheet-selection-drop-down-test
Sheet: b

a | b | c | d
1.601 | 1.6126 | 1.5888 | 1.5984 |  |  | Average
1.5983 | 1.6095 | 1.5848 | 1.5999
1.6045 | 1.6198 | 1.5951 | 1.6025
1.6018 | 1.6123 | 1.5926 | 1.6008
1.6004 | 1.6201 | 1.5993 | 1.6087
1.6084 | 1.6176 | 1.6005 | 1.6059
1.6063 | 1.6156 | 1.5854 | 1.5905
1.5911 | 1.5921 | 1.564 | 1.5645
1.5662 | 1.5767 | 1.5391 | 1.5757
1.5761 | 1.5774 | 1.5433 | 1.5572
1.5569 | 1.5588 | 1.5402 | 1.5474
1.5473 | 1.5663 | 1.5389 | 1.5465
1.5467 | 1.5553 | 1.5057 | 1.5247
1.5245 | 1.5283 | 1.496 | 1.5261
1.5258 | 1.5363 | 1.5058 | 1.5089
Spreadsheet: 771042d1646395020-how-do-you-split-a-table-up-into-multiple-smaller-tables-by-column-how-to-split-up-a-table-into-mutiple-tables
Sheet: Sheet1

 | Normal table that sorts entire table
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
 | 3 | 8 | 143 |  | 3456 |  |  | 34563
 |  |  |  |  |  |  |  | 45623
 |  |  |  |  |  |  |  | 62376
 | 1 | 10 | 34 | 2334 | 4373456 |  | 345634 | 3456343
 | 5 | 6 | 455 |  |  |  |  | 4567456
 |  |  | 567 |  | 435 |  |  | 34563465
 | 4 | 7 | 7 | 456352 | 234 | 2345634 | 5467854
 | 2 | 9 | 23 | 43657345 |  | 3456
 | 6 |  | 3245 |  | 3456345
 |  |  | 25435 |  |  | 7345634 | 73456456
 |  |  |  |  |  |  | 45634
 | Above table broken up so to sort by individual columns without sorting entire table
 | Column1 | Column1 | Column1 | Column1 | Column1 | Column1 | Column1 | Column1
 | 1 | 10 | 25435
 | 2 | 9 | 3245 | 2334 | 4373456 |  | 345634 | 3456343
 | 3 | 8 | 567 | 43657345 |  | 3456
 | 4 | 7 | 455 |  | 3456 |  |  | 34563
 | 5 | 6 | 143 | 456352 | 234 | 2345634 | 5467854
 | 6 |  | 34 |  |  |  |  | 4567456
 |  |  | 23 |  | 3456345
 |  |  | 7 |  |  | 7345634 | 73456456
 |  |  |  |  | 435 |  |  | 34563465
 |  |  |  |  |  |  |  | 62376
 |  |  |  |  |  |  | 45634
 |  |  |  |  |  |  |  | 45623
Spreadsheet: 215974d1361551913-need-to-work-on-countif-and-countifs-formulas-so-it-excludes-certain-data-counting-problems
Sheet: data

order type | customer | expedite | status | Cycle time
SS | A | Yes |  | 3
SC | A | No |  | 3
SS | A | Yes |  | 3
SS | A | No | Cancelled | 0
SS+C | B | Yes |  | 1
SS | B | No |  | 1
SS | B | Yes |  | 0
SS | B | No |  | 3
SS | B | Yes |  | 3
PS | B | No |  | 0
SS | D | Yes | Cancelled | 0
SS | D | No |  | 0
PE | D | Yes |  | 3
SS+U | D | No |  | 1
SS+L | D | Yes |  | 0
SS | B | Yes |  | 3
SS | B | No |  | 3
SS | B | Yes |  | 3
PS | B | No | Cancelled | 0
SS | D | Yes |  | 3
SS | D | No |  | 3
SS | B | Yes |  | 3
SS | B | No |  | 2
SS | B | Yes |  | 2
PS | B | No |  | 2
SS | D | Yes | Cancelled | 0
SS | D | No |  | 1
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 2410

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
 | Workshop
Spreadsheet: 794688d1662215744-positions-of-numbers-within-a-range-within-range
Sheet: Within range

 |  |  | Numbers in ascending order
 | Position
 | 1 |  | 11 |  | In column D, there are numbers in ascending order
 | 2 |  | 13 |  | Their corresponding position counted from the first number are in column B.
 | 3 |  | 17
 | 4 |  | 31
 | 5 |  | 33
 | 6 |  | 38
 | 7 |  | 74
 | 8 |  | 79
 | 9 |  | 83
 | 10 |  | 96
 | 11 |  | 97
 | 12 |  | 115
 | Lower range |  | 20
 | Upper range |  | 90
 | [NAME] return position |  |  |  | We like a formula to return the position of the numbers that are within the yellow highlighted specific range
 |  |  |  |  | i.e., not lower than D27, and not higher than D28
Spreadsheet: 49959d1249385984-how-to-auto-populate-but-with-criteria-conslidate-with-criteria-blank
Sheet: Company C

 | CF ID | Participating LE | Participating Subdiv | Flow | Amount | CF currency | Other Currency | Expected date | Realized date | Eligible | Hedgeable Percentage
 |  | External | External | Outflow | 12200 | EUR | GBP | 2009-06-05 00:00:00 |  | Eligible | 100
 |  | External | External | Outflow | 1076.3 | EUR | GBP | 2009-06-23 00:00:00 |  | Eligible | 100
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-01-01 00:00:00 |  |  | 0
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-01-31 00:00:00 |  |  | 0
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-03-02 00:00:00 |  |  | 0
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-04-01 00:00:00 |  |  | 0
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-05-01 00:00:00 |  |  | 0
 |  | Germany GmBH | Propulsion and controls | Outflow |  | EUR | GBP | 2010-05-31 00:00:00 |  |  | 0
 |  | External | External | Outflow |  | EUR | GBP | 2012-06-30 00:00:00 |  |  | 0
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Susan Hatch Davis

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
To me, this is a basic labor principle about fairness. To enjoy the benefits of collective bargaining without contributing to costs is unfair.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 75 Notchend Rd, West Topsham, Vt 05086 | State Representative | Yes |  | Orange
Spreadsheet: 831168d1685459911-formula-to-lookup-from-dynamic-file-name-based-on-cell-value-output-file
Sheet: Summary & Shrinkage

Finance summary |  |  |  |  | Daily View
 |  | Finance |  |  | 2023-07-02 00:00:00
 |  | Operational Forecast |  |  | 7208 | 594 | 1125 | 1156 | 1185 | 1144 | 1131 | 873
 |  | Operational Forecast including [NAME] |  |  | 8316
 |  | Planned AHT |  |  | 265 | 265 | 265 | 265 | 265 | 265 | 265 | 265
 |  | Required Staffing |  |  | 612
 |  | Staffing Hrs |  |  | 451 | 43 | 97 | 96 | 98 | 75 | 70 | 47
 |  | Staff [NAME] (+/-) Hrs |  |  | -161 | -22
 |  | FC WL Completion
 |  | Predicted WL Volumes
 |  | [NAME]
Spreadsheet: 437815d1451524284-organizing-information-in-excel-need-this-for-work-ef857_organizing_info
Sheet: Input

ID | Serial N |  | Team1 |  |  |  | Team 2 |  |  |  | Team 3
 |  |  | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | Development Question
 |  |  | 4 | 6 | 3 | 2 | 6 | 2 | 6 | 2 | 6 | 3 | 6 | 3
ID | Serial N |  | Team1 |  |  |  | Team 2
 |  |  | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | Development Question
 |  |  | 9 | 4 | 7 | 3 | 3 | 3 | 6 | 2
ID | Serial N |  | Team1 |  |  |  | Team 2 |  | Team 4
 |  |  | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | 1. Attribute A | 2. Atribute B | 3. Attribute C | 4. Attribute D | Development Question
 |  |  | 9 | 4 | 7 | 3 | 3 | 3 | 6 | 2 | 6 | 3 | 6 | 3
Spreadsheet: 139094a0-bd32-4bfc-9e56-129f8a9eccf5
Sheet: Sheet1

Table KS11a Industry of employment - All People aged 16 to 74 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
* Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more information please visit our website: www.birmingham.gov.uk or the National Statistics Website:
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2005. Crown copyright material is reproduced with the permission
of the [NAME] of HMSO .
Spreadsheet: 762443d1641561842-vlook-up-depending-on-2-criterion-book3
Sheet: Sheet1

NAME | GRADE | TYPE | ALLOWANCE |  |  |  |  |  |  | GRADE | PETROL | ELECTRIC |  |  |  |  |  | PETROL
JS | 1 | ELECTRIC |  |  |  |  |  |  |  | 1 | 4896 | 6996 |  |  |  |  |  | ELECTRIC
GT | 2 | PETROL |  |  |  |  |  |  |  | 2 | 5172 | 7500
NO | 4 | ELECTRIC |  |  |  |  |  |  |  | 3 | 5520 | 7896
DR | 5 | ELECTRIC |  |  |  |  |  |  |  | 4 | 5868 | 8196
BE | 1 | PETROL |  |  |  |  |  |  |  | 5 | 6204 | 8604
SR | 2 | ELECTRIC |  |  |  |  |  |  |  | 6 | 6900 | 9300
AR | 4 | PETROL
Spreadsheet: 863243d1710805686-pull-only-jan-data-jan-data
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column62 | Column7 | year |  |  |  | jan value | year end value
2023-11-07 00:00:00 | p | 542 | 11.29 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-31 00:00:00 | 2023
2023-12-04 00:00:00 | d | 5.049 | 12.06 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 2024
2024-01-04 00:00:00 | d | 4.905 | 12.2691
2024-02-05 00:00:00 | d | 4.877 | 12.4482 |  |  |  |  |  |  |  | Correct data
2024-03-06 00:00:00 | d | 4.9 | 12.5 |  |  |  |  |  |  |  | 2023 | NA | 60.891
2024-03-15 00:00:00 | d |  |  |  |  | 15.3 |  |  |  |  | 2024 | 60.18 | 15.3
 | Sub-Total
 |  |  |  | Total F & G
Spreadsheet: 145866d1331784153-sumif-prep-data-test-1-
Sheet: MTD

 |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | H | H
Line # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | Total
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 3 | 2 | 2 | 2 | 1 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | 0 |  | 21
4 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 18
5 | 1 | 0 | 1 | 1 | 0 | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  | 10
6 | 0 | 0 | 1 | 0 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | 20
8 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 4 | 1 | 1 | 1 | 0 | 2 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  | 23
12 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 12
14 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8
 | 1 | 4 | 4 | 4 | 4 | 8 | 5 | 4 | 3 | 6 | 5 | 3 | 6 | 2 | 3 | 4 | 3 | 4 | 7 | 6 | 3 | 5 | 5 | 2 | 3 | 0 | 2 | 3 | 3 | 0 | 0 |  | 112
 |  | Day of Month | 12 | 0
 |  |  |  |  |  |  |  | Prep Hours
 |  |  | Line 3 | Line 4 | Line 5 | Line 6 | Line 8 | Line 12 | Line 14
Day Shift | Job 1 | Work Order
 |  | Type
 |  | Total Time
 | Job 2 | Work Order |  |  |  |  |  | 2032650
 |  | Type |  |  |  |  |  | DIA |  | F
 |  | Total Time
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time
Night Shift | Job 1 | Work Order
 |  | Type
 |  | Total Time
 | Job 2 | Work Order |  |  |  |  | 2032130 | 2032640
 |  | Type |  |  |  |  | DIA | L3 |  | G
 |  | Total Time |  |  |  |  |  | 5.5
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time
Spreadsheet: 191637d1352165218-filtering-problem-student
Sheet: Sheet1

 |  |  |  |  | AAA | Child | Father | Mother
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | Janice Joplin
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: Semi-Finals

⚽Updated scores⚽ |  |  |  |  | ⚽Updated scores⚽
Italy 🆚 Spain |  |  |  |  | England 🏴󠁧󠁢󠁥󠁮󠁧󠁿 🆚 Denmark 🇩🇰
⚽8pm kick-off⚽ |  |  |  |  | ⚽8pm kick-off⚽
〰〰〰〰〰〰〰〰〰 |  |  |  |  | 〰〰〰〰〰〰〰〰〰
⚽ Amin A: 1-2 |  |  |  |  | ⚽ Amin A: 4-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Arif J: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Arif J: 2-1
⚽ Din: 1-2 |  |  |  |  | ⚽ Din: 3-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Hanif E: 1-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Hanif E: 3-1
[NAME]: 2-1 |  |  |  |  | [NAME]: 2-0
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Mehboob: N-S |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Mehboob: N-S
⚽ Mohamed: 2-1 |  |  |  |  | ⚽ Mohamed: 3-1 Wild card applied original score 3-0
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Muizz: 3-0 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Muizz: 4-0
⚽ [NAME]: 3-1 |  |  |  |  | ⚽ [NAME]: 3-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Rahim V: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Rahim V: 2-1
⚽ Rayyan: 1-0 |  |  |  |  | ⚽ Rayyan: 2-0
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Sahir: 3-2 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Sahir: 2-0
⚽ Salim: 2-1 |  |  |  |  | ⚽ Salim: 3-1 Wild card applied original score 1-0
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Salman: 3-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Salman: 2-1
[NAME]: 2-1 |  |  |  |  | [NAME]: 3-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Shafiq: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Shafiq: 3-1
[NAME]: 2-1 |  |  |  |  | [NAME]: 2-1
[NAME]: 1-1 |  |  |  |  | [NAME]: 3-1 Wild card applied original score 2-0
Spreadsheet: 672909d1587062868-parsing-property-address-and-property-city-state-zip-from-text-strings-addresses-formula
Sheet: One Col

1408 6TH ST  ARGYLE TX 76226
324 N [NAME]  WHITE SETTLEMENTMT TX 76108
3400 BURNETT TANDY DR  FORT WORTH TX 76107
2612 GABRIEL DR  MCKINNEY TX 75071
4603 CAMP BOWIE BLVD  FORT WORTH TX 76107-3743
6651 FOSSIL BLUFF DR  FORT WORTH TX 76137-6580
2850 STADIUM DR  FORT WORTH TX 76129
4245 BERRY ST  FORT WORTH TX 76105-5002
408 W FM 545 APT 100 BLUE RIDGE TX 75424
145 LAKEVIEW DR  ALEDO TX 76008-3926
4625 BENBROOK HWY  FORT WORTH TX 76116
6440 SKY POINTE DR  LAS VEGAS NV 89131
7043 SEYMOUR HWY  [NAME]
PO BOX 1604  STEPHENVILLE TX 76401
5358 W VICKERY AVE  FORT WORTH TX 76107
7016 CR 802  BURLESON TX 76028
9068 TYNE TRL  FORT WORTH TX 76118
5358 W VICKERY AVE  FORT WORTH TX 76107
P O BOX 224033   DALLAS TX 75222
8912 HUNTERS GLEN TRAIL  FORT WORTH TX 76120
3257 N BEACH ST  FORT WORTH TX 76111-6301
7920 WILLOWRIDGE DR  NORTHLAKE. TX 76247
310 HOUSTON ST  FORT WORTH TX 76102-7404
3803 SOUTHWEST BLVD  FORT WORTH TX 76116-9440