tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 004e70a9-546b-41ab-9c75-8c6e483daabb
Sheet: Soph Rotations 6-8-9 (9 sem)

Bioengineering Co-op Schedule Form
Student Name: |  | Concentration :
 |  | Company :
Anticipated  Start Date: | Year / Semester
 | (Sophomore Year)
AP/Tr Credits
 | Fall | Spring | Summer
Freshman | CHEM 0960 | CHEM 0970
 | ENGR 0011 | [NAME] 0012
 | MATH 0220 | MATH 0230
 | PHYS 0174 | PHYS 0175
 | H/SS Elective | H/SS Elective
Sophomore | BIOENG 1070 | BIOENG 1071 | Co-op
 | BIOENG 1085 | BIOENG 1085
 | BIOSC 0050 | BIOENG 1210
 | ENGR 0135 | BIOENG 1310
 | MATH 0240 | BIOENG 1630
 | MATH 0290 | ENGR 0020
 | [NAME]
Junior | BIOENG 1085 | Co-op | Co-op
 | BIOENG 1220
 | BIOENG 1320
 | BIOSC 1250
 | MATH 0280
 | H/SS Elective
Pre-Senior | Minor/Conc elective | BIOENG 1002
 | Minor/Conc elective | BIOENG 1085
 | Minor/Conc elective | BIOENG 1150
 | Minor/Conc elective | BIOENG 1255
 | lab experience | [NAME]
 |  | [NAME]
 |  | BIOENG 1241
Senior | BIOENG 1085 | BIOENG 1085
 | BIOENG 1160 | BIOENG 1161
 | IMAGING COURSE | [NAME]
 | [NAME] | [NAME]
 | Engr/Sci Elective | Engr/Sci Elective
 | H/SS Elective | H/SS Elective
Spreadsheet: 859422d1707822246-gantt-chart-using-excel-gantt-plan
Sheet: Plan

 |  |  |  |  |  |  |  | week commencing
 | Task | Description | Comment - Skills / People Required | [NAME] | Start Date | Finish Date | Duration
 |  | Tender |  | Closed | 2015-08-20 00:00:00 | 2015-09-12 00:00:00
 | 1 | footings |  | Open | 2015-09-29 00:00:00 | 2015-10-10 00:00:00
 | 1.1 | foundations |  | Open | 2015-10-11 00:00:00 | 2015-10-30 00:00:00
 | 1.2 | inspection |  | Open | MILESTONE | 2015-11-02 00:00:00
 | 2 | brick laying |  | Open | 2015-11-05 00:00:00 | 2016-01-27 00:00:00
 | 3 | roofing Frame |  | Closed |  | 2016-01-28 00:00:00
 | 3.1 | roof slate/tiling |  | Open | 2016-01-28 00:00:00 | 2016-01-29 00:00:00
 | 3.2 | inspection |  | Open | MILESTONE | 2016-01-30 00:00:00
 | 4 | Electrical |  | Open |  | 2016-01-31 00:00:00
 | 5 | Plumbing |  | Open |  | 2016-02-01 00:00:00
 | 5.1 | Water |  | Open |  | 2016-02-02 00:00:00
 | 5.2 | Waste |  | Open |  | 2016-02-03 00:00:00
 | 5.3 | Bathroom |  | Open |  | 2016-02-04 00:00:00
 | 5.4 | Kitchen |  | Open |  | 2016-02-05 00:00:00
 |  |  |  | Closed | MILESTONE | 2016-02-06 00:00:00
 |  |  |  | Open |  | 2016-02-07 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-08 00:00:00
 |  |  |  | Open |  | 2016-02-09 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-10 00:00:00
 |  |  |  | Open | 2015-11-02 00:00:00 | 2016-02-11 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-12 00:00:00
 |  |  |  | Open |  | 2016-02-13 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-14 00:00:00
 |  |  |  | Open |  | 2016-02-15 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-16 00:00:00
 |  |  |  | Open |  | 2016-02-17 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-18 00:00:00
 |  |  |  | Open |  | 2016-02-19 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-20 00:00:00
 |  |  |  | Open |  | 2016-02-21 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-22 00:00:00
 |  |  |  | Open |  | 2016-02-23 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-24 00:00:00
 |  |  |  | Open |  | 2016-02-25 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-26 00:00:00
 |  |  |  | Open |  | 2016-02-27 00:00:00
 |  |  |  | Open | MILESTONE | 2016-02-28 00:00:00
 |  |  |  | Open |  | 2016-02-29 00:00:00
 |  |  |  | Open | MILESTONE | 2016-03-01 00:00:00
 |  |  |  | Open |  | 2016-03-02 00:00:00
 |  |  |  | Open | MILESTONE | 2016-03-03 00:00:00
 |  |  |  | Open |  | 2016-03-04 00:00:00
 |  |  |  | Open | MILESTONE | 2016-03-05 00:00:00
 |  |  |  | Open |  | 2016-03-06 00:00:00
 |  |  |  | Open | MILESTONE | 2016-03-07 00:00:00
 |  |  |  |  |  | 2016-03-08 00:00:00
