tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -142080 | -142462
2 | -138699 | -136853
3 | -135130 | -133387
4 | -125244 | -125558
5 | -106895 | -107400
6 | -115168 | -114773
7 | -98089 | -97774
8 | -101801 | -102186
9 | -101660 | -102186
10 | -102426 | -102249
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-08-31 00:00:00 |  | 47553
 | 2001-09-11 00:00:00
CBS Dollars
 |  |  | -252720.37
Spreadsheet: 879588d1727177762-grassroots-football-team-season-stat-tracker-deddymanager1-gameday-stats-spill-365-aligw
Sheet: GW 1

Date | 7th September 2024
Competition | League
Home/Away | Away
Result | 1-1
Player Name | Started | Sub | Goals | Disallowed Goal | Pens | Overall Goals | Assists | Yellow | Red | [NAME] | Pen conceeded | MOTM | Clean Sheet | Fines | Fine Paid? (Y/N)
Player 1 | 1 |  |  |  |  |  | 1
Player 4 | 1 |  | 1
Player 6 | 1 |  |  |  |  |  |  |  |  |  |  | 1
Player 5 |  | 1
Player 2 |  | 1
Player 3 |  | 1
Player 8 | 1
Player 9 | 1
Player 7 | 1
Player 10 | 1
Player 11 | 1
Player 16 | 1
Player 13 | 1 |  |  | 1
Player 14 | 1
Player 15 |  | 1
Player 12 |  | 1
Spreadsheet: 145292d1331495811-copying-data-to-excel-column-of-pasted-data-is-becoming-a-formula-whats-going-on-data-paste-problem
Sheet: Sheet1

 |  | GAME |  | HANDICAP | MONEY LINE | TOTAL POINTS
Sun 3/11 | 873 | Boston Celtics |  |  | 184 | Over 179 -101
12:30:00 | 874 | Los Angeles Lakers |  |  | -205 | Under 179 -109
Sun 3/11 | 875 | Indiana Pacers |  |  | 193 | Over 184.5 -103
15:05:00 | 876 | Orlando Magic |  |  | -215 | Under 184.5 -107
Sun 3/11 | 877 | Milwaukee Bucks |  |  | -127 | Over 198 +100
15:05:00 | 878 | Toronto Raptors |  |  | 115 | Under 198 -110
Spreadsheet: 031b8ff7-18aa-49de-83bc-75d5c4f6591f
Sheet: 2014 and 2015 Cross Subsidy Aid

Calculation of Cross Subsidy Reduction Aid |  |  |  |  | SFY 14 and 15
This is an example of the calculations  of Cross Subsidy Revenue for SFY 2014 with changes for SFY 2015
Line  Number | Calculations | Description |  |  | Amounts
Lesser of A or B
Option A |  | All Data is Current Year
1 |  | Total ADM Served (K-12) |  |  | 3770.09
2 |  | Maximum Payable per ADM - | SFY 2014 - $20 per ADM | SFY 2015 - $48 per ADM | 20
3 | 1 * 2 = 3 | Total Cross Subsidy Aid Option A |  |  | 75401.8
Option B |  | All Data is Current Year
4 |  | Level 1 Basic Allowance |  |  | 450
5 |  | [NAME] |  |  | 3770.09
6 | 5 X .008 | Level 1 Size Allowance |  |  | 30.16072
7 |  | Free Lunch (K-12) | 1100 |  | 1100
8 |  | Reduced  Lunch (K-12)  * .5 | 219 | 1/2 of Reduced | 109.5
9 | 7 + 8 | Total Free and 1/2 Reduced |  |  | 1209.5
10 |  | Total Enrollment 10/1/12 (K-12) |  |  | 2673
11 | 9 / 10 | Ratio of Free & Reduced/Enrolled |  |  | 0.4524878413767303
12 | 11 X $400 | Level 1 Poverty Allowance |  |  | 180.9951365506921
13 | 4 + 6 + 12 | Total Level 1 Allowance per ADM |  |  | 661.1558565506921
14 | 5 X 13 | Initial Level 1 Revenue |  |  | 2492617.083223199
15 | 12/1 Child Count | Level 2 ASD | 78 | 10100 | 787800
16 |  | Level 2 Developmental Delay | 83 | 10100 | 838300
17 |  | Level 2 SMI | 20 | 10100 | 202000
18 |  | Level 3 Deaf, H/H | 14 | 17500 | 245000
19 |  | Level 3 EBD | 95 | 17500 | 1662500
20 |  | Level 4 DCD - Mild | 20 | 26000 | 520000
21 |  | Level 4 DCD - Severe | 14 | 26000 | 364000
22 |  | Level 4 Physically Impaired | 10 | 26000 | 260000
23 |  | Level 4 Visually Impaired | 2 | 26000 | 52000
24 |  | Level 4 Deaf Blind | 0 | 26000 | 0
24 | 15+16+17+18+19+20+21+22+23=24 | Initial Level 2 - 4 Aid |  |  | 4931600
25 | 14 + 24 | Initial Level 1 - 4 Aid |  |  | 7424217.083223199
26 | 25 * .01 | Total Cross Subsidy Aid Option B |  | SFY 2015 .01 is changed to .0227 | 74242.17083223199
27 |  | Lesser of Formula A or [NAME] |  |  | 74242.17083223199
Spreadsheet: tracy_geaccone__40544__G&A_by_Account
Sheet: Total (2)

