tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37125d1235068455-pub-poker-league-table-help-poker-scores
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | testing
 |  | Scores |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formulae |  |  |  | rank numbers:
 | Player | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10 | Week11 | [NAME] | Week13 | Week14 | Week15 | Week16 | Week17 | Week18 | Week19 | Week20 | Week21 | Week22 | Week23 | Week24 | Week25 | Week26 | Week27 | Week28 | Week29 | Week30 | Week31 | Week32 | Week33 | Week34 | Week35 | [NAME] | Week37 | Week38 | Week39 | [NAME] | Week41 | [NAME] | Week43 | Week44 | Week45 | Sum of top 20 | Avg. of top 20 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | Derek | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 8 | 8 | 8 | 9 | 9 | 9 | 10 | 10 | 10 | 11 | 11 | 11 | 12 | 12 | 12 | 13 | 13 | 13 | 14 | 14 | 14 | 15 | 15 | 15 | 243 | 12.15 |  | <- using array formula to create large{1 - 20} | 15 | 15 | 15 | 14 | 14 | 14 | 13 | 13 | 13 | 12 | 12 | 12 | 11 | 11 | 11 | 10 | 10 | 10 | 9 | 9 | 9
 | Gavin | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 180 | 9 |  | <- writing 1-20 into embedded array | 11 | 11 | 11 | 11 | 10 | 10 | 10 | 10 | 9 | 9 | 9 | 9 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7 | 6
 | [NAME] | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 142 | 7.1 |  |  | 9 | 9 | 9 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sum: | average: | diffs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Derek | 243 | 12.15 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gavin | 180 | 9 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Derek | 142 | 7.1 | 0 | 0
Spreadsheet: 776543d1649780562-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a
Sheet: Stats 

Stats Drivers |  |  |  |  |  |  |  |  | [NAME]
 | Pole | Wins | [NAME] | Fastest Pitstop | Retirements |  |  |  |  | Pole | Wins | [NAME] | Fastest Pitstop | Retirements
Verstappen | 0 | 0 | 0 | 0 | 1 |  |  |  | Redbull
[NAME] | 0 | 0 | 0 | 0 | 1 |  |  |  | Mercedes
Hamiton | 0 | 0 | 0 | 0 | 0 |  |  |  | Ferrari
Russel | 0 | 0 | 0 | 0 | 0 |  |  |  | Mclaren
Leclerc | 1 | 1 | 1 | 1 | 0 |  |  |  | Alpine
Sainz | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME]
Riccardo | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME]
Norris | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME]
Ocon | 0 | 0 | 0 | 0 | 0 |  |  |  | Haas
Gasly | 0 | 0 | 0 | 0 | 1
Tsunoda | 0 | 0 | 0 | 0 | 0
Vettel | 0 | 0 | 0 | 0 | 0
Stroll | 0 | 0 | 0 | 0 | 0
Latifi | 0 | 0 | 0 | 0 | 0
Albon | 0 | 0 | 0 | 0 | 0
Bottas | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
Magnussen | 0 | 0 | 0 | 0 | 0
Total
Spreadsheet: 59448d1259940781-vlookup-to-return-multiple-cells-of-same-lookup-value-test-1-
Sheet: Receipt

 |  |  |  |  | RECEIPT
Elaine |  |  |  | ARTIST REFERENCE | A0006
 |  |  |  | DATE | 2009-12-04 15:30:17
 |  |  |  | DATE RECEIVED | 2009-12-01 00:00:00
 |  |  |  | RECEIVED VIA | HAND
OUR REF | ARTIST REF | [NAME] |  |  | PRICE
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1 | AR0055 | bulbs - oil on canvas (150x110 cm) | F1 | F1 | 6000
F1
F1
F1
F1
F1
 |  |  |  | TOTAL | 96000
Please direct enquiries to:
Received with thanks
Art & Escape Ltd agree to represent works for at least the length of exhibition.
All payments to be made within 30 days after exhibition.
Spreadsheet: 151575d1334986390-possible-to-use-functions-on-multiple-worksheets-where-the-worksheet-is-yet-to-created-adding-data-even-sheet-is-not-present
Sheet: Sheet1

