tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123257d1317442920-data-fields-from-multiple-spreadsheets-abc-builders-1245-plank-road
Sheet: Sheet1

 | Customer Name: | ABC Builders
 | Job Name: | 1245 Plank road
Estimate | Sell Price: | 22000
 | Material Cost: | 7000
 | Labor Cost | 3000
 | Gross Margin | 0.32
Actuals
 | Material Cost | 6700
 | Labor Cost | 2800
 | Gross Margin | 0.37
Spreadsheet: 190373d1351625984-extract-a-time-from-a-cell-with-date-and-time-stamp-and-then-perform-calculations-excel-formula-workbook
Sheet: Sheet1

Event Start | Event End | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00
1900-01-01 10:00:00 | 1900-01-01 11:30:00 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 10:00:00 | 1900-01-01 11:30:00
1900-01-01 08:00:00 | 1900-01-01 11:00:00
1900-01-01 13:30:00 | 1900-01-01 15:30:00
I would appreciate your help to develop a formula that extracted the start and end times from cells in columns A and B and then in Columns C through U returned a positive value - a "1" - if the event was on at that time and a negative value - a "0" - if it was not. I have manually filled in the top row to demonstrate what I require a formula to do
Spreadsheet: 490798d1480083059-multiple-cell-lookup-storage-gk2
Sheet: PR

Material | Description | Qty on Hand | Reorder Point | Needs Ordered | PR#1 | PR#2 | Delivery Date | Qty Ordered | Notes
141699 | CUPS,FOAM PLASTIC,8 OZ | 60 | 86 | Order | 11101045 | 1234 | 2016-10-31 00:00:00 | 100 | LATE
Spreadsheet: 02604504-f727-4623-8a30-a0b966e699fe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 81. Value of Building Approved, Chain Volume Measures, Original - Northern Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total houses ;  New ; |  |  | Original | A590537T | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total other residential building ;  New ; |  |  | Original | A590538V | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A590539W | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590540F | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590541J | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590542K | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590543L | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 118891d1314083551-how-to-get-sum-of-deliveries-made-against-a-period-separated-by-months-sample
Sheet: Sheet2

Period
From | 2011-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item
To | 2011-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Item | A |  |  |  | I will be entering date limits in B2& B3 and will select an item in the list in B4. I need to get the result manully put in B7 to B18 automatically when I give the dates and [NAME] name. |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
Months | Quantity | Pending |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
Jan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
Feb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
Mar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
Apr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
May | 18000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
Jun | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
Aug |  |  |  |  | I am also interested when I selet an item, at the same time I should get the pending schedule.
Sep
Oct
Nov
Dec
Spreadsheet: 126566d1319746630-excel-2007-index-match-returns-0-pivotifandmatch1
Sheet: Archive

Date | Letter
2011-10-01 00:00:00 | a
2011-10-01 00:00:00 | b
2011-10-02 00:00:00 | c
2011-10-02 00:00:00 | a
2011-10-03 00:00:00 | d
2011-10-04 00:00:00 | c
2011-10-04 00:00:00 | a
2011-10-04 00:00:00 | b
2011-10-04 00:00:00 | e
2011-10-05 00:00:00 | a
2011-10-05 00:00:00 | c
2011-10-06 00:00:00 | e
2011-10-07 00:00:00 | a
2011-10-08 00:00:00 | d
2011-10-09 00:00:00 | b
2011-10-10 00:00:00 | c
2011-10-11 00:00:00 | b
2011-10-11 00:00:00 | a
2011-10-11 00:00:00 | d
2011-10-12 00:00:00 | e
2011-10-12 00:00:00 | a
2011-10-12 00:00:00 | d
2011-10-13 00:00:00 | c
2011-10-14 00:00:00 | a
2011-10-15 00:00:00 | d
2011-10-16 00:00:00 | a
2011-10-17 00:00:00 | d
2011-10-18 00:00:00 | a
2011-10-19 00:00:00 | d
2011-10-20 00:00:00 | a
2011-10-21 00:00:00 | b
2011-10-22 00:00:00 | c
2011-10-23 00:00:00 | c
Spreadsheet: 723181d1615553285-annual-pay-raise-formula-to-add-to-personnel-budget-costs-payroll-annual-raises-formula
Sheet: Personnel

 | Job Title | Employee Name | Status | Hire Date | Term Date | Annual Pay | FT or PT | [NAME] or Hourly | [NAME] |  | 2019-01-01 00:00:00
 | Art Director |  | Filled | 2018-07-15 00:00:00 | 2020-01-31 00:00:00 | 150000 | FT | Salary
 | Senior Marketing Manager |  | Filled | 2019-03-20 00:00:00 |  | 150000 | FT | Salary
 | VP Product |  | Filled | 2021-02-01 00:00:00 |  | 150000 | FT | Salary
 | Annual raises on anniversary date of hire: |  | 0.03
