tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101042d1299193391-excel-2007-revenue-recognition-projections-revenue-projections
Sheet: Sheet3

Product Category |  | Probability | Sales Probability |  | Sales Stage | Probability
Custom |  | 0.1 | 10% (Initial Talks with the Client) |  | 1-Initial contact / Discovery meetings | 0.1
Syndicated |  | 0.5 | 50% (Proposal sent to Client) |  | 2-Outstanding proposal (not delivered) | 0.1
 |  | 0.9 | 90% (Awaiting Signed Agreement) |  | 3-Proposal delivered / In consideration | 0.5
 |  | 1 | 100% (Signed Agreement) |  | 4-Proposal being seriously considered | 0.5
 |  |  |  |  | 5-Terms being negotiated / Verbal agreement | 0.9
 |  |  |  |  | 6-Signed contract / Processing | 1
Spreadsheet: 266278d1379569070-index-and-match-only-if-adjacent-cell-value-is-true-test2
Sheet: Sheet1

Equipment Number | PM Number | PM Ref |  | Equipment Number | PM Number
AB | 12 | 1 |  | AB | 12 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
DE | 23 | 2 |  | DE | 87 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
GH | 45 | 3 |  | GH | 50 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
GH | 78 | 2 |  | JK | 42 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
DE | 87 | 1 |  | MN | 85 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
JK | 42 | 1
AB | 63 | 2
MN | 22 | 2
JK | 86 | 2
MN | 85 | 1
AB | 24 | 3
DE | 13 | 4
GH | 36 | 4
DE | 71 | 3
JK | 98 | 3
GH | 50 | 1
AB | 41 | 4
MN | 69 | 4
JK | 83 | 4
MN | 49 | 3
Spreadsheet: 143144d1330228532-single-criteria-lookup-two-columns-example
Sheet: Sheet1

Room | Name | Room | Name
301 | Name1 | 320 | [NAME] |  | [NAME] | <<<<<Lookup Value
302 | [NAME] | 321 | Name21 |  |  | <<<<<Room No Result
303 | Name3 | 322 | Name22
304 | Name4 | 323 | Name23
305 | Name5 | 324 | Name24
306 | Name6 | 325 | Name25
307 | Name7 | 326 | Name26
308 | Name8 | 327 | Name27
309 | Name9 | 328 | Name28
310 | Name10 | 329 | Name29
311 | Name11 | 330 | Name30
312 | Name12 | 331 | Name31
313 | Name13 | 332 | Name32
314 | Name14 | 333 | Name33
315 | Name15 | 334 | [NAME]
316 | [NAME] | 335 | Name35
317 | Name17 | 336 | Name36
318 | Name18 | 337 | Name37
319 | Name19 | 338 | Name38
Spreadsheet: 688645d1595887050-help-with-sumifs-formula-across-multiple-sheets-sample-worksheet
Sheet: VC

Client Name:
DOB:
Insurance:
Member ID:
Clinician: | SEAN
Dx Code:
Number of Sessions Billed This Year
Submission Claim ID # | DOS | Date Claim Submitted | Total Claim | Carrier Payment
 |  | 2020-06-25 00:00:00 | 175 | 110.57 | Sean
 |  |  |  |  | Sean
 |  | 2020-07-10 00:00:00 | 175 | 110.57 | Sean
 |  |  |  |  | Sean
 |  | Totals:
 |  |  | Billed | Recieved
Spreadsheet: 709939d1608636765-calculate-age-from-dob-calculate-age
Sheet: CALCULATE AGE

 | Name | Date of birth | Age
