tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89bfc4b9-5fa1-4c93-a11d-5f8b61a39e7f
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Heidenau, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 6 | 892 | 787 | 697 | 600
6 - 15 | 1125 | 1247 | 1240 | 1145
15 - 25 | 1461 | 998 | 1163 | 1258
25 - 40 | 2982 | 2792 | 2375 | 2013
40 - 65 | 5733 | 5461 | 5287 | 5129
65 und mehr | 4230 | 4297 | 4372 | 4464
Insgesamt | 16423 | 15582 | 15134 | 14609
%
unter 6 | 5.431407172867321 | 5.050699525093056 | 4.605523985727501 | 4.107057293449244
6 - 15 | 6.850149181026609 | 8.002823771017841 | 8.193471653231136 | 7.837634334998973
15 - 25 | 8.896060403093223 | 6.404826081375948 | 7.684683494119201 | 8.611130125265246
25 - 40 | 18.1574620958412 | 17.91811064048261 | 15.69314127130963 | 13.77917721952221
40 - 65 | 34.9083602265116 | 35.04684892825055 | 34.93458437954275 | 35.10849476350195
65 und mehr | 25.75656092066005 | 27.57669105378 | 28.88859521606978 | 30.55650626326237
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 878844d1726148107-using-results-from-array-formulas-for-use-in-another-formula-drewber-patient-percentages-spill-365-aligw
Sheet: Sheet2

 | [NAME] | 1 |  | [NAME] | 27
 | [NAME] | 5 |  | [NAME] | 1
 | [NAME] | 8 |  | [NAME] | 4
 | Clay | 6 |  | [NAME] | 6
 | [NAME] | 1 |  | [NAME] | 18
 | Gardner | 11 |  | Byrd | 11
 | Greene | 2 |  | [NAME] | 15
 | [NAME] | 1 |  | Clay | 9
 | Jacobs | 7 |  | [NAME] | 1
 | [NAME] | 9 |  | Davila | 2
 | [NAME] | 3 |  | [NAME] | 23
 | [NAME] | 25 |  | Drake | 2
 | [NAME] | 10 |  | Ford | 35
 | Peck | 5 |  | Fox | 73
 | Reynolds | 8 |  | Fritz | 15
 | [NAME] | 3 |  | Fuller | 5
 | Tanner | 3 |  | Gardner | 14
 | Vaughan | 17 |  | Goodman | 29
 | Woods | 5 |  | Greene | 3
 |  |  |  | Hale | 26
 |  |  |  | [NAME] | 5
 |  |  |  | Holder | 19
 |  |  |  | Jacobs | 22
 |  |  |  | [NAME] | 52
 |  |  |  | Little | 28
 |  |  |  | Maldonado | 34
 |  |  |  | [NAME] | 42
 |  |  |  | Mccann | 1
 |  |  |  | Mccormick | 30
 |  |  |  | [NAME] | 20
 |  |  |  | [NAME] | 33
 |  |  |  | [NAME] | 24
 |  |  |  | Obrien | 19
 |  |  |  | [NAME] | 20
 |  |  |  | [NAME] | 19
 |  |  |  | Peck | 14
 |  |  |  | Pittman | 16
 |  |  |  | Ray | 8
 |  |  |  | Reynolds | 15
 |  |  |  | Richards | 2
 |  |  |  | Rivers | 20
 |  |  |  | [NAME] | 5
 |  |  |  | Schroeder | 9
 |  |  |  | Smith | 28
 |  |  |  | Tanner | 13
 |  |  |  | Travis | 1
 |  |  |  | Vaughan | 84
 |  |  |  | Walter | 3
 |  |  |  | Woodard | 28
 |  |  |  | Woods | 7
Spreadsheet: 710018d1608667539-countif-returning-0-when-value-not-found-anyway-to-return-blank-instead-test
Sheet: Test

 | AA | BB | CC | DD | EE | FF
 |  |  |  |  |  |  | Failure Count
Completed | Completed | Failed | Completed | Incomplete | Completed | In Progress
Failed | Completed | Failed | Failed | Incomplete | Completed | In Progress
Completed | Completed | Not Done | No Grade | Incomplete | Completed | In Progress
Spreadsheet: 154327d1336384591-automation-of-excel-sheet-demo
Sheet: TimeSheet- 2nd - 6th April'12

 |  |  |  |  |  |  | NON VATS |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Vacation/ Holiday Day
