tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 51037d1250615990-how-do-i-make-a-column-array-variable-within-a-function-variable-array-sample
Sheet: Sheet1

Beg Date | 2009-07-20 00:00:00 |  |  |  | NEED: Average between 2 dates pulled from table below based on Market chosen
End Date | 2009-07-24 00:00:00
 |  |  |  |  | =AVERAGEIFS(L:L,K:K,">="&B$2,K:K,"<="&B$3)
MARKET INPUT |  |  |  |  | AVERAGEIFS(array with data , array with dates, ">=" & beg date , array with dates ,"<="& end date) |  |  |  |  |  |  |  |  |  | List | Column Number
Market 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Market 2 | 12
Market 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Market 3 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Market 4 | 14
 |  |  |  |  |  |  |  |  |  | Date | Market 2 | Market 3 | Market 4 | Market 5 | etc…
 |  |  |  |  |  |  |  |  |  | 2009-07-16 00:00:00 | 80 | 92 | 106
 |  |  |  |  |  |  |  |  |  | 2009-07-17 00:00:00 | 80 | 92 | 106
 |  |  |  |  |  |  |  |  |  | 2009-07-20 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-21 00:00:00 | 84 | 97 | 112
 |  |  |  |  |  |  |  |  |  | 2009-07-22 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-23 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-24 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-27 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-28 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-29 00:00:00 | 82 | 94 | 108
 |  |  |  |  |  |  |  |  |  | 2009-07-30 00:00:00 | 80 | 92 | 106
 |  |  |  |  |  |  |  |  |  | 2009-07-31 00:00:00 | 78 | 90 | 104
 |  |  |  |  |  |  |  |  |  | 2009-08-03 00:00:00 | 78 | 90 | 104
 |  |  |  |  |  |  |  |  |  | 2009-08-04 00:00:00 | 74 | 85 | 98
 |  |  |  |  |  |  |  |  |  | 2009-08-05 00:00:00 | 72 | 83 | 95
 |  |  |  |  |  |  |  |  |  | 2009-08-06 00:00:00 | 66 | 76 | 87
 |  |  |  |  |  |  |  |  |  | 2009-08-07 00:00:00 | 66 | 76 | 87
 |  |  |  |  |  |  |  |  |  | 2009-08-10 00:00:00 | 62 | 71 | 82
 |  |  |  |  |  |  |  |  |  | 2009-08-11 00:00:00 | 61 | 70 | 81
 |  |  |  |  |  |  |  |  |  | 2009-08-12 00:00:00 | 56 | 64 | 74
 |  |  |  |  |  |  |  |  |  | 2009-08-13 00:00:00 | 56 | 64 | 74
 |  |  |  |  |  |  |  |  |  | 2009-08-14 00:00:00 | 54 | 62 | 71
Spreadsheet: 109234d1306161415-autofill-help-accessing-random-cells-on-separate-sheet-reference-book1example
Sheet: Sheet2

Client # | Name
930 | User1 LastName | 123 Smith Road | New York, NY 10001 | [PHONE] | [PHONE] | [EMAIL] | 1955-02-03 00:00:00 | 2007-05-19 00:00:00 | 2010-11-13 00:00:00
19 | User2 LastName | 456 Smith Road | New York, NY 10002 | [PHONE] | [PHONE] | [EMAIL] |  | 2006-11-15 00:00:00 | 2011-01-15 00:00:00
1653 | User3 LastName | 789 Smith Road | New York, NY 10003 | [PHONE] | [PHONE] | [EMAIL] | 1965-03-04 00:00:00 | 2008-08-19 00:00:00 | 2010-04-29 00:00:00
1703 | User1703 LastName | 111 Some Street | Newark, NJ 08912 | [PHONE] | [PHONE] | [EMAIL] |  | 2009-12-22 00:00:00 | 2011-01-14 00:00:00
1170 | [NAME] | 2222 Jones Road | Edison, NJ 07689 | [PHONE] | [PHONE] | [EMAIL] | 1975-04-05 00:00:00 | 2007-06-01 00:00:00 | 2010-07-30 00:00:00
Spreadsheet: andy_zipper__123__Broker & Exchange Detail 6-7-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 | 3 | 4
 | [NAME]: counterparty has no bid access to product | 1 | 10 | 11
 | [NAME]: counterparty has no offer access to product |  | 6 | 6
 | FAILURE: Limit price violated |  | 17 | 17
 | [NAME]: product violates counterparty term limit | 3 |  | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 7 | 1 | 8
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 30 | 5 | 35
APB Energy, Inc. Total |  | 43 | 42 | 85
Natsource LLC | FAILURE: counterparty exceeded credit limit | 2 | 5 | 7
 | [NAME]: counterparty has no bid access to product | 1 | 4 | 5
 | [NAME]: counterparty has no offer access to product |  | 6 | 6
 | FAILURE: Limit price violated | 1 | 13 | 14
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 9 | 10
 | FAILURE: Base product not active for hedge | 2 |  | 2
