tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2841b93a-3324-4de2-ba68-de7543461d9a
Sheet: Sheet1

Aantal gezinnen naar kindertal en herkomst, 2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
-
 | Aantal kinderen
 | -
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 of meer | totaal (= 1 of meer)
-
Autochtoon | 810514 | 884042 | 269024 | 50429 | 9617 | 2889 | 1176 | 1114 | 2028805
Niet-westers allochtoon | 124879 | 122372 | 54501 | 18295 | 5464 | 1595 | 441 | 211 | 327758
w.v. Turks | 23834 | 28647 | 13680 | 3390 | 634 | 118 | 35 | 13 | 70351
Marokkaans | 16878 | 17858 | 12917 | 7092 | 2739 | 890 | 220 | 107 | 58701
Surinaams | 28729 | 24587 | 8018 | 1635 | 329 | 82 | 14 | 5 | 63399
Antilliaans | 11109 | 8944 | 3190 | 823 | 189 | 48 | 18 | 8 | 24329
Overig niet-westers | 44329 | 42336 | 16696 | 5355 | 1573 | 457 | 154 | 78 | 110978
Westers allochtoon | 78871 | 64650 | 16267 | 2948 | 467 | 112 | 36 | 29 | 163380
Totaal | 1014264 | 1071064 | 339792 | 71672 | 15548 | 4596 | 1653 | 1354 | 2519943
-
Bron: CBS.
Spreadsheet: 705661d1606242155-data-comparison-and-aggregation-looking-for-help-copy-template-1-
Sheet: Individuals

ID | Name | Address 1 | Address 2 | Address 3 | Post Code | comments
111 | Name 1 | 999 jhjgsdxcvhggh |  |  | CV2 3SQ | 111 and 333 has same postcode(F4 and F6), so these ID's calculations will be done in N,O,P column in analysis tab
222 | Name 2 |  |  |  | LE91 2RU | Only 222 has this postcode (cell F5), so this ID calculations will be done in F,G,H column in analysis tab - This has been done already
333 | Name 3 |  |  |  | CV2 3SQ | 111 and 333 has same postcode(F4 and F6), so these ID's calculations will done in N,O,P column in analysis tab
444 | Name 4 |  |  |  | PO12 4RT
555 | Name 5 |  |  |  | PO12 4RT
666 | Name 6 |  |  |  | BS2 3KL
777 | Name 7 |  |  |  | DE24 7BY
888 | Name 8 |  |  |  | NG11 2JG
999 | Name 9 |  |  |  | CV11 0AA
1000 | Name 10 |  |  |  | PO12 4RT
Spreadsheet: 767146d1644315323-countifs-unique-values-in-one-column-based-on-criteria-in-other-columns-unique-countifs
Sheet: Sheet1

JOB | CATEGORY | TIME LEFT |  | Result required | Result
1 | HOME | 0 |  | Unique values in column A, based on column B = "HOME" & column C = 0
2 | WORK | 0 |  | Unique values in column A, based on column B = "WORK" & column C = 0
3 | MISC | 0 |  | Unique values in column A, based on column B = "MISC" & column C = 0
4 | HOME | 1
1 | HOME | 5 |  | Unique values in column A, based on column B = "HOME" & column C value greater than 0
1 | HOME | 2 |  | Unique values in column A, based on column B = "WORK" & column C value greater than 0
2 | WORK | 4 |  | Unique values in column A, based on column B = "MISC" & column C value greater than 0
5 | MISC | 6
6 | MISC | 1
7 | MISC | 0
8 | MISC | 1
3 | HOME | 3
Spreadsheet: 677866d1589557419-sorting-data-question_file-1-
Sheet: Sheet2

