tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796333d1663228569-summing-with-a-criterion-uniforms
Sheet: Sheet2

[NAME] |  |  |  | PURCHASED STOCK | TOTAL ISSUED
MAGNUM TROUSERS |  |  |  | 200 |  | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 40 | 42 | 44 | 46 | 48 | 50
COMBAT TROUSERS |  |  |  |  |  | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 40 | 42 | 44 | 46 | 48 | 50
LONG SLEEVE SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
SHORT SLEEVE SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
T-SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
JERSEY'S |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
PULL OVERS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
COMBAT BOOTS |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
RAIN JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
WARM JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
SHOES |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
SOCKS
WEB BELTS
LEATHER BELTS
BASEBALL CAPS
JUMPSUITS
STEP OUT TUNICS
KENNY JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
REFLECTIVE JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
BULLET PROOF VESTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
LADIES SKIRTS
GUM BOOTS W/ZIP |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
PANTY [NAME]'S
OVERAL 2-PIECE'S
FORMAL JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
GREEN CROSS SHOES |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
LANYARDS
APPLETS
BEANIE'S
HAND GLOVES
RANKS
NAME TAGS
SHOULDER FLASHES
LADIES HANDBAG
SCARF
TIE'S
FACIAL MASKS
STUN GUN
TORCHES
PEPPER SPRAYS
BATONS
HOLSTERS
[NAME]
RIOT GEARS
LEG HOLSTERS
BADGES
L/E BUFF'S
ARM SLEEVES
Spreadsheet: 08d6ce26-2819-4ac2-8f2d-ae864951e6d1
Sheet: Program-CurriculumDev

[NAME] | Principle | Approach | Key Players | MC Assignment | Timeline | Progress to Date
Program/Curriculum Development | New programs sustain the college enrollment
 | Curriculum provides the framework for innovation, transfer, career technology and basic skills
 | Programs support community interest, articulation and student completion
 | Enrollment
 | Innovation
 | Staff/Professional Development
 | Technology, Sustainability and Efficiency
 | Achievement and Success
 | Enrollment | Necessary for upcoming competition for  enrollments
 |  | Additional programs/curriculum necessary  for STEM
 |  | Additional programs/curriculum necessary  for increased transfer opportunity
 |  | SB 1440 provides increased transfer and  should be capitalized
 | Innovation | College trends analysis informs program  review and  new program development
 |  | Community and Business needs inform  program  review and new program  development
 |  | Other data sources inform the college on  needed programs and programs that  provide  educational and business partnerships
 |  | Make program development a hiring criteria for  faculty
 | Staff/Professional Development | Faculty planning and program development  allows for necessary professional  development
 |  | Program and Curriculum development  includes faculty mentors, business mentors  and other professional development  coaching as part of the program process
 |  | Technology professional development  infused in all curriculum / program  development
 |  | Technology professional development  infused in all program labs and student  support services
 | Technology Sustainability and Efficiency | Increased availability and use of software in  support labs
 |  | Increased online courses and fully online  programs
 |  | Increased program and department  marketing  via the web and college homepage
 |  | Increased program efficiencies through  planning systems, technology processes and  integrated technology systems
 | Achievement and Success | Create measures for student success and  increase by program
 |  | Create measures for student retention and  increase by program
 |  | Create measures for student completion   a. accelerated learning   b. support services   c. student assessment, orientation,     counseling/planning, career and transfer   identification
Spreadsheet: 156319d1337263169-pivot-table-data-example
Sheet: Sheet2

Sum of Quantity | Column Labels
Row Labels | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | Grand Total
Bex |  |  |  | 8 |  |  |  |  |  |  |  | 6 | 5 | 8 |  |  | 27
Dex |  | 4 |  |  | 7 |  |  |  | 4 | 3 | 5 |  |  |  |  |  | 23
Hex | 3 |  | 6 |  |  | 4 | 6 | 5 |  |  |  |  |  |  | 8 | 4 | 36
Grand Total | 3 | 4 | 6 | 8 | 7 | 4 | 6 | 5 | 4 | 3 | 5 | 6 | 5 | 8 | 8 | 4 | 86
Spreadsheet: 715754d1611851851-i-need-assistance-on-a-if-lookup-search-excelhelp-2021-01-28
Sheet: Sheet1

