tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680487d1591043668-assessment-report-result-formulas-20200-06-01-oeldere-mariyav-1041000-assessment-report-result-formulas-measures-assessment
Sheet: Scores

Result
Fully compliant | 10
Partially compliant | 5
Not implemented | 0
Not applicable | NA
0 | Best practice
0.7 | Very good performance
More than 70% -> Best practice and Less than 70% -> Very good performance.
The answer is for total result of all questions, if i understood your question right.
Fully  Compliant
Almost Fully Compliant
Partially Compliant
Not Implemented
Not Applicable
Not Checked
Fully  Compliant
Almost Fully Compliant
Major
Not Applicable
Not Checked
Spreadsheet: 848383d1699104467-nth-largest-value-with-criteria-ignore-duplicates-nth-largest
Sheet: Sheet1

1 | 25 |  |  | nth | largest + ignore duplicate + criteria
1 | 40 |  |  | 1
1 | 40 |  |  | 2 | 30
2 | 25 |  |  | 3 | 25
2 | 15 |  |  | 4 | 15
2 | 30
2 | 35
2 | 35
2 | 30
2 | 25
2 | 15
2 | 30
Spreadsheet: 882471d1730861435-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r1
Sheet: Aug

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value
[NAME] | [NAME] | I am submitting a student timetable
[NAME] | [NAME] | I am submitting a student timetable
[NAME] | [NAME] | I am submitting a student timetable
[NAME] | [NAME] | I have completed today's training | 2022-08-16 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am submitting a student progress report | 2022-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | 10 | 1 | 10
[NAME] | [NAME] | I have completed today's training | 2022-08-22 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1 | [NAME] | 0.5 |  |  |  | 31.5
[NAME] | Amanda [NAME] | I am notifying the date/time of a TNA | 2022-09-02 00:00:00 | Student to Trainer
[NAME] | [NAME] | I have completed today's training | 2022-08-23 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
Spreadsheet: 67335d1267960531-index-match-lookup-problem-door_lists-v2
Sheet: Doors

 | Type of Door |  | Amount | Height of Door | [NAME] of door |  | $
 | Laminate |  | 1 | 800 | 400 |  |  |  | This is what I have now which works on 1 table at a time
 | Select |  |  | 800 | 498 |  |  |  | This is what I want to do accessing all the tables through the drop down at cell B5
 | Select |  |  | 800 | 498
 | Select |  |  | 800 | 498
 | Laminate |  | 1 | 800 | 498
 | Select |  |  | 800 | 498
 |  |  |  |  |  | Total
Spreadsheet: 75252d1275838197-solved-auto-sum-with-date-dependency-book1
Sheet: Sheet1

