tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742649d1627934441-cell-contents-is-also-found-in-a-range-of-cells-then-is-text-in-adjacent-columns-equal-v1-revised
Sheet: Sheet2

Last report | status | Bucket Name | Version | definition
2021-07-26 00:00:00 | [NAME] | cm-dodger | v1 | ["0025CA0A000071DD"]
2021-07-26 00:00:00 | [NAME] | cm-dodger | v1 | ["0025CA0A0000052E","0025CA0A00000518"]
2021-07-26 00:00:00 | [NAME] | cub | v1 | ["0025CA0A00007BD3","0025CA0A00007B6D","0025CA0A00007B28","0025CA0A00007AE5","0025CA0A000079D8","0025CA0A00007687","0025CA0A00007668","0025CA0A0000744B","0025CA0A000073A6","0025CA0A00007361","0025CA0A0000735F","0025CA0A0000735D","0025CA0A00007358","0025CA0A00007357","0025CA0A0000734E"]
2021-07-26 00:00:00 | [NAME] | cub | v1 | ["0025CA0A00007B6E","0025CA0A00007B68","0025CA0A00007A6A","0025CA0A00007472","0025CA0A00007434","0025CA0A0000739F","0025CA0A0000739C","0025CA0A00007368","0025CA0A00007362"]
2021-07-26 00:00:00 | [NAME] | giant | v1 | ["0025CA0A000042A7"]
2021-07-26 00:00:00 | susan | giant | v1 | ["0025CA0A00002698"]
2021-07-26 00:00:00 | susan | giant | v1 | ["0025CA0A00001C81","0025CA0A00001C7F"]
2021-07-26 00:00:00 | susan | giant | v1 | ["0025CA0A000011E1"]
Spreadsheet: 91708d1291379380-auto-fill-columns-b-c-d-based-on-column-data-of-a-master-list-in-a-2nd-sheet-auto-fill
Sheet: Sheet1

No | Model | Description | Price
1 | MPC2600 | Black | 10
2 | MPC 3000 | Black | 15
3 | MPG 4000 | Black | 20
4 | [NAME] D8000 | Yellow | 55
5 | MF d3400 | Yellow | 40
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 5

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | Total spent = |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 4547238.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 4547238.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 1
Spreadsheet: 137932d1327434596-automatically-create-graphs-based-on-specific-data-graph-data
Sheet: ANR

Date | responsible | Order Compliance (%) | ASN Compliance (%) | Arrive O Port Compliance (%) | Depart on Air Compliance (%)
2011-12-02 00:00:00 | ANR | 100 | 100 | 80 | 80 |  |  |  | Graph 1 | X axis = date
2011-12-05 00:00:00 | ANR | 100 | 100 | 100 | 80 |  |  |  |  | Y axis = value
2011-12-06 00:00:00 | ANR | 80 | 100 | 100 | 75 |  |  |  |  | Should show Order compliance values
2011-12-08 00:00:00 | ANR | 83 | 100 | 100 | 80
2011-12-09 00:00:00 | ANR | 100 | 100 | 100 | 100 |  |  |  | Graph 2 | X axis = date
2011-12-12 00:00:00 | ANR | 100 | 100 | 100 | 100 |  |  |  |  | Y axis = value
2011-12-13 00:00:00 | ANR | 100 | 100 | 83 | 83 |  |  |  |  | Should show ASN compliance values
2011-12-14 00:00:00 | ANR | 100 | 100 | 100 | 100
2011-12-15 00:00:00 | ANR | 100 | 86 | 100 | 100 |  |  |  | Graph 3 | X axis = date
2011-12-16 00:00:00 | ANR | 100 | 100 | 100 | 100 |  |  |  |  | Y axis = value
2011-12-19 00:00:00 | ANR | 100 | 100 | 100 | 100 |  |  |  |  | Should show Arrive O Port compliance values
 |  |  |  |  |  |  |  |  | [NAME] | X axis = date
 |  |  |  |  |  |  |  |  |  | Y axis = value
 |  |  |  |  |  |  |  |  |  | Should show [NAME] on Air compliance values
