tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858852d1707369934-addition-of-points-that-meet-certain-conditions-x-country-results-sheet-2
Sheet: Points

 |  | PARTICIPATION POINTS
 |  | Give 1 point for each competitor
 |  | Tibro | Coochin | Coonowrin
Preps |  | 2 | 4 | 4
Yr 1 |  | 3 | 3 | 3 |  |  |  | Tibro | Coochin | Coonowrin
Yr 2 |  | 4 | 2 | 4 |  |  | TOTAL
Yr 3 |  | 3 | 1 | 5
Yr 4 |  | 2 | 3 | 4
Yr 5 |  | 3 | 3 | 4
Yr 6 |  | 4 | 1 | 5
 | Total
 |  |  |  |  |  |  |  | CHAMPIONS | RUNNER UP
 |  | Tibro | Coochin | Coonowrin
BOYS |  | 12 | 13 | 32
GIRLS |  | 12 | 11 | 21
Spreadsheet: a389502b-66d3-4979-aaac-f848c311e023
Sheet: 6-8 Sample

MENU - 6-8
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No |  |  | Decimal Equivalents
 |  | [NAME] |  | [NAME] |  | [NAME] Fish Nuggets |  | Cheese Pizza |  | Beef  Taco  Meat |  |  |  |  | 1/8 Cup | 0.125
 |  | [NAME] |  | [NAME] |  | [NAME] |  | with Whole Wheat Crust |  | on [NAME] |  |  |  |  | 1/4 Cup | 0.25
 |  | Sweet Potato Fries |  | Broccoli |  | Mashed Potatoes |  | Romaine Lettuce |  | Salsa |  |  |  |  | 3/8 Cup | 0.375
 |  | [NAME] |  | Carrots |  | Green Beans |  | Sliced tomato |  | [NAME] |  |  |  |  | 1/3 Cup | 0.333
 |  | [NAME] |  | Kiwi |  | Peaches |  | Pineapple |  | Corn |  |  |  |  | 1/2 Cup | 0.5
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Cantaloupe |  |  |  |  | 5/8 Cup | 0.625
 |  |  |  |  |  |  |  |  |  | Skim or 1 % |  |  |  |  | 2/3 Cup | 0.666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
Mt/MA (1 oz eq per day)  (9-10 oz eq per week) |  | 2.4 oz USDA deli turkey, .5oz cheese |  | 1/2 c. Teriyaki = 2 oz |  | 6 nuggets = 2.25 M/MA and 0.75 G/B |  | 1 sl =1.5 oz M/MA and 2 oz G/B |  | Taco meat- 2 oz |  |  |  |  | 7/8 Cup | 0.875
 |  | 2 | Oz Eq | 2 | Oz Eq | 2.25 | Oz Eq | 1.5 | Oz Eq | 2 | Oz Eq |  |  |  | 1 Cup | 1
Vegetables (3/4 Cup per day)      (3 3/4 Cup per week)
[NAME]  (1/2 Cup per week) |  |  |  | Broccoli - 1/2 c |  |  |  | Romaine - 1 c. |  |  |  |  |  |  | 1 cup leafy  greens  = 1/2 cup vegetable
 |  |  | Cup | 0.5 | Cup |  | Cup | 0.5 | Cup |  | Cup
Red/Orange  (3/4 Cup per week) |  |  |  | Carrots  (1/4 c) |  |  |  | Tomato
 |  | 0.5 | Cup | 0.25 | Cup |  | Cup | 0.25 | Cup |  | Cup
Beans/Peas (Legumes) (1/2 Cup per week) |  |  |  |  |  |  |  |  |  | [NAME] (1/2c) |  |  |  |  | 1/4 cup dried fruit  = 1/2 cup fruit
 |  |  | Cup |  | Cup |  | Cup |  | Cup | 0.5 | Cup
Starchy  (1/2 Cup per week) |  |  |  |  |  | Mashed potatoes |  |  |  | Corn (1/4c)
 |  |  | Cup |  | Cup | 0.5 | Cup |  | Cup |  | Cup
Other  (1/2 cup per week) |  | [NAME] (1/4c) |  |  |  |  |  |  |  | Salsa (1/4c)
 |  | 0.25 | Cup |  | Cup | 0.25 | Cup |  | Cup | 0.25 | Cup
