tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: IDC

INTEREST DURING CONSTRUCTION ($000)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Current Month |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "IDC_Table"
Calendar Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals | 1
 | (Excl IDC & W/H) |  | Total
Project Cost
Bridge Financing Rate
Permanent Financing Rate
Subordinated Debt Rate
Construction Balance
Beginning Balance |  |  |  | 0
Construction Drawdown
Interest During Construction
W/H Tax - IDC
Ending Balance
Cumulative % Complete (Excl IDC & W/H Tax)
All-In Cumulative % Complete
Shareholder Construction Loan
Beginning Balance |  |  |  | 0
Shareholder [NAME]
Construction Drawdown
Plus: Interest During Construction
Plus: W/H Tax - IDC
Ending Balance
Senior Debt
Beginning Balance |  |  |  | 0
Senior Debt Proceeds
Construction Drawdown
Plus: Interest During Construction
Plus: W/H Tax - IDC
Ending Balance
Subordinated Debt
Beginning Balance |  |  |  | 0
Subordinated Debt Proceeds
Construction Drawdown
Plus: Interest During Construction
Plus: W/H Tax - IDC
Ending Balance
IDC - Shareholder Construction Loan
IDC - Senior Debt
IDC - Subordinated Debt
Total IDC
IDC - Cumulative
W/H Tax - IDC
W/H Tax - Cumulative
Monthly IDC To Be Expensed
Cumulative IDC To Be Expensed
Equity Balance
Actual Equity Contribution |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cumulative Equity Contribution
Beginning Balance |  |  |  | 0
Construction Drawdown
Plus: Interest During Construction |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Plus: W/H Tax - IDC |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending Balance
Total Interest During Construction
Total W/H Tax - Interest
Cumulative Bridge Loan Issuance
Cumulative Bridge Loan IDC
Cumulative Bridge Loan W/H Tax - IDC
Total Cumulative Bridge Loan
Commitment Fee Calculation
Beginning Commitment Amount |  |  |  | 0
Current Period Amount Committed
Current Period Amount Drawndown
Ending Commitment Amount
Commitment Fee
Total Commitment Fee
Total Commitment Fee
Spreadsheet: 37396d1235395239-how-to-calculate-date-how-to-calculate-date
Sheet: Sheet1

 | 2nd Thursday in month
2009-01-01 00:00:00 | 2009-01-15 00:00:00
2008-12-01 00:00:00 | 2008-12-11 00:00:00
2008-11-01 00:00:00 | 2008-11-13 00:00:00
2008-10-01 00:00:00 | 2008-10-09 00:00:00
2008-09-01 00:00:00 | 2008-09-11 00:00:00
2008-08-01 00:00:00 | 2008-08-14 00:00:00
2008-07-01 00:00:00 | 2008-07-10 00:00:00
2008-06-01 00:00:00 | 2008-06-12 00:00:00
2008-05-01 00:00:00 | 2008-05-15 00:00:00
2008-04-01 00:00:00 | 2008-04-10 00:00:00
2008-03-01 00:00:00 | 2008-03-13 00:00:00
2008-02-01 00:00:00 | 2008-02-14 00:00:00
2008-01-01 00:00:00 | 2008-01-10 00:00:00
2007-12-01 00:00:00 | 2007-12-13 00:00:00
2007-11-01 00:00:00 | 2007-11-15 00:00:00
2007-10-01 00:00:00 | 2007-10-11 00:00:00
2007-09-01 00:00:00 | 2007-09-13 00:00:00
2007-08-01 00:00:00 | 2007-08-09 00:00:00
Spreadsheet: 344d44f2-b999-41d7-8f5a-d51652d5a8b6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5477 | 15371 | [NAME] | Tellechea | ARG | 2 | 00:16:35 | 00:01:35 | 01:20:15 | [NAME] | 00:37:09 | 1 | 02:16:19
5477 | 15974 | Rodrigo | [NAME] | PER | 1 | 00:17:32 | 00:01:14 | 01:22:16 | 00:00:27 | 00:38:18 | 2 | [NAME]
5477 | 15132 | [NAME] | Figari | PER | 3 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: serials v mono

