tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ace67df4-e3d3-446e-a5d9-639d5f05a337
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mass |  |  |  |  | Performance by Watts
Rider | 60 | [NAME] | 132 | lbs | [NAME]. Speed | 30.84472787160887 | KPH | 19.1237312803975 | MPH
Batteries | 5 | [NAME] | 11 | lbs | At | 200 | Watts
Ebike | 15 | [NAME] | 33 | lbs | = | 33.617437460118 | KPH | 20.84281122527316 | MPH
Total Weight | 80 | [NAME] | 176 | lbs | Input | 200 | Watts
Resistance Characteristics |  |  |  |  |  | 5.555555555555555 | Amps
CD | 0.9 |  |  |  | Motor Speed | 1961.806493482158 | RPM
Frontal Area | 0.38 | m2 |  |  | Distance | 40.34092495214161 | KM | 25.0113734703278 | [NAME]
[NAME]. | 0.5 | m |  |  | Performance by KPH
Rolling [NAME]. | 0.004 |  |  |  | At | 40 | KPH | 24.8 | MPH
Air Density | 1.226 | kg/m3 |  |  | = | 322.4246913580246 | Watts | 0.4323785588816208 | HP
Grade | 0 | % | 0 | deg |  | 8.956241426611795 | Amps
Motor Characteristics |  |  |  |  | Motor Speed | 2334.272498681132 | RPM
Torque | 10 | Nm |  |  | Distance | 29.77439463325727 | KM | 20.24658835061495 | [NAME]
Efficiency | 100 | % |  |  | [NAME]
Cont. RPM | 1800 | RPM |  |  | Wind | 287.5802469135802 | Watts
Gearing | 5.5 | :1 |  |  | Rolling | 34.84444444444445 | Watts
Battery Characteristics |  |  |  |  | Grade | 0 | Watts
Voltage | 36 | V
Amp/Hours | 10 | AH
[NAME]. | 1.2
Discharge | 80 | %
Spreadsheet: kate_symes__19188__DJ Index 5-2
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-05-02 00:00:00
Flow Date: | 2001-05-02 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 245 | 2800
 | Firm Trades Purchases | 242 | 2000
[NAME] | Firm Trades Sales | 125 | 808
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 253 | 3200
 | Firm Trades Purchases | 244 | 800
[NAME] | Firm Trades Sales | 149.2105263157895 | 2280
 | Firm Trades Purchases | 154 | 400
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 217.5337837837838 | 5920
 | Firm Trades Purchases | 218.75 | 3840
[NAME] | Firm Trades Sales | 94.66666666666666 | 3000
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 100 | 176
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 226.2222222222222 | 6480
 | Firm Trades Purchases | 218.3653846153846 | 832
[NAME] | Firm Trades Sales | 128.1578947368421 | 3800
 | Firm Trades Purchases | 127.4912280701754 | 2280
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 212.9516129032258 | 4960
 | Firm Trades Purchases | 205.4216867469879 | 1328
[NAME] | Firm Trades Sales | 109.1207349081365 | 3048
 | Firm Trades Purchases | 108.2525252525253 | 792
Spreadsheet: 835927d1688986813-calculate-the-number-of-rows-and-dont-count-duplicates-question
Sheet: Sheet1

 | Drug A | Drug B |  | Outcome
Patient A | 0 | 0 |  | 1
Patient B | 1 | 1 |  | 0
Patient C | 1 | 0 |  | 1
Patient D | 1 | 1 |  | 1
Patient E | 0 | 0 |  | 0
Patient F | 1 | 0 |  | 1
Patient G | 1 | 1 |  | 1
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: Montreal

