tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805337d1668627311-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022-v2
Sheet: Test Template

Material Cost
 |  | Price per unit |  |  |  |  |  |  | Primary Wood | Nogal USA
 |  |  |  |  |  |  |  |  | Secondary Wood | [NAME]
 |  |  |  |  |  |  |  | Final Dimensions
Drawer runners | 3 | 18
Tooling | 1 | 35 |  |  |  |  |  | Wood | Element | Quantity | Length | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 1st | Top/Bottom | 1 | 1.9 | 1.4 | 0.045
Labor Cost |  |  |  |  |  |  |  | 1st | Walls | 2 | 0.8 | 0.8 | 0.03
Time |  | Price per minute |  |  |  |  |  | 1st | Back | 1 | 3 | 0.8 | 0.01
Processing |  | 5 |  |  |  |  |  | 1st | Legs | 4 | 0.5 | 0.05 | 0.05
Cutting All pieces | 3 | 40 |  |  |  |  |  | 2nd | Sttrecther | 2 | 2.8 | 0.1 | 0.05
Drawers | 6 | 40 |  |  |  |  |  | 1st | Rails | 2 | 0.8 | 0.05 | 0.05
Glue up | 6 | 30 |  |  |  |  |  | 1st | Seperations | 2 | 0.8 | 0.8 | 0.02
Sanding | 5 | 30 |  |  |  |  |  | 1st | Doors | 3 | 1 | 0.8 | 0.02
Finish | 10 | 20
Assemply and cutting joints | 4 | 40
Delivery | 0 | 350 |  |  | RAW LUMBER
Stacking | 0 | 100
 |  | Total |  |  |  |  |  |  | length | thickness | width | quantity | m2 | m3 | Price/m3 | Price | [NAME]
Shop Costs |  | 14 |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Construction Total |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Profit |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  | 0
 |  | Total |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  | 0
 |  | IVA |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
Spreadsheet: 887739d1738067727-check-list-for-advanced-doubles-check-list-for-advanced-doubles-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | An item nr can appear in multiple Pos nr, that's normal.
 |  |  |  |  |  |  |  |  |  |  | A code can appear in multiple items. It is not desired but it's not a problem.
 |  |  |  |  |  |  |  |  |  |  | The problem is when two identical item have different code.
 |  |  |  |  |  |  |  |  |  |  | I need to indicate or make a list of the rows where or item no's that are the same but have different code.
 |  | Pos | Item | Code | Desired output | zbor
 |  | H1 | 1 | A | Ok
 |  | H2 | 2 | B | H2, H5, H9
 |  | H3 | 4 | D | Ok
 |  | H4 | 4 | D | Ok
 |  | H5 | 2 | A | H2, H5, H9
 |  | H6 | 6 | F | H6, H10
 |  | H7 | 7 | G | Ok
 |  | H8 | 8 | H | Ok
 |  | H9 | 2 | B | Ok
 |  | H10 | 6 | J | H6, H10
 |  | H11 | 4 | D | Ok
