tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766712d1644010170-sumproduct-name-range-help-valuation-testing
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Test Book Value
 |  | 0 | 1500 | 5000 | 10000 |  |  |  |  |  | EE Count | 10001
 |  | 1500 | 5000 | 10000 |  | Tier Differentials
 | Products: | Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 1 | [NAME] | Tier 3 | [NAME] | Monthly | Annual | [NAME]
 | Product 1 | 8 | 4 | 2.5 | 2.5
AB | Product 2 |  |  |  | 2
BC | Product 3 | 1.5 | 1.5 | 0.75 | 0.4
etc | Product 4 | 1.5 | 1.5 | 0.75 | 0.4
 | Product 5 | 1.5 | 1.5 | 0.75 | 0.4
 | Product 6 | 3 | 3 | 1.5 | 0.75
PR | Product 7 | 2 | 2 | 1 | 0.5
 | Product 8 | 1.5 | 1.5 | 0.75 | 0.4
 | Product 9 | 3.5 | 3 | 2.5 | 1.75
 | Product 10 | 2 | 1.75 | 1.5 | 1
 | Product 11 | 2 | 2 | 1 | 0.5
 | Product 12 | 2 | 1 | 0.6 | 0.3
 | Product 13 | 1 | 1 | 1 | 1
 | Product 14 | 0.25 | 0.25 | 0.25 | 0.25
 | Product 15 | 1 | 1 | 0.5 | 0.5
 | Product 16 | 4 | 2 | 1.5 | 0.75
 | Product 17 | 3 | 2.5 | 2 | 1
 | Product 18 | 2 | 1 | 1 | 0.5
 | Product 19 | 2 | 1 | 0.75 | 0.4
 | Product 20 | 2 | 1 | 0.75 | 0.4
 |  | =SUMPRODUCT(--(C28>{Tier1_EE,Tier2_EE,Tier3_EE,Tier4_EE}),--(C28-{Tier1_EE,Tier2_EE,Tier3_EE,Tier4_EE}),{PR_DIF1,PR_DIF2,PR_DIF3,PR_DIF4})
Spreadsheet: 79452d1279720045-excel-2007-conditional-average-across-multiple-sheets-bowlingtest
Sheet: Sheet4

[NAME] |  | Geran |  | [NAME] |  | [NAME]
- | 9 | - | 6 | - | 0 | - | 6
6 |  | 6 |  | 8 |  | 6 |  |  |  | = spare
9 |  | 9 |  | 10 |  | 10
7 |  | 8 |  | 14 |  | 7
7 |  | 9 |  | 6 |  | 8
8 |  | 7 |  | 8 |  | 10
9 |  | 10 |  | 8 |  | 7
6 |  | 5 |  | 10 |  | 9
4 |  | 2 |  | 7 |  | 6
9 |  | 3 |  | 8 |  | 12
- | 3 | - | 8 | - | 9 | - | 7
9 |  | 5 |  | 11 |  | 3
6 |  | 10 |  | 5 |  | 17
8 |  | 7 |  | 10 |  | 15
14 |  | 9 |  | 9 |  | 7
8 |  | 8 |  | 5 |  | 8
7 |  | 13 |  | 8 |  | 9
3 |  | 3 |  | 7 |  | 9
9 |  | 10 |  | 8 |  | 6
10 |  | 13 |  | 8 |  | 9
Spreadsheet: 827267d1682585773-filter-function-breaks-the-formula-sample-workbook2-aligw
Sheet: Sheet1

 | value1 | value2
 | 123 | a
 | 123 | a
 | 456 | a |  |  |  | AliGW:
 | 456 | b |  |  |  | Value | Count
 | 123 | b |  |  |  |  | 9
 | 123 | b |  |  |  | 123 | 6
 | 789 | a |  |  |  | 456 | 5
 | 456 | a
 | 123 | a
 | 123 | a
 | 456 | a
 | 456 | b
 | 123 | b |  |  |  | Desired outcome:
 | 123 | b |  |  |  | 789 | 9
 | 789 | a |  |  |  | 123 | 6
 | 789 | a |  |  |  | 456 | 5
 | 123 | a
 | 123 | a
 | 456 | a
 | 456 | b
 | 123 | b
 | 123 | b
 | 789 | a
 | 456 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 789 | a
 | 234 | b
 | 234 | b
 | 789 | a
 | 789 | b
