tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220395d1363142057-formula-that-will-address-the-changes-in-each-cell-reflected-on-bottom-of-worksheet-march-fuel-summary
Sheet: Sheet1

DATE | START F.O.B | USED | TRANSFERS | RCV'D | ENDING F.O.B | L.O.B | USED | FROM/TO
2013-03-01 00:00:00 | 100822 | 200 |  |  | 100622 | 1973 | 1
2013-03-02 00:00:00 | 100622 | 5500 |  |  | 95122 | 1972 | 10
2013-03-03 00:00:00 | 95122 | 200 | 10102 |  | 84820 | 1962 | 21 | B-285
2013-03-04 00:00:00 | 84820 | 2960 |  | 30000 | 111860 | 1941 | 31 | [NAME]
2013-03-05 00:00:00 | 111860 | 5520 |  |  | 106340 | 1910 | 40
2013-03-06 00:00:00 | 106340 | 3860 |  |  | 102480 | 1870 | 40
2013-03-07 00:00:00 | 102480 | 200 |  |  | 102280 | 1830 | 25
2013-03-08 00:00:00 | 102280 | 3120 |  |  | 99160 | 1805 | 35
2013-03-09 00:00:00 | 99160 | 200 |  |  | 98960 | 1770 | 41
2013-03-10 00:00:00 | 98960 | 2950 |  |  | 96010 | 1729 | 1
2013-03-11 00:00:00 | 96010 | 200 |  |  | 95810 | 1728 | 1
2013-03-12 00:00:00 | 95810 | 2720 |  |  | 93090 | 1727 | 21
2013-03-13 00:00:00 | 93090 |  |  |  | 93090 | 1706
2013-03-14 00:00:00 |  |  |  |  | 0
2013-03-15 00:00:00 |  |  |  |  | 0
2013-03-16 00:00:00 |  |  |  |  | 0
2013-03-17 00:00:00 |  |  |  |  | 0
2013-03-18 00:00:00 |  |  |  |  | 0
2013-03-19 00:00:00 |  |  |  |  | 0
2013-03-20 00:00:00 |  |  |  |  | 0
2013-03-21 00:00:00 |  |  |  |  | 0
2013-03-22 00:00:00 |  |  |  |  | 0
2013-03-23 00:00:00 |  |  |  |  | 0
2013-03-24 00:00:00 |  |  |  |  | 0
2013-03-25 00:00:00 |  |  |  |  | 0
2013-03-26 00:00:00 |  |  |  |  | 0
2013-03-27 00:00:00 |  |  |  |  | 0
2013-03-28 00:00:00 |  |  |  |  | 0
2013-03-29 00:00:00 |  |  |  |  | 0
2013-03-30 00:00:00 |  |  |  |  | 0
2013-03-31 00:00:00 |  |  |  |  | 0
Totals | 1287376 | 27630 | 10102 | 30000 |  |  | 267
 | START F.O.B | USED | TRANSFERS | RCV'D | ENDING F.O.B | L.O.B. | USED
Spreadsheet: 114852d1310555840-remove-duplicates-then-sumif-with-only-formula-first-and-second-thoughts
Sheet: Sheet1

things | things 2 | count | first thought |  |  | second thought
A | X | 7 | A X | 1 | 30 | 1 | 30
B | Y | 10 | B Y | 1 |  | 1
C | Z | 8 | C Z | 1 |  | 1
C | Z | 8 | C Z | 2 |  | 2
B | Y | 10 | B Y | 2 |  | 2
B | W | 20 | B W | 1 |  | 1
C | Y | 10 | C Y | 1 |  | 1
Spreadsheet: sally_beck__34340__2002 Budget Edie Format
Sheet: East Power Admins

 | East Power Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 2
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 200034d1355395851-a-better-pivot-table-a-better-pivot_solution
Sheet: Pivot