Spreadsheet: 702616d1604432735-need-formula-to-post-payments-with-different-dates-frequency-than-column-headers-date-range-issue
Sheet: CASH FLOW FORECAST

Each Payment= | 500
 | Year | 2019 | 2019 | 2019 | 2019 | 2019-2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020
 | Date: FROM | 2019-11-01 00:00:00
10 | TO Date
Pay Frequency | Start Date
Weekly | 2019-11-02 00:00:00
Bi-Weekly | 2019-11-02 00:00:00
Monthly | 2019-11-02 00:00:00
[NAME] | 2019-11-02 00:00:00
Quarterly | 2019-11-02 00:00:00
Spreadsheet: 175501d1345555170-check-if-a-cell-contains-a-part-of-the-other-cell-sample1-1-_conditional-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Prefix | tcn-
tcn-1 | 1 |  |  |  | tcn-1 | 1 |  |  | tcn-1 | 1
tcn-2 | 2 |  |  |  | tcn-2 | 2 |  |  | tcn-2 | 2
[NAME] | 3 |  |  |  | [NAME] | 3 |  |  | [NAME] | 3
tcn-4 | 8 |  |  |  | tcn-4 | 8 |  |  | tcn-4 | 8
tcn-5 | 9 |  |  |  | tcn-5 | 9 |  |  | tcn-5 | 9
tcn-6 | 11 |  |  |  | tcn-6 | 11 |  |  | tcn-6 | 11
tcn-7 | 16 |  | > |  | tcn-7 | 16 |  |  | tcn-7 | 16
tcn-8 | 21 |  |  |  | tcn-8 | 21 |  |  | tcn-8 | 21
tcn-9 | 34 |  |  |  | tcn-9 | 34 |  |  | tcn-9 | 34
tcn-10 | 44 |  |  |  | tcn-10 | 44 |  |  | tcn-10 | 44
tcn-11 | 47 |  |  |  | tcn-11 | 47 |  |  | tcn-11 | 47
tcn-12 | 55 |  |  |  | tcn-12 | 55 |  |  | tcn-12 | 55
tcn-13 | 58 |  |  |  | tcn-13 | 58 |  |  | tcn-13 | 58
Spreadsheet: 776949d1650016144-row-conditonal-formating-depending-on-cell-value-test-dashboard-3-etaf
Sheet: OVERVIEW 2

TYPE | (Tous)
PAYMENT | (Tous)
PÉRIODE | [NAME] | REVENUES TVAC
2023 | 3418 | 3418
Q1 | 3418 | 3418
2024 | 3418 | 3418
Q1 | 3418 | 3418
2025 | 4006 | 4006
Q1 | 4006 | 4006
2021 | 6290 | 6290
Q3 | 1790 | 1790
Q4 | 4500 | 4500
2022 | 8004.88 | 8004.88
Q1 | 4122.38 | 4122.38
Q2 | 3882.5 | 3882.5
TOTAL | 25136.88 | 25136.88
Spreadsheet: 888175d1738627592-removing-duplicate-information-not-so-simple-example_sample
Sheet: Sheet1

