tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725060d1616514428-need-a-formula-to-help-with-an-order-form-pulling-through-correct-pricing-for-the-quantity-example-1-2-
Sheet: Sheet2

# | Item No. | Item Description | Flavour | [NAME] (kg) |  | MOQ | Price | MOQ | Price | MOQ | Price | MOQ | Price | MOQ | Price
45 | [NAME] | Cream of Rice | Chocolate Banana | 2 |  | 300 | 7.5 | 600 | 6.85 | 1000 | 6.8 | 1500 | 6.65 | 2000 | 6.5
46 | LRF046E | Cream of Rice | Strawberry-Cheesecake | 2 |  | 300 | 7.5 | 600 | 6.85 | 1000 | 6.8 | 1500 | 6.65 | 2000 | 6.5
47 | [NAME] | Cream of Rice | Apple Pie | 2 |  | 300 | 7.5 | 600 | 6.85 | 1000 | 6.8 | 1500 | 6.65 | 2000 | 6.5
 |  | [NAME] | 100 |  |  |  |  | 7.5 | 600 | 6.85 | 1000 | 6.8 | 1500 | 6.65 | 2000
 |  |  | 300 |  |  |  |  | 600 | 6.85 | 1000 | 6.8 | 1500 | 6.65 | 2000 | 6.5
 |  |  | 500
 |  |  | 700
 |  |  | 900
 |  |  | 1100
 |  |  | 1300
 |  |  | 1500
 |  |  | 1700
 |  |  | 1900
 |  |  | 2100
 |  |  | 2300
Spreadsheet: 787061d1657623050-formula-to-calculate-risk-2022-07-12-oeldere-joenuhbanana-formula-help
Sheet: Sheet1

With Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 | 2022-07-29 00:00:00 | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-09 00:00:00 | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 | 2022-09-03 00:00:00 | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 | 2022-08-24 00:00:00 | Risk of OOS
No Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 |  | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Will go OOS
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 |  | Will go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 |  | Will go OOS
Spreadsheet: 330109d1404542097-column-number-of-3-cell-containing-text-in-a-row-sample2
Sheet: Sheet1

is text
length
nth occurance
1
Column number with 3rd occurrennce of non-zero alphanumeric characters
 |  |  |  |  | [NAME]
 |  |  |  |  |  |  | a | f | 3d
 |  |  |  |  |  |  |  |  |  | t6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | h6 | 99 | uh
 |  |  |  |  |  |  |  |  | m | bgtr
I have (manually) highlighted the cells containing the 3rd non-zero value...
This is an ARRAY FORMULA (CTRL+SHIFT+ENTER to set).
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Dec

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
December | Dates of leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
December Total
Spreadsheet: louise_kitchen__23044__CFs by Industry and Erating Update
Sheet: Summary Average Term

Total Wholesale Cash Flows excluding Prepays
 |  |  | Weighted Average Term
 | Energy Marketers |  | (in months)
Net CF | -334077429.3062399
Assets | 3663442786.862622 |  | 18.8816208722813
Liabilities | -3997520216.16886 |  | 23.17576050832499
 | Financial Institutions
Net CF | -554859975.532384
Assets | 1954356222.714518 |  | 37
Liabilities | -2509216198.2469 |  | 44
 | Gas & electric utilities
Net CF | 2823417936.892923
Assets | 4572726779.953126 |  | 51.46683311089593
Liabilities | -1749308843.0602 |  | 31.9544453358602
 | Independent power producers
Net CF | 20735672.33845999
Assets | 99621834.12535998 |  | 49.42690447631401
Liabilities | -78886161.78690001 |  | 27.8987597155157
 | Industrials
Net CF | -281627186.0325328
Assets | 1404818100.779671 |  | 23.13091317983429
Liabilities | -1686445286.812205 |  | 50.17670033534996
 | Oil and gas producers
Net CF | 620180796.6190102
Assets | 1136868032.76484 |  | 33.54949713085639
Liabilities | -516687236.1458296 |  | 10.11637590853003
 | Other
Net CF | 740984821.960018
Assets | 963029682.4036977 |  | 25.76366250496099
Liabilities | -222044860.4436799 |  | 31.75327543417006
 | Totals
