tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Toppnik

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
[NAME]
offlineToppnik
Add as a friend Send message Donate
Experience level 28
19,631 / 20,000
Location: PolandPoland, Saxony Citizenship: CroatiaCroatia
eRepublik birthday
Sep 13, 2009
National rank: 604
No political activity
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(462)
Gunner_V
Zix14
Doktor-X
Getafix_14
123dudo
Alexandar Najvechi
Gunner1980
[NAME]
Nimesin
view all
Land of Toppnik: 13 buildings
Visit
About me
Wiki page
don't you fuckin touch me !!
Achievements
hard worker
23
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
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
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,252.60
Super soldier:4,252 / 4,500
Rank
Field Marshal *Field Marshal *
Rank points:
1,857,097 / 1,875,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: GenPower

4-002 Genesis - Power
Date | Ref. | Details | Debit |  | Date | Ref. | Details | Credit
2008-12-10 00:00:00 | 1-001 | National Bank - Cheque | 35
2008-12-17 00:00:00 | 1-001 | National Bank - Cheque | 35
2008-12-24 00:00:00 | 1-001 | National Bank - Cheque | 35
 |  | Total | 105 |  |  |  | Total | 0
 |  | Balance | 105 |  |  |  | Balance
Spreadsheet: 757831d1638467239-how-to-avoid-that-a-formula-changes-the-value-of-a-cell-once-the-cell-is-not-empty-book1
Sheet: Sheet1

Month | Rate
1 | 1.15
2 | 1.17
3 | 1.13
4 | 1.21
5 | 1.2
6 | 1.21
7 | 1.17
8 | 1.15
9 | 1.14
10 | 1.14
11 | 1.13
12 | 1.12
Spreadsheet: 119803d1314758246-how-to-sum-data-sourced-through-indirect-and-match-pt-daily-values
Sheet: Rec

Date | Position | AUD | BRL | CAD | CHF | CZK | DKK | EUR | GBP | HKD | HUF | ILS | [NAME] | KRW | NOK | NZD | SEK | SGD | THB | TRY | USD | ZAR
30Aug2011 | Initial | 2360085.93 | 35629.58 | 126589.53 | 0 | 6538 | 0 | 0 | 0 | 0 | 0 | 0 | 135629865 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6016.5 | 0
 | Trade | 542560.08 | <- this cell should sum all of the AUD currency values sourced from sheet 30Aug2011
 |  |  | Date | 2011-08-30 00:00:00 | <<You can filter by Date here
 |  |  | Sum of Net Cons
 |  |  | CCY | Total
 |  |  | AUD | 11190281.13
 |  |  | BRL | 992040.9200000002
 |  |  | DKK | 8618968.26
 |  |  | GBP | 6602209.619999999
 |  |  | HUF | 1356906.76
 |  |  | USD | 3704711.790000001
 |  |  | Grand Total | 32465118.48
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 0001

January 2000 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers | Data Source
HPLC | 12 |  | 50120 |  |  |  | Black Marlin | 96022051 | Unify Expense Report - Settlements
HPLC | 12 |  |  |  |  |  | Houston Pipeline Company | 96021987/ 96021988 | CPR (Basis Adj) Report | Accrual Expense
 |  |  |  |  |  |  |  |  | + estimated intrazone expense
HPLC |  |  | 1172 |  |  |  | [NAME] |  | CPR Report
HPLC |  |  | 6880 |  |  |  | Coastal States Gas Transmission |  | CPR Report
HPLC |  |  | 4612 |  |  |  | Florida Gas Transmission |  | CPR Report
HPLC | 12 |  | 0 |  |  |  | Humble Gas Pipeline |  | CPR (Basis Adj) Report
HPLC | 12 |  | 390 |  |  |  | MidCon Texas Pipeline Corp. | 96006770 | Unify Expense Report - Settlements
HPLC | 12 |  | 14876 |  |  |  | Southland Energy Corporation | 96008703 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 2115.18 |  |  |  | Northern Natural Gas/Black Marlin | 96020553 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 77781 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667 | CPR Report
ECT/Texas | 16 |  | 1117 |  |  |  | Pan Grande Pipeline, LLC | 96019628 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 112642 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96009903/ 96011842 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 0 |  | 98300 |  | Centana Storage Demand Charge | 96019236 | Unify Expense Report - Settlements
ECT/Texas | 16 |  |  |  |  |  | Houston Pipeline Company | 96007846/ 96007849 | CPR (Basis Adj) Report |  |  | 165443 | Flashed but needs to be part of manual entry
 |  |  |  |  |  |  |  |  | + estimated intrazone expense