Spreadsheet: 47700d1246879851-summing-value-of-characters-test
Sheet: Sheet1

 | A | B | D | E | E
 | E | B | D | B | A
 | A | B | C | D | E
 | C | C | B | A | E
 | C | A | A | B | D
 | Text | Value
 | A | 25
 | B | 20
 | C | 15
 | D | 10
 | E | 5
Spreadsheet: 6ccc9661-aad2-47d5-a1f5-f25687312285
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2012
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 380 |  | 378 |  | 952 |  | 750
Florida | 108 |  | 107 |  | 897 |  | 200
Georgia | 1290 |  | 1285 |  | 1027 |  | 2750
North Carolina | 585 |  | 580 |  | 993 |  | 1200
South Carolina | 299 |  | 298 |  | 918 |  | 570
Virginia | 86 |  | 85 |  | 1129 |  | 200
Southeast | 2748 |  | 2733 |  | 996 |  | 5670
Arkansas | 595 |  | 585 |  | 1083 |  | 1320
Louisiana | 230 |  | 225 |  | 1003 |  | 470
Mississippi | 475 |  | 470 |  | 970 |  | 950
Missouri | 350 |  | 330 |  | 1033 |  | 710
Tennessee | 380 |  | 375 |  | 934 |  | 730
Delta | 2030 |  | 1985 |  | 1011 |  | 4180
Kansas | 56 |  | 54 |  | 578 |  | 65
Oklahoma | 305 |  | 140 |  | 480 |  | 140
Texas | 6550 |  | 3900 |  | 615 |  | 5000
Southwest | 6911 |  | 4094 |  | 610 |  | 5205
Arizona | 200 |  | 197 |  | 1511 |  | 620
California | 142 |  | 141 |  | 1651 |  | 485
New Mexico | 46 |  | 40 |  | 1080 |  | 90
West | 388 |  | 378 |  | 1517 |  | 1195
Total Upland | 12077 |  | 9190 |  | 849 |  | 16250
Pima:
Arizona | 3 |  | 3 |  | 1152 |  | 7
California | 225 |  | 224 |  | 1575 |  | 735
New Mexico | 2 |  | 2 |  | 981 |  | 5
Texas | 8 |  | 8 |  | 832 |  | 13
Total Pima | 238 |  | 237 |  | 1540 |  | 760
Total all | 12315 |  | 9427 |  | 866 |  | 17010
Last update: 1/14/13.
Source:  USDA, January 2013 Crop Production report.
Spreadsheet: 97223d1296465573-sum-of-top-entries-from-an-horizontal-array-of-data-sample_neo4u44
Sheet: CG-1

ABC
SECTION: 1
Fall 2010 |  | Quizez |  |  |  |  |  |  |  | Assignments |  | Quizez |  |  |  | Examinations |  | Total | Adjstd
# | Reg No | Q1 | Q2 | Q3 | Q4 | Q5 |  |  |  | 5 | 5 | 5 | 5 | 10 | 20 | 20 | 25 | 95 | 100 |  |  | Grades Summary Tables
 |  | 10 | 10 | 10 | 10 | 10 | Required: Average of top 3 marks |  |  | Pre-Mid | Post-Mid | Pre-Mid | Post-Mid | C.Part. | Project | Mid | Final | Score | Score | Grade
