tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 825278d1681222483-need-help-to-get-the-date-wise-count-for-each-item-company-wise-need-help-to-get-the-date-wise-count-for-each-item-company-wise
Sheet: Sheet1

Name of the company | Items | Orders | Updated Date orders as on
ABC Company | Light Bulb | 7 | 2023-04-01 00:00:00
ABC Company | Fan | 5 | 2023-04-01 00:00:00
ABC Company | Regulators | 8 | 2023-04-01 00:00:00
ABC Company | Tubelight | 15 | 2023-04-01 00:00:00
DEF Company Ltd | Regulators | 12 | 2023-04-02 00:00:00
ABC Company | Fan | 8 | 2023-04-02 00:00:00 |  | (8 includes the order of 01-04-2023 also so for 02-04-2023 order is for 3 only which gets reflected in D16)
DEF Company Ltd | Electric Cooker | 4 | 2023-04-02 00:00:00
ABC Company | Tubelight | 18 | 2023-04-02 00:00:00 |  | (18 includes the order of 01-04-2023 also so for 02-04-2023 order is for 3 only which gets reflected in D18)
DEF Company Ltd | LED Lighting | 5 | 2023-04-02 00:00:00
ABC Company | Fan | 12 | 2023-04-03 00:00:00
This is a old record which has been assigned to our department. In all there could be 800 lines of items for the month. This is just a sample data.
I need the formula for all the the columns as any new company can be added during the month
This is monthly record statemen
Answer I would like to have in formula for all the rows and columns |  |  |  |  |  | Sum of Orders |  | Updated Date orders as on
Name of the Company | Items | 2023-04-01 00:00:00 | 2023-04-02 00:00:00 | 2023-04-03 00:00:00 |  | Name of the company | Items | 2023-04-01 00:00:00 | 2023-04-02 00:00:00 | 2023-04-03 00:00:00
ABC Company | Light [NAME] | 7 |  |  |  | ABC Company | Fan | 5 | 8 | 12
ABC Company | Fans | 5 | 3 | 4 |  | ABC Company | Light Bulb | 7
ABC Company | Regulators | 8 |  |  |  | ABC Company | Regulators | 8
ABC Company | Tubelights | 15 | 3 | 3 |  | ABC Company | Tubelight | 15 | 18
DEF Company Ltd | Regulators |  | 12 | 12 |  | DEF Company Ltd | Electric Cooker |  | 4
DEF Company Ltd | Electric Cookers |  | 4 | 4 |  | DEF Company Ltd | LED Lighting |  | 5
DEF Company Ltd | LED Lighting |  | 5 | 5 |  | DEF Company Ltd | Regulators |  | 12
Spreadsheet: debra_perlingiere__8423__e prime Energy Marketing Master Firm 10192001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-10-19 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | e prime Energy Marketing, Inc. | CONTACT:
ADDRESS: | 1099 18th Street, Suite 3000 | TITLE:
 | Denver, CO 80202 | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENRON ENTITY
COLLATERAL
THRESHOLD  in $ | 2500000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Xcel Energy Inc. | Enron Corp. (BBB+) | NOTE:  See Comment 1 below
LIMIT in $[NAME] | $10 MM | $30 MM
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = | BBB- (Standard & Poor's) | BBB- (Standard & Poor's)
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty
-Guarantor ($[NAME]) | 50000000 | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:  X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS | 1.  Cross-commodity guarantee being negotiated by [NAME] to cover financial and physical
 | trading between e prime Energy Marketing and Enron North America.  [NAME] amount to be $10 MM.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 99575d1298192652-return-first-and-last-date-with-data-start-and-end-date
Sheet: Sheet1

 | Summary | Start Date | End Date
 | Site Prep
 | Construction
 | Testing
 | Cashflow | 2011-01-01 00:00:00
 | Site Prep | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0
 | Construction | 0 | 0 | 100 | 100 | 100 | 0 | 20 | 0
 | Testing | 0 | 0 | 0 | 100 | 100 | 0 | 50 | 0
