tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 888186d1738662511-im-not-sure-if-condition-format-for-top-and-bottom-number-with-all-row-by-each-item-testing-condition-format
Sheet: Admin Building

 | BILL OF QUANTITY
 | PROJECT: AIS CAMPUS, SEN SOK
 | LOCATION: PHNOM PENH, SEN SOK.
 | ITEM:  ADD STEEL FRAME FOR MAINTERNANCE AT ADMIN BUILDING
 |  |  |  |  |  | Supplier A |  |  |  | Supplier B |  |  |  | Supplier C
 | No. | Description | Unit | Brand | Qty. | Unit Rate  (USD) |  |  | AMOUNT (USD) | Unit Rate  (USD) |  |  | AMOUNT (USD) | Unit Rate  (USD) |  |  | AMOUNT (USD) | Remark
 |  |  |  |  |  | Material | Labor | Total |  | Material | Labor | Total |  | Material | Labor | Total
 |  | ADD STEEL FRAME FOR MAINTENANCE AC.
 | 1 | Supply material and install Tube:(20x40)mm, Thk 1.4mm.include welding, Anti rush, and Spray Paint. See detail drawing and specification. | m |  | 402.9 | 2.875 | 1.495 |  |  | 2.6222805 | 2.36005245 |  |  | 1.5 | 0.5
 | 2 | Supply material and install Tube:(30x60)mm, Thk 1.8mm.include welding, Anti rush, and Spray Paint. See detail drawing and specification. | m |  | 279.94 | 2.8 | 0.6 |  |  | 4.15833075 | 2 |  |  | 4.15833075 | 3.742497675
 | 3 | Supply material and install [NAME] (40x40)mm, Thk 5mm, include welding, Anti rush, and Spray Paint. See detail drawing and specification. | m |  | 23 | 7 | 2 |  |  | 3.043089000000001 | 2.738780100000001 |  |  | 7 | 1
 | 4 | Supply material to fix [NAME]. include welding, Anti rush, and Spray Paint. See detail drawing and specification. | nos |  | 308 | 1.5 | 1 |  |  | 0.16875 | 0.16875 |  |  | 1.5 | 0.5
 | 5 | Supply material to fix bolt by Sikadur 31CF | set |  | 3 | 35 | 25 |  |  | 29.7 | 13.86 |  |  | 35 | 25
 |  |  |  |  | High price
 |  |  |  |  | Low price
Spreadsheet: 800223d1665553161-salary-calculation-as-per-joining-date-for-payroll-budgeting-sample-date-of-joining-caculation
Sheet: Sample

 | Budget | 2022-01-31 00:00:00
 |  | 2022-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Hire Cost |  |  |  |  |  | Procurement |  |  |  | Medical Insurance |  |  | OFFICE & ADMINISTRATION & IT
Sl. No | Emp. ID | Full Name | Hire Date | Branch | Designation | Department | Brand | BASIC | E-ACCM | E-TRA | E-OTH | E-HEAT | Total Payable | Grand Total | Annual Gross | Pre Medical cost - Unicare | Relocation Allowance | Overseas Hiring -  Cost | Visa - Cost - Inside UAE | Visa - Cost - Outside | Visa Renewal | Uniform & Name Badges | Uniform Quantity | Shoes | Employee Welcome Packs | Medical Insurance | Life Insurance | Work Men Compensation | Telephone Fees | Parking Fees | Salik Expenses | Petrol/ Travel Expenses | Laptop/Desktop/ ipad | Mobile/ [NAME] | Flight Ticket | Addition Allowance | CTC | Jan -22 | Feb -22 | Mar - 22 | Apr -22 | May -22 | June -22 | July - 22 | Aug -22 | Sept -22 | Oct - 22 | Nov -22 | Dec -22
1 | 100012 | ABCD | 2017-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3700
2 | 100013 | EFGH | 2022-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5000
Spreadsheet: 855612d1705132549-groupby-formula-but-sort-with-last-column-of-the-dataset-pivotby-aligw
Sheet: Formula

 |  |  | 1 | 3 | Total | <<<I need to sort this
 | 8210 | 1220 |  | 1879.74 | 1879.74
 | Total |  | 30218.5 | 1879.74 | 32098.23999999999
 | 1620 | 3110 | 10292.19 |  | 10292.19
 | 1210 | 1410 | 10000 |  | 10000
 | 1110 | 3210 | 4494.5 |  | 4494.5
 | 3110 | 1210 | 2208.5 |  | 2208.5
 | 3340 | 3390 | 1621.58 |  | 1621.58
 | 3110 | 1430 | 396.3 |  | 396.3
 | 1430 | 1210 | 380 |  | 380
 | 3340 | 3110 | 377.59 |  | 377.59
 | 7390 | 1620 | 247.03 |  | 247.03
 | 1430 | 1110 | 186 |  | 186
 | 7140 | 3110 | 13.81 |  | 13.81
 | 7380 | 1210 | 1 |  | 1
