tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 468286d1467216031-match-date-name-and-specific-shift-and-return-date-in-other-cell-example-schedule
Sheet: schedule

 |  |  | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00
Name | Position | PT | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00
First Name Middle Name Last Name1 | 1 |  | 8 | 8 | 8 |  |  | 8 | 8 | C | C | C |  |  | PL | PL | PL | PL | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8
First Name Middle Name Last Name2 | 1 |  | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 10 | C |  |  | 10 | 10 | 10 | 10
First Name Middle Name Last Name3 | 1 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 7 |  |  | C | SL | SL | SL | SL |  |  | SL | SL | SL | SL
First Name Middle Name Last Name4 | 1 |  | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 10 | C |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 10 | 10 | 10 | 7
First Name Middle Name Last Name5 | 1 |  | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9
First Name Middle Name Last Name6 | 2 |  | PL | PL | 10 |  |  | C | 10 | 10 | 10 | 10 |  |  | PL | PL | PL | PL | PL |  |  | C | 7 | 7 | 7 | 7 |  |  | PL | PL | 10 | 10
First Name Middle Name Last Name7 | 2 |  | 9 | 9 | 9 |  |  | C | 7 | 7 | 7 | 8 |  |  | 7 | 7 | 7 | 9 | 7 |  |  | 9 | 9 | 9 | 10 | 10 |  |  | 8 | 8 | 8 | 8
First Name Middle Name Last Name8 | 2 |  | C | PL | PL |  |  | 10 | 9 | 9 | 9 | 10 |  |  | PL | PL | 9 | 9 | PL |  |  | 7 | 7 | 7 | 7 | 8 |  |  | 9 | 9 | 9 | 9
First Name Middle Name Last Name9 | 2 |  | 7 | 7 | 7 |  |  | 7 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 7 | PL |  |  | 10 | 10 | 10 | PL | PL |  |  | 7 | 7 | 7 | PL
First Name Middle Name Last Name10 | 2 |  | 7 | 7 | 7 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 9 | 9 | 9 | C | 9 |  |  | 9 | 9 | 9 | 9 | C |  |  | 7 | 7 | 9 | 7
Spreadsheet: 223089d1364046612-help-with-tvm-spreadsheet-future-value
Sheet: Sheet1

rate of increase |  | 0.1
years to college |  | 6
Current college costs |  | 1000
rate of interest |  | 0.02
FV
Annual
Monthly
 |  |  |  | College Costs |  |  |  | Investment required
 |  |  |  | College  Costs | add increase
 |  |  | yr1
 |  |  | yr2
 |  |  | yr3
 |  |  | yr4
 |  |  | [NAME]
 |  |  | yr6
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -55850 | -55438
2 | -43999 | -43938
3 | -29392 | -29570
4 | -59280 | -59683
5 | -59827 | -59683
6 | -58120 | -57497
7 | -52462 | -52789
8 | -94542 | -93200
9 | -59632 | -58938
10 | -88592 | -88150
11 | -53451 | -52903
12 | -52850 | -52903
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  | 34979
 | 2001-08-12 00:00:00
CBS Dollars
 |  |  | -287550.35
Spreadsheet: 3da2f195-5f2e-4d5e-a86a-0e4250be5b23
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  | Expense Budget Overdraft/Zero Revenue Budget
 |  |  | Request Form
 |  |  | Date |  | FY
 |  |  | Business Unit |  | Ref #
 |  | FUND | DEPARTMENT ID | PROGRAM | CLASS | ACCOUNT
 | Explanation:
 | Note:  Expense budget lines must be set up with a $0 budget before they can be set to overdraft.
 | College Business Officer Signature |  |  |  | Date
 | Budget & Financial Planning Signature |  |  |  | Date entered
Spreadsheet: 766036d1643730075-count-of-breaches-look-up
Sheet: Sheet1

 |  | Reference | Amount of breaches | 1 | 2 | 3
 |  | 1.2 | 2 | Breach | Breach | OK
 |  | 1.3 |  | Breach | Breach | Breach
 |  | 1.4 |  | OK | OK | Breach
 |  | 1.5 |  | OK | Breach | Breach
Spreadsheet: kevin_hyatt__19636__EP2002 NGI
Sheet: Speakers

