tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148677d1333506886-keep-duplicate-data-example
Sheet: Sheet1

[PHONE] | The Way Things Work: An Illustrated Encyclopedia of Technology | [NAME] (translator) | 1967 | Simon &amp; Schuster
[PHONE] | Mog's Christmas | [NAME] | 1992 | [NAME]
[PHONE] | Liar | [NAME] | 0 | Harpercollins Uk
[PHONE] | Twopence to Cross the Mersey | [NAME] | 1992 | HarperCollins Publishers
[PHONE] | The Prime of Miss [NAME] | [NAME] | 1999 | [NAME]
[PHONE] | The Fighting Man | [NAME] | 1993 | HarperCollins Publishers
[PHONE] | First Among Equals | [NAME] | 2000 | [NAME]
[PHONE] | Matter Of Honour | [NAME] | 2000 | [NAME]
[PHONE] | Kidnapped | [NAME] | 1999 | [NAME]
[PHONE] | Brave New World | Aldous [NAME] | 1999 | [NAME]
[PHONE] | Made in America | [NAME] | 1995 | HarperCollins Publishers
[PHONE] | Nothing Can Be Better | Barns &amp; Budd | 1996 | Atlantic
[PHONE] | Daughters of the Storm | [NAME] | 1996 | HarperCollins Publishers
[PHONE] | [NAME] | [NAME] | 1997 | HarperCollins Publishers
[PHONE] | Sir [NAME] and the Green Knight | [NAME] | 1999 | HarperCollins UK
[PHONE] | [NAME] and Sir [NAME] | [NAME] | 1999 | [NAME]
[PHONE] | Cereus Blooms At Night | [NAME] | 0 | Fairmount Books Ltd Remainders
[PHONE] | [NAME]: And Other Stories | [NAME] | 1999 | [NAME]
[PHONE] | CHESS FOR YOUNG BEGINNERS | [NAME] | 1975 | HarperCollins Publishers
[PHONE] | Paddington in the Kitchen | [NAME] | 1942 | HarperCollins Publishers
[PHONE] | Babe Dressing | [NAME] | 1997 | HarperCollins Publishers
[PHONE] | Which Colour? | [NAME] | 1989 | HarperCollins Publishers
[PHONE] | When It's Time for Bed (Collins Baby &amp; [NAME]) | [NAME] | 1994 | [NAME]
[PHONE] | [NAME] (Collins Baby and Toddler Series) | [NAME] | 1994 | HarperCollins Publishers
[PHONE] | [NAME] Steam Train Journey | [NAME] | 1979 | HarperCollins Publishers
Spreadsheet: geir_solberg__11280__11-17act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 75701d1276255112-lookup-process-information-from-table-example
Sheet: Sheet3

Ammount: | 2 | Resource: | Resource 5 |  | Requires: | 5 | Resource 2 | > | 10 | Resource 1 | > | 5 | Resource 1
 |  |  |  |  |  | 5 | Resource 3 |  | 5 | Resource 2
Ammount: | 1 | Building: | Building 4 |  | Requires: | 3 | Resource 3 | > | 5 | Resource 1 | > | 11 | Resource 1 | > | 16 | Resource 1 | > | 18 | Resource 1
 |  |  |  |  |  | 3 | Resource 4 |  | 3 | Resource 2 |  | 3 | Resource 2 |  | 2 | Resource 2
 |  |  |  |  |  | 2 | Resource 5 |  | 3 | Resource 3 |  | 2 | Resource 3
 |  |  |  |  |  |  |  |  | 2 | Resource 4
