tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680514d1591067881-reconfigure-table-results-client-detail-form-responses
Sheet: Form responses 1

STEP 1: RAW DATA
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 1 |  | [NAME]
STEP 2: ADD BLANK ROW BASED ON CELL VALUE [COLUMN G - NUMBER OF DEPENDANTS]
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 1 |  | [NAME]
STEP 3: DESIRED OUTPUT
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B.
Spreadsheet: 81237d1281476286-combining-columns-data-combining-columns
Sheet: Sheet1

 | b | c | d |  | Cumulative
2 | #N/A | #N/A | M-04SD |  | M-04SD
3 | #N/A | #N/A | #N/A |  | #N/A
4 | 9G7 | #N/A | #N/A |  | 9G7
5 | #N/A | #N/A | A-08 |  | A-08
6 | #N/A | #N/A | #N/A |  | #N/A
7 | 8I | #N/A | M-04USD |  | ?
8 | #N/A | 4RX | #N/A |  | 4RX
Spreadsheet: 121935d1316515795-excel-2007-solved-how-to-group-and-sort-data-forumxl-1-
Sheet: Sheet1

Chassis | Network Element Name | Slot No | Product ID | SNMP Name | Current Termination Milestone
jr1 | PN1 | Chassis | JP1 | CS1 | 1 Yr to Termination |  |  |  |  | total | terminated
jr1 | PN1 | 1 | JP2 | CS2 | 6 months to Termination |  |  |  | jr1
jr1 | PN1 | 1 | JP3 | CS3 |  |  |  |  | jr2
jr1 | PN1 | 2 | [NAME] | CS4 | Terminated |  |  |  | [NAME]
jr1 | PN1 | 3 | JP5 | CS5 | Terminated
jr1 | PN1 | 3 | JP6 | CS6 | 1 Yr to Termination
jr1 | PN1 | 4 | JP7 | CS7
jr1 | PN1 | 6 | JP8 | CS8
jr1 | PN1 | 7 | JP9 | CS9
jr1 | PN1 | 8 | JP10 | CS10 | Terminated
jr1 | PN1 | 8 | JP11 | CS11 | 1 Yr to Termination
jr1 | PN1 | 9 | [NAME] | CS12 | Terminated
jr1 | PN1 | 9 | [NAME] | CS13 | 1 Yr to Termination
jr2 | PN2 | Chassis | [NAME] | CS14 | 1 Yr to Termination
jr2 | PN2 | 1 | JP15 | CS15 | 6 months to Termination
jr2 | PN2 | 1 | JP16 | CS16
jr2 | PN2 | 2 | JP17 | CS17 | Terminated
jr2 | PN2 | 3 | JP18 | CS18 | Terminated
jr2 | PN2 | 6 | JP19 | CS19 | Terminated
jr2 | PN2 | 6 | [NAME] | CS20 | 1 Yr to Termination
jr2 | PN2 | 7 | JP21 | CS21 | Terminated
jr2 | PN2 | 7 | JP22 | CS22 | 1 Yr to Termination
jr2 | PN2 | 8 | JP23 | CS23 | Terminated
jr2 | PN2 | 8 | [NAME] | CS24 | 1 Yr to Termination
jr2 | PN2 | 9 | JP25 | CS25 | Terminated
jr2 | PN2 | 9 | JP26 | CS26 | 1 Yr to Termination
[NAME] | PN3 | Chassis | JP27 | CS27
[NAME] | PN3 | 1 | JP28 | CS28
[NAME] | PN3 | 2 | [NAME] | CS29
[NAME] | PN3 | 3 | JP30 | CS30
[NAME] | PN3 | 4 | JP31 | CS31
[NAME] | PN3 | 5 | JP32 | CS32
[NAME] | PN3 | 5 | JP33 | CS33
[NAME] | PN3 | 5 | JP34 | CS34
[NAME] | PN3 | 7 | [NAME] | CS35
[NAME] | PN3 | 7 | [NAME] | CS36
[NAME] | PN3 | 8 | JP37 | CS37
[NAME] | PN3 | 8 | JP38 | CS38
[NAME] | PN3 | 9 | JP39 | CS39
[NAME] | PN3 | 9 | [NAME] | CS40
Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: SpotRates

 |  |  |  |  |  | Prior Year Ending Spot: |  |  | 1.4539
 |  |  | Daily | MTD | Curr Day | Prior Month Average Spot |  |  | 1.483320689655173
 |  |  | Spot | Average | Mon. [NAME]
 |  |  | 1.5332
 |  |  | 1.531
 |  |  | 1.532
 |  |  |  |  |  |  | 1.522 | Oct 31/00
 |  |  | 1.53
 |  |  | 1.5332
 |  |  | 1.54
 |  |  | 1.548
 |  |  | 1.5412
 |  |  | 1.543
 |  |  | 1.5445
 |  |  | 1.553
 |  |  | 1.554
 |  |  | 1.5585
