tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875607d1722216516-how-to-keep-a-drop-down-table-list-from-changing-excel-drop-down-list
Sheet: MASTER

 |  | To Do: Input ALL square footage then back into painting and flooring price per square foot.
 |  | 3255 Warrensville Center Road
 |  | Purchase Price | 515000
 |  | Total Budget | 100000
 |  | All-In | 615000
 |  | Money Spent | 0
 |  | Current All-In | 515000
 |  |  | Budgeted | Actual
 |  | Total Spent | 7016.666666666667 | 0
 |  | Percent Spent | 0.07016666666666667 | 0
 |  | Remaining | 92983.33333333333 | 100000
 |  | Master Budget
 |  | Materials | Budget Cost | Actual Cost | Difference
 | Exterior | Garage Roof | 0
 |  | Apartment Roof | 0
 |  | Gutters, soffit, fascia | 0
 |  | Siding | 0
 |  | Exterior Painting | 0
 |  | Decks and Porches | 0
 |  | Concrete | 0
 |  | Garage | 0
 |  | Landscaping | 0
 | Interior | Demo | 0
 |  | Plumbing | 0
 |  | Electrical | 700
 |  | HVAC | 0
 |  | Framing | 0
 |  | Insulation | 0
 |  | Drywall | 0
 |  | Carpentry | 0
 |  | Interior Painting | 0
 |  | Appliances | 2450
 |  | Cabinets, Countertops, Backsplash | 2926.666666666667
 |  | Flooring | 0
 |  | Permits | 0
 |  | Misc | 0
 |  | Total | 6076.666666666667 | 0 | -6076.666666666667
 |  |  |  |  |  |  |  | 0
 |  | Labor
 | Exterior | Garage Roof | 0 | <-- how to get sumif to expand when I insert a row???
 |  | Apartment Roof | 0
 |  | Gutters, soffit, fascia | 0
 |  | Siding | 0
 |  | Exterior Painting | 0
 |  | Decks and Porches | 0
 |  | Concrete | 0
 |  | Garage | 0
 |  | Landscaping | 0
 | Interior | Demo | 0
 |  | Plumbing | 0
 |  | Electrical | 0
 |  | HVAC | 0
 |  | Framing | 0
 |  | Insulation | 0
 |  | Drywall | 0
 |  | Carpentry | 0
 |  | Interior Painting | 0
 |  | Appliances | 0
 |  | Cabinets, Countertops, Backsplash | 940
 |  | Flooring | 0
 |  | Permits | 0
 |  | Misc | 0
 |  | Total | 940 | 0 | -940
Spreadsheet: 241407-highlighting-a-variable-number-of-duplicates-example
Sheet: Data

ID | Amount
9087 | 0
9087 | 145
6754 | 0
6754 | 0
6754 | 0
1356 | 0
1356 | 9
1356 | 0
1356 | 0
Spreadsheet: 829463d1684238493-tricky-lookup-with-ifs-book1
Sheet: CHECKLIST

ID1 | ID2 | Comments
11233 | a | wefec
11234 | b | qwdwdaef
11235 | aa | [NAME]
11236 | ww | dwd
11237
11238 | sw | qwe
11239 | de | th
11241 | sdf | jy
11242 | was | ew
Spreadsheet: andy_zipper__176__DYNEGY-ICE VOL Apr24
Sheet: E-Mail

 | 2001-04-24 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: richard_sanders__31921__ercotabslowandhigh
Sheet: richard_sanders__31921__ercotab

Dates | C.ERCOT.B - AbsLow | C.ERCOT.B - AbsHigh
 | ERCOT B, Central, Megawatt Daily Price Survey | ERCOT B, Central, Megawatt Daily Price Survey
