tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: hunter_shively__12743__EnovateDPR0123
Sheet: ENOVATE DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
ENOVATE
GAS TRADING |  |  | 10 Bcf |  |  | 20 Bcf |  |  |  | 2000
Short Term Trading
Long Term Trading |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  | MTD | QTD | YTD | MTD 12/12 |  | 114
 |  | ENOVATE | 1315.43208904 | 1315.43208904 | 10.96708904000162 |  |  |  |  | P&L 13th |  | 17
 |  |  |  |  |  |  |  |  |  | MTD 13th |  | 131
 |  | GAS TRADING | 1315.43208904 | 1315.43208904 | 10.96708904000162
 |  | Short Term Trading | 1315.43208904 | 1315.43208904 | 10.96708904000162 |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 738830d1625255708-sum-numbers-over-x-and-y-multiple-columns-and-multiple-rows-using-single-range-book1
Sheet: Sheet1

 |  |  |  |  | 2021-07-24 00:00:00
Project Management |  |  | [NAME] | 144 | 5 | Data Acquisition - Steep Creek
Data Acquisition - Steep Creek |  | <- answer would be 47 | Junior II | 153 | 8 | Data Acquisition - Steep Creek | 5 | Data Acquisition - Steep Creek
Data Acquisition - Clearwater |  | <- answer would be 22 | Intermediate I | 173 | 10 | Data Acquisition - Clearwater | 6 | Data Acquisition - Steep Creek
Field Work and Surveys - Steep Creek |  |  | Junior II | 153 | 5 | Data Acquisition - Clearwater | 7 | Data Acquisition - Clearwater
Field Work and Surveys - Clearwater |  |  | Intermediate I | 173 | 6 | Data Acquisition - Steep Creek | 8 | Data Acquisition - Steep Creek
 |  |  | Senior II | 247 |  |  | 9 | Data Acquisition - Steep Creek
Spreadsheet: 113836d1309730167-excel-2007-attendance-formula-attendance-2012-template-for-excel-help
Sheet: Sheet1

 |  | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | Attended Y/N | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | Attended Y/N | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | Attended Y/N | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | Attended Y/N | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | Attended Y/N | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | Attended Y/N | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | Attended Y/N | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | Attended Y/N | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | Attended Y/N | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | Attended Y/N | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | Attended Y/N | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | Attended Y/N
 | [NAME] | yes
 | [NAME] | no
YSA | [NAME] | yes
 | Fred | yes
YSA | bill | no
 | [NAME] | no
YSA | [NAME] | yes
 | Nate | no
 | [NAME] | yes
YSA
YSA
YSA
YSA
YSA
YSA
YSA
YSA
YSA
YSA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD AVG
 |  | Pecentage of People Who Attended
 |  | Number of YSA Who Attended
 |  | Number of Perspective People Who Attended
 |  | Number of People Who Attended
Spreadsheet: 814331d1674288941-excel-conditional-formatting-actual-vs-budget-actual-vs-budget-file
Sheet: Sheet1

A$000's |  | Actual | Budget | My Comments
Total Income |  | 628.7099499999999 | 542.66274 | This formula is correct. Total Income Actual higher than the budget (above 100, therefore Green colour)
Expenses |  | 536.6206199999999 | 544.39879 | This formula is correct. Total Expense Actual lower than the budget (in between 100 to 95 therefore Orance colour)
Net Surplus / (Deficit) |  | 92.08933 | -1.73605 | This formula is incorrect. Net Surplus Actual is 92.09 higher than the budget (-1.74). Therefore colour should have been green but color is red here.
Surplus/(Deficit) % Total Income |  | 0.146473473181075 | -0.003199132485123264 | This formula is incorrect. Surplus Actual 14.65% higher than the budget (-0.32%). Therefore colour should have been green but color is red here.
Current Asset / Current Liabilities |  | 1.57 | 2.25 | This formula is correct
Employee Remuneration / Total Income |  | 0.7037002091660334 | 0.7242818302860938 | This formula is correct
Spreadsheet: 275381d1383494888-results-of-2-formulas-in-one-cell-e09m2june_jriley
Sheet: Summary

