tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 14f93eff-6033-457e-bdda-537ff33efdc8
Sheet: EPR 1X CQY

Reconciliations of GAAP to Non-GAAP Adjusted Financial Measures
(In millions, except EPS)
Fourth Quarter Ended September 30, 2013
 |  |  |  |  | Continuing Operations
 | Product Sales Revenue | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 312.2 | 27.7 | 233.1 | 123.4000000000001 | 63.50000000000009 | 0.24
% of revenue |  |  | 0.3686541198798039 | 0.195160525067215
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | 0 | -15.3 | 15.3 | 9.999999999999998 | 0.03
Amortization of intangibles | 0 | -2.3 | -4.4 | 6.7 | 4.4 | 0.02
Legal settlement | 0 | 0 | -2.4 | 2.4 | 1.6 | 0.01
Impairment | 0 | 0 | -0.4 | 0.4 | 0.2999999999999999 | 0
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | 0 | 0
Total non-GAAP adjustments | 0 | -2.3 | -22.5 | 24.8 | 16.3 | 0.06
Adjusted measures | 312.2 | 25.4 | 210.6 | 148.2000000000001 | 79.80000000000008 | 0.3
% of revenue |  |  | 0.3330697453740313 | 0.2343824134113555
Year Ended September 30, 2013
 |  |  |  |  | Continuing Operations
 | Product Sales Revenue | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 1085.2 | 102.7 | 850.3 | 494.0999999999999 | 272.6999999999999 | 1.03
% of revenue |  |  | 0.3631277758797403 | 0.2110095661086436
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | 0 | -73.9 | 73.9 | 48.4 | 0.17
Amortization of intangibles | 0 | -9.2 | -17.7 | 26.9 | 17.6 | 0.07
Proxy fees | 0 | 0 | -7.6 | 7.6 | 4.9 | 0.02
Legal settlement | 0 | 0 | -2.4 | 2.4 | 1.6 | 0.01
Impairment | 0 | 0 | -3.6 | 3.6 | 2.4 | 0.01
Royalty settlement | -5 | 0 | 0 | -5 | -5 | -0.02
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | -5.9 | -0.02
Total non-GAAP adjustments | -5 | -9.2 | -105.2 | 109.4 | 64 | 0.24
Adjusted measures | 1080.2 | 93.5 | 745.0999999999999 | 603.4999999999999 | 336.6999999999999 | 1.27
% of revenue |  |  | 0.3182012299282542 | 0.2577297574308165
(a) Adjustments tax effected at 35%, except no tax effect on royalty settlement
(b) Primarily related to DoubleDown
Spreadsheet: 878005d1724954851-sequence-numbering-in-table-sequance-numbering-in-table
Sheet: Sheet1

 |  |  |  |  | [NAME] in Table
 |  |  |  |  | Frequently Rendering table and the sequential numbers does not stay in order
 |  |  |  |  | I want to see sequential numbers stay in order when re-ordered
 |  |  | Want to see in Table |  | No | Name | Address
 |  | =SEQUENCE(50,1) →→ |  |  |  | Name 1
 |  |  | 2 |  |  | Name 5
 |  |  | 3 |  |  | Name 230
 |  |  | 4 |  |  | Name 1
 |  |  | 5 |  |  | Name 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
 |  |  | 50
Spreadsheet: 133171d1324243415-functions-and-controls-rating
Sheet: Sheet2

RATING | # of time occurred | # of H | # of D | # of A | H - D - A %
Spreadsheet: 37084d1235043513-lookup-date-and-delete-if-not-within-frame-nxc2
Sheet: Sorted

