tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0907be3c-9fd1-4f86-9fd8-fc302ab79566
Sheet: Table VI.3

Table VI.3 الجدول
Total Waste Generation (thousand tons)
مجموع النفايات المولدة ([NAME])
 | 2005 | 2007 | 2008 | 2009
Bahrain | … | … | … | … | البحرين
Egypt | 183,000a/, 1 | 50,859b/, 2 | … | … | مصر
Iraq | 5,446b/, 3 | … | … | 49c/, 4 | العراق
Jordan | … | … | … | … | الأردن
Kuwait | 6,093b/, 5 | 8,160b/, 5 | 6,596b/, 5 | 5,330b/, 5 | الكويت
Lebanon | … | … | … | … | لبنان
Oman | … | … | … | … | عمان
Palestine | 996b/, 6 | … | 1,913b/ | 1,785b/ | فلسطين
Qatar | … | 3,103b/ | 2,879b/ | 3,007b/ | قطر
Saudi Arabia | … | … | … | … | المملكة العربية السعودية
The Sudan | … | … | … | … | السودان
The Syrian Arab Republic | … | … | … | … | الجمهورية العربية السورية
The United Arab Emirates | … | … | … | 32,735b/, 7 | الإمارات العربية المتحدة
Yemen | 3,183d/ | 3,618d/ | 3,422b/, 8 | 3,525b/, 8 | اليمن
Sources: | a/ | Environment Statistical Report 2007, CAPMAS, August 2009.
 | [NAME] | UNSD/UNEP Environment Questionnaire on Environment Statistics 2010.
 | c/ | Environmental Statistics in Iraq Report 2009, COSIT, 2010.
 | d/ | Central Statistical Organization reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
Notes: | 1 | Includes waste generated from hospitals for the amount of 110,000 thousand tons.
 | 2 | Waste generated from agriculture, forestry and fishing, manufacturing industries and other activities only.  Calculated by ESCWA.
 | 3 | According to the Environmental Survey for Iraq for 2005 (water, wastewater, municipal services).
 | 4 | Waste generated from manufacturing industries only.  Calculated by ESCWA.
 | 5 | Waste generated from agriculture, forestry and fishing, construction and municipal waste only.  Calculated by ESCWA.
 | 6 | Waste generated from municipal waste only.  Calculated by ESCWA.
 | 7 | Data are compiled from the following sources: Waste Management Centre in Abu Dhabi, Dubai Municipality, Sharjah Municipality, and Works of Ras Al Khaimah.
 | 8 | Waste generated from Municipal Waste only.  Calculated by ESCWA. Municipal waste data from households include a total of garbage generated in the urban and rural areas of the country, and is calculated by estimating the amount of waste for each of the urban and rural population by calculating the average daily intake per capita.  It is estimated at 0.60 kg/person per day in urban areas and 0.35 kg/person per day in rural areas.  These calculations are based on the study from the Yemeni German waste management project (GTZ) of the Ministry of Local Administration.
Spreadsheet: 25dd81cc-e94d-4d6a-bb81-66961ea06263
Sheet: Tunisia population census

