tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875062d1721635051-making-list-with-variable-length-detailed-example-set
Sheet: Sheet1

This column contains Code AND Device name and looks like this: First goes Code, then device name which is text | This column gets removed and combined in A column | This Columns contains varaible data.Lenght is always known | In here I need to combine values specifially like this. List places cannot be swapped, because then it is imposible to make a copy to other software.
Code |  | Properties(Alarms) | Combined info
[NAME]: Padėtis |  | Nėra maitinimo
HLA30AA251 Antrinio oro ventiliatoriaus dažnio keitiklis |  | [NAME]
HLA40AA251 Temperatūra |  | Nepasileidžia
 |  | Saugos raktas
 |  | Neišsijungia
 |  | Suveikusi sauga
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-21-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: 0610 Reo Supply

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0610 | Reo Supply |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 3500 | 0 | 3500 |  |  |  | 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
 |  |  |  | Contract Works Sub-Total | 3500 | 0 | 3500 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0610 | Reo Supply |  |  | NET TOTAL | 3500 | 0 | 3500 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 153338d1335877652-populate-base-on-string-of-dates-book1
Sheet: Sheet1

Start | End | 2012-05-01 12:00:00 | 2012-05-02 12:00:00 | 2012-05-03 12:00:00 | 41033.5 | 41034.5 | 41035.5 | 41036.5 | 41037.5 | 41038.5 | 41039.5 | 41040.5 | 41041.5 | 41042.5 | 41043.5 | 41044.5 | 41045.5 | 41046.5 | 2012-05-18 12:00:00 | 2012-05-19 12:00:00 | 2012-05-20 12:00:00 | 2012-05-21 12:00:00 | 2012-05-22 12:00:00 | 2012-05-23 12:00:00 | 2012-05-24 12:00:00 | 2012-05-25 12:00:00 | 2012-05-26 12:00:00 | 2012-05-27 12:00:00 | 2012-05-28 12:00:00 | 2012-05-29 12:00:00 | 2012-05-30 12:00:00 | 2012-05-31 12:00:00
2012-05-01 21:00:00 | 2012-05-01 22:00:00 |  | X
2012-05-03 21:00:00 | 2012-05-04 02:00:00 |  |  |  | X
2012-05-03 21:00:00 | 2012-05-04 07:00:00 |  |  | X | X
41033 | 41035 |  |  | X | X | X | X
2012-05-05 00:00:00 | 2012-05-05 00:00:00 |  |  |  |  | X
2012-05-06 00:45:00 | 2012-05-06 07:00:00 |  |  |  |  |  | X
2012-05-06 10:00:00 | 2012-05-06 15:00:00 |  |  |  |  |  | X | X
41039 | 41039 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  | X
Spreadsheet: 130427d1322288815-formula-to-calculate-the-probability-of-the-next-value-considering-previous-pattern-problem
Sheet: Sheet1

Result
APPLE
APPLE
APPLE
APPLE
APPLE
PEACH
PEACH
PEACH
APPLE
PEACH
APPLE
PEACH
APPLE
PEACH
PEACH
PEACH
PEACH
APPLE
APPLE
 | What is the probability of "APPLE" or "PEACH" to be the next result?
Spreadsheet: 810539d1671841889-issues-with-fantasy-football-flex-position-sample-ffb-dobbs123-
Sheet: Sheet1

POS | PLAYER | PTS
QB | [NAME] | 35.06
RB | [NAME] | 4.9
RB | [NAME] | 10.1
WR | [NAME] | 14.5
WR | [NAME] | 23.3
TE | [NAME] | 1.8
RB | [NAME] | 16.5 | FLEX
WR | [NAME] | 16.4 | FLEX
K | [NAME] | 4
DEF | Denver Broncos | 8
FINAL
RB | [NAME] | 8.4
RB | Sony [NAME] | 0.2
RB | [NAME] | 6.3
WR | [NAME] | 18.4
QB | [NAME] | 25.08
TOTAL
Spreadsheet: 1e72103e-7aee-4349-892f-158b21c63dd5
Sheet: Sheet1

2012 DIVISION 1AA CIF-SS/FORD GIRLS VOLLEYBALL CHAMPIONSHIPS, presented by Farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1ST ROUND |  | 2ND ROUND | QTR FINALS | SEMI-FINALS | FINALS
TUES., NOV. 6 |  | THURS., NOV. 8 | SAT., NOV. 10 | TUES., NOV. 13 | SATURDAY
 |  |  |  |  | NOV. 17