PIN | Name | Order |  | Unique | Duplicate
001400 | ROBINS, [NAME] | XLB1-225
001400 | ROBINS, [NAME] | XLB1-225
001400 | ROBINS, [NAME] | XLB1-225
002037 | MILLER, [NAME] | XLB2-226
002037 | MILLER, [NAME] | XLB2-226
002037 | MILLER, [NAME] | XLB2-226
002573 | [NAME], [NAME] Francies | XLB1-225
002573 | [NAME], [NAME] Francies | XLB1-225
002573 | [NAME], [NAME] Francies | XLB1-225
003880 | BUTLER, [NAME] | XLB1-225
003880 | BUTLER, [NAME] | XLB1-225
003880 | BUTLER, [NAME] | XLB1-225
006082 | EDWARDS, [NAME] | XLB2-226
006082 | EDWARDS, [NAME] | XLB2-226
006082 | EDWARDS, [NAME] | XLB2-226
006134 | [NAME], [NAME] | XLB1-225
006134 | [NAME], [NAME] | XLB1-225
006134 | [NAME], [NAME] | XLCC-128
006308 | MARTIN, [NAME] | XLB1-225
006308 | MARTIN, [NAME] | XLB1-225
006308 | MARTIN, [NAME] | XLB1-225
006308 | MARTIN, [NAME] | XLB1-225
006308 | MARTIN, [NAME] | XLB1-225
006308 | MARTIN, [NAME] | XLB1-225
009527 | GILLETT, [NAME] | XLB2-226
009527 | GILLETT, [NAME] | XLB2-226
009527 | GILLETT, [NAME] | XLB3-247
Spreadsheet: 857133d1706191624-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling-bsweet0us-
Sheet: Squad schedule 2

Squad 1 | 2024-01-12 00:00:00 |  | Squad 2 | 2024-01-13 00:00:00 |  | Squad 3 | 2024-01-14 00:00:00 |  | Squad 4 | 2024-01-15 00:00:00 |  | Squad 5 | 2024-01-16 00:00:00
Spreadsheet: 287109d1388655400-drop-lists-automatic-input-book2
Sheet: Sheet2

 | Week Start/End | 2014-01-01 00:00:00 | 2014-01-11 00:00:00 |  | TOTAL PURCHASES
 | BEVERAGES |  |  |  | #N/A
 | Week Start | Product  Reference | Supplier name | # [NAME] | Invoice Amount
 | 2014-01-01 00:00:00 |  |  | 2
 | 2014-01-02 00:00:00 |  |  | 2
 | 2014-01-03 00:00:00 |  |  | 2
 | 2014-01-04 00:00:00 |  |  | 2
 | 2014-01-05 00:00:00 |  |  | 2
 | 2014-01-06 00:00:00 |  |  | 2
 | 2014-01-07 00:00:00 |  |  | 2
 | 2014-01-08 00:00:00 |  |  | 2
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 12

Name | lbs | oz | Oz (total) | Points
 | 5 | 0
 | 0 | 0
 | 5 | 0
 | 4 | 10
 | 17 | 10
 | 8 | 1
 | 0 | 0
 | 9 | 0
 | 8 | 0
 | 1 | 0
 | 4 | 0
 | 15 | 10
 | 10 | 0
 | 0 | 0
 | 10 | 2
 | 45 | 5
 | 1 | 2
 | 3 | 3
Spreadsheet: 126299d1319624249-issue-with-setting-up-a-formula-with-more-than-one-condition-ge-report-august-2011-final-test
Sheet: Italy 2011

ITALY
GE Business | GE Sub-business | Matter Number | Matter Description | GE Contact | Office | S&S Contact | Status | Category of Work | Non S&S related sums billed from 01 January to 31 August 2011 (£) | S&S related sums billed from 01 January to 31 August 2011 (£) | Cumulative Total 2011 (£)
Commercial Finance | GE Real Estate Italia  Srl | 45239-8 | Miscellaneous Employment matters - Italy | [NAME], [NAME] | Milan | [NAME] | Ongoing | 2 | 0 | 0 | 0
Commercial Finance | GE Real Estate Italia  Srl | 45239-9 | New reporting lines | [NAME] | Milan | [NAME] | Ongoing | 2 | 0 | 0 | 0
Commercial Finance | GE Tip S.r.I | 68361-1 | Redundancy in Italy | [NAME] | Milan | [NAME] | Ongoing | 1 | 0 | 0 | 0
Corporate | GE Interantional Inc | 9304-51 | General Employment Advice | [NAME], [NAME] | Mian | [NAME] | Ongoing | 2 | 0 | 14021.59 | 14021.59
Corporate | GE International Inc | 9304-55 | [NAME] ([NAME]) | [NAME], [NAME] | Milan | [NAME] | Ongoing | 2 | 0 | 0 | 0
Corporate | GE [NAME] | 9251-7 | Split of consultancy agreements | Krisztian K Pannonhalmi | Milan | Davide Sportelli | Completed | 5 | 0 | 0 | 0
Corporate | GE International Inc | 9304-56 | Redundancy in GBS | Avril Cornu, Sonia Verenucci, [NAME] | Milan | [NAME] | Ongoing | 1 | 0 | 0 | 0
Industrial | GE Power Controls Italia SpA | 27620-5 | Mr Berta consultancy agreement | [NAME] | Milan | [NAME] | Completed | 6 | 0 | 0 | 0
NBC Universal | Pictures | 60968-3 | Reorganisation | [NAME] | Milan | [NAME] | Completed | 1 | 0 | 0 | 0
Industrial | GE Power Controls Italia SpA | 27620-6 | [NAME] | [NAME], [NAME] | Milan | [NAME] | Ongoing | 3 | 0 | 0 | 0
NBCUniversal International Limited | NBCUniversal International Limited | 73912-1 | Advice on reporting lines | [NAME] | Milan | [NAME] | Completed | 6 | 0 | 890.05 | 890.05
 |  |  |  |  |  |  |  |  | 0 | 14911.64 | 14911.64