Spreadsheet: 219003d1362640488-conditional-formating-cell-with-tolerance-sample
Sheet: FAI REPORT (2)

Inspection Report
First Article: |  |  |  | In-Coming: |  |  |  |  |  | Final:
Dwg No. / Rev : |  |  |  | Inspector Name : |  |  |  |  | Qty :
Product S/N : |  |  |  | Data of Inspection : |  |  |  |  | [NAME] :
Supplier ID : |  |  |  | P.O. / receiver No. : |  |  |  |  | N.C.R.No. :
Bubbled No. | Dimensional Char./  Dwg Notes |  |  | Tolerances |  | Inspection Data of Sample |  |  |  |  | Measurement Equipment | Remarks
 | ( Inch / Millimeter ) |  |  | Upper | Lower | 1 | 2 | 3 | 4 | 5
19 | c |  0.03 |  |  | - | -
20 | 0.13 |  |  | 0.05 | 0
21 | Ö 0.4 |  |  | - | -
22 | Ø83.70 |  |  | 0.13 | 0.13
23 | j |  Ø 0.13 m | A | B m |  |  | - | -
24 | Ø75.43 |  |  | 0.13 | 0.13
25 | j |  Ø 0.13 m | A | B m |  |  | - | -
26 | [NAME] |  |  | 0.13 | 0.13
27 | j |  Ø 0.40 m | A | B m |  |  | - | -
28 | 15.41 |  |  | 0.13 | 0.13
29 | 0.15 |  |  | 0.13 | 0.13
30 | 0.59                                                              0.45 |  |  | - | -
31 | Ø85.471  (2x) |  |  | 0.06 | 0.06
32 | j |  Ø 0.13 m | A | B m |  |  | - | -
33 | 0.40                                                           0.20 |  |  | - | -
34 | 30º |  |  | 0.5º | 0.5º
35 | 0.38 |  |  | 0.13 | 0.13
36 | R0.38 |  |  | 0.13 | 0.13
37 | 60º (4x) |  |  | 0.5º | 0.5º
38 | 49.5 |  |  | 0.13 | 0.13
39 | 60º |  |  | 0.5º | 0.5º
40 | 12º |  |  | 0.5º | 0.5º
41 | 12º |  |  | 0.5º | 0.5º
42 | Ø3.45 |  |  | 0.1 | 0.03
43 | Ø3.45 |  |  | 0.1 | 0.03
44 | 3.18 (DEPTH) |  |  | 0.13 | 0.13
45 | Ø5.56 |  |  | 0.13 | 0.13
46 | j| Ø 0.19 m | A |B m |D |  |  | - | -
47 | [NAME] |  |  | 0.13 | 0.13
48 | Ø100.00 |  |  | 0.13 | 0.13
49 | b | Ø 0.15 m | A |  |  | - | -
50 | 1/8-27 NPT                                            TAP DRILL THRU ONE WALL |  |  | - | -
51 | MIN 7 FULL THREADS |  |  | - | -
52 | [NAME] |D| A |B m |  |  | - | -
Measurement Equipment |  |  |  |  |  |  |  |  |  |  | Inspection Status
CMM: | Co-ordinate Measurement Machine |  |  |  | PG: | Pin Gauge
[NAME]: | Dial Indicator |  |  |  | PLG: | Plug Gauge |  |  |  |  | Passed (Qty) :
DM: | [NAME] |  |  |  | RG: | Radius Gauge
DT: | Dial Tester |  |  |  | SG: | Slip Gauge |  |  |  |  | Failed (Qty) :
HG: | Height Gauge |  |  |  | TG: | Thread Gauge
HT: | Hardness Tester |  |  |  | [NAME]: | [NAME] |  |  |  |  | Yield (%) :
IM: | Internal Micrometer |  |  |  | VI: | Visual Inspection
OM: | Outside Micrometer |  |  |  | TPG: | Thread Pitch Gauge
PP: | Profile Projector |  |  |  | BM: | [NAME]
Quality Team Disposition & Approval
 |  |  |  |  |  |  |  | **Conditional
