tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851113d1701355152-table-filter-with-different-value-in-cell-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Tag 1
Product | Description | Make | Model | Supplier | Source | Product Category | Quantity | Tag
Item 1 | about the Item | make 1 | model 1 | Supplier 1 | Source 1 | Product 1 | 1 | Tag 1
Item 2 | about the Item | make 2 | model 2 | Supplier 2 | Source 2 | Product 2 | 1 | Tag 1
Item 3 | about the Item | make 1 | model 3 | Supplier 1 | Source 3 | Product 3 | 1 | Tag 1
Item 4 | about the Item | make 3 | model 4 | Supplier 1 | Source 2 | Product 1 | 1 | Tag 1, Tag 2
Item 5 | about the Item | make 1 | model 5 | Supplier 1 | Source 1 | Product 2 | 1 | Tag 2
Item 6 | about the Item | make 2 | model 6 | Supplier 2 | Source 2 | Product 3 | 1 | Tag 1
Item 7 | about the Item | make 1 | model 7 | Supplier 1 | Source 3 | Product 1 | 1 | Tag 3
Item 8 | about the Item | make 2 | model 8 | Supplier 1 | Source 2 | Product 2 | 1 | Tag 1
Item 9 | about the Item | make 1 | model 9 | Supplier 1 | Source 1 | Product 3 | 1 | Tag 1, Tag 2
Item 10 | about the Item | make 3 | model 10 | Supplier 2 | Source 2 | Product 1 | 1 | Tag 2, Tag 3
Item 11 | about the Item | make 1 | model 11 | Supplier 1 | Source 3 | Product 2 | 1 | Tag 1
Item 12 | about the Item | make 2 | model 12 | Supplier 1 | Source 2 | Product 3 | 1 | Tag 3
Item 13 | about the Item | make 1 | model 13 | Supplier 1 | Source 1 | Product 1 | 1 | Tag 3
Item 14 | about the Item | make 2 | model 14 | Supplier 2 | Source 2 | Product 2 | 1 | Tag 1, Tag 3
Item 15 | about the Item | make 1 | model 15 | Supplier 1 | Source 3 | Product 3 | 1 | Tag 2
Item 16 | about the Item | make 3 | model 16 | Supplier 1 | Source 2 | Product 1 | 1 | Tag 1
Item 17 | about the Item | make 1 | model 17 | Supplier 1 | Source 1 | Product 2 | 1 | Tag 3
Item 18 | about the Item | make 2 | model 18 | Supplier 2 | Source 2 | Product 3 | 1 | Tag 1
Item 19 | about the Item | make 1 | model 19 | Supplier 1 | Source 3 | Product 1 | 1 | Tag 1, Tag 3
Item 20 | about the Item | make 2 | model 20 | Supplier 1 | Source 2 | Product 2 | 1 | Tag 1, Tag 2, Tag 4
Spreadsheet: sally_beck__35333__Enron2001
Sheet: YTD

 | Year-End Estimate Paid | EDS 2001 Commitment | [NAME] | Comments
Spent to Date |  |  |  | Actuals spent to date
Monthly Estimate to Spend |  |  |  | Based on $360,000/month thru year end
NEC Screens (estimate spend) | 5113498.55 |  |  | We are being billed for these
(does not include sales tax)
2001 Total |  | 8000000
(These numbers include EOTT - approximately $10,210/per month)
ACTUAL SPENT TO DATE
Spent to Date
[NAME] - billed to date | 5535380.02
 |  | 8000000
