tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 228ee108-0733-4093-ab96-2a4c1bafc0a5
Sheet: Expenses

Event Budget for [Event Name]
Expenses
 |  |  |  |  | Estimated | Actual
Total Expenses
 | Estimated | Actual |  |  | Estimated | Actual
Site |  |  |  | Refreshments
Room and hall fees |  |  |  | Food
Site staff |  |  |  | Drinks
Equipment |  |  |  | Linens
Tables and chairs |  |  |  | Staff and gratuities
Totals |  |  |  | Totals
Decorations |  |  |  | Program
Flowers |  |  |  | Performers
Candles |  |  |  | Speakers
Lighting |  |  |  | Travel
Balloons |  |  |  | Hotel
Paper supplies |  |  |  | Other
Totals |  |  |  | Totals
Publicity |  |  |  | Prizes
Graphics work |  |  |  | Ribbons/Plaques/Trophies
Photocopying/Printing |  |  |  | Gifts
Postage |  |  |  | Totals
Totals
Miscellaneous
Telephone
Transportation
Stationery supplies
Fax services
Totals
Spreadsheet: 390412d1429626119-lookup-help-with-if-false-return-conditions-lookup
Sheet: Sheet1

Category | Description | Taken | Remaining
Fruit | [NAME] | 3 | 6 |  |  |  | Started with | Remaining
Fruit | [NAME] | 2 | 4 |  |  | [NAME] | 9
Fruit | Apple | 1 | 5 |  |  | Apple | 6
Fruit | Orange | 3 | 4 |  |  | Orange | 7
Fruit | Apple | 1 | 4
Fruit | Orange | 1 | 3
Spreadsheet: 43384d1242054016-excel-2007-pivot-table-refresh-data-book-1
Sheet: Data

Division | Reg No | SLM # | Sls Name | TRNNum | Cust No | Customer Name | Cust PO No | Inv No | Item No | Inv Date | Commission Sales | Comm Prcnt | Comm Amount | [NAME] | H&O Item Flag | H&O Commission Rate | Special Customer % | New Commision Rate | New Commission Amount | Vendor #
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 12345 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 123456 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 123456 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 123456 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 123456 | Customer # 4 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
SER | 30 | SLM # 2 | SLM # 2NAME | 0 | 56789 | Customer # 5 | 568633 | 7116715 | 04072 | 04/03/09 | 5584.04 | 2 | 111.68 | 2 | 0 | 0 | 0 | 2 | 111.68 | 12345
Spreadsheet: 738137d1624869332-match-function-that-returns-multiple-results-beer-example
Sheet: Production Plan

SKU # | SKU Desc | Planned production units | Bottle | [NAME] | Label 1 | Label 2 | Label 3
1111 | Pale Ale | 500 |  |  |  | Pale Ale Front | Pale Ale Back
2222 | Stout | 500 |  |  |  | Stout Front | Stout Back
3333 | Lager | 1000 |  |  |  | Lager Front | Lager Back
4444 | Sour | 400 |  |  |  | [NAME] | [NAME]
Spreadsheet: 229533d1366426715-conditional-formatting-value-highlights-multiple-values-containers
Sheet: Sheet1

 | Asset no.
 | OMSU1000874 | <----Hired
 | CXSU1016802 | <----Hired
 | CRSU1532215 | <----Purchased
 | CXSU1002347 | <----Hired
 | CXSU1064924 | <----Hired
 | CXSU1016145 | <----Hired
 | TRIU0704384 | <----Purchased
 | CXSU1064800 | <----Hired
 | CXSU1016401 | <----Hired
 | SPRU1000247 | <----Purchased
 | CXSU1002305 | <----Hired
 | CXSU1003723 | <----Hired
 | CXSU1002706 | <----Hired
 | AMFU4252365 | <----Purchased
 | TRIU0777879 | <----Hired
 | CXSU1003908 | <----Hired
 | CXSU1016612 | <----Hired
 | CXSU1003889 | <----Purchased
 | CRXU7657870 | <----Hired
 | CXSU1002964 | <----Hired
 | CXSU1016401 | <----Hired
 | CXSU1002141 | <----Hired
 | [NAME] | <----Hired
 | RWLU7040254 | <----Hired
 | CRSU1531060 | <----Purchased
 | FBXU8966475 | <----Hired
 | CRSU1535533 | <----Hired
 | CXSU1002347 | <----Hired