Serials vs. [NAME] by Branch FY09 and FY10
 | FY09 | FY10 | % change | % of total FY10 expend.
Kingston
monographs | 302430.28 | 343565.02
monographs endowments | 21098.01 | 3810.68
MONOGRAPHS TOTAL
serials | 2602491.17 | 2726388.62
serials endowments | 36466.84 | 36582.03
SERIALS TOTAL
KINGSTON SUBTOTAL
[NAME]
monographs | 2168.62 | 76.5
serials | 27264.41 | 10536.48
CCE SUBTOTAL
CCE
monographs | 7058.43 | 13780.93
serials | 4194.3 | 4460.97
[NAME]
All branches
monographs
serials
TOTAL
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: EAST-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | June |  |  |  |  |  | September |  |  |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  |  |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-EAST
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 521439d1496591946-index-multiple-tables-on-multiple-sheets-testing-2-
Sheet: Team MB

Case Number | Media Source | Status | ATT Team Leader | Case Owner | [NAME] | Case Summary
 |  |  |  |  | Different Information here | and Also here
Top 3 Case Drivers
Outliers Resolve
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Outliers ORS
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Workflow Outliers *507100
Please include Who:  What: Opportunity for the workflow per mycst*507100 2 - 3 agents
Spreadsheet: 048b2f46-fa8b-4d76-bef7-67d5171910d4
Sheet: szkody

 |  |  | Tabela nr 5
[NAME]
Informacje o szkodach w ostatnich 3 latach
22.06.2008-21.06.2011
ilość szkód | rodzaj szkody | wysokość wypłaty odszkodowania
1 | OC komunikacyjne | 2300
1 | OC komunikacyjne | 1454.43
2 | OC delikt, szkoda w mieniu | 10000
2 | delikt, obrażenia ciała | 2899.23
1 | kradzież z włamaniem i rabunek | 320.35
 | RAZEM
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 12-3 Day

 | CR1 | Priority | Headcount | QI
1 |  | 1 |  | [NAME]
2 |  | 2 |  | [NAME]
3 |  | 3 |  | [NAME]
4 |  | 4 |  | [NAME]
5 | Alinity RV | 5 | 0.25 | [NAME]
12 |  | 17 |  | [NAME]
13 |  | 18 |  | [NAME]
9 | Architect RV | 6 | 0.25 | [NAME]
15 | [NAME] | 20 | 0.5 | [NAME]
17 | Alinity RV | 7 | 0.25 | [NAME]
 |  |  |  | [NAME]
31 | Architect RV | 8 | 0.25 | [NAME]
8 | Architect RV | 14 | 0.25 | [NAME]
10 | Architect RV | 9 | 0.25 | [NAME]
11 | [NAME] | 21 | 0.33 | [NAME]
18 | Architect RV | 15 | 0.25 | [NAME]
19 | Architect RV | 10 | 0.25 | [NAME]
20 | [NAME] | 19 | 0.5 | [NAME]
21 | Architect RV | 11 | 0.25 | [NAME]
22 |  | 12 |  | [NAME]
23 | Architect RV | 13 | 0.25 | [NAME]
7 |  | 16 |  | [NAME]
Total
 | CR2 | Priority
74 | Side Cassette | 1 |  | Kristi
78 |  | 2 |  | Kristi
79 | V102 | 3 |  | Kristi
77 | 6ul | 4 | 0.25 | Kristi
87 | [NAME] | 5 |  | Kristi
53 | Architect RV | 6 | 0.2 | Kristi
61 | [NAME] | 10 | 0.5 | Kristi
66 | [NAME] | 9 | 0.5 | Kristi
84 | Cepheid MB1 PQ | 7 | 1 | Kristi
86 |  | 8 |  | Kristi
62 |  | 16 |  | Kristi
63 | NP 104 | 15 | 0.25 | Kristi
67 |  | 14 |  | Kristi
88 |  | 11 |  | Kristi
107 |  |  |  | Kristi
108 | Alinity [NAME] Key3 | 12 | 0.2 | Kristi
109 | Alinity OverCap | 13 | 0.2 | Kristi
Total
 | CR3