1999-06-01 00:00:00 | 27.5 | 32
1999-06-02 00:00:00 | 26.25 | 37.5
1999-06-03 00:00:00 | 26.5 | 36
1999-06-04 00:00:00 | 28 | 31.5
1999-06-07 00:00:00 | 28.5 | 40
1999-06-08 00:00:00 | 23 | 55
1999-06-09 00:00:00 | 27 | 33
1999-06-10 00:00:00 | 26.75 | 29
1999-06-11 00:00:00 | 26.5 | 28.25
1999-06-14 00:00:00 | 27 | 32
1999-06-15 00:00:00 | 22.75 | 27.25
1999-06-16 00:00:00 | 25 | 25.5
1999-06-17 00:00:00 | 23.75 | 25.75
1999-06-18 00:00:00 | 23 | 25.75
1999-06-21 00:00:00 | 26 | 28.5
1999-06-22 00:00:00 | 23.5 | 26.25
1999-06-23 00:00:00 | 23.75 | 24.75
1999-06-24 00:00:00 | 23.75 | 24.75
1999-06-25 00:00:00 | 23 | 24.25
1999-06-28 00:00:00 | 26.5 | 30
1999-06-29 00:00:00 | 30 | 34
1999-06-30 00:00:00 | 28 | 33
1999-07-01 00:00:00 | 33 | 35
1999-07-02 00:00:00 | 34 | 35
1999-07-06 00:00:00 | 44 | 55
1999-07-07 00:00:00 | 40 | 60
1999-07-08 00:00:00 | 30 | 35.5
1999-07-09 00:00:00 | 30 | 32
1999-07-12 00:00:00 | 28.75 | 33
1999-07-13 00:00:00 | 29 | 33.5
1999-07-14 00:00:00 | 26 | 32
1999-07-15 00:00:00 | 31 | 35
1999-07-16 00:00:00 | 34 | 36
1999-07-19 00:00:00 | 35 | 40
1999-07-20 00:00:00 | 34 | 38.5
1999-07-21 00:00:00 | 35 | 37
1999-07-22 00:00:00 | 27 | 36.5
1999-07-23 00:00:00 | 32 | 34.5
1999-07-26 00:00:00 | 44 | 90
1999-07-27 00:00:00 | 50 | 175
1999-07-28 00:00:00 | 65 | 100
1999-07-29 00:00:00 | 150 | 200
1999-07-30 00:00:00 | 180 | 500
1999-08-02 00:00:00 | 100 | 350
1999-08-03 00:00:00 | 35 | 60
1999-08-04 00:00:00 | 45 | 51
1999-08-05 00:00:00 | 44 | 56
1999-08-06 00:00:00 | 60 | 130
1999-08-09 00:00:00 | 140 | 235
1999-08-10 00:00:00 | 100 | 250
1999-08-11 00:00:00 | 325 | 400
1999-08-12 00:00:00 | 250 | 400
1999-08-13 00:00:00 | 300 | 350
1999-08-16 00:00:00 | 225 | 250
1999-08-17 00:00:00 | 175 | 200
1999-08-18 00:00:00 | 99 | 101
1999-08-19 00:00:00 | 90 | 100
1999-08-20 00:00:00 | 174 | 176
1999-08-23 00:00:00 | 175 | 275
1999-08-24 00:00:00 | 55 | 75
1999-08-25 00:00:00 | 70 | 75
1999-08-26 00:00:00 | 145 | 150
1999-08-30 00:00:00 | 175 | 225
1999-08-31 00:00:00 | 135 | 150
Sum | 4494.75 | 6416.5
Average | 70.2305 | 100.2578
Average (+) | 70.2305 | 100.2578
Average (-) | NaN | NaN
Percent (+) | 100 | 100
Percent (-) | 0 | 0
Maximum | 325 | 500
Minimum | 22.75 | 24.25
Std Deviation | 71.7482 | 111.7624
Zstat | 0.9788 | 0.8971
[NAME] | 5147.8101 | 12490.8412
Last | 135 | 150
Spreadsheet: 119686d1314654222-combining-data-from-multiple-rows-example
Sheet: Sheet1

