tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2aba0b59-0996-49b6-b76d-832a94a596f3
Sheet: Sheet1

Country Statistical Tables for Sub-Saharan Africa (SSA)
This Contents sheet provides an explanation of each worksheet in the file.
Users are encouraged to read Food Security Assessment (FSA), which discusses global food
security issues and estimates food gaps for 70 lower income countries. The report was published in
May 2005 and is available at http://www.ers.usda.gov/Publications/GFA16/ .
The report estimates the number of hungry people to evaluate the progress made toward the
World Food Summit goal of reducing the number of hungry people by half by 2015.
Factors affecting food security, such as food production, imports and food aid are discussed.
The tables and charts provided in this file are not found in the report.
This file contains:
- 37 country statistical sheets
Each country is identified by its 2-digit country code (the country code key is listed below).
There are 3 Central African, 9 East African, 8 Southern African, and 17 West African countries.
Each country sheet contains two tables and one chart with data relevant to food security.
Table "Food availability and food gaps" contains 9 years of historical data and estimates/projections
for 2004, 2009, and 2014. Grain production data are extracted from the Production, Supply and
Demand database of USDA as of October 2004. The 2004 figure of grain production is actual data.
Root production data are from FAOSTAT, available through 2003, then converted into grain equivalent.
Commercial grain imports are from FAO and Food aid data from WFP. Total food availability is a
calculated amount of all food available, converted into grain equivalent. For information on the
definitions and method of calculation of food gaps please see "Appendix 1: Methodology" in the FSA
report. The chart "Cereal and Non-cereal Imports" plots 10 years of FAO data. The table
"Import share of domestic supply" contrasts average 1992-93 commodity import shares with 2001-02
shares, all of which are presented in separate sheets as described below for all 70 countries included
in the study.
- Sub-Saharan Africa sheet
This sheet contains "Food availability and food gaps" data aggregated for all Sub-Saharan Africa, a
chart on food aid effectiveness, a chart and a table on food import dependency in the region, and a
text box, summarizing the trend of food security in the region.
Country code key:
Central Africa
CM = Cameroon
CF = Central African Republic
ZR = Congo, Democratic Republic (formerly Zaire)
East Africa
BI = Burundi
ER = Eritrea
ET = Ethiopia
KE = Kenya
RW = Rwanda
SO = Somalia
SD = Sudan
TZ = Tanzania
UG = Uganda
Southern Africa
AO = Angola
LS = [NAME]
MG = Madagascar
MW = [NAME]
MZ = Mozambique
SW = Swaziland
ZM = Zambia
ZW = Zimbabwe
West Africa
BJ = Benin
BF = Burkina Faso
CV = Cape Verde
TD = Chad
CI = Côte d'Ivoire
GM = Gambia
GH = Ghana
GN = Guinea
GW = Guinea-Bissau
LR = Liberia
ML = Mali
MR = Mauritania
NE = Niger
NG = Nigeria
SN = Senegal
SL = Sierra Leone
TG = Togo
Spreadsheet: 71869d1272556926-lookup-range-between-2-numbers-and-3rd-value-zipcode2
Sheet: Hoja1

