tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 119894d1314828870-excel-2008-exporting-quickbooks-p-and-ls-to-excel-p-and-l-excel-forum
Sheet: Sheet1

 |  |  |  |  | Feb 11 |  | Jan 11
 | Ordinary Income/Expense
 |  | Income
 |  |  | Patient Fees |  | 169905.91 |  | 149979.4
 |  |  | Medicare/Medicaid/Workers Comp |  | 216815.61 |  | 208002.14
 |  |  | Tricare |  | 1564.89 |  | 992.21
 |  |  | Forest [NAME] |  | 58975.82 |  | 58532.03
 |  |  | Refunds |  | -1774.09 |  | -763.36
 |  |  | NSF Checks |  | -59.79 |  | -34.79
 |  | Total Income |  |  | 445428.35 |  | 416707.63
 |  | Expense
 |  |  | Admin Reimbursement |  | -26.19 |  | -91.79
 |  |  | Bank Service Charges |  | 154.94 |  | 285.82
 |  |  | Billing Fees |  | 18101.99 |  | 16793.91
 |  |  | Business Meals & Entertainment |  | 96.28 |  | 0
 |  |  | Collection Fees |  | 603.65 |  | 517.32
 |  |  | Delivery & Freight |  | 167 |  | 105
 |  |  | Dues and Subscriptions |  | 398.67 |  | 0
 |  |  | Fees Expense |  | 550 |  | 350
 |  |  | Insurance - Health |  | 12246.81 |  | 12246.81
 |  |  | Insurance - Malpractice |  | 10227.9 |  | 10252.51
 |  |  | Insurance - Overhead |  | 47.65 |  | 47.65
 |  |  | Manager's Salary |  | 10500 |  | 10500
 |  |  | Office Supplies |  | 377.69 |  | 129.37
 |  |  | Online Services |  | 12.95 |  | 12.95
 |  |  | Outside Services |  | 724 |  | 438
 |  |  | Payroll Expenses
 |  |  |  | Admin Salary Expense | 6438.81 |  | 7450.44
 |  |  |  | Health Ins Stipend - Staff | 137.1 |  | 57.3
 |  |  |  | Health Insurance - Staff | 369.26 |  | 369.26
 |  |  |  | Less Reimbursement | -1669.39 |  | -1755.82
 |  |  |  | Mileage Reimbursement | 29.76 |  | 53.07
 |  |  |  | Payroll Tax Expense | 599.06 |  | 692.97
 |  |  |  | [NAME] | 1315.18 |  | 1501.55
 |  |  |  | Payroll Expenses - Other | 24.27 |  | 5.87
 |  |  | Total Payroll Expenses |  | 7244.05 |  | 8374.64
 |  |  | Postage and Delivery |  | 362.16 |  | 345.9
 |  |  | Professional Fees |  | 3950.18 |  | 10740.34
 |  |  | Recruiting Expense |  | 50 |  | 50
 |  |  | Rent |  | 1000 |  | 1000
 |  |  | [NAME] |  | 2535 |  | 2590
 |  |  | Telephone & Pagers |  | 903.81 |  | 806.61
 |  |  | Travel |  | 627.11 |  | 0
 |  |  | Voice Mail System |  | 911.81 |  | 1023.25
 |  |  | Void Checks |  | 0 |  | 0
 |  |  | Allocable Expenses |  | 0 |  | 0
 |  | Total Expense |  |  | 71767.46 |  | 76518.29
 | Net Ordinary Income |  |  |  | 373660.89 |  | 340189.34
 | Other Income/Expense
 |  | Other Expense
 |  |  | Contract Labor-Doctors' |  | 172058.09 |  | 173141.14
 |  |  | Guaranteed Payments-Members
 |  |  |  | Base Pay | 151958.83 |  | 134902.86
 |  |  |  | 10% Allocation | 11008.74 |  | 10752.56
 |  |  |  | Partner Allocation | 38635.23 |  | 21392.78
 |  |  |  | Guaranteed Payments-Members - Other | 0 |  | 0
 |  |  | Total Guaranteed Payments-Members |  | 201602.8 |  | 167048.2
 |  | Total Other Expense |  |  | 373660.89 |  | 340189.34
 | Net Other Income |  |  |  | -373660.89 |  | -340189.34