June Temperature Summary
In °F
Date | High | High-City | Low | Low-City
2009-06-01 00:00:00
2009-06-02 00:00:00
2009-06-03 00:00:00
2009-06-04 00:00:00
2009-06-05 00:00:00
2009-06-06 00:00:00
2009-06-07 00:00:00
2009-06-08 00:00:00
2009-06-09 00:00:00
2009-06-10 00:00:00
2009-06-11 00:00:00
2009-06-12 00:00:00
2009-06-13 00:00:00
2009-06-14 00:00:00
2009-06-15 00:00:00
2009-06-16 00:00:00
2009-06-17 00:00:00
2009-06-18 00:00:00
2009-06-19 00:00:00
2009-06-20 00:00:00
2009-06-21 00:00:00
2009-06-22 00:00:00
2009-06-23 00:00:00
2009-06-24 00:00:00
2009-06-25 00:00:00
2009-06-26 00:00:00
2009-06-27 00:00:00
2009-06-28 00:00:00
2009-06-29 00:00:00
2009-06-30 00:00:00
Monthly Records
High/Low
Date
City
Spreadsheet: 884482d1733675507-top-10-with-duplicates-top-10-with-duplicates
Sheet: Top 10% 

 | 2024-10-01 00:00:00 |  |  |  |  | 2024-11-01 00:00:00 |  |  |  |  | 2024-12-01 00:00:00
Rank | Name | items | Percentage |  | Rank | Name | items | Percentage |  | Rank | Name | items | Percentage
 | [NAME] | 25 | 0.05219206680584551 |  |  | [NAME] | 22 | 0.09166666666666666
2 | [NAME] | 21 | 0.04384133611691023 |  | 2 | [NAME] | 16 | 0.06666666666666667
3 | [NAME] | 18 | 0.03757828810020877 |  | 3 | [NAME] | 12 | 0.05
4 | [NAME] | 17 | 0.03549060542797495 |  | 4 | [NAME] | 12 | 0.05
5 | [NAME] | 17 | 0.03549060542797495 |  | 5 | [NAME] | 12 | 0.05
6 | [NAME] | 17 | 0.03549060542797495 |  | 6 | [NAME] | 12 | 0.05
7 | Contractors | 16 | 0.03340292275574112 |  | 7 | [NAME] | 9 | 0.0375
8 | [NAME] | 15 | 0.03131524008350731 |  | 8 | [NAME] | 8 | 0.03333333333333333
9 | [NAME] | 12 | 0.02505219206680585 |  | 9 | [NAME] | 8 | 0.03333333333333333
10 | [NAME] | 11 | 0.02296450939457203 |  | 10 | [NAME] | 8 | 0.03333333333333333
11 | [NAME] | 11 | 0.02296450939457203 |  | 11 | [NAME] | 7 | 0.02916666666666667
12 | [NAME] | 10 | 0.0208768267223382 |  | 12 | [NAME] | 7 | 0.02916666666666667
13 | [NAME] | 9 | 0.01878914405010438 |  | 13 | [NAME] | 6 | 0.025
14 | [NAME] | 9 | 0.01878914405010438 |  | 14 | [NAME] | 6 | 0.025
 |  |  |  |  | 15 | [NAME] | 5 | 0.02083333333333333
 |  |  |  |  | 16 | [NAME] | 5 | 0.02083333333333333
 |  |  |  |  | 17 | [NAME] | 5 | 0.02083333333333333
 |  |  |  |  | 18 | [NAME] | 4 | 0.01666666666666667
 |  |  |  |  | 19 | [NAME] | 4 | 0.01666666666666667
 |  |  |  |  | 20 | [NAME] | 3 | 0.0125
 |  |  |  |  | 21 | [NAME] | 3 | 0.0125
 |  |  |  |  | 22 | [NAME] | 3 | 0.0125
 |  |  |  |  | 23 | [NAME] | 3 | 0.0125
 |  |  |  |  | 24 | [NAME] | 3 | 0.0125
 |  |  |  |  | 25 | [NAME] | 3 | 0.0125
 |  |  |  |  | 26 | [NAME] | 3 | 0.0125
 |  |  |  |  | 27 | Izaak Connor | 3 | 0.0125
 |  |  |  |  | 28 | [NAME] | 3 | 0.0125