جدول 30: السكان في تونس بحسب [NAME] تعداد 2004
Table 30: Population of Tunisia by age groups, 2004 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 416981 | 391034 | … | … | 263742 | 246986 | 153239 | 144048 | 416981 | 391034
5-9 | 435592 | 412776 | … | … | 268424 | 254374 | 167168 | 158402 | 435592 | 412776
10-14 | 509522 | 481931 | … | … | 309655 | 293832 | 199867 | 188099 | 509522 | 481931
15-19 | 540500 | 522751 | … | … | 337333 | 325439 | 203167 | 197312 | 540500 | 522751
20-24 | 500369 | 498783 | … | … | 333613 | 324011 | 166756 | 174772 | 500369 | 498783
25-29 | 420183 | 445050 | … | … | 280390 | 287258 | 139793 | 157792 | 420183 | 445050
30-34 | 355052 | 379302 | … | … | 243190 | 251042 | 111862 | 128260 | 355052 | 379302
35-39 | 344928 | 370272 | … | … | 239753 | 250007 | 105175 | 120265 | 344928 | 370272
40-44 | 322098 | 323909 | … | … | 230276 | 225750 | 91822 | 98159 | 322098 | 323909
45-49 | 282352 | 279145 | … | … | 199742 | 189993 | 82610 | 89152 | 282352 | 279145
50-54 | 215066 | 215704 | … | … | 151301 | 142425 | 63765 | 73279 | 215066 | 215704
55-59 | 148136 | 158579 | … | … | 101918 | 105614 | 46218 | 52965 | 148136 | 158579
60-64 | 127759 | 130131 | … | … | 81516 | 83809 | 46243 | 46322 | 127759 | 130131
65-69 | 123529 | 124436 | … | … | 75283 | 77144 | 48246 | 47292 | 123529 | 124436
70-74 | 100931 | 94757 | … | … | 58715 | 57717 | 42216 | 37040 | 100931 | 94757
75-79 | 63022 | 59603 | … | … | 35556 | 36709 | 27466 | 22894 | 63022 | 59603
80-84 | 36391 | 34198 | … | … | 19498 | 21110 | 16893 | 13088 | 36391 | 34198
85+ | 23024 | 23076 | … | … | 12139 | 14197 | 10885 | 8879 | 23024 | 23076
غير محدد    Not stated | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | …
المجموع    Total |  |  | … | …
Spreadsheet: 013b6081-6d33-444f-913f-e1c989b88ce1
Sheet: L_OTHER

Project Status |  |  |  |  | Yes/No |  |  |  |  | [NAME]
CODE | NAME | DISPLAY | VALUE |  | CODE | NAME | DISPLAY | VALUE |  | CODE | NAME | DISPLAY
Not Started |  |  |  |  | Y | Yes |  |  |  | Grant | Grant
Less than 50% completed |  |  |  |  | N | No |  |  |  | Loan | Loan
Completed 50% or more |  |  |  |  | Yes | Yes
Fully Completed |  |  |  |  | No | No
 |  |  |  |  | Y | Y
 |  |  |  |  | N | N
 |  |  |  |  | Yes | Y
 |  |  |  |  | No | N
Spreadsheet: 97081d1296287527-how-to-report-a-value-using-if-function-without-performing-any-math-operations-book3
Sheet: Sheet1

type | author | value
RMSE | Pea | 0.97 |  |  | Sum of value | type
ME | Pea | 0.56 |  |  | author | ME | RMSE | Grand Total
RMSE | [NAME] | 0.51 |  |  | [NAME] | 0.76 | 0.51 | 1.27
ME | [NAME] | 0.76 |  |  | Pea | 0.56 | 0.97 | 1.53
 |  |  |  |  | Grand Total | 1.32 | 1.48 | 2.8
Spreadsheet: benjamin_rogers__1138__unit performance data version1
Sheet: Wilton Center

 |  | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8
Life-to-Date Run Hours |  | 300.8 | 266.8 | 229.8 | 279 | 147.7 | 177.4 | 150 | 178.5
Life-to-Date Starts |  | 47 | 48 | 38 | 39 | 28 | 33 | 24 | 30
Performance Test Data
Output (MW) | Converted to 90 F | 78.2 | 77.7 | 76.5 | 76.7 | 77.3 | 78.4 | 78.4 | 77.7
Heat Rate (LHV) | Converted to 90 F | 10622 | 10641 | 10545 | 10650 | 10717 | 10641 | 10690 | 10694
[NAME] (ppm) | Converted to 90 F | 9.6 | 9.34 | 8.91 | 8.69 | 8.19 | 9.53 | 7.65 | 7.12
Spreadsheet: 1015f535-80a3-43fd-a2f8-f4bf76087d9d
Sheet: Sheet1

Unnamed: 0 | PACK  2  SKI  TRIP  **YEAR** | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | PARTICIPANTS |  | Number
 | Pack |  | 105
 | Guests |  | 5
Checks Given to [NAME] |  |  | INCOME
Date | Batch # |  | Total of Checks
 | First Batch
 | [NAME]
 | Third batch
 | [NAME]
 | Fifth Batch
 | TOTAL CHECKS |  | 0
Cash Given to Treasurer |  |  | INCOME
Date | Batch # |  | Total of Cash
 | First Batch
 | [NAME]
 | Third batch
 | Owed to Pack 2 |  | 0
 | TOTAL Cash |  | 0
