tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: james_steffes__12828__residental rate components
Sheet: PA

PENNSYLVANIA
 | Customer charge ($/month) | Distribution (/kWh) |  | Transmission |  | CTC (/kWh) |  | Generation/Energy (if PLR)  (/kWh) |  | SBC (/kWh) | Other (/kWh) |  | Notes
Allegheny (West Penn Power) | 5 | 0.01836 |  | 0.00303 | a | 0 |  | 0.03254 |  |  | 0.00621 | b
Citizens Electric of Lewisburg | 3.56 | 1.7615 | c | n/a |  | 0.365 |  | 3.7625 | d
Duquesne Light Comp (DQE) | 6.38 | 3.0212 |  | 0.2483 | e | 3.3928 |  | 4.6349 | f
First Energy (Penn Power Comp.) | 8.89 | 2.267 |  | 0.711 |  | 1.836 | g | 5.521 | h |  |  |  | See note "i"
Met Ed (GPU) | 6.67 | 3.029 |  | 0.172 |  | 0.763 |  | 4.357
Penelec (GPU) | 6.81 | 2.973 |  | 0.124 |  | 0.315 |  | 4.404
PPL | 6.47 | 1.796 | j |  | k | 0.397 | I | 4.846 | m |  | 1.49 | n
PECO/Exelon | 5.1 | 4.57 | o |  |  | 2.71 | p | 5.02 | q
Pike County Light & Power | 5.21 | 3.76 | r |  |  | 0.0738 | s | 5.3847 | t | 0.0327
UGI | 5.5 | 3.165 | u | 0.37 | v | 0.851 | w | 4.667 | x
Wellsboro Electric | 5.51 | 1.165 |  |  | y |  |  |  | y
Notes:
All charges are in cents, unless otherwise specified.  All charges are for the basic residential service currently effective and assumes one "dwelling".  When a charge is dependant on quantity of kWhs, the charge for the first level is used and a footnote indicates the price differs depending on quantity.
a) There is also an ancillary charge of  0.00141
b) Intangible transition
c) Price for first 200 kWh (next 800 = 1.5115; additional = 1.1115
d) For PLR customers; this is a maximum charge and includes transmission
e) If an EGS is selected, transmission and generation are not charged by DQE
f) Generation charge includes transmission ancillary services, etc.
g) Per first 350 kWh (over 350 = 1.377; charge decreases when a load meter is installed)
h) Energy and capacity charges (over 350=4.141; charge decreases when a load meter is installed)
i) Those with an alternative supplier will receive credit for ancillary services charged as part of transmission charges; there is also a "loss" charge
j) For the first 200 kWh (next 600 = 1.594; additional = 1.594)
k) The charge "will provide and charge consistent with PJM Open Access Transmission Tariff…"
l) For the first 200 kWh (next 600 = 0.352; additional = 0.325)
m) For the first 200 kWh (next 600 = 4.256; additional = 3.903)
n) Intangible transition charge
o) For June-September for first 500 kWh (additional kWh is 5.31); winter is 4.57
p) For June-September for first 500 kWh (additional kWh is 3.12); winter is 2.71
q) For June-September for first 500 kWh (additional kWh is 5.61); winter is 5.02
r) "Delivery" charge for first 1,000 kWh (over 1k = 3.2507)
s) For first 1k (over 1k = .0635)
t) For first 1k (over 1k = 4.6427)
u) For first 500 (next 500=2.684, over 1000=1.971)
v) For all
w) For first 500 (next 500=0.736, over 1000=0.564)
x) For first 500 (next 500=4.032, over 1000=3.090)
y) Generation and transmission charge is a variable market rate (3.9045 as of Nov. 00)
Spreadsheet: 0675e5fe-ba8c-45de-95f4-487e365b6a28
Sheet: Sherbet

Sherbet Production Sheet
Sherbet Produced (gal)
Finished Sherbet (gal)
Sherbet Remaining (gal)
[NAME] (gal)
Flavor, Volume | Volume | No. of [NAME] | Sherbet (Gal) | Mix Required (Gal)
Lemon | 3 gallon
 | quart
Lime | 3 gallon
 | quart
Orange | 3 gallon
 | quart
Pineapple | 3 gallon
 | quart
[NAME] | 3 gallon
 | quart
Watermelon | 3 gallon
 | quart
Flavor7 | 3 gallon
 | quart
