tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 193109d1352730730-how-to-get-sum-values-of-dropbox-if-not-sum-return-a-statement-testing
Sheet: FINAL TEAM REPORT (Step 3)

POS | NAME | INJ (?) | OVR | COST | OVR+POW |  | POS | NAME | INJ (?) | OVR | COST | OVR+POW |  | POS | NAME | INJ (?) | OVR | COST | OVR+POW
QB--1 |  |  |  |  |  |  | LE--1 |  |  |  |  |  |  | K--1
QB--2 |  |  |  |  |  |  | LE--2 |  |  |  |  |  |  | [NAME]
QB--3 |  |  |  |  |  |  | LE--3 |  |  |  |  |  |  | P--1
QB--4 |  |  |  |  |  |  | LE--4 |  |  |  |  |  |  | P--2
HB--1 |  |  |  |  |  |  | RE--1
HB--2 |  |  |  |  |  |  | RE--2
HB--3 |  |  |  |  |  |  | RE--3
HB--4 |  |  |  |  |  |  | RE--4
FB--1 |  |  |  |  |  |  | DT--1
FB--2 |  |  |  |  |  |  | DT--2
WR--1 |  |  |  |  |  |  | DT--3
WR--2 |  |  |  |  |  |  | DT--4
WR--3 |  |  |  |  |  |  | LOLB--1
WR--4 |  |  |  |  |  |  | LOLB--2 |  |  |  |  |  |  | # OF OFFENSIVE PLAYERS
WR--5 |  |  |  |  |  |  | LOLB--3 |  |  |  |  |  |  | # OF DEFENSIVE PLAYERS
WR--6 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | # OF SPEACIAL TEAMS PLAYERS
WR--7
TE--1 |  |  |  |  |  |  | MLB--1 |  |  |  |  |  |  | TOTAL
TE--2 |  |  |  |  |  |  | MLB--2 |  |  |  |  |  |  | ROSTER SPOTS LEFT
TE--3 |  |  |  |  |  |  | MLB--3
LT--1 |  |  |  |  |  |  | MLB--4 |  |  |  |  |  |  | OFFENSE TOTAL
LT--2 |  |  |  |  |  |  | ROLB--1 |  |  |  |  |  |  | DEFENSE TOTAL
LT--3 |  |  |  |  |  |  | ROLB--2 |  |  |  |  |  |  | SPC TEAM TOTAL
LG--1 |  |  |  |  |  |  | ROLB--3 |  |  |  |  |  |  | TOTAL
LG--2 |  |  |  |  |  |  | ROLB--4 |  |  |  |  |  |  | Points over/under [NAME]
LG--3 |  |  |  |  |  |  | CB--1
C--1 |  |  |  |  |  |  | CB--2 |  |  |  |  |  |  | "X" in the "INJ (?)" indicates that the player is injured
C--2 |  |  |  |  |  |  | CB--3
C--3 |  |  |  |  |  |  | CB--4 |  |  |  |  |  |  | IF there is a new cap go into cell "S23" and change "1000" to the new cap ONLY
RG--1 |  |  |  |  |  |  | CB--5
[NAME] |  |  |  |  |  |  | CB--6
RG--3 |  |  |  |  |  |  | CB--7
RG--4 |  |  |  |  |  |  | FS--1
RT--1 |  |  |  |  |  |  | FS--2
RT--2 |  |  |  |  |  |  | FS-3
RT--3 |  |  |  |  |  |  | SS--1
 |  |  |  |  |  |  | SS--2
 |  |  |  |  |  |  | SS--3
Spreadsheet: 4d50c8e8-6d70-4d66-a722-e03c68c7d226
Sheet: Nigeria

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Nigeria | this year | last year | this year | last year | this year | last year
Spreadsheet: 708308d1607714558-sum-of-selective-cells-by-logic-in-a-row-book2
Sheet: Sheet2

 | Code-10 | Code-20 | Name | Code | Length | Name | Code | Length | Name | Code | Length | Name | Code | Length | Name | Code | Length
 | 700 | 300 | ABC | 10 | 100 | ABC | 10 | 200 | BCA | 20 | 250 | ABC | 10 | 400 | BCA | 20 | 50
 | SUM of cells next to Code 10=100+200+400 =700
 | SUM of cells next to Code 20=250+50 =300