1 | [NAME] | 1996-06-06 00:00:00
2 | Cecilia | 1983-03-20 00:00:00
3 | [NAME] | 2000-11-16 00:00:00
4 | [NAME] | 1984-08-21 00:00:00
5 | Belinda | 1990-03-30 00:00:00
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
Spreadsheet: 136a0495-172b-4e79-abdd-32612176a58e
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 14
Cuadro 3.23-10-3
[NAME]
Ingresos municipales de la región Sureste por sub-región y provincia, según año, 1998-2007
(Valor en RD$)
[NAME] | Total Ingresos  Región Sur Este | Ingresos según Sub-Región Valdesia | Ingresos según provincia Distrito Nacional | Ingresos según provincia Santo [NAME] | Ingresos según provincia [NAME] | Ingresos según provincia Peravia | Ingresos según [NAME] | Ingresos según [NAME] | Ingresos según Sub-Región del Yuma | Ingresos según [NAME] | Ingresos según [NAME] | Ingresos según [NAME] | Ingresos según provincia [NAME] | Ingresos según provincia Hato Mayor
1998 | 345062167 | 183377233 | … | … | … | 52185718 | 94932371 | 36259144 | 161684934 | 20139675 | 31192250 | 38470055 | 51271108 | 20611846
1999 | 1085339853 | 895784305 | 691301277 | … | … | 59415760 | 106320728 | 38746540 | 189555548 | 24179764 | 38298796 | 47372328 | 57050519 | 22654141
2000 | 369497277 | 196187698 | … | … | … | 66586426 | 83599097 | 46002175 | 173309579 | 24855014 | 50757305 | 43291211 | 34052543 | 20353506
2001 | 415175400 | 208234641 | … | … | 4002231 | 31105097 | 108273079 | 64854234 | 206940759 | 36785256 | 17039531 | 63517346 | 79708863 | 9889763
2002 | 102918813 | 38379713 | … | … | … | 11906394 | 4113343 | 22359976 | 64539100 | 13086175 | 0 | 44648895 | 6022715 | 781315
2003 | 148480852 | 24313870 | … | … | … | 13749620 | 4987860 | 5576390 | 124166982 | 0 | 0 | 57290785 | 66876197 | 0
2004 | 991152014 | 570819923 | … | 13962552 | 1673270 | 155737123 | 285638157 | 113808821 | 420332091 | 37720729 | 136575278 | 135959831 | 74656747 | 35419506
2005 | 1543398818 | 758275159 | … | 146545514 | 69799890 | 180758020 | 230598894 | 130572841 | 785123659 | 104577635 | 197825813 | 128266442 | 278051788 | 76401981
2006 | 3985328478 | 3075167985.15 | 2258215604.96 | 74369271 | 85988182.52 | 174367072.09 | 299875202 | 182352652.58 | 910160492.85 | 69289481.72 | 272570145.52 | 36398513 | 397314306.61 | 134588046
2007P | 79711690529.15 | 55876072469.21 | 3233203895.03 | 28101452982 | 3553654626.33 | 8112805159.06 | 1125141117.79 | 11749814689 | 23835618059.94 | 58706150.34 | 1020827674.86 | 1856883151 | 17396506845.74 | 3502694238
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 119706d1314676394-mid-extracting-each-number-their-respective-category-mid
Sheet: Sheet1

There are 12 series of numbers, separated by comma, in one cell.  The goal is to distribute values tagged as 1 in their respective categories. (See Columns D to N).
 |  |  | Category
Case | Raw Data |  | Peach | Blue | Green | Red | Yellow | Maroon | Black | Gray | White | Orange | Pink
A103 | 0,1,0,0,1,0,0,0,0,0,0,1 |  | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1
A104 | 1,1,1,0,0,1,0,1,1,0,1,0
A105 | 0,0,1,0,0,0,0,0,0,0,0,1
A106 | 0,1,1,0,1,0,1,0,0,0,1,1
A107 | 0,0,0,1,0,0,0,0,0,0,0,1
A108 | 0,0,0,0,0,0,0,0,0,1,0,0
A109 | 0,1,0,1,0,0,0,0,0,1,0,0
A110 | 1,1,1,0,0,0,0,0,0,1,1,1
A111 | 0,1,0,0,1,0,0,0,0,0,0,0
A112 | 1,1,1,0,0,0,0,0,0,0,0,0
A113 | 0,0,1,1,0,0,1,0,0,0,0,0
A114 | 0,0,0,0,0,1,0,1,0,0,0,0
A115 | 0,1,0,0,1,0,0,0,0,0,0,0
A116 | 1,1,0,1,0,1,1,0,0,0,0,1
A117 | 0,1,0,0,0,1,0,1,0,0,0,0
A118 | 0,0,1,0,0,0,0,0,0,0,0,0
A119 | 0,0,0,0,1,1,0,0,1,0,0,0
A120 | 1,1,1,1,1,0,0,0,0,0,0,1
A121 | 0,1,1,0,1,0,1,0,0,0,1,0
A122 | 0,0,1,0,1,0,0,0,0,0,1,0
A123 | 0,0,1,1,0,0,1,0,0,0,0,0
A124 | 0,0,0,0,0,0,0,0,0,0,0,0
A125 | 1,0,1,0,0,0,0,0,0,0,0,0
A126 | 0,1,0,0,0,0,0,0,0,0,0,0
A127 | 0,0,0,0,0,0,0,0,0,0,0,1
A128 | 0,0,0,0,1,1,0,0,0,0,0,1
A129 | 0,0,0,0,0,0,0,0,1,0,0,0
A130 | 0,0,0,0,0,0,0,0,1,0,0,0
A131 | 0,1,1,1,0,0,1,0,0,0,1,0
A132 | 0,0,0,0,0,0,0,0,0,0,0,1
Spreadsheet: paul_y'barbo__28520__WGI LNG Pricing
Sheet: Differentials

 |  | Differentials - Japanese Delivery Prices
 | Malaysia vs. Abu Dhabi | Malaysia vs.  Alaska | Malaysia vs. Australia | Malaysia vs.  Brunei | Malaysia vs. Indonesia | Malaysia vs. Qatar
