tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123120d1317361921-separate-numbers-raceno-rework1
Sheet: Sheet1

Kyneton Raceguide - 29 September 2011
Track:  Showers. ([NAME]: 16)
1
TAB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
E14 | 14
E15 | 15
E16 | 16
E17 | 17
2
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
E14 | 14
3
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
14 | 14
E15 | 15
E16 | 16
E17 | 17
E18 | 18
4
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
E11 | 11
E12 | 12
[NAME] | 13
5
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
E11 | 11
E12 | 12
6
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
7
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
8
TAB | AB
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
E14 | 14
E15 | 15
E16 | 16
E17 | 17
Spreadsheet: 476121d1471622690-predictive-population-sample-book
Sheet: Draft Board

 |  |  |  | Team
 | Best Available |  |  | Total Spent
 | Rank | Player |  | Total Purse
 |  |  |  | Pick 1
 |  |  |  | Pick 2
 |  |  |  | Pick 3
 |  |  |  | Pick 4
 |  |  |  | Pick 5
 |  |  |  | Pick 6
 |  |  |  | Pick 7
 |  |  |  | Pick 8
 |  |  |  | Pick 9
 |  |  |  | Pick 10
 |  |  |  | Pick 11
 |  |  |  | Pick 12
 |  |  |  | Pick 13
 |  |  |  | Pick 14
 |  |  |  | Pick 15
 |  |  |  | Pick 16
 |  |  |  | Pick 17
 |  |  |  | Pick 18
 |  |  |  | [NAME] (this pick)
Spreadsheet: 37849d1235944868-conditional-formatting-k1
Sheet: xyz

PO No | Color | [NAME] | Original Delivery Date | Actual Delivery Date | Lab-Dip/Variant Termin | Approval Date | [NAME] | [NAME] Date | [NAME] | [NAME]
Sipariş No | Renk | Sipariş Adedi | Orjinal Yükleme [NAME] | Güncel Yükleme Tarihi | Lab-Dip/Varyant Termin | OK [NAME] | [NAME] Termin | [NAME] | [NAME] | [NAME] Kontrol Sonucu
5780 | 803 | 1628 | 2009-05-06 00:00:00 |  | 2009-03-07 00:00:00 |  | 2009-03-12 00:00:00 |  | 10.03.2009 11.03.2009 | N Y |  | 2009-03-10 00:00:00 | 2009-03-11 00:00:00
Spreadsheet: 181409d1348028863-mapping-data-from-multiple-rows-into-one-how_to_auto_map_live
Sheet: Admin-Reporting

Exchange rate USD/VND |  | 21800
Code | Account description |  |  | FORECAST
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
600000
600003
602005
610000
602000
600002
602010
601001
602002
602007
600006
602012
602023
602026
602008
602024
610011
610001 | T&E - Travel Local : Fares
610012
631014
603001
603004
603011
663002
634001
612001
612000
631006
631005
624000
611000
621002
611001
633008
631003
630001
621000
631007
623000
611003
650022
650021
650032
621200
650011
660000
621001
680002
625000
643000
640004
632007
640000
641000
633005
630006
691003
661400
602055
632008
694600
692000
620000
632004
640001
622001
602011
611002
 | TOTAL
Spreadsheet: 813721d1673956689-similar-values-if-function-vlookup-sample-2-
Sheet: Sheet3

 |  |  |  |  |  |  | Name |  |  | date |  | ID |  |  | Amount
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-31 00:00:00 | 0 | 121212 | 0 | 0 | 4363 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-31 00:00:00 | 0 | 636363 | 0 | 0 | 914 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-31 00:00:00 | 0 | 242424 | 0 | 0 | 807 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-31 00:00:00 | 0 | 323232 | 0 | 0 | 6717 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-31 00:00:00 | 0 | 121212 | 0 | 0 | 825 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-31 00:00:00 | 0 | 636363 | 0 | 0 | 937 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-31 00:00:00 | 0 | 242424 | 0 | 0 | 5795 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-31 00:00:00 | 0 | 121212 | 0 | 0 | 2492 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-31 00:00:00 | 0 | 636363 | 0 | 0 | 906 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-31 00:00:00 | 0 | 242424 | 0 | 0 | 382 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | Scott | 0 | 0 | 2023-01-31 00:00:00 | 0 | 121212 | 0 | 0 | 804 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | Scott | 0 | 0 | 2023-01-31 00:00:00 | 0 | 636363 | 0 | 0 | 937 | 0
Spreadsheet: 769570d1645605008-join-cells-in-different-columns-book1
Sheet: Table 1

 |  |  | Branch |  |  |  | Statement |  | Page
 |  |  |  |  |  |  |  |  | 1 of 336
 |  |  | Account Number |  |  |  | Currency
 |  |  |  |  |  |  | INR
 |  |  | Type of Account |  |  | Period
 |  |  | cdGold |  |  | 01-Apr-2021       -       31-Dec-2021