Spreadsheet: cd83a4e7-d231-4c11-9b06-b9b83c74e81e
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80689412622 | [NAME] | Face Of God | 2004-02-07 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Spreadsheet: 68559d1269098217-excel-2007-how-to-put-00-prefix-to-all-country-calling-codes-book1
Sheet: Sheet1

9379 | 009379 |  | 009379
937504 | 00937504 |  | 00937504
355 | 00355 |  | 00355
355422 | 00355422 |  | 00355422
1264772 | 001264772 |  | 001264772
6721 | 006721 |  | 006721
1268 | 001268 |  | 001268
1268464 | 001268464 |  | 001268464
Your numbers | [NAME] |  | After copy - paste special
Spreadsheet: 90179d1289936686-sum-total-question-yesterdays-totals
Sheet: 1112

11/12/2010  Performance Data
 |  | 1st Work |  |  |  |  | QC |  |  |  | SC | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT | MMIG, RSCH & UPDT | All Other DA | IA  Forms Pkgs | IA  Trans | EDIT w/pass | PASS | FAIL | IA QC | SURINQ  &  Death Cert
 |  |  |  |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 1 | 10 | 5 |  |  |  |  |  |  |  | 86 | 3.5 | Reporting | 5.5 | 15.63636363636364
 | Dustin |  | 20 |  |  |  |  |  |  |  |  | 140 | 4.5 | Trending/out of office | 3 | 46.66666666666666
 | Sharron |  | 2 | 3 | 6 |  |  |  |  | 19 |  | 98 |  |  | 9 | 10.88888888888889
 | Roxy |  | 4 | 5 |  |  |  |  |  |  |  | 43 |  |  | 3 | 14.33333333333333
 | [NAME] |  |  |  |  |  | 2 | 7 | 4 |  |  | 78 |  |  | 7.5 | 10.4
 | Ana |  | 7 | 5 |  |  |  |  |  |  |  | 64 | 3 | PVC/Research | 5 | 12.8
 | Maria |  | 6 | 90 |  |  |  |  |  |  |  | 312 |  |  | 14.5 | 21.51724137931035
 | [NAME] | * | * | * | * | * | * | * | * | * | * | #N/A | * | out of office | 0 | #N/A
 | Petra |  |  |  |  |  | 1 | 2 | 4 |  |  | 42 | 13.5 | Checklist/PVC | 3.5 | 12
 | Regina |  |  |  |  |  | 2 | 12 | 2 |  |  | 96 | 0.5 | SWT | 8.5 | 11.29411764705882
 | Noy |  |  |  |  |  | 19 | 8 | 2 |  |  | 174 | 1 | sys issues/SWT | 12 | 14.5
 | [NAME] | * | * | * | * | * | * | * | * | * | * | #N/A |  | Out of Office / Paternity |  | #N/A
 | [NAME] | * | * | * | * | * | * | * | * | * | * | #N/A | * | Out of Office |  | #N/A
 | Michelle |  |  |  |  |  |  |  |  |  | 33 | 52.8 |  |  | 2.5 | 21.12
 | Keisha |  |  |  |  | 9 |  |  |  |  |  | 54 |  |  | 4 | 13.5
 | [NAME] |  |  |  | 12 | 28 |  |  |  |  |  | 204 |  |  | 16 | 12.75
TEAM TOTALS | Pts Earned: | 1 | 7 | 3 | 3 | 6 | 6 | 6 | 6 | 3 | 1.6 |  |  |  |  | #N/A
 | TASK VOLUME: | 1 | 49 | 108 | 18 | 37 | 24 | 29 | 12 | 19 | 33 | 1443.8 | 26 |  | 94 | 15.35957446808511
 | Pts Earned: | 1 | 343 | 324 | 54 | 222 | 144 | 174 | 72 | 57 | 52.8