Have:
Name | Height | Weight | Age
[NAME] | 5'5
[NAME] |  | 150
[NAME] |  |  | 35
[NAME] | 5'10
[NAME] |  | 185
[NAME] |  |  | 31
Need:
Name | Height | Weight | Age
[NAME] | 5'5 | 150 | 35
[NAME] | 5'10 | 185 | 31
Spreadsheet: 583147d1532280475-get-unique-values-excluding-2-sample-workbook
Sheet: Sheet1

 |  |  |  | Unique Values |  | Expected Value
 |  | A |  |  |  | A
 |  | B |  |  |  | B
 |  | C |  |  |  | C
 |  | D |  |  |  | D
 |  | E |  |  |  | G
 |  | F
 |  | G
Spreadsheet: 82363d1282371018-look-up-the-part-code-having-end-with-desired-character-1234
Sheet: CNDDRKCCR

 |  |  | 12301-GB6-9000C
 |  |  | 12341-GB6-9100C
 |  |  | 90201-GF6-0000C
Part Code | Part name
1100661 | OIL ENGINE 10 W 30 - SJ GRADE
12301-GB6-9000C | COVER CYLINDER HEAD
12331-GB0-9100 | COVER R CYLINDER HEAD SIDE
12341-GB6-9100C | COVER L CYLINDER HEAD SIDE
[PHONE] | HOLE CAP TAPPET ADJUSTING
12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER
98056-57718-01 | SPARK PLUG
90201-GF6-0000C | NUT CAP 7MM
90442-GF6-0000 | WASHER SEALING 7 MM
90443-GF6-0000 | WASHER A SEALING 7 MM
[PHONE] | WASHER SEALING 12 MM
91302-KEV-9000 | O-RING 30.8X3
95701-06110-00 | BOLT FLANGE 6X110
96001-06020-00 | BOLT FLANGE SH.6X20
12191-KRS-C100 | GASKET CYLINDER
Spreadsheet: 212520d1360157717-need-help-auto-generate-columns-stafprofile
Sheet: weight

Name | Weight
Spreadsheet: 789769d1659357882-need-help-with-tax-tables-tax-sample
Sheet: Sheet2

0 - 50 000 | Not taxable | 0 |  | 0 |  | 500000
50 0001 - 100 000 | 18% for each N$ above 50 000 | 50000 |  | 0.18
100 001 - 300 000 | 9 000 + 25% for each N$ above 100 000 | 100000 | 9000 | 0.25
300 001 - 500 000 | 59 000 + 28% for each N$ above 300 000 | 300000 | 59000 | 0.28
500 001 - 800 000 | 115 000 + 30% for each N$ above 500 000 | 500000 | 115000 | 0.3
801 001 - 1 500 000 | 205 000 + 32% for each N$ above 800 000 | 800000 | 205000 | 0.32
Above 1 500 000 | 429 000 + 37% for each N$ above 1 500 000 | 1500000 | 429000 | 0.37
 |  |  |  |  | 25572.58
 |  |  |  |  | 7541.04
 |  |  |  |  | 1156
 |  |  |  |  | 1790.08
 |  |  |  |  | Tax table | 300000
 |  |  |  |  |  |  | x | 0.28
 |  |  |  |  |  | 59000
Spreadsheet: 219089d1362666623-if-then-statement-that-assigns-another-cell-value-vlookup-solution
Sheet: Sheet1

 | Gross Margin | Score |  |  |  |  |  |  | Gross Margin | Score
 | 50000 |  |  |  |  |  |  |  | 0 | 5
 |  |  |  |  |  |  |  |  | 100000 | 15
 |  |  |  |  |  |  |  |  | 250000 | 25
 |  |  |  |  |  |  |  |  | 500000 | 35
 |  |  |  |  |  |  |  |  | 750000 | 45
 |  |  |  |  |  |  |  |  | 1000000 | 55
 |  |  |  |  |  |  |  |  | 1500000 | 65
 |  |  |  |  |  |  |  |  | 2000000 | 75