Date | Transaction |  |  | Debit | Credit |  |  | Balance |  |  | I need this
 | Opening Balance |  |  |  |  |  |  | 24,095.98 CR
2021-04-02 00:00:00 | CASHFREE PAYMENTS IN MB RefNo: 9281525 |  |  |  | 10 |  |  | 24,105.98 CR
 | IMPS [PHONE]
2021-04-02 00:00:00 | CASHFREE PAYMENTS IN MB RefNo: 9283261 |  |  |  | 319 |  |  | 24,424.98 CR
 | IMPS [PHONE]
2021-04-02 00:00:00 | Inward Clearing Payee CEREN  BUSINESS GROUP |  |  | 3690 |  |  |  | 10,220.98 CR
 | Presenting Bank:SOUTH INDIAN BANK L Inst Num
 | 104182
Spreadsheet: 880334d1727967187-help-with-percentile-function-percentile
Sheet: Sheet1

Name | Value | Grade (1-4) | Explanation of manual calculation | Grade (1-4) Automated |  | Percentile | Value | Grades |  | Excl 0
Random name 02 | 0 | 1 | Since the value is 0, the grade should be 1 |  |  | 0.15 |  | 1
Random name 04 | 0 | 1 | Since the value is 0, the grade should be 1 |  |  | 0.5 |  | 2
Random name 06 | 0 | 1 | Since the value is 0, the grade should be 1 |  |  | 0.85 |  | 3
Random name 14 | 0 | 1 | Since the value is 0, the grade should be 1 |  |  | 1 |  | 4
Random name 05 | 0.5 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 08 | 0.9 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 16 | 1.7 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 11 | 3.2 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 15 | 3.2 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 13 | 5.6 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 03 | 6.1 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 12 | 7.9 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 10 | 8.8 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 01 | 9.4 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 09 | 17.1 |  | I used Percentile formula for the values that are greater than 0 only.
Random name 07 | 35.6 |  | I used Percentile formula for the values that are greater than 0 only.
If the value in B column is 0, then the grade should be 1, for all the other values the grade should be based on percentile (the range of values for calculating percentile should include only the values which are greater than 0). In above solution I have to sort values, write some formula for values that are equal to 0 and another formula that are greater than 0. I need a solution that will work for all the values with the mentioned logic.
Spreadsheet: 805695d1668840192-highlight-cell-with-unique-number-based-off-vlookup-outcome-sample-sheet
Sheet: Output

Conversion |  | Tracker | Tracker-String | Date | Time | SP1 | SP2 | SP3 | SP4 | SP5 | SP6 | SP7 | SP8 | SP9 | SP10 | SP11 | SP12 | SP13 | SP14 | SP15 | SP16 | SP17 | SP18 | SP19 | SP20 | SP21 | SP22 | SP23 | SP24 | SP25 | SP26 | SP27 | SP28
 | 1024 | T1024 - 1
 | 1024 | T1024 - 2
 | 1024 | T1024 - 3
 | 1025 | T1025 - 1
 | 1025 | T1025 - 2
 | 1025 | T1025 - 3
Spreadsheet: 698776d1602170557-combining-formulas-indirect-and-lookup-and-vlookup-excel-indirect-lookup
Sheet: App4

Date | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Data9 | Data10
2020-10-05 00:00:00 | 6 | 3 | 6 | 6 | 0 | 5 | 5 | 3 | 3 | 4
2020-10-08 00:00:00 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 2 | 1 | 1
Spreadsheet: 69e90917-6570-426f-8748-0d0154f5cd4c
Sheet: Sheet1

