tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102303d1300257279-need-help-plotting-data-data
Sheet: Sheet1

Month | Sales | Region
1 | 3.059205 | Washington
1 | 3.7422 | Oregon
1 | 4.04077 | California
1 | 14.513077 | Idaho
1 | 99.6032129963145 | Utah
1 | 103.3009109999998 | Arizona
2 | 6.78717 | Nevada
2 | 7.470066 | Montana
2 | 7.655238 | Wyoming
2 | 10.51498 | Idaho
2 | 11.56785 | Colorado
2 | 41.70528510782589 | Utah
3 | -16.51997 | New Mexico
3 | 1.010234 | North Dakota
3 | 1.977882 | South Dakota
3 | 16.51997 | Nebraska
3 | 28.001858 | Oregon
3 | 65.7089867902114 | Utah
4 | 1.679011 | Kansas
4 | 2.546897 | Oklahoma
4 | 2.546922 | Texas
4 | 21.570977 | Missisippi
4 | 27.888428 | Minesotta
4 | 162.2972762099678 | Utah
5 | 1.337478 | Iowa
5 | 2.674942 | Missouri
5 | 2.674955 | South Dakota
5 | 35.3148089999999 | Arkansas
5 | 56.260267 | Washington
5 | 179.18789518416 | Utah
6 | 1.693196 | Iowa
6 | 2.191229 | Nevada
6 | 2.674903 | Lousiana
6 | 22.623581 | Wisconsin
6 | 54.225625 | Illinois
6 | 269.294409139379 | Utah
7 | 2.319335 | Indiana
7 | 2.603869 | Michigan
7 | 2.675011 | Oregon
7 | 25.882013 | Ohio
7 | 64.84018399999991 | Kentucky
7 | 236.5761150056844 | Utah
8 | -34.20647600000001 | Tennessee
8 | 1.337441 | Oklahoma
8 | 2.67483 | South Dakota
8 | 32.057535 | Idaho
8 | 47.438702 | Missisippi
8 | 400.8228233943141 | Utah
9 | -10.045457 | Nevada
9 | 0.768343 | Alabama
9 | 1.522457 | Georgia
9 | 26.422006 | Tennessee
9 | 56.1750609999999 | Florida
9 | 440.4456922796375 | Utah
10 | 1.892431 | Florida
10 | 2.546944 | Washington
10 | 2.674929 | South Carolina
10 | 42.771794 | Missisippi
10 | 64.327907 | North Carolina
10 | 278.3653676359166 | Utah
11 | 1.280651 | Virginia
11 | 1.522485 | Georgia
11 | 2.546947 | Missisippi.
11 | 25.412467 | Kentucky
11 | 71.58457099999981 | Arizona
11 | 362.1147103489258 | Utah
12 | -2.532079 | North Dakota
12 | 1.024476 | Kansas
12 | 1.280606 | Tennessee
12 | 12.948292 | Florida
12 | 14.626391 | Ohio
12 | 153.0438632361165 | Utah
Spreadsheet: 784579d1655833429-need-to-apply-discount-to-a-product-selected-from-drop-down-list-testquote21
Sheet: Products

Item Code | 3Design Products | Price
61412 | 3Design Pro | 6930
83271 | 3Shaper Pro | 1650
81575 | DeepImage Pro | 950
61490 | 3Design Pro upgrade to V10 | 1430
85957 | 3Shaper Pro upgrade to [NAME] | 990
70499 | 3Design Care - 1 year | 590
76430 | 3DesignCare /w Free upgrade | 1400
 | Online 3 day Introduction Training – Three 5 Hour days with a 3 hour follow-up | 1500
 | Online 3 day Advanced Training – Three 5 Hour days with a 3 hour follow-up | 1500
 | Online 2 day 3Shaper Training – Two 5 hour days | 1000
 | Classroom 3 day Introduction Training – Three 8 Hour days | 1500
 | Classroom 3 day Advanced Training – Three 8 Hour days | 1500
 | Classroom 2 day 3Shaper Training – Two 8 Hour days | 1000
 | Training - Online 4 hours | 500