1995-06-01 00:00:00
1998-05-01 00:00:00
1998-06-01 00:00:00
1998-07-01 00:00:00
1998-08-01 00:00:00
1998-09-01 00:00:00
1998-10-01 00:00:00
1998-11-01 00:00:00
1998-12-01 00:00:00
1999-05-01 00:00:00
1999-06-01 00:00:00
1999-07-01 00:00:00
1999-08-01 00:00:00
1999-09-01 00:00:00
1999-10-01 00:00:00
1999-11-01 00:00:00
1999-12-01 00:00:00
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
2000-04-01 00:00:00
2000-05-01 00:00:00
2000-06-01 00:00:00
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 13 | 13
Index | 6649 | 734 | 7383
Europe/Other | 3020 | 273 | 3293
North America/Asia | 3629 | 461 | 4090
Other | 8 | 29 | 37
TOTAL | 6657 | 776 | 7433
Spreadsheet: dbf47809-670a-4bd5-8dd9-18e08940f629
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8075 | 16450 | [NAME] | Herberger | GER | 0 | 00:26:29 | 00:02:19 | 00:37:54 | 00:01:37 | 00:14:55 | 1 | 01:23:12
8075 | 44567 | [NAME] | Young | GBR | 0 | 00:28:46 | 00:02:37 | 00:49:48 | 00:02:27 | 00:16:27 | 2 | 01:40:02
8075 | 13354 | [NAME] | [NAME] | GBR | 0 | 00:35:36 | 00:02:20 | 00:48:31 | 00:02:54 | [NAME] | 3 | 01:54:19
Spreadsheet: ada6062b-c14d-4ab1-88f0-05cd1919433f
Sheet: South

ATTACHMENT 9 PRICE SCHEDULE
SOUTH COUNTY
 | Service Address:
 | South County Division
 | 500 Third Ave.
 | [NAME], CA 91910
 | MODEL | SERIAL # | [NAME] ID# | OLD ID # | PRICE Base Year | PRICE Year 1 | PRICE Year 2 | PRICE Year 3 | PRICE Year 4
1 | AMANO PIX3000X | 351169987 | 2496 | 10317
2 | WIDMER T-3 | 155317 | 2061 | 77290
3 | WIDMER T-3 | 161144 | 2065 | 10252
4 | WIDMER T-3 | 161148 | 2062 | 10027
5 | [NAME] | 242155 | 2211 | 93191
6 | WIDMER T-3 | 154916 | 2209 | 10912
7 | WIDMER T-3 | 154828 | 2210 | 10779
8 | [NAME] | 379542 | 3504 | 93110
9 | WIDMER T-3 | 155319 | 2058 | 77467
10 | [NAME] | 338597 | 2066 | 77465
11 | WHITAKER ET | 842168CD | 2048 | 76603
12 | WHITAKER | 854872SE | 2049 | 91692
13 | [NAME] | 468704 | 3612
14 | WIDMER N-3 Numbering | 154733 | 3413
15 | [NAME] | 523450 | 3241 | N/A
16 | [NAME] | 523880 | 2443 | N/A
 |  |  | TOTAL *
 |  |  | * transfer these totals to summary sheet
