tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__15019__BridgeDPR0531
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 3137.7795368 | 5140.779536800001 | 10431.7795368
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 3137.7795368 | 5140.779536800001 | 10431.7795368
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 140374d1328723664-vlookup-versus-sumif-forumula-return-excelhelpfile
Sheet: Sheet1

 |  |  | Tools |  |  |  |  |  |  |  | [NAME] |  |  |  | Helper
 |  |  | #4 Center |  | I typed #4 Center |  |  |  |  |  | 9-E-C5 |  |  |  | 1
 |  |  | #5 Center |  | I typed #5 Center |  |  |  |  |  | 9-E-C3 |  |  |  | 1
 |  |  | #6 Center |  | copied cell from sheet2 |  |  |  |  |  | 9-E-C1 |  |  |  | 1
 |  |  | #4 Center |  | copied text from sheet2 |  |  |  |  |  | 9-E-C5 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 9-E-C5 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | 1
Spreadsheet: 794470d1662060971-using-index-match-with-a-condition-logistics-tracker-083022-error-correction
Sheet: Comparison Results

Order# DSV | Order#  Huber | No Matching Huber Order # | Booking Number (Huber) | Booking Flag | Current Date | Current Date Minus Scheduled Ship Date (Huber) | Estimated Pickup Date (DSV) | Scheduled Ship Date (Huber) | Late Pickup/Update Oracle | Scheduled Depature Date (DSV) | Vessel ETD (Huber) | Update Oracle | Scheduled Arrival Date (DSV) | Vessel ETA (Huber) | Update Oracle | Actual Departure Date (DSV) | Actual Ship Date (Huber) | Container In Transit | Actual Departure Date (DSV) | ATD (Huber) | Order Invoice Trigger
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 3. HBV

 |  | HBV screening |  |  |  |  | HBV screening
 |  | HBV NAT is performed using:
 |  | Commercial assay |  |  |  |  | HBV NAT is performed using:
 |  |  |  |  |  |  | Commercial assay | 0
 |  | please specify supplier |  |  |  |  | please specify supplier | 0
 |  |  |  |  |  |  | please specify test used | 0
 |  | please specify test used |  |  |  |  | In house assay please indicate : | 0
 |  |  |  |  |  |  | technology used  (e.g. PCR, real-time PCR, TMA etc.) | 0
 |  | In house assay |  |  |  |  | sensitivity
 |  | please indicate : |  |  |  |  | 95% detection limit in IU/ml with respect to 1 ml of individual donor plasma) | 0
 |  |  |  |  |  |  | 50% detection limit in IU/ml with respect to 1 ml of individual donor plasma) | 0
 |  | technology used  (e.g. PCR, real-time PCR, TMA etc.) |  |  |  |  | specificity (%) | 0
 |  |  |  |  |  |  | HBV genotypes covered by the assay | 0
 |  | sensitivity
 |  |  |  |  |  |  | HBV NAT is performed as
 |  | 95% detection limit in IU/ml (with respect to 1 ml of individual donor plasma) |  |  |  |  | individual donation NAT (ID NAT) | 0
 |  |  |  |  |  |  | mini pool NAT | 0 | 0
 |  | 50% detection limit in IU/ml (with respect to 1 ml of individual donor plasma)
 |  | specificity (%)
 |  | HBV genotypes covered by the assay
 |  | HBV NAT is performed as
 |  | individual donation NAT (ID NAT)
 |  | mini pool NAT (please indicate pool size)
 |  |  |  | Page 25 of 34
Spreadsheet: 155197d1336713881-sumproduct-with-2-criteria-sal-sac
Sheet: Salary Sacrifice