Spreadsheet: 548639d1511247772-extract-data-in-excel-test-for-excel-forum
Sheet: Sheet1

THIS TYPE FILE:
No. | NAME | Sanc Amount | Sanc Date | Exp Date
 |  | Disb Amount | Disb Date | Overdue Date
 |  | Instalment Amount | Inst Date | Date
10-810-7 | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013
 |  | 310000 | 05-12-2002 | 30-06-1999
 |  | 2585 | 27-09-2008
10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016
 |  | 900000 | 09-11-2009 | 24-04-2014
 |  | 16619 | 09-01-2010
11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018
 |  | 200000 | 27-06-2013 | 05-11-2015
 |  | 4758 | 27-07-2013
WANT CHANGES LIKE THIS
No. | NAME | Sanc Amount | Sanc Date | Exp Date | Disb Amount | Disb Date | Overdue Date | Instalment Amount | Inst Date | Date
10-810-7 | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013 | 310000 | 05-12-2002 | 30-06-1999 | 2585 | 27-09-2008
10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016 | 900000 | 09-11-2009 | 24-04-2014 | 16619 | 09-01-2010
11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018 | 200000 | 27-06-2013 | 05-11-2015 | 4758 | 27-07-2013
Spreadsheet: vkaminski__40915__LJM Simulation3
Sheet: Assumptions and Methodology

Goals of the model:
to model the terminal values of the raptor structures
to study the implication of cross-guarantees among raptors on LJM
Methodology:
Estimate drift and volatility terms from a two year history of daily stock prices by using market data on self or comparables
Use portfolio approach to reduce the size of the covariance matrix (Portfolio definition included in the raptor sheets)
Simulate to obtain the distribution of the terminal values of the raptors
Calculate the impact on LJM
The assets in the vehicles are aggregated in the following portfolios
ENE Stock (ENE)
Total Public Exposure of Raptor 1 (PUBR1)
Total Private Exposure except Merlin Put of Raptor 1 (PRIVR1)
Hanover Compressor of Raptor 2
Total Brazilian Exposure (CEG+Gaspart+Riogas+Other) in Raptor 2 (BRASR2)
TNPC Stock (TNPC)
The sources of data for the valuation are as follows
The raptor spreadsheets (obtained from [NAME]) provided information on the assets and liabilities of raptor vehicles (raptor1h, raptor2b, raptor3b, and raptor4.xls)
RAC ([NAME]) provided the spreadsheet, Raptor [NAME], for data on market values of Raptor 1 private exposure and Raptor 2 Brazilian exposure.
[NAME] spreadsheets provided more up-to-date figures on the raptors.
Assumptions/Questions/Notes
The drifts for assets are beta based except for privates in R1 (set to 10%)
Riskfree Rate = 6%, Market Return = 16%, Betas calculated using last three years' data, unless not available.
Volatilities are implied from options contracts.
Privates are marked to the market for strike prices, publics and Brazilians have definite prices
Private exposure debt added directly to equity and convertibility of Venoco is ignored
Brazilian exposure uses RAC numbers except for the category "Others" where notional is used due to the inavailability of RAC figures
Spreadsheet: 840171d1692531081-dynamic-formula-to-pull-data-from-multiple-columns-in-a-specific-manner-dynamic-array-question
Sheet: Inputs

 |  |  |  | *List of questions in Column B are assumed to be unlimited (upto excel row limitations)
 |  |  |  | *List of answers & Weights below each question in the table are also assumed to be unlimited (upto excel row limitations)
 | List of questions | Table headers
 |  |  |  |  | Weight | Answer | Weight | Answer | Weight | Answer | Weight
 | Question 1 | Answer |  | Q1 A1 | 0.35 | [NAME] | 0.45 | [NAME] | 0.2 | [NAME] | 0.2
 | Question 2 | Weight |  | Q1 A2 | 0.25 | [NAME] | 0.55 | [NAME] | 0.4 | [NAME] | 0.3
 | Question 3 |  |  | Q1 A3 | 0.1 |  |  | [NAME] | 0.4 | [NAME] | 0.25
 | Question 4 |  |  | Q1 A4 | 0.15 |  |  |  |  | [NAME] | 0.25
 |  |  |  | Q1 A5 | 0.1
 |  |  |  | Q1 A6 | 0.05