[NAME]
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] | L | 33 | 188 | 100 | 65 | 65 | 65 | 100 | 25 | 25 | 25 | 85 | 85 | 100 | 100
G | [NAME] | L | 37 | 172 | 45 | 55 | 55 | 55 | 55 | 25 | 25 | 25 | 45 | 45 | 45 | 45
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | L | 11 | 212 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 35 | 65 | 65
C | [NAME] | R | 47 | 180 | 65 | 65 | 65 | 55 | 55 | 45 | 65 | 85 | 65 | 25 | 55 | 35
C | [NAME] | R | 18 | 180 | 85 | 65 | 65 | 55 | 55 | 45 | 85 | 55 | 55 | 25 | 65 | 55
C | [NAME] | R | 21 | 188 | 65 | 55 | 45 | 65 | 45 | 65 | 65 | 35 | 55 | 55 | 65 | 35
LW | [NAME] | L | 25 | 188 | 65 | 65 | 65 | 55 | 55 | 45 | 85 | 55 | 65 | 45 | 65 | 55
LW | [NAME] | L | 45 | 204 | 55 | 65 | 55 | 55 | 55 | 45 | 55 | 55 | 55 | 45 | 55 | 45
LW | [NAME] | L | 17 | 228 | 55 | 65 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 45 | 45 | 45
LW | [NAME] | L | 22 | 188 | 45 | 45 | 55 | 45 | 45 | 45 | 45 | 55 | 45 | 45 | 45 | 45
LW | [NAME] | L | 32 | 188 | 35 | 35 | 35 | 35 | 45 | 55 | 35 | 55 | 35 | 55 | 35 | 65
RW | [NAME] | R | 23 | 204 | 65 | 65 | 65 | 55 | 65 | 45 | 65 | 65 | 65 | 45 | 65 | 45
RW | [NAME] | R | 12 | 180 | 55 | 65 | 65 | 55 | 45 | 55 | 45 | 55 | 55 | 25 | 55 | 55
RW | [NAME] | R | 26 | 180 | 65 | 65 | 55 | 45 | 55 | 45 | 55 | 55 | 55 | 45 | 55 | 45
RW | [NAME] | R | 31 | 204 | 45 | 45 | 45 | 35 | 45 | 55 | 45 | 45 | 35 | 65 | 45 | 35
RW | [NAME] | R | 36 | 228 | 35 | 35 | 45 | 35 | 35 | 55 | 35 | 45 | 45 | 55 | 35 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 48 | 188 | 65 | 55 | 45 | 65 | 65 | 55 | 55 | 45 | 65 | 65 | 45 | 45
D | [NAME] | L | 24 | 212 | 55 | 45 | 45 | 65 | 45 | 55 | 45 | 25 | 55 | 55 | 45 | 65
D | [NAME] | L | 27 | 196 | 55 | 65 | 55 | 55 | 55 | 55 | 65 | 45 | 65 | 45 | 65 | 55
D | [NAME] | L | 14 | 188 | 45 | 45 | 45 | 55 | 35 | 45 | 35 | 45 | 65 | 85 | 45 | 55
D | [NAME] | R | 28 | 212 | 65 | 55 | 55 | 65 | 55 | 65 | 65 | 45 | 65 | 45 | 55 | 55
D | Patrice Brisebois | R | 43 | 180 | 55 | 55 | 55 | 55 | 55 | 55 | 45 | 45 | 65 | 55 | 45 | 55
D | [NAME] | R | 5 | 212 | 55 | 45 | 45 | 55 | 55 | 65 | 55 | 35 | 55 | 85 | 55 | 65
D | [NAME] | R | 34 | 212 | 45 | 45 | 35 | 45 | 45 | 55 | 45 | 35 | 45 | 55 | 35 | 55
Spreadsheet: 806429d1669292860-rolling-average-excluding-blank-cells-but-including-zeros-sample
Sheet: Sheet1