TODAY'S SPOT
Spreadsheet: 839589d1692103899-weekly-reporting-formula-check-jul_wk4-data_test-1-
Sheet: Hal

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 703441d1605003767-countif-range-of-cells-contains-text-from-column-a-countif-range
Sheet: Hoja1

 | Titular | Suplente | Banquillo |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Javier |  |  |  |  | Alboraya 0 - 0 Alzira | [NAME]
Mario |  |  |  |  | 13 Javier (P) | 1 Chover (P)
Dídac |  |  |  |  | 2 Mario | 2 Mario
PEPE |  |  |  |  | 3 Dídac | 3 Dídac  75'
Savall |  |  |  |  | 4 PEPE | 4 PEPE
 |  |  |  |  | 5 Savall (C) | 5 Savall (C)
 |  |  |  |  | 6 Victor | 6 Victor
 |  |  |  |  | 7 Sergio  85' | 7 Sergio
 |  |  |  |  | 8 Israel  71' | 8 Israel  56'
 |  |  |  |  | 9 [NAME]  71' | 9 [NAME]  67'
 |  |  |  |  | 10 Iker  75' | 10 Iker  75'
 |  |  |  |  | 11 Victor | 11 Victor
 |  |  |  |  | Suplentes | Suplentes
 |  |  |  |  |  | [NAME] "A"
 |  |  |  |  | 1 Chover | 12 Diego
 |  |  |  |  | 12 Diego | 13 Javier
 |  |  |  |  | 14 [NAME]75' | 14 Francesc
 |  |  |  |  | 15 Francesc | 15 Adrian  56'
 |  |  |  |  | 16 Adrian  71' | 16 Mario  67'
 |  |  |  |  | 17 Mario  85' | 17 [NAME]
 |  |  |  |  | 18 Miguel  71' | 18 [NAME]75'
 |  |  |  |  |  | 19 Sergio  75'
 |  |  |  |  |  | 20 Lucas
