tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0e0bf932-f493-43de-a30b-f613b354065e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | SINGLE FAMILY VALUATION/
 | FIRE SPRINKLER WORKSHEET 2001.1
 | Job Address:
 | A | USE | SQ. FT. |  | VALUE |  |  |  | VALUATION*
 |  | EXISTING NON-SPRINKLED BUILDING
 |  | LIVABLE / CONDITIONED AREA |  | X | 110.2924 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 42.48 |  |  | = | 0
 |  |  |  |  |  | TOTAL A |  | = | 0
 | B | GARAGE |  | X | 42.48 |  |  | = | 0
 |  | CARPORT |  | X | 42.48 |  |  | = | 0
 |  | COVERED PATIO |  | X | 42.48 |  |  | = | 0
 |  |  |  |  |  | TOTAL B |  | = | 0
 | C | TOTAL EXISTING VALUE, (A+B) |  |  |  | TOTAL C |  | = | 0
 | D | FACTORED EXISTING VALUE | 0 | X | 0.25 | TOTAL D |  | = | 0
 | E | NEW CONSTRUCTION/ADDITION
 |  | LIVABLE / CONDITIONED AREA |  | X | 110.2924 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 42.48 |  |  | = | 0
 |  |  |  |  |  | TOTAL E |  | = | 0
 | F | GARAGE |  | X | 42.48 |  |  | = | 0
 |  | CARPORT |  | X | 42.48 |  |  | = | 0
 |  | COVERED PATIO |  | X | 42.48 |  |  | = | 0
 |  |  |  |  |  | TOTAL F |  | = | 0
 | G | REMODELED AREAS, includes work requiring permit per  IRC 105.2 amended.
 |  | LIVABLE / CONDITIONED AREA |  | X | 110.2924 | X | 0.3 | = | 0
 |  | GARAGE |  | X | 42.48 | X | 0.3 | = | 0
 |  | CARPORT |  | X | 42.48 | X | 0.3 | = | 0
 |  | COVERED PATIO |  | X | 42.48 | X | 0.3 | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 42.48 | X | 0.3 | = | 0
 |  |  |  |  |  | TOTAL G |  | = | 0
 | H | TOTAL NEW AND [NAME], (E+F+G) |  |  |  | TOTAL H |  | = | 0
 | IF H >D FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | IF TOTAL H >50% of TOTAL C
 | 0
 | * Values per http://www.iccsafe.org/cs/Pages/BVD.aspx, June, 2014. |  |  |  |  |  | revised 6/30/2014.
 | The scope of work and related square footages provided are subject to field verification.  Where discrepancies are encountered by the inspector, work shall stop and a new worksheet shall be completed, inclusive of the entire known scope of work.  Sprinklers shall be installed if indicated on the revised worksheet.
Spreadsheet: 166727d1341760413-conditional-formatting-highlighting-cells-task-w-example
Sheet: Sheet1

 |  | Article | Total on hand \ Units by priority | Unit 1 required | Unit 2 required | Unit 3 required | Unit 4 required | Unit 5 required | Unit 6 required |  | Distribute resources to units according to their priority: unit 1 gets total on hand (TOH), unit 2 gets TOH- Unit 1 amount, Unit 3 gets TOH-unit 1-unit2 ...etc
 |  | chair | 234 | 88 | 34 | 123 | 23 | 35 | 66 |  | Condition 1: highlight in green if unit gets required amount of items
 |  | table | 22 | 1 | 20 | 23 | 23 | 23 | 23 |  | Condition 2: highlight in yellow if unit gets less than required amount but at least 1 item
 |  | computer | 123 | 3 | 2 | 34 |  | 23 | 34 |  | Condition 3: highlight in red if unit gets no items at all
 |  | pencil | 44 | 22 |  | 66 | 34 | 23 | 34 |  | Condition 4: leave blank if the item is not required for the unit
 |  | notebook | 345 | 88 | 78 | 66 | 34 | 23 | 34
 |  | truck | 678 | 88 | 78 | 66 | 34 | 23 | 34
 |  | boots | 234 | 88 | 78 |  | 34 | 23 | 34
 |  | helmets | 22 | 88 | 78 | 66 | 34 | 23 | 34
 |  | Expected outcome
 |  | Article | Total on hand \ Units by priority | Unit 1 required | Unit 2 required | Unit 3 required | Unit 4 required | Unit 5 required | Unit 6 required
 |  | chair | 234 | 88 | 34 | 123 | 23 | 35 | 66
 |  | table | 22 | 1 | 20 | 23 | 23 | 23 | 23
 |  | computer | 123 | 3 | 2 | 34 |  | 23 | 34
 |  | pencil | 44 | 22 |  | 66 | 34 | 23 | 34
 |  | notebook | 345 | 88 | 78 | 66 | 95 | 23 | 34
 |  | truck | 400 | 88 | 78 | 66 | 34 | 23 | 34
 |  | boots | 234 | 88 | 78 |  | 34 | 23 | 34
 |  | helmets | 22 | 10 | 78 | 66 | 34 | 23 | 34