Spreadsheet: 06f692fa-9da6-4d8f-a284-9b7cedaf7a48
Sheet: 2012 Aggregate Report

Aggregate Report | City of Carrollton
Contract Period | 1/1/13 - 12/31/13
Contract Terms | 15/12
Carrier | ULLICO
Benefits Included | Medical, Rx
ISL Deductible | 225000
Lasers | Member 1 - $1.25 million
 | Member 2 - $375,000
 |  | ATTACHMENT POINTS
Month | Single Lives | Total | Family Lives | Total | Total Net Aggregate Claims
2013/01 | 290 |  | 427 |  | 492349.4500000001
2013/02 | 292 |  | 433 |  | 418216.79
2013/03 | 295 |  | 431 |  | 501443.72
2013/04 | 299 |  | 430 |  | 609030.39
2013/05 | 298 |  | 429 |  | 697545.39
2013/06 | 300 |  | 427 |  | 683270.3
2013/07 | 304 |  | 427 |  | 546008.6799999999
2013/08 | 311 |  | 430 |  | 529903.6499999999
2013/09 |  |  |  |  | 0
2013/10 |  |  |  |  | 0
2013/11 |  |  |  |  | 0
2013/12 |  |  |  |  | 0
Year-To-Date |  |  |  |  | 4477768.369999999
Spreadsheet: 131263d1322839009-if-equal-to-then-insert-entire-row-ttttexfor
Sheet: Sheet2

[NAME] | Doe | abc | 100 | en-US | USA | yes
[NAME] | Doe | abc | 100 | en-US | USA | yes
[NAME] | Doe | abc | 100 | en | USA | yes
Spreadsheet: 120479d1315323075-dropdown-list-generate-records-meeting-criteria
Sheet: Sheet1

 |  |  |  | Unique List
 | Item | Price | Sub |  |  |  |  | Unique List
 | CAB | 321 | SD5 |  |  |  |  | CAB
 | DENT | 15 | SD8R |  |  |  |  | DENT
 | CAB | 452 | SDR5 |  |  |  |  | BIN
 | BIN | 111 | GTY |  |  |  |  | SUB
 | SUB | 10005 | BHK |  |  |  |  | [NAME]
Source | BIN | 5436 | MNJ |  |  |  |  | #N/A
 | [NAME] | 123 | DS1E2 |  |  |  |  | #N/A
 | CAB | 0 |  |  |  |  |  | #N/A
 | [NAME] | 7 | D24R |  |  |  |  | #N/A
 | DENT | 895 | 5W5D |  |  |  |  | #N/A
 | [NAME] | 569 | T651 |  |  |  |  | #N/A
 | CAB | 54 |  |  |  |  |  | #N/A
 |  |  |  |  | Inset>Name>Define: Name:UniqueListValidation; [NAME]:
Lookup records for |  | CAB
 |  | Price | Sub
 |  | 321 | SD5
 |  | 452 | SDR5
 |  | 0
 |  | 54
Spreadsheet: 696039d1600566187-how-to-efficiently-manage-trapping-value-and-n-a-errors-example-level-1-10-country-carnival-and-level-6-10-state-challenge-7th-and-8th-november-202
Sheet: Vault

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Springiest Vault Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award | Award Bagged
Club | Comp Number | First Name | Last Name | Level | Judge 1 |  | Judge 2 |  | Scratch | Average | Score | [NAME] | Springiest Vault | Sportmanship | Superhero Costume
 |  |  |  |  | Vault 1 | Vault 2 | Vault 1 | Vault 2
ABC | 1111 | Gymnast | One | 3 | 1.3 |  | 1.1
ABC | 2222 | Gymnast | Two | 4 |  | 0.5 |  | 0.3
ABC | 3333 | Gymnast | Three | 5
XYZ | 9999 | Gymnast | One | 3
XYZ | 8888 | Gymnast | Two | 3
XYZ | 7777 | Gymnast | Three | 4
XYZ | 6666 | Gymnast | Four | 4
XYZ | 5555 | Gymnast | Five | 5
XYZ | 4444 | Gymnast | Six | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 743805d1628739626-generate-random-list-of-numbers-with-constraints-and-targets-randbetween-list-with-constraints
Sheet: Sheet1

