tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814690d1674555408-calculating-pay-dates-payroll-dates
Sheet: Sheet1

 |  |  |  |  |  |  | Federal Holidays
 |  |  |  |  |  |  | 2023-01-02 00:00:00 | New Year’s Day
 |  |  |  |  |  |  | 2023-01-16 00:00:00 | Birthday of [NAME], Jr.
 |  |  |  |  |  |  | 2023-02-20 00:00:00 | Washington’s Birthday
 |  |  |  |  |  |  | 2023-05-29 00:00:00 | Memorial Day
 |  |  |  |  |  |  | 2023-06-19 00:00:00 | Juneteenth National Independence Day
 |  |  |  |  |  |  | 2023-07-04 00:00:00 | Independence Day
 |  |  |  |  |  |  | 2023-09-04 00:00:00 | Labor Day
 |  |  |  |  |  |  | 2023-11-09 00:00:00 | Columbus Day
 |  |  |  |  |  |  | 2023-11-10 00:00:00 | Veterans Day
 |  |  |  |  |  |  | 2023-11-23 00:00:00 | Thanksgiving Day
 |  |  |  |  |  |  | 2023-12-25 00:00:00 | Christmas Day
 | Pay Period 1 | Pay Period 2 | Pay Period 3 | Pay Period 4 | Pay Period 5 | Pay Period 6 | Pay Period 7 | Pay Period 8 | Pay Period 9 | Pay Period 10 | Pay Period 11 | Pay Period 12 | Pay Period 13 | Pay Period 14 | Pay Period 15 | Pay Period 16 | Pay Period 17 | Pay Period 18 | Pay Period 19 | Pay Period 20 | Pay Period 21 | Pay Period 22 | Pay Period 23 | Pay Period 24
 | 2023-01-01 00:00:00
 | 2023-01-15 00:00:00
10 Days after EOM
Legal Pay Date |  |  | 2023-02-24 00:00:00 |  | 2023-03-24 00:00:00 |  |  |  |  | 2023-06-09 00:00:00 | 2023-06-23 00:00:00 |  |  |  |  | 2023-09-08 00:00:00 |  |  |  |  | 2023-11-24 00:00:00 | 2023-12-08 00:00:00 | 2023-12-22 00:00:00
Accelerated Pay Date Reason |  |  | Payday is on Saturday |  | Payday is on Saturday | Payday is on Saturday |  |  |  | Payday is on Saturday | Payday is on Sunday |  |  |  |  | Payday is on Sunday |  |  |  |  | Payday is on Saturday | Payday is on Sunday | Payday is on Federal Holiday
Spreadsheet: 153869d1336075079-easy-one-i-think-copy-of-book1-1
Sheet: Sheet1

Number | Item
2 | A |  |  | A=?
4 | B |  |  | B=?
6 | C |  |  | C=?
8 | A |  |  | D=?
10 | A |  |  | E=? |  | Row Labels | Sum of Number
12 | A |  |  |  |  | A | 32
14 | B |  |  |  |  | B | 18
16 | C |  |  |  |  | C | 22
18 | D |  |  |  |  | D | 38
20 | D |  |  |  |  | E | 72
22 | E |  |  |  |  | Grand Total | 182
24 | E
26 | E
Spreadsheet: 870826d1717267569-sumifs-not-working-as-i-thought-it-would-expenses
Sheet: Summary

Month | Food | Travel | Hospitality | Accommodation | Total
2024-04-01 00:00:00 | =SUMIFS(Records!$F$1:$F,Records!$H$1:$H,>=&A2,Records!$F$1:$F,<&(EOMONTH($A2,0)+1),Records!$G$1:$G,=&B$1) |  |  |  | £-
2024-05-01 00:00:00 | =SUMIFS('Records'!F:F,'Records'!H:H,>='Summary'!A2,'Records'!F:F,<&(EOMONTH('Summary'!A2,0)+1),'Records'!G:G,='Summary'!B$1) |  |  |  | £-
2024-06-01 00:00:00 |  |  |  |  | £-
2024-07-01 00:00:00 |  |  |  |  | £-
2024-08-01 00:00:00 |  |  |  |  | £-
2024-09-01 00:00:00 |  |  |  |  | £-
2024-10-01 00:00:00 |  |  |  |  | £-
2024-11-01 00:00:00 |  |  |  |  | £-
2024-12-01 00:00:00 |  |  |  |  | £-
2025-01-01 00:00:00 |  |  |  |  | £-
2025-02-01 00:00:00 |  |  |  |  | £-
2025-03-01 00:00:00 |  |  |  |  | £-
Total | £- | £- | £- | £- | £-
Spreadsheet: 105810d1303108979-how-to-remove-s-0-9-and-spaces-regexp-sept-1-2004
Sheet: Ex 5 Change cell reference $

