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

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
ToxicCro
offlineToxicCro
Add as a friend Send message Donate
Experience level 28
16,954 / 20,000
Location: PolandPoland, Lower Saxony and Bremen Citizenship: CroatiaCroatia
eRepublik birthday
Jan 26, 2010
National rank: 795
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
[NAME])
Odak
che-krtica
[NAME] od Potoka
Smiljan
Gunner_V
[NAME]
gazzari
UsrcU
Begonija
view all
Land of ToxicCro: 11 buildings
Visit
About me
Wiki page
[NAME] i kamatar :)
Ako tko treba GOLDA neka mi pošalje [NAME]! :)
Achievements
hard worker
17
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
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
12
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,118.00
Super soldier:3,118 / 3,250
Rank
General ***General ***
Rank points:
1,344,658 / 1,350,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 710211d1608775919-need-to-move-random-data-from-one-worksheet-to-another-my-dmc-thread-inventory-template
Sheet: Overview

Thread variety | Number of skeins owned | Number of skeins on "needed" list | Unique skeins owned | Percentage of colors owned
Main colors
Variegated
Satins
Diamant
Metallics – Light Effects
Color Variations
Total
Spreadsheet: 1ff99977-7670-43bf-8315-e0e0ed640dd9
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0028693 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Mountaintop Golf & Lake Club WWTF | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 70300 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L | NTU
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
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Grab | Composite | Composite | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  | 120000 | 10 |  |  |  | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | 3 x Year | 3 x Year | 5 x Week | See Permit | See Permit | See Permit | 5 x Week | 3 x Year | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 676146d1588679006-double-dependent-drop-down-blank-cells-drop-down-from-2-inidices-of-table-matrix-va-graves1907-
Sheet: Lookups-Master

 |  |  | Category | BMcD | Client | BMcD LT | New Column |  |  |  | This section to the left is located on a separate sheet from the drop downs | The actual sheet is 500 - 1000 lines long for this section as well as the green and yellow below. | People will add data to this table periodically and those changes need to appear on the data validation (I.E. new "Categories", different name options, new columns, etc.) |  |  |  |  |  | Cleaned up list from index rows for building drop-down | Cleaned up list from table headers for building drop-down
 |  |  | Dev | [NAME] | [NAME] | [NAME]
 |  |  | Dev | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | No change ==> |  |  |  | <== Change
 |  |  | Dev | Darrin | Darrin
 |  |  | Dev | Neel
 |  |  | Dev | Greg
 |  |  | Mis | Greg | Greg | Greg
 |  |  | Mis
 |  |  | Mis | [NAME] | [NAME] | [NAME]
 |  |  | Mis |  | [NAME] | [NAME]
 |  |  | Mis |  | Neel | Neel
 |  |  | Fin | Neel | Neel | Neel
 |  |  | Fin | [NAME] | [NAME] | [NAME]
 |  |  | Fin |  |  | Darrin
Spreadsheet: 890038d1741171041-merge-formula-example-8-
Sheet: Sheet1

[NAME] | Ext. number | Name 1 | Name 2 | Name 3 | Name 4 | Addresses-Street | Addresses-House number | Addresses-Country-ISO 2
 | 1 | Auchan Titan |  |  |  | Bulevardul 1 Decembrie 1918 | 33A | RO
 | 2 | Auchan Targu Mures Istoric |  |  |  | Strada Gheorghe Doja | 243 | RO
 | 3 | [NAME] |  |  |  | Dn 65 B, Nr F4 Comuna Bradu | F4 | RO
 | 4 | [NAME] |  |  |  | Strada Alexandru Vaida Voevod | 53B | RO
 | 10 | [NAME] |  |  |  | [NAME] | 564-560 | RO
 | 9 | [NAME] |  |  |  | Calea Unirii | 22 | RO
 | 7 | [NAME] |  |  |  | Strada Aristide Demetriade | 1 | RO
 | 8 | [NAME] |  |  |  | [NAME] Vlaicu | 220 | RO
 | 12 | [NAME] |  |  |  | Calea București | 80 | RO
 | 13 | Auchan City Crangasi |  |  |  | Bulevardul Constructorilor | 16A | RO