Zip | Street Name | Start | End |  |  | Street |  | Zip
1426 | 3 DE FEBRERO | 701 | 1800 |  |  | ACEVEDO EDUARDO | 3000 | #N/A
1428 | 3 DE FEBRERO | 1801 | 2800
1429 | 3 DE FEBRERO | 2801 | 4100
1429 | 3 DE FEBRERO | 4101 | 4300
1429 | 3 DE FEBRERO | 4301 | 4900
1064 | 5 DE JULIO | 401 | 500
1073 | 9 DE JULIO AVENIDA | 1 | 2
1408 | ACASSUSO | 5101 | 6400
1408 | ACASSUSO | 6401 | 7300
1440 | ACASSUSO | 7301 | 7700
1414 | ACEVEDO | 1 | 1200
1405 | ACEVEDO EDUARDO | 1 | 200
1405 | ACEVEDO EDUARDO | 201 | 700
1405 | ACEVEDO EDUARDO (VER JUANA DE IBARBOUROU) | 1001 | 1100
1427 | ACHA MARIANO | 901 | 1330
1430 | ACHA MARIANO | 1331 | 2600
1430 | ACHA MARIANO | 2601 | 3900
1430 | ACHA MARIANO | 3901 | 5000
1430 | 14 DE JULIO | 1501 | 1700
1130 | 15 DE NOVIEMBRE DE 1889 | 1101 | 1800
1261 | 15 DE NOVIEMBRE DE 1889 | 1801 | 2700
1417 | 2 DE ABRIL | 3101 | 3200
1439 | 2 DE ABRIL DE 1982 | 6401 | 7000
1431 | 20 DE FEBRERO | 5601 | 6100
1155 | 20 DE SEPTIEMBRE | 1 | 100
1155 | 20 DE SEPTIEMBRE | 201 | 400
1170 | 24 DE NOVIEMBRE | 1 | 500
1224 | 24 DE NOVIEMBRE | 501 | 1200
1242 | 24 DE NOVIEMBRE | 1201 | 2300
1002 | 25 DE MAYO | 1 | 800
1437 | 27 DE FEBRERO AVENIDA | 5001 | 6300
1437 | 27 DE FEBRERO AVENIDA | 6301 | 7000
1439 | 27 DE FEBRERO AVENIDA | 1 | 2
Spreadsheet: mary_hain__25835__3rd qtr - 1999 FERC
Sheet: Exchange

 | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | Total
Exchange Receipt
Hinson Power Company | 0 | 0 | 44640
Illinois Power Company | 67200 | 70400 | 0
[NAME] | 0 | 2976 | 2880
Washington Water & Power | 0 | 0 | 0
Total
Exchange Delivery
Hinson Power Company | 0 | 0 | -44640
Illinois Power Company | 0 | 0 | 0
[NAME] | 0 | -2976 | -2880
Washington Water & Power | 0 | 0 | 0
Total
Spreadsheet: 178199d1346696866-countif-sample
Sheet: Sheet1

Name | Check in | # of Rooms
Person A | 2012-09-03 00:00:00 | 1
Person B | 2012-09-04 00:00:00 | 2
Person C | 2012-09-04 00:00:00 | 1
Person D | 2012-09-06 00:00:00 | 1
Person E | 2012-09-07 00:00:00 | 1
Person E | 2012-09-07 00:00:00 | 0
Person F | 2012-09-07 00:00:00 | 1
Person G | 2012-09-10 00:00:00 | 2
Person H | 2012-09-10 00:00:00 | 2
Person I | 2012-09-12 00:00:00 | 1
Spreadsheet: 0c33e48b-a755-4561-8664-c9e8bf3e635f
Sheet: Sheet1

LITA INTEREST GROUP RENEWALS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Established | Last Renewal | Next Renewal | Notes
BIGWIG | 2005 | 2008 | 2011
E-Resources Management | 2005 | 2011 | 2014
Internet Resources and Services | 1995 | 2011 | 2014
Standards | 2002 | 2009 | 2012
Authority Control in the Online Environment (LITA/ALCTS) | 1985 | 2009 | 2012
[NAME] and Virtualization Interest Group | 2010 |  | 2013
Distance Learning | 1997 | 2009 | 2012
Drupal Interest Group | 2009 | 2009 | 2012
Emerging Technologies | 1986 | 2009 | 2012
Open Source Systems | 2000 | 2010 | 2013
Public Libraries Technology | 2006 | 2009 | 2012
Digital Library Technologies | 2001 | 2007 | 2010
Heads of Library Technology | 2001 | 2010 | 2013
Imagineering | 1989 | 2012 | 2015
[NAME] | 2007 | 2012 | 2015
[NAME] (LITA/ALCTS) | 1990 | 2010 | 2013
Mobile Computing | 2009 | 2012 | 2015
Next Generation Catalog | 2007 |  | 2013
[NAME] | 2010 |  | 2013
Transliteracy IG | 2010 |  | 2013
LITA/ALCTS Linked Library Data Interest Group | 2011 |  | 2014
Industry and Technology | 2011 |  | 2014
Search Engine optimization IG | 2012 |  | 2015
ALCTS/LITA IG: Library Code Year | 2012 |  | 2015
Game Making | 2012 |  | 2015
Internet Portals | 2002 |  | disbanded 2006
Electronic Publishing/Electronic Journals | 1997 | 2003 | disbanded 2006
Human/Machine Interface | 1986 | 2005 | Disbanded 2009
Personal Computing | 1986 | 2003 | disbanded 2006
Secure Systems and Services | 1995 | 2003 | disbanded 2006
Technical Services Workstation (LITA/ALCTS) | 1988 | 2003 | disbanded 2006
Technology and the Arts | 1985 | 2003 | disbanded 2006
Topic Maps | 2005 |  | Disbanded 2009
RFID | 2005 | 2011 | Disbanded 2011
JPEG 2000 in Archives and Libraries | 2005 | 2008 | Disbanded 2011
Spreadsheet: 878766d1726048045-add-price-ranges-to-a-working-index-match-formula-index-match
Sheet: Sheet1