76425 | Training Group Online 2 Hours | 240
61498 | Training Onsite w/ Travel Expenses | 800
75904 | 3Design Atelier | 4400
85956 | 3Design Atelier Update | 1050
61408 | 3Design Designer | 4400
61490 | 3Design Designer Update
85958 | Upgrade 3Design Atelier to Pro | 2530
85959 | Upgrade 3Design Designer to Pro | 2530
85960 | Upgrade Practice to Pro | 6560
85961 | Upgrade Practice to [NAME] | 4050
85962 | Uprade Practice to Designer | 4050
61521 | Replace Dongle | 170
70512 | Replace ID to ID | 170
 | [NAME] | 0.2
 | 5% Discount | 0.05
 | 10% Discount | 0.1
 | 15% Discount | 0.15
 | 20% Discount | 0.2
Spreadsheet: 782185d1653892953-bring-two-different-rows-to-same-line-test
Sheet: Tabelle1

Main Mail adresses | Comparing |  |  | Expected Result
A | BB
B | DD
C | K
D | X
E | V | no matching, stays here
F | HH
G | O
H | P
I | S
J | EE |  |  |  | bringing them in a same lane
K |  |  |  | K
L
M
N
O |  |  |  | O
P |  |  |  | P
R
S |  |  |  | S
T
U
W
Y
Z
X |  |  |  | X
AA
BB |  |  |  | BB
CC
DD |  |  |  | DD
EE |  |  |  | EE
KK
Spreadsheet: 45073d1243864427-using-boolean-to-compile-knowledge-flags
Sheet: USA & Canada

9 | Country | Sent | Received | Location | Contact | Notes
10 | Canada | Yes
11 | USA | Yes
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 0bf090fe-2d0e-47f0-b477-52553a171a15
Sheet: Sheet1

Crimes Against Persons Offenses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Offense Category
by Location, 2011
Location | Total Offenses | Offense Category
 |  | Assault Offenses | Homicide Offenses | Kidnapping/ Abduction | [NAME], Forcible | [NAME], Nonforcible
Total | 1321523 | 1226300 | 3792 | 15310 | 69356 | 6765
Abandoned/Condemned Structure | 16 | 8 | 0 | 2 | 5 | 1
Air/Bus/Train Terminal | 2989 | 2774 | 1 | 23 | 187 | 4
Amusement Park | 57 | 51 | 0 | 0 | 6 | 0
Arena/Stadium/Fairgrounds/Coliseum | 170 | 162 | 0 | 2 | 6 | 0
ATM Separate From Bank | 7 | 4 | 0 | 1 | 2 | 0
Auto Dealership New/Used | 171 | 161 | 0 | 4 | 5 | 1
Bank/Savings and Loan | 1067 | 996 | 2 | 52 | 16 | 1
Bar/Nightclub | 29332 | 28697 | 68 | 74 | 493 | 0
Camp/Campground | 539 | 467 | 0 | 5 | 62 | 5
Church/Synagogue/Temple/Mosque | 2213 | 1901 | 4 | 30 | 270 | 8
Commercial Office Building | 10860 | 10302 | 15 | 79 | 441 | 23
Construction Site | 496 | 480 | 3 | 1 | 12 | 0
[NAME] | 9860 | 9508 | 35 | 154 | 157 | 6
Daycare Facility | 172 | 140 | 0 | 5 | 26 | 1
Department/Discount Store | 7658 | 7322 | 9 | 87 | 235 | 5
Dock/Wharf/Freight/Modal Terminal | 27 | 25 | 0 | 0 | 2 | 0
Drug Store/Doctor's Office/Hospital | 10774 | 9945 | 19 | 64 | 731 | 15
Farm Facility | 41 | 36 | 0 | 0 | 5 | 0
Field/Woods | 8723 | 7049 | 110 | 102 | 1321 | 141
Gambling Facility/Casino/Race Track | 191 | 187 | 0 | 1 | 3 | 0
Government/Public Building | 11227 | 10318 | 10 | 103 | 627 | 169
Grocery/Supermarket | 4528 | 4363 | 5 | 56 | 103 | 1
Highway/Road/Alley/Street | 155560 | 149004 | 843 | 2314 | 3238 | 161
Hotel/Motel/etc. | 15408 | 13224 | 48 | 382 | 1629 | 125
Industrial Site | 241 | 231 | 1 | 1 | 8 | 0
Jail/Prison | 8775 | 8345 | 15 | 20 | 392 | 3
Lake/Waterway | 1047 | 926 | 12 | 3 | 99 | 7
[NAME] | 899 | 869 | 6 | 7 | 17 | 0
Military Installation | 7 | 4 | 0 | 1 | 2 | 0
Park/Playground | 2339 | 2130 | 5 | 28 | 164 | 12
Parking Lot/Garage | 54363 | 52079 | 216 | 660 | 1277 | 131
Rental Storage Facility | 915 | 847 | 1 | 15 | 45 | 7
Residence/Home | 828761 | 762917 | 2111 | 9706 | 48918 | 5109
Rest Area | 752 | 677 | 6 | 5 | 64 | 0
Restaurant | 13334 | 12758 | 15 | 176 | 374 | 11
School/College | 41001 | 38410 | 2 | 173 | 2219 | 197
School – College/University | 1275 | 1155 | 2 | 12 | 106 | 0
School – Elementary/Secondary | 17106 | 15955 | 2 | 59 | 1064 | 26
Service/Gas Station | 6064 | 5847 | 20 | 81 | 113 | 3
Shelter – Mission/Homeless | 147 | 137 | 0 | 0 | 9 | 1
Shopping Mall | 7825 | 7399 | 22 | 83 | 309 | 12
[NAME] (TV, [NAME], etc.) | 5010 | 4692 | 12 | 94 | 209 | 3
[NAME] | 23 | 23 | 0 | 0 | 0 | 0
Other/Unknown | 59553 | 53775 | 172 | 645 | 4385 | 576
Spreadsheet: 844557d1696337228-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results
Sheet: 3