Total:
Notes:
Spreadsheet: 219289d1362699862-nested-formula-required-for-two-cell-inputs-and-a-single-cell-output-kentec
Sheet: Sheet1

 |  |  |  |  |  |  | 1 | 2 | [NAME]
 |  |  |  |  |  |  | 1 | 4 | Kentec XT+ 1 Area 4 Zone
 |  |  |  |  |  |  | 1 | 6 | Kentec XT+ 1 Area 8 Zone
 |  |  |  |  |  |  | 2 | 2 | Kentec XT+ 2 Area 2 Zone
 |  |  |  |  |  |  | 2 | 4 | Kentec XT+ 2 Area 4 Zone
 |  |  |  |  |  |  | 2 | 6 | Kentec XT+ 2 Area 8 Zone
 |  |  |  |  |  |  | 3 | 2 | Kentec XT+ 3 Area 2 Zone
 |  |  |  |  |  |  | 3 | 4 | Kentec XT+ 3 Area 4 Zone
 |  |  |  |  |  |  | 3 | 6 | Kentec XT+ 3 Area 8 Zone
 |  |  |  |  |  |  | 4 | 2 | Kentec XT+ 4 Area 2 Zone
 |  |  |  |  |  |  | 4 | 4 | Kentec XT+ 4 Area 4 Zone
 |  | 1 |  |  |  |  | 4 | 6 | Kentec XT+ 4 Area 8 Zone
 |  | 4
Spreadsheet: 45571d1244346226-conditional-formatting-if-matching-set-of-values-conditional
Sheet: Sheet1

NIESTER | [NAME] |  | ALEXANDER | [NAME]
GLEESON | fred |  | ANTHIS | [NAME]
HALE | justin |  | BENGE | nathan
KEIM | [NAME] |  | BLEY | geoff
[NAME] | [NAME] |  | NIESTER | [NAME]
KEIM | jordan |  | KEIM | [NAME]
ANTHIS | [NAME]
ANTHIS | [NAME]
Spreadsheet: elizabeth_sager__9631__Williams-Dynegy Assignments
Sheet: Sheet1

 | [NAME] purposed assignments
 | Couterparty | Buy/Sell | Deal # | Volume | Price | Time | Delivery | Tenure | Full MTM
1a | [NAME] | B | 572231 | 50 | 45 | ON | CINERGY | '02-05 | -8703099
1b | Dynegy | S | 569237 | 50 | 44.75 | ON | CINERGY | '02-05 | 8514958
2a | [NAME] | B | 475619 | 50 | 59.5 | ON | CINERGY | '02 | -5368684
2b | Dynegy | S | 559221 | 50 | 50 | ON | CINERGY | '02 | 3467709
3a | [NAME] | B | 510236 | 50 | 77 | OFF | SP-15 | '02 | -9360034 | can only take half value due to MW differences
3b | Dynegy | S | 538869 | 25 | 72 | OFF | SP-15 | '02 | 4208288
4a | [NAME] | B | 473070 | 50 | 60.25 | ON | CINERGY | '02 | -5518761
4b | Dynegy | S | 733840 | 50 | 39.75 | ON | CINERGY | '02 | 1416656
5a | [NAME] | B | 555561 | 25 | 77 | ON | SP-15 | '03 | -3863902
5b | Dynegy | S | 538841 | 25 | 72 | ON | SP-15 | '03 | 3282738
6a | [NAME] | B | 595421 | 25 | 45 | OFF | SP-15 | '03-04 | -3138508 | 03-04 tenure use only '04
6b |  | S | 537900 | 25 | 45 | OFF | SP-15 | '04 | 1437453
7a | [NAME] | B | 611574 | 25 | 57 | ON | SP-15 | '03 | -1539245
7b |  | S | 539009 | 100 | 73.25 | ON | SP-15 | '03 | 13712116
8a | [NAME] | B | 555563 | 25 | 77 | ON | SP-15 | '03 | -3863902
8b | Dynegy | S | 538994 | 125 | 72 | ON | SP-15 | '03 | 16413690
 |  |  |  |  | Full out-of the money w/Williams
 |  |  |  |  | Minus half 3a
 |  |  |  |  | Minus half 6a
 |  |  |  |  | [NAME] to be shifted
 |  |  |  |  | Full in the money w/Dynegy
 |  |  |  |  | Minus 75% 7b
 |  |  |  |  | Minus 80% 7b
 |  |  |  |  | [NAME] to be shifted
 |  |  |  |  | Difference