Page1 | (All)
Sum of Value | Column
Row | 2011 | 2012 | $ Growth | % Growth | 2012 % Contribution | 2013 Model Quota | [NAME] | SDM Adjust | Grand Total
[NAME] | 893484 | 1012414 | -15160.66188737085 | -0.0346380024351608 | 0.484183823400715 | 997253.3381126293 | 997253.3381126293 | 0 | 3885244.463883708
[NAME] | 40464 | 66728 | 3540.178662918763 | -0.05091510049971659 | 0.02201769675018257 | 70268.17866291877 | 70268.17866291877 | 0 | 251268.5070913526
[NAME] | 430781 | 548813 | 68446.01689544343 | 0.1504256310462144 | 0.1645148516262781 | 617259.0168954434 | 617259.0168954434 | 0 | 2282558.365626813
[NAME] | 1081166 | 1260688 | 10836.36938598094 | -0.03463800243516091 | 0.5119161634767978 | 1271524.369385981 | 1271524.369385981 | 0 | 4895739.585436104
[NAME] | 497566 | 537930 | 57982.63895133039 | -0.03463800243516102 | 0.1868969702401809 | 595912.6389513303 | 595912.6389513303 | 0 | 2285304.069112959
KatieCantlon | 513611 | 509846 | 51863.84415983206 | -0.03463800243516102 | 0.2337869751940889 | 561709.8441598321 | 561709.8441598321 | 0 | 2198740.731628469
[NAME] | 949804.36 | 962410 | 18531.96738243246 | -0.0346380024351608 | 0.5201243643880507 | 980941.9673824324 | 980941.9673824324 | 0 | 3892630.747633659
[NAME] | 722837 | 931328 | 31655.41995982022 | -0.03463800243516058 | 0.5379848570526649 | 962983.4199598202 | 962983.4199598202 | 0 | 3611787.763226315
[NAME] | 367078.8 | 340335 | 23408.85817365481 | -0.03463800243516091 | 0.1344109442760337 | 363743.8581736548 | 363743.8581736548 | 0 | 1458310.474293906
[NAME] | 407479 | 602984 | 75807.47357855158 | -0.03463800243516091 | 0.1742875368861362 | 678791.4735785517 | 678791.4735785517 | 0 | 2443853.560385189
[NAME] | 166413 | 132508 | 17139.24474840632 | -0.05091510049971659 | 0.02987581670887134 | 149647.2447484063 | 149647.2447484063 | 0 | 615354.7132059352
Grand Total | 6070684.16 | 6905984 | 344051.3500110002 | -0.2285085894345057 | 3 | 7250035.350011 | 7250035.350011 | 0 | 27820792.98152441
Spreadsheet: 81414d1281609631-adding-a-computed-column-at-end-for-a-growing-list-using-fn-no-macros-example12
Sheet: Sheet1

StudentName | Marks1 | Marks2 | Marks3 | Marks4 | Marks5 | Marks6 |  | Total
Roshan | 10 | 10 | 10 | 10 | 10 | 10 |  | Average | 30 | 35 | 40 | 45 | 52 | 60
mark | 1 | 1 | 1 | 1 | 1 | 1 |  | Percentage | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.8
[NAME] | 10 | 10 | 10 | 10 | 10 | 10
pete | 20 | 20 | 20 | 20 | 20 | 20
jai | 35 | 36 | 37 | 38 | 39 | 40
No macros
The student list might increase in future but I need to place the "total ","Average" ,"Percentage"that entire row at the end of the last student
without using macro and everything has to be achieved in the same sheet
Spreadsheet: 204390d1357491666-general-database-problems-to-make-it-more-user-friendly-excel-practice
Sheet: Sheet1

Student ID | Surname | Initial | Age | Program | Building | Classroom
ST348-245 | [NAME] | L. | 18 | English
ST348-246 | Wilson | R. | 23 | Business
ST348-247 | [NAME] | J. | 18 | Chemistry
ST348-248 | Smith | K. | 20 | Chemistry
ST348-249 | [NAME] | B. | 21 | Business
ST348-250 | [NAME] | K. | 26 | Biology
ST348-251 | [NAME] | N. | 18 | Maths
ST348-252 | [NAME] | C. | 19 | English
ST348-253 | Bettison | M. | 20 | English
ST348-254 | Martins | J. | 22 | Physics
Spreadsheet: eric_saibi__9878__102201R
Sheet: Hammond 02

