tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 2

 | Nov 23 |  | Nov 30 |  | Dec 7 |  | Dec 14
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 381458122 | 381458122 | 386135995 | 386135995 | 386815002 | 386815002 | 373815958 | 373815958
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 18336792 | 18336792 | 16707328 | 16707328 | 16715730 | 16715730 | 14833311 | 14833311
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 22238040 | 22238040 | 22031189 | 22031189 | 22051544 | 22051544 | 22186373 | 22186373
Dealers** | 18910675 | 18891984 | 18749996 | 18718637 | 18742936 | 18712521 | 18853736 | 18819257
Buyside | 3327365 | 3346055 | 3281193 | 3312552 | 3308609 | 3339024 | 3332637 | 3367115
Total Equity | 6121616 | 6121616 | 6121616 | 6121616 | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 867282d1714127056-looking-for-shortcut-to-put-all-tab-names-on-one-tab-plus-data-template-empty
Sheet: Company Name 2

 |  |  |  |  |  | Company Name 2
 |  | Month ending
 |  | Enter month
 | Date | Invoice number | Total | Materials | Labour | Tax | [NAME] | Payable
 |  | Totals
[NAME]
Company No. 06977736
Spreadsheet: 770753d1646241289-match-employee-id-on-two-different-tabs-and-add-the-corresponding-name-to-column-example
Sheet: Sheet2