Spreadsheet: 773761d1648037999-formula-range-based-on-another-cell-value-test-demo-2
Sheet: Sheet1

 |  |  | AUX |  |  | POINT | SPEC |  |  | RESULT1 | RESULT2 | RESULT3...
 |  |  |  |  |  | 1 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 2 |  | 3.0 CAR |  | 1.5 | 1.4
 |  |  |  |  |  | 3 |  | 3.5 CAR |  | 2.5 | 1.3
 |  |  |  |  |  | 4 |  | 3.5 CAR |  | 2.1 | 2.2
 |  |  |  |  |  | 5 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 6 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 7 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 3 | 6
 |  |  |  |  |  | 8 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 9 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 10 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 11 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 9 | 11
 |  |  |  |  |  | 12 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 13 |  | 3.5 CAR |  | 2.5 | 1.3
 |  |  |  |  |  | 14 |  | 3.5 CAR |  | 2.1 | 2.2
 |  |  |  |  |  | 15 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 16 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 17 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 13 | 15
 |  |  |  |  |  | 1 |  | 3.0 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 2 |  | 3.0 HOME |  | 1.4 | 1.4
 |  |  |  |  |  | 3 |  | 3.5 HOME |  | 1.3 | 1.3
 |  |  |  |  |  | 4 |  | 3.5 HOME |  | 2.1 | 2.2
 |  |  |  |  |  | 5 |  | 3.0 HOME |  | 1.2 | 2.1
 |  |  |  |  |  | 6 |  | 4.0 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 7 |  | 3.0 HOME |  | 2.5 | 1.3
 |  |  |  | 1 | 5
 |  |  |  |  |  | 8 |  | 3.0 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 9 |  | 3.0 HOME |  | 1.5 | 1.3
 |  |  |  |  |  | 10 |  | 3.5 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 11 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  | 8 | 10
 |  |  |  |  |  | 12 |  | 3.5 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 13 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  |  |  | 14 |  | 3.5 HOME |  | 2.1 | 2.2
 |  |  |  |  |  | 15 |  | 3.5 HOME |  | 1.5 | 1.3
 |  |  |  |  |  | 16 |  | 3.5 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 17 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  | 12 | 15
Spreadsheet: joe_parks__14622__POSTIONTRAX_NOV
Sheet: POSTION

 | MTM |  | POSTION | ROLL OFF | NEW DEAL | MTM | NET |  | ROLLOFF VALUE |  | change | PRIOR POSTION | CHANGE
 | 2.813 | DEC |  |  |  |  |  |  |  | 2.852 |  | -46.5 |  | 2001-06-01 00:00:00
 |  | JAN |  |  |  |  |  |  |  | 3.041 |  | -9.3 |  | 2001-06-02 00:00:00
 |  | FEB |  |  |  |  |  |  |  | 3.081 |  | -3.1 |  | 2001-06-03 00:00:00
 |  | MAR |  |  |  |  |  |  |  | 3.066 |  | 0 |  | 2001-06-04 00:00:00
 |  | Z-H |  |  |  |  |  |  |  | 3.01 |  | 0 |  | 2001-06-05 00:00:00
 |  | J-V |  |  |  |  |  |  |  | 3.127 |  | 1
 |  | CAL2 |  |  |  |  |  |  |  | 3.18 |  | 2
 |  | HH_SWAP |  |  |  |  |  |  | 1.97 | 2.4 |  | -69.7 |  | 2001-06-06 00:00:00
 |  | HSC_SWAP |  |  |  |  |  |  | 1.83 | 2.36 |  | 0 |  | 2001-06-07 00:00:00
 |  | KATY_SWAP |  |  |  |  |  |  |  | 2.31 |  | 15.5 |  | 2001-06-08 00:00:00
 |  | WAHA_SWAP |  |  |  |  |  |  | 1.64 | 2.11 |  | 0 |  | 2001-06-09 00:00:00
 |  | [NAME] |  |  |  |  |  |  | 1.61 | 2.08 |  | 0 |  | 2001-06-10 00:00:00
 |  | KATY_PHYS |  |  |  |  |  |  |  | 2.31 |  | 58.9 |  | 2001-06-11 00:00:00
 |  | TOTAL |  |  |  |  |  |  |  |  |  | -54.2 |  | 2001-06-12 00:00:00
 |  | [NAME]_ AUG |  |  |  |  |  |  |  |  |  | 0 |  | 2001-06-13 00:00:00
 |  | HH_AUG | KA |  |  |  |  |  | 3.447 |  |  | 0 |  | 2001-06-14 00:00:00
 |  | Hsc_AUG |  |  | basis | -19000 |  |  | 3.51 |  |  | 0 |  | 2001-06-15 00:00:00
 |  |  |  |  |  |  |  |  | 3.475 |  |  |  |  | 2001-06-16 00:00:00
 |  | TOTAL |  |  |  |  |  |  | 3.39 |  |  | 75.65 |  | 2001-06-17 00:00:00 | 25000
 |  |  |  |  |  |  |  |  | 3.39 |  |  |  |  | 2001-06-18 00:00:00 | 25000
 |  | NUMBER OF DAYS |  | 9 | 1 |  |  |  | 3.475 |  |  |  |  | 2001-06-19 00:00:00 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-06-20 00:00:00 | 25000
 |  |  |  |  |  |  |  | PRIOR |  |  |  |  |  | 2001-06-21 00:00:00 | 25000
 |  | 2001-12-01 00:00:00 | 2.813 |  |  |  |  | 3.397 |  |  |  |  |  | 2001-06-22 00:00:00 | 25000