27100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Smith, [NAME]
27100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Doe, [NAME]
28650 | [NAME] SuperEzy Empee Extra Cont Value |  |  | Doe, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Frankston, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME], [NAME]
37100 | CBUS SS SSAC - CBUS SelfSelect Salsac Empee Value |  |  | [NAME], [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME], [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Kukikier, Oz
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME], [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Lam, Tham
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Nugget, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Richie, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Te Are, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Victory, Adelaide
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Fox, [NAME]
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Fox, Mulder
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Scully, Mary
37100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Rambo, [NAME]
38255 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Stallone, [NAME]
38650 | [NAME] SuperEzy Empee Extra Cont Value |  |  | Hall, John
38650 | MACQUARIESS - Macquarie Salary Sacrifice Value |  |  | King, [NAME]
38860 | [NAME] SuperEzy Empee Extra Cont Value |  |  | [NAME], [NAME]
38860 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Balog, [NAME]
38860 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Wilde, [NAME]
57100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME], [NAME]
57100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Doctor, [NAME]
57100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Woof, [NAME]
67100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | [NAME], [NAME]
67100 | [NAME] SuperEzy Empee Extra Cont Value |  |  | [NAME], [NAME]
67100 | CBUS SALSAC - CBUS Employee Salary Sacrifice Value |  |  | Chio, [NAME]
67100 | BTSUP SS - BTFinancial Salary Sacrifice Value |  |  | Phillips, [NAME]
Spreadsheet: 35535d1233148325-list-question-practice
Sheet: Sheet1

 |  | Forage Species | Stage of Maturity to | Plant Height to | Minimum | Estimated
 |  |  | Harvest for Highest | [NAME] | Cutting Height | Regrowth
 |  |  | Quality |  |  | Period
 |  | [NAME] | Very early bloom | 12 inches | 8 inches | NA*
 |  | [NAME] | Early to full bloom | 12 inches | 3-4 inches | 30-35 days
 |  | Alyceclover | Early to full bloom | 8 inches | 3-4 inches | NA
 |  | Bahiagrass | NA | 6-12 inches | 2 inches | 28-35 days
 |  | Bermudagrass | NA | 14-16 inches | 3-4 inches | 28-35 days
 |  | Carpon desmodium | Early to full bloom | NA | 3-4 inches | NA
 |  | Clovers | Early to full bloom | NA | 3-4 inches | 35-42 days
 |  | Grasses, perennial | NA | 14-16 inches | 3-4 inches | 5-7 weeks
 |  | Hemarthria (Limpograss) | NA | 14-16 inches | 3-4 inches | 28-35 days
 |  | [NAME] | Very early bloom | 14-16 inches | 4 inches | NA
 |  | Millet | Early Boot | NA | 6-8 inches
 |  | Oats | Milk to soft dough | NA | 2-3 inches | NA
 |  | Pangolagrass | NA | 12-18 inches | 3-4 inches | 35 days
 |  | [NAME] | Early Boot | NA | 6-8 inches | NA
 |  | Perennial Peanut | Early to full bloom | 10-12 inches | 2-3 inches | 6 weeks
 |  | Rhodesgrass | NA | 14-16 inches | 3-4 inches | 28-35 days
 |  | Rye | Boot to early head | NA | 2-3 inches | NA
 |  | Ryegrass | Early to full bloom | NA | 2-3 inches | NA
 |  | Stargrass | NA | 14-16 inches | 3-4 inches | 28-35 days
 |  | Sorghum | Boot to soft dough | NA | 6-8 inches | NA
 |  | Sudangrass | Early Boot | NA | 6-8 inches | NA
 |  | Wheat | Early head to soft dough | NA | 2-3 inches | NA
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 13 - Data

[NAME]
Focus Area 13 - HIV - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
13-01 | AIDS (aged 13+) Incidence (rate per 100,000 population) | 15.0 (2000) | 9.2 (2008) | 1 | Moved toward target
13-02 | New AIDS (aged 13+) Cases among Men who have Sex with Men (number of cases) | 382 (2004) | 284 (2008) | 25% Less | Met or exceeded target
13-03 | New AIDS (aged 13+) Cases among Persons who Inject Drugs (number of cases) | 325 (2004) | 150 (2008) | 25% Less | Met or exceeded target
13-04 | New AIDS (aged 13+) Cases among Men who have Sex with Men and Inject Drugs (number of cases) | 36 (2004) | 25 (2008) | 25% Less | Met or exceeded target
13-11 | Persons (aged 25-44) with Tuberculosis who have been Tested for HIV (percentage) | 63 (1997) | 86 (2008) | 85 | Met or exceeded target
13-14 | HIV Disease Deaths (age-adjusted per 100,000 population) | 9.0 (1996) | 2.3 (2008) | 0.7 | Moved toward target
13-17b | New Cases of Perinatally Acquired AIDS (number of cases) | 4 (2004) | 6 (2008) | Reduce | Moved away from target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 118835d1314038076-excel-2007-vlookup-return-multiple-values-swap-tracker-1-
Sheet: Swap Lookup

 |  |  |  |  |  | ID Utopia | 21384