201 | Mask | 1 | 3 | Shirell
202 | Mask |  |  | Shirell
203 | Mask |  |  | Shirell
204 | Mask |  |  | Shirell
205 | Mask | 2 | 3 | Shirell
Total
Grand Total
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Coroplast 4mm

 |  |  |  | Screen Printing
 |  |  |  | Art  -   Screens  -   Film
233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
Size H X W | 18 | 24 | 36 | 48 | 60 | 72 | 96
12 | 1.54 | 1.54 | 2.07 | 7.41 | 16.5 | 16.5 | 16.5
18 | 1.54 | 1.54 | 2.07 | 7.41 | 16.5 | 16.5 | 16.5
24 | 1.54 | 2.21 | 2.99 | 7.41 | 16.5 | 16.5 | 16.5
36 | 2.07 | 2.99 | 0 | 7.41 | 16.5 | 16.5 | 16.5
48 | 7.41 | 7.41 | 7.41 | 7.41 | 16.5 | 16.5 | 16.5
72 | 0 | 0 | 0 | 0 | 16.5 | 16.5 | 16.5
96 | 16.5 | 16.5 | 16.5 | 16.5 | 16.5 | 16.5 | 16.5
Artwork to Film |  |  |  | 10 | Per Color
Screen charges |  |  |  | 20 | a screen
re-order screens |  |  |  | 15 | re-burn per screen
color changes |  |  |  | 15 | per change
sleeve,pant,special locations |  |  |  | 0.25 | per location
Fleece Charge |  |  |  | 0.25 | per location
3% MISPRINT ALLOWANCE ON ALL JOBS PER INDUSTRY STANDARD
Spreadsheet: 875639d1722245015-calculating-per-diem-meals-on-multiple-variables-per-diems-example-jt
Sheet: Per Diems

 | Example |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Breakfast | Lunch | Dinner
 | Departure Date | Start Time |  | Return Date | End Time
 | Number of Nights
 |  |  |  | 700 | 1100 | 1700
 | Meals entitlement - calculated from trip dates |  |  | Breakfast | Lunch | Dinner
 |  |  |  |  |  |  |  | Check
 | Departure |  |  |  | Return |  |  | 1130 | <- in format as you desire, i.e. enter as 1130 and display as 11:30
 | Meal | Before |  |  | Meal | After
 | Breakfast | 07:00:00 |  |  | Breakfast | 08:00:00 |  | Time formatted as per your desire, i.e. enter 0000 (without colon) and display as 00:00 in 24-hour time format
 | Lunch | 11:00:00 |  |  | Lunch | 14:00:00 |  | With Breakfast, [NAME] and Dinner time at E12:G12,
 | Dinner | 19:00:00 |  |  | Dinner | 19:00:00
 | Question 1 |  |  |  |  |  |  | Calculating Per Diem Meals on multiple variables
 | How do I calculate the number of meals based on multiple variables: |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1426726-calculating-per-diem-meals-on-multiple-variables.html
 | 1 | Departure date and start time
 | 2 | Return date and end time
 | 3 | Departure before time for breakfast, lunch and dinner
 | 4 | Return after time for breakfast, lunch and dinner
 | Answer should populate the following:
 | 4 | in cell E14 Breakfast
 | 5 | in cell F14 Lunch
 | 4 | in cell E14 Dinner
 | Question 2
 | I want the time displayed as 24 hour time. But when you enter you must put the colon in. Is there any way to alter the way the time is entered to display as 24 hour time without having to put a colon in?
 | For example if I have formatted the cell to display 24 hour time:
 | But when I enter the time as "0700" without a colon
 | It will display like this 0:00