Target | Min | [NAME] | Number of Random Numbers |  |  | Average
 | 200 | 320 | 140 |  |  | 250
Spreadsheet: 721022d1614431136-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-2-
Sheet: Manpower Cost

 |  | Cost per Minute
Doctors | Senior Consultant | 1
Doctors | Consultant | 1
Doctors | Associate Consultant | 1
Doctors | Resident | 1
Doctors | Medical Officer | 1
Nurses | Senior Nursing Officer | 1
Nurses | Nursing Officer | 1
Nurses | Assistant [NAME] | 1
Nurses | Senior Staff Nurse | 1
Nurses | Staff Nurse | 1
Nurses | Senior Assistant [NAME] | 1
Nurses | Assistant Nurse | 1
Nurses | Principal Assistant Nurse | 1
PSA | Senior PSA | 1
PSA | PSA | 1
AHP&Pharm | AHP (e.g. [NAME], Dietician, Psychologist, Podiatrist) | 1
AHP&Pharm | AHP Assistant (e.g. [NAME], [NAME], P&O Asst) | 1
AHP&Pharm | Pharmacist | 1
AHP&Pharm | Med Technologist | 1
AHP&Pharm | Radiographer | 1
AHP&Pharm | Phlebotomist | 1
Spreadsheet: 696858d1601011850-vlookup-with-concat-vlookup-with-concat-problem
Sheet: Sheet1

1 | D5212 ( [NAME] partial - resin base )
1 | D5110 ( Complete denture - maxillary )
2 | D5110 ( Complete denture - maxillary )
1 | D9940 ( Occlusal guards; by report )
2 | D5120 ( Complete denture - mandibular )
3 | D5211 ( Maxillary partial - resin base )
2 | D9940 ( Occlusal guards; by report )
2 | D5211 ( Maxillary partial - resin base )
3 | D5212 ( [NAME] partial - resin base )
3 | D9940 ( Occlusal guards; by report )
Spreadsheet: 290361d1389858719-combining-several-rows-in-one-excel_list
Sheet: Лист1

 | What is now
 |  | Column1 | Column2 | Column3 | Column4
 |  | Name | A | [NAME] | YYY
 |  | Name | B | [NAME] | YYY
 |  | Name | C | [NAME] | YYY
 | Desired result
 |  | Column1 | Column2 | Column3 | Column4
 |  | Name | A B С | [NAME] | YYY
Spreadsheet: 238468d1369574201-4-digit-code-for-similar-product-new-product-unique-code-4-digit-codes-cleaned-up
Sheet: Sheet1

 | Fruit | ID
 | Apple
 | Apple
 | Orange
 | Apple
 | Orange
 | Peach
 | Peach
 | Grapes
 | Grapefruit
Spreadsheet: 151812d1335132380-excel-2007-help-calculating-winning-outcomes-for-gambling-against-my-friend-on-ufc-fights-ef819909-friday-night-fights
Sheet: Sheet1

My Guy | Abel | [NAME] | [NAME] | [NAME]
My Line | 1.41 | 1.32 | 1.38 | 2.67
My Bet | 2000 | 2500 | 2000 | 1500
His [NAME] | Abel | Fred | Gene | Hank
His Line | 1.41 | 3.61 | 1.38 | 1.49
His Bet | 4000 | 1000 | 2000 | 1000
 | MyGuy1 | MyGuy2 | MyGuy3 | MyGuy4 |  | I Win | He Wins | Winner
Spreadsheet: 775503d1649153893-create-an-excel-table-that-sums-multiple-columns-from-a-multiple-drop-down-selection-multi-list-selection
Sheet: DATA