TOTAL SALES |  |  | 0
Refunds Owed |  |  | 0
 | NET SALES |  | 0
Expenses Paid |  |  | EXPENSES
Bus Deposit
Bus Balance
Gratuities
[NAME]
Supplies (Movies, Candy, Pens, etc)
TOTAL EXPENSES |  |  | 0
NET  COST  TO  PACK 2 |  |  | 0
 |  | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
# PEOPLE |  | 85 | 103 | 110
PAID |  | 3943 | 5189 | 4697
REFUNDS |  | -20 | -770 | -218
NET SALES |  | 3923 | 4419 | 4479
[NAME] |  | 2972 | 3343 | 3666
BUS |  | 1360 | 1525 | 1600
GRATUITY |  | 150 | 170 | 180
MISC EXP |  | 16 | 15 | 21
TOTAL EXPENSES |  | 4498 | 5053 | 5467
NET COST TO PACK |  | 575 | 634 | 988
OWED TO PACK 2 | $
Scout Name
Scout Name
Scout Name
Scout Name
TOTAL OWED TO PACK | 0
REFUNDS  OWED | $ | Reason | (i.e. Overpaid, dropped helmet or tubing)
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
Scout Name
TOTAL | 0
EXCESS  COST  ANALYSIS
Bus Cost (per bus) | # of Busses
 |  | 0
# of Bus seats Paid | Amount per seat
 |  | 0
Net Cost of Bus |  | 0
Gratuity Expense
Movies, Candy, Copies
NET  COST |  | 0
Spreadsheet: daren_farmer__6672__egmnom-May
Sheet: DELV SUMMARY

 |  | ECT DELIVERED
 |  | MAY 2000
 | #1338 | #1373 | #1511 | #1195 | #1258
 |  |  |  | TIER 1 | TIER 1
 | UNIT | LYONDELL | CLARK | HUNTSMAN | DONAHUE
DAYS | Aristech | CHANNELVIEW | REFINERY | EAST PLANT | LUFKIN | TOTAL
1 | 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 | 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 | 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 | 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 | 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
TOTAL
Spreadsheet: 858328d1707053598-combined-two-operations-result-in-one-summary-sheet-shipment_receipt_report
Sheet: Feb 2024

 | Sr. No | Offloading Date | BL# / AWB# | Container # | Type | Inv# | Supplier | WH | Unloaded by | Cost
 |  | 2024-02-03 00:00:00 |  | tnsu-2001254 | 1x20ft. Dry | EG-230139 | EVEREST GLOBAL | 901 | Outsource | 275
 | Total
Spreadsheet: 130134d1322073709-conditional-formatting-icon-sets-traffic-lights_jpr73
Sheet: Sheet1

 | Company XXX
 |  | Budget | Actual | Visual
 | 2011-04-01 00:00:00 | 29.26037461822686 | 29.02543730377395
 | 2011-05-01 00:00:00 | 28.36414082711559 | 28.36414082711559
 | 2011-06-01 00:00:00 | 28.56815356749654 | 28.56815356749654
 | 2011-07-01 00:00:00 | 28.9306489093017 | 28.94923755866345
 | 2011-08-01 00:00:00 | 29.2516750250814 | 28.10055552101491
 | 2011-09-01 00:00:00 | 29.21448375738506 | 28.32778635516595
 | 2011-10-01 00:00:00 | 29.11345539672783 | 28.49571366076177
 | 2011-11-01 00:00:00 | 29.06927611642176 | 29.16479086292259
 | 2011-12-01 00:00:00 | 28.96563350513994 | 29.18524336118568
 | 2012-01-01 00:00:00 | 28.99359912776685 | 29.35053249772294
 | 2012-02-01 00:00:00 | 29.01867317921229 | 29.72570705596576
 | 2012-03-01 00:00:00 | 29.03154039008284 | 29.89798876258142
Spreadsheet: sally_beck__34371__gas physical
Sheet: Sheet1

