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

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
josko79
offlinejosko79
Remove friend Send message Donate
Experience level 28
19,095 / 20,000
Location: PolandPoland, Saxony Citizenship: CroatiaCroatia
eRepublik birthday
Nov 03, 2010
National rank: 634
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(150)
zmataga123
Domago
[NAME]
[NAME]
yanbbo
[NAME]
zomfgzor
HateFul
nookie_hookie
view all
Land of josko79: 24 buildings
Visit
About me
Wiki page
1. GB TIGROVI
Achievements
hard worker
9
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
1
Resistance Hero
Started a resistance war and liberated 1 regions.
super soldier
13
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
3,405.04
Super soldier:3,405 / 3,500
Rank
Field Marshal Field Marshal
Rank points:
1,512,221 / 1,600,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 274149d1383034143-how-to-configure-vlookup-to-filter-first-one-or-two-key-words-flag-scenario-rambo-
Sheet: File2

 | File [2]
 | business name | New column | flag rank
 | [NAME] |  | 1
 | eion incorporation |  | 2
 | mega company |  | 3
 | cat technologies |  | 4
 | carlton patent |  | 5
 | drew u.s.a |  | 6
 | defiant mall |  | 7
 | knolls corp, |  | 8
 | red orange violet |  | 9
 | crawford patent |  | 10
 | regulis corp |  | 11
 | drew ph. |  | 12
 | amadeus corporation |  | 13
 | orange velocity |  | 14
 | iso patent incorporation |  | 15
 | arceus corp. |  | 16
 | bucket shoal inc. |  | 17
 | red orange violet |  | 18
 | sand filter corp. |  | 19
 | bayo incorporation |  | 20
 | ryo limited |  | 21
Spreadsheet: 787554d1657863774-rag-status-reference-from-sub-project-to-project-rag-f-aligw
Sheet: Sheet1

Project Name | RAG status |  |  | Project Name | Sub Project | RAG staus
Mitel |  |  |  | Mitel | M1 | Green
Comverse |  |  |  | Mitel | M2 | Red
Sony |  |  |  | Comverse | C1 | Amber
Idea |  |  |  | Sony | S1 | Green
Airtel |  |  |  | Sony | S2 | Amber
Vodafone |  |  |  | Sony | S3 | Green
 |  |  |  | Idea | Id1 | Red
 |  |  |  | Idea | Id2 | Amber
 |  |  |  | Airtel | A1 | Green
 |  |  |  | Airtel | A2 | Red
 |  |  |  | Vodafone | V1 | Green
 |  |  |  | Vodafone | V2 | Amber
 |  |  |  | Vodafone | V3 | Amber
Spreadsheet: 889309d1740069262-quickly-convert-column-of-currency-amounts-to-other-currency-via-historical-data-bnbusd_1m_2020-copy
Sheet: Table1

Close | Close time
13.6862 | 2020-04-10 23:22:59.999000
13.6932 | 2020-04-10 23:23:59.999000
13.6761 | 2020-04-10 23:24:59.999000
13.69 | 2020-04-10 23:25:59.999000
13.7131 | 2020-04-10 23:26:59.999000
13.7345 | 2020-04-10 23:27:59.999000
13.7092 | 2020-04-10 23:28:59.999000
13.69 | 2020-04-10 23:29:59.999000
13.6854 | 2020-04-10 23:30:59.999000
13.6896 | 2020-04-10 23:31:59.999000
13.6789 | 2020-04-10 23:32:59.999000
13.6785 | 2020-04-10 23:33:59.999000
13.6672 | 2020-04-10 23:34:59.999000
13.6708 | 2020-04-10 23:35:59.999000
13.6692 | 2020-04-10 23:36:59.999000
13.7343 | 2020-04-10 23:37:59.999000
13.7563 | 2020-04-10 23:38:59.999000
13.7129 | 2020-04-10 23:39:59.999000
13.6943 | 2020-04-10 23:40:59.999000
13.6953 | 2020-04-10 23:41:59.999000
Spreadsheet: 840902d1693145503-trying-to-conditionally-format-columns-based-on-dynamic-cell-values-whole-school-compass-export-template-aligw
Sheet: Scale

