tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868319d1715045786-amortization-schedule-need-to-return-correct-value-prepaid-accomodation
Sheet: Weekly

 |  |  |  |  |  |  |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026
 |  | Vendor | Description | Starting balance | Invoice date | Start date | End date | Weeks | Amort. Amt. | Remaining balance | 2020-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total 2024 | 2024-01-01 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | Total | 2025-01-01 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | Total | 2026-01-01 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00 | Total
 |  |  | Accomodation 1 | 115000 | 2024-02-25 00:00:00 | 2024-04-01 00:00:00 | 2024-06-24 00:00:00
 |  |  | Accomodation 2 | 30000 | 2024-02-25 00:00:00 | 2024-05-03 00:00:00 | 2024-05-31 00:00:00
 |  |  | Accomodation 3 | 65000 | 2024-02-25 00:00:00 | 2024-04-19 00:00:00 | 2024-06-14 00:00:00
 |  | 12/31/2023 Balance |  |  |  | Total Outstanding |  |  |  |  | Add New
 |  | 0 |  |  |  |  |  |  |  |  | Less Amortisation
 |  |  |  |  |  |  |  |  |  |  | Balance
 |  |  |  |  |  |  |  |  |  |  | Per QB
 |  |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  | IF(OR(C$8="",C$7>$A21),0,MIN(C$5-SUM(C$13:C20),C$8))
 |  |  |  |  | C8 |  |  |  |  |  |  |  |  | Amortisatyion amount
 |  |  |  |  | C7 |  |  |  |  |  |  |  |  | First period
 |  |  |  |  | A21 |  |  |  |  |  |  |  |  | Current cell
 |  |  |  |  | C5 |  |  |  |  |  |  |  |  | Starting balance
 |  |  |  |  | C13 |  |  |  |  |  |  |  |  | First amount
 |  |  |  |  | C20 |  |  |  |  |  |  |  |  | previous amount
 |  |  |  |  | C8 |  |  |  |  |  |  |  |  | Amortisatyion amount
 |  |  |  |  | Table cells need to show amortisation amounts based on start date and end date
 |  |  |  |  | Accomodation schedule, we prepay these balances then need allocate them and track on a weekly basis as accomodation can change depending on weather for employees
 |  |  |  |  | Needs to start and end based on start and end date
Spreadsheet: 7c9d8901-eec8-4ba9-ab43-b100690523d6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MTX | Test | MTX | Methotrexate, Serum | Methotrexate, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 1 mL Collection Instructions: Send specimen in amber vial to protect from light. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK <24 hours; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Nontoxic drug concentration after 72 hours: <0.1 mcmol/L | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 83520 |  |  |  |  | Rochester
MTX | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
MTX | Result | 8721 | Methotrexate, S | Methotrexate, S | Numeric |  |  |  |  | mcmol/L |  |  |  |  |  |  |  |  |  | 14836-1
Spreadsheet: 491382d1480442221-months-since-last-purchase-and-reseller-count-copy-of-copy-of-months-since-purchase-and-reseller-count
Sheet: Resellers per SKU

 | Reseller Count
Product | 2016-05-01 00:00:00 | 2016-06-02 00:00:00 | 2016-07-03 00:00:00 | 2016-08-04 00:00:00 | 2016-09-05 00:00:00 | 2016-10-06 00:00:00
Product 1
Product 2
Product 3
Product 4
Product 5
Product 6
Spreadsheet: 823507d1679995259-how-can-i-convert-this-google-sheet-formula-to-excel-test-stock-portfolio-tracker
Sheet: Summary

 | Stock Ticker | Stock | Google Price | Manual Price | Last Price | Last DPS | Yield on Cost | Last Price Yield | Shares | Cost | Cost (Per Share) | Unrealized Gain/Loss | Unrealized Gain/Loss (%) | Realized Gain/Loss | Dividends Collected | Total Gain/Loss | Mkt Value | % of Portfolio
Growth | AAPL | Apple | 158.28 | 0 | 158.28 | 0
Growth | TSM | Taiwan Semiconductor | 90.66 | 0 | 90.66 | 0
Growth | LOW | Lowes | 190.53 | 0 | 190.53 | 0
Growth | RACE | Ferrari | 266.17 | 0 | 266.17 | 0
Growth |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
Watch |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
Special Situation |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
Growth |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  | Initial Capital | 500000
Spreadsheet: 142785d1330011073-show-data-according-to-date-copy-of-daily-report
Sheet: comments details

 | Comments Daily Updates Detail For All Profiles