Spreadsheet: 06eca52a-1628-41d1-9b27-b5e707d57e6a
Sheet: Sheet1

STATE OF WEST VIRGINIA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
OFFICES OF THE INSURANCE COMMISSIONER
1124 Smith Street, Charleston WV  25301
Phone:  (304)558-2100
Fax:  (304)558-1365
www.wvinsurance.gov
Required of Domestic Property & Casualty, Financial Guaranty, Mortgage Guaranty, or Accident & Sickness Insurer
Company Name:
NAIC Code:
Supplement to Annual Statement for the Period:
Reconciliation and Summary of Assets and Reserve Requirement under W. Va. Code §33-8-22.  Calculation can be based on discounted (using IRS factors) or undiscounted loss and LAE Reserves.  For purposes of these calculations, the Loss and LAE Reserve shall be determine net of anticipated salvage and subrogation, and gross of any discount for the time value of money or tabular discount.
 |  |  |  |  | $ [NAME]
Qualifying Investments §33-8-22(a)
a. Cash, cash equivalents and ST investments |  |  |  |  | 0
[NAME] rated credit instruments and preferred stock (SVO 1, 2, or 3) |  |  |  |  | 0
c. Qualifying ST rated credit instruments and preferred stock (SVO 1, 2, or 3) |  |  |  |  | 0
d. Qualifying domestic equities |  |  |  |  | 0
e. Qualifying foreign investments and hedged foreign currency exposures |  |  |  |  | 0
f. Qualifying investments acquired pursuant to statutorily allowed additional investment authority |  |  |  |  | 0
6. Interest and dividends receivable on qualifying investments |  |  |  |  | 0
7. Reinsurance recoverable on paid losses |  |  |  |  | 0
Total Qualifying Investments |  |  |  | 1 | 0
Adjusted Loss and Loss Adjustment Expense Reserves §33-8-22-(b)(1)
Statutory Loss Reserves * |  |  |  |  | 0
Statutory Loss Adjustment Expense Reserves * |  |  |  |  | 0
* If discounted, please show calculation and discount factors used to adjust reserves.
Total Adjusted Loss and Loss Adjustment Expense Reserves |  |  |  | 2 | 0
Adjusted [NAME]§33-8-22(b)(2)
[NAME] Reserves |  |  |  |  | 0
Less Admitted Asset Amounts of:
[NAME] Agents' Balances in Course of Collection |  |  |  |  | 0
[NAME] and Health Premiums Due and Unpaid |  |  |  |  | 0
[NAME] Health Premiums |  |  |  |  | 0
d.  Premiums, agents' balances, and installments booked but deferred and not yet due |  |  |  |  | 0
e.  Bills Receivable, taken for Premium |  |  |  |  | 0
Adjusted Unearned Premium Reserve |  |  |  | 3 | 0
Statutorily Required Policy and Contract Reserves §33-8-22(b)(3) |  |  |  | 4 | 0
Total Reserve Requirement     (Lines 2 + 3 + 4) |  |  |  | 5 | 0
Excess/(Deficiency) of Qualifying Investments over Reserve Requirement    (Line 1 minus 5) |  |  |  |  | 0
Note:  If a deficiency exists, the insurer is required to submit an explanation for why the deficiency exists, and a plan of action to remedy the deficiency.  The plan should be forwarded within thirty (30) days of this filing.
Compliant with provisions of 33-8-22(a) & (b) |  |  |  |  | YES
Spreadsheet: 726776d1617448830-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Journal Entries

 | MONTHLY EXPENSES SUMMARY |  | CHARITABLES & SPONSORSHIPS
 | Journal Entries
 | Date | Item Code | Descrtiption of Transaction | Amt. | Transaction Type | Ref/ Invoice No. | Cheque No. | Request/ Received By | Journal Entry By | Payee/Donor Details | Debit Amt. | Credit Amt. |  |  |  | Month | Date
 | 2018-01-21 00:00:00 |  | Internet Charges | 2000 | Credit
 | 2021-02-25 00:00:00 |  | Building Rent | 35000 | Credit
 | 2018-12-20 00:00:00 |  | Statationery | 1500 | Credit
 | 2018-12-21 00:00:00 |  | Statationery | 2500 | Credit
 | 2018-12-22 00:00:00 |  | Furniture
 | 2018-12-23 00:00:00 |  | Statationery
 | 2018-12-24 00:00:00 |  | Computers
 | 2018-12-25 00:00:00 |  | Fuel
 | 2018-12-26 00:00:00 |  | Building Rent
 | 2018-06-27 00:00:00 |  | Computers | 3000 | Credit
 | 2018-10-28 00:00:00 |  | [NAME]