Scale |  | Level | Lookup |  | [NAME]
A | Below | B | 1 |  |  | 12 months or more below the expected achievement level
B | Below | C | 2 |  |  | 6 months below the expected achievement level |  |  |  | Y |  | S | G | G | G
C | Below | D | 3 |  |  | At the expected achievement level |  |  |  | 3 |  | 1 | 4 | 3 | 4
D | Below | 0.5 | 4 |  |  | 6 months above the expected achievement level |  |  |  | 1 |  | 1 | 1 | 2.5 | 1
0.5 | Half way through | Foundation | 4.5 |  |  | 12 months or more above the expected achievement level |  |  |  | 1 |  | 1 | 0.5 | 7 | 0.5
F | At the end of | Foundation | 5 |  |  |  |  |  |  | 1 |  | 1 | 1.5 | 1 | 1.5
F.5 | Half way through | 1 | 5.5 |  |  |  |  |  |  | 4 |  | 1 | 2 | 0.5 | 2
1 | At the end of | 1 | 6 |  |  |  |  |  |  | 3 |  | 1 | 2 | 4 | 2.5
1.5 | Half way through | 2 | 6.5 |  |  |  |  |  |  | F |  | 1 | F | 3 | 7
2 | At the end of | 2 | 7 |  |  |  |  |  |  |  |  |  |  | 4.5 | 1
2.5 | Half way through | 3 | 7.5 |  |  |  |  |  |  | 2 |  | 2 | 3 | 6.5 | 0.5
3 | At the end of | 3 | 8 |  |  |  |  |  |  |  |  |  |  |  | 4
3.5 | Half way through | 4 | 8.5
4 | At the end of | 4 | 9
4.5 | Half way through | 5 | 9.5
5 | At the end of | 5 | 10
5.5 | Half way through | 6 | 10.5
6 | At the end of | 6 | 11
6.5 | Half way through | 7 | 11.5
7 | At the end of | 7 | 12
7.5 | Half way through | 8 | 12.5
8 | At the end of | 8 | 13
8.5 | Half way through | 9 | 13.5
9 | At the end of | 9 | 14
9.5 | Half way through | 10 | 14.5
10 | At the end of | 10 | 15
Spreadsheet: d183cf70-699d-4374-ac45-b745b03fea98
Sheet: Sheet1