Item | Maj | Cat | Price | Code | IF using price too |  |  |  |  | Maj | Cat | Price | Code
0243 | ACC | 110 | 81 |  |  |  |  |  |  | ACC | 110 | <100 | A
0097 | ACC | 110 | 150 |  | Should return B |  |  |  |  | ACC | 110 | 100-199.99 | B
3318 | ACC | 110 | 84 |  |  |  |  |  |  | ACC | 110 | 200+ | C
4481 | ACC | 110 | 225 |  | Should return C |  |  |  |  | ARMS | 110 |  | A
3149 | ACC | 110 | 230 |  | Should return C |  |  |  |  | ARMS | 110 | 60-99.99 | E
4477 | ACC | 110 | 235 |  | Should return C |  |  |  |  | ARMS | 110 | 100+ | H
9387 | ACC | 110 | 99 |  |  |  |  |  |  | ARMS | 130 |  | A
5816 | ACC | 110 | 115 |  | Should return B |  |  |  |  | ARRO | 110 |  | D
6702 | ARMS | 110 | 42 |  |  |  |  |  |  | ARRO | 140 |  | J
6669 | ARMS | 130 | 127 |  |  |  |  |  |  | ATLA | 110 |  | E
6668 | ARMS | 110 | 65 |  | Should return E |  |  |  |  | ATLA | 130 |  | F
6662 | ARMS | 110 | 115 |  | Should return H
6716 | ARMS | 110 | 131 |  | Should return H
S261 | ARRO | 110 | 66
S244 | ARRO | 110 | 75
S257 | ARRO | 140 | 83
0090 | ATLA | 110 | 49
0070 | ATLA | 130 | 44
Spreadsheet: dbbfe356-85d6-4fac-9610-e8e4f0c23b03
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4495 | 6515 | [NAME] | Laurence | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:07:51
4495 | 10367 | [NAME] | Webb | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:09:30
4495 | 15247 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | [NAME]
Spreadsheet: 845009d1696586549-filter-using-multiple-rows-and-ranges-844994d1696577715-filter-using-multiple-rows-and-ranges-20231006_o365_-example_data-2-
Sheet: Sheet1