Spreadsheet: 170138d1343165770-totaling-up-the-duplicated-info-delete-the-excess-delete-the-rev-from-the-description-2012-07-24-legorgia-oeldere-
Sheet: Blad1

 |  |  | 3 |  | unique cells
 |  | count | count 2
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 1
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 2
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 3
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 4
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 5
179049-101 C 15 FIXED OVERHEAD Rev C |  | 6 | 6
179458-101 A 15 RETRACT REV A |  | 8 | 1
179458-101 A 15 RETRACT REV A |  | 8 | 2
179458-101 A 15 RETRACT REV A |  | 8 | 3
179458-101 A 15 RETRACT REV A |  | 8 | 4
179458-101 A 15 RETRACT REV A |  | 8 | 5
179458-101 A 15 RETRACT REV A |  | 8 | 6
179458-101 A 15 RETRACT REV A |  | 8 | 7
179458-101 A 15 RETRACT REV A |  | 8 | 8
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 1
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 2
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 3
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 4
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 5
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 6
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 7
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 8
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 9
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 10
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B |  | 11 | 11
Spreadsheet: 211305d1359716186-too-many-formulas-causing-slow-process-work-book-to-save-call-register
Sheet: CALLS SUMMARY1

MR 188 CALL REGISTER FOR THE MONTH OF JAN-2013
S NO | [NAME] | CALLS |  | S NO | [NAME] | CALLS
* | TOTAL NUMBER OF CALLS
1 | WARRANTY |  |  |  | NUMBER OF WARRANTY TSI PENDING
2 | TOTAL MANDATORY CALLS |  |  |  | NUMBER OF MANDATORY TSI PENDING
3 | TOTAL CHARGEABLE CALLS |  |  |  | NUMBER OF CHARGEABLE TSI PENDING
4 | TOTAL P M CLINIC CALLS |  |  |  | NUMBER OF P M CLINIC TSI PENDING
5 | TOTAL AMC CALLS |  |  |  | NUMBER OF AMC TSI PENDING
6 | TOTAL GOOD WILL CALLS |  |  |  | NUMBER OF GOOD WILL TSI PENDING
7 | TOTAL EMS CALLS |  |  |  | NUMBER OF EMS TSI PENDING
8 | TOTAL AMC (FOLLOW UP) CALLS |  |  |  | NUMBER OF AMC (FALLOW UP) TSI PENDING
9 | TOTAL CANNCELLED CALLS |  |  |  | TOTAL NUMBER OF CALLS MASTER HAS TO BE CREATE
10 | TOTAL NUMBER OF CALLS (CALL CONTINUE) |  |  |  | TOTAL NUMBER OF TSI NOT PUNCHED
11 | TOTAL NUMBER OF KUC CALLS |  |  |  | TOTAL NUMBER OF KUC TSI PENDING
 |  |  |  |  | TOTAL RC PENDING
Spreadsheet: 838972d1691574047-calculating-the-waiting-time-value-book1-63-ans
Sheet: Sheet1

Delivery Waiting Time (hh:[NAME]) | Daily Waiting Time | Daily Income |  |  | Example of calc | Value | Daily Waiting Time | Daily Income
00:51:00
01:51:00
00:55:00
00:12:00
01:30:00
00:55:00
00:43:00
00:58:00
00:55:00
02:35:00
I can not enter the helper columns (F to I) as the data comes from an external source.
If a vehicle has to wait longer than 45 mins to make a delivery,  we are paid £0.36 for each minute above the 0:45
If a value in Column A is above 0:45, then deduct 0:45
Then sum all values above 0:00 in the range A3:A12 and put the result in B3
Then multiply B3 by £0.36 to give me a  daily total payment due in C3.
Spreadsheet: 123847d1317900090-excel-2007-sort-data-whilst-ignoring-blank-cells-code_solution
Sheet: Sheet1