Translator | 1st language | Paid for 1st language | 2nd language | Paid for 2nd language | 3rd language | Paid for 3rd language | 4th language | Paid for 4th language | 5th language | Paid for 5th language | 6th language | Paid for 6th language | 7th language | Paid for 7th language |  |  | Polish | Russian | German | English | Italian | French | Dutch
AAA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  | 252
BBB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
CCC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 223
DDD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 452 | 215 | 562 |  | 2548 | 20
EEE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258
FFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147 |  |  | 874
GGG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 215 | 854 | 875 | 995 | 25 | 47 | 63
HHH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 628
III |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 475 |  | 412
Spreadsheet: 84782d1284825892-dynamic-array-lookup-copy-of-excel-challenge
Sheet: Challenge 1

For the first 2000 cumulative units sold during the year, pay a commission of $1.50 per unit.
After 2000 cumulative units are sold, switch to a commission of $1.25 per unit.
Use Excel [NAME] (no VBA) to calculate the commission for each month.
You can add additional lines as necessary for intermediate calculations.
Your formulas need to account for any amount in any month (e.g. more than 2000 units in January)
Use these cells in your formula: |  |  |  | 2000 | 1.5 | 1.25
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Sales | 227 | 594 | 510 | 606 | 503 | 176 | 368 | 485 | 403 | 148 | 775 | 980
Commission
 | 340.5 | 891 | 765 | 909 | 644.5 | 220 | 460 | 606.25 | 503.75 | 185 | 968.75 | 1225
Spreadsheet: 688971d1596044091-sales-by-month-sales-by-month
Sheet: Sheet1

Sales Data
Date | Name | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount Including Vat
2020-01-01 00:00:00 | Clint | 2006400 | 1 | 2300 | 0.15
2020-01-02 00:00:00 | Desire | 2006401 | 2 | 2400 | 0.15
2020-01-03 00:00:00 | Omega | 2006402 | 3 | 2500 | 0.15 |  |  |  | 2020-01-01 00:00:00
2020-01-04 00:00:00 | [NAME] | 2006403 | 4 | 2600 | 0.15 |  |  |  | 2020-02-01 00:00:00
2020-01-05 00:00:00 | Clint | 2006404 | 5 | 2700 | 0.15 |  |  |  | 2020-03-01 00:00:00
2020-01-06 00:00:00 | clint | 2006405 | 6 | 2800 | 0.15 |  |  |  | 2020-04-01 00:00:00
2020-02-10 00:00:00 | Desire | 2006401 | 7 | 2900 | 0.15 |  |  |  | 2020-05-01 00:00:00
2020-02-11 00:00:00 | Omega | 2006402 | 8 | 3000 | 0.15 |  |  |  | 2020-06-01 00:00:00
2020-02-12 00:00:00 | [NAME] | 2006403 | 9 | 3100 | 0.15 |  |  |  | 2020-07-01 00:00:00
2020-02-13 00:00:00 | Desire | 2006401 | 10 | 3200 | 0.15 |  |  |  | 2020-08-01 00:00:00
2020-02-14 00:00:00 | Omega | 2006402 | 11 | 3300 | 0.15 |  |  |  | 2020-09-01 00:00:00
2020-02-15 00:00:00 | [NAME] | 2006403 | 12 | 3400 | 0.15 |  |  |  | 2020-10-01 00:00:00
2020-03-01 00:00:00 | [NAME] | 2006406 | 13 | 3500 | 0.15 |  |  |  | 2020-11-01 00:00:00
2020-03-02 00:00:00 | Graig | 2006407 | 14 | 3600 | 0.15 |  |  |  | 2020-12-01 00:00:00
2020-03-03 00:00:00 | Clint | 2006400 | 15 | 3700 | 0.15
2020-03-04 00:00:00 | Desire | 2006401 | 16 | 3800 | 0.15
2020-03-05 00:00:00 | [NAME] | 2006403 | 17 | 3900 | 0.15
2020-03-06 00:00:00 | [NAME] | 2006408 | 18 | 4000 | 0.15
I want a formula which can rearrange the above sales data above by Month. See the desired answer. Please not that cell B33 ia a drop down list.
Pivot tables  and VBA are not required. THANK YOU.
Desired Answer
Sales by Month
Fiscal Month: | 2020-03-01 00:00:00
Date | Name | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount Including Vat
2020-01-01 00:00:00 | Clint | 2006400 | 1 | 2300 | 0.15
2020-01-02 00:00:00 | Desire | 2006401 | 2 | 2400 | 0.15
2020-01-03 00:00:00 | Omega | 2006402 | 3 | 2500 | 0.15
2020-01-04 00:00:00 | [NAME] | 2006403 | 4 | 2600 | 0.15
2020-01-05 00:00:00 | Clint | 2006404 | 5 | 2700 | 0.15
2020-01-06 00:00:00 | clint | 2006405 | 6 | 2800 | 0.15
Spreadsheet: 285fa191-ac33-42b2-9a6a-b90862409801
Sheet: TC132