Menu Page
 | [NAME] | [NAME] (UDF shows B cell formula)
 | Menu Page
 | 0
 | 1
 | 0
 | 1
 | 0
 | #N/A
 | #N/A
 | Test
 | FRED270
 | Change Me then [NAME]
Cell Reference Type | Rel
[NAME] to change | 1
 | Macro | RegExp_Early_Execute_5
 | Global | 1
 | IgnoreCase | 0
 | Current Direction Pattern | (?:[\^\])-/+*:,="[(])(\$?)([A-Z]{1,2})(\$?)(\d{1,5})
 | Dave's Direction Pattern | (?:[\^\])-/+*:,="[(])(\$?)([A-Z]{1,2})(\$?)(\d{1,5})
 | User Defined Function | ReplaceRef(Cel.[NAME], "Abs", 2)
 | Abs | 1
 | Rel | 2
 | Row | 3
 | Col | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
Spreadsheet: 26232d1218187396-how-to-auto-highlight-higher-value-cell-in-same-row-when-enter-copy-of-example
Sheet: Sheet1

100 |  | 99
110 |  | 118
98 |  | 110
78 |  | 72
99 |  | 100
123 |  | 130
234 |  | 224
168 |  | 150
22 |  | 14
25 |  | 56
45 |  | 22
33 |  | 75
101 |  | 145
Spreadsheet: 752708d1634908200-formula-to-sort-by-road-name-first-then-by-house-number-test-worksheet-to-sort-formula
Sheet: Sheet1

 | 150/152 & 154/158 [NAME] | 1 Bell Road | 2 Bell Road | Cottage | 13 Oak Road | 18 Oak Road | 14 Random Street | 2 Random Street | 22 Random Street
Income
Commercial Rental Income | 13041.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Receivable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Residential Rental Income | 0 | 292 | 2130 | 3490 | 409.5 | 370 | 388 | 5195 | 328
Total Income
Spreadsheet: 146114d1331904951-extract-from-1-sheet-to-many-sum-total-not-working-extract-from-1-sheet-to-many-sheets
Sheet: NEVILLE COLE

SAMPLE CYCLE TEST RUNS
[NAME] | TECHNICIAN | CYCLE A |  | CYCLE B |  | CYCLE C |  | CYCLE D |  | CYCLE E |  | CYCLE F
 |  | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart
RUN 11 | NEVILLE COLE | 21 | 17.BB | 110 | 13.BB | 62 | 9.RR | 64 | 11.DB | 66 | 9.ZH | 40 | 16.DD
RUN 12 | NEVILLE COLE | 23 | 12.A | 120 | 13.BB | 67 | 11.AH | 69 | 11.DB | 71 | 11.DX | 42 | 16.DD
TOTALS |  | 44 |  | 230 |  | 129 |  | 133 |  | 137 |  | 82
Spreadsheet: 480707d1474032553-if-or-true-statement-for-choosing-the-currency-to-calculate-exchange-rates-costing-format-2
Sheet: Cost of Execution

 |  |  |  |  |  | RATE | 470
