tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 844807d1696476660-assistance-in-updating-formula-showing-value-error-book3-excel-365-
Sheet: Table of Contents

[NAME] Personal Fortnightly Budget for the 2024 Financial Year
 | 'Table of Contents'!A1
 | 'How to use this Spreadsheet'!A5
 | 'Notices of Copyright Plagiarism'!A5
 | 'NDIS Payments'!A5
 | 'Income, Cash, or Debit Expenses'!B7
 | 'Income, Cash, or Debit Expenses'!A5
 | 'C''link Repayments'!A5
 | 'Home and Utilities'!A5
 | 'Insurance and Financial'!A5
 | 'Emergency Fund'!A5
 | 'Life Savings'!A5
 | 'Debts - Including Credit Cards'!A5
 | 'Personal, Other'!A5
 | Children!A5
 | Miscellaneous!A5
 | 'Assistance Dogs Aus (Savings)'!A5
 | 'Christmas Club'!A5
 | 'Debts - Excluding Credit Cards'!A5
 | 'Transport and Auto'!A5
 | 'Commonwealth Bank of Australia'!A5
 | PCCU!A5
 | 'QANTAS Money'!A5
 | 'Summary (Totals)'!A5
 | 'Records of Payments,Other Notes'!A5
 | 'Fees and [NAME] List'!A5
 | 'Streaming Services Subscription'!A5
 | 'ANZ QANTAS Visa C C Purchases'!A5
 | 'Latitude GEM Visa C C Purchases'!A5
 | 'QANTAS Money C C Purchases'!A5
 | Personal!A5
 | 'Bupa N-E Ambulance Insurance'!A5
 | '[NAME] Insurance'!A5
 | 'Pharmaceutical Expenses'!A5
 | 'Pharmaceutical Expenses (4)'!A5
 | Electricity!A5
 | 'Telstra Services'!A5
 | 'Debts - M E Adair'!A5
 | 'Debts - J E Adair'!A5
 | 'Debts - ATO HELP'!A5
 | 'Debts - ATO SFSS'!A5
 | 'CBA Funds'!A5
 | 'Christmas Club Funds'!A5
 | 'Debts - mybudget.com.au'!A5
 | 'Emergency Funds'!A5
 | 'Life Savings Funds'!A5
 | 'Assistance Dogs Australia'!A5
 | 'Assistance Dogs Aus (Savings 1)'!A5
 | 'Junction Housing Expenses'!A5
 | 'PCCU Funds'!A5
 | 'QANTAS Money Funds'!A5
 | 'Xtra Credit Card Payments'!A5
 | 'Tuition Fees (J Grieger)'!A5
 | 'Tuition Fees (Larkins B)'!A5
 | 'Tuition Fees (Francesca H-T)'!A5
 | 'Tuition Fees ([NAME] Moraa)'!A5
 | 'Tuition Fees (J [NAME]
 | 'Tuition Fees (and Extras)'!A5
 | 'tafeSA or University Fees'!A5
 | 'Mediation Institute Australia'!A5
 | AOFM!A5
 | '[NAME] Services'!A5
 | 'Friends With Benefits (FWB)'!A5
 | '[NAME]
 | 'startingfresh.com.au (Tanya J)'!A5
 | 'Lay-By List'!A5
 | '[NAME] Press'!A5
 | 'Savings (Money in Jar at home)'!A5
 | 'V-lookup Function'!A5
 | 'Income & Cash or [NAME] (2)'!A5
 | 'Home and Utilities (Leap Year)'!A5
 | 'Income & Cash or [NAME] (3)'!A5
 | 'Pharmaceuticals List (2)'!A5
Spreadsheet: 196274d1353941999-vlookup-returning-values-with-the-most-recent-date-vlookup-by-date
Sheet: Sheet1

Table A |  |  |  |  | Table B
ID | Lookup values |  |  |  | ID | Value | Date
244 |  |  |  |  | 244 | 3 | 2012-10-01 00:00:00
255 |  |  |  |  | 244 | 2 | 2012-10-02 00:00:00
266 |  |  |  |  | 245 | 1 | 2012-10-03 00:00:00
 |  |  |  |  | 345 | 1 | 2012-10-04 00:00:00
 |  |  |  |  | 245 | 3 | 2012-10-05 00:00:00
 |  |  |  |  | 255 | 2 | 2012-10-06 00:00:00