Totals
DEMAND CHARGE NOTES:
 |  |  |  | $93,300 demand charge is in line 36 of OA Flash Page
ISSUES: | CPR estimate does not tie with Unify actuals as of 8/2/99
NOTE: | Because Unify does not tie with CPR, and because Unify does not seem to have flashed all pipelines, we used CPR tickets to flash
 | Boxed items show total expense that should show up on HPLC Transport Revenue - HPLR/ECT line
Spreadsheet: 72822d1273542857-convert-letter-to-number-then-calculate-average-number-letter-average-2
Sheet: Sheet1

Quality | EC | EC | U | EC | VC | VC | U | U | VC | SC | SC | EC | SC | DC | DC | DC | DC | VC | VC | VC | VC |  |  |  | #N/A | Quality
Grade | Percentage
DC | 62.5
EC | 95
SC | 90
U | 49.9
VC | 80
Spreadsheet: 00e522ac-bba7-4185-a28d-0d1ec2f4d34c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  | Coolhurst LT & SRC
 |  | Ladies Singles Summer 2011
First Round | Second Round | Quarter Finals | Semi Finals | Final
By end 3 June | By end [NAME] 9 June | By end Sat 12 June | By end [NAME] 16 June | On Sat 19 June
 | [NAME]
 | 1
 | Kat Keverne
 | [NAME]
 | [NAME]
 | 8
 | Rita Kilemade
 | 3
 | [NAME]
[NAME]
Francesca Lansdown
 | [NAME] |  |  |  | WINNER
 | 6
 | [NAME]
 | 5
 | [NAME]
 | [NAME]
 | [NAME]
 | 4
 | [NAME]
 | 7
 | [NAME]
 | [NAME]
 | [NAME]
 | 2
 |  |  |  | Queries?    Contact [NAME] 07786 507818
 | By end [NAME] 9 June | By end Sat 12 June | By end Mon 14 June | By end Thurs 17 June | On Sat 19 June
 | First Round | Second Round | Quarter Finals | Semi Finals | Final
Spreadsheet: 811799d1672799023-xlookup-problems-with-duplicates-samplesheet-1-
Sheet: Sheet1

Gallons | Amount
21.59 | 69.72
13 | 45
32.15 | 125.34
37.56 | 128.04
21.98100000000001 | 85.7
28.036 | 109.31
31.015 | 120
17.12 | 60.09
45.53 | 159.32
11.175 | 58.66
23.2 | 80.28
30.64 | 170
7.03 | 23
32.15 | 125.37
46.37 | 255.01
21.986 | 122
42.869 | 150
21.88 | 71.12
9.25 | 42.58
33.72 | 118.32
11.94 | 40
20.32 | 67.07000000000001
31.65 | 126.57
22.464 | 85.34
28.323 | 160
10.826 | 56.83
20.673 | 79.57000000000001
29.72 | 101.34
20.01 | 66.02
11.318 | 43
16.845 | 62.65
23.79 | 91.84
23.124 | 86
36.927 | 208.6
7.36 | 27.98
44.27 | 155.36
21.68 | 71.53
14.82 | 48
32.03 | 121.7
37.816 | 128.54
43.95 | 153.81
24.306 | 88.69
16.21 | 59
23.12 | 84.6
42 | 144.88
19.013 | 69
25.785 | 93.57
23.07 | 80.72
42.03 | 143.29
7.391 | 26.82
-1 | 0.22
26.091 | 138
26.32 | 150
18.95 | 108
25.21 | 85.7
13.74 | 51.27
37.16 | 178
14.01 | 43
44.39 | 146.46
Spreadsheet: 864165d1711458419-formula-name-errors-billy60-preventive-maintenance-schedule-2
Sheet: Full Maintenance Log

 |  | Preventive Maintenance Register
 |  | Vehicle ID | Service Performed | Last Service |  |  | Frequency of Service |  | Next Service Due |  | Comments
 | FOR CALCULATIONS – DO NOT EDIT |  |  | Odometer | Date | Cost | [NAME] | Months | Odometer | Date
 |  | VEH001 | Oil & Filter Change | 45000 | 2024-02-03 00:00:00 | 45
 |  | VEH001 | Tire Rotation / Balance | 52000 | 2024-03-02 00:00:00 | 45
 |  | VEH002 | Fuel Filter Change | 32000 | 2024-01-09 00:00:00 | 35
 |  | VEH003 | Battery Replacement | 75000 | 2024-01-07 00:00:00 | 125
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Vouchers

 |  |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Client Services/Benefits Delivery