Spreadsheet: 2c132761-05b9-4b46-99a4-2c7a9beec818
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 8/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2011/12 | Q1 Sep-Nov | 46.3646974401961 | 1.125526280695738 | -0.04739860166504735 | 0.3396545983846662 | 47.78247971761145 | -0.4626915634516938 | 47.31978815415976
 | [NAME] | 39.17974509915986 | 0.1432626545503038 | 0.2699564823357473 | 0.2214356928307892 | 39.8143999288767 | 1.183849204081244 | 40.99824913295794
 | [NAME] | 21.69583357146939 | 0.3902129253903844 | 0.02769454355440525 | 0.2170485461906847 | 22.33078958660487 | -1.91839689525007 | 20.4123926913548
 | [NAME] | 8.229626666158644 | 0.1344738463101611 | 0.9843320079360544 | 0.7427577153815939 | 10.09119023578645 | 11.68532292610706 | 21.77651316189352
 | MY Sep-Aug | 115.469902776984 | 1.793475706946588 | 1.23458443216116 | 1.520896552787734 | 120.0188594688795 | 10.48808367148654 | 130.506943140366 | 92.93205345835372 | 1.404326475997337
2012/13 | Q1 Sep-Nov | 52.52519479529824 | 1.930083252367072 | 0.06856141324907399 | 0.372022959037876 | 54.89586241995227 | -0.8559562591682384 | 54.03990616078403
 | [NAME] | 27.32570027877795 | 0.03619668133584805 | 0.2062503231846548 | 0.3402923494367741 | 27.90843963273523 | 0.2597724235719321 | 28.16821205630716
 | [NAME] | 23.47589745543681 | 0.3363116216748269 | 0.03446577236369772 | 0.2225950752555312 | 24.06926992473086 | -0.4645150052934245 | 23.60475491943744
 | MY Sep-Aug | 113.0352504873851 | 2.33690854940212 | 1.824639325925261 | 1.558418631402571 | 118.7552169941151 | 8.657348062388927 | 127.412565056504 | 92.40687412 | 1.378821286509978
2013/14 | MY Sep-Aug | 129.5460174125088 | 1.905088491360424 | 0.9975609424200613 | 1.587620179441355 | 134.0362870257307 | 4.978350030073184 | 139.0146370558039 | 92.334426 | 1.505555869874621
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 8/13/2013
Spreadsheet: 59676d1260266946-extraxt-missing-data-2-column-extract-missing-value
Sheet: Sheet1

 | MASTER | RESULT MONTH -1 |  | MISSING VALUES IN COL C COMPARING WITH COL B
 | 1 | 1 |  | 32 | 0
 | 2 | 2 |  | 0 | 0
 | 3 | 3 |  | 0 | 0
 | 4 | 4 |  | 0 | 0
 | 5 | 5 |  | 0 | 0
 | 6 | 6 |  | 0 | 0
 | 7 | 7 |  | 0 | 0
 | 8 | 8 |  | 0 | 0
 | 9 | 9 |  | 0 | 0
 | 10 | 10 |  | 0 | 0
 | 11 | 11
 | 12 | 12
 | 13 | 13
 | 14 | 14
 | 15 | 15
 | 16 | 16
 | 17 | 17
 | 18 | 18
 | 19 | 19
 | 20 | 20
 | 21 | 21
 | 22 | 22
 | 23 | 23
 | 24 | 24
 | 25 | 25
 | 26 | 26
 | 27 | 27
 | 28 | 28
 | 29 | 29
 | 30 | 30
 | 31 | 31
 | 32
Spreadsheet: 777588d1650486561-adding-up-decimals-that-equal-minutes-rhanz
Sheet: Sheet1

Decimal Value |  | Hours/Minutes
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
Spreadsheet: 880813d1728656303-sign-in-out-sheet-help-sign-in-book_2
Sheet: Form Responses