In column B i would like to return the value that corresponds to the most recent date. E.g There are 3 instances of 244 in Table B, so I'd like VLOOKUP to return 1 which is the most recent based on date in column H |  |  |  |  | 255 | 2 | 2012-10-07 00:00:00
 |  |  |  |  | 266 | 1 | 2012-10-08 00:00:00
 |  |  |  |  | 266 | 2 | 2012-10-09 00:00:00
 |  |  |  |  | 255 | 3 | 2012-10-10 00:00:00
 |  |  |  |  | 244 | 1 | 2012-10-11 00:00:00
Spreadsheet: 864034d1711380789-formula-to-extract-value-from-sheet-formula-to-extract-value
Sheet: BT8 Intercompany Debtors

Southern & Eastern 8
Eastern 8 | 992005 |  | 1032.8
BR2 | 992005 |  | 0
BR3 | 992005 |  | -2035.56
BR4 | 992005 |  | -3333.6
BR5 | 992005 |  | -1857.8
 | Total |  | -6194.16
 |  |  | 0
Southern | 992005 |  | -5042.4
BP1 | 992005 |  | 2035.56
BP2 | 992005 |  | 9201
 | Total |  | 6194.16
[NAME]
Spreadsheet: 111935d1308163309-average-time-am-pm-when-various-criteria-are-met-sample
Sheet: WEEK 2

CALL LOG: WEEK OF
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7023 | b | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 233 | 2:20:18 | 09:44:00 | 16:47:00 | 258 | 2:58:20 | 07:28:00 | 16:10:00 | 206 | 2:36:50 | 09:51:00 | 18:38:00 | 248 | 2:13:02 | 07:35:00 | 16:42:00
7018 | h | 193 | 4:38:15 | 08:19:00 | 17:00:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 175 | 5:42:54 | 08:11:00 | 16:57:00 | 267 | 4:54:00 | 08:18:00 | 18:49:00 | 196 | 3:45:42 | 08:16:00 | 16:55:00
7011 | e | 129 | 1:48:31 | 12:40:00 | 17:12:00 | 157 | 1:55:52 | 09:00:00 | 16:50:00 | 267 | 4:54:00 | 08:18:00 | 18:49:00 | 241 | 2:56:56 | 09:12:00 | 17:04:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00
7008 | d |  |  |  |  | 267 | 4:54:00 | 08:18:00 | 18:49:00 | 229 | 4:13:09 | 07:59:00 | 16:37:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00
7014 | c | 237 | 3:42:17 | 07:42:00 | 16:49:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 238 | 4:43:29 | 07:58:00 | 16:51:00 | 117 | 1:00:01 | 16:04:00 | 18:53:00 | 171 | 2:54:36 | 08:24:00 | 16:54:00
7016 | g | 267 | 4:54:00 | 08:18:00 | 18:49:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00 |  |  |  |  | 282 | 4:07:49 | 08:23:00 | 18:49:00 | 186 | 4:45:41 | 08:31:00 | 18:40:00
7032 | f | 71 | 1:03:47 | 08:08:00 | 10:57:00 | 185 | 2:54:00 | 08:13:00 | 16:58:00 | 171 | 2:54:36 | 08:24:00 | 16:54:00 | 204 | 3:06:27 | 08:21:00 | 16:56:00 | 229 | 3:21:47 | 08:32:00 | 16:55:00
7013 | j | 105 | 3:45:16 | 08:05:00 | 16:49:00 | 151 | 2:40:58 | 08:18:00 | 16:53:00 | 152 | 4:32:26 | 08:21:00 | 16:22:00 | 281 | 4:22:22 | 08:07:00 | 16:58:00 | 171 | 2:54:36 | 08:24:00 | 16:54:00
7015 | i |  |  |  |  | 219 | 2:54:29 | 07:53:00 | 16:58:00 |  |  |  |  | 299 | 3:33:35 | 08:03:00 | 16:52:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00
7012 | a |  |  |  |  | 241 | 2:56:56 | 09:12:00 | 17:04:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00
COURT TOTALS
COURT AVERAGE
7010 | x | 393 | 5:19:10 | 08:09:00 | 18:42:00 | 338 | 4:37:59 | 08:03:00 | 18:45:00 | 361 | 5:29:16 | 08:07:00 | 18:52:00 |  |  |  |  | 282 | 4:00:05 | 08:17:00 | 18:43:00
7022 | y | 178 | 2:50:43 | 08:11:00 | 16:49:00 | 183 | 3:11:47 | 08:19:00 | 16:55:00 | 279 | 3:27:05 | 08:07:00 | 16:55:00 | 244 | 3:08:18 | 08:09:00 | 16:57:00 | 234 | 3:18:25 | 08:17:00 | 16:51:00
7019 | z | 148 | 2:43:42 | 08:27:00 | 17:05:00 | 186 | 3:07:13 | 10:00:00 | 17:51:00 | 147 | 1:58:55 | 08:14:00 | 17:37:00 | 162 | 2:31:24 | 08:24:00 | 16:40:00 | 220 | 2:57:21 | 08:11:00 | 17:54:00
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 755260d1636739209-how-to-averageifs-last-n-values-based-on-date-and-product-how-to-averageifs-last-n-values-based-on-date-and-product
Sheet: Sheet1

