tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 262780d1378287675-lookup-multiple-rows-where-2-conditions-must-be-met-pivotdgt
Sheet: Sheet1

ID | Team | Date
7736 | A | 2013-09-03 00:00:00
7775 | B | 2013-09-03 00:00:00 |  |  | Team | Date | ID
7795 | A | 2013-09-03 00:00:00 |  |  | A | 2013-09-03 00:00:00 | 7736
7860 | C | 2013-09-04 00:00:00 |  |  |  |  | 7795
7414 | D | 2013-09-04 00:00:00 |  |  | B | 2013-09-03 00:00:00 | 7775
7448 | D | 2013-09-04 00:00:00 |  |  | C | 2013-09-04 00:00:00 | 7860
7591 | D | 2013-09-04 00:00:00 |  |  | D | 2013-09-04 00:00:00 | 7414
7742 | D | 2013-09-04 00:00:00 |  |  |  |  | 7448
7760 | D | 2013-09-04 00:00:00 |  |  |  |  | 7591
7761 | D | 2013-09-05 00:00:00 |  |  |  |  | 7742
7767 | D | 2013-09-05 00:00:00 |  |  |  |  | 7760
7783 | D | 2013-09-05 00:00:00 |  |  |  | 2013-09-05 00:00:00 | 7761
7814 | D | 2013-09-05 00:00:00 |  |  |  |  | 7767
 |  |  |  |  |  |  | 7783
 |  |  |  |  |  |  | 7814
 |  |  |  |  | Grand Total
Spreadsheet: 97003d1296222733-onclick-event-on-excel-cell-query_new
Sheet: BorrowerDetails

 | First Name | Last Name | Address | City | State | Zip
 | [NAME] | Kfdtestit | ABC | Alabaster Town | AL | 35007
 | [NAME] | Kfdtestit | ABC | Alabaster Town | AL | 35007
 | Arris | Kfdtestit | ABC | Little [NAME] | AR | 72201
 | [NAME] | Kfdtestit | ABC | Little [NAME] | AR | 72201
 | Akron | Kfdtestit | ABC | Anchorage Town | AK | 99501
 | Aki | Kfdtestit | ABC | Anchorage Town | AK | 99501
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: Sheet1

 |  |  |  | NON-CAMPING SALES CASH OUT
 |  |  |  |  |  |  |  |  |  |  |  |  | WORKSHEET
 |  |  |  |  |  |  | Cash Out #: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash Out #
 | PREPARED BY: |  |  |  |  |  |  |  |  |  |  |  | PREPARED BY: |  |  |  |  |  | DEPARTMENT:
 | OPENING DATE: |  | 2013-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | OPENING DATE: |  |  |  |  |  | CLOSING DATE:
 |  |  |  |  |  |  |  | Season |  |  |  |  |  |  | Begin#/ | End# | Dump | C | Day Use | C |  | C | Season | C
 |  |  | Begin#/ |  | Dump | Day Use | Wood | Pass |  |  |  |  |  |  | Receipt# |  | Fee | CK | Fee | CK | Wood | CK | Pass | CK
 | Date: |  | Receipt# | End # | Fee | Fee | 5230 | 5205 |  |  |  |  |  |  |  |  |  |  | 5125 |  | 5230 |  | 5205
1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2013-02-14 00:00:00 | 1 |  | 15 | C |  | C
2 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2013-02-15 00:00:00 | 2 | 6 |  | C | 25 | C
3 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2013-02-15 00:00:00 | 7 | 12 |  |  |  |  | 36 | CK
4 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2013-02-16 00:00:00 | 13 |  |  |  |  |  |  |  | 50 | CK
5 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2013-02-14 00:00:00 | 14 |  | 15 | CK
6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2013-02-17 00:00:00 | 15 | 16 |  |  | 10 | CK
7 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2013-02-18 00:00:00 | 17 | 19 |  |  |  |  | 18 | C | 50 | C
8 |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  | 21
 | TOTALS THIS PAGE |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS THIS PAGE
 | Totals Page 2 to: |  |  |  |  |  |  |  |  |  |  |  |  | Totals Page 2 to ____
 | GRAND TOTALS: |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTALS:
 | NET SALES: |  |  |  |  |  |  |  |  |  |  |  |  | NET SALES
 | Sales Tax:"%" |  | 0.07 |  |  |  |  |  |  |  |  |  |  | Sales Tax: "%" |  | 0.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Camping Sales Cash Out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash |  | Check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00