Redondo Union | Bay #1 |  |  |  | SANTIAGO CANYON
 |  | *Redondo Union |  |  | COLLEGE
Bye
*Marlborough | Sunshine #2 |  | Redondo Union
 |  | Newport Harbor | 25-17,25-21,25-19
Newport Harbor | Sunset #3 | 25-21,19-25,27-29
*[NAME] | South Coast #1 | 25-22,15-11 |  | *Redondo Union
 |  | [NAME] |  | 25-13,25-17,15-25
Wilson/Long Beach | Moore #3 | 25-19,13-25,25-21,25-19 |  | 21-25,18-16
*Vista Murrieta | Southwestern #1 |  | *[NAME]
 |  | *Vista Murrieta | 21-25,14-25,25-23 |  | *Redondo Union
Ventura | Channel At-Lg | 25-18,25-22,25-13 | 29-27,15-8
*Corona del Mar | Pacific Coast #1
 |  | Corona del Mar |  |  | 25-21,25-17,25-21
[NAME] | Southwestern #3 | 25-18,25-13,25-17
*Lakewood | Moore #2 |  | *Corona del Mar
 |  | *Lakewood | 25-23,25-17,25-16
[NAME] | Channel #2 | 25-16,25-19,25-23
*Huntington Beach | Sunset #2 |  |  | Corona del Mar
 |  | Huntington Beach |  | 25-17,25-19,24-26
Peninsula | Bay #3 | 21-25,19-25,25-12 |  | 25-23
*[NAME] | Trinity #1 | 25-16,18-16 | [NAME]
 |  | *[NAME] | 25-23,25-21,25-14
[NAME] | South Coast At-Lg | 25-17,25-19,25-14 |  | SATURDAY~~8:00PM~~
*Los Alamitos | Sunset #1
 |  | Los Alamitos |  |  |  | Marymount
Santa Barbara | Channel #3 | 25-12,25-15,25-22 |  |  |  | 25-18,22-25,23-25,
*Poly/Long Beach | Moore #1 |  | Poly/Long Beach |  |  | 25-22,15-13
 |  | *Poly/Long Bch | 19-25,25-22,16-25
Northwood | Pacific Coast #3 | 25-13,25-15,25-16 | 25-19,15-13
*Tesoro | South Coast #2 |  |  | *Tesoro
 |  | Tesoro |  | 25-15,25-17,25-23
Chaparral | Southwestern #2 | 25-11,25-13,25-15
*Santa Margarita | Trinity #2 |  | *Tesoro
 |  | *Santa Margarita | 25-21,22-25,25-17,25-23
Notre Dame Academy | Sunshine #3 | 27-25,18-25,22-25,
*Beckman | Pacific Coast #2 | 25-19,15-10 |  |  | Marymount
 |  | *Lutheran/Or |  |  | 29-27,22-25,25-17,25-21
Lutheran/Orange | Trinity #3 | 24-26,25-20,25-14
*Mira Costa | Bay #2 | 25-21 | Lutheran/Or
 |  | [NAME] | 25-20,18-25,19-25
Mission Viejo | South Coast #3 | 25-16,25-22,25-19 | 25-21,20-18
*[NAME] | Channel #1
 |  | *[NAME] |  | Marymount
Millikan | Moore #4 | 25-23,25-12,25-21 |  | 25-23,25-7,25-13
*Marymount | Sunshine #1 |  | *Marymount
 |  | Marymount | 25-15,22-25,25-19,25-23