Spreadsheet: 543452d1508405072-plants-downtime-calculations-zeszyt1
Sheet: Sheet4

 |  | Plant Downtimes Calculations
 |  | Date | Plant A |  |  | Plant B |  |  | Remarks
 |  |  | Planned TA | Power | Others | Planned TA | Power | Others
 |  | 2017-01-01 00:00:00 |  |  | 3 Hr 20 Min |  | 1 Hr 20 Min |  | Plant A was down for Inspection. Plant B was down due to power failure
 |  | 2017-01-02 00:00:00
 |  | 2017-01-03 00:00:00
 |  | 2017-01-04 00:00:00
 |  | 2017-01-05 00:00:00
 |  | 2017-01-06 00:00:00
 |  | 2017-01-07 00:00:00
 |  | 2017-01-08 00:00:00
 |  | 2017-01-09 00:00:00
 |  | 2017-01-10 00:00:00
 |  | 2017-01-11 00:00:00
 |  | 2017-01-12 00:00:00
 |  | 2017-01-13 00:00:00
 |  | 2017-01-14 00:00:00
 |  | Toatl
Spreadsheet: 529705d1500971173-return-list-with-non-blank-values-from-a-range-with-multiple-columns-testfile
Sheet: Solution ExcelForum

 | sofie | [NAME] | [NAME]
tom |  | george
piet | eline | tine | elise
[NAME] | [NAME] |  | [NAME]
 | anne | joost | ann-sophie
 | inge |  | ine
[NAME] |  | [NAME]
 |  | filip
 | leen |  | lore
tom | hilke |  | hannelore
 |  |  | lisabeth
[NAME] | isabelle
Spreadsheet: 122519d1316904207-auto-sort-rows-newest-football-statsheet
Sheet: Home

Team_______________ |  |  |  |  | Record_____________ |  |  |  |  |  |  |  |  | Coach_______________ |  |  |  |  |  |  |  | Date______________
 |  |  |  |  |  | Receiving
Name | # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 11 | 12 | 13 | 14 | Tot. |  | [NAME]. |  |  |  |  | Team Stats |  |  |  |  |  |  | Individual Stats
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass: |  | for |  |  |  | yds. |  | Receiving
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INT |  |  | TD's |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rush: |  |  |  | for |  | yds. |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TD's |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Off.: |  | TD's |  |  | yds. |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penalties: |  | for |  | yds. |  |  | Rushing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st downs: |  |  | TO's: |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Def: |  |  | YARDS ALLOWED |  |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SACKS |  |  |  | TFL |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INT |  |  |  | FUM |  |  |  |  |  | carries for |  |  | yds, |  | TD
incompletions: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total: |  |  |  |  |  | Times: |  |  |  |  |  |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  | Rushing
Name | # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | Tot. |  | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
Yards
Drives        Plays
Time
Results
1st Downs:
Penalties:
Spreadsheet: 389979d1429397965-how-to-copy-each-result-to-other-column-when-accepted-list_selections
Sheet: Sheet1

 |  |  | choose--> | Category | A |  |  |  |  | Data
 |  |  | choose--> | Size | S |  |  |  |  | Category | Size
 |  |  | result--> | Model |  |  |  |  |  | A | S
 |  |  |  |  |  |  |  |  |  | B | M
 |  |  |  |  |  |  |  |  |  | C | L
 |  |  | Selections | Model | Qty |  |  |  |  | D | XL
Spreadsheet: 790718d1659964666-count-each-element-in-the-column-and-assign-it-to-the-row-it-is-responsible-for-workbook1
Sheet: Sheet1