Id | Start time | Completion time | [NAME] | Name | Are you: | Name1 | Question | Question1 | Full Name | Company | Visiting (Name of Host) | Vehicle Registration | Full Name1 |  | last | in | out | now
17 | 2024-10-07 08:24:46 | 2024-10-07 08:24:53 | anonymous |  | Staff | [NAME], [NAME] | In
18 | 2024-10-07 11:53:35 | 2024-10-07 11:53:42 | anonymous |  | Staff | [NAME], [NAME] | Out |  |  |  |  |  |  |  | Winters, [NAME]
19 | 2024-10-08 08:42:48 | 2024-10-08 08:42:55 | anonymous |  | Staff | [NAME], [NAME] | In
20 | 2024-10-08 09:36:41 | 2024-10-08 09:37:04 | anonymous |  | Staff | Winters, [NAME] | In
21 | 2024-10-08 12:09:20 | 2024-10-08 12:09:34 | anonymous |  | Staff | [NAME], [NAME] | Out
22 | 2024-10-08 12:09:35 | 2024-10-08 12:09:49 | anonymous |  | Staff | [NAME], [NAME] | Out
23 | 2024-10-08 13:15:20 | 2024-10-08 13:15:31 | anonymous |  | Staff | Winters, [NAME] | Out
24 | 2024-10-09 08:31:03 | 2024-10-09 08:31:14 | anonymous |  | Staff | [NAME], [NAME] | In
25 | 2024-10-09 09:32:16 | 2024-10-09 09:32:26 | anonymous |  | Staff | Winters, [NAME] | In
26 | 2024-10-09 11:58:17 | 2024-10-09 11:58:32 | anonymous |  | Staff | [NAME], [NAME] | Out
27 | 2024-10-09 13:26:50 | 2024-10-09 13:27:01 | anonymous |  | Staff | Winters, [NAME] | Out
28 | 2024-10-10 08:28:09 | 2024-10-10 08:28:23 | anonymous |  | Staff | [NAME], [NAME] | In
29 | 2024-10-10 09:09:36 | 2024-10-10 09:10:07 | anonymous |  | Staff | Winters, [NAME] | In
30 | 2024-10-10 12:08:48 | 2024-10-10 12:08:56 | anonymous |  | Staff | [NAME], [NAME] | Out
31 | 2024-10-10 12:29:43 | 2024-10-10 12:29:51 | anonymous |  | Staff | Winters, [NAME] | Out
32 | 2024-10-11 08:29:21 | 2024-10-11 08:29:32 | anonymous |  | Staff | [NAME], [NAME] | In
Spreadsheet: richard_shapiro__32634__MR-List 91801
Sheet: Sheet1

LAST | FIRST | POSITION | STATE | CONTACT | COMMENTS
Hochstetter | [NAME] | Chair | AK
[NAME] | Mack | State Rep. | AL
[NAME] | [NAME] | Governor's office | AL
[NAME] | [NAME] | President | AL
Baez | Bruilio | Commissioner | FL
Jacobs, Jr. | [NAME] | Chair | FL
McDonald, Jr. | Lauren "Bubba" | Commissioner | GA
Wise | [NAME] | Chair | GA
[NAME] | Irma | Chair | LA
Field | [NAME] | Commissioner | LA
Rider | [NAME] | Governor's office | LA
[NAME] | [NAME] | Governor's office | MS
Ellis | Tyrone | State Rep. | MS
[NAME] | [NAME] | State Senator | MS
Ervin, IV | [NAME] | Commissioner | NC
[NAME] | [NAME] | Chair | NC
Bradley | [NAME] | Commissioner | SC
Savndard | [NAME] | Chair | SC
Spreadsheet: 45607d1244416151-using-if-and-offset-formula-math-point
Sheet: table

 |  |  |  |  |  |  |  |  | J |  |  |  |  |  |  |  | R |  | T |  |  |  |  |  |  |  | AB
 |  |  | Level | Point | Learning Gain Point |  |  |  | Reading |  |  |  |  |  |  |  |  |  | Math
 |  |  | 3 | 1 | 1 |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | level |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | level
 |  |  |  |  |  |  |  |  | 86 | 295 | 474 | 539 | 671 | 886 | 772 | 844 | 1 |  | 375 | 581 | 569 | 770 | 958 | 1025 | 1238 | 1068 | 1
 |  |  |  |  |  |  |  |  | 1046 | 1315 | 1342 | 1450 | 1542 | 1696 | 1772 | 1852 | 2 |  | 1079 | 1277 | 1452 | 1554 | 1661 | 1733 | 1782 | 1832 | 2
 |  |  |  |  |  |  |  |  | 1198 | 1456 | 1510 | 1622 | 1715 | 1882 | 1972 | 2068 | 3 |  | 1269 | 1444 | 1632 | 1692 | 1786 | 1851 | 1901 | 1947 | 3
 |  |  |  |  |  |  |  |  | 1489 | 1690 | 1762 | 1860 | 1945 | 2073 | 2146 | 2219 | 4 |  | 1509 | 1658 | 1769 | 1860 | 1939 | 1998 | 2023 | 2050 | 4
 |  |  |  |  |  |  |  |  | 1866 | 1965 | 2059 | 2126 | 2181 | 2282 | 2298 | 2311 | 5 |  | 1750 | 1863 | 1957 | 2019 | 2080 | 2092 | 2142 | 2193 | 5
 |  |  |  |  |  |  |  |  | column | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | column | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  |  |  | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 |  |  | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 |  |  |  |  |  |  |  | I |  | K |  |  |  |  |  |  |  | S |  | U
 |  |  |  |  |  |  |  | Cut-Off Minimums for Learning Gains |  |  |  |  |  |  |  |  |  | Cut-Off Minimums for Learning  Gains
 |  |  |  |  |  |  |  |  | Read | Math |  |  |  |  |  |  |  |  | Read | Math
 |  |  |  |  |  |  |  | 4 | 231 | 163 |  |  |  |  |  |  |  | 4 | 231 | 163
 |  |  |  |  |  |  |  | 5 | 167 | 120 |  |  |  |  |  |  |  | 5 | 167 | 120
 |  |  |  |  |  |  |  | 6 | 134 | 96 |  |  |  |  |  |  |  | 6 | 134 | 96
 |  |  |  |  |  |  |  | 7 | 111 | 79 |  |  |  |  |  |  |  | 7 | 111 | 79
 |  |  |  |  |  |  |  | 8 | 93 | 65 |  |  |  |  |  |  |  | 8 | 93 | 65
 |  |  |  |  |  |  |  | 9 | 78 | 55 |  |  |  |  |  |  |  | 9 | 78 | 55
 |  |  |  |  |  |  |  | 10 | 78 | 49 |  |  |  |  |  |  |  | 10 | 78 | 49
 |  |  |  |  |  |  |  |  | grade | offset |  |  |  |  |  |  |  |  | grade | offset
 |  |  |  |  |  |  |  |  | 3 | 9 | T65 |  |  |  |  |  |  |  | 3 | 9 | AD65
 |  |  |  |  |  |  |  |  | 4 | 8 | U65 |  |  |  |  |  |  |  | 4 | 8 | AE65
 |  |  |  |  |  |  |  |  | 5 | 7 | V65 |  |  |  |  |  |  |  | 5 | 7 | AF65
 |  |  |  |  |  |  |  |  | 6 | 6 | W65 |  |  |  |  |  |  |  | 6 | 6 | AG65
 |  |  |  |  |  |  |  |  | 7 | 5 | X65 |  |  |  |  |  |  |  | 7 | 5 | AH65
 |  |  |  |  |  |  |  |  | 8 | 4 | Y65 |  |  |  |  |  |  |  | 8 | 4 | AI65
 |  |  |  |  |  |  |  |  | 9 | 3 | Z65 |  |  |  |  |  |  |  | 9 | 3 | AJ65
 |  |  |  |  |  |  |  |  | 10 | 2 | AA65 |  |  |  |  |  |  |  | 10 | 2 | AK65
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb10-Feb16p

