tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145222d1331391632-sum-if-function-from-different-cells-0102-1
Sheet: Data

 |  |  | 1
Product | Pages | Machine | Production Start | Productivity
asd | 4 | A | 07:00:00 | 5000
[NAME] | 6 | B | 08:00:00 | 5666
fjgj | 8 | A | 08:05:00 | 3444
ksdhfk | 4 | A | 15:00:00 | 7888
dfhdnfg | 6 | A | 15:15:00 | 9664
[NAME] | 7 | C | 23:15:00 | 4567
hdjash | 9 | C | 23:30:00 | 8976
ytir | 2 | B | 1900-01-01 00:00:00 | 3457
[NAME] | 8 | C | 00:45:00 | 5643
hasjf | 4 | C | 03:00:00 | 1234
sdf | 6 | A | 05:00:00 | 6543
[NAME] | 7 | B | 02:15:00 | 7653
tyue | 9 | C | 04:15:00 | 8754
jjjs | 2 | B | 23:00:00 | 5567
jjs | 8 | A | 18:15:00 | 8890
kkkd | 4 | A | 1900-01-01 00:00:00 | 7659
jjje | 6 | B | 00:45:00 | 9876
jjjja | 7 | C | 03:00:00 | 3453
jjjjsd | 9 | C | 05:00:00 | 2357
jjjed | 2 | B | 02:15:00 | 8754
Spreadsheet: 023b695a-c5a5-46e1-8639-3740366b0daf
Sheet: Log

PURCHASING CARD TRANSACTION LOG
[NAME]:
Month:
Order Date | Order Confirmation Number | Supplier & Description of goods/services* | 10 digit nominal code (ending in 1 or 3) | Project code | Sub analysis code | Net (£) | VAT (£) | Total (£) | Goods received (Yes/No) | Reconciled to statement (Yes/No)
 |  | Company X Ltd - Training course | 1900341753 | FIN001 |  | 100 | 15
 |  | Company X Ltd - Training course | 1900341753 | FIN001 |  | -100 | -15
Completed by |  | (Cardholder) | Signed |  |  | Date
Authorised by  (Budget Holder) |  |  | Signed |  |  | Date
* Please note that the description must not exceed a maximum of 28 characters (including spaces) for upload into the financial system.
Spreadsheet: 41260d1239746095-entering-a-payment-and-seeing-a-new-balance-new-monthly-payment-sheet-2
Sheet: Sheet1

Choose a Month |  |  | Car |  | Truck |  | Credit Card
August |  | Beginning Balance | 1000 |  | 2000 |  | 1500
 |  |  | Payment | Car New Balance | Payment | Truck New Balance | Payment | Credit Card New Balance
 |  | January | 50 | 950 | 50 | 1950 | 50 | 1450
 |  | February | 25 | 925 | 25 | 1925 | 25 | 1425
 |  | March | 100 | 825 | 100 | 1825 | 100 | 1325
 |  | April | 25 | 800 | 25 | 1800 | 25 | 1300
 |  | May | 50 | 750 | 50 | 1750 | 50 | 1250
Choose a Creditor |  | June | 25 | 725 | 25 | 1725 | 25 | 1225
Car |  | July | 100 | 625 | 100 | 1625 | 100 | 1125
 |  | August | 50 | 575 | 50 | 1575 | 50 | 1075
Enter Payment |  | September | 25 | 550 | 25 | 1550 | 25 | 1050
 |  | October | 25 | 525 | 25 | 1525 | 25 | 1025
New Balance |  | November | 25 | 500 | 25 | 1500 | 25 | 1000
 |  | December | 50 | 450 | 50 | 1450 | 50 | 950
