tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148209d1333249858-attempting-to-extract-data-from-a-report-example-data
Sheet: Extracted data

Name | Check-in | Check-out | Voucher | Folio | Room & Tax
Xx, Xxxxxxxx | 2012-03-20 00:00:00 | 2012-03-24 00:00:00 | 000000000 | 334849 | 664.8 | <- this should sum anything beginning with "room" "city" or "state"
Xxxxxxxx, [NAME] | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 272776429 | 336900 | 163.15
Xxxx, [NAME] | 2012-03-21 00:00:00 | 2012-03-24 00:00:00 | 273005489 | 337126 | 536.28
etc | etc | etc | etc | etc | etc
Spreadsheet: 691105d1597477651-repetitive-cell-in-vlookup-mani-copy
Sheet: Sheet1

Table 1
PR | PO QNY | PO | value
10074943 | 30 | [PHONE] | ?
10074943 | 20 | [PHONE] | ?
10102331 | 50 | [PHONE] | ?
10102331 | 40 | [PHONE] | ?
10102331 | 60 | [PHONE] | ?
Table 2
PO | PO QNY | value
[PHONE] | 40 | 0.068
[PHONE] | 50 | 0.024
[PHONE] | 20 | 5
[PHONE] | 30 | 0
[PHONE] | 60 | 0
Spreadsheet: 111822d1308102973-using-isblank-helpforumexample
Sheet: Sample Data 3

 | Program Name | Minimum Investment | Performance Fee | Inception Date | Assets Traded | Highest Month | Lowest Month | Percent Winning Months | Average Monthly ROI | Annualized ROI | Standard Deviation
 | D1 | 15000 | 0.35 | 2000-01-01 00:00:00 | Spot Currencies | 0.158 | -0.039 | 0.6842105263157895 | -0.00125 | -0.015 | 0.04484898796176875
Year | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec | Total
2008
2009 |  |  |  | -0.035 | 0.028 | 0.01 | 0.028 | 0.005 | 0.022 | 0.017 | -0.024 | -0.037
2010 | 0.026 | 0.008 | 0.022 | -0.003 | -0.008 | -0.033 | -0.007 | 0.033 | 0.011 | 0.017 | -0.014 | 0.001
2011 | 0.005 | -0.039
Spreadsheet: 164969d1340976271-4-quadrant-xy-chart-want-the-cross-hairs-of-my-chart-to-be-1-1-instead-of-0-0-easy-nope-axis1
Sheet: Sheet1

y | x
0.09941843250829474 | 3.83147111606708
1.24184650273178 | -2.470031736954086
1.085397645026398 | 1.27669947965467
3.287434410410977 | -3.665419465035482
-4.026638351071656 | -1.570342052045699
-2.607523909759313 | -0.4951825270236532
3.375181192132116 | 0.8055716546410507 |  |  |  |  |  |  |  |  |  | Steps
4.018756467857606 | 4.898152944048468 |  |  |  |  |  |  |  |  |  | Right click axis > format Axis > Axis options
-2.986577943203406 | 2.961396802929961 |  |  |  |  |  |  |  |  |  | Axis value, set to 1
Spreadsheet: 841094d1693344776-need-to-populate-a-cell-based-on-the-contents-of-a-dropdown-cell-excel-question-sample
Sheet: DAR

Status | DAR Number | Submitter | Date | USER 1 | USER 2 | Department | Fund | Source Code | Function | Purpose | Project | Activity | Vendor | Amount | Form Type | PS ID | Description | Supporting Docs | Supporting Docs2 | Reconciliation Comments
 |  |  |  |  | ADOSP |  |  |  |  | 20003
 |  |  |  |  | DSPRO |  |  |  |  | 20009
 |  |  |  |  | AGSPE |  |  |  |  | 20026
 |  |  |  |  | PRS&S |  |  |  |  | 20022
Spreadsheet: 211056d1359645268-help-row-into-column-another-sheet-dee2_version1
Sheet: ENG