Owner Name |  | Georgia Power Company
Station Name |  | Hammond Power Station
Unit Name |  | Hammond 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Coal
Capacity |  | 125 MW
Start Date |  | 2001-10-19 00:00:00
End Date |  | 2001-12-09 00:00:00
Prv. Start Date |  | 2001-09-22 00:00:00
Prv. End Date |  | 2001-10-01 00:00:00
Comments |  | Boiler/Burner
SIC |  | 4911
Plant ID |  | 1516000
Unit ID |  | 1004514
Outage ID |  | 8710
Spreadsheet: 17205601-1dcd-43ab-95cb-f6bacc6761f5
Sheet: PPI 003

Permit No.: |  | WQ0017635 |  | Facility Name: |  | Martin Marietta Quarry & Mackilwean T.F. |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
PPI: |  | 003 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
[NAME]. Limit:
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: larry_campbell__20968__Flagstaff Calcs
Sheet: Example

[NAME]
RED ROCK EXPANSION PROJECT
FLAGSTAFF COMPRESSOR STATION
Table 6
EXAMPLE EMISSION CALCULATIONS
GE LM2500 TURBINE
[NAME]
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
CO Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
VOC Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 0oF x 10% NMHC x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Particulate Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 6.6E-3 lb/MMBtu x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
SO2 Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 3.4E-3 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Formaldehyde Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 7.1E-4 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1007

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: richard_ring__31586__newEnronEgyPECOChoice
Sheet: Active

N102 (8R) | REF02 (12) | REF02 (PR) | REF02 (NH) | REF02 (LO) |  | REF03 | REF02 (TZ) | DTM02 (150) | AMT02 (MA) | AMT02 (KC) | AMT02 (KZ) | REF03 (SPL) | REF02 (11)
 |  | Rate | Rate |  |  | [NAME] | [NAME] | Start | Peak
Customer Name | Account No. | Class | Code | Strata | Rate Code Description | Type | Cycle | Date | Dmd | [NAME] Obl. | Trx Obl. | [NAME] | Enron Acct #
[NAME] | 231172239726 | GS | CM | 6 |  | Mo | 11 | 1999-04-16 00:00:00 | 48 | 27.3 | 27.3 | RICH PE | 41350002
HOLLYWOOD OIL CO | 400708742517 | GS | CM | 4 | Commercial measured | Mo |  | 1999-01-12 00:00:00 | 18.5 | 13 | 13 | BYBERRY | 41060002
CHELTENHAM SHOPPING | 040180742601001 | PD | PD | 57 | Primary Distribution Power | Mo |  | 1999-02-26 00:00:00 | 525.8 | 415.4 | 415.4 | CEDARBRO | 41150002
CHELTENHAM SHOPPING | 401807861018 | GS | C | 9 | Commercial - no demand | Mo |  | 1999-01-28 00:00:00 | 8.2 | 2 | 2 | MIDD PE | 41000002
TETRATEC CORP | 045103859151201 | GS | GS | 6 | General Service | Mo |  | 1999-01-15 00:00:00 | 390.5 | 356 | 356 | BYBERRY | 41030002
SDG MACERICH PROPERT | 502011678526 | GS | CH7 | 5 | Commercial Heat - Demand Forgiveness | Mo |  | 1999-02-01 00:00:00 | 34.1 | 19 | 19 | MIDD PE | 41020002
SUBURBAN AIR SPIRAL | 401570029512 | GS | CM | 4 |  | Mo | 15 | 2000-01-22 00:00:00 | 21.5 | 20 | 19.86 | PECO-ZONE | 41470002
WILLARD INC. | 450153081994 | GS | CM | 6 |  | Mo | 01 | 2000-02-02 00:00:00 | 57 | 33.47 | 33.26 | PECO-ZONE | 41480002
AMERICAN COLLEGE | 050219305101301 | HT | HT | 056 |  | Hr | 21 | 2000-02-01 00:00:00 | 867.6 | 889.7 | 865.73 | PECO-ZONE | 41500002
UNIVERSAL MACHINE CO | 4013046733312 | GS | CM | 6 |  | Mo | 13 | 2000-02-18 00:00:00 | 285.3 | 255.79 | 279.5 | PECO-ZONE | 41510002
WILLIARD INC | 040059308001501 | PD | PD | 60 |  | Mo | 05 | 2000-03-09 00:00:00 | 316 | 289.26 | 316.08 | PECO-ZONE | 41520002
LEHIGH VALLEY DAIRIES | [PHONE] | EO | POL | 73 |  | UM |  | 2000-06-02 00:00:00 |  |  |  | PECO-ZONE | 41530002
LEHIGH VALLEY DAIRIES | 040219321001801 | HT | HT | 53 |  | Hr | 21 | 2000-07-01 00:00:00 | 2876.8 | 2494.67 | 2725.96 | PECO-ZONE | 41540002
PRUDENTIAL INS CO AMER | 040089206001501 | HT | HT | 54 |  | Hr | 08 | 2000-07-13 00:00:00 | 5507.6 | 4924.31 | 5380.87 | PECO-ZONE | 41550002
Spreadsheet: 781478d1653368417-sumproduct-by-month-year-with-an-if-function-sumproduct
Sheet: Example