Sr. No. | Date | URL | Business Name | Cities | Profile 1 | Profile 2 | Profile 3 | Profile 4 | Profile 5 | Profile 6 | Profile 7 | Profile 8 | Profile 9 | Profile 10
1 | 2012-02-17 00:00:00 | www.wxyz.com | Business Ontario | Ontario | yes | N\A | Yes | Peding | yes | yes | yes | N\A | N\A | yes | 1
2 | same data | www.abcd.com | Business San Bernardino | San Bernardino | yes | N\A | Yes | Approved | yes | N\A | N\A | N\A | N\A | yes | 2
3 | same data | www.abcd.com | Business Riverside | Riverside | yes | Approved | Yes | Approved | N\A | N\A | N\A | N\A | Approved | N\A | 3
4 | same data | www.abcd.com | Business San Diego | San Diego | yes | N\A | Yes | Approved | Approved | N\A | N\A | N\A | N\A | Approved | 4
5 | same data | www.abcd.com | Business [NAME] | [NAME] | yes | N\A | Yes | Approved | Approved | N\A | N\A | N\A | N\A | Approved | 5
6 | same data | www.abcd.com | Business Anaheim | Anaheim | yes | N\A | Yes | Approved | Approved | yes | N\A | N\A | N\A | Approved | 6
1 | 2012-02-20 00:00:00 | www.wxyz.com | Business Ontario | Ontario | yes | N\A | Yes | Peding | yes | yes | yes | N\A | N\A | yes
2 | same data | www.abcd.com | Business San Bernardino | San Bernardino | yes | N\A | Yes | Approved | yes | N\A | N\A | N\A | N\A | yes
3 | same data | www.abcd.com | Business Riverside | Riverside | yes | Approved | Yes | Approved | N\A | N\A | N\A | N\A | Approved | N\A
4 | same data | www.abcd.com | Business San Diego | San Diego | yes | N\A | Yes | Approved | Approved | N\A | N\A | N\A | N\A | Approved
5 | same data | www.abcd.com | Business [NAME] | [NAME] | yes | N\A | Yes | Approved | Approved | N\A | N\A | N\A | N\A | Approved
6 | same data | www.abcd.com | Business Anaheim | Anaheim | yes | N\A | Yes | Approved | Approved | yes | N\A | N\A | N\A | Approved
 |  | Note: B3:[NAME] all boxes name is "date"
 |  | I want to show data according to date "17/2/2012" on other sheet
 |  | when I type date all  data (of specific date data) must be show
 |  | can any one create the formula for my this sheet ?
 |  | thanks
Spreadsheet: 858128d1706885284-formula-for-weekly-from-daily-week-calendar-dj
Sheet: Daily

2024-01-01 00:00:00 | Week1 |  |  |  |  | Week2 |  |  |  |  | Week3 |  |  |  |  | Week4 |  |  |  |  | Week5 |  |  |  |  | Week6 |  |  |  |  | Week7 |  |  |  |  | Week8 |  |  |  |  | Week9 |  |  |  |  | Week10 |  |  |  |  | Week11 |  |  |  |  | [NAME]
 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00
 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00
Opening Balance | 1
Receipts | 1 | 21 | 2 | 12 | 9 | 17 | 10 | 17 | 25 | 15 | 21 | 21 | 21 | 5 | 15 | 6 | 12 | 18 | 17 | 5 | 19 | 4 | 14 | 23 | 11 | 20 | 24 | 15 | 1 | 10 | 1 | 18 | 23 | 18 | 17
Payments | -6 | -4 | -8 | -5 | -1 | -14 | -11 | -4 | -3 | -15 | -11 | -4 | -12 | -7 | -3 | -15 | -15 | -3 | -8 | -1 | -12 | -6 | -15 | -13 | -9 | -5 | -6 | -6 | -14 | -4 | -2 | -7 | -9 | -14 | -14
Closing Balance
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-11-P-0042

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-11-P-0042 |  |  | 1P
W912LP-11-P-0042 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: ReferenceUSA