Special Occasion Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]: [EMAIL]
Tel: (415) 519-1866
www.simplymochi.com
How to Order You can place your order by phone or e-mail.  We will confirm your order by phone or e-mail.  [NAME] fill out the form below. Minimum order is 1 dozen mochi.  You can choose up to 2 flavors for free per WHOLE order, not per dozen.  Any additional flavors will include a $3.00 fee per flavor.  We prefer 24-48 hours notice.  However, we can accommodate same day orders when available.   If less than 24 hours notice, please confirm your order by calling us.
Pick Up Location 593 Guerrero @18th St, San Francisco, Ca 94110
Delivery Delivery rates vary according to location.  • Within San Francisco                    $10.00 • Peninsula                                       $10.00 • South Bay/East Bay/North Bay      $20.00
Customer Billing Information
Name: |  |  | Date:
Date of Delivery: |  |  | Time of Delivery:
Contact Information: |  |  | [NAME]:
Delivery Address:
City:
Zip Code:
Commercial or Residence
Special Instructions
Occasion
Refered By?
Description |  | Mochi Dessert Table | [NAME] or dinner dessert in a box | Qty |  | Line Total
Regular Flavors (50 min/up to 2 flavors) |  | 1.5 | $2.50/$3.00 for seasonal
PB & J |  | 0 | 0 | 0 |  | 0
PB Chocolate |  | 0 | 0 | 0 |  | 0
Red Bean |  | 0 | 0 | 0 |  | 0
Nutella |  | 0 | 0 | 0 |  | 0
[NAME] |  | 0 | 0 | 0 |  | 0
[NAME] |  | 0 | 0 | 0 |  | 0
S'mores |  | 0 | 0 | 0 |  | 0
Choconuts |  | 0 | 0 | 0 |  | 0
Oreo Cheesecake |  | 0 | 0 | 0 |  | 0
[NAME] |  | 0 | 0 | 0 |  | 0
Taro |  | 0 | 0 | 0 |  | 0
Chocolate |  | 0 | 0 | 0 |  | 0
Salted Caramel |  | 0 | 0 | 0 |  | 0
Seasonal Flavors
Chocolate Covered Strawberry |  | 2 | 0 | 0 |  | 0
Red Bean Strawberry |  | 2 | 0 | 0 |  | 0
Chocolate Mint |  | 2 | 0 | 0 |  | 0
Coconut/Haupia |  | 2 | 0 | 0 |  | 0
Pumpkin Cheesecake |  | 2 | 0 | 0 |  | 0
Mango Curd |  | 2 | 0 | 0 |  | 0
Tier Stand & Decorations
3 tier stand    (15-36 mochi) |  | Varies ** | 0 | 0 |  | 0
4 tier stand   (20-45 mochi) |  | Varies ** | 0 | 0 |  | 0
5 tier stand   (35-75 mochi) |  | Varies ** | 0 | 0 |  | 0
6 tier stand   (50-90 mochi) |  | Varies ** | 0 | 0 |  | 0
7 tier stand   (70-110 mochi) |  | Varies ** | 0 | 0 |  | 0
 |  |  |  |  | 0 | SUBTOTAL | 0
 |  |  |  |  |  | Delivery | 0
 |  |  |  |  |  | $3.00 per additional flavor fee | 0
 |  |  |  |  |  | TOTAL | 0
Forms of Payment
COD, cash on delivery
Checks made payable to [NAME]
* The first two flavors are free.  Any additional flavors are an extra $3.00 a flavor
** Please call for a personalized quote on these tiers
*** Special Introductory Rate
Spreadsheet: 733265d1621466747-help-with-formula-based-on-number-of-occurences-of-values-in-another-column-sample
Sheet: Sheet1

 | 1
 | 0.5
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1000
 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | 0
 | 2000
Time | S | N | Result | T | T+L | S2 | W/L | P | CP | SP | Reset
04/05/2019 11:25:00 | A | 5.6 | Won
04/05/2019 11:50:00 | B | 3.56 | Won
04/05/2019 11:53:00 | C | 3.8 | Lost
04/05/2019 12:18:00 | D | 3.45 | Lost
04/05/2019 12:41:00 | E | 4.93 | Lost
04/05/2019 12:50:00 | C | 4.1 | Won
04/05/2019 13:00:00 | F | 4.2 | Lost
04/05/2019 13:06:00 | S | 3.45 | Lost
04/05/2019 [NAME] | T | 3.45 | Lost
04/05/2019 13:16:00 | A | 2.66 | Lost
04/05/2019 13:50:00 | U | 3.1 | Lost
04/05/2019 14:01:00 | Y | 4.6 | Lost
04/05/2019 14:05:00 | Z | 5.32 | Lost
04/05/2019 14:10:00 | X | 3.6 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 14:12:00 | C | 3 | Won
04/05/2019 14:18:00 | B | 4.59 | Won
04/05/2019 14:25:00 | A | 4.2 | Lost | 8 |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 7 so add one equals 8)
04/05/2019 14:30:00 | R | 3.05 | Lost
04/05/2019 14:36:00 | K | 3.85 | Lost
04/05/2019 14:38:00 | O | 3.55 | Lost
04/05/2019 14:45:00 | P | 4.58 | Lost
04/05/2019 17:15:00 | C | 3.86 | Lost
04/05/2019 17:30:00 | F | 3.5 | Lost
04/05/2019 18:15:00 | S | 5.59 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 19:15:00 | T | 3.7 | Lost
04/05/2019 20:15:00 | A | 5.3 | Lost
11/05/2019 11:50:00 | U | 4.2 | Won
11/05/2019 12:18:00 | Y | 3.15 | Lost
11/05/2019 12:30:00 | Z | 5.16 | Lost
11/05/2019 13:16:00 | X | 4 | Won
11/05/2019 13:40:00 | C | 5.5 | Lost | 16 |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 15 so add one equals 16)
11/05/2019 13:53:00 | B | 3.06 | Won
11/05/2019 14:12:00 | A | 3.08 | Lost
18/05/2019 12:05:00 | A | 5.2 | Lost
18/05/2019 12:15:00 | U | 5.59 | Lost
18/05/2019 12:25:00 | Y | 5.08 | Lost
[NAME] 12:40:00 | Z | 4.06 | Lost
18/05/2019 12:47:00 | X | 3.56 | Lost
[NAME] 12:50:00 | C | 4.1 | Lost
18/05/2019 13:06:00 | A | 4.5 | Won |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
18/05/2019 13:10:00 | U | 4.6 | Lost
[NAME] 13:15:00 | Y | 3.85 | Won
18/05/2019 13:18:00 | Z | 3.6 | Lost | 25 |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 24 so add one equals 25)
18/05/2019 13:40:00 | X | 5.1 | Lost
[NAME] 13:46:00 | C | 3.05 | Lost
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: EOTT Gain(loss)

 | Southeast Region |  |  |  |  |  | Southwest Region |  |  |  |  |  |  |  |  |  |  |  | North Region