1 | 3.446 | 2002-01-01 00:00:00 | 2.991 |  |  |  | 2.552 | 2.369 |  |  |  |  |  | 2001-06-23 00:00:00 | 25000
2 | 3.397 | 2002-02-01 00:00:00 | 3.036 |  |  |  | 2.902 | 2.753 |  |  |  |  |  | 2001-06-24 00:00:00 | 25000
3 | 3.422 | 2002-03-01 00:00:00 | 3.005 |  |  |  | 3.252 | 3.125 |  |  |  |  |  | 2001-06-25 00:00:00 | 25000
 |  | 2002-04-01 00:00:00 | 2.945 |  |  |  | 3.422 | 3.303 |  |  |  |  |  | 2001-06-26 00:00:00 | 25000
 |  | 2002-05-01 00:00:00 | 2.983 |  |  |  | 3.394 | 3.28 |  |  |  |  |  | 2001-06-27 00:00:00 | 25000
 |  | 2002-06-01 00:00:00 | 3.023 |  |  |  | 3.325 | 3.215 |  |  |  |  |  | 2001-06-28 00:00:00 | 25000
 |  | 2002-07-01 00:00:00 | 3.06 |  |  |  | 3.232 | 3.125 |  |  |  |  |  | 2001-06-29 00:00:00 | 25000
 |  | 2002-08-01 00:00:00 | 3.093 |  |  |  | 3.252 | 3.15 |  |  |  |  |  | 2001-06-30 00:00:00 | 25000
 |  | 2002-09-01 00:00:00 | 3.095 |  |  |  | 3.285 | 3.185 |  |  | ,30 |  |  |  | 25000
 |  | 2002-10-01 00:00:00 | 3.117 |  |  |  | 3.325 | 3.225
 |  | 2002-11-01 00:00:00 | 3.297 |  |  |  | 3.362 | 3.262
 |  | 2002-12-01 00:00:00 | 3.482 |  |  |  | 3.36 | 3.26
 |  |  |  |  |  |  | 3.372 | 3.272
 |  |  |  |  |  |  | 3.532 | 3.432
 |  |  |  |  |  |  | 3.695 | 3.595
Spreadsheet: 824628d1680719079-vlookup-on-different-sheet-and-return-sum-of-values-if-it-is-more-than-one-sample_data
Sheet: PO_Details