Title | Fiscal year | Period | JL reference | JL amount | 1e-07 | Period check | Sort CODE | Sort period check | Desired result |  |  | Select period | FY | Period |  |  |  |  |  |  |  |  |  | 1004
XY100102/940.47 EUR | FY10 | P01 |  |  |  |  |  |  | 1008S_2 |  |  | 1008 |  |  |  |  |  |  |  |  |  |  |  | 1005
[NAME] | FY10 | P05 |  |  |  |  |  |  | 1008S_3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1008
XY100504/118557.03 EUR | FY10 | P05 |  |  |  |  |  |  | XY100801
[NAME] | FY10 | P04 |  |  |  |  |  |  | XY100808
XY100406/976.73 EUR | FY10 | P05 |  |  |  |  |  |  | XY100809
XY100407/719.28 EUR | FY10 | P04 |  |  |  |  |  |  | blank cell
XY100808/24086.06 EUR | FY10 | P08 |  |  |  |  |  |  | blank cell
XY100809/47156.10 EUR | FY10 | P08 |  |  |  |  |  |  | blank cell
XY100801/295.55 EUR | FY10 | P08 |  |  |  |  |  |  | blank cell
1008S_2/9,932.87 EUR / Reversible (weekly) | FY10 | P08 |  |  |  |  |  |  | blank cell
1008S_3/23,173.33 EUR / Non-reversible | FY10 | P08 |  |  |  |  |  |  | blank cell
1004S_4/20,820.74 EUR / Reversible (weekly) | FY10 | P04 |  |  |  |  |  |  | blank cell
1004S_19/2,247.10 EUR / Non-reversible | FY10 | P04 |  |  |  |  |  |  | blank cell
1004S_6/31,480.32 EUR / Reversible (weekly) | FY10 | P04 |  |  |  |  |  |  | blank cell
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -91998
3531 | -330799 | -331850
60667 |  | -292138
60749 | 46177 | -266798
61206
61334 | -238070
62960
INDEX
2000-11-30 00:00:00 |  |  | 52631.01
2000-12-11 00:00:00
Spreadsheet: 768856d1645170765-sumproduct-formula-to-count-multiple-text-excel-helpsumproductand-substiute
Sheet: Sheet1

Vehicle | Operator | Driver | Labourer | Number in Crew | Contract | Depot |  | No. nights accom | TM Days | m3       Monday | m3       Tuesday | m3 Wednesday | m3     Thursday | m3            Friday | m3      Saturday | m3         Sunday | Total Output m3 | CONTRACT PERFORMANCE | CONTRACT PERFORMANCE
V9 VPL |  |  |  |  | Norfolk |  |  |  |  | X | X | X | X | X | X | X |  | MACHINES OUT
V11 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | Weekly Combined              Contract Profit
V15 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL  PROFIT
V16 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAYS WORKED
V18 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAYS LOST
V21 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAILY AVERAGE M3
V24 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK PROFIT
V25 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAYS WORKED
V26 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAYS LOST
V27 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAILY AVERAGE M3
V28 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | HEREFORD PROFIT
V29 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | HEREFORD DAYS WORKED
V30 VPL |  |  |  |  | Cornwall |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X |  | HEREFORD DAYS LOST
V31 VPL |  |  |  |  | [NAME] |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X |  | [NAME] AVERAGE M3
V33 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V40 VPL |  |  |  |  | Norfolk |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X
[NAME] |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V50 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
GN59 GXE |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
KY60 WUP |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V66 VPL mon-tue |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V77 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V60 VPL |  |  |  |  | Cornwall |  |  |  |  | WEATHER | WEATHER | X | X | X | X | X
SJ12 XVB |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V55 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V66 VPL wed-thur |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
[NAME] fri-sat |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V30 VPL fri - sat |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V9 VPL fri |  |  |  |  | Norfolk |  |  |  |  | WEATHER | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
Spreadsheet: john_lavorato__16606__NEPCO Projects (updated)
Sheet: Sheet1

 |  |  |  |  | Revised Version - Updated for Profitability
NEPCO - Outstanding Projects
 |  |  | Percentage