Spreadsheet: 78968d1279215515-display-data-from-pivot-table-display-data-from-pivot-table
Sheet: Data

 | Stock Exchange
 | Security | ISIN No. | Daily High | DATE
 | 182 Day Treasury Bill 15.01.10 - 16.07.10 | MT3200010580 | 994.926 | 2010-02-16 00:00:00
 | 182 Day Treasury Bill 15.01.10 - 16.07.10 | MT3200010580 | 998.418 | 2010-04-15 00:00:00
 | 182 Day Treasury Bill 15.01.10 - 16.07.10 | MT3200010580 | 998.737 | 2010-04-23 00:00:00
 | 3.6% MGS 2013 (IV) | MT0000011511 | 101.81 | 2010-01-06 00:00:00
 | 3.6% MGS 2013 (IV) | MT0000011511 | 101.74 | 2010-01-07 00:00:00
 | 3.6% MGS 2013 (IV) | MT0000011511 | 101.84 | 2010-01-13 00:00:00
 | 3.75% MGS 2015 (VI) FI May 10 | MT0000011636 | 104.06 | 2010-06-09 00:00:00
 | 3.75% MGS 2015 (VI) FI May 10 | MT0000011636 | 103.32 | 2010-06-23 00:00:00
 | 3.75% MGS 2015(VI) | MT0000011610 | 101.6 | 2010-03-09 00:00:00
 | 3.75% MGS 2015(VI) | MT0000011610 | 101.78 | 2010-03-15 00:00:00
 | 3.75% MGS 2015(VI) | MT0000011610 | 101.67 | 2010-03-16 00:00:00
 | 4% AX Investments Plc 2013 | MT0000081225 | 118 | 2010-04-15 00:00:00
 | 4% AX Investments Plc 2013 | MT0000081225 | 119 | 2010-05-31 00:00:00
 | 4% AX Investments Plc 2013 | MT0000081225 | 119 | 2010-06-14 00:00:00
 | 4.6% HSBC Bank Malta Plc € 2017 | MT0000031220 | 102.25 | 2010-01-04 00:00:00
 | 4.6% HSBC Bank Malta Plc € 2017 | MT0000031220 | 102.2 | 2010-01-05 00:00:00
 | 4.6% HSBC Bank Malta Plc € 2017 | MT0000031220 | 102 | 2010-01-06 00:00:00
 | 4.6% HSBC Bank Malta Plc € 2017 | MT0000031220 | 102.21 | 2010-01-07 00:00:00
 | 4.6% MGS 2020 (II) | MT0000011602 | 101.52 | 2010-01-15 00:00:00
 | 4.6% MGS 2020 (II) | MT0000011602 | 102 | 2010-01-22 00:00:00
 | 4.6% MGS 2020 (II) | MT0000011602 | 103.79 | 2010-04-16 00:00:00
 | 4.6% MGS 2020 (II) | MT0000011602 | 104.24 | 2010-04-19 00:00:00
 | 4.6% MGS 2020 (II) | MT0000011602 | 103.85 | 2010-04-30 00:00:00
 | 4.6% MGS 2020 (II) FI May 10 | MT0000011644 | 104.72 | 2010-06-09 00:00:00
 | 4.6% MGS 2020 (II) FI May 10 | MT0000011644 | 104.62 | 2010-06-10 00:00:00
 | 4.6% MGS 2020 (II) FI May 10 | MT0000011644 | 104.79 | 2010-07-02 00:00:00
 | 4.6% MGS 2020 (II) FI May 10 | MT0000011644 | 105 | 2010-07-07 00:00:00
 | 4.8% Bank of Valletta Plc Sub € 2020 | MT0000021270 | 102.5 | 2010-04-15 00:00:00
 | 4.8% Bank of Valletta Plc Sub € 2020 | MT0000021270 | 102.5 | 2010-04-16 00:00:00
 | 4.8% Bank of Valletta Plc Sub € 2020 | MT0000021270 | 102.49 | 2010-04-19 00:00:00
 | 4.8% MGS 2016 (II) | MT0000011149 | 105.13 | 2010-01-15 00:00:00
 | 4.8% MGS 2016 (II) | MT0000011149 | 105.29 | 2010-01-18 00:00:00
 | 4.8% MGS 2016 (II) | MT0000011149 | 105.48 | 2010-01-19 00:00:00
 | 4.8% MGS 2016 (II) | MT0000011149 | 105.73 | 2010-02-01 00:00:00
 | 4.8% MGS 2016 (II) | MT0000011149 | 105.51 | 2010-02-03 00:00:00
Spreadsheet: 806708d1669500792-extracting-and-reformating-data-from-pivot-table-efpivotvalues
Sheet: Data