Appointment |  |  | Name |  |  | Approved | Reject | Approve |  | Signature |  | Date
Remark :
Spreadsheet: 694529d1599661715-searching-text-in-a-colunm-and-returning-2-results-example
Sheet: Sheet1

Table1 |  |  |  |  | Table | Results after Comparing Colunm F with the Table 1
ID | Grp | Entity |  |  | Entity | ID | GRP
1 | AAA | Nom Entreprise 1 |  |  | Name Azer |  | CCC |  | 4 | CCC
2 | AAA | Company CityX |  |  | Name C | 5 | DDD |  | 5 | DDD
3 | BBB | Name DEPARTMENT |  |  | Public | 6 | DDD |  | 6 | DDD
4 | CCC | Name Azerty |  |  | Gov. [NAME] | 8 | EEE |  | 8 | EEE
5 | DDD | Name Co |  |  | Department Finance | 8 | EEE |  | 8 | EEE
6 | DDD | Compagny Public |  |  | Entreprise | 1 | AAA |  | 1 | AAA
7 | EEE | IT Department |  |  | Company CityX | 2 | AAA |  | 2 | AAA
8 | EEE | Gov. [NAME]
Spreadsheet: 846599d1697745191-multiple-search-criteria-excelent
Sheet: blad y

SEMANA:
 | Kilos stock principio [NAME] | 20 | 40 | 80 | 20 | 80 | 130 | 60
 | [NAME] a llenar
 | [NAME] en bolsas:
 | Kilos a producir
 | Nos queda a final semana
2023-10-16 00:00:00 |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | TOTAL
[NAME] | [NAME]
 | kilos
 | BATCH
 | date in numbers
 | LOT
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  | ok, ik ga het op een andere manier proberen. Ik wil in een cel de waarde hebben die terug te vinden is in een ander blad, genaamd 'blad x'. Ik wil dat de waarde gegeven wordt die correspondeerd met de datum in A10  in blad x in kolom C .  En daarna ook [NAME] die in cel  [NAME] staat en terug te vinden is kolom [NAME] blad [NAME] moet de waarde ook nog corresponderen die terug te vinden is in A11 en die waarde is terug te vinden in En als er geen waarde gevonden wordt moet de cel leeg blijven.
 | kilos
 | BATCH | 02 | 01
 | date in numbers
 | LOT
Fred | [NAME]
 | kilos
 | BATCH
 | date in numbers
 | LOT
[NAME] | kilos
 | BATCH |  |  |  |  |  |  | 01
 | date in numbers
 | Productnumber
 | LOT
OSCAR | kilos
 | BATCH |  |  | 02
 | date in numbers
 | Productnumber
 | LOT
ANDREU | kilos
 | BATCH
 | date in numbers
 | Productnumber
 | LOT
 | Kilos stock final del dia
Spreadsheet: 811841d1672828227-copy-whole-rows-if-condition-is-fulfilled-example-file-hd
Sheet: Data

Name | Start | Starts at | End | Ends at | All-day event | Reminder on/off | Reminder on | Reminder at | Organizer | Mandatory participants | Optional participants | Ressources | Information | Description | Categories | Location | Priority | Private | Kilometers | Vertraulichkeit | Show as | Duration | Day | Month | Year | Calendar week
Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00 | Off | On | 2023-03-06 00:00:00 | 08:45:00 |  |  |  |  |  |  | Blue |  | Normal | Off |  | Normal | 2 |  | Monday | March
Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00 | Off | On | 2023-03-06 00:00:00 | 10:45:00 |  |  |  |  |  |  | Yellow |  | Normal | Off |  | Normal | 2 |  | Monday | March
Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 |  |  |  |  |  |  | Green |  | Normal | Off |  | Normal | 2 |  | Tuesday | March
Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00 | Off | On | 2023-03-08 00:00:00 | 07:30:00 |  |  |  |  |  |  | Red |  | Normal | Off |  | Normal | 2 |  | Wednesday | March
Christmas | 2023-12-25 00:00:00 | 00:00:00 | 2023-12-26 00:00:00 | 00:00:00 | On | Off | 2023-12-23 00:00:00 | 14:00:00 |  |  |  |  |  |  | White |  | Normal | Off |  | Normal | 1
Spreadsheet: d75c9535-9e6a-479a-bd50-ab8f98f7a7a8
Sheet: Table 7.3

