tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769735d1645658876-sumifs-to-add-total-volume-for-specific-user-only-if-another-cell-contains-that-user-id-example
Sheet: Processor #'s

1 | 0 | username | ID | Name | 10 |  |  | code | Job | Subjob | 0.02286245353159851 |  |  | ACL_FL1 |  | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SUMIFS? | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  | [NAME] |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SUMIFS? | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  | ACL_FL3 |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SUMIFS? | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  |  |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Should return Blank | 0 | 0 | 0 | Should return Blank | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L tab if O2 Contains "ACL_FL1"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L  if [NAME] either "ACL_FL2" or "ACL_FL3"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L tab if O4 Contains either "ACL_FL2" or "ACL_FL3"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should return blank under both columns due to O5 being blank
Spreadsheet: 001a39e2-c873-4bb0-96db-912eb01abe56
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | ANNUAL UPDATE AREA
 | Fiscal Year | [NAME] | Federal Minimum |  |  | Only white cells can accept entries.  Gray or Blue are calculations
 | 2006 | 568.78 | 144.2 |  |  | 1.  Enter Injury Date (Use month, day and year format).
 | 2007 | 587.35 | 144.2 |  |  | NOTE: This entry will automatcially default to the correct "Injury Fiscal Year, calculated"
 | FY08 =>7/23/07 | 615.35 | 137.33 |  |  | 2.  Enter Wage Information
 | FY08 =>6/30/08 | 615.35 | 156 |  |  |  | [NAME] hourly wage and hours worked per week if known.
 | FY09 =>7/23/08 | 640.56 | 156 |  |  |  | [NAME] daily rate. (Both can be used)
 | FY09 =>6/30/09 | 640.56 | 174.67 |  |  |  | [NAME] beginning and ending date of each quarter for which wage information exists.
 | FY10 =>7/23/09 | 676.61 | 174.67 |  |  |  | d.  Enter corresponding quarterly wages.
 | FY10 =>6/30/10 | 676.61 | 193.33 |  |  |  |  | Note: If employee has been working less than one year, enter available information.  Otherwise
 | 2011 | 692.93 | 193.33 |  |  |  |  | employer has all wage information and must be entered.
 | 2012 | 711.38 | 193.33
 | 2013 | 741.65 | 193.33 |  |  | The wage calculator will pick the best daily wage and print "BEST" with an arrow beside it.
 | 2014 | 754.81 | 193.33 |  |  |  | (The daily rate best daily wage will be the daily rate times 5 divided by 7.
 |  |  |  |  |  |  | or is calculated from total days in a quarter.)
 | Near the end of each fiscal year,
 | the new [NAME] comp rate and federal
 | minimum will be emailed to self-
 | insured employers / TPA's for entry
 | above.
 |  |  |  |  |  | The wage calculator will multiply the the "BEST" daily rate times 7 times .6667 to arrive at the calculated
 |  |  |  |  |  |  | comp rate.
 |  |  |  |  |  | "USE THIS ONE" |  |  | will appear under the weekly rate to pay the claimant.
 |  |  |  |  | IMPORTANT:  Be sure to print the calculation for the claimant's file.
Spreadsheet: 793913d1661789513-array-formula-that-looks-up-and-returns-values-from-a-table-sequence-example
Sheet: Holidays Table

year | month | week | hours
2021 | Jan | 1 | 8
2021 | Jun | 2 | 16
2021 | Jul | 1 | 16
2021 | Sep | 2 | 24
2021 | Nov | 4 | 8
2021 | Dec | 5 | 8
2022 | Jan | 1 | 16
2022 | Feb | 2 | 24
2022 | Jul | 1 | 32
2022 | Sep | 2 | 8
2022 | Nov | 4 | 16
2022 | Dec | 5 | 8
Spreadsheet: 738304d1624963187-transposing-data-book1-51-ans2
Sheet: Transposed

Date | Year | Quarter | Conversion Currency | Currency Value |  |  |  |  |  | Date | Year | Quarter | Conversion Currency | Currency Value
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDCAD Curncy | 1.0117
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDCLP Curncy | 515.673
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDCZK Curncy | 18.1714
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDDKK Curncy | 5.013
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDHUF Curncy | 211.757
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDILS Curncy | 2.8311
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDJPY Curncy | 88.085
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDKRW Curncy | 855.6085
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDMXN Curncy | 12.6062
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDNZD Curncy | 1.0615
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDNOK Curncy | 6.47467
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDPLN Curncy | 2.8803
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDSEK Curncy | 6.1776
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDCHF Curncy | 0.7307
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDTRY Curncy | 2.1262
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDGBP Curncy | 0.4952
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDUSD Curncy | 0.7303
 |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  |  | AUDEUR Curncy | 0.6726