RAW Data:  Applications Installed: | Testing Forumula Finds Primary so far | [NAME] is to also find Secondary | RAW Data Primary: | RAW Data Secondary:
Powershell 7-x64 |  | Primary | Powershell | Microsoft Edge
Powershell 7-x64 |  | Primary | Adobe | Internet Explorer
Powershell 7-x32 |  | Primary |  | Firefox
[NAME] |  | Secondary |  | [NAME]
Chrome v29.3.3 |  | Secondary |  | Chrome
Office 10.1 |  | remaining
Powershell 9 |  | Primary
[NAME] |  | Primary
Adobe Photoshop |  | Primary
Adobe Illustrator |  | Primary
Microsoft Edge |  | Secondary
Microsoft Edge |  | Secondary
Internet Explorer |  | Secondary
Firefox |  | Secondary
[NAME] |  | Secondary
[NAME] |  | Secondary
Powershell |  | Primary
Office 10.1 |  | remaining
Firefox |  | Secondary
Spreadsheet: elizabeth_sager__9467__Virt Bidding Credit Req data
Sheet: Summary Percentile

NYISO
Frequency Distribution
of Price Delta by Zone
June, July, August 2001 (to 8/31/2001)
(Peak Hours)
(DAM-RTM)
Frequency Occurence | WEST | CENTRL | MHK VL | CAPITL | HUD VL | GENESE | LONGIL | NORTH | N.Y.C. | MILLWD | DUNWOD | H Q | NPX | O H | PJM
0.1 | 1.29 | 1.5 | 1.5 | 1.63 | 1.760000000000005 | 1.3 | 1.2 | 1.4 | 2.12 | 1.55 | 1.51 | 1.52 | 1.95 | 1.39 | 1.79
0.2 | 2.78 | 3.11 | 3.09 | 3.28 | 3.27 | 2.75 | 2.78 | 2.91 | 4.18 | 3.22 | 3.23 | 2.97 | 3.519999999999982 | 2.66 | 3.33
0.3 | 4.3 | 4.81 | 4.95 | 5.14 | 5.26 | 4.31 | 4.58 | 4.7 | 6.42 | 5.04 | 4.97 | 4.71 | 5.45 | 4.12 | 5.04
0.4 | 5.73 | 6.52 | 6.86 | 7 | 7.09 | 5.85 | 7.57 | 6.39 | 8.71 | 6.87 | 6.88 | 6.29 | 7.06 | 5.51 | 6.73
0.5 | 7.529999999999994 | 8.14 | 8.580000000000005 | 9.02 | 9.2 | 7.59 | 11.97 | 8.05 | 11.32 | 8.76 | 8.77 | 8 | 9.17 | 6.97 | 8.27
0.6 | 9.16 | 10.06 | 10.48 | 11.3 | 11.59 | 9.33 | 18.57 | 9.81 | 14.24 | 11.24 | 11.09 | 9.71 | 11.66 | 8.57 | 10.07
0.7 | 11.34 | 12.37 | 13.02 | 14.1 | 14.62 | 11.65 | 35.14 | 12.56 | 18.3 | 14.41 | 14.35 | 12.63 | 14.7 | 10.82 | 12.48
0.8 | 14.75 | 16.01 | 17.17 | 18.51 | 19.96 | 15.2 | 48.97 | 16.4 | 25.85 | 20.14 | 20.19 | 16.7 | 19.29 | 14.27 | 16.37
0.9 | 24.12 | 25.42 | 26.65 | 31.37 | 40.54 | 24.95 | 71.57 | 26.54 | 45.78 | 44.09 | 44.11 | 29.01 | 34.25 | 25.03 | 27.02
0.92 | 28.91 | 31.03 | 33.1 | 37.46 | 49.4 | 30.17 | 91.8 | 31.66 | 63.52 | 59.27 | 59.82 | 34.49 | 43.94 | 30.84 | 33.7
0.94 | 35.66 | 38.03 | 38.96 | 50.11 | 70.25 | 36.86 | 106.49 | 38.93 | 83.73 | 81.29 | 82.74 | 42.48 | 56.68 | 37.58 | 46.51
0.96 | 49.9 | 50.67 | 52.45 | 77.01 | 95.68 | 49.55 | 132.79 | 52.49 | 110.84 | 107.98 | 109.44 | 57.27 | 80.85 | 53.17 | 73.06
0.97 | 71.37 | 71.61 | 72.76 | 100.81 | 109.52 | 69.96 | 156.87 | 71.52 | 159.33 | 155.46 | 158.52 | 77.14 | 103.1 | 74.78 | 87.27
0.98 | 90.16 | 91.45 | 98.42 | 148.9 | 200.91 | 89.15 | 244.68 | 92.56 | 252.65 | 245.72 | 249.48 | 101.47 | 146.48 | 93.35 | 121.38
0.99 | 150.51 | 149.56 | 152.27 | 259.54 | 301.75 | 143.7 | 398.99 | 142.28 | 405.96 | 396.8 | 404.13 | 149.81 | 264.75 | 171.96 | 244.68
1 | 827.11 | 821.66 | 847.2 | 882.81 | 894.06 | 838.29 | 885.09 | 809.26 | 898.06 | 882.03 | 895.77 | 799.3 | 931.12 | 932.72 | 932.04
Spreadsheet: 101361d1299513600-linking-workbooks-example
Sheet: Apr

 | Unit Sold
