tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113606d1309449563-looking-up-maximum-valus-in-a-cell-range-book2
Sheet: Sheet1

Highest Date range |  |  |  |  | Dates | HUK | HBUK | IMG | Bentley | MAN | BMW | HBE | HNL
HUK | 5 | need dates to go here |  |  | 2010-10-01 00:00:00 | 1 | 4 | 1 | 7 | 4 | 10 | 4 | 4
HBUK | 7 |  |  |  | 2010-10-02 00:00:00 | 1 | 4 | 1 | 7 | 4 | 9 | 4 | 4
IMG | 2 |  |  |  | 2010-10-03 00:00:00 | 1 | 4 | 1 | 7 | 5 | 9 | 4 | 5
BGBL | 8 |  |  |  | 2010-10-04 00:00:00 | 1 | 2 | 1 | 7 | 3 | 9 | 2 | 3
MAN | 9 |  |  |  | 2010-10-05 00:00:00 | 1 | 2 | 1 | 7 | 3 | 8 | 2 | 3
BMW | 10 |  |  |  | 2010-10-06 00:00:00 | 2 | 3 | 1 | 7 | 2 | 7 | 3 | 2
HBE | 7 |  |  |  | 2010-10-07 00:00:00 | 1 | 1 | 1 | 5 | 1 | 7 | 1 | 1
HNL | 9 |  |  |  | 2010-10-08 00:00:00 | 4 | 1 | 1 | 5 | 2 | 7 | 1 | 2
 |  |  |  |  | 2010-10-09 00:00:00 | 5 | 2 | 1 | 4 | 3 | 5 | 2 | 3
 |  |  |  |  | 2010-10-10 00:00:00 | 4 | 3 | 1 | 4 | 4 | 4 | 3 | 4
 |  |  |  |  | 2010-10-11 00:00:00 | 4 | 7 | 1 | 4 | 8 | 1 | 7 | 8
 |  |  |  |  | 2010-10-12 00:00:00 | 4 | 3 | 1 | 8 | 8 | 3 | 3 | 8
 |  |  |  |  | 2010-10-13 00:00:00 | 3 | 4 | 1 | 3 | 8 | 2 | 4 | 8
 |  |  |  |  | 2010-10-14 00:00:00 | 3 | 5 | 1 | 3 | 7 | 8 | 5 | 7
 |  |  |  |  | 2010-10-15 00:00:00 | 3 | 5 | 1 | 3 | 9 | 9 | 5 | 9
 |  |  |  |  | 2010-10-16 00:00:00 | 2 | 6 | 1 | 2 | 8 | 9 | 6 | 8
 |  |  |  |  | 2010-10-17 00:00:00 | 1 | 6 | 1 | 2 | 6 | 7 | 6 | 6
 |  |  |  |  | 2010-10-18 00:00:00 | 1 | 6 | 2 | 1 | 6 | 6 | 6 | 6
 |  |  |  |  | 2010-10-19 00:00:00 | 1 | 6 | 1 | 1 | 6 | 6 | 6 | 6
 |  |  |  |  | 2010-10-20 00:00:00 | 1 | 6 | 1 | 1 | 6 | 6 | 6 | 6