Product | Week | [NAME] |  |  |  | FR formula ↓
BC0002 | 2021-10-10 00:00:00 | 21000 |  | BC0002
BC0006 | 2021-10-03 00:00:00 | 90000 |  | BC0006
BC0006 | 2021-10-17 00:00:00 | 1000 |  | BC0022
BC0006 | 2021-10-31 00:00:00 | 0 |  | BC0086
BC0006 | 2021-11-07 00:00:00 | 82000 |  | BC0109
BC0022 | 2021-10-03 00:00:00 | 81000
BC0022 | 2021-10-10 00:00:00 | 80000
BC0022 | 2021-10-17 00:00:00 | 100000
BC0022 | 2021-10-24 00:00:00 | 59000
BC0022 | 2021-10-31 00:00:00 | 81000
BC0022 | 2021-11-07 00:00:00 | 33000
BC0086 | 2021-10-03 00:00:00 | 82090
BC0086 | 2021-11-07 00:00:00 | 57600
BC0109 | 2021-10-03 00:00:00 | 111725
BC0109 | 2021-10-10 00:00:00 | 105000
BC0109 | 2021-10-17 00:00:00 | 185950
BC0109 | 2021-10-24 00:00:00 | 158975
BC0109 | 2021-10-31 00:00:00 | 161325
BC0109 | 2021-11-07 00:00:00 | 219000
Spreadsheet: 716119d1612041868-populate-weekly-hours-based-on-start-and-end-date-projectresourcing
Sheet: Sheet1

 |  |  |  |  |  | 2021-02-01 00:00:00
 |  |  |  |  |  | 2021-02-06 00:00:00
Role | Name | St Date | En Date | Billable | Std Hours
1 | TBD | 2021-02-01 00:00:00 | 2021-03-26 00:00:00 | Y | 40
Spreadsheet: 60799d1261397632-data-validation-problem-in-excel-problem_datavalidation
Sheet: Sheet1

SL. NO | Description | UNIT BASIC  PRICE | EXCISE DUTY (Amount) | Sales Tax applicable for Supply in Areas of |  |  |  | PACKING & FORWARDING CHARGES (RS.) | FREIGHT (RS.) | TRANSIT INSURANCE (RS.) | OTHER CHARGES (RS.) | TOTAL LANDED VALUE
 |  |  |  | Madhya Pradesh |  | Chhattisgarh |  |  |  |  |  | FOR SUPPLIES IN AREAS OF
 |  |  |  | CST | VAT | CST | VAT |  |  |  |  | MP | C.G.
 |  | (Rs. Each) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.)
1 | [NAME] |  |  | 0
2 | [NAME]
3 | [NAME]
4 | [NAME]
Spreadsheet: 156731d1337429974-min-value-of-column-of-specific-cells-book1
Sheet: results

Part number | Στήλη1 | Στήλη2 | quantities | Στήλη4 | Στήλη5 | quantities in remaining days | Στήλη7 | Στήλη8 | Στήλη9 | in this cell I want the returns |  | final product | Στήλη1 | Στήλη2 | Στήλη3 | Στήλη7
3010061 |  |  | 5000 |  |  |  |  |  |  |  |  | 7061520
 |  |  |  |  |  |  |  |  |  |  |  | 7061610
 |  |  |  |  |  |  |  |  |  |  |  | 7061620
 |  |  |  |  |  |  |  |  |  |  |  | 7066221
 |  |  |  |  |  |  |  |  |  |  |  | 7068210
 |  |  |  |  |  |  |  |  |  |  |  | 7140200
 |  |  |  |  |  |  |  |  |  |  |  | 7090611
 |  |  |  |  |  |  |  |  |  |  |  | 7061610
 |  |  |  |  |  |  |  |  |  |  |  | 7066211
