tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 30418d1225918736-categorizing-labels-gvb_lookup_example
Sheet: Sheet3

Sigma 70-200 |  | 750
Sigma 28-70 |  | 340
 |  | 800
 |  | 1890
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  | 10
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Spreadsheet: kimberly_watson__20614__02CapPlan_8_22_01
Sheet: Depreciation

NORTHERN NATURAL GAS
2002 - 2003 OPERATING & STRATEGIC PLAN
DEPRECIATION FROM CAPITAL - COMMERCIAL GROUP
 |  |  |  |  |  |  |  |  |  |  | 2002 |  | 2003
 |  |  |  |  |  |  |  |  |  |  | ($[NAME]) |  | ($[NAME])
 | Estimated Depreciation from 2001 Capital
 |  | Total Capital Spent in 2001 |  |  |  |  |  | 22000000
 |  | Depreciation Rate / Transmission-Onshore |  |  |  |  |  | 0.0115
 |  | Total Depreciation for 2002
 | Estimated Depreciation from 2002 Capital
 |  | Total Capital Spent in 2002 |  |  |  |  |  | 35270000
 |  | Depreciation Rate / Transmission-Onshore |  |  |  |  |  | 0.0115
 |  | Total Depreciation
 |  | Only November & December in-service for 2002
 | Estimated Depreciation from 2003 Capital
 |  | Total Capital Spent in 2003 |  |  |  |  |  | 20300000
 |  | Depreciation Rate / Transmission-Onshore |  |  |  |  |  | 0.0115
 |  | Total Depreciation
 |  | Only November & December in-service for 2003
 |  |  |  |  | Total Depreciation by Year
Spreadsheet: 011a1157-923e-4cec-bead-117c10ea17a6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Lewis & Clark College |  | Destination : |  |  | Name: |  |  | Mail   ______
Travel & Entertainment Expense Report |  | Dates of Travel: |  |  | Address: |  |  | Pick-Up ______
 |  | Purpose of Travel:
 |  | Supervisor Travel Authorization:
TRAVEL: | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Totals
Date:
Destination:
Airfare |  |  |  |  |  |  |  | 0
Auto Mileage @ $0.51 |  |  |  |  |  |  |  | 0
Taxi, Car Rental |  |  |  |  |  |  |  | 0
Lodging |  |  |  |  |  |  |  | 0
Breakfast (see below) |  |  |  |  |  |  |  | 0
[NAME] (see below) |  |  |  |  |  |  |  | 0
Dinner (see below) |  |  |  |  |  |  |  | 0
Other |  |  |  |  |  |  |  | 0
Entertainment (Complete Below) |  |  |  |  |  |  |  | 0
Totals: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ENTERTAINMENT: | (details to support entry above)
Date |  | Company/Individual |  |  | Description, Including Business Purpose |  |  | Amount
Per Diem Meal Rates for Travel Within the US: |  | Breakfast | Lunch | Dinner | Total
Full Day, High Cost Areas (see below) |  | 10 | 15 | 25 | 50 | Maximum total of $37.50 for departing and returning days
Full Day, All Other Areas |  | 8 | 12 | 20 | 40 | Maximum total of $30.00 for departing and returning days
High Cost Metropolitan Areas:
Baltimore, Boston, Chicago, New York City, Philadelphia, |  |  |  |  |  | Cash Summary
San Francisco, Seattle, Washington D.C. |  |  | Reimbursement Approval |  |  | Total Cost of Trip |  | 0
High Cost States: |  |  | Supervisor Authorization: |  | Date | Less Items Charged to College
Alaska and Hawaii |  |  |  |  |  |  | Airfare
 |  |  | Account |  | Amount
I hereby certify that all expenses on this report were incurred for [NAME]
& Clark business purposes and conform to the College Travel and |  |  |  |  |  | Total Paid by [NAME] |  | 0
Entertainment Policy. |  |  |  |  |  | Less: Travel Advances
 |  |  |  |  |  | Amount to be Reimbursed |  | 0
 |  |  |  |  |  | [NAME] to Cashiers
[NAME]'s signature |  | Date |  |  |  | (Attach receipt)
Spreadsheet: 108742d1305733201-formulas-not-working-or-is-the-sheet-not-functioning-copy-of-sic-sow-diary
Sheet: May Fliped