ENRON
[NAME] COSTS
(in thousands)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of
 |  | ETS |  | ENA |  | Europe |  | EGM |  | EIM |  | ENW |  | EGA |  | EGF |  | EGEP |  | EES |  | EECC |  | EBS |  | EREC |  | Clean Fuels |  | Other |  | Corp |  | Total |  | Gross
Salaries
Capitalized costs
Benefits
Capitalized costs
Employee Expenses
Capitalized costs
Advertising
Communications expense
Capitalized costs
Contributions
Computer expense
Insurance
Outside services
Capitalized costs
Engineering & Construction
Capitalized costs
Postage & Freight
Capitalized costs
Subscriptions
Materials & supplies
Capitalized costs
Supply expense
Capitalized costs
Rent expense
Capitalized costs
Utilities
Other
Capitalized costs
Allocations
Capitalized costs
Intercompany services*
Additional capitalized costs
Net Total
Gross Total
(before capitalized costs)
*  Other side in intercompany revenues.
Spreadsheet: louise_kitchen__22542__2001 Gain Calcs4
Sheet: Sheet1

 |  | Summary of 2001 Asset Sales |  |  | Book | Sales
 |  |  |  |  | Basis | Proceeds | Gain | Multiple |  | EBITDA
 |  | 2001-05-03 00:00:00 | Sale of 2000 Peakers to Allegheny* | [NAME] | 635.5 | 1047.7 |  |  |  | 30.7
 |  | 2001-03-01 00:00:00 | Sale of [NAME] (Enser Co) | Lydecker |  |  |  |  |  | -1.4
 |  | 2001-03-23 00:00:00 | Sale of Brownsville and Caledonia to CINergy | [NAME] | 274.3 | 499.625 |  |  |  | 22.5
 |  | 2001-04-11 00:00:00 | Pastoria | Calger | 72.5 | 112.9 |  |  |  | 0
 |  | 2001-04-11 00:00:00 | Fountain Valley PSCO | Calger |  |  |  |  |  | 0
 |  | 2001-05-02 00:00:00 | Delta Turbines | Calger | 56.8 | 67.8 |  |  |  | 0
 |  | 2001-07-11 00:00:00 | Alamac/NCPH | Duran | 7.5 | 22 |  |  |  | -2.9
 |  | 2001-08-31 00:00:00 | SW  Power (LVC) | Calger |  |  |  |  |  | 7.5
 |  | 2001-06-01 00:00:00 | HPL | Redmond |  | 352.5 |  |  |  | 66.3
 |  | 2001-09-14 00:00:00 | Blue Dog Turbines - Northwestern | [NAME] | 40.3 | 49.5 |  |  |  | 0
 |  | 2001-09-26 00:00:00 | Sale of New Albany to Duke | Presto | 136.096 | 135 |  |  |  | 12.3
 |  |  | FORECASTED SALES
 |  | [NAME] | Vitro Sale | Williams/Irvin |  | 39.5 | 14 |  |  | 0
 |  | [NAME] | Cornhusker | Duran
 |  |  | *includes $23 million for unwind of COMED capacity transaction.
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-99 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2000
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 139298d1328179755-calculate-number-of-months-in-year-stert_end-date
Sheet: Sheet1