ID | Shipping_Source | QTY | SKI
1 | SELLER | 3 | TS-2345
2 | SELLER | 1 | TS-2698
3 | SELLER | 4 | TS-2345
4 | SELLER | 1 | TS-2299
5 | SELLER | 2 | TS-2698
Spreadsheet: 816230d1675435865-recipe-copy-example
Sheet: Sheet1

 | INGREDIENT: | [NAME]: | ANOTHER VALUE |  | Recipe
 | Sugar | 1 | 10
 | Glucose | 1 | 20
 | white chocolate |  | 30
 | milk | 1 | 40
 | Milk chocolate |  | 50
Spreadsheet: 732292d1620866190-amazon-jewelry-fee-help-anand3000-amazon-fees
Sheet: Amazon

Cost | Target Profit | Net Sale | Fee | [NAME] |  |  | Amazon Fees
350 | 100 |  |  |  |  | Tier 1 fee | 250 | 0.2
150 | 50 |  |  |  |  | [NAME] fee |  | 0.05
100 | 40
Spreadsheet: 878216d1725285839-golf-pairs-team-admin-tool-ullesthorpedave-golf-pairings-365-aligw
Sheet: Sheet1

Players | Select |  |  | Pairings
A
B | Y
C
D | Y
E
F | Y
G
H | Y
I
J | Y
K
L | Y
M
N
O
P | Y
Q
R | Y
S
T
U
V
W | Y
X
Y | Y
Z
AA | Y
BB
CC
DD
EE | Y
FF
GG
HH
II
JJ
Spreadsheet: 721158d1614536131-find-last-and-first-non-zero-value-for-particular-lookup-criteria-book3
Sheet: Sheet1

Date | Product | Value
2020-01-01 00:00:00 | Ship | 0
2020-01-01 00:00:00 | Car | 50
2020-01-01 00:00:00 | Train | 0
2020-01-01 00:00:00 | Boat | 0
2020-01-01 00:00:00 | Van | 0
2020-01-01 00:00:00 | Trailer | 0
2020-01-01 00:00:00 | Motocycle | 30
2020-01-01 00:00:00 | Plain | 40
2020-02-01 00:00:00 | Ship | 0
2020-02-01 00:00:00 | Car | 20
2020-02-01 00:00:00 | Train | 30
2020-02-01 00:00:00 | Boat | 0
2020-02-01 00:00:00 | Van | 0
2020-02-01 00:00:00 | Trailer | 20
2020-02-01 00:00:00 | Plain | 0
2020-03-01 00:00:00 | Ship | 30
2020-03-01 00:00:00 | Car | 0
2020-03-01 00:00:00 | Train | 0
2020-03-01 00:00:00 | Boat | 0
2020-03-01 00:00:00 | Van | 10
2020-03-01 00:00:00 | Trailer | 40
2020-03-01 00:00:00 | Motocycle | 0
2020-03-01 00:00:00 | Plain | 10
2020-04-01 00:00:00 | Ship | 20
2020-04-01 00:00:00 | Car | 0
2020-04-01 00:00:00 | Train | 0
2020-04-01 00:00:00 | Boat | 0
2020-04-01 00:00:00 | Van | 0
2020-04-01 00:00:00 | Trailer | 0
2020-04-01 00:00:00 | Motocycle | 20
2020-04-01 00:00:00 | Plain | 0
 |  |  |  | Date of last non zero value
LAST non zero value | Ship
 | Car
 | Train
 | Boat
 | Van
 | Trailer
 | Motocycle
 | Plain
 |  |  |  | Date of first non zero value