Daily total
Additional Vegetable to reach [NAME] (1 Cup per week)
Grains(1 oz eq day) (8-10 oz eq per week) |  | [NAME] |  | [NAME] (3/4c) |  | Breading and 1 oz roll |  | Pizza Crust |  | WW Tortilla
 |  | 1.5 | Oz Eq | 1.5 | Oz Eq | 1.75 | Oz Eq | 2 | Oz Eq | 1.5 | Oz Eq
Fruits (1/2 Cup per day)  (2 1/2 cups per week) |  | Strawberries |  | Kiwi (1/2 c) |  | Peaches (1/2c) |  | Pineapple (1/2c) |  | Cantaloupe (1/2c)
 |  | 0.5 | Cup | 0.5 | Cup | 0.5 | Cup | 0.5 | Cup | 0.5 | Cup
[NAME] (1 Cup per day)  (5 a week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 193246d1352766198-formula-to-pull-numbers-from-data-in-a-cell-highergrounds
Sheet: BillOfMaterials (multi-level)

 | American Hydroponics
 | [NAME] of Materials
 | (Multi-Level) 93048 - Collector Covered 5ft module
 | Item - Description | Qty |  | Unit Cost | Total Cost
24049 | 24049 - Stage - Collector HDPE Processed | 5 | ft | 1.86 | 9.23 | 0.4 |  |  | #N/A
02062 | 02062 - Hose Clamp 3.5in to 5.5in | 2 | ea | 1.22 | 2.44 | 0.25 |  |  | #N/A
23032 | 23032 - Stage - Bulkhead Fitting 1in prepped | 1 | ea | 4.93 | 4.93 |  |  |  | #N/A
40002 | 40002 - Labor for Production | 0.0333 | hr | 60 | 2 |  |  |  | #N/A
30261 | 30261 - Screw SS 8-32 x 1.75in Pan head | 4 | ea | 0.08 | 0.34 |  |  |  | #N/A
30262 | 30262 - Washer SS Flat #10 | 8 | ea | 0.02 | 0.19 |  |  |  | #N/A
30038 | 30038 - Washer SS #10 Lock | 4 | ea | 0.02 | 0.07 |  |  |  | #N/A
30265 | 30265 - Nut 8-32 SS | 4 | ea | 0.03 | 0.11 |  |  |  | #N/A
30260 | 30260 - Brace Zinc 4in x 4in x .875in | 1 | ea | 2.09 | 2.09 |  |  |  | #N/A
02088 | 02088 - End Cap Covered Collector with Logo | 2 | ea | 0.69 | 1.37 |  |  |  | #N/A
02000 | 02000 - Hose Clamp 1in to 2in | 1 | ea | 0.7 | 0.7 |  |  |  | #N/A
50018 | 50018 - Tape Gasket .125in x .5in | 2.4166 | ft | 0.84 | 2.04 |  |  |  | #N/A
 | [NAME] of Materials
 | Manifold 3ft Finishing 1in
 | Item - Description | Qty |  | Unit Cost | Total Cost |  |  |  | #N/A
22030 | 22030 - Tubing White LDPE 1in x 5ft | 1 | ea | 4.55 | 4.55 |  |  |  | #N/A
23002 | 23002 - Grommet Microtube | 6 | ea | 0.23 | 1.38 |  |  |  | #N/A
22018 | 22018 - Micro Tubing .25in x 16in | 6 | ea | 0.06 | 0.36 |  |  |  | #N/A
30006 | 30006 - Nyties 11in | 3 | ea | 0.06 | 0.18 |  |  |  | #N/A
40002 | 40002 - Labor for Production | 0.06667 | hr | 60 | 4.0002 |  |  |  | #N/A
25083 | 25083 - Tee Nylon 1in BRB | 1 | ea | 0.75 | 0.75 |  |  |  | #N/A
25048 | 25048 - Male Adapter Nylon 1in BRB x .75in GHT | 2 | ea | 0.83 | 1.66 |  |  |  | #N/A
25113 | 25113 - Cap .75in [NAME] | 2 | ea | 0.38 | 0.76 |  |  |  | #N/A
25114 | 25114 - Ball Valve PVC with Union 1in | 1 | ea | 13.65 | 13.65 |  |  |  | #N/A
25043 | 25043 - Female Adapter PVC 1in | 1 | ea | 0.34 | 0.34 |  |  |  | #N/A
25046 | 25046 - Male Adapter Nylon 1in MPT x 1in BRB | 1 | ea | 0.95 | 0.95 |  |  |  | #N/A
Spreadsheet: 537641d1505213620-day-issue-and-pivot-table-incorrect-week-numbers-timesystem1
Sheet: Data

2017 DO NOT EDIT THIS COLUMN | Date | Name | Project | If Project=Other or Non Project Related Work Describe here | Time spent (in hours) (Normal) | OT Hours (X1.5) | OT Hours (X2) | Night Shift Hours (X1/3) | Contractor Standard Hours | Contractor Hours above standard | Productive (YES/NO) | Non Productive time Category | Non Productive time Description (if OTHER used) | Productive time description (describe work completed) Select or add FMI Number if known | Chargeable ? (NO, YES Internal (Sisco), YES External (Customer)) | If YES Internal, [NAME] to be charged | If YES External, Customer to be charged | Manager [NAME]. Line to be reviewed by Team Member | Team member comment (Free text field) | Year Month Number | Total Hours without OT factoring | WFT Month Number | Month Name | OT Month Number | OT Month Name | [NAME] | Is Contractor | Is 334 Contractor
 | 2017-09-11 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-12 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-13 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-14 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-15 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-16 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 10
 | 2017-09-17 00:00:00 | [NAME] 334Cntr | 334 door OH |  | 7
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 36

Uke: | 36 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 868409d1715159891-dynamic-formula-or-something-else-yoy-growth-v2-ans
Sheet: Sales Team RR&F

 | Select Period | GP P2 | Sales Team Growth
 |  |  |  | TY |  | LY | Growth
 | Sales team Forecast - LY v TY
 |  |  |  | Up |  | Down | Level
 | Qty Trading Up V Qty Trading Down
 | Company | Period TY | Avg Day Period TY | Forecast Period TY |  | Period LY | Avg Day Period LY |  | Acc TY | Avg Day Acc TY |  | Acc LY | Avg Day Acc LY
 | Grand Total
 | Customer 2
 | Customer 3
 | Customer 4
 | Customer 5
 | Customer 6
 | Customer 7
 | Customer 8
 | Customer 9
 | Customer 10
 | Customer 11
 | Customer 12
 | Customer 13
 | Customer 14
 | Customer 15
 | Customer 16
 | Customer 17
 | Customer 18
 | Customer 19
 | Customer 20
 | Customer 21
 | Customer 22
 | Customer 23
 | Customer 24
 | Customer 25
 | Customer 26
 | Customer 27
 | Customer 28
 | Customer 29
 | Customer 30
Spreadsheet: 374134d1422680438-conditional-formatting-groups-of-rows-bookexample2
Sheet: Desired Formatting

 |  | Below is the formatting I would like to create using a formula with conditional formatting.  The only reliable indicator of the beginning of a new set of rows is the first column, Date.
 | Date | Header2 | Data | MoreData
 | 2094-10-25 00:00:00 | Item1 | Text
 | 2094-10-25 00:00:00 | Item2 |  | 10.08
 | 2094-10-24 00:00:00 | Item3 |  | 0.02
 | 2094-10-27 00:00:00 | Item4
 |  | It's possible there could be text here…
 |  | …so only the date is a reliable indicator. |  | 238
 |  |  |  | 24
 |  |  |  | 2423
 | 2094-10-27 00:00:00 | Item5 |  | 232
 |  |  |  | 2
 | 2094-10-28 00:00:00 | Item6 |  | 23
 |  |  |  | 23
 | 2094-10-29 00:00:00 | Item7 |  | 23.27
 |  |  |  | 12
 |  |  |  | 1000
 | 2094-10-29 00:00:00 | Item8 |  | 124
 | 2094-10-29 00:00:00 | Item9 |  | 4222
 |  |  |  | 424
 |  |  |  | 32
 | 2094-10-30 00:00:00 | Item11 |  | 2
 |  |  |  | 2
Spreadsheet: 725310d1616612722-formula-on-worksheet-that-changes-column-if-copied-on-new-worksheet-cocktail-box-stock-sheet
Sheet: July Stock

 | Wet Product |  |  |  |  |  | Dry Product
 | Product | QTY initial | QTY in | QTY out | QTY holding |  | Product | QTY initial | QTY in | QTY out | QTY holding
 | [NAME] (50ml) |  |  |  |  |  | Feather
 | [NAME] (50ml) |  |  |  |  |  | Lime dehydrated
 | [NAME] (50ml) |  |  |  |  |  | Pineapple freeze dried
 | [NAME] (50ml) |  |  |  |  |  | Plum freeze dried
 | [NAME] (50ml) |  |  |  |  |  | [NAME] cake
 | Chivas Regal 12yrs (700ml) |  |  |  |  |  | Rose buds
 | Olmeca Blanco Tequila (700ml) |  |  |  |  |  | White tea (100g)
 | Campari (700ml) |  |  |  |  |  | Mini pegs
 | Cointreau (700ml) |  |  |  |  |  | Maple leaf
 | El Bandarra Rose (1000ml) |  |  |  |  |  | Grapefruit dehydrated
 | [NAME] (330ml) |  |  |  |  |  | Plastic bottle & cap
 | Miraculous foamer (118ml) |  |  |  |  |  | Blueberries freeze dried
 | Fever tree soda (200ml) |  |  |  |  |  | Raspberries freeze dried
 | Prosecco & pineapple cordial (700ml) |  |  |  |  |  | Orange dehydrated
 | [NAME] (700ml) |  |  |  |  |  | Lemon dehydrated
 | Peach & honey shrub (700ml) |  |  |  |  |  | [NAME] bottle (200ml)
 | Plum & sage cordial (700ml) |  |  |  |  |  | Garnish bag
 | Sherry & vanilla reduction (700ml) |  |  |  |  |  | Envelopes
 | Passion fruit puree (1000ml)
 | Grepefruit & vanilla falernum (700ml)
 | Chamomile & thyme cordial (700ml)
 | Maple and citrus syrup (700ml)
 | Clementine shrub (700ml)
 | Apple Juice (1000ml)
 | Fever tree lemonade (200ml)
 | El Bandarra Red (1000ml)
 | Angostura bitters (200ml)
 | Sugar (1000g)
 | Elderflower cordial (500ml)
 | Prosecco (200ml)
 | Orgeat (1000ml)
 | Maraschino liqueur (700ml)
 | [NAME] (50 per jar)
 | Chocolate bitters (200ml)
 | Lime Cordial (700ml)
Spreadsheet: 155422d1336825856-counting-sequences-consecutive
Sheet: Sheet1

 | enetr here |  | a | b | c
 | a
 | a
 | c
 | c
 | a
 | a
 | a
 | a
 | a
 | a
 | b
 | b
 | b
 | b
 | a
 | b
Spreadsheet: mark_taylor__24696__eol petchems-plastics mkt commentary
Sheet: Sheet1

Latest Economic Indicators
Unemployment was recently reported 4.1% up from 3.9% in April.  The GDP for the first quarter was 5.4.
Crude (Nymex ($[NAME])) |  |  |  | Nat Gas (Nymex ($/MMBTU))
 | 2000-06-02 00:00:00 | Last Week |  |  | 2000-06-02 00:00:00 | Last Week
July | 30.35 |  |  | July | 4.043
August | 29.44 |  |  | August | 4.022
September | 28.74 |  |  | September | 4
October | 28.18 |  |  | October | 4
November | 27.67 |  |  | November | 4.092
December | 27.2 |  |  | December | 4.187
Propane (Nymex (cts/gal)) |  |  |  | Ethane (OPIS (cts/gal))
 | 2000-06-02 00:00:00 | Last Week |  |  | 2000-06-02 00:00:00 | Last Week
July | 58 |  |  | Spot Mt. Belvieu | 38.5
August | 58.4
September | 59
October | 59.3
November | 59.8
December | 60.05
Domestic Ethylene/Polyethylene Markets
Contract ethylene for May is reported unchanged from April's price level, but producers have announced price
increases of 2 cts/lb for June.  A 5 cts/lb price increase for polyethylene announced for April is still on the
table but appears to have some momentum due to feedstock pressures and continued strength in the energy
markets.
Domestic Propylene/Polypropylene Markets
It appears as though propylene will settle up 2 cts/lb in May and 1 ct/lb in June even though final contract
prices have not been absolutely determined.  Spot availability is still extremely limited in all grades.  The May
polypropylene price increase of 4 cts/lb appears to be holding and the additional 4 cts/lb announced for June
is seeing support from sellers.  Talk of a July increase is still unconfirmed.  Further tightness is expected
due to strong demand and previous production interruptions that have not been completely corrected.
Petrochemicals
Benzene - June contract settled with a 15 cpg increase to $1.35/gal, reflecting higher production costs and reduction in supply.
June spot currently bid above contract due to delayed trader imports creating prompt tightness in the market.
Toluene - Nitration toluene has traded in the low 1.20's.  Market has been quiet the last few trading days with blending economics falling.
Styrene - Spot values remain weak, trading as low as 30.5 cpp, slightly above production cost. Producers have cut back on production to help support the falling market.
Methanol - Inventories are building on the back of imports.  The BP/Amoco unit is coming up June 6th after a 6-day outage.  The new Titan plant
in Trinidad is still not producing.
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Keepers

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2016-07-13 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2016-07-13 00:00:00
Spreadsheet: 42344d1240928450-shifting-formula-sample_new-1
Sheet: Sheet1

NAME |  | hr25/sr25/ut50 |  |  | ER | CR | CD | DR | FL | HR | MA | PE | OQ | SR | UT
Whepla* |  |  |  |  |  |  |  | 998 |  |  |  | 970 | 916 | 302 | 65
Anaiek* |  |  |  |  |  | 698 | 751 | 649 |  |  | 301 | 927 | 866 | 660 | 854
TestOne |  |  |  |  |  | 501 | 671 | 579 |  | 614 | 798 |  | 933 | 743 | 700 |  | Result should be = 85.6%
TestTwo |  | [NAME] Here |  |  |  |  |  | 246 |  |  |  | 786 |  | 323 | 410 |  | Result should be = 64.2%
IF(AND(d9>0,d10>0,d11>0),((0.25*d9)+(0.25*d10)+(0.5*d11)),IF(AND(d9="",d10>0,d11>0),((0.66*d11)+(0.339*d10)),IF(AND(d9>0,d10="",d11>0),((0.339*d9)+(0.66*d11)),IF(AND(d9>0,d10>0,d11=""),((0.5*d9)+(0.5*d10)),IF(AND(d9="",d10=""),d11,IF(AND(d10="",R114=""),d9,IF(AND(d9="",d11=""),d10)))))))
 | Test 1 | HR cap | 0.8410958904109589
 |  | SR cap | 0.8951807228915662
 |  | UT cap | 0.8433734939759037
 | Test 2 | HR cap
 |  | SR cap | 0.5857142857142857
 |  | UT cap | 0.6725
 |  | HR is 25% of the total, SR is 25%, and UT is 50%
 | If all 3.. | HR Cap*.25 + SR Cap*.25 + UT Cap*.5
 | If no HR | SR Cap*.339 + UT Cap*.66
 | If no SR | HR Cap*.339 + UT Cap*.66
 | If no UT | HR Cap*.5 + SR Cap*.5
 | If only 1 of 3 | Only Stat*1(100%)
Spreadsheet: 36933d1234891047-help-with-index-match-vlookup-example-index-and-match-1-
Sheet: Data

ItemDescription | Item-ID | Cost | [NAME] | Retail
HayBooster | Hay6060 | 195.5 | 0.2 | 234.6
HayS44SandFilter | HayS244S | 359.76 | 0.2 | 431.712
Tristar1.5hp2sp | HaySP3215EE | 423.71 | 0.2 | 508.4519999999999
Spreadsheet: 8466b99e-c2d9-40d3-95cc-7fd3d798f85b
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 11/23/2014 1:39:40 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: 70498d1271232555-problem-found-in-linked-spreadsheets-using-match-command-blank-englishautomatichafcheck
Sheet: Sheet1

08/09 | 09/10 | 10/11 | MC | N. | Service No. | Surname | Forename | DOB | Admission | Discharge | Letter date | Date | Hospital | Speciality | Time frame | Lab | Duplicate DOC with additional INFO | No of pages | Date Sent | Date Rec. | [NAME].
 |  |  |  |  |  |  |  |  | E
Spreadsheet: 3317c09e-373c-4a70-8e43-9c60af4b07c3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | School Counselor Curriculum Results Report | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Goal
Lessons and Activities Related to Goal:
Grade Level | [NAME] | [NAME] In Which Class/ Subject | [NAME], Standard and [NAME] | Curriculum and Materials | Start /End | Process Data (Number of students affected) | Perception Data (Surveys or assessments used) | Outcome Data (Achievement, attendance and/or behavior data) | Implications
Spreadsheet: 863555d1710993505-conditional-formatting-highlights-blank-cell-even-if-criteria-is-not-met-sample-workbook-dj
Sheet: Dashboard 2024

AS | Jan | Jan% | Feb | Feb% | Mar | [NAME] | Apr | Apr% | May | May% | Jun | Jun% | Jul | [NAME] | Aug | Aug% | Sep | Sep% | Oct | Oct% | Nov | Nov% | Dec | Dec%
Overall Satisfaction Score
Easy
Prompt
Expertise
Clear
S | Jan | Jan% | Feb | Feb% | Mar | [NAME] | Apr | Apr% | May | May% | Jun | Jun% | Jul | [NAME] | Aug | Aug% | Sep | Sep% | Oct | Oct% | Nov | Nov% | Dec | Dec%
Overall Satisfaction Score
Suitable
Responsiveness
Expectations
Satisfied
Spreadsheet: 124448d1318422667-find-case-and-diacritics-insensitive-duplicates-in-one-column-sortdiacriticinsensitive
Sheet: Lookups

Diacritics | Replace With
À | A
Á | A
Â | A
Ã | A
Ä | A
Å | A
Ç | C
È | E
É | E
Ê | E
Ë | E
Ì | I
Í | I
Î | I
Ï | I
Ð | D
Ñ | N
Ò | O
Ó | O
Ô | O
Õ | O
Ö | O
Ù | U
Ú | U
Û | U
Ü | U
Ý | Y
Spreadsheet: 39158d1237360986-if-and-and-formulas-excel-2003-reporting-examples
Sheet: Sheet1

Current Report
Org. | User Name | Person Number | Cert. Name | Status | Target Date | Acquired On | Expiry Date
Making Group | [NAME] | cl_543 | Making bags | Acquired |  | 2007-03-30 00:00:00 | 2010-03-29 00:00:00
Making Group | [NAME] | cl_543 | Making baskets | Acquired |  | 2007-07-31 00:00:00 | 2010-07-30 00:00:00
Making Group | [NAME] | cl_543 | Making cars | Acquired |  | 2007-07-31 00:00:00 | 2010-07-30 00:00:00
Making Group | [NAME] | cl_543 | Making children | Acquired |  | 2007-06-21 00:00:00 | 2010-06-20 00:00:00
Making Group | [NAME] | cl_543 | Making clothes | Assigned | 2009-02-18 01:51:11
Making Group | [NAME] | cl_595 | Making bags | Expired | 2009-01-22 00:00:00 | 2006-01-23 00:00:00 | 2009-01-22 00:00:00
Making Group | [NAME] | cl_595 | Making baskets | Acquired | 2010-06-20 00:00:00 | 2007-06-21 00:00:00 | 2010-06-20 00:00:00
Making Group | [NAME] | cl_595 | Making cars | Expired | 2009-01-22 00:00:00 | 2006-01-23 00:00:00 | 2009-01-22 00:00:00
Making Group | [NAME] | cl_595 | Making children | Assigned | 2009-04-22 06:01:59
Making Group | [NAME] | cl_595 | Making clothes | Assigned | 2009-04-22 06:01:35
Making Group | [NAME] | cl_595 | Making beds | Acquired |  | 2008-02-13 00:00:00
Making Group | [NAME] | cl_595 | Making out | Assigned | 2009-04-22 06:01:15
Ideal outcome
Org | User Name | Person Number | Making [NAME] | Making baskets | Making cars | Making children | Making clothes
Making Group | [NAME] | cl_543 | Yes | Yes | Yes | Yes | Yes
Making Group | [NAME] | cl_595 | No | Yes | No | No | No
Spreadsheet: 46239d1245147687-time-formatting-issue-flexi-time
Sheet: Sheet1

July
STAFF MEMBER | ALLOWANCE | LEFT | USED | USED | USED | USED
A | 2 | 0 | 1 | 1
B | 2 | -2 | 2 | 2
C | 2 | -4 | 3 | 3
D | 2 | 2
E | 2 | 2
F | 2 | 2
G | 2 | 2
H | 2 | 2
I | 2 | 2
J | 2 | 2
K | 2 | 2
L | 2 | 2
M | 2 | 2
N | 2 | 2
O | 2 | 2
P | 2 | 2
Q | 2 | 2
August
CCR | ALLOWANCE | LEFT | USED | USED | USED | USED
A | 2 | 2
B | 0 | 0
C | -2 | -2
D | 4 | 4
E | 4 | 4
F | 4 | 4
G | 4 | 4
H | 4 | 4
I | 4 | 4
J | 4 | 4
K | 4 | 4
L | 4 | 4
M | 4 | 4
N | 4 | 4
O | 4 | 4
P | 4 | 4
Q | 4 | 4
Spreadsheet: 52863d1252676136-conditional-formatting-accountantcost-debitcreditflagging
Sheet: Sheet2

10 | *
15 | *
12 | *
-10 | *
10 | *
11
-15 | *
33
-12 | *
-10 | *
33.5
33.4 | *
17
6
-33.4 | *
Spreadsheet: 836522d1689443818-payments-allocation-to-bills-in-fifo-basis-fifo-sample-data-001-harshit8999-
Sheet: payments

payment date | payment number | payment vendor name | payment amount | [NAME] |  | payment date | payment number | payment vendor name | payment amount | allocated payment | allocfated bills |  |  | payment date | payment number | payment vendor name | payment amount | allocated payment | allocfated bills
2015-06-16 00:00:00 | 125/JNL/37 | ALMT Legal | 3550 |  |  |  |  |  |  |  |  |  |  | 2015-06-16 00:00:00 | 125/JNL/37 | ALMT Legal | 3550 | 3550 | 124//Journal/36 | different payments are allocated to same bill
2015-07-09 00:00:00 | 139/JNL/45 | ALMT Legal | 1600 |  |  |  |  |  |  |  |  |  |  | 2015-07-09 00:00:00 | 139/JNL/45 | ALMT Legal | 1600 | 1600 | 124//Journal/36
2015-07-09 00:00:00 | 141/JNL/47 | ALMT Legal | 3375 |  |  |  |  |  |  |  |  |  |  | 2015-07-09 00:00:00 | 141/JNL/47 | ALMT Legal | 3375 | 3375 | 124//Journal/36
2018-05-05 00:00:00 | 2077/JNL/66 | [NAME] (Photographer) | 1000 |  |  |  |  |  |  |  |  |  |  | 2018-05-05 00:00:00 | 2077/JNL/66 | [NAME] (Photographer) | 1000 | 1000 | 1574//Journal/239
2019-04-30 00:00:00 | 3656/JNL/73 | [NAME] (Photographer) | 580.29 |  |  |  |  |  |  |  |  |  |  | 2019-04-30 00:00:00 | 3656/JNL/73 | [NAME] (Photographer) | 580.29 | 580.29 | 1574//Journal/239
2018-06-07 00:00:00 | 2162A/Pay133 | [NAME] (Photographer) | 102252.05 |  |  |  |  |  |  |  |  |  |  | 2018-06-07 00:00:00 | 2162A/Pay133 | [NAME] (Photographer) | 102252.05 | 17919.71 | 1574//Journal/239 | these all are allocated to different bills from same payment
2019-07-19 00:00:00 | 4086A/Pay118 | [NAME] (Photographer) | 5049 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700 | 1685//Journal/275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55920 | 1792//Journal/311
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26712.34 | 1816//Journal/335
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-07-19 00:00:00 | 4086A/Pay118 | [NAME] (Photographer) | 5049 | 5049 | 1816//Journal/335
Spreadsheet: 274475d1383131152-recognise-two-different-employee-id-numbers-in-one-cell-book1
Sheet: Sheet1

employee ID | employee ID |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10