Spreadsheet: 26645d1218926979-game-using-excel-footballgame
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 40 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  | Los Angeles
 |  | RESULTS
 |  | Los Angeles | San Diego | San Francisco |  |  |  |  |  |  |  |  | San Diego
 |  | 20 | 5 | 10
 |  | -5 | 10 | -5 |  |  |  |  |  |  |  |  | San Francisco
 |  | 20 | -5 | 10
 |  | -10 | 20 | 20
Spreadsheet: mary_fischer__25626__1291
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1291
COMPANY NAME    MEP Services Fair Value Co.
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 807032d1669721507-fv-function-value-mismatch-financial-calculation-problem
Sheet: Sheet1

 |  | Payment Due at beginning of the year |  |  | Payment Due at beginning of the year
 | Financial Institute Data | Excel FV Calculation 1 |  |  | Excel FV Calculation 2
Period (Month) | Monthly Deposit 500 |  | Difference with B Col |  |  | Difference Col B
36 | 19717 | 19766.39274475297 |  |  | 19668.05248234127
60 | 34886 | 35059.44033120502 |  |  | 34885.01525493037
96 | 61134 | 61721.34220031455 |  |  | 61414.27084608413
120 | 81267 | 82349.37177024416 |  |  | 81939.67340322802
144 | 103781 | 105600.4569638441 |  |  | 105075.0815560638
180 | 142602 | 146136.4030058382 |  |  | 145409.3562247146
240 | 223387 | 232175.5498186364 |  |  | 231020.4475807327
 |  | 0.06 | Rate |  | 0.06 | Rate
 |  | 36 | Term |  | 36 | Term
 |  |  | Payment |  |  | Payment
 |  | 0 | Initial Deposit |  | 0 | Initial Deposit
 |  | 1 | Due |  | 0 | Due
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: TDIP Cohort 1 Yr 3

Grant: |  | Title 1A Targeted District Improvement
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2013
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013
0070-99 | Westminster 50 | 290290 |  |  |  |  | 27785 | 9876 | 11039 | 9749 | 11870 | 56006 | 13544 | 27559
0100-99 | [NAME] | 50000 |  |  |  |  | 23255 |  |  |  |  | 20731 |  |  | 6014
0120-99 | Englewood | 201882 |  |  |  | 28177 |  |  | 11863 | 9967 | 8297 | 25867 | 30837 | 17025 | 13891
1390-99 | Huerfano | 51402 |  |  |  |  |  | 9135 |  |  |  | 23778 |  | 18489
1540-99 | [NAME] | 177450 |  |  |  |  |  |  |  |  |  |  |  | 139384
1620-99 | Aguilar | 138516 |  |  | 126338 |  | 12178
1810-99 | Karval | 100000 |  |  |  |  |  |  |  | 12578 |  |  | 7647 |  | 1640
2035-99 | Montezuma | 128126 |  |  | 9234 | 5738 |  |  | 5087 | 5152 | 3845 |  | 24678 | 752 | 3936
2405-99 | [NAME] RE-3 | 111117 |  |  |  | 5117 | 11679 | 2383 | 824 | 4891 | 946 | 1210 | 6461 | 2532 | 980 | 3333
2520-99 | East otero | 100000 |  |  |  |  |  | 18518 | 5602 | 6297 | 55633 | 13950
2530-99 | [NAME] R-2 | 103465 |  |  |  |  |  | 92669 |  |  |  |  | 6543
Spreadsheet: 23427d1212858020-calculate-the-commission-for-each-client-automaticaly-log
Sheet: Sheet1