S/N |  | QTY |  |  |  |  |  |  | CONTRACT SUM
1 | oil tester | 1 | 3809.25 | 3809.25 |  | COST | 3809.25 |  | 4143265.43 | 1 | 4143265.43 |  |  |  |  |  | 0 | 0
2 |  | 0 | 0 | 0 |  | TRANSFER COST | 90 |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
3 |  | 0 | 0 | 0 |  | FREIGHT | 100 |  | 0 | 0 | 0 |  |  |  |  |  | 940349.9 | 1880699.8
4 |  | 0 | 0 | 0 |  |  | 3999.25 |  | 0 | 0 | 0 |  |  |  |  |  | 415571.8 | 831143.6
5 |  | 0 | 0 | 0 |  | L/C 1% | 39.9925 |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
6 |  | 0 | 0 | 0 |  | VAT OF L/C | 1.999625 |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
7 |  | 0 | 0 | 0 |  |  | 4041.242125 |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
8 |  | 0 | 0 | 0 |  | COE | 1899383.79875 |  | 0 | 0 | 0 |  |  |  |  |  | 1985571.44 | 3971142.88
9 |  | 0 | 0 | 0 |  | CONT SUM | 4350428.7015 |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
10 |  | 0 | 0 | 0 |  | WHT/VAT | 414326.5430000001 |  | 0 | 0 | 0 |  |  |  |  |  | 70000 | 140000
 |  |  | S. TOTAL | 3809.25 |  | LESS TAX | 3936102.1585 |  | 0 | 0 | 0 |  |  |  |  |  | 70000 | 140000
 |  |  |  |  |  | PROFIT | 2036718.359750001 |  |  |  | 4143265.43 |  |  |  |  |  |  | 6962986.279999999
 |  |  |  |  |  | TRANSPORT | 0 |  |  |  | 207163.2715
1 | elec tool | 0 | 70000 | 0 |  | P/R | 0 |  |  |  | 4350428.7015 |  |  |  |  |  |  | 6962986.279999999
2 | mech tool | 0 | 70000 | 0 |  | LESS PR/TR | 2036718.359750001
3 | [NAME] | 0 | 10000 | 0 |  | INT 3mths@28% | 131681.9370612842 |  | DIFF
4 |  | 0 | 0 | 0 |  |  | 1905036.422688716 |  | COE |  | 1899383.79875
5 |  | 0 | 0 | 0 |  |  |  |  | AMT DEPOSITED |  | 569815.139625 |  |  |  |  |  |  | 6754096.6916
 |  |  | S. TOTAL | 0 |  |  | 0.4378962519330272 |  | BANK |  | 1329568.659125
Spreadsheet: 766317d1643836923-tiered-pricing-help-needed-gbs-tiered-model
Sheet: Sheet1

GBs | AP | AU | CA | EU | IN | JP | SA | ME | US | ZA
0 | 0.12 | 0.114 | 0.085 | 0.085 | 0.109 | 0.114 | 0.11 | 0.11 | 0.085 | 0.11
10001 | 0.1 | 0.098 | 0.08 | 0.08 | 0.085 | 0.089 | 0.105 | 0.105 | 0.08 | 0.105
50001 | 0.095 | 0.094 | 0.06 | 0.06 | 0.082 | 0.086 | 0.09 | 0.09 | 0.06 | 0.09
150001 | 0.09 | 0.092 | 0.04 | 0.04 | 0.08 | 0.084 | 0.08 | 0.08 | 0.04 | 0.08
500001 | 0.08 | 0.09 | 0.03 | 0.03 | 0.078 | 0.08 | 0.06 | 0.06 | 0.03 | 0.06
1024001 | 0.07 | 0.085 | 0.025 | 0.025 | 0.075 | 0.07 | 0.05 | 0.05 | 0.025 | 0.05
5024000 | 0.06 | 0.08 | 0.02 | 0.02 | 0.072 | 0.06 | 0.04 | 0.04 | 0.02 | 0.04
EU
[NAME] (example) | 4549.490000000001 | 2393.2025 | 29683.3525 | 101164.8075 | 1835.6875 | 1019.1725 | 585.1624999999999 | 3644.995 | 363620.76 | 1461.9
Cost $
Spreadsheet: 006ecdbe-bc08-4e5e-bff4-5c1832957677
Sheet: Sheet1