Spreadsheet: 703519d1605028779-aggregating-values-for-id-with-conditions-sampi
Sheet: Sheet1

ID | VALUE: | BAL: | AGG BAL: | COUNT:
111 | Grass | 100 | 250 | 3
111 | Weed | 50 | 250 | 3
222 | WeedGrass | 25 | 25 | 1
222 |  | 0 | 25 | 1
111 | Grass | 100 | 250 | 3
333 | Grass | 100 | 100 | 1
444 | Weed | 50 | 0 | 0
555 |  | 0 | 0 | 0
Spreadsheet: 709980d1608649336-specific-time-how-many-times-numbers-coming-in-column-in-excel-example
Sheet: Sheet1

Date | Numbers |  | 1995 | 2020
2020-12-06 00:00:00 | 17 28 39 37 38 |  | No | Times | How many time each number coming from 1995 to 2020
2020-12-05 00:00:00 | 16 21 22 23 38
2020-12-04 00:00:00 | 38 23 37 17 20
1999-08-03 00:00:00 | 02 14 35 38 29
1996-08-03 00:00:00 | 07 23 25 34 36
1995-08-03 00:00:00 | 09 31 27 32 23
1990-08-03 00:00:00 | 14 20 24 19 24
2001-07-08 00:00:00 | 07 08 11 12 14
2005-09-04 00:00:00 | 01 17 18 12 19
Spreadsheet: 138685d1327834139-calculate-total-sums-from-multiple-text-entries-example-monthly-expenses-tracking
Sheet: Integra Options

 | Integra
 | Current Triple Play | Proposed Double Play | Proposed Previous Plan
2011-09-11 00:00:00 | 163 | 140 | 78
2011-10-11 00:00:00 | 163 | 140 | 78
2011-11-11 00:00:00 | 163 | 140 | 78
2011-12-11 00:00:00 | 163 | 140 | 78
2011-01-12 00:00:00 | 163 | 140 | 78
2011-02-12 00:00:00 | 163 | 140 | 78
2011-03-12 00:00:00 | 163 | 140 | 78
2011-04-12 00:00:00 | 163 | 140 | 78
2011-05-12 00:00:00 | 163 | 140 | 78
2011-06-12 00:00:00 | 163 | 140 | 78
2011-07-12 00:00:00 | 163 | 140 | 78
2011-08-12 00:00:00 | 163 | 140 | 78
2011-09-12 00:00:00 | 163 | 140 | 78
2011-10-12 00:00:00 | 163 | 140 | 78
2011-11-12 00:00:00 | 163 | 140 | 78
2011-12-12 00:00:00 | 163 | 140 | 78
2011-01-13 00:00:00 | 163 | 140 | 78
2011-02-13 00:00:00 | 163 | 140 | 78
2011-03-13 00:00:00 | 163 | 140 | 78
 | 3097 | 2660 | 1482
Per Month Savings |  | 23 | 85
Total Contract Savings |  | 437 | 1615
$300 Early Termination |  |  | 1315
Spreadsheet: jeff_dasovich__14253__Pricing
Sheet: Sheet1

Item | Monthly Recurring Cost | Non-Recurring Cost
Cisco 6509 Switch - Westin | 500 | 100000
Cisco 6509 Switch - Level-3 | 500 | 100000
Dark Fiber between Westin & Level-3 | 5000 | 5000
[NAME] from 11th to 19th | 1000 | 2000
[NAME] from 13th to 19th | 1000 | 2000
Colocation Rack @ Level-3 | 1000 | 1000
Total
Spreadsheet: 166459d1341590459-excel-2007-automnatically-copy-formula-to-next-row-when-a-cell-is-populated-in-that-row-excel-q
Sheet: Sheet1

 |  | Question1 |  |  |  | Question2 |  |  |  | Question3 |  |  |  | Question4
Number | Load (Yes / No) | Q1 | Q2 | Q3 | A4 | Q4 | Q1 | Q2 | A5 | Q3 | Q4 | Q1 | A6 | Q1 | Q2 | Q3 | Q4 | Yes | No | N/A
 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