Spreadsheet: 689678d1596584374-fill-range-of-cells-with-corresponding-data-this-example-b6
Sheet: Layout

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
A
B
C
D
E
F
G
H
Spreadsheet: 0f4f947e-b9e7-4dd2-8ebe-5fbfc92af89a
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 | City of Rio Rancho Department of Finance - Ambulance Billing Payment Plan Agreement | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32
Please complete all the information on this form as completely and accurately as possible by typing or using blue or black ink.  Please contact us at (505) 891-5010 with any questions.
Section I - Patient Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Patient Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Acct #
 |  |  |  |  |  |  | Last Name |  |  |  |  |  |  |  |  |  | First Name
Address:
 |  |  |  |  | Street |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | City/State |  |  |  |  |  |  |  |  | Zip
Phone #: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Mail:
Section II - Payment Information
For the patient number referenced above, my outstanding balance owed to the City of Rio Rancho is:
 |  |  |  | $
I hereby agree to submit monthly payments to the City in the amount of:
 |  |  |  | $ |  |  |  |  |  |  | (minimum $50.00)
due and payable to the City of Rio Rancho by the 15th day of each month beginning as of the date first written above and continuing until the balance is paid in full (the last payment may be less than $50.00).  I understand that should I fail to make a payment within ten days of its due date, this payment plan will terminate and I will immediately be responsible for paying any remaining balance in full.  The total balance must be paid in full within one year of the date first written above.
By signing below, I hereby acknowledge that I have read and agree to the terms of this Agreement.
Patient Signature:
(or legally authorized) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
Accepted by:
 |  |  |  |  |  |  |  |  | [NAME], EMS Billing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | [NAME], Manager |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
Please return this completed and signed form to: Attn: [NAME], [NAME], 3200 Civic Center Circle NE, Rio Rancho, NM  87144.  A fully signed copy will be returned to you.
Spreadsheet: 114980d1310637505-need-help-to-summing-sum
Sheet: Sheet1

A | B | C
1 | 800 | ab |  | 1 | 800 | Note: These are array formulas and should be confirmed thourgh Ctrl+shift+Enter
1 | 800 | bc |  | 2 | 900
1 | 800 | aa |  | 3 | 500
1 | 800 | aa
1 | 800 | fg
1 | 800 | aa
2 | 900 | ab |  |  | 2200
2 | 900 | dd
2 | 900 | ee
3 | 500 | ab
2 | 900 | ab
2 | 900 | ab
2 | 900 | ab
Spreadsheet: 47734d1246906906-dependent-drop-down-lists-dependentlists3
Sheet: Choices

On this page we use Validation List of |  |  |  |  |  | Sample Lists
Allow: =Animals
for both H5 and H19 versions. |  |  |  |  |  | Problematic - make a change in H5 and the following cells remain with now-incorrect values
 |  |  |  |  |  |  | Classes | Types | Animals