Name of insured / Customer# |  |  | Company | Policy Type | Eff. Date | Premium | Commission
[NAME] |  |  | TRAVELERS | AUTO |  | 1000 | 150
[NAME] |  |  | SAFECO | HOME |  | 500 | 50
[NAME] |  |  | TRAVELERS | HOME |  | 600 | 72
[NAME] |  |  | SAFECO | AUTO |  | 2000 | 400
Policy Count |  | 4 |  | TOTALS: |  | 4100 | 672
Spreadsheet: 129522d1321650432-excel-2007-date-range-countif
Sheet: Sheet1

Date | Data |  |  | Today
2011-11-18 00:00:00 | 5 |  |  | 2011-11-18 00:00:00
2011-11-18 00:00:00 | 6
2011-11-18 00:00:00 | 10
2011-11-17 00:00:00 | 6
2011-11-17 00:00:00 | 6
2011-11-17 00:00:00 | 7
2011-11-16 00:00:00 | 9
2011-11-16 00:00:00 | 7
 | 6
Spreadsheet: 772498d1647330735-higher-values-in-col-a-than-col-b-sum-rows-with-the-higher-value-and-show-difference-cols-a-b-higher-difference
Sheet: Sheet1

2 | 3 |  |  |  | 2 | 3
2 | 1 |  |  |  | 2 | 1
2 | 3 |  |  |  | 2 | 3
2 | 1 |  |  |  | 2 | 1
2 | 2 |  |  |  | 2 | 2
2 | 3 |  |  |  | 2 | 3
4 | 2 |  |  |  | 4 | 2
4 | 3 |  |  |  | 4 | 3
4 | 5 |  |  |  | 4 | 5
2 | 1 |  |  |  | 2 | 1
Column A total | Column B Total | Total of the highest value from A + B for each row |  |  |  | Difference between Columns A + B where Column A is higher value
Spreadsheet: 485370d1476851572-select-value-in-table-based-on-gender-and-weight-select-value-in-table-based-on-gender-and-weight-v2
Sheet: After

 | Male |  |  |  | Name | Gender | Weight | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 |  | Total | End Score |  |  | Coefficient check
 | Weight | coefficient |  |  |  |  |  |  |  |  |  |  |  |  | = total * Coeffiecient |  |  | = end score / total
 | 60 | 1.5 |  |  |  | Male | 80.7 | 50 | 51 | 60 | 55 | 62 |  |  | 158.6
 | 70 | 1.4 |  |  |  | Male | 75.6 | 55 | 52 | 58 | 60 | 61 |  |  | 166.6
 | 80 | 1.3 |  |  |  | Female | 60 | 40 | 48 | 48 | 50 | 0 |  |  | 148.96
 | 90 | 1.2 |  |  |  | Male | 95.1 | 60 | 65 | 66 | 68 | 0 |  |  | 160.8
 | 100 | 1.1 |  |  |  | Female | 66.8 | 45 | 0 | 50 | 52 | 53 |  |  | 145.23
 |  |  |  |  |  |  |  | Values in red are the expected results, All help much appreciated.
 | Female |  |  |  |  | Excel Forum
 | Weight | coefficient
 | 55 | 1.63
 | 65 | 1.52
 | 75 | 1.41
 | 85 | 1.3
Spreadsheet: 329957d1404466717-using-index-match-with-multiple-criteria-sample
Sheet: Report