Spreadsheet: 71830d1272539944-excel-2007-sales-and-stock-register-spreadsheet-projectv2-tw-
Sheet: Stocktable

 | STOCKTABLE
 | Barcode | product description | unit price | Sold |  | Restock |  | stock
 | 101 | Coke | 0.59 | 3 | 3 | 12 | 12 | 59
 | 102 | fanta | 0.59 | #N/A | 0 | 10 | 10 | 70
 | 103 | crisps | 0.35 | 4 | 4 | 20 | 20 | 116
Spreadsheet: 189781d1351347704-repeating-the-calculations-every-x-column-example
Sheet: Calcs

 | Unit 1 |  | Unit 2 |  | Unit 3 |  | Unit 4 |  | Unit 5 |  | Unit 6 |  | Unit 7 |  | Unit 8 |  | Unit 9 |  | Unit 10
 | % | m | % | m | % | m | % | m | % | m | % | m | % | m | % | m | % | m | % | m
Spreadsheet: jeffrey_a_shankman__13934__MgmtSum-Q401-Global-111601
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
2001 EARNINGS ESTIMATE
4th QUARTER YTD
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East (1Q01 only)
Puerto Rico
Japan
Drift
Finance and Structuring
Office of the Chairman
Overview
Total Commercial
Credit Reserve |  |  |  |  |  |  |  | 0
Financing Related |  |  |  |  |  |  |  | 0
Group Cost
Support Cost Allocated to Teams
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes direct and allocated expenses
Spreadsheet: sally_beck__33827__Global Mkt_Plan
Sheet: Settlements & Confirms

 |  |  |  |  |  | ENERGY OPERATIONS |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J
 |  |  |  |  |  | Plan 2001
Cycle |  |  |  |  | Name | CC Number | CC Owner | CC Name |  |  |  | Global Markets | Global Markets | Global Crude & Products | Coal | Emissions | Currency | Equities | Interest Rate | Agricultural Trading | Insurance | Weather | Global Products Trading | Caribbean / Middle East
 |  |  |  |  |  | SETTLEMENTS AND CONFIRMATIONS
Cycle 6 |  |  |  |  | NAEODC80 | 105585 | [NAME] | NA-Energy Ops Emerging Conirmations |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0 | 0
Cycle 3 |  |  |  |  | NAEODC34 | 105612 | [NAME] | NA-Energy Ops Financial Confirmations |  | 887038 |  |  | 0.12 |  |  |  |  |  |  |  |  |  | 0.15 | 0
Cycle 3 |  |  |  |  | NAEODC35 | 105613 | [NAME] | NA-Energy Ops Financial Statements |  | 51312 |  |  | 0.12 |  |  |  |  |  |  |  |  |  | 0.11 | 0
Spreadsheet: 465490d1465698131-join-pages-potholes
Sheet: Master

 |  |  |  | As of
 |  |  | UOM | Brand |  | Price | GST |  | QTY Ordered | $$  Sub Total
Spreadsheet: 697646d1601465171-sum-if-calculation-jsd-tablet-format-tally
Sheet: Sheet1

Vessel : |  |  | ACORN INS237 |  |  |  |  |  | Total
Date: |  |  | 2019-04-25 00:00:00 |  |  |  |  |  | Boxes
 |  |  |  | Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | Price Per Kg
 |  |  |  |  |  |  |  | Boxes | Weight | Cost
COD | C1 | 1.5 |  | CPM | COD | GH | C1 | 1.5 | 33 | 108
 | C2 | 4 |  | CPM | COD | GH | C2 | 4 | 33 | 112
 | [NAME] | 3.5 |  | JPL | COD | GH | [NAME] | 3.5 | 33 | 110
 | C4 | 2.5 |  | WC | COD | GH | C4 | 2.5 | 33 | 80
 | C5 | 1 |  | HD | COD | GH | C5 | 1 | 40 | 96
 | C6 | 1.75 |  | HD | COD | GH | C6 | 1.75 | 40 | 96
HADDOCK | H0 |  |  | WC | HAD | GH | H4 | 7 | 45 | 92
 | H1 |  |  | JPL | HAD | GH | H5 | 6 | 45 | 90
 | H2 |  |  | CPM | HAD | GH | H5 | 5 | 45 | 90
 | H3 |  |  | WC | HAD | GH | H5 | 5 | 45 | 78
 | H4 | 7 |  | WC | HAD | GH | H5 | 0.25 | 45 | 0
 | H5 | 33.25 |  | WC | HAD | GH | H5 | 1 | 45 | 75
 | H6 | 141 |  | HD | HAD | GH | H5 | 16 | 45 | 75
 | HR | 48 |  | HD | HAD | GH | H6 | 15 | 45 | 40