Swaps Combined |  | Agent Search |  | BOUNDAOUI, MOHAMMED |  | Aspect | 23839
2011-09-24 00:00:00
BOUNDAOUI, MOHAMMED |  | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | COULIBALY, AMADOU | 2011-09-25 00:00:00
2011-09-25 00:00:00 |  | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | SAYAD, ILYAS | 2011-09-26 00:00:00
GHAZALI, MAHDI
2011-09-26 00:00:00
NAWALAGUEMBA, YAMEOGO THEOPHANE
2011-09-27 00:00:00
NAWALAGUEMBA, YAMEOGO THEOPHANE
2011-09-28 00:00:00
OSSETÉ, CEDRIC JOHAN
2011-09-29 00:00:00
[NAME], ZIZINA
2011-09-30 00:00:00
[NAME], ZIZINA
(vide)
(vide)
Total général
Spreadsheet: 834774d1688067476-help-on-reverse-engineering-single-input-calculator-dh-volume-calcuator
Sheet: Volume Calculation

 | [NAME] FOR NEW CALCULATIONS
 | GRAVITY CORRECTION |  |  |  | OBSERVED GRAVITY |  |  | 23.964
 | TABLE | 5A |  |  | OBSERVED TEMPERATURE |  |  | 86.35
 |  |  |  |  | API GRAVITY AT 60 F |  |  | 22.3
 |  |  |  |  | AVERAGE TEMPATURE -OR-
 | TEMPERATURE CORRECTION |  |  |  | OBSERVED TEMPERATURE |  |  | 90.35
 | TABLE | 6A
 |  |  |  |  | VOLUME CORRECTION FACTOR
 |  |  |  |  | CTL |  |  | 0.98925
 | PRESSURE CORRECTION |  |  |  | AVERAGE PRESSURE |  |  | 36
 |  |  |  |  | VOLUME CORRECTION FACTOR
 |  |  |  |  | CPL |  |  | 1.00016
 |  |  | VOLUME CALCULATION
 | [NAME] FOR NEW CALCULATIONS
 |  | ENTER |  | (1) |  | GROSS IND VOL |  | 144.13
 |  | ENTER |  | (2) |  | [NAME] |  | 1.0003
 |  | ( CALC.  ABOVE ) |  | (3) |  | CTL |  | 0.98925
 |  | ( CALC.  ABOVE ) |  | (4) |  | CPL |  | 1.00016
 |  |  |  | (5) = (2) X (3) X (4) |  | CCF |  | 0.9897051024839998
 |  |  |  | (1) X (5) |  | GROSS STD VOL |  | 142.6461964210189
 |  |  |  | ENTER  S & W |  | 1.1568 | % | 0.988432
 |  |  |  |  |  | NET STD VOL |  | 140.9960652208205
 | RUN 2
 | GRAVITY CORRECTION
 | TABLE | #N/A
 | OBSERVED | #N/A | @ | #N/A
 | CORRECTED TO 60 | #N/A
 |  | #N/A |  |  | #N/A | #N/A
 |  |  | [NAME] | k1 | #N/A | #N/A | #N/A | #N/A | #N/A
 | CRUDE (15-65) | 1 | 341.0957 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 | GASOLINE (50.1-85.0) | 2 | 192.4571 | 0.2438 | #N/A | #N/A | #N/A | #N/A | #N/A
 | JET (37.1-50.0) | 3 | 330.301 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 | DIESEL (0-37.0) | 4 | 103.872 | 0.2701 | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 | TEMPERATURE CORRECTION FACTOR FOR LIQUID |  |  |  |  | PRESSURE CORRECTION FACTOR FOR LIQUID
 | AVERAGE TEMPERATURE |  |  | #N/A |  | AVERAGE PRESSURE |  |  | #N/A
 | #N/A | #N/A |  | #N/A |  | 2.695 |  |  | #N/A
 | RUN 3