Spreadsheet: 773118d1647622681-help-needed-with-returning-1st-col-values-based-on-adjacent-array-book-5
Sheet: Sheet1

 |  | TAG | ROUTES
 |  |  |  |  |  |  |  |  | I want to auto generate a list with no spaces or blanks that results in this below…
AA |  | 101 | AA | GG | HH | EE
 |  | 102 | AC | AD | EE | FA |  |  | 101
 |  | 101 | EH | AA | AB | AC |  |  | 101 | 101
 |  | 105 | AC | FF | GG | AE |  |  | 104 | 104
 |  | 104 | AD | AB | AA | AE |  |  | 102 | 102
 |  | 101 | FA | TE | AD | TQ
 |  | 102 | GG | TE | AB | AA |  |  | because I search for any row that has the cell AA and then return the 1st column's value for each
Spreadsheet: 43323d1241975722-split-numbers-and-split-words-another-stab
Sheet: Sheet1

 | FN | MN | EN
 | 12 | 23 | 44 | Numbers i put in!
 | FN |  | MN |  | EN |  |  |  | FN | MN | EN
 | 12 | + | 23 | + | 44 | = | 79 |  | 3 | 3 | 3 | 9 | Only 1 number, problem in 2 and 3 spot next line, How do i get it to put "0" in this places?
 | 7 | + | 0 | + | 0 | = | 7 |  | 9 | 0 | 0 | 9 | Now i need to get "0" in 2 and 3 spot automaticly, since its only one number!
 | 7 | + | 0 | = | 7 |  |  |  | 9 | 0 |  | 9 | Now i need to get "0" in 2 spot automaticly, since its only one number!
 |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | FN | MN | EN
 |  |  |  |  |  |  |  |  | 333 | 333 | 333 | 999 | Great! Got 3 numbers, all is well!
 |  |  |  |  |  |  |  |  | 9 | 9 | 9 | 27 | Great"! Got 2 numbers, all is well!
 |  |  |  |  |  |  |  |  | 2 | 7 |  | 9 | This one works out great, since i got numbers in all the places!
 | FN |  | MN |  | EN |  |  |  | FN | MN | EN
 | 12 | + | 23 | + | 44 | = | 79 |  | 5 |  | 8 | 13 | Here I need to put in a formula that puts "0" in when MN dos not produse a number, so that i get a sum!
 | 7 | + | 0 | + | 0 | = | 7 |  | 1 | 3 | 0 | 4 | And in the 3 spot I need to put in a "0" since its only 13_ and lacking a 3 number!
 | 7 | + | 0 | = | 7 |  |  |  | 4 | 0 |  | 4 | Same here, sine I got only one digit in the last line, I need to automatickly also get "0" here if only 1 number!
 |  |  |  |  | Total
 | How i did it… But this dos not work!
 | FN |  | MN |  | EN
 | 12 | + | 23 | + | 44 | = | 79
 | 7 | + | 7 | + | #N/A | = | #N/A
 |  |  |  |  | This… | Is the problem with only 2 numbers "13", on the 3 spot it dos not get a value, there is no 3 number.
 | #N/A | + | #N/A | = | #N/A | So how do i get it to put "0" if there is NOT 3 number
 |  |  | This… |  | Total
 | FN | MN | EN
 | 333 | 333 | 333
 | FN |  | MN |  | EN
 | 3 | + | 0 | + | 0 | = | 3
 | 3 | + | 3 | + | #N/A | = | #N/A
 |  |  |  |  | This… | Is the problem with only 2 numbers "13", on the 3 spot it dos not get a value, there is no 3 number.
 | #N/A | + | #N/A | = | #N/A | So how do i get it to put "0" if there is NOT 3 number
 |  |  | This… |  | Total
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Karlo FTW

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
Karlo FTW
offlineKarlo FTW
Remove friend Send message Donate
Experience level 30
29,711 / 30,000
Location: UkraineUkraine, Subcarpathia Citizenship: CroatiaCroatia
eRepublik birthday
Nov 06, 2009
National rank: 144
No political activity
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
News from eCroatia
Friends(1392)
marac2809
[NAME]
Atea
[NAME]
marko-st
[NAME]
StjepanRadic
Roman Rajh
brutas33
view all
Land of Karlo FTW: 29 buildings
Visit
About me
Wiki page
Subscribe my newspapers!
Selling Q5 tanks and buying food all quality,pm me or on irc /query [NAME]
Achievements
hard worker
13
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
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
6
Resistance Hero
Started a resistance war and liberated 6 regions.
super soldier
20
Super Soldier
Advance 250 strength points
society builder
2
Society Builder
Invited 10 people to eRepublik and helped them reach level 10
mercenary
1
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
5,049.48
Super soldier:5,049 / 5,250
Rank
Supreme Marshal ***Supreme Marshal ***
Rank points:
4,222,009 / 4,900,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 35595d1233183043-how-to-restrict-the-cell-data-to-letters-a-through-e-and-a-through-e-conditional-formatting-options
Sheet: Sheet1