Spreadsheet: 49232d1248459016-minimum-distance-between-points-mininumdistance
Sheet: Distance (km)

From / To | [NAME] | CUST_02 | CUST_03 | CUST_04 | CUST_05
[NAME] | 0 | 22.2 | 21.7 | 18.9 | 18.7
CUST_02 | 22.2 | 0 | 0.6 | 3.4 | 3.6
CUST_03 | 21.7 | 0.6 | 0 | 2.8 | 3.1
CUST_04 | 18.9 | 3.4 | 2.8 | 0 | 0.3
CUST_05 | 18.7 | 3.6 | 3.1 | 0.3 | 0
Day 1 | 1 | 0 | 1 | 0 | 0 |  | should be | 21.7
Day 2 | 1 | 0 | 0 | 1 | 0 |  | should be | 18.9
Day 3 | 1 | 0 | 1 | 0 | 1 |  | should be | 3.1
Day 4 | 0 | 1 | 0 | 1 | 1 |  | should be | 0.3
Day 5 | 1 | 1 | 0 | 1 | 1 |  | should be | 0.3
Spreadsheet: 223987d1364401340-autopopulating-several-sheets-from-1-sheet-with-drop-down-list-cost-tracking-test
Sheet: MASTER PO LOG

Date | PO # | Description | Vendor | Amount | Category
2013-01-11 00:00:00 | S-10000 | ARGON GAS | WELDING SUPPLIES UNLIMITED | 6000 | REIMBURSABLE CONSUMABLES
2013-01-12 00:00:00 | S-10001 | 22 TON DROTT | HERTZ | 2350 | REIMBURSABLE EQUIPMENT
 |  |  |  |  |  |  |  |  |  | REIMBURSABLE CONSUMABLES
 |  |  |  |  |  |  |  |  |  | NON-REIMBURSABLE CONSUMABLES
 |  |  |  |  |  |  |  |  |  | REIMBURSABLE EQUIPMENT
 |  |  |  |  |  |  |  |  |  | NON-REIMBURSABLE EQUIPMENT
 |  |  | TOTAL | 8350