Spreadsheet: 146498d1332219257-need-help-with-if-vlookup-needs-tweaking-or-changed-completely-sample-measures-workbook
Sheet: Sales Quote

 | Rough opening width, inches | Finished width, inches
1 | 11 |  | correct
2 | 12 |  | wrong, should be 26.75
3 | 13 |  | wrong, should be 26.75
4 | 14 |  | wrong, should be 26.75 | measurements in Column B are done manually, is there any way to fix colunm C  without adding five rows with same value in between row on reference sheet?    Wow, 405 extra rows!
6 | 15 |  | wrong, should be 26.75
7 | 16 |  | wrong, should be 26.75
8 | 17 |  | correct
9 | 18 |  | wrong, should be 33.25
10 | 19 |  | wrong, should be 33.25
11 | 20 |  | wrong, should be 33.25
12 | 21 |  | wrong, should be 33.25
13 | 22 |  | wrong, should be 33.25
14 | 23
15 | 24
16 | 25
Spreadsheet: 128027d1320752230-is-there-a-way-of-using-if-to-look-up-values-to-create-a-result-opex-only-count
Sheet: Sheet1

ID No. | Item | Opex Stock | Con Stock | Capex Stock |  | Result | Correct
001 | Bottle | 1 | 0 | 0 |  | 0 | No
002 | Cup | 0 | 1 | 1 |  | 1 | No
003 | Dish | 10 | 1 | 0 |  | 1 | yes
004 | Spoon | 1 | 0 | 1 |  | 1 | yes
005 |  | 0 | 0 | 0 |  | 1 | No
006 | Ladle | 0 | 2 | 0 |  | 1 | No
007 | Fork | 1 | 0 | 0 |  | 0 | No
008 |  | 0 | 0 | 0 |  | 1 | No
009 | Knife | 2 | 1 | 1 |  | 1 | Yes
 |  | Key -
 | The formula must look to see if there is any information in the items column before proceeding with the calculation
 | The caluclation needs to return the amount of lines where opex only stock is present, however if no stock is present in the con stock or capex stock column then the calculation also must count the opex line even it is zero as it is classed as an active line.
Spreadsheet: 470793d1468661490-sorting-two-different-values-book1
Sheet: R Sort

 | Status | Opened |  | Unit | R
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 36855 | 36855
Cross_Currency Fixed-Fixed | 0 | 7952 | 7952
Cross_Currency Fixed-Float | 0 | 5633 | 5633
TOTAL | 0 | 50440 | 50440
Spreadsheet: 752964d1635154726-move-start-of-week-to-new-tab-week-example-pr1
Sheet: February

 |  |  | Incorrect
 |  |  |  |  |  |  |  |  |  | Correct
 | Week |  |  |  |  |  |  |  | Week
 | 1 |  |  |  | So, this date should be 31/01/2021 |  |  |  | 1 | 2021-01-31 00:00:00
 |  |  |  |  | Week 1 would be 31/01
 |  | day | date |  |  |  |  |  |  | date
 |  | Sunday
 |  | Monday |  |  | If I leave the dates to calculate over
 |  | Tuesday |  |  | the weeks go out of sequence
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week |  |  |  |  |  |  |  | Week
 | 2 | commencing date: |  |  |  |  |  |  | 2
 |  | day | date |  |  |  |  |  |  | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week |  |  |  |  |  |  |  | Week
 | 3 | commencing date: |  |  |  |  |  |  | 3
 |  | day | date |  |  |  |  |  |  | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week |  |  |  |  |  |  |  | Week
 | 4 | commencing date: |  |  |  |  |  |  | 4
 |  | day | date |  |  |  |  |  |  | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 |  |  |  |  |  |  |  |  |  |  | this week would need to be week 1 in March and so on
 | Week |  |  |  |  |  |  |  | Week
 | 5 | commencing date: |  |  |  |  |  |  | 5
 |  | day | date |  |  |  |  |  |  | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