sheet1
sheet2
sheet3
sheet4
sheet5
sheet6
sheet7
sheet8
sheet9
sheet10
Spreadsheet: 9a97f499-06fb-4e4a-806b-b53f9bbf7232
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-10 09:09:39.450000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.75 | 102.625 | 102.5 | 102.125
4.5 | 102.362 | 102.237 | 102.112 | 101.737 |  | Note: | Refer To Price [NAME]
4.375 | 101.593 | 101.468 | 101.343 | 100.968 |  |  | For all Price Adjs
4.25 | 101 | 100.875 | 100.75 | 100.125
4.125 | 100.163 | 100.038 | 99.913 | 99.288
4 | 99.162 | 99.037 | 98.912 | 98.287
3.875 | 98.118 | 97.993 | 97.868 | 97.243
3.75 | 97.243 | 97.118 | 96.993 | 96.368
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.606 | 102.481 | 102.356 | 101.981
3.625 | 102.217 | 102.092 | 101.967 | 101.592
3.5 | 101.668 | 101.543 | 101.418 | 101.043
3.375 | 100.951 | 100.826 | 100.701 | 100.326
3.25 | 100.202 | 100.077 | 99.952 | 99.327
3.125 | 99.638 | 99.513 | 99.388 | 98.763
3 | 98.888 | 98.763 | 98.638 | 98.013 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-24 09:09:39.450000
30 DAY | 2014-07-09 09:09:39.450000
45 DAY | 2014-07-24 09:09:39.450000
60 DAY | 2014-08-08 09:09:39.450000
90 DAY | 2014-09-07 09:09:39.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 770998d1646382108-pulling-data-based-on-criteria-from-one-list-to-another-book3-gk3-
Sheet: Sheet2

D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: CCI - CS-SPD BULK & PACK

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD BULK & PACK
FACILITY: | CROSS CANCER INSTITUTE (CCI)
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  |  | X |  | X |  |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-WRAPPER 18" |  |  |  | BP0002 |  | 4
20-WRAPPER 24" |  |  |  | BP0003 |  | 1
20-WRAPPER 30" |  |  |  | BP0004 |  | 2
20-WRAPPER 36" |  |  |  | BP0005 |  | 2
20-WRAPPER 45" |  |  |  | BP0006 |  | 3
20-WRAPPER 54" |  |  |  | BP0007 |  | 1
20-HUCK TOWELS |  |  |  | BP0009 |  | 13
10-TRAY-PILLOW COVERS |  |  |  | AP0014 |  | 1
10-SPINAL DRAPES |  |  |  | BP0016 |  | 3
1-GOWN GORE MED |  |  |  | GP0009 |  | 3
1-GOWN GORE XL |  |  |  | GP0010 |  | 1
1-GOWN STD XL |  |  |  | GP0002 |  | 15
2-GOWN STD XL |  |  |  | GP0004 |  | 1
LG SPLIT PACK |  |  |  | CP0006 |  | 2
LITHOTOMY PACK |  |  |  | CP0010 |  | 4
BROVIAC PACK (CCI) |  |  |  | CP0040 |  | 4
2-HUCK TOWEL |  |  |  | SP0081 |  | 15
MED BARRIER |  |  |  | SP0016 |  | 2
HALF SHEET |  |  |  | SP0015 |  | 4
5-DECONTAM GOWNS M |  |  |  | BP0019 |  | 3
3-HALF SHEETS |  |  |  | BP0032 |  | 4
5-MEDIUM BARRIER |  |  |  | BP0011 |  | 2
3/4 SHEET |  |  |  | SP0020 |  | 2
MAYO COVER |  |  |  | SP0003 |  | 1
LG SPLIT DRAPE |  |  |  | SP0010 |  | 2
UPDATED:
June 17th 2009
Spreadsheet: 012e7ecc-996c-4a68-ab4d-00ad918265d1
Sheet: Sheet1