Spreadsheet: 158369d1338203578-indexing-multiple-arrays-the-final-example1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes or No
1 | Yes | 12 |  | 1 | No | 423 |  | 1 | Yes | 23 |  | 1 | Yes | 12 | Yes |  |  |  |  | Yes
2 | No | 23 |  | 2 | Yes | 3423 |  | 2 | No | 1232 |  | 5 | Yes | 14 |  |  |  |  |  | No
3 | No | 14 |  | 3 | No | 342 |  |  |  |  |  | 7 | Yes | 1
4 | No | 23 |  | 4 | No | 324 |  | 3 | No | 431 |  | 2 | Yes | 3423
 |  |  |  | 5 | No | 4 |  | 4 | No | 5 |  | 1 | Yes | 23
5 | Yes | 14 |  | 6 | No | 5 |  | 5 | No | 5 |  | 6 | Yes | 54
6 | No | 23 |  |  |  |  |  | 6 | Yes | 54
7 | Yes | 1 |  | 7 | No | 6 |  | 7 | No | 6
Spreadsheet: darrell_schoolcraft__7736__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 11

WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  |  | [NAME] (PAGER)
 | S2 | [NAME] | S5 | HOLCOLM | S2 | [NAME] | S5 | S2, S4 & S5 | TOTAL
HOUR | MWH | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 |  | 0 | 0 | 6.75 | 325.1183
10:00:00 |  | 0 | 0 | 6.75 | 325.1183
11:00:00 |  | 0 | 0 | 6.75 | 325.1183
12:00:00 |  | 0 | 0 | 6.75 | 325.1183
13:00:00 |  | 0 | 0 | 6.75 | 325.1183
14:00:00 |  | 0 | 0 | 6.75 | 325.1183
15:00:00 |  | 0 | 0 | 6.75 | 325.1183
16:00:00 |  | 0 | 0 | 6.75 | 325.1183
17:00:00 |  | 0 | 0 | 6.75 | 259.3290941907262
18:00:00 |  | 0 | 0 | 6.75 | 298.1840238059713
19:00:00 |  | 0 | 0 | 6.75 | 325.1183
20:00:00 |  | 0 | 0 | 6.75 | 325.1183
21:00:00 |  | 0 | 0 | 6.75 | 325.1183
22:00:00 |  | 0 | 0 | 6.75 | 249.5824763555353
23:00:00 |  | 0 | 0 | 6.75 | 151.2532643552231
1900-01-01 00:00:00 |  | 0 | 0 | 6.75 | 131.3727352819895
1900-01-01 01:00:00 |  | 0 | 0 | 6.75 | 101.3987323889473
1900-01-01 02:00:00 |  | 0 | 0 | 6.75 | 71.22869908410007
1900-01-01 03:00:00 |  | 0 | 0 | 6.75 | 91.36451240375277
1900-01-01 04:00:00 |  | 0 | 0 | 6.75 | 91.36451240375277
1900-01-01 05:00:00 |  | 0 | 0 | 6.75 | 141.3228754577088
1900-01-01 06:00:00 |  | 0 | 0 | 6.75 | 249.5824763555353
1900-01-01 07:00:00 |  | 0 | 0 | 6.75 | 317.5396681536001
1900-01-01 08:00:00 |  | 0 | 0 | 6.75 | 325.1183
DAILY
TOTAL
Spreadsheet: 838230d1690831451-sum-value-error-jul_wk4-data_test
Sheet: Aaliya

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 182921d1348657107-provide-formula-for-autofilter-book11
Sheet: SHEET1 (2)

COLLECTIVE WORKING HOURS
 | 005 | BIS/005/12 | 0
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | TOTAL
 |  |  |  |  | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | TOTAL