Net Income |  |  |  |  | 0 |  | 0
Spreadsheet: 848558d1699282858-split-range-sample
Sheet: Sheet1

Boxes | Range |  | Boxes | [NAME] |  | Boxes | Custom
1 | 1-3 |  | 1 | 1 |  | 1 | 1
2 | 9-12 |  | 1 | 2 |  | 1 | 2
3 | 5-8 |  | 1 | 3 |  | 1 | 3
 |  |  | 2 | 9 |  | 2 | 9
 |  |  | 2 | 10 |  | 2 | 10
 |  |  | 2 | 11 |  | 2 | 11
 |  |  | 2 | 12 |  | 2 | 12
 |  |  | 3 | 5 |  | 3 | 5
 |  |  | 3 | 6 |  | 3 | 6
 |  |  | 3 | 7 |  | 3 | 7
 |  |  | 3 | 8 |  | 3 | 8
Spreadsheet: geir_solberg__11289__1-03act
Sheet: EPEData

 | 37356.02222222222
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 37  , 77  , 34  , 83  , 39  ,1
 | NEWMAN 3 ,ECON, 43  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL,182  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 260 ,  392,  155, 400 ,  79 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,120  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 91  , 91  , 91  ,104  ,  0  ,1
 | LAMBDA, 23.51,  687,  690,  110,   -1,    0,11861,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: Pivot Table of New

Row Labels | Count of CALLID
Database Issues | 5
Equipment Loan | 6
GroupWise | 46
HeatService | 2
HW Install | 2
HW Issues | 18
InfoDesk | 26
Internet/Intran | 1
Internet_Other | 2
LanAdmin Access | 46
[NAME] | 93
M1 Support | 2
Network Issues | 16
Network Task | 15
PC Setup | 16
Primavera | 1
Printing | 37
Project | 1
SanitizationExcess | 12
Security Issues | 2
Security Notice | 8
Security RSA Tokens | 8
Server | 3
SW Install | 4
SW Issues | 65
SW Licenses | 6
Technology Enhancement | 1
Telephone | 26
Telephone Down | 8
Wireless Device | 6
Grand Total | 484
Spreadsheet: 147547d1332853748-if-and-vlookup-help-example-2
Sheet: Sheet1

[NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | Sup Bookings
Avon | Lithuanian | 1 |  | Avon | Lithuanian | 3
Avon | Polish | 1 |  | Avon | Polish | 13
Avon | Russian | 7 |  | Avon | Russian | 7
Bedfordshire | Albanian | 14 |  | Bedfordshire | Albanian | 8
Bedfordshire | Arabic | 63 |  | Bedfordshire | Arabic | 10
Bedfordshire | Bengali | 24 |  | Bedfordshire | Bengali | 8
Bedfordshire | Cantonese | 3 |  | Bedfordshire | Cantonese | 2
Berkshire | Croatian | 13 |  | Berkshire | Croatian | 2
Berkshire | Czech | 7 |  | Berkshire | Czech | 20
Berkshire | French | 8 |  | Berkshire | French | 2
Buckinghamshire | Gujarati | 10 |  | Buckinghamshire | Gujarati | 9
Buckinghamshire | Hindi | 8 |  | Buckinghamshire | Cantonese | 24
Buckinghamshire | Hungarian | 2 |  | Buckinghamshire | Croatian | 1
Cambridgeshire | Indonesian | 2 |  | Cambridgeshire | Czech | 199
Cambridgeshire | Italian | 20 |  | Cambridgeshire | French | 42
Cambridgeshire | Kurdish (Sorani) | 2 |  | Cambridgeshire | Gujarati | 32
Cambridgeshire | Kurdish(Bahdini) | 9 |  | Cambridgeshire | Hindi | 13
Cambridgeshire | Lithuanian | 24 |  | Cambridgeshire | Hungarian | 8
Cheshire | Mandarin | 1 |  | Cheshire | Indonesian | 2
Cheshire | Pashto | 199 |  | Cheshire | Italian | 6
Cheshire | Portuguese | 42 |  | Cheshire | Portuguese | 152
Cheshire | Punjabi | 32 |  | Cheshire | Punjabi | 1
Spreadsheet: 79048d1279278827-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-system-forumex
Sheet: Activity Code

Activity Code
 | Summary by Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
 | 301
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 301 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Q1303 | 301 | 2345 | [NAME] | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 4 | 10 | TUFC | B
Q1303 | 301 | 1234 | [NAME]
Q1303 | 301 | 123 | This One Test
[NAME] | 301 | 7777 | TEST2
[NAME] | 301 | 8888 | TEST3
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  | I would rather have cost centres
 | 302 |  |  |  |  |  |  |  |  |  | descending rather than across
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Spreadsheet: 839436d1691983182-correction-in-vlookup-function-in-relative-reference-test1-3-1-
Sheet: Sheet1

STRING | LEN | Desired result | [NAME] results | LEN | Function | Parameter 1 | Parameter 2
SYD DL LAX DL ATL DL LAX DL SYD | 31 |  |  | 17 | RIGHT | 3
SYD DL LAX DL SYD |  |  |  | 31 | MID | 15 | 3
SYD DL LAX DL DTW DL LAX DL SYD |  |  |  | 36 | MID | 15 | 3
SYD DL LAX DL SAN//PHX DL LAX DL SYD |  |  |  | 45 | MID | 22 | 3
SYD DL LAX DL ATL DL GIG DL JFK DL LAX DL SYD
SYD DL LAX DL ATL DL CHS DL MSP DL LAX DL SYD
SYD DL LAX DL ATL DL FLL DL ATL DL LAX DL SYD
SYD DL LAX DL TUS DL LAX DL SYD
 |  |  | Function to use corresponding B column instead D
Spreadsheet: 839258d1691768404-how-to-populate-the-closest-date-match-to-the-reference-date-example
Sheet: Sheet2

ID | Enrolment date | 1st Assessment | 2nd Assessment
ID-1234 | 2023-04-17 00:00:00
ID-1235 | 2023-05-03 00:00:00 | 2023-01-09 00:00:00
ID-1236 | 2023-06-29 00:00:00 | 2023-04-17 00:00:00
ID-1237 | 2023-05-03 00:00:00 | 2023-03-22 00:00:00 | 2023-07-26 00:00:00
ID-1238 | 2023-05-03 00:00:00 | 2023-03-27 00:00:00 | 2023-05-18 00:00:00
ID-1239 | 2023-04-11 00:00:00 | 2023-02-03 00:00:00 | 2023-05-17 00:00:00
ID-1240 | 2023-04-06 00:00:00 | 2023-02-23 00:00:00 | 2023-05-30 00:00:00
ID-1241 | 2023-05-10 00:00:00 | 2023-04-28 00:00:00 | 2023-07-14 00:00:00
ID-1242 | 2023-06-12 00:00:00 | 2017-12-21 00:00:00
ID-1243 | 2023-06-09 00:00:00 | 2017-12-21 00:00:00
ID-1244 | 2023-05-10 00:00:00 | 2023-04-27 00:00:00 | 2023-07-05 00:00:00
ID-1245 | 2023-06-22 00:00:00 | 2017-12-21 00:00:00
Spreadsheet: 887037d1737125308-computation-of-leave-days-leave-calculator-jt-
Sheet: Sheet2

Length of Service | Annual Leave Days | Monthly Leave
1 - 9 years | 18
10 years and above | 21
 |  |  |  | Monthly Leave Accrual
Employee Name | Date Joined | Years of Service | Annual Leave Days | 2025-01-01 00:00:00
Empl 1 | 2018-08-10 00:00:00
Empl 2 | 1999-09-15 00:00:00
Empl 3 | 2025-01-01 00:00:00
Empl 1 | 2018-08-10 00:00:00 | 6 | 18 | 1.5 | 3 | 4.5 | 6 | 7.5 | 9 | 10.5 | 12 | 13.5 | 15 | 16.5 | 18
Empl 2 | 1999-09-15 00:00:00 | 25 | 21 | 1.75 | 3.5 | 5.25 | 7 | 8.75 | 10.5 | 12.25 | 14 | 15.75 | 17.5 | 19.25 | 21
Empl 3 | 2025-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1.5 | 3 | 4.5 | 6 | 7.5 | 9 | 10.5 | 12 | 13.5
Spreadsheet: 472542d1469632810-sum-based-on-working-days-asset-creations-2016
Sheet: Data

 |  | Note:
 |  | 2nd May Bank Holiday
 |  | 30th May Bank Holiday |  |  |  |  |  |  |  |  |  |  |  | WD
 |  | Company Code | Asset | Asset Class | Created by | Created on | Acquisition yr | First acq.per. | First acq. on | Capitalized on |  | Work Day |  | on or Before WD-5 | WD -4 to -3 | WD -1 to -2
 |  |  | 10116622 | 11000 |  | 2016-01-07 00:00:00
 |  |  | 10116623 | 11000 |  | 2016-01-27 00:00:00
 |  |  | 10116624 | 11000 |  | 2016-01-29 00:00:00
 |  |  | 10116625 | 11000 |  | 2016-05-11 00:00:00
 |  |  | 10116626 | 11000 |  | 2016-05-26 00:00:00
 |  |  | 10116627 | 11000 |  | 2016-05-31 00:00:00
Spreadsheet: 00f9e447-4742-4b8a-b7a9-f56ba1de0803
Sheet: Exhibit XVI

All Forms
USAA Group
Pennsylvania
Three Year Premium and Expense Experience
 | USAA Group Pennsylvania |  |  |  | USAA Group Countrywide
 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 |  | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00
Written Premiums | 63208093.45999999 | 71080902.72 | 83454253.16 |  | 2953330273.54 | 3217777377.96 | 3589462248.66
[NAME] | 60180171.72000001 | 66605282.87 | 76406360.08 |  | 2852260009.08 | 3077152628.4 | 3382837250.99
Commission & Brokerage | 0 | 0 | 0 |  | 0 | 0 | 0
General Expenses | 715315.2099999996 | 1355864.43 | 1590527.83 |  | 32934071.75 | 58951011.26 | 65283058.77
Other Acquisition Expenses, Field Supervision, and Collection Expenses | 7219282.189999998 | 7775108.27 | 10036604.36 |  | 332073498.57 | 345137446.5 | 419368614.11
Taxes, Licenses & Fees | 1285596.74 | 1366846.19 | 1879087.87 |  | 66592402.04 | 61216767.2 | 82181712.87
Incurred Loss | 48938314.59 | 65742831.06 | 61496528.28 |  | 1673694459.99 | 2518855663.33 | 2201784303.59
Paid Loss | 47760572.59 | 57693071.06 | 53580681.28 |  | 1664488923.99 | 2284384435.33 | 2215780106.59
Paid Unallocated LAE | 7110010.41 | 5102465.19 | 3954912.76 |  | 172352551.91 | 193085033.29 | 182957338.05
Paid Allocated LAE | 589807.1699999997 | 442134.28 | 491155.03 |  | 19857709.48000002 | 20690133.97 | 24271301.85
All data is on a Direct basis
Spreadsheet: 80c0adce-ed75-4392-8482-bdb3553ca312
Sheet: Sheet1

FY 2012 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | ORIGINAL | SEPT-MAY | [NAME] | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | PAYMENT | [NAME] | REMAINING
1 | [NAME] 1 | 12173702 | 1217373 | 1217345 | 12173702 | 0
5 | PRAIRIE LAKES AEA 8 | 11932421 | 1193242 | 1193243 | 11932421 | 0
7 | AEA 267 | 25953086 | 2595314 | 2595260 | 25953086 | 0
9 | MISSISSIPPI BEND AEA 9 | 17943809 | 1794383 | 1794362 | 17943809 | 0
10 | GRANT WOOD AEA 10 | 25140991 | 2514103 | 2514064 | 25140991 | 0
11 | HEARTLAND AEA 11 | 45695987 | 4569599 | 4569596 | 45695987 | 0
12 | NORTHWEST AEA | 14971662 | 1497170 | 1497132 | 14971662 | 0
13 | GREEN HILLS AEA 13 | 14813279 | 1481329 | 1481318 | 14813279 | 0
15 | GREAT PRAIRIE AEA 15 | 13537748 | 1353777 | 1353755 | 13537748 | 0
 |  | 182162685 | 18216290 | 18216075 | 182162685 | 0
Spreadsheet: 817570d1676324547-i-need-this-calendar-template-to-also-highlight-date-ranges-copy-annual-pipeline
Sheet: Help

Help
https://www.vertex42.com/calendars/yearly-schedule-of-events.html
Instructions
1) | Enter the year in the header
2) | Choose a start day (1 = Sunday, 2 = Monday) in the header
3) | Edit the Title and Sub-Title at the top of the [NAME]
4) | Add events for each month. Enter dates in a standard date format in column J.
5) | For each event, choose an event type from the drop-down box if you want the event to be highlighted, or leave column L blank to avoid highlighting.
Highlighting by Event Type
 | You can highlight dates by choosing an Event Type in column L. The colors are controlled using conditional formatting.
 | To change labels for the event types, edit the cells listed under "Event Type Labels." Do not leave any of these cells blank.