Pavilion
 | 2013-02-10 00:00:00 |  |  | Thru | 2013-02-16 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 191202d1351967817-swapping-colums-and-rows-here-is-one-way100
Sheet: Sheet1

From
 | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | wk 7
Site A | 3 | 4 | 5 | 6 | 7 | 8 | ETC ETC
Site B | 8 | 9 | 10 | 11 | 12 | 13 | hh
Site C | 8 | 9 | 10 | 11 | 12 | 13 | bb
Site D | 8 | 9 | 10 | 11 | 12 | 13 | bbbbb
Site E | 8 | 9 | 10 | 11 | 12 | 13 | nnn
To
Wk 1 | Site A | 3
Wk 2 | Site A | 4
Wk 3 | Site A | 5
Wk 4 | Site A | 6
Wk 5 | Site A | 7
Wk 6 | Site A | 8
wk 7 | Site A | ETC ETC
Wk 1 | Site B | 8
Wk 2 | Site B | 9
Wk 3 | Site B | 10
Wk 4 | Site B | 11
Wk 5 | Site B | 12
Wk 6 | Site B | 13
wk 7 | Site B | hh
Wk 1 | Site C | 8
Wk 2 | Site C | 9
Wk 3 | Site C | 10
Wk 4 | Site C | 11
Wk 5 | Site C | 12
Wk 6 | Site C | 13
wk 7 | Site C | bb
Wk 1 | Site D | 8
Wk 2 | Site D | 9
Wk 3 | Site D | 10
Wk 4 | Site D | 11
Wk 5 | Site D | 12
Wk 6 | Site D | 13
wk 7 | Site D | bbbbb
Wk 1 | Site E | 8
Wk 2 | Site E | 9
Wk 3 | Site E | 10
Wk 4 | Site E | 11
Wk 5 | Site E | 12
Wk 6 | Site E | 13
wk 7 | Site E | nnn
Wk 1 | #N/A | #N/A
Wk 2 | #N/A | #N/A
Wk 3 | #N/A | #N/A
Wk 4 | #N/A | #N/A
Wk 5 | #N/A | #N/A
Spreadsheet: 855502d1705046434-monthly-and-quarterly-records-to-be-replicated-1eagle-tracker-16122023
Sheet: Data