Spreadsheet: 676767d1588959719-lookup-groupmembers-and-sum-a-groups-amount-2020-05-08-oeldere2-sealpino-pt-676763d1588958652-lookup-groupmembers-and-sum-a-groups-amount
Sheet: Blad1

 | group | type | worth | Vlookup |  |  | results to be |  |  |  | Rijlabels | Som van worth |  |  | abc10-djfsd | group 1
 |  | abc10-djfsd | 30 |  |  | Group | abc10 | 70 |  |  | abc1 | 70 |  |  | [NAME] | group 1
 |  | [NAME] | 40 |  |  | Group | adc10 | 90 |  |  | adc1 | 90 |  |  | adc10-ddsg42t56 | group 2
 |  | adc10-ddsg42t56 | 40 |  |  | Group | wet20 | 80 |  |  | wet2 | 80 |  |  | adc10-flgro02wr543 | group 2
 |  | adc10-flgro02wr543 | 50 |  |  | Group | gre20 | 100 |  |  | gre2 | 100 |  |  | wet20-34mvkfgkrt4 | group 3
 |  | wet20-34mvkfgkrt4 | 20 |  |  | Group | abc30, abc31 | 50 |  |  | abc3 | 50 |  |  | wet20-dlfk0934 | group 3
 |  | wet20-dlfk0934 | 60 |  |  | Group | dam30, dam31 | 30 |  |  | [NAME] | 30 |  |  | gre20-fsdgtgtdr65 | group 4
 |  | gre20-fsdgtgtdr65 | 40 |  |  |  |  |  |  |  | Eindtotaal | 420 |  |  | [NAME] | group 4
 |  | [NAME] | 60 |  |  | For example: |  |  |  |  |  |  |  |  | abc30-ksfgksg043 | group 5
 |  | abc30-ksfgksg043 | 20 |  |  | All rows in"C" with [NAME]…. Should be accumulated to a sum |  |  |  |  |  |  |  |  | abc31-jsdfgksder | group 5
 |  | abc31-jsdfgksder | 30 |  |  |  |  |  |  |  |  |  |  |  | dam30-djkdf93f39f | group 6
 |  | dam30-djkdf93f39f | 10 |  |  |  |  |  |  |  |  |  |  |  | dam31-fdsksd9034 | group 6
 |  | dam31-fdsksd9034 | 20
This table can be up to 100 rows as [NAME] |  |  |  |  |  |  |  |  |  |  | Rijlabels | Som van worth
with a great mix in product codes |  |  |  |  |  |  |  |  |  |  | group 1 | 70
but can be defined in groups. |  |  |  |  |  |  |  |  |  |  | abc10-djfsd | 30
I want to see a list how much in each group |  |  |  |  |  |  |  |  |  |  | [NAME] | 40
 |  |  |  |  |  |  |  |  |  |  | group 2 | 90
 |  |  |  |  |  |  |  |  |  |  | adc10-ddsg42t56 | 40
 |  |  |  |  |  |  |  |  |  |  | adc10-flgro02wr543 | 50
 |  |  |  |  |  |  |  |  |  |  | group 3 | 80
 |  |  |  |  |  |  |  |  |  |  | wet20-34mvkfgkrt4 | 20
 |  |  |  |  |  |  |  |  |  |  | wet20-dlfk0934 | 60
 |  |  |  |  |  |  |  |  |  |  | group 4 | 100
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  | gre20-fsdgtgtdr65 | 40
 |  |  |  |  |  |  |  |  |  |  | group 5 | 50
 |  |  |  |  |  |  |  |  |  |  | abc30-ksfgksg043 | 20
 |  |  |  |  |  |  |  |  |  |  | abc31-jsdfgksder | 30
 |  |  |  |  |  |  |  |  |  |  | group 6 | 30
 |  |  |  |  |  |  |  |  |  |  | dam30-djkdf93f39f | 10
 |  |  |  |  |  |  |  |  |  |  | dam31-fdsksd9034 | 20
 |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 420
Spreadsheet: 717767d1612843620-i-need-to-use-a-vlookup-that-depends-on-the-date-i-select-to-chose-the-values-data-test-1
Sheet: Sheet1