DEADLINE | DEPOSIT | FULL AMOUNT
2022-02-22 00:00:00 | 90000 |  |  | Feb22 | [NAME] | Apr22 | May22
2022-02-22 00:00:00 | 19440 | 21615
2022-03-15 00:00:00 | 556255 | 618015
2022-03-30 00:00:00 | 64601 | 69046 |  | I want the sum amount of column B per month&year but when the Full amount column (C) is blank/has no value, to be ignored and not calculate in the sum
2022-04-08 00:00:00 | 114800 | 126015 |  | Therefore I want the formula to give me the amount of 19440 for February2022.
2022-04-20 00:00:00 | 36361 | 40416
2022-04-20 00:00:00 | 3385 | 3776
2022-04-20 00:00:00 | 1297 | 1446
2022-04-20 00:00:00 | 443 | 466
2022-04-22 00:00:00 | 11880 | 13015
2022-04-27 00:00:00 | 52200 | 58015
2022-05-03 00:00:00 | 173520 | 192815
2022-05-03 00:00:00 | 46950 | 51165
2022-05-03 00:00:00 | 105480 | 117215
2022-05-05 00:00:00 | 19440 | 21615
2022-05-05 00:00:00 | 46850 | 52015
2022-05-05 00:00:00 | 46000 | 51115
2022-05-10 00:00:00 | 45365 | 50420
2022-05-10 00:00:00 | 64300 | 70000
2022-05-10 00:00:00 | 86160 | 900000
2022-05-10 00:00:00 | 188600 | 250000
2022-05-10 00:00:00 | 450001 | 475000
2022-05-18 00:00:00 | 55800 | 59000
Spreadsheet: 2ceed179-2dd2-465c-be8a-613ee66ce60f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Compositions from 1955 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ref | Got Y/N | [NAME] | [NAME] | Year | Title of Piece | Information | Piano | BB | WB | Country | CD Source
 |  | Part 6