Activity Name | Vouchers
Activity Description / Purpose | The process of timely and accurate provider payment
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Review documentation
Enter services and payment information into system
Authorize Payment
Issue Warrant
Voucher sent to Vendor
Reconcile Payment
Correct Errors
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T29

الجدول 29: تقديرات السكان حسب فئات العمر والمواطنون/غير مواطنين وحضر/ريف والجنس  في مصر، 2011
Table 29: Population etimates by age groups, nationals/non-nationals, urban/rural and sex in Egypt,  2011
 | Nationals | المواطنون | Non- Nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 4370269 | 4156405 | ... | ... | 1645898 | 1569426 | 2724371 | 2586979 | 4370269 | 4156405 | 8526674
5-9 | 4353223 | 4090843 | ... | ... | 1691089 | 1599495 | 2662134 | 2491348 | 4353223 | 4090843 | 8444066
10-14 | 4420078 | 4108255 | ... | ... | 1682584 | 1578194 | 2737494 | 2530061 | 4420078 | 4108255 | 8528333
15-19 | 4837291 | 4596221 | ... | ... | 1951128 | 1883232 | 2886163 | 2712989 | 4837291 | 4596221 | 9433512
20-24 | 4451881 | 4244515 | ... | ... | 1920777 | 1895848 | 2531104 | 2348667 | 4451881 | 4244515 | 8696396
25-29 | 3486398 | 3574726 | ... | ... | 1523932 | 1590506 | 1962466 | 1984220 | 3486398 | 3574726 | 7061124
30-34 | 2671664 | 2557526 | ... | ... | 1209471 | 1176803 | 1462193 | 1380723 | 2671664 | 2557526 | 5229190
35-39 | 2554033 | 2591043 | ... | ... | 1148718 | 1142341 | 1405315 | 1448702 | 2554033 | 2591043 | 5145076
40-44 | 2286131 | 2233528 | ... | ... | 1072465 | 1062772 | 1213666 | 1170756 | 2286131 | 2233528 | 4519659
45-49 | 2074515 | 1983907 | ... | ... | 979583 | 940766 | 1094932 | 1043141 | 2074515 | 1983907 | 4058422
50-54 | 1703894 | 1674605 | ... | ... | 866825 | 838568 | 837069 | 836037 | 1703894 | 1674605 | 3378499
55-59 | 1340259 | 1160024 | ... | ... | 652311 | 562740 | 687948 | 597284 | 1340259 | 1160024 | 2500283
60-64 | 991751 | 889417 | ... | ... | 535336 | 444297 | 456415 | 445120 | 991751 | 889417 | 1881168
65-69 | 707193 | 610103 | ... | ... | 338377 | 257334 | 368816 | 352769 | 707193 | 610103 | 1317296
70-74 | 444815 | 427877 | ... | ... | 215839 | 189939 | 228976 | 237938 | 444815 | 427877 | 872692
75+ | 417183 | 400444 | ... | ... | 184777 | 164337 | 232406 | 236107 | 417183 | 400444 | 817627
المجموع Total | 41110578 | 39299439 | ... | ... | 17619110 | 16896598 | 23491468 | 22402841 | 41110578 | 39299439 | 80410017
Spreadsheet: 166791d1341814099-conditional-formatting-highlight-second-or-more-row-hilightduplicaterows
Sheet: Tabelle1