ReferenceUSA
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per search
Logins | 62 | 85 | 182 | 200 | 103 | 68 | 127 | 142 | 126 | 81 | 86 | 75
Searches | 96 | 199 | 461 | 410 | 127 | 83 | 176 | 178 | 404 | 306 | 898 | 583 |  | 11025
# of Print/Detail Views | 216 | 2087 | 519 | 676 | 204 | 123 | 222 | 200 | 502 | 404 | 1002 | 865
Total Records Printed or Viewed | 233 | 2183 | 797 | 990 | 274 | 127 | 223 | 266 | 506 | 812 | 1002 | 915
# of Downloads | 11 | 108 | 53 | 31 | 11 | 17 | 3 | 45 | 12 | 90 | 110 | 11
Total Records Downloaded | 275 | 2605 | 496 | 494 | 267 | 341 | 75 | 1089 | 300 | 1961 | 2650 | 234
Residential Searches | 23 | 6 | 29 | 17 | 13 | 27 | 10 | 38 | 23 | 8 | 5 | 12
Business Searches | 73 | 193 | 432 | 393 | 114 | 56 | 166 | 140 | 381 | 298 | 893 | 571
COUNTER-Compliant?: | No
Spreadsheet: 820889d1678326034-adding-a-select-drop-down-filter-calendar-doc-2-
Sheet: Hashtags

 | Hashtag Organizer
 |  |  |  |  |  | © 2020 Vertex42.com
 |  | Number Included:
 | HASHTAG | INCLUDE | SORT | TOPIC | IG  POSTS | IG LINK |  | ◄ Use the Filter and Sort features
 | #spreadsheets | x | 1 | Spreadsheets | 26727
 | #vertex42 | x | 2 | Spreadsheets | 60
 | #msexcel | x | 3 | Spreadsheets | 12955
 | #learnexcel | x | 5 | Spreadsheets | 1426
 | #excelhelp |  | 4 | Spreadsheets | 527
 |  |  |  |  |  |  |  | ◄ To add more rows, drag the bottom right corner down.
Spreadsheet: 216485d1361788050-ranking-ranking
Sheet: Sheet1

SL no | Name | Country | Rank | I want short them in a particular countrywise ranking through formula
1 | x | India | 50
2 | s | UK | 30
3 | f | India | 22
4 | d | UK | 100
Spreadsheet: 184144d1349163355-calculating-the-number-of-days-example-ss_rev_a
Sheet: Sheet2

Route | Exercise | Type | Day | Month | Wk | Distance (Miles) | Time (mins sec) | Run No. This Year TOTAL | Days Since Last Run | Total Weeks Run Miles | Cycle No. This Year TOTAL | Days Since Last Cycle | Total Weeks Cycle Miles
Track 2x500m, 3x1k, 2x500m | Run | Reps | Tue | 2012-09-25 00:00:00 | 39 | 4.97 | 35.11 | 4 | 7 | 31.3 | 3 |  | 31.57
Torquay-Newton Abbot | Cycle | Ride | Sat | 2012-09-22 00:00:00 | 38 | 14.03 | 67.12 |  |  |  |  | 10
Track Pyramid | Run | Reps | Thu | 2012-09-20 00:00:00 | 38 | 5.64 | 49.4 |  | 12
Track 2x1 mile, 3x800m, 4x400m | Run | Reps | Tue | 2012-09-18 00:00:00 | 38 | 6.17 | 49.36 |  | 14
Home-Paignton | Cycle | Ride | Mon | 2012-09-17 00:00:00 | 38 | 12.32 | 45.12 |  |  |  |  | 15
[NAME] | Run | Run | Sun | 2012-09-16 00:00:00 | 37 | 14.52 | 117.18 |  | 16
[NAME] | Cycle | Ride | Fri | 2012-09-14 00:00:00 | 37 | 5.22 | 36.45 |  |  |  |  | 18
Spreadsheet: 47499d1246525723-vlookup-look-up-names
Sheet: Sheet2

 |  | Name | PID | PTL | Comments
1smith | [NAME] | [NAME],[NAME] | 1234 | [NAME] |  | [NAME]
2smith | [NAME] | smith,[NAME] | 1235 | [NAME]
3smith | [NAME] | smith,[NAME] | 1236 | [NAME]
4smith | [NAME] | smith,[NAME] | 1237 | [NAME]
5smith | [NAME] | smith,[NAME] | 1238 | [NAME]
1wilson | wilson | wilson,martin | 1239 | [NAME]
2wilson | wilson | wilson,fred | 1240 | [NAME]
3wilson | wilson | wilson,[NAME] | 1241 | [NAME]
Spreadsheet: 120274d1315151183-sum-for-duplicate-row-excel
Sheet: Sheet1

Name | jan | feb | March | april
A | 5 | 4 | 6 | 8
B | 1 | 5 | 7 | 9
C | 5 | 6 | 8 | 10
A | 6 | 7 | 9 | 11
C | 3 | 8 | 10 | 12
A | 4 | 9 | 11 | 13
A | 15 | 20 | 26 | 32
B | 1 | 5 | 7 | 9
C | 8 | 14 | 18 | 22
Spreadsheet: 846377d1697610514-create-a-drop-down-cell-that-brings-information-from-other-sheets-on-click-master-list-of-manuals
Sheet: SEC