Employee Masters |  |  |  |  |  | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summarry
Attn Code | Emp No | Employee Name |  | Date |  | In1 | Out1 | [NAME] | In2 | Out2 | [NAME] | In3 | Out3 | [NAME] | In4 | Out4 | [NAME] | In5 | Out5 | [NAME] | In6 | Out6 | [NAME] | In7 | Out7 | [NAME] | In8 | Out8 | [NAME] |  | Total IN Punch | Total OUT Punch | Total Break Hrs
1 | 1804 | Satheesh P |  | 2014-07-01 00:00:00 |  | 09:26 | 13:28 | 00:19:00 | 13:47 | 20:10 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 2 | 2 | 00:19:00
2 | 1809 | [NAME] |  | 2014-07-01 00:00:00 |  | 13:39 | 22:02 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 1 | 1
3 | 1813 | Ranjith Prasanth C |  | 2014-07-01 00:00:00 |  | 06:13 | 16:13 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 1 | 1
5 | 1820 | Harisankaran K S |  | 2014-07-01 00:00:00 |  | 09:33 | 19:12 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 1 | 1
7 | 1826 | Yuvraj N |  | 2014-07-01 00:00:00 |  | 08:58 | 13:15 | 00:10:00 | 13:25 | 17:21 | 00:08:00 | 17:29 | 18:51 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 3 | 3 | 00:18:00
9 | 1838 | Vijay V |  | 2014-07-01 00:00:00 |  | 01:39 | 11:34 | 01:42:00 | 13:16 | 13:33 | 02:38:00 | 16:11 | 16:37 | 01:57:00 | 18:34 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 4 | 3 | 06:17:00
10 | 1845 | [NAME]. M |  | 2014-07-01 00:00:00 |  | 13:59 | 19:01 | 00:10:00 | 19:11 | 22:03 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 2 | 2 | 00:10:00
1 | 1804 | Satheesh P |  | 2014-07-02 00:00:00 |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  |  |  | #N/A | #N/A | #N/A
2 | 1809 | [NAME] |  | 2014-07-02 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-02 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-02 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-02 00:00:00
9 | 1838 | Vijay V |  | 2014-07-02 00:00:00 |  |  | Match crietia will be Employee name, LogRecords headers & Date
10 | 1845 | [NAME]. M |  | 2014-07-02 00:00:00 |  |  | it fails support when ther is a change in 3 criteria which is the "DATE"
1 | 1804 | Satheesh P |  | 2014-07-03 00:00:00
2 | 1809 | [NAME] |  | 2014-07-03 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-03 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-03 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-03 00:00:00
9 | 1838 | Vijay V |  | 2014-07-03 00:00:00
10 | 1845 | [NAME]. M |  | 2014-07-03 00:00:00
1 | 1804 | Satheesh P |  | 2014-07-04 00:00:00
2 | 1809 | [NAME] |  | 2014-07-04 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-04 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-04 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-04 00:00:00
9 | 1838 | Vijay V |  | 2014-07-04 00:00:00
10 | 1845 | [NAME]. M |  | 2014-07-04 00:00:00
Spreadsheet: 101548d1299660212-data-compilation-sales-calculator-2010
Sheet: Plan Criteria

Sales Plan Criteria
Qualification Criteria | Type | < 80% | 80% to 99% | 100% to 119% | 120% + |  | Lower Band % | Qual Y | Qual N
 |  | 3 | 4 | 5 | 6
Offers Created | No. | 24 | 24 | 24 | 24 |  |  | < 80% | < 80%
CEI Score | % | 0.9 | 0.9 | 0.9 | 0.9 |  | 0.8 | 80% to 99% | < 80%
Failed Mystery Shops | No. | 0 | 0 | 0 | 0 |  | 1 | 100% to 119% | 80% to 99%
F&I PPU Achieved | No. | 775 | 775 | 775 | 775 |  | 1.2 | 120% + | 100% to 119%
 |  | Min £ |  |  |  | Max £ |  |  |  | % Commission
Sales Structure | Type | < 80% | 80% to 99% | 100% to 119% | 120% + | < 80% | 80% to 99% | 100% to 119% | 120% + | < 80% | 80% to 99% | 100% to 119% | 120% +
 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Push Cars | New | 75 | 100 | 185 | 200 | 75 | 100 | 300 | 400 | 0 | 0 | 0.1 | 0.12
