tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mike_carson__27610__KOCH02012002
Sheet: Sheet1

 | [NAME] for power delivered
 | On-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee | COST | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 100 | 19 |  | 1 |  |  |  |  | 26.03
 | TVA | 0 |  |  | 1 |  |  |  |  | 31
 | Cinergy | -700 | 20.25 |  | 1 |  |  |  |  | 30.96
 | Comed | -100 | 20.5 |  | 1 |  |  |  |  | 34.75
 | Off-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee |  | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 15.75 |  | 1 |  |  |  |  | 18.25
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand |  | WIRE AMOUNT
 |  |  |  |  | Total | >>>>>>
 |  |  |  |  |  |  |  |  | Existing
Spreadsheet: 220470d1363176727-calculating-specific-working-hours-237-time-calculation
Sheet: Sheet3

2100
2200
2300
2400
1
100
200
300
400
500
600
Spreadsheet: 04b46cf9-e6b2-4b14-86e2-f1b12fa1e2b9
Sheet: Sheet1

Marketing Project Rubric | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Process | [NAME]. | Satisfactory | Excellent
1. Has a clear vision  of final product | 1,2,3 | 4,5,6 | 7,8,9
2. Properly organized to complete project | 1,2,3 | 4,5,6 | 7,8,9
3. Managed time wisely | 1,2,3 | 4,5,6 | 7,8,9
4. Acquired needed  knowledge base | 1,2,3 | 4,5,6 | 7,8,9
5. Communicated efforts with teacher | 1,2,3 | 4,5,6 | 7,8,9
6. Showed appropriate  Leadership skills | 1,2,3 | 4,5,6 | 7,8,9
Presentation | [NAME]. | Satisfactory | Excellent
1. Format | 1,2,3 | 4,5,6 | 7,8,9
2. Mechanics of  speaking/writing | 1,2,3 | 4,5,6 | 7,8,9
3. Organization and  structure | 1,2,3 | 4,5,6 | 7,8,9
4. Creativity | 1,2,3 | 4,5,6 | 7,8,9
5. Demonstates Knowledge | 1,2,3 | 4,5,6 | 7,8,9
6.Equal Participation | 1,2,3 | 4,5,6 | 7,8,9
7. 1 or more commercial techniques | 1,2,3 | 4,5,6 | 7,8,9
8. 1 or more presentation aides | 1,2,3 | 4,5,6 | 7,8,9
Product | [NAME]. | Satisfactory | Excellent
1.Creativity | 1,2,3 | 4,5,6 | 7,8,9
2.Useful to horse  or owner | 1,2,3 | 4,5,6 | 7,8,9
3. Meets project  requirements | 1,2,3 | 4,5,6 | 7,8,9
Totals | 17-51 | 68-102 | 119-153
Grade | 60-65 | 70-80 | 90-100
Spreadsheet: 837780d1690424842-need-a-simple-formula-if-todays-date-is-august-1st-minus-6-days-then-return-balance-thematrix05-sample42
Sheet: Sheet1

 |  | Balance | 455.02
 |  | 2023-01-01 00:00:00
 |  |  |  | =IF TODAY [NAME]AUGUST J14 MINUS 6 DAYS, THEN RETURN BALANCE (D1)
Spreadsheet: 772631d1647418603-index-lookup-multiple-sources-and-values-matching-a-criteria-index-lookup
Sheet: Sheet1

 | Style 1 |  |  | Style 2 |  |  | Combined |  |  |  |  |  | Current formula is returning 'Room' values from the named ranges sequentially, not selecting the values which correspond to the correct 'Sub Type'.
 | Room | Sub Type |  | Room | Sub Type |  | Room
 | Bed 1 | A |  | Living | B
 | Office | B |  | Bed 3 | A |  |  |  |  |  |  |  | Current Formula
 | Study | B |  | Bed 4 | A
 | Bed 2 | A |  | Nursery |  |  |  |  |  |  |  |  | IF(ROWS(H$8:[NAME]:H8)<=COUNTIFS(Room1,"*",Subtype1,"A"),Room1,Room2),IF(ROWS(H$8:H8)<=COUNTIFS(Room1,"*",Subtype1,"A"),ROWS(H$8:H8),ROWS(B$11:B11)-COUNTIFS(Room1,"*",Subtype1,"A"))))
 | Theatre | A
 | Kitchen | A
 | Playroom | B
 | Dining | B