Start date | End Date | Months in 2012 | [NAME]
2011-11-01 00:00:00 | 2012-12-31 00:00:00 | 12
2011-11-01 00:00:00 | 2012-11-30 00:00:00 | 11
2012-01-01 00:00:00 | 2012-12-01 00:00:00 | 12
2011-01-01 00:00:00 | 2012-03-01 00:00:00 | 3
2012-04-01 00:00:00 | 2012-06-30 00:00:00 | 2
2010-12-01 00:00:00 | 2012-11-30 00:00:00 | 11
2011-04-01 00:00:00 | 2012-03-30 00:00:00 | 3
2012-06-01 00:00:00 | 2013-07-30 00:00:00 | 6
2011-01-01 00:00:00 | 2013-05-31 00:00:00 | 12
Spreadsheet: chris_germany__1880__Ogleth200105
Sheet: external

DOYLE |  | Deals 774072, 774087, 774325
May    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  | [NAME] |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  |  |  | FT | IT @ .1861 | COST
DAY | REQUEST |  |  |  |  |  |  |  | zero |  | DEL'd x Comm.
2001-05-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0328 | 0.1861
 | 0
 | 0 |  | 4250 | 4027 |  |  | 4.9
 | 0 |  |  | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0
 | 0
 | 0 | 4500
 | 0 | 10000 |  | 6586 |  |  |  |  |  |  | 0
 | 0 | 10000 |  |  |  |  |  |  |  |  | 0
 | 0 | 5500 |  |  |  |  |  |  |  |  | 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
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | All gas for month purchased delivered…no transport costs or fuel losses.
 | Ending balance to be cashed out via [NAME]'s published [NAME] IT rate.
Spreadsheet: 846563d1697721221-lookup-formula-help-to-extract-multiple-values-based-on-one-reference-lookup_samrat_v1
Sheet: Production Consumption

[NAME] | Date | Product Code | Product Name | Customer Name | RM Code | RM Name | Standard Qty (in %) | [NAME] (in Kg) | Standard Qty (in Kg) | Actual Consumption in Batch (in Kg)
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | RTU TH. | a | 0.5 | 1000 |  | 600
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KS-017 | b | 0.01 | 1000 |  | 10
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KAS-041 | c | 0.055 | 1000 |  | 55
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KM-23 | d | 0.02 | 1000 |  | 20
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR4-014 | e | 0.05 | 1000 |  | 50
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR3-014 | f | 0.06 | 1000 |  | 60
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | [NAME] | g | 0.18 | 1000 |  | 180
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | PA-52 | h | 0.001 | 1000 |  | 1
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | EA | i | 0.085 | 1000 |  | 85
27666 | 2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | BA | j | 0.05 | 1000 |  | 50
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | RTU THINNER | k | 0.25 | 1000 |  | 250
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | BA | l | 0.04 | 1000 |  | 40
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | EA | m | 0.37 | 1000 |  | 370
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | NBA | n | 0.01 | 1000 |  | 10
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | BC | o | 0.01 | 1000 |  | 10
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | DAA | p | 0.015 | 1000 |  | 15
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | MALIK | q | 0.015 | 1000 |  | 15
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | UK-100 | r | 0.004 | 1000 |  | 4
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | KR4-014 | s | 0.05 | 1000 |  | 50
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | KR3-014 | t | 0.05 | 1000 |  | 50
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | KR-32F | u | 0.18 | 1000 |  | 180
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | KP-988 | v | 0.002 | 1000 |  | 2
27662 | 2023-10-11 00:00:00 | 124 | N.C LACQUER 10% GLOSS | y | KP-0002 | w | 0.002 | 1000 |  | 2
Spreadsheet: 218788d1362581055-lookup-problem-book2
Sheet: Sheet2

Name | Address | Key
[NAME] | 13 Nowhere Lane Sometown, USA
[NAME] | 3 Deadend Road Metropolis, USA
[NAME] | 25 Somewhere Else Elsetown, USA
Sherlock [NAME] | 221B Bakers Street London, UK
[NAME] | 1313 [NAME] Heights
Mr Adams | 0001 Cemetery Lane Chicago, IL
Spreadsheet: 153945d1336127049-more-conditinoal-formating-channel-list
Sheet: Sheet1