Ohio Department of Education | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | PCR Request
25 South Front Street, MS G03 w Columbus, OH 43215 |  |  |  |  |  |  |  | SUBMIT TWO COPIES
Entity Name |  |  | IRN |  | County |  | Project #
1.  General Information
C.F.D.A. Number
U.S.A.S. Fund Code
Cost Center Number
2.  Total Cash Basis Expenditures by Object Code
Salaries/100
[NAME]
Purchased Services/400
Supplies/500
Capital Outlay/600
Other/800
3.  Fiscal Summary
Allocation
Available Budget
Fiscal Information As Of
Cash Received
Total Cash Basis Expenditures |  |  |  |  |  |  |  | 0
Cash Balance On Hand |  |  |  |  |  |  |  | 0
Cash Available |  |  |  |  |  |  |  | 0
4.  Fund Request
Negative Amount
Advance Amount
Advance Period
Total Amount Requested |  |  |  |  |  |  |  | 0
5.  [NAME]
Explain need for Advance Amount in excess of 10% of Available Budget
Explain need for Advance Amount when Cash Balance On Hand exceeds 10% of Available Budget
As required by the Cash Management Improvement Act (codified as 31 CFR part 205 and 34 CFR 80.20 and 80.21), cash advances are limited to the immediate cash needs of the requesting entity. By submitting this cash request, the entity certifies that this request is in compliance with the Cash Management Improvement Act and 34 CFR 80.20 and 80.21 and will be disbursed in the month for which funds were requested. For cash requests submitted in July, August or September entity certifies that the underlying obligations were made prior to June 30. Additionally, by submitting this cash request, the entity certifies that the obligations incurred under this project, for which funds are requested, were made within the period of availability outlined in the grant agreement.
Name of Treasurer or CFO (typed) |  |  |  | Signature of Treasurer or CFO |  |  |  | Date
Address |  |  |  | City |  | State: |  | Zip
Telephone |  |  | Ext | FAX |  | E-Mail
Spreadsheet: 2627bc42-c213-4bd0-9f7b-d1344ecc5dfa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Motor cars and station wagons - New ; |  |  | Original | A2413502X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Motor cars and station wagons - Used ; |  |  | Original | A2413503A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Light trucks - New ; |  |  | Original | A2413504C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Light trucks - Used ; |  |  | Original | A2413505F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Heavy trucks - New ; |  |  | Original | A2413506J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Heavy trucks - Used ; |  |  | Original | A2413507K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Other motor vehicles ; |  |  | Original | A2413508L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413509R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 814658d1674532030-bringing-back-a-table-header-from-a-min-function-1
Sheet: Sheet1

vendor 1 |  |  |  | vendor 2 |  |  |  | vendor 3
Currency | Unit Price | UoM |  | Currency | Unit Price | UoM |  | Currency | Unit Price | UoM |  | Best Price AUD | Supplier
AUD | 50 | each |  | AUD | 66 | each |  | AUD | 12 | each
Spreadsheet: 107117d1304340405-changing-today-referance-in-a-formula-to-a-cell-referance-sample-data-workbook
Sheet: New 

 | Today + 30 Days | Today + 60 Days | Today + 90 Days | Today + 120 Days
2011-05-02 00:00:00
 |  |  |  |  |  |  |  |  | Today
 |  |  |  |  | Date: | 2011-05-02 00:00:00