Net CF
Assets
Liabilities
Spreadsheet: 739201d1625577079-if-formula-to-total-with-criteria-not-working-additonalhourssample
Sheet: Sheet1

 | With [NAME]
 | Contract | M-F | O/T Adj | Sat | SatAdj | TotalAdj | Total | Worked |  | The 2 gray are additional hours worked.
 | 37 |  |  |  |  |  |  |  |  | All 3 Adj columns and the Worked work!
 | 37 |  |  | 5 |  |  |  |  |  | The Total does not and will not whatever I do
 | 37
 | 37
 | 37 |  |  |  |  |  |  |  |  | It needs to be…
 | 37 |  |  |  |  |  |  |  |  | if contract = 37(fulltime) it is simply the 2 adj added together
 | 27 | 20 |  |  |  |  |  |  |  | if contract + hours worked <37, it is simply the adjusted hours
 |  |  |  |  |  |  |  |  |  | however if contract + hours worked >37, it is the extra hours worked above contract + the extra adj hours NOT INCLUDING THE HOURS ABOVE USED FOR THE ADJUSTMENT
 | Mockup with correct figures
 | Contract | M-F | O/T Adj | Sat | SatAdj | TotalAdj | Total | Worked
 | 37 | 5 |  | 5
 | 37 | 5
 | 36 | 3 |  | 3 |  |  | 8.5 |  |  | Yellow ones don't work
 | 36 | 3 |  |  |  |  | 4
 | 10 | 30 |  |  |  |  | 31.5
 | 10 | 10
 | 10
Spreadsheet: 224135d1364464679-help-with-spreadsheet-example
Sheet: YTD

 | Working Days
Office 1 | Day Sick | % | Office 2 | Day Sick | % | Office 3 | Day Sick | % | Office 4 | Day Sick | % | Office 5 | Day Sick | % | Office 6 | Day Sick | %
a1 |  |  | b1 |  |  | c1 |  |  | d1 |  |  | e1 |  |  | f1
a2 |  |  | b2 |  |  | c2 |  |  | d2 |  |  | e2 |  |  | f2
a3 |  |  | b3 |  |  | c3 |  |  | d3 |  |  | e3 |  |  | f3
a4 |  |  | b4 |  |  | c4 |  |  | d4 |  |  | e4 |  |  | f4
a5 |  |  | [NAME] |  |  | c5 |  |  | d5 |  |  | e5 |  |  | f5
a6 |  |  | b6 |  |  | c6 |  |  | d6 |  |  | e6 |  |  | f6
a7 |  |  | b7 |  |  | c7 |  |  | d7 |  |  | e7 |  |  | f7
[NAME] |  |  | b8 |  |  | c8 |  |  | d8 |  |  | e8 |  |  | f8
a9 |  |  | b9 |  |  | c9 |  |  | d9 |  |  | e9 |  |  | f9
a10 |  |  | b10 |  |  | c10 |  |  | d10 |  |  | e10 |  |  | f10
a11 |  |  | b11 |  |  | c11 |  |  | d11 |  |  | Total Days YTD | 0 |  | f11
a12 |  |  | b12 |  |  | c12 |  |  | d12 |  |  |  |  |  | Total Days YTD
a13 |  |  | b13 |  |  | c13 |  |  | d13
a14 |  |  | b14 |  |  | c14 |  |  | d14
a15 |  |  | b15 |  |  | c15 |  |  | d15
a16 |  |  | b16 |  |  | c16 |  |  | d16
a17 |  |  | b17 |  |  | c17 |  |  | d17
a18 |  |  | b18 |  |  | c18 |  |  | d18
a19 |  |  | b19 |  |  | c19 |  |  | d19
a20 |  |  | b20 |  |  | c20 |  |  | d20
Total Days YTD | 0 |  | Total Days YTD | 0 |  | Total Days YTD | 0 |  | Total Days YTD | 0
Spreadsheet: 71997d1272664771-copying-data-between-sheets-sample
Sheet: Selection

