tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56176d1256257967-too-many-arguments-jacko311
Sheet: Variables

# | Setup |  | Time Frame | Symbol | Accounts
0 | (none)
1 | Trend Trade |  | 1m |  | Mirus |  | Futures
2 | [NAME] |  | 3m |  | TS_Futures | (The symbols must be placed in alphabetical order or many of the calculations will not be correct.) | Symbol | Point Value | [NAME] | [NAME] | Commission ($/contract) | Commission in Ticks
3 | [NAME] |  | 5m |  | TS_Forex
4 |  |  | 10m |  | IB_IRA |  | AD | 100000 | 0.0001 |  | 4.4
5 |  |  | 13m |  | IB_Standard |  | BP | 62500 | 0.0001 |  | 5.32
6 |  |  | 15m |  |  |  | CC | 10 | 1 |  | 4.4
7 |  |  | 30m |  |  |  | CD | 100000 | 0.0001 |  | 4.4
8 |  |  | 60m |  |  |  | CL | 1000 | 0.01 |  | 5.32
9 |  |  | Daily |  |  |  | CT | 50000 | 0.0001 |  | 5.32
10 |  |  | Weekly |  |  |  | DX | 1000 | 0.005 |  | 5.32
11 |  |  | 650vb |  | Type |  | EC | 125000 | 0.0001 |  | 5.32
12 |  |  | 1000vb |  | Futures |  | EMD | 100 | 0.1 |  | 5.32
13 |  |  | 2500vb |  | Forex |  | ES | 50 | 0.25 |  | 4.4
14 |  |  | 5000vb |  | Options |  | GC | 100 | 0.1 |  | 4.4
15 |  |  | 10000vb |  | Stock_ETF |  | HG | 25000 | 0.0005 |  | 5.32
16 |  |  | 55t |  |  |  | HO | 42000 | 0.0001 |  | 5.32
17 |  |  | 220t |  |  |  | JY | 12500000 | 1e-06 |  | 5.32
18 |  |  | 512t |  |  |  | KC | 37500 | 0.0005 |  | 5.32
19 |  |  | 20000vb |  |  |  | NG | 10000 | 0.001 |  | 5.32
20 |  |  | 610t |  |  |  | NQ | 20 | 0.25 |  | 5.32
21 |  |  |  |  |  |  | SF | 125000 | 0.0001 |  | 5.32
22 |  |  |  |  |  |  | SI | 5000 | 0.005 |  | 5.32
23 |  |  |  |  |  |  | TF | 100 | 0.1 |  | 4.4
24 |  |  |  |  |  |  | US | 1000 | 0.03125 |  | 4.4
25 |  |  |  |  |  |  | YM | 5 | 1 |  | 4.4
26 |  |  |  |  |  |  | ZB | 1000 | 0.03125 |  | 4.4
27 |  |  |  |  |  |  | ZC | 50 | 0.25 |  | 5.32
28 |  |  |  |  |  |  | ZF | 1000 | 0.0078125 |  | 5.32
29 |  |  |  |  |  |  | ZL | 600 | 0.01 |  | 5.32
30 |  |  |  |  |  |  | ZM | 100 | 0.1 |  | 5.32
31 |  |  |  |  |  |  | ZN | 1000 | 0.01625 |  | 5.32
32 |  |  |  |  |  |  | ZS | 50 | 0.25 |  | 5.32
33 |  |  |  |  |  |  | ZW | 50 | 0.25 |  | 4.4
34
35
36
37 |  |  |  |  |  | Option/Stock/ETF commissions
38 |  |  |  |  |  | Type | Per share/contract
39 |  |  |  |  |  | Option | 1.4
40 |  |  |  |  |  | Stock/ETF | 0.01
41
42
43
(The symbols must be placed in alphabetical order or some of the calculations will not be correct.)
Symbol
Point Value
[NAME]
[NAME]
Commission ($/contract)
Commission in Ticks
Spreadsheet: 858314d1707046341-combined-two-operations-result-in-one-summary-sheet-shipment_receipt_report
Sheet: Summary

 | Offloading Expense by WH
 |  | Old WH |  | New WH |  |  | Offloading Expense Summary 2024
 | Month | Shipments Received | Outsourced Expense | Shipments Received | Outsourced Expense |  | Month | Shipments Received | Outsourced Expense
 | 2024-01-01 00:00:00 |  |  |  |  |  | 2024-01-01 00:00:00
 | 2024-02-01 00:00:00 |  |  |  |  |  | 2024-02-01 00:00:00
 | 2024-03-01 00:00:00 |  |  |  |  |  | 2024-03-01 00:00:00
 | 2024-04-01 00:00:00 |  |  |  |  |  | 2024-04-01 00:00:00
 | 2024-05-01 00:00:00 |  |  |  |  |  | 2024-05-01 00:00:00
 | 2024-06-01 00:00:00 |  |  |  |  |  | 2024-06-01 00:00:00
 | 2024-07-01 00:00:00 |  |  |  |  |  | 2024-07-01 00:00:00
 | 2024-08-01 00:00:00 |  |  |  |  |  | 2024-08-01 00:00:00
 | 2024-09-01 00:00:00 |  |  |  |  |  | 2024-09-01 00:00:00
 | 2024-10-01 00:00:00 |  |  |  |  |  | 2024-10-01 00:00:00
 | 2024-11-01 00:00:00 |  |  |  |  |  | 2024-11-01 00:00:00
 | 2024-12-01 00:00:00 |  |  |  |  |  | 2024-12-01 00:00:00
 | YTD Total |  |  |  |  |  | YTD Total