pnr | lopnr | [NAME] | EDATUM | [NAME] | fddd
# | 24 | Kontroll | 2007-01-26 00:00:00 | 2006-12-12 00:00:00 | 50
# | 29 | Inre | 2006-11-28 00:00:00 | 2006-11-28 00:00:00 | 33.33
# | 29 | Inre | 2006-12-14 00:00:00 | 2006-12-12 00:00:00 | 33.33
# | 29 | Inre | 2007-01-22 00:00:00 | 2006-03-14 00:00:00 | 200
# | 29 | Inre | 2007-03-01 00:00:00 | 2006-12-12 00:00:00 | 33.33
# | 29 | Inre | 2007-04-19 00:00:00 | 2007-03-15 00:00:00 | 33.33
# | 12 | Inre | 2007-01-04 00:00:00 | 2007-01-04 00:00:00 | 98
# | 12 | Inre | 2007-03-16 00:00:00 | 2007-03-16 00:00:00 | 100
# | 12 | Inre | 2007-03-26 00:00:00 | 2007-03-21 00:00:00 | 147
# | 24 | Kontroll | 2007-01-26 00:00:00 | 2006-12-12 00:00:00 | 50
Spreadsheet: 60718d1261248385-work-schedule-timesheet-copy-of-schedule-timesheet2
Sheet: WS

Work Schedule--Week of
 |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
BREAKFAST | COOK | [NAME] | 05:00-11:00
 |  | [NAME] | 05:00-12:00
 | FLOOR |  |  | [NAME] | 07:00-12:00
 |  |  |  | [NAME] | 07:50-13:00
LUNCH | COOK
 |  |  |  |  |  | [NAME] | 10:00-13:00
 | MIDDLE | Fred | 10:00-14:00
 |  |  |  |  |  |  |  | [NAME] | 11:00-14:00 | [NAME] | 11:00-14:00
 | DT
DINNER | COOK |  |  |  |  |  |  |  |  |  |  | [NAME] | 16:00-20:00
 | MIDDLE |  |  |  |  |  |  |  |  | Fred | 17:00-22:00
 |  |  |  |  |  |  |  |  |  | [NAME] | 14:00-24:00
 | DT
 | FLOOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 13:00-22:00
Spreadsheet: 673559d1587446079-display-combined-average-of-a-range-with-criteria-in-rows-and-columns-kpi-pack-excel-forum
Sheet: Monthly View

 |  |  |  |  | January | February | March
 | KPI's
 | INBOUND
 | KPI 1: Dock to Stock (excl returns) - DTS
 |  |  | Target | 0.95
 | Technology
 | 1 |  |  | % | Average of all 1's (column a) for January from KPI report tab (QLD,NSW,VIC,WA,SA) . Eg average of F14:I14,F30:I30 etc.
 | 2 |  |  | % | Average of all 2's (column a) from KPI report tab (QLD,NSW,VIC,WA,SA) . E
 | 3 |  |  | %
 | 4 |  |  | %
 | 5 |  |  | %
 | 6 |  |  | %
 | 7 |  |  | %
 | 8 |  |  | %
 | 9 |  |  | %
 | 10 |  |  | %
 | 11
 | 12
 | 13
 | 14
 |  |  | TOTAL - QLD | %
Spreadsheet: 680844d1591218881-conditional-formatting-based-on-other-cells-test-sheet
Sheet: Sheet1

 | RECEIVED ITEMS |  | 2020-06-01 00:00:00
 |  | ITEM |  |  |  |  |  | PURCHASE |  |  |  |  | [NAME] |  | STOCK INVENTORY
 | ITEM NO. | [NAME] | DATE ORDERED | DATE/TIME  RECEIVED | QUANTITY ORDERED | QUANTITY RECEIVED | QUANTITY REMAINING | VENDOR | PO # | WORK ORDER CONTRACT NUMBER | STOCK | VENDOR  ORDER NO. | AREA | SHELF / BIN | QTY | ITEM AREA | ITEM SHELF / BIN
 | X7930 | HC14-23 Cab | 2020-05-29 00:00:00 | 2020-06-01 09:00:00 | 1 | 1 |  | Company L | 29586 | 154133 |  | abc1 | Residential | O-2
 | X0585 | HC-11 | 2020-05-29 00:00:00 | 2020-06-01 09:00:00 | 1 | 1 |  | Company L | 29586 | 154133 |  | abc2 | Residential | O-2
 | MPG 25141 | MPG 2514 | 2020-05-27 00:00:00 | 2020-06-01 11:20:00 | 5 | 5 |  | K Supply | 29571 |  |  | xyz1 |  |  | 5 | Hardware
 | MPG 25106 | MPG 2510 | 2020-05-27 00:00:00 | 2020-06-01 11:20:00 | 4 | 4 |  | K Supply | 29571 |  |  | xyz2 |  |  | 4 | Hardware