ID | VALUE | val_roll_ave | FORMULA | REQUIRED
1 | 123.2739130434782 |  |  | 123.2739130434782
1 | 8.18 |  |  | 65.72695652173913
1 | 41.81666666666666 |  |  | 57.75685990338164
1 |  |  |  |  | <--- should ignore the blank cell B5
1 | 0 |  |  |  | <--- should include the 0 in cell [NAME]
1 | 7.15
1 | 90.28749999999998
1
1 | 12.65
1 | 121.5333333333333 |  |  |  | Row
1 | 39.25
1
1 | 15.4
1 | 0
1 | 62.0611111111111
1 | 35.8
1
1 | 49.56666666666666 |  |  |  |  | Manual
1 | 126.6560606060606
1 | 23.06666666666667
1 | 126.6560606060606
1 | 23.06666666666667
1 | 177.1351724137931
1 | 8.4 |  |  |  |  | Manual
2 | 12
2 |  |  |  |  | <--- should ignore the blank cell B27
2 | 110
2 | 0 |  |  |  | <--- should include the 0 in cell B29
2
Spreadsheet: 159178d1338535535-split-text-and-numbers-of-different-lengths-sample-15-
Sheet: Sheet2

 | Number | Text | All except text
3211,630000006704215239089PHALANDWA
14649,611000005008185114087COETZEE
13801,140000005602205021080Greeff
6507,990000005511235737088TSHABALALA
4180,280000006203195933084SEBOKEDI
6692,040000007106280298082ZONDI
6844,180000005301085704085MABALA
Spreadsheet: 679959d1590701434-calc-how-many-invoices-need-to-be-sent-invoicing_projects_03
Sheet: Tabelle1

 |  |  |  |  |  |  | 2021 | 2022 |  |  |  |  |  |  |  |  |  |  | 2022
 |  | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
Contracting Customers |  | 3 | 3 | 4 | 4 | 5 | 5 | 8 | 11 | 12 | 13 | 14 | 16 | 19 | 22 | 24 | 26 | 29 | 31
Ordered Project Months / Customer |  | 3.58875 | 3.67275875 | 3.755920000000001 | 3.838233750000001 | 3.9197 | 4.00031875 | 4.080089999999999 | 4.15901375 | 4.237089999999998 | 4.314318749999998 | 4.390699999999998 | 4.466233749999998 | 4.540919999999997 | 4.614758749999997 | 4.687749999999997 | 4.759893749999997 | 4.831189999999996 | 4.901638749999996
Ordered Project Months / Total
Project Months to be invoiced |  | 0 | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ?
Manual Example Months July-Sept
 |  |  | 3*1 | 3*1 | 3*1 | 3*0,59
 |  |  |  | 3*1 | 3*1 | 3*1 | 3*0,67
 |  |  |  |  | 4*1 | 4*1 | 4*1 | 4*0,76
 |  |  |  |  | … | … | … | … | …
Project Months to be invoiced |  |  | 3 | 6 | … | … | … | … | …
Spreadsheet: 152395d1335370604-list-all-matching-values-in-a-row-sample
Sheet: A

 |  |  |  |  |  |  |  |  | End Result:
Original Column | Matching Values from B |  |  |  |  |  |  |  | Original Column | Matching Values from B
XX1234 |  |  |  |  |  |  |  |  | XX1234 | AA1234
 |  |  |  |  |  |  |  |  |  | BB1234
YY4321 |  |  |  |  |  |  |  |  | YY4321 | BB4321
XY5678 |  |  |  |  |  |  |  |  | XY5678 | CC5678
YX8765 |  |  |  |  |  |  |  |  | YX8765
ZZ1111 |  |  |  |  |  |  |  |  | ZZ1111 | DD1111
 |  |  |  |  |  |  |  |  |  | FF1111
ZY2222 |  |  |  |  |  |  |  |  | ZY2222
YZ3333 |  |  |  |  |  |  |  |  | YZ3333 | DD3333
Spreadsheet: chris_stokley__4004__ISO meeting schedule revised
Sheet: Sheet1

