tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 287582d1388871137-need-number-of-consecutive-hours-with-temperatures-below-zero-test1
Sheet: Pivot Table

Rank | Date | Sum of Time
1 | 1996-02-04 21:00:00 | 5 days, 22:00:00
2 | 1996-12-26 14:00:00 | 1 day, 13:00:00
3 | 1996-01-20 18:00:00 | 1 day, 9:00:00
4 | 1996-01-06 17:00:00 | 16:00:00
5 | 1996-01-07 16:00:00 | 14:00:00
6 | 1996-01-28 15:00:00 | 13:00:00
7 | 1996-12-27 10:00:00 | 11:00:00
8 | 1996-01-25 14:00:00 | 10:00:00
9 | 1996-02-06 12:00:00 | 10:00:00
 | 1996-12-20 16:00:00 | 10:00:00
11 | 1996-02-05 07:00:00 | 8:00:00
12 | 1996-03-03 13:00:00 | 7:00:00
13 | 1996-01-05 15:00:00 | 6:00:00
14 | 1996-03-07 13:00:00 | 5:00:00
15 | 1996-01-03 14:00:00 | 4:00:00
 | 1996-03-08 14:00:00 | 4:00:00
17 | 1996-02-05 15:00:00 | 4:00:00
18 | 1996-01-29 17:00:00 | 3:00:00
19 | 1996-01-24 12:00:00 | 2:00:00
20 | 1996-01-26 04:00:00 | 1:00:00
21 | 1996-01-08 03:00:00 | 1:00:00
Grand Total |  | 14 days, 5:00:00
Spreadsheet: 686995d1594906503-vba-multiple-spreedsheets-linked-combined_reports
Sheet: Consolidated Reports