Sl.No | Name | FA(a) | FA(b) | FA(a+b) | SA
1 |  | 10 | 10 | 20 | 50
2 |  | 1 | 2 |  | 46
3 |  | 12 | 4 | 7 | 11
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Spreadsheet: 1981a528-af59-4631-901f-5eabef7711a7
Sheet: Fall.Spring.ActionForm

 | ALCORN STATE UNIVERSITY
 | FALL & SPRING
 | ADJUNCT & OVERLOAD ASSIGNMENT ACTION FORM
 | This form is submitted to request a one time payment to existing faculty members/overload, *RECURRING adjunct faculty members,
 | and staff members/2nd assignment for classes taught during the Fall or Spring Semester.  Payment will be made at the close
 | of the applicable semester.
 | NOTE: Adjunct Faculty Members who are ORIGINAL APPOINTLENTS to the university, RECENTLY RETIRED, or need to RENEW
 | after a break in service that extends beyond 1 year are NOT included on this form.  A PAF is required by Human Resources.
 | DEPARTMENT |  |  |  |  |  | DATE:
 | CHECK ONE: |  |  | FALL |  | SPRING
 | ADJUNCT ORGANIZATION CODE:
 | COMMENTS:
 |  | ID NUMBER |  | FACULTY OR STAFF MEMBER |  |  |  | AMOUNT DUE
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 |  |  |  |  |  | TOTAL
 |  |  |  |  |  | Budget Office
 | Chairperson |  |  |  |  |  | Date:
 | [NAME] |  |  |  |  |  | Date:
 | Area Vice President |  |  |  |  |  | Date:
Spreadsheet: 847208d1698245639-lookup-and-match-a-number-to-a-start-and-end-sequence-column-sequence-match-aligw
Sheet: Sheet2

[NAME]
115848
129389
138225
138110
138635
138743
138756
138765
138810
138815
138777
138901
138799
138776
129223
154334
138634
138686
138813
Spreadsheet: 118914d1314095552-wind-shear-calculation-windshearlaw
Sheet: Sheet2

Calculation of Wind Shear Law
Height above ground level：z | 5 | m |  | Wind Shear - Power | 11.0756634324829
Roughness length：z0 | 0.5 | m
Reference height：zref | 3 | m
Reference speed：Vref | 10 | m/s
Shear exponent：α | 0.2 |  |  | Wind Shear - Log | 12.85097208938469
 | Height above ground level：z | Power Formula | [NAME]
Wind Shear - (Power & Log) | 0 | 0 | 0
 | 1 | 8.027415617602307 | 3.868528072345416
 | 2 | 9.221079114817277 | 7.737056144690832
 | 3 | 10 | 10
 | 4 | 10.59223841048812 | 11.60558421703625
 | 5 | 11.0756634324829 | 12.85097208938469
 | 6 | 11.48698354997035 | 13.86852807234542
 | 7 | 11.84664452542244 | 14.72885939736233
 | 8 | 12.16728683786411 | 15.47411228938166
 | 9 | 12.45730939615517 | 16.13147192765458
 | 10 | 12.72259636539392 | 16.7195001617301
 | 11 | 12.96744116109658 | 17.25143640340314
 | 12 | 13.19507910772894 | 17.73705614469083
 | 13 | 13.40801291208457 | 18.18378300199619
 | 14 | 13.60822107858739 | 18.59738746970775
 | 15 | 13.79729661461215 | 18.98244401703927
 | 16 | 13.97654237543158 | 19.34264036172708
 | 17 | 14.14703843171982 | 19.68099281839111
 | 18 | 14.30969081105255 | 20
 | 19 | 14.46526749888148 | 20.30175490739039
 | 20 | 14.61442551621925 | 20.58802823407552
Spreadsheet: 488734d1478798479-template-to-calculate-monthly-reduction-by-fixed-percentage-monthly-reduction
Sheet: Folha1

 | 100 | 5
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 795563d1662749136-named-range-works-with-offset-but-not-with-index-small-example
Sheet: Inspection Data

 |  |  |  |  |  |  |  |  |  |  |  | Currenly, no inspection data from the year of 2021 is included
filtered by changing the start and end dates, or by filtering the CPN or  other columns - either one column at a time or  multiple columns at once. |  |  |  |  |  |  |  |  |  |  |  | Currently, NC data only exists for Jan. to Aug. of 2022
CPN |  | Inspection-Data Date Range  >>>> | Start Date --> | 2022-01-31 00:00:00 |  | 2022-01-31 00:00:00 | <--- End Date
 | Part Description | Vendor | QC Log#  (aka Lot #) | Date Insp | Qty. Rcv. | Inspector | QC Proc. | Qty. Insp. | Qty. Rej. | Rej. Location | NC Code Description | Reject Reason
Spreadsheet: drew_fossum__8684__Scott exp 11-16-00
Sheet: Meals and Ent Sup