Staff 1 |  | First Floor Module 1A
Staff 2 |  | First Floor Module 1B
Staff 3 |  | Second Floor Module 2A
Staff 4 |  | Second [NAME] 2B
Staff 5 |  | Second Floor Module 2C
Staff 6 |  | Second Floor Module 2D
Staff 7 | First Floor Module 1B | Second Floor Module 2E
Staff 8 |  | Third Floor Module 3G
Staff 9 |  | Third Floor Module 3H
Staff 10 |  | Third Floor Module 3I
Staff 11 |  | Third Floor Module 3K
Staff 12 | Second Floor Module 2A
Staff 13
Staff 14
Staff 15
Staff 16
Staff 17
Staff 18
Staff 19 | Second Floor Module 2E
Staff 20
Staff 21
Staff 22
Staff 23 | Second Floor Module 2C
Staff 24
Staff 25
Staff 26
Staff 27 | Second Floor Module 2A
Staff 28
Staff 29
Staff 30
Staff 31
Staff 32
Staff 33
Staff 34
Staff 35
Staff 36
Staff 37
Staff 38
Staff 39
Staff 40
Staff 41 | Second Floor Module 2A
Staff 42
Staff 43 | Second Floor Module 2A
Staff 44
Staff 45
Staff 46
Staff 47
Staff 48
Staff 49
Staff 50
Staff 51
Staff 52
Staff 53 | Second Floor Module 2D
Staff 54
Staff 55
Staff 56
Staff 57
Staff 58
Staff 59 | Second Floor Module 2D
Staff 60
Staff 61
Staff 62
Staff 63
Staff 64
Staff 65
Staff 66
Staff 67
Staff 68
Staff 69
Staff 70
Staff 71
Staff 72
Staff 73
Staff 74
Staff 75
Staff 76
Staff 77
Staff 78
Staff 79 | Third Floor Module 3H
Staff 80
Staff 81
Staff 82
Staff 83
Staff 84
Staff 85
Staff 86
Staff 87
Staff 88
Staff 89 | Second [NAME] 2B
Staff 90
Staff 91 | Second Floor Module 2E
Staff 92
Staff 93
Staff 94
Staff 95 | Second Floor Module 2D
Staff 96
Staff 97 | Second Floor Module 2A
Staff 98
Staff 99 | Second Floor Module 2A
Spreadsheet: 544139d1508774453-problem-with-solver-cant-find-a-feasible-solution-kopia-solver-error
Sheet: Blad2

 | Probabilities |  |  | Total probability | sorted Probability |  |  | sorted description
Game | HomeWin | Draw | AwayWin | Sum
Game 1 | 44.599 | 22.881 | 32.52
Game 2 | 34.139 | 28.943 | 36.91799999999999
Game 3 | 6.474 | 21.003 | 72.523
Game 4 | 92.483 | 5.496 | 2.020999999999995 |  |  |  |  |  |  |  | System
Game 5 | 87.922 | 10.412 | 1.666000000000002 |  |  |  |  |  |  |  | 1^= | 2
Game 6 | 20.619 | 21.652 | 57.729 |  |  |  |  |  |  |  | 2^= | 6
Game 7 | 37.786 | 21.191 | 41.023 |  |  |  |  |  |  |  | 3^= | 5
Game 8 | 51.806 | 19.637 | 28.557
Game 9 | 59.603 | 30.786 | 9.610999999999997
Game 10 | 43.626 | 24 | 32.374
Game 11 | 62.876 | 24.141 | 12.983
Game 12 | 58.68 | 25.476 | 15.844
Game 13 | 48.792 | 23.404 | 27.804
 |  |  | Solver:
 |  |  | Find max value of E15
 |  |  | I3:K15 has to be binary
 |  |  | L16 should be equal to L17<--- fails constraint, how?
Spreadsheet: 40550d1238890839-istext-behaviour-recognition-istext
Sheet: Sheet1

4
3
2
6
5
8
0
n
2
3
4
1
5
67
8
9
6
5
4
3
#N/A | <--- formula here
Spreadsheet: 217818d1362204232-issue-with-rate-function-aaslezak
Sheet: Sheet1

Coupon | 0.14 |  | Coupon | 0.14
Par | 100 |  | FV
N | 2 |  | PV | -106
YTM | 0.12 |  | N | 1
TYPE | 0 |  | TYPE | 0
Price |  |  | YTM
TADXL.com
Spreadsheet: 910cfae4-000a-4dab-9221-3ffce8f7141e
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 12/21/2014 7:23:56 PM
 | [NAME] ([NAME]) Neumann - NON
Justice of the Supreme Court - NON | 97859
 | [NAME]
Public Service Commissioner - DEM | 46446
 | [NAME]
Public Service Commissioner - REP | 54859
 | [NAME]
Representative in Congress - DEM | 52403
 | [NAME]