CLAIMANT ID | SECTOR: CHOICE 1_(SELECT OR TYPE THE CLAIMANT PREFERENCE | SECTOR: CHOICE 2_(SELECT OR TYPE THE CLAIMANT PREFERENCE) | METHOD OF CONTACT_PHONE/JOURNAL | 18-24 | SELF EMPLOYED | HEALTH ISSUES | FOUND WORK | COMMENTS
RAJ | Civil Service | Childcare | BOTH | YES | NO | YES-CAN WORK | NO | HARD WORKER
DEEPAK | Childcare | Childcare | JOURNAL | YES | YES | NO | NO | GOOD
[NAME] | Education | Care | PHONE | YES | NO | YES-CAN WORK | NO
[NAME] | Care | Care | BOTH | NO | NO | YES-CAN WORK | YES | VERY GOOD
PAUL | Facilities Management/Cleaning | Driving | JOURNAL | NO | YES | YES-CANNOT WORK | NO | HARD WORKER
Spreadsheet: 859168d1707636822-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-book1_most
Sheet: Sheet1

Column1 | Count
Abigail1 | 10
Bob2 | 8
Carmen3 | 7
Mark4 | 6
Tom5 | 5
Sawyer | 3
[NAME] | 2
Jasper | 2
Felix | 2
Juniper | 2
Elijah | 2
Camila | 2
Willow | 2
[NAME] | 2
Penelope | 2
Elara | 2
Silas | 2
Thalia | 2
[NAME] | 2
Sofia | 2
Spreadsheet: 734042d1621952083-dependency-drop-down-based-on-values-from-another-cell-eh_prm_test-part-1
Sheet: Snapshot

Metrics | Customer view
 | [NAME] | Nadia | [NAME]
 | Analytics​ | Attribution​ | Client Deliverables​ | Client/Company​ | Data Load​ | Development​ | Model change​ | New Business​ | Other​ | Quality​ | User Permissions & Data Scoping​
Changes
Changes requested | 1
Changes accepted
Changes rejected | 2
Changes WIP | 3
No changes needed
Average length of open task
Longest open task
Metrics |  |  |  |  |  | Agent view
 | [NAME] | Nadia | [NAME]
 | Analytics​ | Attribution​ | Client Deliverables​ | Client/Company​ | Data Load​ | Development​ | Model change​ | New Business​ | Other​ | Quality​ | User Permissions & Data Scoping​
Changes
Changes requested
Changes rejected
Changes WIP
Average length of open task
Longest open task
Spreadsheet: 111695d1308035719-first-and-last-prototype-and-convert-to-unique-number-first-and-last-prototype-and-convert-to-unique-number
Sheet: Sheet1

 | Control Limits of each prototype |  |  |  |  |  |  |  |  |  | Count of Application / Build Version | System ID
 | Prototype | No of Application / Build Version | Last Application/Build Version of current prototype | First Application/Build of next prototype | Effort/ Application or Build | LCLNatural | UCLNatural | UCLmR |  | [NAME] | Application / Build Version | A | B1 | B2 | C01 | C02 | C1 | Grand Total
 | A | 1 |  |  | 1109.5 |  |  |  |  |  | A03.02 | 6 |  |  |  |  |  | 6
 | B1 | 3 |  |  | 3792.083333333333 |  |  |  |  |  | B1.00 |  | 16 |  |  |  |  | 16
 | B2 | 8 |  |  | 97.5 |  |  |  |  |  | B1.01 |  | 14 |  |  |  |  | 14
 | C01 | 4 |  |  | 585.0625 |  |  |  |  | … | B1.02 |  | 12 |  |  |  |  | 12
 | C02 | 2 |  |  | 1164.875 |  |  |  |  | … | B1.04 |  |  | 2 |  |  |  | 2
 | C1 | 3 |  |  | -8051.833333333333 |  |  |  |  | … | 3.01 |  |  | 40 |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | … | 3.02 |  |  | 14 |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | .. | 3.03 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | … | 3.04 |  |  | 12 |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | … | 3.05 |  |  | 20 |  |  |  | 20
 |  |  |  |  |  |  |  |  |  | … | 3.06 |  |  | 5 |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 3.07 |  |  | 82 |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  | 4.02 |  |  |  | 35 |  |  | 35
 | 1) | Is there any formula that to pull the last and 1st "Application / Build Version" for each prototype? |  |  |  |  |  |  |  |  | 4.03 |  |  |  | 22 |  |  | 22
 |  | As the table next to it is a pivot table… I want to exclude the Grand Total too. |  |  |  |  |  |  |  |  | 4.04 |  |  |  | 65 |  |  | 65
 |  |  |  |  |  |  |  |  |  |  | 4.05 |  |  |  | 24 |  |  | 24
 | 2) | As I need to do a vlookup for the column LCLnatural and UCL Natural from another source, is there a way that I can replace the |  |  |  |  |  |  |  |  | 5.01 |  |  |  |  | 5 |  | 5
 |  | Prototype number to VT Cycle that is in [NAME] so that the 1st and Last "Application / Build Version is Represented by [NAME] (which is [NAME]) |  |  |  |  |  |  |  |  | 5.03 |  |  |  |  | 5 |  | 5
 |  |  |  |  |  |  |  |  |  |  | 5.04 |  |  |  |  |  | 15 | 15
 |  | I tried nested if and it works but the condition is limited. |  |  |  |  |  |  |  |  | 5.05 |  |  |  |  |  | 7 | 7
 |  |  |  |  |  |  |  |  |  |  | 5.06 |  |  |  |  |  | 15 | 15
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 6 | 42 | 176 | 146 | 10 | 37 | 417
Spreadsheet: 66321d1267008315-pivot-table-count-and-sum-latest-revision-from-the-database-pr-e-room-2010-02-24
Sheet: Generator