SAP Id | Resource Name | Team | Newco - Incident Mgmt | Newco - VES TechSupport | VES - Incident Mgmt | VES - Chordiant OR CRM Support | Chordiant_BAU | Online_Programme | Vendor_Integration_Prog | Vodafone_eShop_L3 | Chordiant_BAU | EG_NewCo_eShop | N_Portfolio_Project | MTS_RoamingData_Rfsh | APP_SKYWALKER | LT_UK_MTS_PAS_Capacity_for_USS | Chargeable Hours | Non-Chargeable | Vacation | Public Holiday
10722721 | [NAME] | Incident Mgmt |  |  |  |  |  | 2.5 | 2 |  |  |  |  | 4.5 |  |  |  | 0 | 27 | 0
10731386 | Banpreet Singh | Incident Mgmt |  |  |  |  |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10391107 | [NAME] | Incident Mgmt |  |  |  |  |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628998 | [NAME] | Incident Mgmt |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10628911 | [NAME] | Incident Mgmt |  |  |  |  |  | 4.5 |  |  |  |  |  |  | 4.5 |  |  | 0 | 0 | 0
10556485 | Ajay  Ashtikar | Incident Mgmt |  |  |  |  |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10727324 | Amber [NAME] | Incident Mgmt |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 |  | 0 | 0 | 0
10381737 | [NAME] | Incident Mgmt |  |  |  |  |  | 4.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10614473 | [NAME] | Tech support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10556831 | [NAME] | Tech support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10716330 | [NAME] | Tech support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10724809 | [NAME] | Tech support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Daily Total
 | Weekly Total
 | Poject | Hours Weekly
 | Non-VATS - Online_I.40000227 | 157.5
 | Roaming Refresh | 22.5
 | Vendor Integration Program | 11.25
 | Non-VATS - Chordiant_BAU | 22.5
 | Skywalker (D2SD) | 22.5
 | LT_UK_MTS_PAS_Capacity_for_USS | 18