Printing
 | If you add or remove rows, or modify the column widths, you may need to adjust the print area and page breaks.
 | To change the page breaks, go to View > Page Break Preview.
 | To change the Print Area, select the cells you want to print and go to Page Layout > Print Area > Set Print Area.
Holidays
 | For convenience, some holidays have been included in the template. You do not need to use these, and if you want to add other holidays, you can enter the dates manually after looking them up on the internet.
Sharing Your Schedule of Events
 | Although Vertex42.com does not permit publishing this spreadsheet on the web, you may create a PDF and publish the PDF. The attribution in the footer must not be removed.
Additional Help
 | The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
© 2013-2019 Vertex42 LLC. All rights reserved.
Spreadsheet: 05312963-fa13-4af6-a245-0bc265802651
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
FCHIC | Test | FCHIC | CHIC2, 4q12 Deletion (FIP1L1 and PDGFRA Fusion), FISH | CHIC2, 4q12 Deletion, FISH | Fluorescence In Situ Hybridization (FISH) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  | Varies | Provide a reason for referral with each specimen. The laboratory will not reject testing if this information is not provided, but appropriate testing and interpretation may be compromised or delayed.  Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen.  Advise Express Mail or equivalent if not on courier service.   Submit only 1 of the following specimens:   Specimen Type: Blood Container/Tube: Green top (sodium heparin) [NAME]: 7-10 mL Collection Instructions: 1. Invert several times to mix blood. 2. Other anticoagulants are not recommended and are harmful to the viability of the cells.   Specimen Type: Bone marrow Container/Tube: Green top (sodium heparin) [NAME]: 1-2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Other anticoagulants are not recommended and are harmful to the viability of the cells. | Blood: 2 mL/Bone Marrow: 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Clotted blood or bone marrow | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 6 days | 7 days |  | Profile |  |  |  |  | Rochester
FCHIC | [NAME] | VARIES | Varies |  |  |  | Ambient
FCHIC | Order Question | G_681 | Source |  | Answer List
FCHIC | Option | G_681-1 | Whole blood Na Hep
FCHIC | Option | G_681-2 | Bone marrow Na Hep
FCHIC | Order Question | G_683 | Reason For Referral |  | Plain Text
FCHIC | Result | 84308 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
FCHIC | Result | 22461 | [NAME] | [NAME] | Alphanumeric
FCHIC | Result | G_681 | Source | Source | Alphanumeric
FCHIC | Result | 22463 | Order Date | Order Date | Alphanumeric
FCHIC | Result | G_683 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
FCHIC | Result | 22465 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHIC | Result | 22466 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41749-3
FCHIC | Result | 22467 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
FCHIC | Result | 22468 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHIC | Result | 22469 | Consultant | Consultant | Alphanumeric
FCHIC | Result | 22470 | Report Date | Report Date | Alphanumeric
Spreadsheet: 818377d1676785420-excel-formula-to-identify-a-missing-invoice-missing-invoice-ans
Sheet: Sheet1