FLOR A01 | Y | [NAME], [NAME] |  | 2001 | Aubade |  | y | y |  | UK | [NAME]
FLOR B01 | Y | [NAME], [NAME] |  | 2011 | Bone Apart |  | y | y |  | UK | [NAME]
FLOR B02 | Y | [NAME], [NAME] |  | 1992 | Ballade & Spanish Dance |  | y | y |  | UK | WOT 2
FLOR B03 | Y | Wiffin, [NAME] |  | 2008 | Blue Jeans |  | y | y |  | UK | WOT 2
FLOR C01 | y | Sparke, [NAME] |  | 2010 | Cappricio |  | y | y |  | UK | Summon the [NAME]
FLOR C02 | Y | Wilby, [NAME] |  | 2011 | [NAME] |  | y |  |  | UK | Boneman walking
FLOR C03 | Y | Wiggins, [NAME] |  | 1995 | Caprice for trombone |  | y | y |  | UK | [NAME]
FLOR C04 | Y | Monti, [NAME] |  | 2008 | Czardas |  | y | y |  | UK | WOT 2
FLOR C05 | Y | Leidzen [NAME] |  | 1975 | Concertino |  | y | y |  | UK | Bakers Dozen
FLOR D01 | Y | Donizetti | Kappey, J A. | 1960 | Divertissement on Melodies from Linda di Chamonix
FLOR D02 | Y | Newton, [NAME] |  | 1999 | [NAME] to York |  | y | y |  |  | Phenomenon
FLOR F01 | Y | Moren, Bertrand |  | 2000 | The Flying Slide |  | y | y |  | Swiss
FLOR H01 | Y | [NAME], [NAME] |  | 2009 | Hellas |  | y |  |  | UK
FLOR O01 | Y | Newsome, [NAME] |  | 1987 | Oberland Variations |  | y | y |  | UK | [NAME]
FLOR M01 | Y | Cimera, [NAME] |  | 1957 | [NAME] |  | y |  |  | USA
FLOR N01 | Y | Bourgeous, Derek |  | 2008 | Nightmare for Trombone |  | y | y |  | UK | Rathamataz
FLOR R01 | Y | Fitzpatrick, [NAME] |  | 2007 | Rhapsody for trombone | commission | y | y |  | AUS | Southern Cross
FLOR R02 | Y | Richards, [NAME] |  | 1981 | Rhumba |  | y | y |  | UK
FLOR R03 | Y | Langford, [NAME] |  | 1975 | Rhapsody for trombone |  | y | y |  | UK | Bone Idyll
FLOR P01 | Y | Newton Rodney |  | 1999 | Phantasm |  | y | y |  | UK | Phenonenon
FLOR P02 | Y | [NAME], Darrol |  | 2008 | Phantasy |  | y |  |  | UK | wot 2
FLOR S01 | Y | Harper, [NAME] |  | 2010 | Salsa Panadero |  | y |  |  | UK | Boneman Walking
FLOR S02 | Y | [NAME], [NAME] |  | 1980 | Suite for Trombone |  | y | y |  | UK | Southern Cross
FLOR S03 | Y | Woodfield, [NAME] |  |  | Slightly Sentimental |  | y
FLOR T01 | Y | Newsome, [NAME] |  | 1972 | Tenor [NAME] |  | y | y |  | UK
FLOR W01 | Y | Wilby, [NAME] |  | 1996 | White Knuckle Ride |  | y | y |  | UK | Rathamataz
Spreadsheet: 128639d1321139886-unhide-column-s-and-p-expanded-pivot
Sheet: Weekly

TC | (PIVOT - BC) + PIVOT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | VAH | VaL | VA Range | mean CPR | std CPR | mean +1 | mean     -1/2
Pivot | (H+L+C)/3 | Date | H | L | C | Range | Close | Open #F=2 | PIVOT | BC | TC | Prange | R1 | R2 | R3 | R4 | S1 | S2 | S3 | [NAME]
BC | (H+L)/2 | 2011-10-31 00:00:00 | 1280.75 | 1208.5 | 1251 |  |  | 1266.5
 |  | 2011-11-11 00:00:00 | 1275.25 | 1218.25 | 1261.5 |  |  | 1249
R4 | R3 + (R2-R1)
R3 | R1+(H-L)
R2 | PIVOT + (H-L)
R1 | 2 X PIVOT - LOW
S1 | 2 X PIVOT - HIGH
S2 | PIVOT - (HIGH - LOW)
S3 | S1 - (HIGH - LOW)
[NAME] | S3 - (S1 - S2)
Spreadsheet: 174330d1345025332-vlookup-with-drop-down-functionality-vlookup-with-a-drop-down-menu
Sheet: Actual

 |  | 2011 | 2011 | 2011 | 2011 | 2012 | 2012 | 2012 | 2012