Spreadsheet: 490135d1479708295-date-entire-in-cell-will-indicate-time-and-close-open-text-statue
Sheet: Sheet1

Issue [NAME] | Time | Issue Raised By | Department | Issue Details | Solution | Solve Date | Statues
2016-11-16 00:00:00 | 10:30:00 | Employee 707 | Procurement | Query1 | Solution34 | 2016-11-16 00:00:00 | Close
2016-11-16 00:00:00 | 11:15:00 | Employee 269 | Sales | query2 | Solution35 |  | Open
2016-11-16 00:00:00 | 12:00:00 | Employee 268 | Plant | Query3 | Solution36 | 2016-11-17 00:00:00 | Close
2016-11-16 00:00:00 | 12:45:00 | Employee 826 | CRM | Query4 | Solution37 | 2016-11-18 00:00:00 | Close
2016-11-16 00:00:00 | 13:30:00 | Employee 388 | HR | Query5 | Solution38 |  | Open
2016-11-16 00:00:00 | 14:15:00 | Employee 180 | Account | Query6 | Solution39 |  | Open
2016-11-16 00:00:00 | 15:00:00 | Employee 037 | Plant | Query7 | Solution40 | 2016-11-19 00:00:00 | Close
Spreadsheet: 289347d1389534875-popup-to-show-and-select-from-drop-down-list-to-excel-forum-opoup-menu-1201
Sheet: prt

header
aa1
ab2
aa2
[NAME]
aa3
ab4
aa4
ab5
aa5
ab6
aa6
[NAME]
aa2
[NAME]
aa3
ab4
aa4
ab5
aa5
ab6
aa6
[NAME]
aa7
ab8
aa3
ab4
aa4
ab5
aa5
ab6
aa6
[NAME]
aa7
ab8
aa8
ab9
aa4
ab5
aa5
ab6
aa6
[NAME]
aa7
ab8
aa8
ab9
aa9
ab10
aa5
ab6
aa6
[NAME]
aa7
ab8
aa8
ab9
aa9
ab10
aa10
ab11
aa6
[NAME]
aa7
ab8
aa8
ab9
aa9
ab10
aa10
ab11
aa11
ab12
aa7
ab8
aa8
ab9
aa9
ab10
aa10
ab11
aa11
ab12
aa12
ab13
aa8
ab9
aa9
ab10
aa10
ab11
aa11
ab12
aa12
ab13
aa13
[NAME]
aa9
ab10
aa10
Spreadsheet: 22543d1211488098-hi-need-help-work
Sheet: Sheet1