DATE | SUBJECT | [NAME] | TIME | CALL-IN/NOTES
Weds 2/21* | ISO Board: ISO bylaw amend., [NAME]. Power Mitig., DRP | ISO | 9am-5pm | 1-877-381- 5998
 | bid awards, transmission expansion plans, Discretionary |  | public | Passcode: ISO BOARD
 | [NAME]. Prog., [NAME] scheduling, splitting OR from |  | session | Internet streaming audio: not yet posted
 | BEEP stack, Summer 2002 generation, gen. maint. stds.
Thurs 2/22* | ISO Board | ISO | TBD | agenda:  http://www.caiso.com/meetings/
consol. w/2-21 |  |  |  | docs/010221noticeofboardofgovernorsmtg.pdf
Fri 2/23* | Market Surveillance Committee | ISO | TBD
cancelled
Weds 2/28* | ISO Board | ISO | 8am-5pm
new
 |  |  |  | Internet streaming audio:
 |  |  |  | http://acw.activate.net/intercall/californiaiso/bog/010228.ram
Thurs 3/1* | 2002-2004 Reliability Must-Run Technical Study | ISO | 10am-3pm
 | Final Stakeholder Meeting
Thurs 3/8* | Generator Communications Project (GCP) | ISO | 9am-3:30pm | [PHONE]
 |  |  |  | (no passcode given)
 |  |  |  | Internet streaming audio: http://
 |  |  |  | acw.activate.net/intercall/03082001/californiaiso1_010308.ram
Weds 3/15* | ISO Board | ISO | 8am-noon
new
 |  |  |  | Internet streaming audio:
 |  |  |  | http://acw.activate.net/intercall/californiaiso/bog/010315.ram
Weds 3/21* | ISO Board | ISO | TBD
tentative
Thurs 3/22* | ISO Board | ISO | TBD
consol. with 3/21
Fri 3/23* | Market Surveillance Committee | ISO | TBD
Fri, 3/30* | ISO Board | ISO | 8am-5pm
 |  |  |  | Internet streaming audio:
new |  |  |  | http://acw.activate.net/intercall/californiaiso/bog/010330.ram
Spreadsheet: 755641d1637003148-if-formula-to-ignore-result-if-both-index-functions-return-from-the-same-cell-georgie_t
Sheet: Sheet1

Respondent |  | How often do you go to the cinema? |  |  |  |  |  |  | Difference between most recent answer and the answer before that
 | Answer in: | January | July | January | July |  |  |  | Previous | Most recent | Difference
A |  | Often | Sometimes | Sometimes
B |  | Sometimes | Sometimes
C |  | Often | Often | No data
D |  | Hardly ever or never | No data | Hardly ever or never | Sometimes
E |  | No data | Hardly ever or never | Sometimes
F |  | Sometimes | Often
Spreadsheet: 839589d1692103899-weekly-reporting-formula-check-jul_wk4-data_test-1-
Sheet: Andrea

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] |  | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: kate_symes__18287__DJ Index 4-10
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-10 00:00:00
Flow Date: | 2001-04-10 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 373.6 | 2000
 | Firm Trades Purchases | 363.3333333333333 | 1200
[NAME] | Firm Trades Sales | 327.5 | 800
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 382.3333333333333 | 6000
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 330 | 1600
 | Firm Trades Purchases | 317.5 | 400
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 177.030303030303 | 7920
 | Firm Trades Purchases | 178.2142857142857 | 3360
[NAME] | Firm Trades Sales | 89.683908045977 | 3480
 | Firm Trades Purchases | 85.35714285714286 | 280
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 190 | 272
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 94.68085106382979 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 319.8972602739726 | 7008
 | Firm Trades Purchases | 310.6666666666666 | 1200
[NAME] | Firm Trades Sales | 298.3333333333333 | 2400
 | Firm Trades Purchases | 300.6666666666666 | 600
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 175.3333333333333 | 1200
 | Firm Trades Purchases | 184.8148148148148 | 1728