Date | 2011-05-01 00:00:00 | 2011-05-02 00:00:00 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 2011-05-05 00:00:00 | 2011-05-06 00:00:00 | 2011-05-07 00:00:00 | 2011-05-08 00:00:00 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00 | 2011-05-15 00:00:00 | 2011-05-16 00:00:00 | 2011-05-17 00:00:00 | 2011-05-18 00:00:00 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-21 00:00:00 | 2011-05-22 00:00:00 | 2011-05-23 00:00:00 | 2011-05-24 00:00:00 | 2011-05-25 00:00:00 | 2011-05-26 00:00:00 | 2011-05-27 00:00:00 | 2011-05-28 00:00:00 | 2011-05-29 00:00:00 | 2011-05-30 00:00:00 | 2011-05-31 00:00:00
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 426958-276442 | 374823-180259
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Complete
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 420239-267620 | 416273-257139 blck
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete | Start
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 415176-293214 | 422599 JH civs
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 434796-293353 | 437948-301415
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Complete
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 431173-292340
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 436357-296793 sched
Action
Did you meet?
Customer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 362955-160066
Action |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Customer
Action
Did you meet?
Spreadsheet: 798908d1664808394-what-formula-to-use-for-summary-data-ot
Sheet: Summary

 | 95A |  |  |  | 95A
 | Friday | 2 | [NAME]
 | Saturday | 10 | [NAME]
 | 95B
 | Friday | 9 | [NAME]
 | Saturday | 10 | [NAME]
 | Wednesday | 21 | someone
Spreadsheet: 795869d1662986172-googlesheets-count-number-of-days-between-days-listed-in-text-days_leadtime-hd1-1-
Sheet: Sheet1

 |  |  |  | Desired Output |  |  | HD
Collection Day | Train Departure Day | Train Arrival Day | Delivery Day | Lead Days (incl weekends) | Lead Days (exc weekends) |  | Lead Days (incl weekends) | Lead Days (excl. weekends)
1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-07 00:00:00 | 1900-01-02 00:00:00 | 7 | 5
1900-01-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 9 | 7
1900-01-02 00:00:00 | 1900-01-02 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 5 | 5
1900-01-06 00:00:00 | 1900-01-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-05 00:00:00
Lead Days = number of days between collection day and delivery day
collection day = Day 1
Day
1900-01-02 00:00:00
1900-01-03 00:00:00
1900-01-04 00:00:00
1900-01-05 00:00:00
1900-01-06 00:00:00
1900-01-07 00:00:00
Spreadsheet: 121548d1316137781-pivot-table-to-roll-up-data-and-display-in-pivot-chart-tickets
Sheet: Sheet4

Average of Duration
Assigned To | Total |  | Average Time Spent on Tickets per day
[NAME] | 1.75 |  |  | 1.75
[NAME] | 1.125 |  |  | 1.125
[NAME] | 3 |  |  | 3
[NAME] | 1.375 |  |  | 2.75
 |  |  |  | (copied and pasted the values above before changing)
Row Labels | Average of Duration*Count
[NAME] | 1.75
[NAME] | 1.125
[NAME] | 3
[NAME] | 2.75
Grand Total | 2.275
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 1st

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 561645cb-69cf-416c-82be-1e368e186916
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Mid Bay for 2010
Indicator | 2010
Chlorophyll a | 24.855
Aquatic Grasses | 15.35
[NAME] | 71.627
[NAME] | 20.34005
Water Clarity | 26.363
Phytoplankton Index | 93.64
Water Quality Index | 40.94833333
Biotic Index | 43.11001667
Bay Health Index | 42.029175
Spreadsheet: 694729d1599763991-if-formula-help-dschittone-sample
Sheet: 09-10

LIST PROJECT # | DISTRICT SCHOOL - PROPOSED BUILDING PROJECT                                      (List Deficiencies from District Facilities Director and 00-05 District LRFP'S by School and Year)   Note:  Add Rows for Additional Schools | 2009-2010 | Life - Safety  - Priority A | Critical /  Recommended Projects -              Priority B | [NAME]Priority C | Barrier-Free ADA Compliance - Priority H | Energy Efficiency - Priority E | Quantity - Check Total | Unit Cost
 | SCHOOL NAME: [NAME] Complex
