tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33774__overview of doorstep status for execs
Sheet: Sheet1

 |  |  |  |  |  | Current status
Office |  | Rating | Common findings of office as listed in presentation to JS | Rating |  | Number of observations | Closed observations | Open observations with target date after 9/12/00 | Global issues not yet cleared - missed target date | Open observations having missed target date | Pulp and paper comments not yet completed as trading not commenced | Item that missed target date or any global issues not yet cleared (whether or not they are past target date or not)
[NAME] | Feb. 16-18 | 1 red, 8 yellow, 1 green | 1, 2, 3, 5, 6 | B |  | 10 | 9 |  |  | 1 |  | Finalization of translation of open contracts (backlog)
Calgary | May 9-12 | 5 red, 4 yellow | 1, 2 5, 6 | C |  | 9 | 6 | 3 |  |  |  | Enpower (installation in process), management of fx risks
Frankfurt | Feb. 24-25 | 1 red, 9 yellow | 1, 2, 5 | B |  | 10 | 10
[NAME] I (a) | April 10-14 | 3 red, 19 yellow | 1, 2, 3, 4, 5, 6 | B-, C+ |  | 22 | 7 | 9 | 2 | 4 |  | Global - Use of mobile phones to make trades, Enpower needs to be enhanced for continental power.   Non global that missed target date - procedures established to ensure deals maintained outside main deal database are captured in credit agg, review of standalone models, confirmation process slowed by credit and legal, lack of mater agreements in place.
London Phase II (b) | May 23 - June 2 | 9 red, 17 yellow | 1, 2, 3, 5, 6 | C |  | 26 |  | 5 | 1 |  | 6 | Global - Hedging and fx issues, Others - pulp and paper issues have not been addressed as trading is not planned for the near future in London.
Oslo | Feb 21-23 | 2 red, 7 yellow | 1, 5, 6 | [NAME] |  | 9 | 7 | 1 |  | 1 |  | Tracking and monitoring fx exposures
Panama City | 2000-05-18 00:00:00 | 1 red, 8 yellow | 1, 4, 5, 6 | F |  | 9 | 0* | 3 |  | 6 |  | Commercial lines not taped
Sao Paulo | Feb 14-15 | 2 red, 5 yellow | 2, 4, 5, 6 | B |  | 7 | 4 | 3 |  |  |  | Commercial lines not taped
Seoul | April 3-7 | 6 yellow | 4 | C |  | 5 | No target dates have been specified.
Singapore | March 1-3 | 4 red, 2 yellow | 1, 2, 4, 5 | C |  | 6 | 5 |  | 1 |  |  | Use of mobile phones to make trades.
Sydney | Feb. 28-29 | 2 red, 4 yellow | 1, 2, 3, 5, 6 | B |  | 6 | 6
* This report was received at the end of August, which attributes to this low number.
Definitions:
Red | Item extremely high priority. Should be cleared immediately.
Yellow | Key issue which does not violate a global standard.
Green | Finding that represents a weakness, and should be cleared, but not a key issue.
Common findings
1 | Ineffective segregation of duties
2 | Capture of positions not timely or complete
3 | Systems implementation issue:  Control requirements vs. critical mass
4 | Phone lines not taped and use of cell phones for trading
5 | Inconsistent operational practices across commodities and locations
6 | Lack of process for creating operational controls for new commodities/businesses
Spreadsheet: 1ac5522d-f4a7-4199-83e9-fee4f6942204
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-12-01 09:38:25.260000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.814 | 101.689 | 101.564 | 101.189 |  | and are added to price quote
4.375 | 101.321 | 101.196 | 101.071 | 100.696
4.25 | 100.576 | 100.451 | 100.326 | 99.951 |  | Note: | Refer To Price [NAME]
4.125 | 100.09 | 99.965 | 99.84 | 99.465 |  |  | For all Price Adjs
4 | 99.635 | 99.51 | 99.385 | 98.76
3.875 | 99.061 | 98.936 | 98.811 | 98.186
3.75 | 98.19 | 98.065 | 97.94 | 97.315
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.311 | 101.186 | 101.061 | 100.686
3.75 | 100.779 | 100.654 | 100.529 | 100.154
3.625 | 100.382 | 100.257 | 100.132 | 99.757
3.5 | 100.048 | 99.923 | 99.798 | 99.423
3.375 | 99.655 | 99.53 | 99.405 | 98.78
3.25 | 99.064 | 98.939 | 98.814 | 98.189
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-12-15 09:38:25.260000
30 DAY | 2011-12-30 09:38:25.260000
45 DAY | 2012-01-14 09:38:25.260000
60 DAY | 2012-01-29 09:38:25.260000
90 DAY | 2012-02-28 09:38:25.260000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 039c31df-1f25-44f6-9a60-f5835a48a710
Sheet: Sheet1

