tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 732171d1620813042-number-of-different-values-in-a-range-based-on-criteria-test1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | HQ
JAN | 2021-01-01 00:00:00 | AAA | hq |  |  |  |  |  | 2021-01-01 00:00:00
 | 2021-01-12 00:00:00 | AAA | hq
 | 2021-01-20 00:00:00 | AAA |  | 2x AAA, so desired value is "1"
FEB | 2021-02-03 00:00:00 | BBB | hq
 | 2021-02-17 00:00:00 | BBB | hq
 | 2021-02-18 00:00:00 | BBB
 | 2021-02-24 00:00:00 | AAA |  | 2x BBB, so desired value is "1"
MAR | 2021-03-03 00:00:00 | AAA | hq
 | 2021-03-07 00:00:00 | AAA | hq
 | 2021-03-08 00:00:00 | CCC
 | 2021-03-11 00:00:00 | CCC | hq
 | 2021-03-14 00:00:00 | CCC
 | 2021-03-21 00:00:00 | CCC
 | 2021-03-23 00:00:00 | CCC
 | 2021-03-29 00:00:00 | AAA | hq
 | 2021-03-30 00:00:00 | AAA | hq | 4x AAA & 1xCCC, so desired value is "2"
APR | 2021-04-02 00:00:00 | BBB
 | 2021-04-04 00:00:00 | BBB | hq
 | 2021-04-04 00:00:00 | AAA | hq
 | 2021-04-06 00:00:00 | CCC
 | 2021-04-08 00:00:00 | CCC | hq
 | 2021-04-18 00:00:00 | BBB | hq
 | 2021-04-20 00:00:00 | DDD
 | 2021-04-23 00:00:00 | DDD | hq
 | 2021-04-27 00:00:00 | DDD | hq
 | 2021-04-28 00:00:00 | AAA | hq
 | 2021-04-30 00:00:00 | DDD | hq | 2x AAA, 2xBBB, 1xCCC, 3xDDD, so desired value is "4"
MAY | 2021-05-02 00:00:00 | EEE
 | 2021-05-04 00:00:00 | AAA | hq
 | 2021-05-05 00:00:00 | CCC | hq
 | 2021-05-07 00:00:00 | CCC | hq
 | 2021-05-08 00:00:00 | BBB |  | 1xAAA, 2xCCC, so desired value is "2"
Spreadsheet: 96877d1296139881-countifs-to-get-criteria-from-a-cell-reference-capacity
Sheet: Sheet2

Customer Account: Account Name |  | 1/2/2011 - 1/8/2011 | 1/9/2011 - 1/15/2011 | 1/16/2011 - 1/22/2011 | 1/23/2011 - 1/29/2011 | 1/30/2011 - 2/5/2011 | 2/6/2011 - 2/12/2011 | 2/13/2011 - 2/19/2011 | 2/20/2011 - 2/26/2011 | 2/27/2011 - 3/5/2011 | 3/6/2011 - 3/12/2011 | 7/10/2011 - 7/16/2011
BGA, Inc. | Record Count | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 1
CME Builders & Engineers, Inc. | Record Count | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Pilot Travel Centers | Record Count | 1 | 1 | 0 | 1 | 3 | 0 | 1 | 0 | 0 | 0 | 0
Target Corporation | Record Count | 0 | 2 | 3 | 21 | 25 | 34 | 8 | 8 | 5 | 3 | 0
Grand Total | Record Count | 1 | 4 | 3 | 24 | 28 | 34 | 9 | 10 | 5 | 3 | 1
Spreadsheet: 85949d1285938364-rounding-to-a-list-morris2
Sheet: Sheet1