Main datasheet |  |  |  |  |  |  | Selection criteria |  |  |  |  |  | Desired output
Dataset | Hole_ID | Depth_From | Depth_To | UniqueID | Other Data columns |  | Interval | Hole_ID | Depth_From | Depth_To |  | Interval | Dataset | Hole_ID | Depth_From | Depth_To | UniqueID | Other Data columns
NA | Test_001 | 0 | 1 | #0001 | … |  | A | Test_001 | 2 | 6 |  | A | NA | Test_001 | 2 | 3 | #0003 | …
NA | Test_001 | 1 | 2 | #0002 | … |  | B | Test_002 | 6 | 12 |  | A | NA | Test_001 | 3 | 4 | #0004 | …
NA | Test_001 | 2 | 3 | #0003 | … |  | C | Test_003 | 4 | 7 |  | A | NA | Test_001 | 4 | 5 | #0005 | …
NA | Test_001 | 3 | 4 | #0004 | … |  | D | Test_003 | 10 | 13 |  | A | NA | Test_001 | 5 | 6 | #0006 | …
NA | Test_001 | 4 | 5 | #0005 | … |  |  |  |  |  |  | B | NA | Test_002 | 6 | 7 | #0012 | …
NA | Test_001 | 5 | 6 | #0006 | … |  |  |  |  |  |  | B | NA | Test_002 | 7 | 8 | #0013 | …
NA | Test_001 | 6 | 7 | #0007 | … |  |  |  |  |  |  | B | NA | Test_002 | 8 | 9 | #0014 | …
NA | Test_001 | 7 | 8 | #0008 | … |  |  |  |  |  |  | B | NA | Test_002 | 9 | 10 | #0015 | …
NA | Test_001 | 8 | 9 | #0009 | … |  |  |  |  |  |  | B | NA | Test_002 | 10 | 11 | #0016 | …
NA | Test_001 | 9 | 10 | #0010 | … |  |  |  |  |  |  | B | NA | Test_002 | 11 | 12 | #0017 | …
NA | Test_002 | 5 | 6 | #0011 | … |  |  |  |  |  |  | C | NA | Test_003 | 4 | 5 | #0024 | …
NA | Test_002 | 6 | 7 | #0012 | … |  |  |  |  |  |  | C | NA | Test_003 | 5 | 6 | #0025 | …
NA | Test_002 | 7 | 8 | #0013 | … |  |  |  |  |  |  | C | NA | Test_003 | 6 | 7 | #0026 | …
NA | Test_002 | 8 | 9 | #0014 | … |  |  |  |  |  |  | D | NA | Test_003 | 10 | 11 | #0030 | …
NA | Test_002 | 9 | 10 | #0015 | … |  |  |  |  |  |  | D | NA | Test_003 | 11 | 12 | #0031 | …
NA | Test_002 | 10 | 11 | #0016 | … |  |  |  |  |  |  | D | NA | Test_003 | 12 | 13 | #0032 | …
NA | Test_002 | 11 | 12 | #0017 | …
NA | Test_002 | 12 | 13 | #0018 | …
NA | Test_002 | 13 | 14 | #0019 | …
NA | Test_003 | 0 | 1 | #0020 | …
NA | Test_003 | 1 | 2 | #0021 | …
NA | Test_003 | 2 | 3 | #0022 | …
NA | Test_003 | 3 | 4 | #0023 | …
NA | Test_003 | 4 | 5 | #0024 | …
NA | Test_003 | 5 | 6 | #0025 | …
NA | Test_003 | 6 | 7 | #0026 | …
NA | Test_003 | 7 | 8 | #0027 | …
NA | Test_003 | 8 | 9 | #0028 | …
NA | Test_003 | 9 | 10 | #0029 | …
NA | Test_003 | 10 | 11 | #0030 | …
NA | Test_003 | 11 | 12 | #0031 | …
NA | Test_003 | 12 | 13 | #0032 | …
NA | Test_003 | 13 | 14 | #0033 | …
Spreadsheet: 874465d1721059838-assigning-a-number-to-a-name-no-tap-bowling-scores-template
Sheet: No Tap Sheets

 | NO TAP & DRAW 4
LANE |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 6 | Men |  |  |  |  | Women
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $ | $ | # | NAME |  | SCORE | # | NAME |  | SCORE | $
1 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 41
LANE |  | 7 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 8
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 9 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 10
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 11 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 12
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 13 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 14
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 16
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 17 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 18
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 19 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 20
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 21 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 22
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 23 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 24
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
Spreadsheet: sally_beck__33745__June Delainey Report
Sheet: Summary Expense Info

TOT_OPS_EXPENSES |  |  |  | ACTUAL | PLAN2000 | 2000-06-01 00:00:00 |  | PLAN2000 |  | M.MTD |  |  | ACTUAL
 |  |  |  |  | M.YTD | ena |  | TOTAL_HEADCOUNT
 | ENRON NORTH AMERICA - ENERGY OPERATIONS
 | YTD BUDGET COMPARISON
 | AS OF JUNE 2000
 |  | YTD EXPENSES AS OF JUNE 2000 |  |  |  |  |  | APRIL HEADCOUNT
 |  | Group | Owner | Actual | Plan | Actual Greater than / (Less than)  Plan |  | Actual | Plan | Actual Greater than / (Less than)  Plan | Adj Plan | Actual Greater than / (Less than) Adj Plan
 | Support Groups
 |  | Natural Gas Operations | Price | 8210339 | 7904210.191