North American Association of Central Cancer Registries
2012 ANNUAL CONFERENCE
NCRA Event Number  2012-066
It is your responsibility to document the session that you attended.
Please keep this form for your credential submission.
Name: |  |  | Total Hours:
 | TOPIC | SPEAKER | CE HOURS APPROVED | HOURS ATTENDED
2012-06-05 00:00:00 | Conference Day 1, Tuesday
08:30:00 | Plenary Session 1: NAACCR 25th Anniversary: Past, Present, & Future |  | 1.5
 | Historical Perspectives of Cancer Surveillance in North America; 25 Years of Progress | [NAME], MD, MPH
 | International perspectives of Cancer Registration: Global Initiatives & Future Directions | [NAME], PhD
10:30:00 | Plenary Session 2: Bridges to the Future: Communicating Cancer Surveillance Data |  | 1.5
 | Making Cancer Survival Statistics More Relevant for Clinicans, Patients, and the General Public | [NAME], PhD
 | Improving the Social Impact of Cancer Registry Data Through Infographic Thinking | [NAME], PhD; [NAME], PhD; Heather Corcoran, MFA
13:30:00 | Concurrent Session 1 |  | 1.5
15:30:00 | Concurrent Session 2 |  | 1.5
2012-06-06 00:00:00 | Conference Day 2, Wednesday
09:00:00 | Plenary Session 3: Bridgest to the Future: Collecting Clinically Relevant Data |  | 1.5
 | Creation of CCOs in Oregon: Plans and Progress | [NAME], MPH
 | National System Performance Reporting | [NAME], MD, PhD, CCFP, FRCPC
10:45:00 | Concurrent Session 3 |  | 1.5
2012-06-07 00:00:00 | Conference Day 3, Thursday
08:00:00 | Birds of a Feather: Information Overload - Any Way Out? | [NAME]; [NAME] | 1
09:00:00 | Plenary Session 4: Deliberations on the Future of Collaborative Stage |  | 1
 | Update: CS Summit Data Element Review Workgroup | [NAME], PhD
 | Update: CS Summit Evaluation & Simplification Workgroup | [NAME]
 | Concept Development: CS Lite | [NAME]; [NAME]
 | Results from CSv2 Reliability Study | [NAME]; [NAME]
10:15:00 | Concurrent Session 4 |  | 1.5
12:45:00 | Plenary Session 5: Future of Collaborative Stage: Interactive Panel Discussion |  | 1
14:00:00 | Concurrent Session 5 |  | 1.5
15:45:00 | NAACCR Showcase |  | 0.75
 | NAACCR Geocoder | [NAME]
 | Using NAACCR Data to Identify Cancer Disparities | [NAME]
Total Hours |  |  | 15.75
Spreadsheet: 699145d1602430799-index-match-3-criterion-match-return-value-question-book1-22_1
Sheet: Template

 |  | File | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account |  |  | index | [NAME] |  |  |  | aggregate
 |  | 913145138 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009004870
 |  | 912472516 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009004870 |  |  |  |  |  |  |  |  | 648.31
 |  | 913179271 | BAT MAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016003790 |  |  |  |  |  |  |  |  | 51.59
 |  | 913530576 | BRUCE WAYNE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018003244 |  |  |  |  |  |  |  |  | 6438.5