Spreadsheet: 006f820a-ec39-4fe3-88b3-2a0a0ab4d58f
Sheet: Sheet1

ROUNDTABLE MONTH | Roundtable Commissioner Conducting | Set up chairs | Provide Opening Ceremony & Prayer | Provide Song or sparkler during opening | Help with VENTURE Breakout | Help with VARSITY Breakout | Help with SCOUT Breakout | Help with CUB SCOUT Closing | Provide Cracker Barrel
January | Venturing | River | River Oaks | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow | Mtn View
February | Cub Scout | Mtn View | River | River Oaks | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow
March | 11-Yr-Old Leaders | Mtn Shadow | Mtn View | River | River Oaks | W Jordan | W Jordan E | Westland | [NAME]
April | [NAME] | [NAME] | Mtn Shadow | Mtn View | River | River Oaks | W Jordan | W Jordan E | Westland
May | Varsity | Westland | [NAME] | Mtn Shadow | Mtn View | River | River Oaks | W Jordan | W Jordan E
June | Venturing | W Jordan E | Westland | [NAME] | Mtn Shadow | Mtn View | River | River Oaks | W Jordan
August | District Chair | NA | [NAME] | Mt. Vista | NA | NA | NA | NA | NA
September | Cub Scout | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow | Mtn View | River | River Oaks
October | 11-Yr-Old Leaders | River Oaks | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow | Mtn View | River
November | [NAME] | River | River Oaks | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow | Mtn View
December | Varsity | Mtn View | River | River Oaks | W Jordan | W Jordan E | Westland | [NAME] | Mtn Shadow
Note: St. Joseph the Worker  and Mt. Vista Methodist will help with August Stampede; No roundtable in July.
Spreadsheet: 781757d1653522709-possible-multiple-if-functions-sample
Sheet: Sheet13

Tag Number | Sold | Product |  |  | Product | Qty Available
 |  |  |  |  |  |  | I would like a formula that counts how many, for example, trucks are listed in column c and return that value in column G against the right Product -  but only the ones with a No in column B?
56165 | Yes | Truck |  |  | Truck
5146884 | No | Car |  |  | Car
156132 | No | Truck |  |  | Bike
54698 | Yes | Bike |  |  | Scooter
251684 | Yes | Bike
4849 | No | Scooter
Spreadsheet: 142362d1329792724-find-all-occurrences-of-a-name-in-one-column-and-return-data-from-other-columns-sample
Sheet: Sheet1

 | Data |  |  |  | Output
 | Name | Create Date | Delivered Date |  | Name | Report 1 |  | Report 2 |  | Report 3
 | [NAME] | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 |  |  | Created | Delivered | Created | Delivered | Created | Delivered
 | [NAME] | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 |  | [NAME]
 | Fred | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 |  | Fred
 | Sue | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 |  | Sue
 | Sue | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 |  | Julie
 | Fred | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
 | Fred | 2012-01-13 00:00:00 | 2012-01-14 00:00:00
 | [NAME] | 2012-01-11 00:00:00 | 2012-01-12 00:00:00
 | Sue | 2012-01-18 00:00:00 | 2012-01-19 00:00:00
 | [NAME] | 2012-01-19 00:00:00 | 2012-01-20 00:00:00
 | Julie | 2012-01-22 00:00:00 | 2012-01-23 00:00:00
 | Julie | 2012-01-06 00:00:00 | 2012-01-07 00:00:00
 | [NAME] | 2012-01-15 00:00:00 | 2012-01-16 00:00:00
 | [NAME] | 2012-01-20 00:00:00 | 2012-01-21 00:00:00
 | [NAME] | 2012-01-16 00:00:00 | 2012-01-17 00:00:00
 | [NAME] | 2012-01-09 00:00:00 | 2012-01-10 00:00:00
 | Julie | 2012-01-14 00:00:00 | 2012-01-15 00:00:00
 | [NAME] | 2012-01-01 00:00:00 | 2012-01-02 00:00:00
Spreadsheet: 84876d1284981716-avoid-ref-error-when-deleting-data-andrea-test-good
Sheet: Main

STORE | SKU | SKU_DESC | SOH | Scanned | Resolved | [NAME] | Avg. Cost | Ext. Cost | Resolution
 |  |  |  |  |  |  |  |  |  |  | Neg
 |  |  |  |  |  |  |  |  |  |  | Pos
 |  |  |  |  |  |  |  |  |  |  | Total $ | -1539