Date | Program Name | Start Time | End Time | No. Of Adverts | Channel
2012-05-03 00:00:00 | Breakfast | 06:00 BST | 09:15 BST | 0 | BBC 1
2012-05-03 00:00:00 | This Morning | 10:30 BST | 12:30 BST | 4 | ITV
2012-05-03 00:00:00 | [NAME] | 19:00 BST | 20:00 BST | 2 | Sky News
2012-05-03 00:00:00 | Channel 4 News | 19:00 BST | 20:00 BST | 1 | Channel 4
2012-05-03 00:00:00 | [NAME] | 23:00 BST | 23:30 BST | 1 | Bloomberg EU
2012-05-03 00:00:00 | Mad Money | 23:00 ET | 00:00 ET | 4 | CNBC US
Spreadsheet: 738740d1625225442-index-aggregate-formula-help-example-data
Sheet: Jan2021

2021-01-01 00:00:00
Number | Category | Member [NAME] | Species | Points
 | Open ExC | Person A | aaa | 2
 | Open MinC | Person A | bbb | 0
 | Open ExCat | Person B | [NAME] | 1
 | Open MinC | Person C | ddd | 3
 | Open ExC | Person B | eee | 0
Spreadsheet: 845362d1696895333-assistance-in-updating-formula-showing-value-error-2024-financial-year-planner-and-budget-fortnightly-with-or-without-gst-second-value-error
Sheet: Income, Cash, or Debit Expenses