ENA Gas Physically flowing |  |  | Daily Volume
Sales
Reliant Energy Entex |  |  | 13500 |  | Supply from Storage
City of Tallahassee |  |  | 10000 |  | Purchasing supply
[NAME] |  |  | 4000 |  | Purchasing supply
Midland Cogen PEPL |  |  | 5000 |  | Purchasing supply
[NAME] |  |  | 11100 |  | Purchasing supply
PURCHASES
Louis Dreyfus Natural Gas |  |  | 10000 |  | Sold to City of Tallahassee
Citrus | We are acting as Nominations agent for Citrus.  Moving at 90,000/day
Enovate/ | ENA is acting as Nominations agent for Enovate and Enron Midwest
Midwest | Currently moving about 300,000/day.   Part of the People deal.
City of Pasadena |  | ENA is acting as nominations agent for the city.   4,000/day
Enron Compression Services
Exchange of power for gas deals.  Currently collecting gas volumes on
[NAME] (11,000/day)and Northern Natural (2,000)
[NAME] sold to various parties
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -939 | -1588
2 | -2025 | -1588
3 | -2053 | -1588
4 | -1629 | -1588
5 | -2098 | -1588
6 | -980 | -1588
7 | -556 | -1588
8 | -837 | -1588 |  |  |  |  |  |  |  |  | Avg
9 |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10
11 |  |  |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -345354
2001-12-08 00:00:00
CBS Volume
 |  |  | -39976
Spreadsheet: 760095d1639993666-one-to-one-many-to-one-one-to-many-formula-copy-of-sample-book-1-2226-1-
Sheet: old

Origin code | Destination code | [NAME] result | expected
307210000 | 307211000 |  | One to One
307210011 | 307211010 |  | Many to One
307210011 | 307211010 |  | Many to One
307210019 | 307211010 |  | One to One
307210091 | 307211090 |  | Many to One
307210091 | 307211090 |  | Many to One
307210099 | 307211091 |  | One to Many
307210099 | 307211092 |  | One to Many
Spreadsheet: 717273d1612548731-closing-formula-help-dbs
Sheet: Worksheet

S.no | child part number | stock available | Consumption | FIFO Consumption | Closing Stock
1 | 50114242 | 9000 | 9100 |  | 0
 | 50114242 | 40900 | 0 | 100
 | 50289271 | 23000 | 44000 |  | 0
 | 50289271 | 20000 | 0 |  | 0
 | 50289271 | 4000 |  | 0
 | 51040241 | 4000 | 4000 | 4000 | 0
 | 51040241 | 3100 | 0 | 0
 | 52202876 | 21000 | 20000
 | 52202876 | 2000 | 0 | 0
 | 52202876 | 7000 | 0 | 0
Spreadsheet: 856151d1705507458-appending-data-from-one-sheet-to-another-excelforum-test-sheet
Sheet: Desired Result

Name | Telephone Number | Email address
Jones, R | 89461614 | [EMAIL]
Smith, A | 23121551 | [EMAIL]
Hodgkins, T | 46455161 | [EMAIL]
Mackay, D | 98464165 | [EMAIL]
Thompson, H | 25545645 | [EMAIL]
Regus, L | 45455453 | [EMAIL]
Arran, I | 12154658 | [EMAIL]
Spreadsheet: 224354d1364551916-determine-minimum-value-in-column-and-get-all-the-value-in-its-row-book2
Sheet: Sheet1

 | A | B | C
X1 | 2 | 3 | 5
X2 | 1 | 6 | 2
X3 | 5 | 2 | 1
min Value at Column C
X3 | 5 | 2 | 1
Spreadsheet: 792426d1660898214-sumifs-and-lookup-function-resulted-to-null-value-sampleproblemsumifsandlookup-file-1-hd
Sheet: Report

 | Profit Center | 2063-000
 | Planning Group | Item | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | Z1 | Labor
 | [NAME] | Plant and Equipment
 | Z3 | Materials
 | Z4 | Temporaries
 | [NAME] | Subcontractors
 | Z6 | General Expense
 | Z7 | Others
 | Total Outflows
 | Account 21200101 is incorrectly removed
 | Account 21200101 is replaced
 | Account 21200101 is correctly removed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 60
Spreadsheet: 355995d1414907978-auto-filter-test-marks
Sheet: Absent

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
Spreadsheet: 817946d1676521465-date-formula-remove-time-from-date
Sheet: Sheet3