TITLE | LICENCE START DATE | LICENSE PERIOD (YRS) | TOTAL COST | COST PER YR | CURRENCY | FX RATE | £GBP TOTAL COST | £GBP PER YEAR | FINANCIAL TIER (1-3) Tier 1 - 0-5k Tier 2 - 5-13k Tier 3 - 13k+ | [NAME] | GENRE | DEAL TYPE
[NAME] [NAME] | 2022-07-18 00:00:00 | 10 | 20000 |  | GBP | 1 | 20000 | 2000 | 1 | A | Dance | Ongoing
[NAME] performance | 2022-08-07 00:00:00 | 3 | 21000 |  | GBP | 1 | 21000 | 7000 | 2 | B | Theatre | Ongoing
I Capuleti e I Montecchi | 2022-04-30 00:00:00 | 3 | 27000 |  | GBP | 1 | 27000 | 9000 | 2 | A+ | Theatre | Ongoing
[NAME] in Sound | 2022-09-02 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | C | Opera | Ongoing
Maestras - The Long Journey of Women to the Podium | 2022-08-20 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A | Opera | Ongoing
The Land of Smiles | 2022-07-01 00:00:00 | 2 | 3000 |  | USD | 1.36 | 2205.882352941176 | 1102.941176470588 | 1 | B | Opera | Ongoing
The Pianist of Yarmouk | 2022-06-04 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A+ | Opera | Ongoing
[NAME] | 2022-12-08 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | C | Opera | Ongoing
Werther | 2022-06-20 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A | Opera | Ongoing
Wozzeck | 2022-10-02 00:00:00 | 2 | 3000 |  | USD | 1.36 | 2205.882352941176 | 1102.941176470588 | 1 | B | Dance | Ongoing
Stepping into the Unknown: The Choreographer Christian Spuck | 2022-12-20 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A+ | Dance | Ongoing
Taking Risks | 2022-02-14 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | C | Dance | Ongoing
Festival Cities and the Crisis | 2022-09-16 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A | Dance | Ongoing
[NAME]: Romeo und Julia | 2022-05-12 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | B | Dance | Ongoing
[NAME]: The Nutcracker and [NAME] | 2022-03-28 00:00:00 | 2 | 3000 |  | USD | 1.36 | 2205.882352941176 | 1102.941176470588 | 1 | A+ | Dance | Ongoing
[NAME]: Nabucco | 2022-08-22 00:00:00 | 2 | 3000 |  | USD | 1.36 | 2205.882352941176 | 1102.941176470588 | 1 | C | Dance | Ongoing
[NAME]: [NAME] | 2022-11-11 00:00:00 | 2 | 3000 |  | USD | 1.36 | 2205.882352941176 | 1102.941176470588 | 1 | A | Dance | Ongoing
Igor Stravinsky: The Rake’s Progress | 2022-11-03 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | B | Dance | Ongoing
EL CRUCE SOBRE EL NIÁGARA | 2022-03-26 00:00:00 | 2 | 4000 |  | USD | 1.36 | 2941.176470588235 | 1470.588235294118 | 1 | A+ | Dance | Ongoing
Soledad | 2022-06-11 00:00:00 | 2 | 450 | 450 | EUR | 1.2 | 375 | 375 | 1 | C | Documentary | Ongoing
A Swan Lake | 2022-05-07 00:00:00 | 2 | 650 | 650 | EUR | 1.2 | 541.6666666666667 | 541.6666666666667 | 1 | A | Music | Ongoing
Spreadsheet: 737401d1624395207-help-with-index-and-match-functions-that-act-dynamically-example
Sheet: Provider Incremental Pt Revenue

 | PROVIDER INCREMENTAL PATIENT REVENUE
 | ANNUAL REFILL VOLUME
 | TOTAL # OF PROVIDERS
 | CURRENT STATE |  |  |  |  |  | FUTURE STATE
 |  |  |  | % | DAILY | ANNUAL |  |  |  | % | DAILY | ANNUAL
 | REFILLS RECEIVED |  |  | 0.75 |  |  | REFILLS RECEIVED |  |  | 0.25
 | STAFF | REFILLS/DAY | MINS/REFILL | FTE | [NAME] | TOTAL COST | STAFF | REFILLS/DAY | MINS/REFILL | FTE | [NAME] | TOTAL COST
 | MD |  | 2 |  |  |  | MD |  | 0.5
 | REVENUE FROM ADDITIONAL VISITS
 | Provider Hours Saved Per Year
 | Provider FTE Saved Per Year
 | % of Hours For Additional Office Visits |  |  |  | 0.5
 | Visits Per Hour |  |  |  | 3
 | Revenue Per Visit |  |  |  | 75
 | Potential Additional Revenue Generated