Speakers
Name |  | Company | Address |  |  | Phone | Fax | E-mail
[NAME] | Norwood | Calpine | 700 Louisiana Street, Suite 2700 | Houston | Texas | [PHONE] | [PHONE] | [EMAIL]
[NAME] | Wilkes | GE | Building 40, Room 517, 1 River Road | Schenectady | NY | [PHONE] |  | [EMAIL]
[NAME] | [NAME] | Enron | PO Box 1188, [NAME] 3AC3101 | Houston | Texas | [PHONE] |  | [EMAIL]
Wayne | Sartore | Enbridge | 3000 Fifth Avenue Place, 425 - 1st Street S.W. | Calgary | Alberta | [PHONE] |  | [EMAIL]
Spreadsheet: 174321d1345022165-vlookup-with-drop-down-functionality-____vlookup-with-a-drop-down-menu
Sheet: Actual

 |  | 2011 |  |  |  | 2012
Product |  | Jan | Feb | Mar | April | Jan | Feb | Mar | April
Product A | Units | 10 | 20 | 30 | 50 | 65 | 75 | 45 | 85
Product B | Units | 22 | 55 | 99 | 77 | 88 | 45 | 65 | 65
Product C | Units | 22 | 44 | 55 | 45 | 88 | 99 | 66 | 66
Product D | Units | 65 | 23 | 65 | 44 | 55 | 89 | 76 | 23
Product A | Values | 235 | 235 | 654 | 5689 | 789 | 546 | 888 | 457
Product B | Values | 1235 | 5647 | 1365 | 1235 | 456 | 564 | 1235 | 125
Product C | Values | 1254 | 4567 | 566 | 5467 | 568 | 569 | 5632 | 125
Product D | Values | 2223 | 4569 | 4567 | 887 | 1299 | 1256 | 1245 | 1254
Spreadsheet: 860014d1708249803-to-generate-random-list-of-number-but-not-to-get-itself-random-number-with-no-repetition
Sheet: Plan1

Random | order
Spreadsheet: 678365d1589840767-if-formula-looking-at-another-tab-to-determine-results-eh_-project-planne
Sheet: Project planner snapshot

ID | Tasks | Owner | Start Date | Duration | Priority |  | Status |  |  | ID |  |  |  |  | Task owners (Adhoc tasks excluded)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task meter (Adhoc tasks excluded)
 | Adhoc Tasks | Owner |  |  |  |  | Status |  |  | Adhoc queries
 |  |  |  |  |  |  |  |  |  | Upcoming absences |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Total Tasks
 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority tracker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
Spreadsheet: 60257d1260826184-gantt-chart-help-with-conditional-formatting-automation-gantt-chart-help
Sheet: Help

 | Task 1 |  | Task 2 |  | Task 3 |  | Task 4 |  | Task 5 |  | Task 6
 | Start | Complete | Start | Complete | Start | Complete | Start | Complete | Start | Complete | Start | Complete
Project 1 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-07-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-12-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-06-01 00:00:00
Project 2
Project 3
 |  |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
 | Start | Complete
Project 1 | 2009-01-01 00:00:00 | 2009-06-01 00:00:00
Project 2
Project 3
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: Worksheet

Answer the questions on this page to begin the Chapter JTE Workbook.  The values entered here will automatically populate in other tabs.
Chapter Information
Chapter Name
Lodge Name
Council Name
Chapter Chief
Chapter Adviser
Chapter Staff Adviser
Date of Chapter JTE Petition
Membership Figures
Ordeal Membership
Brotherhood Membership
Unit Information
Spreadsheet: 850715d1701105182-return-value-yes-or-no-if-a-time-is-greater-or-less-than-a-time-displayed-in-another-cell-times
Sheet: Sheet1

Late? | SLA | Delivered time
Y | 09:00:00 | 10:55:00
Y | 08:00:00 | 10:54:37
Y | 09:00:00 | 10:50:00
Y | 08:00:00 | 10:44:57
N | 17:30:00 | 10:44:23
N | 17:30:00 | 10:44:23
N | 17:30:00 | 10:44:23
Y | 08:00:00 | 10:43:47
Spreadsheet: 249972d1373702784-grouping-of-record-data-work-sheet
Sheet: DATA