표준개발협력기관 한국철강협회 지정목록
번호 | 규격번호 | 규격명 | 지정분야
612 | KSDISO8954-2 | 페로알로이-용어-제2부:샘플링 및 샘플준비 | ISO/TC132
613 | KSDISO8954-1 | 페로알로이-용어-제1부:재료 | ISO/TC132
614 | [NAME] | 칼슘 실리콘 | ISO/TC132
615 | KSD2363 | 연자성 합금용 50% 니켈 50% 철분말 | ISO/TC132
616 | KSD2362 | 연자성용 산화철 | ISO/TC132
617 | KSDISO8954-3 | 페로알로이-용어-제3부:체 분석 | ISO/TC132
618 | [NAME] | 훼로 니오브 | ISO/TC132
619 | KSD3726 | 페로 붕소 | ISO/TC132
620 | [NAME] | 실리콘 크롬 | ISO/TC132
621 | [NAME] | 훼로 바나듐 | ISO/TC132
622 | KSD3717 | 실리코망가니즈 | ISO/TC132
623 | KSD3716 | 훼로 몰리브덴 | ISO/TC132
624 | [NAME] | 훼로 텅스텐 | ISO/TC132
625 | KSD3714 | 페로 크로뮴 | ISO/TC132
626 | [NAME] | 페로 실리콘 | ISO/TC132
627 | KSD3712 | 훼로 망간 | ISO/TC132
628 | [NAME] | 훼로 티탄 | ISO/TC132
629 | KSD0046 | [NAME] 샘플링 방법 및 입도 측정 방법 | ISO/TC132
630 | KSD0045 | 훼로알로이 성분용 시료의 샘플링 방법 (훼로니겔 ) | ISO/TC132
631 | [NAME] | 훼로알로이 성분용 시료의 샘플링 방법 ( 훼로인 , 금속망간 ,금속규소, 금속크롬 , 칼슘실리콘 및 훼로붕소 ) | ISO/TC132
632 | KSD0043 | 훼로알로이 성분용 시료의 샘플링 방법 ( 훼로텅스텐 , 훼로몰리브덴 , 훼로바나듐 , 훼로티탄 및 훼로니오브 ) | ISO/TC132
633 | KSD0042 | 훼로알로이 성분용 시료의 샘플링 방법 ( 훼로망간 , 훼로실리콘, 훼로크롬 , 실리콘 망간 및 실리콘크롬 ) | ISO/TC132
634 | KSD0006 | [NAME] 방법 통칙 | ISO/TC132
635 | [NAME] | 페로 니켈 | ISO/TC132
Spreadsheet: 08f0713b-1911-470b-b4e0-d77569453b63
Sheet: Sheet1