Date |  | Result
9/9/2022, 12:17 AM |  | 2022-09-09 00:00:00
9/7/2022, 7:40 PM
9/7/2022, 7:30 PM
9/7/2022, 10:54 PM
9/7/2022, 10:29 PM
8/3/2022, 3:36 PM
8/11/2022, 10:01 AM
8/10/2022, 10:59 AM
7/20/2022, 11:50 PM
7/20/2022, 11:30 PM
6/7/2022, 3:22 PM
6/7/2022, 3:13 PM
6/7/2022, 2:29 PM
6/7/2022, 1:59 PM
5/17/2022, 2:16 PM
Spreadsheet: 146574d1332260312-getting-data-moving-from-one-spreadsheet-to-another-026-except
Sheet: Sheet1

 | M1076 / 327767071 |  |  |  |  |  |  |  |  |  |  |  | ORG |  |  |  |  | 1 |  | 2012-03-14 15:47:00 |  |  |  |  | E35A00200187 |  |  |  |  | 2012-03-14 00:01:00 |  |  |  |  | PINTLE TUBE BENT |  |  |  |  |  |  |  | S&T114 |  |  |  |  | A |  |  |  | 6
 |  | TUBE ASSEM |  |  |  |  | 013664058 |  |  |  |  | 1 |  |  |  |  | 0 |  |  |  | A |  |  |  | WW91GM220740001 |  |  |  |  |  |  |  | 02 |  |  | BD |  |  |  | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | O 20750329 R SIAD 3/18
 |  | HANDLE,DOO |  |  |  |  | 013659718 |  |  |  |  | 1 |  |  |  |  | 0 |  |  |  | A |  |  |  | WW91GM220740004 |  |  |  |  |  |  |  | 02 |  |  | BD |  |  |  | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | O 20750332 NMBG 3/20
 |  | SCREW,CAP, |  |  |  |  | 011524223 |  |  |  |  | 8 |  |  |  |  | 0 |  |  |  | A |  |  |  | WW91GM220740002 |  |  |  |  |  |  |  | 02 |  |  | BD |  |  |  | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | O 20750330 @RSSA 3/15
 |  | HANDLE,DOO |  |  |  |  | 013659717 |  |  |  |  | 1 |  |  |  |  | 0 |  |  |  | A |  |  |  | WW91GM220740005 |  |  |  |  |  |  |  | 02 |  |  | BD |  |  |  | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | O 20750333 NMBG 3/20
 |  | NUT,SELF-L |  |  |  |  | 011505918 |  |  |  |  | 8 |  |  |  |  | 0 |  |  |  | A |  |  |  | WW91GM220740003 |  |  |  |  |  |  |  | 02 |  |  | BD |  |  |  | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | O 20750331 @RSSA 3/15
Spreadsheet: 851053d1701314359-how-to-look-up-time-in-based-on-employee-name-and-date-of-login-book1
Sheet: Sheet1

Employee: | [NAME] |  |  |  |  |  |  |  |  | Employees
Week starting: | 2023-10-21 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
Week ending: |  |  |  |  |  |  |  |  |  | [NAME]
Pay Date: |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
Day | Date | Time In | Time Out | Break (minutes) | Unloading Time | Hours |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
Total hours:
Spreadsheet: 87758d1287606839-max-count-in-a-series-based-on-name-in-place-test-for-max-count
Sheet: Monthly

 | Direct Hrs | Indirect Labor Hrs |  |  | Total Hrs | Training Hours | Utlilization | Percent of hours training | Average Hours / 5 day week | % at work | % not at work | Max days in a row
[NAME] | 104 | 48 | 0 | 0 | 152 | 8 | 0.6842105263157895 | 0.05263157894736842 | 15.2 | 0.9047619047619048 | 0.09523809523809523 | 0
[NAME] | 0 | 123 | 0 | 0 | 123 | 0 | 0 | 0 | 12.3 | 0.7321428571428571 | 0.2678571428571429
Ernest | 166.5 | 3 | 0 | 0 | 169.5 | 0 | 0.9823008849557522 | 0 | 16.95 | 1.008928571428571 | -0.008928571428571397
Spreadsheet: 70592d1271321506-vlookup-with-another-condition-sample
Sheet: Sheet2