Pull Cars | New | 50 | 75 | 135 | 150 | 50 | 75 | 300 | 400 | 0 | 0 | 0.1 | 0.12
Motability / VIP Sales | New | 50 | 75 | 75 | 75 | 50 | 75 | 75 | 75 | 0 | 0 | 0 | 0
A1 | New | 50 | 75 | 100 | 100 | 50 | 75 | 100 | 100 | 0 | 0 | 0 | 0
Used, Demo & Ex-Demo | Used | 75 | 100 | 160 | 175 | 75 | 100 | 300 | 400 | 0 | 0 | 0.1 | 0.12
[NAME] (New/Used) |  | 100 | 125 | 175 | 200 | 100 | 125 | 175 | 200 | 0 | 0 | 0 | 0
Overage Used Car 90 Days + | Used | 100 | 125 | 200 | 225 | 100 | 125 | 300 | 400 | 0 | 0 | 0.1 | 0.12
F&I Structure 100%+ | Type | Penetration | £'s | Penetration | £'s | Less Than | Penetration | £'s
HP, LP, CH, FL Cases | All | 0.6 | 40 | 0.5 | 20 | < | 0.5 | 15
PCP Cases | All | 0.45 | 75 | 0.35 | 50 | < | 0.35 | 40
Supagard Cases | All | 0.55 | 40 | 0.45 | 25 | < | 0.45 | 20
36M Warranties | Used | 0.45 | 60 | 0.35 | 50 | < | 0.35 | 40
24M to 35M Warranties | Used | 0.45 | 50 | 0.35 | 40 | < | 0.35 | 30
12M to 23M Warranties | Used | 0.45 | 35 | 0.35 | 25 | < | 0.35 | 15
3M to 11M Warranties | Used | 0.45 | 20 | 0.35 | 15 | < | 0.35 | 10
F&I Paid at | Type | Penetration | £'s | Penetration | £'s | Less Than | Penetration | £'s
HP, LP, CH, FL Cases | All | 0.6 | #N/A | 0.5 | #N/A | < | 0.5 | 15
PCP Cases | All | 0.45 | #N/A | 0.35 | #N/A | < | 0.35 | 40
Supagard Cases | All | 0.55 | #N/A | 0.45 | #N/A | < | 0.45 | 20
36M Warranties | Used | 0.45 | #N/A | 0.35 | #N/A | < | 0.35 | 40
24M to 35M Warranties | Used | 0.45 | #N/A | 0.35 | #N/A | < | 0.35 | 30
12M to 23M Warranties | Used | 0.45 | #N/A | 0.35 | #N/A | < | 0.35 | 15
3M to 11M Warranties | Used | 0.45 | #N/A | 0.35 | #N/A | < | 0.35 | 10
Other Structure |  | Pass | Fail <90% | Fail
CEI (Monthly Bonus) 90% + |  | 100 | -100
Mystery Shop 95% + |  | 100 |  | -200
Group [NAME] (Y/N) |  | 250
Spreadsheet: 672892d1587055668-formula-to-calculate-the-next-available-date-in-a-column-next-available-date-pivot-table-blank-filter
Sheet: Sheet1