Customer Name:
Customer Add 1:
Customer Add 2:
[NAME]:
Contact No:
Statement
Date | Invoice No | Details | Debit | Credit | Date of Receipt | Balance
2010-12-28 00:00:00 | xyzxxx | abcdefg | 25 | 25
2011-04-27 00:00:00 | xyzxxx | abcdefg | 25
2011-02-25 00:00:00 | xyzxxx | abcdefg | 25
2011-03-28 00:00:00 | xyzxxx | abcdefg | 25 | 0
2011-04-25 00:00:00 | xyzxxx | abcdefg | 25
2011-03-28 00:00:00 | xyzxxx | abcdefg | 25
Total
Total Amount Due
Less than 30 Days | 30 Days | 60 Days | 90 Days | 120+ Days
Address:
Address:
Address:
Address:
Today + 30 Days | Today + 60 Days | Today + 90 Days | Today + 120 Days
Spreadsheet: 7e4f778e-c8fd-457d-9896-cb1f430eb5d5
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
RUPR | Test | RUPR | Rabbit Urine Proteins, IgE | Rabbit Urine Proteins, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RUPR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RUPR | Result | RUPR | Rabbit Urine Proteins, IgE | Rabbit Urine Proteins, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10961-1
Spreadsheet: ec852d5b-0147-4aa2-8293-c23d2be8a122
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4934 | 29770 | [NAME] | Maciel | BRA | 0 | 00:42:06 | 00:02:01 | 02:12:36 | 00:01:58 | [NAME] | 1 | 04:39:11
4934 | 10101 | [NAME] | Wise | AUS | 0 | 00:51:37 | 00:01:46 | 02:20:52 | 00:01:47 | [NAME] | 2 | 04:53:21
4934 | 31814 | Pavel | Hotar | CZE | 0 | 00:50:08 | 00:01:43 | 02:30:33 | 00:01:58 | 01:49:32 | 3 | 05:13:57
4934 | 34190 | [NAME] | Noble | USA | 0 | 01:02:24 | [NAME] | [NAME] | 00:02:07 | 01:45:10 | 4 | [NAME]
4934 | 33761 | [NAME] | Hely | AUS | 0 | 01:02:05 | [NAME] | 03:02:44 | 00:04:20 | 02:23:30 | 5 | 06:35:45
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF OTHER CURRENT ASSETS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-99 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2000 |  | OTHER |  | 06-30-2000 |  | OTHER |  | 09-30-2000 |  | OTHER |  | 12-31-2000
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Hyperion Line 0189 - Fair Value Investment (current)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 94307d1294159478-index-match-finding-a-true-date-book3
Sheet: Sheet1

2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00
79 | 47 | 76 | 92 | 98 | 82 | 80 | 47
 | #N/A
 | 79
 | 79
 | 79
 | 79
Spreadsheet: 189121d1351091851-array-sumproduct-issue-trying-to-count-text-sampledata
Sheet: Sheet1

SaleCampaign | SaleType | SaleLocationCode
TR1 | Cat | 5000
TR1 | Parrot | 5000 |  |  | TR1 | TR1 | TR2 | TR2 | TR3 | TR3
TR1 | Cat, Dog | 6000 | [NAME] (incorrect results) |  | AreaA | AreaB | AreaA | AreaB | AreaA | AreaB
TR1 | Cat, Dog | 7000 |  | TotalSales
TR1 | Dog | 7000 |  | TotalUnits
TR1 | Dog | 7000 |  | Cat
TR1 | Dog | 7000 |  | Dog
TR1 | Cat, Dog | 8000 |  | Parrot
TR1 | Dog, [NAME] | 8000
TR1 | Cat, Dog | 9000
TR2 | Parrot | 5000 | Correct Results |  | TR1 | TR1 | TR2 | TR2 | TR3 | TR3
TR2 | Dog | 6000 |  |  | AreaA | AreaB | AreaA | AreaB | AreaA | AreaB
TR2 | Dog | 6000 |  | TotalSales
TR2 | Dog | 6000 |  | TotalUnits
TR2 | Cat | 9000 |  | Cats | 3 | 2 | 0 | 2 | 3 | 2
TR2 | Cat, Dog, [NAME] | 9000 |  | Dogs | 5 | 3 | 3 | 1 | 3 | 2 |  | Areas
TR3 | Cat | 5000 |  | Parrots | 1 | 1 | 1 | 1 | 3 | 3 |  | AreaA | AreaB
TR3 | Cat, Dog, [NAME] | 5000 |  |  |  |  |  |  |  |  |  | 5000 | 8000
TR3 | Parrot | 5000 |  |  |  |  |  |  |  |  |  | 6000 | 9000
TR3 | Cat, Dog, [NAME] | 7000 |  |  |  |  |  |  |  |  |  | 7000
TR3 | Dog | 7000
TR3 | Dog, [NAME] | 8000
TR3 | Cat | 9000
TR3 | Cat, Dog, [NAME] | 9000
TR3 | Parrot | 9000
Spreadsheet: 791806d1660601511-return-blank-date-if-there-is-no-data-in-the-input-cell-new-insurance-tracker
Sheet: 2022-2023 Benefits