Natsource LLC Total |  | 7 | 40 | 47
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 3 |  | 3
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 21 |  | 21
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 4 |  | 4
Amerex Natural Gas I, Ltd. Total |  | 6 |  | 6
Amerex Power, Ltd. | FAILURE: counterparty exceeded credit limit |  | 1 | 1
 | [NAME]: counterparty has no bid access to product |  | 5 | 5
 | FAILURE: Limit price violated |  | 3 | 3
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 12 | 12
Prebon Energy, Inc. | FAILURE: Order pended due to limit price violation | 1 |  | 1
Prebon Energy, Inc. Total |  | 1 |  | 1
Grand Total |  | 78 | 94 | 172
Spreadsheet: 118082d1313432147-vlookup-to-show-0-as-0-and-blank-as-blank-chk_flowback-3-
Sheet: 24 HOUR QUERY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  |  |  |  |  | Phone Number:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flowback Company:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flowback Rep: |  |  |  |  |  | Phone Number:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flowback Rep: |  |  |  |  |  | Phone Number:
 | EASTERN DIVISION |  |  | SELECT START DATE: |  |  |  |  |  | 2011-07-21 00:00:00 |  |  |  |  |  |  | Total Recovery Volume:
 | NORTHERN DISTRICT
 | TIME DATA |  |  | PRESSURE DATA |  |  |  |  |  | PRODUCTION DATA |  |  |  |  |  |  | ADDITIONAL DATA |  |  |  |  |  | WATER DETAILS |  |  |  |  | COMMENTS / REMARKS
 | DATE / TIME | ELAPSED TIME |  | TUBING PRESSURE | CASING PRESSURE | INTERMEDIATE PRESSURE | SURFACE PRESSURE | LINE PRESSURE |  | GAS RATE | 24 HOUR SALES | CUM. SALES | WATER RATE | 24 HOUR WATER | CUM. WATER |  | SAND RETURNS | CHOKE SIZE | FLOW TEMP | DIFF. | ORIFICE SIZE |  | WATER WEIGHT | CHLORIDES | [NAME] | [NAME]
 | [mm/dd/yy   hh:[NAME]] | [hours] |  | [psig] | [psig] | [psig] | [psig] | [psig] |  | [mcfd] | [mcf] | [mcf] | [bwph] | [bbls] | [bbls] |  |  | [64ths] | [°F] | [in. H2O] | [in] |  | [ppg] | [ppm] | [bbl] | [%]
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Spreadsheet: 726056d1617030791-convert-data-from-skills-matrix-into-analyzable-data-model-by-employees-skills-in-rows-sample-original-data-and-desired-result
Sheet: Result

 | employee 1 | Art | Germany