Evaluation
N | Why did the chicken cross the road? |  |  |  |  |  |  |  |  | 1
 |  | For la resistance! |  |  |  |  |  |  |  | 0
Y | What is 5 + 5? |  |  |  |  |  |  |  |  | 0
 |  | ten |  |  |  |  |  |  |  | 0
N | Is my ex an awesome person? |  |  |  |  |  |  |  |  | 1
 |  | Yes |  |  |  |  |  |  |  | 0
Y | Am I really a mewing kitty? |  |  |  |  |  |  |  |  | 0
 |  | Yes |  |  |  |  |  |  |  | 0
Y | How much wood could a wood [NAME] if a wood [NAME] could [NAME]? |  |  |  |  |  |  |  |  | 0
 |  | Lots
Spreadsheet: benjamin_rogers__1032__Coal presentation Backup
Sheet: Preliminary Economics

 | 750 | MW | 10500 | Heat Rate |  | 8000 | Heat Rate |  | 8000 | Heat Rate
 |  |  | 1.25 | /MMBTU |  | 3 | /MMBTU |  | 4 | /MMBTU
 |  |  |  | /MWH |  |  | /MWH |  |  | /MWH
 | Fuel Cost | Variable O&M | Dispatch Cost
Coal $/MWh
Gas $/MWh @ $3.00/MMBTU
Gas $/MWh @ $4.00/MMBTU
Dispatch Spread ($3 Gas)
Dispatch Spread ($4 Gas)
 |  |  |  |  | (Excluding O&M)
 |  |  |  |  | 30 Year NPV of Dispatch Spread @ 18% Discount Rate
 |  |  |  |  | In $[NAME]'s
 |  |  |  |  |  | Gas Price
 |  |  |  |  |  | $3.00/MMBTU | $4.00/MMBTU
 |  |  |  | Run Hours | 8000
Year | 1
Yearly Dispatch Spread ($3 Gas)
Yearly Dispatch Spread ($4 Gas)
NPV ($3 Gas)
NPV ($4 Gas)
 |  |  | Market Price
Revenue per Year |  |  | 25 | /MWH
Year | 1
Yearly Dispatch Spread ($3 Gas)
Yearly Dispatch Spread ($4 Gas)
NPV ($3 Gas) |  | Including O&M and major maintenance |  |  | (Including O&M and Major [NAME])
NPV ($4 Gas) |  |  |  |  | 30 Year NPV of Dispatch Spread @ 18% Discount Rate
 |  |  |  |  | In $[NAME]'s
 |  |  |  |  |  | Gas Price
 |  |  |  |  |  | $3.00/MMBTU | $4.00/MMBTU
 |  |  |  | Run Hours | 8000
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Davey

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 1ef298eb-3898-4f17-b831-355a2350b0f7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 36. Value of Building Approved - Northern Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A420418X | 1970-07-01 00:00:00 | 2009-06-01 00:00:00 | 468 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420430R | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420442X | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | [NAME] | 1970-07-01 00:00:00 | 2009-06-01 00:00:00 | 468 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422768K | 1973-07-01 00:00:00 | 2009-06-01 00:00:00 | 432 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 146345d1332128901-indexing-values-using-vlookup-indexing
Sheet: Sheet1

 | a | 1 |  | a | b
 | a | 2 |  | 1 | 4
 | a | 3 |  | 2 | 5
 | b | 4 |  | 3 | 10
 | b | 5 |  | 6 | 11
 | a | 6 |  | 7
 | a | 7 |  | 8
 | a | 8 |  | 9
 | a | 9 |  | 12
 | b | 10 |  | 13
 | b | 11 |  | 14
 | a | 12 |  | 15
 | a | 13 |  | 16
 | a | 14 |  | 17
 | a | 15
 | a | 16
 | a | 17
Spreadsheet: 804168d1667923272-conditional-formating-across-tabs-if-istext-contac-bonus-meeting-at-1-3-week-look-ahead-work-in-progress
Sheet: 22-001