ITEM NO. | PROCEDURE NUMBER | PROCEDURE TITLE | REVISION NUMBER | DATE
Aviation Security (SEC)
1 | AvSec-001 | Security Policy | 0 | 2023-10-15 00:00:00
2 | AvSec-002 | Security Culture | 1 | 2023-10-17 00:00:00
2 | AvSec-003 | Security Bulletin | 0 | 2023-10-18 00:00:00
Spreadsheet: ff3e45f4-e7d6-411d-a113-022a0b514182
Sheet: Lunes

HORARIOS DE ATENCIÓN A LOS ALUMNOS
DE LAS OFICINAS DE LAS FACULTADES EN SAN ISIDRO
DIA LUNES
HORA / DIA |  | Facultad de Ingeniería | Facultad de Negocios | Facultad de  Comunicaciones | Laboratorio  Química | Facultad de  Psicología | Facultad de Derecho | Facultad de  Economía
08:00:00 | 09:00:00 |  | [NAME]  PTC Adm. Y NNII |  |  |  |  | Jaime Canales
09:00:00 | 10:00:00 |  |  |  |  | [NAME]
10:00:00 | 11:00:00 | PTC Nikolai Vinces  Ing. Electrónica
11:00:00 | 12:00:00
12:00:00 | 13:00:00
13:00:00 | 14:00:00
14:00:00 | 15:00:00 |  | Emerson Sifuentes  PTC Adm. Y NNII   [NAME]  Adm y Finanzas
15:00:00 | 16:00:00
16:00:00 | 17:00:00 | Director [NAME]. Civil |  |  |  |  | [NAME]
17:00:00 | 18:00:00
Spreadsheet: kam_keiser__17787__phys procedures-new
Sheet: Year End 

1. | Before you do anything -
 |  | Save roll into the new Yr and new month - /2001/0102/File Name
2. | Complete all normal Month End Procedures - do not roll yet
3. | After you have completed all month end procedures, you will require some manual entries on the report page
4. | On or around line 65 on the Report page, you will see a life-to-date through 2000.  Change that to read Life to date through 2001
5. | Then on the line underneath that, you will see [NAME]
6. | On that line, go all the way across and drop in the 2001 P&L LTD Gross recognized balance for each roll
 |  | (this should be located on or around line 63 from the 12/2001 file)
7. | Within cells 69-71 (or beneath the title YTD through current date) there are formulas which include prior year ending balances
8. | change the hard-coded number in the cell to the appropriate 12/2001 number
9. | You may need to change the signs in some of the cells so the check figures are 0 across the spreadsheet
10. | Make sure that your daily, monthly, and year-to-date P&L are all the same number when you are finished.
Spreadsheet: 146179d1331939551-price-grid-index-lookup-match-windows-check-sheet-2012-1-
Sheet: Price List

Style1 |  | [NAME]
 | Height | 100 | 200 | 300 | 400 | 500
 | 100 | 200 | 300 | 400 | 500 | 600
 | 200 | 300 | 400 | 500 | 600 | 700
 | 300 | 400 | 500 | 600 | 700 | 800
 | 400 | 500 | 600 | 700 | 800 | 900
 | 500 | 600 | 700 | 800 | 900 | 1000
Style2 |  | [NAME]
 | Height | 100 | 200 | 300 | 400 | 500
 | 100 | 300 | 400 | 500 | 600 | 700
 | 200 | 400 | 500 | 600 | 700 | 800
 | 300 | 500 | 600 | 700 | 800 | 900
 | 400 | 600 | 700 | 800 | 900 | 1000
 | 500 | 700 | 800 | 900 | 1000 | 1100
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-08-31 00:00:00 |  | 1299640.66
2001-09-05 00:00:00
60874 | 853
78169
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-08-31 00:00:00 |  | 275313.72
2001-09-05 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361 |  |  |  | CBS Volume | 24268 | 24693 | 24361
 |  |  |  |  | 272432 | 117857 | 148659
2001-08-31 00:00:00 |  | 759991.94
2001-09-05 00:00:00
500241
500391 | 1227
500392 | 361
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 0e9bc565-6d80-42b5-92a3-40c06e71f99d
Sheet: Sheet1