nachrichtID | nachrichtTitel | sprache | land | datum | kurzBeschreibung | timeStamp | kurzMeldung | newsletter | quartalsUebersicht | verfallsDatum | email | url | status | user
1 | Buch: [NAME]: Krieg und Welt | ungarisch | [NAME] | 12.07.2012 [NAME] | Übersetzung | 11.19.2004 10:51:47 | Ja | [NAME] |  | 11.22.2222 [NAME] | [EMAIL] | www.doml.at | [NAME] | 1
2 | Literatur aktuell | deutsch | Albanien | 12.11.1111 00:00:00 | test | 11.19.2004 10:41:03 | [NAME] | [NAME] | [NAME] | 11.22.2222 [NAME] | [EMAIL] | www.doml.at | [NAME]
3 | Buchmesse in Warschau | polnisch | [NAME] | 11.29.2004 00:00:00 | Monika [NAME] und [NAME] ([NAME]) [NAME] über die XV Buchmesse in Warschau | 11.30.2004 12:46:43 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | [NAME] | [NAME]
4 | "Trufle" von Jan Grzegorczyk | polnisch | [NAME] | 11.29.2004 00:00:00 | Neuer Roman des Autors  "Adieu. Przypadki ksi&#281;dza Grosera" | 11.30.2004 13:21:33 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | http://serwisy.gazeta.pl/kultura/1,34169,2419159.html | [NAME]
5 | Zwei neue Bücher über Czes&#322;aw Mi&#322;osz | polnisch | [NAME] | 11.29.2004 00:00:00 | "W ogrodzie ziemskim. [NAME] i "Czes&#322;aw Mi&#322;osz in memoriam" | 11.30.2004 15:06:29 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | [NAME] | [NAME]
6 | [NAME] | polnisch | [NAME] | 11.28.2005 00:00:00 | Antologie der ukrainischen Poesie der Gegenwart auf Polnisch | 11.30.2004 13:34:40 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | http://serwisy.gazeta.pl/kultura/1,34169,2417320.html | [NAME]
7 | Ulitzkaja: „Russland wird zivilisiert – [NAME]!“ | deutsch | Albanien | 10.19.2012 00:00:00 | Ulitzkaja im [NAME] | 10.19.2012 00:00:00 | Ja | [NAME] | [NAME] | 04.19.2013 00:00:00 |  | http://diepresse.com/home/kultur/literatur/1302962/Ulitzkaja_Russland-wird-zivilisiert-oder-schreckl | [NAME]
Spreadsheet: 678055d1589693590-create-mail-labels-from-cell-string-example1704
Sheet: Sheet1

Original Data
114  Petworth RdDurranFalkirkKW14 7NB
40  Carriers RoadCrickardarnDundeeLD2 5NS
100  Circle WayCaergwrleWrexhamLL12 2EL
29  Newgate StreetJack HillMontroseLS22 3RE
25  Nith StreetGlascorieGlasgowAM351FZ
Spreadsheet: 05a2f97b-3ea1-44fa-abe9-97b1d9c3cd3e
Sheet: Sheet1