Key | Task | Company | Plant/PrCtr | Frequency | Importance | Period | Due/Cut-off Date | Owner | Manager | Rem1 | Rem2 | Esc1 | Esc2 | Esc1 mail [NAME] | Esc2 mail [NAME]
1 | 80 IA Final working and form 10 CCB preparation | GE | WD-MH (17) PC - Dhule 350001 | Yearly | Medium | 1 | 31st May | XYZ | XYZ | -14 | -7 | 5 | 30 | abc@123 | abc@123
2 | 80 IA Final working and form 10 CCB preparation | GE | WD-MH (17) PC - Dhule 350001 | Monthly | Medium | 1 | 31st May | XYZ | XYZ | -14 | -7 | 5 | 30 | abc@123 | abc@123
3 | 80 IA Final working and form 10 CCB preparation | GE | WD-MH (17) PC - Dhule 350001 | Quarterly | Medium | 1 | 31st May | XYZ | XYZ | -14 | -7 | 5 | 30 | abc@123 | abc@123
4 | Advance tax working | GE | WD-MH (17) PC - Dhule 350001 | Yearly | Medium | 3 | 15th of the end of each quarter | XYZ | XYZ | -6 | -3 | 5 | 30 | abc@123 | abc@123
5 | Advance tax working | GE | WD-MH (17) PC - Dhule 350001 | Monthly | Medium | 3 | 15th of the end of each quarter | XYZ | XYZ | -6 | -3 | 5 | 30 | abc@123 | abc@123
6 | Advance tax working | GE | WD-MH (17) PC - Dhule 350001 | Quarterly | Medium | 3 | 15th of the end of each quarter | XYZ | XYZ | -6 | -3 | 5 | 30 | abc@123 | abc@123
Spreadsheet: 740169d1626205965-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues-1-
Sheet: Sheet4

ID | Client | Date of Meeting | Units | Meeting Type | Duration | Entered | Counselor
91966 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
88341 | Amber Riley | In Person |  |  | 30 mins |  | [NAME]
33848 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME]
23739 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
43135 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
25826 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
80559 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
47064 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
84667 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
20382 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
50915 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
68065 | Cooper Manning | In Person |  |  | 60 mins |  | [NAME]
67507 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
33733 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
39903 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon
36003 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
99670 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
25465 | [NAME] | In Person |  |  | 30 mins |  | [NAME]
53132 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME]
28902 | Eddie Izzard | In Person |  |  | 60 mins |  | [NAME]
26732 | Eli Manning | Over the Phone |  |  | 60 mins |  | [NAME]
23030 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
75022 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
97961 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
64035 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
94388 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
31467 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
25339 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
36788 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME]
17279 | [NAME] | In Person |  |  | 45 mins |  | [NAME]
50337 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
66334 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
62503 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon
87608 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
64761 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
99567 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
80934 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME]
65131 | [NAME] | In Person |  |  | 45 mins |  | [NAME]
24935 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
55156 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
40011 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
96790 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
71048 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
52278 | [NAME] | In Person |  |  | 30 mins |  | [NAME]
46668 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME]
34486 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
84325 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
28777 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
72276 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
Spreadsheet: 759348d1639500130-populating-cell-with-value-if-another-cell-contains-a-fractional-value-corian_pricing_tool
Sheet: Pricing Tool

 |  | Studio / Supplier
 |  | Project / Customer Reference
 |  | Manufacturer |  |  | Corian
 |  | Finish
 |  | Price Group
 |  | Sheet Price in £ plus VAT
 |  | Slab Size
 |  |  |  |  |  |  |  |  | Template, Fabrication & Install |  | 650
 |  | [NAME] (in hours) |  |  |  |  |  |  | [NAME] in £
 |  | Number of Sheets* |  |  |  |  |  |  | Sheet Charge in £
 |  | Materials (in £ plus VAT) |  |  |  |  |  |  | Material Charge in £
 |  |  |  |  |  |  |  |  | Sink Charge in £
 |  | Upstands? |  | No | <<-- Add these to LABOUR VALUE |  |  |  | Waste Charge in £
 |  | Coved? |  | No | <<-- Add these to LABOUR VALUE |  |  |  | Partial Sheet Cut Surcharge |  |  | <<-- Add Manually
 |  |  |  |  |  |  |  |  | [NAME] in £
 |  | Sink |  |  |  |  |  |  | Project Total (plus VAT)
 |  | Sink Model (Primary) |  | NONE |  | Cost
 |  | Sink Model (Secondary) |  | NONE |  | Cost
 |  | Sink Waste Fitting |  |  |  | <<--Displays on MISC VALUE |  |  | *PLEASE NOTE - HALF SHEET IS .5, THIRD SHEET IS .33 ETC
 |  | Other Misc Costs |  |  |  | <<--Displays on MISC VALUE
 |  | Cut Details
 |  | Polished Sink Cutout |  | Select | Hob Cutout | Select | Tap Hole | Select
 |  | Unpolished Sink Cuout |  | Select | [NAME] | Select | Radial Cuts | Select
 |  | Further Cutting Notes
 |  | Upstand Information Here:
 |  | Lit Waste/Overflows Here:
 |  | Project Notes/Layout Details