[NAME] |  | Logistics | Superty | 2957889 | 2792397.5775
NAT_GAS |  | Natural Gas | Price | 5252450 | 5111812.6135
TX_NAT_GAS |  | Gas Assets Operations | Herod | 2791515 | 2662822.666320833
PWR |  | Power Operations | Albrecht / Reeves | 1557534 | 1650260.725
FINANC |  | Risk Mgmt & Controls | Moscoso / Perez | 421129 | 513599.303
MERCH_ASSET |  | Merchant Assets | Hall | 364321 | 613134
EQUITIES |  | Financial Products Operations | Glover | 780759 | 947579
EMRG_PRDTS |  | Emerging Products Operations | Earnest / Hall | 542084 | 914791.0161666665
ENRON_ONLINE |  | EOL Product Controls | [NAME] | 748398 | 1005703.25
GBL_GRP |  | Global Data Group | Solmonson | 1556342 | 1825072.61895
0120236.TOTAL |  | Global Facilities on Co 012 |  | -354 | 0
 |  | Global Data Group | Solmonson | 1555988 | 1825072.61895
ENT_ACT |  | Strategic Operations |  | 780125 | 972694.8319999999
4442788.TOTAL |  | Energy Ops Calgary (a) | [NAME] | 618678 | 559600
ENG_OP_MGT |  | Energy Ops Mgmt | Beck | 2384577 | 2790324
CAP_WO_RC |  | Capital WO RC's | Beck | 1 | 0
 |  | Management and Controls | Beck | 3585832 | 4276618.135
4131805.TOTAL |  | Less:  Non-ENA Billings |  | -944192 | -1276642.277886417 |  |  | 0 | 0 |  | 0
 |  | Total Energy Operations Expenses within ENA
 |  | check:
ENGY_OPS_W_ONLINETRD |  | ENGY_OPS_W_ONLINETRD
Spreadsheet: 878441d1725527213-unique-text-join-and-transpose-by-formula-as-well-as-by-code-text-join-and-transpose-windknife
Sheet: Expected Result

Date | Particulars |  |  |  |  | Text Join |  |  | Windknife
2024-06-16 00:00:00 | [NAME],Greenland
 | Pistachio Glues
2024-06-16 00:00:00 | Wold Never Goes Wrong
 | [NAME]
2024-06-16 00:00:00 | Google Inc
 | Rusted Pure Base
2024-06-17 00:00:00 | Amazon Coporation
 | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
 | Pistachio Glues
2024-06-17 00:00:00 | [NAME] LLC
 | Fever
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | Wold Vision Pvt Ltd
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | New Kalakriti
 | Pills & Lassi
2024-06-20 00:00:00 | [NAME]
 | Addons
 | Harder
2024-06-20 00:00:00 | Hindustan Lever Ltd
 | Fever
 | Pola Ship
2024-06-21 00:00:00 | Overseas Market
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-23 00:00:00 | Hindustan Lever Ltd
 | Pills & Lassi
 | Pills & Lassi
2024-06-30 00:00:00 | Reliance Telecom
 | Pure Base
 | Pola Ship
2024-06-30 00:00:00 | Hindustan Lever Ltd
 | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-03 00:00:00 | Alzazira Corporation Ltd
 | Pills & Lassi
 | Rusted Pure Base
2024-07-03 00:00:00 | [NAME]
 | Rusted Pure Base
 | Rusted Pure Base
 | Rusted Pola Ship
 | Rusted Pola Ship
 | Rusted Pola Ship
2024-07-03 00:00:00 | Botanical Garden
 | Fever
 | Pola Ship
 | Pola Ship
2024-07-07 00:00:00 | Plast Product
 | BONE Sheet
 | Rusted BONE Sheet
2024-07-08 00:00:00 | Alzazira Corporation Ltd
 | Rusted Lock Film
 | Pills & Lassi
2024-07-10 00:00:00 | Alzazira Corporation Ltd
 | Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown
 | Rusted Pola Ship
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles
 | Pola Ship
2024-07-28 00:00:00 | The Kingdom of Plant of Apes
 | Pills & Lassi
 | Pills & Lassi