Scene 1: Count the latest Revision |  |  |  |  | Scene 2: Sum the latest Revision
Generated by PIVOT |  |  |  |  | Generated by PIVOT
Count of TYPE | TYPE |  |  |  | Sum of USD VALUE | TYPE
GENERATOR | Materials | Services | Grapd Total |  | GENERATOR | Materials | Services | Grapd Total
[NAME] | 14 | 1 | 15 |  | [NAME] | 4124997.236666667 | 0.006666666666666667 | 4124997.243333334
Wisdom | 7 |  | 7 |  | Wisdom | 114387.9733333333 |  | 114387.9733333333
Ozobeme, F. | 9 | 10 | 19 |  | Ozobeme, F. | 299660.5 | 147508.0284 | 447168.5284
[NAME] |  | 1 | 1 |  | [NAME] |  | 73893.33333333334 | 73893.33333333334
Grapd Total | 30 | 12 | 42 |  | Grapd Total | 4539045.71 | 221401.3684 | 4760447.078400001
 |  |  |  |  | SHOULD BE:
SHOULD BE: |  |  |  |  | Sum of USD VALUE | TYPE
Count of TYPE | TYPE |  |  |  | GENERATOR | Materials | Services | Grapd Total
GENERATOR | Materials | Services | Grapd Total |  | [NAME] | 4124988.696666667 | 0.006666666666666667 | 4124997.243333334
[NAME] | 13 | 1 | 14 |  | Wisdom | 114387.9733333333 |  | 114387.9733333333
Wisdom | 7 |  | 7 |  | Ozobeme, F. | 299500.3333333334 | 147371.4217333333 | 329518.5284000001
Ozobeme, F. | 6 | 6 | 12 |  | [NAME] |  | 73893.33333333334 | 73893.33333333334
[NAME] |  | 1 | 1 |  | Grapd Total | 4421595.71 | 221201.3684 | 4642797.078400001
Grapd Total | 26 | 8 | 34
Spreadsheet: 721619d1614791764-getting-array-index-formula-to-ignore-blank-cells-ef-gk
Sheet: Sheet1

Q |  |  | Unique List
W
E
R
T
Y
E
R
T
Y
Q
W
Spreadsheet: 678216d1589785765-my-parent-drop-down-is-in-column-g-and-dependent-drop-down-is-in-column-k-not-working-xisaabaadka-al-barakacopy-repaired-
Sheet: Warbixin - qabyo

[NAME]
[NAME]
 |  | Lacagta | %
 | Hanti | 308816.9999999999 | 0.2499999999999999
 | [NAME] | 308817 | 0.25
 | [NAME] | 0 | 0
 | [NAME] | 82410.30000000002 | 0.0667145105353656
 | Raasamaal | 226406.7 | 0.1832854894646344
 | Raasamaal | 228928.65 | 1.01113902547937
 | [NAME] | 114144.23 | 0.4986017695906563
 | Shirkadda OPEC | 114784.42 | 0.5013982304093436
 | [NAME] | -500 | -0.002208415210327256
 | [NAME] | -250 | -0.001104207605163628
 | Qiima Dhimis | 80 | 0.000353346433652361
 | Khasaare | -1851.95 | -0.008179749097531124
 | [NAME] iyo [NAME] | 308817.0000000001 | 0.25
Spreadsheet: 740240d1626252861-trying-to-interpolate-a-table-aviation-help-please-aligw
Sheet: Sheet1

Altitude (1,000ft) | Weight (tonnes)
 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40
41 |  |  |  |  | 30 | 7 | 0 | 4 | 16 | 33
 |  |  |  | 22 | 4 | 0 | 4 | 15 | 30 | 45
 |  | 37 | 14 | 2 | 0 | 5 | 15 | 28 | 43 | 56
 | 23 | 7 | 0 | 0 | 6 | 16 | 28 | 41 | 54 | 64
 | 2 | 0 | 2 | 8 | 18 | 29 | 41 | 53 | 62 | 68
 | 0 | 4 | 11 | 21 | 31 | 42 | 52 | 61 | 67 | 70
 | 7 | 15 | 24 | 34 | 43 | 53 | 61 | 67 | 70 | 70
 | 19 | 27 | 36 | 45 | 54 | 61 | 66 | 70 | 70 | 68
 | 31 | 40 | 48 | 55 | 62 | 67 | 70 | 70 | 69 | 64
 | Question
 | What value is obtained from the table for a aircraft weight of 58 tonnes at a altitude of 32,000ft?
 | Manual caluclation
 | - Interpolate between 60 & 55 tonnes for both 33,000 and 31,000ft.
 | - copying data from the table and interpolating for 58 tonnes on the x axis
 |  |  |  | 58
 | - now interpolating the 58 tonne data in the Y axis
 | 32
 | - Answer is 41.1
 | Now how do I build a workbook such that I can have input fields for weight and altitude and a forumla calculates the correct output