[NAME] | Firm Trades Sales | 110.6 | 2000
 | Firm Trades Purchases | 109.0645161290323 | 744
Spreadsheet: 855637d1705147029-average-if-of-unique-values-with-conditions-question
Sheet: Sheet1

Origin | Destination | Ticket | Fare | OD_Ticket |  | Unique OD_tickets | Fare (average of unique fares if duplicate)
Pontefract | Woodlesford | ADVANCE | 5.1 |  |  |  | 5.1
Leeds | Bradford | ADVANCE | 3.5 |  |  | [NAME] | 5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Leeds - Bradford_SINGLE | 7.5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Castleford - Pontefract_ADVANCE | 3.5
Leeds | Bradford | ADVANCE | 6
Leeds | Bradford | SINGLE | 7.5
[NAME] | Pontefract | ADVANCE | 3
[NAME] | Pontefract | ADVANCE | 4
Spreadsheet: 74244d1274802482-data-table-by-age-range-lookup-data-table-by-age-range-bigduke6-sdg10
Sheet: Sheet1

Age | Amount |  |  |  |  |  | Today, 10:42 AM
22 |  |  |  |  |  |  | bigduke6
24 |  |  |  |  |  |  | LOOKUP - Data table by age range - bigduke6 - SDG10.xlsx
25 |  |  |  |  |  |  | Registered User   Join Date: 25 May 2010
26 |  |  |  |  |  |  | Location: Deep South
29 |  |  |  |  |  |  | MS Office Version:Excel 2007
30 |  |  |  |  |  |  | Posts: 1
33 |  |  |  |  |  |  | Data table by age range
34 |  |  |  |  |  |  | http://www.excelforum.com/excel-general/730545-data-table-by-age-range.html
35 |  |  |  |  |  |  | Good Morning !!
37 |  |  |  |  |  |  | I have been working on a table based on ages and trying to develop a formula to read a rate based on an individuals age to not much success.
39 |  |  |  |  |  |  | It is consuming the limit of 7 nested if statements !! Any help will be tremendously appreciated !!
40 |  |  |  |  |  |  | Age Amount
42 |  |  |  |  |  |  | 1 25 less then 0.05
44 |  |  |  |  |  |  | 2 25 through 29 0.06
45 |  |  |  |  |  |  | 3 30 through 34 0.08
47 |  |  |  |  |  |  | 4 35 through 39 0.09
49 |  |  |  |  |  |  | 5 40 through 44 0.10
50 |  |  |  |  |  |  | 6 45 through 49 0.15
51 |  |  |  |  |  |  | 7 50 through 54 0.23
54 |  |  |  |  |  |  | 8 55 through 59 0.43
55 |  |  |  |  |  |  | 9 60 through 64 0.66
58 |  |  |  |  |  |  | 10 65 through 69 1.27
59 |  |  |  |  |  |  | 11 70 > then 2.06
60 |  |  |  |  |  |  | Regards BD6 !!
61
64
65
66
67
68
69
70
72
74
80
90
100
Spreadsheet: 676575d1588873689-lookup-a-combination-of-multiple-critera-and-return-a-value-criteria_combination
Sheet: Sheet1

 |  |  |  | Scenario 1
Data 1 | Data 2 | Values |  | Apple | Criteria 1
[NAME] | Grapes | 1 |  | [NAME] | [NAME]
Apple | [NAME] | 2
Apple | Grapes | 3 |  | 2 | Result
Grapes | [NAME] | 4
 |  |  |  | Scenario 2
 |  |  |  | [NAME] | Criteria 1
 |  |  |  | Apple | [NAME]
 |  |  |  | 2 | Result
 | The criteria can be in any order
Spreadsheet: 783402d1654783700-demand-plan-basis-on-90-warehouse-utilization-book1-azii-
Sheet: Sheet2