EE = Employee Only | EC = Employee & Child(ren) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic EE = $10k Employer-provided policy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Macro should insert new row, copy formulas, re-sort list by EE Last name, and [NAME] fields.
ES = Employee & Spouse | EF = Employee & Family |  |  |  |  |  |  |  |  |  |  |  |  | PPO = Basic Plan     HMO = Buy-Up Plan |  |  |  |  | Basic Plus = Basic policy plus Employee-paid policy |  |  |  |  | Choice = Basic     Option A = Buy-Up     HAS = High Deductible
Employee Information |  |  |  |  |  | COBRA |  |  |  | Profit Sharing Plan |  |  |  | Kaiser Dental |  |  |  |  | MetLife Life Insurance |  |  |  |  | Providence Health Plan |  |  |  |  | HealthEquity Flexible Savings Plans
Name Last, First | Unit | Date of Eligibility | Eligibility Profile | Effective Date of Benefits | Date of Termination of Benefits | Enrolled | Effective | Default Termination | Actual Termination Date | Plan Name | Date Added | Eligible to Participate | Date Invited to Participate | Plan Elected | Enrollment Confirmed | EE Premium | ER Premium | Total Cost | Plan Elected | Enrollment Confirmed | EE Premium | ER Premium | Total Cost | Plan Elected | Enrollment Confirmed | EE Premium | ER Premium | Total Cost | Enrollment Confirmed | HSA EE Savings | HSA ER Savings | FSA EE Savings | DCRA EE Savings | Total Insurance Cost | BDI to [NAME]
Sample, Test | 100002 | 2022-03-04 00:00:00 | FT |  | 2022-09-07 00:00:00 |  |  |  |  | BDI |  |  |  | HMO EF |  |  |  |  | Basic EE |  |  |  |  | Choice ES |  |  |  |  |  |  | 0
[NAME], [NAME] | 100007 | 2022-07-29 00:00:00 | PT |  |  |  |  |  |  | BDI |  |  |  | PPO ES |  |  |  |  | Basic Plus |  | 1.28 |  |  | HSA EE |  |  |  |  |  | 200
Doe, [NAME] | 100001 | 2022-09-25 00:00:00 | FT |  |  |  |  |  |  | SPI |  |  |  | HMO EF | 2022-07-26 00:00:00 |  |  |  | Basic Plus | 2022-07-26 00:00:00 | 14.56 |  |  | HSA EF | 2022-07-26 00:00:00 |  |  |  | 2022-07-26 00:00:00 | 500 |  |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HMO EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  |  |  |  | Totals |  |  |  |  | Totals |  |  |  |  | Totals
Spreadsheet: 767266d1644386658-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation6
Sheet: Weekdays

Weekdays
Click Consulting
Purpose | To update the allocation table to exclude weekend days.
Function | NETWORKDAYS - returns the number of workdays, excluding weekends, between two dates (inclusive)
Allocation
 | Amount | Alloc Start | Alloc End |  | WeekDays | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2022-11-01 00:00:00 | 2022-12-31 00:00:00
 | 1000 | 2025-11-01 00:00:00 | 2025-12-31 00:00:00
 | 1000 | 2026-12-01 00:00:00 | 2026-12-31 00:00:00
 | 1000 | 2027-12-01 00:00:00 | 2027-12-31 00:00:00
 | 1000 | 2028-12-01 00:00:00 | 2028-12-31 00:00:00
 | 1000 | 2029-12-01 00:00:00 | 2029-12-31 00:00:00
 | 1000 | 2030-12-01 00:00:00 | 2030-12-31 00:00:00
 | 1000 | 2007-12-01 00:00:00 | 2007-12-31 00:00:00
 | 1000 | 2008-12-01 00:00:00 | 2008-12-31 00:00:00
 | 1000 | 2013-12-01 00:00:00 | 2013-12-31 00:00:00
 | 1000 | 2012-12-01 00:00:00 | 2012-12-31 00:00:00
 | 1000 | 2011-12-01 00:00:00 | 2011-12-31 00:00:00
 | 1000 | 2010-12-01 00:00:00 | 2010-12-31 00:00:00
 | 1000 | 2023-12-01 00:00:00 | 2023-12-31 00:00:00
Spreadsheet: 880178d1727796378-count-if-sum-if-2024-06-03-tmpl-hourly-pp-calculations-tms-1-2-
Sheet: Info