Spreadsheet: chris_germany__1897__Oglethorpe2001_05
Sheet: Oglethorpe2001_05

sitara # | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Pipeline_Point_Code | Point_Name | Is_Tax_Detail | Item_Description | Quantity | Quantity_Unit_Id | Unit_Price | Statement_Amount
766316 | 5/3/2001 00:00:00 | 5/3/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT | N | Cost of Gas | 4250 | MMBtu | 4.9 | 20825
793871 | 5/17/2001 00:00:00 | 5/17/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 32000 | MMBtu | 4.4 | 140800
774325 | 5/8/2001 00:00:00 | 5/31/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Demand Charges |  |  | 1 | 93835
774325 | 5/8/2001 00:00:00 | 5/8/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 4500 | MMBtu | 4.395 | 19777.5
774325 | 5/9/2001 00:00:00 | 5/9/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 10000 | MMBtu | 4.29 | 42900
774325 | 5/10/2001 00:00:00 | 5/10/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 10000 | MMBtu | 4.2 | 42000
774325 | 5/11/2001 00:00:00 | 5/11/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 5500 | MMBtu | 4.245 | 23347.5
774325 | 5/18/2001 00:00:00 | 5/18/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 15000 | MMBtu | 4.29 | 64350
774325 | 5/25/2001 00:00:00 | 5/25/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | N | Cost of Gas | 1893 | MMBtu | 4.22 | 7988.46
774072 | 5/1/2001 [NAME] | 5/31/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT | N | Cost of Gas | 77402 | MMBtu | 0 | 0
774072 | 5/1/2001 [NAME] | 5/31/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT | N | Exchange Fee |  |  | 0.1861 | 14404.51
Spreadsheet: 798659d1664622198-reversing-amount-based-on-paid-column-book2
Sheet: Sheet1

PatientID | Invoice | Invoice Balance | Patient Paid | Total | [NAME] | Reverse
1234 | 5678 | 3.85 | 14.05 | 14.24 | 0.19 | 0.19
1234 | 4231 | 2.89 | 14.05 | 14.24 | 0.19
1234 | 5641 | 0.43 | 14.05 | 14.24 | 0.19
1234 | 8743 | 14.33 | 14.05 | 14.24 | 0.19
5566 | 489 | 500 | 50 | 3728.24 | 3678.24 | 50
5566 | 1569 | 100 | 50 | 3728.24 | 3678.24
Spreadsheet: 41425d1239892377-array-formula-test7
Sheet: Results Key

1 | 21000 | SC | NRT  - Product 1
2 | 15000 | EAP | EAP - Product 2
3 | 1440 | GM | Globalfit - Product 3
4 | 189000 | SC | Test - Product 4
5 | 0 | GM | Get up and start walking
6 | 10500 | MISC | First aid CPR class
7 | 0 | MISC | Go to a Dance
Spreadsheet: 296454d1392096351-matching-data-in-two-sheets-to-consolidate-the-data-sample-file
Sheet: Result Sheet 1

Destination | Country | Quantity
MIAMI | USA | 20
[NAME] | USA | 10
SYDNEY | AUSTRALIA | 10
BREMEN | GERMANY | 10
BREMEN | GERMANY | 15
[NAME] | USA | 20
Spreadsheet: mark_whitt__25298__El paso pipeline marketing
Sheet: Sheet1