Spreadsheet: 869032d1715703633-how-to-filter-a-column-based-on-a-column-in-a-different-file-all-comptuers2
Sheet: Report (31)

Name | GuestLastBootTime | GuestMachineSerialNumber | CustomProperty1
LAB1-7 | 2024-04-08 20:17:59 | 2993PD2 | ACME
LAB1-4 | 2023-12-19 21:28:02 | J4BDF42 | ACME
LAB1-12 | 2024-04-24 04:42:08 | 3FRQX14 | ACME
LAB009 | 2022-09-13 16:51:59 | JLSRX14 | ACME
LAB1-31 | 2024-02-07 20:24:27 | 313RX14 | ACME
LAB1-28 | 2024-04-08 16:05:38 | 963RX14 | ACME
LAB1-23 | 2023-03-14 19:00:03 | J49CF42 | ACME
LAB1-8 | 2022-11-24 21:19:03 | 2594PD2 | ACME
LAB1-22 | 2024-04-02 18:58:53 | J49FF42 | ACME
Spreadsheet: 183143d1348721371-auto-fill-and-check-box-hide-help-me-please-help
Sheet: Sheet2

Employment | B1 | Type
 |  | Company Name | Phone: |  | Fax: |  | [NAME]:
 |  | Address | City | State | Zip | county
 |  | Date Called
 | B2 | Type
 |  | Company Name | Phone: |  | Fax: |  | [NAME]:
 |  | Address | City | State | Zip | county
 |  | Date Called
I want B1-H3 and B6-H8 to fill automatically here when I complete it on sheet one
Spreadsheet: 850708d1701097920-creating-a-list-from-a-table-using-multiple-criteria-book2-namiridite-
Sheet: Tracker

Tracker
Category | Code | Person | Date | Number
Bananas | IP23 | [NAME] | 2023-03-07 00:00:00 | 1
Apples | IP24 | Michelle | 2023-11-08 00:00:00 | 2
Lemons | IP23 | Michelle | 2023-11-09 00:00:00 | 1
Bananas | IP23 | Michelle | 2023-11-20 00:00:00 | 4
Bananas | IPKL | [NAME] | 2023-10-30 00:00:00 | 5
Lemons | SO92 | [NAME] | 2023-10-30 00:00:00 | 3
Bananas | SO92 | [NAME] | 2023-10-30 00:00:00 | 6
Bananas | IP24 | [NAME] | 2023-05-11 00:00:00 | 7
Apples | SO8E | [NAME] | 2023-05-11 00:00:00 | 8
Spreadsheet: 718123d1612993413-stat-tools-add-in-for-forecasting-hardware-sales-example
Sheet: Forecast (2)

StatTools Report
Analysis: | Forecast
Performed By: | [NAME]
Date: | Wednesday, February 10, 2021
Updating: | Live/Unlinked
Moving Averages Forecasts for Sales
Forecasting Constant
Span | 3
Moving Averages
Mean Abs Err
Root Mean Sq Err
Mean Abs Per% Err
Forecasting Data | Sales | Forecast | Error
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
Spreadsheet: 210812d1359567469-really-need-help-please-automation-across-sheets-sample-excel
Sheet: CONFIRMED ATTENDEES