I'm kindly asking for excel formula to identify a missing invoice in column C and show it in column G
Desired solution
Date | Entry Type | Invoice | Customer Name | Credit | Cumulative | Missing Invoice | Missing Invoice
1000/001 : Sales-Byo
Opening Balance as at 01/01/2021 |  |  |  |  | -1150726.61
31/03/2021 | General Journal | SBB003 | Donor culsign | 93851.53 | -1244578.14
31/03/2021 | General Journal | SBB004 | Tongwe high school | 105764.19 | -1350342.33
13/04/2021 | General Journal | SBB006 | [NAME] | 21781.66 | -1380298.66 |  | SBB007
14/04/2021 | General Journal | SBB007 | Donor culsign | 29165.94 | -1402080.32
16/04/2021 | General Journal | SBB008 | Donor culsign | 38113.83 | -1431246.26
20/04/2021 | General Journal | SBB009 | Donor culsign | 8436.68 | -1469360.09
29/04/2021 | General Journal | SBB011 | Donor culsign | 20567.69 | -1477796.77 |  | SBB010
29/04/2021 | General Journal | SBB014 | Malikuwa sec school | 10065.5 | -1498364.46
 |  | C15 value changed for testing
Spreadsheet: 693164d1598814568-conditional-formatting-duplicates-but-with-conditions-reopened-xlf20200830-cf_duplicates_with_conditions-for_tsacov-as
Sheet: Escalations__AS