2 | Replace Built-Up Roof System | 169500 | 0 |  | 0 | 0 | 0 | 53700 | 15
3 | Paint Interior Walls | 26800 | 0 | 0 |  | 0 | 0 | 243214 | 0.55
12 | Alternate Heat Source for Pool Water (Electronic or Photovoltaic) | 800000 | 0 | 0 |  | 0 |  |  | Rebate $400,000
17 | Replace Data ports | 217400 | 0 | 0 |  | 0 | 0 | 217316 | 1
18 | Upgrade Computer Network | 217400 | 0 | 0 |  | 0 | 0 | 217316 | 1.5
 | SUBTOTAL "A"
 | SCHOOL NAME: [NAME]
15 | Replace Aluminum Entrance with Glazing | 60500 | 0 | 0 |  | 0 | 0 | 11 qty | 5500
16 | Replace Aluminum Framed Single Pane Windows | 99580 | 0 | 0 | 0 | 0 |  | 1532 | 65
17 | Replace Carpeting (corr, then 1/2 CRs over 2 years) | 45000 | 0 | 0 |  | 0 | 0 | 15361 | 4.1
20 | Replace Door Automatic Closers | 3025 |  | 0 |  | 0 | 0 | 11 qty | 275
21 | Replace Door Locksets | 27950 |  | 0 | 0 | 0 | 0 | 86 qty | 325
22 | Replace Doors with Glazing | 53550 |  | 0 | 0 | 0 | 0 | 51 qty | 1050
24 | Replace Fire Rated Wood Doors | 7600 |  | 0 | 0 | 0 | 0 | 8 qty | 950
25 | Replace Hollow Core Wood Doors | 10000 |  | 0 | 0 | 0 | 0 | 57 qty | 175
28 | Replace Resilient Flooring | 17200 | 0 | 0 |  | 0 | 0 | 4082 | 4.2
29 | Replace Rubber Floor | 2400 | 0 | 0 |  | 0 | 0 | 212 | 11
32 | Replace Site Walkways | 101700 | 0 | 0 |  |  | 0 | 17685 | 5.75
33 | Replace Solid Core Wood Doors | 23800 |  | 0 | 0 | 0 | 0 | 58 qty | 850
36 | Replace [NAME] or [NAME] | 500 | 0 | 0 |  | 0 | 0 | 14 Lf | 14
 |  |  |  |  |  |  | 0
 | SUBTOTAL "B"
 | SCHOOL NAME: William Davies Middle School
1 | Paint Interior Walls | 7000 | 0 | 0 |  | 0 | 0 | 63380 | 0.55
6 | Replace Window Glazing | 65000 | 0 | 0 |  | 0
 |  |  |  |  |  |  | 0
 | SUBTOTAL "C"
 | SCHOOL NAME:
1 |  | 0 | 0 | 0 | 0 | 0 | 0
 | SUBTOTAL "D"
 | SUMMARY SUBTOTALS (Subtotals A-G) :
 | PROJECT SOFT COSTS (A/E Fees, [NAME], Printing x 28%) :
 | PROJECT TOTALS:
Spreadsheet: 61558d75-bbf8-43f0-b672-2fad7794d2e8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258975 | 13875 | Sue | Walker | GBR |  | 00:19:14 | 00:01:13 | 00:37:50 | 00:01:03 | 00:10:34 | 1 | 01:09:52
Spreadsheet: 142659d1329946751-drop-down-lists-and-hyperlinks-to-other-sheets-sample-sheet
Sheet: AE0

Community Code: | AE0
Community Name: | AMELIA PARK
County: | CLERMONT
City/Township: | AMELIA |  | Requirements
 |  | Builder: | 0
 |  | Developer: | 0
 |  | Community: | 0
 |  | HOA: | 0
 |  | PUD: | 0
 |  | City/Twp.: | 0
 |  | County: | 0
 |  | State: | [NAME] is required with four or more risers  8' and 9' garage doors allowed
Spreadsheet: 676356d1588771239-look-up-value-in-db-and-fill-missing-values-in-another-xls-file-stat-test
Sheet: Sheet1

 | IF MISSING Values | If missing values
 | Pick up value from DB1.xls in column "E"
Art nr | New Nr | Name 2 | Artikelbenämning |  | Re: LOOK UP VALUE in DB and FILL MISSING VALUES in ANOTHER XLS file
701035 | =INDEX([DB1.xlsx]Blad1!D$2:D$6;PASSA(A5+0;INDEX([DB1.xlsx]Blad1!$E$2:$E$6+0;);0)) |  | aaa |  | Hi.
701895 |  |  | bbb
701896 |  |  | [NAME]
345890 |  |  | ddd |  | formula needs to read "text numbers" as numbers in column E before matching data
123987 |  |  | eee
 |  |  |  |  | In B5 (sheet1) to be copied down