Spreadsheet: 79834d1280073832-if-or-cells-contain-specific-text-display-results-in-multiple-areas-testsheet2
Sheet: Example Table

 | Raw Data |  |  | Input Field |  |  | Output
 | Code | Name |  | Job Code | B14 |  | Name | Current Jobs | Job Code | Job Code2 | Job Code3
 | B14 | [NAME] |  | Job Code | [NAME] |  | [NAME] | 2 | B14 | B16
 | B15 | [NAME] |  | Job Code | B16 |  | [NAME] | 1 | B14
 | B16 | [NAME] |  |  |  |  | [NAME] | 3 | B14 | [NAME] | B16
 | B14 | [NAME]
 | B17 | [NAME]
 | B18 | [NAME]
 | B14 | [NAME]
 | B16 | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 103500d1301266236-formula-to-identify-a-title-and-return-the-contents-of-the-group-recipelookup
Sheet: Sheet2

recipe 1 | ingridients 1.1 | 90001
recipe 1 | ingridients 1.2 | 90002
recipe 1 | ingridients 1.3 | 90003
recipe 1 | ingridients 1.4 | 90004
recipe 1 | ingridients 1.5 | 90005
recipe 1 | ingridients 1.6 | 90006
recipe 1 | ingridients 1.7 | 90007
recipe 1 | ingridients 1.8 | 90008
recipe 1 | ingridients 1.9 | 90009
recipe 2 | ingridients 2.1
recipe 2 | ingridients 2.2
recipe 2 | ingridients 2.3
recipe 3 | ingridients 3.1
recipe 3 | ingridients 3.2
recipe 3 | ingridients 3.3
recipe 3 | ingridients 3.4
recipe 3 | ingridients 3.5
recipe 3 | ingridients 3.6
recipe 3 | ingridients 3.7
recipe 3 | ingridients 3.8
recipe 3 | ingridients 3.9
recipe 3 | ingridients 3.10
recipe 3 | ingridients 3.11
recipe 4 | ingridients 4.1 | 10024
recipe 4 | ingridients 4.2 | 10025
recipe 4 | ingridients 4.3 | 10026
recipe 4 | ingridients 4.4 | 10027
recipe 4 | ingridients 4.5 | 10028
recipe 4 | ingridients 4.6 | 10029
recipe 4 | ingridients 4.7 | 10030
recipe 4 | ingridients 4.8 | 10031
recipe 5 | ingridients 4.9
recipe 5 | ingridients 5.1
recipe 5 | ingridients 5.2
recipe 6 | ingridients 6.1
recipe 6 | ingridients 6.2
recipe 6 | ingridients 6.3
recipe 6 | ingridients 6.4
recipe 6 | ingridients 6.5
recipe 6 | ingridients 6.6
recipe 6 | ingridients 6.7
recipe 6 | ingridients 6.8
Spreadsheet: kate_symes__18297__Variances
Sheet: April

Date | Buy/Sell | Del Pt | Deal # | Total Hrs | Total MWH | Rate | Problem
4/1 | Buy | SP-15 | 566424.1 |  | 341 | 125 | Rate should be $125.73 per [NAME]'s schedule
4/1 | Buy | Nepool | 302293.1 |  | 625 | 34 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings
4/1 | Buy | Nepool | 399863.1 |  | 600 | 24.25 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings
4/1 | Sell | Nepool | 302297.1 |  | 625 | 35 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings
4/2 | Buy | SP-15 | 566391.1 | off peak | 416 | 125.73 | Total MWh for 566391.1 and 566426.1 off peak should be 599 per [NAME]'s schedule
4/2 | Buy | SP-15 | 566426.1 | off peak | 142.8 | 125 | Rate should be $125.73 per [NAME]'s schedule
4/2 | Buy | SP-15 | 566391.1 | on peak | 96 | 220.17 | Total MWh for 566391.1 and 566426.1 on peak should be 331 per [NAME]'s schedule
4/2 | Buy | SP-15 | 566426.1 | on peak | 252.46 | 220 | Rate should be $220.17 per [NAME]'s schedule
4/8 | Buy | SP-15 | 573785.1 |  | 115 | 80 | Real time sheet sent to EES has 35 @ $80
4/8 | Buy | SP-15 | 576512.1 |  | 17 | 80 | Real time sheet sent to EES has 35 @ $80
4/9 | Buy | SP-15 | 576512.1 |  | 31 | 80 | Real time sheet sent to EES has 48 @ $80
4/9 | Sell | SP-15 | 573862.1 |  | 0.2 | 107 | EES not showing this deal
4/11 | Buy | SP-15 | 578856.1 |  | 21 | 150 | EES not showing this deal
Spreadsheet: 203487d1357140288-unit-price-cost-price-with-condition-date-price-and-stock-book1
Sheet: Sheet1