[NAME] | Restaurant | ID | Original Action | Actual Action | Intake Agent | Notes |  |  | Total |  |  |  |  |  |  |  |  | Helper
 | C12 |  |  | Verbal Negative |  |  |  | 911
 | C12 |  |  | Escalation |  |  |  | Escalation
 | C12 |  |  | 911 |  |  |  | Non-Escalation
 | C12 |  |  | Non-Escalation |  |  |  | Verbal Negative
 |  |  |  |  |  |  |  | More Info
 |  |  |  |  |  |  |  | High [NAME] |  |  |  |  |  | Restaurant Key:
 |  |  |  |  |  |  |  | 1) Immediate positive test results (when we have them or have confirmed). |  |  |  |  |  | If Cell is RED then it is a High Alert Restaurant
 |  |  |  |  |  |  |  | 2) Outbreak potential situations (multiple CMs impacted).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | If Cell is ORANGE then it is a California Restaurant (Overrided by HARs)
 |  |  |  |  |  |  |  | 3) COVID-related Hospitalizations of any kind.
 |  |  |  |  |  |  |  | 4) Multiple CMs that are testing. |  |  |  |  |  | If cell is YELLOW then the Restaurant has multiple cases (Overrided by HARs/CA)
 |  |  |  |  |  |  |  | High Alert / CA Locations |  | Total Occurances
 |  |  |  |  |  |  |  | Location # | Case count
 |  |  |  |  |  |  |  | C051
 |  |  |  |  |  |  |  | C200
 |  |  |  |  |  |  |  | C287
 |  |  |  |  |  |  |  | C324
 |  |  |  |  |  |  |  | C338
 |  |  |  |  |  |  |  | C446
 |  |  |  |  |  |  |  | C189
 |  |  |  |  |  |  |  | C190
 |  |  |  |  |  |  |  | C200
 |  |  |  |  |  |  |  | C206
 |  |  |  |  |  |  |  | C211
 |  |  |  |  |  |  |  | C272
 |  |  |  |  |  |  |  | C281
 |  |  |  |  |  |  |  | C282
 |  |  |  |  |  |  |  | C292
 |  |  |  |  |  |  |  | C300
 |  |  |  |  |  |  |  | C320
 |  |  |  |  |  |  |  | C321
 |  |  |  |  |  |  |  | C331
 |  |  |  |  |  |  |  | C327
 |  |  |  |  |  |  |  | C329
 |  |  |  |  |  |  |  | C330
 |  |  |  |  |  |  |  | C332
 |  |  |  |  |  |  |  | C337
 |  |  |  |  |  |  |  | C338
 |  |  |  |  |  |  |  | C349
 |  |  |  |  |  |  |  | C357
 |  |  |  |  |  |  |  | C358
 |  |  |  |  |  |  |  | C365
 |  |  |  |  |  |  |  | C366
 |  |  |  |  |  |  |  | C373
 |  |  |  |  |  |  |  | C380
 |  |  |  |  |  |  |  | C384
 |  |  |  |  |  |  |  | C389
 |  |  |  |  |  |  |  | C390