Machines | Host | VLAN
Machine11 | esxi-1 | 3,69 |  |  |  |  |  | Host   \ [NAME] | 3 | 69 | 3501 | 6 | 3007 | 1274 | 17 | 18
Machine12 | esxi-1 | 3501 |  |  |  |  |  | esxi-1 | 2 | 2 | 5 | 1 | 2 | 2 | 0 | 0
Machine13 | esxi-1 | 3501,6 |  |  |  |  |  | esxi-2 | 0 | 0 | 3 | 0 | 0 | 0 | 1 | 1
Machine14 | esxi-1 | 3501,3
Machine15 | esxi-1 | 3007,  1274, 3501
Machine16 | esxi-1 | 3007,  1274, 3501
Machine21 | esxi-2 | 17,18,19,3501
Machine22 | esxi-2 | 20,23,822,3501
Machine23 | esxi-2 | 24,25,298,3501
Machine24 | esxi-2 | 26,27,818
Spreadsheet: 732643d1621092806-price-menu-dependent-drop-downs-with-lookup-function-based-on-multiple-selections-price-menu-xlookup
Sheet: Pricing

MAKE | MODEL | Category | Service | Labor Hours |  | LABOR RATE | 100 |  | MAKES | Ford | Toyota | Honda |  |  |  |  |  | MODEL |  | Category |  | SERVICE
FORD | FESTIVA | BRAKES | MASTER CYLINDER REPLACEMENT | 3.5 |  |  |  |  | FORD | Festiva | Rav4 | Fit |  |  |  |  |  | FESTIVA |  | BRAKES |  | MASTER CYLINDER REPLACEMENT
FORD | FESTIVA | BRAKES | R&R FRONT BRAKE PADS | 3.5 |  |  |  |  | TOYOTA | Mustang | Camry | Accord |  |  |  |  |  | MUSTANG |  | ELECTRICAL |  | OVERHALL
FORD | MUSTANG | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 4.5 |  |  |  |  | HONDA |  | Supra | Odyssey |  |  |  |  |  | RAV4 |  | ENGINE |  | R&R FRONT BRAKE PADS
FORD | MUSTANG | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 4.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | CAMRY |  |  |  | R&R FRONT BRAKE PADS -REPLACE ROTORS
TOYOTA | RAV4 | ELECTRICAL | REPLACE HEADLIGHTS | 4.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPRA |  |  |  | R&R FRONT BRAKE PADS -RESURFACE ROTORS
TOYOTA | RAV4 | BRAKES | R&R FRONT BRAKE PADS | 3.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | FIT |  |  |  | REPLACE HEADLIGHTS
TOYOTA | CAMRY | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 4.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCORD |  |  |  | WATER PUMP
TOYOTA | CAMRY | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 4.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | ODYSSEY
TOYOTA | SUPRA | ENGINE | OVERHALL | 0.5
TOYOTA | SUPRA | ENGINE | WATER PUMP | 0.5
HONDA | FIT | BRAKES | MASTER CYLINDER REPLACEMENT | 3.5
HONDA | FIT | BRAKES | R&R FRONT BRAKE PADS | 4.5
HONDA | ACCORD | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 5.5
HONDA | ODYSSEY | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 5.5
Spreadsheet: 53185d1253116334-return-only-unique-text-from-another-sheet-along-with-correlating-minimum-and-maximum-book4_sep16
Sheet: Sheet1

Job Title | Job Group | Salary |  |  |  | Data
[NAME] | x | 200000 |  | Job Group | Job Title | [NAME] of Salary | Min of Salary2
[NAME] | x | 89000 |  | x | [NAME] | 200000 | 88000
[NAME] | x | 120000 |  |  | [NAME] | 120000 | 89000
[NAME] | x | 88000 |  |  | Purch Mgr | 60000 | 60000
Purch Mgr | x | 60000 |  | x Total |  | 200000 | 60000
[NAME] | y | 45000 |  | y | [NAME] | 195000 | 195000
[NAME] | y | 110000 |  |  | [NAME] | 110000 | 45000
Purch Mgr | y | 75000 |  |  | Purch Mgr | 75000 | 75000
[NAME] | y | 195000 |  | y Total |  | 195000 | 45000
[NAME] | z | 188000 |  | z | [NAME] | 188000 | 188000
[NAME] | z | 99000 |  |  | [NAME] | 99000 | 65000
[NAME] | z | 65000 |  |  | Pur Mgr | 45000 | 45000
Pur Mgr | z | 45000 |  | z Total |  | 188000 | 45000
 |  |  |  | Grand Total |  | 200000 | 45000