Effective sq.ft | Closing stock |  | Total Tonnage | 4.03 | 4.03 | Total space utilized | Ref. | Total Capacity (mT) | Opening (Jun-1st) | Demand Plan | DN Forecast | Closing Stock | Days | Utilization % | Ref.
 | NP FFL |  |  | NP FFL
9360.4 |  |  |  |  |  |  | '=IF(E$1*B3<0,0,E$1*B3) | 1581.148648648649 | 1219.15 |  | 1395.5 | 2123.65 | 24.98411764705882 |  | =g3/a3
10437.5 |  |  |  |  |  |  |  | 1763.091216216216 | 1952.6 |  | 1446.6 | 2905.3 | 45.87315789473683
15121 |  |  |  |  |  |  |  | 2554.222972972973 | 2575.65 |  | 2216.5 | 3158.450000000001 | 32.11983050847459
3614.5 |  |  |  |  |  |  |  | 610.5574324324324 | 782.4499999999999 |  | 1238.65 | 743.0999999999999 | 26.22705882352941
15750 |  |  |  |  |  |  |  | 2660.472972972973 | 1096.8 |  | 358.2 | 2837.900000000001 | 30.9589090909091
8965.5 |  |  |  |  |  |  |  | 1514.442567567567 | 2003.75 |  | 793.3 | 1210.45 | 0
18652 |  |  |  |  |  |  |  | 3150.675675675676 | 2389.75 |  | 3273.5 | 7915.549999999999 | 50.52478723404255
34764.25999999999 |  |  |  |  |  |  |  | 5872.341216216216 | 10248.7 |  | 11070.95 | 6910.383333333333 | 40.6493137254902
Table 1 |  |  |  |  |  |  |  | Table 2
June |  |  |  | July |  |  |  |  | Ref. | K3=B15 and so on
Opening Stock | Demand Plan | DN Forecast | Closing Stock | Opening Stock | Demand Plan | DN Forecast | Closing Stock
0 |  | 600 |  |  | 0 | 1000 | 700 |  | Steps to find formula: |  | g3/a3=0.9
658.3499999999999 |  | 958.3499999999999 |  |  | 0 | 900 | 1199.3 |  |  |  | SUM(E3:F3)/a3=0.9
114 |  | 814 |  |  | 0 | 900 | 1199.3 |  |  |  | SUM(IF(E$1*B3<0,0,E$1*B3),F3)/a3=0.9
560.65 |  | 1060.65 |  |  | 0 | 300 | 399.2999999999997 |  |  |  | SUM(IF(E$1*D15<0,0,E$1*D15),F3)/a3=0.9
0 |  | 0 |  |  | 0 | 900 | 1199.3 |  |  |  | SUM(IF(E$1*(A15+B15-C15)<0,0,E$1*(A15+B15-C15)),F3)/a3=0.9
6.75 |  | 0 |  |  | 0 | 0 | 6.75 |  |  |  | E$1*(A15+B15-C15)/a3=0.9 |  |  | Assuming that E$1*(A15+B15-C15) must be greater than zero in order for O3 = 90%
30 |  | 1830 |  |  | 0 | 3000 | 3999.299999999999 |  |  |  | (A15+B15-C15)/a3=0.9/E$1
0 |  | 1200 |  |  | 0 | 2800 | 3732.633333333333 |  |  |  | A15+B15-C15=0.9/E$1*a3
Table 3 |  |  |  |  |  |  |  |  |  |  | B15=0.9/E$1*a3-A15+C15
Spreadsheet: 367840d1420134922-solved-help-want-to-subtract-values-based-on-if-check-box-is-checked-test-5-
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] | 135
bill 2 | 220
bill 3 | 800
[NAME] | 50
Spreadsheet: 880647d1728480452-transform-output-file-into-usable-data-layout-test_cjshoe
Sheet: Output