Spreadsheet: 63026d1263999692-using-conditional-statements-to-create-an-ordered-list-cnps-inventory-wip
Sheet: D830

 | Name | Serial Number | Service Tag |  |  | Case 1 | Case 2 | Case 3
 | CNPS01WS | CN-0HN338-[PHONE] | FWTXWG1 |  |  | True | False | False
 | CNPS02WS | CN-0HN338-[PHONE] | BZTXWG1 |  |  | False | False | False
 | CNPS03WS | CN-0HN338-[PHONE] | JZTXWG1 |  |  | True | False | False
 | CNPS04WS | CN-0HN338-[PHONE] | 7ZTXWG1 |  |  | True | False | False
 | [NAME] | CN-0HN338-[PHONE] | 6TTXWG1 |  |  | False | False | False
 | CNPS06WS | CN-0HN338-[PHONE] | 8YTXWG1 |  |  | False | False | False
 | CNPS07WS | CN-0HN338-[PHONE] | HTTXWG1 |  |  | False | False | False
 | CNPS08WS | CN-0HN338-48643-84H-0336 | [NAME] |  |  | False | False | False
 | CNPS09WS | CN-0HN338-[PHONE] | GXTXWG1 |  |  | False | False | False
 | CNPS10WS | CN-0HN338-[PHONE] | 8WTXWG1 |  |  | False
 | CNPS11WS | CN-0HN341-48643-76I-0461 | HRFLBD1
 | CNPS12WS | CN-0HN341-48643-76I-0444 | 9SFLBD1
 | CNPS13WS | CN-0HN341-48643-76I-0462 | BSFLCD1
 | CNPS14WS | CN-0HN341-48643-76I-0464 | FSFLBD1
 | CNPS15WS | CN-0HN341-48643-76I-0436 | [NAME]
 | CNPS16WS | CN-0HN341-48643-76I-0459 | [NAME]
 | CNPS17WS | CN-0HN341-48643-76P-1107 | [NAME]
 | CNPS18WS | CN-0HN338-[PHONE] | 1ZTXWG1
 | CNPS20WS | CN-0HN338-[PHONE] | 6RTXWG1
 | CNPS21WS | CN-0HN338-[PHONE] | 4XTXWG1
 | [NAME] | CN-0HN341-48643-76P-0398 | 5SFLBD1
 | CNPS23WS | CN-0HN338-[PHONE] | 4WTXWG1
 | CNPS24WS | CN-0HN338-[PHONE] | 5STXWG1
Spreadsheet: benjamin_rogers__1010__TVA Wkly Anal - 121499
Sheet: Parts_Refurb $s

 | Spare Parts |  | Spare Parts
 | Actuals |  | per Invy Detail
Dynegy | 5000000 |  | 5000000
Natole | 359700 |  | 359700
Turbine Resources | 1126671.15 |  | 1126671.15
 |  |  | -1013887.05 | Not yet paid
Natole | 943800 |  | 943800
Selkirk | 3111381.03 |  | 3111381.03
Dow | 161700 |  | 161700 | incl in Dow Turbine line of budget
[NAME] |  |  | 198000 | Not yet paid
IBC Refurb of spares (Wood Group) |  |  | 1082508.47 | Not yet paid
Spare parts before adjustment
Parts staying at New Albany | 4391315.49
Refurb cost of parts staying at New Albany | 886191.12 |  |  | Not yet paid need to reconcile with IBC
Spare parts after adjustment for Units 1-4
Adjustment amount to New Albany cost summary
Estimate to complete Units 5-6 at New Albany | 2000000
Total Estimated Project cost for spares at New Albany
 | Refurbishment |  | Refurbishment
 | Actuals |  | Total Estimate