USER ID | Name
ID 1 | name 1
ID 2 | name 2
ID 3 | name 3
ID 4 | name 4
ID 5 | name 5
ID 6 | name 6
ID 7 | name 7
ID 8 | name 8
ID 9 | name 9
ID 10 | name 10
ID 11 | name 11
ID 12 | name 12
ID 13 | name 13
ID 14 | name 14
ID 15 | name 15
ID 16 | name 16
ID 17 | name 17
ID 18 | name 18
Spreadsheet: f073ba13-8cd5-454e-91f4-a90dd827cb1a
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
HHTM | Test | HHTM | Hereditary Hemorrhagic Telangiectasia, ENG and ACVRL1 Large Deletion/Duplication, Molecular Analysis | ENG and ACVRL1, [NAME] | Dosage Analysis by [NAME] (MLPA) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple cardiovascular-related gene sequencing tests can be performed on a single specimen after a single extraction. See Multiple Cardiovascular-Related Gene Sequencing Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: 1. Include physician name and phone number with the specimen. 2. Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing.  Forms:  1. Hereditary Hemorrhagic Telangiectasia (HHT) Gene Testing Patient Information Sheet (Supply T650) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Varies | 5 days | 10 days | 1 | 81479 |  |  |  |  | Rochester
HHTM | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
HHTM | Result | 31068 | ENG-ACVRL1, [NAME] | ENG-ACVRL1, [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69481-0
HHTM | Result | 45500 | ENG-ACVRL1, [NAME] | ENG-ACVRL1, [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
HHTM | Result | 45516 | ENG-ACVRL1, [NAME] by | ENG-ACVRL1, [NAME] by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 137208d1327000471-complicated-if-index-formula-example2012_summer_internship
Sheet: IT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internship IT Email/Login Request Form
Office | Department | Last | First | Year | College | Major | App. Rec. | Phone Int. | Live Int./Sent | TBNT | Status | [NAME] | Phone | Comments | M | T | W | Th | F | Start Date | End Date | User Name | Imm. Supervisor | Email address | Drives | Status | Date | Error
Los Angeles | Global Partnerships | Duck | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dduck | x | [EMAIL] |  |  |  |  |  | Los AngelesGlobal Partnerships
Los Angeles | GV Marketing | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mmouse | x | [EMAIL] |  |  |  |  |  | Los AngelesGV Marketing
TMG Nashville | Marketing | Dog | Goofy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gdog | x | [EMAIL] |  |  |  |  |  | TMG NashvilleMarketing
Spreadsheet: 61946e2b-0f8d-4a15-b9e9-d3a9413fd04c
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
42359530 | 2014-07-19 04:48:39 | ALLIES | 0 | 3 | 5 | 798698 | dave65tdh | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42359761 | 2014-07-19 05:07:15 | AXIS | 0 | 3 | 5 | 798698 | dave65tdh | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42364562 | 2014-07-19 15:48:24 | AXIS | 0 | 5 | 6 | 458667 | black sheep | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42377890 | 2014-07-20 15:08:20 | ALLIES | 0 | 5 | 6 | 1362585 | NEMAUS | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
42378149 | 2014-07-20 15:34:15 | AXIS | 0 | 4 | 6 | 1362585 | NEMAUS | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
42417163 | 2014-07-23 06:10:12 | ALLIES | 1 | 5 | 0 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42417309 | 2014-07-23 06:39:47 | AXIS | 1 | 5 | 4 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42456731 | 2014-07-26 06:07:11 | AXIS | 0 | 6 | 7 | 963569 | tinishubi | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42456920 | 2014-07-26 06:29:29 | ALLIES | 0 | 3 | 7 | 963569 | tinishubi | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42462675 | 2014-07-26 17:36:38 | ALLIES | 0 | 6 | 7 | 1610234 | Ted_Hilton | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42465204 | 2014-07-26 21:23:18 | ALLIES | 1 | 6 | 3 | 331242 | AdairC | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42465590 | 2014-07-26 21:52:24 | AXIS | 0 | 5 | 6 | 331242 | AdairC | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42499928 | 2014-07-29 05:32:46 | AXIS | 1 | 6 | 3 | 1563905 | boostybleep | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42500210 | 2014-07-29 06:10:19 | ALLIES | 1 | 6 | 4 | 1563905 | boostybleep | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42527722 | 2014-07-31 06:44:34 | ALLIES | 1 | 5 | 2 | 1394475 | Franzac | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 63150 | 59999
2 | 64643 | 60000 |  |  |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 65489 | 60000 |  |  |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 61296 | 60000 | 1 |  |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 57384 | 60300 | 2 |  |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 38477 | 36000 | 25769 | 24300 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 37958 | 42000 | 25600 | 30000
8 | 39372 | 37811 | 25610 | 29173
9 | 38862 | 38855 | 26702 | 30000
10 | 37175 | 38855 | 29335 | 30000
11 | 38725 | 38614 | 32471 | 29809
12 | 34768 | 37555 | 31799 | 28000
13 | 32840 | 37555 | 32905 | 28000
14 | 39757 | 40146 | 32995 | 30000
15 | 39667 | 39089 | 30543 | 31023
16 | 35987 | 39089 | 31473 | 31023
17 | 36447 | 39089 | 29858 | 31023
18 | 36600 | 39089 | 29631 | 31023
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 451518.05
2002-02-18 00:00:00
CBS Volume
 |  |  | 13684
Spreadsheet: 693833d1599170405-between-two-dates-daysout
Sheet: Sheet1

Days | 60
Cost | 5000
 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00
Number of Costs | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 1 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value
Needed Value |  |  |  |  |  |  | 5000 | 10000 | 10000 | 5000 | 10000 | 15000 | 15000 | 15000 | 15000 | 10000 | 10000 | 15000 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: JT 2 2003320

JT 2  2003320 |  | 2022-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Bottled Tea | 0.9
Diet Sprite | 0.56
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
[NAME] | 0.28
[NAME] | 1.13
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.35
Applesauce | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Juice Prune | 0.56
Juice Grape | 0.23
Honey | 0.07
Jam/Jelly ea | 0.06
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.16
Ranch Dressing | 0.04
Hot Sauce | 0.5
Miracle Whip | 0.25
Salt/Pepper | 0.02
Lemon Juice | 0.03
[NAME] | 0.11
[NAME] | 0.13
Milk- Skim | 0.25
2% Milk | 0.25
Broth, [NAME] pkt. | 0.1
Cereal-Cheerios | 0.39
Cereal-Corn Flakes | 0.39
[NAME] | 1.47
Coffee, [NAME]. cs. | 95.11
Coffee Decaf  Prepack cs. | 37.84
Creamer, non dairy box | 0.03
Tea Bags | 0.03
Diet Popsicles | 0.25
Popcicles | 0.2
Ice Cream- Diet-Vanilla | 0.43
Ice Cream-Vanilla | 0.41
Ensure | 0.13
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.23
Pulmocare | 0.44
2Cal HN | 0.4
Vital | 3.04
[NAME] | 1.5
Juven | 2.1
[NAME] | 1.75
Sugar | 0.02
Sweetner-Equal | 0.03
Sweetner-Splenda | 0.03
Sweetner-Sweet N Low | 0.03
[NAME]-pkts. | 2.4
Plastic Ware (fork,spoon knife) | 0.03
[NAME] | 3.5
monthly coffee
[NAME] | 10
Refrigerator Thermometer (reg.)
Monthly Total
Spreadsheet: 268978d1380905662-help-with-if-answer-x-then-add-1-if-answer-then-add-2-easy
Sheet: Sheet1

 |  | Required Charge Current (A) | 100 | 200 | 400 | 800
 |  | 3800 |  |  |  |  |  | If total in any cell D12 thru [NAME] <= 10 add 1 to the total count, and if >=10 add 2 to the total count
 |  | 6000
 |  | 1000
 |  | 8500
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 13 - Table 2

LAS Beer |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 20966.852 | 0 | 0 | 638.3439999999973 | 21605.196 | 0.03044539065759588 | 0.03044539065759597
Net revenue | 2848.638 | 0 | -200.7052754185988 | 653.7692754185988 | 3301.702 | 0.1590458317273027 | 0.2295024062090721
Net revenue/hl | 135.863886481385 | 0 | -9.289676215786187 | 26.2456021535989 | 152.8198124191977 | 0.1248008310150606 | 0.1931757057251182
[NAME] | -880.4421437648928 | 0 | 56.68118851283793 | -187.9203247479452 | -1011.68128 | 0.1490604887152613 | 0.2134385843280648
[NAME]/hl | -41.99209989963647 | 0 | 2.623498000797491 | -7.457230183406431 | -46.82583208224541 | 0.1151105135052031 | 0.1775865032048799
Gross profit | 1968.195856235107 | 0 | -144.0240869057609 | 465.8489506706536 | 2290.02072 | 0.1635126213406932 | 0.2366883098523333
Gross margin | 0.6909252268049177 | 0 | 0 | 0 | 0.6935879494878701 | 30 | 40
SG&A excl. deprec.&amort. | -572.426 | 0 | 43.67152999135385 | -124.7135299913539 | -653.4680000000001 | 0.1415763784314479 | 0.2178683882132431
SG&A deprec.&amort. | -41.044 | 0 | 3.450941006215558 | -10.03294100621556 | -47.626 | 0.1603644868921159 | 0.2444435485385334
SG&A total | -613.4699999999999 | 0 | 47.12247099756939 | -134.7464709975695 | -701.094 | 0.1428333903858381 | 0.2196463902025682
Other operating income/expenses | -13.90885350676805 | 0 | 4.548910010391689 | 5.113625467603791 | -4.246318028772571 | -0.6947039504940999 | -0.3676525505941594
Normalized EBIT | 1340.817002728339 | 0 | -92.35270589779981 | 336.2161051406879 | 1584.680401971227 | 0.1818767204970302 | 0.2507546551517054
Normalized EBIT margin | 0.4706870450820143 | 0 | 0 | 0 | 0.4799586401108359 | 90 | 80
Normalized EBITDA | 1561.556002728339 | 0 | -105.2236483078707 | 355.5810475507595 | 1811.913401971228 | 0.1603255975485132 | 0.2277094429719401
Normalized EBITDA margin | 0.5481763575183436 | 0 | 0 | 0 | 0.5487816289814247 | 10 | -10
Spreadsheet: 31b429a1-9202-468f-9278-e765c0f0e00c
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
42630095 | 2014-08-07 21:46:40 | AXIS | 1 | 4 | 1 | 565186 | player565186 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
42643940 | 2014-08-08 23:19:57 | AXIS | 1 | 5 | 3 | 1610595 | player1610595 | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42698023 | 2014-08-12 22:22:53 | AXIS | 1 | 10 | 2 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42698410 | 2014-08-12 23:01:34 | ALLIES | 0 | 8 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42698979 | 2014-08-12 23:12:03 | AXIS | 1 | 5 | 0 | 380301 | Alecsander | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
42699101 | 2014-08-12 23:33:38 | AXIS | 1 | 6 | 3 | 380301 | Alecsander | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42699367 | 2014-08-12 23:52:27 | ALLIES | 0 | 4 | 6 | 380301 | Alecsander | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
Spreadsheet: 91341d1291107957-sumif-a-text-formula-sumif-example
Sheet: Sheet1

Row No. | Description | Totaling Type | Totaling | Amount
1 | [NAME] | Posting Accounts | 122620 | 100
1 | VAT Output | Posting Accounts | 122630 | 100
1 | VAT Control account | Posting Accounts | 122610 | 100
A1 | Total Assets | [NAME] | 1
2 | Dividends payable (2007) | Posting Accounts | 231350 | 200
2 | Dividends payable (2008) | Posting Accounts | 231351 | 200
2 | Dividends payable (2009) | Posting Accounts | 231352 | 200
2 | Audit fees Payable - 2008 | Posting Accounts | 231524 | 200
2 | Audit fees Payble - 2009 | Posting Accounts | 231525 | 200
2 | Provision for legal fees | Posting Accounts | 231526 | 200
2 | Corporation Tax Liability - 2008 | Posting Accounts | 231531 | 200
A2 | Total Liabilities | [NAME] | 2
3 | Share Capital | Posting Accounts | 211100 | 500
3 | Share Premium | Posting Accounts | 212100|212110 | 500
3 | Reserves | Posting Accounts | 215102|214100|214101 | 500
A3 | Share Capital and Reserves | [NAME] | 3
A4 | NET ASSETS | [NAME] | A1+A2+A3
Spreadsheet: 192668d1352485426-grouping-data-in-multiple-columns-under-one-entity-dummy-worksheet
Sheet: Sheet1

Original Data
Org Number | Org Name | Group A Amount 1 | Group A Amount2 | Group B Amount 1 | Group B Amount 2
12345 | XYZ | 1000
12345 | XYZ |  | 1000 | 1000
12345 | XYZ |  |  |  | 1000
Desired Result |  | Group A | Group B
12345 | XYZ | 2000 | 2000
Spreadsheet: 153069d1335745038-excel-2007-conditional-formatting-with-2-variables-rick52a
Sheet: Sheet2

Biofos |  |  | Coarse |  |  | Dynafos |  |  | Nexfos
P | P > 21 < 22 |  | P | P > 21 < 22 |  | P | P  > 18.5 < 19.5 |  | P | P > 19 < 20
Ca | Ca > 15 < 16 |  | Ca | Ca> 15 < 16 |  | Ca | Ca > 20 < 21 |  | Ca | Ca > 15 < 18
+12 | < 1 |  | +8 | < 2 |  | +12 | < 2 |  | Na | Na > 4 < 5
-100 | < 1 |  | +12 | < 30 |  | -100 | < 2 |  | Insol | Insol >5 < 6
 |  |  |  |  |  |  |  |  | +12 | < 1
 |  |  |  |  |  |  |  |  | -100 | < 5
Biofos | 1
Coarse | 1
Dynafos | 1
Nexfos
 | P > 21 < 22 |  | Ca > 15 < 16
 | P  > 18.5 < 19.5 |  | Ca > 20 < 21
 | P > 19 < 20 |  | Ca > 15 < 18
Spreadsheet: 151296d1334856786-leaderboard-sorting-leaderboard
Sheet: Leader Board

 |  |  | Name | Session 1 | Session 2 | Session 3 | Total
 |  | 1 | Aberdeen | 0 | 0 | 0 | 0
 |  | 1 | [NAME] | 0 | 0 | 0 | 0
 |  | 1 | Deeside | 0 | 0 | 0 | 0
 |  | 1 | Deveron | 0 | 0 | 0 | 0
 |  | 1 | Donside | 0 | 0 | 0 | 0
 |  | 1 | Ellon | 0 | 0 | 0 | 0
 |  | 1 | Forres | 0 | 0 | 0 | 0
 |  | 1 | Fraserburgh | 0 | 0 | 0 | 0
 |  | 1 | Mearns | 0 | 0 | 0 | 0
 |  | 1 | Moray | 0 | 0 | 0 | 0
Spreadsheet: 874371d1720964925-calculate-monthly-costs-based-on-start-and-end-dates-calculate-monthly-costs-based-on-start-and-end-dates
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  | 0.138
 |  |  | 37.5 |  |  |  |  |  | 0.07 | 9096 |  | 189.84 |  | Helper Column
Name | Start Date | End Date | FTE Salary | ACTUAL Hrs | Actual Salary | [NAME] | Project | Actual [NAME] by Project | Pension by Project | NIC | NIC Project | HSF by Project | Total Cost by Project | Project Days | Project Start Date | Project End Date
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 3.75 | D05
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 11.25 | R4401
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 7.5 | R4402
Employee B | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 37.5 | R62
Employee C | 2024-04-01 00:00:00 | 2024-05-31 00:00:00 | 33366 | 37.5 |  | 37.5 | R36
Employee D | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 15 | U05
Employee D | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 22.5 | U11
Employee E | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 26.25 |  | 18.75 | R36
Employee E | 2024-06-17 00:00:00 | 2025-03-31 00:00:00 | 33366 | 26.25 |  | 7.5 | R76
Employee F | 2024-04-01 00:00:00 | 2024-05-30 00:00:00 | 33366 | 30 |  | 30 | R4105
Employee F | 2024-06-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 30 |  | 7.5 | R4105
Employee F | 2024-06-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 30 |  | 22.5 | R89
Employee G | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 30 |  | 30 | R21
Employee H | 2024-04-01 00:00:00 | 2024-05-31 00:00:00 | 24790 | 37.5 |  | 37.5 | U11
Employee I | 2024-09-01 00:00:00 | 2025-03-31 00:00:00 | 25584 | 37.5 |  | 37.5 | U11
Employee J | 2024-09-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 37.5 | U11
Calculate monthly costs based on start and end dates |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
https://www.excelforum.com/excel-formulas-and-functions/1426208-calculate-monthly-costs-based-on-start-and-end-dates.html
Spreadsheet: 804782d1668333880-missing-alphanumeric-sequence-alphanumericsequence_52779
Sheet: Sheet1

Invoice Number |  |  |  | Expected Result | Missing Invoice Number
C01063381 |  |  |  | X01003458
C01063384 |  |  |  | C01063382 | C01063388
C01063386 |  |  |  | C01063388 | CR01005474
C01063389 |  |  |  | CR01005474 | K01003460
CR01005471 |  |  |  | K01003460 | X01003458
CR01005473
CR01005476
CR01005478
CR01005480
[NAME]
K01003458
[NAME]
[NAME]
K01003465
X01003456
X01003459
X01003461
X01003463
X01003465
C01063383
C01063385
C01063387
C01063390
CR01005472
CR01005475
CR01005477
CR01005479
[NAME]
[NAME]
K01003459
K01003462
K01003464
X01003455
[NAME]
X01003460
X01003462
X01003464
Spreadsheet: 813473d1673801141-vlookup-2-condition-how-ask-formula-vlookups
Sheet: Sheet2

 |  |  |  | 2023-01-01 00:00:00 | % of all | Budget | % Spent | Spent | Funded | Released
Software |  |  |  | Left over
a | asdf |  |  | 14.07766990291262 | 0.004675262902392893 | 14.07766990291262 | 0
b | asdfg |  |  | 1240.814239482201 | 0.4693306192876887 | 1413.2 | 0 |  | n/a | 172.3857605177994
 | zxcv |  |  | 48.64317152103564 | 0.1376415239697612 | 414.4519741100324 | 0 |  |  | 365.8088025889967
Ex Rate | 14500
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: BDO

Raw Material |  | BDO
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00
2023-10-09 00:00:00 |  | 18 | 200
2023-10-11 00:00:00 |  | 47 | 200
Total
Spreadsheet: 5f4a03ca-5048-4add-9f6f-537ffb3464b6
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 10/20/2014 5:46:23 PM
 | [NAME] ([NAME]) Neumann - NON
Justice of the Supreme Court - NON | 97859
 | [NAME]
Public Service Commissioner - DEM | 46446
 | [NAME]
Public Service Commissioner - REP | 54859
 | [NAME]
Representative in Congress - DEM | 52403
 | [NAME]
Representative in Congress - REP | 56570
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 550781d1512546067-creating-new-sheets-based-on-categories-in-one-sheet-excel-forum
Sheet: Sheet1

Sku | Product name | Category | Subcategory | Price | Margin
bkm_111_123 | Baby Doll | toys | girls | 12.12 | 15
bkm_111_124 | Baby boys Doll | toys | Boys | 12.12 | 15
bkm_111_125 | red rose | Flowers | roses | 15 | 25
bkm_111_126 | Yellow rose | Flowers | roses | 15 | 25
bkm_111_127 | [NAME] | cleaning | soap | 30 | 22
bkm_111_128 | head and shoulders | cleaning | Shampoo | 12 | 11