Marketing Target
1) [NAME] | Lead | Customer Contact | Status | Comments
Huber | [NAME] | [NAME] | Should close this week | Recommending to management
Pure | J.Z. |  | Package being prepared--presented this week
Phillips | [NAME] | [NAME] | Not considering long term deals at this time
Amoco | [NAME] |  | Presentation made, customer to complete discussions this week | Continuing conversations via phone
[NAME] | [NAME] |  | Presentation made, customer to complete discussions this week | Continuing conversations via phone
Texaco/Chevron | [NAME] |  | Presentation made, customer to complete discussions this week | Continuing conversations via phone
Cross Timbars | [NAME] |  | not interested
Western Gas | M.N. | [NAME] | reviewing; minimal interest
BP Amoco ([NAME]) | [NAME] |  | Interested in capacity for Calpeak deal | Expect feedback on Wed 10/3
2) Generation | Lead |  | Status | Comments
Reliant | [NAME] |  | talked to Kern once, will discuss again | Will contact this week
Calpine | [NAME] |  | 10/3 Calpine "frozen " - do not expect action soon | medium probability
Mirant | [NAME] |  | Based on 9/25 discussion,[NAME] to provide feedback on their valuation - 10/3 left message | low probability
NRG | [NAME] |  | Call into [NAME] | low probability
FPL | [NAME] |  | Proposal sent to [NAME] 9/26 - phone call from FPL 10/5 [NAME] is rep. | low probability
AES | [NAME] |  | 2 low load factor plants in [NAME]. with 2004 start. Not looking to buy firm transport - projects doubtful ([NAME]) | no probability
Tractabel | [NAME] |  | [NAME] advised (9/25) that they're "done" on firm transport. No need for incremental | medium probability
Mexicana de Cobre | [NAME] |  | Offered earlier start date (9/21) to go with package previously assigned | low probability
SPPC/NPC | [NAME] |  |  | low probability
[NAME] ([NAME]) | [NAME]
Evergreen Power | [NAME]
Ogden Pacific | [NAME]
3) Current EPNG Shippers | Lead |  | Status | Comments
Duke | [NAME] |  | Low interest on Duke's part - last offer was $7.5 - $8MM for 1/02 start  and $1 MM for a 11/03 start | low probability
El Paso | N/A
Tenaska | [NAME] |  | Fred passed to [NAME] -will call today. | low probability
SMUD | [NAME] |  | [NAME] regarding '03 capacity sent
4) Industrial | Lead |  | Status | Comments
Palo Alto | [NAME] | [NAME] | create term sheet/structure.  Would only be interest jan. 2003 forward
NCPA | [NAME] |  | create term sheet/structure
Santa Clara | [NAME] | [NAME] | create term sheet/structure.  Would only be interest jan. 2003 forward
Knauf Fiberglass | [NAME] | [NAME] | create term sheet/structure
Spreadsheet: daren_farmer__5933__SMI23reveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From:  [NAME] ([NAME])
Date:  06/08/00
Subject:  Revised Availabilities Effective 06/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | SMI 23 | 64990 | 0.1162 |  |  | 41153
1st of month DBQ = 41153/d.
Spreadsheet: 778574d1651157287-week-predictor-cashflow-sample
Sheet: Creditors

Priority | Payment Type | A/C | Client | Type | Inv Date | Due Date | Inv No. | Details | Gross | Paid | Outstanding |  |  | Due Date | Expecting Payment | EOM | Week | Funidng Type
 | 0 |  |  |  | 2022-01-03 00:00:00 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
0 | 1 | TES001 | Test1 |  | 2022-02-21 00:00:00 |  |  | Test |  |  | 100
1 | 1 | TES002 | Test2 |  | 2022-12-15 00:00:00 |  |  | Test |  |  | 175
1 | 1 | TES003 | Test3 |  | 2022-06-16 00:00:00 |  |  | Test |  |  | 999.01
1 | 1 | TES004 | Test4 |  | 2022-09-13 00:00:00 |  |  | Test |  |  | 25
Spreadsheet: 36452d1234337953-creat-sub-layer-validation-dependentlists2
Sheet: Lists