X | employee 1 | Art | Germany | Hardware B | ggg
X | employee 1 | Art | Germany | Hardware C | EXPERT
X | employee 1 | Art | Germany | Hardware D | EXPERT
X | employee 1 | Art | Germany | Hardware E | EXPERT
X | employee 1 | Art | Germany | Hardware F | EXPERT
X | employee 1 | Art | Germany | Software A | EXPERT
X | employee 1 | Art | Germany | Software B | EXPERT
Y | employee 2 | Science | France | Hardware A | ADVANCED
Y | employee 2 | Science | France | Hardware B | ADVANCED
Y | employee 2 | Science | France | Hardware C | EXPERT
Y | employee 2 | Science | France | Hardware D | EXPERT
Y | employee 2 | Science | France | Hardware E | EXPERT
Y | employee 2 | Science | France | Hardware F | EXPERT
Y | employee 2 | Science | France | Software A | ADVANCED
Y | employee 2 | Science | France | Software B | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware A | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware B | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware C | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware D | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware E | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware F | EXPERT
Z | employee 3 | Enginieer | Belgium | Software A | ADVANCED
Z | employee 3 | Enginieer | Belgium | Software B | ADVANCED
#REF! | #REF! | #REF! | #REF! | Hardware A | #REF!
#REF! | #REF! | #REF! | #REF! | Hardware B | #REF!
#REF! | #REF! | #REF! | #REF! | Hardware C | #REF!
#REF! | #REF! | #REF! | #REF! | Hardware D | #REF!
#REF! | #REF! | #REF! | #REF! | Hardware E | #REF!
#REF! | #REF! | #REF! | #REF! | Hardware F | #REF!
#REF! | #REF! | #REF! | #REF! | Software A | #REF!
Spreadsheet: 754171d1635980935-commission-payable-based-on-target-received-sm_mc-incentive-november
Sheet: Formula Comparison

 | Regular Commission |  |  |  | Regular Club Target Met Commission
 | Min. Units | [NAME] | Commission $ per unit |  | Min. Units | [NAME] | Club Target Met $ per unit
 | 10 | 29 | 40 |  | 10 | 29 | 20
 | 30 | 39 | 40 |  | 30 | 39 | 20
 | 40 | 49 | 50 |  | 40 | 49 | 25
 | 50 | 500 | 60 |  | 50 | 250 | 30
 | Units Sold | [NAME]  P/Unit | Payout Amount
 | 11
 | Club Target Met Yes/No | Club Target Met $ per unit | Club Target Met Payout Amount
 | 22
 | Total Incentive Payable
 | November Incentive
 | Units Sold | Unit Commission Rate, P/Unit | Commission Amount
 | 45
 | Min. Units | [NAME] | 0.8 | 0.9 | 1 | 1.1
 | 10 | 29 | 20 | 30 | 40 | 60
 | 30 | 39 | 20 | 30 | 40 | 60
 | 40 | 49 | 25 | 37.5 | 50 | 75
 | 50 | 250 | 30 | 45 | 60 | 90
 | % Store Target Met | Store Target Met $ per unit | Store Target Met Payout Amount
 | 0.9
 | Total Incentive Payable
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Imbal
1 | -3728 | -3387 |  | -25
2 | -3766 | -3387 |  | -25
3 | -3703 | -3387 | -4 | -25
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141715.48
2002-03-03 00:00:00
CBS Volume
 |  |  | 61661
Spreadsheet: 598340d1542384395-smallest-value-for-conditions-example-3-
Sheet: not working!

Country | Location | Colour | Value |  | Class
poland | warsaw | blue apple | 0.2 |  | big
poland | poznan | blue apple | 0.4 |  | small
poland | warsaw | red apple | 0.1 |  | small
poland | poznan | blue apple | 0.3 |  | small
germany | xyz | blue apple | 0.5 |  | small | Provide Country: | poland
poland | poznan | blue apple | 0 | 0% should be not taken into consideration!! | small | Provide Colour | blue apple
 |  |  |  |  |  | Provide class: | small
 |  |  |  | Final result
Spreadsheet: 122127d1316624416-formatting-issue-causing-printing-problems-opencomp-truck-modmuscle-indexsheet
Sheet: OC NMCA

 |  | Open Comp NMCA
Car Number | 1st Session | 2nd Session | 3rd Session | Quickest Time | Dial In
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
 |  |  |  | 0 | ERR
Spreadsheet: 123930d1317929512-splitting-address-into-multiple-columns-addresstranspose
Sheet: Sheet1

 | Address line 1 | Address line 2 | City | State | [NAME]
170 S. 29th Street San Jose, CA 95116 | 170 S. 29th street |  | San Jose | CA | 95116
1305 [NAME]. [NAME], TX 75006-6980 | 1305 [NAME] rd |  | Carrollton | TX | 75006-6980
25800 Northwestern Hwy.,Suite 250 Southfield, MI 48075 | 25800 Northwestern Hwy., | Suite 250 | Southfield | MI | 48075
150 [NAME]., Ste. 2500 Detroit, MI 48226 | 150 [NAME]., | Ste. 2500 | Detroit | MI | 48226
Spreadsheet: 58008d1258318402-duplicating-text-into-columns-in-extra-sheets-pub-schedule
Sheet: Peter

 | 2001-01-01 00:00:00
 | T                   2
 | 3