Spreadsheet: 238cf069-b63e-49ab-92cc-f50dc15e6857
Sheet: Sheet1

FINANCIAL REPORTS | Unnamed: 1
MEUR (except stated otherwise) | Q2 2011
Income statement | Apr-Jun 11
Revenue | 226.7
EBITDAR | 73.6
EBITDA | 14.8
EBIT | 7.0
Financial income & expense, net | -0.5
Income tax | -1.8
Profit/loss for the year | 4.7
Balance sheet | 2011-06-30 00:00:00
Balance sheet total | 384.7
Total equity attributable to equity holders of the parent | 161.2
Cash flow | Apr-Jun 11
Cash flow from operating activities | -20.1
Cash flow from investing activities | -14.4
Cash flow from financing activities | 14.9
Financial key figures | Apr-Jun 11
EBITDAR Margin, % | 0.325
EBITDA Margin, % | 0.065
EBIT Margin, % | 0.031
Operational key figures | 2011-06-30 00:00:00
Number of hotels 1) | 315
Number of rooms 1) | 67767
Operational key figures | Apr-Jun 11
Occupancy, % 2) | 65.4
RevPAR, EUR 2) | 67.5
Share related key figures | 2011-06-30 00:00:00
Weighted average number of shares | 146311945
Share related key figures | Apr-Jun 11
Earnings per share, EUR | 0.03
1)     Includes leased, managed and franchised hotels/rooms in operations.
2)     Including managed and leased hotels in operation.
Spreadsheet: 91743d1291404940-counting-data-in-one-column-that-is-reliant-on-data-in-another-column-h57
Sheet: Sheet1

Job1 | Completed | 4000
Job3 | Work in Progress | 2000
Job1 | Work in Progress | 750 |  | Job1 | 8000
Job1 | Work in Progress | 4000 |  | Job2 | 3000
Job4 | Completed | 1850 |  | Job3 | 8850
Job2 | Completed | 3000 |  | Job4 | 4849
Job3 | Completed | 1000 |  | [NAME] | 0
[NAME] | Work in Progress | 4000 |  | Job6 | 1800
Job6 | Completed | 1800
Job1 | Completed | 4000
Job2 | Not Proceeding | 958
Job3 | Completed | 7850
Job4 | Completed | 2999
[NAME] | Work in Progress | 1512
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Ld