Product |  | Jan | Feb | Mar | Apr | Jan | Feb | Mar | Apr
Product A | Actual Units | 10 | 20 | 30 | 50 | 65 | 75 | 45 | 85
Product B | Actual Units | 22 | 55 | 99 | 77 | 88 | 45 | 65 | 65
Product C | Actual Units | 22 | 44 | 55 | 45 | 88 | 99 | 66 | 66
Product D | Actual Units | 65 | 23 | 65 | 44 | 55 | 89 | 76 | 23
Product A | Actual Value | 235 | 235 | 654 | 5689 | 789 | 546 | 888 | 457
Product B | Actual Value | 1235 | 5647 | 1365 | 1235 | 456 | 564 | 1235 | 125
Product C | Actual Value | 1254 | 4567 | 566 | 5467 | 568 | 569 | 5632 | 125
Product D | Actual Value | 2223 | 4569 | 4567 | 887 | 1299 | 1256 | 1245 | 1254
Spreadsheet: 297840d1392625128-issue-with-solver-solver
Sheet: Sheet1

21150 | 0 | -916234.3000000007 |  |  |  | 43123 | 1 | -1622639.779999999
65467.25 | 0 |  |  |  |  | 84758.75 | 1
127406.25 | 0 |  |  |  |  | 111188 | 1
161639.53 | 0 |  |  |  |  | 118110 | 1
180016.25 | 0 |  |  |  |  | 140019.5 | 1
430296.75 | 0 |  |  |  |  | 141236.24 | 1
437695 | 0 |  |  |  |  | 411276.5 | 1
1028108 | 0 |  |  |  |  | 607640 | 1
1496043.25 | 0 |  |  |  |  | 1870877 | 1
8371345 | 0 |  |  |  |  | -88303 | 0
-50 | 0 |  |  |  |  | -106648.75 | 1
-12722.38 | 0 |  |  |  |  | -168775.11 | 1
-33264.46 | 0 |  |  |  |  | -684223.5 | 1
-44700 | 0 |  |  |  |  | -1458526 | 0
-86112.25 | 0 |  |  |  |  | -1857152.95 | 1
-119106.75 | 0 |  |  |  |  | -2334068.46 | 1
-190124 | 0
-225991 | 0
-634461.5 | 0
-666782 | 0
-1041289.25 | 0
-1900189.83 | 0
-2000000 | 0
-5578666.75 | 0
Spreadsheet: 214753d1361108459-recognize-and-convert-dolar-to-real-parttwo-mareeco-oeldere-
Sheet: Plan1

 |  | Dolar's Day |  | 1.96
 | Código | Descrição |  |  | Quantidade |  | Valor | Quantidade | Total Converted to Real | Correct Result
 | C00542 | [NAME] 1N4007 | R$ | 0.1 | 1 |  | 0.1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | pc
 | C00543 | [NAME] 1N4148 | $ | 0.15 | 2 |  | 0.15 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | pc
 | C01568 | RESISTOR CR25 3R3 | $ | 0.15 | 1 |  | 0.15 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01166 |  |  |  |  | 2 |  | pc |  | 0.02332
 | C02268 | [NAME] ST | R$ | 0.25 | 1 |  | 0.25 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | pc
Spreadsheet: 85081d1285153273-count-instances-of-a-value-across-multiple-sheets-book1
Sheet: Linc 456