1 | R-123 | 7.9 | 8 | 8 | 5 | 7.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grade | GPA | Count
2 | [NAME] | 7.9 | 8 | 7.8 | 7 | 7.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A+
3 | R-125 | 7 | 7.9 | 7.4 | 7.5 | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
4 | R-126 | 8 | 7.9 | 4 | 6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A-
5 | R-127 | 7.9 | 7.9 | 7.9 | 8.2 | 8
6 | R-128 | 8.1 | 8.6 | 8.5 | 7.8 | 8.4
7 | R-129 | 8 | 8 | 8.1 | 7.7 | 8
8 | R-130 | 5 | 8.2 | 7.6 | 7.8 | 7.95
9 | R-131 | 8.3 | 8.5 | 8.5 | 8.2 | 8.5
10 | R-132 | 7.9 | 7 |  | 7.6 | 7.6
11 | R-133 | 8 | 8.6 | 8 | 8 | 8.5
12 | R-134 | 8.1 | 7.6 | 7.8 | 8 | 7.6
13 | R-135 | 8.7 | 8 | 8.3 | 7.8 | 6
14 | R-136 | 5 | 0 | 7 | 7 | 7.6
15 | R-137 | 7.9 | 8 | 7.9 | 7.9 | 7.7
16 | [NAME] | 8.7 | 8.7 | 0 | 7 | 8.6
17 | R-139 | 7.9 | 8 | 8.2 | 7 | 8
18 | R-140 | 8 | 8.2 | 7.8 | 7.3 | 8
19 | R-141 | 7.9 | 7.9 | 6.9 | 0 | 7.8
20 | R-142 | 7.9 | 7.8 | 7.4 | 5.5 | 7.9
21 | R-143 | 7.8 | 7.5 | 7.5 | 7.2 | 8
22 | R-144 | 8.2 | 8.4 | 7.9 | 7 | 8.4
23 | R-145 | 7.9 | 7.9 | 0 | 6 | 2
24 | [NAME] | 7.9 | 8 | 5.5 | 6 | 7.85
25 | [NAME] | 7 | 8.3 | 8 | 8.6 | 8
26 | R-148 | 7.6 | 7.9 | 8 | 8 | 9
27 | R-149 | 7.8 | 7.5 | 6.9 | 7.5 | 7.5
28 | R-150 | 6.8 | 0 | 7.9 | 7.6 | 6
29 | R-151 | 5 | 0 | 7.8 | 7.6 | 7.8
30 | R-152 | 7.6 | 8 | 6 | 6.8 | 8
31 | R-153 | 8.9 | 8.8 | 0 | 9 | 8.6
32 | R-154 | 7.5 | 7.5 | 8 | 6.4 | 7.3
33 | R-155 | 8.2 | 8.2 | 0 | 7.3 | 7.3
34 | R-156 | 7.8 | 7.9 | 8 | 0 | 7.8
35 | [NAME] | 8 | 8.6 | 8 | 8 | 7.8
36 | R-158 | 8.6 | 6.9 | 8.2 | 7 | 8.1
37 | R-159 | 8.2 | 8.6 | 8.7 | 7 | 8.1
38 | R-160 | 8 | 8 | 8 | 7 | 8.4
39 | R-161 | 0 | 7.8 | 7.8 | 7.9 | 0
Spreadsheet: 66091d1266782910-excel-2007-highlight-row-based-on-date-conditional-formatting-already-used-leave-tracker-example
Sheet: LEAVE TRACKER