[NAME]. D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 823714d1680106174-translating-table-data-dexter-gk
Sheet: Need2

 | Vehicle | Ids | Run |  | Ids | Run | Vehicle
 | 9663 | tripid: KB_A3-Sunday-029500_M100_1 |  |  | tripid: KB_A3-Sunday-029500_M100_1 | 1 | 9663
 | 8553 | tripid: KB_A3-Sunday-031500_M100_2 |  |  | tripid: KB_A3-Sunday-054900_M100_1 | 1 | 8552
 | 8552 | tripid: KB_A3-Sunday-033500_M100_3 |  |  | tripid: KB_A3-Sunday-031500_M100_2 | 2 | 8553
 | 9663 | tripid: KB_A3-Sunday-035000_M100_1 |  |  | tripid: KB_A3-Sunday-056400_M100_2 | 2 | 9645
 | 9645 | tripid: KB_A3-Sunday-035500_M100_4 |  |  | tripid: KB_A3-Sunday-033500_M100_3 | 3 | 8552
 | 8553 | tripid: KB_A3-Sunday-037000_M100_2 |  |  | tripid: KB_A3-Sunday-059400_M100_3 | 3 | 8571
 | 8664 | tripid: KB_A3-Sunday-037500_M100_5 |  |  | tripid: KB_A3-Sunday-035500_M100_4 | 4 | 9645
 | 8552 | tripid: KB_A3-Sunday-039000_M100_3 |  |  | tripid: KB_A3-Sunday-062000_M100_4 | 4 | 8566
 | 9663 | tripid: KB_A3-Sunday-039500_M100_1 |  |  | tripid: KB_A3-Sunday-037500_M100_5 | 5 | 8664
 | 9645 | tripid: KB_A3-Sunday-041000_M100_4 |  |  | tripid: [NAME] | 5 | 8553
 | 8553 | tripid: KB_A3-Sunday-041400_M100_2 |  |  | tripid: KB_A3-Sunday-047400_M100_6 | 6 | 9842
 | 8664 | tripid: KB_A3-Sunday-043000_M100_5 |  |  | tripid: KB_A3-Sunday-057900_M100_6 | 6 | 9845
 | 8552 | tripid: KB_A3-Sunday-043400_M100_3 |  |  | tripid: KB_A3-Sunday-051400_M100_10 | 10 | 9663
 | 9663 | tripid: KB_A3-Sunday-045000_M100_1 |  |  | tripid: KB_A3-Sunday-053400_M100_11 | 11 | 8553
 | 9645 | tripid: KB_A3-Sunday-045400_M100_4 |  |  | tripid: KB_A3-Sunday-070400_M100_11 | 11 | 9845
 | 8553 | tripid: KB_A3-Sunday-047000_M100_2 |  |  | tripid: [NAME] | 13 | 8664
 | 9842 | tripid: KB_A3-Sunday-047400_M100_6 |  |  | tripid: KB_A3-Sunday-065600_M100_14 | 14 | 8567
 | 8664 | tripid: KB_A3-Sunday-049400_M100_5 |  |  | tripid: [NAME] | 15 | 8674
 | 8552 | tripid: [NAME] |  |  |  |  | Need
 | 9663 | tripid: KB_A3-Sunday-051400_M100_10
 | 9645 | tripid: KB_A3-Sunday-051000_M100_4
 | 9842 | tripid: [NAME]
 | 8552 | tripid: KB_A3-Sunday-054900_M100_1
 | 8553 | tripid: KB_A3-Sunday-053400_M100_11
 | 8664 | tripid: [NAME]
 | 9645 | tripid: KB_A3-Sunday-056400_M100_2
 | 9663 | tripid: KB_A3-Sunday-057000_M100_10
 | 9845 | tripid: KB_A3-Sunday-057900_M100_6
 | 8664 | tripid: [NAME]
 | 8552 | tripid: KB_A3-Sunday-061000_M100_1
 | 8571 | tripid: KB_A3-Sunday-059400_M100_3
 | 8553 | tripid: KB_A3-Sunday-059000_M100_11
 | 9645 | tripid: KB_A3-Sunday-062500_M100_2
 | 8566 | tripid: KB_A3-Sunday-062000_M100_4
 | 9663 | tripid: KB_A3-Sunday-063200_M100_10
 | 9845 | tripid: KB_A3-Sunday-064000_M100_6
 | 8553 | tripid: [NAME]
 | 8571 | tripid: KB_A3-Sunday-065500_M100_3
 | 8552 | tripid: KB_A3-Sunday-066800_M100_1
 | 8567 | tripid: KB_A3-Sunday-065600_M100_14
 | 8664 | tripid: [NAME]
 | 9645 | tripid: KB_A3-Sunday-068000_M100_2
 | 8566 | tripid: KB_A3-Sunday-068500_M100_4
 | 9663 | tripid: KB_A3-Sunday-070000_M100_10
 | 8674 | tripid: [NAME]
 | 8571 | tripid: [NAME]
 | 8567 | tripid: KB_A3-Sunday-073000_M100_14
 | 8553 | tripid: [NAME]
 | 9845 | tripid: KB_A3-Sunday-070400_M100_11
 | 8664 | tripid: [NAME]
Spreadsheet: 740661d1626442002-can-you-keep-tree-map-hierarchy-the-same-example-workbook
Sheet: Sheet1