Raw data
Date | Profits |  |  |  |  |  |  |  | Profits by Month
2009-09-07 00:00:00 | 10 |  |  |  |  |  |  |  | 2009-09-01 00:00:00 |  | [NAME] in column K to scan column A and sum those in red for moth of Sep 09
2009-09-07 00:00:00 | -2 |  |  |  |  |  |  |  | 2009-10-01 00:00:00 |  | [NAME] in column K to scan column A and sum those in red for moth of Oct 09
2009-09-08 00:00:00 | 5 |  |  |  |  |  |  |  | 2009-11-01 00:00:00 |  | …
2009-09-08 12:15:27 | 1 |  |  |  |  |  |  |  | 2009-12-01 00:00:00 |  | …
2009-09-08 12:54:42 | 4 |  |  |  |  |  |  |  | 2010-01-01 00:00:00 |  | …
2009-09-08 12:54:42 | 7 |  |  |  |  |  |  |  | 2010-02-01 00:00:00
2009-09-08 12:54:42 | -5 |  |  |  |  |  |  |  | 2010-03-01 00:00:00
2009-09-09 00:00:00 | -2 |  |  |  |  |  |  |  | 2010-04-01 00:00:00
2009-09-09 00:00:00 | -10 |  |  |  |  |  |  |  | 2010-05-01 00:00:00
2009-09-09 00:00:00 | -20 |  |  |  |  |  |  |  | 2010-06-01 00:00:00
2009-09-09 04:15:08 | 4 |  |  |  |  |  |  |  | 2010-07-01 00:00:00
2009-09-10 08:50:17 | 12 |  |  |  |  |  |  |  | 2010-08-01 00:00:00
2009-09-10 08:50:17 | 26 |  |  |  |  |  |  |  | 2010-09-01 00:00:00
2009-09-10 13:39:33 | 30 |  |  |  |  |  |  |  | 2010-10-01 00:00:00
2009-09-10 13:39:33 | 12 |  |  |  |  |  |  |  | 2010-11-01 00:00:00
2009-09-10 13:39:33 | 44 |  |  |  |  |  |  |  | 2010-12-01 00:00:00
2009-09-14 07:40:17 | 11
2009-09-14 07:40:17 | 19
2009-09-14 07:40:17 | -34 |  |  |  |  |  |  |  | As you can see, certain months there are more number of records than others and some months zero.
2009-09-14 09:10:08 | -55
2009-09-14 10:31:58 | -10
2009-09-15 15:27:52 | 15
2009-09-15 15:36:12 | -22
2009-09-18 00:41:32 | -1
2009-09-18 08:16:29 | 9
2009-09-24 06:20:03 | 23
2009-09-30 08:12:40 | 14
2009-09-30 14:50:13 | 5
2009-10-07 01:06:12 | 9
2009-10-08 04:23:40 | 1
2009-10-08 07:49:59 | -10
2009-10-19 14:38:00 | -20
2010-01-20 14:27:12 | 32
2010-03-31 14:47:39 | 12
2010-04-23 11:57:58 | 55
2010-05-20 00:15:59 | 41
2010-05-31 00:21:50 | -20
2010-05-31 14:37:25 | 12
2010-06-01 00:00:00 | 34
2010-06-02 10:31:31 | 32
2010-06-03 00:00:00 | 12
2010-06-03 00:00:00 | 45
2010-06-03 00:00:00 | -22
2010-06-04 00:00:00 | -16
2010-06-04 00:00:00 | 12
Spreadsheet: 146146d1331921533-price-grid-index-lookup-match-windows-check-sheet-2012
Sheet: Price List

1 |  | [NAME]
 | Height | 100 | 200 | 300 | 400 | 500
 | 100 | 200 | 300 | 400 | 500 | 600
 | 200 | 300 | 400 | 500 | 600 | 700
 | 300 | 400 | 500 | 600 | 700 | 800
 | 400 | 500 | 600 | 700 | 800 | 900
 | 500 | 600 | 700 | 800 | 900 | 1000
2 |  | [NAME]
 | Height | 100 | 200 | 300 | 400 | 500
 | 100 | 300 | 400 | 500 | 600 | 700
 | 200 | 400 | 500 | 600 | 700 | 800
 | 300 | 500 | 600 | 700 | 800 | 900
 | 400 | 600 | 700 | 800 | 900 | 1000
 | 500 | 700 | 800 | 900 | 1000 | 1100
Spreadsheet: 491666d1480591598-count-consecutive-cells-matching-string-start-after-3-example-consecutive-cells-after-third
Sheet: Sheet1

 | Entries |  |  |  |  |  |  |  |  | Result
 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 |  |  |  | count consecutive cells matching 1 start counting after 3
 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 2
 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 2 |  |  |  | as shown on a row 9 - there are 9 consecutive times the number 1
 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 |  |  |  | the result is 6 because it should count only after the 3rd consecutive number 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 |  |  |  | on row 10 is counting again only after the 3rd consecutive number 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 |  |  |  | there are 2 consecutive entries with another number between them and it should be considered as two different consecutive entries of 1 - so the result should be 2
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | additionally on row number 11 are shown 2 consecutive entries with blank cell between them should be also considered as 1 consecutive entry
 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 5
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Angels