IF(OR(MONTH($A$3)={3,4,5,6,7,8,9,10,11}),
Spreadsheet: tracy_geaccone__40156__2001_1Q_Margin Variance
Sheet: TWRev

[NAME]
Margin [NAME] 2000 vs. 1Q 2001
 |  | 1Q |  | 1Q
 |  | 2000 |  | 2001 |  | [NAME]
West Deliveries
East
[NAME]
Other
West Deliveries:
Increased Rates & Volumes
Avg. [NAME] for Q1 2000 = .877
Avg. [NAME] for Q1 2001 =  1.114
East Deliveries:
Increased Rates
[NAME]:
Increased IT volumes
Spreadsheet: 112655d1308703889-countif-for-two-criteria-countif-for-two-criteria
Sheet: Stats

 | Stats (desired result)-Credit Card
Item | Current Formula | Desired Result | Is formula ok?
Number of cells contain "may be RM" in remark column | 3 | 3 | ok
Number of cells contain "may be RM" in remark column G and PCT in column H (both criteria) | 2 | 2 | ok
number of blank cell, exclude Sav product | 2 | 2 | ok
number of blank cell | 6 | 6 | ok
 | Stats (desired result)-upg
Number of blank cell in column O with code PCT | (COUNTBLANK(INDEX(Data,,8)))-,COUNTIF("dataupg","pct") | 4 | not matched
Spreadsheet: 08e4f9fa-d052-406c-bb24-fda017605dbc
Sheet: جمعیت 

 | [NAME] جمعیت و خانوار محلات ناحیه 7 منطقه 5
 | نام محله | جمعیت (نفر) | جمعیت (نفر) |  | تعداد خانوار
 |  |  | مرد | زن
 | جنت آباد شمالی | 30223 | 15353 | 14870 | 9444
 | جنت آباد مرکزی | 36215 | 18361 | 17854 | 11317
 | جنت آباد جنوبی | 57259 | 28744 | 28515 | 17893
 | شاهین | 20986 | 10724 | 10262 | 6558
 | [NAME]
Spreadsheet: 298204d1392736761-create-scroll-bar-to-scroll-through-year-of-dates-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 0
 | Start Date | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 1
 | BROKEN EXAMPLE
 |  |  |  |  |  |  |  |  |  | 0
 | Start Date | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 1 | 00:00:00
Spreadsheet: 705172d1605899428-outputting-values-to-new-column-based-on-id-and-if-condition-sampx
Sheet: Sheet1

ID: |  |  | Type |  |  |  |  | Delivery: | Relation: | Expected Value:
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | RRR |  | -/-/-/-/-
11344 |  |  | AAAT |  |  |  |  | RRR | CCCR | TPAR
11344 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR
11454 |  |  | TTTT |  |  |  |  |  | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA |  | No Scenarios
11454 |  |  | AAAT |  |  |  |  | RRR |  | No Scenarios
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB | VVVR | VVVR
1158 |  |  | FFFT |  |  |  |  | RRR | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB |  | VVVR
10975 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR
10975 |  |  | FFFT |  |  |  |  | RRR | CCCR | TPAR
1407 |  |  | FFFT |  |  |  |  | CD w/o Z | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | CCCR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | FFF | CCCR | No Scenarios
1161 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -
1161 |  |  | FFFT |  |  |  |  | RRR |  | -
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC | CCCR/ TPAR/ DPAC
Spreadsheet: 776994d1650047614-sumifs-with-a-formula-test
Sheet: Sheet1

5 | 6 | 7 | 4
9 | 2 | 5 | 5
4 | 2 | 7 | 6
2 | 7 | 0 | 0
7 | 5 | 7 | 4
1 | 3 | 0 | 0
6 | 6 | 0 | 0
10 | 7 | 0 | 0
1 | 10 | 4 | 2
=SUMIFS((A1:A9+B1:B9)/(C1:C9-D1:D9),C1:C9,">0",D1:D9,">0")
Spreadsheet: 181235d1347973786-copy-speciffic-rows-from-workbook-with-vba-or-formula-target_0
Sheet: Sheet1

D1 | F1 | H1 | CS ABS | AA1
101 | 101 | 101 | 101 | 101 |  |  |  | IF formula
D3 | F3 | H3 | CS ABS | AA3
D4 | F4 | H4 | CS ABS | AA4
D5 | F5 | H5 | CS ABS | AA5
D6 | F6 | H6 | CS ABS | AA6
101 | 101 | 101 | 101 | 101
D8 | F8 | H8 | CS ABS | AA8
D9 | F9 | H9 | CS ABS | AA9
D10 | [NAME] | H10 | CS ABS | AA10
D1 | F1 | H1 | CS ABS | AA1
D2 | F2 | H2 | CS | AA2 | <- should not be displayed |  |  | Lookup formula
D3 | F3 | H3 | CS ABS | AA3
D4 | F4 | H4 | CS ABS | AA4
D5 | F5 | H5 | CS ABS | AA5
D6 | F6 | H6 | CS ABS | AA6
D7 | F7 | H7 | IE | AA7 | <- should not be displayed
D8 | F8 | H8 | CS ABS | AA8
D9 | F9 | H9 | CS ABS | AA9
D10 | [NAME] | H10 | CS ABS | AA10
header | header | header | header | header
D1 | F1 | H1 | CS ABS | AA1 |  |  |  | Example  of what it should look like
D3 | F3 | H3 | CS ABS | AA3
D4 | F4 | H4 | CS ABS | AA4
D5 | F5 | H5 | CS ABS | AA5
D6 | F6 | H6 | CS ABS | AA6
D8 | F8 | H8 | CS ABS | AA8
D9 | F9 | H9 | CS ABS | AA9
D10 | [NAME] | H10 | CS ABS | AA10
Spreadsheet: 186147d1349942971-need-help-getting-cell-color-to-follow-cell-format-motor-comparison-chart
Sheet: Sheet1

 | Bow Mount | Transom Mount | [NAME] | Cable Steer | Digital Maximizer |  |  |  | Shaft length |  |  |  |  | Voltage |  |  |  | i-Pilot/i-Pilot Link Compatible | Co-Pilot Compatible | AutoPilot Compatible | Universal Sonar 2 | Lift Assist Stow/Deploy
 |  |  |  |  |  | 30" | 36" | 42" | 45" | 48" | 52" | 54" | 60" | 12v | 24v | 36v | 48v
Terrova
Powerdrive V2
Fortrex
Maxxum
Edge
Vantage
Traxxis
Endura Maxx
Endura C2
Engine Mount
[NAME]
Spreadsheet: 721094d1614489462-conditional-formatting-for-design-book1-18-ans
Sheet: Sheet1

1 | 2 | 3 | 4
Stage 1
 | Aciticity | % Complete | Formating/formula
1 | sumission | 20 | 18 |  |  |  |  |  |  |  | =$[NAME]
2 | Review | 21-49 | 25 |  |  |  |  |  |  |  | =AND($D4>20,$D4<=49)
3 | Approval | 50-100 | 60 |  |  |  |  |  |  |  | =$D4>49
Stage 2
 | Aciticity | Float | Formating/formula
1 | sumission | -1 | 1
2 | Review | 1 | 30
3 | Approval | 2 | 70
Spreadsheet: 770106d1645810275-tracing-and-summing-from-numerous-sheet-sumifs-qs2-v2
Sheet: Backend Data - Ref ID

Booking No. | Revenue
IO-[PHONE] | 86.69444444444444
IO-[PHONE] | 41.86666666666667
IO-[PHONE] | 43.79651851851852
IO-[PHONE] | 47.53155555555556
IO-[PHONE] | 27.73333333333333
IO-[PHONE] | 40.39703703703704
IO-[PHONE] | 59.25925925925926
IO-[PHONE] | 7.333333333333333
IO-[PHONE] | 7.333333333333333
IO-[PHONE] | 107.6725925925926
IO-[PHONE] | 43.66474074074074
IO-[PHONE] | 39.05088888888889
IO-[PHONE] | 245.0927407407407
IO-[PHONE] | 132.8531851851852
Spreadsheet: kate_symes__18774__New Notification Report 0101
Sheet: Mar 01 Changes

ALL PROPOSED CHANGES SINCE: |  | 2001-02-27 00:00:00
Old Record Information |  |  | New Record Information
Change Type | Old Name | CP ID | New Name
Spreadsheet: 682847d1592358472-formula-to-look-up-values-from-multiple-columns-separate-sheet-in-a-cell-with-text-site-masterlist-wip
Sheet: Export

Username | Name | UserTypes | [NAME] | Latitude | Longitude | Timezone | [NAME] | [NAME] | Roles | Company | Facility Zone | Tablet Profile
1 Sleep Lounge near the gate
Spreadsheet: d65980de-a3bc-4bd9-85f3-7782fb8f1dd8
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Biology
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 264845d1378996555-transfer-data-from-one-sheet-to-another-with-different-format-and-formatting-fixture_auto_update1
Sheet: Setup

 | Number of Teams = | 8 |  | Start Date  = | 2013-08-14 00:00:00
 |  |  |  | Team Name | Venue
 |  |  |  | Cawburn A | a
 |  |  |  | Cawburn B | a
 |  |  |  | Oatridge | b
 |  |  |  | [NAME] | b
 |  |  |  | Bentswood | c
 |  |  |  | Commercial | c
 |  |  |  | D Luxe | d
 |  |  |  | Firs | e
 |  |  |  | Tower | f
 |  |  |  | j | g
 |  |  |  | k | h
 |  |  |  | l | i
 |  |  |  | h | j
 |  |  |  | dee | k
 |  |  |  | de | l
 |  |  |  | kljlj | m
Spreadsheet: chris_germany__2914__02 2000 GELP OIL BY VENDOR
Sheet: GELP OIL DELIVERY SHEET #3

GELP #2 FUEL OIL RECEIPTS FOR THE MONTH
Delivery Date | Beginning Flow counter reading | Ending Flow counter reading | Plant Recorded Delivery |  | BP AMOCO       Quantity on B/L-Gross | Marathon Ashland Quantity on B/L-Gross | CITGO Quantity on B/L-Gross | B/L #
 |  |  | Due from previous sheet
 |  |  | Any additional ordered | 0 | (orders for the 23rd)
 |  |  | TOTAL DELIVERED
 |  |  | OWED TO GELP/ (OVER DELIVERED)
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-034,070

 |  |  |  |  |  |  |  | 7-034   7-070
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 470818d1468679294-ref-error-when-inserting-row-into-table-precious-metals-template-5-prc
Sheet: Silver (Inventory)

 |  | TOTAL P/L |  |  |  | TOTALS
 | Year | Description | Mint | Purchase Date | Units | Weight (oz) | Total Weight | Purchase Price | Spot Value | Premium | P/L ($) | P/L (%)