Academy Name | 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
Balance Sheet
Date
 | Governmental Fund Types |  |  |  |  |  |  |  | Account Groups
 | General |  | Special Revenue |  | Debt Service |  | Capital Projects |  | Fixed Assets |  | Long Term Debt |  | Total
Assets
Cash and Equivalents |  |  |  |  |  |  |  |  |  |  |  |  | 0
Investments |  |  |  |  |  |  |  |  |  |  |  |  | 0
Accounts Receivables |  |  |  |  |  |  |  |  |  |  |  |  | 0
Due From Other Funds |  |  |  |  |  |  |  |  |  |  |  |  | 0
Due From Other Governmental Units |  |  |  |  |  |  |  |  |  |  |  |  | 0
Prepaid Expenses |  |  |  |  |  |  |  |  |  |  |  |  | 0
Fixed Assets |  |  |  |  |  |  |  |  |  |  |  |  | 0
Amount Available for Debt Service |  |  |  |  |  |  |  |  |  |  |  |  | 0
Amount to be Provided for Debt Retirement |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Assets | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Liabilities and Fund Balance
Accounts Payable |  |  |  |  |  |  |  |  |  |  |  |  | 0
Short Term Notes Payable |  |  |  |  |  |  |  |  |  |  |  |  | 0
Due to Other Funds |  |  |  |  |  |  |  |  |  |  |  |  | 0
Accrued Expenditures |  |  |  |  |  |  |  |  |  |  |  |  | 0
Accrued Salaries and Benefits |  |  |  |  |  |  |  |  |  |  |  |  | 0
Deferred Revenue |  |  |  |  |  |  |  |  |  |  |  |  | 0
Long Term Notes Payable |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Liabilities | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment in Fixed Assets |  |  |  |  |  |  |  |  |  |  |  |  | 0
Fund Balance:
Beginning Fund Balance |  |  |  |  |  |  |  |  |  |  |  |  | 0
Revenues Over (Under) Expenditures |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Fund Balance | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Liabilities and Fund Balance | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Note:  This template is not an all inclusive document and may need to be tailored to fit the reporting needs of the Academy. Refer to the Michigan School Accounting Manual (Bulletin 1022) for accounting codes and format.
Spreadsheet: 161628d1339584021-prettier-graphs-and-easier-x-axis-change-2012-monitoring-sheet_pt_jpr73
Sheet: PT_pH

[NAME] pH Min | (Tous)
[NAME] pH Max | (Tous)
[NAME] | (Tous)
[NAME] | (Tous)
Lower Target pH | (Tous)
Upper Target pH | (Tous)
 | Données