Los Angeles Angels | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Los Angeles Angels | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods |  |  |  |  |  |  |  | Wild Card Winner | 0.5
Personnel
Adams, [NAME] | ML | ML | ML | ML | ML | ML |  | Income
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -0.4
Frederickson, [NAME] | ML | ML | ML | ML | ML | ML |  | From Blue Jays | -0.9
Gutierrez, [NAME] | ML | ML | ML | ML | ML | ML |  | From Diamondbacks | -0.3
[NAME] | ML | ML | ML | ML | ML | ML |  | From Indians | -3.2
Badenhop, [NAME] | ML | ML | ML | ML | ML | ML |  | From Padres |  | -0.3
Below, [NAME] | ML | ML | ML | ML | ML | ML |  | From Phillies | -1
Bourgeois, [NAME] | ML | ML | ML | ML | ML | ML |  | From Twins | -18.8 | -4.2 | -4.1
Bray, Stephen | ML | ML | ML | ML | ML | ML |  | From White Sox | -0.4
Carroll, [NAME] | ML | ML | ML | ML | ML | ML
Castillo, Wilkin | ML | ML | ML | ML | ML | ML |  | Expenses
Colvin, Tyler | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 6.9
Daeges, [NAME] | ML | ML | ML | ML | ML | ML |  | Jennings, [NAME] | 0.9 | 0.9
[NAME], Argenis | ML | ML | ML | ML | ML | ML |  | Ledezma, Wil | 0.1 | 0.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Athletics | 4 | 3
Griffith, [NAME] | ML | ML | ML | ML | ML | ML |  | To Braves | 0.3 | 0.3
Hardy, Rowdy | ML | ML | ML | ML | ML | ML |  | To Cubs | 6.2 | 8.1 | 8.1
Hoffpauir, [NAME] | ML | ML | ML | ML | ML | ML |  | To Mariners |  | 0.5
Hynick, [NAME] | ML | ML | ML | ML | ML | ML |  | To Red Sox | 0.1
Newmann, [NAME] | ML | ML | ML | ML | ML | ML |  | To Twins | 0.5 | 0.3 |  |  | 0.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Salmon, [NAME] | ML | ML | ML | ML | ML | ML
Santana, Cristian | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Tobin, Mason | ML | ML | ML | ML | ML | ML
Walters, P.J. | ML | ML | ML | ML | ML | ML
Ortiz, [NAME] | 21.1 | 21.1 | 21.1
[NAME], Oliver | 18.8 | 18.8 | 18.8
Matsuzaka, [NAME] | 17.6 | 17.6 | 17.6
Matsui, Hideki | 9.9 | 9.9 | 9.9
Encarnacion, [NAME] | 4.1 | A3
Ramirez, Hanley | 3 | A2 | A3
[NAME], [NAME] | 2.2 | 2.2 | 2.2
Crisp, Coco | 2.1 | 2.1 | 2.1
[NAME], [NAME] | 1.9 | 1.9 | 1.9 | 1.9
Freel, [NAME] | 1.5 | 1.5 | 1.5
Sowers, [NAME] | 1.3 | A2 | A3
[NAME], Ray | 1
Casilla, [NAME] | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.5 | A
Padilla, Vicente | 0.5 | A
Park, [NAME] | 0.5 | A
Mota, [NAME] | 0.3
Schierholtz, Nate | 0.3 | 0.7 | A1 | A2 | A3
Slowey, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.2 | 0.2 | 0.2
Mulder, [NAME] | 0.1 | 0.1
Lohse, [NAME] | 0.1
Spreadsheet: daren_farmer__5932__EI305reveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/08/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | EI 305 | 3800 | 0.1392 |  |  | 3271
1st of month DBQ = 3280/d
Spreadsheet: 1a64db91-ab97-4b32-9961-0f0bbb70d76b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CERE | Test | CERE | Ceruloplasmin, Serum | Ceruloplasmin, S | Immunoturbidimetric Assay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Fasting (4 hours preferred, nonfasting acceptable). Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Males 0-17 years: 14.0-41.0 mg/dL > or =18 years: 15.0-30.0 mg/dL Females 0-17 years: 14.0-41.0 mg/dL > or =18 years: 16.0-45.0 mg/dL | Monday through Saturday; Continuously | 1 day (not reported on Sunday) | 3 days | 1 | 82390 |  |  |  |  | Rochester
CERE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CERE | Result | CERE | Ceruloplasmin, S | Ceruloplasmin, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2064-4 | Ceruloplasmin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | -588471 | -3424486.73 | -1308815 | -6070039.97 | -438897 | -1985482.87
2 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | -5561351.76
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  | 528426.48 |  | 110829
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  | 76232 | -32931.88 | 310990 | 1576085
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 6107723.97
8 |  | Interdesk |  |  |  |  |  |  |  |  |  |  | 3520115 | 13572990
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  | -4703 | -18802.59 | -10117 | -40447.77
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  | -4 | -2017.98 | -7808 | -30479.2 | 7812 | 32497.18
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  | 164105 | 656091.79 | 17922 | 71652.16 | -3425 | -13693.15
14 |  | Cash Out |  |  |  |  |  |  | -188951 | -785761.29 | -10197 |  | -1558
15 |  | Cash In |  |  |  |  |  |  | 110612 | 367074.03 | 7 | 25.34
16 |  | Synthetic Storage |  |  |  |  |  |  | -158916 |  | 22504 | -1044538.62 | 116593 | -250480
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  | -50585 | -202242.42 | -25513 |  | 25514 | 109276.46
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  | 3009 |  | -142107 | -321446
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | -1201634 | -4804132.73 | 1242776 | 4968618.45 | -3395037 | -13573357.93
23 | Fuel: |  |  |  |  |  |  |  | 4703 | 18802.59 | 10117 | 40447.77
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  | 593241 | 1941447.88 | 78899 | 397768.65 | 3902 | -1371.75
25 |  | Demand |  |  |  |  |  |  |  | -2129877.5
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | -6533
 |  | TOTAL
