tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_stokley__3970__Phoenix 082401
Sheet: Mgmt

 | CUSTOMER | PHOENIX LEAD | PHOENIX SECOND | PORTFOLIO ORIGINATION | SERVICE MGMT | ACCOUNT MGMT | RISK MODELS | DEAL MGMT | DSM | LEGAL | TRANSACTION SUPPORT | CONTRACT REVIEW % | REVIEW START | TARGET END | ORIG TARGET
 |  |  |  |  |  |  |  |  | PERCENT COMPLETE (simple avg)
 |  |  |  |  |  |  |  |  | TOTAL PROJECT COMPLETENESS
 | FZ | [NAME]
 | SW | [NAME]
 | DB | [NAME]
Spreadsheet: 45316d1244075148-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample
Sheet: Jan Cat1

Model | Amount-Cat1
500 | -174.29
750 | -2262.167420000004
AB | -661.97716
AD | -53.8898
AL | -1523.33
BX | -4056.255
BZ | -3228.96
CA | -1841.355
CB | -402.3125
GL | -2868.781915198807
GM | -221.0269653693443
MF | -755.3130685052638
MR | -9278.193647035247
OA | -328.2282893398016
OB | -123.2664119982595
OR | -154.8486199890987
ZP | -271.5391654515289
Grand Total | -28205.73496288735
Spreadsheet: 819297d1677397260-limitation-of-characters-in-excel-formula-excel-bug-report
Sheet: Sheet1

COD | D1C | FORMULA | PROFILDIM | RT | RL | DGR | DN1 | DN2 | DN3 | DN1U | DN2U | DN3U | PN1 | PN2 | [NAME] | PN2U | SCH1 | SCH2 | SCH3 | SDR | OD1 | OD2 | OD3 | WT1 | WT2 | WT3 | DIAEX | DIAEX2 | DIAINT | DIAINT2 | DIAC | BORE | DIABOLT | BOLTL | BOLTNO | THREADT | [NAME] | TH1 | TH2 | WID1 | [NAME] | LEN1 | [NAME] | [NAME] | HIG2 | A | B | C | D | E | F | G | PREFAB | TRACKING
THR | ADIABOLT |  |  | SR | 222 | 90 | 5" | 21/2" |  | 5" |  |  | 300 |  | #300 |  | SCH10 | SCH10" |  | SDR17 | 141.3 | 73.03 |  | 3.4 | 3.05 |  |  |  | 120 |  |  | 100 | 3/4" | 100 | 4 |  |  | 4 |  | 100 |  | 100 | 100 |  | 50
Spreadsheet: 103284d1301046797-if-formula-for-corresponding-tables-copy-of-auto-adjust_2
Sheet: Sheet1

TABLE ONE |  |  |  |  | TABLE TWO
Distance | Lengths | Before | 100% Adjusted |  | distance | barrier | % before barrier | 100% adj number | formula in m3:m11
1000 m | 9.65 | 0.9 |  |  | 1000 m | 1 | 0.5 |  | (((100-(L3*100))*0.034)+K3)
1000 m | 9 | 0.9 |  |  | 1200 m | 1 | 0.5 |  | (((100-(L4*100))*0.042)+K4)
1000 m | 9.4 | 0.9 |  |  | 1400 m | 1 | 0.5 |  | (((100-(L5*100))*0.044)+K5)
1200 m | 11.57 | 0.9 |  |  | 1600 m | 1 | 0.5 |  | (((100-(L6*100))*0.044)+K6)
1200 m | 11.4 | 0.9 |  |  | 1800 m | 1 | 0.5 |  | (((100-(L7*100))*0.046)+K7)
1200 m | 12 | 0.9 |  |  | 2200 m | 1 | 0.5 |  | (((100-(L8*100))*0.048)+K8)
1400 m | 12.91 | 0.9 |  |  | 2400 m | 1 | 0.5 |  | (((100-(L9*100))*0.052)+K9)
1400 m | 13 | 0.9 |  |  | 2850 m | 1 | 0.5 |  | (((100-(L10*100))*0.054)+K10)
1400 m | 13 | 0.9 |  |  | 3200 m | 1 | 0.5 |  | (((100-(L11*100))*0.054)+K11)
1400 m | 12.5 | 0.9
I have manually entered the formula want in cells d3:d6. Ideally though I would like a formula to automatically change the formula in cells d3:d6 depending on the distance in cells b3:b6.
I have pasted the formulas fromI3:I11 in cells J3:J11 without the = sign to show the formulas.
So if I changed cell A3 to 200m I would like cell D3 's formula to change from (((100-(c3*100))*0.034)+b3) to (((100-(c3*100))*0.042)+b3)
i have added more to table one. You see the % before is always 90% but as the lengths are different the outcome is different as the formula is a calculation based on the values of cells B and C
Spreadsheet: 705602d1606218766-if-formula-with-limiting-choices-ef1417_gv-south-phase-1-worksheet
Sheet: Spreadsheet