Name | Capacity | Contract Amount | Completed* | Completion Date | Comments
[NAME] (Arkansas) | 2,200 MW CCGT | $800.1MM | 0.49 | May 2003 | Expected profit of $52.2MM
[NAME] (Arizona) | 2,200 MW CCGT | $881.4MM | 0.27 | August 2003 | Expected profit of $52.7MM
[NAME] (Illinois) | 1,100 MW CCGT | $508.1MM | 0.26 | September 2003 | Joint Venture with PCL; 100% of revenues shown; expected profit of $15.0MM
LSP Kendall (Illinois) | 1,100 MW CCGT | $246.8MM | 0.74 | May 2002 | Joint Venture with [NAME]; only NEPCO's revenues shown;
 |  |  |  |  | expected loss of ($33.4MM)
Cogentrix Green Power (Oklahoma) | 820 MW CCGT | 283.1MM | 0.98 | December 2001 | Expected loss of ($10.5MM)
Cogentrix Southhaven (Mississippi) | 820 MW CCGT | $327.0MM | 0.36 | July 2003 | Expected profit of $14.0MM
[NAME] (Louisiana) | 820 MW CCGT | $327.9MM | 0.8 | July 2002 | Expected profit of $10.7MM
AES [NAME] (Texas) | [NAME] | $298.9MM | 0.79 | August 2002 | Expected profit of 11.2MM
[NAME] (Arkansas) | 600MW CCGT | $237.7MM | 0.65 | October 2002 | Expected profit of $12.9MM
TPS McAdams (Mississippi) | 600MW CCGT | $238.4MM | 0.65 | October 2002 | Expected profit of $12.0MM
Coyote Springs (Oregon) | 280MW CCGT | $122.7MM** | 0.76 | June 2002 | Expected profit of 4.4MM
Goldendale (Washington) | [NAME] | $149.3MM | 0.73 | July 2002 | Expected profit of $12.9MM
Fountain Valley (Colorado) | 240MW Simple Cycle | $140.0MM | 1 | September 2001 | Expected completion in October 2001 with proit of $16.9MM
Lake Worth (Florida) | 200MW CCGT Addition | $120.0MM | 0.32 | June 2003 | Expected profit of $8.7MM
Linden 6 (New Jersey) | 172MW Dual Fuel Cogen | $92.8MM | 0.97 | October 2001 | Expected completion December 2001; expected loss of ($8.5MM)
*As of September 30, 2001; includes procurement in percentage completed calculation
**Excludes Turbine
N.B.  LSP Kendall, Cogentrix Green Power, and Linden 6 are projected to post aggregate losses of approximately $52MM; all other projects are projected to be profitable (percentage completed multipled
by expected total profit has been recognized as income to date under percentage of completion accounting)
Spreadsheet: a597bab2-acf7-448a-8cc4-8f8221ae2936
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8766 | 46068 | Carmela | Vergura | ITA | 128 | 00:18:54 | 00:00:35 | 00:36:35 | 00:01:46 | [NAME] | 1 | 01:19:27
8766 | 10324 | [NAME] | [NAME] | ITA | 127 | 00:21:48 | 00:00:36 | 00:37:51 | 00:02:07 | 00:23:06 | 2 | 01:25:30
Spreadsheet: 686872d1594843833-excel-dynamic-formula-to-calculate-ramp-production-based-on-onboarding-ramp-up-plan
Sheet: Refer

Ramp | Ramp%
1 | 0.05
2 | 0.1
3 | 0.15
4 | 0.2
5 | 0.3
6 | 0.4
7 | 0.5
8 | 0.6
9 | 0.7
10 | 0.8
11 | 0.9
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1
17 | 1
18 | 1
19 | 1
20 | 1
21 | 1
22 | 1
23 | 1
24 | 1
25 | 1
26 | 1
27 | 1
28 | 1
29 | 1
30 | 1
31 | 1
32 | 1
33 | 1
34 | 1
35 | 1
36 | 1
37 | 1
38 | 1
39 | 1
40 | 1
41 | 1
42 | 1
43 | 1
44 | 1
45 | 1
46 | 1
47 | 1
48 | 1
49 | 1
50 | 1
51 | 1
52 | 1
53 | 1
54 | 1
55 | 1
56 | 1
57 | 1
58 | 1
59 | 1
60 | 1
Spreadsheet: 791718d1660563473-formula-enhancement-for-detecting-numbers-lower-or-greater-by-1-in-row-above-next-expected-values
Sheet: PRP

NUMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOWER by 1 | GREATER by 1 |  |  | PRIME | NON-prime | EVEN | ODD | NEXT |  |  |  |  |  |  |  |  |  | PRIME/NON-prime |  |  |  |  |  |  |  |  |  | EVEN/ODD
2 | 2 | 0 | 6
3 | 2 | 3 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 | 2 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 | 7 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
0 | 0 | 3 | 7
1 | 0 | 2 | 7
1 | 2 | 2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 | 5 | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
0 | 3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 4 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 6 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 | 0 | 6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | 1 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 | 2 | 1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 | 2 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
0 | 1 | 4 | 3
Spreadsheet: 88016d1287911189-extracting-text-string-with-2-options-end-and-limited-options-extractsolutions-4-christianr-2-
Sheet: Sheet1

 |  | zbor |  | Marcol |  | Marcol
1
2 | abcxyz
3 | CR 256 | 256 |  | 256 |  | 256 |  | 256 | 256 |  | 256
4 | CR 256, 278, 296 | 256 |  | 256 |  | 256 |  | 256, 278, 296 | 256 |  | 256
5 | CR 2,278,296 | 2 |  | 2 |  | 2 |  | 2,278,296 | 2 |  | 2
6 | CR 25; XYZ 412, 478 | 25 |  | 25 |  | 25 |  | 25,  [NAME], 478 | 25 |  | 25
7 | CR 2566, 278, 296; XYZ 412, 478 | 2566 |  | 2566 |  | 2566 |  | 2566, 278, 296,  [NAME], 478 | 2566 |  | 2566
8 | ABC 1232, 1468; CR 12345, 1278, 1296 | 12345 |  | 12345 |  | 12345 |  | 12345, 1278, 1296 | 12345 |  | 12345
9 | ABC 1232, 1468; CR 12345678, 1278, 1296; XYZ 412, 478 | 12345678 |  | 12345678 |  | 12345678 |  | 12345678, 1278, 1296,  [NAME], 478 | 12345678 |  | 12345678
10 | ABC 1232, 1468; CR 12(a)b.56+II-VI; [NAME], 478 | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI,  [NAME], 478 | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI
11 | ABC 1232, 1468; CR [PHONE], 1278, 1296; XYZ 412, 478 | [PHONE] |  | [PHONE] |  | [PHONE] |  | [PHONE], 1278, 1296,  [NAME], 478 | [PHONE] |  | [PHONE]
 | If the string to be searched doesn't exceed 102 characters then :=
 | This is the shortest I can make the formula to get a clean result
1/. | IF(ISERROR(FIND("CR",B2,1)),"",IF(ISERROR(SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))),SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),LEFT(SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))-1)))
 | 273 | characters
 | If the string contains a semi-colon(;) and at least one comma (,) then this might suffice.
2/. | IF(ISERROR(FIND("CR",B2,1)),"",IF(ISERROR(SEARCH(",",B2)),SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),LEFT(SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))-1)))
 | 227 | characters
3/. | If you can use a two stage search then columns I & J should work for any length of string and remove all the above conditions.
 | zbors' updated formula is the answer !!!
4/. | SUBSTITUTE(LEFT(SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE(B2,"CR ",REPT(" ",255)),250,255),",",REPT(" ",255)),";",REPT(" ",255)),255)," ","")
 | 137 | characters
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Texas - Trading

 | Texas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 707124 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 196020
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 180628.8 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 38500 |  |  |  |  | 1.2
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 38500 | Total |  |  |  | 1.1
ENAOUTSV | Outside Services |  |  |  |  |  | 5500
ENASUPP | Supplies Expense |  |  |  |  |  | 22000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 270.4166666666667 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | -0.2328333333327464 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 5005.473000000001 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0.7333333333333335 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 6600 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 268914d1380887079-taking-a-average-value-month-sensitive-from-a-separate-sheet-m1kef
Sheet: Capture sheet