Yr 2002 | [NAME] | Miss/Ala | Pearsall | SW | SE/OLP | [NAME] | TNM | TNM | North | WTX | Red River | Buffalo | Cherokee | Osage | Odessa | KS | Hobbs | SW/OLP | N Dakota |  | Total
Receipts |  |  |  | LA |  |  | Texas | NMx | Texas |  |  |  |  |  |  |  |  |  |  |  | EOTT
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Total
Gain(Loss)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Total
At $20/Bbl
% G/(L)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Total
Add Dollars if you wish
 | Southeast Operations Area |  |  |  |  | Southwest Operations Area |  |  |  |  | North Operations Area |  |  |  |  | Total Balance Check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference
 | Production | Physical | Total | Monthly |  | Production | Physical | Total | Monthly |  | Production | Physical | Total | Monthly |  | Production | Physical | Total | Monthly |  | total sums to
 | Month | Receipts | Volume | % |  | Month | Receipts | Volume | % |  | Month | Receipts | Volume | % |  | Month | Receipts | Volume | % |  | Area sums
 |  | BBLS. | Gain/Loss | Gain/Loss |  |  | BBLS. | Gain/Loss | Gain/Loss |  |  | BBLS. | Gain/Loss | Gain/Loss |  |  | BBLS. | Gain/Loss | Gain/Loss
 | Jan |  |  |  |  | Jan |  |  |  |  | Jan |  |  |  |  | Jan
 | Feb |  |  |  |  | Feb |  |  |  |  | Feb |  |  |  |  | Feb
 | Mar |  |  |  |  | Mar |  |  |  |  | Mar |  |  |  |  | Mar
 | Apr |  |  |  |  | Apr |  |  |  |  | Apr |  |  |  |  | Apr
 | May |  |  |  |  | May |  |  |  |  | May |  |  |  |  | May
 | Jun |  |  |  |  | Jun |  |  |  |  | Jun |  |  |  |  | Jun
 | Jul |  |  |  |  | Jul |  |  |  |  | Jul |  |  |  |  | Jul
 | Aug |  |  |  |  | Aug |  |  |  |  | Aug |  |  |  |  | Aug
 | Sept |  |  |  |  | Sept |  |  |  |  | Sept |  |  |  |  | Sept
 | Oct |  |  |  |  | Oct |  |  |  |  | Oct |  |  |  |  | Oct
 | Nov |  |  |  |  | Nov |  |  |  |  | Nov |  |  |  |  | Nov
 | Dec |  |  |  |  | Dec |  |  |  |  | Dec |  |  |  |  | Dec
 | Total |  |  |  |  | Total |  |  |  |  | Total |  |  |  |  | Total
