tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219729d1362922026-counting-occurrences-233-count_occurances
Sheet: Dec2004

Month | Day | paper | Cost | cumul | total Rs | weekly amt
Dec | wed | IE | 300 | 300 | 3
2 |  | IE | 300 | 600 | 6
3 |  | IE | 300 | 900 | 9
4 |  | IE | 300 | 1200 | 12
5 | [NAME] | IES | 200 | 1400 | 14 | 14
6 |  | IE | 300 | 1700 | 17
7 |  | IE | 300 | 2000 | 20
8 |  | IE | 300 | 2300 | 23
9 |  | IE | 300 | 2600 | 26
10 |  | IE | 300 | 2900 | 29
11 |  | IE | 300 | 3200 | 32
12 | [NAME] | IES | 200 | 3400 | 34 | 17
13 |  | IE | 300 | 3700 | 37
14 |  | IE | 300 | 4000 | 40
15 |  | IE | 300 | 4300 | 43
16 |  | IE | 300 | 4600 | 46
17 |  | TI | 150 | 4750 | 47.5
18 |  | TI | 150 | 4900 | 49
19 | [NAME] | HTS | 450 | 5350 | 53.5 | 16.5
20 |  | TI | 150 | 5500 | 55
21 |  | HT | 150 | 5650 | 56.5
22 |  | TI | 150 | 5800 | 58
23 |  | TI | 150 | 5950 | 59.5
24 |  | TI | 150 | 6100 | 61
25 |  | HT | 150 | 6250 | 62.5
26 | [NAME] | HTS | 450 | 6700 | 67 | 12
27 |  | TI | 150 | 6850 | 68.5
28 |  | TI | 150 | 7000 | 70
29 |  | HT | 150 | 7150 | 71.5
30 |  | Hindu | 250 | 7400 | 74
31 | fri | Hindu | 250 | 7650 | 76.5
Spreadsheet: 883722d1732375022-vlookup-for-salaries-yearly-salary-increment-based-on-anniversay-date-forecasting-salary-forecasting-jt-1-
Sheet: josephteh

Period 1(P1) = April'24 Period 2(P2) = May'24 Period 12 (P12) = March'25
 | P9 - December 1st |  |  |  |  |  |  | Anniversary Increment |  |  | Contractual Increment |  |  |  | Monthly salary:
Employee Name | Annual salary at the beginning of Fiscal Year (FY) | Salary per mth | Level | Step | Step Anniversary (DD/MM) | Salaries paid until Dec 1st | Forecast for remainder of FY (Dec, Jan, Feb, March) | Next Step Annual Salary | Salary per mth | Pro-rate Salary on Anniversary Month | 22/12/24 [NAME] Annual Salary | Salary per mth | Pro-rate [NAME] in Dec Month |  | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total
Employee A |  |  | IT-03 | 8 | N/A
Employee B |  |  | IT-03 | 5 | 2024-10-16 00:00:00
Employee C |  |  | IT-01 | 6 | 2025-01-29 00:00:00
Employee D |  |  | IT-02 | 3 | 2024-05-27 00:00:00
Employee E |  |  | IT-04 | 4 | 2024-11-15 00:00:00
Anniversary Increment
Level | Effective date | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 |  | Added 6 helper columns and re-arranged the anniversary and contractual increment table.
IT-01 | 1/4/2024 | 60000 | 61000 | 62000 | 63000 | 64000 | 65000 | 66000 | 67000
IT-02 | 1/4/2024 | 80000 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000
IT-03 | 1/4/2024 | 100000 | 102000 | 104000 | 106000 | 108000 | 110000 | 112000 | 114000
IT-04 | 1/4/2024 | 120000 | 122000 | 124000 | 126000 | 128000 | 130000 | 132000 | 134000
Collective Bargaining Agreement Increment
Level | Effective date | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8
IT-01 | 22/12/24 | 61500 | 62500 | 63500 | 64500 | 65500 | 66500 | 67500 | 68500
IT-02 | 22/12/24 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000 | 88000
IT-03 | 22/12/24 | 101500 | 103500 | 105500 | 107500 | 109500 | 111500 | 113500 | 115500
IT-04 | 22/12/24 | 121500 | 123500 | 125500 | 127500 | 129500 | 131500 | 133500 | 135500
https://www.excelforum.com/excel-general/1430786-vlookup-for-salaries-yearly-salary-increment-based-on-anniversay-date-forecasting.html
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Frajercina

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
Frajercina
offlineFrajercina
Add as a friend Send message Donate
Experience level 29
24,103 / 25,000
Location: UkraineUkraine, Subcarpathia Citizenship: CroatiaCroatia
eRepublik birthday
Nov 14, 2009
National rank: 352
No political activity
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
[NAME])
Goonie GooGoo
loody-chincho
Dino_zippo
dado007
MileLican
[NAME]
MaliZeleniTHR
ivansplit
[NAME]
view all
Land of Frajercina: 21 buildings
Visit
About me
Wiki page
'' NO MATTER THE NUMBER, YOU STAND YOUR GROUND AND FIGHT ''
Achievements
hard worker
16
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
1
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
18
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
4,681.42
Super soldier:4,681 / 4,750
Rank
Supreme Marshal *Supreme Marshal *
Rank points:
3,041,722 / 3,500,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 829120d1683928971-sum-every-other-column-only-where-adjacent-column-is-non-empty-cell-sum-every-other-column
Sheet: Sum Every Other Column

 |  |  |  |  |  |  |  |  |  | Desired Result