Spreadsheet: 17b61207-b9ef-4d6a-b100-3c12df70d5dd
Sheet: Venezuela

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Venezuela | this year | last year | this year | last year | this year | last year
Spreadsheet: 697426d1601353853-allocation-from-lowest-rank-to-top-rank-sample1
Sheet: Sheet1

 |  |  | Initial Stock at Stores |  |  |  |  |  | Weekly Sales |  |  |  |  |  | Store Rank |  |  |  |  |  | Stock needed |  |  |  |  |  |  | Stock to Be
Product |  | WH Stock | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  |  | 1 | 2 | 3 | 4 | 5
ABC |  | 0 | 2 | 10 | 2 | 0 | 2 |  | 1 | 2 | 4 | 2 | 2 |  | 5 | 4 | 2 | 1 | 3 |  |  |  |  |  |  |  |  |  | -6 | 2 | 4 |  | stock allocation from store 2 to store 4 dan store 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | initial stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (-) means excessive stock at store
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (+) under stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | allocate stock from store with lowest rank to top rank store
Spreadsheet: 329491d1404320219-complex-look-up-and-sum-example-data
Sheet: Sheet4

Results Page
 | Date
Unique Reference | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
12345
98821
12134
11445
1244B
1242T
Example: | Sum values in Quantity Columns in "Data Page" if Unique Reference and Date matches those of B3 and A4
Data Page (separate sheet)
Date | [NAME] Number | [NAME] (1) | Quantity | [NAME] (2) | Quantity | [NAME] (3) | Quantity | [NAME] (4) | Quantity | [NAME] (5) | Quantity
2014-01-01 00:00:00 | 1 | 12345 | 25 | 12134 | 12 | 1242T | 10 | 1242T | 8 | 98821 | 450
2014-01-01 00:00:00 | 2 | 11445 | 700 | 11445 | 20
2014-01-01 00:00:00 | 3 | 1242T | 589 | 1242T | 124 | 98821 | 7000 | 11445 | 89 | 11445 | 123
2014-01-02 00:00:00 | 4 | 12345 | 50 | 11445 | 100 | 11445 | 100
2014-01-03 00:00:00 | 5 | 1244B | 50 | 12345 | 1000 | 1244B | 100 |  |  | 12134 | 2000
2014-01-03 00:00:00 | 6 | 11445 |  | 11445 |  |  |  | 12345 | 10000
2014-01-07 00:00:00 | 7 | 12345 | 3000 | 11445 | 10000 | 98821 | 3000 |  |  | 12134 | 5000
2014-01-08 00:00:00 | 8 | 11445 | 1000 | 1244B | 1000
2014-01-07 00:00:00 | 9 | 98821 | 1000 | 11445 | 10000 | 98821 | 2000 |  |  | 12345 | 20000
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: MAIN

 | NEW EQUIPMENT COST REPORT ORGANIZER
 | Start Date | End Date
Pay Period | 24/07/2011 | 06/08/2011 | dd/mm/yyyy
Trucks | [NAME] | Hour [NAME] | Equipment | Hour [NAME]
OTV 1000 | 111 | 1 | OME 1003 | a | [NAME]
OTV 1005 | 222 | 2 | OME 1004 | b | [NAME].
OTV 1012 | 333 | 3 | OME 1006 | c | Backhoe
OTV 1013 | 444 | 4 | OME 1021 | d | Loader
OTV 0879 | 555 | 5 | OME 5309 | e | Grader
OTV 1023 | 666 | 6 | OME 7102 | f | Tractor - Pat 3
OTV 1030 | 777 | 7 | OME 7103 | g | Tractor - Pat 2
OTV 5342 | 888 | 8
OTV 5508 | 999 | 9 | Instructions: enter pay period start/end dates, as well as starting odometer and hour [NAME] readings into the boxes on this page. Once everything has been entered, click File, Print… in the 'Print what' box, select Entire workbook then click OK.  To print sheets for an individual unit, select the unit number at bottom then click File, Print, 'Print what' then Active sheet(s)  You must ONLY enter information on this page
OTV 7022 | 123 | 10
OTV 7243 | 456 | 11
OTV 7246 | 789 | 12
Spreadsheet: 692113d1598093460-calculating-ltd-and-etc-using-multiple-data-excel-issues
Sheet: Sheet1

 | LTD | ETC |  |  |  |  |  |  |  |  | A | A | A | A | A | F | F | F | F