5 AM
:00 | 05:00:00 |  |  | 05:00:00 | 05:15:00
:15 |  | 05:15:00 |  | 05:30:00 | 05:45:00
:30 | 05:30:00 |  |  | 06:00:00 | 06:14:00
:45 |  | 05:45:00
6 AM
:00 | 1
:14 |  | 1
:20 | 1
:34 |  | 1
:40 | 1
:54 |  | 1
7 AM
:00 | 1
:14 |  | 1
:20 | 1
:34 |  | 1
:40 | 1
:54 |  | 1
8 AM
:00 | 1
:14 |  | 1
:20 | 1
:34 |  | 1
:40 | 1
:54 |  | 1
9 AM
:00 | 1
:16 |  | 1
:24 | 1
:40 |  | 1
:48 | 1
10 AM
:04 |  | 1
:12 | 1
:30 |  | 1
:36 | 1
:53 | 1
:54 |  | 1
11 AM
:13 | 1
:14 |  | 1
:33 | 1
:34 |  | 1
:53 | 1
:54 |  | 1
12 PM
:13 | 1
:14 |  | 1
:33 | 1
:34 |  | 1
:53 | 1
:54 |  | 1
1 PM
:13 | 1
:14 |  | 1
:33 | 1
:34 |  | 1
:53 | 1
:54 |  | 1
2 PM
:11 | 1
:12 |  | 1
:31 | 1
:32 |  | 1
:51 | 1
:52 |  | 1
3 PM
:11 | 1
:12 |  | 1
:31 | 1
:32 |  | 1
:51 | 1
:52 |  | 1
4 PM
:11 | 1
:12 |  | 1
:31 | 1
:32 |  | 1
:51 | 1
:52 |  | 1
5 PM
:11 | 1
:12 |  | 1
:31 | 1
:32 |  | 1
:51 | 1
:52 |  | 1
6 PM
:15 | 1
:18 |  | 1
:39 | 1
:44 |  | 1
7 PM
:04 | 1
:10 |  | 1
:28 | 1
:34 |  | 1
:52 | 1
:58 |  | 1
8 PM
:16 | 1
:28 |  | 1
:58 |  | 1
9 PM
:01 | 1
:28 |  | 1
:33 | 1
:58 |  | 1
10 PM
:03 | 1
:28 |  | 1
:33 | 1
:58 |  | 1
11 PM
:04 | 1
:29 |  | 1
:34 | 1
12 AM
:09 | 1 | 1
:49 | 1 | 1
1 AM
:29 |  | 1
:33 | 1
Spreadsheet: 733461d1621588673-combining-the-data-from-different-cell-to-specific-cells-under-certain-condition-book3-trial-ans1
Sheet: Sheet1

 |  |  | a | b | c | a | q | w | e | r | w | x | y | z | a1 | b1 | c1 | d1 | a2 | b2 | c2 | d2 | a3 | b3 | c3 | d3 | a4 | b4 | c4 | d4
 |  |  | abca | bcaa | bcab | caab
Spreadsheet: 080bec70-b34c-42b7-9ada-aa07906c7155
Sheet: Noten B mit Es

Priv. | Archiv | Titel der Sammlung | Titel der Komposition | Nr. | Komponist | Arrangeur | [NAME] | Besetzung | Anmerkung | Einstufung
 |  | [NAME]. Jagdhorn | [NAME] zur "Begrüßung" 4 Es |  | [NAME] |  | Zimmermann | 4 F.Pl. + 4 Pf.Es |  | #
