tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 27574d1220930598-add-multiple-cells-not-in-a-row-hours-p357
Sheet: Sheet1

 | NAME | FROM |  | TO | Hrs
1 | name1 | 8 | to | 17 | 9
2 | [NAME] | 9 | to | 17 | 8
3 | name3 | 10 | to | 17 | 7
4 | name4 | 11 | to | 17 | 6
5 | name5 |  | to |  | 0
6 | name6 |  | to |  | 0
7 | name7 |  | to |  | 0
8 | name8 |  | to |  | 0
9 | name9 |  | to |  | 0
10 | name10 |  | to |  | 0
11 | name11 |  | to |  | 0
12 | name12 |  | to |  | 0
13 | name13 |  | to |  | 0
14 | name14 |  | to |  | 0
15 | [NAME] |  | to |  | 0
16 | [NAME] |  | to |  | 0
17 | name17 |  | to |  | 0
18 | name18 |  | to |  | 0
19 | name19 |  | to |  | 0
20 | name20 |  | to |  | 0
21 | [NAME] |  | to |  | 0
22 | name22 |  | to |  | 0
23 | name23 |  | to |  | 0
24 | name24 |  | to |  | 0
25 | name25 |  | to |  | 0
26 | [NAME] |  | to |  | 0
27 | name27 |  | to |  | 0
28 | name28 |  | to |  | 0
29 | name29 |  | to |  | 0
30 | name30 |  | to |  | 0
31 | name31 |  | to |  | 0
32 | name32 |  | to |  | 0
33 | name33 |  | to |  | 0
34 | [NAME] |  | to |  | 0
35 | name35 |  | to |  | 0
36 | name36 |  | to |  | 0
37 | name37 |  | to |  | 0
38 | name38 |  | to |  | 0
39 | [NAME] |  | to |  | 0
40 | name40 |  | to |  | 0
41 | name41 |  | to |  | 0
42 | name42 |  | to |  | 0
43 | name43 |  | to |  | 0
44 | name44 |  | to |  | 0
45 | name45 |  | to |  | 0
46 | name46 |  | to |  | 0
47 | [NAME] |  | to |  | 0
48 | name48 |  | to |  | 0
49 | name49 |  | to |  | 0
50 | name50 |  | to |  | 0
 | Total | 30 |  |  | 30
 |  | formula 1 |  |  | formula 2
 | * This will work correctly unless there is someone working over-night
Spreadsheet: 764297d1642681473-help-for-formula-for-extracting-different-words-and-sorting-them-among-spreadsheet-uniqe-list-in-assending-order-ans
Sheet: Sortedata

 | aaa | qqq | [NAME]
 | [NAME] | ww | aaa
 | dd | aaa | qqq
 | ee | dd | ee
 | aaa | ee | dd
 | ss | ss | zzz
 | ee | dd | ee
 | aaa | ee | dd
 | ss | ss | zzz
 | Unsorted data |  |  | Sorted as per count
 | LIST | COUNT |  | LIST | COUNT | Helper range F2:H10 used