IBC Contract Payment #1 | 13392698 |  | 13392698
IBC Contract Payment #2 | 9374889 |  | 9374889
IBC Contract Payment #3 |  |  | 2678540 | Not yet paid
IBC Contract Payment #4 - Final |  |  | 1339270 | Not yet paid
Contract Out of Scope Work | 652369.63 |  | 652369.63 | LEC Combustion Burners ($593k scope change + 10% IBC fee)
WH Rent | 5400 |  | 5400
[NAME] | -167 |  | -167
TTS out of scope refurb expenses | 10246.5 |  | 10246.5
Waterway lease and Port of Pensacola chgs | 123281.75 |  | 123281.75
Scrap sale | -113214.4 |  | -113214.4
Other costs to complete |  |  | 0 | Per final refurb analysis
Refurb cost before adjustment
Spreadsheet: 716751d1612353470-getting-exact-match-across-2-sheets-using-sumproduct-testbook_1
Sheet: Scanned

EQUIPMENT BARCODE | [NAME] |  | comments
DO NOT ENTER DATA HERE
2788
[PHONE]
9865
QA116-001930
QA118-013295
[)>0617V1FKY11P8470016321294SPRD-00154748-0501T006N84700163212948KH9222214D00616D20150101094
[)>0617V1KRF41PIM-276A/PDSB0090963
[)>0617V1LEW51P4240015290593AD1S123160529R0091TAVO1231S06
 |  |  |  |  |  |  | 2788
 |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  | 9865
 |  |  |  |  |  |  | QA116-001930
 |  |  |  |  |  |  | QA118-013295
 |  |  |  |  |  |  | [)>0617V1FKY11P8470016321294SPRD-00154748-0501T006N84700163212948KH9222214D00616D20150101094
 |  |  |  |  |  |  | [)>0617V1KRF41PIM-276A/PDSB0090963
 |  |  |  |  |  |  | [)>0617V1LEW51P4240015290593S123160529R0091TAVO1231S06
Spreadsheet: 472244d1469511159-formula-vlookup-to-calculate-running-total-of-master-inventory-sheet-final-inventory-2
Sheet: Displays

 |  | PURCHASE |  | INVENTORY
ITEM NAME | [NAME] | Cases | Number | Total | Notes
Tablecloth-Fitted | 6' |  | 4
Tablecloth-Skins | 6' |  | 2
Tablecloth-Fitted | 8' |  | 4
A Frame (White) |  |  | 25
Bamboo Tree | Potted |  | 4
Bench |  |  | 5
Bistro Table |  |  | 6
Blu-Ray Player |  |  | 1
Cart | green |  | 1
Chairs (Collapsable) | grey |  | 2
Collateral Boxes (Rolling) | Black |  | 6
Couch | Red |  | 2 | 2
Dolly | grey |  | 1
Easels |  |  | 10
Ice Chest (Large) |  |  | 1
Ice Chest (Small) |  |  | 2
Leather Chair |  |  | 8
Mirage | City Scape |  | 1 |  | 2 cases
Mirage | Lineman |  | 1
Mirage | Child |  | 1
Podium | Electricity |  | 1
Pop up banner | Solar |  | 1
Prize Wheel | Large |  | 1
Prize Wheel | Small |  | 1
Side Tables | Red, Yellow, Green |  | 10
Stool |  |  | 4
Table (Folding) | 6 ft |  | 4
Tent | 10x10 |  | 4
Trade Show Box |  |  | 6
TV |  |  | 1
Vacuum |  |  | 1
Xpressions | SEED |  | 1
Xpressions | ED |  | 1
Sign Holders-Stands |  |  | 4
Heaters-Propane |  |  | 4
Spreadsheet: 198481d1354795061-if-prior-to-a-date-sample-time-zones
Sheet: Sheet1

Zone | UTC | BRT
Venues | ssdjksdjk | Rio de Janeiro, Sao Paulo, Brasilia
Standard Time [UTC +/-] | 0 | -3
Daylight Saving Time (DST)  [UTC +/-] | 1 | -2
DST End Date
DST Start Date
Spreadsheet: 871131d1717567426-get-data-by-map-data-input-1-1-aligw
Sheet: Report