Then, the validation list for I5 uses an INDIRECT formula |  |  |  |  |  |  | Canine | Tigers | [NAME]
Allow:  =INDIRECT(H5)
so the word chosen becomes the active "list" and the animal
names are brought over. The same thing is used in the |  |  |  |  |  |  | NOTE: Problem if you make selections in the boxes above, and then go back and change an earlier box
validation list for J5: |  |  |  |  |  |  | it does not change the others, so you could end up with Canine - Tiger - Bald Eagle.
Allow:  =INDIRECT(I5)
This technique could go on indefinitely. |  |  |  |  |  |  | SOLUTION: A WorkSheet_change macro can be used to watch for changes in the earliest boxes and then
 |  |  |  |  |  |  | clear the previous made in later boxes that are now no longer valid.
The "LISTS" are on the next sheet.
 |  |  |  |  |  |  | Right-click on the sheetname tab and VIEW CODE to see the macro.
 |  |  |  |  |  | Better - change H19 and the following cells clear their values
 |  |  |  |  |  |  | Classes | Types | Animals
 |  |  |  |  |  |  | Canine | Terrier | Scottish
Spreadsheet: 755595d1636984467-formula-to-determine-if-customers-purchasing-special-packs-buy-full-pack-example-6-
Sheet: Sheet2

Count of Category | Manually Calculated Converted Buyer?
User ID | Converted to Regular Pack | Did Not Convert to Regular Pack | (blank) | Grand Total
57 |  |  | 1 | 1
147 |  |  | 2 | 2
187 |  |  | 1 | 1
319 |  | 1 |  | 1
329 |  |  | 1 | 1
438 |  |  | 1 | 1
460 |  |  | 1 | 1
846 |  | 1 |  | 1
915 |  |  | 1 | 1
2277 |  |  | 2 | 2
2415 |  |  | 1 | 1
2461 |  |  | 1 | 1
2893 |  |  | 1 | 1
3299 |  |  | 4 | 4
3346 |  |  | 1 | 1
3819 |  |  | 1 | 1
5624 |  |  | 2 | 2
5987 |  |  | 1 | 1
6457 |  |  | 1 | 1
35197 | 1 |  | 5 | 6
Grand Total | 1 | 2 | 28 | 31
Spreadsheet: 871680d1718104395-sum-with-cells-containing-numbers-and-text-shiftpatternbollocks
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | [NAME] | [NAME] | [NAME] |  | Standard
0800-2000 | 0700-1900 | 1000-2200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lower
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The above should say
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 4 | 8
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: INDEX MATCH 2

Table 1 |  |  |  | Cet exercise est pour transférer les colones de ceux qui ont voté
Covo | [NAME] | V |  | 13 | 17
Eastwood | [NAME] | v | 695-3297 | 13 |  | 21
Arcand | [NAME] | A | 695-2532 | 13
Beaulieu | Michel |  |  | 13 | 17 | 21
Legault | [NAME] |  |  |  | 17 | 21
Rozon | Gilles |  | 695-7565 |  |  | 21
Cross | [NAME] | X | 694-4865 | 13 |  | 21
Kelso | [NAME] |  |  |  | 17 | 21
Du Preez | [NAME] |  |  |  |  | 21
Arsenault | Stéphane | V | 697-7813 | 13
Legault | [NAME] |  |  | 13 | 17 | 21
Table 2
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Spreadsheet: 876019d1722628197-placing-names-on-teams-learning-the-ropes-book-2
Sheet: Solution

Player Number | First Name | Last Name | Assigned Team # |  | Team Number | TEAM MEMBERS
1 | Afera | Quick | 4 |  | 1
2 | Al | Knol | 6 |  | 2
3 | Barb | Tamp | 9 |  | 3
4 | Barb | Pine | 1 |  | 4
5 | [NAME] | [NAME] | 10 |  | 5
6 | [NAME] | Stout | 2 |  | 6
7 | [NAME] | Smith | 3 |  | 7
8 | [NAME] | Dime | 5 |  | 8
9 | [NAME] | Radcliff | 6 |  | 9
10 | George | Plum | 8 |  | 10
11 | [NAME] |  | 10
12 | [NAME] | Slow | 1
13 | [NAME] | [NAME] | 7
14 | Mac | Long | 3
15 | Nate | Late | 2
16 | Ned | Brow | 5
17 | Ray | Erskine | 9
18 | Shelly | Early | 8
19 | [NAME] | Ready | 4
20 | Sue | Baxter | 7
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: Oct

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 742056d1627496043-formula-that-edits-sum-of-one-cell-and-moves-excess-to-another-cell-sample-timesheet
Sheet: Sheet1

 |  |  | BI-WEEKLY TIME SHEET