Week Commencing 7/02/2021
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | Contract | 2021-02-07 00:00:00 |  |  |  |  |  |  | COMMENTS
TEST 1 | Sun - Thur | Y | Y | Y | Y | Y |  | Y
TEST 2 | Sun - Thur | Y | Y | Y | Y | Y |  | Y
TEST 3 | Sun - Thur | Y | Y | Y | Y | Y |  | Y
TEST 4 | Mon - Fri |  | Y | Y | Y | Y | Y | Y
TEST 5 | Mon - Fri |  | Y | Y | Y | Y | Y | Y
TEST 6 | Mon - Fri | Y | Y | Y | Y | Y | Y | Y
TEST 7 | Mon - Fri |  | Y | Y | Y | Y | Y | Y
TEST 8 | Mon - Fri |  | AFT | AFT | AFT | AFT | AFT
TEST 9 | Mon - Fri |  | Y | Y | Y | Y | Y | Y
TEST 10 | Mon - Fri |  | H | H | H | H | H | Y
TEST 11 | Sun / Mon / Tue | Y | Y | Y
TEST 12 | Fri / Sun | Y |  |  |  |  | Y
TEST 13 | Sun - Thur | Y |  |  | Y | Y | Y | Y
TEST 14 | Mon - Fri | Y | Y | Y | Y | Y | Y | Y
TEST 15 | Mon - Fri | Y | Y | Y | Y | Y | Y | Y
Employed total | Total
Ashley / Simon (BC)
 | Best Connection
TEST 16 | Best Connection | Y | Y | Y | Y |  | Y
TEST 17 | Best Connection | Y | Y | Y | Y | Y | Y
Omega / Tori (TRC)
TEST 18 | TRC | Y | Y |  | Y | Y | Y
 | TRC
TEST 19 | TRC |  |  | Y | Y |  | Y
Lewis / Dave (Staff)
TEST 20 | Staff UK | Y | Y | Y |  | Y | Y
[NAME] (Huntsman)
 | Huntsman
Catherine (Syft)
 | Syft
 | Syft
 | Syft
Rebecca (WRC)
TEST 21 |  | Y | Y |  | Y |  | Y
TEST 22 |  | Y |  | Y | Y | Y | Y
TEST 23 |  | Y | Y | Y |  | Y | Y
 |  | Y | Y | Y | Y | Y
TEST 24 |  | Y | Y | Y |  | Y | Y
total staff
staff required |  | 18 | 19 | 19 | 18 | 18 | 18 | 12
difference
Forecast |  | 12602 | 14281 | 13924 | 13623 | 12970 | 13369
Spreadsheet: 708259d1607697865-non-consecutive-count-sample-workbook
Sheet: Interruption

Number of interruptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of hours lost
 | STATUS | MAX LOAD | AVG LOAD | EF | BF | RF | DC | IMB | OC | EMG | LS | SG | LSG | NS | SS | TOTAL | EF | BF | RF | DC | IMB | OC | EMG | LS | S.G | LSG | TX LIMT | SS | TOTAL
ALUU | ACTIVE | 7 | 2.3 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0
CHOBA | ACTIVE | 9 | 2.383333333333333 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0
RUMUEKINI | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SARS RD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
ADP | ACTIVE | 38 | 3.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
MARKET ROAD | ACTIVE | 32 | 4.199999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 8 | 5
OPM | ACTIVE | 39 | 2.528571428571428 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 8 | 1
SHELL ESTATE | ACTIVE | 83 | 0.4466666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1
PIPE LINE | ACTIVE | 47 | 2.722222222222222 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 8 | 1
AIRPORT | ACTIVE | 91 | 0.9608695652173914 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
IGWURITA | INACTIVE
IGWURUTA ROAD | ACTIVE | 21 | 4.74 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 11 | 6
ELIMGBU | ACTIVE | 19 | 4.45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 11 | 6
MBAK | ACTIVE | 38 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
IDORO ROAD | ACTIVE | 37 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
AKA ROAD | ACTIVE | 43 | 4.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 4
IBB AVENUE | ACTIVE | 38 | 3.933333333333334 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
INDONGESIT NKANGA | ACTIVE | 114 | 0.2055555555555556 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5
SIR UDO UDOMA | ACTIVE | 46 | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
Spreadsheet: 63739d1264612985-sumif-formula-multiple-criteria-febuary-2010-dispatch
Sheet: loc summary