Spreadsheet: kimberly_watson__20554__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Amoco |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
PNM |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 733658d1621688903-count-occurrences-of-time-matching-a-range-start-end-time-timeslots_sample
Sheet: Sheet1

Names | Log On | Log Out |  |  | Timeslots |  | How many
[NAME] | 08:12:22 | 16:46:40 |  |  |  |  | Logged on
[NAME] | 10:19:22 | 17:14:16 |  |  | 08:00:00 | 09:00:00 | 3
Carrie | 08:48:33 | 15:54:42 |  |  | 09:00:00 | 10:00:00 | 3
[NAME] | 08:00:00 | 09:17:47 |  |  | 10:00:00 | 11:00:00 | 4
Edgar | 10:28:00 | 13:28:06 |  |  | 11:00:00 | 12:00:00 | 5
[NAME] | 12:04:00 | 20:00:00 |  |  | 12:00:00 | 13:00:00 | 5
 |  |  |  |  | 13:00:00 | 14:00:00 | 5
 |  |  |  |  | 14:00:00 | 15:00:00 | 4
 |  |  |  |  | 15:00:00 | 16:00:00 | 4
 |  |  |  |  | 16:00:00 | 17:00:00 | 3
 |  |  |  |  | 17:00:00 | 18:00:00 | 2
 |  |  |  |  | 18:00:00 | 19:00:00 | 1
 |  |  |  |  | 19:00:00 | 20:00:00 | 1
Spreadsheet: 191154d1351941789-cell-containing-a-specific-word-followed-by-an-if-formula-qap-form-mobility-v6
Sheet: Quality Score Card

[NAME]: | Grade | Ticket Summary | Accurately document Troubleshooting Steps / Resolutions Steps / Action Taken | Attachment included | Accurately document Reported Source | Accurately document Operational Category | Accurately document Product Category | Quick Template Used | Accurately document Asset Information | Accurately document Ticket Status | Accurately document Ticket Status Reason | Accurately document Assignment Group / Routing Group | Accurately document Ticket Impact | Accurately document Ticket Urgency | Accurately input KT Code | Accurately input Correct KT ID | [NAME] ? | Ticket Status | Ticket Status Reason
[NAME] | 0.975
 | 0
[NAME] | 1
 | 1