Name | lbs | oz | Oz (total) | Points
 | 545
 | 3213
 | 3213
 | 32314
 | 445
 | 55
 | 5
 | 5
 | 543532
Spreadsheet: 760301d1640129807-display-names-of-individuals-trained-small-sample-copy-tms
Sheet: Shift Bid

 | SUN | MON | TUES | WED | THURS | FRI | SAT
[NAME] | 9.5 | 9.5 | 9.5 | 9.5 | X | X | X
Suzy | X | 9.5 | 9.5 | 9.5 | X | X | 9.5
[NAME] | X | 9.5 | 9.5 | X | 9.5 | 9.5 | X
[NAME] | X | X | X | 9.5 | 9.5 | 9.5 | 9.5
[NAME] | 9.5 | X | X | X | 9.5 | 9.5 | 9.5
Dale | 9.5 | 9.5 | X | X | X | 9.5 | 9.5
Goal: This is the schedule by day. What I want the spreadsheet to do is on the next worksheet (Run_Taxi) pull data from the training list and only display the individuals by day that are Run/Taxi and then the same for the confined space. This is a very small sample of what I am trying to do, but if I can get the overall formula or steered in the right direction, then I can make the overall live spreadsheet do what I want it to do.
Spreadsheet: 456541d1460931054-calculate-portfolio-return-calculate-portfolio-return
Sheet: Portfolio Returns