Company
Server Vs Client
Server1 |  |  | Server2 |  | Server3 |  | Server4
Sl No | Group | Client | Group | Client | Group | Client | Group | Client
1 | Purchase | TJ-ACS-1 | Production | JP0000DWYAD02 | Design | ADMIN01 | Production | JP0000DWYAD02
2 | Purchase | SDCSERVER01 | Service | PORTALAPPSTAGE | Design | USAMACS0100000 | Production | PORTALAPPSTAGE
3 | Purchase | SDCSERVER02 | Service | SAPSOLMGR01 | Design | ATCLS0F5 | Production | SAPSOLMGR01
4 | Purchase | USPDCSS200002 | Service | USACOMD0110001 | Design | ATLN6800 | Production | USACOMD0110001
5 | Purchase | PORTALAPPPROD | Service | SCSSG0F3 | Design | CYP-ACS-2 | Production | USIBMXS0010001
6 | transport | 10.128.33.120 | Sales | TJPAVCB01 | Design | DGTSERV | Marketing | USIBMXS0010002
7 | transport | 10.130.4.103 | Sales | TJPAVCB02 | Design | KEPICPA3 | Marketing | USIBMXS0010010
8 | transport | BUSCONN03 | Sales | PORTALDBSTAGE | IT | KEPICSQL | Marketing | USIBMXS0010011
9 | transport | [NAME] | Sales | PORTALDEV | IT | MIBDGSERV | Marketing | USMECAD0010000
10 | transport | PIC_MEDIA | Sales | 10.128.33.119 | IT | SDCSERVER03 | Marketing | USMECAD0010001
Spreadsheet: 161315d1339492753-check-for-escalation-after-consultation-brent_solution
Sheet: Sheet1

Case ID | Summary | Create date | Subscriber ID | Escalation (Y/N)
HD0000000576495 | CR: Compliments | 2011-01-04 00:00:00 | 52064730 | N
HD0000000576780 | CR: Consultation | 2011-01-04 00:00:00 | 64465750 | N
HD0000000576730 | CR: Consultation | 2011-01-04 00:00:00 | 50355684 | Y
HD0000000576763 | CR: Customer Issue (direct) | 2011-01-04 00:00:00 | 74880147 | N
HD0000000576702 | CR: Escalation | 2011-01-07 00:00:00 | 50355684
Spreadsheet: 706119d1606482506-single-reference-with-multiple-return-values-sample-1-
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  | expected result
fruits | type | place | status
apple | a | abc1 | good |  |  |  |  |  |  | find value | value return
 | b | abc2 | good |  |  |  |  |  |  | orange |  |  |  |  |  | banana | a | abc6 | good
 | c | abc3 | bad |  |  |  |  |  |  |  |  |  |  |  |  |  | b | [NAME] | good
 | d | abc4 | bad |  |  |  |  |  |  |  |  |  |  |  |  |  | c | abc8 | bad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d | abc9 | bad
banana | a | abc6 | good |  |  |  |  |  |  |  |  |  |  |  |  |  | c | abc10 | bad
 | b | [NAME] | good
 | c | abc8 | bad
 | d | abc9 | bad
 | c | abc10 | bad
pineapple | a | abc12 | good
 | b | abc13 | good
 | c | abc14 | bad
 | d | abc15 | bad
mango | a | abc17 | good
 | b | abc18 | good
 | c | abc19 | bad
 | d | abc20 | bad
 | c | [NAME] | bad
 | d | [NAME] | bad
 | c | abc23 | bad
orange | a | [NAME] | good
 | b | abc23 | good
 | c | abc24 | bad
 | d | abc25 | bad
Spreadsheet: a95ba027-4b8d-4f9b-be99-8bbafe65a5a3
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
FLETG | Test | FLETG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FLETG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FLETG | Result | FLETG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 761642d1641130832-formula-for-multiple-conditions-test-file-etaf-3-
Sheet: Sheet2

Name | Availability | [NAME]
A |  | Do Not Disturb
B
C |  |  |  |  |  |  | The person A should not be available if:    1. The DND status (Sheet2) of person A is Do Not Disturb.  2. The status of person A is pending (Sheet 1).  3. Person A has 2 or more status as Completed.
D
D |  |  | [NAME]
B |  |  | Pending
 |  |  | Completed
 |  |  | OR
Spreadsheet: 838880d1691493484-simplifying-speeding-up-an-indirect-formula-weekly-sales-yoy-by-customer-test
Sheet: D

 |  |  |  | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC |  |  | TOTAL YEARLY
 |  |  |  | 2022-01-03 00:00:00 | 2023-01-02 00:00:00 | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference | 2022 | 2023 | Difference
D | 1283
 |  |  | 2023-05-09 00:00:00
 |  |  | 2023-04-28 00:00:00
 |  |  | 2023-05-08 00:00:00
 |  |  | 2023-07-18 00:00:00
 |  |  | 2023-07-25 00:00:00
 |  |  | 2023-07-25 00:00:00
 | D's TOTAL