GARDEN VIEW - VINTAGE HEIGHTS - BUYERS WORKSHEET - PHASE 1
Client Name:  Roman & Lesli Knezovich |  |  |  | Lot
Phone:
[NAME]:
Model/Site Selection
Model |  | Urban Modern 2 bed
Lot Choice |  | B3L9
Foundation
Basement |  | Yes
Finished Basement |  | Yes
Add 3rd Stall |  | Yes
Allowances
Appliances |  |  |  | 4000 | Incl.
Flooring |  |  |  |  | Incl.
Lighting |  |  |  |  | Incl.
Sod and Sprinklers |  |  |  |  | Incl.
Options
4 Yr Warranty |  | Included |  |  | Incl.
Fireplace |  | Yes
(If Yes) Fireplace Style |  | Add for Stone Surround
Add Cable & Phone |  | No
Add Wood Steps to Deck | 68 | No
Add'l Disc Lights @$68 |  | 0
Smart Home Elec. Package |  | Smart Home Bronze
Total
Purchaser |  |  |  | Date
Purchaser |  |  |  | Date
Spreadsheet: 551aaff2-c412-40cf-95ec-dcf29928bd64
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
GT | Test | GT | Yeast Ident Panel A | Yeast Ident Panel A |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87106 |  |  |  |  | Rochester
GT | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: stacey_white__38805__Flex Schedule Calendar
Sheet: Apr-01

APRIL 2001
 | 2 |  | 3 |  | 4 |  | 5 |  | 6
[NAME] | 9 | [NAME] | 10 | [NAME] | 11 | [NAME] | 12 | [NAME] | 13
[NAME] |  |  |  | J.P. |  |  |  | [NAME]
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 |  | J.P. |  |  |  | [NAME]
 |  |  |  | Andrea-EL 7:30am
 |  |  |  |  |  | J.P.-vacation |  | J.P.-vacation
[NAME] | 16 | [NAME] | 17 | [NAME] | 18 | [NAME] | 19 | [NAME] | 20
[NAME] |  | J.P. |  | [NAME] |  | [NAME] |  | J.P.
[NAME] |  | [NAME] |  | J.P. |  | [NAME] |  | [NAME]
Donnie-dentist 9am
[NAME]'s BDay! |  |  |  |  |  |  |  | Donnie-vacation
 |  |  |  |  |  | Donnie-vacation |  | [NAME]-vacation
[NAME] | 23 | [NAME] | 24 | [NAME] | 25 | [NAME] | 26 | [NAME] | 27
J.P. |  | J.P. |  | [NAME] |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
[NAME]
[NAME]-vacation |  | Andrea/JP Excel 1-4 |  |  |  | Andrea/JP Excel 8:30-11:30
 | 30 |  | 1 | [NAME] | 2 | [NAME] | 3 | [NAME] | 4
 |  |  |  | [NAME] |  | J.P. |  | [NAME]
 |  |  |  | [NAME] |  | [NAME] |  | J.P.
* If your name is listed that means you are working late that day (whatever 'late' means!)
18 applicable days through 5/4/01
36 available early slots (excluding Donnie/Casey)
9 5pm days for each person during the period
Spreadsheet: 46345d1245247042-vlookup-closest-match-closest-match-example
Sheet: Sheet1

2.777777777777778 | 1.75
4.166666666666667
5.555555555555555
11.66666666666667
11.66666666666667
14.44444444444444
16.11111111111111
22.77777777777778
22.77777777777778
22.77777777777778
37.22222222222222
45
56.11111111111111
83.8888888888889
139.4444444444445
278.3333333333334
278.3333333333334
278.3333333333334
278.3333333333334
1.2 | 0.2
1.222 | 0.222
1.25 | 0.25
1.286 | 0.286
1.3 | 0.3
1.333 | 0.333
1.364 | 0.3640000000000001
1.4 | 0.3999999999999999
1.444 | 0.444
1.5 | 0.5
1.533 | 0.5329999999999999
1.571 | 0.571
1.6 | 0.6000000000000001
1.615 | 0.615
1.667 | 0.667
1.7 | 0.7
1.727 | 0.7270000000000001
1.8 | 0.8
1.833 | 0.833
1.9 | 0.8999999999999999
1.909 | 0.909
1.95 | 0.95
2 | 1
2.05 | 1.05
2.1 | 1.1
2.2 | 1.2
2.25 | 1.25
2.3 | 1.3
2.375 | 1.375
2.4 | 1.4
2.5 | 1.5
2.6 | 1.6
2.625 | 1.625
2.7 | 1.7
2.75 | 1.75
2.8 | 1.8
2.875 | 1.875
3 | 2
3.1 | 2.1
3.2 | 2.2
3.25 | 2.25
3.3 | 2.3
3.4 | 2.4
3.5 | 2.5
3.6 | 2.6
3.75 | 2.75
3.8 | 2.8
4 | 3
4.2 | 3.2
4.333 | 3.333
4.5 | 3.5
4.6 | 3.6
5 | 4
5.5 | 4.5
6 | 5
6.5 | 5.5
7 | 6
7.5 | 6.5
8 | 7
8.5 | 7.5
9 | 8
10 | 9
11 | 10
12 | 11
13 | 12
15 | 14
17 | 16
19 | 18
21 | 20
23 | 22
26 | 25
29 | 28
34 | 33
41 | 40
51 | 50
67 | 66
81 | 80
101 | 100
126 | 125
151 | 150
176 | 175
201 | 200
251 | 250
301 | 300
501 | 500
751 | 750
1001 | 1000
Spreadsheet: 756992d1637927888-countif-blank-example
Sheet: wholesalers

Wholesaler_ID | Customer_Number | Belongs_To_Account
1 | 7456543 | 123
2 | FDHDH | 3434
3 | M1 | 5656
4 |  | 123
5 | M1 6HP | 3434
6 |  | 5656
8 | 9864 | 3434
9 | MIKES | 5656
10 | YUMMY | 123
11 |  | 5656