A
PreSalesEnquiries | PostSalesEnquiries | TechnicalEnquiries | RepairEnquiries | ComplaintAnalysis
Location to purchase the devise | Device Registration | Synchronization | Warranty info | Device
Technical handset information | Device Reset | Hard Reset | Service Center Location | Service
Price for handset | Software Application | GPRS | Service Hours | Others
3rd Party application | 3rd Party Appplication | Setup Network | Others | Accessories
Cell Software info | End User technical guidance | ROM Version info | Status of call
Launch Date
Spreadsheet: 3162b01c-7700-4a0e-8362-179d22852037
Sheet: Setting codes

 | SFY 2014 FEDERAL CODE SHEET
SFY 2014 FEDERAL EDRS-SERVS-UFARS codes crosswalk
EDRS Setting Codes
Setting Codes Required for Personnel Type Codes 01 and 07 on EDRS
Ages 6 to 21
Setting Code | [NAME]
A | Regular Class
B | Resource Room
C | Separate Class
D | Public Separate Day School
F | Public Residential
G | Private Residental
H | Home Based/Homebound/Hospital
I | Lead Teacher Provides No Direct Service
Ages Birth Through 5
Setting Code | [NAME]
P | Birth through 2
Y | Early Childhood 3-5
Spreadsheet: 49618d1248971922-returning-multiple-values-index-with-multiple-conditions
Sheet: Master

Zone | Customer | Data | Set #1 | Set #2 | Set #3 | Set #4 | Set #5 | Set #6
Zone 1 | Crystal | Rate | 200 | 600 | 800 | 90 | 650
 |  | Volume | 8 | 6 | 1 | 2 | 24
Zone 1 | [NAME] | Rate | 550 | 750 | 999 | 799
 |  | Volume | 1 | 5 | 34 | 4
Zone 1 | Jordan | Rate | 300 | 50
 |  | Volume | 4 | 6
Zone 1 | Michelle | Rate | 500 | 600
 |  | Volume | 1 | 6
Zone 2 | Crystal | Rate | 798 | 300
 |  | Volume | 7 | 211
Zone 2 | [NAME] | Rate | 601 | 350 | 200 | 500 | 600
 |  | Volume | 276 | 1 | 165 | 58 | 3
Zone 2 | Jordan | Rate | 899 | 200 | 550
 |  | Volume | 1 | 30 | 1
Zone 2 | Michelle | Rate | 701
 |  | Volume | 361
Spreadsheet: 02d2c4ab-531f-43c1-b41b-fe533656f4ea
Sheet: 8-18-2014