[NAME] | 1
[NAME]
[NAME] Pinosan - BPINOSAN
[NAME] Eleazar- ACHIN20
[NAME] [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Jaypee A Adulta - JADULTA
[NAME] Abayan Espinoza - JESPINOSA
[NAME]
[NAME]
[NAME]
[NAME]
Micah Shane Dela Cruz Barrera - MBARRERA
[NAME] | 0
 | 0
[NAME] Adha [NAME]
[NAME]
[NAME] May [NAME]
[NAME]
[NAME]
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index/Index Tranche | 74790 | 184018 | 203104 | 461912
OTHER* | 0 | 0 | 8209 | 8209
TOTAL | 74790 | 184018 | 211313 | 470121
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 4d6b27bc-4b44-4268-85af-0c98666c0454
Sheet: Sheet1

BUDGET ADJUSTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Authorizing transfer of funds from |  |  |  |  | To transfer funds from CPD CD 5 contingency;
Capital Projects Department to Public Works |  |  |  |  | to Cd 5 PW project.
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | Department of Public Works
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | 12-3090-878500-B-89009996 = $25,000.00
 |  |  |  |  | 12-3090-878100-B-89009996 = $25,000.00
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | 12-3090-898101-B-89020070= $25,000.00
 |  |  |  |  | 12-3090-898507-B-89060064= $25,000.00
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | Heather Bray |  | 2011-07-27 00:00:00
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | [NAME] |  | 2011-07-28 00:00:00
 |  |  |  |  | Reference Numbers
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 8

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-08 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 881 |  | 881 |  | 67694 |  |  |  |  |  | 27 | 1 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2 | 20
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5160 |  | 6124 |  | 67694 |  |  |  |  |  | 27 | 3 | 16 |  |  | 15
 |  |  |  |  |  |  |  |  | 7000 |  | 7000 |  | 68918 | 0 |  |  |  |  | 28 | 4 | 19 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 5 | 21 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1048 |  | 1684 |  | 67694 |  |  |  |  |  | 26 | 6 | 19 |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 28 | 7 | 17 |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 29 | 8 | 22 |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 28 | 9 | 23 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 15 | 27 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 14810 |  | 18702 |  | 67694 |  |  |  |  |  | 29 | 35 | 24 |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 28 | 39 | 19 |  |  | 17
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2576 |  | 2974 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1503 |  | 1734 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 13673 |  | 15529 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4114 |  | 4434 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3059 |  | 3287 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5333 |  | 5476 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1711 |  | 1945 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 44 |  | 47 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: theresa_staab__39635__Enron Statement_0901
Sheet: Enron Fuel Sale

 |  | Supply Verification |  | [NAME] To: |  | Remit To:
 |  |  |  |  |  |  | Verification Date:
 |  | NET OUT SETTLEMENT |  | Crestone Gathering Services |  | Enron North America Corp. | 2001-10-18 00:00:00
 |  |  |  | 1400 16th Street
 |  |  |  | Suite 310 |  |  | Due Date:
 |  |  |  | Denver, CO  80202 |  |  | 2001-10-28 00:00:00
 |  |  |  |  |  |  | Payment Method:
 |  |  |  | Contact:  [NAME] |  | Contact:  [NAME] | Wire
 |  |  |  | Tel: (720) 946-3692 |  | Tel:  (303) 575-6465 | Terms:
Crestone Gathering Services, L.L.C. |  |  |  | Fax: (720) 946-3640 |  | Fax: (303) 534-0552
Delivery Period:
2001-09-01 00:00:00
 | Supply |  |  | Mmbtu | Price/MMBtu |  | Amount Due
 | Fuel / LUAF | [NAME] to Crestone Gathering Services |  | 18743.30811424607 | 1.2589 |  | 23595.95058502437
 |  |  |  |  |  | Sub Total: |  | 23595.95058502437
 | Imbalance Sale | Crestone Gathering Services Sale to ENA |  | 0 | 1.2589 |  | 0
 |  |  |  |  |  | Sub Total: |  | 0
 |  |  |  |  |  | TOTAL DUE: |  | 23595.95058502437
Spreadsheet: 03c35933-326e-4af4-bff9-47d725caf011
Sheet: 4a - Budget Summary

 | 4a -Budget Summary
Line |  |  | AEFLA Federal | AEFLA Match | AEFLA Program Income
1 | Current Year Allocation/Match/Anticipated Program Income |  | 0 | 0 | 0
INSTRUCTIONAL SERVICES MUST BE GREATER THAN OR = 95% OF TOTAL BUDGET REQUEST
Instructional Program   (0010 – 2000) - ABE/ESL
2 | Salaries (0100) | (0100)
3 | Employee Benefits (0200) | (0200)
4 | Purchased Professional & Technical Services (0300) | (0300)
5 | Other Purchased Services (0500) | (0500)
6 | Supplies (0600) | (0600)
7 | Equipment (0730) | (0730)
8 | Subtotal Instructional Program ABE/ESL
Instructional Program  (0010-2000) ASE
9 | Salaries (0100) | (0100)
10 | Employee Benefits (0200) | (0200)
11 | Purchased Professional & Technical Services (0300) | (0300)
12 | Other Purchased Services (0500) | (0500)
13 | Supplies (0600) | (0600)
14 | Equipment (0730) | (0730)
15 | Subtotal Instructional Program ASE
Administration  (2300, 2400, and 2500) MAXIMUM ADMINISTRATIVE COSTS = 5%, with waiver requirement for additional amount
16 | Salaries (0100) | (0100)
17 | Employee Benefits (0200) | (0200)
18 | Purchased Professional & Technical Services (0300) | (0300)
19 | Other Purchased Services (0500) | (0500)
20 | Supplies (0600) | (0600)
21 | Equipment (0730) | (0730)
22 | Subtotal Administration
23 | Total Budget
1 | Total Funds Available (repeated from above)
 | Difference - Line 1 less line 24-must be zero
 |  |  | Verification
 |  |  | Instructional Services >/= 95%
 |  |  | Match >/= 40%
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: TOURNEY5

TANNERS CREEK - July 11th, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
 | 0 | 0 | 0
 | 4 | 4.75 | 0
 | 2 | 3.57 | 2.71
 | 3 | 3.53 | 0
 | 0 | 0 | 0
 | 1 | 1.62 | 0
 | 2 | 3.41 | 2.36
 | 3 | 4.85 | 2.6
 | 3 | 4.44 | 0
 | 0 | 0 | 0
 | 4 | 6.08 | 2.41
 | 3 | 4.61 | 0
 | 1 | 0.98 | 0
 | 1 | 1.72 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
Spreadsheet: 168443d1342458155-need-help-on-calculating-the-percent-ulilization-percentutilization
Sheet: sumary

Monthly Store Utilization (in percent)
 | Select Year |  | 2012
Store | 2012-01-01 00:00:00
Store 1
Store 2
Store 3
Store 4
Store 5
Store 6
Store 7
Store 8
Store 9
Store 10
I want to calculate the percent utilization of each store each month up to date. For example, this is the data for month of March-2012:
So, the hour of utilization for Store 4 will be:
 | 2012-03-01 00:00:00 |  | 18.5+3.5 | = | 22 | (round up 1 hour)
 | 2012-03-02 00:00:00 |  | 2.5+3.17 | = | 6 | (round up 1 hour)
 | 2012-03-03 00:00:00 |  |  |  | 24 | (round up 1 hour)
 | 2012-03-04 00:00:00 |  |  |  | 24 | (round up 1 hour)
 | 2012-03-05 00:00:00 |  |  |  | 24 | (round up 1 hour)
 | 2012-03-06 00:00:00 |  |  |  | 24 | (round up 1 hour)
 | 2012-03-07 00:00:00 |  |  |  | 4 | (round up 1 hour)
 | 2012-03-08 00:00:00 |  |  |  | 0 | (round up 1 hour) |  |  | Store 4 March-2012 Total = 128
Therefore Store 4/March will have percent of Utilization = |  |  |  |  |  | Total hour of utilization (128) / Total hour of the month (31*24=744)
 |  |  |  |  | = | 0.18
All other store will be 0% for March of 2012
I need some formular to automatically calculate for all Stores/Month/Year
Thanksss
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Final

 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | 291885.5808523059 |  |  |  | 0
 |  |  |  |  | 0
 | 291885.5808523059 |  |  |  | 0
 |  |  |  | M | 58377.11617046119
 |  |  |  | 1 | 23350.84646818448
 |  |  |  | 2 | 35026.26970227671
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | 116754.2323409224 |  |  |  | 116754.2323409224
 | 175131.3485113835 |  |  |  | -116754.2323409224
 |  |  |  |  | -33741.97314652656
 |  |  |  |  | -16345.59252772913
 |  |  |  |  | -66666.66666666669
 | 15000 |  |  |  | 15000
 | 85000 |  |  |  | -81666.66666666669
 |  |  |  | Difference | 166666.6666666667
Spreadsheet: d8f358b5-7439-4b43-af62-ea54b46d7462
Sheet: Sheet1

Autobusové zastávky | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Délky nájezdových a výjezdových klínů a nástupních hran
(dle [NAME] vyřazovací / zařazovací - pruh / úsek)
[NAME] přímo vedle jízdního pruhu
úsek |  | šířka (m) | délka (m) |  | poměr š/d
LV | nájezd | 3 | 25 | 1 | : | 8.333333333333334
(LV) | (nájezd) | 3 | 20 | 1 | : | 6.666666666666667
LZ | výjezd | 3 | 15 | 1 | : | 5
(LZ) | (výjezd) | 3 | 10 | 1 | : | 3.333333333333333
 |  |  | dle ČSN 736425-1
[NAME] pruhu (podélné stání)
úsek |  | šířka (m) | délka (m) |  |  | šířka (od hrany nástupiště po pravý okraj průběžného jízdního pruhu)
LV | nájezd | 2.2 | 18.33333333333334 |  |  | parkovací pruh | 2.2
(LV) | (nájezd) | 2.2 | 14.66666666666667 |  |  | bezpeč. odstup | 0
LZ | výjezd | 2.2 | 11 |  |  | cyklopruh | 0
(LZ) | (výjezd) | 2.2 | 7.333333333333334 |  |  | šířka (m) | 2.2
[NAME] pruhu (podélné stání) se souběžným cyklopruhem
úsek |  | šířka (m) | délka (m) |  |  | šířka (od hrany nástupiště po pravý okraj průběžného jízdního pruhu)
LV | nájezd | 3.95 | 32.91666666666667 |  |  | parkovací pruh | 2.2
(LV) | (nájezd) | 3.95 | 26.33333333333334 |  |  | bezpeč. odstup | 0.75
LZ | výjezd | 3.95 | 19.75 |  |  | cyklopruh | 1
(LZ) | (výjezd) | 3.95 | 13.16666666666667 |  |  | šířka (m) | 3.95
délky vozidel pro výpočet délky přímé nástupní hrany
úsek |  | typ vozu | délka (m)
LNH | hrana | midi | 8.5
LNH | hrana | standard | 12
LNH | hrana | 3osák | 15
LNH | hrana | kloub | 19
[NAME] pro 2 autobusy se délka hrany rovná součtu délek autobusů v místě provozovaných typů + 1,00 m meziodstup.
Vysvětlivky:
(LV) | (nájezd) | - údaj je minimální možnou hodnotou ve stísněných poměrech a nezaručuje [NAME] nízkopodlažních vozidel k nástupní hraně
 |  | - údaj je možno dle místních podmínek přepsat, délky nájezdů a výjezdů se automaticky přepočtou
Všechny údaje platí pro uspořádání přímém úseku - při umístění v oblouku nutno délky úseků zohlednit.
[NAME], ROPID
květen 2010
Spreadsheet: 109900d1306716189-monthly-rollup-of-data-201105-flare-events-
Sheet: 201105 Flare Events

 | Enter data only in Green cells from left to right.
 |  |  |  |  |  |  | Routine |  |  |  | Non Routine |  |  |  |  |  |  |  |  |  |  |  |  | All Codes | Routine | Non-Routine
DATE | Flare or Vent? | Event Type (Choose Code) | Start Time   (Military Format) | Stop Time    (Military Format) | Volume (MCF) | Operator Initial | Hours | Accum. Hrs | Released Volume (MCF) | Accum. Released Volume (MCF) | Hours | Accum. Hrs | Released Volume  (MCF) | Accum. Released Volume  (MCF) | Daily [NAME] (MCF) | Daily Routine Flare  Volume (MCF) | Daily Non- Routine Flare  Volume (MCF) | Daily Vent Metered Volume (MCF) | Daily Routine Methane Vent  Volume (MCF) | Daily Non- Routine Methane Vent Volume (MCF) |  |  | F |  | RO
2011-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 256 | 134 | 122 | 237 | 233 | 4 |  |  | V | RO
 | F | PM | 01:15:00 | 01:24:00 | 3 | GLS | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 00:09:00 | 00:09:00 | 3 | 3 |  | 0 | 3 |  |  |  |  |  |  | PM |  | PM
 | V | LC | 11:25:00 | 11:35:00 | 4 | GLS | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 00:10:00 | 00:19:00 | 4 | 7 |  |  |  |  | 0 | 4 |  |  |  | LC |  | LC
 | F | SW | 15:30:00 | 18:20:00 | 55 | GLS | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 02:50:00 | 03:09:00 | 55 | 62 |  | 0 | 55 |  |  |  |  |  |  | SW |  | SW
 | F | PM | 19:00:00 | 19:22:00 | 12 | GLS | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 00:22:00 | 03:31:00 | 12 | 74 |  | 0 | 12 |  |  |  |  |  |  | UW |  | UW
2011-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 | 159 | 26 | 245 | 245 | 0 |  |  |  | OL |  | OL
 | F | PM | 15:00:00 | 16:22:00 | 26 | test | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 01:22:00 | 01:22:00 | 26 | 26 |  | 0 | 26 |  |  |  |  |  |  | OO |  | OO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT |  | CT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WO |  | WO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NR |  | NR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LS |  | LS
Spreadsheet: 179109d1347030505-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-and-techlogtest
Sheet: Jim

 | Today is
Today is: |  |  | Calculator
 | Date | Rate (hr) | Time | Cost |  | Landing fee
 |  |  |  |  |  | Running Total (outstanding)
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Payment Record
 |  |  |  |  |  | Landing Fee
 | Total Hours Flown
 |  | Total flying costs
 | Total minus expenses
 | Total after deducting payments