25
Spreadsheet: 161297d1339483457-sum-product-formula-dispatch-report-orissa
Sheet: Snap shot

 |  | BALASORE
 |  | April'12 |  | May |  | June
 |  | billed | not billed | billed | not billed | billed | not billed
 | [NAME] 32K Card
 | 64KB Prepaid SIM Card - NANO-MNP
 | Chhota Recharges 10 new
 | Chhota Recharges 20 new
 | Chhota Recharges 50 new
 | RCV 7 | 0
 |  | Berhampur
 |  | April |  | May |  | June
 |  | billed | not billed | billed | not billed | billed | not billed
 | [NAME] 32K Card
 | 64KB Prepaid SIM Card - NANO-MNP
 | Chhota Recharges 10 new
 | Chhota Recharges 20 new
 | Chhota Recharges 50 new
 | RCV 7
 |  | Bhubaneswar
 |  | April |  | May |  | June
 |  | billed | not billed | billed | not billed | billed | not billed
 | [NAME] 32K Card
 | 64KB Prepaid SIM Card - NANO-MNP
 | Chhota Recharges 10 new
 | Chhota Recharges 20 new
 | Chhota Recharges 50 new
 | RCV 7
 |  | Cuttack
 |  | April |  | May |  | June
 |  | billed | not billed | billed | not billed | billed | not billed
 | [NAME] 32K Card
 | 64KB Prepaid SIM Card - NANO-MNP
 | Chhota Recharges 10 new
 | Chhota Recharges 20 new
 | Chhota Recharges 50 new
 | RCV 7
 |  | Sambalpur
 |  | April |  | May |  | June
 |  | billed | not billed | billed | not billed | billed | not billed
 | [NAME] 32K Card
 | 64KB Prepaid SIM Card - NANO-MNP
 | Chhota Recharges 10 new
 | Chhota Recharges 20 new
 | Chhota Recharges 50 new
 | RCV 7
Spreadsheet: 874270d1720822640-formula-to-get-the-name-of-the-project-with-the-highest-cost-allocation-book1
Sheet: Sheet1

Have this: |  |  |  |  |  | But need this:
Resource  ↑ | Engagement  ↑ | Country | Resource Cost | [NAME] |  | Resource  ↑ | Engagement  ↑ | Country | Resource Cost | [NAME]
A | X | US | 33000 |  |  | A | X | US | 33000 | Y
A | Y | US | 56000 |  |  | A | Y | US | 56000 | Y
A | Z | US | 11000 |  |  | A | Z | US | 11000 | Y
B | X | SP | 25000 |  |  | B | X | SP | 25000 | Y
B | Y | SP | 75000 |  |  | B | Y | SP | 75000 | Y
C | X | BR | 100000 |  |  | C | X | BR | 100000 | X
D | Y | US | 50000 |  |  | D | Y | US | 50000 | Y or Z
D | Z | US | 50000 |  |  | D | Z | US | 50000 | Y or Z
Spreadsheet: 714508d1611248970-help-computing-a-running-total-between-2-sheets-book6
Sheet: Sheet2

Starting Liquid |  | 200000
Mon 01/25 |  | Tue 01/26 |  | Wed 01/27 |  | Thu 01/28 |  | Fri 01/29 |  | Sat 01/30 |  | Sun 01/31
A | B | A | B | A | B | A | B | C | D | C | D | C | D
4
8 | 4
 | 8 | 12
 |  | 2 | 3 | 14
 |  |  |  |  | 13 | 13
 |  |  |  |  |  |  | 14 | 14 | 4
 |  |  |  |  |  |  |  |  | 9 | 13 | 13 | 13 | 13
18210 | 14056 | 24566 | 5223 | 24373 | 12768 | 12768 | 17267 | 17267 | 18780 | 20000 | 20000 | 20000 | 20000
Mon 01/25 |  | Tue 01/26 |  | Wed 01/27 |  | Thu 01/28 |  | Fri 01/29 |  | Sat 01/30 |  | Sun 01/31
A | B | A | B | A | B | A | B | C | D | C | D | C | D
14 | 14 | 14 | 14 | 14 | 4
 |  |  |  |  | 10 | 14 | 14 | 14 | 14 | 14 | 11
 |  |  |  |  |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 13
25969 | 25969 | 25969 | 25969 | 25969 | 22804 | 21539 | 21539 | 21539 | 21539 | 21539 | 20805 | 25187 | 25364
Rows 9-19 represent production line 1
Rows 21-29 represent production line 2
Row 19 is the total amount of liquid used for that day - example, 32,266 used on production line 1 on Monday
Row 29 is the same, but for production line 2
Row 7 represents the running total of where we will be at the end of each day - based off of the usages in rows 19+29
Cell C5 will be manually entered on Monday morning
My goal is to have a running count that incorporates incoming loads of liquid, based off of the schedule on the next sheet
Spreadsheet: kimberly_watson__20628__2001topten
Sheet: Sheet1