Employee Expense Report
Meals and Entertainment Supplement |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  |  | EMPLOYEE NUMBER
MEALS AND ENTERTAINMENT - Enter the cost of all meals (including food charges from hotel receipts) and entertainment.  Attach guest list for entertainment expense.  Meal: B = Breakfast,
L = Lunch, D = Dinner, R = Refreshments, T = Travel Status.  Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date | Meal |  | Location and Business Purpose |  |  |  | Guests |  |  | Cost/Qty | Rate | $ [NAME]
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Tr Ptr |  | Cost Center                           WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 768364d1644937593-trying-to-look-up-and-filter-data-example
Sheet: K ABV

ABV
Component name | Result text
Spreadsheet: 228c2693-7d82-43a3-8c18-8263ed1ae384
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
EAG | Test | EAG | [NAME], Serum | Hepatitis Be Ag, S | Chemiluminescence Immunoassay (CIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL  Collection Instructions: Spin down and immediately remove serum from clot.  Additional Information: 1. Date of draw is required. 2. If ordered with HBVQU/88634 Hepatitis B Virus DNA Detection and Quantification by Real-Time PCR, Serum; send separate vials. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Red top | Negative See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday | 1 day | 2 days | 1 | 87350 |  |  |  |  | Rochester
EAG | [NAME] | SST | Serum SST |  |  |  | Frozen
EAG | Result | EAG | Hepatitis Be Ag, S | Hepatitis Be Ag, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13954-3 | Hepatitis B virus little e Ag:ACnc:Pt:Ser:Ord:EIA
Spreadsheet: 490510d1479903142-problem-analysing-data-problem
Sheet: Sheet2

Title Name | Category | Sub Category | [NAME] count Store Count | New York Store Count | Total Store Count | Average sale
b | CRAFT | COLOURING | 374 | 465 | 839 | 5.066030989272944
e | CRAFT | COLOURING | 361 | 218 | 579 | 4.248630264381559
d | CRAFT | COLOURING | 359 | 218 | 577 | 4.251177176376483
f | CRAFT | COLOURING | 234 | 111 | 345 | 1.869687848383501
i | CRAFT | COLOURING | 144 | 141 | 285 | 1.646491228070175
c | CRAFT | COLOURING | 144 | 114 | 258 | 4.591276088252832
h | PARTWORKS | COLOURING | 144 | 100 | 244 | 1.728770491803278
a | CRAFT | COLOURING | 111 | 114 | 225 | 5.521039316239317
j | CRAFT | COLOURING | 0 | 94 | 94 | 0.9703355155482816
g | CRAFT | COLOURING | 54 | 0 | 54 | 1.823119658119658
k | CRAFT | COLOURING | 0 | 0 | 0 | 0
l | CRAFT | COLOURING | 0 | 0 | 0 | 0
Spreadsheet: 03be3a0c-2407-40fa-b9b5-97998cdbe281
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3715 | 9817 | [NAME] | Dmitrieva | RUS | 0 | 00:23:05 | 00:00:00 | [NAME] | 00:00:00 | 00:39:45 | 1 | [NAME]
3715 | 21503 | Margaryta | Zubyak | UKR | 0 | 00:23:04 | 00:00:00 | 01:26:24 | 00:00:00 | 00:38:55 | 2 | 02:28:25
3715 | 21501 | [NAME] | Kamburova | BUL | 0 | 00:24:14 | 00:00:00 | 01:31:01 | 00:00:00 | 00:41:28 | 3 | 02:36:43
3715 | 21502 | Serap | Tok | TUR | 0 | 00:27:49 | 00:00:00 | [NAME] | 00:00:00 | 00:48:32 | 4 | 02:38:58
3715 | 9838 | [NAME] | [NAME] | TUR | 0 | 00:27:54 | 00:00:00 | [NAME] | 00:00:00 | 00:47:04 | 5 | 02:44:17
3715 | 5495 | Anna | Ivanova | RUS | 0 | 00:23:01 | 00:00:00 | 01:18:26 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 832880d1686651841-excel-chart-hide-zeros-sample
Sheet: Sheet1

 | Unit/Department | Severity Level 1- Negligible | Severity Level 2 - Minor Harm/Damage | Severity Level 3 -  Moderate Harm/Damage | Severity Level 4 - Serious Harm/Damage | Near Miss
 | BONE & JOINT CENTER | 1 | 0 | 0 | 0 | 0
 | HBKMC BUILDING 329 | 0 | 0 | 0 | 0 | 0
 | INTERNAL MEDICINE CLINIC | 0 | 0 | 0 | 0 | 0
 | OPD LEVEL 1 | 2 | 2 | 0 | 0 | 0
 | OPD LEVEL 2 | 9 | 1 | 0 | 0 | 0
 | OPD LEVEL 3 | 0 | 0 | 1 | 0 | 0
 | OPD LEVEL 4 | 1 | 0 | 0 | 0 | 0
 | OUTPATIENT DEPARTMENT | 1 | 0 | 1 | 0 | 0
 | PEDIATRIC | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 2 | 0 | 0 | 0
 | QATAR METABOLIC INSTITUTE | 1 | 0 | 0 | 0 | 0
 | STAFF MEDICAL CENTER | 0 | 0 | 0 | 1 | 0
 | SURGICAL SPECIALTY CENTER - OUTPATIENT DEPARTMENT | 5 | 3 | 1 | 0 | 0
Spreadsheet: 90213d1289963246-populating-cells-with-top-ten-values-from-a-list-book1
Sheet: Sheet1

score | name | standing
19 | [NAME] | 1 | [NAME] | 252
125 | amber | 2 | maria | 251
98 | [NAME] | 3 | ryley | 222
25 | [NAME] | 4 | [NAME] | 158
58 | danny | 5 | [NAME] | 133
63 | greg | 6 | amber | 125
52 | [NAME] | 7 | [NAME] | 120
14 | [NAME] | 8 | [NAME] | 98
15 | [NAME] | 9 | greg | 63
30 | [NAME] | 10 | danny | 58
251 | maria
120 | [NAME]
252 | [NAME]
222 | ryley
158 | [NAME]
133 | [NAME]
22 | wayne
Spreadsheet: 683225d1592566827-time-card-calculation-time_card2c
Sheet: Regular Employee 

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0700 |  | 30 | 1530
 | 0714 |  | 30 | 1530
 | 0715 |  | 30 | 1530
 | 0729 |  | 30 | 1530
 | 0700 |  | 30 | 1532
 |  |  |  | Total  Hrs.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Total  Hrs.
Spreadsheet: 861337d1709222509-gantt-chart-date-line-bar-chart-date-line
Sheet: Sheet1

Task | Start Date | Duration | End Date | Complete | Days Complete | Days Remaining | Today
Task1 | 2024-02-12 00:00:00 | 10 |  | 1 | 10 | 0
Task 2 | 2024-02-05 00:00:00 | 21 |  | 0.95 | 18 | 3
Task 3 | 2024-02-21 00:00:00 | 3
Test | 2024-02-29 00:00:00 | 40 |  | 0 | 0 | 40
Other Task | 2024-02-19 00:00:00 | 15
More of that | 2024-03-11 00:00:00 | 10
Number 3 | 2024-03-25 00:00:00 | 5
Do this | 2024-03-25 00:00:00 | 20
And That | 2024-04-23 00:00:00 | 3
 |  |  |  |  |  |  |  |  | Complete | Calculate percentage.
 |  |  |  |  |  |  |  |  | Days Complete | Calculate how many days are left. If TODAY is before End Date, give the days. If it is equal or after, put 0.
 |  |  |  |  |  |  |  |  | Days Remaining | Duration-Complete
 |  |  |  |  |  |  |  |  | Source | https://www.officetooltips.com/excel_2016/tips/glossy_gantt_chart_with_a_vertical_line.html
Spreadsheet: 747019d1631184596-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-compare-3-lists-for-all-and-neither-match
Sheet: Summary v1

Common 3 | Total | Raw Sales | Total | this method: | https://www.get-digital-help.com/filter-common-values-from-three-columns-in-excel/
 |  |  |  |  | requires custom formatting on column C to remove a redundant "0" at the bottom of results
Spreadsheet: 187838d1350592578-multiple-look-up-multile-lookup-bithurocks
Sheet: Data 1

ID | Cust_Name | [NAME]
100-1 | A | 123_ABCD
100-1 | A | 456_DEFG
100-1 | A | 789_GHIJ
100-1 | A | 000_JKLM
200-2 | B | 111_PPPP
300-3 | C | 999_CCCC
300-3 | C | 999_DDDD
Spreadsheet: 86e2e1f5-1454-4bfd-8cf9-0b0020a6756f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4437 | 9941 | Sophie | Delemer | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:14:42
4437 | 15247 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:15:40
4437 | 15248 | [NAME] | Hubbard | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:17:41
4437 | 26715 | [NAME] | Vivanco | PER | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:18:44
4437 | 14216 | Suzanne | Nielsen | DEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:19:21
Spreadsheet: 0589e894-8918-49f3-ae90-d2a9f5020e19
Sheet: SCC Cover Page

Grant Code:  3192
District Code: |  | Charter [NAME] must enter the district/CSI code
District: Name: | 0
Charter School: | 0 | and the Charter School Name
Report:
Number:
Date:
Person completing this information |  | Charter School Contact:
Name:
Title:
Phone No.:
E-mail:
Submit this file to this e-mail address: | [EMAIL]
Grants Fiscal Staff Contact | Phone No.      E-mail Address
Marti Rodriguez | [PHONE]  [EMAIL]
v1415v1
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7 | 6926 | 6031 |  |  | 1149 | 1150 | 1444 | 1283
8 | 6932 | 6031 |  |  | 1096 | 1150 | 1417 | 1283
9 | 6825 | 6031 |  |  | 1073 | 1150 | 1479 | 1283
10 | 7236 | 6031 |  |  | 1025 | 1150 | 1307 | 1283
11 | 7145 | 6031 |  |  | 1044 | 1150 | 1444 | 1283
12 | 7121 | 6031 |  |  | 1011 | 1150 | 1426 | 1283
13 | 7497 | 6031 |  |  | 1008 | 1150 | 1419 | 1283
14 | 5169 | 6031 |  |  | 956 | 1150 | 1409 | 1283
15 | 7298 | 6531 |  |  | 1098 | 1150 | 1394 | 1283
16 | 4507 | 6531 |  |  | 1042 | 1150 | 1404 | 1283
17 | 5627 | 6513 |  |  | 1034 | 1150 | 1409 | 1283
18 | 6389 | 6531 |  |  | 1004 | 1150 | 1399 | 1283
19 | 6016 | 6531 |  |  | 877 | 1150 | 1388 | 1283
20 | 7602 | 6531 |  |  | 1064 | 1150 | 1365 | 1283
21 | 7180 | 6531 |  |  | 965 | 1150 | 1220 | 1283
22 | 6993 | 6531 |  |  | 1003 | 1150 | 1451 | 1283
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 372841.88
2001-08-22 00:00:00
CBS Volume
 |  |  | 146405
Spreadsheet: 66762d1267457757-how-to-create-drop-down-boxes-book1
Sheet: Sheet1

 | 1    -    All relevant Insurances in place: |  |  | 2  - |  |  |  |  |  |  |  | 3    - |  |  |  |  |  |  |  | 4    -
 | Days to expiry: | 60 | 2010-04-30 00:00:00
 | Public liability - contractual |  |  | Date  due - |  |  | 2010-04-01 00:00:00 |  |  |  |  | [NAME] |  |  | 2012-04-30 00:00:00
 | Product liability - contractual |  |  | level  assigned - |  |  | Mandatory / Minimum |  |  |  |  | Days to expiry - |  |  | 791
 | Employers liability - contractual
 | Professional indemnity - contractual |  |  | 6    - |  |  |  |  |  |  |  | 7    -
 | Others - non-contractual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8    -    :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Screening Level (0-5) -
 | 5    - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample or Self Cert testing -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next Self Cert due -
Spreadsheet: 600377d1543655468-formula-to-create-table-or-list-based-on-team-members-sample-2-
Sheet: Team

 |  | desired
 |  | [NAME] | 2018-11-26 00:00:00 | 2018-12-03 00:00:00 | 2018-12-10 00:00:00
 |  | Lyn
Spreadsheet: 770985d1646370070-vlookup-returns-n-a-possibly-searching-function-instead-of-result-spelling-ages-test-sheet
Sheet: Results

NAME | DOB | AGE AT TEST | SCORE (A) | Spelling Age (A) | Average Score | AGE AT TEST | SCORE (B) | Spelling Age (B) |  | Growth
DATE OF TEST | 2022-02-07 00:00:00 |  |  |  |  | DATE OF TEST:
 | 2010-01-01 00:00:00 |  | 61
 | 2009-11-27 00:00:00 |  | 60
 | 2009-10-05 00:00:00 |  | 56
 | 2009-06-20 00:00:00 |  | 56
 | 2010-03-29 00:00:00 |  | 54
 | 2009-06-10 00:00:00 |  | 53
 | 2010-01-04 00:00:00 |  | 53
 | 2010-04-21 00:00:00 |  | 52
 | 2009-08-11 00:00:00 |  | 52
 | 2009-07-22 00:00:00 |  | 50
 | 2008-10-29 00:00:00 |  | 49
 | 2010-04-30 00:00:00 |  | 49
 | 2009-06-05 00:00:00 |  | 46
 | 2010-03-13 00:00:00 |  | 45
 | 2009-05-30 00:00:00 |  | 45
 | 2009-12-29 00:00:00 |  | 44
 | 2009-11-12 00:00:00 |  | 41
 | 2009-08-11 00:00:00 |  | 38
 | 2009-06-27 00:00:00 |  | 38
 | 2009-11-17 00:00:00 |  | 36
Spreadsheet: 7fc4328f-a42d-483e-b55b-748893221663
Sheet: REVISIONS

WOODWORKING EMISSIONS CALCULATOR REVISION C  JULY 2007 - REVISION SCREEN
 |  |  | Instructions:  Enter emission source / facility data on the "INPUT" tab/screen.  The air emission results and summary of input data are viewed / printed on the "OUTPUT" tab/screen.  The different tabs are on the bottom of this screen.
 |  |  | This spreadsheet is for your use only and should be used with caution. DENR does not guarantee the accuracy of the information contained.  This spreadsheet is subject to continual revision and updating.  It is your responsibility to be aware of the most current information available.  DENR is not responsible for errors or omissions that may be contained herein.
 | Version | Date | Author | Revisions
 | 5b-1.0 | 1997-06-18 00:00:00 | [NAME] | 1) switched voc emission factors from steam-heated and direct-fired kilns
 | (A) |  | Pendola | 2)  changed VOC emission factor for softwood/steam from 3.1 to 3.04 per Huddleston memo
 | B | 2002-07-31 00:00:00 | [NAME] | 1.  REFORMATED AND PUT IN EXCEL, SAME WOODWORKING FACTORS RETAINED.  PM2.5 ESTIMATED.
 |  |  | Davey | ADDED POTENTIAL EMISSIONS CALCULATIONS; KILN FACTORS UPDATED
 | C | 2007-07-09 00:00:00 | [NAME] | Removed dry kiln references and created anew spreadsheet for dry kilns
 |  |  | Davey