Spreadsheet: 7641884c-5264-4b49-8999-5409b11a774f
Sheet: Calculator

 | Duct Testing Calculator (New Construction) |  |  |  |  |  |  | 0.08 | 0.06 | 0.04
 | House address or lot #:
 | Conditioned Floor Area:
 | Duct tester location:
 | Pressure tap location:
 | Ring (if applicable): | Open | 1                2                3
 | At Rough-in (Total Leakage)
 | Test Method | Standard1 |  | Calculated Target | Test2 CFM25
 | Air Handler Present | ≤ 6 CFM25 per 100 sf of CFA
 | Air Handler not Present | ≤ 4 CFM25 per 100 sf of CFA
 | Post Construction
 | Test Method | Standard1 |  | Calculated Target | Test2 CFM25
 | Air Handler Present               (Total Leakage) | ≤ 8 CFM25 per 100 sf of CFA
 | Air Handler Present           (Leakage to Exterior) | ≤ 6 CFM25 per 100 sf of CFA
 | 1.  Test results must comply with one of the Standards options.
 | 2.  Test CFM25 must be equal to or less than the calculated target.
 | Air Leakage testing Calculator (Blower Door Test)
 | Standard | Tested CFM50 |  | Test Result (SLA) |  |  |  | 0.055 | 144
 | 0.00030 SLA                  ((CFM50 X 0.055) / (CFA X 144))
 | Glossary
 | Rough-In:  After installation of the complete air distribution system but before installation of insulation and sheet rock.  Allows for access to all duct seams and connections for re-evaluation of seal integrity if standard is not met in intitial test.
 | Post Construction:  At or near final inspection.  The home must be complete enough to pressurize the home to 25 pa.
 | Total Leakage:  Aggregation of the entire systems duct leakage in a duct test.
 | Leakage to Exterior:  Aggregation of all duct system leaks to the exterior of the CFA in a duct test.
 | CFA:  Conditioned floor area
 | CFM25:  Cubic feet per minute of air leakage at 25 pascals of pressure
 | CFM50:  Cubic feet per minute of air leakage at 50 pascals of pressure
 | Pascal (pa):  Unit of pressure
 | SLA:  Specific leakage area
 | Duct Testing Code Language
 | Air Leakage Testing Code Language
Spreadsheet: 93232d1292855356-in-a-pivot-table-copy-of-book2-2
Sheet: Sheet4

 | Month
Data | JAN | FEB | MAR | APR | Grand Total
Sum of Sold | 10155 | 7053 | 6326 | 6037 | 29571
Sum of Capacity | 15518 | 15636 | 17793 | 18810 | 67757
Sum of Ave | 0.6544013403789148 | 0.4510744435917114 | 0.3555330748046985 | 0.3209463051568315 | 0.4364272326106527
% | 0.6544013403789148 | 0.4510744435917114 | 0.3555330748046985 | 0.3209463051568315 | 0.4364272326106527
Spreadsheet: 4933eb65-ab44-4283-b965-251fceacf266
Sheet: Table 4.3