1 | 4
 | 5
 | 6
 | 7
 | 8 | pub1
 | 9
 | 10
 | 11
2 | 12
 | 13
 | 14
 | 15 | pub3
 | 16
 | 17
 | 18
3 | 19
 | 20
 | 21
 | 22 | Pub2
 | 23
 | 24
 | 25
4 | 26
 | 27
 | 28
 | 29
 | 30 | pub1
 | 31
Spreadsheet: 758566d1638952866-rand-names-on-exact-date-book1-6-
Sheet: Sheet1

Number: | 2
Date: | 2021-12-01 00:00:00
Name: | Date: |  | Results:
[NAME] | 2021-12-01 00:00:00
Anne | 2021-12-01 00:00:00
[NAME] | 2021-12-01 00:00:00
Mark | 2021-12-01 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
Spreadsheet: 58816d1259080769-data-in-multiple-columns-excel-problem
Sheet: students

Stud ID | Institution No. | Subject 1 | Subject 2 | Subject 3
1 | Institution 1 | Maths Business | Business Studies | Economics
2 | Institution 1 | Economics | Further Mathematics | EA
3 | Institution 1 | Business Studies | Maths Business | EA
4 | Institution 1 | Business Studies | Maths Business | EA
5 | Institution 1 | Business Studies | Maths Business | EA
6 | Institution 2 | International Relations | [NAME] | Society & Politics
7 | Institution 2 | International Relations | Business Studies | [NAME]
8 | Institution 2 | International Relations | [NAME] | Maths Business
9 | Institution 2 | Maths Business | [NAME] | Economics
10 | Institution 2 | Business Studies | [NAME] | Society & Politics
61 | Institution 3 | Maths Business | Economics | Society & Politics
62 | Institution 3 | Maths Business | Economics | Society & Politics
63 | Institution 3 | Maths Business | Economics | Society & Politics
64 | Institution 3 | Maths Business | Economics | Society & Politics
65 | Institution 3 | Maths Business | Economics | Society & Politics
Spreadsheet: 881571d1729680572-repeat-cell-contents-based-on-quantity-testb
Sheet: List

Item | Committed | Picked | Packed | Fulfilled | Received | Back Ordered | Quantity | Transfer Price | Amount | Description | Expected Ship Date | [NAME] | Expected Receipt Date | Commit | Commitment Confirmed | Order Priority | Options | Closed | CBM | Total CBM | Weight | Total Weight | QC Inspection | UPI Data | History | Price
123 |  |  |  |  |  |  | 5 |  |  | ABC
456 |  |  |  |  |  |  | 7 |  |  | EFG
789 |  |  |  |  |  |  | 1 |  |  | HIJ
Spreadsheet: 585645d1533887528-help-with-solver-inputs-wall-design-hydr-
Sheet: 2. Loading

Wind Loading
VR | 57 | m/s
Md Post | 0.95
[NAME] | 1
Mz,cat | 0.83
Ms | 1
Mt | 1
Vsit,β Post |  | m/s
Vsit,β Girt |  | m/s
p air | 1.2
kp | 1
b
c
h
b/c
c/h
Cpn Θ=0
b/c | c/h | [NAME] | e
>5 | 0.2 to 1 |  | 0
[NAME] Θ=45
b/c | c/h | [NAME] | x1 | x2
>5 | >0.7 | 2.4 | 0
>5 | >0.7 | 1.2
>5 | >0.7 | 0.6
Cpn Θ=90
b/c | c/h | - Cpn | + Cpn | x1 | x2
All | >0.7 | -1 | 1 | 0
All | >0.7 | -0.25 | 0.25
All | >0.7 | -0.25 | 0.25
x1 | x2 | [NAME] | Cdyn | Pressure Post (Pa) | Pressure Girt (Pa)
0 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
Spreadsheet: 733217d1621442053-match-two-cells-with-two-cells-from-range-excel-question-5-19-2021
Sheet: Sheet1