EMPLOYEE NAME: |  | Name |  |  |  | PAY PERIOD:
WEEK 1 | IN | OUT | REG. HRS. | OT | COMP EARNED | SICK | VAC | HOLIDAY | COMP USED | PERSONAL | TOTAL
2021-07-25 00:00:00 | 12:00:00 | 00:00:00
 | 12:00:00 | 00:00:00
 | 00:00:00 | 12:00:00
 | 14:00:00 | 23:00:00
 | 04:00:00 | 23:00:00
 | WEEK 1 TOTALS
WEEK 2 | IN | OUT | REG. HRS. | OT | COMP EARNED | SICK | VAC | HOLIDAY | COMP USED | PERSONAL | TOTAL
 | 06:00:00 | 18:00:00
 | 06:00:00 | 18:00:00
 | 06:00:00 | 18:00:00
 | WEEK 2 TOTALS
 | GRAND TOTALS
 | EXCESS HOURS
By signing this time sheet I certify that I have carefully reviewed this time sheet and that the hours reported on this time sheet, including all start and
stop times, are accurate. I have not reported more or less time than I actually worked. I will not sign this time sheet if it is not accurate.
Employee Signature |  |  |  |  | Date
Supervisor Signature |  |  |  |  | Date
Spreadsheet: 805806d1668944103-how-to-show-value-added-tax-separate-from-vat-exempt-and-vat-zero-rated-vat-separattion
Sheet: VAT_ZeroRated

[NAME] ZERO RATED
Date | TIN | CUSTOMER NAME | TAX IONVOICE NUMBER / REFERENCE | Particulars of Supplies | Exempt Supplies | Zero Rated Supplies | Std Rated (Excl. VAT)
2022-10-06 00:00:00 | 100100300 | Grocery | 3548 | Milk |  | 50
2022-10-13 00:00:00 | 100100100 | mobile money | 963258 | Electricity |  | 1000
Spreadsheet: eric_saibi__9729__011002
Sheet: Quad Cities 01

Owner Name |  | Exelon Nuclear
Station Name |  | Quad Cities Nuclear Power Station
Unit Name |  | Quad Cities 01
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 838 MW
Start Date |  | 2002-01-09 00:00:00
End Date |  | 2002-01-12 00:00:00
Comments |  | Pump repairs.
SIC |  | 4911
Plant ID |  | 1515021
Unit ID |  | 1007229
Outage ID |  | 19442
Spreadsheet: 289780d1389691445-consolidating-data-from-many-worksheets-example
Sheet: Summary

Output needed:
 | Sheet1 | Sheet2 | Sheet3 |  | Totals |  | (Note: there are 28 - 30 sheets each week)
Employee 1 | 30.75 |  | 31 |  | 61.75
Employee 2 | 31 | 31 |  |  | 62
Employee 3 | 31 |  |  |  | 31 |  | INFO: These reports are run every week
Employee 4 | 30.5 |  |  |  | 30.5 |  | The number of pages varies by a couple each week
Employee 5 | 31 |  |  |  | 31 |  | An employee may appear on several pages every week
Employee 6 | 15.5 |  |  |  | 15.5 |  | The number of rows under each employee can vary every week
Employee 7 | 23.75 |  | 31 |  | 54.75
Employee 8 | 31.75 |  |  |  | 31.75
Employee 9 |  | 31 |  |  | 31
Employee 10 |  | 27.75 |  |  | 27.75
Employee 11 |  | 31 |  |  | 31
Employee 12 |  | 31 |  |  | 31
Note: there are around 300 employees each week)
Spreadsheet: 768330d1644928769-trying-to-look-up-and-filter-data-example
Sheet: K COL

COL
Component name | Result text
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: N Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 02-01) 11-02-2020 | pdf |  | 02-01) 10-02-2020 | pdf |  | 02-01) 10-02-2020 | pdf |  | 11-01) 06-11-2019 | pdf
 | 03-01) 31-03-2020 | pdf |  | 05-01) 11-05-2020 | pdf |  | 05-01) 11-05-2020 | pdf |  | 02-01) 11-02-2020 | pdf
 | 05-01) 12-05-2020 | pdf