Spreadsheet: 884463d1733655901-replicate-rows-in-results-jacc14-tools-spill-365-aligw
Sheet: Sheet1

JOB | product | STORE | type | COST a | RESTOCK
51 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | tools appear in list once
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 9 records
52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd job
52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd job
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 2nd Job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 2nd Job
RESULT
JOB | product | STORE | Type | COST a | RESTOCK
 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | Tool list are replicated for every job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 14 records
51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job
52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
Spreadsheet: 825030d1681056079-array-formula-keep-using-the-1st-row-as-reference-formula-help-array
Sheet: Report

Year | 2020
Asset Category | Car |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q7 should be (31-14+1)*383.90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Change the Year at B1 to 2021, should be 31*383.90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Asset Category | Asset Name | Asset Number | Region / Location | Rate (%) | Dep Start Date | Dep End Date | Per day | No Days | Purchased Date | Purchased Cost | Residual value
 | Hyundai [NAME] | C-BKK-001 | HEADQUATERS | 0.2 |  |  |  |  | 2021-01-14 00:00:00 | 701000 | 1
Car | Hyundai H-1 ฮย4569 | C-BKK-002 | HEADQUATERS | 0.2 | 2021-01-14 00:00:00 | 2026-01-13 00:00:00 | 398.0279299014239 | 1825 | 2021-01-14 00:00:00 | 726800 | 1 | 0 | 0 | 0 | 0 | 720032.5251916758 | 719634.4972617744 | 708489.7152245345 | 696150.8493975904 | 684210.0115005476 | 671871.1456736035 | 659930.3077765608 | 647591.4419496167 | 5507910.493975904
Spreadsheet: 23494d1213031818-sorting-a-block-of-data-sortarray
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 15 | 20 | 22 | 23 | 24 | 25 | 28 | 29
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 30 | 32 | 43 | 44 | 46 | 49 | 51 | 52 | 55 | 58
21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 60 | 60 | 61 | 62 | 63 | 71 | 71 | 72 | 72 | 75
31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  | 75 | 76 | 77 | 78 | 82 | 87 | 88 | 93 | 108 | 110
41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 |  | 111 | 116 | 116 | 118 | 128 | 130 | 142 | 146 | 152 | 153
51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 |  | 156 | 157 | 159 | 162 | 164 | 164 | 165 | 166 | 168 | 170
61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 |  | 173 | 176 | 176 | 176 | 177 | 179 | 182 | 183 | 184 | 185
71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 |  | 186 | 188 | 189 | 193 | 196 | 197 | 199 | 202 | 206 | 206
81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 |  | 209 | 212 | 212 | 213 | 214 | 214 | 215 | 217 | 218 | 219
91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 |  | 219 | 221 | 222 | 228 | 233 | 237 | 239 | 240 | 240 | 242
101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 |  | 245 | 247 | 250 | 254 | 259 | 261 | 261 | 266 | 276 | 278
111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 |  | 278 | 278 | 278 | 284 | 287 | 287 | 288 | 288 | 290 | 295
121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 |  | 297 | 300 | 302 | 305 | 307 | 311 | 312 | 312 | 313 | 319
131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 |  | 319 | 322 | 323 | 323 | 323 | 328 | 336 | 336 | 338 | 338
141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 |  | 338 | 339 | 342 | 343 | 350 | 352 | 354 | 356 | 358 | 360
151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 |  | 373 | 375 | 376 | 377 | 379 | 383 | 385 | 387 | 392 | 394
161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 |  | 394 | 396 | 397 | 398 | 399 | 407 | 410 | 411 | 413 | 420
171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 |  | 422 | 426 | 431 | 431 | 434 | 434 | 437 | 437 | 438 | 439
181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 |  | 440 | 441 | 450 | 454 | 460 | 464 | 469 | 471 | 474 | 474
191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 |  | 476 | 477 | 477 | 481 | 489 | 490 | 494 | 497 | 497 | 499
 |  |  |  |  |  |  |  |  |  |  |  | Take these values and paste special >values them back over your data
 | Indexing used in SMALL [NAME] to the right
Spreadsheet: sally_beck__34360__CoreSystemsOwners
Sheet: Sheet1