Whiting | W1 |  |  | HH | HAD | GH | H6 | 1 | 45 | 40
 | [NAME] | 1.75 |  | BL | HAD | GH | H6 | 30 | 45 | 40
 | W3 |  |  | HD | HAD | GH | H6 | 15 | 45 | 38
 | W4 |  |  | L15 | HAD | GH | H6 | 80 | 45 | 36
 | WR | 9 |  | L15 | HAD | WF | HR | 48 | 45 | 34
Hake | HK0 |  |  | WC | WHG | GH | [NAME] | 1.75 | 45 | 80
 | HK1
 | HK2 |  |  | WT | WHG | WF | WR | 9 | 45 | 62
 | HK3 |  |  | HD | LEM | GH | LS2 | 1 | 40 | 230
 | HK4 | 1 |  | BL | LEM | GH | LS3 | 1 | 40 | 180
 | HK5 |  |  | PWELL | LEM | GH | LS3 | 0.5 | 40 | 180
Saithe | S0 |  |  | HD | LEM | GH | LS3 | 2 | 40 | 175
 | S1 |  |  | PWELL | PLE | GH | P2 | 1 | 20 | 40
 | S2 |  |  | BL | PLE | GH | P3 | 2 | 40 | 74
 | S3 |  |  | WC | PLE | GH | P4 | 9.5 | 40 | 46
 | [NAME] | 1 |  | BL | ANF | GH | M3 | 1 | 20 | 70
Ling | L1 |  |  | JPL | ANF | GH | M4 | 1 | 12 | 62
 | L2 | 1 |  | WT | ANF | GH | M5 | 1 | 24 | 82
 | L3 |  |  | WL | LEZ | GH | MG3 | 1.5 | 40 | 105
Monk | M0 |  |  | PWELL | HKE | GH | HK4 | 1 | 9 | 30
 | M1 |  |  | BL | POK | GH | [NAME] | 1 | 11 | 5
 | M2 |  |  | PWELL | GUR | WF | GUG | 1 | 25 | 35
 | M3 | 1 |  | HD | SQC | WF | SQ4 | 1 | 33 | 270
 | M4 | 1 |  | WL | LIN | GH | L2 | 1 | 8 | 5
 | M5 | 1 |  | BL | WIT | GH | WIT | 1 | 5 | 5
Megrim | MG0
 | MG1
 | MG2
 | MG3 | 1.5
 | MG4
 | MGB
Plaice | P1
 | P2 | 1
 | P3 | 2
 | P4 | 9.5
Lemons | [NAME]
 | LS2 | 1
 | LS3 | 3.5
Skate | SK1
 | SK2
 | SK3
 | SK4
ROKER | R1
 | R2
 | R3
 | R4
Squid | SQ1
 | SQ2
 | SQ3
 | SQ4 | 1
Lythe | LY1
 | LY2
 | LY3
 | LY4
 | TBT
 | HBT
 | BRL
 | [NAME]
 | USK
 | MIX
 | WIT | 1
 | GUG | 1
Spreadsheet: 266549d1379659680-comparing-2-spreadsheets-to-get-data-on-1-forum-work-book
Sheet: invoice

Recipient Created Tax Invoice
TO: | [NAME] |  |  |  |  | FROM: | Super Heros Inc
 | Never Never Land
 | ABN - 11111111 |  |  |  |  |  | ABN -22222222
 | Creditor # 6599 |  |  |  |  | Date: | 2013-09-06 00:00:00
 |  |  |  |  |  | Invoice #
 | DETAILS |  |  |  |  |  | GST | TOTAL
 | Red Dog | 50022
 | Adult Super Hero
 | G/L - 6632.1155.2
 | Less BCITF Subsidy
 | Net Invoice
 | GST
 | Total payable inclusive of GST
Spreadsheet: 72147d1272877231-fill-a-column-with-the-same-formula-as-previous-cell-no-blank-book3
Sheet: Sheet1