Monthly Statistical Bulletin
7.3 Overseas arrivals—visitors and settlers
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Visitors (a) (b) – '000
July | 446.8 | 492.3 | 493.6 | 498.2 | 529.9
August | 460.9 | 499.9 | 496.8 | 515.8 | 542
September | 473.3 | 503 | 477 | 519.5 | 551.6
October | 481.8 | 493.4 | 500.4 | 521.1 | 546.9
November | 465.6 | 495.3 | 496.8 | 525 | 542.1
December | 480.8 | 498.6 | 494.8 | 535.8
January | 477.7 | 499.7 | 497.4 | 524.2
February | 485.1 | 490.1 | 504.7 | 519.4
March | 487.5 | 475.3 | 506.5 | 531.8
April | 472.1 | 490.7 | 509.1 | 521.3
May | 480.5 | 495.1 | 502.4 | 525.9
June | 498.6 | 477.6 | 512.4 | 564.8
Annual | 5710.700000000001 | 5911 | 5991.9 | 6302.799999999999
Settlers (c) – '000
July | 11.17 | 9.71 | 11.45 | 11.74 | 11.77
August | 13.26 | 11.57 | 12.88 | 13.22 | 13.49
September | 12.55 | 10.83 | 12.72 | 12.48 | 12.19
October | 11.6 | 9.37 | 12.35 | 11.94 | 12.05
November | 11.61 | 9.43 | 12.89 | 11.56 | 11.38
December | 11.94 | 10.02 | 13.9 | 12.94
January | 11.47 | 10.51 | 14.21 | 12.39
February | 12.32 | 10.52 | 14.44 | 12.68
March | 12.89 | 11.61 | 14.7 | 14.09
April | 10.78 | 11.21 | 13.33 | 12.64
May | 10.54 | 10.99 | 12.65 | 13.15
June | 10.48 | 11.7 | 13.46 | 13.58
Annual | 140.61 | 127.47 | 158.98 | 152.41
(a) Monthly figures are seasonally adjusted.
(b) Visitors are overseas visitors whose intended stay in Australia is less than 12 months.
(c) Settlers are travellers who hold migrant visas, New Zealand citizens who indicate an intention to settle, and those who are otherwise eligible to settle. |  |  |  |  |  |  |  | Update
Source: ABS, Overseas arrivals and departures, Cat. no. 3401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& |  |  |  | 2014-02-12 00:00:00
Spreadsheet: 468425d1467293498-combinations-of-options-on-the-table-ef928_combinations
Sheet: Sheet1

 |  |  | Criteria | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | Total no. of options
 |  |  | No. of options
 |  |  | Values | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 2 |  |  |  |  | 2
 |  |  | Table of choices
 |  |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | combination | total
Spreadsheet: 167981d1342178559-help-with-data-validation-using-indirect-function-forum_indirectdropdownor
Sheet: Sheet1