Spreadsheet: 53886d1253808628-nesting-multiple-vlookup-conditions-in-an-if-funciton-pigexample
Sheet: TestResults

Pig Batch Number | Tag # | Test Result | Test Date | Age | Sex | Sire | Dam | SOD
772 | 68 | Good | 2008-06-18 00:00:00
774 | 68 | Poor | 2008-04-23 00:00:00
778 | 68 | Excellent | 2008-04-11 00:00:00
779 | 69 | Good | 2008-06-19 00:00:00
780 | 69 | Good | 2008-04-11 00:00:00
782 | 70 | Excellent | 2008-06-10 00:00:00
783 | 70 | Poor | 2008-05-21 00:00:00
Spreadsheet: 753503d1635479219-conditionally-format-multiple-dates-in-a-single-row-book1
Sheet: Sheet1

IDENTIFYING NO | PERSON | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00
123 | PERSON A
321 | PERSON B
456 | PERSON C
REPORT PROVIDED
PERSON A | SICK LEAVE | 2022-01-02 00:00:00 | 2022-01-03 00:00:00
PERSON A | LEAVE | 2022-01-03 00:00:00 | 2022-01-05 00:00:00
PERSON A | LEAVE | 2022-01-10 00:00:00 | 2022-01-10 00:00:00
PERSON B | LEAVE | 2022-01-01 00:00:00 | 2022-01-08 00:00:00
PERSON B | SICK LEAVE | 2022-01-08 00:00:00 | 2022-01-10 00:00:00
PERSON C | LEAVE | 2022-01-01 00:00:00 | 2022-01-02 00:00:00
PERSON C | LEAVE | 2021-01-04 00:00:00 | 2022-01-05 00:00:00
PERSON C | SICK LEAVE | 2022-01-05 00:00:00 | 2022-01-07 00:00:00
PERSON C | LEAVE | 2022-01-07 00:00:00 | 2022-01-10 00:00:00
The report doesn’t always have a set number of leave, PERSON A can take upto 6 different types of leave during the month or year.
The report needs to be projected onto the cells using conditional formatting as the cells are filled with formulas
Spreadsheet: 833139d1686809018-if-statement-with-multiple-conditions-result-is-inconsistent-look-up-with-multiple-if-condition-aligw
Sheet: Data

Part No. | Closing Stock | TTL |  | AliGW | HD
P04538 | 99061.53 | 908.62
P07694-21A | 8000 | 842.2
P20554-01 | 0 | 0
L05302 | 7200 | 730
Condition:
 | IF B2 is not zero in Data tab, [NAME] (only first 6 digit if lookup data only has 6 digit)
 | from the element tab, match and look at the highest number from B column
 | if A2 has decimal - like P07694-21A in B3 Data tab and B3 has more than zero match it to the Element Tab
 | exactly as is - result is 842.20
 | Another condition will be if we could not match A5 from the element tab column A - substitute that Look up value A5
 | from Other Source tab column B then match it with the Element Tab column A and pick the highest number in column B
 | also with the condition if B5 in Data tab is not zero
Spreadsheet: bd5298db-86f7-40b3-bc4c-f12e994d3be9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | COLORADO DEPARTMENT OF HIGHER EDUCATION |  |  |  | [NAME], CCHE-C-7
FISCAL REPORT OF EXPENDITURES
Due July 15, 2013 for Fiscal Year 2012-13
NAME OF INSTITUTION:  _______________________________________ |  |  |  | NAME OF FISCAL OFFICER:  ___________________________
 | (1) | (2) | (3) | (4) | (5) | (6)
 | Amount Shown on | Additional Funds | Funds | Total | Total | Unexpended