Company | NAME
HIPP PR | DANI PING | DANI PING related to HIPP PR & ANSHIP PR
ANSHIP PR | DANI PING
BAGABRO  PR | RAWAL MAR
BAGABRO  PR | GRAW HESH
DIGY LOW PR | GRAW HESH
DIGY LOW PR | RAWA INIT
REGAHA PR | AMATH
ARC MALABS PR | RAKAUMAR IMA
ARC MALABS PR | DIN MARA
REGAHA PR | MAJA JA
ARC MALABS PR | MAJA JA
BAGABRO  PR | OMI BAGAD
ARC MALABS PR | [NAME]
REGAHA PR | AEON GANIC
BAGABRO  PR | GAYA BRO PLE
REGAHA PR | MANAN ARAYA
HIPP PR | SAIKUM | HIPP PR & ANSHIP PR related to these names
ANSHIP PR | SAIKUM
HIPP PR | UMENOD BHAI
ANSHIP PR | UMENOD BHAI
HIPP PR | SEVANTVORA
ANSHIP PR | SEVANTVORA
HIPP PR | RAVATIN
ANSHIP PR | RAVATIN
HIPP PR | SHAPAN
ANSHIP PR | SHAPAN
HIPP PR | LIYAKA
ANSHIP PR | LIYAKA
HIPP PR | SHADO SAD
ANSHIP PR | SHADO SAD
The above is a sample data , under column B there are names and this name is related to a company in column A. Name (columnB) may related to two or more companies and I want to group these companies (columnA) related to [NAME] (columnB) and give a group name. While grouping the other names (column B) related to the companies are also grouped. The group name should be the any name of company (columnA) in that group (preferably first name in the alphabetical order of group of companies)
In above data there are six company (columnA) , in grouping is three group
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | - | 641 | 641
Cross-Currency Fixed-Fixed | - | 66 | 66
Cross-Currency Fixed-Float | - | 254 | 254
TOTAL | - | 961 | 961
Spreadsheet: e9bc52da-e990-4f58-96cc-7cea0b80c557
Sheet: Fall 2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
MAEd Low Residency Learning Communities
Fall 2015
Subject | Course and Title | Campus Code & Location | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | 10 | 2 | 4 | 4 | 4 | 2
Index | 1653 | 1634 | 3862 | 2480 | 2367 | 2769
OTHER* | - | - | 34 | - | - | 40
TOTAL | 1663 | 1636 | 3900 | 2484 | 2371 | 2811
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 807677d1669995087-categorized-modes-of-payment-excel-help
Sheet: Cash