Name | Code | Highest Turnover Value | 2000-03-07 00:00:00 | 2000-03-08 00:00:00 | 2000-03-09 00:00:00 | 2000-03-10 00:00:00 | 2000-03-13 00:00:00 | 2000-03-14 00:00:00 | 2000-03-15 00:00:00 | 2000-03-16 00:00:00 | 2000-03-17 00:00:00 | 2000-03-20 00:00:00 | 2000-03-21 00:00:00 | 2000-03-22 00:00:00 | 2000-03-23 00:00:00 | 2000-03-24 00:00:00 | 2000-03-27 00:00:00 | 2000-03-28 00:00:00 | 2000-03-29 00:00:00 | 2000-03-30 00:00:00 | 2000-03-31 00:00:00 | 2000-04-03 00:00:00 | 2000-04-04 00:00:00 | 2000-04-05 00:00:00 | 2000-04-06 00:00:00 | 2000-04-07 00:00:00 | 2000-04-10 00:00:00 | 2000-04-11 00:00:00 | 2000-04-12 00:00:00 | 2000-04-13 00:00:00 | 2000-04-14 00:00:00 | 2000-04-17 00:00:00 | 2000-04-18 00:00:00 | 2000-04-24 00:00:00 | 2000-04-25 00:00:00 | 2000-04-26 00:00:00 | 2000-04-27 00:00:00 | 2000-05-01 00:00:00 | 2000-05-02 00:00:00 | 2000-05-03 00:00:00 | 2000-05-04 00:00:00 | 2000-05-05 00:00:00 | 2000-05-08 00:00:00 | 2000-05-09 00:00:00 | 2000-05-10 00:00:00 | 2000-05-11 00:00:00 | 2000-05-12 00:00:00 | 2000-05-15 00:00:00 | 2000-05-17 00:00:00 | 2000-05-18 00:00:00 | 2000-05-19 00:00:00 | 2000-05-22 00:00:00 | 2000-05-23 00:00:00 | 2000-05-24 00:00:00 | 2000-05-25 00:00:00 | 2000-05-26 00:00:00 | 2000-05-29 00:00:00 | 2000-05-30 00:00:00 | 2000-06-01 00:00:00 | 2000-06-02 00:00:00 | 2000-06-05 00:00:00 | 2000-06-06 00:00:00 | 2000-06-07 00:00:00 | 2000-06-08 00:00:00 | 2000-06-12 00:00:00 | 2000-06-13 00:00:00 | 2000-06-14 00:00:00 | 2000-06-15 00:00:00 | 2000-06-16 00:00:00 | 2000-06-19 00:00:00 | 2000-06-20 00:00:00 | 2000-06-21 00:00:00 | 2000-06-22 00:00:00 | 2000-06-23 00:00:00 | 2000-06-26 00:00:00 | 2000-06-27 00:00:00 | 2000-06-28 00:00:00 | 2000-06-29 00:00:00 | 2000-06-30 00:00:00 | 2000-07-03 00:00:00 | 2000-07-04 00:00:00 | 2000-07-05 00:00:00
ABG SUNDAL CLI.HLDG. | N:ASC(P) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURNS
ACTIVE 24 DEAD - 06/10/2006 | N:ACTI(P)
AF GRUPPEN 'A' | N:AFG(P)
AFRICAN PETROLEUM | N:APCL(P)
AGASTI HOLDING | N:AGA(P)
AGR GROUP DEAD - 01/01/15 | N:AGR(P)
AGRESSO DEAD - T/O BY 676348 | 870953(P)
AKASTOR | N:AKA(P)
AKER | N:AKER(P)
AKER BIOMARINE DEAD - 16/01/13 | N:AKBM(P)
AKER DRILLING DEAD - 02/11/11 | N:AKD(P)
AKER FLOATING PRODUCTION DEAD - 02/04/12 | N:AKFP(P)
AKER SOLUTIONS | N:AKSO(P)
[NAME] DEAD - 24/07/12 | N:AIK(P)
ALGETA DEAD - 24/03/14 | N:ALGE(P)
ALLIANSE DEAD - 14/07/06 | N:ALL(P)
ALTINEX | N:ALX(P)
AMERICAN SHIPPING CO. | N:AMSC(P)
AMERSHAM (OSL) DEAD - 30/03/04 | N:AHM(P)
ANDVORD TYBRING GJEDDE DEAD - 21/11/06 | N:ATG(P)
APL DEAD - 24/09/07 | N:APLC(P)
APPTIX | N:APP(P)
A-PRESSEN DEAD - DEAD-31/10/03 | N:APR(P) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ARCHER | N:ARCH(P)
ATEA | N:ATEA(P)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculate return on portfolio:
Spreadsheet: 850701d1701093806-formula-that-returns-a-range-of-non-empty-cells-based-on-conditions-excel-formula-range
Sheet: Sheet1

 | Product A |  |  |  |  |  |  |  |  |  | Product A | Product B | Product C
 |  | Flavor 1 |  |  |  |  |  |  |  |  | Flavor 1 | Flavor 1 | Flavor 1
 |  |  | Recipe text and data |  |  |  |  |  |  |  |  | Flavor 2
 |  |  | Recipe text and data |  |  |  |  |  |  |  |  | Flavor 3
 |  |  |  |  |  |  |  |  |  |  |  | Flavor 4
 | Product B
 |  | Flavor 1
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  | Flavor 2
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  | Flavor 3
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  | Flavor 4
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 | Product C
 |  | Flavor 1
 |  |  | Recipe text and data
 |  |  | Recipe text and data
 |  |  | Recipe text and data
Spreadsheet: 53346d1253219486-merging-two-spreadsheets-test
Sheet: Total