4.3 Dwelling approvals
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Number (a)
\
July | 13004 | 15072 | 13064 | 11182 | 14656
August | 12856 | 15018 | 14783 | 12860 | 14363
September | 14038 | 13561 | 12007 | 13745 | 16791
October | 13447 | 15162 | 11138 | 13400 | 16491
November | 14891 | 14121 | 11895 | 13516
December | 15404 | 15380 | 11895 | 13290
January | 15612 | 13919 | 11739 | 13081
February | 15436 | 12928 | 11879 | 13421
March | 16898 | 14269 | 11996 | 12901
April | 16025 | 13797 | 10635 | 14592
May | 14883 | 12674 | 14239 | 14088
June | 14578 | 12612 | 14712 | 13396
Annual | 177072 | 168513 | 149982 | 159472
Annual change (a) – per cent
July | 0.5645348387595845 | 15.90279913872654 | -13.32271762208069 | -14.40600122473974 | 31.06778751565017
August | 3.393919897056463 | 16.8170504044804 | -1.564788919962709 | -13.00818507745383 | 11.68740279937792
September | 21.48853310255301 | -3.397919931614197 | -11.45933190767643 | 14.47488964770551 | 22.16078574026919
October | 18.54888477475095 | 12.75377407600209 | -26.54003429626698 | 20.30885257676422 | 23.06716417910448
November | 43.155162468756 | -5.170908602511588 | -15.76375610792437 | 13.62757461118116
December | 49.69873663751216 | -0.1558036873539379 | -22.65929778933679 | 11.72761664564943
January | 60.53470437017995 | -10.844222393031 | -15.66204468711832 | 11.43197887383933
February | 43.6040561912736 | -16.2477325732055 | -8.114170792079207 | 12.98089064736089
March | 56.75324675324674 | -15.55805420759853 | -15.92963767608101 | 7.544181393797928
April | 34.58469807676155 | -13.90327613104525 | -22.91802565775168 | 37.20733427362481
May | 36.88034581072381 | -14.84243768057515 | 12.34811424964495 | -1.060467729475391
June | 21.96101397138794 | -13.48607490739471 | 16.65080875356804 | -8.945078847199568
Annual | 31.22082079708319 | -4.833626999186769 | -10.99677769667622 | 6.327425957781596
(a) Monthly figures are seasonally adjusted.
Source: ABS, Building approvals, Australia, cat. no. 8731.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/8731.0Dec%202007?OpenDocument | http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/8731.0Dec%202007?OpenDocument | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=8731.0&viewtitle=Building%20Approvals,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=8731.0&issue=Jan%202008&num=&view=& |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-01-09 00:00:00
Spreadsheet: 104530d1302107918-excel-2007-help-with-formula-on-lookup-info-or-matching-info-2011-okc-supply-tracking-sheet-testing
Sheet: 2011 Supplies TRACKING

Reorder # | Product Description | Order Type | AOM Order Request Date | Qty | Unit Price | Amount to be Billed |  | AOM Approval | AOM Approval Date |  | Ship Order # | Ship Order Date | PO Number | Billable Customer No. | Contract # | [NAME] | Ship To | Pricing Exception (Y or N) | Description
22551 |  | PSTD | 2011-12-03 00:00:00 | 2 | 10 | 20
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 89579d1289365794-cell-value-changes-another-cell-or-displays-a-notification-timecard
Sheet: Expense Voucher

 | AZO. EXPENSE REPORT
 |  |  |  |  | Name: |  |  |  | Dept: |  |  | Date: | 2010-11-09 23:03:35
 | Billable |  | [NAME] | Job # |  | Engr | Install | Warranty |  | Sales | Other
 | Dates of | Destination |  |  | Meals |  |  | Lodging | Airfare | Taxi/Limo | Auto | Auto | Total
 | Travel | From | To | Breakfast | Lunch | Dinner | Total Meals |  |  | Etc. | Rental | Mileage | Meals/Travel
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  | TOTALS |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ENTERTAINMENT EXPENSES
 | Date | Person/Group Entertained |  |  | Explanation: Location, Bus, Purpose |  |  |  | Amount |  | Grand Total |  | 0
 |  |  |  |  |  |  |  |  |  |  | Total of ALL Travel, Entertainment,
 |  |  |  |  |  |  |  |  |  |  | and [NAME]
 |  |  |  |  |  |  |  |  |  |  | Company Expense |  | 0
 |  |  |  |  |  |  |  |  |  |  | Balance Due Employee |  | 0
 | TOTAL |  |  |  |  |  |  |  | 0
 | [NAME] EXPENSES (phone, parking/tolls, postage, non-meal tips, etc.)
 | Date |  |  | Item and/or Explanation |  |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Signature of Person Submitting
 |  |  |  |  |  |  |  |  |  |  | Approved By
 | TOTAL |  |  |  |  |  |  |  | 0