ITEM | COST UM | LIST | UM | STANDARD | WALK IN | GOOD | BETTER | MGR APPRV | UM2
[NAME] | 329.170 EA | 638.18 | EA | 638.18 | 457.55 | 421.34 | 391.71 | 365.38 | EA |  |  | 329.170 EA | 638.18 | EA | 638.18 | 457.55 | 421.34 | 391.71 | 365.38 | EA | MC | 1.39 | 1.28 | 1.19 | 1.11
 | MULTIPLIER |  |  |  | 1.39 | 1.28 | 1.19 | 1.11
 | BASIS |  |  |  | MC | MC | MC | MC
JNK15A-8PDCS/DVS DU | 843.400 EA | 1686.8 | EA | 1686.8 | 1172.33 | 1062.68 | 1003.65 | 936.17 | EA
 | MULTIPLIER |  |  |  | 1.39 | 1.26 | 1.19 | 1.11
 | BASIS |  |  |  | MC | MC | MC | MC
JNK15E-8P-DCS-DVS-DU | 1406.380 EA | 2519.58 | EA | 2519.58 | 1954.87 | 1757.98 | 1645.46 | 1561.08 | EA
 | MULTIPLIER |  |  |  | 1.39 | 1.25 | 1.17 | 1.11
 | BASIS |  |  |  | MC | MC | MC | MC
[NAME] | 1357.540 EA | 2459.03 | EA | 2459.03 | 1886.98 | 1696.93 | 1615.47 | 1506.87 | EA
 | MULTIPLIER |  |  |  | 1.39 | 1.25 | 1.19 | 1.11
 | BASIS |  |  |  | MC | MC | MC | MC
Spreadsheet: 237499d1369233329-how-do-i-tie-a-column-to-a-pivot-table-z_examplefile
Sheet: Sheet6

Calculated Field
[NAME] | Field | [NAME]
1 | PromCrd | ='PC Passes'/'PC Calls'
2 | Comp | ='C Passes'/'C Calls'
3 | [NAME] | =EmailPass/EmailElig
4 | Cell | =CellPass/CellElig
5 | RecAsk | ='Rec Ask'/'Rec Elig'
6 | %Goal | =(paidhours*Money)/(paidhours*ABSPaidHourGoal)
7 | Recurring% | =Recur/Transac
8 | Availability | =TotNet/Totavail
9 | Unaccounted | =Unacc/Totavail
10 | %WRAP | =Wrap/Logged
11 | AHT(IB) | ='Total Time'/'IB Calls'
12 | UnconOthr | =Uncon/Totavail
Calculated Item
[NAME] | Item | [NAME]
Note: | When a cell is updated by more than one formula,
 | the value is set by the formula with the last solve order.
 | To change the solve order for multiple calculated items or fields,
 | on the Options tab, in the [NAME] group, click [NAME], and then click [NAME].
Spreadsheet: 112344d1308505403-merging-tasks-w-parts-ordered-for-tasks-sample-task-parts-merger
Sheet: Tasks

200 TASK CARDS / NON-ROUTINES BY TASK NUMBER
Task | ATA | [NAME] | OPEN/CLOSED | STATUS | TASK DRIVER | NOTES
433 | 53-20 | FLOORBOARD FRAME AT FRAME 41 CORRODED. | OPEN | APPROVED | 36/12K
434 | 53-20 | FLOORBOARD FRAME AT FRAME 38 CORRODED. | OPEN | AWAITING REP APPROVAL | 36/12K | CSP- ADDL PARTS REQ. $431.25 AWAIT. REP. 6-14-11
435 | 53-20 | FLOORBOARD FRAME AT FRAME 40 CORRODED. | OPEN | STORES FOR PRICING | 36/12K | ADDL PARTS REQ 6/2/11 $
436 | 53-20 | FLOORBOARD FRAME AT FRAME 39 CORRODED. | OPEN | APPROVED | 36/12K