tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788498d1658501034-getting-total-of-all-numbers-in-a-cell-comps-v2
Sheet: Sheet1

Shell:  48% Polyester, 47% Cotton, 5% Polyamide Lining: 100% Polyester Faux Fur: 63% Acrylic, 37% Polyester Rib: 99% Polyester, 1% Elastane Padding: 100% Polyester
70% VISCOSE 30% NYLON
80% Polyester, 10% Acrylic, 10% Viscose
72% VISCOSE 28% NYLON
95% Polyester, 5% Elastane
100% Viscose
100% Lamb Leather Lining: 100% Polyester
100% Lamb Leather Lining: 100% Viscose
Upper: Waterporof full grain leather. Midsole: 100% Rubber. Outsole: 100% rubber. Foodbed: 100% EVA. Lining: 100% wool.
Upper: 100% Leather. Lining & Sock: 100% PU. Outsole: 100% Rubber
Upper: 100% Leather. Lining & Sock: 100% PU. Outsole: 100% Rubber
Upper: 100% Leather. Lining & Sock: 100% PU. Outsole: 100% Rubber
Upper: 100% Leather. Lining & Sock: 100% PU. Outsole: 100% Rubber
97% Cotton 3% Elastane
70% VISCOSE 30% NYLON
Spreadsheet: 597638d1541961604-text-categorisation-if-cell-contains-several-text-in-a-single-cell-then-return-a-value-text-categorisation-sample
Sheet: Text Categorisation

Text Description | Category |  | KW 1 | KW 2 | Category
Repair 10 Vacuum |  |  | Repair | Vacuum | Vacuum Repair Services
Road Transportation Jan'17 |  |  | Road | Transportation | Land Transportation Services
Air Transportation Jan'17 |  |  | Air | Transportation | Air Transportation Services
Spreadsheet: 783439d1654813313-task-completion-rate-on-weekly-monthly-basis-task-completion
Sheet: Percentage