FINISHED GOODS PACKED AS
SSP |  | CONE / | CONE /
tex | quality | LENGTH | CTN
TEX-27[60/3] | SPUN POLYESTER | 5000 MTRS | 72
TEX-27[60/3] | SPUN POLYESTER | 3000 MTRS | 32
TEX-30 | POLY POLY CORE | 5000 MTRS | 50
Spreadsheet: 156171d1337199080-help-with-food-question-sample
Sheet: Sheet1

Type of food | Cuisine
spaghetti | Italian
pad thai | Thai
corned beef | Deli
eggroll | Chinese
california roll | Japanese
edamame | Japenese
hamburger | american
egg drop soup | chinese
french fries | American
Spreadsheet: 92827d1292361562-populate-cells-with-data-from-a-different-file-named-in-another-cell-food-scientist
Sheet: Sheet1

 | Workbook 1: |  |  |  |  | Workbook 2:
 | Ingredient |  |  |  |  | Formulation
 | Name | Moisture (%) |  |  | Filename | Ingredient Name | Ingredient Moisture
 | Corn Flour | 0.085 |  |  | Ingredient | Corn Flour | 0.085
 | Points:
1 | These two simple tables are representations of two different files from which data would be combined.
2 | Workbook 1 is named "Ingredient" and workbook 2 is named "Formulation".
3 | Understand that there will be many rows in "Formulation" column F calling upon thousands of possible ingredients (each with a unique filename).
4 | When entering any filename into column Fof "Formulation", fields in column G and H would be populated with information from the named file - whether it is opened or closed.
Spreadsheet: 872848d1719299013-copy-data-to-another-sheet-and-separate-into-group-expense
Sheet: sheet 1

 | Claim for Month June |  |  | BALANCE BF |  |  | 541.68
 | Date | Category | Ref no | Description | Car | Km | Amount | BALANCE
 | 2024-06-02 00:00:00 | ACCOMMODATION FEE | [PHONE] | OYO 90380 HOTEL JASIN 2 DAY |  |  | 352.8
 | 2024-06-06 00:00:00 | PETROL | 3313d1 | PETRONAS - SELANDAR | PJL4 | 251073 | 50
 | 2024-06-05 00:00:00 | PETROL | 02000704 | PETRONAS - SELANDAR | PJL4 | 251270 | 50 |  |  |  | 1 | PETROL | 车油
 | 2024-06-12 00:00:00 | TOP UP | [PHONE] | TOP UP |  |  | -4000 |  |  |  | 2 | TOUCH N GO
 | 2024-05-31 00:00:00 | OFFICE EQUIPMENT | 2645 | KINDAKI - FEWING |  |  | 660 |  |  |  | 3 | PRINT & STATIONERY | BANNER，文具
 | 2024-05-31 00:00:00 | PHONE CHARGES FEE | [PHONE] | DIGI |  |  | 207.6 |  |  |  | 4 | TOOLS & UTENSIL | covid test kit，打芭用具，钥匙
 | 2024-06-07 00:00:00 | POSTAGE & COURIER | ERA906464222 | POSLAJU - SABAH TO CUSTOMER |  |  | 284.8 |  |  |  | 5 | ENTERTAINMENT FEE | 礼物
 | 2024-06-07 00:00:00 | POSTAGE & COURIER | ERA906464219 | POSLAJU - SABAH TO CUSTOMER |  |  | 284.8 |  |  |  | 6 | ACCOMMODATION FEE | 住宿
 | 2024-06-12 00:00:00 | POSTAGE & COURIER | ERD086153363 | POSLAJU - JOHOR BAHRU TO CUSTOMER |  |  | 6.5 |  |  |  | 7 | ELECTRICITY FEE | 电费
 | 2024-06-12 00:00:00 | ACCOMMODATION FEE | [PHONE] | RJ [NAME] DAY |  |  | 356.64 |  |  |  | 8 | TELEKOM FEE | UNIFI
 |  |  |  |  |  |  |  |  |  |  | 9 | POSTAGE & COURIER | 邮寄，快递
 |  |  |  |  |  |  |  |  |  |  | 10 | LESEN FEE
 |  |  |  |  |  |  |  |  |  |  | 11 | PHONE CHARGES FEE | 电话费
 |  |  |  |  |  |  |  |  |  |  | 12 | WATER FEE | 水费
 |  |  |  |  |  |  |  |  |  |  | 13 | TRANSPORT FEE | 船运，罗里
 |  |  |  |  |  |  |  |  |  |  | 14 | CLEANING FEE | 打扫
 |  |  |  |  |  |  |  |  |  |  | 15 | UPKEEP OF MOTOR VEHICLE | 修车，洗车
 |  |  |  |  |  |  |  |  |  |  | 16 | TRANSPORTATION FEE | 车票，taxi
 |  |  |  |  |  |  |  |  |  |  | 17 | UPKEEP OF WATER PUMP | 修pump, 买牛油
 |  |  |  |  |  |  |  |  |  |  | 18 | STAFF WALFARE | 床，被单
 |  |  |  |  |  |  |  |  |  |  | 19 | CONTRACTOR FEE | 打芭借钱，代理做芭
 |  |  |  |  |  |  |  |  |  |  | 20 | MEDICAL FEE
 |  |  |  |  |  |  |  |  |  |  | 21 | SIGNBOARD | 广告牌
 |  |  |  |  |  |  |  |  |  |  | 22 | ACCIDENT | 意外
 |  |  |  |  |  |  |  |  |  |  | 23 | ROAD TAX
 |  |  |  |  |  |  |  |  |  |  | 24 | TOP UP
 |  |  |  |  |  |  |  |  |  |  | 25 | ADVERTISEMENT | 宣传单夹报纸
 |  |  |  |  |  |  |  |  |  |  | 26 | OFFICE EQUIPMENT | 电脑
 |  |  |  |  |  |  |  |  |  |  | 27 | FURNITURE & FITTING | 架子
 |  |  |  |  |  |  |  |  |  |  | 28 | REFUND | 顾客退钱
 |  |  |  |  |  |  |  |  |  |  | 29 | SUNDRY & MISCELLANEOUS | 车罚单
 |  |  |  |  |  |  |  |  |  |  | 30 | PANTRIES | 买糕
 |  |  |  |  |  |  |  |  |  |  | 31 | RENTAL | 租
 |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  | TOTAL