Spreadsheet: 108292d1305306449-adding-a-unique-hyperlinks-to-a-column-quickly-book1-3-day92
Sheet: Sheet1

3-4329 |  |  |  | http://workorder/incident=3-4329 |  | http://workorder/incident
3-4339 |  |  |  | http://workorder/incident=3-4339
3-4342 |  |  |  | http://workorder/incident=3-4342
3-4368 |  |  |  | http://workorder/incident=3-4368
3-4378 |  |  |  | http://workorder/incident=3-4378
3-4379 |  |  |  | http://workorder/incident=3-4379
3-4382 |  |  |  | http://workorder/incident=3-4382
3-4391 |  |  |  | http://workorder/incident=3-4391
3-4400 |  |  |  | http://workorder/incident=3-4400
3-4405 |  |  |  | http://workorder/incident=3-4405
3-4408 |  |  |  | http://workorder/incident=3-4408
3-4421 |  |  |  | http://workorder/incident=3-4421
3-4433 |  |  |  | http://workorder/incident=3-4433
3-4438 |  |  |  | http://workorder/incident=3-4438
3-4441 |  |  |  | http://workorder/incident=3-4441
3-4453 |  |  |  | http://workorder/incident=3-4453
3-4469 |  |  |  | http://workorder/incident=3-4469
3-4474 |  |  |  | http://workorder/incident=3-4474
3-4502 |  |  |  | http://workorder/incident=3-4502
3-4509 |  |  |  | http://workorder/incident=3-4509
3-4512 |  |  |  | http://workorder/incident=3-4512
3-4524 |  |  |  | http://workorder/incident=3-4524
3-4526 |  |  |  | http://workorder/incident=3-4526
3-4529 |  |  |  | http://workorder/incident=3-4529
3-4537 |  |  |  | http://workorder/incident=3-4537
3-4538 |  |  |  | http://workorder/incident=3-4538
3-4540 |  |  |  | http://workorder/incident=3-4540
3-4545 |  |  |  | http://workorder/incident=3-4545
3-4554 |  |  |  | http://workorder/incident=3-4554
3-4574 |  |  |  | http://workorder/incident=3-4574
3-4576 |  |  |  | http://workorder/incident=3-4576
3-4578 |  |  |  | http://workorder/incident=3-4578
3-4582 |  |  |  | http://workorder/incident=3-4582
3-4591 |  |  |  | http://workorder/incident=3-4591
3-4596 |  |  |  | http://workorder/incident=3-4596
3-4604 |  |  |  | http://workorder/incident=3-4604
3-4608 |  |  |  | http://workorder/incident=3-4608
3-4611 |  |  |  | http://workorder/incident=3-4611
3-4612 |  |  |  | http://workorder/incident=3-4612
3-4618 |  |  |  | http://workorder/incident=3-4618
3-4619 |  |  |  | http://workorder/incident=3-4619
3-463- |  |  |  | http://workorder/incident=3-463-
3-4633 |  |  |  | http://workorder/incident=3-4633
3-4634 |  |  |  | http://workorder/incident=3-4634
3-4635 |  |  |  | http://workorder/incident=3-4635
3-4636 |  |  |  | http://workorder/incident=3-4636
3-4644 |  |  |  | http://workorder/incident=3-4644
3-4645 |  |  |  | http://workorder/incident=3-4645
3-4654 |  |  |  | http://workorder/incident=3-4654
3-4655 |  |  |  | http://workorder/incident=3-4655
3-4660 |  |  |  | http://workorder/incident=3-4660
3-4665 |  |  |  | http://workorder/incident=3-4665
3-4671 |  |  |  | http://workorder/incident=3-4671
3-4676 |  |  |  | http://workorder/incident=3-4676
3-4687 |  |  |  | http://workorder/incident=3-4687
3-4690 |  |  |  | http://workorder/incident=3-4690
3-4691 |  |  |  | http://workorder/incident=3-4691
3-4697 |  |  |  | http://workorder/incident=3-4697
3-4705 |  |  |  | http://workorder/incident=3-4705
3-4712 |  |  |  | http://workorder/incident=3-4712
Spreadsheet: 718278d1613067132-how-to-split-1-3-4-5-word-name-into-two-cell-only-test-etaf
Sheet: Sheet2