Spreadsheet: 105400d1302769003-formulas-to-import-transfer-from-ws-to-ws-trial
Sheet: Display

PR No. | NCMAR Number | Responsible | Debit Number
Import Pr No. from | NCMAR Number | Responsible person | Debit Note Number from Downlaod3
Worksheet "Download1" | *10001411* from Download2 | *10001411* from Download2 | which matches the ncmar now in Column B
 | based on the PR Number in | based on the PR Number in
 | column A across from column C | column A across from Column B
 | of Download2 | of Download2
77777 | 10001411 | [NAME] | 55551
88888 | 10001412 | [NAME] | 55552
99999 | 10001413 | paddy1 | 55553
11111 | 10001414 | paddy1 | 55554
Spreadsheet: 714419d1611223501-sumifs-that-also-compares-2-columns-and-uses-latest-date-sumifs-prob
Sheet: Sheet1

Title | Status | Status 2 | End Date | Resceduled End Date |  |  | No of In Plan due to end in
Project 1 | Temporary | In Progress | 2021-01-30 00:00:00 |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00
Project 2 | Temporary | In Progress | 2021-01-30 00:00:00
Project 3 | Temporary | Complete | 2021-01-30 00:00:00
Project 4 | Temporary | In Plan | 30/02/2021 | 2021-03-30 00:00:00 |  |  | The above basically needs to total the amount of in plans that are due to end in the months H3-J3. As you can see some of the End Dates have been rescheduled so need something to only take the latest end date. I have tried incorporating a MAX but only get errors
Project 5 | Temporary | In Progress | 2021-01-30 00:00:00
Project 6 | Temporary | In Progress | 2021-01-30 00:00:00 |  |  |  | Many Thanks!!!!!!!
Project 7 | Permenant | In Plan | 30/02/2021 | 2021-03-30 00:00:00
Project 8 | Permenant | In Progress | 2021-01-30 00:00:00
Project 9 | Permenant | In Progress | 2021-01-30 00:00:00
Project 10 | Permenant | In Progress | 2021-01-30 00:00:00
Project 11 | Permenant | In Plan | 30/02/2021 | 2021-03-30 00:00:00
Project 12 | Permenant | In Progress | 2021-01-30 00:00:00
Project 13 | Temporary | In Plan | 2021-01-30 00:00:00
Project 14 | Temporary | In Plan | 2021-01-30 00:00:00
Project 15 | Permenant | In Plan | 2021-01-30 00:00:00
Project 16 | Temporary | In Progress | 2021-01-30 00:00:00
Project 17 | Temporary | In Progress | 2021-01-30 00:00:00
Project 18 | Permenant | Complete | 2021-02-27 00:00:00
Project 19 | Permenant | In Progress | 2021-01-30 00:00:00
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Nicholls, Matthew