Spreadsheet: louise_kitchen__23535__1-30
Sheet: Sheet1

Number 1 | Belden
Number 2 | [NAME]
Number 3 | Swerzbin
Number 4 | Calger
Number 5 | Presto
Number 6 | Sturm
Number 7 | Shively
Number 8 | Milnthorp
Number 9 | Motley
Number 10 | [NAME]
Number 11 | Benson
Number 12 | Zufferli
Number 13 | Duran
Number 14 | Martin
Number 15 | [NAME] | ?
Number 16 | Gonzales
Number 17 | Devries
Number 18 | Richter
Number 19 | Davies
Number 20 | Black
Number 21 | [NAME]
Number 22 | Miler
Number 23 | Tycholiz
Number 24 | [NAME]
Number 25 | Wiggs
Number 26 | [NAME]
Number 27 | Luce
Number 28 | [NAME]
Number 29 | [NAME]
Number 30 | [NAME]
Number 31 | Maggi
Number 32 | Vickers
Spreadsheet: 144083d1330703344-time-averages-for-different-names-reviewertimeaverage01
Sheet: Sheet1

First Reviewer | Second Reviewer | Tech to First Reviewer Time | First to Second Reviewer Time
Anne | [NAME] | 8:24:00 | 18:22:00
Anne | [NAME] | 4:52:00 | 20:27:00
Anne | [NAME] | 6:47:00 | 18:18:00
Anne | [NAME] | 6:54:00 | 18:02:00
Anne | [NAME] | 5:52:00 | 17:37:00
Anne | [NAME] | 5:42:00 | 18:11:00
Anne | [NAME] | 6:16:00 | 18:23:00
Anne | [NAME] | 3:36:00 | 20:24:00
[NAME] | [NAME] | 3:26:00 | 22:31:00
[NAME] | [NAME] | 7:25:00 | 18:33:00
[NAME] | [NAME] | 3:20:00 | 23:00:00
[NAME] | [NAME] | 3:34:00 | 21:03:00
[NAME] | [NAME] | 3:18:00 | 21:13:00
[NAME] | [NAME] | 1:10:00 | 22:46:00
[NAME] | [NAME] | 2:20:00 | 21:20:00
[NAME] | [NAME] | 2:30:00 | 22:19:00
[NAME] | [NAME] | 2:05:00 | 22:36:00
[NAME] | [NAME] | 8:49:00 | 23:16:00
[NAME] | [NAME] | 5:02:00 | 0:14:00
[NAME] | [NAME] | 8:25:00 | 23:17:00
[NAME] | [NAME] | 6:16:00 | 0:05:00
[NAME] | [NAME] | 7:45:00 | 23:37:00
[NAME] | [NAME] | 4:53:00 | 1:43:00
[NAME] | [NAME] | 2:53:00 | 2:22:00
[NAME] | [NAME] | 11:13:00 | 1 day, 17:40:00
[NAME] | [NAME] | 9:50:00 | 1 day, 17:58:00
[NAME] | [NAME] | 7:01:00 | 1 day, 17:35:00
[NAME] | [NAME] | 6:13:00 | 1 day, 17:24:00
[NAME] | [NAME] | 3:12:00 | 1 day, 19:57:00
[NAME] | [NAME] | 5:36:00 | 1 day, 17:19:00
[NAME] | [NAME] | 5:10:00 | 1 day, 21:44:00
[NAME] | [NAME] | 4:50:00 | 1 day, 17:31:00
Average - Anne: |  | 6:02:53
Average - Lisa: |  | 3:14:13
Average - Robert: |  | 6:17:34
Average: [NAME]: |  | 6:38:07
Average - Jack: |  | 19:41:51
Average - William: |  | 17:43:20
Average - Patricia: |  | 1 day, 10:19:18
Spreadsheet: 813362d1673697449-calculate-in-a-dynamic-table-number-of-occurrences-each-cell-calculate_occurences
Sheet: Feuil1

 | initial table
 |  | B |  |  |  |  |  | D |  |  | AZ |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  |  | D |  |  | AZ |  | FF
 | A | C |  |  |  |  |  | D |  |  | AZ |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C |  |  |  |  |  | D |  |  | AZ |  | FF
 | A | B |  |  |  |  | A | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | RE |  | FF
 | A | C |  |  |  |  |  | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C |  |  |  |  |  | D |  |  | RE |  | FF
 | A | B |  |  |  |  | A | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | RE |  | FF
 | A | B |  |  |  |  | A | D |  |  | TU |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | TU |  | FF
 | expected result
 | 6 | 4 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 1 |  | 6