ACRYLON PAINTS (PTY) LTD
CASH SALES - (Cash)
Details
Date | Document Number | Customer Name | Cash Sale Amount | MoP
 | `
Spreadsheet: larry_campbell__20968__Flagstaff Calcs
Sheet: Turbine

[NAME]
RED ROCK EXPANSION PROJECT
FLAGSTAFF COMPRESSOR STATION
Table 1
TURBINE INFORMATION
Manufacturer: | GE LM2500
Fuel Type: | Sweet Natural Gas
HHV: | 1050 | Btu/scf
Site Elevation: | 7458
Inlet Loss: | 4 | in H2O
Exhaust Loss: | 4 | in H2O
Shaft Power: | 37270 | hp @ 12.8oF (Base Load)
 | 30565 | hp @ 60oF (Base Load)
[NAME]: | 9451 | Btu/hp-hr @95oF (50% Load)
 |  | [NAME]/hr | ([NAME] x shp@12.8oF)
[NAME]: | 6308 | Btu/hp-hr @60oF (Base Load)
 |  | [NAME]/hr | ([NAME] x shp@60oF)
Speed: | 6100 | rpm
[NAME]: |  | [NAME]/hr | ([NAME])
[NAME]: |  | [NAME]/hr | (Avg Heat Rate / HHV)
Annual Fuel: |  | [NAME]/yr | ([NAME])
Potential Emissions
Temp | Turbine | NOx (as NO2) |  | CO |  | THC
(oF) | Load (%) | (lb/hr) | (tpy) | (lb/hr) | (tpy) | (lb/hr) | (tpy)
0 | Base | 22.4 |  | 13.6 |  | 4.600000000000001
0 | 64 | 25.3 |  | 15.4 |  | 5.4
0 | 50 | 23 |  | 14 |  | 4.9
12.8 | Base | 22.7 |  | 13.8 |  | 4.7
12.8 | 50 | 22.6 |  | 13.7 |  | 4.8
40 | Base | 20.8 |  | 12.6 |  | 4.3
40 | 50 | 20.5 |  | 12.5 |  | 4.4
60 | Base | 19.4 |  | 11.8 |  | 4
60 | 50 | 13.2 |  | 8.1 |  | 2.7
95 | Base | 16.9 |  | 10.3 |  | 3.5
95 | 50 | 11.9 |  | 7.3 |  | 2.5
 | [NAME]
 | Base [NAME]
[NAME] (04/00)
PM | 0.0066 | lb/MMBtu
SO2 | 0.0034 | lb/MMBtu
Formaldehyde | 0.00071 | lb/MMBtu
Proposed Turbine Emissions
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX |  |  | operating at 64% load 100% of time
CO |  |  | operating at 64% load 100% of time
VOC |  |  | operating at 64% load 100% of time
PM
SO2
Formaldehyde
Proposed Turbine Emissions Plus 15% Safety Factor
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX
CO
VOC
PM
SO2
Formaldehyde
Spreadsheet: 0fd5dbee-8535-4b79-b16b-b78c55c871a7
Sheet: Program ID's

Program ID's | Description
100 | National Office
200 | Board Of Directors Meetings
315 | Region I Office
325 | Region II Office
335 | Region III Office
345 | Region IV Office
445 | National League
455 | National Presidents Cup
495 | TOPSoccer
501 | Regional League - Administrative
502 | Western Regional League - Region III
503 | Eastern Regional League - Region III
504 | Central Regional League - Region III
505 | National Presidents Cup - Regional Events
506 | Northeast Regional League - Region I
507 | Colonial Regional League - Region I
550 | Referee Program
630 | National Championship Finals - Referee
650 | National Championship Finals - Operations
690 | National Championship Finals - Regional Support
701 | ODP National Championships
705 | ODP Regional Championships
710 | Boys ODP Administrative
711-720 | Boys ODP Events - Please provide event/location
750 | Girls ODP Administrative
751-760 | Girls ODP Events - Please provide event/location
800 | NSCAA/USYS Workshop
* | More Program ID's available so if event/budget category is not shown, please provide description and we will get recorded appropriately.
Spreadsheet: 863657d1711060117-formula-to-check-if-a-cell-contains-exact-text-from-a-list-and-if-so-return-that-text-find-text-dj
Sheet: Sheet1

 | Area | Sector | # Staff | True Area |  | Area List Lookup
 | CA - United States, CA - San Diego, CA - NorCal | 5 | 45 |  |  | CA - San Diego
 | CA - San Diego, CA - State | 5 | 45 |  |  | CA - Los Angeles
 | CA - Los Angeles | 5 | 45 |  |  | CA - Fresno
 | CA - United States | 5 | 45 |  |  | CA - San Francisco
 | CA - Los Angeles, [NAME] | 5 | 45
 | CA - United States, CA - Fresno, CA - NorCal | 5 | 45
Spreadsheet: 1ae43cf2-1ccf-4355-8548-adc9aa5eb8d8
Sheet: Sheet1

Unnamed: 0 | LIETUVIŲ TAUTYBĖS GYVENTOJAI, SAVE PRISKYRĘ ŽEMAIČIAMS, PAGAL LYTĮ, AMŽIAUS GRUPES, RELIGINES BENDRUOMENES IR KALBŲ MOKĖJIMĄ | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
 | 2011 m. gyventojų ir būstų surašymo rezultatai
Apskritis | Gyvento-jų skaičius | Vyrai | Moterys | Amžiaus grupės |  |  |  |  |  |  |  | Religinė bendruomenė |  |  |  |  |  | Mokantys kitą kalbą | Rusų | Anglų | Vokiečių | Lenkų | Prancūzų | Kitas | Nemoka, nenurodė
 |  |  |  | 0–19 | 20–29 | 30–39 | 40–49 | 50–59 | 60–69 | 70–79 | 80+ | [NAME] katalikų | [NAME] | evange-likų liuteronų | kitų tikėjimų | nė vienai | [NAME]
Iš viso | 2169 | 1165 | 1004 | 379 | 244 | 265 | 369 | 357 | 289 | 186 | 80 | 1818 | 40 | 11 | 18 | 164 | 118 | 1848 | 1639 | 673 | 209 | 67 | 43 | 94 | 321
Alytaus | 31 | 16 | 15 | 6 | 8 | 1 | 5 | 6 | 1 | 2 | 2 | 29 | 0 | 0 | 0 | 0 | 2 | 24 | 20 | 11 | 2 | 5 | 3 | 0 | 7
Kauno | 220 | 104 | 116 | 44 | 41 | 26 | 34 | 33 | 15 | 16 | 11 | 164 |  | 0 | 7 | 21 | 25 | 198 | 161 | 105 | 32 | 17 | 1 | 9 | 22
Klaipėdos | 243 | 131 | 112 | 52 | 28 | 28 | 42 | 44 | 28 | 15 | 6 | 186 | 11 |  | 2 | 23 | 16 | 207 | 179 | 81 | 25 | 2 | 8 | 17 | 36
Marijampolės | 39 | 14 | 25 | 5 | 3 | 2 | 9 | 10 | 2 | 3 | 5 | 34 | 0 |  | 0 | 2 | 2 | 34 | 32 | 8 | 6 | 3 | 0 | 0 | 5
Panevėžio | 90 | 44 | 46 | 15 | 7 | 14 | 18 | 17 | 10 | 6 | 3 | 72 |  | 0 | 3 | 10 | 4 | 79 | 70 | 20 | 6 | 2 | 4 | 2 | 11
Šiaulių | 105 | 45 | 60 | 17 | 18 | 20 | 23 | 18 | 4 | 4 | 1 | 78 |  | 0 | 2 | 11 | 13 | 98 | 89 | 48 | 9 | 3 | 3 | 5 | 7
Tauragės | 24 | 15 | 9 | 6 | 3 | 5 | 2 | 3 | 4 | 1 | 0 | 15 |  | 0 | 0 | 4 | 3 | 23 | 18 | 12 | 2 | 0 | 1 | 2 | 1
Telšių | 1169 | 665 | 504 | 184 | 86 | 135 | 204 | 190 | 202 | 121 | 47 | 1050 | 20 |  | 2 | 68 | 25 | 959 | 873 | 256 | 98 | 5 | 11 | 49 | 210
Utenos | 40 | 19 | 21 | 7 | 14 | 1 | 7 | 3 | 2 | 4 | 2 | 33 |  | 0 | 0 | 4 | 3 | 37 | 27 | 19 | 5 | 3 | 1 | 0 | 3
Vilniaus | 208 | 112 | 96 | 43 | 36 | 33 | 25 | 33 | 21 | 14 | 3 | 157 |  |  | 2 | 21 | 25 | 189 | 170 | 113 | 24 | 27 | 11 | 10 | 19
 | • – konfidencialūs duomenys
Spreadsheet: 138217d1327574070-formula-with-sheet-name-variable-toys
Sheet: Item 002

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Price Check | 2012-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Sellers | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highest Price | 202.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Price | 15.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From | ross6868
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | Quebec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lowest Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Total Value
Item | Wrebbit 3D Jigsaw Puzzle - Imperial Star Destroyer
Year | 1996
Condition | Factory Sealed | Mint
Description | 823 Piece puzzle. Item # P3D-909. Height 10"xWidth 31.5"xDepth 17.5"
Spreadsheet: 160628d1339148293-to-get-minimum-value-from-a-database-with-criteria-else-return-na-min-example_5
Sheet: Sheet1

 |  | Criteria | Result
 |  | 6.1apple
 |  | 6.2orange
 |  | 6.3grape |  | ----This should become "0" instead of "NA" if there is "zero" value in the data.
 |  | 6.4kiwi
 |  | Fruit | Qty
 |  | 6.1apple | 1
 |  | 6.2orange | 2
 |  | 6.3grape | 4
 |  | 6.1apple | 4
 |  | 6.1apple | 5
 |  | 6.3grape | 6
 |  | 6.1apple | 7
 |  | 6.2orange | 2
 |  | 6.3grape | 9
 |  | 6.1apple | 1
 |  | 6.1apple | 1
 |  | 6.3grape | 7
 |  | 6.2orange | 4
 |  | 6.3grape | 6
 |  | 6.3grape | 0
 |  | 6.4kiwi | NA
 |  | 6.4kiwi | 4
 |  | 6.3apple | NA
Spreadsheet: 837998d1690580026-keep-a-group-family-rows-together-when-sorting-group-sort
Sheet: Sheet1

[NAME] | Account Number | Account Type | Fee Structure | HELPER COLUMN
[NAME] | KramerGroup | Group | Standard Fee | =IF(ISNUMBER(SEARCH("Family",A2)),INT(MAX(E$1:E1))+1,E1+0.1)
[NAME] | 6579 | IHIRA
[NAME] | 9194 | RH
Mark | 7368 | SEP
[NAME] | 1609 | CO
Jake | 2159 | IHIRA
[NAME] | 4187 | LT
Nick | 1817 | LT
[NAME] | DossGroup | Group | 0.01
[NAME] | 2786 | JT
Scott | 6214 | RH
[NAME] | 2009 | RO
[NAME] | 9230 | RH
Sara | 5866 | CO
[NAME] | CorthGroup | Group | Standard Fee
Kristy | 1259 | IN
[NAME] | 1681 | RO
[NAME] | StevensGroup | Group | Standard Fee
[NAME] | 8921 | LT
[NAME] | 1984 | RO
[NAME] | MartinGroup | Group | Standard Fee
[NAME] | 4449 | IN
Mark | 3834 | RH
[NAME] | 3767 | SEP
Cox Family | CoxGroup | Group | GrandFathered
[NAME] | 3785 | IN
[NAME] | 8426 | CO
Mixon Family | MixonGroup | Group | Standard Fee
[NAME] | 4516 | RO
[NAME] | 5400 | SEP
Samantha | 9247 | JT
Julie | 6012 | RO
Spreadsheet: 687291d1595082060-random-number-selection-with-blanks-forum-example-generator-additional-scenario
Sheet: Both from list

 | Factor to test |  | 1 |  |  | Current example of test generator
 | Ariana Passed
 |  | 1 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 2
 |  | 3
 |  | 5
 |  | 6 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 9
 |  | 10
 |  |  |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 12
 | Test generator using random generator of tables passed (C23:C34) and random generator between 0 and 12
 | Ariana Passed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowed Values
 |  | 1 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 3
 |  | 5
 |  | 6 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 9
 |  |  |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 12
Spreadsheet: 678853d1590085135-downloaded-xls-to-be-imported-into-a-existing-file-with-static-itemnumner-collect-item
Sheet: Sheet1

Name |  | Sida: | 1
Ordersammandrag |  | Utskrivet: | 2020-05-21 00:00:00
Artiklar |  |  |  |  |  |  |  |  |  | COMPANY: | 3000 |  |  |  |  | Comany: | 6000
Urval: | Kundnr | 3000, 6000 |  |  |  |  |  |  |  | Item nr | QTY |  |  |  |  | Itemnr | QTY
 |  |  |  |  |  |  |  |  |  | 12345 | LOOKUP QTY FOR ITEM IN ANOTHER XLS FILE |  |  |  |  | 12345
Artnr | Artikelbenämning | ClientNR |  | Del date | Qty | Value |  |  |  |  | AND ACCUMULATE IF MORE ORDERS
 | Ordernr | Kundnr | Kundnamn | Levdatum | Antal | Belopp kr |  |  |  |  | WITH SAME CLIENT NR
 |  |  |  |  |  |  |  |  |  | Itemnr | Qty | Value |  |  |  | Item nr | QTY | Value
12345 | Item Delta |  |  |  |  |  |  |  |  | 12345 | 6 | 30 |  |  |  | 12345 | 3 | 15
 | 99 | 6000 | Company BBB | 2020-06-01 00:00:00 | 3 | 15 |  |  |  | 34567 | 5 | 100 |  |  |  | 34567 | 0 | 0
 | 100 | 3000 | Company AAA | 2020-06-14 00:00:00 | 5 | 25 |  |  |  | then continue as many is on the the list of the imported
 | 100 | 3000 | Company AAA | 2020-06-17 00:00:00 | 1 | 5 |  |  |  | [NAME] file.
 |  |  |  | Sum | 9 | 45 |  |  |  | 76534 | 0 | 0 |  |  |  | 76534 | 20 | 200
34567 | Item Beta
 | 100 | 3000 | Company AAA | 2020-06-17 00:00:00 | 5 | 100
 |  |  |  | Sum | 5 | 1000
76534 | [NAME] |  |  |  |  |  |  |  |  | The item list is static with item numbers
 | 101 | 6000 | Company BBB | 2020-08-28 00:00:00 | 20 | 200
 |  |  |  | Sum | 20 | 200
THIS XLS FILE LOOKS LIKE THIS THAT I IMPORT FROM ADMIN PGM
I WANT FROM ANOTHER XLS FILE PICK VALUES from this one
SEE to the right