Shippers # | Carrier # | Date | Month | Year | Logs Picked up from | Carrier | Driver/Truck # | Log count on B/L | Log count on yard | # Tagged  logs | Gross BFT | Net BFT | [NAME] | Buyer | Cost | Ticket # | Load | Cost
193 | 107-207 | 2009-01-08 00:00:00 | 1 | 2009 | [NAME], KY | RIPATO | DICKIE | 451 | 450 | 452 | 45648 | 44587 | 83500 | HUSTONVILLE | 45125 | J0900025 | 1
Spreadsheet: 770409d1646053465-calculate-how-many-days-people-have-from-start-date-until-end-date-from-month-to-month-enddate-aligw
Sheet: English

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-09-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  |  |  |  | =IF(D3<=Calcul_9;IF(Calcul_9-D3>30;30;-((Calcul_9-30)-D3)))
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  |  |  |  | =MAX(MIN(IF(OR(D3="";AND(D3<=Calcul_9;D3-Calcul_9>30));30;-((Calcul_9-30)-D3));30);0)
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  |  |  |  | The maximum is 30 days
 | Sigrid | 2020-03-18 00:00:00 |  |  |  |  |  |  | If the end date has arrived then it should be calculated and if it is> but Calculation day then max 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  |  |  |  | Sometimes there is a End date that is more than a month in advance, but the maximum in that case will be 30, exept if it is less then month in atvansed
 | Heida | 2021-09-02 00:00:00
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00
 |  |  |  |  |  |  |  |  | The formula must be such that it works on all parties and also that if the names / dates are changed, the formula works on them
Oktobere |  |  |  |  |  |  |  |  | Red is wrong and is not working
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  |  |  |  | If the End date has passed, an error occurs
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | Sigrid | 2020-03-18 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida
 | Sandra
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | Sigrid | 2020-03-18 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida
 | Sandra
Spreadsheet: 216375d1361743808-linking-sheets-with-data-validation-cells-master_agent_template-2
Sheet: Quote

Week | Date | Name | Type | Product | Source | Bind | Same Day F/U | Mail Quote | 3 Day F/U | 14 Day F/U | Comments
 | 2013-02-22 00:00:00 | [NAME] |  |  | Current Client
1 |  |  | Inbound | NW Auto | Current Client | Y
2 |  |  | Outbound | NW Home | Previous Client | N
3 |  |  |  | NW Dwelling | Walk-In
4 |  |  |  | NW Tenant | The Guide
5 |  |  |  | NW MC | Yellow Pages
 |  |  |  | NW Boat | Internet
 |  |  |  | NW RV | Referral
 |  |  |  | NW Life | Center of Influence
 |  |  |  | NW Annuity | Event
 |  |  |  | NW Funds | Radio
 |  |  |  | NW PUL | Billboard
 |  |  |  | NW IM | Cross Sell
 |  |  |  | NW Bond | Winback
 |  |  |  | NW Comm | Requote
 |  |  |  | NW Farm | OYSR
 |  |  |  | Titan | Premium Change
 |  |  |  | Titan Comm
 |  |  |  | Allrisk Home
 |  |  |  | Allrisk Comm
 |  |  |  | Tapco Home
 |  |  |  | Tapco Comm
 |  |  |  | MAIF
 |  |  |  | AIC
 |  |  |  | Progressive
 |  |  |  | JIA
 |  |  |  | IWIF
 |  |  |  | Assurity
 |  |  |  | Health
 |  |  |  | Universal
 |  |  |  | MAIF Comm
 |  |  |  | MAIF Taxi
 |  |  |  | Commonwealth
 |  |  |  | Comm - Other
 |  |  |  | American Modern
 |  |  |  | Foremost
Spreadsheet: 120058d1314961260-ranking-a-league-table-by-head-to-head-results-nhl-2011-2012-schedule
Sheet: Standing Table

Pos | Team | All Games |  |  |  |  |  |  |  |  |  |  |  | Home |  |  |  |  |  |  |  |  |  | Road
 |  | P | W | L | OT-W | OT-L | SO-W | SO-L | ROW | GF | GA | [NAME] | Pts | P | W | L | OT-W | OT-L | SO-W | SO-L | GF | GA | Pts | P | W | L | OT-W | OT-L | SO-W | SO-L | GF | GA | Pts