SL | EMP. NO. | NAME | DEPARTMENT | DESIGNATION | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F
1
TOTAL WORKING DAYS |  |  |  |  | 0 | 0 | 1 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
Spreadsheet: a35bc737-1512-4e52-96ee-d4e0a01c7858
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0013348 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Bay River MSD - Pamlico Regional Facility | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00600 | 00400 | 00545 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | Total Nitrogen | pH | Settleable Solids | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mL/L | mg/L | mg/L | NTU
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Grab | Composite | Grab | Composite | Grab | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  | 320044 | 10 |  |  |  | 14 | 4 |  | 10 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  |  | 6-9 |  |  | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | 3 x Year | 3 x Year | Daily | See Permit | See Permit | 3 x Year | See Permit | 3 x Year | Daily | 3 x Year | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 25364d1216664957-data-extraction-and-tabulation-from-different-tabs-dashboard-worksheet-v3_expectedresult
Sheet: Risk Evaluation Summary

Risk Evaluation Summary |  |  |  | Risk Level
Practice Area | # of Current | # of Application | # of Infrastructure | High | Medium | Low
Finance Systems | 4 | 4 |  | 2 | 2 | 0
GS
HR
IT for IT | 1 | 1 | 2 |  |  | 2
Mkt & Sales | 2 | 2 |  |  | 1 | 1
Total
Spreadsheet: 94035d1293820348-getting-the-monthly-sums-back-to-the-monthly-wss-sums-back-to-the-monthly-wss
Sheet: FEBRUARY

 | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCES | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | Name | Entry date | Leaving date | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00 | 2010-03-29 00:00:00 | 2010-03-30 00:00:00 | 2010-03-31 00:00:00 |  | W | V | C | H | F | R
1 | P1 | 2009-10-31 00:00:00 |  |  | V | V | V | V | V | V | V |  | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
2 | P2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H |  | W | W
3 | P3 | 2008-11-24 00:00:00 |  |  |  |  |  |  | W | W |  |  |  |  |  |  |  |  |  | W | W |  |  |  |  |  |  |  |  |  | W
4 | P4 | 2009-06-05 00:00:00 |  |  |  |  |  |  | W | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C |  | W | W
5 | P5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  | W | W |  |  |  |  |  |  | W
6 | P6 | 2006-01-18 00:00:00 | 2010-03-03 00:00:00 |  |  |  |  |  | W | W |  |  |  |  |  | W | W | W | W | W |  | W | W | W |  |  |  |  |  | W | W
7 | P7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00 |  |  |  |  |  | W | W |  |  |  | W | W | W | W | W | W |  | W | W | W | W |  |  |  |  |  |  | W
8 | P8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 |  |  |  |  |  | W | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C |  |  | W
9 | P9 | 2010-03-03 00:00:00
10 | P10 | 2010-03-03 00:00:00
11 | P11 | 2010-04-22 00:00:00
12 | P12 | 2010-10-22 00:00:00
13 | P13 | 2010-11-23 00:00:00
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 | F: [NAME], V: Vacances, C: Clinique, U: Fugue, R: Réintégration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Spreadsheet: 749071d1632493516-sort-by-column-in-one-sheet-and-maintain-row-formula-references-in-another-sheet-test-metrics
Sheet: YTD

ISP | Hours Worked | Avg. ACD Talk Time | Auto-In Calls | Top Line Calls | Outbound Calls | Total Calls | Avg. Calls/Hour | ISP Emails | Clearslide Email Campaigns | Avg. Emails/Hour | Webinars Conducted | SF Leads Created | Avg. Work Volume/Hour | SF Tasks w/out Clearslide | SF Opp. | Total SF | Avg. SF/Hour | Clearslide Emails Sent | Total Contacts | Avg. Contacts/Hour
a
b
c
 |  | *if all months are sorted alphabetically by ISP name (column A), ISP "a" Avg. Calls/Hour = 5.02 (column H) which is correct
 |  | *If you sort by Total calls in Jan sheet, descending order - changed [NAME]. Calls/Hour (column H) value for ISP "a" to 5.7 which isn't correct
Spreadsheet: 275072d1383323016-inserting-blank-line-after-a-group-of-numbers-book1
Sheet: Sheet1

 |  | Before |  | After
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 99654 |  | 35784
 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 78458 |  | 99654
 |  | 78458 |  | 99654
 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  |  |  | 78458
 |  |  |  | 78458
 |  |  |  | 78458