RANK | NAME | TYPE | FROM | TO | REMARKS
SPC |  | LEAVE | 2010-02-12 00:00:00 | 2010-02-21 00:00:00
SPC |  | CONVALESCENT |  |  | AWAITING SURGERY FOR DATES
SGT |  | PCS | 2010-02-13 00:00:00 | 2010-03-10 00:00:00 | WAITING TO FALL OFF AAA-162
SPC |  | CONVALESCENT | 2010-01-30 00:00:00 | 2010-03-12 00:00:00 | CHILDBIRTH
SGT |  | PERMISSIVE TDY | 2010-02-21 00:00:00 | 2010-02-26 00:00:00 | FUNERAL ESCORT
SPC |  | EMERGENCY | 2010-02-16 00:00:00 | 2010-02-25 00:00:00
PFC |  | PASS | 2010-02-19 00:00:00 | 2010-02-22 00:00:00
PFC |  | PCS | 2010-03-04 00:00:00 | 2010-03-19 00:00:00 | WAITING TO FALL OFF AAA-162
SPC |  | CONVALESCENT | 2010-02-09 00:00:00 | 2010-03-11 00:00:00 | SURGERY / LEAVE FORM NOT SUBMITTED
SGT |  | PERMISSIVE TDY | 2010-02-26 00:00:00 | 2010-03-07 00:00:00 | NEW SOLDIER
SPC |  | PERMISSIVE TDY | 2010-03-01 00:00:00 | 2010-03-10 00:00:00 | NEW SOLDIER
SGT |  | ETS | 2010-02-14 00:00:00 | 2010-04-26 00:00:00 | WAITING TO FALL OFF AAA-162
SGT |  | PCS | 2010-02-18 00:00:00 | 2010-03-01 00:00:00 | WAITING TO FALL OFF AAA-162
SPC |  | CONVALESCENT | 2010-02-16 00:00:00 | 2010-03-29 00:00:00 | CHILDBIRTH
SPC |  | LEAVE | 2010-02-17 00:00:00 | 2010-02-26 00:00:00 | CHILDBIRTH
SPC |  | ETS | 2010-02-10 00:00:00 | 2010-02-19 00:00:00 | WAITING TO FALL OFF AAA-162
SPC |  | PCS | 2010-02-01 00:00:00 | 2010-02-20 00:00:00 | MISSED PCS DATE
SPC |  | CONVALESCENT | 2010-02-04 00:00:00 | 2010-03-06 00:00:00 | SURGERY
SPC |  | ETS | 2010-02-10 00:00:00 | 2010-04-10 00:00:00 | WAITING TO FALL OFF AAA-162
SPC |  | PCS | 2010-02-16 00:00:00 | 2010-02-19 00:00:00 | REPORTED TO EOD SCHOOL
 | NEEDS DATA
 | SM HAS HIT START DATE
 | SM HAS HIT END DATE
Spreadsheet: 330909d1404902192-formula-for-matching-two-sheets-with-only-part-of-the-description-dslr
Sheet: Sheet2

Description | Code
DIGITAL CAMERA CANON EOS 7D 18-135IS KIT | 1451995
DIGITAL SLR CAMERA NIKON D3100 KIT 18-55 | 1554395
DIG. CAMERA CANON EOS 1100D 18-55IS KIT | 1631713
DIGITAL CAMERA CANON EOS 600D 18-55IS + DSLR ENTRY ACCESSORY | 1631721
CAMERA NIKON D5100 KIT 18-55 VR + BAG + 8GB + UV PRAKTICA | 1655108
CAMERA NIKON D5100 18-55&55-200 + BAG + 8GB + UV PRAKTICA | 1673157
FLASH FOR DIGITAL SLR CAMERA CANON 430 EXII | 1721054
SLR CAMERA NIKON D3200 KIT 18-55 VR + BAG CF-EU05 + 8GB | 1777165
DIGITAL SLR CAMERA CANON EOS 650D 18-55IS II | 1827561
DIGITAL CAMERA SAMSUNG EV-NX1000 20-50MM WHITE | 1864378
DIGITAL CAMERA NIKON D5200 18-55 KIT + BAG + 8GB + ML-L3 | 1894846
DIGITAL SLR CAMERA NIKON D3100 18-105 + BAG + 8GB | 1920065
DIGITAL CAMERA NIKON D7100 KIT 18-105 VR + CF-EU05 BAG+SD8GB | 1948792
SLR NIKON D3100 KIT 18-55 + CASE + 8GB RED | 1952641
DIGITAL SLR CAMERA NIKON D3100 KIT 18-55 + CASE + 4GB | 1952668
DIGITAL SLR CAMERA SONY NEX-3NL 16-50MM | 1957147
DIGITAL SLR CAMERA SONY NEX-3NL 16-50MM WHITE | 1957155
DIGITAL SLR CAMERA SONY SLT-A58K 18-55MM | 1957163
DIG CAMERA SAMSUNG NX-300 18-55MM BLACK | 1983946
DIGITAL CAMERA OLYMPUS PEN E-PL3 14-42 BLACK + 8GB CARD | 1995421
DIG CAMERA SAMSUNG NX-2000 20-50MM BLACK | 2059258
DIG CAMERA SAMSUNG NX-2000 20-50MM WHITE | 2059266
DIG. CAMERA OLYMPUS E-PM2 14-42MM BLACK + TBC-404 | 2061112
DIG. CAMERA OLYMPUS E-PM2 14-42MM RED + TBC-404 | 2061120
DIGITAL CAMERA NIKON D5100 KIT 18-105 VR BUNDLE | 2066777
DSLR CAMERA SONY [NAME] ILCE-3000 | 2071320
DIGITAL CAMERA NIKON D5100 18-55MM & 55-200MM + CASE + TRIPO | 2076810
DIGITAL CAMERA NIKON D5200 18-55MM VR & 55-200MM VR | 2111845
DIGITAL CAMERA NIKON D5200 DOUBLE KIT 2 | 2116162
DIG. CAMERA OLYMPUS E-PM2 14-42MM WHITE + TBC-404 | 2125307
DSLR NIKON D3300 KIT BLACK 18-55 VR | 2135922
DIG. CAMERA SONY A5000 16-50MM BLACK | 2144794
DIG. CAMERA SONY A5000 16-50MM WHITE | 2144913
DIGITAL CAMERA SONY DSC-WX220 PINK | 2151006
DIGITAL CAMERA NIKON AW1 11-27.5MM BLACK | 2154102
DSLR CAMERA NIKON D3200 KIT 18-55 II VR | 2155044
DIGITAL CAMERA SAMSUNG NX MINI GREEN | 2173964
DIGITAL CAMERA SAMSUNG NX MINI PINK | 2173972
DIGITAL CAMERA SAMSUNG NX MINI BROWN | 2173980
Spreadsheet: 787866d1658101134-two-criteria-index-match-not-working-index-match2
Sheet: ETC