Es/535 |  |  | [NAME] |  | [NAME] |  |  | 3Pf.B+4Pf.Es+4Alph.F |  | #
Es/790 |  | Faszination Jagdmusik | Bess`ler Marsch (Es/B) |  | [NAME] |  | Eigenverlag | 3Pf.Es+2Pf.B |  | #
Es/790 |  | Faszination Jagdmusik | Festliche Entrada (Es/B) |  | [NAME] |  | Eigenverlag | 3Pf.Es+2Pf.B |  | #
[NAME] |  |  | Festliche Jagdhornklänge |  | Schreier Bernhard |  |  | 3Pf.Es+2Pf.B |  | #
Es/429 |  |  | [NAME] |  | [NAME] |  |  | 3Pl.+2Pf.+5 Pf.Es |  | #
Es/625 |  |  | [NAME] für B und Es-Hörner |  | [NAME] |  |  | 3Pl.+3Pf.+4 Pf.Es |  | #
ES/578 |  |  | Große Jagdhornfanfare |  | Banco Gerhart |  | [NAME] | 3FPl.+1PfB+4Es |  | #
Es/670 |  |  | Ich schieß den [NAME]... |  | [NAME] |  |  | 4 Pf.Es+ 3Fpl.+2Pf.[NAME] 1 Posaune |  | #
 |  | [NAME]. Jagdhorn | Jagdfanfare |  | [NAME] |  | Zimmermann | 4 F.Pl. + 4 Pf.Es |  | #
Es/650 |  |  | [NAME] |  | [NAME] |  |  | 4 Es+3FPl.+2Pf [NAME] gem Chor |  | #
Es/789 |  |  | [NAME] Freischütz" |  | Weber C.M.v. | [NAME] |  | 2Tp, 2Flgh.,2Baßflgh.,Tuba,4F,4Es,3FPl.2PfB |  | #
Es/651 |  |  | Muss i denn |  | Hayden Johann |  |  | 4 Es+3FPl.+2Pf B+ 1Tp. |  | #
Es/919 |  |  | Parforcejagdszenen aus "Jahreszeiten" |  | [NAME] | Arr.: [NAME] |  | 4 Waldh.F+ 4 Pfh.Es+3FPl.+2Pf.B |  | #
G/073 |  |  | [NAME] |  | [NAME] |  |  | 3Pl.+2Pf.+ 4Es |  | #
Es/299+309 |  | [NAME] | Waldhornklänge |  | Stiegler Karl |  | [NAME] | 4 + 4F | Suite in 5 Sätzen | #
Es/337 |  |  | Waldszenen |  | Kretz Andreas |  |  | ES u.B | mit [NAME] | #
Es/671 |  |  | Weinviertler-Mährische Treibjagd |  | [NAME] |  | Eigenverlag | 2FP,2 Pf.B,4 Pf.Es und Musikanten |  | #
Es/578 |  |  | [NAME] |  | Banco Gerhart |  | [NAME] | 3FPl.+1PfB+4Es |  | #
Spreadsheet: 26470d1218632027-counting-from-a-range-book1-3
Sheet: Sheet1

Score |  | Grid
181.7414490194256 |  | 0 to 40 | 0
176.3141651235341 |  | 41 to 60 | 3
174.4815161958279 |  | 61 to 80 | 7
161.6192845959932 |  | 81 to 90 | 10
160.9154834712577 |  | 100 and above | 29
158.413888370204
153.5829273045696
149.250823879274
147.4687265806715
145.9631662610809
143.3106780673812
141.2024194758702
127.7379625205712
127.6676353779941
126.7688679245283
125.7721522427405
121.9048940330849
116.3040663040663
116.0882712475069
115.5903544438576
113.1795885496742
111.6252934126063
110.4370519588164
109.5243197973805
108.835073254724
108.2644789738611
105.8802626308347
104.3998260855333
104.2238959319396
99.94594777203473
99.14728635956259
97.5121135548943
96.20231365877838
95.68437381600864
94.53107279194238
91.69127500693264
89.62532180477348
88.4649167257863
88.18791493950731
88.05985239106258
87.64766726550167
87.40639702178164
83.02814894842129
82.95946977889753
82.92604198916787
81.51948870285354
80.58531120912974
79.24203226938333
77.25132099530111
71.84094470069317
71.52157580914069
70.85505108846935
70.43440164459273
69.89382557092334
60.04420839959592
55.88896241762485
51.17412308338585
46.17945937646935
Spreadsheet: 111802d1308086969-making-calculations-based-on-dropdown-selection-dropdownscreatingformulae
Sheet: Policies and formulas

 |  | Factor | Deduction
Nebraska Fire Plus | prem-35 | 1 | 35
Alpha Cancer Plan | prem | 1 | 0
FaceCare | prem*0.95-30 | 0.95 | 30
NoseInsurance | prem-45 | 1 | 45
EarsSafe | prem-13.5 | 1 | 13.5
Spreadsheet: 102404d1300349455-select-worksheet-shorcuts-keyboard
Sheet: FuncKeyLst

 | Alone | Shift | Alt | Ctrl | Shft-Alt | Shft-Ctrl | Alt-Ctrl | Shft-Alt-Ctrl
F1 | Help | "What's This?" | [NAME] |  | New Workbk |  | Excel4 Macro
F2 | Edit active cell | Edit cell comment | Save As |  | Save |  | Open File | Print
F3 | Paste Name | Paste Function |  | Define Name |  | Create Names
F4 | Repeat Action | Repeat Find | Exit Excel | Close Window |  |  | Exit Excel | Exit Excel
F5 | Go To | "Find" dialog bx |  | Restore Win Sz.
F6 | Next Pane | Prior Pane |  | Next Workbook |  | Prior Workbook
F7 | Spelling |  |  | Move window
F8 | Extend Selection | Add to selection | Macro dialog bx | Resize Window
F9 | Calc all open wrkbks | Calc active wrkbk |  | Maximize wrkbk
[NAME] | Menu bar | Shortcut menu |  | Maximize window
F11 | Create Chart | New worksheet | VBA editor | Excel4 Macro
F12 | Save As | Save |  | Open |  | Print
 | Macros limit users to selected key in combination with either Ctrl or Ctrl-Shift
 | This corresponds to the blue and purple columns above.
 | So without distrubing the default-defined keyboard, and counting the blank cells in those columns
 | you still have 11key-combinations for storing macros using the function keys.
Spreadsheet: 866835d1713764351-false-result-from-deeply-nested-if-formula-financial-chart-example
Sheet: Proj A (3)

PoP Start | PoP End |  | Proj A |  |  |  |  |  |  |  |  |  |  | [NAME] length - revised
2022-08-10 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] length - existing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] length - saving
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CFY
Delete those dates that do not align to any data |  |  | Placeholder, change formula when ready | Placeholder, change formula when ready | fix top formula by deleting +REF! | fix top formula by deleting +REF! | fix by choosing last cell visible in top formula | Placeholder, change formula when ready | Placeholder, change formula when ready
Month | FY Date of Occurrence | Qtr / FY Date of Occurrence | Contracted / Obligated | Expenditures | Obligated | Expended | Unexpended | APPN | APPN FY | APPN Life | Period of Availability | APPN Status | Column1
2022-08-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2022-09-30 00:00:00 |  |  |  | 0
2022-10-31 00:00:00 |  |  |  | 0
2022-11-30 00:00:00 |  |  |  | 0
2022-12-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2023-01-31 00:00:00 |  |  |  | 0
2023-02-28 00:00:00 |  |  |  | 0
2023-03-31 00:00:00 |  |  |  | 0
2023-04-30 00:00:00 |  |  |  | 1137451.26
2023-05-31 00:00:00 |  |  |  | 1137451.25 |  |  |  | RDT&E
2023-06-30 00:00:00 |  |  |  | 0
2023-07-31 00:00:00 |  |  |  | 0 |  |  |  | O&M
2023-08-31 00:00:00 |  |  |  | 1549976.48 |  |  |  | RDT&E
2023-09-30 00:00:00 |  |  |  | 774988.24 |  |  |  | RDT&E
2023-10-31 00:00:00 |  |  |  | 853594.67
2023-11-30 00:00:00 |  |  |  | 869410.28 |  |  |  | RDT&E
2023-12-31 00:00:00 |  |  |  |  |  |  |  | RDT&E
2024-01-31 00:00:00 |  |  |  | 1707189.33
2024-02-29 00:00:00
2024-03-31 00:00:00
2024-04-30 00:00:00
2024-05-31 00:00:00
2024-06-30 00:00:00
2024-07-31 00:00:00
2024-08-31 00:00:00
2024-09-30 00:00:00
2024-10-31 00:00:00
2024-11-30 00:00:00
2024-12-31 00:00:00
Spreadsheet: 120077d1314965833-lookup-formula-that-evaluates-two-criteria-book2
Sheet: data test

choose org | AA
 | Sept to populate
Projects Total
General Projects
Project number one
Project number one A
Project number one B
Project number one C
Project number one D
Project number one E
Project number one F
Project number one G
Project number one Sub 1
Project number one Sub 1 A
Project number one Sub 1 b
Project number one Sub 1 C
Project number one Sub 2
Project number one Sub 2 A
Project number one Sub 2 B
Project number one Sub 2 C
Project number one Sub 3
Project number one Sub 3 A
Project number one Sub 3 B
Project number two
Project number three
Project number three A
Project number three B
Project number three C
Project number three D
Project number four
Project number five
Project number six
Project number six A
Specific Projects
Project number seven
Project number eight
Project number eight A
Project number eight B
Project number eight C
Project number nine
Project number nine A
Project number nine B
Project number ten
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: 1240SF 2Sty

TWO STORY DUPLEX PLAN D:  3 Bedroom, 2 1/2 Bath, 1240 SF
Descriptions | Qty. | Unit | Unit Cost | Unit Total | Per SF | Unit Total W/Ovrhd | Per SF
Area Calculations: |  |  |  | Masonry |  |  | S.F.
Heated Area: |  |  |  | Foundation |  |  | S.F.
Lower Level | 473 | S.F. |  | Flatwork
Upper Level |  | S.F. |  | Patio |  |  | S.F.
Total Heated |  | S.F. |  | Second patio |  | 0
 |  |  |  | Walk
Other Covered Areas: |  |  |  | Driveway
Garage |  | S.F. |  | Windows |  | 9
Entry/Covd Porch |  | S.F. |  | Ext. Doors |  | 1
Total Other Covered |  | S.F. |  | Interior Doors |  | 9
Total Covered SF |  | S.F. |  | Const.Time |  |  | Months
Professional Services
Architectural | 0 | L.S.
Structural Engineering |  | S.F. | 0.15
Construction Surveying | 0 | L.S. | 315
Interior Design | 1 | L.S. | 0
Permits & Fees
Building Permits | 1 | L.S. | 150
Building Inspections | 1 | L.S. | 100
Utility Connections | 1 | L.S. | 0
Insurance
Builder's Risk |  | Mos.
General Liability | 1 | L.S. | 500
Temporary Utilities
Electricity |  | Mos. | 30
Water |  | Mos. | 30
Sanitary Facilities |  | Mos. | 10
Clean Up
Site Clean Up | 1 | L.S. | 750
Building Clean |  | S.F. | 0.1
Sitework
Environmental Controls | 0 | L.S. | 0
Lot Clear | 1 | Each | 150
Finish Grading | 1 | L.S. | 150
Sprinkler System | 1 | L.S. | 0
Landscaping | 1 | L.S. | 0
Privacy Fencing | 0 | L.F. | 15
Fence Gate | 0 | L.S. | 100
Concrete Work
Foundation |  | S.F. | 5.75
Underpinning | 1 | L.S. | 100
Flatwork |  | S.F. | 2
Driveway |  | S.F. | 2.25
Carpentry
Framing Materials |  | S.F. | 2.5
[NAME] |  | S.F. | 1.9
[NAME] |  | S.F. | 1.2
Framing Labor |  | S.F. | 3.5
Entry Door | 1 | L.S. | 285
Exterior Doors |  | LS | 285
Trim Materials |  | S.F. | 0.6
Interior Doors |  | DRS | 85
Trim Labor |  | S.F. | 0.6
Base Cabinets | 33 | L.F. | 60
Upper Cabinets | 16 | L.F. | 30
Glass & Mirrors
Windows |  | Wdws. | 85
Shower Enclosures | 0 | L.S. | 0
Mirrors | 36 | S.F. | 5
Moisture Protectors
Roofing & Flashing |  | SQS. | 52
Gutters | 1 | L.S. | 200
Insulation |  | S.F. | 0.75
Drywall |  | S.F. | 3
Masonry
Stone Veneer |  | S.F. | 5
Painting (Heated) |  | S.F. | 2
Painting (Covered) |  | S.F. | 0.6
[NAME] | 48 | S.F. | 5.5
Carpet & Vinyl |  | S.Y. | 15
Laminate Counters | 27 | L.F. | 24
Syn. Marble Counters | 9 | L.F. | 24
Syn. Marble Lavatories | 2 | Lavs | 40
Syn. Marble Tubs | 0 | Tub | 750
[NAME] | 1 | Tub | 300
Window Treatments |  | WDWS. | 35
F.P. Treatments | 0 | L.S. | 0
Specialties
Hardware | 1 | L.S. | 500
Metal Fireplaces | 0 | EA. | 650
Overhead Door & Openor | 1 | DRS. | 700
Electrical
Wiring & Panels |  | S.F. | 2.25
Fixtures | 1 | L.S. | 750
TV. Phone Prewire | 1 | L.S. | 150
Mechanical
Plumbing | 1 | L.S. | 4200
Laterals | 25 | L.F. | 15
Plumbing Fixtures | 1 | L.S. | 2000
Appliances | 1 | L.S. | 990
HVAC |  | L.S. | 2.85
Supervision |  | Mos.
TOTAL
Spreadsheet: 0999ffb6-c76d-45db-a584-682f22e14904
Sheet: Sheet1

 | x | y |  |  | x | y |  |  | x | y
A | 50 | 0 |  | B | 0 | 0 |  | C | 0 | 0
 | 50 | 100 |  |  | 100 | 80 |  |  | 10 | 10
 |  |  |  |  |  |  |  |  | 20 | 15
 |  |  |  |  |  |  |  |  | 25 | 30
 |  |  |  |  |  |  |  |  | 40 | 40
 |  |  |  |  |  |  |  |  | 55 | 60
 |  |  |  |  |  |  |  |  | 65 | 65
 |  |  |  |  |  |  |  |  | 85 | 80
 |  |  |  |  |  |  |  |  | 90 | 95
 |  |  |  |  |  |  |  |  | 100 | 100