Y | Type | Acc | Fname | Lname | Note | Remark
20 | A | IT | [NAME] | [NAME]
20 | A | Fin | Po | Aa
12 | V | Fin | Ty | rt
23 |  | iu | Mo | Aa
24 | A | IT | [NAME] | [NAME]
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: IT Infra-Cap

 | IT Infrastructure - Capital Projects
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  |  | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Data Center Relocation |  |  |  |  |  | 1100400
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Disaster Recovery |  |  |  |  |  | 11004000
ENAEMPEX | Core Infrastructure Build |  |  |  |  |  | 330120 |  | Other
ENAT&EEX | Temp Data Center Readiness |  |  |  |  |  | 165060
ENAOUTSV | Desktop Technology Refresh | 0 |  |  |  |  | 2751000 |  | Total
ENASUPP | Peripheral Technology Refresh |  |  |  |  |  | 825300
ENAMKTEX | Network Printer Refresh |  |  |  |  |  | 5942.16
ENATOTDR | Total Capital Expenses |  |  |  |  |  |  |  | IT Consultants | 192000 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 15
Spreadsheet: 5765b32d-68a8-43c9-a307-8813edb04178
Sheet: Sheet1

MASTER OF DIVINITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  | required |  | completed
1.103 | Intro to OT |  | 3
CHOICE | OT Elective |  | 3
CHOICE | OT Elective |  | 3
1.210 | Greek |  | 3
1.205 | Gospels |  | 4
1.206 | [NAME] |  | 4
2.425 | Early Church |  | 3
2.401 | Luther & Reformation |  | 3
2.406 | Luther & Confessions |  | 3
CHOICE | Modern Church History |  | 3
2.301 | Intro to Systematic Theol |  | 3
CHOICE | Theological Thematic |  | 3
2.304 | Intro to Ethics |  | 3
CHOICE | Pastoral Care |  | 3
CHOICE | Christian Education |  | 3
3.700 | Foundations in Homiletics |  | 1.5
CHOICE | Homiletics Elective |  | 1.5
CHOICE | Homiletics Elective |  | 3
CHOICE | Church in Society |  | 3
3.900 | Music in Parish |  | 1.5
CHOICE | Stewardship/Parish Ministry |  | 3
4.105a | Church's Worship -fall |  | 1.5
4.105b | Church's Worship -spring |  | 1.5
4.201a | Integrative Seminar 1-fall |  | 1.5
4.201b | Integrative Seminar 1-spring |  | 1.5
4.202 | Integrative Seminar II |  | 1.5
4.203 | Integrative Seminar III |  | 1.5
4.301 | Multi-cultural |  | 1.5
 | Other Tradition | ELCA only | 3
 | Electives |  | 16.5
 | NON-ACADEMIC REQ'D
 | Teaching Parish
 | CPE
 | Internship
 | Human Relations Workshop
 | Sexual Ethics Workshop
 | TOTAL ACADEMIC CREDITS |  | 90.5 |  | 0
Spreadsheet: 95953d1295460064-averageif-copy-of-hods-calander-2011
Sheet: LEADERBOARD

 | LEADERBOARD
 | GOLD STAR! | OCHO | 92.4
 | CLOSE BUT NO CIGAR | TINTO | 92
 | KEEP IT UP! | PORTO | 91.8
 | TRAILING THE PACK | SECO | 90
 |  | JUNO | 88.8
 |  | LUDO | 88.8
 |  | BANCO | 87
 |  | VELO | 86.4
 |  | FINO | 85.2
 |  | DECO | 84.6
 |  | LOUNGE | 75.4
 |  | TRAGO | 38.2
 |  | TAUNTON CC | 37.6
 | HEEL DRAGGERS | BATH CC | 37.6
 |  | ARCO | 35.6
 |  | PINTO | 35.6
 |  | [NAME] | 35.2
 |  | LOCO | 0
 |  | LOCO | 0
 |  | NO1 | 0
 |  | NO2 | 0
 |  | NO3 | 0
 | WOODEN SPOON | NO4 | 0