Spreadsheet: 3654d108-377c-42f8-9780-17af142481c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Clinical information on SFT and DTF
 | SFT samples
 | STT | location | [NAME] (cm) | pt sex | pt age
 | 200 | liver | 18 | male | 48
 | 597 | mediastinum | 8.5 | female | 75
 | 626 | right chest
 | 675 | parapharyngeal space
 | 1079 | left lung | 3 | male | 64
 | 1637 | left upper lobe lung | 10 | female | 53
 | 1771 | left lower lobe lung | 3.5 | male | 64
 | 1966 | pre-sacrum | 7 | male | 60
 | 2770 | pleura of left lower lobe | 1.8 | male | 53
 | 2772 | right lower lobe | 1.4 | male | 72
 | 2774 | mediastinum | 15 | male | 57
 | 2775 | right pleura | 22 | female | 52
 | 2776 | visceral pleura | 8 | male | 70
 | DTF samples
 | STT | location | [NAME] (cm) | pt sex | pt age | B-catenin mutation status
 | 1968 | sacrum | 7 | female | 32 | exon 3 point mutation S45F
 | 1969 | right knee | 9 | female | 21 | wildtype exon 3
 | 1986 | small bowel | 8.5 | male | 53 | wildtype exon 3
 | 1987 | abdominal wall | 6 | female | 32 | exon 3 point mutation S45F
 | 3119 | popliteal soft tissue | 9 | female | 21 | exon 3 point mutation T41A
 | 3120 | sacral soft tissue | 7 | female | 32 | exon 3 point mutation T41A
 | 3121 | mediastinum | 21 | male | 52 | exon 3 point mutation T41A
 | 3122 | left chest wall | 7.5 | female | 70 | exon 3 point mutation T41A
 | 3123 | lumbar soft tissue | 19 | female | 48 | exon 3 point mutation T41A
 | 3124 | left forearm | 4 | female | 26 | exon 3 point mutation S45P
 | 3125 | right upper arm | 8 | male | 58
 | 1777 | right posterior calf | 15 | male | 45
Spreadsheet: andy_zipper__753__10_23_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 200 | 300 | 46 | 69.1 | 2.17 | 2001-10-23 10:25:00
 | [NAME] | 60 | 660 | 760 | 44.7 | 51.5 | 1.81 | 2001-10-23 10:25:00
 | HU F2 | 61 | 900 | 1000 | 44.5 | 49.5 | 1.8 | 2001-10-23 10:25:00
 | HU G2 | 62 | 1030 | 1130 | 40.9 | 44.9 | 1.67 | 2001-10-23 10:25:00
 | [NAME] | 63 | 1140 | 1240 | 39.4 | 42.8 | 1.63 | 2001-10-23 10:25:00
 | [NAME] | 68 | 1325 | 1425 | 38.4 | 41.4 | 1.71 | 2001-10-23 10:25:00
 | [NAME] | 69 | 1425 | 1550 | 37.3 | 40.7 | 1.69 | 2001-10-23 10:25:00
 | [NAME] | 68 | 1475 | 1625 | 36.3 | 40 | 1.63 | 2001-10-23 10:25:00
 | HU N2 | 68 | 1500 | 1700 | 34.8 | 39.5 | 1.59 | 2001-10-23 10:25:00
 | [NAME] |  |  |  | 33.4 | 37.9 | 1.5 | 2001-10-22 14:23:00
 | HU U2 |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]