1 | Montreal Canadiens | 0 | 0 | 4 | 3 | 1 | 0 | 0 | 0 | 0 | 3 | 13 | 6 | 7 | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 11
2 | [NAME] | 0 | 0 | 4 | 3 | 1 | 1 | 0 | 2 | 0 | 1 | 8 | 7 | 1 | 6 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 4 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 5
3 | Ottawa Senators | 0 | 0 | 4 | 2 | 2 | 0 | 0 | 1 | 0 | 1 | 8 | 8 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 1 | 0 | 4 | 4 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4
4 | Buffalo Sabres | 0 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 6 | 12 | -6 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 7 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3
5 | #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
Spreadsheet: f31da141-31c9-4f2b-8543-863b961ba72b
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
APLB | Test | APLB | Apolipoprotein B, Plasma | Apolipoprotein B, P | Automated Turbidimetric Immunoassay | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection Container/Tube: Lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting-overnight (12-14 hours) 2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | > or =18 years: 48-124 mg/dL Reference values have not been established for patients that are less than 18 years of age. | Monday through Friday; Continuously | 1 day (not reported on Saturday or Sunday) | 4 days | 1 | 82172 |  |  |  |  | Rochester
APLB | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 8 days
APLB | Result | APLB | Apolipoprotein B, P | Apolipoprotein B, P | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1884-6 | Apolipoprotein B:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 91c84c2a-3186-477e-9a77-10a9d7788b21
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | City of Ankeny
NEW AND EXPANDED COMPANIES
Type & Year | Company | Location |  | Product/Service | Function | Approximate Employment | Notes
 |  | City | County
New to the City of Ankeny
2009 | Iowa Soybean Association | Ankeny | Polk | Soybean Marketing and Research | Headquarters | 50 | Constructed 30,000 SF facility.
2009 | Darling International, Inc. | Ankeny | Polk | Analytical Laboratory | Branch Facility | < 10 | Built-out 5,000 SF leased space.
2009 | Pioneer Hi-Bred | Ankeny | Polk | Agriculture Inputs Regulatory Compliance | Branch Facility | 100 | Occupied 60,000 SF custom-built facility.
2008 | Goian North America | Ankeny | Polk | Wind Tower Internals | Division | < 15 | Built-out 15,000 SF leased facility.
Expansions/New Facilities
2012 | [NAME] Des Moines Works | Ankeny | Polk | Agricultural Equipment Manufacturing | Branch Facility | 1900 | Adding 300,000 SF factory building.
2012 | Lauridsen Group, Inc. | Ankeny | Polk | Nutrition Products | Headquarters | 64 | Adding 21,000 SF office/laboratory facility and 16 jobs.
2012 | SYSCO Food Services of Iowa | Ankeny | Polk | Food Service Product Distribution | Branch Facility | 268 | Added 20,000 SF corporate office/customer service center.
2012 | [NAME] | Ankeny | Polk | Food Service Manaufacturer and Distribution | Single Location | 30 | Adding expansion and 15 jobs.
2012 | CJM Financial, Inc. | Ankeny | Polk | Transportation Industry Invoice Factoring | Single Location | 10 | Adding office expansion.
2011 | Accumold | Ankeny | Polk | Plastic Micro-molding | Headquarters | 150 | Added 40,000 SF, doubling facility size and 40+ employees.
2011 | QA Graphics | Ankeny | Polk | Computer Graphics Developer | Single Location | 25 | Built-out 9,000 SF leased facility.
2011 | Perishable Distributors of Iowa, LTD | Ankeny | Polk | Frozen & Refrigerated Distribution | Headquarters | 500 | Added a $7 million expansion and modernization of warehouse/distribution facility.
2008 | Airgas | Ankeny | Polk | Industrial/Medical/ Gas Distribution | Branch Facility | <100 | Added 13,000 SF facility, doubling facility size.
2008 | Praxair | Ankeny | Polk | Corporate Shared Services/ Accessory Distribution | Branch Facility | <200 | Added 11,000 SF to Shared Services space.
2008 | Tone's Spices | Ankeny | Polk | Food Ingredients and Flavorings | Branch Facility | 400 | Added 20 new positions and invested $1 million in new line.
Downsizing/Closing/Mass Layoff
2010 | Harland Clarke | Ankeny | Polk | Financial Document Printing | Branch Facility | 100 | Plant closure October 2010
Ankeny is a community in the Des Moines Metropolitan area.   Access metrowide Business Growth Status information.
Spreadsheet: 826866d1682347929-vlookup-partial-match-vlookup-to-extract-partial-match-col-b
Sheet: Codes