Name |  | First Name | Last Name |  | First name | Last Name
SOLO |  | SOLO
MD SOLO |  | MD | SOLO
MD SOLO MAHMUD |  | MD SOLO | MAHMUD
MD SOLO [NAME] |  | MD SOLO MAHMUD | [NAME]
Spreadsheet: 765947d1643687744-formula-to-calculate-number-of-days-may-be-too-much-excel-help-2-2-
Sheet: Sheet1

2022
[NAME] | Collection Date | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 |  | Total # Days
2019-06-11 00:00:00
2019-09-11 00:00:00
2019-06-11 00:00:00
2020-04-14 00:00:00 | 2022-01-20 00:00:00
2020-05-05 00:00:00
2021-04-22 00:00:00 | 2022-01-13 00:00:00
2022-01-04 00:00:00
2021-02-04 00:00:00 | 2022-01-07 00:00:00
2021-02-04 00:00:00 | 2022-01-07 00:00:00
2021-02-04 00:00:00 | 2022-01-07 00:00:00
2021-02-04 00:00:00 | 2022-01-07 00:00:00
2021-02-11 00:00:00 | 2022-01-07 00:00:00
2021-02-11 00:00:00 | 2022-01-07 00:00:00
2021-02-11 00:00:00
2021-02-22 00:00:00
2021-02-22 00:00:00 | 2022-01-14 00:00:00
2022-01-12 00:00:00 | 2022-01-28 00:00:00
2021-02-22 00:00:00 | 2022-01-13 00:00:00
2021-02-22 00:00:00
2022-01-23 00:00:00
2021-02-22 00:00:00
2021-02-23 00:00:00
2021-02-22 00:00:00
2021-03-23 00:00:00
2021-03-10 00:00:00
2021-03-15 00:00:00
2021-03-10 00:00:00
2021-03-15 00:00:00
2021-03-15 00:00:00
2021-04-06 00:00:00 | 2022-01-12 00:00:00
2021-04-01 00:00:00 | 2022-01-12 00:00:00
2021-04-06 00:00:00
2021-04-22 00:00:00
2021-04-27 00:00:00
2021-05-13 00:00:00
2021-05-17 00:00:00
2021-05-17 00:00:00
2021-05-17 00:00:00
Spreadsheet: 89224d1288970896-average-example
Sheet: Sheet1