Dot % | Table | Measurement
1 | 1.9 |  |  | 42
2 | 3.7 |  |  | 0 | 0 | #N/A
3 | 5.6 |  |  | 14 | 0
4 | 7.4
5 | 9.2
6 | 11
7 | 12.8
8 | 14.6
9 | 16.3
10 | 18.1
11 | 19.8
12 | 21.5
13 | 23.2
14 | 24.9 | 19
15 | 26.5
16 | 28.1
17 | 29.8
18 | 31.4
19 | 32.9
20 | 34.5 | 25
21 | 36
22 | 37.6
23 | 39.1
24 | 40.5
25 | 42 | 31
26 | 43.4
27 | 44.9
28 | 46.3
29 | 47.7
30 | 49 | 35
31 | 50.4
32 | 51.7
33 | 53
34 | 54.3
35 | 55.5
36 | 56.8
37 | 58
38 | 59.2
39 | 60.4
40 | 61.5 | 44
41 | 62.7
42 | 63.8
43 | 64.9
44 | 66
45 | 67
46 | 68.1
47 | 69.1
48 | 70.1
49 | 71
50 | 72
51 | 72.9
52 | 73.9
53 | 74.8
54 | 75.6
55 | 76.5
56 | 77.3
57 | 78.2
58 | 79
59 | 79.7
60 | 80.5
61 | 81.3
62 | 82
63 | 82.7
64 | 83.4
65 | 84.1
66 | 84.7
67 | 85.4
68 | 86
69 | 86.6
70 | 87.2
71 | 87.8
72 | 88.4
73 | 88.9
74 | 89.5
75 | 90
76 | 90.5
77 | 91
78 | 91.5
79 | 92
80 | 92.4
81 | 92.9
82 | 93.3
83 | 93.8
84 | 94.2
85 | 94.6
86 | 95
87 | 95.4
88 | 95.8
89 | 96.2
90 | 96.5
91 | 96.9
92 | 97.3
93 | 97.6
94 | 98
95 | 98.3
96 | 98.7
97 | 99
98 | 99.3
99 | 99.7
100 | 100
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 793870
 | Loans | 5913
 | Municipal | <1,000
 | Recovery
 | Sovereign | 229046
Index Tranche | Asia | <1,000
 | Europe | 188272
 | North America | 194059
Index | Asia | 32070
 | Europe | 407178
 | North America | 577380
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL* |  | 2427789
Estimated net notional amount outstanding, November 30 weekly snapshot, by product type (millions of USD), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 841597d1693778467-formula-to-calculate-percentage-emmarky-tms
Sheet: Sheet1

Question | Response
A1 | Yes
A2 | yes
A3 | yes
A4 | no
B1 | no
B2 | n/a
B3 | yes
B4 | no
C1 | n/a
C2 | yes
[NAME] | no
C4 | n/a
D1 | yes
D2 | no
D3 | n/a
D4 | yes
Total percentage |  | list in a cell on another sheet | =SUMPRODUCT((IFERROR(MATCH("*"&$A$2:$A$17&"*",Sheet2!$A$2,0),0))*($B$2:$B$17="yes"))/SUM(COUNTIF(B2:B17,{"yes","no"}))
 |  | list in a cell on another sheet referred to by Named [NAME] | =SUMPRODUCT((IFERROR(MATCH("*"&$A$2:$A$17&"*",nrQuestions,0),0))*($B$2:$B$17="yes"))/SUM(COUNTIF(B2:B17,{"yes","no"}))
 |  | static list embedded in formula | =SUMPRODUCT((LEN("A1,A3,B1,B3,C1,C2,C4,D2,D4")<>LEN(SUBSTITUTE("A1,A3,B1,B3,C1,C2,C4,D2,D4",A2:A17,"")))*($B$2:$B$17="yes"))/SUM(COUNTIF(B2:B17,{"yes","no"}))
 |  | static list using Named Value | =SUMPRODUCT((LEN(nvQuestions)<>LEN(SUBSTITUTE(nvQuestions,A2:A17,"")))*($B$2:$B$17="yes"))/SUM(COUNTIF(B2:B17,{"yes","no"}))
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 4

 | October 18 | October 25 | November 1 | November 8 | November 15