Event Name: | Unnamed: 1 | Unnamed: 2
Event Date:
Budget Amount (if applicable)
Exepenses
Item | Estimated Cost | Actual Cost
VENUE
Rental
Set Up
Cleaning Fees
Other
Subtotal | 0 | 0
Printed Materials
Invitations
Posters
Programs
Nametages
Subtotal | 0 | 0
Rentals
Tables
Chairs
Riser
Linens
Podium
[NAME]
Easels
Pipe and [NAME]
Subtotal | 0 | 0
Audio Visual
Microphone
Sound System
Technical Equipment
Media Box
Lighting
Subtotal | 0 | 0
Hospitalty
Food
Beverages
Set Up
Staffing
Tax & Gratuities
Subtotal | 0 | 0
Photography
Parking
Entertainment
Parking
Postage
TOTAL | 0 | 0
Spreadsheet: 851025d1701289088-labor-pricing-grid-help-2039-toyota-grid
Sheet: Table 1 - NEW

159.95 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
Spreadsheet: 68450d1268985583-data-selection-issues-fa-test-1
Sheet: Liquidity-09

 | XYZ Company
 | Ratio Analysis
 |  |  |  |  |  |  |  | Select the month below
 | Liquidity Ratios |  |  |  |  |  |  | 2009-01-01 00:00:00 |  |  |  |  |  | Q1 2009 |  |  |  |  |  |  |  | 2009-01-01 00:00:00
 | Definition: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 2010
 |  | Current Ratio | = | Current Assets |  |  |  |  |  | = |  |  |  |  |  | = |  |  |  |  |  | Q1 2009
 |  |  |  | Current Liabilities
 |  | Industry Average |  |  |  |  |  |  | 1.13 |  |  |  |  |  | 1.13
 |  | [NAME]
 |  | Quarterly Growth/Decline
Spreadsheet: 0013ac20-e643-4c00-9390-33a2e7a91c31
Sheet: Sheet1

CONTRACT NO. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
ITEM NO. 624 0004 - FLAGGING
PLAN QUANTITY =
DATE | AEB # | DAILY | ACCUM | AEB # | ACCUM | PAYMENT
 | TOTAL | TOTAL | TOTAL | PAY TOTAL | PAY TOTAL | NO.
FINAL TOTALS
Spreadsheet: 221084d1363362554-same-formula-works-in-1-spreadsheet-but-no-another-working-tracking-sheet
Sheet: Instructions For Use

Instructions for correct use of the Tracking Sheet
General
1 | The Studio Booker will create the tracking sheet for each AudioGo title and will enter the title into B4 and the number of sessions that have been initially booked in D14
2 | The Producer will add the number of pages in the book in [NAME] as well as narrator details and details as to whether the book is a print copy or PDF
3 | The Senior Audio Engineer will set the required formats, the relevant ISBN numbers, delivery dates, and announcements
Recording
1 | The Producer must record details of each session to include their name, date and time of session, the page the session ended on and the time on the timeline at the end of the session in HH:MM. Note A : must be entered between hours and minutes
 | When the producer enters the page they recorded up to and the time on the timeline the spreadsheet automatically works out the following:
 | Pages Left: This shows how many pages are left to record
 | Pages To Record Per Remaining Sessions: This calculates how many pages need to be recorded per remaining session. If this number exceeds the average number of pages recorded in each session so far, the spreadsheet will alert you that you may need to book further sessions. Equally if the number is significantly less it may indicate that less sessions are needed. Note: The spreadsheet will only alert you if MORE sessions are needed not less.
 | Average Minutes Per Session: This is calculated by converting the time on the timeline for each session into minutes and dividing by the number of sessions that have been used. If this number is below 100 the Audio Manager should be notified. NOTE: The spreadsheet will flash up a warning if the narrator is achieving less than 90 minutes per session
 | Side Announcements Required: If the Audio CD and/or Cassette checkbox is ticked in the Formats Required section, the spreadsheet will calculate the number of CD's and/or [NAME] sides that will be required based on the latest EDL time provided. NOTE: The number of sides is based on AudioGo's requirement of an absolute maximum running time of 79 minutes. It also accounts for AudioGo's requirement that their books be on 1-4 CD's and then ONLY even numbers thereafter i.e. 1-4,6,8,10,12 etc.
Post Production
1 | Post Production is broken down into 5 different sections reflecting the different processes required for each format required. ALL books will go through Proof Audio and Final Editing and almost certainly Final Download Masters.
2 | As there are many different stages of post-production it is vital that Audio Producers keep this sheet up to date as this will be the only way we will know of what stage each of AudioGo's titles are at and what the next stage of Post-Production is.