Spreadsheet: 880019d1727630115-populating-table-from-a-dropdown-list-drop-down-example
Sheet: Sheet1

 |  |  |  | Name | Table 1 |  |  | Table 4
 |  |  |  | # | Column 1 | Column 2 | Column 3 | Column 1 | Column 2 | Column 3
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 226033d1365213648-problem-solving-items-in-a-range-cost-in-relation-to-a-quantity-silkscreen-pricing-quote
Sheet: Sheet1

Silk Screen Charges
Qty. | 1 Colour | 2 Colour | 3 Colour | 4 Colour | 5 Colour | 6 Colour |  | Additional Charge Considerations
1 - 10 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 |  | Coloured Shirt - Screen printing starts one column over (Ex. 1 colour would be a 2 colour, 2 colour would be 3, etc.)
11 - 25 | 4.5 | 5.25 | 6 | 6.75 | 7.5 | 8.25 |  | [NAME] $5 per colour  **White is considered 2 colours as two layers must be applied.
26 - 50 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 |  | [NAME] - $10 per colour
51 - 75 | 2.75 | 3.15 | 3.55 | 3.95 | 4.35 | 4.75 |  | PMS [NAME]30 per colour
76 - 100 | 2.25 | 2.6 | 2.95 | 3.3 | 3.65 | 4 |  | [NAME] $40 per hour (1 hr. min.)
101 - 150 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 |  | Numbers - $4 per location
151 - 250 | 1.8 | 2 | 2.2 | 2.4 | 2.6 | 2.8 |  | Names - $5 per location
251+ | 1.7 | 1.8 | 1.9 | 2 | 2.1 | 2.2 |  | Additional locations are half the price of the first location, based on the highest colour quantity location.
Screen Set up: | 1 Colour | 2 Colour | 3 Colour | 4 Colour | 5 Colour | 6 Colour |  | Screen set up is a one time fee to create the screens for processing.
 | 15 | 30 | 45 | 60 | 75 | 90
Screen Cost Quote:  (All pricing is for silk screening.  Cost of shirts in addition.)
Shirt Quantity:
[NAME] for 1st location: |  |  |  |  | ** See Colour Charge
Additional Locations:
Number Custom Colours:
Number PMS Colours:
Location Qty for Numbers per shirt:
Location Qty for Names per shirt:
Number - Screen Set Up:
Silk Screen Charge for 1st Location:
Silk Screen Charge for 2nd Location:
Custom Colour Charge:
PMS Colour Charge:
Numbers Charge:
Names Charge:
[NAME]:
Silk Screen Subtotal:
Per Shirt Cost:
Shirt Cost Subtotal:
[NAME]:
Tax:
Order Total:
Spreadsheet: 542882d1508156436-auto-populate-the-nth-large-value-original
Sheet: Working

 |  | Department | PRO |  | By selecting the Dept & company , data should get auto populated from the Master sheet.
 |  | Company | FCE2 |  | Objective: To find the large Total by selecting 3 conditions (Dept, Company, Top)
 |  | Top | 7 |  | Top can be any Numbers
 |  |  |  |  | If I Select "ALL" in Dept & Company, according to Top, the output need to be derived
 |  |  | S.no | Emp No. | Emp Name | Job Description | Department | Company | Pay Grade | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Incorrect answer
 | Example
Spreadsheet: 130581d1322476083-check-date-and-time-and-set-indicator-forum
Sheet: Sheet2

I | II | III | IV
A1001 | 01.12.2011 | 8 - 9 am | c1001
A1002 | 01.12.2011 | 8 - 10 am | c1002
A1001 | 01.12.2011 | 9 - 10 am | c1003
A1002 | 01.12.2011 | 9 - 10 am | c1004
A1003 | 01.12.2011 | 9 - 9:30 am | c1002
Spreadsheet: 114559d1310313197-nested-if-comm
Sheet: Sheet4

 |  |  | Trip
 |  | Van Capacity | 1 | 2 | 3 | 4 | 5
 |  | 100 | 10 | 12 | 14 | 15 | 20
 |  | 200 | 20 | 23 | 25 | 27 | 30
 |  | 300 | 25 | 27 | 30 | 35 | 40
 | Driver | Trip No | Capacity | Comm $
 | A | 1 | 100
 | A | 2 | 200
 | B | 1 | 200
 | B | 2 | 100
 | B | 3 | 300
 | C | 1 | 200
 | C | 2 | 200
 | C | 3 | 300
 | C | 4 | 300
 | D | 1 | 200
 | D | 2 | 300
 | D | 3 | 200
 | D | 4 | 300
 | D | 5 | 100