PROGRAM | Original Official | Reallocated | Released | Available | Expenditures for | Funds
 | Allocation Notice | by CCHE | to CCHE | (1 + 2 - 3  = 4) | Fiscal Year 2012-13 | (4 - 5 = 6)
Colorado Need-based Grant |  |  |  | 0 |  | 0
Colorado Graduate Grant |  |  |  | 0 |  | 0
Colorado Work-Study |  |  |  | 0 |  | 0
[NAME] |  |  |  | 0 |  | 0
TOTAL All Programs | 0 | 0 | 0 | 0 | 0 | 0
Fiscal Officer Signature |  |  |  | Date
RETURN THIS FORM TO THE ATTENTION OF: Celina Duran
 | [NAME]
Spreadsheet: 97499d1296662618-extract-birthday-date-and-month-birthday
Sheet: Data

 |  | [NAME] in to  any year (in this case 2010) |  |  |  | Use the Advanced Filter (under the menu Data | Filter | [NAME],  with the following values:-
Day | 4 | 2010-06-04 00:00:00 |  |  |  | Copy to Another location (selected)
Month | June |  |  |  |  | List Range $A$8:$C$16
Count | Number of birthdays on 4 June = 2 |  |  |  |  | [NAME]: $C$1:$C$2
 |  |  |  |  |  | Copy To: $G$1:$H$16
 |  |  |  |  |  | The above settings will generate the table below
Name | DoB | [NAME] in to  any year (in this case 2010) |  |  |  | Name | DoB
A | 1963-06-04 00:00:00 | 2010-06-04 00:00:00 |  |  |  | A | 1963-06-04 00:00:00
B | 2004-01-01 00:00:00 | 2010-01-01 00:00:00 |  |  |  | F | 1975-06-04 00:00:00
C | 1945-12-01 00:00:00 | 2010-12-01 00:00:00
D | 1953-08-15 00:00:00 | 2010-08-15 00:00:00
E | 1939-01-27 00:00:00 | 2010-01-27 00:00:00
F | 1975-06-04 00:00:00 | 2010-06-04 00:00:00
G | 1929-02-08 00:00:00 | 2010-02-08 00:00:00
H | 1945-08-15 00:00:00 | 2010-08-15 00:00:00
Spreadsheet: 724914d1616441140-two-dimensional-lookup-with-interpolation-excel_001_two-dim-lookup
Sheet: 2 dimensional lookup

 |  | Qty |  |  |  |  |  | Input
 | Group | 1 | 2 | 3 | 4 | 5 |  |  | Group | C
 | A | 2.8 | 2.52 | 2.27 | 2.04 | 1.84 |  |  | Qty | 2.2
 | B | 3.5 | 3.15 | 2.84 | 2.55 | 2.3
 | C | 5.95 | 5.37 | 4.82 | 4.34 | 3.9 |  | Req. Output
 | D | 8.4 | 7.56 | 6.8 | 6.12 | 5.51 |  | 1- | Value1 | 5.37 | No interpolation-  give the first boundary value
 | E | 12.25 | 11.03 | 9.92 | 8.93 | 8.04 |  | 2- | Value2 | 4.82 | No interpolation-  give the second boundary value
 | F | 14.7 | 13.23 | 11.91 | 10.72 | 9.64 |  | 3- | Value3 | 5.26 | Perform interpolation - give interpolated value
Spreadsheet: 470860d1468736084-sorting-two-different-values-book1
Sheet: R Database

S # | Date | Month | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | less | Balance | Status | Unit | s | vn | Column1
1 |  |  | GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96 | 400 |  |  |  | GR | A | KA 01
 |  |  | R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36 | 400 |  |  |  | R | B | KA 02
 |  |  | RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33 | 400 |  |  |  | RR | C | KA 03
 |  |  | GR-06 | 11.42 | 50.28 | 116.1 | 9.36 | 0.93 | 27.83 | 0.59 | 0.47 | 5.12 | 400 | 400 |  |  | GR | D | KA 04
 |  |  | R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21 | 400 |  |  |  | R | E | KA 05
 |  |  | R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69 | 400 |  |  |  | R | F | KA 06
 |  |  | RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14 | 400 | 400 |  |  | RR | G | KA 07
 |  |  | GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3 | 400 |  |  |  | GR | H | KA 08
 |  |  | RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91 | 400 |  |  |  | RR | I | KA 09
Spreadsheet: 734974d1622628402-rental-projection-for-a-list-of-shops-rental-sheet-question
Sheet: Assumption

Option | Explanation | Rent Void (days) | New start date | [NAME] (months) | Rental increment for next 12 months from the "new start date".  (i.e. the first year rental) | Annual growth rate  (i.e. annual growth rate every 12 months)
Cont | the tenancy is not expire, continue on next row | NA | NA | NA | NA | NA
Renew_A | the tenancy will be renewed. New start date being from the date right after the end date | 0 | subsequent to the end date | 12 | 0.05 | 0.05
Renew_B | the tenancy will be renewed. New start date being from the date right after the end date | 0 | subsequent to the end date | 24 | -0.2 | 0.05
Renew_C | the tenancy will be renewed. New start date being from the date right after the end date | 0 | subsequent to the end date | 36 | 0.1 | 0.05
New Let_A | The tenancy will be expired.  New start date being after the rent void period at the rental level base on the rental increment (column F) | 30 | the first date of the month following the rent void (e.g. after the rent void period say 15 Jan, the new start date will be 1 Feb) | 36 | 0.05 | 0.05
New Let_B | The tenancy will be expired.  New start date being after the rent void period at the rental level base on the rental increment (column F) | 60 | the first date of the month following the rent void (e.g. after the rent void period say 15 Jan, the new start date will be 1 Feb) | 24 | -0.2 | 0.05
New Let_C | The tenancy will be expired.  New start date being after the rent void period at the rental level base on the rental increment (column F) | 90 | the first date of the month following the rent void (e.g. after the rent void period say 15 Jan, the new start date will be 1 Feb) | 60 | 0.15 | 0.05
Spreadsheet: 887797d1738124439-fixed-asset-depreciation-josephteh-fixed-asset-depreciation
Sheet: Sheet1

 | Year 1 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Year 3 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Need a generic formula for Initial Depreciation and Annual Depreciation.
 | Asset bought in Year 1
 | - Initial Depreciation = $500,000 x 20% = $100,000 in Year 1
 | - Annual Depreciation = $500,000 x 10% = $50,000 per year from Year 1 to Year 8
 | Asset bought in Year 3
 | - Initial Depreciation = $300,000 x 20% = $60,000 in Year 3
 | - Annual Depreciation = $300,000 x 10% = $30,000 per year from Year 3 to Year 10
Spreadsheet: 740707d1626482130-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v5-
Sheet: Version10

Totals: |  |  |  | Purchase
 |  |  |  | Sale
 |  |  |  |  | TRANSACTION |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity Bought(+) / Sold(-) | Price | Fees | Amount | Quantity Sold | Price | Amount (Cost of Goods Sold) | Quantity Remaing | Price | Amount (Inventory Value) | Gain(+) / Loss(-) Running Balance | Gain(+) / Loss(-) per Sale Only
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase | 2021-02-22 00:00:00 |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 246.20782 | 102.55 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0
Spreadsheet: 289720d1389662539-making-a-home-tutor-timetable-system-schedule
Sheet: Pupil A

back |  | Pupil A
 |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
 |  | 0830-0900 | ICT | English
 |  | 0900-0930 | ICT | Maths
 |  | 0930-1000 | Maths
 |  | 1000-1030 | Science
 |  | 1030-1100 | Science
 |  | 1100-1130
 |  | 1130-1200
 |  | 1230-1300
 |  | 1300-1330
 |  | 1330-1400
 |  | 1400-1430
 |  | 1430-1500
 |  | 1500-1530
Spreadsheet: 874167d1720730238-vlookup-via-searching-text-in-cell-char-limit-sample-document
Sheet: SAMPLE

SAMPLE DATA |  |  |  |  |  |  |  | Lookup | Return
FIELD | MISC FIELD | MISC FIELD2 | [NAME] | Test Output |  | TEST #1 | GOAL | CG508 | C123
8140-14-1.0 8140-14-1.5 8140-14-2.3 8140-14-2.5 8140-18-1.7 8140-20-2.0 |  |  |  | A123 |  |  | Current | CG508 |  | <-issue right here
8100-12LV 8100-14LV 8100-16LV 8100-18 8100-20 8100-22 8100-24 8100-28 |  |  |  | B123
[NAME] CG405 CG406 CG407 CG408 CG409 CG410 CG411 CG412 CG413 CG414 CG415 CG416 CG417 CG430 CG431 CG432 CG501 CG502 CG503 CG504 CG505 CG506 CG507 CG508 CG509 CG510 CG511 CG512 CG513 CG514 CG515 CG516 CG521 CG418 CG433 CG434 CG435 [NAME] CG441 CG442 |  |  |  | C123 |  |  |  | Lookup | Return
LXMC13 LXMC14 LXMC15 LXMC16 LXMC17 |  |  |  | D123 |  | TEST #2 | GOAL | 8100-24 | B123
LXMC13x LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC17a |  |  |  | CHAR TEST 1 |  |  | Current | 8100-24 |  | <-works here
LXMC13x LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC17a |  |  |  | CHAR TEST 2
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | TEST #3 | GOAL | LXMC17 | D123
 |  |  |  |  |  |  | Current | LXMC17 |  | <-works here
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | HIGH CHAR TEST | GOAL | [NAME] | C123
 |  |  |  |  |  |  | Current | LXMC17a |  | <-issue right here
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | HIGH CHAR TEST | GOAL | [NAME] | C123
 |  |  |  |  |  |  | Current | LXMC17b |  | <-works here
Spreadsheet: e2818937-6f06-4533-af15-4eebc6b42d14
Sheet: Sheet1

MATTEL, INC. AND SUBSIDIARIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | EXHIBIT I
CONSOLIDATED STATEMENTS OF OPERATIONS (Unaudited)
 |  |  |  |  |  | For the Three Months Ended March 31,
(In millions, except per share and |  |  |  |  |  | 2009 |  |  |  | 2008 |  |  |  | Yr / Yr
percentage information) |  |  |  |  |  | $ Amt |  | % Net Sales |  | $ Amt |  | % Net Sales |  | % Change
Net Sales |  |  |  |  | $ | 785.6 |  |  | $ | 919.3 |  |  |  | -0.1454367453497225
Cost of sales |  |  |  |  |  | 439.7 |  | 0.56 |  | 522.5 |  | 0.568 |  | -0.1584688995215311
Gross Profit |  |  |  |  |  | 345.9 |  | 0.44 |  | 396.8 |  | 0.432 |  | -0.1282762096774194
Advertising and promotion expenses |  |  |  |  |  | 84.1 |  | 0.107 |  | 103 |  | 0.112 |  | -0.183495145631068
Other selling and administrative expenses |  |  |  |  |  | 317 |  | 0.404 |  | 330.34 |  | 0.359 |  | -0.04038263607192582
Operating Loss |  |  |  |  |  | -55.2 |  | -0.07 |  | -36.5 |  | -0.04
Interest expense |  |  |  |  |  | 15.9 |  | 0.02 |  | 16 |  | 0.017 |  | -0.006249999999999978
Interest (income) |  |  |  |  |  | -3.5 |  | -0.004 |  | -8.5 |  | -0.009 |  | -0.5882352941176471
Other non-operating (income) expense, net |  |  |  |  |  | -2.14 |  |  |  | 15.8
Loss Before Income Taxes |  |  |  |  |  | -65.46 |  | -0.083 |  | -59.8 |  | -0.065
Benefit for income taxes |  |  |  |  |  | -14.5 |  |  |  | -13.2
Net Loss |  |  |  |  | $ | -51 |  | -0.065 | $ | -46.6 |  | -0.051
EPS - Basic |  |  |  |  | $ | -0.14 |  |  | $ | -0.13
Average Number of Common Shares |  |  |  |  |  | 358.9 |  |  |  | 361.75084
EPS - Diluted |  |  |  |  | $ | -0.14 |  |  | $ | -0.13
Average Number of Common and
Potential Common Shares |  |  |  |  |  | 358.9 |  |  |  | 361.75084
Spreadsheet: 681317d1591468825-sorting-missing-data-example-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Observed |  |  | Forecast
 |  |  |  |  | Time: | Temp Calculation |  |  |  |  | Time | Temp |  | Time | Temp
 | Should be False. Difference of greater than 2 |  |  |  | 07:56:00 |  |  |  |  |  | 10:56:00 | 22 |  | 07:56:00 | 17
 | Should be False. Difference of greater than 2 |  |  |  | 08:56:00 |  |  | Missing 9:56 Time Slot ---> |  |  | 2020-03-05 08:56:00 | 20.28 |  | 08:56:00 | 17
 | Should be blank as no data with 9:56 time stamp is available |  |  |  | 09:56:00 |  |  |  |  |  | 07:56:00 | 21 |  | 09:56:00 | 20
 | Should be True. Difference of less than or equal to  2 |  |  |  | 10:56:00 |  |  |  |  |  | 2020-03-05 11:56:00 | 21.72 |  | 10:56:00 | 20
 | Should be True. Difference of less than or equal to  3 |  |  |  | 11:56:00 |  |  |  |  |  |  |  |  | 11:56:00 | 20
Spreadsheet: 594772d1539960276-extracting-data-to-a-new-sheet-based-on-dates-test
Sheet: Snapshot

 |  | Total Contacted | Total Hired | Rehire |  | Rehire % | New | New % | Referral | Referral % |  | % Hired | Goal % |  | January | February | March | April | May | June | July | August | September | October | November | December |  | Tot |  | January | February | March | April | May | June | July | August | September | October | November | December |  | Tot
 | Total
 | Current ICIMS Flow |  |  |  |  | ICIMS [NAME] Today
 |  |  |  |  |  |  |  |  |  | Apps |  | New App
 | Total Contacted |  |  |  |  | Grounds Attendant |  |  |  | 6 |  | 2
 | hired |  |  |  |  | [NAME]
 | contacted |  |  |  |  | Character
 | interview schedule |  |  |  |  | Concierge
 | submit |  |  |  |  | Team Lead
 | withdrew |  |  |  |  | Supervisor
 | not selected |  |  |  |  | Area Supervisor
 | no show |  |  |  |  | Operations Supervisor
 | pending
 | Offer
 | offer accepted
 | pipeline started
Spreadsheet: 886575d1736612878-count-if-function-should-be-count-value-of-charactor-as-a-half-salary-nirman22
Sheet: Before

SN |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Full  Day | Half  Day | W/O | Leave | Total
1 | Deepak Gote | p | p | p | p | w | p | h | w | p | p | p | w | p | p | w | p | p | p | w | p | p | w | p | p | p | w | p | p | p | p | p |  |  | 4
2 | Atul Shinde | p | l | p | p | w | p | p | w | p | p | h | w | p | p | w | h | p | p | w | p | p | w | p | p | p | w | p | p | p | p | p |  |  | 4
3 | [NAME] | p | l | p | p | w | h | p | w | p | p | p | w | p | p | w | p | p | h | w | p | h | w | p | p | p | w | p | p | p | p | p |  |  | 4
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Spreadsheet: 879066d1726502072-how-to-do-advanced-sales-analyses-using-excel-example_excel-sales-export
Sheet: Sheet1

 | Summary Orders by [NAME] Period |  |  |  |  | Start Date | 2024-01-01 00:00:00 | End Date |  |  |  |  |  |  | Order Qty by Article by Month
 |  |  |  |  |  |  |  |  |  | <--- Input desired price range --->
 | Category | Subcategory | Article | # Orders | Total Qty | Total Amount | [NAME] | Min U/Price | [NAME] | Min Price Range | [NAME] | Total Order Value | [NAME] |  | Category | Subcategory | Article | Total Qty | Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 | May 2024 | Jun 2024
 | 101 | 101.10 | 101.10.001 |  |  |  |  |  |  | 80 |  |  |  |  | 101 | 101.10 | 101.10.001
 | 101 | 101.10 | 101.10.002 |  |  |  |  |  |  |  | 5 |  |  |  | 101 | 101.10 | 101.10.002
 | 101 | 101.10 | 101.10.003 |  |  |  |  |  |  | 6 | 8 |  |  |  | 101 | 101.10 | 101.10.003
 | Welcome to the forum!
 | Your sample size is too small. I have added 2 more random orders.
 | First, convert your data into an Excel table.
 | Next, add 3 helper columns: [Date], [Line Amount] and [Total Order Value] with the formulas:
 | Then, create another table, and using COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS and MAXIFS.
 | Calculate average/minimum/maximum unit price for each article.
 | And, input desired price range in [Min Price Range] and [Max Price Range] columns for each article, to get the Total Order Value.
Spreadsheet: 185204d1349555949-conditional-formatting-and-exact-value-across-multiple-cells-sample
Sheet: Sheet1

 | 40911
Ref | 42
A | 4
B
C | 7
D | 3
E | 3
F | 1
G | 1
H | 2
I
J | 15
K
L | 1
M
N | 1
O
P | 9
Q | 11
R | 5
S
T
U
V | 5
Total 1 | 23
Total 2 | 16
Total 3 | 1
Total 4 | 5
Total 5 | 18
Total 6 | 5
Grand Total