Job # | Current Awarded Jobs | Resource | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri
22-001 | Operation |  | 2022-11-07 00:00:00
185 [NAME] | DEMO
 | MOBILZATION |  | x
 | [NAME] | RG |  | x
 | EROSION CONTROL |  |  |  | x | x | x
 | survey
 | testing
 | permits
 | MOT
 | barricades
 | barrier wall
 | mot sub
 | MOBILZATION
 | EARTHWORK - ROUGH GRADE
 | clearing and grubbing
 | stripping & stockpiling
 | onsite cuts
 | onsite fills
 | rock excavation
 | bld. Bulk excvation & backfill
 | bld. Pad prep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8/24 ?
 | hauling
 | finish grading/ top soil respread
 | other earthwork
 | dewatering
 | Drilling
 | Blasting
 | Boring
 | Excavation
 | STORM
 | STORM PIPE SUBMITT
 | STORM PIPE APPROVALS
 | STORM  PIPE DELIVERY
 | STORM PIPE INSTALL
 | STORM STRUCTURES SUBMITT
 | STORM STRUCTURES APPROVALS
 | STORM STRUCTURES DELIVERED
 | STORM STRUCTURES INSTALLED
 | SANITARY SEWER
 | SANITARY PIPE SUBMIT
 | SANITARY PIPE APPROVAL
 | SANITARY  PIPE DELIVERED
 | SANITARY  PIPE INSTALLED
 | SANITARY  STRUCTURES SUBMITTAL
 | SANITARY  STRUCTURES APPROVED
 | SANITARY  STRUCTURES DELIVERED
 | SANITARY STRUCTURES INSTALLED
 | WATER
 | WATER PIPE SUBMITTAL
 | WATER PIPE APPROVAL
 | WATER LIFT STATION SUBMITTAL
 | WATER LIFT STATION APPROVAL
 | WATER QUALITY SUBMITTAL
 | WATER METER  APPROVAL
 | WATER METER  SUBMITTAL
 | UNDERGROUND DETENTION SUBMITTAL
 | FILTERRA STRUCTURES SUBMITTAL
 | PAVING
 | ASPHALT SUBMITTAL
 | ASPHALT APPROVAL
 | CONCRETE SUBMITTAL
 | CONCRETE APPROVAL
 | STRIPING SUBMITTAL
 | STRIPING APPROVAL
 | SIDEWALK
 | CURB
 | PAVING BASES
 | PARKING LOT
 | BUILDING PAD
 | [NAME]
 | erosion control | RG
 | clearing and grubbing | RG
 | stripping & stockpiling | RG
 | onsite cuts
 | onsite fills
 | rock excavation
 | bld. Bulk excvation & backfill
 | bld. Pad prep
 | hauling
 | finish grading/ top soil respread
 | other earthwork
 | dewatering
 | Drilling
 | Blasting
 | Boring
 | Excavation
Spreadsheet: 131191d1322778075-returning-multiple-results-example1
Sheet: Contact Info

 | PHONE | ADDRESS | CITY STATE ZIP
Customer1 | 1234567890 | 123 Road St | City, ST, 12345
Customer2 | 1234567890 | 124 Road St | City, ST, 12346
Customer3 | 1234567890 | 125 Road St | City, ST, 12347
Customer4 | 1234567890 | 126 Road St | City, ST, 12348
Customer5 | 1234567890 | 127 Road St | City, ST, 12349
Customer6 | 1234567890 | 128 [NAME] | City, ST, 12350
Customer7 | 1234567890 | 129 Road St | City, ST, 12351
Customer8 | 1234567890 | 130 [NAME] | City, ST, 12352
Customer9 | 1234567890 | 131 Road St | City, ST, 12353
Customer10 | 1234567890 | 132 Road St | City, ST, 12354
Customer11 | 1234567890 | 133 Road St | City, ST, 12355
Customer12 | 1234567890 | 134 Road St | City, ST, 12356
Customer13 | 1234567890 | 135 Road St | City, ST, 12357
Customer14 | 1234567890 | 136 Road St | City, ST, 12358
Customer15 | 1234567890 | 137 Road St | City, ST, 12359
Customer16 | 1234567890 | [NAME] | City, ST, 12360
Customer17 | 1234567891 | 139 Road St | City, ST, 12361
Spreadsheet: 482652d1475168595-work-out-yearly-values-ef
Sheet: Sheet1