Spreadsheet: jeff_dasovich__14199__TP_1_2
Sheet: Berkeley

 |  | INPUTS |  |  | OUTPUTS
 | Restaurant Location | Weekly Hours of Operation | Full-time Equivalent Staff | Weekly Supply Expenses | Weekly Profit | Market Share (%) | Annual Growth Rate (%)
1 | Albany | 96 | 16 | 850 | 3800 | 0.25 | 0.08
2 | Berkeley | 110 | 22 | 1400 | 4600 | 0.32 | 0.085
3 | Oakland | 100 | 18 | 1200 | 4400 | 0.35 | 0.08
4 | Lafayette | 125 | 25 | 1500 | 6500 | 0.3 | 0.1
5 | Orinda | 120 | 24 | 1600 | 6000 | 0.28 | 0.09
e | 0.9595454545454544
w1 | 0.175
w2 | 0
w3 | 0.575
w4 | 0.2500000000000007
w5 | 0
e*input
 | Albany
 | Berkeley
 | Oakland
 | Lafayette
 | Orinda
Spreadsheet: 128551d1321040713-concatif-across-multiple-sheets-hours-test4upl
Sheet: Aaron Glass - Employees

Unique ID | SSN | Employee  First Name | Employee  Last Name | Jan  Hours | Feb  Hours | Mar  Hours | April  Hours | May  Hours | June  Hours | July  Hours | Aug  Hours | Sept  Hours | Oct  Hours | Nov  Hours | Dec  Hours | Total Hours |  | Jan Pension | Feb Pension | [NAME] | Apr Pension | May Pension | Jun Pension | July Pension | August Pension | Sept Pension | Oct Pension | Nov  Pension | Dec  Pension | YTD  Pension | [NAME]
ArringtonDa2269 | 2269 | [NAME] | [NAME] | 145.5 | 164.75 | 144 | 157.5 | 132.5 | 138 | 159.25 | 222.75 | 163.25 |  |  |  | 1427.5 |  | 756.6 | 856.7 | 748.8000000000001 | 819 | 689 | 717.6 | 859.95 | 1202.85 | 881.5500000000001 | 0 | 0 | 0 | 7532.050000000001
 |  | Total Hours Entered |  | 145.5 | 164.75 | 144 | 157.5 | 132.5 | 138 | 159.25 | 222.75 | 163.25 | 0 | 0 | 0 | 1427.5 |  | 756.6 | 856.7 | 748.8000000000001 | 819 | 689 | 717.6 | 859.95 | 1202.85 | 881.5500000000001 | 0 | 0 | 0 | 7532.050000000001
 |  | Total Hours from Report
 |  | Difference |  | 145.5 | 164.75 | 144 | 157.5 | 132.5 | 138 | 159.25 | 222.75 | 163.25 | 0 | 0 | 0 |  |  | 756.6 | 856.7 | 748.8000000000001 | 819 | 689 | 717.6 | 859.95 | 1202.85 | 881.5500000000001 | 0 | 0 | 0
 |  | Received Date |  | 2011-02-14 00:00:00 | 2011-03-09 00:00:00 | 2011-04-14 00:00:00 | 2011-05-13 00:00:00 | 2011-06-10 00:00:00 | 2011-07-07 00:00:00 | 2011-08-09 00:00:00 | 2011-09-09 00:00:00 | 2011-10-13 00:00:00
 |  | Check Date |  | 2011-02-10 00:00:00 | 2011-03-08 00:00:00 | 2011-04-12 00:00:00 | 2011-05-12 00:00:00 | 2011-06-07 00:00:00 | 2011-07-05 00:00:00 | 2011-08-09 00:00:00 | 2011-09-07 00:00:00 | 2011-10-12 00:00:00
 |  | Check Amount |  | 9679.88 | 13802.4 | 12643.68 | 10843.12 | 9184.56 | 11353.2 | 11747 | 30355.38 | 18466.67
 |  |  | H&W $ | 5231.28 | 7484.4 | 6856.08 | 5879.72 | 4980.36 | 4820.2 | 6337.5 | 16357.23 | 9950.87
 |  |  | Pension $ | 4448.6 | 6318 | 5787.6 | 4963.4 | 4204.2 | 4069 | 5409.5 | 13998.15 | 8515.8
 |  |  | H&W Hour | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 | 6.31 | 6.31 | 6.31
 |  |  | Pension Hour | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 | 5.4 | 5.4 | 5.4
 |  |  | Check # | 3785 | 3870 | 3997 | 4112 | 4193 | 4309 | 4437 | 4553 | 4726
 |  |  |  |  |  |  |  |  |  | *****
 | **** - Paid some hours at $6.16 and some at $6.31