Rank | Item | Quantities | Percentage |  | Rank | Item | Quantities | Percentage |  | Rank | Item | Quantities | Percentage
 | Extra large /10 | 52 | 0.1085594989561587 |  |  | Extra large /10 | 24 | 0.1
2 | Large /9 | 43 | 0.08977035490605428 |  | 2 | Cotton gloves | 20 | 0.08333333333333333
3 | Short PVC gloves | 40 | 0.08350730688935282 |  | 3 | Disposable masks | 19 | 0.07916666666666666
4 | Large /9 | 37 | 0.07724425887265135 |  | 4 | Short PVC gloves | 18 | 0.075
5 | Extra large /10 | 36 | 0.07515657620041753 |  | 5 | Large /9 | 16 | 0.06666666666666667
6 | Disposable masks | 26 | 0.05427974947807934 |  | 6 | Extra large /10 | 16 | 0.06666666666666667
7 | Extra large | 16 | 0.03340292275574112 |  | 7 | Large /9 | 13 | 0.05416666666666667
8 | XX Large/ 11 | 15 | 0.03131524008350731 |  | 8 | XX Large/ 11 | 11 | 0.04583333333333333
9 | Extra large | 15 | 0.03131524008350731 |  | 9 | 2X Large | 9 | 0.0375
10 | 2X Large | 15 | 0.03131524008350731 |  | 10 | 3X Large | 9 | 0.0375
11 | Medium /8 | 14 | 0.02922755741127349 |  | 11 | Large | 8 | 0.03333333333333333
12 | Medium /8 | 13 | 0.02713987473903967 |  | 12 | Extra large | 6 | 0.025
Spreadsheet: 138208d1327570189-indirect-cekks-cio-testing-sheet-draft
Sheet: 2012

year | 2012
Name | age | spelling | maths | reading
 |  | 14 | 6705 | 8
 |  | 15 | 75 | 9
 |  | 16 | 80 | 10
 |  | 17 | 85 | 11
 |  | 18 | 90 | 12
 |  | 1* | 95 | 13
 | State Average | 12 | 50 | 6
Spreadsheet: 820531d1678148322-xlookp-vlookup-with-2-criteria-sample15
Sheet: Sheet1

 |  |  |  |  |  | Asset 1 Payment | -2500
 |  |  |  |  |  | Asset 2 Payment | -3000 |  | Answers
 |  |  |  |  |  |  | Asset 1 | Asset 2 | Asset 1 | Asset 2
 | Date | Asset | Payment | TX ID |  | Jan |  |  | -2500 | -3000
 | 2023-01-02 00:00:00 | Asset 1 | -2500 | r182 |  | Feb
 | 2023-01-03 00:00:00 | Asset 2 | -3000 | f763 |  | Mar
 | 2023-02-01 00:00:00 | Asset 1 | -2500 | ma82 |  | Apr
 | 2023-02-02 00:00:00 | Asset 2 | -3000 | 718i |  | May
 | 2023-03-02 00:00:00 | Asset 1 | -2500 | p917 |  | Jun
 | 2023-03-03 00:00:00 | Asset 2 | -3000 | n739 |  | Jul
 |  |  |  |  |  | Aug
 |  |  |  |  |  | Sep
 |  |  |  |  |  | Oct
 |  |  |  |  |  | Nov
 |  |  |  |  |  | Dec
Spreadsheet: 101037d1299191278-multiple-data-tables-link-and-calculate-onto-target-tables-test2
Sheet: Sheet1