Total Interest Rate* | 28893 | 21930 | 32909 | 35658 | 24385
SDs and MSPs** | 13448 | 8267 | 13277 | 13773 | 10361
Other | 15445 | 13663 | 19632 | 21885 | 14024
Total Cross-Currency | 594 | 704 | 1132 | 1722 | 1292
SDs and MSPs | 436 | 444 | 802 | 1115 | 866
Other | 158 | 260 | 330 | 607 | 426
Total Credit | 21230 | 15616 | 15747 | 16225 | 14988
SDs and MSPs | 11740 | 8707 | 8815 | 9221 | 8117
Other | 9490 | 6909 | 6932 | 7004 | 6871
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 50717 | 38250 | 49788 | 53605 | 40665
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*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: phillip_platter__31426__SCH estate
Sheet: NP15

NP15
CounterParty | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
PX - Purchase
PX - Sale
CA Imbalance - Purchase (Decrease Load)
CA Imbalance - Sale (Increase Load)
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
EES |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
buy ees (+)
[NAME]
Sale to EES at DJ Index (-)
Sale to ees at Fixed + 5 (-)
LT SW Buy From Imbalance
LT SW
Load8
Load9
Load10
MEGA
PNM
SC Customer3
SC Customer4
SC Customer5
Daily Trades
Line Losses
NCPA |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
Modesto |  | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 0 | 0
EESI |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | -24.5 | 0 | 0 | 0
PGET |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirant |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Relient |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other NP15 Trade |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total NP15
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: 836373d1689317126-remove-duplicated-in-textjoin-formula-tfs-cr-in-s03-vs-new-wp-and-takt-2023-07-10-example-1-
Sheet: TFS 230710

 | TFS |  |  |  |  | BASELINE |  | Comments to changes |  | SFI |  |  |  |  |  | Oveview