MaRRS SPELLING BEE & MATHS PREMIER LEAGUE 2012-2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
S.NO | Name of the Student | Class | Spelling Bee | MPL
1 | Vidyut | I | Y
2 | [NAME] | I | Y
3 | [NAME] | I | Y
4 | [NAME] sundar | I | Y
5 | Vishrudh | I | Y
6 | [NAME] | I | Y
7 | [NAME] | I | Y
8 | [NAME] | I | Y
9 | [NAME] R | I A | Y
10 | Sidh Jain | I A | Y
11 | [NAME] | I C | Y
12 | Sommer | I C | Y
13 | Yadhishwar | I C | Y
14 | Ganesh | I C | Y
15 | Aathish Om | I C | Y
16 | Harshika | I C | Y
17 | Aaditya | I C | Y
18 | Harshith Sethiya | II A | Y
19 | Jeel | II A |  | Y
20 | Pratham Jain | II A |  | Y
21 | [NAME] | II A |  | Y
22 | Yanchi | II A | Y
23 | Naman | II A |  | Y
24 | [NAME] | II A | Y | Y
25 | Shriram | II B | Y | Y
26 | Sherwin | II B | Y | Y
27 | [NAME] | II B | Y | Y
28 | Nithyashree | II B | Y | Y
29 | Sakshi | II B | Y | Y
30 | [NAME] | II B | Y
31 | Vinisha | II B | Y
32 | [NAME] | II B | Y
33 | Sunjana | II B |  | Y
34 | Kaavya | II B | Y
35 | V Megha | II C | Y | Y
36 | Gokulraj | II C | Y
37 | [NAME] | II C | Y
38 | [NAME] | II C | Y | Y
39 | Kavyadharshini | II C | Y | Y
40 | A K Sharvesh | II C | Y | Y
41 | Akash Siddrath | II C | Y | Y
42 | Prasath | II C | Y
43 | Rithvik | II C | Y
44 | [NAME] | II C | Y | Y
45 | G V Akash | II D | Y
46 | Shivani | II D | Y
47 | Harini | II D | Y
48 | Rishwanth | II D | Y
49 | Chirag | II D | Y
50 | Jeevanandhan | II D | Y
51 | Priyadhershini | II D | Y
52 | Srinath | II D | Y
53 | [NAME] | II D | Y
54 | Nandhana | II D | Y | Y
55 | Bhargav | III A | Y | Y
56 | Manav | III A | Y | Y
57 | Darshan | III A | Y
58 | Varun | III A | Y
59 | Sucharitha | III A | Y
60 | [NAME] | III A | Y | Y
61 | Namrutha | III A | Y | Y
62 | Asreen | III A | Y
63 | Gokulakrishna | III A | Y
64 | Swetha | III A |  | Y
65 | [NAME] | III A |  | Y
66 | Anupam | III A | Y | Y
67 | Jayesh | III A |  | Y
68 | Meiazhagee | III B | Y
69 | Ridhi | III B | Y
70 | Neishta | III B | Y
71 | [NAME] | III B | Y | Y
72 | Labdhi | III B | Y
73 | [NAME] | III B | Y | Y
74 | [NAME] | III B | Y
75 | Suyash | III B | Y
76 | Mirudhul | III B | Y
77 | Kritin | III B | Y
78 | Pooja | III B | Y
79 | Vansh | III B | Y
80 | [NAME] | III C | Y
81 | [NAME] | III C | Y
82 | M Pranav | III C | Y
83 | [NAME] | III C | Y
84 | Hashvi | III C | Y
85 | Nitya sigapi | III C | Y
86 | Deepika | III C | Y
87 | Mythreyi | III C | Y
88 | Srinidhi Varsha | III C | Y | Y
Date of competition : 16th Feb 2013( Saturday)
Venue: Calibre Academy, [NAME].
The following is the time schedule for the Written and Oral Rounds:
All the students will assemble at 8.45am at [NAME].
MPL (Math Premier League) starts at 8.45am and ends at 9.30am.
MSB (MaRRS [NAME]): Class 1,2,5,6,7,8 & 9 at 9.30 to 10.30 am - Writtern Round and 10.30am to 11.30am -  Oral Round.
Class 3 & 4 at 12.00pm to 1pm Writtern Round and 1pm to 2.30pm Oral Round.
Spreadsheet: 10730398-d62c-46cf-a627-de771c4355cd
Sheet: Test