Representative in Congress - REP | 56570
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: mary_fischer__25425__April log with curtailment corrections
Sheet: GRID

DESERT SKY
GRID VARIANCE
 |  |  |  | Chargeable to: A=AEP, N=Force Majeure, E=Enron, T= TXU
Month: | April '02 |  |  | Reason: U=unscheduled outage, S= scheduled outage, F=fluctuation
Charge | Date off | Time off | Date on | Time on | Hrs. | Reason | Comments
N/A | N/A | N/A | N/A | N/A | N/A | N/A | No grid downtime
Spreadsheet: 863700d1711101829-info-from-one-sheet-to-another-it-services-stock-control
Sheet: Total Assets Demo

IT Services - Asset Control
Asset Information |  |  | Assets Quantities
Inventory ID | Product Name | Product Description | Kingston (A) | Bridge (B) | HESC (G) | Leonardo/The Cove (E/J) | Construction (K) | The Hub (D) | Total
ITS001 | 22' Dell Monitors | 22' Dell Monitors
ITS002 | 27' Dell Monitors | 27' Dell Monitors
ITS003 | Webcams | Assorted Webcams
ITS004 | Keyboards | Assorted Keyboards
ITS005 | Mice | Assorted Mice
ITS006 | Headphones | Assorted USB Headphones
Spreadsheet: 847047d1698147467-summation-from-different-columns-based-on-multiple-criteria-24102023-sample-for-excel-forum
Sheet: Sheet1

 |  | PrCD >>> | 100 | 200 | 201 | 202 | 203 | 518 | 501
 | Date | BrCD | col1 | [NAME] | col3 | col4 | col5 | col6 | col7
 | 2023-02-28 00:00:00 | 20 | 16790285.11 | 28788782.91 | 1222019.6 | 14427 | 206202.8 | 150000
 | 2023-03-31 00:00:00 | 22 | 4236284.22 | 6687236.88 | 0 | 1253.4 | 0 | 0 | 0
 | 2023-04-01 00:00:00 | 8 | 7295028.76 | 43482850.14 | 0 | 36083.29 | 0 | 3028.38 | 0
 | 2023-05-06 00:00:00 | 9 | 3400462.24 | 47440112.2 | 0 | 30389.33 | 0 | 5786.8 | 504162.86
 | 2023-06-18 00:00:00 | 10 | 10238076.62 | 51355996.71 | 212122 | 177247.9 | 123123 | 3782.6 | 15454
 | 2023-06-18 00:00:00 | 15 | 15488107.03 | 19219407.51 | 145450 | 26536.1 | 455000 | 322150.02 | 455476.05
 | 2023-06-19 00:00:00 | 21 | 22278430.52 | 71079283.95 | 0 | 168080.9 | 0 | 977331.54 | 0
 | 2023-06-21 00:00:00 | 24 | 20257028.34 | 37027020.58 | 0 | 258374.62 | 11442.94 | 30170.03 | 662092.1
 | 2023-07-18 00:00:00 | 22 | 11842136.39 | 11776406.97 | 177298.67 | 39876.7 | 0 | 826473.1 | 0
 | 2023-06-18 00:00:00 | 8 | 4451510.26 | 7143605.16 | 45863.56 | 1253.4 | 15552 | 4250 | 1154255
 | 2022-04-30 00:00:00 | 9 | 7495873.23 | 42909093.28 | 0 | 19401.79 | 0 | 3028.38 | 0
 | 2022-04-30 00:00:00 | 15 | 4423014.81 | 48913632.17 | 0 | 30389.33 | 0 | 5786.8 | 165915.56
 |  |  |  | RESULT is as follows |  | Date | 2023-06-18 00:00:00 |  |  | PrCD Criteria table
 |  |  |  |  |  |  |  |  | [NAME] | 200 | 201 | 501
 |  |  |  | BrCD | [NAME] | Bal2 | Bal3 |  | Bal2 | 100 | 202
 |  |  |  | 8 |  |  |  |  | Bal3 | 203 | 518
 |  |  |  | 9 | 0 | 0 | 0
 |  |  |  | 10
 |  |  |  | 15
 |  |  |  | 20 | 0 | 0 | 0
 |  |  |  | 21 | 0 | 0 | 0
 |  |  |  | 22 | 0 | 0 | 0
 |  |  |  | 24 | 0 | 0 | 0
 |  |  |  |  | [NAME] : must add 200 + 201 +501 amount for BrCD & Date
 |  |  |  |  | See the criteria table beside