New Employees Induction Confirmed Attendees
This sheet is automated. Data checkpoint: Ensure complete and accurate details on 'Guest List Names' sheet.
Prefix | Surname | First Name | Nickname | Position | Division | Assignment
Spreadsheet: 706589d1606786178-need-to-return-first-occurrence-of-job-in-array-return-jobs-_excel-forum
Sheet: Master sheet

Customer | S/O | Ship date | P/N | JOB# | Sub-ASY JOB#'S | Mechanical jobs
Customer 1 | 15006 | 2018-09-21 00:00:00 | P/N 1 | 25022 | N/A | N/A
Customer 2 | 15372 | 2019-01-17 00:00:00 | P/N 2 | 24358 | 24394, 24486, 19714 | 24732
Customer 3 | 15675 | 2019-03-05 00:00:00 | P/N 3 | 23106 | 23105 | N/A
Customer 4 | 15675 | 2019-03-05 00:00:00 | P/N 4 | 22823 | N/A | N/A
Customer 5 | 15675 | 2019-03-05 00:00:00 | P/N 5 | Stock | N/A | N/A
Customer 6 | 15675 | 2019-03-05 00:00:00 | P/N 6 | Stock | N/A | N/A
Customer 7 | 16253 | 2019-09-12 00:00:00 | P/N 7 | 24159 | 24105 | 23917, 24167
Customer 8 | 16370 | 2019-10-18 00:00:00 | P/N 8 | 21781 | 19674 | N/A
Customer 9 | 16421 | 2019-12-02 00:00:00 | P/N 9 | 24966 | N/A | 24974
Customer 10 | 15889 | 2019-12-02 00:00:00 | P/N 10 | 19714 | 19715, 19712, 19713, 19711, 19735, 19716, 19734, 19717, 20361 | N/A
Customer 11 | 16421 | 2019-12-02 00:00:00 | P/N 11 | 24343 | 24025, 24395 | 24374
Customer 12 | 16690 | 2019-12-13 00:00:00 | P/N 12 | 23401 | 27020, 27063, 25931, 26566 | N/A
Customer 13 | 16483 | 2019-12-13 00:00:00 | P/N 13 | 25315 | 25319 | 25314, 25316
Customer 14 | 16690 | 2019-12-13 00:00:00 | P/N 14 | 26567 | N/A | N/A
Customer 15 | 16690 | 2019-12-13 00:00:00 | P/N 15 | 27096 | 27050 | N/A
Customer 16 | 16671 | 2019-12-19 00:00:00 | P/N 16 | 26194 | N/A | 26195
Customer 17 | 16654 | 2020-01-08 00:00:00 | P/N 17 | 22623 | 22678, 22628, 22397, 22314, 22412, 21606, | 22627
Customer 18 | 16707 | 2020-01-10 00:00:00 | P/N 18 | 23948 | N/A | 23952, 23953
Customer 19 | 16559 | 2020-01-10 00:00:00 | P/N 19 | 24721 | 25333, 24945 | 25370, 24726, 24727
Customer 20 | 16953 | 2020-01-13 00:00:00 | P/N 20 | 25449 | 23623, 16861 | N/A
Customer 21 | 16506 | 2020-01-31 00:00:00 | P/N 21 | 23675 | 16595, 18285 | N/A
Customer 22 | 16995 | 2020-02-04 00:00:00 | P/N 22 | 24638 | 25717, 25073 | N/A
Customer 23 | 16616 | 2020-02-07 00:00:00 | P/N 23 | Stock | N/A | N/A
Customer 24 | 16616 | 2020-02-07 00:00:00 | P/N 24 | 22958 | 22963, 22805, 22806,22992 | 22942, 22966
Customer 25 | 16616 | 2020-02-07 00:00:00 | P/N 25 | 22958 | 22963, 22991, 22992, 22988, 23843, 23214, 23844 | 22966
Customer 26 | 16616 | 2020-02-07 00:00:00 | P/N 26 | Stock | N/A | N/A
Customer 27 | 16616 | 2020-02-07 00:00:00 | P/N 27 | Stock | N/A | N/A