School Name Here
Class | First Name | Last Name | LEA Student # | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Q19 | Q20 | [NAME] | Q22 | [NAME] | Q24 | Q25 | Q26 | Q27 | Q28 | Q29 | Q30 | Q31 | Q32 | Q33 | Q34 | Q35 | Q36 | Q37 | Q38 | Q39 | Q40 | Q41 | Q42 | Q43 | Q44 | Q45 | Q46 | Q47 | Q48 | Q49 | Q50 | Q51 | Q52 | Q53 | [NAME] | Q55 | Q56 | Q57 | Q58 | [NAME] | Q60 | Q61 | Q62 | Q63 | Q64 | Q65 | Q66 | Q67 | [NAME] | Q69
Teacher1
Teacher2
Teacher 3
Teacher 4
Teacher5
Teacher6
Spreadsheet: 1b3addf3-5f7e-4bae-8608-815e71046a31
Sheet: 7.3 Page

7.3 Overseas arrivals—visitors and settlers
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Visitors (a) (b) – '000
July | 487.4 | 487.7 | 491.3 | 527.5 | 569.3
August | 492.4 | 490.3 | 508.3 | 537.4
September | 495.8 | 468 | 512.7 | 547
October | 485.2 | 492 | 512.6 | 538.8
November | 487.9 | 489.6 | 516.3 | 536.7
December | 488.7 | 482.7 | 521.9 | 572.5
January | 490.2 | 488.1 | 506.7 | 561.3
February | 480.6 | 493 | 507.9 | 561.8
March | 465.3 | 496.1 | 522 | 560.9
April | 484.3 | 499.7 | 512.3 | 572.6
May | 481.6 | 489.6 | 513.3 | 581.9
June | 472 | 506.2 | 562.8 | 563.7
Annual | 5811.4 | 5883 | 6188.1 | 6662.099999999999
Settlers (c) – '000
July | 9.71 | 11.45 | 11.74 | 11.77 | 9.62
August | 11.57 | 12.88 | 13.22 | 13.49
September | 10.83 | 12.72 | 12.48 | 12.19
October | 9.37 | 12.35 | 11.94 | 12.05
November | 9.43 | 12.89 | 11.56 | 11.38
December | 10.02 | 13.9 | 12.94 | 11.93
January | 10.51 | 14.21 | 12.39 | 11.61
February | 10.52 | 14.44 | 12.68 | 11.71
March | 11.61 | 14.67 | 14.09 | 11.72
April | 11.21 | 13.33 | 12.64 | 10.81
May | 10.99 | 12.65 | 13.15 | 11.59
June | 11.7 | 13.46 | 13.58 | 10.38
Annual | 127.47 | 158.95 | 152.41 | 140.63
(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-10-07 00:00:00
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Operational Characteristics

OPERATIONAL CHARACTERISTICS
 |  | 11 | 12 | 21 | 22
CAPACITY AND HEAT RATE |  | ISO | 95* | ISO | 95*
 |  | with chilling | with chilling | no chilling | no chilling
Gross Unit Capacity (MW) |  | 48.3 | 48.3 | 45.5 | 34.5
Unit Auxiliary Power (MW) | 0.015
Main Power Transformer (MW) | 0.005
Gas Compression (MW)
[NAME] |  | -0.2 | -1.75 | 0 | 0
Net Plant Capacity
Heat Rate - Plant Net of GSU and Auxiliary (LHV)
Heat Rate - Plant Net of GSU and Auxiliary (LHV)
suction press. | psig
discharge press. | psig | 700
suction temp. | F | 80
compressor efficiency | % | 0.82
design gas flow | MMscfd | 10
gas compressibility
compression ratio
compression power | kW
Spreadsheet: adf0af23-830e-476d-86d9-169c3a48df7d
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80689457623 | [NAME] | Something More (I Need To Praise You) | 2004-03-19 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Spreadsheet: 739263d1625593518-loan-calculator-with-known-regular-payments-loan_calc_example
Sheet: Loan Calculator

 | Simple Loan Calculator
 | Loan Values |  |  |  | Loan Summary
 | Loan amount |  | 799 |  | Monthly payment
 | Annual interest rate |  | 0.2404 |  | Number of payments
 | Loan period in years |  | 0.5 |  | Total interest
 | Start date of loan |  | 2021-04-01 00:00:00 |  | Total cost of loan
 | Pmt No. | Payment Date | Beginning Balance | Payment | Principal | Interest | Ending Balance
Spreadsheet: 348874d1412127962-creating-explanatory-variables-example
Sheet: Sheet1

 | Net Income | Extraordinary Items
Year 1 | 450 | 500
Year 2 | 500
Year 3 | 200
Year 4 (Current Year) | 340
LOSS Variable
Year 1
Year 2
Year 3
Year 4 (Current Year)
Spreadsheet: de24dcd8-821b-4268-a13f-108d0705c422
Sheet: Sheet1

Unnamed: 0 | 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
 |  | CODI   I   ESPECIALITAT
 |  | ARMD01ET    Fuster | TALLER D'OCUPACIÓ "_____________________________________" |  |  |  |  |  |  |  |  | ( Del 01/07/2008 al 30/06/2010)
 |  | [NAME] | N. D'EXPEDIENT: | 07/00000/2007 |  |  |  | ( 1ª Fase del 01/07/2008  a   31/12/2008 )
 |  |  | CONTROL DE FALTES D'ASSISTÈNCIA  I  D'ACCIDENTS LABORALS  AL MES DE  G E N E R  2008
 |  |  |  |  |  |  |  | FALTES D'ASSISTÈNCIA
N. | CODI |  |  | ACCIDENTS  LABORALS |  |  |  | A C C I D E N T S |  | M A L A L T I A |  | Amb |  | TOTAL | TOTAL | % FALTES PER | NUM. D'
 | D'ESPE |  |  | AL CENTRE |  | IN ITINERE |  | LABORALS |  | COMÚ |  | Insp. | ALTRES | DIES | DIES | ACCIDENTS | ACCIDENTS
OR | CIALITAT | LLINATGES | NOMS | Lleu | Greu | Lleu | Greu | Amb baixa | Sense baixa | Amb baixa | Sense baixa | Mèd. |  | DE   BAIXA | D'ASSISTÈNCIA | LABORALS | LABORALS
1 | ARMD01ET |  |  | 1 |  |  |  | 3 |  |  | 1 | s/n | 2 | 6 | 14 | 15 | 1
2
3
4
5
6
7
8
1 | [NAME]
2
3
4
5
6
7
8
 |  |  | TOTALES | 1 | 0 | 0 |  | 3 | 0 | 0 | 1 | 0 | 2 | 6 | 14 | 15 | 1
 |  | PEL TALLER D'OCUPACIÓ
 |  | El/La directora/a del taller d'ocupació |  |  |  |  |  | El/s docent/s del taller d'ocupació |  |  |  |  |  | PER L'ADMINISTRACIÓ
 |  |  |  |  |  |  |  |  |  |  |  |  |  | El cap de la Secció
 |  | (signatura i segell) |  |  |  |  |  |  |  |  |  |  |  | (signatura)
 |  |  |  | Palma, a __  de  __________ de 2008
Spreadsheet: 160221d1339010237-dependent-drop-down-list-wage-comparison-v1-modified-by-tigeravatar-
Sheet: Projects

project | D.O. | project_desc | Project Issued Date
660000201 |  | [NAME], B11410 | 2011-08-09 00:00:00
660000227 | 2271 | Range Control Building | 2011-09-20 00:00:00
660000240 | 2258 | Repairs to R&R Club, Bldg 3650 | 2011-06-30 00:00:00
660000261 | 2330 | Repairs to PWD Fac, B11430 | 2012-04-25 00:00:00
660000263 | 2279 | Golf Course Parking Lot | 2011-09-21 00:00:00
660000274 | 2290 | Construct Fuel Cntainmnt Area2 | 2011-09-27 00:00:00
660000276 | 2272 | Construct Family Life Center | 2011-09-08 00:00:00
660000287 | 283 | B-Wing HVAC, Building 12500 | 2011-09-29 00:00:00
660000289 | 2270 | CRAC Unit [NAME] 1109 | 2011-09-12 00:00:00
660000302 | 2263 | Construct Range Access Ctrl Pt | 2011-08-09 00:00:00
660000308 | 2274 | Repair 1st Floor Offices B6022 | 2011-09-27 00:00:00
660000317 | 2267 | Construct Ordnance Courts | 2011-08-17 00:00:00
660000320 | 2286 | Install Doors, Bldg 2300 | 2011-09-22 00:00:00
660000324 | 2285 | Addition to QM Museum, B5218 | 2011-09-28 00:00:00
660000332 | 2269 | Renovate Building 9028 | 2011-08-17 00:00:00
660000336 | 2257 | Construct [NAME] | 2011-06-30 00:00:00
660000341 | 2266 | B6222 Base 4 (OPS) Facility | 2011-08-09 00:00:00
660000345 | 2309 | Construct Canopy, Bldg 6242 | 2011-09-29 00:00:00
660000348 | 2280 | Renovate Bathrooms, Bldg 9035 | 2011-09-21 00:00:00
660000351 | 2275 | Construct Office, Bldg 6242 | 2011-09-21 00:00:00
660000356 | 2262 | BOLC Training Facility | 2011-08-09 00:00:00
660000362 | 2256 | Construct Parking Lot, B1109 | 2011-06-23 00:00:00
660000363 | 2259 | Repair Bathrooms, Bldg 12504 | 2011-06-26 00:00:00
660000364 | 2281 | Barrier at Jackson Circle | 2011-09-30 00:00:00
660000365 | 2260 | [NAME] | 2011-07-27 00:00:00
660000366 | 2261 | ALU Parking Lot | 2011-07-27 00:00:00
660000367 | 2265 | Building 8150 Casework | 2011-08-03 00:00:00
660000369 | 2278 | Construct Bleacher Shelters | 2011-09-21 00:00:00
660000373 | 2316 | CH47 [NAME] | 2011-09-28 00:00:00
660000374 | 2292 | Equipment Storage Bldg & Reno | 2011-09-28 00:00:00
660000375 | 2277 | ACS Memorial Garden B9023 | 2011-09-21 00:00:00
660000376 | 2273 | Construct Pavilion Bldg 1109 | 2011-09-13 00:00:00
660000377 | 2276 | Construct 2 Pavilions ALU | 2011-09-21 00:00:00
660000384 | 2291 | Ordnance Reviewing Stand | 2011-09-29 00:00:00
660000386 | 2295 | Renovate DPTS, B1107 | 2011-09-29 00:00:00
660000387 | 2317 | Earthquake Damage Repairs | 2011-09-29 00:00:00
660000388 | 2284 | SCoE Reviewing Stand Cover | 2011-09-29 00:00:00
660000389 | 2287 | Renovate Book Office Space | 2011-09-27 00:00:00
660000390 | 2294 | Restroom-Data Adds, B17159 | 2011-09-29 00:00:00
660000391 | 2288 | Repairs to Building 8135 | 2011-09-22 00:00:00
660000392 | 2312 | Three-Sided Shelter | 2011-09-30 00:00:00
Spreadsheet: 881110d1729021911-calculating-number-of-winter-workdays-between-two-dats-calculator
Sheet: Man Hour Calculator

Quantity Calculator
Unload |  |  | Ea | Shake Out |  |  | Ea |  | Production Rates
Qty of Beams |  | 50 | Ea | Qty over 30 |  | 50 | Ea
Qty of Columns |  | 50 | Ea | Qty over 30 |  | 50 | Ea |  |  | Unload |  |  | 30 | Shake Out |  |  | 15
Pandecking |  | 50 | SqFt | Qty over 30 |  | 50 | SqFt |  |  | Erection Under 30 |  |  | 0.875 | Erection over 30 |  |  | 0.8
Qty of Studs |  | 50 | Ea | Qty over 30 |  | 50 | Ea |  |  | Decking under 30 |  |  | 90 | Decking over 30 |  |  | 75
Qty of Bolts |  | 50 | Ea | Qty over 30 |  | 50 | Ea |  |  | Welding Under 30 |  |  | 4 | Welding Over 30 |  |  | 3
Welding |  | 50 | LF | Qty over 30 |  | 50 | LF |  |  | Stud Welding Under 30 |  |  | 30 | Stud Welding Over 30 |  |  | 23
Wall Panels |  | 50 | Ea | Qty over 30 |  | 50 | Ea |  |  | [NAME] Up Under 30 |  |  | 16 | Bolt Up Over 30 |  |  | 12
[NAME] |  | 50 | Ea | Qty over 30 |  | 50 | Ea |  |  | Wall Panels Under 30 |  |  | 0.5 | Wall Panels Over 30 |  |  | 0.25
Total Units
Man Hours |  |  |  |  |  |  |  |  |  | [NAME] Under 30 |  |  | 0.5 | [NAME] Over 30 |  |  | 0.25
Unload |  |  |  | Shake Out |  |  |  |  |  | Plumbing |  |  | 1 | Plumbing over 30 |  |  | 1
Erection Under 30 |  |  |  | Erection over 30 |  |  |  |  |  | Misc |  |  | 1 | Misc Over 30 |  |  | 1
Decking under 30 |  |  |  | Decking over 30
Welding Under 30 |  |  |  | Welding Over 30
Stud Welding Under 30 |  |  |  | Stud Welding Over 30
[NAME] Up Under 30 |  |  |  | Bolt Up Over 30
Wall Panels Under 30 |  |  |  | Wall Panels Over 30
[NAME] Under 30 |  |  |  | [NAME] Over 30
Plumbing |  |  | 30 | Plumbing over 30 |  |  | 30
Misc |  |  | 30 | Misc Over 30 |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Period Start |  |  | Winter Start |  | 2024-11-01 00:00:00
Total Hours: |  |  |  | Winter Hours |  |  |  |  |  |  |  |  |  | Period End |  |  | Winter End |  | 2025-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Period Days
[NAME] |  | 1 | Ea | Onsite days |  |  | Days
Man hours per Day |  | 9 |  | Job Duration |  |  | Days
Work Days per Week |  | 6 |  | Schedule Duration |  |  | Weeks
 |  |  |  |  |  |  | Months |  |  |  |  |  |  |  |  |  | 1st Winter Start
Crew Hours Per Day |  |  |  | Start Date: | 2024-09-01 00:00:00 | End Date |  |  |  |  |  |  |  |  |  |  | last winter end
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No complete [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net working Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Composite [NAME]
Spreadsheet: 870554d1717056617-display-results-from-imported-csv-file-book1_csv
Sheet: <1760

Column4 | Column11 | Column12 | Column16 | Column32 | Column33 | Column36
1540 | 2313 | 4599 | 8480 | 0 | 0 | 0
1540 | 2313 | 4599 | 8480 | 10 | 10 | 1350
1540 | 2313 | 4599 | 8480 | 670 | 910 | 1425
1540 | 2313 | 4599 | 8480 | 1670 | 1910 | 1850
1540 | 2313 | 4599 | 8480 | 170 | 510 | 2900
1540 | 2313 | 4599 | 8480 | 160 | 360 | 3475
1100 | 2135 | 4456 | 5679 | 0 | 0 | 0
1100 | 2135 | 4456 | 5679 | 100 | 200 | 300
1100 | 2135 | 4456 | 5679 | 400 | 400 | 475
1100 | 2135 | 4456 | 5679 | 1550 | 1600 | 1000
1100 | 2135 | 4456 | 5679 | 550 | 700 | 1125
1100 | 2135 | 4456 | 5679 | 350 | 450 | 1175
1210 | 2204 | 4480 | 6358 | 700 | 320 | 0
1210 | 2204 | 4480 | 6358 | 50 | 0 | 75
1210 | 2204 | 4480 | 6358 | 250 | 110 | 150
1210 | 2204 | 4480 | 6358 | 300 | 120 | 275
1210 | 2204 | 4480 | 6358 | 0 | 10 | 600