Spreadsheet: 175247d1345470290-bubble-chart-showing-zones-and-month-values-bubble-chart
Sheet: Sheet1

 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00
WC | 9 | 4 | 9 | 2 | 4 | 7 | 13
DBN | 1 | 1 | 1 | 1 | 2 | 12 | 5
PTA | 5 | 9 | 5 | 5 | 5 | 5 | 3
NWP | 3 | 3 | 7 | 7 | 3 | 5 | 8
EC | 3 | 3 | 7 | 8 | 3 | 5 | 4
Spreadsheet: 722777d1615402034-exclude-row-from-sum-and-sumproduct-formula-helpbook1
Sheet: Sheet1

 |  | April / Avril
FY |  | 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
2020/21 |  | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
A SHIFT
A1 | Employee |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N
A2 | Employee | N | N |  |  |  |  |  | D | D | N | N | N |  |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N
A3 | Employee |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N |  |  |  |  | D | D | D | N | N
B SHIFT
B1 | Employee |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N |  |  |  |  | D | D | D | N | N
B2 | Employee | D | D | N | N | N |  |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D
Exclude |  | D | D | N | N | N |  |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D
C SHIFT
C1 | Employee | N | N |  |  |  |  |  | A | A | A | A | A |  |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N
C2 | Employee |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N |  |  |  |  | D | D | D | N | N
[NAME] | Employee
D SHIFT
D1 | Employee | D
D2 | Employee |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N
D3 | Employee
Exclude |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D | N | N | N
ARAF
R1 | Employee |  |  | N |  |  |  |  |  |  | N | N | N |  |  |  |  |  | N |  |  |  |  | N | N | N |  |  | N
 |  |  |  |  |  |  |  | Lt PAVLOV |  |  |  |  |  |  | PO1 TREMBLAY |  |  |  |  |  |  | Sgt SIEGERT |  |  |  |  |  |  | MCpl SCOTLAND
 | Employee | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d
 | Employee | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d
 | Employee | D | D | N | N | N |  |  |  |  | D | D | D | N | N |  |  |  |  |  | D | D | N | N |  |  |  |  |  | D | D
 | Employee |  | d | d |  |  | d | d | d | d |  |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d
 | Employee | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d | d |  |  | d | d | d | d
 | Employee | d | d | d
 | Days
 | Nights
Spreadsheet: 154177d1336276984-excel-2007-sum-based-on-range-and-multiple-worksheet-xyz-product
Sheet: Accounting