Spreadsheet: 759506d1639580790-sum-column-based-on-values-in-2-other-columns-audits-master
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases
[NAME] |  | 144
[NAME] | 1 | 182
Luc | 1 | 187
[NAME] |  | 265
[NAME] |  | 226
Brae |  | 241
[NAME] |  | 90
[NAME] | 1 | 150
[NAME] | 0 | 100
[NAME] | 0 | 80
Ry | 0 | 60
[NAME] | 1 | 40
Will | 1 | 880
Will |  | 100
Jo | 1 | 220
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
Will |  | 259
JR |  | 191
Ry |  | 191
Spreadsheet: 270670d1381581089-formula-for-multiple-matches-to-sum-result-from-another-column-into-another-sheet-justmeok_example_amended
Sheet: JUL 13

 |  | Jul 2013 |  |  |  |  |  |  |  | YTD
GL Code | Account | Actual | Budget | Actual vs Budget $Difference | Actual vs Budget %Diff | LY | answer shb | Actual vs LY $Difference | Actual vs LY %Diff | Actual | Budget | Actual vs Budget $Difference | Actual vs Budget %Diff | LY | Actual vs LY $[NAME] | Actual vs LY %Diff
6-2200 |  |  |  |  |  | 50733.74 |  |  | 0 |  |  |  |  | 50733.74 |  | 0
6-2400 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
6-2401 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
6-2440 |  |  |  |  |  | 50733.74 | 53161.87 |  | 0 |  |  |  |  | 50733.74 |  | 0
6-2441 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
6-1274 |  |  |  |  |  | 31.53 | 4950.8
6-1276 |  |  |  |  |  | 9803.7 | 3358.37
6-2505 |  |  |  |  |  | 0 | 3092.04
6-2520 |  |  |  |  |  | 1358.21 | 0
6-2525 |  |  |  |  |  | 0 | 1358.21
6-2530 |  |  |  |  |  | 5551.4 | 0
6-2540 |  |  |  |  |  | 7801.7 | 5551.4
6-2550 |  |  |  |  |  | 0 | 7801.7
6-2560 |  |  |  |  |  | 509.95 | 0
6-2565 |  |  |  |  |  | 275.53 | 509.95
6-2570 |  |  |  |  |  | -1634.01 | 275.53