Spreadsheet: 165432d1341231138-if-cell-is-y-then-put-rows-information-into-certain-area-of-another-sheet-help-fulldailymold-try-to-copy-to-usage
Sheet: Disa 2

DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 1 | OF | 1
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 5000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:21:00 | 20:31:00 | 20 |  |  |  |  |  | M9999 |  |  |  |  | Y
20:32:00 | 20:42:00 | 20 |  |  |  |  |  | M88888 |  |  |  |  | N
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 2 | OF | 2
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 5000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 3 | OF | 3
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 5000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
Spreadsheet: cb721b89-6bdf-41b2-a3ad-7809e857760f
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
41070013 | 2014-04-20 05:20:42 | ALLIES | 1 | 6 | 4 | 1539140 | Arctic Dragon | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
41070255 | 2014-04-20 05:44:23 | AXIS | 0 | 5 | 6 | 1539140 | Arctic Dragon | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
Spreadsheet: 752963d1635153673-is-it-possible-to-see-how-ths-works-or-copy-re-create-the-formulae-carrots
Sheet: This month

 | REVENUES |  |  |  |  |  | COSTS
 |  |  |  |  |  |  |  |  |  |  | (£)
 | Area (hectares) |  |  |  | 10 |  | Lines / metre |  |  |  | 0.1
 | Field Area (sqm) |  |  |  |  |  | Licensing / metre |  |  |  | 0.02
 | Field Length (m) |  |  |  |  |  | [NAME]
 | Line Separation (metres) |  |  |  | 3 |  | Other |  |  |  | 0
 | Number of lines
 | Total Line Length
 | Weight / metre |  |  |  | 8 |  | Total Costs / metre
 | Yield (tonne)
 |  |  |  |  |  |  | Total Annual Costs
 | Ratio |  |  |  | 0.6 |  | Write-down of initial capex
 | Tonnes |  |  |  |  |  | Total Cost
 |  |  |  |  |  |  | Cost / Tonne
 |  |  |  |  |  |  | Initial Capex
 |  |  |  |  |  |  | One-off installation Cost / hectare |  |  |  | 3000
 |  |  |  |  |  |  | Total Capex
 |  |  |  |  |  |  | Amortisation Period (years) |  |  |  | 10
 | COST/TONNE SENSITIVITY
 | (£) |  | Weight / Metre
 |  |  | 8 |  | 12 | 14 | 16
 | Line / Metre | 0.1 |  | 182.3647364736473 | 151.9706137280395 | 130.2605260526053 | 113.9779602960296
 |  |  | 280.0392539253925 | 224.031403140314 | 186.6928359502617 | 160.02243081451 | 140.0196269626963
 |  |  | 332.1225872587259 | 265.6980698069807 | 221.4150581724839 | 189.7843355764148 | 166.061293629363
 |  |  | 384.2059205920592 | 307.3647364736473 | 256.1372803947062 | 219.5462403383196 | 192.1029602960296
 |  |  | 436.2892539253926 | 349.031403140314 | 290.8595026169284 | 249.3081451002243 | 218.1446269626963
 |  |  | 488.372587258726 | 390.6980698069808 | 325.5817248391506 | 279.0700498621291 | 244.186293629363
 |  |  | 540.4559205920593 | 432.3647364736474 | 360.3039470613729 | 308.8319546240339 | 270.2279602960297
 |  |  | 592.5392539253926 | 474.031403140314 | 395.026169283595 | 338.5938593859386 | 296.2696269626963
 |  |  | 644.622587258726 | 515.6980698069807 | 429.7483915058173 | 368.3557641478434 | 322.311293629363
 |  |  | 696.7059205920593 | 557.3647364736473 | 464.4706137280395 | 398.1176689097481 | 348.3529602960297
 |  |  | 748.7892539253926 | 599.031403140314 | 499.1928359502617 | 427.8795736716529 | 374.3946269626963
 | NOTE: Blue cells are inputs, black cells are calculated