Salesman1 | 692
Salesman2 | 408
Salesman3 | 171
Salesman4 | 530
Salesman5 | 776
Salesman6 | 281
Salesman7 | 250
Salesman8 | 471
Salesman9 | 398
Salesman10 | 503
Salesman11 | 273
Salesman12 | 815
Salesman13 | 289
Salesman14 | 328
Salesman15 | 206
Salesman16 | 652
Salesman17 | 739
Salesman18 | 457
Salesman19 | 896
Salesman20 | 91
Salesman21 | 822
Salesman22 | 790
Spreadsheet: 31629d1227570147-multiple-cut-offs-possible-array-solution-sample
Sheet: Sheet1

 | var1 | var2 | var3 | var4 | var5
Set 1 | 6 | 6 | 7 | 6 | 7
Set 2 | 6 | 7 | 6 | 7 | 6 |  |  |  | This isn't too bad if there is a small set of variables… but it gets worse as I add variables
Set 3 | 5 | 5 | 5 | 5 | 5 |  |  |  | Is there an array solution of some sort?
Set 4
Set 5
 | var1 | var2 | var3 | var4 | var5 | Set 1 | Set 2 | Set 3 | Set 4 | Set 5
person 1 | 8 | 7 | 6 | 5 | 9 | 2 | 1 |  |  |  | <<<<- What is the easiest way to populate these "set" scores?
person 2 | 8 | 10 | 9 | 5 | 7 | 1 | 1
person 3 | 5 | 5 | 6 | 2 | 7 | 4 | 3
person 4 | 6 | 3 | 7 | 6 | 6 | 2 | 2
person 5 | 6 | 7 | 5 | 4 | 6 | 3 | 2
person 6 | 6 | 5 | 9 | 7 | 4 | 2 | 2
person 7 | 6 | 7 | 4 | 4 | 3 | 3 | 3
person 8 | 6 | 5 | 5 | 5 | 5 | 4 | 4
person 9 | 9 | 9 | 6 | 7 | 7 | 1 | 0
person 10 | 7 | 7 | 6 | 9 | 8 | 1 | 0
person 11 | 5 | 6 | 7 | 5 | 3 | 3 | 4
person 12 | 6 | 8 | 6 | 7 | 6 | 2 | 0
person 13 | 6 | 6 | 4 | 4 | 3 | 3 | 4
person 14 | 3 | 4 | 4 | 1 | 2 | 5 | 5
person 15 | 7 | 6 | 8 | 10 | 9 | 0 | 1
person 16 | 6 | 5 | 7 | 7 | 9 | 1 | 1
person 17 | 4 | 5 | 6 | 1 | 3 | 5 | 4
Spreadsheet: 158256d1338116316-excel-vlookup-issue-testsetup-5-
Sheet: Sheet1

 |  |  |  | Size | 54" 8' |  | data validation is allow /list =mydrop