TABLE SALES
DATE | ITEM | QTY | UNIT PRICE | PROFIT
2013-01-10 00:00:00 | TABLE | 3 | 20000 | ???
2013-01-11 00:00:00 | TABLE | 1 | 20000 | ???
INVENTORY |  |  |  | TABLE PURCHASE
ITEM | STOCK |  |  | DATE | ITEM | QTY | COST PRICE
TABLE | 6 |  |  | 2013-01-01 00:00:00 | TABLE | 3 | 10000
CHAIR | 1 |  |  | 2013-01-02 00:00:00 | TABLE | 3 | 12000
Spreadsheet: 6c711dbe-317c-4eca-b1f2-07d05108cd9b
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/02/2013 | Wrestling | Gardner-Webb (UVA Duals) | 12:00 AM | W, 24-14
11/02/2013 | Wrestling | [NAME] (UVA Duals) | 12:00 AM | W, 46-0
11/02/2013 | Wrestling | at Virginia (UVA Duals) | 12:00 AM | L, 41-6
11/09/2013 | Wrestling | at Mercyhurst Laker Open | 12:00 AM | Results
11/15/2013 | Wrestling | at Iowa State | 12:00 AM | L, 22-12
11/15/2013 | Wrestling | Midland | 12:00 AM | W, 34-6
11/16/2013 | Wrestling | [NAME] (Ames, Iowa) | 12:00 AM | Results
11/23/2013 | Wrestling | Navy Classic | 12:00 AM | 9th/14
12/07/2013 | Wrestling | Drexel ([NAME]) | 12:00 AM | W, 25-8
12/07/2013 | Wrestling | VMI ([NAME]) | 12:00 AM | W, 38-3
12/07/2013 | Wrestling | [NAME] ([NAME]) | 12:00 AM | W, 27-3
12/08/2013 | Wrestling | at Indiana ([NAME]) | 12:00 AM | W, 22-21
12/08/2013 | Wrestling | Northern Colorado ([NAME]) | 12:00 AM | W, 35-4
12/22/2013 | Wrestling | Tournament of Champions (Reno, Nev.) | 12:00 AM | 5th/25
01/04/2014 | Wrestling | Lock Haven | 12:00 AM | W, 18-12
01/18/2014 | Wrestling | Oklahoma State | 12:00 AM | L, 30-6
02/01/2014 | Wrestling | Pittsburgh | 12:00 AM | L, 33-6
02/06/2014 | Wrestling | Oklahoma | 12:00 AM | L, 19-15
02/07/2014 | Wrestling | [NAME] | 12:00 AM | W, 45-0
02/14/2014 | Wrestling | Clarion University (Beauty and Beast) | 12:00 AM | W, 28-7
02/16/2014 | Wrestling | at Ohio | 12:00 AM | L, 26-19
[NAME] | Wrestling | at Edinboro | 12:00 AM | L, 29-6
03/08/2014 | Wrestling | Big 12 Championships (Norman, Okla.) | 04:00 PM | 4 p.m.
03/20/2014 | Wrestling | at NCAA Championships (Oklahoma City) | 12:00 AM | All Day
03/21/2014 | Wrestling | at NCAA Championships (Oklahoma City) | 12:00 AM | TBD
[NAME] | Wrestling | at NCAA Championships (Oklahoma City) | 12:00 AM | TBD
Spreadsheet: 219283d1362698243-expanding-sum-range-when-using-sumifs-function-for-sales-tracking-spreadsheet-sales-totals-sheet
Sheet: Reference Sheet

Products |  | January |  | February
 |  | revenue | sites | revenue | sites
a
b
c
d
e
f
g
h
i
j
Division
US
CNW
LatAm
Europe
Vintage
Asia