Spreadsheet: cfd962e5-6f93-4e24-b505-e658c4acac1a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: March 7, 2014 (7:45 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 237399
Q1-2004 | 223675
Q2-2004 | 233241
Q3-2004 | 232983
Q4-2004 | 246201
Q1-2005 | 236033
Q2-2005 | 244136
Q3-2005 | 244711
Q4-2005 | 255856
Q1-2006 | 245182
Q2-2006 | 254735
Q3-2006 | 255745
Q4-2006 | 271401
Q1-2007 | 257973
Q2-2007 | 265739
Q3-2007 | 267325
Q4-2007 | 281304
Q1-2008 | 270217
Q2-2008 | 277643
Q3-2008 | 277604
Q4-2008 | 282885
Q1-2009 | 261948
Q2-2009 | 266881
Q3-2009 | 265508
Q4-2009 | 280622
Q1-2010 | 267483
Q2-2010 | 274697
Q3-2010 | 276055
Q4-2010 | 291990
Q1-2011 | 277885
Q2-2011 | 289552
Q3-2011 | 288862
Q4-2011 | 304550
Q1-2012 | 290131
Q2-2012 | 297462
Q3-2012 | 296119
Q4-2012 | 320584
Spreadsheet: 802708d1666978433-using-index-and-aggregate-to-pull-data-in-ignoring-blanks-excel-example
Sheet: Sheet1

 | Material | Qty
 | 20018000 | 5 | [NAME]
 | 20018004 | 0 |  |  | Is there a way to formulate it so it will skip a duplicate result?
 | 20018008
 | 20018012 | 15
 | 20018004 | 0
 | 20018020 | 25
 | 20018024
 | 20018026 | 30
 | 20018028
 | 20018030
 | 20018032 | 30
Spreadsheet: 58658d1258927716-color-blank-cells-colorblankcells1
Sheet: Expenditure

DATE | Account Heads | AMOUNT | Rate Per Unit | Litres Consumed | Rate per Litre | Alcohol % | Benzene% | Chlorine% | Sodium % | Electricity Units | Elec Rate/Unit |  |  |  | Start Col | End Col | Color
2009-11-19 00:00:00 | Water Charges | 1000 |  | 100 [NAME] | 10/Ltr |  |  |  |  |  |  |  |  | Water Charges | 5 | 6
2009-11-20 00:00:00 | Chemicals |  |  |  |  | 0.001 | 0.025 | 0 |  |  |  |  |  | Electricity Charges | 11 | 12
2009-11-20 00:00:00 | Electricity Charges | 100 |  |  |  |  |  |  |  | 25 | 4 |  |  | Chemicals | 7 | 10
2009-11-20 00:00:00 | Electricity Charges | 150
2009-11-20 00:00:00 | Water Charges | 2580
2009-11-21 00:00:00 | Electricity Charges | 250 |  |  |  |  |  |  |  | 62.5 | 4
2009-11-21 00:00:00 | Water Charges | 1200 |  |  | 10/Ltr
2009-11-22 00:00:00 | Chemicals | 2500 |  |  |  | 0.001 | 0.025 | 0 | 0.042
2009-11-22 00:00:00 | Chemicals | 2800 |  |  |  | 0 | 0.0175 |  | 0
2009-11-22 00:00:00 | Electricity Charges | 1800
2009-11-22 00:00:00 | Water Charges | 500 |  | 50 [NAME]
Spreadsheet: 727193d1617760118-auto-pull-and-multiple-good-company
Sheet: Production Plan

 |  |  |  | NEED TO AUTOMATE THIS COLUMN
 | Crafiting duration | Quantity Output | Daily Production | Needed Production | Tables Needed
Plastic Parts | 0.6 | 10 |  | 65
Plastic Case | 0.6 | 1
Enhanced Battery Cell | 0.6 | 1
Circuit Board | 0.6 | 5 |  | 37
Logic Circuit | 0.6 | 1
Integrated Circuit | 0.6 | 10 |  | 35
7 Segment Circuit | 0.6 | 1
Plastic | 1 | 50 |  | 366
Metal | 1 | 50 |  | 87
Electronic Parts | 1 | 100 |  | 979
Chemicals | 1 | 50 |  | 26
Spreadsheet: 490651d1479983491-percentage-and-pie-chart-help-percentage
Sheet: Sheet1

B
B
B
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
I
I
W
W
W
B
B
B
C
C
C
C
C
C
C
C
C
C
C
D
D
D
Spreadsheet: 838350d1690948100-calculation-returning-an-error-test-46-
Sheet: Sheet1

 | 2. Date | Movement Type | 3. Location |  | 4. Travel Times |  | 5. Reason for Stop | Travel Hours | 6.Did you work? | 6. Hours Worked | 7. Meal Period | Travel Comp Hours
 |  |  | From | To | Start | Stop |  |  |  |  |  |  | 8. Notes
 | 2023-07-11 00:00:00 | Waiting |  |  | 8:00:00 | 17:00:00 | Waiting Period |  | Yes | 08:00:00 | 00:30:00
 | 2023-07-12 00:00:00 | Traveling |  | CAIN |  | 23:00:00 | En Route |  |  | 02:00:00 | 00:45:00
 | 2023-07-13 00:00:00 | Waiting |  |  |  | 3:30:00 | Waiting Period |  | Yes | 04:30:00
 | 2023-07-14 00:00:00 | Traveling |  | Indianapolis Airport |  | 4:30:00 | Awaiting Transportation |  |  | 01:00:00
 | 2023-07-15 00:00:00 | Waiting |  |  |  | 7:30:00 | Waiting Period |  |  | 02:30:00 | 00:30:00
 | 2023-07-16 00:00:00 | Traveling |  | Qatar |  | 22:00:00 | En Route
 | 2023-07-17 00:00:00 | Waiting |  |  |  | 23:00:00 | Waiting Period
Spreadsheet: 00106cd7-b1a1-486f-afff-af9de1491bbe
Sheet: Table A - Performance_Feedstock

Data for MRC evaluation of criteria |  |  |  |  |  |  |  |  | PROPRIETARY/BUSINESS SENSITIVE
 | Published State of the Art |  |  | Example |  | From Applicant
Parameter/Performance | [NAME]:      App Biochem Biotech 1999 | Yeast (S. cerevisiae):         App Env Microbiol 1998 | E. coli:                 J Ind Microbiol Biotech 1998 | Benchmark | Target | Benchmark (Current)* | Intermediate Target (~6-8 months) | Final Target (18-24 months)
Feed (pure sugars, hydrolysate of what feed, other sources) | Mixed clean sugars | Mixed clean sugars | Pure sugars | Corn stover hydrolysate | Corn stover hydrolysate
Process type (e.g., SSF, [NAME], HHF, other -identified) | Co-fermentation | Co-fermentation | Single sugar fermentation | SSF | HHF
Initial concentrations:
Total Solids (%) |  |  |  | 0.2 | 0.2
Glucose (g/L) | 75 | 90 | 140
[NAME] (g/L) | 75 | 44 | 140
Other sugars (g/L)
Organic acids or other inhibitors (g/L)
Sugar Utilization
Glucose (%) | 100 | 100 |  | 100 | 100
Xylose (%) | 84 | 90 |  | 85 | 94
Other sugars (%) |  |  |  | 0 | 90
Biofuel or [NAME] (% theoretical)
Glucose to biofuel or bioproduct (%) |  |  | 85.6 | 95 | 95
Xylose to biofuel or bioproduct (%) |  |  | 89.4 | 75 | 85
Other sugars to biofuel or bioproduct (%) |  |  |  | 0 | 85
Final ethanol titer (g/L) | 67 | 60 | 63.8 | 50 | 62
Robustness
Fermentation rate (time to achieve yields above) (hours) | 80 | 52 | 96 | 84-168 | 36-48
Scale demonstrated (>1L, >10L, >100L, etc.) | 1L | <1L | <1L | >1L | >1000L
References/Notes |  | Calculated from Figure 4A of the article |  | An example only. | Represents the design case described in NREL's 2002 design report ([NAME] TP-510-32438)
* Provide best data based on current level of your technology development
Spreadsheet: 788063d1658245449-sumifs-with-derived-criteria-sumifs_derived_criteria_example
Sheet: Sales

Sales Rep | Sale Amount | Sale Area |  | Rep | Region | Total Sales
[NAME] | 100 | Area 1 |  | [NAME] | North | 550
[NAME] | 300 | Area 2
Cath | 500 | Area 3
[NAME] | 700 | Area 4
[NAME] | 200 | Area 5
[NAME] | 400 | Area 6
Cath | 600 | Area 7
[NAME] | 800 | Area 1
[NAME] | 250 | Area 2
[NAME] | 350 | Area 3
Cath | 450 | Area 4
[NAME] | 550 | Area 5
[NAME] | 100 | Area 6
[NAME] | 300 | Area 7
Cath | 500 | Area 1
[NAME] | 700 | Area 2
[NAME] | 200 | Area 3
[NAME] | 400 | Area 4
Cath | 600 | Area 5
[NAME] | 800 | Area 6
[NAME] | 250 | Area 7
[NAME] | 350 | Area 1
Cath | 450 | Area 2
[NAME] | 550 | Area 3
[NAME] | 100 | Area 4
[NAME] | 300 | Area 5
Cath | 500 | Area 6
[NAME] | 700 | Area 7
[NAME] | 200 | Area 1
[NAME] | 400 | Area 2
Cath | 600 | Area 3
[NAME] | 800 | Area 4
[NAME] | 250 | Area 5
[NAME] | 350 | Area 6
Cath | 450 | Area 7
[NAME] | 550 | Area 8
Spreadsheet: 678608d1589979414-excel-wiil-not-concatenate-concatenate
Sheet: Sheet1

15539 | 1 | =A$1&B1 | =concatenate(A$1,B1) | =concat(A$1,B1) | 1 | 2
 | 2 | =A$1&B2 | =concatenate(A$1,B1) | =concat(A$1,B1)
 | 3 | =A$1&B3 | =concatenate(A$1,B1) | =concat(A$1,B1)
 | 4 | =A$1&B4 | =concatenate(A$1,B1) | =concat(A$1,B1)
 | 5 | =A$1&B5 | =concatenate(A$1,B1) | =concat(A$1,B1)
 | 6 | =A$1&B6 | =concatenate(A$1,B1) | =concat(A$1,B1)
10
Spreadsheet: tracy_geaccone__40463__2002 1N9 Forecast
Sheet: ENA Note 1

Enron Leasing Partners, LP & Associated Entities
Interest Income/Expense Calculation
From Enron North America (413)
To Enron Pipeline Company (1N9)
Original Principal |  | 402000000
Principal Payment |  | 0
Ending Principal
Days In Year |  | 360
Days In Month |  | 30
Rate |  | 1 Month LIBOR
Original Spread |  | 0.003
Penalty Spread |  | 0.006
Due Date: |  | Demand
 |  |  | Monthly Rate
Month | Principal | Month | LIBOR | Adjustment | Total | Daily Rate | Interest
January |  |  | 0.04 | 0.003
February |  |  | 0.04
March |  |  | 0.04
April |  |  | 0.04
May |  |  | 0.04
June |  |  | 0.04
July |  |  | 0.04
August |  |  | 0.04
September |  |  | 0.04
October |  |  | 0.04
November |  |  | 0.04
December |  |  | 0.04
YTD Total
Spreadsheet: john_griffith__16082__1_17_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL G2 | EXP |  |  | 94.5 | 107.1 | 1.2 | 2002-01-15 14:52:00
 | CL H2 | 19 | 220 | 230 | 52.6 | 55 | 0.64 | 2002-01-17 11:19:00
 | CL J2 | 19.5 | 313 | 326 | 51.3 | 53.4 | 0.64 | 2002-01-17 11:19:00
 | CL K2 | 20 | 385 | 400 | 49.2 | 51.1 | 0.63 | 2002-01-17 11:19:00
 | CL M2 | 20 | 430 | 440 | 47.9 | 49.1 | 0.61 | 2002-01-17 11:19:00
 | CL N2 | 20 | 455 | 475 | 45.2 | 47.2 | 0.58 | 2002-01-17 11:19:00
 | CL Q2 | 20 | 485 | 505 | 44.3 | 46.1 | 0.57 | 2002-01-17 11:19:00
 | CL U2 | 20 | 495 | 515 | 42.1 | 43.8 | 0.54 | 2002-01-17 11:19:00
 | [NAME] | 20 | 498 | 518 | 39.5 | 41.1 | 0.51 | 2002-01-17 11:19:00
 | CL X2 | 20.5 | 500 | 520 | 36.7 | 38.1 | 0.48 | 2002-01-17 11:19:00
 | [NAME] | 20.5 | 500 | 520 | 35 | 36.4 | 0.46 | 2002-01-17 11:19:00
 | CL F3 | 20.5 | 505 | 525 | 33.8 | 35.1 | 0.44 | 2002-01-17 11:19:00
 | CL M3 | 20.5 | 510 | 535 | 28.9 | 30.4 | 0.38 | 2002-01-17 11:19:00
 | CL Z3 | 21 | 540 | 540 | 26.2 | 26.2 | 0.35 | 2002-01-17 11:19:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 328581d1403953186-multiple-variables-to-calculate-a-value-pricing_calculator_solution
Sheet: Pricing_Calculator

 |  |  |  |  |  |  | Pricing / sq. m
 |  |  | 64 | 90 | 114 |  | 90mm & 114mm Blades | TRADITIONAL TILTBAR | CLEARVIEW TILT BAR | ULTRA TILTBAR
 | Traditional | < 500 mm | 154 | 154 | 154 |  | Panels under 700[NAME] wide | 154 | 159 | 179
 | Clear View | < 500 mm | 159 | 159 | 159 |  | Panels 700mm – 900mm wide | 177 | 182 | 202
 | Ultra Clear | < 500 mm | 179 | 179 | 179
 | Traditional | < 700 mm | 154 | 154 | 154 |  | 64mm Blades | TRADITIONAL TILTBAR | CLEARVIEW TILT BAR | ULTRA TILTBAR
 | Clear View | < 700 mm | 159 | 159 | 159 |  | Panels under 500mm wide | 154 | 159 | 179
 | Ultra Clear | < 700 mm | 179 | 179 | 179 |  | Panels 500mm – 750[NAME] wide | 177 | 182 | 202
 | Traditional | 500 mm – 750 mm | 177 | 177 | 177
 | Clear View | 500 mm – 750 mm | 182 | 182 | 182
 | Ultra Clear | 500 mm – 750 mm | 202 | 202 | 202
 | Traditional | 700 mm – 900 mm | 177 | 177 | 177
 | Clear View | 700 mm – 900 mm | 182 | 182 | 182
 | Ultra Clear | 700 mm – 900 mm | 202 | 202 | 202
 |  | [NAME] | 90 mm
 |  | Panel Size | 500 mm – 750 mm
 |  | Tilt Bar Type | Clear View
 |  | [NAME] (sq. m) |  | [NAME]
 |  | [NAME] (sq. m) |  | [NAME]
 |  | Total Cost
Spreadsheet: 142510d1329880807-conditional-weighted-average-ignoring-n-a-values-weighted-average-conditionl-with-error-sample2
Sheet: Sheet1

Occupation | [NAME] | Sample Size | Skilled |  | [NAME]: | =SUMPRODUCT(B2:B11,C2:C11,(D2:D11="Yes")+0)/SUMPRODUCT(C2:C11,(D2:D11="Yes")+0)
Customer Service Rep | 0.76 | 216 | No |  | Result:
Teller | 0.45 | 198 | No
Software Engineer | 0.88 | 250 | Yes |  | [NAME]: | {=SUM((B2:B11)*(C2:C11)*(D2:D11="Yes"))/SUM(C2:C11*(D2:D11="Yes"))}
#N/A | #N/A | #N/A | #N/A |  | Result:
#N/A | #N/A | #N/A | #N/A
Financial Manager | 0.65 | 651 | Yes
School Psychologist | 0.32 | 89 | Yes
Recreation Worker | 0.93 | 233 | No
#N/A | #N/A | #N/A | #N/A
Mapping Technician | 0.53 | 67 | Yes
Spreadsheet: 2fa9563a-37d6-48b9-95c7-07513f6ac478
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Project 89020152-3-Trails trail KC and Metro G
Is this ordinance for the following: |  |  |  | x | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  | FY 2011
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify source and amount.
 | Source of Funds: |  |  |  | National Parks Grant through 3-trail CID
 | Year Funded: |  |  |  | 2011
 | Amount of Non-City Funds: |  |  | $ | 30000
 | If no, please identify source and amount of city funds.
 | Acct #: |  |  |  | 3090-898601
 | Name of Fund: |  |  |  | CD6 Neighborhood Conservation
 | Year Funded: |  |  |  | 2011
 | Amount of City Funds: |  |  | $ | 100000
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 130000
 | Estimated lifespan of project in years |  |  | $ | 25
 | Estimated annual operating and maintenance costs |  |  | $ | 2000
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please please provide source of funds. |  |  |  | 1000-898077-89020142
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 57602d1257812324-data-valadition-one-list-populates-another-book1
Sheet: Sheet1

L Name | F Name | Month |  |  |  |  |  | [NAME] | [NAME] | Jan
 |  |  |  |  |  |  |  | [NAME] | Jon | Feb
 |  |  |  |  |  |  |  | [NAME] | [NAME] | Mar
 |  |  |  |  |  |  |  | [NAME] | Mark | Apr
 |  |  |  |  |  |  |  | Flores | [NAME] | May
 |  |  |  |  |  |  |  | Flores | [NAME] | Jun
 |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 878053d1725017857-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-providernames-updated
Sheet: TOTAL

 |  | Windknife | Count |  | JT | Count |  | TMS | Count
 |  | BAMBAM, F |  |  |  |  |  | ALBA, J
 |  | ALBA, J |  |  |  |  |  | ALBA, J
 |  | CLOONEY, G |  |  |  |  |  | BAMBAM, F
 |  | HANKS, T |  |  |  |  |  | BAMBAM, F
 |  | DE VITO, D |  |  |  |  |  | CLOONEY, G
 |  | WAYNE, B |  |  |  |  |  | CLOONEY, G
 |  | STARK, T |  |  |  |  |  | DE VITO, D
 |  | KYLE, S |  |  |  |  |  | FRED, B
 |  |  |  |  |  |  |  | FRED, B
 |  |  |  |  |  |  |  | HANKS, T
 |  |  |  |  |  |  |  | KYLE, S
 |  |  |  |  |  |  |  | STARK, T
 |  |  |  |  |  |  |  | STARK, T
 |  |  |  |  |  |  |  | WAYNE, B
Spreadsheet: 855457d1705008241-trying-to-return-matches-in-an-array-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | How many times they share items |  |  |  |  |  |  |  |  |  |  | How many times one has but the other does not |  |  |  |  |  |  |  |  |  |  | How many times they share not having items
 |  | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 |  |  |  | Location A | Location B | Location C | Location D | Location E | Location F | Location G | Location H | Location I |  |  | Location A | Location B | Location C | Location D | Location E | Location F | Location G | Location H | Location I |  |  | Location A | Location B | Location C | Location D | Location E | Location F | Location G | Location H | Location I
 | Location A | X | X | X |  | X | X | X | X | X | X |  |  | Location A |  |  |  |  |  |  |  |  |  |  | Location A |  |  |  |  |  |  |  |  |  |  | Location A
 | Location B | X | X | X |  |  | X |  | X |  |  |  |  | Location B |  |  |  |  |  |  |  |  |  |  | Location B |  |  |  |  |  |  |  |  |  |  | Location B
 | Location C |  |  |  |  |  |  |  | X |  |  |  |  | Location C |  |  |  |  |  |  |  |  |  |  | Location C |  |  |  |  |  |  |  |  |  |  | Location C
 | Location D |  | X |  |  | X | X |  | X | X |  |  |  | Location D |  |  |  |  |  |  |  |  |  |  | Location D |  |  |  |  |  |  |  |  |  |  | Location D
 | Location E |  |  | X | X |  |  | X | X |  | X |  |  | Location E |  |  |  |  |  |  |  |  |  |  | Location E |  |  |  |  |  |  |  |  |  |  | Location E
 | Location F |  |  | X | X | X | X |  | X |  |  |  |  | Location F |  |  |  |  |  |  |  |  |  |  | Location F |  |  |  |  |  |  |  |  |  |  | Location F
 | Location G | X |  |  |  |  |  | X | X |  | X |  |  | Location G |  |  |  |  |  |  |  |  |  |  | Location G |  |  |  |  |  |  |  |  |  |  | Location G
 | Location H |  | X | X |  |  | X |  |  |  |  |  |  | Location H |  |  |  |  |  |  |  |  |  |  | Location H |  |  |  |  |  |  |  |  |  |  | Location H
 | Location I |  |  |  |  | X | X | X |  |  |  |  |  | Location I |  |  |  |  |  |  |  |  |  |  | Location I |  |  |  |  |  |  |  |  |  |  | Location I
Spreadsheet: 845285d1696831404-carrying-forward-totals-from-sheet-1-to-sheet-2-error-record-sheet-wp-oct-23
Sheet: 10 OCT 23 

 | LPG PLANT DAILY STOCK RECORD SHEET
BOUESTEAD PETROLEUM MARKETING SDN BHD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE: 07/10/2023
VEHICLE NO. | RECEIPT FROM *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISSUE TO *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARKS | GATE PASS
 | BOTTLE |  |  |  |  |  |  |  |  |  |  |  |  | CYLINDERS |  |  | TYPE OF 50 KG |  |  |  | BOTTLE |  |  |  |  |  |  |  |  | BOTTLE |  | TYPE OF 50 KG
 | 12 KG |  |  |  | 14 KG |  | 14 KG PDB | 12 KG BT |  |  | 14 KG BLW |  |  | 50 KG |  |  |  |  |  |  | 12 KG |  | 14 KG |  | 14 KG PDB | 12 KG BT |  | 14 KG BLW |  | 50 KG
 | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | C | CLW | YT | [NAME] | FULL | EMPTY | FULL | EMPTY | FULL | FULL | EMPTY | FULL | EMPTY | FULL | EMPTY | C | CLW | YT | [NAME]
TOTAL
[NAME]
S/No | JENIS SILINDER DAN KATEGORY |  |  |  |  |  |  |  |  | 12 KG |  |  | 14 KG |  |  | 12 KG BT |  |  | 14 KG BLW |  |  | 50 KG OREN |  |  | 50 KG CLW |  |  | 50 KG YT |  |  | 50 KG YTW
1 | JUMLAH JUALAN [NAME]
2 | BOCOR ISI DITERIMA DARI [NAME]
3 | SILINDER ISI DITERIMA DARI [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0
4 | SILINDER DITERIMA DARI PETRONAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
PEMBUKAAN DAN PENUTUPAN BUKU STOK UNTUK HARI INI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR MANUAL UPDATE
1 | Type |  | 12 KG |  |  |  | 14 KG |  |  |  | 12 KG BT |  |  |  | 14 KG BLW |  |  |  | 50 KG |  |  |  | 50 KG ORANGE |  |  |  | 50 KG CLW |  |  |  | 50 KG YT |  |  |  | 50 KG YTW
2 | Opening
3 | Category |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi |  | Kosong |  | Isi
 |  |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
4 | Total
5 | Grand Total
6 | Closing
 | 1222
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: February

` | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00 |  |  |  |  | Total Hours
[NAME]
Scott
Adam
 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 122372d1316772627-sum-by-month-week-etc-to-date-in-a-log-summary
Sheet: Sheet1

Summary
 |  | Falories | Fat | Diet
Today | 2011-09-23 00:00:00 | 2 | 3 | 4
WeekToDate | 2011-09-19 00:00:00 | 7 | 7 | 10
MonthToDate | 2011-09-01 00:00:00 | 10 | 18 | 20
MonthToDate | 2011-09-01 00:00:00 | 10 | 18 | 20