FIRST non zero value | Ship
 | Car
 | Train
 | Boat
 | Van
 | Trailer
 | Motocycle
 | Plain
 |  | INDEX(A$2:A32;MATCH(TRUE;INDEX((A2:A32<>0);0);0))
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 190816 | 190367 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 178629 | 195650 |  | -18000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 189748 | 191438 |  | -2971 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 193749 | 192572 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 186998 | 194141 |  | -2628 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 181005 | 192134 |  | -11852 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 192971 | 197823 |  | -5298 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 200612 | 199693 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 204009 | 203869 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 201524 | 200614 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 175844 | 188791 |  | -13972 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 199202 | 201992 |  | -4000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 205757 | 209777 |  | -4862 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 206004 | 205639 |  | -1000
15 | 157488 | 174447 |  | -17991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 115285 | 126419 |  | -13069 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 157197 | 157684 |  | -500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 162054 | 162309 |  | -500
19 | 167760 | 166939 |  | -500
20 | 163689 | 163004
21 | 176859 | 175523
22 | 195275 | 194452 |  | -500
23 | 198421 | 197192 |  | -500
24 | 211907 | 211121 |  | -500
25 | 214731 | 212929 |  | -500
26 | 198809 | 197622 |  | -500
27 | 187854 | 189423
28 | 162223 | 173350 |  | -11862
29 | 193720 | 202742 |  | -10152
30 | 162741 | 169823 |  | -7916
31
 | 2001-10-31 00:00:00 |  |  |  | 43731
 | 2001-11-30 00:00:00
 | CBS Dollars
 |  |  |  | -365472.28
Spreadsheet: a710c21f-0eee-4118-bc02-e328a36df0f0
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
PTU | Test | PTU | Protein, Total, [NAME] | Protein, Total, U | [NAME] (Pyrogallol Red) | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative.  Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Preferred Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	Yes Thymol	Yes | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =18 years: <102 mg/24 hours Reference values have not been established for patients that are <18 years of age.   Reference value applies to 24-hour collection. | Monday through Sunday; Continuously | Same day/1 day | Same day/1 day | 1 | 84156 |  |  |  |  | Rochester
PTU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
PTU | Order Question | TM23 | Collection Duration |  | Plain Text
PTU | Order Question | VL21 | [NAME] |  | Plain Text
PTU | Result | TP2 | Total Protein | Total Protein | Numeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 2889-4
PTU | Result | TM23 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
PTU | Result | VL21 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 19153-6
PTU | Result | CONC1 | Concentration | Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35663-4
Spreadsheet: 723850d1615917239-need-a-formula-to-read-a-range-of-cell-sample
Sheet: Sheet1

 | B16:E21 |  | 3 | 4
 |  |  | Q1 Actual | Q1 EST
 |  |  |  |  |  | Need a formula in D7 to read the range in cell B3
 | License |  |  |  |  | VLOOKUP($B7, $[NAME], D$3, 0)
 | Maint
 | Service
 | Subscriptions
 | Support
 | Total
 | License |  | 40 | 835.8715100000001
 | Maint |  | 0 | 0
 | Service |  | 0 | 0
 | Subscriptions |  | 99 | 755.75248
 | Support |  | 0 | 188.02177
 | Total
 | License |  | 736 | 4558
 | Maint |  | 90 | 0
 | Service |  | 855 | 0
 | Subscriptions |  | 255 | 95
 | Support |  | 463 | 4445
 | Total
Spreadsheet: 750356d1633409545-cell-contains-a-date-then-returns-a-certain-text-permit-register-example-5-10-2021
Sheet: Quotes

ABC Job Number | Address | Description | Client
 | Address 27 | Description 27 | Client 27
ABC-21028 | Address 28 | Description 28 | Client 28
ABC-21029 | Address 29 | Description 29 | Client 29
ABC-21030 | Address 30 | Description 30 | Client 30
Spreadsheet: 161455ea-084b-4a96-92aa-0933ef84e352
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Refinance Calculator
 | Current Monthly Payment | 2124.56
 | (Principal and Interest Only)
 | Cost of Refinancing | 2000
 | (Include all closing costs, fees, etc.)
 | New Loan Amount | 300000
 | New Term in Years | 30 |  | MONTHS TO BREAK EVEN: | 9
 | New Interest Rate | 0.065
 | NEW payment | 1896.204070478898
 | (Principal and Interest Only)
 | Monthly Savings | 228.3559295211016
 | (Principal and Interest Only)
 | Disclaimer:
 | This is an analysis based on the information you have provided in the input section. These are general estimates and should not be used as the sole basis for making financial decisions. Before making saving and investing decisions, consider all of your assets, including, for example, equity in a home, savings accounts, and other investments you may own.
 | ©1999-2010 Financial Finesse, Inc. All rights reserved.
 | This document contains confidential and proprietary information of Financial Finesse, Inc. and is intended solely for use of the intended recipient.
 | Unauthorized reproduction or distribution is strictly prohibited. The information contained in this document is not to be construed as advice.
 | If you have questions about your financial situation, you should contact a financial professional.