Weeks open | Weeks until repaired |  | This is what I am looking for | or | Some thing that would put this in a new sheet
0 | 4 |  | 4.076 |  | Weeks Open | Average WUR
0 | 5 |  | 4.076 |  | 0 | 4.076
0 | 3 |  | 4.076 |  | 1 | 2.5
0 | 6 |  | 4.076 |  | 2 | 2.2
0 | 3 |  | 4.076 |  | 3 | 1.25
0 | 4 |  | 4.076
0 | 2 |  | 4.076
0 | 4 |  | 4.076
0 | 5 |  | 4.076
0 | 6 |  | 4.076
0 | 4 |  | 4.076
0 | 3 |  | 4.076
0 | 4 |  | 4.076
1 | 3 |  | 2.5
1 | 2 |  | 2.5
1 | 3 |  | 2.5
1 | 3 |  | 2.5
1 | 2 |  | 2.5
1 | 2 |  | 2.5
1 | 3 |  | 2.5
1 | 2 |  | 2.5
2 | 2 |  | 2.2
2 | 1 |  | 2.2
2 | 2 |  | 2.2
2 | 1 |  | 2.2
2 | 2 |  | 2.2
2 | 3 |  | 2.2
2 | 4 |  | 2.2
2 | 3 |  | 2.2
2 | 2 |  | 2.2
2 | 2 |  | 2.2
3 | 1 |  | 1.25
3 | 2 |  | 1.25
3 | 1 |  | 1.25
3 | 1 |  | 1.25
Spreadsheet: 751093d1633870617-formula-to-calculate-amount-based-on-drop-list-budget-d
Sheet: Summary

 | Budget Summary
 | Category Title | March | April | May | June | July | August | September | October | November | December | January | Febuary | TOTAL
 | Advertising and promotion | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bank Charges | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Insurance | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Office Rent | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cleaning material
 | Fuel and oil
 | Stationery
 | Salary | 4500
 | [NAME]
 | Material
 | Phase or Category Title
Spreadsheet: 146801d1332356317-how-to-add-or-subtract-based-on-if-a-number-is-negative-remodel-project
Sheet: Sheet1

 | Items | Allowance | Actual Cost | Difference in Allowance & Actual Cost | Spent | Difference
 | Kitchen and Vanity Cabnets | 8000 | 21158
 | Counter and Sink* | 4000 | 7823
 | Appliances | 2800 | 4386.18 |  | 4386.18
 | Faucets* | 700 | 1024.06 |  | 1024.06
 | Lights/fans/etc.* | 2000
 | floor/wall tile* | 794.45
 | Carpet | 3126.67
 | Hard wood flooring | 3690 |  |  | 500
 | Totals
 | * Cost incomplete |  |  |  | As of: | 2012-03-20 00:00:00
Spreadsheet: 759227d1639429612-vlookup-and-moving-to-a-new-cell-once-cell-contains-nothing-test-inventory
Sheet: INDEX

 |  | Opening | Closing
Beer | Batch | opening | Closing
Lager 50L | 1234 | 10
Lager 50L | 1235 | 15
Lager 50L | 1236 | 20
Lager 30L | 444 | 44
Lager 30L | 488 | 23
Spreadsheet: 713559d1610790267-using-with-two-conditions-derive-the-results-working
Sheet: Sheet1

 | Name | Jan | Feb | Mar
 | A | 12 | 14 | 20
 | B | 17 | 13 | 18
 | C | 15 | 19 | 16
 | Condition 1 | Condition 2 | Required Answer
 | Jan | 15 | C