1 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
2 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
3 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
4 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
5 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
6 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | H | 100
7 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | H | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | H | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 4 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 6 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: 135743d1326213406-auto-transfer-data-from-master-sheet-to-individual-worksheets-nbastatistics
Sheet: Atl

Atlanta
Away Games |  |  | Home Games
Points Scored | Points Allowed |  | Points Scored | Points Allowed
106 | 70 |  | 101 | 93
84 | 95 |  | 105 | 98
100 | 92 |  | 109 | 116
74 | 76 |  | 109 | 94
102 | 96
106 | 101
Spreadsheet: 92de0fdb-a098-4f8d-9a2b-310f5ebed612
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
F_12 | Test | F_12 | Coagulation Factor XII Activity Assay, Plasma | Coag Factor XII Assay, P | Activated Partial Thromboplastin Clot-Based Assay | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Patient must not be receiving [NAME] or heparin therapy. 3. Each coagulation assay requested should have its own vial. 4. If priority specimen, mark request form, give reason, and request a call-back. 5. Coagulation testing is highly complex, often requiring the performance of multiple assays and correlation with clinical information. For that reason we suggest ordering Coagulation Consultations. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Adults: 55-180% Normal, full-term newborn infants or healthy premature infants may have decreased levels (> or =15% to 20%) which may not reach adult levels for > or =180 days postnatal.* *See Pediatric Hemostasis References in Coagulation Studies in Special Instructions. | Monday through Friday | 1 day | 3 days | 1 | 85280 |  |  |  |  | Rochester
F_12 | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
F_12 | Result | F_12 | Coag Factor XII Assay, P | Coag Factor XII Assay, P | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3232-6
Spreadsheet: 35613d1233191139-calculations-using-references-from-two-drop-down-lists-correl-droplists_myerror
Sheet: Sheet3

List | List2 | List3 | List4 |  |  |  |  |  | [NAME] | ListB | [NAME]
1 | 1 | 432453 | 23 |  | List | List3 | 0.2616770832029163 |  | 17.2 | 34.3 | 73.7
2 | 2 | 424 | 634 |  |  |  |  |  | 31.3 | 21 | 13 |  | [NAME] | [NAME] | #N/A
3 | 3 | 34 | 1245 |  |  |  |  |  | 12.8 | 29.1 | 61
994 | 994 | 245 | 1856 |  |  |  |  |  | 1.5 | 1 | 7.3
5 | 5 | -215964.5 | 2467 |  |  |  |  |  | -8.5 | -5.3 | -24.7
6 | 6 | -345665.9 | 3078 |  |  |  |  |  | 48.8 | 16.4 | 60.2
7 | 7 | -475367.3 | 3689 |  |  |  |  |  | 47.6 | 23.3 | 32.4
8 | 8 | -605068.7 | 4300 |  |  |  |  |  | 62.7 | 23 | 35.3
9 | 9 | -734770.1 | 4911 |  |  |  |  |  | 23.1 | 30.7 | 13.8
10 | 10 | -864471.5 | 5522 |  |  |  |  |  | 26.7 | -23.3 | -42.3
11 | 11 | -994172.9 | 6133
12 | 12 | -1123874.3 | 6744
Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet8

 |  |  |  | Row Labels | Count of Status
 |  |  |  | Didn't join after selection | 1
 |  |  |  | Duplicate | 6 |  |  | Status | Count of status
 |  |  |  | No Show | 11 |  |  | Didn't join after selection | 1
 |  |  |  | Not Interested | 13 |  |  | Duplicate | 6
 |  |  |  | Not Suitable | 16 |  |  | No Show | 11
 |  |  |  | Offer Accepted | 1 |  |  | Not Interested | 13
 |  |  |  | [NAME] | 3 |  |  | Not Suitable | 16
 |  |  |  | Rejected (1st) | 32 |  |  | Offer Accepted | 1
 |  |  |  | Rejected (2nd) | 5 |  |  | [NAME] | 3
 |  |  |  | Scheduled | 4 |  |  | Rejected (1st) | 32
 |  |  |  | (blank) |  |  |  | Rejected (2nd) | 5
 |  |  |  | Grand Total | 92 |  |  | Scheduled | 4
 |  |  |  |  |  |  |  | Not Yet Scheduled | 1
 |  |  |  |  |  |  |  | Grand Total | 93