Impact Aid Program Survey Form
The survey date is __________________
STUDENT INFORMATION
Student’s Last Name | First Name |  | M.I. | Date of Birth | Grade | School Name
Address |  |  | City |  |  | State | Zip Code
If the above property is a federal property, enter the name of the property. |  | Name of federal property
PARENT/GUARDIAN EMPLOYMENT INFORMATION: CIVILIAN
Enter information in this section regarding the parent/guardian if 1) neither parent/guardian with whom the student resided was on active duty in the Uniformed Services of the United States and 2) either parent/guardian with whom the student resided was employed on federal property, or 3) either the parent/guardian reported to work on federal property on the survey date.  Enter the parent/guardian’s name as it appears on the employer’s payroll record.
Parent/Guardian’s Last Name | First Name and M.I. | Name of Parent/Guardian’s Employer
Address of Parent/Guardian’s Employer |  | City |  |  | State | Zip Code
Name of federal property
Address of federal property |  | City |  |  | State | Zip Code
PARENT/GUARDIAN EMPLOYMENT INFORMATION: UNIFORMED SERVICES
Enter information in this section regarding the parent/guardian if either person was on active duty in the Uniformed Services of the United States on the survey date.
Parent/Guardian’s Last Name | First Name and M.I. |  |  | Branch of Service |  | Rank
PARENT/GUARDIAN EMPLOYMENT INFORMATION: FOREIGN MILITARY
Enter information in this section regarding the parent/guardian if either person was both an accredited foreign government official and a foreign military officer on the survey date.
Parent/Guardian’s Last Name | First Name and M.I. |  |  | Branch of Service |  | Rank
Name of Foreign Government
PARENT/GUARDIAN EMPLOYMENT INFORMATION: FARMING, GRAZING, LUMBERING AND MINING
Enter information in this section if either the parent or guardian spent more than 50 percent of his or her working time on federal property (whether as an employee or self-employed) engaged in farming, grazing, lumbering or mining.
Parent/Guardian’s Last Name | First Name and M.I. | Name of Parent's/Guardian’s Employer
Address of Parent/Guardian’s Employer |  | City |  |  | State | Zip Code
Name of federal property |  | Address of federal property
This information is the basis for payment to your school district of federal funds under the Impact Aid Program (Title VIII of the Elementary and Secondary Education Act), and may be provided to the U.S. Department of Education if your school district’s application for payment is audited.  This form must be signed and dated for your school district to receive funds based on this information.
èSignature of Parent/Guardian_____________________________èDate____________
Spreadsheet: e3a2bb49-0e34-4e6a-acc0-a77bcc1b2e2d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
41005594 | 2014-04-15 20:53:37 | ALLIES | 1 | 6 | 5 | 1373296 | player1373296 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
41005898 | 2014-04-15 21:15:26 | AXIS | 0 | 4 | 6 | 1422784 | flarchi | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
41006192 | 2014-04-15 21:27:56 | ALLIES | 0 | 0 | 6 | 1422784 | flarchi | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
41006488 | 2014-04-15 21:48:48 | ALLIES | 0 | 5 | 6 | 1487332 | Freuden | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
41006701 | 2014-04-15 22:02:01 | AXIS | 1 | 6 | 4 | 1487332 | Freuden | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: New Albany

 | New Albany Generating Plant
 | 1514 County Road 126, New Albany, MS 38652
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | Home | [NAME]
 | Control Room 2 | [PHONE] |  | [NAME] | Plant Manager | [PHONE] | [PHONE]
 | Control Room Fax | [PHONE] |  | [NAME] | Maintenance Manager | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 1 | [PHONE] |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 2 | [PHONE] |  | [NAME] | Tech | [PHONE] |  | [PHONE] |  |  | TVA Switching Station | [PHONE]
 | On Call Cell Phone | [PHONE] |  | Garion Dillingham | Tech | [PHONE] | [PHONE] | [PHONE]
 |  |  |  | [NAME] | Tech | [PHONE] |  | [PHONE]
 | Neighboring Control Areas |  |  | [NAME] | Tech | [PHONE] |  | [PHONE]
 | TVA Security Coordinator | [PHONE] |  | [NAME] | Purchasing Agent | [PHONE] |  | [PHONE]
 | TVA Control Room | [PHONE]
 | TVA Transmission | [PHONE]
 | TVA FAX | [PHONE]
 | TVA Switching Station | [PHONE]
 | FAX | [PHONE]
 | Columbia Gulf Pipeline
 | Gas Control | [PHONE]
 | ECOLOCHEM
 | 24 Hour | [PHONE]
 | Emergency Numbers
 | Sheriff | [PHONE]
 | Ambulance (Union Hosp) | [PHONE]
Spreadsheet: 142239d1329748838-excel-2007-get-data-from-check-list-visual-inspection-for-toilets-excel-forum-2007-20-feb-2012-v1
Sheet: Toilet Check List

B | [NAME]
S/N | Description |  |  |  |  |  |  |  |  |  |  |  |  | Remarks
1 | Ceiling | MV Fan dusty |  | Speaker dusty
2 | Wall | Dirty |  | Stain |  | Crack |  | Title Pop-Up
3 | Floor | Dirty |  | Stain |  | Crack |  | Title Pop-Up |  | Wet Floor
4 | Lights | Ceiling Light Blown |  | Mirror light blown (Top) |  | Mirror light blown (Below)
5 | Basin Area | [NAME] and wet | 3 | Mirrors dirty |  | Taps dripping, dirty | 1 | Dirty | 1
6 | Hand towel dispenser | Dirty |  | Low Stock |  | Dusty
7 | [NAME] | Dirty |  | Not working |  | Dusty
8 | Urinal | Dirty |  | Not working
9 | Cubicle | Dirty |  | Wet floor |  | Mirror dirty |  | Lights in mirror down |  | Sensor not working |  | Flush not working
 |  | Toilet roll finish / low stock |  | Utility table |  | [NAME] door
10 | Shower Room | Items Missing |  | [NAME] not working
11 | Any Dusty Surfaces
12 | Door - Wooden | Door closing too fast/slow |  | [NAME] from Closer |  | Handle loose | 2 | Key Hole Cap Missing |  | Lockset Loose |  | Hindge Spoilt
 |  | Door panel damage |  | Door panel out of Alignment |  | Dirty