Spreadsheet: fc15ebbc-6562-4031-b530-2a021383579d
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
BFTH | Test | BFTH | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BFTH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BFTH | Result | BFTH | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6030-1 | Budgerigar feather [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 889774d1740686183-need-excel-formula-to-show-location-wise-number-of-hires-in-specific-month-to-upload-sabahi2-
Sheet: Task 7

 | What is the average number of calendar days all employees worked in the company by locations and seniority (using one formula)?
 | Location | Manager | Team Lead | Senior | Regular | Junior
 | Bucharest
 | [NAME]
 | Kyiv
 | Lodz
 | London
 | New York
 | Wroclaw
Spreadsheet: 843058d1695032216-count-occurences-each-cell-within-array-count-occurences-arrays
Sheet: Feuil1

38 | 42 | 56 | 38 |  |  |  | 42 | 56 | 38
A | B | C | D |  |  | A | B | C | D
 |  |  |  |  |  | EXPECTED RESULT
 |  |  |  |  |  | 2 | 1 | 1 | 2
 |  |  |  |  |  | A | B | C | D
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 2-16 thru 2-22

 |  |  |  |  |  | System:
 |  |  | 2009-02-16 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-02-16 00:00:00 |  |  |  |  |  |  | Total
1 |  |  | 64
2 |  |  | 71.99 |  |  |  | 70.01
3 |  | 57 |  |  |  | 58
4 |  |  | 37.92 |  | 37.31 |  | 38.47
5 |  | 30.17 |  |  | 32.1 |  | 34.3
6 |  |  |  | 37.85
7 |  |  |  | 38.2
8 |  |  |  |  |  | 37
9 |  |  |  |  |  | 36.48
10 |  |  |  |  |  |  |  |  |  | no gas
11 |  | 35.2 |  | 31.18 |  |  | 40.24
12 |  |  | 36 |  |  | 31.01
13 |  |  | 37.33 |  |  | 39.46
14 |  | 35.9 |  |  | 36
15 |  |  |  | 35.1 |  | 35
16 |  |  | 36.38 |  | 35.02 |  |  | 28.37
17 |  |  | 40.34 |  |  | 37.45
18 |  |  |  |  | 34.32
19 |  | 37 |  |  |  | 34.5
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 4-4T

 | Section 4: Utilization
 | Table 4-4Trend:  Miles - Agency Owned Vehicles by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Passenger Vehicles | 1050970783.2 | 1154976793.6 | 1247584312.6 | 1338688079.5 | 1168410022.8
 | Trucks | 1903114986.7 | 1960772518.3 | 2089912259.3 | 2078871346.4 | 1934631102.1
 | Other | 32685869 | 37419700.9 | 33282271 | 36761600 | 30926691
 | Grand Total | 2986771639 | 3153169012.9 | 3370778843 | 3454321026 | 3133967816
Spreadsheet: 843238d1695141792-different-number-of-periods-and-days-calculated-from-a-fixed-period-with-varying-years-different-number-of-periods-and-days
Sheet: Results

Period/Year: | 3 | 2022-04-02 00:00:00 | 2023-04-01 00:00:00 |  |  |  |  | Results
Start date | End date | Number of days | Years | Days before  the year | Days in  the year | Days after the year | Control sum | Difference
2022-01-10 00:00:00 | 2025-01-10 00:00:00 | 1096 | 3 | 82 | 365 | 649 | 1096 | 0
2022-01-21 00:00:00 | 2025-01-21 00:00:00
2022-01-07 00:00:00 | 2025-01-07 00:00:00
2022-06-10 00:00:00 | 2027-06-10 00:00:00
2021-12-03 00:00:00 | 2024-12-03 00:00:00
2022-04-03 00:00:00 | 2025-04-03 00:00:00
2021-09-26 00:00:00 | 2024-09-26 00:00:00
2022-12-18 00:00:00 | 2025-12-18 00:00:00
2021-10-25 00:00:00 | 2024-10-25 00:00:00
2022-07-15 00:00:00 | 2025-07-15 00:00:00
2022-05-01 00:00:00 | 2023-04-30 00:00:00
2022-08-02 00:00:00 | 2025-08-02 00:00:00
2021-12-17 00:00:00 | 2024-12-17 00:00:00
2022-02-21 00:00:00 | 2025-02-21 00:00:00
2022-10-01 00:00:00 | 2023-10-01 00:00:00
2023-01-01 00:00:00 | 2023-12-31 00:00:00
2022-08-17 00:00:00 | 2023-08-17 00:00:00
2023-01-01 00:00:00 | 2023-12-31 00:00:00
2021-07-23 00:00:00 | 2024-07-23 00:00:00
2021-07-16 00:00:00 | 2024-07-16 00:00:00
2022-04-29 00:00:00 | 2025-04-29 00:00:00
2022-03-14 00:00:00 | 2025-03-14 00:00:00
2023-01-01 00:00:00 | 2023-06-30 00:00:00
2022-05-17 00:00:00 | 2027-05-17 00:00:00
2022-07-09 00:00:00 | 2023-07-09 00:00:00
2021-07-09 00:00:00 | 2023-07-09 00:00:00
2021-11-23 00:00:00 | 2024-11-23 00:00:00
2022-04-11 00:00:00 | 2025-04-11 00:00:00
Spreadsheet: 215037d1361233078-determine-ytd-average-employee-weekly-hours-ytd-ave-weekly-hours
Sheet: Pivot table

Row Labels | Sum of Hours Billing | Sum of Comp. X Worked Hours
Employee Zebra | 280.2 | 4.75
2 | 47.5 | 0
3 | 53.5 | 1.5
4 | 40.5 | 3
5 | 59.7 | 0.25
6 | 0
7
8 | 55
1 | 24 | 0
Grand Total | 280.2 | 4.75
Spreadsheet: 218948d1362615439-40-hours-per-week-how-to-calculate-overtime-hours-timesheettest
Sheet: 4 Mar 13

 | TIME AND MILEAGE SHEET - WEEK COMMENCING: |  |  |  |  | 2013-03-04 00:00:00
 | START TIME | FINISH TIME | TOTAL HRS |  | DUTIES | EFI CASE | [NAME] | OT
 | 07:15:00 | 09:15:00 |  | t | Travel |  | 124
 | 09:15:00 | 20:00:00 |  | l | labour at customer
 | 20:00:00 | 20:30:00 |  | t | Travel to hotel |  | 5
 |  |  |  | h | Overnight Stay
 | 07:00:00 | 07:30:00 |  | t | Travel to customer |  | 5
 | 07:30:00 | 13:00:00 |  | l | labour at customer
 | 13:00:00 | 15:15:00 |  | t | Onward travel |  | 122
 | 15:15:00 | 18:45:00 |  | l | labour at customer
 | 18:45:00 | 19:30:00 |  | t | Travel to hotel |  | 8
 |  |  |  | h | Overnight Stay
 | 07:00:00 | 07:30:00 |  | t | travel |  | 8
 | 07:30:00 | 09:30:00 |  | l | labour at customer
 | 09:30:00 | 12:15:00 |  | t | Onward travel |  | 132
 | 12:15:00 | 17:30:00 |  | l | labour at customer
 | 17:30:00 | 17:45:00 |  | t | Travel to hotel |  | 5
 |  |  |  | h | Overnight Stay
 | 08:30:00 | 09:00:00 |  | t | Travel to customer |  | 5
 | 09:00:00 | 17:15:00 |  | l | labour at customer
 | 17:15:00 | 18:25:00 |  | t | Travel to hotel |  | 2
 | 09:00:00 | 17:00:00 |  | ho | Home office
SAT
SUN
 |  | OPENING MILEAGE: |  |  |  | BUSINESS:
 |  | CLOSING MILEAGE: | 2475 |  |  | PRIVATE:
 |  |  |  |  | Accum Overtime
 |  | OVERNIGHT STAYS:
 | Travel Time |  |  |  | Vacation
 | Labour Time |  |  |  | Home Office
 | Hotel Stays |  |  |  | Sick / Dotors / Hospital
 | Comp Day |  |  |  | Weekly Overtime
 | Total Hours
Spreadsheet: 695986d1600518009-help-with-countifs-function-copy-of-rightmove-analysis-mt-2-
Sheet: Rental market snapshot

Key Stats |  |  |  |  |  | Date of data gathering: 7/9/2020
Price pcm per bedroom |  |  |  |  |  | Property Type | Number of properties | Average Rent Prices (pcm) | Asking Rental Range (pcm)
Whole Catchment Area | Sub Areas / Description |  |  | Why is this different? | HMOs sum function, add all rooms together, i.e. 5 bed hmo on markets means +5? | 1 room in House share (HMOs) | =COUNTIFS('Rental Count 7th Sep 2020'!$B$3:$B$75, 1)
M6 8 | Claremont and Hope | =averageifs('Rental Count 7th Sep 2020'!$I$3:$I$75,'Rental Count 7th Sep 2020'!$G$3:$G$75,"M30 0") |  |  |  | 1 bed/studio apartments | =COUNTIFS('Rental Count 7th Sep 2020'!$D$3:$D$75, "Apartment", 'Rental Count 7th Sep 2020'!$E$3:$E$75, "1")
[NAME] | [NAME] | =AVERAGEIFS('Rental Count 7th Sep 2020'!$I$3:$I$75, 'Rental Count 7th Sep 2020'!$G$3:$G$75, M30 0SH) |  |  |  | 2 bed apartments
M30 8 | Westwood Park, Winton, Council Estate in SW Monton, and NE section of Peel Green including social housing along Bridgewater Canal |  |  |  |  | 2 bed terrace
M30 9 | Monton, Ellesmere Park and Half Edge Lane |  |  |  |  | 2 bed semi
M30 0 | [NAME], Patricroft, Liverpool Road and East Barton (Land bounded by Man Ship Canal, A575 (E), M602 (N) and [NAME] (W). |  |  |  |  | 3 bed apartment
M50 1 | Ladywell & Eccles New Road |  |  |  |  | 3 bed terrace (including townhouses)
 |  |  |  |  |  | 3 bed semi
 |  |  |  |  |  | 3 bed detached
 |  |  |  |  |  | 4 bed terrace
 |  |  |  |  |  | 4 bed semi
 |  |  |  |  |  | 4 bed detached
 |  |  |  |  |  | 4 bed terrace
 |  |  |  |  |  | 4 bed semi
 |  |  |  |  |  | 4 bed detached
Spreadsheet: 549829d1511954248-query-refresh-error-on-some-pcs-and-not-others-tasks
Sheet: Inform Me

[NAME] | Category | Due Date | Owner | Task | Status | Progress Notes
Inform Me | Website | 2017-12-13 00:00:00 | Gillian | Sample Task 4 | Done
Inform Me | Blog | 2017-12-14 00:00:00 | Gillian | Sample Task 5 | Postponed
Inform Me | Blog |  | Stephen | Sample Task 24 | In Progress
Spreadsheet: 38522d1236688950-calculating-a-series-of-numbers-points-4-edan-
Sheet: Sheet1

Level | Points gained
5 | 11
Stats | Stat level | Points spent on this stat
1 | 10 | 21
2 | 24 | 68
3 | 17 | 42
4 | 3 | 6
5 | 25 | 72
6 | 1 | 2
Spreadsheet: 777682d1650551285-count-the-number-of-unique-records-that-match-a-criteria-new-count-unique-test
Sheet: Sheet1

Name | Total Episodes | Start | End | Total Work Days Missed
[NAME] | 1 | 2022-01-01 00:00:00 | 2022-01-05 00:00:00 | 2 |  | Number of staff with more than 5 episodes of sickness
[NAME] | 1 | 2022-02-08 00:00:00 | 2022-03-06 00:00:00 | 5
[NAME] | 1 | 2022-01-05 00:00:00 | 2022-01-10 00:00:00 | 3
[NAME] | 2 | 2022-03-06 00:00:00 | 2022-03-09 00:00:00 | 3
[NAME] | 3 | 2022-04-20 00:00:00 | 2022-04-22 00:00:00 | 1
[NAME] | 2 | 2022-03-10 00:00:00 | 2022-03-18 00:00:00 | 6
[NAME] | 2 | 2022-02-20 00:00:00 | 2022-02-25 00:00:00 | 2
[NAME] | 3 | 2022-03-25 00:00:00 | 2022-03-27 00:00:00 | 2
[NAME] | 4 | 2022-05-25 00:00:00 | 2022-05-29 00:00:00 | 4
[NAME] | 3 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 1
[NAME] | 4 | 2022-04-29 00:00:00 | 2022-05-05 00:00:00 | 5
[NAME] | 5 | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 1
[NAME] | 6 | 2022-07-14 00:00:00 | 2022-07-19 00:00:00 | 3
[NAME] | 5 | 2022-05-28 00:00:00 | 2022-06-03 00:00:00 | 3
Spreadsheet: 275211d1383394288-calling-data-from-another-sheet-with-an-if-function-or-macro-vlookup
Sheet: Original

Value | Name
1 | Apple
2 | Orange
3 | Kiwi
4 | [NAME]
5 | Coconut
6 | Pineapple
7 | [NAME]
8 | [NAME]
9 | Lemon
10 | Lime
Spreadsheet: 840305d1692634115-threshold-tracking-risk-management-threshold-tracking-2023-v3
Sheet: Count by month

Count of Incident Type | Column Labels
 | Jul | Aug | Sep | Grand Total
Row Labels
Chemical or Mechanical [NAME] |  | 1 | 1 | 2
Choking |  | 1 |  | 1
Falls |  | 4 |  | 4
Minor Injury |  | 5 |  | 5
Peer to Peer Aggressor - No/Minor Injury |  | 3 |  | 3
SIB - Minor Injury | 1 | 5 | 1 | 7
Grand Total | 1 | 19 | 2 | 22
Spreadsheet: 773438d1647866119-lookup-and-provide-max-latest-value-with-condition-test9v2
Sheet: Sheet2

ID |  |  |  |  |  |  | Status | Last Login Date&Time
133435833032 |  |  |  |  |  |  | Active | 2021-03-12 20:35:39
228056127019 |  |  |  |  |  |  | Active | 2022-03-12 13:47:30.094000
228056127019 |  |  |  |  |  |  | Active | 2018-05-24 10:46:51.653000
228056127019 |  |  |  |  |  |  | Active | 2022-03-15 08:35:11.593000
555877949108 |  |  |  |  |  |  | Inactive | 2016-11-09 12:25:10.458000
555877949108 |  |  |  |  |  |  | Active | 2022-02-17 14:16:32.860000
560088524108 |  |  |  |  |  |  | Inactive | 2021-10-12 11:39:55.081000
566925861100 |  |  |  |  |  |  | Inactive | 2020-05-05 09:09:34.033000
567464149107 |  |  |  |  |  |  | Inactive | 2015-08-18 11:41:14.748000
568845263108 |  |  |  |  |  |  | Active | 2015-04-17 09:18:45.151000
611766667046 |  |  |  |  |  |  | Inactive | 2015-10-06 10:29:06.897000
611766667046 |  |  |  |  |  |  | Inactive
611766667046 |  |  |  |  |  |  | Active
642188514565 |  |  |  |  |  |  | Active
Spreadsheet: 8f99ec21-9f1f-460e-8bd5-cd86cd690bb7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3552 | 15837 | [NAME] | [NAME] | AUT | 16 | 00:16:01 | 00:00:32 | [NAME] | 00:00:49 | 00:20:04 | 1 | 00:56:47
3552 | 15669 | [NAME] | Rassinger | AUT | 18 | 00:16:25 | [NAME] | [NAME] | 00:00:49 | [NAME] | 2 | 00:58:01
Spreadsheet: 87c68a21-15a8-4773-8bb5-b69a25d98a62
Sheet: Sheet1

Table S6 - Expressed genes and genes with transient differential expression in adult worms treated with human TNF-alpha for 1 h or 24 h | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Category | # of probes in the array | # of expressed probes | # of expressed genes | # of differentially expressed genes | # of genes with higher expression in TNF-alpha treated adult at 1 h | # of genes with higher expression in TNF-alpha treated adult at 24 h
S. mansoni genes w/orthologs in other species | 8949 | 8022 | 5455 | 397 | 250 | 147
S. mansoni genes with orthologs only in japonicum and in no other species | 5502 | 4525 | 3428 | 242 | 160 | 82
S. mansoni genes w/ NoMatch in GenBank | 27258 | 17197 | 16074 | 726 | 411 | 315
Total | 41709 | 29744 | 24957 | 1365 | 821 | 544
Spreadsheet: 0000b7d7-9a7f-4915-92fb-1d7caba51ee9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Long Short Equity Fund
 | [NAME]
 | Inception Date | 2013-07-16 00:00:00
 |  | Class I | Class N | Custom
 | Date | QLEIX | QLENX | Benchmark*
* | 2013-07-31 00:00:00 | 0.006000000000000005 | 0.006000000000000005 | 0.002619812254668008
 | 2013-08-31 00:00:00 | -0.02882703777335993 | -0.02882703777335993 | -0.0105805
 | 2013-09-30 00:00:00 | 0.045035824 | 0.045035824 | 0.02480883825004754
 | 2013-10-31 00:00:00 | 0.0430950049 | 0.042115573 | 0.01948424368625412
 | 2013-11-30 00:00:00 | 0.028169014084507 | 0.02819548872180433 | 0.00892506190075304
 | 2013-12-31 00:00:00 | 0.015235195 | 0.015031847 | 0.01067345232281847
 | 2014-01-31 00:00:00 | -0.03036238981390793 | -0.03036238981390804 | -0.01856250305775209
 | * partial month return, inception date [NAME]
 | Month-end Returns as of | Class I | Class N | (.5*MSCI [NAME])
 | January 31, 2014 | QLEIX | QLENX | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.07792919999460057 | 0.07672908158432734 | 0.03723123705894849
 | Since Inception Annualized Return
 | Since Inception Annualized Monthly Volatility | 0.1079168211018775 | 0.1073367777652951 | 0.05389894110571227
 | Quarter-end Returns as of | Class I | Class N | Custom
 | December 31, 2013 | QLEIX | QLENX | Benchmark*
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.11168253858029 | 0.1104448407046448 | 0.05684899985025105
 | Since Inception Annualized Return
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: maxzarazni

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
maxzarazni
offlinemaxzarazni
Remove friend Send message Donate
Experience level 29
21,881 / 25,000
Location: CroatiaCroatia, Central Croatia Citizenship: CroatiaCroatia
eRepublik birthday
Sep 03, 2009
National rank: 459
Party Member
Ekipa za bolju eHrvatskuEkipa za bolju eHrvatsku Center Wing
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Diseases News
Friends(206)
Aahz_ZBK
[NAME]
Rpgguzda
semsica
Ghetto_Souljah
PeeKaBooh
ivansplit
dSoKre
ZYX1
view all
Land of maxzarazni: 18 buildings
Visit
Achievements
hard worker
21
Hard Worker
Worked 30 days in a row
congressman
1
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
12
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
17
Super Soldier
Advance 250 strength points
society builder
1
Society Builder
Invited 10 people to eRepublik and helped them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
4,334.33
Super soldier:4,334 / 4,500
Rank
Field Marshal *Field Marshal *
Rank points:
1,754,340 / 1,875,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 736426d1623617441-returning-multiple-horizontal-values-matching-a-criteria-testbook5
Sheet: Sheet1

Product | COMPANY | TECHNICIAN | Sales | ITEM1 | ITEM2 | ITEM3 | ITEM4 | ITEM5 | ITEM6 | ITEM7 | ITEM8 | ITEM9
[NAME]-190 | SHOPPERS DRUGMART #120 | EVA SMART | A
[NAME]-190 | SHOPPERS DRUGMART #120 | EVA SMART | B
[NAME]-190 | SHOPPERS DRUGMART #120 | EVA SMART | C
[NAME]-190 | SHOPPERS DRUGMART #120 | NAT KNOWLES | D
[NAME]-190 | SHOPPERS DRUGMART #120 | NAT KNOWLES | E
[NAME]-190 | SHOPPERS DRUGMART #120 | NAT KNOWLES | F
[NAME]-190 | SHOPPERS DRUGMART #120 | NAT KNOWLES | G
[NAME]-190 | SHOPPERS DRUGMART #120 | NAT KNOWLES | H
[NAME] | PHARMAPRIX 247 | PEGGY WHITE | 1
[NAME] | PHARMAPRIX 247 | NOELLA FLEMING | 2
[NAME] | PHARMAPRIX 247 | NOELLA FLEMING | 3
[NAME] | PHARMAPRIX 247 | PEGGY WHITE | 4
[NAME] | PHARMAPRIX 247 | STEF BITER | 5
[NAME] | PHARMAPRIX 247 | STEF BITER | 6
[NAME] | PHARMAPRIX 247 | [NAME] | 7
[NAME] | PHARMAPRIX 247 | [NAME] | 8
[NAME] | PHARMAPRIX 247 | SOFIA DELON | 9
What I am trying to achieve using only Excel.
[NAME] | Company | Tech1Name | Tech1Prod1 | Tech1Prod2 | Tech1Prod3 | Tech1Prod4 | Tech1Prod4 | Tech2Name | Tech2Prod1 | Tech2Prod2 | Tech2Prod3 | Tech2Prod4 | Tech2Prod5 | Tech3Name | Tech3Prod1 | Tech3Prod2 | Tech3Prod3 | Tech3Prod4 | Tech4Name | Tech4Prod1 | Tech4Prod2 | Tech4Prod3 | Tech4Prod4 | Tech5Name | Tech4Prod1 | Tech4Prod2 | Tech4Prod3 | Tech4Prod4
[NAME]-190 | SHOPPERS DRUGMART #120 | EVA SMART | A | B | C |  |  | NAT KNOWLES | D | E | F | G
Spreadsheet: 1f896c97-cd98-4257-938d-95c72a6d5a0d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | Bradford paid for - 3B10024
 |  |  | Bradford Free Subs/Voucher - 3B10023
 |  |  |  | Bradford
 |  |  | Subscription Price List
 | T&A
 | Weeks | 1 | 4 | 8 | 13 | 26 | 52
 | Monday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Tuesday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Wednesday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Thursday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Friday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Saturday | 1.6 | £6.40 | £12.80 | £20.80 | £41.60 | £83.20
 | Full Week | 9.6 | 38.4 | £76.80 | 124.8 | 249.6 | 499.2
 | Weekly Titles
 | Weeks | 1 | 4 | 8 | 13 | 26 | 52
 | [NAME] | 1.85 | 7.4 | 14.8 | 24.05 | 48.1 | 96.2
 | Keighley News | 1.75 | 7 | 14 | 22.75 | 45.5 | 91
 | [NAME] | 1.85 | 7.4 | 14.8 | 24.05 | 48.1 | 96.2
 | Wharfedale Obs | 1.85 | 7.4 | 14.8 | 24.05 | 48.1 | 96.2
 | Free
 | Weeks | 1 | 4 | 8 | 13 | 26 | 52
 | [NAME] | 0.95 | 3.8 | 7.6 | 12.35 | 24.7 | 49.4
 | Months
 | Months | 1 | 2 | 4 | 6 | 8 | 12
 | Living | 1 | 2 | 4 | £6.00 | 8 | 12
Spreadsheet: 692635d1598471335-finding-duplicate-values-using-conditional-formatting-dup-etaf
Sheet: Sheet1

Name | Date
Doe, [NAME] | 2020-08-26 00:00:00
Doe, [NAME] | 2020-08-24 00:00:00
Doe, [NAME] | 2020-08-26 00:00:00
[NAME], [NAME] | 2020-08-26 00:00:00
[NAME], [NAME] | 2020-08-26 00:00:00
[NAME], [NAME] | 2020-08-25 00:00:00
Spreadsheet: 773284d1647767661-find-next-available-day-find-next-available-day_for_sharepoint
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Chosen | Results
01:00:00 | 05:00:00 | 03:00:00 | 04:00:00 | 08:00:00 |  |  | Sunday | Monday
02:00:00 | 02:00:00 | 08:00:00 | 09:00:00 | 05:00:00 |  |  | Monday | Monday
 |  | 09:00:00 | 06:00:00 |  |  |  | Saturday | Wednesday
07:00:00 | 08:00:00 |  |  | 07:00:00 |  |  | Tuesday | Tuesday
 |  |  |  | 02:00:00 |  |  | Wednesday | Friday
Spreadsheet: 766178d1643792996-averaging-values-based-on-multiple-conditions-copy-of-sample-10-
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  |  | Start row | 3 |  | 3
A | 1 | 78 |  |  |  |  |  |  | Start column | C |  | 3
A | 2 | 99 |  | 83 |  |  |  |  | End row | 5 |  | 5
A | 3 | 72 | 93 |  | 79 | 85 |  |  | End Column | E |  | 5
A | 4 | 83 | 89 |  |  | 75
B | 1 | 89 |  | 82 |  |  |  | INDIRECT formula
B | 2 |  |  |  | 93 | 96
B | 3 | 81 |  | 72 |  |  |  | OFFSET formula
B | 4 |  |  |  |  | 91
C | 1 | 77 |  |  |  |  |  |  | C-G need 1,2,3
C | 2 |  | 91 | 79 |  |  |  |  | B need 2,3
C | 3 |  |  |  | 89 |  |  |  | A need A
C | 4 | 92 |  | 84 | 78