Date | [NAME] pH Min | [NAME] pH Max | [NAME] | [NAME] | Lower Target pH | Upper Target pH
2012-05-15 00:00:00 | 3.741 | 7.922 | 6.926 | 0.332 | 7 | 8
2012-05-16 00:00:00 | 2.831 | 7.277 | 6.712 | 0.352 | 7 | 8
2012-05-17 00:00:00 | 6.089 | 8.102 | 7.03 | 0.319 | 7 | 8
2012-05-18 00:00:00 | 3.409 | 10.894 | 7.473 | 1.763 | 7 | 8
2012-05-19 00:00:00 | 6.592 | 6.925 | 6.76 | 0.089 | 7 | 8
2012-05-20 00:00:00 | 3.732 | 8 | 6.036 | 0.54 | 7 | 8
2012-05-21 00:00:00 | 3.185 | 5.914 | 5.19 | 0.525 | 7 | 8
2012-05-22 00:00:00 | 4.556 | 7.143 | 6.507 | 0.405 | 7 | 8
2012-05-23 00:00:00 | 2.857 | 11.289 | 7.07 | 1.386 | 7 | 8
2012-05-24 00:00:00 | 3.969 | 8.731 | 6.11 | 0.814 | 7 | 8
2012-05-25 00:00:00 | 6.169 | 8.383 | 6.845 | 0.592 | 7 | 8
2012-05-26 00:00:00 | 5.736 | 7.05 | 6.488 | 0.378 | 7 | 8
2012-05-27 00:00:00 | 5.044 | 7.751 | 6.754 | 0.238 | 7 | 8
2012-05-28 00:00:00 | 2.387 | 8.915 | 7.132 | 0.568 | 7 | 8
2012-05-29 00:00:00 | 3.64 | 8.95 | 7.875 | 0.626 | 7 | 8
Spreadsheet: 147079d1332515539-counting-days-between-set-dates-example2
Sheet: Data

 | Name: | [NAME]
 |  |  |  |  |  | Days worked that month
 | Start date (for this timesheet) | 2012-04-01 00:00:00
 | Finish date (for this timesheet) | 2012-04-30 00:00:00 |  |  |  |  |  |  |  | What I would like to use
 | What days of the week do you normally work |  |  |  |  |  |  |  |  | Week1 |  | Hours worked
 | Monday | Yes |  |  |  |  |  |  |  | Monday | Yes | 08:50:00
 | Tuesday | Yes |  |  |  |  |  |  |  | Tuesday | Yes | 08:50:00
 | Wednesday | Yes |  |  |  |  |  |  |  | Wednesday | Yes
 | Thursday | Yes |  |  |  |  |  |  |  | Thursday | Yes
 | Friday | Yes |  |  |  |  |  |  |  | Friday | Yes | 08:50:00
 | Saturday | No |  |  |  |  |  |  |  | Saturday | No
 | Sunday | No |  |  |  |  |  |  |  | Sunday | No
 | Yes |  |  |  |  |  |  |  |  | Week2
 |  |  |  |  |  |  |  |  |  | Monday | Yes
 |  |  |  |  |  |  |  |  |  | Tuesday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Wednesday | Yes
 |  |  |  |  |  |  |  |  |  | Thursday | Yes
 |  |  |  |  |  |  |  |  |  | Friday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Saturday | No | 04:00:00
 |  |  |  |  |  |  |  |  |  | Sunday | No
 |  |  |  |  |  |  |  |  |  | Week3
 |  |  |  |  |  |  |  |  |  | Monday | Yes
 |  |  |  |  |  |  |  |  |  | Tuesday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Wednesday | Yes
 |  |  |  |  |  |  |  |  |  | Thursday | Yes | 06:00:00
 |  |  |  |  |  |  |  |  |  | Friday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Saturday | No
 |  |  |  |  |  |  |  |  |  | Sunday | No
 |  |  |  |  |  |  |  |  |  | Week4
 |  |  |  |  |  |  |  |  |  | Monday | Yes
 |  |  |  |  |  |  |  |  |  | Tuesday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Wednesday | Yes
 |  |  |  |  |  |  |  |  |  | Thursday | Yes
 |  |  |  |  |  |  |  |  |  | Friday | Yes | 08:50:00
 |  |  |  |  |  |  |  |  |  | Saturday | No | 04:00:00
 |  |  |  |  |  |  |  |  |  | Sunday | No
Spreadsheet: 693403d1598958720-tally-number-wise-required-sum-of-hours-amounts-count-of-strength-as-per-categories-book3
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB
 |  |  |  |  |  |  |  |  |  | Sum of Total Hrs |  |  |  |  |  | Sum of Total Amount |  |  |  |  |  | Count of Total Strength
Tally No | 2020-08-01 00:00:00 | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-03 00:00:00 | SumHrs | SumAmt |  | up to 10 hrs | 10.1 to 14 hrs | 14.1 to 24 hrs | Weekend Hrs | Holiday Hrs | Sum of Hrs after Weekend/Holidays Reduction | [NAME] | 10.1 to 14 Hrs OT1 Rate | 14.1 to 24 Hrs OT2 Rate | Weekend Hrs Rate | Holidays Rate | Total Amount | up to 10 hrs | 11 to 14 hrs | 15 to 24 hrs | Weekend | Holidays | Count after Weekend/Holidays Reduction
 | Hrs | Amt | Hrs | Amt | Hrs | Amt | SumHrs | SumAmt |  |  |  |  |  |  |  |  | 1.25 | 1.5 | 1.5 | 1.5