TGT | ACT | TGT | ACT | TGT | ACT | TGT | ACT | TGT | ACT | Total
1000 | 50 | 1000 | 100 | 1000 |  | 1000 |  | 1000 |  | 2000 | [NAME] Here [Sum only TGT columns only where ACT is not empty
Include | Available | Include | Available | Exclude |  | Exclude |  | Exclude
 |  |  |  |  |  |  |  |  |  | Desired Result
TGT | ACT | TGT | ACT | TGT | ACT | TGT | ACT | TGT | ACT | Total
1000 | 50 | 1000 | 100 | 1500 | 200 | 1500 | 500 | 1000 |  | 5000 | [NAME] Here [Sum only TGT columns only where ACT is not empty
Include | Available | Include | Available | Include | Available | Include | Available | Exclude
Spreadsheet: 67045d1267687814-help-with-the-most-basic-of-formulas-book1
Sheet: Sheet3

SUM: | 171.5 | 9.75 | 2 | 6.95 | 190.2
SUBTOTAL: | 171.5 | 9.75 | 2 | 6.95 | 190.2
Factor: | 1.75 | 1.95 | 2 | 6.95 | 1
Name | Food packs | Food bars | Extra1 | Extra2 | Total
[NAME] | 28 | 3 |  |  | 54.85
[NAME] | 14 | 2 |  | 1 | 35.35
Kelly | 56 |  | 1 |  | 100
Spreadsheet: kevin_ruscitti__20325__template
Sheet: Sheet1

DAILY PHYS PRICE POSITIONS:
[NAME] | INDEX | BASIS | NYMEX | Notes
Michcon:
Consumers:
Great Lakes:
Belle River
St. Clair
TOTAL GREAT LAKES:
ANR:
ML3
ML6
ML7
TOTAL ANR:
TOTAL DAILY PRICE POSITIONS:
TOTAL MONTHLY PRICE POSITIONS:
TOTAL MONTHLY CONTRACTS:
*  Excludes peoples deals.
Spreadsheet: 107481d1304626834-average-between-dates-nickiname
Sheet: Sheet1

Date | Price |  | StartDate | EndDate | Average Price
2011-01-01 00:00:00 | 21 |  | 2011-01-10 00:00:00 | 2011-01-25 00:00:00 | 61.25
2011-01-02 00:00:00 | 43
2011-01-03 00:00:00 | 78
2011-01-04 00:00:00 | 43
2011-01-05 00:00:00 | 34
2011-01-06 00:00:00 | 32
2011-01-07 00:00:00 | 5
2011-01-08 00:00:00 | 23
2011-01-09 00:00:00 | 32
2011-01-10 00:00:00 | 5
2011-01-11 00:00:00 | 2
2011-01-12 00:00:00 | 87
2011-01-13 00:00:00 | 321
2011-01-14 00:00:00 | 76
2011-01-15 00:00:00 | 43
2011-01-16 00:00:00 | 2
2011-01-17 00:00:00 | 7
2011-01-18 00:00:00 | 32
2011-01-19 00:00:00 | 54
2011-01-20 00:00:00 | 65
2011-01-21 00:00:00 | 76
2011-01-22 00:00:00 | 68
2011-01-23 00:00:00 | 34
2011-01-24 00:00:00 | 43
2011-01-25 00:00:00 | 65
2011-01-26 00:00:00 | 98
2011-01-27 00:00:00 | 65
2011-01-28 00:00:00 | 3
2011-01-29 00:00:00 | 3
2011-01-30 00:00:00 | 4
2011-01-31 00:00:00 | 6
Spreadsheet: 477402d1472274938-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: Yearly contracts old

 |  |  |  | Yearly contracts feasibility |  | Proposed Saving
Category | Material | Sum of Value of spend-FY16  (Rs Crore) | Total spend-FY 17E (Rs Crore) | Feasibility (Yes/No) | Rationale
RM | Octyl Methoxy Cinnamate (Galax | 0.7757143000000001 |  | No | Rs 90/-per kg saving taken based on 8MT PO, It is a Seasonal item for suncare and consolidated already | NA
RM | SunCat DE | 0.6291759999999998 |  | Yes | Volume based saving feasible in case of yearly contract | 2 lacs
RM | Lipocare | 0.597375 |  | Yes | we have six month price contract with existing vendor. | It is consume in Shape Gel and volume is mre or leass same so saving would be appx 0.8 lacs
RM | [NAME] | 0.5424165 |  | yes | Suncat D and [NAME] are the substitute for each other and R&D is working on Suncat De to use in place of [NAME] 350/-per kg savingis expected to in flow, if [NAME] is approved by R&D. | 6 lacs | No for yearly contract since substitute is being developed
RM | Nestdry ST2000 | 0.538965 |  | Yes | Earlier we were using MT100z, We replace MT100z with Nestdry ST 2000 to achieve cost saving. | 2.5 lacs
RM | Gold Leaf | 0.522548 |  | No | Price fluctuations are very high. | NA
RM | Light Liquid Paraffin | 0.5080851965 |  | yes | Upward trend in price so yearly/half-yearly contract not feasible. Position can be taken for 3 months | 0.5 lacs (3 month positioning)
RM | Acrypol ET-1 | 0.492886 |  | No | It is a substitute of Aqua SF1 and its price reduced from Rs 408 per kgs to Rs 192 per kg and further we reduced Rs 10/-per kg in June'16 | NA | No further cost-saving possible so attempt at yearly contract not profitable
RM | Bio-White/Sabiwhite | 0.4737700000000001 |  | No | Price [NAME] in Apr'16 Rs 2200/-per kg on consolidation. | no
PM | Sun Screen Gel Pinch Of Tube10 | 1.265422796 |  | Yes | Yearly quantity high enough to negotiate better on yearly contract |  | 10 lcas
PM | White Jar 50g | 0.5813420079999998 |  | yes | Price reduce Rs 3.35/-per Jar in Nov'15, Approx 38 lac saving done. | no
Spreadsheet: john_forney__15526__s_9-14-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-14 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Enron Call |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirant Call |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Total
[NAME]: |  | Deal Details
23
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 12 |  | 22
773108.1 |  | [NAME] | -50 | 23 | 12 |  | 22
758660.9 |  | Enron Call | -100 |  | 7 |  | 22
772644.1 |  | Enron bk/out | 100 | 22.25 | 7 |  | 22
773096.1 |  | CP1 | 50 | 23 | 12 |  | 22
Spreadsheet: 598515d1542563346-for-a-given-range-of-cells-b5-t5-count-the-number-of-cells-containing-x-sample-worksheet
Sheet: Sheet1

Sales Target
Salesman
[NAME] | x | x |  |  |  | x | x |  |  | x |  | x | x |  | x | x |  | x |  |  |  |  | The answer shoul be 10, not 48
[NAME] |  | x | x | x | x | x |  |  |  | x | x | x | x | x | x | x | x | x |  |  |  |  | The answer shoul be 14, not 38
Carlo | x |  | x | x | x |  | x |  | x |  | x | x |  | x |  | x |  |  |  |  |  |  | The answer shoul be 10, not 24
[NAME] | x | x | x | x | x | x | x | x | x |  | x |  | x | x |  |  | x | x |  |  |  |  | This is correct
Spreadsheet: 90405d1290120885-excel-2007-vlookup-in-multiple-sheets-vlookupproblem-1
Sheet: C

PRODUCTS | QTY | PIECES | PRICE | SELECTED QTY | FINAL PIECES
C1 | 2 | 30.25
C2 | 3 | 26.25
[NAME] | 4 | 17
C4 | 5 | 11
C5 | 6 | 1
C6 | 7 | 7
C7 | 8 | 10
C8 | 9 | 12
C9 | 10 | 35.25
C10 | 11 | 16
Spreadsheet: 772677d1647432573-concatenate-return-matching-data-concatenate-return-matching-data
Sheet: Sheet1

MASTER DATA |  |  |  |  | RECORDING DATA
From | To | Issued To |  |  | TR# | From | To | User | Correct User/s
22000001 | 22000050 | [NAME] |  |  | 1 | 22000055 | 22000060 |  | [NAME]
22000051 | 22000075 | [NAME] |  |  | 2 | 22000077 | 22000080 |  | [NAME]
22000076 | 22000131 | [NAME] |  |  | 3 | 22000005 | 22000045 |  | [NAME]
22000132 | 22000143 | [NAME] |  |  | 4 | 22000131 | 22000135 |  | [NAME]; [NAME] |  | 22000131 issued to [NAME] while 22000132 - 22000135 issued to [NAME]
 |  |  |  |  | 5 | 22000075 | 22000076 |  | [NAME]; [NAME] |  | 22000075 issued to [NAME] while 22000076 issued to [NAME]
 |  |  |  |  | 6 | 22000140 | 22000142 |  | [NAME]
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 10
 |  |  |  |  | 11
 |  |  |  |  | 12
 |  |  |  |  | 13
 |  |  |  |  | 14
 |  |  |  |  | 15
Spreadsheet: 79281d1279561629-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-rev2
Sheet: Activity Code

Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 101 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 202 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 301 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Q1303 | 301 | 2345 | [NAME] | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 4 | 10 | TUFC | B
[NAME] | 301 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 301 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 301 | 1235 | [NAME] | 2010-07-18 00:00:00 | 2010-07-18 00:00:00 | 4 | 10 | Robins | B
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 302 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 3 | 5 | TUFC | A
Q1303 | 302 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 302 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 302 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 3 | 10 | Robins | B
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1306 | 303 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 303 | 1235 | [NAME] | 2010-07-18 00:00:00 | 2010-07-18 00:00:00 | 5 | 200 | Robins | B
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 304 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 306 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Spreadsheet: 329343d1404281352-problem-finding-a-complex-formula-book1
Sheet: Pendientes y Curvas Vertica (2

Cotas y [NAME] |  |  | Calculo de Pendientes
Puntos | [NAME] (Cr,Y) | Progresiva En el Plano (Pg,X) | Tramos | P =(Yb-Ya)/(Xb-Xa) | P% = P*100
 | 114 | 0
 | 108.06 | 540
 | 97.3 | 900
 | 91.86 | 1240
 | 61.62 | 2500
 | 61.86 | 2840
C
Progresiva en  el Plano (Pg) | Progresiva  Absoluta (Pr) |  | [NAME]
0 | 0
20
40
60
80
100
120
140
160
180
200
220
240
260
280
300
320
340
360
380
400
420
440 |  |  |  |  |  | 620
460 |  |  |  |  |  | 640
480 |  |  |  |  |  | 660
500
520
540
560
580
Spreadsheet: 677346d1589311500-need-not-sure-if-function-or-vbs-is-best-way-to-proceed-example
Sheet: Data Sheet

NAME | TYPE | CAUSE NUMBER | FILING DATE | AAL | Adversary | 262 | 263-1 | 263-2/Final
[NAME] | ER | 45254 |  | JM |  | 2020-04-21 00:00:00 | 2020-08-18 00:00:00 | 2020-12-15 00:00:00
Widdel | ER | 68541 |  | ST |  | 2020-04-21 00:00:00 | 2020-08-18 00:00:00 | 2020-12-15 00:00:00
WHITES | ER | 65987 |  | CL |  | 2020-04-24 00:00:00 | 2020-08-28 00:00:00 | 2020-12-08 00:00:00
WHITES | ER | 453215 |  | CL |  | 2020-04-28 00:00:00 |  | 2020-08-25 00:00:00
Chosen | ER | 54156 |  | KK |  | 2020-05-05 00:00:00 | 2020-09-01 00:00:00 | 2020-12-15 00:00:00
heaven | ER | 45695 |  | ST |  | 2020-05-05 00:00:00 | 2020-09-01 00:00:00 | 2020-12-15 00:00:00
booker | ER | 421578 |  | ST |  | 2020-05-05 00:00:00 | 2020-09-01 00:00:00 | 2020-12-15 00:00:00
CRAWdad | ER | 87564 |  | AM |  | 2020-05-12 00:00:00 | 2020-09-22 00:00:00 | 2021-01-12 00:00:00
towns | ER | 786545 |  | CL |  | 2020-05-12 00:00:00 | 2020-09-22 00:00:00 | 2021-01-12 00:00:00
Tipps | ER | 468515 |  | EB |  | 2020-05-12 00:00:00 | 2020-09-08 00:00:00 | 2020-12-08 00:00:00
Smith | ER | 65412 |  | JM |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Marks | ER | 65413 |  | KK |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Jones | ER | 65321 |  | ST |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Spreadsheet: 55d091e5-ce02-4da1-935e-cd19a7db3c8c
Sheet: Sheet1

Shark KCNQ Exons | Unnamed: 1 | 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
exons: |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 10 | 11 | 12 | 13
Cm KCNQ2 | traces |  | AAVX01085041.1 |  | AAVX01174509.1 | AAVX01174509.1 |  |  | AAVX01086666.1 | AAVX01418534.1 | AAVX01219901.1 | AAVX01219901.1 |  | AAVX01096296.1
[NAME] | traces |  | AAVX01202677.1 |  | AAVX01561545.1 |  | AAVX01215360.1 | AAVX01215360.1 | AAVX01229763.1 | AAVX01040812.1 |  |  | AAVX01292612.1 | AAVX01073066.1 | AAVX01203494.1
Cm KCNQ4 | traces |  | AAVX01121274.1 |  |  | AAVX01194025.1 | AAVX01260182.1 |  | AAVX01607736.1 |  |  |  | AAVX01022942.1 | AAVX01388299.1
[NAME] | traces |  |  | AAVX01280566.1 |  |  |  |  | AAVX01229763.1 | AAVX01569805.1
[NAME] | traces | AAVX01546818.1 | AAVX01459694.1 | AAVX01316951.1 | AAVX01127120.1 | AAVX01449486.1 | [NAME] | AAVX01570633.1 | AAVX01608801.1 |  |  |  | AAVX01468564.1 | AAVX01037281.1
Unassigned Exons | traces |  | AAVX01417463.1 |  |  |  | AAVX01570633.1 |  | AAVX01032042.1 |  |  | AAVX01037281.1 | AAVX01037281.1
 |  |  |  |  |  |  | AAVX01133191.1 |  |  |  |  | AAVX01048026.1
Spreadsheet: 888785d1739366604-two-lookups-to-return-result-book2
Sheet: Sheet1

Price group name | Jumper | T shirt |  |  | Jumper | Tshirt | Price group name
[NAME] | 40 | 10
XS | 40 | 20
S | 50 | 10
M | 50 | 20
L | 60 | 10
XL | 60 | 20
XXL | 70 | 10
XXXL | 70 | 20
Spreadsheet: 37062d1235012416-sort-question-baskets
Sheet: Sheet3

Basket 1 | 3 | Basket 1 | 4 | Basket 2 | 5 |  | Items | Oranges | Apples | Lemons
Basket 3 | 7 | Basket 3 | 2 | Basket 9 | 4 |  | Basket 1 | 3 | 4 | 0
Basket 4 | 2 | Basket 5 | 2 | Basket 11 | 1 |  | Basket 2 | 0 | 0 | 5
 |  |  |  |  |  |  | Basket 3 | 7 | 2 | 0
 |  |  |  |  |  |  | Basket 4 | 2 | 0 | 0
 |  |  |  |  |  |  | Basket 5 | 0 | 2 | 0
 |  |  |  |  |  |  | Basket 6 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 7 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 8 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 9 | 0 | 0 | 4
 |  |  |  |  |  |  | Basket 10 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 11 | 0 | 0 | 1
 |  |  |  |  |  |  | Basket 12 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 13 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 14 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 15 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 16 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 17 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 18 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 19 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 20 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 21 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 22 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 23 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 24 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 25 | 0 | 0 | 0
 |  |  |  |  |  |  | Basket 26 | 0 | 0 | 0
Spreadsheet: 769186d1645374340-find-item-in-one-cell-and-return-value-from-another-401k-weekly-upload-to-pentegra-v4-help-file-2
Sheet: Summary

Justice League, LLC
Payroll Summary
January 7, 2022
 |  |  |  | Batman |  |  | Superman |  |  | [NAME]
 |  |  |  | Hours | Rate | Jan 7, 22 | Hours | Rate | Jan 7, 22 | Hours | Rate | Jan 7, 22
Employee Wages, Taxes and Adjustments
 |  | Gross Pay
 |  |  | Salary |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Hourly Wage | 25.85 | 10 | 258.5 | 21.02 | 13 | 273.26 | 32.93 | 10.5 | 345.77
 |  |  | Overtime (x1.5) |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | PTO |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Reception Hours |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | RM Hourly Wage |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Training wage (hourly) |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Employee Bonus |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Product Bonus |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Allowances |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Cash Tips |  |  | 3 |  |  | 20 |  |  | 3
 |  |  | Charge Tips |  |  | 80 |  |  | 166.5 |  |  | 242.68
 |  | Total Gross Pay
 |  | Deductions from Gross Pay
 |  |  | 401K Employee Contribution |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Cash Tips (offset) |  |  | -3 |  |  | -20 |  |  | -3
 |  |  | [NAME] (offset) |  |  | -80 |  |  | -166.5 |  |  | -242.68
 |  |  | Health Benefits |  |  | 0 |  |  | 0 |  |  | 0
 |  | Total Deductions from Gross Pay
 | Adjusted Gross Pay
 | Taxes Withheld
 |  | Federal Withholding |  |  |  | -1 |  |  | -41 |  |  | -57
 |  | Medicare Employee |  |  |  | -4.95 |  |  | -6.67 |  |  | -8.58
 |  | Social Security Employee |  |  |  | -21.17 |  |  | -28.51 |  |  | -36.67
 |  | Medicare Employee Addl Tax |  |  |  | 0 |  |  | 0 |  |  | 0
 | Total Taxes Withheld
 | Deductions from Net Pay
 |  | Child Support Withholdings |  |  |  | 0 |  |  | 0 |  |  | 0
 | Total Deductions from Net Pay
Net Pay
Employer Taxes and Contributions
 | Federal Unemployment |  |  |  |  | 2.05 |  |  | 2.76 |  |  | 3.55
 | Medicare Company |  |  |  |  | 4.95 |  |  | 6.67 |  |  | 8.58
 | Social Security Company |  |  |  |  | 21.17 |  |  | 28.51 |  |  | 36.67
 | TX - Unemployment Tax |  |  |  |  | 1.06 |  |  | 1.43 |  |  | 1.83
 | 401K Company Match |  |  |  |  | 0 |  |  | 0 |  |  | 0
Total Employer Taxes and Contributions
Spreadsheet: 59167d1259634159-umm-need-help-test
Sheet: Sheet1

 | DATA |  |  |  |  |  |  | Need the Weekly Average Score of per supervisor. (If Possible, avoid macros) | [NAME] wise(Avg)
 | Sno | Supervisor | Employee | Week 1 | Week 2 | Week 3 | Week 4 |  | Supervisor | Week 1 | Week 2 | Week 3 | Week 4
 | 1 | AB | A | 15 | 20 | 25 | 30 |  | AB | 14 | 16.33 | 20.5 | 19.6
 | 2 | AB | B | NA | 17 | 16 | 18 |  | AC | 10.5 | 23 | 12 | 11
 | 3 | AB | C | 13 | 12 | NA | 11 |  | AD | 11.5 | 21 | 15 | 16.5
 | 4 | AC | D | 11 | 21 | NA | 11
 | 5 | AC | E | 10 | 25 | 12 | NA
 | 6 | AD | F | 8 | NA | 15 | 22
 | 7 | AD | G | 15 | 21 | NA | 11