[NAME] | Southwestern At-Lg | 25-10,25-15,25-6
*Denotes Host Team
2012 GIRLS VOLLEYBALL DIVISION 1AA
Spreadsheet: 2c99cf5d-54fd-49cf-9d70-4d863caa630c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44357050 | 2014-12-08 13:41:46 | AXIS | 1 | 10 | 7 | 1574436 | Spernatz | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44357219 | 2014-12-08 14:15:05 | ALLIES | 0 | 6 | 10 | 1574436 | Spernatz | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44413071 | 2014-12-12 18:20:42 | ALLIES | 1 | 6 | 5 | 1524381 | komark | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44413279 | 2014-12-12 18:36:31 | AXIS | 1 | 6 | 5 | 1524381 | komark | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44459245 | 2014-12-15 21:22:10 | AXIS | 1 | 7 | 4 | 509176 | arsenal94 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44459515 | 2014-12-15 21:42:31 | ALLIES | 1 | 7 | 4 | 509176 | arsenal94 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44460185 | 2014-12-15 22:22:57 | AXIS | 1 | 6 | 4 | 478428 | Endicott | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44460527 | 2014-12-15 22:39:12 | ALLIES | 0 | 1 | 6 | 478428 | Endicott | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44499811 | 2014-12-18 21:27:42 | AXIS | 1 | 6 | 2 | 524628 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44500148 | 2014-12-18 21:47:30 | ALLIES | 0 | 2 | 6 | 524628 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
Spreadsheet: 727982d1618238772-count-how-many-of-each-site-and-sum-the-numbers-in-the-columns-that-it-refers-too-count-and-sum-numbers
Sheet: Sheet1

 |  |  | Tea | Coffee | Soup | Chocolate | Pop | Water |  |  |  | Total Tea | Total Coffee | Total Soup | Total Chocolate | Total Pop | Total Water
 |  | Site A | 1 | 1 | 1 | 1 | 1 | 1 |  |  | Site A | 4
 |  | Site b | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Site B | 3
 |  | Site c | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Site C | 0
 |  | Site d | 1 | 1 | 1 | 1 | 1 | 1 |  |  | Site D | 10
 |  | Site d | 3 | 3 | 3 | 3 | 3 | 3
 |  | Site b | 2 | 2 | 2 | 2 | 2 | 2
 |  | Site b | 0 | 0 | 0 | 0 | 0 | 0
 |  | Site d | 0 | 0 | 0 | 0 | 0 | 0
 |  | Site A | 0 | 0 | 0 | 0 | 0 | 0
 |  | Site b | 1 | 1 | 1 | 1 | 1 | 1
 |  | Site d | 2 | 2 | 2 | 2 | 2 | 2
 |  | Site A | 3 | 3 | 3 | 3 | 3 | 3
 |  | Site d | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 796691d1663439264-how-to-display-a-result-if-all-the-data-in-a-row-from-table1-and-table2-match-classeur2-hd
Sheet: Feuil1

Branche | Ex1 | Ex2 | Ex3 | Table 1 |  |  |  |  |  | Ex1 | Ex2 | Ex3 | Table 2
 | 1 | 18 | 23 |  |  |  |  |  |  | 12 | 20 | 20
 | 14 | 22 | 28 |  |  |  |  |  |  | 4 | 4 | 4
 | 1 | 18 | 12 |  |  |  |  |  |  | 1 | 18 | 12
 | 0 | 0 | 0 |  |  |  |  |  |  | 12 | 2 | 2
Expected results
Branche | Ex1 | Ex2 | Ex3 | Table3
 | 1 | 18 | 23
 | 14 | 22 | 28
BR | 1 | 18 | 12
 | 0 | 0 | 0
Branche |  | Ex2 | Ex3
 | 1 | 18 | 23
 | 14 | 22 | 28
 | 1 | 18 | 12
 | 0 | 0 | 0
Spreadsheet: 93761d1293539589-how-to-sum-costs-associated-to-a-string-book1-copy
Sheet: Sheet1