Locations
 |  |  |  | NL | f10 | SNL | f10 | PNL | f10 | DS2 | [NAME] |  | DS1 | DSR1 |  | total
 | 426
 | 457
 | 470
 | sunshine stn.
 | Happy endings
 | 433
 | 444
 | Allard's
 | PBG
 | crossroads
 | [NAME]
 | GCM
 | Friendly's
 | [NAME]'s Valley
 | Big Sky
 | H&R #1
 | RHJ #1
 | 25001
 | Wheat MT
 | Big Hole
Spreadsheet: 99362d1297997242-help-making-a-bar-chart-with-whiskers-bar-chart-data
Sheet: Sheet1

Normal HR ([NAME]) | Short HR ([NAME]) | Long HR ([NAME])
180 | 162 | 168
146.3 | 121.2 | 164.4
168 | 180 | 162
173.9 | 171.43 | 166.67
130.4 | 176.47 | 148.15
156 | 162 | 156
146.3 | 133.33 | 153.85
175.041 | 179.1 | 174.23
187.5 | 88.88 | 184.6
142.86 | 134.83 | 169.01
144.6 | 162.1621621621622 | 148.15
171.4285714285714 | 171.4 | 162.1621621621622
164.4 | 171.4 | 181.8
170.39 | 154.6 | 171.42
171.4 | 160 | 181.8
153.4 | 136.3636363636364 | 166.34
171.43 |  | 164.38
166.6666666666667 |  | 150
171.4285714285714
Spreadsheet: 786480d1657207682-preparing-spreadsheet-for-data-visualization-based-on-ethnic-demographic-shift-over-time-employee-demographics-copy
Sheet: summations

Ethnic Code | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
a
b
h
i
m
t
u
w
Spreadsheet: 125414d1319023705-lookup-with-multiple-criteria-on-multiple-tabs-indexmatch
Sheet: List

Column1
#1 Copper
#1 Insul. Copper wire
#1 Steel
#2 Copper
#2 Insul. Copper wire
#2 Steel
3003 Alum
5' Plate/Structural
5052 Alum
6061 Alum
6061 Alum Turnings
70/30 ADM
70/30 Clips
ACSR
[NAME]
AL-CU Radiator
Alternator
Alum Breakage
[NAME]
Alum Bumpers
Alum Busbar
Alum Cans
[NAME]
Alum Foil
Alum Fuel Tanks
[NAME]
Alum Radiators
Alum Rims
Alum Siding
Alum Signs
Alum Transformer (Case)
Alum Transformer (No Case)
Alum Turnings
Auto Cast
Auto Radiator
Ballast
Bare Bright Copper
[NAME]
Batteries
Black CATV
[NAME]
[NAME]
[NAME]
Busheling
Carbide
Cardboard
Cars
Cast Aluminum
Cast Iron
Chargers
[NAME]
Christmas Lights
Compressors
Concrete Forms
Converters
Copper Bearing
Copper Busbar
Copper Helix
Copper Transformer (Case)
Copper Transformer (No Case)
Copper Turnings
Die Cast
E Scrap
EC Wire
EDM Wire
Electric Motors
Extrusion
Freight
[NAME]
[NAME]
[NAME]
Inconel
[NAME]/ACSR
[NAME]
Jelly Wire
Lead
Lead Coated Cu
Low Grade Wire
HB Cast Iron
Magnesium
[NAME]
[NAME]
[NAME]
Mixed Iron
[NAME]
[NAME]
MLC with Poly
Moly
New Cast Aluminum
New Extrusion
New Pro Painted Extrusion
Newspaper
Nickel
Painted MLC
Painted Siding
Phos Bronze
Plastics
Radiator Ends
Rail
Range Lead
Rebar
Red Brass
Sheet Aluminum
Sheet Copper
Sheet Iron
Soft Lead
Stainless (304)
Stainless (316)
Stainless (400)
Stainless Turnings
Starter
Stators
Steel Cased Batteries
Steel Turnings
Tin
Titanium
Tool Steel
Torching
Transmissions
Unc. [NAME]
Unc. [NAME]
Unc. [NAME]
Unc. AL/CU Radiators
Unc. [NAME]
Unc. Auto Radiators
Unc. Brass
Unc. Copper
Unc. Copper Turnings
Unc. Extrusion
Unc. Lead
Unc. Motor Blocks
Unc. Sheet
Unc. Stainless
Unc. Stainless Turnings
Unprepared Plate/Structural
Wheel Weights
Wire Harness
[NAME]
Yellow Brass Turnings
Zinc
Spreadsheet: 482340d1475019914-new-empty-table-for-each-element-of-dropdown-list-new-city-example
Sheet: Sheet1