Spreadsheet: 754048d1635902085-aggregating-time-overlapping-events-samplefile
Sheet: Current process

Agent | Event Type | Start Time | End Time | 2021-11-01 08:00:00 | 2021-11-01 08:30:00 | 2021-11-01 09:00:00 | 2021-11-01 09:30:00 | 2021-11-01 10:00:00 | 2021-11-01 10:30:00 | 2021-11-01 11:00:00 | 2021-11-01 11:30:00 | 2021-11-01 12:00:00 | 2021-11-01 12:30:00 | 2021-11-01 13:00:00 |  | <--- Columns I want to remove.
[NAME] | 1 | 2021-11-01 08:00:00 | 2021-11-01 08:05:00
[NAME] | 2 | 2021-11-01 08:05:00 | 2021-11-01 10:05:00
[NAME] | 2 | 2021-11-01 10:05:00 | 2021-11-01 11:10:00
[NAME] | 2 | 2021-11-01 11:10:00 | 2021-11-01 12:30:00
[NAME] | 2 | 2021-11-01 12:30:00 | 2021-11-01 13:00:00
[NAME] | 1 | 2021-11-01 08:00:00 | 2021-11-01 08:05:00
[NAME] | 2 | 2021-11-01 08:05:00 | 2021-11-01 09:05:00
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Results I want to replicate on a separate tab
Spreadsheet: 9fd0eab4-e45b-45e8-b93b-e30a18fa3ed8
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=246
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-25 7:39 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits (Seasonally Adjusted) | 2011-12-23 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2011-12-23 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2011-12-23 00:00:00 | Current
Notes:
Census data seasonally adjusted by the Federal Reserve Bank of Saint | 2011-12-23 00:00:00 | Current
Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
2014-04-24 00:00:00
2014-05-27 00:00:00
2014-06-25 00:00:00
2014-07-25 00:00:00
2014-08-26 00:00:00
2014-09-25 00:00:00
Spreadsheet: 848245d1699005301-sumifs-not-picking-up-multiple-criteria-spend-tracker-example
Sheet: Spend

Category | Date of Purchase | Cost Per Item | Quantity | Total
Blue | 2023-04-09 00:00:00 | 1000 | 1
Green | 2023-07-21 00:00:00 | 1000 | 2
Yellow | 31/07/2023 | 5600 | 1
Orange | 2023-08-01 00:00:00 | 634 | 1
Blue | 2023-08-01 00:00:00 | 16900 | 1
Orange | 2023-08-24 00:00:00 | 3.99 | 12
Pink | 25/08/2023 | 595 | 1
Green | 30/08/2023 | 0.33 | 500
[NAME] | 2023-09-01 00:00:00 | 9.99 | 20
[NAME] | 2023-09-04 00:00:00 | 18560 | 1
Spreadsheet: 701420d1603748876-formula-to-compare-tables-and-flag-rows-that-have-been-updated-customer-list-abell-
Sheet: New Table

ADDRESS_NO | Account_ID | ADDRESS_TYPE | CUSTOMER | [NAME] | ADDRESS_2 | CITY | PROVINCE | POST_CODE | [NAME] | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | AIAC01 | AIAC05 | AIAC08 | ABAC04/L01 | DRDL01 | [NAME] | Flag
1 | End | End | Customer 1 | 1212 second street |  | Toronto | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20
2 | End | End | Customer 2 | 1225 third street |  | Mississauga | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20
3 | End | End | Customer 3 | 1225 third street |  | Mississauga | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20