Yes/No | Overtime Rate | Shift Premium | Weekend Premium | Underground Premium | Roster | Scheduled Hours | Daily OT | PP | Day Type | Paid Meal Break |  |  |  | Acting Premium
Yes | 1 | 2.79 | 2.01 | 0.4 | 8/80 40hrs A |  |  | 01-2024 | Days | 1 |  |  |  | 0.07
No | 1.5 |  |  |  | 8/80 40hrs B |  |  | 02-2024 | Nights | 2
 | 2 |  |  |  | 7x7 D Tu R1 0600 | 12 | 0 | 03-2024 | Vacation
 |  |  |  |  | 7x7 D Tu R1 0630 | 12 |  | 04-2024 | Sick
 |  |  |  |  | 7x7 D Tu R1 0700 | 12 |  | 05-2024 | Stat Worked Days
 |  |  |  |  | 7x7 D Tu R2 0600 | 12 |  | 06-2024 | Stat Worked Nights
 |  |  |  |  | 7x7 D Tu R2 0630 | 12 |  | 07-2024 | Off
 |  |  |  |  | 7x7 D Tu R2 0700 | 12 |  | 08-2024 | Extra Shift
 |  |  |  |  | 7x7 DN Tu R1 0600 | 12 |  | 09-2024 | Acting Shift Days
 |  |  |  |  | 7x7 DN Tu R1 0630 | 12 |  | 10-2024 | Acting Shift Nights
 |  |  |  |  | 7x7 [NAME] | 12 |  | 11-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 12-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 13-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 14-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 15-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 16-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 17-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 18-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 19-2024
 |  |  |  |  | 7x7 [NAME] | 12 |  | 20-2024
 |  |  |  |  | 7x7 D We R1 0600 | 12 |  | 21-2024
 |  |  |  |  | 7x7 D We R1 0630 | 12 |  | 22-2024
 |  |  |  |  | 7x7 D We R1 0700 | 12 |  | 23-2024
 |  |  |  |  | 7x7 D We R2 0600 | 12 |  | 24-2024
 |  |  |  |  | 7x7 D We R2 0630 | 12
 |  |  |  |  | 7x7 D We R2 0700 | 12
 |  |  |  |  | 7x7 DN We R1 0600 | 12
 |  |  |  |  | 7x7 DN We R1 0630 | 12
 |  |  |  |  | 7x7 DN We R1 0730 | 12
 |  |  |  |  | 7x7 DN We R2 0600 | 12
 |  |  |  |  | 7x7 DN We R2 0730 | 12
 |  |  |  |  | 7x7 DN We R2 0730 | 12
 |  |  |  |  | 7x7 DN We R3 0600 | 12
 |  |  |  |  | 7x7 DN We R3 0630 | 12
 |  |  |  |  | 7x7 DN We R3 0700 | 12
 |  |  |  |  | 7x7 DN We R4 0600 | 12
 |  |  |  |  | 7x7 DN We R4 0630 | 12
 |  |  |  |  | 7x7 DN We R4 0700 | 12
 |  |  |  |  | LifeStyle 1A 0600 | 12
 |  |  |  |  | LifeStyle 1A 0630 | 12
 |  |  |  |  | LifeStyle 1A 0700 | 12
 |  |  |  |  | LifeStyle 2A 0600 | 12
 |  |  |  |  | LifeStyle 2A 0730 | 12
 |  |  |  |  | LifeStyle 3A 0600 | 12
 |  |  |  |  | LifeStyle 3A 0730 | 12
 |  |  |  |  | LifeStyle 4A 0600 | 12
 |  |  |  |  | LifeStyle 4A 0730 | 12
Spreadsheet: a5e2130f-f587-4f90-afee-c14067b95ac5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38808884 | 2013-12-03 00:15:21 | ALLIES | 0 | 5 | 6 | 21590 | Greenheart22 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: 132765d1323912088-what-function-do-i-use-for-these-questions-draft1
Sheet: Sheet1

Number of copies | Price per Copy
1 | 0.07
10 | 0.06
100 | 0.05
200 | 0.04
500 | 0.03
1000 | 0.02
Copies Made | Total Cost | Delivery Cost
3
10
200
1001