Table 2 |  |  |  |  |  | Table 1
Part | Plant |  |  |  |  | Part | Plant | Column1
123 | ZZ45 | Function = if cell A2 & B2 match G2 & H2 or G3 & H3 or G4 & G4 etc, then return I2 (or I3 etc which ever the case is) |  |  |  | 123 | ZZ45 | 45
456 | GH67 |  |  |  |  | 555 | GH67 | 76
678 | ZZ45 |  |  |  |  | 678 | ZZ45 | 37
345 | BH89 |  |  |  |  | 345 | BH89 | 98
123 | BH89 |  |  |  |  | 123 | BH89 | 12
456 | ZZ45 |  |  |  |  | 456 | ZZ45 | 3
890 | BH89 |  |  |  |  | 890 | BH89 | 6
 |  |  | #N/A
 |  |  | 37
 |  |  | 98
 |  |  | 12
 |  |  | 3
 |  |  | 6
Spreadsheet: mary_fischer__25622__87P
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF MINORITY INTERESTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[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: 800505d1665690165-using-sumproduct-to-transpose-and-summarize-data-from-a-matrix-to-a-vertical-table-excel-file
Sheet: Problem

 |  |  | Matrix Table |  |  |  |  |  |  |  |  |  |  | Problem |  |  |  |  |  |  | End Result
 |  |  | Job Hours |  |  |  |  | Episodes per Month
 | # | Quote | Job 1 | Job 2 | Job 3 | Job 4 | Total | Episodes | Months | Per Month |  | # | Quote | 1 | 2 | 3 | 4 | 5 |  | Quote | 1 | 2 | 3 | 4 | 5
 | 1 | 324172 | 1 | 2 | 3 | 1 |  | 6 | 5 |  |  | 1 | 324172 |  |  |  |  |  |  | 324172
 | 2 | 323966 |  |  |  | 1 |  | 6 | 3 |  |  | 2 | 323966 |  |  |  |  |  |  | 323966
 | 3 | 323965 | 1 |  | 1 |  |  | 6 | 4 |  |  | 3 | 324207 |  |  |  |  |  |  | 324207
 | 4 | 324207 |  | 2 |  | 2 |  | 6 | 5
 | 5 | 324312 | 1 |  | 1 | 1 |  | 6 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Tasks |  |  |  |  |  |  | Tasks
 |  |  |  |  |  |  |  |  |  |  |  |  | Job 1 |  |  |  |  |  |  | Job 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Job 2 |  |  |  |  |  |  | Job 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Job 3 |  |  |  |  |  |  | Job 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Job 4 |  |  |  |  |  |  | Job 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  | I like to use a single formula statement, as opposed to a conjoined mulitple statement formula as shown in the 'End Result' example,
 |  |  |  |  |  | to transpose and summarize numbers from the matrix table to a standard vertical table as show in the "Problem" table.
 |  |  |  |  |  | However, the figures and outcome should be the same as shown on the "End Result" table.
Spreadsheet: 887553d1737791880-muliply-a-value-with-some-criteria-if-formula-help-from-help-forum
Sheet: Sheet1

Name | Designation | Gross Salary | One day salary | MISS | Need formula
 | FSA | 39035 | 1259.193548387097 | 19
 | [NAME] | 42000 | 1354.838709677419 | 8
 | Driver | 32000 | 1032.258064516129 | 0
 | Driver | 32000 | 1032.258064516129 | 9
 | SOL | 32000 | 1032.258064516129 | 16
 | SOL | 32000 | 1032.258064516129 | 29
 | Skilled OFC Labour | 32000 | 1032.258064516129 | 17
 | Skilled OFC Labour | 32000 | 1032.258064516129 | 15
 | Driver | 32000 | 1032.258064516129 | 8
 | Skilled OFC Labor | 32000 | 1032.258064516129 | 0
 | Associate Technician | 32000 | 1032.258064516129 | 8
 | Technical Associate | 32000 | 1032.258064516129 | 0
 | FSA | 32000 | 1032.258064516129 | 16
 | Technical Assistant | 32000 | 1032.258064516129 | 12
 | FSA | 32000 | 1032.258064516129 | 10
 | Labor-Cum-Helper | 32000 | 1032.258064516129 | 8
 | Labor-Cum-Helper | 32000 | 1032.258064516129 | 13
 | Driver | 32000 | 1032.258064516129 | 8
 | Technician Assistant | 32000 | 1032.258064516129 | 0
 | Technical Associate | 32000 | 1032.258064516129 | 8
 | Technical Associate | 32000 | 1032.258064516129 | 10
 | Manager FTTH | 140000 | 4516.129032258064 | 0
 | Driver | 32000 | 1032.258064516129 | 12
 | Senior Technician | 40000 | 1290.322580645161 | 20
 | ANT | 44000 | 1419.354838709677 | 19
 | Splicer | 40000 | 1290.322580645161 | 10
 | Splicer | 46000 | 1483.870967741935 | 17
 | Technician-FTTH | 45000 | 1451.612903225806 | 8
 | Supervisor [NAME] | 45000 | 1451.612903225806 | 0
 | Technician | 40000 | 1290.322580645161 | 8
 | Supervisor | 53000 | 1709.677419354839 | 12
 | Technical Associate | 32000 | 1032.258064516129 | 12
 | ANT | 32000 | 1032.258064516129 | 16
 | ANT | 35000 | 1129.032258064516 | 18
 | FSA | 32000 | 1032.258064516129 | 10
 | FSA | 32000 | 1032.258064516129 | 0
Spreadsheet: 738267d1624948959-transposing-data-transposing-data-ans
Sheet: Sheet1

Date | Year | Quarter | Conversion | Currency | Currency | Value
2016-01-01 00:00:00 | 2016 | AUDCAD | Curncy | 1.0117
2016-01-01 00:00:00 | 2016 | AUDCLP | Curncy | 515.673
2016-01-01 00:00:00 | 2016 | AUDCZK | Curncy | 18.1714
2016-01-01 00:00:00 | 2016 | AUDDKK | Curncy | 5.013
2016-01-01 00:00:00 | 2016 | AUDHUF | Curncy | 211.757
2016-01-01 00:00:00 | 2016 | AUDILS | Curncy | 2.8311
2016-01-02 00:00:00 | 2016 | AUDJPY | Curncy | 88.085
2016-01-02 00:00:00 | 2016 | AUDKRW | Curncy | 855.6085
2016-01-02 00:00:00 | 2016 | AUDMXN | Curncy | 12.6062
2016-01-02 00:00:00 | 2016 | AUDNZD | Curncy | 1.0615
2016-01-02 00:00:00 | 2016 | AUDNOK | Curncy | 6.47467
2016-01-02 00:00:00 | 2016 | AUDPLN | Curncy | 2.8803
2016-01-03 00:00:00 | 2016 | AUDSEK | Curncy | 6.1776
2016-01-03 00:00:00 | 2016 | AUDCHF | Curncy | 0.7307
2016-01-03 00:00:00 | 2016 | AUDTRY | Curncy | 2.1262
2016-01-03 00:00:00 | 2016 | AUDGBP | Curncy | 0.4952
2016-01-03 00:00:00 | 2016 | AUDUSD | Curncy | 0.7303
2016-01-03 00:00:00 | 2016 | AUDEUR | Curncy | 0.6726
Spreadsheet: eb896a1c-4f01-44f3-ac01-3a55c8e47cd2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: November 23, 2014 (10:01 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
Spreadsheet: 265265d1379153206-rota-time-calculations-and-colour-coding-staff-rota
Sheet: Sheet1 (2)

 | Monday
 | Start/Finish Time | Total Shift length | Additional hours worked
[NAME] | 07:30:00 | 08:30:00 | 01:30:00 |  |  | 0.3125 | 0.7291666666666666
 | 17:00:00 |  |  |  |  | 0.7083333333333334 | 0.5416666666666666
[NAME] | 14:00:00 | 08:00:00 | 04:00:00 |  |  | 09:30:00
 | 22:00:00
 |  |  | I'd like cell C3, C5, C7 etc to minus 1 hour if the shift begins before 08:30 and ends after 14:30
 |  |  | I'd like a day time shift ie one starting and finishing before 17:30 to be filled red and any shift starting after 13:00 to be filled dark red. I've currently got only the starting time colour coded using conditional formatting.
 |  |  | Cells in column B are the only input cells with the remainder being result cells.
 |  |  | The results in column D are currently looking at sheet 2 and deducting the staff members normal hours for a Monday from what they actually worked.