New York
 |  | 2011 | 2012 | 2013 | 2014
Population
 | Population | 19.52 | 19.61 | 19.7 | 19.75
 | % under | 8.2 | 8.4 | 8.3 | 8.3
Economy
 | Average Wage (wkly) | 2690 | 2770 | 2780 | 2820
 | Average Rent (mothly) | 2710 | 2760 | 2803 | 2834
 | % with out a job | 8.2 | 8.5 | 7.5 | 6.2
Spreadsheet: 713120d1610558260-create-a-spreadsheet-with-drop-down-yes-no-rental-spreadsheet-blank
Sheet: Sheet1

PROPERTY | TENANT | DEPOSIT AMOUNT | RENT | MANAGEMENT FEE | RENT GUARANTEE FEE | DUE DATE | PAYMENT TO LANDLORD | PAYMENT RECEIVED | PAYMENT SENT | Rent Guarantee | RENT GUARANTEE SHARE | NIL DEPOSIT SHARE
10 Montrose Street | [NAME] | 500 | 500 | 0.1 | 0 | 1st | 450 | Yes
2 Dean Court F0/2 | [NAME] | 500 | 500 | 0.1 | 0 | 1st | 450 |  | Yes
2 Barclay Street G/2 | [NAME]
14 Benbow Road | [NAME] +1
22 Wallace Street F2/1 | [NAME]
8 Irving Quadrant F5 | Beata Edina Csibi
5 Amisfield Street F2/2 | [NAME]
51 Hillend Crescent | [NAME]
6 Greenlaw Court F0/3 | [NAME]
230 Dumbarton Road F1/2 | [NAME]
15 Bell Street | [NAME]
110 Harefield Drive | MEARS
19 Greenlaw Road | MEARS
2073 Dumbarton Road | MEARS
11 Balmartin | MEARS
2505 Dumbarton Road | MEARS
46 Bulldale Street | MEARS
8 Greenlaw Road | MEARS
3 Dyke Road | MEARS
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-14

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-14 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F |  | July 4th Observed
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 120807d1315528227-excel-2007-how-do-i-combine-6-worksheets-into-one-mastersheet-in-the-same-workbook-pm-grade-2-literacy-6-classes-blank-template
Sheet: GR 2  TEACHER 5

Assessment | Decodables |  |  |  |  |  |  |  | ORF |  |  |  |  |  |  |  | AQPA Skills
 | End Benchmark Score = 72 (1st Grade) 2x Green move to ORF |  |  |  |  |  |  |  | Year End BM 75% Score = 117 2 scores at 117 = May discontinue ORF |  |  |  |  |  |  |  | Long Vowels | PM1 | PM2 | PM3 | Cons. Blends | PM1 | PM2 | PM3 | Vow. Var. | PM1 | PM2 | PM3 | Diphtong | PM1 | PM2 | PM3 | Schwa a | PM1 | PM2 | PM3 | Silent Letters | PM1 | PM2 | PM3 | Hard Soft g/c | PM1 | PM2 | PM3 | [NAME] | PM1 | PM2 | PM3 | -ge/-dge | PM1 | PM2 | PM3