Spreadsheet: 729485d1619112194-how-to-avoid-div-0-error-in-solver-excel-solver-problem
Sheet: Sheet1

 | B9:B12 are known variables (user entry)
 | two equations in cell G10 and [NAME]
 | two unknown variables A and S in cells E10 and F10
 | The user likes to find the values for A and S for which G10=G11=0
 | the equations are written such that if A and S are solved, G10 and [NAME] are zero (or extremely small)
 | when using Solver you need to avoid the #DIV/0! Error in some creative way
 |  |  |  | NH3 | H2S
Temperature, °F | 100 |  |  | A | S
pressure, psia | 100 | 35-200 |  | 200 | 100 |  | eq.11 | min | -1e-05
NH3 (mol% in vap) | 2 | 0-10 |  |  |  |  | eq.12 | [NAME] | 1e-05
H2S (mol% in vap) | 5 | 0-10
pNH3, psia
pH2S, psia
a | 1.634936309588357
H0 | 0.04346339905559361
Spreadsheet: 808352d1670426372-fraction-vs-decimal-vlookup-approximate-copy-of-measurement-conversion-question
Sheet: Measurement Conversion Question

 |  |  |  |  |  |  | 0.03125 | 0.03125
 |  |  |  |  |  |  | 0.0625 | 0.0625
 |  |  |  |  |  |  | 0.09375 | 0.09375
 |  |  |  |  |  |  | 0.125 | 0.125
 |  |  |  |  |  |  | 0.15625 | 0.15625
 |  | INTEGER | DECIMAL | MEASUREMENT TO CLOSEST 32ND | CORRECT RETURN VALUE |  | 0.1875 | 0.1875
 | 238.147375 |  |  |  | 0.15625 |  | 0.21875 | 0.21875
 | 238.27635 |  |  |  | 0.28125 |  | 0.25 | 0.25
 | 238 |  |  |  | 0 |  | 0.28125 | 0.28125
 | 238.7815 |  |  |  | 0.8125 |  | 0.3125 | 0.3125
 | 238.834 |  |  |  | 0.84375 |  | 0.34375 | 0.34375
 | 238.999 |  |  |  | ADDITION OF 1 TO INTEGER |  | 0.375 | 0.375
 | 238.125 |  |  |  | 0.125 |  | 0.40625 | 0.40625
 | 238.456 |  |  |  | 0.46875 |  | 0.4375 | 0.4375
 | 238.334 |  |  |  | 0.34375 |  | 0.46875 | 0.46875
 | 238.001 |  |  |  | 0.03125 |  | 0.5 | 0.5
 |  |  |  |  |  |  | 0.53125 | 17/32
 |  |  |  |  |  |  | 0.5625 | 0.5625
 |  |  |  | RETURN VALUE NEEDED |  |  | 0.59375 | 0.59375
 |  |  |  | COMPARITIVE VALUE |  |  | 0.625 | 0.625
 |  |  |  |  |  |  | 0.65625 | 0.65625
 |  |  | RETURN VALUE IN COLUMN E10 THRU E19 TO RETURN CLOSEST DECIMAL CONVERSION TO AMERICAN STANDARD MEASUREMENT >/= ROUNDED TO CLOSES 1/32 |  |  |  | 0.6875 | 0.6875
 |  |  |  |  |  |  | 0.71875 | 0.71875
 |  |  |  |  |  |  | 0.75 | 0.75
 |  |  |  |  |  |  | 0.78125 | 0.78125
 |  |  |  |  |  |  | 0.8125 | 0.8125
 |  |  |  |  |  |  | 0.84375 | 0.84375
 |  |  |  |  |  |  | 0.875 | 0.875
 |  |  |  |  |  |  | 0.90625 | 0.90625
 |  |  |  |  |  |  | 0.875 | 0.875
 |  |  |  |  |  |  | 0.90625 | 0.90625
 |  |  |  |  |  |  | 0.9375 | 0.9375
 |  |  |  |  |  |  | 0.96875 | 31/32
Spreadsheet: 770130d1645818877-offset-with-count-not-working-horizontally-problem-child
Sheet: week5

[NAME]
Vance
Team 3
Team 4
Team 5
Team 6
Team 7
Team 8
Team 9
Team 10
Spreadsheet: 689284d1596257077-need-formula-to-count-by-two-way-lookup-book3_chris
Sheet: Sheet1