Account | Account | Type | Classification | Description |  | COLUMN A |  | COLUMN B |  |  | COLUMN C |  |  |  |  |  | COLUMN D
Area | Column1 | Column2 | Column3 | Column4 |  | Account |  | Bank | Bookmaker |  | Banking | Banking | Banking | Banking | Banking |  | Banking | Banking | Banking | Banking | Banking | Bookmaker | Bookmaker
Banking | Lloyds_TSB | Debit |  |  |  | Area |  | Accounts | Accounts |  | Lloyds_TSB | Barclays_Bank | Halifax_Bank | Nationwide_Bank | Natwest_Bank |  | Lloyds_TSB | Barclays_Bank | Halifax_Bank | Nationwide_Bank | Natwest_Bank | 188bet | Betfair
Banking | Barclays_Bank | Credit |  |  |  | Banking |  | Barclays_Bank | 188bet |  | Debit | Debit | Debit | Debit | Debit |  | Debit | Debit | Debit | Debit | Debit | Transfer | Transfer
Bookmaker | 188bet | Win |  |  |  | Bookmaker |  | Halifax_Bank | 10Bet |  | Credit | Credit | Credit | Credit | Credit |  | Credit | Credit | Credit | Credit | Credit | Charge | Charge
Banking | Halifax_Bank | Charge |  |  |  |  |  | Lloyds_TSB | 12bet.com |  | Charge | Charge | Charge | Charge | Charge |  | Charge | Charge | Charge | Charge | Charge | Correction | Correction
Bookmaker | Betfair | Bet |  |  |  |  |  | Nationwide_Bank | 32 Red |  | Correction | Correction | Correction | Correction | Correction |  | Correction | Correction | Correction | Correction | Correction | [NAME]. | [NAME].
Banking | Nationwide_Bank | Correction |  |  |  |  |  | Natwest_Bank | 5 Dimes |  | StartBal. | StartBal. | StartBal. | StartBal. | StartBal. |  | StartBal. | StartBal. | StartBal. | StartBal. | StartBal. | Win | Win
Banking | Natwest_Bank | Debit |  |  |  |  |  |  | 888Sport |  |  |  |  |  |  |  |  |  |  |  |  | Lose | Lose
 |  |  |  |  |  |  |  |  | All You Bet |  |  |  |  |  |  |  |  |  |  |  |  | Confiscation | Confiscation
 |  |  |  |  |  |  |  |  | Bet 365 |  |  |  |  |  |  |  |  |  |  |  |  | Bet | Bet
 |  |  |  |  |  |  |  |  | Bet Red Kings
 |  |  |  |  |  |  |  |  | Bet3000
 |  |  |  |  |  |  |  |  | Bet-At-Home
 |  |  |  |  |  |  |  |  | BETDAQ
 |  |  |  |  |  |  |  |  | Betfair
 |  |  |  |  |  |  |  |  | Betfred
 |  |  |  |  |  |  |  |  | BetOnline
 |  |  |  |  |  |  |  |  | Betsonic
 |  |  |  |  |  |  |  |  | Betsson Sportsbook
 |  |  |  |  |  |  |  |  | Blue Square
 |  |  |  |  |  |  |  |  | Bodog
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Boylesports
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | comeon!
 |  |  |  |  |  |  |  |  | Coral
 |  |  |  |  |  |  |  |  | Dobet
 |  |  |  |  |  |  |  |  | Eurobet
 |  |  |  |  |  |  |  |  | Expekt
 |  |  |  |  |  |  |  |  | gamebookers
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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
Spreadsheet: 174758d1345173815-conditional-formating-issue-example
Sheet: Sheet1

[NAME] | 3 | 5 | 5
[NAME] | 5 | 5 | 4
Low # |  |  |  |  | How would I highlihgt the 3 red if it is from [NAME] and blue if from [NAME]?
[NAME] | 3 | 5 | 5 |  | Or how would I just highlight the lower of the two in the rows [NAME]?
[NAME] | 5 | 5 | 4
Low # | 3 | 5 | 4
Spreadsheet: 669669d1585540002-running-total-based-on-multiple-criteria-sumproduct-car-match-counter
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Date | model | Sale | RunCount
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: MAR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  |  |  |  |  |  |  |  |  | A |  | C
 |  |  |  |  |  |  |  |  |  | B |  | D
C |  | C |  | C |  | B |  | B |  | B |  | B
D |  | D |  | D |  | A |  | A |  | A |  | A
D |  | D |  | D |  | D |  | A |  | A |  | A
C |  | C |  | C |  | C |  | B |  | B |  | B
A |  | C |  | C |  | C |  | C |  | B |  | B
B |  | D |  | D |  | D |  | D |  | A |  | A
B |  | B |  | D |  | D |  | D |  | D |  | A
A |  | A |  | C |  | C |  | C |  | C |  | B
A
B
Spreadsheet: 59114d1259581915-graphic-y-f-x-has-become-crazy-entretien
Sheet: Honda Civic