Core System Owners
 | Business | IT
EOL | [NAME]
Gas Fundamentals |  | [NAME]
Sitara | [NAME] | [NAME]
Enpower | [NAME] | [NAME]
RAC | [NAME] | Ramesh [NAME] / [NAME]
Tagg/Erms | [NAME] | [NAME]
CPR | [NAME] | [NAME]
DPR | [NAME] | [NAME]
Tagg Confirmations | [NAME] [NAME] | [NAME]
Enpower Confirmations | [NAME] [NAME] | [NAME]
DCAF 2 | [NAME] [NAME] | [NAME]
Global | [NAME] | Sundar Chitradurga
MKM | [NAME] | [NAME]
EDI | [NAME] | [NAME]
Unify Gas Logisitcs | [NAME] [NAME] | [NAME]
Unify Power Settlements | [NAME] | [NAME]
Unify Gas Settlements | [NAME] | [NAME]
Unify Financial Settlements | [NAME] | [NAME]
TDS | [NAME] | [NAME]
SAP | [NAME] | [NAME] | x55098; [PHONE] cell
Spreadsheet: 840512d1692790657-help-request-for-unconventional-issue-production-example
Sheet: Alphabetical

 | Material | Customer Name |  | Received | LOC | B | K | PROJECT | SS/PL | MAT    REC | RDY
 |  |  |  |  |  |  |  |  | ORD
 |  | [NAME] | [NAME] | 2023-07-17 00:00:00 | Ogt | 0 | 1 | Scal [NAME] | 0 | 7-25 | Y
 |  | Chase Const. | Riverside Ln. | 2023-07-17 00:00:00 | Wells | 0 | 1 | 104' 6' Scal OTB | 7-21 | 0 | 0
 |  | [NAME] | [NAME] | 2023-07-05 00:00:00 | Wells | 0 | 1 | 8' 36" Wht Vnyl Handrail | 7-10 | 8-10 | Y
 |  | Crowe | [NAME] | 2023-07-19 00:00:00 | [NAME] | 0 | 1 | 17' Blk Alum Hndrl | 7-21 | 0 | 0
 |  | Dumont | [NAME] | 2023-07-24 00:00:00 | Kit | 1 | 0 | 6' Blk VC Repair | 0 | STK | 0
 |  | Ferland | Pam | 2023-07-14 00:00:00 | Ogt | 0 | 1 | (2) 5' x [NAME] | 7-21 | 0 | 0
 |  | Gonfrade | Scott | 2023-06-28 00:00:00 | Wells | 1 | 0 | Repair | 7-6 | 7-17 | Y
 |  | Griffin | [NAME] | 2023-07-12 00:00:00 | OOB | 0 | 1 | 6'h to 4'h Priv Taper Panel | 4-13 | 0 | 0
 |  | Hwang | [NAME] | 2023-07-14 00:00:00 | Bid | 1 | 0 | Dumpster Gate Replacement | 0 | 0 | 0
 |  | [NAME] | Ward | 2023-07-24 00:00:00 | Yk B | 1 | 0 | 8', 42" Berk D-e | 7-24 | 8-1 | Y
 |  | Mudd | Kerry | 2023-07-14 00:00:00 | Kbk | 0 | 1 | 23' 5' Roman Grid | 7-20 | 8-10 | Y
 |  | [NAME] | [NAME] | 2023-06-29 00:00:00 | Kbk | 1 | 0 | 69' 6' Guardian | 7-6 | 7-25 | Y
 |  |  |  |  |  |  |  | No highlighting in this column indicates that materials have been received or fabricated.
 |  |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  |  |  |  | B | K
Spreadsheet: 866342d1713285148-dynamic-drop-down-lists-dynamic-dropdowns-eba
Sheet: Sheet1

 | 1. Reference Table |  |  | 2. Main Table in Use |  | Dynamic DV Lists |  |  |  |  |  |  | 3. Data Validation Lists
 |  |  |  |  |  | req'd in this col.
 | Class No. | Code |  | ID | Class Code | Class Name |  |  |  |  | Used Classes |  |  | 2 | 3
 | 1 | A, B, C, D |  | 1 | 1
 | 1 | A |  | 2 | 3 |  |  |  |  |  | 2 |  | B | H | D
 | 1 | A, B |  | 3 | 2 |  |  |  |  |  | 3 |  | C | I | I
 | 1 | A, E, F |  | 4 |  |  |  |  |  |  |  |  | D |  | J
 | 1 | B, F |  | 5 |  |  |  |  |  |  |  |  | E |  | K
 | 2 | G |  | 6 |  |  |  |  |  |  |  |  | F |  | L
 | 2 | G, H, I |  |  |  |  |  |  |  |  |  |  |  |  | M
 | 2 | H |  |  |  |  |  |  |  |  |  |  |  |  | N
 | 3 | C, D, I, J, K |  |  |  |  |  |  |  |  |  |  |  |  | O
 | 3 | C
 | 3 | J, K, L, M
 | 3 | K, L
 | 3 | M
 | 3 | M
 | 3 | J, M
 | 3 | J, K, M, N, O