Criteria 1 | Criteria2 | Req.Result
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2 |  |  |  |  | Need to Count Criteria 1 based on criteria 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | WXYZ1490 | 2 |  |  | Count of Criteria 1 | Column Labels
03.ABC | WXYZ1490 | 2 |  |  | Row Labels | 03.ABC | 04.XYZ | 05.EFG | 16.PQR | Grand Total
03.ABC | [NAME] | 1 |  |  | WXYZ1330 |  |  |  | 2 | 2
03.ABC | [NAME] | 1 |  |  | [NAME] | 10 | 1 |  |  | 11
03.ABC | [NAME] | 1 |  |  | WXYZ1490 | 2 | 1 |  |  | 3
03.ABC | [NAME] | 1 |  |  | [NAME] | 8 |  |  |  | 8
03.ABC | [NAME] | 1 |  |  | WXYZ1510 | 5 |  | 1 |  | 6
03.ABC | [NAME] | 1 |  |  | Grand Total | 25 | 2 | 1 | 2 | 30
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
04.XYZ | [NAME] | 2
04.XYZ | WXYZ1490 | 2
05.EFG | WXYZ1510 | 2
16.PQR | WXYZ1330 | 1
16.PQR | WXYZ1330 | 1
Spreadsheet: 125739d1319205095-excel-2007-condiitonal-format-sheet-1-from-values-in-sheet2-example1
Sheet: Sheet2

0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.6 | 0.8 | 0.8 | 0.1 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.6 | 0.8 | 0.8 | 0.1 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.6 | 0.8 | 0.8 | 0.1 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.6 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.6 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.6 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.6 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.6 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.1 | 0.8 | 0.8 | 0.01 | 0.1 | 0.1 | 0.9 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9
0.1 | 0.1 | 0.1 | 0.01 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
Spreadsheet: 3dc0f1fc-70c0-45ad-a15c-40a408d835c0
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.55 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 11/01/12 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.55 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.55 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2013-05-17 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: darrell_schoolcraft__7895__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 1st = 65000
 |  |  | SoCal Gas Price |  | 2.69
 |  |  | San Juan Gas Price |  | 2.48
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 475 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 490 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 490 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 515 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 490 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 490 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 490 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 490 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 490 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 490 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 490 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 490 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 490 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 490 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 490 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 490 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 490 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 421 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 421 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 421 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 421 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 421 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 421 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 421 | 7
Spreadsheet: 812283d1673041163-formula-to-find-next-major-release-date-in-table-sample-release-dates-01062023
Sheet: Release Dates

Type | Release Date
Major | 2023-01-05 00:00:00
Minor | 2023-01-06 00:00:00
Minor | 2023-01-08 00:00:00
Minor | 2023-01-10 00:00:00
Major | 2023-01-12 00:00:00
Minor | 2023-01-13 00:00:00
Minor | 2023-01-15 00:00:00
Minor | 2023-01-18 00:00:00
Major | 2023-01-19 00:00:00
Minor | 2023-01-21 00:00:00
Minor | 2023-01-22 00:00:00
Minor | 2023-01-24 00:00:00
Major | 2023-01-26 00:00:00
Minor | 2023-01-27 00:00:00
Minor | 2023-01-28 00:00:00
Spreadsheet: 0596fe4a-2512-43bd-9d62-b035afe0d3ba
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | ФОРМА N
МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ГРАЖДАНСКОЙ АВИАЦИИ
ФОРМА ОТЧЕТНОСТИ ПО ВОЗДУШНОМУ ТРАНСПОРТУ
ВЫДАЧА СВИДЕТЕЛЬСТВ АВИАЦИОННОМУ ПЕРСОНАЛУ И ЕГО ПОДГОТОВКА
[NAME] для связи: |  |  |  | Государство:
Организация:
[NAME].: |  |  |  | Год:
Факс:
E-mail:
КВАЛИФИКАЦИЯ АВИАЦИОННОГО ПЕРСОНАЛА
Код ИКАО | Категория квалификации |  | [NAME] квалификации  (ежегодно) | Всего действующих  квалификаций | Число признаний  действительности/конверсий  (ежегодно) | [NAME]/конверсий | Возраст выхода на пенсию
 | a |  | b | c | d | e | f
 | 1 | ATPL
 | 2 | CPL
 | 3 | MPL
 | 4 | PPL
 | 5 | Квалиф. [NAME]
 | 6 | Специальные разрешения
 | 7 | [NAME] техобслуживанию
 | 8 | [NAME] диспетчера УВД
ПОТЕНЦИАЛ ПОДГОТОВКИ АВИАЦИОННЫХ СПЕЦИАЛИСТОВ В БУДУЩЕМ
Код ИКАО | Категория свидетельства |  | Учебные организации  (на текущий момент) | Учебные организации  (на 5 лет) | Потенциал подготовки  (на 5 лет)
 | g |  | h | i | j
 | 9 | Пилоты (PPL/CPL/ATPL)
 | 10 | Пилоты (MPL)
 | 11 | [NAME] техобслуживанию
 | 12 | [NAME] диспетчера УВД