Date | km | Opérations | [NAME] | Garage
1993-07-22 00:00:00 | 0 | [NAME] |  | Du [NAME]
1993-08-31 00:00:00 | 1983 | Vidange | 99.74586748826523 | Du [NAME]
1993-09-14 00:00:00 | 2200 | Réparation carrosserie suite accident | 1316.003945380566 | Du [NAME]
1993-09-15 00:00:00 | 2200 | Installation alarme | 5863.94 | Du [NAME]
1993-09-16 00:00:00 | 2200 | Tapis | 70.87507260384446 | Du [NAME]
1994-05-27 00:00:00 | 11142 | Révision |  | Du [NAME]
1995-04-20 00:00:00 | 18696 | Révision | 298.774157452394 | Du [NAME]
1996-06-25 00:00:00 | 30481 | Vidange | 189.5581570133408 | Du [NAME]
1997-03-20 00:00:00 |  | Révision | 543.2231076122367
1997-09-18 00:00:00 | 44756 | Changement 2 pneus | 262.8937567553971 | Cent Mille Pneus Boulogne
1997-09-19 00:00:00 | 44785 | Contrôle technique | 51.83266586071953 | [NAME]
1997-10-21 00:00:00 | 45552 | Déconnexion de l'alarme | 23.7774732185189 | [NAME]
1998-04-15 00:00:00 | 50312 | Révision | 150.8787923598651 | [NAME]
1999-08-30 00:00:00 | 59685 | Changement pot échappement | 157.42 | [NAME]
1999-09-02 00:00:00 | 59767 | Révision Changement plaquettes AV | 326.3034009851255 | [NAME]
1999-11-05 00:00:00 | 60734 | Contrôle technique | 56.40613637784184 | Auto Sécurité Versailles
2000-01-24 00:00:00 | 61989 | Réparation carrosserie suite tempête | 1906.25 | Ravier Boulogne
2001-05-16 00:00:00 |  | Dépannage (panne pompe essence) | 155.6245302664657 | Honda Versailles
2002-03-14 00:00:00 | 72189 | Contrôle technique |  | Auto sécurité Le Chesnay
2003-05-17 00:00:00 | 77240 | Vidange | 60 | [NAME]
2004-03-01 00:00:00 | 80524 | Contrôle technique |  | Auto sécurité Le Chesnay
2004-04-01 00:00:00 | 80920 | Contre visite contrôle technique | 22 | Auto sécurité Le Chesnay
2004-04-01 00:00:00 | 80925 | Changement 2 pneus AV Révision |  | [NAME]
2006-06-03 00:00:00 | 91324 | Contrôle technique | 62 | Autovision Versailles
2007-03-24 00:00:00 | 96732 | Changement pneus [NAME] | 155.18 | [NAME]
2007-07-28 00:00:00 | 99535 | [NAME] huile | 49.9 | [NAME]
2007-09-05 00:00:00 |  | Changement batterie | 93 | Honda Versailles
2007-09-12 00:00:00 | 100190 | Nettoyage démarreur | 150 | Honda Versailles
2008-02-22 00:00:00 | 104830 | Changement pot échappement | 249.93 | Honda Versailles
2009-09-30 00:00:00 | 117433 | Réparation radiateur + commande embrayage + vidange + changement pneux AV | 1887.73
 | 19.85678052079811 | km/j | 14203.24706337458 | €
 | 7252.689085221508 | km/an | 889.5307443602817 | €/an
Spreadsheet: chris_dorland__1633__AecoCurve_0501_5YR_07-27-00
Sheet: Sheet1