Annual Energy Tracking |  |  |  |  |  |  |  |  |  |  |  | Report Period |  |  |  | May |  | 2010
2005 Baseline |  |  |  |  |  |  |  |  | Target Annual MMBTU
2010 History
 |  |  |  | Total Gas, MCF |  | Total Elec, kWh |  | Total MMBTU
2005 Baseline
2015 Goal
2010 Usage
2010 vs 2015 Goal Variance
 |  | 2015 GOAL |  | IF CELL Q1=MONTHX, SUM [NAME] THRU MONTHX |  |  |  |  |  |  |  |  |  |  | Monthly MMBTU
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 2015 Goal | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  | 2010 | YTD Cumulative Tracking, MMBTU |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  | Total Gas, MCF |  | Total Elec, kWh |  | Total MMBTU |  |  |  |  |  | July
2015 Goal |  |  |  |  |  |  |  |  |  |  |  |  |  | August
2011 Current |  |  |  |  |  |  |  |  |  |  |  |  |  | September
[NAME], +/- % |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dummy data linked to respective cells in given timeframe for testing purposes only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need to match cell C22 to cells [NAME]:AA17, and take the column for the matching cell to be the column for the vlookup.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | want to sum(cell NN##:cell MM##)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual CDD | Annual HDD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TBD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MMBTUH/MCF | 1.02
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Tenant Grading

 | Credit Grading - Tenant Grade
 | Borrower
 | Tenant
 | Property
 |  |  |  |  | Raw score | Weighting factor | Weighted score
 | Rent arrears in last 36 months |  |  |  | 2 | 3
 | Significant (-1); No History (0); Minor (+1); No arrears (+2)
 | Experian score |  |  |  | 2 | 2
 | <40 & no mitigation (-1); No History (0); <40 & satisfactory mitigation (+1); >40 (+2)
 | Rent v ERV |  |  |  | 0 | 1
 | >10% overrented (-1); within 10% of ERV (0); >5% underrented (+1); >10% underrented (+2)
 | Occupational history |  |  |  | 2 | 1
 | Not yet occupying (-1); <1 year (0); <5 years (+1); <10 years (+2)
 | Tenant media / search |  |  |  | 2 | 1
 | Adverse (-1); No history (0); Neutral history (+1); Positive (+2)
 | Overall weighted tenant grade
 | Additional comments:
 | Weighted Average Rating |  | Rating | Rent | Weighting | W.A.R.
 |  | 1 | 1.75 | 520000
 |  | 2
 |  | 3
 |  | 4
 | Grade | Grading descriptor
 | ≥1 | Strong |  | [NAME]: | 1.75
 | ≥0.5 | Good |  | Descriptor: | Strong
 | ≥0 | Satisfactory |  | Prepared by: | [NAME]
 | <0 | Weak |  | Date: | 2018-04-17 00:00:00
 | Defaulted | Default
 | Tenant Weightings: Tenant gradings should be weighted in proportion to their rental income
 | Residential Tenancies: a default grade of 0.5 (good) should be used for residential tenancies
Spreadsheet: cooper_richey__4030__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 22  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 29.75 | 30.25
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 28.75 | 29.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 28.25 | 29.5
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 28 | 29
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 28 | 29
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 28 | 29
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 32 | 33
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 32 | 33
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 32 | 33
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 35.25 | 36.25
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 35.25 | 36.25
 |  | DEC | 33.3 |  |  |  | DEC | 35.25 | 36.25
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 751161d1633942955-number-of-values-within-each-closed-interval-example
Sheet: Sheet1

15.0225 | 31.8477 | 29.6444 | 18.4276 | 8.2123 | 9.4141 | 6.609900000000001 | 6.609900000000001 | 8.012 | 7.611400000000001 | 11.2168 | 11.2168
34.051 | 35.2528 | 19.8297 | 7.611400000000001 | 5.0075 | 6.4096 | 4.6069 | 26.4396 | 25.0375 | 15.4231 | 21.6324 | 31.2468
26.4396 | 36.054 | 21.6324 | 9.4141 | 9.2138 | 11.2168 | 14.6219 | 19.6294 | 15.4231 | 12.6189 | 12.6189 | 15.6234
44.8672 | 46.66990000000001 | 38.2573 | 22.8342 | 35.4531 | 13.4201 | 54.68190000000001 | 36.054 | 11.4171 | 9.6144 | 9.8147 | 11.8177
46.66990000000001 | 55.4831 | 37.8567 | 26.2393 | 13.4201 | 10.2153 | 19.2288 | 25.8387 | 16.024 | 11.2168 | 9.8147 | 14.2213
Expected solution below
Start of interval | End of interval | Number of values from Rows 1-5 that are within each closed interval
48.21507142857143 | 55.4831 | 2 | (2 values are between the closed interval of 48.21507143 and 55.4831), by closed interval the upper and lower limits are included as well
40.9470428571429 | 48.21507142857143 | 3 | (3 values are between the closed interval of 40.[PHONE] and 48.21507143), by closed interval the upper and lower limits are included as well
33.67901428571428 | 40.94704285714285 | same rule as above
26.41098571428571 | 33.67901428571428 | same rule as above
19.14295714285714 | 26.41098571428571 | same rule as above
11.87492857142856 | 19.14295714285714 | same rule as above
4.6069 | 11.87492857142856 | same rule as above
My attempt
Start of interval | End of interval | Number of values from Rows 1-5 that are within each closed interval
48.21507142857143 | 55.4831 |  | (2 values are between the closed interval of 48.21507143 and 55.4831), by closed interval the upper and lower limits are included as well
40.9470428571429 | 48.21507142857143 |  | (3 values are between the closed interval of 40.[PHONE] and 48.21507143), by closed interval the upper and lower limits are included as well
33.67901428571428 | 40.94704285714285
26.41098571428571 | 33.67901428571428
19.14295714285714 | 26.41098571428571
11.87492857142856 | 19.14295714285714
4.6069 | 11.87492857142856
Spreadsheet: 674313d1587751555-frequency-formula-with-criteria-when-filtered-test
Sheet: Sheet5

 | 157503 | 2209254 | SY RL17 SHP 350ml Repair Total Renew7 TH
 | 157506 | 2209251 | SY RL17 SHP [NAME] IntensiveTH
 | 157504 | 2209253 | SY RL17 CON 350ml Repair Total Renew7 TH |  |  |  | 8150029084 | 5
 | 179752 | 2209255 | Syoss Oleo 12 Intense Care Conditioner 450 ml |  |  |  | 8150030797 | 5
 | 206654 | 2308780 | 2016 EC P&P Conditioner 400ML TH |  |  |  | 8150024062 | 5
 | 205089 | 2205492 | IG NATURALS 2-0 NATURAL BLACK |  |  |  | 8150000446 | 2 | **
 | 205090 | 2205493 | IG NATURALS 3-0 DARK BROWN |  |  |  | 8150029095 | 5
 | 216601 | 2240250 | Igora Colors 6-68 Light Chocolate |  |  |  | 8150014758 | 3
 | 216602 | 2240251 | Igora Colors 6-88 Berry Red |  |  |  | 8150019605 | 3
 | 179751 | 2209256 | SY RL17 SHP 350ml Oleo12 Intense Care TH |  |  |  | 8150021085 | 1
 | 195022 | 2454629 | 'EC RL16 CON 400ml Hydro [NAME] |  |  |  | 8150019132 | 1
 | 214857 | 2446151 | EC CON 400ml 8 Precious Oil TH |  |  |  | 8150028620 | 2
 | 218420 | 2308238 | EC Serum Deep Repair Conditioner 400ml |  |  |  | 8150015422 | 4
 | 191032 | 2367061 | Taft Shine Spray 250ml.
 | 205091 | 2205491 | IG NATURALS 4-68 CHOCOLATE
 | 216603 | 2240252 | Igora Colors 8-1 Dark Ash Blonde
 | 205088 | 2065181 | Taft Volume Powder
 | 214855 | 2367644 | TAFT POWER STYLING GEL  MEGA STRONG
 | 205092 | 2205489 | IG NATURALS 5-0 LIGHT BROWN
 | 191026 | 2027159 | Syoss Color OLEO 5-0
 | 191030 | 2344155 | TAFT ULTRA MOUSSE 150 ML 6
 | 193070 | 1896305 | N&E 5.05 GOLDEN LIGHT BROWN
 | 201102 | 2070194 | Syoss Silicone Free Moisture Conditioner 500 ml
 | 216604 | 2240253 | Igora Colors 10-1 Titanium Blonde
 | 221601 | 2302736 | Igora Colors 5-5 Cacao
 | 221602 | 2302734 | Igora Colors 6-0 Dark Blonde
 | 221603 | 2302732 | Igora Colors 6-65 Nougat
 | 218422 | 2342370 | EC Airy Biotin Conditioner 400ml
 | 214856 | 2446114 | EC RL19 SHP 400ml 8 Precious Oil TH
 | 202821 | 1498421 | TAFT FULL ON ROUGH&TOUGH STYLING POWDER
 | 221604 | 2302729 | Igora Colors 7-1 Cool Middle Blonde
 | 214858 | 2367067 | Taft RL18 Gel 150ml Super Glue TH
 | 226157 | 2267183 | Taft Power Active Power Gel 150ml
 | 201101 | 2069548 | Syoss Silicone Free Moisture Shampoo 500 ml
 |  |  |  |  |  | 27 | Foodland | 2167423 | 8150016327 | 28.09.18 | 1 | 04465 | 165.85 | Damaged Goods.(RTV.90024582) | Rungsinee | 93XSTH0018 | 29.04.19
Spreadsheet: 577998d1528896875-formular-for-cost-of-individual-sold-item-using-fifo-fifo
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 128870d1321313476-help-with-rota-roster-spreadsheet-sample-rota
Sheet: Rota

 |  | Mon |  |  | Tue |  |  | Wed |  |  | Thu |  |  | Fri |  |  | Sat |  |  | Sun |  |  | Service User Comments
 |  | 2011-12-08 00:00:00
 | Service User 1 | 13:00:00 | - | 22:00:00 | 09:00:00 | - | 16:00:00 | 00:00:00 | - | 00:00:00 | 13:00:00 | - | 22:00:00 | 14:00:00 | - | 20:00:00 | 13:00:00 | - | 22:00:00 |  | -
 |  | Staff 1 |  |  | Staff 1 |  |  |  |  |  | Staff 2 |  |  | Staff 3 |  |  | Staff 1
 | Service User 2 |  | - |  | 10:00:00 | - | 16:00:00 | 13:00:00 | - | 22:00:00 |  | - |  |  | - |  | 09:00:00 | - | 16:00:00 | 13:00:00 | - | 22:00:00
 |  |  |  |  | Staff 2 |  |  | Staff 1 |  |  |  |  |  |  |  |  | Staff 2 |  |  | Staff 3
 | Service User 3 | 09:00:00 | - | 18:00:00 | 09:00:00 | - | 13:00:00 | 09:00:00 | - | 16:00:00 | 14:00:00 | - | 20:00:00 |  | - |  |  | - |  |  | -
 |  | Staff 3 |  |  | Staff 3 |  |  | Staff 3 |  |  | Staff 3
 | Staff Comments -            S = Supervision T = Training TM = Team Meeting AL = Annual leave
 | Transport Information
Spreadsheet: 165875d1341381090-excel-2007-conditional-formatting-not-doing-anything-on-some-cells-footy-tipping-2012-removed-data
Sheet: Ladder

ID | LW | Pos | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | TOTAL | MARGIN | AVE
USERID 1 | 1 | 1 | NAME 1 | 5 | 4 | 4 | 4 | 3 | 6 | 6 | 7 | 7 | 3 | 8 | 4 | 5 | 4 | 3 | 5 | 4 | 82 | 188 | 4.82
USERID 2 | 2 | 2 | [NAME] 2 | 7 | 4 | 4 | 5 | 4 | 6 | 5 | 6 | 4 | 3 | 8 | 4 | 4 | 4 | 3 | 4 | 4 | 79 | 192 | 4.65
USERID 3 | 3 | 3 | NAME 3 | 4 | 5 | 3 | 5 | 5 | 5 | 7 | 7 | 6 | 3 | 4 | 5 | 4 | 3 | 4 | 4 | 3 | 77 | 189 | 4.53
USERID 4 | 5 | 4 | NAME 4 | 4 | 3 | 3 | 5 | 4 | 5 | 7 | 6 | 7 | 4 | 4 | 4 | 4 | 3 | 4 | 5 | 4 | 76 | 162 | 4.47
USERID 5 | 6 | 5 | NAME 5 | 6 | 4 | 4 | 5 | 3 | 4 | 6 | 6 | 5 | 3 | 4 | 4 | 5 | 3 | 5 | 5 | 3 | 75 | 184 | 4.41
USERID 6 | 4 | 6 | NAME 6 | 1 | 5 | 4 | 3 | 3 | 5 | 7 | 7 | 5 | 2 | 5 | 4 | 5 | 4 | 4 | 9 | 2 | 75 | 185 | 4.41
USERID 7 | 8 | 7 | NAME 7 | 3 | 6 | 5 | 6 | 3 | 6 | 5 | 5 | 5 | 3 | 4 | 4 | 4 | 4 | 5 | 3 | 4 | 75 | 192 | 4.41
USERID 8 | 7 | 8 | [NAME] 8 | 3 | 3 | 4 | 2 | 4 | 4 | 6 | 10 | 7 | 3 | 4 | 5 | 5 | 3 | 5 | 4 | 3 | 75 | 237 | 4.41
USERID 9 | 9 | 9 | NAME 9 | 4 | 4 | 4 | 5 | 2 | 5 | 7 | 5 | 5 | 3 | 4 | 4 | 5 | 4 | 4 | 5 | 3 | 73 | 217 | 4.29
USERID 10 | 10 | 10 | NAME 10 | 3 | 2 | 5 | 5 | 3 | 5 | 4 | 6 | 10 | 3 | 3 | 5 | 5 | 3 | 2 | 4 | 3 | 71 | 222 | 4.18
USERID 11 | 11 | 11 | NAME 11 | 6 | 3 | 5 | 6 | 2 | 4 | 6 | 6 | 4 | 3 | 1 | 4 | 5 | 4 | 4 | 4 | 1 | 68 | 201 | 4
USERID 12 | 12 | 12 | NAME 12 | 2 | 2 | 3 | 4 | 6 | 6 | 3 | 6 | 5 | 2 | 3 | 4 | 4 | 5 | 3 | 6 | 3 | 67 | 166 | 3.94
USERID 13 | 13 | 13 | NAME 13 | 3 | 4 | 3 | 3 | 4 | 2 | 7 | 5 | 3 | 3 | 2 | 4 | 5 | 4 | 3 | 9 | 2 | 66 | 170 | 3.88
USERID 14 | 14 | 14 | NAME 14 | 3 | 5 | 3 | 5 | 4 | 5 | 3 | 6 | 4 | 3 | 3 | 4 | 4 | 4 | 5 | 3 | 2 | 66 | 192 | 3.88
USERID 15 | 15 | 15 | NAME 15 | 4 | 4 | 3 | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 3 | 5 | 5 | 3 | 3 | 4 | 2 | 65 | 221 | 3.82
USERID 16 | 16 | 16 | [NAME] 16 | 2 | 4 | 3 | 3 | 4 | 5 | 4 | 5 | 4 | 2 | 3 | 4 | 5 | 3 | 2 | 6 | 2 | 61 | 227 | 3.59
USERID 17 | 17 | 17 | [NAME] 17 | 4 | 4 | 3 | 4 | 2 | 7 | 4 | 6 | 4 | 1 | 2 | 3 | 5 | 4 | 3 | 2 | 3 | 61 | 240 | 3.59