Spreadsheet: 886085d1736081883-get-data-if-the-month-is-less-than-the-month-and-mentioned-above-book2
Sheet: Jan

 | Month | 1
 | Year | 2025
 | Past Bookings
 | Booking No. | Status | No. of Guests | Property | Check-In | Check-Out | Payment Status
 | HMPPXTEY2K |  |  |  | 12/28/2024
 | HMRZ8AKP8Z |  |  |  | 12/22/2024
 | HM2KMWTNCF |  |  |  | 12/21/2024
 | HMYEDJYEQY |  |  |  | 12/21/2024
 | HME5DT349E |  |  |  | 2024-06-12 00:00:00
 | HMFQK5KFYA |  |  |  | 11/13/2024
Spreadsheet: 9f540c43-a00d-4f5e-b8b2-6c81a4489d5b
Sheet: Sheet1

Top PFAM domains overrepresented among 4 lineage specificity groups | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Aspergillus Core | Fisher's Exact | [NAME] core | Fisher's Exact | Affc-specific | Fisher's Exact | Afum-specific | Fisher's Exact
WD domain, G-beta repeat | 6.73e-06 | RNA recognition motif | 0.000801 | acetyltransferase, GNAT family | 1.672e-06 | oxidoreductase, short chain dehydrogenase/reductase family | 2.854e-05
RNA recognition motif | 9.033e-06 | WD domain, G-beta repeat | 0.00124 | [NAME] amylase, catalytic domain | 0.002823 | Ferric reductase like transmembrane component | 0.002145
Helicase conserved C-terminal domain | 1.742e-05 | [NAME] family | 0.006 | Fungal cellulose binding domain | 0.007468 | glycosyl hydrolase, family 18 | 0.002726
SH3 domain | 3.827e-05 | protein kinase domain | 0.00991 | alpha/beta hydrolase fold | 0.01126 | FAD-binding domain | 0.002726
[NAME] family | 5.046e-05 | Mitochondrial carrier protein | 0.0124 | oxidoreductase, short chain dehydrogenase/reductase family | 0.01572 | C6 transcription factor domain | 0.002871
protein kinase domain | 0.0002746 | SH3 domain | 0.0167 | Amidase | 0.0163 | amine oxidase, flavin-containing | 0.003329
[NAME] domain | 0.0004889 | Helicase conserved C-terminal domain | 0.0216 | MFS transporter | 0.03804 | Ankyrin repeat | 0.006469
ATPase family associated with various cellular activities (AAA) | 0.0007474 | Ubiquitin-conjugating enzyme | 0.0331 | ABC transporter, ATP-binding protein | 0.04453 | FAD binding domain | 0.009151
HEAT repeat | 0.0007474 | tetratricopeptide repeat | 0.0343 | ABC-2 type transporter | 0.04702 | NmrA-like family | 0.009987
ATPase, AAA family | 0.001001 | [NAME] domain | 0.0466 | glycosyl hydrolase, family 43 | 0.04702 | MFS transporter | 0.01482
Fisher’s Exact test implemented in EASE within TM4 software package (http://TM4.org)
was used to identify overrepresented PHAM domains.
Spreadsheet: 878566d1725659175-need-formulas-to-get-average-of-monthly-productivity-per-person-productivity-changes_v3
Sheet: Power Query

Average of Value | Attribute.1 (Month) | Attribute.1
 | Sep | Oct | Nov | Dec | Jan | Feb
EMPLOYEES:
Person 1 | 0.6862963613793106 | 0.4321776800000002 | 0.2267930659999999 | 0.2206392199999999 | 0.4868486367741937 | 0.8192307700000004
Person 2 | 0 | 0 | 0 | 0 | 0.7741935483870968 | 1
Person 3 | 0.3951149458620689 | 0.9731182800000002 | 1 | 1 | 1 | 1
Person 4 | 0 | 0 | 0 | 0 | 1 | 1
Person 5 | 0.7828947399999999 | 0.7828947399999999 | 0.7828947399999999 | 0.7828947399999999 | 1 | 1
Person 6 | 1 | 1 | 1 | 1 | 1 | 1
Person 7 | 0 | 0 | 0 | 0 | 1 | 1
Person 8 | 0.3992214251724139 | 0.24583965 | 0.24583965 | 0.24583965 | 0.5402593403225805 | 0.5490101999999998
Person 9 | 0 | 0 | 0 | 0 | 0.7741935483870968 | 1
Person 10 | 0 | 0 | 0 | 0 | 1 | 1
Person 11 | 0.8999999999999996 | 0.8000000000000004 | 0.2711864390000001 | 0.2457627100000001 | 0.4457627100000002 | 0.5728813549999998
Person 12 | 0 | 0 | 0 | 0 | 1 | 1
Person 13 | 0.62861001 | 0.62861001 | 0.664101081 | 0.7469135800000002 | 0.9428514535483873 | 1
Person 14 | 0.01612902999999999 | 0.4921956283870969 | 1 | 1 | 1 | 1
Person 15 | 0 | 0 | 0 | 0 | 0.7419354838709677 | 1
Person 16 | 1 | 1 | 1 | 1 | 1 | 1
Person 17 | 0 | 0 | 0 | 0 | 0.7741935483870968 | 1
Person 18 | 0 | 0 | 0 | 0 | 1 | 1
Person 19 | 0 | 0 | 0 | 0 | 1 | 1
Person 20 | 0.04772080000000001 | 0.2005560187096773 | 1 | 1 | 1 | 1
Person 21 | 0.40625 | 0.6743951612903226 | 1 | 1 | 1 | 1
Person 22 | 0 | 0 | 0 | 0 | 1 | 1
Person 23 | 0 | 0 | 0 | 0 | 1 | 1
Person 24 | 0.24533333 | 0.24533333 | 0.24533333 | 0.24533333 | 0.8295913970967742 | 1
Person 25 | 0 | 0 | 0 | 0 | 1 | 1
Person 26 | 1 | 1 | 1 | 1 | 1 | 1
Person 27 | 1 | 1 | 1 | 1 | 1 | 1
Person 28 | 1 | 1 | 1 | 1 | 1 | 1
Person 29 | 1 | 1 | 1 | 1 | 1 | 1
Person 30 | 1 | 1 | 1 | 1 | 1 | 1
Person 31 | 1 | 1 | 1 | 1 | 1 | 1
Person 32 | 1 | 1 | 1 | 1 | 1 | 1
Person 33 | 1 | 1 | 1 | 1 | 1 | 1
Person 34 | 1 | 1 | 1 | 1 | 1 | 1
Person 35 | 1 | 1 | 1 | 1 | 1 | 1
Person 36 | 1 | 1 | 1 | 1 | 1 | 1
Person 37 | 1 | 1 | 1 | 1 | 1 | 1
Person 38 | 1 | 1 | 1 | 1 | 1 | 1
Person 39 | 1 | 1 | 1 | 1 | 1 | 1
Person 40 | 1 | 1 | 1 | 1 | 1 | 1
Person 41 | 1 | 1 | 1 | 1 | 1 | 1
Person 42 | 1 | 1 | 1 | 1 | 1 | 1
Person 43 | 1 | 1 | 1 | 1 | 1 | 1
Person 44 | 1 | 1 | 1 | 1 | 1 | 1
Person 45 | 1 | 1 | 1 | 1 | 1 | 1
Person 46 | 1 | 1 | 1 | 1 | 1 | 1
Person 47 | 1 | 1 | 1 | 1 | 1 | 1
Person 48 | 1 | 1 | 1 | 1 | 1 | 1
Person 49 | 1 | 1 | 1 | 1 | 1 | 1
Person 50 | 1 | 1 | 1 | 1 | 1 | 1
Person 51 | 1 | 1 | 1 | 1 | 1 | 1
Person 52 | 1 | 1 | 1 | 1 | 1 | 1
Person 53 | 1 | 1 | 1 | 1 | 1 | 1
Person 54 | 1 | 1 | 1 | 1 | 1 | 1
Person 55 | 1 | 1 | 1 | 1 | 1 | 1
Person 56 | 1 | 1 | 1 | 1 | 1 | 1
Person 57 | 1 | 1 | 1 | 1 | 1 | 1
Person 58 | 1 | 1 | 1 | 1 | 1 | 1
Person 59 | 1 | 1 | 1 | 1 | 1 | 1
Person 60 | 1 | 1 | 1 | 1 | 1 | 1
Person 61 | 1 | 1 | 1 | 1 | 1 | 1
Person 62 | 1 | 1 | 1 | 1 | 1 | 1
Person 63 | 1 | 1 | 1 | 1 | 1 | 1
Person 64 | 1 | 1 | 1 | 1 | 1 | 1
Person 65 | 1 | 1 | 1 | 1 | 1 | 1
Person 66 | 1 | 1 | 1 | 1 | 1 | 1
Person 67 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 074a54cf-586e-4c0f-8506-0e7d8a85a27e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | EMERGENCY GENERATOR ANNUAL PM MAINTENANCE | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Date: |  |  |  |  | Manufacturer & Model No.
Site Name: |  |  |  |  | Serial No:
Inspection performed by:
Ö [NAME] |  |  | Readings |  | Ö [NAME] |  |  | Readings
 | Replacement of Fluid/Filters: |  |  |  |  | [NAME]
 | Change Crankcase Oil & Replace Oil Filter |  |  |  |  | Generator Operation (No Load)
 | Inspect and Replace Air Filter |  |  |  |  | Frequency (Hz)
 | Add Radiator Coolant |  |  |  |  | Voltage (Volts)
 | Visual Inspection Checks: |  |  |  |  | Perform Auto Transfer Switch Operational Check:
 | [NAME] (If Applicable) |  |  |  |  | [NAME] under Load
 | Check Battery Voltages |  |  |  |  | Generator Operation (Under Load)
 |  | Stationary Voltage |  |  |  |  | Frequency (Hz)
 |  | Cranking Voltage |  |  |  |  | Voltage (Volts)
 |  | Running Voltage |  |  |  |  | Current (Amps)
 | Battery Charger Operation |  |  |  |  | Check Operation from Transfer Switch
 | Clean & Tighten Baterry Terminals |  |  |  |  |  | Frequency (Hz)
 | Crankcase Oil Level |  |  |  |  |  | Voltage (Volts)
 | Check and Clean Crankcase Breather |  |  |  |  |  | Current (Amps)
 | Check and Clean Radiator |  |  |  |  | Check Unit in Automatic & Breaker Closed
 |  | Coolant Level: |  |  |  | Check Setting on Exerciser Clock
 |  | Coolant Condition |  |  |  |  | Day
 |  | Leaks: |  |  |  |  | Time
 | Belts, Check Condition and Tension |  |  |  |  |  | Duration
 | Hoses, Check Condition and [NAME] |  |  |  |  | Record the Following Information
 | Block Heater Operation |  |  |  |  |  | TDES Engine Start (Sec)
 | Air Filter Condition and Duct Connection |  |  |  |  |  | TDNE Normal to Emergency (Sec)
 | Check Dip Drain on Exhaust |  |  |  |  |  | TDEN Emergency to Normal (Min)
 | Inspect Exhaust Flex Connectors, Hangers & Supports |  |  |  |  |  | TDEC Engine Cool-Down (Min)
 | Check Engine Electrical Connections |  |  |  |  |  | TDOE Off to Emergency (Sec)
 | Perform Engine Running Operational Check: |  |  |  |  |  | DTON Off to Normal (Sec)
 | Check for Leaks: Indicate Results |  |  |  |  | Return All Systems to Normal Operation:
 | Fuel |  |  |  |  | Record Run Time Hour [NAME]
 | Oil |  |  |  |  | Return All Systems to Normal Operation:
 | Coolant |  |  |  |  | Record Follow-up Actions Required
 | Exhaust |  |  |  |  | Record and File Report on All Items Listed Above
 | Check Engine Oil Pressure Gauge Reading (psi)
 | Check Engine Coolant Temperature Gauge Reading (F)
Comments and Recommendations
REPLACEMENT OF FLUIDS AND FILTERS:
VISUAL INSPECTIONS CHECK:
PERFORM ENGINE RUNNING OPERATIONAL CHECKS:
[NAME]:
PERFORM AUTOMATIC TRANSFER SWITCH OPERATIONAL CHECK:
RETURN ALL SYSTEMS TO NORMAL OPERATION:
OTHER OBSERVATION:
Spreadsheet: 831112d1685431585-how-to-use-the-minimum-or-equal-to-50-recursive-subtraction-5-30
Sheet: Sheet1

 |  |  | RESULT
A | 89 |  | A | 50
B | 72 |  | A | 39
C | 15 |  | B | 50
D | 21 |  | B | 22
E | 46 |  | C | 15
F | 165 |  | D | 21
 |  |  | E | 46
 |  |  | F | 50
 |  |  | F | 50
 |  |  | F | 50
 |  |  | F | 15
Spreadsheet: 155169d1336693669-excel-2007-subtract-a-date-range-on-around-or-within-another-date-range-count-days-in-quarter
Sheet: Sheet1

 |  |  |  | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  |  | Q4 |  |  |  | Leaves |  |  |  | Days Absent
FM/SM |  | Program | Name | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Leave | Type | Start Date | End Date | Q1 | Q2 | Q3 | Q4 | Q1 TOTAL | Q2 TOTAL | Q3 TOTAL | Q4 TOTAL
 |  |  | [NAME] |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Sick | 2012-04-01 00:00:00 | 2012-05-01 00:00:00
 |  |  | [NAME] |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Personal | 2012-06-01 00:00:00 | 2012-08-01 00:00:00
 |  |  | Kelly |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Maternity | 2012-11-01 00:00:00 | 2013-02-01 00:00:00
 |  |  | Cathy |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Vacation | 2012-12-01 00:00:00 | 2013-05-01 00:00:00
Spreadsheet: 167082d1341894970-vlookup-only-works-on-row-1-of-data-book1
Sheet: Data Source

Identifier | Part 1 | Part 2 | Part 3 | Percentage
BR5A_CL01\05\05 | BR5A_CL01 | 05 | 05 | 0.1807165331979322
BR5A_CL01\04\06 | BR5A_CL01 | 04 | 06 | 1.021287466518198
BR5A_CL01\03\07 | BR5A_CL01 | 03 | 07 | 1.000632559666901
BR5A_CL01\02\08 | BR5A_CL01 | 02 | 08 | 0.8500354145650447
BR5A_CL01\01\09 | BR5A_CL01 | 01 | 09 | 0.8465884661268931
BR5A_CL01\01\10 | BR5A_CL01 | 01 | 10 | 0.8505942836858523
BR5A_CL01\01\11 | BR5A_CL01 | 01 | 11 | 0.8151941464449196
BR5A_CL01\02\12 | BR5A_CL01 | 02 | 12 | 0.9005864915564752
BR5A_CL01\03\13 | BR5A_CL01 | 03 | 13 | 0.9030974574053944
BR5A_CL01\04\14 | BR5A_CL01 | 04 | 14 | 0.9084689322522398
BR5A_CL01\05\15 | BR5A_CL01 | 05 | 15 | 0.8234946700480906
Spreadsheet: 466358d1466148365-holiday-nigh-shift-time-sheet-computation-sample-632016
Sheet: Sheet1 (2)

ACCOUNT | EMPLOYEE # | EMPLOYEE NAME | BASIC SALARY | HOURLY RATE | FIXED ALLOWANCE
CUTOFF
2016-01-01 00:00:00
 |  |  |  | REGULAR DAY
START DATE | END DATE | SCHEDULE |  | TIME IN | TIME OUT | BREAK | OT START | OT END | BREAK |  |  | REG DAY | REG NIGHT | REG OT | OT ND |  | LATE | UNDERTIME | REG DAY  (# OF DAYS) | REG NIGHT (HOURS) | REG OT | OT ND | HOLIDAY REG (HOURS) | HOLIDAY NIGHT SHIFT (HOURS)
2016-03-16 00:00:00 | 2016-03-16 00:00:00 | 08:00:00 | 17:00:00 | 08:15:00 | 17:00:00 | REG | 08:00:00 | 17:00:00 | REG
2016-03-17 00:00:00 | 2016-03-17 00:00:00 | 14:00:00 | 23:00:00 | 14:00:00 | 23:00:00 |  | 14:00:00 | 23:00:00
2016-03-18 00:00:00 | 2016-03-19 00:00:00 | 22:00:00 | 07:00:00 | 22:00:00 | 07:00:00 |  | 22:00:00 | 07:00:00
2016-03-19 00:00:00 | 2016-03-20 00:00:00 | 23:00:00 | 08:00:00 | 23:00:00 | 08:00:00 |  | 23:00:00 | 08:00:00
2016-03-20 00:00:00 | 2016-03-21 00:00:00 | 23:00:00 | 02:00:00 | 23:00:00 | 02:00:00 |  | 23:00:00 | 02:00:00
2016-03-21 00:00:00 | 2016-03-21 00:00:00 | 01:00:00 | 05:00:00 | 01:00:00 | 05:00:00 |  | 01:00:00 | 05:00:00
2016-03-22 00:00:00 | 2016-03-22 00:00:00 | 01:00:00 | 10:00:00 | 01:00:00 | 10:00:00 |  | 01:00:00 | 10:00:00
2016-03-23 00:00:00 |  | 17:00:00 | 22:00:00 | 17:00:00 | 22:00:00 |  | 17:00:00 | 22:00:00
2016-03-24 00:00:00
2016-03-25 00:00:00
2016-03-26 00:00:00
2016-03-27 00:00:00
2016-03-28 00:00:00
2016-03-29 00:00:00
2016-03-30 00:00:00
2016-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMMARY
Spreadsheet: 865436d1712501303-make-rule-when-passing-date-oeysbrei-samplefile-formula-date
Sheet: Solution

 | Kontroll | Annet arbeid | Arbeid utført | [NAME] kontroll | Varsel neste kontroll | Varsel sendt
 | Årlig |  | 2023-03-02 00:00:00 |  |  | OK
 | Periodisk |  | 2023-03-05 00:00:00 |  |  |  |  | <==Add "OK" here to test
 | Årlig | Ruteskruing
Spreadsheet: 717141d1612509389-conditional-format-cell-with-date-from-previous-month-trial-2
Sheet: Training Title

TrainingCode | Trainingtitle
100 | [NAME] 100
 | [NAME] 101
 | [NAME] 102
 | [NAME] 103
 | Lesson 104
 | [NAME] 105
 | [NAME] 106
 | [NAME] 107
 | [NAME] 108
 | [NAME] 109
 | [NAME] 110
 | [NAME] 111
 | [NAME] 112
 | [NAME] 113
 | [NAME] 114
 | [NAME] 115
 | [NAME] 116
 | [NAME] 117
 | [NAME] 118
 | [NAME] 119
 | [NAME] 120
 | [NAME] 121
 | [NAME] 122
 | [NAME] 123
 | [NAME] 124
 | [NAME] 125
 | [NAME] 126
 | [NAME]
 | [NAME] 128
 | [NAME] 129
 | [NAME] 130
 | [NAME] 131
 | [NAME] 132
 | [NAME] 133
 | [NAME] 134
 | [NAME] 135
 | [NAME] 136
 | [NAME] 137
 | [NAME] 138
 | [NAME] 139
 | [NAME] 140
 | [NAME] 141
 | [NAME] 142
 | [NAME] 143
 | [NAME] 144
 | [NAME] 145
 | [NAME] 146
 | [NAME] 147
 | [NAME] 148
 | [NAME] 149
 | [NAME] 150
 | [NAME] 151
 | [NAME] 152
 | [NAME] 153
 | [NAME] 154
 | [NAME] 155
 | [NAME] 156
 | [NAME] 157
 | [NAME] 158
 | [NAME] 159
 | [NAME] 160
 | [NAME] 161
 | [NAME] 162
 | [NAME] 163
 | [NAME] 164
 | [NAME] 165
 | [NAME] 166
 | [NAME]
 | [NAME] 168
 | [NAME] 169
 | [NAME] 170
 | [NAME] 171
 | [NAME] 172
 | [NAME] 173
 | [NAME] 174
 | [NAME] 175
 | [NAME] 176
 | [NAME] 177
 | [NAME] 178
 | [NAME] 179
 | [NAME] 180
 | [NAME] 181
 | [NAME] 182
 | [NAME] 183
 | [NAME] 184
 | [NAME] 185
 | [NAME] 186
 | [NAME] 187
 | [NAME] 188
 | [NAME] 189
 | [NAME] 190
 | [NAME] 191
 | [NAME] 192
 | [NAME] 193
 | [NAME] 194
 | [NAME] 195
 | [NAME] 196
 | [NAME] 197
 | [NAME] 198
 | [NAME] 199
 | [NAME] 200
 | [NAME] 201
 | [NAME] 202
 | [NAME] 203
 | [NAME] 204
 | [NAME] 205
 | [NAME] 206
 | [NAME] 207
 | [NAME] 208
 | [NAME] 209
 | [NAME] 210
 | [NAME] 211
 | [NAME] 212
 | [NAME] 213
 | [NAME] 214
 | [NAME] 215
 | [NAME] 216