2022-06-01 00:00:00 | 2022-06-01 08:00:00 |  | LOWES | #[NAME]! | 106664236 | 2022-06-07 11:52:00 | Billed | 646 | 0 | ALI | 1 | EA | [NAME] | S12 | 73B | HUBO | HGIU502123 | 73 |  |  | 106664236 | LOWES | KISSIMMEE,FL | 1044 | 646 | 15 | 1 | HUBO | #[NAME]! | 2022-06-01 08:00:00 | S12
Spreadsheet: 841017d1693268145-display-tables-based-on-drop-down-pull-history-and-highlight-from-conditional-format-dontation-list
Sheet: 900 (CLEANERS)

CAT.# | NAME | ADDRESS | CONTACT | PHONE NUMBER | [NAME]
 | Mercy House Community Center | Tia Mica’s Closet & Pantry | 1249 S 111th Ave Cashion, Az 85329 | Mercy Arredondo | [PHONE] | [EMAIL]
 | Glendale Community Action Team | 6261 N 83rd Ave Glendale, AZ 85303 | Aimee Tibbits | [PHONE] | [EMAIL]
 | Boys & Girls Clubs of the Valley | 6420 W Maryland Ave Glendale, AZ 85301 | [NAME] | [PHONE] | [EMAIL]
 | [NAME] Charities | 501 E Roanoke Ave Phoenix, AZ 85004 | [NAME] | [PHONE] | [EMAIL]
 | Marvin's Mission |  | Lucinda | [PHONE]
 | Veterans against sex trafficking |  |  | [PHONE]
 | Sun City FD | 18602 N 99th Ave Sun City AZ 85373 |  | [PHONE]
 | MCSO Dist. 3 | 13063 W. Bell Road surprise, AZ 85374 |  | [PHONE]
 | 4 [NAME] youngtown | 11129 W Michigan Ave | Tanua Donaldson | [PHONE]
 | Halfway Home Rescue |  | [NAME] | [PHONE] | [EMAIL]
 | [NAME]'s Place |  | [NAME] | [PHONE]
 | Mom's Pantry | 13440 N Cave Creek Rd Phoenix, AZ 85022 | [NAME] | [PHONE] | [EMAIL]
 | MCSO Sheriff's Posse | 10861 W Sunland Dr Sun City, AZ | Capt. [NAME] | [PHONE]