Name | Type |  |  | Name | Type |  |  | Name
A412 | B |  |  | A412 | B |  |  | A412
F12 | 5 |  |  | F12 | 5 |  |  | F12
A412 | A |  |  | A412 | A |  |  | A412
A412 | B |  |  | A412 | B |  |  | A412
F12 | 12 |  |  | F12 | 12 |  |  | F12
F12 | 5 |  |  | F12 | 5 |  |  | F12
F12 | 5 |  |  | F12 | 5 |  |  | F12
Goal: Highlight second or more duplicate rows |  |  |  | All duplicate rows highlighted |  |  |  | Second or more duplicate cell highlighted
 |  |  |  | (SUMPRODUCT) |  |  |  | (COUNTIF)
Spreadsheet: 74332d1274874824-excel-2007-plotting-id-numbers-on-a-grid-talent-map
Sheet: Sheet1

ID no | name | potential | performance | Co-ordinate
1.1 | bob | 1 | 1 | 1.1
1.2 | [NAME] | 1 | 1 | 1.1
1.3 | stuart | 3 | 2 | 3.2
1.4 | billy | 2 | 2 | 2.2 |  |  |  | Talent Map
1.5 | gemima | 4 | 4 | 4.4
1.6 | [NAME] | 3 | 3 | 3.3 |  | Potential | 4
1.7 | cecil | 4 | 2 | 4.2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  | Performance
Spreadsheet: 34025d1231139757-find-numbers-sample-sheet
Sheet: Sheet2

1000139168 | NULL | [PHONE] |  |  | "=IF(COUNTIF(C:C,A:A)>0,A:A,"NULL")
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL | [PHONE]
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
[PHONE] | NULL
Spreadsheet: andy_zipper__165__DYNEGY-ICE VOL Apr9
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-9-01 thru Apr-9-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 147619d1332882459-is-there-a-formula-for-this-when-working-with-2-tabs-example-of-problem
Sheet: Sheet1

 |  | Enrolments
 | Name | Football | Netball | Hockey | Yoga
 | [NAME] | 2011-11-23 00:00:00 | 2011-11-30 00:00:00 | 2011-12-22 00:00:00
 | [NAME] |  | 2011-11-30 00:00:00 | 2011-12-22 00:00:00 | 2012-01-05 00:00:00
 | Harriet | 2011-12-13 00:00:00 |  |  | 2012-01-24 00:00:00
 | Abbigail | 2011-11-23 00:00:00 | 2011-11-30 00:00:00 | 2011-12-22 00:00:00 | 2012-01-05 00:00:00
 | [NAME] |  | 2011-12-01 00:00:00 | 2011-12-23 00:00:00
 | Leanne | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 |  | 2011-01-07 00:00:00
 | [NAME] | 2011-12-20 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2012-01-11 00:00:00
 | Bev | 2011-12-20 00:00:00 |  | 2011-12-28 00:00:00 | 2012-01-11 00:00:00
 |  | 6
Spreadsheet: 161053d1339389500-if-if-only-i-knew-the-answer-if
Sheet: Sheet1

Sundry Codes Application Guide (Oils only)
Model | [NAME] | Code | Description | Oil Desc. | R Code
AH
 | ASTRA | AF26 | Auto Trans-Fluid (GM P/N 93165147 or equivalent) | [NAME] | #N/A | R1 | Dexos 1
 | ASTRA | AF8 | Auto Trans-Fluid (Holden Spec No. HN2414/JWS3309) | Castrol Transmax E |  | R10 | Castrol LSX 85W140
 | ASTRA | GO10 | [NAME] (Holden Spec No. HN2354) | [NAME] 75W80 |  | R11 | Castrol EPX 80W90
 | ASTRA | GO25 | [NAME] (GM P/N 93165290) | [NAME] 75W80 |  | R12 | [NAME]
 | ASTRA | MO27 | Engine Oil (ACEA A3/B3) | Castrol Magnatec Professional 10W-30 |  | R13 | Castrol Transmax E
 | ASTRA | MO32 | Engine Oil (ACEA A3/B4) | Castrol Magnatec Professional 10W-30 |  | R14 | Castrol Magnatec Professional 10W-30
 | ASTRA | MO4 | Engine Oil (ACEA A2 or A3) | Castrol Magnatec Professional 15W-40 |  | R15 | Castrol Magnatec Professional 15W-40
 | ASTRA | PS2 | Power Steering Fluid ([NAME]) | [NAME] |  | R2 | Dexos 2
 | ASTRA | RC4 | Radiator Coolant (Holden Spec GM6277M) |  |  | R3 | Castrol Edge A3 5W30