Group | Unit Number | No. | %
Group 1 | Unit 1 | 3
Group 1 | Unit 2 | 4
Group 1 | Unit 3 | 1
Group 1 | Unit 4 | 4
Group 1 | Unit 5 | 2
Group 1 | Unit 6 | 1
Group 1 | Unit 7 | 1
Group 1 | Unit 8 | 2
Group 1 | Unit 9 | 1
Group 1 | Unit 10 | 1
Group 1 | Unit 11 | 1
Group 2 | Unit 1 | 3
Group 2 | Unit 2 | 4
Group 2 | Unit 3 | 2
Group 2 | Unit 4 | 4
Group 2 | Unit 5 | 3
Group 2 | Unit 6 | 2
Group 2 | Unit 7 | 2
Group 3 | Unit 1 | 2
Group 3 | Unit 2 | 2
Group 3 | Unit 3 | 3
Group 3 | Unit 4 | 2
Group 3 | Unit 5 | 2
Group 3 | Unit 6 | 1
Group 3 | Unit 7 | 2
Group 3 | Unit 8 | 1
Group 3 | Unit 9 | 1
Group 3 | Unit 10 | 2
Spreadsheet: 12bf1985-ceef-44dc-b430-17db67bb01c4
Sheet: EPA

FY13 FRINGE BENEFIT WORKSHEET - EPA
Name:
FTE: |  | Enter a value between .50 and 1.00
Hired Prior to 7/1/96? |  | Select Yes or No
State or Optional Retirement? |  | Select State, Optional, or Not Applicable
Description | Object Code | Factor | [NAME] | Annual | Monthly
Salary | 11XX, 13XX
BENEFITS
Social Security1 | 1812
Medicare | 1813
State Retirement2 | 1822
Optional State Retirement3 | 187X
Health Insurance | 1832
Unemployment, workers compensation, etc . | 1892
Transit Tax | 3914
Communication Technologies Core Fee | 3225
Professional Liability | 1803 | Enter Amount
Total Benefits
TOTAL COMPENSATION
 |  |  |  | Benefits as % of Salary =
NOTES:
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Vlookup

Certificate |  | 90 Credit |  | Diploma
Points | Grading | Points | Grading | POINTS | GRADING
210 | P | 630 | PP | 1300 | MPP
230 | M | 660 | MP | 1340 | MMP
260 | D* | 720 | DM | 1420 | DMM
 |  | 750 | DD | 1460 | DDM
 |  |  |  | 1590 | D*D*D*
Spreadsheet: 90873d1290585234-large-with-if-function-754378_initiator
Sheet: Sheet1