12512
14512 | 10 | 95.8 | 10 | 95.8
1653 | 10 | 95.8 | 10 | 95.8 | 6 | 57.48
14564 | 10 | 103.7 | 10 | 103.7 | 6 | 62.22
15678 | 10 | 95.8 | 10 | 95.8
19785 | 10 | 106.9 | 10 | 106.9
21785
22784 | 10 | 112.2 | 10 | 112.2 | 6 | 67.32
Notes
Normal rate to be consider for up to 10 Hrs
10.1 to 14 Hrs to be consider as a OT1,up to 10 Hrs is normal rate above 10 and below 14 hrs  OT1 rate applicable
14.1 to 24 Hrs to be consider as a OT2,up to 10 Hrs is normal rate above 10 and below 14 hrs  OT1 rate applicable and above 14 to 24 hrs OT2 rate applicable.
All Hours related to weekends/Hoildays to be considered as a OT2,Normal rate,OT1 rate not applicable.
Spreadsheet: 218872d1362597346-countif-sample
Sheet: Sheet1

1A | 2A | 3A | 4A | 5A | 6A | 7A | 8A | 9A | 10A | 12A | 13A | 14A | 15A | 16A | 17A | 18A | 19A | 20A
 |  |  | 4480
 |  |  | WARZ
 |  |  | MT
21A | 22A | 23A | 24A | 25A | 26A | 27A | 28A | 29A | 30A | 31A | 32A | 33A | 34A | 35A | 36A | 37A | 38A | 39A
 |  |  |  |  |  |  | 4453
 |  |  |  |  |  |  | WARZ
 |  |  |  |  |  |  | MT
Spreadsheet: 856553d1705762352-match-and-extract-lambda-map-filter-extract
Sheet: L3

 |  |  |  |  | Match |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Extract >> | <<< Extract >> |  |  | <<< Extract >>
 |  |  |  |  | B-1/2/3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple |  |  | 133.05
 |  |  |  |  | Lon-2/5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Jasmine |  |  | 36.12
 |  |  |  |  | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Lily |  |  | 44
 |  |  |  |  | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME],Matrix | Rose |  |  | 101.36
Spreadsheet: 98244d1297236080-get-the-text-from-one-string-extracting-the-text-from-the-string
Sheet: MAIN

ROLE | OUTPUT
ZG_HU_ECC_FI14_AR_ACC_CLK_HU04 | FI14
ZG_HU_ECC_FI14_AR_ACC_CLK_HU08 | FI14
ZG_HU_ECC_FI18_TR_CSH_MGR_HU04 | FI18
ZG_HU_ECC_FI18_TR_CSH_MGR_HU08 | FI18
ZG_HU_ECC_FI23_TV_TRA | FI23
ZG_HU_ECC_LO17_WH_OPE_P2_HU02 | LO17
ZG_HU_ECC_LO17_WH_OPE_P2_HU04 | LO17
ZG_HU_ECC_LO17_WH_OPE_P2_HU08 | LO17
ZG_HU_ECC_TR02_PRINTER_HU08 | TR02
ZG_HA_ECC_TR01_BC_ENDUSER | TR01
ZG_HU_ECC_CO04_LO_CTL_CLK_HU08 | CO04
ZG_HU_ECC_CO12_CC_ACC_CLK_HU08 | CO12
ZG_HU_CR09_CCC_AGT_HU02 | CR09
ZG_HU_CR09_CCC_AGT_HU04 | CR09
ZG_HU_CR09_CCC_AGT_HU08 | CR09
ZG_HU_CR14_VALIDATOR_HU02 | CR14
ZG_HU_CR14_VALIDATOR_HU04 | CR14
Extracting the role in the Cell A2 by searching  the items in the "list" tab and give the result in cell B2 for  the corresponding role
Spreadsheet: 775751d1649286882-excel-2016-sheet-to-sheet-automation-excel-functions-sample
Sheet: Sheet 2