C | [NAME]
S/N | Description |  |  |  |  |  |  |  |  |  |  |  |  | Remarks
1 | Ceiling | MV Fan dusty |  | Speaker dusty
2 | Wall | Dirty |  | Stain |  | Crack |  | Title Pop-Up
3 | Floor | Dirty |  | Stain |  | Crack |  | Title Pop-Up |  | Wet Floor
4 | Lights | Ceiling Light Blown |  | Mirror light blown (Top) |  | Mirror light blown (Below)
5 | Basin Area | [NAME] and wet |  | Mirrors dirty |  | Taps dripping, dirty |  | Dirty
6 | Hand towel dispenser | Dirty |  | Low Stock |  | Dusty
7 | [NAME] | Dirty |  | Not working |  | Dusty
8 | Cubicle | Dirty |  | Wet floor |  | Mirror dirty |  | Lights in mirror down |  | Sensor not working |  | Flush not working
 |  | Toilet roll finish / low stock |  | Utility table |  | [NAME] full |  | Sanitary bags finish / low stock |  | [NAME]
9 | Shower Room | Items Missing |  | [NAME] not working |  | [NAME]
10 | Any Dusty Surfaces | Overall
11 | Door - Wooden | Door closing too fast/slow |  | [NAME] from Closer |  | Handle loose | 2 | Key Hole Cap Missing |  | Lockset Loose |  | Hindge Spoilt
 |  | Door panel damage |  | Door panel out of Alignment |  | Dirty
Spreadsheet: 770319d1645989521-how-to-convert-text-to-rows-report-filter-format-help
Sheet: Desired Report Format

RO # | RO-DATE | WIDATE-CAT | CWI-FLAG | ADV-NO | MISC-CODE | CODE-AMT | JOB# | OPERATION CODE
Spreadsheet: 185798e4-ca51-4980-9b68-753451d9f05d
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 17. COMMERCIAL FINANCE COMMITMENTS, Fixed Loans By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414226J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414227K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414228L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414229R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414230X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2414231A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414232C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2414233F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414234J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414235K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414236L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414237R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414238T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL FIXED LOANS ; |  |  | Original | A2414239V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 757186d1638098220-how-to-use-let-formula-to-complete-the-effect-of-e-f-column-forumhelp_11-28
Sheet: Sheet1

Name | Type |  |  | Name | Type
zucca | Type1 |  |  |  |  |  |  |  | Type1、Type4、Type10
hellen | Type2 |  |  | hellen |  |  |  | hellen | Type2、Type8
dee | [NAME] |  |  | dee |  |  |  | dee | Type3、Type7
zucca | Type4 |  |  | [NAME] |  |  |  | [NAME] | Type5
[NAME] | Type5 |  |  | cheves |  |  |  | cheves | Type6
cheves | Type6
dee | Type7 |  |  |  | Type6
hellen | Type8 |  |  | dee | Type3、Type7
zucca | Type1 |  |  | hellen | Type2、Type8
zucca | Type10 |  |  | [NAME] | Type5
 |  |  |  | zucca | Type1、Type4、Type10
Spreadsheet: 823236d1679830745-divide-sum-of-column-with-fixed-value-in-power-pivot-excel-power-pivot-question
Sheet: NORTH STAR_PMO

 | 168 | 184 | 176 | 176 | 176 | 176
DEVELOPMENT COST NORTH STAR A22/005
AK EMMI Department | 1. julij 2022 | 1. avgust 2022 | 1. september 2022 | 1. oktober 2022 | 1. november 2022 | 1. december 2022 | TOTAL
PMO
PURCHASE
SALES
QS
R&D
LOGISTIC
Production TECHOLOGY
Production START
Bussiness trevel | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Per diem | 500 | 500 | 500 | 500 | 500 | 500
TOTAL
DEVELOPMENT TIMELINE NORTH STAR A22/005
AK EMMI Department | 1. julij 2022 | 1. avgust 2022 | 1. september 2022 | 1. oktober 2022 | 1. november 2022 | 1. december 2022 | TOTAL
PMO
PURCHASE
SALES
QS
R&D
LOGISTIC
Production TECHOLOGY
Production START
Bussiness trevel
Per diem
TOTAL
ONE TIME COSTS   PROJECT NORTH STAR
ONE TIME COSTS NORTH STAR | 1st Offer | 2nd Offer | Nomination | Planned | Real | Delta | Status
Extrusion tool | 129000 | 71000
CNC fixtures | 164000 | 31500
Pressing tool | 260000 | 70000
Bending tool | 60000 | 16700
Prototype price per piece | 13520 | 1464.74
Material | 11150 | 11150
Material order MOQ (500kg) | 26000 | 26000
TOTAL Prototypes price (25pcs) | 338017 | 36625
TOTAL
PROJECT NORTH STAR TOTAL COSTS
COSTS NORTH STAR | 1st Offer | 2nd Offer | Nomination | Planned | Real | Delta | Status
Development
One time cost
TOTAL Prototypes price (25pcs)
Material order delta
TOTAL PROJECT COSTS