KEY
 | Sampling
 | New customer
abcd | Closed
Spreadsheet: 306e0d59-60fd-4d51-ad9d-cb82c1befde1
Sheet: Reading Gr. 5

2012 Minnesota Comprehensive Assessments-Series II (MCA-II)
Grade 5 Reading
Raw Score | Scale Score | Level | Percentile Rank
0 | 501 | D | 1
1 | 501 | D | 1
2 | 501 | D | 1
3 | 501 | D | 1
4 | 501 | D | 1
5 | 501 | D | 1
6 | 501 | D | 1
7 | 501 | D | 1
8 | 501 | D | 1
9 | 507 | D | 1
10 | 512 | D | 1
11 | 516 | D | 1
12 | 519 | D | 1
13 | 521 | D | 1
14 | 523 | D | 1
15 | 526 | D | 1
16 | 527 | D | 2
17 | 529 | D | 2
18 | 531 | D | 3
19 | 532 | D | 3
20 | 534 | D | 4
21 | 535 | D | 5
22 | 537 | D | 5
23 | 538 | D | 6
24 | 540 | P | 7
25 | 541 | P | 8
26 | 542 | P | 10
27 | 544 | P | 11
28 | 545 | P | 13
29 | 546 | P | 15
30 | 548 | P | 17
31 | 549 | P | 19
32 | 550 | M | 22
33 | 552 | M | 25
34 | 553 | M | 28
35 | 554 | M | 32
36 | 556 | M | 36
37 | 557 | M | 41
38 | 559 | M | 46
39 | 561 | M | 52
40 | 563 | M | 58
41 | 565 | E | 64
42 | 567 | E | 70
43 | 569 | E | 77
44 | 572 | E | 83
45 | 576 | E | 89
46 | 580 | E | 93
47 | 586 | E | 97
48 | 597 | E | 99
49 | 599 | E | 99
Spreadsheet: 26029d1217910794-averaging-most-recent-data-example
Sheet: Sheet1

Fruit | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | 3 Day Average
Apples | 5 | 6 | 12 | 4 | 6 | 3
Oranges |  | 8 | 3 |  | 5 | 2
Pears | 1 | 5 |  |  |  | 4
Bananas | 3 | 6 |  | 6 | 3 | 9
Spreadsheet: mary_fischer__25626__1291
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 1291
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915
RE - Beg Bal |  | 0920 |  |  |  | 46000 |  |  |  |  |  |  |  | -18299 |  | Taxes
RE - Net Income |  | 0930 |  | 46000 |  |  |  | -61807
RE - Net Income (Fair Value Adjustment) |  | 0931 |  |  |  |  |  | 27364
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 739135d1625549895-make-match-function-ignore-hidden-cells-excelforum-question
Sheet: Sheet4

 |  |  |  |  |  |  | Data | Data Position in Column
 |  |  |  |  |  |  | 1 |  |  |  |  | Notes
 |  |  |  |  |  |  | 2 |  |  |  |  | Values in blue cells is the position of data in the green cells
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
Spreadsheet: 798817d1664755073-volume-range-with-multiple-if-and-statements-see-attached-volume-range-calculation
Sheet: Sheet1

 |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 0
 | In-service | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  | 1000000
 | [NAME] | 500000 | 1250000 | 2000000 | 3000000 | 3500000 | 4200000 |  |  | Expenses | 3200 | 3840 | 4608 | 5529.599999999999 | 6635.52 | 7962.623999999999
 | Expenses
Spreadsheet: 778297d1650982037-pull-three-columns-from-one-sheet-to-another-and-have-them-aplhabetically-sorted-for-excel-help-forum
Sheet: Sorted