Spreadsheet: 37cab6f0-5f87-48d3-9f0c-0cc60c70c8de
Sheet: distamben

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : Ir.DWIDJONO PHS / drg.R.HARRY DS.M.Kes
K/L/D/I |  | : [NAME]. [NAME]
SATKER/SKPD |  | : [NAME] ENERGI
PPK |  | :
[NAME] |  | : 2013
NO | KEGIATAN |  | SUB KEGIATAN/ PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN ￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼ | WAKTU PELAKSANAAN (BULAN) | [NAME] | [NAME]
 |  |  |  |  |  |  | PERKIRAAN BIAYA (RP,-) | [NAME] (APBN/ APBD) | RENCANA PEMBIAYAAN
(1) | (2) |  | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14)
1 | Penyediaan Peralatan dan Perlengkapan Kantor |  |  | Pengadaan Mesin Penghancur Kertas | 1 buah | [NAME] | 1100000 | APBD | Distamben | Pengadaan Langsung | Maret 2013 | 2 minggu | _
 |  |  |  | Pengadaan [NAME] | 8 buah | [NAME] | 36000000 | APBD | Distamben | Pengadaan Langsung | April 2013 | 2 minggu | _
 |  |  |  | Pengadaan Filing Kabinet | 5 buah | [NAME] | 12500000 | APBD | Distamben | Pengadaan Langsung | April 2013 | 2 minggu | _
 |  |  |  | Pengadaan AC | 5 buah | [NAME] | 20500000 | APBD | Distamben | Pengadaan Langsung | Maret 2012 | 2 minggu | _
 |  |  |  | Pengadaan Komputer PC | 2 buah | [NAME] | 11400000 | APBD | Distamben | Pengadaan Langsung | Juni 2013 | 2 minggu | _
 |  |  |  | Pengadaan Meja Rapat | 12 buah | [NAME] | 12000000 | APBD | Distamben | Pengadaan Langsung | [NAME] 2013 | 2 minggu | _
 |  |  |  | Pengadaan Kursi Rapat | 1 buah | [NAME] | 11000000 | APBD | Distamben | Pengadaan Langsung | [NAME] 2013 | 2 minggu | _
 |  |  |  | Pengadaan Faximili | 1 buah | [NAME] | 2100000 | APBD | Distamben | Pengadaan Langsung | Juni 2013 | 2 minggu | _
2 | [NAME] Gedung Kantor |  |  | Belanja Sekat Dinding Ruangan Kantor | 1 paket | [NAME] | 50000000 | APBD | Distamben | [NAME] | Maret 2012 | 2 minggu | _
3 | Pengadaan [NAME] tertentu |  |  | Belanja Pakaian Olah Raga | 70 stel | [NAME] | 14000000 | APBD | Distamben | Pengadaan Langsung | Maret 2012 | 2 minggu | _
4 | Pengadaan dan Peningkatan Bidang Ketenagalistrikan |  |  | Pengadaan Bahan Peralatan Biogas | 5 unit | [NAME] | 75000000 | APBD | Distamben | [NAME] | Oktober 2013 | 1 bulan | _
 |  |  |  | Pengadaan [NAME] ([NAME]) | 1 unit | [NAME] | 500000000 | APBD | Distamben | Lelang | Oktober 2013 | 1.5 bulan | _
 |  |  |  | TOTAL |  |  | 745600000
 |  |  |  |  |  |  |  |  |  |  |  | Batulicin, 03 Januari 2013
 |  |  |  |  |  |  |  |  |  |  | an. | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | drg.R.HARRY DHARMAWAN S,M.Kes
 |  |  |  |  |  |  |  |  |  |  |  | NIP 19631104 199301 1 002