Category | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Project | 0.65625 | 0.34375 | 0.46875 | 0.59375 | 0.3125 | 0.375 | 0.5 | 0.6875
Budget Allocation | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
bookeeping | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Talent | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
Internal Training | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Market Survey | 75 | 25 | 45 | 65 | 20 | 30 | 50 | 80
Spreadsheet: 794435f0-e4f8-47f4-96a5-a4b54b478744
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Print Music, Word Owned * | 80689559280 | Word Music | If [NAME] | 2014-04-08 | Vocal Folio | Na | 19.95 | Y | NYP
Print Music, Word Owned * | 80689558283 | Various | Wow Worship 2014 | 2014-03-25 | Vocal Folio | Na | 32.95 | Y | NYP
Print Music, Word Owned * | 80689557286 | Various | Wow Hits 2014 | 2014-02-11 | Vocal Folio | Na | 32.95 | Y | Available
[NAME] | 38081473475 | [NAME] | The Best Of [NAME] (Medium Low W/ Cd) | 2014-01-28 | Vocal Folio | Na | 26.99 | Y | Available
[NAME] | 38081473468 | [NAME] | The Best Of [NAME] (Medium Low) | 2014-01-28 | Vocal Folio | Na | 16.99 | Y | Available
[NAME] | 38081473437 | [NAME] | The Best Of [NAME] (Medium High W/ Cd) | 2014-01-28 | Vocal Folio | Na | 26.99 | Y | Available
[NAME] | 38081473420 | [NAME] | The Best Of [NAME] (Medium High) | 2014-01-28 | Vocal Folio | Na | 16.99 | Y | Available
[NAME] | 38081471136 | [NAME] | Sunday Morning Special Services Companion | 2014-02-25 | Piano Folio | Na | 24.99 | Y | Available
[NAME] | 38081473925 | [NAME] | Songs Of Healing & Hope (Med High Vocal) | 2014-02-25 | Vocal Folio | Na | 16.99 | Y | Available
[NAME] | 38081463407 | Jan Sanborn | [NAME] Praise Favorites | 2014-03-25 | Piano Folio | Na | 12.99 | Y | Available
[NAME] | 38081470115 | [NAME] | What Praise Can I Play For Easter? | 2014-03-25 | Piano Folio | Na | 12.99 | Y | Available
[NAME] | 38081464220 | [NAME] | The Contemporary Service | 2014-04-22 | Piano Folio | Na | 14.99 | Y | Available
[NAME] | 38081464237 | [NAME] | The Traditional Service | 2014-04-22 | Piano Folio | Na | 14.99 | Y | Available
Spreadsheet: 785905d1656826021-interpolated-value-from-value-list-interpolated_value
Sheet: Foglio1

Temp [°C] | value
-50 | 5
0 | 10
50 | 25 |  |  | insert here a temperature |  |  |  | here obtain the interpolated value
100 | 50 |  |  | 400 | °C | -->  -->  -->
200 | 100
300 | 150
400 | 200
Spreadsheet: 024496e0-7f30-4bc1-8ec9-f5faece02fdd
Sheet: Charges

Monthly OATT Schedule 1 Through or Out Service (TOUT) Settlement
TR_OATTSCH1TOUT_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer Details |  |  |  |  | Charge Details
[NAME] Number | [NAME] Name | Point of Receipt | Point of Delivery | Reservation Amount | OATT Schedule 1 Rate | OATT Schedule 1 TOUT Charge
String | String | String | String | MWh | $/MW-Hour | $
Spreadsheet: 220039d1363038663-counting-days-formula-formulas
Sheet: Formula 2 Result

Date 1 | 2012-07-27 00:00:00 | 2012-08-28 00:00:00 | 2012-09-29 00:00:00 |  | 1st applicable value | 2nd applicable value
2012-06-17 00:00:00 |  |  |  |  | 40 | 72
2012-06-18 00:00:00 |  |  |  |  | 39 | 71
2012-06-19 00:00:00 |  |  |  |  | 38 | 70
2012-06-20 00:00:00 |  |  |  |  | 37 | 69
2012-06-21 00:00:00 | not applicable |  |  |  | 68 | 100
2012-06-22 00:00:00 | not applicable |  |  |  | 67 | 99
2012-07-08 00:00:00 | not applicable |  |  |  | 51 | 83
2012-07-09 00:00:00 | not applicable |  |  |  | 50 | 82
2012-07-10 00:00:00 | not applicable |  |  |  | 49 | 81
2012-08-11 00:00:00 | not applicable | not applicable |  |  | 49 | n/a
2012-09-12 00:00:00 | not applicable | not applicable |  |  | 17 | n/a
Spreadsheet: 132506d1323793952-excel-2007-lookup-with-column-and-row-book2
Sheet: Sheet1

 | 12 | 15 | 18 | 20 | 24 |  |  | Amount | 4000
0 | 110 | 120 | 135 | 165 | 205 |  |  | Term | 20
1501 | 135 | 150 | 170 | 200 | 230 |  |  | Total | 380
2001 | 160 | 180 | 195 | 230 | 260
2501 | 180 | 195 | 215 | 255 | 305
3001 | 195 | 215 | 240 | 295 | 345
3500 | 0.06 | 0.07 | 0.08 | 0.095 | 0.11