Date | Code |  | Date | Value |  | Date | Value
2002-01-01 00:00:00 | aa |  | 2002-01-01 00:00:00 |  |  | 2002-01-01 00:00:00
2002-01-02 00:00:00 |  |  | 2002-01-02 00:00:00 |  |  | 2002-01-02 00:00:00
2002-01-03 00:00:00 |  |  | 2002-01-03 00:00:00 |  |  | 2002-01-03 00:00:00
2002-01-04 00:00:00 |  |  | 2002-01-04 00:00:00 |  |  | 2002-01-04 00:00:00
2002-01-05 00:00:00 |  |  | 2002-01-05 00:00:00 |  |  | 2002-01-05 00:00:00
2002-01-06 00:00:00 |  |  | 2002-01-06 00:00:00 |  |  | 2002-01-06 00:00:00
2002-01-07 00:00:00 |  |  | 2002-01-07 00:00:00 |  |  | 2002-01-07 00:00:00
2002-01-08 00:00:00 |  |  | 2002-01-08 00:00:00 |  |  | 2002-01-08 00:00:00
2002-01-09 00:00:00 |  |  | 2002-01-09 00:00:00 |  |  | 2002-01-09 00:00:00
2002-01-10 00:00:00 | bb |  | 2002-01-10 00:00:00 |  |  | 2002-01-10 00:00:00
2002-01-11 00:00:00 |  |  | 2002-01-11 00:00:00 |  |  | 2002-01-11 00:00:00
2002-01-12 00:00:00 |  |  | 2002-01-12 00:00:00 |  |  | 2002-01-12 00:00:00
2002-01-13 00:00:00 |  |  | 2002-01-13 00:00:00 |  |  | 2002-01-13 00:00:00
2002-01-14 00:00:00 |  |  | 2002-01-14 00:00:00 |  |  | 2002-01-14 00:00:00
2002-01-15 00:00:00 |  |  | 2002-01-15 00:00:00 |  |  | 2002-01-15 00:00:00
2002-01-16 00:00:00 | cc |  | 2002-01-16 00:00:00 |  |  | 2002-01-16 00:00:00 | MISS
2002-01-17 00:00:00 |  |  | 2002-01-17 00:00:00 |  |  | 2002-01-17 00:00:00 | MISS
2002-01-18 00:00:00 |  |  | 2002-01-18 00:00:00 |  |  | 2002-01-18 00:00:00 | MISS
 |  |  |  |  |  | expected result
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: HEAD

Old course number | New course number
HEAD-618 | HEAD-6618
HEAD-621 | [NAME]
HEAD-625 | HEAD-6625
HEAD-713 | HEAD-7713
HEAD-731 | HEAD-7731
HEAD-823 | HEAD-8823
HEAD-832 | HEAD-8832
HEAD-833 | HEAD-8833
HEAD-834 | [NAME]
HEAD-835 | HEAD-8835
HEAD-850 | HEAD-8850
Spreadsheet: 688500d1595833106-frequency-formula-required-book12
Sheet: Sheet1

Product | [NAME] | [NAME] | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10
A | 2 | 100 | 0 | 0 | 100 | 0 | 100 | 0 | 0 | 100 | 0 | 100
B | 3 | 200 | 0 | 0 | 200 | 0 | 0 | 200 | 0 | 0 | 200 | 0
C | 4 | 500 | 0 | 0 | 500 | 0 | 0 | 0 | 500 | 0 | 0 | 0
Product | [NAME] | [NAME] | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10
A | 2 | 100 | 0 | 0 | 100
B | 3 | 200 | 0 | 0 | 200
C | 4 | 500 | 0 | 0 | 500
Spreadsheet: 717159d1612516529-mini-league-tables-rank
Sheet: Sheet1

 | Rank | Part | Description | Value | Cost | QTY | Tool # | Tool Changes | OPPS