Spreadsheet: 188259d1350774041-help-production-schedule-on-workday-production-master-schedule_draft_201012-excelforum
Sheet: TABLE

Product Category | MP | FAB | B/P | FIT | MP2 | FAB3 | B/P4 | FIT5 | MP6 | FAB7 | B/P8 | [NAME]
Coal Body | 61 | 143 | 20 | 51
Scow End | 69 | 137 | 17 | 48
[NAME] | 81 | 96 | 17 | 108
Crane | 50 | 276 | 7 | 239
Flat Top Trailer | 41 | 450 | 20 | 90
[NAME] | 82 | 793 | 30 | 128
Low Loader | 118 | 1000 | 43 | 146
Water Tank | 73 | 406 | 43 | 163
Lube Service | 100 | 513 | 71 | 220
Spreadsheet: 792357d1660854720-calculate-date-week-range-based-on-week-number-sameplebook-hd
Sheet: Sheet1

Year | Week # | Month | Date Range | HD
2022 | 1 | December | Dec 26 - Jan 1 |  |  |  |  |  | On my actual sheet the year and week number are static values, they do not change. I would like a formula to resolve a date (week) range (Sunday - Saturday) and display it for example "Jan 2 - Jan 8" based on the week number value in another cell.
2022 | 2 | January | Jan 2 - Jan 8
2022 | 3 | January | Jan 9 - Jan 15
2022 | 4 | January | Jan 16 - Jan 22
2022 | 5 | January | Jan 23 - Jan 29
2022 | 6 | January | Jan 30 - Feb 5
2022 | 7 | February | Feb 6 - Feb 12
2022 | 8
2022 | 9
2022 | 10
2022 | 11
2022 | 12
2022 | 13
Spreadsheet: 884840d1734106167-help-with-dynamic-calendar_incorrect-event-text-color-dynamic-event-and-holiday-calendar-in-excel-test1
Sheet: Holiday Calendar

 |  |  |  |  |  |  |  |  | October |  |  |  |  |  | 2025
 | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 | Notes |  | :
Spreadsheet: 762388d1641537325-rearrange-change-order-column-in-filter-function-book1
Sheet: Sheet1

Fruits | Price | Date | Pieces |  |  | Fruits | Date | Pieces |  |  | Date | Pieces | Fruits
Apple | 5 | 2022-12-01 00:00:00 | 50 |  | From |  | 2022-12-01 00:00:00 | 50 |  | to |  | 50 | Apple
Apple | 5 | 2022-12-02 00:00:00 | 50 |  |  | Apple | 2022-12-02 00:00:00 | 50 |  |  | 2022-12-02 00:00:00 | 50 | Apple
Lemon | 3 | 2022-12-01 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  |  |  | 50 | Apple
 |  |  |  |  |  |  |  |  |  |  | 2022-12-02 00:00:00 | 50 | Apple
Spreadsheet: 51946d1251551250-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-sample-invoice
Sheet: Validation Lists

 | Source Data for DropDown Lists:
 | Product List: |  | Dependent Product Type List: |  |  | Dependent Size List:
 | Product |  | Product | Type |  | Product | Type | Size |  | *I've written down all the size available for each product and type, but I don't know what formula to use
 | ABC |  | ABC | Bed |  | ABC | Bed | 100 |  | so that the '[NAME]' column in the invoice only show the size available for a particular product with a particular type.
 | ABC 2 |  | ABC | Box |  | ABC | Bed | 120
 | XYZ |  | ABC | Set |  | ABC | Box | 100
 | Accessories |  | ABC 2 | Bed |  | ABC | Box | 120
 |  |  | ABC 2 | Box |  | ABC | Set | 100
 |  |  | ABC 2 | Set |  | ABC | Set | 120
 |  |  | XYZ | Bed |  | ABC 2 | Bed | 100
 |  |  | XYZ | Box |  | ABC 2 | Bed | 120
 |  |  | XYZ | Set |  | ABC 2 | Bed | 160
 |  |  | Accessories | Pillow |  | ABC 2 | Bed | 180
 |  |  | Accessories | Memory Pillow |  | ABC 2 | Box | 100
 |  |  | Accessories | Matrres Pad |  | ABC 2 | Box | 120
 |  |  |  |  |  | ABC 2 | Box | 160
 |  |  |  |  |  | ABC 2 | Box | 180
 |  |  |  |  |  | ABC 2 | Set | 100
 |  |  |  |  |  | ABC 2 | Set | 120
 |  |  |  |  |  | ABC 2 | Set | 160
 |  |  |  |  |  | ABC 2 | Set | 180
 |  |  |  |  |  | Accessories | Pillow | 1 Size
 |  |  |  |  |  | Accessories | Memory Pillow | 1 Size
 |  |  |  |  |  | Accessories | Mattress Pad | 100
 |  |  |  |  |  | Accessories | Mattress Pad | 120
 |  |  |  |  |  | Accessories | Mattress Pad | 160
 |  |  |  |  |  | Accessories | Mattress Pad | 180
 |  |  |  |  |  | XYZ | Bed | 120
 |  |  |  |  |  | XYZ | Bed | 160
 |  |  |  |  |  | XYZ | Bed | 180
 |  |  |  |  |  | XYZ | Box | 120
 |  |  |  |  |  | XYZ | Box | 160
 |  |  |  |  |  | XYZ | Box | 180
 |  |  |  |  |  | XYZ | Set | 120
 |  |  |  |  |  | XYZ | Set | 160
 |  |  |  |  |  | XYZ | Set | 180