Spreadsheet: kate_symes__18499__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 209079d1359013771-filter-data-by-key-in-criteria-keyinfilterdata
Sheet: Sheet2

 | Sales group | Sales district | Sales office |  | Customer A | [NAME]
 | ZAI | ZAE | ZAB |  | 100989 | 1994-08-04 00:00:00
 |  |  |  |  | 104347 | 2007-10-02 00:00:00
Spreadsheet: 740687d1626456720-filtering-specific-texts-and-its-corresponding-rows-and-then-being-able-to-toggle-between-book3
Sheet: Sheet1

 | Representative Data
 |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00
 | Loan Terms |  | Cash inflows / outflows
 | Origination Date | 2014-04-01 00:00:00 | Reserves Funding | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Payoff Date | 2016-03-01 00:00:00 | Initial Funding | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | LIBOR Floor |  | Origination Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Spread |  | Debt Service Income (Interest) | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | All-In Rate |  | Accrued Interest | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Internal rate of return |  | Minimum Interest | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Multiple on Invested Capital |  | Loan Paydown / Payoff | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | First Extension Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Second Extension Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Exit Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Total Cash Flow
 | Solution | Being able to toggle the cash inflows and outflows using a custom filter potentially? Where I could click to only display certain rows
 |  | of inflows and outflows therefore impacting the total cash flow, but then being able to re display them later.
 |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00
 | Loan Terms |  | Cash inflows / outflows
 | Origination Date | 2014-04-01 00:00:00
 | Payoff Date | 2016-03-01 00:00:00 | Initial Funding | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | LIBOR Floor |  | Origination Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Spread |  | Debt Service Income (Interest) | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | All-In Rate |  | Accrued Interest | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 | Internal rate of return
 | Multiple on Invested Capital |  | Loan Paydown / Payoff | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | First Extension Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Second Extension Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Exit Fee | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 0
 |  |  | Total Cash Flow
Spreadsheet: 791097d1660150946-sumproduct-with-date-11-8-2021-counting-unique-days-hd
Sheet: Data - Update 0208

Boekjaar / Periode | Dagboek | Datum | Bkst.nr. | Grootboekrekening | Omschrijving | Relatie | Kostenplaats | Kostendrager | Debet | Credit | Saldo
2022 - 1 | [NAME] | 2022-01-01 00:00:00 | 22600002 | 7000 - CEO | Vergoeding | 57 - Consultancy | [NAME] | KD100 - General & Staffuncties | 2500
2019 - 1 | [NAME] | 2019-02-25 00:00:00 | 19600355 | 7012 - Manager cultuur & ceremonies | werkzaamheden cultuurplan | 54 - Cultuur | KP20 - Marketing & communicatie | KD110 - Organizing Committee | 100
2021 - 12 | [NAME] | 2021-12-23 00:00:00 | 21600224 | 7014 - Manager marketing & communicatie | Advies | 7 - Bureau A | KP20 - Marketing & communicatie | KD220 - MarCom Personeel | 12320
2019 - 1 | [NAME] | 2017-12-31 00:00:00 | 19600187 | 7060 - Declaratiekosten | Voorgeschoten | 15 - Bureau B | KP20 - Marketing & communicatie | KD290 - Representatiekosten buitenland | 25.48
2022 - 2 | [NAME] | 2022-02-10 00:00:00 | 22600094 | 7060 - Declaratiekosten | Factuur 123 | 185 - Declarant 1 | [NAME] | KD130 - Overige organisatiekosten | 23.57
2022 - 2 | [NAME] | 2022-02-11 00:00:00 | 22600083 | 7060 - Declaratiekosten | Factuur werkzaamheden 1 | 69 - CEO | [NAME] | KD130 - Overige organisatiekosten | 284.88
2020 - 12 | [NAME] | 2020-12-11 00:00:00 | 20600017 | 7080 - Overige personeelskosten | Factuur werkzaamheden 2 | 69 - CEO | [NAME] | KD130 - Overige organisatiekosten | 52.25
2021 - 1 | [NAME] | 2021-01-18 00:00:00 | 21600058 | 7080 - Overige personeelskosten | Ontwerpkosten | 50 - Creatief n Co | [NAME] | KD110 - Organizing Committee | 210
2019 - 1 | [NAME] | 2019-10-02 00:00:00 | 19600353 | 7200 - Vormgeving algemeen | Vormgeving | 50 - Creatief n Co | KP20 - Marketing & communicatie | KD200 - Vormgeving | 1680
2019 - 1 | [NAME] | 2016-12-29 00:00:00 | 19600138 | 7200 - Vormgeving algemeen | Uren | 50 - Creatief n Co | KP20 - Marketing & communicatie | KD200 - Vormgeving | 1225
Transport