Spreadsheet: 808991d1670834706-if-and-or-formula-help-sample-excel-1-
Sheet: Sheet1

[NAME] | TransactionDate | Transaction Month | Invoice No | Amount | Pay terms  (EOM) | Over Due | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
ABC Ltd | 2022-11-18 00:00:00 |  | 010 | 1500 | 30
ABC Ltd | 2022-10-05 00:00:00 |  | 002 | 2000 | 30
XYZ Ltd | 2022-09-22 00:00:00 |  | Inv 0010 | 200 | 60
XYZ Ltd | 2022-10-26 00:00:00 |  | Inv 0050 | 500 | 60
PQR Ltd | 2022-08-15 00:00:00 |  | 7685 | 650 | 60
PQR Ltd | 2022-07-15 00:00:00 |  | 4942 | 500 | 60
PQR Ltd | 2022-11-28 00:00:00 |  | 5187 | 300 | 60
Spreadsheet: 268345d1380576316-lookup-and-if-combined-tester
Sheet: Sheet1

 |  |  | Price
 |  |  | Price
 |  |  | Sale
 |  |  | Pricing Structure
 |  |  | Sale
 |  |  | Product | Price | Sale
 |  |  | Brick | 1 | 10
 |  |  | Shovel | 2 | 12
 |  |  | Spade | 3 | 13
 |  |  | Wrench | 4 | 14
 |  |  |  |  |  |  |  |  | QTY | Product | Price
 |  |  |  |  |  |  |  |  | 1 | Shovel
Spreadsheet: 149328d1333850532-need-if-to-leave-certain-cells-blank-visitexample
Sheet: Sheet1

 |  |  |  | Minimum No. Of Audits PA | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
Name | Code | Workstream | Risk Category
Fitters  (Sub-Contractor) | F2500 | (F) Fitters | 1
[NAME]) | F2504 | (F) Fitters | 2
MD Fitters  (Sub-Contractor) | F2500 | (F) Fitters | 3
Spreadsheet: 839432d1691980533-correction-in-vlookup-function-in-relative-reference-test1
Sheet: Sheet1

STRING | LEN | Desired result | [NAME] results | LEN | Function
SYD DL LAX DL ATL DL LAX DL SYD | 31 |  |  | 17 | =Right(D4,3)
SYD DL LAX DL SYD |  |  |  | 31 | =MID(D4, 15, 3)
SYD DL LAX DL DTW DL LAX DL SYD |  |  |  | 36 | = MID(D4,15,3)
SYD DL LAX DL SAN//PHX DL LAX DL SYD |  |  |  | 45 | =MID(D4,22,3)
SYD DL LAX DL ATL DL GIG DL JFK DL LAX DL SYD
SYD DL LAX DL ATL DL CHS DL MSP DL LAX DL SYD
SYD DL LAX DL ATL DL FLL DL ATL DL LAX DL SYD
SYD DL LAX DL TUS DL LAX DL SYD
 |  |  | Function to use corresponding B column instead D
Spreadsheet: 71340d1272007598-excel-2007-help-on-if-functions-test
Sheet: Sheet1

P/L % | Stop Loss | Entry | Market | High prior | 30 day Highest | Look up | Trailing stop | Action
 |  |  |  |  |  |  | 0.05
 | 31.6 | 37.5 | 38.2 | 39 | 42.45