Forkortet nedbetalingsperiode (Filtrert på unike kreditorer)
Process assistant | Total |  |  |  |  |  |  |  | Process assistant | Case number | Total
B
D
W
Spreadsheet: 801578d1666262275-get-another-result-directly-from-two-tables-without-auxiliary-columns-help10-20
Sheet: Sheet1

 | TABLE A |  |  |  |  |  | TABLE B | nation | Asia | Americas | Europe | Japan | Korea
 | Column1 | Column2 | Column3 | Column4 | Column5 |  |  | discount factor | 0.1 | 0.06 | 0.08 | 0.03 | 0.12
 | salesman |  | nation |  | Amount
 | A |  | Asia |  | 100
 | B |  | Americas |  | 200
 | C |  | Japan |  | 300 |  |  | salesman | Sum
 | D |  | Europe |  | 400 |  |  | A | 7789
 | E |  | Korea |  | 500 |  |  | F | 10384
 | F |  | Asia |  | 600 |  |  | B | 8162
 | G |  | Japan |  | 700 |  |  | C | 8800
 | H |  | Asia |  | 800 |  |  | D | 9180
 | A |  | Americas |  | 900 |  |  | E | 9735
 | B |  | Japan |  | 1000 |  |  | G | 10786
 | C |  | Europe |  | 1100 |  |  | H | 11016
 | D |  | Korea |  | 1200
 | E |  | Asia |  | 1300
 | F |  | Japan |  | 1400
 | G |  | Asia |  | 1500
 | H |  | Americas |  | 1600
 | A |  | Japan |  | 1700
 | B |  | Europe |  | 1800
 | C |  | Korea |  | 1900
 | D |  | Asia |  | 2000
 | E |  | Japan |  | 2100
 | F |  | Asia |  | 2200
 | G |  | Americas |  | 2300
 | H |  | Japan |  | 2400
 | A |  | Europe |  | 2500
 | B |  | Korea |  | 2600
 | C |  | Asia |  | 2700
 | D |  | Japan |  | 2800
 | E |  | Asia |  | 2900
 | F |  | Americas |  | 3000
 | G |  | Japan |  | 3100
 | H |  | Europe |  | 3200
 | A |  | Korea |  | 3300
 | B |  | Asia |  | 3400
 | C |  | Japan |  | 3500
 | D |  | Asia |  | 3600
 | E |  | Americas |  | 3700
 | F |  | Japan |  | 3800
 | G |  | Europe |  | 3900
 | H |  | Korea |  | 4000
Spreadsheet: 704565d1605625691-breakout-multiple-items-from-a-single-cell-into-their-own-row-slash-cleanup
Sheet: Sheet1

Original Data |  |  |  |  |  | Desired Result
Item | P/N | Desc | Qty. | Price Ea. |  | Item | P/N | Desc | Qty. | Price Ea.
4 | 846TE17 / 834BW61 | Bracket | 12 | #N/A |  | 4 | 846TE17 / 834BW61 | Bracket | 12 | #N/A
5 | 841R512 / 824LY903 / 826KV987 | Frame | 10 | #N/A |  | 4 | 846TE17 | Bracket | 12 | 12.31
6 | 457PO4645 | Varnish | 1 | 45.87 |  | 4 | 834BW61 | Bracket | 12 | 19.6
 |  |  |  |  |  | 5 | 841R512 / 824LY903 / 826KV987 | Frame | 10 | #N/A
 |  |  |  |  |  | 5 | 841R512 | Frame | 10 | 81
 |  |  |  |  |  | 5 | 824LY903 | Frame | 10 | 67.51
 |  |  |  |  |  | 5 | 826KV987 | Frame | 10 | 47.5
 |  |  |  |  |  | 6 | 457PO4645 | Varnish | 1 | 45.87
Spreadsheet: 267666d1380133696-working-with-sumif-based-on-the-date-question
Sheet: Sheet1

Branch Name |  | number of deliveries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
adidas |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00
adidas |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-02 00:00:00 | adidas
fila |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-03 00:00:00 | nike
polo |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-03 00:00:00 | fila
Nike |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-03 00:00:00 | polo
adidas |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-03 00:00:00 | adidas
fila |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-07 00:00:00 | adidas |  |  | <<<this is where the problem occurs, it should minus the data from the previous date. The answer should be "-2" because there's a delivery of adidas last 09-03-13
adidas |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-08 00:00:00 | nike
Nike |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-09 00:00:00 | fila
adidas |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-10 00:00:00 | polo
fila |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-11 00:00:00 | adidas
polo |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-12 00:00:00 | adidas
Nike |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-13 00:00:00 | nike
adidas |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-14 00:00:00 | fila
adidas |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | polo
polo |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-16 00:00:00 | adidas |  |  | <<same goes here, the answer should be -1
Spreadsheet: 9ffd3924-bd07-4e99-895e-a148408c9480
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  |  |  | ประกาศรุ่นที่ 15 - 23
1. ตรวจสอบรายชื่อหน่วยงานและจังหวัด ให้ถูกต้อง หากไม่ถูกต้อง โทร. [PHONE] ด่วน!!!!!!!
2. ให้จองห้องพักตามรุ่นที่ประกาศที่โรงแรมตรัง (ทิวลิป วสุ) ถนนวิสุทธิ์กษัตริย์ เขตพระนคร กทม. โทร. 02-281-1402-3
 | หากที่พักเต็ม ให้ติดต่อจองที่โรมแรม นูโว ซิตี้ โทร. 02-282-7500