Spreadsheet: 678ba362-89bf-4999-9ee5-a82512ec441c
Sheet: Sheet1

Ohio Department of Education | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | PCR Request
25 S. Front St., MS G03 w Columbus, OH 43215     Phone [PHONE] |  |  |  |  |  |  |  | Updated 2/6/14
Entity Name |  |  | IRN |  | County |  | Project Number
1.  General Information
C.F.D.A. Number
U.S.A.S. Fund Code
Cost Center Number
2.  Total Cash Basis Expenditures by Object Code
Salaries/100
[NAME]
Purchased Services/400
Supplies/500
Capital Outlay/600
Other/800
3.  Fiscal Summary
Allocation
Available Budget
Fiscal Information As Of
Cash Received
Total Cash Basis Expenditures |  |  |  |  |  |  |  | 0
Cash Balance On Hand |  |  |  |  |  |  |  | 0
Cash Available |  |  |  |  |  |  |  | 0
4.  Fund Request
Negative Amount
Advance Amount
Advance Period
Total Amount Requested |  |  |  |  |  |  |  | 0
5.  [NAME]
Explain need for Advance Amount in excess of 10% of Available Budget
Explain need for Advance Amount when Cash Balance On Hand exceeds 10% of Available Budget
As required by the Cash Management Improvement Act (codified as 31 CFR part 205 and 34 CFR 80.20 and 80.21), cash advances are limited to the immediate cash needs of the requesting entity. By submitting this cash request, the entity certifies that this request is in compliance with the Cash Management Improvement Act and 34 CFR 80.20 and 80.21 and will be disbursed in the month for which funds were requested. For cash requests submitted in July, August or September entity certifies that the underlying obligations were made prior to June 30. Additionally, by submitting this cash request, the entity certifies that the obligations incurred under this project, for which funds are requested, were made within the period of availability outlined in the grant agreement.
Name of Treasurer or CFO (typed) |  |  |  | Signature of Treasurer or CFO |  |  |  | Date
Address |  |  |  | City |  | State: |  | Zip
Telephone |  |  | Ext | FAX |  | E-Mail
Spreadsheet: 852163d1702272030-forecasting-values-tempforecast
Sheet: VTACscaling