Spreadsheet: 774604d1648561972-formula-average-days-between-to-date-columns-in-excel-help
Sheet: Dates

Date Manager Asked | Date Manager Responded
2022-02-02 00:00:00 | 2022-02-14 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-16 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-22 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-24 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-03 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2021-12-06 00:00:00 | 2021-12-06 00:00:00
2022-02-02 00:00:00 | 2022-02-14 00:00:00
2021-10-06 00:00:00 | 2021-11-04 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-03-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-17 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-03 00:00:00
2022-02-02 00:00:00 | 2022-02-17 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-03-01 00:00:00
2021-11-23 00:00:00 | 2021-12-20 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00 | 2022-02-04 00:00:00
2021-12-20 00:00:00 | 2021-12-20 00:00:00
2022-03-01 00:00:00 | 2022-03-01 00:00:00
2022-02-02 00:00:00
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: April

Date | Sales
2022-04-01 00:00:00 | 1
2022-04-02 00:00:00 | 1
2022-04-03 00:00:00 | 1
2022-04-04 00:00:00 | 1
2022-04-05 00:00:00 | 1
2022-04-06 00:00:00 | 1
2022-04-07 00:00:00 | 1
2022-04-08 00:00:00 | 1
2022-04-09 00:00:00 | 1
2022-04-10 00:00:00 | 1
2022-04-11 00:00:00 | 1
2022-04-12 00:00:00 | 1
2022-04-13 00:00:00 | 1
2022-04-14 00:00:00 | 1
2022-04-15 00:00:00 | 1
2022-04-16 00:00:00 | 1
2022-04-17 00:00:00 | 1
2022-04-18 00:00:00 | 1
2022-04-19 00:00:00 | 1
2022-04-20 00:00:00 | 1
2022-04-21 00:00:00 | 1
2022-04-22 00:00:00 | 1
2022-04-23 00:00:00 | 1
2022-04-24 00:00:00 | 1
2022-04-25 00:00:00 | 1
2022-04-26 00:00:00 | 1
2022-04-27 00:00:00 | 1
2022-04-28 00:00:00 | 1
2022-04-29 00:00:00 | 1
2022-04-30 00:00:00 | 1
Spreadsheet: 827036d1682440868-countifs-matchif-forumla-finding-criteria-on-two-sheets-then-comparing-then-count-countifs-help
Sheet: Agreed Access

Name | [NAME] | Access type
Smith | [EMAIL] | DataB1
[NAME] | [EMAIL] | DataB1
Adam | [EMAIL] | DataB1
[NAME] | [EMAIL] | DataB1
[NAME] | [EMAIL] | DataB1
Smith | [EMAIL] | DataB2
[NAME] | [EMAIL] | DataB2
Adam | [EMAIL] | DataB2
[NAME] | [EMAIL] | DataB2
[NAME] | [EMAIL] | DataB2
Smith | [EMAIL] | DataB3
[NAME] | [EMAIL] | DataB3
Adam | [EMAIL] | DataB3
[NAME] | [EMAIL] | DataB3
[NAME] | [EMAIL] | DataB3
Smith | [EMAIL] | DataB4
[NAME] | [EMAIL] | DataB4
Adam | [EMAIL] | DataB4
[NAME] | [EMAIL] | DataB4
[NAME] | [EMAIL] | DataB4
Spreadsheet: 815364d1674905168-error-if-value-in-cell-appeared-already-in-the-last-365-days-please-help-me
Sheet: Sheet1 (3)