1.1 Daily Tasks
To do list creation.
[NAME]
[NAME]
Checking of emails.
Monitoring and processign of Open cases
Monitoring and processign of DSATs
Escalations
Daily meet up/handshake
Adhoc Tasks
1.2 Weekly Tasks
Call Productivity analysis
One on One coaching with the supervisors.
QA Analysis
To do list creation.
Weekly CSAT analysis
Weekly FCR/Resolution rate analysis
Weekly Productivity Report
1.3 Semi-Month Tasks
1.4 Monthly Tasks
Spreadsheet: d933c688-76f4-469a-9823-fa623875ad11
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
CELI | Test | CELI | Celiac-Associated HLA-DQ Alpha 1 and DQ Beta 1 Medium-High Resolution DNA Typing, Blood | [NAME] | Polymerase Chain Reaction (PCR)/Sequence-Specific Oligonucleotide Probe (SSO) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube: Yellow top (ACD solution B) [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. | 3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 7:30 a.m.-5:00 p.m. | 5 days | 9 days | 2 | 81376 |  |  |  |  | Rochester
CELI | [NAME] | ACDB | [NAME] ACD-B |  |  |  | Refrigerated
CELI | Result | DQA | DQ alpha 1 | DQ alpha 1 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44728-4
CELI | Result | DQB | DQ beta 1 | DQ beta 1 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43291-4
CELI | Result | CELIG | [NAME] gene pairs present? | [NAME] gene pairs present? | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CELI | Result | CELIC | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: rick_buy__32948__raptor4b
Sheet: Cash-Int-Trans

Transactions
Option Premiums Earned
Settle Put Premium on ENE shares |  |  | 2001-01-26 00:00:00
Total Option Premiums Earned |  | h
Cash Settlement on Put
Transfer to Note
Distributions
to LJM | -40469684
LJM additional Equity
Paymentof Interest on Note Receivable |  |  | 2001-03-11 00:00:00
Permitted Investment
Cash Account
Beginning Balance |  |  | 2000-08-31 00:00:00
Net Income
Amortizations
Change in:
Notes Receivable
Interest Receivable
Notes Payable
Option/Put Obligations
Distributions
LJM Equity
Ending Balance
Permitted Investment Income Summary
Permitted Investment Income
 |  |  |  | Historic LIBOR Quotes
Date | 2000-08-31 00:00:00 |  |  | 2000-08-15 00:00:00 | 0.0724 | 2000-11-15 00:00:00 | 0.0713
Beginning Balance | 71001000 |  |  | 2000-09-15 00:00:00 | 0.072 | 2000-12-15 00:00:00 | 0.0688
Date |  |  |  | 2000-10-15 00:00:00 | 0.0718 | 2001-01-15 00:00:00 | 0.0594
Days |  |  |  | Avg
Interest
Date |  |  |  | 2001-01-15 00:00:00 | 0.0594 | 2001-04-15 00:00:00
Beginning Balance | 32684999.85166666 |  |  | 2001-02-15 00:00:00 |  | 2001-05-15 00:00:00
Date |  |  |  | 2001-03-15 00:00:00 |  | 2001-06-15 00:00:00
Days |  |  |  | Avg
Interest
Interest Expense Summary
Interest Expense
Interest from Amort Sheet
Additional Interest included in Amort Sheet
Transaction Date
Amount
Date
Days
Additional Interest
LJM Maximum Capital
Report Date
Intial Contribution | 2000-08-31 00:00:00
Additional
Capital Return if available
Maxium B/S LJM Capital
Spreadsheet: bd477063-039b-4e30-a7da-c212c7347f19
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
FHME | Test | FHME | [NAME] | [NAME] | Polymerase Chain Reaction (PCR) and DNA sequencing | EDTA (lavender-top) tube: EDTA |  |  | 10 | mL | Draw 10 mL whole blood in a lavender-top (EDTA) tube(s). Ship refrigerate.  Note: Collection date is required. | 5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Frozen | A final report will be attached in MayoAccess.   Test Performed by: Athena Diagnostics                              377 Plantation Street                              Four Biotech Park                              Worcester, MA 01605 | Varies | 28 days | 5 - 7 weeks |  | Profile |  |  |  |  | Athena Diagnostics
FHME | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 6 days
FHME | Result | FHME | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHME | Billing Component | FHME |  | MOPATH PROCEDURE LEVEL 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81406
FHME | Billing Component | FHME |  | MOPATH PROCEDURE LEVEL 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81407
FHME | Billing Component | FHME |  | LONG QT SYND GENE FULL SEQ |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81280
Spreadsheet: 825825d1681559496-correction-of-the-indirect-timetable-formula-2023-draft-dailykode-1-
Sheet: MARCH

 |  | DATE | 2023-03-01 00:00:00
GR. 1 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM
 | 1 | 111 | Jhon |  |  | H |  |  | N |  |  |  | N |  |  |  |  |  | H |  |  |  |  |  |  | H |  |  |  |  |  |  |  | H
 | 2 | 112 | [NAME]
 | 3 | 113 | Adalyn
 | 4 | 114 | [NAME]
 | 5 | 115 | Beverly
Spreadsheet: 746740d1630994162-sumifs-with-table-references-results-in-value-error-exceld-and-c
Sheet: Summary

Month | DEMAND (Expected to have) | CAPACITY (Actually have) | What I would expect the capacity to be
2020-08-01 00:00:00 | 8 |  | 5.2
2020-09-01 00:00:00 | 8 |  | 5.2
2020-10-01 00:00:00 | 7 |  | 4.8
2020-11-01 00:00:00 | 7 |  | 3
2020-12-01 00:00:00 | 7 |  | 3
2021-01-01 00:00:00 | 7 |  | 5
2021-02-01 00:00:00 | 7 |  | 6
2021-03-01 00:00:00 | 7 |  | 6
2021-04-01 00:00:00 | 7 |  | 8.37
2021-05-01 00:00:00 | 7 |  | 8.37
2021-06-01 00:00:00 | 7 |  | 8.87
2021-07-01 00:00:00 | 7 |  | 11.37
2021-08-01 00:00:00 | 9 |  | 8.37
2021-09-01 00:00:00 | 7 |  | 8.87
2021-10-01 00:00:00 | 7 |  | 8.87
2021-11-01 00:00:00 | 7 |  | 8.87
2021-12-01 00:00:00 | 7 |  | 8.87
2022-01-01 00:00:00 | 7 |  | 9.87
2022-02-01 00:00:00 | 7 |  | 9.87
2022-03-01 00:00:00 | 7 |  | 9.87
2022-04-01 00:00:00 | 7 |  | 9.87
Spreadsheet: 674293d1587746916-sum-total-past-due-invoices-from-a-list-of-clients-sum-client-total-invoices
Sheet: Sheet1

 | The goal is to write a formula in column P that separately sums the total Past Due invoice amounts in column M for each individual client
 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong |  | Wrong
Cust # | Name | Invoice # | Inv date | Due date | Order # | Inv amt | Paid | Cr/Adj | Balance | Age Balance as of Today | Days Past Due | Past Due | Client |  | Total
16625 | XYZ Corp | 81624 | 2020-02-10 00:00:00 | 2020-03-11 00:00:00 | 48752 | 600 | 0 | 55312.4 | -55312.4
 |  | 81668 | 2020-02-28 00:00:00 | 2020-03-29 00:00:00 | 48112 | 375849 | 0 | 0 | 375849
Customer total |  | Ph |  |  | Fax |  |  |  | 320536.6
16704 | ABC Corp | 81560 | 2020-01-20 00:00:00 | 2020-02-19 00:00:00 | 48516 | 12266.2 | 0 | 0 | 12266.2 |  |  |  |  |  | 12266.2
 |  | 81599 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48711 | 0 | 0 | 1340 | -1340
 |  | 81600 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48713 | 0 | -1742.98 | 3317.76 | -1574.78
 |  | 81604 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48717 | 0 | 0 | 9097.02 | -9097.02
 |  | 81605 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48718 | 0 | 0 | 254.4 | -254.4
 |  | 81681 | 2020-03-04 00:00:00 | 2020-04-03 00:00:00 | 47924 | 576175.56 | 0 | 0 | 576175.56
 |  | 81739 | 2020-03-27 00:00:00 | 2020-04-26 00:00:00 | 48854 | 1950 | 0 | 0 | 1950
 |  | 81746 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 48846 | 1447.55 | 0 | 0 | 1447.55
Customer total |  | PH |  |  | Fax |  |  |  | 3305.56 |  |  |  |  |  | 0
14300 | DFG Corp | 81641 | 2020-02-19 00:00:00 | 2020-02-19 00:00:00 | 48647 | 4141.18 | 0 | 0 | 4141.18 |  |  |  |  |  | 4141.18
 |  | 81720 | 2020-03-18 00:00:00 | 2020-03-18 00:00:00 | 48154 | 111438.26 | 0 | 0 | 111438.26
Customer total |  | PH |  |  | Fax |  |  |  | 115579.44
Spreadsheet: 824560d1680671452-transferring-data-from-other-sheets-to-main-sheet-sample
Sheet: Dashboard

 |  |  |  | delivery # / performance [m³/min]
Task ID | Start | End | Volume [m³] | 1 | 2 | 3 | 4
T1
T2
T3
T4
T5
Spreadsheet: 779883d1652172653-need-help-with-timesheet-formulas-employee-timesheet
Sheet: Copy of Copy of may 1-15

pay ;period
EMPLOYEE NAME | TIME IN | TIME OUT | GRACE PERIOD | TOTAL WORKED HOURS | REGULAR HOURS | MINUTES/HOURS FOR DEDUCTION | TOTAL WORKED HOURS PLUS LUNCH TIME | TOTAL OVERTIME
name 1 | 08:00:00 | 17:00:00 | 0 |  | 09:00:00
name 2 | 08:11:00 | 17:00:00 | 0:10:00 |  | 09:00:00
name 3 | 10:01:00 | 17:00:00 | 0:10:00 |  | 09:00:00
name 4 | 12:01:00 | 17:00:00 | 0:10:00 |  | 09:00:00
name 5 | 07:45:00 | 16:55:00 | 0:10:00 |  | 09:00:00
name 6 | 07:30:00 | 17:15:00 | 0:10:00 |  | 09:00:00
name 7 | 08:00:00 | 17:15:00 | 0 |  | 09:00:00
 |  |  |  |  |  | CONDITIONS:
 |  |  |  |  |  | > Work schedule is 8 AM - 5 PM (8 hours worked, 1 hour for breaktime)
 |  |  |  |  |  | > Grace period for time in is 10 minutes. (If someone timed in at around 8:10 AM, he/she is not considered as late)
 |  |  |  |  |  | > Late is 8:11 AM to 10 AM
 |  |  |  |  |  | > Half day is considered if timed in 10:01 AM (but should punched out by 5:00 PM)
 |  |  |  |  |  | > Undertime if out between 3:01 PM - 4:49 PM, in 8:01 AM - 8:10 AM timed in
 |  |  |  |  |  | > Saturday is only until 4:30
 |  |  |  |  |  |  | work sched 8-5
On time all | 08:00:00 | 17:00:00 |  |  |  |  | conditions:
Late, out at 5 | 08:10:00 | 17:00:00 |  |  |  |  | late is 8:11 to 10 - 5
Late after 10, out at 5 | 10:01:00 | 17:00:00 |  |  |  |  | half day if 1001 - 5
In after 12, out at 5 | 12:01:00 | 17:00:00 |  |  |  |  | ut if out bet 301-449, in 801-810
In Early, Out bet 3-449 | 07:45:00 | 16:55:00 |  |  |  |  | no flexi
Early, Out after 5 | 07:30:00 | 17:15:00 |  |  |  |  | no ot
On time, out after 5 | 08:00:00 | 17:15:00 |  |  |  |  | grace period is 10 mins
 |  |  |  |  |  |  | saturday is only until 4:30
 |  |  |  |  |  | 09:00:00
On time all | 08:00:00 | 17:00:00 |  |  |  | 09:00:00 | how to encode the hours without typing colon
Late, out at 5 | 08:11:00 | 17:00:00 |  |  |  | 08:50:00
Late after 10, out at 5 | 10:01:00 | 17:00:00 |  |  |  | 06:59:00
In after 12, out at 5 | 12:01:00 | 17:00:00 |  |  |  | 04:59:00
In Early, Out bet 3-449 | 07:45:00 | 16:55:00 |  |  |  | 09:10:00
Early, Out after 5 | 07:30:00 | 17:15:00 |  |  |  | 09:45:00
On time, out after 5 | 08:00:00 | 17:15:00 |  |  |  | 09:15:00
Spreadsheet: kate_symes__18943__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.89 | 1432
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
Spreadsheet: jason_wolfe__13349__Matrix032701
Sheet: NORTHEAST REGION (2)

Pipeline | Logistics/Primary | Ext. | Logistics/Secondary | Ext. | Deal Validation/EOL | Ext. | Deal Validation/Telephonic | Ext. | Vol. Control/Primary | Ext.
Alabama Tennessee | [NAME] | 37086 | [NAME] | 34210 | [NAME] | 33222 | [NAME] | 33048 | N/A
Algonquin | [NAME] | 37679 | [NAME] | 31921 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 58963
Central Texas Gathering System | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 34780
Columbia Gas of Kentucky | [NAME] | 35610 | [NAME] | 33893 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31801
Columbia Gas Transmission | [NAME] | 35610 | [NAME] | 33893 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31801
Columbia Gulf | [NAME] | 36796 | [NAME] | 37086 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31801
Consolidated Natural Gas | [NAME] | 37519 | [NAME] | 35610 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 37118
East Ohio Gas | [NAME] | 35610 | [NAME] | 33893 | [NAME] | 33222 | [NAME] | 33048 | N/A
East Tennessee | [NAME] | 37086 | [NAME] | 34210 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 35195
EGSI (Exxon) | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | N/A
Equitran | [NAME] | 37679 | [NAME] | 31921 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 37516
[NAME] | [NAME] | 37086 | [NAME] | 34210 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 37118
Iroquois | [NAME] | 37519 | [NAME] | 35610 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 37516
Leviathan Gas | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | N/A
National Fuel | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31582
Olympic Pipeline | [NAME] | 35610 | [NAME] | 33893 | [NAME] | 33222 | [NAME] | 33048 | N/A
Tennessee Gas | [NAME] | 37086 | [NAME] | 34210 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 35195
Tennessee River Intrastate | [NAME] | 37086 | [NAME] | 34210 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31582
Texas Eastern | [NAME] | 37679 | [NAME] | 31921 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 31582
Transco | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 58963
Transco Louisiana Intrastate | [NAME] | 31901 | [NAME] | 53783 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 58963
Venice Gas Gathering System | [NAME] | 36796 | [NAME] | 37086 | [NAME] | 33222 | [NAME] | 33048 | [NAME] | 37516
Spreadsheet: 716282d1612150901-annual-due-date-conditional-formatting-icon-set-project-management-sheet
Sheet: Commenced-ACR

No. | Ref. | Details | Annual Report  Due Date | Assigned to
1 | [NAME] | Caloundra, Queensland | 2021-04-14 00:00:00 | <-------- | need to be updated every year
2 | [NAME] | Greenbank, Queensland | 2021-12-06 00:00:00 | <-------- | need to be updated every year
3 | [NAME] | Ipswich Queensland | 2021-09-23 00:00:00 | <-------- | need to be updated every year
4 | [NAME] | Springfield, Queensland | 2021-01-16 00:00:00 | <-------- | need to be updated every year
Spreadsheet: 31f660e5-e661-48d3-ba70-278020b5af88
Sheet: Sheet1

Simultaneous polydrug use among adults aged 16 to 59 - Drug Misuse Declared 2011/12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Sheet | Title | Period covered | National Statistics | Previous publication | Last updated
P.01 | Composition of the most recent incidents of drug use in the last year among 16 to 59 year olds, 2010/11 and 2011/12 Crime Survey for England and Wales | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.02 | Proportion of cases of single and simultaneous polydrug use, overall and simultaneous use with cannabis, powder cocaine, ecstasy and amphetamines, by drug, 2010/11 and 2011/12 Crime Survey for England and Wales | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.03 | Proportion of cases of simultaneous polydrug use in which each combination of two drugs was used, 2010/11 and 2011/12 Crime Survey for England and Wales | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.04 | Composition of most recent incidents of drug use, by drug, 2010/11 and 2011/12 Crime Survey for England and Wales | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.05 | Proportion of the most recent incidents of drug use where alcohol was also used and where any other substance was also used, by drug, 2010/11 and 2011/12 Crime Survey for England and Wales | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.06 | Proportion of 16 to 59 year olds having specified personal and behavioural characteristics, by most recent type of drug use, 2010/11 and 2011/12 CSEW | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
P.07 | Proportion of 16 to 59 year olds having specified household and area characteristics, by most recent type of drug use, 2010/11 and 2011/12 CSEW | 2010/11-2011/12 | Yes |  | 2012-09-27 00:00:00
Spreadsheet: 698048d1601706492-extract-non-zero-list-of-values-containing-formula-yo
Sheet: Sheet1

INPUT |  |  |  |  | SUM IF FUNC |  |  |  | EXPECTED OUTPUT
B | 1 |  |  |  | A |  |  |  | B | 11
B | 2 |  |  |  | B |  |  |  | C | 12
C | 3 |  |  |  | C |  |  |  | D | 4
D | 4 |  |  |  | D |  |  |  | E | 12
E | 5 |  |  |  | E |  |  |  | F | 6
F | 6 |  |  |  | F
E | 7 |  |  |  | G
B | 8 |  |  |  | H
C | 9
Spreadsheet: 773115d1647622002-help-needed-with-returning-1st-col-values-based-on-adjacent-array-book-5
Sheet: Sheet1

 |  | TAG | ROUTES
 |  |  |  |  |  |  |  |  | I want to auto generate a list with no spaces or blanks that results in this below…
AA |  | 101 | AA | GG | HH | EE
 |  | 102 | AC | AD | EE | FA |  |  | 101
 |  | 101 | EH | AA | AB | AC |  |  | 101
 |  | 105 | AC | FF | GG | AE |  |  | 104
 |  | 104 | AD | AB | AA | AE |  |  | 102
 |  | 101 | FA | TE | AD | TQ
 |  | 102 | GG | TE | AB | AA |  |  | because I search for any row that has the cell AA and then return the 1st column's value for each
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 6

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-27 00:00:00 |  |  |  | 80057
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN43779 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-27 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
4 4 4 4 |  | 425963 60MATERIAL 435208 20MATERIAL |  | RTNR, BRG CAP, DS INS IMP CYL 66 SV+ Material Surcharge RETAINER, BELT DRIVE PULLEY, FOL Material Surcharge |  |  |  |  |  |  |  | 94.00 60.00 62.00 20.00 |  |  |  | 376.00 240.00 248.00 80.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $944.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 944
Spreadsheet: 40421d1238736386-populate-using-sumproduct-or-array-sample
Sheet: Record

 | task: POPULATE THE LOG SHEET WITH THE DATA FROM THE RECORD SHEET
 | (as per example [NAME])
 | (note weird European date notation)
 | Holiday Record
 |  | Start | End | Type
 | [NAME] | 2009-01-01 00:00:00 | 2009-01-05 00:00:00 | AH
 | [NAME] | 2009-02-02 00:00:00 | 2009-02-15 00:00:00 | AH
 | [NAME] | 2009-03-04 00:00:00 | 2009-03-18 00:00:00 | PH
 | [NAME] | 2009-01-17 00:00:00 | 2009-01-21 00:00:00 | PH
 | [NAME] | 2009-03-14 00:00:00 | 2009-03-17 00:00:00 | PH
 | [NAME] | 2009-02-02 00:00:00 | 2009-03-06 00:00:00 | AH
 | [NAME] | 2009-01-27 00:00:00 | 2009-02-02 00:00:00 | AH
Spreadsheet: 165578d1341281787-dealing-with-student-grades-2012-2-fungus-
Sheet: student info (print)

 |  |  | 학부 (Dept) | 학년 | 학본 | 이름 | English name | E-Mail | 전화번호
 |  | 1