Spreadsheet: 77665d1278082407-vlookup-returning-errors-test-book
Sheet: data

ref | Site_Address | Site_County | Site_Post_Code | Site_Cust_Num | Site_Area_Code | ref
10558 | Anniesland Village Business Park Netherton Road Glasgow | Strathclyde | G13 1EU | 123 | 10-A | 10558
10562 | Unit 6  Block 5  Oakbank Industrial Estate Garscube Road Glasgow | Strathclyde | G20 7LU | 123 | 10-A | 10562
10578 | Unit 1 Block 8  3 Spearsbridge Terrace Thornliebank Ind Estate Nitshill Road Glasgow | Strathclyde | G46 8JH | 123 | 10-B | 10578
10724 | Block 6 Unit 1, Young Road Caldwellside Ind Est Lanark |  | ML11 7SR | 123 | 10-C | 10724
10731 | 43 [NAME] [NAME]East Kilbride | Renfrewshire | G75 0YL | 123 | 10-B | 10731
Spreadsheet: 709689d1608485336-automatic-creation-of-summary-and-filling-of-data-autofill-of-orders
Sheet: SUMMARY

 | CustID | WOID | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-12 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-19 00:00:00 | 2020-12-20 00:00:00
 | C123 | WO123
 | C234 | [NAME]
 | C345 | WO345
 | C456 | WO456
 | The above have been filled automatically.
 | Can it be done automatically by Excel?
 | When a customer issues [NAME], a new Sheet will be added with data in the same pattern as the four sheets shown.
 | Then, the Summary Sheet should autofill CustID, WOID and the quantity in the appropriate dates.
 | Is such a thing possible?
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 27

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
Handmade Sticker: 3.75"x4.5" 3D Handcrafted Food Fun Themed |  |  |  |  | 24 | 0.48 | 11.52
SS874F | F) Ice Cream Parlour | 775749180398 | CHINA | 4911.91.0090
Handmade Sticker: 3.75"x4.5" 3D Handcrafted Food Fun Themed |  |  |  |  | 24 | 0.48 | 11.52
SS874I | I) Cupcake Fun | 775749180428 | CHINA | 4911.91.0090
Handmade Sticker: 3.75"x4.5" 3D Handcrafted Food Fun Themed |  |  |  |  | 24 | 0.48 | 11.52
SS874J | J) [NAME] | 775749180435 | CHINA | 4911.91.0090
Handmade Sticker: 3.75"x4.5" 3D Handcrafted Food Fun Themed |  |  |  |  | 24 | 0.48 | 11.52
[NAME] | K) Ice Cream Truck! | 775749180459 | CHINA | 4911.91.0090
Paper Craft Essential: 6.5" Designer Cropping Scissors Metal Blade |  |  |  |  | 36 | 0.75 | 27
ST170D | D) Scallop | 775749073379 | CHINA | 8213.00.1020
Paper Craft Essential: 6.5" Designer Cropping Scissors Metal Blade |  |  |  |  | 36 | 0.75 | 27
[NAME] | G) Wave | 775749073393 | CHINA | 8213.00.1020
Paper Craft Essential: 6.5" Designer Cropping Scissors Metal Blade |  |  |  |  | 48 | 0.75 | 36
ST170H | H) ZigZag | 775749073386 | CHINA | 8213.00.1020
Paper Craft Essential: 6.5" Designer Cropping Scissors Metal Blade |  |  |  |  | 48 | 0.75 | 36
ST170I | I) Medium Wave | 775749186321 | CHINA | 8213.00.1020
Paper Craft Essential: Utility Knife Set w/6 Blades |  |  |  |  | 48 | 0.68 | 32.64
ST200 | - | 775749066616 | CHINA | 8211.93.0000
Paper Craft Essential: 7.5"x9" Self-Healing Cutting Mat (B5) w/Grids |  |  |  |  | 36 | 1.48 | 53.28
ST212 | - | 775749117462 | TAIWAN | 3926.90.9990
Paper Craft Essential: 7"x10" Piercing Mat Self-Healing w/Grids |  |  |  |  | 30 | 1.28 | 38.4
ST220 | - | 775749159608 | CHINA | 3921.90.0090
Paper Craft Essential: 13"x13" All-Purpose Craft Mat Self-Healing w/Grids |  |  |  |  | 30 | 1.68 | 50.4
ST222 | - | 775749173659 | CHINA | 3921.90.0090
Paper Craft Essential: 12" (30cm) Paper Trimmer |  |  |  |  | 48 | 1.38 | 66.24
ST286 | - | 775749142402 | CHINA | 8441.10.0000
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
SW460A | A) Gold | 775749101171 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
SW460B | B) Silver | 775749101188 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
[NAME] | C) Blue Steel | 775749101195 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
SW460D | D) Rose Platinum | 775749101201 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
SW460E | E) Green Metallic | 775749150506 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 0 | 0.82 | 0
SW460F | F) White | 775749204117 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 48 | 0.82 | 39.36
[NAME] | G) Purple | 775749211252 | TAIWAN | 9608.20.0010
[NAME]: 1.2mm Fine Point Permanent |  |  |  |  | 0 | 0.82 | 0
SW460H | H) Copper | 775749211269 | TAIWAN | 9608.20.0010
Spreadsheet: 759008d1639227905-data-split-blank-lines-issue-data-split-example
Sheet: Raw Data