Code | 0 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 21 | 22 | 23 | 24 | 26 | 27 | 28 | 29 | 31 | 32 | 33 | 34 | 36 | 37 | 38 | 39 | 41 | 42 | 43 | 44 | 46 | 47 | 48 | 49
IL | 0 | 27 | 32 | 37 | 41 | 45 | 48 | 50
JS | 0 | 26 | 32 | 38 | 42 | 46 | 49 | 51
LO55 | 0 | 18 | 22 | 26 | 31 | 36 | 42 | 50
KH | 0 | 20 | 24 | 28 | 33 | 37 | 43 | 50
KS | 0 | 32 | 37 | 40 | 43 | 46 | 48 | 50
LA | 0 | 34 | 41 | 46 | 50 | 53 | 54 | 55
MA | 0 | 24 | 27 | 31 | 34 | 37 | 42 | 50
PN | 0 | 19 | 22 | 26 | 30 | 35 | 41 | 50
PO | 0 | 20 | 26 | 32 | 38 | 43 | 47 | 50
PG | 0 | 16 | 21 | 27 | 33 | 39 | 45 | 50
[NAME] | 0 | 18 | 26 | 33 | 40 | 45 | 49 | 50
RU | 0 | 25 | 31 | 36 | 41 | 45 | 48 | 50
SE | 0 | 18 | 23 | 29 | 35 | 40 | 46 | 50
SI | 0 | 24 | 29 | 34 | 39 | 43 | 46 | 50
SP | 0 | 25 | 30 | 35 | 40 | 44 | 47 | 50
TU | 0 | 19 | 24 | 30 | 35 | 41 | 46 | 50
LO54 | 0 | 21 | 27 | 32 | 37 | 42 | 46 | 50
LO31 | 0 | 24 | 30 | 35 | 40 | 44 | 48 | 50
LI | 0 | 21 | 26 | 32 | 37 | 42 | 46 | 50
ME | 0 | 15 | 20 | 26 | 32 | 38 | 44 | 50
MD | 0 | 19 | 25 | 30 | 35 | 41 | 46 | 50
OS | 0 | 15 | 19 | 24 | 29 | 35 | 42 | 50
PL | 0 | 19 | 25 | 30 | 36 | 41 | 46 | 50
PH | 0 | 21 | 26 | 32 | 37 | 42 | 47 | 50
DT | 0 | 13 | 18 | 23 | 29 | 36 | 43 | 50
PY | 0 | 18 | 23 | 28 | 33 | 39 | 45 | 50
RS | 0 | 18 | 23 | 29 | 34 | 40 | 45 | 50
SO03 | 0 | 15 | 20 | 26 | 31 | 37 | 44 | 50
TT | 0 | 16 | 21 | 27 | 33 | 39 | 45 | 50
VC | 0 | 16 | 21 | 26 | 32 | 38 | 44 | 50
BU23 | 0 | 14 | 18 | 23 | 29 | 35 | 42 | 50
CT41 | 0 | 15 | 19 | 23 | 28 | 33 | 40 | 50
MU07 | 0 | 16 | 21 | 26 | 32 | 38 | 44 | 50
DN17 | 0 | 19 | 23 | 27 | 31 | 35 | 41 | 50
EG16 | 0 | 15 | 19 | 23 | 28 | 34 | 40 | 50
EQ08 | 0 | 16 | 21 | 26 | 32 | 38 | 44 | 50
FN19 | 0 | 15 | 19 | 24 | 29 | 34 | 41 | 50
CT37 | 0 | 16 | 20 | 25 | 30 | 35 | 42 | 50
HS31 | 0 | 15 | 19 | 24 | 30 | 36 | 42 | 50
HS32 | 0 | 15 | 19 | 24 | 29 | 34 | 41 | 50
IN60 | 0 | 15 | 19 | 24 | 29 | 34 | 41 | 50
ET16 | 0 | 20 | 25 | 30 | 35 | 40 | 45 | 50
LB21 | 0 | 18 | 22 | 27 | 32 | 37 | 43 | 50
MI19 | 0 | 18 | 22 | 26 | 30 | 35 | 40 | 50
MI30 | 0 | 18 | 22 | 26 | 31 | 37 | 42 | 50
SR41 | 0 | 14 | 18 | 23 | 27 | 33 | 40 | 50
Spreadsheet: 65116d1265847329-trouble-with-date-input-sample_dateerr
Sheet: Sheet1