Name | CH | LF | OP | Pan | Net Pan | Yds
WC-q | 8 | 453 | 1 | 104.5465035771982 | 105 | 286.3636363636364
 |  |  |  |  |  | named range is |  | refers to | dynamic range
 |  |  |  |  |  | mydrop
 |  |  |  |  |  | just add to col a and validation will also change
Size | Result | Result2
54" 8' | 4.333 | 286.3636363636364
54" 9' | 4.333 | 350
54" 10' | 4.333 | 393.75
bbb
[NAME]
Spreadsheet: 74553d1275045749-adjusting-a-formula-based-on-a-value-of-another-cell-proactive
Sheet: Rates

 | Rates
 |  | Invoice | Ret Invoice
 | Basic | 12.25 | 11.75
 | Overtime | 16.43 | 14.93
 | Saturday | 15.87 | 15.37
 | Sunday | 17.39 | 16.89
 | Bank Holiday | 18.84 | 18.34
 | Night Out | 22 | 22.2
Spreadsheet: 03508000-4a6e-411e-a9d9-29f9222c97ce
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
266865 | 82247 | [NAME] | Chalmers | GBR | 802 | 00:17:50 | 00:39:54 | 00:00:00 | 00:00:00 | 00:11:11 | 1 | 01:09:58
266865 | 82246 | Tasmin | [NAME] | GBR | 801 | 00:20:57 | [NAME] | 00:00:00 | 00:00:00 | 00:12:28 | 2 | [NAME]
266865 | 82245 | Agnethe | Underbjerg | DEN | 803 | 00:20:01 | 00:43:56 | 00:00:00 | 00:00:00 | 00:12:22 | 3 | 01:17:47
Spreadsheet: 683007d1592424715-creating-dropdown-list-drom-dynamic-row-entries-dropdown-example
Sheet: Example

Sub Category | Problem |  |  |  | Please Select | Additional Clean | Till Out of Action | Cannot Secure or Cannot Open | Cannot Set or Unset Alarm | Come off runners | Communication Failure | Control panel fault | [NAME] |  | Please Select | Additional Clean | Till Out of Action | Cannot Secure or Cannot Open | Cannot Set or Unset Alarm | Come off runners | Communication Failure | Control panel fault | [NAME]
Automatic Controls |  |  |  |  | Y |  |  |  | Y |  | Y | Y | Y
BMS |  |  |  |  | Y | Y | Y |  |  |  | Y | Y | Y
Control Panels |  |  |  |  | Y |  |  |  | Y |  |  | Y | Y
Inverter |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y
Fire Alarm System |  |  |  |  | Y |  |  |  | Y |  | Y | Y | Y
Spreadsheet: 856382d1705639262-single-cell-formula-to-return-results-not-found-after-comparing-2-lists-kwoltman
Sheet: WS2

Username | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
A
B
C
D
E
F
A
B
C
A
B
C
A
B
C
Spreadsheet: 105752d1303033706-workload-analysis-workload
Sheet: Sheet1

Role | Level | Authority Range | Deal worked this yr | Authority Range New | Future Workload
Credit Manager | 1 | 1.5 - 2 M | 20 | 2 M
Relantionship Manag | 1 | .5 M | 10 | 0.25 M
Credit Manager | 2 | 1- 1.5 M | 35 | 1.5 M - 2 M
Relantionship Manag | 2 | .250 M | 45 | 0.5 M
Credit Manager | 3 | 1 M | 60 | 1.5 M
Relantionship Manag | 3 | .10 M | 56 | .25o M
Spreadsheet: 470400d1468458763-need-a-formula-that-tracks-our-students-absences-csdb-attendance
Sheet: BlankRecord