AECO Financial Mids ($C/GJ)
2001-05-01 00:00:00 | 4.356265266601167
2001-06-01 00:00:00 | 4.339093022933191
2001-07-01 00:00:00 | 4.322059624319184
2001-08-01 00:00:00 | 4.33246269221923
2001-09-01 00:00:00 | 4.315376813353528
2001-10-01 00:00:00 | 4.32317935778198
2001-11-01 00:00:00 | 4.559410843663351
2001-12-01 00:00:00 | 4.696010286175924
2002-01-01 00:00:00 | 4.715830204703884
2002-02-01 00:00:00 | 4.513794524088159
2002-03-01 00:00:00 | 4.339749429324602
2002-04-01 00:00:00 | 4.052967949567378
2002-05-01 00:00:00 | 4.023099347312175
2002-06-01 00:00:00 | 4.013716634062547
2002-07-01 00:00:00 | 4.011316658954436
2002-08-01 00:00:00 | 4.008815660231266
2002-09-01 00:00:00 | 3.992271767924521
2002-10-01 00:00:00 | 4.016728819289436
2002-11-01 00:00:00 | 4.189449140758525
2002-12-01 00:00:00 | 4.329389190126506
2003-01-01 00:00:00 | 4.354812913985072
2003-02-01 00:00:00 | 4.175045576148214
2003-03-01 00:00:00 | 3.982254414260017
2003-04-01 00:00:00 | 3.681032283216517
2003-05-01 00:00:00 | 3.658290011469485
2003-06-01 00:00:00 | 3.689691740869521
2003-07-01 00:00:00 | 3.694077440652255
2003-08-01 00:00:00 | 3.772792283112461
2003-09-01 00:00:00 | 3.75673295163348
2003-10-01 00:00:00 | 3.781311530931096
2003-11-01 00:00:00 | 3.898934715183142
2003-12-01 00:00:00 | 4.038084801698961
2004-01-01 00:00:00 | 4.160724469208891
2004-02-01 00:00:00 | 3.98806014518782
2004-03-01 00:00:00 | 3.801000646805381
2004-04-01 00:00:00 | 3.519910171652022
2004-05-01 00:00:00 | 3.498866887332639
2004-06-01 00:00:00 | 3.531539599370943
2004-07-01 00:00:00 | 3.535912744139058
2004-08-01 00:00:00 | 3.6138444283134
2004-09-01 00:00:00 | 3.596450687134323
2004-10-01 00:00:00 | 3.619363767558887
2004-11-01 00:00:00 | 3.769362694940241
2004-12-01 00:00:00 | 3.903174116850535
2005-01-01 00:00:00 | 4.048730665946549
2005-02-01 00:00:00 | 3.882754792220668
2005-03-01 00:00:00 | 3.701260055156269
2005-04-01 00:00:00 | 3.4396977228772
2005-05-01 00:00:00 | 3.419919189871794
2005-06-01 00:00:00 | 3.45337789809918
2005-07-01 00:00:00 | 3.457576674185316
2005-08-01 00:00:00 | 3.534812749975708
2005-09-01 00:00:00 | 3.51595907475497
2005-10-01 00:00:00 | 3.537062622940183
2005-11-01 00:00:00 | 3.731877797711166
2005-12-01 00:00:00 | 3.86015797811803
2006-01-01 00:00:00 | 4.021233785743881
2006-02-01 00:00:00 | 3.861654432483423
2006-03-01 00:00:00 | 3.685432211880058
2006-04-01 00:00:00 | 3.429875517866574
Spreadsheet: 599895d1543351251-find-closest-value-in-a-table-of-values-zxc
Sheet: Лист1

 | Category | Rate | Closest |  | Category | Point 1 | Point 2 | Point 3 | Point 4 | Point 5
 | IT 02 | 20.32 |  |  | IT 01 | 14.04 | 15.25 | 16.21 | 19.7 | 22.95
 | IT 04 | 28.68 |  |  | IT 02 | 18.02 | 20.81 | 23.6 | 25.67 | 28.71
 | IT 05 | 37.65 |  |  | IT 03 | 20.61 | 23.34 | 27.8 | 31.25 | 35.71
 | IT 06 | 35.28 |  |  | IT 04 | 24.19 | 27.59 | 30.73 | 34.11 | 38.19
 |  |  |  |  | IT 05 | 27.99 | 32.51 | 36.21 | 40.02 | 45.6
 |  |  |  |  | IT 06 | 35.36 | 40.56 | 44.7 | 49.07 | 55.38
 |  |  |  |  | IT 07 | 44.17 | 51.8 | 57.46 | 62.94 | 69.91
 |  |  |  |  | IT 08 | 59.1 | 67.27 | 72.94 | 78.83 | 86.86
 |  |  |  |  | IT 09 | 74.54 | 84.34 | 90.49 | 96.26 | 104.47