AM Shift | 1 | 72210101 | HRS BLK 12" PLASTIC TRAY | 861.5999999999999 | 0.718 | 1200 | 59 |  |  |  |  |  |  | Shift | QTY
AM Shift | 2 | 72100480 | TRI WHT ASY SA BACKPLATE | 662.4 | 0.92 | 720 | 65 |  |  |  |  |  | 1st | AM SHFT | 10732
AM Shift | 3 | 72100128 | TRI WHT BACKPKLATE | 592.8000000000001 | 0.78 | 760 | 56 |  |  |  |  |  | 2nd | NIGHTS | 1592
AM Shift | 4 | 72100450 | TRI WHT ASSY COVER & DL | 467.0999999999999 | 1.557 | 300 | 41 |  |  |  |  |  | 3rd
AM Shift | 5 | 72100125 | JOS CLR SOAP DISH | 354 | 0.295 | 1200 | 34
AM Shift | 6 | 72100148 | TRI WHT BACKPLATE | 326.4 | 1.7 | 192 | 73 |  |  |  |  |  |  | Shift | [NAME]
AM Shift | 7 | 72500106 | LWB RH  UPPER FINISHER | 129.168 | 0.7176 | 180 | 9 |  |  |  |  |  | 1st | AM SHFT | 10
AM Shift | 8 | 72500105 | LWB LH  UPPER FINISHER | 129.168 | 0.7176 | 180 | 9 |  |  |  |  |  | 2nd | NIGHTS | 9
AM Shift | 9 | 72100112 | AAR WHT LOCATION BODY | 109.8 | 0.0915 | 1200 | 12 |  |  |  |  |  | 3rd | PM SHIFT | 3
AM Shift | 10 | 72100113 | AAR WHT BRACKET BODY | 109.8 | 0.0915 | 1200 | 13
AM Shift | 11 | 72100111 | AAR WHT CAP |  | 0.0592 | 3600 | 6 |  |  |  |  |  |  | Shift | Value
AM Shift | 12 |  |  |  |  |  |  |  |  |  |  |  | 1st | NIGHTS | 4655.416
AM Shift | 13 |  |  |  |  |  |  |  |  |  |  |  | 2nd | AM Shift | 3742.236000000001
AM Shift | 14 |  |  |  |  |  |  |  |  |  |  |  | 3rd | PM Shift | 1501.28
AM Shift | 15
 |  |  |  | 3742.236000000001 |  | 10732 Parts | 10
 | Rank | Part | Description | Value | Cost | QTY | Tool # | Tool Changes | OPPS
PM Shift | 1 | 72210101 | HRS BLK 12" PLASTIC TRAY | 574.4 | 0.718 | 800 | 59
PM Shift | 2 | 72100148 | TRI WHT BACKPLATE | 571.1999999999999 | 1.7 | 336 | 73
PM Shift | 3 | 72100128 | TRI WHT BACKPKLATE | 355.68 | 0.78 | 456 | 56
PM Shift | 4
PM Shift | 5
PM Shift | 6
PM Shift | 7
PM Shift | 8
PM Shift | 9
PM Shift | 10
PM Shift | 11
PM Shift | 12
PM Shift | 13
PM Shift | 14
PM Shift | 15
 |  |  |  | 1501.28 |  | 1592 Parts | 3
 | Rank | Part | Description | Value | Cost | QTY | Tool # | Tool Changes | OPPS
NIGHTS | 1 | 72500106 | LWB RH  UPPER FINISHER | 1119.456 | 0.7176 | 1560 | 9
NIGHTS | 2 | 72500105 | LWB LH  UPPER FINISHER | 1076.4 | 0.7176 | 1500 | 9
NIGHTS | 3 | 72100148 | TRI WHT BACKPLATE | 897.5999999999999 | 1.7 | 528 | 73
NIGHTS | 4 | 72210101 | HRS BLK 12" PLASTIC TRAY | 574.4 | 0.718 | 800 | 59
NIGHTS | 5 | 72300101 | TEC     METER HOUSING | 307.8 | 0.57 | 540 | 4
NIGHTS | 6 | 72100125 | JOS CLR SOAP DISH | 236 | 0.295 | 800 | 34
NIGHTS | 7 | 72100111 | AAR WHT CAP | 142.08 | 0.0592 | 2400 | 6
NIGHTS | 8 | 72100112 | AAR WHT LOCATION BODY | 109.8 | 0.0915 | 1200 | 12
NIGHTS | 9 | 72100113 | AAR WHT BRACKET BODY | 109.8 | 0.0915 | 1200 | 13
NIGHTS | 10 | 72500101 | [NAME]  UPPER FINISHER | 41.04000000000001 | 0.684 | 60 | 23
NIGHTS | 11 | 72500102 | [NAME] | 41.04000000000001 | 0.684 | 60 | 23
NIGHTS | 12
NIGHTS | 13
NIGHTS | 14
NIGHTS | 15
 |  |  |  | 4655.416 |  | 10648 Parts | 9