Nicholls, [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 221027d1363350997-using-solver-with-constraints-my-solver
Sheet: Answer Report 1

Microsoft Excel 15.0 Answer Report
Worksheet: [My Solver.xlsx]Sheet1
Report Created: 3/14/2013 11:45:23 PM
Result: Solver found a solution.  All Constraints and optimality conditions are satisfied.
Solver Engine
 | Engine: GRG Nonlinear
 | Solution Time: 0.016 Seconds.
 | Iterations: 0 Subproblems: 0
Solver Options
 | [NAME],  Iterations Unlimited, Precision 0.000001
 | Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Central
 | Max Subproblems Unlimited, [NAME], [NAME] 1%, Assume NonNegative
Objective Cell (Value Of)
 | Cell | Name | Original Value | Final Value
 | $F$4 |  | 500000 | 500000
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $A$4 | A | 207896.4056137999 | 207896.4056137999 | [NAME]
 | $B$4 | B | 29959.37653026668 | 29959.37653026668 | [NAME]
 | $C$4 | C | 0.2178559333761372 | 0.2178559333761372 | [NAME]
 | $D$4 | D | 104857.6 | 104857.6 | [NAME]
 | $E$4 | E | 157286.4 | 157286.4 | [NAME]
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $A$4 | A | 207896.4056137999 | $A$4<=0.5*$F$4 | Not Binding | 42103.5943862001
 | $B$4 | B | 29959.37653026668 | $[NAME] | Not Binding | 220040.6234697333
 | $C$4 | C | 0.2178559333761372 | $C$4<=0.5*$F$4 | Not Binding | 249999.7821440666
 | $D$14 | A + B +C >=100 000 D | 237856 | $D$14>=100000 | Not Binding | 137856
 | $D$4 | D | 104857.6 | $D$4<=0.5*$F$4 | Not Binding | 145142.4
 | $D$4 | D | 104857.6 | $D$4>=$C$4+50000 | Not Binding | 54857.38214406663
 | $E$4 | E | 157286.4 | $E$4<=0.5*$F$4 | Not Binding | 92713.59999999998
 | $E$4 | E | 157286.4 | $E$4=1.5*$D$4 | Binding | 0
 | $F$4 |  | 500000 | $F$4=500000 | Binding | 0
 | $A$4 | A | 207896.4056137999 | $A$4>=0 | Not Binding | 207896.4056137999
 | $B$4 | B | 29959.37653026668 | $[NAME] | Not Binding | 29959.37653026668
 | $C$4 | C | 0.2178559333761372 | $C$4>=0 | Not Binding | 0.2178559333761372
 | $D$4 | D | 104857.6 | $[NAME] | Not Binding | 104857.6
 | $E$4 | E | 157286.4 | $E$4>=0 | Not Binding | 157286.4
Spreadsheet: 168261d1342353766-excel-2007-vlookup-returns-n-a-with-special-characters-folderlist
Sheet: Sheet1

Job Number | Folder ID | Result I would like to have ([NAME])
Order 1 | 9(Dij':``%U33O7DX@MM
Order 2 | 3Y=A[$(c!/VH!ga`,T&u
Order 3 | -uecBgd@Do[XaZ.T5%0g
Order 4 | +0*2hqH"+sJ\&`X?c[sQ
Order 5 | +0*2hqH"+sJ\&`X?c[sQ
Order 6 | 9(Dij':``%U33O7DX@MM
Order 7 | 3Y=A[$(c!/VH!ga`,T&u
Order 8 | 3Y=A[$(c!/VH!ga`,T&u
Order 9 | 3Y=A[$(c!/VH!ga`,T&u
Order 10 | N[0$CF$h<CM0qqoVjoPs
Order 11 | 9(Dij':``%U33O7DX@MM
Order 12 | 9(Dij':``%U33O7DX@MM
Order 13 | 3Y=A[$(c!/VH!ga`,T&u
Order 14 | 3Y=A[$(c!/VH!ga`,T&u
Order 15 | 3Y=A[$(c!/VH!ga`,T&u
Order 16 | 9(Dij':``%U33O7DX@MM
Order 17 | gQ1rgV*`$kO9JKLjcCC"
Order 18 | gQ1rgV*`$kO9JKLjcCC"
Order 19 | gQ1rgV*`$kO9JKLjcCC"
Order 20 | N[0$CF$h<CM0qqoVjoPs
Order 21 | -uecBgd@Do[XaZ.T5%0g
Order 22 | -uecBgd@Do[XaZ.T5%0g
Order 23 | 3Y=A[$(c!/VH!ga`,T&u
Order 24 | Kjo@FZoK4%T$qe.WC
Order 25 | `&HC#GeTG1S>+s?J#A1g
Order 26 | Kjo@FZoK4%T$qe.WC
Order 27 | 9(Dij':``%U33O7DX@MM
Order 28 | Kjo@FZoK4%T$qe.WC
Order 29 | 3Y=A[$(c!/VH!ga`,T&u
Order 30 | 9(Dij':``%U33O7DX@MM
Order 31 | gQ1rgV*`$kO9JKLjcCC"
Order 32 | -uecBgd@Do[XaZ.T5%0g
Order 33 | -uecBgd@Do[XaZ.T5%0g
Order 34 | 9(Dij':``%U33O7DX@MM
Order 35 | 3Y=A[$(c!/VH!ga`,T&u
Order 36 | \BqcJLABFgS<hh=?,Nhq
Order 37 | !!!!!!!!!!!!!!!!!!!!
Order 38 | `&HC#GeTG1S>+s?J#A1g
Order 39 | 3Y=A[$(c!/VH!ga`,T&u
Order 40 | `&HC#GeTG1S>+s?J#A1g
Order 41 | 9(Dij':``%U33O7DX@MM
Order 42 | 3Y=A[$(c!/VH!ga`,T&u
Order 43 | 9(Dij':``%U33O7DX@MM
Spreadsheet: 569f777c-44bf-4c10-917e-3d766b311190
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Leipzig, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 77186 | 84028 | 91176 | 93703
20 - 65 | 337902 | 329366 | 322272 | 315290
65 und mehr | 116721 | 119166 | 125058 | 129587
Insgesamt | 531809 | 532560 | 538506 | 538580
%
unter 20 | 14.51385741873492 | 15.77812828601472 | 16.93128767367494 | 17.39815811949942
20 - 65 | 63.5382251898708 | 61.84580141204747 | 59.84557275127854 | 58.54097812766905
65 und mehr | 21.94791739139428 | 22.37607030193781 | 23.22313957504652 | 24.06086375283152
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 22.84271771105232 | 25.51204435187603 | 28.29162943103962 | 29.71962320403438
Altenquotient | 34.54285562086049 | 36.180419351117 | 38.80510872803098 | 41.10089124298265
Gesamtquotient | 57.38557333191279 | 61.69246370299303 | 67.0967381590706 | 70.82051444701703
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: john_lavorato__16500__West position
Sheet: West Power Position

WEST POSITION
All positions are PV'd | All Years |  |  | 2000 |  |  |  | 2001 |  |  |  |  |  | 2002-2015
 | total | BOM | 2000-06-01 00:00:00 | Q3-00 | Q4-00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Q1 | Q2 | Q3 | Q4 | Total
Peak
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Total
 | All Years
 | total | BOM | 36678 | Q3-00 | Q4-00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Q1 | Q2 | Q3 | Q4 | Total
Off-peak
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Total
 | All Years
Grand Total | total | BOM | 2000-06-01 00:00:00 | Q3-00 | Q4-00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Q1 | Q2 | Q3 | Q4 | Total
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Grand Total
 | All Years |  |  | 2000 |  |  |  | 2001 |  |  |  |  |  | 2002-2015
Gas position contracts | total | BOM | 2000-06-01 00:00:00 | Q3-00 | Q4-00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Q1 | Q2 | Q3 | Q4 | Total
Sumas (Daily) |  | -3 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas position [NAME]'s | total | BOM | 2000-06-01 00:00:00 | Q3-00 | Q4-00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Q1 | Q2 | Q3 | Q4 | Total
Sumas (Daily)
Spreadsheet: 32cfd9e7-7626-4cc0-9741-129c68a1c32d
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ausländer und Ausländerinnen, welche länger als 2 Jahre in der [NAME] bleiben möchten, werden verpflichtet, die Sprache des jeweiligen Landesteils zu lernen.
 | Welches ist Ihre höchste abgeschlossene Ausbildung?
Antwort | Obligatorische Schule oder (noch) keine abgeschlossene Ausbildung | [NAME], [NAME], berufsvorbereitende [NAME], [NAME] | Maturitätsschule, Diplommittelschule | Höhere Fach- oder [NAME] ([NAME]. Fach- oder [NAME], HKG, TS) | Universität, Hochschule, Fachhochschule, Höhere Fachschule ([NAME], HWV, HFG, HFS)
[NAME] | 0.85 | 0.92 | 0.87 | 0.89 | 0.82
Neutral / Weiss nicht | 0.09 | 0.05 | 0.07 | 0.06 | 0.09
[NAME] | 0.07 | 0.03 | 0.05 | 0.05 | 0.09
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 141811d1329467441-excel-2007-automation-form-advanced-form-care
Sheet: Sheet1

To: | Caring & CO. |  |  |  | [NAME]  : | 1300 12 1212
 | Our Fax No: 03-8965 1234
From:_________________________________________________________
Company Name:_______________________________________________
Your Phone No: |  |  |  |  | Fax no:
Important Notice : |  |  | Please complete this form and fax your Referral Letter or
 |  |  | appointment card to us
Reason for seeking treatment: (please tick whichever approriate)
For Admission |  |  |  |  | First visit (please attach Referral Letter)
For Consultation |  |  |  |  | Follow-up visit (please attach Appointment Card)
Information on Employee & Patient:
Caring ID No |  |  |  | >
Name of employee |  |  |  | >
Name of patient |  |  |  | >
I/C of Employee |  |  |  | >
Name of clinic issuing referral letter |  |  |  | >
Name of hospital/specialist referred to |  |  |  | >
Name of doctor you wish to meet |  |  |  | >
Diagnosis |  |  |  | >
Date of visit/admission |  |  |  | >
Fax GL to: |  |  |  |  |  | Fax No:
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S RM Kent 

 |  |  |  |  | Friday to Thursday
 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target | % Against Target
 | Major injury | -50 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lost time injury | -25 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Non-lost time injury | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Service Strike (HV) | -20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Service Strike (LV) | -15 |  |  | 0 | 0 | 0 | 0 | 0 | Less than 3 | Less than 36 |  | <6
 | Service Strike (Gas) | -10 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33
 | Service Strike (Other) | -5 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33
 | Manager [NAME] | 0.1 |  |  | 26 | 0 | 0 | 0 | 0 | 26
 | Safety observations | 0.01 |  |  | 166 | 0 | 0 | 0 | 0 | 166
 | H&S advisor visits | 0.2 |  |  | 12 | 0 | 0 | 0 | 0 | 12
 | Manager/Supervisor Safety Visits | 0.01 |  |  | 83 | 0 | 0 | 0 | 0 | 83
 | [NAME] | 0.01 |  |  | 317 | 0 | 0 | 0 | 0 | 317
 | ABC Tours | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 3
 | HAVS |  |  |  | 0 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: 145387d1331565006-index-match-several-sheets-to-one-formula-vml
Sheet: SubTot

 |  |  | Dep Date |  |  |  |  |  |  | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00
 |  |  | W/c Date |  | 2011-04-02 00:00:00 | 2011-04-09 00:00:00 | 2011-04-16 00:00:00 | 2011-04-23 00:00:00 |  | 2012-05-05 00:00:00 | 2012-05-12 00:00:00 | 2012-05-19 00:00:00 | 2012-05-26 00:00:00 | 2012-06-02 00:00:00 | 2012-06-09 00:00:00 | 2012-06-16 00:00:00 | 2012-06-23 00:00:00 | 2012-06-30 00:00:00 | 2012-07-07 00:00:00 | 2012-07-14 00:00:00 | 2012-07-21 00:00:00 | 2012-07-28 00:00:00 | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00 | 2012-09-15 00:00:00 | 2012-09-22 00:00:00 | 2012-09-29 00:00:00 | 2012-10-06 00:00:00 | 2012-10-13 00:00:00 | 2012-10-20 00:00:00 | 2012-10-27 00:00:00 | TOTAL | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | Total
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 1 | 1 | 1 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1279737551786876 | 0.2216781143834356 | 0.2911703896426912 | 0.2226846941348127 | 0.1171279072896231 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Costs | Transfers | -11.40350877192983
 | Handling | 0
Spreadsheet: 53823d1253740456-vertical-and-horizonal-search-book2
Sheet: Sheet1

 |  | [NAME] | [NAME] | Martin | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | 2009-01-01 00:00:00 |  | B | A |  |  | C | B | B |  | A
 | 2009-01-02 00:00:00 | A | B |  | B | A | C | B | B |  | C
 | 2009-01-03 00:00:00 | A |  |  | B | A |  |  |  |  | 2009-01-06 00:00:00
 | 2009-01-04 00:00:00 | A |  | B |  | A
 | 2009-01-05 00:00:00 |  | C | B |  |  |  | C | C |  | [NAME]
 | 2009-01-06 00:00:00 | B | C |  | C |  | A | C | C |  | [NAME]
 | 2009-01-07 00:00:00 | B |  |  | C | B | A |  |  |  | [NAME]
 | 2009-01-08 00:00:00 | B |  | C |  | B | A |  |  |  | [NAME]
 | 2009-01-09 00:00:00 |  |  | C |  |  |  |  |  |  | [NAME]
 | 2009-01-10 00:00:00 |  | A |  |  |  |  | A | A
 | 2009-01-11 00:00:00 | C | A |  | A | C | B | A | A
 | 2009-01-12 00:00:00 | C | A |  | A | C | B | A | A
 | 2009-01-13 00:00:00 |  |  | A | A
 | 2009-01-14 00:00:00 |  | C | A |  |  |  | C | C
 | 2009-01-15 00:00:00 |  | C | A | B |  | C | C | C
 | 2009-01-16 00:00:00 | A |  |  | C | A | C
 | 2009-01-17 00:00:00 | A |  | B | C | A
 | 2009-01-18 00:00:00 | A |  | B |  | A
 | 2009-01-19 00:00:00 |  | A |  |  |  |  | A | A
 | 2009-01-20 00:00:00 | B | A |  |  | B | A | A | A
 | 2009-01-21 00:00:00 | B | A | C | A | B | A | A | A
Spreadsheet: 703958d1605270420-round-total-quantity-from-max-formula-inventory-mockup_gw
Sheet: Sheet1

 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00
PRODUCT | Purchase | 0
 | Forecast/Actual sale | 1000 | 1100 | 1100 | 1100 | 1200 | 1000 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
12 | Inventory | 4000
 | Month of Supply
 | smooth | 0.5
Spreadsheet: 804688d1668217582-mmulti-function-help-popcorn
Sheet: Sheet1

Number | Probablity | Number
 | First die |  |  |  |  |  |  | First Die | Second Die |  | Joint P | Total | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
1 |  | 1 |  |  |  |  |  |  |  |  |  | Sum:
2 |  | 1 |  |  |  |  |  |  | 1
3 |  | 1
4 |  | 1 |  |  |  |  |  |  | 2
5 |  | 1
6 |  | 1 |  |  |  |  |  |  | 3
 | Second die |  |  |  |  |  |  | 1
1 |  | 1 |  |  |  |  |  |  | 4
2 |  | 1
3 |  | 1 |  |  |  |  |  |  | 5
4 |  | 1
5 |  | 1 |  |  |  |  |  |  | 6
6 |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
Spreadsheet: 161045d1339382330-to-get-minimum-value-from-a-database-with-criteria-else-return-na-min-example_6
Sheet: Sheet1

 |  | Criteria | Result
 |  | 6.1apple
 |  | 6.2orange
 |  | 6.3grape
 |  | 6.4kiwi |  | ----This should become "0" instead of "NA" because the minimum value is "0".
 |  | Fruit | Qty
 |  | 6.1apple | 1
 |  | 6.2orange | 2
 |  | 6.3grape | 4
 |  | 6.1apple | 4
 |  | 6.1apple | 5
 |  | 6.3grape | 6
 |  | 6.1apple | 7
 |  | 6.2orange | 2
 |  | 6.3grape | 0
 |  | 6.1apple | 1
 |  | 6.1apple | 1
 |  | 6.3grape | 7
 |  | 6.2orange | 4
 |  | 6.3grape | na
 |  | 6.3grape | 1
 |  | 6.4kiwi | 0
 |  | 6.4kiwi | NA
 |  | 6.3apple | NA