Spreadsheet: 80800d1280988284-merging-different-worksheet-reports-dummy-2-report-analysis-weekly
Sheet: Sheet2

SALES & MARKETING |  | AUDIT ANALYSIS REPORT |  |  | DATE: 12th TO 18 th June 2010
ACCOUNT NAME | On shelf | Stock | Display | Product | Product | Points | Score | Sales Representative
 | availabilty | Rotation |  | Clean/Cond | Branding
Shop 1 Branch A | 11 | 11 | 11 | 11 | 0 |  |  | Sales rep 1
Shop 1 Branch B | 0 | 0 | 0 | 0 | 0 |  |  | Sales rep 2
Shop 1 Branch C | 0 | 0 | 0 | 0 | 0 |  |  | sales rep 2
Shop 1 Branch D | 3.5 | 4 | 4 | 4 | 0 |  |  | sales rep 3
Shop 1 Branch E | 3.5 | 3.5 | 3.5 | 3.5 | 0 |  |  | sales rep 3
Shop 2 Branch A | 5.5 | 4.5 | 4.5 | 2 | 0 |  |  | sales rep 4
Shop 2 Branch B | 11 | 11 | 11 | 11 | 0 |  |  | sales rep 2
Shop 2 Branch C | 6 | 8.5 | 8.5 | 8.5 | 0 |  |  | sales rep 2
Shop 2 Branch D | 5 | 4.5 | 4.5 | 4.5 | 0 |  |  | sales rep 1
Shop 2 Branch E | 6 | 4.5 | 4.5 | 4.5 | 0 |  |  | sales rep 1
Shop 2 Branch F | 0 | 0 | 0 | 0 | 0 |  |  | sales rep 3
Shop 2 Branch G | 9.5 | 10 | 10 | 10 | 0 |  |  | sales rep 4
Shop 2 Branch H | 4.6 | 5 | 6 | 6 | 0 |  |  | sales rep 4
Shop 2 Branch I | 4 | 4 | 15 | 4 | 0 |  |  | sales rep 2
Shop 2 Branch J | 7 | 7 | 7 | 7 | 0 |  |  | sales rep 2
Shop 2 Branch K | 1.5 | 1.5 | 1.5 | 1.5 | 0 |  |  | sales rep 3
Shop 2 Branch L | 2.5 | 2.5 | 2.5 | 2.5 | 0 |  |  | sales rep 4
Shop 3 Branch 1 | 5 | 6 | 9 | 9 | 0 |  |  | sales rep 4
Shop 3 Branch 2 | 4 | 4 | 4.5 | 3.5 | 0 |  |  | sales rep 1
Shop 3 Branch 3 | 5 | 4.5 | 4.5 | 4.5 | 0 |  |  | sales rep 1
Shop 3 Branch 4 | 5.5 | 4 | 3.5 | 0.5 | 0 |  |  | sales rep 3
Spreadsheet: 273047d1382597519-help-automatic-sorting-by-clicking-a-cell-book3
Sheet: Sheet2