Job # | Job Title | Job Priority | Start Date | End Date | Notes
Priority 1 Jobs
Priority 2 Jobs
Priority 3 Jobs
Priority 4 Jobs
*Goal is to have data from "Original Data" automatically populate in the appropriate yellow highlighted sections when I type a new job into "Original Data" tab.
Spreadsheet: 234662d1368155911-stop-insert-row-from-changing-functions-new-register
Sheet: Transmittal All

PROJECT NUMBER:
PROJECT NAME:
 |  |  |  |  |  | A.B.N. 81 010 761 378
 |  |  |  |  | REVISION DATES
[NAME]
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
[NAME] | SOFTCOPY
# = Number of copies | D = AUTOCAD DRAWING FORMAT (.DWG)
 | E = EMAIL
 | P = PDF FORMAT |  |  |  | REVISION HISTORY
 | U = UPLOAD
DRAWING TITLE | NUMBER | CURRENT STATUS
SPECIFICATIONS / CERTIFICATE / OTHER | NUMBER | CURRENT STATUS
Spreadsheet: benjamin_rogers__1197__Calpine version 2
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax |  | 400
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 702536d1604407024-max-function-with-condition-doch-dzka
Sheet: 2020

09:00:00 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Day | In | Out | Hours | Overtime | Weekend | Day | In | Out | Hours | Overtime | Weekend | Day | In | Out | Hours | Overtime | Weekend
 | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  | 2 | 06:52:00 | 16:52:00 |  |  |  | 2
 | 3 |  |  |  |  |  | 3 | 06:50:00 |  |  |  |  | 3
 | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4
 | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5
 | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6
 | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7
 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8
 | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10
 | 11 |  |  |  |  |  | 11 |  |  |  |  |  | 11
 | 12 | 06:52:00 | 17:02:00 |  |  |  | 12 |  |  |  |  |  | 12
 | 13 | 06:54:00 | 17:01:00 |  |  |  | 13 |  |  |  |  |  | 13
 | 14 | 06:51:00 | 16:54:00 |  |  |  | 14 |  |  |  |  |  | 14
 | 15 | 06:54:00 | 17:00:00 |  |  |  | 15 |  |  |  |  |  | 15
 | 16 | 06:57:00 | 16:30:00 |  |  |  | 16 |  |  |  |  |  | 16
 | 17 |  |  |  |  |  | 17 |  |  |  |  |  | 17
 | 18 |  |  |  |  |  | 18 |  |  |  |  |  | 18
 | 19 | 06:55:00 | 17:02:00 |  |  |  | 19 |  |  |  |  |  | 19
 | 20 | 06:53:00 | 16:55:00 |  |  |  | 20 |  |  |  |  |  | 20
 | 21 | 06:55:00 | 17:00:00 |  |  |  | 21 |  |  |  |  |  | 21
 | 22 | 06:54:00 | 16:55:00 |  |  |  | 22 |  |  |  |  |  | 22
 | 23 | 06:56:00 | 16:27:00 |  |  |  | 23 |  |  |  |  |  | 23
 | 24 |  |  |  |  |  | 24 |  |  |  |  |  | 24
 | 25 |  |  |  |  |  | 25 |  |  |  |  |  | 25
 | 26 | 06:55:00 | 16:56:00 |  |  |  | 26 |  |  |  |  |  | 26
 | 27 | 06:51:00 | 16:27:00 |  |  |  | 27 |  |  |  |  |  | 27
 | 28 | 06:53:00 | 16:17:00 |  |  |  | 28 |  |  |  |  |  | 28
 | 29 | 06:49:00 | 15:57:00 |  |  |  | 29 |  |  |  |  |  | 29
 | 30 | 06:49:00 | 15:20:00 |  |  |  | 30 |  |  |  |  |  | 30
 | 31 |  |  |  |  |  |  |  |  |  |  |  | 31
 | Total |  |  |  |  |  | Total |  |  |  |  |  | Total
 |  | weekday |  |  | weekend |  |  | holiday |  |  | annual leave |  |  | sick leave