A1 | LX | [NAME] | -43000 | -4500 | 1T | 260 |  | 18M | 25M | Y
A2 | LX | [NAME] | -43000 | 0 | 1T | 450 |  | 18M | 25M | Y
A3 | LX | [NAME] | -43000 | 4500 | 1T | 280 |  | 18M | 25M | N
B1.01 | LX | [NAME] 1 | 9500 | -16500 | 1T | 160 |  | 18M | 25M | N
B1.02 | LX | [NAME] 1 | 9500 | -13500 | 1T | 160 |  | 18M | 25M | Y
B1.03 | LX | [NAME] 1 | 9500 | -10500 | 1T | 160 |  | 18M | 25M | Y
B1.04 | LX | [NAME] 1 | 9500 | -7500 | 1T | 160 |  | 18M | 25M | Y
B1.05 | LX | [NAME] 1 | 9500 | -4500 | 1T | 160 |  | 18M | 25M | N
B1.06 | LX | [NAME] 1 | 9500 | -1500 | 1T | 630 |  | 18M | 25M | N
B1.07 | LX | [NAME] 1 | 9500 | 1500 | 1T | 630 |  | 18M | 25M | N
B1.08 | LX | [NAME] 1 | 9500 | 4500 | 1T | 160 |  | 18M | 25M | Y
B1.09 | LX | [NAME] 1 | 9500 | 7500 | 1T | 160 |  | 18M | 25M | N
B1.10 | LX | [NAME] 1 | 9500 | 10500 | 1T | 160 |  | 18M | 25M | Y
B2.01 | LX | [NAME] | 7750 | -16500 | 1T | 160 |  | 18M | 25M | N
B2.02 | LX | [NAME] | 7750 | -13500 | 1T | 160 |  | 18M | 25M | N
B2.03 | LX | [NAME] | 7750 | -10500 | 2T | 160 |  | 18M | 25M | Y
[NAME] | LX | [NAME] | 7750 | -7500 | 2T | 160 |  | 18M | 25M | Y
B2.05 | LX | [NAME] | 7750 | -4500 | 2T | 610 |  | 18M | 25M | Y
[NAME] | LX | [NAME] | 7750 | -1500 | 2T | 500 |  | 18M | 25M | N
Spreadsheet: 567989d1522325300-sumproduct-formula-to-ignore-duplicates-or-return-unique-values-only-book1
Sheet: Sheet2

 |  |  |  | 2017-06-01 00:00:00
 |  |  |  | 2017-06-30 00:00:00
 |  |  | Total in June
 |  |  | Unique ID# in June | 19
 | ID # |  |  |  | Date
 | 1 |  |  |  | 2018-01-29 01:00:00
 | 2 |  |  |  | 2017-09-18 01:00:00
 | 2 |  |  |  | 2017-06-21 01:00:00
 | 4 |  |  |  | 2017-06-06 01:00:00
 | 5 |  |  |  | 2018-01-29 01:00:00
 | 6 |  |  |  | 2017-09-18 01:00:00
 | 7 |  |  |  | 2017-06-01 01:00:00
 | 8 |  |  |  | 2017-06-21 01:00:00
 | 9 |  |  |  | 2017-06-06 01:00:00
 | 2 |  |  |  | 2018-01-29 01:00:00
 | 11 |  |  |  | 2017-09-18 01:00:00
 | 12 |  |  |  | 2017-06-21 01:00:00
 | 13 |  |  |  | 2017-06-06 01:00:00
 | 14 |  |  |  | 2018-01-29 01:00:00
 | 15 |  |  |  | 2017-09-18 01:00:00
 | 7 |  |  |  | 2017-06-01 01:00:00
 | 17 |  |  |  | 2017-06-21 01:00:00
 | 18 |  |  |  | 2017-06-06 01:00:00
 | 7 |  |  |  | 2018-01-29 01:00:00
 | 20 |  |  |  | 2017-09-18 01:00:00
 | 21 |  |  |  | 2017-06-21 01:00:00
 | 21 |  |  |  | 2017-06-06 01:00:00
 | 21 |  |  |  | 2018-01-29 01:00:00
 | 21 |  |  |  | 2017-09-18 01:00:00
 | 22 |  |  |  | 2017-06-01 01:00:00
 | 23 |  |  |  | 2017-06-21 01:00:00
 | 24 |  |  |  | 2017-06-06 01:00:00
 | 25 |  |  |  | 2018-01-29 01:00:00
 | 25 |  |  |  | 2017-09-18 01:00:00
 | 27 |  |  |  | 2017-06-21 01:00:00
 | 28 |  |  |  | 2017-06-06 01:00:00
 | 29 |  |  |  | 2018-01-29 01:00:00
 | 30 |  |  |  | 2017-09-18 01:00:00
 | 31 |  |  |  | 2017-06-01 01:00:00
 | 31 |  |  |  | 2017-06-21 01:00:00
 | 31 |  |  |  | 2017-06-06 01:00:00
 | 34 |  |  |  | 2018-01-29 01:00:00
 | 35 |  |  |  | 2017-09-18 01:00:00
 | 36 |  |  |  | 2017-06-21 01:00:00
 | 37 |  |  |  | 2017-06-06 01:00:00
 | 38 |  |  |  | 2017-06-07 00:00:00
 | 38 |  |  |  | 2017-06-08 00:00:00
Spreadsheet: 215284d1361327113-need-help-with-step-functions-taxi-cost-plot
Sheet: Sheet1

[NAME] | Cost
0.1
0.2
0.25
0.3
0.4
0.5
0.6
0.75
0.8
0.9
1
1.1
1.2
1.25
1.3
1.4
1.5
1.6
1.75
1.8
1.9
2
2.1
2.2
2.25
2.3
2.4
2.5
2.6
2.75
2.8
2.9
Spreadsheet: 33185d1229468967-excel-2000-show-billable-days-icdtp
Sheet: December

 |  |  |  |  |  | 2008-12-31 00:00:00
Last Name | First Name | Where From | R or C | Placement | Release | Billable Days
Nguyen | [NAME] |  | c | 2008-12-16 00:00:00 | 2009-02-14 00:00:00 | 16
Cobb | Dannie |  | c | 2008-12-16 00:00:00 | 2009-02-14 00:00:00 | 16
Cash | [NAME] |  | c | 2008-12-16 00:00:00 | 2009-02-14 00:00:00 | 16
Godinez | [NAME] |  | c | 2008-12-16 00:00:00 | 2009-02-14 00:00:00 | 16
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | Monthly Total | 64
 |  |  |  |  | Daily $77.17 | 4938.88