ITEM | DATE | DEBIT | CREDIT
PO# 2441-L                         (intered "40219" for Date) | 2010-02-10 00:00:00 | 1540.6 |  |  | 437 | TOTAL
PO# 2443-A | 10-Feb | 640
Car Rental | 2/10 | 135.6
Motel | Feb 10 | 163.15
PO# 2450-D | 02/10 | 2271.55
Deposit (Ref#A86391HJ) | 2-10-2010 |  | 2000
[NAME] client | 2-10 | 62.1
Deposit (Ref#A42G434T) | Feb-11 | 0 | 2000
Deposit (Ref#A42G5LT3)        (intered "40201 for Date) | 2010-02-12 00:00:00 |  | 1250
Spreadsheet: 837702d1690366479-formula-to-use-indirect-with-index-and-match-from-different-sheets-index-match-problem-with-indirect-v1
Sheet: Summary

 | Inspectors | COMPANY
 |  | Company 1 | Company 2 | Company 3 | Company 4 | Company 5
 | Inspector 1
 | Inspector 2
 | Inspector 3
 | Inspector 4
 | Inspector 5
 | Inspector 6
Spreadsheet: 685138d1593759505-difficulties-using-solver-for-staff-schedule-complicated-criteria-set-schedule2-hydr-
Sheet: Constraints(Night)

Count of night shifts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count of number of night shifts in the next 4 days (forward and inclusive); [NAME] 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Constraint |  | <=3 | what if on 2 days of day 3 and on day 4?
 |  | Employee
Date | Week | [NAME] | [NAME] | Ayisha | [NAME] | Kaitlin | Jayme | [NAME] | [NAME] | Felix | [NAME] | Casual1 | Casual2 | Casual3 | Casual4 | Casual5 |  | Employuee
Spreadsheet: ee97375d-1280-4858-8cd0-176db8883ccc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
7.1. Pressupost total del projecte per partides i per organismes o entitats col·laboradores (en euros).
PARTIDES |  | Contribucions exteriors |  |  |  | Contribucions locals |  |  | Despesa total
 | Comunitat Autònoma | ONGD sol·licitant | [NAME] (*) | TOTAL | SOCI LOCAL | BENEFICIARIS | [NAME](*) | TOTAL
A. DESPESES DIRECTES
A.I. Terrenys |  |  |  | 0 |  |  |  | 0 | 0
A.II. Construccions |  |  |  | 0 |  |  |  | 0 | 0
A.III. Equips i subministraments |  |  |  | 0 |  |  |  | 0 | 0
A.IV. Personal Local |  |  |  | 0 |  |  |  | 0 | 0
A.V. Personal expatriat |  |  |  | 0 |  |  |  | 0 | 0
A.VI. Viatges, estades i dietes |  |  |  | 0 |  |  |  | 0 | 0
A.VII. Fons rotatori (**) |  |  |  | 0 |  |  |  | 0 | 0
A.VIII. Funcionament |  |  |  | 0 |  |  |  | 0 | 0
A.IX. Imprevists |  |  |  | 0 |  |  |  | 0 | 0
TOTAL DESPESES DIRECTES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% sobre el subtotal
B. DESPESES INDIRECTES
B.I. Formulació |  |  |  | 0 |  |  |  | 0 | 0
B.II. Control i seguiment |  |  |  | 0 |  |  |  | 0 | 0
B.III. Avaluació |  |  |  | 0 |  |  |  | 0 | 0
TOTAL DESPESES INDIRECTES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% sobre el subtotal
TOTAL GENERAL EN EUROS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% sobre el total
* Detallau el nom de cada entitat i especificau-ne la quantia.
** Només per a microcrèdits.
Spreadsheet: 679288d1590311098-ignore-hidden-cells-in-ampersand-function-ampersand-ignore-hidden-cells
Sheet: Sheet1

Location
London |  | Person | [NAME]
 |  | 1 | Southwark
 |  | 2 | Hackney
 |  | 3 | Kensington
 |  | 4 | Chelsea
 |  | 5 | Richmond
 |  | 6 | Notting [NAME]
 |  | 7 | Southwark
 |  | 8 | Hackney
 |  | 9 | Kensington
 |  | 10 | Chelsea
 |  | 11 | Richmond
 |  | 12 | Notting [NAME]
 |  | 13 | Southwark
 |  | 14 | Hackney
 |  | 15 | Kensington
 |  | 16 | Chelsea
 |  | 17 | Richmond
 |  | 18 | Notting [NAME]
 |  | 19 | Southwark
 |  | 20 | Hackney
 |  | 21 | Kensington
 |  | 22 | Chelsea
 |  | 23 | Richmond
 |  | 24 | Notting [NAME]
 |  | 25 | Southwark
 |  | 26 | Hackney
 |  | 27 | Kensington
 |  | 28 | Chelsea
 |  | 29 | Richmond
 |  | 30 | Notting [NAME]
 |  | 31 | Southwark
 |  | 32 | Hackney
 |  | 33 | Kensington
 |  | 34 | Chelsea
Spreadsheet: 170295d1343229540-how-to-pick-number-from-selected-column-b
Sheet: Sheet1

 |  |  | Headcount | Ans
 | 2012-01-12 00:00:00 | 1 |  | 2
 | 2012-03-12 00:00:00 | 3 |  | 25
January | 2
February | 22
March | 25
April | 5
May | 86
June | 9
July | 798
August | 24
September | 46
October | 68
November | 80
December | 7