Seasonal BM | N/A |  |  |  |  |  |  |  | 51 |  |  | 72 |  |  |  | 89 | 31 |  |  |  | 39 |  |  |  | 27 |  |  |  | 15 |  |  |  | 14 |  |  |  | 13 |  |  |  | 13 |  |  |  | 33 |  |  |  | 11
Student Name | F | P1 | P2 | W | P3 | P4 | P5 | S | F | P1 | P2 | W | P3 | P4 | P5 | S | ** BM Scores reflect 80% Mastery of Individual Sections
 | Decodables & AQPA
 |  | Below = PM |  |  |  |  |  |  |  | 75th %tile |  |  |  | Below = PM
 |  | Met BM |  |  |  |  |  |  |  | ORF-Met BM
Spreadsheet: 35081d1232584916-changing-sheet-name-reference-automatically-purchases-compilation-autosaved-
Sheet: FMA

 |  | PUB NAME |  |  |  |  | PERIOD
 | PERIOD CASH SALES TARGET
 | TARGET GP% TO ACHIEVE
 | WET/DRY SPLIT | WET | DRY
 |  | 1
 | PERIOD DRY SALES TARGET | 0
 | WEEK | 1 | 2 | 3 | 4 | PERIOD TOTAL
 | SALES TARGET | 0 | 0 | 0 | 0 | 0
 | ACTUAL SALES |  |  |  |  | 0
 | SALES VARIANCE | 0 | 0 | 0 | 0 | 0
 | ALLOWABLE PURCHASES | 0 | 0 | 0 | 0 | 0
 | ACTUAL PURCHASES | 132 | 0 | 0 | 0 | 132
 | REMAINING TO SPEND | -132 | 0 | 0 | 0 | -132
 | CURRENT GP% ACHIEVED | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | PURCHASE BREAKDOWN | WEEK 1 |  | WEEK 2 |  | WEEK 3 |  | WEEK 4 |  | TOTALS
 |  | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | %
 | FAIRFAX | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 44 | 0.3333333333333333
 | M+J SEAFOODS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | 0
 | FRESH DIRECT | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 22 | 0.1666666666666667
 | WEST COUNTRY | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 22 | 0.1666666666666667
 | HOPWELLS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | 0
 | 3663 | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 44 | 0.3333333333333333
 | OTHER SUPPLIERS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 132 | 1
Spreadsheet: 824171d1680349435-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator-ans2
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed
Shortages |  | Fixed Deduction | Rate on Excess | Rates
 |  |  |  |  |  |  | Verify |  |  | Shortage | Deduction
0 | 200 | 200 | 0 | E200 + 0% of the excess of 0 |  |  | 0 |  |  | 1000
200 | 250 | 200 | 0.09 | E200 + 0% of the excess of 200
250 | 300 | 200 | 0.08 | E200 + 0% of the excess of 250
300 | 350 | 200 | 0.07 | E200 + 0% of the excess of 300
350 | 400 | 200 | 0.06 | E200 + 0% of the excess of 350
400 | 450 | 200 | 0.05 | E200 + 0% of the excess of 400
450 | 500 | 200 | 0.04 | E200 + 0% of the excess of 450
500 | 550 | 200 | 0.03 | E200 + 0% of the excess of 500
550 |  | 200 | 0.02 | E200 + 0% of the excess of 550
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction
200 |  |  | 0 |  | 200
250 | 200 | 50 | 0.09
350 | 200 | 150 | 0.06
450 | 200 | 250 | 0.04
 | 200 | excess of 200 | 0.02
Spreadsheet: 111713d1308046212-count-multiple-criteria-multiple-sheets-and-date-range-report-template
Sheet: Report

 | Period 1 |  |  |  |  | Period 2