No | ID | Work Item Type | Title 1 | Title 2 | WP | BASELINE TAKT | New WP | Comment Takt | CO level comment | WP started | Released? | PS Responsible |  |  |  | T1 - no split
1 | 196769 | [NAME] | X2 / VT1-2005 / Jumper cable between PH and first coach damaged during operation -PS
2 | 196770 | Task |  | WP133A / Jumper cable between PH and first coach damaged during operation | WP133A | 1 |  | New WP no. | OK | No |  | [NAME]
3 | 198268 | Task |  | 3DX-SRMS / Jumper cable between PH and first coach damaged during operation | 3DX-SRMS
4 | 199668 | Task |  | WP133_PRE / Jumper cable between PH and first coach damaged during operation | WP133_PRE | 6 |  | New WP no. | Jocke skat titta på att införa [NAME] efter sommaren | 2023-05-05 00:00:00 | Yes | [NAME]
5 | 200693 | Task |  | WP133B / Jumper cable between PH and first coach damaged during operation | WP133B | 1 |  | New WP no. | OK | No |  | [NAME]
6 | 200694 | Task |  | WP133C / Jumper cable between PH and first coach damaged during operation | WP133C | 1 |  | New WP no. | OK | No |  | [NAME]
6 | 200947 | Task |  | WP132 / Jumper cable between PH and first coach damaged during operation | WP132 | 1 |  | New WP no. | Ny task skapad 2023-07-13 | No |  | [NAME]
7 | 196823 | [NAME] | Passenger coaches / SJ / Update of retrofit instruction for interior doors (SJ0161) -PS
8 | 196824 | Task |  | WP176 / Update of retrofit instruction for interior doors (SJ0161) | WP176
9 | 198267 | Task |  | 3DX-SRMS / Update of retrofit instruction for interior doors (SJ0161) | 3DX-SRMS
10 | 197077 | [NAME] | URB2 / Swedfix 1833 / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled -PS
11 | 197078 | Task |  | PM4114 / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled | PM4114
12 | 198279 | Task |  | 3DX-SRMS / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled | 3DX-SRMS
13 | 197193 | [NAME] | URB2 / ### / Location of temperature sensor GT10 -PS
14 | 197194 | Task |  | PM4077 / Location of temperature sensor GT10 | PM4077
15 | 198276 | Task |  | 3DX-SRMS / Location of temperature sensor GT10 | 3DX-SRMS
16 | 199243 | Task |  | PM4042 / Location of temperature sensor GT10 | PM4042
17 | 199245 | Task |  | PM4120 / Location of temperature sensor GT10 | PM4120
18 | 199246 | Task |  | PM4139 / Location of temperature sensor GT10 | PM4139
Spreadsheet: 1498d247-ee1a-4ac7-b826-59e169e6bd6d
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
PMS2K | Test | PMS2K | PMS2 Gene, Known Mutation | PMS2 Gene, Known Mutation | Polymerase chain reaction (PCR) followed by DNA sequencing or gene dosage analysis by [NAME] probe amplification (MLPA) of the PMS2 gene is utilized to test for the presence of mutations previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  |  | Varies | [NAME] must arrive within 96 hours of collection.  [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant  [NAME]: 3 mL  Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. [NAME] (Supply T519) 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. | 1 mL | No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Friday; 10 am | 10 days | 16 days | 1 | 81318 |  |  |  |  | Rochester
PMS2K | [NAME] | VARIES | Varies |  |  |  | Ambient
PMS2K | Result | 33625 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
PMS2K | Result | 33626 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PMS2K | Result | 33627 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PMS2K | Result | 33628 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
PMS2K | Result | 33629 | Amendment | Amendment | Alphanumeric
PMS2K | Result | 33630 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
PMS2K | Result | 33631 | Source | Source | Alphanumeric
PMS2K | Result | 33632 | Reviewed By | Reviewed By | Alphanumeric
PMS2K | Result | 33633 | Release Date | Release Date | Alphanumeric
Spreadsheet: 858405d1707121988-options-in-filter-arent-alphabetical-examplenumeric
Sheet: Data

Artikel | Kolom1 | Artikelgroep
4 | A | 700
5 | B | 300
6 | A | 710
7 | A | 564
9 | E | 300
14 | D | 300
16 | C | 300
19 | C | 300
20 | A | 300
21 | D | 850
46 | A | 300
125 | D | 300
62 | F | 564
63 | D | 210
66 | A | 310
72 | D | 564
73 | E | 800
89 | C | 200
97 | C | 100
98 | B | 300
99 | B | 564
100 | D | 710
101 | F | 700
105 | A | 900
106 | D | 120
108 | B | 200
Spreadsheet: 622d9230-f6e0-4c49-bd0f-dda6968017ec
Sheet: 6-Annual Financial Report

 |  |  |  |  |  | Date
District:
School: |  |  |  | Revision
 |  |  |  | Budget Submission #:
 |  |  | Year 1 |  | Year 2
 |  | PROGRAM CATEGORIES | Budget | Actual Expenditures | Budget | Actual Expenditures
 | Support Program
 |  | Salaries (0100)
 |  | Employee Benefits (0200)
 |  | Purchased Professional & Technical Services (0300)
 |  | Other Purchased Services (0500)
 |  | Supplies (0600)
 |  | Other (0800)
 |  | Subtotal Support Program
 |  | Total Support
 |  | INDIRECT
 |  | Indirect Cost Amount Override
 |  | Total Budget
 |  | Typed Name of Person Preparing Report                 Date |  |  | Signature of School District Authorized Representative*
 |  | *Check with your school district budget office for the signature of the school district authorized representative.
Spreadsheet: 848090d1698882204-vlookup-using-left-function-with-array-example
Sheet: Sheet1

List 1 | List 2 | Holding | Forumula column
Fred corporation | Fred corp | 0.1
shane | Shane LTD | 0.15
[NAME] limited liabiltiy partnership | [NAME] | 0.2
 | Chris LTD | 0.05
 | [NAME] | 0.07
Spreadsheet: 713095d1610553694-data-transfer-from-one-worksheet-to-others-golf-group-composite-spreadsheet2
Sheet: Assignment Sheet (2)

 |  | SUNDAY |  | DATE:
 |  | WEDNESDAY
 |  | Team #1 |  | [NAME] | Strokes |  | GAME
 | 1 |  |  |  |  |  |  | Regular Stroke Play
 | 2 |  |  |  |  |  |  | Match Play
 | 3 |  |  |  |  |  |  | Stableford
 | 4 |  |  |  |  |  |  | 2-Man Scramble
 | 5 |  |  |  |  |  |  | 3-Man Scramble
 |  |  |  |  |  |  |  | 4-Man Scramble
 |  | Team #2 |  | [NAME] | Strokes |  | SCORING
 | 1 |  |  |  |  |  |  | 1 Low Score
 | 2 |  |  |  |  |  |  | 2 Low Scores
 | 3 | [NAME] |  |  |  |  |  | 3 Low Scores
 | 4 |  |  |  |  |  | TODAY'S LOCAL RULES
 | 5 |  |  |  |  |  |  | Play ball down (as it lies)
 |  |  |  |  |  |  |  | Lift, clean & place within 1 club length no closer to hole
 |  | Team #3 |  | [NAME] | Strokes |  |  | (only where carts can drive)
 | 1 |  |  |  |  |  |  | Lift, clean & place within 1 club length, no closer to hole
 | 2 |  |  |  |  |  |  | (anywhere on course)
 | 3 |  |  |  |  |  |  | Hole-out all scoring balls
 | 4 |  |  |  |  |  |  | Gimmies length of "your own" foot
 | 5 |  |  |  |  |  | BUNKER PLAY
 |  |  |  |  |  |  |  | Play bunkers as the ball lies
 |  | Team #4 |  | [NAME] | Strokes |  |  | Lift, clean and place within 1 club length, no closer to hole
 | 1 |  |  |  |  |  |  | Remove ball from bunker, no closer to hole
 | 2 |  |  |  |  |  |  | Rake and place within 12 inches of original position
 | 3 |  |  |  |  |  | WILDCARD PLAYER
 | 4 |  |  |  |  |  |  | Charlie for Team #1; [NAME] for Team #2
 | 5 |  |  |  |  |  | OTHER
 |  | Team #5 |  | [NAME] | Get /Give Strokes
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 109738d1306508351-pull-back-first-value-in-array-testfile2xlsx
Sheet: Roles

[NAME] | AO_SSN | A_SSN | O_SSN | NP_O_SSN | NP_O_TIN | Trustee_SSN | [NAME] | JA_Real_To_A | JO_SSN | Plan_Admin_SSN | [NAME] | Transfer_Co_TIN | Transfer_Co_Acct_Num | Assignee_SSN | JO2_SSN | [NAME] | [NAME] | Contingent_Annt | Contingent_Own | Contingent_Own1 | [NAME] | Contingent_Own3 | Contingent_Own4 | 3rd_Party_Cust_TIN | [NAME] | Contact_SSN | [NAME] | Guardian_SSN | Inherited_IRA_SSN | Legal_Rep_SSN | Payee_SSN | Payee_Cont_SSN | [NAME] | POA_SSN | Rep_Estate_SSN
82 | 111111111
83 | 111111111
84 | 111111111
85 |  | 222222222 |  | 555555555
86 |  | 222222222 |  |  | 666666666
87 |  |  | 111111111
88 |  |  | 111111111
89 | 111111111
90 | 111111111
91 |  | 222222222 |  | 555555555
92 | 111111111
93 | 111111111
94 | 111111111
95 |  | 222222222 |  | 555555555
96 |  | 222222222 |  |  | 666666666
97 | 111111111
98 | 111111111
99 | 111111111
100 | 111111111
101 |  | 222222222 |  | 555555555
102 | 111111111
103 |  |  | 111111111
104 |  |  | 111111111
105 |  | 222222222 |  | 555555555
106 |  | 222222222 |  |  | 666666666
107 | 111111111
108 | 111111111
109 | 111111111
110 | 111111111
111 |  | 222222222 |  | 555555555
112 | 111111111
113 | 111111111
114 | 111111111
115 |  | 222222222 |  | 555555555
116 |  | 222222222 |  |  | 666666666
117 | 111111111
118 | 111111111
119 | 111111111
120 | 111111111
121 |  | 222222222 |  | 555555555
122 | 111111111
123 | 111111111
Spreadsheet: 696189d1600695794-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 4

Supplier 4 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-01 00:00:00 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0dca4700-a95c-48e7-8853-96d62f7dc103
Sheet: SGSY Bank details

 | Name of the Bank & Branch associated with SGSY,BSKP & other Scheme
 | Name of G.P | Name Bank with Branch | Phone No.   ( '03462)
 | Khatanga | PBGB, Barachaturi | 228-777
 |  | UBI ,[NAME] | 255-548
 | Nagari | U.C.O. ,[NAME] | 255-743
 |  | U.C.O., Patharchapri | 8016421559
 | [NAME] | Allahabad ,Suri | 255-556
 | [NAME] | PBGB, [NAME] | 255-305
 |  | Union Bank  of India,Suri | 255-719
 |  | Allahabad ,Karidhya | 255-489
 | [NAME] | C.B.I. ,Chota Alunda | 228-202
 |  | PBGB,[NAME] | 255-716
 |  | S.B.I. ,[NAME] | 255-560
 | Mallickpur | PBGB,[NAME] | 255-716
 |  | S.B.I., [NAME] | 255-560
 |  | Allahabad, Karidhya | 255-489
 | Bhurkuna | C.B.I. ,Bhurkuna | 220-032
 |  | C.B.I. ,Kachujore | 220-027
 |  | Bank of India, Suri | 256-229/255-029
Spreadsheet: 79355d1279638047-numerical-date-and-time-dummy_pvt
Sheet: Data

 | Time Allowance | 15
Consignee Code | Appointment ID | Scheduled Start Time | Gate In Time | [NAME] | [NAME] | Late Truck
8L | 2821464 | 06/01/10 08:00 AM | 06/01/10 08:15 AM | 0.01041666666424135 | 0 hour(s) 15 min(s) Late | 1 |  | FORMULA HERE BASED
8L | 2823934 | 06/03/10 06:00 AM | 06/03/10 05:12 AM | -0.03333333333284827 | 0 hour(s) 48 min(s)  Early | 0 |  | ON TIME ALLOWANCE AND
8L | 2813096 | 06/04/10 02:00 PM | 06/07/10 09:21 AM | 2.806249999994179 | 67 hour(s) 21 min(s) Late | 1 |  | NUM VAR
8L | 2837796 | 06/06/10 10:00 AM | 06/07/10 09:20 AM | 0.9722222222262644 | 23 hour(s) 20 min(s) Late | 1
8L | 2837804 | 06/06/10 10:00 AM | 06/07/10 09:20 AM | 0.9722222222262644 | 23 hour(s) 20 min(s) Late | 1 |  | IF TRUCK IS EARLY OR WITHIN
8L | 2837810 | 06/06/10 10:00 AM | 06/07/10 09:19 AM | 0.9715277777795563 | 23 hour(s) 19 min(s) Late | 1 |  | TIME ALLOWANCE,
8L | 2788852 | 06/07/10 06:00 AM | 06/08/10 12:52 PM | 1.286111111112405 | 30 hour(s) 52 min(s) Late | 1 |  | LATE TRUCK = 0
8L | 2788852 | 06/07/10 06:00 AM | 06/08/10 12:52 PM | 1.286111111112405 | 30 hour(s) 52 min(s) Late | 1 |  | IF NUM VAR GREATER THAN
8L | 2795328 | 06/07/10 06:00 AM | 06/08/10 12:53 PM | 1.286805555559113 | 30 hour(s) 53 min(s) Late | 1 |  | ALLOWANCE LATE TRUCK  = 1
8L | 2805321 | 06/07/10 06:00 AM | 06/07/10 06:14 AM | 0.00972222222480923 | 0 hour(s) 14 min(s) Late | 0
8L | 2806544 | 06/07/10 06:00 AM | 06/07/10 06:09 AM | 0.006249999998544808 | 0 hour(s) 9 min(s) Late | 0
8L | 2808466 | 06/07/10 06:00 AM | 06/07/10 08:18 AM | 0.09583333333284827 | 2 hour(s) 18 min(s) Late | 1
8L | 2816435 | 06/07/10 06:00 AM | 06/08/10 12:55 PM | 1.288194444445253 | 30 hour(s) 55 min(s) Late | 1