Spreadsheet: dcaf708a-2087-440f-b0a5-9a8ddbcaaeee
Sheet: Sheet1

2007-2008 to 2008-2009 Gains in Reading and Mathematics for NCLB Subgroups | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Indicator (d)(1) |  |  | Indicator (d)(2)
Reading |  |  | Math
All Sudents Gain |  |  | All Sudents Gain
Number gaining | 56 |  | Number gaining | 57
Number of Schools | 118 |  | Number of Schools | 118
Percentage Gaining | 0.4745762711864407 |  | Percentage Gaining | 0.4830508474576271
Subgroup gaining |  |  | Subgroup gaining
Number African American Gaining | 13 |  | Number African American Gaining | 13
Number of Schools | 31 |  | Number of Schools | 31
Percentage Gaining | 0.4193548387096774 |  | Percentage Gaining | 0.4193548387096774
Subgroup gaining |  |  | Subgroup gaining
Number American Indian Gaining | 1 |  | Number American Indian Gaining | 1
Number of Schools | 1 |  | Number of Schools | 1
Percentage Gaining | 1 |  | Percentage Gaining | 1
Number Asian Gaining | 2 |  | Number Asian Gaining | 2
Number of Schools | 4 |  | Number of Schools | 4
Percentage Gaining | 0.5 |  | Percentage Gaining | 0.5
Number Hispanic Gaining | 17 |  | Number Hispanic Gaining | 16
Number of Schools | 39 |  | Number of Schools | 39
Percentage Gaining | 0.4358974358974359 |  | Percentage Gaining | 0.4102564102564102
Number IEP Gaining | 19 |  | Number IEP Gaining | 18
Number of Schools | 52 |  | Number of Schools | 52
Percentage Gaining | 0.3653846153846154 |  | Percentage Gaining | 0.3461538461538461
Number ELL Gaining | 15 |  | Number ELL Gaining | 14
Number of Schools | 31 |  | Number of Schools | 30
Percentage Gaining | 0.4838709677419355 |  | Percentage Gaining | 0.4666666666666667
Number Low SES Gaining | 44 |  | Number Low SES Gaining | 47
Number of Schools | 115 |  | Number of Schools | 115
Percentage Gaining | 0.3826086956521739 |  | Percentage Gaining | 0.4086956521739131
Spreadsheet: 780873d1652840668-can-i-combine-multiple-array-formulas-into-1-combine-dynamic-arrays
Sheet: Sheet1

Below is what I have now |  |  |  | Here is what I'd like to have:
 | 32 | [NAME] for Cat3 |  | Cat3 | Person3 | 32
Person17 | 20.84 |  |  | Cat3 | Person17 | 20.84
Person31 | 32 |  |  | Cat3 | Person31 | 32
 |  |  |  | Cat4 | Person70 | 187.22
 |  |  |  | Cat4 | Person78 | 287.91
 | 187.22 | [NAME] for Cat4 |  | Cat4 | Person79 | 146.79
Person78 | 287.91 |  |  | Cat4 | Person92 | 415.38
Person79 | 146.79 |  |  | Cat5 | Person4 | 20
Person92 | 415.38 |  |  | Cat5 | Person5 | 30
 |  |  |  | Cat5 | Person7 | 40
 | 20 | [NAME] for Cat5