IRN | DISTRICT | COUNTY | FISCAL STATUS | CAUTION  DECLARED | WATCH  DECLARED | EMERGENCY  DECLARED
048462 | Black River Local SD | Medina | CAUTION | 2011-02-18 00:00:00
043711 | Canton City SD | [NAME] | CAUTION | 2007-03-22 00:00:00
047845 | East Knox Local SD | Knox | CAUTION | 2012-09-04 00:00:00
043968 | Fairborn City SD | Greene | CAUTION | 2013-01-14 00:00:00
045369 | Fairport Harbor Ex Vill SD | Lake | CAUTION | 2004-04-30 00:00:00
045823 | Hillsdale Local SD | Ashland | CAUTION | 2012-06-14 00:00:00
044230 | Lockland Local SD | [NAME] | CAUTION | 2013-11-22 00:00:00
044263 | Lorain City SD | Lorain | CAUTION | 2007-06-23 00:00:00
048025 | North Fork Local SD | Licking | CAUTION | 2010-03-25 00:00:00
046599 | Richmond Heights Local SD | Cuyahoga | CAUTION | 2014-03-17 00:00:00
046003 | Shadyside Local SD | Belmont | CAUTION | 2004-04-12 00:00:00
049064 | Southern Local SD | [NAME] | CAUTION | 2011-04-11 00:00:00
048652 | Switzerland of Ohio Local SD | Monroe | CAUTION | 2010-07-31 00:00:00
045005 | Warrensville Heights City SD | Cuyahoga | CAUTION | 2008-05-05 00:00:00
049999 | Coventry Local SD | Summit | WATCH |  | 1997-05-15 00:00:00
044495 | Niles City SD | Trumbull | WATCH |  | 2003-03-10 00:00:00
043570 | Bellaire Local SD | Belmont | EMERGENCY |  |  | 2009-12-31 00:00:00
050120 | Brookfield Local SD | Trumbull | EMERGENCY |  |  | 2013-05-14 00:00:00
048488 | Cloverleaf Local SD | Medina | EMERGENCY |  |  | 2012-01-24 00:00:00
047209 | Ledgemont Local SD | [NAME] | EMERGENCY |  |  | 2010-11-09 00:00:00
050195 | Liberty Local SD | Trumbull | EMERGENCY |  |  | 2011-07-11 00:00:00
044297 | Mansfield City SD | Richland | EMERGENCY |  | 2006-12-08 00:00:00 | 2013-12-17 00:00:00
139303 | Monroe Local SD | Butler | EMERGENCY |  |  | 2012-05-09 00:00:00
Spreadsheet: 296383d1392069750-prevent-duplicating-data-when-using-data-validation-list-cf-dups-in-col-h
Sheet: Sheet1

Account | Name | Dr in EGP | Cr in EGP | Net |  |  | Cash in safe- EGP
 | Cash in safe- EGP |  |  |  |  |  | Cash in safe EURO
 | Cash in safe USD |  |  |  |  |  | Cash in safe- EGP
 | Cash in safe EURO
 | Cash in safe ESTRLING
 | CIB egp 422
 | CIB egp 414
 | CIB usd 349
 | CIB usd 356
 | CIB euro [PHONE]
 | HSBC EGP
 | HSBC  US$
 | HSBC EURO
 | CIB TIME DEPOSIT USD
 | CIB Cash cover for LG
 | Cheques under collections
 | Accounts receivable
 | [NAME] custody
 | Accrued revenue
 | Debtors
 | Debit Sales tax
 | Deduction from source DEBIT
 | Guarantees at others
 | Prepaid Insurance
 | Prepaid Leased Containers
 | Prepaid Others
 | FA
 | Accumulated Depreciation
 | Account Payable
 | NOTES PAYABLE
 | Accrued expenses
 | Taxes on Salaries - Credtiors
 | Social Insurance on Salaries - Creditors
 | Credit Sales tax
 | Deduction from source CREDIT
 | Agents Outside - Creditors
 | Agent Egypt - Creditors
 | Other Creditors
 | CA- Namma Intl
 | [NAME]
 | CA - Hammad
 | Namma tours
 | LIBYA NAMMA SHIPPING AGENCIES NCL
 | Namma Shipping MXL COLLECTION
 | Namma Shipping MXL PAYMENT
 | NESMAL
 | VESSEL ADJUSTMENT
 | Defered Tax
 | Capital
 | Accumulated losses 2009
 | Income from NVOCC
 | Income from Friegt Forwarding
 | Un realized gain
 | NVOCC Operating expenses
 | Forwarding Operating expenses
 | Depreciation-containers
 | salaries
 | STAMP TAX
 | Insurance expenses
 | Travel & Transportation expenses
 | LIBYA Travel & Transportation expenses
 | Communication
 | Professional expenses
 | rent
 | [NAME] expenses
 | Electricity,Gas&Water
 | Accomodation & hospitality
 | Stationary expense
 | Business development expenses
 | bank charges
 | Unrealized loss
 | Depreciation computers-edp
 | Depreciation Communications-edp
 | Depreciation Air-Conditioner
 | Depreciation furniture