sl | no | Brand | approval | indent | order | request | Proforma | PO
1 | abc | a | 8001 | OR01 | PI-00201 | PO-500 | 2013-12-12 00:00:00 | 2014-01-01 00:00:00
2 | abc1 | b | 8002 | OR02 | PI-00202 | PO-501 | 2013-12-13 00:00:00 | 2014-01-02 00:00:00
3 | abc2 | a | 8003 | OR03 | PI-00203 | PO-502 | 2013-12-14 00:00:00 | 2014-01-03 00:00:00
4 | abc3 | a | 8004 | OR04 | PI-00204 | PO-503 | 2013-12-15 00:00:00 | 2014-01-04 00:00:00
5 | abc4 | c | 8005 | OR05 | PI-00205 | PO-504 | 2013-12-16 00:00:00 | 2014-01-05 00:00:00
6 | [NAME] | b | 8006 | OR06 | PI-00206 | PO-505 | 2013-12-17 00:00:00 | 2014-01-06 00:00:00
7 | abc6 | a | 8007 | OR07 | [NAME] | PO-506 | 2013-12-18 00:00:00 | 2014-01-07 00:00:00
8 | [NAME] | c | 8008 | OR08 | PI-00208 | PO-507 | 2013-12-19 00:00:00 | 2014-01-08 00:00:00
Spreadsheet: 140429d1328740936-weighted-averages-using-a-qualified-sumproduct-formula-reference-sheet-daddy
Sheet: Sheet1

 | Example A (sorted) |  |  |  | Example B (unsorted) |  |  |  | Desired Output (Example A) |  |  |  | Desired Output (Example B)
 | Status | Equity | % Debt |  | Status | Equity | % Debt |  | Status | Equity | % Debt |  | Status | Equity | % Debt
 | Closed | 938645.1941174022 | 0.7 |  | Pipeline | 753511.5260890513 | 0.7 |  | Closed |  |  |  | Closed
 | Closed | 1368300.007224153 | 0.7 |  | Closed | 1280730.314807457 | 0.65 |  | Delayed |  |  |  | Delayed
 | Closed | 788475.75 | 0.65 |  | Closed | 788475.75 | 0.65 |  | Pipeline |  |  |  | Pipeline
 | Closed | 1261456.84 | 0.65 |  | Closed | 863770.4394435851 | 0.7 |  | Total / Avg |  |  |  | Total / Avg
 | Closed | 1280730.314807457 | 0.65 |  | Delayed | 881939.2153083184 | 0.65
 | Closed | 925502.2538922525 | 0.7 |  | Closed | 925502.2538922525 | 0.7
 | Closed | 1300790.973315803 | 0.72904653 |  | Closed | 1300790.973315803 | 0.72904653
 | Closed | 863770.4394435851 | 0.7 |  | Closed | 1306360.090045471 | 0.65
 | Closed | 1306360.090045471 | 0.65 |  | Pipeline | 1311528.581719239 | 0.7
 | Closed | 2454900.291166465 | 0.6 |  | Closed | 1368300.007224153 | 0.7
 | Closed | 1188457.907152929 | 0.65 |  | Closed | 938645.1941174022 | 0.7
 | Delayed | 1564882.732712457 | 0.7 |  | Pipeline | 1128524.689581397 | 0.65
 | Delayed | 1213620.148097466 | 0.65 |  | Pipeline | 1187440.035424126 | 0.7
 | Delayed | 881939.2153083184 | 0.65 |  | Closed | 1188457.907152929 | 0.65
 | Pipeline | 4322499.988109671 | 0.65 |  | Delayed | 1213620.148097466 | 0.65
 | Pipeline | 2780162.458056359 | 0.65 |  | Closed | 1261456.84 | 0.65
 | Pipeline | 1128524.689581397 | 0.65 |  | Delayed | 1564882.732712457 | 0.7
 | Pipeline | 1187440.035424126 | 0.7 |  | Pipeline | 1917958.919648064 | 0.65
 | Pipeline | 753511.5260890513 | 0.7 |  | Closed | 2454900.291166465 | 0.6
 | Pipeline | 1917958.919648064 | 0.65 |  | Pipeline | 2780162.458056359 | 0.65
 | Pipeline | 1311528.581719239 | 0.7 |  | Pipeline | 4322499.988109671 | 0.65
 | Total / Avg |  |  |  | Total / Avg