AH07 |  |  |  |  |  | R4 | Castrol Magnatec Professional C3 5W40
 | ASTRA | AF26 | Auto Trans-Fluid (GM P/N 93165147 or equivalent) | [NAME] |  | R5 | [NAME]
 | ASTRA | AF8 | Auto Trans-Fluid (Holden Spec No. HN2414/JWS3309) | Transman E |  | R6 | [NAME]
 | ASTRA | GO10 | [NAME] (Holden Spec No. HN2354) | [NAME] 75W80 |  | R7 | Castrol VMX 80 Gear Oil
 | ASTRA | GO25 | [NAME] (GM P/N 93165290) | [NAME] 75W80 |  | R8 | [NAME] 75W80
 | ASTRA | MO27 | Engine Oil (ACEA A3/B3) | Castrol Magnatec Professional 10W-30 |  | R9 | [NAME] Oil
 |  |  | I want to create a function to go in column F that will look at the test in the adjacent cell in Column E then return the appropriate "R Code" from the table in Columns G&H
Spreadsheet: 849370d1699887348-end-date-based-on-known-start-date-and-hours-worked-manufacturing-capacity-planning-excel-forum
Sheet: Data Sheet

 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Year | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034
 | Month Start
 | Month End
 | Holiday |  | Date
 |  |  | 2023 | 2024 | 2025 | 2026
 | New Years Day |  | 2023-01-02 00:00:00
 | Good Friday
 | Easter Monday
 | Early May Bank Holiday
 | Kings’s Corornation
 | Spring Bank Holiday
 | Summer Bank Holiday
 | Christmas Day
 | Boxing Day
 | Closed
 | Closed
 | Closed
 | Daily Start Time (Mon-Fri) |  | 1900-01-07 07:30:00
 | Daily End Time (Mon-Thurs) |  | 1900-01-04 16:30:00
 | Daily End Time (Fri) |  | 1900-01-12 12:30:00
 | Daily Lunch Break (Mon - Thurs) |  | Start Time | 1900-01-12 12:30:00
 |  |  | End Time | 1900-01-01 01:00:00
Spreadsheet: 35330d1232934712-excel-2007-formula-to-average-a-percentage-qc-sheet-master
Sheet: Sunday

 |  |  |  |  |  |  |  |  | System:
 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Jobs taken to QC | Total QC Completed | Pass | Fail
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Totals
Spreadsheet: 715177d1611593328-return-a-certain-response-to-an-if-function-between-a-number-range-com-test-chart
Sheet: Sheet1

Month | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 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 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Target | 7800 | 7800 | 7800 | 13000 | 13000 | 13000 | 13000 | 13000 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666
Achieved | 780 | 6212.959999999999 | -5512 | 5546.32 | 9550.32 | 25224.68 | 37428.04 | 27347.32 | 3692
Commission
Spreadsheet: 806204d1669159686-audit-date-punch-type-lookup-time-test-ag
Sheet: Daily

 | 2022-01-03 00:00:00 | 2022-01-03 00:00:00
Employee | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT
1514 |  | 12:40:00 | 08:47:00 | 17:20:00 | 06:26:00 | 15:14:00 | 06:24:00 | 15:31:00 | 06:24:00 | 15:26:00 |  |  |  |  | 06:24:00 | 16:26:00 | 06:24:00 | 16:19:00 | 06:25:00 | 15:01:00
1798 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:55:00 | 00:00:00 | 06:54:00 | 15:32:00 | 06:57:00 | 15:37:00
1868 | 07:03:00 | 16:22:00 | 06:50:00 | 17:36:00 | 06:50:00 | 15:20:00 |  |  |  |  |  |  |  |  | 06:52:00 | 15:37:00 | 06:53:00 | 15:38:00 | 06:50:00 | 15:34:00
1871 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:01:00 | 09:46:00 | 06:58:00 | 15:53:00 | 07:04:00 | 15:41:00
1891 |  |  | 07:01:00 | 19:40:00 | 06:57:00 | 17:30:00 | 06:58:00 | 15:30:00 |  |  |  |  |  |  | 07:03:00 | 17:36:00 | 06:59:00 | 17:34:00 | 06:59:00 | 17:35:00
1990
1991
2034
2065
2076
2078
2054