Spreadsheet: 694776d1599786283-lookup-help-sheq-metric
Sheet: Sam draft Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rolling Injury Dial
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month Result | 0.5 | 0.01
 | Rolling Injury Dial
 | Rolling Incident Dial |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | 0% to 35% | 0.35
 | Rolling Training Dial |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow | 35% to 70% | 0.35
 | Rolling SHEQ Observation Dial |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green | 70% to 100% | 0.3
 | Rolling [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank |  | 0.5
 | Rolling Injury as of |  |  | Oct-20
 |  |  |  |  | 2018-05-01 00:00:00 | 2018-06-01 00:00:00
 |  |  |  |  | 2 | 3
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: TUR

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 58 | 00:01:29.937000 | 1 |  | 1 |  | 00:01:25.049000
2 | [NAME] |  |  | 18 | 58 | 00:01:29.703000 | 2 |  | 2 |  | 00:01:25.454000
3 | [NAME] |  |  | 15 | 58 | 00:01:30.279000 | 5 |  | 3 |  | 00:01:25.851000
4 | [NAME] |  |  | 12 | 58 | 00:01:30.108000 | 4 |  | 4 |  | 00:01:25.595000
5 | [NAME] |  |  | 10 | 58 | 00:01:30.573000 | 3 |  | 5 |  | 00:01:25.574000
6 | [NAME] |  |  | 8 | 58 | 00:01:31.167000 | 6 |  | 6 |  | 00:01:25.982000
7 | [NAME] |  |  | 6 | 58 | 00:01:30.158000 | 9 |  | 7 |  | 00:01:26.659000
8 | [NAME] |  |  | 4 | 58 | 00:01:30.618000 | 7 |  | 8 |  | 00:01:26.296000
9 | Sebastien Buemi |  |  | 2 | 58 | 00:01:31.360000 | 16 |  | 9 |  | 00:01:27.255000
10 | [NAME] |  |  | 1 | 58 | 00:01:31.038000 | 24 |  | 10
11 | [NAME] |  |  | 0 | 58 | 00:01:31.118000 | 10 |  | 11 |  | 00:01:26.395000
12 | [NAME] |  |  | 0 | 58 | 00:01:31.153000 | 8 |  | 12 |  | 00:01:26.646000
13 | [NAME] |  |  | 0 | 57 | 00:01:32.070000 | 12 |  | 13 |  | 00:01:27.027000
14 | [NAME] |  |  | 0 | 57 | 00:01:30.797000 | 15 |  | 14 |  | 00:01:27.244000
15 | [NAME] |  |  | 0 | 57 | 00:01:32.079000 | 11 |  | 15 |  | 00:01:26.764000
16 | [NAME] |  |  | 0 | 57 | 00:01:29.894000 | 17 |  | 16 |  | 00:01:27.572000
17 | Pastor Maldonado |  |  | 0 | 57 | 00:01:32.044000 | 14 |  | 17 |  | 00:01:27.236000
18 | Jarno [NAME] |  |  | 0 | 57 | 00:01:32.862000 | 19 |  | 18 |  | 00:01:29.673000
19 | [NAME] |  |  | 0 | 56 | 00:01:32.695000 | 18 |  | 19 |  | 00:01:28.780000
20 | [NAME] |  |  | 0 | 56 | 00:01:34.971000 | 23 |  | 20 |  | 00:01:31.564000
21 | Narain Karthikeyan |  |  | 0 | 55 | 00:01:33.948000 | 22 |  | 21 |  | 00:01:30.813000
22 | [NAME] |  |  | 0 | 53 | 00:01:34.699000 | 20 |  | 22 |  | 00:01:30.445000
23 | [NAME] |  |  | - | 44 | 00:01:32.519000 | 13 |  | RET |  | 00:01:27.145000
24 | [NAME] |  |  | - | 0 |  | 21 |  | DNS |  | 00:01:30.692000
Spreadsheet: 35543d1233150901-countind-dates-on-a-different-xls-file-zara
Sheet: Sheet1

2009-01-01 00:00:00
 |  | how many were created on each date
2009-01-01 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
2009-01-02 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-01 00:00:00
2009-01-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00
2009-01-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
2009-01-05 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
2009-01-06 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00
2009-01-07 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00
2009-01-08 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00
2009-01-09 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00
2009-01-10 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-10

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-17 00:00:00
 |  |  | Monitoring Well #: | MW-10 |  |  |  | Well Depth: | 7.35 |  | ft |  |  | Screened/Open Interval: | 2 - 7 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 1.17 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 10:50 | x |  | 6.61 | NA | 15.54 | NA | 616 | NA | 0.73 | NA | 52.2 | NA | 26.2 | NA | 200 | 1.66
 | 10:55 | x |  | 6.62 |  | 15.9 |  | 614 |  | 0.46 |  | 42.1 |  | 17.8 |  | 200 | 1.97
 | 11:00 | x |  | 6.63 |  | 16.09 |  | 606 |  | 0.49 |  | 37.3 |  | 11.5 |  | 200 | 2.36
 | 11:05 | x |  | 6.65 |  | 16.15 |  | 592 |  | 0.51 |  | 32.7 |  | 8.12 |  | 200 | 2.72
 | 11:10 | x |  | 6.67 |  | 16.12 |  | 557 |  | 0.58 |  | 27.7 |  | 6.45 |  | 200 | 3.02
 | 11:15 | x |  | 6.67 |  | 16.23 |  | 506 |  | 0.62 |  | 24.3 |  | 5.39 |  | 200 | 3.39
 | 11:20 | x |  | 6.64 |  | 16.25 |  | 490 |  | 0.52 |  | 20.1 |  | 5.26 |  | 200 | 3.75
 | 11:25 | x |  | 6.6 |  | 16.42 |  | 495 |  | 0.49 |  | 18.6 |  | 5.14 |  | 200 | 4.15
 | 11:30 | x |  | 6.58 |  | 16.35 |  | 503 |  | 0.48 |  | 11.7 |  | 4.96 |  | 200 | 4.56
 | [NAME]: |  | 10:43:00 |  | Sample notes:
 | [NAME]: |  | 11:30:00
 | Sample Time: |  | 11:32:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 730419d1619696777-automatically-copy-date-reference-if-there-is-a-1-in-the-table-corresponding-to-it-automatically-copy-date-reference-if-there-is-a-1-in-the-table-corresponding-to-it
Sheet: Sheet1

UID | Date |  | UID | Date
Expected
Is there a way to automate the date process whereby the formula will see where a "1" occurs in the table on "Sheet2" and then automatically lookup the date and copy it in, and then be able to drag down the formula  so that it skips the previous date that it's just looked up and looks for the next corresponding date.
Spreadsheet: 104930d1302382672-totals-across-16-sheets-lineup4
Sheet: Game 7

[NAME] | Player | 1st | 2nd | 3rd | 4th | 5th | 6th | Bench | Infield | Outfield |  |  |  | Bench | Infield | Outfield
1
2
3
4
5
6
7
8
9
10
11
12
 | CF
 | RF
 | LF
 | P
 | C
 | 1st
 | 2nd
 | 3rd
 | SS
 | B
 | Num Players
 | 12
Spreadsheet: 720682d1614257367-formula-to-alter-calculation-dependant-on-drop-down-list-value-copy-of-tim-recording-sheet-1-
Sheet: Example

 |  |  |  |  |  |  |  |  |  | WEEK 1 | <=== Selected Week
 |  |  |  |  |  |  |  |  |  | WORK AREA
 | Monday | Minute |  |  |  |  |  |  |  | WorkArea | Minute |  |  |  |  |  |  | Concatenated Hour
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  | 19
 | Tuesday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7 |  |  |  |  |  |  |  |  |  | Day you're Interested in |  |  | Monday
 | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 | 10 |  |  |  |  |  |  |  |  |  | Code you're interested in: |  |  | C2
 | 11 |  |  |  |  |  |  |  |  |  | Time you're interested in: |  |  | 19:00 - 19:59
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | Number of Instances for the Hour
 | 14 |  |  |  |  |  |  |  |  |  | Number of Instances for the Day
 | 15 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :00
 | 16 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :10
 | 17 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :20
 | 18 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :30
 | 19 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :40
 | Wednesday | Minute |  |  |  |  |  |  |  |  | Number of Instances during: |  | :50
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 30445d1225963181-using-reference-points-through-worksheets-test
Sheet: Sheet2

 | CANKE
 | NORMAN
-45
45 | 6.42
100 | 3.21
250 | 3.21
300 | 3.13
500 | 2.99
1000 | 2.91
2000 | 2.91
FS | 0.57
WRS | 0.15
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: Lexi-Comp

[NAME]
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
Lexi-Comp Online
Logins | 150 | 27 | 80 | 77 | 153 | 44 | 201 | 175 | 407 | 165 | 61 | 82 |  | 0
Searches | 274 | 109 | 428 | 457 | 497 | 330 | 770 | 678 | 1403 | 651 | 567 | 964 |  | 0
Documents Retrieved | 381 | 138 | 533 | 616 | 872 | 403 | 934 | 822 | 1653 | 869 | 632 | 1385 |  | 0
COUNTER-Compliant?: | No
Stats are e-mailed monthly from [EMAIL] to [EMAIL]
Spreadsheet: 146606d1332269324-probl-me-excel-2007-essais
Sheet: Feuil3

 |  |  |  |  |  |  | TOTAL: Brut |  | 17.99
 |  |  |  |  |  |  | 0.137
 |  |  |  |  |  |  | C.S.G + C.R.D.S
 |  |  |  |  |  |  | 0.97 | 0.08
 |  |  |  |  |  |  | TOTAL CHARGES:
 |  |  |  |  |  |  | TOTAL NET:
Charges sur salaires
Charges sur salaires | Taux au 01.01.2010 (%) |  |  | Assiette mensuelle au 01.01.2010
 | Employeur | Salarié | Total | Montant | [NAME]
a- Charges sociales
Sécurité sociale (URSSAF)
Assurance - maladie - solidarité (1) | 13.1 | 0.75 | 13.85 | Total brut | -
Vieillesse plafonnée | 8.3 | 6.65 | 14.95 | Total brut | Tranche A (de 0 à 2 885 €)
Vieillesse déplafonnée | 1.6 | 0.1 | 1.7 | Total brut | -
Allocations familiales | 5.4 | - | 5.4 | Total brut | -
Accident du travail (2) | Variable | - | Variable | Total brut | -
FNAL base | 0.1 | - | 0.1 | Total brut | Tranche A (de 0 à 2 885 €)
FNAL : cotisation supplémentaire (> 20 salariés) (3) | 0.4 | - | 0.4 | Total brut | -
Chômage (Pôle emploi) | 4 | 2.4 | 6.4 | Total brut | Tranche A+B (de 0 à 11 540 €)
Fonds de garantie des salaires (AGS) (4) | 0.4 | - | 0.4 | Total brut | Tr.A+B (de 2 885 à 11 540 €)
APEC : contribution cadres | 0.036 | 0.024 | 0.06 | Total brut | Tranche B
APEC : [NAME] (mars) | 12.46 | 8.31 | 20,77 | - | -
Retraite complémentaire non cadres
Tranche 1 | 4.5 | 3 | 7.5 | Tranche 1 | 0 à 2 885 €
Tranche 2 | 12 | 8 | 20 | Tranche 2 | de 2 885 à 8 655 €
Régime cadres (minima)
Prévoyance | 1.5 | - | 1.5 | Total brut | Tranche A
ARCCO | 4.5 | 3 | 7.5 | Total brut | Tranche A
AGIRC Tr. B&C | 12.6 | 7.7 | 20.3 | Total brut | Tr.B/C
Contribution exceptionnelle et temporaire (CET) | 0.22 | 0.13 | 0.35 | Total brut | Tr.A+B+C
AGFF cadre et non-cadre | 1.2 | 0.8 | 2 | - | 0 à 2 885 €
AGFF non-cadre | 1.3 | 0.9 | 2.2 | - | de 2 885 à 8 655 €
AGFF cadre | 1.3 | 0.9 | 2.2 | Tranche B | de 2 885 à 11 540 €
b- Taxes & contributions spéciales
Prévoyance complémentaire (> 9 salariés) | 8 | 0 | 8 | Cotisation patronale prévoyance
Taxe d'apprentissage (5)(6) | 0.5 | 0 | 0.5 | Total brut | -
Contribution au développement de l'apprentissage | 0.18 | 0 | 0.18 | Total brut | -
Participation formation (7)
Ent. [NAME]. | 0.55 | 0 | 0.55 | Total brut | -
Ent. de 10 à moins de 20 salariés | 1.05 | 0 | 1.05 | Total brut | -
Ent. de 20 salariés et + | 1.6 | 0 | 1.6 | Total brut | -
Ent. avec CDD | 1 | 0 | 1 | Total brut versé aux titulaires de ces contrats | -
Participation construction | 0.45 | 0 | 0.45 | Total brut | -
(entreprise > 20 salariés)
Versement transport | variable | 0 | variable | Total brut | -
(entreprise > 9 salariés)
Taxe sur salaire (employeur non assujetti à la TVA) | 4.25 | 0 | 4.25 | Total brut | Tranche annuelle
 |  |  |  |  | de 0 à 7 491 €
 | 8.5 | 0 | 8.5 | Total brut | Tranche annuelle
 |  |  |  |  | de 7 491 à 14 960 €
 | 13.6 | 0 | 13.6 | Total brut | Tranche annuelle
 |  |  |  |  | au-delà de 14 960 €
CSG
Non déductible | 0 | 2.4 | 2.4 | 97 % du total brut + Cotisation prévoyance employeur
Déductible | 0 | 5.1 | 5.1
CRDS | 0 | 0.5 | 0.5
Spreadsheet: 271625d1382005853-excel-coding-and-formulas-for-master-and-cost-sheets-pricing-sheet
Sheet: Master

Code | Description | Material | Labour | Paint | Total | ex [NAME] | VAT | Total inc VAT
A1 | 800mm x 900mm side panel | side panel | 150 | 30 | 20 | 200 | 0.2 | 240
A2 | 800mm x 900mm side panel | side panel | 100 | 30 | 20 | 200 | 0.2 | 241
A3 | 800mm x 900mm side panel | side panel | 45 | 30 | 20 | 200 | 0.2 | 242
A4 | 800mm x 900mm side panel | side panel | 254 | 30 | 20 | 200 | 0.2 | 243
A5 | 800mm x 900mm side panel | side panel | 678 | 30 | 20 | 200 | 0.2 | 244
A6 | 800mm x 900mm side panel | side panel | 43 | 30 | 20 | 200 | 0.2 | 245
A7 | 800mm x 900mm side panel | side panel | 9876 | 30 | 20 | 200 | 0.2 | 246
A8 | 800mm x 900mm side panel | side panel | 34 | 30 | 20 | 200 | 0.2 | 247
A9 | 800mm x 900mm side panel | side panel | 66 | 30 | 20 | 200 | 0.2 | 248
A10 | 800mm x 900mm side panel | side panel | 85 | 30 | 20 | 200 | 0.2 | 249
A11 | 800mm x 900mm side panel | side panel | 24 | 30 | 20 | 200 | 0.2 | 250
A12 | 800mm x 900mm side panel | side panel | 150 | 30 | 20 | 200 | 0.2 | 251
Spreadsheet: 329398d1404301931-formula-for-calculating-sla-sla
Sheet: Master Sheet

Incident ID | Category | Type | Priority | Employee # Location | Status | Summary | Workgroup | Owner [NAME] | Restoration Goal Achieved | Registered DT | Restored | Pending Closed DT | Classification | SLO
PM778763 | Incident | Secondary Incident | 4 | Building 1 | Closed | Outlook | techical support | Jhon | True | 2014-06-05 01:58:24 | 2014-06-05 02:17:04 | 2014-06-05 02:17:04
PM778764 | Incident | Standard Incident | 4 | Building 2 | Closed | Power issue | techical support | Jhon | False | 2014-06-17 09:34:20
PM778765 | Incident | Standard Incident | 5 | Building 1 | Pending Closed | internet | techical support | Jhon | True | 2014-06-24 15:24:27 | 2014-06-24 15:45:16 | 2014-06-24 15:45:16
PM778766 | Incident | Standard Incident | 3 | Building 1 | Pending Closed | Outlook | techical support | Jhon | True | 2014-06-25 02:49:20 | 2014-06-25 09:30:04 | 2014-06-25 09:30:04
PM778767 | Incident | Standard Incident | 3 | Building 1 | Closed | Power issue | techical support | Bing | True | 2014-05-01 22:06:53 | 2014-05-02 00:28:00 | 2014-05-02 00:28:00
PM778768 | Incident | Standard Incident | 5 | Building 2 | Closed | internet | techical support | Bing | True | 2014-05-02 00:35:22 | 2014-05-12 01:31:17 | 2014-05-02 01:31:17
PM778769 | Incident | Standard Incident | 4 | Building 2 | Closed | Excel | techical support | Bing | True | 2014-05-02 00:55:17 | 2014-05-02 01:42:05 | 2014-05-02 01:42:05
PM778770 | Incident | Standard Incident | 3 | Building 1 | Closed | internet | techical support | Bing | True | 2014-05-02 01:01:49 | 2014-05-02 02:30:17 | 2014-05-02 02:30:17
Spreadsheet: 866132d1713081125-give-a-distinct-sequence-number-for-every-data-type-in-col-a-and-col-b-ref-book-aligw
Sheet: Sheet1

DATE | TYPE |  |  | DATE | 2024-04-05 00:00:00
2024-04-01 00:00:00 | PAYMENT |  |  | TYPE | LIABILITY
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT |  |  | BILL SL NO
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT |  |  | Number That I should get is | 5
2024-04-01 00:00:00 | PAYMENT |  |  | But What I have got | 2
2024-04-01 00:00:00 | LIABILITY
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | OTHER
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | LIABILITY
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | OTHER
2024-04-01 00:00:00 | PAYMENT
2024-04-01 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | LIABILITY
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | LIABILITY
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | PAYMENT
2024-04-05 00:00:00 | OTHER
2024-04-05 00:00:00 | OTHER
2024-04-05 00:00:00 | OTHER
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | OTHER
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | OTHER
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | OTHER
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | LIABILITY
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | OTHER
2024-04-08 00:00:00 | PAYMENT
2024-04-08 00:00:00 | LIABILITY