Person5 | 30
Person7 | 40
Spreadsheet: 490054d1479609083-how-to-make-dropdownt-list-of-unique-items-dependent-on-another-dropdown-list-how-to-make-dropdownt-list-of-unique-items-dependent-on-another-dropdown-list
Sheet: List1

 |  |  |  |  |  | Shop | Item |  |  |  |  |  | Filtered list 1 |  | Kaufland | [NAME] | Tesco | Billa
 |  |  |  |  |  | Kaufland | glue |  | Shop | [NAME] |  |  | Kaufland
 |  |  |  |  |  | [NAME] | glue |  | Item |  |  |  | [NAME]
 |  |  |  |  |  | [NAME] | scissors |  |  |  |  |  | Tesco
 |  |  |  |  |  | Tesco | pencil |  |  |  |  |  | Kaufland
 |  |  |  |  |  | Kaufland | ruler |  |  |  |  |  | Billa
 |  |  |  |  |  | Billa | scissors
 |  |  |  |  |  | Kaufland | paper
 |  |  |  |  |  | Tesco | ruler
 |  |  |  |  |  | Billa | glue
 |  |  |  |  |  | Billa | rubber
 |  |  |  |  |  | [NAME] | rubber
 |  |  |  |  |  | Kaufland | string
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Tesco | brush
 |  |  |  |  |  | [NAME] | string
 |  |  |  |  |  | Tesco | pencil
 |  |  |  |  |  | [NAME] | glue
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Kaufland | ruler
Spreadsheet: 474330d1470733545-min-sum-problem-minimum-row-match
Sheet: Sheet1

34 | 67 | 89 | 190 |  |  | row
34 | 34 | 67 | 135 |  |  | minimum
23 | 4 | 5 | 32
76 | 34 | 45 | 155
Spreadsheet: 687966d1595510515-find-multiple-instances-a-word-in-a-string-of-txt-in-a-column-and-return-values-in-columns-apples
Sheet: Sheet1

Here is an apple | 5 | 2019-08-01 00:00:00 |  | apple | 5 | 2019-08-01 00:00:00
here is a banana | 12 | 2020-03-25 00:00:00 |  | apple | 10 | 30/02/2019
The apple is green | 10 | 30/02/2019 |  | apple | 1 | 2020-07-17 00:00:00
Strawberries are red | 7 | 2019-11-05 00:00:00
It is apple flavoured | 1 | 2020-07-17 00:00:00
Here is an orange | 17 | 2019-11-22 00:00:00
Spreadsheet: 583436d1532439567-rework-a-template-in-order-to-create-a-weekly-calendar-2018_07_24__demo_1
Sheet: Tabelle1

2018-08-01 00:00:00 |  |  |  | Bla 1 | Blub 1 | Blabla 1
2018-08-02 00:00:00 |  |  |  | Bla 2 | Blub 2 | Blabla 2
2018-08-03 00:00:00 |  |  |  | Bla 3 | Blub 3 | Blabla 3
2018-08-04 00:00:00 |  |  |  | Bla 4 | Blub 4 | usw. usf
2018-08-05 00:00:00 |  |  |  | Bla 5 | Blub 5 | usw. usf
2018-08-06 00:00:00 |  |  |  | Bla 6 | Blub 6 | usw. usf
2018-08-07 00:00:00 |  |  |  | Bla 7 | usw. usf | usw. usf
2018-08-08 00:00:00 |  |  |  | Bla 8 | usw. usf | usw. usf
2018-08-09 00:00:00 |  |  |  | Bla 9 | usw. usf | usw. usf
Spreadsheet: mark_whitt__25244__Huber - Existing & Proposed Deals 111201
Sheet: Summary

Existing Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index | 994232 | -90118
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index | 1002482 | 189775
2002-06-01 00:00:00 | 2013-05-31 00:00:00 | 42000 | Gage | IF NGPL MidContinent Index minus $0.01 | 8328453
Proposed Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 45000 | Glenrock | IF CIG Rocky Mtns. index minus $0.03 | 6080660
2001-12-01 00:00:00 | 2006-05-31 00:00:00 | 20000 | PG&E Topock | Gas Daily PG&E Topock index minus $0.02 | 4291022
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily El Paso-San Juan index minus $0.10 | 1440313
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily NWPL Wyoming Pool index minus $0.10 | 1349922
* The "55 days payable" value above is calculated as 55 days times the Daily Volume times the average forward curve price (curve date = Nov 9, 2001)