Spreadsheet: 65f79eb4-fbd7-4bee-b4b0-18a1d55cd7fc
Sheet: Sheet1

บัญชีรายชื่อพนักงานเทศบาลที่ผ่านทดลองการปฏิบัติหน้าที่ราชการ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
ตามมติการประชุม ก.ท.จ.ฉะเชิงเทรา ครั้งที่ 8/2552 วันที่ 25 สิงหาคม  2552 (แนบวาระ 3.1)
ที่ | เทศบาล | อำเภอ | ชื่อ - สกุล |  | ตำแหน่ง | เริ่มรับราชการ | ผ่านการทดลอง | [NAME] | [NAME] | มติ ก.ท.จ.
 |  |  |  |  |  | เมื่อวันที่ | เมื่อวันที่ | เมื่อวันที่
1 | บางคล้า | บางคล้า | น.ส.นฤมล | อัศวชัยยง | บุคลากร 3 | 16 ม.ค. 2552 | 15 ก.ค. 2552 | 17 ก.ค. 2552 | 22 ก.ค. 2552 | รับทราบ
2 | เกาะขนุน | พนมสารคาม | น.ส.ทัศนีย์ | แซ่ฮึง | ช่างภาพ 1 | 16 ธ.ค. 2551 | 15 มิ.ย. 2552 | 22 มิ.ย. 2552 | 24 มิ.ย. 2552 | รับทราบ
Spreadsheet: 15a1cdc0-0b2d-4a79-b87c-f8410526717d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
NAME: |  |  |  |  |  |  | (time format - 8 am, 5:30 pm or military format - 17:30)
 | Regular Duty Sunday | Regular Duty Monday | Regular Duty Tuesday | Regular Duty Wednesday | Regular Duty Thursday | Regular Duty Friday | Regular Duty Saturday
Date
Start Time
End Time
(A)Total Hours in Hospital Regular Duty | 0 | 0 | 0 | 0 | 0 | 0 | 0
The section below pertains to coming into the hospital from at home call - only count actual time spent in hospital.
 | In-Hospital Call Sunday | In-Hospital Call Monday | In-Hospital Call Tuesday | In-Hospital Call Wednesday | In-Hospital Call Thursday | In-Hospital Call Friday | In-Hospital Call Saturday
Start Time
End Time
(B)Total Hours in Hospital from At-Home Call | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Moonlighting Sunday | Moonlighting Monday | Moonlighting Tuesday | Moonlighting Wednesday | Moonlighting Thursday | Moonlighting Friday | Moonlighting Saturday
Start Time
End Time
(B)Total Hours in Hospital from At-Home Call | 0 | 0 | 0 | 0 | 0 | 0 | 0
Resident/fellows must answer these questions before turning in the time sheet for the week:
Weekly in-hospital hours |  | 0
Using section (A) only, were there any dates where you did not have 10 hours off between shifts? |  |  |  |  |  |  | yes/no
If yes, which days?
Did you have one or more 24 hour periods free from clinical responsibilities during this week? |  |  |  |  |  |  | yes/no
If yes, which days?
Were there any days during the week when you worked in the hospital more than 30 continuous hours? |  |  |  |  |  |  | yes/no
If yes, which days?
Did you take in-hospital call no more frequently than every third night? |  |  |  |  |  |  | yes/no
If yes, which days?
Have you engaged in any moonlighting activities in the past 12 months or anytime during residency/fellowship? |  |  |  |  |  |  | yes/no
If yes, please provide a report of locations, dates, and time spent on each date since the last report.
Spreadsheet: 836139d1689121076-please-provide-the-3-required-formulas-according-to-expected-results-in-table-vlockup-formula
Sheet: Sheet1

Data |  | Expected | Expected | Expected
Old | New | In Old But Not In New | In New But Not In Old | In Both Old And New
1 | 7 |  | 7 | 1
2 | 1 | 2
3 | 9 |  | 9 | 3
4 | 3
5 | 11 | 5 | 11
6 | 4 | 6 |  | 4
 |  | VLOOKUP | VLOOKUP | VLOOKUP
 |  | 5 | 9 | 3
 |  | 6 | 11 | 4
Spreadsheet: 22532ff4-f816-477a-93ba-5754fcf2999e
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Project #62080330 - Airfield Pavement Repairs
 | Amendment No. 3
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  |  |  |  | FY
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: |  |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  |  |  |  | FY
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: |  |  |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date