How to solve the action part where one would take profit only if the trade hits the trailing stop and is above my entry by more than 5%
Currently the action says profit when the P&L is only 2%.
Spreadsheet: 746283d1630604602-automatically-work-out-percentage-increase-to-balance-figure-handicap-suggestion_mod2
Sheet: Sheet2

36 |  | hcap |  | pts |  | Winners Cut | [NAME] | Total Cut | [NAME] | Rounded Increase | New Exact H'Cap | Play H'Cap |  |  |  | Percentage
[NAME] | 20.3 | 20 |  | 41 |  |  |  |  |  |  |  |  | Cat 1 | 0 to 9 | 0.1 | 0.133333375
[NAME] | 13.1 | 13 |  | 40 |  |  |  |  |  |  |  |  | Cat 2 | 10 to 19 | 0.2
[NAME] | 28.1 | 28 |  | 38 |  |  |  |  |  |  |  |  | Cat 3 | 20 to 29 | 0.3
[NAME] | 25.8 | 26 |  | 37 |  |  |  |  |  |  |  |  | Cat 4 | 30 & over | 0.4
[NAME] | 5.2 | 5 |  | 37
[NAME] | 17.7 | 18 |  | 36
[NAME] | 14.9 | 15 |  | 35
[NAME] | 9.8 | 10 |  | 35
[NAME] | 9.1 | 9 |  | 34
[NAME] | 30.9 | 31 |  | 33
[NAME] | 19 | 19 |  | 33
[NAME] | 10.6 | 11 |  | 33
[NAME] | 20 | 20 |  | 31
[NAME] | 29.4 | 29 |  | 31
[NAME] | 24.2 | 24 |  | 31
[NAME] | 16.1 | 16 |  | 30
[NAME] | 21.4 | 21 |  | 30
[NAME] | 16.6 | 17 |  | 30
[NAME] | 28 | 28 |  | 29
[NAME] | 7.2 | 7 |  | 29
[NAME] | 23 | 23 |  | 29
[NAME] | 14.1 | 14 |  | 29
[NAME] | 16.9 | 17 |  | 28
[NAME] | 12.3 | 12 |  | 27
[NAME] | 34.8 | 35 |  | 27
[NAME] | 11.6 | 12 |  | 27
[NAME] | 10.6 | 11 |  | 26
[NAME] | 19.6 | 20 |  | 25
[NAME] | 11.7 | 12 |  | 24
[NAME] | 10.6 | 11 |  | 24
[NAME] | 20.5 | 21 |  | 22
[NAME] | 16 | 16 |  | 21
Spreadsheet: 822998d1679640131-need-to-search-multiple-cell-value-and-fill-it-all-into-another-cell-guide-for-suffering
Sheet: Choice

Equipment | [NAME] | Teikoku Pump | Centrifugal Pump
Nemo | Pump will not start | Not energized | No flow
Teikoku | No Suction Capability | Over current | Under capacity
Centrifugal | Discharge Output Low | Over heat | Irregular discharge
 | Discharge Pressure Low | Poor insulation | Low discharge pressure
 | Discharge Output Fluctuate | TRG indicates red zone | Pump will not prime
 | Pump is Noisy | Abnormal wear of bearing | Prime lost after starting
 | Pump is [NAME] | Seizure of bearing | Pump stalls when starting
 | Drive Overloaded | No liquid pump | Pump overheats
 | Stator Service Life is Too Short | Required capacity not pumped | Motor overheats
 | Rotor Service Life is Too Short | Required pressure not emitted | Excessive power absorbed
 | Shaft Seal Leaks | Performance goes down | Noise and vibration
 |  | Cavitation occurs | Pump element wear
 |  | Serging occurs | Seizure
 |  | Abnormal vibrations | Mechanical seal leakage
 |  | Vibration increasing
 |  | Abnormal noise
 |  | Noise increasing