Spreadsheet: 676168d1588690404-calculating-time-value-returns-hash-bd
Sheet: Sheet2

 |  | HOUR | MIN | SEC | TIME | Plant Status | Plant Status | Breakdown
 |  | 1 | 30 | 30 |  | 0
 |  | 2 | 30 | 30 |  | 1
 |  | 12 | 30 | 30 |  | 0
 |  | 2 | 30 | 30 |  | 1
Spreadsheet: 760615d1640339050-compare-columns-in-one-spreedsheet-in-other-spreedsheet-estat2122-tp1-copy-2-
Sheet: Amostras NR

NR |  | Amostras independentes
ZONA
A | B
7 | 8
5 | 8
8
10 | 5
6 | 4
8 | 6
5 | 10
6 | 6
1 | 4
7 | 6
7 | 3
5 | 6
4 | 12
4 | 5
4 | 5
6 | 2
3 | 7
2 | 7
7 | 4
4 | 4
3 | 5
3 | 4
2 | 6
6 | 4
3 | 3
2 | 3
7
1 | 4
5 | 9
7 | 7
4 | 7
6 | 6
5 | 8
5 | 9
7 | 5
2 | 5
4 | 6
4 | 4
4
3 | 6
4 | 4
3 | 7
9 | 3
8 | 9
3 | 5
7 | 7
5 | 5
6 | 7
5 | 4
6 | 5
8 | 4
4 | 11
3 | 0
2 | 5
5 | 10
4 | 3
5 | 8
6 | 8
3 | 5
6 | 11
2 | 4
0 | 8
1 | 5
5 | 11
1 | 5
5
4 | 4
6 | 2
6 | 8
3 | 8
2 | 7
5 | 4
7 | 4
8 | 9
3 | 3
2 | 5
5 | 8
8 | 5
6 | 10
5 | 5
9 | 5
5 | 6
2 | 9
2 | 8
3 | 7
6 | 6
3 | 13
7 | 6
8 | 3
6 | 1
4 | 6
5 | 6
4 | 8
4 | 6
6 | 4
4 | 6
5 | 5
2 | 8
2 | 5
6 | 4
6 | 3
5 | 5
11 | 7
5 | 10
4 | 6
9 | 7
2 | 3
6 | 5
5 | 9
7 | 9
6 | 7
4 | 5
0 | 7
5 | 4
5 | 5
7 | 8
1 | 9
1 | 6
5 | 7
9
Spreadsheet: 811806d1672806379-auto-date-and-day-with-highlighting-sundays-and-perhaps-holidays-auto-date
Sheet: Monatsabrechnung

[NAME]
!! [NAME] WERDEN !! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
Tag |  |  | 2023-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summe | Sonntage Feiertage
[NAME] |  |  | 40
[NAME]
Bilanz
Spreadsheet: 156401d1337280036-use-of-sumif-function-figoexample1
Sheet: Sheet1

 | Car Model | Color | Price | Mileage |  |  | Black | White
 | Figo | Black | 2000 | 12 |  | Figo | 8078 | 16298
 | Swift | White | 1300 | 13 |  | Swift | 6473 | 1300
 | WagonR | Black | 3400 | 21
 | Polo | Black | 5466 | 15
 | Swift | Black | 6473 | 16
 | Figo | Black | 3542 | 23
 | Figo | White | 6453 | 31
 | WagonR | White | 8700 | 10
 | Polo | White | 1542 | 16
 | Figo | Black | 2536 | 15
 | Figo | White | 9845 | 16
Spreadsheet: 231460d1367079944-using-excel-for-home-based-symptoms-diary-wheeze-diary
Sheet: Sheet1

Date | [NAME], nose block,[NAME] leak | Activity induced cough | Night cough | Wheeze: day | Wheeze Night | Total
2013-04-27 00:00:00 | Present | Present | Present | Present | Present | 5
 | SUMMARY | OF THE | DAYS ON WHICH | CHILD HAD | SYMPTOMS
Month | date 1 to 7 | Date 8 to 14 | Date 15 to 21 | Date 22 to 31
Jan | 3 | nil | 17,18, 19
Feb
March |  | 11,12
April