[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | © 2009-2014 Vertex42 LLC
[Name of Organization, Class, Club, etc.] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | NAME
Spreadsheet: 713889d1610994070-negative-cell-help-test-workbook
Sheet: Sheet1

Current Mortgage |  | Loan Scenario 1 | Loan Scenario 2 | Loan Scenario 3 | Loan Scenario 4
30 Year Fixed
385000
0.03125 |  | 0.02875 | 0.03 | 0.025 | 0.0275
360 |  |  |  | 240
515000
 | Payment Savings
2000 | Costs | 3500 | 3500 | 3500 | 3500
531 | Breakeven(Months)
69
251
Spreadsheet: 170747d1343392837-finding-cell-corresponding-to-kth-smallest-in-a-array-alexander_golinsky_solution
Sheet: Sheet1

Fri Jul 20 12:02:35 EDT 2012 | Jul 20 2012 | 2012-07-20 00:00:00 |  |  |  | Jan | 1
 |  |  |  |  |  | Feb | 2
 |  |  |  |  |  | Mar | 3
 |  |  |  |  |  | Apr | 4
 |  |  |  |  |  | May | 5
 |  |  |  |  |  | Jun | 6
 |  |  |  |  |  | Jul | 7
 |  |  |  |  |  | Aug | 8
 |  |  |  |  |  | Sep | 9
 |  |  |  |  |  | Oct | 10
 |  |  |  |  |  | Nov | 11
 |  |  |  |  |  | Dec | 12
Spreadsheet: 734997d1622642130-counting-duplicates-in-specific-case-example
Sheet: Sheet1

 | Name | Group |  |  |  | Attended more than once from Group A | 0
 | B.Almond | A |  |  |  | Attended more than once from Group B | 0
 | C.Carrot | B |  |  |  | Attended more than once from Group C | 0
 | D.Juice | C
 | B.Almond | A
 | A.Cabbage | C
 | C.Carrot | B
 | B.Fairy | A
 | B.Fairy | A
Spreadsheet: d7f3e263-899c-4fa6-88bf-25457ae9a41c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5338 | 7145 | [NAME] | Matheus | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:59:02
5338 | 9919 | Danilo | Pimentel | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:59:05
5338 | 33643 | Rafael | Beserra Da Fonseca | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:59:59
5338 | 33644 | Diego | [NAME] | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:01:07
5338 | 7938 | [NAME] | Rivera | CHI | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:06:52
Spreadsheet: 703953d1605266208-cant-apportion-multi-month-costs-by-month-monthly-subtotals
Sheet: COSTINGS

CATEGORY | Role/Element | Name/Product | Day Rate | Cost | From | To | Total |  |  | Month | Employee | Software | TOTAL
Employee | Developer |  | 100 |  | 2020-01-02 00:00:00 | 2020-02-12 00:00:00 |  |  |  | 2020-01-01 00:00:00
Employee | Manager |  | 200 |  | 2020-01-03 00:00:00 | 2020-01-17 00:00:00 |  | 43848 |  | 2020-02-01 00:00:00
Software | MS Excel |  |  | 125 | 2020-01-11 00:00:00 |  |  | 43842 |  | 2020-03-01 00:00:00
Employee | QA |  | 125 |  | 2020-01-21 00:00:00 | 2020-04-14 00:00:00 |  | 43863 |  | 2020-04-01 00:00:00
Employee | Analyst |  | 130 |  | 2020-02-01 00:00:00 | 2020-04-14 00:00:00 |  | 43863 |  | 2020-05-01 00:00:00
Employee | QA |  | 125 |  | 2020-03-11 00:00:00 | 2020-04-14 00:00:00 |  | 43863 |  | 2020-06-01 00:00:00
Employee | Developer |  | 100 |  | 2020-01-22 00:00:00 | 2020-02-12 00:00:00 |  | 43863 |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
Need formulae in [NAME] that sums costs for each month based on dates in Cols F - G and values in Col D |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | S/be: |  |  |  |  |  | Made up as:
 |  |  |  |  |  |  |  |  |  | Month | Employee | Software | TOTAL |  |  |  | Jan | Feb | Mar | Apr | Total
 |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 8375 | 125 |  |  |  | Employee | 3000 | 1200 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  | Employee | 3000 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  | Software | 125 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  | Employee | 1375 | 3625 | 3875 | 1750
 |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  | Employee | 0 | 3770 | 4030 | 1820
 |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  | Employee | 0 | 0 | 2625 | 1750
 |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  | Employee | 1000 | 1200 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: StatDays

Statutory Holidays
January | 2018-01-01 00:00:00
February | 2018-02-12 00:00:00
March | 2018-03-30 00:00:00
April
May | 2018-05-21 00:00:00
June
July | 2018-07-02 00:00:00
August | 2018-08-06 00:00:00
September | 2018-09-03 00:00:00
October | 2018-10-08 00:00:00
November | 2018-11-12 00:00:00
December | 2018-12-25 00:00:00 | 2018-12-26 00:00:00
Spreadsheet: 198233d1354715021-counting-of-unique-items-in-list-and-listing-unique-items-in-a-list-counting-and-creating-unique-list
Sheet: Sheet1

List
 |  | < < < This list contains "" and different repeated values in cell.
 |  | How do we make a formula in cell [NAME] to calculate the number of unique items?
 |  |  | < number of unique items
[NAME] |  |  | result is supposed to return an answer "4".
D1
 |  | And how do we make the items automatically list out into a table like below?
D1
 |  | List |  | List
 |  | [NAME]
 |  | D1
D1 |  | X1
 |  | F1
X1
X1
F1
Spreadsheet: 687391d1595177141-formula-that-check-values-in-colum-b-and-return-results-to-column-c-7777
Sheet: batch_analysis_export.utf-16

ahlens.se | 1002070 |  |  |  |  |  |  | 1 | 100,000+ | 5
byggmax.se | 974262 |  |  |  |  |  |  | 2 | 30,000-99,999 | 4.5
cdon.se | 853752 |  |  |  |  |  |  | 3 | 10,000-29,999 | 4
kjell.com | 555796 |  |  |  |  |  |  | 4 | 2,000-9,999 | 3.5
granngarden.se | 309093 |  |  |  |  |  |  | 5 | 500-1,999 | 3
cervera.se | 208533 |  |  |  |  |  |  | 6 | 100-499 | 2.5
beijerbygg.se | 201908 |  |  |  |  |  |  | 7 | 0-99 | 2
coolstuff.se | 114740
bagarenochkocken.se | 98622
svensktkosttillskott.se | 94127
tretti.se | 73025
kitchentime.se | 69394
elon.se | 68551
svenskhalsokost.se | 52709
svenssons.se | 38485
gardenstore.se | 36574
whiteaway.se | 23887
hemfint.se | 20559
robotexperten.se | 15082
inredningsvaruhuset.se | 10812
hultens.se | 10642
designtorget.se | 10457
solheminredning.se | 8063
hemmy.se | 6646
confidentliving.se | 5376
boxexperience.com | 2221
enemo.se | 644
skanskabyggvaror.se | 0
domain1.com | 50
domain2.com | 300
Spreadsheet: 72557d1273241565-forcing-cells-to-match-formats-schedule-workbook-for-upload
Sheet: Sat

 |  |  | Saturday, Spring 2010, May 8, 2010
 |  |  |  |  | 06:00:00
 | in |  | out |  |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30 |  | :30
Spreadsheet: 736110d1623352670-extracting-intermediate-values-from-start-and-end-points-of-line-book1
Sheet: Current Test Specs

 | Insertion Loss |  |  |  | Return Loss |  |  |  |  | INTERPOLATED
 | Frequency Start | Frequency Stop | [NAME] | [NAME] | Frequency Start | Frequency Stop | [NAME] | [NAME] |  |  | IL m | 5 | 400 | 600 | 1000 | 1200 |  | RL m | 5 | 400 | 600 | 1000 | 1200
0 | 5 | 1200 | 0.15 | 0.25 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -0.15 | -0.25
0.5 | 5 | 1200 | -0.35 | -0.25 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -0.65 | -0.75
1 | 5 | 1200 | -0.85 | -0.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -1.15 | -1.25
1.5 | 5 | 1200 | -1.35 | -1.25 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -1.65 | -1.75
2 | 5 | 1200 | -1.85 | -1.75 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -2.15 | -2.25
2.5 | 5 | 1200 | -2.35 | -2.25 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -2.65 | -2.75
3 | 5 | 1200 | -2.85 | -2.75 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -3.15 | -3.25
3.5 | 5 | 1200 | -3.35 | -3.25 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -3.65 | -3.75
4 | 5 | 1200 | -3.85 | -3.75 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -4.15 | -4.25
4.5 | 5 | 1200 | -4.35 | -4.25 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -4.65 | -4.75
5 | 5 | 1200 | -4.85 | -4.75 | 5 | 1200 | -27 | -25
 | 5 | 1200 | -5.15 | -5.25
6 | 5 | 1200 | -5.85 | -5.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -6.15 | -6.25
7 | 5 | 1200 | -6.85 | -6.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -7.15 | -7.25
8 | 5 | 1200 | -7.85 | -7.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -8.15 | -8.25
9 | 5 | 1200 | -8.85 | -8.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -9.15 | -9.25
10 | 5 | 1200 | -9.85 | -9.75 | 5 | 1200 | -27 | -24
 | 5 | 1200 | -10.15 | -10.25
11 | 5 | 1200 | -10.85 | -10.75 | 5 | 1200 | -27 | -23
 | 5 | 1200 | -11.15 | -11.25
12 | 5 | 1200 | -11.15 | -11.25 | 5 | 1200 | -27 | -23
 | 5 | 1200 | -12.15 | -12.25
13 | 5 | 1200 | -12.85 | -12.75 | 5 | 1200 | -27 | -23
 | 5 | 1200 | -13.15 | -13.25
14 | 5 | 1200 | -13.85 | -13.75 | 5 | 1200 | -27 | -23
 | 5 | 1200 | -14.15 | -14.25
15 | 5 | 1200 | -14.85 | -14.75 | 5 | 1200 | -27 | -22
 | 5 | 1200 | -15.15 | -15.25
16 | 5 | 1200 | -15.85 | -15.75 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -16.15 | -16.25
17 | 5 | 1200 | -16.85 | -16.75 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -17.15 | -17.25
18 | 5 | 1200 | -17.85 | -17.65 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -18.15 | -18.25
19 | 5 | 1200 | -18.85 | -18.65 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -19.15 | -19.25
20 | 5 | 1200 | -19.85 | -1965 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -20.15 | -20.25
21 | 5 | 1200 | -20.85 | -20.65 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -21.15 | -21.25
22 | 5 | 1200 | -21.85 | -21.65 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -22.15 | -22.25
23 | 5 | 1200 | -22.85 | -22.65 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -23.15 | -23.35
24 | 5 | 1200 | -23.85 | -23.55 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -24.15 | -24.35
25 | 5 | 1200 | -24.85 | -24.55 | 5 | 1200 | -27 | -19
 | 5 | 1200 | -25.15 | -25.35
26 | 5 | 1000 | -25.85 | -25 | 5 | 1200 | -27 | -19
 | 5 | 1000 | -26.15 | -26.35
75 | 5 | 10 | -34 | -34 | 5 | 1200 | -23 | -17
 | 10 | 1200 | -34 | -23
Spreadsheet: 750690d1633595834-matching-id-to-data-in-lookup-list-breakdown
Sheet: Sheet1

 | company id | name of company |  | company id | name of company | jan | feb | [NAME] | apr
 | 12345 | abc windows |  | 678910 |  | 0.2 | 0.4 | 0.3 | 0.1
 | 678910 | def windows |  | 42345 |  | 0.4 | 0.3 | 0 | 0.3
 | 42345 | ghi windows |  | 12345 |  | 0.5 | 0.1 | 0.1 | 0.3