Product | Type | Key
a | 1 | JHYU918-9187-088
b | 2 | JHYU918-9187-088
c | 3 | JHYU414-234H-876
d | 4 | JHYU414-234H-877
a | 1 | JHYU414-234H-878
b | 2 | JHYU414-234H-645
c | 3 | JHYU414-234H-646
d | 4 | JHYU414-234H-647
a | 5 | JHYU414-234H-648
b | 6 | JHYU414-234H-649
c | 7 | JHYU414-234H-650
d | 8 | JHYU414-234H-651
a | 9 | JHYU414-234H-652
b | 10 | JHYU414-234H-887
c | 11 | JHYU414-234H-888
d | 12 | JHYU918-9187-088
a | 13 | JHYU918-9187-088
c | 11 | JHYU414-234H-876
Spreadsheet: 870064d1716567512-rota-generator-rota-test-tommartin123-
Sheet: Sheet2

 |  | Name | Number of shifts per week | Random | 5 | 4 | 3 | 2 | [NAME]
 |  | [NAME] | 5
 |  | [NAME] | 5
 |  | [NAME] | 5
 |  | Anna | 5
 |  | Becci | 5
 |  | Benet | 5
 |  | Edita | 5
 |  | [NAME] | 2
 |  | Gemma | 2
 |  | [NAME] | 5
 |  | [NAME] | 2
 |  | Greeshma | 5
 |  | Hosni | 5
 |  | Isabel | 4
 |  | [NAME] | 5
 |  | Jimble | 5
 |  | [NAME] | 5
 |  | Joyal | 5
 |  | Jubna | 5
 |  | Maria | 5
 |  | [NAME] | 5
 |  | [NAME] | 3
 |  | Omotola | 5
 |  | [NAME] | 4
 |  | Vanese | 5
Spreadsheet: 327813d1403695157-exact-quantity-for-breakeven-exact-quantity-for-breakeven
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Total
Quantities | 5 | 4 | 3 | 2 | 1
Income | 500 | 400 | 500 | 300 | 200
Expenses | 200 | 100 | 300 | 150 | 100
Net income
 | Net Income
 | Investment | 300 | 900 | 600
 | .@Quantity | 5 |  | 9 | <------------ this is the result I want
Spreadsheet: 599308d1542963868-how-to-create-a-list-of-values-with-a-criteria-in-a-one-cell-using-formula-masterlist
Sheet: MasterList

Document Number | Submittal Number
AC-667003-1 | TR-0140
AB-544315-1 | TR-0195
AB-544315-1 | TR-0230
AA-7120030-1 | TR-0185
AA-544472-1 | TR-0245
AB-544310-1 | TR-0110
AB-611123-2 | TR-0245
AB-544319-1 | TR-0247
AB-321150-1 | TR-0245
Spreadsheet: 758255d1638788405-how-to-match-two-different-data-and-get-the-result-test
Sheet: Sheet1

 | Source |  |  |  |  |  |  | Result
Source 1 | Name | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 |  | Name | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00
 | Dhaka | 12 | 19 | 26 | 33 | 40 |  | Dhaka | False | True | True | True | True
 | Khulna | 13 | 11 | 9 | 19 | 21 |  | Khulna | False | True | True | True | True
 | [NAME] | 16 | 12 | 18 | 11 | 10 |  | [NAME] | False | False | False | False | False
Source 2 | Name | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00
 | Dhaka | 19 | 26 | 33 | 40 | 19
 | Khulna | 11 | 9 | 19 | 21 | 10
 | Rangpur | 12 | 18 | 11 | 10 | 21
Spreadsheet: 727744d1618068939-updating-index-function-mealplan-aligw
Sheet: Measurement Master List

 | Measurements master list
 | item | Column1 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 708637d1607958524-multiply-one-cell-by-multiple-criteria-depending-on-the-value-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Band starts at
 | 1 |  |  |  |  |  | 1 | 75
 | 2 |  |  |  |  |  | 7 | 100
 | 3 |  |  |  |  |  | 13 | 150
 | 4 |  |  |  |  |  | 19 | 200
 | 5
 | 6 |  |  |  |  |  |  |  | Date | Agent | Total Sales | Commission
 | 7 |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 7 | 700 | How do I get cells O8:O11 to multiply correctly so that 7 sales = $700 (7 sales means would be $100 per unit) and so on.
 | 8 |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 10 | 1000
 | 9 |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 13 | 1950
 | 10 |  |  |  |  |  |  |  | 12/14/2020 | [NAME] | 20 | 4000
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20