tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building19

Building19
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 129328d1321547654-conditional-formatting-two-cols-such-that-both-cols-get-same-color-based-on-a-sum-conditional_format_two_cells_together
Sheet: Sheet1

2 | 3 |  | 1 | 1 | UL | LL | Goal:
1 | 5 |  |  |  | 5 | 2 | I will have two cols of data(col A and col B).
2 | 5 |  |  |  |  |  | I want to conditionally format these two cols such that if the sum of the data in their respective cells are larger than some limit
2 | 3 |  |  |  |  |  | then BOTH cells are to be formated a certain way.
1 | 0
2 | 1 |  |  |  |  |  | For example
3 | 1 |  |  |  |  |  | If [NAME] and B1=2 the sum is 3 and this is less than or equal to 4…….both A1 and B1 would be formatted green
4 | 1
1 | 2 |  |  |  |  |  | if A1=4 and B1=1 then sum is 5 and this is greater than 4 …..both [NAME] and B1 would be formatter red
2 | 2
3 | 2
4 | 2 |  |  |  |  |  | ($A1+$B1)<=4 |  | if(and((SUM($A1,$B1)<=UL,sum($a1,$b1)>=LL),true,false)
1 | 3
2 | 3
3 | 3
4 | 3
1 | 4
2 | 4
3 | 4
4 | 4
1 | 5
2 | 5
3 | 5
4 | 5
4 | 5
4 | 5
4 | 5
4 | 5
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-08-31 00:00:00 |  | 1328416.64
2001-09-08 00:00:00
60874 | 1363
78169
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-08-31 00:00:00 |  | 275313.72
2001-09-08 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 281142 | 117857 | 148659
2001-08-31 00:00:00 |  | 760779.86
2001-09-10 00:00:00
500241
500391 | 2488
500392 | 727
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: kate_symes__18461__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 |  |  |  |  |  | ..
Spreadsheet: 272160d1382244062-need-help-with-formula-left-right-subtitute-book1
Sheet: Sheet1

 |  |  | 1St Step | 2Nd Step | 3Rd Step
 |  |  |  |  | Replace "-" with ""
1 - 4 Hours apr |  |  |  |  | 4
3 Hours apr |  |  |  |  | 3
2 - 10 Hours apr |  |  |  |  | 10
2hrs |  |  |  |  | 2
6-8 Hours apr |  |  |  |  | 8
3-7hrs
3-7 hrs
7-11 hrs
4-6 hrs APR
Spreadsheet: 762584d1641648505-dynamic-dropdown-list-based-on-cell-value-ts-and-ps-tanks-schedule-2022
Sheet: Lookup Tables

Terminals | Terminal PM - Lookup | TS/PS - Lookup | Tank Type - Lookup | Service Status - Lookup | Inspection Status - Lookup | Contractor - Lookup | Project Managers | Project Schedule - Lookup | TS/PS - Lookup | Today | This Year | This Month | This Quarter | Quarters | Year
Aldermaston - Gully  - Lookup | [NAME] | PS | AST | In-Service | N/A | N/A | [NAME] | On [NAME] (+/-) 2 Weeks | TS |  |  |  |  | Q1 | 2021
Aldermaston - Top Site | [NAME] | PS | UST | In Service – Approved Postponement | Awaiting Tank Emptying | Mistras Group | [NAME] | 3-4 Weeks Behind Schedule | PS |  |  |  |  | Q2 | 2022
Amsterdam | [NAME] | TS | Square | Out-of-Service For Inspection | Awaiting Tank Cleaning | Oceaneering | [NAME] | >4 Weeks Behind Schedule |  |  |  |  |  | Q3 | 2023
[NAME] | [NAME] | PS | Horizontal | Out-of-Service - Awaiting Contract | Awaiting Op's Handover to PM | Rosen | [NAME] | N/A |  |  |  |  |  | Q4 | 2024
Belfast | [NAME] | TS | Sphere | L.T.O.O.S | Awaiting [NAME] | TesTex NDT | [NAME] |  |  |  |  |  |  |  | 2025
Bramhall | [NAME] | PS | Bullet |  | Awaiting Inspection | Viking NDT | [NAME] |  |  |  |  |  |  |  | 2026
Clydebank | [NAME] | TS |  |  | Inspection Ongoing | UltraScan NDT |  |  |  |  |  |  |  |  | 2027
Eastham | [NAME] | TS |  |  | Inspection Complete - Awaiting Report |  |  |  |  |  |  |  |  |  | 2028
[NAME] | [NAME] | TS |  |  | Report Issued - Awaiting Review & Repair Plan |  |  |  |  |  |  |  |  |  | 2029
Grays | [NAME] | TS |  |  | Repair Plan Issued - Awaiting Repairs |  |  |  |  |  |  |  |  |  | 2030
Hallen | [NAME] | PS |  |  | Repairs Ongoing |  |  |  |  |  |  |  |  |  | 2031
Immingham - East | [NAME] | TS |  |  | Repairs Complete - Awaiting Post Repair Inspection |  |  |  |  |  |  |  |  |  | 2032
Immingham - West | [NAME] | TS |  |  | Post Repair Inspection Complete - Awaiting Post Repair Report |  |  |  |  |  |  |  |  |  | 2033
Inverness | [NAME] | PS |  |  | Under Hydro Test |  |  |  |  |  |  |  |  |  | 2034
Killingholme | [NAME] | PS |  |  | Tank Handed Over to Operations |  |  |  |  |  |  |  |  |  | 2035
Mannheim - North | [NAME] | TS |  |  |  |  |  |  |  |  |  |  |  |  | 2036
Mannheim - South | [NAME] | TS |  |  |  |  |  |  |  |  |  |  |  |  | 2037
Misterton | [NAME] | PS |  |  |  |  |  |  |  |  |  |  |  |  | 2038
[NAME] | [NAME] | PS
Redcliff Bay | [NAME] | PS
Riverside | [NAME] | TS
Runcorn | [NAME] | TS
[NAME] | [NAME] | PS
[NAME] | [NAME] | TS
[NAME] | [NAME] | TS
Shannon | [NAME] | TS
Thetford | [NAME] | PS
Tyneside | [NAME] | TS
[NAME] | [NAME] | PS
Spreadsheet: kevin_ruscitti__20286__BidWkTrades_Mar01
Sheet: Sheet1

 | March Settle: | 4.998
 | Michcon:
 | Date | Location | Volume | B/S | Basis Price | Fix Price | Weight
 | 2001-02-22 00:00:00 | Michcon | 9677 | B | 0.24
 | 2001-02-22 00:00:00 | Michcon | 9677 | S | 0.22
 | 2001-02-22 00:00:00 | Michcon | 1968 | S | 0.245
 | 2001-02-23 00:00:00 | Michcon | 839 | S |  | 5.42
 | 2001-02-26 00:00:00 | Michcon | 175 | S |  | 5.415
 | 2001-02-26 00:00:00 | Michcon | 645 | B |  | 5.345
 | 2001-02-26 00:00:00 | Michcon | 129 | S |  | 5.435
 | 2001-02-26 00:00:00 | Michcon | 10000 | S | 0.275
 | 2001-02-27 00:00:00 | Michcon | 2400 | S |  | 5.47
 | 2001-02-27 00:00:00 | Michcon | 1130 | S |  | 5.53
 | 2001-02-27 00:00:00 | Michcon | 6 | S |  | 5.535
 | 2001-02-27 00:00:00 | Michcon | 3300 | S |  | 5.55
 | 2001-02-27 00:00:00 | Michcon | 100 | S |  | 5.535
 | 2001-02-27 00:00:00 | Michcon | 92 | S |  | 5.56
 | Consumers Power:
 | Date | Location | Volume | B/S | Basis Price | Fix Price | Weight
 | 2001-02-23 00:00:00 | Consumers | 10000 | S | 0.21
 | 2001-02-23 00:00:00 | Consumers | 10000 | S | 0.235
 | 2001-02-23 00:00:00 | Consumers | 10000 | S | 0.23
 | 2001-02-24 00:00:00 | Consumers | 161 | S |  | 5.405
 | 2001-02-24 00:00:00 | Consumers | 750 | S |  | 5.415
 | 2001-02-26 00:00:00 | Consumers | 905 | S |  | 5.37
 | 2001-02-26 00:00:00 | Consumers | 10000 | S |  | 5.385
 | 2001-02-26 00:00:00 | Consumers | 4000 | B | 0.25
 | 2001-02-26 00:00:00 | Consumers | 10000 | S | 0.255
 | 2001-02-26 00:00:00 | Consumers | 1226 | S | 0.26
 | 2001-02-26 00:00:00 | Consumers | 752 | B |  | 5.27
 | 2001-02-26 00:00:00 | Consumers | 484 | S |  | 5.32
 | 2001-02-27 00:00:00 | Consumers | 221 | S |  | 5.33
 | 2001-02-27 00:00:00 | Consumers | 105 | B |  | 5.28
 | 2001-02-27 00:00:00 | Consumers | 2100 | S |  | 5.51
 | 2001-02-27 00:00:00 | Consumers | 150 | S |  | 5.51
 | 2001-02-27 00:00:00 | Consumers | 10000 | B |  | 5.495
 | 2001-02-27 00:00:00 | Consumers | 5000 | B |  | 5.52
 | 2001-02-27 00:00:00 | Consumers | 1935 | S |  | 5.58
 | 2001-02-28 00:00:00 | Consumers | 1000 | B |  | 5.51
 | 2001-02-27 00:00:00 | Consumers | 2000 | S |  | 5.55
 | ANR/ML7:
 | Date | Location | Volume | B/S | Basis Price | Fix Price | Weight
 | 2001-02-26 00:00:00 | ML7 | 5000 | B | 0.2475
 | 2001-02-27 00:00:00 | ML7 | 1113 | S |  | 5.58
 | 2001-02-28 00:00:00 | ML7 | 2020 | S |  | 5.67
Spreadsheet: 100289d1298665552-solved-formula-to-total-of-cells-based-on-criteria-sum-of-matching-states
Sheet: Location

Location | State
[NAME], NE | Nebraska
Canaan, CT | Connecticut
Columbus, NE | Nebraska
[NAME], NJ | New Jersey
Franklin, WI | Wisconsin
Hancock, NY | New York
Holdrege, NE | Nebraska
[NAME], SC | South Carolina
Juncos, PR | Puerto Rico
Left Early | n/a
n/a | n/a
Nogales, MX | Mexico
Oceanside, CA | California
Outside BD | n/a
PdC, France | France
RTP, NC | North Carolina
Rutherford, NJ | New Jersey
San Diego, CA | California
San Jose, CA | California
Sandy, UT | Utah
Sarasota, FL | Florida
Sparks, MD | Maryland
Treyburn, NC | North Carolina
Waltham, MA | Massachusetts
Woburn, MA | Massachusetts
St. Louis, MO | Missouri
Spreadsheet: 869301d1715884787-map-function-spilling-multiple-results-per-row-byrow_map
Sheet: sheet

Text 1 | Text 3 | Text 4 | Result
Ava | @gmail | .com |  |  |  | @gmail | .com
Emma | @outlook | .com | [EMAIL] |  | Emma | @outlook | .com
[NAME] | @company | .org | [EMAIL] |  | [NAME] | @company | .org
[NAME] | @yahoo | .com | [EMAIL] |  | [NAME] | @yahoo | .com
[NAME] | @institute | .edu | [EMAIL] |  | [NAME] | @institute | .edu
Olivia | @outlook | .com | [EMAIL] |  | Olivia | @outlook | .com
Sophia | @gmail | .com | [EMAIL] |  | Sophia | @gmail | .com
Spreadsheet: 829814d1684463906-numbering-weeks-example-week-numbering
Sheet: Sheet1

 |  |  |  | Sample date 1: |  | 2023-08-14 00:00:00 |  | Sample date 2: |  | 2024-08-14 00:00:00
In column A,  I want the column to list all the weeks just by one day, and the week number for that given time frame. It should work for any set of dates I plug in above
 | 1
2023-08-21 00:00:00 | 2
2023-08-28 00:00:00 | 3
2023-09-04 00:00:00 | 4
2023-09-11 00:00:00 | 5
2023-09-18 00:00:00 | 6
2023-09-25 00:00:00 | 7
2023-10-02 00:00:00 | 8
2023-10-09 00:00:00 | 9
2023-10-16 00:00:00 | 10
2023-10-23 00:00:00 | 11
2023-10-30 00:00:00 | 12
2023-11-06 00:00:00 | 13
2023-11-13 00:00:00 | 14
2023-11-20 00:00:00 | 15
2023-11-27 00:00:00 | 16
2023-12-04 00:00:00 | 17
2023-12-11 00:00:00 | 18
2023-12-18 00:00:00 | 19
2023-12-25 00:00:00 | 20
2024-01-01 00:00:00 | 21
2024-01-08 00:00:00 | 22
2024-01-15 00:00:00 | 23
2024-01-22 00:00:00 | 24
2024-01-29 00:00:00 | 25
2024-02-05 00:00:00 | 26
2024-02-12 00:00:00 | 27
2024-02-19 00:00:00 | 28
2024-02-26 00:00:00 | 29
2024-03-04 00:00:00 | 30
2024-03-11 00:00:00 | 31
2024-03-18 00:00:00 | 32
2024-03-25 00:00:00 | 33
2024-04-01 00:00:00 | 34
2024-04-08 00:00:00 | 35
2024-04-15 00:00:00 | 36
2024-04-22 00:00:00 | 37
2024-04-29 00:00:00 | 38
2024-05-06 00:00:00 | 39
2024-05-13 00:00:00 | 40
2024-05-20 00:00:00 | 41
2024-05-27 00:00:00 | 42
2024-06-03 00:00:00 | 43
2024-06-10 00:00:00 | 44
2024-06-17 00:00:00 | 45
2024-06-24 00:00:00 | 46
2024-07-01 00:00:00 | 47
2024-07-08 00:00:00 | 48
2024-07-15 00:00:00 | 49
2024-07-22 00:00:00 | 50
2024-07-29 00:00:00 | 51
2024-08-05 00:00:00 | 52
2024-08-12 00:00:00 | 53
Spreadsheet: 113761d1309572208-how-to-graph-stacked-bar-with-special-criteria-see-enclosures-graph-stacked-bar
Sheet: Sheet1

Date | Cap1 | Cap2 | Total_Capacity
2010-05-01 00:00:00 | 7425 | 7871 | 16506
2010-06-01 00:00:00 | 5187 | 5999 | 17212
2010-07-01 00:00:00 | 4343 | 3960 | 17212
2010-08-01 00:00:00 | 10263 | 5203 | 23220
2010-09-01 00:00:00 | 5686 | 3782 | 23220
2010-10-01 00:00:00 | 6641 | 5091 | 21330
2010-11-01 00:00:00 | 7218 | 5299 | 21330
2010-12-01 00:00:00 | 10608 | 6280 | 21330
2011-01-01 00:00:00 | 7242 | 6015 | 22176
2011-02-01 00:00:00 | 3745 | 8215 | 22680
2011-03-01 00:00:00 | 5641 | 4731 | 22680
2011-04-01 00:00:00 | 6311 | 7524 | 22680
2011-05-31 00:00:00 | 19818 | 6647 | 25056
Spreadsheet: 15da2ede-640a-4515-9ac5-d4681d2db4af
Sheet: Submissions

Repository Submission Tracking [TEMPLATE - WITH EXAMPLES]
***Please see the "IRB Help Sheet - Repositories:  [NAME] and Releases" for additional information about this template.***
Date of Submission | Source of Data/Specimens | Description of Data/Specimens | Study Status | Individually Identifiable? | Consent and Authorization Methods | Submittal Agreement Signed
[EXAMPLE 1] 5/16/2010 | [NAME] (OHSU) - IRB #s 5678, 1234, 5432 | Blood and Tumor Tissue from prior subjects in breast cancer studies | 5678 -Terminated 1234 - Terminated 5432 - Active | Yes - coded, repository has access to identifiers | Consent to storage and future research on CANCER ONLY.  Authorization to store in repository. | 2010-05-14 00:00:00
[EXAMPLE 2] 6/2/2010 | University of Washington [Title] | Blood samples from relatives of breast cancer patients | Closed to Enrollment | No | Consent/authorization silent on storage/future research.  Not identifiable, no waivers needed. | 2010-06-01 00:00:00
[Example 3] 7/7/2010 | OHSU Clinical Records | Data on treatment of bacterial infections in immunocompromised breast cancer patients | N/A - clinical records | Yes - repository will code | OHSU IRB approved waiver of consent/auth on 7/1/2010. | N/A - data collected by repository investigators
Spreadsheet: 132423d1323748295-running-total-including-null-values-null-example
Sheet: Sheet1

A1 = Total Charge | B1 = First Allowance (Manual entry) | C1 = Second Allowance (Manual entry) | D1 = Third Allowance (Manual  entry)
 | B2 = First Savings (A1 - B1) | C2 = 2nd Savings (If C1 = Null  then B1 - B1) | D2 = 3rd Savings (IF B1 and/C1 = Null then use value from A1 or last Line 1 value > 0
All Numbers have a value
500 | Null | 250 | 100 | 1
Null Examples
500 | NULL | 250 | 250 | 2
500 | NULL | NULL | 400 | 3
500 | 300 | NULL | 250 | 4
Example 1 500 - 300 = 200. 300 - 250 = 50 and 250 - 100 = 150. Total savings = 200 + 50 + 150 = 400.  [NAME] to maintain value when there is no entry for B1 but entry for C1 and D1. Logic 500 - 250 = 250 where C1 knows to start with a value = 500 from A1 not Null  Examples 3 - 4 are simply other Null examples using starting subtotals not = Total Charge
Spreadsheet: 28983d1223576651-percentages-and-percentage-totals-across-sheets-addpercents
Sheet: Sheet1

 |  |  | DAYS ALLOC | DAYS ELAPS | % COMPLETE
 | PROJ1 | TASK1 | 90 | 70 | 77.77777777777777
 | PROJ1 | TASK2 | 150 | 110 | 73.33333333333333
 | PROJ2 | TASK3 | 80 | 40 | 50
 | PROJ2 | TASK4 | 70 | 30 | 42.85714285714285
 | PROJ2 | TASK5 | 60 | 25 | 41.66666666666666
 | PROJ1 |  |  |  | 75.55555555555554
 | PROJ2 |  |  |  | 44.84126984126984
 | PROGRAMME |  |  |  | 60.1984126984127
Spreadsheet: 113540d1309419455-excel-2007-how-to-detech-wrong-ve-sign-appear-infront-of-figure-with-link-to-master-list-need-help
Sheet: Question

No | Name | Codes | Name | Amount
1 | [NAME] | 1245 | Housing Allowance | 2000
2 | [NAME] | 1589 | Transport Allowance | -2000
3 | [NAME] | 1238 | Mobile Allowance | 2000
4 | [NAME] | 1423 | Meal Allowance | 2000
5 | Kent | 1841 | Absence Deduction | 2000
6 | Vivian | 1256 | Penalty | -2000
7 | Helen | 1258 | Transport Deduction | -2000
8 | [NAME] | 1236 | Leave Deduction | -2000
 | Remarks :
 | Additional Payment - figure without -ve
 | Deduction Payment  - figure with -ve
 | Question
 | Which formula can apply to detect that is wrong -ve sign appear infornt of figure with link to master list
 | Example : no 2. [NAME] should be no have -ve sign
 | no 5. kent - should be have -ve sign
Spreadsheet: 59291d1259779573-combining-several-columns-of-data-example-1-
Sheet: Sheet 1

What I have
 | A | A |  | B | B |  | C | C
ID | Used | Free | ID | Used | Free | ID | Used | Free
Example 1 | 0 | 1 | Example 1 | 1 | 0 | Example 1 | 1 | 0
Example 2 | 11 | 21 | Example 2 | 1 | 0 | Example3 | 1 | 0
Example 4 | 1 | 2 |  |  |  | Example 4 | 3 | 3
 |  |  |  |  |  |  |  |  | What a Pivot Table Could do for You
What I would Like |  |  |  |  |  |  |  |  |  | Column Labels
 | A | A | B | B | C | C |  |  |  | A |  | B |  | C
ID | Used | Free | Used | Free | Used | Free |  |  | Row Labels | Used | Free | Used | Free | Used | Free
Example 1 | 0 | 1 | 1 | 0 | 1 | 0 |  |  | Example 1 | 0 | 1 | 1 | 0 | 1 | 0
Example 2 | 11 | 21 | 1 | 0 |  |  |  |  | Example 2 | 11 | 21 | 1 | 0
Example3 |  |  |  |  | 1 | 0 |  |  | Example 3 |  |  |  |  | 1 | 0
Example 4 | 1 | 2 |  |  | 3 | 3 |  |  | Example 4 | 1 | 2 |  |  | 3 | 3
What you should start with
ID | Used | Free | Letter
Example 1 | 0 | 1 | A
Example 2 | 11 | 21 | A
Example 4 | 1 | 2 | A
Example 1 | 1 | 0 | B
Example 2 | 1 | 0 | B
Example 1 | 1 | 0 | C
Example 3 | 1 | 0 | C
Example 4 | 3 | 3 | C
Spreadsheet: 02fe2df1-1ab6-493a-a3d1-ae9d32c16d79
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 474 |  | <100 |  |  |  | 474
 | Europe |  |  | 784930 |  |  | 85183 |  |  | 870113
 | North America | 104687 | 767612 | 17060 | 8752 | 23157 | 912 | 113439 | 790769 | 17972
Index | Asia | 3545 | 89642 | 187151 | 284 | 8059 | 35528 | 3829 | 97701 | 221496
 | Europe |  |  | 2689187 |  |  | 627221 |  |  | 3047766
 | North America | 274483 | 1418075 | 206488 | 123326 | 618381 | 34192 | 325291 | 1647058 | 240679
TOTAL |  | 382715 | 2275329 | 3885290 | 132362 | 649597 | 783036 | 442559 | 2535528 | 4398500
Estimated gross notional amount outstanding, December 28 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 829904d1684518985-delete-duplicates-based-on-multiple-criteria-s666-pq-delete-duplicates-based-on-multiple-criteria
Sheet: Sheet1

Total | Invoice Business Unit | Project Number |  |  |  | Total | Invoice Business Unit | Project Number
0 | Department A | Customer 1234 |  | 1 |  | 0 | Department A | Customer 1234
0 | Department A | Customer 1234 |  | 2 |  | 0 | Department B | Customer 1234
0 | Department A | Customer 1234 |  | 3 |  | 89 | Department B | Customer 2345
0 | Department B | Customer 1234 |  | 4 |  | 89 | Department C | Customer 0812
0 | Department A | Customer 1234 |  | 5 |  | 0 | Department D | Customer 0812
0 | Department B | Customer 2345 |  | 6
89 | Department B | Customer 2345 |  | 7
89 | Department C | Customer 0812 |  | 8
0 | Department D | Customer 0812 |  | 9
0 | Department C | Customer 0812 |  | 10
0 | Department D | Customer 0812 |  | 11
Spreadsheet: 105818d1303117294-display-data-from-1-sheet-to-another-sheet-automatically-sample-1000-
Sheet: beverley

Beverley
2:10  Beverley | Beverley | Flat | 0 | 0
2:40  [NAME] | Beverley | Flat | 0 | 0
3:10  [NAME] | Beverley | Flat | 0 | 0
3:40  Beverley | Beverley | Flat | 0 | -100
[NAME] | Beverley | Flat | 125 | -100
4:40  [NAME] | Beverley | Flat | 0 | 0
5:10  Beverley | Beverley | Flat | 0 | 0