START DATE | Product ID | Product Type |  |  | Model | Per Week | Next Availble Date
2020-08-10 00:00:00 | 14732 | SPECIAL |  |  | Frameless | 5 |  | <<<<<< Need a formula that looks at the "C" Column based on the F2 and returns the date in Column A that does NOT have a Product Slotted in Column B
2020-08-10 00:00:00 | 14646 | SPECIAL |  |  | Special | 5
2020-08-11 00:00:00 | 14647 | SPECIAL |  |  | Frame-Type | 1
2020-08-11 00:00:00 | 14897 | FRAMELESS |  |  | Walking Floors | 1 |  |  |  |  | Next available date should also scan the product ID to see where a product is not slotted.
2020-08-12 00:00:00 | 14922 | FRAME-TYPE
2020-08-12 00:00:00 | 14767 | FRAMELESS
2020-08-12 00:00:00 | 14898 | FRAMELESS
2020-08-12 00:00:00 | 14932 | SPECIAL |  |  | No [NAME] needed if you use a pivot table shown below
2020-08-13 00:00:00 | 14768 | FRAMELESS |  |  | You will need to make your column A real dates instead of text dates
2020-08-13 00:00:00 | 14931 | FRAMELESS |  |  | After changing data be sure to refresh pivot table.
2020-08-14 00:00:00 |  | WALKING FLOOR
2020-08-14 00:00:00 | 14900 | FRAMELESS
2020-08-17 00:00:00 | 14923 | FRAME-TYPE
2020-08-17 00:00:00 |  | SPECIAL |  |  | Product ID | (blank)
2020-08-17 00:00:00 |  | SPECIAL
2020-08-17 00:00:00 |  | SPECIAL |  |  | Row Labels | Min of START DATE
2020-08-17 00:00:00 |  | SPECIAL |  |  | FRAMELESS | 2020-08-27 00:00:00
2020-08-18 00:00:00 |  | WALKING FLOOR |  |  | FRAME-TYPE | 2020-08-26 00:00:00
2020-08-20 00:00:00 | 14899 | FRAMELESS |  |  | SPECIAL | 2020-08-17 00:00:00
2020-08-21 00:00:00 | 14746 | FRAMELESS |  |  | WALKING FLOOR | 2020-08-14 00:00:00
2020-08-21 00:00:00 | 14747 | FRAMELESS |  |  | Grand Total | 2020-08-14 00:00:00
2020-08-21 00:00:00 | 14748 | FRAMELESS
2020-08-21 00:00:00 | 14749 | FRAMELESS
2020-08-21 00:00:00 | 14750 | FRAMELESS
2020-08-24 00:00:00 |  | SPECIAL
2020-08-24 00:00:00 |  | SPECIAL
2020-08-24 00:00:00 |  | SPECIAL
2020-08-25 00:00:00 |  | SPECIAL
2020-08-25 00:00:00 |  | SPECIAL
2020-08-26 00:00:00 |  | WALKING FLOOR
2020-08-26 00:00:00 |  | FRAME-TYPE
2020-08-27 00:00:00 |  | FRAMELESS
2020-08-27 00:00:00 |  | FRAMELESS
2020-08-28 00:00:00 |  | FRAMELESS
2020-08-28 00:00:00 |  | FRAMELESS
2020-08-28 00:00:00 |  | FRAMELESS
Spreadsheet: richard_shapiro__32623__Investment Portfolio
Sheet: Sheet1

EPSA INVESTMENT PORTFOLIO
 | Beginning |  |  |  | Unrealized | Unrealized | Foreign | Ending
 | Balance | Dividend | Purchases | Capital Gain | Gain | Loss | Tax | Balance
2000-03-31 00:00:00 | 190281.4 | 979.33 | 0 | 0 | 3525.15 | 0 | 0
2000-06-30 00:00:00 | 194785.88 | 990.39 | 0 | 0 | 0 | -4177.84 | 0
2000-09-30 00:00:00 | 191598.43 | 1090.23 | 94998 | 0 | 0 | -7779.67 | 0
2000-12-31 00:00:00 | 279906.99 | 2024.11 | 0 | 22785.5 | 0 | -26809.04 | -121.39
2001-03-31 00:00:00 | 277786.17 | 1165.56 | 0 | 357.1 | 0 | -15901.83 | 0
2001-06-30 00:00:00 | 263407 | 1574.58 | 99999.99 | 0 | 12168.09 | 0 | 0
2001-09-30 00:00:00 | 377149.66 | 1282.82 | 0 | 0 | 0 | -49145.17 | 0
Spreadsheet: 798922d1664814608-extract-data-from-an-array-excel-sample
Sheet: Sheet1

 | Data Source: |  |  |  | Output:
 | Item | kW rating | Number |  | Item | kW rating | Number
 | Heating | 5 | 2 |  | Lighting | 0.05 | 10
 | Cooling | 50 | 1 |  | Lighting | 0.15 | 15
 | Cooling | 21 | 3 |  | Lighting | 0.06 | 10
 | Lighting | 0.05 | 10
 | Heating | 1.5 | 25
 | Other | 25 | 2
 | Lighting | 0.15 | 15
 | Heating | 20 | 5
 | Lighting | 0.06 | 10
 | Other | 54 | 1