Diesel Register
Information is captured here
DATE | DRIVER NAME | TRUCK REG | ODOMETER READING | *REALISTIC METER READING* | DIESEL METER READING | QUANTITY(LITRES)
2013-10-15 00:00:00 | [NAME] | BN 99 WC GP | 100000 | 100000 |  | 150 |  |  |  | Column1
2013-10-16 00:00:00 | [NAME] | TZD 952 GP | 100000 |  |  | 100 |  |  |  | BN 99 WC GP
2013-10-17 00:00:00 | [NAME] | LMP 383 GP | 100000 |  |  | 200 |  |  |  | TZD 952 GP
2013-10-18 00:00:00 | [NAME] | NRZ 935 GP | 100000 |  |  | 500 |  |  |  | LMP 383 GP
2013-10-19 00:00:00 | [NAME] | KSD 084 GP | 100000 |  |  | 300 |  |  |  | NRZ 935 GP
2013-10-20 00:00:00 | [NAME] | BH 14 VZ GP | 100000 |  |  | 230 |  |  |  | KSD 084 GP
2013-10-21 00:00:00 | [NAME] | BN 99 WC GP | 100025 |  |  | 50 |  |  |  | BH 14 VZ GP
2013-10-22 00:00:00 | [NAME] | TZD 952 GP | 100025 |  |  | 270 |  |  |  | FL01(3.0)
2013-10-23 00:00:00 | [NAME] | LMP 383 GP | 100025 |  |  | 820 |  |  |  | FL02(4.5)
2013-10-24 00:00:00 | [NAME] | NRZ 935 GP | 100025 |  |  | 360
2013-10-25 00:00:00 | [NAME] | KSD 084 GP | 100025 |  |  | 420
2013-10-26 00:00:00 | [NAME] | BH 14 VZ GP | 100025 |  |  | 750
2013-10-27 00:00:00 | [NAME] | FL01(3.0) | 400 |  |  | 234
2013-10-28 00:00:00 | [NAME] | FL02(4.5) | 400 |  |  | 234
2013-10-29 00:00:00 | [NAME] | FL01(3.0) | 600 |  |  | 234
2013-10-30 00:00:00 | [NAME] | FL02(4.5) | 600 |  |  | 234
2013-10-31 00:00:00 | [NAME] | BN 99 WC GP | 601 |  |  | 235
2013-11-01 00:00:00 | [NAME] | BN 99 WC GP | 602 |  |  | 236
2013-11-02 00:00:00 | [NAME] | BN 99 WC GP | 603 |  |  | 237
Spreadsheet: 805859d1668963345-formula-to-count-blank-cells-from-column-where-the-rows-range-changes-sample-hd
Sheet: Sheet1

Notes | Worker | Status
 | Name1
 | [NAME] | x
 | Name3 |  |  |  | Blank cell count from column c
 | Name4
 | Name5
 | Name6
 | Name7 | m
 | Name8
 | Name9
 | Name10
 | Name11 | d
 | Name12
 | Name13
 | Name14
 | Name15 | c
 | [NAME]
 | Name17
 | Name18
 | Name19
Spreadsheet: 477041d1472119296-lookup-column-and-row-to-return-value-double-look-up
Sheet: Data

Reference | Date | Notified | Year Cal | Year | Type | Cover | Claim Type | Deductible
 |  |  |  |  |  |  |  | #N/A
11235 | 2015-02-01 00:00:00 | 2015-02-02 00:00:00 | 2015 | 2015 | Fall | Public Liability | Liability | 25000
56465 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016 | 2016 | Fire | Property | Property | 100000
54688 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013 | 2013 | Trip | Employers Liability | Liability | 0