Date | [NAME] | False if the person in B appears twice or more in column B and the date is not longer than 12 months ago
2021-11-11 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2021-12-15 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-01-15 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-01-17 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-06-06 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2022-10-23 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-12-14 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2022-12-24 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2023-01-19 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2023-01-16 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out. Employee tried on 24th Dec 22 (row 9) but was rejected; he received code on 15th Jan 22 (row4) |  | should be Free Code
2022-11-12 00:00:00 | [EMAIL] | True | same case as [NAME], row 11 |  | should be Free Code
2023-10-24 00:00:00 | [EMAIL] | True
2023-01-01 00:00:00 | [EMAIL] | True
Spreadsheet: 547197d1510390096-event-study-varying-sample-size-per-event-window-statistically-allowed-event-study_example-file
Sheet: Solutions

 |  | CAR (0,1) | CAR (0,2) | CAR (0,3)
 | N | 96 | 79 | 60 | Number of observations obvously changes - is it allowed to still conclude that CAAR in (0;1) is insignificant while CAAR in (0;2) is significant?
 | CAAR | -0.002597255940255959 | -0.004673852953201522 | -0.002928288644708947
 | t-Test | -1.538928268153696 | -1.852404644455402 | -1.072309898298046
 | P-Value | 0.1271813898414165 | 0.06780004470173034 | 0.2880224109682232
 | Min | -0.04543838213339363 | -0.06316157448041251 | -0.06888446609480427
 | [NAME] | 0.0576911381842358 | 0.05162558879236243 | 0.03943886929819801
 | Std.dev. | 0.01653605802607628 | 0.02242604705745214 | 0.02115286480493491
 | Wilcoxon Z | -1.659057108024803 | -1.969489027968249 | -0.8539459481886751
 | CAAR = cumulative average abnormal return
 | CAR = cumulative abnormal return
Spreadsheet: 74980d1275507528-summing-accross-multiple-worksheets-ron
Sheet: Sheet2

 | 105 | 205 | 305 | 405 | 505
2010-01-01 00:00:00 | 23.45660563958978 | 67.7684888561524 | 75.46175627280904 | 31.04105525762186 | 75.33638510432105
2010-02-01 00:00:00 | 60.09990891006733 | 99.7708095371057 | 70.25316391516903 | 77.45551087500138 | 11.70500338851905
2010-03-01 00:00:00 | 74.04027843473024 | 0.2599437509861247 | 61.93657746092567 | 34.01291150366163 | 19.00141331957068
2010-03-01 00:00:00 | 62.33810577129199 | 75.97097864561928 | 32.11397862695256 | 12.51679530104381 | 48.57935155130595
2010-04-01 00:00:00 | 43.66947985869416 | 18.94428537572792 | 72.95937502390817 | 55.15480980212209 | 96.51976664099192
2010-05-01 00:00:00 | 99.09439223534689 | 41.76088118155627 | 54.74678406417937 | 89.29899430555066 | 26.55577481303926
2010-06-01 00:00:00 | 27.15884334175005 | 25.39713885854102 | 46.43342973139713 | 43.84609205115954 | 33.6027344379056
2010-07-01 00:00:00 | 48.13315932723772 | 33.58761467091173 | 85.0963830241617 | 52.71038029198234 | 89.77754755855551
2010-08-01 00:00:00 | 36.89045280162686 | 26.4272725737122 | 63.37664642753212 | 43.17726479288035 | 65.05023087796005
2010-09-01 00:00:00 | 22.26966477739884 | 79.45015244562042 | 1.079868438090337 | 26.52063048519697 | 80.2446951194083
2010-10-01 00:00:00 | 31.5104788340609 | 4.283467708960309 | 89.06906969919508 | 68.46621579488384 | 27.83802155412847
2010-11-01 00:00:00 | 13.43316015641777 | 4.336859837099727 | 95.34499584154742 | 99.80391124079438 | 76.0796936372305
2010-11-01 00:00:00 | 85.54532931216323 | 18.34238309567457 | 61.67708261999923 | 51.76111101237812 | 67.00395256556403
2010-12-01 00:00:00 | 61.81187475510033 | 66.95084640443683 | 45.39523797406484 | 47.76484329078667 | 19.65865881592328