Spreadsheet: 774742d1648642795-error-in-pivot-table-excel-pivot-issue-answered
Sheet: Sheet5

category | GL | Project | Amount | Sales Amt | Cost Amt |  |  |  | Column Labels
Sales | IT Sales | project A | 5000 |  |  |  |  | Row Labels | project A | project B | Grand Total
Sales | HW Sales | project A | 0 |  |  |  |  | Cost
Sales | IT Sales | project B | 100 |  |  |  |  | IT Cost
Cost | IT Cost | project B | 200 |  |  |  |  | Sum of Amount | 1160 | 200 | 1360
Sales | HW Sales | project B | 200 |  |  |  |  | Sum of GP | -1160 | -200 | -1360
Cost | IT Cost | project A | 60 |  |  |  |  | Sum of GM | #[NAME]! | #[NAME]! | #[NAME]!
Cost | IT Cost | project A | 700 |  |  |  |  | Cost Sum of Amount | 1160 | 200 | 1360
Cost | IT Cost | project A | 400 |  |  |  |  | Cost Sum of GP | -1160 | -200 | -1360
 |  |  |  |  |  |  |  | Cost Sum of GM | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  | HW Sales
 |  |  |  |  |  |  |  | Sum of Amount | 0 | 200 | 200
 |  |  |  |  |  |  |  | Sum of GP | 0 | 200 | 200
 |  |  |  |  |  |  |  | Sum of GM | #[NAME]! | 1 | 1
 |  |  |  |  |  |  |  | IT Sales
 |  |  |  |  |  |  |  | Sum of Amount | 5000 | 100 | 5100
 |  |  |  |  |  |  |  | Sum of GP | 5000 | 100 | 5100
 |  |  |  |  |  |  |  | Sum of GM | 1 | 1 | 1
 |  |  |  |  |  |  |  | Sales Sum of Amount | 5000 | 300 | 5300
 |  |  |  |  |  |  |  | Sales Sum of GP | 5000 | 300 | 5300
 |  |  |  |  |  |  |  | Sales Sum of GM | 1 | 1 | 1
 |  |  |  |  |  |  |  | Total Sum of Amount | 6160 | 500 | 6660
 |  |  |  |  |  |  |  | Total Sum of GP | 3840 | 100 | 3940
 |  |  |  |  |  |  |  | Total Sum of GM | 0.768 | 0.3333333333333333 | #[NAME]!
Spreadsheet: 83624d1283604662-data-concatenate-if-vlookup-data-concatenate-if-vlookup-new-
Sheet: AIM (Object)

LN No. | MR No. | KP No.
51 | 12344321 | 12321
56 | 65432109 | 12021
52 | 23456780 | 54321
50 | 1234567 | 4321
50 | 123456 | 321
50 | 12345 | 21
50 | 1234 | 1
 | 123 | 50
 | 12 | 465
 | 1 | 487
 |  | 24