Oton 2 New | Sedan
Oton 3 New | Sedan
Oton MX30 New | SUV
Oton 6 New | Sedan
Oton MX 5 New | SUV
Oton K Series New | Bakkie
Units Ret U/V Pass | Passenger
Units Ret U/V Comm | Commercial
Units Ret U/V Pass Oth | Other
Units Ret U/V Comm Oth | Other
Units W/Sale U/V | Other
Units W/Sale U/V Other | Other
Spreadsheet: 64276d1265144340-combinations-and-permutations-formula-scratch
Sheet: Sheet1

Cum: | 32 | 16 | 8 | 4 | 2
Count: | 2 | 2 | 2 | 2 | 2
 | Wireless | eMerchant | CustSvc | DebitAcc | Annual
 | 0 | 0 | 0 | 0 | 0
 | 25 | 10 | 10 | 5 | 79
# | Permutations
1 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 79
3 | 0 | 0 | 0 | 5 | 0
4 | 0 | 0 | 0 | 5 | 79
5 | 0 | 0 | 10 | 0 | 0
6 | 0 | 0 | 10 | 0 | 79
7 | 0 | 0 | 10 | 5 | 0
8 | 0 | 0 | 10 | 5 | 79
9 | 0 | 10 | 0 | 0 | 0
10 | 0 | 10 | 0 | 0 | 79
11 | 0 | 10 | 0 | 5 | 0
12 | 0 | 10 | 0 | 5 | 79
13 | 0 | 10 | 10 | 0 | 0
14 | 0 | 10 | 10 | 0 | 79
15 | 0 | 10 | 10 | 5 | 0
16 | 0 | 10 | 10 | 5 | 79
17 | 25 | 0 | 0 | 0 | 0
18 | 25 | 0 | 0 | 0 | 79
19 | 25 | 0 | 0 | 5 | 0
20 | 25 | 0 | 0 | 5 | 79
21 | 25 | 0 | 10 | 0 | 0
22 | 25 | 0 | 10 | 0 | 79
23 | 25 | 0 | 10 | 5 | 0
24 | 25 | 0 | 10 | 5 | 79
25 | 25 | 10 | 0 | 0 | 0
26 | 25 | 10 | 0 | 0 | 79
27 | 25 | 10 | 0 | 5 | 0
28 | 25 | 10 | 0 | 5 | 79
29 | 25 | 10 | 10 | 0 | 0
30 | 25 | 10 | 10 | 0 | 79
31 | 25 | 10 | 10 | 5 | 0
32 | 25 | 10 | 10 | 5 | 79
Spreadsheet: 44741d1243509482-match-two-columns-to-data-table-test-file-rebate
Sheet: Volumes

Product Code | Product Desc | Rebate Product | Depot | Region | Market | Volume | Sales Value | Sales Unit | Cost Value | Unit Cost | Margin (£) | Marging (ppl) | Rebate Value
004 | Gasoil | Gasoil | 001 | Scotland | RNC | 200 | 190 | 95 | 76.5 | 38.25 | 113.5 | 56.75
 |  | BIODIE | 001
 |  | Derv | 001
Spreadsheet: 47915d1247086374-invoice-sheet-need-a-formula-to-add-total-invoices-up-based-on-supplier-codes-please-summary
Sheet: Summary

Expenditure Heading | Total Budget | Total Budget Remaining
IT Equipment | 10 | 8
Other Equipment | 10 | 8
Furniture & Fittings | 10 | 8
Property | 10 | 8
Vehicles | 10 | 8
Printing & Stationery | 10 | 8
Schools Consumables | 10 | 8
European & Domestic Funds | 10 | 8
Catering & Retail | 10 | 8
Professional Services | 10 | 8
Travel & Subsistence - Accom | 10 | 8
Travel & Subsistence - Other | 10 | 8
Marketing | 10 | 8
Exams | 10 | 8
Other | 10 | 8
Franchise Expenditure / Subcontractor | 10 | 8
Access Fund/Student Support | 10 | 8
Direct Client & Student Exps | 10 | 8
He Validation Costs | 10 | 8
Staff Development | 10 | 8
Depreciation | 10 | 8
Amortisation | 10 | 8
Interest & Charges | 10 | 8
Contracts | 10 | 8
Default Purchases | 10 | 8
Inter Company | 10 | 8
Totals | 260 | 208