Spreadsheet: 329174d1404221905-how-do-i-autopopulate-data-from-1-database-to-another-in-excel-2003-database-2-minor-for-person-a
Sheet: Sheet1

 | UNCONTROLLED WHEN PRINTED
 | QUALITY AUDITOR LOG
 | Name |  | Person A
 | Training Courses
 | Course Name |  |  |  | Course No |  | Date Passed |  | Verification
 | (a) |  |  |  | (b) |  | (c) |  | (d)
 | Course |  |  |  | 2849 |  | 2011-08-12 00:00:00 |  | Certificated
 | IRCA Team Leader Course |  |  |  | IRCA/A17059 |  | 2011-12-02 00:00:00 |  | Certificated
 | Team Leader [NAME] |  |  |  | N/A |  | 2012-03-07 00:00:00 |  | Certificated
 | Training Audits
 | Date | On-Site Audit                       Duration |  |  | Off-Site Audit                      Duration |  |  | Audited                             Unit / Section |  |  | Role                       in Audit |  | No in                   Team |  | Audit                                      Standard |  |  | Type of                        Audit |  | Verification |  | Audit                        Client
 | (a) | (b) |  |  | (c) |  |  | (d) |  |  | (e) |  | (f) |  | (g) |  |  | (h) |  | (i) |  | (j)
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | QSO Authorization
 | Course Name |  |  |  | Course No |  | Date Passed |  | Verification |  |  |  |  | Level |  |  | Self Auditor |  |  | Auditor |  | Lead Auditor
 | (a) |  |  |  | (b) |  | (c) |  | (d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  | Not Required |  |  | [NAME] QSC |  | [NAME] QSC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  | Not Required |  |  | 2014-03-03 00:00:00 |  | 2014-03-03 00:00:00
 | UNCONTROLLED WHEN PRINTED
 | Name |  | Person A
 | Audits Experience
 | Date | On-Site Audit                       Duration |  |  | Off-Site Audit                      Duration |  |  | Audited                             Unit / Section |  |  | Role                       in Audit |  | No in                   Team |  | Audit                                      Standard |  |  | Type of                        Audit |  | Verification |  | Audit                        Client
 | (a) | (b) |  |  | (c) |  |  | (d) |  |  | (e) |  | (f) |  | (g) |  |  | (h) |  | (i) |  | (j)
 | May | 2 days |  |  | 1 days |  |  |  |  |  | Auditor |  |  |  | As Column (e) states BOTH 'Auditor' & 'ATL' the following should be calculated
 | Jun | 2 days |  |  | 4 days |  |  |  |  |  | ATL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Where Column (e) states 'Auditor' - ONLY Column (b) should be taken at line 45 and added to DATABASE 1 Master at Cell L7 to read 2 days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Where Column (e) states 'ATL' - BOTH columns (b) AND (c ) should be added and shown in Cell O7 as 6 days
Spreadsheet: 2b8656aa-48ab-440b-8978-1d9981b76c9b
Sheet: Sheet1

Saint Paul VISTA Program | Unnamed: 1 | Unnamed: 2 | Expense Report Form | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Name: |  |  | Report for (Month/Year):
Address: |  |  |  | Work Site:
Part A:  Reimbursable Expenses
Date | Location | Description / Purpose of Business |  |  | Amount
 |  | Total Part A: |  |  | 0
Part B:  Mileage and Parking Expenses |  |  | [NAME]
Date | From / To | Description / Purpose of Business | Beginning | End | Total Miles | Parking Fee
 |  |  |  | Totals Part B: | 0 | 0
 |  |  |  |  | Total Part A Expense | 0
 |  |  |  | Total Miles x | 0.555 | 0
VISTA's Signature |  | Date |  |  | Parking Fees | 0
 |  |  |  |  | Total Expense per Report: | 0
VISTA Program Manager's Signature |  | Date
City of Saint Paul VISTA Program
Spreadsheet: 74381d1274898552-sum-multiple-data-in-pivot-table-debtors-statement-v2
Sheet: Exported Datasheet

Date | Client | [NAME] | Closing Balance | 0-30 | 30-60 | 60-90 | >90
2010-04-01 00:00:00 | ABC | ABC/125 | 12000 |  | 12000
2010-04-02 00:00:00 | XYZ | XYZ/250 | 12540 |  | 12540
2010-05-20 00:00:00 | ABC | ABC/126 | 20000 | 20000