[NAME]
Top Ten Shippers (Revenues)
For the Period January 2001 through September 2001
 | (000's) | % of
Shipper | Amount | Revenues
Southern California Gas Co | 40403
Pacific Gas and Electric | 12917
BP Energy Company | 7586
Sempra Energy Trading Corp | 6857
El Paso Energy Marketing | 5488
Duke Energy Trading and Marketing | 5375
Texaco Natural Gas | 5005
PG&E Energy Trading | 4424
Burlington Resources Trading | 3956
U S Gas Transportation | 3766
Total Top  Ten
Other Shippers
Transportation Revenues | 127326
Spreadsheet: 203851d1357268556-data-entry-using-excel-2010-denkai-animal-subsidized-vet-clinic-pack-01032012
Sheet: Vet Services

Subsidized Veterinary Services
Owner’s Name |  |  |  |  | Date
Address
City |  |  |  | State |  | Zip
E-mail |  |  |  |  | Phone
Name of Pet |  |  | Type |  | Breed
Color |  | Age |  | Sex |  | Weight
Service(s) Provided: |  |  | Notes (as needed): |  |  |  | Cost:
 |  |  |  |  |  | Total:
Offering a donation as a tribute to a family member, pet, or friend is a wonderful way to show your love while supporting [NAME]. Donations can also be offered as a way to honor an event or simply to show you care. We thank you advance and appreciate you!
I would like to donate $(                   ) in honor of
I,                                                          am the owner of the above noted animal.  I authorize and request that my animal be given vaccinations as indicated above.  I further understand that there may be adverse reactions to the vaccinations and hereby agree to take the animal to my veterinarian for treatment as necessary.  Furthermore, I will not hold Denkai Animal Sanctuary, its employees or veterinarian responsible for illness, injury or death as a result of these vaccinations or participation in this vaccination clinic.
 | Signature |  |  |  |  | Date
Spreadsheet: 43200d1241779164-sumproduct-formula-with-criterion-condition-test
Sheet: Sheet1

Criteria
1 |  | 3000 | 0.4
1 |  | 4567 | 0.4
1 |  | 334 | 1
2 |  | 556 | 0.3
2 |  | 669 | 0.2
2 |  | 6600 | 0.2
10 |  | 8900 | 0.1
10 |  | 9900 | 0.1
10 |  | 8000 | 0.2
 |  | 42526
8461.400000000001
Spreadsheet: 672366d1586848364-24hrs-time-calculation-with-conditions-medication
Sheet: Meds

Date | Time | [NAME] | Med2 Count | 24hrs
2020-04-11 00:00:00 | 17:00:00 | 2 |  | #1
2020-04-11 00:00:00 | 23:50:00 | 2 | 1
2020-04-12 00:00:00 | 15:00:00 | 2
2020-04-12 00:00:00 | 22:30:00 | 2 | 1 | #2
2020-04-13 00:00:00 | 12:30:00 | 2 | 1
2020-04-13 00:00:00 | 23:30:00 | 2 | 1
2020-04-14 00:00:00 | 09:00:00 | 2 | 1
Spreadsheet: 105306d1302708744-sumproduct-with-dates-staffing2
Sheet: Charts

Select a Region or a Service Center |  | Select Job Category | Select Status |  | list for Region or all (columna A on associates tab) | list for Service Center  (column b on associates tab) | list for job Category (category tab) you want or All | list for job status (column I on associates tab)
REGION I | ATL | ACCOUNT MANAGERS | FULL TIME
 | # OF ASSOCIATES as of 12/31/20** | HIRED | TERMED |  | REGION I | ABI | SERVICE CENTER MGR | FULL TIME
2000 | 0 | 0 | 0 |  | REGION II | ALB | LEADERSHIP | PART TIME
 |  |  |  |  | REGION III | AMA | ACCOUNT MANAGERS
2000 | 4 | 3 | 2 |  | REGION IV | ASH | DRIVERS
2001 |  |  |  |  | REGION V | ATL | FREIGHT HANDLERS
2002 |  |  |  |  | REGION VIII | AUG | CLERICAL
2003 |  |  |  |  |  | AUS | MAINTENANCE
2004 |  |  |  |  |  | BHM | OTHER
2005 |  |  |  |  |  | BTR
2006 |  |  |  |  |  | CBS
2007 |  |  |  |  |  | CHS
2008 |  |  |  |  |  | CLT
2009 |  |  |  |  |  | COL
2010 |  |  |  |  |  | CRP
2011 |  |  |  |  |  | CSD
 |  |  |  |  |  | DAL
 |  |  |  |  |  | DFW
 |  |  |  |  |  | DOT
 |  |  |  |  |  | ELP
 |  |  |  |  |  | FAY
 |  |  |  |  |  | FDK
 |  |  |  |  |  | FLO
 |  |  |  |  |  | FMY
 |  |  |  |  |  | FTL
 |  |  |  |  |  | FTS
 |  |  |  |  |  | GBO
 |  |  |  |  |  | GEN
 |  |  |  |  |  | GRV
 |  |  |  |  |  | HAZ
 |  |  |  |  |  | HIC
 |  |  |  |  |  | HOU
 |  |  |  |  |  | HSV
 |  |  |  |  |  | JAC
 |  |  |  |  |  | JAX
 |  |  |  |  |  | JCK
 |  |  |  |  |  | KIN
 |  |  |  |  |  | KNX
 |  |  |  |  |  | LCH
 |  |  |  |  |  | LRD
 |  |  |  |  |  | LRK
 |  |  |  |  |  | MAC
 |  |  |  |  |  | MCA
 |  |  |  |  |  | MGM
 |  |  |  |  |  | MIA
 |  |  |  |  |  | MOB
 |  |  |  |  |  | MPS
 |  |  |  |  |  | NAS
 |  |  |  |  |  | NAT
 |  |  |  |  |  | NOR
 |  |  |  |  |  | NRL
 |  |  |  |  |  | OCA
 |  |  |  |  |  | ODS
 |  |  |  |  |  | OKC
 |  |  |  |  |  | ORL
 |  |  |  |  |  | PEN
 |  |  |  |  |  | RAL
 |  |  |  |  |  | RCO
 |  |  |  |  |  | RIC
 |  |  |  |  |  | RMT
 |  |  |  |  |  | ROA
 |  |  |  |  |  | SAT
 |  |  |  |  |  | SAV
 |  |  |  |  |  | SCH
 |  |  |  |  |  | SHM
 |  |  |  |  |  | SHV
 |  |  |  |  |  | TOK
 |  |  |  |  |  | TPA
 |  |  |  |  |  | TRC
 |  |  |  |  |  | TUP
 |  |  |  |  |  | TXA
 |  |  |  |  |  | TYR
 |  |  |  |  |  | VAL
 |  |  |  |  |  | WAC
 |  |  |  |  |  | WAT
 |  |  |  |  |  | WFL
 |  |  |  |  |  | WIL
 |  |  |  |  |  | WPB
 |  |  |  |  |  | WYB
 |  |  |  |  |  | WBC
Spreadsheet: 484748d1476419244-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v3
Sheet: Sheet1

 |  |  |  | Example 1
 |  |  |  |  | date chosen
 |  |  |  |  |  | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  |  |  |  | 3
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  |  | choose last column
 |  |  |  |  | Areas | M7
 |  |  |  |  | A1
 |  |  |  |  | A10
 |  |  |  |  | A8
 |  |  |  |  | A3
 |  |  |  |  | A6
 |  |  |  |  | A12
 |  |  |  |  | A5
 |  |  |  |  | A9
 |  |  |  |  | A7
 |  |  |  |  | A11
 |  |  |  |  | A4
 |  |  |  |  | A2
Spreadsheet: 380641c3-16d4-4e56-ad77-f3469452692f
Sheet: InStateSAME

GLOBAL EDUCATION OFFICE
Approved Programs List 2013/2014
IN-STATE
All these programs are for the same Tuition & Fees as KSC
 |  |  | Approved Programs |  |  | Language of Instruction | GPA
 |  |  | Canada
 |  |  |  |  | Various Universities in Quebec and other provinces | English or French | 2.5
 |  |  | Chile
 |  |  |  |  | [NAME] [NAME] | English or Spanish | 2.5
 |  |  | Ecuador
 |  |  |  |  | Universidad San Francisco de Quito, [NAME] | Spanish | 2.75
 |  |  | England
 |  |  |  |  | University of Derby | English | 2.5
 |  |  |  |  | University of Wolverhampton | English | 2.5
 |  |  | France
 |  |  |  |  | Université Catholique de Lille | French/English | 2.75
 |  |  | Japan
 |  |  |  |  | Kansai Gaidai University | English | 3
 |  |  | Poland
 |  |  |  |  | Jagiellionian University | English | 3
 |  |  | USA
 |  |  |  |  | 175 Universities through National Student Exchange | English | 2.5
Financial Costs and Financial Aid: [NAME] approved programs vary in terms of cost. Whatever [NAME] approved program you
choose, you will remain eligible for financial aid. Cost estimates above are subject to change and approximate only.
Other costs may vary.  For more details, ask for a specific budget planning sheet.
Not all approved program destinations are listed here, please visit GEO for more information.
Spreadsheet: 157514d1337778288-returning-a-unique-kth-small-k-value-example
Sheet: Sheet1

ITEMS BEING RETURNED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PURCHASE HISTORY
SKU | # | QUALITY | PH Row | Column3 | Column4 | Column1 | Column2 | Column24 | Column25 | Column22 | Column222 | Column23 | invoice |  |  |  |  | SKU | # | Quality | Invoice #
widget1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget2 | 1 | 1 | T73255
widget2 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 1 | 1 | T73253
widget1 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 1 | 2 | A157235
widget2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget2 | 3 | 1 | T732541
widget1 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 3 | 1 | T73252
widget1 | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 3 | 1 | T732510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget2 | 3 | 2 | A15723
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 4 | 1 | jlk;s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | widget1 | 4 | 2 | A15723 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | result | -2 | -3 | -2-3 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | {FALSE;FALSE;FALSE;4;5;FALSE;FALSE;FALSE} |  | {4;5;FALSE} |  | 4 | {0;0;0} | {0;0;0} |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  | {FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;8} | {4} | {8;FALSE} |  | 8 | {1;0} | {1;0}
 |  |  |  | {FALSE;FALSE;3;4;5;FALSE;FALSE;FALSE} | {4;8} | {3;4;5;FALSE} |  | 3 | {0;1;0;1} | {0;0;1;1}
 |  |  |  | {FALSE;FALSE;FALSE;4;5;FALSE;FALSE;FALSE} | {4;8;3} | {4;5;FALSE} |  | 5 | {2;0;1} | {1;1;1}
 |  |  |  | {1;2;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE} | {4;8;3;4} | {1;2;FALSE} |  | 1 | {0;0;4} | {0;0;4}
 |  |  |  | {FALSE;FALSE;FALSE;4;5;FALSE;FALSE;FALSE}
 |  |  |  |  | {4;8;3;4;1} | {4;5;FALSE} |  |  | {4;0;1} | {2;2;1}
Spreadsheet: 133958d1324864915-cell-calculation-with-text-anonymust_-example
Sheet: Sheet1

Cost | Qty | Unit | Unit price
2 | 230 | g | £0.01/g
2 | 10 | [NAME] | £0.20/litre
2 | 1.25 | Kg | £1.60/Kg
2 | 14 | lb | £0.14/lb
2 | 100 | g | £0.02/g
2 | 16 | oz | £0.13/oz
2000 | 2 | pink elephant | £1000.00/pink elephant
Spreadsheet: 75492d1276071040-consolidate-4-worksheets-into-1-bom-for-forum
Sheet: airpump assembly

 | [NAME] of Materials | MTTS | airpump assembly
MECHANICAL
Author: |  | Date initial: | 2010-05-19 00:00:00
 |  | Updated: | 2010-05-19 00:00:00
version:
Sequence | Designator | Type no. | Value | Footprint | Description | Nr. Required |  | price 1pc (US$) | Order code: | Note | Inspect 1 | Reference:
1 | filter mesh | 2 layer |  | make air clean |  | 1
2 | screw1 | 15mm |  | hold the filter | 15mm | 1
3 | screw2 | 25mm |  | clamp the door behind airpump | 25mm | 2
4 | [NAME] D8 | D8 |  | conect airpump and pipe out put | D8mm | 1
5 | pipe out put | D8xd5x70mm |  | conduction air into the blender | long ~ 70mm | 1
Spreadsheet: 759057d1639266151-reporting-sum-of-all-sheets-into-a-master-sheet-example
Sheet: REPORTING SHEET

Protocol | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00
220038.1
421016.1
421108.1
420051.1
621089.1
421118.1
421117.1
621091.1
420065.1
420102.1
421012.1
420076.1
421126.1
421063.1
419078.1
421038.1
421053.1
420054.1
420139.1
421001.1
421003.1
421068.1
421082.1
421084.1
421085.1
421023.1
421071.1
420044.1
421096.1
421097.1
421104.1
421110.1
421105.1
420072.1
220017.1
219051.1
421049.1
221031.1
Spreadsheet: 780965d1652891321-getting-data-from-another-worksheet-data
Sheet: Mar

Emp | Contacted | Yes | No | Maybe
[NAME] | 300 | 174 | 110
[NAME] | 275 | 125 | 25
[NAME] | 289 | 136 | 120
[NAME] | 339 | 230 | 56
[NAME] | 401 | 187 | 114
[NAME] | 356 | 274 | 5
Spreadsheet: eric_saibi__9857__101101R
Sheet: Cromby 01

Owner Name |  | Exelon Power
Station Name |  | Cromby Power Station
Unit Name |  | Unit 01
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Coal
Capacity |  | 188 MW
Start Date |  | 2001-10-26 00:00:00
End Date |  | 2001-11-09 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-10-19 00:00:00
Comments |  | Boiler and Superheater work
SIC |  | 4931
Plant ID |  | 1514989
Unit ID |  | 1005109
Outage ID |  | 17466
Spreadsheet: 81593d1281711718-vacation-and-sick-tracking-vacation-sick
Sheet: Table

 | SICK |  | VACATION
Year | Monthly | [NAME] | Monthly | [NAME] |  | 1st year vacation acrues at 5 hrs per month with a maximum accumulation of 168 hours.
0 | 5 | 216 | 5 | 168 |  | 1st through 3rd year sick time acrues at 5 hrs per month with a maximum accumlation of 216 hours.
1 | 5 | 216 | 10 | 168
3 | 7 | 408 | 13 | 168 |  | 2nd - 3rd year vacation acrues at 10 hours per month with a max of 168 hours.
 |  |  |  |  |  | 4th -5th year vacation acrues at 13 hours per month with a max of 168 hours.
 |  |  |  |  |  | 4th-5th year sick acrues at 7 hours per month with a max of 408 hours.
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (9)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
9.01
9.02
9.03
9.04 |  |  |  |  |  |  |  |  |  | 0
9.05 |  |  |  |  |  |  |  |  |  | 0
9.06 |  |  |  |  |  |  |  |  |  | 0
9.07 |  |  |  |  |  |  |  |  |  | 0
9.08 |  |  |  |  |  |  |  |  |  | 0
9.09 |  |  |  |  |  |  |  |  |  | 0
9.1 |  |  |  |  |  |  |  |  |  | 0
9.11 |  |  |  |  |  |  |  |  |  | 0
9.12 |  |  |  |  |  |  |  |  |  | 0
9.13 |  |  |  |  |  |  |  |  |  | 0
9.14 |  |  |  |  |  |  |  |  |  | 0
9.15 |  |  |  |  |  |  |  |  |  | 0
9.16 |  |  |  |  |  |  |  |  |  | 0
9.17 |  |  |  |  |  |  |  |  |  | 0
9.18 |  |  |  |  |  |  |  |  |  | 0
9.19 |  |  |  |  |  |  |  |  |  | 0
9.2 |  |  |  |  |  |  |  |  |  | 0
9.21 |  |  |  |  |  |  |  |  |  | 0
9.22 |  |  |  |  |  |  |  |  |  | 0
9.23 |  |  |  |  |  |  |  |  |  | 0
9.23999999999999 |  |  |  |  |  |  |  |  |  | 0
9.24999999999999 |  |  |  |  |  |  |  |  |  | 0
9.25999999999999 |  |  |  |  |  |  |  |  |  | 0
9.26999999999999 |  |  |  |  |  |  |  |  |  | 0
9.27999999999999 |  |  |  |  |  |  |  |  |  | 0
9.28999999999999 |  |  |  |  |  |  |  |  |  | 0
9.29999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: MAL

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 56 | 00:01:41.539000 | 1 |  | 1 |  | 00:01:34.870000
2 | [NAME] |  |  | 18 | 56 | 00:01:41.264000 | 4 |  | 2 |  | 00:01:35.200000
3 | [NAME] |  |  | 15 | 56 | 00:01:41.547000 | 6 |  | 3 |  | 00:01:36.124000
4 | [NAME] |  |  | 12 | 56 | 00:01:40.571000 | 3 |  | 4 |  | 00:01:35.179000
5 | [NAME] |  |  | 10 | 56 | 00:01:41.999000 | 7 |  | 5 |  | 00:01:36.251000
6 | [NAME] |  |  | 8 | 56 | 00:01:40.717000 | 5 |  | 6 |  | 00:01:35.802000
7 | [NAME] |  |  | 6 | 56 | 00:01:42.095000 | 10 |  | 7 |  | 00:01:36.820000
8 | [NAME] |  |  | 4 | 56 | 00:01:41.512000 | 2 |  | 8 |  | 00:01:34.974000
9 | [NAME] |  |  | 2 | 56 | 00:01:42.491000 | 11 |  | 9 |  | 00:01:37.035000
10 | [NAME] |  |  | 1 | 56 | 00:01:42.883000 | 14 |  | 10 |  | 00:01:37.370000
11 | [NAME] |  |  | 0 | 56 | 00:01:42.973000 | 17 |  | 11 |  | 00:01:37.593000
12 | [NAME] |  |  | 0 | 55 | 00:01:41.778000 | 9 |  | 12 |  | 00:01:36.809000
13 | Sebastien Buemi |  |  | 0 | 55 | 00:01:42.659000 | 12 |  | 13 |  | 00:01:37.160000
14 | [NAME] |  |  | 0 | 55 | 00:01:43.744000 | 13 |  | 14 |  | 00:01:37.347000
15 | [NAME] |  |  | 0 | 55 | 00:01:43.677000 | 19 |  | 15 |  | 00:01:38.645000
16 | [NAME] |  |  | 0 | 54 | 00:01:45.357000 | 21 |  | 16 |  | 00:01:40.648000
17 | [NAME] |  |  | 0 | 52 | 00:01:41.054000 | 8 |  | 17 |  | 00:01:36.324000
18 | [NAME] |  |  | - | 46 | 00:01:46.521000 | 23 |  | RET |  | 00:01:41.549000
19 | [NAME] |  |  | - | 42 | 00:01:45.346000 | 22 |  | RET |  | 00:01:41.001000
20 | Jarno [NAME] |  |  | - | 31 | 00:01:45.280000 | 20 |  | RET |  | 00:01:38.791000
21 | [NAME] |  |  | - | 23 | 00:01:43.298000 | 16 |  | RET |  | 00:01:37.528000
22 | [NAME] |  |  | - | 22 | 00:01:45.516000 | 15 |  | RET |  | 00:01:37.496000
23 | Narain Karthikeyan |  |  | - | 14 | 00:01:49.385000 | 24 |  | RET |  | 00:01:42.574000
24 | Pastor Maldonado |  |  | - | 8 | 00:01:45.689000 | 18 |  | RET |  | 00:01:38.276000
Spreadsheet: 782531d1654096792-formula-linked-to-a-specific-period-excelforum
Sheet: Sheet1

Month | Period |  |  |  |  | [NAME] | Period
2022-01-01 00:00:00 | 01 |  |  |  |  | 2022-01-01 00:00:00 | Pick relevant period from column B
2022-02-01 00:00:00 | 02
2022-03-01 00:00:00 | 03
2022-04-01 00:00:00 | 04
2022-05-01 00:00:00 | 05
2022-06-01 00:00:00 | 06
2022-07-01 00:00:00 | 07
2022-08-01 00:00:00 | 08
2022-09-01 00:00:00 | 09
2022-10-01 00:00:00 | 10
2022-11-01 00:00:00 | 11
2022-12-01 00:00:00 | 12