Date | Category | Sub-category | Cost
2010-11-27 00:00:00 | Cars | Ferrari | 100
2010-11-27 00:00:00 | Meals | lunch | 1
2010-11-27 00:00:00 | [NAME] | BMW | 15
2010-11-27 00:00:00 | cars | Ferrari | 245
2010-11-27 00:00:00 | [NAME] | Honda | 12
2010-11-27 00:00:00 | meals | dinner | 2
2010-11-28 00:00:00 | cars | toyota | 9
2010-12-07 00:00:00 | Cars | ford | 25
2010-12-08 00:00:00 | [NAME] | Honda | 10
2010-12-09 00:00:00 | Cars | ford | 12
2010-12-10 00:00:00 | Meals | Dinner | 2
2010-12-10 00:00:00 | Meals | Dinner | 2
2010-12-12 00:00:00 | Meals | lunch | 1
1 | What is the total cost of cars in the whole period?
2 | What is the total cost of dinner in the whole period?
3 | What is the total cost of dinner in the December period?
Spreadsheet: 859773d1708019057-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-option-2
Sheet: Batch B21

 |  | Summary of Assessment Outcome  Name of Programme: det  Name of Lecturer- que IV By- win SSO Name- swa
 |  | Batch B21 result Sheet
 |  | Student ID | First Name | Surname | Result Unit 502  IV-win | Result Unit 503   IV-win | 1st Term Progression | Result Unit 417  IV-win | Result Unit 506 IV-win | Result Unit 423 IV-win | 2st Term Progression | Result Unit 426 IV-win | Result Unit 501 IV-win | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Correct Name As pe Passport | Checked by
 |  | 23456 | [NAME] | Sumathi | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 23457 | [NAME] | ARIFA | Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 23458 | Tordai | [NAME] | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  | 2022-12-06 00:00:00 | Student
 |  | 23459 | Porter | Letaif | Pass | Pass | PP | Resit-Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 23460 | Suleman | Ogunbase | Pass | Pass | PP | Resit-Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 23461 | Porter | Packiarajah | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PT | 7 | Yes |  |  |  | yes
 | Withdrawn | 21090 | [NAME] | Khanom | Refer | Refer | PT | Not Submitted | Not Submitted | Not Submitted | PT | Withdrawn | Withdrawn | WD | 0 | WD
 |  | PP= Pass & Progress
 |  | PT= Progress with Trailing
 |  | Total Students |  |  | 28 | 28 |  | 28 | 28 | 28 |  | 27 | 27 | 27 | 20
 |  | Submission |  |  | 28 | 28 |  | 26 | 24 | 24 |  | 20 | 21
 |  | Submission Rate
 |  | Pass |  |  | 27 | 27 |  | 24 | 22 | 23 |  | 20 | 20
 |  | Refer |  |  | 1 | 1 |  | 2 | 2 | 1 |  | 0 | 1
 |  | Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 |  | Not Submitted |  |  | 0 | 0 |  | 2
 |  | Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: SK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Committee Score

COMMITTEE SCORES - RFP 20XX-XX
 |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Vendor 5 | Vendor 6 | Vendor 7 | Vendor 8 | Vendor 9 | Vendor 10
 | Total Possible Score | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
C R I T E R I A
Qualification Requirements
Understanding the Problem | 0
[NAME] | 0
Professional Personnel | 0
Soundness of Approach | 0
Terms and Conditions | 0
Available Facilities | 0
Value Added Services | 0
Evaluation of Costs
Cost Rating | 0
Total Qualification Requirements
Total Cost Data
Total Score
Oral Presentation | 0
Total Score After Oral Presentation
Note:  Cost is a qualitative point value; the committee chair person enters the cost values in the cost rating tabulation form below.
Calculation of Cost Rating Score:
Lowest Vendor Cost - All Bids (same value all columns) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Vendor Cost submitted |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Weight = Lowest Cost / Vendor Cost
Cost Rating =
Spreadsheet: 526049d1499093503-need-dynamic-vlookup-if-possible-without-helper-column-vlookup-problem
Sheet: Sheet1