50 | 4321 | 847
50 | 54321 | 5623
50 | 654321 | 2410
50 | 7654321 | 665544
 | 201000ACM002011
 | 201005ACM122011
 | 201003ACM452011 | 78
 | 201005ACM802011 | 123456
 | 201046ACM1232011
 | 2010123ACM3212011
 | 2010876ACM042011 | 225
50 | 551364 | 1
50 | 24153 | 12
51 | 12345678 | 123
52 | 23456789 | 123
53 | 34567890 | 1234
54 | 45678901 | 12345
55 | 56789012 | 123456
56 | 67890123 | 18
50 | 3214123 | 121
 |  |  |  | [NAME] — Data - Concatenate If Vlookup
 |  |  |  | Started by — SunOffice
 |  |  |  | http://www.excelforum.com/excel-general/742606-data-concatenate-if-vlookup.html
Spreadsheet: 112866d1308842388-moving-rows-from-one-sheet-to-another-sheet-based-on-row-content-test-book
Sheet: Sheet1

Local Government | Exact Population | Rounded Population | Population Range | Action Type | Supportive Action Category | Key Word | Action Category | Action
A | 1895 |  | 0-5,000 | Supportive Action | Policy Development | Building (policy development) | Energy | Adopted energy and water conservation targets for new DL 114 development permit area
B | 39183 |  | 10,000-50,000 | Supportive Action | Programs and Partnerships | Water (upgrade) | Energy | Assisted 5 local non-profit societies with funding to upgrade water and sewer systems for their community halls or other facilities
C | 88370 |  | 50,000-100,000 | Supportive Action | Policy Development | Building (DPA) | Energy | Proposed a new DPA for Water and Energy conservation
D | 11512 |  | 10,000-50,000 | Supportive Action | Policy Development | Community Planning (OCP) | Energy | New OCP commits to water, building, natural site, and active transportation actions
E | 11512 |  | 10,000-50,000 | Supportive Action | Policy Development | Community Planning (OCP) | Building | New OCP commits to water, building, natural site, and active transportation actions
F | 11512 |  | 10,000-50,000 | Supportive Action | Policy Development | Community Planning (OCP) | Transportation | New OCP commits to water, building, natural site, and active transportation actions
G | 11512 |  | 10,000-50,000 | Supportive Action | Policy Development | Community Planning (OCP) | [NAME] | New OCP commits to water, building, natural site, and active transportation actions
H | 826 |  | 0-5,000 | Direct Action |  | Building (upgrade) | Building | Maintain existing buildings to make as energy efficient as possible
I | 1015 |  | 0-5,000 | Direct Action |  | Building (general practice) | Building | Reviewed each development proposal to ensure all related aspects of the OCP were adhered to
J | 1411 |  | 0-5,000 | Direct Action |  | Building (general practice) | Building | Implemented OCP objective to ensure new developments have minimal environmental impact and promote sustainability
K | 1598 |  | 0-5,000 | Direct Action |  | Building (upgrade) | Building | Expansion of multi-family residential uses
L | 1895 |  | 0-5,000 | Direct Action |  | Building (general practice) | Building | Worked with developers to protect natural features on properties being developed
Spreadsheet: 7507a4f7-72b9-43bd-b4e8-0d9e596201fc
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
PFCEA | Test | PFCEA | Carcinoembryonic Antigen (CEA), Pleural Fluid | CEA, Pleural Fluid | Immunoenzymatic Assay |  |  |  | 2 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Plastic vial [NAME]: 2 mL | 0.5 mL | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82378 |  |  |  |  | Rochester
PFCEA | [NAME] | PLRFLD | Pleural Fluid |  |  |  | Frozen | 90 days
PFCEA | Result | PCEA | CEA, Pleural Fluid | CEA, Pleural Fluid | Numeric |  |  |  |  | ng/mL
PFCEA | Result | SITE9 | Site | Site | Numeric
Spreadsheet: be7a7631-9d69-4c71-8983-2f5d305de119
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7686 | 47143 | [NAME] | Turner | RSA | 0 | 00:18:06 | 00:00:00 | 01:07:31 | 00:00:00 | 00:31:22 | 1 | 01:57:01