Client ID | Client Name | Amount outstanding | Business Segment |  | All Segments
1000 | Alpha Inc | 4500000 | General |  | Rank | Largest Clients
1000 | Alpha Inc | 4500000 | General |  |  |  |  |  | Row Labels | Average of Amount outstanding
1000 | Alpha Inc | 4500000 | General |  | 1 |  |  |  | GLL Inc | 9898803056
1001 | Beta inc | 6700000 | Special |  | 2 |  |  |  | B1 Co | 8650401289
1001 | Beta inc | 6700000 | Special |  | 3 |  |  |  | [NAME] | 565656000
1001 | Beta inc | 6700000 | Special |  | 4 |  |  |  | Lambda inc | 135000000
1002 | [NAME] | 7500000 | Auto |  | 5 |  |  |  | [NAME] | 99552200
1002 | [NAME] | 7500000 | Auto |  | 6 |  |  |  | Delta Inc | 99000000
1003 | Delta Inc | 99000000 | Special |  | 7 |  |  |  | [NAME] | 89684640
1003 | Delta Inc | 99000000 | Special |  | 8 |  |  |  | B2 Co | 54065540
1004 | XYZ Inc | 10500000 | General |  | 9 |  |  |  | ABC Corp | 12099999
1004 | XYZ Inc | 10500000 | General |  | 10 |  |  |  | XYZ Inc | 10500000
1004 | XYZ Inc | 10500000 | General |  |  |  |  |  | Grand Total | 1788162620.363636
1005 | ABC Corp | 12099999 | Auto
1005 | ABC Corp | 12099999 | Auto |  | Auto
1006 | Lambda inc | 135000000 | Special |  | Rank | Largest Clients
1006 | Lambda inc | 135000000 | Special |  | 1 |  |  | Business Segment | Client Name | Average of Amount outstanding
1007 | Omega Corp | 1000 | Auto |  | 2 |  |  | Auto | [NAME] | 89684640
1007 | Omega Corp | 1000 | Auto |  | 3 |  |  |  | ABC Corp | 12099999
1008 | [NAME] | 99552200 | General |  | 4 |  |  |  | [NAME] | 7500000
1008 | [NAME] | 99552200 | General |  | 5 |  |  | Auto Total |  | 36428213
1008 | [NAME] | 99552200 | General |  | 6 |  |  | General | GLL Inc | 9898803056
1009 | [NAME] | 565656000 | Special |  | 7 |  |  |  | [NAME] | 99552200
1009 | [NAME] | 565656000 | Special |  | 8 |  |  |  | B2 Co | 54065540
1010 | [NAME] | 500 | Auto |  |  |  |  | General Total |  | 2886341970.285714
1010 | [NAME] | 500 | Auto |  | General |  |  | Special | B1 Co | 8650401289
1011 | [NAME] | 89684640 | Auto |  | Rank |  |  |  | [NAME] | 565656000
1011 | [NAME] | 89684640 | Auto |  | 1 |  |  |  | Lambda inc | 135000000
1012 | B1 Co | 8650401289 | Special |  | 2 |  |  | Special Total |  | 3117019096.333333
1012 | B1 Co | 8650401289 | Special |  | 3
1013 | B2 Co | 54065540 | General |  | 4
1013 | B2 Co | 54065540 | General |  | 5
1014 | B3 Co | 100 | Auto |  | 6
1014 | B3 Co | 100 | Auto |  | 7
1015 | LMC Inc | 5000 | Special |  | 8
1015 | LMC Inc | 5000 | Special
1016 | GLL Inc | 9898803056 | General |  | Special
1016 | GLL Inc | 9898803056 | General |  | Rank
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
Spreadsheet: 117712d1312978407-autofill-template-book1
Sheet: Sheet2

Program like that
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Student name (A6)
 | [NAME] (B6) |  |  |  |  |  |  |  |  |  |  | <<  chose: F; Ak; CH; P; D; E
 | Kursas (C6) |  |  |  |  |  |  |  |  |  |  | <<  chose: I; II; III; IV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Chose student:
 |  |  | Math |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | English |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
 |  |  | etc. |  |  |  |  |  |  |  | <<  type: 1-10; įsk; atl.; etc.
Spreadsheet: 879442d1726965100-how-to-leave-out-any-columns-that-have-all-0-00-in-them-testfile
Sheet: CFS Charges

CFS - Warehouse Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges.
CFS Location: |  | cfs-1
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | CFS Location | Total Charges: | CFS Charge | CFS In-Bond | Admin Fees CUCC | Documentation | [NAME] (DAD) | Facility Fee | Handling Fee | Pallet Fee | Over Dimension | Import [NAME] | CUCC Collect | [NAME] | Forklift Fee | Wage/Labor Trans Fee | Imp Ship Ins Fee | Port Drayage Srchg | [NAME] (local equip)
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-09-15 00:00:00 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | [NAME] | 293.09 | 293.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | [NAME] | 259.94 | 259.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-05 00:00:00 | Client-1 | 5 | Barcelona | NY | Boston | 1-box | 72 | 0.15 | LCL | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-17 00:00:00 | Client-1 | 6 | Barcelona | NY | Boston | 1-box | 103 | 0.17 | LCL | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-19 00:00:00 | Client-1 | 7 | [NAME] | NY | Boston | 5-box | 1310 | 1.53 | LCL | [NAME] | 224.8 | 224.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-26 00:00:00 | Client-1 | 8 | [NAME] | NY | Boston | 5 | 2170 | 1.94 | LCL | [NAME] | 295.9 | 295.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0