ID | Created By | Department | New Department | Right Department
2089 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME] | 91838 Vehicle and [NAME] | This is what I get
2090 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME] | 91724 Document Release & Partner Communication | This is what I need from sheet 2
2091 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME]
2092 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME]
Spreadsheet: 825042d1681063439-array-formula-keep-using-the-1st-row-as-reference-formula-help-array-4-1-
Sheet: Explaination

 |  |  |  |  |  |  |  | Else Full month Depreciation
 |  |  |  |  |  |  |  | (No of day in Month * per day (Column H)
 | 1st IF |  |  | 3rd IF |  |  |  |  |  |  |  | 4rd IF |  |  |  | 2st IF
 | (Dep SD>R ED, result 0) |  |  | And(Dep SD<R SD,R ED< Dep ED), |  |  |  |  |  |  |  | And(Dep SD<R SD,R ED< Dep ED), |  |  |  | (Dep ED>R SD, result 0)
 |  |  |  | result = (R ED- Dep SD +1)* per day (Column H) |  |  |  |  |  |  |  | result = (D ED- R SD +1)* per day (Column H)
 |  |  |  |  | Depreciation Start Date |  |  |  |  |  |  | Depreciation End Date
 |  |  |  |  | Column F |  |  |  |  |  |  | Column G
 |  |  | Each Black Line                                             Indicate the start of month till the end of month to be computate the depreciation
 |  |  | Column M to X
 |  |  | Dep SD=Depreciation Start Date
 |  |  | Dep ED=Depreciation End Date
 |  |  | R SD= Reporting month Start Date
 |  |  | R ED=Reporting month End Date
Spreadsheet: 863129d1710694581-please-help-me-calculate-the-maximum-consecutive-negative-value-in-a-column-example
Sheet: Sheet1

5
10
-2
-5
5
2
5
-10
6
4
-11
-2
-5
-3
-7
54
61
-1023
-1
57
33
4
Spreadsheet: 748779d1632336996-adding-a-name-based-on-city-book1
Sheet: Sheet1

Department | City | Days | Shift | FTE | Status
Outpatient | Boise | Sat-Sun | 0600-1430 | 0.4 | ADD NAME HERE BASED ON CITY LISTED IN [NAME]-If city =Boise in cell B10, [NAME] would be automaticly added in F10
Outpatient | Boise | Sat-Sun | 0900-1730 | 0.4 | Open Shift
Outpatient | Boise | Mon-Fri | 0500-1330 | 1
Spreadsheet: 59c0b343-2b28-436e-9732-6f284830c3be
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6267 | 7966 | [NAME] | Peiffer | FRA | 23 | 00:06:30 | 00:01:18 | 00:15:27 | 00:00:56 | 00:19:14 | 1 | 00:43:23
6267 | 7986 | [NAME] | Perkins | USA | 21 | 00:06:41 | 00:02:28 | 00:16:29 | 00:01:11 | 00:18:55 | 2 | 00:45:43
6267 | 40700 | Javier | Merida | ESP | 22 | 00:06:14 | 00:02:58 | 00:19:23 | 00:02:16 | 00:56:23 | 3 | 01:27:12
Spreadsheet: 804104d1667896755-index-and-match-formula-with-2-criteria-inc-nearest-date-sample-index-match
Sheet: Sheet1

 | Part No. | Part Name | No. Ship | 1-C01 | 1-C02 | 1-C03 | 1-C04 | 1-C05 | 1-C06
 |  |  | ETA | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 2022-11-10 00:00:00 | 2022-11-10 00:00:00
 |  |  | Status | Rcv | Rcv | Otw | Otw | Otw | Otw
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  | 0 | 90000 | 0 | 102000 | 0 | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  | 2000 | 1920 | 1560 | 3840 | 3200 | 3000
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  | 0 | 1920 | 2568 | 1920 | 3200 | 3000
 | F210010075 | GREASE MULTEMP 2C194 |  | 30 | 0 | 10 | 0 | 25 | 0
 | F210010058 | [NAME] NO.2 |  | 0 | 0 | 0 | 30 | 0 | 10
 | 8020300141 | SPIRAL SPRING MN |  | 0 | 0 | 100 | 0 | 0 | 100
 | 4535690005 | [NAME] |  | 200 | 0 | 0 | 2000 | 3000 | 0
 | 4038090054 | BRACKET,SEAT TRACK STPR |  | 0 | 0 | 0 | 2400 | 3000 | 0
 | Criteria : | Otw
 | Part No. | Part Name | Qty Otw |  | Qty Otw & Nearest Date
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  |  | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  |  | 3200
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  |  | 3200
 | F210010075 | GREASE MULTEMP 2C194 |  |  | 25
 | F210010058 | [NAME] NO.2 |  |  | 10
 | 8020300141 | SPIRAL SPRING MN |  |  | 100
 | 4535690005 | [NAME] |  |  | 3000
 | 4038090054 | BRACKET,SEAT TRACK STPR |  |  | 3000
Spreadsheet: 601272d1544276946-formula-to-calculate-mtbf-and-mttr-ikk-bd-monitoring-new
Sheet: BD BY WEEK

Equip No | (All)
Row Labels | Count of [NAME] | Sum of Repair Time (Hour)
40 | 144 | 265.8899999999999
41 | 155 | 254.61
42 | 36 | 67.33
43 | 97 | 172.15
44 | 105 | 175.68
45 | 7 | 14.27
46 | 88 | 122.61
47 | 124 | 223.74
48 | 107 | 190.6099999999999
49 | 82 | 110.6799999999999
Grand Total | 945 | 1597.569999999997
Spreadsheet: 823236d1679830745-divide-sum-of-column-with-fixed-value-in-power-pivot-excel-power-pivot-question
Sheet: RAZVOJ

IME | Urna postavka | URE | STROŠEK | DODATEK | [NAME]
[NAME] | 60 | 30
[NAME] | 50 | 30
Aljaž Korent | 40 | 30
[NAME] | 40 | 30
[NAME] | 40 | 15
[NAME] | 40 | 15
Uroš Škripač | 40 | 30
Spreadsheet: 90893d1290597813-excel-2007-if-formula-for-hours-worked-more-or-less-than-regular-hours-time-sheet
Sheet: Sheet 1

TIMESHEET - August 2010
Employee: | [NAME]
Hrly Rate: | 37.49 |  | Regular Hours: | 08:00:00
Date | Day | Start Time | End Time | Total Hours | Lunch 1/2 Hour | Total | Overtime
21/7/2010 | Wednesday | 08:30:00 | 16:00:00 | 07:30:00 | 00:30:00 | 07:00:00 | -1:00
22/7/2010 | Thursday | 08:30:00 | 19:00:00 | 10:30:00 | 00:30:00 | 10:00:00 | 2
24/8/2010 | Tuesday | 08:00:00 | 17:00:00 | 09:00:00 | 00:30:00 | 08:30:00 | 00:30:00
 |  |  | Totals: | 09:00:00 |  | 08:30:00 | 01:30:00
 |  | *** require a IF formula to work out overtime in column H
Spreadsheet: 97089d1296298069-hiding-cells-amptd_test
Sheet: Monthly Score

 | [NAME]
 | Call Stats |  | Frequency | Target | Achieved | MTD
 |  | Calls Answered | Daily |  |  | 180
 |  | AHT | Daily | 360 | 2 | 360 | Less Then
 |  | Talk | Daily | 0.8 | 1 | 0.8 | More Then
 |  | Work | Daily | 0.1 | 2 | 0.1 | Less Then
 |  | Hold | Daily | 0.1 | 2 | 0.1 | Less Then
 |  | Transfers | Daily | 0.1 | 1 | 0.1 | Less Then
 |  | Outbound | Daily | 0.1 | 2 | 0.1 | Less Then
 | Fault Metrics |  | Frequency | Target | Achieved | MTD
 |  | [NAME] | Daily | 0.95 | 1 | 0.95 | More Then
 |  | FDT | Daily | 0.95 | 1 | 0.95 | More Then
 |  | FLC | Daily | 0.33 | 1 | 0.35 | More Then
 |  | Wasted | Daily | 0.05 | 2 | 0.05 | Less Then
 |  | Repeats | Daily | 0.1 | 2 | 0.1 | Less Then
 |  | Truck rate | Daily | 0.45 | 1 | 0.45
 |  | Mobile Compliance | Daily | 0.7 | 1 | 0.7 | More Then
 |  | Appointed | Daily | 0.25 | 1 | 0.25
 |  |  |  |  |  |  | Around
 | Other KPI |  | Frequency | Target | Achieved | MTD | Around
 |  | FTR | Weekly | 0.5 |  | 0
 |  | [NAME] | Daily | 0.95 |  | 0
 |  | NPS | Daily | 0 |  | 0
 |  | Attendance | Daily | 0.96 |  | 0
 | Quality |  | Frequency | Target | Achieved | MTD
 |  | Number Completed | Monthly |  | 0 | 0
 |  | Score |  |  | 0 | 0
 |  | Total Percentage of Achieved Metrics MTD |  |  | 0.5555555555555556
Spreadsheet: 583996d1532903120-formula-to-change-colour-of-cell-instead-of-conditional-formatting-format-cell-number-custom-type
Sheet: Sheet1

Estimated | Actual | Helper
2018-07-29 00:00:00 | 2018-07-28 00:00:00 |  | Formula =IFNA(LOOKUP(B2-A2,{0,4,9},{0,4,10}),"")
2018-07-29 00:00:00 | 2018-07-29 00:00:00 |  | [NAME] Type > [Red][>9]"Red Alert ";[Green][<=3]"On Time ";[Blue]"Warning ";
2018-07-29 00:00:00 | 2018-07-30 00:00:00
2018-07-29 00:00:00 | 2018-07-31 00:00:00
2018-07-29 00:00:00 | 2018-08-01 00:00:00
2018-07-29 00:00:00 | 2018-08-02 00:00:00
2018-07-29 00:00:00 | 2018-08-03 00:00:00
2018-07-29 00:00:00 | 2018-08-04 00:00:00
2018-07-29 00:00:00 | 2018-08-05 00:00:00
2018-07-29 00:00:00 | 2018-08-06 00:00:00
2018-07-29 00:00:00 | 2018-08-07 00:00:00
2018-07-29 00:00:00 | 2018-08-08 00:00:00
2018-07-29 00:00:00 | 2018-08-09 00:00:00
2018-07-29 00:00:00 | 2018-08-10 00:00:00
2018-07-29 00:00:00 | 2018-08-11 00:00:00
2018-07-29 00:00:00 | 2018-08-12 00:00:00
2018-07-29 00:00:00 | 2018-08-13 00:00:00