[NAME] | date |  | Miles per year
10168 | 2007-09-04 00:00:00
19906 | 2008-03-05 00:00:00
30601 | 2008-10-01 00:00:00
40405 | 2009-10-05 00:00:00
40577 | 2009-10-08 00:00:00
49782 | 2010-07-05 00:00:00
50434 | 2010-07-27 00:00:00
54499 | 2011-06-09 00:00:00
68732 | 2012-05-31 00:00:00
83197 | 2014-12-17 00:00:00
90225 | 2015-12-11 00:00:00
95623 | 2016-02-23 00:00:00
Spreadsheet: b773864e-34bc-4cd2-a062-73667b167884
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38752661 | 2013-11-29 03:09:36 | ALLIES | 0 | 5 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
38752745 | 2013-11-29 03:19:14 | ALLIES | 0 | 4 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
38752825 | 2013-11-29 03:26:36 | ALLIES | 0 | 3 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
Spreadsheet: joe_parks__14622__POSTIONTRAX_NOV
Sheet: J-V_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 53.5 | 3.085 |  |  | 53.5 | 3.055 |  |  |  |  | ROLLOFF VAULE
 | 53.5 | 3.045 |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 7.5
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 61356d1262177955-creating-bar-chart-with-acceptable-range-712177
Sheet: Sheet1

NAME | VALUES | MIN | MAX
m | 10 | 5 | 12 | 7.5
nb | 12 | 5 | 14 | 6.5
r | 13 | 4 | 15 | 5.5
t | 12 | 4 | 14 | 4.5
y | 6 | 6 | 8 | 3.5
u | 12 | 2 | 14 | 2.5
f | 5 | 4 | 7 | 1.5
d | 7 | 6 | 9 | 0.5
Spreadsheet: 79901d1280160681-auto-sorting-rank-tiebreakers-and-other-help-2010-2011-nfl-season
Sheet: NFL Team Information

LR | CR | DR | Team |  |  |  | Overall |  |  |  |  |  |  | Divisional |  |  |  | Home |  |  |  |  |  |  | Away
 |  |  |  |  |  |  | Wins | Loses | % | (W-L) | PF | PA | Net | Wins | Loses | % | (W-L) | Wins | Loses | % | (W-L) | PF | PA | Net | Wins | Loses | % | (W-L) | PF | PA | Net
 |  |  | Baltimore | Ravens | Baltimore Ravens | BAL
 |  |  | Cincinnati | Bengals | Cincinnati Bengals | CIN
 |  |  | Cleveland | [NAME] | [NAME] | CLE
 |  |  | Pittsburgh | Steelers | Pittsburgh Steelers | PIT
 |  |  | Houston | Texans | Houston Texans | HOU
 |  |  | Indianapolis | Colts | Indianapolis Colts | IND
 |  |  | Jacksonville | [NAME] | [NAME] | JAX
 |  |  | Tennessee | Titans | Tennessee Titans | TEN
 |  |  | Buffalo | Bills | Buffalo Bills | BUF
 |  |  | Miami | [NAME] | [NAME] | MIA
 |  |  | NY Jets | - | New York Jets | NYJ
 |  |  | New England | Patriots | New England Patriots | NE
 |  |  | Denver | Broncos | Denver Broncos | DEN
 |  |  | Kansas City | Chiefs | Kansas City Chiefs | KC
 |  |  | Oakland | Raiders | Oakland Raiders | OAK
 |  |  | San Diego | Chargers | San Diego Chargers | SD
 |  |  | Chicago | Bears | Chicago Bears | CHI
 |  |  | Detroit | Lions | Detroit Lions | DET
 |  |  | Green Bay | Packers | Green Bay Packers | GB
 |  |  | Minnesota | Vikings | Minnesota Vikings | MIN
 |  |  | Atlanta | Falcons | Atlanta Falcons | ATL
 |  |  | Carolina | Panthers | Carolina Panthers | CAR
 |  |  | New Orleans | Saints | New Orleans Saints | NO
 |  |  | Tampa Bay | Buccaneers | Tampa Bay Buccaneers | TB
 |  |  | Dallas | Cowboys | Dallas Cowboys | DAL
 |  |  | NY Giants | - | New York Giants | NYG
 |  |  | Philadelphia | Eagles | Philadelphia Eagles | PHI
 |  |  | Washington | Redskins | Washington Redskins | WSH
 |  |  | Arizona | Cardinals | Arizona Cardinals | ARZ
 |  |  | San Francisco | 49ers | San Francisco 49ers | SF
 |  |  | Seattle | Seahawks | [NAME] | SEA
 |  |  | St. Louis | [NAME] | St. Louis Rams | STL