Spreadsheet: 723304d1615620839-lookup-formula-to-return-sum-value-from-separate-workbook-daily-plod-tracker-test
Sheet: lookups

Machine | rate | Column1 | Location |  | Work type
Excavator 190, 170 | 197 |  | Memphis |  | Clearing
Rockbreaker | 45 |  | [NAME] sth |  | Rehab
Bobcat | 187 |  | [NAME] sth |  | Misc
Loader volvo | 195 |  | [NAME]
Loader [NAME] | 206.5 |  | [NAME]
Traxcavator | 215 |  | Atbara
772 grader | 210 |  | [NAME]
15t tipper | 160 |  | Whirling Dervish Nth
watercart | 175 |  | Whirling Dervish Sth
HV mob | 250 |  | Maingays
LV mob | 95 |  | Enterprise
roller/day | 550 |  | Million Dollar
inductions/standby | 85 |  | Porphyry
labour | 85 |  | Deep South
roadbase - ton | 7 |  | [NAME]
 |  |  | [NAME]
 |  |  | Mt Celia
 |  |  | Far South
 |  |  | Moody's Reward
 |  |  | Yundamindra
 |  |  | [NAME]
 |  |  | Luvironza
 |  |  | Qena
Spreadsheet: 52631d1252490621-filters-and-countif-formula-dummy
Sheet: Data

Surname | Forename | Form | Gender | KS2 (En) | FSM | SEN Stage | Language | Ethnicity | In care | 20. What do you think of ExelForum.com? | 19. I love my life | 18. I hate my life
Franklin | Rich |  | Male | 4 | N |  | ENG | WBRI | N | 1 | 1 | 1 |  |  |  |  | Question | 1s | 2s | 3s | 4s
Henderson | [NAME] |  | Male |  | N |  | ENG | WBRI | N | 2 | 2 | 1 |  |  |  |  | 20 | 4 | 4 | 1 | 1
Silva | [NAME] |  | Female |  | N |  | ENG | REFU | N | 3 | 3 | 3 |  |  |  |  | 19 | 5 | 3 | 2 | 0
White | [NAME] |  | Female |  | N | N | ENG | WBRI | N | 2 | 1 | 2 |  |  |  |  | 18 | 5 | 3 | 1 | 0
[NAME] | [NAME] |  | Female |  | N |  | ENG | WBRI | N | 1 | 2 | 1
Parker | [NAME] |  | Male | 5 | Y | N | ENG | REFU | N | 4 | 2 | 0
Kent | [NAME] |  | Male |  | N | P | ENG | BASI | N | 2 | 1 | 2
Man | [NAME] |  | Male |  | N |  | ENG | WBRI | N | 1 | 1 | 1
[NAME] | Flash |  | Male |  | Y |  | ENG | WBRI | N | 2 | 3 | 1
Woman | Cat |  | Female |  | N | A | ENG | REFU | N | 1 | 1 | 2
Spreadsheet: 766906d1644159914-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-test10-ans-3
Sheet: TAB3

 |  |  |  |  |  |  |  |  | =IFERROR(VALUE('TAB1'!C2),0)+INDEX('TAB2'!$B2:$ZY2,1+2*INT((COLUMNS($B1:B1)-1)/3))
I need the red fixed
Spreadsheet: 690404d1597081329-elapsed-workday-minutes-between-2-date-timestamps-sample
Sheet: Sheet1

UniqueID | EntryTime | Response Date | Minute [m]:ss | Interger Minute |  |  | Holiday
17028499623 | 2020-03-02 17:59:32 | 2020-03-02 18:05:42 |  |  |  |  | 2020-07-04 00:00:00
55198359414 | 2020-03-03 07:11:04 | 2020-03-03 07:11:18
64936242032 | 2020-03-03 08:39:06 | 2020-03-03 08:54:12
80850295561 | 2020-03-03 15:32:39 | 2020-03-03 15:32:52
866741611 | 2020-03-16 15:45:24 | 2020-03-17 06:11:24
76570045712 | 2020-03-22 13:17:12 | 2020-03-30 14:07:19
12391889300 | 2020-04-19 14:36:44 | 2020-05-19 06:54:18
 | 2020-07-03 14:16:21 | 2020-07-06 09:20:23
 | 2020-08-07 00:00:00 | 2020-08-08 00:00:00