Spreadsheet: 820654d1678215487-extract-numbers-between-symbols-calculate-and-join-numbers-extract-numbers-between-symbols
Sheet: Sheet1

 |  | Actual Output till date
 |  | Plant1 | 100
 |  | Plant2 | 300
 |  | Plant3
 |  | Plant4 | 200
 |  | Total:
 | (Total)Plant1+Plant2/Plant3/Plant4
Target | (2600)1000+500/700/400
Balance to against target (B9-Col.D data of each plant) | (2000)900+200/700/200
No. of balance working days | 249 |  | Converted B11 in to months @ 25 working days a month
Average required per month | (200.8)90.4+20.1/70.3/40.2
We have 4 plants at various locations.  Preparing a report of Target Vs. Actual , balance and average required per month
Need a formula for the yellow highlighted cells.  The challenge is to extract the numbers between the symbols and multiply with No. of months balance, etc.
Spreadsheet: 887535d1737755664-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Mar

 |  |  | 2026-03-02 00:00:00 | 2026-03-03 00:00:00 | 2026-03-04 00:00:00 | 2026-03-05 00:00:00 | 2026-03-06 00:00:00 | 2026-03-07 00:00:00
 |  |  | 2026-03-09 00:00:00 | 2026-03-10 00:00:00 | 2026-03-11 00:00:00 | 2026-03-12 00:00:00 | 2026-03-13 00:00:00 | 2026-03-14 00:00:00
 |  |  | 2026-03-16 00:00:00 | 2026-03-17 00:00:00 | 2026-03-18 00:00:00 | 2026-03-19 00:00:00 | 2026-03-20 00:00:00 | 2026-03-21 00:00:00
 |  |  | 2026-03-23 00:00:00 | 2026-03-24 00:00:00 | 2026-03-25 00:00:00 | 2026-03-26 00:00:00 | 2026-03-27 00:00:00 | 2026-03-28 00:00:00
 |  |  | 2026-03-30 00:00:00 | 2026-03-31 00:00:00 | 2026-04-01 00:00:00 | 2026-04-02 00:00:00 | 2026-04-03 00:00:00 | 2026-04-04 00:00:00
 |  |  | 2026-04-06 00:00:00 | Notes
Spreadsheet: 102631d1300597268-deciphering-a-number-and-placing-the-archived-number-workbook8
Sheet: Sheet2

700 | 007
008 | 008
900 | 009
101 | 011
120 | 120
130 | 031
410 | 014
150 | 150
601 | 601
710 | 017