3. กรณีที่ต้องการเปลี่ยนผู้เข้าอบรม ให้ทำหนังสือราชการแจ้งเรื่องการเปลี่ยนผู้เข้าอบรมแล้วนำหนังสือมายื่นวันอบรม
4. ให้พิมพ์เทศบัญญัติ/ข้อบัญญัติ ประจำปี 2556 ในระบบ ให้เสร็จสิ้นก่อนวันอบรม
5. เอกสารที่ อปท. ต้องนำมาในวันอบรม (นำเครื่องคำนวณมาด้วย)
- | ให้นำข้อมูลเกี่ยวกับบุคลากร ได้แก่ ชื่อ-นามสกุล เลขที่บัตรประจำตัวประชาชน วันที่บรรจุ เงินเดือน/ค่าตอบแทน
- | ฐานข้อมูลหมู่ ถนน ซอย ฐานข้อมูลพื้นที่รับผิดชอบ [NAME] (บางส่วน เพื่อฝึกการบันทึกข้อมูล)
- | งบแสดงฐานะการเงินประจำปีงบประมาณ 2555 พร้อมหมายเหตุประกอบงบการเงิน ได้แก่ เลขที่บัญชีเงินฝากธนาคาร รายละเอียดเงินรับฝาก
- | รายงานการจัดทำเช็คพร้อมฎีการายจ่ายที่เบิกจ่ายไปแล้วของปีปัจจุบัน ตั้งแต่เดือนตุลาคม ถึงปัจจุบัน หรืออย่างน้อย ๓ เดือน
 | (โดยให้จัดเรียงฎีกาเบิกเงินพร้อมเอกสารประกอบการเบิกจ่ายรวมกับรายงานการจัดทำเช็คในแต่ละวัน โดยจัดเรียงตามลำดับก่อนหลังและจัดเรียงเป็นเดือน ๆ )
- | [NAME] ตั้งแต่เดือนตุลาคม ถึงปัจจุบัน หรืออย่างน้อย ๓ เดือน
 | (โดยให้จัดเรียงใบนำส่งเงิน หลักฐานการฝากเงินกับธนาคารพร้อมเอกสารที่เกี่ยวข้อง   แนบรวมกับใบสำคัญสรุปใบนำส่งเงินในแต่ละวัน)
- | [NAME]  สมุดเงินสดจ่าย และทะเบียนเงินรายรับ ประจำปีงบประมาณปัจจุบัน
Spreadsheet: 713393d1610692465-data-presentation-in-a-column-orders_export-sample
Sheet: orders_export

Name | Financial Status | Subtotal | Shipping | Taxes | Total | Discount Code | Discount Code
1873 | paid | 320 | 0 | 0 | 320
1873
1873
1873
1874 | paid | 270 | 0 | 0 | 270 | OOJHK | OOJHK
1874 |  |  |  |  |  |  | OOJHK
1874 |  |  |  |  |  |  | OOJHK
1874 |  |  |  |  |  |  | OOJHK
1875 | paid | 6206 | 0 | 0 | 6206
1875
1875
1875
1875
1875
1875
1875
1875
1875
1875
1875
1876 | paid | 353 | 0 | 0 | 353 | OOJHK | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
1876 |  |  |  |  |  |  | OOJHK
Spreadsheet: susan_pereira__39557__T-port
Sheet: Sheet1

 | Vintage Gas
 | Callery (881241)
 | 0.05 | IT Rate
 | 0.0981 | Gathering
 | 0.0022 | GRI
 | 0.0495 | Fuel
 | Gwinville (881241)
 | 0.005 | IT Rate
 | 0.0268 | Gathering
 | 0.0022 | GRI
 | 0.0495 | Fuel