Registrations | Week 1 | Week 2 | Week 3 | Week 4 | PERIOD END | Week 1 | Week 2 | Week 3 | Week 4 | PERIOD END
Total received for registration | 6 | 6 | 0 | 0 | 12
Received - Priority 1's
Received - Priority 2 & 3's
Processed - Priority 1's
Processed - Priority 2 & 3's
Processed - Total
Priority 1's processed within SLA (5 days)
Priority 2's & 3's processed within SLA (20 days)
Spreadsheet: 677264d1589273765-inserting-a-new-line-but-vlook-up-dont-change-rates-sheet
Sheet: Sheet3

C10
Used for: Patio slabs, pathways and non-structural work
Type: Domestic & commercial use
C15
Used for: Pavement kerbs and floor blinding
Type: Domestic & Commercial
C20
Used for: Domestic floors and foundations (where the weight of structure will be lighter). Also good for workshop bases, garages, driveways and internal floor slabs.
Type: Domestic
C25
Used for: Construction in all areas. Multi-purpose concrete mix, usually used for foundations.
Type: Domestic & Commercial
C30
Used for: Pathways and roadways (this is the lowest grade concrete mix that can be used for this purpose). More durable than the grades that have come before, and thus is much more weather-resistant and can take heavy road traffic.
Type: Commercial
C35
Used for: Commercial structures. This heavy concrete mix is usually used for creating external walls and slabs, as well as for structural piling.
Type: Commercial
C40
Used for: Commercial construction sites, creating foundations and beams for structural support and roads. The most durable in this list, C40 can withstand chemical corrosion also, so is frequently used on farms where slurry could corrode structures, or in septic tanks.
Type: Commercial
Spreadsheet: 730961d1620070517-populating-cells-based-on-dependent-drop-down-lists-within-a-table-costing-sheet-v2
Sheet: Costing Sheet

Costing Sheet
Ingredient Type | Ingredient Description | Unit | Weight | Cost per Unit | Cost per Item | Total
Fruit | Orange | 2
Fruit | Apple | 1
Fruit | [NAME] | 3
Fruit | Lemon Juice |  | 50
Veg | Onion | 3
Veg | Carrot |  | 150
Veg | Swede | 2
Veg | Mushroom |  | 500
Meat | Beef - Topside |  | 1000
Meat | [NAME] | 2
Meat | Lamb - Leg |  | 1000
Meat | Pork - Rolled Loin |  | 1000
Spreadsheet: 151624d1335025739-excel-2007-help-with-spreadsheet-2012-dsis-by-month
Sheet: ROSTER

First | Last | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
[NAME] | Murdaugh
[NAME] | Ceasar
Lorenzo | [NAME]
[NAME] | Thompson
Viola | [NAME]
[NAME] | Alston
Leroy | Simpkins
Dennis | Gates
[NAME] | Coley
Forace | Burns
Calvin | Little
[NAME] | [NAME]
Shavonne | Gilyard
[NAME] | [NAME]
[NAME] | Price
[NAME] | Payne
Leonard | [NAME]
[NAME] | [NAME]
[NAME] | Harps
Lindsey | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Pixley
Jamone | Moore
[NAME] | Emanuel
[NAME] | [NAME]
[NAME] | Green
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Womack
Harlan | McMath
[NAME] | Philpot
[NAME] | Hankerson
[NAME] | Maynor
Spreadsheet: 269301d1381107165-multiply-countifs-by-value-in-different-column-of-same-row-sumiftodayindex
Sheet: Sheet1

 |  |  |  | Today's Summary
 |  |  |  | BO | A | T
Desired Results
 |  |  |  |  |  |  |  |  |  | I copied the data in oct 4 since you said today, so i used today fucntion
 |  |  |  |  |  |  |  |  |  | TODAY is
 |  |  | Qty | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00
 |  |  | 5 | BO | BO | BO | BO |  |  | BO
 |  |  | 1 | BO | BO | BO | A |  |  | A
 |  |  | 3 | BO | BO | A | A |  |  | A
 |  |  | 5 | BO | A | A | T |  |  | T